One Hat Cyber Team

Edit File: Dashboard_Page.php

<?php
require_once("module/Systems_Authenticate/Verify_user.php");
require_once("module/Systems_Authenticate/Verify_admin.php");
require_once("module/Systems_main/header_web.php");
require_once("build/function/function.inc.php");
require_once("module/Systems_Connect/DBConnect.php");

$DataShowNumBussinessMan = "SELECT * FROM tbl_businessman";
$DataShowNumBussinessManQuery = mysqli_query($con, $DataShowNumBussinessMan);
$DataShowNumBussinessManResult = mysqli_fetch_array($DataShowNumBussinessManQuery);
$DataShowNumBussinessManCount = mysqli_num_rows($DataShowNumBussinessManQuery);

$DataShowNumLicense = "SELECT * FROM tbl_data_application
        INNER JOIN tbl_type_document ON tbl_data_application.type_document_id = tbl_type_document.type_document_id
        WHERE tbl_type_document.type_document_style='1' ";
$DataShowNumLicenseQuery = mysqli_query($con, $DataShowNumLicense);
$DataShowNumLicenseResult = mysqli_fetch_array($DataShowNumLicenseQuery);
$DataShowNumLicenseCount = mysqli_num_rows($DataShowNumLicenseQuery);

$DataShowNumBook = "SELECT * FROM tbl_data_application
        INNER JOIN tbl_type_document ON tbl_data_application.type_document_id = tbl_type_document.type_document_id
        WHERE tbl_type_document.type_document_style='2' ";
$DataShowNumBookQuery = mysqli_query($con, $DataShowNumBook);
$DataShowNumBookResult = mysqli_fetch_array($DataShowNumBookQuery);
$DataShowNumBookCount = mysqli_num_rows($DataShowNumBookQuery);

$DataShowAllApp = "SELECT * FROM tbl_data_application
        INNER JOIN tbl_businessman ON tbl_data_application.businessman_id = tbl_businessman.businessman_id 
        INNER JOIN tbl_type_document ON tbl_data_application.type_document_id = tbl_type_document.type_document_id
        INNER JOIN tbl_member ON tbl_data_application.member_id = tbl_member.member_id
        ORDER BY tbl_data_application.data_application_id DESC limit 5";
$DataShowAllAppQuery = mysqli_query($con, $DataShowAllApp);

$DataShowAllAppCount = mysqli_num_rows($DataShowAllAppQuery);

$DataShow = "SELECT * FROM tbl_data_application
        INNER JOIN tbl_businessman ON tbl_data_application.businessman_id = tbl_businessman.businessman_id
        INNER JOIN tbl_type_document ON tbl_data_application.type_document_id = tbl_type_document.type_document_id
        INNER JOIN tbl_type_application ON tbl_data_application.application_type = tbl_type_application.type_application_id
        INNER JOIN tbl_data_license ON tbl_data_application.data_application_id = tbl_data_license.data_application_id
        ORDER BY tbl_data_license.data_license_date_end ASC";
$DataShowQuery = mysqli_query($con, $DataShow);

$DataAllProgram = "SELECT * FROM tbl_config_program WHERE config_program_id='1' ";
$DataAllProgramQuery = mysqli_query($con, $DataAllProgram);
$DataAllProgramResult = mysqli_fetch_array($DataAllProgramQuery);
$datacode_cus = $DataAllProgramResult["code_cus"];

$DataConfig = "SELECT * FROM tbl_config_institution";
$DataConfigQuery = mysqli_query($con, $DataConfig);
$DataConfigResult = mysqli_fetch_array($DataConfigQuery);
if ($DataConfigResult["institution_logo"] == "") {
  $LogoImageShow = "no_logo.png";
} else {
  $LogoImageShow = $DataConfigResult["institution_logo"];
}

?>

<link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css">

<link rel="stylesheet" href="plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css">

<div class="content-wrapper">
  
  <div class="content-header">
    <div class="container-fluid">
      <div class="row mb-2">
        <div class="col-sm-6">
          <h1 class="m-0 text-dark">แผงควบคุม</h1>
          <?php  
           $Bar1Show=date('Y-m-d', strtotime('-1 month'));
           $Bar1Show=ThaiShortDateTime4($Bar1Show);

$Bar2Show=date('Y-m-d', strtotime('-2 month'));
           $Bar2Show=ThaiShortDateTime4($Bar2Show);
          
           
           $Bar3Show=date('Y-m-d', strtotime('-3 month'));
           $Bar3Show=ThaiShortDateTime4($Bar3Show);

$Bar4Show=date('Y-m-d', strtotime('-4 month'));
           $Bar4Show=ThaiShortDateTime4($Bar4Show);

$Bar5Show=date('Y-m-d', strtotime('-5 month'));
           $Bar5Show=ThaiShortDateTime4($Bar5Show);

$Bar6Show=date('Y-m-d', strtotime('-6 month'));
           $Bar6Show=ThaiShortDateTime4($Bar6Show);
          ?>
        </div>

