API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.38 KB | None | 0 0
raw download clone embed print report
  1. <section class="content-header">
  2. <h1>
  3. <b>Halaman Master Data Guru</b>
  4. <td>
  5. </td>
  6. </h1>
  7. <Br/>
  8. </section>
  9. <div class="col-md-3">
  10. <div class="box box-primary">
  11. <div class="box-body pad table-responsive">
  12. <table class="table table-bordered text-center">
  13.  
  14. <tr>
  15. <td>
  16.  
  17. <a name="guru" type="submit" c class="btn btn-block btn-primary tambah-guru" data-toggle="modal" data-target="#tambahguru"><i class="fa fa-user-plus""></i>&nbsp;Tambah Data Guru </a>
  18. </td>
  19.  
  20. </tr>
  21.  
  22. </table>
  23. </div>
  24. <!-- /.box -->
  25. </div>
  26. </div>
  27. <!-- /.col -->
  28.  
  29. <!-- Main content -->
  30.  
  31.  
  32. <!-- TABEL GURU -->
  33. <section class="content">
  34. <div class="row">
  35. <div class="col-xs-12">
  36. <div class="box">
  37.  
  38. <div class="box-header">
  39. <h3 class="box-title">Keterangan Data Semua Guru</h3>
  40. </div>
  41. <!-- /.box-header -->
  42. <div class="box-body table-responsive">
  43. <table id="example1" class="table table-bordered table-striped">
  44.  
  45. <thead>
  46. <tr>
  47. <th style="background-color: #00e7f7;">No</th>
  48. <th style="background-color: #00e7f7;">NIP</th>
  49. <th style="background-color: #00e7f7;">Nama Guru</th>
  50. <th style="background-color: #00e7f7;">No.Telp</th>
  51. <th style="background-color: #00e7f7;">Pelajaran</th>
  52. <th style="background-color: #00e7f7; text-align: center;" width="310px" align="text-center">Aksi</th>
  53. </tr>
  54. </thead>
  55. <tbody>
  56. <?php
  57. $no = 1;
  58.  
  59. $data = mysqli_query($kon,"SELECT * FROM guru LEFT JOIN pelajaran ON guru.kode_pelajaran = pelajaran.kode_pelajaran LEFT JOIN jk ON guru.kode_jk=jk.kode_jk");
  60. while($d = mysqli_fetch_array($data)){
  61.  
  62. ?>
  63. <tr>
  64.  
  65. <td><?php echo $no++; ?></td>
  66. <td><?php echo $d['nip']; ?></td>
  67. <td><?php echo $d['nama_guru']; ?></td>
  68. <td><?php echo $d['no_telp']; ?></td>
  69. <td><?php echo $d['nama_pelajaran']; ?></td>
  70.  
  71. <td align="center">
  72. <a style="cursor: pointer;" onclick="select_data('<?php echo $d['nip']?>',
  73. '<?php echo $d['nama_guru'] ?>',
  74. '<?php echo $d['jk'] ?>',
  75. '<?php echo $d['alamat'] ?>',
  76. '<?php echo $d['no_telp'] ?>',
  77. '<?php echo $d['nama_pelajaran'] ?>',
  78. '<?php echo $d['password'] ?>'
  79. )" data-toggle="modal" data-target="#modal-detail-guru" class="btn btn-info"> <i class="fa fa-eye"> Detail Data</i></a>
  80.  
  81. <a style="cursor: pointer;" onclick="select_data2('<?php echo $d['nip']?>',
  82. '<?php echo $d['nama_guru'] ?>',
  83. '<?php echo $d['jk'] ?>',
  84. '<?php echo $d['alamat'] ?>',
  85. '<?php echo $d['no_telp'] ?>',
  86. '<?php echo $d['nama_pelajaran'] ?>',
  87. '<?php echo $d['password'] ?>'
  88. )" data-toggle="modal" data-target="#modal-edit-guru" class="btn btn-warning"> <i class="fa fa-edit"> Edit Data</i></a>
  89. <a href="hguru.php?nip=<?= $d['nip']?>" class="btn btn-danger hapus">
  90. <i class="fa fa-trash"></i> Hapus Data</a>
  91.  
  92.  
  93.  
  94. </td>
  95. </tr>
  96. <?php }?>
  97.  
  98. </table>
  99. </div>
  100. <!-- /.box-body -->
  101. </div>
  102. <!-- /.box -->
  103. </div>
  104. <!-- /.col -->
  105. </div>
  106. <!-- /.row -->
  107. </section>
  108.  
  109. <?php
  110. $query = mysqli_query($kon, "SELECT max(nip) as idMaks FROM guru") ;
  111. $data = mysqli_fetch_array($query);
  112. $nim = $data['idMaks'];
  113. $noUrut = (int) substr($nim, 6, 3);
  114. $noUrut++;
  115. $char = "NIP055";
  116. $IDbaru = $char . sprintf("%03s", $noUrut);
  117. ?>
  118. <!-- MODAL TAMBAH DATA -->
  119. <div class="modal fade" id="tambahguru" role="dialog">
  120. <div class="modal-dialog">
  121. <div class="modal-content">
  122. <div class="modal-header">
  123. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  124. <span aria-hidden="true">&times;</span></button>
  125. <h4 class="modal-title" ><i class="fa fa-user-plus"></i>&nbsp;Tambah Data Guru</h4>
  126. </div>
  127. <form action="aksi_guru.php" method="POST" enctype="multipart/form-data">
  128. <div class="modal-body">
  129.  
  130. <div class="form-group col-md-6" >
  131. <label>Nomor Induk Pendidikan</label>
  132.  
  133. <div class="input-group date" >
  134. <div class="input-group-addon">
  135. <i class="fa fa-plus-square"></i>
  136. </div>
  137. <input type="text" name="nip" class="form-control pull-right" id="datepicker" value="<?php echo $IDbaru ?>" readonly>
  138. </div>
  139. <!-- /.input group -->
  140. </div>
  141.  
  142. <div class="form-group col-md-6">
  143. <label>Nama Guru</label>
  144.  
  145. <div class="input-group">
  146. <div class="input-group-addon">
  147. <i class="fa fa-file-text-o"></i>
  148. </div>
  149. <input type="text" name="nama_guru" class="form-control pull-right" id="reservation">
  150. </div>
  151. <!-- /.input group -->
  152. </div>
  153. <!-- /.form group -->
  154.  
  155. <!-- Date and time range -->
  156. <div class="form-group col-md-6">
  157. <label>Jenis Kelamin</label>
  158.  
  159. <div class="input-group date">
  160. <div class="input-group-addon">
  161. <i class="fa fa-plus-square"></i>
  162. </div>
  163. <select name="kode_jk" class="form-control">
  164. <option value="">--Pilih--</option>
  165. <?php
  166. include 'koneksi.php';
  167. $kp = mysqli_query($kon,"SELECT * FROM jk");
  168. while ($kode_p = mysqli_fetch_array($kp))
  169. {
  170. echo "<option value='$kode_p[kode_jk]'>$kode_p[jk]</option>";
  171. }
  172. ?>
  173. </select>
  174. </div>
  175. </div>
  176.  
  177. <div class="form-group col-md-6">
  178. <label>Alamat</label>
  179.  
  180. <div class="input-group">
  181. <div class="input-group-addon">
  182. <i class="fa fa-file-text"></i>
  183. </div>
  184. <input type="text" name="alamat" class="form-control pull-right" id="reservation">
  185. </div>
  186. <!-- /.input group -->
  187. </div>
  188.  
  189. <div class="form-group col-md-6">
  190. <label>No.Telepon</label>
  191. <div class="input-group date">
  192. <div class="input-group-addon">
  193. <i class="fa fa-plus-square"></i>
  194. </div>
  195. <input type="number" name="no_telp" class="form-control pull-right" id="datepicker" maxlength="13" minlength="13">
  196. </div>
  197. </div>
  198.  
  199. <div class="form-group col-md-6">
  200. <label>Kode Pelajaran</label>
  201.  
  202. <div class="input-group date">
  203. <div class="input-group-addon">
  204. <i class="fa fa-plus-square"></i>
  205. </div>
  206. <select name="kode_pelajaran" class="form-control">
  207. <option value="">--Pilih--</option>
  208. <?php
  209. include 'koneksi.php';
  210. $kp = mysqli_query($kon,"SELECT * FROM pelajaran");
  211. while ($kode_p = mysqli_fetch_array($kp))
  212. {
  213. echo "<option value='$kode_p[kode_pelajaran]'>$kode_p[nama_pelajaran]</option>";
  214. }
  215. ?>
  216. </select>
  217. </div>
  218. </div>
  219.  
  220. <div class="form-group col-xs-12 ">
  221. <label>Password</label>
  222.  
  223. <div class="input-group date">
  224. <div class="input-group-addon">
  225. <i class="fa fa-plus-square"></i>
  226. </div>
  227. <input type="text" name="password" class="form-control pull-right" id="datepicker">
  228. </div>
  229. <!-- /.input group -->
  230. </div>
  231. </div>
  232. <div class="modal-footer">
  233. <button type="submit" name="simpan" class="btn btn-primary" id="simpan"><i class="fa fa-send-o "></i>&nbsp;TAMBAH DATA</button>
  234. </div>
  235. </form>
  236. </div>
  237. </div>
  238. </div>
  239.  
  240. <div class="modal fade" id="modal-edit-guru">
  241. <div class="modal-dialog">
  242. <div class="modal-content">
  243. <div class="modal-header">
  244. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  245. <span aria-hidden="true">&times;</span></button>
  246. <h4 class="modal-title"><i class="fa fa-user"></i> User Profil</h4>
  247. </div>
  248. <div class="content-header">
  249. <table cellpadding="5" cellspacing="0" border="1" width="100%" class="table table-bordered table-striped col-md-12">
  250. <tbody><tr><td>Kode NIP (Nomor Induk Pegawai)</td>
  251. <td><input type="text" name="nip" class="form-control" id="knip" readonly="true" >
  252.  
  253. <tr><td>Nama Guru</td>
  254. <td><input type="text" class="form-control" readonly="true" id="knama_guru" name="nama_guru"></td>
  255.  
  256. <tr><td>Jenis Kelamin</td>
  257. <td><input type=" text" class="form-control" readonly="true" id="kjk" name="jk"></td>
  258.  
  259. <tr><td>Alamat</td>
  260. <td><input type="textarea" class="form-control" readonly="true" id="kalamat" name="alamat"></td>
  261.  
  262. <tr><td>No Telp.</td>
  263. <td><input type=" text" class="form-control" readonly="true" id="kano_telp" name="no_telp"></td>
  264.  
  265. <tr><td>Pelajaran</td>
  266. <td><input type=" text" class="form-control" readonly="true" id="knama_pelajaran" name="nama_pelajaran"></td>
  267.  
  268. <tr><td>Password</td>
  269. <td><input type=" text" class="form-control" readonly="true" id="kpassword" name="password"></td>
  270. </tr>
  271.  
  272. </tbody></table>
  273. <div class="modal-footer">
  274.  
  275. </div>
  276. </div>
  277. <!-- /.modal-content -->
  278. </div>
  279. <!-- /.modal-dialog -->
  280. </div>
  281.  
  282.  
  283. <!-- modal detail data guru -->
  284. <div class="modal fade" id="modal-detail-guru">
  285. <div class="modal-dialog">
  286. <div class="modal-content">
  287. <div class="modal-header">
  288. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  289. <span aria-hidden="true">&times;</span></button>
  290. <h4 class="modal-title"><i class="fa fa-user"></i> User Profil</h4>
  291. </div>
  292. <div class="content-header">
  293. <table cellpadding="5" cellspacing="0" border="1" width="100%" class="table table-bordered table-striped col-md-12">
  294. <tbody><tr><td>Kode NIP (Nomor Induk Pegawai)</td>
  295. <td><input type="text" name="nip" class="form-control" id="knip" readonly="true" >
  296.  
  297. <tr><td>Nama Guru</td>
  298. <td><input type="text" class="form-control" readonly="true" id="knama_guru" name="nama_guru"></td>
  299.  
  300. <tr><td>Jenis Kelamin</td>
  301. <td><input type=" text" class="form-control" readonly="true" id="kjk" name="jk"></td>
  302.  
  303. <tr><td>Alamat</td>
  304. <td><input type="textarea" class="form-control" readonly="true" id="kalamat" name="alamat"></td>
  305.  
  306. <tr><td>No Telp.</td>
  307. <td><input type=" text" class="form-control" readonly="true" id="kano_telp" name="no_telp"></td>
  308.  
  309. <tr><td>Pelajaran</td>
  310. <td><input type=" text" class="form-control" readonly="true" id="knama_pelajaran" name="nama_pelajaran"></td>
  311.  
  312. <tr><td>Password</td>
  313. <td><input type=" text" class="form-control" readonly="true" id="kpassword" name="password"></td>
  314. </tr>
  315.  
  316. </tbody></table>
  317. <div class="modal-footer">
  318.  
  319. </div>
  320. </div>
  321. <!-- /.modal-content -->
  322. </div>
  323. <!-- /.modal-dialog -->
  324. </div>
  325.  
  326.  
  327.  
  328. <script type="text/javascript">
  329. function select_data($nip,$nama_guru,$jk,$alamat,$no_telp,$nama_pelajaran,$password){
  330. $("#knip").val($nip);
  331. $("#knama_guru").val($nama_guru);
  332. $("#kjk").val($jk);
  333. $("#kalamat").val($alamat);
  334. $("#kano_telp").val($no_telp);
  335. $("#knama_pelajaran").val($nama_pelajaran);
  336. $("#kpassword").val($password);
  337. }
  338. function select_data2($nip,$nama_guru,$jk,$alamat,$no_telp,$nama_pelajaran,$password){
  339. $("#knip").val($nip);
  340. $("#knama_guru").val($nama_guru);
  341. $("#kjk").val($jk);
  342. $("#kalamat").val($alamat);
  343. $("#kano_telp").val($no_telp);
  344. $("#knama_pelajaran").val($nama_pelajaran);
  345. $("#kpassword").val($password);
  346. }
  347. </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!