File Manager

✏️ Edit File: /home/rla105zs937x/public_html/marutitechnologies.in/admin/yearlywages_pdf.php

<?php 
	include("config.php");
 require_once("dompdf/dompdf_config.inc.php");
	$ccode=trim($_REQUEST['ccode']);
	$cname=trim($_REQUEST['cname']);
	
	
	$qry="where `company_code`='$ccode' ";
	
	$year=trim($_REQUEST['year']);
	$year1=$year+1;
	$string = 'JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC';
	$array = explode(',', $string);
	$sql2=mysqli_query($conn,"select * from `company_register` where `company_code`='$ccode' and `company_name`='$cname'");
	$query=mysqli_fetch_array($sql2);
	
	
	$str= "select * from `members` $qry";
	$sql=mysqli_query($conn,"select * from `members` $qry");
	
	$html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style>body{margin:20px;},table, th, td {width:100%; border: 1px solid black; border-collapse: collapse;text-align:center;font-size:7px;}</style></head><body>';
 $html.='<div>Yearly Wages 
	<hr style="margin-top:-10px;">(1) Estb. Name: '.$query["company_name"].' 
	(2) Estb. Code: :'.$query['regien_code'].' 
	(2) Year :	 March-'.$year.' TO February -'.$year1.' 
	
	<table>
	<tr><td>sno</td><td>PF No.</td><td>Name of the Employee</td><td>MAR	</td><td>APR</td><td>May</td><td>JUN</td><td>JUL</td> <td> AUG</td><td>SEP</td><td>OCT</td><td>NOV</td><td>DEC</td><td>JAN</td> <td> FEB</td><td>Arr</td><td>Total</td> <td>EE</td> <td>PF</td><td>VPF</td> <td> ER</td><td>Admin</td> <td> Total</td></tr>
	<tr><td>EPF difference between 12% and 8.33 %</td><td>Pension fund 8.33%</td></tr>';
	$rows=mysqli_num_rows($sql);
	$sno=0; $gtwages=0;$gtepf1=0;$gtepf2=0;$gteps=0;
	while ($row = mysqli_fetch_array($sql)) 
	{
 $twages=0; $tm=0;$tepf1=0;$tepf2=0;$teps=0;$tlop=0;$t6=0;$t7=0;
		$uan=$row['uan'];
		$pfid=$row['pfmember_id'];
		$employee_name=$row['employee_name'];
		
		$sno++;$s=0;
		
		for($i=4;$i<=12;$i++)
		{
			$tm++;
			
			$k=$i-2;
			$wmonth='02-0'.$i.'-'.$year;
			$str="select * from `ecr` where `ccode`='$ccode' and `wmonth`='$wmonth'";
			$sql1=mysqli_query($conn,$str);
			while ($query=mysqli_fetch_array($sql1))
			{
				$ecrname = $query['ecrfile'];
			}
			//header info for browser
			$rows1=mysqli_num_rows($sql1);
			if($rows1>0)
			{
				header("Pragma: no-cache"); 
				header("Expires: 0");
				$content = file_get_contents('ECR_File/'.$ecrname.'.txt');
				$lines = explode("\n", $content); // TAKING NEW ROW BY ' \n '
				$rcount= count($lines);
				foreach ($lines as $line) {
					
					
					$row = explode("#~#", $line); //IN TEXT FILE COLUMN IS SEPARATED BY ' : '
					$schema_insert = "";
					if($uan==$row[0])
					{	$s=1;
						$twages=$twages+$row[3];
						$tm=$row[3];
						$teps=$teps+$row[4];
					}
					
				}
			}
			
		}
		for($i=1;$i<=3;$i++)
		{
			$tm++;
			$year1=$year+1;
			if($i==1)
			{
			$k=11;
			}
			else
			{
			$k=$i-2;
			}
			$wmonth='02-0'.$i.'-'.$year1;
			$sql1=mysqli_query($conn,"select * from `ecr` where `ccode`='$ccode' and `wmonth`='$wmonth'");
			$query=mysqli_fetch_array($sql1);
			while ($query=mysqli_fetch_array($sql1))
			{
				$ecrname = $query['ecrfile'];
			}
			$rows1=mysqli_num_rows($sql1);
			if($rows1>0)
			{
				header("Pragma: no-cache"); 
				header("Expires: 0");
				//start of printing column names as names of MySQL fields
				$content = file_get_contents('ECR_File/'.$ecrname.'.txt');
				$lines = explode("\n", $content); // TAKING NEW ROW BY ' \n '
				$rcount= count($lines);
				
				
				foreach ($lines as $line) {
					
					$row = explode("#~#", $line); //IN TEXT FILE COLUMN IS SEPARATED BY ' : '
					$schema_insert = "";
					if($uan==$row[0])
					{
						$s=1;
						$twages=$twages+$row[3];
						$teps=$teps+$row[4];
						$tm=$row[3];
					}
				}
				
			}
			
		}
		$gtwages=$gtwages+$twages;
		$ee=$twages*0.12;
		$pf=$twages*0.083;
		$er=$twages*0.037;
		$wmonth='02-04-'.$year;
		$wmonth1=date('Y-m-d', strtotime($wmonth));
		$sql_cn2 = mysqli_query($conn,"SELECT * FROM wages where sdate1 <='".$wmonth1."' and edate1 >='".$wmonth1."' ");
		$qr_cn2 = mysqli_fetch_array($sql_cn2);
		$ac2 = $qr_cn2['acc2']/100;
		$ac2min = $qr_cn2['acc2min'];
		$acc2=round($teps*$ac2);
			if($acc2>=$ac2min)
			{
				$acc2 = $acc2;
			}
			else
			{
				$acc2 =$ac2min;
			}
		$tot=$ee+$pf+$er+$acc2;
		
		$html.='
		<tr><td>'.$sno.'</td><td>'.$pfid.'</td><td>'.$employee_name.'</td><td>'.$twages.'</td><td>'.$twages.'</td><td>'.$twages.'</td><td>'.$twages.'</td><td>'.$twages.'</td><td>'.$twages.'</td><td'.$twages.'></td><td>'.$twages.'</td><td>'.$twages.'</td><td'.$twages.'></td><td>'.$twages.'</td><td>'.$twages.'</td><td'.$twages.'></td><td>'.$ee.'</td><td>'.$pf.'</td><td>0</td><td>'.$er.'</td><td>'.$acc2.'</td><td'.$tot.'></td></tr>';
		
		
	}
	$html.= '</table> Signature of the Employer with Office Seal </body></html>';
 $dompdf = new DOMPDF(); 
 $dompdf->load_html($html);
 $dompdf->render();
 $pdf = $dompdf->output();
 $dompdf->stream("FORM6A_TN".$ccode.".pdf", array("Attachment" => false));
	
