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 : salary.php

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

$resp_mesg = "";
$resp_stat = "F";
$resp_file = "";

if ($_POST["load_data"] == 'dept_data') {
    if ($type_id == 'ADMIN') {
        $mysql = "select * from masdept where fsalrenbl='T' order by fdeptname";
    } else {
        $mysql = "select * from masdept inner join masdept_user on masdept.fdeptcode = masdept_user.fdeptcode and fusercode='$user_id' order by fdeptname";
    }
    $myres = mysqli_query($mycon, $mysql);
    if (mysqli_num_rows($myres) > 1) {
        echo "<option value=0>--Select--</option>";
    }
    while ($myrow = mysqli_fetch_assoc($myres)) {
        echo "<option value='$myrow[fdeptcode]'>$myrow[fdeptname] [$myrow[fdeptcode]]</option>";
    }
}

if ($_POST["load_data"] == 'salr_mnth') {
    $dept_code = $_POST["dept_code"];
    $mysql = "select left(fattndate,7) as lsalrmnth from attendance where fdeptcode like '$dept_code' group by left(fattndate,7)  order by left(fattndate,7) desc";
    $myres = mysqli_query($mycon, $mysql);
    echo "<option value='0'>--Select--</option>	";
    if (mysqli_num_rows($myres) != 0) {
        while ($myrow = mysqli_fetch_assoc($myres)) {
            echo "<option value='$myrow[lsalrmnth]'>$myrow[lsalrmnth]</option>";
        }
    }
}

if ($_POST["load_data"] == 'last_updt') {
    $dept_code = $_POST["dept_code"];
    $salr_mnth = $_POST["salr_mnth"];
    $mysql = "select * from salary where fdeptcode='$dept_code' and fsalrmnth='$salr_mnth'";
    $myres = mysqli_query($mycon, $mysql);
    $myrows = array();
    while ($r = mysqli_fetch_assoc($myres)) {
        $myrows = $r;
    }
    echo json_encode($myrows);
}

