Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
!test.php	2.49 KB	-rw-rw-rw-
audit_trail.php	13.96 KB	-rw-rw-rw-
blank_page.php	10.78 KB	-rw-rw-rw-
kodCP.php	10.09 KB	-rw-rw-rw-
kodCTU.php	10.04 KB	-rw-rw-rw-
kodDG.php	11.48 KB	-rw-rw-rw-
kodDimension.php	10.07 KB	-rw-rw-rw-
kodJenisKapal.php	10.09 KB	-rw-rw-rw-
kodJenisOps.php	10.09 KB	-rw-rw-rw-
kodJenisSyarikat.php	10.13 KB	-rw-rw-rw-
kodKapal.php	36.32 KB	-rw-rw-rw-
kodKapal_a.php	25.99 KB	-rw-rw-rw-
kodMF.php	11.21 KB	-rw-rw-rw-
kodNegara.php	11.29 KB	-rw-rw-rw-
kodPacking.php	10.09 KB	-rw-rw-rw-
kodPort.php	16.19 KB	-rw-rw-rw-
kodPortBAK.php	15.7 KB	-rw-rw-rw-
kodPort_a.php	11.6 KB	-rw-rw-rw-
kodSyarikat.php	17.4 KB	-rw-rw-rw-
kodSyarikat_a.php	13.09 KB	-rw-rw-rw-
kodWeight.php	10.05 KB	-rw-rw-rw-
menu_list.php	19.24 KB	-rw-rw-rw-
new_blank.php	1.43 KB	-rw-rw-rw-
userList.php	14.46 KB	-rw-rw-rw-
userListxx.php	18.53 KB	-rw-rw-rw-

Code Editor : kodSyarikat.php

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

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

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

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

<div class="block full">

<?php

$success 	= 0;
				if($_POST):

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

$id=$_POST['val-id'];
					$kod=strtoupper($_POST['val-code']);
					$nama=mysqli_real_escape_string($mysqli_link,strtoupper($_POST['val-name']));
					$alamat=mysqli_real_escape_string($mysqli_link,strtoupper($_POST['val-alamat']));
					$tel=$_POST['val-tel'];
					$fax=$_POST['val-fax'];
					$type=$_POST['val-type'];
					$flagAktif=$_POST['val-aktif'];

if($do=="add"){						
						$qAdd="INSERT INTO kod_syarikat (kod,nama,alamat,noTel,noFax,idJenisSyarikat,flagAktif,flagApprove) VALUES ('$kod', '$nama', '$alamat', '$tel', '$fax', '$type', '$flagAktif', 'Y')";
						mysqli_query($mysqli_link,$qAdd) or die(mysqli_connect_error());
					$success 	= 1;
					$msg = "RECORD ADDED!";
					}
					if($do=="edit"){						
						$qEdit="UPDATE kod_syarikat SET kod='$kod', nama='$nama', alamat='$alamat', noTel='$tel', noFax='$fax', idJenisSyarikat='$type', flagAktif='$flagAktif' WHERE idSyarikat='$id'";		
						mysqli_query($mysqli_link,$qEdit) or die(mysqli_connect_error());
					$success 	= 1;
					$msg = "RECORD UPDATED!";
					}
					if($do=="delete"){	
						foreach($_POST['myid'] as $value){						
							$qDelete="DELETE FROM kod_syarikat WHERE idSyarikat='$value'";	
							mysqli_query($mysqli_link,$qDelete) or die(mysqli_connect_error());
						}
					$success 	= 3;
					}

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

endif;

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

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

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

endif;

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

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

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

