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

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

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

if ($_POST['load_data'] == 'grid_data') {
    $dept_code = $_POST['dept_code'];
    $empl_stat = $_POST['empl_stat'];
    $find_data = $_POST['find_data'];

require("sys_grid_data.php");
    $i = 1;
    if ($type_id == 'ADMIN') {
        $myqry = " ";
    } elseif ($type_id == 'CHIEF') {
        $myqry = " inner join masdept_user du on em.fdeptcode = du.fdeptcode and du.fusercode = '$user_id' ";
    }

$grid_sele = "select * from masempl em
    inner join masdept dp on em.fdeptcode = dp.fdeptcode 
    inner join masdesn dn on em.fempldesn = dn.fempldesn " . $myqry . "
    where (em.femplcode like '%$find_data%' or em.femplname like '%$find_data%' or em.femplmobl like '%$find_data%') 
    and em.fdeptcode like '$dept_code' and femplstat like '$empl_stat' and ifnull(em.fdeleted,'F')='F'
    order by em.fdeptcode,dn.fdesnordr,em.fempldesn,fempltype,femplname";

$grid_para = grid_limit($grid_sele);
    $page_numb = $grid_para[0];
    $last_page = $grid_para[1];
    $page_limt = $grid_para[2];
    $lowr_limt = $grid_para[3];

$mysql = $grid_sele . " limit $lowr_limt, $page_limt";
    $myres = mysqli_query($mycon, $mysql);
    $mycnt = mysqli_num_rows($myres);
    if ($mycnt > 0) {
        echo "<table class=''>";
        echo "<thead>";
        echo "<tr>";
        echo "<th width='4%'> # </th>";
        echo "<th width='6%'> Client</th>";
        echo "<th width='5%'> Empl ID </th>";
        echo "<th width='20%'> Employee Name</th>";
        echo "<th width='15%'> Designation </th>";
        echo "<th width='8%'> D.O.B. </th>";
        echo "<th width='10%'> Mobile No.</th>";
        echo "<th width='14%'> Email ID </th>";
        echo "<th width='8%'> Status </th>";
        echo "<th width='10%'> Action </th>";
        echo "</tr>";
        echo "</thead>";
        echo "<tbody>";
        while ($myrow = mysqli_fetch_assoc($myres)) {
            $page_link = "<a class='btn btn-success btn-sm' href=# onClick=edit_data('$myrow[femplcode]')>Edit</a>";
            $page_link .= " <a class='btn btn-danger btn-sm' href=# onClick=dele_data('$myrow[femplcode]')>Delete</a>";
            // if ($myrow['femplstat'] == 'T') {
            //     $page_link .= " <a class='btn btn-primary btn-sm' href=# onClick=inac_empl('$myrow[femplcode]')>Deactivate</a>";
            // }
            // if ($myrow['femplstat'] != 'T') {
            //     $page_link .= " <a class='btn btn-primary btn-sm' href=# onClick=actv_empl('$myrow[femplcode]')>Activate</a>";
            // }

if ($myrow['fempltype'] == 'P') $empl_type = "PERMANENT";
            if ($myrow['fempltype'] == 'T') $empl_type = "TEMPORARY";

$empl_stat = $myrow['femplstat'] == 'T' ? "ACTIVE" : "INACTIVE";
            $dept_logo = "img-empl/" . $myrow['femplphot'];

echo "<tr>";
            echo "<td align='center'> $i</td>";
            echo "<td align='center'> [$myrow[fdeptcode]] $myrow[fdeptshrt]</td>";
            echo "<td align='center'> $myrow[femplcode]</td>";
            echo "<td align='left'>  <img src='$dept_logo' height='30px' width='28px' style='border:1px solid #ccc;' align='absmiddle' alt=''> $myrow[femplname]</td>";
            echo "<td align='left'>  $myrow[fempldesn]</td>";
            echo "<td align='center'> " . date('d/m/Y', strtotime($myrow['fbrthdate'])) . "</td>";
            echo "<td align='center'> $myrow[femplmobl]</td>";
            echo "<td align='left'>$myrow[femplmail]</td>";
            echo "<td align='center'>$empl_stat</td>";
            echo "<td align='center'>$page_link</td>";
            echo "</tr>";
            $i++;
        }
        echo "</tbody>";
        echo "</table>";
        include("sys_grid_navbar.php");
    } else {
        echo "<div class='alert alert-info'>No details found!</div>";
    }
}

