API tools faq
paste
Advertisement
arsel

dbgvj

arsel
May 11th, 2013
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 66.75 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. MySQL Data Transfer
  3. Source Host: localhost
  4. Source Database: dbgvj
  5. Target Host: localhost
  6. Target Database: dbgvj
  7. Date: 5/12/2013 3:47:36 AM
  8. */
  9.  
  10. SET FOREIGN_KEY_CHECKS=0;
  11. -- ----------------------------
  12. -- Table structure for auto
  13. -- ----------------------------
  14. CREATE TABLE `auto` (
  15. `FORM_MEMBER` int(11) DEFAULT '0',
  16. `NOTA` int(11) DEFAULT '0',
  17. `FINANCE` int(11) DEFAULT '0',
  18. `PO` int(11) DEFAULT '0',
  19. `OPNAME_PRODUCT` int(11) DEFAULT '0',
  20. `OPNAME_NON_PRODUCT` int(11) DEFAULT '0',
  21. `OPNAME_INVENTOR` int(11) DEFAULT '0',
  22. `MEJA1` varchar(15) DEFAULT '0',
  23. `MEJA2` varchar(15) DEFAULT '0',
  24. `MEJA3` varchar(15) DEFAULT '0',
  25. `MEJA4` varchar(15) DEFAULT '0',
  26. `MEJA5` varchar(15) DEFAULT '0',
  27. `MEJA6` varchar(15) DEFAULT '0',
  28. `MEJA7` varchar(15) DEFAULT '0',
  29. `MEJA8` varchar(15) DEFAULT '0',
  30. `MEJA9` varchar(15) DEFAULT '0',
  31. `MEJA10` varchar(15) DEFAULT '0',
  32. `MEJA11` varchar(15) DEFAULT '0',
  33. `MEJA12` varchar(15) DEFAULT '0',
  34. `MEJA13` varchar(15) DEFAULT '0',
  35. `MEJA14` varchar(15) DEFAULT '0',
  36. `MEJAX` varchar(15) DEFAULT '0',
  37. `ID_MEMBER` int(11) DEFAULT NULL,
  38. `GAJI` varchar(15) DEFAULT '0'
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40.  
  41. -- ----------------------------
  42. -- Table structure for t_bayar
  43. -- ----------------------------
  44. CREATE TABLE `t_bayar` (
  45. `NOTA` varchar(25) NOT NULL DEFAULT '',
  46. `ID_MEMBER` varchar(25) DEFAULT NULL,
  47. `Customer` varchar(25) DEFAULT NULL,
  48. `DATE` date DEFAULT NULL,
  49. `BAYAR` double(15,0) DEFAULT NULL,
  50. `QTY_TOTAL` double(5,0) DEFAULT NULL,
  51. `TOTAL` double(15,0) DEFAULT NULL,
  52. `DISC` double(15,0) DEFAULT NULL,
  53. `VDISC` double(15,0) DEFAULT NULL,
  54. `KEMBALI` double(15,0) DEFAULT NULL,
  55. `MEJA` varchar(3) DEFAULT NULL,
  56. `USERNAME` varchar(15) DEFAULT NULL,
  57. PRIMARY KEY (`NOTA`)
  58. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  59.  
  60. -- ----------------------------
  61. -- Table structure for t_belanja
  62. -- ----------------------------
  63. CREATE TABLE `t_belanja` (
  64. `KODE_PO` varchar(10) NOT NULL DEFAULT '',
  65. `TGL_PO` date DEFAULT NULL,
  66. `USERNAME` varchar(25) DEFAULT NULL,
  67. `TOTAL` double(10,0) DEFAULT NULL,
  68. `STATUS` varchar(5) DEFAULT NULL,
  69. PRIMARY KEY (`KODE_PO`)
  70. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  71.  
  72. -- ----------------------------
  73. -- Table structure for t_finance
  74. -- ----------------------------
  75. CREATE TABLE `t_finance` (
  76. `KODE_FIN` varchar(11) NOT NULL DEFAULT '',
  77. `LDT` date DEFAULT NULL,
  78. `TGL_FIN` date DEFAULT NULL,
  79. `CASHIER_SALDO` double(7,0) DEFAULT NULL,
  80. `PURCHASE_SALDO` double(7,0) DEFAULT NULL,
  81. `OWNER_EQUITY` double(7,0) DEFAULT NULL,
  82. `BENEFIT_A` double(7,0) DEFAULT NULL,
  83. `BENEFIT_B` double(7,0) DEFAULT NULL,
  84. `ADDITIONAL` double(7,0) DEFAULT NULL,
  85. `PURCHASE` double(7,0) DEFAULT NULL,
  86. `PRIVE` double(7,0) DEFAULT NULL,
  87. `SALARY` double(7,0) DEFAULT NULL,
  88. `MAINTENANCE` double(7,0) DEFAULT NULL,
  89. `PDAM` double(7,0) DEFAULT NULL,
  90. `PLN` double(7,0) DEFAULT NULL,
  91. `RETRI` double(7,0) DEFAULT NULL,
  92. `ACC_DEP` double(7,0) DEFAULT NULL,
  93. `PRE_EXPENSE` double(7,0) DEFAULT NULL,
  94. `DEPOSIT` double(7,0) DEFAULT NULL,
  95. `USERNAME` varchar(15) DEFAULT NULL,
  96. PRIMARY KEY (`KODE_FIN`)
  97. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  98.  
  99. -- ----------------------------
  100. -- Table structure for t_gaji
  101. -- ----------------------------
  102. CREATE TABLE `t_gaji` (
  103. `id_transgaji` varchar(12) NOT NULL DEFAULT '',
  104. `id_karyawan` varchar(25) NOT NULL DEFAULT '',
  105. `date_tr` date DEFAULT NULL,
  106. `Salary_Value` double DEFAULT NULL,
  107. `bonus` double DEFAULT NULL,
  108. `total_paid` double DEFAULT NULL,
  109. `salary_payable` double DEFAULT NULL,
  110. PRIMARY KEY (`id_transgaji`)
  111. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  112.  
  113. -- ----------------------------
  114. -- Table structure for t_item
  115. -- ----------------------------
  116. CREATE TABLE `t_item` (
  117. `KODE_ITEM` varchar(15) NOT NULL DEFAULT '0',
  118. `NAMA_ITEM` varchar(50) DEFAULT NULL,
  119. `product` varchar(2) DEFAULT NULL,
  120. `UNIT` varchar(10) DEFAULT NULL,
  121. `RAT` double(5,0) DEFAULT NULL,
  122. PRIMARY KEY (`KODE_ITEM`)
  123. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  124.  
  125. -- ----------------------------
  126. -- Table structure for t_item_belanja
  127. -- ----------------------------
  128. CREATE TABLE `t_item_belanja` (
  129. `ID_BELANJA` int(11) NOT NULL AUTO_INCREMENT,
  130. `KODE_PO` varchar(10) DEFAULT NULL,
  131. `KODE_ITEM` varchar(15) DEFAULT NULL,
  132. `QTY` double(15,0) DEFAULT NULL,
  133. `UNIT` varchar(15) DEFAULT NULL,
  134. `HARGA` double(15,0) DEFAULT NULL,
  135. `TOTAL` double(15,0) DEFAULT NULL,
  136. PRIMARY KEY (`ID_BELANJA`)
  137. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
  138.  
  139. -- ----------------------------
  140. -- Table structure for t_karyawan
  141. -- ----------------------------
  142. CREATE TABLE `t_karyawan` (
  143. `id_karyawan` varchar(25) NOT NULL DEFAULT '',
  144. `reg_date` date DEFAULT NULL,
  145. `name` varchar(50) DEFAULT NULL,
  146. `address` varchar(50) DEFAULT NULL,
  147. `phone` varchar(15) DEFAULT NULL,
  148. `position` varchar(25) DEFAULT NULL,
  149. `salary_pr` double DEFAULT NULL,
  150. `layoff` date DEFAULT NULL,
  151. PRIMARY KEY (`id_karyawan`)
  152. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  153.  
  154. -- ----------------------------
  155. -- Table structure for t_member
  156. -- ----------------------------
  157. CREATE TABLE `t_member` (
  158. `ID_MEMBER` varchar(25) NOT NULL DEFAULT '',
  159. `Form_Number` varchar(25) DEFAULT NULL,
  160. `REG_DATE` date DEFAULT NULL,
  161. `MEMBER_NAME` varchar(25) DEFAULT NULL,
  162. `NICK` varchar(15) DEFAULT NULL,
  163. `NO_ID` varchar(25) DEFAULT NULL,
  164. `TYPE_ID` varchar(10) DEFAULT NULL,
  165. `ADDR` varchar(50) DEFAULT NULL,
  166. `BP` varchar(25) DEFAULT NULL,
  167. `BD` date DEFAULT NULL,
  168. `PHONE` varchar(15) DEFAULT NULL,
  169. `EMAIL` varchar(25) DEFAULT NULL,
  170. `VALIDTH` date DEFAULT NULL,
  171. PRIMARY KEY (`ID_MEMBER`)
  172. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  173.  
  174. -- ----------------------------
  175. -- Table structure for t_menu
  176. -- ----------------------------
  177. CREATE TABLE `t_menu` (
  178. `CODE_MENU` varchar(15) NOT NULL DEFAULT '',
  179. `MENU` varchar(50) DEFAULT NULL,
  180. `QTY` double(15,0) DEFAULT NULL,
  181. `AMOUNT` double(15,0) DEFAULT NULL,
  182. PRIMARY KEY (`CODE_MENU`)
  183. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  184.  
  185. -- ----------------------------
  186. -- Table structure for t_transaksi
  187. -- ----------------------------
  188. CREATE TABLE `t_transaksi` (
  189. `ID_TRANS` int(11) NOT NULL AUTO_INCREMENT,
  190. `NOTA` varchar(25) DEFAULT NULL,
  191. `DATE` date DEFAULT NULL,
  192. `CODE_MENU` varchar(15) DEFAULT NULL,
  193. `HARGA` double(15,0) DEFAULT NULL,
  194. `QTY` double(15,0) DEFAULT NULL,
  195. `ID_MEMBER` varchar(25) DEFAULT NULL,
  196. `CUSTOMER` varchar(25) DEFAULT NULL,
  197. `MEJA` varchar(3) DEFAULT NULL,
  198. `PAID` varchar(3) DEFAULT NULL,
  199. `CLEAR` varchar(3) DEFAULT NULL,
  200. `VISIBLE` char(2) DEFAULT NULL,
  201. PRIMARY KEY (`ID_TRANS`)
  202. ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
  203.  
  204. -- ----------------------------
  205. -- Table structure for t_user
  206. -- ----------------------------
  207. CREATE TABLE `t_user` (
  208. `username` varchar(15) NOT NULL,
  209. `password` varchar(15) DEFAULT NULL,
  210. `type` varchar(15) DEFAULT NULL,
  211. PRIMARY KEY (`username`)
  212. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  213.  
  214. -- ----------------------------
  215. -- View structure for nota
  216. -- ----------------------------
  217. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `nota` AS select distinct sum(`t_transaksi`.`QTY`) AS `Sum(t_transaksi.QTY)`,`t_transaksi`.`NOTA` AS `NOTA` from `t_transaksi` group by `t_transaksi`.`NOTA`;
  218.  
  219. -- ----------------------------
  220. -- View structure for tes_member2
  221. -- ----------------------------
  222. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tes_member2` AS select `a`.`NOTA` AS `NOTA`,`a`.`ID_TRANS` AS `ID_TRANS`,`a`.`DATE` AS `DATE`,`a`.`CODE_MENU` AS `CODE_MENU`,`a`.`HARGA` AS `HARGA`,sum(`a`.`QTY`) AS `Tot_Qty`,`a`.`ID_MEMBER` AS `ID_MEMBER`,`a`.`CUSTOMER` AS `CUSTOMER`,`a`.`MEJA` AS `MEJA`,`a`.`PAID` AS `PAID`,`a`.`CLEAR` AS `CLEAR`,`a`.`VISIBLE` AS `VISIBLE` from `t_transaksi` `a` group by `a`.`NOTA`;
  223.  
  224. -- ----------------------------
  225. -- View structure for vw_bayar1
  226. -- ----------------------------
  227. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar1` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'1') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  228.  
  229. -- ----------------------------
  230. -- View structure for vw_bayar10
  231. -- ----------------------------
  232. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar10` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'10') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  233.  
  234. -- ----------------------------
  235. -- View structure for vw_bayar11
  236. -- ----------------------------
  237. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar11` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'11') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  238.  
  239. -- ----------------------------
  240. -- View structure for vw_bayar12
  241. -- ----------------------------
  242. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar12` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'12') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  243.  
  244. -- ----------------------------
  245. -- View structure for vw_bayar13
  246. -- ----------------------------
  247. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar13` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'13') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  248.  
  249. -- ----------------------------
  250. -- View structure for vw_bayar14
  251. -- ----------------------------
  252. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar14` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'14') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  253.  
  254. -- ----------------------------
  255. -- View structure for vw_bayar2
  256. -- ----------------------------
  257. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar2` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'2') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  258.  
  259. -- ----------------------------
  260. -- View structure for vw_bayar3
  261. -- ----------------------------
  262. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar3` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'3') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  263.  
  264. -- ----------------------------
  265. -- View structure for vw_bayar4
  266. -- ----------------------------
  267. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar4` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'4') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  268.  
  269. -- ----------------------------
  270. -- View structure for vw_bayar5
  271. -- ----------------------------
  272. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar5` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'5') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  273.  
  274. -- ----------------------------
  275. -- View structure for vw_bayar6
  276. -- ----------------------------
  277. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar6` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'6') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  278.  
  279. -- ----------------------------
  280. -- View structure for vw_bayar7
  281. -- ----------------------------
  282. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar7` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'7') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  283.  
  284. -- ----------------------------
  285. -- View structure for vw_bayar8
  286. -- ----------------------------
  287. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar8` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'8') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  288.  
  289. -- ----------------------------
  290. -- View structure for vw_bayar9
  291. -- ----------------------------
  292. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayar9` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'9') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  293.  
  294. -- ----------------------------
  295. -- View structure for vw_bayarx
  296. -- ----------------------------
  297. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_bayarx` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,sum((`t_transaksi`.`QTY` * `t_transaksi`.`HARGA`)) AS `TOTAL` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'X') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  298.  
  299. -- ----------------------------
  300. -- View structure for vw_gaji
  301. -- ----------------------------
  302. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_gaji` AS select `t_karyawan`.`id_karyawan` AS `id_karyawan`,`t_karyawan`.`name` AS `name`,`t_gaji`.`date_tr` AS `date_tr`,sum(`t_gaji`.`Salary_Value`) AS `salary`,sum(`t_gaji`.`bonus`) AS `BONUS`,sum(`t_gaji`.`total_paid`) AS `total_paid`,`t_gaji`.`salary_payable` AS `salary_payable`,`t_karyawan`.`salary_pr` AS `salary_pr`,`t_karyawan`.`address` AS `address` from (`t_gaji` join `t_karyawan` on((`t_gaji`.`id_karyawan` = `t_karyawan`.`id_karyawan`))) group by `t_karyawan`.`id_karyawan`,`t_karyawan`.`name`,substr(`t_gaji`.`date_tr`,6,2);
  303.  
  304. -- ----------------------------
  305. -- View structure for vw_grafik
  306. -- ----------------------------
  307. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_grafik` AS select `t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS`,`t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,sum(`t_transaksi`.`QTY`) AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`CUSTOMER` AS `CUSTOMER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`VISIBLE` AS `VISIBLE` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) group by `t_transaksi`.`DATE`;
  308.  
  309. -- ----------------------------
  310. -- View structure for vw_lap_belanja
  311. -- ----------------------------
  312. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lap_belanja` AS select `b`.`KODE_ITEM` AS `KODE_ITEM`,`b`.`QTY` AS `QTY`,`b`.`UNIT` AS `UNIT`,`b`.`HARGA` AS `HARGA`,`a`.`USERNAME` AS `USERNAME`,`b`.`TOTAL` AS `TOTAL`,`a`.`KODE_PO` AS `KODE_PO`,`a`.`TGL_PO` AS `TGL_PO`,`t_item`.`NAMA_ITEM` AS `NAMA_ITEM` from ((`t_belanja` `a` join `t_item_belanja` `b` on((`a`.`KODE_PO` = `b`.`KODE_PO`))) join `t_item` on((`b`.`KODE_ITEM` = `t_item`.`KODE_ITEM`)));
  313.  
  314. -- ----------------------------
  315. -- View structure for vw_lap_belanja_year
  316. -- ----------------------------
  317. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lap_belanja_year` AS select sum(`b`.`QTY`) AS `QTY`,`b`.`UNIT` AS `UNIT`,`b`.`HARGA` AS `HARGA`,`a`.`USERNAME` AS `USERNAME`,sum(`b`.`TOTAL`) AS `TOTAL`,`a`.`KODE_PO` AS `KODE_PO`,substr(`a`.`TGL_PO`,6,2) AS `MID(a.TGL_PO,6,2)`,`a`.`TGL_PO` AS `TGL_PO` from (`t_belanja` `a` join `t_item_belanja` `b` on((`a`.`KODE_PO` = `b`.`KODE_PO`))) group by substr(`a`.`TGL_PO`,6,2);
  318.  
  319. -- ----------------------------
  320. -- View structure for vw_lap_day
  321. -- ----------------------------
  322. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lap_day` AS select `a`.`ID_TRANS` AS `ID_TRANS`,`a`.`NOTA` AS `NOTA`,`a`.`DATE` AS `DATE`,`a`.`CODE_MENU` AS `CODE_MENU`,`a`.`HARGA` AS `HARGA`,`a`.`QTY` AS `QTY`,`a`.`ID_MEMBER` AS `ID_MEMBER`,`a`.`CUSTOMER` AS `CUSTOMER`,`a`.`MEJA` AS `MEJA`,`a`.`PAID` AS `PAID`,`a`.`CLEAR` AS `CLEAR`,`a`.`VISIBLE` AS `VISIBLE`,`b`.`BAYAR` AS `BAYAR`,`b`.`TOTAL` AS `TOTAL`,`b`.`DISC` AS `DISC`,`b`.`VDISC` AS `VDISC`,`b`.`KEMBALI` AS `KEMBALI`,`c`.`MENU` AS `MENU`,`b`.`QTY_TOTAL` AS `Tot_QTY` from ((`t_transaksi` `a` join `t_bayar` `b` on((`a`.`NOTA` = `b`.`NOTA`))) join `t_menu` `c` on((`a`.`CODE_MENU` = `c`.`CODE_MENU`))) group by `a`.`NOTA`,`a`.`CODE_MENU`;
  323.  
  324. -- ----------------------------
  325. -- View structure for vw_lap_jual_month
  326. -- ----------------------------
  327. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lap_jual_month` AS select `t_bayar`.`DATE` AS `DATE`,sum(`t_bayar`.`QTY_TOTAL`) AS `QTY`,sum(`t_bayar`.`TOTAL`) AS `TOTAL`,sum(`t_bayar`.`VDISC`) AS `VDISC`,(sum(`t_bayar`.`TOTAL`) - sum(`t_bayar`.`VDISC`)) AS `NET_TOTAL` from `t_bayar` group by `t_bayar`.`DATE`;
  328.  
  329. -- ----------------------------
  330. -- View structure for vw_lap_jual_year
  331. -- ----------------------------
  332. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lap_jual_year` AS select `t_bayar`.`DATE` AS `DATE`,sum(`t_bayar`.`QTY_TOTAL`) AS `QTY`,sum(`t_bayar`.`TOTAL`) AS `TOTAL`,sum(`t_bayar`.`VDISC`) AS `VDISC`,(sum(`t_bayar`.`TOTAL`) - sum(`t_bayar`.`VDISC`)) AS `NET_TOTAL` from `t_bayar` group by substr(`t_bayar`.`DATE`,6,2);
  333.  
  334. -- ----------------------------
  335. -- View structure for vw_meja1
  336. -- ----------------------------
  337. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja1` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'1') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  338.  
  339. -- ----------------------------
  340. -- View structure for vw_meja10
  341. -- ----------------------------
  342. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja10` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'10') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  343.  
  344. -- ----------------------------
  345. -- View structure for vw_meja11
  346. -- ----------------------------
  347. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja11` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'11') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  348.  
  349. -- ----------------------------
  350. -- View structure for vw_meja12
  351. -- ----------------------------
  352. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja12` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'12') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  353.  
  354. -- ----------------------------
  355. -- View structure for vw_meja13
  356. -- ----------------------------
  357. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja13` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'13') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  358.  
  359. -- ----------------------------
  360. -- View structure for vw_meja14
  361. -- ----------------------------
  362. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja14` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'14') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  363.  
  364. -- ----------------------------
  365. -- View structure for vw_meja2
  366. -- ----------------------------
  367. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja2` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `ITEM`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'2') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  368.  
  369. -- ----------------------------
  370. -- View structure for vw_meja3
  371. -- ----------------------------
  372. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja3` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'3') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  373.  
  374. -- ----------------------------
  375. -- View structure for vw_meja4
  376. -- ----------------------------
  377. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja4` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'4') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  378.  
  379. -- ----------------------------
  380. -- View structure for vw_meja5
  381. -- ----------------------------
  382. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja5` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'5') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  383.  
  384. -- ----------------------------
  385. -- View structure for vw_meja6
  386. -- ----------------------------
  387. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja6` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'6') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  388.  
  389. -- ----------------------------
  390. -- View structure for vw_meja7
  391. -- ----------------------------
  392. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja7` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'7') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  393.  
  394. -- ----------------------------
  395. -- View structure for vw_meja8
  396. -- ----------------------------
  397. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja8` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'8') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  398.  
  399. -- ----------------------------
  400. -- View structure for vw_meja9
  401. -- ----------------------------
  402. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_meja9` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'9') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  403.  
  404. -- ----------------------------
  405. -- View structure for vw_mejax
  406. -- ----------------------------
  407. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_mejax` AS select `t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`ID_MEMBER` AS `ID_MEMBER`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`PAID` AS `PAID`,`t_transaksi`.`CODE_MENU` AS `CODE_MENU`,`t_menu`.`MENU` AS `MENU`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`ID_TRANS` AS `ID_TRANS` from (`t_transaksi` join `t_menu` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'X') and (`t_transaksi`.`VISIBLE` = _utf8'T') and (`t_transaksi`.`CLEAR` = _utf8'F'));
  408.  
  409. -- ----------------------------
  410. -- View structure for vw_nota
  411. -- ----------------------------
  412. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_nota` AS select distinct `a`.`NOTA` AS `NOTA`,`a`.`DATE` AS `DATE`,`a`.`CODE_MENU` AS `CODE_MENU`,`b`.`MENU` AS `MENU`,`a`.`HARGA` AS `HARGA`,`a`.`QTY` AS `QTY`,`a`.`ID_MEMBER` AS `ID_MEMBER`,`a`.`CUSTOMER` AS `CUSTOMER`,(`a`.`QTY` * `a`.`HARGA`) AS `total` from (`t_transaksi` `a` join `t_menu` `b` on((`a`.`CODE_MENU` = `b`.`CODE_MENU`)));
  413.  
  414. -- ----------------------------
  415. -- View structure for vw_nota_tot_detail
  416. -- ----------------------------
  417. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_nota_tot_detail` AS select sum(`t_bayar`.`TOTAL`) AS `Total2`,sum(`t_bayar`.`VDISC`) AS `VDisc2`,`t_bayar`.`DATE` AS `DATE` from `t_bayar` group by `t_bayar`.`DATE`;
  418.  
  419. -- ----------------------------
  420. -- View structure for vw_purchase
  421. -- ----------------------------
  422. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_purchase` AS select `b`.`KODE_ITEM` AS `KODE_ITEM`,`b`.`QTY` AS `QTY`,`b`.`UNIT` AS `UNIT`,`a`.`KODE_PO` AS `KODE_PO`,`a`.`TGL_PO` AS `TGL_PO`,`a`.`USERNAME` AS `USERNAME`,`a`.`TOTAL` AS `TOTAL`,`a`.`STATUS` AS `STATUS` from (`t_belanja` `a` join `t_item_belanja` `b` on((`a`.`KODE_PO` = `b`.`KODE_PO`)));
  423.  
  424. -- ----------------------------
  425. -- View structure for vw_r_bayar_meja1
  426. -- ----------------------------
  427. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_r_bayar_meja1` AS select `a`.`NOTA` AS `NOTA`,`a`.`DATE` AS `DATE`,`a`.`HARGA` AS `HARGA`,`a`.`QTY` AS `QTY`,`a`.`ID_MEMBER` AS `ID_MEMBER`,`a`.`MEJA` AS `MEJA`,`a`.`PAID` AS `PAID`,`a`.`CODE_MENU` AS `CODE_MENU`,`b`.`MENU` AS `MENU`,`a`.`CLEAR` AS `CLEAR`,`a`.`ID_TRANS` AS `ID_TRANS`,(`a`.`QTY` * `a`.`HARGA`) AS `TOTAL_MENU` from (`t_transaksi` `a` join `t_menu` `b` on((`a`.`CODE_MENU` = `b`.`CODE_MENU`))) where ((`a`.`MEJA` = _utf8'1') and (`a`.`VISIBLE` = _utf8'T') and (`a`.`CLEAR` = _utf8'F'));
  428.  
  429. -- ----------------------------
  430. -- View structure for vw_sum_qty
  431. -- ----------------------------
  432. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_sum_qty` AS select `a`.`NOTA` AS `NOTA`,`a`.`ID_TRANS` AS `ID_TRANS`,`a`.`DATE` AS `DATE`,`a`.`CODE_MENU` AS `CODE_MENU`,`a`.`HARGA` AS `HARGA`,sum(`a`.`QTY`) AS `Tot_Qty`,`a`.`ID_MEMBER` AS `ID_MEMBER`,`a`.`CUSTOMER` AS `CUSTOMER`,`a`.`MEJA` AS `MEJA`,`a`.`PAID` AS `PAID`,`a`.`CLEAR` AS `CLEAR`,`a`.`VISIBLE` AS `VISIBLE` from `t_transaksi` `a` group by `a`.`NOTA`;
  433.  
  434. -- ----------------------------
  435. -- View structure for vw_tot1
  436. -- ----------------------------
  437. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot1` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'1') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  438.  
  439. -- ----------------------------
  440. -- View structure for vw_tot10
  441. -- ----------------------------
  442. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot10` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'10') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  443.  
  444. -- ----------------------------
  445. -- View structure for vw_tot11
  446. -- ----------------------------
  447. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot11` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'11') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  448.  
  449. -- ----------------------------
  450. -- View structure for vw_tot12
  451. -- ----------------------------
  452. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot12` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'12') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  453.  
  454. -- ----------------------------
  455. -- View structure for vw_tot13
  456. -- ----------------------------
  457. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot13` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'13') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  458.  
  459. -- ----------------------------
  460. -- View structure for vw_tot14
  461. -- ----------------------------
  462. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot14` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'14') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  463.  
  464. -- ----------------------------
  465. -- View structure for vw_tot2
  466. -- ----------------------------
  467. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot2` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'2') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  468.  
  469. -- ----------------------------
  470. -- View structure for vw_tot3
  471. -- ----------------------------
  472. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot3` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'3') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  473.  
  474. -- ----------------------------
  475. -- View structure for vw_tot4
  476. -- ----------------------------
  477. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot4` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'4') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  478.  
  479. -- ----------------------------
  480. -- View structure for vw_tot5
  481. -- ----------------------------
  482. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot5` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'5') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  483.  
  484. -- ----------------------------
  485. -- View structure for vw_tot6
  486. -- ----------------------------
  487. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot6` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'6') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  488.  
  489. -- ----------------------------
  490. -- View structure for vw_tot7
  491. -- ----------------------------
  492. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot7` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'7') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  493.  
  494. -- ----------------------------
  495. -- View structure for vw_tot8
  496. -- ----------------------------
  497. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot8` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'8') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  498.  
  499. -- ----------------------------
  500. -- View structure for vw_tot9
  501. -- ----------------------------
  502. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_tot9` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'9') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  503.  
  504. -- ----------------------------
  505. -- View structure for vw_totx
  506. -- ----------------------------
  507. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_totx` AS select sum((`t_transaksi`.`HARGA` * `t_transaksi`.`QTY`)) AS `Total`,`t_transaksi`.`HARGA` AS `HARGA`,`t_transaksi`.`MEJA` AS `MEJA`,`t_transaksi`.`QTY` AS `QTY`,`t_transaksi`.`CLEAR` AS `CLEAR`,`t_transaksi`.`NOTA` AS `NOTA` from (`t_menu` join `t_transaksi` on((`t_transaksi`.`CODE_MENU` = `t_menu`.`CODE_MENU`))) where ((`t_transaksi`.`MEJA` = _utf8'X') and (`t_transaksi`.`PAID` = _utf8'F') and (`t_transaksi`.`CLEAR` = _utf8'F')) group by `t_transaksi`.`NOTA`;
  508.  
  509. -- ----------------------------
  510. -- View structure for vw_trans_distinc
  511. -- ----------------------------
  512. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_trans_distinc` AS select distinct sum(`t_transaksi`.`QTY`) AS `QTY`,`t_transaksi`.`NOTA` AS `NOTA`,`t_transaksi`.`DATE` AS `DATE` from `t_transaksi` group by `t_transaksi`.`DATE`;
  513.  
  514. -- ----------------------------
  515. -- Records
  516. -- ----------------------------
  517. INSERT INTO `auto` VALUES ('0', '16', '2', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  518. INSERT INTO `t_bayar` VALUES ('000001', '', '', '2013-01-19', '12000', '2', '10000', '0', '0', '2000', '1', null);
  519. INSERT INTO `t_bayar` VALUES ('000003', '111 001 150676', '', '2013-02-05', '500000', '7', '36000', '10', '3600', '470840', '1', null);
  520. INSERT INTO `t_bayar` VALUES ('000004', '111 001 150676', '', '2013-02-01', '40000', '5', '37000', '10', '3700', '6700', 'x', null);
  521. INSERT INTO `t_bayar` VALUES ('000005', '', 'maya ', '2013-02-01', '70000', '11', '68000', '0', '0', '2000', '3', null);
  522. INSERT INTO `t_bayar` VALUES ('000006', '111 002 160886', '', '2013-02-01', '20000', '5', '20000', '10', '2000', '2000', '6', null);
  523. INSERT INTO `t_bayar` VALUES ('000007', '', 'albert', '2013-02-01', '55000', '11', '54500', '0', '0', '500', '14', null);
  524. INSERT INTO `t_bayar` VALUES ('000008', '', '', '2013-02-02', '60000', '8', '58000', '0', '0', '2000', 'x', null);
  525. INSERT INTO `t_bayar` VALUES ('000009', '111 004 051292', '', '2013-02-02', '32000', '5', '31000', '10', '3100', '4100', '9', null);
  526. INSERT INTO `t_bayar` VALUES ('000010', '', 'huda ', '2013-02-02', '65000', '11', '64500', '0', '0', '500', '9', null);
  527. INSERT INTO `t_bayar` VALUES ('000011', '111 002 160886', '', '2013-04-19', '20000', '5', '19000', '10', '1900', '4610', '1', null);
  528. INSERT INTO `t_bayar` VALUES ('000012', '111 001 150676', '', '2013-04-27', '70000', '10', '65000', '10', '6500', '17350', '1', null);
  529. INSERT INTO `t_bayar` VALUES ('000013', '111 001 150676', '', '2013-04-27', '69000', '9', '69000', '10', '6900', '13110', '1', null);
  530. INSERT INTO `t_bayar` VALUES ('000014', '111 001 150676', '', '2013-04-27', '90000', '12', '86000', '10', '8600', '20340', '1', null);
  531. INSERT INTO `t_bayar` VALUES ('000015', '111 001 150676', '', '2013-04-27', '70000', '9', '69000', '10', '6900', '14110', '1', null);
  532. INSERT INTO `t_bayar` VALUES ('000016', '111 001 150676', '', '2013-04-27', '17500', '5', '17500', '10', '1750', '3325', '1', null);
  533. INSERT INTO `t_belanja` VALUES ('000001', '2013-02-01', 'DIANA', '148500', 'F');
  534. INSERT INTO `t_belanja` VALUES ('000002', '2013-03-07', 'DIANA', '194000', 'F');
  535. INSERT INTO `t_belanja` VALUES ('000003', '2013-02-02', 'NURMA', '112500', 'F');
  536. INSERT INTO `t_finance` VALUES ('000001', '2013-01-31', '2013-02-01', '30000', '0', '0', '0', '173800', '3000', '0', '10000', '50000', '0', '0', '0', null, '3476', '10000', '-15176', 'SPV');
  537. INSERT INTO `t_finance` VALUES ('000002', '2013-02-01', '2013-02-02', '25000', '10000', '0', '173800', '0', '0', '10000', '0', '0', '0', '0', '0', null, '0', '0', '433800', 'SPV');
  538. INSERT INTO `t_item` VALUES ('AGLN', 'REFILL AIR', 'R', null, null);
  539. INSERT INTO `t_item` VALUES ('APLB', 'BUAH APEL', 'R', null, null);
  540. INSERT INTO `t_item` VALUES ('ASKA', 'TEPUNG ASOKA', null, 'KG', '0');
  541. INSERT INTO `t_item` VALUES ('AVKD', 'BUAH ALPUKAT', 'R', null, null);
  542. INSERT INTO `t_item` VALUES ('AYDD', 'AYAM DADA', 'R', null, null);
  543. INSERT INTO `t_item` VALUES ('AYPH', 'AYAM PAHA', 'R', null, null);
  544. INSERT INTO `t_item` VALUES ('BRNC', 'BROWNIEST COFFEE', 'P', null, null);
  545. INSERT INTO `t_item` VALUES ('BWBM', 'BAWANG BOMBAI', 'R', null, null);
  546. INSERT INTO `t_item` VALUES ('BWMER', 'BAWANG MERAH', null, 'KG', '0');
  547. INSERT INTO `t_item` VALUES ('BWPTH', 'BAWANG PUTIH', null, 'KG', '0');
  548. INSERT INTO `t_item` VALUES ('CBBH', 'CABE BESAR HIJAU', null, 'PCS', '0');
  549. INSERT INTO `t_item` VALUES ('CBBM', 'CABE BESAR MERAH', null, 'KG', '0');
  550. INSERT INTO `t_item` VALUES ('CBMB', 'CABAI MERAH BESAR', 'R', null, null);
  551. INSERT INTO `t_item` VALUES ('CBMK', 'CABAI MERAH KECIL', 'R', null, null);
  552. INSERT INTO `t_item` VALUES ('CKLB', 'COKLAT BATANGAN', 'R', null, null);
  553. INSERT INTO `t_item` VALUES ('CPP', 'CAPUCINNO', 'P', null, null);
  554. INSERT INTO `t_item` VALUES ('CRNB', 'CARNATION BESAR', 'R', null, null);
  555. INSERT INTO `t_item` VALUES ('CRNK', 'CARNATION KECIL', 'R', null, null);
  556. INSERT INTO `t_item` VALUES ('ESB', 'ES BATU', 'R', null, null);
  557. INSERT INTO `t_item` VALUES ('EXT J', 'EXTRA JOSS', 'R', null, null);
  558. INSERT INTO `t_item` VALUES ('GLMRH', 'GULA MERAH', null, 'KG', '0');
  559. INSERT INTO `t_item` VALUES ('GLP', 'GULA PASIR', 'R', null, null);
  560. INSERT INTO `t_item` VALUES ('GRM H', 'GARAM HALUS', 'R', null, null);
  561. INSERT INTO `t_item` VALUES ('GRM K', 'GARAM KASAR', 'R', null, null);
  562. INSERT INTO `t_item` VALUES ('HTC', 'HOT CHOCOLATE', 'R', null, null);
  563. INSERT INTO `t_item` VALUES ('JH', 'JAHE', 'R', null, null);
  564. INSERT INTO `t_item` VALUES ('JVA LT', 'JAVA LATTE', 'R', null, null);
  565. INSERT INTO `t_item` VALUES ('KBS', 'SAYUR KUBIS', 'R', null, null);
  566. INSERT INTO `t_item` VALUES ('KCP HTM', 'ABC KECAP HITAM', 'R', null, null);
  567. INSERT INTO `t_item` VALUES ('KEMANGI', 'DAUN KEMANGI', 'R', null, null);
  568. INSERT INTO `t_item` VALUES ('KJU', 'KEJU BATANGAN', 'R', null, null);
  569. INSERT INTO `t_item` VALUES ('KPL HTM', 'KAPAL API BUBUK', 'R', null, null);
  570. INSERT INTO `t_item` VALUES ('KPLG', 'KAPULAGA', 'R', null, null);
  571. INSERT INTO `t_item` VALUES ('KPS', 'KOPI SUSU', 'P', null, null);
  572. INSERT INTO `t_item` VALUES ('KTGP', 'KANTONG PLASTIK', 'P', null, null);
  573. INSERT INTO `t_item` VALUES ('LCSY', 'LECCY SYRUP', 'R', null, null);
  574. INSERT INTO `t_item` VALUES ('LDH', 'LADA HITAM', 'R', null, null);
  575. INSERT INTO `t_item` VALUES ('LDP', 'LADA PUTIH', 'R', null, null);
  576. INSERT INTO `t_item` VALUES ('LL', 'LELE', null, 'KG', '0');
  577. INSERT INTO `t_item` VALUES ('LMNT', 'LEMON TEA', 'P', null, null);
  578. INSERT INTO `t_item` VALUES ('MD', 'MADU', 'R', null, null);
  579. INSERT INTO `t_item` VALUES ('MGA', 'BUAH MANGGA', 'R', null, null);
  580. INSERT INTO `t_item` VALUES ('MGRF', 'MINYAK GORENG REFILL', 'R', null, null);
  581. INSERT INTO `t_item` VALUES ('MGRN', 'MARGARIN', 'R', null, null);
  582. INSERT INTO `t_item` VALUES ('MRJR', 'MINYAK RAJA RASA', 'R', null, null);
  583. INSERT INTO `t_item` VALUES ('MSS', 'MESSES', 'R', null, null);
  584. INSERT INTO `t_item` VALUES ('PRMN', 'PERMEN', 'R', null, null);
  585. INSERT INTO `t_item` VALUES ('PSNG', 'PISANG', 'R', null, null);
  586. INSERT INTO `t_item` VALUES ('PTT', 'KENTANG', 'R', null, null);
  587. INSERT INTO `t_item` VALUES ('RTTW', 'ROTI TAWAR', 'R', null, null);
  588. INSERT INTO `t_item` VALUES ('SBL SC', 'ABC SAMBAL SACHET', null, '', '0');
  589. INSERT INTO `t_item` VALUES ('SBN CUCI', 'SABUN CUCI', 'R', null, null);
  590. INSERT INTO `t_item` VALUES ('SBN MD', 'SABUN MANDI', 'R', null, null);
  591. INSERT INTO `t_item` VALUES ('SBN SUN', 'SABUN SUNLIGHT', 'R', null, null);
  592. INSERT INTO `t_item` VALUES ('SBN TGN', 'SABUN CUCI TANGAN', 'R', null, null);
  593. INSERT INTO `t_item` VALUES ('SDKF', 'SODA KRAT FANTA', 'P', null, null);
  594. INSERT INTO `t_item` VALUES ('SLBB', 'SELAI BLUEBERRY', 'R', null, null);
  595. INSERT INTO `t_item` VALUES ('SLKC', 'SELAI KACANG', 'R', null, null);
  596. INSERT INTO `t_item` VALUES ('SLNS', 'SELAI NANAS', 'R', null, null);
  597. INSERT INTO `t_item` VALUES ('SLST', 'SELAI STRAWBERRY', 'R', null, null);
  598. INSERT INTO `t_item` VALUES ('SNTP', 'SNACK TEMPE', 'P', null, null);
  599. INSERT INTO `t_item` VALUES ('SNTT', 'SNACK CAMPUR', 'P', null, null);
  600. INSERT INTO `t_item` VALUES ('soda', 'fanta', null, 'BKS', null);
  601. INSERT INTO `t_item` VALUES ('SR', 'SERE', 'R', null, null);
  602. INSERT INTO `t_item` VALUES ('SSC SC', 'ABC SAUS SACHET', null, '', '0');
  603. INSERT INTO `t_item` VALUES ('SSS', 'SOSIS', null, 'BKS', '0');
  604. INSERT INTO `t_item` VALUES ('SSU CK', 'SUSU COKLAT', 'R', null, null);
  605. INSERT INTO `t_item` VALUES ('STRM', 'SAUS TIRAM', null, 'BTL', '1');
  606. INSERT INTO `t_item` VALUES ('STRW', 'STRAWBERRY', 'R', null, null);
  607. INSERT INTO `t_item` VALUES ('SYR', 'SAYUR', 'R', null, null);
  608. INSERT INTO `t_item` VALUES ('THMTG', 'TAHU GORENG', null, 'BKS', '0');
  609. INSERT INTO `t_item` VALUES ('THU MTG', 'TAHU MATANG', 'R', null, null);
  610. INSERT INTO `t_item` VALUES ('THU MTH', 'TAHU MENTAH', 'R', null, null);
  611. INSERT INTO `t_item` VALUES ('TIMUN', 'TIMUN SAYUR', null, 'PCS', '0');
  612. INSERT INTO `t_item` VALUES ('TLR', 'TELUR', 'R', null, null);
  613. INSERT INTO `t_item` VALUES ('TMN', 'TIMUN', 'R', null, null);
  614. INSERT INTO `t_item` VALUES ('TMP', 'TEMPE', 'R', null, null);
  615. INSERT INTO `t_item` VALUES ('TMTB', 'TOMAT BUAH', 'R', null, null);
  616. INSERT INTO `t_item` VALUES ('TMTS', 'TOMAT SAMBAL', 'R', null, null);
  617. INSERT INTO `t_item` VALUES ('TPGB', 'TEPUNG BERAS', 'R', null, null);
  618. INSERT INTO `t_item` VALUES ('TRG', 'SAYUR TERONG', null, 'PCS', '0');
  619. INSERT INTO `t_item` VALUES ('WHTC', 'WHITE COFFEE', 'P', null, null);
  620. INSERT INTO `t_item_belanja` VALUES ('1', '000001', 'AGLN', '2', '', '4000', '8000');
  621. INSERT INTO `t_item_belanja` VALUES ('2', '000001', 'AYDD', '2', '', '25000', '50000');
  622. INSERT INTO `t_item_belanja` VALUES ('3', '000001', 'KCP HTM', '1', '', '15000', '15000');
  623. INSERT INTO `t_item_belanja` VALUES ('4', '000001', 'MGRF', '2', '', '12500', '25000');
  624. INSERT INTO `t_item_belanja` VALUES ('5', '000001', 'ASKA', '1', 'KG', '5000', '5000');
  625. INSERT INTO `t_item_belanja` VALUES ('6', '000001', 'BWBM', '1', '', '22000', '22000');
  626. INSERT INTO `t_item_belanja` VALUES ('7', '000001', 'MRJR', '1', '', '23500', '23500');
  627. INSERT INTO `t_item_belanja` VALUES ('8', '000002', 'MGA', '2', '', '10000', '20000');
  628. INSERT INTO `t_item_belanja` VALUES ('9', '000002', 'MGRN', '2', '', '13000', '26000');
  629. INSERT INTO `t_item_belanja` VALUES ('10', '000002', 'JVA LT', '12', '', '833', '10000');
  630. INSERT INTO `t_item_belanja` VALUES ('11', '000002', 'CKLB', '2', '', '15000', '30000');
  631. INSERT INTO `t_item_belanja` VALUES ('12', '000002', 'CPP', '45', '', '1667', '75000');
  632. INSERT INTO `t_item_belanja` VALUES ('13', '000002', 'AVKD', '3', '', '11000', '33000');
  633. INSERT INTO `t_item_belanja` VALUES ('14', '000003', 'HTC', '10', '', '2000', '20000');
  634. INSERT INTO `t_item_belanja` VALUES ('15', '000003', 'CPP', '30', '', '1250', '37500');
  635. INSERT INTO `t_item_belanja` VALUES ('16', '000003', 'BRNC', '3', '', '10000', '30000');
  636. INSERT INTO `t_item_belanja` VALUES ('17', '000003', 'RTTW', '2', '', '12500', '25000');
  637. INSERT INTO `t_menu` VALUES ('APEL', 'JUS APPLE', '1', '5000');
  638. INSERT INTO `t_menu` VALUES ('AYM', 'AYAM GORENG', '1', '9000');
  639. INSERT INTO `t_menu` VALUES ('BKSO', 'BAKSO', '1', '5000');
  640. INSERT INTO `t_menu` VALUES ('BLKC', 'KOPI HITAM', '1', '3000');
  641. INSERT INTO `t_menu` VALUES ('BLKJ', 'KOPI HITAM JAHE', '1', '3500');
  642. INSERT INTO `t_menu` VALUES ('BNGJ', 'JUS BUAH NAGA', '1', '6000');
  643. INSERT INTO `t_menu` VALUES ('BRNC', 'BROWNIES COFFEE', '1', '3500');
  644. INSERT INTO `t_menu` VALUES ('CMT', 'CHIKEN MUSHROOM TIRAM', '1', '11000');
  645. INSERT INTO `t_menu` VALUES ('CPPH', 'HOT CAPUCINNO', '1', '3500');
  646. INSERT INTO `t_menu` VALUES ('CPPJ', 'JUS CAPUCINNO', '1', '5000');
  647. INSERT INTO `t_menu` VALUES ('FRT', 'FRIES TEMPE', '1', '5000');
  648. INSERT INTO `t_menu` VALUES ('FSN', 'FRIED CHIKEN SAUS NANAS', '1', '11000');
  649. INSERT INTO `t_menu` VALUES ('GRSD', 'GREEN SODA', '1', '6000');
  650. INSERT INTO `t_menu` VALUES ('HTCK', 'HOT CHOCOLATE', '1', '5000');
  651. INSERT INTO `t_menu` VALUES ('JALP', 'JUS ALPUKAT', '1', '5000');
  652. INSERT INTO `t_menu` VALUES ('JBUJ', 'JUS JAMBU', '1', '5000');
  653. INSERT INTO `t_menu` VALUES ('JOSH', 'JOSHUA', '1', '5000');
  654. INSERT INTO `t_menu` VALUES ('JRNH', 'JERUK NIEPEACE HOT', '1', '2500');
  655. INSERT INTO `t_menu` VALUES ('JRNI', 'JERUK NIEPEACE ICE', '1', '3000');
  656. INSERT INTO `t_menu` VALUES ('JSHH', 'JOSHUA HANGAT', '1', '5000');
  657. INSERT INTO `t_menu` VALUES ('JSMH', 'JASMINE TEA HANGAT', '1', '2000');
  658. INSERT INTO `t_menu` VALUES ('JSTI', 'JASMINE TEA ICE', '1', '2500');
  659. INSERT INTO `t_menu` VALUES ('KPRM', 'KOPI REMPAH MADU', '1', '5000');
  660. INSERT INTO `t_menu` VALUES ('KPSS', 'KOPI SUSU', '1', '3000');
  661. INSERT INTO `t_menu` VALUES ('KTG', 'KENTANG GORENG', '1', '4500');
  662. INSERT INTO `t_menu` VALUES ('LCYJ', 'JUS LECCY', '1', '5000');
  663. INSERT INTO `t_menu` VALUES ('LLP', 'LELE LALAPAN', '1', '7500');
  664. INSERT INTO `t_menu` VALUES ('LMNTI', 'LEMON TEA ICE', '1', '3000');
  665. INSERT INTO `t_menu` VALUES ('LMTH', 'LEMON TEA HANGAT', '1', '3500');
  666. INSERT INTO `t_menu` VALUES ('LPAY', 'LALAPAN AYAM', '1', '9000');
  667. INSERT INTO `t_menu` VALUES ('LTEC', 'COFFEE LATTE', '1', '4000');
  668. INSERT INTO `t_menu` VALUES ('LTEI', 'LATTE ICE', '1', '5000');
  669. INSERT INTO `t_menu` VALUES ('LTP', 'LALAPAN TEMPE', '1', '6000');
  670. INSERT INTO `t_menu` VALUES ('MGGJ', 'JUS MANGGA', '1', '5000');
  671. INSERT INTO `t_menu` VALUES ('MLNJ', 'JUS MELON', '1', '5000');
  672. INSERT INTO `t_menu` VALUES ('NGSS', 'NASI GORENG SOSIS', '1', '8500');
  673. INSERT INTO `t_menu` VALUES ('NSGO', 'NASI GORENG ORIGINAL', '1', '7000');
  674. INSERT INTO `t_menu` VALUES ('PBC', 'PISANG BAKAR COKLAT', '1', '5000');
  675. INSERT INTO `t_menu` VALUES ('PBK', 'PISANG BAKAR KEJU', '1', '5000');
  676. INSERT INTO `t_menu` VALUES ('PTTF', 'POTATO FRIES', '1', '5000');
  677. INSERT INTO `t_menu` VALUES ('RBB', 'ROTI BAKAR BLUEBERRY', '1', '5000');
  678. INSERT INTO `t_menu` VALUES ('RBC', 'ROTI BAKAR COKLAT', '1', '5000');
  679. INSERT INTO `t_menu` VALUES ('RBK', 'ROTI BAKAR KACANG', '1', '6000');
  680. INSERT INTO `t_menu` VALUES ('RBMX', 'ROTI BAKAR MIX', '1', '5000');
  681. INSERT INTO `t_menu` VALUES ('RBN', 'ROTI BAKAR NANAS', '1', '5000');
  682. INSERT INTO `t_menu` VALUES ('RBS', 'ROTI BAKAR STRAWBERRY', '1', '5000');
  683. INSERT INTO `t_menu` VALUES ('RJM', 'RUJAK MANIS', '1', '5000');
  684. INSERT INTO `t_menu` VALUES ('RTKJ', 'ROTI BAKAR KEJU', '1', '5000');
  685. INSERT INTO `t_menu` VALUES ('SMKJ', 'JUS SEMANGKA', '1', '5000');
  686. INSERT INTO `t_menu` VALUES ('SSCH', 'SUSU COKLAT HANGAT', '1', '3500');
  687. INSERT INTO `t_menu` VALUES ('SSCI', 'SUSU COKLAT ICE', '1', '4000');
  688. INSERT INTO `t_menu` VALUES ('SSJH', 'SUSU JAHE HANGAT', '1', '3500');
  689. INSERT INTO `t_menu` VALUES ('SSPI', 'SUSU PUTIH ICE', '1', '4000');
  690. INSERT INTO `t_menu` VALUES ('SSPT', 'SUSU PUTIH HANGAT', '1', '3500');
  691. INSERT INTO `t_menu` VALUES ('SSS', 'SOSIS ', '1', '5000');
  692. INSERT INTO `t_menu` VALUES ('STRJ', 'JUS STRAWBERRY', '1', '6000');
  693. INSERT INTO `t_menu` VALUES ('STS', 'SATE SESUATU', '1', '5000');
  694. INSERT INTO `t_menu` VALUES ('SUPB', 'SUP BUAH', '1', '6000');
  695. INSERT INTO `t_menu` VALUES ('TBBQ', 'TAHU BARBEQUE', '1', '5000');
  696. INSERT INTO `t_menu` VALUES ('THCP', 'TAHU CRISPY', '1', '5000');
  697. INSERT INTO `t_menu` VALUES ('THGL', 'TAHU GALAU', '1', '5000');
  698. INSERT INTO `t_menu` VALUES ('THRH', 'TEA TARIX HOT', '1', '4000');
  699. INSERT INTO `t_menu` VALUES ('THRI', 'TEA TARIX ICE', '1', '5000');
  700. INSERT INTO `t_menu` VALUES ('TMTJ', 'JUS TOMAT', '1', '5000');
  701. INSERT INTO `t_menu` VALUES ('TPL', 'TEMPE LALAPAN', '1', '5000');
  702. INSERT INTO `t_menu` VALUES ('USM', 'UDANG ASAM MANIS', '1', '10000');
  703. INSERT INTO `t_menu` VALUES ('WRTJ', 'JUS WORTEL', '1', '5000');
  704. INSERT INTO `t_menu` VALUES ('WTHC', 'WHITE COFFEE', '1', '5000');
  705. INSERT INTO `t_transaksi` VALUES ('1', '000001', '2013-01-13', 'APEL', '5000', '1', '', 'F', '1', 'C', 'C', 'F');
  706. INSERT INTO `t_transaksi` VALUES ('2', '000001', '2013-01-13', 'FRT', '5000', '1', '', 'F', '1', 'C', 'C', 'F');
  707. INSERT INTO `t_transaksi` VALUES ('3', '000003', '2013-01-19', 'BNGJ', '6000', '1', '', 'yy', '1', 'C', 'C', 'F');
  708. INSERT INTO `t_transaksi` VALUES ('4', '000003', '2013-01-19', 'JALP', '5000', '4', '', 'yy', '1', 'C', 'C', 'F');
  709. INSERT INTO `t_transaksi` VALUES ('5', '000004', '2013-02-01', 'WTHC', '5000', '1', '111 001 150676', 'F', 'X', 'C', 'C', 'F');
  710. INSERT INTO `t_transaksi` VALUES ('6', '000004', '2013-02-01', 'FSN', '11000', '2', '111 001 150676', 'F', 'X', 'C', 'C', 'F');
  711. INSERT INTO `t_transaksi` VALUES ('7', '000004', '2013-02-01', 'HTCK', '5000', '2', '111 001 150676', 'F', 'X', 'C', 'C', 'F');
  712. INSERT INTO `t_transaksi` VALUES ('8', '000005', '2013-02-01', 'CMT', '11000', '2', '', 'maya ', '3', 'C', 'C', 'F');
  713. INSERT INTO `t_transaksi` VALUES ('9', '000005', '2013-02-01', 'BKSO', '5000', '3', '', 'maya ', '3', 'C', 'C', 'F');
  714. INSERT INTO `t_transaksi` VALUES ('10', '000005', '2013-02-01', 'JALP', '5000', '2', '', 'maya ', '3', 'C', 'C', 'F');
  715. INSERT INTO `t_transaksi` VALUES ('11', '000005', '2013-02-01', 'BNGJ', '6000', '1', '', 'maya ', '3', 'C', 'C', 'F');
  716. INSERT INTO `t_transaksi` VALUES ('12', '000005', '2013-02-01', 'JRNI', '3000', '2', '', 'maya ', '3', 'C', 'C', 'F');
  717. INSERT INTO `t_transaksi` VALUES ('13', '000005', '2013-02-01', 'AYM', '9000', '1', '', 'maya ', '3', 'C', 'C', 'F');
  718. INSERT INTO `t_transaksi` VALUES ('14', '000006', '2013-02-01', 'BLKC', '3000', '2', '111 002 160886', 'F', '6', 'C', 'C', 'F');
  719. INSERT INTO `t_transaksi` VALUES ('15', '000006', '2013-02-01', 'PTTF', '5000', '2', '111 002 160886', 'F', '6', 'C', 'C', 'F');
  720. INSERT INTO `t_transaksi` VALUES ('16', '000006', '2013-02-01', 'LTEC', '4000', '1', '111 002 160886', 'F', '6', 'C', 'C', 'F');
  721. INSERT INTO `t_transaksi` VALUES ('17', '000007', '2013-02-01', 'NSGO', '7000', '2', '', 'albert', '14', 'C', 'C', 'F');
  722. INSERT INTO `t_transaksi` VALUES ('18', '000007', '2013-02-01', 'THCP', '5000', '2', '', 'albert', '14', 'C', 'C', 'F');
  723. INSERT INTO `t_transaksi` VALUES ('19', '000007', '2013-02-01', 'THRH', '4000', '2', '', 'albert', '14', 'C', 'C', 'F');
  724. INSERT INTO `t_transaksi` VALUES ('20', '000007', '2013-02-01', 'GRSD', '6000', '2', '', 'albert', '14', 'C', 'C', 'F');
  725. INSERT INTO `t_transaksi` VALUES ('21', '000007', '2013-02-01', 'CPPH', '3500', '3', '', 'albert', '14', 'C', 'C', 'F');
  726. INSERT INTO `t_transaksi` VALUES ('22', '000008', '2013-02-02', 'AYM', '9000', '4', '', '', 'X', 'C', 'C', 'F');
  727. INSERT INTO `t_transaksi` VALUES ('23', '000008', '2013-02-02', 'GRSD', '6000', '2', '', '', 'X', 'C', 'C', 'F');
  728. INSERT INTO `t_transaksi` VALUES ('24', '000008', '2013-02-02', 'JOSH', '5000', '2', '', '', 'X', 'C', 'C', 'F');
  729. INSERT INTO `t_transaksi` VALUES ('25', '000009', '2013-02-02', 'LTEI', '5000', '2', '111 004 051292', 'F', '9', 'C', 'C', 'F');
  730. INSERT INTO `t_transaksi` VALUES ('26', '000009', '2013-02-02', 'AYM', '9000', '1', '111 004 051292', 'F', '9', 'C', 'C', 'F');
  731. INSERT INTO `t_transaksi` VALUES ('27', '000009', '2013-02-02', 'SUPB', '6000', '2', '111 004 051292', 'F', '9', 'C', 'C', 'F');
  732. INSERT INTO `t_transaksi` VALUES ('28', '000010', '2013-02-02', 'BLKJ', '3500', '3', '', 'huda ', '9', 'C', 'C', 'F');
  733. INSERT INTO `t_transaksi` VALUES ('29', '000010', '2013-02-02', 'STRJ', '6000', '2', '', 'huda ', '9', 'C', 'C', 'F');
  734. INSERT INTO `t_transaksi` VALUES ('30', '000010', '2013-02-02', 'KPRM', '5000', '4', '', 'huda ', '9', 'C', 'C', 'F');
  735. INSERT INTO `t_transaksi` VALUES ('31', '000010', '2013-02-02', 'FSN', '11000', '2', '', 'huda ', '9', 'C', 'C', 'F');
  736. INSERT INTO `t_transaksi` VALUES ('32', '000003', '2013-02-05', 'BKSO', '5000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  737. INSERT INTO `t_transaksi` VALUES ('33', '000011', '2013-04-11', 'APEL', '5000', '1', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  738. INSERT INTO `t_transaksi` VALUES ('34', '000011', '2013-04-19', 'BLKC', '3000', '3', '111 001 150676', '', '1', 'C', 'C', 'F');
  739. INSERT INTO `t_transaksi` VALUES ('35', '000011', '2013-04-19', 'BKSO', '5000', '1', '111 001 150676', '', '1', 'C', 'C', 'F');
  740. INSERT INTO `t_transaksi` VALUES ('36', '000012', '2013-04-27', 'BKSO', '5000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  741. INSERT INTO `t_transaksi` VALUES ('37', '000012', '2013-04-27', 'GRSD', '6000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  742. INSERT INTO `t_transaksi` VALUES ('38', '000012', '2013-04-27', 'FSN', '11000', '1', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  743. INSERT INTO `t_transaksi` VALUES ('39', '000012', '2013-04-27', 'LTEC', '4000', '1', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  744. INSERT INTO `t_transaksi` VALUES ('40', '000012', '2013-04-27', 'KPRM', '5000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  745. INSERT INTO `t_transaksi` VALUES ('41', '000012', '2013-04-27', 'AYM', '9000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  746. INSERT INTO `t_transaksi` VALUES ('42', '000013', '2013-04-27', 'CMT', '11000', '4', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  747. INSERT INTO `t_transaksi` VALUES ('43', '000013', '2013-04-27', 'GRSD', '6000', '3', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  748. INSERT INTO `t_transaksi` VALUES ('44', '000013', '2013-04-27', 'CPPH', '3500', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  749. INSERT INTO `t_transaksi` VALUES ('45', '000014', '2013-04-27', 'CMT', '11000', '3', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  750. INSERT INTO `t_transaksi` VALUES ('46', '000014', '2013-04-27', 'CPPH', '3500', '4', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  751. INSERT INTO `t_transaksi` VALUES ('47', '000014', '2013-04-27', 'GRSD', '6000', '2', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  752. INSERT INTO `t_transaksi` VALUES ('48', '000014', '2013-04-27', 'AYM', '9000', '3', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  753. INSERT INTO `t_transaksi` VALUES ('49', '000015', '2013-04-27', 'APEL', '5000', '5', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  754. INSERT INTO `t_transaksi` VALUES ('50', '000015', '2013-04-27', 'FSN', '11000', '4', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  755. INSERT INTO `t_transaksi` VALUES ('51', '000016', '2013-04-27', 'BRNC', '3500', '5', '111 001 150676', 'F', '1', 'C', 'C', 'F');
  756. INSERT INTO `t_user` VALUES ('DIANA', '§¬¤±¤', 'CASHIER');
  757. INSERT INTO `t_user` VALUES ('NURMA', '±¸µ°¤', 'CASHIER');
  758. INSERT INTO `t_user` VALUES ('SPV', '¶³¹', 'SPV');
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!