INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060917031','input','1',' MDE2D KH 1','TOKO','PM-E','E2D-ZHBE-319-0','CC MODEL PAKU MATA SLEP KH 14 8K ','','1.130','1','100.00','1158000','0','0','15000','1158000','0','0','0','1158000','SIN','00420361','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBE-319-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2D-ZHBE-319-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060917031','2026-09-06','1.130','2026-09-06','09:17:04','PLG0031183','1158000','1158000','0','1158000','1158000','input','2026-09-06 09:17:03','F32606091703');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060917031','2026-09-06','09:17:04','SIN','1158000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0002','D','2026-09-06','09:17:04','input','PENJUALAN','F326060917031','7235650000','1158000','7236808000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060924111','input','1',' MDB1D X HW','TOKO','PM-B','B1D-ZGAG-29-0','GW X ITALY RIBBON VAR HW 8K ','','0.830','1','100.00','851000','0','0','15000','851000','0','0','0','851000','LIS','00413865','B1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZGAG-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='B1D-ZGAG-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060924111','2026-09-06','0.830','2026-09-06','09:24:11','PLG0031184','851000','851000','0','851000','851000','input','2026-09-06 09:24:11','F32606092411');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060924111','2026-09-06','09:24:11','LIS','851000','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-260906-0003','D','2026-09-06','09:24:11','input','PENJUALAN','F326060924111','7236808000','851000','7237659000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='851000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060924111' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060924112','input',' 1',' MED2E X LG','TOKO','PM-D','D2E-ZDBG-48-0','LT X MODEL MATA LG 8K ','','0.530','1','100.00','554000','0','0','15000','554000','0','0','0','554000','LIS','00401291','D2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZDBG-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='D2E-ZDBG-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060924112','2026-09-06','0.530','2026-09-06','09:24:11','PLG0031185','554000','554000','0','554000','554000','input','2026-09-06 09:24:11','F32606092411');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060924112','2026-09-06','09:24:11','LIS','554000','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-260906-0004','D','2026-09-06','09:24:11','input','PENJUALAN','F326060924112','7237659000','554000','7238213000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326060924112' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060929311','input','1',' MEE2E KH 2','TOKO','PM-E','E2E-ZHBI-131-0','CC MODEL SNAKE MATA SLEP KH 20 8K ','','0.470','1','100.00','491000','0','0','15000','490000','0','0','0','490000','AAT','00421256','E2E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBI-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2E-ZHBI-131-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060929311','2026-09-06','0.470','2026-09-06','09:29:32','PLG0031186','490000','490000','0','490000','490000','input','2026-09-06 09:29:31','F32606092931');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060929311','2026-09-06','09:29:32','AAT','490000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0005','D','2026-09-06','09:29:32','input','PENJUALAN','F326060929311','7238213000','490000','7238703000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061028171','input','1',' MEF3 XXX H','TOKO','PM-F','F3E-ZFXH-159-0','GL XXX CAPELLA SLEP HW 8K ','','1.370','1','100.00','1432000','0','0','15000','1390000','0','0','0','1390000','LIS','00408020','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXH-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='F3E-ZFXH-159-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061028171','2026-09-06','1.370','2026-09-06','10:28:17','PLG0031187','1390000','1390000','0','1390000','1390000','input','2026-09-06 10:28:17','F32606102817');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061028171','2026-09-06','10:28:17','LIS','1390000','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-260906-0006','D','2026-09-06','10:28:17','input','PENJUALAN','F326061028171','7238703000','1390000','7240093000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061028171' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061028172','input',' 1',' MDE2 X LG ','TOKO','PM-E','E2D-ZGBA-111-0','CC X MODEL MATA LG 14 8K ','','1.000','1','100.00','1025000','0','0','15000','1025000','0','0','0','1025000','LIS','00414593','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBA-111-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2D-ZGBA-111-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061028172','2026-09-06','1.000','2026-09-06','10:28:17','PLG0031188','1025000','1025000','0','1025000','1025000','input','2026-09-06 10:28:17','F32606102817');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061028172','2026-09-06','10:28:17','LIS','1025000','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-260906-0007','D','2026-09-06','10:28:17','input','PENJUALAN','F326061028172','7240093000','1025000','7241118000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061028172' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061107581','input','1',' MEE1 CM 12','TOKO','PM-E','E1E-ZIXC-32-0','CC PIPA MODEL BUNGA VAR CM 12 8K ','','0.460','1','100.00','481000','0','0','15000','481000','0','0','0','481000','SIN','00421922','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXC-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E1E-ZIXC-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061107581','2026-09-06','0.460','2026-09-06','11:07:59','PLG0031189','481000','481000','0','481000','481000','input','2026-09-06 11:07:58','F32606110758');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061107581','2026-09-06','11:07:59','SIN','481000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0008','D','2026-09-06','11:07:59','input','PENJUALAN','F326061107581','7241118000','481000','7241599000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061110021','input','1',' MHB1H X AV','TOKO','PM-B','B1H-ZDXD-238-0','GW X TUSUK MRICAN SLEP AV 8K ','','0.260','1','100.00','287000','0','0','15000','288000','0','0','0','288000','FIT','00397938','B1H','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZDXD-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='B1H-ZDXD-238-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061110021','2026-09-06','0.260','2026-09-06','11:10:03','PLG0031190','288000','288000','0','288000','288000','input','2026-09-06 11:10:02','F32606111002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061110021','2026-09-06','11:10:03','FIT','288000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0009','D','2026-09-06','11:10:03','input','PENJUALAN','F326061110021','7241599000','288000','7241887000');
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='972000',harga_beli ='972000' WHERE kode_barcode='T0054890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='T0072059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4358000',harga_beli ='4358000' WHERE kode_barcode='T0074862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='T0077297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2383000',harga_beli ='2383000' WHERE kode_barcode='T0079591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='773500',harga_beli ='773500' WHERE kode_barcode='T0079865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='T0079868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='T0079869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='T0079879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1024500',harga_beli ='1024500' WHERE kode_barcode='00052974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='00064198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1212500',harga_beli ='1212500' WHERE kode_barcode='00090365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='00096890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='00102954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00103630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00120913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00132895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00133009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10398000',harga_beli ='10398000' WHERE kode_barcode='00141171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00142644' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1233500',harga_beli ='1233500' WHERE kode_barcode='00142650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00149726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00166158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00175403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1442500',harga_beli ='1442500' WHERE kode_barcode='00181466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1264500',harga_beli ='1264500' WHERE kode_barcode='00182849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00187806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3114500',harga_beli ='3114500' WHERE kode_barcode='00194622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00201184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1547000',harga_beli ='1547000' WHERE kode_barcode='00209127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='00209522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='00213369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='00213405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1139500',harga_beli ='1139500' WHERE kode_barcode='00213686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00213848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3814500',harga_beli ='3814500' WHERE kode_barcode='00216509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00221400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2100500',harga_beli ='2100500' WHERE kode_barcode='00223055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1432000',harga_beli ='1432000' WHERE kode_barcode='00229143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00229297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1223000',harga_beli ='1223000' WHERE kode_barcode='00232223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='00233756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1724500',harga_beli ='1724500' WHERE kode_barcode='00235731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00237945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='00240727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6218000',harga_beli ='6218000' WHERE kode_barcode='00241193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='00243242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00243446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1317000',harga_beli ='1317000' WHERE kode_barcode='00243916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2905500',harga_beli ='2905500' WHERE kode_barcode='00247320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2456000',harga_beli ='2456000' WHERE kode_barcode='00251708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2905500',harga_beli ='2905500' WHERE kode_barcode='00254363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3334000',harga_beli ='3334000' WHERE kode_barcode='00255678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2351500',harga_beli ='2351500' WHERE kode_barcode='00256394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00256496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00257782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1411000',harga_beli ='1411000' WHERE kode_barcode='00258005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1557500',harga_beli ='1557500' WHERE kode_barcode='00258745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1223000',harga_beli ='1223000' WHERE kode_barcode='00258749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00260039' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00261890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00262510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2038000',harga_beli ='2038000' WHERE kode_barcode='00264622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1223000',harga_beli ='1223000' WHERE kode_barcode='00265415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1724500',harga_beli ='1724500' WHERE kode_barcode='00265735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00268791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='00268802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2508000',harga_beli ='2508000' WHERE kode_barcode='00268957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00269112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00270520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='00272416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7346500',harga_beli ='7346500' WHERE kode_barcode='00272894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='00273818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='888500',harga_beli ='888500' WHERE kode_barcode='00273907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='00274396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00277691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='909500',harga_beli ='909500' WHERE kode_barcode='00281431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3501000',harga_beli ='3501000' WHERE kode_barcode='00283283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='11025000',harga_beli ='11025000' WHERE kode_barcode='00283322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='00284337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='940500',harga_beli ='940500' WHERE kode_barcode='00284364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1306500',harga_beli ='1306500' WHERE kode_barcode='00284430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1484000',harga_beli ='1484000' WHERE kode_barcode='00284994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='00285792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='909500',harga_beli ='909500' WHERE kode_barcode='00288452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00290451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00290955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='993000',harga_beli ='993000' WHERE kode_barcode='00290980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='961500',harga_beli ='961500' WHERE kode_barcode='00290982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00291024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00294259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='940500',harga_beli ='940500' WHERE kode_barcode='00294260' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3731000',harga_beli ='3731000' WHERE kode_barcode='00294757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8496000',harga_beli ='8496000' WHERE kode_barcode='00295141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1003500',harga_beli ='1003500' WHERE kode_barcode='00295193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1254000',harga_beli ='1254000' WHERE kode_barcode='00297551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00297627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00297951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3396500',harga_beli ='3396500' WHERE kode_barcode='00298269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2477000',harga_beli ='2477000' WHERE kode_barcode='00298345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00299663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='00300475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00301304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00301362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2592000',harga_beli ='2592000' WHERE kode_barcode='00302645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00302955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1254000',harga_beli ='1254000' WHERE kode_barcode='00303862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1275000',harga_beli ='1275000' WHERE kode_barcode='00303915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='993000',harga_beli ='993000' WHERE kode_barcode='00304212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='951000',harga_beli ='951000' WHERE kode_barcode='00305005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00305485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00305493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='00305542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1567500',harga_beli ='1567500' WHERE kode_barcode='00306186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00306465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00307506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='993000',harga_beli ='993000' WHERE kode_barcode='00307837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3657500',harga_beli ='3657500' WHERE kode_barcode='00309100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3083000',harga_beli ='3083000' WHERE kode_barcode='00309836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='961500',harga_beli ='961500' WHERE kode_barcode='00309992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='951000',harga_beli ='951000' WHERE kode_barcode='00310563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00310566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00311299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6322500',harga_beli ='6322500' WHERE kode_barcode='00313257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='00315117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00316165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00317399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00319010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00319073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7179500',harga_beli ='7179500' WHERE kode_barcode='00320719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00323774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3292000',harga_beli ='3292000' WHERE kode_barcode='00323928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2790500',harga_beli ='2790500' WHERE kode_barcode='00324242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00324623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00326747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00327926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00329335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2362000',harga_beli ='2362000' WHERE kode_barcode='00329444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='00331623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='00333691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='00334287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00336680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2393500',harga_beli ='2393500' WHERE kode_barcode='00337578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5298500',harga_beli ='5298500' WHERE kode_barcode='00337736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00337822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4149000',harga_beli ='4149000' WHERE kode_barcode='00338085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00339478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00340149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1912500',harga_beli ='1912500' WHERE kode_barcode='00340461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00340726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00340746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00341878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1672000',harga_beli ='1672000' WHERE kode_barcode='00342070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00344610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00344624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00344626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00344643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='00346126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00346808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00347526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00347617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2414000',harga_beli ='2414000' WHERE kode_barcode='00347662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00348844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00348853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00349231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3292000',harga_beli ='3292000' WHERE kode_barcode='00349485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2999500',harga_beli ='2999500' WHERE kode_barcode='00349819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2278500',harga_beli ='2278500' WHERE kode_barcode='00349850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00349851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='00349921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2006500',harga_beli ='2006500' WHERE kode_barcode='00349947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1965000',harga_beli ='1965000' WHERE kode_barcode='00349980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00350362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00350734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='00351171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10471000',harga_beli ='10471000' WHERE kode_barcode='00351402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00351568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='826000',harga_beli ='826000' WHERE kode_barcode='00351768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2518500',harga_beli ='2518500' WHERE kode_barcode='00352085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2456000',harga_beli ='2456000' WHERE kode_barcode='00352115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00352578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='15779500',harga_beli ='15779500' WHERE kode_barcode='00353157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2508000',harga_beli ='2508000' WHERE kode_barcode='00353247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7169000',harga_beli ='7169000' WHERE kode_barcode='00353473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00353488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00353513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2435000',harga_beli ='2435000' WHERE kode_barcode='00353831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00354498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00354511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2612500',harga_beli ='2612500' WHERE kode_barcode='00354615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00355579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00355959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1536500',harga_beli ='1536500' WHERE kode_barcode='00355976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00356050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00356767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='00357585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1567500',harga_beli ='1567500' WHERE kode_barcode='00357587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00358033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00358200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00358263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='00358793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1965000',harga_beli ='1965000' WHERE kode_barcode='00358826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1024500',harga_beli ='1024500' WHERE kode_barcode='00359463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00359696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00359981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00360662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4828000',harga_beli ='4828000' WHERE kode_barcode='00361161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00361344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='00361566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00361650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10534000',harga_beli ='10534000' WHERE kode_barcode='00361854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='9562000',harga_beli ='9562000' WHERE kode_barcode='00361859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00362561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2665000',harga_beli ='2665000' WHERE kode_barcode='00362735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1703500',harga_beli ='1703500' WHERE kode_barcode='00363819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00363968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00363969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00363970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2069500',harga_beli ='2069500' WHERE kode_barcode='00364071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1515500',harga_beli ='1515500' WHERE kode_barcode='00364427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3689000',harga_beli ='3689000' WHERE kode_barcode='00364429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00364470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5141500',harga_beli ='5141500' WHERE kode_barcode='00364669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00364682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2121500',harga_beli ='2121500' WHERE kode_barcode='00364833' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5392500',harga_beli ='5392500' WHERE kode_barcode='00365416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3668000',harga_beli ='3668000' WHERE kode_barcode='00365431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00365570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00365762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00365767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00365789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5152000',harga_beli ='5152000' WHERE kode_barcode='00365906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00366248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3083000',harga_beli ='3083000' WHERE kode_barcode='00366676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10429500',harga_beli ='10429500' WHERE kode_barcode='00367478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2508000',harga_beli ='2508000' WHERE kode_barcode='00367540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='11307000',harga_beli ='11307000' WHERE kode_barcode='00367860' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00367882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00367883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00367903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00368596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00368843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2100500',harga_beli ='2100500' WHERE kode_barcode='00368895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00369217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00369446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2989000',harga_beli ='2989000' WHERE kode_barcode='00370374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00370557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8193000',harga_beli ='8193000' WHERE kode_barcode='00370579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00370587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00370818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00371741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00371743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00371798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='00371825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00371867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00371889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00372265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00372564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1599000',harga_beli ='1599000' WHERE kode_barcode='00372682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00372752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00372765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2801000',harga_beli ='2801000' WHERE kode_barcode='00372869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00372915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00373508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00373737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4159500',harga_beli ='4159500' WHERE kode_barcode='00374067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6949500',harga_beli ='6949500' WHERE kode_barcode='00374222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3710000',harga_beli ='3710000' WHERE kode_barcode='00374245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00374254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='826000',harga_beli ='826000' WHERE kode_barcode='00374502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00375250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00375505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00375651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00375654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='00375776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1588500',harga_beli ='1588500' WHERE kode_barcode='00375819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00375896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00375995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00376112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00376114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='993000',harga_beli ='993000' WHERE kode_barcode='00376216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00376261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00376287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00376290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00376365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00376427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7482500',harga_beli ='7482500' WHERE kode_barcode='00376542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='00376545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00376792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00376811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00376812' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00376822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00376855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='00376871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1515500',harga_beli ='1515500' WHERE kode_barcode='00376873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00376883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2874000',harga_beli ='2874000' WHERE kode_barcode='00376903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00376966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00376970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00376980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00377242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00377266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00377280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00377412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='617000',harga_beli ='617000' WHERE kode_barcode='00377560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00377561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00377611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6385000',harga_beli ='6385000' WHERE kode_barcode='00377627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00377682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00378350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4420500',harga_beli ='4420500' WHERE kode_barcode='00378354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00378651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2174000',harga_beli ='2174000' WHERE kode_barcode='00378953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00379130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='669000',harga_beli ='669000' WHERE kode_barcode='00379132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00379374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00379385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00379386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00379395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00379541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3229500',harga_beli ='3229500' WHERE kode_barcode='00379610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='00379647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00379805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='00380043' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00380069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2048500',harga_beli ='2048500' WHERE kode_barcode='00380094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5309000',harga_beli ='5309000' WHERE kode_barcode='00380548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='00380549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4107000',harga_beli ='4107000' WHERE kode_barcode='00380550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2414000',harga_beli ='2414000' WHERE kode_barcode='00380556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2539500',harga_beli ='2539500' WHERE kode_barcode='00380569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00380577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00380578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00380592' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8412500',harga_beli ='8412500' WHERE kode_barcode='00380608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3177000',harga_beli ='3177000' WHERE kode_barcode='00380609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3877000',harga_beli ='3877000' WHERE kode_barcode='00380615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00380618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4159500',harga_beli ='4159500' WHERE kode_barcode='00380631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4504000',harga_beli ='4504000' WHERE kode_barcode='00380642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='00380708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2205000',harga_beli ='2205000' WHERE kode_barcode='00380709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00381027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2853000',harga_beli ='2853000' WHERE kode_barcode='00381055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00381273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4190500',harga_beli ='4190500' WHERE kode_barcode='00381338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1567500',harga_beli ='1567500' WHERE kode_barcode='00381402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00381407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1432000',harga_beli ='1432000' WHERE kode_barcode='00381420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1944000',harga_beli ='1944000' WHERE kode_barcode='00381429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1912500',harga_beli ='1912500' WHERE kode_barcode='00381432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1829000',harga_beli ='1829000' WHERE kode_barcode='00381433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2048500',harga_beli ='2048500' WHERE kode_barcode='00381440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='00381443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00381466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00381666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2383000',harga_beli ='2383000' WHERE kode_barcode='00381716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='00381749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1306500',harga_beli ='1306500' WHERE kode_barcode='00382044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00382139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00382145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00382150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00382638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00382672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1609500',harga_beli ='1609500' WHERE kode_barcode='00382674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00382796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00382987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00383036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00383037' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1536500',harga_beli ='1536500' WHERE kode_barcode='00383109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00383201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='00383307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1630500',harga_beli ='1630500' WHERE kode_barcode='00383319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00383328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2508000',harga_beli ='2508000' WHERE kode_barcode='00383391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00383527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='617000',harga_beli ='617000' WHERE kode_barcode='00383950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1797500',harga_beli ='1797500' WHERE kode_barcode='00384018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10398000',harga_beli ='10398000' WHERE kode_barcode='00384120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4870000',harga_beli ='4870000' WHERE kode_barcode='00384289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00384338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2571000',harga_beli ='2571000' WHERE kode_barcode='00384375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00384919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00384936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00385175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10408500',harga_beli ='10408500' WHERE kode_barcode='00385275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1693000',harga_beli ='1693000' WHERE kode_barcode='00385307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00385325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00385517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00385599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10554500',harga_beli ='10554500' WHERE kode_barcode='00385938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00386046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00386089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1672000',harga_beli ='1672000' WHERE kode_barcode='00386274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00386324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00386700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00386908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2759000',harga_beli ='2759000' WHERE kode_barcode='00386962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00387688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00387878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00388201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00388380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00388392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00388398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00388414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00388603' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00388826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00388841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00388842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2069500',harga_beli ='2069500' WHERE kode_barcode='00389311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00389711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00389714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1682500',harga_beli ='1682500' WHERE kode_barcode='00389802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00390963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00390965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='00391148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00391206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00391208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='690000',harga_beli ='690000' WHERE kode_barcode='00391236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00391242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00391288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00391569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00391615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00391732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1473500',harga_beli ='1473500' WHERE kode_barcode='00391735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00391838' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00391851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00391852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='982500',harga_beli ='982500' WHERE kode_barcode='00392432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='00392617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1860500',harga_beli ='1860500' WHERE kode_barcode='00392680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00392691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1400500',harga_beli ='1400500' WHERE kode_barcode='00392698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2832000',harga_beli ='2832000' WHERE kode_barcode='00392702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00392768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00392920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00392927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='00393006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00393009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00393010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00393011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='763000',harga_beli ='763000' WHERE kode_barcode='00393149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='711000',harga_beli ='711000' WHERE kode_barcode='00393158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00393507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00393666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00393886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='00393894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='00393897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00394087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3480000',harga_beli ='3480000' WHERE kode_barcode='00394196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00394876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00395289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3041000',harga_beli ='3041000' WHERE kode_barcode='00395332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8475000',harga_beli ='8475000' WHERE kode_barcode='00395334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1818500',harga_beli ='1818500' WHERE kode_barcode='00395347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1055500',harga_beli ='1055500' WHERE kode_barcode='00395351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00395365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00395375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00395512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00395514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00395517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00395519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00395589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00395960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00396057' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00396145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00396153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00396161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2069500',harga_beli ='2069500' WHERE kode_barcode='00396162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1536500',harga_beli ='1536500' WHERE kode_barcode='00396164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00396177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00396178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00396179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00396180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00396187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00396200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00396261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3062000',harga_beli ='3062000' WHERE kode_barcode='00396292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6792500',harga_beli ='6792500' WHERE kode_barcode='00396295' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5277500',harga_beli ='5277500' WHERE kode_barcode='00396361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='00396370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00396402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2069500',harga_beli ='2069500' WHERE kode_barcode='00396415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10523500',harga_beli ='10523500' WHERE kode_barcode='00396481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00396501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7179500',harga_beli ='7179500' WHERE kode_barcode='00396511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00396518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3062000',harga_beli ='3062000' WHERE kode_barcode='00396519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4232500',harga_beli ='4232500' WHERE kode_barcode='00396523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2989000',harga_beli ='2989000' WHERE kode_barcode='00396525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00396609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00396623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='888500',harga_beli ='888500' WHERE kode_barcode='00396778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00396875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00396876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00396878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1547000',harga_beli ='1547000' WHERE kode_barcode='00396879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00396880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='00396881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3877000',harga_beli ='3877000' WHERE kode_barcode='00396997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00396999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2414000',harga_beli ='2414000' WHERE kode_barcode='00397004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='690000',harga_beli ='690000' WHERE kode_barcode='00397045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00397046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00397107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00397211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00397212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00397215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='711000',harga_beli ='711000' WHERE kode_barcode='00397349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00397403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00397404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3762000',harga_beli ='3762000' WHERE kode_barcode='00397429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00397716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6270000',harga_beli ='6270000' WHERE kode_barcode='00397829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8078000',harga_beli ='8078000' WHERE kode_barcode='00397949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='909500',harga_beli ='909500' WHERE kode_barcode='00397962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00398401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00398405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00398406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5006000',harga_beli ='5006000' WHERE kode_barcode='00398771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4149000',harga_beli ='4149000' WHERE kode_barcode='00398780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3145500',harga_beli ='3145500' WHERE kode_barcode='00398788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00398790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1515500',harga_beli ='1515500' WHERE kode_barcode='00398791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00398841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00398883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='00398914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='00399261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00399262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00399700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00399733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00399745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00399755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2205000',harga_beli ='2205000' WHERE kode_barcode='00399773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='00399791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1662000',harga_beli ='1662000' WHERE kode_barcode='00399820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00399859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00399874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00399895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00399899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00399909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4190500',harga_beli ='4190500' WHERE kode_barcode='00399962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3887500',harga_beli ='3887500' WHERE kode_barcode='00399964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3563500',harga_beli ='3563500' WHERE kode_barcode='00399973' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00399978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1703500',harga_beli ='1703500' WHERE kode_barcode='00400050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00400173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00400175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00400176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1839500',harga_beli ='1839500' WHERE kode_barcode='00400181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='439000',harga_beli ='439000' WHERE kode_barcode='00400199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00400254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00400256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00400257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00400268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00400488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00400663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00400666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00400677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00400679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00400680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00400681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1808000',harga_beli ='1808000' WHERE kode_barcode='00400918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1003500',harga_beli ='1003500' WHERE kode_barcode='00400921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00401164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00401271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00401289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00401296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00401485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00401527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='711000',harga_beli ='711000' WHERE kode_barcode='00401649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00401659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00401680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2696500',harga_beli ='2696500' WHERE kode_barcode='00401723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00401763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1776500',harga_beli ='1776500' WHERE kode_barcode='00401791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2832000',harga_beli ='2832000' WHERE kode_barcode='00401797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1045000',harga_beli ='1045000' WHERE kode_barcode='00401803' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1693000',harga_beli ='1693000' WHERE kode_barcode='00401826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4232500',harga_beli ='4232500' WHERE kode_barcode='00402067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2853000',harga_beli ='2853000' WHERE kode_barcode='00402082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00402194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00402239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00402266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1306500',harga_beli ='1306500' WHERE kode_barcode='00402267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='00402330' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00402331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00402518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00402847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1682500',harga_beli ='1682500' WHERE kode_barcode='00402851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00402862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00402869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00402871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00402880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00402895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00402896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5194000',harga_beli ='5194000' WHERE kode_barcode='00402955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1463000',harga_beli ='1463000' WHERE kode_barcode='00402976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3584500',harga_beli ='3584500' WHERE kode_barcode='00402990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00402999' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1912500',harga_beli ='1912500' WHERE kode_barcode='00403000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00403057' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00403059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00403078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='846500',harga_beli ='846500' WHERE kode_barcode='00403696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00403697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00403700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00403703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00403704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00403715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00403878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00403879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00403905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00404012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00404020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00404022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='711000',harga_beli ='711000' WHERE kode_barcode='00404024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00404025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00404496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00404502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00404793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00404805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00404817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='00404839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1703500',harga_beli ='1703500' WHERE kode_barcode='00404843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3532500',harga_beli ='3532500' WHERE kode_barcode='00404860' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3344000',harga_beli ='3344000' WHERE kode_barcode='00404880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00404881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00405076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='10408500',harga_beli ='10408500' WHERE kode_barcode='00405086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3198000',harga_beli ='3198000' WHERE kode_barcode='00405105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00405138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00405139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5204500',harga_beli ='5204500' WHERE kode_barcode='00405155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00405168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1567500',harga_beli ='1567500' WHERE kode_barcode='00405244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1505000',harga_beli ='1505000' WHERE kode_barcode='00405267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2174000',harga_beli ='2174000' WHERE kode_barcode='00405289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00405461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00405492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='826000',harga_beli ='826000' WHERE kode_barcode='00405505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='982500',harga_beli ='982500' WHERE kode_barcode='00405507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00405538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00405655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='8391500',harga_beli ='8391500' WHERE kode_barcode='00406173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00406197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2100500',harga_beli ='2100500' WHERE kode_barcode='00406281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00406282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00406284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00406294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00406604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00406628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00406629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2100500',harga_beli ='2100500' WHERE kode_barcode='00406706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00407205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00407206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1745500',harga_beli ='1745500' WHERE kode_barcode='00407221' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00407230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00407239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00407240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00407241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00407242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00407424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00407432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00407435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00407436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00407438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1850000',harga_beli ='1850000' WHERE kode_barcode='00407443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00407452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00407456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5309000',harga_beli ='5309000' WHERE kode_barcode='00407467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2926000',harga_beli ='2926000' WHERE kode_barcode='00407483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='00407488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='00407518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00407520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3407000',harga_beli ='3407000' WHERE kode_barcode='00407871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3104000',harga_beli ='3104000' WHERE kode_barcode='00407878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00407885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00407922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00407987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='00407992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='00408004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00408016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00408017' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00408150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='00408153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00408189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00408619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1881000',harga_beli ='1881000' WHERE kode_barcode='00408668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00408693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00408695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00408718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4859500',harga_beli ='4859500' WHERE kode_barcode='00408864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2090000',harga_beli ='2090000' WHERE kode_barcode='00408866' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4096500',harga_beli ='4096500' WHERE kode_barcode='00408874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4232500',harga_beli ='4232500' WHERE kode_barcode='00408875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='00408893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1797500',harga_beli ='1797500' WHERE kode_barcode='00408894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00408942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2006500',harga_beli ='2006500' WHERE kode_barcode='00408976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1212500',harga_beli ='1212500' WHERE kode_barcode='00408978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00409024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00409038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='711000',harga_beli ='711000' WHERE kode_barcode='00409173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00409178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00409374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00409386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00409392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00409406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00409411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00409412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2184500',harga_beli ='2184500' WHERE kode_barcode='00409423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00409533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00409534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00409535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='00409725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='00409872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00409878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00409917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00409918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00409919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00409930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00409931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00410380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00410422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='418000',harga_beli ='418000' WHERE kode_barcode='00410425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00410427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00411023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00411091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5267000',harga_beli ='5267000' WHERE kode_barcode='00411134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00411150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5183500',harga_beli ='5183500' WHERE kode_barcode='00411257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1693000',harga_beli ='1693000' WHERE kode_barcode='00411403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4243000',harga_beli ='4243000' WHERE kode_barcode='00411444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2748500',harga_beli ='2748500' WHERE kode_barcode='00411452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2038000',harga_beli ='2038000' WHERE kode_barcode='00411463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00411469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00411470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00411605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00411607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00411613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00411725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='439000',harga_beli ='439000' WHERE kode_barcode='00411732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3908500',harga_beli ='3908500' WHERE kode_barcode='00411811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00411815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='805000',harga_beli ='805000' WHERE kode_barcode='00411836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00411837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00411839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00411840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00411844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00411846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00411849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00411850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00411854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00411858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00411859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00411860' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00411862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00411864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00411867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00411874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00411875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00411876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00411877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00411878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00412250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00412255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4128000',harga_beli ='4128000' WHERE kode_barcode='00412382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00412384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00412455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00412467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00412499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00412500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5256500',harga_beli ='5256500' WHERE kode_barcode='00412518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2121500',harga_beli ='2121500' WHERE kode_barcode='00412529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3198000',harga_beli ='3198000' WHERE kode_barcode='00412532' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1609500',harga_beli ='1609500' WHERE kode_barcode='00412542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='00412547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00412550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='00412727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00412740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00412743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00412744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00412828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1588500',harga_beli ='1588500' WHERE kode_barcode='00412834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6322500',harga_beli ='6322500' WHERE kode_barcode='00412836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5277500',harga_beli ='5277500' WHERE kode_barcode='00412853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='731500',harga_beli ='731500' WHERE kode_barcode='00412915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00412923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00412952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='721500',harga_beli ='721500' WHERE kode_barcode='00412986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00413059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00413062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00413066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00413123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00413126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00413127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00413128' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='752500',harga_beli ='752500' WHERE kode_barcode='00413244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5256500',harga_beli ='5256500' WHERE kode_barcode='00413261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1724500',harga_beli ='1724500' WHERE kode_barcode='00413264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00413265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00413266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00413269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00413303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2111000',harga_beli ='2111000' WHERE kode_barcode='00413448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00413450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00413455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00413456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00413457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00413469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00413475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00413544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1714000',harga_beli ='1714000' WHERE kode_barcode='00413691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='00413692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00413693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00413847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00413861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00413932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00413940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00413945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='00413995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2132000',harga_beli ='2132000' WHERE kode_barcode='00414018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00414033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00414180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00414181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00414187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1024500',harga_beli ='1024500' WHERE kode_barcode='00414199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1829000',harga_beli ='1829000' WHERE kode_barcode='00414389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2184500',harga_beli ='2184500' WHERE kode_barcode='00414394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00414410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00414411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00414438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2675500',harga_beli ='2675500' WHERE kode_barcode='00414488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1400500',harga_beli ='1400500' WHERE kode_barcode='00414519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00414531' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6239000',harga_beli ='6239000' WHERE kode_barcode='00414548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3093500',harga_beli ='3093500' WHERE kode_barcode='00414552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00414626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00414635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00414680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00415346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00415351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00415352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00415353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00415527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00415537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00415538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3208500',harga_beli ='3208500' WHERE kode_barcode='00415540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1432000',harga_beli ='1432000' WHERE kode_barcode='00415542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1411000',harga_beli ='1411000' WHERE kode_barcode='00415543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1599000',harga_beli ='1599000' WHERE kode_barcode='00415545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1327500',harga_beli ='1327500' WHERE kode_barcode='00415732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2236500',harga_beli ='2236500' WHERE kode_barcode='00415830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1954500',harga_beli ='1954500' WHERE kode_barcode='00415832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00415882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='836000',harga_beli ='836000' WHERE kode_barcode='00415885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='00415886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1588500',harga_beli ='1588500' WHERE kode_barcode='00415887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1578000',harga_beli ='1578000' WHERE kode_barcode='00415888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2665000',harga_beli ='2665000' WHERE kode_barcode='00415891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7336000',harga_beli ='7336000' WHERE kode_barcode='00415892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00415894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='00415895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='00415896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='00415899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00415942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1024500',harga_beli ='1024500' WHERE kode_barcode='00415983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='00416005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2644000',harga_beli ='2644000' WHERE kode_barcode='00416022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1515500',harga_beli ='1515500' WHERE kode_barcode='00416023' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00416024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00416070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4222000',harga_beli ='4222000' WHERE kode_barcode='00416105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00416109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00416164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00416175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1672000',harga_beli ='1672000' WHERE kode_barcode='00416209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='00416225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00416328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00416359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00416362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00416365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00416509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00416560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00416562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00416563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='826000',harga_beli ='826000' WHERE kode_barcode='00416564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='794500',harga_beli ='794500' WHERE kode_barcode='00416565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5277500',harga_beli ='5277500' WHERE kode_barcode='00416808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='439000',harga_beli ='439000' WHERE kode_barcode='00417071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3501000',harga_beli ='3501000' WHERE kode_barcode='00417075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4232500',harga_beli ='4232500' WHERE kode_barcode='00417081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7315000',harga_beli ='7315000' WHERE kode_barcode='00417167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00417400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00417466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00417516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00417517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5831500',harga_beli ='5831500' WHERE kode_barcode='00417573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3292000',harga_beli ='3292000' WHERE kode_barcode='00417574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2466500',harga_beli ='2466500' WHERE kode_barcode='00417577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='00417620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5382000',harga_beli ='5382000' WHERE kode_barcode='00417820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2612500',harga_beli ='2612500' WHERE kode_barcode='00417821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='00417824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='00417825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='930500',harga_beli ='930500' WHERE kode_barcode='00417841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1567500',harga_beli ='1567500' WHERE kode_barcode='00417848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00417960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00417963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00417966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00417989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00418009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00418011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00418012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1797500',harga_beli ='1797500' WHERE kode_barcode='00418131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00418455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1358500',harga_beli ='1358500' WHERE kode_barcode='00418457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3981500',harga_beli ='3981500' WHERE kode_barcode='00418460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5612000',harga_beli ='5612000' WHERE kode_barcode='00418461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3511500',harga_beli ='3511500' WHERE kode_barcode='00418465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00418473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='679500',harga_beli ='679500' WHERE kode_barcode='00418475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00418476' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='6186500',harga_beli ='6186500' WHERE kode_barcode='00418486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='00418487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00418489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1787000',harga_beli ='1787000' WHERE kode_barcode='00418492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='00418493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1588500',harga_beli ='1588500' WHERE kode_barcode='00418495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1599000',harga_beli ='1599000' WHERE kode_barcode='00418496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00418953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00418978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='690000',harga_beli ='690000' WHERE kode_barcode='00419021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00419060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00419079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00419129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00419171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00419180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00419192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7273500',harga_beli ='7273500' WHERE kode_barcode='00419254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00419261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2926000',harga_beli ='2926000' WHERE kode_barcode='00419405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3198000',harga_beli ='3198000' WHERE kode_barcode='00419415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3313000',harga_beli ='3313000' WHERE kode_barcode='00419432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='00419441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7033000',harga_beli ='7033000' WHERE kode_barcode='00419465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2916000',harga_beli ='2916000' WHERE kode_barcode='00419466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1933500',harga_beli ='1933500' WHERE kode_barcode='00419470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='7378000',harga_beli ='7378000' WHERE kode_barcode='00419473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='815500',harga_beli ='815500' WHERE kode_barcode='00419768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00419780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='648000',harga_beli ='648000' WHERE kode_barcode='00419785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00419786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='533000',harga_beli ='533000' WHERE kode_barcode='00419793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00419800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2957500',harga_beli ='2957500' WHERE kode_barcode='00419804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2916000',harga_beli ='2916000' WHERE kode_barcode='00419805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00419809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1181000',harga_beli ='1181000' WHERE kode_barcode='00419815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1202000',harga_beli ='1202000' WHERE kode_barcode='00419816' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3104000',harga_beli ='3104000' WHERE kode_barcode='00420051' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3302500',harga_beli ='3302500' WHERE kode_barcode='00420059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3292000',harga_beli ='3292000' WHERE kode_barcode='00420061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1390000',harga_beli ='1390000' WHERE kode_barcode='00420067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1547000',harga_beli ='1547000' WHERE kode_barcode='00420074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00420075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1432000',harga_beli ='1432000' WHERE kode_barcode='00420077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2121500',harga_beli ='2121500' WHERE kode_barcode='00420083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1871000',harga_beli ='1871000' WHERE kode_barcode='00420087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2153000',harga_beli ='2153000' WHERE kode_barcode='00420088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2686000',harga_beli ='2686000' WHERE kode_barcode='00420090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='00420091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4588000',harga_beli ='4588000' WHERE kode_barcode='00420101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2675500',harga_beli ='2675500' WHERE kode_barcode='00420107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='784000',harga_beli ='784000' WHERE kode_barcode='00420142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='449500',harga_beli ='449500' WHERE kode_barcode='00420222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00420223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00420339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00420341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420343' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='00420345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='00420346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00420347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00420349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='585500',harga_beli ='585500' WHERE kode_barcode='00420350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00420352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='564500',harga_beli ='564500' WHERE kode_barcode='00420357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00420358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3344000',harga_beli ='3344000' WHERE kode_barcode='00420364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00420365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1609500',harga_beli ='1609500' WHERE kode_barcode='00420366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1609500',harga_beli ='1609500' WHERE kode_barcode='00420367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00420368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4682000',harga_beli ='4682000' WHERE kode_barcode='00420372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00420387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='575000',harga_beli ='575000' WHERE kode_barcode='00420420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='481000',harga_beli ='481000' WHERE kode_barcode='00420421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3563500',harga_beli ='3563500' WHERE kode_barcode='00420437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1662000',harga_beli ='1662000' WHERE kode_barcode='00420447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3626500',harga_beli ='3626500' WHERE kode_barcode='00420452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00420453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='00420464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00420473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='4232500',harga_beli ='4232500' WHERE kode_barcode='00420490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2142500',harga_beli ='2142500' WHERE kode_barcode='00420496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1682500',harga_beli ='1682500' WHERE kode_barcode='00420498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00420582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='5204500',harga_beli ='5204500' WHERE kode_barcode='00420683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='596000',harga_beli ='596000' WHERE kode_barcode='00420874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00420875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00420876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='554000',harga_beli ='554000' WHERE kode_barcode='00420877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00420878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00420879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='502000',harga_beli ='502000' WHERE kode_barcode='00420880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00420881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='543500',harga_beli ='543500' WHERE kode_barcode='00420882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='00421251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='512500',harga_beli ='512500' WHERE kode_barcode='00421254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00421257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00421259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='428500',harga_beli ='428500' WHERE kode_barcode='00421263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1421500',harga_beli ='1421500' WHERE kode_barcode='00421285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1860500',harga_beli ='1860500' WHERE kode_barcode='00421286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='00421287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1014000',harga_beli ='1014000' WHERE kode_barcode='00421313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00421356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='470500',harga_beli ='470500' WHERE kode_barcode='00421372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='00421576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='1170500',harga_beli ='1170500' WHERE kode_barcode='00421577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='00421598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='2320000',harga_beli ='2320000' WHERE kode_barcode='00421604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='627000',harga_beli ='627000' WHERE kode_barcode='00421620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00421637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00421638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='658500',harga_beli ='658500' WHERE kode_barcode='00421694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00421739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00421744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='637500',harga_beli ='637500' WHERE kode_barcode='00421917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='940500',harga_beli ='940500' WHERE kode_barcode='00421918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00421919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='700500',harga_beli ='700500' WHERE kode_barcode='00421920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00421921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00421923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1045000',harga_jual='522500',harga_beli ='522500' WHERE kode_barcode='00421924' LIMIT 1;
UPDATE tm_group SET harga='1045000' WHERE kode_group = 'ME' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('ME','1045000','input','2026-09-06 11:23:32');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061124091','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZHBF-124-0','KL X SANTA KH 42 8K ','','2.050','1','100.00','2142000','0','0','15000','2143000','0','0','0','2143000','FIT','00420496','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBF-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='H1E-ZHBF-124-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061124091','2026-09-06','2.050','2026-09-06','11:24:10','PLG0031191','2143000','2143000','0','2143000','2143000','input','2026-09-06 11:24:09','F32606112409');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061124091','2026-09-06','11:24:10','FIT','2143000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0010','D','2026-09-06','11:24:10','input','PENJUALAN','F326061124091','7241887000','2143000','7244030000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061128121','input','1',' MEE2 X HW ','TOKO','PM-E','E2E-ZGXA-81-0','CC X MODEL MATA HW 15 8K ','','0.560','1','100.00','585000','0','0','15000','585000','0','0','0','585000','FIT','00411605','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2E-ZGXA-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061128121','2026-09-06','0.560','2026-09-06','11:28:13','PLG0031192','585000','585000','0','585000','585000','input','2026-09-06 11:28:12','F32606112812');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061128121','2026-09-06','11:28:13','FIT','585000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0011','D','2026-09-06','11:28:13','input','PENJUALAN','F326061128121','7244030000','585000','7244615000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061133381','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZGBA-6-0','GL X OVAL C SLEP UB 65 8K ','','2.560','1','100.00','2675000','0','0','15000','2675000','0','0','0','2675000','LIS','00414488','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBA-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='F1E-ZGBA-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061133381','2026-09-06','2.560','2026-09-06','11:33:39','PLG0031193','2675000','2675000','0','2675000','2675000','input','2026-09-06 11:33:38','F32606113338');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061133381','2026-09-06','11:33:39','LIS','2675000','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-260906-0012','D','2026-09-06','11:33:39','input','PENJUALAN','F326061133381','7244615000','2675000','7247290000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2675000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061133381' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061133382','input',' 1',' MEF1 X UB ','TOKO','PM-F','F1E-ZHXH-92-0','GL X OVAL C SLEP UB 65 8K ','','2.500','1','100.00','2612000','0','0','15000','2613000','0','0','0','2613000','LIS','00417821','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHXH-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='F1E-ZHXH-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061133382','2026-09-06','2.500','2026-09-06','11:33:39','PLG0031194','2613000','2613000','0','2613000','2613000','input','2026-09-06 11:33:38','F32606113338');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061133382','2026-09-06','11:33:39','LIS','2613000','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-260906-0013','D','2026-09-06','11:33:39','input','PENJUALAN','F326061133382','7247290000','2613000','7249903000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061133382' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061138461','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-ZIXA-210-0','GW X MODEL CAT HITAM LG PE 8K ','','0.470','1','100.00','491000','0','0','15000','491000','0','0','0','491000','SIN','00421637','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIXA-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='B1E-ZIXA-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061138461','2026-09-06','0.470','2026-09-06','11:38:47','PLG0031195','491000','491000','0','491000','491000','input','2026-09-06 11:38:46','F32606113846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061138461','2026-09-06','11:38:47','SIN','491000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0014','D','2026-09-06','11:38:47','input','PENJUALAN','F326061138461','7249903000','491000','7250394000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061206431','kasir','1',' TAE0TA DW ','TOKO','PT-E','E0TA-UDAG-120-T','CC SETENGAH RANTAI DW 16 ','','4.000','1','100.00','7360000','0','0','15000','7360000','0','0','0','7360000','AAT','T0004165','E0TA','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-UDAG-120-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E0TA-UDAG-120-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061206431','2026-09-06','4.000','2026-09-06','12:06:43','PLG0031196','7360000','7360000','0','7360000','7360000','kasir','2026-09-06 12:06:43','F32606120643');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061206431','2026-09-06','12:06:43','AAT','7360000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0015','D','2026-09-06','12:06:43','kasir','PENJUALAN','F326061206431','7250394000','7360000','7257754000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061213381','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZGXG-176-0','KL X SIEM COBRA ANAK KH 34 9K','','1.030','1','100.00','1179000','0','0','15000','1180000','0','0','0','1180000','SIN','00412577','H2J','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGXG-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='H2J-ZGXG-176-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061213381','2026-09-06','1.030','2026-09-06','12:13:39','PLG0031197','1180000','1180000','0','1180000','1180000','kasir','2026-09-06 12:13:38','F32606121338');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061213381','2026-09-06','12:13:39','SIN','1180000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0016','D','2026-09-06','12:13:39','kasir','PENJUALAN','F326061213381','7257754000','1180000','7258934000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020117','X-00020117','CC COR T 8K','GR','---','E1E','BELI','BELI001','475000','2026-09-06','0.500','1','kasir','2026-09-06 12:15:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020117','X-00020117');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0001','00402416','LIS','1','BELI','BELI001','E1E', 'X-00020117', 'CC COR T 8K','0.500','0.500','100.00','570000','475000','950000','1045000','1','475000','475000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0001','2026-09-06','2026-09-06','12:15:10','LIS','---','0.500','475000','475000','475000','475000','475000','kasir','2026-09-06 12:15:10','FB-260906-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0001','LINDA AGUSTIN','JATISRONO WONOGIRI','','','','kasir','2026-09-06 12:15:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0017','K','2026-09-06','12:15:10','kasir','PEMBELIAN UMUM','FB-260906-0001','7258934000','475000','7258459000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020118','X-00020118','GL XX CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1405000','2026-09-06','1.470','1','kasir','2026-09-06 12:15:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020118','X-00020118');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0002','F326271200381','LIS','2','BELI','BELI001','F3E', 'X-00020118', 'GL XX CAPELLA SLEP HW 8K','1.470','1.470','100.00','1478000','1405000','955782','1045000','1','1405000','1405000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.470',berat_beli_asli=berat_beli_asli+'1.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.470',berat_akhir_asli=berat_akhir_asli+'1.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0002','2026-09-06','2026-09-06','12:15:10','LIS','---','1.470','1405000','1405000','1405000','1405000','1405000','kasir','2026-09-06 12:15:10','FB-260906-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0002','LINDA','JATISRONO','','','082136963788','kasir','2026-09-06 12:15:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0018','K','2026-09-06','12:15:10','kasir','PEMBELIAN UMUM','FB-260906-0002','7258459000','1405000','7257054000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020119','X-00020119','GW X BOTORAN HATI SLEP DG 8K','GR','---','B0C','BELI','BELI001','515000','2026-09-06','0.550','1','kasir','2026-09-06 12:15:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-B0C';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B0C','X-00020119','X-00020119');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0003','F325221210182','AAT','1','BELI','BELI001','B0C', 'X-00020119', 'GW X BOTORAN HATI SLEP DG 8K','0.550','0.550','100.00','560000','515000','936364','1005000','1','515000','515000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B0C' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0003','2026-09-06','2026-09-06','12:15:58','AAT','---','0.550','515000','515000','515000','515000','515000','kasir','2026-09-06 12:15:59','FB-260906-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0003','PATMI','POHIJO SAMPUNG','','','082265326468','kasir','2026-09-06 12:15:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0019','K','2026-09-06','12:15:58','kasir','PEMBELIAN UMUM','FB-260906-0003','7257054000','515000','7256539000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020120','X-00020120','CC MODEL DAUN SLEP VAR LG 19 8K','GR','---','E1E','BELI','BELI001','515000','2026-09-06','0.530','1','kasir','2026-09-06 12:15:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020120','X-00020120');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0004','F326241149091','AAT','2','BELI','BELI001','E1E', 'X-00020120', 'CC MODEL DAUN SLEP VAR LG 19 8K','0.530','0.530','100.00','610000','515000','971698','1045000','1','515000','515000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0004','2026-09-06','2026-09-06','12:15:58','AAT','---','0.530','515000','515000','515000','515000','515000','kasir','2026-09-06 12:15:59','FB-260906-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0004','FANES','KARANGLO TEGALREJO','','','','kasir','2026-09-06 12:15:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0020','K','2026-09-06','12:15:58','kasir','PEMBELIAN UMUM','FB-260906-0004','7256539000','515000','7256024000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061222001','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZHXA-262-0','CC X MODEL MATA CM 14 8K ','','0.750','1','100.00','784000','0','0','15000','785000','0','0','0','785000','AAT','00416560','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHXA-262-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2E-ZHXA-262-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061222001','2026-09-06','0.750','2026-09-06','12:22:01','PLG0031198','785000','785000','0','785000','785000','kasir','2026-09-06 12:22:00','F32606122200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326061222001','2026-09-06','12:22:01','AAT','785000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0021','D','2026-09-06','12:22:01','kasir','PENJUALAN','F326061222001','7256024000','785000','7256809000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020121','X-00020121','CC COR MODEL SLEP CM 8K','GR','---','E1D','BELI','BELI001','932000','2026-09-06','0.980','1','kasir','2026-09-06 12:28:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020121','X-00020121');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0005','F326171023231','AAT','1','BELI','BELI001','E1D', 'X-00020121', 'CC COR MODEL SLEP CM 8K','0.980','0.980','100.00','1050000','932000','951020','1025000','1','932000','932000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0005','2026-09-06','2026-09-06','12:28:20','AAT','---','0.980','932000','932000','932000','932000','932000','kasir','2026-09-06 12:28:20','FB-260906-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0005','LASTRI','GENENG BULUKERTO','','','','kasir','2026-09-06 12:28:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0022','K','2026-09-06','12:28:20','kasir','PEMBELIAN UMUM','FB-260906-0005','7256809000','932000','7255877000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020122','X-00020122','LT X MODEL PITA SLEEP HW 8K','GR','---','D1G','BELI','BELI001','290000','2026-09-06','0.300','1','kasir','2026-09-06 12:28:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00020122','X-00020122');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0006','F326030253281','LIS','1','BELI','BELI001','D1G', 'X-00020122', 'LT X MODEL PITA SLEEP HW 8K','0.300','0.300','100.00','325000','290000','966667','1085000','1','290000','290000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0006','2026-09-06','2026-09-06','12:28:48','LIS','---','0.300','290000','290000','290000','290000','290000','kasir','2026-09-06 12:28:49','FB-260906-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0006','SUNARSIH','JANGGIR SUMBER','','','','kasir','2026-09-06 12:28:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0023','K','2026-09-06','12:28:48','kasir','PEMBELIAN UMUM','FB-260906-0006','7255877000','290000','7255587000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060109561','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZGXI-204-0','CC X MODEL MATA CM 10 8K ','','0.800','1','100.00','836000','0','0','15000','836000','0','0','0','836000','SIN','00412923','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXI-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2E-ZGXI-204-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060109561','2026-09-06','0.800','2026-09-06','13:09:56','PLG0031199','836000','836000','0','836000','836000','kasir','2026-09-06 13:09:56','F32606010956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060109561','2026-09-06','13:09:56','SIN','836000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0024','D','2026-09-06','13:09:56','kasir','PENJUALAN','F326060109561','7255587000','836000','7256423000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060127421','kasir','1',' MGPFG X KH','TOKO','PM-P','PFG-YIXE-121-0','GL X WG TIFF SLEP KH 8K ','','2.010','1','100.00','2181000','0','0','15000','2160000','0','0','0','2160000','LIS','00368136','PFG','0','0','-','1','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFG-YIXE-121-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='PFG-YIXE-121-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060127421','2026-09-06','2.010','2026-09-06','13:27:42','PLG0031200','2160000','2160000','0','2160000','2160000','kasir','2026-09-06 13:27:42','F32606012742');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060127421','2026-09-06','13:27:42','LIS','2160000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0025','D','2026-09-06','13:27:42','kasir','PENJUALAN','F326060127421','7256423000','2160000','7258583000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060143371','kasir','1',' MFE2F KH 1','TOKO','PM-E','E2F-ZHBI-141-0','CC MODEL PAKU MATA SLEP KH 16 8K ','','0.400','1','100.00','426000','0','0','15000','427000','0','0','0','427000','FIT','00421266','E2F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHBI-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='E2F-ZHBI-141-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060143371','2026-09-06','0.400','2026-09-06','13:43:38','PLG0031201','427000','427000','0','427000','427000','kasir','2026-09-06 13:43:37','F32606014337');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060143371','2026-09-06','13:43:38','FIT','427000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0026','D','2026-09-06','13:43:38','kasir','PENJUALAN','F326060143371','7258583000','427000','7259010000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020123','X-00020123','CC COR M 8K','GR','---','E2E','BELI','BELI001','675000','2026-09-06','1.000','1','kasir','2026-09-06 13:46:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020123','X-00020123');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0007','F323051142291','LIS','1','BELI','BELI001','E2E', 'X-00020123', 'CC COR M 8K','1.000','1.000','100.00','466000','675000','675000','1045000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0007','2026-09-06','2026-09-06','13:46:43','LIS','---','1.000','675000','675000','675000','675000','675000','kasir','2026-09-06 13:46:44','FB-260906-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0007','KRISTIN','KISMANTORO','','','','kasir','2026-09-06 13:46:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0027','K','2026-09-06','13:46:43','kasir','PEMBELIAN UMUM','FB-260906-0007','7259010000','675000','7258335000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020124','X-00020124','CC X MODEL DAUN SLEP LG 8 8K','GR','---','E1E','BELI','BELI001','407000','2026-09-06','0.420','1','kasir','2026-09-06 13:49:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020124','X-00020124');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0008','F326161156212','AAT','1','BELI','BELI001','E1E', 'X-00020124', 'CC X MODEL DAUN SLEP LG 8 8K','0.420','0.420','100.00','498000','407000','969048','1045000','1','407000','407000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0008','2026-09-06','2026-09-06','13:49:18','AAT','---','0.420','407000','407000','407000','407000','407000','kasir','2026-09-06 13:49:18','FB-260906-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0008','NADIA','MIRICINDE PWO','','','','kasir','2026-09-06 13:49:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0028','K','2026-09-06','13:49:18','kasir','PEMBELIAN UMUM','FB-260906-0008','7258335000','407000','7257928000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020125','X-00020125','CC WEDDING MATA CM 12 8K','GR','---','E2D','BELI','BELI001','960000','2026-09-06','1.010','1','kasir','2026-09-06 13:49:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020125','X-00020125');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260906-0009','F326161156211','AAT','2','BELI','BELI001','E2D', 'X-00020125', 'CC WEDDING MATA CM 12 8K','1.010','1.010','100.00','1177000','960000','950495','1025000','1','960000','960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260906-0009','2026-09-06','2026-09-06','13:49:18','AAT','---','1.010','960000','960000','960000','960000','960000','kasir','2026-09-06 13:49:18','FB-260906-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260906-0009','NADIA','MIRICINDE PWO','','','','kasir','2026-09-06 13:49:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260906-0029','K','2026-09-06','13:49:18','kasir','PEMBELIAN UMUM','FB-260906-0009','7257928000','960000','7256968000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060158451','kasir','1',' MDA1D X PM','TOKO','PM-A','A1D-ZDBG-22-0','AT X ITALY SLEP MATA VAR PM 8K ','','1.070','1','100.00','1097000','0','0','15000','1098000','0','0','0','1098000','LIS','00401265','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDBG-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-09-06' AND kode_barang='A1D-ZDBG-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060158451','2026-09-06','1.070','2026-09-06','13:58:45','PLG0031202','1098000','1098000','0','1098000','1098000','kasir','2026-09-06 13:58:45','F32606015845');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060158451','2026-09-06','13:58:45','LIS','1098000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0030','D','2026-09-06','13:58:45','kasir','PENJUALAN','F326060158451','7256968000','1098000','7258066000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060205231','input','1',' MEF3E PM ','TOKO','PM-F','F3E-ZGBI-136-0','GL ANAK VERONA SLEP PM 8K ','','2.070','1','100.00','2163000','0','0','15000','2163000','0','0','0','2163000','SIN','00415896','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBI-136-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='2026-09-06' AND kode_barang='F3E-ZGBI-136-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060205231','2026-09-06','2.070','2026-09-06','14:05:24','PLG0031203','2163000','2163000','0','2163000','2163000','input','2026-09-06 14:05:23','F32606020523');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-06','F326060205231','2026-09-06','14:05:24','SIN','2163000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260906-0031','D','2026-09-06','14:05:24','input','PENJUALAN','F326060205231','7258066000','2163000','7260229000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060109561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060109561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060109561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060127421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060127421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060127421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060143371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060143371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060143371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060158451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060158451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060158451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060205231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060205231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060205231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060917031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060917031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060917031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060924111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060924111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060924111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060924112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060924112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060924112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060929311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060929311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060929311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061028171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061028171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061028171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061028172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061028172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061028172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061107581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061107581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061107581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061110021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061110021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061110021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061124091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061124091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061124091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061128121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061128121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061128121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061133381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061133382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061133382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061138461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061138461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061138461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061206431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061206431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061206431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061213381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061213381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061213381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061222001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061222001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061222001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260906-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260906-0009';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-06' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260907-0001','D','2026-09-07','15:16:35','SYSTEM','SALDO AWAL','SALDO AWAL','0','7260229000','7260229000');
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-260907-0001','D','2026-09-07','15:16:35','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260907-0001','D','2026-09-07','15:16:35','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260907-0001','D','2026-09-07','15:16:35','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
UPDATE tp_system SET tgl_system='2026-09-07';