One Hat Cyber Team

Edit File: main_20220621.php

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

$param_data 	= array();
	$combx1 		= "";
	$combx2 		= "";
	$name  				= (isset($_GET['val-name'])) ? $_GET['val-name'] : '' ;
	$idMarineFacility 	= (isset($_GET['idMarineFacility'])) ? $_GET['idMarineFacility'] : '' ;
	$idKapal 			= (isset($_GET['idKapal'])) ? $_GET['idKapal'] : '' ;
	$aktif 				= (isset($_GET['val-aktif'])) ? $_GET['val-aktif'] : '' ;

// $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 			= "";
	$comb4 			= "";

if($roles == 1 || $roles == 2 || $roles == 3){
		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('{$dgapprove}' != 'Y', a.commentsMFSO != '-bypass-',1)
						)";
			$comb4 	= " AND c.idMarineFacility='{$idPelabuhan}'";
 		}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 	= "";
	}

if(!empty($idMarineFacility)){ 
		$combx1 			.= " AND idMarineFacility = ? ";
		$param_data['p1'] 	= $idMarineFacility;
	}

$sqly 		= "SELECT 
						c.idMarineFacility,
						c.nama AS nama_pelabuhan
					FROM
						kod_marine_facility c 
					WHERE 
						c.flagAktif ='Y' 
					AND 
						c.flagPort = 'Kemaman' 
					{$combx1}
					{$comb4}
					ORDER BY 
						nama
				";
	$result4 	= mysqli_prepare_all($sqly,$param_type = "auto",$param_data);

