Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
fpdf	[ DIR ]	drwxrwxrwx
phpexcel	[ DIR ]	drwxrwxrwx
phpmailer	[ DIR ]	drwxrwxrwx
reports	[ DIR ]	drwxrwxrwx
api_sendmail.php	2.22 KB	-rwxrwxrwx
api_sendmail1.php	2.03 KB	-rwxrwxrwx
api_sendsms.php	1.08 KB	-rwxrwxrwx
attendance.php	13.66 KB	-rwxrwxrwx
attendance_report.php	40.23 KB	-rwxrwxrwx
attendance_report_attn_stat_mn...	16.79 KB	-rw-rw-r--
attendance_report_attn_stat_sa...	18.77 KB	-rw-rw-r--
attendance_report_datewise.php	5.59 KB	-rwxrwxrwx
attendance_report_excel.php	14.66 KB	-rwxrwxrwx
attendance_report_month_detail...	2.76 KB	-rwxrwxrwx
attendance_report_month_summar...	4.01 KB	-rwxrwxrwx
attendance_report_monthwise_in...	6.85 KB	-rwxrwxrwx
attendance_report_monthwise_su...	5.09 KB	-rwxrwxrwx
attendance_report_monthwise_su...	4.13 KB	-rwxrwxrwx
attendance_report_yearwise_sum...	4.56 KB	-rwxrwxrwx
attendance_statement_2023-03.x...	11.39 KB	-rw-r--r--
attendance_statement_2024-01.x...	60.03 KB	-rw-r--r--
attendance_statement_2024-02.x...	48.48 KB	-rw-r--r--
attendance_statement_2024-03.x...	10.73 KB	-rw-r--r--
attendance_statement_2024-04.x...	10.56 KB	-rw-r--r--
attendance_statement_2024-05.x...	10.63 KB	-rw-r--r--
attendance_statement_2024-06.x...	10.63 KB	-rw-r--r--
attendance_statement_2024-07.x...	47.43 KB	-rw-r--r--
attendance_statement_2024-08.x...	11.54 KB	-rw-r--r--
attendance_statement_2024-09.x...	43.78 KB	-rw-r--r--
attendance_statement_2024-10.x...	11.15 KB	-rw-r--r--
attendance_statement_2024-11.x...	43.35 KB	-rw-r--r--
attendance_statement_2024-12.x...	9.32 KB	-rw-r--r--
attendance_statement_2025-01.x...	16.99 KB	-rw-r--r--
attendance_statement_salary_.x...	7.04 KB	-rw-r--r--
attendance_statement_salary_20...	7.06 KB	-rw-r--r--
attendance_statement_salary_20...	7.36 KB	-rw-r--r--
attendance_statement_salary_20...	19.89 KB	-rw-r--r--
attendance_statement_salary_20...	18.32 KB	-rw-r--r--
attendance_statement_salary_20...	18.06 KB	-rw-r--r--
attendance_statement_salary_20...	17.78 KB	-rw-r--r--
attendance_statement_salary_20...	17.63 KB	-rw-r--r--
attendance_statement_salary_20...	7.72 KB	-rw-r--r--
attendance_statement_salary_20...	7.67 KB	-rw-r--r--
attendance_statement_salary_20...	7.72 KB	-rw-r--r--
attendance_statement_salary_20...	7.52 KB	-rw-r--r--
attendance_statement_salary_20...	7.06 KB	-rw-r--r--
attendance_statement_salary_20...	7.36 KB	-rw-r--r--
attendance_statement_salary_20...	7.53 KB	-rw-r--r--
attendance_status.php	20.13 KB	-rwxrwxrwx
attendance_status_deepak.php	9.38 KB	-rw-rw-r--
attendance_status_ihf.php	9.38 KB	-rwxrwxrwx
backup_data.php	903 B	-rwxrwxrwx
control.php	5.78 KB	-rwxrwxrwx
departments.php	8.79 KB	-rwxrwxrwx
departments_logo_upload.php	679 B	-rwxrwxrwx
documents.php	4.16 KB	-rwxrwxrwx
employees.php	17.28 KB	-rwxrwxrwx
employees2.php	14.04 KB	-rw-rw-r--
employees_form.php	20.19 KB	-rw-rw-r--
employees_photo_upload.php	647 B	-rwxrwxrwx
employees_print_id_card.php	2.76 KB	-rw-rw-r--
employees_print_nda_form.php	12.86 KB	-rw-rw-r--
employees_report_excel.php	5.07 KB	-rw-rw-r--
expense.php	10.79 KB	-rwxrwxrwx
expense_advance.php	4.69 KB	-rwxrwxrwx
expense_advance2.php	4.55 KB	-rw-rw-r--
expense_report.php	3.26 KB	-rwxrwxrwx
expense_report_daywise_details...	4.46 KB	-rwxrwxrwx
expense_report_daywise_summary...	5.27 KB	-rwxrwxrwx
expense_report_details_date.ph...	5.32 KB	-rwxrwxrwx
expense_report_details_date_su...	5.43 KB	-rwxrwxrwx
expense_report_details_head.ph...	22.11 KB	-rwxrwxrwx
expense_report_details_head_su...	22.13 KB	-rwxrwxrwx
expense_report_headwise_detail...	18.32 KB	-rwxrwxrwx
expense_report_headwise_summar...	18.32 KB	-rwxrwxrwx
expense_report_monthwise_detai...	3.3 KB	-rwxrwxrwx
expense_report_monthwise_summa...	3.3 KB	-rwxrwxrwx
expense_report_statement.php	5.69 KB	-rwxrwxrwx
expense_report_statement_date....	6.15 KB	-rwxrwxrwx
expense_report_statement_excel...	19.74 KB	-rw-rw-r--
expense_report_statement_excel...	32.6 KB	-rwxrwxrwx
expense_report_statement_excel...	32.79 KB	-rw-rw-r--
expense_report_statement_mnth....	4.88 KB	-rwxrwxrwx
expense_report_statement_year....	4.86 KB	-rwxrwxrwx
expense_report_summary.php	18.43 KB	-rwxrwxrwx
expense_statement_monthly_.xls...	6.04 KB	-rw-r--r--
expense_statement_monthly_2023...	10.08 KB	-rw-r--r--
expense_statement_monthly_2024...	10 KB	-rw-r--r--
expense_statement_monthly_2024...	8.99 KB	-rw-r--r--
expense_statement_monthly_2024...	9.16 KB	-rw-r--r--
expense_statement_monthly_2024...	8.87 KB	-rw-r--r--
expense_statement_monthly_2024...	30.05 KB	-rw-r--r--
expense_statement_monthly_2024...	9 KB	-rw-r--r--
expense_statement_monthly_2024...	9.61 KB	-rw-r--r--
expense_statement_monthly_2024...	11.03 KB	-rw-r--r--
expense_statement_monthly_2024...	10.92 KB	-rw-r--r--
expense_statement_monthly_2024...	9.65 KB	-rw-r--r--
expense_statement_monthly_2024...	9.66 KB	-rw-r--r--
expense_statement_monthly_2024...	10.37 KB	-rw-r--r--
grievance_status.php	5.44 KB	-rw-rw-r--
header_menu.php	3.46 KB	-rwxrwxrwx
header_note.php	5.06 KB	-rwxrwxrwx
holidays.php	6.19 KB	-rwxrwxrwx
home_appraisals.php	185 B	-rwxrwxrwx
home_attendance.php	26.81 KB	-rwxrwxrwx
home_clients.php	10.62 KB	-rwxrwxrwx
home_dashboard.php	236 B	-rwxrwxrwx
home_employees.php	9.47 KB	-rwxrwxrwx
home_events.php	9.71 KB	-rwxrwxrwx
home_expenses.php	27.27 KB	-rwxrwxrwx
home_flash.php	2.38 KB	-rwxrwxrwx
home_inventory.php	3.14 KB	-rwxrwxrwx
home_movements.php	9.03 KB	-rwxrwxrwx
home_note_count.php	6.75 KB	-rw-rw-r--
home_salary.php	12.81 KB	-rwxrwxrwx
home_task.php	6.15 KB	-rwxrwxrwx
home_userlogs.php	2.02 KB	-rw-rw-r--
home_work_entry.php	15.08 KB	-rwxrwxrwx
home_work_flash.php	2.36 KB	-rwxrwxrwx
home_work_view.php	11.96 KB	-rwxrwxrwx
login.php	3.3 KB	-rwxrwxrwx
logout.php	261 B	-rwxrwxrwx
mc_print.php	9.54 KB	-rwxrwxrwx
mcf_status.php	2.87 KB	-rw-rw-r--
office_logisys3_oums_2024-09-2...	20.57 MB	-rw-r--r--
oums_sms_push.php	18.18 KB	-rwxrwxrwx
oums_sms_send.php	5.39 KB	-rwxrwxrwx
pg_app_edit.php	5.17 KB	-rwxrwxrwx
popup_empl_events.php	3.53 KB	-rw-rw-r--
popup_empl_salary.php	2.67 KB	-rw-rw-r--
popup_work_entry.php	3.14 KB	-rw-rw-r--
popup_work_review.php	1.55 KB	-rw-rw-r--
salary.php	24.44 KB	-rwxrwxrwx
salary_statement.php	40.09 KB	-rw-rw-r--
salary_statement_2024-05.xlsx	18.57 KB	-rw-r--r--
salary_statement_2024-06.xlsx	18.43 KB	-rw-r--r--
salary_statement_2024-07.xlsx	17.89 KB	-rw-r--r--
salary_statement_2024-08.xlsx	17.46 KB	-rw-r--r--
salary_statement_2024-09.xlsx	16.97 KB	-rw-r--r--
salary_statement_2024-10.xlsx	16.94 KB	-rw-r--r--
salary_statement_2024-11.xlsx	17.36 KB	-rw-r--r--
salary_statement_month_excel.p...	21.36 KB	-rw-rw-r--
send_mail.php	383 B	-rwxrwxrwx
send_sms.php	203 B	-rwxrwxrwx
sendsmsapi.php	759 B	-rwxrwxrwx
staff_move.php	8.55 KB	-rwxrwxrwx
status_report.php	23.7 KB	-rwxrwxrwx
status_report_03022018.php	14.76 KB	-rwxrwxrwx
status_report_import_attendanc...	3.27 KB	-rwxrwxrwx
sys_connect.php	492 B	-rwxrwxrwx
sys_connect_old.php	123 B	-rwxrwxrwx
sys_connect_pget.php	311 B	-rwxrwxrwx
sys_employees.php	2.55 KB	-rwxrwxrwx
sys_grid_data.php	805 B	-rwxrwxrwx
sys_grid_navbar.php	1.72 KB	-rwxrwxrwx
sys_mainphp.php	6.92 KB	-rwxrwxrwx
sys_mode.php	780 B	-rwxrwxrwx
sys_module.php	580 B	-rwxrwxrwx
sys_modules.php	2.47 KB	-rwxrwxrwx
sys_session.php	1.04 KB	-rwxrwxrwx
task_reminder.php	16.45 KB	-rwxrwxrwx
task_review.php	11.37 KB	-rwxrwxrwx
upcoming_events.php	8.79 KB	-rw-rw-r--
user_departments.php	4.09 KB	-rwxrwxrwx
user_logs.php	5.8 KB	-rwxrwxrwx
user_password.php	3.67 KB	-rwxrwxrwx
user_password_request.php	2.09 KB	-rwxrwxrwx
user_rights.php	7.34 KB	-rwxrwxrwx
user_setup.php	10.79 KB	-rwxrwxrwx
user_validate.php	3.07 KB	-rwxrwxrwx
work_assign.php	5.86 KB	-rw-rw-r--
work_done_report.xlsx	7.91 KB	-rw-r--r--
work_done_report_empl.xlsx	6.57 KB	-rw-r--r--
work_entry.php	9.04 KB	-rwxrwxrwx
work_entry_org.php	3.48 KB	-rwxrwxrwx
work_entry_report.php	2.71 KB	-rwxrwxrwx
work_entry_report_appraisal.ph...	8.79 KB	-rw-rw-r--
work_entry_report_assn_work_ex...	8.79 KB	-rw-rw-r--
work_entry_report_assn_work_vi...	9.03 KB	-rw-rw-r--
work_entry_report_statement.ph...	4.63 KB	-rwxrwxrwx
work_entry_report_work_done_as...	9.34 KB	-rw-rw-r--
work_entry_report_work_done_as...	9.46 KB	-rw-rw-r--
work_entry_report_work_done_em...	8.91 KB	-rw-rw-r--
work_entry_report_work_done_em...	8.91 KB	-rw-rw-r--
work_entry_report_work_done_ex...	8.79 KB	-rw-rw-r--
work_entry_report_work_done_li...	9.43 KB	-rw-rw-r--
work_entry_report_work_done_li...	8.91 KB	-rw-rw-r--
work_entry_report_work_done_st...	4.65 KB	-rw-rw-r--
work_review.php	6.08 KB	-rwxrwxrwx
workentry_report.php	9.43 KB	-rw-rw-r--
xattendance_report_01.php	7.77 KB	-rwxrwxrwx
xattendance_report_02.php	4.49 KB	-rwxrwxrwx
xattendance_report_03.php	6 KB	-rwxrwxrwx
xattendance_report_04.php	5.18 KB	-rwxrwxrwx
xattendance_report_05.php	4.84 KB	-rwxrwxrwx
xget_master_info.php	801 B	-rwxrwxrwx

