One Hat Cyber Team
Your IP :
172.16.0.254
Server IP :
58.26.163.33
Server :
Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Server Software :
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
PHP Version :
7.3.25
Buat File
|
Buat Folder
Eksekusi
Dir :
C:
/
xampp7
/
htdocs
/
edgpens_220424
/
kod
/
Edit File:
kodDG.php
<?php if(empty($page)){ include("../access.php"); } ?> <?php $modal_name = str_replace("/", "-", $page); ?> <!-- Blank Header --> <div class="content-header"> <div class="row"> <div class="col-sm-6"> <div class="header-section"> <h1><i class="gi gi-skull"></i> DANGEROUS GOODS</h1> </div> </div> <div class="col-sm-6 hidden-xs"> <div class="header-section"> <!-- <ul class="breadcrumb breadcrumb-top"> --> <!-- <li>Extra Pages</li> --> <!-- <li><a href="">Blank</a></li> --> <!-- </ul> --> </div> </div> </div> </div> <!-- END Blank Header --> <!-- Get Started Block --> <div class="block full"> <!-- Get Started Title --> <!-- <div class="block-title"> <h2>Blank</h2> </div> --> <!-- [QUERY_STRING] --> <?php $success = 0; if($_POST): $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'])); $imo=$_POST['val-imo']; $un=$_POST['val-un']; $kpa=$_POST['val-kpa']; $prop=mysqli_real_escape_string($mysqli_link,$_POST['val-prop']); $flagAktif=$_POST['val-aktif']; if($do=="add"){ $qAdd="INSERT INTO kod_dg(UNNumber,IMOClass,nama,KPAGroup,properties,flagAktif) VALUES ('$un', '$imo', '$nama', '$kpa', '$prop', '$flagAktif')"; mysqli_query($mysqli_link,$qAdd) or die(mysqli_connect_error()); $success = 1; $msg = "RECORD ADDED!"; } if($do=="edit"){ $qEdit="UPDATE kod_dg SET UNNumber='$un', IMOClass='$imo', nama='$nama', KPAGroup='$kpa', properties='$prop', flagAktif='$flagAktif' WHERE idKodDG='$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_dg WHERE idKodDG='$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($success){ echo "<script>window.location.replace('index.php?page=kod/kodDG&success={$success}');</script>"; exit(); } ?> <?php ?> <div id="modal-form" class="modal fade <?php echo $modal_name;?>" tabindex="-1" role="dialog" aria-hidden="true"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <form class="push form-horizontal" id="form-validation" action="index.php?page=kod/kodDG" 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">×</span></button> <h4 class="modal-title"><strong>DANGEROUS GOODS</strong></h4> </div> <div class="modal-body"><!-- modal-body --> <div class="form-group"> <label class="col-md-3 control-label" for="val-name">Proper Name <span class="text-danger">*</span></label> <div class="col-md-8"> <input type="text" id="val-name" name="val-name" class="form-control validation" data-validation="default" placeholder="Proper Name.."> </div> </div> <div class="form-group"> <label class="col-md-3 control-label" for="val-imo">IMO Class <span class="text-danger">*</span></label> <div class="col-md-3"> <input type="text" id="val-imo" name="val-imo" class="form-control validation" data-validation="default" placeholder="IMO Class.."> </div> <label class="col-md-2 control-label" for="val-un">UN Number <span class="text-danger">*</span></label> <div class="col-md-3"> <input type="text" id="val-un" name="val-un" class="form-control validation" data-validation="default" placeholder="UN Number.."> </div> </div> <div class="form-group"> <label class="col-md-3 control-label" for="val-prop">Properties <span class="text-danger">*</span></label> <div class="col-md-8"> <textarea id="val-prop" name="val-prop" rows="5" class="form-control validation" data-validation="default" placeholder="Properties.."></textarea> </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><!-- [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: 30px;" class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox"><span></span></label></th> <th class="text-center" style="width: 30px;">ID</th> <th class="text-center">PROPER NAME</th> <th class="text-center" style="width: 30px;">IMO CLASS</th> <th class="text-center" style="width: 30px;">UN NUMBER</th> <th class="text-center">PROPERTIES</th> <th style="text-center 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_dg"; $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-name#$rowKod[nama]|" ."val-imo#$rowKod[IMOClass]|" ."val-un#$rowKod[UNNumber]|" ."val-prop#$rowKod[properties]|" ."val-id#$rowKod[idKodDG]|" ."val-aktif#$rowKod[flagAktif]"; ?> <tr> <td class="text-center"><label class="csscheckbox csscheckbox-primary"><input type="checkbox" name="myid[]" value="<?php echo $rowKod['idKodDG'];?>"><span></span></label></td> <td class="text-center"><?=$rowKod['idKodDG']?></td> <td><strong><?=$rowKod['nama']?></strong></td> <td class="text-center"><?=$rowKod['IMOClass']?></td> <td class="text-center"><?=$rowKod['UNNumber']?></td> <td><?=nl2br($rowKod['properties'])?></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").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(''); $("#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>
Simpan