INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','08:53:20');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260114-0001','1','TFC-ZAAC-33-0','1','2.810','2.810','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-ZAAC-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-ZAAC-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-ZAAC-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-ZAAC-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2026-01-14 08:53:32' WHERE kode_barang='TFC-ZAAC-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-ZAAC-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-14 08:53:32','TOKO','TFCBR','TFC','TFC-ZAAC-33-0','1','2.810','2.810','1','2.810','2.810','75.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-ZAAC-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZAAC-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-01-14' WHERE no_faktur_beli='FB-251224-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260114-0001','2026-01-14','08:53','2.810','kasir','2026-01-14 08:53:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260114-0002','1','TFG-ZAAC-31-0','1','6.250','6.250','TOKO','TFG.BALIK','TOKO','TFGBR');
DELETE FROM tm_barang WHERE kode_barang='TFG-ZAAC-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFG-ZAAC-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFG-ZAAC-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFG-ZAAC-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGBR',tgl_last_beli='2026-01-14 08:53:49' WHERE kode_barang='TFG-ZAAC-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFG-ZAAC-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-14 08:53:49','TOKO','TFGBR','TFG','TFG-ZAAC-31-0','1','6.250','6.250','1','6.250','6.250','75.00');
DELETE FROM tm_dept WHERE kode_dept='TFG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFG-ZAAC-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFG-ZAAC-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-01-14' WHERE no_faktur_beli='FB-251223-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260114-0002','2026-01-14','08:53','6.250','kasir','2026-01-14 08:53:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','10:35:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','10:48:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','11:10:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','13:14:13');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0001','kasir','1',' 700K-16-20','TOKO','BIPPER','PBDG-YLXD-120-0','CINCIN SILVER 925 ','','4.350','1','100.00','267000','0','0','16950','700000','0','0','0','700000','SUL','00040300','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXD-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.350',berat_jual_asli=berat_jual_asli+'4.350',stock_jual='1',berat_akhir=berat_akhir-'4.350',berat_akhir_asli=berat_akhir_asli-'4.350',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PBDG-YLXD-120-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0001','2026-01-14','4.350','2026-01-14','13:23:23','PLG0008797','700000','700000','0','700000','0','kasir','2026-01-14 13:23:22','FJ-260114-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0001','2026-01-14','13:23:23','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0002','2026-01-14','2026-01-14 13:23:22','PENJUALAN : FJ-260114-0001','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0003','D','2026-01-14','13:23:23','TBC','PENJUALAN','FJ-260114-0001','19359801514','700000','19360501514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-260114-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0002','kasir',' 1',' 950K-135-2','TOKO','BIPPER','PBDG-YLBE-7-0','CINCIN SILVER 925 ','','1.930','1','100.00','119000','0','0','16950','950000','0','0','0','950000','SUL','00040691','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLBE-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PBDG-YLBE-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0002','2026-01-14','1.930','2026-01-14','13:23:23','PLG0008798','950000','950000','0','950000','0','kasir','2026-01-14 13:23:22','FJ-260114-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0002','2026-01-14','13:23:23','SUL','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0003','2026-01-14','2026-01-14 13:23:22','PENJUALAN : FJ-260114-0002','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0004','D','2026-01-14','13:23:23','TBC','PENJUALAN','FJ-260114-0002','19360501514','950000','19361451514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1650000' WHERE no_faktur_jual='FJ-260114-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01676','SULIS','1','CC SILVER','SZ 17 PUTIH GLOSY FONT BERKSHIRE SWASH','3.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01676','2026-01-14','2026-01-14','14:14:57','PLG0008799','kasir','2026-01-24','kasir','2026-01-14 14:14:57','3.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01677','SULIS','1','SEPASANG SILVER','CWE SZ 10 CWO SZ 12 5 FONT BRUSH SCRIPT','6.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01677','2026-01-14','2026-01-14','14:16:29','PLG0008800','kasir','2026-01-24','kasir','2026-01-14 14:16:29','6.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0003','kasir','1',' 700K-11-20','TOKO','BIPPER','PBDG-YLXD-126-0','CINCIN SILVER 925 ','','1.180','1','100.00','73000','0','0','16950','399000','0','0','0','399000','SUL','00040306','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXD-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PBDG-YLXD-126-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0003','2026-01-14','1.180','2026-01-14','14:41:34','PLG0008801','399000','399000','0','399000','0','kasir','2026-01-14 14:41:33','FJ-260114-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0003','2026-01-14','14:41:34','SUL','399000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0004','2026-01-14','2026-01-14 14:41:33','PENJUALAN : FJ-260114-0003','.','TBC','399000','399000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0005','D','2026-01-14','14:41:34','TBC','PENJUALAN','FJ-260114-0003','19361451514','399000','19361850514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='399000' WHERE no_faktur_jual='FJ-260114-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0004','kasir',' 1',' 500K-20-21','TOKO','BIPPER','PBDG-YLCA-16-0','CINCIN SILVER 925 ','','2.020','1','100.00','124000','0','0','16950','400000','0','0','0','400000','SUL','00040735','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLCA-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PBDG-YLCA-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0004','2026-01-14','2.020','2026-01-14','14:41:34','PLG0008802','400000','400000','0','400000','0','kasir','2026-01-14 14:41:33','FJ-260114-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0004','2026-01-14','14:41:34','SUL','400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0005','2026-01-14','2026-01-14 14:41:33','PENJUALAN : FJ-260114-0004','.','TBC','400000','400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0006','D','2026-01-14','14:41:34','TBC','PENJUALAN','FJ-260114-0004','19361850514','400000','19362250514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='799000' WHERE no_faktur_jual='FJ-260114-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-01-14 ','14:44:39');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01604','SULIS','1','GOLD','WED RING','','','2.000','','50.00','1','2470000','1950000','0','700000','4600000','sz 13 putih doff semprot. 1 zircon','font berkshire swash grf Vikry 28','berat akhir jangan lebih dari contoh model','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260114-0006','2026-01-14','2026-01-14 15:28:01','PESANAN : DP-01604','.','TBC','3680000','3680000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0007','D','2026-01-14','15:28:01','TBC','PESANAN','DP-01604','19362250514','3680000','19365930514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01604','2026-01-14','2026-01-14','15:28:01','PLG0008803','SULIS','2026-02-14','kasir','2026-01-14 15:28:01','2.000','0','0','0','3680000','0','700000','4600000','4600000','920000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01605','SULIS','1','PLD','WED RING','','','4.000','','10.00','1','2365000','300000','0','700000','1900000','model tanpa mata sz 25 putih doff semprot','font berkshire swash grf Putri 28','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260114-0007','2026-01-14','2026-01-14 15:30:15','PESANAN : DP-01605','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0008','D','2026-01-14','15:30:15','TBC','PESANAN','DP-01605','19365930514','950000','19366880514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01605','2026-01-14','2026-01-14','15:30:15','PLG0008804','SULIS','2026-02-14','kasir','2026-01-14 15:30:15','4.000','0','0','0','950000','0','700000','1900000','1900000','950000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0004';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0005','kasir','1',' PLBDG-0009','TOKO','BIPPLD','PLBDG-YKXD-24-0','CINCIN PALADIJ PLBDG-00093 ','','4.320','1','6.00','611000','0','0','16950','1996000','0','0','0','1996000','HELMI','00039471','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YKXD-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.320',berat_jual_asli=berat_jual_asli+'4.320',stock_jual='1',berat_akhir=berat_akhir-'4.320',berat_akhir_asli=berat_akhir_asli-'4.320',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PLBDG-YKXD-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0005','2026-01-14','4.320','2026-01-14','17:52:57','PLG0008805','1996000','1996000','0','1996000','0','kasir','2026-01-14 17:52:57','FJ-260114-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0005','2026-01-14','17:52:57','HELMI','1996000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0008','2026-01-14','2026-01-14 17:52:57','PENJUALAN : FJ-260114-0005','.','TBC','1996000','1996000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0009','D','2026-01-14','17:52:57','TBC','PENJUALAN','FJ-260114-0005','19366880514','1996000','19368876514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1996000' WHERE no_faktur_jual='FJ-260114-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0006','kasir','1',' DP-01519BI','TOKO','BIPPSN','PSPRT-YLCX-6-0','CINCIN PERAK','','3.350','1','100.00','206000','0','0','16950','700000','0','0','0','700000','SUL','00040716','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YLCX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PSPRT-YLCX-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0006','2026-01-14','3.350','2026-01-14','18:01:47','PLG0008806','700000','700000','0','700000','0','kasir','2026-01-14 18:01:46','FJ-260114-0006','DP-01519','700000');
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-01-14','FJ-260114-0006','2026-01-14','18:01:47','SUL','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260114-0006' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01606','SULIS','1','PER','WED RING','','','3.000','','925.00','1','60000','0','700000','0','700000','sz 28 putih glosy','font brush script','grf Wianyta','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260114-0009','2026-01-14','2026-01-14 18:31:28','PESANAN : DP-01606','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0010','D','2026-01-14','18:31:28','TBC','PESANAN','DP-01606','19368876514','700000','19369576514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01606','2026-01-14','2026-01-14','18:31:28','PLG0008807','SULIS','2026-02-04','kasir','2026-01-14 18:31:28','3.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01607','SULIS','1','PLD','WED RING','','','1.500','','10.00','1','2365000','300000','0','750000','1200000','9 zircon putih glosy','sz 11 font brush script','grf Andri','90000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260114-0010','2026-01-14','2026-01-14 18:38:06','PESANAN : DP-01607','.','TBC','645000','645000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0011','D','2026-01-14','18:38:06','TBC','PESANAN','DP-01607','19369576514','645000','19370221514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01607','2026-01-14','2026-01-14','18:38:06','PLG0008808','SULIS','2026-02-04','kasir','2026-01-14 18:38:06','1.500','0','0','0','645000','0','750000','1290000','1290000','645000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0006';
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8728500',harga_beli ='8728500' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7882500',harga_beli ='7882500' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8646000',harga_beli ='8646000' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5839500',harga_beli ='5839500' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9368000',harga_beli ='9368000' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9182500',harga_beli ='9182500' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7428500',harga_beli ='7428500' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12360000',harga_beli ='12360000' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12174000',harga_beli ='12174000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5757000',harga_beli ='5757000' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5943000',harga_beli ='5943000' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3033500',harga_beli ='3033500' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2992000',harga_beli ='2992000' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12607500',harga_beli ='12607500' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='48737500',harga_beli ='48737500' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4230000',harga_beli ='4230000' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8254000',harga_beli ='8254000' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12504500',harga_beli ='12504500' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8614500',harga_beli ='8614500' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6376000',harga_beli ='6376000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19107000',harga_beli ='19107000' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6974500',harga_beli ='6974500' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7057000',harga_beli ='7057000' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5674500',harga_beli ='5674500' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2806500',harga_beli ='2806500' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2765000',harga_beli ='2765000' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9182500',harga_beli ='9182500' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9657000',harga_beli ='9657000' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13433000',harga_beli ='13433000' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5468000',harga_beli ='5468000' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5963500',harga_beli ='5963500' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7413500',harga_beli ='7413500' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4189000',harga_beli ='4189000' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4993500',harga_beli ='4993500' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4209500',harga_beli ='4209500' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10234500',harga_beli ='10234500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3859000',harga_beli ='3859000' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4024000',harga_beli ='4024000' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5097000',harga_beli ='5097000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7181000',harga_beli ='7181000' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7201500',harga_beli ='7201500' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8873000',harga_beli ='8873000' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4519000',harga_beli ='4519000' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6809500',harga_beli ='6809500' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6458500',harga_beli ='6458500' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6170000',harga_beli ='6170000' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8377500',harga_beli ='8377500' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6541000',harga_beli ='6541000' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4560500',harga_beli ='4560500' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9698000',harga_beli ='9698000' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5901500',harga_beli ='5901500' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6252500',harga_beli ='6252500' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7346000',harga_beli ='7346000' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6933000',harga_beli ='6933000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7160000',harga_beli ='7160000' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6562000',harga_beli ='6562000' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7841000',harga_beli ='7841000' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6892000',harga_beli ='6892000' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7098500',harga_beli ='7098500' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5674500',harga_beli ='5674500' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6809500',harga_beli ='6809500' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6685500',harga_beli ='6685500' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8171500',harga_beli ='8171500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11122000',harga_beli ='11122000' WHERE kode_barcode='00020174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5922000',harga_beli ='5922000' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6046000',harga_beli ='6046000' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10152000',harga_beli ='10152000' WHERE kode_barcode='00020190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8192000',harga_beli ='8192000' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6004500',harga_beli ='6004500' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='47507500',harga_beli ='47507500' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6562000',harga_beli ='6562000' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7160000',harga_beli ='7160000' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4911000',harga_beli ='4911000' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5860500',harga_beli ='5860500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5406500',harga_beli ='5406500' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7923500',harga_beli ='7923500' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8934500',harga_beli ='8934500' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6520500',harga_beli ='6520500' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6273000',harga_beli ='6273000' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9223500',harga_beli ='9223500' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5351500',harga_beli ='5351500' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4307500',harga_beli ='4307500' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='24798000',harga_beli ='24798000' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13730500',harga_beli ='13730500' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9867000',harga_beli ='9867000' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3968000',harga_beli ='3968000' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11355000',harga_beli ='11355000' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8457500',harga_beli ='8457500' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8666500',harga_beli ='8666500' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6727000',harga_beli ='6727000' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8934500',harga_beli ='8934500' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5551000',harga_beli ='5551000' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9698000',harga_beli ='9698000' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8027000',harga_beli ='8027000' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16053500',harga_beli ='16053500' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11472500',harga_beli ='11472500' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12690000',harga_beli ='12690000' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4203000',harga_beli ='4203000' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4203000',harga_beli ='4203000' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15042500',harga_beli ='15042500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11472500',harga_beli ='11472500' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3632000',harga_beli ='3632000' WHERE kode_barcode='00021950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5035000',harga_beli ='5035000' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6128500',harga_beli ='6128500' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5674500',harga_beli ='5674500' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5385500',harga_beli ='5385500' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6850500',harga_beli ='6850500' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6004500',harga_beli ='6004500' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7738000',harga_beli ='7738000' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7717500',harga_beli ='7717500' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5984000',harga_beli ='5984000' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5654000',harga_beli ='5654000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5592000',harga_beli ='5592000' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10730000',harga_beli ='10730000' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7152500',harga_beli ='7152500' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9371500',harga_beli ='9371500' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10232500',harga_beli ='10232500' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7413500',harga_beli ='7413500' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7361500',harga_beli ='7361500' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10544000',harga_beli ='10544000' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13782500',harga_beli ='13782500' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7573000',harga_beli ='7573000' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7387500',harga_beli ='7387500' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5200000',harga_beli ='5200000' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5592000',harga_beli ='5592000' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8439500',harga_beli ='8439500' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19212000',harga_beli ='19212000' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11163000',harga_beli ='11163000' WHERE kode_barcode='00022659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5925500',harga_beli ='5925500' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7439500',harga_beli ='7439500' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7961500',harga_beli ='7961500' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11981500',harga_beli ='11981500' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11015500',harga_beli ='11015500' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7283000',harga_beli ='7283000' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9789000',harga_beli ='9789000' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5221000',harga_beli ='5221000' WHERE kode_barcode='00022822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9319000',harga_beli ='9319000' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7257000',harga_beli ='7257000' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3900000',harga_beli ='3900000' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5571500',harga_beli ='5571500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7469500',harga_beli ='7469500' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9449500',harga_beli ='9449500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5200000',harga_beli ='5200000' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9780500',harga_beli ='9780500' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6685500',harga_beli ='6685500' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8066000',harga_beli ='8066000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11204500',harga_beli ='11204500' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='45783500',harga_beli ='45783500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23429500',harga_beli ='23429500' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4643000',harga_beli ='4643000' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6149000',harga_beli ='6149000' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7593500',harga_beli ='7593500' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10461500',harga_beli ='10461500' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4024000',harga_beli ='4024000' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6632000',harga_beli ='6632000' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6555500',harga_beli ='6555500' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6504000',harga_beli ='6504000' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7242500',harga_beli ='7242500' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10396000',harga_beli ='10396000' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10345000',harga_beli ='10345000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7400500',harga_beli ='7400500' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8040500',harga_beli ='8040500' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13136000',harga_beli ='13136000' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8578000',harga_beli ='8578000' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10447500',harga_beli ='10447500' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7426000',harga_beli ='7426000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11625500',harga_beli ='11625500' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10857000',harga_beli ='10857000' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8655000',harga_beli ='8655000' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10882500',harga_beli ='10882500' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6581000',harga_beli ='6581000' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5612500',harga_beli ='5612500' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5121500',harga_beli ='5121500' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13948500',harga_beli ='13948500' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7057000',harga_beli ='7057000' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3136500',harga_beli ='3136500' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2373000',harga_beli ='2373000' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5468000',harga_beli ='5468000' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7469500',harga_beli ='7469500' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8852000',harga_beli ='8852000' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8852000',harga_beli ='8852000' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18436500',harga_beli ='18436500' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10069500',harga_beli ='10069500' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12496000',harga_beli ='12496000' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4312500',harga_beli ='4312500' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11452000',harga_beli ='11452000' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4609500',harga_beli ='4609500' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6087000',harga_beli ='6087000' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6685500',harga_beli ='6685500' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6479500',harga_beli ='6479500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5633500',harga_beli ='5633500' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6325000',harga_beli ='6325000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6603000',harga_beli ='6603000' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3198500',harga_beli ='3198500' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8192000',harga_beli ='8192000' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9064500',harga_beli ='9064500' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5551000',harga_beli ='5551000' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9368000',harga_beli ='9368000' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6933000',harga_beli ='6933000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7573000',harga_beli ='7573000' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7284000',harga_beli ='7284000' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9636500',harga_beli ='9636500' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5551000',harga_beli ='5551000' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8860000',harga_beli ='8860000' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5406500',harga_beli ='5406500' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7779000',harga_beli ='7779000' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3363500',harga_beli ='3363500' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4189000',harga_beli ='4189000' WHERE kode_barcode='00024082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5509500',harga_beli ='5509500' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5365000',harga_beli ='5365000' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4379000',harga_beli ='4379000' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7944500',harga_beli ='7944500' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7181000',harga_beli ='7181000' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8274500',harga_beli ='8274500' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6397000',harga_beli ='6397000' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6293500',harga_beli ='6293500' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11864500',harga_beli ='11864500' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4581000',harga_beli ='4581000' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6458500',harga_beli ='6458500' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7428500',harga_beli ='7428500' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7923500',harga_beli ='7923500' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15042500',harga_beli ='15042500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19148500',harga_beli ='19148500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16413500',harga_beli ='16413500' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8604500',harga_beli ='8604500' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00026882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5736500',harga_beli ='5736500' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3281000',harga_beli ='3281000' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5860500',harga_beli ='5860500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10152000',harga_beli ='10152000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5674500',harga_beli ='5674500' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11369500',harga_beli ='11369500' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5943000',harga_beli ='5943000' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5509500',harga_beli ='5509500' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5282500',harga_beli ='5282500' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17910500',harga_beli ='17910500' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4808000',harga_beli ='4808000' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4635000',harga_beli ='4635000' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13453500',harga_beli ='13453500' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2187500',harga_beli ='2187500' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8481000',harga_beli ='8481000' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6862500',harga_beli ='6862500' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8666500',harga_beli ='8666500' WHERE kode_barcode='00028061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5158500',harga_beli ='5158500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12463000',harga_beli ='12463000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12316500',harga_beli ='12316500' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8399000',harga_beli ='8399000' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11266500',harga_beli ='11266500' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3738500',harga_beli ='3738500' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8088500',harga_beli ='8088500' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5716000',harga_beli ='5716000' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9653500',harga_beli ='9653500' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5324000',harga_beli ='5324000' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4507000',harga_beli ='4507000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10441000',harga_beli ='10441000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5633500',harga_beli ='5633500' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13417500',harga_beli ='13417500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4932000',harga_beli ='4932000' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7579500',harga_beli ='7579500' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6401500',harga_beli ='6401500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3790000',harga_beli ='3790000' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3841000',harga_beli ='3841000' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3764500',harga_beli ='3764500' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4609500',harga_beli ='4609500' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4481500',harga_beli ='4481500' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4174000',harga_beli ='4174000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6581000',harga_beli ='6581000' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4849000',harga_beli ='4849000' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2146000',harga_beli ='2146000' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2063500',harga_beli ='2063500' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3446000',harga_beli ='3446000' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3797000',harga_beli ='3797000' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3755500',harga_beli ='3755500' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3175500',harga_beli ='3175500' WHERE kode_barcode='00031074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6211000',harga_beli ='6211000' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8687000',harga_beli ='8687000' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6562000',harga_beli ='6562000' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8988000',harga_beli ='8988000' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='22202000',harga_beli ='22202000' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='20531000',harga_beli ='20531000' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7139500',harga_beli ='7139500' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7042000',harga_beli ='7042000' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12880000',harga_beli ='12880000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6069000',harga_beli ='6069000' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='35592500',harga_beli ='35592500' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18820500',harga_beli ='18820500' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6231500',harga_beli ='6231500' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5365000',harga_beli ='5365000' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8109500',harga_beli ='8109500' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7944500',harga_beli ='7944500' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4705000',harga_beli ='4705000' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5798500',harga_beli ='5798500' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7077500',harga_beli ='7077500' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5365000',harga_beli ='5365000' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5014500',harga_beli ='5014500' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6809500',harga_beli ='6809500' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6706500',harga_beli ='6706500' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7098500',harga_beli ='7098500' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4828500',harga_beli ='4828500' WHERE kode_barcode='00031285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3363500',harga_beli ='3363500' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00031332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7676000',harga_beli ='7676000' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6128500',harga_beli ='6128500' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5654000',harga_beli ='5654000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4374500',harga_beli ='4374500' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4354000',harga_beli ='4354000' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2889000',harga_beli ='2889000' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7222000',harga_beli ='7222000' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3384000',harga_beli ='3384000' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5179500',harga_beli ='5179500' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7490500',harga_beli ='7490500' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6211000',harga_beli ='6211000' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6850500',harga_beli ='6850500' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7593500',harga_beli ='7593500' WHERE kode_barcode='00031400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8790500',harga_beli ='8790500' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6727000',harga_beli ='6727000' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4932000',harga_beli ='4932000' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5406500',harga_beli ='5406500' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6871500',harga_beli ='6871500' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6293500',harga_beli ='6293500' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7676000',harga_beli ='7676000' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5592000',harga_beli ='5592000' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3693500',harga_beli ='3693500' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8088500',harga_beli ='8088500' WHERE kode_barcode='00031415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8109500',harga_beli ='8109500' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6149000',harga_beli ='6149000' WHERE kode_barcode='00031455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8501500',harga_beli ='8501500' WHERE kode_barcode='00031457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9368000',harga_beli ='9368000' WHERE kode_barcode='00031459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7387000',harga_beli ='7387000' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8962500',harga_beli ='8962500' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7144500',harga_beli ='7144500' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5757000',harga_beli ='5757000' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4539500',harga_beli ='4539500' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5179500',harga_beli ='5179500' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7016000',harga_beli ='7016000' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6789000',harga_beli ='6789000' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8439500',harga_beli ='8439500' WHERE kode_barcode='00031503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6768000',harga_beli ='6768000' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5117500',harga_beli ='5117500' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7593500',harga_beli ='7593500' WHERE kode_barcode='00031515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6683500',harga_beli ='6683500' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4558000',harga_beli ='4558000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1792500',harga_beli ='1792500' WHERE kode_barcode='00031518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7246500',harga_beli ='7246500' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6350500',harga_beli ='6350500' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9628000',harga_beli ='9628000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3095500',harga_beli ='3095500' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3074500',harga_beli ='3074500' WHERE kode_barcode='00031534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15235500',harga_beli ='15235500' WHERE kode_barcode='00031558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5044500',harga_beli ='5044500' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1792500',harga_beli ='1792500' WHERE kode_barcode='00031564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6530000',harga_beli ='6530000' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5659000',harga_beli ='5659000' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4251000',harga_beli ='4251000' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6562000',harga_beli ='6562000' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4003000',harga_beli ='4003000' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7733000',harga_beli ='7733000' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3425500',harga_beli ='3425500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4230000',harga_beli ='4230000' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6438000',harga_beli ='6438000' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3687500',harga_beli ='3687500' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10575500',harga_beli ='10575500' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9512500',harga_beli ='9512500' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2373000',harga_beli ='2373000' WHERE kode_barcode='00031618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5633500',harga_beli ='5633500' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3838000',harga_beli ='3838000' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18027000',harga_beli ='18027000' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3098500',harga_beli ='3098500' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5282500',harga_beli ='5282500' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7989500',harga_beli ='7989500' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6623500',harga_beli ='6623500' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17229500',harga_beli ='17229500' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3467000',harga_beli ='3467000' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7067500',harga_beli ='7067500' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5736500',harga_beli ='5736500' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5966500',harga_beli ='5966500' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8962500',harga_beli ='8962500' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8143000',harga_beli ='8143000' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7222000',harga_beli ='7222000' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4003000',harga_beli ='4003000' WHERE kode_barcode='00031826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2612000',harga_beli ='2612000' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3900000',harga_beli ='3900000' WHERE kode_barcode='00031855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4416000',harga_beli ='4416000' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6709000',harga_beli ='6709000' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10473000',harga_beli ='10473000' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7614000',harga_beli ='7614000' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7366500',harga_beli ='7366500' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6273000',harga_beli ='6273000' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7016000',harga_beli ='7016000' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4581000',harga_beli ='4581000' WHERE kode_barcode='00031913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='22119500',harga_beli ='22119500' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3198500',harga_beli ='3198500' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17580500',harga_beli ='17580500' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6727000',harga_beli ='6727000' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2724000',harga_beli ='2724000' WHERE kode_barcode='00032198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2600000',harga_beli ='2600000' WHERE kode_barcode='00032209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2125500',harga_beli ='2125500' WHERE kode_barcode='00032211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3838000',harga_beli ='3838000' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2228500',harga_beli ='2228500' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='25483000',harga_beli ='25483000' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17477000',harga_beli ='17477000' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2744500',harga_beli ='2744500' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5097000',harga_beli ='5097000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3693500',harga_beli ='3693500' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4539500',harga_beli ='4539500' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4643000',harga_beli ='4643000' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2167000',harga_beli ='2167000' WHERE kode_barcode='00032365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6314000',harga_beli ='6314000' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3157000',harga_beli ='3157000' WHERE kode_barcode='00032372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16961500',harga_beli ='16961500' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3969000',harga_beli ='3969000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2290500',harga_beli ='2290500' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3487500',harga_beli ='3487500' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10255500',harga_beli ='10255500' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3136500',harga_beli ='3136500' WHERE kode_barcode='00032479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6933000',harga_beli ='6933000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8171500',harga_beli ='8171500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11720500',harga_beli ='11720500' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6299500',harga_beli ='6299500' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14314000',harga_beli ='14314000' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6555500',harga_beli ='6555500' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7989500',harga_beli ='7989500' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7426000',harga_beli ='7426000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='30497000',harga_beli ='30497000' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4684000',harga_beli ='4684000' WHERE kode_barcode='00032602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11864500',harga_beli ='11864500' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8040500',harga_beli ='8040500' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2125500',harga_beli ='2125500' WHERE kode_barcode='00032668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9801500',harga_beli ='9801500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16695500',harga_beli ='16695500' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6933000',harga_beli ='6933000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5695000',harga_beli ='5695000' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2517500',harga_beli ='2517500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7989500',harga_beli ='7989500' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='22615000',harga_beli ='22615000' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5158500',harga_beli ='5158500' WHERE kode_barcode='00033537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4065000',harga_beli ='4065000' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4973000',harga_beli ='4973000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3363500',harga_beli ='3363500' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3528500',harga_beli ='3528500' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1919000',harga_beli ='1919000' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5262000',harga_beli ='5262000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7593500',harga_beli ='7593500' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4003000',harga_beli ='4003000' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23956000',harga_beli ='23956000' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3095500',harga_beli ='3095500' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5509500',harga_beli ='5509500' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3240000',harga_beli ='3240000' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5612500',harga_beli ='5612500' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2270000',harga_beli ='2270000' WHERE kode_barcode='00034351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8522000',harga_beli ='8522000' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5220500',harga_beli ='5220500' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4622000',harga_beli ='4622000' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2806500',harga_beli ='2806500' WHERE kode_barcode='00034365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2290500',harga_beli ='2290500' WHERE kode_barcode='00034368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2105000',harga_beli ='2105000' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2290500',harga_beli ='2290500' WHERE kode_barcode='00034370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2435000',harga_beli ='2435000' WHERE kode_barcode='00034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4478000',harga_beli ='4478000' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3219000',harga_beli ='3219000' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9615500',harga_beli ='9615500' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12442500',harga_beli ='12442500' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4455500',harga_beli ='4455500' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2084500',harga_beli ='2084500' WHERE kode_barcode='00034780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2455500',harga_beli ='2455500' WHERE kode_barcode='00034781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2868500',harga_beli ='2868500' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7676000',harga_beli ='7676000' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3735000',harga_beli ='3735000' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11349000',harga_beli ='11349000' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6190500',harga_beli ='6190500' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4560500',harga_beli ='4560500' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1176500',harga_beli ='1176500' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='00036006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10857000',harga_beli ='10857000' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='929000',harga_beli ='929000' WHERE kode_barcode='00036244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='867000',harga_beli ='867000' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2063500',harga_beli ='2063500' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00036823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6252500',harga_beli ='6252500' WHERE kode_barcode='00036824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4870000',harga_beli ='4870000' WHERE kode_barcode='00036825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5324000',harga_beli ='5324000' WHERE kode_barcode='00036826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00036827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='00036828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00036830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00036831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4395500',harga_beli ='4395500' WHERE kode_barcode='00036832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2228000',harga_beli ='2228000' WHERE kode_barcode='00036947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4684000',harga_beli ='4684000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2063500',harga_beli ='2063500' WHERE kode_barcode='00036993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4312500',harga_beli ='4312500' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6211000',harga_beli ='6211000' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6747500',harga_beli ='6747500' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3693500',harga_beli ='3693500' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4353500',harga_beli ='4353500' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5654000',harga_beli ='5654000' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3033500',harga_beli ='3033500' WHERE kode_barcode='00038672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2889000',harga_beli ='2889000' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6787000',harga_beli ='6787000' WHERE kode_barcode='00038720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4003000',harga_beli ='4003000' WHERE kode_barcode='00038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00038862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5277000',harga_beli ='5277000' WHERE kode_barcode='00039058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3528500',harga_beli ='3528500' WHERE kode_barcode='00039178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2703500',harga_beli ='2703500' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2146000',harga_beli ='2146000' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2373000',harga_beli ='2373000' WHERE kode_barcode='00039182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6314000',harga_beli ='6314000' WHERE kode_barcode='00039192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5674500',harga_beli ='5674500' WHERE kode_barcode='00039193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3508000',harga_beli ='3508000' WHERE kode_barcode='00039194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12119500',harga_beli ='12119500' WHERE kode_barcode='00039381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4044500',harga_beli ='4044500' WHERE kode_barcode='00039405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7999000',harga_beli ='7999000' WHERE kode_barcode='00040395' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11653500',harga_beli ='11653500' WHERE kode_barcode='00040869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5239500',harga_beli ='5239500' WHERE kode_barcode='00040871' LIMIT 1;
UPDATE tm_group SET harga='2486000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2486000','kasir','2026-01-14 19:15:24');
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2409000',harga_beli ='2409000' WHERE kode_barcode='00019926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2536000',harga_beli ='2536000' WHERE kode_barcode='00019929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2536000',harga_beli ='2536000' WHERE kode_barcode='00019933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7755500',harga_beli ='7755500' WHERE kode_barcode='00024887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7945500',harga_beli ='7945500' WHERE kode_barcode='00024889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6445000',harga_beli ='6445000' WHERE kode_barcode='00024890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00024891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00024892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00024893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00024895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6424000',harga_beli ='6424000' WHERE kode_barcode='00024896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00024897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6318500',harga_beli ='6318500' WHERE kode_barcode='00024898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6339500',harga_beli ='6339500' WHERE kode_barcode='00024899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6424000',harga_beli ='6424000' WHERE kode_barcode='00024900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00024901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6403000',harga_beli ='6403000' WHERE kode_barcode='00024902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6360500',harga_beli ='6360500' WHERE kode_barcode='00024903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00024904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6382000',harga_beli ='6382000' WHERE kode_barcode='00024905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4522500',harga_beli ='4522500' WHERE kode_barcode='00024909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4649000',harga_beli ='4649000' WHERE kode_barcode='00024912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4543500',harga_beli ='4543500' WHERE kode_barcode='00024919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4543500',harga_beli ='4543500' WHERE kode_barcode='00024920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4607000',harga_beli ='4607000' WHERE kode_barcode='00024922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4522500',harga_beli ='4522500' WHERE kode_barcode='00024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18436500',harga_beli ='18436500' WHERE kode_barcode='00025675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19252000',harga_beli ='19252000' WHERE kode_barcode='00025676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19824500',harga_beli ='19824500' WHERE kode_barcode='00025677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17224500',harga_beli ='17224500' WHERE kode_barcode='00025679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='29590500',harga_beli ='29590500' WHERE kode_barcode='00025682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18324500',harga_beli ='18324500' WHERE kode_barcode='00025683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='21617500',harga_beli ='21617500' WHERE kode_barcode='00025684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9524500',harga_beli ='9524500' WHERE kode_barcode='00025687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18066500',harga_beli ='18066500' WHERE kode_barcode='00025697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6968000',harga_beli ='6968000' WHERE kode_barcode='00025699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11900000',harga_beli ='11900000' WHERE kode_barcode='00025701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11877000',harga_beli ='11877000' WHERE kode_barcode='00025702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3959000',harga_beli ='3959000' WHERE kode_barcode='00025706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='00025711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4683000',harga_beli ='4683000' WHERE kode_barcode='00025714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13936000',harga_beli ='13936000' WHERE kode_barcode='00025716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7013500',harga_beli ='7013500' WHERE kode_barcode='00025717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5067500',harga_beli ='5067500' WHERE kode_barcode='00025718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4163000',harga_beli ='4163000' WHERE kode_barcode='00025724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1674500',harga_beli ='1674500' WHERE kode_barcode='00025726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1651500',harga_beli ='1651500' WHERE kode_barcode='00025727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5385500',harga_beli ='5385500' WHERE kode_barcode='00025730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7094500',harga_beli ='7094500' WHERE kode_barcode='00025735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3742000',harga_beli ='3742000' WHERE kode_barcode='00025737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2249500',harga_beli ='2249500' WHERE kode_barcode='00025739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10866500',harga_beli ='10866500' WHERE kode_barcode='00025740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5429000',harga_beli ='5429000' WHERE kode_barcode='00025742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6575000',harga_beli ='6575000' WHERE kode_barcode='00025743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='20668000',harga_beli ='20668000' WHERE kode_barcode='00025747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='52123500',harga_beli ='52123500' WHERE kode_barcode='00025795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23112500',harga_beli ='23112500' WHERE kode_barcode='00025796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='48190000',harga_beli ='48190000' WHERE kode_barcode='00025797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17258000',harga_beli ='17258000' WHERE kode_barcode='00025798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='21108500',harga_beli ='21108500' WHERE kode_barcode='00025799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16815500',harga_beli ='16815500' WHERE kode_barcode='00025800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6276000',harga_beli ='6276000' WHERE kode_barcode='00025877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6107000',harga_beli ='6107000' WHERE kode_barcode='00025880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4522500',harga_beli ='4522500' WHERE kode_barcode='00025882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00025883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5623500',harga_beli ='5623500' WHERE kode_barcode='00025888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='29696000',harga_beli ='29696000' WHERE kode_barcode='00025892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13376000',harga_beli ='13376000' WHERE kode_barcode='00025893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10735000',harga_beli ='10735000' WHERE kode_barcode='00025894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13630000',harga_beli ='13630000' WHERE kode_barcode='00025896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5097000',harga_beli ='5097000' WHERE kode_barcode='00026055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00026056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3549500',harga_beli ='3549500' WHERE kode_barcode='00026058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4643000',harga_beli ='4643000' WHERE kode_barcode='00026059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4024000',harga_beli ='4024000' WHERE kode_barcode='00026060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6001500',harga_beli ='6001500' WHERE kode_barcode='00026061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4184000',harga_beli ='4184000' WHERE kode_barcode='00026062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4015000',harga_beli ='4015000' WHERE kode_barcode='00026064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3973000',harga_beli ='3973000' WHERE kode_barcode='00026065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3149000',harga_beli ='3149000' WHERE kode_barcode='00026070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3127500',harga_beli ='3127500' WHERE kode_barcode='00026071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5452000',harga_beli ='5452000' WHERE kode_barcode='00026072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8262500',harga_beli ='8262500' WHERE kode_barcode='00026078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12615500',harga_beli ='12615500' WHERE kode_barcode='00026079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='00026081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00026082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4023000',harga_beli ='4023000' WHERE kode_barcode='00026085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16588000',harga_beli ='16588000' WHERE kode_barcode='00026086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14961000',harga_beli ='14961000' WHERE kode_barcode='00026087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='60202500',harga_beli ='60202500' WHERE kode_barcode='00026090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='63097500',harga_beli ='63097500' WHERE kode_barcode='00026091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12045000',harga_beli ='12045000' WHERE kode_barcode='00026093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23160000',harga_beli ='23160000' WHERE kode_barcode='00026095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18912500',harga_beli ='18912500' WHERE kode_barcode='00026096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13249500',harga_beli ='13249500' WHERE kode_barcode='00026097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5283000',harga_beli ='5283000' WHERE kode_barcode='00026099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3948000',harga_beli ='3948000' WHERE kode_barcode='00026104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5911500',harga_beli ='5911500' WHERE kode_barcode='00026105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3948000',harga_beli ='3948000' WHERE kode_barcode='00026106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4065500',harga_beli ='4065500' WHERE kode_barcode='00026107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5295500',harga_beli ='5295500' WHERE kode_barcode='00026108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3908500',harga_beli ='3908500' WHERE kode_barcode='00026109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3636500',harga_beli ='3636500' WHERE kode_barcode='00026110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3967500',harga_beli ='3967500' WHERE kode_barcode='00026111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5207000',harga_beli ='5207000' WHERE kode_barcode='00026112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5970500',harga_beli ='5970500' WHERE kode_barcode='00026113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3928000',harga_beli ='3928000' WHERE kode_barcode='00026115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4324500',harga_beli ='4324500' WHERE kode_barcode='00026117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4382500',harga_beli ='4382500' WHERE kode_barcode='00026118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3452000',harga_beli ='3452000' WHERE kode_barcode='00026119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2947500',harga_beli ='2947500' WHERE kode_barcode='00026120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2967000',harga_beli ='2967000' WHERE kode_barcode='00026121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='54000500',harga_beli ='54000500' WHERE kode_barcode='00026125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8445000',harga_beli ='8445000' WHERE kode_barcode='00026126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6845000',harga_beli ='6845000' WHERE kode_barcode='00026127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7892500',harga_beli ='7892500' WHERE kode_barcode='00026132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10276000',harga_beli ='10276000' WHERE kode_barcode='00026140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5602000',harga_beli ='5602000' WHERE kode_barcode='00026141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5623500',harga_beli ='5623500' WHERE kode_barcode='00026142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4353500',harga_beli ='4353500' WHERE kode_barcode='00026145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2705000',harga_beli ='2705000' WHERE kode_barcode='00026146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5623500',harga_beli ='5623500' WHERE kode_barcode='00026147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10441500',harga_beli ='10441500' WHERE kode_barcode='00026152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14123500',harga_beli ='14123500' WHERE kode_barcode='00026469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7700000',harga_beli ='7700000' WHERE kode_barcode='00026471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3742000',harga_beli ='3742000' WHERE kode_barcode='00026472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4088000',harga_beli ='4088000' WHERE kode_barcode='00026475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='27403000',harga_beli ='27403000' WHERE kode_barcode='00026480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='28917000',harga_beli ='28917000' WHERE kode_barcode='00026481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10036000',harga_beli ='10036000' WHERE kode_barcode='00026484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00026485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4499000',harga_beli ='4499000' WHERE kode_barcode='00026486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4455500',harga_beli ='4455500' WHERE kode_barcode='00026487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6597000',harga_beli ='6597000' WHERE kode_barcode='00026525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7743000',harga_beli ='7743000' WHERE kode_barcode='00026526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3742000',harga_beli ='3742000' WHERE kode_barcode='00026527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4369000',harga_beli ='4369000' WHERE kode_barcode='00026529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3698500',harga_beli ='3698500' WHERE kode_barcode='00026534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14383000',harga_beli ='14383000' WHERE kode_barcode='00026537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9689500',harga_beli ='9689500' WHERE kode_barcode='00026538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16351000',harga_beli ='16351000' WHERE kode_barcode='00026553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10122500',harga_beli ='10122500' WHERE kode_barcode='00026557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15659000',harga_beli ='15659000' WHERE kode_barcode='00026560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4369000',harga_beli ='4369000' WHERE kode_barcode='00026561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4412500',harga_beli ='4412500' WHERE kode_barcode='00026563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8621500',harga_beli ='8621500' WHERE kode_barcode='00026653' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='00026654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3529000',harga_beli ='3529000' WHERE kode_barcode='00026655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3635000',harga_beli ='3635000' WHERE kode_barcode='00026656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4184000',harga_beli ='4184000' WHERE kode_barcode='00026658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2409000',harga_beli ='2409000' WHERE kode_barcode='00026659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4924000',harga_beli ='4924000' WHERE kode_barcode='00026660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3466000',harga_beli ='3466000' WHERE kode_barcode='00026662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4564500',harga_beli ='4564500' WHERE kode_barcode='00026665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5410000',harga_beli ='5410000' WHERE kode_barcode='00026666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4374500',harga_beli ='4374500' WHERE kode_barcode='00026668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4808000',harga_beli ='4808000' WHERE kode_barcode='00026669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9987000',harga_beli ='9987000' WHERE kode_barcode='00026671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00026672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3817500',harga_beli ='3817500' WHERE kode_barcode='00026677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6004500',harga_beli ='6004500' WHERE kode_barcode='00026678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00026679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2916500',harga_beli ='2916500' WHERE kode_barcode='00026680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5008500',harga_beli ='5008500' WHERE kode_barcode='00026681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3508000',harga_beli ='3508000' WHERE kode_barcode='00026683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3106500',harga_beli ='3106500' WHERE kode_barcode='00026684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3381000',harga_beli ='3381000' WHERE kode_barcode='00026686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4987000',harga_beli ='4987000' WHERE kode_barcode='00026691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10312000',harga_beli ='10312000' WHERE kode_barcode='00026693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5917000',harga_beli ='5917000' WHERE kode_barcode='00026697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4649000',harga_beli ='4649000' WHERE kode_barcode='00026699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4332000',harga_beli ='4332000' WHERE kode_barcode='00026702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5579000',harga_beli ='5579000' WHERE kode_barcode='00026708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4416500',harga_beli ='4416500' WHERE kode_barcode='00026709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5008500',harga_beli ='5008500' WHERE kode_barcode='00026710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2958500',harga_beli ='2958500' WHERE kode_barcode='00026711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4542000',harga_beli ='4542000' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13215000',harga_beli ='13215000' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16329500',harga_beli ='16329500' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='24397000',harga_beli ='24397000' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='26365000',harga_beli ='26365000' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15897000',harga_beli ='15897000' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9992500',harga_beli ='9992500' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11398500',harga_beli ='11398500' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15140000',harga_beli ='15140000' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11896000',harga_beli ='11896000' WHERE kode_barcode='00027647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8219000',harga_beli ='8219000' WHERE kode_barcode='00027649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6705000',harga_beli ='6705000' WHERE kode_barcode='00027650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19033000',harga_beli ='19033000' WHERE kode_barcode='00027652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23250500',harga_beli ='23250500' WHERE kode_barcode='00027654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7993500',harga_beli ='7993500' WHERE kode_barcode='00027657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3610000',harga_beli ='3610000' WHERE kode_barcode='00027659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5776000',harga_beli ='5776000' WHERE kode_barcode='00027663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5885000',harga_beli ='5885000' WHERE kode_barcode='00027664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00027667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12336500',harga_beli ='12336500' WHERE kode_barcode='00027668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6072000',harga_beli ='6072000' WHERE kode_barcode='00027669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16804500',harga_beli ='16804500' WHERE kode_barcode='00027671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17553000',harga_beli ='17553000' WHERE kode_barcode='00027672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9625000',harga_beli ='9625000' WHERE kode_barcode='00027678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5515500',harga_beli ='5515500' WHERE kode_barcode='00027680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13718000',harga_beli ='13718000' WHERE kode_barcode='00027681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5642500',harga_beli ='5642500' WHERE kode_barcode='00027682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3254500',harga_beli ='3254500' WHERE kode_barcode='00027687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4226500',harga_beli ='4226500' WHERE kode_barcode='00027688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14758000',harga_beli ='14758000' WHERE kode_barcode='00027691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='19559000',harga_beli ='19559000' WHERE kode_barcode='00027694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3893500',harga_beli ='3893500' WHERE kode_barcode='00029700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8073000',harga_beli ='8073000' WHERE kode_barcode='00029701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6366500',harga_beli ='6366500' WHERE kode_barcode='00029702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14023500',harga_beli ='14023500' WHERE kode_barcode='00029703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5491500',harga_beli ='5491500' WHERE kode_barcode='00029704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16254500',harga_beli ='16254500' WHERE kode_barcode='00029705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9757500',harga_beli ='9757500' WHERE kode_barcode='00029706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10661000',harga_beli ='10661000' WHERE kode_barcode='00030416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='41438000',harga_beli ='41438000' WHERE kode_barcode='00030724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7016000',harga_beli ='7016000' WHERE kode_barcode='00030727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='28333000',harga_beli ='28333000' WHERE kode_barcode='00030732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14123500',harga_beli ='14123500' WHERE kode_barcode='00030733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10504000',harga_beli ='10504000' WHERE kode_barcode='00030735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='24007500',harga_beli ='24007500' WHERE kode_barcode='00030741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12155500',harga_beli ='12155500' WHERE kode_barcode='00030742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14794000',harga_beli ='14794000' WHERE kode_barcode='00030744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3275500',harga_beli ='3275500' WHERE kode_barcode='00030753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3888500',harga_beli ='3888500' WHERE kode_barcode='00030754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10288500',harga_beli ='10288500' WHERE kode_barcode='00030755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9084000',harga_beli ='9084000' WHERE kode_barcode='00030758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9581500',harga_beli ='9581500' WHERE kode_barcode='00030760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3374500',harga_beli ='3374500' WHERE kode_barcode='00030761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3461000',harga_beli ='3461000' WHERE kode_barcode='00030763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5969500',harga_beli ='5969500' WHERE kode_barcode='00030766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5667000',harga_beli ='5667000' WHERE kode_barcode='00030767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6056000',harga_beli ='6056000' WHERE kode_barcode='00030768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5969500',harga_beli ='5969500' WHERE kode_barcode='00030769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23575000',harga_beli ='23575000' WHERE kode_barcode='00030773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='55174000',harga_beli ='55174000' WHERE kode_barcode='00030774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5346500',harga_beli ='5346500' WHERE kode_barcode='00030785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4755000',harga_beli ='4755000' WHERE kode_barcode='00030786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3994000',harga_beli ='3994000' WHERE kode_barcode='00030787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7779000',harga_beli ='7779000' WHERE kode_barcode='00031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9171000',harga_beli ='9171000' WHERE kode_barcode='00031682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3994000',harga_beli ='3994000' WHERE kode_barcode='00031684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1796500',harga_beli ='1796500' WHERE kode_barcode='00031686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1923000',harga_beli ='1923000' WHERE kode_barcode='00031687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8579500',harga_beli ='8579500' WHERE kode_barcode='00031690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3665500',harga_beli ='3665500' WHERE kode_barcode='00032055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1700500',harga_beli ='1700500' WHERE kode_barcode='00033190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5328500',harga_beli ='5328500' WHERE kode_barcode='00033455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7016000',harga_beli ='7016000' WHERE kode_barcode='00033504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2228500',harga_beli ='2228500' WHERE kode_barcode='00033505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2455500',harga_beli ='2455500' WHERE kode_barcode='00033509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2414500',harga_beli ='2414500' WHERE kode_barcode='00033510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14602000',harga_beli ='14602000' WHERE kode_barcode='00033511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14940000',harga_beli ='14940000' WHERE kode_barcode='00033512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='22188000',harga_beli ='22188000' WHERE kode_barcode='00033513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17306500',harga_beli ='17306500' WHERE kode_barcode='00033516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12383000',harga_beli ='12383000' WHERE kode_barcode='00033517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5621000',harga_beli ='5621000' WHERE kode_barcode='00033518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2456500',harga_beli ='2456500' WHERE kode_barcode='00033881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6789000',harga_beli ='6789000' WHERE kode_barcode='00034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7201500',harga_beli ='7201500' WHERE kode_barcode='00034761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5324000',harga_beli ='5324000' WHERE kode_barcode='00034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5035000',harga_beli ='5035000' WHERE kode_barcode='00034763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4746000',harga_beli ='4746000' WHERE kode_barcode='00034768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3095500',harga_beli ='3095500' WHERE kode_barcode='00034769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5282500',harga_beli ='5282500' WHERE kode_barcode='00034776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2951000',harga_beli ='2951000' WHERE kode_barcode='00035830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3170000',harga_beli ='3170000' WHERE kode_barcode='00035831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6252500',harga_beli ='6252500' WHERE kode_barcode='00036170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5943000',harga_beli ='5943000' WHERE kode_barcode='00036357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3095500',harga_beli ='3095500' WHERE kode_barcode='00036359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00036412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3363500',harga_beli ='3363500' WHERE kode_barcode='00036416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5035000',harga_beli ='5035000' WHERE kode_barcode='00036621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4870000',harga_beli ='4870000' WHERE kode_barcode='00036623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5179500',harga_beli ='5179500' WHERE kode_barcode='00036624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4581000',harga_beli ='4581000' WHERE kode_barcode='00036626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5571500',harga_beli ='5571500' WHERE kode_barcode='00036627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4932000',harga_beli ='4932000' WHERE kode_barcode='00036628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5551000',harga_beli ='5551000' WHERE kode_barcode='00036629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6572000',harga_beli ='6572000' WHERE kode_barcode='00036763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6487500',harga_beli ='6487500' WHERE kode_barcode='00036764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6445000',harga_beli ='6445000' WHERE kode_barcode='00036765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6424000',harga_beli ='6424000' WHERE kode_barcode='00036766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6297500',harga_beli ='6297500' WHERE kode_barcode='00036767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2765000',harga_beli ='2765000' WHERE kode_barcode='00036790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3446000',harga_beli ='3446000' WHERE kode_barcode='00036806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3817500',harga_beli ='3817500' WHERE kode_barcode='00036808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2971500',harga_beli ='2971500' WHERE kode_barcode='00036844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4663500',harga_beli ='4663500' WHERE kode_barcode='00036848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3817500',harga_beli ='3817500' WHERE kode_barcode='00036850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4044500',harga_beli ='4044500' WHERE kode_barcode='00036852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4560500',harga_beli ='4560500' WHERE kode_barcode='00036853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='00036855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14855500',harga_beli ='14855500' WHERE kode_barcode='00036906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18363000',harga_beli ='18363000' WHERE kode_barcode='00036907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10819500',harga_beli ='10819500' WHERE kode_barcode='00036908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7016000',harga_beli ='7016000' WHERE kode_barcode='00036909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11242000',harga_beli ='11242000' WHERE kode_barcode='00036912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7713000',harga_beli ='7713000' WHERE kode_barcode='00036913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18976000',harga_beli ='18976000' WHERE kode_barcode='00036914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='15024500',harga_beli ='15024500' WHERE kode_barcode='00036915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12467500',harga_beli ='12467500' WHERE kode_barcode='00036916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='21194500',harga_beli ='21194500' WHERE kode_barcode='00036918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4560500',harga_beli ='4560500' WHERE kode_barcode='00037019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00037245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6128500',harga_beli ='6128500' WHERE kode_barcode='00037246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4911000',harga_beli ='4911000' WHERE kode_barcode='00037250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5262000',harga_beli ='5262000' WHERE kode_barcode='00037252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6252500',harga_beli ='6252500' WHERE kode_barcode='00037269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5489000',harga_beli ='5489000' WHERE kode_barcode='00037272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5633500',harga_beli ='5633500' WHERE kode_barcode='00037273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00037274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3859000',harga_beli ='3859000' WHERE kode_barcode='00037278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00037280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5303000',harga_beli ='5303000' WHERE kode_barcode='00037281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00037283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3962000',harga_beli ='3962000' WHERE kode_barcode='00037284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7408000',harga_beli ='7408000' WHERE kode_barcode='00037288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5117500',harga_beli ='5117500' WHERE kode_barcode='00037289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5344500',harga_beli ='5344500' WHERE kode_barcode='00037813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4434000',harga_beli ='4434000' WHERE kode_barcode='00038371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4434000',harga_beli ='4434000' WHERE kode_barcode='00038372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4412500',harga_beli ='4412500' WHERE kode_barcode='00038373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4455500',harga_beli ='4455500' WHERE kode_barcode='00038375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3763500',harga_beli ='3763500' WHERE kode_barcode='00038376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3763500',harga_beli ='3763500' WHERE kode_barcode='00038377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7743000',harga_beli ='7743000' WHERE kode_barcode='00038378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10057500',harga_beli ='10057500' WHERE kode_barcode='00038380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13669500',harga_beli ='13669500' WHERE kode_barcode='00038381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7354000',harga_beli ='7354000' WHERE kode_barcode='00038382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3612000',harga_beli ='3612000' WHERE kode_barcode='00038383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9300500',harga_beli ='9300500' WHERE kode_barcode='00038385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9538500',harga_beli ='9538500' WHERE kode_barcode='00038386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9581500',harga_beli ='9581500' WHERE kode_barcode='00038387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3132500',harga_beli ='3132500' WHERE kode_barcode='00038388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3174500',harga_beli ='3174500' WHERE kode_barcode='00038389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3425000',harga_beli ='3425000' WHERE kode_barcode='00038390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3508500',harga_beli ='3508500' WHERE kode_barcode='00038391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3404000',harga_beli ='3404000' WHERE kode_barcode='00038393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3467000',harga_beli ='3467000' WHERE kode_barcode='00038394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1859000',harga_beli ='1859000' WHERE kode_barcode='00038396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1817000',harga_beli ='1817000' WHERE kode_barcode='00038397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2339000',harga_beli ='2339000' WHERE kode_barcode='00038399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2652500',harga_beli ='2652500' WHERE kode_barcode='00038400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2715000',harga_beli ='2715000' WHERE kode_barcode='00038401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00038402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2214000',harga_beli ='2214000' WHERE kode_barcode='00038403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2819500',harga_beli ='2819500' WHERE kode_barcode='00038404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1796000',harga_beli ='1796000' WHERE kode_barcode='00038405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2569000',harga_beli ='2569000' WHERE kode_barcode='00038407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2569000',harga_beli ='2569000' WHERE kode_barcode='00038408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2548000',harga_beli ='2548000' WHERE kode_barcode='00038409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2276500',harga_beli ='2276500' WHERE kode_barcode='00038411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4845000',harga_beli ='4845000' WHERE kode_barcode='00038419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4845000',harga_beli ='4845000' WHERE kode_barcode='00038420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4949500',harga_beli ='4949500' WHERE kode_barcode='00038421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4845000',harga_beli ='4845000' WHERE kode_barcode='00038422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4573500',harga_beli ='4573500' WHERE kode_barcode='00038423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6035500',harga_beli ='6035500' WHERE kode_barcode='00038424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6411000',harga_beli ='6411000' WHERE kode_barcode='00038425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5074500',harga_beli ='5074500' WHERE kode_barcode='00038427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4761500',harga_beli ='4761500' WHERE kode_barcode='00038428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00038429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5074500',harga_beli ='5074500' WHERE kode_barcode='00038430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00038431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12509000',harga_beli ='12509000' WHERE kode_barcode='00038433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12571500',harga_beli ='12571500' WHERE kode_barcode='00038434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10544500',harga_beli ='10544500' WHERE kode_barcode='00038435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10798000',harga_beli ='10798000' WHERE kode_barcode='00038436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2536000',harga_beli ='2536000' WHERE kode_barcode='00038437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2578500',harga_beli ='2578500' WHERE kode_barcode='00038438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7227000',harga_beli ='7227000' WHERE kode_barcode='00038441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2493500',harga_beli ='2493500' WHERE kode_barcode='00038442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2958500',harga_beli ='2958500' WHERE kode_barcode='00038444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8283500',harga_beli ='8283500' WHERE kode_barcode='00038446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8135500',harga_beli ='8135500' WHERE kode_barcode='00038447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8917500',harga_beli ='8917500' WHERE kode_barcode='00038449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8283500',harga_beli ='8283500' WHERE kode_barcode='00038451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14094500',harga_beli ='14094500' WHERE kode_barcode='00038452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13735500',harga_beli ='13735500' WHERE kode_barcode='00038453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='17391000',harga_beli ='17391000' WHERE kode_barcode='00038454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00038534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4344000',harga_beli ='4344000' WHERE kode_barcode='00038535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1984000',harga_beli ='1984000' WHERE kode_barcode='00038536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2527000',harga_beli ='2527000' WHERE kode_barcode='00038537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2673000',harga_beli ='2673000' WHERE kode_barcode='00038538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3592000',harga_beli ='3592000' WHERE kode_barcode='00038540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5555000',harga_beli ='5555000' WHERE kode_barcode='00038541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1879500',harga_beli ='1879500' WHERE kode_barcode='00038543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1879500',harga_beli ='1879500' WHERE kode_barcode='00038545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2088500',harga_beli ='2088500' WHERE kode_barcode='00038547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2026000',harga_beli ='2026000' WHERE kode_barcode='00038548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3905500',harga_beli ='3905500' WHERE kode_barcode='00038550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4030500',harga_beli ='4030500' WHERE kode_barcode='00038551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00038552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6065000',harga_beli ='6065000' WHERE kode_barcode='00038553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='00038554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2937500',harga_beli ='2937500' WHERE kode_barcode='00038555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23709500',harga_beli ='23709500' WHERE kode_barcode='00038556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4261000',harga_beli ='4261000' WHERE kode_barcode='00038557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10036000',harga_beli ='10036000' WHERE kode_barcode='00038559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3071500',harga_beli ='3071500' WHERE kode_barcode='00038561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1276500',harga_beli ='1276500' WHERE kode_barcode='00038564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1276500',harga_beli ='1276500' WHERE kode_barcode='00038565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1276500',harga_beli ='1276500' WHERE kode_barcode='00038566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6618500',harga_beli ='6618500' WHERE kode_barcode='00038567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4455500',harga_beli ='4455500' WHERE kode_barcode='00038568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6467000',harga_beli ='6467000' WHERE kode_barcode='00038569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4477500',harga_beli ='4477500' WHERE kode_barcode='00038570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4434000',harga_beli ='4434000' WHERE kode_barcode='00038571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11831000',harga_beli ='11831000' WHERE kode_barcode='00038573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11074000',harga_beli ='11074000' WHERE kode_barcode='00038575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2424000',harga_beli ='2424000' WHERE kode_barcode='00038772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='128029000',harga_beli ='128029000' WHERE kode_barcode='00038877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='49463500',harga_beli ='49463500' WHERE kode_barcode='00038891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='46082000',harga_beli ='46082000' WHERE kode_barcode='00038892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='40190500',harga_beli ='40190500' WHERE kode_barcode='00038893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4856000',harga_beli ='4856000' WHERE kode_barcode='00038894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6084000',harga_beli ='6084000' WHERE kode_barcode='00038895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11903000',harga_beli ='11903000' WHERE kode_barcode='00038896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8155000',harga_beli ='8155000' WHERE kode_barcode='00038897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00038898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10694000',harga_beli ='10694000' WHERE kode_barcode='00038899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8332500',harga_beli ='8332500' WHERE kode_barcode='00038900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5725000',harga_beli ='5725000' WHERE kode_barcode='00038901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3665500',harga_beli ='3665500' WHERE kode_barcode='00038902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9333500',harga_beli ='9333500' WHERE kode_barcode='00038903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5347000',harga_beli ='5347000' WHERE kode_barcode='00038904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='12810000',harga_beli ='12810000' WHERE kode_barcode='00038905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14756000',harga_beli ='14756000' WHERE kode_barcode='00038906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8200000',harga_beli ='8200000' WHERE kode_barcode='00038907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11072000',harga_beli ='11072000' WHERE kode_barcode='00038908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5687000',harga_beli ='5687000' WHERE kode_barcode='00038923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='28907500',harga_beli ='28907500' WHERE kode_barcode='00038924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='22975000',harga_beli ='22975000' WHERE kode_barcode='00038925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='00038950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6050000',harga_beli ='6050000' WHERE kode_barcode='00038951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='16094500',harga_beli ='16094500' WHERE kode_barcode='00039103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4015000',harga_beli ='4015000' WHERE kode_barcode='00039104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5342500',harga_beli ='5342500' WHERE kode_barcode='00039105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='18730500',harga_beli ='18730500' WHERE kode_barcode='00039107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='00039109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3698500',harga_beli ='3698500' WHERE kode_barcode='00039110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4520500',harga_beli ='4520500' WHERE kode_barcode='00039111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6921500',harga_beli ='6921500' WHERE kode_barcode='00039113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4849000',harga_beli ='4849000' WHERE kode_barcode='00039163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='00039164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00039165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4251000',harga_beli ='4251000' WHERE kode_barcode='00039166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00039168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3467000',harga_beli ='3467000' WHERE kode_barcode='00039169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3198500',harga_beli ='3198500' WHERE kode_barcode='00039170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3136500',harga_beli ='3136500' WHERE kode_barcode='00039171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='26281500',harga_beli ='26281500' WHERE kode_barcode='00039222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13412000',harga_beli ='13412000' WHERE kode_barcode='00039223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5252500',harga_beli ='5252500' WHERE kode_barcode='00039224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4723500',harga_beli ='4723500' WHERE kode_barcode='00039225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3424500',harga_beli ='3424500' WHERE kode_barcode='00039226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7978500',harga_beli ='7978500' WHERE kode_barcode='00039227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11393000',harga_beli ='11393000' WHERE kode_barcode='00039228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7652000',harga_beli ='7652000' WHERE kode_barcode='00039229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7520000',harga_beli ='7520000' WHERE kode_barcode='00039230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6877500',harga_beli ='6877500' WHERE kode_barcode='00039231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5290500',harga_beli ='5290500' WHERE kode_barcode='00039233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3344500',harga_beli ='3344500' WHERE kode_barcode='00039235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4307000',harga_beli ='4307000' WHERE kode_barcode='00039236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2489000',harga_beli ='2489000' WHERE kode_barcode='00039237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2453500',harga_beli ='2453500' WHERE kode_barcode='00039238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00039278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5687000',harga_beli ='5687000' WHERE kode_barcode='00039444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00039547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00039549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00039551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00039552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2910000',harga_beli ='2910000' WHERE kode_barcode='00039558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7312000',harga_beli ='7312000' WHERE kode_barcode='00039795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4289500',harga_beli ='4289500' WHERE kode_barcode='00040124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1329500',harga_beli ='1329500' WHERE kode_barcode='00040125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1369500',harga_beli ='1369500' WHERE kode_barcode='00040126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1329500',harga_beli ='1329500' WHERE kode_barcode='00040127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1430000',harga_beli ='1430000' WHERE kode_barcode='00040128' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1712000',harga_beli ='1712000' WHERE kode_barcode='00040129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1289000',harga_beli ='1289000' WHERE kode_barcode='00040130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1369500',harga_beli ='1369500' WHERE kode_barcode='00040131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1832500',harga_beli ='1832500' WHERE kode_barcode='00040133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2255500',harga_beli ='2255500' WHERE kode_barcode='00040134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2638000',harga_beli ='2638000' WHERE kode_barcode='00040135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2638000',harga_beli ='2638000' WHERE kode_barcode='00040136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2497000',harga_beli ='2497000' WHERE kode_barcode='00040137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00040138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2396500',harga_beli ='2396500' WHERE kode_barcode='00040139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1853000',harga_beli ='1853000' WHERE kode_barcode='00040140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2678500',harga_beli ='2678500' WHERE kode_barcode='00040142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2618000',harga_beli ='2618000' WHERE kode_barcode='00040143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='00040144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3262500',harga_beli ='3262500' WHERE kode_barcode='00040145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2416500',harga_beli ='2416500' WHERE kode_barcode='00040146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3262500',harga_beli ='3262500' WHERE kode_barcode='00040147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3021000',harga_beli ='3021000' WHERE kode_barcode='00040148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2598000',harga_beli ='2598000' WHERE kode_barcode='00040149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2578000',harga_beli ='2578000' WHERE kode_barcode='00040150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1208500',harga_beli ='1208500' WHERE kode_barcode='00040151' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1591000',harga_beli ='1591000' WHERE kode_barcode='00040152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1208500',harga_beli ='1208500' WHERE kode_barcode='00040153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1188500',harga_beli ='1188500' WHERE kode_barcode='00040154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1591000',harga_beli ='1591000' WHERE kode_barcode='00040155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2255500',harga_beli ='2255500' WHERE kode_barcode='00040156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1289000',harga_beli ='1289000' WHERE kode_barcode='00040157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00040158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2698500',harga_beli ='2698500' WHERE kode_barcode='00040159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00040160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1732000',harga_beli ='1732000' WHERE kode_barcode='00040161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1812500',harga_beli ='1812500' WHERE kode_barcode='00040162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1470000',harga_beli ='1470000' WHERE kode_barcode='00040163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4913500',harga_beli ='4913500' WHERE kode_barcode='00040164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9807000',harga_beli ='9807000' WHERE kode_barcode='00040165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5699000',harga_beli ='5699000' WHERE kode_barcode='00040166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9907500',harga_beli ='9907500' WHERE kode_barcode='00040167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4893500',harga_beli ='4893500' WHERE kode_barcode='00040168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6202500',harga_beli ='6202500' WHERE kode_barcode='00040169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6887000',harga_beli ='6887000' WHERE kode_barcode='00040170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8840000',harga_beli ='8840000' WHERE kode_barcode='00040171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13371000',harga_beli ='13371000' WHERE kode_barcode='00040172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6101500',harga_beli ='6101500' WHERE kode_barcode='00040173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6283000',harga_beli ='6283000' WHERE kode_barcode='00040174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6263000',harga_beli ='6263000' WHERE kode_barcode='00040176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4229000',harga_beli ='4229000' WHERE kode_barcode='00040177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6202500',harga_beli ='6202500' WHERE kode_barcode='00040178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5558000',harga_beli ='5558000' WHERE kode_barcode='00040179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2074500',harga_beli ='2074500' WHERE kode_barcode='00040180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6625500',harga_beli ='6625500' WHERE kode_barcode='00040181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11762500',harga_beli ='11762500' WHERE kode_barcode='00040182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7298000',harga_beli ='7298000' WHERE kode_barcode='00040183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7665000',harga_beli ='7665000' WHERE kode_barcode='00040184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7563000',harga_beli ='7563000' WHERE kode_barcode='00040185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8541500',harga_beli ='8541500' WHERE kode_barcode='00040186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3690000',harga_beli ='3690000' WHERE kode_barcode='00040187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3771500',harga_beli ='3771500' WHERE kode_barcode='00040188' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8582500',harga_beli ='8582500' WHERE kode_barcode='00040189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='23525000',harga_beli ='23525000' WHERE kode_barcode='00040190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4016000',harga_beli ='4016000' WHERE kode_barcode='00040193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11436500',harga_beli ='11436500' WHERE kode_barcode='00040194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6707000',harga_beli ='6707000' WHERE kode_barcode='00040195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5259500',harga_beli ='5259500' WHERE kode_barcode='00040196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11375000',harga_beli ='11375000' WHERE kode_barcode='00040197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8215500',harga_beli ='8215500' WHERE kode_barcode='00040198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6116000',harga_beli ='6116000' WHERE kode_barcode='00040199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='00040200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4036500',harga_beli ='4036500' WHERE kode_barcode='00040201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4016000',harga_beli ='4016000' WHERE kode_barcode='00040202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5953000',harga_beli ='5953000' WHERE kode_barcode='00040203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4138500',harga_beli ='4138500' WHERE kode_barcode='00040204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4199500',harga_beli ='4199500' WHERE kode_barcode='00040205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='00040206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4261000',harga_beli ='4261000' WHERE kode_barcode='00040207' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4199500',harga_beli ='4199500' WHERE kode_barcode='00040208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4322000',harga_beli ='4322000' WHERE kode_barcode='00040209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='00040210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1733500',harga_beli ='1733500' WHERE kode_barcode='00040211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1238500',harga_beli ='1238500' WHERE kode_barcode='00040212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='00040213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='00040214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='00040215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11245500',harga_beli ='11245500' WHERE kode_barcode='00040216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='11576000',harga_beli ='11576000' WHERE kode_barcode='00040217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4952500',harga_beli ='4952500' WHERE kode_barcode='00040218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00040219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5798500',harga_beli ='5798500' WHERE kode_barcode='00040220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2840500',harga_beli ='2840500' WHERE kode_barcode='00040222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2924000',harga_beli ='2924000' WHERE kode_barcode='00040223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00040224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7935500',harga_beli ='7935500' WHERE kode_barcode='00040225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='2903000',harga_beli ='2903000' WHERE kode_barcode='00040226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8165500',harga_beli ='8165500' WHERE kode_barcode='00040227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6620000',harga_beli ='6620000' WHERE kode_barcode='00040229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5283500',harga_beli ='5283500' WHERE kode_barcode='00040230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5429500',harga_beli ='5429500' WHERE kode_barcode='00040231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3780000',harga_beli ='3780000' WHERE kode_barcode='00040232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7267500',harga_beli ='7267500' WHERE kode_barcode='00040233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6536500',harga_beli ='6536500' WHERE kode_barcode='00040234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6119000',harga_beli ='6119000' WHERE kode_barcode='00040235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5805500',harga_beli ='5805500' WHERE kode_barcode='00040236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4260500',harga_beli ='4260500' WHERE kode_barcode='00040237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5889000',harga_beli ='5889000' WHERE kode_barcode='00040238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6160500',harga_beli ='6160500' WHERE kode_barcode='00040239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4218500',harga_beli ='4218500' WHERE kode_barcode='00040240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4114000',harga_beli ='4114000' WHERE kode_barcode='00040241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6119000',harga_beli ='6119000' WHERE kode_barcode='00040242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4949500',harga_beli ='4949500' WHERE kode_barcode='00040243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='14242000',harga_beli ='14242000' WHERE kode_barcode='00040244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6223000',harga_beli ='6223000' WHERE kode_barcode='00040245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='10775500',harga_beli ='10775500' WHERE kode_barcode='00040246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6244000',harga_beli ='6244000' WHERE kode_barcode='00040247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8332500',harga_beli ='8332500' WHERE kode_barcode='00040248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4490000',harga_beli ='4490000' WHERE kode_barcode='00040249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8207000',harga_beli ='8207000' WHERE kode_barcode='00040250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='8019000',harga_beli ='8019000' WHERE kode_barcode='00040252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4532000',harga_beli ='4532000' WHERE kode_barcode='00040253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13344000',harga_beli ='13344000' WHERE kode_barcode='00040254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13156000',harga_beli ='13156000' WHERE kode_barcode='00040255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4385500',harga_beli ='4385500' WHERE kode_barcode='00040256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6014500',harga_beli ='6014500' WHERE kode_barcode='00040258' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3696500',harga_beli ='3696500' WHERE kode_barcode='00040259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4114000',harga_beli ='4114000' WHERE kode_barcode='00040261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6307000',harga_beli ='6307000' WHERE kode_barcode='00040262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4114000',harga_beli ='4114000' WHERE kode_barcode='00040263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='6286000',harga_beli ='6286000' WHERE kode_barcode='00040264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4030500',harga_beli ='4030500' WHERE kode_barcode='00040265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4573500',harga_beli ='4573500' WHERE kode_barcode='00040266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4615500',harga_beli ='4615500' WHERE kode_barcode='00040267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00040270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7825000',harga_beli ='7825000' WHERE kode_barcode='00040271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='7355000',harga_beli ='7355000' WHERE kode_barcode='00040272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='26746000',harga_beli ='26746000' WHERE kode_barcode='00040273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5430500',harga_beli ='5430500' WHERE kode_barcode='00040274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3061000',harga_beli ='3061000' WHERE kode_barcode='00040347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9450500',harga_beli ='9450500' WHERE kode_barcode='00040368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00040369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5220500',harga_beli ='5220500' WHERE kode_barcode='00040370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4312500',harga_beli ='4312500' WHERE kode_barcode='00040371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4065000',harga_beli ='4065000' WHERE kode_barcode='00040372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3755500',harga_beli ='3755500' WHERE kode_barcode='00040373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='26103000',harga_beli ='26103000' WHERE kode_barcode='00040584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='9881500',harga_beli ='9881500' WHERE kode_barcode='00040608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13673000',harga_beli ='13673000' WHERE kode_barcode='00040615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3178000',harga_beli ='3178000' WHERE kode_barcode='00040622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4292000',harga_beli ='4292000' WHERE kode_barcode='00040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4374500',harga_beli ='4374500' WHERE kode_barcode='00040625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4849000',harga_beli ='4849000' WHERE kode_barcode='00040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4251000',harga_beli ='4251000' WHERE kode_barcode='00040628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5097000',harga_beli ='5097000' WHERE kode_barcode='00040629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='3652500',harga_beli ='3652500' WHERE kode_barcode='00040630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='4292000',harga_beli ='4292000' WHERE kode_barcode='00040688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='5551000',harga_beli ='5551000' WHERE kode_barcode='00040689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13673000',harga_beli ='13673000' WHERE kode_barcode='00040698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2486000',harga_jual='13673000',harga_beli ='13673000' WHERE kode_barcode='00040700' LIMIT 1;
UPDATE tm_group SET harga='2486000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2486000','kasir','2026-01-14 19:15:43');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0007','kasir','1',' TFGRR75-84','TOKO','TFGLR','TFGRR-YLXD-64-0','THIFA GELANG RANTAI RG ','','6.820','1','84.00','14527000','0','0','16950','14750000','0','0','0','14750000','FIR','00040244','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXD-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.820',berat_jual_asli=berat_jual_asli+'6.820',stock_jual='1',berat_akhir=berat_akhir-'6.820',berat_akhir_asli=berat_akhir_asli-'6.820',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='TFGRR-YLXD-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0007','2026-01-14','6.820','2026-01-14','19:20:19','PLG0008809','14750000','14750000','0','14750000','0','kasir','2026-01-14 19:20:18','FJ-260114-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0007','2026-01-14','19:20:19','FIR','14750000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0011','2026-01-14','2026-01-14 19:20:18','PENJUALAN : FJ-260114-0007','.','TBC','14750000','14750000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0012','D','2026-01-14','19:20:19','TBC','PENJUALAN','FJ-260114-0007','19370221514','14750000','19384971514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='14750000' WHERE no_faktur_jual='FJ-260114-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','19:41:00');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0008','kasir','1',' 700K-11-59','TOKO','MMPER','PMM-YKBD-44-0','CINCIN SILVER 925 ','','1.030','1','100.00','64000','0','0','16950','300000','0','0','0','300000','NAD','00039816','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBD-44-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-01-14' AND kode_barang='PMM-YKBD-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0008','2026-01-14','1.030','2026-01-14','19:42:34','PLG0008810','300000','300000','0','300000','0','kasir','2026-01-14 19:42:33','FJ-260114-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0008','2026-01-14','19:42:34','NAD','300000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0012','2026-01-14','2026-01-14 19:42:33','PENJUALAN : FJ-260114-0008','.','TBC','300000','300000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0013','D','2026-01-14','19:42:34','TBC','PENJUALAN','FJ-260114-0008','19384971514','300000','19385271514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','...');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='300000' WHERE no_faktur_jual='FJ-260114-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260114-0009','kasir','1',' 500K-125-0','TOKO','MMPER','PMM-YIAF-11-0','CINCIN SILVER 925 ','','1.830','1','100.00','47000','0','0','16950','500000','0','0','0','500000','NIS','00038756','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIAF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='PMM-YIAF-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260114-0009','2026-01-14','1.830','2026-01-14','19:43:13','PLG0008811','500000','500000','0','500000','0','kasir','2026-01-14 19:43:12','FJ-260114-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-14','FJ-260114-0009','2026-01-14','19:43:13','NIS','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260114-0013','2026-01-14','2026-01-14 19:43:12','PENJUALAN : FJ-260114-0009','.','TBC','500000','500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260114-0014','D','2026-01-14','19:43:13','TBC','PENJUALAN','FJ-260114-0009','19385271514','500000','19385771514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='FJ-260114-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260114-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260114-0009';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-14' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','TBC','SALDO AWAL','SALDO AWAL','0','19385771514','19385771514');
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-260115-0001','D','2026-01-15','20:07:09','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
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-260115-0001','D','2026-01-15','20:07:09','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260115-0001','D','2026-01-15','20:07:09','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
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-260115-0001','D','2026-01-15','20:07:09','BCK','SALDO AWAL','SALDO AWAL','0','1940208000','1940208000');
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-260115-0001','D','2026-01-15','20:07:09','BCD','SALDO AWAL','SALDO AWAL','0','1348483500','1348483500');
UPDATE tp_system SET tgl_system='2026-01-15';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-14 ','21:14:47');