INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-07 ','08:08:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','11:17:35');
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,potong_rp,keterangan) VALUES ('FJ-251007-0001','kasir','1',' DP-01100T ','TOKO','TFPSN','PSPLT-YIBE-35-0','CINCIN PALADIUM ','','2.040','1','6.00','269000','0','0','16700','1260000','0','0','0','1260000','FIR','00038922','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBE-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PSPLT-YIBE-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0001','2025-10-07','2.040','2025-10-07','11:18:35','PLG0006837','1260000','1260000','0','1260000','572500','kasir','2025-10-07 11:18:35','FJ-251007-0001','DP-01100','687500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0001','2025-10-07','11:18:35','FIR','1260000','0');
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-251007-0002','D','2025-10-07','11:18:35','kasir','PENJUALAN','FJ-251007-0001','86600','572500','659100','OPEN');
UPDATE tt_jual_head SET dibayar_rp='572500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251007-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0001';
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7373000',harga_beli ='7373000' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6658500',harga_beli ='6658500' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7303500',harga_beli ='7303500' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4933000',harga_beli ='4933000' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7913500',harga_beli ='7913500' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7756500',harga_beli ='7756500' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6275000',harga_beli ='6275000' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5351500',harga_beli ='5351500' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10441000',harga_beli ='10441000' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10284000',harga_beli ='10284000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4863000',harga_beli ='4863000' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5020000',harga_beli ='5020000' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2562500',harga_beli ='2562500' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2527500',harga_beli ='2527500' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10650000',harga_beli ='10650000' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='41170000',harga_beli ='41170000' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3573500',harga_beli ='3573500' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6972000',harga_beli ='6972000' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10563000',harga_beli ='10563000' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7276500',harga_beli ='7276500' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5386000',harga_beli ='5386000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16140500',harga_beli ='16140500' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5891500',harga_beli ='5891500' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5961500',harga_beli ='5961500' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4793500',harga_beli ='4793500' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2336000',harga_beli ='2336000' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7756500',harga_beli ='7756500' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8157500',harga_beli ='8157500' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11347000',harga_beli ='11347000' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4619000',harga_beli ='4619000' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5037500',harga_beli ='5037500' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6262500',harga_beli ='6262500' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3538500',harga_beli ='3538500' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4218500',harga_beli ='4218500' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3312000',harga_beli ='3312000' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='00018927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3556000',harga_beli ='3556000' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8645500',harga_beli ='8645500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3259500',harga_beli ='3259500' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6066000',harga_beli ='6066000' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4584500',harga_beli ='4584500' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6083500',harga_beli ='6083500' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7495000',harga_beli ='7495000' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3817500',harga_beli ='3817500' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5456000',harga_beli ='5456000' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5212000',harga_beli ='5212000' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7077000',harga_beli ='7077000' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5525500',harga_beli ='5525500' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8192500',harga_beli ='8192500' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3469000',harga_beli ='3469000' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4985500',harga_beli ='4985500' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6205500',harga_beli ='6205500' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6048500',harga_beli ='6048500' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5543000',harga_beli ='5543000' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6623500',harga_beli ='6623500' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5822000',harga_beli ='5822000' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4793500',harga_beli ='4793500' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8244500',harga_beli ='8244500' WHERE kode_barcode='00020156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5647500',harga_beli ='5647500' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6902500',harga_beli ='6902500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9395000',harga_beli ='9395000' WHERE kode_barcode='00020174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5002500',harga_beli ='5002500' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5107500',harga_beli ='5107500' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8576000',harga_beli ='8576000' WHERE kode_barcode='00020190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6920000',harga_beli ='6920000' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5072500',harga_beli ='5072500' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='40131000',harga_beli ='40131000' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6083500',harga_beli ='6083500' WHERE kode_barcode='00020244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5543000',harga_beli ='5543000' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6048500',harga_beli ='6048500' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4148500',harga_beli ='4148500' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4950500',harga_beli ='4950500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4567000',harga_beli ='4567000' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4671500',harga_beli ='4671500' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6693500',harga_beli ='6693500' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7547500',harga_beli ='7547500' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5508000',harga_beli ='5508000' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7791500',harga_beli ='7791500' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4520500',harga_beli ='4520500' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3638500',harga_beli ='3638500' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='20947500',harga_beli ='20947500' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11598500',harga_beli ='11598500' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8335000',harga_beli ='8335000' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3352000',harga_beli ='3352000' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9592000',harga_beli ='9592000' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7144500',harga_beli ='7144500' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5351500',harga_beli ='5351500' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7321000',harga_beli ='7321000' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5682500',harga_beli ='5682500' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7547500',harga_beli ='7547500' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4689000',harga_beli ='4689000' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8192500',harga_beli ='8192500' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6780500',harga_beli ='6780500' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13561000',harga_beli ='13561000' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9691500',harga_beli ='9691500' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10719500',harga_beli ='10719500' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3550500',harga_beli ='3550500' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3550500',harga_beli ='3550500' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4145500',harga_beli ='4145500' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12706500',harga_beli ='12706500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9691500',harga_beli ='9691500' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3068000',harga_beli ='3068000' WHERE kode_barcode='00021950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4253000',harga_beli ='4253000' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5177000',harga_beli ='5177000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4793500',harga_beli ='4793500' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4549500',harga_beli ='4549500' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5787000',harga_beli ='5787000' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5072500',harga_beli ='5072500' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6536500',harga_beli ='6536500' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4671500',harga_beli ='4671500' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5351500',harga_beli ='5351500' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6519000',harga_beli ='6519000' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5055000',harga_beli ='5055000' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4776000',harga_beli ='4776000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4724000',harga_beli ='4724000' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9064000',harga_beli ='9064000' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6042000',harga_beli ='6042000' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7916000',harga_beli ='7916000' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8644000',harga_beli ='8644000' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6262500',harga_beli ='6262500' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6218500',harga_beli ='6218500' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8907000',harga_beli ='8907000' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11642500',harga_beli ='11642500' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6397000',harga_beli ='6397000' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6240500',harga_beli ='6240500' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4392500',harga_beli ='4392500' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4724000',harga_beli ='4724000' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7129000',harga_beli ='7129000' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16229000',harga_beli ='16229000' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9430000',harga_beli ='9430000' WHERE kode_barcode='00022659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5005500',harga_beli ='5005500' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6284500',harga_beli ='6284500' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4602000',harga_beli ='4602000' WHERE kode_barcode='00022763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6725500',harga_beli ='6725500' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10121000',harga_beli ='10121000' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9305500',harga_beli ='9305500' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6152000',harga_beli ='6152000' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8269000',harga_beli ='8269000' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4410000',harga_beli ='4410000' WHERE kode_barcode='00022822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7872000',harga_beli ='7872000' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6130000',harga_beli ='6130000' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3294500',harga_beli ='3294500' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6310000',harga_beli ='6310000' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7982500',harga_beli ='7982500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4392500',harga_beli ='4392500' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8262000',harga_beli ='8262000' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5647500',harga_beli ='5647500' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6813500',harga_beli ='6813500' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9465000',harga_beli ='9465000' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='38674500',harga_beli ='38674500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19791500',harga_beli ='19791500' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3922000',harga_beli ='3922000' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5194500',harga_beli ='5194500' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6188000',harga_beli ='6188000' WHERE kode_barcode='00023573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8837500',harga_beli ='8837500' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5602500',harga_beli ='5602500' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6118000',harga_beli ='6118000' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8782000',harga_beli ='8782000' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8739000',harga_beli ='8739000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6251500',harga_beli ='6251500' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6792000',harga_beli ='6792000' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11096500',harga_beli ='11096500' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7246500',harga_beli ='7246500' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8825500',harga_beli ='8825500' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6273000',harga_beli ='6273000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9820500',harga_beli ='9820500' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9171500',harga_beli ='9171500' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7311000',harga_beli ='7311000' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9193000',harga_beli ='9193000' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5559000',harga_beli ='5559000' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4741000',harga_beli ='4741000' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4326000',harga_beli ='4326000' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11783000',harga_beli ='11783000' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5961500',harga_beli ='5961500' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2649500',harga_beli ='2649500' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4619000',harga_beli ='4619000' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6310000',harga_beli ='6310000' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7477500',harga_beli ='7477500' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7477500',harga_beli ='7477500' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15574000',harga_beli ='15574000' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8506000',harga_beli ='8506000' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10555500',harga_beli ='10555500' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3643000',harga_beli ='3643000' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9674000',harga_beli ='9674000' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3893500',harga_beli ='3893500' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5142000',harga_beli ='5142000' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5647500',harga_beli ='5647500' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5473500',harga_beli ='5473500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4758500',harga_beli ='4758500' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5343000',harga_beli ='5343000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5578000',harga_beli ='5578000' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2702000',harga_beli ='2702000' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6920000',harga_beli ='6920000' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7657500',harga_beli ='7657500' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4689000',harga_beli ='4689000' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7913500',harga_beli ='7913500' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6397000',harga_beli ='6397000' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6153000',harga_beli ='6153000' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8140000',harga_beli ='8140000' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4689000',harga_beli ='4689000' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7484500',harga_beli ='7484500' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4567000',harga_beli ='4567000' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6571500',harga_beli ='6571500' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3538500',harga_beli ='3538500' WHERE kode_barcode='00024082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3699000',harga_beli ='3699000' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6711000',harga_beli ='6711000' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6066000',harga_beli ='6066000' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6989500',harga_beli ='6989500' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5403500',harga_beli ='5403500' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5316500',harga_beli ='5316500' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10022500',harga_beli ='10022500' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3869500',harga_beli ='3869500' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5456000',harga_beli ='5456000' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6275000',harga_beli ='6275000' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6693500',harga_beli ='6693500' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12706500',harga_beli ='12706500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16175500',harga_beli ='16175500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13865000',harga_beli ='13865000' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7268500',harga_beli ='7268500' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00026882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4846000',harga_beli ='4846000' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2771500',harga_beli ='2771500' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4950500',harga_beli ='4950500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8576000',harga_beli ='8576000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4793500',harga_beli ='4793500' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9604000',harga_beli ='9604000' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5020000',harga_beli ='5020000' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4462500',harga_beli ='4462500' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15129500',harga_beli ='15129500' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4061500',harga_beli ='4061500' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4584500',harga_beli ='4584500' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3915500',harga_beli ='3915500' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11364500',harga_beli ='11364500' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5775500',harga_beli ='5775500' WHERE kode_barcode='00027620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00027759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1848000',harga_beli ='1848000' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5438500',harga_beli ='5438500' WHERE kode_barcode='00027901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7164000',harga_beli ='7164000' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5797000',harga_beli ='5797000' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7321000',harga_beli ='7321000' WHERE kode_barcode='00028061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4357500',harga_beli ='4357500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10528000',harga_beli ='10528000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10404500',harga_beli ='10404500' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7095000',harga_beli ='7095000' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9517000',harga_beli ='9517000' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3158500',harga_beli ='3158500' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6833000',harga_beli ='6833000' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5769500',harga_beli ='5769500' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4828500',harga_beli ='4828500' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8155000',harga_beli ='8155000' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3807000',harga_beli ='3807000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8820000',harga_beli ='8820000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4759000',harga_beli ='4759000' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11334500',harga_beli ='11334500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3201500',harga_beli ='3201500' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3288000',harga_beli ='3288000' WHERE kode_barcode='00030711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3244500',harga_beli ='3244500' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3180000',harga_beli ='3180000' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3893500',harga_beli ='3893500' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3785500',harga_beli ='3785500' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3526000',harga_beli ='3526000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5559000',harga_beli ='5559000' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4096500',harga_beli ='4096500' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1830500',harga_beli ='1830500' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1813000',harga_beli ='1813000' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2911000',harga_beli ='2911000' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3207500',harga_beli ='3207500' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3172500',harga_beli ='3172500' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14432500',harga_beli ='14432500' WHERE kode_barcode='00031073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='00031074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5246500',harga_beli ='5246500' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7338500',harga_beli ='7338500' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5543000',harga_beli ='5543000' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2789000',harga_beli ='2789000' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7592500',harga_beli ='7592500' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='18755000',harga_beli ='18755000' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='17343000',harga_beli ='17343000' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6031000',harga_beli ='6031000' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6705500',harga_beli ='6705500' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3451500',harga_beli ='3451500' WHERE kode_barcode='00031185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5948500',harga_beli ='5948500' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10880000',harga_beli ='10880000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5126500',harga_beli ='5126500' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='30066000',harga_beli ='30066000' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15898500',harga_beli ='15898500' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5264000',harga_beli ='5264000' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6850500',harga_beli ='6850500' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6711000',harga_beli ='6711000' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3974500',harga_beli ='3974500' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4584500',harga_beli ='4584500' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4898000',harga_beli ='4898000' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5979000',harga_beli ='5979000' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4236000',harga_beli ='4236000' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5665000',harga_beli ='5665000' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4079000',harga_beli ='4079000' WHERE kode_barcode='00031285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3137500',harga_beli ='3137500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5769500',harga_beli ='5769500' WHERE kode_barcode='00031332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5769500',harga_beli ='5769500' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6484000',harga_beli ='6484000' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3451500',harga_beli ='3451500' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5177000',harga_beli ='5177000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4776000',harga_beli ='4776000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3695500',harga_beli ='3695500' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3678000',harga_beli ='3678000' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2440500',harga_beli ='2440500' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6100500',harga_beli ='6100500' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4375000',harga_beli ='4375000' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6327500',harga_beli ='6327500' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5246500',harga_beli ='5246500' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5787000',harga_beli ='5787000' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00031400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7425500',harga_beli ='7425500' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5682500',harga_beli ='5682500' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4584500',harga_beli ='4584500' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4567000',harga_beli ='4567000' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5804500',harga_beli ='5804500' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5316500',harga_beli ='5316500' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6484000',harga_beli ='6484000' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4724000',harga_beli ='4724000' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6833000',harga_beli ='6833000' WHERE kode_barcode='00031415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4671500',harga_beli ='4671500' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4636500',harga_beli ='4636500' WHERE kode_barcode='00031453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6850500',harga_beli ='6850500' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5194500',harga_beli ='5194500' WHERE kode_barcode='00031455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7181500',harga_beli ='7181500' WHERE kode_barcode='00031457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7913500',harga_beli ='7913500' WHERE kode_barcode='00031459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6240000',harga_beli ='6240000' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='00031477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7570500',harga_beli ='7570500' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6035000',harga_beli ='6035000' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4863000',harga_beli ='4863000' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4375000',harga_beli ='4375000' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5926500',harga_beli ='5926500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5734500',harga_beli ='5734500' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7129000',harga_beli ='7129000' WHERE kode_barcode='00031503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5717500',harga_beli ='5717500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4323000',harga_beli ='4323000' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00031515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5645500',harga_beli ='5645500' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3850500',harga_beli ='3850500' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1514500',harga_beli ='1514500' WHERE kode_barcode='00031518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6121500',harga_beli ='6121500' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5364500',harga_beli ='5364500' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8133000',harga_beli ='8133000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2614500',harga_beli ='2614500' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2597500',harga_beli ='2597500' WHERE kode_barcode='00031534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12870000',harga_beli ='12870000' WHERE kode_barcode='00031558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4261500',harga_beli ='4261500' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1514500',harga_beli ='1514500' WHERE kode_barcode='00031564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5516000',harga_beli ='5516000' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4780500',harga_beli ='4780500' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3591000',harga_beli ='3591000' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5543000',harga_beli ='5543000' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3381500',harga_beli ='3381500' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6532500',harga_beli ='6532500' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2893500',harga_beli ='2893500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3573500',harga_beli ='3573500' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5438500',harga_beli ='5438500' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3115000',harga_beli ='3115000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2855500',harga_beli ='2855500' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8933500',harga_beli ='8933500' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8035500',harga_beli ='8035500' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00031618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4759000',harga_beli ='4759000' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3242500',harga_beli ='3242500' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3312000',harga_beli ='3312000' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15228000',harga_beli ='15228000' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2617500',harga_beli ='2617500' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4462500',harga_beli ='4462500' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6749000',harga_beli ='6749000' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5595500',harga_beli ='5595500' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14554500',harga_beli ='14554500' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2928500',harga_beli ='2928500' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4846000',harga_beli ='4846000' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5040000',harga_beli ='5040000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7570500',harga_beli ='7570500' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2754000',harga_beli ='2754000' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6878500',harga_beli ='6878500' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6100500',harga_beli ='6100500' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3381500',harga_beli ='3381500' WHERE kode_barcode='00031826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2206500',harga_beli ='2206500' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3294500',harga_beli ='3294500' WHERE kode_barcode='00031855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3730500',harga_beli ='3730500' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5667500',harga_beli ='5667500' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8847000',harga_beli ='8847000' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6432000',harga_beli ='6432000' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6223000',harga_beli ='6223000' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5926500',harga_beli ='5926500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3869500',harga_beli ='3869500' WHERE kode_barcode='00031913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='18685000',harga_beli ='18685000' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2702000',harga_beli ='2702000' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14850500',harga_beli ='14850500' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5682500',harga_beli ='5682500' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2301000',harga_beli ='2301000' WHERE kode_barcode='00032198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2196500',harga_beli ='2196500' WHERE kode_barcode='00032209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='00032211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3242500',harga_beli ='3242500' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1882500',harga_beli ='1882500' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='21526500',harga_beli ='21526500' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14763500',harga_beli ='14763500' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2318500',harga_beli ='2318500' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3922000',harga_beli ='3922000' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1830500',harga_beli ='1830500' WHERE kode_barcode='00032365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5334000',harga_beli ='5334000' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2667000',harga_beli ='2667000' WHERE kode_barcode='00032372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4828500',harga_beli ='4828500' WHERE kode_barcode='00032373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14327500',harga_beli ='14327500' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3353000',harga_beli ='3353000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1935000',harga_beli ='1935000' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2946000',harga_beli ='2946000' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8663000',harga_beli ='8663000' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2649500',harga_beli ='2649500' WHERE kode_barcode='00032479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6902500',harga_beli ='6902500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9900500',harga_beli ='9900500' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5321500',harga_beli ='5321500' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12091500',harga_beli ='12091500' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6749000',harga_beli ='6749000' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6273000',harga_beli ='6273000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='25761500',harga_beli ='25761500' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='00032602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3172500',harga_beli ='3172500' WHERE kode_barcode='00032648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10022500',harga_beli ='10022500' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6792000',harga_beli ='6792000' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='00032668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8279500',harga_beli ='8279500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14103000',harga_beli ='14103000' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4811000',harga_beli ='4811000' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2266000',harga_beli ='2266000' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2318500',harga_beli ='2318500' WHERE kode_barcode='00033263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2126500',harga_beli ='2126500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6749000',harga_beli ='6749000' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1935000',harga_beli ='1935000' WHERE kode_barcode='00033347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19103500',harga_beli ='19103500' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4357500',harga_beli ='4357500' WHERE kode_barcode='00033537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3434000',harga_beli ='3434000' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2981000',harga_beli ='2981000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1621500',harga_beli ='1621500' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4445000',harga_beli ='4445000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3381500',harga_beli ='3381500' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3312000',harga_beli ='3312000' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='20236500',harga_beli ='20236500' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13238000',harga_beli ='13238000' WHERE kode_barcode='00034319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2614500',harga_beli ='2614500' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2614500',harga_beli ='2614500' WHERE kode_barcode='00034343' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2737000',harga_beli ='2737000' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4741000',harga_beli ='4741000' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1917500',harga_beli ='1917500' WHERE kode_barcode='00034351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7199000',harga_beli ='7199000' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2684500',harga_beli ='2684500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4410000',harga_beli ='4410000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3904500',harga_beli ='3904500' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='00034365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1935000',harga_beli ='1935000' WHERE kode_barcode='00034368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1778000',harga_beli ='1778000' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1935000',harga_beli ='1935000' WHERE kode_barcode='00034370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2057000',harga_beli ='2057000' WHERE kode_barcode='00034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3782500',harga_beli ='3782500' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2754000',harga_beli ='2754000' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2719500',harga_beli ='2719500' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8122500',harga_beli ='8122500' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10510500',harga_beli ='10510500' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3764000',harga_beli ='3764000' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5278000',harga_beli ='5278000' WHERE kode_barcode='00034679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1760500',harga_beli ='1760500' WHERE kode_barcode='00034780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2074500',harga_beli ='2074500' WHERE kode_barcode='00034781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3439500',harga_beli ='3439500' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2423000',harga_beli ='2423000' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6484000',harga_beli ='6484000' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3155000',harga_beli ='3155000' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9586500',harga_beli ='9586500' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5229000',harga_beli ='5229000' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='994000',harga_beli ='994000' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1011000',harga_beli ='1011000' WHERE kode_barcode='00036006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9171500',harga_beli ='9171500' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='802000',harga_beli ='802000' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='784500',harga_beli ='784500' WHERE kode_barcode='00036244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='732500',harga_beli ='732500' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2789000',harga_beli ='2789000' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00036809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00036823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00036824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4114000',harga_beli ='4114000' WHERE kode_barcode='00036825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00036826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00036827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2266000',harga_beli ='2266000' WHERE kode_barcode='00036828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00036830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00036831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00036832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1882000',harga_beli ='1882000' WHERE kode_barcode='00036947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='00036993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3643000',harga_beli ='3643000' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5246500',harga_beli ='5246500' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5700000',harga_beli ='5700000' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3677500',harga_beli ='3677500' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4776000',harga_beli ='4776000' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2740500',harga_beli ='2740500' WHERE kode_barcode='00038609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4584500',harga_beli ='4584500' WHERE kode_barcode='00038671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2562500',harga_beli ='2562500' WHERE kode_barcode='00038672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2231500',harga_beli ='2231500' WHERE kode_barcode='00038673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2440500',harga_beli ='2440500' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00038716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5733000',harga_beli ='5733000' WHERE kode_barcode='00038720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8053000',harga_beli ='8053000' WHERE kode_barcode='00038819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3381500',harga_beli ='3381500' WHERE kode_barcode='00038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3136500',harga_beli ='3136500' WHERE kode_barcode='00038862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6867500',harga_beli ='6867500' WHERE kode_barcode='00038959' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2100000',harga_jual='3922000',harga_beli ='3922000' WHERE kode_barcode='00021123' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2100000',harga_jual='9195000',harga_beli ='9195000' WHERE kode_barcode='00023133' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2100000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00027940' LIMIT 1;
UPDATE tm_group SET harga='2100000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2100000','kasir','2025-10-07 11:39:27');
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2035000',harga_beli ='2035000' WHERE kode_barcode='00019926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00019929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00019933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6551000',harga_beli ='6551000' WHERE kode_barcode='00024887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6712000',harga_beli ='6712000' WHERE kode_barcode='00024889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5444500',harga_beli ='5444500' WHERE kode_barcode='00024890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5409000',harga_beli ='5409000' WHERE kode_barcode='00024891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5409000',harga_beli ='5409000' WHERE kode_barcode='00024892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5391000',harga_beli ='5391000' WHERE kode_barcode='00024893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5391000',harga_beli ='5391000' WHERE kode_barcode='00024895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5426500',harga_beli ='5426500' WHERE kode_barcode='00024896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5409000',harga_beli ='5409000' WHERE kode_barcode='00024897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5337500',harga_beli ='5337500' WHERE kode_barcode='00024898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5355000',harga_beli ='5355000' WHERE kode_barcode='00024899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5426500',harga_beli ='5426500' WHERE kode_barcode='00024900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5409000',harga_beli ='5409000' WHERE kode_barcode='00024901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5409000',harga_beli ='5409000' WHERE kode_barcode='00024902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5373000',harga_beli ='5373000' WHERE kode_barcode='00024903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5391000',harga_beli ='5391000' WHERE kode_barcode='00024904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5391000',harga_beli ='5391000' WHERE kode_barcode='00024905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00024909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3927500',harga_beli ='3927500' WHERE kode_barcode='00024912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3838000',harga_beli ='3838000' WHERE kode_barcode='00024919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3838000',harga_beli ='3838000' WHERE kode_barcode='00024920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3891500',harga_beli ='3891500' WHERE kode_barcode='00024922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15574000',harga_beli ='15574000' WHERE kode_barcode='00025675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16263000',harga_beli ='16263000' WHERE kode_barcode='00025676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16746500',harga_beli ='16746500' WHERE kode_barcode='00025677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14354000',harga_beli ='14354000' WHERE kode_barcode='00025678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14550000',harga_beli ='14550000' WHERE kode_barcode='00025679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='24996000',harga_beli ='24996000' WHERE kode_barcode='00025682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15479500',harga_beli ='15479500' WHERE kode_barcode='00025683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='18261000',harga_beli ='18261000' WHERE kode_barcode='00025684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8045500',harga_beli ='8045500' WHERE kode_barcode='00025687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15261500',harga_beli ='15261500' WHERE kode_barcode='00025697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5886000',harga_beli ='5886000' WHERE kode_barcode='00025699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10052000',harga_beli ='10052000' WHERE kode_barcode='00025701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10033000',harga_beli ='10033000' WHERE kode_barcode='00025702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='00025706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3707500',harga_beli ='3707500' WHERE kode_barcode='00025711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00025714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11772000',harga_beli ='11772000' WHERE kode_barcode='00025716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5924500',harga_beli ='5924500' WHERE kode_barcode='00025717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4281000',harga_beli ='4281000' WHERE kode_barcode='00025718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5313000',harga_beli ='5313000' WHERE kode_barcode='00025723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3516500',harga_beli ='3516500' WHERE kode_barcode='00025724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1414500',harga_beli ='1414500' WHERE kode_barcode='00025726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1395500',harga_beli ='1395500' WHERE kode_barcode='00025727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4549500',harga_beli ='4549500' WHERE kode_barcode='00025730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='00025734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5993000',harga_beli ='5993000' WHERE kode_barcode='00025735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3161000',harga_beli ='3161000' WHERE kode_barcode='00025737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1900500',harga_beli ='1900500' WHERE kode_barcode='00025739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9179500',harga_beli ='9179500' WHERE kode_barcode='00025740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4586000',harga_beli ='4586000' WHERE kode_barcode='00025742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5554500',harga_beli ='5554500' WHERE kode_barcode='00025743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4622500',harga_beli ='4622500' WHERE kode_barcode='00025744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2412000',harga_beli ='2412000' WHERE kode_barcode='00025745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='17459000',harga_beli ='17459000' WHERE kode_barcode='00025747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='44030500',harga_beli ='44030500' WHERE kode_barcode='00025795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19524000',harga_beli ='19524000' WHERE kode_barcode='00025796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='40707500',harga_beli ='40707500' WHERE kode_barcode='00025797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14578500',harga_beli ='14578500' WHERE kode_barcode='00025798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='17831000',harga_beli ='17831000' WHERE kode_barcode='00025799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14204500',harga_beli ='14204500' WHERE kode_barcode='00025800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5301500',harga_beli ='5301500' WHERE kode_barcode='00025877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5159000',harga_beli ='5159000' WHERE kode_barcode='00025880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00025882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480500',harga_beli ='4480500' WHERE kode_barcode='00025883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4750500',harga_beli ='4750500' WHERE kode_barcode='00025888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='25085000',harga_beli ='25085000' WHERE kode_barcode='00025892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11299500',harga_beli ='11299500' WHERE kode_barcode='00025893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9068000',harga_beli ='9068000' WHERE kode_barcode='00025894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11513500',harga_beli ='11513500' WHERE kode_barcode='00025896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00026055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00026056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00026058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3922000',harga_beli ='3922000' WHERE kode_barcode='00026059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00026060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5069500',harga_beli ='5069500' WHERE kode_barcode='00026061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3534500',harga_beli ='3534500' WHERE kode_barcode='00026062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3391500',harga_beli ='3391500' WHERE kode_barcode='00026064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3356000',harga_beli ='3356000' WHERE kode_barcode='00026065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2660000',harga_beli ='2660000' WHERE kode_barcode='00026070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2642000',harga_beli ='2642000' WHERE kode_barcode='00026071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4605500',harga_beli ='4605500' WHERE kode_barcode='00026072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6979500',harga_beli ='6979500' WHERE kode_barcode='00026078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10656500',harga_beli ='10656500' WHERE kode_barcode='00026079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3731000',harga_beli ='3731000' WHERE kode_barcode='00026080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='00026081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480500',harga_beli ='4480500' WHERE kode_barcode='00026082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3398500',harga_beli ='3398500' WHERE kode_barcode='00026085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14012500',harga_beli ='14012500' WHERE kode_barcode='00026086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12638000',harga_beli ='12638000' WHERE kode_barcode='00026087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='50855000',harga_beli ='50855000' WHERE kode_barcode='00026090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='53300500',harga_beli ='53300500' WHERE kode_barcode='00026091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10174500',harga_beli ='10174500' WHERE kode_barcode='00026093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19564000',harga_beli ='19564000' WHERE kode_barcode='00026095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15976000',harga_beli ='15976000' WHERE kode_barcode='00026096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11192000',harga_beli ='11192000' WHERE kode_barcode='00026097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4462500',harga_beli ='4462500' WHERE kode_barcode='00026099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3335000',harga_beli ='3335000' WHERE kode_barcode='00026104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4994000',harga_beli ='4994000' WHERE kode_barcode='00026105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3335000',harga_beli ='3335000' WHERE kode_barcode='00026106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3434500',harga_beli ='3434500' WHERE kode_barcode='00026107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='00026108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00026109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3071500',harga_beli ='3071500' WHERE kode_barcode='00026110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3351500',harga_beli ='3351500' WHERE kode_barcode='00026111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4398500',harga_beli ='4398500' WHERE kode_barcode='00026112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5043500',harga_beli ='5043500' WHERE kode_barcode='00026113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4944000',harga_beli ='4944000' WHERE kode_barcode='00026114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3318000',harga_beli ='3318000' WHERE kode_barcode='00026115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3653000',harga_beli ='3653000' WHERE kode_barcode='00026117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3702000',harga_beli ='3702000' WHERE kode_barcode='00026118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2916000',harga_beli ='2916000' WHERE kode_barcode='00026119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2490000',harga_beli ='2490000' WHERE kode_barcode='00026120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2506500',harga_beli ='2506500' WHERE kode_barcode='00026121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='45616000',harga_beli ='45616000' WHERE kode_barcode='00026125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7134000',harga_beli ='7134000' WHERE kode_barcode='00026126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5782500',harga_beli ='5782500' WHERE kode_barcode='00026127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6667000',harga_beli ='6667000' WHERE kode_barcode='00026132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8680500',harga_beli ='8680500' WHERE kode_barcode='00026140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4732000',harga_beli ='4732000' WHERE kode_barcode='00026141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4750500',harga_beli ='4750500' WHERE kode_barcode='00026142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3677500',harga_beli ='3677500' WHERE kode_barcode='00026145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2285000',harga_beli ='2285000' WHERE kode_barcode='00026146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4750500',harga_beli ='4750500' WHERE kode_barcode='00026147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8820000',harga_beli ='8820000' WHERE kode_barcode='00026152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11930500',harga_beli ='11930500' WHERE kode_barcode='00026469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6504500',harga_beli ='6504500' WHERE kode_barcode='00026471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3161000',harga_beli ='3161000' WHERE kode_barcode='00026472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3453500',harga_beli ='3453500' WHERE kode_barcode='00026475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='23148500',harga_beli ='23148500' WHERE kode_barcode='00026480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='24427500',harga_beli ='24427500' WHERE kode_barcode='00026481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8477500',harga_beli ='8477500' WHERE kode_barcode='00026484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3581000',harga_beli ='3581000' WHERE kode_barcode='00026485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3800500',harga_beli ='3800500' WHERE kode_barcode='00026486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3764000',harga_beli ='3764000' WHERE kode_barcode='00026487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5572500',harga_beli ='5572500' WHERE kode_barcode='00026525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6541000',harga_beli ='6541000' WHERE kode_barcode='00026526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3161000',harga_beli ='3161000' WHERE kode_barcode='00026527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3691000',harga_beli ='3691000' WHERE kode_barcode='00026529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3124500',harga_beli ='3124500' WHERE kode_barcode='00026534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12150000',harga_beli ='12150000' WHERE kode_barcode='00026537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8185000',harga_beli ='8185000' WHERE kode_barcode='00026538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13812500',harga_beli ='13812500' WHERE kode_barcode='00026553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8550500',harga_beli ='8550500' WHERE kode_barcode='00026557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13228000',harga_beli ='13228000' WHERE kode_barcode='00026560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3691000',harga_beli ='3691000' WHERE kode_barcode='00026561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3727500',harga_beli ='3727500' WHERE kode_barcode='00026563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7283000',harga_beli ='7283000' WHERE kode_barcode='00026653' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1999500',harga_beli ='1999500' WHERE kode_barcode='00026654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2981000',harga_beli ='2981000' WHERE kode_barcode='00026655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3070500',harga_beli ='3070500' WHERE kode_barcode='00026656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3534500',harga_beli ='3534500' WHERE kode_barcode='00026658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2035000',harga_beli ='2035000' WHERE kode_barcode='00026659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4159500',harga_beli ='4159500' WHERE kode_barcode='00026660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2927500',harga_beli ='2927500' WHERE kode_barcode='00026662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3856000',harga_beli ='3856000' WHERE kode_barcode='00026665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4570000',harga_beli ='4570000' WHERE kode_barcode='00026666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3695000',harga_beli ='3695000' WHERE kode_barcode='00026668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4061500',harga_beli ='4061500' WHERE kode_barcode='00026669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8436500',harga_beli ='8436500' WHERE kode_barcode='00026671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00026672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3225000',harga_beli ='3225000' WHERE kode_barcode='00026677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5072500',harga_beli ='5072500' WHERE kode_barcode='00026678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00026679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2463500',harga_beli ='2463500' WHERE kode_barcode='00026680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4230500',harga_beli ='4230500' WHERE kode_barcode='00026681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2963500',harga_beli ='2963500' WHERE kode_barcode='00026683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2624000',harga_beli ='2624000' WHERE kode_barcode='00026684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2856000',harga_beli ='2856000' WHERE kode_barcode='00026686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3873500',harga_beli ='3873500' WHERE kode_barcode='00026689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4213000',harga_beli ='4213000' WHERE kode_barcode='00026691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8711000',harga_beli ='8711000' WHERE kode_barcode='00026693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4998000',harga_beli ='4998000' WHERE kode_barcode='00026697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3927500',harga_beli ='3927500' WHERE kode_barcode='00026699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3659500',harga_beli ='3659500' WHERE kode_barcode='00026702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4712500',harga_beli ='4712500' WHERE kode_barcode='00026708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3731000',harga_beli ='3731000' WHERE kode_barcode='00026709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4230500',harga_beli ='4230500' WHERE kode_barcode='00026710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2499000',harga_beli ='2499000' WHERE kode_barcode='00026711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3837000',harga_beli ='3837000' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11163000',harga_beli ='11163000' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13794000',harga_beli ='13794000' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12698000',harga_beli ='12698000' WHERE kode_barcode='00027633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='20609000',harga_beli ='20609000' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='22271500',harga_beli ='22271500' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13428500',harga_beli ='13428500' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8441000',harga_beli ='8441000' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9628500',harga_beli ='9628500' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12789000',harga_beli ='12789000' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10048500',harga_beli ='10048500' WHERE kode_barcode='00027647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6943000',harga_beli ='6943000' WHERE kode_barcode='00027649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5664000',harga_beli ='5664000' WHERE kode_barcode='00027650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16078000',harga_beli ='16078000' WHERE kode_barcode='00027652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19640500',harga_beli ='19640500' WHERE kode_barcode='00027654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6752500',harga_beli ='6752500' WHERE kode_barcode='00027657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3049500',harga_beli ='3049500' WHERE kode_barcode='00027659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4435500',harga_beli ='4435500' WHERE kode_barcode='00027662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4879000',harga_beli ='4879000' WHERE kode_barcode='00027663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4971500',harga_beli ='4971500' WHERE kode_barcode='00027664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00027667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10421000',harga_beli ='10421000' WHERE kode_barcode='00027668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5129500',harga_beli ='5129500' WHERE kode_barcode='00027669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14195500',harga_beli ='14195500' WHERE kode_barcode='00027671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14827500',harga_beli ='14827500' WHERE kode_barcode='00027672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8130500',harga_beli ='8130500' WHERE kode_barcode='00027678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4659000',harga_beli ='4659000' WHERE kode_barcode='00027680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11588000',harga_beli ='11588000' WHERE kode_barcode='00027681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4766000',harga_beli ='4766000' WHERE kode_barcode='00027682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='00027687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3570000',harga_beli ='3570000' WHERE kode_barcode='00027688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13999000',harga_beli ='13999000' WHERE kode_barcode='00027690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12466500',harga_beli ='12466500' WHERE kode_barcode='00027691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13214000',harga_beli ='13214000' WHERE kode_barcode='00027692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16522000',harga_beli ='16522000' WHERE kode_barcode='00027694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3289000',harga_beli ='3289000' WHERE kode_barcode='00029700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6819500',harga_beli ='6819500' WHERE kode_barcode='00029701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5378000',harga_beli ='5378000' WHERE kode_barcode='00029702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11846000',harga_beli ='11846000' WHERE kode_barcode='00029703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4639000',harga_beli ='4639000' WHERE kode_barcode='00029704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13731000',harga_beli ='13731000' WHERE kode_barcode='00029705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8242500',harga_beli ='8242500' WHERE kode_barcode='00029706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9006000',harga_beli ='9006000' WHERE kode_barcode='00030416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='35004000',harga_beli ='35004000' WHERE kode_barcode='00030724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5926500',harga_beli ='5926500' WHERE kode_barcode='00030727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='23934000',harga_beli ='23934000' WHERE kode_barcode='00030732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11930500',harga_beli ='11930500' WHERE kode_barcode='00030733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8873000',harga_beli ='8873000' WHERE kode_barcode='00030735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='20280000',harga_beli ='20280000' WHERE kode_barcode='00030741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10268000',harga_beli ='10268000' WHERE kode_barcode='00030742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12497000',harga_beli ='12497000' WHERE kode_barcode='00030744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2767000',harga_beli ='2767000' WHERE kode_barcode='00030753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3284500',harga_beli ='3284500' WHERE kode_barcode='00030754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8691000',harga_beli ='8691000' WHERE kode_barcode='00030755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7673500',harga_beli ='7673500' WHERE kode_barcode='00030758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8094000',harga_beli ='8094000' WHERE kode_barcode='00030760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2850500',harga_beli ='2850500' WHERE kode_barcode='00030761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2923500',harga_beli ='2923500' WHERE kode_barcode='00030763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='17612500',harga_beli ='17612500' WHERE kode_barcode='00030764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00030766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4787000',harga_beli ='4787000' WHERE kode_barcode='00030767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5116000',harga_beli ='5116000' WHERE kode_barcode='00030768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00030769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19914500',harga_beli ='19914500' WHERE kode_barcode='00030773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='46607000',harga_beli ='46607000' WHERE kode_barcode='00030774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2053000',harga_beli ='2053000' WHERE kode_barcode='00030784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4516500',harga_beli ='4516500' WHERE kode_barcode='00030785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4016500',harga_beli ='4016500' WHERE kode_barcode='00030786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3374000',harga_beli ='3374000' WHERE kode_barcode='00030787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6571500',harga_beli ='6571500' WHERE kode_barcode='00031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7747000',harga_beli ='7747000' WHERE kode_barcode='00031682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3374000',harga_beli ='3374000' WHERE kode_barcode='00031684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1517500',harga_beli ='1517500' WHERE kode_barcode='00031686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1624500',harga_beli ='1624500' WHERE kode_barcode='00031687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7247500',harga_beli ='7247500' WHERE kode_barcode='00031690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3096500',harga_beli ='3096500' WHERE kode_barcode='00032055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1436500',harga_beli ='1436500' WHERE kode_barcode='00033190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00033455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1691000',harga_beli ='1691000' WHERE kode_barcode='00033501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5926500',harga_beli ='5926500' WHERE kode_barcode='00033504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1882500',harga_beli ='1882500' WHERE kode_barcode='00033505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12131500',harga_beli ='12131500' WHERE kode_barcode='00033508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2074500',harga_beli ='2074500' WHERE kode_barcode='00033509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2039500',harga_beli ='2039500' WHERE kode_barcode='00033510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12334500',harga_beli ='12334500' WHERE kode_barcode='00033511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12620000',harga_beli ='12620000' WHERE kode_barcode='00033512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='18742500',harga_beli ='18742500' WHERE kode_barcode='00033513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14619500',harga_beli ='14619500' WHERE kode_barcode='00033516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10460500',harga_beli ='10460500' WHERE kode_barcode='00033517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4748500',harga_beli ='4748500' WHERE kode_barcode='00033518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00033881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5124500',harga_beli ='5124500' WHERE kode_barcode='00034640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5734500',harga_beli ='5734500' WHERE kode_barcode='00034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6083500',harga_beli ='6083500' WHERE kode_barcode='00034761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4253000',harga_beli ='4253000' WHERE kode_barcode='00034763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5700000',harga_beli ='5700000' WHERE kode_barcode='00034766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4009000',harga_beli ='4009000' WHERE kode_barcode='00034768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2614500',harga_beli ='2614500' WHERE kode_barcode='00034769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4462500',harga_beli ='4462500' WHERE kode_barcode='00034776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3416500',harga_beli ='3416500' WHERE kode_barcode='00034779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2493000',harga_beli ='2493000' WHERE kode_barcode='00035830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2677500',harga_beli ='2677500' WHERE kode_barcode='00035831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00036170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5020000',harga_beli ='5020000' WHERE kode_barcode='00036357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2806500',harga_beli ='2806500' WHERE kode_barcode='00036358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2614500',harga_beli ='2614500' WHERE kode_barcode='00036359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2562500',harga_beli ='2562500' WHERE kode_barcode='00036360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00036412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4357500',harga_beli ='4357500' WHERE kode_barcode='00036413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00036416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4253000',harga_beli ='4253000' WHERE kode_barcode='00036621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4741000',harga_beli ='4741000' WHERE kode_barcode='00036622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4114000',harga_beli ='4114000' WHERE kode_barcode='00036623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4375000',harga_beli ='4375000' WHERE kode_barcode='00036624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4061500',harga_beli ='4061500' WHERE kode_barcode='00036625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3869500',harga_beli ='3869500' WHERE kode_barcode='00036626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00036627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='00036628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4689000',harga_beli ='4689000' WHERE kode_barcode='00036629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3730500',harga_beli ='3730500' WHERE kode_barcode='00036630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2415000',harga_beli ='2415000' WHERE kode_barcode='00036702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2415000',harga_beli ='2415000' WHERE kode_barcode='00036705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2415000',harga_beli ='2415000' WHERE kode_barcode='00036707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5551500',harga_beli ='5551500' WHERE kode_barcode='00036763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5480000',harga_beli ='5480000' WHERE kode_barcode='00036764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5444500',harga_beli ='5444500' WHERE kode_barcode='00036765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5426500',harga_beli ='5426500' WHERE kode_barcode='00036766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5319500',harga_beli ='5319500' WHERE kode_barcode='00036767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3677500',harga_beli ='3677500' WHERE kode_barcode='00036770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2336000',harga_beli ='2336000' WHERE kode_barcode='00036790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2214000',harga_beli ='2214000' WHERE kode_barcode='00036791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2911000',harga_beli ='2911000' WHERE kode_barcode='00036806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3225000',harga_beli ='3225000' WHERE kode_barcode='00036808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2353500',harga_beli ='2353500' WHERE kode_barcode='00036842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2510000',harga_beli ='2510000' WHERE kode_barcode='00036844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3939500',harga_beli ='3939500' WHERE kode_barcode='00036848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3225000',harga_beli ='3225000' WHERE kode_barcode='00036850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3922000',harga_beli ='3922000' WHERE kode_barcode='00036851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3416500',harga_beli ='3416500' WHERE kode_barcode='00036852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='00036853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3312000',harga_beli ='3312000' WHERE kode_barcode='00036855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12549000',harga_beli ='12549000' WHERE kode_barcode='00036906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='15512000',harga_beli ='15512000' WHERE kode_barcode='00036907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9139500',harga_beli ='9139500' WHERE kode_barcode='00036908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5926500',harga_beli ='5926500' WHERE kode_barcode='00036909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='13102000',harga_beli ='13102000' WHERE kode_barcode='00036910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9496500',harga_beli ='9496500' WHERE kode_barcode='00036912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6515500',harga_beli ='6515500' WHERE kode_barcode='00036913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16029500',harga_beli ='16029500' WHERE kode_barcode='00036914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12691500',harga_beli ='12691500' WHERE kode_barcode='00036915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10531500',harga_beli ='10531500' WHERE kode_barcode='00036916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='17904000',harga_beli ='17904000' WHERE kode_barcode='00036918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='00037019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5769500',harga_beli ='5769500' WHERE kode_barcode='00037245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5177000',harga_beli ='5177000' WHERE kode_barcode='00037246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2841500',harga_beli ='2841500' WHERE kode_barcode='00037249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4148500',harga_beli ='4148500' WHERE kode_barcode='00037250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4445000',harga_beli ='4445000' WHERE kode_barcode='00037252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3364500',harga_beli ='3364500' WHERE kode_barcode='00037253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6205500',harga_beli ='6205500' WHERE kode_barcode='00037256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00037269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4462500',harga_beli ='4462500' WHERE kode_barcode='00037270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4636500',harga_beli ='4636500' WHERE kode_barcode='00037272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4758500',harga_beli ='4758500' WHERE kode_barcode='00037273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00037274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00037275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4357500',harga_beli ='4357500' WHERE kode_barcode='00037276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3259500',harga_beli ='3259500' WHERE kode_barcode='00037278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4166000',harga_beli ='4166000' WHERE kode_barcode='00037279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2684500',harga_beli ='2684500' WHERE kode_barcode='00037280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4480000',harga_beli ='4480000' WHERE kode_barcode='00037281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4671500',harga_beli ='4671500' WHERE kode_barcode='00037283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3347000',harga_beli ='3347000' WHERE kode_barcode='00037284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3660500',harga_beli ='3660500' WHERE kode_barcode='00037285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6257500',harga_beli ='6257500' WHERE kode_barcode='00037288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4323000',harga_beli ='4323000' WHERE kode_barcode='00037289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4514500',harga_beli ='4514500' WHERE kode_barcode='00037813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3745500',harga_beli ='3745500' WHERE kode_barcode='00038371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3745500',harga_beli ='3745500' WHERE kode_barcode='00038372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3727500',harga_beli ='3727500' WHERE kode_barcode='00038373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3727500',harga_beli ='3727500' WHERE kode_barcode='00038374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3764000',harga_beli ='3764000' WHERE kode_barcode='00038375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3179500',harga_beli ='3179500' WHERE kode_barcode='00038376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3179500',harga_beli ='3179500' WHERE kode_barcode='00038377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6541000',harga_beli ='6541000' WHERE kode_barcode='00038378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10122000',harga_beli ='10122000' WHERE kode_barcode='00038379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8496000',harga_beli ='8496000' WHERE kode_barcode='00038380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11547000',harga_beli ='11547000' WHERE kode_barcode='00038381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6212000',harga_beli ='6212000' WHERE kode_barcode='00038382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3051500',harga_beli ='3051500' WHERE kode_barcode='00038383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3124500',harga_beli ='3124500' WHERE kode_barcode='00038384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7856500',harga_beli ='7856500' WHERE kode_barcode='00038385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8057500',harga_beli ='8057500' WHERE kode_barcode='00038386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8094000',harga_beli ='8094000' WHERE kode_barcode='00038387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2646000',harga_beli ='2646000' WHERE kode_barcode='00038388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2681500',harga_beli ='2681500' WHERE kode_barcode='00038389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2893000',harga_beli ='2893000' WHERE kode_barcode='00038390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2964000',harga_beli ='2964000' WHERE kode_barcode='00038391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2875500',harga_beli ='2875500' WHERE kode_barcode='00038393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2928500',harga_beli ='2928500' WHERE kode_barcode='00038394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1570000',harga_beli ='1570000' WHERE kode_barcode='00038396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1535000',harga_beli ='1535000' WHERE kode_barcode='00038397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1976000',harga_beli ='1976000' WHERE kode_barcode='00038399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2240500',harga_beli ='2240500' WHERE kode_barcode='00038400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2293500',harga_beli ='2293500' WHERE kode_barcode='00038401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1852500',harga_beli ='1852500' WHERE kode_barcode='00038402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1870000',harga_beli ='1870000' WHERE kode_barcode='00038403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2381500',harga_beli ='2381500' WHERE kode_barcode='00038404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1517500',harga_beli ='1517500' WHERE kode_barcode='00038405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1499500',harga_beli ='1499500' WHERE kode_barcode='00038406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2170000',harga_beli ='2170000' WHERE kode_barcode='00038407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2170000',harga_beli ='2170000' WHERE kode_barcode='00038408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2152500',harga_beli ='2152500' WHERE kode_barcode='00038409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='00038411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1658500',harga_beli ='1658500' WHERE kode_barcode='00038412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='00038414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2875500',harga_beli ='2875500' WHERE kode_barcode='00038415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7038500',harga_beli ='7038500' WHERE kode_barcode='00038416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2505000',harga_beli ='2505000' WHERE kode_barcode='00038417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4093000',harga_beli ='4093000' WHERE kode_barcode='00038419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4093000',harga_beli ='4093000' WHERE kode_barcode='00038420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4181000',harga_beli ='4181000' WHERE kode_barcode='00038421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4093000',harga_beli ='4093000' WHERE kode_barcode='00038422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3863500',harga_beli ='3863500' WHERE kode_barcode='00038423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5098000',harga_beli ='5098000' WHERE kode_barcode='00038424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5416000',harga_beli ='5416000' WHERE kode_barcode='00038425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5398000',harga_beli ='5398000' WHERE kode_barcode='00038426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00038427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4022000',harga_beli ='4022000' WHERE kode_barcode='00038428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3828000',harga_beli ='3828000' WHERE kode_barcode='00038429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00038430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3828000',harga_beli ='3828000' WHERE kode_barcode='00038431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10566500',harga_beli ='10566500' WHERE kode_barcode='00038433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10619500',harga_beli ='10619500' WHERE kode_barcode='00038434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8907500',harga_beli ='8907500' WHERE kode_barcode='00038435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9121500',harga_beli ='9121500' WHERE kode_barcode='00038436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00038437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2178000',harga_beli ='2178000' WHERE kode_barcode='00038438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2196000',harga_beli ='2196000' WHERE kode_barcode='00038439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3409500',harga_beli ='3409500' WHERE kode_barcode='00038440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6105000',harga_beli ='6105000' WHERE kode_barcode='00038441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2106500',harga_beli ='2106500' WHERE kode_barcode='00038442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2499000',harga_beli ='2499000' WHERE kode_barcode='00038444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9389500',harga_beli ='9389500' WHERE kode_barcode='00038445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6997500',harga_beli ='6997500' WHERE kode_barcode='00038446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6872500',harga_beli ='6872500' WHERE kode_barcode='00038447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7533000',harga_beli ='7533000' WHERE kode_barcode='00038449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6819000',harga_beli ='6819000' WHERE kode_barcode='00038450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6997500',harga_beli ='6997500' WHERE kode_barcode='00038451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11906000',harga_beli ='11906000' WHERE kode_barcode='00038452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11602500',harga_beli ='11602500' WHERE kode_barcode='00038453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='14691000',harga_beli ='14691000' WHERE kode_barcode='00038454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4040000',harga_beli ='4040000' WHERE kode_barcode='00038534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3669500',harga_beli ='3669500' WHERE kode_barcode='00038535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1676000',harga_beli ='1676000' WHERE kode_barcode='00038536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2134500',harga_beli ='2134500' WHERE kode_barcode='00038537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2258000',harga_beli ='2258000' WHERE kode_barcode='00038538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3034500',harga_beli ='3034500' WHERE kode_barcode='00038540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4692500',harga_beli ='4692500' WHERE kode_barcode='00038541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2170000',harga_beli ='2170000' WHERE kode_barcode='00038542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1588000',harga_beli ='1588000' WHERE kode_barcode='00038543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1905500',harga_beli ='1905500' WHERE kode_barcode='00038544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1588000',harga_beli ='1588000' WHERE kode_barcode='00038545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1764000',harga_beli ='1764000' WHERE kode_barcode='00038547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1711500',harga_beli ='1711500' WHERE kode_barcode='00038548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2293500',harga_beli ='2293500' WHERE kode_barcode='00038549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3299000',harga_beli ='3299000' WHERE kode_barcode='00038550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3405000',harga_beli ='3405000' WHERE kode_barcode='00038551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3828000',harga_beli ='3828000' WHERE kode_barcode='00038552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5123000',harga_beli ='5123000' WHERE kode_barcode='00038553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4891000',harga_beli ='4891000' WHERE kode_barcode='00038554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2481500',harga_beli ='2481500' WHERE kode_barcode='00038555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='20028000',harga_beli ='20028000' WHERE kode_barcode='00038556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3599500',harga_beli ='3599500' WHERE kode_barcode='00038557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5591000',harga_beli ='5591000' WHERE kode_barcode='00038558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='8477500',harga_beli ='8477500' WHERE kode_barcode='00038559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3490000',harga_beli ='3490000' WHERE kode_barcode='00038560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2594500',harga_beli ='2594500' WHERE kode_barcode='00038561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1078000',harga_beli ='1078000' WHERE kode_barcode='00038564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1078000',harga_beli ='1078000' WHERE kode_barcode='00038565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='1078000',harga_beli ='1078000' WHERE kode_barcode='00038566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5591000',harga_beli ='5591000' WHERE kode_barcode='00038567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3764000',harga_beli ='3764000' WHERE kode_barcode='00038568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5463000',harga_beli ='5463000' WHERE kode_barcode='00038569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3782000',harga_beli ='3782000' WHERE kode_barcode='00038570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3745500',harga_beli ='3745500' WHERE kode_barcode='00038571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6687000',harga_beli ='6687000' WHERE kode_barcode='00038572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9994000',harga_beli ='9994000' WHERE kode_barcode='00038573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9354500',harga_beli ='9354500' WHERE kode_barcode='00038575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='16461500',harga_beli ='16461500' WHERE kode_barcode='00038576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2824000',harga_beli ='2824000' WHERE kode_barcode='00038670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3748500',harga_beli ='3748500' WHERE kode_barcode='00038732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2047500',harga_beli ='2047500' WHERE kode_barcode='00038772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11550000',harga_beli ='11550000' WHERE kode_barcode='00038872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11550000',harga_beli ='11550000' WHERE kode_barcode='00038873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11550000',harga_beli ='11550000' WHERE kode_barcode='00038874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11550000',harga_beli ='11550000' WHERE kode_barcode='00038875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='11550000',harga_beli ='11550000' WHERE kode_barcode='00038876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='108150000',harga_beli ='108150000' WHERE kode_barcode='00038877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='41783500',harga_beli ='41783500' WHERE kode_barcode='00038891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='38926500',harga_beli ='38926500' WHERE kode_barcode='00038892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='33950500',harga_beli ='33950500' WHERE kode_barcode='00038893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4102000',harga_beli ='4102000' WHERE kode_barcode='00038894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5139500',harga_beli ='5139500' WHERE kode_barcode='00038895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10055000',harga_beli ='10055000' WHERE kode_barcode='00038896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6888500',harga_beli ='6888500' WHERE kode_barcode='00038897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3101500',harga_beli ='3101500' WHERE kode_barcode='00038898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9033500',harga_beli ='9033500' WHERE kode_barcode='00038899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7038500',harga_beli ='7038500' WHERE kode_barcode='00038900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4836000',harga_beli ='4836000' WHERE kode_barcode='00038901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='3096500',harga_beli ='3096500' WHERE kode_barcode='00038902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='7884500',harga_beli ='7884500' WHERE kode_barcode='00038903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4517000',harga_beli ='4517000' WHERE kode_barcode='00038904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='10821000',harga_beli ='10821000' WHERE kode_barcode='00038905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='12465000',harga_beli ='12465000' WHERE kode_barcode='00038906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='6927000',harga_beli ='6927000' WHERE kode_barcode='00038907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='9353000',harga_beli ='9353000' WHERE kode_barcode='00038908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='4804000',harga_beli ='4804000' WHERE kode_barcode='00038923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='24419000',harga_beli ='24419000' WHERE kode_barcode='00038924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='19407500',harga_beli ='19407500' WHERE kode_barcode='00038925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='2071000',harga_beli ='2071000' WHERE kode_barcode='00038950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2100000',harga_jual='5111000',harga_beli ='5111000' WHERE kode_barcode='00038951' LIMIT 1;
UPDATE tm_group SET harga='2100000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2100000','kasir','2025-10-07 11:39:54');
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-251007-0003','K','2025-10-07','11:41:31','kasir','BELANJA','BELI TISU','659100','35000','624100');
UPDATE tp_curr SET rp= '16600.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16600.00', 'kasir','2025-10-07 11:42:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','12:38:02');
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,potong_rp,keterangan) VALUES ('FJ-251007-0002','kasir','1',' 850K-135-1','TOKO','BIPPER','PBDG-YHBI-8-0','CINCIN SILVER 925 ','','2.380','1','100.00','61000','0','0','16600','599000','0','0','0','599000','NITA','00038359','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHBI-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PBDG-YHBI-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0002','2025-10-07','2.380','2025-10-07','13:47:10','PLG0006838','599000','599000','0','599000','0','kasir','2025-10-07 13:47:10','FJ-251007-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0002','2025-10-07','13:47:10','NITA','599000','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-251007-0006','2025-10-07','2025-10-07 13:47:10','PENJUALAN : FJ-251007-0002','.','TBC','599000','599000','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-251007-0007','D','2025-10-07','13:47:10','TBC','PENJUALAN','FJ-251007-0002','17081835614','599000','17082434614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='599000' WHERE no_faktur_jual='FJ-251007-0002' 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,potong_rp,keterangan) VALUES ('FJ-251007-0003','kasir',' 1',' 500K-195-1','TOKO','BIPPER','PBDG-YIBF-1-0','CINCIN SILVER 925 ','','2.070','1','100.00','54000','0','0','16600','400000','0','0','0','400000','NITA','00038932','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIBF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PBDG-YIBF-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0003','2025-10-07','2.070','2025-10-07','13:47:10','PLG0006839','400000','400000','0','400000','0','kasir','2025-10-07 13:47:10','FJ-251007-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0003','2025-10-07','13:47:10','NITA','400000','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-251007-0007','2025-10-07','2025-10-07 13:47:10','PENJUALAN : FJ-251007-0003','.','TBC','400000','400000','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-251007-0008','D','2025-10-07','13:47:10','TBC','PENJUALAN','FJ-251007-0003','17082434614','400000','17082834614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='999000' WHERE no_faktur_jual='FJ-251007-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','13:57:44');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2025-10-07 14:45:03' WHERE id_card = '-';
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,potong_rp,keterangan) VALUES ('FJ-251007-0004','kasir','1',' TFC-21356 ','TOKO','TFCBR','TFC-XCBF-15-0','TFC-21356 GIA 6471734095','','3.300','1','83.00','22192000','14422500','869','16600','23500000','0','0','0','23500000','ILU','00027759','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-XCBF-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='TFC-XCBF-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0004','2025-10-07','3.300','2025-10-07','14:45:06','PLG0006840','23500000','23500000','0','23500000','0','kasir','2025-10-07 14:45:05','FJ-251007-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0004','2025-10-07','14:45:06','ILU','23500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-251007-0001','2025-10-07','2025-10-07 14:45:05','PENJUALAN : FJ-251007-0004','','KET','2500000','2500000','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-251007-0002','D','2025-10-07','14:45:06','KET','PENJUALAN BERLIAN','FJ-251007-0004','132563000','2500000','135063000','CARD');
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-251007-0008','2025-10-07','2025-10-07 14:45:05','PENJUALAN : FJ-251007-0004','','TBC','21000000','21000000','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-251007-0009','D','2025-10-07','14:45:06','TBC','PENJUALAN BERLIAN','FJ-251007-0004','17082834614','21000000','17103834614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='2500000',card_fee_rp ='0',transfer_rp='21000000' WHERE no_faktur_jual='FJ-251007-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','14:53:08');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01326','ILU','1','TFC','RESIZE KE 12 KRUM TETEP PUTIH','3.300','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01326','2025-10-07','2025-10-07','14:54:44','PLG0006841','kasir','2025-10-09','kasir','2025-10-07 14:54:44','3.300','0','0','0','0','0','0','0','0');
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,potong_rp,keterangan) VALUES ('FJ-251007-0005','kasir','1',' TFCMR75-83','TOKO','TFCINMAS','TFCMR-YABB-30-0','THIFA CINCIN MAS RG ','','6.960','1','83.00','12253000','0','0','16600','12900000','0','0','0','12900000','ASRI','00033508','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YABB-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.960',berat_jual_asli=berat_jual_asli+'6.960',stock_jual='1',berat_akhir=berat_akhir-'6.960',berat_akhir_asli=berat_akhir_asli-'6.960',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='TFCMR-YABB-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0005','2025-10-07','6.960','2025-10-07','15:12:35','PLG0006842','12900000','12900000','0','12900000','0','kasir','2025-10-07 15:12:35','FJ-251007-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0005','2025-10-07','15:12:35','ASRI','12900000','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-251007-0009','2025-10-07','2025-10-07 15:12:35','PENJUALAN : FJ-251007-0005','.','TBC','12900000','12900000','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-251007-0010','D','2025-10-07','15:12:35','TBC','PENJUALAN','FJ-251007-0005','17103834614','12900000','17116734614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='12900000' WHERE no_faktur_jual='FJ-251007-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','17:56:37');
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,potong_rp,keterangan) VALUES ('FJ-251007-0006','kasir','1',' 1.0K-12-00','TOKO','MMPER','PMM-YIXH-36-0','CINCIN SILVER 925 ','','1.990','1','100.00','51000','0','0','16600','1000000','0','0','0','1000000','NIS','00038630','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PMM-YIXH-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0006','2025-10-07','1.990','2025-10-07','17:57:44','PLG0006843','1000000','1000000','0','1000000','0','kasir','2025-10-07 17:57:44','FJ-251007-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0006','2025-10-07','17:57:44','NIS','1000000','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-251007-0010','2025-10-07','2025-10-07 17:57:44','PENJUALAN : FJ-251007-0006','.','TBC','1000000','1000000','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-251007-0011','D','2025-10-07','17:57:44','TBC','PENJUALAN','FJ-251007-0006','17116734614','1000000','17117734614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-251007-0006' 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,potong_rp,keterangan) VALUES ('FJ-251007-0007','kasir','1',' 700K-20-00','TOKO','MMPER','PMM-YGXD-26-0','CINCIN SILVER 925 ','','2.330','1','100.00','55000','0','0','16600','700000','0','0','0','700000','NAD','00036972','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXD-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PMM-YGXD-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0007','2025-10-07','2.330','2025-10-07','17:58:54','PLG0006844','700000','700000','0','700000','0','kasir','2025-10-07 17:58:54','FJ-251007-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0007','2025-10-07','17:58:54','NAD','700000','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-251007-0011','2025-10-07','2025-10-07 17:58:54','PENJUALAN : FJ-251007-0007','.','TBC','700000','700000','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-251007-0012','D','2025-10-07','17:58:54','TBC','PENJUALAN','FJ-251007-0007','17117734614','700000','17118434614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-251007-0007' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01327','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 14 GRF IKWAL DAN COWO RESIZE KE 21 GRF MARIZKA','4.320','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01327','2025-10-07','2025-10-07','18:04:25','PLG0006845','kasir','2025-10-08','kasir','2025-10-07 18:04:25','4.320','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','18:04:55');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0007';
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,potong_rp,keterangan) VALUES ('FJ-251007-0008','kasir','1',' 850K-16-00','TOKO','MMPER','PMM-YGXI-28-0','CINCIN SILVER 925 ','','1.780','1','100.00','42000','0','0','16600','850000','0','0','0','850000','NIS','00037089','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXI-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PMM-YGXI-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0008','2025-10-07','1.780','2025-10-07','18:38:06','PLG0006846','850000','850000','0','850000','0','kasir','2025-10-07 18:38:06','FJ-251007-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0008','2025-10-07','18:38:06','NIS','850000','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-251007-0012','2025-10-07','2025-10-07 18:38:06','PENJUALAN : FJ-251007-0008','.','TBC','850000','850000','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-251007-0013','D','2025-10-07','18:38:06','TBC','PENJUALAN','FJ-251007-0008','17118434614','850000','17119284614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-251007-0008' 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,potong_rp,keterangan) VALUES ('FJ-251007-0009','kasir',' 1',' 700K-175-0','TOKO','MMPER','PMM-YFBX-92-0','CINCIN SILVER 925 ','','1.680','1','100.00','40000','0','0','16600','700000','0','0','0','700000','NIS','00036533','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2025-10-07' AND kode_barang='PMM-YFBX-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251007-0009','2025-10-07','1.680','2025-10-07','18:38:06','PLG0006847','700000','700000','0','700000','0','kasir','2025-10-07 18:38:06','FJ-251007-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-07','FJ-251007-0009','2025-10-07','18:38:06','NIS','700000','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-251007-0013','2025-10-07','2025-10-07 18:38:06','PENJUALAN : FJ-251007-0009','.','TBC','700000','700000','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-251007-0014','D','2025-10-07','18:38:06','TBC','PENJUALAN','FJ-251007-0009','17119284614','700000','17119984614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1550000' WHERE no_faktur_jual='FJ-251007-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251007-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251007-0009';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01328','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 17 GRF IMAN DAN COWO RESIZE KE 13 GRF AORIN','3.460','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01328','2025-10-07','2025-10-07','18:41:53','PLG0006848','kasir','2025-10-08','kasir','2025-10-07 18:41:53','3.460','0','0','0','0','0','0','0','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-07';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-251008-0001','D','2025-10-08','20:07:10','TBC','SALDO AWAL','SALDO AWAL','0','17119984614','17119984614');
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-251008-0001','D','2025-10-08','20:07:10','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251008-0001','D','2025-10-08','20:07:10','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-251008-0001','D','2025-10-08','20:07:10','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-251008-0001','D','2025-10-08','20:07:10','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-251008-0001','D','2025-10-08','20:07:10','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251008-0001','D','2025-10-08','20:07:10','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-251008-0001','D','2025-10-08','20:07:10','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251008-0001','D','2025-10-08','20:07:10','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251008-0001','D','2025-10-08','20:07:10','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
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-251008-0001','D','2025-10-08','20:07:10','BCD','SALDO AWAL','SALDO AWAL','0','1330221000','1330221000');
UPDATE tp_system SET tgl_system='2025-10-08';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','20:53:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','20:53:26');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01215','SULIS','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2100000','1870000','0','700000','5375000','1 zircon sz 14 crom putih glosy','font yeseva one grf Steven Johan S','berat jgn di bawah 2.5 gr','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251008-0001','2025-10-08','2025-10-07 20:55:50','PESANAN : DP-01215','.','TBC','4300000','4300000');
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-251008-0002','D','2025-10-08','20:55:50','TBC','PESANAN','DP-01215','17119984614','4300000','17124284614','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01215','2025-10-08','2025-10-08','20:55:50','PLG0006849','SULIS','2025-10-27','kasir','2025-10-07 20:55:50','2.500','0','0','0','4300000','0','700000','5375000','5375000','1075000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01216','SULIS','1','PER','WEDDING RING','','','3.000','','925.00','1','25000','0','700000','0','700000','sz 32 lebar nambah 1mm','crom putih doff semprot. 1 zircon','font yeseva one grf Juju Nanda S','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251008-0002','2025-10-08','2025-10-07 20:58:32','PESANAN : DP-01216','.','TBC','700000','700000');
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-251008-0003','D','2025-10-08','20:58:32','TBC','PESANAN','DP-01216','17124284614','700000','17124984614','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01216','2025-10-08','2025-10-08','20:58:32','PLG0006850','SULIS','2025-10-27','kasir','2025-10-07 20:58:32','3.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-07 ','21:00:01');