Code Editor : status_report.php

<?php
include("sys_session.php");
include("sys_mainphp.php");
include("sys_connect.php");
include("fpdf/fpdf.php");

$resp_mesg = "";
$resp_stat = "";
$resp_file = "";
$dept_code = "";
$attn_date = date('Y-m-d');

include("status_report_import_attendance.php");

$pdf = new FPDF('P', 'mm', 'A4');
$pdf->SetMargins(15, 15);
$pdf->SetFont('Arial', '', 9);

//ALL ClientS SUMMARY	
$mysql = "select * from masdept where ifnull(fdeptstat,'F')='T' order by fdeptname";
$myres = mysqli_query($mycon, $mysql);
$mycnt = mysqli_num_rows($myres);
if ($mycnt != 0) {
    $i = 1;
    $line_no = 0;
    while ($row = mysqli_fetch_assoc($myres)) {
        $dept_code = $row['fdeptcode'];
        if ($line_no == 0 || $line_no % 36 == 0) {
            $rept_date = date('d/m/Y', strtotime($attn_date));
            $header_dept_code = $dept_code;
            $header_dept_name = get_dept_name($dept_code);

$pdf->AddPage();

$pdf->SetFont('Arial', 'B', 11);
            $pdf->Cell(0, 7, "LOGISYS", 0, 1, "C");
            $line_no++;

$pdf->SetFont('Arial', 'B', 10);
            $pdf->Cell(0, 7, "ATTENDANCE SUMMARY", 0, 1, "C");
            $line_no++;
            $pdf->Cell(0, 7, "DATE: {$rept_date}", 0, 1, "C");
            $line_no++;

$pdf->SetFont('Arial', 'B', 9);

$x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->MultiCell(10, 7, "Sl. No.", 1, "C");

$pdf->SetXY($x + 10, $y);
            $pdf->MultiCell(15, 7, "Client Code", 1, "C");

$pdf->SetXY($x + 25, $y);
            $pdf->MultiCell(100, 14, "Client Name", 1, "C");

$pdf->SetXY($x + 125, $y);
            $pdf->MultiCell(40, 7, "Total", 1, "C");

$pdf->SetXY($x + 125, $y + 7);
            $pdf->MultiCell(10, 7, "Empl.", 1, "C");

$pdf->SetXY($x + 135, $y + 7);
            $pdf->MultiCell(10, 7, "Pr.", 1, "C");

$pdf->SetXY($x + 145, $y + 7);
            $pdf->MultiCell(10, 7, "Ab.", 1, "C");

$pdf->SetXY($x + 155, $y + 7);
            $pdf->MultiCell(10, 7, "C.L.", 1, "C");

$pdf->SetXY($x + 165, $y);
            $pdf->MultiCell(20, 14, "Remarks", 1, "C");
            $line_no++;
        }
        $pdf->SetFont('Arial', '', 9);
        $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$row['fdeptcode']}", 1, 0, "C");
        $pdf->Cell(100, 7, "{$row['fdeptname']}", 1, 0, "L");

$mysql1 = "select count(*) as ltotempl,
        sum(case when fattnstat in ('PR','P1','P2','PO','CD','D1','D2') then 1 else 0 end) as ltotalpr,
        sum(case when fattnstat ='AB' then 1 else 0 end) as ltotalab,
        sum(case when fattnstat ='CL' then 1 else 0 end) as ltotalcl 
        from attendance where fdeptcode='$dept_code' and fattndate=current_date 
        group by fdeptcode";
        $myres1 = mysqli_query($mycon, $mysql1);
        $mycnt1 = mysqli_num_rows($myres1);
        if ($mycnt1 == 0) {
            $pdf->Cell(10, 7, "-", 1, 0, "C");
            $pdf->Cell(10, 7, "-", 1, 0, "C");
            $pdf->Cell(10, 7, "-", 1, 0, "C");
            $pdf->Cell(10, 7, "-", 1, 0, "C");
            $pdf->Cell(20, 7, "Pending", 1, 0, "C");
        } else {
            while ($row1 = mysqli_fetch_assoc($myres1)) {
                $pdf->Cell(10, 7, "{$row1['ltotempl']}", 1, 0, "C");
                $pdf->Cell(10, 7, "{$row1['ltotalpr']}", 1, 0, "C");
                $pdf->Cell(10, 7, "{$row1['ltotalab']}", 1, 0, "C");
                $pdf->Cell(10, 7, "{$row1['ltotalcl']}", 1, 0, "C");
                $pdf->Cell(20, 7, "", 1, 0, "C");
            }
        }
        $pdf->ln();
        $line_no++;
        $i++;
    }
}

