One Hat Cyber Team

Edit File: kodKapal.php

<?php if(empty($page)){ include("../access.php"); } ?>

<?php  
	$modal_name 	= str_replace("/", "-", $page);
	
	$user 			= get_user_full($_SESSION['session']);
	$roles 			= (int)$user['idRoles'];
	$idUser 		= (int)$user['idUser'];
?>

<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					<h1><i class="gi gi-boat"></i>&nbsp;&nbsp;VESSELS</h1>
				</div>
			</div>
			<div class="col-sm-6 hidden-xs">
				<div class="header-section">
					
						
						
					
				</div>
			</div>
		</div>
	</div>

<div class="block full">

<?php

$success 	= 0;
				if($_POST):

$do 	= $_POST['type_submit'];
					//print_r($_POST);
					//exit();

$id=$_POST['val-id'];
					//$kod=strtoupper($_POST['val-code']);
					$nama=mysqli_real_escape_string($mysqli_link,strtoupper($_POST['val-name']));
					$sykt=$_POST['val-sykt'];
					$type=$_POST['val-type'];
					$imo=$_POST['val-imo'];
					$issc=$_POST['val-issc'];
					$flag=$_POST['val-flag'];
					$call=$_POST['val-call'];
					$mmsi=$_POST['val-mmsi'];
					$gt=$_POST['val-gt'];
					$tarikhLuputISSC=change_date($_POST['tarikhLuputISSC'],'Y-m-d');
					$ISSCAuthority=$_POST['ISSCAuthority'];					
					$flagAktif=$_POST['val-aktif'];

if($do=="add"){

$qAdd="INSERT INTO kod_kapal (nama,idSyarikat,idJenisKapal,IMO,ISSC,Flag,CallSign,flagAktif,flagApprove,MMSI,GT,tarikhLuputISSC,ISSCAuthority) VALUES ('$nama', '$sykt', '$type', '$imo', '$issc', '$flag', '$call', '$flagAktif', 'Y', '$mmsi', '$gt', '$tarikhLuputISSC', '$ISSCAuthority')";
						mysqli_query($mysqli_link,$qAdd) or die(mysqli_connect_error());

$last_id 		= mysqli_insert_id($mysqli_link);
						$folder 		= "./upload/vessel/{$last_id}";
						if(!is_dir($folder)):

mkdir($folder,0777,TRUE);
							$file 	= "./upload/index.html";
							copy($file, $folder."/index.html");

endif;

$list_ext 	= array(
										'.gif',
										'.pdf',
										'.jpeg',
										'.jpg',
										'.jpe',
										'.bmp',
										'.ico',
										'.svg',
										'.tif',
										'.tiff'
										);

$filename 	= $_FILES['file_upload']['name'];
						$ext 		= strtolower(substr($filename, strrpos($filename, ".")));

$crew 		= "";
						if (in_array($ext, $list_ext)) {
							$file_name 		= "issc{$ext}";
							move_uploaded_file($_FILES['file_upload']['tmp_name'],$folder."/".$file_name);

unset($sql);
							unset($param_type);
							unset($param_data);

$sql 	 		= "UPDATE 
													kod_kapal 
												SET 
													fail_issc 			= ?
												WHERE 
													idKapal = ?";
							$param_type 	= ""; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)
							$param_data 	= array(
												"fail_issc" 	=> $file_name,
												"idKapal" 		=> $last_id
											 	);
							$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"");

}

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

}else if($do=="edit"){						
						$qEdit="UPDATE kod_kapal SET nama='$nama', idSyarikat='$sykt', idJenisKapal='$type', IMO='$imo', ISSC='$issc', Flag='$flag', CallSign='$call', flagAktif='$flagAktif', MMSI='$mmsi', GT='$gt', tarikhLuputISSC='$tarikhLuputISSC', ISSCAuthority='$ISSCAuthority' WHERE idKapal='$id'";		
						mysqli_query($mysqli_link,$qEdit) or die(mysqli_connect_error());

$last_id 		= $id;
						$folder 		= "./upload/vessel/{$last_id}";
						if(!is_dir($folder)):

mkdir($folder,0777,TRUE);
							$file 	= "./upload/index.html";
							copy($file, $folder."/index.html");

endif;

$filename 	= $_FILES['file_upload']['name'];
						$ext 		= strtolower(substr($filename, strrpos($filename, ".")));

$crew 		= "";
						if (in_array($ext, $list_ext)) {
							$file_name 		= "issc{$ext}";
							move_uploaded_file($_FILES['file_upload']['tmp_name'],$folder."/".$file_name);

unset($sql);
							unset($param_type);
							unset($param_data);

}

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

}else if($do=="delete"){	
						foreach($_POST['myid'] as $value){						
							$qDelete="DELETE FROM kod_kapal WHERE idKapal='$value'";	
							mysqli_query($mysqli_link,$qDelete) or die(mysqli_connect_error());
						}
					$success 	= 3;
					}

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'] 	= "RECORD DELETED!";
					}

