INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','08:24:02'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-10','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-09'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-09'; 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-09' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-09'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-09'; 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-10' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-09' 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-10'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','08:24:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-10 ','08:54:51'); 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 ('MDAT-ZJAX-1-0','00031757',' ','AT COR KWT BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','2486500','2026-10-10','2486500','2.240','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:00:59','2.230','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZJAX-1-0','00031757'); 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-10','MDAT-ZJAX-1-0','MDAT','TOKO','INPUT1','100.00','2.240','2.230','1','2.240','2.230','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-ZJAX-2-0','00031758',' ','GL RANGKAIAN COR 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5206000','2026-10-10','5206000','4.690','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:08:18','4.680','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-ZJAX-2-0','00031758'); 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-10','MDGL-ZJAX-2-0','MDGL','TOKO','INPUT1','100.00','4.690','4.680','1','4.690','4.680','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-ZJAX-3-0','00031759',' ','KL FANCY VAR TDK BT KUPU 48CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','11100000','2026-10-10','11100000','10.000','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:16:52','9.990','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-ZJAX-3-0','00031759'); 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-10','MDKL-ZJAX-3-0','MDKL','TOKO','INPUT1','100.00','10.000','9.990','1','10.000','9.990','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-ZJAX-4-0','00031760',' ','GL RANGKAIAN COR 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4717500','2026-10-10','4717500','4.250','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:21:03','4.240','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-ZJAX-4-0','00031760'); 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-10','MDGL-ZJAX-4-0','MDGL','TOKO','INPUT1','100.00','4.250','4.240','1','4.250','4.240','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-ZJAX-5-0','00031761',' ','GL RANGKAIAN COR 18CM KKT PER MK ','','GR','---','MD','MDGL','TOKO','INPUT1','5617000','2026-10-10','5617000','5.060','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:26:25','5.050','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-ZJAX-5-0','00031761'); 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-10','MDGL-ZJAX-5-0','MDGL','TOKO','INPUT1','100.00','5.060','5.050','1','5.060','5.050','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-ZJAX-6-0','00031762',' ','GL RANGKAIAN COR 19CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','6660000','2026-10-10','6660000','6.000','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:29:33','5.990','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-ZJAX-6-0','00031762'); 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-10','MDGL-ZJAX-6-0','MDGL','TOKO','INPUT1','100.00','6.000','5.990','1','6.000','5.990','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-ZJAX-7-0','00031763',' ','GL RANGKAIAN COR 19CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','6149500','2026-10-10','6149500','5.540','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:31:27','5.530','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-ZJAX-7-0','00031763'); 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-10','MDGL-ZJAX-7-0','MDGL','TOKO','INPUT1','100.00','5.540','5.530','1','5.540','5.530','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-ZJAX-8-0','00031764',' ','GL RANGKAIAN COR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4218000','2026-10-10','4218000','3.800','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:36:48','3.790','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-ZJAX-8-0','00031764'); 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-10','MDGL-ZJAX-8-0','MDGL','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 ('MDGL-ZJAX-9-0','00031765',' ','GL RANGKAIAN VAR BT 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5239500','2026-10-10','5239500','4.720','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:39:04','4.710','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-ZJAX-9-0','00031765'); 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-10','MDGL-ZJAX-9-0','MDGL','TOKO','INPUT1','100.00','4.720','4.710','1','4.720','4.710','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-ZJAX-10-0','00031766',' ','GL RANGKAIAN COR VAR BT 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4618000','2026-10-10','4618000','4.160','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-10 09:40:54','4.150','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-ZJAX-10-0','00031766'); 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-10','MDGL-ZJAX-10-0','MDGL','TOKO','INPUT1','100.00','4.160','4.150','1','4.160','4.150','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 ('MDGL-ZJAX-9-0','00031765','00031765','GL RANGKAIAN VAR BT 18CM KKT PER SHB ','GL RANGKAIAN COR VAR BT 18CM KKT PER SHB','','','5239500','5239500',' 0','0','adminpusat','2026-10-10 09:44:09'); UPDATE tm_barang SET nama_barang='GL RANGKAIAN COR VAR BT 18CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDGL-ZJAX-9-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-ZJAX-11-0','00031767',' ','GL RANGKAIAN COR 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','12144000','2026-10-10','12144000','6.600','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-10 10:05:56','6.590','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-ZJAX-11-0','00031767'); 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-10','MTGL-ZJAX-11-0','MTGL','TOKO','INPUT1','100.00','6.600','6.590','1','6.600','6.590','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-ZJAX-12-0','00031768',' ','GL RANGKAIAN COR VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10065000','2026-10-10','10065000','5.470','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-10 10:10:14','5.460','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-ZJAX-12-0','00031768'); 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-10','MTGL-ZJAX-12-0','MTGL','TOKO','INPUT1','100.00','5.470','5.460','1','5.470','5.460','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-ZJAX-13-0','00031769',' ','GL RANGKAIAN COR VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10378000','2026-10-10','10378000','5.640','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-10 10:11:48','5.630','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-ZJAX-13-0','00031769'); 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-10','MTGL-ZJAX-13-0','MTGL','TOKO','INPUT1','100.00','5.640','5.630','1','5.640','5.630','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-ZJAX-14-0','00031770',' ','GL RANGKAIAN COR VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9329000','2026-10-10','9329000','5.070','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-10 10:13:37','5.060','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-ZJAX-14-0','00031770'); 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-10','MTGL-ZJAX-14-0','MTGL','TOKO','INPUT1','100.00','5.070','5.060','1','5.070','5.060','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-261010-0001','1','MDAT-ZJAX-1-0','1','2.240','2.240','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MDAT-ZJAX-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-10','TOKO','BKMF','MDAT','MDAT-ZJAX-1-0','100.00','1','2.240','2.230','1','2.240','2.230'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.240',berat_out_asli=berat_out_asli+'2.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDAT-ZJAX-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-261010-0001','2','MDGL-ZJAX-2-0','1','4.690','4.690','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BKMF','MDGL','MDGL-ZJAX-2-0','100.00','1','4.690','4.680','1','4.690','4.680'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.690',berat_out_asli=berat_out_asli+'4.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-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-261010-0001','3','MDKL-ZJAX-3-0','1','10.000','10.000','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MDKL-ZJAX-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-10','TOKO','BKMF','MDKL','MDKL-ZJAX-3-0','100.00','1','10.000','9.990','1','10.000','9.990'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.000',berat_out_asli=berat_out_asli+'9.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDKL-ZJAX-3-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-261010-0001','2026-10-10','2026-10-10','10:13','16.93','adminpusat','2026-10-10 10:14:56'); 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-261010-0002','1','MDGL-ZJAX-4-0','1','4.250','4.250','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-4-0','100.00','1','4.250','4.240','1','4.250','4.240'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.250',berat_out_asli=berat_out_asli+'4.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-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-261010-0002','2','MDGL-ZJAX-5-0','1','5.060','5.060','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-5-0','100.00','1','5.060','5.050','1','5.060','5.050'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.060',berat_out_asli=berat_out_asli+'5.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-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-261010-0002','3','MDGL-ZJAX-6-0','1','6.000','6.000','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-6-0','100.00','1','6.000','5.990','1','6.000','5.990'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.000',berat_out_asli=berat_out_asli+'5.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-6-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-261010-0002','4','MDGL-ZJAX-7-0','1','5.540','5.540','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-7-0','100.00','1','5.540','5.530','1','5.540','5.530'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.540',berat_out_asli=berat_out_asli+'5.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-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-261010-0002','5','MDGL-ZJAX-9-0','1','4.720','4.720','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-9-0','100.00','1','4.720','4.710','1','4.720','4.710'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.720',berat_out_asli=berat_out_asli+'4.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-9-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-261010-0002','6','MDGL-ZJAX-10-0','1','4.160','4.160','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-10-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-10-0','100.00','1','4.160','4.150','1','4.160','4.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.160',berat_out_asli=berat_out_asli+'4.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MDGL-ZJAX-10-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-261010-0002','7','MDGL-ZJAX-8-0','1','3.800','3.800','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJAX-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-10','TOKO','BGLMD','MDGL','MDGL-ZJAX-8-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-10' AND kode_barang='MDGL-ZJAX-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-261010-0002','2026-10-10','2026-10-10','10:15','33.53','adminpusat','2026-10-10 10:16:21'); 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-ZJAX-11-0','00031767','00031767','GL RANGKAIAN COR 18CM KKT PER SHB ','GL RANGKAIAN COR 18CM KKT PER MK','','','12144000','12144000',' 0','0','adminpusat','2026-10-10 10:18:49'); UPDATE tm_barang SET nama_barang='GL RANGKAIAN COR 18CM KKT PER MK' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZJAX-11-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-261010-0003','1','MTGL-ZJAX-11-0','1','6.600','6.600','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJAX-11-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-10','TOKO','BKGLMT','MTGL','MTGL-ZJAX-11-0','100.00','1','6.600','6.590','1','6.600','6.590'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.600',berat_out_asli=berat_out_asli+'6.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MTGL-ZJAX-11-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-261010-0003','2','MTGL-ZJAX-12-0','1','5.470','5.470','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJAX-12-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-10','TOKO','BKGLMT','MTGL','MTGL-ZJAX-12-0','100.00','1','5.470','5.460','1','5.470','5.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.470',berat_out_asli=berat_out_asli+'5.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MTGL-ZJAX-12-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-261010-0003','3','MTGL-ZJAX-13-0','1','5.640','5.640','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJAX-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-10','TOKO','BKGLMT','MTGL','MTGL-ZJAX-13-0','100.00','1','5.640','5.630','1','5.640','5.630'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.640',berat_out_asli=berat_out_asli+'5.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MTGL-ZJAX-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-261010-0003','4','MTGL-ZJAX-14-0','1','5.070','5.070','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJAX-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-10','TOKO','BKGLMT','MTGL','MTGL-ZJAX-14-0','100.00','1','5.070','5.060','1','5.070','5.060'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.070',berat_out_asli=berat_out_asli+'5.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-10' AND kode_barang='MTGL-ZJAX-14-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-261010-0003','2026-10-10','2026-10-10','10:22','22.78','adminpusat','2026-10-10 10:23:00'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261010-0001','1','MDGL-ZJAX-4-0','1','4.250','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-4-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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-ZJAX-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.250',berat_out_asli='4.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.250',berat_akhir_asli =berat_akhir_asli-'4.240' WHERE kode_barang='MDGL-ZJAX-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-261010-0001','2','MDGL-ZJAX-5-0','1','5.060','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-5-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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-ZJAX-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.060',berat_out_asli='5.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.060',berat_akhir_asli =berat_akhir_asli-'5.050' WHERE kode_barang='MDGL-ZJAX-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-261010-0001','3','MDGL-ZJAX-6-0','1','6.000','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-6-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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='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-ZJAX-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='6.000',berat_out_asli='5.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.000',berat_akhir_asli =berat_akhir_asli-'5.990' WHERE kode_barang='MDGL-ZJAX-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-261010-0001','4','MDGL-ZJAX-7-0','1','5.540','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-7-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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='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-ZJAX-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.540',berat_out_asli='5.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.540',berat_akhir_asli =berat_akhir_asli-'5.530' WHERE kode_barang='MDGL-ZJAX-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-261010-0001','5','MDGL-ZJAX-8-0','1','3.800','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-8-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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='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-ZJAX-8-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='MDGL-ZJAX-8-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261010-0001','6','MDGL-ZJAX-9-0','1','4.720','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-9-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-9-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-ZJAX-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.720',berat_out_asli='4.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.720',berat_akhir_asli =berat_akhir_asli-'4.710' WHERE kode_barang='MDGL-ZJAX-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-261010-0001','7','MDGL-ZJAX-10-0','1','4.160','TOKO','BGLMD'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-10-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-10-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-ZJAX-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.160',berat_out_asli='4.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.160',berat_akhir_asli =berat_akhir_asli-'4.150' WHERE kode_barang='MDGL-ZJAX-10-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-261010-0001','2026-10-10','2026-10-10','11:07','4.160','adminpusat','261010'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261010-0002','1','MTGL-ZJAX-11-0','1','6.600','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAX-11-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJAX-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-ZJAX-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='6.600',berat_out_asli='6.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.600',berat_akhir_asli =berat_akhir_asli-'6.590' WHERE kode_barang='MTGL-ZJAX-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-261010-0002','2','MTGL-ZJAX-12-0','1','5.470','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAX-12-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJAX-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-ZJAX-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.470',berat_out_asli='5.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.470',berat_akhir_asli =berat_akhir_asli-'5.460' WHERE kode_barang='MTGL-ZJAX-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-261010-0002','3','MTGL-ZJAX-13-0','1','5.640','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAX-13-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJAX-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='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-ZJAX-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.640',berat_out_asli='5.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.640',berat_akhir_asli =berat_akhir_asli-'5.630' WHERE kode_barang='MTGL-ZJAX-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-261010-0002','4','MTGL-ZJAX-14-0','1','5.070','TOKO','BKGLMT'); DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZJAX-14-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZJAX-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='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-ZJAX-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.070',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.070',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='MTGL-ZJAX-14-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-261010-0002','2026-10-10','2026-10-10','11:07','5.070','adminpusat','261010'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261010-0003','1','MDAT-ZJAX-1-0','1','2.240','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZJAX-1-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZJAX-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='MDAT' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' 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='MDAT-ZJAX-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.240',berat_out_asli='2.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.240',berat_akhir_asli =berat_akhir_asli-'2.230' WHERE kode_barang='MDAT-ZJAX-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-261010-0003','2','MDGL-ZJAX-2-0','1','4.690','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZJAX-2-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZJAX-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='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='MDGL-ZJAX-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.690',berat_out_asli='4.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.690',berat_akhir_asli =berat_akhir_asli-'4.680' WHERE kode_barang='MDGL-ZJAX-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-261010-0003','3','MDKL-ZJAX-3-0','1','10.000','TOKO','BKMF'); DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZJAX-3-0' LIMIT 1; INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-ZJAX-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='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='MDKL-ZJAX-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='9.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'9.990' WHERE kode_barang='MDKL-ZJAX-3-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-261010-0003','2026-10-10','2026-10-10','11:07','10.000','adminpusat','261010');