UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0001785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='10055500',harga_beli ='10055500' WHERE kode_barcode='T0003259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='13435500',harga_beli ='13435500' WHERE kode_barcode='T0003262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3126500',harga_beli ='3126500' WHERE kode_barcode='T0003283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0003285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8365500',harga_beli ='8365500' WHERE kode_barcode='T0003292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8416500',harga_beli ='8416500' WHERE kode_barcode='T0003293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='10174000',harga_beli ='10174000' WHERE kode_barcode='T0003304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003330' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0003644' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0003671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0003679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0003819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8281500',harga_beli ='8281500' WHERE kode_barcode='T0003820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6337500',harga_beli ='6337500' WHERE kode_barcode='T0003829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3498500',harga_beli ='3498500' WHERE kode_barcode='T0003841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='5087000',harga_beli ='5087000' WHERE kode_barcode='T0003842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3346500',harga_beli ='3346500' WHERE kode_barcode='T0003846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2484500',harga_beli ='2484500' WHERE kode_barcode='T0003847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2467500',harga_beli ='2467500' WHERE kode_barcode='T0003851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0005008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0005809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='T0012592' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0012656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='11695000',harga_beli ='11695000' WHERE kode_barcode='T0014670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8365500',harga_beli ='8365500' WHERE kode_barcode='T0022027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0016549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0016550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0016552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0032890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0034703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0036020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3346500',harga_beli ='3346500' WHERE kode_barcode='T0036741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='T0036748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6675500',harga_beli ='6675500' WHERE kode_barcode='T0038725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='4985500',harga_beli ='4985500' WHERE kode_barcode='T0038726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2501500',harga_beli ='2501500' WHERE kode_barcode='T0038727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0041545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0041548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8416500',harga_beli ='8416500' WHERE kode_barcode='T0041584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8484000',harga_beli ='8484000' WHERE kode_barcode='T0041591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0041593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='13520000',harga_beli ='13520000' WHERE kode_barcode='T0041600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8399500',harga_beli ='8399500' WHERE kode_barcode='T0041601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='11830000',harga_beli ='11830000' WHERE kode_barcode='T0041604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='10140000',harga_beli ='10140000' WHERE kode_barcode='T0041605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='16900000',harga_beli ='16900000' WHERE kode_barcode='T0041606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='8450000',harga_beli ='8450000' WHERE kode_barcode='T0042437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6760000',harga_beli ='6760000' WHERE kode_barcode='T0042438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0042439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='16900000',harga_beli ='16900000' WHERE kode_barcode='T0044138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='5070000',harga_beli ='5070000' WHERE kode_barcode='T0044139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='T0044142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='5070000',harga_beli ='5070000' WHERE kode_barcode='T0044147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='10140000',harga_beli ='10140000' WHERE kode_barcode='T0044148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='T0048326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1707000',harga_beli ='1707000' WHERE kode_barcode='T0048337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0050781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0052726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3346500',harga_beli ='3346500' WHERE kode_barcode='T0052735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1639500',harga_beli ='1639500' WHERE kode_barcode='T0052741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0056326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0056328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0056329' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0056331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0056336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='5070000',harga_beli ='5070000' WHERE kode_barcode='T0056344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1656500',harga_beli ='1656500' WHERE kode_barcode='T0056663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='T0056667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0056668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2569000',harga_beli ='2569000' WHERE kode_barcode='T0056670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3329500',harga_beli ='3329500' WHERE kode_barcode='T0056671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='5070000',harga_beli ='5070000' WHERE kode_barcode='T0056676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6760000',harga_beli ='6760000' WHERE kode_barcode='T0056680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3346500',harga_beli ='3346500' WHERE kode_barcode='T0056681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0056799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0059353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6726500',harga_beli ='6726500' WHERE kode_barcode='T0059362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0068704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0068706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0068708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0068709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0069572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0071250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='710000',harga_beli ='710000' WHERE kode_barcode='T0074494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0074495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0074497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0074499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0074505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='811500',harga_beli ='811500' WHERE kode_barcode='T0074507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='1690000',harga_beli ='1690000' WHERE kode_barcode='T0074510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='930000',harga_beli ='930000' WHERE kode_barcode='T0074512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='879000',harga_beli ='879000' WHERE kode_barcode='T0074513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='T0074516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='845000',harga_beli ='845000' WHERE kode_barcode='T0074517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3295500',harga_beli ='3295500' WHERE kode_barcode='T0074528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0074529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='T0074531' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='T0074532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1690000',harga_jual='6760000',harga_beli ='6760000' WHERE kode_barcode='T0074533' LIMIT 1;
UPDATE tm_group SET harga='1690000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1690000','admin','2025-11-05 08:09:17');
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2124000',harga_beli ='2124000' WHERE kode_barcode='T0072890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2159500',harga_beli ='2159500' WHERE kode_barcode='T0072921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0072899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3575500',harga_beli ='3575500' WHERE kode_barcode='T0072903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3575500',harga_beli ='3575500' WHERE kode_barcode='T0072915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2407500',harga_beli ='2407500' WHERE kode_barcode='T0072901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1699500',harga_beli ='1699500' WHERE kode_barcode='T0072885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1717000',harga_beli ='1717000' WHERE kode_barcode='T0072884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0072882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='T0072898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2266000',harga_beli ='2266000' WHERE kode_barcode='T0072879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2513500',harga_beli ='2513500' WHERE kode_barcode='T0072912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='T0072910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1646500',harga_beli ='1646500' WHERE kode_barcode='T0072914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2036000',harga_beli ='2036000' WHERE kode_barcode='T0072908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1858500',harga_beli ='1858500' WHERE kode_barcode='T0072900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='5044500',harga_beli ='5044500' WHERE kode_barcode='T0072920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0072911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2319000',harga_beli ='2319000' WHERE kode_barcode='T0072878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='T0072881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1717000',harga_beli ='1717000' WHERE kode_barcode='T0062338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='T0072889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='T0062887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2336500',harga_beli ='2336500' WHERE kode_barcode='T0062896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2708500',harga_beli ='2708500' WHERE kode_barcode='T0062918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2867500',harga_beli ='2867500' WHERE kode_barcode='T0062921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='5009500',harga_beli ='5009500' WHERE kode_barcode='T0062929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3168500',harga_beli ='3168500' WHERE kode_barcode='T0064209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0065725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2266000',harga_beli ='2266000' WHERE kode_barcode='T0072909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3363000',harga_beli ='3363000' WHERE kode_barcode='T0065137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0065389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1894000',harga_beli ='1894000' WHERE kode_barcode='T0065405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3894500',harga_beli ='3894500' WHERE kode_barcode='T0065414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3274500',harga_beli ='3274500' WHERE kode_barcode='T0065420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4301500',harga_beli ='4301500' WHERE kode_barcode='T0065421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3558000',harga_beli ='3558000' WHERE kode_barcode='T0065975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3451500',harga_beli ='3451500' WHERE kode_barcode='T0066754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2531500',harga_beli ='2531500' WHERE kode_barcode='T0067225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0067226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4036000',harga_beli ='4036000' WHERE kode_barcode='T0067241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3505000',harga_beli ='3505000' WHERE kode_barcode='T0067243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1823500',harga_beli ='1823500' WHERE kode_barcode='T0068133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1735000',harga_beli ='1735000' WHERE kode_barcode='T0068137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0068451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='T0068855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2124000',harga_beli ='2124000' WHERE kode_barcode='T0068868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4602000',harga_beli ='4602000' WHERE kode_barcode='T0068870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2195000',harga_beli ='2195000' WHERE kode_barcode='T0068876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1646500',harga_beli ='1646500' WHERE kode_barcode='T0068883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1451500',harga_beli ='1451500' WHERE kode_barcode='T0068884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2018000',harga_beli ='2018000' WHERE kode_barcode='T0072930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3186000',harga_beli ='3186000' WHERE kode_barcode='T0069495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3097500',harga_beli ='3097500' WHERE kode_barcode='T0069497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='T0072880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2036000',harga_beli ='2036000' WHERE kode_barcode='T0069895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2566500',harga_beli ='2566500' WHERE kode_barcode='T0069921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2496000',harga_beli ='2496000' WHERE kode_barcode='T0070148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0070410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2655000',harga_beli ='2655000' WHERE kode_barcode='T0070411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3593500',harga_beli ='3593500' WHERE kode_barcode='T0070412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='T0070425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2248000',harga_beli ='2248000' WHERE kode_barcode='T0070428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1823500',harga_beli ='1823500' WHERE kode_barcode='T0070436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2708500',harga_beli ='2708500' WHERE kode_barcode='T0070439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1947500',harga_beli ='1947500' WHERE kode_barcode='T0070442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2974000',harga_beli ='2974000' WHERE kode_barcode='T0070449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2443000',harga_beli ='2443000' WHERE kode_barcode='T0070454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2425000',harga_beli ='2425000' WHERE kode_barcode='T0070455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4248000',harga_beli ='4248000' WHERE kode_barcode='T0070459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4425000',harga_beli ='4425000' WHERE kode_barcode='T0070460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2319000',harga_beli ='2319000' WHERE kode_barcode='T0072917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3487000',harga_beli ='3487000' WHERE kode_barcode='T0070757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1929500',harga_beli ='1929500' WHERE kode_barcode='T0071212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0071227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2974000',harga_beli ='2974000' WHERE kode_barcode='T0071229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3629000',harga_beli ='3629000' WHERE kode_barcode='T0071502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1717000',harga_beli ='1717000' WHERE kode_barcode='T0071511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3505000',harga_beli ='3505000' WHERE kode_barcode='T0071667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3398500',harga_beli ='3398500' WHERE kode_barcode='T0072094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3363000',harga_beli ='3363000' WHERE kode_barcode='T0072931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2053500',harga_beli ='2053500' WHERE kode_barcode='T0072309' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2319000',harga_beli ='2319000' WHERE kode_barcode='T0072317' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='T0072319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2301000',harga_beli ='2301000' WHERE kode_barcode='T0072928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2478000',harga_beli ='2478000' WHERE kode_barcode='T0072926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1788000',harga_beli ='1788000' WHERE kode_barcode='T0072586' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0072589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1858500',harga_beli ='1858500' WHERE kode_barcode='T0072590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='T0072592' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1717000',harga_beli ='1717000' WHERE kode_barcode='T0072596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1593000',harga_beli ='1593000' WHERE kode_barcode='T0072598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='T0072599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='T0072601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3752500',harga_beli ='3752500' WHERE kode_barcode='T0072616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0072617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='4213000',harga_beli ='4213000' WHERE kode_barcode='T0072618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3805500',harga_beli ='3805500' WHERE kode_barcode='T0072619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3699500',harga_beli ='3699500' WHERE kode_barcode='T0072621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1345500',harga_beli ='1345500' WHERE kode_barcode='T0072955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2407500',harga_beli ='2407500' WHERE kode_barcode='T0072956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3027000',harga_beli ='3027000' WHERE kode_barcode='T0072958' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3363000',harga_beli ='3363000' WHERE kode_barcode='T0072960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2212500',harga_beli ='2212500' WHERE kode_barcode='T0072961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2602000',harga_beli ='2602000' WHERE kode_barcode='T0072999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2743500',harga_beli ='2743500' WHERE kode_barcode='T0073001' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2620000',harga_beli ='2620000' WHERE kode_barcode='T0073002' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2655000',harga_beli ='2655000' WHERE kode_barcode='T0073003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3115500',harga_beli ='3115500' WHERE kode_barcode='T0073680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3947500',harga_beli ='3947500' WHERE kode_barcode='T0073683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3451500',harga_beli ='3451500' WHERE kode_barcode='T0073685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3593500',harga_beli ='3593500' WHERE kode_barcode='T0073686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3664000',harga_beli ='3664000' WHERE kode_barcode='T0073687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0073688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2620000',harga_beli ='2620000' WHERE kode_barcode='T0073691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1823500',harga_beli ='1823500' WHERE kode_barcode='T0073692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2974000',harga_beli ='2974000' WHERE kode_barcode='T0073722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2655000',harga_beli ='2655000' WHERE kode_barcode='T0073724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='T0073726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3487000',harga_beli ='3487000' WHERE kode_barcode='T0073727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3540000',harga_beli ='3540000' WHERE kode_barcode='T0073728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='3629000',harga_beli ='3629000' WHERE kode_barcode='T0073729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2690500',harga_beli ='2690500' WHERE kode_barcode='T0073743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='2354500',harga_beli ='2354500' WHERE kode_barcode='T0073745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1982500',harga_beli ='1982500' WHERE kode_barcode='T0073746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1770000',harga_beli ='1770000' WHERE kode_barcode='T0073747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='1788000',harga_beli ='1788000' WHERE kode_barcode='T0073767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1770000',harga_jual='7027000',harga_beli ='7027000' WHERE kode_barcode='T0074527' LIMIT 1;
UPDATE tm_group SET harga='1770000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','1770000','admin','2025-11-05 08:09:38');
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0072906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2148000',harga_beli ='2148000' WHERE kode_barcode='T0001219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='35889500',harga_beli ='35889500' WHERE kode_barcode='T0001397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='895000',harga_beli ='895000' WHERE kode_barcode='T0002357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3526500',harga_beli ='3526500' WHERE kode_barcode='T0002587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2005000',harga_beli ='2005000' WHERE kode_barcode='T0003166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1700500',harga_beli ='1700500' WHERE kode_barcode='T0008353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='T0008357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1432000',harga_beli ='1432000' WHERE kode_barcode='T0008364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='T0012058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1897500',harga_beli ='1897500' WHERE kode_barcode='T0015578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1289000',harga_beli ='1289000' WHERE kode_barcode='T0022513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='T0040036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1271000',harga_beli ='1271000' WHERE kode_barcode='T0027957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2649500',harga_beli ='2649500' WHERE kode_barcode='T0029841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3186500',harga_beli ='3186500' WHERE kode_barcode='T0029930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='985000',harga_beli ='985000' WHERE kode_barcode='T0072896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='949000',harga_beli ='949000' WHERE kode_barcode='T0072895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2202000',harga_beli ='2202000' WHERE kode_barcode='T0033942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5370000',harga_beli ='5370000' WHERE kode_barcode='T0034286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1915500',harga_beli ='1915500' WHERE kode_barcode='T0034478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='T0034479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1110000',harga_beli ='1110000' WHERE kode_barcode='T0034489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1163500',harga_beli ='1163500' WHERE kode_barcode='T0034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1128000',harga_beli ='1128000' WHERE kode_barcode='T0034492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2005000',harga_beli ='2005000' WHERE kode_barcode='T0034677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0037257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3598000',harga_beli ='3598000' WHERE kode_barcode='T0037466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1969500',harga_beli ='1969500' WHERE kode_barcode='T0037655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3007500',harga_beli ='3007500' WHERE kode_barcode='T0037708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='T0037956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1987000',harga_beli ='1987000' WHERE kode_barcode='T0038057' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2416500',harga_beli ='2416500' WHERE kode_barcode='T0038063' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3455000',harga_beli ='3455000' WHERE kode_barcode='T0038064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='949000',harga_beli ='949000' WHERE kode_barcode='T0038099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5782000',harga_beli ='5782000' WHERE kode_barcode='T0038107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1110000',harga_beli ='1110000' WHERE kode_barcode='T0040367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4761500',harga_beli ='4761500' WHERE kode_barcode='T0040586' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3043000',harga_beli ='3043000' WHERE kode_barcode='T0040718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3490500',harga_beli ='3490500' WHERE kode_barcode='T0040939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11545500',harga_beli ='11545500' WHERE kode_barcode='T0041108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2023000',harga_beli ='2023000' WHERE kode_barcode='T0041488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='18079000',harga_beli ='18079000' WHERE kode_barcode='T0041524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3598000',harga_beli ='3598000' WHERE kode_barcode='T0045140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1271000',harga_beli ='1271000' WHERE kode_barcode='T0041808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1396500',harga_beli ='1396500' WHERE kode_barcode='T0041884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2953500',harga_beli ='2953500' WHERE kode_barcode='T0041908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='841500',harga_beli ='841500' WHERE kode_barcode='T0042082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2631500',harga_beli ='2631500' WHERE kode_barcode='T0042134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3508500',harga_beli ='3508500' WHERE kode_barcode='T0042141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8467000',harga_beli ='8467000' WHERE kode_barcode='T0042168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1736500',harga_beli ='1736500' WHERE kode_barcode='T0042245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4940500',harga_beli ='4940500' WHERE kode_barcode='T0042293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2345000',harga_beli ='2345000' WHERE kode_barcode='T0042489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1987000',harga_beli ='1987000' WHERE kode_barcode='T0042493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4206500',harga_beli ='4206500' WHERE kode_barcode='T0042862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='27154500',harga_beli ='27154500' WHERE kode_barcode='T0043069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3097000',harga_beli ='3097000' WHERE kode_barcode='T0043167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='T0043444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='T0043446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1718500',harga_beli ='1718500' WHERE kode_barcode='T0043447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1700500',harga_beli ='1700500' WHERE kode_barcode='T0043448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12655500',harga_beli ='12655500' WHERE kode_barcode='T0043497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17989500',harga_beli ='17989500' WHERE kode_barcode='T0043498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0043529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='T0043536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1163500',harga_beli ='1163500' WHERE kode_barcode='T0043539' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='T0044004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1396500',harga_beli ='1396500' WHERE kode_barcode='T0044008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2703000',harga_beli ='2703000' WHERE kode_barcode='T0044243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2524000',harga_beli ='2524000' WHERE kode_barcode='T0044320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0045061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9541000',harga_beli ='9541000' WHERE kode_barcode='T0045313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2327000',harga_beli ='2327000' WHERE kode_barcode='T0045361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2739000',harga_beli ='2739000' WHERE kode_barcode='T0045435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4708000',harga_beli ='4708000' WHERE kode_barcode='T0045441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16683000',harga_beli ='16683000' WHERE kode_barcode='T0045473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14230500',harga_beli ='14230500' WHERE kode_barcode='T0045476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0072875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3598000',harga_beli ='3598000' WHERE kode_barcode='T0046025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1199500',harga_beli ='1199500' WHERE kode_barcode='T0046034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1181500',harga_beli ='1181500' WHERE kode_barcode='T0046035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2327000',harga_beli ='2327000' WHERE kode_barcode='T0046582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2524000',harga_beli ='2524000' WHERE kode_barcode='T0046593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2005000',harga_beli ='2005000' WHERE kode_barcode='T0046601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0047029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1199500',harga_beli ='1199500' WHERE kode_barcode='T0047312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2005000',harga_beli ='2005000' WHERE kode_barcode='T0047737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1342500',harga_beli ='1342500' WHERE kode_barcode='T0047741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2971500',harga_beli ='2971500' WHERE kode_barcode='T0048156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1307000',harga_beli ='1307000' WHERE kode_barcode='T0048379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0048714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1700500',harga_beli ='1700500' WHERE kode_barcode='T0048716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1754500',harga_beli ='1754500' WHERE kode_barcode='T0048717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1754500',harga_beli ='1754500' WHERE kode_barcode='T0048720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1826000',harga_beli ='1826000' WHERE kode_barcode='T0048722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6175500',harga_beli ='6175500' WHERE kode_barcode='T0049043' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3580000',harga_beli ='3580000' WHERE kode_barcode='T0049361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3580000',harga_beli ='3580000' WHERE kode_barcode='T0049362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0049432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2828500',harga_beli ='2828500' WHERE kode_barcode='T0049588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='931000',harga_beli ='931000' WHERE kode_barcode='T0049591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10382000',harga_beli ='10382000' WHERE kode_barcode='T0050434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4224500',harga_beli ='4224500' WHERE kode_barcode='T0050859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3186500',harga_beli ='3186500' WHERE kode_barcode='T0050949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1665000',harga_beli ='1665000' WHERE kode_barcode='T0051654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2112500',harga_beli ='2112500' WHERE kode_barcode='T0051706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11993000',harga_beli ='11993000' WHERE kode_barcode='T0052837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3222000',harga_beli ='3222000' WHERE kode_barcode='T0052851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0052864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2595500',harga_beli ='2595500' WHERE kode_barcode='T0053132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0054076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1915500',harga_beli ='1915500' WHERE kode_barcode='T0054257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4296000',harga_beli ='4296000' WHERE kode_barcode='T0054718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3866500',harga_beli ='3866500' WHERE kode_barcode='T0054720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3938500',harga_beli ='3938500' WHERE kode_barcode='T0054721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4564500',harga_beli ='4564500' WHERE kode_barcode='T0054724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10615000',harga_beli ='10615000' WHERE kode_barcode='T0054727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1700500',harga_beli ='1700500' WHERE kode_barcode='T0054761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5280500',harga_beli ='5280500' WHERE kode_barcode='T0056238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15859500',harga_beli ='15859500' WHERE kode_barcode='T0056691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6999000',harga_beli ='6999000' WHERE kode_barcode='T0056761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='T0072874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2076500',harga_beli ='2076500' WHERE kode_barcode='T0057061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1128000',harga_beli ='1128000' WHERE kode_barcode='T0057062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8628000',harga_beli ='8628000' WHERE kode_barcode='T0057063' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='T0058703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2327000',harga_beli ='2327000' WHERE kode_barcode='T0058776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4045500',harga_beli ='4045500' WHERE kode_barcode='T0058837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2828500',harga_beli ='2828500' WHERE kode_barcode='T0059258' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1146000',harga_beli ='1146000' WHERE kode_barcode='T0059284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2542000',harga_beli ='2542000' WHERE kode_barcode='T0059292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3813000',harga_beli ='3813000' WHERE kode_barcode='T0059319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='985000',harga_beli ='985000' WHERE kode_barcode='T0059389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2631500',harga_beli ='2631500' WHERE kode_barcode='T0059407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2524000',harga_beli ='2524000' WHERE kode_barcode='T0059417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='T0059422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2595500',harga_beli ='2595500' WHERE kode_barcode='T0059436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2613500',harga_beli ='2613500' WHERE kode_barcode='T0059443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3687500',harga_beli ='3687500' WHERE kode_barcode='T0060238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1969500',harga_beli ='1969500' WHERE kode_barcode='T0060254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5388000',harga_beli ='5388000' WHERE kode_barcode='T0061866' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1342500',harga_beli ='1342500' WHERE kode_barcode='T0062310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1450000',harga_beli ='1450000' WHERE kode_barcode='T0062347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3490500',harga_beli ='3490500' WHERE kode_barcode='T0062552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3508500',harga_beli ='3508500' WHERE kode_barcode='T0062553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3544500',harga_beli ='3544500' WHERE kode_barcode='T0062554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1289000',harga_beli ='1289000' WHERE kode_barcode='T0062573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1360500',harga_beli ='1360500' WHERE kode_barcode='T0062574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2953500',harga_beli ='2953500' WHERE kode_barcode='T0065378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2739000',harga_beli ='2739000' WHERE kode_barcode='T0065489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1378500',harga_beli ='1378500' WHERE kode_barcode='T0067228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1199500',harga_beli ='1199500' WHERE kode_barcode='T0067229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14410000',harga_beli ='14410000' WHERE kode_barcode='T0067251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='18097000',harga_beli ='18097000' WHERE kode_barcode='T0067255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3992000',harga_beli ='3992000' WHERE kode_barcode='T0067256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='18401500',harga_beli ='18401500' WHERE kode_barcode='T0067259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3813000',harga_beli ='3813000' WHERE kode_barcode='T0068124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1844000',harga_beli ='1844000' WHERE kode_barcode='T0068689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1897500',harga_beli ='1897500' WHERE kode_barcode='T0068724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12494500',harga_beli ='12494500' WHERE kode_barcode='T0068897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4690000',harga_beli ='4690000' WHERE kode_barcode='T0068904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5084000',harga_beli ='5084000' WHERE kode_barcode='T0069474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3777000',harga_beli ='3777000' WHERE kode_barcode='T0069476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5191000',harga_beli ='5191000' WHERE kode_barcode='T0069479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5477500',harga_beli ='5477500' WHERE kode_barcode='T0069480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5155500',harga_beli ='5155500' WHERE kode_barcode='T0069502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1969500',harga_beli ='1969500' WHERE kode_barcode='T0069897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2023000',harga_beli ='2023000' WHERE kode_barcode='T0069898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3580000',harga_beli ='3580000' WHERE kode_barcode='T0069899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1539500',harga_beli ='1539500' WHERE kode_barcode='T0069919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4385500',harga_beli ='4385500' WHERE kode_barcode='T0069928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3634000',harga_beli ='3634000' WHERE kode_barcode='T0069930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5459500',harga_beli ='5459500' WHERE kode_barcode='T0069938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5567000',harga_beli ='5567000' WHERE kode_barcode='T0070139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7429000',harga_beli ='7429000' WHERE kode_barcode='T0070141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7285500',harga_beli ='7285500' WHERE kode_barcode='T0070142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9057500',harga_beli ='9057500' WHERE kode_barcode='T0070143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8986000',harga_beli ='8986000' WHERE kode_barcode='T0070146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1110000',harga_beli ='1110000' WHERE kode_barcode='T0070409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4421500',harga_beli ='4421500' WHERE kode_barcode='T0070463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5012000',harga_beli ='5012000' WHERE kode_barcode='T0070464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5459500',harga_beli ='5459500' WHERE kode_barcode='T0070480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3526500',harga_beli ='3526500' WHERE kode_barcode='T0070482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5817500',harga_beli ='5817500' WHERE kode_barcode='T0070483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5227000',harga_beli ='5227000' WHERE kode_barcode='T0070484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12584000',harga_beli ='12584000' WHERE kode_barcode='T0070536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3490500',harga_beli ='3490500' WHERE kode_barcode='T0070537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0070876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0070877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0070878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1790000',harga_beli ='1790000' WHERE kode_barcode='T0071214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0071215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0071216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='T0071217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7375000',harga_beli ='7375000' WHERE kode_barcode='T0071218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9183000',harga_beli ='9183000' WHERE kode_barcode='T0071219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0071225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0071226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4153000',harga_beli ='4153000' WHERE kode_barcode='T0072937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17989500',harga_beli ='17989500' WHERE kode_barcode='T0071496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1253000',harga_beli ='1253000' WHERE kode_barcode='T0071504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3795000',harga_beli ='3795000' WHERE kode_barcode='T0071512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12727000',harga_beli ='12727000' WHERE kode_barcode='T0071521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='T0071663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4743500',harga_beli ='4743500' WHERE kode_barcode='T0071664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5137500',harga_beli ='5137500' WHERE kode_barcode='T0071665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3132500',harga_beli ='3132500' WHERE kode_barcode='T0072936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0072313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3705500',harga_beli ='3705500' WHERE kode_barcode='T0072322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7536000',harga_beli ='7536000' WHERE kode_barcode='T0072941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0072584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4833000',harga_beli ='4833000' WHERE kode_barcode='T0072603' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6480000',harga_beli ='6480000' WHERE kode_barcode='T0072964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5459500',harga_beli ='5459500' WHERE kode_barcode='T0072965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1289000',harga_beli ='1289000' WHERE kode_barcode='T0072995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0073675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2595500',harga_beli ='2595500' WHERE kode_barcode='T0073676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1163500',harga_beli ='1163500' WHERE kode_barcode='T0073677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1092000',harga_beli ='1092000' WHERE kode_barcode='T0073679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0073681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1360500',harga_beli ='1360500' WHERE kode_barcode='T0073682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17757000',harga_beli ='17757000' WHERE kode_barcode='T0073694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='T0073696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3347500',harga_beli ='3347500' WHERE kode_barcode='T0073714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3526500',harga_beli ='3526500' WHERE kode_barcode='T0073717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1217500',harga_beli ='1217500' WHERE kode_barcode='T0073734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1199500',harga_beli ='1199500' WHERE kode_barcode='T0073735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='985000',harga_beli ='985000' WHERE kode_barcode='T0073737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0073738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1163500',harga_beli ='1163500' WHERE kode_barcode='T0073739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1074000',harga_beli ='1074000' WHERE kode_barcode='T0073744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2148000',harga_beli ='2148000' WHERE kode_barcode='T0073750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4600500',harga_beli ='4600500' WHERE kode_barcode='T0073751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4385500',harga_beli ='4385500' WHERE kode_barcode='T0073752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4708000',harga_beli ='4708000' WHERE kode_barcode='T0073753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4564500',harga_beli ='4564500' WHERE kode_barcode='T0073754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8055000',harga_beli ='8055000' WHERE kode_barcode='T0073766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2882000',harga_beli ='2882000' WHERE kode_barcode='T0073769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2900000',harga_beli ='2900000' WHERE kode_barcode='T0073770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2936000',harga_beli ='2936000' WHERE kode_barcode='T0073772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2989500',harga_beli ='2989500' WHERE kode_barcode='T0073773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2774500',harga_beli ='2774500' WHERE kode_barcode='T0073774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2506000',harga_beli ='2506000' WHERE kode_barcode='T0073777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2792500',harga_beli ='2792500' WHERE kode_barcode='T0073778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6014500',harga_beli ='6014500' WHERE kode_barcode='T0074018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='805500',harga_beli ='805500' WHERE kode_barcode='T0074022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='823500',harga_beli ='823500' WHERE kode_barcode='T0074023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8825000',harga_beli ='8825000' WHERE kode_barcode='T0074486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9218500',harga_beli ='9218500' WHERE kode_barcode='T0074485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1020500',harga_beli ='1020500' WHERE kode_barcode='T0074484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='T0074483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5424000',harga_beli ='5424000' WHERE kode_barcode='T0074487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5424000',harga_beli ='5424000' WHERE kode_barcode='T0074488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8860500',harga_beli ='8860500' WHERE kode_barcode='T0074489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1128000',harga_beli ='1128000' WHERE kode_barcode='T0074518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5442000',harga_beli ='5442000' WHERE kode_barcode='T0074534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3598000',harga_beli ='3598000' WHERE kode_barcode='T0074535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3634000',harga_beli ='3634000' WHERE kode_barcode='T0074536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2685000',harga_beli ='2685000' WHERE kode_barcode='T0074537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9039500',harga_beli ='9039500' WHERE kode_barcode='T0074538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12548000',harga_beli ='12548000' WHERE kode_barcode='T0074539' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2792500',harga_beli ='2792500' WHERE kode_barcode='T0074551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3276000',harga_beli ='3276000' WHERE kode_barcode='T0074554' LIMIT 1;
UPDATE tm_group SET harga='1790000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','1790000','admin','2025-11-05 08:09:52');
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1448000',harga_beli ='1448000' WHERE kode_barcode='T0000044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='26897000',harga_beli ='26897000' WHERE kode_barcode='T0001415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1412000',harga_beli ='1412000' WHERE kode_barcode='T0002468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1394000',harga_beli ='1394000' WHERE kode_barcode='T0002469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1900500',harga_beli ='1900500' WHERE kode_barcode='T0002494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5484500',harga_beli ='5484500' WHERE kode_barcode='T0006182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5303500',harga_beli ='5303500' WHERE kode_barcode='T0012557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2082000',harga_beli ='2082000' WHERE kode_barcode='T0012570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3711000',harga_beli ='3711000' WHERE kode_barcode='T0012620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3855500',harga_beli ='3855500' WHERE kode_barcode='T0013082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3620000',harga_beli ='3620000' WHERE kode_barcode='T0014678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='8996000',harga_beli ='8996000' WHERE kode_barcode='T0017016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7059000',harga_beli ='7059000' WHERE kode_barcode='T0023440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9140500',harga_beli ='9140500' WHERE kode_barcode='T0032805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1557000',harga_beli ='1557000' WHERE kode_barcode='T0032934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0032937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9140500',harga_beli ='9140500' WHERE kode_barcode='T0033573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5213000',harga_beli ='5213000' WHERE kode_barcode='T0033671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='27186500',harga_beli ='27186500' WHERE kode_barcode='T0034311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='45540000',harga_beli ='45540000' WHERE kode_barcode='T0034312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1647500',harga_beli ='1647500' WHERE kode_barcode='T0034698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3711000',harga_beli ='3711000' WHERE kode_barcode='T0034737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5358000',harga_beli ='5358000' WHERE kode_barcode='T0037228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3711000',harga_beli ='3711000' WHERE kode_barcode='T0037454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7475500',harga_beli ='7475500' WHERE kode_barcode='T0037627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3638500',harga_beli ='3638500' WHERE kode_barcode='T0037699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0037893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0037894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0037897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0038044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0038047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='12869500',harga_beli ='12869500' WHERE kode_barcode='T0038298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='14480000',harga_beli ='14480000' WHERE kode_barcode='T0038301' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1394000',harga_beli ='1394000' WHERE kode_barcode='T0039590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4072500',harga_beli ='4072500' WHERE kode_barcode='T0039612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='10715500',harga_beli ='10715500' WHERE kode_barcode='T0041140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1538500',harga_beli ='1538500' WHERE kode_barcode='T0041492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3620000',harga_beli ='3620000' WHERE kode_barcode='T0041557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1412000',harga_beli ='1412000' WHERE kode_barcode='T0041810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1557000',harga_beli ='1557000' WHERE kode_barcode='T0041814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1176500',harga_beli ='1176500' WHERE kode_barcode='T0041819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1376000',harga_beli ='1376000' WHERE kode_barcode='T0042026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7276500',harga_beli ='7276500' WHERE kode_barcode='T0042126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4724500',harga_beli ='4724500' WHERE kode_barcode='T0042504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='959500',harga_beli ='959500' WHERE kode_barcode='T0042808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='T0042838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0042916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0042917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0042918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0042919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='36327000',harga_beli ='36327000' WHERE kode_barcode='T0045326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2118000',harga_beli ='2118000' WHERE kode_barcode='T0045357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1176500',harga_beli ='1176500' WHERE kode_barcode='T0045758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='869000',harga_beli ='869000' WHERE kode_barcode='T0047314' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1122500',harga_beli ='1122500' WHERE kode_barcode='T0072905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1864500',harga_beli ='1864500' WHERE kode_barcode='T0072894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1176500',harga_beli ='1176500' WHERE kode_barcode='T0048376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1412000',harga_beli ='1412000' WHERE kode_barcode='T0049385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7349000',harga_beli ='7349000' WHERE kode_barcode='T0049654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1629000',harga_beli ='1629000' WHERE kode_barcode='T0049970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3403000',harga_beli ='3403000' WHERE kode_barcode='T0049980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5068000',harga_beli ='5068000' WHERE kode_barcode='T0050008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5611000',harga_beli ='5611000' WHERE kode_barcode='T0050444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1991500',harga_beli ='1991500' WHERE kode_barcode='T0050452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4434500',harga_beli ='4434500' WHERE kode_barcode='T0050809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5249000',harga_beli ='5249000' WHERE kode_barcode='T0050811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5158500',harga_beli ='5158500' WHERE kode_barcode='T0051681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='14534500',harga_beli ='14534500' WHERE kode_barcode='T0052702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5430000',harga_beli ='5430000' WHERE kode_barcode='T0054298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5339500',harga_beli ='5339500' WHERE kode_barcode='T0054299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1176500',harga_beli ='1176500' WHERE kode_barcode='T0054785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9231000',harga_beli ='9231000' WHERE kode_barcode='T0056148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4815000',harga_beli ='4815000' WHERE kode_barcode='T0056246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='T0056275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2624500',harga_beli ='2624500' WHERE kode_barcode='T0056740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1719500',harga_beli ='1719500' WHERE kode_barcode='T0056745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3620000',harga_beli ='3620000' WHERE kode_barcode='T0056774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2624500',harga_beli ='2624500' WHERE kode_barcode='T0056798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='T0057060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0072892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='17955500',harga_beli ='17955500' WHERE kode_barcode='T0057545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='21720000',harga_beli ='21720000' WHERE kode_barcode='T0057546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='10860000',harga_beli ='10860000' WHERE kode_barcode='T0059273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1629000',harga_beli ='1629000' WHERE kode_barcode='T0059357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1448000',harga_beli ='1448000' WHERE kode_barcode='T0059358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1086000',harga_beli ='1086000' WHERE kode_barcode='T0059393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5104500',harga_beli ='5104500' WHERE kode_barcode='T0059464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3765000',harga_beli ='3765000' WHERE kode_barcode='T0059466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='8996000',harga_beli ='8996000' WHERE kode_barcode='T0059474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0060831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='923500',harga_beli ='923500' WHERE kode_barcode='T0060833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5177000',harga_beli ='5177000' WHERE kode_barcode='T0062956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4796500',harga_beli ='4796500' WHERE kode_barcode='T0062957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0065375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2661000',harga_beli ='2661000' WHERE kode_barcode='T0065384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5249000',harga_beli ='5249000' WHERE kode_barcode='T0065438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='T0065947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2389500',harga_beli ='2389500' WHERE kode_barcode='T0066742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2389500',harga_beli ='2389500' WHERE kode_barcode='T0066743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='T0066746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2353000',harga_beli ='2353000' WHERE kode_barcode='T0066747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3674500',harga_beli ='3674500' WHERE kode_barcode='T0067233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='18064000',harga_beli ='18064000' WHERE kode_barcode='T0067260' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7330500',harga_beli ='7330500' WHERE kode_barcode='T0068455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1810000',harga_beli ='1810000' WHERE kode_barcode='T0068711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1719500',harga_beli ='1719500' WHERE kode_barcode='T0068717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='T0068718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2172000',harga_beli ='2172000' WHERE kode_barcode='T0068720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1919000',harga_beli ='1919000' WHERE kode_barcode='T0068722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3041000',harga_beli ='3041000' WHERE kode_barcode='T0068723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0068863' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4199500',harga_beli ='4199500' WHERE kode_barcode='T0068911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3258000',harga_beli ='3258000' WHERE kode_barcode='T0068913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0070417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0070419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0070461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4398500',harga_beli ='4398500' WHERE kode_barcode='T0070487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0070521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='941500',harga_beli ='941500' WHERE kode_barcode='T0070522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='T0070538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1810000',harga_beli ='1810000' WHERE kode_barcode='T0071222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1900500',harga_beli ='1900500' WHERE kode_barcode='T0071224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3837500',harga_beli ='3837500' WHERE kode_barcode='T0071513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9249500',harga_beli ='9249500' WHERE kode_barcode='T0071516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='10860000',harga_beli ='10860000' WHERE kode_barcode='T0071517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1267000',harga_beli ='1267000' WHERE kode_barcode='T0071669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='T0071670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1267000',harga_beli ='1267000' WHERE kode_barcode='T0071671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1122500',harga_beli ='1122500' WHERE kode_barcode='T0071673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='977500',harga_beli ='977500' WHERE kode_barcode='T0072097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='977500',harga_beli ='977500' WHERE kode_barcode='T0072098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='T0072947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='14498500',harga_beli ='14498500' WHERE kode_barcode='T0072626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='10896500',harga_beli ='10896500' WHERE kode_barcode='T0072627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5520500',harga_beli ='5520500' WHERE kode_barcode='T0072952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1394000',harga_beli ='1394000' WHERE kode_barcode='T0072957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4471000',harga_beli ='4471000' WHERE kode_barcode='T0072968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='760500',harga_beli ='760500' WHERE kode_barcode='T0073006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1629000',harga_beli ='1629000' WHERE kode_barcode='T0073008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='13249500',harga_beli ='13249500' WHERE kode_barcode='T0073695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='4815000',harga_beli ='4815000' WHERE kode_barcode='T0073699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3819500',harga_beli ='3819500' WHERE kode_barcode='T0073700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='18100000',harga_beli ='18100000' WHERE kode_barcode='T0073701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='8869000',harga_beli ='8869000' WHERE kode_barcode='T0073702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='7149500',harga_beli ='7149500' WHERE kode_barcode='T0073703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2570500',harga_beli ='2570500' WHERE kode_barcode='T0073705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='5086500',harga_beli ='5086500' WHERE kode_barcode='T0073720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1665500',harga_beli ='1665500' WHERE kode_barcode='T0073740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='T0073741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1267000',harga_beli ='1267000' WHERE kode_barcode='T0073742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9068500',harga_beli ='9068500' WHERE kode_barcode='T0073748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='T0073756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2552500',harga_beli ='2552500' WHERE kode_barcode='T0073757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2534000',harga_beli ='2534000' WHERE kode_barcode='T0073758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2570500',harga_beli ='2570500' WHERE kode_barcode='T0073779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='2588500',harga_beli ='2588500' WHERE kode_barcode='T0073780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='18245000',harga_beli ='18245000' WHERE kode_barcode='T0073781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='10733500',harga_beli ='10733500' WHERE kode_barcode='T0074019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1810000',harga_beli ='1810000' WHERE kode_barcode='T0074026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='905000',harga_beli ='905000' WHERE kode_barcode='T0074520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='T0074521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1357500',harga_beli ='1357500' WHERE kode_barcode='T0074522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1086000',harga_beli ='1086000' WHERE kode_barcode='T0074523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1267000',harga_beli ='1267000' WHERE kode_barcode='T0074524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='1448000',harga_beli ='1448000' WHERE kode_barcode='T0074525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='3548000',harga_beli ='3548000' WHERE kode_barcode='T0074540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1810000',harga_jual='9267500',harga_beli ='9267500' WHERE kode_barcode='00295403' LIMIT 1;
UPDATE tm_group SET harga='1810000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','1810000','admin','2025-11-05 08:10:10');
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2196000',harga_beli ='2196000' WHERE kode_barcode='T0001324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='T0001626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1372500',harga_beli ='1372500' WHERE kode_barcode='T0001631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1226500',harga_beli ='1226500' WHERE kode_barcode='T0001632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1208000',harga_beli ='1208000' WHERE kode_barcode='T0001633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1391000',harga_beli ='1391000' WHERE kode_barcode='T0001636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='12718500',harga_beli ='12718500' WHERE kode_barcode='T0002534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='18135500',harga_beli ='18135500' WHERE kode_barcode='T0002538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1116500',harga_beli ='1116500' WHERE kode_barcode='T0002646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5581500',harga_beli ='5581500' WHERE kode_barcode='T0002699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1208000',harga_beli ='1208000' WHERE kode_barcode='T0011816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1098000',harga_beli ='1098000' WHERE kode_barcode='T0016447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1738500',harga_beli ='1738500' WHERE kode_barcode='T0017824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='10980000',harga_beli ='10980000' WHERE kode_barcode='T0020109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1299500',harga_beli ='1299500' WHERE kode_barcode='T0024478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1684000',harga_beli ='1684000' WHERE kode_barcode='T0024921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1391000',harga_beli ='1391000' WHERE kode_barcode='T0024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1665500',harga_beli ='1665500' WHERE kode_barcode='T0025222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1135000',harga_beli ='1135000' WHERE kode_barcode='T0027088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1299500',harga_beli ='1299500' WHERE kode_barcode='T0031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1336000',harga_beli ='1336000' WHERE kode_barcode='T0031470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1135000',harga_beli ='1135000' WHERE kode_barcode='T0032927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7265500',harga_beli ='7265500' WHERE kode_barcode='T0033666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='9333000',harga_beli ='9333000' WHERE kode_barcode='T0037976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='9607500',harga_beli ='9607500' WHERE kode_barcode='T0037977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5636500',harga_beli ='5636500' WHERE kode_barcode='T0037980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='18300000',harga_beli ='18300000' WHERE kode_barcode='T0040119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='11950000',harga_beli ='11950000' WHERE kode_barcode='T0043054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3843000',harga_beli ='3843000' WHERE kode_barcode='T0044770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='769000',harga_beli ='769000' WHERE kode_barcode='T0045114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='T0048968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='915000',harga_beli ='915000' WHERE kode_barcode='T0048969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='915000',harga_beli ='915000' WHERE kode_barcode='T0048970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2251000',harga_beli ='2251000' WHERE kode_barcode='T0049859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1921500',harga_beli ='1921500' WHERE kode_barcode='T0049861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3331000',harga_beli ='3331000' WHERE kode_barcode='T0050814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2690500',harga_beli ='2690500' WHERE kode_barcode='T0050888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='27541500',harga_beli ='27541500' WHERE kode_barcode='T0051687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2708500',harga_beli ='2708500' WHERE kode_barcode='T0051842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='10486000',harga_beli ='10486000' WHERE kode_barcode='T0052955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1409500',harga_beli ='1409500' WHERE kode_barcode='T0053429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='732000',harga_beli ='732000' WHERE kode_barcode='T0053864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5655000',harga_beli ='5655000' WHERE kode_barcode='T0055807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1208000',harga_beli ='1208000' WHERE kode_barcode='T0056784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2653500',harga_beli ='2653500' WHERE kode_barcode='T0058739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='T0059327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1372500',harga_beli ='1372500' WHERE kode_barcode='T0059328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3861500',harga_beli ='3861500' WHERE kode_barcode='T0059473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='915000',harga_beli ='915000' WHERE kode_barcode='T0060259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='6515000',harga_beli ='6515000' WHERE kode_barcode='T0061257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='805500',harga_beli ='805500' WHERE kode_barcode='T0061867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='805500',harga_beli ='805500' WHERE kode_barcode='T0061868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2891500',harga_beli ='2891500' WHERE kode_barcode='T0062321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2562000',harga_beli ='2562000' WHERE kode_barcode='T0062323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3989500',harga_beli ='3989500' WHERE kode_barcode='T0062952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7595000',harga_beli ='7595000' WHERE kode_barcode='T0062953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7174000',harga_beli ='7174000' WHERE kode_barcode='T0063646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='4246000',harga_beli ='4246000' WHERE kode_barcode='T0064215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='4996000',harga_beli ='4996000' WHERE kode_barcode='T0065141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1189500',harga_beli ='1189500' WHERE kode_barcode='T0065158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3715000',harga_beli ='3715000' WHERE kode_barcode='T0065181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3715000',harga_beli ='3715000' WHERE kode_barcode='T0065968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='T0065981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1519000',harga_beli ='1519000' WHERE kode_barcode='T0066540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2672000',harga_beli ='2672000' WHERE kode_barcode='T0066568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3440500',harga_beli ='3440500' WHERE kode_barcode='T0066570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0066774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='T0067263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1007000',harga_beli ='1007000' WHERE kode_barcode='T0067264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2782000',harga_beli ='2782000' WHERE kode_barcode='T0068454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7338500',harga_beli ='7338500' WHERE kode_barcode='T0072945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3440500',harga_beli ='3440500' WHERE kode_barcode='T0068910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3276000',harga_beli ='3276000' WHERE kode_barcode='T0069485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3752000',harga_beli ='3752000' WHERE kode_barcode='T0069910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3257500',harga_beli ='3257500' WHERE kode_barcode='T0069940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3257500',harga_beli ='3257500' WHERE kode_barcode='T0069941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7796000',harga_beli ='7796000' WHERE kode_barcode='T0069943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5929500',harga_beli ='5929500' WHERE kode_barcode='T0070478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3733500',harga_beli ='3733500' WHERE kode_barcode='T0071213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='2873500',harga_beli ='2873500' WHERE kode_barcode='T0071243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='7466500',harga_beli ='7466500' WHERE kode_barcode='T0071524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='6039000',harga_beli ='6039000' WHERE kode_barcode='T0072943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3843000',harga_beli ='3843000' WHERE kode_barcode='T0072622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3697000',harga_beli ='3697000' WHERE kode_barcode='T0072624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='9077000',harga_beli ='9077000' WHERE kode_barcode='T0072629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='9077000',harga_beli ='9077000' WHERE kode_barcode='T0072630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5362000',harga_beli ='5362000' WHERE kode_barcode='T0072631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='22015000',harga_beli ='22015000' WHERE kode_barcode='T0072635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='9150000',harga_beli ='9150000' WHERE kode_barcode='T0072966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='5490000',harga_beli ='5490000' WHERE kode_barcode='T0073707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1848500',harga_beli ='1848500' WHERE kode_barcode='T0073708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1555500',harga_beli ='1555500' WHERE kode_barcode='T0073709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1555500',harga_beli ='1555500' WHERE kode_barcode='T0073710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1757000',harga_beli ='1757000' WHERE kode_barcode='T0073711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0073712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='4410500',harga_beli ='4410500' WHERE kode_barcode='T0073713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='586000',harga_beli ='586000' WHERE kode_barcode='T0074020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='T0074021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='6972500',harga_beli ='6972500' WHERE kode_barcode='T0074490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1629000',harga_beli ='1629000' WHERE kode_barcode='T0074552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='1775500',harga_beli ='1775500' WHERE kode_barcode='T0074553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3715000',harga_beli ='3715000' WHERE kode_barcode='T0074556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3752000',harga_beli ='3752000' WHERE kode_barcode='T0074557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3806500',harga_beli ='3806500' WHERE kode_barcode='T0074558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0074559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1830000',harga_jual='3770000',harga_beli ='3770000' WHERE kode_barcode='T0074560' LIMIT 1;
UPDATE tm_group SET harga='1830000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','1830000','admin','2025-11-05 08:10:26');
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='18592500',harga_beli ='18592500' WHERE kode_barcode='T0017808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1850000',harga_jual='12876000',harga_beli ='12876000' WHERE kode_barcode='T0033668' LIMIT 1;
UPDATE tm_group SET harga='1850000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','1850000','admin','2025-11-05 08:10:39');
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='T0044775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5984000',harga_beli ='5984000' WHERE kode_barcode='T0051841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4899500',harga_beli ='4899500' WHERE kode_barcode='T0051851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='13221000',harga_beli ='13221000' WHERE kode_barcode='T0056780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='6377000',harga_beli ='6377000' WHERE kode_barcode='T0056781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4095500',harga_beli ='4095500' WHERE kode_barcode='T0066769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='1272000',harga_beli ='1272000' WHERE kode_barcode='T0066770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='2113500',harga_beli ='2113500' WHERE kode_barcode='T0066772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='4133000',harga_beli ='4133000' WHERE kode_barcode='T0067265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='11126500',harga_beli ='11126500' WHERE kode_barcode='T0067267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='505000',harga_beli ='505000' WHERE kode_barcode='T0071238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='542500',harga_beli ='542500' WHERE kode_barcode='T0071645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1870000',harga_jual='5573000',harga_beli ='5573000' WHERE kode_barcode='T0073704' LIMIT 1;
UPDATE tm_group SET harga='1870000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','1870000','admin','2025-11-05 08:10:51');
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='5538000',harga_beli ='5538000' WHERE kode_barcode='T0036633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4801000',harga_beli ='4801000' WHERE kode_barcode='T0065165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1890000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='T0065166' LIMIT 1;
UPDATE tm_group SET harga='1890000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','1890000','admin','2025-11-05 08:11:04');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050820511','kasir','1',' TAE0 X DW ','TOKO','TBK-E','E0TA-XDBG-31-T','CC X SETENGAH RANTAI DW 18 17K ','OL','1.980','1','100.00','3346000','0','0','15000','3402000','0','14000','0','3416000','NS','T0056681','E0TA','0','0','-','0','1690000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-XDBG-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='E0TA-XDBG-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050820511','2025-11-05','1.980','2025-11-05','08:20:51','PLG0074464','3402000','3402000','14000','3416000','3416000','kasir','2025-11-05 08:20:51','F22505082051');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050820511','2025-11-05','08:20:51','NS','3416000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251105-0002','D','2025-11-05','08:20:51','kasir','PENJUALAN','F225050820511','2376939000','3416000','2380355000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3416000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225050820511' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050820512','kasir',' 1',' TEF3 UB ','TOKO','TBK-F','F3TE-YFAA-87-T','GL RANTAI HOLLOW SIRIP UB 17K ','OL','3.050','1','100.00','5459000','0','0','15000','5546000','0','21000','0','5567000','NS','T0069938','F3TE','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3TE-YFAA-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050820512','2025-11-05','3.050','2025-11-05','08:20:51','PLG0074465','5546000','5546000','21000','5567000','5567000','kasir','2025-11-05 08:20:51','F22505082051');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050820512','2025-11-05','08:20:51','NS','5567000','21000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251105-0003','D','2025-11-05','08:20:51','kasir','PENJUALAN','F225050820512','2380355000','5567000','2385922000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225050820512' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050842111','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YJCA-11-T','GL HOLLOW DOUBLE MODEL DAUN VAR HW 8K ','OL','1.910','1','100.00','1910000','0','0','15000','1930000','0','10000','0','1940000','NS','T0074742','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCA-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3E-YJCA-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050842111','2025-11-05','1.910','2025-11-05','08:42:12','PLG0074466','1930000','1930000','10000','1940000','1940000','kasir','2025-11-05 08:42:11','F22505084211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050842111','2025-11-05','08:42:12','NS','1940000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0004','D','2025-11-05','08:42:12','kasir','PENJUALAN','F225050842111','2385922000','1940000','2387862000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050912531','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJBI-107-T','AT KLIP BANGKOK SLEP LG 8K ','OL','0.600','1','100.00','600000','0','0','15000','610000','0','5000','0','615000','TJ','T0074667','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBI-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='A1E-YJBI-107-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050912531','2025-11-05','0.600','2025-11-05','09:12:54','PLG0074467','610000','610000','5000','615000','615000','kasir','2025-11-05 09:12:53','F22505091253');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050912531','2025-11-05','09:12:54','TJ','615000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0005','D','2025-11-05','09:12:54','kasir','PENJUALAN','F225050912531','2387862000','615000','2388477000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051012051','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YKXA-76-T','GL MODEL FLIK CAPELA VAR HW 8K ','','1.770','1','100.00','1770000','0','0','15000','1770000','0','0','0','1770000','RTA','T0074871','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXA-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3E-YKXA-76-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051012051','2025-11-05','1.770','2025-11-05','10:12:06','PLG0074468','1770000','1770000','0','1770000','1770000','kasir','2025-11-05 10:12:05','F22505101205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051012051','2025-11-05','10:12:06','RTA','1770000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0006','D','2025-11-05','10:12:06','kasir','PENJUALAN','F225051012051','2388477000','1770000','2390247000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051023421','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YKXC-20-T','GW TUSUK MODEL DOLLAR CM PE 8K ','OL','0.550','1','100.00','550000','0','0','15000','556000','0','5000','0','561000','NS','T0074933','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXC-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='B1E-YKXC-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051023421','2025-11-05','0.550','2025-11-05','10:23:43','PLG0074469','556000','556000','5000','561000','561000','kasir','2025-11-05 10:23:42','F22505102342');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051023421','2025-11-05','10:23:43','NS','561000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0007','D','2025-11-05','10:23:43','kasir','PENJUALAN','F225051023421','2390247000','561000','2390808000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051051431','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YIXE-36-T','GL KOREA UB 17K ','','0.420','1','100.00','760000','0','0','15000','760000','0','0','0','760000','TIN','T0073006','F3TF','0','0','-','0','1810000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YIXE-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3TF-YIXE-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051051431','2025-11-05','0.420','2025-11-05','10:51:44','PLG0074470','760000','760000','0','760000','760000','kasir','2025-11-05 10:51:43','F22505105143');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051051431','2025-11-05','10:51:44','TIN','760000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0008','D','2025-11-05','10:51:44','kasir','PENJUALAN','F225051051431','2390808000','760000','2391568000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051052081','kasir','1',' MEF3E LT ','TOKO','SMBK-F','F3E-YJBA-9-T','GL MODEL GHENIA ANAK LT 8K ','','1.030','1','100.00','1030000','0','0','15000','1030000','0','0','0','1030000','TIN','T0074330','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBA-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3E-YJBA-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051052081','2025-11-05','1.030','2025-11-05','10:52:09','PLG0074471','1030000','1030000','0','1030000','1030000','kasir','2025-11-05 10:52:08','F22505105208');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051052081','2025-11-05','10:52:09','TIN','1030000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0009','D','2025-11-05','10:52:09','kasir','PENJUALAN','F225051052081','2391568000','1030000','2392598000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051119101','kasir','1',' MEF2 X UB ','TOKO','SMBK-F','F2E-YHBI-249-0','GL X OVAL MATA UB 54 8K ','','2.520','1','100.00','2520000','0','0','15000','2520000','0','0','0','2520000','TIN','00367490','F2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YHBI-249-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F2E-YHBI-249-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051119101','2025-11-05','2.520','2025-11-05','11:19:10','PLG0074472','2520000','2520000','0','2520000','2520000','kasir','2025-11-05 11:19:10','F22505111910');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051119101','2025-11-05','11:19:10','TIN','2520000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0010','D','2025-11-05','11:19:10','kasir','PENJUALAN','F225051119101','2392598000','2520000','2395118000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051220551','kasir','1',' MGPE AY 18','TOKO','SMBK-P','PEG-VJXA-9-T','CC WG LISTRING MATA AY 18 ','','1.020','1','100.00','1061000','0','0','15000','1061000','0','10000','0','1071000','RTA','T0038579','PEG','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEG-VJXA-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PEG-VJXA-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051220551','2025-11-05','1.020','2025-11-05','12:20:56','PLG0074473','1061000','1061000','10000','1071000','1071000','kasir','2025-11-05 12:20:55','F22505122055');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051220551','2025-11-05','12:20:56','RTA','1071000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0011','D','2025-11-05','12:20:56','kasir','PENJUALAN','F225051220551','2395118000','1071000','2396189000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225051239121','kasir','1',' MEB1 X BM ','TOKO','SMBK-B','B1E-YKXA-115-0','GW X MODEL CAT HITAM BM PE 8K ','OL','0.550','1','100.00','550000','0','0','15000','556000','0','5000','0','561000','RTA','00375685','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXA-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='B1E-YKXA-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225051239121','2025-11-05','0.550','2025-11-05','12:39:12','PLG0074474','556000','556000','5000','561000','561000','kasir','2025-11-05 12:39:12','F22505123912');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225051239121','2025-11-05','12:39:12','RTA','561000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0012','D','2025-11-05','12:39:12','kasir','PENJUALAN','F225051239121','2396189000','561000','2396750000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050148261','kasir','1',' MEE1 HW 17','TOKO','SMBK-E','E1E-YKXA-95-T','CC MODEL SLEP VAR HW 17 8K ','OL H','0.640','1','100.00','640000','0','0','15000','645000','0','10000','0','655000','NS','T0074890','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXA-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='E1E-YKXA-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050148261','2025-11-05','0.640','2025-11-05','13:48:27','PLG0074475','645000','645000','10000','655000','655000','kasir','2025-11-05 13:48:26','F22505014826');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050148261','2025-11-05','13:48:27','NS','655000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0013','D','2025-11-05','13:48:27','kasir','PENJUALAN','F225050148261','2396750000','655000','2397405000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050210271','kasir','1',' MEA1E X UB','TOKO','SMBK-A','A1E-YFBX-12-0','AT X MODEL MATA UB 8K','','0.770','1','100.00','770000','0','0','15000','770000','0','0','0','770000','RTA','00358097','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YFBX-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='A1E-YFBX-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050210271','2025-11-05','0.770','2025-11-05','14:10:27','PLG0074476','770000','770000','0','770000','770000','kasir','2025-11-05 14:10:27','F22505021027');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050210271','2025-11-05','14:10:27','RTA','770000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0014','D','2025-11-05','14:10:27','kasir','PENJUALAN','F225050210271','2397405000','770000','2398175000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050223011','kasir','1',' MEE1 HW 15','TOKO','SMBK-E','E1E-YKXA-89-T','CC MODEL SLEP VAR HW 15 8K ','OL','0.590','1','100.00','590000','0','0','15000','599000','0','5000','0','604000','NS','T0074884','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXA-89-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='E1E-YKXA-89-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050223011','2025-11-05','0.590','2025-11-05','14:23:01','PLG0074477','599000','599000','5000','604000','604000','kasir','2025-11-05 14:23:01','F22505022301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050223011','2025-11-05','14:23:01','NS','604000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0015','D','2025-11-05','14:23:01','kasir','PENJUALAN','F225050223011','2398175000','604000','2398779000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050148261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050148261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050148261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050210271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050210271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050210271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050223011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050223011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050223011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050820511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050820511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050820511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050820512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050820512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050820512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050842111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050842111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050842111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050912531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050912531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050912531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051012051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051012051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051012051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051023421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051023421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051023421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051051431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051051431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051051431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051052081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051052081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051052081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051119101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051119101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051119101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051220551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051220551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051220551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225051239121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225051239121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225051239121';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050319441','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YJXC-58-T','GL SANTA POLOS UB 17K ','','1.420','1','100.00','2570000','0','0','15000','2570000','0','0','0','2570000','TIN','T0073779','F3TF','0','0','-','0','1810000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YJXC-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='F3TF-YJXC-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050319441','2025-11-05','1.420','2025-11-05','15:19:45','PLG0074478','2570000','2570000','0','2570000','2570000','kasir','2025-11-05 15:19:44','F22505031944');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050319441','2025-11-05','15:19:45','TIN','2570000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0016','D','2025-11-05','15:19:45','kasir','PENJUALAN','F225050319441','2398779000','2570000','2401349000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225050320541','kasir','1',' MDE2 CM 10','TOKO','SMBK-E','E2D-YGBB-132-T','CC MODEL MATA VAR CM 10 8K ','','0.910','1','100.00','892000','0','0','15000','892000','0','0','0','892000','RTA','T0071404','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGBB-132-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='E2D-YGBB-132-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225050320541','2025-11-05','0.910','2025-11-05','15:20:55','PLG0074479','892000','892000','0','892000','892000','kasir','2025-11-05 15:20:54','F22505032054');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','F225050320541','2025-11-05','15:20:55','RTA','892000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251105-0017','D','2025-11-05','15:20:55','kasir','PENJUALAN','F225050320541','2401349000','892000','2402241000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050319441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050319441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050319441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225050320541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225050320541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225050320541';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-05';
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-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-05';
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-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','2402241000','2402241000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','BCA','SALDO AWAL','SALDO AWAL','0','4115435888','4115435888');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0001','D','2025-11-06','16:03:12','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-11-06';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','A1H-YKXE-2-0','1','0.290','0.290','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1H-YKXE-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1H-YKXE-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-06 16:39:43' WHERE kode_barang='A1H-YKXE-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1H-YKXE-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:39:43','TOKO','SMBK-A','A1H','A1H-YKXE-2-0','1','0.290','0.290','1','0.290','0.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1H-YKXE-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1H-YKXE-2-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','A1H-YKXE-4-0','1','0.280','0.280','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1H-YKXE-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1H-YKXE-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-06 16:39:43' WHERE kode_barang='A1H-YKXE-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1H-YKXE-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:39:43','TOKO','SMBK-A','A1H','A1H-YKXE-4-0','1','0.280','0.280','1','0.280','0.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1H-YKXE-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1H-YKXE-4-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251106-0001','2025-11-06','16:39','0.570','input','2025-11-05 16:39:43');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','B1E-YKXE-16-0','1','0.480','0.480','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YKXE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YKXE-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-06 16:39:59' WHERE kode_barang='B1E-YKXE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YKXE-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:39:59','TOKO','SMBK-B','B1E','B1E-YKXE-16-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YKXE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YKXE-16-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251106-0001','2025-11-06','16:39','0.480','input','2025-11-05 16:39:58');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','D1H-YKXE-87-0','1','0.200','0.200','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1H-YKXE-87-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1H-YKXE-87-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-06 16:40:13' WHERE kode_barang='D1H-YKXE-87-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1H-YKXE-87-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:40:13','TOKO','SMBK-D','D1H','D1H-YKXE-87-0','1','0.200','0.200','1','0.200','0.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1H-YKXE-87-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1H-YKXE-87-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','D1F-YKXE-88-0','1','1.700','1.700','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YKXE-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YKXE-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-06 16:40:13' WHERE kode_barang='D1F-YKXE-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YKXE-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:40:13','TOKO','SMBK-D','D1F','D1F-YKXE-88-0','1','1.700','1.700','1','1.700','1.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YKXE-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YKXE-88-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','D1E-YKXE-89-0','1','1.100','1.100','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-YKXE-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-YKXE-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-06 16:40:13' WHERE kode_barang='D1E-YKXE-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-YKXE-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:40:13','TOKO','SMBK-D','D1E','D1E-YKXE-89-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-YKXE-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-YKXE-89-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251106-0001','2025-11-06','16:40','3.000','input','2025-11-05 16:40:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','F3E-YKXE-52-0','1','1.530','1.530','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXE-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXE-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-11-06 16:40:28' WHERE kode_barang='F3E-YKXE-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXE-52-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:40:28','TOKO','SMBK-F','F3E','F3E-YKXE-52-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKXE-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXE-52-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251106-0001','2025-11-06','16:40','1.530','input','2025-11-05 16:40:28');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251106-0001','1','H1E-YKXE-40-0','1','2.810','2.810','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKXE-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKXE-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-06 16:40:42' WHERE kode_barang='H1E-YKXE-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKXE-40-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-06 16:40:42','TOKO','SMBK-H','H1E','H1E-YKXE-40-0','1','2.810','2.810','1','2.810','2.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKXE-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKXE-40-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251106-0001','2025-11-06','16:40','2.810','input','2025-11-05 16:40:42');