INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','08:13:59');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-12';
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-01-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-12' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','08:17:03');
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 ('MTAT-ZAAC-1-0','00027627',' ','AT JEPSI POLOS MK ','','GR','---','MT','MTAT','TOKO','INPUT1','1037000','2026-01-13','1037000','0.550','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:20:18','0.540','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-ZAAC-1-0','00027627');
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-01-13','MTAT-ZAAC-1-0','MTAT','TOKO','INPUT1','100.00','0.550','0.540','1','0.550','0.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 ('MTAT-ZAAC-2-0','00027628',' ','AT JEPSI POLOS MK ','','GR','---','MT','MTAT','TOKO','INPUT1','1056000','2026-01-13','1056000','0.560','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:20:45','0.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-ZAAC-2-0','00027628');
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-01-13','MTAT-ZAAC-2-0','MTAT','TOKO','INPUT1','100.00','0.560','0.550','1','0.560','0.550','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 ('MTAT-ZAAC-3-0','00027629',' ','AT JEPSI DEWI 3 MK ','','GR','---','MT','MTAT','TOKO','INPUT1','1923000','2026-01-13','1923000','1.020','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:22:26','1.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-ZAAC-3-0','00027629');
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-01-13','MTAT-ZAAC-3-0','MTAT','TOKO','INPUT1','100.00','1.020','1.010','1','1.020','1.010','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 ('MTAT-ZAAC-4-0','00027630',' ','AT JEPSI DEWI 3 MK ','','GR','---','MT','MTAT','TOKO','INPUT1','1885000','2026-01-13','1885000','1.000','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:22:44','0.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-ZAAC-4-0','00027630');
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-01-13','MTAT-ZAAC-4-0','MTAT','TOKO','INPUT1','100.00','1.000','0.990','1','1.000','0.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 ('MTGL-ZAAC-5-0','00027631',' ','GL RANGKAIAN COR 18CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','10613000','2026-01-13','10613000','5.630','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:24:48','5.620','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-ZAAC-5-0','00027631');
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-01-13','MTGL-ZAAC-5-0','MTGL','TOKO','INPUT1','100.00','5.630','5.620','1','5.630','5.620','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 ('MTGW-ZAAC-6-0','00027632',' ','GW CAP BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1451500','2026-01-13','1451500','0.770','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:26:56','0.760','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-6-0','00027632');
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-01-13','MTGW-ZAAC-6-0','MTGW','TOKO','INPUT1','100.00','0.770','0.760','1','0.770','0.760','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 ('MTGW-ZAAC-7-0','00027633',' ','GW CAP BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1508000','2026-01-13','1508000','0.800','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:27:23','0.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-7-0','00027633');
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-01-13','MTGW-ZAAC-7-0','MTGW','TOKO','INPUT1','100.00','0.800','0.790','1','0.800','0.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 ('MTGW-ZAAC-8-0','00027634',' ','GW CAP BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','2413000','2026-01-13','2413000','1.280','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:28:57','1.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-8-0','00027634');
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-01-13','MTGW-ZAAC-8-0','MTGW','TOKO','INPUT1','100.00','1.280','1.270','1','1.280','1.270','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 ('MTGW-ZAAC-9-0','00027635',' ','GW CAP BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','2111500','2026-01-13','2111500','1.120','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:29:58','1.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-9-0','00027635');
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-01-13','MTGW-ZAAC-9-0','MTGW','TOKO','INPUT1','100.00','1.120','1.110','1','1.120','1.110','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 ('MTGW-ZAAC-10-0','00027636',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','961500','2026-01-13','961500','0.510','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:31:15','0.500','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-10-0','00027636');
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-01-13','MTGW-ZAAC-10-0','MTGW','TOKO','INPUT1','100.00','0.510','0.500','1','0.510','0.500','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 ('MTGW-ZAAC-11-0','00027637',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','980500','2026-01-13','980500','0.520','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:32:10','0.510','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-11-0','00027637');
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-01-13','MTGW-ZAAC-11-0','MTGW','TOKO','INPUT1','100.00','0.520','0.510','1','0.520','0.510','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 ('MTGW-ZAAC-12-0','00027638',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1583500','2026-01-13','1583500','0.840','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:33:27','0.830','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-12-0','00027638');
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-01-13','MTGW-ZAAC-12-0','MTGW','TOKO','INPUT1','100.00','0.840','0.830','1','0.840','0.830','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGW-ZAAC-13-0','00027639',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1602500','2026-01-13','1602500','0.850','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:34:29','0.840','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-13-0','00027639');
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-01-13','MTGW-ZAAC-13-0','MTGW','TOKO','INPUT1','100.00','0.850','0.840','1','0.850','0.840','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 ('MTGW-ZAAC-14-0','00027640',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1621500','2026-01-13','1621500','0.860','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:35:28','0.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-ZAAC-14-0','00027640');
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-01-13','MTGW-ZAAC-14-0','MTGW','TOKO','INPUT1','100.00','0.860','0.850','1','0.860','0.850','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-ZAAC-15-0','00027641',' ','KL FANCY DB 41CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','10443000','2026-01-13','10443000','5.540','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:37:55','5.530','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-ZAAC-15-0','00027641');
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-01-13','MTKL-ZAAC-15-0','MTKL','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 ('MTKL-ZAAC-16-0','00027642',' ','KL VALENTINE DB 41CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','10367500','2026-01-13','10367500','5.500','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:41:01','5.490','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-ZAAC-16-0','00027642');
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-01-13','MTKL-ZAAC-16-0','MTKL','TOKO','INPUT1','100.00','5.500','5.490','1','5.500','5.490','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-ZAAC-17-0','00027643',' ','KL VALENTINE DB 41CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','10367500','2026-01-13','10367500','5.500','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:42:16','5.490','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-ZAAC-17-0','00027643');
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-01-13','MTKL-ZAAC-17-0','MTKL','TOKO','INPUT1','100.00','5.500','5.490','1','5.500','5.490','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-ZAAC-18-0','00027644',' ','KL VALENTINE DB 41CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','11329000','2026-01-13','11329000','6.010','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:43:03','6.000','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-ZAAC-18-0','00027644');
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-01-13','MTKL-ZAAC-18-0','MTKL','TOKO','INPUT1','100.00','6.010','6.000','1','6.010','6.000','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-ZAAC-19-0','00027645',' ','KL PAJERO 49CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','18511000','2026-01-13','18511000','9.820','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:44:24','9.810','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-ZAAC-19-0','00027645');
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-01-13','MTKL-ZAAC-19-0','MTKL','TOKO','INPUT1','100.00','9.820','9.810','1','9.820','9.810','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZAAC-20-0','00027646',' ','KL PAJERO PJG 69CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','26390000','2026-01-13','26390000','14.000','100.00','16','0','1885000.00','1','0.045', 'adminpusat','2026-01-13 08:45:37','13.990','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-ZAAC-20-0','00027646');
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-01-13','MTKL-ZAAC-20-0','MTKL','TOKO','INPUT1','100.00','14.000','13.990','1','14.000','13.990','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','08:50:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','09:16:31');
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-260113-0001','1','MTAT-ZAAC-1-0','1','0.550','0.550','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-ZAAC-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-01-13','TOKO','BKATMT','MTAT','MTAT-ZAAC-1-0','100.00','1','0.550','0.540','1','0.550','0.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.550',berat_out_asli=berat_out_asli+'0.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTAT-ZAAC-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-260113-0001','2','MTAT-ZAAC-2-0','1','0.560','0.560','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-ZAAC-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-01-13','TOKO','BKATMT','MTAT','MTAT-ZAAC-2-0','100.00','1','0.560','0.550','1','0.560','0.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.560',berat_out_asli=berat_out_asli+'0.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTAT-ZAAC-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-260113-0001','3','MTAT-ZAAC-3-0','1','1.020','1.020','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-ZAAC-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-01-13','TOKO','BKATMT','MTAT','MTAT-ZAAC-3-0','100.00','1','1.020','1.010','1','1.020','1.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.020',berat_out_asli=berat_out_asli+'1.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTAT-ZAAC-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-260113-0001','4','MTAT-ZAAC-4-0','1','1.000','1.000','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-ZAAC-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-01-13','TOKO','BKATMT','MTAT','MTAT-ZAAC-4-0','100.00','1','1.000','0.990','1','1.000','0.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'0.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTAT-ZAAC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0001','2026-01-13','2026-01-13','09:16','3.13','adminpusat','2026-01-13 09:17:21');
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-260113-0002','1','MTGL-ZAAC-5-0','1','5.630','5.630','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZAAC-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-01-13','TOKO','BKGLMT','MTGL','MTGL-ZAAC-5-0','100.00','1','5.630','5.620','1','5.630','5.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.630',berat_out_asli=berat_out_asli+'5.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGL-ZAAC-5-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-260113-0002','2026-01-13','2026-01-13','09:17','5.63','adminpusat','2026-01-13 09:17:42');
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-260113-0003','1','MTGW-ZAAC-6-0','1','0.770','0.770','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-6-0','100.00','1','0.770','0.760','1','0.770','0.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.770',berat_out_asli=berat_out_asli+'0.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','2','MTGW-ZAAC-7-0','1','0.800','0.800','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-7-0','100.00','1','0.800','0.790','1','0.800','0.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','3','MTGW-ZAAC-8-0','1','1.280','1.280','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-8-0','100.00','1','1.280','1.270','1','1.280','1.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.280',berat_out_asli=berat_out_asli+'1.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-8-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-260113-0003','4','MTGW-ZAAC-9-0','1','1.120','1.120','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-9-0','100.00','1','1.120','1.110','1','1.120','1.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','5','MTGW-ZAAC-10-0','1','0.510','0.510','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-10-0','100.00','1','0.510','0.500','1','0.510','0.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','6','MTGW-ZAAC-11-0','1','0.520','0.520','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-11-0','100.00','1','0.520','0.510','1','0.520','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.520',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','7','MTGW-ZAAC-12-0','1','0.840','0.840','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-12-0','100.00','1','0.840','0.830','1','0.840','0.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.840',berat_out_asli=berat_out_asli+'0.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','8','MTGW-ZAAC-13-0','1','0.850','0.850','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-13-0','100.00','1','0.850','0.840','1','0.850','0.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.850',berat_out_asli=berat_out_asli+'0.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','9','MTGW-ZAAC-14-0','1','0.860','0.860','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-ZAAC-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-01-13','TOKO','BKGWMT','MTGW','MTGW-ZAAC-14-0','100.00','1','0.860','0.850','1','0.860','0.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.860',berat_out_asli=berat_out_asli+'0.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTGW-ZAAC-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-260113-0003','2026-01-13','2026-01-13','09:17','7.55','adminpusat','2026-01-13 09:18: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-260113-0004','1','MTKL-ZAAC-15-0','1','5.540','5.540','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-15-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-01-13' AND kode_barang='MTKL-ZAAC-15-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-260113-0004','2','MTKL-ZAAC-16-0','1','5.500','5.500','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-16-0','100.00','1','5.500','5.490','1','5.500','5.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.500',berat_out_asli=berat_out_asli+'5.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTKL-ZAAC-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-260113-0004','3','MTKL-ZAAC-17-0','1','5.500','5.500','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-17-0','100.00','1','5.500','5.490','1','5.500','5.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.500',berat_out_asli=berat_out_asli+'5.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTKL-ZAAC-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-260113-0004','4','MTKL-ZAAC-18-0','1','6.010','6.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-18-0','100.00','1','6.010','6.000','1','6.010','6.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.010',berat_out_asli=berat_out_asli+'6.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTKL-ZAAC-18-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-260113-0004','5','MTKL-ZAAC-19-0','1','9.820','9.820','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-19-0','100.00','1','9.820','9.810','1','9.820','9.810');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.820',berat_out_asli=berat_out_asli+'9.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTKL-ZAAC-19-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-260113-0004','6','MTKL-ZAAC-20-0','1','14.000','14.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZAAC-20-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-01-13','TOKO','BKKLMT','MTKL','MTKL-ZAAC-20-0','100.00','1','14.000','13.990','1','14.000','13.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'14.000',berat_out_asli=berat_out_asli+'13.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='MTKL-ZAAC-20-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-260113-0004','2026-01-13','2026-01-13','09:18','46.37','adminpusat','2026-01-13 09:19:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-13 ','09:28:02');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260113-0001','1','MTGW-ZAAB-84-0','TOKO','INPUT1','KL ITALY ST TWIST 42CM KKT PER BLT SHB ','1','2.070','RETUR SALAH BERAT');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-01-13 09:29:17',status_delete='2.060' WHERE kode_barang='MTGW-ZAAB-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAB-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAAB-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='INPUT1' AND kode_barang='MTGW-ZAAB-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260113-0001','2','MTGW-ZAAB-85-0','TOKO','INPUT1','KL ITALY ST 41CM KKT PER S SHB ','1','1.960','RETUR SALAH BERAT');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-01-13 09:29:17',status_delete='1.950' WHERE kode_barang='MTGW-ZAAB-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAB-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAAB-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='INPUT1' AND kode_barang='MTGW-ZAAB-85-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260113-0001','2026-01-13','admin','2026-01-13','09:29:17','admin','2026-01-13 09:29:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','09:31:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','10:28:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-13 ','12:17:26');
UPDATE tm_group SET harga='1100000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1100000','admin','2026-01-13 12:19:23');
UPDATE tm_group SET harga='1100000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1100000','admin','2026-01-13 12:19:33');
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3924500',harga_beli ='3924500' WHERE kode_barcode='00027560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3753000',harga_beli ='3753000' WHERE kode_barcode='00027561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5143500',harga_beli ='5143500' WHERE kode_barcode='00027562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5772500',harga_beli ='5772500' WHERE kode_barcode='00027563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5639000',harga_beli ='5639000' WHERE kode_barcode='00027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5277000',harga_beli ='5277000' WHERE kode_barcode='00027565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='00027566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='6953500',harga_beli ='6953500' WHERE kode_barcode='00027567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5201000',harga_beli ='5201000' WHERE kode_barcode='00027568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='6858000',harga_beli ='6858000' WHERE kode_barcode='00027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5391500',harga_beli ='5391500' WHERE kode_barcode='00027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11297000',harga_beli ='11297000' WHERE kode_barcode='00027571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='21469500',harga_beli ='21469500' WHERE kode_barcode='00027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9220500',harga_beli ='9220500' WHERE kode_barcode='00027573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5658000',harga_beli ='5658000' WHERE kode_barcode='00027574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7582000',harga_beli ='7582000' WHERE kode_barcode='00027575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5772500',harga_beli ='5772500' WHERE kode_barcode='00027576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5524500',harga_beli ='5524500' WHERE kode_barcode='00027577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5715000',harga_beli ='5715000' WHERE kode_barcode='00027578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5677000',harga_beli ='5677000' WHERE kode_barcode='00027579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5658000',harga_beli ='5658000' WHERE kode_barcode='00027580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4039000',harga_beli ='4039000' WHERE kode_barcode='00027581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9411000',harga_beli ='9411000' WHERE kode_barcode='00027582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9334500',harga_beli ='9334500' WHERE kode_barcode='00027583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9544500',harga_beli ='9544500' WHERE kode_barcode='00027584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11354000',harga_beli ='11354000' WHERE kode_barcode='00027585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5563000',harga_beli ='5563000' WHERE kode_barcode='00027586' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='7830000',harga_beli ='7830000' WHERE kode_barcode='00027587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18993000',harga_beli ='18993000' WHERE kode_barcode='00027588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19164500',harga_beli ='19164500' WHERE kode_barcode='00027589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19050000',harga_beli ='19050000' WHERE kode_barcode='00027590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3677000',harga_beli ='3677000' WHERE kode_barcode='00027591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3810000',harga_beli ='3810000' WHERE kode_barcode='00027592' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3886500',harga_beli ='3886500' WHERE kode_barcode='00027593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5620000',harga_beli ='5620000' WHERE kode_barcode='00027594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5734500',harga_beli ='5734500' WHERE kode_barcode='00027595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4496000',harga_beli ='4496000' WHERE kode_barcode='00027596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9754000',harga_beli ='9754000' WHERE kode_barcode='00027597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5829500',harga_beli ='5829500' WHERE kode_barcode='00027598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19088500',harga_beli ='19088500' WHERE kode_barcode='00027599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9525000',harga_beli ='9525000' WHERE kode_barcode='00027600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='5582000',harga_beli ='5582000' WHERE kode_barcode='00027601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19336000',harga_beli ='19336000' WHERE kode_barcode='00027602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2896000',harga_beli ='2896000' WHERE kode_barcode='00027603' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9411000',harga_beli ='9411000' WHERE kode_barcode='00027604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='00027605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4096000',harga_beli ='4096000' WHERE kode_barcode='00027606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='00027607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4077000',harga_beli ='4077000' WHERE kode_barcode='00027608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4820000',harga_beli ='4820000' WHERE kode_barcode='00027609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9773000',harga_beli ='9773000' WHERE kode_barcode='00027610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9525000',harga_beli ='9525000' WHERE kode_barcode='00027611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9639500',harga_beli ='9639500' WHERE kode_barcode='00027612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='9601500',harga_beli ='9601500' WHERE kode_barcode='00027613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='4648500',harga_beli ='4648500' WHERE kode_barcode='00027614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='12516000',harga_beli ='12516000' WHERE kode_barcode='00027615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18364500',harga_beli ='18364500' WHERE kode_barcode='00027616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='10268000',harga_beli ='10268000' WHERE kode_barcode='00027617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18002500',harga_beli ='18002500' WHERE kode_barcode='00027618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='3867500',harga_beli ='3867500' WHERE kode_barcode='00027619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19050000',harga_beli ='19050000' WHERE kode_barcode='00027620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='20612500',harga_beli ='20612500' WHERE kode_barcode='00027621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='15202000',harga_beli ='15202000' WHERE kode_barcode='00027622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='13335000',harga_beli ='13335000' WHERE kode_barcode='00027623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='19069500',harga_beli ='19069500' WHERE kode_barcode='00027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='47492000',harga_beli ='47492000' WHERE kode_barcode='00027625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='22822000',harga_beli ='22822000' WHERE kode_barcode='00027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1048000',harga_beli ='1048000' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1067000',harga_beli ='1067000' WHERE kode_barcode='00027628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1943500',harga_beli ='1943500' WHERE kode_barcode='00027629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1905000',harga_beli ='1905000' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='10725500',harga_beli ='10725500' WHERE kode_barcode='00027631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1467000',harga_beli ='1467000' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1524000',harga_beli ='1524000' WHERE kode_barcode='00027633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2438500',harga_beli ='2438500' WHERE kode_barcode='00027634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='2134000',harga_beli ='2134000' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='972000',harga_beli ='972000' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='991000',harga_beli ='991000' WHERE kode_barcode='00027637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1600500',harga_beli ='1600500' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1619500',harga_beli ='1619500' WHERE kode_barcode='00027639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='1638500',harga_beli ='1638500' WHERE kode_barcode='00027640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='10554000',harga_beli ='10554000' WHERE kode_barcode='00027641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='10477500',harga_beli ='10477500' WHERE kode_barcode='00027642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='10477500',harga_beli ='10477500' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='11449500',harga_beli ='11449500' WHERE kode_barcode='00027644' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='18707500',harga_beli ='18707500' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1905000',harga_jual='26670000',harga_beli ='26670000' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_group SET harga='1905000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1905000','admin','2026-01-13 12:19:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','12:31:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','15:01:00');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0001','1','MTAT-ZAAC-1-0','1','0.550','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZAAC-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZAAC-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='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZAAC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.550',berat_out_asli='0.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.550',berat_akhir_asli =berat_akhir_asli-'0.540' WHERE kode_barang='MTAT-ZAAC-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-260113-0001','2','MTAT-ZAAC-2-0','1','0.560','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZAAC-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZAAC-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='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZAAC-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.560',berat_out_asli='0.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.560',berat_akhir_asli =berat_akhir_asli-'0.550' WHERE kode_barang='MTAT-ZAAC-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-260113-0001','3','MTAT-ZAAC-3-0','1','1.020','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZAAC-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZAAC-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='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZAAC-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.010' WHERE kode_barang='MTAT-ZAAC-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-260113-0001','4','MTAT-ZAAC-4-0','1','1.000','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-ZAAC-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-ZAAC-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='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-ZAAC-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MTAT-ZAAC-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260113-0001','2026-01-13','2026-01-13','15:01','1.000','adminpusat','260113');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0002','1','MTGL-ZAAC-5-0','1','5.630','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZAAC-5-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-ZAAC-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='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-ZAAC-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.630',berat_out_asli='5.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.630',berat_akhir_asli =berat_akhir_asli-'5.620' WHERE kode_barang='MTGL-ZAAC-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-260113-0002','2026-01-13','2026-01-13','15:01','5.630','adminpusat','260113');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0003','1','MTGW-ZAAC-6-0','1','0.770','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-6-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.770',berat_out_asli='0.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.770',berat_akhir_asli =berat_akhir_asli-'0.760' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','2','MTGW-ZAAC-7-0','1','0.800','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-7-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.800',berat_out_asli='0.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.800',berat_akhir_asli =berat_akhir_asli-'0.790' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','3','MTGW-ZAAC-8-0','1','1.280','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-8-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.280',berat_out_asli='1.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.280',berat_akhir_asli =berat_akhir_asli-'1.270' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','4','MTGW-ZAAC-9-0','1','1.120','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-9-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.120',berat_out_asli='1.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.120',berat_akhir_asli =berat_akhir_asli-'1.110' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','5','MTGW-ZAAC-10-0','1','0.510','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-10-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.510',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.510',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','6','MTGW-ZAAC-11-0','1','0.520','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-11-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.520',berat_out_asli='0.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.520',berat_akhir_asli =berat_akhir_asli-'0.510' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','7','MTGW-ZAAC-12-0','1','0.840','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-12-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.840',berat_out_asli='0.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.840',berat_akhir_asli =berat_akhir_asli-'0.830' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','8','MTGW-ZAAC-13-0','1','0.850','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-13-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.850',berat_out_asli='0.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.850',berat_akhir_asli =berat_akhir_asli-'0.840' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','9','MTGW-ZAAC-14-0','1','0.860','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAAC-14-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-ZAAC-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='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-ZAAC-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.850' WHERE kode_barang='MTGW-ZAAC-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-260113-0003','2026-01-13','2026-01-13','15:02','0.860','adminpusat','260113');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','1','MTKL-ZAAB-86-0','1','2.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-86-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-86-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-ZAAB-86-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='MTKL-ZAAB-86-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','2','MTKL-ZAAB-87-0','1','1.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-87-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-87-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-ZAAB-87-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='MTKL-ZAAB-87-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','3','MTKL-ZAAB-88-0','1','2.700','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-88-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-88-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-ZAAB-88-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.700',berat_out_asli='2.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.700',berat_akhir_asli =berat_akhir_asli-'2.690' WHERE kode_barang='MTKL-ZAAB-88-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','4','MTKL-ZAAB-89-0','1','3.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-89-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-89-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-ZAAB-89-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.030',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.030',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='MTKL-ZAAB-89-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','5','MTKL-ZAAB-90-0','1','2.960','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-90-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-90-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-ZAAB-90-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.960',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.960',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='MTKL-ZAAB-90-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','6','MTKL-ZAAB-91-0','1','2.770','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-91-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-91-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-ZAAB-91-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.770',berat_out_asli='2.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.770',berat_akhir_asli =berat_akhir_asli-'2.760' WHERE kode_barang='MTKL-ZAAB-91-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','7','MTKL-ZAAB-92-0','1','2.120','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-92-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-92-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-ZAAB-92-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.120',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.120',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='MTKL-ZAAB-92-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','8','MTKL-ZAAB-93-0','1','3.650','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-93-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-93-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-ZAAB-93-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='MTKL-ZAAB-93-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','9','MTKL-ZAAB-94-0','1','2.730','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-94-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-94-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-ZAAB-94-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.730',berat_out_asli='2.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.730',berat_akhir_asli =berat_akhir_asli-'2.720' WHERE kode_barang='MTKL-ZAAB-94-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','10','MTKL-ZAAB-95-0','1','3.600','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-95-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-95-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-ZAAB-95-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.600',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.600',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='MTKL-ZAAB-95-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','11','MTKL-ZAAB-96-0','1','2.830','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-96-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-96-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-ZAAB-96-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.830',berat_out_asli='2.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.830',berat_akhir_asli =berat_akhir_asli-'2.820' WHERE kode_barang='MTKL-ZAAB-96-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','12','MTKL-ZAAB-97-0','1','5.930','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-97-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-97-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-ZAAB-97-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.930',berat_out_asli='5.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.930',berat_akhir_asli =berat_akhir_asli-'5.920' WHERE kode_barang='MTKL-ZAAB-97-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','13','MTKL-ZAAB-98-0','1','11.270','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-98-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-98-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-ZAAB-98-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='11.270',berat_out_asli='11.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.270',berat_akhir_asli =berat_akhir_asli-'11.260' WHERE kode_barang='MTKL-ZAAB-98-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','14','MTKL-ZAAB-99-0','1','4.840','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-99-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-99-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-ZAAB-99-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.840',berat_out_asli='4.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.840',berat_akhir_asli =berat_akhir_asli-'4.830' WHERE kode_barang='MTKL-ZAAB-99-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','15','MTKL-ZAAB-100-0','1','2.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-100-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-100-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-ZAAB-100-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.970',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.970',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='MTKL-ZAAB-100-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','16','MTKL-ZAAB-101-0','1','3.980','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-101-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-101-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-ZAAB-101-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.980',berat_out_asli='3.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.980',berat_akhir_asli =berat_akhir_asli-'3.970' WHERE kode_barang='MTKL-ZAAB-101-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','17','MTKL-ZAAB-102-0','1','3.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-102-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-102-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-ZAAB-102-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.030',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.030',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='MTKL-ZAAB-102-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','18','MTKL-ZAAB-103-0','1','2.900','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-103-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-103-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-ZAAB-103-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='MTKL-ZAAB-103-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','19','MTKL-ZAAB-104-0','1','3.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-104-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-104-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-ZAAB-104-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='MTKL-ZAAB-104-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','20','MTKL-ZAAB-105-0','1','2.980','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-105-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-105-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-ZAAB-105-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.980',berat_out_asli='2.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.980',berat_akhir_asli =berat_akhir_asli-'2.970' WHERE kode_barang='MTKL-ZAAB-105-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','21','MTKL-ZAAB-106-0','1','2.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-106-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-106-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-ZAAB-106-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.970',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.970',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='MTKL-ZAAB-106-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','22','MTKL-ZAAB-107-0','1','2.120','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-107-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-107-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-ZAAB-107-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.120',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.120',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='MTKL-ZAAB-107-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','23','MTKL-ZAAB-108-0','1','4.940','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-108-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-108-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-ZAAB-108-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.940',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.940',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='MTKL-ZAAB-108-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','24','MTKL-ZAAB-109-0','1','4.900','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-109-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-109-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-ZAAB-109-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.900',berat_out_asli='4.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.900',berat_akhir_asli =berat_akhir_asli-'4.890' WHERE kode_barang='MTKL-ZAAB-109-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','25','MTKL-ZAAB-110-0','1','5.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-110-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-110-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-ZAAB-110-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.010',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.010',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='MTKL-ZAAB-110-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','26','MTKL-ZAAB-111-0','1','5.960','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-111-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-111-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-ZAAB-111-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.960',berat_out_asli='5.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.960',berat_akhir_asli =berat_akhir_asli-'5.950' WHERE kode_barang='MTKL-ZAAB-111-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','27','MTKL-ZAAB-112-0','1','2.920','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-112-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-112-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-ZAAB-112-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.920',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.920',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='MTKL-ZAAB-112-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','28','MTKL-ZAAB-113-0','1','4.110','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-113-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-113-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-ZAAB-113-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.100' WHERE kode_barang='MTKL-ZAAB-113-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','29','MTKL-ZAAB-114-0','1','9.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-114-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-114-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-ZAAB-114-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.970',berat_out_asli='9.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.970',berat_akhir_asli =berat_akhir_asli-'9.960' WHERE kode_barang='MTKL-ZAAB-114-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','30','MTKL-ZAAB-115-0','1','10.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-115-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-115-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-ZAAB-115-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.060',berat_out_asli='10.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.060',berat_akhir_asli =berat_akhir_asli-'10.050' WHERE kode_barang='MTKL-ZAAB-115-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','31','MTKL-ZAAB-116-0','1','10.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-116-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-116-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-ZAAB-116-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='MTKL-ZAAB-116-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','32','MTKL-ZAAB-117-0','1','1.930','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-117-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-117-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-ZAAB-117-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.920' WHERE kode_barang='MTKL-ZAAB-117-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','33','MTKL-ZAAB-118-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-118-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-118-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-ZAAB-118-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZAAB-118-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','34','MTKL-ZAAB-119-0','1','2.040','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-119-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-119-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-ZAAB-119-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.040',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.040',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='MTKL-ZAAB-119-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','35','MTKL-ZAAB-120-0','1','2.950','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-120-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-120-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-ZAAB-120-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.940' WHERE kode_barang='MTKL-ZAAB-120-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','36','MTKL-ZAAB-121-0','1','3.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-121-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-121-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-ZAAB-121-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.010',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.010',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='MTKL-ZAAB-121-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','37','MTKL-ZAAB-122-0','1','2.360','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-122-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-122-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-ZAAB-122-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.360',berat_out_asli='2.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.360',berat_akhir_asli =berat_akhir_asli-'2.350' WHERE kode_barang='MTKL-ZAAB-122-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','38','MTKL-ZAAB-123-0','1','5.120','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-123-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-123-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-ZAAB-123-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.120',berat_out_asli='5.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.120',berat_akhir_asli =berat_akhir_asli-'5.110' WHERE kode_barang='MTKL-ZAAB-123-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','39','MTKL-ZAAB-124-0','1','3.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-124-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-124-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-ZAAB-124-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='MTKL-ZAAB-124-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','40','MTKL-ZAAB-125-0','1','10.020','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-125-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-125-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-ZAAB-125-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.020',berat_out_asli='10.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.020',berat_akhir_asli =berat_akhir_asli-'10.010' WHERE kode_barang='MTKL-ZAAB-125-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','41','MTKL-ZAAB-126-0','1','5.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-126-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-126-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-ZAAB-126-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='4.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'4.990' WHERE kode_barang='MTKL-ZAAB-126-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','42','MTKL-ZAAB-127-0','1','2.930','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-127-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-127-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-ZAAB-127-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.920' WHERE kode_barang='MTKL-ZAAB-127-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','43','MTKL-ZAAB-128-0','1','10.150','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-128-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-128-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-ZAAB-128-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.150',berat_out_asli='10.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.150',berat_akhir_asli =berat_akhir_asli-'10.140' WHERE kode_barang='MTKL-ZAAB-128-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','44','MTKL-ZAAB-129-0','1','1.520','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-129-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-129-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-ZAAB-129-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.520',berat_out_asli='1.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.520',berat_akhir_asli =berat_akhir_asli-'1.510' WHERE kode_barang='MTKL-ZAAB-129-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','45','MTKL-ZAAB-130-0','1','4.940','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-130-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-130-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-ZAAB-130-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.940',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.940',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='MTKL-ZAAB-130-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','46','MTKL-ZAAB-131-0','1','2.110','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-131-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-131-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-ZAAB-131-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='MTKL-ZAAB-131-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','47','MTKL-ZAAB-132-0','1','2.150','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-132-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-132-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-ZAAB-132-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.140' WHERE kode_barang='MTKL-ZAAB-132-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','48','MTKL-ZAAB-133-0','1','2.110','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-133-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-133-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-ZAAB-133-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='MTKL-ZAAB-133-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','49','MTKL-ZAAB-134-0','1','2.140','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-134-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-134-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-ZAAB-134-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='MTKL-ZAAB-134-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','50','MTKL-ZAAB-135-0','1','2.530','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-135-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-135-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-ZAAB-135-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.520' WHERE kode_barang='MTKL-ZAAB-135-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','51','MTKL-ZAAB-136-0','1','5.130','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-136-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-136-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-ZAAB-136-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.130',berat_out_asli='5.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.130',berat_akhir_asli =berat_akhir_asli-'5.120' WHERE kode_barang='MTKL-ZAAB-136-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','52','MTKL-ZAAB-137-0','1','5.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-137-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-137-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-ZAAB-137-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='4.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'4.990' WHERE kode_barang='MTKL-ZAAB-137-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','53','MTKL-ZAAB-138-0','1','5.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-138-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-138-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-ZAAB-138-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='MTKL-ZAAB-138-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','54','MTKL-ZAAB-139-0','1','5.040','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-139-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-139-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-ZAAB-139-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.040',berat_out_asli='5.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.040',berat_akhir_asli =berat_akhir_asli-'5.030' WHERE kode_barang='MTKL-ZAAB-139-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','55','MTKL-ZAAB-140-0','1','2.440','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-140-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-140-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-ZAAB-140-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.440',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.440',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='MTKL-ZAAB-140-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','56','MTKL-ZAAB-141-0','1','6.570','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-141-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-141-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-ZAAB-141-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.570',berat_out_asli='6.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.570',berat_akhir_asli =berat_akhir_asli-'6.560' WHERE kode_barang='MTKL-ZAAB-141-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','57','MTKL-ZAAB-142-0','1','9.640','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-142-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-142-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-ZAAB-142-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.640',berat_out_asli='9.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.640',berat_akhir_asli =berat_akhir_asli-'9.630' WHERE kode_barang='MTKL-ZAAB-142-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','58','MTKL-ZAAB-143-0','1','5.390','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-143-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-143-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-ZAAB-143-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.390',berat_out_asli='5.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.390',berat_akhir_asli =berat_akhir_asli-'5.380' WHERE kode_barang='MTKL-ZAAB-143-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','59','MTKL-ZAAB-144-0','1','9.450','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-144-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-144-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-ZAAB-144-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.450',berat_out_asli='9.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.450',berat_akhir_asli =berat_akhir_asli-'9.440' WHERE kode_barang='MTKL-ZAAB-144-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','60','MTKL-ZAAB-145-0','1','2.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-145-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-145-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-ZAAB-145-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='MTKL-ZAAB-145-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','61','MTKL-ZAAB-146-0','1','10.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-146-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-146-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-ZAAB-146-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='MTKL-ZAAB-146-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','62','MTKL-ZAAB-147-0','1','10.820','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-147-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-147-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-ZAAB-147-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.820',berat_out_asli='10.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.820',berat_akhir_asli =berat_akhir_asli-'10.810' WHERE kode_barang='MTKL-ZAAB-147-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','63','MTKL-ZAAB-148-0','1','7.980','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-148-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-148-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-ZAAB-148-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.980',berat_out_asli='7.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.980',berat_akhir_asli =berat_akhir_asli-'7.970' WHERE kode_barang='MTKL-ZAAB-148-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','64','MTKL-ZAAB-149-0','1','7.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-149-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-149-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-ZAAB-149-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.000',berat_out_asli='6.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.000',berat_akhir_asli =berat_akhir_asli-'6.990' WHERE kode_barang='MTKL-ZAAB-149-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','65','MTKL-ZAAB-150-0','1','10.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-150-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-150-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-ZAAB-150-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.010',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.010',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='MTKL-ZAAB-150-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','66','MTKL-ZAAB-151-0','1','24.930','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-151-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-151-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-ZAAB-151-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='24.930',berat_out_asli='24.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'24.930',berat_akhir_asli =berat_akhir_asli-'24.920' WHERE kode_barang='MTKL-ZAAB-151-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','67','MTKL-ZAAB-152-0','1','11.980','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAB-152-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAB-152-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-ZAAB-152-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='11.980',berat_out_asli='11.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.980',berat_akhir_asli =berat_akhir_asli-'11.970' WHERE kode_barang='MTKL-ZAAB-152-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','68','MTKL-ZAAC-15-0','1','5.540','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-15-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-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='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-ZAAC-15-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='MTKL-ZAAC-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','69','MTKL-ZAAC-16-0','1','5.500','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-16-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-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='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-ZAAC-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.500',berat_out_asli='5.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.500',berat_akhir_asli =berat_akhir_asli-'5.490' WHERE kode_barang='MTKL-ZAAC-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-260113-0004','70','MTKL-ZAAC-17-0','1','5.500','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-17-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-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='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-ZAAC-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.500',berat_out_asli='5.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.500',berat_akhir_asli =berat_akhir_asli-'5.490' WHERE kode_barang='MTKL-ZAAC-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-260113-0004','71','MTKL-ZAAC-18-0','1','6.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-18-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-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='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-ZAAC-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.010',berat_out_asli='6.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.010',berat_akhir_asli =berat_akhir_asli-'6.000' WHERE kode_barang='MTKL-ZAAC-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','72','MTKL-ZAAC-19-0','1','9.820','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-19-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-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-ZAAC-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.820',berat_out_asli='9.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.820',berat_akhir_asli =berat_akhir_asli-'9.810' WHERE kode_barang='MTKL-ZAAC-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260113-0004','73','MTKL-ZAAC-20-0','1','14.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAAC-20-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAC-20-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-ZAAC-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='14.000',berat_out_asli='13.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'14.000',berat_akhir_asli =berat_akhir_asli-'13.990' WHERE kode_barang='MTKL-ZAAC-20-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-260113-0004','2026-01-13','2026-01-13','15:02','14.000','adminpusat','260113');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-13 ','16:41:18');