One Hat Cyber Team
Your IP :
172.16.0.254
Server IP :
58.26.163.33
Server :
Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Server Software :
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
PHP Version :
7.3.25
Buat File
|
Buat Folder
Eksekusi
Dir :
C:
/
xampp7
/
htdocs
/
edgpens_220704
/
View File Name :
dashboard.php
<?php if(empty($page)){ include("access.php"); } ?> <?php $user = get_user_full($_SESSION['session']);?> <? $roles = (int)$user['idRoles']; $idUser = (int)$user['idUser']; $qRole="SELECT nama FROM user_roles WHERE idRoles='$user[idRoles]'"; $resRole=mysqli_query($mysqli_link, $qRole) or die(mysqli_connect_error()); $rowRole=mysqli_fetch_array($resRole); ?> <!-- Blank Header --> <div class="content-header"> <!-- <div class="row"> <div class="col-sm-12 themed-background-info clearfix"> <div class="widget-content "> <div class="img-thumbnail-avatar pull-left"><i class="fa fa-user" style="font-size: 50pt"></i></div> <h2 class="widget-heading h3 text-light"><strong><?=$user['nameUser']?></strong></h2> <span class="text-light-op">ROLE: <?=$rowRole['nama']?></span> </div> </div> </div> --> <!-- <div class="row"> <div class="col-sm-12"><BR></div> </div> --> </div> <!-- END Blank Header --> <!-- <div class="row"> <div class="col-sm-6 col-lg-4"> <a href="javascript:void(0)" class="widget"> <div class="widget-content widget-content-mini themed-background-dark-social"> <strong class="text-light-op">Pending Approval</strong> </div> <div class="widget-content themed-background-social clearfix"> <div class="widget-icon pull-right"> <i class="gi gi-boat text-light-op"></i> </div> <h2 class="widget-heading h3 text-light"><strong><span data-toggle="counter" data-to="3"></span></strong></h2> <span class="text-light-op">VESSELS</span> </div> </a> </div> <div class="col-sm-6 col-lg-4"> <a href="javascript:void(0)" class="widget"> <div class="widget-content widget-content-mini themed-background-dark-flat"> <strong class="text-light-op">Pending Approval</strong> </div> <div class="widget-content themed-background-flat clearfix"> <div class="widget-icon pull-right"> <i class="gi gi-anchor text-light-op"></i> </div> <h2 class="widget-heading h3 text-light"><strong><span data-toggle="counter" data-to="1"></strong></h2> <span class="text-light-op">PORTS</span> </div> </a> </div> <div class="col-sm-6 col-lg-4"> <a href="javascript:void(0)" class="widget"> <div class="widget-content widget-content-mini themed-background-dark-creme"> <strong class="text-light-op">Pending Approval</strong> </div> <div class="widget-content themed-background-creme clearfix"> <div class="widget-icon pull-right"> <i class="gi gi-group text-light-op"></i> </div> <h2 class="widget-heading h3 text-light"><strong><span data-toggle="counter" data-to="10"></strong></h2> <span class="text-light-op">COMPANIES</span> </div> </a> </div> </div> --> <style type="text/css"> div.custom-height { height:90px; } .short-div { height:50%; } .badge-custom{ font-size: 12pt; } .badge-counter{ display: inline-block; width: 50px; } </style> <div class="row"> <div class="col-lg-6"> <div class="widget"> <?php if($roles == 2 || $roles == 5){ $q1="SELECT SUM(IF(idApproveMFSO=0,1,0)) AS tot_pending, SUM(if(tot_ack=1,1,0)) AS tot_ack from permohonan_cnt "; if($roles == 2) $q1.=" WHERE idApproveMFSO = 0 OR idApproveMFSO = {$idUser}"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); ?> <div class="widget-content themed-background-flat text-left clearfix"> <div class="row"> <div class="col-xs-6 custom-height"> <h3 class="widget-heading text-light">MFSO</h3> </div> <div class="col-xs-6 custom-height"> <div class="row short-div" style=""> <div class="col-md-12"> <span class="pull-right"><b style="color: white">PENDING</b></span> <br> <span class="pull-right badge badge-custom text-warning"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_pending'];?>"></span> </span> </div> </div> <div class="row short-div" style=""> <div class="col-md-12"> <span class="pull-right"><b style="color: white">ACKNOWLEDGED</b></span> <br> <span class="pull-right badge badge-custom text-success"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_ack'];?>"></span> </span> </div> </div> </div> </div> </div> <?php } ?> <?php if($roles == 3 || $roles == 5){ $q1="SELECT SUM(IF(idApproveMTSO=0,1,0)) AS tot_pending, SUM(if(tot_app=1,1,0)) AS tot_app from permohonan_cnt WHERE idApproveMFSO != 0 AND tot_ack = 1 "; if($roles == 2) $q1.=" AND (idApproveMTSO = 0 OR idApproveMTSO = {$idUser})"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); ?> <div class="widget-content themed-background-amethyst text-left clearfix"> <div class="row"> <div class="col-xs-6 custom-height"> <h3 class="widget-heading text-light">MTSO</h3> </div> <div class="col-xs-6 custom-height"> <div class="row short-div" style=""> <div class="col-md-12"> <span class="pull-right"><b style="color: white">PENDING</b></span> <br> <span class="pull-right badge badge-custom text-warning"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_pending'];?>"></span> </span> </div> </div> <div class="row short-div" style=""> <div class="col-md-12"> <span class="pull-right"><b style="color: white">APPROVED</b></span> <br> <span class="pull-right badge badge-custom text-success"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_app'];?>"></span> </span> </div> </div> </div> </div> </div> <?php } ?> <?php if($roles == 1){ $q1="SELECT SUM(IF(tot_ack=0,1,0)) AS tot_pending, SUM(tot_ack) AS tot_ack, SUM(tot_app) AS tot_app from permohonan_cnt WHERE 1 AND submit='Y' AND ETA >= NOW() AND ETA != '0000-00-00 00:00:00' AND idUserApply = {$idUser} "; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); ?> <div class="widget-content themed-background-amethyst text-left clearfix"> <div class="row"> <div class="col-xs-12"> <center><h3 class="widget-heading text-light"><b>STATUS APPLICATION BEFORE ARRIVAL DATE</b></h3></center> <hr> </div> </div> <div class="row"> <div class="col-xs-4"> <center> <span style="color: white">PENDING</span> <br> <span class="badge badge-custom text-warning"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_pending'];?>"></span> </span> </center> </div> <div class="col-xs-4"> <center> <span style="color: white">ACKNOWLEDGED</span> <br> <span class="badge badge-custom text-warning"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_ack'];?>"></span> </span> </center> </div> <div class="col-xs-4"> <center> <span style="color: white">APPROVED</span> <br> <span class="badge badge-custom text-warning"> <span class="badge-counter" data-toggle="counter" data-to="<?php echo $rslt['tot_app'];?>"></span> </span> </center> </div> </div> </div> <?php } ?> </div> </div> <?php if($roles == '1'){ ?> <div class="col-lg-6"> <div class="widget"> <div class="widget-content themed-background-passion text-left clearfix"> <h3 class="widget-heading text-light">Pending Approval <i class="gi gi-circle_exclamation_mark"></i> </h3> </div> <?php $q1="SELECT if(tot_kapal IS NULL,0,tot_kapal) AS tot_kapal, if(tot_pelabuhan IS NULL,0,tot_pelabuhan) AS tot_pelabuhan, if(tot_syarikat IS NULL, 0,tot_syarikat) AS tot_syarikat FROM dummy LEFT JOIN (SELECT SUM(1) AS tot_kapal, flagApprove FROM `kod_kapal` a WHERE 1 AND a.flagApprove = 'N' AND idUserApply='{$idUser}' GROUP BY flagApprove) a ON 1 LEFT JOIN (SELECT SUM(1) AS tot_pelabuhan, flagApprove FROM `kod_pelabuhan` a WHERE 1 AND a.flagApprove = 'N' AND idUserApply='{$idUser}' GROUP BY flagApprove) b ON 1 LEFT JOIN (SELECT SUM(1) AS tot_syarikat, flagApprove FROM `kod_syarikat` a WHERE 1 AND a.flagApprove = 'N' AND idUserApply='{$idUser}' GROUP BY flagApprove) c ON 1 "; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); ?> <div class="widget-content text-center"> <div class="row text-center"> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-boat"></i><BR> <small>VESSELS</small><BR> <a href="index.php?page=kod/kodKapal_a" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_kapal'];?>"></a> </h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-anchor"></i><BR> <small>PORTS</small><BR> <a href="index.php?page=kod/kodPort_a" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_pelabuhan'];?>"></a> </h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-group"></i><BR> <small>COMPANIES</small><BR> <a href="index.php?page=kod/kodSyarikat_a" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_syarikat'];?>"></a> </h3> </div> </div> </div> </div> </div> <?php } ?> <?php if($roles == '5'){ ?> <div class="col-lg-6"> <div class="widget"> <div class="widget-content themed-background-passion text-left clearfix"> <h3 class="widget-heading text-light">Pending Approval <i class="gi gi-circle_exclamation_mark"></i> </h3> </div> <?php $q1="SELECT * FROM pending_approval"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); ?> <div class="widget-content text-center"> <div class="row text-center"> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-boat"></i><BR> <small>VESSELS</small><BR> <a href="index.php?page=kod/kodKapal" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_kapal'];?>"></a> </h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-anchor"></i><BR> <small>PORTS</small><BR> <a href="index.php?page=kod/kodPort" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_pelabuhan'];?>"></a> </h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"> <i class="gi gi-group"></i><BR> <small>COMPANIES</small><BR> <a href="index.php?page=kod/kodSyarikat" class="themed-color-passion"><span data-toggle="counter" data-to="<?php echo $rslt['tot_syarikat'];?>"></a> </h3> </div> </div> </div> </div> </div> <?php } ?> </div> <?php $q1="SELECT * FROM monthly_app"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); $rslt=mysqli_fetch_array($res1); if($roles == '5'){ ?> <div class="row"> <div class="col-lg-6"> <div class="widget"> <div class="widget-content widget-content-mini themed-background-dark-default text-light text-center"> <i class="fa fa-bar-chart-o"></i> <strong>Monthly Stats [PENS]</strong> </div> <div class="widget-content themed-background-muted"> <div class="row text-center"> <div class="col-xs-4"> <h3 class="widget-heading"><i class="gi gi-buoy text-muted push"></i><BR><small>TOTAL</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_permohonan'];?>" ></h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"><i class="hi hi-warning-sign text-muted push"></i><BR><small>ACKNOWLEDGED</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_ack'];?>"></h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"><i class="hi hi-warning-sign text-muted push"></i><BR><small>APPROVED</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_app'];?>"></h3> </div> </div> </div> <div class="widget-content"> <!-- Get Started Content --> <?php $q1="SELECT COUNT(*) as bil, flagDG FROM permohonan_main WHERE submit='Y' GROUP BY flagDG"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); ?> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", {packages:["corechart"]}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['TYPE', 'NO'], <?php while($row1 = mysqli_fetch_array($res1)) { if($row1["flagDG"]=="Y"){ $type="PENS + DG"; }else{ $type="PENS"; } echo "['".$type."', ".$row1["bil"]."],"; } ?> ]); var options = { //title: 'My Daily Activities', is3D: true, // legend: 'none', legend: {position: 'labeled', textStyle: {color: 'black', fontSize: 13, bold: true}}, colors: ['#1b9e77', '#fa8654', '#99cc00', '#d95f02', '#9797ff', '#DEB25C'], //pieHole: 0.5, //pieStartAngle: 100, pieSliceText: 'none', }; var chart = new google.visualization.PieChart(document.getElementById('piechart_3d')); chart.draw(data, options); } </script> <div id="piechart_3d" style="height: 400px;"></div> </div> </div> </div> <div class="col-lg-6"> <div class="widget"> <div class="widget-content widget-content-mini themed-background-dark-default text-light text-center"> <i class="fa fa-bar-chart-o"></i> <strong>Monthly Stats [DG]</strong> </div> <div class="widget-content themed-background-muted"> <div class="row text-center"> <div class="col-xs-4"> <h3 class="widget-heading"><i class="gi gi-buoy text-muted push"></i><BR><small>TOTAL</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_dg'];?>" ></h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"><i class="gi gi-buoy text-muted push"></i><BR><small>ENABLED</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_dg_enab'];?>" ></h3> </div> <div class="col-xs-4"> <h3 class="widget-heading"><i class="hi hi-warning-sign text-muted push"></i><BR><small>APPROVED</small><br><span data-toggle="counter" data-to="<?php echo $rslt['tot_dg_app'];?>"></h3> </div> </div> </div> <div class="widget-content"> <!-- Get Started Content --> <?php $q1="SELECT COUNT(*) as bil, flagDG FROM permohonan_main WHERE submit='Y' GROUP BY flagDG"; $res1=mysqli_query($mysqli_link,$q1) or die(mysqli_connect_error()); ?> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load("current", {packages:["corechart"]}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['TYPE', 'NO'], <?php while($row1 = mysqli_fetch_array($res1)) { if($row1["flagDG"]=="Y"){ $type="PENS + DG"; }else{ $type="PENS"; } echo "['".$type."', ".$row1["bil"]."],"; } ?> ]); var options = { //title: 'My Daily Activities', is3D: true, // legend: 'none', legend: {position: 'labeled', textStyle: {color: 'black', fontSize: 13, bold: true}}, colors: ['#FFA500', '#99FF99', '#1b9e77', '#fa8654', '#99cc00', '#d95f02'], //pieHole: 0.5, //pieStartAngle: 100, pieSliceText: 'none', }; var chart2 = new google.visualization.PieChart(document.getElementById('piechart_3d2')); chart2.draw(data, options); } </script> <div id="piechart_3d2" style="height: 400px;"></div> </div> </div> </div> </div> <?php }?> <!-- Load and execute javascript code used only in this page --> <script src="js/pages/uiWidgets.js"></script> <script>$(function(){ UiWidgets.init(); });</script>