One Hat Cyber Team

Edit File: userRole.php

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

<?php  
	$modal_name 	= str_replace("/", "-", $page);
?>

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

<div class="block full">
		


<?
$roles=$_POST['roles'];
$terminal=$_POST['terminal'];
?>
    
    <div class="block full">

<form action="index.php?page=utility/userRole" method="post" class="form-horizontal form-borderless">
		<div class="form-group form-actions">
			<label class="col-md-2 control-label" for="example-select2">Roles : </label>
			<div class="col-md-4">
				<select id="roles" name="roles" class="form-control" size="1" onchange="this.form.submit()">
					<option value="">Choose Role..</option>
<?
$qRoles="SELECT * FROM user_roles";
$resRoles=mysqli_query($mysqli_link, $qRoles) or die(mysqli_connect_error());
while($rowRoles=mysqli_fetch_array($resRoles)){
?>
					<option value="<?=$rowRoles['idRoles']?>" <?if($rowRoles['idRoles']==$roles){?>selected<?}?>><?=$rowRoles['nama']?></option>

<?}mysqli_free_result($resRoles)?>
				</select>
			</div>
		</div>

<?if($roles==2){//terminal?>
		<div class="form-group form-actions">
			<label class="col-md-2 control-label" for="example-select3">Marine Facility : </label>
			<div class="col-md-4">
				<select id="terminal" name="terminal" class="form-control" size="1" onchange="this.form.submit()">
					<option value="">Choose Marine Facility..</option>
<?
$qMF="SELECT * FROM kod_marine_facility";
$resMF=mysqli_query($mysqli_link, $qMF) or die(mysqli_connect_error());
while($rowMF=mysqli_fetch_array($resMF)){
?>
					<option value="<?=$rowMF['idMarineFacility']?>" <?if($rowMF['idMarineFacility']==$terminal){?>selected<?}?>><?=$rowMF['nama']?></option>

<?}mysqli_free_result($resMF)?>
				</select>
			</div>
		</div>

<?}?>

</div>

<?if($roles){?>

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete">
					<thead>
						<tr>
							
							<th class="text-center" style="width: 40px;">ID</th>
							<th>USERNAME</th>
							<th>NAME</th>
							<?if($roles==2){?>
							<th class="text-center">TERMINAL</th>
							<?}?>
							<th class="text-center" style="width: 80px;">STATUS</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($roles==2 AND $terminal){
						$samb=" AND idPelabuhan='$terminal'";
					}	
						$qKod="SELECT * FROM user_list WHERE idRoles='$roles' $samb";
						$resKod=mysqli_query($mysqli_link, $qKod) or die(mysqli_connect_error());
						while($rowKod=mysqli_fetch_array($resKod)){

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

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

$qKod2="SELECT nama FROM kod_marine_facility WHERE idMarineFacility='$rowKod[idPelabuhan]'";
						$resKod2=mysqli_query($mysqli_link, $qKod2) or die(mysqli_connect_error());
						$rowKod2=mysqli_fetch_array($resKod2);							
					?>
						<tr>
							
							<td class="text-center"><?=$rowKod['idUser']?></td>
							<td><strong><?=$rowKod['emailUser']?></strong></td>
							<td><?=$rowKod['nameUser']?></td>
							<?if($roles==2){?>
							<td class="text-center"><?=$rowKod2['nama']?></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>
							
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>
			</form>
			</div>
<?}?>

// '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).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", ".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');
				$("#form-validation").setvalidation(editdata);
				$("#form-validation > [name='type_submit']").val("edit");
				// console.log($._data($("#form-validation").get(0), "events"));
			});

});

</script>

</div>