INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-03 ','08:03:09'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-03','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-02'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-02'; 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-02' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-02'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-02'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-02'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-02'; 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-03' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-02' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-10-03'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-03 ','08:05:31'); 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-ZJXC-1-0','00031547',' ','GL VANESSA VAR CAT KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6992000','2026-10-03','6992000','3.800','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:12:55','3.790','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-ZJXC-1-0','00031547'); 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-10-03','MTGL-ZJXC-1-0','MTGL','TOKO','INPUT1','100.00','3.800','3.790','1','3.800','3.790','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-ZJXC-2-0','00031548',' ','GL RANGKAIAN 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10286000','2026-10-03','10286000','5.590','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:18:55','5.580','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-ZJXC-2-0','00031548'); 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-10-03','MTGL-ZJXC-2-0','MTGL','TOKO','INPUT1','100.00','5.590','5.580','1','5.590','5.580','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-ZJXC-3-0','00031549',' ','GL RANGKAIAN 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10212000','2026-10-03','10212000','5.550','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:21:21','5.540','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-ZJXC-3-0','00031549'); 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-10-03','MTGL-ZJXC-3-0','MTGL','TOKO','INPUT1','100.00','5.550','5.540','1','5.550','5.540','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-ZJXC-4-0','00031550',' ','GL RANGKAIAN 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9826000','2026-10-03','9826000','5.340','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:24:25','5.330','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-ZJXC-4-0','00031550'); 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-10-03','MTGL-ZJXC-4-0','MTGL','TOKO','INPUT1','100.00','5.340','5.330','1','5.340','5.330','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-ZJXC-5-0','00031551',' ','GL RANGKAIAN 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10746000','2026-10-03','10746000','5.840','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:25:25','5.830','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-ZJXC-5-0','00031551'); 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-10-03','MTGL-ZJXC-5-0','MTGL','TOKO','INPUT1','100.00','5.840','5.830','1','5.840','5.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 ('MTGL-ZJXC-6-0','00031552',' ','GL VANESSA VAR CAT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6072000','2026-10-03','6072000','3.300','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:30:35','3.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-ZJXC-6-0','00031552'); 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-10-03','MTGL-ZJXC-6-0','MTGL','TOKO','INPUT1','100.00','3.300','3.290','1','3.300','3.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 ('MTKL-ZJXC-7-0','00031553',' ','KL VANESSA DB CAT 48CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','18234500','2026-10-03','18234500','9.910','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:34:23','9.900','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-ZJXC-7-0','00031553'); 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-10-03','MTKL-ZJXC-7-0','MTKL','TOKO','INPUT1','100.00','9.910','9.900','1','9.910','9.900','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-ZJXC-8-0','00031554',' ','KL VANESSA DB CAT 50CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','26570000','2026-10-03','26570000','14.440','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-03 08:41:30','14.430','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-ZJXC-8-0','00031554'); 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-10-03','MTKL-ZJXC-8-0','MTKL','TOKO','INPUT1','100.00','14.440','14.430','1','14.440','14.430','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-ZJXB-18-0','00031545','00031545','GL RANGKAIAN DBL CHN VAR BT 18CM KKT PER SHB ','GL RANGKAIAN VAR BT 18CM KKT PER SHB','','','10488000','10488000',' 0','0','adminpusat','2026-10-03 08:45:27'); UPDATE tm_barang SET nama_barang='GL RANGKAIAN VAR BT 18CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZJXB-18-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-ZJXC-1-0','00031547','00031547','GL VANESSA VAR CAT KKT PER SHB ','GL VANESSA VAR CAT 17CM KKT PER SHB','','','6992000','6992000',' 0','0','adminpusat','2026-10-03 08:45:59'); UPDATE tm_barang SET nama_barang='GL VANESSA VAR CAT 17CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZJXC-1-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-261003-0001','1','MTCN-ZJXB-13-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-ZJXB-13-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-10-03','TOKO','BKCNMT','MTCN','MTCN-ZJXB-13-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-10-03' AND kode_barang='MTCN-ZJXB-13-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-261003-0001','2','MTCN-ZJXB-14-0','1','1.810','1.810','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZJXB-14-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-10-03','TOKO','BKCNMT','MTCN','MTCN-ZJXB-14-0','100.00','1','1.810','1.800','1','1.810','1.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.810',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTCN-ZJXB-14-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-261003-0001','3','MTCN-ZJXB-15-0','1','1.800','1.800','TOKO','INPUT1','TOKO','BKCNMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZJXB-15-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-10-03','TOKO','BKCNMT','MTCN','MTCN-ZJXB-15-0','100.00','1','1.800','1.790','1','1.800','1.790'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTCN-ZJXB-15-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-261003-0001','2026-10-03','2026-10-03','09:12','5.68','adminpusat','2026-10-03 09:13:22'); 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-261003-0002','1','MTGL-ZJXB-16-0','1','8.950','8.950','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-16-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-10-03','TOKO','BKGLMT','MTGL','MTGL-ZJXB-16-0','100.00','1','8.950','8.940','1','8.950','8.940'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.950',berat_out_asli=berat_out_asli+'8.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXB-16-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-261003-0002','2','MTGL-ZJXB-17-0','1','5.330','5.330','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-17-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-10-03','TOKO','BKGLMT','MTGL','MTGL-ZJXB-17-0','100.00','1','5.330','5.320','1','5.330','5.320'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.330',berat_out_asli=berat_out_asli+'5.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXB-17-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-261003-0002','3','MTGL-ZJXB-18-0','1','5.700','5.700','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-18-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-10-03','TOKO','BKGLMT','MTGL','MTGL-ZJXB-18-0','100.00','1','5.700','5.690','1','5.700','5.690'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.700',berat_out_asli=berat_out_asli+'5.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXB-18-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-261003-0002','2026-10-03','2026-10-03','09:13','19.98','adminpusat','2026-10-03 09:15:11'); 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-261003-0003','1','MTKL-ZJXB-19-0','1','3.390','3.390','TOKO','INPUT1','TOKO','BKKLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZJXB-19-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-10-03','TOKO','BKKLMT','MTKL','MTKL-ZJXB-19-0','100.00','1','3.390','3.380','1','3.390','3.380'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.390',berat_out_asli=berat_out_asli+'3.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTKL-ZJXB-19-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-261003-0003','2026-10-03','2026-10-03','09:15','3.39','adminpusat','2026-10-03 09:16:00'); 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-261003-0004','1','MTGL-ZJXC-1-0','1','3.800','3.800','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-1-0','100.00','1','3.800','3.790','1','3.800','3.790'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.800',berat_out_asli=berat_out_asli+'3.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','2','MTGL-ZJXC-2-0','1','5.590','5.590','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-2-0','100.00','1','5.590','5.580','1','5.590','5.580'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.590',berat_out_asli=berat_out_asli+'5.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','3','MTGL-ZJXC-3-0','1','5.550','5.550','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-3-0','100.00','1','5.550','5.540','1','5.550','5.540'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.550',berat_out_asli=berat_out_asli+'5.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','4','MTGL-ZJXC-4-0','1','5.340','5.340','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-4-0','100.00','1','5.340','5.330','1','5.340','5.330'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.340',berat_out_asli=berat_out_asli+'5.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','5','MTGL-ZJXC-5-0','1','5.840','5.840','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-5-0','100.00','1','5.840','5.830','1','5.840','5.830'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.840',berat_out_asli=berat_out_asli+'5.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','6','MTGL-ZJXC-6-0','1','3.300','3.300','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTGL-ZJXC-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-10-03','TOKO','BKMF','MTGL','MTGL-ZJXC-6-0','100.00','1','3.300','3.290','1','3.300','3.290'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.300',berat_out_asli=berat_out_asli+'3.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTGL-ZJXC-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-261003-0004','2026-10-03','2026-10-03','09:16','29.42','adminpusat','2026-10-03 09:20:19'); 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-261003-0005','1','MTKL-ZJXC-7-0','1','9.910','9.910','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZJXC-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-10-03','TOKO','BKMF','MTKL','MTKL-ZJXC-7-0','100.00','1','9.910','9.900','1','9.910','9.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.910',berat_out_asli=berat_out_asli+'9.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTKL-ZJXC-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-261003-0005','2','MTKL-ZJXC-8-0','1','14.440','14.440','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZJXC-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-10-03','TOKO','BKMF','MTKL','MTKL-ZJXC-8-0','100.00','1','14.440','14.430','1','14.440','14.430'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'14.440',berat_out_asli=berat_out_asli+'14.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-03' AND kode_barang='MTKL-ZJXC-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-261003-0005','2026-10-03','2026-10-03','09:20','24.35','adminpusat','2026-10-03 09:21:11'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-03 ','10:13:31'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-03 ','10:17:32'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-03 ','10:29:05'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0001','1','MDGL-ZJXB-1-0','1','7.670','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXB-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXB-1-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-ZJXB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='7.670',berat_out_asli='7.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.670',berat_akhir_asli =berat_akhir_asli-'7.660' WHERE kode_barang='MDGL-ZJXB-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-261003-0001','2','MDGL-ZJXB-2-0','1','8.160','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXB-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXB-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-ZJXB-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='8.160',berat_out_asli='8.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.160',berat_akhir_asli =berat_akhir_asli-'8.150' WHERE kode_barang='MDGL-ZJXB-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-261003-0001','3','MDGL-ZJXB-3-0','1','3.020','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXB-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXB-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='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-ZJXB-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.010' WHERE kode_barang='MDGL-ZJXB-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-261003-0001','4','MDGL-ZJXB-4-0','1','3.060','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXB-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXB-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='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-ZJXB-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.060',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.060',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='MDGL-ZJXB-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-261003-0001','5','MDGL-ZJXB-5-0','1','3.110','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJXB-5-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJXB-5-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-ZJXB-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.110',berat_out_asli='3.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.110',berat_akhir_asli =berat_akhir_asli-'3.100' WHERE kode_barang='MDGL-ZJXB-5-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-261003-0001','2026-10-03','2026-10-03','10:32','3.110','adminpusat','261003'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0002','1','MTCN-ZJXB-13-0','1','2.070','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXB-13-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXB-13-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-ZJXB-13-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-ZJXB-13-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0002','2','MTCN-ZJXB-14-0','1','1.810','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXB-14-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXB-14-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-ZJXB-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.800' WHERE kode_barang='MTCN-ZJXB-14-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0002','3','MTCN-ZJXB-15-0','1','1.800','TOKO','BKCNMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZJXB-15-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-ZJXB-15-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-ZJXB-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.800',berat_out_asli='1.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.800',berat_akhir_asli =berat_akhir_asli-'1.790' WHERE kode_barang='MTCN-ZJXB-15-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-261003-0002','2026-10-03','2026-10-03','10:32','1.800','adminpusat','261003'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','1','MTGL-ZJXB-9-0','1','3.390','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-9-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-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='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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.380' WHERE kode_barang='MTGL-ZJXB-9-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','2','MTGL-ZJXB-10-0','1','3.500','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-10-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-10-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.500',berat_out_asli='3.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.500',berat_akhir_asli =berat_akhir_asli-'3.490' WHERE kode_barang='MTGL-ZJXB-10-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','3','MTGL-ZJXB-11-0','1','3.650','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-11-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-11-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.650',berat_out_asli='3.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.650',berat_akhir_asli =berat_akhir_asli-'3.640' WHERE kode_barang='MTGL-ZJXB-11-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','4','MTGL-ZJXB-12-0','1','3.670','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-12-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-12-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.670',berat_out_asli='3.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.670',berat_akhir_asli =berat_akhir_asli-'3.660' WHERE kode_barang='MTGL-ZJXB-12-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','5','MTGL-ZJXB-16-0','1','8.950','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-16-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-16-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='8.950',berat_out_asli='8.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.950',berat_akhir_asli =berat_akhir_asli-'8.940' WHERE kode_barang='MTGL-ZJXB-16-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','6','MTGL-ZJXB-17-0','1','5.330','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-17-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-17-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.330',berat_out_asli='5.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.330',berat_akhir_asli =berat_akhir_asli-'5.320' WHERE kode_barang='MTGL-ZJXB-17-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0003','7','MTGL-ZJXB-18-0','1','5.700','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXB-18-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXB-18-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='BKGLMT'; INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-ZJXB-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.700',berat_out_asli='5.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.700',berat_akhir_asli =berat_akhir_asli-'5.690' WHERE kode_barang='MTGL-ZJXB-18-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-261003-0003','2026-10-03','2026-10-03','10:32','5.700','adminpusat','261003'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0004','1','MTKL-ZJXB-19-0','1','3.390','TOKO','BKKLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXB-19-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXB-19-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-ZJXB-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.380' WHERE kode_barang='MTKL-ZJXB-19-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-261003-0004','2026-10-03','2026-10-03','10:32','3.390','adminpusat','261003'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0005','1','MDKL-ZJXB-6-0','1','7.510','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXB-6-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXB-6-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-ZJXB-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='7.510',berat_out_asli='7.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.510',berat_akhir_asli =berat_akhir_asli-'7.500' WHERE kode_barang='MDKL-ZJXB-6-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0005','2','MDKL-ZJXB-7-0','1','11.150','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXB-7-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXB-7-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-ZJXB-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='11.150',berat_out_asli='11.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.150',berat_akhir_asli =berat_akhir_asli-'11.140' WHERE kode_barang='MDKL-ZJXB-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-261003-0005','3','MDKL-ZJXB-8-0','1','7.560','TOKO','BKLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJXB-8-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJXB-8-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-ZJXB-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='7.560',berat_out_asli='7.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.560',berat_akhir_asli =berat_akhir_asli-'7.550' WHERE kode_barang='MDKL-ZJXB-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-261003-0005','2026-10-03','2026-10-03','10:32','7.560','adminpusat','261003'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0006','1','MTGL-ZJXC-1-0','1','3.800','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.800',berat_out_asli='3.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.800',berat_akhir_asli =berat_akhir_asli-'3.790' WHERE kode_barang='MTGL-ZJXC-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-261003-0006','2','MTGL-ZJXC-2-0','1','5.590','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.590',berat_out_asli='5.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.590',berat_akhir_asli =berat_akhir_asli-'5.580' WHERE kode_barang='MTGL-ZJXC-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-261003-0006','3','MTGL-ZJXC-3-0','1','5.550','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.550',berat_out_asli='5.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.550',berat_akhir_asli =berat_akhir_asli-'5.540' WHERE kode_barang='MTGL-ZJXC-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-261003-0006','4','MTGL-ZJXC-4-0','1','5.340','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.340',berat_out_asli='5.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.340',berat_akhir_asli =berat_akhir_asli-'5.330' WHERE kode_barang='MTGL-ZJXC-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-261003-0006','5','MTGL-ZJXC-5-0','1','5.840','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-5-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.840',berat_out_asli='5.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.840',berat_akhir_asli =berat_akhir_asli-'5.830' WHERE kode_barang='MTGL-ZJXC-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-261003-0006','6','MTGL-ZJXC-6-0','1','3.300','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJXC-6-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJXC-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='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-ZJXC-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='MTGL-ZJXC-6-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261003-0006','7','MTKL-ZJXC-7-0','1','9.910','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXC-7-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXC-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='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='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='MTKL-ZJXC-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='9.910',berat_out_asli='9.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.910',berat_akhir_asli =berat_akhir_asli-'9.900' WHERE kode_barang='MTKL-ZJXC-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-261003-0006','8','MTKL-ZJXC-8-0','1','14.440','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZJXC-8-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZJXC-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='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='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='MTKL-ZJXC-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='14.440',berat_out_asli='14.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'14.440',berat_akhir_asli =berat_akhir_asli-'14.430' WHERE kode_barang='MTKL-ZJXC-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-261003-0006','2026-10-03','2026-10-03','10:32','14.440','adminpusat','261003');