· 9 years ago · Nov 06, 2016, 05:22 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Nov 06, 2016 at 06:19 PM
7-- Server version: 5.5.27
8-- PHP Version: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `niki_ac2016`
21--
22
23DELIMITER $$
24--
25-- Procedures
26--
27CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_AddLvl`(
28in lname varchar(35),
29
30in userid varchar(15),
31
32out newID tinyint(3),
33
34OUT error VARCHAR(4)
35
36)
37BEGIN
38
39DECLARE proces INT DEFAULT 0;
40
41DECLARE last_id TINYINT(2);
42
43declare modID tinyint(3);
44
45DECLARE c_getModID CURSOR FOR SELECT modulID FROM nikiac_modul WHERE modulID != 0 && 1=1;
46
47DECLARE CONTINUE HANDLER FOR NOT FOUND SET proces = 1;
48
49DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' BEGIN END ;
50
51IF EXISTS (SELECT 'x' FROM nikiac_level WHERE lvl=lname) THEN
52
53 BEGIN
54
55 SET error = '1000' ;
56
57 END ;
58
59 ELSE -- jika tidak ada, eksekusi
60
61 BEGIN
62
63 INSERT INTO nikiac_level SET lvl=lname, aktif='Y', createdBy=userid;
64
65 SET last_id = LAST_INSERT_ID();
66
67 OPEN c_getModID;
68
69 REPEAT
70
71 FETCH c_getModID INTO modID;
72
73 IF NOT proces THEN
74
75 INSERT INTO nikiac_grouplvlmdl SET idlevel=last_id, modulID=modID, r='Y', userID=userid;
76
77 END IF;
78
79 UNTIL proces END REPEAT;
80
81 CLOSE c_getModID;
82
83 SET error='';
84
85 select last_id as newID;
86
87 END;
88
89END IF; -- end cek available data
90
91SELECT error;
92
93END$$
94
95CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_modManag`(
96
97
98IN idlvl tinyint(2),
99
100IN modName varchar(30),
101
102in folder varchar(50),
103
104in aktif varchar(1),
105
106IN users varchar(15),
107
108in menuid tinyint(3),
109
110OUT error varchar(4)
111
112)
113BEGIN
114
115DECLARE proces INT DEFAULT 0;
116
117DECLARE j_mods TINYINT(5);
118
119DECLARE mods TINYINT(5);
120
121declare t_lvl tinyint(2);
122
123declare last_id tinyint(3);
124
125DECLARE c_getlvl CURSOR FOR select idlevel from nikiac_level where 1=1;
126
127DECLARE CONTINUE HANDLER FOR NOT FOUND SET proces = 1;
128
129DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' BEGIN END ;
130
131if exists (select 'x' from nikiac_modul where nama_modul=modName) then
132
133BEGIN
134
135 SET error = '1000' ;
136
137END ;
138
139ELSE -- jika tidak ada, eksekusi
140
141BEGIN
142
143INSERT into nikiac_modul SET nama_modul=modName, modul_folder=folder, aktif=aktif, createdBy=users, menuID=menuId;
144
145set last_id = LAST_INSERT_ID();
146
147 open c_getlvl;
148
149 repeat
150
151 fetch c_getlvl into t_lvl;
152
153 if not proces then
154
155 INSERT INTO nikiac_grouplvlmdl SET idlevel=t_lvl, modulID=last_id, userID=users;
156
157 end if;
158
159 until proces end repeat;
160
161 close c_getlvl;
162
163SET error='';
164
165END;
166
167END IF; -- end cek available data
168
169select error;
170
171END$$
172
173CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_trxPembelianDtl`(
174
175
176 IN kdp VARCHAR (20),
177
178
179 IN nota VARCHAR (20),
180
181
182 IN kdsup SMALLINT (1),
183
184
185 IN userid VARCHAR (15),
186
187
188 IN tgl DATE,
189
190
191 IN kdb VARCHAR (5),
192
193
194 IN q_beli SMALLINT (3),
195
196
197 IN h_brg DECIMAL (10, 2),
198
199
200 IN ttl DECIMAL (10, 2),
201
202
203 OUT error VARCHAR (4)
204
205
206)
207BEGIN
208
209
210 DECLARE ttl_beli DECIMAL (10, 2) ;
211
212
213 DECLARE h_beli DECIMAL (10, 2) ;
214
215
216 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000'
217
218
219 BEGIN
220
221
222 END ;
223
224
225 -- cek inputan baru atau bukan, jika bukan do it
226
227
228 IF EXISTS (SELECT 'x' FROM nikiac_pembelian WHERE kdPembelian = kdp) THEN
229
230
231 BEGIN
232
233
234 IF EXISTS (SELECT 'x' FROM nikiac_pembeliandtl WHERE kdPembelian = kdp && kd_barang = kdb) THEN -- cek barang yg di input, sudah ada apa blm di keranjang
235
236
237 BEGIN
238
239
240 SET error = '1001' ;
241
242
243 END ;
244
245
246 ELSE
247
248
249 BEGIN
250
251
252 INSERT INTO nikiac_pembeliandtl SET kdPembelian = kdp,
253
254
255 kd_barang = kdb,
256
257
258 qty_beli = q_beli,
259
260
261 harga_beli = (ttl / q_beli),
262
263
264 total = ttl ;
265
266
267 SET ttl_beli = (SELECT DISTINCT SUM(total) AS t_harga FROM nikiac_pembeliandtl WHERE kdPembelian = kdp) ;
268
269
270 SET h_brg = (SELECT harga_beli FROM nikiac_barang WHERE kdbarang = kdb) ; -- cek harga barang satuan saat ini
271
272
273 UPDATE nikiac_pembelian SET total_pembelian = ttl_beli WHERE kdPembelian = kdp ; -- update total pembelian
274
275
276
277
278
279 IF h_brg != (ttl / q_beli) THEN
280
281
282 BEGIN
283
284
285 UPDATE nikiac_barang SET harga_beli = (ttl / q_beli) WHERE kdbarang = kdb ;
286
287
288 END ;
289
290
291 END IF ; -- end if cek harga barang dan update harga satuan
292
293
294 SET error = '' ;
295
296
297 END;
298
299
300 END IF; -- end cek item ada/nggak
301
302
303 END;
304
305
306 ELSE
307
308
309 BEGIN
310
311
312 INSERT INTO nikiac_pembelian SET kdPembelian = kdp,
313
314
315 no_nota = nota,
316
317
318 kdsup = kdsup,
319
320
321 userID = userid,
322
323
324 tgl_input = NOW(),
325
326
327 tgl_beli = tgl,
328
329
330 ids = 1 ;
331
332
333 INSERT INTO nikiac_pembeliandtl SET kdPembelian = kdp,
334
335
336 kd_barang = kdb,
337
338
339 qty_beli = q_beli,
340
341
342 harga_beli = (ttl / q_beli),
343
344
345 total = ttl ;
346
347
348 SET ttl_beli = (SELECT DISTINCT SUM(total) AS t_harga FROM nikiac_pembeliandtl WHERE kdPembelian = kdp) ;
349
350
351 SET h_brg = (SELECT harga_beli FROM nikiac_barang WHERE kdbarang = kdb) ;
352
353
354
355
356
357 -- cek harga barang satuan saat ini
358
359
360 UPDATE nikiac_pembelian SET total_pembelian = ttl_beli WHERE kdPembelian = kdp ;
361
362
363 -- update total pembelian
364
365
366 IF h_brg != (ttl / q_beli) THEN
367
368
369 BEGIN
370
371
372 UPDATE nikiac_barang SET harga_beli = (ttl / q_beli) WHERE kdbarang = kdb;
373
374
375 END ;
376
377
378 END IF ; -- end if cek harga barang
379
380
381 SET error = '' ;
382
383
384 END;
385
386
387 END IF;
388
389
390SELECT error;
391
392
393END$$
394
395CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_trxPembelianDtl_delProd`(
396
397
398 in idp int(5),
399
400
401 IN kdp VARCHAR (20),
402
403
404 OUT error VARCHAR (4)
405
406
407)
408BEGIN
409
410
411 DECLARE ttl_beli DECIMAL (10, 2) ;
412
413
414 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000'
415
416
417 BEGIN
418
419
420 END ;
421
422
423
424
425
426 delete from nikiac_pembeliandtl where idDtlPembelian=idp && kdPembelian=kdp;
427
428
429 SET ttl_beli = (SELECT DISTINCT SUM(total) AS t_harga FROM nikiac_pembeliandtl WHERE kdPembelian = kdp) ;
430
431
432 UPDATE nikiac_pembelian SET total_pembelian = ttl_beli WHERE kdPembelian = kdp ; -- update total pembelian
433
434
435 SET error = '' ;
436
437
438SELECT error;
439
440
441END$$
442
443CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_trxPenjualanDtl`(
444
445
446 IN kdp VARCHAR (20),
447
448
449 IN cust VARCHAR (25),
450
451
452 IN tgl DATE,
453
454
455 IN kdb VARCHAR (5),
456
457
458 IN h_jual DECIMAL (10, 2),
459
460
461 IN q_jual SMALLINT (3),
462
463
464 IN userid VARCHAR (15),
465
466
467 OUT error VARCHAR (4)
468
469
470)
471BEGIN
472
473
474 DECLARE ttl_h_brg DECIMAL (10, 2) ;
475
476
477 DECLARE brg_diskon DECIMAL (9, 2) ;
478
479
480 DECLARE h_beli DECIMAL (10, 2) ;
481
482
483 DECLARE ttl_harga_jual DECIMAL (10, 2) ;
484
485
486 DECLARE stok SMALLINT (3) ;
487
488
489 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' BEGIN END ;
490
491
492 SET ttl_h_brg = (h_jual * q_jual) ;
493
494
495 SET stok =
496
497
498 (SELECT
499
500
501 a.stok
502
503
504 FROM
505
506
507 nikiac_barang a
508
509
510 WHERE a.kdbarang = kdb);
511
512
513 -- select stok;
514
515
516 IF q_jual <= stok
517
518
519 THEN -- cek stok yg ada dengan qty jual
520
521
522 BEGIN
523
524
525 IF EXISTS
526
527
528 (SELECT
529
530
531 'x'
532
533
534 FROM
535
536
537 nikiac_penjualan
538
539
540 WHERE kd_penjualan = kdp)
541
542
543 THEN -- cek inputan baru apa bukan, jika buka do it now
544
545
546 BEGIN
547
548
549 IF EXISTS
550
551
552 (SELECT
553
554
555 'x'
556
557
558 FROM
559
560
561 nikiac_penjualandtl
562
563
564 WHERE kd_penjualan = kdp && kd_barang = kdb)
565
566
567 THEN -- cek barang yg di input, sudah ada apa blm di keranjang
568
569
570 BEGIN
571
572
573 SET error = '1001' ;
574
575
576 END ;
577
578
579 ELSE -- jika tidak ada, eksekusi
580
581
582 BEGIN
583
584
585 SET brg_diskon =
586
587
588 (SELECT DISTINCT
589
590
591 SUM((harga_jual) - h_jual)
592
593
594 FROM
595
596
597 nikiac_barang
598
599
600 WHERE kdbarang = kdb) ;
601
602
603 SET h_beli =
604
605
606 (SELECT
607
608
609 harga_beli
610
611
612 FROM
613
614
615 nikiac_barang
616
617
618 WHERE kdbarang = kdb) ;
619
620
621 INSERT INTO nikiac_penjualandtl SET kd_penjualan = kdp,
622
623
624 kd_barang = kdb,
625
626
627 harga_jual = h_jual,
628
629
630 diskon = brg_diskon,
631
632
633 qty = q_jual,
634
635
636 harga_beli = h_beli,
637
638
639 total_harga = ttl_h_brg,
640
641
642 userID = userid,
643
644
645 date_lastUpdate = NOW(),
646
647
648 user_lastUpdate = userid ;
649
650
651 SET ttl_harga_jual =
652
653
654 (SELECT DISTINCT
655
656
657 SUM(total_harga)
658
659
660 FROM
661
662
663 nikiac_penjualandtl
664
665
666 WHERE kd_penjualan = kdp) ;
667
668
669 UPDATE
670
671
672 nikiac_penjualan
673
674
675 SET
676
677
678 subtotal = ttl_harga_jual
679
680
681 WHERE kd_penjualan = kdp ;
682
683
684 SET error = '' ;
685
686
687 END ;
688
689
690 END IF ;
691
692
693 -- end cek kd_penjualan dan kd_barang
694
695
696 END ;
697
698
699 ELSE
700
701
702 BEGIN
703
704
705 -- jika data baru
706
707
708 SET brg_diskon =
709
710
711 (SELECT DISTINCT
712
713
714 SUM((harga_jual) - h_jual)
715
716
717 FROM
718
719
720 nikiac_barang
721
722
723 WHERE kdbarang = kdb) ;
724
725
726 SET h_beli =
727
728
729 (SELECT
730
731
732 harga_beli
733
734
735 FROM
736
737
738 nikiac_barang
739
740
741 WHERE kdbarang = kdb) ;
742
743
744 INSERT INTO nikiac_penjualan SET kd_penjualan = kdp,
745
746
747 ids = 1,
748
749
750 customer = cust,
751
752
753 tgl_input = NOW(),
754
755
756 tgl_jual = tgl,
757
758
759 userID = userid ;
760
761
762 INSERT INTO nikiac_penjualandtl SET kd_penjualan = kdp,
763
764
765 kd_barang = kdb,
766
767
768 harga_jual = h_jual,
769
770
771 diskon = brg_diskon,
772
773
774 qty = q_jual,
775
776
777 harga_beli = h_beli,
778
779
780 total_harga = ttl_h_brg,
781
782
783 userID = userid,
784
785
786 date_lastUpdate = NOW(),
787
788
789 user_lastUpdate = userid ;
790
791
792 -- Dapetin total harga pembelian
793
794
795 SET ttl_harga_jual =
796
797
798 (SELECT DISTINCT
799
800
801 SUM(total_harga)
802
803
804 FROM
805
806
807 nikiac_penjualandtl
808
809
810 WHERE kd_penjualan = kdp) ;
811
812
813 UPDATE
814
815
816 nikiac_penjualan
817
818
819 SET
820
821
822 subtotal = ttl_harga_jual
823
824
825 WHERE kd_penjualan = kdp ;
826
827
828 SET error = '' ;
829
830
831 END ;
832
833
834 END IF ;
835
836
837 -- end cek input baru atau bukan
838
839
840 END ;
841
842
843 ELSE
844
845
846 BEGIN
847
848
849 SET error = '1002' ;
850
851
852 END ;
853
854
855 END IF ;
856
857
858 -- end cek stok
859
860
861 SELECT error;
862
863
864END$$
865
866CREATE DEFINER=`root`@`localhost` PROCEDURE `nikiac_trxPenjualanDtl_update`(
867
868
869 IN idp INT (8),
870
871
872 IN kdp VARCHAR (20),
873
874
875 IN q_jual SMALLINT (3),
876
877
878 IN h_jual DECIMAL (10, 2),
879
880
881 IN t_harga DECIMAL (10, 2),
882
883
884 OUT error VARCHAR (4)
885
886
887)
888BEGIN
889
890
891DECLARE stok SMALLINT (3) ;
892
893
894DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' BEGIN END ;
895
896
897SET stok = (SELECT
898
899
900 a.stok
901
902
903 FROM
904
905
906 nikiac_barang a, nikiac_penjualandtl b
907
908
909 WHERE idDtlPenjualan=idp && a.kdbarang = b.kd_barang);
910
911
912 -- select stok;
913
914
915
916
917
918 IF q_jual <= stok THEN -- cek stok yg ada dengan qty jual
919
920
921 BEGIN
922
923
924 UPDATE
925
926
927 nikiac_penjualandtl
928
929
930 SET
931
932
933 qty = q_jual,
934
935
936 harga_jual = h_jual,
937
938
939 total_harga = t_harga
940
941
942 WHERE idDtlPenjualan = idp && kd_penjualan = kdp ;
943
944
945 UPDATE
946
947
948 nikiac_penjualan
949
950
951 SET
952
953
954 subtotal =
955
956
957 (SELECT DISTINCT
958
959
960 SUM(total_harga) AS t_harga
961
962
963 FROM
964
965
966 nikiac_penjualandtl
967
968
969 WHERE nikiac_penjualandtl.kd_penjualan = kdp)
970
971
972 WHERE kd_penjualan = kdp ;
973
974
975 SET error = '' ;
976
977
978 END;
979
980
981 ELSE
982
983
984 BEGIN
985
986
987 SET error = '1002' ;
988
989
990 END;
991
992
993 END IF;
994
995
996 SELECT error ;
997
998
999END$$
1000
1001DELIMITER ;
1002
1003-- --------------------------------------------------------
1004
1005--
1006-- Table structure for table `nikiac_barang`
1007--
1008
1009CREATE TABLE IF NOT EXISTS `nikiac_barang` (
1010 `kdbarang` varchar(5) NOT NULL,
1011 `nama_barang` varchar(100) NOT NULL,
1012 `harga_beli` decimal(10,2) NOT NULL,
1013 `harga_jual` decimal(10,2) NOT NULL,
1014 `stok` smallint(3) NOT NULL,
1015 `lokasi` varchar(20) NOT NULL,
1016 `gambar` varchar(100) NOT NULL,
1017 `idkat` int(3) NOT NULL,
1018 `ids` tinyint(1) NOT NULL,
1019 PRIMARY KEY (`kdbarang`)
1020) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1021
1022--
1023-- Dumping data for table `nikiac_barang`
1024--
1025
1026INSERT INTO `nikiac_barang` (`kdbarang`, `nama_barang`, `harga_beli`, `harga_jual`, `stok`, `lokasi`, `gambar`, `idkat`, `ids`) VALUES
1027('B0001', 'Compresor Avanza Denso CG Asli', 1050000.00, 1275000.00, 1, 'Rak 3', '', 34, 1),
1028('B0002', 'Evaporator Xover Laminated', 300000.00, 450000.00, 1, 'Rak 3', '', 36, 1),
1029('B0003', 'Compresor 15A CG Imi', 800000.00, 950000.00, 1, 'Rak 3', '', 34, 1),
1030('B0004', 'Compresor 15C CG Imi', 775000.00, 975000.00, 1, 'Rak 3', '', 34, 1),
1031('B0005', 'Compresor Forsa Assy CG Imi', 825000.00, 975000.00, 1, 'Rak 3', '', 34, 1),
1032('B0006', 'Compresor 17A CG Imi', 800000.00, 975000.00, 1, 'Rak 3', '', 34, 1),
1033('B0007', 'Compresor Xenia 1000cc CG Imi', 825000.00, 975000.00, 2, 'Rak 3', '', 34, 1),
1034('B0008', 'Compresor 13C Starlet / Taruna CG Imi', 800000.00, 975000.00, 2, 'Rak 3', '', 34, 1),
1035('B0009', 'Compresor Datsun GO Original LLG', 950000.00, 1650000.00, 1, 'Rak 3', '', 34, 1),
1036('B0010', 'Compresor Brio Sanden Original LLG', 1750000.00, 2650000.00, 0, 'Rak 3', '', 34, 1),
1037('B0011', 'Compresor 17A Denso Genuine', 1410000.00, 1550000.00, 1, 'Rak 3', '', 34, 1),
1038('B0012', 'Compresor Odissey K3 Denso Genuine ', 3250000.00, 3650000.00, 1, 'Rak 3', '', 34, 1),
1039('B0013', 'Compresor Mercy C-class c200 6PK k4 ND', 2750000.00, 3150000.00, 1, 'Rak 3', '', 34, 1),
1040('B0014', 'Compresor 507 8PK SD Imi', 810000.00, 975000.00, 1, 'Rak 3', '', 34, 1),
1041('B0015', 'Compresor 505 Fujicool ', 700000.00, 875000.00, 1, 'Rak 3', '', 34, 1),
1042('B0016', 'Compresor 508 Fujicool', 675000.00, 875000.00, 1, 'Rak 3', '', 34, 1),
1043('B0017', 'Compresor 507 Fujicool', 675000.00, 875000.00, 1, 'Rak 3', '', 34, 1),
1044('B0018', 'Compresor Avanza Imi Assy DP', 725000.00, 850000.00, 1, 'Rak 3', '', 34, 1),
1045('B0019', 'Condensor Hy Getz Formula', 550000.00, 675000.00, 0, 'Rak 1', '', 35, 1),
1046('B0020', 'Expansi Verna / Getz / Aveo Asli', 200000.00, 275000.00, 0, 'Rak 4', '', 37, 1),
1047('B0021', 'Compresor Xenia 1000cc / Grand Max Denso Genuine', 1385000.00, 1575000.00, 1, 'Rak 3', '', 34, 1),
1048('B0022', 'Compresor Avanza All New Veloz Denso Genuine', 1380000.00, 1600000.00, 1, 'Rak 3', '', 34, 1),
1049('B0023', 'Compresor All New CRV 2000cc Sanden Asli', 2400000.00, 2750000.00, 1, 'Rak 3', '', 34, 1),
1050('B0024', 'Compresor 508 Denso CG Asli', 950000.00, 1250000.00, 1, 'Rak 3', '', 34, 1),
1051('B0025', 'Compresor 507 Denso CG Asli', 950000.00, 1250000.00, 1, 'Rak 3', '', 34, 1),
1052('B0026', 'Compresor All New Kia Rio LLG', 1000000.00, 3250000.00, 1, 'Rak 3', '', 34, 1),
1053('B0027', 'Compresor BMW 17A Exsing Only', 850000.00, 1450000.00, 1, 'Rak 3', '', 34, 1),
1054('B0028', 'Compresor Innova Bensin Single Exsing Only', 800000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1055('B0029', 'Compresor Livina Pipa Dpn Blkg Original Exsing', 1450000.00, 1950000.00, 1, 'Rak 3', '', 34, 1),
1056('B0030', 'Compresor APV Arena Single Denso Genuine', 1600000.00, 1750000.00, 1, 'Rak 3', '', 34, 1),
1057('B0031', 'Compresor Innova Diesel Double Denso Genuine', 1180000.00, 1400000.00, 1, 'Rak 3', '', 34, 1),
1058('B0032', 'Compresor APV Arena Double Denso CG Asli', 1160000.00, 1350000.00, 1, 'Rak 3', '', 34, 1),
1059('B0033', 'Compresor 15A Denso CG Asli', 1200000.00, 1375000.00, 1, 'Rak 3', '', 34, 1),
1060('B0034', 'Compresor 15C Denso CG Asli', 1725000.00, 1900000.00, 1, 'Rak 3', '', 34, 1),
1061('B0035', 'Compresor Harrier / Ist / Alphard Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1062('B0036', 'Compresor All New CRV 2400cc Exsing', 700000.00, 1050000.00, 2, 'Rak 3', '', 34, 1),
1063('B0037', 'Compresor Peugeot 307 / 206 6PK Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1064('B0038', 'Compresor Karimun Estillo Only Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1065('B0039', 'Compresor Daihatsu Ceria Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1066('B0040', 'Compresor Toyota Ist Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1067('B0041', 'Compresor Aveo Assy Exsing', 700000.00, 1050000.00, 2, 'Rak 3', '', 34, 1),
1068('B0042', 'Compresor BMW Sensor Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1069('B0043', 'Compresor Jaguar S4 Ass Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1070('B0044', 'Compresor Volvo Zexel Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1071('B0045', 'Compresor Grand Civic Only Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1072('B0046', 'Compresor Panther Bison Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1073('B0047', 'Compresor Volvo S70 Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1074('B0048', 'Compresor Mercy K3 Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1075('B0049', 'Compresor Xenia 1000 Only Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1076('B0050', 'Compresor Terrano Only Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1077('B0051', 'Compresor New Accord Only Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1078('B0052', 'Compresor Tucson Valve Assy Exsing', 700000.00, 1050000.00, 1, 'Rak 3', '', 34, 1),
1079('B0053', 'Condensor Panther Old R12 DP', 355000.00, 455000.00, 1, 'Rak 1', '', 35, 1),
1080('B0054', 'Condensor Panther Old R134 Fujicool', 300000.00, 425000.00, 1, 'Rak 1', '', 35, 1),
1081('B0055', 'Condensor Panther Touring Matic DP', 375000.00, 500000.00, 1, 'Rak 1', '', 35, 1),
1082('B0056', 'Condensor Great Corolla R12 DP', 325000.00, 475000.00, 1, 'Rak 1', '', 35, 1),
1083('B0057', 'Condensor Great Corolla R134 DP', 350000.00, 475000.00, 1, 'Rak 1', '', 35, 1),
1084('B0058', 'Condensor Panther Old R134 DP', 275000.00, 400000.00, 1, 'Rak 1', '', 35, 1),
1085('B0059', 'Condensor Kuda Bensin AC Cond', 300000.00, 450000.00, 1, 'Rak 1', '', 35, 1),
1086('B0060', 'Condensor Panther Touring Manual Denso Genuine', 500000.00, 700000.00, 1, 'Rak 1', '', 35, 1),
1087('B0061', 'Condensor Futura LLG', 325000.00, 450000.00, 1, 'Rak 1', '', 35, 1),
1088('B0062', 'Condensor Panther Touring Manual Pokka', 375000.00, 500000.00, 1, 'Rak 1', '', 35, 1),
1089('B0063', 'Condensor Kijang Diesel 2000 Paco', 495000.00, 650000.00, 1, 'Rak 1', '', 35, 1),
1090('B0064', 'Condensor Kijang Bensin 2000 DP', 350000.00, 475000.00, 1, 'Rak 1', '', 35, 1),
1091('B0065', 'Condensor Corolla Altis DP', 400000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1092('B0066', 'Condensor Escudo 2.0 / 1.6 Model ND Pokka', 400000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1093('B0067', 'Condensor XL7 Pokka', 500000.00, 650000.00, 1, 'Rak 1', '', 35, 1),
1094('B0068', 'Condensor Vios Old Manual Pokka', 375000.00, 500000.00, 1, 'Rak 1', '', 35, 1),
1095('B0069', 'Condensor Sirion Yaruki', 450000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1096('B0070', 'Condensor Ertiga Yaruki', 450000.00, 575000.00, 1, 'Rak 1', '', 35, 1),
1097('B0071', 'Condensor Escudo 2.0 Model Seiko Seiki DP', 325000.00, 450000.00, 1, 'Rak 1', '', 35, 1),
1098('B0072', 'Condensor Vitara R134 DP', 350000.00, 475000.00, 1, 'Rak 1', '', 35, 1),
1099('B0073', 'Condensor Kijang Grand R12 DP', 275000.00, 375000.00, 1, 'Rak 1', '', 35, 1),
1100('B0074', 'Condensor Baleno Old Pokka', 425000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1101('B0075', 'Condensor Kuda Diesel Denso Cool Gear ', 750000.00, 900000.00, 1, 'Rak 1', '', 35, 1),
1102('B0076', 'Condensor Terios / Rush Pokka', 425000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1103('B0077', 'Condensor Kijang Bensin 97 DP', 350000.00, 475000.00, 1, 'Rak 1', '', 35, 1),
1104('B0078', 'Condensor Xover Pokka', 450000.00, 575000.00, 1, 'Rak 1', '', 35, 1),
1105('B0079', 'Condensor Agya / Ayla Yaruki', 450000.00, 600000.00, 1, 'Rak 1', '', 35, 1),
1106('B0080', 'Condensor Timor Halla DP', 425000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1107('B0081', 'Condensor Avanza 1500cc Matic ND MLY', 435000.00, 575000.00, 1, 'Rak 1', '', 35, 1),
1108('B0082', 'Condensor Avanza Old 1300cc ND MLY', 425000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1109('B0083', 'Condensor Avanza Old 1300cc Denso Genuine', 750000.00, 900000.00, 1, 'Rak 1', '', 35, 1),
1110('B0084', 'Condensor Genio R134 DP', 300000.00, 425000.00, 1, 'Rak 1', '', 35, 1),
1111('B0085', 'Condensor Avanza Old 1300cc Manual Pokka', 325000.00, 425000.00, 2, 'Rak 1', '', 35, 1),
1112('B0086', 'Condensor Avanza New Veloz 1300cc ND MLY', 425000.00, 550000.00, 1, 'Rak 1', '', 35, 1),
1113('B0087', 'Condensor Avanza New Veloz 1500cc ND MLY', 565000.00, 675000.00, 1, 'Rak 1', '', 35, 1),
1114('B0088', 'Condensor Avanza 1500cc Matic Pokka', 325000.00, 450000.00, 1, 'Rak 1', '', 35, 1),
1115('B0089', 'Extrafan Hembus Tiup 12V Veyron', 100000.00, 145000.00, 4, 'Rak 1', '', 40, 1),
1116('B0090', 'Extrafan Hembus Tiup 24V Fujicool', 100000.00, 175000.00, 2, 'Rak 1', '', 40, 1),
1117('B0091', 'Extrafan Hisap 12V Fujicool ', 100000.00, 145000.00, 2, 'Rak 1', '', 40, 1),
1118('B0092', 'Oli Compresor Suniso 4L', 275000.00, 425000.00, 1, 'Rak 1', '', 41, 1),
1119('B0093', 'Oli Compresor Kin Oil 1L', 55000.00, 85000.00, 11, 'Rak 1', '', 41, 1),
1120('B0094', 'Oli Compresor ND Oil 8', 22500.00, 45000.00, 9, 'Rak 1', '', 41, 1),
1121('B0095', 'Oli Compresor C-Parts', 50000.00, 85000.00, 2, 'Rak 1', '', 41, 1),
1122('B0096', 'Oli Compresor Hoa Hw 68', 135000.00, 175000.00, 4, 'Rak 1', '', 41, 1),
1123('B0097', 'MC Aerio ND MLY', 235000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1124('B0098', 'MC Ertiga ND MLY', 250000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1125('B0099', 'MC Genio R134 Label Hon', 245000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1126('B0100', 'MC Jazz Old / New City Label Hon', 225000.00, 375000.00, 4, 'Rak 5', '', 39, 1),
1127('B0101', 'MC New Jazz Yuky Cool', 200000.00, 325000.00, 3, 'Rak 5', '', 39, 1),
1128('B0102', 'MC APV Old ND MLY', 235000.00, 375000.00, 5, 'Rak 5', '', 39, 1),
1129('B0103', 'MC Escudo 2.0 / 1.6 / XL7 5PK', 240000.00, 375000.00, 4, 'Rak 5', '', 39, 1),
1130('B0104', 'MC Escudo 2.0 / 1.6 / XL7 4PK', 245000.00, 375000.00, 4, 'Rak 5', '', 39, 1),
1131('B0105', 'MC Yaris / New Vios ND MLY', 235000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1132('B0106', 'MC Vios Old DP', 225000.00, 325000.00, 1, 'Rak 5', '', 39, 1),
1133('B0107', 'MC Vios Old ND MLY', 235000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1134('B0108', 'MC Forsa / Vitara ND MLY', 235000.00, 375000.00, 3, 'Rak 5', '', 39, 1),
1135('B0109', 'MC Forsa / Vitara Pokka', 200000.00, 325000.00, 1, 'Rak 5', '', 39, 1),
1136('B0110', 'MC Forsa Got 1 ND MLY', 245000.00, 375000.00, 3, 'Rak 5', '', 39, 1),
1137('B0111', 'MC Forsa / Vitara DP', 230000.00, 325000.00, 2, 'Rak 5', '', 39, 1),
1138('B0112', 'MC Jazz RS / Freed ', 260000.00, 375000.00, 4, 'Rak 5', '', 39, 1),
1139('B0113', 'MC Atoz 4PK Yuki', 200000.00, 325000.00, 3, 'Rak 5', '', 39, 1),
1140('B0114', 'MC Panther R134 ND MLY', 245000.00, 375000.00, 1, 'Rak 5', '', 39, 1),
1141('B0115', 'MC Panther R12 ND MLY', 265000.00, 385000.00, 2, 'Rak 5', '', 39, 1),
1142('B0116', 'MC Panther R12 Yuki', 260000.00, 385000.00, 1, 'Rak 5', '', 39, 1),
1143('B0117', 'MC Panther R12 DP', 260000.00, 385000.00, 1, 'Rak 5', '', 39, 1),
1144('B0118', 'MC Timor Halla Pokka', 230000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1145('B0119', 'MC Timor Doowon / Great Corolla ACM', 230000.00, 375000.00, 1, 'Rak 5', '', 39, 1),
1146('B0120', 'MC Timor Doowon / Great Corolla ND MLY', 240000.00, 375000.00, 3, 'Rak 5', '', 39, 1),
1147('B0121', 'MC March / Juke DP', 260000.00, 375000.00, 1, 'Rak 5', '', 39, 1),
1148('B0122', 'MC March / Juke Label Calsonic ', 290000.00, 385000.00, 2, 'Rak 5', '', 39, 1),
1149('B0123', 'MC Livina Label Calsonic Kansei', 275000.00, 375000.00, 3, 'Rak 5', '', 39, 1),
1150('B0124', 'MC Sirion MD', 225000.00, 375000.00, 1, 'Rak 5', '', 39, 1),
1151('B0125', 'MC Grand Max ND MLY', 235000.00, 375000.00, 2, 'Rak 5', '', 39, 1),
1152('B0126', 'MC All New CRV 2000cc Label Hon', 225000.00, 375000.00, 1, 'Rak 5', '', 39, 1),
1153('B0127', 'MC All New CRV 2000cc DP', 230000.00, 375000.00, 1, 'Rak 5', '', 39, 1);
1154
1155-- --------------------------------------------------------
1156
1157--
1158-- Table structure for table `nikiac_grouplvlmdl`
1159--
1160
1161CREATE TABLE IF NOT EXISTS `nikiac_grouplvlmdl` (
1162 `idGroupLM` int(8) unsigned NOT NULL AUTO_INCREMENT,
1163 `idlevel` tinyint(2) DEFAULT NULL,
1164 `modulID` tinyint(3) DEFAULT NULL,
1165 `r` enum('Y','N') NOT NULL DEFAULT 'N',
1166 `c` varchar(1) NOT NULL DEFAULT 'N',
1167 `e` varchar(1) NOT NULL DEFAULT 'N',
1168 `d` varchar(1) NOT NULL DEFAULT 'N',
1169 `userID` varchar(15) NOT NULL,
1170 PRIMARY KEY (`idGroupLM`),
1171 KEY `idlevel` (`idlevel`),
1172 KEY `modulID` (`modulID`)
1173) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=162 ;
1174
1175--
1176-- Dumping data for table `nikiac_grouplvlmdl`
1177--
1178
1179INSERT INTO `nikiac_grouplvlmdl` (`idGroupLM`, `idlevel`, `modulID`, `r`, `c`, `e`, `d`, `userID`) VALUES
1180(1, 1, 0, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1181(2, 1, 1, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1182(3, 1, 2, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1183(4, 1, 3, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1184(5, 1, 4, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1185(6, 1, 5, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1186(7, 1, 6, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1187(8, 1, 7, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1188(9, 1, 8, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1189(10, 1, 15, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1190(153, 15, 1, 'Y', 'Y', 'N', 'N', 'administrator'),
1191(154, 15, 2, 'N', 'N', 'N', 'N', 'administrator'),
1192(155, 15, 3, 'Y', 'Y', 'N', 'N', 'administrator'),
1193(156, 15, 4, 'N', 'N', 'N', 'N', 'administrator'),
1194(157, 15, 5, 'Y', 'Y', 'Y', 'N', 'administrator'),
1195(158, 15, 6, 'N', 'N', 'N', 'N', 'administrator'),
1196(159, 15, 7, 'N', 'N', 'N', 'N', 'administrator'),
1197(160, 15, 8, 'Y', 'Y', 'Y', 'Y', 'administrator'),
1198(161, 15, 15, 'N', 'N', 'N', 'N', 'administrator');
1199
1200-- --------------------------------------------------------
1201
1202--
1203-- Table structure for table `nikiac_kategori`
1204--
1205
1206CREATE TABLE IF NOT EXISTS `nikiac_kategori` (
1207 `idkat` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
1208 `ids` tinyint(1) unsigned NOT NULL,
1209 `nama_kat` varchar(50) NOT NULL,
1210 PRIMARY KEY (`idkat`)
1211) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
1212
1213--
1214-- Dumping data for table `nikiac_kategori`
1215--
1216
1217INSERT INTO `nikiac_kategori` (`idkat`, `ids`, `nama_kat`) VALUES
1218(34, 1, 'Compresor'),
1219(35, 1, 'Condensor'),
1220(36, 1, 'Evaporator'),
1221(37, 1, 'Expansion'),
1222(38, 1, 'Receiver Dryer'),
1223(39, 1, 'Magnet Clutch'),
1224(40, 1, 'Extra Fan'),
1225(41, 1, 'Oli'),
1226(42, 1, 'Motor Fan / Motor Radiator'),
1227(43, 1, 'Blower'),
1228(44, 1, 'Electrical'),
1229(45, 1, 'Fitting'),
1230(46, 1, 'Slang & Pipa'),
1231(47, 1, 'Greel'),
1232(48, 1, 'Bearing'),
1233(49, 1, 'Spool Magnet'),
1234(50, 1, 'Pully'),
1235(51, 1, 'Center Piece');
1236
1237-- --------------------------------------------------------
1238
1239--
1240-- Table structure for table `nikiac_level`
1241--
1242
1243CREATE TABLE IF NOT EXISTS `nikiac_level` (
1244 `idlevel` tinyint(2) NOT NULL AUTO_INCREMENT,
1245 `lvl` varchar(35) NOT NULL,
1246 `aktif` enum('Y','N') NOT NULL,
1247 `CreatedBy` varchar(15) NOT NULL,
1248 PRIMARY KEY (`idlevel`)
1249) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
1250
1251--
1252-- Dumping data for table `nikiac_level`
1253--
1254
1255INSERT INTO `nikiac_level` (`idlevel`, `lvl`, `aktif`, `CreatedBy`) VALUES
1256(1, 'Super Administrator', 'Y', 'administrator'),
1257(15, 'Kasir', 'Y', 'administrator');
1258
1259-- --------------------------------------------------------
1260
1261--
1262-- Table structure for table `nikiac_lgnhistories`
1263--
1264
1265CREATE TABLE IF NOT EXISTS `nikiac_lgnhistories` (
1266 `idLgn` int(8) unsigned NOT NULL AUTO_INCREMENT,
1267 `username` varchar(15) NOT NULL,
1268 `ip` varchar(20) NOT NULL,
1269 `jam` datetime DEFAULT NULL,
1270 `hostname` varchar(100) NOT NULL,
1271 `browser` varchar(17) NOT NULL,
1272 `ket` enum('IN','OUT') NOT NULL,
1273 PRIMARY KEY (`idLgn`)
1274) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=241 ;
1275
1276--
1277-- Dumping data for table `nikiac_lgnhistories`
1278--
1279
1280INSERT INTO `nikiac_lgnhistories` (`idLgn`, `username`, `ip`, `jam`, `hostname`, `browser`, `ket`) VALUES
1281(157, 'owner', '202.80.216.227', NULL, '202.80.216.227', 'Other', 'IN'),
1282(158, 'owner', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'IN'),
1283(159, 'owner', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'OUT'),
1284(160, 'Administrator', '202.80.219.133', NULL, '202.80.219.133', 'Other', 'IN'),
1285(161, 'owner', '115.178.201.88', NULL, '115.178.201.88', 'Chrome', 'IN'),
1286(162, 'owner', '115.178.201.88', NULL, '115.178.201.88', 'Chrome', 'OUT'),
1287(163, 'owner', '115.178.201.88', NULL, '115.178.201.88', 'Chrome', 'IN'),
1288(164, 'owner', '115.178.212.85', NULL, '115.178.212.85', 'Chrome', 'IN'),
1289(165, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1290(166, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1291(167, 'serang', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1292(168, 'serang', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1293(169, 'bayubahari', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1294(170, 'bayubahari', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1295(171, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1296(172, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1297(173, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'IN'),
1298(174, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1299(175, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1300(176, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1301(177, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1302(178, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1303(179, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1304(180, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1305(181, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1306(182, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Chrome', 'IN'),
1307(183, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'OUT'),
1308(184, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'IN'),
1309(185, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Chrome', 'OUT'),
1310(186, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Chrome', 'IN'),
1311(187, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Chrome', 'OUT'),
1312(188, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'OUT'),
1313(189, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'IN'),
1314(190, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1315(191, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1316(192, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1317(193, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1318(194, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1319(195, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1320(196, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1321(197, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1322(198, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1323(199, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'IN'),
1324(200, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'OUT'),
1325(201, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1326(202, '', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1327(203, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1328(204, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1329(205, 'owner', '115.178.195.187', NULL, '115.178.195.187', 'Chrome', 'IN'),
1330(206, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1331(207, 'serang', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1332(208, 'serang', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1333(209, '', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1334(210, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1335(211, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1336(212, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Chrome', 'IN'),
1337(213, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1338(214, 'Administrator', '203.77.240.68', NULL, '203.77.240.68', 'Firefox', 'OUT'),
1339(215, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1340(216, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1341(217, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1342(218, 'Harkit', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1343(219, 'Harkit', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1344(220, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1345(221, 'owner', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1346(222, 'sudirman', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1347(223, 'sudirman', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'OUT'),
1348(224, 'sudirman', '115.178.201.141', NULL, '115.178.201.141', 'Chrome', 'IN'),
1349(225, 'owner', '115.178.208.135', NULL, '115.178.208.135', 'Chrome', 'IN'),
1350(226, 'owner', '115.178.208.135', NULL, '115.178.208.135', 'Chrome', 'OUT'),
1351(227, 'owner', '115.178.208.135', NULL, '115.178.208.135', 'Chrome', 'IN'),
1352(228, 'owner', '115.178.208.135', NULL, '115.178.208.135', 'Chrome', 'OUT'),
1353(229, 'owner', '115.178.201.29', NULL, '115.178.201.29', 'Chrome', 'IN'),
1354(230, 'Administrator', '202.80.219.133', NULL, '202.80.219.133', 'Firefox', 'IN'),
1355(231, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Chrome', 'IN'),
1356(232, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1357(233, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1358(234, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1359(235, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'OUT'),
1360(236, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1361(237, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1362(238, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'OUT'),
1363(239, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN'),
1364(240, 'Administrator', '::1', NULL, 'Chila-Zyan', 'Firefox', 'IN');
1365
1366-- --------------------------------------------------------
1367
1368--
1369-- Table structure for table `nikiac_menu`
1370--
1371
1372CREATE TABLE IF NOT EXISTS `nikiac_menu` (
1373 `menuID` tinyint(3) NOT NULL AUTO_INCREMENT,
1374 `menu` varchar(30) NOT NULL,
1375 `aktif` enum('Y','N') DEFAULT NULL,
1376 `sort` tinyint(2) NOT NULL,
1377 PRIMARY KEY (`menuID`)
1378) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
1379
1380--
1381-- Dumping data for table `nikiac_menu`
1382--
1383
1384INSERT INTO `nikiac_menu` (`menuID`, `menu`, `aktif`, `sort`) VALUES
1385(1, 'Data Master', 'Y', 2),
1386(2, 'Transaksi', 'Y', 3),
1387(3, 'Laporan', 'Y', 4),
1388(5, 'My Account', 'Y', 1),
1389(6, 'Settings', 'Y', 5),
1390(7, 'Laporan 2', 'Y', 6);
1391
1392-- --------------------------------------------------------
1393
1394--
1395-- Table structure for table `nikiac_modul`
1396--
1397
1398CREATE TABLE IF NOT EXISTS `nikiac_modul` (
1399 `modulID` tinyint(3) NOT NULL AUTO_INCREMENT,
1400 `nama_modul` varchar(30) NOT NULL,
1401 `modul_folder` varchar(50) DEFAULT NULL,
1402 `aktif` enum('Y','N') NOT NULL DEFAULT 'N',
1403 `createdBy` varchar(15) NOT NULL,
1404 `menuID` tinyint(3) DEFAULT NULL,
1405 PRIMARY KEY (`modulID`)
1406) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
1407
1408--
1409-- Dumping data for table `nikiac_modul`
1410--
1411
1412INSERT INTO `nikiac_modul` (`modulID`, `nama_modul`, `modul_folder`, `aktif`, `createdBy`, `menuID`) VALUES
1413(0, 'system', 'system', 'Y', 'administrator', NULL),
1414(1, 'kategori', 'kategori', 'Y', 'administrator', 1),
1415(2, 'suplier', 'suplier', 'Y', 'administrator', 1),
1416(3, 'barang', 'barang', 'Y', 'administrator', 1),
1417(4, 'user', 'user', 'Y', 'administrator', 1),
1418(5, 'penjualan', 'trx_penjualan', 'Y', 'administrator', 2),
1419(6, 'pembelian', 'trx_pembelian', 'Y', 'administrator', 2),
1420(7, 'all reports', 'laporan', 'Y', 'administrator', 3),
1421(8, 'profile', 'profile', 'Y', 'administrator', 5),
1422(15, 'general', 'settings', 'Y', 'administrator', 6);
1423
1424-- --------------------------------------------------------
1425
1426--
1427-- Table structure for table `nikiac_paramchild`
1428--
1429
1430CREATE TABLE IF NOT EXISTS `nikiac_paramchild` (
1431 `idpc` tinyint(5) NOT NULL AUTO_INCREMENT,
1432 `idpm` int(3) NOT NULL,
1433 `child_name` varchar(50) NOT NULL,
1434 `ket` text,
1435 `aktif` varchar(1) DEFAULT 'Y',
1436 PRIMARY KEY (`idpc`)
1437) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
1438
1439--
1440-- Dumping data for table `nikiac_paramchild`
1441--
1442
1443INSERT INTO `nikiac_paramchild` (`idpc`, `idpm`, `child_name`, `ket`, `aktif`) VALUES
1444(1, 1, 'Y', 'Ya', 'Y'),
1445(2, 1, 'N', 'Tidak', 'Y'),
1446(3, 2, 'Pembelian', 'report/pembelian/rpt_pembelian', 'Y'),
1447(4, 2, 'Penjualan', 'report/penjualan/rpt_penjualan', 'Y'),
1448(5, 2, 'Stok Barang', 'report/stok/rpt_stok', 'Y'),
1449(6, 2, 'Penjualan2', 'report/penjualan2/rpt_penjualan', 'Y');
1450
1451-- --------------------------------------------------------
1452
1453--
1454-- Table structure for table `nikiac_parameter`
1455--
1456
1457CREATE TABLE IF NOT EXISTS `nikiac_parameter` (
1458 `idpm` int(3) NOT NULL AUTO_INCREMENT,
1459 `nama_param` varchar(50) NOT NULL,
1460 `ket` text,
1461 `userid` varchar(15) NOT NULL,
1462 PRIMARY KEY (`idpm`)
1463) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
1464
1465--
1466-- Dumping data for table `nikiac_parameter`
1467--
1468
1469INSERT INTO `nikiac_parameter` (`idpm`, `nama_param`, `ket`, `userid`) VALUES
1470(1, 'stdChoices', 'Pilihan Y/N', ''),
1471(2, 'RptParam', 'Parameter untuk laporan', 'yuda'),
1472(3, 'TestParam', 'cuma tester', 'yuda');
1473
1474-- --------------------------------------------------------
1475
1476--
1477-- Table structure for table `nikiac_pembelian`
1478--
1479
1480CREATE TABLE IF NOT EXISTS `nikiac_pembelian` (
1481 `kdPembelian` varchar(20) NOT NULL,
1482 `no_nota` varchar(20) NOT NULL,
1483 `total_pembelian` decimal(10,2) NOT NULL,
1484 `kdsup` smallint(1) NOT NULL,
1485 `userID` varchar(15) NOT NULL,
1486 `tgl_input` datetime DEFAULT NULL,
1487 `tgl_beli` date NOT NULL,
1488 `ids` tinyint(1) unsigned NOT NULL,
1489 PRIMARY KEY (`kdPembelian`)
1490) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1491
1492--
1493-- Dumping data for table `nikiac_pembelian`
1494--
1495
1496INSERT INTO `nikiac_pembelian` (`kdPembelian`, `no_nota`, `total_pembelian`, `kdsup`, `userID`, `tgl_input`, `tgl_beli`, `ids`) VALUES
1497('P-DHG201610280000001', '019797', 750000.00, 1, 'owner', '2016-10-28 03:53:48', '2016-10-28', 1);
1498
1499-- --------------------------------------------------------
1500
1501--
1502-- Table structure for table `nikiac_pembeliandtl`
1503--
1504
1505CREATE TABLE IF NOT EXISTS `nikiac_pembeliandtl` (
1506 `idDtlPembelian` int(5) NOT NULL AUTO_INCREMENT,
1507 `kdPembelian` varchar(20) NOT NULL,
1508 `kd_barang` varchar(5) NOT NULL,
1509 `qty_beli` smallint(3) NOT NULL,
1510 `harga_beli` decimal(10,2) NOT NULL,
1511 `total` decimal(10,2) NOT NULL,
1512 PRIMARY KEY (`idDtlPembelian`)
1513) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1514
1515--
1516-- Dumping data for table `nikiac_pembeliandtl`
1517--
1518
1519INSERT INTO `nikiac_pembeliandtl` (`idDtlPembelian`, `kdPembelian`, `kd_barang`, `qty_beli`, `harga_beli`, `total`) VALUES
1520(1, 'P-DHG201610280000001', 'B0019', 1, 550000.00, 550000.00),
1521(2, 'P-DHG201610280000001', 'B0020', 1, 200000.00, 200000.00);
1522
1523--
1524-- Triggers `nikiac_pembeliandtl`
1525--
1526DROP TRIGGER IF EXISTS `T_UpdStok_AD_Pembelian`;
1527DELIMITER //
1528CREATE TRIGGER `T_UpdStok_AD_Pembelian` AFTER DELETE ON `nikiac_pembeliandtl`
1529 FOR EACH ROW BEGIN
1530
1531
1532 UPDATE nikiac_barang SET stok=stok - OLD.qty_beli WHERE kdbarang=OLD.kd_barang;
1533
1534
1535 END
1536//
1537DELIMITER ;
1538DROP TRIGGER IF EXISTS `T_UpdStok_AI_Pembelian`;
1539DELIMITER //
1540CREATE TRIGGER `T_UpdStok_AI_Pembelian` AFTER INSERT ON `nikiac_pembeliandtl`
1541 FOR EACH ROW BEGIN
1542
1543
1544 UPDATE nikiac_barang SET stok=stok + NEW.qty_beli WHERE kdbarang=NEW.kd_barang;
1545
1546
1547 END
1548//
1549DELIMITER ;
1550DROP TRIGGER IF EXISTS `T_UpdStok_AU_Pembelian`;
1551DELIMITER //
1552CREATE TRIGGER `T_UpdStok_AU_Pembelian` AFTER UPDATE ON `nikiac_pembeliandtl`
1553 FOR EACH ROW BEGIN
1554
1555
1556 UPDATE nikiac_barang SET stok=stok - old.qty_beli WHERE kdbarang=old.kd_barang;
1557
1558
1559 UPDATE nikiac_barang SET stok=stok + new.qty_beli WHERE kdbarang=new.kd_barang;
1560
1561
1562 END
1563//
1564DELIMITER ;
1565
1566-- --------------------------------------------------------
1567
1568--
1569-- Table structure for table `nikiac_penjualan`
1570--
1571
1572CREATE TABLE IF NOT EXISTS `nikiac_penjualan` (
1573 `kd_penjualan` varchar(20) NOT NULL,
1574 `ids` tinyint(1) unsigned NOT NULL,
1575 `customer` varchar(25) NOT NULL DEFAULT 'Guest',
1576 `tgl_input` datetime DEFAULT NULL,
1577 `tgl_jual` date DEFAULT NULL,
1578 `subtotal` decimal(10,2) NOT NULL,
1579 `diskon` decimal(8,2) NOT NULL,
1580 `grand_total` decimal(10,2) NOT NULL,
1581 `uang_bayar` decimal(10,2) NOT NULL,
1582 `uang_kembali` decimal(10,2) NOT NULL,
1583 `keterangan` text,
1584 `userID` varchar(15) NOT NULL,
1585 `date_lastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
1586 `user_lastUpdate` varchar(15) DEFAULT NULL,
1587 PRIMARY KEY (`kd_penjualan`)
1588) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1589
1590--
1591-- Dumping data for table `nikiac_penjualan`
1592--
1593
1594INSERT INTO `nikiac_penjualan` (`kd_penjualan`, `ids`, `customer`, `tgl_input`, `tgl_jual`, `subtotal`, `diskon`, `grand_total`, `uang_bayar`, `uang_kembali`, `keterangan`, `userID`, `date_lastUpdate`, `user_lastUpdate`) VALUES
1595('INV-2016110600000001', 1, 'umay', '2016-11-06 21:42:04', '2016-11-06', 2650000.00, 0.00, 2650000.00, 2650000.00, 0.00, '', 'Administrator', '2016-11-06 14:42:04', NULL);
1596
1597-- --------------------------------------------------------
1598
1599--
1600-- Table structure for table `nikiac_penjualandtl`
1601--
1602
1603CREATE TABLE IF NOT EXISTS `nikiac_penjualandtl` (
1604 `idDtlPenjualan` int(8) unsigned NOT NULL AUTO_INCREMENT,
1605 `kd_penjualan` varchar(20) NOT NULL,
1606 `kd_barang` varchar(5) NOT NULL,
1607 `harga_jual` decimal(10,2) NOT NULL,
1608 `diskon` decimal(10,2) NOT NULL,
1609 `qty` smallint(3) NOT NULL,
1610 `harga_beli` decimal(10,2) NOT NULL DEFAULT '0.00',
1611 `total_harga` decimal(10,2) NOT NULL,
1612 `userID` varchar(15) NOT NULL,
1613 `tgl_input` datetime DEFAULT NULL,
1614 `date_lastUpdate` datetime DEFAULT NULL,
1615 `user_lastUpdate` varchar(15) DEFAULT NULL,
1616 PRIMARY KEY (`idDtlPenjualan`),
1617 KEY `kd_penjualan` (`kd_penjualan`)
1618) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1619
1620--
1621-- Dumping data for table `nikiac_penjualandtl`
1622--
1623
1624INSERT INTO `nikiac_penjualandtl` (`idDtlPenjualan`, `kd_penjualan`, `kd_barang`, `harga_jual`, `diskon`, `qty`, `harga_beli`, `total_harga`, `userID`, `tgl_input`, `date_lastUpdate`, `user_lastUpdate`) VALUES
1625(1, 'INV-2016110600000001', 'B0010', 2650000.00, 0.00, 1, 1750000.00, 2650000.00, 'Administrator', NULL, '2016-11-06 21:42:04', 'Administrator');
1626
1627--
1628-- Triggers `nikiac_penjualandtl`
1629--
1630DROP TRIGGER IF EXISTS `T_UpdStok_AD_Penjualan`;
1631DELIMITER //
1632CREATE TRIGGER `T_UpdStok_AD_Penjualan` AFTER DELETE ON `nikiac_penjualandtl`
1633 FOR EACH ROW BEGIN
1634
1635
1636 UPDATE nikiac_barang SET stok=stok + OLD.qty WHERE kdbarang=OLD.kd_barang;
1637
1638
1639 END
1640//
1641DELIMITER ;
1642DROP TRIGGER IF EXISTS `T_UpdStok_AI_Penjualan`;
1643DELIMITER //
1644CREATE TRIGGER `T_UpdStok_AI_Penjualan` AFTER INSERT ON `nikiac_penjualandtl`
1645 FOR EACH ROW BEGIN
1646
1647
1648 UPDATE nikiac_barang SET stok=stok - NEW.qty WHERE kdbarang=NEW.kd_barang;
1649
1650
1651 END
1652//
1653DELIMITER ;
1654DROP TRIGGER IF EXISTS `T_UpdStok_AU_Penjualan`;
1655DELIMITER //
1656CREATE TRIGGER `T_UpdStok_AU_Penjualan` AFTER UPDATE ON `nikiac_penjualandtl`
1657 FOR EACH ROW BEGIN
1658
1659
1660 UPDATE nikiac_barang SET stok=stok - old.qty WHERE kdbarang=old.kd_barang;
1661
1662
1663 UPDATE nikiac_barang SET stok=stok + new.qty WHERE kdbarang=new.kd_barang;
1664
1665
1666 END
1667//
1668DELIMITER ;
1669
1670-- --------------------------------------------------------
1671
1672--
1673-- Table structure for table `nikiac_rptpriv`
1674--
1675
1676CREATE TABLE IF NOT EXISTS `nikiac_rptpriv` (
1677 `idparam` tinyint(5) NOT NULL,
1678 `idlevel` tinyint(2) NOT NULL,
1679 `userid` varchar(15) NOT NULL,
1680 `akses` enum('Y','N') NOT NULL,
1681 KEY `idlevel` (`idlevel`)
1682) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1683
1684--
1685-- Dumping data for table `nikiac_rptpriv`
1686--
1687
1688INSERT INTO `nikiac_rptpriv` (`idparam`, `idlevel`, `userid`, `akses`) VALUES
1689(3, 1, 'administrator', 'Y'),
1690(4, 1, 'administrator', 'Y'),
1691(5, 1, 'administrator', 'Y'),
1692(0, 1, 'administrator', 'Y');
1693
1694-- --------------------------------------------------------
1695
1696--
1697-- Table structure for table `nikiac_settings`
1698--
1699
1700CREATE TABLE IF NOT EXISTS `nikiac_settings` (
1701 `ids` tinyint(1) unsigned NOT NULL AUTO_INCREMENT,
1702 `kdSET` varchar(3) NOT NULL,
1703 `nama_toko` varchar(100) NOT NULL,
1704 `alamat` text,
1705 `keckab` varchar(200) DEFAULT NULL,
1706 `tlp` varchar(20) DEFAULT NULL,
1707 `printer` varchar(100) NOT NULL,
1708 `url_web` varchar(200) NOT NULL,
1709 `logo_toko` varchar(100) NOT NULL,
1710 `last_update` varchar(20) NOT NULL,
1711 `folder_modul` varchar(20) NOT NULL,
1712 `limit_page` tinyint(1) unsigned DEFAULT NULL,
1713 PRIMARY KEY (`ids`)
1714) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1715
1716--
1717-- Dumping data for table `nikiac_settings`
1718--
1719
1720INSERT INTO `nikiac_settings` (`ids`, `kdSET`, `nama_toko`, `alamat`, `keckab`, `tlp`, `printer`, `url_web`, `logo_toko`, `last_update`, `folder_modul`, `limit_page`) VALUES
1721(1, 'DHG', 'NIKI AC', 'JL . Singosari Raya No. 130, Karawaci, Tangerang', 'Banten', '021-5915602', 'Canon MP230 series Printer', 'http://nikiac.com/pusat/', '', 'owner', 'modul', 15);
1722
1723-- --------------------------------------------------------
1724
1725--
1726-- Table structure for table `nikiac_suplier`
1727--
1728
1729CREATE TABLE IF NOT EXISTS `nikiac_suplier` (
1730 `kdsup` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
1731 `ids` tinyint(1) unsigned NOT NULL,
1732 `nama_sup` varchar(100) DEFAULT NULL,
1733 `tlp` varchar(20) NOT NULL,
1734 `alamat` text,
1735 `date_create` date DEFAULT NULL,
1736 PRIMARY KEY (`kdsup`)
1737) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1738
1739--
1740-- Dumping data for table `nikiac_suplier`
1741--
1742
1743INSERT INTO `nikiac_suplier` (`kdsup`, `ids`, `nama_sup`, `tlp`, `alamat`, `date_create`) VALUES
1744(1, 1, 'Mutiara AC', '0215381599', 'Auto Parts BSD', '2016-10-28');
1745
1746-- --------------------------------------------------------
1747
1748--
1749-- Table structure for table `nikiac_users`
1750--
1751
1752CREATE TABLE IF NOT EXISTS `nikiac_users` (
1753 `username` varchar(15) NOT NULL,
1754 `nama_lengkap` varchar(40) NOT NULL,
1755 `pass` varchar(35) NOT NULL,
1756 `hp` varchar(15) NOT NULL,
1757 `sessionID` varchar(100) NOT NULL DEFAULT '0',
1758 `online` enum('Y','N') NOT NULL DEFAULT 'N',
1759 `aktif` enum('Y','N') NOT NULL DEFAULT 'Y',
1760 `level` tinyint(2) NOT NULL,
1761 `ids` tinyint(1) unsigned NOT NULL,
1762 `last_seen` datetime NOT NULL,
1763 `foto` varchar(200) NOT NULL,
1764 PRIMARY KEY (`username`),
1765 KEY `nikiac_users_ibfk_1` (`level`)
1766) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1767
1768--
1769-- Dumping data for table `nikiac_users`
1770--
1771
1772INSERT INTO `nikiac_users` (`username`, `nama_lengkap`, `pass`, `hp`, `sessionID`, `online`, `aktif`, `level`, `ids`, `last_seen`, `foto`) VALUES
1773('Administrator', 'umay.ahmad', 'bcd0e61c786edfddbc0a55aa8884e553', '085920012885', 'e2fv4nompu9bokajigemevhn22', 'Y', 'Y', 1, 1, '2016-11-06 23:03:08', ''),
1774('bayubahari', 'Bayu Bahari', 'b0308c45d25a393c5ec7dc3246ada8ff', '081318307272', '', 'N', 'Y', 1, 1, '2016-10-27 23:07:33', ''),
1775('Harkit', 'Bengkel Harkit', '9d9b8b40f2f36fc1e137367038553976', '02155652087', '', 'N', 'Y', 15, 1, '2016-10-28 09:13:22', ''),
1776('owner', 'Qtink', '0443a2b208bf2e773cd0a3f47852c575', '0878-0810-3899', 'e8064170575ba97e07607d207a9a4670', 'Y', 'Y', 1, 1, '2016-10-29 08:14:48', ''),
1777('serang', 'Niki AC Serang', '95d0789c1452f386d3cc9839cf0cf92e', '081911100751', '', 'N', 'Y', 15, 1, '2016-10-28 06:45:30', ''),
1778('sudirman', 'H. Sudirman', '48858f770f67d31c42a3cf6786244a55', '087878429036', 'b59234870c3048fce2378976eb76ef8a', 'Y', 'Y', 1, 1, '2016-10-28 09:28:26', '');
1779
1780-- --------------------------------------------------------
1781
1782--
1783-- Stand-in structure for view `nikiac_vpembeliandtl`
1784--
1785CREATE TABLE IF NOT EXISTS `nikiac_vpembeliandtl` (
1786`kdbarang` varchar(5)
1787,`nama_barang` varchar(100)
1788,`harga_pokok_beli` decimal(10,2)
1789,`harga_pokok_jual` decimal(10,2)
1790,`kdsup` smallint(1) unsigned
1791,`nama_sup` varchar(100)
1792,`no_nota` varchar(20)
1793,`total_pembelian` decimal(10,2)
1794,`userID` varchar(15)
1795,`tgl_beli` date
1796,`idDtlPembelian` int(5)
1797,`kdPembelian` varchar(20)
1798,`qty_beli` smallint(3)
1799,`harga_beli_satBaru` decimal(10,2)
1800,`total_beli` decimal(10,2)
1801);
1802-- --------------------------------------------------------
1803
1804--
1805-- Stand-in structure for view `nikiac_vpenjualandtl`
1806--
1807CREATE TABLE IF NOT EXISTS `nikiac_vpenjualandtl` (
1808`kdbarang` varchar(5)
1809,`nama_barang` varchar(100)
1810,`harga_beli` decimal(10,2)
1811,`harga_jualstd` decimal(10,2)
1812,`idDtlPen` int(8) unsigned
1813,`kd_penjualan` varchar(20)
1814,`th_beli` decimal(37,2)
1815,`harga_jualreal` decimal(10,2)
1816,`qty` smallint(3)
1817,`diskon_produk` decimal(33,2)
1818,`pendapatan` decimal(39,2)
1819,`th_jual` decimal(10,2)
1820,`customer` varchar(25)
1821,`tgl_jual` date
1822,`diskon_final` decimal(8,2)
1823,`userID` varchar(15)
1824);
1825-- --------------------------------------------------------
1826
1827--
1828-- Structure for view `nikiac_vpembeliandtl`
1829--
1830DROP TABLE IF EXISTS `nikiac_vpembeliandtl`;
1831
1832CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `nikiac_vpembeliandtl` AS select `a`.`kdbarang` AS `kdbarang`,`a`.`nama_barang` AS `nama_barang`,`a`.`harga_beli` AS `harga_pokok_beli`,`a`.`harga_jual` AS `harga_pokok_jual`,`nikiac_suplier`.`kdsup` AS `kdsup`,`nikiac_suplier`.`nama_sup` AS `nama_sup`,`b`.`no_nota` AS `no_nota`,`b`.`total_pembelian` AS `total_pembelian`,`b`.`userID` AS `userID`,`b`.`tgl_beli` AS `tgl_beli`,`c`.`idDtlPembelian` AS `idDtlPembelian`,`c`.`kdPembelian` AS `kdPembelian`,`c`.`qty_beli` AS `qty_beli`,`c`.`harga_beli` AS `harga_beli_satBaru`,`c`.`total` AS `total_beli` from (((`nikiac_barang` `a` join `nikiac_suplier`) join `nikiac_pembelian` `b`) join `nikiac_pembeliandtl` `c`) where ((`a`.`kdbarang` = `c`.`kd_barang`) and (`b`.`kdsup` = `nikiac_suplier`.`kdsup`) and (`b`.`kdPembelian` = `c`.`kdPembelian`));
1833
1834-- --------------------------------------------------------
1835
1836--
1837-- Structure for view `nikiac_vpenjualandtl`
1838--
1839DROP TABLE IF EXISTS `nikiac_vpenjualandtl`;
1840
1841CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `nikiac_vpenjualandtl` AS select `a`.`kdbarang` AS `kdbarang`,`a`.`nama_barang` AS `nama_barang`,`a`.`harga_beli` AS `harga_beli`,`a`.`harga_jual` AS `harga_jualstd`,`b`.`idDtlPenjualan` AS `idDtlPen`,`b`.`kd_penjualan` AS `kd_penjualan`,sum((`a`.`harga_beli` * `b`.`qty`)) AS `th_beli`,`b`.`harga_jual` AS `harga_jualreal`,`b`.`qty` AS `qty`,(case when (`a`.`harga_jual` >= `b`.`harga_jual`) then sum((`a`.`harga_jual` - `b`.`harga_jual`)) when (`a`.`harga_jual` <= `b`.`harga_jual`) then 0 end) AS `diskon_produk`,sum(((`b`.`total_harga` - (`a`.`harga_beli` * `b`.`qty`)) - `c`.`diskon`)) AS `pendapatan`,`b`.`total_harga` AS `th_jual`,`c`.`customer` AS `customer`,`c`.`tgl_jual` AS `tgl_jual`,`c`.`diskon` AS `diskon_final`,`c`.`userID` AS `userID` from ((`nikiac_barang` `a` join `nikiac_penjualandtl` `b`) join `nikiac_penjualan` `c`) where ((`a`.`kdbarang` = `b`.`kd_barang`) and (`b`.`kd_penjualan` = `c`.`kd_penjualan`)) group by `b`.`idDtlPenjualan`;
1842
1843--
1844-- Constraints for dumped tables
1845--
1846
1847--
1848-- Constraints for table `nikiac_grouplvlmdl`
1849--
1850ALTER TABLE `nikiac_grouplvlmdl`
1851 ADD CONSTRAINT `nikiac_grouplvlmdl_ibfk_1` FOREIGN KEY (`idlevel`) REFERENCES `nikiac_level` (`idlevel`) ON DELETE CASCADE ON UPDATE CASCADE,
1852 ADD CONSTRAINT `nikiac_grouplvlmdl_ibfk_2` FOREIGN KEY (`modulID`) REFERENCES `nikiac_modul` (`modulID`) ON DELETE CASCADE ON UPDATE CASCADE;
1853
1854--
1855-- Constraints for table `nikiac_penjualandtl`
1856--
1857ALTER TABLE `nikiac_penjualandtl`
1858 ADD CONSTRAINT `nikiac_penjualandtl_ibfk_1` FOREIGN KEY (`kd_penjualan`) REFERENCES `nikiac_penjualan` (`kd_penjualan`) ON DELETE CASCADE ON UPDATE CASCADE;
1859
1860--
1861-- Constraints for table `nikiac_rptpriv`
1862--
1863ALTER TABLE `nikiac_rptpriv`
1864 ADD CONSTRAINT `nikiac_rptpriv_ibfk_1` FOREIGN KEY (`idlevel`) REFERENCES `nikiac_level` (`idlevel`) ON DELETE CASCADE ON UPDATE CASCADE;
1865
1866--
1867-- Constraints for table `nikiac_users`
1868--
1869ALTER TABLE `nikiac_users`
1870 ADD CONSTRAINT `nikiac_users_ibfk_1` FOREIGN KEY (`level`) REFERENCES `nikiac_level` (`idlevel`) ON DELETE CASCADE ON UPDATE CASCADE;
1871
1872/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1873/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1874/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;