API tools faq
paste
Advertisement
gussuryo

test Disada

gussuryo
Jan 16th, 2019
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.33 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. if(!isset($_SESSION['user'])) {
  4. header('location:index.php'); }
  5. include "koneksi.php";
  6. ?>
  7.  
  8. <title>Data Warranty Claim</title>
  9. <link rel="stylesheet" href="assets/css/bootstrap.min.css">
  10. <script type="text/javascript" src="assets/js/jquery.js"></script>
  11. <script type="text/javascript" src="assets/js/bootstrap.min.js"></script>
  12. <link rel="stylesheet" href="assets/css/form-elements.css">
  13. <link rel="stylesheet" href="assets/css/bootstrap.css">
  14. <link rel="stylesheet" href="assets/css/style.css">
  15. <body>
  16. <div class="container">
  17. <div class="header">
  18. <a class="judul">Dinas Pengadaan TNI AU</a>
  19. </div>
  20. <nav class="navbar navbar-default navbar-static-top">
  21. <div class="container-fluid">
  22. <ul class="nav navbar-nav">
  23. <li><a href="menu.php">Home</a></li>
  24. <li class="dropdown">
  25. <li class="active"><a href="data_kontrak.php">Perkembangan Kontrak Data</a></li>
  26. <li><a href="data_warranty.php">Data Warranty Claim</a></li>
  27. <li><a href="data_bg.php">Bank Garansi</a></li>
  28. </ul>
  29. <ul class="nav navbar-nav navbar-right">
  30. <li><a href="#"><span class="glyphicon
  31. glyphicon-user"></span> </a></li>
  32. <li><a href="logout.php"><span
  33. class="glyphicon glyphicon-log-out"></span> Logout</a></li>
  34. </ul>
  35. </div>
  36. </nav>
  37.  
  38. <div class="row row-table">
  39. <br><br>
  40. <div class="container content"><div class="row">
  41. <div class="col-md-10 col-md-offset-1 col">
  42. <font face="georgia">
  43. <center><h4>Data Warranty Claim</h4></center>
  44. <br><br><br>
  45. <form method="post" name="form-pesan" class="form">
  46. <p align="right"><input name="input" size="35" type="text" placeholder="Masukkan Kata Kunci"/>&nbsp;&nbsp;<button class="btn btn-default btn-md" type="submit">Cari</button></p>
  47. </form>
  48. <br><br>
  49. <a href="pr_addWR.php"><button class="btn btn-info btn-md glyphicon glyphicon-plus-sign"> Tambah Data Warranty Claim</button></a>&nbsp;&nbsp;&nbsp;
  50. <br><br>
  51.  
  52. <?php
  53. include 'koneksi.php';
  54. if($_POST){?>
  55. <table class="table table-striped">
  56. <thead>
  57. <tr>
  58. <th>Nama PT</th>
  59. <th>No Kontrak / tgl kontrak</th>
  60. <th>Nama Barang</th>
  61. <th>No PN</th>
  62. <th>Jumlah</th>
  63. <th>Satuan</th>
  64. <th>Tindakan</th>
  65. <th>Nomor</th>
  66. <th>Jatuh Tempo</th>
  67. <th>Ket</th>
  68. </tr>
  69. </thead>
  70. </tbody>
  71. <?php
  72. include "koneksi.php";
  73. $input=@$_POST['input'];
  74. $q = "SELECT * from data_warranty where nama_pt like '%$input%' or no_kontrak like '%$input%' or tgl_kontrak like '%$input%' or no_pn like '%$input%'"; //query to get the search result -->
  75. $tampil = mysql_query($q);
  76. while($data= mysql_fetch_array($tampil))
  77. {
  78. echo'<tr>';
  79. $nama_pt = $data[1];
  80. $no_kontrak = $data[2];
  81. $tgl_kontrak = $data[3];
  82. $nama_barang = $data[4];
  83. $no_pn = $data[5];
  84. $jumlah = $data[6];
  85. $satuan = $data[7];
  86. $tindakan = $data[8];
  87. $nomor = $data[9];
  88. $jatuh_tempo = $data[10];
  89. $ket = $data[11];
  90. print("<td>$nama_pt</td>");
  91. print("<td>$no_kontrak / $tgl_kontrak</td>");
  92. print("<td>$nama_barang</td>");
  93. print("<td>$no_pn</td>");
  94. print("<td>$jumlah</td>");
  95. print("<td>$satuan</td>");
  96. print("<td>$tindakan</td>");
  97. print("<td>$nomor</td>");
  98. print("<td>$jatuh_tempo</td>");
  99. print("<td>$ket</td>");
  100. ?>
  101.  
  102. <td><a href="pr_editWR.php?id=<?php echo $data['id'];?>"><button class="btn btn-success btn-sm glyphicon glyphicon-edit"> Edit</button></a></td>
  103. <td><a href="pr_deleteWR.php?id=<?php echo $data['id'];?>" onclick="return confirm('Apakah Anda yakin ingin Delete data?')"><button class="btn btn-danger btn-sm glyphicon glyphicon-erase"> Delete</button></a></td>
  104. <?php
  105. echo'</tr>';
  106. }?></tbody></table><br><br><br>
  107. <center><button class="btn btn-info btn-md" onClick="history.go(-1);">Kembali</button></a></center></font>
  108. <br><br><br>
  109. <?php
  110. }
  111. else
  112. {
  113. ?>
  114. <table border="1" class="table table-striped">
  115. <thead>
  116. <tr>
  117. <th rowspan="2">No</th>
  118. <th rowspan="2">Nama <br>PT</th>
  119. <th rowspan="2">No Kontrak /<br>Tanggal</th>
  120. <th colspan ="4">Sucad yang diwarranty claim</th>
  121. <th rowspan="2">Tindakan Disada</th>
  122. <th rowspan="2">Nomor IP<br> W/C</th>
  123. <th rowspan="2">Jatuh<br> Tempo</th>
  124. <th rowspan="2">Ket</th>
  125. <th rowspan="2">Action</th>
  126. </tr>
  127. <tr>
  128. <th>Nama Barang</th>
  129. <th>Nomor PN</th>
  130. <th>Jumlah</th>
  131. <th>Satuan</th>
  132.  
  133. </tr>
  134. </thead>
  135. <tbody>
  136.  
  137. <?php
  138. include "koneksi.php";
  139. $tampil= mysql_query("select * from data_warranty");
  140. $total= mysql_num_rows($tampil);
  141. $halaman = 10;
  142. $page = isset($_GET["halaman"]) ? (int)$_GET["halaman"] : 1;
  143. $mulai = ($page>1) ? ($page * $halaman) - $halaman : 0;
  144. // $result = mysql_query("SELECT * FROM data_warranty");
  145. $total = mysql_num_rows($tampil);
  146. $pages = ceil($total/$halaman);
  147. $query = mysql_query("select * from data_warranty LIMIT $mulai, $halaman")or die(mysql_error);
  148. $no =$mulai+1;
  149. while($data= mysql_fetch_array($tampil))
  150. {
  151. echo'<tr>';
  152. // $id = $data[0];
  153. $nama_pt = $data[1];
  154. $no_kontrak = $data[2];
  155. $tgl_kontrak = $data[3];
  156. $nama_barang = $data[4];
  157. $no_pn = $data[5];
  158. $jumlah = $data[6];
  159. $satuan = $data[7];
  160. $tindakan = $data[8];
  161. $nomor = $data[9];
  162. $jatuh_tempo = $data[10];
  163. $ket = $data[11];
  164. // print("<td>$id</td>");
  165. echo '<td>'. $no++ . '</d>';
  166. print("<td>$nama_pt</td>");
  167. print("<td>$no_kontrak / $tgl_kontrak</td>");
  168. print("<td>$nama_barang</td>");
  169. print("<td>$no_pn</td>");
  170. print("<td>$jumlah</td>");
  171. print("<td>$satuan</td>");
  172. print("<td>$tindakan</td>");
  173. print("<td>$nomor</td>");
  174. print("<td>$jatuh_tempo</td>");
  175. print("<td>$ket</td>");
  176. ?>
  177.  
  178. <td>
  179. <a href="pr_editWR.php?id=<?php echo $data['id'];?>"><button class="btn btn-success btn-sm glyphicon glyphicon-edit"> Edit</button></a>
  180. <a href="pr_deleteWR.php?id=<?php echo $data['id'];?>" onclick="return confirm('Apakah Anda yakin ingin Delete data?')"><button class="btn btn-danger btn-sm glyphicon glyphicon-erase"> Delete</button></a>
  181. </td>
  182. <?php
  183. $today = strtotime(date('Y-m-d'));
  184. $dateend = strtotime($jatuh_tempo);
  185. $dateRange = $dateend-$today;
  186. $tempo = ($dateRange/24/60/60);
  187.  
  188. if ($tempo <= 30 && $tempo >= 1)
  189. {
  190. echo " <font color='red'>
  191. <font size=1>
  192. <b>Warning:
  193. Nama PT: " . $nama_pt .
  194. ", Nama Barang: " . $nama_barang .
  195. ", No Kontrak: " . $no_kontrak .
  196. ", Tempo tinggal: ". $tempo .
  197. " hari</b></font></font><br></a>";
  198. ?>
  199. <td>
  200. <a href= "tempo.php?id=<?php echo $data['id'];?>"></a>;
  201. }
  202. </td>
  203. <?php
  204. echo'</tr>';}
  205. ?>
  206. </tbody>
  207. </table>
  208. <?php
  209. }
  210. ?>
  211. <div class="">
  212. <?php for ($i=1; $i<=$pages ; $i++){ ?>
  213. Halaman <a href="?halaman=<?php echo $i; ?>"> <?php echo $i; ?></a>
  214.  
  215. <?php } ?>
  216. </font>
  217. </div></div></div></div>
  218. <br><br><br>
  219.  
  220. <div class="footer">
  221. <center>&copy; 2019. Designed by gusbowo03</center>
  222. </div>
  223. </div>
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!