1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / bssl.mfmsbd.com /
Filename : start.php
back
<?php
require 'functions.php';
checkLogin();
$db_link = connect();
getSettings($db_link);
getFees($db_link);

// $query_custact_dt = getCustAct($db_link);
$query_custact_re = re_getCustAct($db_link);

// login user
$login_user = $_SESSION['log_user'];

if ($login_user != 'admin') {
    $branch_id = $_SESSION['branch_id'];
}    

// Total Customers
$sql_custact = "SELECT COUNT(1) as total_all FROM customer WHERE 1";

if ($login_user != 'admin') {   
    $sql_custact .= " AND custbranch_id = {$branch_id}";
}

$query_custact = mysqli_query($db_link, $sql_custact);
// checkSQL($db_link, $query_custact, $db_link);
$cust_row1 = mysqli_fetch_assoc($query_custact);
$total_customers = $cust_row1['total_all'];

// Active Customers
$sql_custact = "SELECT COUNT(1) as total_active FROM customer WHERE cust_active = 1";

if ($login_user != 'admin') {   
    $sql_custact .= " AND custbranch_id = {$branch_id}";
}

$query_custact = mysqli_query($db_link, $sql_custact);
// checkSQL($db_link, $query_custact, $db_link);
$cust_row2 = mysqli_fetch_assoc($query_custact);
$active_customers = $cust_row2['total_active'];

// Loans
//1 = pending, 2 = approved, 3 = refused, 4 = abandoned, 5 = cleared
$pending_loans = $approved_loans = $refused_loans = $abandoned_loans = $cleared_loans = 0;

$loan_q1 = "SELECT loanstatus_id, count(1) as total FROM `loans` WHERE 1";
if ($login_user != 'admin') {   
    $loan_q1 .= " AND branch_id = {$branch_id}";
}
$loan_q1 .= " group by loanstatus_id";
$loan_rs = mysqli_query($db_link, $loan_q1);

while ($loan_row = mysqli_fetch_assoc($loan_rs)) {
    switch($loan_row['loanstatus_id']) {
        case 1:
            $pending_loans = $loan_row['total'];
          break;

        case 2:
            $approved_loans = $loan_row['total'];
          break;

        case 3:
            $refused_loans = $loan_row['total'];
          break;

        case 4:
            $abandoned_loans = $loan_row['total'];
          break;

        case 5:
            $cleared_loans = $loan_row['total'];
          break;              
    }
}

$total_loans = $pending_loans + $approved_loans + $refused_loans + $abandoned_loans + $cleared_loans;


// Total employees
$sql_employee = "SELECT COUNT(1) as total_all FROM employee WHERE 1";

if ($login_user != 'admin') {   
    $sql_employee .= " AND emplbranch_id = {$branch_id}";
}


$query_employee = mysqli_query($db_link, $sql_employee);
//checkSQL($db_link, $query_custact1, $db_link);
$emp_row = mysqli_fetch_assoc($query_employee);
$total_employee = $emp_row['total_all'];


$sql_branch = "SELECT * FROM branch";
$query_branch = mysqli_query($db_link, $sql_branch);
checkSQL($db_link, $query_branch, $db_link);
$brn_row = mysqli_num_rows($query_branch);

$sql_user = "SELECT * FROM user";
$query_user = mysqli_query($db_link, $sql_user);
checkSQL($db_link, $query_user, $db_link);
$user_row = mysqli_num_rows($query_user);

