Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
fpdf	[ DIR ]	drwxrwxrwx
phpexcel	[ DIR ]	drwxrwxrwx
phpmailer	[ DIR ]	drwxrwxrwx
reports	[ DIR ]	drwxrwxrwx
.src.php	3.61 KB	-rw-r--r--
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...	10.83 KB	-rw-r--r--
attendance_statement_2025-02.x...	42.25 KB	-rw-r--r--
attendance_statement_2025-03.x...	9.17 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...	16.64 KB	-rw-r--r--
attendance_statement_salary_20...	7.33 KB	-rw-r--r--
attendance_statement_salary_20...	7.33 KB	-rw-r--r--
attendance_statement_salary_20...	7.5 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.79 KB	-rw-r--r--
expense_statement_monthly_2024...	9.33 KB	-rw-r--r--
expense_statement_monthly_2024...	9.98 KB	-rw-r--r--
expense_statement_monthly_2025...	11.06 KB	-rw-r--r--
expense_statement_monthly_2025...	21.63 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--
office_logisys3_oums_2025-01-2...	233 B	-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_2024-12.xlsx	17.58 KB	-rw-r--r--
salary_statement_2025-01.xlsx	17.89 KB	-rw-r--r--
salary_statement_2025-02.xlsx	19.75 KB	-rw-r--r--
salary_statement_2025-03.xlsx	20.19 KB	-rw-r--r--
salary_statement_month_excel.p...	21.39 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.44 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 : home_expenses.php

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

<div style="margin-bottom: 5px;" class="head_blue">Expenses</div>
<ul class="nav nav-tabs">
    <li class="active"><a data-toggle="tab" href="#this_month_status">Expenses Status</a></li>
    <li><a data-toggle="tab" href="#prev_month_status">Prev. Month Status</a></li>
    <li><a data-toggle="tab" href="#this_date_expenses">Today's Expenses</a></li>
    <li><a data-toggle="tab" href="#this_month_expenses">This Month Expenses</a></li>
    <li><a data-toggle="tab" href="#last_month_expenses">Prev. Month Expenses</a></li>
    <li><a data-toggle="tab" href="#this_month_datewise_summary">This Month (Date wise)</a></li>
    <li><a data-toggle="tab" href="#this_year_monthwise_summary">This Year (Month wise)</a></li>
    <li><a data-toggle="tab" href="#total_yearwise_summary">Total (Year wise)</a></li>

</ul>

<div class="tab-content" id="home-content-note">
    
    <div id="this_month_status" class="tab-pane fade in active">
        <?php
        if ($type_id == "ADMIN") {
            $myqry = " group by ex.femplcode having ftotlbaln<>0 ";
        } else {
            $myqry = " where ex.femplcode='$empl_id' group by ex.femplcode ";
        }
        $mysql = "select ex.fdeptcode as fdeptcode,fdeptname,ex.femplcode as femplcode,femplname,
        sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
        sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
        sum(case when facnttype='payment' then fexpnamnt else 0 end) - sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlbaln 
        from expenses ex 
        left join masempl em on ex.femplcode=em.femplcode 
        left join masdept dp on ex.fdeptcode=dp.fdeptcode ".$myqry;        
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $dept_recp = "0.00";
        $dept_payt = "0.00";
        $dept_baln = "0.00";
        echo "<table class='table table-striped table-condensed table-hover'>";
        echo "<tr>";
        echo "<th class='text-right'>#</th>";
        echo "<th class='text-left  col-sm-4'> Description</th>";
        echo "<th class='text-right col-sm-2'> Total Payment</th>";
        echo "<th class='text-right col-sm-2'> Total Receipt</th>";
        echo "<th class='text-right col-sm-2'> Total Balance</th>";
        echo "<th class='text-left  col-sm-2'> Last Updated</th>";
        echo "</tr>";
        $i = 1;
        while ($myrow = mysqli_fetch_assoc($myres)) {
            $mysql1 = "select fexpndate from expenses where femplcode='$myrow[femplcode]' order by fexpndate desc limit 1";
            $myres1 = mysqli_query($mycon, $mysql1);
            while ($myrow1 = mysqli_fetch_assoc($myres1)) {
                $last_updt = date('d/m/Y', strtotime($myrow1['fexpndate']));
            }
            echo "<tr>";
            echo "<td class='text-right'> $i.</td>";
            echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
            echo "<td class='text-right'> $myrow[ftotlpayt]</td>";
            echo "<td class='text-right'> $myrow[ftotlrecp]</td>";
            echo "<td class='text-right'> $myrow[ftotlbaln]</td>";
            echo "<td class='text-left'>  $last_updt</td>";
            echo "</tr>";
            $i++;
        }
        echo "</table>";
        ?>
    </div>

