Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
app_download.php	1.6 KB	-rw-rw-rw-
app_print.php	22.28 KB	-rw-rw-rw-
app_print_230312.php	21.87 KB	-rw-rw-rw-
app_report.php	7 B	-rw-rw-rw-
application.php	13.23 KB	-rw-rw-rw-
application_1.php	5.59 KB	-rw-rw-rw-
audit_trail_1.php	4.23 KB	-rw-rw-rw-
bill.pdf	1.78 KB	-rw-rw-rw-
declaration.php	13.92 KB	-rw-rw-rw-
declaration_1.php	2.35 KB	-rw-rw-rw-
declaration_2.php	2.34 KB	-rw-rw-rw-
declaration_3.php	2.06 KB	-rw-rw-rw-
declaration_4.php	1.93 KB	-rw-rw-rw-
declaration_5.php	2 KB	-rw-rw-rw-
declaration_6.php	2.05 KB	-rw-rw-rw-
declaration_7.php	2.25 KB	-rw-rw-rw-
declaration_8.php	2.57 KB	-rw-rw-rw-
declaration_9.php	123.3 KB	-rw-rw-rw-
declaration_f.php	515 B	-rw-rw-rw-
declaration_prt.php	1.49 KB	-rw-rw-rw-
print_report.php	3.21 KB	-rw-rw-rw-
site_1.php	3 KB	-rw-rw-rw-
site_2.php	3.5 KB	-rw-rw-rw-
user.php	5.95 KB	-rw-rw-rw-
user_1.php	2.38 KB	-rw-rw-rw-

Code Editor : application_1.php

<?php 
	
	$combx1 	= "";

if(!empty($period)){
		if($period=='year'){ 
			$combx1 			.= " AND YEAR(a.tarikhApply) = ? ";
			$param_data['p1'] 	= $year;
		}

if($period=='month'){ 
			$combx1 			.= " AND DATE_FORMAT(a.tarikhApply,'%m-%Y') = ? ";
			$param_data['p2'] 	= $month;
		}
		
		if($period=='week'){ 
			$combx1 			.= " AND (date(a.tarikhApply) BETWEEN STR_TO_DATE(?,'%d-%m-%Y') and STR_TO_DATE(?,'%d-%m-%Y')) ";
			$param_data['p3'] 	= $sdate;
			$param_data['p4'] 	= $edate;
		}

if($period == 'year')
			$report_name 	= "Yearly Report : {$year}";
		else if($period == 'month')
			$report_name 	= "Monthly Report : {$month}";
		else if($period == 'week')
			$report_name 	= "Weekly Report : {$sdate} - {$edate}";

}else{
		$combx1 			.= " AND YEAR(a.tarikhApply) = ? ";
		$param_data['p1'] 	= date('Y');
		$report_name 		= "Yearly Report : ".date('Y');
	}

$sqlx 		= "	SELECT 
						sum(IF(a.flagApproveMFSO='Y' AND a.commentsMFSO != '-bypass-',1,0)) mfso_app, 
						sum(IF(a.flagApproveMFSO='T' AND a.commentsMFSO != '-bypass-',1,0)) mfso_dis, 
						sum(IF(a.flagApproveMFSO='N' AND a.commentsMFSO != '-bypass-',1,0)) mfso_pen, 
						sum(IF(a.commentsMFSO != '-bypass-',1,0)) mfso_tot, 
						sum(IF(a.flagApproveMTSO='Y',1,0)) mtso_app, 
						sum(IF(a.flagApproveMTSO='T',1,0)) mtso_dis, 
						sum(IF(a.flagApproveMTSO='N',1,0)) mtso_pen, 
						sum(1) mfso_tot,
						sum(IF(a.flagApproveDG='Y' AND a.flagDG = 'Y',1,0)) dg_app, 
						sum(IF(a.flagApproveDG='T' AND a.flagDG = 'Y',1,0)) dg_dis, 
						sum(IF(a.flagApproveDG='N' AND a.flagDG = 'Y',1,0)) dg_pen, 
						sum(IF(a.flagDG = 'Y',1,0)) dg_tot
					FROM permohonan_main a
					WHERE 1=1 
					{$combx1}
				";
	$result2 	= mysqli_prepare_all($sqlx,$param_type = "auto",$param_data);
	$rows_app 	= $result2->num_rows;
	$aa = $result2->fetch_assoc();

