Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
detail.php	29.97 KB	-rw-rw-rw-
detail_20210104.php	32.67 KB	-rw-rw-rw-
dg.php	43.04 KB	-rw-rw-rw-
dg_20200723.php	51.85 KB	-rw-rw-rw-
dg_20201219.php	50 KB	-rw-rw-rw-
isps_info-1.php	16.45 KB	-rw-rw-rw-
isps_info.php	12.96 KB	-rw-rw-rw-
isps_info_20200723.php	18.17 KB	-rw-rw-rw-
isps_infox.php	14.94 KB	-rw-rw-rw-
main(3).php	644 B	-rw-rw-rw-
main(5).php	51.58 KB	-rw-rw-rw-
main.php	52.4 KB	-rw-rw-rw-
main_20201220.php	31.43 KB	-rw-rw-rw-
main_20201222.php	31.43 KB	-rw-rw-rw-
main_20210408.php	47.29 KB	-rw-rw-rw-
main_20220621.php	55.52 KB	-rw-rw-rw-
main_230312.php	51.76 KB	-rw-rw-rw-
mainx.php	30.78 KB	-rw-rw-rw-
other_part.php	17.22 KB	-rw-rw-rw-
other_part_20200723.php	15.45 KB	-rw-rw-rw-
other_part_20201219.php	13.56 KB	-rw-rw-rw-
port_call.php	32.4 KB	-rw-rw-rw-
port_call_20200723.php	23.49 KB	-rw-rw-rw-
port_call_20220413.php	22.79 KB	-rw-rw-rw-
port_call_230312.php	32.38 KB	-rw-rw-rw-
s_detail.php	27.87 KB	-rw-rw-rw-
s_detail_240205.php	27.79 KB	-rw-rw-rw-
s_info.php	28.24 KB	-rw-rw-rw-
s_main.php	14.85 KB	-rw-rw-rw-
s_main_240205.php	14.81 KB	-rw-rw-rw-
s_upload_me.php	1.56 KB	-rw-rw-rw-
ship_particular_20200723.php	27.12 KB	-rw-rw-rw-
ship_particular_230312.php	43.12 KB	-rw-rw-rw-
site.php	18.43 KB	-rw-rw-rw-
tabs.php	10.13 KB	-rw-rw-rw-
tabs_old.php	10.22 KB	-rw-rw-rw-
upload	5.32 KB	-rw-rw-rw-
upload.php	14.3 KB	-rw-rw-rw-
upload_20200723.php	14.23 KB	-rw-rw-rw-
upload_me.php	1.53 KB	-rw-rw-rw-

Code Editor : main_20210408.php

<?php if(empty($page)){ include("../access.php"); } ?>
<?php  
	$modal_name 	= str_replace("/", "-", $page);

// $sqlx 	= "SELECT * FROM utiliti_user";
	// $rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
	$user 			= get_user_full($_SESSION['session']);
	$roles 			= (int)$user['idRoles'];
	// $roles 			= (int)$_GET['roles'];
	$idUser 		= (int)$user['idUser'];
	$idPelabuhan 	= (int)$user['idPelabuhan'];
	$dgapprove 		= $user['flagDGApproval'];
	$comb1 			= "";
	$comb2 			= "a.flagApprove,";
	$comb3 			= "";

if($roles !== 5){
		if($roles == 1){
 			$comb1 	= " AND a.idUserApply = '{$idUser}'";
		}else if($roles == 2){
 		// echo	$comb1 = " AND ((a.submit = 'Y' AND a.idApprove = 0) OR (IF(a.idApprove != 0, a.idApprove = {$idUser}, null))) AND a.idMarineFacility = '{$idPelabuhan}'";
			$comb1 	= " AND if(a.idApproveMFSO = 0 AND a.idApproveDG = 0 AND a.idApproveMTSO = 0, a.submit = 'Y', 1) AND a.idMarineFacility = '{$idPelabuhan}' AND a.idApproveMTSO = 0";
			$comb3 	= "	AND (IF(a.idApproveMFSO != 0 AND a.idApproveDG != 0,
							IF((a.idApproveMFSO = 0 OR a.idApproveDG = 0) AND a.idApproveMFSO != a.idApproveDG,
							(IF(a.idApproveMFSO != 0, a.idApproveMFSO = {$idUser}, 1))
							OR
							(IF(a.idApproveDG != 0, a.idApproveDG = {$idUser}, 1)),
							a.idApproveMFSO = {$idUser} OR a.idapproveDG = {$idUser} 
							)
							,1))
							AND IF(a.flagDG = 'T' AND a.idApproveMFSO != 0 , a.idApproveMFSO = {$idUser},1) ";
			$comb3 	.= "	AND (
							IF(a.flagDG != 'Y', a.commentsMFSO != '-bypass-',1)
						)";