?>
<?php headandmenu('Microfinance Management System', '1'); ?>
<!--main content start-->
<section id="main-content">
    <section class="wrapper" style="min-height: 850px;">
        
        
        <!-- Content Row -->
        <div class="container-fluid">

        <!-- Page Heading -->
        <div class="d-sm-flex align-items-center justify-content-between mb-4 pe-5 ps-3 mt-4">
            <h1 class="h3 mb-0" style="color: #005095; ">Dashboard Overview</h1>
            <a href="cust_new.php" class="d-none d-sm-inline-block btn btn-sm btn-primary shadow-sm"><i class="fa-solid fa-plus"></i> Add Customer</a>
        </div>

            <div class="row state-overview">
                <div class="col-lg-3 col-sm-6">
                    <section class="card">
                        <div class="symbol terques">
                            <i class="fa fa-user"></i>
                        </div>
                        <div class="value">
                            <h1>
                            <?php echo $total_customers ;   ?>
                            </h1>
                            <p>Total Customers</p>
                        </div>
                    </section>
                </div>
                <div class="col-lg-3 col-sm-6">
                    <section class="card">
                        <div class="symbol red">
                            <i class="fa-solid fa-building-columns"></i>
                        </div>
                        <div class="value">
                            <h1>
                            <?php echo $total_loans; ?>
                            </h1>
                            <p>Total Loans</p>
                        </div>
                    </section>
                </div>
                <div class="col-lg-3 col-sm-6">
                    <section class="card">
                        <div class="symbol yellow">
                        <i class="fa-solid fa-money-check"></i>
                        </div>
                        <div class="value">
                            <h1>
                            <?php echo $cleared_loans; ?>
                            </h1>
                            <p>Cleared Loans</p>
                        </div>
                    </section>
                </div>
                <div class="col-lg-3 col-sm-6">
                    <section class="card">
                        <div class="symbol blue">
                            <i class="fa-solid fa-code-branch"></i>
                        </div>
                        <div class="value">
                            <h1>
                            <?php echo $brn_row; ?>
                            </h1>
                            <p>Total Branch</p>
                        </div>
                    </section>
                </div>
            </div>
            <div class="row ">
                <!-- Earnings (Monthly) Card Example -->
                <div class="col-xl-3 col-md-6 mb-4 ">
                    <div class="card">
                        <div class="card-body p-4" style="background: #f38630;">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-white text-uppercase mb-1">
                                    Active Customers</div>
                                    <div class="h5 mb-0 font-weight-bold text-white"><?php echo $active_customers; ?></div>
                                </div>
                                <div class="col-auto">
                                    <i class="fa-solid fa-users text-white" style="font-size: 30px;"></i>
                                </div>
                            </div>
                            
                        </div>
                        <a href="cust_act.php"><div class="card-footer cfooter">
                            Active Customers <i class="fa-solid fa-arrow-right"></i>
                        </div></a>
                    </div>
                </div>
                <!-- Earnings (Monthly) Card Example -->
                <div class="col-xl-3 col-md-6 mb-4">
                    <div class="card ">
                        <div class="card-body p-4" style="background: #005095;">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-white text-uppercase mb-1">
                                    Active Loans</div>
                                    <div class="h5 mb-0 font-weight-bold text-white"><?php echo  $approved_loans; ?></div>
                                </div>
                                <div class="col-auto">
                                    <i class="fa-solid fa-money-check-dollar text-white" style="font-size: 30px;"></i>
                                </div>
                            </div>
                            
                        </div>
                        <a href="loans_act.php"><div class="card-footer cfooter">
                            Active Loans <i class="fa-solid fa-arrow-right"></i>
                        </div></a>
                    </div>
                </div>
                <!-- Earnings (Monthly) Card Example -->
                <div class="col-xl-3 col-md-6 mb-4">
                    <div class="card ">
                        <div class="card-body p-4" style="background: #f38630;">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-white text-uppercase mb-1">
                                    Pending Loans</div>
                                    <div class="h5 mb-0 font-weight-bold text-white"><?php echo  $pending_loans;  ?></div>
                                </div>
                                <div class="col-auto">
                                    <i class="fa-solid fa-user-tie text-white" style="font-size: 30px;"></i>
                                </div>
                            </div>
                            
                        </div>
                        <a href="loans_pend.php"><div class="card-footer cfooter">
                            Pending Loans <i class="fa-solid fa-arrow-right"></i>
                        </div></a>
                    </div>
                </div>
                <!-- Earnings (Monthly) Card Example -->
                <div class="col-xl-3 col-md-6 mb-4">
                    <div class="card ">
                        <div class="card-body p-4" style="background: #005095;">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-white text-uppercase mb-1">
                                    Total Employees</div>
                                    <div class="h5 mb-0 font-weight-bold text-white"><?php echo  $total_employee; ?></div>
                                </div>
                                <div class="col-auto">
                                <i class="fa-solid fa-user-group text-white" style="font-size: 30px;"></i></i>
                                </div>
                            </div>
                            
                        </div>
                        <a href="empl_curr.php"><div class="card-footer cfooter">
                            Current Employees  <i class="fa-solid fa-arrow-right"></i>
                        </div></a>
                    </div>
                </div>
            </div>

        
        <!-- Data table Starts -->
        <div class="row">
            <div class="col-sm-12">
                <section class="card">
                    <header class="card-header">
                        Recent Customers
                        <span class="tools pull-right">
                            <a href="javascript:;" class="fa fa-chevron-down"></a>
                            <a href="javascript:;" class="fa fa-times"></a>
                        </span>
                    </header>
                    <div class="card-body">
                        <div class="adv-table">
                            <div class="table-responsive">
                                
                                <table  class="display table table-bordered table-striped" id="dynamic-table">
                                    <thead>
                                        <tr>
                                            <th>Cust. No.</th>
                                            <th>Name</th>
                                            <th>Gender</th>
                                            <th>Occupation</th>
                                            <th>Address</th>
                                            <th>Phone No.</th>
                                            <th>Memb. since</th>
                                            <th>Branch</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php while ($row_custact=mysqli_fetch_assoc($query_custact_re)) { ?>
                                        
                                        
                                        <tr class="gradeX">
                                            <td><a href="customer.php?cust=<?php echo $row_custact['cust_id']; ?>"><?php echo $row_custact['cust_no']; ?></a></td>
                                            <td><?php echo $row_custact['cust_name']?></td>
                                            <td><?php echo $row_custact['custsex_name']?></td>
                                            <td><?php echo $row_custact['cust_occup']?></td>
                                            <td><?php echo $row_custact['cust_address']?></td>
                                            <td><?php echo $row_custact['cust_phone']?></td>
                                            <td><?php echo date("d.m.Y",$row_custact['cust_since'])?></td>
                                            <td ><?php echo $row_custact['branch_name']; ?></td>
                                            <td>
                                                <a class="btn btn-info btn-sm text-light" href="customer.php?cust=<?php echo $row_custact['cust_id']?>"><i class="fa-solid fa-pen-to-square"></i></a>
                                                <!-- <a onclick="return confirm('Are you sure to delete?')" class="btn btn-danger btn-sm text-light" href="delete_cust.php?id=<?php echo $row_custact['cust_id']?>"><i class="fa-solid fa-pen-to-square"></i></a> -->
                                            </td>
                                        </tr>
                                        <?php } ?>
                                        
                                    </tbody>
                                    
                                </table>
                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>
        <div class="row">
            <!-- Left Side of Dashboard -->
            <div class="col-lg-6">
                <?PHP include $_SESSION['set_dashl']; ?>
            </div>
            
            <!-- Right Side of Dashboard -->
            <div  class="col-lg-6">
                <?PHP include $_SESSION['set_dashr']; ?>
            </div>
            <!-- Logout Reminder Message -->
            <?PHP   checkLogout();  ?>
        </div>
    </div>
    </section>
</section>
<!--main content end-->
<?php footer(); ?>