<?php
// Sets to unlimited period of time
ini_set('max_execution_time', 0);
?>
<?php



include("db.php");

$cmpid=1;
$fromdate='2022-10-01';
$todate='2022-10-31';
$branch_id=4;


  $sql="select  eb_no `Employee Code`,concat(worker_name,' ',last_name) `Employee Name`,per_bank_name `Bank Name`, per_bank_ac_no `Account No`,per_bank_ifsc `IFSC Code`, 
  AMOUNT `Net_Pay` from tbl_pay_period tpp,tbl_pay_employee_payroll tpep ,worker_master wm where tpp.company_id=$cmpid and tpp.branch_id=$branch_id 
  and from_date='$fromdate' and to_date='$todate' and tpp.status<>4 and is_active=1 and tpp.id=tpep.PAYPERIOD_ID and COMPONENT_ID=21 and tpep.EMPLOYEEID=wm.eb_id 
  order by eb_no
  ";
  $tamt=0;
  $resulta = $conn->query($sql);
  while($rowa = $resulta->fetch_assoc()) 
  {

//	$cmpn=$rowa["company_id"];
 
 echo $rowa["Employee Code"];

  $tamt=$tamt+$rowa["Net_Pay"];

 }
	 
	 echo $tamt;