// echo "<br>";
 		}else if($roles == 3){
 			$comb1 	= " AND IF(a.flagDG = 'Y', 
 							((a.idApproveMFSO != 0 AND a.flagApproveMFSO = 'Y') OR a.commentsMFSO = '-bypass-') AND a.idApproveDG != 0 AND a.flagApproveDG = 'Y', 
 							(a.idApproveMFSO != 0 AND a.flagApproveMFSO = 'Y') OR a.commentsMFSO = '-bypass-'
 						) 
 						AND IF(a.idApproveMTSO != 0, 
 							a.idApproveMTSO = {$idUser},
 							1
 						)";
 		// echo	$comb1 = " AND ((f.idRoles = '2' AND a.flagApprove = 'Y') OR (IF(a.idApprove != 0, a.idApprove = {$idUser}, null)))";
 			$comb2 	= " IF(a.idApproveMTSO != {$idUser}, 'T',a.flagApprove) AS flagApprove,";
 		}
	}else{
		$comb1 	= "";
	}
				
	$sqlx 		= "SELECT * FROM ( SELECT 
						IF(DATE_FORMAT(date_sub(a.ETA, INTERVAL 1 WEEK),'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d'),'Y','T') AS warning,
						a.idPermohonan,
						a.idUserApply,
						a.refID,
						a.flagDG,
						a.flagISSC,
						a.idApproveMFSO,
						a.flagApproveMFSO,
						a.commentsMFSO,
						a.idApproveDG,
						a.flagApproveDG,
						a.commentsDG,
						a.idApproveMTSO,
						a.flagApproveMTSO,
						a.commentsMTSO,
						a.securityLevel,
						{$comb2}
						a.comments,
						DATE_FORMAT(a.tarikhApply,'%d-%m-%Y') AS tarikhApply,
						DATE_FORMAT(a.tarikhApproveDG,'%d-%m-%Y') AS tarikhDG,
						DATE_FORMAT(a.tarikhApproveMFSO,'%d-%m-%Y') AS tarikhMFSO,
						DATE_FORMAT(a.tarikhApproveMTSO,'%d-%m-%Y') AS tarikhMTSO,
						DATEDIFF(a.tarikhApproveMFSO,a.tarikhApply) AS daysMFSO,
						DATEDIFF(a.tarikhApproveDG,a.tarikhApply) AS daysDG,
						DATEDIFF(a.tarikhApproveMTSO,a.tarikhApply) AS daysMTSO,
						b.nameUser AS nama_user,
						c.nama AS nama_pelabuhan,
						d.nama AS nama_kapal,
						e.nama AS nama_syarikat,
						f.nameUser AS nama_mfso,
						g.nameUser AS nama_dg,
						h.nameUser AS nama_mtso
					FROM 
						permohonan_main a
					LEFT JOIn 
						user_list b ON b.idUser = a.idUserApply
					LEFT JOIN 
						kod_marine_facility c on c.idMarineFacility = a.idMarineFacility
					LEFT JOIN 
						kod_kapal d ON d.idKapal = a.idKapal
					LEFT JOIN 
						kod_syarikat e ON e.idSyarikat = d.idSyarikat
					LEFT JOIn 
						user_list f ON f.idUser = a.idApproveMFSO
					LEFT JOIN 
						user_list g ON g.idUser = a.idApproveDG
					LEFT JOIN 
						user_list h ON h.idUser = a.idApproveMTSO
					WHERE 1
						{$comb1} 
						{$comb3}
						AND a.status != 'R'
					) x
					ORDER BY 
						FIELD(x.flagApproveMTSO,'T','Y'), 
						x.tarikhApply DESC
				";
	$result2 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
	$rows_app 	= $result2->num_rows;

if($roles !== 5){
		// $comb2 		= " AND a.idUserApply = '{$idUser}' AND (if(a.submit = 'Y',idApproveMFSO = 0,1))";
		$comb2 		= " AND a.idUserApply = '{$idUser}' AND a.flagApproveMFSO = 'N'";
	}else{
		$comb2 		= "";
	}

$sqlx 		= "SELECT 
						a.idPermohonan,
						a.idUserApply,
						a.refID,
						a.flagDG,
						a.idApprove,
						a.flagApprove,
						a.comments,
						DATE_FORMAT(a.tarikhApply,'%d-%m-%Y') AS tarikhApply,
						b.nameUser AS nama_user,
						c.nama AS nama_pelabuhan,
						d.nama AS nama_kapal,
						e.nama AS nama_syarikat
					FROM 
						permohonan_main a
					LEFT JOIn 
						user_list b ON b.idUser = a.idUserApply
					LEFT JOIN 
						kod_marine_facility c on c.idMarineFacility = a.idMarineFacility
					LEFT JOIN 
						kod_kapal d ON d.idKapal = a.idKapal
					LEFT JOIN 
						kod_syarikat e ON e.idSyarikat = d.idSyarikat
					WHERE 1
						{$comb2}
						AND a.submit != 'Y'
					ORDER BY 
						FIELD(a.flagApproveMFSO,'N','T','Y'), 
						a.tarikhApply DESC
				";
	$result3 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
	$rows_incomplete 	= $result3->num_rows;

