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-20260217-0001','1','A1D-YKBD-20-0','1','1.210','1.210','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKBD-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKBD-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-YKBD-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKBD-20-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-YKBD-20-0','1','1.210','1.210','1','1.210','1.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YKBD-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKBD-20-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-20260217-0001','1','A1E-ZBAF-271-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZBAF-271-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-271-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1E-ZBAF-271-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1E','A1E-ZBAF-271-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZBAF-271-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-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-20260217-0001','1','A1E-ZBAF-272-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZBAF-272-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-272-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1E-ZBAF-272-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1E','A1E-ZBAF-272-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZBAF-272-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-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-20260217-0001','1','A1E-ZBAF-273-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZBAF-273-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-273-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1E-ZBAF-273-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZBAF-273-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-02-17 08:02:41','TOKO','PM-A','A1E','A1E-ZBAF-273-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZBAF-273-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-273-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-20260217-0001','1','A1E-ZBAF-274-0','1','0.600','0.600','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZBAF-274-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-274-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1E-ZBAF-274-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1E','A1E-ZBAF-274-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZBAF-274-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-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-20260217-0001','1','A1E-ZBAF-275-0','1','0.630','0.630','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZBAF-275-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-275-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1E-ZBAF-275-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1E','A1E-ZBAF-275-0','1','0.630','0.630','1','0.630','0.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZBAF-275-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZBAF-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-20260217-0001','1','A1D-ZBAF-276-0','1','1.040','1.040','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-276-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-276-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-276-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-276-0','1','1.040','1.040','1','1.040','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-276-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-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-20260217-0001','1','A1D-ZBAF-277-0','1','1.000','1.000','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-277-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-277-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-277-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-277-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-277-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-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-20260217-0001','1','A1D-ZBAF-310-0','1','0.880','0.880','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-310-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-310-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-310-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-310-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-310-0','1','0.880','0.880','1','0.880','0.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-310-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-310-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-20260217-0001','1','A1D-ZBAF-311-0','1','0.850','0.850','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-311-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-311-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-311-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-311-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-311-0','1','0.850','0.850','1','0.850','0.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-311-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-311-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-20260217-0001','1','A1D-ZBAF-312-0','1','1.020','1.020','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-312-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-312-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-312-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-312-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-312-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-312-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-312-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-20260217-0001','1','A1D-ZBAF-314-0','1','1.150','1.150','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-314-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-314-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-314-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-314-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-314-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-314-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-314-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-20260217-0001','1','A1D-ZBAF-315-0','1','1.200','1.200','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAF-315-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-315-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-02-17 08:02:41' WHERE kode_barang='A1D-ZBAF-315-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAF-315-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-02-17 08:02:41','TOKO','PM-A','A1D','A1D-ZBAF-315-0','1','1.200','1.200','1','1.200','1.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZBAF-315-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAF-315-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:02','11.110','admpindah','2026-02-17 08:02:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','B1D-ZBXE-117-0','1','0.860','0.860','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZBXE-117-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZBXE-117-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-02-17 08:03:03' WHERE kode_barang='B1D-ZBXE-117-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZBXE-117-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-17 08:03:03','TOKO','PM-B','B1D','B1D-ZBXE-117-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' 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='B1D-ZBXE-117-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZBXE-117-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','B1E-ZBXE-124-0','1','0.620','0.620','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBXE-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBXE-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-02-17 08:03:03' WHERE kode_barang='B1E-ZBXE-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBXE-124-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-02-17 08:03:03','TOKO','PM-B','B1E','B1E-ZBXE-124-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZBXE-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBXE-124-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-20260217-0001','1','B1E-ZBAA-93-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBAA-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-02-17 08:03:03' WHERE kode_barang='B1E-ZBAA-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBAA-93-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-02-17 08:03:03','TOKO','PM-B','B1E','B1E-ZBAA-93-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZBAA-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-93-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:02','1.980','admpindah','2026-02-17 08:03:03');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','D1G-ZBAF-278-0','1','0.330','0.330','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZBAF-278-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZBAF-278-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D1G-ZBAF-278-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZBAF-278-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-02-17 08:03:23','TOKO','PM-D','D1G','D1G-ZBAF-278-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZBAF-278-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZBAF-278-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-20260217-0001','1','D1G-ZBAF-279-0','1','0.300','0.300','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZBAF-279-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZBAF-279-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D1G-ZBAF-279-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZBAF-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-02-17 08:03:23','TOKO','PM-D','D1G','D1G-ZBAF-279-0','1','0.300','0.300','1','0.300','0.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZBAF-279-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZBAF-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-20260217-0001','1','D1E-ZBAF-306-0','1','0.620','0.620','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZBAF-306-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZBAF-306-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D1E-ZBAF-306-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZBAF-306-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-02-17 08:03:23','TOKO','PM-D','D1E','D1E-ZBAF-306-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZBAF-306-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZBAF-306-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-20260217-0001','1','D2E-ZBAF-307-0','1','0.610','0.610','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZBAF-307-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZBAF-307-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D2E-ZBAF-307-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZBAF-307-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-02-17 08:03:23','TOKO','PM-D','D2E','D2E-ZBAF-307-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZBAF-307-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZBAF-307-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-20260217-0001','1','D1D-ZBAF-308-0','1','1.070','1.070','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1D-ZBAF-308-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1D-ZBAF-308-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D1D-ZBAF-308-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1D-ZBAF-308-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-02-17 08:03:23','TOKO','PM-D','D1D','D1D-ZBAF-308-0','1','1.070','1.070','1','1.070','1.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1D' 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='D1D-ZBAF-308-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1D-ZBAF-308-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-20260217-0001','1','D1F-ZBAF-309-0','1','0.430','0.430','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZBAF-309-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZBAF-309-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-02-17 08:03:23' WHERE kode_barang='D1F-ZBAF-309-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZBAF-309-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-02-17 08:03:23','TOKO','PM-D','D1F','D1F-ZBAF-309-0','1','0.430','0.430','1','0.430','0.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' 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='D1F-ZBAF-309-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZBAF-309-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:03','3.360','admpindah','2026-02-17 08:03:22');
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-20260217-0001','1','E1D-ZBXF-188-0','1','1.760','1.760','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBXF-188-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBXF-188-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBXF-188-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBXF-188-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBXF-188-0','1','1.760','1.760','1','1.760','1.760','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-ZBXF-188-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBXF-188-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-20260217-0001','1','E2D-ZBAF-283-0','1','1.110','1.110','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-283-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-283-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-283-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-283-0','1','1.110','1.110','1','1.110','1.110','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-ZBAF-283-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-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-20260217-0001','1','E2D-ZBAF-285-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-285-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-285-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-285-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-285-0','1','1.100','1.100','1','1.100','1.100','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-ZBAF-285-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-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-20260217-0001','1','E2D-ZBAF-286-0','1','1.510','1.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-286-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-286-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-286-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-286-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-286-0','1','1.510','1.510','1','1.510','1.510','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-ZBAF-286-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-286-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-20260217-0001','1','E2D-ZBAF-287-0','1','1.510','1.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-287-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-287-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-287-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-287-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-287-0','1','1.510','1.510','1','1.510','1.510','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-ZBAF-287-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-287-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-20260217-0001','1','E2D-ZBAF-288-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-288-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-288-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-288-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-288-0','1','1.550','1.550','1','1.550','1.550','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-ZBAF-288-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-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-20260217-0001','1','E2D-ZBAF-289-0','1','1.570','1.570','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAF-289-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-289-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E2D-ZBAF-289-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E2D','E2D-ZBAF-289-0','1','1.570','1.570','1','1.570','1.570','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-ZBAF-289-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAF-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-20260217-0001','1','E1D-ZBAF-290-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-290-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-290-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-290-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-290-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-290-0','1','1.150','1.150','1','1.150','1.150','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-ZBAF-290-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-290-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-20260217-0001','1','E1D-ZBAF-291-0','1','0.780','0.780','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-291-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-291-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-291-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-291-0','1','0.780','0.780','1','0.780','0.780','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-ZBAF-291-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-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-20260217-0001','1','E1D-ZBAF-292-0','1','0.860','0.860','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-292-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-292-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-292-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-292-0','1','0.860','0.860','1','0.860','0.860','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-ZBAF-292-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-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-20260217-0001','1','E1D-ZBAF-293-0','1','0.980','0.980','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-293-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-293-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-293-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-293-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-293-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZBAF-293-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-293-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-20260217-0001','1','E1D-ZBAF-295-0','1','1.420','1.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-295-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-295-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-295-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-295-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZBAF-295-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-295-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-20260217-0001','1','E1D-ZBAF-296-0','1','0.870','0.870','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-296-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-296-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-296-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-296-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-296-0','1','0.870','0.870','1','0.870','0.870','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-ZBAF-296-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-296-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-20260217-0001','1','E1D-ZBAF-297-0','1','0.820','0.820','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAF-297-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-297-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1D-ZBAF-297-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAF-297-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-02-17 08:03:44','TOKO','PM-E','E1D','E1D-ZBAF-297-0','1','0.820','0.820','1','0.820','0.820','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-ZBAF-297-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAF-297-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-20260217-0001','1','E1E-ZBAF-299-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAF-299-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-299-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1E-ZBAF-299-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAF-299-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-02-17 08:03:44','TOKO','PM-E','E1E','E1E-ZBAF-299-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-ZBAF-299-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-299-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-20260217-0001','1','E1E-ZBAF-300-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAF-300-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-300-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1E-ZBAF-300-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAF-300-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-02-17 08:03:44','TOKO','PM-E','E1E','E1E-ZBAF-300-0','1','0.480','0.480','1','0.480','0.480','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-ZBAF-300-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-300-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-20260217-0001','1','E1E-ZBAF-302-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAF-302-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-302-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-17 08:03:44' WHERE kode_barang='E1E-ZBAF-302-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAF-302-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-02-17 08:03:44','TOKO','PM-E','E1E','E1E-ZBAF-302-0','1','0.480','0.480','1','0.480','0.480','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-ZBAF-302-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAF-302-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:03','18.470','admpindah','2026-02-17 08:03:44');
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-20260217-0001','1','F3E-ZBAD-186-0','1','2.730','2.730','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAD-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F3E-ZBAD-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAD-186-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-02-17 08:04:08','TOKO','PM-F','F3E','F3E-ZBAD-186-0','1','2.730','2.730','1','2.730','2.730','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-ZBAD-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-186-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-20260217-0001','1','F3E-ZBAF-91-0','1','1.830','1.830','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAF-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F3E-ZBAF-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAF-91-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-02-17 08:04:08','TOKO','PM-F','F3E','F3E-ZBAF-91-0','1','1.830','1.830','1','1.830','1.830','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-ZBAF-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-91-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-20260217-0001','1','F2E-ZBAF-95-0','1','1.970','1.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZBAF-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZBAF-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F2E-ZBAF-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZBAF-95-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-17 08:04:08','TOKO','PM-F','F2E','F2E-ZBAF-95-0','1','1.970','1.970','1','1.970','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZBAF-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZBAF-95-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','F2E-ZBAF-97-0','1','1.970','1.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZBAF-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZBAF-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F2E-ZBAF-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZBAF-97-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-02-17 08:04:08','TOKO','PM-F','F2E','F2E-ZBAF-97-0','1','1.970','1.970','1','1.970','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZBAF-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZBAF-97-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-20260217-0001','1','F1E-ZBAF-102-0','1','3.000','3.000','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-102-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-102-0','1','3.000','3.000','1','3.000','3.000','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-ZBAF-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-102-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','F1E-ZBAF-103-0','1','3.030','3.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-103-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-103-0','1','3.030','3.030','1','3.030','3.030','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-ZBAF-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-103-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-20260217-0001','1','F1E-ZBAF-104-0','1','5.010','5.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-104-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-104-0','1','5.010','5.010','1','5.010','5.010','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-ZBAF-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-104-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-20260217-0001','1','F1E-ZBAF-105-0','1','4.000','4.000','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-105-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-105-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-105-0','1','4.000','4.000','1','4.000','4.000','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-ZBAF-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-105-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-20260217-0001','1','F1E-ZBAF-106-0','1','1.980','1.980','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-106-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-106-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-106-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-106-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-106-0','1','1.980','1.980','1','1.980','1.980','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-ZBAF-106-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-106-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-20260217-0001','1','F1E-ZBAF-107-0','1','2.080','2.080','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-107-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-107-0','1','2.080','2.080','1','2.080','2.080','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-ZBAF-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-107-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-20260217-0001','1','F1E-ZBAF-108-0','1','1.970','1.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-108-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-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-108-0','1','1.970','1.970','1','1.970','1.970','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-ZBAF-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-108-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-20260217-0001','1','F1E-ZBAF-109-0','1','1.960','1.960','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBAF-109-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-109-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F1E-ZBAF-109-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBAF-109-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-17 08:04:08','TOKO','PM-F','F1E','F1E-ZBAF-109-0','1','1.960','1.960','1','1.960','1.960','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-ZBAF-109-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBAF-109-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260217-0001','1','F3E-ZBAF-269-0','1','1.650','1.650','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAF-269-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-269-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F3E-ZBAF-269-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAF-269-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-02-17 08:04:08','TOKO','PM-F','F3E','F3E-ZBAF-269-0','1','1.650','1.650','1','1.650','1.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZBAF-269-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-269-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-20260217-0001','1','F3E-ZBAF-270-0','1','2.040','2.040','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAF-270-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-270-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F3E-ZBAF-270-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAF-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-02-17 08:04:08','TOKO','PM-F','F3E','F3E-ZBAF-270-0','1','2.040','2.040','1','2.040','2.040','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-ZBAF-270-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-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-20260217-0001','1','F3E-ZBAF-305-0','1','1.540','1.540','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAF-305-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-305-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-17 08:04:08' WHERE kode_barang='F3E-ZBAF-305-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAF-305-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-02-17 08:04:08','TOKO','PM-F','F3E','F3E-ZBAF-305-0','1','1.540','1.540','1','1.540','1.540','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-ZBAF-305-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAF-305-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:03','36.760','admpindah','2026-02-17 08:04:08');
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-20260217-0001','1','H1E-ZAAE-110-0','1','4.900','4.900','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZAAE-110-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZAAE-110-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-02-17 08:04:32' WHERE kode_barang='H1E-ZAAE-110-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZAAE-110-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-02-17 08:04:32','TOKO','PM-H','H1E','H1E-ZAAE-110-0','1','4.900','4.900','1','4.900','4.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZAAE-110-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZAAE-110-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260217-0001','2026-02-17','08:04','4.900','admpindah','2026-02-17 08:04:31');
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 ('F326170805461','input','1',' MDE2 X HW ','TOKO','PM-E','E2D-ZAAF-232-0','CC X MODEL PAKU MATA HW 13 8K ','','1.030','1','100.00','1251000','0','0','15000','1250000','0','0','0','1250000','SIN','00385683','E2D','0','0','-','1','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-232-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='E2D-ZAAF-232-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 ('F326170805461','2026-02-17','1.030','2026-02-17','08:05:47','PLG0027201','1250000','1250000','0','1250000','1250000','input','2026-02-17 08:05:46','F32617080546');
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-02-17','F326170805461','2026-02-17','08:05:47','SIN','1250000','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-260217-0002','D','2026-02-17','08:05:47','input','PENJUALAN','F326170805461','2464357000','1250000','2465607000');
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 ('F326170936141','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YLXD-33-0','GL X KREPYAK DAUN BUNGA VAR UB 8K ','','4.700','1','100.00','5804000','0','0','15000','5805000','0','0','0','5805000','SIN','00379619','F3E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXD-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.700',berat_jual_asli=berat_jual_asli+'4.700',stock_jual='1',berat_akhir=berat_akhir-'4.700',berat_akhir_asli=berat_akhir_asli-'4.700',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='F3E-YLXD-33-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 ('F326170936141','2026-02-17','4.700','2026-02-17','09:36:14','PLG0027202','5805000','5805000','0','5805000','5805000','input','2026-02-17 09:36:14','F32617093614');
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-02-17','F326170936141','2026-02-17','09:36:14','SIN','5805000','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-260217-0003','D','2026-02-17','09:36:14','input','PENJUALAN','F326170936141','2465607000','5805000','2471412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5805000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170936141' 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 ('F326170936142','input',' 1',' MEE2 X LG ','TOKO','PM-E','E2E-ZABC-66-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.470','1','100.00','580000','0','0','15000','580000','0','0','0','580000','SIN','00386696','E2E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZABC-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='E2E-ZABC-66-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 ('F326170936142','2026-02-17','0.470','2026-02-17','09:36:14','PLG0027203','580000','580000','0','580000','580000','input','2026-02-17 09:36:14','F32617093614');
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-02-17','F326170936142','2026-02-17','09:36:14','SIN','580000','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-260217-0004','D','2026-02-17','09:36:14','input','PENJUALAN','F326170936142','2471412000','580000','2471992000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='580000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170936142' 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 ('F326170936143','input',' 1',' MEE1 UB ','TOKO','PM-E','E1E-ZABX-83-0','CC COR MODEL SLEP UB 8K ','','0.680','1','100.00','840000','0','0','15000','840000','0','0','0','840000','SIN','00386312','E1E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABX-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='E1E-ZABX-83-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 ('F326170936143','2026-02-17','0.680','2026-02-17','09:36:14','PLG0027204','840000','840000','0','840000','840000','input','2026-02-17 09:36:14','F32617093614');
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-02-17','F326170936143','2026-02-17','09:36:14','SIN','840000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260217-0005','D','2026-02-17','09:36:14','input','PENJUALAN','F326170936143','2471992000','840000','2472832000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='840000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170936143' 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 ('F326171021371','input','1',' TEF3 HW ','TOKO','PT-F','F3TE-YHBG-14-T','GL MODEL CAPELA VAR HW 17K ','','2.380','1','100.00','5307000','0','0','15000','5308000','0','0','0','5308000','SIN','T0072606','F3TE','0','0','-','0','2230000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YHBG-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='F3TE-YHBG-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326171021371','2026-02-17','2.380','2026-02-17','10:21:38','PLG0027205','5308000','5308000','0','5308000','5308000','input','2026-02-17 10:21:37','F32617102137');
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-02-17','F326171021371','2026-02-17','10:21:38','SIN','5308000','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-260217-0006','D','2026-02-17','10:21:38','input','PENJUALAN','F326171021371','2472832000','5308000','2478140000');
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 ('F326171211081','input','1',' MEF3E YT ','TOKO','PM-F','F3E-YLBB-291-0','GL KREPYAK DAUN SLEP YT 8K ','','3.360','1','100.00','4150000','0','0','15000','4150000','0','0','0','4150000','FIT','00382441','F3E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBB-291-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='F3E-YLBB-291-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 ('F326171211081','2026-02-17','3.360','2026-02-17','12:11:09','PLG0027206','4150000','4150000','0','4150000','4150000','input','2026-02-17 12:11:08','F32617121108');
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-02-17','F326171211081','2026-02-17','12:11:09','FIT','4150000','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-260217-0007','D','2026-02-17','12:11:09','input','PENJUALAN','F326171211081','2478140000','4150000','2482290000');
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 ('F326171223241','input','1',' MFH1 X UB ','TOKO','PM-H','H1F-YJXB-259-0','KL X MILANO ANAK UB 34 8K ','','3.000','1','100.00','3795000','0','0','15000','3765000','0','0','0','3765000','AAT','00371843','H1F','0','0','-','1','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXB-259-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='H1F-YJXB-259-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 ('F326171223241','2026-02-17','3.000','2026-02-17','12:23:25','PLG0027207','3765000','3765000','0','3765000','3765000','input','2026-02-17 12:23:24','F32617122324');
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-02-17','F326171223241','2026-02-17','12:23:25','AAT','3765000','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-260217-0008','D','2026-02-17','12:23:25','input','PENJUALAN','F326171223241','2482290000','3765000','2486055000');
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 ('F326171233461','input','1',' MHB1 HK ','TOKO','PM-B','B1H-ZABC-156-0','GW TUSUK MRICAN SLEP HK 8K ','','0.260','1','100.00','339000','0','0','15000','338000','0','0','0','338000','SIN','00386786','B1H','0','0','-','1','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZABC-156-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='B1H-ZABC-156-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171233461','2026-02-17','0.260','2026-02-17','12:33:46','PLG0027208','338000','338000','0','338000','338000','input','2026-02-17 12:33:46','F32617123346');
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-02-17','F326171233461','2026-02-17','12:33:46','SIN','338000','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-260217-0009','D','2026-02-17','12:33:46','input','PENJUALAN','F326171233461','2486055000','338000','2486393000');
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-00018226','X-00018226','KL NORY ANAK KH 34 8K','GR','---','H1E','BELI','BELI001','1735000','2026-02-17','2.100','1','kasir','2026-02-17 13:06:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018226','X-00018226');
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-260217-0001','F325161258061','AAT','1','BELI','BELI001','H1E', 'X-00018226', 'KL NORY ANAK KH 34 8K','2.100','2.100','100.00','1805000','1735000','826190','1245000','1','1735000','1735000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260217-0001','2026-02-17','2026-02-17','13:06:42','AAT','---','2.100','1735000','1735000','1735000','1735000','1735000','kasir','2026-02-17 13:06:42','FB-260217-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0001','YUAN','KISMANTORO','','','','kasir','2026-02-17 13:06:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0010','K','2026-02-17','13:06:42','kasir','PEMBELIAN UMUM','FB-260217-0001','2486393000','1735000','2484658000');
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-00018227','X-00018227','CC X WEDDING POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','1205000','2026-02-17','1.480','1','kasir','2026-02-17 13:14:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018227','X-00018227');
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-260217-0002','F325161250082','AAT','1','BELI','BELI001','E1D', 'X-00018227', 'CC X WEDDING POLOS CM 14 8K','1.480','1.480','100.00','990000','1205000','814189','1225000','1','1205000','1205000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.480',berat_beli_asli=berat_beli_asli+'1.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.480',berat_akhir_asli=berat_akhir_asli+'1.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260217-0002','2026-02-17','2026-02-17','13:14:23','AAT','---','1.480','1205000','1205000','1205000','1205000','1205000','kasir','2026-02-17 13:14:23','FB-260217-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0002','MUHAMAD NUROHIM','GAMBIRANOM KISMANTORO','','','','kasir','2026-02-17 13:14:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0011','K','2026-02-17','13:14:23','kasir','PEMBELIAN UMUM','FB-260217-0002','2484658000','1205000','2483453000');
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-00018228','X-00018228','LT SANDAL MODEL CAT VAR CM 8K','GR','---','D1D','BELI','BELI001','690000','2026-02-17','0.910','1','kasir','2026-02-17 13:14:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1D','X-00018228','X-00018228');
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-260217-0003','F325271101372','FIT','1','BELI','BELI001','D1D', 'X-00018228', 'LT SANDAL MODEL CAT VAR CM 8K','0.910','0.910','100.00','618000','690000','758242','1225000','1','690000','690000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1D' 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-260217-0003','2026-02-17','2026-02-17','13:14:44','FIT','---','0.910','690000','690000','690000','690000','690000','kasir','2026-02-17 13:14:45','FB-260217-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0003','RISKI','BANDAR PACITAN','','','','kasir','2026-02-17 13:14:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0012','K','2026-02-17','13:14:44','kasir','PEMBELIAN UMUM','FB-260217-0003','2483453000','690000','2482763000');
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 ('F326170157401','kasir','1',' MEF2 10K L','TOKO','PM-F','F2E-YKBF-167-0','GL PIPA ANAK CAT MATA LG 40 8K ','','2.020','1','100.00','2495000','0','0','15000','2495000','0','10000','0','2505000','SIN','00378839','F2E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YKBF-167-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='F2E-YKBF-167-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 ('F326170157401','2026-02-17','2.020','2026-02-17','13:57:41','PLG0027209','2495000','2495000','10000','2505000','2505000','kasir','2026-02-17 13:57:40','F32617015740');
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-02-17','F326170157401','2026-02-17','13:57:41','SIN','2505000','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-260217-0013','D','2026-02-17','13:57:41','kasir','PENJUALAN','F326170157401','2482763000','2505000','2485268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2505000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170157401' 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 ('F326170157402','kasir',' 1',' MEE2 X 5K ','TOKO','PM-E','E2E-YKXC-72-0','CC X MODEL BONEKA ANAK CAT LG 8K ','','0.590','1','100.00','729000','0','0','15000','730000','0','5000','0','735000','SIN','00375993','E2E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKXC-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='E2E-YKXC-72-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 ('F326170157402','2026-02-17','0.590','2026-02-17','13:57:41','PLG0027210','730000','730000','5000','735000','735000','kasir','2026-02-17 13:57:40','F32617015740');
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-02-17','F326170157402','2026-02-17','13:57:41','SIN','735000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260217-0014','D','2026-02-17','13:57:41','kasir','PENJUALAN','F326170157402','2485268000','735000','2486003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='735000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170157402' 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 ('F326170157403','kasir',' 1',' MEE1 X BM ','TOKO','PM-E','E1E-ZABH-213-0','CC X MODEL CAT HITAM BM 12 8K ','','0.500','1','100.00','617000','0','0','15000','618000','0','0','0','618000','SIN','00387071','E1E','0','0','-','0','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABH-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='E1E-ZABH-213-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 ('F326170157403','2026-02-17','0.500','2026-02-17','13:57:41','PLG0027211','618000','618000','0','618000','618000','kasir','2026-02-17 13:57:40','F32617015740');
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-02-17','F326170157403','2026-02-17','13:57:41','SIN','618000','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-260217-0015','D','2026-02-17','13:57:41','kasir','PENJUALAN','F326170157403','2486003000','618000','2486621000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170157403' 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 ('F326170233251','input','1',' MEF3 UB ','TOKO','PM-F','F3E-ZABX-79-0','GL LEMES MODEL CASTELI UB 8K ','','1.600','1','100.00','1976000','0','0','15000','1975000','0','0','0','1975000','FIT','00386308','F3E','0','0','-','1','1245000');
UPDATE tm_barang SET tgl_last_jual='2026-02-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABX-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-02-17' AND kode_barang='F3E-ZABX-79-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 ('F326170233251','2026-02-17','1.600','2026-02-17','14:33:25','PLG0027212','1975000','1975000','0','1975000','1975000','input','2026-02-17 14:33:25','F32617023325');
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-02-17','F326170233251','2026-02-17','14:33:25','FIT','1975000','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-260217-0016','D','2026-02-17','14:33:25','input','PENJUALAN','F326170233251','2486621000','1975000','2488596000');
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-00018229','X-00018229','GL LEMES MODEL CASTELI UB 8K','GR','---','F3E','BELI','BELI001','985000','2026-02-17','0.870','1','kasir','2026-02-17 14:47:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018229','X-00018229');
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-260217-0004','F326251039271','AAT','1','BELI','BELI001','F3E', 'X-00018229', 'GL LEMES MODEL CASTELI UB 8K','0.870','0.870','100.00','1070000','985000','1132184','1245000','1','985000','985000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.870',berat_beli_asli=berat_beli_asli+'0.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.870',berat_akhir_asli=berat_akhir_asli+'0.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260217-0004','2026-02-17','2026-02-17','14:47:38','AAT','---','0.870','985000','985000','985000','985000','985000','kasir','2026-02-17 14:47:39','FB-260217-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0004','TITIS','NAWANGAN','','','','kasir','2026-02-17 14:47:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0017','K','2026-02-17','14:47:38','kasir','PEMBELIAN UMUM','FB-260217-0004','2488596000','985000','2487611000');
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-00018230','X-00018230','GL LONG LING UB 8K','GR','---','F3E','BELI','BELI001','970000','2026-02-17','0.970','1','kasir','2026-02-17 14:47:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018230','X-00018230');
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-260217-0005','F326031050541','AAT','2','BELI','BELI001','F3E', 'X-00018230', 'GL LONG LING UB 8K','0.970','0.970','100.00','1033000','970000','1000000','1245000','1','970000','970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260217-0005','2026-02-17','2026-02-17','14:47:38','AAT','---','0.970','970000','970000','970000','970000','970000','kasir','2026-02-17 14:47:39','FB-260217-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0005','TITIS','NAWANGAN','','','','kasir','2026-02-17 14:47:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0018','K','2026-02-17','14:47:38','kasir','PEMBELIAN UMUM','FB-260217-0005','2487611000','970000','2486641000');
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-00018231','X-00018231','KL SIEM COBRA ANAK KH 34 9K','GR','---','H2J','BELI','BELI001','1115000','2026-02-17','1.060','1','kasir','2026-02-17 14:48:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00018231','X-00018231');
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-260217-0006','F325281038051','AAT','1','BELI','BELI001','H2J', 'X-00018231', 'KL SIEM COBRA ANAK KH 34 9K','1.060','1.060','100.00','1188000','1115000','1051887','1345000','1','1115000','1115000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260217-0006','2026-02-17','2026-02-17','14:48:10','AAT','---','1.060','1115000','1115000','1115000','1115000','1115000','kasir','2026-02-17 14:48:10','FB-260217-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0006','RARA','POHIJO','','','081246290739','kasir','2026-02-17 14:48:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0019','K','2026-02-17','14:48:10','kasir','PEMBELIAN UMUM','FB-260217-0006','2486641000','1115000','2485526000');
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-00018232','X-00018232','LT X MODEL ARESO SLEP UB 8K','GR','---','D1G','BELI','BELI001','360000','2026-02-17','0.360','1','kasir','2026-02-17 14:48:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00018232','X-00018232');
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-260217-0007','F325281041271','AAT','2','BELI','BELI001','D1G', 'X-00018232', 'LT X MODEL ARESO SLEP UB 8K','0.360','0.360','100.00','380000','360000','1000000','1285000','1','360000','360000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260217-0007','2026-02-17','2026-02-17','14:48:10','AAT','---','0.360','360000','360000','360000','360000','360000','kasir','2026-02-17 14:48:10','FB-260217-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260217-0007','RARA','POHIJO','','','081246290739','kasir','2026-02-17 14:48:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-17' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260217-0020','K','2026-02-17','14:48:10','kasir','PEMBELIAN UMUM','FB-260217-0007','2485526000','360000','2485166000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260217-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260217-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170157401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170157402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157403' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170157403' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170157403';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170233251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170233251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170233251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170805461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170805461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170805461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170936141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170936142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936143' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170936143' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170936143';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171021371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171021371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171211081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171211081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171211081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171223241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171223241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171223241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171233461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171233461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171233461';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260217-0001','1','E1TD-YHBG-21-T','1','0.980','0.980','TOKO','PT-E','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TBK-E' WHERE kode_barang='E1TD-YHBG-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-17','TOKO','TBK-E','E1TD','E1TD-YHBG-21-T','100.00','1','0.980','0.980','1','0.980','0.980');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.980',berat_out_asli=berat_out_asli+'0.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-17' AND kode_barang='E1TD-YHBG-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260217-0001','2026-02-17','2026-02-17','15:19','0.98','input','2026-02-17 15:19:59');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-17';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260218-0001','D','2026-02-18','15:35:35','SYSTEM','SALDO AWAL','SALDO AWAL','0','2485166000','2485166000');
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-260218-0001','D','2026-02-18','15:35:35','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-260218-0001','D','2026-02-18','15:35:35','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-260218-0001','D','2026-02-18','15:35:35','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-02-18';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260218-0001','1','E1TD-YHBG-21-T','1','0.980','TOKO','TBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-YHBG-21-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1TD-YHBG-21-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TBK-E';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1TD-YHBG-21-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.980',berat_out_asli='0.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.980',berat_akhir_asli =berat_akhir_asli-'0.980' WHERE kode_barang='E1TD-YHBG-21-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260218-0001','2026-02-18','2026-02-18','16:46','0.980','admpindah','260218');
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-20260218-0001','1','E2E-ZBAG-78-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZBAG-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZBAG-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-18 16:47:42' WHERE kode_barang='E2E-ZBAG-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZBAG-78-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-02-18 16:47:42','TOKO','PM-E','E2E','E2E-ZBAG-78-0','1','0.530','0.530','1','0.530','0.530','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-ZBAG-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZBAG-78-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-20260218-0001','1','E2E-ZBAG-79-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZBAG-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZBAG-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-18 16:47:42' WHERE kode_barang='E2E-ZBAG-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZBAG-79-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-02-18 16:47:42','TOKO','PM-E','E2E','E2E-ZBAG-79-0','1','0.450','0.450','1','0.450','0.450','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-ZBAG-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZBAG-79-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-20260218-0001','1','E1E-ZBAG-80-0','1','0.700','0.700','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAG-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAG-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-18 16:47:42' WHERE kode_barang='E1E-ZBAG-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAG-80-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-02-18 16:47:42','TOKO','PM-E','E1E','E1E-ZBAG-80-0','1','0.700','0.700','1','0.700','0.700','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-ZBAG-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAG-80-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-20260218-0001','1','E1E-ZBAG-81-0','1','0.700','0.700','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAG-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAG-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-02-18 16:47:42' WHERE kode_barang='E1E-ZBAG-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAG-81-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-02-18 16:47:42','TOKO','PM-E','E1E','E1E-ZBAG-81-0','1','0.700','0.700','1','0.700','0.700','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-ZBAG-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAG-81-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260218-0001','2026-02-18','16:47','2.380','admpindah','2026-02-17 16:47:42');
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-20260218-0001','1','F3E-ZBAD-165-0','1','4.150','4.150','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAD-165-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-165-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-18 16:47:59' WHERE kode_barang='F3E-ZBAD-165-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAD-165-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-02-18 16:47:59','TOKO','PM-F','F3E','F3E-ZBAD-165-0','1','4.150','4.150','1','4.150','4.150','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-ZBAD-165-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-165-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-20260218-0001','1','F3E-ZBAD-166-0','1','3.010','3.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZBAD-166-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-166-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-02-18 16:47:59' WHERE kode_barang='F3E-ZBAD-166-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZBAD-166-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-02-18 16:47:59','TOKO','PM-F','F3E','F3E-ZBAD-166-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZBAD-166-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZBAD-166-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260218-0001','2026-02-18','16:47','7.160','admpindah','2026-02-17 16:47:58');