if ($_POST["load_data"] == 'save_data') {
    $dept_code = $_POST["dept_code"];
    $salr_mnth = $_POST["salr_mnth"];

$mysql = "select * from masdept where fdeptcode like '$dept_code'";
    $myres = mysqli_query($mycon, $mysql);
    while ($myrow = mysqli_fetch_assoc($myres)) {
        $code_rate = $myrow['fcoderate'];
    }

$year = substr($salr_mnth, 0, 4);
    $mnth = substr($salr_mnth, 5, 2);
    $mnth_days = cal_days_in_month(CAL_GREGORIAN, $mnth, $year);

$mysql1 = "select fdeptcode,femplcode, 
    count(case when fattnstat='pr' then fattnstat end) as ldayspr,
    count(case when fattnstat='p1' then fattnstat end) as ldaysp1,
    count(case when fattnstat='p2' then fattnstat end) as ldaysp2,
    count(case when fattnstat='d1' then fattnstat end) as ldaysd1,
    count(case when fattnstat='d2' then fattnstat end) as ldaysd2,
    count(case when fattnstat='po' then fattnstat end) as ldayspo,
    count(case when fattnstat='cd' then fattnstat end) as ldayscd,
    count(case when fattnstat='hw' then fattnstat end) as ldayshw,
    count(case when fattnstat='cl' then fattnstat end) as ldayscl,
    count(case when fattnstat='ab' then fattnstat end) as ldaysab,
    sum(case when fattnstat='cd' then fcodepack end) as lpackcd,
    sum(case when fattnstat='pr' then fovertime end) as lhourot,
    sum(case when fattnstat='p1' then fovertime end) as lhouro1,
    sum(case when fattnstat='p2' then fovertime end) as lhouro2,
    sum(ftrvlamnt) as lamntta 
    from attendance 
    where fdeptcode like '$dept_code' and left(fattndate,7)='$salr_mnth' 
    group by fdeptcode, femplcode";

$myres1 = mysqli_query($mycon, $mysql1);
    while ($myrow1 = mysqli_fetch_assoc($myres1)) {
        $dept_code = $myrow1['fdeptcode'];
        $empl_code = $myrow1['femplcode'];

$mysql2 = "select * from masempl where femplcode='$empl_code' and ifnull(fsalrcomp,'F')='T'";
        $myres2 = mysqli_query($mycon, $mysql2);
        while ($myrow2 = mysqli_fetch_assoc($myres2)) {
            $base_salr = $myrow2['fsalrbase'];
            $days_salr = $myrow2['fsalrdays'];
            $hour_salr = $myrow2['fsalrhour'];
            $salr_type = $myrow2['fsalrtype'];

$days_pr = 0;
            $days_p1 = 0;
            $days_p2 = 0;
            $salr_pr = 0;

$days_po = 0;
            $days_d1 = 0;
            $days_d2 = 0;

$days_hw = 0;
            $salr_hw = 0;

$days_cl = 0;

$days_ab = 0;
            $salr_ab = 0;

$salr_ta = 0;

$hour_ot = 0;
            $salr_ot = 0;

$pack_cd = 0;
            $salr_cd = 0;

$totl_salr = 0;
            $salr_remk = "";

$days_pr = $myrow1['ldayspr'] + $myrow1['ldaysp1'] + $myrow1['ldaysp2'] + ($myrow1['ldaysd1'] / 2) + ($myrow1['ldaysd2'] / 2);

$days_po = $myrow1['ldayspo'];
            $days_cd = $myrow1['ldayscd'];
            $days_hw = $myrow1['ldayshw'];
            $days_cl = $myrow1['ldayscl'];
            $days_ab = $myrow1['ldaysab'] + ($myrow1['ldaysd1'] / 2) + ($myrow1['ldaysd2'] / 2);

$salr_ta = $myrow1['lamntta'];
            $hour_ot = $myrow1['lhourot'];
            $pack_cd = $myrow1['lpackcd'];

$salr_ot = $hour_ot * $hour_salr;

$salr_cd = $pack_cd * $code_rate;

$salr_pr = $days_pr * $days_salr;

if ($salr_type == 'C') {
                $salr_hw = 0; //$days_hw * $days_salr;
                $salr_ab = $days_ab * $days_salr;
                $totl_salr = $base_salr + $salr_hw + $salr_ta + $salr_ot - $salr_ab;
            }

if ($salr_type == 'D') {
                $totl_salr = $salr_pr + $salr_ta + $salr_ot + $salr_cd;
            }

$mysql3 = "select * from salary where fdeptcode='$dept_code' and femplcode='$empl_code' and fsalrmnth='$salr_mnth'";

$myres3 = mysqli_query($mycon, $mysql3);
            $mycnt3 = mysqli_num_rows($myres3);
            if ($mycnt3 == 0) {
                $mysql4 = "";
                $mysql4 .= "insert into salary (";
                $mysql4 .= "fsalrmnth, fdeptcode, femplcode, fsalrbase, fsalrdays, fsalrhour, ftotlsalr, ";
                $mysql4 .= "fdayspr, fdayspo, fdayscl, fdayscd, fpackcd, fsalrcd, fdayshw, fsalrhw, ";
                $mysql4 .= "fdaysab, fsalrab, fsalrta, fhourot, fsalrot, fsalrremk, fupdtuser, fupdttime) ";
                $mysql4 .= "values('$salr_mnth', '$dept_code', '$empl_code', '$base_salr', '$days_salr', '$hour_salr', '$totl_salr', ";
                $mysql4 .= "'$days_pr', '$days_po', '$days_cl', '$days_cd', '$pack_cd', '$salr_cd', '$days_hw', '$salr_hw', ";
                $mysql4 .= "'$days_ab', '$salr_ab', '$salr_ta', '$hour_ot', '$salr_ot', '$salr_remk', '$user_id', now())";
            } else {
                $mysql4 = "";
                $mysql4 .= "update salary set ";
                $mysql4 .= "fdeptcode='$dept_code',fsalrbase='$base_salr', fsalrdays='$days_salr', fsalrhour='$hour_salr', ftotlsalr='$totl_salr', ";
                $mysql4 .= "fdayspr='$days_pr', fdayspo='$days_po', fdayshw='$days_hw', fdayscl='$days_cl', ";
                $mysql4 .= "fdayscd='$days_cd', fpackcd='$pack_cd', fsalrcd='$salr_cd', fdayshw='$days_hw', fsalrhw='$salr_hw', ";
                $mysql4 .= "fdaysab='$days_ab', fsalrab='$salr_ab', fsalrta='$salr_ta', fhourot='$hour_ot', fsalrot='$salr_ot', ";
                $mysql4 .= "fsalrremk='$salr_remk', fupdtuser='$user_id', fupdttime=now() ";
                $mysql4 .= "where femplcode='$empl_code' and fsalrmnth='$salr_mnth'";
            }
            $myres4 = mysqli_query($mycon, $mysql4);
        }
    }
    $resp_mesg = "Salary updated!";
    $resp_stat = "T";
    echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file));
}