if($_POST):

if($_POST['val-type'] == 'mfso'):
			$ext 	= "MFSO";
		elseif($_POST['val-type'] == 'dg'):
			$ext 	= "DG";
		else:
			$ext 	= "MTSO";
		endif;

$sql 	 		= "UPDATE 
								permohonan_main 
							SET 
								submit 					= IF('{$_POST['flagApprove']}' = 'T','T',submit),
								flagApprove{$ext} 		= ?,
								idApprove{$ext} 		= ?,
								comments{$ext} 			= ?,
								tarikhApprove{$ext} 	= NOW()
							WHERE 
								idPermohonan = ?";
		$param_type 	= "ssss";
		$param_data 	= array(
							"flagApprove{$ext}" 	=> $_POST['flagApprove'],
							"idApprove{$ext}" 		=> $idUser,
							"comments{$ext}" 		=> $_POST['comments'],
							"idPermohonan" 			=> $_POST['val-id']
						 	);
		$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"APPLICATION UPDATE ({$ext} APPROVAL)");

$sql 	 		= "INSERT INTO permohonan_kelulusan (idPermohonanMain, flagApprove, idApprove, tarikhApprove, type, comments) values (?,?,?,NOW(),?,?)";
		$param_type 	= "sssss";
		$param_data 	= array(
							"idPermohonanMain" 	=> $_POST['val-id'],
							"flagApprove" 		=> $_POST['flagApprove'],
							"idApprove" 		=> $idUser,
							"type" 				=> $_POST['val-type'],
							"comments" 			=> $_POST['comments']
						 	);
		$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);

echo "<script>window.location.replace('index.php?page=edg/main');</script>";
		exit();
	endif;
?>

<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					<h1>APPLICATION</h1>
				</div>
			</div>
			<div class="col-sm-6 hidden-xs">
				<div class="header-section">
					
						
						
					
				</div>
			</div>
		</div>
	</div>

<div class="block full">

<div class="block-title">
                	<?php if($roles == 1 || $roles == 5){ ?>
                    <div class="block-options pull-left">
                        <a href="index.php?page=edg/main&np=edg/ship_particular" class="btn btn-effect-ripple btn-success" data-toggle="tooltip" title="Add New Application">
                        	<i class="gi gi-folder_plus"></i>&nbsp;&nbsp;New
                       	</a>
                    </div>
                    <?php }?>
                    <ul class="nav nav-tabs" data-toggle="tabs">
                        <li class="active"><a href="#block-tabs-home">Application Status <span href="javascript:void(0)" class="label label-info"><?php echo $rows_app; ?></span></a></li>
                	<?php if($roles == 1 || $roles == 5){ ?>
                        <li><a href="#block-tabs-profile">Incomplete Form <span href="javascript:void(0)" class="label label-info"><?php echo $rows_incomplete; ?></span></a></li>
                    <?php }?>
                    </ul>
                </div>

<div id="modal-form" class="modal fade <?php echo $modal_name;?>" tabindex="-1" role="dialog" aria-hidden="true">
				<div class="modal-dialog modal-lg">
					<div class="modal-content">

<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span aria-hidden="true">&times;</span></button>
							<h4 class="modal-title"><strong>APPLICATION APPROVAL</strong></h4>
						</div>

<div class="alert alert-success alert-dismissable">
							<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
							<h4><strong>MFSO/DG COMMENTS</strong></h4>
							<p>MFSO : <span class="name2" style="text-transform: uppercase;">asd</span></p>
							<p><span class="comments2"></span></p>
							<br>
							<p>DG : <span class="name3" style="text-transform: uppercase;">asd</span></p>
							<p><span class="comments3"></span></p>
							</div>

<ul class="nav nav-pills nav-justified nav-pills-custom" data-toggle="tabs">
							
								<li class="active tab-click"><a href="#ship">Ship Particular</a></li>
								<li class="tab-click"><a href="#isps">ISPS Information</a></li>
								<li class="tab-click"><a href="#port">Last 10 Port Calls</a></li>
								<li class="tab-click"><a href="#part">Other Particular</a></li>
								<li class="tab-click"><a href="#dg">Dangerous Goods</a></li>
								<li class="tab-click" data-approve='Y'><a href="#apr" class="btn btn-default"><b>Approval</b></a></li>
							</ul>

