API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2019
186
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.69 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include '../config.php';
  3.  
  4. session_start();
  5.  
  6. if($_SESSION['role'] !="in"){
  7. header("location:../login.php");
  8. }
  9. $sql2 = mysqli_query($con, "SELECT * FROM Inventori_Gudang ORDER BY kat_head ASC ;");
  10. $sql3 = mysqli_query($con, "SELECT * FROM project_table ORDER BY date_deliver ASC ;");
  11. $sql4 = mysqli_query($con, "SELECT * FROM budget_table ORDER BY bud_num ASC ;");
  12. ?>
  13. <!DOCTYPE html>
  14. <html lang="en">
  15. <head>
  16. <title>Modul Inventori Staff : Estimasi Proyek</title>
  17. <meta charset="utf-8">
  18. <meta name="viewport" content="width=device-width, initial-scale=1">
  19. <link rel="stylesheet" href="../css3/bootstrap.min.css">
  20. <link rel="stylesheet" href="../addfeat/featCss.css">
  21. <link href="../css3/dataTables.bootstrap.min.css" rel="stylesheet">
  22. <script src="../js/jquery.min.js"></script>
  23. <script src="../js3/bootstrap.min.js"></script>
  24. <script src="../js/popper.min.js"></script>
  25. <script src="../js/tooltip.min.js"></script>
  26. </head>
  27. <body onload="startTime()">
  28.  
  29. <nav class="navbar navbar-default navbar-fixed-top">
  30. <div class="container-fluid">
  31. <div class="navbar-header">
  32. <a class="navbar-brand" href="#menu" id="menu">Modul Inventori</a>
  33. </div>
  34. <ul class="nav navbar-nav">
  35. <li><a href="index_utama.php">Laman Utama</a></li>
  36. <li class="dropdown"><a class="dropdown-toggle" data-toggle="dropdown" href="#">Aktivitas <span class="caret"></span></a>
  37. <ul class="dropdown-menu">
  38. <li><a href="perencanaan.php">Perencanaan Inventori</a></li>
  39. <li><a href="log_aktivitas.php">Histori Aktivitas</a></li>
  40. <li><a href="list_proyek.php">Histori Proyek</a></li>
  41. <li><a href="log_kom.php">Saran Eksternal</a></li>
  42. <li><a href="katalog_barang.php">Katalog Barang</a></li>
  43. <li><a href="stok_inventori.php">Stok Inventori</a></li>
  44. </ul>
  45. </li>
  46. </ul>
  47. <ul class="nav navbar-nav navbar-right">
  48. <p class="navbar-text" id="txt"></p>
  49. <p class="navbar-text">Halo, <?php echo $_SESSION['username']; ?></p>
  50. <li><a href="logout.php">Keluar</a></li>
  51. </ul>
  52. </div>
  53. </nav>
  54.  
  55.  
  56. <div id="page-content-container">
  57. <div class="container-fluid">
  58. <div class="row">
  59. <div class="col-lg-12">
  60. <br/>
  61. <br/>
  62. <center><h1>Prediksi Anggaran Proyek</h1></center>
  63. <br/>
  64. <center><p>Pada laman ini anda dapat melakukan prediksi anggaran proyek berdasarkan dari inventori yang ada.</p></center>
  65. <br/>
  66. <div class="container">
  67. <div class ="panel-group col-xs-4">
  68. <div class ="panel panel-default">
  69. <div class ="panel heading"><h4><center>Tambah Proyek</center></h4></div>
  70. <div class="panel-body">
  71. <center>
  72. <p>Pendataan Proyek</p>
  73. <button class="btn btn-default" data-toggle="modal" data-target="#myModal1">Tampilkan</button>
  74. </div>
  75. </div>
  76. </div>
  77. <div class ="panel-group col-xs-4">
  78. <div class ="panel panel-default">
  79. <div class ="panel heading"><h4><center>Entri Material</center></h4></div>
  80. <div class="panel-body">
  81. <center>
  82. <p>Entri Material dari Inventori</p>
  83. <button class="btn btn-default" data-toggle="modal" data-target="#myModal2">Tampilkan</button>
  84. </div>
  85. </div>
  86. </div>
  87. <div class ="panel-group col-xs-4">
  88. <div class ="panel panel-default">
  89. <div class ="panel heading"><h4><center>Fungsi Tambahan</center></h4></div>
  90. <div class="panel-body">
  91. <center>
  92. <p>Fungsi tambahan untuk flush basis data</p>
  93. <a href="flush_matPro.php" class="btn btn-danger">Flush</a>
  94. <button class="btn btn-danger" data-toggle="modal" data-target="#delModal">Delete</button>
  95. <a href="print_proyek.php" class="btn btn-primary">Print</a>
  96. </div>
  97. </div>
  98. </div>
  99. <div>
  100. <center><button class="btn btn-primary" id="popper-button">Generate</button>
  101. </div>
  102. <div id="poptable">
  103. <table class="table table-striped table-bordered">
  104. <thead>
  105. <tr>
  106. <th>Kode Proyek</th>
  107. <th>Kode Material</th>
  108. <th>Nama Material</th>
  109. <th>Besaran</th>
  110. <th>Harga Barang</th>
  111. <th>Tersedia</th>
  112. <th>Kebutuhan</th>
  113. <th>Jumlah Pembelian</th>
  114. <th>Biaya</th>
  115. </tr>
  116. </thead>
  117. <tbody>
  118. <?php
  119. include '../config.php';
  120. $test = mysqli_query($con,"SELECT * FROM budget_table");
  121. while($row = mysqli_fetch_array($test))
  122. {
  123. echo "<tr>
  124. <td>".$row['bud_proj_code']."</td>
  125. <td>".$row['mat_code']."</td>
  126. <td>".$row['mat_name']."</td>
  127. <td>".$row['mat_size']."</td>
  128. <td>".$row['mat_cost']."</td>
  129. <td>".$row['mat_ava']."</td>
  130. <td>".$row['mat_need']."</td>
  131. <td>".$row['mat_purc']."</td>
  132. <td>".$row['total_cost']."</td>
  133. </tr>";
  134. }
  135. ?>
  136. </tbody>
  137.  
  138. </table>
  139. </div>
  140. </div>
  141. </div>
  142. </div>
  143. <br/>
  144. <br/>
  145. </div>
  146. </div>
  147. </div>
  148. </div>
  149. <div class="modal fade" id="myModal1" role="dialog">
  150. <div class="modal-dialog modal-lg">
  151.  
  152. <div class="modal-content">
  153. <div class="modal-header">
  154. <button type="button" class="close" data-dismiss="modal">&times;</button>
  155. <h3 class="modal-title">Inisiasi Proyek</h3></div>
  156. <br/>
  157. <form role="form" method="post" onSubmit="return validasi()" action="tambah_proyek.php">
  158. <div class="row">
  159. <div class="form-group col-xs-4 col-xs-offset-4">
  160. <label for="kodeProyek">Kode Proyek:</label>
  161. <input type="text" class="form-control" id="kodeProyek" name="kodeProyek" placeholder="Isikan kode unik proyek baru">
  162. </div>
  163. </div>
  164. <div class="row">
  165. <div class="form-group col-xs-4 col-xs-offset-4">
  166. <label for="namaPengguna">End User:</label>
  167. <input type="text" class="form-control" id="namaPengguna" name="namaPengguna" placeholder="Isikan pengguna dari proyek ini">
  168. </div>
  169. </div>
  170. <div class="row">
  171. <div class="form-group col-xs-4 col-xs-offset-4">
  172. <label for="judulPekerjaan">Nama Proyek:</label>
  173. <textarea class="form-control" id="judulPekerjaan" rows="2" name="judulPekerjaan" placeholder="Spesifikan keperluan proyek"></textarea>
  174. </div>
  175. </div>
  176. <div class="row">
  177. <div class="form-group col-xs-4 col-xs-offset-4">
  178. <label for="lokasiProyek">Lokasi Proyek:</label>
  179. <input type="text" class="form-control" id="lokasiProyek" name="lokasiProyek" placeholder="Spesifikasikan lokasi proyek diadakan">
  180. </div>
  181. </div>
  182. <div class = "row">
  183. <div class="form-group col-xs-4 col-xs-offset-4">
  184. <label for="tanggalAkhir">Tanggal Kirim :</label>
  185. <input type="date" class="form-control" id="tanggalAkhir" name="tanggalAkhir">
  186. </div>
  187. </div>
  188. <div class = "row">
  189. <div class="form-group col-xs-4 col-xs-offset-4">
  190. <button name="submitPro" value="submitPro" type="submit" class="btn btn-primary">Submit</button>
  191. </div>
  192. </div>
  193. </form>
  194. <div class="modal-footer">Informasikan proyek yang akan diinisiasi.</div>
  195. </div>
  196. </div>
  197. </div>
  198.  
  199.  
  200. <div class="modal fade" id="myModal2" role="dialog">
  201. <div class="modal-dialog modal-lg">
  202.  
  203. <div class="modal-content">
  204. <div class="modal-header">
  205. <button type="button" class="close" data-dismiss="modal">&times;</button>
  206. <h3 class="modal-title">Entri Material</h3></div>
  207. <form class="modal-body" role="form" method="post" onSubmit="return validasi2()" action="material_proyek.php">
  208. <div class="row">
  209. <div class="form-group col-xs-4 col-xs-offset-4">
  210. <label for="kodMaterialPro">Material :</label>
  211. <select class="form-control" id="kodMaterialPro" name="kodMaterialPro">
  212. <option value="0">--- Pilih Material ---</option>
  213. <?php if(mysqli_num_rows($sql2) > 0){ ?>
  214. <?php while ($row = mysqli_fetch_array($sql2)){ ?>
  215. <option value="<?php echo $row['item_id']?>|<?php echo $row['available_stock']?>"><?php echo $row['item_id'] ?> - <?php echo $row['item_name'] ?> - (<?php echo $row['size_detail'] ?>) - [<?php echo $row['available_stock'] ?>]</option>
  216. <?php } ?>
  217. <?php } ?>
  218. </select>
  219. </div>
  220. </div>
  221. <div class="row">
  222. <div class="form-group col-xs-4 col-xs-offset-4">
  223. <label for="jmlNeed">Jumlah yang dibutuhkan :</label>
  224. <input type="number" class="form-control" id="jmlNeed" name="jmlNeed" min="0" placeholder="Jumlah barang yang dibutuhkan">
  225. </div>
  226. </div>
  227. <div class="row">
  228. <div class="form-group col-xs-4 col-xs-offset-4">
  229. <label for="proTujuan">Proyek yang dituju :</label>
  230. <select class="form-control" id="proTujuan" name="proTujuan">
  231. <option value="0">--- Pilih Proyek ---</option>
  232. <?php if(mysqli_num_rows($sql3) > 0){ ?>
  233. <?php while ($row = mysqli_fetch_array($sql3)){ ?>
  234. <option value="<?php echo $row['proj_code']?>|<?php echo $row['user_comp'] ?>|<?php echo $row['job_title'] ?>"><?php echo $row['proj_code']?> - <?php echo $row['user_comp'] ?> - <?php echo $row['job_title'] ?></option>
  235. <?php } ?>
  236. <?php } ?>
  237. </select>
  238. </div>
  239. </div>
  240. <div class = "row">
  241. <div class="form-group col-xs-4 col-xs-offset-4">
  242. <button type="submit" name="masukanX" value ="masukanX" class="btn btn-primary">Masukan</button>
  243. </div>
  244. </div>
  245. </form>
  246. <div class="modal-footer">Silakan pilih material dari inventori dan masukan stok tambahan yang masuk.</div>
  247. </div>
  248. </div>
  249. </div>
  250.  
  251.  
  252. <div class="modal fade" id="delModal" role="dialog">
  253. <div class="modal-dialog modal-lg">
  254.  
  255. <div class="modal-content">
  256. <div class="modal-header">
  257. <button type="button" class="close" data-dismiss="modal">&times;</button>
  258. <h3 class="modal-title">Hapus Material Proyek</h3></div>
  259. <form class="modal-body" role="form" method="post" onSubmit="return validasi4()" action="delete_inventori.php">
  260. <div class="row">
  261. <div class="form-group col-xs-4 col-xs-offset-4">
  262. <label for="kodbudDel">Material:</label>
  263. <select class="form-control" id="kodbudDel" name="kodbudDel">
  264. <option value="0">--- Pilih Material ---</option>
  265. <?php if(mysqli_num_rows($sql4) > 0){ ?>
  266. <?php while ($row = mysqli_fetch_array($sql4)){ ?>
  267. <option value="<?php echo $row['bud_num']?>"><?php echo $row['bud_proj_code']?> - <?php echo $row['bud_proj_title'] ?> - <?php echo $row['mat_detail'] ?>)</option>
  268. <?php } ?>
  269. <?php } ?>
  270. </select>
  271. </div>
  272. </div>
  273. <div class="row">
  274. <div class="form-group col-xs-4 col-xs-offset-4">
  275. <label for="komx">Perihal Penghapusan :</label>
  276. <textarea type="text" class="form-control" id="komx" name="komx" placeholder="Alasan penghapusan material proyek"></textarea>
  277.  
  278. </div>
  279. </div>
  280. <div class = "row">
  281. <div class="form-group col-xs-4 col-xs-offset-4">
  282. <button type="submit" name="delButton1" value ="delButton1" class="btn btn-primary">Masukan</button>
  283. </div>
  284. </div>
  285. </form>
  286. <div class="modal-footer">Silakan pilih material dari tabel proyek, dan sertakan alasannya.</div>
  287. </div>
  288. </div>
  289. </div>
  290.  
  291. </body>
  292. </html>
  293.  
  294. <script>
  295. var hidden=true;
  296. $(document).ready(function(){
  297. var ref = $('#popper-button');
  298. var popup = $('#poptable');
  299. popup.hide();
  300. ref.click(function(){
  301.  
  302. if (hidden) {
  303. popup.show();
  304.  
  305. var popper = new Popper(ref,popup,{
  306. placement: 'bottom',
  307. onCreate: function(data){
  308. console.log(data);
  309. },
  310. modifiers: {
  311. flip: {
  312. behavior: ['left', 'right', 'top','bottom']
  313. },
  314. offset: {
  315. enabled: true,
  316. offset: '0,10'
  317. }
  318. }
  319. });
  320.  
  321. } else {
  322. popup.hide();
  323. }
  324. hidden=!hidden;
  325. });
  326. })
  327. </script>
  328.  
  329. <script type="text/javascript">
  330. function validasi() {
  331. var kodPro = document.getElementById("kodeProyek").value;
  332. var namPen = document.getElementById("namaPengguna").value;
  333. var judPek = document.getElementById("judulPekerjaan").value;
  334. var lokPro = document.getElementById("lokasiProyek").value;
  335. var tangAk = document.getElementById("tanggalAkhir").value;
  336. if (kodPro != "" && namPen!="" && judPek!="" && lokPro!="" && tangAk!="") {
  337. alert('data sedang diproses ke database.');
  338. return true;
  339. }else{
  340. alert('Harus diisi secara lengkap !');
  341. return false;
  342. }
  343. }
  344.  
  345. </script>
  346.  
  347. <script type="text/javascript">
  348. function validasi2() {
  349. var koMatP = document.getElementById("kodMaterialPro").value;
  350. var jmlNee = document.getElementById("jmlNeed").value;
  351. var proTuj = document.getElementById("proTujuan").value;
  352. if (koMatP != "" && jmlNee!="" && proTuj!="") {
  353. alert('data sedang diproses ke database.');
  354. return true;
  355. }else{
  356. alert('Harus diisi secara lengkap !');
  357. return false;
  358. }
  359. }
  360.  
  361. </script>
  362.  
  363. <script type="text/javascript">
  364. function validasi4() {
  365. var kodbudD = document.getElementById("kodbudDel").value;
  366. var komx = document.getElementById("komx").value;
  367. if (kodbudD != "" && komx!="") {
  368. alert('data sedang diproses ke database.');
  369. return true;
  370. }else{
  371. alert('Harus diisi secara lengkap !');
  372. return false;
  373. }
  374. }
  375.  
  376. </script>
  377.  
  378. <script>
  379. function startTime() {
  380. var today = new Date();
  381. var h = today.getHours();
  382. var m = today.getMinutes();
  383. var s = today.getSeconds();
  384. m = checkTime(m);
  385. s = checkTime(s);
  386. document.getElementById('txt').innerHTML =
  387. h + ":" + m + ":" + s;
  388. var t = setTimeout(startTime, 500);
  389. }
  390. function checkTime(i) {
  391. if (i < 10) {i = "0" + i}; // add zero in front of numbers < 10
  392. return i;
  393. }
  394. </script>
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!