API tools faq
paste
Advertisement
Guest User

checkdata.php

a guest
Jan 16th, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.35 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include "config.php";
  3. include "function.php";
  4. if (isset($_GET['page'])) {
  5. if ($_GET['page'] === 'view') {
  6. ?>
  7.  
  8. <?php
  9. // $q = "SELECT no_session FROM audit ORDER BY tanggal_audit DESC, no_session DESC";
  10. // $resultData = mysql_query($q);
  11. // $getData = mysql_fetch_array($resultData);
  12. ?>
  13. <!-- <script src="coba.js"></script>
  14. --> <div class="header">
  15. <h1 class="page-title">New Audit Session</h1>
  16. <ul class="breadcrumb">
  17. <li>Home </li>
  18. <li class="active">New Audit Session</li>
  19. </ul>
  20. </div>
  21. <div class="main-content">
  22. <!-- <ul class="nav nav-tabs">
  23. <li class="active"><a href="#procces1" data-toggle="tab">Process 1</a></li>
  24. <div class="pull-right col-lg-4">
  25. <label>Last SMS Number/ No. SMS Terakhir : <?php echo $getData['no_sms'] ?></label>
  26. </div>
  27. </ul> -->
  28.  
  29. <?php
  30. // $sms_a = $getData['no_sms'];
  31. // $sms_b = 1;
  32. // $hasilsms = $sms_a + $sms_b;
  33.  
  34. // echo $hasilsms;
  35.  
  36. // die("STOP");
  37. ?>
  38. <script src='javascript.js'></script>
  39.  
  40. <link rel="stylesheet" href="style.css">
  41. <div class="row">
  42. <div class="col-sm-12 col-md-12">
  43. <br/>
  44. <div class="panel panel-default">
  45. <a href="#widget1container" class="panel-heading" data-toggle="collapse"> Create Audit Session</a>
  46. <div id="widget1container" class="panel-body collapse in">
  47. <div class="box-body table-responsive">
  48. <div class="tab-pane active in" id="procces1">
  49. <form action="checkdata.php" name="audit" method="post" id="tab">
  50. <div class="col-lg-6">
  51. <div class="form-group">
  52. <label> No. Session </label>
  53. <input type="text" name="no_session" class="form-control" required="">
  54. </div>
  55. </div>
  56. <div class="col-lg-6">
  57. <div class="form-group">
  58. <label> Date </label>
  59. <input type="date" name="tanggal_audit" value="<?php
  60. date_default_timezone_set('Asia/Jakarta');
  61. echo date("Y-m-d"); ?>"
  62. class="form-control" required="">
  63. </div>
  64. </div>
  65.  
  66. <div class="col-lg-6">
  67. <div class="form-group">
  68. <label> Project Name </label>
  69. <select name="nama_proyek" class="form-control" required="">
  70. <option value="0">- Pilih Proyek -</option>
  71. <?php
  72. $prj = mysql_query("SELECT * FROM project order BY nama_project asc");
  73. while ($proj = mysql_fetch_array($prj)) {
  74. ?>
  75. <option value="<?php echo $proj['nama_project'] ?>"><?php echo $proj['nama_project'] ?></option>
  76. <?php } ?>
  77. </select>
  78. </div>
  79. </div>
  80. <div class="col-lg-6">
  81. <div class="form-group">
  82. <label> Auditor </label>
  83. <input type="text" name="auditor" value="<?php echo $get['uName'];?>" class="form-control" readonly="">
  84. </div>
  85. </div>
  86.  
  87. <br>
  88. <div class="col-lg-6">
  89. <div class="form-group">
  90. <div class="input-group">
  91. <label class="input-group-btn">
  92. <span class="btn btn-primary">
  93. <span class="fa fa-plus"></span>
  94. Add Photo <input type="file" name="foto1" style="display: none;" multiple>
  95. </span>
  96. </label>
  97. <input type="text" class="form-control" readonly>
  98. </div>
  99. </div>
  100. <div class="form-group">
  101. <label> No. Finding </label>
  102. <input type="text" name="no_finding" class="form-control" required="">
  103. </div>
  104. <!-- <hr{ clear:both; }>
  105. -->
  106. <div class="form-group">
  107. <label> Finding Description </label>
  108. <textarea name="deskripsi" rows="2" class="form-control"></textarea>
  109. </div>
  110. <div class="form-group">
  111. <label> Area </label>
  112. <input type="text" name="area" class="form-control" required="">
  113. </div>
  114. <div class="form-group">
  115. <label> PIC </label>
  116. <input type="text" name="pic" class="form-control" required="">
  117. </div>
  118. <div class="form-group">
  119. <label> Urgency </label>
  120. <select name="urgency" class="form-control" required="">
  121. <option value="HIGH">HIGH</option>
  122. <option value="MEDIUM">MEDIUM</option>
  123. <option value="LOW">LOW</option>
  124. </select>
  125. </div>
  126. <div class="form-group">
  127. <label> Follow Up Action Plan </label>
  128. <textarea name="action" rows="2" class="form-control"></textarea>
  129. </div>
  130. <div class="form-group">
  131. <label> Due Date </label>
  132. <input type="due_date" name="tanggal_buat" value="<?php
  133. date_default_timezone_set('Asia/Jakarta');
  134. echo date("Y-m-d"); ?>"
  135. class="form-control" required="">
  136. </div>
  137. <div class="form-group">
  138. <input type='button' onClick='terimainput()' value='Submit'>
  139. <input type='reset' value='Reset'>
  140. </div>
  141. </div>
  142.  
  143.  
  144. <div class="col-sm-12 col-md-12">
  145. <div class="panel panel-default" style="border-color: #337ab7;">
  146. <a href="#widget1container" class="panel-heading" data-toggle="collapse" style="background: #337ab7; border-color: #337ab7; color: white;"> Detail Of Session</a>
  147. <div id="widget1container" class="panel-body collapse in">
  148. <table class="table table-bordered table-striped" id="tabelinput">
  149. <thead>
  150. <tr>
  151. <th class="col-xs-1">#</th>
  152. <th class="col-lg-2">No. Finding</th>
  153. <th class="col-lg-2">Photo</th>
  154. <th class="col-lg-4">Description</th>
  155. <th class="col-lg-2">Area</th>
  156. <th class="col-lg-2">PIC</th>
  157. <th class="col-lg-2">Urgency</th>
  158. <th class="col-lg-4">Action Plan</th>
  159. <th class="col-lg-2">Due Date</th>
  160.  
  161. </tr>
  162. </thead>
  163. <tbody id="addProduct">
  164. <tr id="first" style="display:none">
  165. <td><input type="checkbox" class="checkbox"/></td>
  166. <td><input name="finding[]" type="text" class="form-control" required=""/></td>
  167. <td><input name="photo[]" type="text" class="form-control" required=""/></td>
  168. <td><input name="description[]" type="text" class="form-control col-lg-4" required=""</td>
  169. <td><input name="area[]" type="text" class="form-control" required=""/></td>
  170. <td><input name="pic[]" type="text" class="form-control" required=""/></td>
  171. <td><input name="urgency[]" type="text" class="form-control" required=""/></td>
  172. <td><input name="action[]" type="text" class="form-control col-lg-4" required=""/></td>
  173. <td><input name="due[]" type="text" class="form-control" required=""/></td>
  174. </tr>
  175. <tr id="empty"><td colspan="9" class="sys_align_center" >No Data / Tidak ada data</td></tr>
  176. </tbody>
  177. </table>
  178. <div class="col-lg-12">
  179. <div class="form-group">
  180. <button type="submit" onClick="return confirm('Are you sure to submit the data? You will not allowed to edit the submitted data later');" class="btn btn-primary" name="saveadd">Submit</button>
  181. <a href="view.php" class="btn btn-default" > Back</a>
  182. <input type="hidden" name="counter" id="counter">
  183. <input type="hidden" name="reqdata" id="reqdata">
  184. </div>
  185. </div>
  186. </form>
  187. </div>
  188. </div>
  189. </div>
  190. </div>
  191. </div>
  192. </div>
  193. <script>
  194. $('input[name=radioreq]').change(function () {
  195. var dt;
  196. dt = $('input[name="radioreq"]:checked').val();
  197. $('#reqdata').val(dt);
  198. // $("valreq").val(dt);
  199. // alert(dt);
  200. });
  201.  
  202. $("#request").change(function () {
  203. var dta;
  204. dta = $("#request").val();
  205. $('#reqdata').val(dta);
  206. // $("valreq").val(dt);
  207. // alert(dt);
  208. });
  209.  
  210. </script>
  211.  
  212. <?php
  213.  
  214. // $qPermis = "select DISTINCT checkdata, employee, users, complain, project, "
  215. // . "warehouse, workshop, `reset`, `add`, `delete`, download, print, price, "
  216. // . "flag, proses1, proses2 from permission where id_user = $get[oId]";
  217. // $rPermis = mysql_query($qPermis);
  218. // $dataPermis = mysql_fetch_array($rPermis);
  219. // $permisAdd = false;
  220.  
  221. // if(count($dataPermis) > 0){
  222. // if($dataPermis['add'] == '1'){
  223. // $permisAdd = true;
  224. // }
  225. // }
  226.  
  227. if (isset($_POST['saveadd']) && $permisAdd) {
  228.  
  229. $nama_proyek = $_POST['nama_proyek'];
  230.  
  231. $projid = mysql_query("SELECT * FROM project where nama_project = '$nama_proyek'");
  232. while ($projectid = mysql_fetch_array($projid)){
  233.  
  234. $pid = $projectid['id'];
  235.  
  236. if (false === $projectid) {
  237. echo mysql_error();
  238. }
  239. };
  240.  
  241. // echo "$pid";
  242.  
  243. $tgl_order = $_POST['tanggal_order'];
  244. $jam_sms = $_POST['jam_sms'];
  245. $no_sms = $_POST['no_sms'];
  246. $pemesan = $_POST['pemesan'];
  247. $nama_proyek = $_POST['nama_proyek'];
  248. $item = $_REQUEST['item'];
  249. $qty = $_REQUEST['qty'];
  250. $unit = $_REQUEST['unit'];
  251. $notes = $_POST['notes'];
  252. $reqs = $_POST['reqdata'];
  253. $status_pic = $_POST['status_pic'];
  254. $datenow = date("Y-m-d h:i:s");
  255. $cnt = $_POST['counter'];
  256.  
  257. for ($i = 0; $i < $cnt; $i++) {
  258. $sql = "insert into `purchasing` SET "
  259. . "`tanggal_order`='$tgl_order', "
  260. . "`no_sms`='$no_sms', "
  261. . "`jam_sms`='$jam_sms', "
  262. . "`pemesan`='$pemesan', "
  263. . "`projectid`='$pid', "
  264. . "`nama_proyek`='$nama_proyek', "
  265. . "`item`='$item[$i]', "
  266. . "`qty`='$qty[$i]', "
  267. . "`satuan`='$unit[$i]', "
  268. . "`notes`='$notes', "
  269. . "`request`='$reqs', "
  270. . "`status_pic`='$status_pic', "
  271. . "`createdby`='$get[uName]', "
  272. . "`created`='$datenow' ";
  273.  
  274. $resultq = mysql_query($sql);
  275. $newid = mysql_insert_id();
  276. }
  277. if ($resultq) {
  278. echo "<script>alert('Berhasil ditambah.')</script>";
  279. echo "<script type='text/javascript'>document.location='./index.php?pic=checkdata&page=print&id=$no_sms'; </script>";
  280. } else {
  281. echo "<script>alert('Gagal! tidak dapat ditambah.')</script>";
  282. }
  283. }
  284. }
  285.  
  286. } elseif ($_GET['page'] === "update") {
  287. ?>
  288.  
  289. <div class="header">
  290. <h1 class="page-title">Update Data</h1>
  291. <ul class="breadcrumb">
  292. <li>Home </li>
  293. <li class="active">Update Data</li>
  294. </ul>
  295. </div>
  296. <?php
  297. }
  298. ?>
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!