<div class="tab-content">
								<div class="tab-pane  active" id="ship"></div>
								<div class="tab-pane" id="isps"></div>
								<div class="tab-pane" id="port"></div>
								<div class="tab-pane" id="part"></div>
								<div class="tab-pane" id="dg"></div>
								<div class="tab-pane" id="apr">
								<hr>
									<div class="form-group">
									    <label class="col-md-3 control-label" for="flagApprove">Approve/Acknowledge This? <span class="text-danger">*</span></label>
									    <div class="col-md-6">
										<select class="form-control validation" data-validation="default" name="flagApprove" id="flagApprove">
											<option value="">- Please Select -</option>
											<option value="T">No</option>
											<option value="Y">Yes</option>
										</select>
									    </div>
									</div>
									<div class="form-group">
									    <label class="col-md-3 control-label" for="comments">Comments/Note <span class="text-danger">*</span></label>
									    <div class="col-md-6">
									    	<textarea class="form-control validation" data-validation="default" name="comments" id="comments"></textarea>
									    </div>
									</div>
								</div>
							</div>
							<hr>
					
							<center>
						
						<button type="submit" class="btn btn-effect-ripple btn-primary">Submit</button>
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>

</center>
						</div>

</form>

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

<div class="tab-content">

<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;">NO</th>
										
										<th class="text-left">Submitted Date</th>
										<th class="text-left">Submitted By</th>
										<th class="text-left">MFSO/DG/MTSO</th>
										<th class="text-left">Process Day</th>
										
										
										
										<th class="text-left">Vessel &amp; Company Name</th>
										
										<th class="text-left">Terminal Name</th>
										<th class="text-center">On Board Status</th>
										
										<?php if($roles == 1 || $roles == 5){ ?>
										<th class="text-center no_sorting" style="width: 40px;"><i class="fa fa-flash"></i></th>
										<?php } ?>
									</tr>
								</thead>
								<tbody>
								<?php

