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-20261027-0001','1','A1G-ZJXF-274-0','1','0.270','0.270','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1G-ZJXF-274-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZJXF-274-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-27 07:55:22' WHERE kode_barang='A1G-ZJXF-274-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZJXF-274-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:22','TOKO','PM-A','A1G','A1G-ZJXF-274-0','1','0.270','0.270','1','0.270','0.270','100.00'); DELETE FROM tm_dept WHERE kode_dept='A1G' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1G' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1G-ZJXF-274-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZJXF-274-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','A1D-ZJBF-124-0','1','1.030','1.030','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1D-ZJBF-124-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZJBF-124-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-27 07:55:22' WHERE kode_barang='A1D-ZJBF-124-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZJBF-124-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:22','TOKO','PM-A','A1D','A1D-ZJBF-124-0','1','1.030','1.030','1','1.030','1.030','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-ZJBF-124-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZJBF-124-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','A1E-ZJBF-191-0','1','0.600','0.600','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1E-ZJBF-191-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZJBF-191-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-27 07:55:22' WHERE kode_barang='A1E-ZJBF-191-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZJBF-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 ('2026-10-27 07:55:22','TOKO','PM-A','A1E','A1E-ZJBF-191-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-ZJBF-191-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZJBF-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-20261027-0001','1','A1E-ZJBF-192-0','1','0.610','0.610','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1E-ZJBF-192-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZJBF-192-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-27 07:55:22' WHERE kode_barang='A1E-ZJBF-192-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZJBF-192-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:22','TOKO','PM-A','A1E','A1E-ZJBF-192-0','1','0.610','0.610','1','0.610','0.610','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-ZJBF-192-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZJBF-192-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:55','2.510','admpindah','2026-10-27 07:55:22'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','B1E-ZJBF-90-0','1','0.610','0.610','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1E-ZJBF-90-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJBF-90-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-27 07:55:40' WHERE kode_barang='B1E-ZJBF-90-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJBF-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 ('2026-10-27 07:55:40','TOKO','PM-B','B1E','B1E-ZJBF-90-0','1','0.610','0.610','1','0.610','0.610','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-ZJBF-90-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJBF-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-20261027-0001','1','B1E-ZJBF-146-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1E-ZJBF-146-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJBF-146-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-27 07:55:40' WHERE kode_barang='B1E-ZJBF-146-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJBF-146-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:40','TOKO','PM-B','B1E','B1E-ZJBF-146-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-ZJBF-146-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJBF-146-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','B1G-ZJBF-151-0','1','0.260','0.260','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1G-ZJBF-151-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZJBF-151-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-27 07:55:40' WHERE kode_barang='B1G-ZJBF-151-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZJBF-151-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:40','TOKO','PM-B','B1G','B1G-ZJBF-151-0','1','0.260','0.260','1','0.260','0.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZJBF-151-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZJBF-151-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:55','1.370','admpindah','2026-10-27 07:55:40'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','D1G-ZJBF-161-0','1','0.300','0.300','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1G-ZJBF-161-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZJBF-161-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1G-ZJBF-161-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZJBF-161-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1G','D1G-ZJBF-161-0','1','0.300','0.300','1','0.300','0.300','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZJBF-161-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZJBF-161-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-20261027-0001','1','D1E-ZJBF-194-0','1','0.600','0.600','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJBF-194-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-194-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1E-ZJBF-194-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJBF-194-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1E','D1E-ZJBF-194-0','1','0.600','0.600','1','0.600','0.600','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJBF-194-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-194-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-20261027-0001','1','D1E-ZJBF-195-0','1','0.510','0.510','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJBF-195-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-195-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1E-ZJBF-195-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJBF-195-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1E','D1E-ZJBF-195-0','1','0.510','0.510','1','0.510','0.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJBF-195-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-195-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','D1F-ZJBF-196-0','1','0.370','0.370','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1F-ZJBF-196-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZJBF-196-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1F-ZJBF-196-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZJBF-196-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1F','D1F-ZJBF-196-0','1','0.370','0.370','1','0.370','0.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZJBF-196-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZJBF-196-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','D1E-ZJBF-197-0','1','0.780','0.780','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJBF-197-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-197-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1E-ZJBF-197-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJBF-197-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1E','D1E-ZJBF-197-0','1','0.780','0.780','1','0.780','0.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJBF-197-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-197-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','D1E-ZJBF-198-0','1','0.560','0.560','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJBF-198-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-198-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1E-ZJBF-198-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJBF-198-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1E','D1E-ZJBF-198-0','1','0.560','0.560','1','0.560','0.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJBF-198-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJBF-198-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','D1F-ZJBF-199-0','1','0.750','0.750','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1F-ZJBF-199-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZJBF-199-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-27 07:55:58' WHERE kode_barang='D1F-ZJBF-199-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZJBF-199-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:55:58','TOKO','PM-D','D1F','D1F-ZJBF-199-0','1','0.750','0.750','1','0.750','0.750','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZJBF-199-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZJBF-199-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:55','3.870','admpindah','2026-10-27 07:55:57'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E1E-ZIBA-152-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZIBA-152-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIBA-152-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1E-ZIBA-152-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIBA-152-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1E','E1E-ZIBA-152-0','1','0.520','0.520','1','0.520','0.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZIBA-152-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIBA-152-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-20261027-0001','1','E2D-ZIBF-314-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZIBF-314-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-314-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2D-ZIBF-314-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIBF-314-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2D','E2D-ZIBF-314-0','1','1.550','1.550','1','1.550','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZIBF-314-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-314-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E2D-ZJXH-119-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-119-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-119-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2D-ZJXH-119-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-119-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2D','E2D-ZJXH-119-0','1','1.550','1.550','1','1.550','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXH-119-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-119-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-20261027-0001','1','E1F-ZJAF-270-0','1','0.390','0.390','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJAF-270-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJAF-270-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJAF-270-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJAF-270-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJAF-270-0','1','0.390','0.390','1','0.390','0.390','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJAF-270-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJAF-270-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E2D-ZJBF-204-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBF-204-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-204-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2D-ZJBF-204-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBF-204-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2D','E2D-ZJBF-204-0','1','1.550','1.550','1','1.550','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBF-204-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-204-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E2D-ZJBF-205-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBF-205-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-205-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2D-ZJBF-205-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBF-205-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2D','E2D-ZJBF-205-0','1','1.550','1.550','1','1.550','1.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBF-205-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-205-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E2D-ZJBF-206-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJBF-206-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-206-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2D-ZJBF-206-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJBF-206-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2D','E2D-ZJBF-206-0','1','1.530','1.530','1','1.530','1.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJBF-206-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJBF-206-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','E2E-ZJBF-207-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJBF-207-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJBF-207-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2E-ZJBF-207-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJBF-207-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2E','E2E-ZJBF-207-0','1','0.480','0.480','1','0.480','0.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJBF-207-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJBF-207-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-20261027-0001','1','E2E-ZJBF-208-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJBF-208-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJBF-208-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E2E-ZJBF-208-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJBF-208-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E2E','E2E-ZJBF-208-0','1','0.460','0.460','1','0.460','0.460','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-ZJBF-208-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJBF-208-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-20261027-0001','1','E1F-ZJBF-210-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-210-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-210-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-210-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-210-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-210-0','1','0.400','0.400','1','0.400','0.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-210-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-210-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-20261027-0001','1','E1F-ZJBF-211-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-211-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-211-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-211-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-211-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-211-0','1','0.400','0.400','1','0.400','0.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-211-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-211-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-20261027-0001','1','E1F-ZJBF-212-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-212-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-212-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-212-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-212-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-212-0','1','0.410','0.410','1','0.410','0.410','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-212-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-212-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-20261027-0001','1','E1F-ZJBF-213-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-213-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-213-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-213-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-213-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-213-0','1','0.410','0.410','1','0.410','0.410','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-213-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-213-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-20261027-0001','1','E1F-ZJBF-215-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-215-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-215-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-215-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-215-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-215-0','1','0.370','0.370','1','0.370','0.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-215-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-215-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-20261027-0001','1','E1F-ZJBF-216-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJBF-216-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-216-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-27 07:56:14' WHERE kode_barang='E1F-ZJBF-216-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJBF-216-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:14','TOKO','PM-E','E1F','E1F-ZJBF-216-0','1','0.350','0.350','1','0.350','0.350','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJBF-216-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJBF-216-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:56','11.920','admpindah','2026-10-27 07:56:14'); 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-20261027-0001','1','F3E-ZJBF-87-0','1','2.180','2.180','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-87-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-87-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-87-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-87-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-87-0','1','2.180','2.180','1','2.180','2.180','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-87-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-87-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-20261027-0001','1','F3E-ZJBF-88-0','1','2.470','2.470','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-88-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-88-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-88-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-88-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-88-0','1','2.470','2.470','1','2.470','2.470','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-88-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-88-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-20261027-0001','1','F3E-ZJBF-89-0','1','2.770','2.770','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-89-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-89-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-89-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-89-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-89-0','1','2.770','2.770','1','2.770','2.770','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-89-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-89-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','F3E-ZJBF-91-0','1','0.770','0.770','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-91-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-91-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-91-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-91-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-91-0','1','0.770','0.770','1','0.770','0.770','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-91-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-91-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','F3E-ZJBF-92-0','1','0.810','0.810','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-92-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-92-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-92-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-92-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-92-0','1','0.810','0.810','1','0.810','0.810','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-92-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-92-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','F3E-ZJBF-94-0','1','0.700','0.700','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-94-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-94-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-94-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-94-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-94-0','1','0.700','0.700','1','0.700','0.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-94-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-94-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-20261027-0001','1','F3E-ZJBF-95-0','1','0.680','0.680','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-95-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-95-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-95-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-95-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-95-0','1','0.680','0.680','1','0.680','0.680','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-95-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-95-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','F1E-ZJBF-187-0','1','5.180','5.180','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJBF-187-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJBF-187-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F1E-ZJBF-187-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJBF-187-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F1E','F1E-ZJBF-187-0','1','5.180','5.180','1','5.180','5.180','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-ZJBF-187-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJBF-187-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-20261027-0001','1','F1E-ZJBF-193-0','1','2.750','2.750','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJBF-193-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJBF-193-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F1E-ZJBF-193-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJBF-193-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F1E','F1E-ZJBF-193-0','1','2.750','2.750','1','2.750','2.750','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-ZJBF-193-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJBF-193-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','F2E-ZJBF-200-0','1','2.080','2.080','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F2E-ZJBF-200-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZJBF-200-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F2E-ZJBF-200-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZJBF-200-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F2E','F2E-ZJBF-200-0','1','2.080','2.080','1','2.080','2.080','100.00'); DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZJBF-200-0'; DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZJBF-200-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-20261027-0001','1','F2E-ZJBF-202-0','1','3.260','3.260','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F2E-ZJBF-202-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZJBF-202-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F2E-ZJBF-202-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZJBF-202-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F2E','F2E-ZJBF-202-0','1','3.260','3.260','1','3.260','3.260','100.00'); DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZJBF-202-0'; DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZJBF-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-20261027-0001','1','F3E-ZJBF-220-0','1','2.210','2.210','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-220-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-220-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-220-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-220-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-220-0','1','2.210','2.210','1','2.210','2.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-220-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-220-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-20261027-0001','1','F3E-ZJBF-228-0','1','3.010','3.010','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-228-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-228-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-228-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-228-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-228-0','1','3.010','3.010','1','3.010','3.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-228-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-228-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-20261027-0001','1','F3E-ZJBF-229-0','1','2.120','2.120','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-229-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-229-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-229-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-229-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-229-0','1','2.120','2.120','1','2.120','2.120','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-229-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-229-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-20261027-0001','1','F3E-ZJBF-235-0','1','3.940','3.940','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJBF-235-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-235-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-27 07:56:37' WHERE kode_barang='F3E-ZJBF-235-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJBF-235-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:37','TOKO','PM-F','F3E','F3E-ZJBF-235-0','1','3.940','3.940','1','3.940','3.940','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJBF-235-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJBF-235-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:56','34.930','admpindah','2026-10-27 07:56:37'); 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-20261027-0001','1','H1E-ZJBF-84-0','1','1.520','1.520','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-84-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-84-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-84-0','1','1.520','1.520','1','1.520','1.520','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-ZJBF-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-84-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261027-0001','1','H1E-ZJBF-85-0','1','2.210','2.210','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-85-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-85-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-85-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-85-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-85-0','1','2.210','2.210','1','2.210','2.210','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-ZJBF-85-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-85-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-20261027-0001','1','H1E-ZJBF-86-0','1','1.860','1.860','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-86-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-86-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-86-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-86-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-86-0','1','1.860','1.860','1','1.860','1.860','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-ZJBF-86-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-86-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-20261027-0001','1','H1E-ZJBF-189-0','1','2.020','2.020','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-189-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-189-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-189-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-189-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-189-0','1','2.020','2.020','1','2.020','2.020','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-ZJBF-189-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-189-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-20261027-0001','1','H1E-ZJBF-236-0','1','0.920','0.920','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-236-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-236-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-236-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-236-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-236-0','1','0.920','0.920','1','0.920','0.920','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-ZJBF-236-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-236-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-20261027-0001','1','H1E-ZJBF-237-0','1','2.210','2.210','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-237-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-237-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-237-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-237-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-237-0','1','2.210','2.210','1','2.210','2.210','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-ZJBF-237-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-237-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-20261027-0001','1','H1E-ZJBF-241-0','1','1.850','1.850','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-241-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-241-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-241-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-241-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-241-0','1','1.850','1.850','1','1.850','1.850','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-ZJBF-241-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-241-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-20261027-0001','1','H1E-ZJBF-243-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJBF-243-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-243-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H1E-ZJBF-243-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJBF-243-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:56:59','TOKO','PM-H','H1E','H1E-ZJBF-243-0','1','2.050','2.050','1','2.050','2.050','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-ZJBF-243-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJBF-243-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-20261027-0001','1','H2J-ZJBF-258-0','1','1.110','1.110','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H2J-ZJBF-258-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZJBF-258-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-27 07:56:59' WHERE kode_barang='H2J-ZJBF-258-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZJBF-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 ('2026-10-27 07:56:59','TOKO','PM-H','H2J','H2J-ZJBF-258-0','1','1.110','1.110','1','1.110','1.110','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-ZJBF-258-0'; DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZJBF-258-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:56','15.750','admpindah','2026-10-27 07:56:59'); 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-20261027-0001','1','PEF-ZJBF-120-0','1','1.360','1.360','TOKO','PMBK-P','TOKO','PM-P'); DELETE FROM tm_barang WHERE kode_barang='PEF-ZJBF-120-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PEF-ZJBF-120-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2026-10-27 07:57:21' WHERE kode_barang='PEF-ZJBF-120-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PEF-ZJBF-120-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-27 07:57:21','TOKO','PM-P','PEF','PEF-ZJBF-120-0','1','1.360','1.360','1','1.360','1.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='PEF' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PEF' 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='PEF-ZJBF-120-0'; DELETE FROM tm_barang_export WHERE kode_barang='PEF-ZJBF-120-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261027-0001','2026-10-27','07:57','1.360','admpindah','2026-10-27 07:57:21'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326270951321','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YKBH-105-0','CC MODEL BUNGA VAR CM 14 8K ','','1.500','1','100.00','1507000','0','0','15000','1508000','0','0','0','1508000','FIT','00378966','E1D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBH-105-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='E1D-YKBH-105-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 ('F326270951321','2026-10-27','1.500','2026-10-27','09:51:32','PLG0032072','1508000','1508000','0','1508000','1508000','input','2026-10-27 09:51:32','F32627095132'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326270951321','2026-10-27','09:51:32','FIT','1508000','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-261027-0002','D','2026-10-27','09:51:32','input','PENJUALAN','F326270951321','7995320000','1508000','7996828000'); 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 ('F326271052151','input','1',' TDA1 UB ','TOKO','PT-A','A1TD-ZJXE-253-T','AT MODEL KLIP ARESO UB 17K ','','0.900','1','100.00','1683000','0','0','15000','1683000','0','0','0','1683000','LIS','T0085763','A1TD','0','0','-','0','1870000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-ZJXE-253-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='A1TD-ZJXE-253-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326271052151','2026-10-27','0.900','2026-10-27','10:52:15','PLG0032073','1683000','1683000','0','1683000','1683000','input','2026-10-27 10:52:15','F32627105215'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326271052151','2026-10-27','10:52:15','LIS','1683000','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-261027-0003','D','2026-10-27','10:52:15','input','PENJUALAN','F326271052151','7996828000','1683000','7998511000'); 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 ('F326271234171','input','1',' MDE1 X BG ','TOKO','PM-E','E1D-ZBXF-160-0','CC X MODEL SLEP BG 16 8K ','','1.090','1','100.00','1095000','0','0','15000','1095000','0','0','0','1095000','AAT','00388742','E1D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXF-160-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='E1D-ZBXF-160-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 ('F326271234171','2026-10-27','1.090','2026-10-27','12:34:18','PLG0032074','1095000','1095000','0','1095000','1095000','input','2026-10-27 12:34:17','F32627123417'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326271234171','2026-10-27','12:34:18','AAT','1095000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261027-0004','D','2026-10-27','12:34:18','input','PENJUALAN','F326271234171','7998511000','1095000','7999606000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1095000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271234171' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326271234172','input',' 1',' MEE2 X KH ','TOKO','PM-E','E2E-ZJAE-176-0','CC X MODEL SNAKE MATA KH 14 8K ','','0.500','1','100.00','512000','0','0','15000','513000','0','0','0','513000','AAT','00430059','E2E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJAE-176-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='E2E-ZJAE-176-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 ('F326271234172','2026-10-27','0.500','2026-10-27','12:34:18','PLG0032075','513000','513000','0','513000','513000','input','2026-10-27 12:34:17','F32627123417'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326271234172','2026-10-27','12:34:18','AAT','513000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261027-0005','D','2026-10-27','12:34:18','input','PENJUALAN','F326271234172','7999606000','513000','8000119000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271234172' LIMIT 1; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020655','X-00020655','LT X MODEL MATA JP 8K','GR','---','D2D','BELI','BELI001','785000','2026-10-27','0.840','1','kasir','2026-10-27 12:38:49'); DELETE FROM tp_barang WHERE kode_dept = 'X-D2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00020655','X-00020655'); 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-261027-0001','F325061214061','SIN','1','BELI','BELI001','D2D', 'X-00020655', 'LT X MODEL MATA JP 8K','0.840','0.840','100.00','845000','785000','934524','1015000','1','785000','785000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.840',berat_beli_asli=berat_beli_asli+'0.840',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.840',berat_akhir_asli=berat_akhir_asli+'0.840',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-261027-0001','2026-10-27','2026-10-27','12:38:48','SIN','---','0.840','785000','785000','785000','785000','785000','kasir','2026-10-27 12:38:49','FB-261027-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261027-0001','RUSMINI','BANDAR PCT','','','085236766481','kasir','2026-10-27 12:38:49'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-27' 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-261027-0006','K','2026-10-27','12:38:48','kasir','PEMBELIAN UMUM','FB-261027-0001','8000119000','785000','7999334000'); 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 ('F326271251281','kasir','1',' MEA1 LG ','TOKO','PM-A','A1E-YJXD-285-0','AT GYPSY HATI VAR LG 8K ','','0.550','1','100.00','564000','0','0','15000','565000','0','0','0','565000','SIN','00372265','A1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-285-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='A1E-YJXD-285-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 ('F326271251281','2026-10-27','0.550','2026-10-27','12:51:28','PLG0032076','565000','565000','0','565000','565000','kasir','2026-10-27 12:51:28','F32627125128'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326271251281','2026-10-27','12:51:28','SIN','565000','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-261027-0007','D','2026-10-27','12:51:28','kasir','PENJUALAN','F326271251281','7999334000','565000','7999899000'); 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-00020656','X-00020656','CC MODEL MATA UB 12','GR','---','E2TE','BELI','BELI001','2565000','2026-10-27','1.760','1','kasir','2026-10-27 14:22:46'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00020656','X-00020656'); 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-261027-0002','F322011240491','LIS','1','BELI','BELI001','E2TE', 'X-00020656', 'CC MODEL MATA UB 12','1.760','1.760','100.00','1285000','2565000','1457386','1890000','1','2565000','2565000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-27' 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-261027-0002','2026-10-27','2026-10-27','14:22:45','LIS','---','1.760','2565000','2565000','2565000','2565000','2565000','kasir','2026-10-27 14:22:46','FB-261027-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261027-0002','EKO','PUHPELEM','','','','kasir','2026-10-27 14:22:46'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-27' 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-261027-0008','K','2026-10-27','14:22:45','kasir','PEMBELIAN UMUM','FB-261027-0002','7999899000','2565000','7997334000'); 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 ('F326270233111','input','1',' MEF3E X YT','TOKO','PM-F','F3E-ZIBF-242-0','GL X SANTA DAUN SERUT YT 8K ','','2.310','1','100.00','2368000','0','0','15000','2368000','0','0','0','2368000','AAT','00425860','F3E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBF-242-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-10-27' AND kode_barang='F3E-ZIBF-242-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 ('F326270233111','2026-10-27','2.310','2026-10-27','14:33:11','PLG0032077','2368000','2368000','0','2368000','2368000','input','2026-10-27 14:33:11','F32627023311'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-27','F326270233111','2026-10-27','14:33:11','AAT','2368000','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-261027-0009','D','2026-10-27','14:33:11','input','PENJUALAN','F326270233111','7997334000','2368000','7999702000'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261027-0001','1','E2D-ZDBA-90-0','1','1.320','1.320','TOKO','PM-E','TOKO','SBK-E'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-E' WHERE kode_barang='E2D-ZDBA-90-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-27','TOKO','SBK-E','E2D','E2D-ZDBA-90-0','100.00','1','1.320','1.320','1','1.320','1.320'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.320',berat_out_asli=berat_out_asli+'1.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-27' AND kode_barang='E2D-ZDBA-90-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261027-0001','2026-10-27','2026-10-27','14:39','1.32','input','2026-10-27 14:39:51'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261027-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261027-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261027-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261027-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270233111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270233111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270233111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270951321' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270951321' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270951321'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271052151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271052151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271052151'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271234171' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271234171' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271234171'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271234172' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271234172' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271234172'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271251281' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271251281' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271251281'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-28','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-27'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-27'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-27'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-27' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-27'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-27'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-27'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-27'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-28' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-27' 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-261028-0001','D','2026-10-28','15:07:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','7999702000','7999702000'); 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-261028-0001','D','2026-10-28','15:07:30','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-261028-0001','D','2026-10-28','15:07:30','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261028-0001','D','2026-10-28','15:07:30','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-10-28';