INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','08:28:30');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-28';
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-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-28';
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-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-28' 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-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','08:28:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','08:41:15');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260129-0001','1','PSPRT-ZABH-8-0','1','4.750','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZABH-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZABH-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZABH-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZABH-8-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='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZABH-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.750',berat_out_asli='4.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.750',berat_akhir_asli =berat_akhir_asli-'4.750' WHERE kode_barang='PSPRT-ZABH-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260129-0001','2026-01-29','2026-01-29','08:45','4.750','input','2026-01-29 08:45:40','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','09:02:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','10:34:42');
UPDATE tm_group SET harga='1200000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','1200000','input','2026-01-29 10:47:30');
UPDATE tm_group SET harga='1200000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','1200000','input','2026-01-29 10:47:35');
UPDATE tm_group SET harga='1200000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','1200000','input','2026-01-29 10:47:46');
UPDATE tm_group SET harga='100000' WHERE kode_group = 'PSPRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPRE','100000','input','2026-01-29 10:47:52');
UPDATE tm_group SET harga='100000' WHERE kode_group = 'PSPRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPRL','100000','input','2026-01-29 10:47:57');
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='584000',harga_beli ='584000' WHERE kode_barcode='00021134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='251500',harga_beli ='251500' WHERE kode_barcode='00036894' LIMIT 1;
UPDATE tm_group SET harga='100000' WHERE kode_group = 'PSPRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPRT','100000','input','2026-01-29 10:48:03');
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='288000',harga_beli ='288000' WHERE kode_barcode='00003680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='405000',harga_beli ='405000' WHERE kode_barcode='00003681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='323000',harga_beli ='323000' WHERE kode_barcode='00003682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='415500',harga_beli ='415500' WHERE kode_barcode='00003683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='317000',harga_beli ='317000' WHERE kode_barcode='00003684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='399000',harga_beli ='399000' WHERE kode_barcode='00003685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='247500',harga_beli ='247500' WHERE kode_barcode='00003686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='346000',harga_beli ='346000' WHERE kode_barcode='00003687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='240000',harga_beli ='240000' WHERE kode_barcode='00003688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='236000',harga_beli ='236000' WHERE kode_barcode='00003689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='239000',harga_beli ='239000' WHERE kode_barcode='00003690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='280000',harga_beli ='280000' WHERE kode_barcode='00003691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='291000',harga_beli ='291000' WHERE kode_barcode='00003715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='280000',harga_beli ='280000' WHERE kode_barcode='00003716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='416000',harga_beli ='416000' WHERE kode_barcode='00003717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='287000',harga_beli ='287000' WHERE kode_barcode='00003718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='396000',harga_beli ='396000' WHERE kode_barcode='00003719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='229000',harga_beli ='229000' WHERE kode_barcode='00003720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='372000',harga_beli ='372000' WHERE kode_barcode='00003721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='241000',harga_beli ='241000' WHERE kode_barcode='00003722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='329000',harga_beli ='329000' WHERE kode_barcode='00003724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='410500',harga_beli ='410500' WHERE kode_barcode='00003725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='282000',harga_beli ='282000' WHERE kode_barcode='00003726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='421000',harga_beli ='421000' WHERE kode_barcode='00003727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='339000',harga_beli ='339000' WHERE kode_barcode='00003728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='205500',harga_beli ='205500' WHERE kode_barcode='00003729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='210000',harga_beli ='210000' WHERE kode_barcode='00003730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='329000',harga_beli ='329000' WHERE kode_barcode='00003731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='236000',harga_beli ='236000' WHERE kode_barcode='00003732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='219000',harga_beli ='219000' WHERE kode_barcode='00003733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='347000',harga_beli ='347000' WHERE kode_barcode='00003734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='234000',harga_beli ='234000' WHERE kode_barcode='00003735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='270000',harga_beli ='270000' WHERE kode_barcode='00003736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='340000',harga_beli ='340000' WHERE kode_barcode='00003737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='238000',harga_beli ='238000' WHERE kode_barcode='00003738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='433000',harga_beli ='433000' WHERE kode_barcode='00003739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='411500',harga_beli ='411500' WHERE kode_barcode='00003740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='422000',harga_beli ='422000' WHERE kode_barcode='00003741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='248000',harga_beli ='248000' WHERE kode_barcode='00003742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='291000',harga_beli ='291000' WHERE kode_barcode='00003743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='448500',harga_beli ='448500' WHERE kode_barcode='00003744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='381000',harga_beli ='381000' WHERE kode_barcode='00003745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='256000',harga_beli ='256000' WHERE kode_barcode='00003746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='249500',harga_beli ='249500' WHERE kode_barcode='00003747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='217000',harga_beli ='217000' WHERE kode_barcode='00003806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='214000',harga_beli ='214000' WHERE kode_barcode='00003807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='283000',harga_beli ='283000' WHERE kode_barcode='00003808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='204000',harga_beli ='204000' WHERE kode_barcode='00003809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='176000',harga_beli ='176000' WHERE kode_barcode='00003810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='157000',harga_beli ='157000' WHERE kode_barcode='00003811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='394000',harga_beli ='394000' WHERE kode_barcode='00003812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='300000',harga_beli ='300000' WHERE kode_barcode='00003813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='331000',harga_beli ='331000' WHERE kode_barcode='00003814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='369000',harga_beli ='369000' WHERE kode_barcode='00003815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='268000',harga_beli ='268000' WHERE kode_barcode='00003816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='220500',harga_beli ='220500' WHERE kode_barcode='00003817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='220500',harga_beli ='220500' WHERE kode_barcode='00003818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='422000',harga_beli ='422000' WHERE kode_barcode='00003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='100000',harga_jual='433000',harga_beli ='433000' WHERE kode_barcode='00003931' LIMIT 1;
UPDATE tm_group SET harga='100000' WHERE kode_group = 'PER' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PER','100000','input','2026-01-29 10:48:08');
UPDATE tm_group SET harga='100000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','100000','input','2026-01-29 10:48:15');
UPDATE tm_group SET harga='1200000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','1200000','input','2026-01-29 10:48:50');
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3034500',harga_beli ='3034500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6146000',harga_beli ='6146000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='239000',harga_beli ='239000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3477000',harga_beli ='3477000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7698500',harga_beli ='7698500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2884000',harga_beli ='2884000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2758500',harga_beli ='2758500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2808500',harga_beli ='2808500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6695500',harga_beli ='6695500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='24724000',harga_beli ='24724000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3440000',harga_beli ='3440000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3408500',harga_beli ='3408500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3221000',harga_beli ='3221000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3346000',harga_beli ='3346000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3315000',harga_beli ='3315000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9304500',harga_beli ='9304500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3562500',harga_beli ='3562500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='12762000',harga_beli ='12762000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4603500',harga_beli ='4603500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5411500',harga_beli ='5411500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5558500',harga_beli ='5558500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6538000',harga_beli ='6538000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5289000',harga_beli ='5289000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7566000',harga_beli ='7566000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9035000',harga_beli ='9035000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='10896000',harga_beli ='10896000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8815000',harga_beli ='8815000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='1836500',harga_beli ='1836500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3403500',harga_beli ='3403500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5191000',harga_beli ='5191000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4701500',harga_beli ='4701500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2693500',harga_beli ='2693500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2595500',harga_beli ='2595500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7958000',harga_beli ='7958000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9549500',harga_beli ='9549500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4260500',harga_beli ='4260500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8447500',harga_beli ='8447500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6709000',harga_beli ='6709000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='3257000',harga_beli ='3257000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2767000',harga_beli ='2767000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6293000',harga_beli ='6293000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6533000',harga_beli ='6533000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8423000',harga_beli ='8423000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='12757000',harga_beli ='12757000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='11508000',harga_beli ='11508000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4211500',harga_beli ='4211500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6562500',harga_beli ='6562500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9157500',harga_beli ='9157500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8349500',harga_beli ='8349500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8594500',harga_beli ='8594500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9867500',harga_beli ='9867500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='19686000',harga_beli ='19686000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2008000',harga_beli ='2008000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='2008000',harga_beli ='2008000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='1836500',harga_beli ='1836500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6072500',harga_beli ='6072500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='10431000',harga_beli ='10431000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='11924500',harga_beli ='11924500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='10137000',harga_beli ='10137000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9500500',harga_beli ='9500500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='10406500',harga_beli ='10406500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9280000',harga_beli ='9280000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5534000',harga_beli ='5534000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='66428000',harga_beli ='66428000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='10333000',harga_beli ='10333000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9549500',harga_beli ='9549500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7076500',harga_beli ='7076500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='13589500',harga_beli ='13589500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='15770000',harga_beli ='15770000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='9059500',harga_beli ='9059500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7321500',harga_beli ='7321500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='8031500',harga_beli ='8031500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6293000',harga_beli ='6293000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2950000','input','2026-01-29 11:04:39');
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='20687000',harga_beli ='20687000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='12136500',harga_beli ='12136500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6394500',harga_beli ='6394500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='6444500',harga_beli ='6444500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7478500',harga_beli ='7478500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='5676500',harga_beli ='5676500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='14098500',harga_beli ='14098500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4327500',harga_beli ='4327500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='16225500',harga_beli ='16225500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='7713000',harga_beli ='7713000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2950000','input','2026-01-29 11:04:48');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2950000','input','2026-01-29 11:04:53');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2950000','input','2026-01-29 11:04:57');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2950000','input','2026-01-29 11:05:00');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2950000','input','2026-01-29 11:05:03');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2950000','input','2026-01-29 11:05:07');
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2950000','input','2026-01-29 11:05:13');
UPDATE tm_barang SET harga_skrg ='2950000',harga_jual='4456500',harga_beli ='4456500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2950000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2950000','input','2026-01-29 11:05:16');
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 ('ABRE-ZABI-1-0','00041202','ABRE-02101 ','GIWANG ABRE-02101 ','','GR','---','DM','ABRE','TOKO','SEM-ELCO','6897500','2026-01-29','6897500','2.270','103.00','75','0','2950000.00','1','0.14', 'input','2026-01-29 11:07:53','2.270','295000','132.00','17100.00','','TOKO','FREETAG','','10','','','IDR 35 000 000','1','0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZABI-1-0','00041202');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','ABRE-ZABI-1-0','ABRE','TOKO','SEM-ELCO','103.00','2.270','2.270','1','2.270','2.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02101 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-1-0','00041202','RD','2','0.020 ','400','8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-1-0','00041202','RD','2','0.045 ','400','18');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-1-0','00041202','RD','6','0.040 ','450','18');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-1-0','00041202','RD','8','0.220 ','400','88');
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 ('ABRE-ZABI-2-0','00041203','ABRE-02102 ','GIWANG ABRE-02102 ','','GR','---','DM','ABRE','TOKO','SEM-ELCO','3306000','2026-01-29','3306000','1.350','83.00','75','0','2950000.00','1','0.14', 'input','2026-01-29 11:11:05','1.350','485000','55.75','17100.00','','TOKO','FREETAG','','10','','','IDR 17 500 000','1','0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZABI-2-0','00041203');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','ABRE-ZABI-2-0','ABRE','TOKO','SEM-ELCO','83.00','1.350','1.350','1','1.350','1.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02102 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-2-0','00041203','RD','2','0.055 ','400','22');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZABI-2-0','00041203','RD','16','0.075 ','450','33.75');
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 ('CBRE-ZABI-3-0','00041204','CBRE-06985 ','CINCIN CBRE-06985 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3110000','2026-01-29','3110000','1.270','83.00','75','0','2950000.00','1','0.14', 'input','2026-01-29 11:14:09','1.270','440000','58.73','17100.00','','TOKO','FREETAG','','10','','','IDR 17 000 000','1','RS16 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABI-3-0','00041204');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','CBRE-ZABI-3-0','CBRE','TOKO','SEM-ELCO','83.00','1.270','1.270','1','1.270','1.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06985 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABI-3-0','00041204','RD','1','0.075 ','475','35.63');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABI-3-0','00041204','RD','8','0.055 ','420','23.1');
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 ('CBRE-ZABI-4-0','00041205','CBRE-06986 ','CINCIN CBRE-06986 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4554500','2026-01-29','4554500','1.860','83.00','75','0','2950000.00','1','0.14', 'input','2026-01-29 11:16:15','1.860','525000','87.55','17100.00','','TOKO','FREETAG','','10','','','IDR 24 500 000','1','RS 13 5 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABI-4-0','00041205');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','CBRE-ZABI-4-0','CBRE','TOKO','SEM-ELCO','83.00','1.860','1.860','1','1.860','1.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06986 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABI-4-0','00041205','RD','6','0.090 ','370','33.3');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABI-4-0','00041205','RD','2','0.040 ','400','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABI-4-0','00041205','RD','8','0.085 ','450','38.25');
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3085500',harga_beli ='3085500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6250000',harga_beli ='6250000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='243000',harga_beli ='243000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3536000',harga_beli ='3536000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7828500',harga_beli ='7828500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2932500',harga_beli ='2932500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2805000',harga_beli ='2805000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2856500',harga_beli ='2856500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6808500',harga_beli ='6808500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='25143000',harga_beli ='25143000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3498500',harga_beli ='3498500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3466500',harga_beli ='3466500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3275500',harga_beli ='3275500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3403000',harga_beli ='3403000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3371000',harga_beli ='3371000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9462000',harga_beli ='9462000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='12978000',harga_beli ='12978000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4681500',harga_beli ='4681500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5503000',harga_beli ='5503000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5652500',harga_beli ='5652500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6648500',harga_beli ='6648500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5378500',harga_beli ='5378500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7694500',harga_beli ='7694500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9188500',harga_beli ='9188500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='11080500',harga_beli ='11080500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8964000',harga_beli ='8964000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='1867500',harga_beli ='1867500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3461500',harga_beli ='3461500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5279000',harga_beli ='5279000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4781000',harga_beli ='4781000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2739000',harga_beli ='2739000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2639500',harga_beli ='2639500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8092500',harga_beli ='8092500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9711000',harga_beli ='9711000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4333000',harga_beli ='4333000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8590500',harga_beli ='8590500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6823000',harga_beli ='6823000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3312000',harga_beli ='3312000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2814000',harga_beli ='2814000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6399500',harga_beli ='6399500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4482000',harga_beli ='4482000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6643500',harga_beli ='6643500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8566000',harga_beli ='8566000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='12973000',harga_beli ='12973000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='11703000',harga_beli ='11703000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4283000',harga_beli ='4283000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6673500',harga_beli ='6673500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9313000',harga_beli ='9313000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8491000',harga_beli ='8491000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8740000',harga_beli ='8740000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='10035000',harga_beli ='10035000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='20020000',harga_beli ='20020000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2042000',harga_beli ='2042000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='2042000',harga_beli ='2042000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='1942500',harga_beli ='1942500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='1867500',harga_beli ='1867500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6175500',harga_beli ='6175500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='10607500',harga_beli ='10607500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='12126500',harga_beli ='12126500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='10309000',harga_beli ='10309000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9661500',harga_beli ='9661500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='10582500',harga_beli ='10582500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9437500',harga_beli ='9437500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5627500',harga_beli ='5627500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='67554000',harga_beli ='67554000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='10508000',harga_beli ='10508000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9711000',harga_beli ='9711000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7196500',harga_beli ='7196500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='13819500',harga_beli ='13819500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='16037500',harga_beli ='16037500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='9213000',harga_beli ='9213000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7445500',harga_beli ='7445500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='8167500',harga_beli ='8167500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6399500',harga_beli ='6399500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7014500',harga_beli ='7014500' WHERE kode_barcode='00041202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3361500',harga_beli ='3361500' WHERE kode_barcode='00041203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='3162500',harga_beli ='3162500' WHERE kode_barcode='00041204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4631500',harga_beli ='4631500' WHERE kode_barcode='00041205' LIMIT 1;
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','3000000','input','2026-01-29 13:04:08');
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='21037500',harga_beli ='21037500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='12342000',harga_beli ='12342000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6502500',harga_beli ='6502500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='6553500',harga_beli ='6553500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7605000',harga_beli ='7605000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='5772500',harga_beli ='5772500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='14337500',harga_beli ='14337500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4400500',harga_beli ='4400500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='16500500',harga_beli ='16500500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='7843500',harga_beli ='7843500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','3000000','input','2026-01-29 13:04:16');
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','3000000','input','2026-01-29 13:04:21');
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','3000000','input','2026-01-29 13:04:25');
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','3000000','input','2026-01-29 13:04:30');
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','3000000','input','2026-01-29 13:04:34');
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','3000000','input','2026-01-29 13:04:38');
UPDATE tm_barang SET harga_skrg ='3000000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='3000000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','3000000','input','2026-01-29 13:04:45');
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 ('TFGRR-ZABI-5-0','00041206','TFGRR75-85% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','5814500','2026-01-29','5814500','2.280','85.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 15:56:16','2.280','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZABI-5-0','00041206');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGRR-ZABI-5-0','TFGRR','TOKO','GLRTF','85.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-85% ');
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 ('TFKMR-ZABI-6-0','00041207','TFKMR75-85% ','THIFA KALUNG MAS RG ','','GR','---','GOLD','TFKMR','TOKO','KMPTF','14560500','2026-01-29','14560500','5.710','85.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 15:57:10','5.710','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFKMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFKMR','TFKMR-ZABI-6-0','00041207');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFKMR-ZABI-6-0','TFKMR','TOKO','KMPTF','85.00','5.710','5.710','1','5.710','5.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFKMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFKMR','TFKMR75-85% ');
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 ('TFGRR-ZABI-7-0','00041208','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','7271000','2026-01-29','7271000','2.920','83.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 15:58:10','2.920','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZABI-7-0','00041208');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGRR-ZABI-7-0','TFGRR','TOKO','GLRTF','83.00','2.920','2.920','1','2.920','2.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% ');
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 ('TFGRR-ZABI-8-0','00041209','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','10931500','2026-01-29','10931500','4.390','83.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 15:59:01','4.390','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZABI-8-0','00041209');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGRR-ZABI-8-0','TFGRR','TOKO','GLRTF','83.00','4.390','4.390','1','4.390','4.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% ');
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 ('TFCMR-ZABI-9-0','00041210','TFCMR75-87% ','THIFA CINCIN MAS RG ','','GR','---','GOLD','TFCMR','TOKO','CMPTF','6786000','2026-01-29','6786000','2.600','87.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 16:00:17','2.600','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFCMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFCMR','TFCMR-ZABI-9-0','00041210');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFCMR-ZABI-9-0','TFCMR','TOKO','CMPTF','87.00','2.600','2.600','1','2.600','2.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFCMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFCMR','TFCMR75-87% ');
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 ('TFGRR-ZABI-10-0','00041211','TFGRR75-87% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','21846000','2026-01-29','21846000','8.370','87.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 16:01:05','8.370','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZABI-10-0','00041211');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGRR-ZABI-10-0','TFGRR','TOKO','GLRTF','87.00','8.370','8.370','1','8.370','8.370','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-87% ');
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 ('TFGKR-ZABI-11-0','00041212','TFGKR75-87% ','THIFA GELANG KAKU RG ','','GR','---','GOLD','TFGKR','TOKO','GLKTF','19079500','2026-01-29','19079500','7.310','87.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 16:02:08','7.310','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGKR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGKR','TFGKR-ZABI-11-0','00041212');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGKR-ZABI-11-0','TFGKR','TOKO','GLKTF','87.00','7.310','7.310','1','7.310','7.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGKR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGKR','TFGKR75-87% ');
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 ('TFGKR-ZABI-12-0','00041213','TFGKR75-87% ','THIFA GELANG KAKU RG ','','GR','---','GOLD','TFGKR','TOKO','GLKTF','18505000','2026-01-29','18505000','7.090','87.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 16:02:40','7.090','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGKR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGKR','TFGKR-ZABI-12-0','00041213');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGKR-ZABI-12-0','TFGKR','TOKO','GLKTF','87.00','7.090','7.090','1','7.090','7.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGKR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGKR','TFGKR75-87% ');
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 ('TFGRR-ZABI-13-0','00041214','TFGRR75-84% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','9828000','2026-01-29','9828000','3.900','84.00','75','0','3000000.00','1','0.14', 'input','2026-01-29 16:03:36','3.900','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZABI-13-0','00041214');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-29','TFGRR-ZABI-13-0','TFGRR','TOKO','GLRTF','84.00','3.900','3.900','1','3.900','3.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-84% ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-29 ','16:54:25');