//LOGISYS DAYWISE
$mysql = "select (case when fempltype='P' then 'LOGS' else attendance.fdeptcode end) as fdeptcode,
attendance.femplcode,femplname,fattndate,attendance.fattnstat,fstatdesc,attendance.flogitime,attendance.flogotime,
flogidiff,flogodiff,fworkhour from attendance,masempl,masattn_stat,masdesn where 
fattndate=current_date and attendance.femplcode=masempl.femplcode and attendance.fattnstat=masattn_stat.fattnstat 
and attendance.fdeptcode=masattn_stat.fdeptcode and fempltype='P' and masempl.fempldesn=masdesn.fempldesn 
order by fempltype,fdesnordr,femplname";

$myres = mysqli_query($mycon, $mysql);
$mycnt = mysqli_num_rows($myres);
if ($mycnt != 0) {
    $line_no = 0;
    while ($row = mysqli_fetch_assoc($myres)) {
        if ($dept_code <> $row['fdeptcode']) {
            $line_no = 0;
            $i = 1;
        }

if ($line_no == 0 || $line_no % 36 == 0) {
            $dept_code = $row['fdeptcode'];
            $rept_date = date('d/m/Y', strtotime($attn_date));
            $header_dept_code = $dept_code;
            $header_dept_name = get_dept_name($dept_code);

$pdf->AddPage();
            $pdf->SetFont('Arial', 'B', 11);
            $pdf->Cell(0, 7, "LOGISYS", 0, 1, "C");
            $line_no++;

$pdf->SetFont('Arial', 'B', 10);
            $pdf->Cell(0, 7, "ATTENDANCE STATUS (DAYWISE)", 0, 1, "C");
            $line_no++;
            $pdf->Cell(95, 7, "Client Name: {$header_dept_name}", 0, 0, "L");
            $pdf->Cell(90, 7, "Date: {$rept_date}", 0, 0, "R");
            $pdf->ln();
            $line_no++;

$pdf->SetFont('Arial', 'B', 9);

$x = $pdf->GetX();
            $y = $pdf->GetY();
            $pdf->MultiCell(10, 7, "Sl. No.", 1, "C");

$pdf->SetXY($x + 10, $y);
            $pdf->MultiCell(15, 7, "Empl. Code", 1, "C");

$pdf->SetXY($x + 25, $y);
            $pdf->MultiCell(50, 14, "Employee Name", 1, "C");

$pdf->SetXY($x + 75, $y);
            $pdf->MultiCell(25, 14, "Status", 1, "C");

$pdf->SetXY($x + 100, $y);
            $pdf->MultiCell(35, 7, "Log In", 1, "C");

$pdf->SetXY($x + 100, $y + 7);
            $pdf->MultiCell(15, 7, "Time", 1, "C");

$pdf->SetXY($x + 115, $y + 7);
            $pdf->MultiCell(20, 7, "Remarks", 1, "C");

$pdf->SetXY($x + 135, $y);
            $pdf->MultiCell(35, 7, "Log Out", 1, "C");

$pdf->SetXY($x + 135, $y + 7);
            $pdf->MultiCell(15, 7, "Time", 1, "C");

$pdf->SetXY($x + 150, $y + 7);
            $pdf->MultiCell(20, 7, "Remarks", 1, "C");

$pdf->SetXY($x + 170, $y);
            $pdf->MultiCell(15, 7, "Work Hours", 1, "C");

$line_no++;
        }
        $empl_code = $row['femplcode'];
        $pdf->SetFont('Arial', '', 9);
        $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$row['femplcode']}", 1, 0, "C");
        $pdf->Cell(50, 7, "{$row['femplname']}", 1, 0, "L");
        $pdf->Cell(25, 7, "{$row['fstatdesc']}", 1, 0, "C");
        $attn_stat = strtolower($row['fattnstat']);
        if ($attn_stat == "ab" || $attn_stat == "cl" || $attn_stat == "hd" || $attn_stat == "wo") {
            $pdf->Cell(15, 7, "-", 1, 0, "C");
            $pdf->Cell(20, 7, "-", 1, 0, "C");
            $pdf->Cell(15, 7, "-", 1, 0, "C");
            $pdf->Cell(20, 7, "-", 1, 0, "C");
            $pdf->Cell(15, 7, "-", 1, 0, "C");
        } else {
            $logi_time = $row['flogitime'];
            $logi_diff = $row['flogidiff'];
            $pdf->Cell(15, 7, "{$logi_time}", 1, 0, "C");
            if ($logi_diff > "00:00:00") {
                $pdf->Cell(20, 7, "{$logi_diff} delay", 1, 0, "C");
            } elseif ($logi_diff < "00:00:00") {
                $pdf->Cell(20, 7, "{$logi_diff} early", 1, 0, "C");
            } else {
                $pdf->Cell(20, 7, "-", 1, 0, "C");
            }

$logo_time = $row['flogotime'];
            $logo_diff = $row['flogodiff'];

if ($logo_time == "00:00:00") {
                $pdf->Cell(15, 7, "-", 1, 0, "C");
                $pdf->Cell(20, 7, "Pending", 1, 0, "C");
            } else {
                if ($logo_diff > "00:00:00") {
                    $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
                    $pdf->Cell(20, 7, "{$logo_diff} delay", 1, 0, "C");
                } elseif ($logo_diff < "00:00:00") {
                    $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
                    $pdf->Cell(20, 7, "{$logo_diff} early", 1, 0, "C");
                } elseif ($logo_diff == "00:00:00") {
                    $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
                    $pdf->Cell(20, 7, "-", 1, 0, "C");
                } else {
                    $pdf->Cell(15, 7, "-", 1, 0, "C");
                    $pdf->Cell(20, 7, "-", 1, 0, "C");
                }
            }

$work_hour = $row['fworkhour'];
            if ($work_hour > "00:00:00") {
                $pdf->Cell(15, 7, "{$work_hour}", 1, 0, "C");
            } else {
                $pdf->Cell(15, 7, "-", 1, 0, "C");
            }
        }
        $i++;
        $pdf->ln();
        $line_no++;
    }
}