if ($_POST["load_data"] == 'dele_data') {
    $dept_code = $_POST["dept_code"];
    $salr_mnth = $_POST["salr_mnth"];
    if ($type_id == "ADMIN" or $type_id == "CHIEF") {
        $mysql = "delete from salary where fdeptcode='$dept_code' and fsalrmnth='$salr_mnth'";
        $myres = mysqli_query($mycon, $mysql);
        $resp_mesg = "Salary details deleted!";
        $resp_stat = "T";
    } else {
        $resp_mesg = "Salary details could not be deleted! Contact Administrator";
        $resp_stat = "F";
    }

echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file));
}

if ($_POST["load_data"] == 'view_data') {
    $dept_code = $_POST["dept_code"];
    $salr_mnth = $_POST["salr_mnth"];

$mysql = "select upper(date_format(concat(sl.fsalrmnth,'-01'),'%M %Y')) as lsalrmnth,dp.fdeptcode,dp.fdeptname,dp.fdeptshrt,sl.femplcode,em.femplname,sl.fsalrbase,sl.fsalrdays,
    sl.fdayspr,sl.fdayspo,sl.fdayscl,sl.fsalrta,sl.fhourot,sl.fsalrot,
    sl.fdayshw,sl.fsalrhw,sl.fdaysab,sl.fsalrab,sl.fdayscd,sl.fpackcd,sl.fsalrcd,
    sl.ftotlsalr
    from salary sl
    inner join masdept dp on sl.fdeptcode = dp.fdeptcode     
    inner join masempl em on sl.femplcode = em.femplcode and em.fdeleted<>'T'
    inner join masdesn ds on dp.fdepttype = ds.fdepttype and em.fempldesn = ds.fempldesn 
    where fsalrmnth='$salr_mnth' and sl.fdeptcode='$dept_code' and ftotlsalr<>0 
    order by sl.fdeptcode,fempltype,fdesnordr,ds.fempldesn,femplname";
    $myres = mysqli_query($mycon, $mysql);
    $mycnt = mysqli_num_rows($myres);
    if ($mycnt == 0) {
        $resp_mesg = "No data found!";
        $resp_stat = "F";
    } else {
        $resp_stat = "T";
        $i = 1;
        $dept_code = "";
        $year = substr($salr_mnth, 0, 4);
        $mnth = substr($salr_mnth, 5, 2);

$line_no = 0;
        $totl_pr = 0;
        $totl_cl = 0;
        $totl_hw = 0;
        $totl_hwsalr = 0;
        $totl_ta = 0;
        $totl_ot = 0;
        $totl_otsalr = 0;
        $totl_ab = 0;
        $totl_absalr = 0;
        $totl_salr = 0;
        $totl_cd_days = 0;
        $totl_cd = 0;
        $totl_cdslr = 0;
        require("fpdf/fpdf.php");
        $pdf = new FPDF('L', 'mm', 'A4');
        while ($myrow = mysqli_fetch_assoc($myres)) {
            if ($dept_code <> $myrow['fdeptcode'] && $dept_code != "") {
                $totl_hwsalr = number_format((float)$totl_hwsalr, 2, '.', '');
                $totl_ta = number_format((float)$totl_ta, 2, '.', '');
                $totl_ot = number_format((float)$totl_ot, 1, '.', '');
                $totl_otsalr = number_format((float)$totl_otsalr, 2, '.', '');
                $totl_absalr = number_format((float)$totl_absalr, 2, '.', '');
                $totl_cdsalr = number_format((float)$totl_cdsalr, 2, '.', '');
                $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(115, 7, "Total", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_pr}", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_cl}", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_ta}", 1, 0, "R");
                $pdf->Cell(10, 7, "{$totl_hw}", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_hwsalr}", 1, 0, "R");
                $pdf->Cell(10, 7, "{$totl_ab}", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_absalr}", 1, 0, "R");
                $pdf->Cell(10, 7, "{$totl_cd}", 1, 0, "C");
                $pdf->Cell(15, 7, "{$totl_cdsalr}", 1, 0, "R");
                $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
                $pdf->Cell(20, 7, "", 1, 0, "L");
                $pdf->ln();
                $line_no++;

$line_no = 0;
                $i = 1;
                $totl_pr = 0;
                $totl_cl = 0;
                $totl_hw = 0;
                $totl_hwsalr = 0;
                $totl_ta = 0;
                $totl_ot = 0;
                $totl_otsalr = 0;
                $totl_ab = 0;
                $totl_absalr = 0;
                $totl_salr = 0;
            }

if ($line_no == 0 || $line_no % 24 == 0) {
                $pdf->AddPage();
                $pdf->SetFont('Arial', 'B', 10);
                $pdf->Cell(0, 7, "SALARY STATEMENT - {$myrow['lsalrmnth']}", 0, 1, "C");
                $line_no++;
                $pdf->Cell(0, 7, "{$myrow['fdeptname']}", 0, 1, "C");
                $line_no++;

$pdf->SetFont('Arial', 'B', 9);
                $pdf->Cell(10, 14, "Sl No", 1, 0, "C");
                $pdf->Cell(75, 14, "Employee Name", 1, 0, "C");

$x = $pdf->GetX();
                $y = $pdf->GetY();
                $pdf->MultiCell(15, 7, "Salary / Month", 1, "C");

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

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

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

$pdf->SetXY($x + 50, $y);
                $pdf->MultiCell(15, 7, "Travel Allow.", 1, "C");

$pdf->SetXY($x + 65, $y);
                $pdf->MultiCell(25, 7, "Holiday Work", 1, "C");

$pdf->SetXY($x + 65, $y + 7);
                $pdf->MultiCell(10, 7, "Days", 1, "C");

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

$pdf->SetXY($x + 90, $y);
                $pdf->MultiCell(25, 7, "Absent deduct.", 1, "C");

$pdf->SetXY($x + 90, $y + 7);
                $pdf->MultiCell(10, 7, "Days", 1, "C");

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

$pdf->SetXY($x + 115, $y);
                $pdf->MultiCell(35, 7, "Coding work", 1, "C");

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

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

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

$pdf->SetXY($x + 150, $y);
                $pdf->MultiCell(20, 14, "Net Salary", 1, "C");

$pdf->SetXY($x + 170, $y);
                $pdf->Cell(20, 14, "Remarks", 1, 0, "C");
                $pdf->ln();
                $line_no++;
            }

$pdf->SetFont('Arial', '', 9);
            $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
            $pdf->Cell(75, 7, "[{$myrow['femplcode']}] {$myrow['femplname']}", 1, 0, "L");
            $pdf->Cell(15, 7, "{$myrow['fsalrbase']}", 1, 0, "R");
            $pdf->Cell(15, 7, "{$myrow['fsalrdays']}", 1, 0, "R");
            $pdf->Cell(10, 7, "{$myrow['fdayspr']}" + "{$myrow['fdayspo']}", 1, 0, "C");
            $pdf->Cell(10, 7, "{$myrow['fdayscl']}", 1, 0, "C");
            $pdf->Cell(15, 7, "{$myrow['fsalrta']}", 1, 0, "R");
            $pdf->Cell(10, 7, "{$myrow['fdayshw']}", 1, 0, "C");
            $pdf->Cell(15, 7, "{$myrow['fsalrhw']}", 1, 0, "R");
            $pdf->Cell(10, 7, "{$myrow['fdaysab']}", 1, 0, "C");
            $pdf->Cell(15, 7, "{$myrow['fsalrab']}", 1, 0, "R");
            $pdf->Cell(10, 7, "{$myrow['fdayscd']}", 1, 0, "C");
            $pdf->Cell(10, 7, "{$myrow['fpackcd']}", 1, 0, "C");
            $pdf->Cell(15, 7, "{$myrow['fsalrcd']}", 1, 0, "R");
            $pdf->Cell(20, 7, "{$myrow['ftotlsalr']}", 1, 0, "R");
            $pdf->Cell(20, 7, "{$myrow['fsalrremk']}", 1, 0, "L");
            $pdf->ln();
            $line_no++;

$totl_pr = $totl_pr + $myrow["fdayspr"];
            $totl_cl = $totl_cl + $myrow["fdayscl"];
            $totl_hw = $totl_hw + $myrow["fdayshw"];
            $totl_hwsalr = $totl_hwsalr + $myrow["fsalrhw"];
            $totl_ta = $totl_ta + $myrow["fsalrta"];
            $totl_ot = $totl_ot + $myrow["fhourot"];
            $totl_otsalr = $totl_otsalr + $myrow["fsalrot"];
            $totl_ab = $totl_ab + $myrow["fdaysab"];
            $totl_absalr = $totl_absalr + $myrow["fsalrab"];
            $totl_cd_days = $totl_cd_days + $myrow["fdayscd"];
            $totl_cd = $totl_cd + $myrow["fpackcd"];
            $totl_cdsalr = $totl_cdsalr + $myrow["fsalrcd"];
            $totl_salr = $totl_salr + $myrow["ftotlsalr"];
            $i++;
        }
        $totl_hwsalr = number_format((float)$totl_hwsalr, 2, '.', '');
        $totl_ta = number_format((float)$totl_ta, 2, '.', '');
        $totl_ot = number_format((float)$totl_ot, 1, '.', '');
        $totl_otsalr = number_format((float)$totl_otsalr, 2, '.', '');
        $totl_absalr = number_format((float)$totl_absalr, 2, '.', '');
        $totl_cdsalr = number_format((float)$totl_cdsalr, 2, '.', '');
        $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(115, 7, "Total", 1, 0, "C");
        $pdf->Cell(10, 7, "{$totl_pr}", 1, 0, "C");
        $pdf->Cell(10, 7, "{$totl_cl}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$totl_ta}", 1, 0, "R");
        $pdf->Cell(10, 7, "{$totl_hw}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$totl_hwsalr}", 1, 0, "R");
        $pdf->Cell(10, 7, "{$totl_ab}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$totl_absalr}", 1, 0, "R");
        $pdf->Cell(10, 7, "{$totl_cd_days}", 1, 0, "C");
        $pdf->Cell(10, 7, "{$totl_cd}", 1, 0, "C");
        $pdf->Cell(15, 7, "{$totl_cdsalr}", 1, 0, "R");
        $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
        $pdf->Cell(20, 7, "", 1, 0, "L");
        $pdf->ln();
        $line_no++;

$resp_stat = "T";
        $resp_file = 'reports/' . $year . ' ' . $mnth . ' salary_statement.pdf';
        $pdf->output($resp_file, 'F');
    }
    echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file));
}