<div class="form-group">
							    <label class="col-md-3 control-label" for="val-name">Name <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-name" name="val-name" class="form-control validation" data-validation="default" placeholder="Name..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-alamat">Address <span class="text-danger">*</span></label>
							    <div class="col-md-8">
									<textarea id="val-alamat" name="val-alamat" rows="5" class="form-control validation" data-validation="default" placeholder="Address.."></textarea>
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-tel">Phone Number <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-tel" name="val-tel" class="form-control validation" data-validation="default" placeholder="Phone Number..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-fax">Fax Number <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <input type="text" id="val-fax" name="val-fax" class="form-control validation" data-validation="default" placeholder="Fax Number..">
							    </div>
							</div>
							<div class="form-group">
							    <label class="col-md-3 control-label" for="val-type">Company Type <span class="text-danger">*</span></label>
							    <div class="col-md-6">
							        <select id="val-type" name="val-type" class="form-control validation select-select2" data-validation="default" data-placeholder="Company Type..">
		                                <option></option>
								<?
								$qJenisSykt="SELECT idJenisSyarikat,nama FROM kod_jenis_syarikat WHERE flagAktif='Y' ORDER BY nama";
								$resJenisSykt=mysqli_query($mysqli_link, $qJenisSykt) or die(mysqli_connect_error());
								while($rowJenisSykt=mysqli_fetch_array($resJenisSykt)){
								?>
										<option value="<?=$rowJenisSykt['idJenisSyarikat']?>"><?=$rowJenisSykt['nama']?></option>
								<?}mysqli_free_result($resJenisSykt)?>
									</select>
							    </div>
							</div>

<div class="form-group">
								<label class="col-md-3 control-label" for="val-aktifL">Status <span class="text-danger">*</span></label>
								<div class="col-md-6">
								  <label class="radio-inline" for="val-aktifY">
									  <input type="radio" class="not_autoset default_radio" id="val-aktifY" name="val-aktif" value="Y" <?if($rowKod['flagAktif']=="Y"){?>checked<?}?>> Active
								  </label>
								  <label class="radio-inline" for="val-aktifT">
									  <input type="radio" class="not_autoset" id="val-aktifT" name="val-aktif" value="T" <?if($rowKod['flagAktif']=="T"){?>checked<?}?>> Inactive
								  </label>
								</div>
							</div>						
						</div>

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

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

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

