payrollGenerationForAll.php

<?php
ob_start();
include_once("includes/Database.php");
include_once("includes/functions.php");

try{

if (isset($_POST['payrolltype'])){

    $payrollType = $_POST['payrolltype'];
    $region = $_POST['regionselect'];
    $month = $_POST['month'];
    $year = $_POST['year'];
    $emailIntimation = $_POST['sendemail'];
    $operator = $_POST['operator'];

    $lastMonth = "";
    $lastYear = "";

    if ($month=="1"){
        $lastMonth = "12";
        $lastYear=$year-1;
    }else{
        $lastMonth = $month-1;
        $lastYear=$year;
    }

    if ($lastMonth < 10){
        $lastMonth="0".$lastMonth;
    }

    if ($month < 10){
        $month="0".$month;
    }

    $daysLastMonth=cal_days_in_month(CAL_GREGORIAN,$lastMonth,$lastYear);

    $daysCurrentMonth=cal_days_in_month(CAL_GREGORIAN,$month,$year);

    $startLastDate = $year."-".$month."-01";
    $endLastDate = $year."-".$month."-".$daysCurrentMonth;
   
    $count = 0;
    if ($payrollType == "all"){ 

        $AllRegionalEmployeesArray = getRegionalEmployees($region);
        
        foreach($AllRegionalEmployeesArray as $row){

           $employee = $row['employee_internal_id'];

            if ($employee != "" && $employee != null && $employee != "null"){
                //generate payroll of one selected employee

                $employeeSalaryDetails = getEmployeeSalaryDetailsForPayroll($employee);

                //iterate through above object as [0]['basic_salary']

                if (isset($employeeSalaryDetails[0]['emp_id'])){////////
                    $count++;
                    $empId = $employeeSalaryDetails[0]['emp_id'];
                    $accountNo = $employeeSalaryDetails[0]['account_no'];
                    $ibanNo = $employeeSalaryDetails[0]['iban_no'];
                    // $projectAllowance = $employeeSalaryDetails[0]['project_allowance'];
                    // $housingAllowance = $employeeSalaryDetails[0]['housing_allowance'];
                    // $conveyanceAllowance = $employeeSalaryDetails[0]['conveyance_allowance'];
                    // $otherAllowance = $employeeSalaryDetails[0]['other_allowance'];
                    // $basicSalary = $employeeSalaryDetails[0]['basic_salary'];
                    // $wpsSalary = $employeeSalaryDetails[0]['wps_salary'];
                    $joinDate = $employeeSalaryDetails[0]['join_date'];
                    $terminationDate = $employeeSalaryDetails[0]['termination_date'];
                    $wpsSalary = 0;
                    $generatePayroll = false;
                    $joinDate = explode("-", $joinDate);
                    $joinDate = $joinDate[0]."-".$joinDate[1];
                    $terminationDate = explode("-", $terminationDate);
                    $terminationDateNotSet = $terminationDate[0]."-".$terminationDate[1];
                    $terminationDate = $terminationDate[0]."-".$terminationDate[1];
                    
                    $payrollDate =  $year."-".$month;
                    
                    if($terminationDateNotSet[0]==0 && $terminationDateNotSet[1]==0){
                        $generatePayroll = true;
                    }elseif($payrollDate <= $terminationDate){
                        $generatePayroll =true;
                    }

                    /*if(($year >= $joinDate[0] && $month >= $joinDate[1]) && $generatePayroll
                        )*/
                    if($payrollDate>=$joinDate && $generatePayroll){
                  
                    $absence = getAttendanceRecordsForMonthYear($employee,$region,'Absence',$month,$year);
                    
                    if ($absence == null || $absence == ""){
                        $absence = 0;
                    }

                    $unpaidLeave = getAttendanceRecordsForMonthYear($employee,$region,'UnpaidLeave',$month,$year);

                    if ($unpaidLeave == null || $unpaidLeave == ""){
                        $unpaidLeave = 0;
                    }

                    $Job = getAttendanceRecordsForMonthYear($employee,$region,'Job',$month,$year);

                    if ($Job == null || $Job == ""){
                        $Job = 0;
                    }
                    
                    
                    // A = basic_salary x ((total days - (absence + unpaid leave)) / total days)
                    $basicSalary = round( $employeeSalaryDetails[0]['basic_salary'] * (($daysCurrentMonth - ($absence + $unpaidLeave)) / $daysCurrentMonth));

                    // B = housing_allowance x ((total days - (absence + unpaid leave)) / total days)
                    $housingAllowance = round( $employeeSalaryDetails[0]['housing_allowance'] * (($daysCurrentMonth - ($absence + $unpaidLeave)) / $daysCurrentMonth));

                    // C = conveyance_allowance x ((total days - (absence + unpaid leave)) / total days)
                    $conveyanceAllowance = round( $employeeSalaryDetails[0]['conveyance_allowance'] * (($daysCurrentMonth - ($absence + $unpaidLeave)) / $daysCurrentMonth));

                    // D = other_allowance x ((total days - (absence + unpaid leave)) / total days)
                    $otherAllowance = round( $employeeSalaryDetails[0]['other_allowance'] * (($daysCurrentMonth - ($absence + $unpaidLeave)) / $daysCurrentMonth));

                    // E = project_allowance x ((total days - (absence + unpaid leave)) / total days)
                    $projectAllowance = $employeeSalaryDetails[0]['project_allowance'] * ($Job);

                    $netSalary = $projectAllowance+$housingAllowance+$conveyanceAllowance+$otherAllowance+$basicSalary+$wpsSalary;
                    //arrears of last month = salary of last month - payments of last month
                    

                    if ($netSalary==null || $netSalary == ""){
                        $netSalary=0;
                    }
                    
                    $lastMonthPayments = getLastMonthPayments($employee,$lastMonth, $lastYear);

                    $totalPreviousPayments = $lastMonthPayments[0]['totalamount'];
                    
                    if ($totalPreviousPayments == null || $totalPreviousPayments == ""){
                        $totalPreviousPayments = 0;
                    }
                    
                    $lastMonthSalary = getLastMonthSalary($empId, $lastMonth, $lastYear);

                    if (isset($lastMonthSalary[0]['totalsalary'])){

                        $lastSalary = $lastMonthSalary[0]['totalsalary'];

                        if ($lastSalary == "" || $lastSalary == null){
                            $lastSalary = 0;
                        }

                    }else{
                        $lastSalary = 0;
                    }


                    $arrears = $lastSalary - $totalPreviousPayments;

                    

                    $grossSalary = $netSalary + $arrears;
                    // total payments this month
                    $currentMonthPayments = getLastMonthPayments($employee, $month, $year);
                    $totalCurrentMonthPayments = $currentMonthPayments[0]['totalamount'];

                    if ($totalCurrentMonthPayments == null || $totalCurrentMonthPayments == ""){
                        $totalCurrentMonthPayments = 0;
                    }
                    $deductions = $totalCurrentMonthPayments;
                    $insertStatus = InsertPayrollData($empId, $accountNo, $ibanNo, $projectAllowance, $housingAllowance, $conveyanceAllowance, $otherAllowance, $basicSalary, $wpsSalary, $deductions, $arrears, $grossSalary, $month, $year,$operator);
                    // $insertStatus = true;
                    if ($insertStatus==true){

                        if ($emailIntimation == "notsend"){
                        
                        }else if ($emailIntimation == "send"){

                            $empEmailRow = GetEmployeeEmailForPayroll($empId);

                            // $mailto = $empEmailRow[0]['employee_email'];

                            $mailto = "adnan@npm.works";

                            $empName = getemployeename($empId);

                            $salaryDetailsEmail = "<b>Account No:</b> $accountNo<br><b>Food Allowance:</b> $projectAllowance<br><b>Housing Allowance: </b>$housingAllowance<br><b>Conveyance Allowance: </b>$conveyanceAllowance<br><b>Other Allowance: </b>$otherAllowance<br><b>Basic Salary: </b>$basicSalary<br><b>Arrears: </b>$arrears<br><b>Payments Made: </b>$totalPreviousPayments<br><b>Gross Salary: </b>$grossSalary";
                            
                            //The header can include their name, ID and the month,year for payroll.
                            $headEmail = "Salary Information | Employee ID: $employee | Name: $empName | Month: $month | Year: $year";
                            
                            $subject = $headEmail;
                            $headers = "From: NPM\r\n";
                            $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
                            $messageCommon = "Dear Employee,<br><br>";
                            $messageCommon .= "Please find below the details of your salary for $month-$year,<br/><br/>";
                            $messageCommon .= $salaryDetailsEmail."<br/><br/>";  //sending table via email
                            $messageCommon .= "Regards,<br>";
                            $messageCommon .= "NPM";

                            if (@mail ($mailto, $subject, $messageCommon, $headers)){
                                // echo $EMAILINTIMATION='SENT';
                            }else{
                                // echo $EMAILINTIMATION='NOT SENT';
                            }

                            //email sending code goes here...

                            
                        }

                        
                    /*if ($insertStatus==true){*/
                    }else{
                       
                    }
                }//if($year>=$joinDate[0] && $month >=$joinDate[1] && & $terminationDate[0]>=$year && $terminationDate[1] >= $month  ){
                    else{
                        ///payroll not generated  due to joining date or terminination date
                    }
                }else{ /////if (isset($employeeSalaryDetails[0]['emp_id']))
                    ///// if (isset($employeeSalaryDetails[0]['emp_id']))
                }   

                
            }else{
                
            }

    }

    echo json_encode("success");

    }else{

        echo json_encode("error");

    }

}else{
    echo json_encode("error");
}

}catch(Exception $e){

    echo json_encode("error");

}
?>