Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
css	[ DIR ]	drwxrwxrwx
edg	[ DIR ]	drwxrwxrwx
edg_200430	[ DIR ]	drwxrwxrwx
edg_20200630	[ DIR ]	drwxrwxrwx
edg_old	[ DIR ]	drwxrwxrwx
extension	[ DIR ]	drwxrwxrwx
img	[ DIR ]	drwxrwxrwx
inc	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
kod	[ DIR ]	drwxrwxrwx
pdf	[ DIR ]	drwxrwxrwx
reports	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
utility	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
.htaccess	1.16 KB	-rw-rw-rw-
!test.php	17 B	-rw-rw-rw-
Nota14102020.docx	22.8 KB	-rw-rw-rw-
access.php	253 B	-rw-rw-rw-
access2.php	245 B	-rw-rw-rw-
account_recovery.php	7.85 KB	-rw-rw-rw-
ajax.php	3.6 KB	-rw-rw-rw-
company_search.php	8.37 KB	-rw-rw-rw-
composer.json	1.42 KB	-rw-rw-rw-
composer.lock	156.45 KB	-rw-rw-rw-
ctype.txt	266 B	-rw-rw-rw-
custom.css	3.7 KB	-rw-rw-rw-
custom.js	9.66 KB	-rw-rw-rw-
custom200630.js	6.46 KB	-rw-rw-rw-
custom_200630.css	1.04 KB	-rw-rw-rw-
custom_200705.js	6.82 KB	-rw-rw-rw-
dashboard.php	21.52 KB	-rw-rw-rw-
dashboard_old.php	51 B	-rw-rw-rw-
dbedgpens.sql	3.85 MB	-rw-rw-rw-
dglist.php	3.97 KB	-rw-rw-rw-
dgweb-dg.txt	2.65 MB	-rw-rw-rw-
dgweb.xls	297.5 KB	-rw-rw-rw-
err_404.php	75 B	-rw-rw-rw-
imp_data.php	2.03 KB	-rw-rw-rw-
index.php	2.83 KB	-rw-rw-rw-
index_footer.php	138 B	-rw-rw-rw-
index_head.php	663 B	-rw-rw-rw-
index_search.php	667 B	-rw-rw-rw-
ins_composer.php	417 B	-rw-rw-rw-
ktn-pens-companies.txt	330.12 KB	-rw-rw-rw-
ktn-pens-port.txt	602.81 KB	-rw-rw-rw-
ktn-pens-vessel.txt	6.12 MB	-rw-rw-rw-
ktn-pens-vtype.txt	353 B	-rw-rw-rw-
login.php	11.47 KB	-rw-rw-rw-
login_200704.php	9.81 KB	-rw-rw-rw-
main.php	584 B	-rw-rw-rw-
nota.txt	120 B	-rw-rw-rw-
odbc.php	18.73 KB	-rw-rw-rw-
odbc_test.php	15.24 KB	-rw-rw-rw-
readtext.php	7.99 KB	-rw-rw-rw-
recover_msg.php	806 B	-rw-rw-rw-
registration.php	24.54 KB	-rw-rw-rw-
registration_2.php	12.94 KB	-rw-rw-rw-
registration_submit.php	5.18 KB	-rw-rw-rw-
reset_password.php	9.48 KB	-rw-rw-rw-
self_register.php	14.57 KB	-rw-rw-rw-
sessions.php	2.78 KB	-rw-rw-rw-
sessions_200705.php	1.4 KB	-rw-rw-rw-
sessions_200721.php	1.75 KB	-rw-rw-rw-
test.php	11.8 KB	-rw-rw-rw-
test_sess.php	1.35 KB	-rw-rw-rw-
testinput.php	6.7 KB	-rw-rw-rw-
testx.php	4 B	-rw-rw-rw-
vessel.txt	498.07 KB	-rw-rw-rw-
vessel2.txt	249.04 KB	-rw-rw-rw-
zzz	11 B	-rw-rw-rw-
zzz.txt	249.04 KB	-rw-rw-rw-
~$ta14102020.docx	162 B	-rw-rw-rw-
~WRL0738.tmp	23.29 KB	-rw-rw-rw-

Code Editor : 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);

<div class="content-header">

</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&nbsp;<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&nbsp;<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="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">
        
<?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());
?>

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>
            </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">
        
<?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());
?>

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>
            </div>
        </div>
		
	</div>

<?php }?>

<script src="js/pages/uiWidgets.js"></script>
<script>$(function(){ UiWidgets.init(); });</script>

${this.title}

Code Editor : dashboard.php