endif;

if($_GET['do']):
					//print_r($_GET);
					//exit();
					$do=$_GET['do'];
					$id=$_GET['id'];

if($do=="approve"){
						$qUpdate="UPDATE kod_kapal SET flagApprove='Y', idUserApprove='{$idUser}', tarikhApprove=NOW() WHERE idKapal='$id'";
						mysqli_query($mysqli_link,$qUpdate) or die(mysqli_connect_error());
					$success 	= 1;
					$msg = "RECORD APPROVED!";
					}

if($do=="xapprove"){
						$qUpdate="UPDATE kod_kapal SET flagApprove='T', idUserApprove='{$idUser}', tarikhApprove=NOW() WHERE idKapal='$id'";
						mysqli_query($mysqli_link,$qUpdate) or die(mysqli_connect_error());
					$success 	= 3;
					$msg = "RECORD NOT APPROVED!";
					}

endif;

if($success){
					echo "<script>window.location.replace('index.php?page=kod/kodKapal&success={$success}');</script>";
					exit();
				}
			?>

<?php 
?>
			<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>VESSEL</strong></h4>
						</div>

<div class="form-group">
							    <label class="col-md-3 control-label" for="val-name">Name <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-name" name="val-name" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-sykt">Company <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <select id="val-sykt" name="val-sykt" class="form-control validation select-select2" data-validation="default" data-placeholder="Company..">
		                                <option value=""></option>
								<?
								$qSykt="SELECT idSyarikat,nama FROM kod_syarikat WHERE flagAktif='Y' AND flagApprove='Y' ORDER BY nama";
								$resSykt=mysqli_query($mysqli_link, $qSykt) or die(mysqli_connect_error());
								while($rowSykt=mysqli_fetch_array($resSykt)){
								?>
										<option value="<?=$rowSykt['idSyarikat']?>"><?=$rowSykt['nama']?></option>
								<?}mysqli_free_result($resSykt)?>
									</select>
								</div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-type">Vessel Type <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <select id="val-type" name="val-type" class="form-control validation select-select2" data-validation="default" data-placeholder="Type..">
		                                <option value=""></option>
								<?
								$qType="SELECT idJenisKapal,nama FROM kod_jenis_kapal WHERE flagAktif='Y' ORDER BY nama";
								$resType=mysqli_query($mysqli_link, $qType) or die(mysqli_connect_error());
								while($rowType=mysqli_fetch_array($resType)){
								?>
										<option value="<?=$rowType['idJenisKapal']?>"><?=$rowType['nama']?></option>
								<?}mysqli_free_result($resType)?>
									</select>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-imo">IMO <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-imo" name="val-imo" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<hr>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-issc">ISSC No <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-issc" name="val-issc" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-fail">Upload ISSC <span class="text-danger">*</span></label>
							    <div class="col-md-6">
									<div class="input-group" data-toggle="tooltip" title="Upload ISSC">
									<div class="input-group-btn">
									<label class="btn btn-primary">
										Browse <input type="file" name="file_upload" class="form-control" style="display: none">
									</label>
									</div>
									<span class="up1">
									<input style="background: white;color: #000" readonly='readonly' value="" type="passenger_upload_text" id="passenger_upload_text" name="passenger_upload_text" value="" class="form-control validation upload-name" data-validation="default" placeholder="No File Selected">
									</span>
									<a href="<?php echo $linkPenumpang;?>" target="_blank" class="up2 form-control" style="cursor: pointer;">
										Click To Open<i class="fa fa-download pull-right" style="line-height: 1.42857143"></i>
									</a>
									<div class="up3 input-group-btn" data-toggle="tooltip" title="Delete File">
										<div class="btn btn-danger del-upload" data-senddata='{"ii": "<?php echo $ii;?>", "type": "passenger", "file": "<?php echo $failPenumpang;?>"}'><i class="fa fa-times"></i></div>
									</div>
									</div>
									<i id="" class="help-blockx animation-pullUp text-warning" style="font-size: 9pt">File Allowed: *.gif, *.pdf, *.jpeg, *.jpg, *.jpe, *.bmp</i>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="tarikhLuputISSC">ISSC Expiry Date <span class="text-danger">*</span></label>
							    <div class="col-md-2">
							        <input type="text" id="tarikhLuputISSC" name="tarikhLuputISSC" value="<?php echo $tarikhLuputISSC;?>" 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="ISSCAuthority">ISSC Issuing Authority <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="ISSCAuthority" name="ISSCAuthority" value="<?php echo $ISSCAuthority;?>" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<hr>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-flag">Flag <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-flag" name="val-flag" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-call">SCN <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-call" name="val-call" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-mmsi">MMSI <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-mmsi" name="val-mmsi" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-gt">GT <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-gt" name="val-gt" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>