if ($_POST["load_data"] == 'view_rept') {
    $dept_code = $_POST["dept_code"];
    $salr_mnth = $_POST["salr_mnth"];
    $dept_bank = "0";

$mysql = "select * from masdept where fdeptcode='$dept_code'";
    $myres = mysqli_query($mycon, $mysql);
    while ($myrow = mysqli_fetch_assoc($myres)) {
        $dept_bank = $myrow['fdeptbank'];
    }

//other bank
    $mysql = "";
    $mysql .= "select masempl.*,salary.* from masempl,salary where ";
    $mysql .= "masempl.femplcode=salary.femplcode and fsalrmnth='$salr_mnth' and salary.fdeptcode like '$dept_code' ";
    $mysql .= "and ftotlsalr<>0 and ifnull(fbankcode,'0')<>'$dept_bank' ";
    $mysql .= "order by salary.fdeptcode,fifsccode, femplname";
    $myres = mysqli_query($mycon, $mysql);
    $mycnt = mysqli_num_rows($myres);
    if ($mycnt == 0) {
        $resp_mesg = "No data found!";
        $resp_stat = "F";
    } else {
        $resp_stat = "T";
        $i = 1;
        $year = substr($salr_mnth, 0, 4);
        $mnth = substr($salr_mnth, 5, 2);
        $mnth_days = cal_days_in_month(CAL_GREGORIAN, $mnth, $year);

$line_no = 0;
        $totl_salr = 0;
        require("fpdf/fpdf.php");
        $pdf = new FPDF('L', 'mm', 'A4');
        while ($myrow = mysqli_fetch_assoc($myres)) {
            if ($dept_code <> $myrow['fdeptcode'] && $dept_code != "") {
                $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(255, 7, "Grand Total", 1, 0, "R");
                $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
                $pdf->ln();
                $line_no++;

$line_no = 0;
                $i = 1;
                $totl_salr = 0;
            }

$header_dept_name = get_dept_name($myrow['fdeptcode']);

$header_salr_mnth = strtoupper(date('F Y', strtotime($salr_mnth)));

if ($line_no == 0 || $line_no % 25 == 0) {
                $pdf->AddPage();
                $pdf->SetFont('Arial', 'B', 10);
                $pdf->Cell(0, 7, "BANK STATEMENT", 0, 1, "C");
                $line_no++;
                $pdf->Cell(0, 7, "$myrow[fdeptcode] - {$header_salr_mnth}", 0, 1, "C");
                $line_no++;

$pdf->SetFont('Arial', 'B', 9);
                $pdf->Cell(10, 7, "Sl No", 1, 0, "C");
                $pdf->Cell(60, 7, "Employee Name", 1, 0, "C");
                $pdf->Cell(60, 7, "Beneficiary Name", 1, 0, "C");
                $pdf->Cell(40, 7, "Account No.", 1, 0, "C");
                $pdf->Cell(30, 7, "IFSC Code", 1, 0, "C");
                $pdf->Cell(55, 7, "Bank Name", 1, 0, "C");
                $pdf->Cell(20, 7, "Amount", 1, 0, "C");
                $pdf->ln();
                $line_no++;
            }

$pdf->SetFont('Arial', '', 9);
            $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
            $pdf->Cell(60, 7, "[{$myrow['femplcode']}] {$myrow['femplname']}", 1, 0, "L");
            $pdf->Cell(60, 7, "{$myrow['facntname']}", 1, 0, "L");
            $pdf->Cell(40, 7, "{$myrow['facntnumb']}", 1, 0, "C");
            $pdf->Cell(30, 7, "{$myrow['fifsccode']}", 1, 0, "C");
            $bank_name = get_bank_name($myrow['fbankcode']);
            $pdf->Cell(55, 7, "{$bank_name}", 1, 0, "L");
            $pdf->Cell(20, 7, "{$myrow['ftotlsalr']}", 1, 0, "R");
            $pdf->ln();
            $line_no++;
            $totl_salr = $totl_salr + $myrow["ftotlsalr"];
            $i++;
        }
        $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(255, 7, "Grand Total", 1, 0, "R");
        $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
        $pdf->ln();
        $line_no++;
    }

//home banks
    $mysql = "";
    $mysql .= "select masempl.*,salary.* from masempl,salary where ";
    $mysql .= "masempl.femplcode=salary.femplcode and fsalrmnth='$salr_mnth' and salary.fdeptcode like '$dept_code' ";
    $mysql .= "and ftotlsalr<>0 and ifnull(fbankcode,'0')='$dept_bank' ";
    $mysql .= "order by salary.fdeptcode,fifsccode,femplname";
    $myres = mysqli_query($mycon, $mysql);
    $mycnt = mysqli_num_rows($myres);
    if ($mycnt != 0) {
        $i = 1;
        $year = substr($salr_mnth, 0, 4);
        $mnth = substr($salr_mnth, 5, 2);
        $mnth_days = cal_days_in_month(CAL_GREGORIAN, $mnth, $year);

$line_no = 0;
        $totl_salr = 0;
        while ($myrow = mysqli_fetch_assoc($myres)) {
            if ($dept_code <> $myrow['fdeptcode'] && $dept_code != "") {
                $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(230, 7, "Grand Total", 1, 0, "R");
                $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
                $pdf->ln();
                $line_no++;

$line_no = 0;
                $i = 1;
                $totl_salr = 0;
            }

$header_dept_name = get_dept_name($myrow['fdeptcode']);

$header_salr_mnth = strtoupper(date('F Y', strtotime($salr_mnth)));

$pdf->SetFont('Arial', '', 9);
            $pdf->Cell(10, 7, "{$i}", 1, 0, "C");
            $pdf->Cell(60, 7, "{$myrow['femplname']}", 1, 0, "L");
            $pdf->Cell(60, 7, "[{$myrow['femplcode']}] {$myrow['femplname']}", 1, 0, "L");
            $pdf->Cell(60, 7, "{$myrow['facntname']}", 1, 0, "L");
            $pdf->Cell(40, 7, "{$myrow['facntnumb']}", 1, 0, "C");
            $pdf->Cell(30, 7, "{$myrow['fifsccode']}", 1, 0, "C");
            $bank_name = get_bank_name($myrow['fbankcode']);
            $pdf->Cell(55, 7, "{$bank_name}", 1, 0, "L");
            $pdf->Cell(20, 7, "{$myrow['ftotlsalr']}", 1, 0, "R");
            $pdf->ln();
            $line_no++;
            $totl_salr = $totl_salr + $myrow["ftotlsalr"];
            $i++;
        }
        $totl_salr = number_format((float)$totl_salr, 2, '.', '');

$pdf->Cell(255, 7, "Grand Total", 1, 0, "R");
        $pdf->Cell(20, 7, "{$totl_salr}", 1, 0, "R");
        $pdf->ln();
        $line_no++;
    }
    $resp_stat = "T";
    $resp_file = 'reports/salary_statement_bank.pdf';
    $pdf->output($resp_file, 'F');
    echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file));
}

${this.title}

Code Editor : salary.php