<div id="prev_month_status" class="tab-pane fade">
        <?php
        if ($type_id == "ADMIN") {
            $myqry = " group by ex.femplcode having ftotlbaln<>0 ";
        } else {
            $myqry = " and ex.femplcode='$empl_id' group by ex.femplcode ";
        }

$mysql = "select ex.fdeptcode as fdeptcode,fdeptname,ex.femplcode as femplcode,femplname,
        sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
        sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
        sum(case when facnttype='payment' then fexpnamnt else 0 end) - sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlbaln 
        from expenses ex 
        left join masempl em on ex.femplcode=em.femplcode 
        left join masdept dp on ex.fdeptcode=dp.fdeptcode 
        where ex.fexpndate <= last_day(current_date- interval 1 month) ".$myqry ;
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $dept_recp = "0.00";
        $dept_payt = "0.00";
        $dept_baln = "0.00";
        echo "<table class='table table-striped table-condensed table-hover'>";
        echo "<tr>";
        echo "<th class='text-right'>#</th>";
        echo "<th class='text-left  col-sm-4'> Description</th>";
        echo "<th class='text-right col-sm-2'> Total Payment</th>";
        echo "<th class='text-right col-sm-2'> Total Receipt</th>";
        echo "<th class='text-right col-sm-2'> Total Balance</th>";
        echo "<th class='text-left  col-sm-2'> Last Updated</th>";
        echo "</tr>";
        $i = 1;
        while ($myrow = mysqli_fetch_assoc($myres)) {
            $mysql1 = "select fexpndate from expenses where femplcode='$myrow[femplcode]' 
            and fdeptcode='$dept_id' and fexpndate <= last_day(current_date- interval 1 month) order by fexpndate desc limit 1";
            $myres1 = mysqli_query($mycon, $mysql1);
            while ($myrow1 = mysqli_fetch_assoc($myres1)) {
                $last_updt = date('d/m/Y', strtotime($myrow1['fexpndate']));
            }

echo "<tr>";
            echo "<td class='text-right'> $i</td>";
            echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
            echo "<td class='text-right'> $myrow[ftotlpayt]</td>";
            echo "<td class='text-right'> $myrow[ftotlrecp]</td>";
            echo "<td class='text-right'> $myrow[ftotlbaln]</td>";
            echo "<td class='text-left'>  $last_updt</td>";
            echo "</tr>";
            $i++;
        }
        echo "</table>";
        ?>
    </div>

<div id="this_date_expenses" class="tab-pane fade">
        <?php
        $mysql = "select date_format(ex.fexpndate,'%d/%m/%Y') as fexpndate,ex.fdeptcode,fdeptshrt,ex.fclntcode,fclntshrt,";
        $mysql .= "ex.femplcode as femplcode, femplname, fheaddesc, facnttype, fexpnremk, ";
        $mysql .= "(case when facnttype='RECEIPT' then fexpnamnt else 0 end) as frecpamnt, ";
        $mysql .= "(case when facnttype='PAYMENT' then fexpnamnt else 0 end) as fpaytamnt ";
        $mysql .= "from expenses ex ";
        $mysql .= "left join masdept dp on ex.fdeptcode=dp.fdeptcode ";
        $mysql .= "left join masclient cl on ex.fclntcode=cl.fclntcode ";
        $mysql .= "left join masempl em on ex.femplcode=em.femplcode and ex.fdeptcode=em.fdeptcode ";
        if ($type_id == 'ADMIN') {
            $mysql .= "where ex.fexpndate=current_date ";
        } else {
            $mysql .= "where ex.fexpndate=current_date and ex.fdeptcode='$dept_id' and ex.femplcode='$empl_id' ";
        }
        $mysql .= "order by ex.fdeptcode,femplname,ex.fexpndate";
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            $totl_recp = 0;
            $totl_payt = 0;
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Date</th>";
            echo "<th class='text-left  col-sm-3'>Name</th>";
            echo "<th class='text-left  col-sm-3'>Description</th>";
            echo "<th class='text-right col-sm-1'>Payments</th>";
            echo "<th class='text-right col-sm-1'>Receipts</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-2' >Remarks</th>";
            echo "</tr>";
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-left'>  $myrow[fheaddesc]</td>";
                echo "<td class='text-right'> $myrow[fpaytamnt]</td>";
                echo "<td class='text-right'> $myrow[frecpamnt]</td>";
                echo "<td class='text-left'>  $myrow[fclntcode] [$myrow[fclntshrt]]</td>";
                echo "<td class='text-left'>  $myrow[fexpnremk]</td>";
                echo "</tr>";
                $totl_recp = $totl_recp + $myrow['frecpamnt'];
                $totl_payt = $totl_payt + $myrow['fpaytamnt'];
                $i++;
            }
            echo "<tr>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  TOTAL</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_payt, 2, '.', '') . "</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_recp, 2, '.', '') . "</td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "</tr>";
            echo "</table>";
        }
        ?>
    </div>