//LOGISYS INDIVIDUAL REPORT
// $attn_mnth = substr($attn_date, 0, 7);
// $mysql = "select masempl.*,masdesn.* from masempl,masdesn where masempl.fempldesn=masdesn.fempldesn and fempltype='P'
// and femplstat='T' and masempl.fdeleted<>'T' order by fdesnordr,masdesn.fempldesn,fempltype,femplname";
// $myres = mysqli_query($mycon, $mysql);
// $mycnt = mysqli_num_rows($myres);
// if ($mycnt != 0) {
//     $line_no = 0;
//     $i = 1;
//     while ($myrow = mysqli_fetch_assoc($myres)) {
//         if ($empl_code <> $myrow['femplcode']) {
//             $line_no = 0;
//             $i = 1;
//         }

//         $empl_code = $myrow['femplcode'];
//         $dept_code = $myrow['fdeptcode'];

//         $year = substr($attn_mnth, 0, 4);
//         $mnth = substr($attn_mnth, 5, 2);
//         $days = cal_days_in_month(CAL_GREGORIAN, $mnth, $year);
//         $days = date("d");
//         $strt_date = date("01-m-Y");
//         $curr_date = date("d/m/Y");

//         for ($j = 1; $j <= $days; $j++) {
//             if ($line_no == 0 || $line_no % 36 == 0) {
//                 $header_dept_code = $dept_code;
//                 $header_dept_name = get_dept_name($dept_code);
//                 $header_empl_code = $empl_code;
//                 $header_empl_name = get_empl_name($empl_code);

