INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','10:10:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-09';
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-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-09' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','10:11:05');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-10';
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-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-10';
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-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-10' 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-11';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','10:11:17');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-11';
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-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-11';
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-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-11' 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-12';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','10:11:30');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0001','1','PSBRE-ZAXI-1-0','1','3.690','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-ZAXI-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRE-ZAXI-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBRE-ZAXI-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRE-ZAXI-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBRE-ZAXI-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.690',berat_out_asli='3.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.690',berat_akhir_asli =berat_akhir_asli-'3.690' WHERE kode_barang='PSBRE-ZAXI-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260112-0001','2026-01-12','2026-01-12','10:22','3.690','input','2026-01-12 10:22:12','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0002','1','CKPRE-ZAXI-17-0','1','1.680','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAXI-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAXI-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAXI-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAXI-17-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAXI-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='CKPRE-ZAXI-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-260112-0002','2','CKPRE-ZAXI-18-0','1','2.210','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAXI-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAXI-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAXI-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAXI-18-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAXI-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.210',berat_out_asli='2.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.210',berat_akhir_asli =berat_akhir_asli-'2.210' WHERE kode_barang='CKPRE-ZAXI-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-260112-0002','3','CKPRE-ZAXI-19-0','1','2.340','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAXI-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAXI-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAXI-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAXI-19-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAXI-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='CKPRE-ZAXI-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-260112-0002','4','CKPRE-ZAXI-20-0','1','2.220','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAXI-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAXI-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAXI-20-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAXI-20-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAXI-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='CKPRE-ZAXI-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0002','5','CKPRE-ZAXI-21-0','1','2.700','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAXI-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAXI-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAXI-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAXI-21-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAXI-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.700',berat_out_asli='2.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.700',berat_akhir_asli =berat_akhir_asli-'2.700' WHERE kode_barang='CKPRE-ZAXI-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260112-0002','2026-01-12','2026-01-12','10:22','2.700','input','2026-01-12 10:22:21','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','1','PMM-ZAXI-12-0','1','1.830','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.830',berat_out_asli='1.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.830',berat_akhir_asli =berat_akhir_asli-'1.830' WHERE kode_barang='PMM-ZAXI-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-260112-0003','2','PMM-ZAXI-13-0','1','2.170','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PMM-ZAXI-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-260112-0003','3','PMM-ZAXI-14-0','1','2.260','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.260',berat_out_asli='2.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.260',berat_akhir_asli =berat_akhir_asli-'2.260' WHERE kode_barang='PMM-ZAXI-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','4','PMM-ZAXI-15-0','1','2.060','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='PMM-ZAXI-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-260112-0003','5','PMM-ZAXI-16-0','1','2.710','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.710',berat_out_asli='2.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.710',berat_akhir_asli =berat_akhir_asli-'2.710' WHERE kode_barang='PMM-ZAXI-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-260112-0003','6','PMM-ZAXI-29-0','1','2.460','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-29-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.460' WHERE kode_barang='PMM-ZAXI-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','7','PMM-ZAXI-30-0','1','2.430','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-30-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.430',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.430',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='PMM-ZAXI-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','8','PMM-ZAXI-31-0','1','2.380','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-31-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.380',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.380',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='PMM-ZAXI-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','9','PMM-ZAXI-32-0','1','1.770','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-32-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-32-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.770',berat_out_asli='1.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.770',berat_akhir_asli =berat_akhir_asli-'1.770' WHERE kode_barang='PMM-ZAXI-32-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','10','PMM-ZAXI-33-0','1','1.820','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-33-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-33-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.820',berat_out_asli='1.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.820',berat_akhir_asli =berat_akhir_asli-'1.820' WHERE kode_barang='PMM-ZAXI-33-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','11','PMM-ZAXI-34-0','1','1.880','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.880',berat_out_asli='1.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.880',berat_akhir_asli =berat_akhir_asli-'1.880' WHERE kode_barang='PMM-ZAXI-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','12','PMM-ZAXI-35-0','1','2.000','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='PMM-ZAXI-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','13','PMM-ZAXI-36-0','1','2.380','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-36-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.380',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.380',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='PMM-ZAXI-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','14','PMM-ZAXI-37-0','1','2.390','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='PMM-ZAXI-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','15','PMM-ZAXI-38-0','1','2.170','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-38-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-38-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PMM-ZAXI-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','16','PMM-ZAXI-39-0','1','2.720','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-39-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-39-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-39-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-39-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.720',berat_out_asli='2.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.720',berat_akhir_asli =berat_akhir_asli-'2.720' WHERE kode_barang='PMM-ZAXI-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','17','PMM-ZAXI-40-0','1','2.740','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-40-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-40-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-40-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-40-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.740',berat_out_asli='2.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.740',berat_akhir_asli =berat_akhir_asli-'2.740' WHERE kode_barang='PMM-ZAXI-40-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','18','PMM-ZAXI-41-0','1','2.710','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-41-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-41-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-41-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-41-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.710',berat_out_asli='2.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.710',berat_akhir_asli =berat_akhir_asli-'2.710' WHERE kode_barang='PMM-ZAXI-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','19','PMM-ZAXI-42-0','1','2.780','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-42-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-42-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.780',berat_out_asli='2.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.780',berat_akhir_asli =berat_akhir_asli-'2.780' WHERE kode_barang='PMM-ZAXI-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','20','PMM-ZAXI-43-0','1','1.850','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-43-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-43-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-43-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-43-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='PMM-ZAXI-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','21','PMM-ZAXI-44-0','1','1.940','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-44-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-44-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='PMM-ZAXI-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','22','PMM-ZAXI-45-0','1','1.850','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-45-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-45-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='PMM-ZAXI-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','23','PMM-ZAXI-46-0','1','1.620','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-46-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-46-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-46-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-46-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.620' WHERE kode_barang='PMM-ZAXI-46-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','24','PMM-ZAXI-47-0','1','1.610','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-47-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-47-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-47-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-47-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='PMM-ZAXI-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','25','PMM-ZAXI-48-0','1','1.620','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-48-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-48-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-48-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-48-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.620' WHERE kode_barang='PMM-ZAXI-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','26','PMM-ZAXI-49-0','1','2.650','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-49-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-49-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-49-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-49-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.650',berat_out_asli='2.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.650',berat_akhir_asli =berat_akhir_asli-'2.650' WHERE kode_barang='PMM-ZAXI-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','27','PMM-ZAXI-50-0','1','2.670','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-50-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-50-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.670',berat_out_asli='2.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.670',berat_akhir_asli =berat_akhir_asli-'2.670' WHERE kode_barang='PMM-ZAXI-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','28','PMM-ZAXI-51-0','1','2.570','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-51-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-51-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-51-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-51-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.570',berat_out_asli='2.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.570',berat_akhir_asli =berat_akhir_asli-'2.570' WHERE kode_barang='PMM-ZAXI-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','29','PMM-ZAXI-52-0','1','2.580','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-52-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-52-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-52-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-52-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.580',berat_out_asli='2.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.580',berat_akhir_asli =berat_akhir_asli-'2.580' WHERE kode_barang='PMM-ZAXI-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','30','PMM-ZAXI-53-0','1','1.870','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-53-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-53-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-53-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-53-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.870',berat_out_asli='1.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.870',berat_akhir_asli =berat_akhir_asli-'1.870' WHERE kode_barang='PMM-ZAXI-53-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','31','PMM-ZAXI-54-0','1','2.230','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-54-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-54-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-54-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-54-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-54-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.230',berat_out_asli='2.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.230',berat_akhir_asli =berat_akhir_asli-'2.230' WHERE kode_barang='PMM-ZAXI-54-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','32','PMM-ZAXI-55-0','1','2.190','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-55-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-55-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-55-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-55-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-55-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.190',berat_out_asli='2.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.190',berat_akhir_asli =berat_akhir_asli-'2.190' WHERE kode_barang='PMM-ZAXI-55-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','33','PMM-ZAXI-56-0','1','2.290','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-56-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-56-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-56-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-56-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-56-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.290',berat_out_asli='2.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.290',berat_akhir_asli =berat_akhir_asli-'2.290' WHERE kode_barang='PMM-ZAXI-56-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','34','PMM-ZAXI-57-0','1','2.270','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-57-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-57-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-57-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-57-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-57-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='PMM-ZAXI-57-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0003','35','PMM-ZAXI-58-0','1','2.330','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXI-58-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXI-58-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXI-58-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXI-58-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXI-58-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.330',berat_out_asli='2.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.330',berat_akhir_asli =berat_akhir_asli-'2.330' WHERE kode_barang='PMM-ZAXI-58-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260112-0003','2026-01-12','2026-01-12','10:22','2.330','input','2026-01-12 10:22:31','THIFA');
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2487000',harga_beli ='2487000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5037500',harga_beli ='5037500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='196000',harga_beli ='196000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6310000',harga_beli ='6310000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2261000',harga_beli ='2261000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2302000',harga_beli ='2302000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5488000',harga_beli ='5488000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='20265500',harga_beli ='20265500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2819500',harga_beli ='2819500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2794000',harga_beli ='2794000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2640000',harga_beli ='2640000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2743000',harga_beli ='2743000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7626500',harga_beli ='7626500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2920000',harga_beli ='2920000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='10460500',harga_beli ='10460500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3773500',harga_beli ='3773500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4435500',harga_beli ='4435500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4556000',harga_beli ='4556000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5359000',harga_beli ='5359000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4335500',harga_beli ='4335500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6201500',harga_beli ='6201500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7406000',harga_beli ='7406000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8931000',harga_beli ='8931000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7225500',harga_beli ='7225500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='1505500',harga_beli ='1505500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2790000',harga_beli ='2790000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4255000',harga_beli ='4255000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2208000',harga_beli ='2208000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2127500',harga_beli ='2127500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6523000',harga_beli ='6523000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7827500',harga_beli ='7827500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3492500',harga_beli ='3492500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6924000',harga_beli ='6924000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5499500',harga_beli ='5499500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2669500',harga_beli ='2669500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='2268000',harga_beli ='2268000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5158000',harga_beli ='5158000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3613000',harga_beli ='3613000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5355000',harga_beli ='5355000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6904000',harga_beli ='6904000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='10456500',harga_beli ='10456500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='9433000',harga_beli ='9433000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3452000',harga_beli ='3452000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5379000',harga_beli ='5379000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7506000',harga_beli ='7506000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6844000',harga_beli ='6844000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7044500',harga_beli ='7044500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8088000',harga_beli ='8088000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='16136000',harga_beli ='16136000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='1565500',harga_beli ='1565500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='1505500',harga_beli ='1505500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4977500',harga_beli ='4977500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8550000',harga_beli ='8550000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='9774000',harga_beli ='9774000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8309000',harga_beli ='8309000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7787000',harga_beli ='7787000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8530000',harga_beli ='8530000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7606500',harga_beli ='7606500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4536000',harga_beli ='4536000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='54448500',harga_beli ='54448500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='8469500',harga_beli ='8469500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7827500',harga_beli ='7827500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5800500',harga_beli ='5800500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='11139000',harga_beli ='11139000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='12926000',harga_beli ='12926000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='7426000',harga_beli ='7426000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6001000',harga_beli ='6001000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6583000',harga_beli ='6583000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5158000',harga_beli ='5158000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2418000','input','2026-01-12 10:25:49');
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='16956500',harga_beli ='16956500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='9948000',harga_beli ='9948000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='5282500',harga_beli ='5282500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6130000',harga_beli ='6130000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='4652500',harga_beli ='4652500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='11556000',harga_beli ='11556000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3547000',harga_beli ='3547000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='13299000',harga_beli ='13299000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='6322000',harga_beli ='6322000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2418000','input','2026-01-12 10:25:58');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2418000','input','2026-01-12 10:26:06');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2418000','input','2026-01-12 10:26:10');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2418000','input','2026-01-12 10:26:14');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2418000','input','2026-01-12 10:26:17');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2418000','input','2026-01-12 10:26:21');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2418000','input','2026-01-12 10:26:25');
UPDATE tm_barang SET harga_skrg ='2418000',harga_jual='3653000',harga_beli ='3653000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2418000','input','2026-01-12 10:26:29');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2418000','input','2026-01-12 10:26:33');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2418000','input','2026-01-12 10:26:38');
UPDATE tm_group SET harga='2418000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2418000','input','2026-01-12 10:26:42');
UPDATE tp_curr SET rp= '16875.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16875.00', 'input','2026-01-12 10:26:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','11:25:32');
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2522000',harga_beli ='2522000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5108500',harga_beli ='5108500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='199000',harga_beli ='199000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2890000',harga_beli ='2890000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6399000',harga_beli ='6399000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2397000',harga_beli ='2397000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2293000',harga_beli ='2293000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2334500',harga_beli ='2334500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5565000',harga_beli ='5565000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='20550500',harga_beli ='20550500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2859500',harga_beli ='2859500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2833500',harga_beli ='2833500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2677500',harga_beli ='2677500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2781500',harga_beli ='2781500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2755500',harga_beli ='2755500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7734000',harga_beli ='7734000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2961000',harga_beli ='2961000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='10607500',harga_beli ='10607500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3826500',harga_beli ='3826500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4498000',harga_beli ='4498000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4620000',harga_beli ='4620000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5434000',harga_beli ='5434000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4396000',harga_beli ='4396000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6289000',harga_beli ='6289000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7510000',harga_beli ='7510000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='9056500',harga_beli ='9056500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7327000',harga_beli ='7327000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='1526500',harga_beli ='1526500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2829000',harga_beli ='2829000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4315000',harga_beli ='4315000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3908000',harga_beli ='3908000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2157500',harga_beli ='2157500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6614500',harga_beli ='6614500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7937500',harga_beli ='7937500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3541500',harga_beli ='3541500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7021500',harga_beli ='7021500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2707000',harga_beli ='2707000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5230500',harga_beli ='5230500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3663500',harga_beli ='3663500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5430000',harga_beli ='5430000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7001000',harga_beli ='7001000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='10603500',harga_beli ='10603500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='9565500',harga_beli ='9565500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3501000',harga_beli ='3501000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5454500',harga_beli ='5454500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7612000',harga_beli ='7612000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6940000',harga_beli ='6940000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7143500',harga_beli ='7143500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='8202000',harga_beli ='8202000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='16363000',harga_beli ='16363000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='1669000',harga_beli ='1669000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='1669000',harga_beli ='1669000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='1587500',harga_beli ='1587500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='1526500',harga_beli ='1526500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5047500',harga_beli ='5047500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='8670000',harga_beli ='8670000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='9911500',harga_beli ='9911500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='8426000',harga_beli ='8426000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7896500',harga_beli ='7896500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='8649500',harga_beli ='8649500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7713500',harga_beli ='7713500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4599500',harga_beli ='4599500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='55214000',harga_beli ='55214000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='8588500',harga_beli ='8588500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7937500',harga_beli ='7937500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5882000',harga_beli ='5882000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='11295500',harga_beli ='11295500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='13108000',harga_beli ='13108000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='7530500',harga_beli ='7530500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6085500',harga_beli ='6085500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6675500',harga_beli ='6675500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5230500',harga_beli ='5230500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2452000','input','2026-01-12 13:05:13');
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='17195000',harga_beli ='17195000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='10088000',harga_beli ='10088000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5315000',harga_beli ='5315000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='5356500',harga_beli ='5356500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6216000',harga_beli ='6216000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='4718000',harga_beli ='4718000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='11718500',harga_beli ='11718500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3597000',harga_beli ='3597000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='13486000',harga_beli ='13486000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='6411000',harga_beli ='6411000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2452000','input','2026-01-12 13:05:20');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2452000','input','2026-01-12 13:05:24');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2452000','input','2026-01-12 13:05:27');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2452000','input','2026-01-12 13:05:32');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2452000','input','2026-01-12 13:05:35');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2452000','input','2026-01-12 13:05:41');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2452000','input','2026-01-12 13:05:45');
UPDATE tm_barang SET harga_skrg ='2452000',harga_jual='3704500',harga_beli ='3704500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2452000','input','2026-01-12 13:05:49');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2452000','input','2026-01-12 13:05:55');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2452000','input','2026-01-12 13:05:59');
UPDATE tm_group SET harga='2452000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2452000','input','2026-01-12 13:06:03');
UPDATE tp_curr SET rp= '16950.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16950.00', 'input','2026-01-12 13:36:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-12 ','14:22:20');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','1','PBDG-ZAXI-2-0','1','1.740','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.740',berat_out_asli='1.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.740',berat_akhir_asli =berat_akhir_asli-'1.740' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','2','PBDG-ZAXI-3-0','1','1.780','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.780',berat_out_asli='1.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.780',berat_akhir_asli =berat_akhir_asli-'1.780' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','3','PBDG-ZAXI-4-0','1','2.320','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.320',berat_out_asli='2.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.320',berat_akhir_asli =berat_akhir_asli-'2.320' WHERE kode_barang='PBDG-ZAXI-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','4','PBDG-ZAXI-5-0','1','2.320','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.320',berat_out_asli='2.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.320',berat_akhir_asli =berat_akhir_asli-'2.320' WHERE kode_barang='PBDG-ZAXI-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','5','PBDG-ZAXI-6-0','1','2.290','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.290',berat_out_asli='2.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.290',berat_akhir_asli =berat_akhir_asli-'2.290' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','6','PBDG-ZAXI-7-0','1','2.380','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.380',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.380',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','7','PBDG-ZAXI-8-0','1','2.150','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','8','PBDG-ZAXI-9-0','1','2.220','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','9','PBDG-ZAXI-10-0','1','2.760','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.760',berat_out_asli='2.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.760',berat_akhir_asli =berat_akhir_asli-'2.760' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','10','PBDG-ZAXI-11-0','1','2.730','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.730',berat_out_asli='2.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.730',berat_akhir_asli =berat_akhir_asli-'2.730' WHERE kode_barang='PBDG-ZAXI-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-260112-0004','11','PBDG-ZAXI-22-0','1','1.540','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='PBDG-ZAXI-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','12','PBDG-ZAXI-23-0','1','1.490','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.490',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.490',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='PBDG-ZAXI-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','13','PBDG-ZAXI-24-0','1','1.410','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.410' WHERE kode_barang='PBDG-ZAXI-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','14','PBDG-ZAXI-25-0','1','3.660','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.660',berat_out_asli='3.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.660',berat_akhir_asli =berat_akhir_asli-'3.660' WHERE kode_barang='PBDG-ZAXI-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','15','PBDG-ZAXI-26-0','1','4.050','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.050',berat_out_asli='4.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.050',berat_akhir_asli =berat_akhir_asli-'4.050' WHERE kode_barang='PBDG-ZAXI-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','16','PBDG-ZAXI-27-0','1','4.160','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.160',berat_out_asli='4.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.160',berat_akhir_asli =berat_akhir_asli-'4.160' WHERE kode_barang='PBDG-ZAXI-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','17','PBDG-ZAXI-28-0','1','4.260','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.260',berat_out_asli='4.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.260',berat_akhir_asli =berat_akhir_asli-'4.260' WHERE kode_barang='PBDG-ZAXI-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0004','18','PBDG-ZAXI-59-0','1','2.840','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAXI-59-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAXI-59-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAXI-59-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAXI-59-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAXI-59-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.840',berat_out_asli='2.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.840',berat_akhir_asli =berat_akhir_asli-'2.840' WHERE kode_barang='PBDG-ZAXI-59-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260112-0004','2026-01-12','2026-01-12','14:22','2.840','input','2026-01-12 14:22:43','THIFA');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01541';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZAAB-1-0','00040837','DP-01541BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','5963500','2026-01-12','5963500','2.930','83.00','75','300000','2452000.00','1','0.14', 'input','2026-01-12 15:19:31','2.930','0','','16950.00','','TOKO','FREETAG','','2','','','PSN01541BIP','1','RS 13','','DP-01541');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZAAB-1-0','00040837');
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-12','PSGT-ZAAB-1-0','PSGT','TOKO','PSNB','83.00','2.930','2.930','1','2.930','2.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01541BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01542';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZAAB-2-0','00040838','DP-01542BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','330000','2026-01-12','330000','2.690','5.00','10','300000','2452000.00','1','0.14', 'input','2026-01-12 15:21:01','2.690','0','','16950.00','','TOKO','FREETAG','','10','','','PSN01542BIP','1','RS 16','','DP-01542');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZAAB-2-0','00040838');
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-12','PSPLT-ZAAB-2-0','PSPLT','TOKO','PSNB','5.00','2.690','2.690','1','2.690','2.690','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01542BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260112-0005','1','PSGT-ZAAB-1-0','1','2.930','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZAAB-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZAAB-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZAAB-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZAAB-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZAAB-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.930' WHERE kode_barang='PSGT-ZAAB-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-260112-0005','2','PSPLT-ZAAB-2-0','1','2.690','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAB-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAB-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAB-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAB-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAB-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.690',berat_out_asli='2.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.690',berat_akhir_asli =berat_akhir_asli-'2.690' WHERE kode_barang='PSPLT-ZAAB-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260112-0005','2026-01-12','2026-01-12','15:23','2.690','input','2026-01-12 15:23:06','THIFA');