INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','08:59:16');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-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='2025-12-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2026-01-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-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-01-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','08:59:39');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-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-01-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-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-01-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','08:59:56');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-02';
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-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-02';
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-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-02' 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-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','09:00:13');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-03';
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-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-03' 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-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','09:00:31');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-04';
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-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-04';
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-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-04' 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-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','09:01:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','09:38:41');
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2396500',harga_beli ='2396500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4854500',harga_beli ='4854500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='189000',harga_beli ='189000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2746500',harga_beli ='2746500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6080500',harga_beli ='6080500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2278000',harga_beli ='2278000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2179000',harga_beli ='2179000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5288000',harga_beli ='5288000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='19528000',harga_beli ='19528000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2692500',harga_beli ='2692500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2544000',harga_beli ='2544000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2643000',harga_beli ='2643000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2618500',harga_beli ='2618500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7349000',harga_beli ='7349000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2814000',harga_beli ='2814000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10080000',harga_beli ='10080000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3636000',harga_beli ='3636000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4274000',harga_beli ='4274000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4390000',harga_beli ='4390000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5164000',harga_beli ='5164000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4177500',harga_beli ='4177500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7136500',harga_beli ='7136500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8606000',harga_beli ='8606000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6962500',harga_beli ='6962500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1450500',harga_beli ='1450500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2688500',harga_beli ='2688500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4100000',harga_beli ='4100000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3713500',harga_beli ='3713500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2127500',harga_beli ='2127500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2050000',harga_beli ='2050000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6285500',harga_beli ='6285500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7542500',harga_beli ='7542500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3365500',harga_beli ='3365500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6672000',harga_beli ='6672000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2572500',harga_beli ='2572500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4970500',harga_beli ='4970500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3481500',harga_beli ='3481500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5160000',harga_beli ='5160000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6653000',harga_beli ='6653000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10076000',harga_beli ='10076000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9089500',harga_beli ='9089500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3326500',harga_beli ='3326500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5183000',harga_beli ='5183000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7233000',harga_beli ='7233000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6595000',harga_beli ='6595000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6788500',harga_beli ='6788500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7794000',harga_beli ='7794000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='15549000',harga_beli ='15549000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1586000',harga_beli ='1586000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1586000',harga_beli ='1586000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1508500',harga_beli ='1508500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='1450500',harga_beli ='1450500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4796500',harga_beli ='4796500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8238500',harga_beli ='8238500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9418500',harga_beli ='9418500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8006500',harga_beli ='8006500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7504000',harga_beli ='7504000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8219500',harga_beli ='8219500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7330000',harga_beli ='7330000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4371000',harga_beli ='4371000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='52467000',harga_beli ='52467000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='8161500',harga_beli ='8161500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7542500',harga_beli ='7542500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5589000',harga_beli ='5589000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='10733500',harga_beli ='10733500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12456000',harga_beli ='12456000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='7155500',harga_beli ='7155500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5782500',harga_beli ='5782500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6343500',harga_beli ='6343500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4970500',harga_beli ='4970500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2330000','input','2026-01-05 09:46:50');
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='16339500',harga_beli ='16339500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='9586000',harga_beli ='9586000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5050500',harga_beli ='5050500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5090000',harga_beli ='5090000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='5907000',harga_beli ='5907000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='4483500',harga_beli ='4483500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='11135500',harga_beli ='11135500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3418000',harga_beli ='3418000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='12815000',harga_beli ='12815000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='6092000',harga_beli ='6092000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2330000','input','2026-01-05 09:46:55');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2330000','input','2026-01-05 09:46:59');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2330000','input','2026-01-05 09:47:02');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2330000','input','2026-01-05 09:47:05');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2330000','input','2026-01-05 09:47:08');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2330000','input','2026-01-05 09:47:11');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2330000','input','2026-01-05 09:47:14');
UPDATE tm_barang SET harga_skrg ='2330000',harga_jual='3520000',harga_beli ='3520000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2330000','input','2026-01-05 09:47:20');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2330000','input','2026-01-05 09:47:23');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2330000','input','2026-01-05 09:47:28');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2330000','input','2026-01-05 09:47:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-05 ','11:03:32');
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2419500',harga_beli ='2419500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4900000',harga_beli ='4900000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='191000',harga_beli ='191000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2772500',harga_beli ='2772500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6138000',harga_beli ='6138000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2299500',harga_beli ='2299500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2199500',harga_beli ='2199500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2239500',harga_beli ='2239500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5338000',harga_beli ='5338000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='19712500',harga_beli ='19712500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2742500',harga_beli ='2742500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2718000',harga_beli ='2718000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2568000',harga_beli ='2568000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2668000',harga_beli ='2668000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2643000',harga_beli ='2643000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7418500',harga_beli ='7418500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2840500',harga_beli ='2840500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='10175000',harga_beli ='10175000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3670500',harga_beli ='3670500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4314500',harga_beli ='4314500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4431500',harga_beli ='4431500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5212500',harga_beli ='5212500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4217000',harga_beli ='4217000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6032500',harga_beli ='6032500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7203500',harga_beli ='7203500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='8687500',harga_beli ='8687500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7028000',harga_beli ='7028000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='1464500',harga_beli ='1464500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2714000',harga_beli ='2714000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4139000',harga_beli ='4139000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3748500',harga_beli ='3748500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2147500',harga_beli ='2147500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2069500',harga_beli ='2069500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6345000',harga_beli ='6345000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7613500',harga_beli ='7613500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3397000',harga_beli ='3397000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6735000',harga_beli ='6735000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2596500',harga_beli ='2596500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='2206000',harga_beli ='2206000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5017500',harga_beli ='5017500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3514000',harga_beli ='3514000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5209000',harga_beli ='5209000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6715500',harga_beli ='6715500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='10171000',harga_beli ='10171000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='9175500',harga_beli ='9175500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3358000',harga_beli ='3358000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5232000',harga_beli ='5232000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7301500',harga_beli ='7301500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6657000',harga_beli ='6657000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6852500',harga_beli ='6852500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7867500',harga_beli ='7867500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='15695500',harga_beli ='15695500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='1601000',harga_beli ='1601000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='1601000',harga_beli ='1601000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='1523000',harga_beli ='1523000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='1464500',harga_beli ='1464500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4841500',harga_beli ='4841500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='8316500',harga_beli ='8316500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='9507500',harga_beli ='9507500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='8082000',harga_beli ='8082000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7574500',harga_beli ='7574500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='8297000',harga_beli ='8297000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7399000',harga_beli ='7399000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4412000',harga_beli ='4412000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='52962500',harga_beli ='52962500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='8238500',harga_beli ='8238500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7613500',harga_beli ='7613500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5642000',harga_beli ='5642000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='10835000',harga_beli ='10835000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='12573500',harga_beli ='12573500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='7223500',harga_beli ='7223500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5837000',harga_beli ='5837000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6403500',harga_beli ='6403500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5017500',harga_beli ='5017500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2352000','input','2026-01-05 14:22:42');
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='16493500',harga_beli ='16493500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='9676500',harga_beli ='9676500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5098000',harga_beli ='5098000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5138000',harga_beli ='5138000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='5962500',harga_beli ='5962500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='4526000',harga_beli ='4526000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='11240500',harga_beli ='11240500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3450000',harga_beli ='3450000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='12936000',harga_beli ='12936000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='6149500',harga_beli ='6149500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2352000','input','2026-01-05 14:22:50');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2352000','input','2026-01-05 14:22:54');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2352000','input','2026-01-05 14:22:59');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2352000','input','2026-01-05 14:23:03');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2352000','input','2026-01-05 14:23:06');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2352000','input','2026-01-05 14:23:10');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2352000','input','2026-01-05 14:23:14');
UPDATE tm_barang SET harga_skrg ='2352000',harga_jual='3553000',harga_beli ='3553000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2352000','input','2026-01-05 14:23:18');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2352000','input','2026-01-05 14:23:22');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2352000','input','2026-01-05 14:23:28');
UPDATE tm_group SET harga='2352000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2352000','input','2026-01-05 14:23:32');