//                 $pdf->AddPage();
//                 $pdf->SetFont('Arial', 'B', 11);
//                 $pdf->Cell(0, 7, "LOGISYS", 0, 1, "C");
//                 $line_no++;

//                 $pdf->SetFont('Arial', 'B', 10);
//                 $pdf->Cell(0, 7, "ATTENDANCE STATUS (INDIVIDUAL)", 0, 1, "C");
//                 $line_no++;
//                 $pdf->Cell(90, 7, "Employee Name: {$header_empl_name}", 0, 0, "L");
//                 $pdf->Cell(90, 7, "Date Range: {$strt_date} to {$curr_date}", 0, 0, "R");
//                 $pdf->ln();
//                 $line_no++;

//                 $pdf->SetFont('Arial', 'B', 9);

//                 $x = $pdf->GetX();
//                 $y = $pdf->GetY();
//                 $pdf->MultiCell(10, 7, "Sl. No.", 1, "C");

//                 $pdf->SetXY($x + 10, $y);
//                 $pdf->MultiCell(20, 14, "Date", 1, "C");

//                 $pdf->SetXY($x + 30, $y);
//                 $pdf->MultiCell(40, 14, "Status", 1, "C");

//                 $pdf->SetXY($x + 70, $y);
//                 $pdf->MultiCell(45, 7, "Log In", 1, "C");

