INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260117-0001','1','E2D-YLAC-141-0','1','2.400','TOKO','SBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLAC-141-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YLAC-141-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-E';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E2D-YLAC-141-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.400',berat_out_asli='2.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.400',berat_akhir_asli =berat_akhir_asli-'2.400' WHERE kode_barang='E2D-YLAC-141-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260117-0001','2026-01-17','2026-01-17','07:56','2.400','admpindah','260117');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','A1D-ZAAF-21-0','1','0.950','0.950','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZAAF-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZAAF-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-01-17 08:00:37' WHERE kode_barang='A1D-ZAAF-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZAAF-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:37','TOKO','PM-A','A1D','A1D-ZAAF-21-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZAAF-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZAAF-21-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','A1E-ZAAF-25-0','1','0.600','0.600','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZAAF-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZAAF-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-01-17 08:00:37' WHERE kode_barang='A1E-ZAAF-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZAAF-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:37','TOKO','PM-A','A1E','A1E-ZAAF-25-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZAAF-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZAAF-25-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260117-0001','2026-01-17','08:00','1.550','admpindah','2026-01-17 08:00:36');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','D2F-YHXH-329-0','1','0.610','0.610','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2F-YHXH-329-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2F-YHXH-329-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-01-17 08:00:53' WHERE kode_barang='D2F-YHXH-329-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2F-YHXH-329-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:53','TOKO','PM-D','D2F','D2F-YHXH-329-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2F-YHXH-329-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2F-YHXH-329-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','D2D-ZAAF-58-0','1','0.980','0.980','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-ZAAF-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-ZAAF-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-01-17 08:00:53' WHERE kode_barang='D2D-ZAAF-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-ZAAF-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:53','TOKO','PM-D','D2D','D2D-ZAAF-58-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2D-ZAAF-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-ZAAF-58-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','D2D-ZAAF-62-0','1','0.900','0.900','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-ZAAF-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-ZAAF-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-01-17 08:00:53' WHERE kode_barang='D2D-ZAAF-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-ZAAF-62-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:53','TOKO','PM-D','D2D','D2D-ZAAF-62-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2D-ZAAF-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-ZAAF-62-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','D1G-ZAAF-74-0','1','0.370','0.370','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZAAF-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZAAF-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-01-17 08:00:53' WHERE kode_barang='D1G-ZAAF-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZAAF-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:00:53','TOKO','PM-D','D1G','D1G-ZAAF-74-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZAAF-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZAAF-74-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260117-0001','2026-01-17','08:00','2.860','admpindah','2026-01-17 08:00:53');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-YJBI-2-0','1','1.470','1.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBI-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBI-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-YJBI-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBI-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-YJBI-2-0','1','1.470','1.470','1','1.470','1.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBI-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBI-2-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-YLCX-181-0','1','0.910','0.910','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YLCX-181-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YLCX-181-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-YLCX-181-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YLCX-181-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-YLCX-181-0','1','0.910','0.910','1','0.910','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YLCX-181-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YLCX-181-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-ZAXI-378-0','1','1.890','1.890','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAXI-378-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-378-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-ZAXI-378-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAXI-378-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-ZAXI-378-0','1','1.890','1.890','1','1.890','1.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAXI-378-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-378-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-84-0','1','2.050','2.050','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-84-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-84-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-84-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-89-0','1','1.710','1.710','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-89-0','1','1.710','1.710','1','1.710','1.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-89-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-92-0','1','1.980','1.980','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-92-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-92-0','1','1.980','1.980','1','1.980','1.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-92-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-95-0','1','1.800','1.800','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-95-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-95-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-95-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-117-0','1','1.650','1.650','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-117-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-117-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-117-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-117-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-117-0','1','1.650','1.650','1','1.650','1.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-117-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-117-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-139-0','1','0.870','0.870','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-139-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-139-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-139-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-139-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-141-0','1','0.810','0.810','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-141-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-141-0','1','0.810','0.810','1','0.810','0.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-141-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2E-ZAAF-146-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZAAF-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2E-ZAAF-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZAAF-146-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2E','E2E-ZAAF-146-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZAAF-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-146-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2E-ZAAF-148-0','1','0.610','0.610','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZAAF-148-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-148-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2E-ZAAF-148-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZAAF-148-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2E','E2E-ZAAF-148-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZAAF-148-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-148-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2E-ZAAF-149-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZAAF-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-149-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2E-ZAAF-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZAAF-149-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2E','E2E-ZAAF-149-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZAAF-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZAAF-149-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-ZAAF-177-0','1','1.030','1.030','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAF-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-ZAAF-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAF-177-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-ZAAF-177-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAF-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-177-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-ZAAF-178-0','1','1.980','1.980','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAF-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-ZAAF-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAF-178-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-ZAAF-178-0','1','1.980','1.980','1','1.980','1.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAF-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-178-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-ZAAF-179-0','1','1.420','1.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAF-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-ZAAF-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAF-179-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-ZAAF-179-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAF-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-179-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1D-ZAAF-180-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAF-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1D-ZAAF-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAF-180-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1D','E1D-ZAAF-180-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAF-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAF-180-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E1E-ZAAF-239-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZAAF-239-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZAAF-239-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E1E-ZAAF-239-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZAAF-239-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E1E','E1E-ZAAF-239-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZAAF-239-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZAAF-239-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','E2D-ZAAF-268-0','1','1.040','1.040','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAF-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-17 08:01:14' WHERE kode_barang='E2D-ZAAF-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAAF-268-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:14','TOKO','PM-E','E2D','E2D-ZAAF-268-0','1','1.040','1.040','1','1.040','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAAF-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAAF-268-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260117-0001','2026-01-17','08:01','23.610','admpindah','2026-01-17 08:01:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','F3E-YDBI-74-0','1','1.560','1.560','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YDBI-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YDBI-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-17 08:01:38' WHERE kode_barang='F3E-YDBI-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YDBI-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:38','TOKO','PM-F','F3E','F3E-YDBI-74-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YDBI-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YDBI-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','F3E-ZAAC-136-0','1','1.460','1.460','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAC-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAC-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-17 08:01:38' WHERE kode_barang='F3E-ZAAC-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAC-136-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:38','TOKO','PM-F','F3E','F3E-ZAAC-136-0','1','1.460','1.460','1','1.460','1.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAC-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAC-136-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260117-0001','2026-01-17','08:01','3.020','admpindah','2026-01-17 08:01:38');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260117-0001','1','H2J-ZAAE-125-0','1','1.930','1.930','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZAAE-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZAAE-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-01-17 08:01:58' WHERE kode_barang='H2J-ZAAE-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZAAE-125-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-17 08:01:58','TOKO','PM-H','H2J','H2J-ZAAE-125-0','1','1.930','1.930','1','1.930','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZAAE-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZAAE-125-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260117-0001','2026-01-17','08:01','1.930','admpindah','2026-01-17 08:01:57');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170827451','input','1',' MHA1 HK ','TOKO','PM-A','A1H-YLCX-360-0','AT TINDIK BABY HK 8K ','','0.260','1','100.00','311000','0','0','15000','310000','0','0','0','310000','FIT','00383765','A1H','0','0','-','1','1197000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YLCX-360-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='A1H-YLCX-360-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170827451','2026-01-17','0.260','2026-01-17','08:27:46','PLG0026764','310000','310000','0','310000','310000','input','2026-01-17 08:27:45','F32617082745');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326170827451','2026-01-17','08:27:46','FIT','310000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0002','D','2026-01-17','08:27:46','input','PENJUALAN','F326170827451','1884843000','310000','1885153000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170945221','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-ZAXH-216-0','GW X TIFF MATA VAR LG 8K ','','0.550','1','100.00','625000','0','0','15000','625000','0','0','0','625000','FIT','00384302','B1E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZAXH-216-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='B1E-ZAXH-216-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170945221','2026-01-17','0.550','2026-01-17','09:45:22','PLG0026765','625000','625000','0','625000','625000','input','2026-01-17 09:45:22','F32617094522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326170945221','2026-01-17','09:45:22','FIT','625000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260117-0003','D','2026-01-17','09:45:22','input','PENJUALAN','F326170945221','1885153000','625000','1885778000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='625000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170945221' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170945222','input',' 1',' MEE2 BW 11','TOKO','PM-E','E2E-YHAB-113-0','CC MODEL MATA VAR BW 11 8K ','','0.470','1','100.00','534000','0','0','15000','535000','0','0','0','535000','FIT','00365368','E2E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHAB-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='E2E-YHAB-113-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170945222','2026-01-17','0.470','2026-01-17','09:45:22','PLG0026766','535000','535000','0','535000','535000','input','2026-01-17 09:45:22','F32617094522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326170945222','2026-01-17','09:45:22','FIT','535000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260117-0004','D','2026-01-17','09:45:22','input','PENJUALAN','F326170945222','1885778000','535000','1886313000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170945222' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171021501','input','1',' MGPDG X LG','TOKO','PM-P','PDG-YHXH-138-0','LT X WG MODEL MATA LG 8K ','','0.510','1','100.00','600000','0','0','15000','600000','0','0','0','600000','FIT','00364666','PDG','0','0','-','0','1187000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-YHXH-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='PDG-YHXH-138-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171021501','2026-01-17','0.510','2026-01-17','10:21:51','PLG0026767','600000','600000','0','600000','600000','input','2026-01-17 10:21:50','F32617102150');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171021501','2026-01-17','10:21:51','FIT','600000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260117-0005','D','2026-01-17','10:21:51','input','PENJUALAN','F326171021501','1886313000','600000','1886913000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326171021501' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171021502','input',' 1',' MGPH KH 42','TOKO','PM-P','PHG-YHXE-173-0','KL WG SANTA KH 42CM 8K ','','2.010','1','100.00','2366000','0','0','15000','2365000','0','0','0','2365000','FIT','00363960','PHG','0','0','-','1','1187000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHG-YHXE-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='PHG-YHXE-173-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171021502','2026-01-17','2.010','2026-01-17','10:21:51','PLG0026768','2365000','2365000','0','2365000','2365000','input','2026-01-17 10:21:50','F32617102150');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171021502','2026-01-17','10:21:51','FIT','2365000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260117-0006','D','2026-01-17','10:21:51','input','PENJUALAN','F326171021502','1886913000','2365000','1889278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2365000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326171021502' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171106511','input','1',' MEF3E X KH','TOKO','PM-F','F3E-YLBE-87-0','GL X RANTAI HOLLOW P3 SLEP KH 8K ','','2.150','1','100.00','2445000','0','0','15000','2445000','0','0','0','2445000','SIN','00383107','F3E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBE-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='F3E-YLBE-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171106511','2026-01-17','2.150','2026-01-17','11:06:51','PLG0026769','2445000','2445000','0','2445000','2445000','input','2026-01-17 11:06:51','F32617110651');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171106511','2026-01-17','11:06:51','SIN','2445000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0007','D','2026-01-17','11:06:51','input','PENJUALAN','F326171106511','1889278000','2445000','1891723000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171107251','input','1',' MEF3E UB ','TOKO','PM-F','F3E-YLXC-7-0','GL GHENIA SLEP UB 8K ','','1.000','1','100.00','1137000','0','0','15000','1137000','0','0','0','1137000','SIN','00379323','F3E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXC-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='F3E-YLXC-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171107251','2026-01-17','1.000','2026-01-17','11:07:25','PLG0026770','1137000','1137000','0','1137000','1137000','input','2026-01-17 11:07:25','F32617110725');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171107251','2026-01-17','11:07:25','SIN','1137000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0008','D','2026-01-17','11:07:25','input','PENJUALAN','F326171107251','1891723000','1137000','1892860000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017976','X-00017976','AT ANAK BONEKA CAT MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','470000','2026-01-17','0.510','1','kasir','2026-01-17 11:33:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017976','X-00017976');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0001','F325090857231','FIT','1','BELI','BELI001','A1E', 'X-00017976', 'AT ANAK BONEKA CAT MATA VAR LG 8K','0.510','0.510','100.00','505000','470000','921569','1147000','1','470000','470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0001','2026-01-17','2026-01-17','11:33:00','FIT','---','0.510','470000','470000','470000','470000','470000','kasir','2026-01-17 11:33:00','FB-260117-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0001','MITA','SETREN LEMAHBANG','','','','kasir','2026-01-17 11:33:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0009','K','2026-01-17','11:33:00','kasir','PEMBELIAN UMUM','FB-260117-0001','1892860000','470000','1892390000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017977','X-00017977','CC X POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','955000','2026-01-17','0.980','1','kasir','2026-01-17 11:33:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017977','X-00017977');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0002','F325220849291','AAT','1','BELI','BELI001','E1D', 'X-00017977', 'CC X POLOS CM 14 8K','0.980','0.980','100.00','1028000','955000','974490','1127000','1','955000','955000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0002','2026-01-17','2026-01-17','11:33:25','AAT','---','0.980','955000','955000','955000','955000','955000','kasir','2026-01-17 11:33:25','FB-260117-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0002','SRIYANTO','PLOSO KISMANTORO','','','','kasir','2026-01-17 11:33:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0010','K','2026-01-17','11:33:25','kasir','PEMBELIAN UMUM','FB-260117-0002','1892390000','955000','1891435000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017978','X-00017978','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','3305000','2026-01-17','3.050','1','kasir','2026-01-17 11:33:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017978','X-00017978');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0003','F325171150031','FIT','1','BELI','BELI001','H2I', 'X-00017978', 'KL X SANTA KH 44 9K','3.050','3.050','100.00','3555000','3305000','1083607','1217000','1','3305000','3305000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0003','2026-01-17','2026-01-17','11:33:56','FIT','---','3.050','3305000','3305000','3305000','3305000','3305000','kasir','2026-01-17 11:33:57','FB-260117-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0003','YULIANA','STREEN LEMAHBANG','','','','kasir','2026-01-17 11:33:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0011','K','2026-01-17','11:33:56','kasir','PEMBELIAN UMUM','FB-260117-0003','1891435000','3305000','1888130000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017979','X-00017979','GL X TIFF SLEP HW 8K','GR','---','F3E','BELI','BELI001','1005000','2026-01-17','1.080','1','kasir','2026-01-17 11:34:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017979','X-00017979');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0004','F325061240332','SIN','1','BELI','BELI001','F3E', 'X-00017979', 'GL X TIFF SLEP HW 8K','1.080','1.080','100.00','1059000','1005000','930556','1147000','1','1005000','1005000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0004','2026-01-17','2026-01-17','11:34:30','SIN','---','1.080','1005000','1005000','1005000','1005000','1005000','kasir','2026-01-17 11:34:31','FB-260117-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0004','DESTY','PURWANTORO','','','','kasir','2026-01-17 11:34:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0012','K','2026-01-17','11:34:30','kasir','PEMBELIAN UMUM','FB-260117-0004','1888130000','1005000','1887125000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017980','X-00017980','GL X KOREA SLEP KH 8K','GR','---','F3F','BELI','BELI001','1197000','2026-01-17','1.260','1','kasir','2026-01-17 11:35:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00017980','X-00017980');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0005','F325061241351','SIN','1','BELI','BELI001','F3F', 'X-00017980', 'GL X KOREA SLEP KH 8K','1.260','1.260','100.00','1260000','1197000','950000','1167000','1','1197000','1197000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0005','2026-01-17','2026-01-17','11:35:13','SIN','---','1.260','1197000','1197000','1197000','1197000','1197000','kasir','2026-01-17 11:35:14','FB-260117-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0005','SABILLA','PURWANTORO','','','','kasir','2026-01-17 11:35:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0013','K','2026-01-17','11:35:13','kasir','PEMBELIAN UMUM','FB-260117-0005','1887125000','1197000','1885928000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017981','X-00017981','CC MODEL DAUN SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','445000','2026-01-17','0.460','1','kasir','2026-01-17 11:37:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017981','X-00017981');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0006','F325291045391','AAT','1','BELI','BELI001','E1E', 'X-00017981', 'CC MODEL DAUN SLEP LG 14 8K','0.460','0.460','100.00','475000','445000','967391','1147000','1','445000','445000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0006','2026-01-17','2026-01-17','11:37:41','AAT','---','0.460','445000','445000','445000','445000','445000','kasir','2026-01-17 11:37:42','FB-260117-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0006','RARA','POHIJO','','','','kasir','2026-01-17 11:37:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0014','K','2026-01-17','11:37:41','kasir','PEMBELIAN UMUM','FB-260117-0006','1885928000','445000','1885483000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017982','X-00017982','CC X MODEL MATA CAT UB 14 8K','GR','---','E2E','BELI','BELI001','455000','2026-01-17','0.470','1','kasir','2026-01-17 11:38:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017982','X-00017982');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0007','F325291051441','AAT','1','BELI','BELI001','E2E', 'X-00017982', 'CC X MODEL MATA CAT UB 14 8K','0.470','0.470','100.00','485000','455000','968085','1147000','1','455000','455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0007','2026-01-17','2026-01-17','11:38:15','AAT','---','0.470','455000','455000','455000','455000','455000','kasir','2026-01-17 11:38:16','FB-260117-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0007','RARA','POHIJO','','','','kasir','2026-01-17 11:38:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0015','K','2026-01-17','11:38:15','kasir','PEMBELIAN UMUM','FB-260117-0007','1885483000','455000','1885028000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171230361','kasir','1',' MDE2 5K LG','TOKO','PM-E','E2D-YDAX-294-0','CC OSROT ANAK EROPA MATA LG 8K ','','0.930','1','100.00','1039000','0','0','15000','1040000','0','5000','0','1045000','AAT','00348780','E2D','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDAX-294-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='E2D-YDAX-294-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171230361','2026-01-17','0.930','2026-01-17','12:30:37','PLG0026771','1040000','1040000','5000','1045000','1045000','kasir','2026-01-17 12:30:36','F32617123036');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171230361','2026-01-17','12:30:37','AAT','1045000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0016','D','2026-01-17','12:30:37','kasir','PENJUALAN','F326171230361','1885028000','1045000','1886073000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171235001','kasir','1',' TDE2 10K C','TOKO','PT-E','E2TD-XIBF-42-T','CC WEDDING MATA CM 22 17K ','','2.140','1','100.00','4376000','0','0','15000','4375000','0','10000','0','4385000','FIT','T0062325','E2TD','0','0','-','1','2045000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-XIBF-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='E2TD-XIBF-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171235001','2026-01-17','2.140','2026-01-17','12:35:00','PLG0026772','4375000','4375000','10000','4385000','4385000','kasir','2026-01-17 12:35:00','F32617123500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171235001','2026-01-17','12:35:00','FIT','4385000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0017','D','2026-01-17','12:35:00','kasir','PENJUALAN','F326171235001','1886073000','4385000','1890458000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171237201','kasir','1',' MEF2 X YT ','TOKO','PM-F','F2E-YACA-13-0','GL X OVAL MATA YT 56 8K ','','7.600','1','100.00','8641000','0','0','15000','8640000','0','0','0','8640000','SIN','00336675','F2E','0','0','-','1','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YACA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.600',berat_jual_asli=berat_jual_asli+'7.600',stock_jual='1',berat_akhir=berat_akhir-'7.600',berat_akhir_asli=berat_akhir_asli-'7.600',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='F2E-YACA-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171237201','2026-01-17','7.600','2026-01-17','12:37:21','PLG0026773','8640000','8640000','0','8640000','8640000','kasir','2026-01-17 12:37:20','F32617123720');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326171237201','2026-01-17','12:37:21','SIN','8640000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0018','D','2026-01-17','12:37:21','kasir','PENJUALAN','F326171237201','1890458000','8640000','1899098000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170113571','kasir','1',' MED2E X LG','TOKO','PM-D','D2E-YIBD-135-0','LT X MODEL MATA LG 8K ','','0.470','1','100.00','534000','0','0','15000','535000','0','0','0','535000','FIT','00370556','D2E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBD-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='D2E-YIBD-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170113571','2026-01-17','0.470','2026-01-17','13:13:57','PLG0026774','535000','535000','0','535000','535000','kasir','2026-01-17 13:13:57','F32617011357');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326170113571','2026-01-17','13:13:57','FIT','535000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0019','D','2026-01-17','13:13:57','kasir','PENJUALAN','F326170113571','1899098000','535000','1899633000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170127151','kasir','1',' MDB1 X CM ','TOKO','PM-B','B1D-ZAAE-3-0','GW X MODEL MATA CM PE 8K ','','0.910','1','100.00','1016000','0','0','15000','1015000','0','5000','0','1020000','SIN','00385252','B1D','0','0','-','1','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-01-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZAAE-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-01-17' AND kode_barang='B1D-ZAAE-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170127151','2026-01-17','0.910','2026-01-17','13:27:15','PLG0026775','1015000','1015000','5000','1020000','1020000','kasir','2026-01-17 13:27:15','F32617012715');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-17','F326170127151','2026-01-17','13:27:15','SIN','1020000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260117-0020','D','2026-01-17','13:27:15','kasir','PENJUALAN','F326170127151','1899633000','1020000','1900653000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017983','X-00017983','LT MODEL SOLITAIRE MATA VAR CM 8K','GR','---','D2E','BELI','BELI001','427000','2026-01-17','0.550','1','kasir','2026-01-17 13:37:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017983','X-00017983');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0008','F325291053431','FIT','1','BELI','BELI001','D2E', 'X-00017983', 'LT MODEL SOLITAIRE MATA VAR CM 8K','0.550','0.550','100.00','455000','427000','776364','1147000','1','427000','427000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0008','2026-01-17','2026-01-17','13:37:17','FIT','---','0.550','427000','427000','427000','427000','427000','kasir','2026-01-17 13:37:17','FB-260117-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0008','AFRIANI','PURWANTORO','','','','kasir','2026-01-17 13:37:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0021','K','2026-01-17','13:37:17','kasir','PEMBELIAN UMUM','FB-260117-0008','1900653000','427000','1900226000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017984','X-00017984','CC MODEL MATA VAR CM 12 8K','GR','---','E2D','BELI','BELI001','1037000','2026-01-17','1.070','1','kasir','2026-01-17 13:38:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017984','X-00017984');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260117-0009','F325151238181','FIT','1','BELI','BELI001','E2D', 'X-00017984', 'CC MODEL MATA VAR CM 12 8K','1.070','1.070','100.00','1105000','1037000','969159','1127000','1','1037000','1037000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260117-0009','2026-01-17','2026-01-17','13:38:06','FIT','---','1.070','1037000','1037000','1037000','1037000','1037000','kasir','2026-01-17 13:38:06','FB-260117-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260117-0009','LINDA','SUMBER BITING','','','','kasir','2026-01-17 13:38:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260117-0022','K','2026-01-17','13:38:06','kasir','PEMBELIAN UMUM','FB-260117-0009','1900226000','1037000','1899189000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260117-0001','1','E2TD-YGXD-16-T','1','1.970','1.970','TOKO','PT-E','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TBK-E' WHERE kode_barang='E2TD-YGXD-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-17','TOKO','TBK-E','E2TD','E2TD-YGXD-16-T','100.00','1','1.970','1.970','1','1.970','1.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-17' AND kode_barang='E2TD-YGXD-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260117-0001','2026-01-17','2026-01-17','14:58','1.97','input','2026-01-17 14:59:42');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260117-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260117-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170113571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170113571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170113571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170127151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170127151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170127151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170827451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170827451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170827451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170945221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170945221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170945221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170945222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170945222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170945222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171021501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171021502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171106511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171106511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171106511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171107251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171107251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171107251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171230361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171230361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171230361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171235001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171235001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171235001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171237201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171237201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171237201';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-17';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260118-0001','D','2026-01-18','15:20:59','SYSTEM','SALDO AWAL','SALDO AWAL','0','1899189000','1899189000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260118-0001','D','2026-01-18','15:20:59','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260118-0001','D','2026-01-18','15:20:59','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260118-0001','D','2026-01-18','15:20:59','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-01-18';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260118-0001','1','E2TD-YGXD-16-T','1','1.970','TOKO','TBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YGXD-16-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YGXD-16-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TBK-E';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E2TD-YGXD-16-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='E2TD-YGXD-16-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260118-0001','2026-01-18','2026-01-18','16:23','1.970','admpindah','260118');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-YHXG-345-0','1','7.070','7.070','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YHXG-345-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YHXG-345-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:24:37' WHERE kode_barang='F3E-YHXG-345-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YHXG-345-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:24:37','TOKO','PM-F','F3E','F3E-YHXG-345-0','1','7.070','7.070','1','7.070','7.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YHXG-345-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHXG-345-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:24','7.070','admpindah','2026-01-17 16:24:36');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','B1E-ZAAC-28-0','1','0.560','0.560','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZAAC-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZAAC-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-01-18 16:58:27' WHERE kode_barang='B1E-ZAAC-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZAAC-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:27','TOKO','PM-B','B1E','B1E-ZAAC-28-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZAAC-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZAAC-28-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:58','0.560','admpindah','2026-01-17 16:58:26');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','E1D-ZAAG-198-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAG-198-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-198-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-18 16:58:42' WHERE kode_barang='E1D-ZAAG-198-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAG-198-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:42','TOKO','PM-E','E1D','E1D-ZAAG-198-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAG-198-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-198-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','E1D-ZAAG-199-0','1','1.140','1.140','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAG-199-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-199-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-18 16:58:42' WHERE kode_barang='E1D-ZAAG-199-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAG-199-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:42','TOKO','PM-E','E1D','E1D-ZAAG-199-0','1','1.140','1.140','1','1.140','1.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAG-199-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-199-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','E1D-ZAAG-200-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAAG-200-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-200-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-01-18 16:58:42' WHERE kode_barang='E1D-ZAAG-200-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAAG-200-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:42','TOKO','PM-E','E1D','E1D-ZAAG-200-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAAG-200-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAAG-200-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:58','3.240','admpindah','2026-01-17 16:58:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-YKXH-100-0','1','1.430','1.430','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXH-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXH-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-YKXH-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXH-100-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-YKXH-100-0','1','1.430','1.430','1','1.430','1.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKXH-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXH-100-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F1E-ZAAC-102-0','1','2.050','2.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZAAC-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZAAC-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F1E-ZAAC-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZAAC-102-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F1E','F1E-ZAAC-102-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZAAC-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZAAC-102-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAE-47-0','1','7.980','7.980','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAE-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAE-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAE-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAE-47-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAE-47-0','1','7.980','7.980','1','7.980','7.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAE-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAE-47-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-195-0','1','3.140','3.140','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-195-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-195-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-195-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-195-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-195-0','1','3.140','3.140','1','3.140','3.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-195-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-195-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-196-0','1','4.560','4.560','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-196-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-196-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-196-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-196-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-196-0','1','4.560','4.560','1','4.560','4.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-196-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-196-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-197-0','1','2.010','2.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-197-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-197-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-197-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-197-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-197-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-197-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-197-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-201-0','1','0.480','0.480','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-201-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-201-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-201-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-202-0','1','2.050','2.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-202-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-202-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-202-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','F3E-ZAAG-203-0','1','3.050','3.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAG-203-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-203-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-01-18 16:58:57' WHERE kode_barang='F3E-ZAAG-203-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZAAG-203-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:58:57','TOKO','PM-F','F3E','F3E-ZAAG-203-0','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZAAG-203-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZAAG-203-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:58','26.750','admpindah','2026-01-17 16:58:57');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','H1E-YLBC-109-0','1','5.830','5.830','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLBC-109-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLBC-109-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-01-18 16:59:13' WHERE kode_barang='H1E-YLBC-109-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLBC-109-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:59:13','TOKO','PM-H','H1E','H1E-YLBC-109-0','1','5.830','5.830','1','5.830','5.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLBC-109-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLBC-109-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','H1E-ZAAG-204-0','1','4.110','4.110','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZAAG-204-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZAAG-204-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-01-18 16:59:13' WHERE kode_barang='H1E-ZAAG-204-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZAAG-204-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:59:13','TOKO','PM-H','H1E','H1E-ZAAG-204-0','1','4.110','4.110','1','4.110','4.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZAAG-204-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZAAG-204-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','H1E-ZAAG-205-0','1','10.100','10.100','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZAAG-205-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZAAG-205-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-01-18 16:59:13' WHERE kode_barang='H1E-ZAAG-205-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZAAG-205-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:59:13','TOKO','PM-H','H1E','H1E-ZAAG-205-0','1','10.100','10.100','1','10.100','10.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZAAG-205-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZAAG-205-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:59','20.040','admpindah','2026-01-17 16:59:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260118-0001','1','PDF-YLAX-44-0','1','0.500','0.500','TOKO','PMBK-P','TOKO','PM-P');
DELETE FROM tm_barang WHERE kode_barang='PDF-YLAX-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PDF-YLAX-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2026-01-18 16:59:29' WHERE kode_barang='PDF-YLAX-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PDF-YLAX-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-18 16:59:29','TOKO','PM-P','PDF','PDF-YLAX-44-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PDF' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PDF' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PDF-YLAX-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PDF-YLAX-44-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260118-0001','2026-01-18','16:59','0.500','admpindah','2026-01-17 16:59:28');