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 : port_call_20220413.php

<?php if(empty($page)){ include("../access.php"); } ?>
<?php  
	$modal_name 	= str_replace("/", "-", $page);
	$user 			= get_user($_SESSION['session']);
	$ii 			= (is_numeric($_GET['ii']) == 1) ? $_GET['ii'] : 0 ;
	$success 	 	= 0;
	$type_submit 	= "add";

$user 			= get_user_full($_SESSION['session']);
	$roles 			= (int)$user['idRoles'];
	$idUser 		= (int)$user['idUser'];

if($roles == 1 || $roles == 5){
		if(!empty($ii)){
			if($roles == 1){
				$query="SELECT *, if(idMarineFacility>0,1,0) AS isps,1 AS port, if(flagDG='Y',1,0) AS dg FROM permohonan_main WHERE idUserApply='{$idUser}' AND idPermohonan = '{$ii}'";
				$result=$mysqli->query($query);	
				$row=$result->fetch_assoc();

if(!$row){
					echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
					exit();
				}

}
		}

if($roles == 1)
			$l_port 	= "index.php?page=kod/kodPort_a";
		else
			$l_port 	= "index.php?page=kod/kodPort";

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

if($_POST):

$do 	= $_POST['type_submit'];

if($ii > 0){

if($do=="add"){

$sql 	 		= "	INSERT INTO 
									permohonan_pelabuhan (
										idPermohonanMain,
										idPelabuhan,
										tarikhTiba,
										tarikhBerlepas,
										securityLevel
									) VALUES (
										?,
										?,
										?,
										?,
										?
									)";
				$param_type 	= "sssss";
				$param_data 	= array(
									"idPermohonanMain" 	=> $ii,
									"idPelabuhan" 		=> $_POST['idPelabuhan'],
									"tarikhTiba" 		=> change_date($_POST['tarikhTiba'],'Y-m-d'),
									"tarikhBerlepas" 	=> change_date($_POST['tarikhBerlepas'],'Y-m-d'),
									"securityLevel" 	=> $_POST['securityLevel']
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"APPLICATION UPDATE (PORT)");

$success 	= 1;
				$msg 		= "RECORD ADDED!";

}else if($do=="add-port"){

$sql 	 		= "	INSERT INTO 
									kod_pelabuhan (
										nama,
										idNegara,
										hadMasa,
										idUserApply,
										tarikhApply
									) VALUES (
										?,
										?,
										?,
										?,
										NOW()
									)";
				$param_type 	= "ssss";
				$param_data 	= array(
									"nama" 			=> $_POST['nama'],
									"idNegara" 		=> $_POST['idNegara'],
									"hadMasa" 		=> $_POST['hadMasa'],
									"idUserApply" 	=> $user['idUser']
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);

$success 	= 1;
				$msg 		= "RECORD ADDED!";

}else if($do=="edit"){

$sql 	 		= "	UPDATE 
										permohonan_pelabuhan 
									SET 
										idPelabuhan 	= ?,
										tarikhTiba 		= ?,
										tarikhBerlepas 	= ?,
										securityLevel 	= ?
									WHERE 
										idPP = ?";
				$param_type 	= "sssss";
				$param_data 	= array(
									"idPelabuhan" 		=> $_POST['idPelabuhan'],
									"tarikhTiba" 		=> change_date($_POST['tarikhTiba'],'Y-m-d'),
									"tarikhBerlepas" 	=> change_date($_POST['tarikhBerlepas'],'Y-m-d'),
									"securityLevel" 	=> $_POST['securityLevel'],
									"idPP" 				=> $_POST['val-id']
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"APPLICATION UPDATE (PORT)");

$success 	= 1;
				$msg 		= "RECORD UPDATED!";

}else if($do=="delete"){

foreach($_POST['myid'] as $value){
					$sql 	 		= "DELETE FROM permohonan_pelabuhan WHERE idPP=?";
					$param_type 	= "s";
					$param_data 	= array(
										"idPP" 	=> $value
									 	);
					$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"APPLICATION UPDATE (PORT)");
				}
				$success 	= 3;
				$msg 		= "RECORD DELETED!";

}else if($do=="submit_me"){							
				$sql 	 		= "UPDATE 
										permohonan_main 
									SET 
										submit 	 			= 'Y',
										idApproveMFSO 	 	= 0,
										commentsMFSO 	 	= '',
										flagApproveMFSO 	= 'N',
										idApproveDG 	 	= 0,
										commentsDG 	 		= '',
										flagApproveDG 		= 'N',
										idApproveMTSO 	 	= 0,
										commentsMTSO 	 	= '',
										flagApproveMTSO 	= 'N'
									WHERE 
										idPermohonan = ?";
				$param_type 	= "s";
				$param_data 	= array(
									"idPermohonan" 		=> $ii
								 	);
				$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);
			}

}