if($rowPending['bil']!=0){
?>

<div id="faq1" class="panel-group">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <div class="panel-title">
                        <a class="accordion-toggle" data-toggle="collapse" data-parent="#faq1" href="#faq1_q1"><h4><span class="label label-danger">&nbsp;Pending Approval List (<strong><?=$rowPending['bil']?></strong>)&nbsp;</h4></span></a>
                    </div>
                </div>
                <div id="faq1_q1" class="panel-collapse collapse out">
                    <div class="panel-body">
        <div class="table-responsive">
            <table id="general-table" class="table table-striped table-condensed table-bordered table-vcenter">
                <thead>
                    <tr>
                        <th style="width: 80px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th>NAME</th>
							<th>ADDRESS</th>
							<th style="width: 90px;">#</th>
							<th>TYPE</th>
                        <th >APPLIED BY</th>
                        <th style="width: 100px;" class="text-center"><i class="fa fa-gear"></i></th>
                    </tr>
                </thead>
                <tbody>
<?
$qPendingList="SELECT a.*,b.nameUser FROM kod_syarikat a LEFT JOIN user_list b ON b.idUser = a.idUserApply WHERE a.flagApprove='N'";
$resPendingList=mysqli_query($mysqli_link, $qPendingList) or die(mysqli_connect_error());
while($rowPendingList=mysqli_fetch_array($resPendingList)){

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

?>
                    <tr>
                        <td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></td>
                        <td><strong><?=$rowPendingList['nama']?></strong></td>
							<td><?=nl2br($rowPendingList['alamat'])?></td>
							<td>
							<i class="fa fa-phone"></i>&nbsp;&nbsp;<?=$rowPendingList['noTel']?><BR>
							<i class="fa fa-fax"></i>&nbsp;&nbsp;<?=$rowPendingList['noFax']?>
							</td>
						<td><?=$rowKod2['nama']?></td>
						<td>
						<?=$rowPendingList['nameUser']?><BR>
						(<?=date("d-m-Y H:i:s", strtotime($rowPendingList['tarikhApply']))?>)
						</td>
                        <td class="text-center">
                            <a href="index.php?page=kod/kodSyarikat&do=approve&id=<?=$rowPendingList['idSyarikat']?>" data-toggle="tooltip" title="Approve" class="btn btn-effect-ripple btn-sm btn-info"><i class="fa fa-check"></i></a>
                            <a href="index.php?page=kod/kodSyarikat&do=xapprove&id=<?=$rowPendingList['idSyarikat']?>" data-toggle="tooltip" title="Not Approve" class="btn btn-effect-ripple btn-sm btn-warning"><i class="fa fa-times"></i></a>
                        </td>
                    </tr>
<?}mysqli_free_result($resPendingList)?>

</tbody>
			</table>
		</div>

</div>
                </div>
            </div>
		</div>
<?}?>

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th style="width: 40px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th>
							<th class="text-center" style="width: 40px;">ID</th>
							<th>NAME</th>
							<th>ADDRESS</th>
							<th style="width: 90px;">#</th>
							<th>TYPE</th>
							<th class="text-center" style="width: 80px;">STATUS</th>
							<th class="text-center no_sorting" style="width: 40px;"><i class="fa fa-flash"></i></th>
						</tr>
					</thead>
					<tbody>
					<?php
					$labels['Y']['class'] = "label-success";
					$labels['Y']['text'] = "Active";
					$labels['T']['class'] = "label-danger";
					$labels['T']['text'] = "Inactive";
					?>
					<?php 
						
						$qKod="SELECT * FROM kod_syarikat WHERE flagApprove='Y'";
						$resKod=mysqli_query($mysqli_link, $qKod) or die(mysqli_connect_error());
						while($rowKod=mysqli_fetch_array($resKod)){

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

// editdata seperti send get value, split by | 
							// cth : <namainput>#<value> | <namaselect>#<value>
							$editdata = "val-code#$rowKod[kod]|"
										."val-name#$rowKod[nama]|"
										."val-alamat#$rowKod[alamat]|"
										."val-tel#$rowKod[noTel]|"
										."val-fax#$rowKod[noFax]|"
										."val-type#$rowKod[idJenisSyarikat]|"
										."val-id#$rowKod[idSyarikat]|"
										."val-aktif#$rowKod[flagAktif]";

$qKod2="SELECT nama FROM kod_jenis_syarikat WHERE idJenisSyarikat='$rowKod[idJenisSyarikat]'";
						$resKod2=mysqli_query($mysqli_link, $qKod2) or die(mysqli_connect_error());
						$rowKod2=mysqli_fetch_array($resKod2);							
					?>
						<tr>
							<td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $rowKod['idSyarikat'];?>"><span></span></label></td>
							<td class="text-center"><?=$rowKod['idSyarikat']?></td>
							<td><strong><?=$rowKod['nama']?></strong></td>
							<td><?=nl2br($rowKod['alamat'])?></td>
							<td>
							<i class="fa fa-phone"></i>&nbsp;&nbsp;<?=$rowKod['noTel']?><BR>
							<i class="fa fa-fax"></i>&nbsp;&nbsp;<?=$rowKod['noFax']?>
							</td>
							<td><?=$rowKod2['nama']?></td>
							<?php $rand = $rowKod['flagAktif'] ?>
							<td class="text-center"><span class="label<?php echo ($labels[$rand]['class']) ? " " . $labels[$rand]['class'] : ""; ?>"><?php echo $labels[$rand]['text'] ?></span></td>
							<td class="text-center">
							<a href="javascript:void(0)" title="Edit Record" class="btn btn-effect-ripple btn-xs btn-success edit-me" data-modal-target="<?php echo $modal_name;?>" data-editdata="<?php echo $editdata;?>"><i class="fa fa-pencil"></i></a>
							<a href="javascript:void(0)" title="Delete Record" class="btn btn-effect-ripple btn-xs btn-danger del-me" data-val="<?php echo $i;?>"><i class="fa fa-times"></i></a>
							</td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>
			</form>
			</div>
		
		<script src="js/pages/formsValidation.js"></script>
        <script type="text/javascript">
        $(document).ready(function(){

$("#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>

${this.title}

Code Editor : kodSyarikat.php