API tools faq
paste
Guest User

transaksi.php

a guest
Feb 23rd, 2017
173
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.77 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include"config.php";
  3. $result = mysql_query("select * from kendaraan");
  4. $jsArray = "var tarifperJam = new Array();\n";
  5. ?>
  6. <html>
  7. <head>
  8. <title>Data Pelanggan Rental Mobil</title>
  9. <script type="text/javascript" src="jquery-1.7.2.min.js"></script>
  10. <link rel="stylesheet" href="css/style.css">
  11. </head>
  12. <body>
  13. <div align="left">
  14. <?php
  15. $aksi=$_GET['aksi'];
  16. if($aksi=="form")
  17. {
  18. //program pemilik form
  19. ?>
  20. </div>
  21. <h2 align="left">Input Data Transaksi Sewa</h2>
  22. <hr align="left" size="1">
  23. <form method="POST" action="transaksi_sewa1.php?aksi=simpan">
  24. <div align="center">
  25. <pre>
  26. No. Transaksi :<input type="text" name="noTransaksi" size="20">
  27.  
  28. No. KTP :<select name="noKTP">
  29. <?php
  30. $c=mysql_query("select * from pelanggan order by noKTP asc");
  31. while ($d=mysql_fetch_array($c)) {
  32. ?>
  33. <option value="<?php echo $d['noKTP'];?>"><?php echo "$d[noKTP]";?></option>
  34. <?php
  35. }
  36. ?>
  37. </select><br/>
  38. No. Polisi :<select name="noPol" onchange="changeValue(this.value)">
  39. <option selected="selected">-------</option>
  40. <?php
  41. while ($row = mysql_fetch_array($result)) {
  42. echo '<option value="' . $row['noPol'] . '">' . $row['noPol'] . '</option>';
  43. $jsArray .= "tarifperJam['" . $row['noPol'] . "'] = {satu:'" . addslashes($row['tarifperJam']) . "'};\n";
  44. }
  45. ?>
  46. </select><br/>
  47. ID Sopir :<select name="IDsopir">
  48. <?php
  49. $c=mysql_query("select * from sopir order by IDsopir asc");
  50. while ($d=mysql_fetch_array($c)) {
  51. ?>
  52. <option value="<?php echo $d['IDsopir'];?>"><?php echo "$d[IDsopir]";?></option>
  53. <?php
  54. }
  55. ?>
  56. </select><br/>
  57. Tanggal Pinjam :Tanggal&nbsp;<select name="hari">
  58. <?php
  59. for ($i=1;$i<=31;$i++) {
  60. ?>
  61. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  62. <?php
  63. }
  64. ?>
  65. </select>&nbsp;Bulan Ke.&nbsp;<select name="bulan">
  66. <?php
  67. for ($i=1;$i<=12;$i++) {
  68. ?>
  69. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  70. <?php
  71. }
  72. ?>
  73. </select>&nbsp;Tahun&nbsp;<select name="tahun">
  74. <?php
  75. $y=date("Y");
  76. for ($i=1998;$i<=$y;$i++) {
  77. ?>
  78. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  79. <?php
  80. }
  81. ?>
  82. </select><br/>
  83. Tanggal Kembali :Tanggal&nbsp;<select name="hari2">
  84. <?php
  85. for ($i=1;$i<=31;$i++) {
  86. ?>
  87. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  88. <?php
  89. }
  90. ?>
  91. </select>&nbsp;Bulan Ke.&nbsp;<select name="bulan2">
  92. <?php
  93. for ($i=1;$i<=12;$i++) {
  94. ?>
  95. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  96. <?php
  97. }
  98. ?>
  99. </select>&nbsp;Tahun&nbsp;<select name="tahun2">
  100. <?php
  101. $y=date("Y");
  102. for ($i=1998;$i<=$y;$i++) {
  103. ?>
  104. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  105. <?php
  106. }
  107. ?>
  108. </select><br/>
  109. Jam Pinjam :<select name="jamPinjam">
  110. <?php
  111. for ($i=1;$i<=24;$i++) {
  112. ?>
  113. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  114. <?php
  115. }
  116. ?>
  117. </select>&nbsp;:&nbsp;<select name="menit">
  118. <?php
  119. for ($i=1;$i<=59;$i++) {
  120. ?>
  121. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  122. <?php
  123. }
  124. ?>
  125. </select><br/>
  126. Jam Kembali :<select name="jamKembali">
  127. <?php
  128. for ($i=1;$i<=24;$i++) {
  129. ?>
  130. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  131. <?php
  132. }
  133. ?>
  134. </select>&nbsp;:&nbsp;<select name="menit">
  135. <?php
  136. for ($i=1;$i<=59;$i++) {
  137. ?>
  138. <option value="<?php echo $i?>"><?php echo "$i";?></option>
  139. <?php
  140. }
  141. ?>
  142. </select><br/>
  143. Lama Pinjam :<input type="text" name="lamaPinjam" size="25">
  144. Kerusakan :<textarea name="kerusakan" width="25" height="10"></textarea>
  145.  
  146. Biaya Kerusakan :&nbsp;Rp.&nbsp;<input type="text" name="biayaKerusakan" size="25"><br/>
  147. Tarif Per Jam :&nbsp;Rp.&nbsp;<input type="text" name="tarifperJam" id="tarifperJam" disabled="tarifPerjam" size="25">
  148. <script type="text/javascript">
  149. <?php echo $jsArray; ?>
  150. function changeValue(id){
  151. document.getElementById('tarifperJam').value = tarifperJam[id].satu;
  152. };
  153. </script>
  154. </pre>
  155. </div>
  156. <hr align="center" size="1">
  157. <table><tr>
  158. <td><div align="center">
  159. <input type="submit" value=" Simpan ">
  160. </div></td></form>
  161. <form method="POST" action="transaksi_sewa1.php?aksi=tampil">
  162. <td><div align="center">
  163. <input type="submit" value=" Batal">
  164. </div></td>
  165. <div align="center">
  166. </tr>
  167. </table>
  168. </div>
  169. </form>
  170. <div align="center">
  171. <?php
  172. }
  173. else if($aksi=="simpan")
  174. {
  175. //program pelanggan simpan
  176. include "config.php";
  177. $noTransaksi=$_POST['noTransaksi'];
  178. $noKTP=$_POST['noKTP'];
  179. $noPol=$_POST['noPol'];
  180. $IDsopir=$_POST['IDsopir'];
  181. $tglPinjam=$_POST['tglPinjam'];
  182. $tglKembali=$_POST['tglKembali'];
  183. $jamPinjam=$_POST['jamPinjam'];
  184. $jamKembali=$_POST['jamKembali'];
  185. $lamaPinjam=$_POST['lamaPinjam'];
  186. $kerusakan=$_POST['kerusakan'];
  187. $biayaKerusakan=$_POST['biayaKerusakan'];
  188. $tarif=$_POST['tarifperJam'];
  189. $idTransaksi=time();
  190. $sqlx="insert into transaksi_sewa values('$idTransaksi','$noTransaksi','$noKTP','$noPol','$IDsopir','$tglPinjam','$tglKembali','$jamPinjam','$jamKembali','$lamaPinjam','$tarif','$kerusakan','$biayaKerusakan')";
  191. $hasil=mysql_query($sqlx);
  192. $affected=mysql_affected_rows();
  193. if($affected>0){
  194. echo 'Save Successfull.';
  195. }else{
  196. echo 'Save Unsuccessfull.';
  197. }
  198. ?>
  199. </div>
  200. <meta http-equiv="refresh" content="1;url=transaksi_sewa1.php?aksi=tampil">
  201. <div align="center">
  202. <?php
  203. }
  204. else if($aksi=="hapus")
  205. {
  206. //diisi dengan hapus
  207. include "config.php";
  208. $id=$_GET['id'];
  209. $sql="select * from transaksi_sewa where noTransaksi='$id'";
  210. $result=mysql_query($sql);
  211. $data=mysql_fetch_array($result);
  212. ?>
  213. <h2>Hapus Data Transaksi</h2>
  214. <hr size="1">
  215. <form method="POST" action="transaksi_sewa1.php?aksi=delete">
  216. <pre>
  217. <input type="hidden" name="id" value="<?php echo $data['noTransaksi']?>">
  218. No. Transaksi : <?php echo $data['noTransaksi']?><br>
  219. No. KTP : <?php echo $data['noKTP']?><br>
  220. No. Polisi : <?php echo $data['noPol']?><br>
  221. Id Sopir : <?php echo $data['IDsopir']?><br>
  222. Tanggal Pinjam : <?php echo $data['tglPinjam']?><br>
  223. Tanggal Kembali : <?php echo $data['tglKembali']?><br>
  224. Jam Pinjam : <?php echo $data['jamPinjam']?><br>
  225. Jam Kembali : <?php echo $data['jamKembali']?><br>
  226. Lama Pinjam : <?php echo $data['lamaPinjam']?><br>
  227. Kerusakan : <?php echo $data['kerusakan']?><br>
  228. Biaya Kerusakan : <?php echo $data['biayaKerusakan']?><br>
  229. Tarif Perjam : <?php echo $data['tarifperJam']?><br>
  230. <?php $totBBM=($data['tarifperJam']*$data['lamaPinjam']+$data['biayaKerusakan'])?>
  231. Biaya Total BBM : <?php echo $totBBM?>
  232.  
  233. <hr size="1">
  234. <table><tr>
  235. <td><input type="submit" value=" Hapus "></td></form>
  236. <form method="POST" action="transaksi_sewa1.php?aksi=tampil">
  237. <td><input type="submit" value=" Batal"></td></tr>
  238. </table></form>
  239. <?php
  240. }
  241.  
  242. else if($aksi=="delete")
  243. {
  244. //diisi dengan delete
  245.  
  246. include "config.php";
  247. $id=$_POST['id'];
  248. $sqlx="delete from transaksi_sewa where noTransaksi='$id'";
  249. $result=mysql_query($sqlx);
  250. $affected=mysql_affected_rows();
  251. if($affected>0){
  252. echo "Delete Successfull.";
  253. }else{
  254. echo "Delete Unsuccessfull.";
  255. }
  256. ?>
  257. <meta http-equiv="refresh" content="3;url=transaksi_sewa1.php?aksi=tampil">
  258. <?php
  259. }
  260. else if($aksi=="detail")
  261. {
  262. //program taransaksi_sewa detail
  263. include "config.php";
  264. $id=$_GET['id'];
  265. $sql="select * from transaksi_sewa order by idTransaksi='$id'";
  266. $result=mysql_query($sql);
  267. $data=mysql_fetch_array($result);
  268. ?>
  269. <center><h2>Detail Transaksi Sewa</h2></center>
  270. <hr size="1">
  271. <table>
  272. <pre>
  273. <input type="hidden" name="tarifPerjam" value="<?php echo $data['idTransaksi']?>" id="tarifperJam" onchange="changeValue(this.value)">
  274. No. Transaksi : <?php echo $data['noTransaksi']?><br>
  275. No. KTP : <?php echo $data['noKTP']?><br>
  276. No. Polisi : <?php while ($row = mysql_fetch_array($result)) {
  277. echo $data['noPol'];
  278. $jsArray .= "tarifperJam['" . $row['noPol'] . "'] = {satu:'" . addslashes($row['tarifperJam']) . "'};\n";
  279. } echo $data['noPol']?><br>
  280. Id Sopir : <?php echo $data['IDsopir']?><br>
  281. Tanggal Pinjam : <?php echo $data['tglPinjam']?><br>
  282. Tanggal Kembali : <?php echo $data['tglKembali']?><br>
  283. Jam Pinjam : <?php echo $data['jamPinjam']?><br>
  284. Jam Kembali : <?php echo $data['jamKembali']?><br>
  285. Lama Pinjam : <?php echo $data['lamaPinjam']?><br>
  286. Kerusakan : <?php echo $data['kerusakan']?><br>
  287. Biaya Kerusakan : <?php echo $data['biayaKerusakan']?><br>
  288. Tarif Perjam : <?php echo $data['tarifperJam'];?><br>
  289. <?php $totBBM=($data['tarifperJam']*$data['lamaPinjam'] +$data['biayaKerusakan'])?>
  290. <hr size="1">
  291. Biaya Total : <?php echo $totBBM?>
  292. </pre>
  293. <hr size="1">
  294. <tr>
  295. <td>
  296. <form method="POST" action="transaksi_sewa1.php?aksi=tampil">
  297. <td><input type="submit" value=" Kembali"></td>
  298. <td><input type="button" value=" Print " onclick="window.print()"></td>
  299. </table></form></tr>
  300.  
  301. <?php
  302.  
  303. }
  304.  
  305. else
  306. {
  307. //program pelanggan tampil
  308. include "config.php";
  309. ?>
  310. </div>
  311. <h2 align="left">Daftar Transaksi Sewa</h2>
  312. <div align="left">
  313. <table>
  314. <tr><form method="POST" action="transaksi_sewa1.php?aksi=form">
  315. <td><input type="submit" Value="+ Tambah Data "></td></tr>
  316. </table>
  317. </form>
  318. </div>
  319. <p align="center">
  320. <div align="center">
  321. <table border="0" cellpadding="5" cellspacing="1" width="100%">
  322. <tr>
  323. <th width="30">No.</th>
  324. <th width="50">No. Transaksi</th>
  325. <th width="100">Nama Pelanggan</th>
  326. <th>Alamat Pelanggan</th>
  327. <th width="100">Tanggal Transaksi</th>
  328. <th width="100">Status Transaksi</th>
  329. <th colspan="2">Action</th>
  330. </tr>
  331. <?php
  332. include "config.php";
  333. $batas=5;
  334. $halaman=$_GET['halaman'];
  335. if(empty($halaman))
  336. {
  337. $posisi=0;
  338. $halaman=1;
  339. }
  340. else
  341. {
  342. $posisi = ($halaman-1) * $batas;
  343. }
  344. $sql="select * from transaksi_sewa order by noTransaksi asc limit $posisi,$batas";
  345. $result=mysql_query($sql);
  346. $no=$posisi+1;
  347. $k=1;
  348. while($data=mysql_fetch_array($result)){
  349. $pes=$data['noKTP'];
  350. $p=mysql_query("select * from pelanggan where noKTP='$pes'");
  351. $pesek=mysql_fetch_array($p);
  352. IF($k % 2 ==0)
  353. {echo"<tr onmouseover=\" bgColor='#FDFC74'\" onmouseout=\"bgColor='#9FE2BF'\"bgcolor='#9FE2BF'>";}else{
  354. echo"<tr onmouseover=\" bgColor='#FDFC74'\" onmouseout=\"bgColor='#D6D6D6'\"bgcolor=#D6D6D6>";}
  355. ?>
  356. <td align="center"><?php echo $no?>.</td>
  357. <td><?php echo $data['noTransaksi']?></td>
  358. <td><?php echo $pesek['namaPelanggan']?></td>
  359. <td><?php echo $pesek['almPelanggan']?></td>
  360. <td><?php $tglPesan=date_default_timezone_set(UTC); echo $tglPesan ?><br></td>
  361. <td>Berhasil</td>
  362. <td width="50" align="center"><a href="transaksi_sewa1.php?aksi=detail&id=<?php echo $data['idTransaksi']?>">Detail</a></td>
  363. <td width="50" align="center"><a href="transaksi_sewa1.php?aksi=hapus&id=<?php echo $data['noTransaksi']?>">Hapus</a></td>
  364. </tr>
  365. <?php
  366. $no++;
  367. $k++;
  368. }
  369. ?>
  370. </table>
  371. </div>
  372. <p align="center">
  373. <div align="center">
  374. <table width="100%">
  375. <tr><td align="center">
  376. <?php
  377. $file="transaksi_sewa1.php";
  378. $tampil2="select * from transaksi_sewa order by idTransaksi asc";
  379. $hasil2=mysql_query($tampil2);
  380. $jmldata=mysql_num_rows($hasil2);
  381. $jmlhalaman=ceil($jmldata/$batas);
  382.  
  383. //link ke halaman sebelumnya (previous)
  384. if($halaman > 1)
  385. {
  386. $previous=$halaman-1;
  387. echo "<A HREF=$file?halaman=1&aksi=tampil><< First</A> |
  388. <A HREF=$file?halaman=$previous&aksi=tampil>< Previous</A> | ";
  389. }
  390. else
  391. {
  392. echo "<< First | < Previous | ";
  393. }
  394.  
  395. $angka=($halaman > 3 ? " ... " : " ");
  396. for($i=$halaman-2;$i<$halaman;$i++)
  397. {
  398. if ($i < 1)
  399. continue;
  400. $angka .= "<a href=$file?halaman=$i&aksi=tampil>$i</A> ";
  401. }
  402.  
  403. $angka .= " <b>$halaman</b> ";
  404. for($i=$halaman+1;$i<($halaman+3);$i++)
  405. {
  406. if ($i > $jmlhalaman)
  407. break;
  408. $angka .= "<a href=$file?halaman=$i&aksi=tampil>$i</A> ";
  409. }
  410.  
  411. $angka .= ($halaman+2<$jmlhalaman ? " ...
  412. <a href=$file?halaman=$jmlhalaman&aksi=tampil>$jmlhalaman</A> " : " ");
  413.  
  414. echo "$angka";
  415.  
  416. //link kehalaman berikutnya (Next)
  417. if($halaman < $jmlhalaman)
  418. {
  419. $next=$halaman+1;
  420. echo " | <A HREF=$file?halaman=$next&aksi=tampil>Next ></A> |
  421. <A HREF=$file?halaman=$jmlhalaman&aksi=tampil>Last >></A> ";
  422. }
  423. else
  424. {
  425. echo " | Next > | Last >>";
  426. }
  427. ?>
  428. </td></tr>
  429. </table>
  430. </div>
  431. <p align="center">
  432. <?php
  433. }
  434. ?>
  435. </body>
  436. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!