API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 5th, 2019
204
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.87 KB | None | 0 0
raw download clone embed print report
  1. <script src='lib/jquery.min.js'></script>
  2. <script src='lib/zebra_datepicker.js'></script>
  3. <link rel='stylesheet' href='lib/css/metallic.css' />
  4. <script>
  5.  
  6.  
  7. $(document).ready(function(){
  8. $('#tanggal1').Zebra_DatePicker({
  9. format: 'Ymd',
  10. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  11. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  12. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  13. });
  14. });
  15. $(document).ready(function(){
  16. $('#tanggal2').Zebra_DatePicker({
  17. format: 'd-m-Y',
  18. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  19. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  20. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  21. });
  22. });
  23. $(document).ready(function(){
  24. $('#tanggal3').Zebra_DatePicker({
  25. format: 'd-m-Y',
  26. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  27. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  28. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  29. });
  30. });
  31. $(document).ready(function(){
  32. $('#tanggal4').Zebra_DatePicker({
  33. format: 'd-m-Y',
  34. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  35. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  36. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  37. });
  38. });
  39. $(document).ready(function(){
  40. $('#tanggal5').Zebra_DatePicker({
  41. format: 'd-m-Y',
  42. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  43. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  44. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  45. });
  46. });
  47. $(document).ready(function(){
  48. $('#tanggal6').Zebra_DatePicker({
  49. format: 'd-m-Y',
  50. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  51. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  52. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  53. });
  54. });
  55. $(document).ready(function(){
  56. $('#tanggal7').Zebra_DatePicker({
  57. format: 'd-m-Y',
  58. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  59. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  60. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  61. });
  62. });
  63. $(document).ready(function(){
  64. $('#tanggal8').Zebra_DatePicker({
  65. format: 'd-m-Y',
  66. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  67. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  68. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  69. });
  70. });
  71. $(document).ready(function(){
  72. $('#tanggal9').Zebra_DatePicker({
  73. format: 'd-m-Y',
  74. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  75. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  76. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  77. });
  78. });
  79. $(document).ready(function(){
  80. $('#tanggal10').Zebra_DatePicker({
  81. format: 'd-m-Y',
  82. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  83. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  84. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  85. });
  86. });
  87. $(document).ready(function(){
  88. $('#tanggal11').Zebra_DatePicker({
  89. format: 'd-m-Y',
  90. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  91. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  92. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  93. });
  94. });
  95. $(document).ready(function(){
  96. $('#tanggal12').Zebra_DatePicker({
  97. format: 'd-m-Y',
  98. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  99. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  100. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  101. });
  102. });
  103. $(document).ready(function(){
  104. $('#tanggal13').Zebra_DatePicker({
  105. format: 'Y-m-d',
  106. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  107. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  108. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  109.  
  110.  
  111. });
  112. });
  113. $(document).ready(function(){
  114. $('#tanggal14').Zebra_DatePicker({
  115. format: 'd-m-Y',
  116. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  117. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  118. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  119. });
  120. });
  121. $(document).ready(function(){
  122. $('#tanggal15').Zebra_DatePicker({
  123. format: 'd-m-Y',
  124. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  125. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  126. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  127. });
  128. });
  129. $(document).ready(function(){
  130. $('#tanggal16').Zebra_DatePicker({
  131. format: 'd-m-Y',
  132. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  133. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  134. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  135. });
  136. });
  137. $(document).ready(function(){
  138. $('#tanggal17').Zebra_DatePicker({
  139. format: 'Y-m-d',
  140. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  141. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  142. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  143. });
  144. });
  145. $(document).ready(function(){
  146. $('#tanggal18').Zebra_DatePicker({
  147. format: 'd-m-Y',
  148. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  149. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  150. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  151. });
  152. });
  153. $(document).ready(function(){
  154. $('#tanggal19').Zebra_DatePicker({
  155. format: 'd-m-Y',
  156. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  157. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  158. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  159. });
  160. });
  161. $(document).ready(function(){
  162. $('#tanggal20').Zebra_DatePicker({
  163. format: 'd-m-Y',
  164. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  165. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  166. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  167. });
  168. });
  169. $(document).ready(function(){
  170. $('#tanggal21').Zebra_DatePicker({
  171. format: 'd-m-Y',
  172. months : ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'],
  173. days : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu'],
  174. days_abbr : ['Minggu','Senin','Selasa','Rabu','Kamis','Jum\'at','Sabtu']
  175. });
  176. });
  177. </script>
  178. <SCRIPT language=Javascript>
  179. <!--
  180. function isNumberKey(evt)
  181. {
  182. var charCode = (evt.which) ? evt.which : event.keyCode
  183. if (charCode > 31 && (charCode < 48 || charCode > 57))
  184.  
  185. return false;
  186. return true;
  187. }
  188. //-->
  189.  
  190. function numberFormat(nr){
  191. //remove the existing
  192. var regex = /,/g;
  193. nr = nr.replace(regex,'');
  194.  
  195. //split it into 2 parts
  196. var x = nr.split(',');
  197. var p1 = x[0];
  198. var p2 = x.length > 1 ? ',' + x[1] : '';
  199. //match group of 3 numbers (0-9) and add ',' between them
  200. regex = /(\d+)(\d{3})/;
  201. while(regex.test(p1))
  202. {
  203. p1 = p1.replace(regex, '$1' + ',' + '$2');
  204. }
  205. //join the 2 parts and return the formatted number
  206. return p1 + p2;
  207. }
  208. //-->
  209. </SCRIPT>
  210. <?php
  211. // Timezone//
  212. date_default_timezone_set("Asia/Jakarta");
  213.  
  214. session_start();
  215. if (empty($_SESSION['namauser']) AND empty($_SESSION['passuser'])){
  216. echo "<link rel='stylesheet' href='//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css'>
  217. <script src='//code.jquery.com/jquery-1.10.2.js'></script>
  218. <script src='//code.jquery.com/ui/1.11.2/jquery-ui.js'></script>
  219. <link rel='stylesheet' href='/resources/demos/style.css'>
  220.  
  221. <center>Untuk mengakses modul, Anda harus login <br>";
  222. echo "<a href=../../index.php><b>LOGIN</b></a></center>";
  223. }
  224. else{
  225. $aksi="modul/mod_kupon/aksi_kupon.php";
  226. switch($_GET[act]){
  227. // Tampil INPUT SETORAN
  228. default:
  229. if ($_SESSION[leveluser]=='1'){
  230.  
  231. echo "<h2>Kupon Dunkin</h2>
  232. <div class='box'><div class='left'><input type=button value='Tambah Kupon' onclick=location.href='?module=kupon&act=tambahkupon'></div>
  233. <div class='right'><form method=get action='$_SERVER[PHP_SELF]'>
  234. <input type=hidden name=module value=kupon>
  235. Masukan Tanggal Transaksi : <input type=text id=tanggal17 name='kata' >&nbsp;<input type=submit value=Cari>
  236. </form></div></div>";
  237.  
  238. if (empty($_GET['kata'])){
  239. echo "<table class='list'><thead>
  240. <tr><td class='center'>no</td>
  241. <td class='center'>Tanggal Transaksi</td>
  242. <td class='center'>Cost Center (CCE)</td>
  243. <td class='center'>CCU</td>
  244. <td class='center'>Kode Data Pos</td>
  245. <td class='center'>Dep Sdep</td>
  246. <td class='center'>Jenis Kupon</td>
  247. <td class='center'>Nilai Lembar</td>
  248. <td class='center'>Jumlah Lembar</td>
  249. <td class='center'>Keterangan</td>
  250. <td class='center'>aksi</td></tr></thead><tbody>";
  251.  
  252. $p = new Paging;
  253. $batas = 15;
  254. $posisi = $p->cariPosisi($batas);
  255. $tampil = mssql_query("EXEC SP_KUPON '',$posisi,$batas");
  256. $no = $posisi+1;
  257. while ($r=mssql_fetch_array($tampil)){
  258. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  259. <td class='right' width='25'>$no</td>
  260. <td class='center' width='25'>$r[tgl_trans]</td>
  261. <td class='center'>$r[kode_center]</td>
  262. <td class='center'>$r[code_unit]</td>
  263. <td class='center'>$r[datapos]</td>
  264. <td class='right'>$r[dep_sdep]</td>
  265. <td class='left'>$r[jenis_kupon]</td>
  266. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  267. echo"</td>
  268. <td class='center' width='25'>$r[jumlah_lembar]</td>
  269. <td class='left' width='100'>$r[keterangan]</td>
  270.  
  271. <td class='center'>
  272. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  273. <a href=$aksi?module=kupon&act=hapus&id=$r[id_kupon] onclick=\"return confirm('Apakah anda yakin akan menghapus $r[jenis_kupon] tanggal transaksi: $r[tgl_trans] , datapos: $r[datapos] ?')\"><img src='images/del.png' border='0' title='hapus' /></a>
  274. </td>
  275. </tr>";
  276. $no++;
  277. }
  278. echo "</tbody></table>";
  279. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON"));
  280. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  281. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  282.  
  283. echo "<div class=pagination>$linkHalaman</div><br>";
  284. break;
  285.  
  286. }else {
  287. echo "<table class='list'><thead>
  288. <tr><td class='center'>no</td>
  289. <td class='center'>Tanggal Transaksi</td>
  290. <td class='center'>Cost Center (CCE)</td>
  291. <td class='center'>CCU</td>
  292. <td class='center'>Kode Data Pos</td>
  293. <td class='center'>Dep Sdep</td>
  294. <td class='center'>Jenis Kupon</td>
  295. <td class='center'>Nilai Lembar</td>
  296. <td class='center'>Jumlah Lembar</td>
  297. <td class='center'>Keterangan</td>
  298. <td class='center'>aksi</td></tr></thead><tbody>";
  299.  
  300. $p = new Paging9;
  301. $batas = 10;
  302. $posisi = $p->cariPosisi($batas);
  303. $kata = $_GET[kata];
  304. $tampil=mssql_query("EXEC SP_KUPON '$kata','$posisi','$batas'");
  305. $no = $posisi+1;
  306. while ($r=mssql_fetch_array($tampil)){
  307. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  308. <td class='right' width='25'>$no</td>
  309. <td class='center' width='25'>$r[tgl_trans]</td>
  310. <td class='center'>$r[kode_center]</td>
  311. <td class='center'>$r[code_unit]</td>
  312. <td class='center'>$r[datapos]</td>
  313. <td class='right'>$r[dep_sdep]</td>
  314. <td class='left'>$r[jenis_kupon]</td>
  315. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  316. echo"</td>
  317. <td class='center' width='25'>$r[jumlah_lembar]</td>
  318. <td class='left' width='100'>$r[keterangan]</td>
  319.  
  320. <td class='center'>
  321. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  322. <a href=$aksi?module=kupon&act=hapus&id=$r[id_kupon] onclick=\"return confirm('Apakah anda yakin akan menghapus $r[jenis_kupon] tanggal transaksi: $r[tgl_trans] , datapos: $r[datapos] ?')\"><img src='images/del.png' border='0' title='hapus' /></a>
  323. </td>
  324. </tr>";
  325. $no++;
  326. }
  327. echo "</tbody></table>";
  328. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON '$kata'"));
  329. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  330. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  331.  
  332. echo "<div class=pagination>$linkHalaman</div><br>";
  333. break;
  334. }
  335. } ELSE if ($_SESSION[leveluser]=='2'){
  336.  
  337. echo "<h2>Kupon Dunkin</h2>
  338. <div class='box'><div class='left'><input type=button value='Tambah Kupon' onclick=location.href='?module=kupon&act=tambahkupon'></div>
  339. <div class='right'><form method=get action='$_SERVER[PHP_SELF]'>
  340. <input type=hidden name=module value=kupon>
  341. Masukan Tanggal Transaksi : <input type=text id=tanggal17 name='kata' size=50>&nbsp;<input type=submit value=Cari>
  342. </form></div></div>";
  343.  
  344. if (empty($_GET['kata'])){
  345. echo "<table class='list'><thead>
  346. <tr><td class='center'>no</td>
  347. <td class='center'>Tanggal Transaksi</td>
  348. <td class='center'>Cost Center (CCE)</td>
  349. <td class='center'>CCU</td>
  350. <td class='center'>Kode Data Pos</td>
  351. <td class='center'>Dep Sdep</td>
  352. <td class='center'>Jenis Kupon</td>
  353. <td class='center'>Nilai Lembar</td>
  354. <td class='center'>Jumlah Lembar</td>
  355. <td class='center'>Keterangan</td>
  356. <td class='center'>aksi</td></tr></thead><tbody>";
  357.  
  358. $p = new Paging;
  359. $batas = 15;
  360. $posisi = $p->cariPosisi($batas);
  361. $tampil = mssql_query("EXEC SP_KUPON '',$posisi,$batas");
  362. $no = $posisi+1;
  363. while ($r=mssql_fetch_array($tampil)){
  364. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  365. <td class='right' width='25'>$no</td>
  366. <td class='center' width='25'>$r[tgl_trans]</td>
  367. <td class='center'>$r[kode_center]</td>
  368. <td class='center'>$r[code_unit]</td>
  369. <td class='center'>$r[datapos]</td>
  370. <td class='right'>$r[dep_sdep]</td>
  371. <td class='left'>$r[jenis_kupon]</td>
  372. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  373. echo"</td>
  374. <td class='center' width='25'>$r[jumlah_lembar]</td>
  375. <td class='left' width='100'>$r[keterangan]</td>
  376.  
  377. <td class='center'>
  378. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  379. <a href=$aksi?module=kupon&act=hapus&id=$r[id_kupon]><img src='images/del.png' border='0' title='hapus' /></a>
  380. </td>
  381. </tr>";
  382. $no++;
  383. }
  384. echo "</tbody></table>";
  385. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON"));
  386. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  387. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  388.  
  389. echo "<div class=pagination>$linkHalaman</div><br>";
  390. break;
  391.  
  392. }else {
  393. echo "<table class='list'><thead>
  394. <tr><td class='center'>no</td>
  395. <td class='center'>Tanggal Transaksi</td>
  396. <td class='center'>Cost Center (CCE)</td>
  397. <td class='center'>CCU</td>
  398. <td class='center'>Kode Data Pos</td>
  399. <td class='center'>Dep Sdep</td>
  400. <td class='center'>Jenis Kupon</td>
  401. <td class='center'>Nilai Lembar</td>
  402. <td class='center'>Jumlah Lembar</td>
  403. <td class='center'>Keterangan</td>
  404. <td class='center'>aksi</td></tr></thead><tbody>";
  405.  
  406. $p = new Paging9;
  407. $batas = 10;
  408. $posisi = $p->cariPosisi($batas);
  409. $kata = $_GET[kata];
  410. $tampil=mssql_query("EXEC SP_KUPON '$kata','$posisi','$batas'");
  411. $no = $posisi+1;
  412. while ($r=mssql_fetch_array($tampil)){
  413. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  414. <td class='right' width='25'>$no</td>
  415. <td class='center' width='25'>$r[tgl_trans]</td>
  416. <td class='center'>$r[kode_center]</td>
  417. <td class='center'>$r[code_unit]</td>
  418. <td class='center'>$r[datapos]</td>
  419. <td class='right'>$r[dep_sdep]</td>
  420. <td class='left'>$r[jenis_kupon]</td>
  421. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  422. echo"</td>
  423. <td class='center' width='25'>$r[jumlah_lembar]</td>
  424. <td class='left' width='100'>$r[keterangan]</td>
  425.  
  426. <td class='center'>
  427. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  428. <a href=$aksi?module=setoran&act=hapus&id=$r[id_kupon]><img src='images/del.png' border='0' title='hapus' /></a>
  429. </td>
  430. </tr>";
  431. $no++;
  432. }
  433. echo "</tbody></table>";
  434. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON '$kata'"));
  435. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  436. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  437.  
  438. echo "<div class=pagination>$linkHalaman</div><br>";
  439. break;
  440. }
  441. } ELSE IF ($_SESSION[leveluser]=='3'){
  442. echo "<h2>Kupon Dunkin</h2>
  443. <div class='box'><div class='left'>
  444. <input type=button value='Tambah Kupon' onclick=location.href='?module=kupon&act=tambahkupon'>
  445. <input type=button value='Export Excel' onclick=location.href='?module=kupon&act=exportexcel'>
  446. <input type=button value='Import Excel' onclick=location.href='?module=kupon&act=importexcel'>
  447.  
  448. </div>
  449. <div class='right'><form method=get action='$_SERVER[PHP_SELF]'>
  450. <input type=hidden name=module value=kupon>
  451. Masukan Tanggal Transaksi : <input type=text id=tanggal17 name='kata' >&nbsp;<input type=submit value=Cari>
  452. </form></div></div>";
  453. if (empty($_GET['kata'])){
  454. echo "<table class='list'><thead>
  455. <tr><td class='center'>no</td>
  456. <td class='center'>Tanggal Transaksi</td>
  457. <td class='center'>Cost Center (CCE)</td>
  458. <td class='center'>CCU</td>
  459. <td class='center'>Kode Data Pos</td>
  460. <td class='center'>Dep Sdep</td>
  461. <td class='center'>Jenis Kupon</td>
  462. <td class='center'>Nilai Lembar</td>
  463. <td class='center'>Jumlah Lembar</td>
  464. <td class='center'>Shift</td>
  465. <td class='center'>Keterangan</td>
  466. <td class='center'>aksi</td></tr></thead><tbody>";
  467.  
  468. $p = new Paging;
  469. $batas = 15;
  470. $posisi = $p->cariPosisi($batas);
  471. $tampil = mssql_query("EXEC SP_KUPON_USER '','$_SESSION[kodecenter]'");
  472. $no = $posisi+1;
  473. while ($r=mssql_fetch_array($tampil)){
  474. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  475. <td class='right' width='25'>$no</td>
  476. <td class='center' width='25'>$r[tgl_trans]</td>
  477. <td class='center'>$r[kode_center]</td>
  478. <td class='center'>$r[code_unit]</td>
  479. <td class='center'>$r[datapos]</td>
  480. <td class='right'>$r[dep_sdep]</td>
  481. <td class='left'>$r[jenis_kupon]</td>
  482. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  483. echo"</td>
  484. <td class='center' width='25'>$r[jumlah_lembar]</td>
  485. <td class='center' width='2'>$r[shift]</td>
  486. <td class='left' width='100'>$r[keterangan]</td>
  487.  
  488. <td class='center'>
  489. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  490. <a href=$aksi?module=kupon&act=hapus&id=$r[id_kupon] onclick=\"return confirm('Apakah anda yakin akan menghapus $r[jenis_kupon] tanggal transaksi: $r[tgl_trans] , datapos: $r[datapos] ?')\"><img src='images/del.png' border='0' title='hapus' /></a>
  491. </td>
  492. </tr>";
  493. $no++;
  494. }
  495. echo "</tbody></table>";
  496. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON_USER '','$_SESSION[kodecenter]'"));
  497. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  498. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  499.  
  500. echo "<div class=pagination>$linkHalaman</div><br>";
  501. break;
  502.  
  503. }else {
  504. echo "<table class='list'><thead>
  505. <tr><td class='center'>no</td>
  506. <td class='center'>Tanggal Transaksi</td>
  507. <td class='center'>Cost Center (CCE)</td>
  508. <td class='center'>CCU</td>
  509. <td class='center'>Kode Data Pos</td>
  510. <td class='center'>Dep Sdep</td>
  511. <td class='center'>Jenis Kupon</td>
  512. <td class='center'>Nilai Lembar</td>
  513. <td class='center'>Jumlah Lembar</td>
  514. <td class='center'>Keterangan</td>
  515. <td class='center'>aksi</td></tr></thead><tbody>";
  516.  
  517. $p = new Paging9;
  518. $batas = 10;
  519. $posisi = $p->cariPosisi($batas);
  520. $kata = $_GET[kata];
  521. $tampil=mssql_query("EXEC SP_KUPON_USER '$kata','$_SESSION[kodecenter]','$posisi','$batas'");
  522. $no = $posisi+1;
  523. while ($r=mssql_fetch_array($tampil)){
  524. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  525. <td class='right' width='25'>$no</td>
  526. <td class='center' width='25'>$r[tgl_trans]</td>
  527. <td class='center'>$r[kode_center]</td>
  528. <td class='center'>$r[code_unit]</td>
  529. <td class='center'>$r[datapos]</td>
  530. <td class='right'>$r[dep_sdep]</td>
  531. <td class='left'>$r[jenis_kupon]</td>
  532. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  533. echo"</td>
  534. <td class='center' width='25'>$r[jumlah_lembar]</td>
  535. <td class='left' width='100'>$r[keterangan]</td>
  536.  
  537. <td class='center'>
  538. <a href=?module=kupon&act=editkupon&id=$r[id_kupon]><img src='images/edit.png' border='0' title='edit' /></a>&nbsp;
  539. <a href=$aksi?module=kupon&act=hapus&id=$r[id_kupon] onclick=\"return confirm('Apakah anda yakin akan menghapus $r[jenis_kupon] tanggal transaksi: $r[tgl_trans] , datapos: $r[datapos] ?')\"><img src='images/del.png' border='0' title='hapus' /></a>
  540. </td>
  541. </tr>";
  542. $no++;
  543. }
  544. echo "</tbody></table>";
  545. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON_USER '$kata','$_SESSION[kodecenter]'"));
  546. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  547. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  548.  
  549. echo "<div class=pagination>$linkHalaman</div><br>";
  550. break;
  551. }
  552. } ELSE IF ($_SESSION[leveluser]=='0'){
  553. echo "<h2>Kupon Dunkin</h2>
  554. <div class='box'><div class='left'></div>
  555. <div class='right'><form method=get action='$_SERVER[PHP_SELF]'>
  556. <input type=hidden name=module value=kupon>
  557. Masukan Tanggal Transaksi : <input type=text id=tanggal17 name='kata' >&nbsp;<input type=submit value=Cari>
  558. </form></div></div>";
  559. if (empty($_GET['kata'])){
  560. echo "<table class='list'><thead>
  561. <tr><td class='center'>no</td>
  562. <td class='center'>Tanggal Transaksi</td>
  563. <td class='center'>Cost Center (CCE)</td>
  564. <td class='center'>CCU</td>
  565. <td class='center'>Kode Data Pos</td>
  566. <td class='center'>Dep Sdep</td>
  567. <td class='center'>Jenis Kupon</td>
  568. <td class='center'>Nilai Lembar</td>
  569. <td class='center'>Jumlah Lembar</td>
  570. <td class='center'>Keterangan</td></tr></thead><tbody>";
  571.  
  572. $p = new Paging;
  573. $batas = 15;
  574. $posisi = $p->cariPosisi($batas);
  575. $tampil = mssql_query("EXEC SP_KUPON '',$posisi,$batas");
  576. $no = $posisi+1;
  577. while ($r=mssql_fetch_array($tampil)){
  578. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  579. <td class='right' width='25'>$no</td>
  580. <td class='center' width='25'>$r[tgl_trans]</td>
  581. <td class='center'>$r[kode_center]</td>
  582. <td class='center'>$r[code_unit]</td>
  583. <td class='center'>$r[datapos]</td>
  584. <td class='right'>$r[dep_sdep]</td>
  585. <td class='left'>$r[jenis_kupon]</td>
  586. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  587. echo"</td>
  588. <td class='center' width='25'>$r[jumlah_lembar]</td>
  589. <td class='left' width='100'>$r[keterangan]</td>
  590. </tr>";
  591. $no++;
  592. }
  593. echo "</tbody></table>";
  594. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON"));
  595. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  596. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  597.  
  598. echo "<div class=pagination>$linkHalaman</div><br>";
  599. break;
  600.  
  601. }else {
  602. echo "<table class='list'><thead>
  603. <tr><td class='center'>no</td>
  604. <td class='center'>Tanggal Transaksi</td>
  605. <td class='center'>Cost Center (CCE)</td>
  606. <td class='center'>CCU</td>
  607. <td class='center'>Kode Data Pos</td>
  608. <td class='center'>Dep Sdep</td>
  609. <td class='center'>Jenis Kupon</td>
  610. <td class='center'>Nilai Lembar</td>
  611. <td class='center'>Jumlah Lembar</td>
  612. <td class='center'>Keterangan</td></tr></thead><tbody>";
  613.  
  614. $p = new Paging9;
  615. $batas = 10;
  616. $posisi = $p->cariPosisi($batas);
  617. $kata = $_GET[kata];
  618. $tampil=mssql_query("EXEC SP_KUPON '$kata','$posisi','$batas'");
  619. $no = $posisi+1;
  620. while ($r=mssql_fetch_array($tampil)){
  621. echo "<tr><input type=hidden name=id value=$r[id_kupon]/>
  622. <td class='right' width='25'>$no</td>
  623. <td class='center' width='25'>$r[tgl_trans]</td>
  624. <td class='center'>$r[kode_center]</td>
  625. <td class='center'>$r[code_unit]</td>
  626. <td class='center'>$r[datapos]</td>
  627. <td class='right'>$r[dep_sdep]</td>
  628. <td class='left'>$r[jenis_kupon]</td>
  629. <td class='right'>";echo number_format($r[nilai_lembar],2,',','.');
  630. echo"</td>
  631. <td class='center' width='25'>$r[jumlah_lembar]</td>
  632. <td class='left' width='100'>$r[keterangan]</td>
  633. </tr>";
  634. $no++;
  635. }
  636. echo "</tbody></table>";
  637. $jmldata=mssql_num_rows(mssql_query("EXEC SP_KUPON '$kata'"));
  638. $jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
  639. $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman);
  640.  
  641. echo "<div class=pagination>$linkHalaman</div><br>";
  642. break;
  643. }
  644. }
  645.  
  646.  
  647.  
  648. //TAMBAH KUPON
  649. case "tambahkupon":
  650.  
  651. $jsArray = "var kdrek = new Array();";
  652. echo "<h2>Tambah Kupon</h2>";
  653. if ($_POST) {
  654. $tgl_trans =$_POST['tgl_trans'];
  655. $CCE =$_POST['CCE'];
  656. $code_unit =$_POST['code_unit'];
  657. $datapos =$_POST['datapos'];
  658. $depsdep =$_POST['dep_sdep'];
  659. //$jenis_kupon =$_POST['jenis_kupon'];
  660. //$nilai_lembar =$_POST['nilai_lembar'];
  661. $jumlah_lembar =$_POST['jumlah_lembar'];
  662. $keterangan =$_POST['keterangan'];
  663. $ket = preg_replace('/[^a-zA-Z0-9 ]/','',$keterangan);
  664. $shift =$_POST['shift'];
  665.  
  666. $error = array();
  667. if(empty($tgl_trans)){
  668. $error['tgl_trans'] = 'Tanggal transaksi tidak boleh kosong !';
  669. }
  670. if(empty($CCE)){
  671. $error['CCE'] = 'Cost center tidak boleh kosong !';
  672. }
  673. if(empty($code_unit)){
  674. $error['code_unit'] = 'Cost unit harus dipilih !';
  675. }
  676. if(empty($datapos)){
  677. $error['datapos'] = 'Datapos tidak boleh kosong !';
  678. }
  679. if(empty($depsdep)){
  680. $error['dep_sdep'] = 'Depsdep harus dipilih !';
  681. }
  682. // if(empty($jenis_kupon)){
  683. // $error['jenis_kupon'] = 'Jenis kupon tidak boleh kosong !';
  684. // }
  685. // if(empty($nilai_lembar)){
  686. // $error['nilai_lembar'] = 'Nilai lembar tidak boleh kosong !';
  687. //}
  688. if(empty($jumlah_lembar)){
  689. $error['jumlah_lembar'] = 'Jumlah lembar tidak boleh kosong !';
  690. }
  691. // if(empty($keterangan)){
  692. // $error['keterangan'] = 'Keterangan tidak boleh kosong !';
  693. // }
  694. if(empty($shift) || $shift == '0'){
  695. $error['shift'] = 'Shift harus dipilih !';
  696. }
  697. if(empty($error)){
  698. //echo "<script>window.alert('');window.location=('?module=kupon&act=tambahkupon')</script>";
  699. $input=mssql_query("EXEC [CREATE_KUPON] '$CCE',
  700. '$code_unit',
  701. '$datapos',
  702. '$tgl_trans',
  703. '$shift',
  704. '$depsdep',
  705. '$jumlah_lembar',
  706. '$ket',
  707. '$_SESSION[namauser]'");
  708.  
  709. $show=mssql_fetch_array($input);
  710. IF ($show[ErrCode]=='1') {
  711. echo "<script>window.alert('$show[ErrorMsg]');
  712. window.location=('?module=kupon&act=tambahkupon')</script>";
  713. //echo "<script>window.location=('../../media.php?module=MK')</script>";
  714. //header('location:../../media.php?module='.$module);
  715. } else {
  716. echo "<script>window.alert('$show[ErrorMsg]');
  717. window.location=('?module=kupon')</script>";
  718. }
  719. }
  720. }
  721. echo" <form name=form method=POST action=''>";
  722. //echo "<br>oke $tgl_trans</br>";
  723. ?>
  724. <script type="text/javascript">
  725. $( function() {
  726.  
  727. $(".tcal").datepicker({
  728. onSelect: function(dateText) {
  729. display("Selected date: " + dateText + ", Current Selected Value= " + this.value);
  730. $(this).change();
  731. }
  732. }).on("change", function() {
  733. display("Change event");
  734. });
  735.  
  736. function display(msg) {
  737. $("<p>").html(msg).appendTo(document.body);
  738. }
  739. });
  740.  
  741. </script>
  742.  
  743.  
  744.  
  745. <table class='list'><tbody>
  746. <tr><td class='left'>Tanggal Transaksi </td><td class='left' colspan=2> : <input type='text' name='tgl_trans' id='tanggal13' onchange="<?php echo 'tes();'; ?>" value="<?php echo $tgl_trans; ?>" >
  747. <div style="color:red"><?php echo isset($error['tgl_trans']) ? $error['tgl_trans'] : '';?></div></td>
  748. <td class='left'>Shift</td> <td class='left' colspan=7> :
  749. <select name='shift'>
  750. <option value=0 selected>-- Pilih Shift --</option>
  751. <option value=1 >1</option>
  752. <option value=2 >2</option>
  753. <option value=3 >3</option>";
  754.  
  755. </select>
  756. <div style="color:red"><?php echo isset($error['shift']) ? $error['shift'] : '';?> </div></td>
  757.  
  758. </tr>
  759.  
  760.  
  761.  
  762. <tr><td class='left'>Kode Center</td><td class='left' colspan=7> : <input type='text' name='CCE' id='CCE' value="<?php echo $_SESSION[kodecenter] ?>" readonly />
  763. <div style="color:red"><?php echo isset($error['CCE']) ? $error['CCE'] : '';?></div></tr>
  764. <tr><td class='left'>CCU</td><td class='left' colspan=2> : <select name='code_unit'>
  765. <option value=0 selected>-- Pilih Kode Unit --</option>
  766. <?php
  767. $tampil=mssql_query("EXEC GET_MASTER_AGEN '$_SESSION[kodecenter]'");
  768. while($r=mssql_fetch_array($tampil)){
  769. echo "<option value='$r[code_unit]'>$r[code_unit]</option>";
  770. }
  771. ?>
  772. </select><div style="color:red"><?php echo isset($error['code_unit']) ? $error['code_unit'] : '';?> </div>
  773.  
  774. <td class='left'>Kode Data Pos</td><td class='left' colspan=4> : <input type='text' name='datapos' id='datapos' style='text-transform:uppercase' size=7 maxlength='3' onkeypress=\"return isNumberKey(event)\" value="<?php echo $datapos; ?>" >
  775. <div style="color:red"><?php echo isset($error['datapos']) ? $error['datapos'] : '';?></div></td></tr>
  776.  
  777. <tr><td class='left'>Dep Sdep</td><td class='left' colspan=2> : <select name='dep_sdep' id='dep_sdep' onchange='changeValue(this.value)'>
  778. <option value=0 selected>-- Pilih Dep Sdep --</option>
  779. <?php
  780. //$tampil=mssql_query("EXEC GET_MASTER_KUPON ");
  781. $tampil=mssql_query("EXEC GET_KUPON_USER '$_POST[tgl_trans]'");
  782. while($r=mssql_fetch_array($tampil)){
  783. echo "<option value='$r[dep_sdep]'>$r[dep_sdep] || $r[jenis_kupon]</option>";
  784. $jsArray .= "kdrek['" . $r[dep_sdep] . "'] = {index:'" . addslashes($r['nama'])."',hard:'" . addslashes($r['nilai_lembar'])."'};";
  785. }
  786. ?>
  787.  
  788. </select><div style="color:red"><?php echo isset($error['dep_sdep']) ? $error['dep_sdep'] : '';?></div></td>
  789. <td class='left'>Nama Kupon</td> <td class='left' colspan=2> : <input type='text' name='nama' id='nama' readonly='readonly' style='text-transform:uppercase' value="<?php echo $jenis_kupon; ?>" />
  790. <div style="color:red"><?php echo isset($error['nama']) ? $error['nama'] : '';?></div></td>
  791.  
  792. <td class='left'>Nilai Lembar</td> <td class='left' colspan=2> : <input type='text' name='nilai_lembar' id='nilai_lembar' readonly='readonly' style='text-transform:uppercase' value="<?php echo $nilai_lembar; ?>" />
  793. <div style="color:red"><?php echo isset($error['nilai_lembar']) ? $error['nilai_lembar'] : '';?></div></td></tr>
  794.  
  795.  
  796. <tr><td class='left'>Jumlah Lembar</td><td class='left' colspan=7> : <input type=text name='jumlah_lembar' id='jumlah_lembar' style='text-transform:uppercase' size=10 maxlength='4' onkeypress=\"return isNumberKey(event)\" value="<?php echo $jumlah_lembar; ?>" />
  797. <div style="color:red"><?php echo isset($error['jumlah_lembar']) ? $error['jumlah_lembar'] : '';?></div></td></tr>
  798.  
  799. <tr><td class='left'>Keterangan</td><td class='left' colspan=7> : <input type=text name='keterangan' onchange="<?php echo 'tes();'; ?>" style='text-transform:uppercase' size=30 value="<?php echo $keterangan; ?>" />
  800. <div style="color:red"><?php echo isset($error['keterangan']) ? $error['keterangan'] : '';?></div></tr>
  801.  
  802. <?php
  803.  
  804. echo "<tr><td></td><td class='left' colspan=7><input type=submit value=Simpan>
  805. <input type=button value=Batal onclick=self.history.back()></td></tr>
  806. </tbody></table></form><br><br><br>";
  807.  
  808. break;
  809.  
  810. //EDIT KUPON
  811. case "editkupon":
  812. //$panggil = mssql_query("SELECT convert(varchar(100),id_kupon) as id_kupon,convert(varchar(10),tgl_trans,25) as tgl_trans,kode_center,code_unit,datapos,dep_sdep,jenis_kupon,nilai_lembar,jumlah_lembar,keterangan,created_by FROM kupon WHERE id_kupon='$_GET[id]'");
  813. $panggil = mssql_query("EXEC GET_EDITKUPON '$_GET[id]'");
  814. $g = mssql_fetch_array($panggil);
  815. IF ($g[ErrCode]<>'0') {
  816. echo "<script>window.alert('$g[ErrorMsg]');
  817. window.location=('media.php?module=kupon')</script>";
  818. //echo "<script>window.location=('../../media.php?module=MK')</script>";
  819. //header('location:../../media.php?module='.$module);
  820. } //else {
  821. //echo "window.location=('media.php?module=kupon&act=editkupon&id=$_GET[id]')";
  822. //}
  823.  
  824. echo "<h2>Edit Kupon</h2>
  825. <form method=POST enctype='multipart/form-data' action=$aksi?module=kupon&act=update>
  826. <input type=hidden name=id value='$g[id_kupon]'>
  827. <input type=hidden name='kodecenter' value='$g[kode_center]'>
  828. <table class='list'><tbody>
  829. <tr><td class='left'>Tanggal Transaksi</td><td class='left' colspan=9> : <input type='text' name='tgl_trans' value='$g[tgl_trans]' readonly > </tr>
  830. <tr><td class='left'>Kode Center</td><td class='left' colspan=9> : <input type='text' name='CCE' id='CCE' value='$g[kode_center]' readonly /></tr>
  831. <tr><td class='left'>CCU</td><td class='left' colspan=4> : <input type='text' name='code_unit' id='code_unit' value='$g[code_unit]' style='text-transform:uppercase' readonly/>
  832. <td class='left'>Kode Data Pos</td><td class='left' colspan=4> : <input type='text' name='datapos' id='datapos' value='$g[datapos]' style='text-transform:uppercase' readonly/>";
  833.  
  834. echo "</tr><tr><td class='left'>Dep Sdep</td><td class='left' colspan=4> : <input type='text' name='depsdep' value='$g[dep_sdep]' readonly />";
  835. echo "</select></td>
  836. <td class='left'>Nama Kupon</td> <td class='left' colspan=2> : <input type='text' name='nama_kupon' id='nama_kupon' value='$g[nama]' readonly='readonly' style='text-transform:uppercase' />";
  837.  
  838. echo "</td>
  839. <td class='left'>Nilai Lembar</td> <td class='left' colspan=2> : <input type='text' name='nilai_lembar' id='nilai_lembar' value='$g[nilai_lembar]' readonly='readonly' style='text-transform:uppercase' />";
  840.  
  841. echo "</td></tr>
  842. <tr><td class='left'>Jumlah Lembar</td><td class='left' colspan=9> : <input type=text name='jumlah_lembar' id='jumlah_lembar' value='$g[jumlah_lembar]' style='text-transform:uppercase' size=10 maxlength='4' onkeypress=\"return isNumberKey(event)\"/>";
  843.  
  844. echo "</td></tr>
  845. <tr><td class='left'>Keterangan</td><td class='left' colspan=9> : <input type=text name='keterangan' style='text-transform:uppercase' size=30>";
  846.  
  847. echo" </td></tr><tr><td></td><td class='left' colspan=9><input type=submit value=Update>
  848. <input type=button value=Batal onclick=self.history.back()></td></tr>
  849. </tbody></table></form>";
  850. break;
  851.  
  852. //EXPORT EXCEL
  853. case "exportexcel":
  854.  
  855. $jsArray = "var kdrek = new Array();";
  856. echo "<h2>EXPORT DATA</h2>";
  857. echo" <form name=form method=POST action='modul/mod_kupon/export.php'>";
  858. //echo "<br>oke $tgl_trans</br>";
  859. ?>
  860.  
  861.  
  862.  
  863. <table class='list'><tbody>
  864. <tr><td class='left'>Tanggal Transaksi </td><td class='left' width='210'> : <input type='text' name='tgl1' id='tanggal20' value="<?php echo $tgl1; ?>" >
  865. <div style="color:red"><?php echo isset($error['tgl1']) ? $error['tgl1'] : '';?></div></td>
  866. <td class='left' width='20'>s/d</td> <td class='left'> : <input type='text' name='tgl2' id='tanggal21' value="<?php echo $tgl2; ?>" >
  867. <div style="color:red"><?php echo isset($error['tgl2']) ? $error['tgl2'] : '';?></div></td>
  868.  
  869. </tr>
  870.  
  871. <tr><td class='left'>Cost Center</td><td class='left' colspan=3> : <select name='CCE'>
  872. <option value=0 selected>-- Pilih Kode Center --</option>
  873. <?php
  874. $tampil=mssql_query("EXEC GET_COSTCENTRE");
  875. while($r=mssql_fetch_array($tampil)){
  876. echo "<option value='$r[costcentre]'>$r[costcentre]</option>";
  877. }
  878. ?>
  879. </select><div style="color:red"><?php echo isset($error['CCE']) ? $error['CCE'] : '';?> </div></tr>
  880.  
  881. <?php
  882.  
  883. echo "<tr><td></td><td class='left' colspan=7><input type=submit value=Export>
  884. <input type=button value=Batal onclick=self.history.back()></td></tr>
  885. </tbody></table></form><br><br><br>";
  886.  
  887. break;
  888.  
  889. //IMPORT EXCEL
  890. case "importexcel":
  891.  
  892. $jsArray = "var kdrek = new Array();";
  893. echo "<h2>IMPORT DATA</h2>";
  894. echo" <form name=form method=POST action='modul/mod_kupon/import.php'>";
  895. //echo "<br>oke $tgl_trans</br>";
  896. ?>
  897.  
  898.  
  899.  
  900. <table class='list'><tbody>
  901. <tr><td class='left'>Path File </td><td class='left'> : <input type='file' name='excel' id='excel' accept= application/vnd.ms-excel (.XLS) >
  902. </td>
  903.  
  904.  
  905. </tr>
  906.  
  907.  
  908. <?php
  909.  
  910. echo "<tr><td></td><td class='left' colspan=2><input type=submit name='import' value=Import >
  911. <input type=button value=Batal onclick=self.history.back()></td></tr>
  912. </tbody></table></form><br><br><br>";
  913.  
  914. break;
  915.  
  916. }
  917. }
  918. ?>
  919.  
  920. <script type="text/javascript">
  921. <?php echo $jsArray; ?>
  922. function changeValue(id){
  923. document.getElementById('nama').value = kdrek[id].index;
  924. document.getElementById('nilai_lembar').value = kdrek[id].hard;
  925. };
  926. </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!