$i=1;
									while($aa = $result2->fetch_assoc()){
										if($aa['warning'] == 'Y')
											$tr_class 	= "danger";
										else
											$tr_class 	= "";

if($aa['flagApproveMTSO'] == 'Y'){
											// if(!empty($tr_class))
												$tr_class 	= "success";
										}
										// else{
											// $tr_class 	= "";
										// }

if($aa['idApprove'] !== $idUser AND $roles == 3){
											$editdata1 = "flagApprove#T|"
														."comments#|"
														."name2#{$aa['nama_mfso']}|"
														."name3#{$aa['nama_dg']}|"
														."comments2#{$aa['commentsMFSO']}|"
														."comments3#{$aa['commentsDG']}";
										}else{
											$editdata1 = "flagApprove#{$aa['flagApproveMFSO']}|"
														."comments#{$aa['commentsMFSO']}";
										}

if($aa['idApprove'] !== $idUser AND $roles == 3){
											$editdata2 = "flagApprove#T|"
														."comments#|"
														."name2#{$aa['nama_mfso']}|"
														."name3#{$aa['nama_dg']}|"
														."comments2#{$aa['commentsMFSO']}|"
														."comments3#{$aa['commentsDG']}";
										}else{
											$editdata2 = "flagApprove#{$aa['flagApproveDG']}|"
														."comments#{$aa['commentsDG']}";
										}

if($aa['idApprove'] !== $idUser AND $roles == 3){
											$editdata3 = "flagApprove#T|"
														."comments#|"
														."name2#{$aa['nama_mfso']}|"
														."name3#{$aa['nama_dg']}|"
														."comments2#{$aa['commentsMFSO']}|"
														."comments3#{$aa['commentsDG']}";
										}else{
											$editdata3 = "flagApprove#{$aa['flagApproveMTSO']}|"
														."comments#{$aa['commentsMTSO']}";
										}

// if($roles == 1)
											$my_width 	= "width = '1px'";
										// else
											// $my_width 	= "width = '10px'";

if($roles == 2 && $cont == 'Y')
											$my_width 	= "width = '10px'";

if($roles == 2 && $dgapprove == 'Y' && $cont == 'Y')
											$my_width 	= "width = '10px'";

if($roles == 3)
											$my_width 	= "width = '10px'";
								?>
									<tr class="<?php echo $tr_class;?>">
										<td class="align-top text-right"><?php echo $i++; ?>.</td>
										
										
										
										
										<td class="align-top"><?php echo $aa['tarikhApply'];?></td>
										<td class="align-top"><?php echo $aa['nama_user'];?></td>
										<td class="align-top text-center table-inside">
											<table class="table-custom" style="min-width: 250px" >
												<tbody>
												<?php if(trim($aa['commentsMFSO']) != "-bypass-"){ ?>
												<tr>
													<?php 
														if($aa['idApproveMFSO'] != 0){
															if($aa['idApproveMFSO'] == $idUser)
																$cont = 'Y';
															else
																$cont = 'T';
														}else{
															$cont = 'Y';
														}

?>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php if($roles == 2 && $cont == 'Y'){ ?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata1;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="mfso"><i class="fa fa-pencil"></i></a>
													<?php } ?>
													</td>
													<td class="align-top text-left alert-mfso" width="50px">MFSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php 
														if($aa['idApproveMFSO'] == 0){ 
															// if(trim($aa['commentsMFSO']) == "-bypass-")
																// $ccc 	= "- BYPASS -";
															// else
																$ccc 	= "PENDING";
													?>
														<div class="alert alert-info alert-custom">
															<center><b><?php echo $ccc; ?></b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveMFSO'] == 'Y'){ ?>
														<div class="alert alert-warning alert-custom">
															<center><b>ACKNOWLEDGED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mfso'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mfso'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												<?php 
													}

if($aa['flagDG'] == 'Y'){ ?>
												
													
												
												<tr>
													<?php 
														if($aa['idApproveDG'] != 0){
															if($aa['idApproveDG'] == $idUser)
																$cont = 'Y';
															else
																$cont = 'T';
														}else{
															$cont = 'Y';
														}

?>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php if($roles == 2 && $dgapprove == 'Y' && $cont == 'Y'){ ?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata2;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="dg"><i class="fa fa-pencil"></i></a>
													<?php } ?>
													</td>
													<td class="align-top text-left alert-dg" width="50px">DG</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveDG'] == 0){ ?>
														<div class="alert alert-info alert-custom">
															<center><b>PENDING</b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveDG'] == 'Y'){ ?>
														<div class="alert alert-warning alert-custom">
															<center><b>eDG ENABLED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_dg'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_dg'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												<?php } ?>
												
													
												
												<tr>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php if($roles == 3){ ?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata3;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="mtso"><i class="fa fa-pencil"></i></a>
													<?php } ?>
													</td>
													<td class="align-top text-left alert-mtso" width="50px">MTSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveMTSO'] == 0){ ?>
														<div class="alert alert-info alert-custom">
															<center><b>PENDING</b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveMTSO'] == 'Y'){ ?>
														<div class="alert alert-success alert-custom">
															<center><b>ACKNOWLEDGED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mtso'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mtso'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												</tbody>
											</table>
										</td>
										<td class="align-top text-center table-inside">
											<table class="table-custom">
												<tbody>
												<?php if(trim($aa['commentsMFSO']) != "-bypass-"){ ?>
												<tr>
													<?php 
														if($aa['idApproveMFSO'] != 0){
															if($aa['idApproveMFSO'] == $idUser)
																$cont = 'Y';
															else
																$cont = 'T';
														}else{
															$cont = 'Y';
														}

?>
													<td class="align-top text-left process-mfso" width="50px">MFSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left">
													<?php if($aa['idApproveMFSO'] == 0){ ?>
														<b class="text-info"> -/- </b>
													<?php }else{ ?>
														<?php echo "<b>".$aa['tarikhMFSO']."</b><br><i>(".$aa['daysMFSO']." Days)</i>"; ?>
													<?php } ?>
													</td>
												</tr>
												<?php 
													}

?>
													<td class="align-top text-left process-dg" width="50px">DG</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveDG'] == 0){ ?>
														<b class="text-info"> -/- </b>
													<?php }else{ ?>
														<?php echo "<b>".$aa['tarikhDG']."</b><br><i>(".$aa['daysDG']." Days)</i>"; ?>
													<?php } ?>
													</td>
												</tr>
												<?php } ?>
												
													
												
												<tr>
													<td class="align-top text-left process-mtso" width="50px">MTSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveMTSO'] == 0){ ?>
														<b class="text-info"> -/- </b>
													<?php }else{ ?>
														<?php echo "<b>".$aa['tarikhMTSO']."</b><br><i>(".$aa['daysMTSO']." Days)</i>"; ?>
													<?php } ?>
													</td>
												</tr>
												</tbody>
											</table>
										</td>
										
										<td class="align-top text-center table-inside">
											<table class="table-custom">
												<tbody>
												<tr>
													<td class="text-left"><?php echo $aa['nama_kapal']?></td>
												</tr>
												<tr>
													<td class="text-left"><?php echo $aa['nama_syarikat']?></td>
												</tr>
												</tbody>
											</table>
										</td>
										
										
										<td class="align-top text-left"><?php echo $aa['nama_pelabuhan']?></td>
										<td class="align-top text-center">
										<?php
										//remarks icon