//                 $pdf->SetXY($x + 70, $y + 7);
//                 $pdf->MultiCell(15, 7, "Time", 1, "C");

//                 $pdf->SetXY($x + 85, $y + 7);
//                 $pdf->MultiCell(30, 7, "Remarks", 1, "C");

//                 $pdf->SetXY($x + 115, $y);
//                 $pdf->MultiCell(45, 7, "Log Out", 1, "C");

//                 $pdf->SetXY($x + 115, $y + 7);
//                 $pdf->MultiCell(15, 7, "Time", 1, "C");

//                 $pdf->SetXY($x + 130, $y + 7);
//                 $pdf->MultiCell(30, 7, "Remarks", 1, "C");

//                 $pdf->SetXY($x + 160, $y);
//                 $pdf->MultiCell(20, 14, "Work Hours", 1, "C");

//                 $line_no++;
//             }

//             $pdf->SetFont('Arial', '', 9);
//             $attn_stat = "";
//             $caln_date = $attn_mnth . '-' . substr('0' . $j, -2, 2);
//             $mysql1 = "select masattn_stat.fstatdesc, attendance.* from masattn_stat,attendance 
//             where femplcode='$empl_code' and fattndate='$caln_date' 
//             and attendance.fdeptcode=masattn_stat.fdeptcode 
//             and attendance.fattnstat=masattn_stat.fattnstat ";
//             $myres1 = mysqli_query($mycon, $mysql1);
//             $myrow1 = mysqli_fetch_assoc($myres1);
//             $mycnt1 = mysqli_num_rows($myres1);
//             $prin_date = date('d/m/Y', strtotime($caln_date));
//             if ($mycnt1 == 0) {
//                 $pdf->Cell(10, 7, "{$i}", 1, 0, "C");            //SL NO		
//                 $pdf->Cell(20, 7, "{$prin_date}", 1, 0, "C");    //DATE										
//                 $pdf->Cell(40, 7, "Pending", 1, 0, "C");         //STATUS
//                 $pdf->Cell(15, 7, "-", 1, 0, "C");                //LOGIN TIME																																
//                 $pdf->Cell(30, 7, "-", 1, 0, "C");                //LOGIN DIFF																																
//                 $pdf->Cell(15, 7, "-", 1, 0, "C");                //LOGOUT TIME																																
//                 $pdf->Cell(30, 7, "-", 1, 0, "C");                //LOGOUT DIFF																																
//                 $pdf->Cell(20, 7, "-", 1, 0, "C");                //WORK HOURS																																
//             } else {
//                 $attn_stat = strtolower($myrow1['fattnstat']);
//                 $attn_desc = $myrow1['fstatdesc'];
//                 $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
//                 $pdf->Cell(20, 7, "{$prin_date}", 1, 0, "C");
//                 $pdf->Cell(40, 7, "{$attn_desc}", 1, 0, "C");

//                 if ($attn_stat == "ab" || $attn_stat == "cl" || $attn_stat == "hd" || $attn_stat == "wo") {
//                     $pdf->Cell(15, 7, "-", 1, 0, "C");
//                     $pdf->Cell(30, 7, "-", 1, 0, "C");
//                     $pdf->Cell(15, 7, "-", 1, 0, "C");
//                     $pdf->Cell(30, 7, "-", 1, 0, "C");
//                     $pdf->Cell(20, 7, "-", 1, 0, "C");
//                 } else {
//                     $logi_time = $myrow1['flogitime'];
//                     $logi_diff = $myrow1['flogidiff'];