</div>
    </div>
  </div>

<section class="content">
    <div class="container-fluid">

<div class="small-box bg-info">
            <div class="inner">
              <h3><?php echo $DataShowNumBussinessManCount; ?></h3>
              <p>ข้อมูลผู้ประกอบการ</p>
            </div>
            <div class="icon">

<div class="small-box bg-success">
            <div class="inner">
              <h3><?php echo $DataShowNumLicenseCount; ?></h3>
              <p>ข้อมูลใบอนุญาต</p>
            </div>
            <div class="icon">
              <i class="fas fa-passport"></i>
            </div>
            <a href="#" class="small-box-footer">
              ทั้งหมด <i class="fas fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>

<div class="small-box bg-warning">
            <div class="inner">
              <h3><?php echo $DataShowNumBookCount; ?></h3>
              <p>ข้อมูลหนังสือรับรองฯ</p>
            </div>
            <div class="icon">
              <i class="fas fa-book"></i>
            </div>
            <a href="#" class="small-box-footer">
              ทั้งหมด <i class="fas fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>

</div>

<!--
      <div class="row">
        <div class="col-md-4 col-sm-4 col-4">
          <div class="card card-danger">
            <div class="card-body">
              <canvas id="donutChart" style="min-height: 250px; height: 250px; max-height: 250px; max-width: 100%;"></canvas>
            </div>
          </div>
        </div>

</div>
-->

<div class="card card-success">
            <div class="card-header">
              <h3 class="card-title">คำขอ 5 รายการล่าสุด</h3>

</div>
            
            <div class="card-body" style="height: 568px;">

<?php while ($DataShowAllAppResult = mysqli_fetch_array($DataShowAllAppQuery)) { ?>

<div>
                      <i class="	far fa-calendar-plus bg-warning"></i>
                      <div class="timeline-item">
                        <span class="time"><i class="far fa-calendar"></i> <?php echo ThaiShortDateTime3($DataShowAllAppResult["application_creation_date"]); ?> </span>
                        <h3 class="timeline-header"><a href="#" onclick="window.location='index.php?page=AppicationShow&typedoc=<?php echo $DataShowAllAppResult["type_document_code"]; ?>&idAction=<?php echo $DataShowAllAppResult["data_application_id"]; ?>';"> <?php echo $DataShowAllAppResult["titlename_name"] . "" . $DataShowAllAppResult["businessman_fname"] . "&nbsp;&nbsp;&nbsp;" . $DataShowAllAppResult["businessman_lname"]; ?></a> <?php echo $DataShowAllAppResult["type_document_name"]; ?> </h3> <span class="time"><i class="fas fa-user-edit"></i> <?php echo $DataShowAllAppResult["member_firstname"] . " " . $DataShowAllAppResult["member_lastname"] ?></span>
                        <div class="timeline-body">
                        <?php echo $DataShowAllAppResult["data_business_title"]; ?>
                        </div>

</div>
                    </div>
                  <?php } ?>

</div>
              </div>

</div>
            
          </div>

</div>
        
        <div class="col-md-6 col-sm-12 col-12" >
          <div class="card card-yellow">
            <div class="card-header">
              <h3 class="card-title">แจ้งเตือนใบอนุญาต/หนังสือรับรองฯ ตั้งแต่ 90 วัน</h3>

</div>
            
            <div class="row">
                <div class="col-12">

<div class="card-body" style="font-size: 12px;height: 568px;">
                      <table id="tabledata1" class="table table-bordered table-hover" style="font-size: 12px;">
                        <thead >
                          <tr>
                            <th width="5%">#</th>
                            <th>ชื่อสถานประกอบการ</th>
                            <th>ประเภท</th>
                            <th>วันที่หมดอายุ</th>
                            <th>จำนวนวัน</th>
                          </tr>
                        </thead>
                        <tbody >
                       
                        </tbody>
                       
                      </table>
                    </div>

</div>

</div>
            
          </div>

</div>

</div>

<div class="col-md-6 col-sm-12 col-12">
          <div class="card card-orange">
            <div class="card-header">
              <h3 class="card-title">แจ้งเตือนใบอนุญาต/หนังสือรับรองฯ ตั้งแต่ 60 วัน</h3>

</div>
            
            <div class="row">
                <div class="col-12">

<div class="card-body" style="font-size: 12px;height: 568px;">
                      <table id="tabledata2" class="table table-bordered table-hover" style="font-size: 12px;">
                        <thead >
                          <tr>
                            <th width="5%">#</th>
                            <th>ชื่อสถานประกอบการ</th>
                            <th>ประเภท</th>
                            <th>วันที่หมดอายุ</th>
                            <th>จำนวนวัน</th>
                          </tr>
                        </thead>
                        <tbody >
                    
                        
                        </tbody>
                       
                      </table>
                    </div>

</div>

</div>
            
          </div>

</div>

