File: /home/cafsindia/uds.cafsinfotech.in/application/controllers_bk/Wage_register.php
<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
require('./application/libraries/dompdf/autoload.inc.php');
use Dompdf\Dompdf;
class Wage_register extends Action_controller{
public function __construct(){
parent::__construct('wage_register');
}
// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
public function index(){
//PERSONAL AREA
$per_area_rslt = $this->query_build_function('personal_code,personal_name','cw_sap_personal_area','','trans_status = 1 and FIND_IN_SET(personal_code, "'.$this->logged_area_access.'") ');
$per_area_list = "";
foreach($per_area_rslt as $for){
$personal_code = $for['personal_code'];
$personal_name = $for['personal_name'];
if($personal_code !== ""){
$per_area_list .= "<option data-value='".$personal_code."' value='".trim($personal_code)."' >".trim($personal_name)."</option>";
}
}
$data['per_area_list'] = $per_area_list;
$data['encKey'] = $this->generateKey();
$this->load->view("$this->control_name/manage",$data);
}
//PROJECT ID FETCH BASED ON PERSONAL CODE & PROCESS MONTH
public function project_id_fetch(){
$encString = file_get_contents('php://input');
$_POST = $this->cryptoDecrypt($encString);
if(!$_POST){
echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
exit(0);
}
$personal_code = $this->input->post('personal_code');
$process_month = $this->input->post("process_month");
if($process_month){
$start_date = date("Y-m-d",strtotime('01-'.$process_month));
$end_date = date("Y-m-t",strtotime($start_date));
$month_qry = 'and cw_sap_project.pro_start_date <= "'.$start_date.'" and cw_sap_project.pro_end_date >= "'.$end_date.'"';
}
$pro_id_qry = 'SELECT pro_id,pro_desc FROM cw_sap_project WHERE cw_sap_project.pro_personal_area_id = "'.$personal_code.'" '.$month_qry.' and cw_sap_project.trans_status = 1';
$pro_id_info = $this->db->query("CALL sp_a_run('SELECT','$pro_id_qry')");
$pro_id_rslt = $pro_id_info->result_array();
$pro_id_info->next_result();
echo json_encode($pro_id_rslt);
}
public function wbs_id_fetch(){
$encString = file_get_contents('php://input');
$_POST = $this->cryptoDecrypt($encString);
if(!$_POST){
echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
exit(0);
}
$personal_code = $this->input->post('personal_code');
$project_id = $this->input->post('project_id');
$process_month = $this->input->post('process_month');
//FOR ACTIVE PROJECT ONLY SHOULD SHOW IN PICKLIST
if($process_month){
$start_date = date("Y-m-d",strtotime('01-'.$process_month));
$end_date = date("Y-m-t",strtotime($start_date));
$month_qry = 'and date_format(cw_pay_structure.from_date, "%Y-%m") <= date_format(str_to_date("01-'.$process_month.'", "%d-%m-%Y") , "%Y-%m") and date_format(cw_pay_structure.to_date, "%Y-%m") >= date_format(str_to_date("01-'.$process_month.'", "%d-%m-%Y") , "%Y-%m") and cw_sap_wbs.wbs_start_date <= "'.$start_date.'" and cw_sap_wbs.wbs_end_date >= "'.$end_date.'"';
}
$wbs_qry = 'select cw_sap_wbs.prime_sap_wbs_id,cw_sap_wbs.wbs_id,cw_sap_wbs.wbs_desc from cw_sap_wbs inner join cw_pay_structure on cw_pay_structure.wbs_element = cw_sap_wbs.wbs_id where cw_pay_structure.personal_code = "'.$personal_code.'" and cw_sap_wbs.wbs_personal_area_id = "'.$personal_code.'" '.$month_qry.' and cw_sap_wbs.wbs_project_id = "'.$project_id.'" and cw_sap_wbs.trans_status = 1 and cw_pay_structure.trans_status = 1 GROUP BY cw_sap_wbs.prime_sap_wbs_id';
// and cw_pay_structure.status = 1
$wbs_info = $this->db->query("CALL sp_a_run ('SELECT','$wbs_qry')");
$wbs_rslt = $wbs_info->result_array();
$wbs_info->next_result();
echo json_encode($wbs_rslt);
}
//ARREAR FRM AND TO MONTH FETCH BASED ON PER AREA AND PROJECT
public function get_month(){
$encString = file_get_contents('php://input');
$_POST = $this->cryptoDecrypt($encString);
if(!$_POST){
echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
exit(0);
}
$project_id = $this->input->post('project_id');
$personal_code = $this->input->post('personal_code');
$wbs_element = $this->input->post("wbs_element");
$wbs_element_val = implode('","',$wbs_element ?? []);
$get_month_qry = 'SELECT cw_arr_transactions.prime_arr_info_id,arr_from,arr_to,cw_arr_transactions.wbs_element FROM cw_arr_transactions INNER JOIN cw_sap_wbs ON cw_sap_wbs.wbs_id = cw_arr_transactions.wbs_element WHERE cw_arr_transactions.trans_status = 1 AND cw_sap_wbs.trans_status = 1 AND cw_arr_transactions.project_id = "'.$project_id.'" AND wbs_personal_area_id = "'.$personal_code.'" AND cw_arr_transactions.wbs_element in ("'.$wbs_element_val.'") ';
$get_month_info = $this->db->query("CALL sp_a_run ('SELECT','$get_month_qry')");
$get_month_rslt = $get_month_info->result_array();
$get_month_info->next_result();
foreach($get_month_rslt as &$dateRange){
$fromDate = DateTime::createFromFormat('m-Y', $dateRange['arr_from']);
$toDate = DateTime::createFromFormat('m-Y', $dateRange['arr_to']);
$dateRange['arr_from'] = $fromDate->format('M-Y');
$dateRange['arr_to'] = $toDate->format('M-Y');
}
if($get_month_rslt){
echo json_encode(array("success"=>TRUE,"wbs"=>$get_month_rslt));
}else{
echo json_encode(array("success"=>FALSE,"message"=>"No Records Found.!"));
}
}
//FILE GENERATE
public function wage_register(){
$encString = file_get_contents('php://input');
$_POST = $this->cryptoDecrypt($encString);
if(!$_POST){
echo json_encode(array('success' => false,'message' => 'Invalid Request..','table_data' => ""));
exit(0);
}
$wage_register = (int)$this->input->post('wage_register');
$process_month = $this->input->post('process_month');
$personal_code = $this->input->post('personal_code');
$project_id = $this->input->post('project_id');
$wbs_element = $this->input->post("wbs_element");
$wbs_element_val = implode('","',$wbs_element ?? []);
$wage_rules = (int)$this->input->post('wage_rules');
$personal_code_arr = array("1100" => "1100","1400" => "1400");
$misc_wbs_qry = "";
if($wage_register === 6){ // FOR MANUAL SALARY
$table_name = ' cw_transactions_fms_man ';
}else
if($wage_register === 7){ // FOR ARREAR
$table_name = ' cw_arr_transactions';
$id = $this->query_arr_trans($this->input->post("arr_month"));
$start_date = date("Y-m-d", strtotime('01-' . $id[0]->arr_from));
$end_date = date("Y-m-d", strtotime('01-' . $id[0]->arr_to));
$month_qry = 'AND DATE_FORMAT(STR_TO_DATE(CONCAT("01-",cw_arr_transactions.arr_from),"%d-%m-%Y"),"%Y-%m-%d") >= "'.$start_date.'" AND DATE_FORMAT(STR_TO_DATE(CONCAT("01-",cw_arr_transactions.arr_to),"%d-%m-%Y"),"%Y-%m-%d") <= "'.$end_date.'" ';
}else{
$table_name = ' cw_transactions_fms ';
}
//WBS IMPLODE
if($wbs_element_val){
$wbs_qry = ' AND '.$table_name.'.wbs_element IN ("'.$wbs_element_val.'") ';
if($wage_register === 3){ // FOR MISC
$misc_wbs_qry = ' AND cw_misc_input_fms.wbs_element IN ("'.$wbs_element_val.'") ';
}
}
//RETRIEVE PROJECT NAME BASED ON PROJECT ID
$project_qry = 'SELECT pro_desc FROM cw_sap_project WHERE cw_sap_project.trans_status = 1 AND cw_sap_project.pro_id = "'.$project_id.'" AND trans_status = 1';
$project_info = $this->db->query("CALL sp_a_run ('SELECT','$project_qry')");
$project_rslt = $project_info->result_array();
$project_info->next_result();
$project_name = $project_rslt[0]['pro_desc'];
//QUERY FOR DYNAMIC RULES AND FROM NUMBER -> FOR DISPLAY IN PDF
$rules_qry = 'SELECT rules,wage_form_no FROM cw_sap_personal_area WHERE personal_code ="'.$personal_code.'" AND trans_status = 1';
$rules_info = $this->db->query("CALL sp_a_run ('SELECT','$rules_qry')");
$rules_rslt = $rules_info->result_array();
$rules_info->next_result();
$cur_year = date('Y');
$start_mnth_year = '01-'.$cur_year;
$end_mnth_year = '12-'.$cur_year;
// QUERY FOR ARREAR DATA RETRIEVAL.
if($wage_register === 7){
// COLUMNS FROM ARREAR COLUMN MAPPING
$wage_qry = 'SELECT column_name,formula from cw_arrear_wage_mapping where trans_status = 1';
$wage_info = $this->db->query("CALL sp_a_run ('SELECT','$wage_qry')");
$wage_rslt = $wage_info->result_array();
$wage_info->next_result();
$expression = '';
$header_exp = '';
foreach($wage_rslt as $val){
$column_name = $val['column_name'];
$formula = $val['formula'];
$columns = explode('+', $formula ?? "");
$final_formula = 'SUM(';
$header_formula = 'SUM(';
foreach($columns as $column){
$final_formula .= $table_name.'.'.trim($column).'+';
$header_formula .= $table_name.'.'.trim($column).'+'; // Remove + at end
}
$final_formula = rtrim($final_formula,'+') .") as sum_$column_name,";
$header_formula = rtrim($header_formula,'+').") as $column_name,";
$expression .= $final_formula;
$header_exp .= $header_formula;
}
$expression = rtrim($expression, ',');
$header_exp = rtrim($header_exp, ',');
//COMMON QUERY FOR BODY
$payroll_data_qry = 'SELECT '.$header_exp.',cw_employees.emp_name,cw_employees.date_of_joining,cw_employees.stop_pay_code,cw_employees.emp_pf_no,cw_employees.emp_esi_no,cw_employees.father_name,cw_employees.bank_account_number,cw_employees.bank_key,(CASE cw_employees.gender WHEN "1" THEN "Male" WHEN "2" THEN "Female" WHEN "3" THEN "Transgender" END) AS gender, cw_sap_position.position_name,(CASE cw_employees.role WHEN "2" THEN "Monthly Salary" WHEN "3" THEN "Perday Salary" END) AS category from '.$table_name.' INNER JOIN cw_employees ON cw_employees.employee_code = '.$table_name.'.employee_code inner join cw_sap_position on cw_sap_position.position_code ='.$table_name.'.position where '.$table_name.'.trans_status = 1 AND cw_employees.sap_trans_status = 2 AND cw_employees.personal_code = "'.$personal_code.'" AND '.$table_name.'.project_id = "'.$project_id.'" '.$month_qry.' '.$wbs_qry.' GROUP BY cw_arr_transactions.employee_code ';
//QUERY FOR FOOTER SUM
$footer_sum_qry = 'SELECT '.$expression.' FROM '.$table_name.' INNER JOIN cw_employees ON cw_employees.employee_code = '.$table_name.'.employee_code where '.$table_name.'.trans_status = 1 AND cw_employees.sap_trans_status = 2 AND cw_employees.personal_code = "'.$personal_code.'" AND '.$table_name.'.project_id = "'.$project_id.'" '.$month_qry.' '.$wbs_qry.'';
}else //BASED ON WAGE REGISTER FUNCTION CALLING STARTS
if($wage_register === 3){ # MISCELLANEOUS PAYMENT
$wage_rule_name = "misc";
$this->misc_wage_rule($process_month,$personal_code,$project_id,$wage_rule_name,$project_name,$rules_rslt,$misc_wbs_qry);
}else{
//COMMON QUERY FOR BODY ALL REPORT
$payroll_data_qry = 'SELECT '.$table_name.'.*,cw_employees.emp_name,cw_employees.date_of_joining,cw_employees.stop_pay_code,cw_employees.emp_pf_no,cw_employees.emp_esi_no,cw_employees.father_name,cw_employees.bank_account_number,cw_employees.bank_key, (CASE cw_employees.gender WHEN "1" THEN "Male" WHEN "2" THEN "Female" WHEN "3" THEN "Transgender" END) AS gender,cw_sap_position.position_name,(CASE '.$table_name.'.role WHEN "2" THEN "Monthly Salary" WHEN "3" THEN "Perday Salary" END) AS category from '.$table_name.' INNER JOIN cw_employees ON cw_employees.employee_code = '.$table_name.'.employee_code inner join cw_sap_position on cw_sap_position.position_code ='.$table_name.'.position where '.$table_name.'.trans_status = 1 AND '.$table_name.'.process_month = "'.$process_month.'" AND '.$table_name.'.personal_code = "'.$personal_code.'" AND '.$table_name.'.project_id = "'.$project_id.'" AND '.$table_name.'.sap_trans_status = 2 '.$wbs_qry.'';
//QUERY FOR FOOTER SUM
$footer_sum_qry = 'SELECT SUM('.$table_name.'.ebasic)AS sum_ebasic,SUM('.$table_name.'.eda)AS sum_eda,SUM('.$table_name.'.espl)AS sum_espl,SUM('.$table_name.'.elwage)AS sum_elwage,SUM('.$table_name.'.total_earnings)AS sum_total_earnings,SUM('.$table_name.'.esi)AS sum_esi,SUM('.$table_name.'.ptax)AS sum_ptax,SUM('.$table_name.'.lwf)AS sum_lwf,SUM('.$table_name.'.total_deductions)AS sum_total_deductions,SUM('.$table_name.'.net_pay)AS sum_net_pay,SUM('.$table_name.'.tot_other_ded)AS sum_tot_other_ded,sum('.$table_name.'.epf)as sum_epf,sum('.$table_name.'.pd)as sum_pd,SUM('.$table_name.'.epf + '.$table_name.'.vpf_amt)AS sum_pf,sum('.$table_name.'.e_mbonus_grs_wesi)as sum_e_mbonus_grs_wesi,SUM('.$table_name.'.total_hra)AS sum_total_hra,sum('.$table_name.'.econv)as sum_econv,SUM('.$table_name.'.ptax + '.$table_name.'.tds)AS sum_income_tax,sum('.$table_name.'.embonus_grs)as sum_embonus_grs,sum('.$table_name.'.over_time)as sum_over_time,sum('.$table_name.'.emed_alw)as sum_emed_alw,sum('.$table_name.'.atn_inc)as sum_atn_inc,sum('.$table_name.'.tds)as sum_tds,sum('.$table_name.'.fgross +'.$table_name.'.pd_gross)as sum_gross_tot FROM '.$table_name.' inner join cw_employees on cw_employees.employee_code = '.$table_name.'.employee_code where '.$table_name.'.trans_status = 1 AND '.$table_name.'.process_month = "'.$process_month.'" AND '.$table_name.'.personal_code = "'.$personal_code.'" AND '.$table_name.'.project_id = "'.$project_id.'" AND '.$table_name.'.sap_trans_status = 2 '.$wbs_qry.'';
}
$payroll_data_info = $this->db->query("CALL sp_a_run ('SELECT','$payroll_data_qry')");
$payroll_data_rslt = $payroll_data_info->result_array();
$payroll_data_info->next_result();
$footer_info = $this->db->query("CALL sp_a_run ('SELECT','$footer_sum_qry')");
$footer_rslt = $footer_info->result_array();
$footer_info->next_result();
if(!$payroll_data_rslt){
echo json_encode(array('success' => FALSE,'message' =>'No Data Available.!'));
exit(0);
}
if($wage_register === 4){ # BONUS PAYMENT
$wage_rule_name = "bonus";
$this->bonus_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt,$wbs_qry);
}else{
$wage_rules_list = array(1 => "Central",2 => "State",3 => "TN_Factory_Act_Wage");
$wage_rule_name = $wage_rules_list[$wage_rules];
//FOR CENTRAL BASED WAGE
if($personal_code && $wage_rules === 1){
$this->all_central_common_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt);
}
//FOR STATE BASED WAGE APART FROM TN AND BENGALURU
if(!array_key_exists($personal_code,$personal_code_arr ?? []) && $wage_rules === 2){
$this->others_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt);
}
//FOR BENGALURU STATE BASED WAGE
if($personal_code === "1400" && $wage_rules === 2){
$this->bengalure_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt);
}
//FOR TN BASED WAGE
if($personal_code === "1100"){
if($wage_rules === 2){ # TN STATE
$this->tamilnadu_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt);
}else
if($wage_rules === 3){ # TN FACTORY DESIGN
$this->tn_factory_act_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt);
}
}
}
//BASED ON WAGE REGISTER FUNCTION CALLING ENDS
}
//PDF GENERATION
public function wage_register_pdf_generate($head_content,$data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id){
$get_pdf_design = '<div>'.$data_content.''.$foot_sum_tr.'</table></div>';
$final_rslt = "<!DOCTYPE html><head><style>
@page{
margin: 60px 25px;
}
.header{
padding: 20px 0px 20px 0px;
margin: 30px 0px 0px 10px;
overflow: auto;
}
td{
word-wrap: break-word;
}
table{
border-collapse: collapse;
}
.page-break {
page-break-before: always;
}
table td.fr-highlighted,.fr-view table th.fr-highlighted{
border: 1px solid black !important;
}</style></head><body>".$get_pdf_design."</body></html>";
$folder = "wage_register/$process_month/$personal_code";
$pro_name = preg_replace('/[^A-Za-z]/', '_', $project_name);
$file_name = $wage_rule_name."_".$project_id;
$db_name = $this->config->item("db_name");
$enc_file_name = $this->encryptFilename($file_name,$db_name);
$file_name = $pro_name."_".$enc_file_name;
//PATH CREATION TO STORE THE FILES
$oldmask = umask(0);
if(!file_exists($folder)){
mkdir($folder, 0777, true); # IF NOT CREATE
}
//FILE WRITE AS HTML
file_put_contents($folder."/".$file_name.".html" , $final_rslt);
chmod($folder."/".$file_name.".html", 0777);
umask($oldmask);
$directory = str_replace('application/controllers', '', __DIR__);
$html_file_name = $directory.$folder."/".$file_name.".html";
$pdf_file_name = $directory.$folder."/".$file_name.".pdf";
if(file_exists($html_file_name)){
//CONVERT HTML FILE TO PDF
$command = "xvfb-run wkhtmltopdf --orientation Landscape $html_file_name $pdf_file_name";
$output = shell_exec($command);
unlink($html_file_name);
if($output){
$this->download_table($personal_code,$process_month,$wage_rule_name,$pro_name,$project_id);
}else{
echo json_encode(array('success' => FALSE,'message' =>'PDF convertion error.please contact admin.'));
exit(0);
}
}else{
echo json_encode(array('success' => FALSE,'message' =>'HTML convertion error.please contact admin.'));
exit(0);
}
}
//DISPLAY TABLE AFTER PDF GENERATED
public function download_table($personal_code,$process_month,$wage_rule_name,$pro_name,$project_id){
$folder = "wage_register/$process_month/$personal_code";
$display_name = $wage_rule_name."_".$pro_name;
$file_name = $wage_rule_name."_".$project_id;
$db_name = $this->config->item("db_name");
$enc_file_name = $this->encryptFilename($file_name,$db_name);
$file_name = $pro_name."_".$enc_file_name;
$path = $folder."/".$file_name.".pdf";
if(file_exists($path)){
$file_path = base_url().$path;
$enc_file_path = base64_encode($file_path);
$tble_line = "<table class = 'table table-striped table-bordered' id = 'wage_table' style='table-layout:fixed;'><thead><tr><th style = 'text-align:center;'>Pdf Type</th><th style = 'text-align:center;'>Action</th></tr></thead><tbody><tr><td style='text-align:center;'>$display_name</td><td style='text-align:center;'><a class = 'btn btn-primary btn-sm' onclick=download_wage('download_$project_id','$enc_file_path') id='download_$project_id' download '><span class='fa fa-download' download> </span> Download </a></td></tr></tbody></table>";
}
if($tble_line){
echo json_encode(array('success' => TRUE,'message' => 'PDF Generated Successfully.!','table_line'=>$tble_line));
exit(0);
}else{
echo json_encode(array('success' => FALSE,'message' => 'PDF not Generated.!'));
exit(0);
}
}
//FOR CENTRAL BASED PDF GENERATION STARTS
public function all_central_common_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt){
$from_date = date('d-m-Y',strtotime('01-'.$process_month));
$to_date = date('t-m-Y',strtotime($from_date));
#-----------------HEADER START-----------------------#
$table_content = '<div><table><tr>
<td colspan="26" style="width: 100%;">
<p style="text-align: center;"><span style="font-size: 10px;"><strong>FORM B</strong></span></p>
<p style="text-align: center;"><span style="font-size: 10px;"><strong>(SEE RULE 78(1) (A) (I) OF THE CONTRACT LABOUR (CENTRAL) RULES, 1971)
FORMAT FOR WAGE REGISTER </strong></span></p>
<p style="text-align: center;"><span style="font-size: 10px;"><strong>FORMAT FOR WAGE REGISTER</strong></span></p>
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 15%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 31%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Highly Skilled</strong></span></div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Skilled</strong></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 20%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Semi Silled</strong></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 21%;">
<div style="text-align: center;"><span style="font-size: 10px;">Un Skilled </span></div>
</td>
<td></td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 14%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Minimum Basic</strong></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 29%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 8%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 19%;"><span style="font-size: 10px;"><br></span></td>
<td class="fr-highlighted" colspan="6" style="width: 20%;"><span style="font-size: 10px;"><br></span></td>
<td></td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 14%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>DA</strong></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 29%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 8%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 19%;"><span style="font-size: 10px;"><br></span></td>
<td class="fr-highlighted" colspan="6" style="width: 20%;"><span style="font-size: 10px;"><br></span></td>
<td></td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 14%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Overtime</strong></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 29%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 8%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="6" style="width: 19%;"><span style="font-size: 10px;"><br></span></td>
<td class="fr-highlighted" colspan="6" style="width: 20%;"><span style="font-size: 10px;"><br></span></td>
<td></td>
</tr>
<tr>
<td colspan="26" style="width: 100.%;">
<p style="text-align: left;"><span style="font-size: 10px;"><strong> Name of the Establishment UPDATER SERVICES LTD. Name of Owner UDS. LIN ...................... Name and Address: '.$project_name.' </strong></span></p>
<p style="text-align: left;"><span style="font-size: 10px;"><strong> Wage Period From : '.$from_date.' To '.$to_date.' (Monthly/Fortnightly/Weekly/Daily/Piece Rated) </strong></span></p>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="12" style="width: 35%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="2" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Others</span></div>
</td>
<td class="fr-highlighted" colspan="10" style="width: 27%;">
<div style="text-align: center;"><span style="font-size: 9px;">Deductions</span></div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 20%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Sl.No</span></div>
</td>
<td class="fr-highlighted" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 9px;">Name</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Rate of Wage</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">No.of Days Worked</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Overtime Hours</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Basic</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;">Special<br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Basic</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;">DA</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Payment Overtime</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">HRA</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Convey</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Bonus <br>Advance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Leave</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Special Allowa</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">nce</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">PF</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">ESIC</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Society/</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">LWF</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">TDS</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Insu</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;">rance<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">P.Tax</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Others</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Recov</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">eries</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Net<br>Payment</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">EM PF Share</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;">Receipt ID</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Date Payment</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Remarks</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(1)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(2)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(3)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(4)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(5)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(6)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(7)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(8)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(9)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(10)</span></div>
</td>
<td class="fr-highlighted" colspan="4">
<div style="text-align: center;"><span style="font-size: 9px;">(11)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(12)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(13)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(14)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(15)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(16)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(17)</span></div>
</td>
<td class="fr-highlighted" colspan="2">
<div style="text-align: center;"><span style="font-size: 9px;">(18)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">(19)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(20)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(21)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(22)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(23)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(24)</span></div>
</td>
<td class="fr-highlighted" >
<div style="text-align: center;"><span style="font-size: 9px;">(25)</span></div>
</td>
</tr>';
#-----------------HEADER END-------------------------#
#---------BODY TABLE DATA PROCESS START--------------#
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$pf_total = $val['epf'] + $val['vpf_amt'];
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
if($val["bank_key"] === "9100"){
$stop_pay = "B";
}else{
$stop_pay = "C";
}
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 10 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 12%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["emp_name"].'<br>'.$val["employee_code"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.$val["pd"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div data-empty="true" style="text-align: right;">
<span style="font-size: 9px;">'.$val["overtime_hours"].'<br></span>
</div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["ebasic"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["eda"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["over_time"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align:right;"><span style="font-size: 9px;">'.round($val["total_hra"]).'<br></span></td>
<td class="fr-highlighted" style="width: 5%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["espl"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($pf_total).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div data-empty="true" style="text-align: right; font-size: 9px;">
'.round($val["lwf"]).'<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["tds"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val['ptax']).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["net_pay"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;">'.round($val["epf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;">'.$stop_pay.'<br>'.$val["bank_account_number"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>';
}
#---------BODY TABLE DATA PROCESS END----------------#
#---------FOOTER TOTAL SUM START---------------------#
$foot_sum_tr = '<tr>
<td class="fr-highlighted">
<div style="text-align: right;"><span style="font-size: 10px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 10px; font-weight:bold;">Grand Total</span></div>
</td>
<td class="fr-highlighted" style="width: 6.5304%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.6934%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.$footer_rslt[0]["sum_pd"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 6.6482%;">
<div data-empty="true" style="text-align: right;">
<span style="font-size: 8px; font-weight:bold;">'.$footer_rslt[0]["sum_overtime_hours"].'<br></span>
</div>
</td>
<td class="fr-highlighted" style="width: 3.1578%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_ebasic"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.1578%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold"></span></div>
</td>
<td class="fr-highlighted" style="width: 3.6519%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_eda"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.091%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_over_time"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 5.5347%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5.5347%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5.5347%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.8143%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.9627%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_espl"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.0557%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.2919%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_epf"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.7891%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.305%;">
<div data-empty="true" style="text-align: right; font-size: 8px; font-weight:bold;">
'.round($footer_rslt[0]["sum_lwf"]).'<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3.8858%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_tds"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.8858%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3.8858%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_ptax"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.0327%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 10px; font-weight:bold;">'.round($footer_rslt[0]["sum_tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.0327%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.1786%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 8.453%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_net_pay"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 2.0995%;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_epf"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 5.1683%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px; font-weight:bold;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5.1683%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px; font-weight:bold;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.0761%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr>';
#---------FOOTER SUM TOTAL END-----------------------#
#---------FUNCTION CALLING FOR PDF GENERATION--------#
$rslt = $this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
//FOR CENTRAL BASED PDF GENERATION ENDS
//FOR STATE BASED PDF GENERATION STARTS
# OTHER STATE EXCLUDE TN & BENGALURU
public function others_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt){
$month = date("F",strtotime("01-$process_month"));
#-------------TABLE HEAD START-----------------------#
$table_content = '<div><table><tr>
<td colspan="23">
<div style="text-align: center;"><span style="font-size: 10px;"> </span></div>
<p style="text-align: center;"><span style="font-size: 10px;"><strong>'.$rules_rslt[0]['wage_form_no'].'</strong></span></p>
<p style="text-align: center;"><span style="font-size: 10px;"><strong> '.$rules_rslt[0]['rules'].'</strong></span></p>
<p style="text-align: center;"><span style="font-size: 10px;"><strong> REGISTER OF WAGE<strong>S</strong></strong></span></p>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="16" style="width: 55%;">
<div style="text-align: left;"><span style="font-size: 10px;">Name and Address of Contractor : <strong>UPDATER SERVICES LTD , <br>No.2/302A,UDS Salai,<br>Off Old Mahabalipuram Road,<br>Thoraipakkam,Chennai -97.</strong><br>Nature and Location of Work : .....................................................................</span></div>
</td>
<td class="fr-highlighted" colspan="10" style="width: 45%;">
<div style="text-align: left;"><span style="font-size: 10px;">Name and address of establishment in under which Contract is carried on,</span></div>
<div style="text-align: left;"><span style="font-size: 10px; "><strong>'.$project_name.',</strong></span></div>
<div style="text-align: left;"><span style="font-size: 10px;"> Name and address of Principal Employer.......................................................</span></div>
<p style="text-align: left;"><span style="font-size: 10px;"> Wage Period : Monthly</span></p>
<p style="text-align: left;"><span style="font-size: 10px;"> Salary Details : '.$process_month.'</span></p>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"> </span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; vertical-align: middle;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 40%;">
<div style="text-align: center;"><span style="font-size: 9px;"><strong>Amount of Wages Earned</strong></span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 20%;">
<div style="text-align: center;"><span style="font-size: 9px;"><strong>Deductions, if any (indicate nature)</strong></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Sl.No</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br><br><br></span></div>
</td>
<td class="fr-highlighted" style="width: 10%;">
<div style="text-align: center;"><span style="font-size: 9px;">Name of Workman</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Sl.No in the register of Workmen<br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Designation / Nature of work done</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">No.of days worked<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; vertical-align: middle;">
<div style="text-align: center;"><span style="font-size: 9px;">Units of work done<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Daily rate of wages / Piece rate</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Basic Wages</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Dearness Allowance</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Over Time</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">HRA</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Special Allowa nce</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Conve</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> yance</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div><span style="font-size: 9px;">Leave wages</span></div><span style="font-size: 9px;"><br></span></td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Bonus</span></div>
<p style="text-align: center;"><span style="font-size: 9px;">Advance</span></p>
</td>
<td class="fr-highlighted" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> earning</span></div>
<br>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: center;"><span style="font-size: 9px;">PF<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">ESI<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.4544%;">
<div style="text-align: center;"><span style="font-size: 9px;">Profess ion</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> tax</span></div>
</td>
<td class="fr-highlighted" style="width: 4.4544%;">
<div style="text-align: center;"><span style="font-size: 9px;">LWF</span></div>
</td>
<td class="fr-highlighted" style="width: 4.4544%;">
<div style="text-align: center;"><span style="font-size: 9px;">TDS</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Advance </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">/ Other deductions</span></div>
</td>
<td class="fr-highlighted " style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">deductions</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Net amount paid</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;">Signature / Thumb Impression of Workmen/ Bank AC no</div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Initials of contractor or his represen</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">tative</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;"> (1)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"> (2)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;"> (3)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"> (4)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (5)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; vertical-align: middle; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (6)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (7)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (8)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (9)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (10)</span></div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 18%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (11)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;">(12)</span></div>
</td>
<td class="fr-highlighted" colspan="7" style="width: 19%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (13)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (14)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (15)</span></div>
</td>
<td class="fr-highlighted" style="width: 5%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"> (16)</span></div>
</td>
</tr>';
#----------TABLE HEAD PROCESS END--------------------#
#----------TABLE BODY DATA PROCESS START-------------#
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$pf_total = $val['epf'] + $val['vpf_amt'];
$income_tax = $val['ptax'] + $val['tds'];
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
if($val["bank_key"] === "9100"){
$stop_pay = "B";
}else{
$stop_pay = "C";
}
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
// Increment row count
$row_count++;
// Add a page break every 10 rows
if($row_count % 10 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr '.$last_tr.'>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["emp_name"].'<br>'.$val["employee_code"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["position_name"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: right;"><span style="font-size: 9px;">'.$val["pd"].'<br></span></td>
<td class="fr-highlighted" style="width: 3%; vertical-align: middle; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div style="text-align: right; font-size: 9px;">'.round($val["eda"]).'
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right; font-size: 9px;">'.round($val["total_hra"]).'
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["econv"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div><span style="font-size: 9px;">'.round($val["elwage"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div><span style="font-size: 9px;">'.round($val["e_mbonus_grs_wesi"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: right; font-size: 9px;">
<div style="text-align: right;">
'.round($pf_total).'<br>
</div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["net_pay"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 9px;"><span style="text-align:center">'.$stop_pay.'</span><br>'.$val["bank_account_number"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 6%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr> ';
}
#----------TABLE BODY DATA PROCESS END---------------#
#----------FOOTER TOTAL SUM START--------------------#
$foot_sum_tr ='<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 10px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px; font-weight:bold;">Grand Total</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: right;"><span style="font-size: 8px;">'.$footer_rslt[0]["sum_pd"].'<br></span></td>
<td class="fr-highlighted" style="width: 3%; vertical-align: middle; text-align: center;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right; font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_eda"]).'
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: center;">
<div style="text-align: right; font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_hra"]).'
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_econv"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_elwage"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%; text-align: right;">
<div><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_e_mbonus_grs_wesi"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%; text-align: center; font-size: 8px;">
<div style="text-align: right; font-weight:bold">
'.round($footer_rslt[0]["sum_pf"]).'<br>
</div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%; text-align: right;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_net_pay"]).'</span></div>
</td>
<td class="fr-highlighted" style="width: 5%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 6%; text-align: center;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr> ';
#----------FOOTER TOTAL SUM END----------------------#
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
# BENGALURU
public function bengalure_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt){
#----------TABLE HEADER START------------------------#
$table_content = '<div><table><tr>
<td colspan="38" style="width: 100.0000%;">
<p style="text-align: left;"><span style="font-size: 11px;"><span style="font-family: Cambria, sans-serif;"><strong>'.$rules_rslt[0]['wage_form_no'].'</strong><br></span></span><span style="font-size: 11px;"><span style="font-family: Cambria, sans-serif;"><strong>COMBINED MUSTER ROLL CUM REGISTER OF WAGES</strong></span></span><br><span style="font-size:11px;"> '.$rules_rslt[0]['rules'].'</span><br>
<span style="font-size:10px;">in lieu of</span><br/>
<span style="font-size:10px;">1. Form I, II of Rule 22(4); Form IV of Rule 29(2); Form V & VII of Rule 29(1) & (5) of Karnataka Minimum Wages Rules, 1958</span><br>
<span style="font-size:10px;">2. Form I of Rules 3(1) of Karnataka Payment of Wages Rules, 1963</span><br>
<span style="font-size:10px;">3. Form XIII of Rules 75; Form XV, XVII, XX, XXI, XXII, XXIII of 78(1) (a) (i), (ii) & (iii) of Karnataka Contract Labour (Regulation & Abolition) Rules, 1974</span><br>
<span style="font-size:10px;">4. Form XIII of Rule 43; Forms XVII, XVIII, XIX, XX, XXI, XXII of Rule 46(2) (a) (c) & (d) of Inter-state Migrant Workmen (Regulation of Employment and conditions of service) Karnataka Rules, 1981</span><br>
<span style="text-align: left; font-weight:bold;"><span style="font-size: 11px;"> <br>Month & Year : '.$process_month.'<br>Name & Address of the Establishment : UPDATER SERVICES LTD., #2 & 3, II Floor, 10TH Main Road, HAL III Stage, Jeeva Bheemanagar Road, Banglore - 560075.<br>Name & Address of the Employer : '.$project_name.' . </span></span></p>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="12" style="width: 20%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="14" style="width: 39%;">
<div style="text-align: center;"><span style="font-size: 11px;"><strong>Earned Wages and Other Allowances</strong></span></div>
</td>
<td class="fr-highlighted" colspan="11" style="width: 24%;">
<div style="text-align: center;"><span style="font-size: 11px;"><strong>Deductions</strong></span></div>
</td>
<td class="fr-highlighted" colspan="3" style="width: 10%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">SL.<br>No<br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<p><span style="font-size: 8px;"><br></span></p>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 8px;">Name</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"> of the<br> Employee<br></span></div>
<p><span style="font-size: 8px;"><br></span></p>
</td>
<td class="fr-highlighted" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 8px;">Father/</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">Husband</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"> Name</span></div>
<p><span style="font-size: 8px;"><br></span></p>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Gender</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">Designation/<br>Department</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Date of </span></div>
<div style="text-align: center;"><span style="font-size: 8px;">Joining</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">ESI No <br> <br><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 6%;"><span style="font-size: 8px;">Pf No<br><br><br><br></span></td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Wages fixed includ -ing VDA <br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">DOL</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">No of Pay<br>able Days</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Total OT Hours<br>Worked</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">Basic</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">DA/<br>VDA</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">HRA</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Convey</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">ance</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Medi</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">cal</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;">allo<br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;">wance<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Att</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">bonus</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Spl.</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"> Allow</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">ance</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: center;"><span style="font-size: 8px;">OT</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1.3101%;">
<div style="text-align: center;"><span style="font-size: 8px;">NFH</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Mater<br>nity<br>Beni<br>fits</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">Leave</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"> Wages</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">Bonus</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">Advance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Subsis</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">tence<br>allo<br>wance</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"> if any</span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Total</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Esi</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align:center;"><span style="font-size: 8px;text-align:center;">PF</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: center;"><span style="font-size: 8px;">PT</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 8px;">TDS</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 8px;">Soci<br>ety</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 8px;">Insu</span></div>
<div style="text-align: center;"><span style="font-size: 8px;">rance</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 8px;">Sal<br>.Adv<br>ance</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Fines</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Dam<br>age/<br>Loss</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">Others</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Total</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">Net<br>pay<br>able</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">Mode <br>of<br> Payment</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;">Employee<br>signature</span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(1)</span></div>
</td>
<td class="fr-highlighted"colspan="2">
<div style="text-align: center;"><span style="font-size: 8px;">(2)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(3)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(4)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(5)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(6)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(7)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(8)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(9)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(10)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(11)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(12)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(13)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(14)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(15)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(16)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(17)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(18)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(19)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(20)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(21)</span></div>
</td>
<td class="fr-highlighted" colspan="2">
<div style="text-align: center;"><span style="font-size: 8px;">(22)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(23)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(24)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(25)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(26)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(27)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(28)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(29)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(30)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(31)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(32)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(33)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(34)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(35)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(36)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(37)</span></div>
</td>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">(38)</span></div>
</td>
</tr>';
#----------TABLE HEADER END--------------------------#
#----------TABLE BODY DATA PROCESS START-------------#
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$pf_total = $val['epf'] + $val['vpf_amt'];
$income_tax = $val['ptax'] + $val['tds'];
$gross_total = $val['fgross'] + $val['pd_gross'];
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
if($val["bank_key"] === "9100"){
$stop_pay = "B";
}else{
$stop_pay = "C";
}
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 9 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$key_no.'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["emp_name"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["father_name"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["gender"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["position_name"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["date_of_joining"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["emp_esi_no"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 20px;"><span style="font-size: 8px;">'.$val["emp_pf_no"].'<br></span></td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($gross_total).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.$val["resignation_date"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.$val["pd"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5px;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($pf_total).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%; text-align:right;"><span style="font-size: 8px; ">'.round($val["tds"]).'<br></span></td>
<td class="fr-highlighted" style="width: 1.4965%; text-align:right;">
<div style="text-align: right;"><span style="font-size: 8px; ">'.round($val["lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align:right;"><span style="font-size: 8px;">'.round($val["net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;" colspan="2">
<div style="text-align: center;"><span style="font-size: 8px;">'.$stop_pay.'<br>'.$val["bank_account_number"].'<br></span></div>
</td>
</tr>';
}
#----------TABLE BODY PROCESS DATA END---------------#
#----------FOOTER SUM TR START-----------------------#
$foot_sum_tr ='<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold;">Grand Total<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 20px;"><span style="font-size: 8px;"><br></span></td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_gross_tot"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_pd"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5px;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_pf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 0%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;"><div style="text-align: right;"><span style="font-size: 9px; font-weight:bold; text-align:right">'.round($footer_rslt[0]["sum_tds"]).'<br></span></div></td>
</td>
<td class="fr-highlighted" style="width: 1%;"><div style="text-align: right;"><span style="font-size: 9px; font-weight:bold; text-align:right">'.round($footer_rslt[0]["sum_lwf"]).'<br></span></div></td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold;">'.round($footer_rslt[0]["sum_tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight:bold">'.round($footer_rslt[0]["sum_net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;" colspan="2">
<div style="text-align: right;"><span style="font-size: 8px;"></span></div>
</td>
</tr>';
#----------FOOTER TOTAL SUM END----------------------#
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
# TN
public function tamilnadu_state_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt){
$month_year = date('d-m-Y',strtotime('01-'.$process_month));
$year = date('Y',strtotime($month_year));
$month = date("F",strtotime($month_year));
#----------TABLE HEADER START------------------------#
$table_content = '<div><table><tr>
<th colspan="10" style="width: 33%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</th>
<th colspan="8" style="width: 25%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</th>
<th colspan="9" style="width: 34%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</th>
<th colspan="2" style="width: 15%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</th>
</tr>
<tr>
<td colspan="29" style="width: 100%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><strong>'.$rules_rslt[0]['wage_form_no'].'</strong></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><strong> '.$rules_rslt[0]['rules'].' </strong></span></div>
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><strong>REGISTER OF WAGE</strong></span></div>
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="10" style="width: 33%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Name of the Establishment:</strong></span></div>
</td>
<td class="fr-highlighted" colspan="8" style="width: 25%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>'.$project_name.'</strong></span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 34%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Wage Period:</strong></span></div>
</td>
<td class="fr-highlighted" colspan="3" style="width: 15%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="10" rowspan="3" style="width: 33%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Name of the Employer/Contractor with Address:</strong></span></div>
</td>
<td class="fr-highlighted" colspan="8" rowspan="3" style="width: 25%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>UPDATER SERVICES LTD, No:- 2/302A,UDS Salai, Off Old Mahabalipuram Road, Thoraipakkam, Chennai - 600097</strong></span></div>
</td>
<td class="fr-highlighted" colspan="9" rowspan="2" style="width: 34%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Week / Fortnight / Month:</strong></span></div>
</td>
<td class="fr-highlighted" colspan="3" style="width: 15%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Month</strong></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="3" rowspan="2" style="width: 15%;">
<div style="text-align: center;"><span style="font-size: 10px;"> '.$month.'<br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="10" style="width: 34%;">
<div style="text-align: center;"><span style="font-size: 10px;"><strong>Year: '.$year.'</strong></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">S.No</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;">Name of The Workman</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Gender</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;">Designation/<br>nature of work</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Daily rated/<br>Piece rated/<br>Monthly rated</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Wage period/<br>week/<br>fn/<br>month</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total no.of days worked<br>during week fn/<br>month</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Units of work done/<br>no.of days worked</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Daily rate of wages/<br>piece rate</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Over</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">time<br>rate</span></div>
</td>
<td class="fr-highlighted" colspan="8" style="width: 25%;">
<div style="text-align: center;"><span style="font-size: 9px;"><strong>Wages Earned</strong></span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Gross <br>Wages</span></div>
</td>
<td class="fr-highlighted" colspan="7" style="width: 20%;">
<div style="text-align: center;"><span style="font-size: 9px;"><strong>Deductions</strong></span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"Total<br>Deductions</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Net Wages</span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Signature/</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Thumb Impression of Workmen/</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Bank AC No</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" rowspan="2" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total unpaid amoun ts accum ulated</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Basic<br>wages</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">DA</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">HRA</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Special Allow</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Bonus</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Advance</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Convey</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">Overtime Earned</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Leave Wages including cash in lieu of kinds</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">PF</span></div>
</td>
<td class="fr-highlighted" style="width: 2.5641%;">
<div style="text-align: center;"><span style="font-size: 9px;">ESI</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Profes</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">sion tax</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Labour welfare<br>fund</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">TDS</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Advance/<br>other Deduct</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ions</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Fines</span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(1)</span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 9px;">(2)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(3)</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">(4)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(5)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(6)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(7)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(8)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(9)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(10)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(11)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(12)</span></div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">(13)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(14)</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">(15)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">(16)</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">(17)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(18)</span></div>
</td>
<td class="fr-highlighted" style="width: 12%;" colspan="4">
<div style="text-align: center;"><span style="font-size: 9px;">(19)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(20)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(21)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(22)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(23)</span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">(24)</span></div>
</td>
</tr>';
#----------TABLE HEADER END--------------------------#
#----------TABLE BODY DATA PROCESS START-------------#
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$pf_total = $val['epf'] + $val['vpf_amt'];
$income_tax = $val['ptax'] + $val['tds'];
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
if($val["bank_key"] === "9100"){
$stop_pay = "B";
}else{
$stop_pay = "C";
}
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 10 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["emp_name"].'<br>'.$val["employee_code"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["gender"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["position_name"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["category"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">M</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$val["pd"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($pf_total).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 9px;">'.round($val["net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 9px;">'.$stop_pay.'<br>'.$val["bank_account_number"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;"><br></span></div>
</td>
</tr>';
}
#----------TABLE BODY PROCESS DATA END---------------#
#----------FOOTER SUM TR START-----------------------#
$foot_sum_tr ='<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 12px;font-weight: bold;"></span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 11px;font-weight: bold;">Grand Total</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;font-weight:bold;">'.$footer_rslt[0]["sum_pd"].'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_epf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($footer_rslt[0]["sum_tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 10px;font-weight: bold;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: right;"><span style="font-size: 8px;font-weight: bold;">'.round($footer_rslt[0]["sum_net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 5%;">
<div style="text-align: right;"><span style="font-size: 8px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 9%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr>';
#----------FOOTER TOTAL SUM END----------------------#
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
//FOR STATE PDF BASED PDF GENERATION ENDS
//FOR TN FACTORY DESIGN PDF GENERATION STARTS
public function tn_factory_act_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt){
$month_year = date('d-m-Y',strtotime('01-'.$process_month));
$year = date('Y',strtotime($month_year));
$month = date("F",strtotime($month_year));
#----------TABLE HEADER START------------------------#
$table_content ='<div><table><tr>
<td colspan="33" style="width: 100.0000%;">
<div style="text-align: center;"><span style="font-size: 10px;">Form No 15 </span></div>
<div style="text-align: center;"><span style="font-size: 10px;">(Part - II )
</span></div>
<div style="text-align: center;"><span style="font-size: 10px;"> REGISTER OF WAGES</span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 10%;">
<div style="text-align: left;"><span style="font-size: 10px;">Name and Address of the factory:</span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 27%;">
<div style="text-align: center;"><span style="font-size: 10px;"> '.$project_name.'</span></div>
</td>
<td colspan="8" rowspan="5" style="width: 24%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="12" style="width: 38%;">
<div style="text-align: center;"><span style="font-size: 10px;">Total No. of Person Employed</span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" rowspan="2" style="width: 10%;">
<div style="text-align: left;"><span style="font-size: 10px;">Name of the Employer/Contractor with Address:</span></div>
</td>
<td class="fr-highlighted" colspan="9" rowspan="2" style="width: 27%;">
<div style="text-align: center;"><span style="font-size: 10px;">UPDATER SERVICES LTD, No:- 2/302A,UDS Salai, Off Old Mahabalipuram Road, Thoraipakkam, Chennai - 600097</span></div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 17%;">
<div style="text-align: center;"><span style="font-size: 10px;">Men</span></div>
</td>
<td class="fr-highlighted" colspan="3" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 10px;">Women</span></div>
</td>
<td class="fr-highlighted" colspan="2" style="width: 8%;">
<div style="text-align: center;"><span style="font-size: 10px;">Male Adolescent</span></div>
</td>
<td class="fr-highlighted" colspan="2" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 10px;">Female Adolescent </span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="5" style="width: 17%;">
<div data-empty="true" style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="3" style="width: 7%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="2" style="width: 8%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="2" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 10%;">
<div style="text-align: left;"><span style="font-size: 10px;">Name of the Manager / In-charge:</span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 27%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td colspan="12" style="width: 38.7604%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="4" style="width: 10%;">
<div style="text-align: center;"><span style="font-size: 10px;">Registration No:</span></div>
</td>
<td class="fr-highlighted" colspan="9" style="width: 27%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td colspan="12" style="width: 38.7604%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="33" style="width: 100%;">
<div style="text-align: center;"><span style="font-size: 10px;">Wage Period '.$month.'-'.$year.' (Monthly /Fortnightly/Weekly /Daily/Piece Rated)</span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<br>
</td>
<td class="fr-highlighted" colspan="13" style="width: 39%;">
<div style="text-align: center;"><span style="font-size: 10px;">Deductions</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<br>
</td>
<td class="fr-highlighted" colspan="3" style="width: 10%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 19%;">
<div style="text-align: center;"><span style="font-size: 10px;">Advances</span></div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 17%;">
<div style="text-align: center;"><span style="font-size: 10px;">Damages/Fines</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;"><br></span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">S.</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">No</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Serial number in register of adult worker and yourng persons</span></div>
</td>
<td class="fr-highlighted" style="width: 9%;">
<div style="text-align: center;"><span style="font-size: 9px;">Name </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">of the</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> worker</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Worker Iden</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">tity Number</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">No.<br>Of Days </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Wor</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ked</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Basic Wages</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Dear<br>ness Allow</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">House Rent Allow</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Conve</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">yance</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Special</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Allowa</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">nce</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Bonus<br>Advance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Over</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">time</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Wages</span></div>
</td>
<td class="fr-highlighted" style="width: 1%;">
<div style="text-align: center;"><span style="font-size: 9px;">Leave </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Wages</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Gross</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Wages</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Prov</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ident</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">fund</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Emplo</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">yee</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">State</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Insur</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Labour</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Wel<br>fare</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Fund</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Adv<br>ance</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Paid</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Adv<br>ance</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Reco</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">very</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Pending</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">the</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> begin</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ning of the month</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Adv<br>ance</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Recov</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ered</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">TDS</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Deduc</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">tion</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">imposed on Damages loss or fines</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Deduc</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">tion<br>Recov</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ery pending</span></div>
<div style="text-align: center;"><span style="font-size: 9px;"> at</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">the beginning of the month</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Deduction </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">made on Damages,</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">loss or Fines</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Pending</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Reco</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">very</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Profe</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ssio</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Tax</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Total</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">dedu</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ctions</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Net</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">wages</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">Date of Paym</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ent</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 9px;">Unpaid<br>Occum</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ulation</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 9px;">Rate which subsist</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance allow</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ance calcula</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">ted and amount paid</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Recieved by </span></div>
<div style="text-align: center;"><span style="font-size: 9px;">worker/</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">bank transac</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">tion</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">I.D.and</span></div>
<div style="text-align: center;"><span style="font-size: 9px;">Date</span></div>
</td>
<td class="fr-highlighted" style="width: 6%;">
<div style="text-align: center;"><span style="font-size: 9px;">Remarks</span></div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(1)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">(2)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(3)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">(4)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(5)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">(6)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">(7)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(8)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;" colspan="3">
<div style="text-align: center;"><span style="font-size: 8px;">(9)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(10)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(11)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(12)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(13)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(14)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(15)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(16)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(17)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">(18)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(19)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(20)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(21)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">(22)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(23)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(24)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(25)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(26)</span></div>
</td>
<td class="fr-highlighted" style="width: 4%;">
<div style="text-align: center;"><span style="font-size: 8px;">(27)</span></div>
</td>
<td class="fr-highlighted" style="width: 3%;">
<div style="text-align: center;"><span style="font-size: 8px;">(38)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 8px;">(29)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 10px;">(30)</span></div>
</td>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 9px;">(31)</span></div>
</td>
</tr>';
#----------TABLE HEADER END--------------------------#
#----------TABLE BODY DATA PROCESS START-------------#
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$pf_total = $val['epf'] + $val['vpf_amt'];
$income_tax = $val['ptax'] + $val['tds'];
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
if($val["bank_key"] === "9100"){
$stop_pay = "B";
}else{
$stop_pay = "C";
}
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 8 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.7127%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7182%;">
<div style="text-align: center;"><span style="font-size: 8px;">'.$val["emp_name"].'<br>'.$val["employee_code"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 3.3214%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4237%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["pd"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.0279%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.5286%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6067%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4516%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.381%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6281%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7933%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6281%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4301%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4818%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($pf_total).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4276%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.8324%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7076%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5121%;">
<div style="text-align: right;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5663%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.9954%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7752%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5487%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.93%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.7899%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5902%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7752%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7921%;">
<div style="text-align: right;"><span style="font-size: 8px;">'.round($val["net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6604%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.254%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.2322%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4215%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br>'.$stop_pay.'<br>'.$val["bank_account_number"].'</span></div>
</td>
<td class="fr-highlighted" style="width: 2.4209%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
</tr>';
}
#----------TABLE BODY PROCESS DATA END---------------#
#----------FOOTER SUM TR START-----------------------#
$foot_sum_tr ='<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 8px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3.7127%;">
<div style="text-align: center;"><span style="font-size: 9px; font-weight:bold">Grand Total<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7182%;">
<div style="text-align: center;"><span style="font-size: 8px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 3.3214%;">
<div style="text-align: center;"><span style="font-size: 8px;"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4237%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_pd"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.0279%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_ebasic"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.5286%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_eda"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6067%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_total_hra"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4516%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_econv"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.381%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_espl"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6281%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_e_mbonus_grs_wesi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7933%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_over_time"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6281%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_elwage"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4301%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_total_earnings"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4818%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold"">'.round($footer_rslt[0]["sum_epf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4276%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_esi"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.8324%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_lwf"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7076%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5121%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5663%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_tot_other_ded"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.9954%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_tds"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7752%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5487%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.93%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.7899%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.5902%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_ptax"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7752%;">
<div style="text-align: right;"><span style="font-size: 9px; font-weight:bold">'.round($footer_rslt[0]["sum_total_deductions"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.7921%;">
<div style="text-align: right;"><span style="font-size: 8px; font-weight:bold">'.round($footer_rslt[0]["sum_net_pay"]).'<br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.6604%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 4.254%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 3.2322%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4215%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
<td class="fr-highlighted" style="width: 2.4209%;">
<div style="text-align: center;"><span style="font-size: 8px; font-weight:bold"><br></span></div>
</td>
</tr>';
#----------FOOTER TOTAL SUM END----------------------#
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
//FOR TN FACTORY DESIGN PDF GENERATION ENDS
//FUNCTION FOR BONUS WAGE RULE
public function bonus_wage_rule($process_month,$personal_code,$project_id,$wage_rules,$project_name,$wage_rule_name,$payroll_data_rslt,$footer_rslt,$rules_rslt,$wbs_qry){
//get bonus sum till previous month
$orderdate = explode('-', $process_month ?? "");
$month = $orderdate[0];
$year = $orderdate[1];
if($month === "09" || $month === "10" || $month === "11" || $month === "12"){
$year = $year;
}else{
$year = date('Y', strtotime($year. ' - 1 years'));
}
$start_month_year = "09-".$year;
$bonus_data_qry = 'SELECT cw_transactions_fms.employee_code,sum(cw_transactions_fms.pd)as pd_tot,sum(cw_transactions_fms.embonus_grs)AS sum_embonus FROM cw_transactions_fms INNER JOIN cw_employees ON cw_employees.employee_code = cw_transactions_fms.employee_code WHERE cw_transactions_fms.trans_status = 1 AND STR_TO_DATE(CONCAT("01-", cw_transactions_fms.process_month), "%d-%m-%Y") BETWEEN STR_TO_DATE("01-'.$start_month_year.'", "%d-%m-%Y") AND STR_TO_DATE("01-'.$process_month.'", "%d-%m-%Y") AND cw_transactions_fms.personal_code = "'.$personal_code.'" AND cw_transactions_fms.sap_trans_status = 2 AND cw_transactions_fms.project_id = "'.$project_id.'" '.$wbs_qry.' GROUP BY cw_transactions_fms.employee_code';
$bonus_data_info = $this->db->query("CALL sp_a_run ('SELECT','$bonus_data_qry')");
$bonus_data_rslt = $bonus_data_info->result_array();
$bonus_data_info->next_result();
$bonus_arr = array();
foreach($bonus_data_rslt as $key => $value){
$bonus_arr[$value['employee_code']]=$value;
}
//TOTAL NO OF DAYS IN YEAR
$current_year = date('Y');
$days = 0;
for($month = 1;$month <= 12;$month++){
$days = $days + cal_days_in_month(CAL_GREGORIAN,$month,$current_year);
}
$table_content = '<div><table><tr>
<td colspan="17" style="width: 100.0000%;">
<div style="text-align: center;">FORM C</div>
<div style="text-align:center; font-size:14px;">[See Rule 4(C)]</div>
<div style="text-align: center;"></div>
<div style="text-align: center;">BONUS PAID TO EMPLOYEES FOR THE ACCOUNTING YEAR ENDING ON - '.$process_month.' </div>
</td>
</tr>
<tr>
<td colspan="7" style="width: 50.1181%;">
<div data-empty="true" style="text-align: left; font-size:12px;">Name of the Establishment : <strong>UPDATER SERVICES LIMITED</strong></div>
<p style="font-size:12px;">No. of Working Days in the Year : '.$days.'</p>
<p style="font-size:12px;">Month/Year : '.$process_month.'</p>
</td>
<td colspan="10" style="width: 59.8052%; font-size:12px;"> Name and address of establishment in under which contract <br> carried on : <strong>'.$project_name.'</strong></td>
</tr>
<tr>
<td class="fr-highlighted" colspan="7" style="width: 40.1181%; font-size:12px;">
<br>
</td>
<td class="fr-highlighted" style="width: 5.2434%;">
<div style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" colspan="5" style="width: 27.5023%;">
<div style="text-align: center; font-size:9px;">Deductions</div>
</td>
<td class="fr-highlighted" colspan="4" style="width: 26.2222%;">
<br>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 4.6815%;">
<div style="text-align: center; font-size:9px;">Sl.No</div>
</td>
<td class="fr-highlighted" style="width: 4.6815%;">
<div style="text-align: center; font-size:9px;">Name of the Employee</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 4.0824%;">
<div style="text-align: center; font-size:9px;">Father's Name</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 8.6656%;">
<div style="text-align: center; font-size:9px;">Wheather he has complete d 15 years of age at the beginning of the accounting year</div>
</td>
<td class="fr-highlighted" style="width: 5.5215%;">
<div style="text-align: center; font-size:9px;">Designation</div>
</td>
<td class="fr-highlighted" style="width: 6.2919%;">
<div style="text-align: center; font-size:9px;">No.of days worked in the year</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 6.2991%;">
<div style="text-align: center; font-size:9px;">Total salary or wage in respect of the accounti ng</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 6.2356%;">
<div style="text-align: center; font-size:9px;">Amount of Bonus payable under section 10 or 11 as the case may be</div>
</td>
<td class="fr-highlighted" style="width: 5.0793%;">
<div style="text-align: center; font-size:9px;">Puja bonus other customary during the accounting year</div>
<div data-empty="true" style="text-align: center; font-size:8px;">
</div>
</td>
<td class="fr-highlighted" style="width: 4.9895%;">
<div style="text-align: center; font-size:9px;">Interim bonus or bonus paid advance</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 5.9001%;">
<div style="text-align: center; font-size:9px;">1[ Amount of Income -tax deductio n ]</div>
</td>
<td class="fr-highlighted" style="width: 5.3046%;">
<div style="text-align: center; font-size:9px;">Deduction on account of financial loss, if any cause by misconduct of the employee</div>
<div data-empty="true" style="text-align: center;">
</div>
</td>
<td class="fr-highlighted" style="width: 6.0631%;">
<div style="text-align: center; font-size:9px;">2 [ Total sum deducted under Columns 9,10,10A and 11 ]</div>
<div data-empty="true" style="text-align: center;">
</div>
</td>
<td class="fr-highlighted" style="width: 6.5963%;">
<div style="text-align: center; font-size:9px;">Net amount payable ( Column8 minus Column 12 )</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 5.597%;">
<div style="text-align: center; font-size:9px;">Amount actually paid</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
<td class="fr-highlighted" style="width: 4.2092%;">
<div style="text-align: center; font-size:9px;">Date on<br>which paid</div>
<div data-empty="true" style="text-align: center;">
</div>
</td>
<td class="fr-highlighted" style="width: 6.8292%;">
<div style="text-align: center; font-size:9px;">Signature / Thumb impression of the employee</div>
<div data-empty="true" style="text-align: center;">
<br>
</div>
</td>
</tr>
<tr>
<td class="fr-highlighted" style="width: 4.6815%;">
<div data-empty="true" style="text-align: center; font-size:9px;">(1)</div>
</td>
<td class="fr-highlighted" style="width: 4.6815%;">
<div style="text-align: center; font-size:9px;">(2)</div>
</td>
<td class="fr-highlighted" style="width: 4.0824%;">
<div style="text-align: center; font-size:9px;">(3)</div>
</td>
<td class="fr-highlighted" style="width: 8.6656%;">
<div style="text-align: center; font-size:9px;">(4)</div>
</td>
<td class="fr-highlighted" style="width: 5.5215%;">
<div style="text-align: center; font-size:9px;">(5)</div>
</td>
<td class="fr-highlighted" style="width: 6.2919%;">
<div style="text-align: center; font-size:9px;">(6)</div>
</td>
<td class="fr-highlighted" style="width: 6.2991%;">
<div style="text-align: center; font-size:9px;">(7)</div>
</td>
<td class="fr-highlighted" style="width: 6.2356%;">
<div style="text-align: center; font-size:9px;">(8)</div>
</td>
<td class="fr-highlighted" style="width: 5.0793%;">
<div style="text-align: center; font-size:9px;">(9)</div>
</td>
<td class="fr-highlighted" style="width: 4.9895%;">
<div style="text-align: center; font-size:9px;">(10)</div>
</td>
<td class="fr-highlighted" style="width: 5.9001%;">
<div style="text-align: center; font-size:9px;">(10)(A)</div>
</td>
<td class="fr-highlighted" style="width: 5.3046%;">
<div style="text-align: center; font-size:9px;">(11)</div>
</td>
<td class="fr-highlighted" style="width: 6.0631%;">
<div style="text-align: center; font-size:9px;">(12)</div>
</td>
<td class="fr-highlighted" style="width: 6.5963%;">
<div style="text-align: center; font-size:9px;">(13)</div>
</td>
<td class="fr-highlighted" style="width: 5.597%;">
<div style="text-align: center; font-size:9px;">(14)</div>
</td>
<td class="fr-highlighted" style="width: 4.2092%;">
<div style="text-align: center; font-size:9px;">(15)</div>
</td>
<td class="fr-highlighted" style="width: 6.8292%;">
<div style="text-align: center; font-size:9px;">(16)</div>
</td>
</tr>';
$emp_data_content = "";
$row_count = 0;
foreach($payroll_data_rslt as $key => $val){
$key_no = (int)$key + 1;
$emp_code = $val["employee_code"];
$sum_bonus_gross = $bonus_arr[$emp_code]['sum_embonus']; //sum of values september to process month (col-8)
$tot_bonus_gross = round($sum_bonus_gross/8.33*100,0); //(col-7)
$bonus_gross = $sum_bonus_gross - $val['embonus_grs']; //add process_month values and sum of values(col-10) till prev month bonus gross
$pd_sum = $bonus_arr[$emp_code]['pd_tot']; //total paid days september to process month(col-6)
$sum_of_ded = $bonus_gross; //col(12)(add col(9+10+10a+11))
$tot_subtract_ded = $sum_bonus_gross - $sum_of_ded; // col(8-12)col(13)
$foot_pd_sum += $pd_sum;
$foot_bonus_gross += $bonus_gross;
$foot_tot_bonus_gross += $tot_bonus_gross;
$foot_sub_ded += $tot_subtract_ded;
$foot_sum_bonus_gross += $sum_bonus_gross;
$foot_sum_of_ded += $sum_of_ded;
if($val["stop_pay_code"] === "Y"){
$stop_pay = "H";
}else{
$stop_pay = "B";
}
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 12 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4.6815%; font-size:9px; text-align: center;">'.$val["emp_name"].'<br>'.$emp_code.'</td>
<td class="fr-highlighted" style="width: 4.0824%; font-size:9px; text-align: center;">'.$val["father_name"].'</td>
<td class="fr-highlighted" style="width: 8.6656%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 5.5215%; font-size:9px; text-align: center;">'.$val["position_name"].'</td>
<td class="fr-highlighted" style="width: 6.2919%; font-size:9px; text-align: right;">'.$pd_sum.'</td>
<td class="fr-highlighted" style="width: 6.2991%; font-size:9px; text-align: right;">'.$tot_bonus_gross.'</td>
<td class="fr-highlighted" style="width: 6.2356%; font-size:9px; text-align: right;">
'.$sum_bonus_gross.'<br>
</td>
<td class="fr-highlighted" style="width: 5.0793%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 4.9895%; font-size:9px; text-align: right;">
'.$bonus_gross.'<br>
</td>
<td class="fr-highlighted" style="width: 5.9001%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 5.3046%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 6.0631%; font-size:9px; text-align: right;">'.$sum_of_ded.'</td>
<td class="fr-highlighted" style="width: 6.5963%; font-size:9px; text-align: right;">'.$tot_subtract_ded.'<br>
</td>
<td class="fr-highlighted" style="width: 5.597%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 4.2092%; font-size:9px; text-align: center;">
'.$stop_pay.'<br>'.$val["bank_account_number"].'<br>
</td>
<td class="fr-highlighted" style="width: 6.8292%; font-size:9px; text-align: center;">
<br>
</td>
</tr>';
}
// TABLE FOOTER
$foot_sum_tr = '<tr>
<td class="fr-highlighted">
<div style="text-align: center;"><span style="font-size: 9px; font-weight:bold;">Grand Total</span></div>
</td>
<td class="fr-highlighted" style="width: 4.6815%; font-size:9px; text-align: center;"></td>
<td class="fr-highlighted" style="width: 4.0824%; font-size:9px; text-align: center;"></td>
<td class="fr-highlighted" style="width: 8.6656%; font-size:9px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 5.5215%; font-size:9px; text-align: center;"></td>
<td class="fr-highlighted" style="width: 6.2919%; font-size:9px; text-align: right; font-weight:bold;">'.$foot_pd_sum.'</td>
<td class="fr-highlighted" style="width: 6.2991%; font-size:9px; text-align: right; font-weight:bold;">'.$foot_tot_bonus_gross.'</td>
<td class="fr-highlighted" style="width: 6.2356%; font-size:8px; text-align: right; font-weight:bold">
'.round($foot_sum_bonus_gross).'<br>
</td>
<td class="fr-highlighted" style="width: 5.0793%; font-size:8px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 4.9895%; font-size:8px; text-align: right; font-weight:bold;">
'.round($foot_bonus_gross).'<br>
</td>
<td class="fr-highlighted" style="width: 5.9001%; font-size:8px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 5.3046%; font-size:8px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 6.0631%; font-size:8px; text-align: right; font-weight:bold;">'.$foot_sum_of_ded.'</td>
<td class="fr-highlighted" style="width: 6.5963%; font-size:8px; text-align: right; font-weight:bold;">'.$foot_sub_ded.'</td>
<td class="fr-highlighted" style="width: 5.597%; font-size:8px; text-align: center;">
<br>
</td>
<td class="fr-highlighted" style="width: 4.2092%; font-size:8px; text-align: center;"><br>
</td>
<td class="fr-highlighted" style="width: 6.8292%; font-size:8px; text-align: center;">
<br>
</td>
</tr>';
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
//FUNCTION FOR DOWNLOAD BY MISC PAYMENT PDF
public function misc_wage_rule($process_month,$personal_code,$project_id,$wage_rule_name,$project_name,$rules_rslt,$wbs_qry){
//QRY FOR GET A FORM SETTING BASED EMPLOYEE MASTER MISC COLUMNS(INPUTS)
$mi_inp_sel_qry = 'SELECT label_name,view_name,with_esi FROM cw_form_setting WHERE prime_module_id IN ("misc_input_fms") AND transaction_type IN (2,3) AND trans_status = "1" AND FIND_IN_SET("'.$this->logged_user_role.'",user_right_for) ORDER BY field_sort asc';
$mi_inp_sel_data = $this->db->query("CALL sp_a_run ('SELECT','$mi_inp_sel_qry')");
$mi_inp_sel_rslt = $mi_inp_sel_data->result_array();
$mi_inp_sel_data->next_result();
$label_key_arr = array_column($mi_inp_sel_rslt ?? [],"label_name","label_name");
$label_view_arr = array_column($mi_inp_sel_rslt ?? [],"view_name","label_name");
$label_esi_arr = array_column($mi_inp_sel_rslt ?? [],"with_esi","label_name");
$label_col_count = count($label_key_arr ?? []);
$table_name = "cw_misc_input_fms";
$lable_str = implode(',',$label_key_arr ?? []);
$label_qry_key = $table_name.'.'.implode(','.$table_name.'.',$label_key_arr ?? []);
//SELECT MISC INPUT FMS TABLE
$payroll_data_qry = 'SELECT '.$label_qry_key.','.$table_name.'.position,'.$table_name.'.net_pay,cw_employees.employee_code,cw_employees.emp_name,cw_employees.date_of_joining,cw_employees.emp_pf_no,cw_employees.emp_esi_no,cw_employees.father_name,cw_employees.bank_account_number,cw_employees.ifsc_code,'.$table_name.'.total_earnings,'.$table_name.'.total_deductions,'.$table_name.'.employee_esi,(CASE cw_employees.gender WHEN "1" THEN "Male" WHEN "2" THEN "Female" WHEN "3" THEN "Transgender" END) AS gender,(CASE '.$table_name.'.role WHEN "2" THEN "Monthly Salary" WHEN "3" THEN "Perday Salary" END) AS category FROM '.$table_name.' INNER JOIN cw_employees ON cw_employees.employee_code = '.$table_name.'.employee_code WHERE cw_employees.trans_status = 1 AND '.$table_name.'.trans_status = 1 AND '.$table_name.'.net_pay > 0 AND '.$table_name.'.sap_trans_status = 2 AND '.$table_name.'.process_month = "'.$process_month.'" and '.$table_name.'.personal_code = "'.$personal_code.'" and '.$table_name.'.project_id = "'.$project_id.'" '.$wbs_qry.'';
$payroll_data_info = $this->db->query("CALL sp_a_run ('SELECT','$payroll_data_qry')");
$payroll_data_rslt = $payroll_data_info->result_array();
$payroll_data_info->next_result();
$i = 0;
foreach($label_key_arr as $key => $value){
$rslt[$i] = "sum($table_name.$value) $value";
$i++;
}
//FOOTER QRY
$sum_column = implode(',',$rslt ?? []);
$sum_qry = 'SELECT '.$sum_column.',sum('.$table_name.'.net_pay) net_pay,sum('.$table_name.'.employee_esi)as employee_esi,sum('.$table_name.'.total_earnings)AS gross FROM '.$table_name.' INNER JOIN cw_employees ON cw_employees.employee_code = '.$table_name.'.employee_code WHERE cw_employees.trans_status = 1 AND '.$table_name.'.trans_status = 1 and '.$table_name.'.net_pay > 0 AND '.$table_name.'.sap_trans_status = 2 AND '.$table_name.'.process_month = "'.$process_month.'" and '.$table_name.'.personal_code = "'.$personal_code.'" and '.$table_name.'.project_id = "'.$project_id.'" '.$wbs_qry.'';
$sum_column_info = $this->db->query("CALL sp_a_run ('SELECT','$sum_qry')");
$sum_rslt = $sum_column_info->result_array();
$sum_column_info->next_result();
//COMPANY INFORMATION
$company_logo_qry = 'SELECT company_logo FROM cw_company_information WHERE trans_status = 1';
$company_logo_info = $this->db->query("CALL sp_a_run ('SELECT','$company_logo_qry')");
$logo_result = $company_logo_info->result_array();
$company_logo_info->next_result();
if(!count($payroll_data_rslt ?? [])){
echo json_encode(array('success' => FALSE,'message' => 'Transactions Data not Available.!'));
}else{
//RETRIEVE PROJECT NAME
$sap_positon_qry = 'SELECT position_code,position_name FROM cw_sap_position WHERE cw_sap_position.trans_status = "1"';
$sap_positon_data = $this->db->query("CALL sp_a_run ('SELECT','$sap_positon_qry')");
$sap_positon_rslt = $sap_positon_data->result_array();
$sap_positon_data->next_result();
$sap_position_arr = array_column($sap_positon_rslt ?? [],"position_name","position_code");
$emp_head_content = "";
$emp_data_content = "";
$row_count = 0;
$emp_head_content .= '
<td class="fr-highlighted" style="width: 2%">
<div style="text-align: center;"><span style="font-size: 7px;">Sl.No</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div style="text-align: center;"><span style="font-size: 7px;">Employee Code</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div style="text-align: center;"><span style="font-size: 7px;">Name</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div style="text-align: center;"><span style="font-size: 7px;">Designation</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div style="text-align: center;"><span style="font-size: 7px;">Bank AC No</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div style="text-align: center;"><span style="font-size: 7px;">IFSC Code</span></div>
</td>';
//DYNAMIC HEADER AND DATA CREATE
foreach($payroll_data_rslt as $array_key => $array_val){
$key_no = (int)$array_key + 1;
//DYNAMIC HEADER AND DATA CREATE
foreach($label_view_arr as $key => $val){
if(array_key_exists($key,$array_val ?? [])){
if((int)$array_key === 0){
$emp_head_content .= '<td class="fr-highlighted" style="line-height:22px; width:20px;">
<div style="text-align: center;"><span style="font-size: 7px;">'.$val.'</span></div>
</td>';
}
}
}
}
$emp_head_content .='<td class="fr-highlighted" style="width: 3%">
<div style="text-align: center;"><span style=" text-align: center; font-size: 7px; margin-right:15px; margin-left:15px;">Total Earnings</span></div>
</td>
<td class="fr-highlighted" style="width: 3%">
<div style="text-align: center;"><span style=" text-align: center; font-size: 7px; margin-right:15px; margin-left:15px;">Total Deductions</span></div>
</td>
<td class="fr-highlighted" style="width: 3%">
<div style="text-align: center;"><span style=" text-align: center; font-size: 7px; margin-right:15px; margin-left:15px;">Net Pay</span></div>
</td>
<td class="fr-highlighted" style="width: 8%">
<div style="text-align: center;"><span style="font-size: 7px; margin-right:15px; margin-left:15px;">Signature</span></div>
</td>';
$total_col_count = $label_col_count + 10;
$table_content ='<div><table><tr>
<td colspan="3" style="width: 21.6116%;">
<div style="text-align: center;"><img src="'.$logo_result[0]['company_logo'].'" style="width: 150px; height: 70px;" class="fr-fic fr-dib"></div>
</td>
<td colspan="'.$label_col_count.'" style="width: 100.000%;">
<div> UPDATER SERVICES LTD</div>
<div> Miscellaneous Payment Register</div>
</td>
</tr>
<tr>
<td class="fr-highlighted" colspan="'.$total_col_count.'" style="width: 100%;">
<p style="text-align: left;">Client Name : '.$project_name.' </p>
<p style="text-align: left;">Month & Year : '.$process_month.'</p>
<p style="text-align: left;">Payment Details for :
</p>
</td>
</tr>
<tr>'.$emp_head_content;
$row_count = 0;
foreach($payroll_data_rslt as $array_key => $array_val){
$key_no = (int)$array_key + 1;
$employee_code = $array_val['employee_code'];
$emp_name = $array_val['emp_name'];
$date_of_joining = $array_val['date_of_joining'];
$position = $array_val['position'];
$bank_ac_no = $array_val['bank_account_number'];
$ifsc_code = $array_val['ifsc_code'];
$total_earnings = $array_val['total_earnings'];
$sum_tot_earn += $total_earnings;
$total_deductions = $array_val['total_deductions'];
$sum_tot_ded += $total_deductions;
$position_name = $sap_position_arr[$position];
$net_pay = $array_val['net_pay'];
$sum_net_pay += $net_pay;
if($row_count === 0){
$emp_data_content .= $table_content ; // Insert page break
}
$row_count++;
// Add a page break every 10 rows
if($row_count % 10 === 0){
$emp_data_content .= '</table><div class="page-break"></div><table></tbody>'.$table_content ; // Insert page break
}
$emp_data_content .= '<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 7px;">'.$key_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;">'.$employee_code.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;">'.$emp_name.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;">'.$position_name.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;">'.$bank_ac_no.'</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;">'.$ifsc_code.'</span></div>
</td>';
//DYNAMIC HEADER AND DATA CREATE
foreach($label_view_arr as $key => $val){
if(array_key_exists($key,$array_val ?? [])){
$emp_data_content .= '<td class="fr-highlighted" style="width: 3%; line-height:30px;">
<div data-empty="true" style="text-align: right;"><span style="font-size: 7px;">'.round($array_val[$key]).'</span></div>
</td>';
}
}
$emp_data_content .='<td class="fr-highlighted" style="width: 3%">
<div data-empty="true" style="text-align: right;"><span style="font-size: 7px;">'.$total_earnings.'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%">
<div data-empty="true" style="text-align: right;"><span style="font-size: 7px;">'.$total_deductions.'</span></div>
</td>
<td class="fr-highlighted" style="width: 3%">
<div data-empty="true" style="text-align: right;"><span style="font-size: 7px;">'.$net_pay.'</span></div>
</td>
<td class="fr-highlighted" style="width: 8%">
<div data-empty="true" style="text-align: right;"><span style="font-size: 7px;"></span></div>
</td>
</tr>';
}
//FOOTER CONTENT
$tr_data ="";
foreach($sum_rslt as $col_name => $col_val){
foreach($col_val as $key_name => $val){
if(array_key_exists($key_name,$label_view_arr ?? [])){
$tr_data .='<td class="fr-highlighted" style="width: 3%">
<div data-empty="true" style="text-align: right;"><span style="font-size:12px; font-weight:bold;">'.round($val).'</span></div>
</td>';
}
}
}
$foot_sum_tr = '<tr>
<td class="fr-highlighted" style="width: 2%;">
<div style="text-align: center;"><span style="font-size: 7px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px; font-size:12px; font-weight:bold;">Grand Total</span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;"></span></div>
</td>
<td class="fr-highlighted" style="width: 4%">
<div data-empty="true" style="text-align: center;"><span style="font-size: 7px;"></span></div>
</td>'.
$tr_data.'
<td class="fr-highlighted" style="width: 4%"><span style="text-align: right; font-size:12px; font-weight:bold;">'.$sum_tot_earn.'</span></td>
<td class="fr-highlighted" style="width: 4%"><span style="text-align: right; font-size:12px; font-weight:bold;">'.$sum_tot_ded.'</span></td>
<td class="fr-highlighted" style="width: 4%"><span style="text-align: right; font-size:12px; font-weight:bold;">'.$sum_net_pay.'</span></td>
<td class="fr-highlighted" style="width: 4%"></td>
</tr>';
$this->wage_register_pdf_generate($table_content,$emp_data_content,$process_month,$personal_code,$wage_rule_name,$foot_sum_tr,$project_name,$project_id);
}
}
}
?>