if($aa['flagDG'] == 'Y'){//DG
												echo "<a href='javascript:void(0)'' class='btn-sm btn-effect-ripple btn-danger' title='Dangerous Goods'><i class='gi gi-circle_exclamation_mark'></i></a>&nbsp;";
											}

if($aa['flagISSC'] == 'Y'){//UN
												echo "<a href='javascript:void(0)'' class='btn-sm btn-effect-ripple btn-info' title='Prohibited Good Under UN Security Council'><i class='gi gi-ban'></i></a>&nbsp;";
											}

if($aa['securityLevel'] == '2' OR $aa['securityLevel'] == '3'){//UN
												echo "<a href='javascript:void(0)'' class='btn-sm btn-effect-ripple btn-warning' title='Security Level'><strong>".$aa['securityLevel']."</strong></a>&nbsp;";
											}

?>
										</td>
										<!-- 
										<td class="align-top text-center table-inside">
											<table class="table-custom">
												<tbody>
												<?php if(trim($aa['commentsMFSO']) != "-bypass-"){ ?>
												<tr>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php 
														if($aa['idApproveMFSO'] != 0){
															if($aa['idApproveMFSO'] == $idUser)
																$cont = 'Y';
															else
																$cont = 'T';
														}else{
															$cont = 'Y';
														}

if($roles == 2 && $cont == 'Y'){
													?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata1;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="mfso"><i class="fa fa-pencil"></i></a>
													<?php } ?>
													</td>
													<td class="align-top text-left" width="50px">MFSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php 
														if($aa['idApproveMFSO'] == 0){ 
															// if(trim($aa['commentsMFSO']) == "-bypass-")
																// $ccc 	= "- BYPASS -";
															// else
																$ccc 	= "PENDING";
													?>
														<div class="alert alert-info alert-custom">
															<center><b><?php echo $ccc; ?></b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveMFSO'] == 'Y'){ ?>
														<div class="alert alert-warning alert-custom">
															<center><b>ACKNOWLEDGED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mfso'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mfso'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												<?php 
													}

if($aa['flagDG'] == 'Y'){ ?>
												<tr>
													<td colspan="4"></td>
												</tr>
												<tr>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php 
														if($aa['idApproveDG'] != 0){
															if($aa['idApproveDG'] == $idUser)
																$cont = 'Y';
															else
																$cont = 'T';
														}else{
															$cont = 'Y';
														}

if($roles == 2 && $dgapprove == 'Y' && $cont == 'Y'){
													?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata2;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="dg"><i class="fa fa-pencil"></i></a>
													<?php } ?>
													</td>
													<td class="align-top text-left" width="50px">DG</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveDG'] == 0){ ?>
														<div class="alert alert-info alert-custom">
															<center><b>PENDING</b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveDG'] == 'Y'){ ?>
														<div class="alert alert-warning alert-custom">
															<center><b>eDG ENABLED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_dg'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_dg'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												<?php } ?>
												<tr>
													<td colspan="4"></td>
												</tr>
												<tr>
													<td class="align-top" <?php echo $my_width; ?>>
													<?php 
														if($roles == 3){
													?>
										<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata3;?>" data-myid="<?php echo $aa['idPermohonan'];?>" data-type="mtso"><i class="fa fa-pencil"></i></a>
													</td>
													<?php } ?>
													<td class="align-top text-left" width="50px">MTSO</td>
													<td class="align-top text-left" width="5px">:</td>
													<td class="align-top text-left my-alert">
													<?php if($aa['idApproveMTSO'] == 0){ ?>
														<div class="alert alert-info alert-custom">
															<center><b>PENDING</b></center>
														</div>
													<?php }else{ ?>
													<?php if($aa['flagApproveMTSO'] == 'Y'){ ?>
														<div class="alert alert-success alert-custom">
															<center><b>ACKNOWLEDGED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mtso'];
															?>
														</div>
													<?php }else{ ?>
														<div class="alert alert-danger alert-custom">
															<center><b>REJECTED</b></center>
															<hr class="hr-custom">
															<?php 
																echo $aa['nama_mtso'];
															?>
														</div>
													<?php } ?>
													<?php } ?>
													</td>
												</tr>
												</tbody>
											</table>
										</td>
										 -->
										<?php 
											// if($aa['flagApprove'] == 'Y'){
											// 	echo "<span class='label label-success block'><i class='fa fa-check'></i> Yes</span>";
											// }else{
											// 	echo "<span class='label label-danger block'><i class='fa fa-close'></i> No</span>";
											// }
										?>
										
										<?php if($roles == 1 || $roles == 5){ ?>
										<td class="align-top text-center">
										<?php 
											// $showme 	= 'T';

if($aa['flagApproveMFSO'] == 'Y' || $aa['flagApproveDG'] == 'Y' || $aa['flagApproveMTSO'] == 'Y' || ($aa['commentsMFSO'] == '-bypass-' && ($aa['flagApproveDG'] == 'Y' || $aa['flagApproveMTSO'] == 'Y'))){
												$showme 	= 'T';

if($aa['flagApproveMFSO'] == 'T' || $aa['flagApproveDG'] == 'T' || $aa['flagApproveMTSO'] == 'T')
													$showme 	= 'Y';
											}
											else{
												$showme 	= 'Y';
											}

// if()
											// 	$showme 	= 'Y';
											// else
											// 	$showme 	= 'T';

if($aa['submit'] != 'T' AND $showme == 'Y'){ ?>
										<a title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success" href="index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $aa['idPermohonan']?>"><i class="fa fa-pencil"></i></a>
										<a href="javascript:void(0)" title="Delete Record" class="btn btn-effect-ripple btn-xs btn-danger del-me" data-val="<?php echo $i;?>"><i class="fa fa-times"></i></a>
										<?php } ?>
										</td>
										<?php } ?>
									</tr>
								<?php } ?>
								</tbody>
							</table>

