UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='7680000',harga_beli ='7680000' WHERE kode_barcode='T0056680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='922000',harga_beli ='922000' WHERE kode_barcode='T0074507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0074503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0074501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0074498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0074496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='922000',harga_beli ='922000' WHERE kode_barcode='T0074495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0071250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3840000',harga_beli ='3840000' WHERE kode_barcode='T0069572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0068706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='7642000',harga_beli ='7642000' WHERE kode_barcode='T0059362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0056799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0074508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5760000',harga_beli ='5760000' WHERE kode_barcode='T0056676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3782500',harga_beli ='3782500' WHERE kode_barcode='T0056671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0056668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1882000',harga_beli ='1882000' WHERE kode_barcode='T0056663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5760000',harga_beli ='5760000' WHERE kode_barcode='T0056344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3840000',harga_beli ='3840000' WHERE kode_barcode='T0056336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0056331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0056329' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3802000',harga_beli ='3802000' WHERE kode_barcode='T0052735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5587500',harga_beli ='5587500' WHERE kode_barcode='T0048326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='11520000',harga_beli ='11520000' WHERE kode_barcode='T0044148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0076179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0076213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3782500',harga_beli ='3782500' WHERE kode_barcode='T0076212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5722000',harga_beli ='5722000' WHERE kode_barcode='T0076211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0076210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0076209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1862500',harga_beli ='1862500' WHERE kode_barcode='T0076208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0076207' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0076192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='902500',harga_beli ='902500' WHERE kode_barcode='T0076191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0076183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1939500',harga_beli ='1939500' WHERE kode_barcode='T0076182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5760000',harga_beli ='5760000' WHERE kode_barcode='T0044147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0076177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='7680000',harga_beli ='7680000' WHERE kode_barcode='T0074533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='2880000',harga_beli ='2880000' WHERE kode_barcode='T0074532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3840000',harga_beli ='3840000' WHERE kode_barcode='T0074531' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='T0074528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0074517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0074516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0074515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0074514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='998500',harga_beli ='998500' WHERE kode_barcode='T0074513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0003671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='13286500',harga_beli ='13286500' WHERE kode_barcode='T0014670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0005809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='2803500',harga_beli ='2803500' WHERE kode_barcode='T0003851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='2822500',harga_beli ='2822500' WHERE kode_barcode='T0003847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3802000',harga_beli ='3802000' WHERE kode_barcode='T0003846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5779500',harga_beli ='5779500' WHERE kode_barcode='T0003842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3974500',harga_beli ='3974500' WHERE kode_barcode='T0003841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='7200000',harga_beli ='7200000' WHERE kode_barcode='T0003829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9408000',harga_beli ='9408000' WHERE kode_barcode='T0003820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0003819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='960000',harga_beli ='960000' WHERE kode_barcode='T0003679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9504000',harga_beli ='9504000' WHERE kode_barcode='T0022027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0003642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0003330' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0003326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='11558500',harga_beli ='11558500' WHERE kode_barcode='T0003304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9562000',harga_beli ='9562000' WHERE kode_barcode='T0003293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9504000',harga_beli ='9504000' WHERE kode_barcode='T0003292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0003285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3552000',harga_beli ='3552000' WHERE kode_barcode='T0003283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='15264000',harga_beli ='15264000' WHERE kode_barcode='T0003262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9638500',harga_beli ='9638500' WHERE kode_barcode='T0041591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='2880000',harga_beli ='2880000' WHERE kode_barcode='T0044142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='5760000',harga_beli ='5760000' WHERE kode_barcode='T0044139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='19200000',harga_beli ='19200000' WHERE kode_barcode='T0044138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='7680000',harga_beli ='7680000' WHERE kode_barcode='T0042438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0042437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='19200000',harga_beli ='19200000' WHERE kode_barcode='T0041606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='11520000',harga_beli ='11520000' WHERE kode_barcode='T0041605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='13440000',harga_beli ='13440000' WHERE kode_barcode='T0041604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9542500',harga_beli ='9542500' WHERE kode_barcode='T0041601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='15360000',harga_beli ='15360000' WHERE kode_barcode='T0041600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3840000',harga_beli ='3840000' WHERE kode_barcode='T0041593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='11424000',harga_beli ='11424000' WHERE kode_barcode='T0003259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9562000',harga_beli ='9562000' WHERE kode_barcode='T0041584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0041548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='2880000',harga_beli ='2880000' WHERE kode_barcode='T0036748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3802000',harga_beli ='3802000' WHERE kode_barcode='T0036741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0036020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='9600000',harga_beli ='9600000' WHERE kode_barcode='T0034703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='3840000',harga_beli ='3840000' WHERE kode_barcode='T0032890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0016552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0016550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1920000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0016549' LIMIT 1;
UPDATE tm_group SET harga='1920000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1920000','admin','2026-06-15 07:46:36');
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2720000',harga_beli ='2720000' WHERE kode_barcode='T0072901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2340000',harga_beli ='2340000' WHERE kode_barcode='T0072910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0072908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3060000',harga_beli ='3060000' WHERE kode_barcode='T0062918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3240000',harga_beli ='3240000' WHERE kode_barcode='T0062921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='5660000',harga_beli ='5660000' WHERE kode_barcode='T0062929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3580000',harga_beli ='3580000' WHERE kode_barcode='T0064209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4400000',harga_beli ='4400000' WHERE kode_barcode='T0065414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3700000',harga_beli ='3700000' WHERE kode_barcode='T0065420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2860000',harga_beli ='2860000' WHERE kode_barcode='T0067225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4560000',harga_beli ='4560000' WHERE kode_barcode='T0067241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2120000',harga_beli ='2120000' WHERE kode_barcode='T0078250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1840000',harga_beli ='1840000' WHERE kode_barcode='T0078244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0069895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3360000',harga_beli ='3360000' WHERE kode_barcode='T0070449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2740000',harga_beli ='2740000' WHERE kode_barcode='T0070455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3940000',harga_beli ='3940000' WHERE kode_barcode='T0070757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3020000',harga_beli ='3020000' WHERE kode_barcode='T0078252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2180000',harga_beli ='2180000' WHERE kode_barcode='T0071212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4100500',harga_beli ='4100500' WHERE kode_barcode='T0071502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3800000',harga_beli ='3800000' WHERE kode_barcode='T0072931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2600000',harga_beli ='2600000' WHERE kode_barcode='T0072928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='T0072926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2100000',harga_beli ='2100000' WHERE kode_barcode='T0072590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1940000',harga_beli ='1940000' WHERE kode_barcode='T0072596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4760000',harga_beli ='4760000' WHERE kode_barcode='T0072618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3420000',harga_beli ='3420000' WHERE kode_barcode='T0072958' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2500000',harga_beli ='2500000' WHERE kode_barcode='T0072961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3000000',harga_beli ='3000000' WHERE kode_barcode='T0073003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0078251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='T0078238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2160000',harga_beli ='2160000' WHERE kode_barcode='T0078245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4460000',harga_beli ='4460000' WHERE kode_barcode='T0073683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='T0073686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2000000',harga_beli ='2000000' WHERE kode_barcode='T0073688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2960000',harga_beli ='2960000' WHERE kode_barcode='T0073691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3920000',harga_beli ='3920000' WHERE kode_barcode='T0073726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3940000',harga_beli ='3940000' WHERE kode_barcode='T0073727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='T0073743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='7940000',harga_beli ='7940000' WHERE kode_barcode='T0074527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3660000',harga_beli ='3660000' WHERE kode_barcode='T0078247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3760000',harga_beli ='3760000' WHERE kode_barcode='T0078236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2820000',harga_beli ='2820000' WHERE kode_barcode='T0075667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0075669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2900000',harga_beli ='2900000' WHERE kode_barcode='T0075676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4120000',harga_beli ='4120000' WHERE kode_barcode='T0075683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2600000',harga_beli ='2600000' WHERE kode_barcode='T0075684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3960000',harga_beli ='3960000' WHERE kode_barcode='T0075686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4160000',harga_beli ='4160000' WHERE kode_barcode='T0075687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3700000',harga_beli ='3700000' WHERE kode_barcode='T0075690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3020000',harga_beli ='3020000' WHERE kode_barcode='T0075698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4000000',harga_beli ='4000000' WHERE kode_barcode='T0075703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='T0075705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1860000',harga_beli ='1860000' WHERE kode_barcode='T0076204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1900000',harga_beli ='1900000' WHERE kode_barcode='T0076206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0076758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3060000',harga_beli ='3060000' WHERE kode_barcode='T0076761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3760000',harga_beli ='3760000' WHERE kode_barcode='T0076762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4040000',harga_beli ='4040000' WHERE kode_barcode='T0076773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1940000',harga_beli ='1940000' WHERE kode_barcode='T0078249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2400000',harga_beli ='2400000' WHERE kode_barcode='T0078394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2340000',harga_beli ='2340000' WHERE kode_barcode='T0078395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2300000',harga_beli ='2300000' WHERE kode_barcode='T0078397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2660000',harga_beli ='2660000' WHERE kode_barcode='T0078410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1660000',harga_beli ='1660000' WHERE kode_barcode='T0078413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1640000',harga_beli ='1640000' WHERE kode_barcode='T0078414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2120000',harga_beli ='2120000' WHERE kode_barcode='T0078416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2420000',harga_beli ='2420000' WHERE kode_barcode='T0078423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4640000',harga_beli ='4640000' WHERE kode_barcode='T0078428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='T0078429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2000000',harga_beli ='2000000' WHERE kode_barcode='T0078439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0078464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2100000',harga_beli ='2100000' WHERE kode_barcode='T0078478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0078479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0078480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3060000',harga_beli ='3060000' WHERE kode_barcode='T0078481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3000000',harga_beli ='3000000' WHERE kode_barcode='T0078483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2200000',harga_beli ='2200000' WHERE kode_barcode='T0079764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0079766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4140500',harga_beli ='4140500' WHERE kode_barcode='T0079767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2400000',harga_beli ='2400000' WHERE kode_barcode='T0079768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2820000',harga_beli ='2820000' WHERE kode_barcode='T0079770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2900000',harga_beli ='2900000' WHERE kode_barcode='T0079771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2400000',harga_beli ='2400000' WHERE kode_barcode='T0079774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2840000',harga_beli ='2840000' WHERE kode_barcode='T0079777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3140000',harga_beli ='3140000' WHERE kode_barcode='T0079778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='T0079779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2720000',harga_beli ='2720000' WHERE kode_barcode='T0079780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='T0079781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2380000',harga_beli ='2380000' WHERE kode_barcode='T0079783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2000000',harga_beli ='2000000' WHERE kode_barcode='T0079784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3200000',harga_beli ='3200000' WHERE kode_barcode='T0079785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2280000',harga_beli ='2280000' WHERE kode_barcode='T0079787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1920000',harga_beli ='1920000' WHERE kode_barcode='T0079788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1860000',harga_beli ='1860000' WHERE kode_barcode='T0079789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0079790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1700000',harga_beli ='1700000' WHERE kode_barcode='T0079793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='T0079794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='T0079796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2000000',harga_beli ='2000000' WHERE kode_barcode='T0079797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0079798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2000000',harga_beli ='2000000' WHERE kode_barcode='T0079799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3060000',harga_beli ='3060000' WHERE kode_barcode='T0079801' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0079802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2920000',harga_beli ='2920000' WHERE kode_barcode='T0079803' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2240000',harga_beli ='2240000' WHERE kode_barcode='T0079804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4000000',harga_beli ='4000000' WHERE kode_barcode='T0079805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0079806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3640000',harga_beli ='3640000' WHERE kode_barcode='T0079807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3280000',harga_beli ='3280000' WHERE kode_barcode='T0079808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='T0079809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2780000',harga_beli ='2780000' WHERE kode_barcode='T0079812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2340000',harga_beli ='2340000' WHERE kode_barcode='T0079818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='T0079819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2720000',harga_beli ='2720000' WHERE kode_barcode='T0079820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0079854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='2200000',harga_beli ='2200000' WHERE kode_barcode='T0079855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='1960000',harga_beli ='1960000' WHERE kode_barcode='T0079857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='T0080414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='T0080416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3040000',harga_beli ='3040000' WHERE kode_barcode='T0080418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2000000',harga_jual='3100000',harga_beli ='3100000' WHERE kode_barcode='T0080419' LIMIT 1;
UPDATE tm_group SET harga='2000000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','2000000','admin','2026-06-15 07:46:48');
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2424000',harga_beli ='2424000' WHERE kode_barcode='T0001219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='40501000',harga_beli ='40501000' WHERE kode_barcode='T0001397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2262500',harga_beli ='2262500' WHERE kode_barcode='T0003166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1919000',harga_beli ='1919000' WHERE kode_barcode='T0008353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2182000',harga_beli ='2182000' WHERE kode_barcode='T0008357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2182000',harga_beli ='2182000' WHERE kode_barcode='T0012058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='T0015578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='T0040036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1434500',harga_beli ='1434500' WHERE kode_barcode='T0027957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3596000',harga_beli ='3596000' WHERE kode_barcode='T0029930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2161500',harga_beli ='2161500' WHERE kode_barcode='T0034478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='T0034479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1252500',harga_beli ='1252500' WHERE kode_barcode='T0034489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1313000',harga_beli ='1313000' WHERE kode_barcode='T0034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1273000',harga_beli ='1273000' WHERE kode_barcode='T0034492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1151500',harga_beli ='1151500' WHERE kode_barcode='T0037257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2222000',harga_beli ='2222000' WHERE kode_barcode='T0037655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3394000',harga_beli ='3394000' WHERE kode_barcode='T0037708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0038064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3939000',harga_beli ='3939000' WHERE kode_barcode='T0040939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='13029000',harga_beli ='13029000' WHERE kode_barcode='T0041108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2283000',harga_beli ='2283000' WHERE kode_barcode='T0041488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='T0045140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1434500',harga_beli ='1434500' WHERE kode_barcode='T0041808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1576000',harga_beli ='1576000' WHERE kode_barcode='T0041884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='T0042082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3959500',harga_beli ='3959500' WHERE kode_barcode='T0042141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='9555000',harga_beli ='9555000' WHERE kode_barcode='T0042168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4747000',harga_beli ='4747000' WHERE kode_barcode='T0042862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3495000',harga_beli ='3495000' WHERE kode_barcode='T0043167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1858500',harga_beli ='1858500' WHERE kode_barcode='T0043446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1939500',harga_beli ='1939500' WHERE kode_barcode='T0043447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='14281500',harga_beli ='14281500' WHERE kode_barcode='T0043497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20301000',harga_beli ='20301000' WHERE kode_barcode='T0043498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0043536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1313000',harga_beli ='1313000' WHERE kode_barcode='T0043539' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='T0044004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2040500',harga_beli ='2040500' WHERE kode_barcode='T0045061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2626000',harga_beli ='2626000' WHERE kode_barcode='T0045361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5313000',harga_beli ='5313000' WHERE kode_barcode='T0045441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='18826500',harga_beli ='18826500' WHERE kode_barcode='T0045473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='16059000',harga_beli ='16059000' WHERE kode_barcode='T0045476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='T0046025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1333500',harga_beli ='1333500' WHERE kode_barcode='T0046035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3353500',harga_beli ='3353500' WHERE kode_barcode='T0048156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1475000',harga_beli ='1475000' WHERE kode_barcode='T0048379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1980000',harga_beli ='1980000' WHERE kode_barcode='T0048717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4040000',harga_beli ='4040000' WHERE kode_barcode='T0049361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3192000',harga_beli ='3192000' WHERE kode_barcode='T0049588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4767500',harga_beli ='4767500' WHERE kode_barcode='T0050859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1879000',harga_beli ='1879000' WHERE kode_barcode='T0051654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2929000',harga_beli ='2929000' WHERE kode_barcode='T0053132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2040500',harga_beli ='2040500' WHERE kode_barcode='T0054076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1919000',harga_beli ='1919000' WHERE kode_barcode='T0054761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5959000',harga_beli ='5959000' WHERE kode_barcode='T0056238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7898500',harga_beli ='7898500' WHERE kode_barcode='T0056761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1273000',harga_beli ='1273000' WHERE kode_barcode='T0057062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4303000',harga_beli ='4303000' WHERE kode_barcode='T0059319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1111000',harga_beli ='1111000' WHERE kode_barcode='T0059389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2848500',harga_beli ='2848500' WHERE kode_barcode='T0059417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2182000',harga_beli ='2182000' WHERE kode_barcode='T0059422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2929000',harga_beli ='2929000' WHERE kode_barcode='T0059436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2949500',harga_beli ='2949500' WHERE kode_barcode='T0059443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2222000',harga_beli ='2222000' WHERE kode_barcode='T0060254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6080500',harga_beli ='6080500' WHERE kode_barcode='T0061866' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3939000',harga_beli ='3939000' WHERE kode_barcode='T0062552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3959500',harga_beli ='3959500' WHERE kode_barcode='T0062553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4000000',harga_beli ='4000000' WHERE kode_barcode='T0062554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3091000',harga_beli ='3091000' WHERE kode_barcode='T0065489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20463000',harga_beli ='20463000' WHERE kode_barcode='T0078268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1555500',harga_beli ='1555500' WHERE kode_barcode='T0067228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='T0067256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6666000',harga_beli ='6666000' WHERE kode_barcode='T0078266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='14100000',harga_beli ='14100000' WHERE kode_barcode='T0068897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6121000',harga_beli ='6121000' WHERE kode_barcode='T0078272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5858000',harga_beli ='5858000' WHERE kode_barcode='T0069479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='14342000',harga_beli ='14342000' WHERE kode_barcode='T0078262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4101000',harga_beli ='4101000' WHERE kode_barcode='T0069930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6282500',harga_beli ='6282500' WHERE kode_barcode='T0070139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3979500',harga_beli ='3979500' WHERE kode_barcode='T0070482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='T0070484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3939000',harga_beli ='3939000' WHERE kode_barcode='T0070537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0070876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2020000',harga_beli ='2020000' WHERE kode_barcode='T0071214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1374000',harga_beli ='1374000' WHERE kode_barcode='T0071225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1374000',harga_beli ='1374000' WHERE kode_barcode='T0071226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20301000',harga_beli ='20301000' WHERE kode_barcode='T0071496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5353000',harga_beli ='5353000' WHERE kode_barcode='T0071664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='12221000',harga_beli ='12221000' WHERE kode_barcode='T0078261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='16059000',harga_beli ='16059000' WHERE kode_barcode='T0078263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20038500',harga_beli ='20038500' WHERE kode_barcode='T0073694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1374000',harga_beli ='1374000' WHERE kode_barcode='T0073734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1353500',harga_beli ='1353500' WHERE kode_barcode='T0073735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='9090000',harga_beli ='9090000' WHERE kode_barcode='T0073766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2828000',harga_beli ='2828000' WHERE kode_barcode='T0073777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3151500',harga_beli ='3151500' WHERE kode_barcode='T0073778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8322500',harga_beli ='8322500' WHERE kode_barcode='T0078254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='10403000',harga_beli ='10403000' WHERE kode_barcode='T0074485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1131500',harga_beli ='1131500' WHERE kode_barcode='T0074483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3151500',harga_beli ='3151500' WHERE kode_barcode='T0074551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='2889000',harga_beli ='2889000' WHERE kode_barcode='T0078270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1111000',harga_beli ='1111000' WHERE kode_barcode='T0075661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1071000',harga_beli ='1071000' WHERE kode_barcode='T0075663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1071000',harga_beli ='1071000' WHERE kode_barcode='T0075664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0075673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1030500',harga_beli ='1030500' WHERE kode_barcode='T0075674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6201500',harga_beli ='6201500' WHERE kode_barcode='T0075710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6080500',harga_beli ='6080500' WHERE kode_barcode='T0075711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7999500',harga_beli ='7999500' WHERE kode_barcode='T0075712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3838000',harga_beli ='3838000' WHERE kode_barcode='T0075713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='16160000',harga_beli ='16160000' WHERE kode_barcode='T0075720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20422500',harga_beli ='20422500' WHERE kode_barcode='T0075722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='16221000',harga_beli ='16221000' WHERE kode_barcode='T0075725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4242000',harga_beli ='4242000' WHERE kode_barcode='T0075726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5717000',harga_beli ='5717000' WHERE kode_barcode='T0075733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='11009000',harga_beli ='11009000' WHERE kode_barcode='T0075734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8625500',harga_beli ='8625500' WHERE kode_barcode='T0075735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='11070000',harga_beli ='11070000' WHERE kode_barcode='T0075804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6787500',harga_beli ='6787500' WHERE kode_barcode='T0075809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='9918500',harga_beli ='9918500' WHERE kode_barcode='T0076216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6403500',harga_beli ='6403500' WHERE kode_barcode='T0076757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3010000',harga_beli ='3010000' WHERE kode_barcode='T0076759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0078398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0078399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0078401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='T0078402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1131500',harga_beli ='1131500' WHERE kode_barcode='T0078404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='T0078406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1576000',harga_beli ='1576000' WHERE kode_barcode='T0078419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1273000',harga_beli ='1273000' WHERE kode_barcode='T0078420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1313000',harga_beli ='1313000' WHERE kode_barcode='T0078422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1454500',harga_beli ='1454500' WHERE kode_barcode='T0078433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1273000',harga_beli ='1273000' WHERE kode_barcode='T0078436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7373000',harga_beli ='7373000' WHERE kode_barcode='T0078444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7110500',harga_beli ='7110500' WHERE kode_barcode='T0078445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5696500',harga_beli ='5696500' WHERE kode_barcode='T0078446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5292500',harga_beli ='5292500' WHERE kode_barcode='T0078448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8282500',harga_beli ='8282500' WHERE kode_barcode='T0078453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='10302000',harga_beli ='10302000' WHERE kode_barcode='T0078456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8221500',harga_beli ='8221500' WHERE kode_barcode='T0078457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8080000',harga_beli ='8080000' WHERE kode_barcode='T0078458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='10100000',harga_beli ='10100000' WHERE kode_barcode='T0078460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1313000',harga_beli ='1313000' WHERE kode_barcode='T0078476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='10322500',harga_beli ='10322500' WHERE kode_barcode='T0078486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8201500',harga_beli ='8201500' WHERE kode_barcode='T0078488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8181000',harga_beli ='8181000' WHERE kode_barcode='T0078490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0079775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1172000',harga_beli ='1172000' WHERE kode_barcode='T0079792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1535500',harga_beli ='1535500' WHERE kode_barcode='T0079813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1010000',harga_beli ='1010000' WHERE kode_barcode='T0079815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1071000',harga_beli ='1071000' WHERE kode_barcode='T0079816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1212000',harga_beli ='1212000' WHERE kode_barcode='T0079817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8888000',harga_beli ='8888000' WHERE kode_barcode='T0079821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='9151000',harga_beli ='9151000' WHERE kode_barcode='T0079823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='17271000',harga_beli ='17271000' WHERE kode_barcode='T0079824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='16867000',harga_beli ='16867000' WHERE kode_barcode='T0079825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='12019000',harga_beli ='12019000' WHERE kode_barcode='T0079826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='30603000',harga_beli ='30603000' WHERE kode_barcode='T0079827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6080500',harga_beli ='6080500' WHERE kode_barcode='T0079829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='10565000',harga_beli ='10565000' WHERE kode_barcode='T0079830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6121000',harga_beli ='6121000' WHERE kode_barcode='T0079831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5777500',harga_beli ='5777500' WHERE kode_barcode='T0079832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4181500',harga_beli ='4181500' WHERE kode_barcode='T0079833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='12120000',harga_beli ='12120000' WHERE kode_barcode='T0079834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7939000',harga_beli ='7939000' WHERE kode_barcode='T0079835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4141500',harga_beli ='4141500' WHERE kode_barcode='T0079836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6060000',harga_beli ='6060000' WHERE kode_barcode='T0079838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8201500',harga_beli ='8201500' WHERE kode_barcode='T0079839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='8120500',harga_beli ='8120500' WHERE kode_barcode='T0079840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5999500',harga_beli ='5999500' WHERE kode_barcode='T0079841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3757500',harga_beli ='3757500' WHERE kode_barcode='T0079842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4343000',harga_beli ='4343000' WHERE kode_barcode='T0079843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='9999000',harga_beli ='9999000' WHERE kode_barcode='T0079846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='15332000',harga_beli ='15332000' WHERE kode_barcode='T0079847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='20059000',harga_beli ='20059000' WHERE kode_barcode='T0079848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='3272500',harga_beli ='3272500' WHERE kode_barcode='T0079849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='7030000',harga_beli ='7030000' WHERE kode_barcode='T0079851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='646500',harga_beli ='646500' WHERE kode_barcode='T0079852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='707000',harga_beli ='707000' WHERE kode_barcode='T0079853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='4525000',harga_beli ='4525000' WHERE kode_barcode='T0080405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6181500',harga_beli ='6181500' WHERE kode_barcode='T0080406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='14180500',harga_beli ='14180500' WHERE kode_barcode='T0080407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='5939000',harga_beli ='5939000' WHERE kode_barcode='T0080408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='6565000',harga_beli ='6565000' WHERE kode_barcode='T0080409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1576000',harga_beli ='1576000' WHERE kode_barcode='T0080420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1111000',harga_beli ='1111000' WHERE kode_barcode='T0080421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2020000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='T0080422' LIMIT 1;
UPDATE tm_group SET harga='2020000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','2020000','admin','2026-06-15 07:47:03');
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1632000',harga_beli ='1632000' WHERE kode_barcode='T0059358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1469000',harga_beli ='1469000' WHERE kode_barcode='T0068718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1938000',harga_beli ='1938000' WHERE kode_barcode='T0068717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='8262000',harga_beli ='8262000' WHERE kode_barcode='T0068455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4141500',harga_beli ='4141500' WHERE kode_barcode='T0067233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1142500',harga_beli ='1142500' WHERE kode_barcode='T0065947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5916000',harga_beli ='5916000' WHERE kode_barcode='T0065438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5834500',harga_beli ='5834500' WHERE kode_barcode='T0062956' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1040500',harga_beli ='1040500' WHERE kode_barcode='T0060831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='10139000',harga_beli ='10139000' WHERE kode_barcode='T0059474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5753000',harga_beli ='5753000' WHERE kode_barcode='T0059464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1224000',harga_beli ='1224000' WHERE kode_barcode='T0059393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1020000',harga_beli ='1020000' WHERE kode_barcode='T0068863' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1836000',harga_beli ='1836000' WHERE kode_barcode='T0059357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='12240000',harga_beli ='12240000' WHERE kode_barcode='T0059273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='24480000',harga_beli ='24480000' WHERE kode_barcode='T0057546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='20237000',harga_beli ='20237000' WHERE kode_barcode='T0057545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1979000',harga_beli ='1979000' WHERE kode_barcode='T0057060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1938000',harga_beli ='1938000' WHERE kode_barcode='T0056745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5426500',harga_beli ='5426500' WHERE kode_barcode='T0056246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='T0054785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='6018000',harga_beli ='6018000' WHERE kode_barcode='T0054299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='6120000',harga_beli ='6120000' WHERE kode_barcode='T0054298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='16381500',harga_beli ='16381500' WHERE kode_barcode='T0052702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='2856000',harga_beli ='2856000' WHERE kode_barcode='T0073758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1244500',harga_beli ='1244500' WHERE kode_barcode='T0078470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1734000',harga_beli ='1734000' WHERE kode_barcode='T0078469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1285500',harga_beli ='1285500' WHERE kode_barcode='T0078468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='T0078467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='23990500',harga_beli ='23990500' WHERE kode_barcode='T0076223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='T0076200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1387500',harga_beli ='1387500' WHERE kode_barcode='T0076198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1652500',harga_beli ='1652500' WHERE kode_barcode='T0076196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5488000',harga_beli ='5488000' WHERE kode_barcode='T0075796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1224000',harga_beli ='1224000' WHERE kode_barcode='T0074523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='20563500',harga_beli ='20563500' WHERE kode_barcode='T0073781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5814000',harga_beli ='5814000' WHERE kode_barcode='T0051681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1428000',harga_beli ='1428000' WHERE kode_barcode='T0073742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1469000',harga_beli ='1469000' WHERE kode_barcode='T0073741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='9996000',harga_beli ='9996000' WHERE kode_barcode='T0073702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5039000',harga_beli ='5039000' WHERE kode_barcode='T0072968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='6263000',harga_beli ='6263000' WHERE kode_barcode='T0072947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1428000',harga_beli ='1428000' WHERE kode_barcode='T0071669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1061000',harga_beli ='1061000' WHERE kode_barcode='T0070522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4957500',harga_beli ='4957500' WHERE kode_barcode='T0070487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1020000',harga_beli ='1020000' WHERE kode_barcode='T0070417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='3672000',harga_beli ='3672000' WHERE kode_barcode='T0068913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='30641000',harga_beli ='30641000' WHERE kode_barcode='T0034311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='12077000',harga_beli ='12077000' WHERE kode_barcode='T0041140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1571000',harga_beli ='1571000' WHERE kode_barcode='T0039590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='14504500',harga_beli ='14504500' WHERE kode_barcode='T0038298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1061000',harga_beli ='1061000' WHERE kode_barcode='T0037893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4100500',harga_beli ='4100500' WHERE kode_barcode='T0037699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='8425500',harga_beli ='8425500' WHERE kode_barcode='T0037627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='T0037454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='6038500',harga_beli ='6038500' WHERE kode_barcode='T0037228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='T0034737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1856500',harga_beli ='1856500' WHERE kode_barcode='T0034698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='51326500',harga_beli ='51326500' WHERE kode_barcode='T0034312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1734000',harga_beli ='1734000' WHERE kode_barcode='T0041492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5875500',harga_beli ='5875500' WHERE kode_barcode='T0033671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='10302000',harga_beli ='10302000' WHERE kode_barcode='T0033573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1020000',harga_beli ='1020000' WHERE kode_barcode='T0032937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='10139000',harga_beli ='10139000' WHERE kode_barcode='T0017016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4080000',harga_beli ='4080000' WHERE kode_barcode='T0014678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='T0012620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5977500',harga_beli ='5977500' WHERE kode_barcode='T0012557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='T0002494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1571000',harga_beli ='1571000' WHERE kode_barcode='T0002469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1591500',harga_beli ='1591500' WHERE kode_barcode='T0002468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='30314500',harga_beli ='30314500' WHERE kode_barcode='T0001415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='40943000',harga_beli ='40943000' WHERE kode_barcode='T0045326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5916000',harga_beli ='5916000' WHERE kode_barcode='T0050811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='6324000',harga_beli ='6324000' WHERE kode_barcode='T0050444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5712000',harga_beli ='5712000' WHERE kode_barcode='T0050008' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='3835500',harga_beli ='3835500' WHERE kode_barcode='T0049980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1836000',harga_beli ='1836000' WHERE kode_barcode='T0049970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='8282500',harga_beli ='8282500' WHERE kode_barcode='T0049654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1591500',harga_beli ='1591500' WHERE kode_barcode='T0049385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='979500',harga_beli ='979500' WHERE kode_barcode='T0047314' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='T0045758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='2387000',harga_beli ='2387000' WHERE kode_barcode='T0045357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1632000',harga_beli ='1632000' WHERE kode_barcode='T0000044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1061000',harga_beli ='1061000' WHERE kode_barcode='T0042918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1040500',harga_beli ='1040500' WHERE kode_barcode='T0042916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5732500',harga_beli ='5732500' WHERE kode_barcode='T0042838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1081500',harga_beli ='1081500' WHERE kode_barcode='T0042808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='5324500',harga_beli ='5324500' WHERE kode_barcode='T0042504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='8201000',harga_beli ='8201000' WHERE kode_barcode='T0042126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='T0042026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='T0041819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1754500',harga_beli ='1754500' WHERE kode_barcode='T0041814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='1591500',harga_beli ='1591500' WHERE kode_barcode='T0041810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='4080000',harga_beli ='4080000' WHERE kode_barcode='T0041557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2040000',harga_jual='10445000',harga_beli ='10445000' WHERE kode_barcode='00295403' LIMIT 1;
UPDATE tm_group SET harga='2040000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','2040000','admin','2026-06-15 07:47:19');
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='906500',harga_beli ='906500' WHERE kode_barcode='T0061867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3008000',harga_beli ='3008000' WHERE kode_barcode='T0066568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4182000',harga_beli ='4182000' WHERE kode_barcode='T0065968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4182000',harga_beli ='4182000' WHERE kode_barcode='T0065181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1339000',harga_beli ='1339000' WHERE kode_barcode='T0065158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='556500',harga_beli ='556500' WHERE kode_barcode='T0078241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2884000',harga_beli ='2884000' WHERE kode_barcode='T0062323' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3255000',harga_beli ='3255000' WHERE kode_barcode='T0062321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='906500',harga_beli ='906500' WHERE kode_barcode='T0061868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3873000',harga_beli ='3873000' WHERE kode_barcode='T0066570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='7334000',harga_beli ='7334000' WHERE kode_barcode='T0061257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1030000',harga_beli ='1030000' WHERE kode_barcode='T0060259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4347000',harga_beli ='4347000' WHERE kode_barcode='T0059473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1545000',harga_beli ='1545000' WHERE kode_barcode='T0059328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3152000',harga_beli ='3152000' WHERE kode_barcode='T0059327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2987000',harga_beli ='2987000' WHERE kode_barcode='T0058739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='6365500',harga_beli ='6365500' WHERE kode_barcode='T0055807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='11804000',harga_beli ='11804000' WHERE kode_barcode='T0052955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4244000',harga_beli ='4244000' WHERE kode_barcode='T0066774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3152000',harga_beli ='3152000' WHERE kode_barcode='T0067263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='T0068454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3873000',harga_beli ='3873000' WHERE kode_barcode='T0068910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4223000',harga_beli ='4223000' WHERE kode_barcode='T0069910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='T0069940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='T0069941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4202500',harga_beli ='4202500' WHERE kode_barcode='T0071213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3234500',harga_beli ='3234500' WHERE kode_barcode='T0071243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='6180000',harga_beli ='6180000' WHERE kode_barcode='T0073707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2081000',harga_beli ='2081000' WHERE kode_barcode='T0073708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1751000',harga_beli ='1751000' WHERE kode_barcode='T0073709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1978000',harga_beli ='1978000' WHERE kode_barcode='T0073711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='618000',harga_beli ='618000' WHERE kode_barcode='T0075783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='824000',harga_beli ='824000' WHERE kode_barcode='T0078461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='6283000',harga_beli ='6283000' WHERE kode_barcode='T0002699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1277500',harga_beli ='1277500' WHERE kode_barcode='T0027088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1566000',harga_beli ='1566000' WHERE kode_barcode='T0024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='T0024921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1463000',harga_beli ='1463000' WHERE kode_barcode='T0024478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='12360000',harga_beli ='12360000' WHERE kode_barcode='T0020109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1957000',harga_beli ='1957000' WHERE kode_barcode='T0017824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1236000',harga_beli ='1236000' WHERE kode_barcode='T0016447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1360000',harga_beli ='1360000' WHERE kode_barcode='T0011816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1463000',harga_beli ='1463000' WHERE kode_barcode='T0031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1257000',harga_beli ='1257000' WHERE kode_barcode='T0002646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='14317000',harga_beli ='14317000' WHERE kode_barcode='T0002534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1566000',harga_beli ='1566000' WHERE kode_barcode='T0001636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1360000',harga_beli ='1360000' WHERE kode_barcode='T0001633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1380500',harga_beli ='1380500' WHERE kode_barcode='T0001632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1545000',harga_beli ='1545000' WHERE kode_barcode='T0001631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2410500',harga_beli ='2410500' WHERE kode_barcode='T0001626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2472000',harga_beli ='2472000' WHERE kode_barcode='T0001324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1504000',harga_beli ='1504000' WHERE kode_barcode='T0031470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1277500',harga_beli ='1277500' WHERE kode_barcode='T0032927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='10506000',harga_beli ='10506000' WHERE kode_barcode='T0037976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='10815000',harga_beli ='10815000' WHERE kode_barcode='T0037977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='6345000',harga_beli ='6345000' WHERE kode_barcode='T0037980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='4326000',harga_beli ='4326000' WHERE kode_barcode='T0044770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1854000',harga_beli ='1854000' WHERE kode_barcode='T0048968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1030000',harga_beli ='1030000' WHERE kode_barcode='T0048969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='1030000',harga_beli ='1030000' WHERE kode_barcode='T0048970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2534000',harga_beli ='2534000' WHERE kode_barcode='T0049859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='T0049861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3749500',harga_beli ='3749500' WHERE kode_barcode='T0050814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3028500',harga_beli ='3028500' WHERE kode_barcode='T0050888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='31003000',harga_beli ='31003000' WHERE kode_barcode='T0051687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2060000',harga_jual='3049000',harga_beli ='3049000' WHERE kode_barcode='T0051842' LIMIT 1;
UPDATE tm_group SET harga='2060000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','2060000','admin','2026-06-15 07:47:45');
UPDATE tm_group SET harga='2080000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','2080000','admin','2026-06-15 07:48:01');
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2898000',harga_beli ='2898000' WHERE kode_barcode='T0044775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6720000',harga_beli ='6720000' WHERE kode_barcode='T0051841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5502000',harga_beli ='5502000' WHERE kode_barcode='T0051851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14847000',harga_beli ='14847000' WHERE kode_barcode='T0056780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7161000',harga_beli ='7161000' WHERE kode_barcode='T0056781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2373000',harga_beli ='2373000' WHERE kode_barcode='T0066772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='T0067265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12495000',harga_beli ='12495000' WHERE kode_barcode='T0067267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4956000',harga_beli ='4956000' WHERE kode_barcode='T0078274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='567000',harga_beli ='567000' WHERE kode_barcode='T0071238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6258000',harga_beli ='6258000' WHERE kode_barcode='T0073704' LIMIT 1;
UPDATE tm_group SET harga='2100000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','2100000','admin','2026-06-15 07:48:16');
UPDATE tm_barang SET harga_skrg ='2120000',harga_jual='6212000',harga_beli ='6212000' WHERE kode_barcode='T0036633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2120000',harga_jual='5385000',harga_beli ='5385000' WHERE kode_barcode='T0065165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2120000',harga_jual='5321500',harga_beli ='5321500' WHERE kode_barcode='T0065166' LIMIT 1;
UPDATE tm_group SET harga='2120000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','2120000','admin','2026-06-15 07:48:29');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-14' 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-260615-0001','D','2026-06-15','08:07:38','SYSTEM','SALDO AWAL','SALDO AWAL','0','10862811000','10862811000');
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-260615-0001','D','2026-06-15','08:07:38','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260615-0001','D','2026-06-15','08:07:38','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-260615-0001','D','2026-06-15','08:07:38','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-260615-0001','D','2026-06-15','08:07:38','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-260615-0001','D','2026-06-15','08:07:38','BCA','SALDO AWAL','SALDO AWAL','0','4510643888','4510643888');
UPDATE tp_system SET tgl_system='2026-06-15';
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 ('F226150859001','kasir','1',' MEH1 UB 34','TOKO','SMBK-H','H1E-ZDXI-24-T','KL ANAK GUCCI UB 34CM 8K ','','2.000','1','100.00','2230000','0','0','15000','2260000','0','0','0','2260000','LUS','T0078616','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXI-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='H1E-ZDXI-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226150859001','2026-06-15','2.000','2026-06-15','08:59:01','PLG0081107','2260000','2260000','0','2260000','2260000','kasir','2026-06-15 08:59:00','F22615085900');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150859001','2026-06-15','08:59:01','LUS','2260000','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-260615-0002','D','2026-06-15','08:59:01','kasir','PENJUALAN','F226150859001','10862811000','2260000','10865071000');
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 ('F226150925151','kasir','1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZDBC-44-T','CC BANGKOK SLEP VAR CM 12 8K ','','1.110','1','100.00','1215000','0','0','15000','1232000','0','5000','0','1237000','TIN','T0078925','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E1D-ZDBC-44-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 ('F226150925151','2026-06-15','1.110','2026-06-15','09:25:16','PLG0081108','1232000','1232000','5000','1237000','1237000','kasir','2026-06-15 09:25:15','F22615092515');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150925151','2026-06-15','09:25:16','TIN','1237000','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-260615-0003','D','2026-06-15','09:25:16','kasir','PENJUALAN','F226150925151','10865071000','1237000','10866308000');
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 ('F226150933371','kasir','1',' MEE2 X YT ','TOKO','SMBK-E','E2E-ZFXI-120-0','CC X MODEL MATA YT 14 8K ','','0.700','1','100.00','780000','0','0','15000','791000','0','0','0','791000','TIN','00408187','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXI-120-0' 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 ('F226150933371','2026-06-15','0.700','2026-06-15','09:33:37','PLG0081109','791000','791000','0','791000','0','kasir','2026-06-15 09:33:37','F22615093337');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150933371','2026-06-15','09:33:37','TIN','791000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260615-0001','2026-06-15','2026-06-15 09:33:37','PENJUALAN : F226150933371','0987654321','BCA','791000','791000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260615-0002','D','2026-06-15','09:33:37','BCA','PENJUALAN','F226150933371','4510643888','791000','4511434888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','IMROATUL');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150933371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150933371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150933371';
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 ('F226150945111','kasir','1',' MFE2F X CM','TOKO','SMBK-E','E2F-ZFXI-117-0','CC X MODEL MATA CM 12 8K ','OL','0.310','1','100.00','352000','0','0','15000','361000','0','5000','0','366000','TIN','00408184','E2F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZFXI-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2F-ZFXI-117-0' 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 ('F226150945111','2026-06-15','0.310','2026-06-15','09:45:11','PLG0081110','361000','361000','5000','366000','366000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945111','2026-06-15','09:45:11','TIN','366000','5000');
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-260615-0004','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945111','10866308000','366000','10866674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='366000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945111' 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 ('F226150945112','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZFXI-118-0','CC X MODEL MATA LG 14 8K ','OL','0.490','1','100.00','546000','0','0','15000','561000','0','5000','0','566000','TIN','00408185','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXI-118-0' 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 ('F226150945112','2026-06-15','0.490','2026-06-15','09:45:11','PLG0081111','561000','561000','5000','566000','566000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945112','2026-06-15','09:45:11','TIN','566000','5000');
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-260615-0005','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945112','10866674000','566000','10867240000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='566000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945112' 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 ('F226150945113','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZFXI-116-0','CC X MODEL MATA LG 8 8K ','OL','0.520','1','100.00','580000','0','0','15000','595000','0','5000','0','600000','TIN','00408183','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXI-116-0' 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 ('F226150945113','2026-06-15','0.520','2026-06-15','09:45:11','PLG0081112','595000','595000','5000','600000','600000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945113','2026-06-15','09:45:11','TIN','600000','5000');
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-260615-0006','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945113','10867240000','600000','10867840000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945113' 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 ('F226150945114','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZFXI-112-0','CC X SOLITAIRE MATA LG 10 8K ','OL','0.520','1','100.00','580000','0','0','15000','595000','0','5000','0','600000','TIN','00408179','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXI-112-0' 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 ('F226150945114','2026-06-15','0.520','2026-06-15','09:45:11','PLG0081113','595000','595000','5000','600000','600000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945114','2026-06-15','09:45:11','TIN','600000','5000');
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-260615-0007','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945114','10867840000','600000','10868440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945114' 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 ('F226150945115','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZFXI-115-0','CC X MODEL MATA LG 14 8K ','OL','0.530','1','100.00','591000','0','0','15000','607000','0','5000','0','612000','TIN','00408182','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXI-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXI-115-0' 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 ('F226150945115','2026-06-15','0.530','2026-06-15','09:45:11','PLG0081114','607000','607000','5000','612000','612000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945115','2026-06-15','09:45:11','TIN','612000','5000');
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-260615-0008','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945115','10868440000','612000','10869052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='612000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945115' 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 ('F226150945116','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-395-0','CC X MODEL MATA CM 12 8K ','OL','0.880','1','100.00','964000','0','0','15000','990000','0','5000','0','995000','TIN','00405613','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-395-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2D-ZEBH-395-0' 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 ('F226150945116','2026-06-15','0.880','2026-06-15','09:45:11','PLG0081115','990000','990000','5000','995000','995000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945116','2026-06-15','09:45:11','TIN','995000','5000');
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-260615-0009','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945116','10869052000','995000','10870047000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='995000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945116' 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 ('F226150945117','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZFXD-10-T','KL RANTAI HOLLOW UB 46 8K ','OL','1.010','1','100.00','1126000','0','0','15000','1151000','0','5000','0','1156000','TIN','T0080175','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='H1E-ZFXD-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226150945117','2026-06-15','1.010','2026-06-15','09:45:11','PLG0081116','1151000','1151000','5000','1156000','1156000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945117','2026-06-15','09:45:11','TIN','1156000','5000');
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-260615-0010','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945117','10870047000','1156000','10871203000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1156000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945117' 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 ('F226150945118','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZFXD-8-T','KL RANTAI HOLLOW UB 46 8K ','OL','1.020','1','100.00','1137000','0','0','15000','1163000','0','5000','0','1168000','TIN','T0080173','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-8-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='2026-06-15' AND kode_barang='H1E-ZFXD-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226150945118','2026-06-15','1.020','2026-06-15','09:45:11','PLG0081117','1163000','1163000','5000','1168000','1168000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945118','2026-06-15','09:45:11','TIN','1168000','5000');
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-260615-0011','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945118','10871203000','1168000','10872371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1168000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945118' 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 ('F226150945119','kasir',' 1',' MED1E X HW','TOKO','SMBK-D','D1E-ZEXI-61-0','LT X MODEL COIN DOLAR HW 8K ','OL','0.450','1','100.00','502000','0','0','15000','515000','0','5000','0','520000','TIN','00402882','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXI-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='D1E-ZEXI-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226150945119','2026-06-15','0.450','2026-06-15','09:45:11','PLG0081118','515000','515000','5000','520000','520000','kasir','2026-06-15 09:45:11','F22615094511');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150945119','2026-06-15','09:45:11','TIN','520000','5000');
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-260615-0012','D','2026-06-15','09:45:11','kasir','PENJUALAN','F226150945119','10872371000','520000','10872891000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150945119' 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 ('F226151013151','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZFXH-106-0','LT X MODEL MATA LG 8K ','OL','0.500','1','100.00','557000','0','0','15000','573000','0','5000','0','578000','LUS','00407967','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFXH-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='D2E-ZFXH-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226151013151','2026-06-15','0.500','2026-06-15','10:13:16','PLG0081119','573000','573000','5000','578000','578000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013151','2026-06-15','10:13:16','LUS','578000','5000');
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-260615-0013','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013151','10872891000','578000','10873469000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013151' 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 ('F226151013152','kasir',' 1',' MEE2E CM12','TOKO','SMBK-E','E2E-ZECX-30-T','CC MODEL SOLITAIRE MATA CM 12 8K ','OL','0.650','1','100.00','725000','0','0','15000','745000','0','5000','0','750000','LUS','T0080096','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZECX-30-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 ('F226151013152','2026-06-15','0.650','2026-06-15','10:13:16','PLG0081120','745000','745000','5000','750000','750000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013152','2026-06-15','10:13:16','LUS','750000','5000');
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-260615-0014','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013152','10873469000','750000','10874219000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='750000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013152' 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 ('F226151013153','kasir',' 1',' MEE2 X UB ','TOKO','SMBK-E','E2E-ZFXC-135-0','CC X MODEL MATA UB 18 8K ','OL','0.680','1','100.00','758000','0','0','15000','779000','0','5000','0','784000','LUS','00406678','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFXC-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2E-ZFXC-135-0' 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 ('F226151013153','2026-06-15','0.680','2026-06-15','10:13:16','PLG0081121','779000','779000','5000','784000','784000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013153','2026-06-15','10:13:16','LUS','784000','5000');
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-260615-0015','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013153','10874219000','784000','10875003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='784000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013153' 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 ('F226151013154','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZDBG-307-0','CC X LISTERING MATA CM 18 8K ','OL','0.770','1','100.00','859000','0','0','15000','882000','0','5000','0','887000','LUS','00401550','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBG-307-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='2026-06-15' AND kode_barang='E2E-ZDBG-307-0' 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 ('F226151013154','2026-06-15','0.770','2026-06-15','10:13:16','PLG0081122','882000','882000','5000','887000','887000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013154','2026-06-15','10:13:16','LUS','887000','5000');
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-260615-0016','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013154','10875003000','887000','10875890000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='887000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013154' 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 ('F226151013155','kasir',' 1',' MEA1E X BW','TOKO','SMBK-A','A1E-ZFXH-37-0','AT X ITALY SLEP VAR BW 8K ','OL','0.510','1','100.00','569000','0','0','15000','585000','0','5000','0','590000','LUS','00407898','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXH-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='A1E-ZFXH-37-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 ('F226151013155','2026-06-15','0.510','2026-06-15','10:13:16','PLG0081123','585000','585000','5000','590000','590000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013155','2026-06-15','10:13:16','LUS','590000','5000');
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-260615-0017','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013155','10875890000','590000','10876480000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013155' 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 ('F226151013156','kasir',' 1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFXE-30-T','CC MODEL SLEP CM 14 8K ','OL','1.020','1','100.00','1117000','0','0','15000','1143000','0','5000','0','1148000','LUS','T0080332','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-30-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='2026-06-15' AND kode_barang='E1D-ZFXE-30-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 ('F226151013156','2026-06-15','1.020','2026-06-15','10:13:16','PLG0081124','1143000','1143000','5000','1148000','1148000','kasir','2026-06-15 10:13:15','F22615101315');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151013156','2026-06-15','10:13:16','LUS','1148000','5000');
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-260615-0018','D','2026-06-15','10:13:16','kasir','PENJUALAN','F226151013156','10876480000','1148000','10877628000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1148000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151013156' 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 ('F226151034131','kasir','1',' TDE2 X HW1','TOKO','TBK-E','E2TD-ZEBB-18-T','CC X MODEL MATA SLEP HW 16 17K ','','1.400','1','100.00','2800000','0','0','15000','2856000','0','0','0','2856000','LUS','T0079781','E2TD','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZEBB-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2TD-ZEBB-18-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 ('F226151034131','2026-06-15','1.400','2026-06-15','10:34:14','PLG0081125','2856000','2856000','0','2856000','2856000','kasir','2026-06-15 10:34:13','F22615103413');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151034131','2026-06-15','10:34:14','LUS','2856000','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-260615-0019','D','2026-06-15','10:34:14','kasir','PENJUALAN','F226151034131','10877628000','2856000','10880484000');
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 ('F226151047331','kasir','1',' MEF3E X PM','TOKO','SMBK-F','F3E-ZFXC-190-0','GL X SANTA DAUN SERUT PM 8K ','OL','2.020','1','100.00','2252000','0','0','15000','2293000','0','10000','0','2303000','TIN','00406733','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-190-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='F3E-ZFXC-190-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 ('F226151047331','2026-06-15','2.020','2026-06-15','10:47:34','PLG0081126','2293000','2293000','10000','2303000','2303000','kasir','2026-06-15 10:47:33','F22615104733');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151047331','2026-06-15','10:47:34','TIN','2303000','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-260615-0020','D','2026-06-15','10:47:34','kasir','PENJUALAN','F226151047331','10880484000','2303000','10882787000');
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 ('F226151102561','kasir','1',' MFD1 LG ','TOKO','SMBK-D','D1F-ZEXF-48-T','LT SLOBOK MICKEY ARESO VAR LG 8K ','','0.320','1','100.00','363000','0','0','15000','368000','0','0','0','368000','RHM','T0079209','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXF-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='D1F-ZEXF-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226151102561','2026-06-15','0.320','2026-06-15','11:02:56','PLG0081127','368000','368000','0','368000','368000','kasir','2026-06-15 11:02:56','F22615110256');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151102561','2026-06-15','11:02:56','RHM','368000','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-260615-0021','D','2026-06-15','11:02:56','kasir','PENJUALAN','F226151102561','10882787000','368000','10883155000');
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 ('F226151109351','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZFXD-137-T','KL MILANO UB 40 8K ','','2.110','1','100.00','2353000','0','0','15000','2384000','0','0','0','2384000','LUS','T0080302','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-137-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='H1E-ZFXD-137-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226151109351','2026-06-15','2.110','2026-06-15','11:09:36','PLG0081128','2384000','2384000','0','2384000','2384000','kasir','2026-06-15 11:09:35','F22615110935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151109351','2026-06-15','11:09:36','LUS','2384000','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-260615-0022','D','2026-06-15','11:09:36','kasir','PENJUALAN','F226151109351','10883155000','2384000','10885539000');
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 ('F226151114441','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFXI-124-0','CC X MODEL MATA CM 16 8K ','','0.830','1','100.00','909000','0','0','15000','921000','0','0','0','921000','LUS','00408191','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXI-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E2D-ZFXI-124-0' 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 ('F226151114441','2026-06-15','0.830','2026-06-15','11:14:45','PLG0081129','921000','921000','0','921000','921000','kasir','2026-06-15 11:14:44','F22615111444');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151114441','2026-06-15','11:14:45','LUS','921000','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-260615-0023','D','2026-06-15','11:14:45','kasir','PENJUALAN','F226151114441','10885539000','921000','10886460000');
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 ('F226151115331','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZFXC-192-0','GL X SANTA DAUN SERUT UB 8K ','','1.710','1','100.00','1907000','0','0','15000','1932000','0','0','0','1932000','LUS','00406735','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-192-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='F3E-ZFXC-192-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 ('F226151115331','2026-06-15','1.710','2026-06-15','11:15:33','PLG0081130','1932000','1932000','0','1932000','1932000','kasir','2026-06-15 11:15:33','F22615111533');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151115331','2026-06-15','11:15:33','LUS','1932000','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-260615-0024','D','2026-06-15','11:15:33','kasir','PENJUALAN','F226151115331','10886460000','1932000','10888392000');
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 ('F226151118001','kasir','1',' MDE1 UB 10','TOKO','SMBK-E','E1D-ZEAI-73-0','CC SPIRAL BUNGA SLEP UB 10 8K ','OL','1.130','1','100.00','1237000','0','0','15000','1265000','0','6000','0','1271000','TIN','00404134','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAI-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E1D-ZEAI-73-0' 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 ('F226151118001','2026-06-15','1.130','2026-06-15','11:18:01','PLG0081131','1265000','1265000','6000','1271000','1271000','kasir','2026-06-15 11:18:00','F22615111800');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151118001','2026-06-15','11:18:01','TIN','1271000','6000');
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-260615-0025','D','2026-06-15','11:18:01','kasir','PENJUALAN','F226151118001','10888392000','1271000','10889663000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1271000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151118001' 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 ('F226151118002','kasir',' 1',' MDE1 X UB ','TOKO','SMBK-E','E1D-ZEBE-110-0','CC X MODEL DUBAI UB 18 8K ','OL','0.820','1','100.00','898000','0','0','15000','924000','0','5000','0','929000','TIN','00404809','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBE-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='E1D-ZEBE-110-0' 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 ('F226151118002','2026-06-15','0.820','2026-06-15','11:18:01','PLG0081132','924000','924000','5000','929000','929000','kasir','2026-06-15 11:18:00','F22615111800');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151118002','2026-06-15','11:18:01','TIN','929000','5000');
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-260615-0026','D','2026-06-15','11:18:01','kasir','PENJUALAN','F226151118002','10889663000','929000','10890592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='929000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151118002' 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 ('F226151205021','kasir','1',' MEF2 X PM ','TOKO','SMBK-F','F2E-ZFXH-16-0','GL X PIPA MATA PM 56 8K ','OL','3.000','1','100.00','3345000','0','0','15000','3375000','0','15000','0','3390000','TIN','00407877','F2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFXH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='F2E-ZFXH-16-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 ('F226151205021','2026-06-15','3.000','2026-06-15','12:05:02','PLG0081133','3375000','3375000','15000','3390000','3390000','kasir','2026-06-15 12:05:02','F22615120502');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151205021','2026-06-15','12:05:02','TIN','3390000','15000');
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-260615-0027','D','2026-06-15','12:05:02','kasir','PENJUALAN','F226151205021','10890592000','3390000','10893982000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151205021' 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 ('F226151205022','kasir',' 1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZDAH-20-0','LT X SLOBOK HURUF BALOK BG E 8K ','OL','0.630','1','100.00','715000','0','0','15000','731000','0','5000','0','736000','TIN','00399721','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAH-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='D1F-ZDAH-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226151205022','2026-06-15','0.630','2026-06-15','12:05:02','PLG0081134','731000','731000','5000','736000','736000','kasir','2026-06-15 12:05:02','F22615120502');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151205022','2026-06-15','12:05:02','TIN','736000','5000');
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-260615-0028','D','2026-06-15','12:05:02','kasir','PENJUALAN','F226151205022','10893982000','736000','10894718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='736000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151205022' 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 ('F226151205023','kasir',' 1',' MDD1D X CM','TOKO','SMBK-D','D1D-ZAAC-43-0','LT X MODEL DAUN SLEP CM 8K ','OL','1.150','1','100.00','1259000','0','0','15000','1282000','0','6000','0','1288000','TIN','00384950','D1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZAAC-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='D1D-ZAAC-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226151205023','2026-06-15','1.150','2026-06-15','12:05:02','PLG0081135','1282000','1282000','6000','1288000','1288000','kasir','2026-06-15 12:05:02','F22615120502');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151205023','2026-06-15','12:05:02','TIN','1288000','6000');
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-260615-0029','D','2026-06-15','12:05:02','kasir','PENJUALAN','F226151205023','10894718000','1288000','10896006000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1288000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151205023' 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 ('F226151224351','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFXD-13-T','KL SANTA KH 42 8K ','OLS CP0PU','1.550','1','100.00','1728000','0','0','15000','1767000','0','149000','0','1916000','TIN','T0080178','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='H1E-ZFXD-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226151224351','2026-06-15','1.550','2026-06-15','12:24:36','PLG0081136','1767000','1767000','149000','1916000','1916000','kasir','2026-06-15 12:24:35','F22615122435');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151224351','2026-06-15','12:24:36','TIN','1916000','149000');
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-260615-0030','D','2026-06-15','12:24:36','kasir','PENJUALAN','F226151224351','10896006000','1916000','10897922000');
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 ('F226151238171','kasir','1',' MEH1 UB 46','TOKO','SMBK-H','H1E-ZDCX-42-T','KL NORY UB 46CM 8K ','OL','0.950','1','100.00','1059000','0','0','15000','1083000','0','5000','0','1088000','TIN','T0079111','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDCX-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='H1E-ZDCX-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226151238171','2026-06-15','0.950','2026-06-15','12:38:18','PLG0081137','1083000','1083000','5000','1088000','0','kasir','2026-06-15 12:38:17','F22615123817');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226151238171','2026-06-15','12:38:18','TIN','1088000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260615-0002','2026-06-15','2026-06-15 12:38:17','PENJUALAN : F226151238171','0987654321','BCA','1088000','1088000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260615-0003','D','2026-06-15','12:38:18','BCA','PENJUALAN','F226151238171','4511434888','1088000','4512522888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','AFIYATI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151238171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151238171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151238171';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005449','X-00005449','AT X KLIP ARESO UB','GR','---','A1F','BELI','BELI001','500000','2026-06-15','0.620','1','kasir','2026-06-15 12:50:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00005449','X-00005449');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260615-0001','F224101053411','TIN','1','BELI','BELI001','A1F', 'X-00005449', 'AT X KLIP ARESO UB','0.670','0.620','100.00','337000','500000','806452','1135000','1','500000','500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260615-0001','2026-06-15','2026-06-15','12:50:30','TIN','---','0.620','500000','500000','500000','500000','500000','kasir','2026-06-15 12:50:31','FB-260615-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260615-0001','DITA','JL BRIGJEN KATAMSO 53A','','','085708534430','kasir','2026-06-15 12:50:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-15' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260615-0031','K','2026-06-15','12:50:30','kasir','PEMBELIAN UMUM','FB-260615-0001','10897922000','500000','10897422000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005450','X-00005450','GL X OVAL C SLEP GELOMBANG YT 54 8K','GR','---','F1E','BELI','BELI001','3024000','2026-06-15','3.000','1','kasir','2026-06-15 12:50:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005450','X-00005450');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260615-0002','F226111109451','RHM','1','BELI','BELI001','F1E', 'X-00005450', 'GL X OVAL C SLEP GELOMBANG YT 54 8K','3.000','3.000','100.00','3360000','3024000','1008000','1115000','1','3024000','3024000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260615-0002','2026-06-15','2026-06-15','12:50:47','RHM','---','3.000','3024000','3024000','3024000','3024000','3024000','kasir','2026-06-15 12:50:48','FB-260615-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260615-0002','ADIB SUBAIRI','KAB. MADIUN','','','','kasir','2026-06-15 12:50:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-15' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260615-0032','K','2026-06-15','12:50:47','kasir','PEMBELIAN UMUM','FB-260615-0002','10897422000','3024000','10894398000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150859001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150859001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150859001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150925151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150925151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150925151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945113' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945113' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945113';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945114' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945114' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945114';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945115' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945115' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945115';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945116' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945116' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945116';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945117' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945117' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945117';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945118' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945118' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945118';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945119' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150945119' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150945119';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013153' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013153' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013153';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013154' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013154' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013154';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013155' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013155' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013155';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013156' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151013156' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151013156';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151034131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151034131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151034131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151047331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151047331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151047331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151102561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151102561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151102561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151109351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151109351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151109351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151114441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151114441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151114441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151115331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151115331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151115331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151118001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151118001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151118001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151118002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151118002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151118002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151205021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151205022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151205023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151205023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151224351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151224351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151224351';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260615-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260615-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260615-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260615-0002';
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 ('F226150116231','kasir','1',' MEF1 X PM ','TOKO','SMBK-F','F1E-ZAAC-119-0','GL X BANGKOK HOLLOW LASER PM 58 8K ','OL','2.980','1','100.00','3323000','0','0','15000','3352000','0','15000','0','3367000','TIN','00385026','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAC-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='F1E-ZAAC-119-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 ('F226150116231','2026-06-15','2.980','2026-06-15','13:16:24','PLG0081138','3352000','3352000','15000','3367000','3367000','kasir','2026-06-15 13:16:23','F22615011623');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150116231','2026-06-15','13:16:24','TIN','3367000','15000');
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-260615-0033','D','2026-06-15','13:16:24','kasir','PENJUALAN','F226150116231','10894398000','3367000','10897765000');
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 ('F226150117131','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZFXD-93-T','GL OVAL C SLEP UB 56 8K ','OL','2.210','1','100.00','2464000','0','0','15000','2486000','0','11000','0','2497000','TIN','T0080258','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-06-15' AND kode_barang='F1E-ZFXD-93-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 ('F226150117131','2026-06-15','2.210','2026-06-15','13:17:14','PLG0081139','2486000','2486000','11000','2497000','2497000','kasir','2026-06-15 13:17:13','F22615011713');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-15','F226150117131','2026-06-15','13:17:14','TIN','2497000','11000');
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-260615-0034','D','2026-06-15','13:17:14','kasir','PENJUALAN','F226150117131','10897765000','2497000','10900262000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150116231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150116231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150116231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150117131';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-15';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-15' 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-260616-0001','D','2026-06-16','14:04:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','10900262000','10900262000');
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-260616-0001','D','2026-06-16','14:04:14','BCA','SALDO AWAL','SALDO AWAL','0','4512522888','4512522888');
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-260616-0001','D','2026-06-16','14:04:14','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-260616-0001','D','2026-06-16','14:04:14','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-260616-0001','D','2026-06-16','14:04:14','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-260616-0001','D','2026-06-16','14:04:14','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-06-16';