//                     $pdf->Cell(15, 7, "{$logi_time}", 1, 0, "C");
//                     if ($logi_diff > "00:00:00") {
//                         $pdf->Cell(30, 7, "{$logi_diff} delay", 1, 0, "C");
//                     } elseif ($logi_diff < "00:00:00") {
//                         $pdf->Cell(30, 7, "{$logi_diff} early", 1, 0, "C");
//                     } else {
//                         $pdf->Cell(30, 7, "-", 1, 0, "C");
//                     }

//                     $logo_time = $myrow1['flogotime'];
//                     $logo_diff = $myrow1['flogodiff'];

//                     if ($logo_time == "00:00:00") {
//                         $pdf->Cell(15, 7, "-", 1, 0, "C");
//                         $pdf->Cell(30, 7, "Pending", 1, 0, "C");
//                     } else {
//                         if ($logo_diff > "00:00:00") {
//                             $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                             $pdf->Cell(30, 7, "{$logo_diff} delay", 1, 0, "C");
//                         } elseif ($logo_diff < "00:00:00") {
//                             $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                             $pdf->Cell(30, 7, "{$logo_diff} early", 1, 0, "C");
//                         } elseif ($logo_diff == "00:00:00") {
//                             $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                             $pdf->Cell(30, 7, "-", 1, 0, "C");
//                         } else {
//                             $pdf->Cell(15, 7, "-", 1, 0, "C");
//                             $pdf->Cell(30, 7, "-", 1, 0, "C");
//                         }
//                     }

//                     $work_hour = $myrow1['fworkhour'];
//                     if ($work_hour > "00:00:00") {
//                         $pdf->Cell(20, 7, "{$work_hour}", 1, 0, "C");
//                     } else {
//                         $pdf->Cell(20, 7, "-", 1, 0, "C");
//                     }
//                 }
//             }
//             $i++;
//             $pdf->ln();
//             $line_no++;
//         }
//     }
// }

// //NON LOGISYS SUMMARY
// $mysql = "select (case when fempltype='P' then 'LOGS' else attendance.fdeptcode end) as fdeptcode,
// attendance.femplcode,femplname,fattndate,attendance.fattnstat,fstatdesc,attendance.flogitime,attendance.flogotime,
// flogidiff,flogodiff,fworkhour from attendance,masempl,masattn_stat,masdesn where 
// fattndate='$attn_date' and attendance.femplcode=masempl.femplcode and attendance.fattnstat=masattn_stat.fattnstat 
// and attendance.fdeptcode=masattn_stat.fdeptcode and fempltype<>'P' and masempl.fempldesn=masdesn.fempldesn 
// order by attendance.fdeptcode,fempltype,fdesnordr,femplname";

// $myres = mysqli_query($mycon, $mysql);
// $mycnt = mysqli_num_rows($myres);
// if ($mycnt != 0) {
//     $line_no = 0;

//     while ($row = mysqli_fetch_assoc($myres)) {
//         if ($dept_code <> $row['fdeptcode']) {
//             $line_no = 0;
//             $i = 1;
//         }

//         if ($line_no == 0 || $line_no % 36 == 0) {
//             $dept_code = $row['fdeptcode'];
//             $rept_date = date('d/m/Y', strtotime($attn_date));
//             $header_dept_code = $dept_code;
//             $header_dept_name = get_dept_name($dept_code);

//             $pdf->AddPage();
//             $pdf->SetFont('Arial', 'B', 11);
//             $pdf->Cell(0, 7, "LOGISYS", 0, 1, "C");
//             $line_no++;

//             $pdf->SetFont('Arial', 'B', 10);
//             $pdf->Cell(0, 7, "ATTENDANCE STATUS (DAYWISE)", 0, 1, "C");
//             $line_no++;
//             $pdf->Cell(95, 7, "Client Name: {$header_dept_name}", 0, 0, "L");
//             $pdf->Cell(90, 7, "Date: {$rept_date}", 0, 0, "R");
//             $pdf->ln();
//             $line_no++;

//             $pdf->SetFont('Arial', 'B', 9);

//             $x = $pdf->GetX();
//             $y = $pdf->GetY();
//             $pdf->MultiCell(10, 7, "Sl. No.", 1, "C");

//             $pdf->SetXY($x + 10, $y);
//             $pdf->MultiCell(15, 7, "Empl. Code", 1, "C");

//             $pdf->SetXY($x + 25, $y);
//             $pdf->MultiCell(50, 14, "Employee Name", 1, "C");

//             $pdf->SetXY($x + 75, $y);
//             $pdf->MultiCell(25, 14, "Status", 1, "C");

//             $pdf->SetXY($x + 100, $y);
//             $pdf->MultiCell(35, 7, "Log In", 1, "C");

//             $pdf->SetXY($x + 100, $y + 7);
//             $pdf->MultiCell(15, 7, "Time", 1, "C");

//             $pdf->SetXY($x + 115, $y + 7);
//             $pdf->MultiCell(20, 7, "Remarks", 1, "C");