</form>
						</div>
                    </div>
                    <div class="tab-pane" id="block-tabs-profile">
                    	
						<div class="table-responsive">
						<form method="post" data-modal-target="<?php echo $modal_name;?>">
							<input name="type_submit" type="hidden" value="delete">

<table id="example-datatable2" 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;">NO</th>
										<th width="100px" class="text-center">Reference ID</th>
										<th width="100px" class="text-center">Submitted On</th>
										<th width="100px" class="text-center">Submitted By</th>
										<th class="text-left">Vessel Name</th>
										<th class="text-left">Company Name</th>
										<th class="text-left">Terminal Name</th>
										<th class="text-center">Dangerous Goods</th>
										<?php if($roles == 1 || $roles == 5){ ?>
										<th class="text-center no_sorting" style="width: 40px;"><i class="fa fa-flash"></i></th>
										<?php } ?>
									</tr>
								</thead>
								<tbody>
								<?php

$i=1;
									while($aa = $result3->fetch_assoc()){
										$editdata = "";
								?>
									<tr>
										<td class="align-top text-right"><?php echo $i++; ?>.</td>
										<td class="align-top text-center"><?php echo $aa['refID']?></td>
										<td class="align-top text-center"><?php echo $aa['tarikhApply']?></td>
										<td class="align-top text-left"><?php echo $aa['nama_user']?></td>
										<td class="align-top text-left"><?php echo $aa['nama_kapal']?></td>
										<td class="align-top text-left"><?php echo $aa['nama_syarikat']?></td>
										<td class="align-top text-left"><?php echo $aa['nama_pelabuhan']?></td>
										<td class="align-top text-center">
										<?php 
											if($aa['flagDG'] == 'Y'){
												echo "<span class='label label-warning block'><i class='fa fa-exclamation-triangle'></i> Yes</span>";
											}else{
												echo "<span class='label label-primary block'><i class='fa fa-check'></i> No</span>";
											}
										?>
										</td>
										<?php if($roles == 1 || $roles == 5){ ?>
										<td class="align-top text-center">
										<a title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success" href="index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $aa['idPermohonan']?>"><i class="fa fa-pencil"></i></a>
										<a href="javascript:void(0)" title="Delete Record" class="btn btn-effect-ripple btn-xs btn-danger del-me" data-val="<?php echo $i;?>"><i class="fa fa-times"></i></a>
										</td>
										<?php } ?>
									</tr>
								<?php } ?>
								</tbody>
							</table>

</form>
						</div>

</div>
                    <div class="tab-pane" id="block-tabs-settings">Settings..</div>
                </div>
                
            
		
		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

// $('.xyz').datepicker({weekStart: 1}).on('changeDate', function(e){ $(this).datepicker('hide'); });

$(document).on("submit","#form-validation",function(e){
            	var tab_approve 	= $(".tab-click.active").data("approve");
            	if(!tab_approve){
            		$(".tab-click :eq(5)").trigger("click");
            		e.preventDefault();
            	}
            });

$.reassign_height_mfso = function(){
				$("td.alert-mfso").each(function(x){
					var a_height1 	= $(this).height();
					$(this).height(a_height1);
					$("td.process-mfso").eq(x).height(a_height1);
				});
			};

$.reassign_height_dg = function(){
				$("td.alert-dg").each(function(x){
					var a_height2 	= $(this).height();
					$(this).height(a_height2);
					$("td.process-dg").eq(x).height(a_height2);
				});
			};