$main_arr 	= array();
	while($qq = $result4->fetch_assoc()){

unset($combx1);
		unset($param_data);
		unset($param_type);

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

$sqlx 		= "SELECT 
							IF(DATE_FORMAT(date_sub(a.ETA, INTERVAL 2 day),'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d'),
								IF(DATE_FORMAT(a.ETA,'%Y-%m-%d') > DATE_FORMAT(NOW(),'%Y-%m-%d'),'Y','T'),'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,
							IF(DATE_FORMAT(a.ETA,'%d-%m-%Y') = '00-00-0000','-/-',DATE_FORMAT(a.ETA,'%d-%m-%Y')) AS ETA,
							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' 
							AND a.idMarineFacility = '{$qq['idMarineFacility']}' 
							AND a.submit = 'Y'
							{$combx1} 
						ORDER BY 
							FIELD(a.flagApproveMTSO,'T','Y'),
							FIELD(IF(DATE_FORMAT(date_sub(a.ETA, INTERVAL 2 day),'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d'),
								IF(DATE_FORMAT(a.ETA,'%Y-%m-%d') > DATE_FORMAT(NOW(),'%Y-%m-%d'),'Y','T'),'T'),'Y','T'), 
							a.tarikhApply DESC
					";
		// $result2 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
		$result2 	= mysqli_prepare_all($sqlx,$param_type = "auto",$param_data);
		$rows_app 	+= $result2->num_rows;

array_push($main_arr, array($result2,$qq['nama_pelabuhan']));
		unset($result2);
		// unset($rows_app);
	}

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">
					<div class="block-options pull-right">
						<div class="btn btn-effect-ripple btn-warning search-me" data-toggle="tooltip" data-original-title="Search"><i class="fa fa fa-search"></i></div>
						<a class="btn btn-sm btn-effect-ripple btn-default" data-toggle="tooltip" data-original-title="Refresh" href="index.php?page=<?php echo $page;?>"><i class="fa fa-refresh"></i></a>
						
					</div>
					<?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>

<fieldset class="lf1">
				<legend class="lf1">Labels</legend>
				<span style="margin-right:10px;"><span class="btn btn-xs btn-effect-ripple btn-danger"><i class="gi gi-circle_exclamation_mark"></i></span> <span style="border-bottom: 1px dotted #ccc">Dangerous Goods</span></span>
				<span style="margin-right:10px;"><span class="btn btn-xs btn-effect-ripple btn-info"><i class="gi gi-ban"></i></span> <span style="border-bottom: 1px dotted #ccc">Prohibited Good Under UN Security Council</span></span>
				<span style="margin-right:10px;"><span class="btn btn-xs btn-effect-ripple btn-warning"><strong>2</strong></span> <span style="border-bottom: 1px dotted #ccc">Security Level 2</span></span>
				<span style="margin-right:10px;"><span class="btn btn-xs btn-effect-ripple btn-warning"><strong>3</strong></span> <span style="border-bottom: 1px dotted #ccc">Security Level 3</span></span>
			</fieldset>

<input type="hidden" name="page" value="<?php echo $page;?>">
						<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"><i class="fa fa fa-search"></i>&nbsp;<strong>SEARCH</strong></h4>
						</div>

<div class="form-group">
								<label class="col-md-3 control-label" for="idMarineFacility">Marine Facility</label>
								<div class="col-md-7">
									<?php 
										$sqlx 	= "SELECT * FROM kod_marine_facility WHERE flagAktif = 'Y' AND flagPort = 'Kemaman' ORDER BY nama";
										$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
									?>
									<select class="form-control select-select2 select2_custom" data-validation="default" name="idMarineFacility" id="idMarineFacility">
										<option value="">-- ALL --</option>
										<?php while($aa = $rstx->fetch_assoc()){ ?>
										<option value="<?php echo $aa['idMarineFacility']; ?>" <?php if($aa['idMarineFacility'] == $idMarineFacility){ echo "selected='selected'";} ?> ><?php echo $aa['nama']; ?></option>
										<?php 	}?>
									</select>
								</div>
							</div>

<div class="form-group">
								<label class="col-md-3 control-label" for="idKapal">Vessels &amp; Company</label>
								<div class="col-md-7">
									<?php 
										$sqlx 	= "SELECT a.nama as nama_kapal, b.nama as nama_syarikat, a.idKapal, b.idSyarikat FROM kod_kapal a left join kod_syarikat b ON b.idSyarikat=a.idSyarikat WHERE a.flagAktif = 'Y' ORDER BY a.nama";
										$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
									?>
									<select class="form-control select-select2 select2_custom" data-validation="default" name="idKapal" id="idKapal">
										<option value="">-- ALL --</option>
										<?php while($aa = $rstx->fetch_assoc()){ ?>
										<option value="<?php echo $aa['idKapal']; ?>" <?php if($aa['idKapal'] == $idKapal){ echo "selected='selected'";} ?> ><?php echo strtoupper($aa['nama_kapal']); ?> -/- <?php echo strtoupper($aa['nama_syarikat']); ?></option>
										<?php 	}?>
									</select>
								</div>
							</div>

</div>

<div class="modal-footer">
						
						<button type="submit" class="btn btn-effect-ripple btn-primary">Submit</button>
						<button type="reset" class="btn btn-effect-ripple btn-default btn-reset"><span class="btn-ripple animate" style="height: 61px; width: 61px; top: -15.3px; left: 11.8667px;"></span>Reset</button>
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>
						</div>
					</form>

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

<?php foreach ($main_arr as $key => $value) {
							echo "<h3 style='color:#454e'><strong><i class='gi gi-anchor'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>".strtoupper($value[1])."</span></strong></h3>";
							$result2 	= $value[0];
						?>
						<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-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete table-loop">
								<thead>
									<tr>
										<th class="text-center no_sorting" style="width: 40px;">NO</th>
										
										<th class="text-left" style="width: 140px;">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-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 table-inside" >
											<?php // echo $aa['tarikhApply'];?>
											<table class="table-custom ">
												<tbody>
												<tr>
													<td class="text-left" style="width: 70px">Submitted</td>
													<td class="text-left" style="width: 1px">:</td>
													<td class="text-center"><b><?php echo $aa['tarikhApply']?></b></td>
												</tr>
												<tr>
													<td class="text-left">ETA</td>
													<td class="text-left">:</td>
													<td class="text-center"><b><?php echo $aa['ETA']?></b></td>
												</tr>
												</tbody>
											</table>
										</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-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>
					<?php unset($result2); echo "<hr>"; } ?>
					</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();
			$(".table-loop").each(function(){
				$(this).setdatatable('{ "autoWidth": false }').setadddelete();
			});
			$("#example-datatable2").setdatatable('{ "autoWidth": false }').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>