One Hat Cyber Team

View File Name : userList.php

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

<?php  
	$modal_name 	= str_replace("/", "-", $page);
	$param_data 	= array();
	$comb1 			= "";
	$name  			= (isset($_GET['val-name'])) ? $_GET['val-name'] : '' ;
	$idrole 		= (isset($_GET['val-roles'])) ? $_GET['val-roles'] : '' ;
	$aktif 			= (isset($_GET['val-aktif'])) ? $_GET['val-aktif'] : '' ;

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

	<!-- Blank Header -->
	<div class="content-header">
		<div class="row">
			<div class="col-sm-6">
				<div class="header-section">
					<h1><i class="gi gi-group"></i>&nbsp;&nbsp;USER LISTS</h1>
				</div>
			</div>
			<div class="col-sm-6 hidden-xs">
				<div class="header-section">
					<!-- <ul class="breadcrumb breadcrumb-top"> -->
						<!-- <li>Extra Pages</li> -->
						<!-- <li><a href="">Blank</a></li> -->
					<!-- </ul> -->
				</div>
			</div>
		</div>
	</div>
	<!-- END Blank Header -->

	<!-- Get Started Block -->
	<div class="block full">
		<!-- Get Started Title -->
		<div class="block-title">
			<div class="block-options pull-right">
				<div class="btn btn-effect-ripple btn-warning search-me" data-toggle="tooltip" data-original-title="Search"><i class="fa fa fa-search"></i></div>
				<a class="btn btn-sm btn-effect-ripple btn-default" data-toggle="tooltip" data-original-title="Refresh" href="index.php?page=<?php echo $page;?>"><i class="fa fa-refresh"></i></a>
				<!-- <div class="btn btn-effect-ripple btn-default reset-me" data-toggle="tooltip" data-original-title="Reset"><i class="fa fa-refresh"></i></div> -->
			</div>
			<h2>User List</h2>
		</div>

