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-20260407-0001','1','A1D-ZBXE-76-0','1','1.070','1.070','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBXE-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBXE-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-04-07 08:08:48' WHERE kode_barang='A1D-ZBXE-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBXE-76-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-04-07 08:08:48','TOKO','PM-A','A1D','A1D-ZBXE-76-0','1','1.070','1.070','1','1.070','1.070','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-ZBXE-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBXE-76-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-20260407-0001','1','A1D-ZCAI-125-0','1','0.980','0.980','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZCAI-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZCAI-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-04-07 08:08:48' WHERE kode_barang='A1D-ZCAI-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZCAI-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-04-07 08:08:48','TOKO','PM-A','A1D','A1D-ZCAI-125-0','1','0.980','0.980','1','0.980','0.980','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-ZCAI-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZCAI-125-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:08','2.050','admpindah','2026-04-07 08:08:48');
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-20260407-0001','1','B1H-ZDXD-238-0','1','0.260','0.260','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-ZDXD-238-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-ZDXD-238-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-07 08:09:10' WHERE kode_barang='B1H-ZDXD-238-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-ZDXD-238-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-04-07 08:09:10','TOKO','PM-B','B1H','B1H-ZDXD-238-0','1','0.260','0.260','1','0.260','0.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-ZDXD-238-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-ZDXD-238-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-20260407-0001','1','B1G-ZDXF-193-0','1','0.370','0.370','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZDXF-193-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZDXF-193-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-07 08:09:10' WHERE kode_barang='B1G-ZDXF-193-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZDXF-193-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-04-07 08:09:10','TOKO','PM-B','B1G','B1G-ZDXF-193-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' 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='B1G-ZDXF-193-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZDXF-193-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-20260407-0001','1','B1H-ZDXF-199-0','1','0.240','0.240','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-ZDXF-199-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-ZDXF-199-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-07 08:09:10' WHERE kode_barang='B1H-ZDXF-199-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-ZDXF-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-04-07 08:09:10','TOKO','PM-B','B1H','B1H-ZDXF-199-0','1','0.240','0.240','1','0.240','0.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-ZDXF-199-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-ZDXF-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-20260407-0001','1','B1H-ZDXF-200-0','1','0.240','0.240','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-ZDXF-200-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-ZDXF-200-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-04-07 08:09:10' WHERE kode_barang='B1H-ZDXF-200-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-ZDXF-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-04-07 08:09:10','TOKO','PM-B','B1H','B1H-ZDXF-200-0','1','0.240','0.240','1','0.240','0.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-ZDXF-200-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-ZDXF-200-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:09','1.110','admpindah','2026-04-07 08:09:10');
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-20260407-0001','1','D2E-YKXC-359-0','1','0.550','0.550','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YKXC-359-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YKXC-359-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-04-07 08:09:36' WHERE kode_barang='D2E-YKXC-359-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YKXC-359-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-04-07 08:09:36','TOKO','PM-D','D2E','D2E-YKXC-359-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' 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='D2E-YKXC-359-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YKXC-359-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:09','0.550','admpindah','2026-04-07 08:09:35');
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-20260407-0001','1','E1D-ZBAD-344-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAD-344-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAD-344-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E1D-ZBAD-344-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAD-344-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-04-07 08:09:54','TOKO','PM-E','E1D','E1D-ZBAD-344-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-ZBAD-344-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAD-344-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-20260407-0001','1','E2D-ZDXF-201-0','1','0.800','0.800','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-201-0','1','0.800','0.800','1','0.800','0.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-ZDXF-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-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-20260407-0001','1','E2D-ZDXF-202-0','1','0.810','0.810','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-202-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-ZDXF-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-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-20260407-0001','1','E2D-ZDXF-203-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-203-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-203-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-203-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-203-0','1','0.900','0.900','1','0.900','0.900','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-ZDXF-203-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-203-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-20260407-0001','1','E2D-ZDXF-204-0','1','0.850','0.850','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-204-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-204-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-204-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-204-0','1','0.850','0.850','1','0.850','0.850','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-ZDXF-204-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-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-20260407-0001','1','E2D-ZDXF-205-0','1','0.930','0.930','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-205-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-205-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-205-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-205-0','1','0.930','0.930','1','0.930','0.930','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-ZDXF-205-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-205-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-20260407-0001','1','E2D-ZDXF-206-0','1','0.860','0.860','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-206-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-206-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-206-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-206-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-206-0','1','0.860','0.860','1','0.860','0.860','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-ZDXF-206-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-206-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-20260407-0001','1','E2D-ZDXF-207-0','1','0.970','0.970','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDXF-207-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-207-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-07 08:09:54' WHERE kode_barang='E2D-ZDXF-207-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDXF-207-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-04-07 08:09:54','TOKO','PM-E','E2D','E2D-ZDXF-207-0','1','0.970','0.970','1','0.970','0.970','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-ZDXF-207-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDXF-207-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:09','7.120','admpindah','2026-04-07 08:09:54');
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-20260407-0001','1','F3E-YECA-116-0','1','1.470','1.470','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YECA-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YECA-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-07 08:10:19' WHERE kode_barang='F3E-YECA-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YECA-116-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-04-07 08:10:19','TOKO','PM-F','F3E','F3E-YECA-116-0','1','1.470','1.470','1','1.470','1.470','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-YECA-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YECA-116-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-20260407-0001','1','F1E-YGAH-149-0','1','2.130','2.130','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YGAH-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YGAH-149-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-07 08:10:19' WHERE kode_barang='F1E-YGAH-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YGAH-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-04-07 08:10:19','TOKO','PM-F','F1E','F1E-YGAH-149-0','1','2.130','2.130','1','2.130','2.130','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-YGAH-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YGAH-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-20260407-0001','1','F3E-YJBB-159-0','1','6.650','6.650','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJBB-159-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJBB-159-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-07 08:10:19' WHERE kode_barang='F3E-YJBB-159-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJBB-159-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-04-07 08:10:19','TOKO','PM-F','F3E','F3E-YJBB-159-0','1','6.650','6.650','1','6.650','6.650','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-YJBB-159-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJBB-159-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-20260407-0001','1','F3E-ZCCX-291-0','1','7.050','7.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCCX-291-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCCX-291-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-07 08:10:19' WHERE kode_barang='F3E-ZCCX-291-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCCX-291-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-04-07 08:10:19','TOKO','PM-F','F3E','F3E-ZCCX-291-0','1','7.050','7.050','1','7.050','7.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-ZCCX-291-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCCX-291-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-20260407-0001','1','F3E-ZCCX-298-0','1','1.030','1.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCCX-298-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCCX-298-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-07 08:10:19' WHERE kode_barang='F3E-ZCCX-298-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCCX-298-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-04-07 08:10:19','TOKO','PM-F','F3E','F3E-ZCCX-298-0','1','1.030','1.030','1','1.030','1.030','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-ZCCX-298-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCCX-298-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:10','18.330','admpindah','2026-04-07 08:10:19');
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-20260407-0001','1','H2J-ZCXB-338-0','1','4.900','4.900','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZCXB-338-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZCXB-338-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-04-07 08:10:39' WHERE kode_barang='H2J-ZCXB-338-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZCXB-338-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-04-07 08:10:39','TOKO','PM-H','H2J','H2J-ZCXB-338-0','1','4.900','4.900','1','4.900','4.900','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-ZCXB-338-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZCXB-338-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-20260407-0001','1','H2J-ZCXB-341-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZCXB-341-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZCXB-341-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-04-07 08:10:39' WHERE kode_barang='H2J-ZCXB-341-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZCXB-341-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-04-07 08:10:39','TOKO','PM-H','H2J','H2J-ZCXB-341-0','1','2.050','2.050','1','2.050','2.050','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-ZCXB-341-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZCXB-341-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-20260407-0001','1','H2J-ZCXG-223-0','1','1.260','1.260','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZCXG-223-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZCXG-223-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-04-07 08:10:39' WHERE kode_barang='H2J-ZCXG-223-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZCXG-223-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-04-07 08:10:39','TOKO','PM-H','H2J','H2J-ZCXG-223-0','1','1.260','1.260','1','1.260','1.260','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-ZCXG-223-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZCXG-223-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-20260407-0001','1','H1E-ZCCX-358-0','1','3.030','3.030','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCCX-358-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCCX-358-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-04-07 08:10:39' WHERE kode_barang='H1E-ZCCX-358-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCCX-358-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-04-07 08:10:39','TOKO','PM-H','H1E','H1E-ZCCX-358-0','1','3.030','3.030','1','3.030','3.030','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-ZCCX-358-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCCX-358-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:10','11.240','admpindah','2026-04-07 08:10:39');
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-20260407-0001','1','A1TD-ZDXF-30-T','1','0.980','0.980','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZDXF-30-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-30-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-04-07 08:11:04' WHERE kode_barang='A1TD-ZDXF-30-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZDXF-30-T' 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-04-07 08:11:04','TOKO','PT-A','A1TD','A1TD-ZDXF-30-T','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZDXF-30-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-30-T';
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-20260407-0001','1','A1TD-ZDXF-31-T','1','1.050','1.050','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZDXF-31-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-31-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-04-07 08:11:04' WHERE kode_barang='A1TD-ZDXF-31-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZDXF-31-T' 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-04-07 08:11:04','TOKO','PT-A','A1TD','A1TD-ZDXF-31-T','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZDXF-31-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZDXF-31-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:10','2.030','admpindah','2026-04-07 08:11:03');
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-20260407-0001','1','D1TE-ZDXF-32-T','1','0.430','0.430','TOKO','PTBK-D','TOKO','PT-D');
DELETE FROM tm_barang WHERE kode_barang='D1TE-ZDXF-32-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1TE-ZDXF-32-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-D',tgl_last_beli='2026-04-07 08:11:41' WHERE kode_barang='D1TE-ZDXF-32-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1TE-ZDXF-32-T' 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-04-07 08:11:41','TOKO','PT-D','D1TE','D1TE-ZDXF-32-T','1','0.430','0.430','1','0.430','0.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1TE-ZDXF-32-T';
DELETE FROM tm_barang_export WHERE kode_barang='D1TE-ZDXF-32-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:11','0.430','admpindah','2026-04-07 08:11:40');
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-20260407-0001','1','E1TE-ZDXF-33-T','1','0.650','0.650','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-04-07 08:12:00' WHERE kode_barang='E1TE-ZDXF-33-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZDXF-33-T' 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-04-07 08:12:00','TOKO','PT-E','E1TE','E1TE-ZDXF-33-T','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZDXF-33-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZDXF-33-T';
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-20260407-0001','1','E1TD-ZDXF-34-T','1','1.050','1.050','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-04-07 08:12:00' WHERE kode_barang='E1TD-ZDXF-34-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZDXF-34-T' 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-04-07 08:12:00','TOKO','PT-E','E1TD','E1TD-ZDXF-34-T','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZDXF-34-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZDXF-34-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:11','1.700','admpindah','2026-04-07 08:12:00');
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-20260407-0001','1','H1TE-ZDXF-35-T','1','2.130','2.130','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZDXF-35-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-35-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-04-07 08:12:22' WHERE kode_barang='H1TE-ZDXF-35-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZDXF-35-T' 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-04-07 08:12:22','TOKO','PT-H','H1TE','H1TE-ZDXF-35-T','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZDXF-35-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-35-T';
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-20260407-0001','1','H1TE-ZDXF-36-T','1','4.100','4.100','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZDXF-36-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-36-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-04-07 08:12:22' WHERE kode_barang='H1TE-ZDXF-36-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZDXF-36-T' 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-04-07 08:12:22','TOKO','PT-H','H1TE','H1TE-ZDXF-36-T','1','4.100','4.100','1','4.100','4.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZDXF-36-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-36-T';
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-20260407-0001','1','H1TE-ZDXF-37-T','1','3.070','3.070','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZDXF-37-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-37-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-04-07 08:12:22' WHERE kode_barang='H1TE-ZDXF-37-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZDXF-37-T' 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-04-07 08:12:22','TOKO','PT-H','H1TE','H1TE-ZDXF-37-T','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZDXF-37-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXF-37-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260407-0001','2026-04-07','08:12','9.300','admpindah','2026-04-07 08:12:21');
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 ('F326070901031','input','1',' MDE1 CM 20','TOKO','PM-E','E1D-ZAXH-114-T','CC VELG KACA CM 20 8K ','','0.960','1','100.00','1085000','0','0','15000','1085000','0','0','0','1085000','AAT','T0076437','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1D-ZAXH-114-T' 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 ('F326070901031','2026-04-07','0.960','2026-04-07','09:01:04','PLG0028495','1085000','1085000','0','1085000','1085000','input','2026-04-07 09:01:03','F32607090103');
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-04-07','F326070901031','2026-04-07','09:01:04','AAT','1085000','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-260407-0002','D','2026-04-07','09:01:04','input','PENJUALAN','F326070901031','4278967000','1085000','4280052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070901031' 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 ('F326070901032','input',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-YEXC-498-0','CC X POLOS CM 22 8K ','','1.980','1','100.00','2237000','0','0','15000','2240000','0','0','0','2240000','AAT','00352809','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEXC-498-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1D-YEXC-498-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 ('F326070901032','2026-04-07','1.980','2026-04-07','09:01:04','PLG0028496','2240000','2240000','0','2240000','2240000','input','2026-04-07 09:01:03','F32607090103');
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-04-07','F326070901032','2026-04-07','09:01:04','AAT','2240000','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-260407-0003','D','2026-04-07','09:01:04','input','PENJUALAN','F326070901032','4280052000','2240000','4282292000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2240000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070901032' 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 ('F326070906511','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDXD-264-0','GL RANTE DAUN VAR HW 8K ','','1.630','1','100.00','1875000','0','0','15000','1875000','0','0','0','1875000','SIN','00397964','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXD-264-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZDXD-264-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 ('F326070906511','2026-04-07','1.630','2026-04-07','09:06:51','PLG0028497','1875000','1875000','0','1875000','1875000','input','2026-04-07 09:06:51','F32607090651');
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-04-07','F326070906511','2026-04-07','09:06:51','SIN','1875000','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-260407-0004','D','2026-04-07','09:06:51','input','PENJUALAN','F326070906511','4282292000','1875000','4284167000');
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 ('F326070918001','input','1',' MDE1 CM 20','TOKO','PM-E','E1D-ZCXE-131-0','CC MODEL BUNGA SLEP VAR CM 20 8K ','','1.210','1','100.00','1367000','0','0','15000','1368000','0','0','0','1368000','AAT','00392232','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXE-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1D-ZCXE-131-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 ('F326070918001','2026-04-07','1.210','2026-04-07','09:18:01','PLG0028498','1368000','1368000','0','1368000','1368000','input','2026-04-07 09:18:00','F32607091800');
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-04-07','F326070918001','2026-04-07','09:18:01','AAT','1368000','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-260407-0005','D','2026-04-07','09:18:01','input','PENJUALAN','F326070918001','4284167000','1368000','4285535000');
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 ('F326071042011','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZCAI-314-0','GL X RANTAI DAUN SLEP HW 8K ','','1.720','1','100.00','1978000','0','0','15000','1978000','0','0','0','1978000','AAT','00395712','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-314-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-ZCAI-314-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 ('F326071042011','2026-04-07','1.720','2026-04-07','10:42:01','PLG0028499','1978000','1978000','0','1978000','1978000','input','2026-04-07 10:42:01','F32607104201');
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-04-07','F326071042011','2026-04-07','10:42:01','AAT','1978000','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-260407-0006','D','2026-04-07','10:42:01','input','PENJUALAN','F326071042011','4285535000','1978000','4287513000');
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-00018736','X-00018736','CC MODEL SLEP VAR CM 18 8K','GR','---','E1D','BELI','BELI001','2100000','2026-04-07','2.290','1','kasir','2026-04-07 10:46:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018736','X-00018736');
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-260407-0001','F325080301351','AAT','1','BELI','BELI001','E1D', 'X-00018736', 'CC MODEL SLEP VAR CM 18 8K','2.290','2.290','100.00','2255000','2100000','917031','1140000','1','2100000','2100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.290',berat_beli_asli=berat_beli_asli+'2.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.290',berat_akhir_asli=berat_akhir_asli+'2.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0001','2026-04-07','2026-04-07','10:46:15','AAT','---','2.290','2100000','2100000','2100000','2100000','2100000','kasir','2026-04-07 10:46:15','FB-260407-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0001','SUKATI','LEMAHBANG KISMANTORO','','','','kasir','2026-04-07 10:46:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0007','K','2026-04-07','10:46:15','kasir','PEMBELIAN UMUM','FB-260407-0001','4287513000','2100000','4285413000');
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 ('F326071057521','kasir','1',' MEF3 XXX H','TOKO','PM-F','F3E-YLAA-29-0','GL XXX FLIK SLEP HW 8K ','','2.060','1','100.00','2369000','0','0','15000','2307000','0','0','0','2307000','SIN','00380611','F3E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAA-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-YLAA-29-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 ('F326071057521','2026-04-07','2.060','2026-04-07','10:57:53','PLG0028500','2307000','2307000','0','2307000','2307000','kasir','2026-04-07 10:57:52','F32607105752');
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-04-07','F326071057521','2026-04-07','10:57:53','SIN','2307000','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-260407-0008','D','2026-04-07','10:57:53','kasir','PENJUALAN','F326071057521','4285413000','2307000','4287720000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2307000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071057521' 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 ('F326071057522','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZBBE-95-0','CC X BABY PLAT LG 8K ','','0.520','1','100.00','598000','0','0','15000','598000','0','0','0','598000','SIN','00391241','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBBE-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1E-ZBBE-95-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 ('F326071057522','2026-04-07','0.520','2026-04-07','10:57:53','PLG0028501','598000','598000','0','598000','598000','kasir','2026-04-07 10:57:52','F32607105752');
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-04-07','F326071057522','2026-04-07','10:57:53','SIN','598000','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-260407-0009','D','2026-04-07','10:57:53','kasir','PENJUALAN','F326071057522','4287720000','598000','4288318000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='598000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071057522' 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 ('F326071110511','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZCBD-44-0','GL X BANGKOK ANAK C SLEP TD 38 8K','','1.950','1','100.00','2242000','0','0','15000','2243000','0','0','0','2243000','AAT','00396524','F1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBD-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F1E-ZCBD-44-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 ('F326071110511','2026-04-07','1.950','2026-04-07','11:10:51','PLG0028502','2243000','2243000','0','2243000','2243000','kasir','2026-04-07 11:10:51','F32607111051');
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-04-07','F326071110511','2026-04-07','11:10:51','AAT','2243000','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-260407-0010','D','2026-04-07','11:10:51','kasir','PENJUALAN','F326071110511','4288318000','2243000','4290561000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2243000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071110511' 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 ('F326071110512','kasir',' 1',' MDE2 X LG ','TOKO','PM-E','E2D-YEAE-142-0','CC X EROPA ANAK MATA LG 8K ','','1.050','1','100.00','1186000','0','0','15000','1187000','0','5000','0','1192000','AAT','00353914','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAE-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2D-YEAE-142-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 ('F326071110512','2026-04-07','1.050','2026-04-07','11:10:51','PLG0028503','1187000','1187000','5000','1192000','1192000','kasir','2026-04-07 11:10:51','F32607111051');
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-04-07','F326071110512','2026-04-07','11:10:51','AAT','1192000','5000');
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-260407-0011','D','2026-04-07','11:10:51','kasir','PENJUALAN','F326071110512','4290561000','1192000','4291753000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1192000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071110512' LIMIT 1;
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-00018737','X-00018737','CC X MODEL SLEP CM 14 8K','GR','---','E1D','BELI','BELI001','902000','2026-04-07','0.910','1','kasir','2026-04-07 11:36:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018737','X-00018737');
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-260407-0002','F325211031141','SIN','1','BELI','BELI001','E1D', 'X-00018737', 'CC X MODEL SLEP CM 14 8K','0.910','0.910','100.00','970000','902000','991209','1140000','1','902000','902000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0002','2026-04-07','2026-04-07','11:36:44','SIN','---','0.910','902000','902000','902000','902000','902000','kasir','2026-04-07 11:36:44','FB-260407-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0002','FITRI','SIGERENG BITING','','','','kasir','2026-04-07 11:36:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0012','K','2026-04-07','11:36:44','kasir','PEMBELIAN UMUM','FB-260407-0002','4291753000','902000','4290851000');
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-00018738','X-00018738','CC MODEL SLEP VAR CM 6 8K','GR','---','E1E','BELI','BELI001','592000','2026-04-07','0.620','1','kasir','2026-04-07 11:37:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018738','X-00018738');
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-260407-0003','F325130928371','SIN','1','BELI','BELI001','E1E', 'X-00018738', 'CC MODEL SLEP VAR CM 6 8K','0.620','0.620','100.00','645000','592000','954839','1160000','1','592000','592000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0003','2026-04-07','2026-04-07','11:37:13','SIN','---','0.620','592000','592000','592000','592000','592000','kasir','2026-04-07 11:37:13','FB-260407-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0003','DWI VERA','NADI BULUKERTO','','','','kasir','2026-04-07 11:37:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0013','K','2026-04-07','11:37:13','kasir','PEMBELIAN UMUM','FB-260407-0003','4290851000','592000','4290259000');
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-00018739','X-00018739','GW TOGE MODEL BUNNY VAR LG 8K','GR','---','B1E','BELI','BELI001','555000','2026-04-07','0.520','1','kasir','2026-04-07 11:38:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00018739','X-00018739');
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-260407-0004','F326051058311','SIN','1','BELI','BELI001','B1E', 'X-00018739', 'GW TOGE MODEL BUNNY VAR LG 8K','0.520','0.520','100.00','640000','555000','1067308','1160000','1','555000','555000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260407-0004','2026-04-07','2026-04-07','11:38:20','SIN','---','0.520','555000','555000','555000','555000','555000','kasir','2026-04-07 11:38:20','FB-260407-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0004','SYIFA','TEGALREJO','','','','kasir','2026-04-07 11:38:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0014','K','2026-04-07','11:38:20','kasir','PEMBELIAN UMUM','FB-260407-0004','4290259000','555000','4289704000');
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-00018740','X-00018740','CC PIPA MATA HT 16 8K','GR','---','E2E','BELI','BELI001','477000','2026-04-07','0.500','1','kasir','2026-04-07 11:39:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018740','X-00018740');
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-260407-0005','F325020222561','FIT','1','BELI','BELI001','E2E', 'X-00018740', 'CC PIPA MATA HT 16 8K','0.500','0.500','100.00','515000','477000','954000','1160000','1','477000','477000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0005','2026-04-07','2026-04-07','11:39:51','FIT','---','0.500','477000','477000','477000','477000','477000','kasir','2026-04-07 11:39:51','FB-260407-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0005','NISA','GEDAWUNG','','','','kasir','2026-04-07 11:39:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0015','K','2026-04-07','11:39:51','kasir','PEMBELIAN UMUM','FB-260407-0005','4289704000','477000','4289227000');
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-00018741','X-00018741','GL X FLIK HATI SLEP HW 8K','GR','---','F3E','BELI','BELI001','1825000','2026-04-07','2.020','1','kasir','2026-04-07 11:41:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018741','X-00018741');
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-260407-0006','F325291056251','SIN','1','BELI','BELI001','F3E', 'X-00018741', 'GL X FLIK HATI SLEP HW 8K','2.020','2.020','100.00','1920000','1825000','903465','1160000','1','1825000','1825000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0006','2026-04-07','2026-04-07','11:41:31','SIN','---','2.020','1825000','1825000','1825000','1825000','1825000','kasir','2026-04-07 11:41:32','FB-260407-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0006','EKA','BAKALAN PWO','','','','kasir','2026-04-07 11:41:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0016','K','2026-04-07','11:41:31','kasir','PEMBELIAN UMUM','FB-260407-0006','4289227000','1825000','4287402000');
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-00018742','X-00018742','KL X SIEMCOBRA KH 44 9K','GR','---','H2J','BELI','BELI001','3527000','2026-04-07','3.010','1','kasir','2026-04-07 11:42:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00018742','X-00018742');
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-260407-0007','F326200802121','AAT','1','BELI','BELI001','H2J', 'X-00018742', 'KL X SIEMCOBRA KH 44 9K','3.010','3.010','100.00','3853000','3527000','1171761','1260000','1','3527000','3527000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.010',berat_beli_asli=berat_beli_asli+'3.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.010',berat_akhir_asli=berat_akhir_asli+'3.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-260407-0007','2026-04-07','2026-04-07','11:42:43','AAT','---','3.010','3527000','3527000','3527000','3527000','3527000','kasir','2026-04-07 11:42:43','FB-260407-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0007','RISKI','TEGALREJO','','','','kasir','2026-04-07 11:42:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0017','K','2026-04-07','11:42:43','kasir','PEMBELIAN UMUM','FB-260407-0007','4287402000','3527000','4283875000');
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-00018743','X-00018743','GL BANGKOK MODEL DAUN SLEP PM D56 8K','GR','---','F1E','BELI','BELI001','4267000','2026-04-07','4.000','1','kasir','2026-04-07 11:44:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018743','X-00018743');
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-260407-0008','F326251100211','FIT','1','BELI','BELI001','F1E', 'X-00018743', 'GL BANGKOK MODEL DAUN SLEP PM D56 8K','4.000','4.000','100.00','4960000','4267000','1066750','1160000','1','4267000','4267000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.000',berat_beli_asli=berat_beli_asli+'4.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.000',berat_akhir_asli=berat_akhir_asli+'4.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260407-0008','2026-04-07','2026-04-07','11:44:53','FIT','---','4.000','4267000','4267000','4267000','4267000','4267000','kasir','2026-04-07 11:44:54','FB-260407-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0008','ANISA','TANJUNG BULUKERTO','','','','kasir','2026-04-07 11:44:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0018','K','2026-04-07','11:44:53','kasir','PEMBELIAN UMUM','FB-260407-0008','4283875000','4267000','4279608000');
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 ('F326071213231','kasir','1',' MEA1 5K CM','TOKO','PM-A','A1E-ZCXF-179-0','AT ANAK BONEKA CAT MATA VAR CM 8K ','','0.760','1','100.00','874000','0','0','15000','867000','0','5000','0','872000','FIT','00392434','A1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXF-179-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='A1E-ZCXF-179-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 ('F326071213231','2026-04-07','0.760','2026-04-07','12:13:24','PLG0028504','867000','867000','5000','872000','872000','kasir','2026-04-07 12:13:23','F32607121323');
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-04-07','F326071213231','2026-04-07','12:13:24','FIT','872000','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-260407-0019','D','2026-04-07','12:13:24','kasir','PENJUALAN','F326071213231','4279608000','872000','4280480000');
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-00018744','X-00018744','AT MODEL BONEKA CAT VAR UB 8K','GR','---','A1E','BELI','BELI001','215000','2026-04-07','0.350','1','kasir','2026-04-07 12:25:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00018744','X-00018744');
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-260407-0009','F324221005341','FIT','1','BELI','BELI001','A1E', 'X-00018744', 'AT MODEL BONEKA CAT VAR UB 8K','0.680','0.350','100.00','453000','215000','614286','1160000','1','215000','215000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0009','2026-04-07','2026-04-07','12:25:57','FIT','---','0.350','215000','215000','215000','215000','215000','kasir','2026-04-07 12:25:58','FB-260407-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0009','ANIK','PURWANTOO','','','','kasir','2026-04-07 12:25:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0020','K','2026-04-07','12:25:57','kasir','PEMBELIAN UMUM','FB-260407-0009','4280480000','215000','4280265000');
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-00018745','X-00018745','CC XX VELG POLOS CM 20 8K','GR','---','E1D','BELI','BELI001','927000','2026-04-07','1.010','1','kasir','2026-04-07 12:27:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018745','X-00018745');
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-260407-0010','F325231200121','FIT','1','BELI','BELI001','E1D', 'X-00018745', 'CC XX VELG POLOS CM 20 8K','1.010','1.010','100.00','1055000','927000','917822','1140000','1','927000','927000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0010','2026-04-07','2026-04-07','12:27:32','FIT','---','1.010','927000','927000','927000','927000','927000','kasir','2026-04-07 12:27:33','FB-260407-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0010','SRIYANTO','BULUKERTO','','','087810472076','kasir','2026-04-07 12:27:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0021','K','2026-04-07','12:27:32','kasir','PEMBELIAN UMUM','FB-260407-0010','4280265000','927000','4279338000');
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 ('F326071232591','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZCCX-514-0','CC WEDDING MATA CM 20 8K ','','1.050','1','100.00','1186000','0','0','15000','1185000','0','10000','0','1195000','AAT','00397168','E2D','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-514-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2D-ZCCX-514-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 ('F326071232591','2026-04-07','1.050','2026-04-07','12:32:59','PLG0028505','1185000','1185000','10000','1195000','1195000','kasir','2026-04-07 12:32:59','F32607123259');
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-04-07','F326071232591','2026-04-07','12:32:59','AAT','1195000','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-260407-0022','D','2026-04-07','12:32:59','kasir','PENJUALAN','F326071232591','4279338000','1195000','4280533000');
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 ('F326071259321','kasir','1',' TED1 SG ','TOKO','PT-D','D1TE-WJBD-105-T','LT MODEL BUNGA CLOVER SLEP SG ','OLW','0.580','1','100.00','1212000','0','0','15000','1220000','0','5000','0','1225000','FIT','T0049951','D1TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-WJBD-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='D1TE-WJBD-105-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326071259321','2026-04-07','0.580','2026-04-07','12:59:33','PLG0028506','1220000','1220000','5000','1225000','1225000','kasir','2026-04-07 12:59:32','F32607125932');
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-04-07','F326071259321','2026-04-07','12:59:33','FIT','1225000','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-260407-0023','D','2026-04-07','12:59:33','kasir','PENJUALAN','F326071259321','4280533000','1225000','4281758000');
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 ('F326070126271','kasir','1',' MDE2 X BM ','TOKO','PM-E','E2D-ZAAF-89-0','CC X MODEL MATA BM 18 8K ','','1.710','1','100.00','1932000','0','0','15000','1932000','0','0','0','1932000','AAT','00385540','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2D-ZAAF-89-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 ('F326070126271','2026-04-07','1.710','2026-04-07','13:26:28','PLG0028507','1932000','1932000','0','1932000','1932000','kasir','2026-04-07 13:26:27','F32607012627');
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-04-07','F326070126271','2026-04-07','13:26:28','AAT','1932000','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-260407-0024','D','2026-04-07','13:26:28','kasir','PENJUALAN','F326070126271','4281758000','1932000','4283690000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1932000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070126271' 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 ('F326070126272','kasir',' 1',' MDA1 UB ','TOKO','PM-A','A1D-ZDXA-51-0','AT HUGGIES KLIP BUNGA VAR UB 8K ','','0.980','1','100.00','1107000','0','0','15000','1108000','0','0','0','1108000','AAT','00397530','A1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDXA-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='A1D-ZDXA-51-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 ('F326070126272','2026-04-07','0.980','2026-04-07','13:26:28','PLG0028508','1108000','1108000','0','1108000','1108000','kasir','2026-04-07 13:26:27','F32607012627');
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-04-07','F326070126272','2026-04-07','13:26:28','AAT','1108000','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-260407-0025','D','2026-04-07','13:26:28','kasir','PENJUALAN','F326070126272','4283690000','1108000','4284798000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1108000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070126272' 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 ('F326070139451','kasir','1',' MEE2 X JP ','TOKO','PM-E','E2E-YLAG-131-0','CC X MODEL MATA ANAK JP 8K ','','0.730','1','100.00','839000','0','0','15000','840000','0','0','0','840000','FIT','00381485','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLAG-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E2E-YLAG-131-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 ('F326070139451','2026-04-07','0.730','2026-04-07','13:39:45','PLG0028509','840000','840000','0','840000','840000','kasir','2026-04-07 13:39:45','F32607013945');
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-04-07','F326070139451','2026-04-07','13:39:45','FIT','840000','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-260407-0026','D','2026-04-07','13:39:45','kasir','PENJUALAN','F326070139451','4284798000','840000','4285638000');
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 ('F326070152511','kasir','1',' MFE1 X UB ','TOKO','PM-E','E1F-YFBH-183-0','CC X BOLA PASIR UB 18 8K ','','1.460','1','100.00','1708000','0','0','15000','1708000','0','0','0','1708000','SIN','00358891','E1F','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YFBH-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='E1F-YFBH-183-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 ('F326070152511','2026-04-07','1.460','2026-04-07','13:52:52','PLG0028510','1708000','1708000','0','1708000','1708000','kasir','2026-04-07 13:52:51','F32607015251');
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-04-07','F326070152511','2026-04-07','13:52:52','SIN','1708000','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-260407-0027','D','2026-04-07','13:52:52','kasir','PENJUALAN','F326070152511','4285638000','1708000','4287346000');
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-00018746','X-00018746','CC X ANAK BONEKA CAT MATA VAR LG 8K','GR','---','E2E','BELI','BELI001','560000','2026-04-07','0.530','1','kasir','2026-04-07 13:55:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018746','X-00018746');
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-260407-0011','F326241039211','FIT','1','BELI','BELI001','E2E', 'X-00018746', 'CC X ANAK BONEKA CAT MATA VAR LG 8K','0.530','0.530','100.00','610000','560000','1056604','1160000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0011','2026-04-07','2026-04-07','13:55:54','FIT','---','0.530','560000','560000','560000','560000','560000','kasir','2026-04-07 13:55:55','FB-260407-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0011','KAYLA','BUGELAN KISMANTORO','','','','kasir','2026-04-07 13:55:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0028','K','2026-04-07','13:55:54','kasir','PEMBELIAN UMUM','FB-260407-0011','4287346000','560000','4286786000');
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-00018747','X-00018747','KL RANTAI HOLLOW ANAK UB 34 8K','GR','---','H1E','BELI','BELI001','640000','2026-04-07','0.650','1','kasir','2026-04-07 13:56:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018747','X-00018747');
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-260407-0012','F326050957531','FIT','1','BELI','BELI001','H1E', 'X-00018747', 'KL RANTAI HOLLOW ANAK UB 34 8K','0.650','0.650','100.00','755000','640000','984615','1160000','1','640000','640000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260407-0012','2026-04-07','2026-04-07','13:56:26','FIT','---','0.650','640000','640000','640000','640000','640000','kasir','2026-04-07 13:56:27','FB-260407-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0012','DEWI','JERUK BANDAR PCT','','','081260844303','kasir','2026-04-07 13:56:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0029','K','2026-04-07','13:56:26','kasir','PEMBELIAN UMUM','FB-260407-0012','4286786000','640000','4286146000');
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-00018748','X-00018748','KL X SANTA ANAK UB 32CM','GR','---','H2I','BELI','BELI001','1665000','2026-04-07','1.950','1','kasir','2026-04-07 13:59:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00018748','X-00018748');
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-260407-0013','F322101136061','FIT','1','BELI','BELI001','H2I', 'X-00018748', 'KL X SANTA ANAK UB 32CM','1.950','1.950','100.00','875000','1665000','853846','1230000','1','1665000','1665000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-07' 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-260407-0013','2026-04-07','2026-04-07','13:59:13','FIT','---','1.950','1665000','1665000','1665000','1665000','1665000','kasir','2026-04-07 13:59:14','FB-260407-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0013','BU MULYATI','NGAGLIK BULUKERTO','','','','kasir','2026-04-07 13:59:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0030','K','2026-04-07','13:59:13','kasir','PEMBELIAN UMUM','FB-260407-0013','4286146000','1665000','4284481000');
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-00018749','X-00018749','CC BABY PLAT LG','GR','---','E1F','BELI','BELI001','375000','2026-04-07','0.510','1','kasir','2026-04-07 13:59:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00018749','X-00018749');
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-260407-0014','F322101136062','FIT','2','BELI','BELI001','E1F', 'X-00018749', 'CC BABY PLAT LG','0.510','0.510','100.00','215000','375000','735294','1170000','1','375000','375000','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-04-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-260407-0014','2026-04-07','2026-04-07','13:59:13','FIT','---','0.510','375000','375000','375000','375000','375000','kasir','2026-04-07 13:59:14','FB-260407-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260407-0014','BU MULYATI','NGAGLIK BULUKERTO','','','','kasir','2026-04-07 13:59:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-07' 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-260407-0031','K','2026-04-07','13:59:13','kasir','PEMBELIAN UMUM','FB-260407-0014','4284481000','375000','4284106000');
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 ('F326070224231','input','1',' MEF2 X HW ','TOKO','PM-F','F2E-YLBI-125-0','GL X OVAL MATA HW 56 8K ','','3.180','1','100.00','3657000','0','0','15000','3658000','0','0','0','3658000','AAT','00383277','F2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLBI-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F2E-YLBI-125-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 ('F326070224231','2026-04-07','3.180','2026-04-07','14:24:23','PLG0028511','3658000','3658000','0','3658000','3658000','input','2026-04-07 14:24:23','F32607022423');
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-04-07','F326070224231','2026-04-07','14:24:23','AAT','3658000','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-260407-0032','D','2026-04-07','14:24:23','input','PENJUALAN','F326070224231','4284106000','3658000','4287764000');
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 ('F326070252011','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-YIBD-151-0','GL X OVAL C SLEP UB 60 8K ','','6.850','1','100.00','7877000','0','0','15000','7877000','0','0','0','7877000','AAT','00370572','F1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIBD-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.850',berat_jual_asli=berat_jual_asli+'6.850',stock_jual='1',berat_akhir=berat_akhir-'6.850',berat_akhir_asli=berat_akhir_asli-'6.850',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F1E-YIBD-151-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 ('F326070252011','2026-04-07','6.850','2026-04-07','14:52:02','PLG0028512','7877000','7877000','0','7877000','7877000','kasir','2026-04-07 14:52:01','F32607025201');
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-04-07','F326070252011','2026-04-07','14:52:02','AAT','7877000','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-260407-0033','D','2026-04-07','14:52:02','kasir','PENJUALAN','F326070252011','4287764000','7877000','4295641000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7877000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070252011' 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 ('F326070252012','kasir',' 1',' MEF3 XXX K','TOKO','PM-F','F3E-YLAA-37-0','GL XXX RANTAI HOLLOW KH 8K ','','2.020','1','100.00','2323000','0','0','15000','2263000','0','0','0','2263000','AAT','00380619','F3E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='F3E-YLAA-37-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 ('F326070252012','2026-04-07','2.020','2026-04-07','14:52:02','PLG0028513','2263000','2263000','0','2263000','2263000','kasir','2026-04-07 14:52:01','F32607025201');
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-04-07','F326070252012','2026-04-07','14:52:02','AAT','2263000','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-260407-0034','D','2026-04-07','14:52:02','kasir','PENJUALAN','F326070252012','4295641000','2263000','4297904000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2263000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070252012' 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 ('F326070300271','kasir','1',' MDA1 UB ','TOKO','PM-A','A1D-ZDXA-50-0','AT HUGGIES KLIP BINTANG VAR UB 8K ','','1.000','1','100.00','1130000','0','0','15000','1130000','0','0','0','1130000','SIN','00397529','A1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDXA-50-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-04-07' AND kode_barang='A1D-ZDXA-50-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 ('F326070300271','2026-04-07','1.000','2026-04-07','15:00:27','PLG0028514','1130000','1130000','0','1130000','1130000','kasir','2026-04-07 15:00:27','F32607030027');
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-04-07','F326070300271','2026-04-07','15:00:27','SIN','1130000','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-260407-0035','D','2026-04-07','15:00:27','kasir','PENJUALAN','F326070300271','4297904000','1130000','4299034000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1130000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070300271' 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 ('F326070300272','kasir',' 1',' MED2E X YT','TOKO','PM-D','D2E-YKBD-42-0','LT X MODEL MATA YT 8K ','','0.620','1','100.00','713000','0','0','15000','713000','0','0','0','713000','SIN','00378451','D2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-04-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YKBD-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-04-07' AND kode_barang='D2E-YKBD-42-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 ('F326070300272','2026-04-07','0.620','2026-04-07','15:00:27','PLG0028515','713000','713000','0','713000','713000','kasir','2026-04-07 15:00:27','F32607030027');
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-04-07','F326070300272','2026-04-07','15:00:27','SIN','713000','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-260407-0036','D','2026-04-07','15:00:27','kasir','PENJUALAN','F326070300272','4299034000','713000','4299747000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070300272' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260407-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260407-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070126271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070126271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070126271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070126272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070126272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070126272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070139451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070139451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070152511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070152511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070152511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070224231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070224231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070224231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070252011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070252011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070252011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070252012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070252012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070252012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070300271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070300271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070300271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070300272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070300272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070300272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070901031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070901031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070901031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070901032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070901032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070901032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070906511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070906511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070906511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070918001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070918001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070918001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071042011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071042011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071042011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071057521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071057521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071057521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071057522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071057522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071057522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071110511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071110511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071110511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071110512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071110512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071110512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071213231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071213231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071213231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071232591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071232591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071232591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071259321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071259321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071259321';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-07';
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-04-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-07' 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-260408-0001','D','2026-04-08','15:32:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','4299747000','4299747000');
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-260408-0001','D','2026-04-08','15:32:14','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-260408-0001','D','2026-04-08','15:32:14','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-260408-0001','D','2026-04-08','15:32:14','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-08';