<div id="this_month_expenses" class="tab-pane fade">
        <?php
        $mysql = "select date_format(ex.fexpndate,'%d/%m/%Y') as fexpndate, ex.fdeptcode,fdeptshrt,ex.fclntcode,fclntshrt,";
        $mysql .= "ex.femplcode as femplcode, femplname, fheaddesc, facnttype, fexpnremk, ";
        $mysql .= "(case when facnttype='RECEIPT' then fexpnamnt else 0 end) as frecpamnt, ";
        $mysql .= "(case when facnttype='PAYMENT' then fexpnamnt else 0 end) as fpaytamnt, ";
        $mysql .= "(case when facnttype='PAYMENT' then fexpnamnt else 0 end) - (case when facnttype='RECEIPT' then fexpnamnt else 0 end) as fbalnamnt ";
        $mysql .= "from expenses ex ";
        $mysql .= "left join masdept dp on ex.fdeptcode=dp.fdeptcode ";
        $mysql .= "left join masclient cl on ex.fclntcode=cl.fclntcode ";
        $mysql .= "left join masempl em on ex.femplcode=em.femplcode ";
        if ($type_id == 'ADMIN') {
            $mysql .= "where date_format(ex.fexpndate,'%m-%Y')=date_format(current_date,'%m-%Y') ";
        } else {
            $mysql .= "where date_format(ex.fexpndate,'%m-%Y')=date_format(current_date,'%m-%Y') and ex.femplcode='$empl_id' ";
        }
        $mysql .= "order by ex.fexpndate,ex.fdeptcode,femplcode,fheaddesc";
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Date</th>";
            echo "<th class='text-left  col-sm-3'>Name</th>";
            echo "<th class='text-left  col-sm-3'>Description</th>";
            echo "<th class='text-right col-sm-1'>Payments</th>";
            echo "<th class='text-right col-sm-1'>Receipts</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-2' >Remarks</th>";
            echo "</tr>";
            $totl_recp = 0;
            $totl_payt = 0;
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-left'>  $myrow[fheaddesc]</td>";
                echo "<td class='text-right'> $myrow[fpaytamnt]</td>";
                echo "<td class='text-right'> $myrow[frecpamnt]</td>";
                echo "<td class='text-left'>  $myrow[fclntcode] [$myrow[fclntshrt]]</td>";
                echo "<td class='text-left'>  $myrow[fexpnremk]</td>";
                echo "</tr>";
                $totl_recp = $totl_recp + $myrow['frecpamnt'];
                $totl_payt = $totl_payt + $myrow['fpaytamnt'];
                $i++;
            }
            echo "<tr>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  TOTAL</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_payt, 2, '.', '') . "</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_recp, 2, '.', '') . "</td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "</tr>";
            echo "</table>";
        }
        ?>
    </div>

