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-20260916-0001','1','B1G-ZIAX-200-0','1','0.310','0.310','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZIAX-200-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZIAX-200-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-09-16 07:58:55' WHERE kode_barang='B1G-ZIAX-200-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZIAX-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-09-16 07:58:55','TOKO','PM-B','B1G','B1G-ZIAX-200-0','1','0.310','0.310','1','0.310','0.310','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-ZIAX-200-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZIAX-200-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260916-0001','2026-09-16','07:58','0.310','admpindah','2026-09-16 07:58:55');
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-20260916-0001','1','D2D-ZHXH-83-0','1','1.070','1.070','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-ZHXH-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-ZHXH-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-09-16 07:59:14' WHERE kode_barang='D2D-ZHXH-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-ZHXH-83-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-09-16 07:59:14','TOKO','PM-D','D2D','D2D-ZHXH-83-0','1','1.070','1.070','1','1.070','1.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2D-ZHXH-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-ZHXH-83-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260916-0001','2026-09-16','07:59','1.070','admpindah','2026-09-16 07:59:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260916-0001','1','E1F-ZIAE-270-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-270-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-270-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-270-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-270-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-270-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-270-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-270-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-20260916-0001','1','E1F-ZIAE-271-0','1','0.310','0.310','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-271-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-271-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-271-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-271-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-271-0','1','0.310','0.310','1','0.310','0.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-271-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-271-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-20260916-0001','1','E1F-ZIAE-272-0','1','0.330','0.330','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-272-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-272-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-272-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-272-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-272-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-272-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-272-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-20260916-0001','1','E1F-ZIAE-274-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-274-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-274-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-274-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-274-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-274-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-274-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-274-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-20260916-0001','1','E1F-ZIAE-275-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-275-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-275-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-275-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-275-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-275-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-275-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-275-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-20260916-0001','1','E1F-ZIAE-276-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-276-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-276-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-276-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-276-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-276-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-276-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-276-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-20260916-0001','1','E1F-ZIAE-277-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-277-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-277-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-277-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-277-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-277-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-277-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-277-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-20260916-0001','1','E1F-ZIAE-279-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIAE-279-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-279-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1F-ZIAE-279-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIAE-279-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-09-16 07:59:29','TOKO','PM-E','E1F','E1F-ZIAE-279-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZIAE-279-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIAE-279-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-20260916-0001','1','E2F-ZIAE-281-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZIAE-281-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-281-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2F-ZIAE-281-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZIAE-281-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-09-16 07:59:29','TOKO','PM-E','E2F','E2F-ZIAE-281-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZIAE-281-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-281-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-20260916-0001','1','E2F-ZIAE-282-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZIAE-282-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-282-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2F-ZIAE-282-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZIAE-282-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-09-16 07:59:29','TOKO','PM-E','E2F','E2F-ZIAE-282-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZIAE-282-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-282-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-20260916-0001','1','E2F-ZIAE-283-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZIAE-283-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-283-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2F-ZIAE-283-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZIAE-283-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-09-16 07:59:29','TOKO','PM-E','E2F','E2F-ZIAE-283-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZIAE-283-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZIAE-283-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-20260916-0001','1','E1E-ZIAE-284-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIAE-284-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIAE-284-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1E-ZIAE-284-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIAE-284-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-09-16 07:59:29','TOKO','PM-E','E1E','E1E-ZIAE-284-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZIAE-284-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIAE-284-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-20260916-0001','1','E1E-ZIAE-285-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIAE-285-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIAE-285-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E1E-ZIAE-285-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIAE-285-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-09-16 07:59:29','TOKO','PM-E','E1E','E1E-ZIAE-285-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZIAE-285-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIAE-285-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-20260916-0001','1','E2E-ZIAE-288-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIAE-288-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-288-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2E-ZIAE-288-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIAE-288-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-09-16 07:59:29','TOKO','PM-E','E2E','E2E-ZIAE-288-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZIAE-288-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-288-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-20260916-0001','1','E2E-ZIAE-289-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIAE-289-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-289-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2E-ZIAE-289-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIAE-289-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-09-16 07:59:29','TOKO','PM-E','E2E','E2E-ZIAE-289-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZIAE-289-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-289-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-20260916-0001','1','E2E-ZIAE-291-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIAE-291-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-291-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2E-ZIAE-291-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIAE-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-09-16 07:59:29','TOKO','PM-E','E2E','E2E-ZIAE-291-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZIAE-291-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-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-20260916-0001','1','E2E-ZIAE-292-0','1','0.510','0.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIAE-292-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-292-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2E-ZIAE-292-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIAE-292-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-09-16 07:59:29','TOKO','PM-E','E2E','E2E-ZIAE-292-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZIAE-292-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIAE-292-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-20260916-0001','1','E2D-ZIAE-294-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIAE-294-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIAE-294-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2D-ZIAE-294-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIAE-294-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-09-16 07:59:29','TOKO','PM-E','E2D','E2D-ZIAE-294-0','1','1.530','1.530','1','1.530','1.530','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-ZIAE-294-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIAE-294-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-20260916-0001','1','E2D-ZIAE-295-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIAE-295-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIAE-295-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-16 07:59:29' WHERE kode_barang='E2D-ZIAE-295-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIAE-295-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-09-16 07:59:29','TOKO','PM-E','E2D','E2D-ZIAE-295-0','1','1.530','1.530','1','1.530','1.530','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-ZIAE-295-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIAE-295-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260916-0001','2026-09-16','07:59','10.150','admpindah','2026-09-16 07:59:29');
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-20260916-0001','1','F1E-ZIAE-268-0','1','0.740','0.740','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZIAE-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIAE-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-16 07:59:51' WHERE kode_barang='F1E-ZIAE-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIAE-268-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-16 07:59:51','TOKO','PM-F','F1E','F1E-ZIAE-268-0','1','0.740','0.740','1','0.740','0.740','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-ZIAE-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIAE-268-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260916-0001','2026-09-16','07:59','0.740','admpindah','2026-09-16 07:59:50');
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-20260916-0001','1','S1G-ZIAD-1-0','1','0.200','0.200','TOKO','PMBK-S','TOKO','PM-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZIAD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZIAD-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-S',tgl_last_beli='2026-09-16 08:00:07' WHERE kode_barang='S1G-ZIAD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZIAD-1-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-09-16 08:00:07','TOKO','PM-S','S1G','S1G-ZIAD-1-0','1','0.200','0.200','1','0.200','0.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' 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='S1G-ZIAD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZIAD-1-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260916-0001','2026-09-16','07:59','0.200','admpindah','2026-09-16 08:00:06');
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 ('F326160834571','input','1',' MEH1 LG ','TOKO','PM-H','H1E-ZIAD-161-0','KL TRIXIE PITA MATA VAR LG 8K ','','0.970','1','100.00','1006000','0','0','15000','1006000','0','0','0','1006000','SIN','00423521','H1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAD-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='H1E-ZIAD-161-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F326160834571','2026-09-16','0.970','2026-09-16','08:34:58','PLG0031370','1006000','1006000','0','1006000','1006000','input','2026-09-16 08:34:57','F32616083457');
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-09-16','F326160834571','2026-09-16','08:34:58','SIN','1006000','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-260916-0002','D','2026-09-16','08:34:58','input','PENJUALAN','F326160834571','7425257000','1006000','7426263000');
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 ('F326160930391','input','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZIAE-277-0','CC BUNGA CLOVER SLEP KH 16 8K ','','0.380','1','100.00','405000','0','0','15000','402000','0','0','0','402000','SIN','00423813','E1F','0','0','-','1','1067000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAE-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E1F-ZIAE-277-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 ('F326160930391','2026-09-16','0.380','2026-09-16','09:30:40','PLG0031371','402000','402000','0','402000','402000','input','2026-09-16 09:30:39','F32616093039');
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-09-16','F326160930391','2026-09-16','09:30:40','SIN','402000','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-260916-0003','D','2026-09-16','09:30:40','input','PENJUALAN','F326160930391','7426263000','402000','7426665000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='402000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160930391' 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 ('F326160930392','input',' 1',' MEF3E HW ','TOKO','PM-F','F3E-ZHBA-226-0','GL CASANO SPECTRA VAR SLEP HW 8K ','','2.790','1','100.00','2893000','0','0','15000','2893000','0','0','0','2893000','SIN','00419805','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBA-226-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZHBA-226-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 ('F326160930392','2026-09-16','2.790','2026-09-16','09:30:40','PLG0031372','2893000','2893000','0','2893000','2893000','input','2026-09-16 09:30:39','F32616093039');
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-09-16','F326160930392','2026-09-16','09:30:40','SIN','2893000','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-260916-0004','D','2026-09-16','09:30:40','input','PENJUALAN','F326160930392','7426665000','2893000','7429558000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2893000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160930392' 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 ('F326160940591','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZIXH-102-0','GL X CAPELLA SLEP HW 8K ','','1.860','1','100.00','1929000','0','0','15000','1930000','0','0','0','1930000','AAT','00422369','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXH-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZIXH-102-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 ('F326160940591','2026-09-16','1.860','2026-09-16','09:41:00','PLG0031373','1930000','1930000','0','1930000','1930000','input','2026-09-16 09:40:59','F32616094059');
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-09-16','F326160940591','2026-09-16','09:41:00','AAT','1930000','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-260916-0005','D','2026-09-16','09:41:00','input','PENJUALAN','F326160940591','7429558000','1930000','7431488000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1930000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160940591' 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 ('F326160940592','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZIXI-241-0','GL X CASTELI CAPELLA SLEP HW 8K ','','2.230','1','100.00','2313000','0','0','15000','2313000','0','0','0','2313000','AAT','00422779','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXI-241-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZIXI-241-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 ('F326160940592','2026-09-16','2.230','2026-09-16','09:41:00','PLG0031374','2313000','2313000','0','2313000','2313000','input','2026-09-16 09:40:59','F32616094059');
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-09-16','F326160940592','2026-09-16','09:41:00','AAT','2313000','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-260916-0006','D','2026-09-16','09:41:00','input','PENJUALAN','F326160940592','7431488000','2313000','7433801000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2313000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160940592' 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 ('F326160940593','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZIXI-112-0','CC WEDDING MATA CM 12 8K ','','0.800','1','100.00','814000','0','0','15000','815000','0','10000','0','825000','AAT','00422650','E2D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXI-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E2D-ZIXI-112-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 ('F326160940593','2026-09-16','0.800','2026-09-16','09:41:00','PLG0031375','815000','815000','10000','825000','825000','input','2026-09-16 09:40:59','F32616094059');
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-09-16','F326160940593','2026-09-16','09:41:00','AAT','825000','10000');
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-260916-0007','D','2026-09-16','09:41:00','input','PENJUALAN','F326160940593','7433801000','825000','7434626000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='825000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160940593' 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 ('F326161011101','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-ZGXI-305-0','CC X BANGKOK POLOS OR 14 8K ','','0.960','1','100.00','976000','0','0','15000','976000','0','0','0','976000','SIN','00413024','E1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXI-305-0' 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-09-16' AND kode_barang='E1D-ZGXI-305-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 ('F326161011101','2026-09-16','0.960','2026-09-16','10:11:10','PLG0031376','976000','976000','0','976000','976000','input','2026-09-16 10:11:10','F32616101110');
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-09-16','F326161011101','2026-09-16','10:11:10','SIN','976000','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-260916-0008','D','2026-09-16','10:11:10','input','PENJUALAN','F326161011101','7434626000','976000','7435602000');
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 ('F326161036361','input','1',' MEF3E X HW','TOKO','PM-F','F3E-YFBH-85-0','GL X RANTAI FLIK VAR HW 8K ','','1.900','1','100.00','1970000','0','0','15000','1970000','0','0','0','1970000','FIT','00358793','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBH-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-YFBH-85-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 ('F326161036361','2026-09-16','1.900','2026-09-16','10:36:37','PLG0031377','1970000','1970000','0','1970000','1970000','input','2026-09-16 10:36:36','F32616103636');
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-09-16','F326161036361','2026-09-16','10:36:37','FIT','1970000','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-260916-0009','D','2026-09-16','10:36:37','input','PENJUALAN','F326161036361','7435602000','1970000','7437572000');
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 ('F326161039591','input','1',' MDE2 CM 22','TOKO','PM-E','E2D-ZDXF-207-0','CC COR WEDING MODEL MATA 22 CM 8K ','','0.970','1','100.00','987000','0','0','15000','987000','0','0','0','987000','SIN','00398175','E2D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDXF-207-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E2D-ZDXF-207-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 ('F326161039591','2026-09-16','0.970','2026-09-16','10:40:00','PLG0031378','987000','987000','0','987000','987000','input','2026-09-16 10:39:59','F32616103959');
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-09-16','F326161039591','2026-09-16','10:40:00','SIN','987000','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-260916-0010','D','2026-09-16','10:40:00','input','PENJUALAN','F326161039591','7437572000','987000','7438559000');
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 ('F326161122291','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZIXH-134-0','KL X MILANO UB 42 8K ','','2.030','1','100.00','2105000','0','0','15000','2105000','0','0','0','2105000','SIN','00422401','H1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXH-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='H1E-ZIXH-134-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F326161122291','2026-09-16','2.030','2026-09-16','11:22:30','PLG0031379','2105000','2105000','0','2105000','2105000','input','2026-09-16 11:22:29','F32616112229');
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-09-16','F326161122291','2026-09-16','11:22:30','SIN','2105000','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-260916-0011','D','2026-09-16','11:22:30','input','PENJUALAN','F326161122291','7438559000','2105000','7440664000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2105000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161122291' 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 ('F326161122292','input',' 1',' MDA1 HW ','TOKO','PM-A','A1D-ZIXC-26-0','AT MODEL BUNGA CLOVER SLEP HW 8K ','','0.880','1','100.00','895000','0','0','15000','895000','0','0','0','895000','SIN','00421916','A1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIXC-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='A1D-ZIXC-26-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 ('F326161122292','2026-09-16','0.880','2026-09-16','11:22:30','PLG0031380','895000','895000','0','895000','895000','input','2026-09-16 11:22:29','F32616112229');
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-09-16','F326161122292','2026-09-16','11:22:30','SIN','895000','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-260916-0012','D','2026-09-16','11:22:30','input','PENJUALAN','F326161122292','7440664000','895000','7441559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161122292' 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 ('F326161122293','input',' 1',' MEE1 CM 14','TOKO','PM-E','E1E-ZGXA-312-0','CC MODEL SLEP HT 12 8K ','','0.770','1','100.00','799000','0','0','15000','800000','0','0','0','800000','SIN','00411836','E1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-312-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E1E-ZGXA-312-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 ('F326161122293','2026-09-16','0.770','2026-09-16','11:22:30','PLG0031381','800000','800000','0','800000','800000','input','2026-09-16 11:22:29','F32616112229');
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-09-16','F326161122293','2026-09-16','11:22:30','SIN','800000','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-260916-0013','D','2026-09-16','11:22:30','input','PENJUALAN','F326161122293','7441559000','800000','7442359000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161122293' 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-00020219','X-00020219','AT COR MODEL ITALY BM 8K','GR','---','A1E','BELI','BELI001','532000','2026-09-16','0.600','1','kasir','2026-09-16 12:19:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020219','X-00020219');
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-260916-0001','F326130219501','SIN','1','BELI','BELI001','A1E', 'X-00020219', 'AT COR MODEL ITALY BM 8K','0.600','0.600','100.00','693000','532000','886667','1047000','1','532000','532000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0001','2026-09-16','2026-09-16','12:19:58','SIN','---','0.600','532000','532000','532000','532000','532000','kasir','2026-09-16 12:19:58','FB-260916-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0001','BINTANG','KISMANTORO','','','082327837812','kasir','2026-09-16 12:19:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0014','K','2026-09-16','12:19:58','kasir','PEMBELIAN UMUM','FB-260916-0001','7442359000','532000','7441827000');
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 ('F326161248441','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZFCX-196-0','GL X SANTA SPECTRA VAR HW 8K ','','1.620','1','100.00','1680000','0','0','15000','1680000','0','0','0','1680000','AAT','00411403','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZFCX-196-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 ('F326161248441','2026-09-16','1.620','2026-09-16','12:48:44','PLG0031382','1680000','1680000','0','1680000','1680000','kasir','2026-09-16 12:48:44','F32616124844');
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-09-16','F326161248441','2026-09-16','12:48:44','AAT','1680000','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-260916-0015','D','2026-09-16','12:48:44','kasir','PENJUALAN','F326161248441','7441827000','1680000','7443507000');
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 ('F326161249071','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZGXD-24-0','CC WEDDING MATA CM 14 8K ','','1.530','1','100.00','1556000','0','0','15000','1558000','0','10000','0','1568000','AAT','00412278','E2D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXD-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E2D-ZGXD-24-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 ('F326161249071','2026-09-16','1.530','2026-09-16','12:49:08','PLG0031383','1558000','1558000','10000','1568000','1568000','kasir','2026-09-16 12:49:07','F32616124907');
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-09-16','F326161249071','2026-09-16','12:49:08','AAT','1568000','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-260916-0016','D','2026-09-16','12:49:08','kasir','PENJUALAN','F326161249071','7443507000','1568000','7445075000');
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-00020220','X-00020220','AT ANAK BONEKA CAT MATA VAR CM 8K','GR','---','A1D','BELI','BELI001','1058000','2026-09-16','1.120','1','kasir','2026-09-16 12:52:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020220','X-00020220');
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-260916-0002','F326170117351','FIT','1','BELI','BELI001','A1D', 'X-00020220', 'AT ANAK BONEKA CAT MATA VAR CM 8K','1.120','1.120','100.00','1305000','1058000','944643','1027000','1','1058000','1058000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.120',berat_beli_asli=berat_beli_asli+'1.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260916-0002','2026-09-16','2026-09-16','12:52:59','FIT','---','1.120','1058000','1058000','1058000','1058000','1058000','kasir','2026-09-16 12:52:59','FB-260916-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0002','ZAFIRA','JANGGLE KISMANTORO','','','','kasir','2026-09-16 12:52:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0017','K','2026-09-16','12:52:59','kasir','PEMBELIAN UMUM','FB-260916-0002','7445075000','1058000','7444017000');
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-00020221','X-00020221','KL POLOS 9K','GR','---','H2I','BELI','BELI001','1530000','2026-09-16','2.010','1','kasir','2026-09-16 12:54:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020221','X-00020221');
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-260916-0003','F323281033552','SIN','1','BELI','BELI001','H2I', 'X-00020221', 'KL POLOS 9K','2.070','2.010','100.00','1090000','1530000','761194','1117000','1','1530000','1530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0003','2026-09-16','2026-09-16','12:54:30','SIN','---','2.010','1530000','1530000','1530000','1530000','1530000','kasir','2026-09-16 12:54:31','FB-260916-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0003','ANNA','BANGSRI','','','','kasir','2026-09-16 12:54:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0018','K','2026-09-16','12:54:30','kasir','PEMBELIAN UMUM','FB-260916-0003','7444017000','1530000','7442487000');
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-00020222','X-00020222','CC X MODEL MATA CM 16 8K','GR','---','E2E','BELI','BELI001','612000','2026-09-16','0.630','1','kasir','2026-09-16 12:54:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020222','X-00020222');
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-260916-0004','F326050111301','SIN','1','BELI','BELI001','E2E', 'X-00020222', 'CC X MODEL MATA CM 16 8K','0.630','0.630','100.00','668000','612000','971429','1047000','1','612000','612000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0004','2026-09-16','2026-09-16','12:54:48','SIN','---','0.630','612000','612000','612000','612000','612000','kasir','2026-09-16 12:54:48','FB-260916-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0004','SELFI','PURWANTORO','','','087754435128','kasir','2026-09-16 12:54:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0019','K','2026-09-16','12:54:48','kasir','PEMBELIAN UMUM','FB-260916-0004','7442487000','612000','7441875000');
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 ('F326160119051','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZEBE-140-0','GL X SHOGUN SLEP UB 56 8K ','','3.050','1','100.00','3163000','0','0','15000','3163000','0','0','0','3163000','SIN','00404839','F1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBE-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F1E-ZEBE-140-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 ('F326160119051','2026-09-16','3.050','2026-09-16','13:19:06','PLG0031384','3163000','3163000','0','3163000','3163000','kasir','2026-09-16 13:19:05','F32616011905');
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-09-16','F326160119051','2026-09-16','13:19:06','SIN','3163000','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-260916-0020','D','2026-09-16','13:19:06','kasir','PENJUALAN','F326160119051','7441875000','3163000','7445038000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3163000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160119051' 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 ('F326160119052','kasir',' 1',' MEF3E X HW','TOKO','PM-F','F3E-YFAD-305-0','GL X FLIK HATI VAR HW 8K','','1.730','1','100.00','1794000','0','0','15000','1794000','0','0','0','1794000','SIN','00357585','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFAD-305-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-YFAD-305-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 ('F326160119052','2026-09-16','1.730','2026-09-16','13:19:06','PLG0031385','1794000','1794000','0','1794000','1794000','kasir','2026-09-16 13:19:05','F32616011905');
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-09-16','F326160119052','2026-09-16','13:19:06','SIN','1794000','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-260916-0021','D','2026-09-16','13:19:06','kasir','PENJUALAN','F326160119052','7445038000','1794000','7446832000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1794000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160119052' 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 ('F326160120551','kasir','1',' MDA1D LG ','TOKO','PM-A','A1D-YLXC-231-0','AT GYPSY HATI VAR LG 8K ','','0.970','1','100.00','987000','0','0','15000','988000','0','0','0','988000','AAT','00379547','A1D','0','0','-','0','1027000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLXC-231-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='A1D-YLXC-231-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 ('F326160120551','2026-09-16','0.970','2026-09-16','13:20:55','PLG0031386','988000','988000','0','988000','988000','kasir','2026-09-16 13:20:55','F32616012055');
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-09-16','F326160120551','2026-09-16','13:20:55','AAT','988000','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-260916-0022','D','2026-09-16','13:20:55','kasir','PENJUALAN','F326160120551','7446832000','988000','7447820000');
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-00020223','X-00020223','AT KLIP BONEKA CAT MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','865000','2026-09-16','0.900','1','kasir','2026-09-16 13:28:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020223','X-00020223');
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-260916-0005','F326101103421','FIT','1','BELI','BELI001','A1E', 'X-00020223', 'AT KLIP BONEKA CAT MATA VAR LG 8K','0.900','0.900','100.00','1008000','865000','961111','1047000','1','865000','865000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0005','2026-09-16','2026-09-16','13:28:30','FIT','---','0.900','865000','865000','865000','865000','865000','kasir','2026-09-16 13:28:30','FB-260916-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0005','DWI','PURWANTORO','','','082324636397','kasir','2026-09-16 13:28:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0023','K','2026-09-16','13:28:30','kasir','PEMBELIAN UMUM','FB-260916-0005','7447820000','865000','7446955000');
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-00020224','X-00020224','GL X TIFF BONEKA ANAK CAT VAR UB 8K','GR','---','F3E','BELI','BELI001','2162000','2026-09-16','2.370','1','kasir','2026-09-16 14:01:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020224','X-00020224');
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-260916-0006','F326150219171','AAT','1','BELI','BELI001','F3E', 'X-00020224', 'GL X TIFF BONEKA ANAK CAT VAR UB 8K','2.370','2.370','100.00','2458000','2162000','912236','1047000','1','2162000','2162000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.370',berat_beli_asli=berat_beli_asli+'2.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.370',berat_akhir_asli=berat_akhir_asli+'2.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0006','2026-09-16','2026-09-16','14:01:14','AAT','---','2.370','2162000','2162000','2162000','2162000','2162000','kasir','2026-09-16 14:01:14','FB-260916-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0006','GITA','JOHO BULUKERTO','','','','kasir','2026-09-16 14:01:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0024','K','2026-09-16','14:01:14','kasir','PEMBELIAN UMUM','FB-260916-0006','7446955000','2162000','7444793000');
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 ('F326160203381','kasir','1',' MEF1 KH ','TOKO','PM-F','F1E-ZIAE-268-0','GL CHOKER MRICAN ARESO VAR KH 8K ','','0.740','1','100.00','775000','0','0','15000','767000','0','0','0','767000','SIN','00423803','F1E','0','0','-','1','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAE-268-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F1E-ZIAE-268-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 ('F326160203381','2026-09-16','0.740','2026-09-16','14:03:38','PLG0031387','767000','767000','0','767000','767000','kasir','2026-09-16 14:03:38','F32616020338');
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-09-16','F326160203381','2026-09-16','14:03:38','SIN','767000','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-260916-0025','D','2026-09-16','14:03:38','kasir','PENJUALAN','F326160203381','7444793000','767000','7445560000');
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 ('F326160244191','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZIXH-105-0','GL X RANTAI HOLLOW KUPU SLEP HW 8K ','','1.250','1','100.00','1296000','0','0','15000','1296000','0','0','0','1296000','SIN','00422372','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXH-105-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZIXH-105-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 ('F326160244191','2026-09-16','1.250','2026-09-16','14:44:20','PLG0031388','1296000','1296000','0','1296000','1296000','input','2026-09-16 14:44:19','F32616024419');
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-09-16','F326160244191','2026-09-16','14:44:20','SIN','1296000','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-260916-0026','D','2026-09-16','14:44:20','input','PENJUALAN','F326160244191','7445560000','1296000','7446856000');
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-00020225','X-00020225','GL X PITTON SLEP HW 8K','GR','---','F3E','BELI','BELI001','1372000','2026-09-16','1.500','1','kasir','2026-09-16 14:45:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020225','X-00020225');
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-260916-0007','F326070256131','SIN','1','BELI','BELI001','F3E', 'X-00020225', 'GL X PITTON SLEP HW 8K','1.500','1.500','100.00','1560000','1372000','914667','1047000','1','1372000','1372000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' 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-260916-0007','2026-09-16','2026-09-16','14:45:36','SIN','---','1.500','1372000','1372000','1372000','1372000','1372000','kasir','2026-09-16 14:45:36','FB-260916-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0007','ITA','TEGALREJO','','','','kasir','2026-09-16 14:45:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0027','K','2026-09-16','14:45:36','kasir','PEMBELIAN UMUM','FB-260916-0007','7446856000','1372000','7445484000');
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 ('F326160257161','kasir','1',' MCE0 X NW ','TOKO','PM-E','E0C-ZDBI-126-0','CC X POLOS NW 18 8K ','','1.450','1','100.00','1446000','0','0','15000','1446000','0','0','0','1446000','SIN','00401772','E0C','0','0','-','0','997000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0C-ZDBI-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='E0C-ZDBI-126-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 ('F326160257161','2026-09-16','1.450','2026-09-16','14:57:17','PLG0031389','1446000','1446000','0','1446000','1446000','kasir','2026-09-16 14:57:16','F32616025716');
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-09-16','F326160257161','2026-09-16','14:57:17','SIN','1446000','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-260916-0028','D','2026-09-16','14:57:17','kasir','PENJUALAN','F326160257161','7445484000','1446000','7446930000');
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 ('F326160309111','kasir','1',' MEF1X 10K ','TOKO','PM-F','F1E-ZCAI-743-0','GL X ANAK BANGKOK HOLLOW LASER PM D38 8K ','','2.000','1','100.00','2074000','0','0','15000','2075000','0','10000','0','2085000','FIT','00396145','F1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAI-743-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F1E-ZCAI-743-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 ('F326160309111','2026-09-16','2.000','2026-09-16','15:09:11','PLG0031390','2075000','2075000','10000','2085000','2085000','kasir','2026-09-16 15:09:11','F32616030911');
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-09-16','F326160309111','2026-09-16','15:09:11','FIT','2085000','10000');
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-260916-0029','D','2026-09-16','15:09:11','kasir','PENJUALAN','F326160309111','7446930000','2085000','7449015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160309111' 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 ('F326160309112','kasir',' 1',' MEF1 X YT ','TOKO','PM-F','F1E-ZHAI-66-0','GL XX OVAL C SLEEP YT 54 8K','','2.790','1','100.00','2893000','0','0','15000','2893000','0','0','0','2893000','FIT','00419466','F1E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHAI-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F1E-ZHAI-66-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 ('F326160309112','2026-09-16','2.790','2026-09-16','15:09:11','PLG0031391','2893000','2893000','0','2893000','2893000','kasir','2026-09-16 15:09:11','F32616030911');
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-09-16','F326160309112','2026-09-16','15:09:11','FIT','2893000','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-260916-0030','D','2026-09-16','15:09:11','kasir','PENJUALAN','F326160309112','7449015000','2893000','7451908000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2893000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160309112' 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 ('F326160309113','kasir',' 1',' MEF3E X LT','TOKO','PM-F','F3E-ZHAI-32-0','GL X CAPELA SLEEP LT 8K ','','3.170','1','100.00','3287000','0','0','15000','3287000','0','0','0','3287000','FIT','00419432','F3E','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAI-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='F3E-ZHAI-32-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 ('F326160309113','2026-09-16','3.170','2026-09-16','15:09:11','PLG0031392','3287000','3287000','0','3287000','3287000','kasir','2026-09-16 15:09:11','F32616030911');
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-09-16','F326160309113','2026-09-16','15:09:11','FIT','3287000','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-260916-0031','D','2026-09-16','15:09:11','kasir','PENJUALAN','F326160309113','7451908000','3287000','7455195000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3287000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160309113' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160119051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160119051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160119051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160119052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160119052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160119052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160120551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160120551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160120551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160203381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160203381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160203381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160244191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160244191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160244191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160257161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160257161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160257161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160309111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160309112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309113' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160309113' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160309113';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160834571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160834571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160834571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160930391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160930391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160930391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160930392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160930392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160930392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160940591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160940592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160940593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160940593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161011101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161011101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161011101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161036361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161036361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161036361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161039591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161039591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161039591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161122291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161122292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161122293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161122293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161248441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161248441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161248441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161249071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161249071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161249071';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-16';
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-09-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-16' 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-260917-0001','D','2026-09-17','15:48:18','SYSTEM','SALDO AWAL','SALDO AWAL','0','7455195000','7455195000');
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-260917-0001','D','2026-09-17','15:48:18','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-260917-0001','D','2026-09-17','15:48:18','BRI','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-260917-0001','D','2026-09-17','15:48:18','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
UPDATE tp_system SET tgl_system='2026-09-17';
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-20260917-0001','1','E1D-ZIAX-182-0','1','0.950','0.950','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIAX-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIAX-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-09-17 17:19:00' WHERE kode_barang='E1D-ZIAX-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIAX-182-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-09-17 17:19:00','TOKO','PM-E','E1D','E1D-ZIAX-182-0','1','0.950','0.950','1','0.950','0.950','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-ZIAX-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIAX-182-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260917-0001','2026-09-17','17:18','0.950','admpindah','2026-09-16 17:19: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-20260917-0001','1','F3E-YLXD-39-0','1','2.630','2.630','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLXD-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLXD-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-17 17:19:14' WHERE kode_barang='F3E-YLXD-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLXD-39-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-09-17 17:19:14','TOKO','PM-F','F3E','F3E-YLXD-39-0','1','2.630','2.630','1','2.630','2.630','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-YLXD-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXD-39-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-20260917-0001','1','F3E-ZGAG-174-0','1','1.450','1.450','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGAG-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGAG-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-17 17:19:14' WHERE kode_barang='F3E-ZGAG-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGAG-174-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-09-17 17:19:14','TOKO','PM-F','F3E','F3E-ZGAG-174-0','1','1.450','1.450','1','1.450','1.450','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-ZGAG-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGAG-174-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-20260917-0001','1','F3E-ZIAF-232-0','1','1.680','1.680','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIAF-232-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-232-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-17 17:19:14' WHERE kode_barang='F3E-ZIAF-232-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIAF-232-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-09-17 17:19:14','TOKO','PM-F','F3E','F3E-ZIAF-232-0','1','1.680','1.680','1','1.680','1.680','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-ZIAF-232-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-232-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-20260917-0001','1','F3E-ZIAF-233-0','1','2.230','2.230','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIAF-233-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-233-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-17 17:19:14' WHERE kode_barang='F3E-ZIAF-233-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIAF-233-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-09-17 17:19:14','TOKO','PM-F','F3E','F3E-ZIAF-233-0','1','2.230','2.230','1','2.230','2.230','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-ZIAF-233-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-233-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-20260917-0001','1','F3E-ZIAF-234-0','1','1.740','1.740','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIAF-234-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-234-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-09-17 17:19:14' WHERE kode_barang='F3E-ZIAF-234-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIAF-234-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-09-17 17:19:14','TOKO','PM-F','F3E','F3E-ZIAF-234-0','1','1.740','1.740','1','1.740','1.740','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-ZIAF-234-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIAF-234-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260917-0001','2026-09-17','17:19','9.730','admpindah','2026-09-16 17:19:14');