$.reassign_height_mtso = function(){
				$("td.alert-mtso").each(function(x){
					var a_height3 	= $(this).height();
					$(this).height(a_height3);
					$("td.process-mtso").eq(x).height(a_height3);
				});
			};	
			// $.reassign_height();

$("td.alert-mfso").on("resize",function(){
				$.reassign_height_mfso();
			});

$("td.alert-dg").on("resize",function(){
				$.reassign_height_dg();
			});

$("td.alert-mtso").on("resize",function(){
				$.reassign_height_mtso();
			});

$("#example-datatable").setdatatable().setadddelete();
			$("#example-datatable2").setdatatable().setadddelete();

$('thead input:checkbox').click(function() {
			    var checkedStatus   = $(this).prop('checked');
			    var table           = $(this).closest('table');

$('tbody input:checkbox', table).each(function() {
			        $(this).prop('checked', checkedStatus);
			    });
			});

$(document).on("click", ".add-me", function(){
				var modal_name 	= "."+$(this).closest("form").data("modal-target");
				$(modal_name).modal({keyboard:true});
				$(modal_name).find("input").not(":button, :submit, :reset").val("").prop("checked",false);
				$(modal_name).find("select").prop("selected",false);
				$(modal_name).find('.help-block').remove();
				$(modal_name).find('.form-group').removeClass('has-success has-error');
				$("#form-validation").setvalidation('');
				$("#form-validation > [name='type_submit']").val("add");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

$("#example-datatable tbody").on("click", ".del-me", function(){
				if(confirm("Delete This Record! Are You Sure?")){
					$(this).closest("table").find("input[type='checkbox']").prop("checked",false);
					$(this).closest("tr").find("input[type='checkbox']").trigger("click");
					$(this).closest("form").submit();
				}
			})

$("#example-datatable tbody").on("click", ".edit-me", function(){
				// console.log(1);
				var modal_name 	= "."+$(this).data("modal-target");
				var editdata 	= $(this).data("editdata");
				var myid 	= $(this).data("myid");
				var type 	= $(this).data("type");
				var getthis = 0;

var targetdata 	= editdata.split("|");
				var got_name = 0;
				$.each(targetdata,function(i,v){
					var target = v.split("#");
					// console.log("span."+target[0]);
					$(modal_name).find("span."+target[0]).text(target[1]);

if(target[0] === 'name2')
						got_name++;
					if(target[0] === 'name3')
						got_name++;
				});

if(got_name > 0)
					$(modal_name).find(".alert").show();
				else
					$(modal_name).find(".alert").hide();

$.ajax({url: "edg/detail.php?ii="+myid+"&target=ship", success: function(result){
					$(modal_name).find(".tab-pane[id=ship]").html(result);
				}}).done(function(){
					$(document).trigger("resize");

$('.other_purpose').tagsInput({
						width: 'auto',
						height: 'auto'
					});

$("div.tagsinput").find("div").html("&nbsp;");
					$("div.tagsinput").find("a").remove();

}
					});

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=isps", success: function(result){
					$(modal_name).find(".tab-pane[id=isps]").html(result);
				}}).done(function(){
					$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=port", success: function(result){
					$(modal_name).find(".tab-pane[id=port]").html(result);
				}}).done(function(){
					$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=part", success: function(result){
					$(modal_name).find(".tab-pane[id=part]").html(result);
				}}).done(function(){
					$(document).trigger("resize");

});

$.ajax({url: "edg/detail.php?ii="+myid+"&target=dg", success: function(result){
					$(modal_name).find(".tab-pane[id=dg]").html(result);
				}}).done(function(){
					$(document).trigger("resize");

});
				// .done(function(){
				// 	$.ajax({url: "edg/detail.php?ii="+myid+"&target=ship", success: function(result){
				// 	$(modal_name).find(".tab-pane[id=ship]").html(result);
				// 	}}).done(function(){
				// 		getthis += 1;
				// 	});
				// });

// if(getthis === 1){

$(modal_name).modal({keyboard:true});
					$(modal_name).find("input").not(":button, :submit, :reset").val("").prop("checked",false);
					$(modal_name).find("select").prop("selected",false);
					$(modal_name).find('.help-block').remove();
					$(modal_name).find('.form-group').removeClass('has-success has-error');
					$("#form-validation").setvalidation(editdata);
					$("#form-validation > [name='type_submit']").val("edit");
					$("#form-validation > [name='val-id']").val(myid);
					$("#form-validation > [name='val-type']").val(type);

// }
				// console.log($._data($("#form-validation").get(0), "events"));
			});

$(".tab-click").on("click",function(){
				$(document).trigger("resize");
			})
        });

</script>
	</div>

${this.title}

Code Editor : main_20210408.php