?>
<h4><b>Application Approval - <?php echo $report_name; ?></b></h4>
<hr>
<?php if(empty($report) || $report=='1'){?>
<?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>MFSO</span></strong></h3>"; ?>
<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete">
	<thead>
		<tr>
			<th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th>
			<th class="text-left" style="width: 75%">Application</th>
			<th class="text-center" style="width: 150px !important;width: 20%">Total</th>
		</tr>
	</thead>
	<tbody>
		<tr class="success">
			<td class="align-top text-right">1.</td>
			<td class="align-top text-left">ACKNOWLEDGED</td>
			<td class="align-top text-right"><?php echo $aa['mfso_app']?></td>
		</tr>
		<tr class="danger">
			<td class="align-top text-right">2.</td>
			<td class="align-top text-left">REJECTED</td>
			<td class="align-top text-right"><?php echo $aa['mfso_dis']?></td>
		</tr>
		<tr class="warning">
			<td class="align-top text-right">3.</td>
			<td class="align-top text-left">PENDING</td>
			<td class="align-top text-right"><?php echo $aa['mfso_pen']?></td>
		</tr>
	</tbody>
</table>
<?php }?>

<?php if(empty($report) || $report=='2'){?>
<?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>MTSO</span></strong></h3>"; ?>
<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete">
	<thead>
		<tr>
			<th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th>
			<th class="text-left" style="width: 75%">Application</th>
			<th class="text-center" style="width: 150px !important;width: 20%">Total</th>
		</tr>
	</thead>
	<tbody>
		<tr class="success">
			<td class="align-top text-right">1.</td>
			<td class="align-top text-left">ACKNOWLEDGED</td>
			<td class="align-top text-right"><?php echo $aa['mtso_app']?></td>
		</tr>
		<tr class="danger">
			<td class="align-top text-right">2.</td>
			<td class="align-top text-left">REJECTED</td>
			<td class="align-top text-right"><?php echo $aa['mtso_dis']?></td>
		</tr>
		<tr class="warning">
			<td class="align-top text-right">3.</td>
			<td class="align-top text-left">PENDING</td>
			<td class="align-top text-right"><?php echo $aa['mtso_pen']?></td>
		</tr>
	</tbody>
</table>
<?php }?>

<?php if(empty($report) || $report=='3'){?>
<?php echo "<h3 style='color:#454e'><strong><i class='gi gi-pencil'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>DG</span></strong></h3>"; ?>
<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete">
	<thead>
		<tr>
			<th class="text-center no_sorting" style="width: 40px !important;width: 5%">No.</th>
			<th class="text-left" style="width: 75%">Application</th>
			<th class="text-center" style="width: 150px !important;width: 20%">Total</th>
		</tr>
	</thead>
	<tbody>
		<tr class="success">
			<td class="align-top text-right">1.</td>
			<td class="align-top text-left">eDG ENABLED</td>
			<td class="align-top text-right"><?php echo $aa['dg_app']?></td>
		</tr>
		<tr class="danger">
			<td class="align-top text-right">2.</td>
			<td class="align-top text-left">REJECTED</td>
			<td class="align-top text-right"><?php echo $aa['dg_dis']?></td>
		</tr>
		<tr class="warning">
			<td class="align-top text-right">3.</td>
			<td class="align-top text-left">PENDING</td>
			<td class="align-top text-right"><?php echo $aa['dg_pen']?></td>
		</tr>
	</tbody>
</table>
<?php }?>

${this.title}

Code Editor : application_1.php