INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-04 ','08:03:58'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-04','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-04'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-03'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-03'; 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-11-03' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-03'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-03'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-04' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-03' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-04'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-04 ','15:01:45'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-1-0','00031937',' ','CN COR DB WAVE SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','854500','2026-11-04','854500','0.480','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:04:12','0.470','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-1-0','00031937'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-1-0','MTCN','TOKO','INPUT1','100.00','0.480','0.470','1','0.480','0.470','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-2-0','00031938',' ','CN COR DB WAVE SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','872500','2026-11-04','872500','0.490','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:05:31','0.480','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-2-0','00031938'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-2-0','MTCN','TOKO','INPUT1','100.00','0.490','0.480','1','0.490','0.480','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-3-0','00031939',' ','CN COR DB WAVE SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','819000','2026-11-04','819000','0.460','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:08:02','0.450','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-3-0','00031939'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-3-0','MTCN','TOKO','INPUT1','100.00','0.460','0.450','1','0.460','0.450','1'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTCN-ZKXD-3-0','00031939','00031939','CN COR DB WAVE SHB ','CN COR DB WAVE SHB','','','819000','819000',' 0','0','adminpusat','2026-11-04 15:09:37'); UPDATE tm_barang SET nama_barang='CN COR DB WAVE SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-ZKXD-3-0' LIMIT 1; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-4-0','00031940',' ','CN KWT TDK BT BDR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1495500','2026-11-04','1495500','0.840','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:11:39','0.830','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-4-0','00031940'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-4-0','MTCN','TOKO','INPUT1','100.00','0.840','0.830','1','0.840','0.830','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-5-0','00031941',' ','CN KWT TDK BT BDR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1460000','2026-11-04','1460000','0.820','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:12:11','0.810','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-5-0','00031941'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-5-0','MTCN','TOKO','INPUT1','100.00','0.820','0.810','1','0.820','0.810','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZKXD-6-0','00031942',' ','CN KWT TDK BT BDR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1388500','2026-11-04','1388500','0.780','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:12:47','0.770','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-ZKXD-6-0','00031942'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTCN-ZKXD-6-0','MTCN','TOKO','INPUT1','100.00','0.780','0.770','1','0.780','0.770','1'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTCN-ZKXD-6-0','00031942','00031942','CN KWT TDK BT BDR SHB ','CN KWT TDK BT BDR SHB','','','1388500','1388500',' 0','0','adminpusat','2026-11-04 15:14:38'); UPDATE tm_barang SET nama_barang='CN KWT TDK BT BDR SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-ZKXD-6-0' LIMIT 1; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZKXD-7-0','00031943',' ','GL COR TDK BT 19CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9434000','2026-11-04','9434000','5.300','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:17:54','5.290','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKXD-7-0','00031943'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTGL-ZKXD-7-0','MTGL','TOKO','INPUT1','100.00','5.300','5.290','1','5.300','5.290','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZKXD-8-0','00031944',' ','GL COR TDK BT 19CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9274000','2026-11-04','9274000','5.210','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:20:09','5.200','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKXD-8-0','00031944'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTGL-ZKXD-8-0','MTGL','TOKO','INPUT1','100.00','5.210','5.200','1','5.210','5.200','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZKXD-9-0','00031945',' ','KL FANCY DB BDR 42CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','10555500','2026-11-04','10555500','5.930','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-04 15:23:12','5.920','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZKXD-9-0','00031945'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-04','MTKL-ZKXD-9-0','MTKL','TOKO','INPUT1','100.00','5.930','5.920','1','5.930','5.920','1'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGL-ZKXD-7-0','00031943','00031943','GL COR TDK BT 19CM KKT PER SHB ','GL COR TDK BT 19CM KKT PER SHB','','','9434000','9434000',' 0','0','adminpusat','2026-11-04 15:23:43'); UPDATE tm_barang SET nama_barang='GL COR TDK BT 19CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' FS', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZKXD-7-0' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGL-ZKXD-8-0','00031944','00031944','GL COR TDK BT 19CM KKT PER SHB ','GL COR TDK BT 19CM KKT PER SHB','','','9274000','9274000',' 0','0','adminpusat','2026-11-04 15:24:01'); UPDATE tm_barang SET nama_barang='GL COR TDK BT 19CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' FS', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZKXD-8-0' LIMIT 1; 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-261104-0001','1','MTCN-ZKXD-1-0','1','0.480','0.480','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-1-0','100.00','1','0.480','0.470','1','0.480','0.470'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0001','2','MTCN-ZKXD-2-0','1','0.490','0.490','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-2-0','100.00','1','0.490','0.480','1','0.490','0.480'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.490',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0001','3','MTCN-ZKXD-3-0','1','0.460','0.460','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-3-0','100.00','1','0.460','0.450','1','0.460','0.450'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.460',berat_out_asli=berat_out_asli+'0.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0001','4','MTCN-ZKXD-4-0','1','0.840','0.840','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-4-0','100.00','1','0.840','0.830','1','0.840','0.830'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.840',berat_out_asli=berat_out_asli+'0.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0001','5','MTCN-ZKXD-5-0','1','0.820','0.820','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-5-0','100.00','1','0.820','0.810','1','0.820','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.820',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0001','6','MTCN-ZKXD-6-0','1','0.780','0.780','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKCNMT','MTCN','MTCN-ZKXD-6-0','100.00','1','0.780','0.770','1','0.780','0.770'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.780',berat_out_asli=berat_out_asli+'0.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTCN-ZKXD-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' 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-261104-0001','2026-11-04','2026-11-04','15:31','3.87','adminpusat','2026-11-04 15:32:39'); 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-261104-0002','1','MTKL-ZKXD-9-0','1','5.930','5.930','TOKO','INPUT1','TOKO','BKKLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZKXD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKKLMT','MTKL','MTKL-ZKXD-9-0','100.00','1','5.930','5.920','1','5.930','5.920'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.930',berat_out_asli=berat_out_asli+'5.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTKL-ZKXD-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' 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-261104-0002','2026-11-04','2026-11-04','15:33','5.93','adminpusat','2026-11-04 15:33:37'); 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-261104-0003','1','MTGL-ZKXD-7-0','1','5.300','5.300','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZKXD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKMF','MTGL','MTGL-ZKXD-7-0','100.00','1','5.300','5.290','1','5.300','5.290'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.300',berat_out_asli=berat_out_asli+'5.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTGL-ZKXD-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; 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-261104-0003','2','MTGL-ZKXD-8-0','1','5.210','5.210','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZKXD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1'; 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-11-04','TOKO','BKMF','MTGL','MTGL-ZKXD-8-0','100.00','1','5.210','5.200','1','5.210','5.200'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.210',berat_out_asli=berat_out_asli+'5.200',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-04' AND kode_barang='MTGL-ZKXD-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' 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-261104-0003','2026-11-04','2026-11-04','15:34','10.51','adminpusat','2026-11-04 15:34:36'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','1','MTCN-ZKXD-1-0','1','0.480','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-1-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.480',berat_out_asli='0.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.480',berat_akhir_asli =berat_akhir_asli-'0.470' WHERE kode_barang='MTCN-ZKXD-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','2','MTCN-ZKXD-2-0','1','0.490','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-2-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.490',berat_out_asli='0.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.490',berat_akhir_asli =berat_akhir_asli-'0.480' WHERE kode_barang='MTCN-ZKXD-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','3','MTCN-ZKXD-3-0','1','0.460','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-3-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.460',berat_out_asli='0.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.460',berat_akhir_asli =berat_akhir_asli-'0.450' WHERE kode_barang='MTCN-ZKXD-3-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','4','MTCN-ZKXD-4-0','1','0.840','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-4-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.840',berat_out_asli='0.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.840',berat_akhir_asli =berat_akhir_asli-'0.830' WHERE kode_barang='MTCN-ZKXD-4-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','5','MTCN-ZKXD-5-0','1','0.820','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-5-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-5-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.820',berat_out_asli='0.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.820',berat_akhir_asli =berat_akhir_asli-'0.810' WHERE kode_barang='MTCN-ZKXD-5-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','6','MTCN-ZKXD-6-0','1','0.780','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXD-6-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXD-6-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-ZKXD-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='0.780',berat_out_asli='0.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.780',berat_akhir_asli =berat_akhir_asli-'0.770' WHERE kode_barang='MTCN-ZKXD-6-0' 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-261104-0001','2026-11-04','2026-11-04','15:43','0.780','adminpusat','261104'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0002','1','MTKL-ZKXD-9-0','1','5.930','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZKXD-9-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZKXD-9-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZKXD-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.930',berat_out_asli='5.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.930',berat_akhir_asli =berat_akhir_asli-'5.920' WHERE kode_barang='MTKL-ZKXD-9-0' 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-261104-0002','2026-11-04','2026-11-04','15:44','5.930','adminpusat','261104'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','1','MTGL-ZKXD-7-0','1','5.300','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZKXD-7-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZKXD-7-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKMF'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKMF'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZKXD-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.300',berat_out_asli='5.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.300',berat_akhir_asli =berat_akhir_asli-'5.290' WHERE kode_barang='MTGL-ZKXD-7-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','2','MTGL-ZKXD-8-0','1','5.210','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZKXD-8-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZKXD-8-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKMF'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKMF'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZKXD-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.210',berat_out_asli='5.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.210',berat_akhir_asli =berat_akhir_asli-'5.200' WHERE kode_barang='MTGL-ZKXD-8-0' 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-261104-0003','2026-11-04','2026-11-04','15:44','5.210','adminpusat','261104');