<div class="col-md-6 col-sm-12 col-12">
          <div class="card card-red">
            <div class="card-header">
              <h3 class="card-title">แจ้งเตือนใบอนุญาต/หนังสือรับรองฯ ตั้งแต่ 30 วัน</h3>

</div>

<div class="card-body" style="font-size: 12px;height: 568px;">
                      <table id="tabledata3" class="table table-bordered table-hover" style="font-size: 12px;">
                        <thead >
                          <tr>
                            <th width="5%">#</th>
                            <th>ชื่อสถานประกอบการ</th>
                            <th>ประเภท</th>
                            <th>วันที่หมดอายุ</th>
                            <th>จำนวนวัน</th>
                          </tr>
                        </thead>
                        <tbody >
                        
                        
                        
                        </tbody>
                       
                      </table>
                    </div>

</div>

</div>

</div>

</div>

</div>
</section>

</div>

<?php
require_once("module/Systems_main/footer_web.php");
?>

<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="plugins/select2/js/select2.full.min.js"></script>
<script src="plugins/chart.js/Chart.min.js"></script>
<script>
  $(function() {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#tabledata1').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
      "language": {
        "search": "ค้นหา :",
        "lengthMenu": "แสดง _MENU_ รายการ ต่อ หน้า",
        "zeroRecords": "ไม่มีพบข้อมูล",
        "infoEmpty": "ไม่มีพบข้อมูล",
        "info": "แสดงหน้า _PAGE_ ถึง _PAGES_",
        "paginate": {
        "first":      "หน้าแรก",
        "last":       "หน้าสุดท้าย",
        "next":       "ต่อไป",
        "previous":   "ก่อนหน้า"
    },
  },
    });

$('#tabledata2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
      "language": {
        "search": "ค้นหา :",
        "lengthMenu": "แสดง _MENU_ รายการ ต่อ หน้า",
        "zeroRecords": "ไม่มีพบข้อมูล",
        "infoEmpty": "ไม่มีพบข้อมูล",
        "info": "แสดงหน้า _PAGE_ ถึง _PAGES_",
        "paginate": {
        "first":      "หน้าแรก",
        "last":       "หน้าสุดท้าย",
        "next":       "ต่อไป",
        "previous":   "ก่อนหน้า"
    },
  },
    });

$('#tabledata3').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
      "language": {
        "search": "ค้นหา :",
        "lengthMenu": "แสดง _MENU_ รายการ ต่อ หน้า",
        "zeroRecords": "ไม่มีพบข้อมูล",
        "infoEmpty": "ไม่มีพบข้อมูล",
        "info": "แสดงหน้า _PAGE_ ถึง _PAGES_",
        "paginate": {
        "first":      "หน้าแรก",
        "last":       "หน้าสุดท้าย",
        "next":       "ต่อไป",
        "previous":   "ก่อนหน้า"
    },
  },
    });

//Initialize Select2 Elements
    $('.select2').select2()

//Initialize Select2 Elements
    $('.select2bs4').select2({
      theme: 'bootstrap4'
    })

//Initialize Select2 Elements
    $('.select2bs5').select2({
      theme: 'bootstrap4'
    })

});

//-------------
  //- DONUT CHART -
  //-------------
  // Get context with jQuery - using jQuery's .get() method.
  var donutChartCanvas = $('#donutChart').get(0).getContext('2d')
  var donutData = {
    labels: [
      'ใบอนุญาต',
      'หนังสือรับรองฯ',

],
    datasets: [{
      data: [<?php echo $DataShowNumLicenseCount;?>, <?php echo $DataShowNumBookCount;?>],
      backgroundColor: ['#f56954', '#00a65a', '#f39c12', '#00c0ef', '#3c8dbc', '#d2d6de'],
    }]
  }
  var donutOptions = {
    maintainAspectRatio: false,
    responsive: true,
  }
  //Create pie or douhnut chart
  // You can switch between pie and douhnut using the method below.
  new Chart(donutChartCanvas, {
    type: 'doughnut',
    data: donutData,
    options: donutOptions
  })

var areaChartOptions = {
    maintainAspectRatio: false,
    responsive: true,
    legend: {
      display: false
    },
    scales: {
      xAxes: [{
        gridLines: {
          display: false,
        }
      }],
      yAxes: [{
        gridLines: {
          display: false,
        }
      }]
    }
  }

//-------------
  //- BAR CHART -
  //-------------
  var barChartCanvas = $('#barChart').get(0).getContext('2d')
  var barChartData = $.extend(true, {}, areaChartData)
  var temp0 = areaChartData.datasets[0]
  var temp1 = areaChartData.datasets[1]
  barChartData.datasets[0] = temp1
  barChartData.datasets[1] = temp0

var barChartOptions = {
    responsive: true,
    maintainAspectRatio: false,
    datasetFill: false
  }

new Chart(barChartCanvas, {
    type: 'bar',
    data: barChartData,
    options: barChartOptions
  })
</script>