<div class="form-group">
								<label class="col-md-3 control-label" for="val-aktifL">Status <span class="text-danger">*</span></label>
								<div class="col-md-6">
								  <label class="radio-inline" for="val-aktifY">
									  <input type="radio" class="not_autoset default_radio" id="val-aktifY" name="val-aktif" value="Y" <?if($rowKod['flagAktif']=="Y"){?>checked<?}?>> Active
								  </label>
								  <label class="radio-inline" for="val-aktifT">
									  <input type="radio" class="not_autoset" id="val-aktifT" name="val-aktif" value="T" <?if($rowKod['flagAktif']=="T"){?>checked<?}?>> Inactive
								  </label>
								</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 class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-name">Name</label>
							    <div class="form-control form-control-custom text-uppercase val-name"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-sykt">Company</label>
							    <div class="form-control form-control-custom text-uppercase val-sykt"></div>
							</div>
							</div>
							</div>
							
							<div class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-type">Vessel Type</label>
							    <div class="form-control form-control-custom text-uppercase val-type"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-imo">IMO</label>
							    <div class="form-control form-control-custom text-uppercase val-imo"></div>
							</div>
							</div>
							</div>
							
							<hr>
							
							<div class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-issc">ISSC No</label>
							    <div class="form-control form-control-custom text-uppercase val-issc"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-fail">ISSC Document</label>
							    <div class="form-control form-control-custom text-uppercase val-fail"><a href="s"><i class="fa fa-search"></i>&nbsp;Click To View</a></div>
							</div>
							</div>
							</div>
							
							<div class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-exp">ISSC Expiry Date</label>
							    <div class="form-control form-control-custom text-uppercase val-exp"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-issue">ISSC Issuing Authority</label>
							    <div class="form-control form-control-custom text-uppercase val-issue"></div>
							</div>
							</div>
							</div>
							
							<hr>
							
							<div class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-flag">Flag</label>
							    <div class="form-control form-control-custom text-uppercase val-flag"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-scn">SCN</label>
							    <div class="form-control form-control-custom text-uppercase val-scn"></div>
							</div>
							</div>
							</div>
							
							<div class="row">
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-mmsi">MMSI</label>
							    <div class="form-control form-control-custom text-uppercase val-mmsi"></div>
							</div>
							</div>
							
							<div class="col-md-6">
							<div class="form-group">
							    <label class="control-label" for="val-gt">GT</label>
							    <div class="form-control form-control-custom text-uppercase val-gt"></div>
							</div>
							</div>
							</div>
								
			
						</div>
						<input type="hidden" name="type_submit" value="add">
						<input type="hidden" name="val-id" value="">

