INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261117-0001','1','H2TE-ZJCX-24-T','1','1.330','TOKO','TBK-H'); DELETE FROM tm_barang_export WHERE kode_barang='H2TE-ZJCX-24-T' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H2TE-ZJCX-24-T' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='TE' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='H2TE' LIMIT 1; INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H2TE' LIMIT 1; DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TBK-H'; INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TBK-H'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H2TE-ZJCX-24-T'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.330',berat_out_asli='1.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.330',berat_akhir_asli =berat_akhir_asli-'1.330' WHERE kode_barang='H2TE-ZJCX-24-T' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261117-0001','2026-11-17','2026-11-17','07:56','1.330','admpindah','261117'); 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-20261117-0001','1','E1E-ZJXF-331-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXF-331-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-331-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-17 07:58:17' WHERE kode_barang='E1E-ZJXF-331-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXF-331-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-11-17 07:58:17','TOKO','PM-E','E1E','E1E-ZJXF-331-0','1','0.410','0.410','1','0.410','0.410','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-ZJXF-331-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-331-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261117-0001','2026-11-17','07:58','0.410','admpindah','2026-11-17 07:58:16'); 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-20261117-0001','1','F1E-ZKXD-55-0','1','1.880','1.880','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZKXD-55-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZKXD-55-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F1E-ZKXD-55-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZKXD-55-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-11-17 07:58:35','TOKO','PM-F','F1E','F1E-ZKXD-55-0','1','1.880','1.880','1','1.880','1.880','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-ZKXD-55-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZKXD-55-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-20261117-0001','1','F3E-ZKAX-200-0','1','4.150','4.150','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAX-200-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAX-200-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F3E-ZKAX-200-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAX-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-11-17 07:58:35','TOKO','PM-F','F3E','F3E-ZKAX-200-0','1','4.150','4.150','1','4.150','4.150','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKAX-200-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAX-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-20261117-0001','1','F1E-ZKAF-70-0','1','2.320','2.320','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZKAF-70-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZKAF-70-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F1E-ZKAF-70-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZKAF-70-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-11-17 07:58:35','TOKO','PM-F','F1E','F1E-ZKAF-70-0','1','2.320','2.320','1','2.320','2.320','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-ZKAF-70-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZKAF-70-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-20261117-0001','1','F3E-ZKAF-71-0','1','2.050','2.050','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAF-71-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-71-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F3E-ZKAF-71-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAF-71-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-11-17 07:58:35','TOKO','PM-F','F3E','F3E-ZKAF-71-0','1','2.050','2.050','1','2.050','2.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKAF-71-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-71-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-20261117-0001','1','F3E-ZKAF-72-0','1','2.390','2.390','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAF-72-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-72-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F3E-ZKAF-72-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAF-72-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-11-17 07:58:35','TOKO','PM-F','F3E','F3E-ZKAF-72-0','1','2.390','2.390','1','2.390','2.390','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-ZKAF-72-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-72-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-20261117-0001','1','F3E-ZKAF-73-0','1','1.530','1.530','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAF-73-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-73-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F3E-ZKAF-73-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAF-73-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-11-17 07:58:35','TOKO','PM-F','F3E','F3E-ZKAF-73-0','1','1.530','1.530','1','1.530','1.530','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-ZKAF-73-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-73-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-20261117-0001','1','F3E-ZKAF-74-0','1','3.730','3.730','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKAF-74-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-74-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-17 07:58:35' WHERE kode_barang='F3E-ZKAF-74-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKAF-74-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:35','TOKO','PM-F','F3E','F3E-ZKAF-74-0','1','3.730','3.730','1','3.730','3.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKAF-74-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKAF-74-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261117-0001','2026-11-17','07:58','18.050','admpindah','2026-11-17 07:58:35'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261117-0001','1','H1E-ZKAF-75-0','1','3.000','3.000','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-75-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-75-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-75-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-75-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-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-75-0','1','3.000','3.000','1','3.000','3.000','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-ZKAF-75-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-75-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-20261117-0001','1','H1E-ZKAF-76-0','1','3.050','3.050','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-76-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-76-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-76-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-76-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-76-0','1','3.050','3.050','1','3.050','3.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-ZKAF-76-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-76-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261117-0001','1','H1E-ZKAF-77-0','1','2.020','2.020','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-77-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-77-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-77-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-77-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-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-77-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-ZKAF-77-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-77-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-20261117-0001','1','H1E-ZKAF-78-0','1','2.100','2.100','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-78-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-78-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-78-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-78-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-78-0','1','2.100','2.100','1','2.100','2.100','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-ZKAF-78-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-78-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261117-0001','1','H1E-ZKAF-79-0','1','2.100','2.100','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-79-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-79-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-79-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-79-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-79-0','1','2.100','2.100','1','2.100','2.100','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-ZKAF-79-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-79-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261117-0001','1','H1E-ZKAF-80-0','1','1.570','1.570','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-80-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-80-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-80-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-80-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-80-0','1','1.570','1.570','1','1.570','1.570','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-ZKAF-80-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-80-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261117-0001','1','H1E-ZKAF-81-0','1','1.560','1.560','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-81-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-81-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-81-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-81-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-81-0','1','1.560','1.560','1','1.560','1.560','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-ZKAF-81-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-81-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-20261117-0001','1','H1E-ZKAF-82-0','1','1.340','1.340','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-82-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-82-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-82-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-82-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-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-82-0','1','1.340','1.340','1','1.340','1.340','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-ZKAF-82-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-82-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-20261117-0001','1','H1E-ZKAF-83-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-83-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-83-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-83-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-83-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-83-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-ZKAF-83-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-83-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-20261117-0001','1','H1E-ZKAF-84-0','1','2.020','2.020','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKAF-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-84-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-17 07:58:58' WHERE kode_barang='H1E-ZKAF-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKAF-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-11-17 07:58:58','TOKO','PM-H','H1E','H1E-ZKAF-84-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-ZKAF-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKAF-84-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261117-0001','2026-11-17','07:58','20.810','admpindah','2026-11-17 07:58:57'); 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 ('F326170834331','input','1',' MDE2 X OR ','TOKO','PM-E','E2D-ZJCX-201-0','CC X MODEL MATA OR 12 8K ','','1.620','1','100.00','1615000','0','0','15000','1615000','0','0','0','1615000','AAT','00432427','E2D','0','0','-','0','997000'); UPDATE tm_barang SET tgl_last_jual='2026-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJCX-201-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-11-17' AND kode_barang='E2D-ZJCX-201-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 ('F326170834331','2026-11-17','1.620','2026-11-17','08:34:34','PLG0032410','1615000','1615000','0','1615000','1615000','input','2026-11-17 08:34:33','F32617083433'); 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-11-17','F326170834331','2026-11-17','08:34:34','AAT','1615000','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-261117-0002','D','2026-11-17','08:34:34','input','PENJUALAN','F326170834331','8240164000','1615000','8241779000'); 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 ('F326170857481','input','1',' MEH1 X YT ','TOKO','PM-H','H1E-ZIXH-139-0','KL X TRIXIE MATA VAR YT 42 8K ','','1.850','1','100.00','1881000','0','0','15000','1883000','0','0','0','1883000','AAT','00422406','H1E','0','0','-','0','1027000'); UPDATE tm_barang SET tgl_last_jual='2026-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXH-139-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-11-17' AND kode_barang='H1E-ZIXH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170857481','2026-11-17','1.850','2026-11-17','08:57:48','PLG0032411','1883000','1883000','0','1883000','1883000','input','2026-11-17 08:57:48','F32617085748'); 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-11-17','F326170857481','2026-11-17','08:57:48','AAT','1883000','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-261117-0003','D','2026-11-17','08:57:48','input','PENJUALAN','F326170857481','8241779000','1883000','8243662000'); 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 ('F326170901551','input','1',' MEE2 X KH ','TOKO','PM-E','E2E-ZKXE-131-0','CC X MODEL SNAKE MATA KH 14 8K ','','0.480','1','100.00','488000','0','0','15000','490000','0','0','0','490000','AAT','00433478','E2E','0','0','-','0','1027000'); UPDATE tm_barang SET tgl_last_jual='2026-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZKXE-131-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-11-17' AND kode_barang='E2E-ZKXE-131-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170901551','2026-11-17','0.480','2026-11-17','09:01:56','PLG0032412','490000','490000','0','490000','490000','input','2026-11-17 09:01:55','F32617090155'); 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-11-17','F326170901551','2026-11-17','09:01:56','AAT','490000','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-261117-0004','D','2026-11-17','09:01:56','input','PENJUALAN','F326170901551','8243662000','490000','8244152000');