API tools faq
paste
Advertisement
Mista

Untitled

Mista
Aug 22nd, 2016
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.98 KB | None | 0 0
raw download clone embed print report
  1. <HTML>
  2. <HEAD><title>Sysco Krida Group</title>
  3.  
  4. <!-- JQUERY -->
  5. <script type="text/javascript" language="javascript" src="assets/media/js/jquery.js"></script>
  6.  
  7. <!-- BOOTSTRAP -->
  8. <!-- Latest compiled and minified CSS -->
  9. <link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
  10.  
  11. <!-- Optional theme -->
  12. <link rel="stylesheet" href="assets/bootstrap/css/bootstrap-theme.min.css">
  13.  
  14. <!-- Latest compiled and minified JavaScript -->
  15. <script src="assets/bootstrap/js/bootstrap.min.js"></script>
  16.  
  17. <!-- DataTables -->
  18. <link rel="stylesheet" type="text/css" href="assets/media/css/dataTables.bootstrap.css">
  19. <link rel="stylesheet" type="text/css" href="assets/media/css/dataTables.responsive.css">
  20. <script type="text/javascript" language="javascript" src="assets/media/js/jquery.dataTables.js"></script>
  21. <script type="text/javascript" language="javascript" src="assets/media/js/dataTables.responsive.js"></script>
  22. <script type="text/javascript" language="javascript" src="assets/media/js/dataTables.bootstrap.js"></script>
  23. <script type="text/javascript" language="javascript" src="assets/media/js/common.js"></script>
  24. <script type="text/javascript" language="javascript" >
  25.  
  26. var dTable;
  27. // #Example adalah id pada table
  28. $(document).ready(function() {
  29. dTable = $('#example').DataTable( {
  30. "bProcessing": true,
  31. "bServerSide": true,
  32. "bJQueryUI": false,
  33. "responsive": true,
  34. "sAjaxSource": "ku-server.php", // Load Data
  35. "sServerMethod": "POST",
  36. "columnDefs": [
  37. { "orderable": false,"targets": 0, "searchable": false },
  38. { "orderable": true, "targets": 1, "searchable": true },
  39. { "orderable": true, "targets": 2, "searchable": true },
  40. { "orderable": true, "targets": 3, "searchable": true },
  41. { "orderable": true, "targets": 4, "searchable": true }
  42.  
  43. ]
  44. } );
  45.  
  46. $('#example').removeClass( 'display' ).addClass('table table-striped table-bordered');
  47. $('#example tfoot th').each( function () {
  48.  
  49. //Agar kolom Action Tidak Ada Tombol Pencarian
  50. if( $(this).text() != "Action" ){
  51. var title = $('#example thead th').eq( $(this).index() ).text();
  52. $(this).html( '<input type="text" placeholder="Search '+title+'" class="form-control" />' );
  53. }
  54. } );
  55.  
  56. // Untuk Pencarian, di kolom paling bawah
  57. dTable.columns().every( function () {
  58. var that = this;
  59.  
  60. $( 'input', this.footer() ).on( 'keyup change', function () {
  61. that
  62. .search( this.value )
  63. .draw();
  64. } );
  65. } );
  66. } );
  67.  
  68.  
  69. </script>
  70. </HEAD>
  71. <BODY>
  72. <!--------------------------------------------------------------------------------------------------------------->
  73. <style type="text/css">
  74. .bs-example{
  75. margin: 20px;padding-top:10px;
  76. }
  77. .lol{height:63px;width:100%;background-color:#fff}
  78. .lil{height:80px;width:100%;background-color:#069}
  79. </style>
  80.  
  81. <div class="lol">
  82. <div class="bs-example">
  83. <ul class="nav nav-pills">
  84. <li class=""><a href="#"><img src="config/unnamed.jpg" height="30px" width="120px"></a></li>
  85. <li class=""><a href="#">Dasboard</a></li>
  86. <li><a href="karyawan.php">Karyawan</a></li>
  87. <li><a href="kendaraan.php">Kendaraan</a></li>
  88. <li><a href="supir.php">Supir</a></li>
  89. <li><a href="kupon.php">Kupon</a></li>
  90. <li class="dropdown">
  91. <a href="#" data-toggle="dropdown" class="dropdown-toggle">Laporan <b class="caret"></b></a>
  92. <ul class="dropdown-menu">
  93. <li><a href="claim.php">Claim BBM</a></li>
  94. <li class="divider"></li>
  95. <li><a href="pdi.php">Penjualan</a></li>
  96. </ul>
  97. </li>
  98. <li class="dropdown pull-right">
  99. <a href="#" data-toggle="dropdown" class="dropdown-toggle">Admin <b class="caret"></b></a>
  100. <ul class="dropdown-menu">
  101. <li><a href="#">Ganti Password</a></li>
  102. <li class="divider"></li>
  103. <li><a href="#">Keluar</a></li>
  104. </ul>
  105. </li>
  106. </ul>
  107. </div></div>
  108. <br>
  109. <!---------------------------------------------------------------------------------------------------------------->
  110. <div class="container-fluid">
  111. <div class="row">
  112. <div class="col-md-12">
  113. <button onClick="showModals()" class="btn btn-primary">Tambah Data</button>
  114. <br>
  115. <hr>
  116. <br>
  117. <table id="example" cellpadding="0" cellspacing="0" border="0" class="display" width="100%">
  118. <thead>
  119. <tr>
  120. <th>Action</th>
  121. <th>NO KUPON</th>
  122. <th>TANGGAL</th>
  123. <th>JAM</th>
  124. <th>NOPOL</th>
  125. <th>KM TERAKHIR</th>
  126. <th>LITER</th>
  127. <th>JENIS BBM</th>
  128. <th>CABANG</th>
  129.  
  130. </tr>
  131. </thead>
  132. <tbody>
  133. </tbody>
  134. <tfoot>
  135. <th>Action</th>
  136. <th>NO KUPON</th>
  137. <th>TANGGAL</th>
  138. <th>JAM</th>
  139. <th>NOPOL</th>
  140. <th>KM TERAKHIR</th>
  141. <th>LITER</th>
  142. <th>JENIS BBM</th>
  143. <th>CABANG</th>
  144. </tfoot>
  145. </table>
  146. </div>
  147. </div>
  148. </div>
  149. </div>
  150. <!-- Modal Popup -->
  151. <div class="modal fade" id="myModals" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  152. <div class="modal-dialog">
  153. <div class="modal-content">
  154. <div class="modal-header">
  155. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  156. <h4 class="modal-title" id="myModalLabel">Add Kendaraan</h4>
  157. </div>
  158. <div class="modal-body">
  159.  
  160. <div class="alert alert-danger" role="alert" id="removeWarning">
  161. <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>
  162. <span class="sr-only">Error:</span>
  163. Anda yakin ingin menghapus Kendaraan ini
  164. </div>
  165. <br>
  166. <form class="form-horizontal" id="formUser" >
  167.  
  168. <input type="hidden" class="form-control" id="idp" name="idp" style="text-transform:uppercase">
  169. <input type="hidden" class="form-control" id="type" name="type">
  170.  
  171. <div class="form-group">
  172. <label for="tgl" class="col-sm-3 control-label">Tanggal</label>
  173. <div class="col-sm-6">
  174. <?php $tgl=date("Y-m-d");?>
  175. <input name="tgl" id="tgl" type="text" class="form-control" autocomplete="off" readonly size="15" data-date-format="yyyy-mm-dd" value="<?php echo "$tgl"; ?>" >
  176. </div></div>
  177.  
  178. <div class="form-group">
  179. <label for="jam" class="col-sm-3 control-label">Jam</label>
  180. <div class="col-sm-6">
  181. <?php $jam=gmdate("H:i:s",time()+60*60*7);?>
  182.  
  183. <input name="jam" type="text" class="form-control" id="jam" autocomplete="off" size="15" readonly="readonly" value="<?php echo "$jam"; ?>" >
  184. </div></div>
  185.  
  186. <div class="form-group">
  187. <label for="nama" class="col-sm-3 control-label">Nama Supir</label>
  188. <div class="col-sm-5">
  189. <table width="385">
  190. <td>
  191. <?php
  192. include "config/koneksi.php";
  193. $result = mysqli_query($db,"select a.id,b.nik,b.nama,c.nopol from supir a, staff b, kendaraan c where a.nik=b.nik and a.nopol=c.nopol order by b.nama asc");
  194. $jsArray = "var lil= new Array();";
  195. echo'<select name="nama" id="nama" onchange="buset1(this.value)" class="form-control">';
  196. echo '<option>---- Pilih ---</option>';
  197. while ($row = mysqli_fetch_array($result)) {
  198. echo '<option value="' . $row['nama'] . '">' . $row['nama'] . '</option>';
  199. $jsArray .= "lil['" . $row['nama'] . "'] = {aa1:'" . addslashes($row['nik']) . "',bb1:'".addslashes($row['nopol'])."'};\n";
  200. }
  201. ?>
  202. </td>
  203. <td><input type="text" id="nik" name="nik" size="10" maxlength="10" class="form-control" value="" readonly/></td>
  204. <td><input type="text" id="nopol" name="nopol" size="10" maxlength="10" class="form-control" value="" readonly onKeyUp="sum();"/>
  205. <script type="text/javascript">
  206. <?php echo $jsArray; ?>
  207. function buset1(nama){
  208. document.getElementById('nik').value = lil[nama].aa1;
  209. document.getElementById('nopol').value = lil[nama].bb1;
  210. };
  211. </script>
  212. </td>
  213. </table>
  214. </div></div>
  215.  
  216.  
  217. <div class="form-group">
  218. <label for="km" class="col-sm-3 control-label">KM Terakhir</label>
  219. <div class="col-sm-5">
  220. <input type="text" class="form-control" id="km" name="km" onKeyPress="return goodchars(event,'0123456789',this)" >
  221. </div>
  222. </div>
  223.  
  224.  
  225. <div class="form-group">
  226. <label for="bbm" class="col-sm-3 control-label">Jenis BBM</label>
  227. <div class="col-sm-5"><table width="300"><td>
  228. <?php
  229. include "config/koneksi.php";
  230. $result = mysqli_query($db,"select bbm,harga from subsidi order by bbm asc");
  231. $jsArray = "var Tipe= new Array();";
  232. echo'<select name="bbm" id="bbm" onchange="document.getElementById(\'harga\').value = Tipe[this.value]" class="form-control">';
  233. echo '<option>---- Pilih ---</option>';
  234. while ($row = mysqli_fetch_array($result)) {
  235. echo '<option value="' . $row['bbm'] . '">' . $row['bbm'] . '</option>';
  236. $jsArray .= "Tipe['" . $row['bbm'] . "'] = '" . addslashes($row['harga']) . "';";
  237. }
  238. echo '</select>';?>
  239. </td>
  240. <td>
  241. <input type="text" id="harga" name="harga" size="10" maxlength="10" class="form-control" onKeyUp="sum();" />
  242. <script type="text/javascript">
  243. <?php echo $jsArray; ?> </script>
  244. </td>
  245. </table>
  246. </div>
  247. </div>
  248.  
  249. <div class="form-group">
  250. <label for="liter" class="col-sm-3 control-label">Liter</label>
  251. <div class="col-sm-6"><table><td>
  252. <input name="liter" type="text" class="form-control" id="liter" autocomplete="off" size="15" onKeyPress="return goodchars(event,'0123456789',this)" onKeyUp="sum();"></td><td><input name="total" type="text" class="form-control" id="total" autocomplete="off" size="15" readonly ></td></table>
  253.  
  254. </div>
  255. </div>
  256.  
  257. <div class="form-group">
  258. <label for="cabang" class="col-sm-3 control-label">Cabang</label>
  259. <div class="col-sm-6">
  260. <input type="text" class="form-control" id="cabang" name="cabang" style="text-transform:uppercase" >
  261. </div>
  262. </div>
  263. </form>
  264.  
  265. </div>
  266. <div class="modal-footer">
  267. <button type="button" onClick="submitUser()" class="btn btn-default" data-dismiss="modal">Submit</button>
  268. <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
  269. </div>
  270. </div>
  271. </div>
  272. </div>
  273.  
  274. <script>
  275.  
  276. //Tampilkan Modal
  277. function showModals( idp )
  278. {
  279. waitingDialog.show();
  280. clearModals();
  281.  
  282. // Untuk Eksekusi Data Yang Ingin di Edit atau Di Hapus
  283. if( idp )
  284. {
  285. $.ajax({
  286. type: "POST",
  287. url: "ku-proses.php",
  288. dataType: 'json',
  289. data: {idp:idp,type:"get"},
  290. success: function(res) {
  291. waitingDialog.hide();
  292. setModalData( res );
  293. }
  294. });
  295. }
  296. // Untuk Tambahkan Data
  297. else
  298. {
  299. $("#myModals").modal("show");
  300. $("#myModalLabel").html("Kupon Baru");
  301. $("#type").val("new");
  302. waitingDialog.hide();
  303. }
  304. }
  305.  
  306. //Data Yang Ingin Di Tampilkan Pada Modal Ketika Di Edit
  307. function setModalData( data )
  308. {
  309. $("#myModalLabel").html(data.idp);
  310.  
  311. $("#type").val("edit");
  312. $("#idp").val(data.idp);
  313. $("#tgl").val(data.tgl);
  314. $("#jam").val(data.jam);
  315. $("#nik").val(data.nopol);
  316. $("#nopol").val(data.nopol);
  317. $("#km").val(data.km);
  318. $("#bbm").val(data.bbm);
  319. $("#liter").val(data.liter);
  320. $("#total").val(data.total);
  321. $("#myModals").modal("show");
  322. }
  323.  
  324. //Submit Untuk Eksekusi Tambah/Edit/Hapus Data
  325. function submitUser()
  326. {
  327. var formData = $("#formUser").serialize();
  328. waitingDialog.show();
  329. $.ajax({
  330. type: "POST",
  331. url: "ku-proses.php",
  332. dataType: 'json',
  333. data: formData,
  334. success: function(data) {
  335. dTable.ajax.reload(); // Untuk Reload Tables secara otomatis
  336. waitingDialog.hide();
  337. }
  338. });
  339. }
  340.  
  341. //Hapus Data
  342. function deleteUser( idp )
  343. {
  344. clearModals();
  345. $.ajax({
  346. type: "POST",
  347. url: "ku-proses.php",
  348. dataType: 'json',
  349. data: {idp:idp,type:"get"},
  350. success: function(data) {
  351. $("#removeWarning").show();
  352. $("#myModalLabel").html("Hapus Kupon");
  353.  
  354. $("#type").val("delete");
  355. $("#idp").val(data.idp);
  356. $("#tgl").val(data.tgl).attr("disabled","true");
  357. $("#jam").val(data.jam).attr("disabled","true");
  358. $("#nik").val(data.nopol).attr("disabled","true");
  359. $("#nopol").val(data.nopol).attr("disabled","true");
  360. $("#km").val(data.km).attr("disabled","true");
  361. $("#bbm").val(data.bbm).attr("disabled","true");
  362. $("#liter").val(data.liter).attr("disabled","true");
  363. $("#total").val(data.total).attr("disabled","true");
  364. $("#cabang").val(data.cabang).attr("disabled","true");
  365. $("#myModals").modal("show");
  366. waitingDialog.hide();
  367. }
  368. });
  369. }
  370.  
  371. //Clear Modal atau menutup modal supaya tidak terjadi duplikat modal
  372. function clearModals()
  373. {
  374. $("#removeWarning").hide();
  375. $("#type").val("");
  376. $("#idp").val("").removeAttr( "disabled" );
  377. $("#tgl").val("").removeAttr( "disabled" );
  378. $("#jam").val("").removeAttr( "disabled" );
  379. $("#nik").val("").removeAttr( "disabled" );
  380. $("#nopol").val("").removeAttr( "disabled" );
  381. $("#km").val("").removeAttr( "disabled" );
  382. $("#bbm").val("").removeAttr( "disabled" );
  383. $("#liter").val("").removeAttr( "disabled" );
  384. $("#total").val("").removeAttr( "disabled" );
  385. $("#cabang").val("").removeAttr( "disabled" );
  386. }
  387. function sum() {
  388. var txtFirstNumberValue = document.getElementById('harga').value;
  389. var txtSecondNumberValue = document.getElementById('liter').value;
  390. var result = parseInt(txtFirstNumberValue) * parseInt(txtSecondNumberValue);
  391. if (!isNaN(result)) {
  392. document.getElementById('total').value = result;
  393. }
  394. }
  395.  
  396. </script>
  397.  
  398. </BODY>
  399. </HTML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!