INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','08:06:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-30';
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-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-30';
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-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-30' 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-31';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','08:07:12');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-31';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-31';
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-02-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-31' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','08:07:33');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-01' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','08:07:52');
UPDATE tp_curr SET rp= '17000.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '17000.00', 'input','2026-02-02 09:26:16');
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2767000',harga_beli ='2767000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5604500',harga_beli ='5604500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='218000',harga_beli ='218000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3170500',harga_beli ='3170500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7020000',harga_beli ='7020000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2630000',harga_beli ='2630000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2515500',harga_beli ='2515500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2561000',harga_beli ='2561000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6105000',harga_beli ='6105000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='22545000',harga_beli ='22545000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3137000',harga_beli ='3137000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3108500',harga_beli ='3108500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2937000',harga_beli ='2937000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3051500',harga_beli ='3051500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3023000',harga_beli ='3023000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8484500',harga_beli ='8484500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3248500',harga_beli ='3248500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='11637000',harga_beli ='11637000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4198000',harga_beli ='4198000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4934500',harga_beli ='4934500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5068500',harga_beli ='5068500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5961500',harga_beli ='5961500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4823000',harga_beli ='4823000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6899500',harga_beli ='6899500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8239000',harga_beli ='8239000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='9936000',harga_beli ='9936000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8038000',harga_beli ='8038000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='1675000',harga_beli ='1675000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3103500',harga_beli ='3103500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4733500',harga_beli ='4733500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2456000',harga_beli ='2456000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7256500',harga_beli ='7256500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8708000',harga_beli ='8708000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3885000',harga_beli ='3885000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7703000',harga_beli ='7703000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6118000',harga_beli ='6118000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2970000',harga_beli ='2970000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='2523000',harga_beli ='2523000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5738500',harga_beli ='5738500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4019000',harga_beli ='4019000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5957500',harga_beli ='5957500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7681000',harga_beli ='7681000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='11632500',harga_beli ='11632500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='10494000',harga_beli ='10494000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3840500',harga_beli ='3840500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5984000',harga_beli ='5984000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8350500',harga_beli ='8350500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7614000',harga_beli ='7614000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7837000',harga_beli ='7837000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8998000',harga_beli ='8998000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='17951000',harga_beli ='17951000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='1831000',harga_beli ='1831000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='1831000',harga_beli ='1831000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='1742000',harga_beli ='1742000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='1675000',harga_beli ='1675000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='9511500',harga_beli ='9511500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='10873500',harga_beli ='10873500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='9243500',harga_beli ='9243500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8663000',harga_beli ='8663000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='9489500',harga_beli ='9489500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8462000',harga_beli ='8462000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5046000',harga_beli ='5046000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='60573500',harga_beli ='60573500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='9422500',harga_beli ='9422500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8708000',harga_beli ='8708000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6453000',harga_beli ='6453000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='12392000',harga_beli ='12392000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='14380000',harga_beli ='14380000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='8261500',harga_beli ='8261500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6676000',harga_beli ='6676000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7323500',harga_beli ='7323500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5738500',harga_beli ='5738500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2690000','input','2026-02-02 09:26:26');
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='18864000',harga_beli ='18864000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='11067000',harga_beli ='11067000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5831000',harga_beli ='5831000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5876500',harga_beli ='5876500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='6819500',harga_beli ='6819500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='5176000',harga_beli ='5176000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='12856000',harga_beli ='12856000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='3946000',harga_beli ='3946000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='14795500',harga_beli ='14795500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='7033500',harga_beli ='7033500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2690000','input','2026-02-02 09:26:33');
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2690000','input','2026-02-02 09:26:38');
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2690000','input','2026-02-02 09:26:42');
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2690000','input','2026-02-02 09:26:45');
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2690000','input','2026-02-02 09:26:49');
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2690000','input','2026-02-02 09:26:56');
UPDATE tm_barang SET harga_skrg ='2690000',harga_jual='4064000',harga_beli ='4064000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2690000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2690000','input','2026-02-02 09:27:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','10:20:30');
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='';
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 ('PLBDG-ZBXB-1-0','00041270','PLBDG-00154 ','CINCIN PALADIUM PLBDG-00154 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','220500','2026-02-02','220500','1.080','17.00','10','250000','1200000.00','1','0.14', 'input','2026-02-02 11:22:45','1.080','0','','17000.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZBXB-1-0','00041270');
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-02-02','PLBDG-ZBXB-1-0','PLBDG','TOKO','PLBDG','17.00','1.080','1.080','1','1.080','1.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00154 ');
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='';
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 ('PLBDG-ZBXB-2-0','00041271','PLBDG-00155 ','CINCIN PALADIUM PLBDG-00155 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','251000','2026-02-02','251000','1.230','17.00','10','250000','1200000.00','1','0.14', 'input','2026-02-02 11:23:06','1.230','0','','17000.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZBXB-2-0','00041271');
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-02-02','PLBDG-ZBXB-2-0','PLBDG','TOKO','PLBDG','17.00','1.230','1.230','1','1.230','1.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00155 ');
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2664000',harga_beli ='2664000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5396000',harga_beli ='5396000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='210000',harga_beli ='210000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3053000',harga_beli ='3053000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6759000',harga_beli ='6759000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2532000',harga_beli ='2532000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2466000',harga_beli ='2466000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5878500',harga_beli ='5878500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='21707000',harga_beli ='21707000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3020000',harga_beli ='3020000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2993000',harga_beli ='2993000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2828000',harga_beli ='2828000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2938000',harga_beli ='2938000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2910500',harga_beli ='2910500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8169000',harga_beli ='8169000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3127500',harga_beli ='3127500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='11204500',harga_beli ='11204500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4041500',harga_beli ='4041500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4751000',harga_beli ='4751000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4880000',harga_beli ='4880000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5740000',harga_beli ='5740000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4643500',harga_beli ='4643500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6643000',harga_beli ='6643000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7932500',harga_beli ='7932500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='9566500',harga_beli ='9566500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7739000',harga_beli ='7739000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2988500',harga_beli ='2988500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4557500',harga_beli ='4557500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2365000',harga_beli ='2365000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6987000',harga_beli ='6987000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8384000',harga_beli ='8384000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3741000',harga_beli ='3741000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7416500',harga_beli ='7416500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5890500',harga_beli ='5890500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2859500',harga_beli ='2859500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='2429500',harga_beli ='2429500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5525000',harga_beli ='5525000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3869500',harga_beli ='3869500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5736000',harga_beli ='5736000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7395000',harga_beli ='7395000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='11200000',harga_beli ='11200000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='10104000',harga_beli ='10104000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3698000',harga_beli ='3698000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5761500',harga_beli ='5761500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8040000',harga_beli ='8040000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7331000',harga_beli ='7331000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7545500',harga_beli ='7545500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8663500',harga_beli ='8663500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='17284000',harga_beli ='17284000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='1763000',harga_beli ='1763000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='1763000',harga_beli ='1763000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='1677000',harga_beli ='1677000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='1612500',harga_beli ='1612500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5331500',harga_beli ='5331500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='9158000',harga_beli ='9158000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='10469500',harga_beli ='10469500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8900000',harga_beli ='8900000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8341000',harga_beli ='8341000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='9136500',harga_beli ='9136500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8147500',harga_beli ='8147500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4858500',harga_beli ='4858500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='58321500',harga_beli ='58321500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='9072000',harga_beli ='9072000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='8384000',harga_beli ='8384000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6213000',harga_beli ='6213000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='11931000',harga_beli ='11931000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='13845500',harga_beli ='13845500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7954000',harga_beli ='7954000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6428000',harga_beli ='6428000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='7051500',harga_beli ='7051500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5525000',harga_beli ='5525000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2590000','input','2026-02-02 13:16:02');
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='18162500',harga_beli ='18162500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='10655500',harga_beli ='10655500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5614000',harga_beli ='5614000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='5658000',harga_beli ='5658000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6566000',harga_beli ='6566000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='4983500',harga_beli ='4983500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='12378000',harga_beli ='12378000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3799500',harga_beli ='3799500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='14245000',harga_beli ='14245000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='6772000',harga_beli ='6772000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2590000','input','2026-02-02 13:16:09');
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2590000','input','2026-02-02 13:16:15');
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2590000','input','2026-02-02 13:16:18');
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2590000','input','2026-02-02 13:16:24');
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2590000','input','2026-02-02 13:16:29');
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2590000','input','2026-02-02 13:16:33');
UPDATE tm_barang SET harga_skrg ='2590000',harga_jual='3912500',harga_beli ='3912500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2590000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2590000','input','2026-02-02 13:16:37');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251227-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251227-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('ABRE-ZBXB-3-0','00041272','ABRE-02042 ','ANTING ABRE-02042 ','','GR','---','DM','ABRE','TOKO','ABRE','5167500','2026-02-02','5167500','2.660','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:24:55','2.660','0','138.30','17000.00','','TOKO','FREETAG','','10','','0','IDB 28 000 000','2','0226 2B4','BE-251227-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZBXB-3-0','00041272');
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-02-02','ABRE-ZBXB-3-0','ABRE','TOKO','ABRE','75.00','2.660','2.660','1','2.660','2.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02042 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-3-0','00041272','RD','2','0.050 ','420','21');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-3-0','00041272','RD','2','0.065 ','420','27.3');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-3-0','00041272','RD','34','0.200 ','450','90');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0001','1','ABRE-ZBXB-3-0','1','2.660','2.660','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZBXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','ABRE','ABRE-ZBXB-3-0','75.00','1','2.660','2.660','1','2.660','2.660');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.660',berat_out_asli=berat_out_asli+'2.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0001','2026-02-02','2026-02-02','13:25','2.66','input','2026-02-02 13:25:11');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260111-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260111-0005';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('ABRE-ZBXB-4-0','00041273','ABRE-01754 ','GIWANG ABRE-01754 ','','GR','---','DM','ABRE','TOKO','ABRE','4662000','2026-02-02','4662000','2.400','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:27:33','2.400','0','144.90','17000.00','','TOKO','FREETAG','','10','','0','IDB 26 500 000','2','0226 1B650','BE-260111-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZBXB-4-0','00041273');
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-02-02','ABRE-ZBXB-4-0','ABRE','TOKO','ABRE','75.00','2.400','2.400','1','2.400','2.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01754 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-4-0','00041273','RD','32','0.310 ','420','130.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-4-0','00041273','RD','2','0.035 ','420','14.7');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0002','1','ABRE-ZBXB-4-0','1','2.400','2.400','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZBXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','ABRE','ABRE-ZBXB-4-0','75.00','1','2.400','2.400','1','2.400','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0002','2026-02-02','2026-02-02','13:27','2.4','input','2026-02-02 13:27:45');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260119-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260119-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CBRE-ZBXB-5-0','00041274','CBR1911 ','CINCIN CBR1911 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2176000','2026-02-02','2176000','1.120','75.00','75','0','2590000.00','1','0.14', 'input','2026-02-02 13:30:01','1.120','0','20.80','17000.00','','TOKO','FREETAG','','10','','','IDB 9 000 000','1','RS12 1B9 0226','BE-260119-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXB-5-0','00041274');
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-02-02','CBRE-ZBXB-5-0','CBRE','TOKO','SEM-BALIK','75.00','1.120','1.120','1','1.120','1.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR1911 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-5-0','00041274','RD','1','0.040 ','320','12.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-5-0','00041274','RD','8','0.025 ','320','8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260124-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260124-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('KLBE-ZBXB-6-0','00041275','KLBE-00493 ','KALUNG KLBE-00493 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','8586000','2026-02-02','8586000','4.420','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:33:38','4.420','0','136.00','17000.00','','TOKO','FREETAG','','10','','0','IDB 39 500 000','3','4B6 0226','BE-260124-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZBXB-6-0','00041275');
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-02-02','KLBE-ZBXB-6-0','KLBE','TOKO','KLBE.BALIK','75.00','4.420','4.420','1','4.420','4.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00493 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZBXB-6-0','00041275','RD','13','0.425 ','320','136');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0003','1','KLBE-ZBXB-6-0','1','4.420','4.420','TOKO','KLBE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-ZBXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','KLBE','KLBE-ZBXB-6-0','75.00','1','4.420','4.420','1','4.420','4.420');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.420',berat_out_asli=berat_out_asli+'4.420',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='KLBE-ZBXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0003','2026-02-02','2026-02-02','13:33','4.42','input','2026-02-02 13:33:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260124-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260124-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('ABRE-ZBXB-7-0','00041276','ABRE-01734 ','ANTING ABRE-01734 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','11208500','2026-02-02','11208500','5.770','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:36:17','5.770','0','230.40','17000.00','','TOKO','FREETAG','','10','','0','IDB 52 500 000','3','12B0 0226','BE-260124-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZBXB-7-0','00041276');
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-02-02','ABRE-ZBXB-7-0','ABRE','TOKO','ABRE.BALIK','75.00','5.770','5.770','1','5.770','5.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01734 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-7-0','00041276','RD','62','0.720 ','320','230.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0004','1','ABRE-ZBXB-7-0','1','5.770','5.770','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','ABRE','ABRE-ZBXB-7-0','75.00','1','5.770','5.770','1','5.770','5.770');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.770',berat_out_asli=berat_out_asli+'5.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0004','2026-02-02','2026-02-02','13:36','5.77','input','2026-02-02 13:36:30');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260124-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260124-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CBRE-ZBXB-8-0','00041277','CBRE-06987 ','CBRE-06987 GIA 6485009440 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3691000','2026-02-02','3691000','1.900','75.00','75','0','2590000.00','1','0.14', 'input','2026-02-02 13:38:53','1.900','0','419.80','17000.00','','TOKO','FREETAG','','10','','','GIE 39 500 000','1','DVS1 10B4 0226','BE-260124-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXB-8-0','00041277');
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-02-02','CBRE-ZBXB-8-0','CBRE','TOKO','SEM-BALIK','75.00','1.900','1.900','1','1.900','1.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06987 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-8-0','00041277','OVAL','1','0.300 ','1250','375');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-8-0','00041277','RD','25','0.140 ','320','44.8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260125-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260125-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CBRE-ZBXB-9-0','00041278','CBRE-04768 ','CINCIN CBRE-04768 ','','GR','---','DM','CBRE','TOKO','CBRE','26146500','2026-02-02','26146500','13.460','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:41:59','13.460','0','355.80','17000.00','','TOKO','FREETAG','','10','','0','IDB 111 000 000','2','RS18 18B4 0226','BE-260125-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXB-9-0','00041278');
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-02-02','CBRE-ZBXB-9-0','CBRE','TOKO','CBRE','75.00','13.460','13.460','1','13.460','13.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04768 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-9-0','00041278','RD','1','0.310 ','900','279');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-9-0','00041278','RD','20','0.240 ','320','76.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0005','1','CBRE-ZBXB-9-0','1','13.460','13.460','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZBXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','CBRE','CBRE-ZBXB-9-0','75.00','1','13.460','13.460','1','13.460','13.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'13.460',berat_out_asli=berat_out_asli+'13.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0005','2026-02-02','2026-02-02','13:42','13.46','input','2026-02-02 13:42:12');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260126-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260126-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('LBRE-ZBXB-10-0','00041279','LBRE-00840 ','LIONTIN LBRE-00840 ','','GR','---','DM','LBRE','TOKO','LBRE.BALIK','4312500','2026-02-02','4312500','2.220','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:44:04','2.220','0','135.04','17000.00','','TOKO','FREETAG','','10','','0','IDB 24 500 000','2','6B4 0226','BE-260126-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZBXB-10-0','00041279');
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-02-02','LBRE-ZBXB-10-0','LBRE','TOKO','LBRE.BALIK','75.00','2.220','2.220','1','2.220','2.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00840 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZBXB-10-0','00041279','RD','16','0.422 ','320','135.04');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0006','1','LBRE-ZBXB-10-0','1','2.220','2.220','TOKO','LBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZBXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','LBRE','LBRE-ZBXB-10-0','75.00','1','2.220','2.220','1','2.220','2.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='LBRE-ZBXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0006','2026-02-02','2026-02-02','13:44','2.22','input','2026-02-02 13:44:16');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260126-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260126-0001';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('TFC-ZBXB-11-0','00041280','TFC-21197 ','CINCIN TFC-21197 ','','GR','---','DM','TFC','TOKO','TFC.BALIK','9635000','2026-02-02','9635000','4.960','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:46:54','4.960','0','248.00','17000.00','','TOKO','FREETAG','','10','','0','IDB 49 500 000','3','RS1512B250 0226','FB-260126-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZBXB-11-0','00041280');
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-02-02','TFC-ZBXB-11-0','TFC','TOKO','TFC.BALIK','75.00','4.960','4.960','1','4.960','4.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21197 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZBXB-11-0','00041280','RD','4','0.065 ','320','20.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZBXB-11-0','00041280','RD','8','0.360 ','320','115.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZBXB-11-0','00041280','RD','75','0.350 ','320','112');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0007','1','TFC-ZBXB-11-0','1','4.960','4.960','TOKO','TFC.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFC-ZBXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','TFC','TFC-ZBXB-11-0','75.00','1','4.960','4.960','1','4.960','4.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.960',berat_out_asli=berat_out_asli+'4.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='TFC-ZBXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0007','2026-02-02','2026-02-02','13:47','4.96','input','2026-02-02 13:47:07');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260127-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260127-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CKBE-ZBXB-12-0','00041281','CKBE-01179 ','CINCIN KAWIN CKBE-01179 ','','GR','---','DM','CKBE','TOKO','SEM-BALIK','4002000','2026-02-02','4002000','2.060','75.00','75','0','2590000.00','1','0.14', 'input','2026-02-02 13:48:59','2.060','0','9.60','17000.00','','TOKO','FREETAG','','10','','','IDB 17 500 000','1','RS13 1B750 0226','BE-260127-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-ZBXB-12-0','00041281');
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-02-02','CKBE-ZBXB-12-0','CKBE','TOKO','SEM-BALIK','75.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01179 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-ZBXB-12-0','00041281','RD','1','0.030 ','320','9.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CKPRE-ZBXB-13-0','00041282','700K-20-931 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','SEM-EMAS','426000','2026-02-02','426000','4.260','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-02 13:50:18','4.260','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBXB-13-0','00041282');
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-02-02','CKPRE-ZBXB-13-0','CKPRE','TOKO','SEM-EMAS','100.00','4.260','4.260','1','4.260','4.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-20-931 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('ABRE-ZBXB-14-0','00041283','ABRE-00736 ','ANTING ABRE-00736 ','','GR','---','DM','ABRE','TOKO','ABRE','4196000','2026-02-02','4196000','2.160','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:53:06','2.160','0','22.40','17000.00','','TOKO','FREETAG','','10','','0','IDB 18 000 000','2','2B8 0226','BE-260128-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZBXB-14-0','00041283');
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-02-02','ABRE-ZBXB-14-0','ABRE','TOKO','ABRE','75.00','2.160','2.160','1','2.160','2.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00736 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-14-0','00041283','RD','2','0.070 ','320','22.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0008','1','ABRE-ZBXB-14-0','1','2.160','2.160','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZBXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','ABRE','ABRE-ZBXB-14-0','75.00','1','2.160','2.160','1','2.160','2.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.160',berat_out_asli=berat_out_asli+'2.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0008','2026-02-02','2026-02-02','13:53','2.16','input','2026-02-02 13:53:21');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CBRE-ZBXB-15-0','00041284','CBRE-06921 ','CBRE-06921 GIA 1459911405 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3335000','2026-02-02','3335000','1.250','103.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:55:36','1.250','272000','279.25','17000.00','','TOKO','FREETAG','','10','','0','IDB 32 000 000','2','DVVS2 8B9 0226','BE-260128-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXB-15-0','00041284');
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-02-02','CBRE-ZBXB-15-0','CBRE','TOKO','CBRE.BALIK','103.00','1.250','1.250','1','1.250','1.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06921 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-15-0','00041284','RD','1','0.170 ','1550','263.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-15-0','00041284','RD','12','0.035 ','450','15.75');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0009','1','CBRE-ZBXB-15-0','1','1.250','1.250','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZBXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','CBRE','CBRE-ZBXB-15-0','103.00','1','1.250','1.250','1','1.250','1.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.250',berat_out_asli=berat_out_asli+'1.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0009','2026-02-02','2026-02-02','13:55','1.25','input','2026-02-02 13:55:48');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CBRE-ZBXB-16-0','00041285','CBRE-03971 ','CINCIN CBRE-03971 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','18784500','2026-02-02','18784500','9.670','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 13:57:35','9.670','0','260.80','17000.00','','TOKO','FREETAG','','10','','0','IDB 80 000 000','3','RS18 18B0 0226','BE-260128-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXB-16-0','00041285');
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-02-02','CBRE-ZBXB-16-0','CBRE','TOKO','CBRE.BALIK','75.00','9.670','9.670','1','9.670','9.670','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03971 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXB-16-0','00041285','RD','28','0.815 ','320','260.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0010','1','CBRE-ZBXB-16-0','1','9.670','9.670','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZBXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','CBRE','CBRE-ZBXB-16-0','75.00','1','9.670','9.670','1','9.670','9.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.670',berat_out_asli=berat_out_asli+'9.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0010','2026-02-02','2026-02-02','13:57','9.67','input','2026-02-02 13:57:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('AMR-ZBXB-17-0','00041286','AMRE75-76% ','ANTING MAS ROSE GOLD ','','GR','---','GOLD','AMR','TOKO','SEM-EMAS','5452500','2026-02-02','5452500','2.770','76.00','75','0','2590000.00','1','0.14', 'input','2026-02-02 13:59:12','2.770','0','','17000.00','','TOKO','FREETAG','','2','','','','3','','BE-260128-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'AMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('AMR','AMR-ZBXB-17-0','00041286');
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-02-02','AMR-ZBXB-17-0','AMR','TOKO','SEM-EMAS','76.00','2.770','2.770','1','2.770','2.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='AMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('AMR','AMRE75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0007';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0007';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CMK-ZBXB-18-0','00041287','CMKE70-71% ','CINCIN MAS KUNING ','','GR','---','GOLD','CMK','TOKO','SEM-EMAS','3843500','2026-02-02','3843500','2.090','71.00','70','0','2590000.00','1','0.14', 'input','2026-02-02 14:00:38','2.090','0','','17000.00','','TOKO','FREETAG','','2','','','','3','','BE-260128-0007','');
DELETE FROM tp_barang WHERE kode_dept = 'CMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMK','CMK-ZBXB-18-0','00041287');
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-02-02','CMK-ZBXB-18-0','CMK','TOKO','SEM-EMAS','71.00','2.090','2.090','1','2.090','2.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMK','CMKE70-71% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0005';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('KMK-ZBXB-19-0','00041288','KMKE70-71% ','KALUNG MAS KUNING ','','GR','---','GOLD','KMK','TOKO','SEM-EMAS','5351500','2026-02-02','5351500','2.910','71.00','70','0','2590000.00','1','0.14', 'input','2026-02-02 14:01:57','2.910','0','','17000.00','','TOKO','FREETAG','','2','','','','3','','BE-260128-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'KMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMK','KMK-ZBXB-19-0','00041288');
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-02-02','KMK-ZBXB-19-0','KMK','TOKO','SEM-EMAS','71.00','2.910','2.910','1','2.910','2.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KMK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMK','KMKE70-71% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260128-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260128-0006';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('LMK-ZBXB-20-0','00041289','LMKE70-71% ','LIONTIN MAS KUNING ','','GR','---','GOLD','LMK','TOKO','SEM-EMAS','3089500','2026-02-02','3089500','1.680','71.00','70','0','2590000.00','1','0.14', 'input','2026-02-02 14:03:32','1.680','0','','17000.00','','TOKO','FREETAG','','2','','','','3','','BE-260128-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'LMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMK','LMK-ZBXB-20-0','00041289');
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-02-02','LMK-ZBXB-20-0','LMK','TOKO','SEM-EMAS','71.00','1.680','1.680','1','1.680','1.680','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMK','LMKE70-71% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260129-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260129-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('ABRE-ZBXB-21-0','00041290','ABRE-00446 ','GIWANG ABRE-00446 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','3458000','2026-02-02','3458000','1.780','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 14:05:52','1.780','0','73.60','17000.00','','TOKO','FREETAG','','10','','0','IDB 18 500 000','3','3B450 0226','BE-260129-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZBXB-21-0','00041290');
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-02-02','ABRE-ZBXB-21-0','ABRE','TOKO','ABRE.BALIK','75.00','1.780','1.780','1','1.780','1.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00446 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-21-0','00041290','RD','26','0.190 ','320','60.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZBXB-21-0','00041290','RD','12','0.040 ','320','12.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0011','1','ABRE-ZBXB-21-0','1','1.780','1.780','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZBXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','ABRE','ABRE-ZBXB-21-0','75.00','1','1.780','1.780','1','1.780','1.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.780',berat_out_asli=berat_out_asli+'1.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0011','2026-02-02','2026-02-02','14:06','1.78','input','2026-02-02 14:06:23');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260129-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260129-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('CKBE-ZBXB-22-0','00041291','CKBE-00257 ','CINCIN KAWIN CKBE-00257 ','','GR','---','DM','CKBE','TOKO','CKBE','6371500','2026-02-02','6371500','3.280','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 14:08:18','3.280','0','68.20','17000.00','','TOKO','FREETAG','','10','','0','IDB 31 500 000','2','RS1353B150 0226','BE-260129-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-ZBXB-22-0','00041291');
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-02-02','CKBE-ZBXB-22-0','CKBE','TOKO','CKBE','75.00','3.280','3.280','1','3.280','3.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-00257 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-ZBXB-22-0','00041291','RD','1','0.110 ','620','68.2');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0012','1','CKBE-ZBXB-22-0','1','3.280','3.280','TOKO','CKBE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CKBE-ZBXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CKBE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','CKBE','CKBE-ZBXB-22-0','75.00','1','3.280','3.280','1','3.280','3.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.280',berat_out_asli=berat_out_asli+'3.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CKBE-ZBXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CKBE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0012','2026-02-02','2026-02-02','14:08','3.28','input','2026-02-02 14:08:30');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260129-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260129-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('LBRE-ZBXB-23-0','00041292','LBRE-00566 ','LIONTIN LBRE-00566 ','','GR','---','DM','LBRE','TOKO','LBRE','2273000','2026-02-02','2273000','1.170','75.00','75','0','2590000.00','1','0.04', 'input','2026-02-02 14:10:26','1.170','0','104.00','17000.00','','TOKO','FREETAG','','10','','0','IDB 16 000 000','2','4B0 0226','BE-260129-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZBXB-23-0','00041292');
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-02-02','LBRE-ZBXB-23-0','LBRE','TOKO','LBRE','75.00','1.170','1.170','1','1.170','1.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00566 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZBXB-23-0','00041292','RD','1','0.055 ','320','17.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZBXB-23-0','00041292','RD','4','0.095 ','320','30.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZBXB-23-0','00041292','RD','4','0.050 ','320','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZBXB-23-0','00041292','RD','28','0.125 ','320','40');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0013','1','LBRE-ZBXB-23-0','1','1.170','1.170','TOKO','LBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZBXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','SEM-BALIK','LBRE','LBRE-ZBXB-23-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='LBRE-ZBXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0013','2026-02-02','2026-02-02','14:10','1.17','input','2026-02-02 14:10:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','14:49:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-02 ','14:50:28');
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-01617';
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-ZBXB-24-0','00041293','DP-01617BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','4321000','2026-02-02','4321000','2.010','83.00','75','300000','2590000.00','1','0.14', 'input','2026-02-02 14:53:19','2.010','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01617BIP','1','RS 13','','DP-01617');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZBXB-24-0','00041293');
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-02-02','PSGT-ZBXB-24-0','PSGT','TOKO','PSNB','83.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01617BIP ');
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-01632';
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 ('PSPRT-ZBXB-25-0','00041294','DP-01632BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','329000','2026-02-02','329000','3.290','100.00','925','400000','100000.00','1','0.14', 'input','2026-02-02 14:55:32','3.290','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01632BIP','1','RS 10 5 RS 15','','DP-01632');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXB-25-0','00041294');
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-02-02','PSPRT-ZBXB-25-0','PSPRT','TOKO','PSNB','100.00','3.290','3.290','1','3.290','3.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01632BIP ');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0014','1','ABRE-ZBXB-14-0','1','2.160','2.160','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZBXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','ABRE.BALIK','ABRE','ABRE-ZBXB-14-0','75.00','1','2.160','2.160','1','2.160','2.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.160',berat_out_asli=berat_out_asli+'2.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0014','2','ABRE-ZBXB-7-0','1','5.770','5.770','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'5.770',berat_in_asli=berat_in_asli+'5.770',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'5.770',berat_akhir_asli=berat_akhir_asli+'5.770' WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.770',berat_out_asli=berat_out_asli+'5.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0014','3','ABRE-ZBXB-3-0','1','2.660','2.660','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZBXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','ABRE.BALIK','ABRE','ABRE-ZBXB-3-0','75.00','1','2.660','2.660','1','2.660','2.660');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.660',berat_out_asli=berat_out_asli+'2.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0014','4','ABRE-ZBXB-21-0','1','1.780','1.780','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZBXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.780',berat_in_asli=berat_in_asli+'1.780',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.780',berat_akhir_asli=berat_akhir_asli+'1.780' WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.780',berat_out_asli=berat_out_asli+'1.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0014','5','ABRE-ZBXB-4-0','1','2.400','2.400','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZBXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','ABRE.BALIK','ABRE','ABRE-ZBXB-4-0','75.00','1','2.400','2.400','1','2.400','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='ABRE-ZBXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0014','2026-02-02','2026-02-02','15:23','14.77','input','2026-02-02 15:24:25');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0015','1','CBRE-ZBXB-15-0','1','1.250','1.250','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZBXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.250',berat_in_asli=berat_in_asli+'1.250',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250' WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.250',berat_out_asli=berat_out_asli+'1.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0015','2','CBRE-ZBXB-8-0','1','1.900','1.900','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZBXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZBXB-8-0','75.00','1','1.900','1.900','1','1.900','1.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.900',berat_out_asli=berat_out_asli+'1.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0015','3','CBRE-ZBXB-5-0','1','1.120','1.120','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZBXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZBXB-5-0','75.00','1','1.120','1.120','1','1.120','1.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0015','4','CBRE-ZBXB-16-0','1','9.670','9.670','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZBXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'9.670',berat_in_asli=berat_in_asli+'9.670',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'9.670',berat_akhir_asli=berat_akhir_asli+'9.670' WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.670',berat_out_asli=berat_out_asli+'9.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0015','5','CBRE-ZBXB-9-0','1','13.460','13.460','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZBXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CBRE.BALIK','CBRE','CBRE-ZBXB-9-0','75.00','1','13.460','13.460','1','13.460','13.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'13.460',berat_out_asli=berat_out_asli+'13.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CBRE-ZBXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0015','2026-02-02','2026-02-02','15:25','27.4','input','2026-02-02 15:25:28');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0016','1','CKBE-ZBXB-22-0','1','3.280','3.280','TOKO','SEM-BALIK','TOKO','CKBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKBE.BALIK' WHERE kode_barang='CKBE-ZBXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CKBE.BALIK','CKBE','CKBE-ZBXB-22-0','75.00','1','3.280','3.280','1','3.280','3.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.280',berat_out_asli=berat_out_asli+'3.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CKBE-ZBXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0016','2','CKBE-ZBXB-12-0','1','2.060','2.060','TOKO','SEM-BALIK','TOKO','CKBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKBE.BALIK' WHERE kode_barang='CKBE-ZBXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CKBE.BALIK','CKBE','CKBE-ZBXB-12-0','75.00','1','2.060','2.060','1','2.060','2.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.060',berat_out_asli=berat_out_asli+'2.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CKBE-ZBXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0016','2026-02-02','2026-02-02','15:25','5.34','input','2026-02-02 15:25:51');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0017','1','KLBE-ZBXB-6-0','1','4.420','4.420','TOKO','SEM-BALIK','TOKO','KLBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KLBE.BALIK' WHERE kode_barang='KLBE-ZBXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'4.420',berat_in_asli=berat_in_asli+'4.420',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.420',berat_akhir_asli=berat_akhir_asli+'4.420' WHERE tanggal='2026-02-02' AND kode_barang='KLBE-ZBXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.420',berat_out_asli=berat_out_asli+'4.420',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='KLBE-ZBXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0017','2026-02-02','2026-02-02','15:25','4.42','input','2026-02-02 15:26:07');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0018','1','LBRE-ZBXB-23-0','1','1.170','1.170','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-ZBXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','LBRE.BALIK','LBRE','LBRE-ZBXB-23-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='LBRE-ZBXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0018','2','LBRE-ZBXB-10-0','1','2.220','2.220','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-ZBXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.220',berat_in_asli=berat_in_asli+'2.220',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.220',berat_akhir_asli=berat_akhir_asli+'2.220' WHERE tanggal='2026-02-02' AND kode_barang='LBRE-ZBXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='LBRE-ZBXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0018','2026-02-02','2026-02-02','15:26','3.39','input','2026-02-02 15:26:23');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0019','1','TFC-ZBXB-11-0','1','4.960','4.960','TOKO','SEM-BALIK','TOKO','TFC.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZBXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'4.960',berat_in_asli=berat_in_asli+'4.960',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.960',berat_akhir_asli=berat_akhir_asli+'4.960' WHERE tanggal='2026-02-02' AND kode_barang='TFC-ZBXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.960',berat_out_asli=berat_out_asli+'4.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='TFC-ZBXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0019','2026-02-02','2026-02-02','15:26','4.96','input','2026-02-02 15:26:37');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0020','1','AMR-ZBXB-17-0','1','2.770','2.770','TOKO','SEM-EMAS','TOKO','AMRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='AMRE.BALIK' WHERE kode_barang='AMR-ZBXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','AMRE.BALIK','AMR','AMR-ZBXB-17-0','76.00','1','2.770','2.770','1','2.770','2.770');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.770',berat_out_asli=berat_out_asli+'2.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='AMR-ZBXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0020','2026-02-02','2026-02-02','15:26','2.77','input','2026-02-02 15:26:57');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0021','1','CMK-ZBXB-18-0','1','2.090','2.090','TOKO','SEM-EMAS','TOKO','CMKE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMKE.BALIK' WHERE kode_barang='CMK-ZBXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','CMKE.BALIK','CMK','CMK-ZBXB-18-0','71.00','1','2.090','2.090','1','2.090','2.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.090',berat_out_asli=berat_out_asli+'2.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CMK-ZBXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0021','2026-02-02','2026-02-02','15:26','2.09','input','2026-02-02 15:27:08');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0022','1','KMK-ZBXB-19-0','1','2.910','2.910','TOKO','SEM-EMAS','TOKO','KMKE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KMKE.BALIK' WHERE kode_barang='KMK-ZBXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','KMKE.BALIK','KMK','KMK-ZBXB-19-0','71.00','1','2.910','2.910','1','2.910','2.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.910',berat_out_asli=berat_out_asli+'2.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='KMK-ZBXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0022','2026-02-02','2026-02-02','15:27','2.91','input','2026-02-02 15:27:19');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0023','1','LMK-ZBXB-20-0','1','1.680','1.680','TOKO','SEM-EMAS','TOKO','LMKE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LMKE.BALIK' WHERE kode_barang='LMK-ZBXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','LMKE.BALIK','LMK','LMK-ZBXB-20-0','71.00','1','1.680','1.680','1','1.680','1.680');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.680',berat_out_asli=berat_out_asli+'1.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='LMK-ZBXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0023','2026-02-02','2026-02-02','15:27','1.68','input','2026-02-02 15:27:37');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260202-0024','1','CKPRE-ZBXB-13-0','1','4.260','4.260','TOKO','SEM-EMAS','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-ZBXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-02-02','TOKO','PER','CKPRE','CKPRE-ZBXB-13-0','100.00','1','4.260','4.260','1','4.260','4.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.260',berat_out_asli=berat_out_asli+'4.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-02' AND kode_barang='CKPRE-ZBXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260202-0024','2026-02-02','2026-02-02','15:27','4.26','input','2026-02-02 15:27:52');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260202-0001','1','PLBDG-ZBXB-1-0','1','1.080','TOKO','PLBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZBXB-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZBXB-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZBXB-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZBXB-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZBXB-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.080' WHERE kode_barang='PLBDG-ZBXB-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-260202-0001','2','PLBDG-ZBXB-2-0','1','1.230','TOKO','PLBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZBXB-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZBXB-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZBXB-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZBXB-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZBXB-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.230',berat_out_asli='1.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.230',berat_akhir_asli =berat_akhir_asli-'1.230' WHERE kode_barang='PLBDG-ZBXB-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-260202-0001','2026-02-02','2026-02-02','15:28','1.230','input','2026-02-02 15:28:19','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260202-0002','1','PSGT-ZBXB-24-0','1','2.010','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZBXB-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZBXB-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZBXB-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZBXB-24-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-ZBXB-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PSGT-ZBXB-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-260202-0002','2','PSPRT-ZBXB-25-0','1','3.290','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZBXB-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZBXB-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZBXB-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZBXB-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' 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='PSPRT-ZBXB-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.290',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.290',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='PSPRT-ZBXB-25-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-260202-0002','2026-02-02','2026-02-02','15:28','3.290','input','2026-02-02 15:28:29','THIFA');