<div class="modal-footer">
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>
						</div>
					</form>

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

<?
$qPending="SELECT COUNT(*) AS bil FROM kod_kapal WHERE flagApprove='N'";
$resPending=mysqli_query($mysqli_link, $qPending) or die(mysqli_connect_error());
$rowPending=mysqli_fetch_array($resPending);

if($rowPending['bil']!=0){
?>
        
        <div id="faq1" class="panel-group">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <div class="panel-title">
                        <a class="accordion-toggle" data-toggle="collapse" data-parent="#faq1" href="#faq1_q1"><h4><span class="label label-danger">&nbsp;Pending Approval List (<strong><?=$rowPending['bil']?></strong>)&nbsp;</h4></span></a>
                    </div>
                </div>
                <div id="faq1_q1" class="panel-collapse collapse out">
                    <div class="panel-body">
			<form method="post" data-modal-target="modal-pending">

<div class="table-responsive">
            <table id="general-table" class="table table-striped table-condensed table-bordered table-vcenter">
                <thead>
                    <tr>
                        <th style="width: 80px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th>NAME</th>
							<th>COMPANY</th>
							<th>TYPE</th>
							<th>ISSC</th>
							<th class="text-center">ISSC EXPIRY DATE</th>														
                        <th >APPLIED BY</th>
                        <th style="width: 150px;" class="text-center"><i class="fa fa-gear"></i></th>
                    </tr>
                </thead>
                <tbody>
				<?php

$qPendingList="SELECT a.*,b.nameUser,IF(tarikhLuputISSC = '0000-00-00','',DATE_FORMAT(tarikhLuputISSC,'%d-%m-%Y')) AS tarikhLuputISSC FROM kod_kapal a LEFT JOIN user_list b ON b.idUser = a.idUserApply WHERE a.flagApprove='N'";
					$resPendingList=mysqli_query($mysqli_link, $qPendingList) or die(mysqli_connect_error());
					while($rowPendingList=mysqli_fetch_array($resPendingList)){

$qKod2="SELECT nama FROM kod_syarikat WHERE idSyarikat='$rowPendingList[idSyarikat]'";
						$resKod2=mysqli_query($mysqli_link, $qKod2) or die(mysqli_connect_error());
						$rowKod2=mysqli_fetch_array($resKod2);

$qKod3="SELECT nama FROM kod_jenis_kapal WHERE idJenisKapal='$rowPendingList[idJenisKapal]'";
						$resKod3=mysqli_query($mysqli_link, $qKod3) or die(mysqli_connect_error());
						$rowKod3=mysqli_fetch_array($resKod3);

$file_link_p 			= "upload/vessel/{$rowPendingList['idKapal']}/".$rowPendingList['fail_issc'];

$vessel->{"val-name"} 	= $rowPendingList['nama'];
						$vessel->{"val-sykt"} 	= $rowKod2['nama'];
						$vessel->{"val-type"} 	= $rowKod3['nama'];
						$vessel->{"val-imo"} 	= $rowPendingList['IMO'];
						$vessel->{"val-issc"} 	= $rowPendingList['ISSC'];
						$vessel->{"val-fail"} 	= (!empty($rowPendingList['fail_issc']) && file_exists($file_link_p)) ? $file_link_p : "";
						$vessel->{"val-exp"} 	= ($rowPendingList['tarikhLuputISSC'] == "0000-00-00") ? "" : $rowPendingList['tarikhLuputISSC'] ;
						$vessel->{"val-issue"} 	= $rowPendingList['ISSCAuthority'];
						$vessel->{"val-flag"} 	= $rowPendingList['Flag'];
						$vessel->{"val-scn"} 	= $rowPendingList['CallSign'];
						$vessel->{"val-mmsi"} 	= $rowPendingList['MMSI'];
						$vessel->{"val-gt"} 	= $rowPendingList['GT'];
						$vessel->{"val-id"} 	= $rowPendingList['idKapal'];
						$editdata2 				= json_encode($vessel);
					?>
                    <tr>
                        <td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></td>
                        <td><strong><?=$rowPendingList['nama']?></strong></td>
                        <td><?=$rowKod2['nama']?></td>
                        <td><?=$rowKod3['nama']?></td>
                        <td><?=$rowPendingList['ISSC']?></td>
                        <td class="text-center"><?=$rowPendingList['tarikhLuputISSC']?></td>                        
						<td>
						<?=$rowPendingList['nameUser']?></br>
						(<?=date("d-m-Y H:i:s", strtotime($rowPendingList['tarikhApply']))?>)
						</td>
                        <td class="text-center">
                        	<a href="javascript:void(0)" title="View/Edit Record" class="btn btn-effect-ripple btn-sm btn-primary process_me" data-modal-target="modal-pending" data-editdata='<?php echo $editdata2;?>'><i class="fa fa-search"></i></a>
                            <a href="index.php?page=kod/kodKapal&do=approve&id=<?=$rowPendingList['idKapal']?>" data-toggle="tooltip" title="Approve" class="btn btn-effect-ripple btn-sm btn-info do_me"><i class="fa fa-check"></i></a>
                            <a href="index.php?page=kod/kodKapal&do=xapprove&id=<?=$rowPendingList['idKapal']?>" data-toggle="tooltip" title="Not Approve" class="btn btn-effect-ripple btn-sm btn-warning do_me"><i class="fa fa-times"></i></a>
                        </td>
                    </tr>
<?}mysqli_free_result($resPendingList)?>
			</form>
				</tbody>
			</table>
		</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;">ID</th>
							<th>NAME</th>
							<th>COMPANY</th>
							<th>TYPE</th>
							<th>ISSC</th>
							<th class="text-center">ISSC EXPIRY DATE</th>
							<th class="text-center">ISSC FILE</th>
							<th class="text-center" style="width: 60px;">STATUS</th>
							<th class="text-center no_sorting" style="width: 40px;"><i class="fa fa-flash"></i></th>
						</tr>
					</thead>
					<tbody>
					<?php
					$labels['Y']['class'] = "label-success";
					$labels['Y']['text'] = "Active";
					$labels['T']['class'] = "label-danger";
					$labels['T']['text'] = "Inactive";
					?>
					<?php 
						
						$qKod="SELECT *,IF(tarikhLuputISSC = '0000-00-00','',DATE_FORMAT(tarikhLuputISSC,'%d-%m-%Y')) AS tarikhLuputISSC FROM kod_kapal WHERE flagApprove='Y'";
						$resKod=mysqli_query($mysqli_link, $qKod) or die(mysqli_connect_error());
						while($rowKod=mysqli_fetch_array($resKod)){

//for($i=1; $i<31; $i++) {

// editdata seperti send get value, split by | 
							// cth : <namainput>#<value> | <namaselect>#<value>
							$editdata = "val-sykt#$rowKod[idSyarikat]|"
										."val-name#$rowKod[nama]|"
										."val-type#$rowKod[idJenisKapal]|"
										."val-imo#$rowKod[IMO]|"
										."val-issc#$rowKod[ISSC]|"
										."val-flag#$rowKod[Flag]|"
										."val-call#$rowKod[CallSign]|"
										."val-id#$rowKod[idKapal]|"
										."val-mmsi#$rowKod[MMSI]|"
										."val-gt#$rowKod[GT]|"
										."tarikhLuputISSC#$rowKod[tarikhLuputISSC]|"
										."ISSCAuthority#$rowKod[ISSCAuthority]|"
										."val-href#$rowKod[fail_issc]|"
										."val-aktif#$rowKod[flagAktif]";

$qKod2="SELECT nama FROM kod_syarikat WHERE idSyarikat='$rowKod[idSyarikat]'";
						$resKod2=mysqli_query($mysqli_link, $qKod2) or die(mysqli_connect_error());
						$rowKod2=mysqli_fetch_array($resKod2);

$qKod3="SELECT nama FROM kod_jenis_kapal WHERE idJenisKapal='$rowKod[idJenisKapal]'";
						$resKod3=mysqli_query($mysqli_link, $qKod3) or die(mysqli_connect_error());
						$rowKod3=mysqli_fetch_array($resKod3);

$file_link 	= "upload/vessel/{$rowKod['idKapal']}/{$rowKod['fail_issc']}";
					?>
						<tr>
							<td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $rowKod['idKapal'];?>"><span></span></label></td>
							<td class="text-center"><?=$rowKod['idKapal']?></td>
							<td><strong><?=$rowKod['nama']?></strong></td>
							<td><?=$rowKod2['nama']?></td>
							<td><?=$rowKod3['nama']?></td>
							<td><?=$rowKod['ISSC']?></td>
							<td class="text-center"><?=$rowKod['tarikhLuputISSC']?></td>
							<td class="text-center">
							<?php 
								if(!empty($rowKod['fail_issc']) && file_exists($file_link)){
							?>
								<div class="input-group donwload_main_<?php echo $rowKod['idKapal'];?>" data-toggle="tooltip" title="ISSC File">
								<a href="<?php echo $file_link;?>" target="_blank" class="up2 form-control" style="cursor: pointer;">
									Click To Open<i class="fa fa-download pull-right" style="line-height: 1.42857143"></i>
								</a>
								<div class="input-group-btn" data-toggle="tooltip" data-placement="right" title="Delete File">
									<div class="btn btn-danger del-upload" data-senddata='{"ii": "<?php echo $rowKod['idKapal'];?>", "file": "<?php echo $rowKod['fail_issc'];?>"}'><i class="fa fa-times"></i></div>
								</div>
								</div>
							<?php 
								}else{
									echo '<span class="label label-warning">None</span>';
								}
							?>
							</td>
							<?php $rand = $rowKod['flagAktif'] ?>
							<td class="text-center"><span class="label<?php echo ($labels[$rand]['class']) ? " " . $labels[$rand]['class'] : ""; ?>"><?php echo $labels[$rand]['text'] ?></span></td>
							<td class="text-center">
							<a href="javascript:void(0)" title="View/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>
				</table>
			</form>
			</div>
		
		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

$(".do_me").on("click", function(x){
				x.preventDefault();
				var act 	= $(this).prop("href");
				var form 	= $(this).parents("form");
				if(confirm("Are You Sure?")){
					form.prop("action",act).submit();
				}
            });

$(document).on("click", ".process_me", function(){
				var modal_name 	= "."+$(this).closest("form").data("modal-target");
				var modal_form 	= $("form",modal_name);
				var editdata 	= $(this).data("editdata");
				$(modal_name).modal({keyboard:true});

$.each(editdata,function(x,y){
					if(x==="val-fail"){
						if(y!=='')
							$("."+x,modal_form).html("<a href='"+y+"' target='_blank'><i class='fa fa-search'></i>&nbsp;Click To View</a>");
						else
							$("."+x,modal_form).text("");
					}else{
						$("."+x,modal_form).text(y);
					}
				});
            });

$("#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");
				var modal_form 	= $("form",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 option:selected").prop("selected",false).trigger("change");
				$(modal_name).find('.help-block').remove();
				$(modal_name).find('.form-group').removeClass('has-success has-error');
				$(modal_form).setvalidation('');
				$("[name='type_submit']",modal_form).val("add");
				// console.log($._data($("#form-validation").get(0), "events"));

$("[type='file']",modal_form).each(function(){

$(this)
					.parent("label")
					.parent("div")
					.parent("div")
					.find("a")
					.prop("href","1");

var t_parent 	= $(this).closest(".input-group");
					var up1 		= $(".up1",t_parent);
					var up2 		= $(".up2",t_parent);
					var up3 		= $(".up3",t_parent);
					var up2_val 	= up2.prop("href").substr(up2.prop("href").lastIndexOf('/') + 1);
					if(up2_val !== "1"){
						up1.hide();
						up2.show();
						$(".btn",up3).removeClass("disabled");
					}else{
						up1.show();
						up2.hide();
						$(".btn",up3).addClass("disabled");
					}
				});

});

$(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");
				var modal_form 	= $("form",modal_name);
				$(modal_name).modal({keyboard:true});
				$(modal_name).find("input").not(":button, :submit, :reset, .not_autoset").val("").prop("checked",false);
				$(modal_name).find("select option:selected").prop("selected",false).trigger("change");
				$(modal_name).find('.help-block').remove();
				$(modal_name).find('.form-group').removeClass('has-success has-error');
				$(modal_form).setvalidation(editdata);
				$("[name='type_submit']",modal_form).val("edit");

var t_id 		= $("[name='val-id']",modal_form).val();
				var href_file 	= '1';
				if($(".donwload_main_"+t_id,document).find("a").prop("href"))
					href_file 	= $(".donwload_main_"+t_id,document).find("a").prop("href");

$("[type='file']",modal_form)
				.parent("label")
				.parent("div")
				.parent("div")
				.find("a")
				.prop("href","upload/vessel/"+t_id+"/"+href_file);

$(".del-upload",modal_form).data("senddata",{"ii": t_id,"file": href_file.substr(href_file.lastIndexOf('/') + 1)});

$("[type='file']",modal_form).each(function(){
					var t_parent 	= $(this).closest(".input-group");
					var up1 		= $(".up1",t_parent);
					var up2 		= $(".up2",t_parent);
					var up3 		= $(".up3",t_parent);
					var up2_val 	= up2.prop("href").substr(up2.prop("href").lastIndexOf('/') + 1);
					if(up2_val !== "1"){
						up1.hide();
						up2.show();
						$(".btn",up3).removeClass("disabled");
					}else{
						up1.show();
						up2.hide();
						$(".btn",up3).addClass("disabled");
					}
				});

});