?>

Batal

⬅ Naik ke marutitechnologies.in 92 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁ECR_File	dir	—	2026-07-18 11:41	📂 Buka
📁Register_file	dir	—	2024-12-12 15:38	📂 Buka
📁assets	dir	—	2020-06-13 06:04	📂 Buka
📁dompdf	dir	—	2018-12-18 19:28	📂 Buka
📁file	dir	—	2022-04-26 10:23	📂 Buka
📁images	dir	—	2021-03-02 06:37	📂 Buka
📁img	dir	—	2018-04-23 07:56	📂 Buka
🐘activemember.php	php	7.8 KB	2021-10-12 09:20	✏️ Edit 👁️ View
🐘add_company.php	php	11.1 KB	2021-10-12 09:21	✏️ Edit 👁️ View
🐘add_eps.php	php	3.6 KB	2021-10-12 09:21	✏️ Edit 👁️ View
📝add_eps.txt	txt	4.2 KB	2017-05-05 10:54	✏️ Edit 👁️ View
🐘add_member.php	php	12.1 KB	2021-10-12 09:21	✏️ Edit 👁️ View
🐘add_wages.php	php	4.3 KB	2017-05-08 12:13	✏️ Edit 👁️ View
🐘ajax_company.php	php	507 B	2018-04-05 12:37	✏️ Edit 👁️ View
🐘claim.php	php	5 KB	2021-10-12 09:22	✏️ Edit 👁️ View
🐘claimdoc.php	php	7.9 KB	2021-10-12 09:22	✏️ Edit 👁️ View
🐘claimupload.php	php	8.2 KB	2021-10-12 09:23	✏️ Edit 👁️ View
🐘class (2).php	php	27.6 KB	2018-03-09 06:50	✏️ Edit 👁️ View
🐘class.php	php	28.1 KB	2026-02-04 06:52	✏️ Edit 👁️ View
🐘class1.php	php	8.6 KB	2022-01-24 11:19	✏️ Edit 👁️ View
🐘class_13-06-20.php	php	28.3 KB	2018-04-27 07:18	✏️ Edit 👁️ View
📜clockh.js	js	5.2 KB	2010-06-02 09:16	✏️ Edit 👁️ View
📜clockp.js	js	635 B	2010-06-02 09:17	✏️ Edit 👁️ View
🐘config.php	php	123 B	2022-08-18 11:09	✏️ Edit 👁️ View
🐘contact.php	php	2 KB	2021-10-12 09:23	✏️ Edit 👁️ View
🌐datepicker.html	html	561 B	2017-05-08 09:12	✏️ Edit 👁️ View
📝datepicker.txt	txt	677 B	2017-05-08 09:10	✏️ Edit 👁️ View
📜ddaccordion.js	js	12.2 KB	2010-06-01 07:33	✏️ Edit 👁️ View
🐘downloadpayslip.php	php	2.2 KB	2018-04-06 07:56	✏️ Edit 👁️ View
🐘ecr_download.php	php	3.4 KB	2018-04-06 07:36	✏️ Edit 👁️ View
🐘ecr_errdownload.php	php	2.9 KB	2021-10-12 09:24	✏️ Edit 👁️ View
🐘ecrupload.php	php	7.3 KB	2021-10-12 09:24	✏️ Edit 👁️ View
🐘edit_company.php	php	16.1 KB	2018-04-24 06:59	✏️ Edit 👁️ View
🐘edit_eps.php	php	4 KB	2021-10-12 09:24	✏️ Edit 👁️ View
🐘edit_member.php	php	14 KB	2021-10-12 09:24	✏️ Edit 👁️ View
🐘edit_wages.php	php	4.7 KB	2021-10-12 09:25	✏️ Edit 👁️ View
🐘employee.php	php	4.8 KB	2021-10-12 09:25	✏️ Edit 👁️ View
🐘employer.php	php	4.7 KB	2021-10-12 09:25	✏️ Edit 👁️ View
📄error_log	file	937.6 KB	2026-03-14 12:20	✏️ Edit 👁️ View
🐘form3a1_pdf.php	php	7 KB	2021-10-12 09:25	✏️ Edit 👁️ View
🐘form3a_pdf.php	php	9.2 KB	2018-05-08 11:59	✏️ Edit 👁️ View
🐘form6a_pdf.php	php	5.3 KB	2021-10-12 09:26	✏️ Edit 👁️ View
🐘header.php	php	3.3 KB	2025-09-02 16:15	✏️ Edit 👁️ View
🐘home.php	php	3.7 KB	2021-10-12 09:19	✏️ Edit 👁️ View
🌐index-digital.html	html	10 KB	2017-04-05 10:42	✏️ Edit 👁️ View
🐘index.php	php	4.7 KB	2026-02-04 06:48	✏️ Edit 👁️ View
🌐index_html.html	html	23.8 KB	2010-06-08 07:46	✏️ Edit 👁️ View
📜jconfirmaction.jquery.js	js	1.2 KB	2010-03-27 09:37	✏️ Edit 👁️ View
📜jquery-1.4.2.min.js	js	70.5 KB	2010-02-22 18:17	✏️ Edit 👁️ View
📝jquery.jclock-1.2.0.js.txt	txt	2.7 KB	2010-06-08 08:49	✏️ Edit 👁️ View
📜jquery.min.js	js	55.9 KB	2010-06-01 07:33	✏️ Edit 👁️ View
📝license.txt	txt	15 KB	2008-01-30 01:33	✏️ Edit 👁️ View
🌐login.html	html	4.3 KB	2017-04-05 10:15	✏️ Edit 👁️ View
🐘logout.php	php	81 B	2021-03-02 05:59	✏️ Edit 👁️ View
🐘memberbulk.php	php	5.4 KB	2018-04-21 13:00	✏️ Edit 👁️ View
🐘menu.php	php	4.3 KB	2018-09-12 07:42	✏️ Edit 👁️ View
🐘monthlywages_pdf.php	php	6.2 KB	2020-06-13 09:16	✏️ Edit 👁️ View
🐘newexcel.php	php	3.5 KB	2022-01-27 06:23	✏️ Edit 👁️ View
🎨niceforms-default.css	css	5.8 KB	2010-06-08 07:21	✏️ Edit 👁️ View
📜niceforms.js	js	14.3 KB	2017-05-11 08:23	✏️ Edit 👁️ View
🐘payroll.php	php	7.9 KB	2021-10-12 09:28	✏️ Edit 👁️ View
🐘payrolldownload.php	php	2.2 KB	2018-04-05 12:49	✏️ Edit 👁️ View
🐘payslip.php	php	7.9 KB	2021-10-12 09:28	✏️ Edit 👁️ View
🐘pdf.php	php	1.2 KB	2018-04-20 11:14	✏️ Edit 👁️ View
🐘pdf_claim.php	php	6.1 KB	2021-10-12 09:29	✏️ Edit 👁️ View
🐘pdf_claim1 - Copy.php	php	7.9 KB	2017-09-25 12:32	✏️ Edit 👁️ View
🐘pdf_claim1.php	php	7.9 KB	2017-09-25 12:32	✏️ Edit 👁️ View
🐘pdf_claim_new.php	php	6 KB	2018-04-27 07:25	✏️ Edit 👁️ View
🐘pdf_uploadclaim.php	php	6.3 KB	2021-10-12 09:29	✏️ Edit 👁️ View
🐘registerbulk.php	php	5.6 KB	2018-04-05 12:50	✏️ Edit 👁️ View
🐘registerbulk_success.php	php	2.5 KB	2021-10-12 09:30	✏️ Edit 👁️ View
🐘report_form3a.php	php	11.7 KB	2021-10-12 09:30	✏️ Edit 👁️ View
🐘report_form6a.php	php	4.4 KB	2021-10-12 09:30	✏️ Edit 👁️ View
🐘report_monthly_wages.php	php	3.8 KB	2021-10-12 09:31	✏️ Edit 👁️ View
🐘report_yearlywages.php	php	4.4 KB	2021-10-12 09:31	✏️ Edit 👁️ View
🐘search_company.php	php	7.5 KB	2021-10-12 09:31	✏️ Edit 👁️ View
🐘search_member.php	php	10.2 KB	2021-10-12 09:31	✏️ Edit 👁️ View
🐘session.php	php	178 B	2021-10-12 05:40	✏️ Edit 👁️ View
🎨style.css	css	13.4 KB	2018-04-24 07:34	✏️ Edit 👁️ View
🐘upload_attentance.php	php	8.3 KB	2021-10-12 09:31	✏️ Edit 👁️ View
🐘view_claimreport.php	php	4.4 KB	2018-04-20 11:48	✏️ Edit 👁️ View
🐘view_claimreport_new.php	php	4.4 KB	2018-04-27 07:04	✏️ Edit 👁️ View
🐘view_claimreport_upload.php	php	4.4 KB	2018-09-26 09:35	✏️ Edit 👁️ View
🐘view_company.php	php	3.6 KB	2021-10-12 09:32	✏️ Edit 👁️ View
🐘view_companydetails.php	php	6.6 KB	2021-10-12 09:32	✏️ Edit 👁️ View
🐘view_ecrupload.php	php	4.9 KB	2022-01-27 06:37	✏️ Edit 👁️ View
🐘view_eps.php	php	3.4 KB	2021-10-12 09:33	✏️ Edit 👁️ View
🐘view_memberfile.php	php	4.4 KB	2021-10-12 09:33	✏️ Edit 👁️ View
🐘view_members.php	php	4.9 KB	2018-04-21 13:01	✏️ Edit 👁️ View
🐘view_register.php	php	7.9 KB	2021-10-12 09:33	✏️ Edit 👁️ View
🐘view_wages.php	php	3.8 KB	2021-10-12 09:33	✏️ Edit 👁️ View
🐘yearlywages_pdf.php	php	5.4 KB	2020-06-13 06:51	✏️ Edit 👁️ View