if ($load_data == 'actv_empl') {
    $mysql = "update masempl set femplstat='T' where femplcode='$_POST[prim_code]'";
    $myres = mysqli_query($mycon, $mysql);
}

if ($load_data == 'inac_empl') {
    $mysql = "update masempl set femplstat='F' where femplcode='$_POST[prim_code]'";
    $myres = mysqli_query($mycon, $mysql);
}

if ($_POST['load_data'] == 'dele_data') {
    $empl_code = $_POST['dele_code'];
    $mysql = "update masempl set femplstat='F',fdeleted='T' where femplcode='$empl_code'";
    $myres = mysqli_query($mycon, $mysql);
}

if ($_POST['load_data'] == 'dept_data') {
    if ($type_id == 'ADMIN') {
        $mysql = "select * from masdept where ifnull(fdeleted,'')<>'T' order by fdeptname";
    } else {
        $mysql = "select * from masdept where ifnull(fdeleted,'')<>'T' order by fdeptname";
    }
    $myres = mysqli_query($mycon, $mysql);
    if (mysqli_num_rows($myres) > 1) {
        echo "<option value=%>--SELECT--</option>";
    }
    while ($myrow = mysqli_fetch_assoc($myres)) {
        echo "<option value='$myrow[fdeptcode]'>$myrow[fdeptname]</option>";
    }
}

if ($_POST['load_data'] == 'desn_data') {
    if ($type_id == 'ADMIN') {
        $mysql = "select * from masdesn order by fdesnordr";
    } elseif ($type_id == 'CHIEF') {
        $mysql = "select * from masdesn order by fdesnordr";
    } else {
        $mysql = "select * from masdesn order by fdesnordr";
    }
    $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[fempldesn]'>$myrow[fempldesn]</option>";
    }
}

if ($_POST['load_data'] == 'bank_data') {
    $mysql = "select * from masbank order by fbankcode";
    $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[fbankcode]'>$myrow[fbankname]</option>";
    }
}