$("[type='file']").on("change",function(){

var t_parent 	= $(this).closest(".input-group");
				var up1 		= $(".up1",t_parent);
				var up2 		= $(".up2",t_parent);
				var up3 		= $(".up3",t_parent);
				var validExtensions = ['gif','pdf','jpeg','jpg','jpe','bmp','ico','svg','tif','tiff']; //array of valid extensions
				var fileName = $(this).val().toLowerCase();
				var fileNameExt = fileName.substr(fileName.lastIndexOf('.') + 1);

if ($.inArray(fileNameExt, validExtensions) == -1){
					alert("Invalid file type");
					$(this).val("");
        			$(".btn",up3).removeClass("disabled").addClass("disabled");
					return false;
				}else{
        			$(this).parents("div.input-group").find(".upload-name").val(fileName.substr(fileName.lastIndexOf('\\') + 1));
        			$(".btn",up3).removeClass("disabled");
				}
        	});

$(".del-upload").on("click",function(){	
				var t_parent 	= $(this).parents(".input-group");
				var up1 		= $(".up1",t_parent);
				var up2 		= $(".up2",t_parent);
				var up3 		= $(".up3",t_parent);	
				var senddata 	= $(this).data("senddata");
				if(up2.is(':visible')){
					if(confirm("Delete This File?")){
						$.post( 
							"ajax.php?do=clear_file_kapal", 
							senddata
						).done(function(data) {
							up1.show();
							up2.hide();
							$(".btn",up3).addClass("disabled");
						});

$(".tooltip",document).remove();
						$(".donwload_main_"+senddata.ii,document).parent("td").append("<span class='label label-warning'>None</span>");
						$(".donwload_main_"+senddata.ii,document).remove();
					}
				}else{
					$("input",t_parent).prop("value","");
					$(".btn",up3).addClass("disabled");
				}
			});

});

</script>

</div>