INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','07:59:25'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-01','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-01'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-31'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-31'; 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-31' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-31'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-31'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-31'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-31'; 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-11-01' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-31' 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-01'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','07:59:56'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-01'; 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-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-01'; 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-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-01' 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-02'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','08:04:46'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','08:28:07'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','08:39:31'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','08:48:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','10:00:01'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','11:50:11'); 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-ZKXB-1-0','00031933',' ','CN COR DB CAT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3685000','2026-11-02','3685000','2.070','100.00','16','0','1780000.00','1','0.045', 'adminpusat','2026-11-02 11:57:04','2.060','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-ZKXB-1-0','00031933'); 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-02','MTCN-ZKXB-1-0','MTCN','TOKO','INPUT1','100.00','2.070','2.060','1','2.070','2.060','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 ('MDGL-ZKXB-2-0','00031934','EX ','GL BABY CAT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','2128500','2026-11-02','2128500','1.980','100.00','8','0','1075000.00','1','0.045', 'adminpusat','2026-11-02 12:00:45','1.970','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKXB-2-0','00031934'); 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-02','MDGL-ZKXB-2-0','MDGL','TOKO','INPUT1','100.00','1.980','1.970','1','1.980','1.970','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 ('MDKL-ZKXB-3-0','00031935','EX ','KL FANCY VAR BT VC 39CM KKT PER BTG ','','GR','---','MD','MDKL','TOKO','INPUT1','2967000','2026-11-02','2967000','2.760','100.00','8','0','1075000.00','1','0.045', 'adminpusat','2026-11-02 12:04:15','2.750','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKXB-3-0','00031935'); 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-02','MDKL-ZKXB-3-0','MDKL','TOKO','INPUT1','100.00','2.760','2.750','1','2.760','2.750','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 ('MDKL-ZKXB-4-0','00031936',' ','KL FANCY 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3128500','2026-11-02','3128500','2.910','100.00','8','0','1075000.00','1','0.045', 'adminpusat','2026-11-02 12:07:43','2.900','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKXB-4-0','00031936'); 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-02','MDKL-ZKXB-4-0','MDKL','TOKO','INPUT1','100.00','2.910','2.900','1','2.910','2.900','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-261102-0001','1','MDGL-ZKXB-2-0','1','1.980','1.980','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKXB-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-02','TOKO','BGLMD','MDGL','MDGL-ZKXB-2-0','100.00','1','1.980','1.970','1','1.980','1.970'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='MDGL-ZKXB-2-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-261102-0001','2026-11-02','2026-11-02','12:13','1.98','adminpusat','2026-11-02 12:13: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-261102-0002','1','MDKL-ZKXB-3-0','1','2.760','2.760','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKXB-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-02','TOKO','BKLMD','MDKL','MDKL-ZKXB-3-0','100.00','1','2.760','2.750','1','2.760','2.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.760',berat_out_asli=berat_out_asli+'2.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='MDKL-ZKXB-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-261102-0002','2','MDKL-ZKXB-4-0','1','2.910','2.910','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKXB-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-02','TOKO','BKLMD','MDKL','MDKL-ZKXB-4-0','100.00','1','2.910','2.900','1','2.910','2.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.910',berat_out_asli=berat_out_asli+'2.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='MDKL-ZKXB-4-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-261102-0002','2026-11-02','2026-11-02','12:15','5.67','adminpusat','2026-11-02 12:15:24'); 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-261102-0003','1','MTCN-ZKXB-1-0','1','2.070','2.070','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZKXB-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-02','TOKO','BKCNMT','MTCN','MTCN-ZKXB-1-0','100.00','1','2.070','2.060','1','2.070','2.060'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.070',berat_out_asli=berat_out_asli+'2.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-02' AND kode_barang='MTCN-ZKXB-1-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-261102-0003','2026-11-02','2026-11-02','12:15','2.07','adminpusat','2026-11-02 12:16:17'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-02 ','16:20:13'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0001','1','MDGL-ZKXB-2-0','1','1.980','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZKXB-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZKXB-2-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-ZKXB-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='MDGL-ZKXB-2-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-261102-0001','2026-11-02','2026-11-02','16:22','1.980','adminpusat','261102'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0002','1','MTCN-ZKXB-1-0','1','2.070','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZKXB-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZKXB-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-ZKXB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='MTCN-ZKXB-1-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-261102-0002','2026-11-02','2026-11-02','16:23','2.070','adminpusat','261102'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261102-0003','1','MDKL-ZKXB-3-0','1','2.760','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZKXB-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZKXB-3-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZKXB-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.760',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.760',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='MDKL-ZKXB-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-261102-0003','2','MDKL-ZKXB-4-0','1','2.910','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZKXB-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZKXB-4-0' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1; DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-ZKXB-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.910',berat_out_asli='2.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.910',berat_akhir_asli =berat_akhir_asli-'2.900' WHERE kode_barang='MDKL-ZKXB-4-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-261102-0003','2026-11-02','2026-11-02','16:23','2.910','adminpusat','261102');