One Hat Cyber Team

View File Name : kodKapal_a.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'];
	$agentname 		= $user['nameUser'];
?>

	<!-- Blank Header -->
	<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">
					<!-- <ul class="breadcrumb breadcrumb-top"> -->
						<!-- <li>Extra Pages</li> -->
						<!-- <li><a href="">Blank</a></li> -->
					<!-- </ul> -->
				</div>
			</div>
		</div>
	</div>
	<!-- END Blank Header -->

	<!-- Get Started Block -->
	<div class="block full">
		<!-- Get Started Title -->
<!--
		<div class="block-title">
			<h2>Blank</h2>
		</div>
-->
<!-- [QUERY_STRING] -->

			<?php 

				$success 	= 0;
				if($_POST):

					echo "<center><i class='fa fa-spinner fa-5x fa-spin text-success'></i></center>";
					$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'];
					$iso=$_POST['val-iso'];
					$tarikhLuputISSC=change_date($_POST['tarikhLuputISSC'],'Y-m-d');
					$ISSCAuthority=$_POST['ISSCAuthority'];					
					// $flagAktif=$_POST['val-aktif'];
					$flagAktif='Y';

					if($do=="add"){						
						$qAdd="INSERT INTO kod_kapal (
								nama,
								namaSyarikat,
								idJenisKapal,
								IMO,
								ISSC,
								Flag,
								CallSign,
								flagAktif,
								flagApprove,
								idUserApply,
								tarikhApply,
								MMSI,
								GT,
								tarikhLuputISSC,
								ISSCAuthority,
								iso_3166_3
							) 
							VALUES (
								'$nama', 
								'$sykt', 
								'$type', 
								'$imo', 
								'$issc', 
								'$flag', 
								'$call', 
								'Y', 
								'Y', 
								{$idUser}, 
								NOW(), 
								'$mmsi', 
								'$gt', 
								'$tarikhLuputISSC', 
								'$ISSCAuthority',
								'$iso'
							)";
						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!";


						$sql 			= "SELECT * FROM kod_template WHERE kod='S08'";
						$param_data 	= array();
						$data 	= mysqli_prepare_all($sql,$param_type = "auto",$param_data);
						$tmpt 	= $data->fetch_assoc();

						$agentname 		= strtoupper($agentname);
						$vesselname 	= strtoupper($tmpt['text']);

						$stmt  			= $mysqli->stmt_init();
						$stmt->prepare("SELECT c.mobileNo 
										FROM utiliti_menu a 
										LEFT JOIN utiliti_kawalan b ON b.idMenu=a.idMenu 
										LEFT JOIN user_list c ON c.idRoles=b.idRoles 
										WHERE a.href='index.php?page=kod/kodKapal' 
										AND c.flagUser = '1' 
										AND c.mobileNo != '' 
										AND CHAR_LENGTH (c.mobileNo) >= 10
										GROUP BY c.mobileNo");
						$stmt->execute();
						$result 		= $stmt->get_result();
						$stmt->close();
						$arr 	= array();
						while($ax = $result->fetch_assoc()){ array_push($arr, $ax['mobileNo']); }

						$destination 	= implode(',',$arr);
						$find 			= array("%agentname%","%name%");
						$replace 		= array($agentname,$vesselname);
						$message 		= str_replace($find,$replace,$usr['text']);
						$message 		= html_entity_decode($message, ENT_QUOTES, 'utf-8'); 
						$message 		= urlencode($message);

						$fp = "http://www.isms.com.my/isms_send.php?un=&pwd=&dstno=$destination&msg=$message";
						ismscURL($fp);

					}
					if($do=="edit"){						
						$qEdit="UPDATE kod_kapal SET nama='$nama', namaSyarikat='$sykt', idJenisKapal='$type', IMO='$imo', ISSC='$issc', Flag='$flag', iso_3166_3='$iso', CallSign='$call', MMSI='$mmsi', GT='$gt', tarikhLuputISSC='$tarikhLuputISSC', ISSCAuthority='$ISSCAuthority', flagVerify='N',tarikhApply=NOW() WHERE idKapal='$id' AND idUserApply = '{$idUser}' AND flagVerify != 'Y'";		
						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;

						$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 UPDATED!";

					}
					if($do=="delete"){	
						foreach($_POST['myid'] as $value){						
							$qDelete="DELETE FROM kod_kapal WHERE idKapal='$value' AND idUserApply = '{$idUser}' AND flagVerify != 'Y'";	
							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($success){
					echo "<script>window.location.replace('index.php?page=kod/kodKapal_a&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">

					<form class="push form-horizontal" id="form-validation" action="index.php?page=kod/kodKapal_a" method="post" enctype="multipart/form-data" autocomplete="off">
						<!-- if delete. check post name delete -->

						<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="modal-body"><!-- modal-body -->

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-name">Vessel 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="Vessel 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="">- Please Choose -</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-sykt">Ship Owner <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-sykt" name="val-sykt" class="form-control validation" data-validation="default" placeholder="Ship Owner..">
							    </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="">- Please Choose -</option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$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-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_digit" placeholder="GT">
							    </div>
							</div>
							
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-issc">ISSC No <span class="text-danger issc-danger" style="display: none">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-issc" name="val-issc" class="form-control issc-validate" data-validation="default" placeholder="ISSC No..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-fail">Upload ISSC <span class="text-danger issc-danger" style="display: none">*</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" accept="<?php echo $conf_doctype2;?>">
									</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 issc-validate 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">
									<b>File Allowed: <?php echo $conf_doctype3;?></b>
									<br><b>(Max Size: <?echo $conf_maxuploadsize;?>MB)</b>
									</i>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="tarikhLuputISSC">ISSC Expiry Date <span class="text-danger issc-danger" style="display: none">*</span></label>
							    <div class="col-md-2">
							        <input type="text" id="tarikhLuputISSC" name="tarikhLuputISSC" value="<?php echo $tarikhLuputISSC;?>" class="form-control input-datepicker issc-validate" data-validation="default" data-date-format="dd-mm-yyyy" placeholder="dd-mm-yyyy">
							        <!-- 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 issc-danger" style="display: none">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="ISSCAuthority" name="ISSCAuthority" value="<?php echo $ISSCAuthority;?>" class="form-control issc-validate" data-validation="default" placeholder="ISSC Issuing Authority..">
							    </div>
							</div>
							<hr>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-flag">Country <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <select id="val-flag" name="val-flag" class="form-control validation select-select2" data-validation="default" data-placeholder="Type..">
		                                <option value="">- Please Choose -</option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$qType="SELECT iso_3166_3,nama FROM kod_negara 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['nama']?>" data-iso="<?=$rowType['iso_3166_3']?>"><?=$rowType['nama']?></option>
								<?}mysqli_free_result($resType)?>
									</select>
									<input type="hidden" name="val-iso">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-call">Call Sign <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="Call Sign..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-mmsi">MMSI</label>
							    <div class="col-md-6">
							        <input type="text" id="val-mmsi" name="val-mmsi" class="form-control" placeholder="MMSI..">
							    </div>
							</div>			
						</div><!-- [end] modal-body -->

						<input type="hidden" name="type_submit" value="add">
						<input type="hidden" name="val-id" value="">
						<input type="hidden" name="val-idx" value="">
						<input type="hidden" name="val-href" value="">

						<div class="modal-footer">
						<!-- <h4 class="pull-left">$ <strong class="text-primary-dark">689</strong><small>.00</small></h4> -->
						<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="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">
					<thead>
						<tr>
							<th style="width: 40px;" class="text-center no_sorting"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th class="text-center" style="width: 40px;">No</th>
							<th>VESSEL NAME</th>
							<th>SHIP OWNER</th>
							<th>TYPE</th>
							<th>ISSC</th>
							<th class="text-center" style="width: 70px;">ISSC EXPIRY DATE</th>
							<th class="text-center" style="width: 130px;">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'] = "Approved";
					// $labels['N']['class'] = "label-warning";
					// $labels['N']['text'] = "Pending";
					// $labels['T']['class'] = "label-danger";
					// $labels['T']['text'] = "Rejected";

					$labels['Y']['class'] = "label-success";
					$labels['Y']['text'] = "Verified";
					$labels['N']['class'] = "label-warning";
					$labels['N']['text'] = "Unverified";
					$labels['T']['class'] = "label-danger";
					$labels['T']['text'] = "Rejected";
					?>
					<?php 
						
						$qKod="SELECT *,IF(tarikhLuputISSC = '0000-00-00','',DATE_FORMAT(tarikhLuputISSC,'%d-%m-%Y')) AS tarikhLuputISSC FROM kod_kapal WHERE 1 AND idUserApply = '{$idUser}' ORDER BY FIELD(flagVerify,'T','N','Y')";
						$resKod=mysqli_query($mysqli_link, $qKod) or die(mysqli_connect_error());
						$bilx=1;
						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[namaSyarikat]|"
										."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-idx#".md5('fif'.$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_link1 	= "upload/vessel/{$rowKod['idKapal']}/{$rowKod['fail_issc']}";
						$file_link2 	= "reports/app_download.php?ii=".md5('fif'.$rowKod['idKapal'])."&zz=".$rowKod['fail_issc'];
					?>
						<tr>
							<td class="text-center">
								<?php echo pathinfo("a.sd.xx", PATHINFO_FILENAME); ?>
							<?php if($rowKod['flagVerify'] != 'Y'){ ?>
								<label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $rowKod['idKapal'];?>"><span></span></label>
							<?php } ?>
							</td>
							<td class="text-center"><?=$bilx++?></td>
							<td><strong><?=$rowKod['nama']?></strong></td>
							<td><?=$rowKod['namaSyarikat']?></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_link1)){
									$inpgrp = ($rowKod['flagVerify'] != 'Y') ? "input-group" : "" ;
							?>
								<div class="<?php echo $inpgrp; ?> donwload_main_<?php echo $rowKod['idKapal'];?>" data-toggle="tooltip" title="ISSC File">
								<a href="<?php echo $file_link2;?>" 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>
								<?php if($rowKod['flagVerify'] != 'Y'){ ?>
								<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>
								<?php } ?>
								</div>
							<?php 
								}else{
									echo '<span class="label label-warning">None</span>';
								}
							?>
							</td>
							<?php $rand = $rowKod['flagVerify'] ?>
							<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">
							<?php if($rowKod['flagVerify'] != '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 $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>
							<?php }else{ /*echo "<a title='Edit Record' class='btn btn-effect-ripple btn-xs btn-success disabled' ><i class='fa fa-pencil'></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(){

        	$("#example-datatable").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");
				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");
					}
				});

				$("#val-gt").trigger("change");
			});

			$(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 t_idx 		= $("[name='val-idx']",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",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");
					}
				});

				$("#val-gt").trigger("change");
				$("select#val-flag").trigger("change");
			});

        	$("[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 = doc_allowed1; //array of valid extensions
				var fileName = $(this).val().toLowerCase();
				var fileNameExt = fileName.substr(fileName.lastIndexOf('.') + 1);

				const fileSize = this.files[0].size / 1024 / 1024; // in MiB

				if ($.inArray(fileNameExt, validExtensions) == -1){
					alert("Invalid file type");
					$(this).val("");
        			$(".btn",up3).removeClass("disabled").addClass("disabled");
					return false;
				}else if (fileSize.toFixed(1)>doc_maxsize1){
					alert("Allowed Max Size: "+doc_maxsize1+"MB");
					$(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");
				}
			});

			$("#val-gt").on("change",function(){
				if($(this).val()==='')
					$(this).prop("value",0).val(0);

				if($(this).val()<5000){
					$(".issc-validate").removeClass("validation");
					$("#form-validation").clearvalidation();
					$("#form-validation").setvalidation2();
					$(".issc-danger").hide();
				}else{
					if(!$(".issc-validate").hasClass("validation"))
						$(".issc-validate").addClass("validation");
					$("#form-validation").clearvalidation();
					$("#form-validation").setvalidation2();
					$(".issc-danger").show();
				}
			});

			$("select#val-flag").on("change",function(){
				$("[name='val-iso']").val($(":selected",this).data("iso"))
			});

        });

        </script>

	</div>