INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','08:07:37');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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='2025-11-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-11-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','08:08:11');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-29';
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-11-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-29' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-11-30';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','08:08:34');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-30';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-12-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','08:09:11');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01400';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YLXA-1-0','00040069','DP-01400BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','2119500','2025-12-01','2119500','1.150','83.00','75','300000','2220000.00','1','0.14', 'input','2025-12-01 09:00:45','1.150','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01400BIP','1','RS 7','','DP-01400');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YLXA-1-0','00040069');
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 ('2025-12-01','PSGT-YLXA-1-0','PSGT','TOKO','PSNB','83.00','1.150','1.150','1','1.150','1.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01400BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01444';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-YLXA-2-0','00040070','DP-01444BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','286000','2025-12-01','286000','4.760','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-01 09:01:58','4.760','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01444BIP','1','RS 23','','DP-01444');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLXA-2-0','00040070');
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 ('2025-12-01','PSPRT-YLXA-2-0','PSPRT','TOKO','PSNB','100.00','4.760','4.760','1','4.760','4.760','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01444BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01446';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-YLXA-3-0','00040071','DP-01446BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','284000','2025-12-01','284000','4.730','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-01 09:03:27','4.730','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01446BIP','1','RS 24','','DP-01446');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLXA-3-0','00040071');
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 ('2025-12-01','PSPRT-YLXA-3-0','PSPRT','TOKO','PSNB','100.00','4.730','4.730','1','4.730','4.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01446BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01451';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-YLXA-4-0','00040072','DP-01451BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','158500','2025-12-01','158500','2.640','100.00','925','400000','60000.00','1','0.14', 'input','2025-12-01 09:05:06','2.640','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01451BIP','1','RS 8 RS 14 5','','DP-01451');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLXA-4-0','00040072');
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 ('2025-12-01','PSPRT-YLXA-4-0','PSPRT','TOKO','PSNB','100.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01451BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','09:33:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-01 ','09:39:43');
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4677500',harga_beli ='4677500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='182000',harga_beli ='182000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2646000',harga_beli ='2646000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5858500',harga_beli ='5858500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2195000',harga_beli ='2195000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2099500',harga_beli ='2099500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2137500',harga_beli ='2137500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5095500',harga_beli ='5095500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='18815500',harga_beli ='18815500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2618000',harga_beli ='2618000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2594000',harga_beli ='2594000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2546500',harga_beli ='2546500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2523000',harga_beli ='2523000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7081000',harga_beli ='7081000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2711000',harga_beli ='2711000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='9712000',harga_beli ='9712000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4118500',harga_beli ='4118500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4230000',harga_beli ='4230000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4975500',harga_beli ='4975500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4025000',harga_beli ='4025000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5758000',harga_beli ='5758000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6876000',harga_beli ='6876000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='8292000',harga_beli ='8292000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6708500',harga_beli ='6708500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1398000',harga_beli ='1398000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2590500',harga_beli ='2590500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3950500',harga_beli ='3950500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3578000',harga_beli ='3578000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2050000',harga_beli ='2050000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1975500',harga_beli ='1975500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6056000',harga_beli ='6056000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7267500',harga_beli ='7267500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3242500',harga_beli ='3242500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6429000',harga_beli ='6429000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5106000',harga_beli ='5106000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2478500',harga_beli ='2478500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2106000',harga_beli ='2106000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4789000',harga_beli ='4789000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3354500',harga_beli ='3354500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4972000',harga_beli ='4972000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6410000',harga_beli ='6410000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='9708500',harga_beli ='9708500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='8758000',harga_beli ='8758000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3205000',harga_beli ='3205000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4994000',harga_beli ='4994000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6969000',harga_beli ='6969000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6354500',harga_beli ='6354500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6540500',harga_beli ='6540500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7509500',harga_beli ='7509500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='14981500',harga_beli ='14981500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1528000',harga_beli ='1528000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1528000',harga_beli ='1528000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1453500',harga_beli ='1453500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='1398000',harga_beli ='1398000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4621500',harga_beli ='4621500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='9075000',harga_beli ='9075000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7714500',harga_beli ='7714500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7230000',harga_beli ='7230000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7919500',harga_beli ='7919500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7062500',harga_beli ='7062500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4211500',harga_beli ='4211500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='50553000',harga_beli ='50553000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7863500',harga_beli ='7863500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='7267500',harga_beli ='7267500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5385500',harga_beli ='5385500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='10342000',harga_beli ='10342000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='12001500',harga_beli ='12001500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6894500',harga_beli ='6894500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5571500',harga_beli ='5571500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='6112000',harga_beli ='6112000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4789000',harga_beli ='4789000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2245000','input','2025-12-01 11:19:31');
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='15743500',harga_beli ='15743500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='9236000',harga_beli ='9236000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4866500',harga_beli ='4866500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4904500',harga_beli ='4904500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5691500',harga_beli ='5691500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='10729000',harga_beli ='10729000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3293000',harga_beli ='3293000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='12347500',harga_beli ='12347500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='5870000',harga_beli ='5870000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2245000','input','2025-12-01 11:19:37');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2245000','input','2025-12-01 11:19:41');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2245000','input','2025-12-01 11:19:44');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2245000','input','2025-12-01 11:19:48');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2245000','input','2025-12-01 11:19:52');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2245000','input','2025-12-01 11:19:55');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2245000','input','2025-12-01 11:19:59');
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='3391500',harga_beli ='3391500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2245000',harga_jual='2143000',harga_beli ='2143000' WHERE kode_barcode='00040069' LIMIT 1;
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2245000','input','2025-12-01 11:20:03');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2245000','input','2025-12-01 11:20:07');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2245000','input','2025-12-01 11:20:13');
UPDATE tm_group SET harga='2245000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2245000','input','2025-12-01 11:20:17');
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2319500',harga_beli ='2319500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4698000',harga_beli ='4698000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='183000',harga_beli ='183000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2658000',harga_beli ='2658000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5884500',harga_beli ='5884500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2204500',harga_beli ='2204500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2108500',harga_beli ='2108500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2147000',harga_beli ='2147000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5118000',harga_beli ='5118000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='18899500',harga_beli ='18899500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2629500',harga_beli ='2629500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2605500',harga_beli ='2605500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2462500',harga_beli ='2462500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2558000',harga_beli ='2558000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2534000',harga_beli ='2534000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7112500',harga_beli ='7112500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2723000',harga_beli ='2723000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='9755500',harga_beli ='9755500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3519000',harga_beli ='3519000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4136500',harga_beli ='4136500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4249000',harga_beli ='4249000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4997500',harga_beli ='4997500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4043000',harga_beli ='4043000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5783500',harga_beli ='5783500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6906500',harga_beli ='6906500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='8329000',harga_beli ='8329000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6738000',harga_beli ='6738000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1404000',harga_beli ='1404000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2602000',harga_beli ='2602000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3968000',harga_beli ='3968000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3594000',harga_beli ='3594000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1984000',harga_beli ='1984000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6083000',harga_beli ='6083000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7299500',harga_beli ='7299500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3257000',harga_beli ='3257000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6457500',harga_beli ='6457500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5128500',harga_beli ='5128500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2489500',harga_beli ='2489500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2115000',harga_beli ='2115000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4810500',harga_beli ='4810500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3369000',harga_beli ='3369000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4994000',harga_beli ='4994000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6439000',harga_beli ='6439000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='9751500',harga_beli ='9751500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='8797000',harga_beli ='8797000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3219500',harga_beli ='3219500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5016500',harga_beli ='5016500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7000000',harga_beli ='7000000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6382500',harga_beli ='6382500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6570000',harga_beli ='6570000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7543000',harga_beli ='7543000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='15048500',harga_beli ='15048500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1460000',harga_beli ='1460000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='1404000',harga_beli ='1404000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4642000',harga_beli ='4642000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7973500',harga_beli ='7973500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='9115000',harga_beli ='9115000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7749000',harga_beli ='7749000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7262500',harga_beli ='7262500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7955000',harga_beli ='7955000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7094000',harga_beli ='7094000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4230000',harga_beli ='4230000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='50778000',harga_beli ='50778000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7898500',harga_beli ='7898500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='7299500',harga_beli ='7299500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5409500',harga_beli ='5409500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='10388000',harga_beli ='10388000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='12055000',harga_beli ='12055000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6925500',harga_beli ='6925500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5596500',harga_beli ='5596500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='6139500',harga_beli ='6139500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4810500',harga_beli ='4810500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2255000','input','2025-12-01 13:56:59');
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='15813500',harga_beli ='15813500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='9277500',harga_beli ='9277500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4888000',harga_beli ='4888000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4926500',harga_beli ='4926500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5716500',harga_beli ='5716500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='4339000',harga_beli ='4339000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='10777000',harga_beli ='10777000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3308000',harga_beli ='3308000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='12402500',harga_beli ='12402500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='5896000',harga_beli ='5896000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2255000','input','2025-12-01 13:57:06');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2255000','input','2025-12-01 13:57:10');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2255000','input','2025-12-01 13:57:13');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2255000','input','2025-12-01 13:57:16');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2255000','input','2025-12-01 13:57:19');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2255000','input','2025-12-01 13:57:23');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2255000','input','2025-12-01 13:57:27');
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='3406500',harga_beli ='3406500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2255000',harga_jual='2152500',harga_beli ='2152500' WHERE kode_barcode='00040069' LIMIT 1;
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2255000','input','2025-12-01 13:57:31');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2255000','input','2025-12-01 13:57:35');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2255000','input','2025-12-01 13:57:39');
UPDATE tm_group SET harga='2255000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2255000','input','2025-12-01 13:57:43');