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-20251024-0001','1','A1E-YJBC-258-0','1','1.050','1.050','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-258-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-258-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-258-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-258-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-258-0','1','1.050','1.050','1','1.050','1.050','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-YJBC-258-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-258-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-20251024-0001','1','A1E-YJBC-259-0','1','0.600','0.600','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-259-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-259-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-259-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-259-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-259-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-YJBC-259-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-259-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-20251024-0001','1','A1E-YJBC-260-0','1','0.550','0.550','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-260-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-260-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-260-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-260-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-260-0','1','0.550','0.550','1','0.550','0.550','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-YJBC-260-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-260-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-20251024-0001','1','A1E-YJBC-261-0','1','0.480','0.480','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-261-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-261-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-261-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-261-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-261-0','1','0.480','0.480','1','0.480','0.480','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-YJBC-261-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-261-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-20251024-0001','1','A1E-YJBC-262-0','1','0.470','0.470','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-262-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-262-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-262-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-262-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-262-0','1','0.470','0.470','1','0.470','0.470','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-YJBC-262-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-262-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-20251024-0001','1','A1E-YJBC-263-0','1','0.690','0.690','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJBC-263-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJBC-263-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1E-YJBC-263-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJBC-263-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1E','A1E-YJBC-263-0','1','0.690','0.690','1','0.690','0.690','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-YJBC-263-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJBC-263-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-20251024-0001','1','A1D-YJBC-264-0','1','1.250','1.250','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YJBC-264-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YJBC-264-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-24 08:01:26' WHERE kode_barang='A1D-YJBC-264-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YJBC-264-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 ('2025-10-24 08:01:26','TOKO','PM-A','A1D','A1D-YJBC-264-0','1','1.250','1.250','1','1.250','1.250','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-YJBC-264-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YJBC-264-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251024-0001','2025-10-24','08:01','5.090','admpindah','2025-10-24 08:01:25');
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-20251024-0001','1','B1E-YJBC-265-0','1','0.790','0.790','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJBC-265-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJBC-265-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2025-10-24 08:01:51' WHERE kode_barang='B1E-YJBC-265-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJBC-265-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 ('2025-10-24 08:01:51','TOKO','PM-B','B1E','B1E-YJBC-265-0','1','0.790','0.790','1','0.790','0.790','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-YJBC-265-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJBC-265-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-20251024-0001','1','B1E-YJBC-266-0','1','0.550','0.550','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJBC-266-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJBC-266-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2025-10-24 08:01:51' WHERE kode_barang='B1E-YJBC-266-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJBC-266-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 ('2025-10-24 08:01:51','TOKO','PM-B','B1E','B1E-YJBC-266-0','1','0.550','0.550','1','0.550','0.550','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-YJBC-266-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJBC-266-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-20251024-0001','1','B1E-YJBC-267-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJBC-267-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJBC-267-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2025-10-24 08:01:51' WHERE kode_barang='B1E-YJBC-267-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJBC-267-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 ('2025-10-24 08:01:51','TOKO','PM-B','B1E','B1E-YJBC-267-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-YJBC-267-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJBC-267-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251024-0001','2025-10-24','08:01','1.840','admpindah','2025-10-24 08:01:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1E-YIBD-353-0','1','0.540','0.540','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YIBD-353-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YIBD-353-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YIBD-353-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YIBD-353-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YIBD-353-0','1','0.540','0.540','1','0.540','0.540','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-YIBD-353-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YIBD-353-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-20251024-0001','1','E2E-YJBA-168-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJBA-168-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJBA-168-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2E-YJBA-168-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJBA-168-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2E','E2E-YJBA-168-0','1','0.470','0.470','1','0.470','0.470','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-YJBA-168-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJBA-168-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-20251024-0001','1','E2E-YJBC-3-0','1','0.730','0.730','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJBC-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJBC-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2E-YJBC-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJBC-3-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2E','E2E-YJBC-3-0','1','0.730','0.730','1','0.730','0.730','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-YJBC-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJBC-3-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-20251024-0001','1','E2D-YJBC-19-0','1','1.080','1.080','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-19-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-19-0','1','1.080','1.080','1','1.080','1.080','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-YJBC-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-19-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-20251024-0001','1','E2D-YJBC-31-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-31-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-31-0','1','1.000','1.000','1','1.000','1.000','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-YJBC-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-31-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-20251024-0001','1','E2D-YJBC-37-0','1','0.860','0.860','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-37-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-37-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YJBC-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-37-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-20251024-0001','1','E2D-YJBC-42-0','1','1.630','1.630','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-42-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-42-0','1','1.630','1.630','1','1.630','1.630','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-YJBC-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-42-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-20251024-0001','1','E2D-YJBC-74-0','1','1.180','1.180','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-74-0','1','1.180','1.180','1','1.180','1.180','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-YJBC-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E2D-YJBC-80-0','1','0.830','0.830','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-80-0','1','0.830','0.830','1','0.830','0.830','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-YJBC-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-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-20251024-0001','1','E2D-YJBC-90-0','1','0.940','0.940','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-90-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-90-0','1','0.940','0.940','1','0.940','0.940','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-YJBC-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-90-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-20251024-0001','1','E2D-YJBC-96-0','1','1.300','1.300','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-96-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-96-0','1','1.300','1.300','1','1.300','1.300','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-YJBC-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-96-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-20251024-0001','1','E2D-YJBC-97-0','1','1.050','1.050','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-97-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YJBC-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-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-20251024-0001','1','E2D-YJBC-102-0','1','0.820','0.820','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJBC-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJBC-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2D-YJBC-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJBC-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2D','E2D-YJBC-102-0','1','0.820','0.820','1','0.820','0.820','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-YJBC-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJBC-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-20251024-0001','1','E1D-YJBC-110-0','1','1.120','1.120','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-110-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-110-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-110-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-110-0','1','1.120','1.120','1','1.120','1.120','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-YJBC-110-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-110-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-20251024-0001','1','E1D-YJBC-122-0','1','2.940','2.940','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-122-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-122-0','1','2.940','2.940','1','2.940','2.940','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-YJBC-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-122-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-20251024-0001','1','E1D-YJBC-125-0','1','1.800','1.800','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-125-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-125-0','1','1.800','1.800','1','1.800','1.800','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-YJBC-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-125-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-20251024-0001','1','E1E-YJBC-128-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-128-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-128-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-128-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-128-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-128-0','1','0.560','0.560','1','0.560','0.560','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-YJBC-128-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-128-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-20251024-0001','1','E1E-YJBC-175-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-175-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-175-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-175-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-175-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-175-0','1','0.420','0.420','1','0.420','0.420','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-YJBC-175-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-175-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-20251024-0001','1','E1E-YJBC-176-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-176-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-176-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-176-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-176-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-176-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YJBC-176-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-176-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-20251024-0001','1','E1E-YJBC-177-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-177-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-177-0','1','0.560','0.560','1','0.560','0.560','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-YJBC-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-177-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1D-YJBC-178-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-178-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-178-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBC-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-178-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1D-YJBC-179-0','1','1.040','1.040','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-179-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-179-0','1','1.040','1.040','1','1.040','1.040','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-YJBC-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-179-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1D-YJBC-180-0','1','1.060','1.060','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-180-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-180-0','1','1.060','1.060','1','1.060','1.060','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-YJBC-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-180-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1D-YJBC-181-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-181-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-181-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-181-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-181-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-181-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBC-181-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-181-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','E1D-YJBC-182-0','1','2.030','2.030','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-182-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-182-0','1','2.030','2.030','1','2.030','2.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBC-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-182-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-20251024-0001','1','E1D-YJBC-183-0','1','0.800','0.800','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-183-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-183-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-183-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-183-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-183-0','1','0.800','0.800','1','0.800','0.800','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-YJBC-183-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-183-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-20251024-0001','1','E1E-YJBC-184-0','1','0.790','0.790','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-184-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-184-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-184-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-184-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-184-0','1','0.790','0.790','1','0.790','0.790','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-YJBC-184-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-184-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-20251024-0001','1','E1D-YJBC-247-0','1','1.010','1.010','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-247-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-247-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-247-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-247-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-247-0','1','1.010','1.010','1','1.010','1.010','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-YJBC-247-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-247-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-20251024-0001','1','E1D-YJBC-248-0','1','1.030','1.030','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-248-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-248-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-248-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-248-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-248-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBC-248-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-248-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-20251024-0001','1','E1D-YJBC-249-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-249-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-249-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-249-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-249-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-249-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YJBC-249-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-249-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-20251024-0001','1','E1D-YJBC-250-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-250-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-250-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-250-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-250-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-250-0','1','0.900','0.900','1','0.900','0.900','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-YJBC-250-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-250-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-20251024-0001','1','E1D-YJBC-251-0','1','0.860','0.860','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YJBC-251-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YJBC-251-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1D-YJBC-251-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YJBC-251-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1D','E1D-YJBC-251-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-YJBC-251-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YJBC-251-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-20251024-0001','1','E1E-YJBC-252-0','1','0.620','0.620','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-252-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-252-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-252-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-252-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-252-0','1','0.620','0.620','1','0.620','0.620','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-YJBC-252-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-252-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-20251024-0001','1','E1E-YJBC-253-0','1','0.600','0.600','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-253-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-253-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-253-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-253-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-253-0','1','0.600','0.600','1','0.600','0.600','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-YJBC-253-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-253-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-20251024-0001','1','E1E-YJBC-254-0','1','0.710','0.710','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-254-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-254-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-254-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-254-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-254-0','1','0.710','0.710','1','0.710','0.710','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-YJBC-254-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-254-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-20251024-0001','1','E1E-YJBC-255-0','1','0.730','0.730','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBC-255-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBC-255-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E1E-YJBC-255-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBC-255-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 ('2025-10-24 08:02:13','TOKO','PM-E','E1E','E1E-YJBC-255-0','1','0.730','0.730','1','0.730','0.730','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-YJBC-255-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBC-255-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-20251024-0001','1','E2E-YJBC-256-0','1','0.430','0.430','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJBC-256-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJBC-256-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2E-YJBC-256-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJBC-256-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2E','E2E-YJBC-256-0','1','0.430','0.430','1','0.430','0.430','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-YJBC-256-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJBC-256-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-20251024-0001','1','E2E-YJBC-257-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJBC-257-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJBC-257-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-10-24 08:02:13' WHERE kode_barang='E2E-YJBC-257-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJBC-257-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 ('2025-10-24 08:02:13','TOKO','PM-E','E2E','E2E-YJBC-257-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-YJBC-257-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJBC-257-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251024-0001','2025-10-24','08:02','36.440','admpindah','2025-10-24 08:02:12');
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-20251024-0001','1','F1E-YJBC-244-0','1','2.060','2.060','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YJBC-244-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YJBC-244-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-10-24 08:02:45' WHERE kode_barang='F1E-YJBC-244-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YJBC-244-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 ('2025-10-24 08:02:45','TOKO','PM-F','F1E','F1E-YJBC-244-0','1','2.060','2.060','1','2.060','2.060','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-YJBC-244-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YJBC-244-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-20251024-0001','1','F1E-YJBC-245-0','1','2.080','2.080','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YJBC-245-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YJBC-245-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-10-24 08:02:45' WHERE kode_barang='F1E-YJBC-245-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YJBC-245-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 ('2025-10-24 08:02:45','TOKO','PM-F','F1E','F1E-YJBC-245-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-YJBC-245-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YJBC-245-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-20251024-0001','1','F1E-YJBC-246-0','1','2.110','2.110','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YJBC-246-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YJBC-246-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-10-24 08:02:45' WHERE kode_barang='F1E-YJBC-246-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YJBC-246-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 ('2025-10-24 08:02:45','TOKO','PM-F','F1E','F1E-YJBC-246-0','1','2.110','2.110','1','2.110','2.110','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-YJBC-246-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YJBC-246-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251024-0001','2025-10-24','08:02','6.250','admpindah','2025-10-24 08:02:45');
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-20251024-0001','1','H2J-YIBC-435-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YIBC-435-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YIBC-435-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H2J-YIBC-435-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YIBC-435-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 ('2025-10-24 08:03:06','TOKO','PM-H','H2J','H2J-YIBC-435-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YIBC-435-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YIBC-435-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-20251024-0001','1','H1E-YJXA-317-0','1','0.870','0.870','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YJXA-317-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YJXA-317-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H1E-YJXA-317-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YJXA-317-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 ('2025-10-24 08:03:06','TOKO','PM-H','H1E','H1E-YJXA-317-0','1','0.870','0.870','1','0.870','0.870','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-YJXA-317-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YJXA-317-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-20251024-0001','1','H2I-YJXA-332-0','1','1.510','1.510','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YJXA-332-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YJXA-332-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H2I-YJXA-332-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YJXA-332-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 ('2025-10-24 08:03:06','TOKO','PM-H','H2I','H2I-YJXA-332-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YJXA-332-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YJXA-332-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-20251024-0001','1','H1F-YJXB-259-0','1','3.000','3.000','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YJXB-259-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YJXB-259-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H1F-YJXB-259-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YJXB-259-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 ('2025-10-24 08:03:06','TOKO','PM-H','H1F','H1F-YJXB-259-0','1','3.000','3.000','1','3.000','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YJXB-259-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YJXB-259-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-20251024-0001','1','H1F-YJAA-191-0','1','2.100','2.100','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YJAA-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YJAA-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H1F-YJAA-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YJAA-191-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 ('2025-10-24 08:03:06','TOKO','PM-H','H1F','H1F-YJAA-191-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YJAA-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YJAA-191-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-20251024-0001','1','H2J-YJAC-108-0','1','2.070','2.070','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YJAC-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YJAC-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H2J-YJAC-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YJAC-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 ('2025-10-24 08:03:06','TOKO','PM-H','H2J','H2J-YJAC-108-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YJAC-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YJAC-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-20251024-0001','1','H2J-YJAC-111-0','1','1.930','1.930','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YJAC-111-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YJAC-111-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H2J-YJAC-111-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YJAC-111-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 ('2025-10-24 08:03:06','TOKO','PM-H','H2J','H2J-YJAC-111-0','1','1.930','1.930','1','1.930','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YJAC-111-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YJAC-111-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-20251024-0001','1','H2I-YJAC-116-0','1','1.900','1.900','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YJAC-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YJAC-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H2I-YJAC-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YJAC-116-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:03:06','TOKO','PM-H','H2I','H2I-YJAC-116-0','1','1.900','1.900','1','1.900','1.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YJAC-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YJAC-116-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','H1F-YJAF-202-0','1','2.110','2.110','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YJAF-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YJAF-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H1F-YJAF-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YJAF-202-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-24 08:03:06','TOKO','PM-H','H1F','H1F-YJAF-202-0','1','2.110','2.110','1','2.110','2.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YJAF-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YJAF-202-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251024-0001','1','H1F-YJBA-224-0','1','3.070','3.070','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YJBA-224-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YJBA-224-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-10-24 08:03:06' WHERE kode_barang='H1F-YJBA-224-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YJBA-224-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 ('2025-10-24 08:03:06','TOKO','PM-H','H1F','H1F-YJBA-224-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YJBA-224-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YJBA-224-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251024-0001','2025-10-24','08:02','20.610','admpindah','2025-10-24 08:03:05');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251024-0001','1','E2TE-YFAA-81-T','1','2.030','TOKO','TBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TE-YFAA-81-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TE-YFAA-81-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='E2TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TE' 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='E2TE-YFAA-81-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='E2TE-YFAA-81-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-251024-0001','2025-10-24','2025-10-24','08:18','2.030','admpindah','251024');
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 ('F325240915461','input','1',' MEE2 HW 17','TOKO','PM-E','E2E-YJAF-186-0','CC MODEL MATA HW 17 8K ','','0.480','1','100.00','506000','0','0','15000','505000','0','0','0','505000','AAT','00373503','E2E','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAF-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='E2E-YJAF-186-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 ('F325240915461','2025-10-24','0.480','2025-10-24','09:15:47','PLG0025375','505000','505000','0','505000','505000','input','2025-10-24 09:15:46','F32524091546');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325240915461','2025-10-24','09:15:47','AAT','505000','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-251024-0002','D','2025-10-24','09:15:47','input','PENJUALAN','F325240915461','436761000','505000','437266000');
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 ('F325240928131','input','1',' MEA1E X PM','TOKO','PM-A','A1E-YJBA-66-0','AT X ITALY SLEP VAR PM 8K ','','0.520','1','100.00','549000','0','0','15000','550000','0','0','0','550000','FIT','00373943','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBA-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='A1E-YJBA-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325240928131','2025-10-24','0.520','2025-10-24','09:28:14','PLG0025376','550000','550000','0','550000','550000','input','2025-10-24 09:28:13','F32524092813');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325240928131','2025-10-24','09:28:14','FIT','550000','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-251024-0003','D','2025-10-24','09:28:14','input','PENJUALAN','F325240928131','437266000','550000','437816000');
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 ('F325240950191','input','1',' MEF3 PM ','TOKO','PM-F','F3E-YJXF-26-0','GL ANAK MODEL DAUN VAR PM 8K ','','2.190','1','100.00','2310000','0','0','15000','2310000','0','0','0','2310000','SIN','00372323','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='F3E-YJXF-26-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 ('F325240950191','2025-10-24','2.190','2025-10-24','09:50:19','PLG0025377','2310000','2310000','0','2310000','2310000','input','2025-10-24 09:50:19','F32524095019');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325240950191','2025-10-24','09:50:19','SIN','2310000','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-251024-0004','D','2025-10-24','09:50:19','input','PENJUALAN','F325240950191','437816000','2310000','440126000');
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 ('F325241009071','input','1',' MIF4I XX U','TOKO','PM-F','F4I-YIAG-95-0','GL XX KOREA SLEP UB 9K','','0.420','1','100.00','477000','0','0','15000','477000','0','0','0','477000','SIN','00369877','F4I','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YIAG-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='F4I-YIAG-95-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 ('F325241009071','2025-10-24','0.420','2025-10-24','10:09:07','PLG0025378','477000','477000','0','477000','477000','input','2025-10-24 10:09:07','F32524100907');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325241009071','2025-10-24','10:09:07','SIN','477000','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-251024-0005','D','2025-10-24','10:09:07','input','PENJUALAN','F325241009071','440126000','477000','440603000');
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 ('F325241028271','input','1',' MEF3E X HW','TOKO','PM-F','F3E-YJXB-232-0','GL X CAPELLA SLEP HW 8K ','','1.760','1','100.00','1857000','0','0','15000','1858000','0','0','0','1858000','AAT','00371816','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXB-232-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='F3E-YJXB-232-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 ('F325241028271','2025-10-24','1.760','2025-10-24','10:28:28','PLG0025379','1858000','1858000','0','1858000','1858000','input','2025-10-24 10:28:27','F32524102827');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325241028271','2025-10-24','10:28:28','AAT','1858000','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-251024-0006','D','2025-10-24','10:28:28','input','PENJUALAN','F325241028271','440603000','1858000','442461000');
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 ('F325241101341','input','1',' MEF3 HW ','TOKO','PM-F','F3E-YEBD-103-0','GL SANTA MODEL PITA VAR HW 8K ','','1.340','1','100.00','1414000','0','0','15000','1415000','0','0','0','1415000','SIN','00355190','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YEBD-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='F3E-YEBD-103-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 ('F325241101341','2025-10-24','1.340','2025-10-24','11:01:35','PLG0025380','1415000','1415000','0','1415000','1415000','input','2025-10-24 11:01:34','F32524110134');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325241101341','2025-10-24','11:01:35','SIN','1415000','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-251024-0007','D','2025-10-24','11:01:35','input','PENJUALAN','F325241101341','442461000','1415000','443876000');
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 ('F325241212121','input','1',' MEF3E X LT','TOKO','PM-F','F3E-YIBD-199-0','GL X TIFF SLEP LT 8K ','','1.000','1','100.00','1055000','0','0','15000','1055000','0','0','0','1055000','SIN','00370620','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBD-199-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='F3E-YIBD-199-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 ('F325241212121','2025-10-24','1.000','2025-10-24','12:12:13','PLG0025381','1055000','1055000','0','1055000','1055000','input','2025-10-24 12:12:12','F32524121212');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325241212121','2025-10-24','12:12:13','SIN','1055000','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-251024-0008','D','2025-10-24','12:12:13','input','PENJUALAN','F325241212121','443876000','1055000','444931000');
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 ('F325240121311','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-YJBC-179-0','CC X VELG POLOS OR 14 8K ','','1.040','1','100.00','1082000','0','0','15000','1075000','0','0','0','1075000','SIN','00374497','E1D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBC-179-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='E1D-YJBC-179-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 ('F325240121311','2025-10-24','1.040','2025-10-24','13:21:32','PLG0025382','1075000','1075000','0','1075000','1075000','input','2025-10-24 13:21:31','F32524012131');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325240121311','2025-10-24','13:21:32','SIN','1075000','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-251024-0009','D','2025-10-24','13:21:32','input','PENJUALAN','F325240121311','444931000','1075000','446006000');
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-00017300','X-00017300','CC MODEL MATA UB 16 8K','GR','---','E2D','BELI','BELI001','645000','2025-10-24','0.950','1','kasir','2025-10-24 13:41:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017300','X-00017300');
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-251024-0001','F324160933302','AAT','1','BELI','BELI001','E2D', 'X-00017300', 'CC MODEL MATA UB 16 8K','0.950','0.950','100.00','623000','645000','678947','1040000','1','645000','645000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251024-0001','2025-10-24','2025-10-24','13:41:34','AAT','---','0.950','645000','645000','645000','645000','645000','kasir','2025-10-24 13:41:35','FB-251024-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251024-0001','JENI','BIITING','','','','kasir','2025-10-24 13:41:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-24' 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-251024-0010','K','2025-10-24','13:41:34','kasir','PEMBELIAN UMUM','FB-251024-0001','446006000','645000','445361000');
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-00017301','X-00017301','CC X WEDDING MATA SLEP BM 16','GR','---','E2TE','BELI','BELI001','4465000','2025-10-24','2.980','1','kasir','2025-10-24 13:46:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017301','X-00017301');
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-251024-0002','F324180127581','AAT','1','BELI','BELI001','E2TE', 'X-00017301', 'CC X WEDDING MATA SLEP BM 16','2.980','2.980','100.00','3368000','4465000','1498322','1885000','1','4465000','4465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.980',berat_beli_asli=berat_beli_asli+'2.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.980',berat_akhir_asli=berat_akhir_asli+'2.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251024-0002','2025-10-24','2025-10-24','13:46:00','AAT','---','2.980','4465000','4465000','4465000','4465000','4465000','kasir','2025-10-24 13:46:01','FB-251024-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251024-0002','BU ARIS','NGANDONG KEPYAR','','','','kasir','2025-10-24 13:46:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-24' 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-251024-0011','K','2025-10-24','13:46:00','kasir','PEMBELIAN UMUM','FB-251024-0002','445361000','4465000','440896000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251024-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251024-0002';
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-00017302','X-00017302','CC X WEDDING MATA SLEP BM 16','GR','---','E2TE','BELI','BELI001','4465000','2025-10-24','2.980','1','kasir','2025-10-24 13:49:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017302','X-00017302');
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-251024-0002','F324180127581','SIN','1','BELI','BELI001','E2TE', 'X-00017302', 'CC X WEDDING MATA SLEP BM 16','2.980','2.980','100.00','3368000','4465000','1498322','1885000','1','4465000','4465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.980',berat_beli_asli=berat_beli_asli+'2.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.980',berat_akhir_asli=berat_akhir_asli+'2.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251024-0002','2025-10-24','2025-10-24','13:49:45','SIN','---','2.980','4465000','4465000','4465000','4465000','4465000','kasir','2025-10-24 13:49:45','FB-251024-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251024-0002','BU ARIS','NGANDONG KEPYAR','','','','kasir','2025-10-24 13:49:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-24' 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-251024-0013','K','2025-10-24','13:49:45','kasir','PEMBELIAN UMUM','FB-251024-0002','445361000','4465000','440896000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251024-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251024-0001';
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-00017303','X-00017303','CC MODEL MATA UB 16 8K','GR','---','E2D','BELI','BELI001','645000','2025-10-24','0.950','1','kasir','2025-10-24 13:52:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017303','X-00017303');
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-251024-0003','F324160933302','AAT','1','BELI','BELI001','E2D', 'X-00017303', 'CC MODEL MATA UB 16 8K','0.950','0.950','100.00','623000','645000','678947','1040000','1','645000','645000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251024-0003','2025-10-24','2025-10-24','13:52:15','AAT','---','0.950','645000','645000','645000','645000','645000','kasir','2025-10-24 13:52:16','FB-251024-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251024-0003','JENI','BIITING','','','','kasir','2025-10-24 13:52:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-24' 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-251024-0015','K','2025-10-24','13:52:15','kasir','PEMBELIAN UMUM','FB-251024-0003','441541000','645000','440896000');
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 ('F325240304581','input','1',' MEE2 LG 14','TOKO','PM-E','E2E-XDXG-36-0','CC MODEL MATA VAR LG 14 8K ','','1.050','1','100.00','1108000','0','0','15000','1110000','0','0','0','1110000','AAT','00290986','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-XDXG-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-24' AND kode_barang='E2E-XDXG-36-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 ('F325240304581','2025-10-24','1.050','2025-10-24','15:04:59','PLG0025383','1110000','1110000','0','1110000','1110000','input','2025-10-24 15:04:58','F32524030458');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-24','F325240304581','2025-10-24','15:04:59','AAT','1110000','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-251024-0016','D','2025-10-24','15:04:59','input','PENJUALAN','F325240304581','440896000','1110000','442006000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240121311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240121311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240121311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240304581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240304581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240304581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240915461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240915461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240915461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240928131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240928131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240928131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325240950191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325240950191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325240950191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241009071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241009071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241009071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241028271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241028271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241028271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241101341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241101341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241101341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325241212121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325241212121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325241212121';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251024-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251024-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251024-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251024-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-24';
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='2025-10-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-24' 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-251025-0001','D','2025-10-25','15:42:49','SYSTEM','SALDO AWAL','SALDO AWAL','0','442006000','442006000');
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-251025-0001','D','2025-10-25','15:42:49','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-251025-0001','D','2025-10-25','15:42:49','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-251025-0001','D','2025-10-25','15:42:49','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-10-25';