if ($_POST['load_data'] == 'disp_data') {
    $empl_code = $_POST['empl_code'];
    $mysql = "select * from masempl where femplcode='$empl_code'";
    $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') {
    $page_mode = $_POST['page_mode'];
    $empl_name = strtoupper($_POST['empl_name']);

$empl_phot = $_POST['empl_phot'];
    $empl_photo = strtolower(str_replace(' ', '_', $empl_phot));

if ($_POST['empl_mobl'] == "") {
        $inpt_errs = "T";
        $resp_mesg = "Please enter mobile number!";
    }

if ($_POST['empl_adhr'] == "") {
        $inpt_errs = "T";
        $resp_mesg = "Please enter aadhar number!";
    }

$empl_stat = $_POST['empl_stat'];

if ($_POST['term_date'] == "00/00/0000" || $_POST['term_date'] == "") {
        $empl_stat = 'T';
    } else {
        $empl_stat = 'F';
    }

if ($inpt_errs != "T") {
        if ($page_mode == "add") {
            $mysql = "select * from masempl where femplmobl='$_POST[empl_mobl]'";
            $myres = mysqli_query($mycon, $mysql);
            $mycnt = mysqli_num_rows($myres);
            if ($mycnt != 0) {
                while ($myrowx = mysqli_fetch_assoc($myres)) {
                    $dept_code = $myrowx['fdeptcode'];
                }
                $resp_mesg = "Employee details exists with this mobile no., Name: " . $empl_name . ", Dept: " . $dept_code . "\n";
                $inpt_errs = "T";
            }

$mysql = "select * from masempl where fadhrnumb='$_POST[empl_adhr]'";
            $myres = mysqli_query($mycon, $mysql);
            $mycnt = mysqli_num_rows($myres);
            if ($mycnt != 0) {
                while ($myrowx = mysqli_fetch_assoc($myres)) {
                    $dept_code = $myrowx['fdeptcode'];
                }
                $resp_mesg .= "Employee details exists with this aadhar no., Name: " . $empl_name . ", Dept: " . $dept_code . "\n";
                $inpt_errs = "T";
            }

$mysql = "select * from masempl where femplmail='$_POST[empl_mail]'";
            $myres = mysqli_query($mycon, $mysql);
            $mycnt = mysqli_num_rows($myres);
            if ($mycnt != 0) {
                while ($myrowx = mysqli_fetch_assoc($myres)) {
                    $dept_code = $myrowx['fdeptcode'];
                }
                $resp_mesg .= "Employee details exists with this mail ID., Name: " . $empl_name . ", Dept: " . $dept_code . "\n";
                $inpt_errs = 'T';
            }

$mysql = "select * from masempl where fpancnumb='$_POST[empl_panc]'";
            $myres = mysqli_query($mycon, $mysql);
            $mycnt = mysqli_num_rows($myres);
            if ($mycnt != 0) {
                while ($myrowx = mysqli_fetch_assoc($myres)) {
                    $dept_code = $myrowx['fdeptcode'];
                }
                $resp_mesg .= "Employee details exists with this PAN., Name: " . $empl_name . ", Dept: " . $dept_code . "\n";
                $inpt_errs = 'T';
            }

if ($inpt_errs != 'T') {
                $mysql1 = "select * from sys_control";
                $myres1 = mysqli_query($mycon, $mysql1);
                $myrow1 = mysqli_fetch_assoc($myres1);
                if (strtoupper($_POST['dept_code']) == 'DEP') {
                    $empl_code = $myrow1["fdeepslno"] + 1;
                } elseif (strtoupper($_POST['dept_code']) == 'IHF') {
                    $empl_code = $myrow1["fihfsslno"] + 1;
                } else {
                    $empl_code = $myrow1["femplslno"] + 1;
                }

$mysql = "insert into masempl (
                femplcode,femplname,fempldesn,fdeptcode,fempltype,fworkplce,frepthead,femplstat,femplgend,
                fbrthdate,
                femplmobl,femplmail,fpermadd1,fpermadd2,fpermadd3,fpermadd4,
                fexpnentr,fattnentr,fworkentr,
                fsalrcomp,fsalrhead,fsalrtype,fsalrappr,fsalrbase,fsalrdays,fsalrhour,
                fjoindate,ftermdate,
                femplremk,femplphot,ftotlleav,fadhrnumb,fpancnumb,facntname,facntnumb,fifsccode,fbankcode,fcreatime,fupdttime,fdeleted) 
                values(
                '$empl_code','$empl_name','$_POST[empl_desn]','$_POST[dept_code]','$_POST[empl_type]','$_POST[work_plce]','$_POST[rept_head]','$empl_stat','$_POST[empl_gend]',
                str_to_date('$_POST[empl_bday]','%d/%m/%Y'),
                '$_POST[empl_mobl]','$_POST[empl_mail]','$_POST[empl_add1]','$_POST[empl_add2]','$_POST[empl_add3]','$_POST[empl_add4]',
                '$_POST[expn_entr]','$_POST[attn_entr]','$_POST[work_entr]',
                '$_POST[salr_comp]','$_POST[salr_head]','$_POST[salr_type]','$_POST[salr_appr]','$_POST[salr_base]','$_POST[salr_days]','$_POST[salr_hour]',
                str_to_date('$_POST[join_date]','%d/%m/%Y'),
                str_to_date('$_POST[term_date]','%d/%m/%Y'),
                '$_POST[empl_remk]','$_POST[empl_phot]','$_POST[totl_casl]','$_POST[empl_adhr]','$_POST[empl_panc]','$_POST[acnt_name]','$_POST[bank_acnt]',
                '$_POST[bank_ifsc]','$_POST[bank_code]',now(),now(),'F')";
                $myres = mysqli_query($mycon, $mysql);

if (strtoupper($_POST['dept_code']) == 'DEP') {
                    $mysql = "update sys_control set fdeepslno='$empl_code'";
                    $myres = mysqli_query($mycon, $mysql);
                } elseif (strtoupper($_POST['dept_code']) == 'IHF') {
                    $mysql = "update sys_control set fihfsslno='$empl_code'";
                    $myres = mysqli_query($mycon, $mysql);
                } else {
                    $mysql = "update sys_control set femplslno='$empl_code'";
                    $myres = mysqli_query($mycon, $mysql);
                }

$resp_mesg = "Details inserted!";
                $resp_stat = "T";

set_user_logs($dept_id, $user_id, 'EMPL', 'EMPLOYEE DETAILS ADDED : ' . '[' . $empl_code . '] ' . $empl_name . ' CLIENT : ' . $_POST['dept_code']);
            }
        } else {
            $mysql = "update masempl set femplname='$empl_name',fempldesn='$_POST[empl_desn]',fdeptcode='$_POST[dept_code]',
            fempltype='$_POST[empl_type]',fworkplce='$_POST[work_plce]',frepthead='$_POST[rept_head]',femplgend='$_POST[empl_gend]',femplstat='$empl_stat',
            femplmobl='$_POST[empl_mobl]',femplmail='$_POST[empl_mail]',fadhrnumb='$_POST[empl_adhr]',fpancnumb='$_POST[empl_panc]',
            fbrthdate=str_to_date('$_POST[empl_bday]','%d/%m/%Y'),
            fjoindate=str_to_date('$_POST[join_date]','%d/%m/%Y'),
            ftermdate=str_to_date('$_POST[term_date]','%d/%m/%Y'),
            fexpnentr='$_POST[expn_entr]',fattnentr='$_POST[attn_entr]',fworkentr='$_POST[work_entr]',
            fpermadd1='$_POST[empl_add1]',fpermadd2='$_POST[empl_add2]',fpermadd3='$_POST[empl_add3]',fpermadd4='$_POST[empl_add4]',
            fsalrcomp='$_POST[salr_comp]',fsalrhead='$_POST[salr_head]',fsalrtype='$_POST[salr_type]',fsalrappr='$_POST[salr_appr]',
            fsalrbase='$_POST[salr_base]',fsalrdays='$_POST[salr_days]',fsalrhour='$_POST[salr_hour]',
            femplremk='$_POST[empl_remk]',femplphot='$empl_phot',
            facntname='$_POST[acnt_name]',facntnumb='$_POST[bank_acnt]',fifsccode='$_POST[bank_ifsc]',fbankcode='$_POST[bank_code]',
            ftotlleav='$_POST[totl_casl]',fupdttime = now(),
            fdeleted='F' where femplcode='$_POST[empl_code]'";
            $myres = mysqli_query($mycon, $mysql);
            set_user_logs($dept_id, $user_id, 'EMPL', 'EMPLOYEE DETAILS UPDATED : ' . '[' . $_POST['empl_code'] . '] ' . $empl_name . ', CLIENT : ' . $_POST['dept_code']);

$resp_mesg = "Details updated!";
            $resp_stat = "T";
        }
    }
    echo json_encode(array("errs" => $inpt_errs, "stat" => $resp_stat, "mesg" => $resp_mesg, "file" => $resp_file));
}

${this.title}

Code Editor : employees2.php