if($success == 1){
			$_SESSION['success'] 		= 1;
			$_SESSION['success_msg'] 	= $msg;
		}else if($success == 2){
			$_SESSION['success'] 		= 2;
			$_SESSION['success_msg'] 	= "OPS! SOMETHING WRONG";
		}else if($success == 3){
			$_SESSION['success'] 		= 3;
			$_SESSION['success_msg'] 	= $msg;
		}

endif;

if($success){
		echo "<script>window.location.replace('index.php?page=edg/main&np=edg/port_call&ii={$ii}&success={$success}');</script>";
		exit();
	}
	
	if($ii > 0){
	
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.idPermohonan,
							a.flagDG,
							a.idApproveMFSO,
							a.idApproveDG,
							a.idApproveMTSO,
							a.commentsMFSO,
							a.commentsDG,
							a.commentsMTSO,
							submit
						FROM 
							permohonan_main a 
						WHERE 
							a.idPermohonan=?
						");
		$stmt->bind_param("s",$permohonan_main = $ii);
		$stmt->execute();

if ($stmt->error)
    		print_r('error executing statement: ' . $stmt->error);

$result 		= $stmt->get_result();
		$stmt->close();
		$row=$result->fetch_assoc();

$idApproveMFSO 			= $row['idApproveMFSO'];
		$idApproveDG 			= $row['idApproveDG'];
		$idApproveMTSO 			= $row['idApproveMTSO'];
		$commentsMFSO 			= $row['commentsMFSO'];
		$commentsDG 			= $row['commentsDG'];
		$commentsMTSO 			= $row['commentsMTSO'];
		$submit 				= $row['submit'];

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.idPP,
							a.idPermohonanMain,
							a.idPelabuhan,
							DATE_FORMAT(a.tarikhTiba,'%d-%m-%Y') AS tarikhTiba,
							DATE_FORMAT(a.tarikhBerlepas,'%d-%m-%Y') AS tarikhBerlepas,
							a.securityLevel,
							b.nama,
							b.hadMasa
						FROM 
							permohonan_pelabuhan a 
						LEFT JOIN 
							kod_pelabuhan b ON b.idPelabuhan = a.idPelabuhan
						WHERE 
							a.idPermohonanMain=?
						");
		$stmt->bind_param("s",$permohonan_main = $ii);
		$stmt->execute();

if ($stmt->error)
    		print_r('error executing statement: ' . $stmt->error);

$result2 		= $stmt->get_result();
		$stmt->close();

$session 	= array();
		// $rowx=$result2->fetch_assoc();
		// print_r($result2->num_rows);

$isps 				= "";
		$isps_href 			= "index.php?page=edg/main&np=edg/isps_info&ii={$ii}";
		if($result2->num_rows){
			$dis_next 			= "";
			$other 				= "";
			$other_href 		= "index.php?page=edg/main&np=edg/other_part&ii={$ii}";
			$upload 			= "";
			$upload_href 		= "index.php?page=edg/main&np=edg/other_part&ii={$ii}";

if($row['flagDG'] == 'Y'){
				$dg 				= "";
				$dg_href 			= "index.php?page=edg/main&np=edg/dg&ii={$ii}";
			}else{
				$dg 				= "disabled";
				$dg_href 		= "javascript:void(0)";
			}

}else{
			$dis_next 			= "disabled";
			$other 				= "disabled";
			$other_href 		= "javascript:void(0)";
			$upload 			= "disabled";
			$upload_href 		= "javascript:void(0)";
			$dg 				= "disabled";
			$dg_href 			= "javascript:void(0)";
		}
		$particular 		= "disabled";
		$particular 		= "javascript:void(0)";

if(!$row){
			echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
			exit();
		}

}else{
		echo "<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>";
		exit();
	}