<div id="last_month_expenses" class="tab-pane fade">
        <?php
        $mysql = "select date_format(ex.fexpndate,'%d/%m/%Y') as fexpndate,ex.fdeptcode,fdeptshrt,ex.fclntcode,fclntshrt,";
        $mysql .= "ex.femplcode as femplcode, femplname, fheaddesc, facnttype, fexpnremk, ";
        $mysql .= "(case when facnttype='RECEIPT' then fexpnamnt else 0 end) as frecpamnt, ";
        $mysql .= "(case when facnttype='PAYMENT' then fexpnamnt else 0 end) as fpaytamnt, ";
        $mysql .= "(case when facnttype='PAYMENT' then fexpnamnt else 0 end) - (case when facnttype='RECEIPT' then fexpnamnt else 0 end) as fbalnamnt ";
        $mysql .= "from expenses ex ";
        $mysql .= "left join masdept dp on ex.fdeptcode=dp.fdeptcode ";
        $mysql .= "left join masclient cl on ex.fclntcode=cl.fclntcode ";
        $mysql .= "left join masempl em on ex.femplcode=em.femplcode ";
        if ($type_id == 'ADMIN') {
            $mysql .= "where date_format(ex.fexpndate,'%m-%Y')=date_format(current_date - interval 1 month,'%m-%Y') ";
        } else {
            $mysql .= "where date_format(ex.fexpndate,'%m-%Y')=date_format(current_date - interval 1 month,'%m-%Y') and ex.femplcode='$empl_id' ";
        }
        $mysql .= "order by ex.fexpndate,ex.fdeptcode,femplcode,fheaddesc";
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Date</th>";
            echo "<th class='text-left  col-sm-3'>Name</th>";
            echo "<th class='text-left  col-sm-3'>Description</th>";
            echo "<th class='text-right col-sm-1'>Payments</th>";
            echo "<th class='text-right col-sm-1'>Receipts</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-2' >Remarks</th>";
            echo "</tr>";
            $totl_recp = 0;
            $totl_payt = 0;
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-left'>  $myrow[fheaddesc]</td>";
                echo "<td class='text-right'> $myrow[fpaytamnt]</td>";
                echo "<td class='text-right'> $myrow[frecpamnt]</td>";
                echo "<td class='text-left'>  $myrow[fclntcode] [$myrow[fclntshrt]]</td>";
                echo "<td class='text-left'>  $myrow[fexpnremk]</td>";
                echo "</tr>";
                $totl_recp = $totl_recp + $myrow['frecpamnt'];
                $totl_payt = $totl_payt + $myrow['fpaytamnt'];
                $i++;
            }
            echo "<tr>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  TOTAL</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_payt, 2, '.', '') . "</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_recp, 2, '.', '') . "</td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "</tr>";
            echo "</table>";
        }
        ?>
    </div>

<div id="this_month_datewise_summary" class="tab-pane fade">
        <?php
        if ($type_id == 'ADMIN') {
            $myqry = " ";
        } else {
            $myqry = " and ex.fdeptcode='$dept_id' and ex.femplcode='$empl_id' ";
        }
        $mysql = "select date_format(ex.fexpndate,'%d-%b-%Y') as fexpndate, ex.fdeptcode as fdeptcode ,fdeptshrt, ex.femplcode as femplcode, femplname, 
        sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
        sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
        sum(case when facnttype='PAYMENT' then fexpnamnt else 0 end) - sum(case when facnttype='RECEIPT' then fexpnamnt else 0 end) as ftotlbaln 
        from expenses ex 
        left join masdept dp on ex.fdeptcode=dp.fdeptcode 
        left join masempl em on ex.femplcode=em.femplcode and ex.fdeptcode=em.fdeptcode 
        where date_format(ex.fexpndate,'%m-%Y')=date_format(current_date,'%m-%Y') ".$myqry."
        group by ex.fexpndate,ex.fdeptcode,femplcode";
        
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Date</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-4'>Name</th>";
            echo "<th class='text-right col-sm-2'>Payment</th>";
            echo "<th class='text-right col-sm-2'>Receipt</th>";
            echo "<th class='text-right col-sm-2'>Balance</th>";
            echo "</tr>";
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  $myrow[fdeptcode] [$myrow[fdeptshrt]]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-right'> $myrow[ftotlpayt]</td>";
                echo "<td class='text-right'> $myrow[ftotlrecp]</td>";
                echo "<td class='text-right'> $myrow[ftotlbaln]</td>";
                echo "</tr>";
                $totl_recp = $totl_recp + $myrow['ftotlrecp'];
                $totl_payt = $totl_payt + $myrow['ftotlpayt'];
                $i++;
            }
            echo "<tr>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "<td class='text-left  bg-info'>  TOTAL</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_payt, 2, '.', '') . "</td>";
            echo "<td class='text-right bg-info'> " . number_format((float)$totl_recp, 2, '.', '') . "</td>";
            echo "<td class='text-left  bg-info'>  </td>";
            echo "</tr>";
            echo "</table>";
            echo "</table>";
        }
        ?>
    </div>

