INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-30 ','08:36:49'); 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-20261030-0001','1','CBRE-ZJCX-2-0','1','1.710','1.710','TOKO','CBRE','TOKO','CBR'); DELETE FROM tm_barang WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZJCX-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZJCX-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-10-30 08:37:03' WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-30 08:37:03','TOKO','CBR','CBRE','CBRE-ZJCX-2-0','1','1.710','1.710','1','1.710','1.710','83.00'); DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' 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='CBRE-ZJCX-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZJCX-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261030-0001','2026-10-30','08:36','1.710','kasir','2026-10-30 08:37:02'); 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-20261030-0002','1','CBRE-ZJCX-1-0','1','1.600','1.600','TOKO','CBRE.BALIK','TOKO','CBR'); DELETE FROM tm_barang WHERE kode_barang='CBRE-ZJCX-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZJCX-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZJCX-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZJCX-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-10-30 08:37:25' WHERE kode_barang='CBRE-ZJCX-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZJCX-1-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-10-30 08:37:25','TOKO','CBR','CBRE','CBRE-ZJCX-1-0','1','1.600','1.600','1','1.600','1.600','75.00'); DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' 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='CBRE-ZJCX-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZJCX-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-30' WHERE no_faktur_beli='BE-261021-0002'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261030-0002','2026-10-30','08:37','1.600','kasir','2026-10-30 08:37:25'); 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-20261030-0003','1','PSPRE-ZJBI-29-0','1','1.950','1.950','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRE-ZJBI-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBI-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRE-ZJBI-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRE-ZJBI-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-10-30 08:37:53' WHERE kode_barang='PSPRE-ZJBI-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRE-ZJBI-29-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-10-30 08:37:53','TOKO','PSN','PSPRE','PSPRE-ZJBI-29-0','1','1.950','1.950','1','1.950','1.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRE-ZJBI-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBI-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-30' WHERE no_faktur_beli=''; 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-20261030-0003','1','PSPRE-ZJBI-30-0','1','4.250','4.250','TOKO','PSN','TOKO','PSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRE-ZJBI-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBI-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRE-ZJBI-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRE-ZJBI-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-10-30 08:37:53' WHERE kode_barang='PSPRE-ZJBI-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRE-ZJBI-30-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-10-30 08:37:53','TOKO','PSN','PSPRE','PSPRE-ZJBI-30-0','1','4.250','4.250','1','4.250','4.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRE' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRE-ZJBI-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBI-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261030-0003','2026-10-30','08:37','6.200','kasir','2026-10-30 08:37:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-30 ','08:58:21'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-30 ','09:10:50'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-30 ','10:57:30'); DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZJBB-14-0'; INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZJBB-14-0','CBRE-ZJBB-14-0','00048487','BG','1','0.070','460'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZJBB-14-0','00048487','BG','1','0.070','460','32.2') INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZJBB-14-0','CBRE-ZJBB-14-0','00048487','RD','7','0.080','320'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZJBB-14-0','00048487','RD','7','0.080','320','25.6') INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZJBB-14-0','CBRE-ZJBB-14-0','00048487','RD','28','0.135','320'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZJBB-14-0','00048487','RD','28','0.135','320','43.2') INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-ZJBB-14-0','00048487','00048487','CINCIN CBRE-05334 ','CINCIN CBRE-05334','','','3201000','3201000',' 0','0','kasir','2026-10-30 14:07:55'); UPDATE tm_barang SET nama_barang='CINCIN CBRE-05334' ,nama_atribut='' ,kode_intern='CBRE-05334 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS135 5B0 1026',total_usd_ext='IDB 19 000 000',total_usd='101' WHERE kode_barang='CBRE-ZJBB-14-0' 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 ('FE-261030-0001','kasir','1',' CBRE-05334','TOKO','CBR','CBRE-ZJBB-14-0','CINCIN CBRE-05334','','1.880','1','75.00','5544000','1838500','101','18200','6300000','0','0','0','6300000','ONLILUNG','00048487','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZJBB-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-10-30' AND kode_barang='CBRE-ZJBB-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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 ('FE-261030-0001','2026-10-30','1.880','2026-10-30','14:08:11','PLG0029850','6300000','6300000','0','6300000','0','kasir','2026-10-30 14:08:11','FE-261030-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-10-30','FE-261030-0001','2026-10-30','14:08:11','ONLILUNG','6300000','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-261030-0001','2026-10-30','2026-10-30 14:08:11','PENJUALAN : FE-261030-0001','','TBC','6300000','6300000','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-261030-0002','D','2026-10-30','14:08:11','TBC','PENJUALAN BERLIAN','FE-261030-0001','108647891255','6300000','108654191255','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='6300000' WHERE no_faktur_jual='FE-261030-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261030-0001'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08422','ILU','1','CBRE05334','JD NO 16 CROM PUTIH','1.880','1','200000','200000'); 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-261030-0002','2026-10-30','2026-10-30 14:34:27','SERVICE : SV-08422','-','TBC','200000','200000','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-261030-0003','D','2026-10-30','14:34:27','TBC','SERVICE','SV-08422','108654191255','200000','108654391255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-'); 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-08422','2026-10-30','2026-10-30','14:34:27','PLG0029851','kasir','2026-11-03','kasir','2026-10-30 14:34:27','1.880','0','0','0','200000','0','200000','200000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-30 ','14:34:43'); UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='86500',harga_beli ='86500' WHERE kode_barcode='A0000754' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='145000',harga_beli ='145000' WHERE kode_barcode='A0000765' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='110000',harga_beli ='110000' WHERE kode_barcode='A0000795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='112000',harga_beli ='112000' WHERE kode_barcode='A0000827' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='90000',harga_beli ='90000' WHERE kode_barcode='A0000779' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='22108500',harga_beli ='22108500' WHERE kode_barcode='B0000049' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18417500',harga_beli ='18417500' WHERE kode_barcode='B0000180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8453500',harga_beli ='8453500' WHERE kode_barcode='B0000251' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='162000',harga_beli ='162000' WHERE kode_barcode='N0001121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='78000',harga_beli ='78000' WHERE kode_barcode='00000783' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='151500',harga_beli ='151500' WHERE kode_barcode='00000796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='99500',harga_beli ='99500' WHERE kode_barcode='00000797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='230000',harga_beli ='230000' WHERE kode_barcode='00000806' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='104500',harga_beli ='104500' WHERE kode_barcode='00000807' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='115000',harga_beli ='115000' WHERE kode_barcode='00000819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='160000',harga_beli ='160000' WHERE kode_barcode='00000822' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='141000',harga_beli ='141000' WHERE kode_barcode='00000848' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='88000',harga_beli ='88000' WHERE kode_barcode='00000854' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='29892500',harga_beli ='29892500' WHERE kode_barcode='00001067' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7339500',harga_beli ='7339500' WHERE kode_barcode='00004335' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7843500',harga_beli ='7843500' WHERE kode_barcode='00004786' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8366500',harga_beli ='8366500' WHERE kode_barcode='00004791' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8292000',harga_beli ='8292000' WHERE kode_barcode='00004795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7843500',harga_beli ='7843500' WHERE kode_barcode='00004797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5490500',harga_beli ='5490500' WHERE kode_barcode='00004802' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10122000',harga_beli ='10122000' WHERE kode_barcode='00004808' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00004813' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8815000',harga_beli ='8815000' WHERE kode_barcode='00004815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9935500',harga_beli ='9935500' WHERE kode_barcode='00004819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7806500',harga_beli ='7806500' WHERE kode_barcode='00004827' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6144500',harga_beli ='6144500' WHERE kode_barcode='00004835' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8049000',harga_beli ='8049000' WHERE kode_barcode='00004961' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00005075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6854000',harga_beli ='6854000' WHERE kode_barcode='00005477' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6574000',harga_beli ='6574000' WHERE kode_barcode='00005478' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7265000',harga_beli ='7265000' WHERE kode_barcode='00005887' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7694500',harga_beli ='7694500' WHERE kode_barcode='00006677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8161500',harga_beli ='8161500' WHERE kode_barcode='00006804' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7974500',harga_beli ='7974500' WHERE kode_barcode='00006874' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8478500',harga_beli ='8478500' WHERE kode_barcode='00007045' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00007084' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6387000',harga_beli ='6387000' WHERE kode_barcode='00007116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7395500',harga_beli ='7395500' WHERE kode_barcode='00008664' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7974500',harga_beli ='7974500' WHERE kode_barcode='00010025' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7582500',harga_beli ='7582500' WHERE kode_barcode='00010108' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8927000',harga_beli ='8927000' WHERE kode_barcode='00010656' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='27452500',harga_beli ='27452500' WHERE kode_barcode='00011077' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8329500',harga_beli ='8329500' WHERE kode_barcode='00011361' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7059500',harga_beli ='7059500' WHERE kode_barcode='00011376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='19198000',harga_beli ='19198000' WHERE kode_barcode='00011549' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4258000',harga_beli ='4258000' WHERE kode_barcode='00011566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7096500',harga_beli ='7096500' WHERE kode_barcode='00011567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00012223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5434500',harga_beli ='5434500' WHERE kode_barcode='00012263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5901500',harga_beli ='5901500' WHERE kode_barcode='00012296' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00012304' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00012321' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8590500',harga_beli ='8590500' WHERE kode_barcode='00012357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2857500',harga_beli ='2857500' WHERE kode_barcode='00012480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5042500',harga_beli ='5042500' WHERE kode_barcode='00012494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6928500',harga_beli ='6928500' WHERE kode_barcode='00012522' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6947500',harga_beli ='6947500' WHERE kode_barcode='00012539' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7526500',harga_beli ='7526500' WHERE kode_barcode='00012597' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7769000',harga_beli ='7769000' WHERE kode_barcode='00012744' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8590500',harga_beli ='8590500' WHERE kode_barcode='00012747' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1774500',harga_beli ='1774500' WHERE kode_barcode='00013148' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7302000',harga_beli ='7302000' WHERE kode_barcode='00013159' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6349500',harga_beli ='6349500' WHERE kode_barcode='00013205' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8422500',harga_beli ='8422500' WHERE kode_barcode='00013245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8254500',harga_beli ='8254500' WHERE kode_barcode='00013247' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1924000',harga_beli ='1924000' WHERE kode_barcode='00013328' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1867500',harga_beli ='1867500' WHERE kode_barcode='00013329' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1942500',harga_beli ='1942500' WHERE kode_barcode='00013339' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8012000',harga_beli ='8012000' WHERE kode_barcode='00014633' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8647000',harga_beli ='8647000' WHERE kode_barcode='00014655' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7881000',harga_beli ='7881000' WHERE kode_barcode='00014684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4165000',harga_beli ='4165000' WHERE kode_barcode='00015244' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00015388' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5322500',harga_beli ='5322500' WHERE kode_barcode='00015389' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00015565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2559000',harga_beli ='2559000' WHERE kode_barcode='00016237' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4333000',harga_beli ='4333000' WHERE kode_barcode='00016250' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9394000',harga_beli ='9394000' WHERE kode_barcode='00016328' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9057500',harga_beli ='9057500' WHERE kode_barcode='00016374' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11691000',harga_beli ='11691000' WHERE kode_barcode='00016703' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00016727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7750500',harga_beli ='7750500' WHERE kode_barcode='00016860' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11859000',harga_beli ='11859000' WHERE kode_barcode='00017033' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8553500',harga_beli ='8553500' WHERE kode_barcode='00017132' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6648500',harga_beli ='6648500' WHERE kode_barcode='00017581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='42803500',harga_beli ='42803500' WHERE kode_barcode='00017910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10178000',harga_beli ='10178000' WHERE kode_barcode='00017944' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7115500',harga_beli ='7115500' WHERE kode_barcode='00018063' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='35240000',harga_beli ='35240000' WHERE kode_barcode='00018110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00018767' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1793000',harga_beli ='1793000' WHERE kode_barcode='00018863' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6443000',harga_beli ='6443000' WHERE kode_barcode='00019096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7227500',harga_beli ='7227500' WHERE kode_barcode='00019107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7209000',harga_beli ='7209000' WHERE kode_barcode='00019121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00019196' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7414500',harga_beli ='7414500' WHERE kode_barcode='00019281' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5771000',harga_beli ='5771000' WHERE kode_barcode='00019303' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7638500',harga_beli ='7638500' WHERE kode_barcode='00019418' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9730000',harga_beli ='9730000' WHERE kode_barcode='00019442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5864000',harga_beli ='5864000' WHERE kode_barcode='00019764' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7657000',harga_beli ='7657000' WHERE kode_barcode='00019766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6443000',harga_beli ='6443000' WHERE kode_barcode='00019769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8198500',harga_beli ='8198500' WHERE kode_barcode='00019771' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7601000',harga_beli ='7601000' WHERE kode_barcode='00020056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7246000',harga_beli ='7246000' WHERE kode_barcode='00020057' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15071000',harga_beli ='15071000' WHERE kode_barcode='00020138' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7358000',harga_beli ='7358000' WHERE kode_barcode='00020160' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6592500',harga_beli ='6592500' WHERE kode_barcode='00020172' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7041000',harga_beli ='7041000' WHERE kode_barcode='00020177' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6816500',harga_beli ='6816500' WHERE kode_barcode='00020237' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8703000',harga_beli ='8703000' WHERE kode_barcode='00020257' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00020402' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00020403' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8441500',harga_beli ='8441500' WHERE kode_barcode='00020422' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9599000',harga_beli ='9599000' WHERE kode_barcode='00020763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1830500',harga_beli ='1830500' WHERE kode_barcode='00020898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6816500',harga_beli ='6816500' WHERE kode_barcode='00021016' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6910000',harga_beli ='6910000' WHERE kode_barcode='00021078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10702500',harga_beli ='10702500' WHERE kode_barcode='00021117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13655500',harga_beli ='13655500' WHERE kode_barcode='00021167' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9244500',harga_beli ='9244500' WHERE kode_barcode='00021252' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3306000',harga_beli ='3306000' WHERE kode_barcode='00021367' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7638500',harga_beli ='7638500' WHERE kode_barcode='00021417' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='20281500',harga_beli ='20281500' WHERE kode_barcode='00021421' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7253000',harga_beli ='7253000' WHERE kode_barcode='00021447' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17069000',harga_beli ='17069000' WHERE kode_barcode='00021482' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3118500',harga_beli ='3118500' WHERE kode_barcode='00021529' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7253000',harga_beli ='7253000' WHERE kode_barcode='00021541' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3213000',harga_beli ='3213000' WHERE kode_barcode='00021558' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4040000',harga_beli ='4040000' WHERE kode_barcode='00021563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4985000',harga_beli ='4985000' WHERE kode_barcode='00021661' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10560500',harga_beli ='10560500' WHERE kode_barcode='00021691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7276500',harga_beli ='7276500' WHERE kode_barcode='00021699' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7276500',harga_beli ='7276500' WHERE kode_barcode='00021836' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7773000',harga_beli ='7773000' WHERE kode_barcode='00021840' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7017000',harga_beli ='7017000' WHERE kode_barcode='00021843' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7619500',harga_beli ='7619500' WHERE kode_barcode='00021889' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10495500',harga_beli ='10495500' WHERE kode_barcode='00021902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6686000',harga_beli ='6686000' WHERE kode_barcode='00022005' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1924000',harga_beli ='1924000' WHERE kode_barcode='00022032' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6088500',harga_beli ='6088500' WHERE kode_barcode='00022038' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6462000',harga_beli ='6462000' WHERE kode_barcode='00022049' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9972500',harga_beli ='9972500' WHERE kode_barcode='00022095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12083000',harga_beli ='12083000' WHERE kode_barcode='00022100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11224000',harga_beli ='11224000' WHERE kode_barcode='00022102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='00022110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10029000',harga_beli ='10029000' WHERE kode_barcode='00022126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8217500',harga_beli ='8217500' WHERE kode_barcode='00022127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6181500',harga_beli ='6181500' WHERE kode_barcode='00022129' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7265000',harga_beli ='7265000' WHERE kode_barcode='00022130' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6760500',harga_beli ='6760500' WHERE kode_barcode='00022133' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5547000',harga_beli ='5547000' WHERE kode_barcode='00022134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9450000',harga_beli ='9450000' WHERE kode_barcode='00022136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7582500',harga_beli ='7582500' WHERE kode_barcode='00022137' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7115500',harga_beli ='7115500' WHERE kode_barcode='00022197' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7395500',harga_beli ='7395500' WHERE kode_barcode='00022199' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8871000',harga_beli ='8871000' WHERE kode_barcode='00022210' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7171500',harga_beli ='7171500' WHERE kode_barcode='00022213' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6256500',harga_beli ='6256500' WHERE kode_barcode='00022235' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00022247' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10645000',harga_beli ='10645000' WHERE kode_barcode='00022275' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5845500',harga_beli ='5845500' WHERE kode_barcode='00022453' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6213500',harga_beli ='6213500' WHERE kode_barcode='00022495' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4557000',harga_beli ='4557000' WHERE kode_barcode='00022505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3567000',harga_beli ='3567000' WHERE kode_barcode='00022545' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4949000',harga_beli ='4949000' WHERE kode_barcode='00022582' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00022608' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12027000',harga_beli ='12027000' WHERE kode_barcode='00022631' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00022696' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14809500',harga_beli ='14809500' WHERE kode_barcode='00022717' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5481000',harga_beli ='5481000' WHERE kode_barcode='00022786' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4912000',harga_beli ='4912000' WHERE kode_barcode='00022794' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3586000',harga_beli ='3586000' WHERE kode_barcode='00022869' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4968000',harga_beli ='4968000' WHERE kode_barcode='00022923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5061000',harga_beli ='5061000' WHERE kode_barcode='00022943' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='19067500',harga_beli ='19067500' WHERE kode_barcode='00022948' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4930500',harga_beli ='4930500' WHERE kode_barcode='00022981' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6119000',harga_beli ='6119000' WHERE kode_barcode='00023122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00023292' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='00023295' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5864000',harga_beli ='5864000' WHERE kode_barcode='00023336' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9879500',harga_beli ='9879500' WHERE kode_barcode='00023351' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6051000',harga_beli ='6051000' WHERE kode_barcode='00023436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8572000',harga_beli ='8572000' WHERE kode_barcode='00023496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00023497' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00023544' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6837000',harga_beli ='6837000' WHERE kode_barcode='00023684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00023715' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5490500',harga_beli ='5490500' WHERE kode_barcode='00023716' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11130500',harga_beli ='11130500' WHERE kode_barcode='00023724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18320500',harga_beli ='18320500' WHERE kode_barcode='00023725' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4102500',harga_beli ='4102500' WHERE kode_barcode='00023732' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7227500',harga_beli ='7227500' WHERE kode_barcode='00023740' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='79722000',harga_beli ='79722000' WHERE kode_barcode='00023898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6611000',harga_beli ='6611000' WHERE kode_barcode='00023930' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7489000',harga_beli ='7489000' WHERE kode_barcode='00024058' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3249500',harga_beli ='3249500' WHERE kode_barcode='00024125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5715000',harga_beli ='5715000' WHERE kode_barcode='00024232' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2465500',harga_beli ='2465500' WHERE kode_barcode='00024280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5565500',harga_beli ='5565500' WHERE kode_barcode='00024289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5864000',harga_beli ='5864000' WHERE kode_barcode='00024323' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7937000',harga_beli ='7937000' WHERE kode_barcode='00024431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10290000',harga_beli ='10290000' WHERE kode_barcode='00024449' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3231000',harga_beli ='3231000' WHERE kode_barcode='00024465' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3193500',harga_beli ='3193500' WHERE kode_barcode='00024466' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14716500',harga_beli ='14716500' WHERE kode_barcode='00024580' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6443000',harga_beli ='6443000' WHERE kode_barcode='00024620' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6163000',harga_beli ='6163000' WHERE kode_barcode='00024630' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00024714' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3569000',harga_beli ='3569000' WHERE kode_barcode='00024718' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7810500',harga_beli ='7810500' WHERE kode_barcode='00024725' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3044500',harga_beli ='3044500' WHERE kode_barcode='00024780' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5098500',harga_beli ='5098500' WHERE kode_barcode='00024886' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6256500',harga_beli ='6256500' WHERE kode_barcode='00024943' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17368000',harga_beli ='17368000' WHERE kode_barcode='00025003' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5453500',harga_beli ='5453500' WHERE kode_barcode='00025036' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00025074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00025080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00025156' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4445000',harga_beli ='4445000' WHERE kode_barcode='00025172' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4557000',harga_beli ='4557000' WHERE kode_barcode='00025196' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7059500',harga_beli ='7059500' WHERE kode_barcode='00025197' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5696000',harga_beli ='5696000' WHERE kode_barcode='00025220' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6767500',harga_beli ='6767500' WHERE kode_barcode='00025260' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4093000',harga_beli ='4093000' WHERE kode_barcode='00025261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6872500',harga_beli ='6872500' WHERE kode_barcode='00025263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9803500',harga_beli ='9803500' WHERE kode_barcode='00025307' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8366500',harga_beli ='8366500' WHERE kode_barcode='00025361' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00025375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00025379' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10271500',harga_beli ='10271500' WHERE kode_barcode='00025416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2783000',harga_beli ='2783000' WHERE kode_barcode='00025473' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4264500',harga_beli ='4264500' WHERE kode_barcode='00025489' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7347000',harga_beli ='7347000' WHERE kode_barcode='00025571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7974500',harga_beli ='7974500' WHERE kode_barcode='00025657' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14716500',harga_beli ='14716500' WHERE kode_barcode='00025665' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00025821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00025828' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6462000',harga_beli ='6462000' WHERE kode_barcode='00025841' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5509500',harga_beli ='5509500' WHERE kode_barcode='00025856' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4893000',harga_beli ='4893000' WHERE kode_barcode='00025859' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6628500',harga_beli ='6628500' WHERE kode_barcode='00025929' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8343000',harga_beli ='8343000' WHERE kode_barcode='00025937' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='19235500',harga_beli ='19235500' WHERE kode_barcode='00026221' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='27994000',harga_beli ='27994000' WHERE kode_barcode='00026314' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8497500',harga_beli ='8497500' WHERE kode_barcode='00026393' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5214500',harga_beli ='5214500' WHERE kode_barcode='00026397' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9113500',harga_beli ='9113500' WHERE kode_barcode='00026406' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8983000',harga_beli ='8983000' WHERE kode_barcode='00026412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13390500',harga_beli ='13390500' WHERE kode_barcode='00026445' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6349500',harga_beli ='6349500' WHERE kode_barcode='00026574' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5266500',harga_beli ='5266500' WHERE kode_barcode='00026593' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00026598' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8086500',harga_beli ='8086500' WHERE kode_barcode='00026599' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8389500',harga_beli ='8389500' WHERE kode_barcode='00026648' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='20001000',harga_beli ='20001000' WHERE kode_barcode='00026780' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1849000',harga_beli ='1849000' WHERE kode_barcode='00026918' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='28031500',harga_beli ='28031500' WHERE kode_barcode='00026949' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6396500',harga_beli ='6396500' WHERE kode_barcode='00027230' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7041000',harga_beli ='7041000' WHERE kode_barcode='00027444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12363000',harga_beli ='12363000' WHERE kode_barcode='00027450' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='49594500',harga_beli ='49594500' WHERE kode_barcode='00027461' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00027463' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7153000',harga_beli ='7153000' WHERE kode_barcode='00027465' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9020500',harga_beli ='9020500' WHERE kode_barcode='00027504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7625000',harga_beli ='7625000' WHERE kode_barcode='00027507' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00027508' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4820500',harga_beli ='4820500' WHERE kode_barcode='00027540' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12468500',harga_beli ='12468500' WHERE kode_barcode='00027705' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7489000',harga_beli ='7489000' WHERE kode_barcode='00027723' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6798000',harga_beli ='6798000' WHERE kode_barcode='00027724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9151000',harga_beli ='9151000' WHERE kode_barcode='00027752' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5995000',harga_beli ='5995000' WHERE kode_barcode='00027757' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7265000',harga_beli ='7265000' WHERE kode_barcode='00027860' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6872500',harga_beli ='6872500' WHERE kode_barcode='00027877' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6331000',harga_beli ='6331000' WHERE kode_barcode='00027879' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00027905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='32376000',harga_beli ='32376000' WHERE kode_barcode='00027962' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00027983' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5266500',harga_beli ='5266500' WHERE kode_barcode='00027984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7358000',harga_beli ='7358000' WHERE kode_barcode='00028015' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7750500',harga_beli ='7750500' WHERE kode_barcode='00028063' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5995000',harga_beli ='5995000' WHERE kode_barcode='00028067' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15370000',harga_beli ='15370000' WHERE kode_barcode='00028081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9356500',harga_beli ='9356500' WHERE kode_barcode='00028100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6368500',harga_beli ='6368500' WHERE kode_barcode='00028175' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5341500',harga_beli ='5341500' WHERE kode_barcode='00028176' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2857500',harga_beli ='2857500' WHERE kode_barcode='00028218' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00028234' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00028239' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4148500',harga_beli ='4148500' WHERE kode_barcode='00028276' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11309500',harga_beli ='11309500' WHERE kode_barcode='00028289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13819500',harga_beli ='13819500' WHERE kode_barcode='00028318' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7949500',harga_beli ='7949500' WHERE kode_barcode='00028373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8124000',harga_beli ='8124000' WHERE kode_barcode='00028463' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5416000',harga_beli ='5416000' WHERE kode_barcode='00028555' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8366500',harga_beli ='8366500' WHERE kode_barcode='00028564' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6032500',harga_beli ='6032500' WHERE kode_barcode='00028580' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4557000',harga_beli ='4557000' WHERE kode_barcode='00028594' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9224000',harga_beli ='9224000' WHERE kode_barcode='00028855' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13147500',harga_beli ='13147500' WHERE kode_barcode='00028860' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5005000',harga_beli ='5005000' WHERE kode_barcode='00028922' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5472000',harga_beli ='5472000' WHERE kode_barcode='00028928' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7059500',harga_beli ='7059500' WHERE kode_barcode='00028932' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6574000',harga_beli ='6574000' WHERE kode_barcode='00028933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6368500',harga_beli ='6368500' WHERE kode_barcode='00028934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00028990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8404000',harga_beli ='8404000' WHERE kode_barcode='00028995' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9879500',harga_beli ='9879500' WHERE kode_barcode='00028996' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00029075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7171500',harga_beli ='7171500' WHERE kode_barcode='00029078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7956000',harga_beli ='7956000' WHERE kode_barcode='00029079' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6704500',harga_beli ='6704500' WHERE kode_barcode='00029080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5173500',harga_beli ='5173500' WHERE kode_barcode='00029093' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8343000',harga_beli ='8343000' WHERE kode_barcode='00029127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5191500',harga_beli ='5191500' WHERE kode_barcode='00029206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='22298000',harga_beli ='22298000' WHERE kode_barcode='00029215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9201000',harga_beli ='9201000' WHERE kode_barcode='00029227' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9954000',harga_beli ='9954000' WHERE kode_barcode='00029231' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='26743000',harga_beli ='26743000' WHERE kode_barcode='00029243' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4426500',harga_beli ='4426500' WHERE kode_barcode='00029336' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5547000',harga_beli ='5547000' WHERE kode_barcode='00029491' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4171500',harga_beli ='4171500' WHERE kode_barcode='00029505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3586000',harga_beli ='3586000' WHERE kode_barcode='00029520' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8250500',harga_beli ='8250500' WHERE kode_barcode='00029522' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5827000',harga_beli ='5827000' WHERE kode_barcode='00029534' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00029579' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6611000',harga_beli ='6611000' WHERE kode_barcode='00029581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7843500',harga_beli ='7843500' WHERE kode_barcode='00029582' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8714000',harga_beli ='8714000' WHERE kode_barcode='00029738' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7582500',harga_beli ='7582500' WHERE kode_barcode='00029769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5565500',harga_beli ='5565500' WHERE kode_barcode='00029771' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00029801' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6499000',harga_beli ='6499000' WHERE kode_barcode='00029867' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6107000',harga_beli ='6107000' WHERE kode_barcode='00029892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5416000',harga_beli ='5416000' WHERE kode_barcode='00029931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4781000',harga_beli ='4781000' WHERE kode_barcode='00029934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00029973' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14921500',harga_beli ='14921500' WHERE kode_barcode='00030008' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17706000',harga_beli ='17706000' WHERE kode_barcode='00030122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6219000',harga_beli ='6219000' WHERE kode_barcode='00030130' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4258000',harga_beli ='4258000' WHERE kode_barcode='00030134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9151000',harga_beli ='9151000' WHERE kode_barcode='00030136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4202000',harga_beli ='4202000' WHERE kode_barcode='00030147' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5416000',harga_beli ='5416000' WHERE kode_barcode='00030194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='26126500',harga_beli ='26126500' WHERE kode_barcode='00030212' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11280000',harga_beli ='11280000' WHERE kode_barcode='00030220' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='16303500',harga_beli ='16303500' WHERE kode_barcode='00030221' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3847500',harga_beli ='3847500' WHERE kode_barcode='00030257' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5827000',harga_beli ='5827000' WHERE kode_barcode='00030258' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11896500',harga_beli ='11896500' WHERE kode_barcode='00030263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6779500',harga_beli ='6779500' WHERE kode_barcode='00030412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13745000',harga_beli ='13745000' WHERE kode_barcode='00030418' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3679500',harga_beli ='3679500' WHERE kode_barcode='00030450' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7096500',harga_beli ='7096500' WHERE kode_barcode='00030456' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='20209000',harga_beli ='20209000' WHERE kode_barcode='00030526' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6462000',harga_beli ='6462000' WHERE kode_barcode='00030555' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='24277500',harga_beli ='24277500' WHERE kode_barcode='00030581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5042500',harga_beli ='5042500' WHERE kode_barcode='00030655' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8161500',harga_beli ='8161500' WHERE kode_barcode='00030682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9525000',harga_beli ='9525000' WHERE kode_barcode='00030684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6928500',harga_beli ='6928500' WHERE kode_barcode='00030700' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6790500',harga_beli ='6790500' WHERE kode_barcode='00030817' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7041000',harga_beli ='7041000' WHERE kode_barcode='00030828' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5266500',harga_beli ='5266500' WHERE kode_barcode='00030840' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7937000',harga_beli ='7937000' WHERE kode_barcode='00030842' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4165000',harga_beli ='4165000' WHERE kode_barcode='00030976' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='00030977' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2446500',harga_beli ='2446500' WHERE kode_barcode='00030991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2446500',harga_beli ='2446500' WHERE kode_barcode='00030992' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00030995' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00030996' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12045500',harga_beli ='12045500' WHERE kode_barcode='00031010' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6582000',harga_beli ='6582000' WHERE kode_barcode='00031011' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14940000',harga_beli ='14940000' WHERE kode_barcode='00031034' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8572000',harga_beli ='8572000' WHERE kode_barcode='00031078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3511000',harga_beli ='3511000' WHERE kode_barcode='00031089' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5322500',harga_beli ='5322500' WHERE kode_barcode='00031091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8204000',harga_beli ='8204000' WHERE kode_barcode='00031094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='34160000',harga_beli ='34160000' WHERE kode_barcode='00031196' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4333000',harga_beli ='4333000' WHERE kode_barcode='00031299' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6976000',harga_beli ='6976000' WHERE kode_barcode='00031445' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7302000',harga_beli ='7302000' WHERE kode_barcode='00031478' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7526500',harga_beli ='7526500' WHERE kode_barcode='00031482' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8217500',harga_beli ='8217500' WHERE kode_barcode='00031509' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00031556' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21877500',harga_beli ='21877500' WHERE kode_barcode='00031561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8124000',harga_beli ='8124000' WHERE kode_barcode='00031575' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3175000',harga_beli ='3175000' WHERE kode_barcode='00031581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8413000',harga_beli ='8413000' WHERE kode_barcode='00031605' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11933500',harga_beli ='11933500' WHERE kode_barcode='00031842' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11653500',harga_beli ='11653500' WHERE kode_barcode='00031849' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00031851' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7433000',harga_beli ='7433000' WHERE kode_barcode='00031879' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8983000',harga_beli ='8983000' WHERE kode_barcode='00031886' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00031891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='26705500',harga_beli ='26705500' WHERE kode_barcode='00032044' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6163000',harga_beli ='6163000' WHERE kode_barcode='00032059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6280500',harga_beli ='6280500' WHERE kode_barcode='00032082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5995000',harga_beli ='5995000' WHERE kode_barcode='00032083' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00032091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11074500',harga_beli ='11074500' WHERE kode_barcode='00032141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8049000',harga_beli ='8049000' WHERE kode_barcode='00032161' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3679500',harga_beli ='3679500' WHERE kode_barcode='00032172' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='00032179' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5886500',harga_beli ='5886500' WHERE kode_barcode='00032246' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3828500',harga_beli ='3828500' WHERE kode_barcode='00032315' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14670000',harga_beli ='14670000' WHERE kode_barcode='00032340' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='37659500',harga_beli ='37659500' WHERE kode_barcode='00032401' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8158000',harga_beli ='8158000' WHERE kode_barcode='00032406' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00032453' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11485500',harga_beli ='11485500' WHERE kode_barcode='00032488' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='23026500',harga_beli ='23026500' WHERE kode_barcode='00032587' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7713000',harga_beli ='7713000' WHERE kode_barcode='00032592' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11286500',harga_beli ='11286500' WHERE kode_barcode='00032647' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7578500',harga_beli ='7578500' WHERE kode_barcode='00032766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7657000',harga_beli ='7657000' WHERE kode_barcode='00032769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5845500',harga_beli ='5845500' WHERE kode_barcode='00032770' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00032789' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5154500',harga_beli ='5154500' WHERE kode_barcode='00032790' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5173500',harga_beli ='5173500' WHERE kode_barcode='00032791' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00032809' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00032821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4986500',harga_beli ='4986500' WHERE kode_barcode='00032823' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2260000',harga_beli ='2260000' WHERE kode_barcode='00032896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00033141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3418000',harga_beli ='3418000' WHERE kode_barcode='00033144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3660500',harga_beli ='3660500' WHERE kode_barcode='00033145' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5920500',harga_beli ='5920500' WHERE kode_barcode='00033146' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00033154' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00033155' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3716500',harga_beli ='3716500' WHERE kode_barcode='00033159' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12028000',harga_beli ='12028000' WHERE kode_barcode='00033179' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10514500',harga_beli ='10514500' WHERE kode_barcode='00033180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5168500',harga_beli ='5168500' WHERE kode_barcode='00033189' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4426500',harga_beli ='4426500' WHERE kode_barcode='00033200' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4538500',harga_beli ='4538500' WHERE kode_barcode='00033202' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3884500',harga_beli ='3884500' WHERE kode_barcode='00033206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00033208' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='00033210' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5920500',harga_beli ='5920500' WHERE kode_barcode='00033237' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3044500',harga_beli ='3044500' WHERE kode_barcode='00033240' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8684000',harga_beli ='8684000' WHERE kode_barcode='00033245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21756500',harga_beli ='21756500' WHERE kode_barcode='00033248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00033279' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14623000',harga_beli ='14623000' WHERE kode_barcode='00033286' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6518000',harga_beli ='6518000' WHERE kode_barcode='00033288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6144500',harga_beli ='6144500' WHERE kode_barcode='00033316' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3361500',harga_beli ='3361500' WHERE kode_barcode='00033350' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4380500',harga_beli ='4380500' WHERE kode_barcode='00033352' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='35041000',harga_beli ='35041000' WHERE kode_barcode='00033374' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1905000',harga_beli ='1905000' WHERE kode_barcode='00033440' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='24707500',harga_beli ='24707500' WHERE kode_barcode='00033441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10081500',harga_beli ='10081500' WHERE kode_barcode='00033442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5024000',harga_beli ='5024000' WHERE kode_barcode='00033452' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='00033494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='00033496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7171500',harga_beli ='7171500' WHERE kode_barcode='00033522' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00033535' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5145000',harga_beli ='5145000' WHERE kode_barcode='00033542' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7377000',harga_beli ='7377000' WHERE kode_barcode='00033550' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4195000',harga_beli ='4195000' WHERE kode_barcode='00033788' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4893000',harga_beli ='4893000' WHERE kode_barcode='00033816' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2433500',harga_beli ='2433500' WHERE kode_barcode='00033818' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5285500',harga_beli ='5285500' WHERE kode_barcode='00033886' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6555000',harga_beli ='6555000' WHERE kode_barcode='00033893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00033895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11578500',harga_beli ='11578500' WHERE kode_barcode='00034016' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2178500',harga_beli ='2178500' WHERE kode_barcode='00034017' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11101000',harga_beli ='11101000' WHERE kode_barcode='00034025' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7451500',harga_beli ='7451500' WHERE kode_barcode='00034027' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6331000',harga_beli ='6331000' WHERE kode_barcode='00034047' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7358000',harga_beli ='7358000' WHERE kode_barcode='00034092' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00034096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3917000',harga_beli ='3917000' WHERE kode_barcode='00034119' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00034170' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8030500',harga_beli ='8030500' WHERE kode_barcode='00034171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9386000',harga_beli ='9386000' WHERE kode_barcode='00034172' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10570500',harga_beli ='10570500' WHERE kode_barcode='00034178' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7209000',harga_beli ='7209000' WHERE kode_barcode='00034179' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3175500',harga_beli ='3175500' WHERE kode_barcode='00034182' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00034183' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4912000',harga_beli ='4912000' WHERE kode_barcode='00034255' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5469500',harga_beli ='5469500' WHERE kode_barcode='00034321' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00034323' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='00034326' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00034335' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2988000',harga_beli ='2988000' WHERE kode_barcode='00034396' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2689500',harga_beli ='2689500' WHERE kode_barcode='00034408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7227500',harga_beli ='7227500' WHERE kode_barcode='00034468' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6630000',harga_beli ='6630000' WHERE kode_barcode='00034496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5957500',harga_beli ='5957500' WHERE kode_barcode='00034646' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4374000',harga_beli ='4374000' WHERE kode_barcode='00034662' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00034698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7190000',harga_beli ='7190000' WHERE kode_barcode='00034744' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5416000',harga_beli ='5416000' WHERE kode_barcode='00034745' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00034746' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00034750' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5360000',harga_beli ='5360000' WHERE kode_barcode='00034751' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5677500',harga_beli ='5677500' WHERE kode_barcode='00034752' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='28143500',harga_beli ='28143500' WHERE kode_barcode='00034842' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3548500',harga_beli ='3548500' WHERE kode_barcode='00034864' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12677000',harga_beli ='12677000' WHERE kode_barcode='00034912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3731500',harga_beli ='3731500' WHERE kode_barcode='00034914' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6667500',harga_beli ='6667500' WHERE kode_barcode='00034919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5360000',harga_beli ='5360000' WHERE kode_barcode='00034991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6219000',harga_beli ='6219000' WHERE kode_barcode='00034994' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9860500',harga_beli ='9860500' WHERE kode_barcode='00034996' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6816500',harga_beli ='6816500' WHERE kode_barcode='00034998' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10197000',harga_beli ='10197000' WHERE kode_barcode='00034999' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12494000',harga_beli ='12494000' WHERE kode_barcode='00035009' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5266500',harga_beli ='5266500' WHERE kode_barcode='00035024' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7439500',harga_beli ='7439500' WHERE kode_barcode='00035048' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='48691000',harga_beli ='48691000' WHERE kode_barcode='00035055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2271500',harga_beli ='2271500' WHERE kode_barcode='00035060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8158000',harga_beli ='8158000' WHERE kode_barcode='00035069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6489000',harga_beli ='6489000' WHERE kode_barcode='00035084' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12909000',harga_beli ='12909000' WHERE kode_barcode='00035088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12960000',harga_beli ='12960000' WHERE kode_barcode='00035089' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7638500',harga_beli ='7638500' WHERE kode_barcode='00035090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8806500',harga_beli ='8806500' WHERE kode_barcode='00035098' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00035100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9757000',harga_beli ='9757000' WHERE kode_barcode='00035101' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00035102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13894500',harga_beli ='13894500' WHERE kode_barcode='00035104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8644500',harga_beli ='8644500' WHERE kode_barcode='00035106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11074500',harga_beli ='11074500' WHERE kode_barcode='00035107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9394000',harga_beli ='9394000' WHERE kode_barcode='00035122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4463500',harga_beli ='4463500' WHERE kode_barcode='00035127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5061000',harga_beli ='5061000' WHERE kode_barcode='00035128' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18563000',harga_beli ='18563000' WHERE kode_barcode='00035158' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8180000',harga_beli ='8180000' WHERE kode_barcode='00035219' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9340000',harga_beli ='9340000' WHERE kode_barcode='00035275' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4109000',harga_beli ='4109000' WHERE kode_barcode='00035276' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9988500',harga_beli ='9988500' WHERE kode_barcode='00035327' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10359500',harga_beli ='10359500' WHERE kode_barcode='00035330' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='19606500',harga_beli ='19606500' WHERE kode_barcode='00035376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4370000',harga_beli ='4370000' WHERE kode_barcode='00035381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6860000',harga_beli ='6860000' WHERE kode_barcode='00035418' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5490500',harga_beli ='5490500' WHERE kode_barcode='00035419' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7115500',harga_beli ='7115500' WHERE kode_barcode='00035462' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6872500',harga_beli ='6872500' WHERE kode_barcode='00035463' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17474000',harga_beli ='17474000' WHERE kode_barcode='00035472' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6489000',harga_beli ='6489000' WHERE kode_barcode='00035492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5901500',harga_beli ='5901500' WHERE kode_barcode='00035498' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00035499' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4496000',harga_beli ='4496000' WHERE kode_barcode='00035520' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10359500',harga_beli ='10359500' WHERE kode_barcode='00035521' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00035523' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5957500',harga_beli ='5957500' WHERE kode_barcode='00035524' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8436000',harga_beli ='8436000' WHERE kode_barcode='00035539' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00035571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5434500',harga_beli ='5434500' WHERE kode_barcode='00035616' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3511000',harga_beli ='3511000' WHERE kode_barcode='00035619' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11217000',harga_beli ='11217000' WHERE kode_barcode='00035829' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11784000',harga_beli ='11784000' WHERE kode_barcode='00036059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6910000',harga_beli ='6910000' WHERE kode_barcode='00036081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13876000',harga_beli ='13876000' WHERE kode_barcode='00036089' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00036288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4473000',harga_beli ='4473000' WHERE kode_barcode='00036289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8329500',harga_beli ='8329500' WHERE kode_barcode='00036342' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12236500',harga_beli ='12236500' WHERE kode_barcode='00036345' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6952500',harga_beli ='6952500' WHERE kode_barcode='00036404' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5024000',harga_beli ='5024000' WHERE kode_barcode='00036409' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6779500',harga_beli ='6779500' WHERE kode_barcode='00036450' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4482000',harga_beli ='4482000' WHERE kode_barcode='00036451' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5005000',harga_beli ='5005000' WHERE kode_barcode='00036453' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6256500',harga_beli ='6256500' WHERE kode_barcode='00036684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9450000',harga_beli ='9450000' WHERE kode_barcode='00036690' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00036694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6952500',harga_beli ='6952500' WHERE kode_barcode='00036695' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3569000',harga_beli ='3569000' WHERE kode_barcode='00036697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1924000',harga_beli ='1924000' WHERE kode_barcode='00036698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4195000',harga_beli ='4195000' WHERE kode_barcode='00036773' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9293500',harga_beli ='9293500' WHERE kode_barcode='00036795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3081500',harga_beli ='3081500' WHERE kode_barcode='00036796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7507500',harga_beli ='7507500' WHERE kode_barcode='00036797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5238000',harga_beli ='5238000' WHERE kode_barcode='00036798' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3436500',harga_beli ='3436500' WHERE kode_barcode='00036800' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13371500',harga_beli ='13371500' WHERE kode_barcode='00036862' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21182000',harga_beli ='21182000' WHERE kode_barcode='00036863' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10495500',harga_beli ='10495500' WHERE kode_barcode='00036865' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5322500',harga_beli ='5322500' WHERE kode_barcode='00036867' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4681500',harga_beli ='4681500' WHERE kode_barcode='00036896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2341000',harga_beli ='2341000' WHERE kode_barcode='00036901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3492500',harga_beli ='3492500' WHERE kode_barcode='00036923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5052500',harga_beli ='5052500' WHERE kode_barcode='00036948' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12904500',harga_beli ='12904500' WHERE kode_barcode='00037020' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6704500',harga_beli ='6704500' WHERE kode_barcode='00037027' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4403500',harga_beli ='4403500' WHERE kode_barcode='00037053' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9061500',harga_beli ='9061500' WHERE kode_barcode='00037056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2241000',harga_beli ='2241000' WHERE kode_barcode='00037061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11541500',harga_beli ='11541500' WHERE kode_barcode='00037090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7246000',harga_beli ='7246000' WHERE kode_barcode='00037091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17928000',harga_beli ='17928000' WHERE kode_barcode='00037095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4519500',harga_beli ='4519500' WHERE kode_barcode='00037151' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8647000',harga_beli ='8647000' WHERE kode_barcode='00037152' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7601500',harga_beli ='7601500' WHERE kode_barcode='00037261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='28300500',harga_beli ='28300500' WHERE kode_barcode='00037330' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3828500',harga_beli ='3828500' WHERE kode_barcode='00037401' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='19123500',harga_beli ='19123500' WHERE kode_barcode='00037407' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10925000',harga_beli ='10925000' WHERE kode_barcode='00037409' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17706000',harga_beli ='17706000' WHERE kode_barcode='00037412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00037416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00037419' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00037422' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2745500',harga_beli ='2745500' WHERE kode_barcode='00037424' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3287000',harga_beli ='3287000' WHERE kode_barcode='00037425' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2148000',harga_beli ='2148000' WHERE kode_barcode='00037426' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2689500',harga_beli ='2689500' WHERE kode_barcode='00037430' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4631500',harga_beli ='4631500' WHERE kode_barcode='00037434' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00037436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6630000',harga_beli ='6630000' WHERE kode_barcode='00037446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9781000',harga_beli ='9781000' WHERE kode_barcode='00037460' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17590000',harga_beli ='17590000' WHERE kode_barcode='00037516' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7972500',harga_beli ='7972500' WHERE kode_barcode='00037517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8740000',harga_beli ='8740000' WHERE kode_barcode='00037518' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13315500',harga_beli ='13315500' WHERE kode_barcode='00037566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11971000',harga_beli ='11971000' WHERE kode_barcode='00037567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10906500',harga_beli ='10906500' WHERE kode_barcode='00037574' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4557000',harga_beli ='4557000' WHERE kode_barcode='00037604' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6176500',harga_beli ='6176500' WHERE kode_barcode='00037606' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='00037665' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3884500',harga_beli ='3884500' WHERE kode_barcode='00037666' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2932500',harga_beli ='2932500' WHERE kode_barcode='00037675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4781000',harga_beli ='4781000' WHERE kode_barcode='00037676' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3903500',harga_beli ='3903500' WHERE kode_barcode='00037678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6682500',harga_beli ='6682500' WHERE kode_barcode='00037793' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='00037796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6686000',harga_beli ='6686000' WHERE kode_barcode='00037829' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9786000',harga_beli ='9786000' WHERE kode_barcode='00037899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11217000',harga_beli ='11217000' WHERE kode_barcode='00037900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5889500',harga_beli ='5889500' WHERE kode_barcode='00037906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2297500',harga_beli ='2297500' WHERE kode_barcode='00037957' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6574000',harga_beli ='6574000' WHERE kode_barcode='00037959' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='00037963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2446500',harga_beli ='2446500' WHERE kode_barcode='00037964' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9562000',harga_beli ='9562000' WHERE kode_barcode='00037965' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3291000',harga_beli ='3291000' WHERE kode_barcode='00037977' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6742000',harga_beli ='6742000' WHERE kode_barcode='00037978' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6499000',harga_beli ='6499000' WHERE kode_barcode='00037979' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6630000',harga_beli ='6630000' WHERE kode_barcode='00037981' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6704500',harga_beli ='6704500' WHERE kode_barcode='00037984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3175000',harga_beli ='3175000' WHERE kode_barcode='00037985' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5490500',harga_beli ='5490500' WHERE kode_barcode='00037986' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7993000',harga_beli ='7993000' WHERE kode_barcode='00037990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4032500',harga_beli ='4032500' WHERE kode_barcode='00037991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6069500',harga_beli ='6069500' WHERE kode_barcode='00038002' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4949000',harga_beli ='4949000' WHERE kode_barcode='00038006' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7323500',harga_beli ='7323500' WHERE kode_barcode='00038008' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6088500',harga_beli ='6088500' WHERE kode_barcode='00038010' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3824000',harga_beli ='3824000' WHERE kode_barcode='00038012' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00038034' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7003500',harga_beli ='7003500' WHERE kode_barcode='00038035' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11915000',harga_beli ='11915000' WHERE kode_barcode='00038036' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4893000',harga_beli ='4893000' WHERE kode_barcode='00038037' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6779500',harga_beli ='6779500' WHERE kode_barcode='00038047' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6387000',harga_beli ='6387000' WHERE kode_barcode='00038048' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4277000',harga_beli ='4277000' WHERE kode_barcode='00038049' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4183500',harga_beli ='4183500' WHERE kode_barcode='00038050' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00038052' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4968000',harga_beli ='4968000' WHERE kode_barcode='00038056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6686000',harga_beli ='6686000' WHERE kode_barcode='00038057' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00038058' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4781000',harga_beli ='4781000' WHERE kode_barcode='00038059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00038060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5061000',harga_beli ='5061000' WHERE kode_barcode='00038061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7750500',harga_beli ='7750500' WHERE kode_barcode='00038063' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5341500',harga_beli ='5341500' WHERE kode_barcode='00038064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8180000',harga_beli ='8180000' WHERE kode_barcode='00038065' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5883000',harga_beli ='5883000' WHERE kode_barcode='00038067' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00038068' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6032500',harga_beli ='6032500' WHERE kode_barcode='00038069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00038070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5192000',harga_beli ='5192000' WHERE kode_barcode='00038071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5715000',harga_beli ='5715000' WHERE kode_barcode='00038073' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00038074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3940500',harga_beli ='3940500' WHERE kode_barcode='00038075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7489000',harga_beli ='7489000' WHERE kode_barcode='00038076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4837000',harga_beli ='4837000' WHERE kode_barcode='00038078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6704500',harga_beli ='6704500' WHERE kode_barcode='00038080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00038081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5640000',harga_beli ='5640000' WHERE kode_barcode='00038082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8740000',harga_beli ='8740000' WHERE kode_barcode='00038083' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4519500',harga_beli ='4519500' WHERE kode_barcode='00038084' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6555000',harga_beli ='6555000' WHERE kode_barcode='00038085' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5547000',harga_beli ='5547000' WHERE kode_barcode='00038086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10738500',harga_beli ='10738500' WHERE kode_barcode='00038087' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7190000',harga_beli ='7190000' WHERE kode_barcode='00038088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7545000',harga_beli ='7545000' WHERE kode_barcode='00038089' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3754000',harga_beli ='3754000' WHERE kode_barcode='00038090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4968000',harga_beli ='4968000' WHERE kode_barcode='00038091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3436500',harga_beli ='3436500' WHERE kode_barcode='00038092' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6219000',harga_beli ='6219000' WHERE kode_barcode='00038093' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5098500',harga_beli ='5098500' WHERE kode_barcode='00038094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8217500',harga_beli ='8217500' WHERE kode_barcode='00038095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9412500',harga_beli ='9412500' WHERE kode_barcode='00038096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8609500',harga_beli ='8609500' WHERE kode_barcode='00038097' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6592500',harga_beli ='6592500' WHERE kode_barcode='00038098' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4463500',harga_beli ='4463500' WHERE kode_barcode='00038100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5509500',harga_beli ='5509500' WHERE kode_barcode='00038101' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8703000',harga_beli ='8703000' WHERE kode_barcode='00038102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00038103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6742000',harga_beli ='6742000' WHERE kode_barcode='00038104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00038105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8553500',harga_beli ='8553500' WHERE kode_barcode='00038106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8815000',harga_beli ='8815000' WHERE kode_barcode='00038108' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8647000',harga_beli ='8647000' WHERE kode_barcode='00038110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2334500',harga_beli ='2334500' WHERE kode_barcode='00038191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2278500',harga_beli ='2278500' WHERE kode_barcode='00038192' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6462000',harga_beli ='6462000' WHERE kode_barcode='00038194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00038195' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00038197' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3402000',harga_beli ='3402000' WHERE kode_barcode='00038272' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1569000',harga_beli ='1569000' WHERE kode_barcode='00038284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='840500',harga_beli ='840500' WHERE kode_barcode='00038292' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5687000',harga_beli ='5687000' WHERE kode_barcode='00038456' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6969500',harga_beli ='6969500' WHERE kode_barcode='00038468' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3268000',harga_beli ='3268000' WHERE kode_barcode='00038469' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='934000',harga_beli ='934000' WHERE kode_barcode='00038597' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2317500',harga_beli ='2317500' WHERE kode_barcode='00038601' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='26865000',harga_beli ='26865000' WHERE kode_barcode='00038611' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00038683' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4404500',harga_beli ='4404500' WHERE kode_barcode='00038722' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7999000',harga_beli ='7999000' WHERE kode_barcode='00038723' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3567000',harga_beli ='3567000' WHERE kode_barcode='00038728' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='00038777' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6328500',harga_beli ='6328500' WHERE kode_barcode='00038780' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5168500',harga_beli ='5168500' WHERE kode_barcode='00038786' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5957500',harga_beli ='5957500' WHERE kode_barcode='00038821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3530000',harga_beli ='3530000' WHERE kode_barcode='00038822' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12943500',harga_beli ='12943500' WHERE kode_barcode='00039029' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7938000',harga_beli ='7938000' WHERE kode_barcode='00039049' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6649000',harga_beli ='6649000' WHERE kode_barcode='00039067' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5382000',harga_beli ='5382000' WHERE kode_barcode='00039070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12555000',harga_beli ='12555000' WHERE kode_barcode='00039075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9396000',harga_beli ='9396000' WHERE kode_barcode='00039081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4668500',harga_beli ='4668500' WHERE kode_barcode='00039082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00039186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5771000',harga_beli ='5771000' WHERE kode_barcode='00039187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5677500',harga_beli ='5677500' WHERE kode_barcode='00039188' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5061000',harga_beli ='5061000' WHERE kode_barcode='00039190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4837000',harga_beli ='4837000' WHERE kode_barcode='00039191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3025500',harga_beli ='3025500' WHERE kode_barcode='00039375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6049000',harga_beli ='6049000' WHERE kode_barcode='00039376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2969500',harga_beli ='2969500' WHERE kode_barcode='00039377' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00039378' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='672500',harga_beli ='672500' WHERE kode_barcode='00039383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4911000',harga_beli ='4911000' WHERE kode_barcode='00039395' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3848000',harga_beli ='3848000' WHERE kode_barcode='00039397' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6387000',harga_beli ='6387000' WHERE kode_barcode='00039400' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4079000',harga_beli ='4079000' WHERE kode_barcode='00039402' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10682500',harga_beli ='10682500' WHERE kode_barcode='00039408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6345000',harga_beli ='6345000' WHERE kode_barcode='00039416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6463500',harga_beli ='6463500' WHERE kode_barcode='00039420' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2390500',harga_beli ='2390500' WHERE kode_barcode='00039425' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4893000',harga_beli ='4893000' WHERE kode_barcode='00039530' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3746500',harga_beli ='3746500' WHERE kode_barcode='00039532' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6142500',harga_beli ='6142500' WHERE kode_barcode='00039541' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7601000',harga_beli ='7601000' WHERE kode_barcode='00039729' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2531500',harga_beli ='2531500' WHERE kode_barcode='00039732' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1316500',harga_beli ='1316500' WHERE kode_barcode='00039735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7813500',harga_beli ='7813500' WHERE kode_barcode='00040351' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7172000',harga_beli ='7172000' WHERE kode_barcode='00040357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8707500',harga_beli ='8707500' WHERE kode_barcode='00040364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5214500',harga_beli ='5214500' WHERE kode_barcode='00040365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12369500',harga_beli ='12369500' WHERE kode_barcode='00040591' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21887000',harga_beli ='21887000' WHERE kode_barcode='00040593' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2521500',harga_beli ='2521500' WHERE kode_barcode='00040596' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6984500',harga_beli ='6984500' WHERE kode_barcode='00040600' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4438500',harga_beli ='4438500' WHERE kode_barcode='00040606' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12673500',harga_beli ='12673500' WHERE kode_barcode='00040607' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2036000',harga_beli ='2036000' WHERE kode_barcode='00040842' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9956500',harga_beli ='9956500' WHERE kode_barcode='00040843' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6784000',harga_beli ='6784000' WHERE kode_barcode='00040845' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8893500',harga_beli ='8893500' WHERE kode_barcode='00040848' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8657000',harga_beli ='8657000' WHERE kode_barcode='00040850' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6311500',harga_beli ='6311500' WHERE kode_barcode='00040852' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5518500',harga_beli ='5518500' WHERE kode_barcode='00040859' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10564000',harga_beli ='10564000' WHERE kode_barcode='00040861' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6716500',harga_beli ='6716500' WHERE kode_barcode='00040867' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9581500',harga_beli ='9581500' WHERE kode_barcode='00040875' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4927500',harga_beli ='4927500' WHERE kode_barcode='00040883' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6463500',harga_beli ='6463500' WHERE kode_barcode='00040956' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2664000',harga_beli ='2664000' WHERE kode_barcode='00040986' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3881500',harga_beli ='3881500' WHERE kode_barcode='00040989' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5920500',harga_beli ='5920500' WHERE kode_barcode='00040990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1519000',harga_beli ='1519000' WHERE kode_barcode='00040996' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2596000',harga_beli ='2596000' WHERE kode_barcode='00041066' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6928500',harga_beli ='6928500' WHERE kode_barcode='00041067' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1345000',harga_beli ='1345000' WHERE kode_barcode='00041069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6742000',harga_beli ='6742000' WHERE kode_barcode='00041070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3642000',harga_beli ='3642000' WHERE kode_barcode='00041074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='915500',harga_beli ='915500' WHERE kode_barcode='00041075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3986500',harga_beli ='3986500' WHERE kode_barcode='00041076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3499500',harga_beli ='3499500' WHERE kode_barcode='00041081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2129000',harga_beli ='2129000' WHERE kode_barcode='00041082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3660500',harga_beli ='3660500' WHERE kode_barcode='00041084' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3642000',harga_beli ='3642000' WHERE kode_barcode='00041086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2857500',harga_beli ='2857500' WHERE kode_barcode='00041088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3100500',harga_beli ='3100500' WHERE kode_barcode='00041094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2540000',harga_beli ='2540000' WHERE kode_barcode='00041139' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6816500',harga_beli ='6816500' WHERE kode_barcode='00041141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4314000',harga_beli ='4314000' WHERE kode_barcode='00041142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5316000',harga_beli ='5316000' WHERE kode_barcode='00041178' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11644000',harga_beli ='11644000' WHERE kode_barcode='00041182' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5012000',harga_beli ='5012000' WHERE kode_barcode='00041183' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5261000',harga_beli ='5261000' WHERE kode_barcode='00041202' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2521500',harga_beli ='2521500' WHERE kode_barcode='00041203' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4489000',harga_beli ='4489000' WHERE kode_barcode='00041272' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3746500',harga_beli ='3746500' WHERE kode_barcode='00041279' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3476500',harga_beli ='3476500' WHERE kode_barcode='00041281' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5535000',harga_beli ='5535000' WHERE kode_barcode='00041291' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8167500',harga_beli ='8167500' WHERE kode_barcode='00041417' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='16132500',harga_beli ='16132500' WHERE kode_barcode='00041429' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2839000',harga_beli ='2839000' WHERE kode_barcode='00041663' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1603500',harga_beli ='1603500' WHERE kode_barcode='00041788' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5265000',harga_beli ='5265000' WHERE kode_barcode='00041790' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3510000',harga_beli ='3510000' WHERE kode_barcode='00041792' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00041795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3611500',harga_beli ='3611500' WHERE kode_barcode='00041796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9585000',harga_beli ='9585000' WHERE kode_barcode='00041799' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='23355000',harga_beli ='23355000' WHERE kode_barcode='00041800' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10429000',harga_beli ='10429000' WHERE kode_barcode='00041801' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4337000',harga_beli ='4337000' WHERE kode_barcode='00041803' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6088500',harga_beli ='6088500' WHERE kode_barcode='00041808' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4202000',harga_beli ='4202000' WHERE kode_barcode='00041809' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4134500',harga_beli ='4134500' WHERE kode_barcode='00041813' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5181000',harga_beli ='5181000' WHERE kode_barcode='00041815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5659000',harga_beli ='5659000' WHERE kode_barcode='00042112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4295500',harga_beli ='4295500' WHERE kode_barcode='00042113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2428000',harga_beli ='2428000' WHERE kode_barcode='00042114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3978000',harga_beli ='3978000' WHERE kode_barcode='00042115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00042116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4818500',harga_beli ='4818500' WHERE kode_barcode='00042117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4295500',harga_beli ='4295500' WHERE kode_barcode='00042118' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00042119' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4295500',harga_beli ='4295500' WHERE kode_barcode='00042120' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00042121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7881000',harga_beli ='7881000' WHERE kode_barcode='00042122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7395500',harga_beli ='7395500' WHERE kode_barcode='00042123' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8012000',harga_beli ='8012000' WHERE kode_barcode='00042124' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5136000',harga_beli ='5136000' WHERE kode_barcode='00042125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8553500',harga_beli ='8553500' WHERE kode_barcode='00042127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7956000',harga_beli ='7956000' WHERE kode_barcode='00042129' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6200500',harga_beli ='6200500' WHERE kode_barcode='00042130' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9674000',harga_beli ='9674000' WHERE kode_barcode='00042131' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8086500',harga_beli ='8086500' WHERE kode_barcode='00042132' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00042133' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3007000',harga_beli ='3007000' WHERE kode_barcode='00042134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4589000',harga_beli ='4589000' WHERE kode_barcode='00042136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3361500',harga_beli ='3361500' WHERE kode_barcode='00042137' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8535000',harga_beli ='8535000' WHERE kode_barcode='00042138' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4519500',harga_beli ='4519500' WHERE kode_barcode='00042139' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00042140' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4687500',harga_beli ='4687500' WHERE kode_barcode='00042141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1924000',harga_beli ='1924000' WHERE kode_barcode='00042232' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3628500',harga_beli ='3628500' WHERE kode_barcode='00042239' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4506000',harga_beli ='4506000' WHERE kode_barcode='00042240' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3763500',harga_beli ='3763500' WHERE kode_barcode='00042244' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6058500',harga_beli ='6058500' WHERE kode_barcode='00042248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2689500',harga_beli ='2689500' WHERE kode_barcode='00042250' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3814000',harga_beli ='3814000' WHERE kode_barcode='00042257' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4421500',harga_beli ='4421500' WHERE kode_barcode='00042258' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00042312' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13584500',harga_beli ='13584500' WHERE kode_barcode='00042313' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2616000',harga_beli ='2616000' WHERE kode_barcode='00042315' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='00042491' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7594000',harga_beli ='7594000' WHERE kode_barcode='00042492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3455000',harga_beli ='3455000' WHERE kode_barcode='00042494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2818500',harga_beli ='2818500' WHERE kode_barcode='00042501' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00042525' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4860000',harga_beli ='4860000' WHERE kode_barcode='00042723' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4185000',harga_beli ='4185000' WHERE kode_barcode='00042724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6446500',harga_beli ='6446500' WHERE kode_barcode='00042725' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2869000',harga_beli ='2869000' WHERE kode_barcode='00042726' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2852000',harga_beli ='2852000' WHERE kode_barcode='00042727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9720000',harga_beli ='9720000' WHERE kode_barcode='00042728' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11053500',harga_beli ='11053500' WHERE kode_barcode='00042730' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5822000',harga_beli ='5822000' WHERE kode_barcode='00042734' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5062500',harga_beli ='5062500' WHERE kode_barcode='00042735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5704000',harga_beli ='5704000' WHERE kode_barcode='00042776' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8961000',harga_beli ='8961000' WHERE kode_barcode='00043064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00043186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00043187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11859000',harga_beli ='11859000' WHERE kode_barcode='00043188' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3847500',harga_beli ='3847500' WHERE kode_barcode='00043189' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5920500',harga_beli ='5920500' WHERE kode_barcode='00043190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3586000',harga_beli ='3586000' WHERE kode_barcode='00043191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5957500',harga_beli ='5957500' WHERE kode_barcode='00043192' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3548500',harga_beli ='3548500' WHERE kode_barcode='00043193' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6462000',harga_beli ='6462000' WHERE kode_barcode='00043194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7339500',harga_beli ='7339500' WHERE kode_barcode='00043195' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15220500',harga_beli ='15220500' WHERE kode_barcode='00043196' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6193500',harga_beli ='6193500' WHERE kode_barcode='00043291' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00043292' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5266500',harga_beli ='5266500' WHERE kode_barcode='00043293' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8217500',harga_beli ='8217500' WHERE kode_barcode='00043294' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='00043389' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5715000',harga_beli ='5715000' WHERE kode_barcode='00043407' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13601500',harga_beli ='13601500' WHERE kode_barcode='00043547' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8497500',harga_beli ='8497500' WHERE kode_barcode='00043548' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9841000',harga_beli ='9841000' WHERE kode_barcode='00043549' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4053000',harga_beli ='4053000' WHERE kode_barcode='00043554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7287000',harga_beli ='7287000' WHERE kode_barcode='00043594' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6446500',harga_beli ='6446500' WHERE kode_barcode='00043656' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6294500',harga_beli ='6294500' WHERE kode_barcode='00043657' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4877000',harga_beli ='4877000' WHERE kode_barcode='00043659' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3544000',harga_beli ='3544000' WHERE kode_barcode='00043660' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='00043666' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3949000',harga_beli ='3949000' WHERE kode_barcode='00043813' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8806500',harga_beli ='8806500' WHERE kode_barcode='00043816' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10010000',harga_beli ='10010000' WHERE kode_barcode='00043817' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5771500',harga_beli ='5771500' WHERE kode_barcode='00043819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8269000',harga_beli ='8269000' WHERE kode_barcode='00043823' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2295000',harga_beli ='2295000' WHERE kode_barcode='00043919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6750000',harga_beli ='6750000' WHERE kode_barcode='00043920' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2261500',harga_beli ='2261500' WHERE kode_barcode='00043921' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00043938' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4426500',harga_beli ='4426500' WHERE kode_barcode='00043941' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='00044345' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2540000',harga_beli ='2540000' WHERE kode_barcode='00044431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6163000',harga_beli ='6163000' WHERE kode_barcode='00044432' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='00044441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4930500',harga_beli ='4930500' WHERE kode_barcode='00044444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='26011500',harga_beli ='26011500' WHERE kode_barcode='00044614' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13511500',harga_beli ='13511500' WHERE kode_barcode='00044642' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4407500',harga_beli ='4407500' WHERE kode_barcode='00044722' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='00044724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6868500',harga_beli ='6868500' WHERE kode_barcode='00044726' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9686500',harga_beli ='9686500' WHERE kode_barcode='00044727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='40787000',harga_beli ='40787000' WHERE kode_barcode='00044728' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6518000',harga_beli ='6518000' WHERE kode_barcode='00044729' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1215000',harga_beli ='1215000' WHERE kode_barcode='00044735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4792500',harga_beli ='4792500' WHERE kode_barcode='00044736' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='24744500',harga_beli ='24744500' WHERE kode_barcode='00044738' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6362000',harga_beli ='6362000' WHERE kode_barcode='00044739' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='00044740' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1434500',harga_beli ='1434500' WHERE kode_barcode='00044904' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4743500',harga_beli ='4743500' WHERE kode_barcode='00045053' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4776000',harga_beli ='4776000' WHERE kode_barcode='00045055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8302500',harga_beli ='8302500' WHERE kode_barcode='00045056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14631000',harga_beli ='14631000' WHERE kode_barcode='00045069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1158000',harga_beli ='1158000' WHERE kode_barcode='00045070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4867000',harga_beli ='4867000' WHERE kode_barcode='00045492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3206500',harga_beli ='3206500' WHERE kode_barcode='00045548' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2835000',harga_beli ='2835000' WHERE kode_barcode='00045554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5147000',harga_beli ='5147000' WHERE kode_barcode='00045556' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7153000',harga_beli ='7153000' WHERE kode_barcode='00045589' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7470000',harga_beli ='7470000' WHERE kode_barcode='00045702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6072000',harga_beli ='6072000' WHERE kode_barcode='00045705' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15896500',harga_beli ='15896500' WHERE kode_barcode='00045708' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4613000',harga_beli ='4613000' WHERE kode_barcode='00045714' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10243500',harga_beli ='10243500' WHERE kode_barcode='00045716' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3081500',harga_beli ='3081500' WHERE kode_barcode='00045832' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6227000',harga_beli ='6227000' WHERE kode_barcode='00045833' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='00045834' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1603500',harga_beli ='1603500' WHERE kode_barcode='00045959' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='894500',harga_beli ='894500' WHERE kode_barcode='00045960' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6902000',harga_beli ='6902000' WHERE kode_barcode='00045961' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2784500',harga_beli ='2784500' WHERE kode_barcode='00045962' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='00045963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10057500',harga_beli ='10057500' WHERE kode_barcode='00045965' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7071000',harga_beli ='7071000' WHERE kode_barcode='00046072' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12994000',harga_beli ='12994000' WHERE kode_barcode='00046073' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3511000',harga_beli ='3511000' WHERE kode_barcode='00046074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='00046075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1856500',harga_beli ='1856500' WHERE kode_barcode='00046076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7071000',harga_beli ='7071000' WHERE kode_barcode='00046077' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11880000',harga_beli ='11880000' WHERE kode_barcode='00046078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4759000',harga_beli ='4759000' WHERE kode_barcode='00046079' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9956500',harga_beli ='9956500' WHERE kode_barcode='00046080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4706500',harga_beli ='4706500' WHERE kode_barcode='00046084' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3881500',harga_beli ='3881500' WHERE kode_barcode='00046086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9363000',harga_beli ='9363000' WHERE kode_barcode='00046206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3071500',harga_beli ='3071500' WHERE kode_barcode='00046705' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6518000',harga_beli ='6518000' WHERE kode_barcode='00046707' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4978500',harga_beli ='4978500' WHERE kode_barcode='00046708' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4826500',harga_beli ='4826500' WHERE kode_barcode='00046710' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3291000',harga_beli ='3291000' WHERE kode_barcode='00046711' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3679500',harga_beli ='3679500' WHERE kode_barcode='00046712' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12606000',harga_beli ='12606000' WHERE kode_barcode='00046717' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3814000',harga_beli ='3814000' WHERE kode_barcode='00046718' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2531500',harga_beli ='2531500' WHERE kode_barcode='00046719' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10479500',harga_beli ='10479500' WHERE kode_barcode='00047025' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9349000',harga_beli ='9349000' WHERE kode_barcode='00047026' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4927500',harga_beli ='4927500' WHERE kode_barcode='00047027' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10012000',harga_beli ='10012000' WHERE kode_barcode='00047028' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6210000',harga_beli ='6210000' WHERE kode_barcode='00047029' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='14664500',harga_beli ='14664500' WHERE kode_barcode='00047031' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5046000',harga_beli ='5046000' WHERE kode_barcode='00047033' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7172000',harga_beli ='7172000' WHERE kode_barcode='00047034' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10159000',harga_beli ='10159000' WHERE kode_barcode='00047035' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7071000',harga_beli ='7071000' WHERE kode_barcode='00047036' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6024500',harga_beli ='6024500' WHERE kode_barcode='00047037' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5299000',harga_beli ='5299000' WHERE kode_barcode='00047068' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7999000',harga_beli ='7999000' WHERE kode_barcode='00047069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11559500',harga_beli ='11559500' WHERE kode_barcode='00047070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5659000',harga_beli ='5659000' WHERE kode_barcode='00047075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6013500',harga_beli ='6013500' WHERE kode_barcode='00047210' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12139000',harga_beli ='12139000' WHERE kode_barcode='00047211' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15342000',harga_beli ='15342000' WHERE kode_barcode='00047212' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4556500',harga_beli ='4556500' WHERE kode_barcode='00047215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5906500',harga_beli ='5906500' WHERE kode_barcode='00047216' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4927500',harga_beli ='4927500' WHERE kode_barcode='00047217' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4455000',harga_beli ='4455000' WHERE kode_barcode='00047218' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4691500',harga_beli ='4691500' WHERE kode_barcode='00047221' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1991500',harga_beli ='1991500' WHERE kode_barcode='00047224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9771000',harga_beli ='9771000' WHERE kode_barcode='00047225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9244500',harga_beli ='9244500' WHERE kode_barcode='00047285' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15351000',harga_beli ='15351000' WHERE kode_barcode='00047286' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3100500',harga_beli ='3100500' WHERE kode_barcode='00047317' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3268500',harga_beli ='3268500' WHERE kode_barcode='00047318' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2036000',harga_beli ='2036000' WHERE kode_barcode='00047319' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3268500',harga_beli ='3268500' WHERE kode_barcode='00047320' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9431000',harga_beli ='9431000' WHERE kode_barcode='00047321' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2166500',harga_beli ='2166500' WHERE kode_barcode='00047329' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4590000',harga_beli ='4590000' WHERE kode_barcode='00047359' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5012000',harga_beli ='5012000' WHERE kode_barcode='00047363' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4776000',harga_beli ='4776000' WHERE kode_barcode='00047364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3696000',harga_beli ='3696000' WHERE kode_barcode='00047365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='24380500',harga_beli ='24380500' WHERE kode_barcode='00047480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2166500',harga_beli ='2166500' WHERE kode_barcode='00047505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00047507' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6649000',harga_beli ='6649000' WHERE kode_barcode='00047508' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1008500',harga_beli ='1008500' WHERE kode_barcode='00047541' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3249500',harga_beli ='3249500' WHERE kode_barcode='00047542' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4826500',harga_beli ='4826500' WHERE kode_barcode='00047543' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='00047544' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21289500',harga_beli ='21289500' WHERE kode_barcode='00047545' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5029000',harga_beli ='5029000' WHERE kode_barcode='00047546' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4961500',harga_beli ='4961500' WHERE kode_barcode='00047547' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3791500',harga_beli ='3791500' WHERE kode_barcode='00047754' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4258000',harga_beli ='4258000' WHERE kode_barcode='00047755' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3306000',harga_beli ='3306000' WHERE kode_barcode='00047756' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4912000',harga_beli ='4912000' WHERE kode_barcode='00047758' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5098500',harga_beli ='5098500' WHERE kode_barcode='00047759' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4860000',harga_beli ='4860000' WHERE kode_barcode='00048047' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2413500',harga_beli ='2413500' WHERE kode_barcode='00048049' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6682500',harga_beli ='6682500' WHERE kode_barcode='00048050' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8269000',harga_beli ='8269000' WHERE kode_barcode='00048051' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10682500',harga_beli ='10682500' WHERE kode_barcode='00048052' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00048053' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6024500',harga_beli ='6024500' WHERE kode_barcode='00048056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8647000',harga_beli ='8647000' WHERE kode_barcode='00048059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10597500',harga_beli ='10597500' WHERE kode_barcode='00048060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5957000',harga_beli ='5957000' WHERE kode_barcode='00048062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5117000',harga_beli ='5117000' WHERE kode_barcode='00048063' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5659000',harga_beli ='5659000' WHERE kode_barcode='00048212' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18096500',harga_beli ='18096500' WHERE kode_barcode='00048431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4522500',harga_beli ='4522500' WHERE kode_barcode='00048474' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3866000',harga_beli ='3866000' WHERE kode_barcode='00048475' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1485000',harga_beli ='1485000' WHERE kode_barcode='00048476' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8083500',harga_beli ='8083500' WHERE kode_barcode='00048477' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00048478' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='16048500',harga_beli ='16048500' WHERE kode_barcode='00048479' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1367000',harga_beli ='1367000' WHERE kode_barcode='00048480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3662000',harga_beli ='3662000' WHERE kode_barcode='00048481' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4438500',harga_beli ='4438500' WHERE kode_barcode='00048483' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3831000',harga_beli ='3831000' WHERE kode_barcode='00048484' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='00048485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7045500',harga_beli ='7045500' WHERE kode_barcode='00048486' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5677500',harga_beli ='5677500' WHERE kode_barcode='00048488' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2464000',harga_beli ='2464000' WHERE kode_barcode='00048490' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1587500',harga_beli ='1587500' WHERE kode_barcode='00048495' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5883000',harga_beli ='5883000' WHERE kode_barcode='00048496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5733500',harga_beli ='5733500' WHERE kode_barcode='00048702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6088500',harga_beli ='6088500' WHERE kode_barcode='00048703' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='00048765' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3193500',harga_beli ='3193500' WHERE kode_barcode='00048766' LIMIT 1; UPDATE tm_barang_titip SET harga_skrg ='2250000',harga_jual='6237500',harga_beli ='6237500' WHERE kode_barcode='00030666' LIMIT 1; UPDATE tm_group SET harga='2250000' WHERE kode_group = 'DM' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2250000','kasir','2026-10-30 15:12:47'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009487','X-00009487','CINCIN MAS KUNING','GR','---','CMK','BELI','BELI001','4970000','2026-10-30','3.680','1','kasir','2026-10-30 15:38:59'); DELETE FROM tp_barang WHERE kode_dept = 'X-CMK'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMK','X-00009487','X-00009487'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-261030-0001','-','NANA','1','BELI','BELI001','CMK', 'X-00009487', 'CINCIN MAS KUNING','3.680','3.680','70.00','2500000','4970000','1350543','1','4970000','4970000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.680',berat_beli_asli=berat_beli_asli+'3.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.680',berat_akhir_asli=berat_akhir_asli+'3.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMK' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-261030-0001','2026-10-30','2026-10-30','15:38:59','NANA','---','3.680','4970000','4970000','4970000','4970000','4970000','kasir','2026-10-30 15:38:59','BE-261030-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-261030-0001','-','-','','','','kasir','2026-10-30 15:38:59'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261030-0003','2026-10-30','2026-10-30 15:38:59','PEMBELIAN UMUM : BE-261030-0001','-','TBC','4970000','4970000'); 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 ('KK-261030-0004','K','2026-10-30','15:38:59','TBC','PEMBELIAN UMUM','BE-261030-0001','108654391255','4970000','108649421255','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-261030-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-261030-0001'; UPDATE tt_service_head SET tgl_selesai='2026-10-30', status ='DONE' WHERE no_service='SV-08420'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-08420'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-30', status ='CLOS' WHERE no_service='SV-08420'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-08420'; 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 ('FE-261030-0002','kasir','1',' LBRE-00828','TOKO','LBR','LBRE-YGBB-21-0','LIONTIN LBRE-00828','','2.270','1','83.00','12691000','7297000','401','18200','16000000','0','0','0','16000000','ONLBARRY','00037422','LBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LBRE-YGBB-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-10-30' AND kode_barang='LBRE-YGBB-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LBR' 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 ('FE-261030-0002','2026-10-30','2.270','2026-10-30','17:53:32','PLG0029852','16000000','16000000','0','16000000','0','kasir','2026-10-30 17:53:31','FE-261030-0002','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-30','FE-261030-0002','2026-10-30','17:53:32','ONLBARRY','16000000','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-261030-0004','2026-10-30','2026-10-30 17:53:31','PENJUALAN : FE-261030-0002','.','TBC','16000000','16000000','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-261030-0005','D','2026-10-30','17:53:32','TBC','PENJUALAN BERLIAN','FE-261030-0002','108649421255','16000000','108665421255','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='16000000' WHERE no_faktur_jual='FE-261030-0002' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-261030-0003','kasir',' 1',' CBRE-07059','TOKO','CBR','CBRE-ZHAB-23-0','CINCIN CBRE-07059 ','','4.190','1','75.00','12904000','4659500','256','18200','19000000','0','0','0','19000000','ONLBARRY','00046072','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZHAB-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.190',berat_jual_asli=berat_jual_asli+'4.190',stock_jual='1',berat_akhir=berat_akhir-'4.190',berat_akhir_asli=berat_akhir_asli-'4.190',stock_akhir='0' WHERE tanggal='2026-10-30' AND kode_barang='CBRE-ZHAB-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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 ('FE-261030-0003','2026-10-30','4.190','2026-10-30','17:53:32','PLG0029853','19000000','19000000','0','19000000','0','kasir','2026-10-30 17:53:31','FE-261030-0002','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-30','FE-261030-0003','2026-10-30','17:53:32','ONLBARRY','19000000','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-261030-0005','2026-10-30','2026-10-30 17:53:31','PENJUALAN : FE-261030-0003','.','TBC','19000000','19000000','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-261030-0006','D','2026-10-30','17:53:32','TBC','PENJUALAN BERLIAN','FE-261030-0003','108665421255','19000000','108684421255','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='35000000' WHERE no_faktur_jual='FE-261030-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261030-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261030-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-30 ','18:56:29'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-30 ','19:30:39'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261030-0002','K','2026-10-30','19:31:02','kasir','KIRIM PAKET','JNE SURABAYA','5760044','44000','5716044'); DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZJCX-2-0'; INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZJCX-2-0','CBRE-ZJCX-2-0','00048766','OVAL','1','0.700','890'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZJCX-2-0','00048766','OVAL','1','0.700','890','623') INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-ZJCX-2-0','00048766','00048766','CBRE-07087 GIA 1558088617 ','CBRE-07087 GIA 1558088617','','','3193500','3193500',' 0','0','kasir','2026-10-30 19:43:13'); UPDATE tm_barang SET nama_barang='CBRE-07087 GIA 1558088617' ,nama_atribut='' ,kode_intern='CBRE-07087 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS14 JVS1 1026',total_usd_ext='GDR 65 000 000',total_usd='623' WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-10-30 19:43:36' WHERE id_card = '-'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-261030-0004','kasir','1',' CBRE-07087','TOKO','CBR','CBRE-ZJCX-2-0','CBRE-07087 GIA 1558088617','','1.710','1','83.00','16498000','11804000','649','18200','29200000','0','0','0','29200000','ONLBARRY','00048766','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZJCX-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-10-30' AND kode_barang='CBRE-ZJCX-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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 ('FE-261030-0004','2026-10-30','1.710','2026-10-30','19:43:38','PLG0029854','29200000','29200000','0','29200000','0','kasir','2026-10-30 19:43:37','FE-261030-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-30','FE-261030-0004','2026-10-30','19:43:38','ONLBARRY','29200000','0'); INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-261030-0001','2026-10-30','2026-10-30 19:43:37','PENJUALAN : FE-261030-0004','','BCK','29200000','29200000','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-261030-0002','D','2026-10-30','19:43:38','BCK','PENJUALAN BERLIAN','FE-261030-0004','16895634978.088','29200000','16924834978.088','CARD'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='29200000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-261030-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-261030-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-261030-0004'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08423','BARY','1','CBRE07087','JD NO 6 CROM PUTIH','1.710','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-08423','2026-10-30','2026-10-30','19:47:09','PLG0029855','kasir','2026-11-03','kasir','2026-10-30 19:47:09','1.710','0','0','0','0','0','0','0','0'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-31','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-30'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-30'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-30'; 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-10-30' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-30'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-30'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-30'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-30'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-31' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-30' 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-261031-0001','D','2026-10-31','20:07:29','BCK','SALDO AWAL','SALDO AWAL','0','16924834978.088','16924834978.088'); 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-261031-0001','D','2026-10-31','20:07:29','TBC','SALDO AWAL','SALDO AWAL','0','108684421255','108684421255'); 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-261031-0001','D','2026-10-31','20:07:29','TMR','SALDO AWAL','SALDO AWAL','0','8955983779','8955983779'); 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-261031-0001','D','2026-10-31','20:07:29','BCD','SALDO AWAL','SALDO AWAL','0','15172621700','15172621700'); 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-261031-0001','D','2026-10-31','20:07:29','SHO','SALDO AWAL','SALDO AWAL','0','2758505684','2758505684'); 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-261031-0001','D','2026-10-31','20:07:29','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900'); 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-261031-0001','D','2026-10-31','20:07:29','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-261031-0001','D','2026-10-31','20:07:29','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-261031-0001','D','2026-10-31','20:07:29','4000000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261031-0001','D','2026-10-31','20:07:29','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-261031-0001','D','2026-10-31','20:07:29','3450000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261031-0001','D','2026-10-31','20:07:29','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-261031-0001','D','2026-10-31','20:07:29','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-261031-0001','D','2026-10-31','20:07:29','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-261031-0001','D','2026-10-31','20:07:29','BCA','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261031-0001','D','2026-10-31','20:07:29','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-261031-0001','D','2026-10-31','20:07:29','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-261031-0001','D','2026-10-31','20:07:29','6000000','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261031-0001','D','2026-10-31','20:07:29','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-261031-0001','D','2026-10-31','20:07:29','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-261031-0001','D','2026-10-31','20:07:29','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-261031-0001','D','2026-10-31','20:07:29','DPE','SALDO AWAL','SALDO AWAL','0','228362000','228362000'); 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-261031-0001','D','2026-10-31','20:07:29','MANDIRI','SALDO AWAL','SALDO AWAL','0','111637450','111637450'); UPDATE tp_system SET tgl_system='2026-10-31';