<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					
					<h1>
					<ol class="breadcrumb" style="padding:0px; margin: 0px">
                        <li><a href="index.php?page=edg/main" style="color:black"><i class="fa fa-home"></i></a></li>
                        <li><a href="javascript:void(0)" style="color:black">NEW APPLICATION</a></li>
                    </ol>
                	</h1>
				</div>
			</div>
			<div class="col-sm-6 hidden-xs">
				<div class="header-section">
					
						
						
					
				</div>
			</div>
		</div>
	</div>

<div class="block full">

<?php include 'tabs.php'; ?>

<form class="push form-horizontal" id="form-validationx" action="index.php?page=edg/main&np=edg/port_call&ii=<?php echo $ii;?>" method="post">

<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>APPLY FOR NEW PORT</strong></h4>
						</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="nama">Name <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<input type="text" id="nama" name="nama" value="<?php echo $nama;?>" class="form-control validation" data-validation="default" >
							    </div>
							</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="idNegara">Country <span class="text-danger">*</span></label>
							    <div class="col-md-6">
										<?php 
											$sqlx 	= "SELECT * FROM kod_negara WHERE flagAktif = 'Y' ORDER BY nama";
											$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
										?>
										<select class="form-control select-select2 validation" data-validation="default" name="idNegara" id="idNegara">
											<option value="">-- Please select --</option>
											<?php while($aa = $rstx->fetch_assoc()){ ?>
											<option value="<?php echo $aa['idNegara']; ?>" ><?php echo $aa['nama']; ?></option>
											<?php 	}?>
										</select>
							    </div>
							</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="hadMasa">Time Limit <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<input type="text" id="hadMasa" name="hadMasa" value="<?php echo $tarikhTiba;?>" class="form-control validation" data-validation="default">
							    </div>
							</div>
				
						</div>

<div class="modal-footer">
						
						<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>
						</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-md">
					<div class="modal-content">

<form class="push form-horizontal" id="form-validation" action="index.php?page=edg/main&np=edg/port_call&ii=<?php echo $ii;?>" method="post">

<div class="form-group">
							    <label class="col-md-3 control-label" for="idPelabuhan">Port <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<div class="input-group">
										<?php 
											$sqlx 	= "SELECT * FROM kod_pelabuhan WHERE flagAktif = 'Y' AND flagApprove = 'Y' ORDER BY nama";
											$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));

$sqly 	= "SELECT * FROM kod_pelabuhan WHERE flagAktif = 'Y' AND flagApprove = 'N' ORDER BY nama";
											$rsty 	= $mysqli->query($sqly) or die(mysqli_error($mysqli));
										?>
										<select class="form-control select-select2 validation" data-validation="default" name="idPelabuhan" id="idPelabuhan">
											<optgroup label="Pending Approval">
											<?php while($aa = $rsty->fetch_assoc()){ ?>
											<option value="<?php echo $aa['idPelabuhan']; ?>" disabled='disabled' ><?php echo $aa['nama']; ?></option>
											<?php 	}?>
											</optgroup>
											<option value="">-- Please select --</option>
											<?php while($aa = $rstx->fetch_assoc()){ ?>
											<option value="<?php echo $aa['idPelabuhan']; ?>" ><?php echo $aa['nama']; ?></option>
											<?php 	}?>
										</select>
										
										<a class="input-group-btn" data-toggle="tooltip" data-original-title="Add New Port" href="l_port" target="_blank">
										<span class="btn btn-effect-ripple btn-primary" style="overflow: hidden; position: relative;"><i class="fa fa-plus"></i></span>
										</a>
									</div>
							    </div>
							</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="tarikhTiba">Arrival Date <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<input type="text" id="tarikhTiba" name="tarikhTiba" value="<?php echo $tarikhTiba;?>" class="form-control input-datepicker validation" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
							    </div>
							</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="tarikhBerlepas">Departure Date <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<input type="text" id="tarikhBerlepas" name="tarikhBerlepas" value="<?php echo $tarikhBerlepas;?>" class="form-control input-datepicker validation" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
							    </div>
							</div>