//             $pdf->SetXY($x + 135, $y);
//             $pdf->MultiCell(35, 7, "Log Out", 1, "C");

//             $pdf->SetXY($x + 135, $y + 7);
//             $pdf->MultiCell(15, 7, "Time", 1, "C");

//             $pdf->SetXY($x + 150, $y + 7);
//             $pdf->MultiCell(20, 7, "Remarks", 1, "C");

//             $pdf->SetXY($x + 170, $y);
//             $pdf->MultiCell(15, 7, "Work Hours", 1, "C");

//             $line_no++;
//         }
//         $empl_code = $row['femplcode'];
//         $pdf->SetFont('Arial', '', 9);
//         $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
//         $pdf->Cell(15, 7, "{$row['femplcode']}", 1, 0, "C");
//         $pdf->Cell(50, 7, "{$row['femplname']}", 1, 0, "L");
//         $pdf->Cell(25, 7, "{$row['fstatdesc']}", 1, 0, "C");
//         $attn_stat = strtolower($row['fattnstat']);
//         if ($attn_stat == "ab" || $attn_stat == "cl" || $attn_stat == "hd" || $attn_stat == "wo") {
//             $pdf->Cell(15, 7, "-", 1, 0, "C");
//             $pdf->Cell(20, 7, "-", 1, 0, "C");
//             $pdf->Cell(15, 7, "-", 1, 0, "C");
//             $pdf->Cell(20, 7, "-", 1, 0, "C");
//             $pdf->Cell(15, 7, "-", 1, 0, "C");
//         } else {
//             $logi_time = $row['flogitime'];
//             $logi_diff = $row['flogidiff'];
//             $pdf->Cell(15, 7, "{$logi_time}", 1, 0, "C");
//             if ($logi_diff > "00:00:00") {
//                 $pdf->Cell(20, 7, "{$logi_diff} delay", 1, 0, "C");
//             } elseif ($logi_diff < "00:00:00") {
//                 $pdf->Cell(20, 7, "{$logi_diff} early", 1, 0, "C");
//             } else {
//                 $pdf->Cell(20, 7, "-", 1, 0, "C");
//             }

//             $logo_time = $row['flogotime'];
//             $logo_diff = $row['flogodiff'];

//             if ($logo_time == "00:00:00") {
//                 $pdf->Cell(15, 7, "-", 1, 0, "C");
//                 $pdf->Cell(20, 7, "Pending", 1, 0, "C");
//             } else {
//                 if ($logo_diff > "00:00:00") {
//                     $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                     $pdf->Cell(20, 7, "{$logo_diff} delay", 1, 0, "C");
//                 } elseif ($logo_diff < "00:00:00") {
//                     $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                     $pdf->Cell(20, 7, "{$logo_diff} early", 1, 0, "C");
//                 } elseif ($logo_diff == "00:00:00") {
//                     $pdf->Cell(15, 7, "{$logo_time}", 1, 0, "C");
//                     $pdf->Cell(20, 7, "-", 1, 0, "C");
//                 } else {
//                     $pdf->Cell(15, 7, "-", 1, 0, "C");
//                     $pdf->Cell(20, 7, "-", 1, 0, "C");
//                 }
//             }

//             $work_hour = $row['fworkhour'];
//             if ($work_hour > "00:00:00") {
//                 $pdf->Cell(15, 7, "{$work_hour}", 1, 0, "C");
//             } else {
//                 $pdf->Cell(15, 7, "-", 1, 0, "C");
//             }
//         }
//         $i++;
//         $pdf->ln();
//         $line_no++;
//     }
// }
$mail_fil1 = "reports/status_report1.pdf";
$mail_fil2 = "reports/status_report2.pdf";
$mail_fil3 = "reports/status_report3.pdf";
$pdf->output($mail_fil1, 'F');
$pdf->output($mail_fil2, 'F');
$pdf->output($mail_fil3, 'F');

$mail_main = "raghu.s@logisys.org";
$mail_copy = "raghu.s@logisys.org";
$mail_bccy = "raghu.s@logisys.org";
$mail_subj = "Daily Attendance Status - " . date('d/m/Y');
$mail_text = "<div style='background:#666666;padding:5px; width:800px;'>
                <table border='1' cellpadding='5' cellspacing='0' width='100%'>
                <tr><td colspan=9  class='text-center text-bold'>Daily attendance status - " . date('d/m/Y') . "</td></tr>
                <tr>
                <td class='text-center'>Sl. No.</td>
                <td class='text-center'>Client</td>
                <td class='text-center'>Client Name</td>
                <td class='text-center'>Total</td>
                <td class='text-center'>Pr.</td>
                <td class='text-center'>Ab.</td>
                <td class='text-center'>Cl.</td>
                <td class='text-center'>Remarks</td>
                </tr>
                </table>
                </div>";

include("api_sendmail.php");
$resp_stat = send_mail($mail_main, $mail_copy, $mail_bccy, $mail_subj, $mail_text, $mail_fil1, $mail_fil2, $mail_fil3);
echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file));

${this.title}

Code Editor : status_report.php