One Hat Cyber Team

Edit File: s_main.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 ;
	$dis_next 		= ($ii>0) ? $ii : "disabled" ;
	$success 	 	= 0;
	$type_submit 	= "add";

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

if(!empty($ii)){
    	if($ii>0){
			// $query="SELECT * FROM visit_main WHERE idVisitor='{$idUser}' AND idVisitMain = '{$ii}'";
			$query="SELECT * FROM visit_main WHERE idVisitMain = '{$ii}'";
			$result=$mysqli->query($query);	
			$row=$result->fetch_assoc();

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

if($_POST):

$do 	= $_POST['type_submit'];

if($ii > 0){
	
			$sql 	 		= "UPDATE 
									visit_main 
								SET 
									idMarineFacility 	= ?,
									tarikhVisit 	 	= ?,
									flagStatus 	 		= ?
								WHERE 
									idVisitMain = ?";
			$param_type 	= "ssss";
			$param_data 	= array(
								"idMarineFacility" 	=> $_POST['idMarineFacility'],
								"tarikhVisit" 		=> change_date($_POST['tarikhVisit'],'Y-m-d'),
								"flagStatus" 		=> $_POST['flagStatus'],
								"idVisitMain" 		=> $ii
							 	);
			$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"SITE VISIT - UPDATED");

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

}else{

$sql 	 		= "	INSERT INTO 
								visit_main (
									idVisitor,
									idMarineFacility,
									tarikhVisit,
									flagStatus,
									enter_by,
									enter_date
								) VALUES (
									?,
									?,
									?,
									?,
									?,
									now()
								)";
			$param_type 	= "sssss";
			$param_data 	= array(
								"idVisitor" 		=> $idUser,
								"idMarineFacility" 	=> $_POST['idMarineFacility'],
								"tarikhVisit" 		=> change_date($_POST['tarikhVisit'],'Y-m-d'),
								"flagStatus" 		=> $_POST['flagStatus'],
								"enter_by" 			=> $idUser
							 	);
			$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"SITE VISIT - ADDED");
			$last_id 	= $data[0];

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

if($success){
				echo "<script>window.location.replace('index.php?page=edg/site&np=edg/s_main&ii={$last_id}&success={$success}');</script>";
				exit();
			}

}

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;
		}

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

endif;
	
	if($ii > 0){
		
		$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT *,DATE_FORMAT(tarikhVisit,'%d-%m-%Y') AS tarikhVisit FROM visit_main WHERE idVisitMain=?");
		$stmt->bind_param("s",$idVisitMain = $ii);
		$stmt->execute();
		$result 		= $stmt->get_result();
		$stmt->close();

$session 	= array();
		$row=$result->fetch_assoc();

$idMarineFacility 	= $row['idMarineFacility'];
		$tarikhVisit 		= $row['tarikhVisit'];
		$flagStatus 		= $row['flagStatus'];

$detail 				= "";
		$detail_href 			= "index.php?page=edg/site&np=edg/s_detail&ii={$ii}";
		$upload 				= "";
		$upload_href 			= "index.php?page=edg/site&np=edg/s_upload&ii={$ii}";

$dis_next 				= "";
	}else{

$idVisitor 			= "";
		$idMarineFacility 	= "";
		$tarikhVisit 		= "";
		$flagStatus 		= "OPEN";

$detail 				= "disabled";
		$detail_href 			= "javascript:void(0)";
		$upload 				= "disabled";
		$upload_href 			= "javascript:void(0)";

$dis_next 				= "disabled";

}

?>
<style type="text/css">
</style>
	
	<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/site" style="color:black"><i class="fa fa-home"></i></a></li>
                        <li><a href="javascript:void(0)" style="color:black">SITE VISIT</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">
		
		<div class="block-section">
			<ul class="nav nav-pills nav-justified">
				<li class="active"><a href="javascript:void(0)">Site Visit</a></li>
				<li class="<?php echo $detail;?>"><a href="<?php echo $detail_href; ?>">Details / Notes &amp; Files Upload</a></li>
			</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-md">
					<div class="modal-content">

<form class="push form-horizontal" id="form-validation2" action="index.php?page=edg/main&np=edg/ship_particular&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 Vessel</strong></h4>
						</div>

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

<div class="form-group">
							    <label class="col-md-3 control-label" for="idJenisKapal">Vessel Type <span class="text-danger">*</span></label>
							    <div class="col-md-6">
								<?php 
									$sqlx 	= "SELECT * FROM kod_jenis_kapal 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="idJenisKapal" id="idJenisKapal">
									<option value="">-- Please select --</option>
									<?php while($aa = $rstx->fetch_assoc()){ ?>
									<option value="<?php echo $aa['idJenisKapal']; ?>" ><?php echo $aa['nama']; ?></option>
									<?php 	}?>
								</select>
							    </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>