<div class="form-group">
								<label class="col-md-3 control-label" for="val-aktifL">Security Level <span class="text-danger">*</span></label>
								<div class="col-md-6">
								<div class="radio">
								<label for="security1">
									<input class="not_autoset default_radio" data-validation="default" type="radio" id="security1" name="securityLevel" value="1"> 1
								</label>
								</div>
								<div class="radio">
								<label for="security2">
									<input class="not_autoset" data-validation="default" type="radio" id="security2" name="securityLevel" value="2"> 2
								</label>
								</div>
								<div class="radio">
								<label for="security3">
									<input class="not_autoset" data-validation="default" type="radio" id="security3" name="securityLevel" value="3"> 3
								</label>
								</div>
								</div>
							</div>						
						</div>

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

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th style="width: 40px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th class="text-center" style="width: 40px;">NO</th>
							<th>PORT</th>
							<th class="text-center">ARRIVAL DATE</th>
							<th class="text-center" style="width: 100px;">DEPARTURE DATE</th>
							<th class="text-center" style="width: 100px;">SECURITY LEVEL</th>
							<th class="text-center no_sorting" style="width: 40px;"><i class="fa fa-flash"></i></th>
						</tr>
					</thead>
					<tbody>
					<?php

$i=1;
						while($aa = $result2->fetch_assoc()){

$editdata = "idPelabuhan#{$aa['idPelabuhan']}|"
										."tarikhTiba#{$aa['tarikhTiba']}|"
										."tarikhBerlepas#{$aa['tarikhBerlepas']}|"
										."securityLevel#{$aa['securityLevel']}|"
										."val-id#{$aa['idPP']}";
						
					?>
						<tr>
							<td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $aa['idPP'];?>"><span></span></label></td>
							<td class="text-right"><?php echo $i++; ?>.</td>
							<td><?php echo $aa['nama']?></td>
							<td class="text-center"><?php echo $aa['tarikhTiba']?></td>
							<td class="text-center"><?php echo $aa['tarikhBerlepas']?></td>
							<td class="text-center"><?php echo $aa['securityLevel']?></td>
							<td class="text-center">
							<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 $editdata;?>"><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>
						</tr>
					<?php }	
						mysqli_free_result($resKod); 
					?>
					</tbody>
					<tbody>
					<?php 
						echo "<tr><td class='text-right'></td><td class='text-right'>{$i}.</td><td class='text-left text-warning' colspan='6'>N/A</td></tr>";
						for ($i=$i; $i <= 10; $i++) { 
							// if($i == 9)
								// echo "<tr><td class='text-right'></td><td class='text-right'>".($i+1).".</td><td class='text-left text-warning' colspan='6'>N/A</td></tr>";
							// else
								echo "<tr><td class='text-right'></td><td class='text-right'>{$i}.</td><td class='text-left text-warning' colspan='6'>N/A</td></tr>";
						}
					?>
					</tbody>
				</table>

</form>
			</div>
		
		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

var tt 	= $("#example-datatable tbody:eq(0) tr").length;
        	
        	if(tt>0)
        		tt_trgt = (tt%2);
        	else
        		tt_trgt = 0;

console.log(tt);
        	// if(tt < 7)
        	// $("#example-datatable tbody:eq(1) tr:eq("+tt_trgt+")").hide();

if(tt >= 10){
        		$(".add-me").addClass("disabled");
        	}

$("#example-datatable").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).modal("hide");
				$(modal_name).find("input").not(":button, :submit, :reset, .not_autoset").val("").prop("checked",false);
				$(modal_name).find(".default_radio, .default_checkbox").prop("checked",true);
				$(modal_name).find("select").children("option").prop("selected",false).trigger("change");				
				$(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"));
			});

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

$(document).on("click", ".del-me-all", function(){
				if(confirm("Delete This Records! Are You Sure?")){
					var check_tick = 0;
					$(this).closest("form").find("input[type='checkbox']").each(function(){
						if($(this).prop('checked'))
							check_tick++;
					});

if(check_tick>0)
						$(this).closest("form").submit();
					else
						alert("Please select which record to be remove!");
				}
			});

$("#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(){
				var modal_name 	= "."+$(this).data("modal-target");
				var editdata 	= $(this).data("editdata");
				$(modal_name).modal({keyboard:true});
				$(modal_name).find("input").not(":button, :submit, :reset, .not_autoset").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");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

});

</script>

</div>
	</div>

${this.title}

Code Editor : port_call_20220413.php