Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission	Action
Auto Save Session.sublime_sess...	31.97 KB	-rw-rw-rw-
Session.sublime_session	99.12 KB	-rw-rw-rw-

Code Editor : Session.sublime_session

{
	"folder_history":
	[
		"/C/xampp7/htdocs/edgpens"
	],
	"last_version": 3211,
	"last_window_id": 2,
	"log_indexing": false,
	"settings":
	{
		"new_window_height": 480.0,
		"new_window_settings":
		{
			"auto_complete":
			{
				"selected_items":
				[
				]
			},
			"build_system_choices":
			[
			],
			"build_varint": "",
			"command_palette":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"console":
			{
				"height": 0.0,
				"history":
				[
				]
			},
			"distraction_free":
			{
				"menu_visible": true,
				"show_minimap": false,
				"show_open_files": false,
				"show_tabs": false,
				"side_bar_visible": false,
				"status_bar_visible": false
			},
			"file_history":
			[
				"/C/xampp7/htdocs/edgpens/inc/template_scripts_200430.php"
			],
			"find":
			{
				"height": 39.0
			},
			"find_in_files":
			{
				"height": 0.0,
				"where_history":
				[
				]
			},
			"find_state":
			{
				"case_sensitive": false,
				"find_history":
				[
				],
				"highlight": true,
				"in_selection": false,
				"preserve_case": false,
				"regex": false,
				"replace_history":
				[
				],
				"reverse": false,
				"show_context": true,
				"use_buffer2": true,
				"whole_word": false,
				"wrap": true
			},
			"incremental_find":
			{
				"height": 27.0
			},
			"input":
			{
				"height": 0.0
			},
			"menu_visible": true,
			"output.find_results":
			{
				"height": 0.0
			},
			"pinned_build_system": "",
			"replace":
			{
				"height": 50.0
			},
			"save_all_on_build": true,
			"select_file":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"select_project":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"select_symbol":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"show_minimap": true,
			"show_open_files": false,
			"show_tabs": true,
			"side_bar_visible": true,
			"side_bar_width": 150.0,
			"status_bar_visible": true,
			"template_settings":
			{
			}
		},
		"new_window_width": 640.0
	},
	"windows":
	[
		{
			"auto_complete":
			{
				"selected_items":
				[
				]
			},
			"buffers":
			[
				{
					"file": "/C/xampp7/htdocs/edgpens/utility/userList.php",
					"settings":
					{
						"buffer_size": 27995,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/utility/change_pass.php",
					"settings":
					{
						"buffer_size": 11929,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/edg/site.php",
					"settings":
					{
						"buffer_size": 18876,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/vendor/phpmailer/phpmailer/get_oauth_token.php",
					"settings":
					{
						"buffer_size": 4947,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"contents": "<?php \n\terror_reporting(1);\n\tdate_default_timezone_set('Asia/Kuala_Lumpur');\n\n\t$GLOBALS['mysqli'] = new mysqli(\"172.16.0.67\", \"edgpens\", \"\t\t\", \"edgpens\");\n\tif ($mysqli->connect_errno) {\n\t\techo \"Failed to connect to MySQL: (\" . $mysqli_link->connect_errno . \") \" . $mysqli_link->connect_error;\n\t\texit();\n\t}\n\n\t$mysqli_link = new mysqli(\"172.16.0.67\", \"edgpens\", \"c6IRnSzhF87XFGtE\", \"edgpens\");\n\tif ($mysqli_link->connect_errno) {\n\t\techo \"Failed to connect to MySQL: (\" . $mysqli_link->connect_errno . \") \" . $mysqli_link->connect_error;\n\t}\n\n\t$svr_http \t= isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on'? \"https://\" : \"http://\";\n\t$svr_port \t= isset($_SERVER['SERVER_PORT']) && $_SERVER['SERVER_PORT'] == '80'? \"\" : \":\".$_SERVER['SERVER_PORT'];\n\t$stmt \t\t= $mysqli->stmt_init();\n\t$stmt->prepare(\"SELECT a.*,\n\t\t\t\t\t\tb.username sms_username,\n\t\t\t\t\t\tb.password sms_password,\n\t\t\t\t\t\tb.sendid sms_sendid \n\t\t\t\t\tFROM \n\t\t\t\t\t\tutiliti_web_config a \n\t\t\t\t\tCROSS JOIN utiliti_sms b\");\n\t$stmt->execute();\n\t$result \t= $stmt->get_result();\n\t$stmt->close();\n\t$aa = $result->fetch_assoc();\n\t$GLOBALS['conf_fullname'] \t\t= $aa['fullname'];\n\t$GLOBALS['conf_shortname'] \t\t= $aa['shortname'];\n\t$GLOBALS['conf_maxuploadsize'] \t= $aa['maxuploadsize'];\n\t$GLOBALS['conf_weblink'] \t\t= $aa['weblink'];\n\t$GLOBALS['conf_fullweblink'] \t= (substr($conf_weblink,0,4)==\"http\") ? $conf_weblink : $svr_http.$_SERVER[\"SERVER_NAME\"].$svr_port.$aa['weblink'];\n\t$GLOBALS['conf_log_attempt'] \t= $aa['log_attempt'];\n\t$GLOBALS['conf_sess_timeout'] \t= $aa['sess_timeout'];\n\t$GLOBALS['conf_pass_min'] \t\t= $aa['pass_min'];\n\t$GLOBALS['conf_pass_max'] \t\t= $aa['pass_max'];\n\t$GLOBALS['conf_pass_digit'] \t= ($aa['pass_digit']==1) ? 'true' : 'false';\n\t$GLOBALS['conf_pass_symbol'] \t= ($aa['pass_symbol']==1) ? 'true' : 'false';\n\t$GLOBALS['conf_pass_upcase'] \t= ($aa['pass_upcase']==1) ? 'true' : 'false';\n\t$GLOBALS['conf_pass_locase'] \t= ($aa['pass_locase']==1) ? 'true' : 'false';\n\t$GLOBALS['conf_pass_expired'] \t= $aa['pass_expired'];\n\t$GLOBALS['conf_pass_text'] \t\t= $aa['pass_text'];\n\t$GLOBALS['conf_sms_username'] \t= $aa['sms_username'];\n\t$GLOBALS['conf_sms_password'] \t= $aa['sms_password'];\n\t$GLOBALS['conf_sms_sendid'] \t= $aa['sms_sendid'];\n\tunset($result);\n\tunset($aa);\n\n\t$stmt \t\t= $mysqli->stmt_init();\n\t$stmt->prepare(\"SELECT * FROM kod_doctype WHERE flagAktif='Y'\");\n\t$stmt->execute();\n\t$result \t= $stmt->get_result();\n\t$stmt->close();\n\t$conf_doctype1 \t= array();\n\t$conf_doctype2 \t= \"\";\n\t$conf_doctype3 \t= \"\";\n\t$conf_doctype4 \t= array();\n\t$GLOBALS['conf_doctype5'] \t= array();\n\n\twhile($aa = $result->fetch_assoc()){ \n\t\tarray_push($conf_doctype1, $aa['doctype']); \n\t\t$conf_doctype2.=' .'.$aa['doctype'].','; \n\t\t$conf_doctype3.=' *.'.$aa['doctype'].','; \n\t\tarray_push($conf_doctype4, '.'.$aa['doctype']);\n\t\t$conf_doctype5[$aa['doctype']]=$aa['mime'];\n\t}\n\t$conf_doctype2 \t= substr($conf_doctype2,1,-1);\n\t$conf_doctype3 \t= substr($conf_doctype3,1,-1);\n\tunset($result);\n\tunset($aa);\n\n\t//----------------------------------------------------------------------------------\n\t// Delete a session and return.\n\t//----------------------------------------------------------------------------------\n\tfunction deleteSession($session){\n\n\t\tglobal $mysqli;\n\t\t// $query=\"DELETE FROM utiliti_session WHERE iduser!=1 AND session = '$session'\";\n\t\t$query=\"DELETE FROM utiliti_session WHERE session = '$session'\";\n\t\t$mysqli->query($query);\n\n\t\treturn;\n\t}\n\n\n\t//----------------------------------------------------------------------------------\n\t// Update session time if it exists.\n\t//----------------------------------------------------------------------------------\n\tfunction updateSession($session){\n\n\t\tglobal $mysqli;\n\t\tcheckSession();\n\n\t\t$query=\"SELECT * FROM utiliti_session WHERE session='$session'\";\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\tif($row){\n\t\t\t$time=getdate(time());\n\t\t\t$s=\"update utiliti_session set masa='\".$time['year'].\"-\".$time['mon'].\"-\".$time['mday'].\" \".$time['hours'].\":\".$time['minutes'].\":\".$time['seconds'].\"' where session='$session'\";\n\t\t\tif(!$r=$mysqli->query($s)) echo $s.\"<br>Fail to updating the session \".$r;\n\n\t\t}else{\n\t\t\t$session=false;\n\t\t}\n\n\t\treturn $session;\n\t}\n\n\n\t//----------------------------------------------------------------------------------\n\t// Log user in. If user already has a session then security risk. Throw them out.\n\t//----------------------------------------------------------------------------------\n\tfunction login($passedusername,$passedpassword){\n\n\t\tglobal $mysqli, $conf_log_attempt;\n\t\tcheckSession();\n\t\t$passedpassword= md5($passedpassword);\n\n\t\t// $query=\"SELECT * FROM utiliti_user WHERE up_id='$passedusername'\";\n\t\t// $result=$mysqli->query($query) or die(mysqli_error($mysqli));\n\n\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t$stmt->prepare(\"SELECT * FROM user_list WHERE emailUser=?\");\n\t\t// $stmt->prepare(\"SELECT * FROM user_list\");\n\t\t$emailUser \t\t= $passedusername;\n\t\t$stmt->bind_param(\"s\",$emailUser);\n\t\t$stmt->execute();\n\t\t$result \t\t= $stmt->get_result();\n\t\t$stmt->close();\n\n\t\t$session \t= array();\n\t\t$row \t\t= $result->fetch_assoc();\n\t\t$usertype \t= 1;\n\n\t\tif(!$row){ // utk user yang belum ada dalam user_list\n\t\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t\t$stmt->prepare(\"SELECT * FROM user_register WHERE emailUser=? AND flagUser=2 AND status=1\");\n\t\t\t$emailUser \t\t= $passedusername;\n\t\t\t$stmt->bind_param(\"s\",$emailUser);\n\t\t\t$stmt->execute();\n\t\t\t$result \t\t= $stmt->get_result();\n\t\t\t$stmt->close();\n\n\t\t\t$session \t= array();\n\t\t\t$row \t\t= $result->fetch_assoc();\n\t\t\t$usertype \t= 2;\n\t\t}\n\n\t\tunset($result);\n\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t$stmt->prepare(\"SELECT * FROM utiliti_login WHERE idUser=? AND user_type=? AND attempt_date=CURDATE()\");\n\t\t$idUser \t\t= $row['idUser'];\n\t\t$user_type \t\t= $usertype;\n\t\t$stmt->bind_param(\"ss\",$idUser,$user_type);\n\t\t$stmt->execute();\n\t\t$result \t\t= $stmt->get_result();\n\t\t$stmt->close();\n\t\t$ulogin \t\t= $result->fetch_assoc();\n\t\t$uid \t\t\t= $ulogin['id'];\n\t\t$ucnt \t\t\t= ($ulogin) ? $ulogin['attempt_count'] : 0;\n\n\t\tif($ucnt < $conf_log_attempt){\n\t\t\tif($row){\n\n\t\t\t\t$userid \t= $row['idUser'];\n\t\t\t\t$nama \t\t= strtoupper($row['nameUser']);\n\t\t\t\t$password \t= $row['passwordUser'];\n\t\t\t\t$trkMula \t= $row['date_start'];\n\t\t\t\t$trkTamat \t= $row['date_end'];\n\t\t\t\t$flagUser \t= ($usertype==2) ? 1 : $row['flagUser'] ;\n\n\t\t\t\tif($password==$passedpassword){\n\t\t\t\t\tif($flagUser == 3){\n\t\t\t\t\t\t$session[0] \t= \"Ops! Something Wrong.<br>Please Contact System Administrators.\";\n\t\t\t\t\t\t$session[1] \t= false;\n\t\t\t\t\t\t$session[3] \t= 1;\n\t\t\t\t\t}else if($flagUser == 2){\n\t\t\t\t\t\t$session[0] \t= \"Ops! Your Login Have Been Blocked.<br>Please Contact System Administrators.\";\n\t\t\t\t\t\t$session[1] \t= false;\n\t\t\t\t\t\t$session[3] \t= 1;\n\t\t\t\t\t// }if(empty($trkMula)){\n\t\t\t\t\t// \t$session[0] \t= \"Ops! Something Wrong.<br>Please Contact System Administrators.\";\n\t\t\t\t\t// \t$session[1] \t= false;\n\t\t\t\t\t// \t$session[3] \t= 1;\n\t\t\t\t\t// }else if ($trkTamat!='' And $trkTamat<>'0000-00-00' And $trkTamat<date(\"Y-m-d\")){\n\t\t\t\t\t// \t$t=strtotime ($trkTamat);\n\t\t\t\t\t// \t$session[0] \t= \"You Cannot Enter This System Anymore. Started From \".date(\"d-M-Y\",$t);\n\t\t\t\t\t// \t$session[1] \t= false;\n\t\t\t\t\t// \t$session[3] \t= 1;\n\t\t\t\t\t// }else if ( $trkMula>date(\"Y-m-d\")){\n\t\t\t\t\t// \t$t=strtotime ($trkMula);\n\t\t\t\t\t// \t$session[0] \t= \"You Can Access This System Start From \".date(\"d-M-Y\",$t);\n\t\t\t\t\t// \t$session[1] \t= false;\n\t\t\t\t\t// \t$session[3] \t= 1;\n\t\t\t\t\t}else {//ok to proceed.\n\t\t\t\t\t\tlog_attempts($idUser,$user_type,2,$uid); // clear count for today\n\t\t\t\t\t\t$session[0]\t\t= \"Welcome Back. {$nama}\";\n\t\t\t\t\t\t$session[1]\t\t= checkUser($userid,$usertype); //check to see if user is already logged in\n\t\t\t\t\t\t$session[3] \t= 0;\n\n\t\t\t\t\t\tif ($session[1]){\n\t\t\t\t\t\t\tdeleteSession($session[1]);//Force the user out if already logged in\n\t\t\t\t\t\t\t$session[1]=setSession($userid,$usertype);\n\t\t\t\t\t\t}else{\n\t\t\t\t\t\t\t$session[1]=setSession($userid,$usertype);\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}else{\n\t\t\t\t\tlog_attempts($idUser,$user_type,1,$uid);\n\t\t\t\t\t$ucntreal \t\t= $conf_log_attempt-($ucnt+1);\n\n\t\t\t\t\tif($ucntreal==0){\n\t\t\t\t\t\tif($usertype==2)\n\t\t\t\t\t\t\t$session[0] \t= \"Too Many Attempts. Account Locked For Today! <hr>You Can Try Unlock It With <br>Forgot Password\";\n\t\t\t\t\t\telse\n\t\t\t\t\t\t\t$session[0] \t= \"Too Many Attempts. Account Locked For Today! <hr>You Can Try Unlock It With <br>Forgot Password / Contact The Admins\";\n\t\t\t\t\t}else{\n\t\t\t\t\t\t$session[0] \t= \"Please Try Again! <hr>You Got <b>{$ucntreal}</b> More Attempt/s Left Before The Account Get Locked.\";\n\t\t\t\t\t}\n\n\t\t\t\t\t$session[1] \t= false;\n\t\t\t\t\t$session[3] \t= 1;\n\t\t\t\t}\n\t\t\t}else{\n\t\t\t\t$session[0] \t= \"Please Try Again!\";\n\t\t\t\t$session[1] \t= false;\n\t\t\t\t$session[3] \t= 1;\n\t\t\t}\n\t\t}else{\n\n\t\t\tif($usertype==2)\n\t\t\t\t$session[0] \t= \"Too Many Attempts. Account Locked For Today! <hr>You Can Try Unlock It With <br>Forgot Password\";\n\t\t\telse\n\t\t\t\t$session[0] \t= \"Too Many Attempts. Account Locked For Today! <hr>You Can Try Unlock It With <br>Forgot Password / Contact The Admins\";\n\n\t\t\t$session[1] \t= false;\n\t\t\t$session[3] \t= 1;\n\t\t}\n\n\t\treturn $session;\n\t}\n\n\tfunction log_attempts($iduser,$usertype,$log_type,$uid = 0,$unlock_iduser = 0){\n\n\t\tglobal $mysqli;\n\t\t$stmt \t= $mysqli->stmt_init();\n\n\t\tif($log_type==1){ \n\t\t// locked\n\t\t\tif(!empty($uid)){ \n\t\t\t// update\n\t\t\t\t$stmt->prepare(\"UPDATE utiliti_login SET attempt_count=attempt_count+1 WHERE id='{$uid}'\");\n\t\t\t\t$stmt->execute();\n\t\t\t}else{ \n\t\t\t// insert\n\t\t\t\t$stmt->prepare(\"INSERT INTO utiliti_login \n\t\t\t\t\t\t\t\t(idUser,user_type,attempt_date,attempt_count) \n\t\t\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t\t\t('{$iduser}','{$usertype}',NOW(),1) \");\n\t\t\t\t$stmt->execute();\n\t\t\t}\n\t\t}else{ \n\t\t// unlocked\n\t\t\tif(!empty($uid)){ \n\t\t\t\t$stmt->prepare(\"UPDATE utiliti_login SET attempt_count=0 WHERE id='{$uid}'\");\n\t\t\t\t$stmt->execute();\n\t\t\t}else{\n\t\t\t\tif($unlock_iduser==0){\n\t\t\t\t\t$stmt->prepare(\"UPDATE utiliti_login \n\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\tattempt_count=0\n\t\t\t\t\t\t\t\t\tWHERE idUser='{$iduser}' \n\t\t\t\t\t\t\t\t\tAND user_type='{$usertype}' \n\t\t\t\t\t\t\t\t\tAND attempt_date=CURDATE() \");\n\t\t\t\t}else{\n\t\t\t\t\t$stmt->prepare(\"UPDATE utiliti_login \n\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\tattempt_count=0, \n\t\t\t\t\t\t\t\t\t\tunlock_idUser='{$unlock_iduser}', \n\t\t\t\t\t\t\t\t\t\tunlock_date=CURDATE() \n\t\t\t\t\t\t\t\t\tWHERE idUser='{$iduser}' \n\t\t\t\t\t\t\t\t\tAND user_type='{$usertype}' \n\t\t\t\t\t\t\t\t\tAND attempt_date=CURDATE() \");\n\t\t\t\t}\n\t\t\t\t$stmt->execute();\n\t\t\t}\n\t\t}\n\n\t}\n\n\t//----------------------------------------------------------------------------------\n\t// Set a session and insert session into session table.\n\t//----------------------------------------------------------------------------------\n\tfunction setSession($userid,$usertype){\n\n\t\tglobal $mysqli;\n\t\t$time=getdate(time());\n\n\t\t$length=80;// set this to the length of session variable desired\n\t\t$session=\"\";\n\t\tmt_srand(time());\n\t\t$sessionstring=\"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789\";\n\n\t\t$achar=strlen($sessionstring)-1;\n\n\t\tfor ($i=0;$i<$length;$i++){\n\t\t\t$session.=$sessionstring[mt_rand(0,$achar)];\n\t\t}\n\t\t$session=$userid.$session;\n\n\t\t$query = \"INSERT INTO utiliti_session (session,idUser,masa,usertype) VALUES \t('$session','$userid','\".$time['year'].\"-\".$time['mon'].\"-\".$time['mday'].\" \".$time['hours'].\":\".$time['minutes'].\":\".$time['seconds'].\"',$usertype)\";\n\t\t$mysqli->query($query) or die(mysqli_error($mysqli));\n\n\t\treturn $session;\n\t}\n\n\n\t//--------------------------------------------------------------------------------\n\t// Check the user to see if they are already logged in.\n\t//--------------------------------------------------------------------------------\n\tfunction checkUser($userid,$usertype){\n\n\t\tglobal $mysqli;\n\t\t$query=\"SELECT * FROM utiliti_session WHERE idUser = '$userid' AND usertype = '$usertype'\";\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\tif ($row){\n\t\t\t$session=$row['session'];\n\t\t}else{\n\t\t\t$session = false;\n\t\t}\n\n\t\treturn $session;\n\t}\n\n\n\t//----------------------------------------------------------------------------------\n\t// Log the user out when they click on the log-out button\n\t//----------------------------------------------------------------------------------\n\tfunction logout($session){\n\n\t\tglobal $mysqli;\n\n\t\t$query=\"SELECT * FROM utiliti_session WHERE session = '$session'\";\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\tif ($row){\n\t\t\t$userid=$row['idUser'];\n\t\t\tdeleteSession($session);\n\t\t\treturn true;\n\t\t}else{\n\t\t\treturn false;\n\t\t}\n\t}\n\n\t//----------------------------------------------------------------------------------\n\t// Check session and return.\n\t//----------------------------------------------------------------------------------\n\tfunction checkSession(){\n\n\t\tglobal $mysqli, $conf_sess_timeout;\n\t\t$expirationtime=time()-($conf_sess_timeout*60); // set this to seconds of inactivity before forced logout (30mins)\n\t//\t$expirationtime=time()-6000; // set this to seconds of inactivity before forced logout (100mins)\n\n\t\t// $usr \t\t= get_user($sess);\n\t\t// $usertype \t= $usr['usertype'];\n\t\t// $cond \t\t= \" AND usertype='{$usertype}' \"; \n\n\t\t$time=getdate($expirationtime);\n\n\t\t$query = \"SELECT idUser,session,masa From utiliti_session WHERE masa < '\".$time['year'].\"-\".$time['mon'].\"-\".$time['mday'].\" \".$time['hours'].\":\".$time['minutes'].\":\".$time['seconds'].\"' \";\n\t\t$result=$mysqli->query($query) or die(mysqli_error($mysqli));\n\n\t\twhile($row=$result->fetch_assoc()){\n\t\t\tdeleteSession($row['session']);\n\t\t}\n\n\t\treturn;\n\t}\n\n    function growl_me($sess = null,$g_scc){\n        $type   = $g_scc;\n        $msg    = (!empty($sess)) ? $sess['success_msg'] : \"\";\n        if($g_scc == 1 && !empty($sess['success_msg'])){\n            echo \"<script>$(document).ready(function(){ $.testme({$type},\\\"{$msg}\\\"); });</script>\";\n        }\n        if($g_scc == 2 && !empty($sess['success_msg'])){\n            echo \"<script>$(document).ready(function(){ $.testme({$type},\\\"{$msg}\\\"); });</script>\";\n        }\n        if($g_scc == 3 && !empty($sess['success_msg'])){\n            echo \"<script>$(document).ready(function(){ $.testme({$type},\\\"{$msg}\\\"); });</script>\";\n        }\n    }\n\n    function get_user($sess){\n\n\t\tglobal $mysqli;\n\t\t$query=\"SELECT * FROM utiliti_session WHERE session='$sess'\";\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\t// $stmt->prepare(\"SELECT * FROM utiliti_session WHERE session=?\");\n\t\t// $running_sql \t= $sess;\n\t\t// $stmt->bind_param(\"s\",$iduser,$running_sql,$descr);\n\t\t// $stmt->execute();\n\t\t// $result = $stmt->get_result();\n\t\t// $row \t= $result->fetch_assoc(MYSQLI_ASSOC);\n\t\t// $stmt->close();\n\t\treturn $row;\n    }\n\n\n    function get_user_full($sess){\n\n\t\tglobal $mysqli;\n\t\t$query=\"SELECT * FROM utiliti_session WHERE session='$sess'\";\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\tif($row['usertype']==1){\n\t\t\t$table \t= \"user_list\";\n\t\t\t$query=\"SELECT \n\t\t\t\t\t\ta.*,\n\t\t\t\t\t\tif(DATE_FORMAT(NOW(),'%Y-%m-%d') >= DATE_FORMAT(date_add(a.datePassword, INTERVAL b.pass_expired day),'%Y-%m-%d'),'Y','N') pass_exp \n\t\t\t\t\tFROM {$table} a \n\t\t\t\t\tcross join utiliti_web_config b\n\t\t\t\t\tWHERE a.idUser='{$row['idUser']}'\";\n\t\t}\n\t\telse{\n\t\t\t$table \t= \"user_register\";\n\t\t\t$query=\"SELECT \n\t\t\t\t\t\ta.*,\n\t\t\t\t\t\t'N' pass_exp\n\t\t\t\t\tFROM {$table} a \n\t\t\t\t\tcross join utiliti_web_config b\n\t\t\t\t\tWHERE a.idUser='{$row['idUser']}'\";\n\t\t}\n\t\t$result=$mysqli->query($query);\n\t\t$row=$result->fetch_assoc();\n\n\t\treturn $row;\n    }\n    \n\tfunction mysqli_prepare_audit($sql,$param_type,$param_data,$param_do = null,$query_type = null){\n\t\t/*\t\n\t\t\tHamdi : 2020-03-20\n\t\t\tThis Function Only for Insert/Update/Delete use.\n\t\t*/\n\t\tglobal $mysqli;\n\t\t$user \t\t\t= get_user($_SESSION['session']);\n\t\t$conn \t\t\t= $mysqli;\n\t\t$stmt  \t\t\t= $conn->stmt_init();\n\t\t$stmt->prepare($sql);\n\t\t$comb_param \t= \"\";\n\t\t$length_type \t= strlen($param_type);\n\t\t$length_data\t= count($param_data);\n\t\t$type_auto \t\t= \"\";\n\n\t\tforeach ($param_data as $a => $b) {\n\t\t\t$comb_param1 \t.= \"\\${$a}=\\\"{$b}\\\",\";\n\t\t\t$comb_param2 \t.= \"\\${$a}=\\\"{$b}\\\",\\n\";\n\t\t\t$type_auto \t\t.= \"s\";\n\t\t}\n\n\t\tif($length_type != $length_data || $param_type == 'auto')\n\t\t\t$param_type \t= $type_auto;\n\n\t\t$data \t\t\t= array();\n\t\t$comb_param1 \t= substr($comb_param1, 0, -1);\n\t\t$comb_param2 \t= $sql.\";\\n\".substr($comb_param2, 0, -2);\n\t\t\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\";\n\t\teval(\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\");\n\n\t\tif (!$stmt->execute()) {\n    \t\techo 'error executing statement: ' . $stmt->error;\n\t\t\t$stmt->close();\n\t\t}else{\n\t\t\t$data[0] \t= $mysqli->insert_id;\n\t\t\t$stmt->close();\n\t\t\taudit_insert($comb_param2,$param_do);\n\t\t}\n\n\t\treturn $data;\n\t}\n\n\tfunction mysqli_prepare_all($sql,$param_type,$param_data){\n\t\t/*\t\n\t\t\tHamdi : 2020-12-07\n\t\t\tThis Function for All Query.\n\t\t*/\n\t\tglobal $mysqli;\n\t\t// $user \t\t\t= get_user($_SESSION['session']);\n\t\t$conn \t\t\t= $mysqli;\n\t\t$stmt  \t\t\t= $conn->stmt_init();\n\t\t$stmt->prepare($sql);\n\t\t$comb_param \t= \"\";\n\t\t$length_type \t= strlen($param_type);\n\t\t$length_data\t= count($param_data);\n\t\t$type_auto \t\t= \"\";\n\n\t\tforeach ($param_data as $a => $b) {\n\t\t\t$comb_param1 \t.= \"\\${$a}=\\\"{$b}\\\",\";\n\t\t\t$comb_param2 \t.= \"\\${$a}=\\\"{$b}\\\",\\n\";\n\t\t\t$type_auto \t\t.= \"s\";\n\t\t}\n\n\t\tif($length_type != $length_data || $param_type == 'auto')\n\t\t\t$param_type \t= $type_auto;\n\n\t\t$data \t\t\t= array();\n\t\t$comb_param1 \t= substr($comb_param1, 0, -1);\n\t\t$comb_param2 \t= $sql.\";\\n\".substr($comb_param2, 0, -2);\n\t\t\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\";\n\t\teval(\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\");\n\n\t\t$stmt->execute() or trigger_error($stmt->error, E_USER_ERROR);\n\t\t($result = $stmt->get_result()) or trigger_error($stmt->error, E_USER_ERROR);\n \t\t$stmt->close();\n\n\t\treturn $result;\n\t}\n\n\tfunction audit_insert($running_sql,$descr = null){\n\n\t\tglobal $mysqli;\n\n\t\tif(!empty($_SESSION['session']))\n\t\t\t$user \t\t= get_user($_SESSION['session']);\n\t\telse\n\t\t\t$user \t\t= \"\";\n\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t$stmt->prepare(\"insert into audit_trail (idUser,running_sql,descr) values (?,?,?)\");\n\t\t$iduser \t\t= $user['idUser'];\n\t\t// $running_sql \t= $comb_param2;\n\t\t$descr \t\t\t= (empty($descr)) ? '' : $descr ;\n\t\t$stmt->bind_param(\"sss\",$iduser,$running_sql,$descr);\n\t\t$stmt->execute();\n\t\t$stmt->close();\n\t}\n\n\tfunction mysql_date($date){\n\t\texplode('-', $date);\n\t\treturn $date[3].\"-\".$date[2].\"-\".$date[1];\n\t}\n\n\t// function mysqli_prepare_audit2(){\n\n\n\t// \tglobal $mysqli;\n\t// \t$stmt  \t\t\t= $mysqli->stmt_init();\n\t// \t$stmt->prepare($sql);\n\t// \t$comb_param \t= \"\";\n\t// \t$length_type \t= strlen($param_type);\n\t// \t$length_data\t= count($param_data);\n\t// \t$type_auto \t\t= \"\";\n\n\t// \tforeach ($param_data as $a => $b) {\n\t// \t\t$comb_param1 \t.= \"\\${$a}=\\\"{$b}\\\",\";\n\t// \t\t$comb_param2 \t.= \"\\${$a}=\\\"{$b}\\\",\\n\";\n\t// \t\t$type_auto \t\t.= \"s\";\n\t// \t}\n\n\t// \tif($length_type != $length_data || $param_type == 'auto')\n\t// \t\t$param_type \t= $type_auto;\n\n\t// \t$data \t\t\t= array();\n\t// \t$comb_param1 \t= substr($comb_param1, 0, -1);\n\t// \t$comb_param2 \t= $sql.\";\\n\".substr($comb_param2, 0, -2);\n\t// \t\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\";\n\t// \teval(\"\\$stmt->bind_param(\\\"\".$param_type.\"\\\",\".$comb_param1.\");\");\n\n\t// \t$stmt->execute();\n\n\t// \t// execute the stored Procedure\n\t// \t$result = $connect->query('call IsUserPresent(@uid, @userCount)');\n\n\t// \t// getting the value of the OUT parameter\n\t// \t$r = $connect->query('SELECT @userCount as userCount');\n\t// \t$row = $r->fetch_assoc(); \n\n\t// }\n\n\tfunction test_loop($id){\n\t\t// $s2=\"SELECT * from user_list\";\n\t\t\t\n  //           $stmt = $mysqli->prepare($s2);\n\t\t// \t$stmt->bind_param(\"s\",$id);\n\t\t//     $stmt->execute();\n\t\t//     $result = $stmt->get_result();\n\t\t// $stmt->close();\n\n\t\t// echo    $jum = $stmt->num_rows;\n\t\t// echo $id;\n\t\t// echo \"<br>\";\n\t\t// global $mysqli;\n\t\t// \t\t$s2=\"SELECT * from user_list where idUser = 1\";\n\t\t\t\n  //           $stmt = $mysqli->prepare($s2);\n\t\t// \t$stmt->bind_param(\"s\",$id);\n\t\t//     $stmt->execute();\n\t\t//     $result = $stmt->get_result();\n\t\t// echo    $jum = $result->num_rows;\n\t\t// $stmt->close();\n// print_r($result);\n\t\t// $sql \t\t\t= \"SELECT lokasi,tujuan,flaglulus,catatan FROM tugasluar WHERE (idPekerja=? AND (? BETWEEN tarikhMula AND tarikhTamat))\";\n\t\t// $param_data \t= array(\n\t\t// \t\t\t\t\t\"idPekerja\" \t=> $idPekerja,\n\t\t// \t\t\t\t\t\"tarikhUrusan\" \t=> $tarikhUrusan,\n\t\t// \t\t\t\t \t);\n\t\t// $result \t\t= mysqli_prepare_all($sql,\"auto\",$param_data);\n\t\t// echo $result->num_rows;\n\n\t\t// $sql \t\t\t= \"SELECT * FROM user_list WHERE (idUser=? AND (? BETWEEN dateCreated AND dateModified))\";\n\t\t$sql \t\t\t= \"SELECT * FROM user_list WHERE idUser=? \";\n\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\"idUser\" \t=> $id\n\t\t\t\t\t\t \t);\n\t\t$result \t\t= mysqli_prepare_all($sql,\"auto\",$param_data);\n\t\techo $result->num_rows;\n\t\t// $zsd = ;\n\t\tprint_r($result->fetch_assoc());\n\t\t// echo $zsd['emailUser'];\n\t\t// print_r();\n\t}\n\t\n\tfunction ismscURL($link,$again = null){//hamdi\n\n\t \t/* HARD CODE NO IJAN */\n\n\t \t// $search \t= \"/(&dstno=)(.*)(&msg)/\";\n\t\t// $replace \t= \"&dstno=0199160201&msg\";\n\t\t// $link  \t\t= preg_replace($search,$replace,$link);\n\n\t\t/* END HARD CODE */\n\n\t\t/* \n\t\t\t[2019-05-23] \n\t\t\tTUKAR USERNAME DAN PASSWORD ISMS \n\t\t\tPerubahan API iSMS\n\t\t*/\n\t\tglobal \n\t\t\t$conf_sms_username,\n\t\t\t$conf_sms_password,\n\t\t\t$conf_sms_sendid;\n\t\t// $username \t= urlencode(\"fifwaysms\");\n\t\t// $password \t= urlencode(\"f1fw4y123\");\n\n\t\t$username \t= urlencode($conf_sms_username);\n\t\t$password \t= urlencode($conf_sms_password);\n\n\t\t$link_old \t= $link;\n\t \t$search \t= \"/(http:)(.*)(&dstno)/\";\n\t \tif(!empty($again))\n\t \t\t$replace \t= \"http://www.isms.com.my/isms_send.php?un=$username&pwd=$password&dstno\";\n\t \telse\n\t \t\t$replace \t= \"https://www.isms.com.my/isms_send.php?un=$username&pwd=$password&dstno\";\n\t\t$link  \t\t= preg_replace($search,$replace,$link);\n\t\t$link \t\t.= \"&type=1&sendid={$conf_sms_sendid}&agreedterm=YES\";\n\t\t/* END TUKAR */\n\t\t\n\t\t$http = curl_init($link);\n\n\t\tcurl_setopt($http, CURLOPT_RETURNTRANSFER, TRUE);\n\t\t$http_result = curl_exec($http);\n\t\t$http_status = curl_getinfo($http, CURLINFO_HTTP_CODE);\n\t\tcurl_close($http);\n\n\t\tif($http_result == \"2000 = SUCCESS\"){\n\t\t\t$http_result \t= \"SMS Telah Berjaya Dihantar\";\n\t\t}\n\t\telse{\n\t\t\tif(empty($again))\n\t\t\t\tismscURL($link_old,\"http\");\n\t\t}\n\n\t\treturn $http_result;\n\t}\n\n\tfunction checkupload($files){\n\n\t\t$conf_maxuploadsize \t= $GLOBALS['conf_maxuploadsize'];\n\t\ttry {\n\n\t\t\t// Undefined | Multiple Files | $_FILES Corruption Attack\n\t\t\t// If this request falls under any of them, treat it invalid.\n\t\t\tif(\n\t\t\t\t!isset($files['error']) ||\n\t\t\t\tis_array($files['error'])\n\t\t\t){\n\t\t\t\tthrow new RuntimeException('Invalid parameters.');\n\t\t\t}\n\n\t\t\t// Check $_FILES['upfile']['error'] value.\n\t\t\tswitch ($files['error']) {\n\t\t\t    case UPLOAD_ERR_OK:\n\t\t\t        break;\n\t\t\t    case UPLOAD_ERR_NO_FILE:\n\t\t\t        throw new RuntimeException('No file sent.');\n\t\t\t    case UPLOAD_ERR_INI_SIZE:\n\t\t\t    case UPLOAD_ERR_FORM_SIZE:\n\t\t\t        throw new RuntimeException('Exceeded filesize limit.');\n\t\t\t    default:\n\t\t\t        throw new RuntimeException('Unknown errors.');\n\t\t\t}\n\n\t\t\t// You should also check filesize here.\n\t\t\t// $filesize \t= $files['size'] / 1024 / 1024;\n\t\t\t$filesize \t= round($files['size'] / 1024 / 1024, 1);\n\n\t\t\tif ($filesize > $conf_maxuploadsize) {\n\t\t\t    throw new RuntimeException('Exceeded filesize limit.');\n\t\t\t}\n\n\t\t\t// DO NOT TRUST $_FILES['upfile']['mime'] VALUE !!\n\t\t\t// Check MIME Type by yourself.\n\t\t\t$finfo = new finfo(FILEINFO_MIME_TYPE);\n\t\t\tif (false === $ext = array_search(\n\t\t\t\t$finfo->file($files['tmp_name']),\n\t\t\t\t$conf_doctype5,\n\t\t\t\ttrue\n\t\t\t)) {\n\t\t\t    throw new RuntimeException('Invalid file format.');\n\t\t\t}\n\n\t\t\treturn \"\";\n\n\t\t}catch (RuntimeException $e) {\n\t\t\treturn $e->getMessage();\n\t\t}\n\n\t}\n?>\n",
					"file": "/C/xampp7/htdocs/edgpens/odbc.php",
					"file_size": 23957,
					"file_write_time": 133013898836303466,
					"settings":
					{
						"buffer_size": 23206,
						"line_ending": "Windows"
					}
				},
				{
					"contents": "<?php\n\tif (!empty($_SERVER['HTTPS']) && ('on' == $_SERVER['HTTPS'])) {\n\t\t$uri = 'https://';\n\t} else {\n\t\t$uri = 'http://';\n\t}\n\t$uri .= $_SERVER['HTTP_HOST'];\n\theader('Location: '.$uri.'/edgpens/');\n\texit;\n?>\nSomething is wrong with the XAMPP installation :-(\n",
					"file": "/C/xampp7/htdocs/index.php",
					"file_size": 269,
					"file_write_time": 133034520426811536,
					"settings":
					{
						"buffer_size": 258,
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/edg/dg.php",
					"settings":
					{
						"buffer_size": 43735,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/utility/agent.php",
					"settings":
					{
						"buffer_size": 22173,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/reports/audit_trail_1.php",
					"settings":
					{
						"buffer_size": 4204,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/kod/kodDoctype.php",
					"settings":
					{
						"buffer_size": 10163,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/utility/sms_setting.php",
					"settings":
					{
						"buffer_size": 11750,
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens_220424/odbc.php",
					"settings":
					{
						"buffer_size": 12731,
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/login.php",
					"settings":
					{
						"buffer_size": 11766,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/company_search.php",
					"settings":
					{
						"buffer_size": 8337,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/edg/detail.php",
					"settings":
					{
						"buffer_size": 29904,
						"encoding": "UTF-8",
						"line_ending": "Unix"
					}
				},
				{
					"contents": "<?php if(empty($page)){ include(\"../access.php\"); } ?>\n<?php  \n\t$modal_name \t= str_replace(\"/\", \"-\", $page);\n// $mysqli->query(\"CREATE TEMPORARY TABLE t1 LIKE City\");\n\n/* INSERT INTO .. SELECT */\n// $mysqli->query(\"INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150\");\n// printf(\"%s\\n\", $mysqli->info);\n\nfunction bindAll($stmt) {\n    $meta = $stmt->result_metadata();\n    $fields = array();\n    $fieldRefs = array();\n    while ($field = $meta->fetch_field())\n    {\n        $fields[$field->name] = \"\";\n        $fieldRefs[] = &$fields[$field->name];\n    }\n\n    call_user_func_array(array($stmt, 'bind_result'), $fieldRefs);\n    $stmt->store_result();\n    return $fields;\n}\n\nfunction fetchRowAssoc($stmt, &$fields) {\n    if ($stmt->fetch()) {\n        return $fields;\n    }\n    return false;\n}\n\n\t$user \t\t\t= get_user($_SESSION['session']);\n\t$ii \t\t\t= (is_numeric($_GET['ii']) == 1) ? $_GET['ii'] : 0 ;\n\t$dis_next \t\t= ($ii>0) ? $ii : \"disabled\" ;\n\t$success \t \t= 0;\n\t$type_submit \t= \"add\";\n\n\t$user \t\t\t= get_user_full($_SESSION['session']);\n\t$roles \t\t\t= (int)$user['idRoles'];\n\t$idUser \t\t= (int)$user['idUser'];\n\n\tif($roles == 1 || $roles == 5){\n\t\tif(!empty($ii)){\n\t\t\tif($roles == 1){\n\t\t\t\t$query=\"SELECT * FROM permohonan_main WHERE idUserApply='{$idUser}' AND idPermohonan = '{$ii}'\";\n\t\t\t\t$result=$mysqli->query($query);\t\n\t\t\t\t$row=$result->fetch_assoc();\n\n\t\t\t\tif(!$row){\n\t\t\t\t\techo \"<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>\";\n\t\t\t\t\texit();\n\t\t\t\t}\n\n\t\t\t}\n\t\t}\n\n\t\tif($roles == 1)\n\t\t\t$l_vessel \t= \"index.php?page=kod/kodKapal_a\";\n\t\telse\n\t\t\t$l_vessel \t= \"index.php?page=kod/kodKapal\";\n\t\t\n\t}else{\n\t\techo \"<script>window.location.replace('index.php?page=edg/main');</script>\";\n\t\texit();\n\t}\n\n\tif($_POST):\n\n\t\t$do \t= $_POST['type_submit'];\n\n\t\tif($do==\"add\"){\t\t\t\t\t\t\n\n\t\t\t$sql \t \t\t= \"\tINSERT INTO \n\t\t\t\t\t\t\t\tkod_kapal (\n\t\t\t\t\t\t\t\t\tnama,\n\t\t\t\t\t\t\t\t\tidSyarikat,\n\t\t\t\t\t\t\t\t\tidJenisKapal,\n\t\t\t\t\t\t\t\t\tIMO,\n\t\t\t\t\t\t\t\t\tISSC,\n\t\t\t\t\t\t\t\t\tFlag,\n\t\t\t\t\t\t\t\t\tCallSign,\n\t\t\t\t\t\t\t\t\tidUserApply,\n\t\t\t\t\t\t\t\t\ttarikhApply\n\t\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\t?,\n\t\t\t\t\t\t\t\t\tNOW()\n\t\t\t\t\t\t\t\t)\";\n\t\t\t$param_type \t= \"ssssssss\";\n\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\"nama\" \t\t\t=> $_POST['nama'],\n\t\t\t\t\t\t\t\t\"idSyarikat\" \t=> $_POST['idSyarikat'],\n\t\t\t\t\t\t\t\t\"idJenisKapal\" \t=> $_POST['idJenisKapal'],\n\t\t\t\t\t\t\t\t\"IMO\" \t\t\t=> $_POST['IMO'],\n\t\t\t\t\t\t\t\t\"ISSC\" \t\t\t=> $_POST['ISSC'],\n\t\t\t\t\t\t\t\t\"Flag\" \t\t\t=> $_POST['Flag'],\n\t\t\t\t\t\t\t\t\"CallSign\" \t\t=> $_POST['CallSign'],\n\t\t\t\t\t\t\t\t\"idUserApply\" \t=> $user['idUser']\n\t\t\t\t\t\t\t \t);\n\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"APPLICATION UPDATE (SHIP PARTICULAR)\");\n\n\t\t\t$success \t= 1;\n\t\t\t$msg \t\t= \"RECORD ADDED!\";\n\n\t\t\tif($success){\n\t\t\t\techo \"<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular');</script>\";\n\t\t\t\texit();\n\t\t\t}\n\n\t\t}else{\n\n\t\t\tif($ii > 0){\n\n\t\t\t\tif($do==\"submit_me\"){\t\t\t\t\t\t\t\n\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\tsubmit \t \t\t\t= 'Y',\n\t\t\t\t\t\t\t\t\t\t\tidApproveMFSO \t \t= 0,\n\t\t\t\t\t\t\t\t\t\t\tcommentsMFSO \t \t= '',\n\t\t\t\t\t\t\t\t\t\t\tflagApproveMFSO \t= 'N',\n\t\t\t\t\t\t\t\t\t\t\tidApproveDG \t \t= 0,\n\t\t\t\t\t\t\t\t\t\t\tcommentsDG \t \t\t= '',\n\t\t\t\t\t\t\t\t\t\t\tflagApproveDG \t\t= 'N',\n\t\t\t\t\t\t\t\t\t\t\tidApproveMTSO \t \t= 0,\n\t\t\t\t\t\t\t\t\t\t\tcommentsMTSO \t \t= '',\n\t\t\t\t\t\t\t\t\t\t\tflagApproveMTSO \t= 'N'\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t$param_type \t= \"s\";\n\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $ii\n\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"APPLICATION UPDATE (SHIP PARTICULAR)\");\n\t\t\t\t\t$last_id \t= $ii;\n\t\t\t\t}else{\t\n\n\t\t\t\t\t$ix \t\t\t= 0;\n\t\t\t\t\t$ix_max \t\t= count($_POST['purpose']);\n\t\t\t\t\t$list_purpose \t= \"\";\n\t\t\t\t\twhile ( $ix < $ix_max){\n\t\t\t\t\t\t$list_purpose .= $_POST['purpose'][$ix].\"|\";\n\t\t\t\t\t\t$ix++;\n\t\t\t\t\t}\n\t\t\t\t\t$list_purpose \t= substr($list_purpose, 0, -1);\n\n\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\tidKapal \t \t\t= ?,\n\t\t\t\t\t\t\t\t\t\t\tbilKrew \t \t\t= ?,\n\t\t\t\t\t\t\t\t\t\t\tbilPenumpang \t\t= ?,\n\t\t\t\t\t\t\t\t\t\t\tGT \t \t\t\t\t= ?,\n\t\t\t\t\t\t\t\t\t\t\tnoVoyage \t \t\t= ?,\n\t\t\t\t\t\t\t\t\t\t\totherCallPurpose \t= ?,\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\tcargo2discharge \t= ?\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t$param_type \t= \"ssssssssss\";\n\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\"idKapal\" \t\t\t=> $_POST['vessel'],\n\t\t\t\t\t\t\t\t\t\t\"bilKrew\" \t\t\t=> $_POST['crew'],\n\t\t\t\t\t\t\t\t\t\t\"bilPenumpang\" \t\t=> $_POST['passenger'],\n\t\t\t\t\t\t\t\t\t\t\"GT\" \t\t\t\t=> $_POST['gt'],\n\t\t\t\t\t\t\t\t\t\t\"noVoyage\" \t\t\t=> $_POST['voyage'],\n\t\t\t\t\t\t\t\t\t\t\"otherCallPurpose\" \t=> $list_purpose,\n\t\t\t\t\t\t\t\t\t\t\"cargo2discharge\" \t=> $_POST['cargo'],\n\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $ii\n\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"APPLICATION UPDATE (SHIP PARTICULAR)\");\n\t\t\t\t\t$last_id \t= $ii;\n\n\t\t\t\t\t$folder \t\t= \"./upload/application/{$last_id}\";\n\t\t\t\t\tif(!is_dir($folder)):\n\n\t\t\t\t\t\tmkdir($folder,0777,TRUE);\n\t\t\t\t\t\t$file \t= \"./upload/index.html\";\n\t\t\t\t\t\tcopy($file, $folder.\"/index.html\");\n\n\t\t\t\t\tendif;\n\n\t\t\t\t\t$list_ext \t= $conf_doctype4;\n\n\t\t\t\t\t$filename \t= $_FILES['crew_upload']['name'];\n\t\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t\t$crew \t\t= \"\";\n\t\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t\t$crew \t\t= \"crew{$ext}\";\n\t\t\t\t\t\tmove_uploaded_file($_FILES['crew_upload']['tmp_name'],$folder.\"/\".$crew);\n\n\t\t\t\t\t\tunset($sql);\n\t\t\t\t\t\tunset($param_type);\n\t\t\t\t\t\tunset($param_data);\n\n\t\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\t\tfailKrew \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\t\"failKrew\" \t\t\t=> $crew,\n\t\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $ii\n\t\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t\t}\n\n\t\t\t\t\t$filename \t= $_FILES['passenger_upload']['name'];\n\t\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t\t$passenger \t= \"\";\n\t\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t\t$passenger \t= \"passenger{$ext}\";\n\t\t\t\t\t\tmove_uploaded_file($_FILES['passenger_upload']['tmp_name'],$folder.\"/\".$passenger);\n\n\t\t\t\t\t\tunset($sql);\n\t\t\t\t\t\tunset($param_type);\n\t\t\t\t\t\tunset($param_data);\n\t\t\t\t\t\t\n\t\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\t\tfailPenumpang \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\t\"failPenumpang\" \t=> $passenger,\n\t\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $ii\n\t\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t\t}\n\n\t\t\t\t\t$folder \t\t= \"./upload/vessel/{$_POST['vessel']}\";\n\t\t\t\t\tif(!is_dir($folder)):\n\n\t\t\t\t\t\tmkdir($folder,0777,TRUE);\n\t\t\t\t\t\t$file \t= \"./upload/index.html\";\n\t\t\t\t\t\tcopy($file, $folder.\"/index.html\");\n\n\t\t\t\t\tendif;\n\n\t\t\t\t\t$filename \t= $_FILES['issc_file']['name'];\n\t\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t\t$vessel \t= \"\";\n\t\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t\t$vessel \t= \"issc{$ext}\";\n\t\t\t\t\t\tmove_uploaded_file($_FILES['issc_file']['tmp_name'],$folder.\"/\".$vessel);\n\n\t\t\t\t\t\tunset($sql);\n\t\t\t\t\t\tunset($param_type);\n\t\t\t\t\t\tunset($param_data);\n\t\t\t\t\t\t\n\t\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\t\tkod_kapal \n\t\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\t\tfail_issc \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tidKapal = ?\";\n\t\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\t\"failPenumpang\" \t=> $vessel,\n\t\t\t\t\t\t\t\t\t\t\t\"idKapal\" \t\t=> $_POST['vessel']\n\t\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t\t}\n\n\t\t\t\t}\n\t\t\t}else{\n\n\t\t\t\t$ix \t\t\t= 0;\n\t\t\t\t$ix_max \t\t= count($_POST['purpose']);\n\t\t\t\t$list_purpose \t= \"\";\n\t\t\t\twhile ( $ix < $ix_max){\n\t\t\t\t\t$list_purpose .= $_POST['purpose'][$ix].\"|\";\n\t\t\t\t\t$ix++;\n\t\t\t\t}\n\t\t\t\t$list_purpose \t= substr($list_purpose, 0, -1);\n\n\t\t\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t\t\t$stmt->prepare(\"SELECT refID FROM permohonan_main where SUBSTR(refID, 1, 6) = DATE_FORMAT(NOW(), '%Y%m') ORDER BY idPermohonan DESC\");\n\t\t\t\t$stmt->execute();\n\t\t\t\t$result \t\t= $stmt->get_result();\n\t\t\t\t$stmt->close();\n\n\t\t\t\t$session \t= array();\n\t\t\t\t$row=$result->fetch_assoc();\n\t\t\t\tif($row){\n\t\t\t\t\t$refID \t= $row['refID']+1;\n\t\t\t\t}else{\n\t\t\t\t\t$refID \t= 0;\n\t\t\t\t}\n\n\t\t\t\t$sql \t \t\t= \"INSERT INTO permohonan_main (refID, idUserApply, idKapal, bilKrew, bilPenumpang, GT, noVoyage, otherCallPurpose, cargo2discharge) values (?,?,?,?,?,?,?,?,?)\";\n\t\t\t\t$param_type \t= \"sssssssssss\";\n\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\"refID\" \t\t\t=> $refID,\n\t\t\t\t\t\t\t\t\t\"idUserApply\" \t\t=> $user['idUser'],\n\t\t\t\t\t\t\t\t\t\"idKapal\" \t\t\t=> $_POST['vessel'],\n\t\t\t\t\t\t\t\t\t\"bilKrew\" \t\t\t=> $_POST['crew'],\n\t\t\t\t\t\t\t\t\t\"bilPenumpang\" \t\t=> $_POST['passenger'],\n\t\t\t\t\t\t\t\t\t\"GT\" \t\t\t\t=> $_POST['gt'],\n\t\t\t\t\t\t\t\t\t\"noVoyage\" \t\t\t=> $_POST['voyage'],\n\t\t\t\t\t\t\t\t\t\"otherCallPurpose\" \t=> $list_purpose,\n\t\t\t\t\t\t\t\t\t\"cargo2discharge\" \t=> $_POST['cargo']\n\t\t\t\t\t\t\t\t \t);\n\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"APPLICATION UPDATE (SHIP PARTICULAR)\");\n\t\t\t\t$last_id \t= $data[0];\n\n\t\t\t\t$folder \t\t= \"./upload/application/{$last_id}\";\n\t\t\t\tif(!is_dir($folder)):\n\n\t\t\t\t\tmkdir($folder,0777,TRUE);\n\t\t\t\t\t$file \t= \"./upload/index.html\";\n\t\t\t\t\tcopy($file, $folder.\"/index.html\");\n\n\t\t\t\tendif;\n\n\t\t\t\t$list_ext \t= $conf_doctype4;\n\n\t\t\t\t$filename \t= $_FILES['crew_upload']['name'];\n\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t$crew \t\t= \"\";\n\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t$crew \t\t= \"crew{$ext}\";\n\t\t\t\t\tmove_uploaded_file($_FILES['crew_upload']['tmp_name'],$folder.\"/\".$crew);\n\n\t\t\t\t\tunset($sql);\n\t\t\t\t\tunset($param_type);\n\t\t\t\t\tunset($param_data);\n\n\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\tfailKrew \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\"failKrew\" \t\t\t=> $crew,\n\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $last_id\n\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t}\n\n\t\t\t\t$filename \t= $_FILES['passenger_upload']['name'];\n\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t$passenger \t= \"\";\n\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t$passenger \t= \"passenger{$ext}\";\n\t\t\t\t\tmove_uploaded_file($_FILES['passenger_upload']['tmp_name'],$folder.\"/\".$passenger);\n\n\t\t\t\t\tunset($sql);\n\t\t\t\t\tunset($param_type);\n\t\t\t\t\tunset($param_data);\n\t\t\t\t\t\n\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\tpermohonan_main \n\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\tfailPenumpang \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tidPermohonan = ?\";\n\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\"failPenumpang\" \t=> $passenger,\n\t\t\t\t\t\t\t\t\t\t\"idPermohonan\" \t\t=> $last_id\n\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t}\n\n\t\t\t\t$folder \t\t= \"./upload/vessel/{$_POST['vessel']}\";\n\t\t\t\tif(!is_dir($folder)):\n\n\t\t\t\t\tmkdir($folder,0777,TRUE);\n\t\t\t\t\t$file \t= \"./upload/index.html\";\n\t\t\t\t\tcopy($file, $folder.\"/index.html\");\n\n\t\t\t\tendif;\n\n\t\t\t\t$filename \t= $_FILES['issc_file']['name'];\n\t\t\t\t$ext \t\t= strtolower(substr($filename, strrpos($filename, \".\")));\n\n\t\t\t\t$vessel \t= \"\";\n\t\t\t\tif (in_array($ext, $list_ext)) {\n\t\t\t\t\t$vessel \t= \"issc{$ext}\";\n\t\t\t\t\tmove_uploaded_file($_FILES['issc_file']['tmp_name'],$folder.\"/\".$vessel);\n\n\t\t\t\t\tunset($sql);\n\t\t\t\t\tunset($param_type);\n\t\t\t\t\tunset($param_data);\n\t\t\t\t\t\n\t\t\t\t\t$sql \t \t\t= \"UPDATE \n\t\t\t\t\t\t\t\t\t\t\tkod_kapal \n\t\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\tfail_issc \t\t\t= ?\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tidKapal = ?\";\n\t\t\t\t\t$param_type \t= \"\"; // EMPTY MEANS AUTO @ TYPE LENGTH != DATA (AUTO)\n\t\t\t\t\t$param_data \t= array(\n\t\t\t\t\t\t\t\t\t\t\"failPenumpang\" \t=> $vessel,\n\t\t\t\t\t\t\t\t\t\t\"idKapal\" \t\t=> $_POST['vessel']\n\t\t\t\t\t\t\t\t\t \t);\n\t\t\t\t\t$data \t\t= mysqli_prepare_audit($sql,$param_type,$param_data,\"\");\n\n\t\t\t\t}\n\n\t\t\t}\n\t\t\n\t\t\t$success \t= 1;\n\n\t\t\tif($success){\n\t\t\t\tif($do==\"submit_me\")\n\t\t\t\t\techo \"<script>window.location.replace('index.php?page=edg/main&np=edg/ship_particular&ii={$last_id}');</script>\";\n\t\t\t\telse\n\t\t\t\t\techo \"<script>window.location.replace('index.php?page=edg/main&np=edg/isps_info&ii={$last_id}');</script>\";\n\t\t\t\texit();\n\t\t\t}\n\n\t\t}\n\n\t\t// if($success == 1){\n\t\t// \t$_SESSION['success'] \t\t= 1;\n\t\t// \t$_SESSION['success_msg'] \t= \"SUCCESS {$do}\";\n\t\t// }else if($success == 2){\n\t\t// \t$_SESSION['success'] \t\t= 2;\n\t\t// \t$_SESSION['success_msg'] \t= \"OPS! SOMETHING WRONG\";\n\t\t// }else if($success == 3){\n\t\t// \t$_SESSION['success'] \t\t= 3;\n\t\t// \t$_SESSION['success_msg'] \t= \"WARNING\";\n\t\t// }\n\n\tendif;\n\t\n\tif($ii > 0){\n\t\t\n\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t$stmt->prepare(\"SELECT * FROM permohonan_main WHERE idPermohonan=?\");\n\t\t$stmt->bind_param(\"s\",$permohonan_main = $ii);\n\t\t$stmt->execute();\n\t\t$result \t\t= $stmt->get_result();\n\t\t$stmt->close();\n\n\t\t$session \t= array();\n\t\t$row=$result->fetch_assoc();\n\n\t\t$idKapal \t\t\t= $row['idKapal'];\n\t\t$bilKrew \t\t\t= $row['bilKrew'];\n\t\t$bilPenumpang \t\t= $row['bilPenumpang'];\n\t\t$GT \t\t\t\t= $row['GT'];\n\t\t$noVoyage \t\t\t= $row['noVoyage'];\n\t\t$otherCallPurpose \t= $row['otherCallPurpose'];\n\t\t$cargo2discharge \t= $row['cargo2discharge'];\n\t\t$idMarineFacility \t= $row['idMarineFacility'];\n\t\t$idApproveMFSO \t\t= $row['idApproveMFSO'];\n\t\t$idApproveDG \t\t= $row['idApproveDG'];\n\t\t$idApproveMTSO \t\t= $row['idApproveMTSO'];\n\t\t$commentsMFSO \t\t= $row['commentsMFSO'];\n\t\t$commentsDG \t\t= $row['commentsDG'];\n\t\t$commentsMTSO \t\t= $row['commentsMTSO'];\n\t\t$submit \t\t\t= $row['submit'];\n\t\t$failKrew \t\t\t= $row['failKrew'];\n\t\t$failPenumpang \t\t= $row['failPenumpang'];\n\t\t$list_purpose \t\t= explode('|', $row['otherCallPurpose']);\n\n\n\t\t$linkKrew \t\t\t= \"1\";\n\t\tif (file_exists(\"upload/application/{$ii}/{$failKrew}\") && !empty($failKrew)) {$linkKrew=\"upload/application/{$ii}/{$failKrew}\";}\n\n\t\t$linkPenumpang \t\t= \"1\";\n\t\tif (file_exists(\"upload/application/{$ii}/{$failPenumpang}\") && !empty($failPenumpang)) {$linkPenumpang=\"upload/application/{$ii}/{$failPenumpang}\";}\n\n\t\t$isps \t\t\t\t= \"\";\n\t\t$isps_href \t\t\t= \"index.php?page=edg/main&np=edg/isps_info&ii={$ii}\";\n\n\t\tif(!empty($idMarineFacility)){\n\t\t\t$port \t\t\t\t= \"\";\n\t\t\t$port_href \t\t\t= \"index.php?page=edg/main&np=edg/port_call&ii={$ii}\";\n\t\t}else{\n\t\t\t$port \t\t\t\t= \"disabled\";\n\t\t\t$port_href \t\t\t= \"javascript:void(0)\";\n\t\t}\n\n\n\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t$stmt->prepare(\"SELECT \n\t\t\t\t\t\t\ta.idPP,\n\t\t\t\t\t\t\ta.idPermohonanMain,\n\t\t\t\t\t\t\ta.idPelabuhan,\n\t\t\t\t\t\t\tDATE_FORMAT(a.tarikhTiba,'%d-%m-%Y') AS tarikhTiba,\n\t\t\t\t\t\t\tDATE_FORMAT(a.tarikhBerlepas,'%d-%m-%Y') AS tarikhBerlepas,\n\t\t\t\t\t\t\ta.securityLevel,\n\t\t\t\t\t\t\tb.nama,\n\t\t\t\t\t\t\tb.hadMasa\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\tpermohonan_pelabuhan a \n\t\t\t\t\t\tLEFT JOIN \n\t\t\t\t\t\t\tkod_pelabuhan b ON b.idPelabuhan = a.idPelabuhan\n\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\ta.idPermohonanMain=?\n\t\t\t\t\t\t\");\n\t\t$stmt->bind_param(\"s\",$permohonan_main = $ii);\n\t\t$stmt->execute();\n\n\t\tif ($stmt->error)\n    \t\tprint_r('error executing statement: ' . $stmt->error);\n\n\t\t$result2 \t\t= $stmt->get_result();\n\t\t$stmt->close();\n\n\t\tif($result2->num_rows && !empty($idMarineFacility)){\n\n\t\t\t$part \t\t\t\t= \"\";\n\t\t\t$part_href \t\t\t= \"index.php?page=edg/main&np=edg/other_part&ii={$ii}\";\n\t\t\t$upload \t\t\t= \"\";\n\t\t\t$upload_href \t\t= \"index.php?page=edg/main&np=edg/upload&ii={$ii}\";\n\n\t\t\tif($row['flagDG'] == 'Y'){\n\t\t\t\t$dg \t\t\t\t= \"\";\n\t\t\t\t$dg_href \t\t\t= \"index.php?page=edg/main&np=edg/dg&ii={$ii}\";\n\t\t\t}else{\n\t\t\t\t$dg \t\t\t\t= \"disabled\";\n\t\t\t\t$dg_href \t\t= \"javascript:void(0)\";\n\t\t\t}\n\t\t}else{\n\t\t\t$part \t\t\t\t= \"disabled\";\n\t\t\t$part_href \t\t\t= \"javascript:void(0)\";\n\t\t\t$upload \t\t\t= \"disabled\";\n\t\t\t$upload_href \t\t= \"javascript:void(0)\";\n\t\t\t$dg \t\t\t\t= \"disabled\";\n\t\t\t$dg_href \t\t\t= \"javascript:void(0)\";\n\t\t}\n\n\t\t// $stmt  \t\t\t= $mysqli->stmt_init();\n\t\t// $stmt->prepare(\"SELECT * FROM permohonan_pelabuhan WHERE idPermohonanMain=?\");\n\t\t// $stmt->bind_param(\"s\",$idPermohonanMain = $ii);\n\t\t// $stmt->execute();\n\t\t// $result \t\t= $stmt->get_result();\n\t\t// $stmt->close();\n\n\t\t// $session \t= array();\n\t\t// $row=$result->fetch_assoc();\n\n\n\t}else{\n\t\t\n\t\t$linkKrew \t\t\t= \"1\";\n\t\t$linkPenumpang \t\t= \"1\";\n\n\t\t$idKapal \t\t\t= \"\";\n\t\t$bilKrew \t\t\t= \"\";\n\t\t$bilPenumpang \t\t= \"\";\n\t\t$GT \t\t\t\t= \"\";\n\t\t$noVoyage \t\t\t= \"\";\n\t\t$idCallPurpose \t\t= \"\";\n\t\t$cargo2discharge \t= \"\";\n\t\t$failKrew \t\t\t= \"\";\n\t\t$failPenumpang \t\t= \"\";\n\n\t\t$isps \t\t\t\t= \"disabled\";\n\t\t$isps_href \t\t\t= \"javascript:void(0)\";\n\t\t$port \t\t\t\t= \"disabled\";\n\t\t$port_href \t\t\t= \"javascript:void(0)\";\n\t\t$part \t\t\t\t= \"disabled\";\n\t\t$part_href \t\t\t= \"javascript:void(0)\";\n\t\t$upload \t\t\t= \"disabled\";\n\t\t$upload_href \t\t= \"javascript:void(0)\";\n\t\t$dg \t\t\t\t= \"disabled\";\n\t\t$dg_href \t\t\t= \"javascript:void(0)\";\n\n\t}\n\n\n\t// $stmt  \t\t\t= $mysqli->stmt_init();\n\t// $stmt->prepare(\"SELECT nama FROM kod_call_purpose WHERE flagAktif = 'Y' \");\n\t// $stmt->execute();\n\t// $result \t\t= $stmt->get_result();\n\t// $stmt->close();\n\t// $list \t= [];\n\t// while($ax = $result->fetch_assoc()){\n\t\t// array_push($list, $ax['nama']);\n\t// }\n\n?>\n<style type=\"text/css\">\n</style>\n\t\n\t<div class=\"content-header\">\n\t\t<div class=\"row\">\n\t\t\t<div class=\"col-sm-6\">\n\t\t\t\t<div class=\"header-section\">\n\t\t\t\t\t\n\t\t\t\t\t<h1>\n\t\t\t\t\t<ol class=\"breadcrumb\" style=\"padding:0px; margin: 0px\">\n                        <li><a href=\"index.php?page=edg/main\" style=\"color:black\"><i class=\"fa fa-home\"></i></a></li>\n                        <li><a href=\"javascript:void(0)\" style=\"color:black\">NEW APPLICATION</a></li>\n                    </ol>\n                \t</h1>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<div class=\"col-sm-6 hidden-xs\">\n\t\t\t\t<div class=\"header-section\">\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\n\n\t\n\t<div class=\"block full\">\n\n\t\t<?php include 'tabs.php'; ?>\n\n\t\t<div class=\"block full\">\n\n\t\t\t<div id=\"modal-form\" class=\"modal fade <?php echo $modal_name;?>\" tabindex=\"-1\" role=\"dialog\" aria-hidden=\"true\">\n\t\t\t\t<div class=\"modal-dialog modal-md\">\n\t\t\t\t\t<div class=\"modal-content\">\n\n\t\t\t\t\t<form class=\"push form-horizontal\" id=\"form-validation2\" action=\"index.php?page=edg/main&np=edg/ship_particular&ii=<?php echo $ii;?>\" method=\"post\">\n\t\t\t\t\t\t\n\n\t\t\t\t\t\t<div class=\"modal-header\">\n\t\t\t\t\t\t\t<button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-hidden=\"true\"><span aria-hidden=\"true\">&times;</span></button>\n\t\t\t\t\t\t\t<h4 class=\"modal-title\"><strong>Apply For New Vessel</strong></h4>\n\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t<div class=\"modal-body\">\n\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"nama\">Name <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t\t<input type=\"text\" id=\"nama\" name=\"nama\" class=\"form-control validation\" data-validation=\"default\" >\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"idSyarikat\">Company <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t<?php \n\t\t\t\t\t\t\t\t\t$sqlx \t= \"SELECT * FROM kod_syarikat WHERE flagAktif = 'Y' AND flagApprove = 'Y' ORDER BY nama\";\n\t\t\t\t\t\t\t\t\t$rstx \t= $mysqli->query($sqlx) or die(mysqli_error($mysqli));\n\t\t\t\t\t\t\t\t?>\n\t\t\t\t\t\t\t\t<select class=\"form-control select-select2 validation\" data-validation=\"default\" name=\"idSyarikat\" id=\"idSyarikat\">\n\t\t\t\t\t\t\t\t\t<option value=\"\">-- Please select --</option>\n\t\t\t\t\t\t\t\t\t<?php while($aa = $rstx->fetch_assoc()){ ?>\n\t\t\t\t\t\t\t\t\t<option value=\"<?php echo $aa['idSyarikat']; ?>\" ><?php echo $aa['nama']; ?></option>\n\t\t\t\t\t\t\t\t\t<?php \t}?>\n\t\t\t\t\t\t\t\t</select>\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"idJenisKapal\">Vessel Type <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t<?php \n\t\t\t\t\t\t\t\t\t$sqlx \t= \"SELECT * FROM kod_jenis_kapal WHERE flagAktif = 'Y' ORDER BY nama\";\n\t\t\t\t\t\t\t\t\t$rstx \t= $mysqli->query($sqlx) or die(mysqli_error($mysqli));\n\t\t\t\t\t\t\t\t?>\n\t\t\t\t\t\t\t\t<select class=\"form-control select-select2 validation\" data-validation=\"default\" name=\"idJenisKapal\" id=\"idJenisKapal\">\n\t\t\t\t\t\t\t\t\t<option value=\"\">-- Please select --</option>\n\t\t\t\t\t\t\t\t\t<?php while($aa = $rstx->fetch_assoc()){ ?>\n\t\t\t\t\t\t\t\t\t<option value=\"<?php echo $aa['idJenisKapal']; ?>\" ><?php echo $aa['nama']; ?></option>\n\t\t\t\t\t\t\t\t\t<?php \t}?>\n\t\t\t\t\t\t\t\t</select>\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"IMO\">IMO <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t\t<input type=\"text\" id=\"IMO\" name=\"IMO\" class=\"form-control validation\" data-validation=\"default\" >\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\t\t\n\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"ISSC\">ISSC <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t\t<input type=\"text\" id=\"ISSC\" name=\"ISSC\" class=\"form-control validation\" data-validation=\"default\" >\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"Flag\">Flag <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t\t<input type=\"text\" id=\"Flag\" name=\"Flag\" class=\"form-control validation\" data-validation=\"default\" >\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t\t\t    <label class=\"col-md-3 control-label\" for=\"CallSign\">SCN </label>\n\t\t\t\t\t\t\t    <div class=\"col-md-6\">\n\t\t\t\t\t\t\t\t\t<input type=\"text\" id=\"CallSign\" name=\"CallSign\" class=\"form-control\" data-validation=\"default\" >\n\t\t\t\t\t\t\t    </div>\n\t\t\t\t\t\t\t</div>\t\t\n\n\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t<input type=\"hidden\" name=\"type_submit\" value=\"add\">\n\t\t\t\t\t\t<input type=\"hidden\" name=\"val-id\" value=\"\">\n\n\t\t\t\t\t\t<div class=\"modal-footer\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t<button type=\"submit\" class=\"btn btn-effect-ripple btn-primary\">Submit</button>\n\t\t\t\t\t\t<button type=\"button\" class=\"btn btn-effect-ripple btn-danger\" data-dismiss=\"modal\">Close</button>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</form>\n\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\n\t\t\t<form class=\"form-horizontal\" id=\"form-validation\" method=\"post\" enctype=\"multipart/form-data\" autocomplete=\"off\">\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t    <label class=\"col-md-4 control-label\" for=\"vessel\">Name Of Ship <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t    <div class=\"col-md-8\">\n\t\t\t\t\t\t<div class=\"input-group\">\n\t\t\t\t\t\t<?php \n\t\t\t\t\t\t\t$sqlx \t= \"SELECT * FROM kod_kapal WHERE flagAktif = 'Y' AND flagApprove = 'Y'\";\n\t\t\t\t\t\t\t$rstx \t= $mysqli->query($sqlx) or die(mysqli_error($mysqli));\n\n\t\t\t\t\t\t\t$sqly \t= \"SELECT * FROM kod_kapal WHERE flagAktif = 'Y' AND flagApprove = 'N'\";\n\t\t\t\t\t\t\t$rsty \t= $mysqli->query($sqly) or die(mysqli_error($mysqli));\n\t\t\t\t\t\t?>\n\t\t\t\t\t\t<select class=\"form-control select-select2 validation\" data-validation=\"default\" name=\"vessel\" id=\"vessel\">\n\t\t\t\t\t\t\t<optgroup label=\"Pending Approval\">\n\t\t\t\t\t\t\t<?php while($aa = $rsty->fetch_assoc()){ ?>\n\t\t\t\t\t\t\t<option value=\"<?php echo $aa['idKapal']; ?>\" <?php if($aa['idKapal'] == $idKapal){ echo \"selected='selected'\";} ?> disabled='disabled' ><?php echo $aa['nama']; ?></option>\n\t\t\t\t\t\t\t<?php \t}?>\n\t\t\t\t\t\t\t</optgroup>\n\t\t\t\t\t\t\t<option value=\"\">-- Choose a Vessel --</option>\n\t\t\t\t\t\t\t<?php while($aa = $rstx->fetch_assoc()){ ?>\n\t\t\t\t\t\t\t<option value=\"<?php echo $aa['idKapal']; ?>\" <?php if($aa['idKapal'] == $idKapal){ echo \"selected='selected'\";} ?> ><?php echo $aa['nama']; ?></option>\n\t\t\t\t\t\t\t<?php \t}?>\n\t\t\t\t\t\t</select>\n\n\t\t\t\t\t\t\n\t\t\t\t\t\t<a class=\"input-group-btn\" data-toggle=\"tooltip\" data-original-title=\"Add New Vessel\" href=\"<?php echo $l_vessel;?>\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"btn btn-effect-ripple btn-primary\" style=\"overflow: hidden; position: relative;\"><i class=\"fa fa-plus\"></i></span>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t    </div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"issc\">ISSC No</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"issc\" readonly=\"readonly\" name=\"issc\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"issc_auth\">ISSC Issuing Authority</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"issc_auth\" readonly=\"readonly\" name=\"issc_auth\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"issc_date\">ISSC Expiry Date</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"issc_date\" readonly=\"readonly\" name=\"issc_date\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"issc_file\">ISSC File <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<div class=\"input-group\" data-toggle=\"tooltip\" title=\"Upload ISSC File\">\n\t\t\t\t\t\t<div class=\"input-group-btn\">\n\t\t\t\t\t\t<label class=\"btn btn-primary\">\n\t\t\t\t\t\t\tBrowse <input type=\"file\" id=\"issc_file\" name=\"issc_file\" class=\"form-control\" style=\"display: none\" accept=\"<?php echo $conf_doctype2;?>\">\n\t\t\t\t\t\t</label>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<span class=\"up1\">\n\t\t\t\t\t\t<input style=\"background: white;color: #000\" readonly='readonly' value=\"\" type=\"issc_upload_text\" id=\"issc_upload_text\" name=\"issc_upload_text\" value=\"\" class=\"form-control validation upload-name\" data-validation=\"default\" placeholder=\"No File Selected\">\n\t\t\t\t\t\t</span>\n\t\t\t\t\t\t<a href=\"1\" target=\"_blank\" class=\"up2 form-control issc_file\" style=\"cursor: pointer;\">\n\t\t\t\t\t\t\tClick To Open<i class=\"fa fa-download pull-right\" style=\"line-height: 1.42857143\"></i>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t<div class=\"up3 input-group-btn\" data-toggle=\"tooltip\" title=\"Delete File\">\n\t\t\t\t\t\t\t<div class=\"btn btn-danger del-upload\" data-senddata='{\"ii\": \"\", \"type\": \"\", \"file\": \"\"}'><i class=\"fa fa-times\"></i></div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<i id=\"\" class=\"help-blockx animation-pullUp text-warning\" style=\"font-size: 9pt\">\n\t\t\t\t\t\t<b>File Allowed: <?php echo $conf_doctype3;?></b>\n\t\t\t\t\t\t<br><b>(Max Size: <?echo $conf_maxuploadsize;?>MB)</b>\n\t\t\t\t\t\t</i>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"imo\">IMO</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"imo\" readonly=\"readonly\" name=\"imo\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"mmsi\">MMSI</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"mmsi\" readonly=\"readonly\" name=\"mmsi\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"nama_syarikat\">Company Name</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"nama_syarikat\" readonly=\"readonly\" name=\"nama_syarikat\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"flag\">Flag</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"flag\" readonly=\"readonly\" name=\"flag\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"callsign\">SCN</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"callsign\" readonly=\"readonly\" name=\"callsign\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"nama_jeniskapal\">Vessel Type</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"nama_jeniskapal\" readonly=\"readonly\" name=\"nama_jeniskapal\" class=\"form-control\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"crew\">No Of Crew <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t<div class=\"col-md-2\">\n\t\t\t\t\t\t<input type=\"text\" id=\"crew\" name=\"crew\" value=\"<?php echo $bilKrew; ?>\"\t class=\"form-control validation\" data-validation=\"default_digit\">\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t\t\t<div class=\"input-group\" data-toggle=\"tooltip\" title=\"Upload list of crew\">\n\t\t\t\t\t\t<div class=\"input-group-btn\">\n\t\t\t\t\t\t<label class=\"btn btn-primary\">\n\t\t\t\t\t\t\tBrowse <input type=\"file\" id=\"crew_upload\" name=\"crew_upload\" class=\"form-control\" style=\"display: none\" accept=\"<?php echo $conf_doctype2;?>\">\n\t\t\t\t\t\t</label>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<span class=\"up1\">\n\t\t\t\t\t\t<input style=\"background: white;color: #000\" readonly='readonly' value=\"\" type=\"crew_upload_text\" id=\"crew_upload_text\" name=\"crew_upload_text\" value=\"\" class=\"form-control validation upload-name\" data-validation=\"default\" placeholder=\"No File Selected\">\n\t\t\t\t\t\t</span>\n\t\t\t\t\t\t<a href=\"<?php echo $linkKrew;?>\" target=\"_blank\" class=\"up2 form-control\" style=\"cursor: pointer;\">\n\t\t\t\t\t\t\tClick To Open<i class=\"fa fa-download pull-right\" style=\"line-height: 1.42857143\"></i>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t<div class=\"up3 input-group-btn\" data-toggle=\"tooltip\" title=\"Delete File\">\n\t\t\t\t\t\t\t<div class=\"btn btn-danger del-upload\" data-senddata='{\"ii\": \"<?php echo $ii;?>\", \"type\": \"crew\", \"file\": \"<?php echo $failKrew;?>\"}'><i class=\"fa fa-times\"></i></div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<i id=\"\" class=\"help-blockx animation-pullUp text-warning\" style=\"font-size: 9pt\">\n\t\t\t\t\t\t<b>File Allowed: <?php echo $conf_doctype3;?></b>\n\t\t\t\t\t\t<br><b>(Max Size: <?echo $conf_maxuploadsize;?>MB)</b>\n\t\t\t\t\t\t</i>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"passenger\">No Of Passenger <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t<div class=\"col-md-2\">\n\t\t\t\t\t\t<input type=\"text\" id=\"passenger\" name=\"passenger\" value=\"<?php echo $bilPenumpang; ?>\" class=\"form-control validation\" data-validation=\"default_digit\">\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t\t\t<div class=\"input-group\" data-toggle=\"tooltip\" title=\"Upload list of passenger\">\n\t\t\t\t\t\t<div class=\"input-group-btn\">\n\t\t\t\t\t\t<label class=\"btn btn-primary\">\n\t\t\t\t\t\t\tBrowse <input type=\"file\" name=\"passenger_upload\" class=\"form-control\" style=\"display: none\" accept=\"<?php echo $conf_doctype2;?>\">\n\t\t\t\t\t\t</label>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<span class=\"up1\">\n\t\t\t\t\t\t<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\">\n\t\t\t\t\t\t</span>\n\t\t\t\t\t\t<a href=\"<?php echo $linkPenumpang;?>\" target=\"_blank\" class=\"up2 form-control\" style=\"cursor: pointer;\">\n\t\t\t\t\t\t\tClick To Open<i class=\"fa fa-download pull-right\" style=\"line-height: 1.42857143\"></i>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t<div class=\"up3 input-group-btn\" data-toggle=\"tooltip\" title=\"Delete File\">\n\t\t\t\t\t\t\t<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>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<i id=\"\" class=\"help-blockx animation-pullUp text-warning\" style=\"font-size: 9pt\">\n\t\t\t\t\t\t<b>File Allowed: <?php echo $conf_doctype3;?></b>\n\t\t\t\t\t\t<br><b>(Max Size: <?echo $conf_maxuploadsize;?>MB)</b>\n\t\t\t\t\t\t</i>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<hr>\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"gt\">GT</label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"gt\" readonly=\"readonly\" name=\"gt\" class=\"form-control\">\n\t\t\t\t\t\t\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"voyage\">Voyage No. </label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<input type=\"text\" id=\"voyage\" name=\"voyage\" value=\"<?php echo $noVoyage; ?>\" class=\"form-control\" data-validation=\"default\">\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\n\t\t\t\t\n\t\t\t\t<div class=\"row\">\t\t\t\t\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"purpose\">Purpose Of Call <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t<select id=\"purpose\" name=\"purpose[]\" class=\"select-chosen validation validation_hidden\" data-placeholder=\"Choose a Purpose..\" multiple=\"\">\n\t\t\t\t\t\t<?php \n\t\t\t\t\t\t\t$stmt  \t\t\t= $mysqli->stmt_init();\n\t\t\t\t\t\t\t$stmt->prepare(\"SELECT idCallPurpose,nama FROM kod_call_purpose WHERE flagAktif = 'Y' \");\n\t\t\t\t\t\t\t$stmt->execute();\n\t\t\t\t\t\t\t$result \t\t= $stmt->get_result();\n\t\t\t\t\t\t\t$stmt->close();\n\t\t\t\t\t\t\twhile($ax = $result->fetch_assoc()){ \n\t\t\t\t\t\t\t\tif (in_array($ax['idCallPurpose'], $list_purpose))\n\t\t\t\t\t\t\t\t\t$slt \t= \"selected='selected'\";\n\t\t\t\t\t\t\t\telse\n\t\t\t\t\t\t\t\t\t$slt \t= \"\";\n\t\t\t\t\t\t?>\n\t\t\t\t\t\t\t<option <?php echo $slt;?> value=\"<?php echo $ax['idCallPurpose'];?>\"><?php echo $ax['nama'];?></option>\n\t\t\t\t\t\t<?php } ?>\n\t\t\t\t\t\t</select>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class=\"col-md-6\">\n\t\t\t\t<div class=\"form-group\">\n\t\t\t\t\t<label class=\"col-md-4 control-label\" for=\"cargo\">Cargo <span class=\"text-danger\">*</span></label>\n\t\t\t\t\t<div class=\"col-md-8\">\n\t\t\t\t\t\t<textarea class=\"form-control validation\" data-validation=\"default\" rows=\"3\" name=\"cargo\"><?php echo $cargo2discharge; ?></textarea>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t\n\n\t\t\t\t<hr>\n\t\t\t\t<center>\n\t\t\t\t<div class=\"btn-group\">\n\t\t\t\t<a class=\"btn btn-warning disabled\"><i class=\"fa fa-chevron-left\"></i></a>\n\t\t\t\t<button class=\"btn btn-primary\" href=\"index.php?page=edg/main\">Save</button>\n\t\t\t\t<a class=\"btn btn-warning <?php echo $dis_next;?>\" href=\"index.php?page=edg/main&np=edg/isps_info&ii=<?php echo $ii;?>\"><i class=\"fa fa-chevron-right\"></i></a>\n\t\t\t\t</div>\n\t\t\t\t</center>\n\t\t\t</form>\n\t\t</div>\n\n\t\t<script src=\"js/pages/formsValidation.js\"></script>\n        <script type=\"text/javascript\">\n\t\t$(document).ready(function(){\n\n\t\t\t$.fn.custom_upload = function(){\n\t\t\t\tvar t_parent \t= $(this).closest(\".input-group\");\n\t\t\t\tvar up1 \t\t= $(\".up1\",t_parent);\n\t\t\t\tvar up2 \t\t= $(\".up2\",t_parent);\n\t\t\t\tvar up3 \t\t= $(\".up3\",t_parent);\n\t\t\t\tvar up2_val \t= up2.prop(\"href\").substr(up2.prop(\"href\").lastIndexOf('/') + 1);\n\n\t\t\t\tif(up2_val !== \"1\"){\n\t\t\t\t\tup1.hide();\n\t\t\t\t\tup2.show();\n\t\t\t\t\t$(\".btn\",up3).removeClass(\"disabled\");\n\t\t\t\t}else{\n\t\t\t\t\tup1.show();\n\t\t\t\t\tup2.hide();\n\t\t\t\t\t$(\".btn\",up3).addClass(\"disabled\");\n\t\t\t\t}\n\t\t\t};\n\n\t\t\tvar states = <?php echo json_encode($list);?>;\n\t\t\t$.curCSS = function (element, attrib, val) {\n\t\t\t\t$(element).css(attrib, val);\n\t\t\t};\n\n\t\t\t$('#other_purpose').tagsInput({\n\t\t\t\twidth: 'auto',\n\t\t\t\theight: 'auto',\n\t\t\t\tautocomplete_url:states \n\t\t\t});\n\n\t\t\t$(\".del-upload\").on(\"click\",function(){\t\n\t\t\t\tvar t_parent \t= $(this).parents(\".input-group\");\n\t\t\t\tvar up1 \t\t= $(\".up1\",t_parent);\n\t\t\t\tvar up2 \t\t= $(\".up2\",t_parent);\n\t\t\t\tvar up3 \t\t= $(\".up3\",t_parent);\t\n\t\t\t\tvar senddata \t= $(this).data(\"senddata\");\n\t\t\t\tif(up2.is(':visible')){\n\t\t\t\t\tif(confirm(\"Delete This File?\")){\n\t\t\t\t\t\t$.post( \n\t\t\t\t\t\t\t\"ajax.php?do=clear_file\", \n\t\t\t\t\t\t\tsenddata\n\t\t\t\t\t\t).done(function(data) {\n\t\t\t\t\t\t\tup1.show();\n\t\t\t\t\t\t\tup2.hide();\n\t\t\t\t\t\t\t$(\".btn\",up3).addClass(\"disabled\");\n\t\t\t\t\t\t});\n\t\t\t\t\t}\n\t\t\t\t}else{\n\t\t\t\t\t$(\"input\",t_parent).prop(\"value\",\"\");\n\t\t\t\t\t$(\".btn\",up3).addClass(\"disabled\");\n\t\t\t\t}\n\t\t\t});\n\n\t\t\t$(\"[type='file']\").each(function(){\n\t\t\t\t$(this).custom_upload();\n\t\t\t});\n\n\t\t\t$(\".upload-name\").on(\"click\",function(){\n\t\t\t\t// console.log($(this).parent(\"div\").find(\"[name='file']\"));\n\t\t\t\t// $(this).parent(\"div\").find(\"[type='file']\").trigger(\"click\");\n\t\t\t});\n\n        \t$(\"[type='file']\").on(\"change\",function(){\n\n\t\t\t\tvar t_parent \t= $(this).closest(\".input-group\");\n\t\t\t\tvar up1 \t\t= $(\".up1\",t_parent);\n\t\t\t\tvar up2 \t\t= $(\".up2\",t_parent);\n\t\t\t\tvar up3 \t\t= $(\".up3\",t_parent);\n\t\t\t\tvar validExtensions = doc_allowed1; //array of valid extensions\n\t\t\t\tvar fileName = $(this).val().toLowerCase();\n\t\t\t\tvar fileNameExt = fileName.substr(fileName.lastIndexOf('.') + 1);\n\n\t\t\t\tconst fileSize = this.files[0].size / 1024 / 1024; // in MiB\n\n\t\t\t\tif ($.inArray(fileNameExt, validExtensions) == -1){\n\t\t\t\t\talert(\"Invalid file type\");\n\t\t\t\t\t$(this).val(\"\");\n        \t\t\t$(\".btn\",up3).removeClass(\"disabled\").addClass(\"disabled\");\n\t\t\t\t\treturn false;\n\t\t\t\t}else if (fileSize.toFixed(1)>doc_maxsize1){\n\t\t\t\t\talert(\"Allowed Max Size: \"+doc_maxsize1+\"MB\");\n\t\t\t\t\t$(this).val(\"\");\n\t\t\t\t\t$(\".btn\",up3).removeClass(\"disabled\").addClass(\"disabled\");\n\t\t\t\t\treturn false;\n\t\t\t\t}else{\n        \t\t\t$(this).parents(\"div.input-group\").find(\".upload-name\").val(fileName.substr(fileName.lastIndexOf('\\\\') + 1));\n        \t\t\t$(\".btn\",up3).removeClass(\"disabled\");\n\t\t\t\t}\n        \t});\n\n        \t$(\"[name='purpose']\").on(\"change\",function(){\n        \t\tif($(this).val() === ''){\n        \t\t\t$(\"[name='other_purpose']\").val(\"\");\n        \t\t}else{\n        \t\t\t$(\"[name='other_purpose']\").val(\"-\");\n        \t\t}\n        \t});\n\n\t\t\t$(document).on(\"click\", \".add-me\", function(){\n\t\t\t\tvar modal_name \t= \".\"+$(this).data(\"modal-target\");\n\t\t\t\t$(modal_name).modal({keyboard:true});\n\t\t\t\t$(modal_name).find(\"input\").not(\":button, :submit, :reset, .not_autoset\").val(\"\").prop(\"checked\",false);\n\t\t\t\t$(modal_name).find(\".default_radio, .default_checkbox\").prop(\"checked\",true);\n\t\t\t\t$(modal_name).find(\"select\").children(\"option\").prop(\"selected\",false).trigger(\"change\");\t\t\t\t\n\t\t\t\t$(modal_name).find('.help-block').remove();\n\t\t\t\t$(modal_name).find('.form-group').removeClass('has-success has-error');\n\t\t\t\t$(\"#form-validation2\").setvalidation('');\n\t\t\t\t$(\"#form-validation2 > [name='type_submit']\").val(\"add\");\n\t\t\t});\n\n\t\t\t$.fn.custom_submit2 = function(){\n\n\t\t\t\tvar this_form \t= $(this);\n\t\t\t\tvar cont \t\t= 0;\n\t\t\t\t$(\".validation_hidden\").each(function(){\n\t\t\t\t\tvar t_this \t= $(this);\n\t\t\t\t\tt_this.parent(\"div\").find(\".help-block\").remove();\n\t\t\t\t\tif(t_this.val() === \"\" || t_this.val() === null){\n\t\t\t\t\t\tcont++;\n\t\t\t\t\t\tt_this.parents(\".form-group\").addClass(\"has-error\");\n\t\t\t\t\t\tt_this.parents(\".form-group\").find(\".chosen-choices\").addClass(\"has-error\");\n\t\t\t\t\t\tt_this.parent(\"div\").append('<div class=\"help-block animation-pullUp\" style=\"display: block;\">This field is required.</div>');\n\t\t\t\t\t}else{\n\t\t\t\t\t\tt_this.parents(\".form-group\").removeClass(\"has-error\");\n\t\t\t\t\t\tt_this.parents(\".form-group\").find(\".chosen-choices\").removeClass(\"has-error\");\n\t\t\t\t\t}\n\t\t\t\t});\n\n\n\t\t\t\tif(this_form.find(\".has-error\").length === 0 && this_form.find(\".help-block\").length === 0 && cont === 0){\n\t\t\t\t\tsetTimeout(function(){ \n\t\t\t\t\t\tif(confirm(\"Save This Record. Are You Sure?\")){\n\t\t\t\t\t\t\tthis_form.unbind().submit();\n\t\t\t\t\t\t}\n\t\t\t\t\t}, 100);\n\t\t\t\t}else{\n\t\t\t\t\t$(this).find(\".help-block\").parents(\".form-group\").addClass(\"has-error\");\n\t\t\t\t\tsetTimeout(function(){ \n\t\t\t\t\t\t$(this_form,document).find(\".has-error\").each(function(){\n\t\t\t\t\t\t\t$(this,document).find(\"div\").each(function(){\n\t\t\t\t\t\t\tvar tot_err = $(this).find(\".help-block\").length;\n\t\t\t\t\t\t\tvar block_1 = $(this).find(\".help-block\").eq(0);\n\n\t\t\t\t\t\t\t$(this).find(\".help-block\").hide();\n\t\t\t\t\t\t\tif(tot_err > 1){\n\t\t\t\t\t\t\t\t\t$(this).find(\".help-block\").not(\":first\").remove();\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t$(this).find(\".help-block\").show();\n\n\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t});\n\t\t\t\t\t}, 100);\n\t\t\t\t}\n\n\t\t\t\t// \tsetTimeout(function(){ \n\t\t\t\t// return 123;\n\t\t\t\t// \t}, 100);\n\t\t\t};\n\n\t\t\t$(\"#form-validation\").setvalidation2();\n\t\t\t$(\"#form-validation\").on(\"submit.validate\",function(e){\n\t\t\t\t$(this).custom_submit2();\n\t\t\t\te.preventDefault();\n\n\t\t\t\t// console.log(asd);\n\t\t\t});\n\n        \t$(\"[name='vessel']\").on(\"change\",function(){\n        \t\tvar t_val \t= $(this).val();\n\t\t\t\t$.ajax({\n\t\t\t\t\ttype\t\t: \"POST\",\n\t\t\t\t\tdata \t\t: \"idKapal=\"+t_val,\n\t\t\t\t\turl \t\t: \"ajax.php?do=get_vessel\",\n\t\t\t\t\tsuccess \t: function(msg){\n\t\t\t\t\t\tvar obj = jQuery.parseJSON(msg);\n\t\t\t\t\t\tif(obj){\n\t\t\t\t\t\t\tif( (new Date(obj.tarikhLuputISSC).getTime() <= new Date(\"<?php echo date(\"Y-m-d\");?>\").getTime())){\n\t\t\t\t\t\t\t\t$(\"[name='issc_date']\").addClass(\"input-warning\");\n\t\t\t\t\t\t\t}else{\n\t\t\t\t\t\t\t\t$(\"[name='issc_date']\").removeClass(\"input-warning\");\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t$(\"[name='imo']\").val(obj.IMO);\n\t\t\t\t\t\t\t$(\"[name='issc']\").val(obj.ISSC);\n\t\t\t\t\t\t\t$(\"[name='callsign']\").val(obj.CallSign);\n\t\t\t\t\t\t\t$(\"[name='nama_syarikat']\").val(obj.nama_syarikat);\n\t\t\t\t\t\t\t$(\"[name='flag']\").val(obj.Flag);\n\t\t\t\t\t\t\t$(\"[name='nama_jeniskapal']\").val(obj.nama_jeniskapal);\n\t\t\t\t\t\t\t$(\"[name='gt']\").val(obj.GT);\n\t\t\t\t\t\t\t$(\"[name='issc_auth']\").val(obj.ISSCAuthority);\n\t\t\t\t\t\t\t$(\"[name='issc_date']\").val(obj.tarikhLuputISSC2);\n\t\t\t\t\t\t\t$(\"[name='mmsi']\").val(obj.MMSI);\n\t\t\t\t\t\t\t$(\".issc_file\").prop(\"href\",obj.linkissc);\n\t\t\t\t\t\t\t$(\".issc_file\").parent(\"div\").find(\".del-upload\").data(\"senddata\",{\"ii\": obj.idKapal, \"type\": \"vessel\", \"file\": obj.fail_issc});\n\t\t\t\t\t\t}else{\n\t\t\t\t\t\t\t$(\"[name='imo']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='issc']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='callsign']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='nama_syarikat']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='flag']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='nama_jeniskapal']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='gt']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='issc_auth']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='issc_date']\").val(\"\");\n\t\t\t\t\t\t\t$(\"[name='mmsi']\").val(\"\");\n\t\t\t\t\t\t\t$(\".issc_file\").prop(\"href\",\"1\");\n\t\t\t\t\t\t\t$(\".issc_file\").parent(\"div\").find(\".del-upload\").data(\"senddata\",{\"ii\": \"\", \"type\": \"\", \"file\": \"\"});\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\t// $(\".issc_file\").prop(\"href\",\"1\");\n\n\t\t\t\t\t\t$(\"#issc_file\").custom_upload();\n\t\t\t\t\t}\n\t\t\t\t});\n        \t});\n\n\t\t\t$(\"#form-validation\").find(\"select\").trigger(\"change\");\n\n\t\t\t$(\"#crew\").on(\"change\",function(){\n\t\t\t\tif($(this).val()<=0){\n\t\t\t\t\t$(\"#crew_upload_text\").removeClass(\"validation\");\n\t\t\t\t\t$(\"#form-validation\").clearvalidation();\n\t\t\t\t\t$(\"#form-validation\").setvalidation2();\n\t\t\t\t}else{\n\t\t\t\t\tif(!$(\"#crew_upload_text\").hasClass(\"validation\"))\n\t\t\t\t\t\t$(\"#crew_upload_text\").addClass(\"validation\");\n\t\t\t\t\t$(\"#form-validation\").clearvalidation();\n\t\t\t\t\t$(\"#form-validation\").setvalidation2();\n\t\t\t\t}\n\t\t\t});\n\n\t\t\t$(\"#passenger\").on(\"change\",function(){\n\t\t\t\tif($(this).val()<=0){\n\t\t\t\t\t$(\"#passenger_upload_text\").removeClass(\"validation\");\n\t\t\t\t\t$(\"#form-validation\").clearvalidation();\n\t\t\t\t\t$(\"#form-validation\").setvalidation2();\n\t\t\t\t}else{\n\t\t\t\t\tif(!$(\"#passenger_upload_text\").hasClass(\"validation\"))\n\t\t\t\t\t\t$(\"#passenger_upload_text\").addClass(\"validation\");\n\t\t\t\t\t$(\"#form-validation\").clearvalidation();\n\t\t\t\t\t$(\"#form-validation\").setvalidation2();\n\t\t\t\t}\n\t\t\t});\n\n\t\t\t$(\"#crew\").trigger(\"change\");\n\t\t\t$(\"#passenger\").trigger(\"change\");\n        });\n\n        </script>\n\t</div> \n",
					"file": "/C/xampp7/htdocs/edgpens/edg/ship_particular.php",
					"file_size": 43202,
					"file_write_time": 133014691529468740,
					"settings":
					{
						"buffer_size": 43203,
						"line_ending": "Unix"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/account_recovery.php",
					"settings":
					{
						"buffer_size": 8165,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/utility/web_setting.php",
					"settings":
					{
						"buffer_size": 17618,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/registration_submit.php",
					"settings":
					{
						"buffer_size": 6198,
						"encoding": "UTF-8",
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/reset_password.php",
					"settings":
					{
						"buffer_size": 9467,
						"line_ending": "Windows"
					}
				},
				{
					"file": "/C/xampp7/htdocs/edgpens/inc/template_start.php",
					"settings":
					{
						"buffer_size": 16828,
						"line_ending": "Unix"
					}
				}
			],
			"build_system": "",
			"build_system_choices":
			[
			],
			"build_varint": "",
			"command_palette":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"console":
			{
				"height": 0.0,
				"history":
				[
				]
			},
			"distraction_free":
			{
				"menu_visible": true,
				"show_minimap": false,
				"show_open_files": false,
				"show_tabs": false,
				"side_bar_visible": false,
				"status_bar_visible": false
			},
			"expanded_folders":
			[
				"/C/xampp7/htdocs/edgpens",
				"/C/xampp7/htdocs/edgpens/edg",
				"/C/xampp7/htdocs/edgpens/kod",
				"/C/xampp7/htdocs/edgpens/reports",
				"/C/xampp7/htdocs/edgpens/utility"
			],
			"file_history":
			[
				"/C/xampp7/htdocs/edgpens/utility/userList.php",
				"/C/xampp7/htdocs/edgpens/extension/PHPMailer-master/get_oauth_tokenx.php",
				"/C/Users/edgpens/Downloads/client_secret_684083486462-trh1f3r308qbq58l4jh362tnbi4ekn6j.apps.googleusercontent.com.json",
				"/C/xampp7/htdocs/edgpens/extension/PHPMailer-master/README.md",
				"/C/xampp7/htdocs/edgpens/odbc.php",
				"/C/xampp7/htdocs/edgpens/kod/audit_trail.php",
				"/C/xampp7/htdocs/edgpens/inc/template_start.php",
				"/C/xampp7/htdocs/edgpens/index.php",
				"/C/xampp7/htdocs/edgpens/edg/main.php",
				"/C/xampp7/htdocs/edgpens/utility/send_sms.php",
				"/C/xampp7/htdocs/edgpens/extension/PHPMailer-master/get_oauth_token.php",
				"/C/xampp7/htdocs/edgpens/inc/template_scripts_200430.php"
			],
			"find":
			{
				"height": 27.0
			},
			"find_in_files":
			{
				"height": 0.0,
				"where_history":
				[
				]
			},
			"find_state":
			{
				"case_sensitive": false,
				"find_history":
				[
					"passeng",
					"bilPenumpang",
					"passenger",
					"roles",
					"lpkm",
					"redirectUri"
				],
				"highlight": true,
				"in_selection": false,
				"preserve_case": false,
				"regex": false,
				"replace_history":
				[
				],
				"reverse": false,
				"show_context": true,
				"use_buffer2": true,
				"whole_word": false,
				"wrap": true
			},
			"folders":
			[
				{
					"path": "C:\\xampp7\\htdocs\\edgpens"
				}
			],
			"groups":
			[
				{
					"selected": 4,
					"sheets":
					[
						{
							"buffer": 0,
							"file": "/C/xampp7/htdocs/edgpens/utility/userList.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 27995,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 450.0,
								"zoom_level": 1.0
							},
							"stack_index": 16,
							"type": "text"
						},
						{
							"buffer": 1,
							"file": "/C/xampp7/htdocs/edgpens/utility/change_pass.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 11929,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 1625.0,
								"zoom_level": 1.0
							},
							"stack_index": 18,
							"type": "text"
						},
						{
							"buffer": 2,
							"file": "/C/xampp7/htdocs/edgpens/edg/site.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 18876,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 6838.0,
								"zoom_level": 1.0
							},
							"stack_index": 17,
							"type": "text"
						},
						{
							"buffer": 3,
							"file": "/C/xampp7/htdocs/edgpens/vendor/phpmailer/phpmailer/get_oauth_token.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 4947,
								"regions":
								{
								},
								"selection":
								[
									[
										2269,
										2269
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax"
								},
								"translation.x": 0.0,
								"translation.y": 1042.0,
								"zoom_level": 1.0
							},
							"stack_index": 15,
							"type": "text"
						},
						{
							"buffer": 4,
							"file": "/C/xampp7/htdocs/edgpens/odbc.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 23206,
								"regions":
								{
								},
								"selection":
								[
									[
										361,
										377
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax"
								},
								"translation.x": 0.0,
								"translation.y": 1.0,
								"zoom_level": 1.0
							},
							"stack_index": 0,
							"type": "text"
						},
						{
							"buffer": 5,
							"file": "/C/xampp7/htdocs/index.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 258,
								"regions":
								{
								},
								"selection":
								[
									[
										192,
										192
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax"
								},
								"translation.x": 0.0,
								"translation.y": 0.0,
								"zoom_level": 1.0
							},
							"stack_index": 1,
							"type": "text"
						},
						{
							"buffer": 6,
							"file": "/C/xampp7/htdocs/edgpens/edg/dg.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 43735,
								"regions":
								{
								},
								"selection":
								[
									[
										14626,
										14626
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 12332.0,
								"zoom_level": 1.0
							},
							"stack_index": 2,
							"type": "text"
						},
						{
							"buffer": 7,
							"file": "/C/xampp7/htdocs/edgpens/utility/agent.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 22173,
								"regions":
								{
								},
								"selection":
								[
									[
										19297,
										19297
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 13716.0,
								"zoom_level": 1.0
							},
							"stack_index": 8,
							"type": "text"
						},
						{
							"buffer": 8,
							"file": "/C/xampp7/htdocs/edgpens/reports/audit_trail_1.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 4204,
								"regions":
								{
								},
								"selection":
								[
									[
										132,
										132
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 369.0,
								"zoom_level": 1.0
							},
							"stack_index": 12,
							"type": "text"
						},
						{
							"buffer": 9,
							"file": "/C/xampp7/htdocs/edgpens/kod/kodDoctype.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 10163,
								"regions":
								{
								},
								"selection":
								[
									[
										4498,
										4498
									],
									[
										4557,
										4557
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 2730.0,
								"zoom_level": 1.0
							},
							"stack_index": 11,
							"type": "text"
						},
						{
							"buffer": 10,
							"file": "/C/xampp7/htdocs/edgpens/utility/sms_setting.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 11750,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 3061.0,
								"zoom_level": 1.0
							},
							"stack_index": 14,
							"type": "text"
						},
						{
							"buffer": 11,
							"file": "/C/xampp7/htdocs/edgpens_220424/odbc.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 12731,
								"regions":
								{
								},
								"selection":
								[
									[
										551,
										77
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax"
								},
								"translation.x": 0.0,
								"translation.y": 0.0,
								"zoom_level": 1.0
							},
							"stack_index": 13,
							"type": "text"
						},
						{
							"buffer": 12,
							"file": "/C/xampp7/htdocs/edgpens/login.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 11766,
								"regions":
								{
								},
								"selection":
								[
									[
										1902,
										1902
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 1373.0,
								"zoom_level": 1.0
							},
							"stack_index": 7,
							"type": "text"
						},
						{
							"buffer": 13,
							"file": "/C/xampp7/htdocs/edgpens/company_search.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 8337,
								"regions":
								{
								},
								"selection":
								[
									[
										4720,
										4720
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 2916.0,
								"zoom_level": 1.0
							},
							"stack_index": 5,
							"type": "text"
						},
						{
							"buffer": 14,
							"file": "/C/xampp7/htdocs/edgpens/edg/detail.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 29904,
								"regions":
								{
								},
								"selection":
								[
									[
										6801,
										6813
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 3872.0,
								"zoom_level": 1.0
							},
							"stack_index": 4,
							"type": "text"
						},
						{
							"buffer": 15,
							"file": "/C/xampp7/htdocs/edgpens/edg/ship_particular.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 43203,
								"regions":
								{
								},
								"selection":
								[
									[
										28577,
										28577
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 18898.0,
								"zoom_level": 1.0
							},
							"stack_index": 3,
							"type": "text"
						},
						{
							"buffer": 16,
							"file": "/C/xampp7/htdocs/edgpens/account_recovery.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 8165,
								"regions":
								{
								},
								"selection":
								[
									[
										5193,
										5211
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 3618.0,
								"zoom_level": 1.0
							},
							"stack_index": 6,
							"type": "text"
						},
						{
							"buffer": 17,
							"file": "/C/xampp7/htdocs/edgpens/utility/web_setting.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 17618,
								"regions":
								{
								},
								"selection":
								[
									[
										8529,
										8529
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 5454.0,
								"zoom_level": 1.0
							},
							"stack_index": 10,
							"type": "text"
						},
						{
							"buffer": 18,
							"file": "/C/xampp7/htdocs/edgpens/registration_submit.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 6198,
								"regions":
								{
								},
								"selection":
								[
									[
										3791,
										3791
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 2054.0,
								"zoom_level": 1.0
							},
							"stack_index": 9,
							"type": "text"
						},
						{
							"buffer": 19,
							"file": "/C/xampp7/htdocs/edgpens/reset_password.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 9467,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"translate_tabs_to_spaces": false
								},
								"translation.x": 0.0,
								"translation.y": 2750.0,
								"zoom_level": 1.0
							},
							"stack_index": 20,
							"type": "text"
						},
						{
							"buffer": 20,
							"file": "/C/xampp7/htdocs/edgpens/inc/template_start.php",
							"semi_transient": false,
							"settings":
							{
								"buffer_size": 16828,
								"regions":
								{
								},
								"selection":
								[
									[
										0,
										0
									]
								],
								"settings":
								{
									"syntax": "Packages/PHP/PHP.sublime-syntax",
									"tab_size": 4,
									"translate_tabs_to_spaces": true
								},
								"translation.x": 0.0,
								"translation.y": 4318.0,
								"zoom_level": 1.0
							},
							"stack_index": 19,
							"type": "text"
						}
					]
				}
			],
			"incremental_find":
			{
				"height": 27.0
			},
			"input":
			{
				"height": 0.0
			},
			"layout":
			{
				"cells":
				[
					[
						0,
						0,
						1,
						1
					]
				],
				"cols":
				[
					0.0,
					1.0
				],
				"rows":
				[
					0.0,
					1.0
				]
			},
			"menu_visible": true,
			"output.find_results":
			{
				"height": 0.0
			},
			"pinned_build_system": "",
			"position": "0,2,3,-1,-1,-1,-1,591,52,52,708",
			"project": "",
			"replace":
			{
				"height": 50.0
			},
			"save_all_on_build": true,
			"select_file":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"select_project":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"select_symbol":
			{
				"height": 0.0,
				"last_filter": "",
				"selected_items":
				[
				],
				"width": 0.0
			},
			"selected_group": 0,
			"settings":
			{
			},
			"show_minimap": true,
			"show_open_files": false,
			"show_tabs": true,
			"side_bar_visible": true,
			"side_bar_width": 226.0,
			"status_bar_visible": true,
			"template_settings":
			{
			},
			"window_id": 1,
			"workspace_name": ""
		}
	],
	"workspaces":
	{
		"recent_workspaces":
		[
		]
	}
}

${this.title}

Code Editor : Session.sublime_session