<!-- [QUERY_STRING] -->

			<?php 

				$success 	= 0;
				if($_POST):

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

					$id=$_POST['val-id'];
					$nama=mysqli_real_escape_string($mysqli_link,strtoupper($_POST['val-name']));
					$user=$_POST['val-user'];
					$syarikat=$_POST['val-syarikat'];
					$phoneNo=$_POST['val-mobile'];
					$roles=$_POST['val-roles'];
					$subroles=$_POST['val-subroles'];
					$dg=$_POST['val-dg'];
					$pelabuhan=$_POST['val-port'];
					$flagAktif=$_POST['val-aktif'];

					if($do=="add"){						
						// $qAdd="INSERT INTO user_list (nameUser, emailUser, idSyarikat, mobileNo, idRoles, idPelabuhan, flagUser, flagApprove, dateCreated, dateVerified, dateModified) VALUES ('$nama', '$user', '$syarikat', '$phoneNo', '$roles', '$pelabuhan', '$flagAktif', 'Y', NOW(), NOW(), NOW())";						
						// mysqli_query($mysqli_link,$qAdd) or die(mysqli_connect_error());

						$sql 	 		= "	INSERT INTO 
											user_list (
												nameUser, 
												passwordUser,
												emailUser, 
												idSyarikat, 
												mobileNo, 
												idRoles, 
												flagDGApproval, 
												idPelabuhan, 
												flagUser, 
												flagApprove, 
												dateCreated, 
												dateVerified, 
												dateModified,
												datePassword
											) VALUES (
												?,
												?,
												?,
												?,
												?,
												?,
												?,
												?, 
												?, 
												'Y',
												NOW(),
												NOW(),
												NOW(),
												NOW()
											)";
						$param_type 	= "sssssssss";
						$param_data 	= array(
											"nameUser" 			=> $nama,
											"passwordUser" 		=> md5('abcd1234'),
											"emailUser" 		=> $user,
											"idSyarikat" 		=> $syarikat,
											"mobileNo" 			=> $phoneNo,
											"idRoles" 			=> $roles,
											"flagDGApproval" 	=> $dg,
											"idPelabuhan" 		=> $pelabuhan,
											"flagUser" 			=> $flagAktif
										 	);
						$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"USER LIST (ADD)");

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

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

						$sql 	 		= "	UPDATE 
												user_list 
											SET 
												nameUser 			= ?, 
												-- passwordUser 	= ?, 
												emailUser 			= ?, 
												idSyarikat 			= ?, 
												mobileNo 			= ?, 
												idRoles 			= ?, 
												flagDGApproval 		= ?, 
												idPelabuhan 		= ?, 
												flagUser 			= ?, 
												dateModified 		= NOW(),
												idSubRoles 			= ? 
											WHERE 
												idUser 	= ?
											";
						$param_type 	= "ssssssssss";
						$param_data 	= array(
											"nameUser" 		=> $nama,
											// "passwordUser" 	=> md5($_POST['val-password']),
											"emailUser" 		=> $user,
											"idSyarikat" 		=> $syarikat,
											"mobileNo" 			=> $phoneNo,
											"idRoles" 			=> $roles,
											"flagDGApproval" 	=> $dg,
											"idPelabuhan" 		=> $pelabuhan,
											"flagUser" 			=> $flagAktif,
											"idSubRoles" 		=> $subroles,
											"idUser" 			=> $id
										 	);
						$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"USER LIST (UPDATE)");

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

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

						foreach($_POST['myid'] as $value){						
							$sql 	 		= "	UPDATE 
													user_list 
												SET 
													passwordUser 	= ?, 
													dateModified 	= NOW(), 
													datePassword 	= NOW() 
												WHERE 
													idUser 	= ?
												";
							$param_type 	= "ss";
							$param_data 	= array(
												"passwordUser" 	=> md5('abcd1234'),
												"idUser" 		=> $value
											 	);
							$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"USER LIST (RESET PASSWORD)");

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

					}
					else if($do=="delete"){	
						foreach($_POST['myid'] as $value){						

							$sql 	 		= "DELETE FROM user_list WHERE idUser=?";
							$param_type 	= "s";
							$param_data 	= array(
												"idUser" 		=> $value
											 	);
							$data 		= mysqli_prepare_audit($sql,$param_type,$param_data,"USER LIST (DELETE)");

						}
					$success 	= 3;
					}
					else if($do=="unlock"){	
						// foreach($_POST['myid'] as $value){						

						// 	$sql 	 		= "DELETE FROM user_list WHERE idUser=?";
						// 	$param_type 	= "s";
						// 	$param_data 	= array(
						// 						"idUser" 		=> $value
						// 					 	);
						// 	$data 		= mysqli_prepare_audit($sql,$param_type,$param_data);

						// }
						foreach($_POST['myid'] as $value){						
							log_attempts($value,1,2,0,$idUser);
						}

						$success 	= 1;
						$msg = "ACCOUNT UNLOCKED!";
					}


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

				endif;

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

			<div id="modal-search" class="modal fade" tabindex="-1" role="dialog" aria-hidden="true">
				<div class="modal-dialog modal-md">
					<div class="modal-content">

					<form class="push form-horizontal" id="search-validation" action="index.php?page=utility/userList" method="get">
						<!-- if delete. check post name delete -->

						<input type="hidden" name="page" value="<?php echo $page;?>">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span aria-hidden="true">&times;</span></button>
							<h4 class="modal-title"><i class="fa fa fa-search"></i>&nbsp;<strong>SEARCH</strong></h4>
						</div>

						<div class="modal-body"><!-- modal-body -->

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-name">Name</label>
							    <div class="col-md-7">
							        <input type="text" id="val-name" name="val-name" class="form-control validation" data-validation="default" placeholder="Name" value="<?php echo $name;?>">
							    </div>
							</div>

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-rolesx">Role</label>
							    <div class="col-md-7">
							        <select id="val-rolesx" name="val-roles" class="form-control validation select-select2 select2_custom" data-validation="default" data-placeholder="Role..">
		                                <option value=""></option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$qRoles="SELECT idRoles,nama FROM user_roles";
								$resRoles=mysqli_query($mysqli_link, $qRoles) or die(mysqli_connect_error());
								while($rowRoles=mysqli_fetch_array($resRoles)){
								?>
										<option value="<?=$rowRoles['idRoles']?>" <?php if($rowRoles['idRoles']==$idrole){?>selected='selected'<?php }?>><?=$rowRoles['nama']?></option>
								<?}mysqli_free_result($resRoles)?>
									</select>
							    </div>
							</div>

							<div class="form-group">
								<label class="col-md-3 control-label" for="val-aktifL">Status</label>
								<div class="col-md-7">
								  <label class="radio-inline" for="val-aktifY">
									  <input type="radio" class="not_autoset default_radio" id="val-aktifY" name="val-aktif" value="1" <?if($aktif=='1'){?>checked<?}?>> Active
								  </label>
								  <label class="radio-inline" for="val-aktifB">
									  <input type="radio" class="not_autoset" id="val-aktifB" name="val-aktif" value="2" <?if($aktif=='2'){?>checked<?}?>> Blocked
								  </label>
								  <label class="radio-inline" for="val-aktifT">
									  <input type="radio" class="not_autoset" id="val-aktifT" name="val-aktif" value="3" <?if($aktif=='3'){?>checked<?}?>> Inactive
								  </label>
								</div>
							</div>						
						</div><!-- [end] modal-body -->


						<div class="modal-footer">
						<!-- <h4 class="pull-left">$ <strong class="text-primary-dark">689</strong><small>.00</small></h4> -->
						<button type="submit" class="btn btn-effect-ripple btn-primary">Submit</button>
						<button type="reset" class="btn btn-effect-ripple btn-default btn-reset"><span class="btn-ripple animate" style="height: 61px; width: 61px; top: -15.3px; left: 11.8667px;"></span>Reset</button>
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>
						</div>
					</form>

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

			<div id="modal-form" class="modal fade <?php echo $modal_name;?>" tabindex="-1" role="dialog" aria-hidden="true">
				<div class="modal-dialog modal-lg">
					<div class="modal-content">

					<form class="push form-horizontal" id="form-validation" action="index.php?page=utility/userList" method="post">
						<!-- if delete. check post name delete -->

						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span aria-hidden="true">&times;</span></button>
							<h4 class="modal-title"><strong>USER</strong></h4>
						</div>

						<div class="modal-body"><!-- modal-body -->

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-user">Username <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <input type="email" id="val-user" name="val-user" class="form-control validation" data-validation="default" placeholder="Username (E-mail)..">
							    </div>
							</div>

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-password">Password <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <input type="text" readonly="readonly" id="val-password" name="val-password" class="form-control" placeholder="Default : abcd1234">
							    </div>
							</div>

					<!-- 		<div class="form-group">
							    <label class="col-md-3 control-label" for="val-confirm-password">Confirm Password <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <input type="password" id="val-confirm-password" name="val-confirm-password" class="form-control validation" data-validation="password2" placeholder="..and confirm it to be safe!">
							    </div>
							</div> -->

							<hr>

							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-name">Name <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <input type="text" id="val-name" name="val-name" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-roles">Role <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <select id="val-roles" name="val-roles" class="form-control validation select-select2" data-validation="default" data-placeholder="Role..">
		                                <option></option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$qRoles="SELECT idRoles,nama FROM user_roles";
								$resRoles=mysqli_query($mysqli_link, $qRoles) or die(mysqli_connect_error());
								while($rowRoles=mysqli_fetch_array($resRoles)){
								?>
										<option value="<?=$rowRoles['idRoles']?>"><?=$rowRoles['nama']?></option>
								<?}mysqli_free_result($resRoles)?>
									</select>
							    </div>
							</div>

							<div class="form-group subrole">
							    <label class="col-md-3 control-label" for="val-subroles">Sub Role</label>
							    <div class="col-md-7">
							        <select id="val-subroles" name="val-subroles" class="form-control select-select2 select2_custom myval" data-placeholder="Sub Role.." data-myval="">
		                                <option value="0">-</option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
									</select>
							    </div>
							</div>

							<div class="form-group approvedg1">
								<label class="col-md-3 control-label" for="val-aktifxL">Approve DG? <span class="text-danger">*</span></label>
								<div class="col-md-7">
								  <label class="radio-inline" for="val-aktifxB">
									  <input type="radio" class="not_autoset default_radio" id="val-aktifxB" name="val-dg" value="T" <?if($rowKod['flagDGApproval']=="T"){?>checked<?}?>> No
								  </label>
								  <label class="radio-inline" for="val-aktifxY">
									  <input type="radio" class="not_autoset" id="val-aktifxY" name="val-dg" value="Y" <?if($rowKod['flagDGApproval']=="Y"){?>checked<?}?>> Yes
								  </label>
								</div>
							</div>	
							<div class="form-group approvedg2">
							    <label class="col-md-3 control-label" for="val-port">Terminal <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <select id="val-port" name="val-port" class="form-control validation select-select2 select2_customx" data-validation="default"  data-placeholder="Terminal (for MFSO)..">
		                                <option value="">None / Please Choose</option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$qTerminal="SELECT idMarineFacility,nama FROM kod_marine_facility WHERE flagAktif='Y'";
								$resTerminal=mysqli_query($mysqli_link, $qTerminal) or die(mysqli_connect_error());
								while($rowTerminal=mysqli_fetch_array($resTerminal)){
								?>
										<option value="<?=$rowTerminal['idMarineFacility']?>"><?=$rowTerminal['nama']?></option>
								<?}mysqli_free_result($resTerminal)?>
									</select>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-syarikat">Company Name <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <select id="val-syarikat" name="val-syarikat" class="form-control validation select-select2" data-validation="default" data-placeholder="Company Name..">
		                                <option></option><!-- Required for data-placeholder attribute to work with Chosen plugin -->
								<?
								$qSykt="SELECT idSyarikat,nama FROM kod_syarikat WHERE flagAktif='Y' AND flagApprove='Y' ORDER BY nama";
								$resSykt=mysqli_query($mysqli_link, $qSykt) or die(mysqli_connect_error());
								while($rowSykt=mysqli_fetch_array($resSykt)){
								?>
										<option value="<?=$rowSykt['idSyarikat']?>"><?=$rowSykt['nama']?></option>
								<?}mysqli_free_result($resSykt)?>
									</select>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-mobile">Mobile Number <span class="text-danger">*</span></label>
							    <div class="col-md-7">
							        <input type="text" id="val-mobile" name="val-mobile" class="form-control validation" data-validation="default" placeholder="Mobile Number (601XXXXXXXX)..">
							    </div>
							</div>
							<hr>
							<div class="form-group">
								<label class="col-md-3 control-label" for="val-aktifL">Status <span class="text-danger">*</span></label>
								<div class="col-md-7">
								  <label class="radio-inline" for="val-aktifY">
									  <input type="radio" class="not_autoset default_radio" id="val-aktifY" name="val-aktif" value="1" <?if($rowKod['flagUser']=="1"){?>checked<?}?>> Active
								  </label>
								  <label class="radio-inline" for="val-aktifB">
									  <input type="radio" class="not_autoset" id="val-aktifB" name="val-aktif" value="2" <?if($rowKod['flagUser']=="2"){?>checked<?}?>> Blocked
								  </label>
								  <label class="radio-inline" for="val-aktifT">
									  <input type="radio" class="not_autoset" id="val-aktifT" name="val-aktif" value="3" <?if($rowKod['flagUser']=="3"){?>checked<?}?>> Inactive
								  </label>
								</div>
							</div>						
						</div><!-- [end] modal-body -->

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

						<div class="modal-footer">
						<!-- <h4 class="pull-left">$ <strong class="text-primary-dark">689</strong><small>.00</small></h4> -->
						<button type="submit" class="btn btn-effect-ripple btn-primary">Submit</button>
						<button type="button" class="btn btn-effect-ripple btn-danger" data-dismiss="modal">Close</button>
						</div>
					</form>

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

			<div class="table-responsive">
			<form method="post" data-modal-target="<?php echo $modal_name;?>">
				<input name="type_submit" type="hidden" value="delete">

				<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th style="width: 40px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th class="text-center" style="width: 40px;">ID</th>
							<th>USERNAME</th>
							<th>NAME</th>
							<th class="text-center">ROLE</th>
							<th class="text-center" style="width: 80px;">STATUS</th>
							<th class="text-center no_sorting" style="width: 100px;"><i class="fa fa-flash"></i></th>
						</tr>
					</thead>
					<tbody>
					<?php
					$labels['1']['class'] = "label-success";
					$labels['1']['text'] = "Active";
					$labels['2']['class'] = "label-warning";
					$labels['2']['text'] = "Blocked";
					$labels['3']['class'] = "label-danger";
					$labels['3']['text'] = "Inactive";
					?>
					<?php 
						


						if(!empty($name)){ 
							$comb1 						.= " AND a.nameUser LIKE ? ";
							$param_data['nameUser'] 	= "%{$name}%";
						}

						if(!empty($idrole)){ 
							$comb1 					.= " AND a.idRoles = ? ";
							$param_data['idRoles'] 	= $idrole;
						}

						if(!empty($aktif)){ 
							$comb1 					.= " AND a.flagUser = ? ";
							$param_data['flagUser'] 	= $aktif;
						}

						$sql 	= "	SELECT 
										a.*,
										IF(b.attempt_count>=c.log_attempt,'1','0') login_status, 
										d.nama as nama_subroles
									FROM user_list a 
									LEFT JOIN (SELECT idUser,attempt_count FROM utiliti_login WHERE attempt_date=CURDATE() AND user_type=1 GROUP BY idUser) b on b.idUser=a.idUser
									LEFT JOIN user_subroles d ON d.idSubRoles=a.idSubRoles
									CROSS JOIN utiliti_web_config c
									WHERE 1 {$comb1}";
						$data 	= mysqli_prepare_all($sql,$param_type = "auto",$param_data);

						while($rowKod = $data->fetch_assoc()){

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

							// editdata seperti send get value, split by | 
							// cth : <namainput>#<value> | <namaselect>#<value>
							$editdata = "val-syarikat#$rowKod[idSyarikat]|"
										."val-user#$rowKod[emailUser]|"
										."val-name#$rowKod[nameUser]|"
										."val-mobile#$rowKod[mobileNo]|"
										."val-roles#$rowKod[idRoles]|"
										."val-subroles#$rowKod[idSubRoles]|"
										."val-port#$rowKod[idPelabuhan]|"
										."val-id#$rowKod[idUser]|"
										."val-aktif#$rowKod[flagUser]|"
										."val-dg#$rowKod[flagDGApproval]";

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

						$subroles = "";
						if(!empty($rowKod['idSubRoles']))
						$subroles = " - ".strtoupper($rowKod['nama_subroles']);
					?>
						<tr>
							<td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $rowKod['idUser'];?>"><span></span></label></td>
							<td class="text-center"><?=$rowKod['idUser']?></td>
							<td><strong><?=$rowKod['emailUser']?></strong></td>
							<td><?=$rowKod['nameUser']?></td>
							<td class="text-center"><?=$rowKod2['nama']?><?=$subroles;?></td>
							<?php $rand = $rowKod['flagUser'] ?>
							<td class="text-center"><span class="label<?php echo ($labels[$rand]['class']) ? " " . $labels[$rand]['class'] : ""; ?>"><?php echo $labels[$rand]['text'] ?></span></td>
							<td class="text-center">
							<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata;?>"><i class="fa fa-pencil"></i></a>
							<a href="javascript:void(0)" title="Reset Password" class="btn btn-effect-ripple btn-xs btn-warning pass-me" data-val="<?php echo $i;?>"><i class="fa fa-refresh"></i></a>
							<?php if($rowKod['login_status']==1){?>
							<a href="javascript:void(0)" title="Unlock Account" class="btn btn-effect-ripple btn-xs btn-info unlock-me" data-val="<?php echo $i;?>"><i class="fa fa-unlock-alt"></i></a>
							<?php } ?>
							<a href="javascript:void(0)" title="Delete Record" class="btn btn-effect-ripple btn-xs btn-danger del-me" data-val="<?php echo $i;?>"><i class="fa fa-times"></i></a>
							</td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>
			</form>
			</div>
		
		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

			// 'val-password': {
			//     required: false,
			//     minlength: 5
			// },
			// 'val-confirm-password': {
			//     required: false,
			//     equalTo: '#val-password'
			// },

			$("#val-password").on("trigger_me",function(e){

				var trgt    = $(this);

				if(trgt.val().length >= 8){

					var numbers =  /^[0-9]+$/i;
					var letters =  /^[a-zA-Z]+$/i;
					var result  = false;
					var valid   = false;

					if(letters.test(trgt.val()))
						result  = true;

					if(numbers.test(trgt.val()))
						result  = true;

					trgt.parent().find(".help-block2").remove();

					if(result){
						trgt.after("<div id=\"val-password-error\" class=\"help-block2 \" style='margin-top:8px;font-weight:400;font-style:italic;color: #de815c'>Your password must be at least 8 characters long and must not contain all numbers or characters</div>");
						trgt.closest(".form-group").addClass("has-error2");
						return false;
					}else{
						trgt.parent().find(".help-block2").remove();
						trgt.closest(".form-group").removeClass("has-error2");
					}

				}else{
					trgt.parent().find(".help-block2").remove();
					trgt.closest(".form-group").removeClass("has-error2");
				}


			});

			$("#val-password").on("keyup",function(e){
				$(this).trigger("trigger_me");
			});

			$("#example-datatable").on("submit",function(){

				var e = jQuery.Event("trigger_me");
				$("#val-password").trigger(e);
				return e.result;

			});

        	$("#example-datatable").setdatatable().setadddelete();

            $('thead input:checkbox').click(function() {
                var checkedStatus   = $(this).prop('checked');
                var table           = $(this).closest('table');

                $('tbody input:checkbox', table).each(function() {
                    $(this).prop('checked', checkedStatus);
                });
            });

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

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

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

			$("#example-datatable tbody").on("click", ".del-me", function(){
				if(confirm("Delete This Record! Are You Sure?")){
					$(this).closest("table").find("input[type='checkbox']").prop("checked",false);
					$(this).closest("tr").find("input[type='checkbox']").trigger("click");
					$(this).closest("form").submit();
				}
			})

			$("#example-datatable tbody").on("click", ".pass-me", function(){
				if(confirm("Reset Default Password For This Record! Are You Sure?")){
					$(this).closest("table").find("input[type='checkbox']").prop("checked",false);
					$(this).closest("tr").find("input[type='checkbox']").trigger("click");
					$(this).closest("form").find("[name='type_submit']").val("edit_pass");
					$(this).closest("form").submit();
				}
			})

			$("#example-datatable tbody").on("click", ".unlock-me", function(){
				if(confirm("Reset Default Password For This Record! Are You Sure?")){
					$(this).closest("table").find("input[type='checkbox']").prop("checked",false);
					$(this).closest("tr").find("input[type='checkbox']").trigger("click");
					$(this).closest("form").find("[name='type_submit']").val("unlock");
					$(this).closest("form").submit();
				}
			})

			$("#example-datatable tbody").on("click", ".edit-me", function(){
				var modal_name 	= "."+$(this).data("modal-target");
				var editdata 	= $(this).data("editdata");
				$(modal_name).modal({keyboard:true});
				$(modal_name).find("input").not(":button, :submit, :reset, .not_autoset").val("").prop("checked",false);
				$(modal_name).find("select").prop("selected",false);
				$(modal_name).find("textarea").val("");
				$(modal_name).find('.help-block').remove();
				$(modal_name).find('.form-group').removeClass('has-success has-error');
				// console.log(editdata);
				$("#form-validation").setvalidation(editdata);
				$("#form-validation > [name='type_submit']").val("edit");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

			$("#val-roles").on("change",function(){
				// console.log(1);
				// alert(1);
				var val_this 	= $(this).val();
				var val_this 	= parseInt(val_this);
				if(val_this == 2){
					$(".approvedg1").show();
					$(".approvedg2").show();
				}
				else if(val_this == 5){
					$(".approvedg1").show();
					$(".approvedg2").hide();
				}
				else{
					$(".approvedg1").hide();
					$(".approvedg2").hide();
					$("[name='val-dg'][type='radio'][value='T']").trigger("click");
					$("#val-port").val("");
					// $("#form-validation").setvalidation('');
				}

				$(".subrole").hide();

				var t_val 	= val_this;
				var t_tgt 	= $("[name='val-subroles']");

				$.ajax({
					type		: "POST",
					data 		: "id="+t_val,
					url 		: "ajax.php?do=get_subroles",
					success 	: function(msg){

						t_tgt.empty();
						t_tgt.append("<option value='0'>-</option>");

						var code_default 	= t_tgt.data("myval");
						var obj = jQuery.parseJSON(msg);

						$.each(obj,function(a,b){
							var mydata 	= $(this);
							var code 	= $.trim(b[0]);
							var descr 	= $.trim(b[1]);

							t_tgt.append("<option value='"+code+"'>"+descr+"</option>");
						});

						$("option[value='"+code_default+"']",t_tgt).attr('selected','selected');
						t_tgt.trigger("change");
					}
				}).complete(function(){
					// if(val_this==2)
					// 	$("").show();
					// else
					// 	$(".subrole").show();
					// console.log($("option",t_tgt).length);
					if($("option",t_tgt).length>1)
						$(".subrole").show();
					// else
						// $(".subrole").hide();
				});


			});


        });

        </script>

	</div>