<div id="this_year_monthwise_summary" class="tab-pane fade">
        <?php
        if ($type_id == 'ADMIN') {
            $mysql = "select date_format(ex.fexpndate,'%Y-%b') as fexpndate, ex.fdeptcode as fdeptcode ,fdeptshrt, ex.femplcode as femplcode, femplname, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
            sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) - sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlbaln 
            from expenses ex 
            left join masdept dp on ex.fdeptcode=dp.fdeptcode 
            left join masempl em on ex.femplcode=em.femplcode and ex.fdeptcode=em.fdeptcode 
            where date_format(ex.fexpndate,'%Y')=date_format(current_date,'%Y') 
            group by date_format(ex.fexpndate,'%m-%Y'),ex.fdeptcode,femplcode";
        } else {
            $mysql = "select date_format(ex.fexpndate,'%Y-%b') as fexpndate, ex.fdeptcode as fdeptcode ,fdeptshrt, ex.femplcode as femplcode, femplname, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
            sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) - sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlbaln 
            from expenses ex 
            left join masdept dp on ex.fdeptcode=dp.fdeptcode 
            left join masempl em on ex.femplcode=em.femplcode and ex.fdeptcode=em.fdeptcode 
            where date_format(ex.fexpndate,'%Y')=date_format(current_date,'%Y') and ex.fdeptcode='$dept_id' and ex.femplcode='$empl_id' 
            group by date_format(ex.fexpndate,'%m-%Y'),ex.fdeptcode,femplcode";
        }
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Month</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-4'>Name</th>";
            echo "<th class='text-right col-sm-2'>Payment</th>";
            echo "<th class='text-right col-sm-2'>Receipt</th>";
            echo "<th class='text-right col-sm-2'>Balance</th>";
            echo "</tr>";
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  $myrow[fdeptcode] [$myrow[fdeptshrt]]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-right'> $myrow[ftotlpayt]</td>";
                echo "<td class='text-right'> $myrow[ftotlrecp]</td>";
                echo "<td class='text-right'> $myrow[ftotlbaln]</td>";
                echo "</tr>";
                $i++;
            }
            echo "</table>";
        }
        ?>
    </div>

<div id="total_yearwise_summary" class="tab-pane fade">
        <?php
        if ($type_id == 'ADMIN') {
            $mysql = "select date_format(ex.fexpndate,'%Y') as fexpndate, ex.fdeptcode as fdeptcode ,fdeptshrt, ex.femplcode as femplcode, femplname, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
            sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) - sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlbaln 
            from expenses ex 
            left join masdept dp on ex.fdeptcode=dp.fdeptcode 
            left join masempl em on ex.femplcode=em.femplcode 
            group by date_format(ex.fexpndate,'%Y'),ex.fdeptcode,femplcode";
        } else {
            $mysql = "select date_format(ex.fexpndate,'%Y') as fexpndate, ex.fdeptcode as fdeptcode ,fdeptshrt, ex.femplcode as femplcode, femplname, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) as ftotlrecp, 
            sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlpayt, 
            sum(case when facnttype='receipt' then fexpnamnt else 0 end) - sum(case when facnttype='payment' then fexpnamnt else 0 end) as ftotlbaln 
            from expenses ex 
            left join masdept dp on ex.fdeptcode=dp.fdeptcode 
            left join masempl em on ex.femplcode=em.femplcode 
            where ex.fdeptcode='$dept_id' and ex.femplcode='$empl_id' 
            group by date_format(ex.fexpndate,'%Y'),ex.fdeptcode,femplcode";
        }
        $myres = mysqli_query($mycon, $mysql) or die(mysqli_error($mycon));
        $mycnt = mysqli_num_rows($myres);
        if ($mycnt == 0) {
            echo "<div class='alert alert-info'>No expense details found!</div>";
        } else {
            echo "<table class='table table-striped table-condensed table-hover'>";
            echo "<tr>";
            echo "<th class='text-right'>#</th>";
            echo "<th class='text-left  col-sm-1'>Year</th>";
            echo "<th class='text-left  col-sm-1'>Client</th>";
            echo "<th class='text-left  col-sm-4'>Name</th>";
            echo "<th class='text-right col-sm-2'>Payment</th>";
            echo "<th class='text-right col-sm-2'>Receipt</th>";
            echo "<th class='text-right col-sm-2'>Balance</th>";
            echo "</tr>";
            $i = 1;
            while ($myrow = mysqli_fetch_assoc($myres)) {
                echo "<tr>";
                echo "<td class='text-right'> $i.</td>";
                echo "<td class='text-left'>  $myrow[fexpndate]</td>";
                echo "<td class='text-left'>  $myrow[fdeptcode] [$myrow[fdeptshrt]]</td>";
                echo "<td class='text-left'>  [$myrow[femplcode]] $myrow[femplname]</td>";
                echo "<td class='text-right'> $myrow[ftotlpayt]</td>";
                echo "<td class='text-right'> $myrow[ftotlrecp]</td>";
                echo "<td class='text-right'> $myrow[ftotlbaln]</td>";
                echo "</tr>";
                $i++;
            }
            echo "</table>";
        }
        ?>
    </div>
</div>

${this.title}

Code Editor : home_expenses.php