File manager

File manager - Edit - /home/autoph/public_html/connectv1/resources/views/dashboard/dashboard.php

Back
<?php include('cfg/db.php'); // include('api/controllers/utility.php'); if (!isset($_SESSION['user']['id'])) { header('location:signin.php'); } // if(!(isset($global_action_permissions['1']) && // in_array("1", $global_action_permissions['1']))){ // header('location:signin.php'); // } // $utility = new Utility(); $granted_company_ids = $utility_class->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; // $check_page = new CheckPage(); // $check_page->start($db); ?> <?php // $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; // $customer_individidual_count = $db -> select("SELECT SUM((SELECT count(1) FROM // (SELECT cd.dms_id FROM customer ci // INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id // INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id // WHERE ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) // ) as total FROM `source_dms` WHERE status = 1"); // $customer_total = $customer_individidual_count; // $vehicle_count = $db -> select(" // SELECT SUM((SELECT count(1) FROM // (SELECT v.dms_id FROM vehicle v // INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id // WHERE v.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) // ) as total_count // FROM `source_dms` WHERE status = 1"); // $sale_count = $db -> select("SELECT count(1) FROM sales WHERE status = 1 "); // $service_count = $db -> select("SELECT count(1) FROM service WHERE status = 1 "); // $gender_query = "SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.gender_id = %d AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1"; // $customer_with_gender_query_total = $db -> select("SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.gender_id <> 0 AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1"); // $male_percent = "0%"; // $male_count_query = $db -> select(sprintf($gender_query,1)); // if($male_count_query > 0){ // $male_percent = ($male_count_query100) / $customer_with_gender_query_total.'%'; // }else{ // $male_percent = '0%'; // } // $female_percent = "0%"; // $female_count_query = $db -> select(sprintf($gender_query,2)); // if($female_count_query > 0){ // $female_percent = ($female_count_query100) / $customer_with_gender_query_total.'%'; // }else{ // $female_percent = '0%'; // } // $where_age = " TIMESTAMPDIFF(YEAR, date_of_birth , CURDATE() ) "; // $age_count_query = "SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE $where_age %s AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1"; // $age_count_query_total = $db -> select("SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.date_of_birth <> '' AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1"); // $age_count_query_below = $db -> select(sprintf($age_count_query," <= 30 ")); // if($age_count_query_below > 0){ // $below_percent = ($age_count_query_below100) / $age_count_query_total.'%'; // }else{ // $below_percent = '0%'; // } // $age_count_query_between = $db -> select(sprintf($age_count_query," <= 50 and $where_age >= 31 ")); // if( $age_count_query_between > 0){ // $age_between_percent = ($age_count_query_between100) / $age_count_query_total.'%'; // }else{ // $age_between_percent = '0%'; // } // $age_count_query_above = $db -> select(sprintf($age_count_query," >= 51 ")); // if( $age_count_query_above > 0){ // $above_percent = ($age_count_query_above*100) / $age_count_query_total.'%'; // }else{ // $above_percent = '0%'; // } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title><?php echo $variable['site_name']; ?> \| Dashboard</title> <!-- Google Font: Source Sans Pro --> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback"> <!-- Font Awesome --> <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css"> <!-- Ionicons --> <!-- <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css"> --> <!-- Tempusdominus Bootstrap 4 --> <!-- <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css"> --> <!-- iCheck --> <!-- <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css"> --> <!-- JQVMap --> <!-- <link rel="stylesheet" href="plugins/jqvmap/jqvmap.min.css"> --> <!-- Select2 --> <link rel="stylesheet" href="plugins/select2/css/select2.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <!-- Daterange picker --> <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css"> <!-- summernote --> <!-- <link rel="stylesheet" href="plugins/summernote/summernote-bs4.min.css"> --> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <style> .progress-group { cursor: pointer; } .overlay { background-color: transparent !important; } </style> </head> <body class="hold-transition sidebar-mini text-sm layout-fixed"> <div class="wrapper"> <!-- Preloader --> <div class="preloader flex-column justify-content-center align-items-center" hidden> <img class="animation__shake" src="dist/img/<?php echo $variable['logo']; ?>" alt="<?php echo $variable['logo']; ?>" height="60" width="60"> </div> <!-- INCLUDE HEADER --> <?php include('include/header.php'); ?> <?php include('include/sidebar.php'); ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <div class="content-header"> <div class="container-fluid"> <div class="row mb-0"> <div class="col-sm-6"> <div id="debuggger"></div> <!-- <h1 class="m-0">Dashboard</h1> --> <!-- <div class="col-md-5 p-0 col-md-offset-4 filter-date-div"> <div class="input-group "> <input type="text" id="filter-date" class="edit-customer lbl-forms-sm form-control form-control-sm" placeholder="Filter by date" style="background-color: transparent;"> <div class=" edit-customer input-group-append" style="height: 31px;"> <div class="input-group-text" id="filter-date-side"><i class="fa fa-calendar"></i></div> </div> </div> </div> --> </div><!-- /.col --> <div class="col-6 text-right"> <div class="btn-group"> <button type="button" class="tooltip-me btn btn-default dropdown-toggle btn-sm" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true" title="Filter" data-html="true" data-placement="left"> <i class="fa fa-filter" aria-hidden="true"></i> </button> <div id="dropdown-filter" class="dropdown-menu dropdown-menu-right"> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <input type="button" class="btn btn-primary btn-sm form-control form-control-sm " name="btnCustomerListNoFilter" id="btnCustomerListNoFilter" value="No Filter" style="width: 100%;"></input> </div> <!--form-group dropdown--> </div> <!--form-group--> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <div id="filter-date" class="p-1" name="filter-date" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 100%"> <i class="fa fa-calendar"></i>  <span></span> <i class="fa fa-angle-down mt-1 float-right"></i> </div> </div> <!--form-group dropdown--> </div> <!--form-group--> <!-- text input --> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="company-filter" id="company-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <?php $company = $db->return_result("SELECT `id`, `code` FROM `source_company` WHERE status = 1 AND id IN (" . $granted_company_ids . ") ORDER BY code ASC"); foreach ($company as $data) { echo "<option value='{$data['id']}' >" . $data['code'] . "</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> </div> </div> <!-- <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="home.php">Home</a></li> <li class="breadcrumb-item active">Dashboard</li> </ol> </div> --> <!-- /.col --> </div><!-- /.row --> </div><!-- /.container-fluid --> </div> <!-- /.content-header --> <!-- Main content --> <section class="content"> <div class="container-fluid"> <!-- Small boxes (Stat box) --> <div class="row"> <div class="col-lg-3 col-6"> <!-- small box --> <div class="small-box bg-info"> <div class="overlay customer_total_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="inner"> <h3> <span id="customer_total">0</span></h3> <p>Customers</p> </div> <div class="icon"> <i class="fa fa-users"></i> </div> <a id="customer_total_info" class="small-box-footer" style="cursor:pointer;">More info <i class="fas fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div class="col-lg-3 col-6" hidden> <!-- small box --> <div class="small-box bg-success"> <div class="inner"> <h3><?php //echo $employee_count; ?> <!-- <sup style="font-size: 20px">%</sup>--> </h3> <p>Employees</p> </div> <div class="icon"> <i class="fa fa-user"></i> </div> <a href="employee.php" class="small-box-footer" style="cursor:pointer;">More info <i class="fas fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div class="col-lg-3 col-6"> <!-- small box --> <div class="small-box bg-warning"> <div class="overlay vehicle_total_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="inner"> <h3> <span id="vehicle_total">0</span></h3> <p>Vehicles</p> </div> <div class="icon"> <i class="fa fa-car"></i> </div> <a id="vehicle_total_info" class="small-box-footer" style="cursor:pointer;">More info <i class="fas fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div class="col-lg-3 col-6"> <!-- small box --> <div class="small-box bg-danger"> <div class="overlay service_total_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="inner"> <h3> <span id="service_total">0</span> </h3> <p>Service</p> </div> <div class="icon"> <i class="fas fas fa-wrench"></i> </div> <a id="service_total_info" class="small-box-footer" style="cursor:pointer;">More info <i class="fas fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div class="col-lg-3 col-6"> <!-- small box --> <div class="small-box bg-success"> <div class="overlay sales_total_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="inner"> <h3> <span id="sales_total">0</span> </h3> <p>Sales Transaction</p> </div> <div class="icon"> <i class="fa fa-dollar-sign"></i> </div> <a id="sales_total_info" class="small-box-footer" style="cursor:pointer;">More info <i class="fas fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> </div> <!-- /.row --> <!-- Main row --> <div class="container-fluid content-row"> <div class="row"> <div class="col-lg-6 mb-2"> <div class="card h-100"> <div class="overlay dms_countings_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div> <i class="float-right tooltip-me mt-2 mr-2 mb-0 fas fa-question-circle" style="color:blue; cursor: help;" data-html="true" data-placement="left" id="bar-chart-title"></i> </div> <canvas class="pr-2 pl-2 " id="bar-chart"></canvas> </div> </div> <div class="col-lg-6 mb-2"> <div class="card h-100"> <div class="overlay customer_countings_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="py-2 px-2"> <div class="progress-group p-0 mt-0 mb-1" id="count-individual"> Individual Customer <span class="float-right"><b><span id="count_individual">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_individual_percent_title"> <div id="count_individual_percent" class="progress-bar bg-success"> </div> </div> </div> <div class="progress-group p-0 mt-0 mb-1" id="count-corporation"> Corporation Customer <span class="float-right"><b><span id="count_corporation">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_corporation_percent_title"> <div id="count_corporation_percent" class="progress-bar bg-primary"> </div> </div> </div> <div class="progress-group p-0 mt-0 mb-1" id="count-male"> Male <span class="float-right"><b><span id="count_male">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_male_percent_title"> <div id="count_male_percent" class="progress-bar bg-danger"></div> </div> </div> <!-- /.progress-group --> <div class="progress-group p-0 mt-0 mb-1" id="count-female"> Female <span class="float-right"><b><span id="count_female">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_female_percent_title"> <div id="count_female_percent" class="progress-bar bg-success"> </div> </div> </div> <!-- /.progress-group --> <div class="progress-group p-0 mt-0 mb-1" id="count-below"> <span class="progress-text">Age Below 30</span> <span class="float-right"><b><span id="count_below">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_below_percent_title"> <div id="count_below_percent" class="progress-bar bg-warning"></div> </div> </div> <!-- /.progress-group --> <div class="progress-group p-0 mt-0 mb-1" id="count-between"> Age Between 31 and 50 <span class="float-right"><b><span id="count_between">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_between_percent_title"> <div class="progress-bar bg-primary" id="count_between_percent"> </div> </div> </div> <!-- /.progress-group --> <div class="progress-group p-0 mt-0 mb-1" id="count-above"> Age 51 and Up <span class="float-right"><b><span id="count_above">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_above_percent_title"> <div class="progress-bar bg-warning" id="count_above_percent"></div> </div> </div> <!-- /.progress-group --> <div class="progress-group p-0 mt-0 mb-1" id="count-vehicle-image"> Vehicle with image <span class="float-right"><b><span id="count_vehicle_image">0</span></b></span> <div class="progress progress-sm tooltip-me" id="count_vehicle_image_percent_title"> <div class="progress-bar bg-success" id="count_vehicle_image_percent"> </div> </div> </div> </div> </div> </div> <div class="col-lg-6 mb-2"> <div class="card h-100"> <div class="overlay complete_incomplete_countings_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <canvas id="donutChart" style="min-height: 250px; height: 250px; max-height: 250px; max-width: 100%;"></canvas> <!-- <div class="my-3 mx-2" id="donut-chart" style="height: 250px;"></div> --> </div> </div> <div class="col-lg-6 mb-2"> <div class="card h-100"> <div class="overlay incomplete_countings_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <canvas class="py-2 px-2" id="pieChart" style="min-height: 250px; height: 250px; max-height: 250px; max-width: 100%;"></canvas> </div> </div> </div> <div class="row"> <div class="col-lg-12 mb-2"> <div class="card" style="height: 300px"> <div class="overlay company_countings_loading"> <i class="fas fa-2x fa-sync-alt fa-spin"></i> </div> <div class="p-0 m-0"> <i class="float-right tooltip-me mt-2 mr-2 mb-0 fas fa-question-circle" style="color:blue; cursor: help;" data-html="true" data-placement="right" id="bar-chart-company-title"></i> </div> <canvas class="pb-5 px-2" id="bar-chart-company"></canvas> </div> </div> </div> </div> <!-- /.row (main row) --> </div><!-- /.container-fluid --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <!-- INSERT FOOTER --> <?php include('include/footer.php'); ?> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> <!-- /.control-sidebar --> </div> <!-- ./wrapper --> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- jQuery UI 1.11.4 --> <script src="plugins/jquery-ui/jquery-ui.min.js"></script> <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip --> <script> $.widget.bridge('uibutton', $.ui.button) </script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- ChartJS --> <script src="plugins/chart.js/Chart.min.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- daterangepicker --> <script src="plugins/moment/moment.min.js"></script> <script src="plugins/daterangepicker/daterangepicker.js"></script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.js"></script> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <script> //GLOBALS WITH PHP var location_url = '<?php echo $variable['site_link'] ?>'; </script> <?php $whitelist = array( '127.0.0.1', '::1' ); if (in_array($_SERVER['REMOTE_ADDR'], $whitelist)) { echo '<script>$("#debuggger").html("<h1>localhost not fetching data due to slow process...</h1>")</script>'; exit; } ?> <script src="dist/js/dashboard/dashboard.js"></script> </body> </html>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings