endang_nuradi

anggota_koperasi_pkm

Jan 27th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.36 KB | None | 0 0
  1. <div class="row">
  2. <div class="col-md-10" style="margin-left:20px">
  3. <h2>Data Anggota</h2>
  4. </div>
  5. </div>
  6. <div class="panel-body">
  7. <ul class="breadcrumb">
  8. <i class="glyphicon glyphicon-home"> </i>
  9. <li><a href="index.php" style="margin-left:10px">Beranda</a></li>
  10. <li><a>Data Anggota</a></li>
  11. </ul>
  12. <button class="btn btn-success" data-toggle="modal" data-target="#myModal" style="margin-bottom: 8px">
  13. <i class="fa fa-plus"></i> Tambah Data
  14. </button>
  15. <div class="row">
  16. <div class="col-md-12">
  17. <!-- Advanced Tables -->
  18. <div class="panel panel-primary">
  19. <div class="panel-heading">
  20. Data Anggota
  21. </div>
  22. <div class="panel-body">
  23. <div class="table-responsive">
  24. <table class="table table-striped table-bordered table-hover" id="dataTables-example">
  25. <thead>
  26. <tr>
  27. <th>No</th>
  28. <th>No Nasabah</th>
  29. <th>Nama Nasabah</th>
  30. <th>Tanggal Masuk</th>
  31. <th>Aksi</th>
  32. </tr>
  33. </thead>
  34. <tbody>
  35. <?php
  36. $no = 1;
  37. $sql = $koneksi->query("select * from anggota");
  38.  
  39. while ($data=$sql->fetch_assoc()) {
  40.  
  41.  
  42. ?>
  43. <tr>
  44. <td><?php echo $no++;?></td>
  45. <td><?php echo $data['id'];?></td>
  46. <td><?php echo $data['nama'];?></td>
  47. <td><?php echo date('d F Y',strtotime($data['tgl_masuk'])); ?></td>
  48. <td>
  49. <div class="btn-group" style="margin-bottom: 2px">
  50. <a href="?page=anggota&aksi=info&id=<?php echo $data['id'];?>" class="btn btn-warning">Info</a>
  51. <button data-toggle="dropdown" class="btn btn-warning dropdown-toggle"><span class="caret"></span></button>
  52. <ul class="dropdown-menu">
  53. <li><a href="?page=anggota&aksi=info&id=<?php echo $data['id'];?>">Infomasi Nasabah</a></li>
  54. <li class="divider"></li>
  55. <li><a href="#">Simpan</a></li>
  56. <li><a href="#">Pinjam</a></li>
  57. <li><a href="#">Ambil</a></li>
  58. <li><a href="#">Bayar</a></li>
  59. </ul>
  60. </div>
  61.  
  62. <a href="?page=anggota&aksi=ubah&id=<?php echo $data['id'];?>" class="btn btn-info" style="margin-bottom: 2px"><i class="fa fa-edit"></i> Ubah</a>
  63. <a onclick="return confirm('Anda yakin ingin menghapus data ini?')" href="?page=anggota&aksi=hapus&id=<?php echo $data['id'];?>" class="btn btn-danger" style="margin-bottom: 2px"><i class="fa fa-trash"></i> Hapus</a>
  64. </td>
  65. </tr>
  66.  
  67. <?php } ?>
  68. </tbody>
  69. </table>
  70. </div>
  71. <a href="./laporan/laporan_anggota_excel.php" target="blank" class="btn btn-default" style="margin-top: 8px"><i class="fa fa-print"></i> ExportToExcel</a>
  72. <a class="btn btn-default" data-toggle="modal" data-target="#myModalcetak" style="margin-top: 8px"><i class="fa fa-print"></i> ExportToPdf</a>
  73.  
  74. </div>
  75. </div>
  76. </div>
  77. </div>
  78.  
  79. <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  80. <div class="modal-dialog">
  81. <div class="modal-content">
  82. <div class="modal-header">
  83. <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
  84. <h4 class="modal-title" id="myModalLabel">Tambah Data</h4>
  85. </div>
  86. <div class="modal-body">
  87. <form role="form" method="POST">
  88. <div class="form-group">
  89. <label>Id Anggota/ NIK</label>
  90. <input class="form-control" name="id"/>
  91. </div>
  92.  
  93.  
  94. <div class="form-group">
  95. <label>Nama Nasabah</label>
  96. <input class="form-control" name="nama"/>
  97. </div>
  98.  
  99.  
  100. <div class="form-group">
  101. <label>Alamat Saat ini</label>
  102. <input class="form-control" name="alamat" />
  103. </div>
  104.  
  105. <div class="form-group">
  106. <label>No HP</label>
  107. <input class="form-control" name="hp" />
  108. </div>
  109.  
  110. <div class="form-group">
  111. <label> Jenis Keangotaan</label>
  112. <select class="form-control" name="jk">
  113. <option value="Anggota Kopkar">Anggota Kopkar</option>
  114. <option value="Eksternal">Eksternal</option>
  115. </select>
  116. </div>
  117.  
  118. <div class="form-group">
  119. <label>Departemen</label>
  120. <input class="form-control" name="dp" />
  121. </div>
  122.  
  123. <div class="form-group">
  124. <label>Tanggal Masuk</label>
  125. <input class="form-control" name="tgl_masuk" type="date" />
  126. </div>
  127.  
  128. <div class="modal-footer">
  129. <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
  130. <input type="submit" name="simpan" value="Simpan" class="btn btn-primary">
  131. </div>
  132. </form>
  133.  
  134. </div>
  135. </div>
  136. </div>
  137. </div>
  138.  
  139. //modal buat cetak anggota dan dari sekian
  140.  
  141. <div class="modal fade" id="myModalcetak" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  142. <div class="modal-dialog">
  143. <div class="modal-content">
  144. <div class="modal-header">
  145. <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
  146. <h4 class="modal-title" id="myModalLabel">Cetak Data Anggota ke PDF</h4>
  147. </div>
  148. <div class="modal-body">
  149. <form role="form" method="POST">
  150. <div class="form-group">
  151. <label>Dari Tanggal</label>
  152. <input class="form-control" name="tgl_awal" type="date" />
  153. </div>
  154.  
  155. <div class="form-group">
  156. <label>Sampai Tanggal</label>
  157. <input class="form-control" name="tgl_akhir" type="date" />
  158. </div>
  159.  
  160. <div class="modal-footer">
  161. <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
  162. <a href="?page=anggota&aksi=cetakpdf" target="_blank" class="btn btn-primary"> Proses</a>
  163. </div>
  164. </form>
  165. </div>
  166. </div>
  167. </div>
  168. </div>
  169.  
  170. <?php
  171.  
  172. if(isset($_POST['simpan'])){
  173.  
  174. $id = @$_POST['id'];
  175. $nama = @$_POST['nama'];
  176. $alamat = @$_POST['alamat'];
  177. $tgl_masuk = @$_POST['tgl_masuk'];
  178. $hp = @$_POST['hp'];
  179. $jk = @$_POST['jk'];
  180. $dp = @$_POST['dp'];
  181.  
  182.  
  183. $sql = $koneksi->query("insert into anggota(id, nama, alamat, tgl_masuk, no_hp, jenis_keanggotaan, departemen)values('$id', '$nama', '$alamat', '$tgl_masuk', '$hp', '$jk', '$dp')");
  184.  
  185. if($sql){
  186. ?>
  187.  
  188. <script type="text/javascript">
  189. alert("Simpan data berhasil");
  190. window.location.href="?page=anggota";
  191.  
  192. </script>
  193.  
  194.  
  195. <?php
  196. }
  197.  
  198. }
  199.  
  200. ?>
Advertisement
Add Comment
Please, Sign In to add comment