<form class="form-horizontal" id="form-validation" method="post">
				<div class="row">
				<div class="col-md-6">
					<div class="form-group">
					    <label class="col-md-4 control-label" for="vessel">Name Of Terminal <span class="text-danger">*</span></label>
						<div class="col-md-8">
							<?php 
								$sqlx 	= "SELECT * FROM kod_marine_facility 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="idMarineFacility" id="idMarineFacility">
								<option value="">-- Please select --</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>

<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label" for="tarikhVisit">Date <span class="text-danger">*</span></label>
					<div class="col-md-4">
						<input type="text" id="tarikhVisit" name="tarikhVisit" value="<?php echo change_blank($tarikhVisit,'','00-00-0000 00:00:00');?>" class="form-control input-datepicker validation" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
					</div>
				</div>
				</div>
				</div>
				
				<div class="row">
				<div class="col-md-6">
				<div class="form-group">
					<label class="col-md-4 control-label text-danger">Status <span class="text-danger">*</span></label>
					<div class="col-md-8">
						<label class="radio-inline" for="flagStatus1">
							<input class="validation" data-validation="default" type="radio" id="flagStatus1" name="flagStatus" value="OPEN" <?php if($flagStatus=='OPEN'){ echo "checked='checked'"; } ?> > Open
						</label>
						<label class="radio-inline" for="flagStatus2">
							<input class="validation" data-validation="default" type="radio" id="flagStatus2" name="flagStatus" value="CLOSED" <?php if($flagStatus=='CLOSED'){ echo "checked='checked'"; } ?> > Closed
						</label>
					</div>
				</div>
				</div>
				</div>
				
				<hr>
				<center>
				<div class="btn-group">
				<a class="btn btn-warning disabled"><i class="fa fa-chevron-left"></i></a>
				<button class="btn btn-primary" href="index.php?page=edg/main">Save</button>
				<a class="btn btn-warning <?php echo $dis_next;?>" href="index.php?page=edg/main&np=edg/s_detail&ii=<?php echo $ii;?>"><i class="fa fa-chevron-right"></i></a>
				</div>
				</center>
			</form>
		</div>

$(".submit_form").on("click",function(){
				$.confirm({
					title: 'Confirm!',
					content: 'Submit This Application For Further Action?',
					buttons: {
						confirm: function () {
							$(".submit_me").trigger("submit");
						},
						cancel: function () {
							// $.alert('Canceled!');
						}
					}
				});
        	});

$("[name='purpose']").on("change",function(){
        		if($(this).val() === ''){
        			$("[name='other_purpose']").val("");
        		}else{
        			$("[name='other_purpose']").val("-");
        		}
        	});

// $(".submit_me").on("submit",function(){
    //     		if(!confirm("Submit This Application For Further Action?")){
				// 	return false;
				// }
        	// });
        	// $(this).trigger("resize");
			$(document).on("click", ".add-me", function(){
				var modal_name 	= "."+$(this).data("modal-target");
				$(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-validation2").setvalidation('');
				$("#form-validation2 > [name='type_submit']").val("add");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

$("#form-validation").setvalidation2();
			$("#form-validation").on("submit",function(){
				if($(this).find(".has-error").length === 0){
					if(!confirm("Save This Record. Are You Sure?")){
						return false;
					}
				}
			});

$("[name='vessel']").on("change",function(){
        		var t_val 	= $(this).val();
				$.ajax({
					type		: "POST",
					data 		: "idKapal="+t_val,
					url 		: "ajax.php?do=get_vessel",
					success 	: function(msg){
						var obj = jQuery.parseJSON(msg);
						if(obj){
							$("[name='imo']").val(obj.IMO);
							$("[name='issc']").val(obj.ISSC);
							$("[name='callsign']").val(obj.CallSign);
							$("[name='nama_syarikat']").val(obj.nama_syarikat);
							$("[name='flag']").val(obj.Flag);
							$("[name='nama_jeniskapal']").val(obj.nama_jeniskapal);
						}else{
							$("[name='imo']").val("");
							$("[name='issc']").val("");
							$("[name='callsign']").val("");
							$("[name='nama_syarikat']").val("");
							$("[name='flag']").val("");
							$("[name='nama_jeniskapal']").val("");
						}
					}
				});
        	});

$("#form-validation").find("select").trigger("change");
        });

</script>
	</div>