INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-06 ','12:02:45');
UPDATE tm_group SET harga='1070000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1070000','admin','2026-01-06 12:04:05');
UPDATE tm_group SET harga='1070000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1070000','admin','2026-01-06 12:04:40');
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1384000',harga_beli ='1384000' WHERE kode_barcode='00027086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1310000',harga_beli ='1310000' WHERE kode_barcode='00027087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1328500',harga_beli ='1328500' WHERE kode_barcode='00027088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2196000',harga_beli ='2196000' WHERE kode_barcode='00027089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2011500',harga_beli ='2011500' WHERE kode_barcode='00027090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2159000',harga_beli ='2159000' WHERE kode_barcode='00027091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='00027092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1956000',harga_beli ='1956000' WHERE kode_barcode='00027093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2731000',harga_beli ='2731000' WHERE kode_barcode='00027094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1993000',harga_beli ='1993000' WHERE kode_barcode='00027095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3339500',harga_beli ='3339500' WHERE kode_barcode='00027096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1993000',harga_beli ='1993000' WHERE kode_barcode='00027097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2694000',harga_beli ='2694000' WHERE kode_barcode='00027098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='00027099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1863500',harga_beli ='1863500' WHERE kode_barcode='00027100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2897000',harga_beli ='2897000' WHERE kode_barcode='00027101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1919000',harga_beli ='1919000' WHERE kode_barcode='00027102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3229000',harga_beli ='3229000' WHERE kode_barcode='00027103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3192000',harga_beli ='3192000' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2011500',harga_beli ='2011500' WHERE kode_barcode='00027105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1993000',harga_beli ='1993000' WHERE kode_barcode='00027106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2583000',harga_beli ='2583000' WHERE kode_barcode='00027107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2786000',harga_beli ='2786000' WHERE kode_barcode='00027108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2694000',harga_beli ='2694000' WHERE kode_barcode='00027109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2398500',harga_beli ='2398500' WHERE kode_barcode='00027110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3303000',harga_beli ='3303000' WHERE kode_barcode='00027111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00027112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1808500',harga_beli ='1808500' WHERE kode_barcode='00027113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1697500',harga_beli ='1697500' WHERE kode_barcode='00027114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3155000',harga_beli ='3155000' WHERE kode_barcode='00027115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4354500',harga_beli ='4354500' WHERE kode_barcode='00027116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3745500',harga_beli ='3745500' WHERE kode_barcode='00027117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1587000',harga_beli ='1587000' WHERE kode_barcode='00027118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2380500',harga_beli ='2380500' WHERE kode_barcode='00027119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2288000',harga_beli ='2288000' WHERE kode_barcode='00027120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2325000',harga_beli ='2325000' WHERE kode_barcode='00027121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2306500',harga_beli ='2306500' WHERE kode_barcode='00027122' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1697500',harga_beli ='1697500' WHERE kode_barcode='00027123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='00027124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2491000',harga_beli ='2491000' WHERE kode_barcode='00027125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2601500',harga_beli ='2601500' WHERE kode_barcode='00027126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1993000',harga_beli ='1993000' WHERE kode_barcode='00027127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2140500',harga_beli ='2140500' WHERE kode_barcode='00027128' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2804500',harga_beli ='2804500' WHERE kode_barcode='00027129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3118500',harga_beli ='3118500' WHERE kode_barcode='00027130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2767500',harga_beli ='2767500' WHERE kode_barcode='00027131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00027132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2232500',harga_beli ='2232500' WHERE kode_barcode='00027133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='00027134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2694000',harga_beli ='2694000' WHERE kode_barcode='00027135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='2251000',harga_beli ='2251000' WHERE kode_barcode='00027136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='1956000',harga_beli ='1956000' WHERE kode_barcode='00027137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4612500',harga_beli ='4612500' WHERE kode_barcode='00027138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4059000',harga_beli ='4059000' WHERE kode_barcode='00027139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4723500',harga_beli ='4723500' WHERE kode_barcode='00027140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5277000',harga_beli ='5277000' WHERE kode_barcode='00027141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4096000',harga_beli ='4096000' WHERE kode_barcode='00027142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4760500',harga_beli ='4760500' WHERE kode_barcode='00027143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4059000',harga_beli ='4059000' WHERE kode_barcode='00027144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='7048000',harga_beli ='7048000' WHERE kode_barcode='00027145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4262000',harga_beli ='4262000' WHERE kode_barcode='00027146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4981500',harga_beli ='4981500' WHERE kode_barcode='00027147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4557500',harga_beli ='4557500' WHERE kode_barcode='00027148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5369000',harga_beli ='5369000' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5221500',harga_beli ='5221500' WHERE kode_barcode='00027150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4262000',harga_beli ='4262000' WHERE kode_barcode='00027151' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4446500',harga_beli ='4446500' WHERE kode_barcode='00027152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4631000',harga_beli ='4631000' WHERE kode_barcode='00027153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4742000',harga_beli ='4742000' WHERE kode_barcode='00027154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4668000',harga_beli ='4668000' WHERE kode_barcode='00027155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='7897000',harga_beli ='7897000' WHERE kode_barcode='00027156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='6919000',harga_beli ='6919000' WHERE kode_barcode='00027157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='9797000',harga_beli ='9797000' WHERE kode_barcode='00027158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4336000',harga_beli ='4336000' WHERE kode_barcode='00027159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5037000',harga_beli ='5037000' WHERE kode_barcode='00027160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='8450500',harga_beli ='8450500' WHERE kode_barcode='00027161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5646000',harga_beli ='5646000' WHERE kode_barcode='00027162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4391500',harga_beli ='4391500' WHERE kode_barcode='00027163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5498500',harga_beli ='5498500' WHERE kode_barcode='00027164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='3026000',harga_beli ='3026000' WHERE kode_barcode='00027165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4428000',harga_beli ='4428000' WHERE kode_barcode='00027166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4391500',harga_beli ='4391500' WHERE kode_barcode='00027167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='4373000',harga_beli ='4373000' WHERE kode_barcode='00027168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5129500',harga_beli ='5129500' WHERE kode_barcode='00027169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5258500',harga_beli ='5258500' WHERE kode_barcode='00027171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='5812000',harga_beli ='5812000' WHERE kode_barcode='00027172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='7841500',harga_beli ='7841500' WHERE kode_barcode='00027173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='9040500',harga_beli ='9040500' WHERE kode_barcode='00027174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='8266000',harga_beli ='8266000' WHERE kode_barcode='00027175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='8985500',harga_beli ='8985500' WHERE kode_barcode='00027176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='9225000',harga_beli ='9225000' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='9373000',harga_beli ='9373000' WHERE kode_barcode='00027178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='9778500',harga_beli ='9778500' WHERE kode_barcode='00027179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='11310000',harga_beli ='11310000' WHERE kode_barcode='00027180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='11919000',harga_beli ='11919000' WHERE kode_barcode='00027181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='13837500',harga_beli ='13837500' WHERE kode_barcode='00027182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='11291500',harga_beli ='11291500' WHERE kode_barcode='00027183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='11623500',harga_beli ='11623500' WHERE kode_barcode='00027184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='11845000',harga_beli ='11845000' WHERE kode_barcode='00027185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='10184500',harga_beli ='10184500' WHERE kode_barcode='00027186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='12878500',harga_beli ='12878500' WHERE kode_barcode='00027187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1845000',harga_jual='14705000',harga_beli ='14705000' WHERE kode_barcode='00027188' LIMIT 1;
UPDATE tm_group SET harga='1845000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1845000','admin','2026-01-06 12:04:54');