INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','09:16:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','09:54:46'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-08','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-08'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-07'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-07'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-07' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-07'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-07'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-07'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-07'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05'; UPDATE tt_barang_saldo SET tanggal= '2026-06-08' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-07' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','TBC','SALDO AWAL','SALDO AWAL','0','23513669014','23513669014'); 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-260608-0001','D','2026-06-08','10:07:48','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650'); 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-260608-0001','D','2026-06-08','10:07:48','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); 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-260608-0001','D','2026-06-08','10:07:48','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','10:07:48','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-260608-0001','D','2026-06-08','10:07:48','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-260608-0001','D','2026-06-08','10:07:48','BCD','SALDO AWAL','SALDO AWAL','0','1393203500','1393203500'); UPDATE tp_system SET tgl_system='2026-06-08'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-08 ','10:11:28'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-08 ','10:37:29'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0001','kasirbip','1',' 800K-23-25','TOKO','BIPPER','PBDG-ZEAE-18-0','CINCIN SILVER 925 YL-10 ','','5.040','1','100.00','515000','0','0','18100','900000','0','0','0','900000','KUR','00043585','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAE-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.040',berat_jual_asli=berat_jual_asli+'5.040',stock_jual='1',berat_akhir=berat_akhir-'5.040',berat_akhir_asli=berat_akhir_asli-'5.040',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PBDG-ZEAE-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0001','2026-06-08','5.040','2026-06-08','11:02:38','PLG0011926','900000','900000','0','900000','0','kasirbip','2026-06-08 11:02:38','FJ-260608-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-06-08','FJ-260608-0001','2026-06-08','11:02:38','KUR','900000','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-260608-0001','2026-06-08','2026-06-08 11:02:38','PENJUALAN : FJ-260608-0001','.','TBC','900000','900000','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-260608-0002','D','2026-06-08','11:02:38','TBC','PENJUALAN','FJ-260608-0001','23513669014','900000','23514569014','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='900000' WHERE no_faktur_jual='FJ-260608-0001' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0002','kasirbip',' 1',' 1.2K-11-25','TOKO','BIPPER','PBDG-ZEXF-33-0','CINCIN SILVER 925 ','','2.020','1','100.00','207000','0','0','18100','1300000','0','0','0','1300000','KUR','00043327','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEXF-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PBDG-ZEXF-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0002','2026-06-08','2.020','2026-06-08','11:02:38','PLG0011927','1300000','1300000','0','1300000','0','kasirbip','2026-06-08 11:02:38','FJ-260608-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-06-08','FJ-260608-0002','2026-06-08','11:02:38','KUR','1300000','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-260608-0002','2026-06-08','2026-06-08 11:02:38','PENJUALAN : FJ-260608-0002','.','TBC','1300000','1300000','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-260608-0003','D','2026-06-08','11:02:38','TBC','PENJUALAN','FJ-260608-0002','23514569014','1300000','23515869014','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='2200000' WHERE no_faktur_jual='FJ-260608-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','11:05:40'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','11:06:14'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0002'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0003','kasirbip','1',' DP-02333DU','TOKO','DUPSN','PSPLT-ZFXE-21-0','CINCIN PALADIUM ','','2.650','1','32.00','1120000','0','0','18100','2207500','0','0','0','2207500','PUT','00044011','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFXE-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPLT-ZFXE-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0003','2026-06-08','2.650','2026-06-08','11:19:21','PLG0011928','2207500','2207500','0','2207500','0','kasirbip','2026-06-08 11:19:20','FJ-260608-0003','DP-02333','1700000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0003','2026-06-08','11:19:21','PUT','2207500','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-260608-0003','2026-06-08','2026-06-08 11:19:20','PENJUALAN : FJ-260608-0003','.','TBC','507500','507500','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-260608-0004','D','2026-06-08','11:19:21','TBC','PENJUALAN','FJ-260608-0003','23515869014','507500','23516376514','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='507500' WHERE no_faktur_jual='FJ-260608-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0003'; UPDATE tt_service_head SET tgl_selesai='2026-06-08', status ='DONE' WHERE no_service='SV-02095'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02095'; UPDATE tt_service_head SET tgl_selesai='2026-06-08', status ='DONE' WHERE no_service='SV-02064'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02064'; 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-06-08', status ='CLOS' WHERE no_service='SV-02064'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02064'; 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-06-08', status ='CLOS' WHERE no_service='SV-02095'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02095'; UPDATE tt_service_head SET tgl_selesai='2026-06-08', status ='DONE' WHERE no_service='SV-02100'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02100'; 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-06-08', status ='CLOS' WHERE no_service='SV-02100'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02100'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0004','kasir','1',' BDC-00107 ','TOKO','TFCBR','BDC-YBBE-16-0','CINCIN BDC-00107','','1.020','1','83.00','4034000','1390500','77','18100','6900000','0','0','0','6900000','FIR','00034369','BDC','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YBBE-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='BDC-YBBE-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0004','2026-06-08','1.020','2026-06-08','12:29:11','PLG0011929','6900000','6900000','0','6900000','0','kasir','2026-06-08 12:29:10','FJ-260608-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-06-08','FJ-260608-0004','2026-06-08','12:29:11','FIR','6900000','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-260608-0004','2026-06-08','2026-06-08 12:29:10','PENJUALAN : FJ-260608-0004','.','TBC','6900000','6900000','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-260608-0005','D','2026-06-08','12:29:11','TBC','PENJUALAN BERLIAN','FJ-260608-0004','23516376514','6900000','23523276514','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='6900000' WHERE no_faktur_jual='FJ-260608-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0004'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','12:31:54'); UPDATE tt_service_head SET tgl_selesai='2026-06-08', status ='DONE' WHERE no_service='SV-02112'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02112'; 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-06-08', status ='CLOS' WHERE no_service='SV-02112'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02112'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02122','FIR','1','CBR','RESIZE KE 16 KRUM ROSEGOLD','1.020','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-260608-0005','2026-06-08','2026-06-08 12:53:51','SERVICE : SV-02122','.','TBC','100000','100000','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-260608-0006','D','2026-06-08','12:53:51','TBC','SERVICE','SV-02122','23523276514','100000','23523376514','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-02122','2026-06-08','2026-06-08','12:53:51','PLG0011930','kasir','2026-06-09','kasir','2026-06-08 12:53:51','1.020','100000','0','0','100000','0','200000','200000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0002','D','2026-06-08','12:53:51','kasir','SERVICE','SV-02122','35444200','100000','35544200'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','13:34:28'); UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8725000',harga_beli ='8725000' WHERE kode_barcode='00017312' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7879000',harga_beli ='7879000' WHERE kode_barcode='00017383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8642500',harga_beli ='8642500' WHERE kode_barcode='00017542' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5837500',harga_beli ='5837500' WHERE kode_barcode='00017624' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9364500',harga_beli ='9364500' WHERE kode_barcode='00017626' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9178500',harga_beli ='9178500' WHERE kode_barcode='00017628' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7425500',harga_beli ='7425500' WHERE kode_barcode='00017636' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5239000',harga_beli ='5239000' WHERE kode_barcode='00017662' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6332500',harga_beli ='6332500' WHERE kode_barcode='00017663' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12355000',harga_beli ='12355000' WHERE kode_barcode='00017681' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12169500',harga_beli ='12169500' WHERE kode_barcode='00017697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5755000',harga_beli ='5755000' WHERE kode_barcode='00017698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5940500',harga_beli ='5940500' WHERE kode_barcode='00017717' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3032000',harga_beli ='3032000' WHERE kode_barcode='00017759' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2991000',harga_beli ='2991000' WHERE kode_barcode='00017760' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12602500',harga_beli ='12602500' WHERE kode_barcode='00017900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='48717500',harga_beli ='48717500' WHERE kode_barcode='00017913' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4228500',harga_beli ='4228500' WHERE kode_barcode='00017959' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8250500',harga_beli ='8250500' WHERE kode_barcode='00017982' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12499500',harga_beli ='12499500' WHERE kode_barcode='00018019' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8611000',harga_beli ='8611000' WHERE kode_barcode='00018036' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6373500',harga_beli ='6373500' WHERE kode_barcode='00018073' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19099500',harga_beli ='19099500' WHERE kode_barcode='00018112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6971500',harga_beli ='6971500' WHERE kode_barcode='00018284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7054000',harga_beli ='7054000' WHERE kode_barcode='00018285' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00018302' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2805500',harga_beli ='2805500' WHERE kode_barcode='00018312' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2764000',harga_beli ='2764000' WHERE kode_barcode='00018337' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9178500',harga_beli ='9178500' WHERE kode_barcode='00018371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9653000',harga_beli ='9653000' WHERE kode_barcode='00018463' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13427500',harga_beli ='13427500' WHERE kode_barcode='00018491' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5466000',harga_beli ='5466000' WHERE kode_barcode='00018517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5961000',harga_beli ='5961000' WHERE kode_barcode='00018519' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7410500',harga_beli ='7410500' WHERE kode_barcode='00018718' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4187500',harga_beli ='4187500' WHERE kode_barcode='00018891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4991500',harga_beli ='4991500' WHERE kode_barcode='00018924' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00018925' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00018937' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4208000',harga_beli ='4208000' WHERE kode_barcode='00019018' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10230500',harga_beli ='10230500' WHERE kode_barcode='00019120' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3857000',harga_beli ='3857000' WHERE kode_barcode='00019123' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4022000',harga_beli ='4022000' WHERE kode_barcode='00019148' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5095000',harga_beli ='5095000' WHERE kode_barcode='00019153' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7178000',harga_beli ='7178000' WHERE kode_barcode='00019234' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00019236' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7198500',harga_beli ='7198500' WHERE kode_barcode='00019283' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8869000',harga_beli ='8869000' WHERE kode_barcode='00019360' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4517500',harga_beli ='4517500' WHERE kode_barcode='00019451' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5239000',harga_beli ='5239000' WHERE kode_barcode='00019510' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00019562' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6456000',harga_beli ='6456000' WHERE kode_barcode='00019563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6167500',harga_beli ='6167500' WHERE kode_barcode='00019564' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8374000',harga_beli ='8374000' WHERE kode_barcode='00019652' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6538500',harga_beli ='6538500' WHERE kode_barcode='00019655' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4558500',harga_beli ='4558500' WHERE kode_barcode='00019656' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9694500',harga_beli ='9694500' WHERE kode_barcode='00019742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00019840' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5899000',harga_beli ='5899000' WHERE kode_barcode='00019911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6250000',harga_beli ='6250000' WHERE kode_barcode='00020018' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7343000',harga_beli ='7343000' WHERE kode_barcode='00020068' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6930500',harga_beli ='6930500' WHERE kode_barcode='00020069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7157500',harga_beli ='7157500' WHERE kode_barcode='00020070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6559000',harga_beli ='6559000' WHERE kode_barcode='00020071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7838000',harga_beli ='7838000' WHERE kode_barcode='00020074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6889000',harga_beli ='6889000' WHERE kode_barcode='00020075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7095500',harga_beli ='7095500' WHERE kode_barcode='00020076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00020077' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00020080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6683000',harga_beli ='6683000' WHERE kode_barcode='00020166' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8168000',harga_beli ='8168000' WHERE kode_barcode='00020168' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5920000',harga_beli ='5920000' WHERE kode_barcode='00020179' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6043500',harga_beli ='6043500' WHERE kode_barcode='00020186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8188500',harga_beli ='8188500' WHERE kode_barcode='00020191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='00020200' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='47488500',harga_beli ='47488500' WHERE kode_barcode='00020223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6559000',harga_beli ='6559000' WHERE kode_barcode='00020259' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7157500',harga_beli ='7157500' WHERE kode_barcode='00020365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4909000',harga_beli ='4909000' WHERE kode_barcode='00020492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5858000',harga_beli ='5858000' WHERE kode_barcode='00020616' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5404000',harga_beli ='5404000' WHERE kode_barcode='00020834' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00020846' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='00021113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8931000',harga_beli ='8931000' WHERE kode_barcode='00021253' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6518000',harga_beli ='6518000' WHERE kode_barcode='00021254' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6270500',harga_beli ='6270500' WHERE kode_barcode='00021280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9220000',harga_beli ='9220000' WHERE kode_barcode='00021405' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00021475' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00021503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='24788000',harga_beli ='24788000' WHERE kode_barcode='00021505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13725000',harga_beli ='13725000' WHERE kode_barcode='00021506' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9863000',harga_beli ='9863000' WHERE kode_barcode='00021585' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3966500',harga_beli ='3966500' WHERE kode_barcode='00021609' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11350500',harga_beli ='11350500' WHERE kode_barcode='00021630' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8454000',harga_beli ='8454000' WHERE kode_barcode='00021635' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6332500',harga_beli ='6332500' WHERE kode_barcode='00021755' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8663000',harga_beli ='8663000' WHERE kode_barcode='00021756' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6724000',harga_beli ='6724000' WHERE kode_barcode='00021758' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8931000',harga_beli ='8931000' WHERE kode_barcode='00021759' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5548500',harga_beli ='5548500' WHERE kode_barcode='00021781' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9694500',harga_beli ='9694500' WHERE kode_barcode='00021782' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8023500',harga_beli ='8023500' WHERE kode_barcode='00021783' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16047000',harga_beli ='16047000' WHERE kode_barcode='00021815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11468000',harga_beli ='11468000' WHERE kode_barcode='00021835' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12685000',harga_beli ='12685000' WHERE kode_barcode='00021844' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='00021867' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='00021876' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4905500',harga_beli ='4905500' WHERE kode_barcode='00021878' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15036500',harga_beli ='15036500' WHERE kode_barcode='00021882' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11468000',harga_beli ='11468000' WHERE kode_barcode='00021905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5033000',harga_beli ='5033000' WHERE kode_barcode='00021976' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6126000',harga_beli ='6126000' WHERE kode_barcode='00021977' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00021979' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5383500',harga_beli ='5383500' WHERE kode_barcode='00021980' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6848000',harga_beli ='6848000' WHERE kode_barcode='00022044' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='00022045' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7735000',harga_beli ='7735000' WHERE kode_barcode='00022046' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00022071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6332500',harga_beli ='6332500' WHERE kode_barcode='00022114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7714000',harga_beli ='7714000' WHERE kode_barcode='00022140' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5981500',harga_beli ='5981500' WHERE kode_barcode='00022141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5651500',harga_beli ='5651500' WHERE kode_barcode='00022142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5590000',harga_beli ='5590000' WHERE kode_barcode='00022143' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10725500',harga_beli ='10725500' WHERE kode_barcode='00022144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7149500',harga_beli ='7149500' WHERE kode_barcode='00022173' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9367500',harga_beli ='9367500' WHERE kode_barcode='00022174' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10228500',harga_beli ='10228500' WHERE kode_barcode='00022176' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7410500',harga_beli ='7410500' WHERE kode_barcode='00022180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7358500',harga_beli ='7358500' WHERE kode_barcode='00022227' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10540000',harga_beli ='10540000' WHERE kode_barcode='00022322' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13777000',harga_beli ='13777000' WHERE kode_barcode='00022356' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7570000',harga_beli ='7570000' WHERE kode_barcode='00022433' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7384500',harga_beli ='7384500' WHERE kode_barcode='00022442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5198000',harga_beli ='5198000' WHERE kode_barcode='00022450' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5590000',harga_beli ='5590000' WHERE kode_barcode='00022468' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8436000',harga_beli ='8436000' WHERE kode_barcode='00022517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19204500',harga_beli ='19204500' WHERE kode_barcode='00022649' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5923500',harga_beli ='5923500' WHERE kode_barcode='00022758' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7436500',harga_beli ='7436500' WHERE kode_barcode='00022759' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7958500',harga_beli ='7958500' WHERE kode_barcode='00022765' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11976500',harga_beli ='11976500' WHERE kode_barcode='00022774' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11011500',harga_beli ='11011500' WHERE kode_barcode='00022806' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7280000',harga_beli ='7280000' WHERE kode_barcode='00022808' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9785000',harga_beli ='9785000' WHERE kode_barcode='00022809' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9315500',harga_beli ='9315500' WHERE kode_barcode='00022867' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7254000',harga_beli ='7254000' WHERE kode_barcode='00022883' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3898500',harga_beli ='3898500' WHERE kode_barcode='00022912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5569000',harga_beli ='5569000' WHERE kode_barcode='00022950' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7466500',harga_beli ='7466500' WHERE kode_barcode='00023060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9446000',harga_beli ='9446000' WHERE kode_barcode='00023123' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5198000',harga_beli ='5198000' WHERE kode_barcode='00023126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9777000',harga_beli ='9777000' WHERE kode_barcode='00023146' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6683000',harga_beli ='6683000' WHERE kode_barcode='00023437' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8063000',harga_beli ='8063000' WHERE kode_barcode='00023488' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11200000',harga_beli ='11200000' WHERE kode_barcode='00023490' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='45765000',harga_beli ='45765000' WHERE kode_barcode='00023493' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23420000',harga_beli ='23420000' WHERE kode_barcode='00023537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00023549' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6146500',harga_beli ='6146500' WHERE kode_barcode='00023563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7590500',harga_beli ='7590500' WHERE kode_barcode='00023572' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10457500',harga_beli ='10457500' WHERE kode_barcode='00023585' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4022000',harga_beli ='4022000' WHERE kode_barcode='00023590' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6629500',harga_beli ='6629500' WHERE kode_barcode='00023593' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6552500',harga_beli ='6552500' WHERE kode_barcode='00023594' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6501500',harga_beli ='6501500' WHERE kode_barcode='00023595' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7240000',harga_beli ='7240000' WHERE kode_barcode='00023596' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10392000',harga_beli ='10392000' WHERE kode_barcode='00023600' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10341000',harga_beli ='10341000' WHERE kode_barcode='00023602' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7397500',harga_beli ='7397500' WHERE kode_barcode='00023604' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8037500',harga_beli ='8037500' WHERE kode_barcode='00023605' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13131000',harga_beli ='13131000' WHERE kode_barcode='00023606' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8575000',harga_beli ='8575000' WHERE kode_barcode='00023607' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10443000',harga_beli ='10443000' WHERE kode_barcode='00023608' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7423000',harga_beli ='7423000' WHERE kode_barcode='00023609' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11620500',harga_beli ='11620500' WHERE kode_barcode='00023611' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10853000',harga_beli ='10853000' WHERE kode_barcode='00023612' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8651500',harga_beli ='8651500' WHERE kode_barcode='00023613' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10878500',harga_beli ='10878500' WHERE kode_barcode='00023614' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6578500',harga_beli ='6578500' WHERE kode_barcode='00023617' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5610500',harga_beli ='5610500' WHERE kode_barcode='00023622' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5119500',harga_beli ='5119500' WHERE kode_barcode='00023623' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13943000',harga_beli ='13943000' WHERE kode_barcode='00023626' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7054000',harga_beli ='7054000' WHERE kode_barcode='00023629' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3135500',harga_beli ='3135500' WHERE kode_barcode='00023632' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00023666' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2372000',harga_beli ='2372000' WHERE kode_barcode='00023679' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5466000',harga_beli ='5466000' WHERE kode_barcode='00023691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7466500',harga_beli ='7466500' WHERE kode_barcode='00023692' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8848500',harga_beli ='8848500' WHERE kode_barcode='00023693' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8848500',harga_beli ='8848500' WHERE kode_barcode='00023697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18429000',harga_beli ='18429000' WHERE kode_barcode='00023704' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10065500',harga_beli ='10065500' WHERE kode_barcode='00023760' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12491000',harga_beli ='12491000' WHERE kode_barcode='00023815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4311000',harga_beli ='4311000' WHERE kode_barcode='00023830' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11447500',harga_beli ='11447500' WHERE kode_barcode='00023843' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4607500',harga_beli ='4607500' WHERE kode_barcode='00023848' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6085000',harga_beli ='6085000' WHERE kode_barcode='00023857' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6683000',harga_beli ='6683000' WHERE kode_barcode='00023907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6476500',harga_beli ='6476500' WHERE kode_barcode='00023913' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5631000',harga_beli ='5631000' WHERE kode_barcode='00023917' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6322500',harga_beli ='6322500' WHERE kode_barcode='00023920' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6600500',harga_beli ='6600500' WHERE kode_barcode='00023934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3197000',harga_beli ='3197000' WHERE kode_barcode='00023964' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8188500',harga_beli ='8188500' WHERE kode_barcode='00023965' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9061000',harga_beli ='9061000' WHERE kode_barcode='00023979' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5548500',harga_beli ='5548500' WHERE kode_barcode='00023985' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9364500',harga_beli ='9364500' WHERE kode_barcode='00023991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6930500',harga_beli ='6930500' WHERE kode_barcode='00023997' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7570000',harga_beli ='7570000' WHERE kode_barcode='00023998' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7281000',harga_beli ='7281000' WHERE kode_barcode='00024000' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9632500',harga_beli ='9632500' WHERE kode_barcode='00024004' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5548500',harga_beli ='5548500' WHERE kode_barcode='00024013' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8856500',harga_beli ='8856500' WHERE kode_barcode='00024038' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5404000',harga_beli ='5404000' WHERE kode_barcode='00024062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7776000',harga_beli ='7776000' WHERE kode_barcode='00024069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3362000',harga_beli ='3362000' WHERE kode_barcode='00024077' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='00024085' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5363000',harga_beli ='5363000' WHERE kode_barcode='00024086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4377000',harga_beli ='4377000' WHERE kode_barcode='00024095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7941000',harga_beli ='7941000' WHERE kode_barcode='00024096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7178000',harga_beli ='7178000' WHERE kode_barcode='00024104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8271000',harga_beli ='8271000' WHERE kode_barcode='00024148' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6394000',harga_beli ='6394000' WHERE kode_barcode='00024186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6291000',harga_beli ='6291000' WHERE kode_barcode='00024189' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11860000',harga_beli ='11860000' WHERE kode_barcode='00024193' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4579000',harga_beli ='4579000' WHERE kode_barcode='00024194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6456000',harga_beli ='6456000' WHERE kode_barcode='00024363' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7425500',harga_beli ='7425500' WHERE kode_barcode='00025284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='00025286' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15036500',harga_beli ='15036500' WHERE kode_barcode='00025510' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19140500',harga_beli ='19140500' WHERE kode_barcode='00026215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16407000',harga_beli ='16407000' WHERE kode_barcode='00026302' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8601000',harga_beli ='8601000' WHERE kode_barcode='00026725' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5734000',harga_beli ='5734000' WHERE kode_barcode='00026884' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3279500',harga_beli ='3279500' WHERE kode_barcode='00026926' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5858000',harga_beli ='5858000' WHERE kode_barcode='00026927' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10148000',harga_beli ='10148000' WHERE kode_barcode='00026952' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00027033' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11365000',harga_beli ='11365000' WHERE kode_barcode='00027034' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5940500',harga_beli ='5940500' WHERE kode_barcode='00027038' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='00027050' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5280500',harga_beli ='5280500' WHERE kode_barcode='00027104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00027149' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17903000',harga_beli ='17903000' WHERE kode_barcode='00027177' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4806000',harga_beli ='4806000' WHERE kode_barcode='00027229' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00027334' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4633000',harga_beli ='4633000' WHERE kode_barcode='00027480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13448000',harga_beli ='13448000' WHERE kode_barcode='00027482' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2186500',harga_beli ='2186500' WHERE kode_barcode='00027795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8477500',harga_beli ='8477500' WHERE kode_barcode='00027945' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6860000',harga_beli ='6860000' WHERE kode_barcode='00028046' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5156500',harga_beli ='5156500' WHERE kode_barcode='00028107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12458000',harga_beli ='12458000' WHERE kode_barcode='00028220' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12311500',harga_beli ='12311500' WHERE kode_barcode='00028368' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8395500',harga_beli ='8395500' WHERE kode_barcode='00028381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11262000',harga_beli ='11262000' WHERE kode_barcode='00028442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3737000',harga_beli ='3737000' WHERE kode_barcode='00028566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8085500',harga_beli ='8085500' WHERE kode_barcode='00028582' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6827500',harga_beli ='6827500' WHERE kode_barcode='00028682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5713500',harga_beli ='5713500' WHERE kode_barcode='00028692' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='00028772' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5321500',harga_beli ='5321500' WHERE kode_barcode='00029136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='00029506' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10437000',harga_beli ='10437000' WHERE kode_barcode='00029526' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00029662' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13412500',harga_beli ='13412500' WHERE kode_barcode='00030349' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4930000',harga_beli ='4930000' WHERE kode_barcode='00030671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7576500',harga_beli ='7576500' WHERE kode_barcode='00030672' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6399000',harga_beli ='6399000' WHERE kode_barcode='00030674' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3788500',harga_beli ='3788500' WHERE kode_barcode='00030709' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3763000',harga_beli ='3763000' WHERE kode_barcode='00030714' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4607500',harga_beli ='4607500' WHERE kode_barcode='00030716' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4479500',harga_beli ='4479500' WHERE kode_barcode='00030719' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4172500',harga_beli ='4172500' WHERE kode_barcode='00030721' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6578500',harga_beli ='6578500' WHERE kode_barcode='00030821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4847500',harga_beli ='4847500' WHERE kode_barcode='00030827' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2166000',harga_beli ='2166000' WHERE kode_barcode='00031061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2145500',harga_beli ='2145500' WHERE kode_barcode='00031062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='00031064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3444500',harga_beli ='3444500' WHERE kode_barcode='00031066' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00031069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3795500',harga_beli ='3795500' WHERE kode_barcode='00031070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3754000',harga_beli ='3754000' WHERE kode_barcode='00031071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6208500',harga_beli ='6208500' WHERE kode_barcode='00031112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8683500',harga_beli ='8683500' WHERE kode_barcode='00031113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6559000',harga_beli ='6559000' WHERE kode_barcode='00031114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00031115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='00031116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8984500',harga_beli ='8984500' WHERE kode_barcode='00031117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22193500',harga_beli ='22193500' WHERE kode_barcode='00031126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='20522500',harga_beli ='20522500' WHERE kode_barcode='00031175' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7136500',harga_beli ='7136500' WHERE kode_barcode='00031182' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7935000',harga_beli ='7935000' WHERE kode_barcode='00031184' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7039000',harga_beli ='7039000' WHERE kode_barcode='00031187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12875000',harga_beli ='12875000' WHERE kode_barcode='00031190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6066500',harga_beli ='6066500' WHERE kode_barcode='00031191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='35578000',harga_beli ='35578000' WHERE kode_barcode='00031203' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18813000',harga_beli ='18813000' WHERE kode_barcode='00031204' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6229000',harga_beli ='6229000' WHERE kode_barcode='00031267' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5363000',harga_beli ='5363000' WHERE kode_barcode='00031268' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8106000',harga_beli ='8106000' WHERE kode_barcode='00031269' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7941000',harga_beli ='7941000' WHERE kode_barcode='00031270' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4703000',harga_beli ='4703000' WHERE kode_barcode='00031272' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00031274' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5796000',harga_beli ='5796000' WHERE kode_barcode='00031276' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7075000',harga_beli ='7075000' WHERE kode_barcode='00031277' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00031278' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5363000',harga_beli ='5363000' WHERE kode_barcode='00031279' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5012500',harga_beli ='5012500' WHERE kode_barcode='00031280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00031282' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6703500',harga_beli ='6703500' WHERE kode_barcode='00031283' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7095500',harga_beli ='7095500' WHERE kode_barcode='00031284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3362000',harga_beli ='3362000' WHERE kode_barcode='00031286' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00031287' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6827500',harga_beli ='6827500' WHERE kode_barcode='00031333' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7673000',harga_beli ='7673000' WHERE kode_barcode='00031335' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4084000',harga_beli ='4084000' WHERE kode_barcode='00031337' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6126000',harga_beli ='6126000' WHERE kode_barcode='00031382' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5651500',harga_beli ='5651500' WHERE kode_barcode='00031383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4373000',harga_beli ='4373000' WHERE kode_barcode='00031385' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4352500',harga_beli ='4352500' WHERE kode_barcode='00031386' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2888000',harga_beli ='2888000' WHERE kode_barcode='00031387' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7219000',harga_beli ='7219000' WHERE kode_barcode='00031390' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5239000',harga_beli ='5239000' WHERE kode_barcode='00031391' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3383000',harga_beli ='3383000' WHERE kode_barcode='00031392' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5177500',harga_beli ='5177500' WHERE kode_barcode='00031394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7487500',harga_beli ='7487500' WHERE kode_barcode='00031396' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6208500',harga_beli ='6208500' WHERE kode_barcode='00031397' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6848000',harga_beli ='6848000' WHERE kode_barcode='00031399' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8786500',harga_beli ='8786500' WHERE kode_barcode='00031401' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6724000',harga_beli ='6724000' WHERE kode_barcode='00031402' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4930000',harga_beli ='4930000' WHERE kode_barcode='00031404' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00031406' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5404000',harga_beli ='5404000' WHERE kode_barcode='00031407' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6868500',harga_beli ='6868500' WHERE kode_barcode='00031409' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6291000',harga_beli ='6291000' WHERE kode_barcode='00031410' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7673000',harga_beli ='7673000' WHERE kode_barcode='00031411' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5590000',harga_beli ='5590000' WHERE kode_barcode='00031413' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3692000',harga_beli ='3692000' WHERE kode_barcode='00031414' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00031416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8106000',harga_beli ='8106000' WHERE kode_barcode='00031454' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7384000',harga_beli ='7384000' WHERE kode_barcode='00031461' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8958500',harga_beli ='8958500' WHERE kode_barcode='00031492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7141500',harga_beli ='7141500' WHERE kode_barcode='00031493' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5755000',harga_beli ='5755000' WHERE kode_barcode='00031494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4538000',harga_beli ='4538000' WHERE kode_barcode='00031495' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5177500',harga_beli ='5177500' WHERE kode_barcode='00031496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7013000',harga_beli ='7013000' WHERE kode_barcode='00031498' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6786000',harga_beli ='6786000' WHERE kode_barcode='00031502' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6765500',harga_beli ='6765500' WHERE kode_barcode='00031504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5115500',harga_beli ='5115500' WHERE kode_barcode='00031514' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6680500',harga_beli ='6680500' WHERE kode_barcode='00031516' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4556500',harga_beli ='4556500' WHERE kode_barcode='00031517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7244000',harga_beli ='7244000' WHERE kode_barcode='00031521' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6348000',harga_beli ='6348000' WHERE kode_barcode='00031522' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9624000',harga_beli ='9624000' WHERE kode_barcode='00031523' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3094000',harga_beli ='3094000' WHERE kode_barcode='00031533' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5042500',harga_beli ='5042500' WHERE kode_barcode='00031563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6527000',harga_beli ='6527000' WHERE kode_barcode='00031565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5657000',harga_beli ='5657000' WHERE kode_barcode='00031566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4249000',harga_beli ='4249000' WHERE kode_barcode='00031568' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6559000',harga_beli ='6559000' WHERE kode_barcode='00031584' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4001500',harga_beli ='4001500' WHERE kode_barcode='00031585' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7730000',harga_beli ='7730000' WHERE kode_barcode='00031588' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3424000',harga_beli ='3424000' WHERE kode_barcode='00031590' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4228500',harga_beli ='4228500' WHERE kode_barcode='00031591' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6435500',harga_beli ='6435500' WHERE kode_barcode='00031595' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3686000',harga_beli ='3686000' WHERE kode_barcode='00031599' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3379000',harga_beli ='3379000' WHERE kode_barcode='00031600' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10571000',harga_beli ='10571000' WHERE kode_barcode='00031613' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9508500',harga_beli ='9508500' WHERE kode_barcode='00031616' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00031619' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3836500',harga_beli ='3836500' WHERE kode_barcode='00031633' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00031634' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18019500',harga_beli ='18019500' WHERE kode_barcode='00031636' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3097500',harga_beli ='3097500' WHERE kode_barcode='00031637' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5280500',harga_beli ='5280500' WHERE kode_barcode='00031658' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7986000',harga_beli ='7986000' WHERE kode_barcode='00031747' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6621000',harga_beli ='6621000' WHERE kode_barcode='00031754' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17222500',harga_beli ='17222500' WHERE kode_barcode='00031755' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3465500',harga_beli ='3465500' WHERE kode_barcode='00031756' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7064500',harga_beli ='7064500' WHERE kode_barcode='00031818' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5734000',harga_beli ='5734000' WHERE kode_barcode='00031819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5964000',harga_beli ='5964000' WHERE kode_barcode='00031820' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8958500',harga_beli ='8958500' WHERE kode_barcode='00031821' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='00031823' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8139500',harga_beli ='8139500' WHERE kode_barcode='00031824' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7219000',harga_beli ='7219000' WHERE kode_barcode='00031825' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2611000',harga_beli ='2611000' WHERE kode_barcode='00031829' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4414000',harga_beli ='4414000' WHERE kode_barcode='00031856' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6706500',harga_beli ='6706500' WHERE kode_barcode='00031857' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10469000',harga_beli ='10469000' WHERE kode_barcode='00031895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7611000',harga_beli ='7611000' WHERE kode_barcode='00031896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7363500',harga_beli ='7363500' WHERE kode_barcode='00031897' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6270500',harga_beli ='6270500' WHERE kode_barcode='00031905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7013000',harga_beli ='7013000' WHERE kode_barcode='00031911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22111000',harga_beli ='22111000' WHERE kode_barcode='00031914' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3197000',harga_beli ='3197000' WHERE kode_barcode='00031968' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17573000',harga_beli ='17573000' WHERE kode_barcode='00031969' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='00032093' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6724000',harga_beli ='6724000' WHERE kode_barcode='00032094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3836500',harga_beli ='3836500' WHERE kode_barcode='00032213' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2228000',harga_beli ='2228000' WHERE kode_barcode='00032215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='25473000',harga_beli ='25473000' WHERE kode_barcode='00032356' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17470000',harga_beli ='17470000' WHERE kode_barcode='00032357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2743500',harga_beli ='2743500' WHERE kode_barcode='00032358' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5095000',harga_beli ='5095000' WHERE kode_barcode='00032360' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3692000',harga_beli ='3692000' WHERE kode_barcode='00032361' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4538000',harga_beli ='4538000' WHERE kode_barcode='00032362' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00032364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6311500',harga_beli ='6311500' WHERE kode_barcode='00032370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16954500',harga_beli ='16954500' WHERE kode_barcode='00032375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3967500',harga_beli ='3967500' WHERE kode_barcode='00032376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2289500',harga_beli ='2289500' WHERE kode_barcode='00032377' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3486000',harga_beli ='3486000' WHERE kode_barcode='00032379' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10251000',harga_beli ='10251000' WHERE kode_barcode='00032381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6930500',harga_beli ='6930500' WHERE kode_barcode='00032498' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8168000',harga_beli ='8168000' WHERE kode_barcode='00032499' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11715500',harga_beli ='11715500' WHERE kode_barcode='00032501' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6297000',harga_beli ='6297000' WHERE kode_barcode='00032504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14308000',harga_beli ='14308000' WHERE kode_barcode='00032505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6552500',harga_beli ='6552500' WHERE kode_barcode='00032507' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7986000',harga_beli ='7986000' WHERE kode_barcode='00032509' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7423000',harga_beli ='7423000' WHERE kode_barcode='00032513' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='30484500',harga_beli ='30484500' WHERE kode_barcode='00032523' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11860000',harga_beli ='11860000' WHERE kode_barcode='00032649' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8037500',harga_beli ='8037500' WHERE kode_barcode='00032667' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9797500',harga_beli ='9797500' WHERE kode_barcode='00032670' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16688500',harga_beli ='16688500' WHERE kode_barcode='00033184' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6930500',harga_beli ='6930500' WHERE kode_barcode='00033220' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5693000',harga_beli ='5693000' WHERE kode_barcode='00033261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2681500',harga_beli ='2681500' WHERE kode_barcode='00033262' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2516500',harga_beli ='2516500' WHERE kode_barcode='00033264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7986000',harga_beli ='7986000' WHERE kode_barcode='00033289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22606000',harga_beli ='22606000' WHERE kode_barcode='00033485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4063500',harga_beli ='4063500' WHERE kode_barcode='00034068' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00034069' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4971000',harga_beli ='4971000' WHERE kode_barcode='00034070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='00034071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3362000',harga_beli ='3362000' WHERE kode_barcode='00034073' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3527000',harga_beli ='3527000' WHERE kode_barcode='00034075' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1918500',harga_beli ='1918500' WHERE kode_barcode='00034076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00034080' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5260000',harga_beli ='5260000' WHERE kode_barcode='00034142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7590500',harga_beli ='7590500' WHERE kode_barcode='00034164' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4001500',harga_beli ='4001500' WHERE kode_barcode='00034166' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00034167' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23946500',harga_beli ='23946500' WHERE kode_barcode='00034249' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='00034347' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3238500',harga_beli ='3238500' WHERE kode_barcode='00034348' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5610500',harga_beli ='5610500' WHERE kode_barcode='00034349' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8518500',harga_beli ='8518500' WHERE kode_barcode='00034354' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00034355' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5218500',harga_beli ='5218500' WHERE kode_barcode='00034356' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4620500',harga_beli ='4620500' WHERE kode_barcode='00034357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4476000',harga_beli ='4476000' WHERE kode_barcode='00034372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3259000',harga_beli ='3259000' WHERE kode_barcode='00034373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3218000',harga_beli ='3218000' WHERE kode_barcode='00034374' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9612000',harga_beli ='9612000' WHERE kode_barcode='00034381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12437500',harga_beli ='12437500' WHERE kode_barcode='00034490' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4454000',harga_beli ='4454000' WHERE kode_barcode='00034661' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4070000',harga_beli ='4070000' WHERE kode_barcode='00035018' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2867000',harga_beli ='2867000' WHERE kode_barcode='00035045' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7673000',harga_beli ='7673000' WHERE kode_barcode='00035046' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3733500',harga_beli ='3733500' WHERE kode_barcode='00035171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11344500',harga_beli ='11344500' WHERE kode_barcode='00035278' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6188000',harga_beli ='6188000' WHERE kode_barcode='00035477' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4558500',harga_beli ='4558500' WHERE kode_barcode='00035519' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1176000',harga_beli ='1176000' WHERE kode_barcode='00035951' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10853000',harga_beli ='10853000' WHERE kode_barcode='00036172' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='949000',harga_beli ='949000' WHERE kode_barcode='00036243' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='866500',harga_beli ='866500' WHERE kode_barcode='00036245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='00036432' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='00036686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4682500',harga_beli ='4682500' WHERE kode_barcode='00036992' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4311000',harga_beli ='4311000' WHERE kode_barcode='00037325' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6208500',harga_beli ='6208500' WHERE kode_barcode='00037332' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6745000',harga_beli ='6745000' WHERE kode_barcode='00037825' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3692000',harga_beli ='3692000' WHERE kode_barcode='00037907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00038024' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5651500',harga_beli ='5651500' WHERE kode_barcode='00038455' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2888000',harga_beli ='2888000' WHERE kode_barcode='00038674' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00038843' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3341500',harga_beli ='3341500' WHERE kode_barcode='00039179' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2702000',harga_beli ='2702000' WHERE kode_barcode='00039180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2145500',harga_beli ='2145500' WHERE kode_barcode='00039181' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6311500',harga_beli ='6311500' WHERE kode_barcode='00039192' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00039193' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='00039194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12114500',harga_beli ='12114500' WHERE kode_barcode='00039381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4043000',harga_beli ='4043000' WHERE kode_barcode='00039405' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7996000',harga_beli ='7996000' WHERE kode_barcode='00040395' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11648500',harga_beli ='11648500' WHERE kode_barcode='00040869' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5237500',harga_beli ='5237500' WHERE kode_barcode='00040871' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3839500',harga_beli ='3839500' WHERE kode_barcode='00041095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='00041096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3630500',harga_beli ='3630500' WHERE kode_barcode='00041097' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6703500',harga_beli ='6703500' WHERE kode_barcode='00041099' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7796500',harga_beli ='7796500' WHERE kode_barcode='00041100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3692000',harga_beli ='3692000' WHERE kode_barcode='00041101' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5239000',harga_beli ='5239000' WHERE kode_barcode='00041102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7244000',harga_beli ='7244000' WHERE kode_barcode='00041103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3733500',harga_beli ='3733500' WHERE kode_barcode='00041104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2888000',harga_beli ='2888000' WHERE kode_barcode='00041105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1629500',harga_beli ='1629500' WHERE kode_barcode='00041106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6971500',harga_beli ='6971500' WHERE kode_barcode='00041108' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3836500',harga_beli ='3836500' WHERE kode_barcode='00041109' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8271000',harga_beli ='8271000' WHERE kode_barcode='00041110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8395000',harga_beli ='8395000' WHERE kode_barcode='00041111' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8168000',harga_beli ='8168000' WHERE kode_barcode='00041112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8230000',harga_beli ='8230000' WHERE kode_barcode='00041113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7714000',harga_beli ='7714000' WHERE kode_barcode='00041114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15413500',harga_beli ='15413500' WHERE kode_barcode='00041180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9244500',harga_beli ='9244500' WHERE kode_barcode='00041280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8745500',harga_beli ='8745500' WHERE kode_barcode='00041414' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5368000',harga_beli ='5368000' WHERE kode_barcode='00042238' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='00042487' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='00042503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7236500',harga_beli ='7236500' WHERE kode_barcode='00042736' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7528500',harga_beli ='7528500' WHERE kode_barcode='00043558' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4991500',harga_beli ='4991500' WHERE kode_barcode='00043942' LIMIT 1; UPDATE tm_group SET harga='2485000' WHERE kode_group = 'DM' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2485000','kasir','2026-06-08 13:35:11'); UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2408000',harga_beli ='2408000' WHERE kode_barcode='00019926' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='00019929' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='00019933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7752000',harga_beli ='7752000' WHERE kode_barcode='00024887' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7942500',harga_beli ='7942500' WHERE kode_barcode='00024889' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6442500',harga_beli ='6442500' WHERE kode_barcode='00024890' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6400500',harga_beli ='6400500' WHERE kode_barcode='00024891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6400500',harga_beli ='6400500' WHERE kode_barcode='00024892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00024893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00024895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6421500',harga_beli ='6421500' WHERE kode_barcode='00024896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6400500',harga_beli ='6400500' WHERE kode_barcode='00024897' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6316000',harga_beli ='6316000' WHERE kode_barcode='00024898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6337000',harga_beli ='6337000' WHERE kode_barcode='00024899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6421500',harga_beli ='6421500' WHERE kode_barcode='00024900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6400500',harga_beli ='6400500' WHERE kode_barcode='00024901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6400500',harga_beli ='6400500' WHERE kode_barcode='00024902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6358000',harga_beli ='6358000' WHERE kode_barcode='00024903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00024904' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00024905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4520500',harga_beli ='4520500' WHERE kode_barcode='00024909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4647000',harga_beli ='4647000' WHERE kode_barcode='00024912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4541500',harga_beli ='4541500' WHERE kode_barcode='00024919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4605000',harga_beli ='4605000' WHERE kode_barcode='00024922' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4520500',harga_beli ='4520500' WHERE kode_barcode='00024923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18429000',harga_beli ='18429000' WHERE kode_barcode='00025675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19244500',harga_beli ='19244500' WHERE kode_barcode='00025676' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19816500',harga_beli ='19816500' WHERE kode_barcode='00025677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17217500',harga_beli ='17217500' WHERE kode_barcode='00025679' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='29578500',harga_beli ='29578500' WHERE kode_barcode='00025682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18317000',harga_beli ='18317000' WHERE kode_barcode='00025683' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='21608500',harga_beli ='21608500' WHERE kode_barcode='00025684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9520500',harga_beli ='9520500' WHERE kode_barcode='00025687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18059500',harga_beli ='18059500' WHERE kode_barcode='00025697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6965000',harga_beli ='6965000' WHERE kode_barcode='00025699' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11895000',harga_beli ='11895000' WHERE kode_barcode='00025701' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11872500',harga_beli ='11872500' WHERE kode_barcode='00025702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3957500',harga_beli ='3957500' WHERE kode_barcode='00025706' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4387500',harga_beli ='4387500' WHERE kode_barcode='00025711' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4681500',harga_beli ='4681500' WHERE kode_barcode='00025714' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13930000',harga_beli ='13930000' WHERE kode_barcode='00025716' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7010500',harga_beli ='7010500' WHERE kode_barcode='00025717' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5065500',harga_beli ='5065500' WHERE kode_barcode='00025718' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4161000',harga_beli ='4161000' WHERE kode_barcode='00025724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1673500',harga_beli ='1673500' WHERE kode_barcode='00025726' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1651000',harga_beli ='1651000' WHERE kode_barcode='00025727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5383500',harga_beli ='5383500' WHERE kode_barcode='00025730' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7091500',harga_beli ='7091500' WHERE kode_barcode='00025735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3740500',harga_beli ='3740500' WHERE kode_barcode='00025737' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10862000',harga_beli ='10862000' WHERE kode_barcode='00025740' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5427000',harga_beli ='5427000' WHERE kode_barcode='00025742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6572500',harga_beli ='6572500' WHERE kode_barcode='00025743' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='20659500',harga_beli ='20659500' WHERE kode_barcode='00025747' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='52103000',harga_beli ='52103000' WHERE kode_barcode='00025795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23103500',harga_beli ='23103500' WHERE kode_barcode='00025796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='48170500',harga_beli ='48170500' WHERE kode_barcode='00025797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17251000',harga_beli ='17251000' WHERE kode_barcode='00025798' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='21100000',harga_beli ='21100000' WHERE kode_barcode='00025799' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16809000',harga_beli ='16809000' WHERE kode_barcode='00025800' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6273500',harga_beli ='6273500' WHERE kode_barcode='00025877' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6104500',harga_beli ='6104500' WHERE kode_barcode='00025880' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4520500',harga_beli ='4520500' WHERE kode_barcode='00025882' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5302000',harga_beli ='5302000' WHERE kode_barcode='00025883' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00025888' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='29684000',harga_beli ='29684000' WHERE kode_barcode='00025892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13371000',harga_beli ='13371000' WHERE kode_barcode='00025893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10730500',harga_beli ='10730500' WHERE kode_barcode='00025894' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13624500',harga_beli ='13624500' WHERE kode_barcode='00025896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5095000',harga_beli ='5095000' WHERE kode_barcode='00026055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='00026056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3548000',harga_beli ='3548000' WHERE kode_barcode='00026058' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00026059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4022000',harga_beli ='4022000' WHERE kode_barcode='00026060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5999000',harga_beli ='5999000' WHERE kode_barcode='00026061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='00026062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4013500',harga_beli ='4013500' WHERE kode_barcode='00026064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3971500',harga_beli ='3971500' WHERE kode_barcode='00026065' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3147500',harga_beli ='3147500' WHERE kode_barcode='00026070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3126500',harga_beli ='3126500' WHERE kode_barcode='00026071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5450000',harga_beli ='5450000' WHERE kode_barcode='00026072' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8259000',harga_beli ='8259000' WHERE kode_barcode='00026078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12610500',harga_beli ='12610500' WHERE kode_barcode='00026079' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='00026081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5302000',harga_beli ='5302000' WHERE kode_barcode='00026082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4021500',harga_beli ='4021500' WHERE kode_barcode='00026085' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16581500',harga_beli ='16581500' WHERE kode_barcode='00026086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14955000',harga_beli ='14955000' WHERE kode_barcode='00026087' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='60178500',harga_beli ='60178500' WHERE kode_barcode='00026090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='63072000',harga_beli ='63072000' WHERE kode_barcode='00026091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12040000',harga_beli ='12040000' WHERE kode_barcode='00026093' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23150500',harga_beli ='23150500' WHERE kode_barcode='00026095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18905000',harga_beli ='18905000' WHERE kode_barcode='00026096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5281000',harga_beli ='5281000' WHERE kode_barcode='00026099' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3946000',harga_beli ='3946000' WHERE kode_barcode='00026104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5909500',harga_beli ='5909500' WHERE kode_barcode='00026105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3946000',harga_beli ='3946000' WHERE kode_barcode='00026106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4064000',harga_beli ='4064000' WHERE kode_barcode='00026107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5293500',harga_beli ='5293500' WHERE kode_barcode='00026108' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3907000',harga_beli ='3907000' WHERE kode_barcode='00026109' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3635000',harga_beli ='3635000' WHERE kode_barcode='00026110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3966000',harga_beli ='3966000' WHERE kode_barcode='00026111' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5205000',harga_beli ='5205000' WHERE kode_barcode='00026112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5968500',harga_beli ='5968500' WHERE kode_barcode='00026113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3926500',harga_beli ='3926500' WHERE kode_barcode='00026115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4322500',harga_beli ='4322500' WHERE kode_barcode='00026117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4381000',harga_beli ='4381000' WHERE kode_barcode='00026118' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3450500',harga_beli ='3450500' WHERE kode_barcode='00026119' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2946500',harga_beli ='2946500' WHERE kode_barcode='00026120' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2966000',harga_beli ='2966000' WHERE kode_barcode='00026121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='53979000',harga_beli ='53979000' WHERE kode_barcode='00026125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8442000',harga_beli ='8442000' WHERE kode_barcode='00026126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7889000',harga_beli ='7889000' WHERE kode_barcode='00026132' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10272000',harga_beli ='10272000' WHERE kode_barcode='00026140' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5599500',harga_beli ='5599500' WHERE kode_barcode='00026141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00026142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00026145' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2704000',harga_beli ='2704000' WHERE kode_barcode='00026146' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5621500',harga_beli ='5621500' WHERE kode_barcode='00026147' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10437000',harga_beli ='10437000' WHERE kode_barcode='00026152' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14118000',harga_beli ='14118000' WHERE kode_barcode='00026469' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7697000',harga_beli ='7697000' WHERE kode_barcode='00026471' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3740500',harga_beli ='3740500' WHERE kode_barcode='00026472' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4086500',harga_beli ='4086500' WHERE kode_barcode='00026475' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='27392000',harga_beli ='27392000' WHERE kode_barcode='00026480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='28905500',harga_beli ='28905500' WHERE kode_barcode='00026481' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10031500',harga_beli ='10031500' WHERE kode_barcode='00026484' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00026486' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4454000',harga_beli ='4454000' WHERE kode_barcode='00026487' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6594000',harga_beli ='6594000' WHERE kode_barcode='00026525' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3740500',harga_beli ='3740500' WHERE kode_barcode='00026527' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4367500',harga_beli ='4367500' WHERE kode_barcode='00026529' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3697000',harga_beli ='3697000' WHERE kode_barcode='00026534' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14377000',harga_beli ='14377000' WHERE kode_barcode='00026537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9686000',harga_beli ='9686000' WHERE kode_barcode='00026538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16344500',harga_beli ='16344500' WHERE kode_barcode='00026553' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10118000',harga_beli ='10118000' WHERE kode_barcode='00026557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15653000',harga_beli ='15653000' WHERE kode_barcode='00026560' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4367500',harga_beli ='4367500' WHERE kode_barcode='00026561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4410500',harga_beli ='4410500' WHERE kode_barcode='00026563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8618500',harga_beli ='8618500' WHERE kode_barcode='00026653' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2366000',harga_beli ='2366000' WHERE kode_barcode='00026654' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3527500',harga_beli ='3527500' WHERE kode_barcode='00026655' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3633500',harga_beli ='3633500' WHERE kode_barcode='00026656' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4182500',harga_beli ='4182500' WHERE kode_barcode='00026658' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2408000',harga_beli ='2408000' WHERE kode_barcode='00026659' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4922000',harga_beli ='4922000' WHERE kode_barcode='00026660' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3464500',harga_beli ='3464500' WHERE kode_barcode='00026662' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4562500',harga_beli ='4562500' WHERE kode_barcode='00026665' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00026666' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4372500',harga_beli ='4372500' WHERE kode_barcode='00026668' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4806000',harga_beli ='4806000' WHERE kode_barcode='00026669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9983000',harga_beli ='9983000' WHERE kode_barcode='00026671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3816000',harga_beli ='3816000' WHERE kode_barcode='00026677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='00026678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5492000',harga_beli ='5492000' WHERE kode_barcode='00026679' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2915000',harga_beli ='2915000' WHERE kode_barcode='00026680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5006500',harga_beli ='5006500' WHERE kode_barcode='00026681' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3105500',harga_beli ='3105500' WHERE kode_barcode='00026684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3380000',harga_beli ='3380000' WHERE kode_barcode='00026686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4985000',harga_beli ='4985000' WHERE kode_barcode='00026691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10308000',harga_beli ='10308000' WHERE kode_barcode='00026693' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5914500',harga_beli ='5914500' WHERE kode_barcode='00026697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4647000',harga_beli ='4647000' WHERE kode_barcode='00026699' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4330500',harga_beli ='4330500' WHERE kode_barcode='00026702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00026708' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5006500',harga_beli ='5006500' WHERE kode_barcode='00026710' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2957500',harga_beli ='2957500' WHERE kode_barcode='00026711' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4540500',harga_beli ='4540500' WHERE kode_barcode='00027627' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13210000',harga_beli ='13210000' WHERE kode_barcode='00027630' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16323000',harga_beli ='16323000' WHERE kode_barcode='00027632' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='24387000',harga_beli ='24387000' WHERE kode_barcode='00027635' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='26354500',harga_beli ='26354500' WHERE kode_barcode='00027636' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15890500',harga_beli ='15890500' WHERE kode_barcode='00027638' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9988500',harga_beli ='9988500' WHERE kode_barcode='00027643' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11394000',harga_beli ='11394000' WHERE kode_barcode='00027645' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15134000',harga_beli ='15134000' WHERE kode_barcode='00027646' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11891000',harga_beli ='11891000' WHERE kode_barcode='00027647' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8215500',harga_beli ='8215500' WHERE kode_barcode='00027649' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6702500',harga_beli ='6702500' WHERE kode_barcode='00027650' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19025500',harga_beli ='19025500' WHERE kode_barcode='00027652' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23241000',harga_beli ='23241000' WHERE kode_barcode='00027654' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7990500',harga_beli ='7990500' WHERE kode_barcode='00027657' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3608500',harga_beli ='3608500' WHERE kode_barcode='00027659' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5773500',harga_beli ='5773500' WHERE kode_barcode='00027663' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5883000',harga_beli ='5883000' WHERE kode_barcode='00027664' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00027667' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12331500',harga_beli ='12331500' WHERE kode_barcode='00027668' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6069500',harga_beli ='6069500' WHERE kode_barcode='00027669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16798000',harga_beli ='16798000' WHERE kode_barcode='00027671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17546000',harga_beli ='17546000' WHERE kode_barcode='00027672' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9621000',harga_beli ='9621000' WHERE kode_barcode='00027678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5513000',harga_beli ='5513000' WHERE kode_barcode='00027680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13712500',harga_beli ='13712500' WHERE kode_barcode='00027681' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5640000',harga_beli ='5640000' WHERE kode_barcode='00027682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3253000',harga_beli ='3253000' WHERE kode_barcode='00027687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4224500',harga_beli ='4224500' WHERE kode_barcode='00027688' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14752000',harga_beli ='14752000' WHERE kode_barcode='00027691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='19551500',harga_beli ='19551500' WHERE kode_barcode='00027694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3892000',harga_beli ='3892000' WHERE kode_barcode='00029700' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8069500',harga_beli ='8069500' WHERE kode_barcode='00029701' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6364000',harga_beli ='6364000' WHERE kode_barcode='00029702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14017500',harga_beli ='14017500' WHERE kode_barcode='00029703' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5489000',harga_beli ='5489000' WHERE kode_barcode='00029704' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16248000',harga_beli ='16248000' WHERE kode_barcode='00029705' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9753500',harga_beli ='9753500' WHERE kode_barcode='00029706' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10657000',harga_beli ='10657000' WHERE kode_barcode='00030416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='41421500',harga_beli ='41421500' WHERE kode_barcode='00030724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7013000',harga_beli ='7013000' WHERE kode_barcode='00030727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='28322000',harga_beli ='28322000' WHERE kode_barcode='00030732' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14118000',harga_beli ='14118000' WHERE kode_barcode='00030733' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10500000',harga_beli ='10500000' WHERE kode_barcode='00030735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23998000',harga_beli ='23998000' WHERE kode_barcode='00030741' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12150500',harga_beli ='12150500' WHERE kode_barcode='00030742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14788000',harga_beli ='14788000' WHERE kode_barcode='00030744' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3274500',harga_beli ='3274500' WHERE kode_barcode='00030753' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3887000',harga_beli ='3887000' WHERE kode_barcode='00030754' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10284500',harga_beli ='10284500' WHERE kode_barcode='00030755' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9080500',harga_beli ='9080500' WHERE kode_barcode='00030758' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00030761' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='00030763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5967500',harga_beli ='5967500' WHERE kode_barcode='00030766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5664500',harga_beli ='5664500' WHERE kode_barcode='00030767' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6053500',harga_beli ='6053500' WHERE kode_barcode='00030768' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5967500',harga_beli ='5967500' WHERE kode_barcode='00030769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23565500',harga_beli ='23565500' WHERE kode_barcode='00030773' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='55151500',harga_beli ='55151500' WHERE kode_barcode='00030774' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4753000',harga_beli ='4753000' WHERE kode_barcode='00030786' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3992500',harga_beli ='3992500' WHERE kode_barcode='00030787' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9167500',harga_beli ='9167500' WHERE kode_barcode='00031682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3992500',harga_beli ='3992500' WHERE kode_barcode='00031684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='00031686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1922500',harga_beli ='1922500' WHERE kode_barcode='00031687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8576000',harga_beli ='8576000' WHERE kode_barcode='00031690' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3664000',harga_beli ='3664000' WHERE kode_barcode='00032055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5326000',harga_beli ='5326000' WHERE kode_barcode='00033455' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7013000',harga_beli ='7013000' WHERE kode_barcode='00033504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2228000',harga_beli ='2228000' WHERE kode_barcode='00033505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2454500',harga_beli ='2454500' WHERE kode_barcode='00033509' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2413500',harga_beli ='2413500' WHERE kode_barcode='00033510' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14596000',harga_beli ='14596000' WHERE kode_barcode='00033511' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14934000',harga_beli ='14934000' WHERE kode_barcode='00033512' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22179000',harga_beli ='22179000' WHERE kode_barcode='00033513' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17299500',harga_beli ='17299500' WHERE kode_barcode='00033516' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12378000',harga_beli ='12378000' WHERE kode_barcode='00033517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5619000',harga_beli ='5619000' WHERE kode_barcode='00033518' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2455500',harga_beli ='2455500' WHERE kode_barcode='00033881' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5033000',harga_beli ='5033000' WHERE kode_barcode='00034763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4744000',harga_beli ='4744000' WHERE kode_barcode='00034768' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3094000',harga_beli ='3094000' WHERE kode_barcode='00034769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5280500',harga_beli ='5280500' WHERE kode_barcode='00034776' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2949500',harga_beli ='2949500' WHERE kode_barcode='00035830' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3168500',harga_beli ='3168500' WHERE kode_barcode='00035831' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3094000',harga_beli ='3094000' WHERE kode_barcode='00036359' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00036412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5177500',harga_beli ='5177500' WHERE kode_barcode='00036624' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4579000',harga_beli ='4579000' WHERE kode_barcode='00036626' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5569000',harga_beli ='5569000' WHERE kode_barcode='00036627' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4930000',harga_beli ='4930000' WHERE kode_barcode='00036628' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6569500',harga_beli ='6569500' WHERE kode_barcode='00036763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6485000',harga_beli ='6485000' WHERE kode_barcode='00036764' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6442500',harga_beli ='6442500' WHERE kode_barcode='00036765' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6421500',harga_beli ='6421500' WHERE kode_barcode='00036766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3444500',harga_beli ='3444500' WHERE kode_barcode='00036806' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4661500',harga_beli ='4661500' WHERE kode_barcode='00036848' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4043000',harga_beli ='4043000' WHERE kode_barcode='00036852' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4558500',harga_beli ='4558500' WHERE kode_barcode='00036853' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00036855' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14849500',harga_beli ='14849500' WHERE kode_barcode='00036906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18355500',harga_beli ='18355500' WHERE kode_barcode='00036907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10815000',harga_beli ='10815000' WHERE kode_barcode='00036908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7013000',harga_beli ='7013000' WHERE kode_barcode='00036909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11237500',harga_beli ='11237500' WHERE kode_barcode='00036912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7710000',harga_beli ='7710000' WHERE kode_barcode='00036913' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18968500',harga_beli ='18968500' WHERE kode_barcode='00036914' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15018500',harga_beli ='15018500' WHERE kode_barcode='00036915' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12462500',harga_beli ='12462500' WHERE kode_barcode='00036916' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='21186000',harga_beli ='21186000' WHERE kode_barcode='00036918' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4558500',harga_beli ='4558500' WHERE kode_barcode='00037019' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6126000',harga_beli ='6126000' WHERE kode_barcode='00037246' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4909000',harga_beli ='4909000' WHERE kode_barcode='00037250' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5631000',harga_beli ='5631000' WHERE kode_barcode='00037273' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00037274' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3857000',harga_beli ='3857000' WHERE kode_barcode='00037278' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00037280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3960500',harga_beli ='3960500' WHERE kode_barcode='00037284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7405000',harga_beli ='7405000' WHERE kode_barcode='00037288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4432500',harga_beli ='4432500' WHERE kode_barcode='00038371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4410500',harga_beli ='4410500' WHERE kode_barcode='00038373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4454000',harga_beli ='4454000' WHERE kode_barcode='00038375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3762000',harga_beli ='3762000' WHERE kode_barcode='00038376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7740000',harga_beli ='7740000' WHERE kode_barcode='00038378' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13664000',harga_beli ='13664000' WHERE kode_barcode='00038381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7351000',harga_beli ='7351000' WHERE kode_barcode='00038382' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3610500',harga_beli ='3610500' WHERE kode_barcode='00038383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9296500',harga_beli ='9296500' WHERE kode_barcode='00038385' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9534500',harga_beli ='9534500' WHERE kode_barcode='00038386' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9577500',harga_beli ='9577500' WHERE kode_barcode='00038387' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='00038388' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3173000',harga_beli ='3173000' WHERE kode_barcode='00038389' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3507000',harga_beli ='3507000' WHERE kode_barcode='00038391' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3402500',harga_beli ='3402500' WHERE kode_barcode='00038393' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3465500',harga_beli ='3465500' WHERE kode_barcode='00038394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1858000',harga_beli ='1858000' WHERE kode_barcode='00038396' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1816500',harga_beli ='1816500' WHERE kode_barcode='00038397' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2338000',harga_beli ='2338000' WHERE kode_barcode='00038399' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2651500',harga_beli ='2651500' WHERE kode_barcode='00038400' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2192000',harga_beli ='2192000' WHERE kode_barcode='00038402' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2213000',harga_beli ='2213000' WHERE kode_barcode='00038403' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2818500',harga_beli ='2818500' WHERE kode_barcode='00038404' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1795500',harga_beli ='1795500' WHERE kode_barcode='00038405' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2568000',harga_beli ='2568000' WHERE kode_barcode='00038407' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2568000',harga_beli ='2568000' WHERE kode_barcode='00038408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2275500',harga_beli ='2275500' WHERE kode_barcode='00038411' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4843000',harga_beli ='4843000' WHERE kode_barcode='00038419' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4843000',harga_beli ='4843000' WHERE kode_barcode='00038420' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4947500',harga_beli ='4947500' WHERE kode_barcode='00038421' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4843000',harga_beli ='4843000' WHERE kode_barcode='00038422' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6033000',harga_beli ='6033000' WHERE kode_barcode='00038424' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6408500',harga_beli ='6408500' WHERE kode_barcode='00038425' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5072500',harga_beli ='5072500' WHERE kode_barcode='00038427' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4530000',harga_beli ='4530000' WHERE kode_barcode='00038429' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5072500',harga_beli ='5072500' WHERE kode_barcode='00038430' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4530000',harga_beli ='4530000' WHERE kode_barcode='00038431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12504000',harga_beli ='12504000' WHERE kode_barcode='00038433' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12566500',harga_beli ='12566500' WHERE kode_barcode='00038434' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10540500',harga_beli ='10540500' WHERE kode_barcode='00038435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10794000',harga_beli ='10794000' WHERE kode_barcode='00038436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='00038437' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2577000',harga_beli ='2577000' WHERE kode_barcode='00038438' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7224000',harga_beli ='7224000' WHERE kode_barcode='00038441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2957500',harga_beli ='2957500' WHERE kode_barcode='00038444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8280500',harga_beli ='8280500' WHERE kode_barcode='00038446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8914000',harga_beli ='8914000' WHERE kode_barcode='00038449' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14089000',harga_beli ='14089000' WHERE kode_barcode='00038452' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17384000',harga_beli ='17384000' WHERE kode_barcode='00038454' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4780500',harga_beli ='4780500' WHERE kode_barcode='00038534' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4342000',harga_beli ='4342000' WHERE kode_barcode='00038535' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1983500',harga_beli ='1983500' WHERE kode_barcode='00038536' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2526000',harga_beli ='2526000' WHERE kode_barcode='00038537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2672000',harga_beli ='2672000' WHERE kode_barcode='00038538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='00038540' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1879000',harga_beli ='1879000' WHERE kode_barcode='00038543' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1879000',harga_beli ='1879000' WHERE kode_barcode='00038545' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2087500',harga_beli ='2087500' WHERE kode_barcode='00038547' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2025000',harga_beli ='2025000' WHERE kode_barcode='00038548' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4029000',harga_beli ='4029000' WHERE kode_barcode='00038551' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4530000',harga_beli ='4530000' WHERE kode_barcode='00038552' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6062500',harga_beli ='6062500' WHERE kode_barcode='00038553' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5788000',harga_beli ='5788000' WHERE kode_barcode='00038554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23699500',harga_beli ='23699500' WHERE kode_barcode='00038556' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4259500',harga_beli ='4259500' WHERE kode_barcode='00038557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10031500',harga_beli ='10031500' WHERE kode_barcode='00038559' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1276000',harga_beli ='1276000' WHERE kode_barcode='00038564' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1276000',harga_beli ='1276000' WHERE kode_barcode='00038565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1276000',harga_beli ='1276000' WHERE kode_barcode='00038566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6616000',harga_beli ='6616000' WHERE kode_barcode='00038567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4454000',harga_beli ='4454000' WHERE kode_barcode='00038568' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6464500',harga_beli ='6464500' WHERE kode_barcode='00038569' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4475500',harga_beli ='4475500' WHERE kode_barcode='00038570' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4432500',harga_beli ='4432500' WHERE kode_barcode='00038571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11069500',harga_beli ='11069500' WHERE kode_barcode='00038575' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2423000',harga_beli ='2423000' WHERE kode_barcode='00038772' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='127977500',harga_beli ='127977500' WHERE kode_barcode='00038877' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='49444000',harga_beli ='49444000' WHERE kode_barcode='00038891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='46063000',harga_beli ='46063000' WHERE kode_barcode='00038892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='40174500',harga_beli ='40174500' WHERE kode_barcode='00038893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4854000',harga_beli ='4854000' WHERE kode_barcode='00038894' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6081500',harga_beli ='6081500' WHERE kode_barcode='00038895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11898500',harga_beli ='11898500' WHERE kode_barcode='00038896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8151500',harga_beli ='8151500' WHERE kode_barcode='00038897' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00038898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10690000',harga_beli ='10690000' WHERE kode_barcode='00038899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8329000',harga_beli ='8329000' WHERE kode_barcode='00038900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5722500',harga_beli ='5722500' WHERE kode_barcode='00038901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3664000',harga_beli ='3664000' WHERE kode_barcode='00038902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9330000',harga_beli ='9330000' WHERE kode_barcode='00038903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5345000',harga_beli ='5345000' WHERE kode_barcode='00038904' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12805000',harga_beli ='12805000' WHERE kode_barcode='00038905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='14750000',harga_beli ='14750000' WHERE kode_barcode='00038906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8197000',harga_beli ='8197000' WHERE kode_barcode='00038907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11067500',harga_beli ='11067500' WHERE kode_barcode='00038908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5685000',harga_beli ='5685000' WHERE kode_barcode='00038923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='28896000',harga_beli ='28896000' WHERE kode_barcode='00038924' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22965500',harga_beli ='22965500' WHERE kode_barcode='00038925' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2450500',harga_beli ='2450500' WHERE kode_barcode='00038950' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6048000',harga_beli ='6048000' WHERE kode_barcode='00038951' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16088000',harga_beli ='16088000' WHERE kode_barcode='00039103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4013500',harga_beli ='4013500' WHERE kode_barcode='00039104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5340500',harga_beli ='5340500' WHERE kode_barcode='00039105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18723000',harga_beli ='18723000' WHERE kode_barcode='00039107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3978500',harga_beli ='3978500' WHERE kode_barcode='00039109' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3697000',harga_beli ='3697000' WHERE kode_barcode='00039110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4519000',harga_beli ='4519000' WHERE kode_barcode='00039111' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00039164' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00039165' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4249000',harga_beli ='4249000' WHERE kode_barcode='00039166' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00039168' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3465500',harga_beli ='3465500' WHERE kode_barcode='00039169' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3135500',harga_beli ='3135500' WHERE kode_barcode='00039171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='26270500',harga_beli ='26270500' WHERE kode_barcode='00039222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13407000',harga_beli ='13407000' WHERE kode_barcode='00039223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5250500',harga_beli ='5250500' WHERE kode_barcode='00039224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4721500',harga_beli ='4721500' WHERE kode_barcode='00039225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7975000',harga_beli ='7975000' WHERE kode_barcode='00039227' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11388500',harga_beli ='11388500' WHERE kode_barcode='00039228' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7649000',harga_beli ='7649000' WHERE kode_barcode='00039229' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7517000',harga_beli ='7517000' WHERE kode_barcode='00039230' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6875000',harga_beli ='6875000' WHERE kode_barcode='00039231' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5288500',harga_beli ='5288500' WHERE kode_barcode='00039233' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00039235' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00039236' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2488000',harga_beli ='2488000' WHERE kode_barcode='00039237' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2452500',harga_beli ='2452500' WHERE kode_barcode='00039238' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5528000',harga_beli ='5528000' WHERE kode_barcode='00039278' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5685000',harga_beli ='5685000' WHERE kode_barcode='00039444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7309000',harga_beli ='7309000' WHERE kode_barcode='00039795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4287500',harga_beli ='4287500' WHERE kode_barcode='00040124' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1329000',harga_beli ='1329000' WHERE kode_barcode='00040125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1329000',harga_beli ='1329000' WHERE kode_barcode='00040127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1832000',harga_beli ='1832000' WHERE kode_barcode='00040133' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2254500',harga_beli ='2254500' WHERE kode_barcode='00040134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2496000',harga_beli ='2496000' WHERE kode_barcode='00040137' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2395500',harga_beli ='2395500' WHERE kode_barcode='00040139' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='00040140' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2677500',harga_beli ='2677500' WHERE kode_barcode='00040142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2617000',harga_beli ='2617000' WHERE kode_barcode='00040143' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2093500',harga_beli ='2093500' WHERE kode_barcode='00040144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3261000',harga_beli ='3261000' WHERE kode_barcode='00040145' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3261000',harga_beli ='3261000' WHERE kode_barcode='00040147' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3019500',harga_beli ='3019500' WHERE kode_barcode='00040148' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2597000',harga_beli ='2597000' WHERE kode_barcode='00040149' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2576500',harga_beli ='2576500' WHERE kode_barcode='00040150' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1208000',harga_beli ='1208000' WHERE kode_barcode='00040151' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2254500',harga_beli ='2254500' WHERE kode_barcode='00040156' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1288500',harga_beli ='1288500' WHERE kode_barcode='00040157' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1731500',harga_beli ='1731500' WHERE kode_barcode='00040161' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1812000',harga_beli ='1812000' WHERE kode_barcode='00040162' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1469500',harga_beli ='1469500' WHERE kode_barcode='00040163' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9803000',harga_beli ='9803000' WHERE kode_barcode='00040165' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6200000',harga_beli ='6200000' WHERE kode_barcode='00040169' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8836500',harga_beli ='8836500' WHERE kode_barcode='00040171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6260000',harga_beli ='6260000' WHERE kode_barcode='00040176' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2073500',harga_beli ='2073500' WHERE kode_barcode='00040180' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6623000',harga_beli ='6623000' WHERE kode_barcode='00040181' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11758000',harga_beli ='11758000' WHERE kode_barcode='00040182' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7295000',harga_beli ='7295000' WHERE kode_barcode='00040183' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7662000',harga_beli ='7662000' WHERE kode_barcode='00040184' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7560000',harga_beli ='7560000' WHERE kode_barcode='00040185' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8538000',harga_beli ='8538000' WHERE kode_barcode='00040186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8579000',harga_beli ='8579000' WHERE kode_barcode='00040189' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='23515500',harga_beli ='23515500' WHERE kode_barcode='00040190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11432000',harga_beli ='11432000' WHERE kode_barcode='00040194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8212000',harga_beli ='8212000' WHERE kode_barcode='00040198' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4035000',harga_beli ='4035000' WHERE kode_barcode='00040201' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4014500',harga_beli ='4014500' WHERE kode_barcode='00040202' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4137000',harga_beli ='4137000' WHERE kode_barcode='00040204' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4198000',harga_beli ='4198000' WHERE kode_barcode='00040205' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4218500',harga_beli ='4218500' WHERE kode_barcode='00040206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4259000',harga_beli ='4259000' WHERE kode_barcode='00040207' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4198000',harga_beli ='4198000' WHERE kode_barcode='00040208' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='00040209' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1733000',harga_beli ='1733000' WHERE kode_barcode='00040211' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1238000',harga_beli ='1238000' WHERE kode_barcode='00040212' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1196500',harga_beli ='1196500' WHERE kode_barcode='00040213' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1196500',harga_beli ='1196500' WHERE kode_barcode='00040214' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2681500',harga_beli ='2681500' WHERE kode_barcode='00040215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11571000',harga_beli ='11571000' WHERE kode_barcode='00040217' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4950500',harga_beli ='4950500' WHERE kode_barcode='00040218' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5796000',harga_beli ='5796000' WHERE kode_barcode='00040220' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2839000',harga_beli ='2839000' WHERE kode_barcode='00040222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2922500',harga_beli ='2922500' WHERE kode_barcode='00040223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7932500',harga_beli ='7932500' WHERE kode_barcode='00040225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6617500',harga_beli ='6617500' WHERE kode_barcode='00040229' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00040230' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5427500',harga_beli ='5427500' WHERE kode_barcode='00040231' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6534000',harga_beli ='6534000' WHERE kode_barcode='00040234' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5803000',harga_beli ='5803000' WHERE kode_barcode='00040236' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5886500',harga_beli ='5886500' WHERE kode_barcode='00040238' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6158000',harga_beli ='6158000' WHERE kode_barcode='00040239' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4112500',harga_beli ='4112500' WHERE kode_barcode='00040241' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6116500',harga_beli ='6116500' WHERE kode_barcode='00040242' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4947500',harga_beli ='4947500' WHERE kode_barcode='00040243' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6220500',harga_beli ='6220500' WHERE kode_barcode='00040245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='10771500',harga_beli ='10771500' WHERE kode_barcode='00040246' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6241500',harga_beli ='6241500' WHERE kode_barcode='00040247' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8329000',harga_beli ='8329000' WHERE kode_barcode='00040248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4488000',harga_beli ='4488000' WHERE kode_barcode='00040249' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8204000',harga_beli ='8204000' WHERE kode_barcode='00040250' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8016000',harga_beli ='8016000' WHERE kode_barcode='00040252' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4530000',harga_beli ='4530000' WHERE kode_barcode='00040253' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13339000',harga_beli ='13339000' WHERE kode_barcode='00040254' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13151000',harga_beli ='13151000' WHERE kode_barcode='00040255' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4384000',harga_beli ='4384000' WHERE kode_barcode='00040256' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4112500',harga_beli ='4112500' WHERE kode_barcode='00040261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6304000',harga_beli ='6304000' WHERE kode_barcode='00040262' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4112500',harga_beli ='4112500' WHERE kode_barcode='00040263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6283500',harga_beli ='6283500' WHERE kode_barcode='00040264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='00040266' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4613500',harga_beli ='4613500' WHERE kode_barcode='00040267' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4237500',harga_beli ='4237500' WHERE kode_barcode='00040270' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7822000',harga_beli ='7822000' WHERE kode_barcode='00040271' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='26735500',harga_beli ='26735500' WHERE kode_barcode='00040273' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5428500',harga_beli ='5428500' WHERE kode_barcode='00040274' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5218500',harga_beli ='5218500' WHERE kode_barcode='00040370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4063500',harga_beli ='4063500' WHERE kode_barcode='00040372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3754000',harga_beli ='3754000' WHERE kode_barcode='00040373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9877500',harga_beli ='9877500' WHERE kode_barcode='00040608' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4290500',harga_beli ='4290500' WHERE kode_barcode='00041059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5569000',harga_beli ='5569000' WHERE kode_barcode='00041060' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5156500',harga_beli ='5156500' WHERE kode_barcode='00041062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='27335000',harga_beli ='27335000' WHERE kode_barcode='00041134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4816000',harga_beli ='4816000' WHERE kode_barcode='00041206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12061000',harga_beli ='12061000' WHERE kode_barcode='00041207' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6023000',harga_beli ='6023000' WHERE kode_barcode='00041208' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18096000',harga_beli ='18096000' WHERE kode_barcode='00041211' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15804000',harga_beli ='15804000' WHERE kode_barcode='00041212' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='15328500',harga_beli ='15328500' WHERE kode_barcode='00041213' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8141000',harga_beli ='8141000' WHERE kode_barcode='00041214' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041363' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041367' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041368' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041369' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00041372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2982000',harga_beli ='2982000' WHERE kode_barcode='00041408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5280500',harga_beli ='5280500' WHERE kode_barcode='00041574' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6002500',harga_beli ='6002500' WHERE kode_barcode='00041575' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6373500',harga_beli ='6373500' WHERE kode_barcode='00041576' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4363000',harga_beli ='4363000' WHERE kode_barcode='00041869' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2755500',harga_beli ='2755500' WHERE kode_barcode='00041870' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2254500',harga_beli ='2254500' WHERE kode_barcode='00041871' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1753500',harga_beli ='1753500' WHERE kode_barcode='00041902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8808500',harga_beli ='8808500' WHERE kode_barcode='00041903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8998500',harga_beli ='8998500' WHERE kode_barcode='00041905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='22115500',harga_beli ='22115500' WHERE kode_barcode='00041906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12357000',harga_beli ='12357000' WHERE kode_barcode='00041907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='31135000',harga_beli ='31135000' WHERE kode_barcode='00041908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='11892000',harga_beli ='11892000' WHERE kode_barcode='00041909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9125000',harga_beli ='9125000' WHERE kode_barcode='00041910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5766500',harga_beli ='5766500' WHERE kode_barcode='00041911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9653500',harga_beli ='9653500' WHERE kode_barcode='00041912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4499500',harga_beli ='4499500' WHERE kode_barcode='00041913' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4499500',harga_beli ='4499500' WHERE kode_barcode='00041914' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4710500',harga_beli ='4710500' WHERE kode_barcode='00041916' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2197000',harga_beli ='2197000' WHERE kode_barcode='00041917' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4647000',harga_beli ='4647000' WHERE kode_barcode='00041918' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4021500',harga_beli ='4021500' WHERE kode_barcode='00041919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3978500',harga_beli ='3978500' WHERE kode_barcode='00041920' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6702500',harga_beli ='6702500' WHERE kode_barcode='00041923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3481000',harga_beli ='3481000' WHERE kode_barcode='00041924' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3481000',harga_beli ='3481000' WHERE kode_barcode='00041925' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3966500',harga_beli ='3966500' WHERE kode_barcode='00041929' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2943500',harga_beli ='2943500' WHERE kode_barcode='00041930' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='00041931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3027000',harga_beli ='3027000' WHERE kode_barcode='00041932' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2881000',harga_beli ='2881000' WHERE kode_barcode='00041933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2943500',harga_beli ='2943500' WHERE kode_barcode='00041934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='00041935' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2108500',harga_beli ='2108500' WHERE kode_barcode='00041937' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2192000',harga_beli ='2192000' WHERE kode_barcode='00041938' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3736500',harga_beli ='3736500' WHERE kode_barcode='00041939' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3736500',harga_beli ='3736500' WHERE kode_barcode='00041940' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3507000',harga_beli ='3507000' WHERE kode_barcode='00041943' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8245500',harga_beli ='8245500' WHERE kode_barcode='00041944' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='9936500',harga_beli ='9936500' WHERE kode_barcode='00041945' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3337500',harga_beli ='3337500' WHERE kode_barcode='00041946' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2809500',harga_beli ='2809500' WHERE kode_barcode='00041947' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2492500',harga_beli ='2492500' WHERE kode_barcode='00041948' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3591000',harga_beli ='3591000' WHERE kode_barcode='00041949' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8069000',harga_beli ='8069000' WHERE kode_barcode='00041950' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6632500',harga_beli ='6632500' WHERE kode_barcode='00041953' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6527000',harga_beli ='6527000' WHERE kode_barcode='00041954' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2366000',harga_beli ='2366000' WHERE kode_barcode='00041955' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2218000',harga_beli ='2218000' WHERE kode_barcode='00041956' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2345000',harga_beli ='2345000' WHERE kode_barcode='00041957' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4457000',harga_beli ='4457000' WHERE kode_barcode='00041959' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4330500',harga_beli ='4330500' WHERE kode_barcode='00041960' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00041961' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6358000',harga_beli ='6358000' WHERE kode_barcode='00041962' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3126500',harga_beli ='3126500' WHERE kode_barcode='00041963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3443000',harga_beli ='3443000' WHERE kode_barcode='00041964' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2640500',harga_beli ='2640500' WHERE kode_barcode='00041965' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3211000',harga_beli ='3211000' WHERE kode_barcode='00041967' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3253000',harga_beli ='3253000' WHERE kode_barcode='00041968' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5597500',harga_beli ='5597500' WHERE kode_barcode='00041969' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='00041970' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2619500',harga_beli ='2619500' WHERE kode_barcode='00041971' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2598500',harga_beli ='2598500' WHERE kode_barcode='00041973' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1711000',harga_beli ='1711000' WHERE kode_barcode='00041974' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3084000',harga_beli ='3084000' WHERE kode_barcode='00041976' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7477500',harga_beli ='7477500' WHERE kode_barcode='00041977' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3211000',harga_beli ='3211000' WHERE kode_barcode='00041978' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2640500',harga_beli ='2640500' WHERE kode_barcode='00041979' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7097500',harga_beli ='7097500' WHERE kode_barcode='00041980' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='6104500',harga_beli ='6104500' WHERE kode_barcode='00041981' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='12124500',harga_beli ='12124500' WHERE kode_barcode='00041982' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='20996000',harga_beli ='20996000' WHERE kode_barcode='00041983' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='17954500',harga_beli ='17954500' WHERE kode_barcode='00041984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='7351000',harga_beli ='7351000' WHERE kode_barcode='00041985' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00041986' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='16898000',harga_beli ='16898000' WHERE kode_barcode='00041988' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13307500',harga_beli ='13307500' WHERE kode_barcode='00041989' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13624500',harga_beli ='13624500' WHERE kode_barcode='00041990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='18081000',harga_beli ='18081000' WHERE kode_barcode='00041991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2007000',harga_beli ='2007000' WHERE kode_barcode='00041992' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13916500',harga_beli ='13916500' WHERE kode_barcode='00042536' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13916500',harga_beli ='13916500' WHERE kode_barcode='00042537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13916500',harga_beli ='13916500' WHERE kode_barcode='00042538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13916500',harga_beli ='13916500' WHERE kode_barcode='00042539' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2672000',harga_beli ='2672000' WHERE kode_barcode='00042780' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3116500',harga_beli ='3116500' WHERE kode_barcode='00042781' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5571500',harga_beli ='5571500' WHERE kode_barcode='00042782' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='27832500',harga_beli ='27832500' WHERE kode_barcode='00042863' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1454000',harga_beli ='1454000' WHERE kode_barcode='00042931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1476500',harga_beli ='1476500' WHERE kode_barcode='00042932' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1264000',harga_beli ='1264000' WHERE kode_barcode='00042933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1744500',harga_beli ='1744500' WHERE kode_barcode='00042934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1387000',harga_beli ='1387000' WHERE kode_barcode='00042935' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2158500',harga_beli ='2158500' WHERE kode_barcode='00042953' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1510000',harga_beli ='1510000' WHERE kode_barcode='00042954' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1454000',harga_beli ='1454000' WHERE kode_barcode='00042955' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1677500',harga_beli ='1677500' WHERE kode_barcode='00042956' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1733500',harga_beli ='1733500' WHERE kode_barcode='00042957' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3106500',harga_beli ='3106500' WHERE kode_barcode='00042989' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3106500',harga_beli ='3106500' WHERE kode_barcode='00042990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='3106500',harga_beli ='3106500' WHERE kode_barcode='00042991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5964000',harga_beli ='5964000' WHERE kode_barcode='00042997' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5964000',harga_beli ='5964000' WHERE kode_barcode='00042999' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5964000',harga_beli ='5964000' WHERE kode_barcode='00043000' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5964000',harga_beli ='5964000' WHERE kode_barcode='00043001' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00043007' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00043008' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00043009' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00043010' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='8946000',harga_beli ='8946000' WHERE kode_barcode='00043011' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1342000',harga_beli ='1342000' WHERE kode_barcode='00043114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1935000',harga_beli ='1935000' WHERE kode_barcode='00043115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1666500',harga_beli ='1666500' WHERE kode_barcode='00043116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1521000',harga_beli ='1521000' WHERE kode_barcode='00043117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1510000',harga_beli ='1510000' WHERE kode_barcode='00043118' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1420500',harga_beli ='1420500' WHERE kode_barcode='00043120' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='2013000',harga_beli ='2013000' WHERE kode_barcode='00043121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1700000',harga_beli ='1700000' WHERE kode_barcode='00043122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1543500',harga_beli ='1543500' WHERE kode_barcode='00043123' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1510000',harga_beli ='1510000' WHERE kode_barcode='00043124' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1353500',harga_beli ='1353500' WHERE kode_barcode='00043126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1677500',harga_beli ='1677500' WHERE kode_barcode='00043127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1655500',harga_beli ='1655500' WHERE kode_barcode='00043128' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1566000',harga_beli ='1566000' WHERE kode_barcode='00043129' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='1554500',harga_beli ='1554500' WHERE kode_barcode='00043130' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='4533000',harga_beli ='4533000' WHERE kode_barcode='00043566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='13667500',harga_beli ='13667500' WHERE kode_barcode='00043600' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2485000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00043628' LIMIT 1; UPDATE tm_group SET harga='2485000' WHERE kode_group = 'GOLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2485000','kasir','2026-06-08 13:35:37'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','14:13:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','14:18:28'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0005','kasirbip','1',' DP-02167DU','TOKO','DUPSN','PSPLT-ZEBE-26-0','CINCIN PALADIUM ','','1.660','1','17.00','373000','0','0','18100','1638000','0','0','0','1638000','KUR','00043787','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPLT-ZEBE-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0005','2026-06-08','1.660','2026-06-08','14:32:12','PLG0011931','1638000','1638000','0','1638000','0','kasirbip','2026-06-08 14:32:12','FJ-260608-0005','DP-02167','1390000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0005','2026-06-08','14:32:12','KUR','1638000','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-260608-0006','2026-06-08','2026-06-08 14:32:12','PENJUALAN : FJ-260608-0005','.','TBC','248000','248000','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-260608-0007','D','2026-06-08','14:32:12','TBC','PENJUALAN','FJ-260608-0005','23523376514','248000','23523624514','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='248000' WHERE no_faktur_jual='FJ-260608-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0005'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02432','DIL','1','GOLD','WEDD RING','','','2.500','','75.00','1','2485000','2300000','0','700000','6450000','PERMATA 1 BUTIR','SIZE 11 GRF : Azhari ?? (VINTAGE)','PUTIH (EMAS PUTIH)','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0007','2026-06-08','2026-06-08 14:37:20','PESANAN : DP-02432','-','TBC','4500000','4500000'); 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-260608-0008','D','2026-06-08','14:37:20','TBC','PESANAN','DP-02432','23523624514','4500000','23528124514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02432','2026-06-08','2026-06-08','14:37:20','PLG0011932','DIL','2026-06-10','sby','2026-06-08 14:37:20','2.500','0','0','0','4500000','0','700000','6460000','6460000','1960000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02433','DIL','1','GOLD','WEDD RING','','','3.000','','75.00','1','2485000','2300000','0','900000','7800000','PERMATA 11 BUTIR','SIZE 9 GRF: Fredi (VINTAGE)','PUTIH (EMAS PUTIH)','110000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0008','2026-06-08','2026-06-08 14:41:33','PESANAN : DP-02433','-','TBC','5500000','5500000'); 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-260608-0009','D','2026-06-08','14:41:33','TBC','PESANAN','DP-02433','23528124514','5500000','23533624514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02433','2026-06-08','2026-06-08','14:41:33','PLG0011933','DIL','2026-06-14','sby','2026-06-08 14:41:33','3.000','0','0','0','5500000','0','900000','7910000','7910000','2410000'); INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02401'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02401'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02401'; 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-260608-0003','K','2026-06-08','14:52:12','sby','PESANAN BATAL','DP-02401','35544200','0','35544200'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-06-08 ','15:39:24'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','15:55:24'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','15:59:45'); 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-20260608-0001','1','PSPLT-ZFXD-48-0','1','4.920','4.920','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXD-48-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXD-48-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-08 16:02:25' WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXD-48-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-06-08 16:02:25','TOKO','SBYPSN','PSPLT','PSPLT-ZFXD-48-0','1','4.920','4.920','1','4.920','4.920','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXD-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXD-48-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-08' 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-20260608-0001','1','PSPLT-ZFXE-22-0','1','3.680','3.680','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZFXE-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXE-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZFXE-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFXE-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-06-08 16:02:26' WHERE kode_barang='PSPLT-ZFXE-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZFXE-22-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-06-08 16:02:26','TOKO','SBYPSN','PSPLT','PSPLT-ZFXE-22-0','1','3.680','3.680','1','3.680','3.680','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZFXE-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFXE-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-06-08' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260608-0001','2026-06-08','16:00','8.600','sby','2026-06-08 16:02:25'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-08 ','16:04:26'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0006','sby','1',' DP-02251SB','TOKO','SBYPSN','PSPLT-ZFXD-48-0','CINCIN PALADIUM ','','4.920','1','17.00','1105000','0','0','18100','2482000','0','0','0','2482000','VAN','00043990','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFXD-48-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.920',berat_jual_asli=berat_jual_asli+'4.920',stock_jual='1',berat_akhir=berat_akhir-'4.920',berat_akhir_asli=berat_akhir_asli-'4.920',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPLT-ZFXD-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0006','2026-06-08','4.920','2026-06-08','16:06:22','PLG0011934','2482000','2482000','0','2482000','0','sby','2026-06-08 16:06:22','FJ-260608-0006','DP-02251','1700000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0006','2026-06-08','16:06:22','VAN','2482000','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-260608-0009','2026-06-08','2026-06-08 16:06:22','PENJUALAN : FJ-260608-0006','','TBC','782000','782000','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-260608-0010','D','2026-06-08','16:06:22','TBC','PENJUALAN','FJ-260608-0006','23533624514','782000','23534406514','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='782000' WHERE no_faktur_jual='FJ-260608-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0006'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0007','sby','1',' DP-02259SB','TOKO','SBYPSN','PSGT-ZEBI-53-0','CINCIN EMAS ','','4.120','1','57.00','5870000','0','0','18100','9230000','0','0','0','9230000','DIL','00043879','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBI-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.120',berat_jual_asli=berat_jual_asli+'4.120',stock_jual='1',berat_akhir=berat_akhir-'4.120',berat_akhir_asli=berat_akhir_asli-'4.120',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSGT-ZEBI-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0007','2026-06-08','4.120','2026-06-08','16:19:35','PLG0011935','9230000','9230000','0','9230000','0','sby','2026-06-08 16:19:34','FJ-260608-0007','DP-02259','6200000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0007','2026-06-08','16:19:35','DIL','9230000','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-260608-0010','2026-06-08','2026-06-08 16:19:34','PENJUALAN : FJ-260608-0007','','TBC','3030000','3030000','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-260608-0011','D','2026-06-08','16:19:35','TBC','PENJUALAN','FJ-260608-0007','23534406514','3030000','23537436514','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='3030000' WHERE no_faktur_jual='FJ-260608-0007' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02434','VAN','1','GOLD','WEDD RING','','','2.500','','37.50','1','2485000','1500000','0','800000','4550000','PERMATA 10 BUTIR','SIZE 14 GRF : Anggara M.S (vladimir)','crom putih','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0011','2026-06-08','2026-06-08 17:04:10','PESANAN : DP-02434','-','TBC','3200000','3200000'); 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-260608-0012','D','2026-06-08','17:04:10','TBC','PESANAN','DP-02434','23537436514','3200000','23540636514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02434','2026-06-08','2026-06-08','17:04:10','PLG0011936','VAN','2026-06-13','sby','2026-06-08 17:04:10','2.500','0','0','0','3200000','0','800000','4650000','4650000','1450000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02435','PUT','1','PLD','WEDD RING','','','2.500','','25.00','1','1200000','550000','0','1000000','2375000','sirkon 32','sz 15.5 crom putih gllosy','grf Rivana 09.08.26','320000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0012','2026-06-08','2026-06-08 17:08:08','PESANAN : DP-02435','.','TBC','2050000','2050000'); 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-260608-0013','D','2026-06-08','17:08:08','TBC','PESANAN','DP-02435','23540636514','2050000','23542686514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02435','2026-06-08','2026-06-08','17:08:08','PLG0011937','PUT','2026-07-02','kasirbip','2026-06-08 17:08:08','2.500','0','0','0','2050000','0','1000000','2695000','2695000','645000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02436','PUT','1','PLD','WED RING','','','3.000','','25.00','1','1200000','550000','0','750000','2400000','sz 15 sama kan sprti cntoh lebar 5/6 mm','grf Rivana 09.08.26','font Berkshire','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0013','2026-06-08','2026-06-08 17:12:50','PESANAN : DP-02436','.','TBC','2050000','2050000'); 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-260608-0014','D','2026-06-08','17:12:50','TBC','PESANAN','DP-02436','23542686514','2050000','23544736514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02436','2026-06-08','2026-06-08','17:12:50','PLG0011938','PUT','2026-07-02','kasirbip','2026-06-08 17:12:50','3.000','0','0','0','2050000','0','750000','2400000','2400000','350000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02437','VAN','1','GOLD','WEDD RING','','','3.000','','37.50','1','2485000','1500000','0','800000','5300000','PERMATA 1 BUTIR','SIZE 14.5 GRF: Novi ?? Eric (vintage)','putih','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0014','2026-06-08','2026-06-08 17:14:58','PESANAN : DP-02437','-','TBC','3700000','3700000'); 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-260608-0015','D','2026-06-08','17:14:58','TBC','PESANAN','DP-02437','23544736514','3700000','23548436514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02437','2026-06-08','2026-06-08','17:14:58','PLG0011939','VAN','2026-06-17','sby','2026-06-08 17:14:58','3.000','0','0','0','3700000','0','800000','5310000','5310000','1610000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','17:15:32'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-08 ','17:16:17'); UPDATE tt_service_head SET tgl_selesai='2026-06-08', status ='DONE' WHERE no_service='SV-02104'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02104'; 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-06-08', status ='CLOS' WHERE no_service='SV-02104'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02104'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02438','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2485000','1500000','0','800000','4550000','PERMATA 3 BUTIR','SIZE 10.5 GRF: Galang (love full) (vintage)','putih (emas putih)','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0015','2026-06-08','2026-06-08 17:18:43','PESANAN : DP-02438','-','TBC','3200000','3200000'); 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-260608-0016','D','2026-06-08','17:18:43','TBC','PESANAN','DP-02438','23548436514','3200000','23551636514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02438','2026-06-08','2026-06-08','17:18:43','PLG0011940','DIL','2026-06-20','sby','2026-06-08 17:18:43','2.500','0','0','0','3200000','0','800000','4580000','4580000','1380000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02439','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2485000','1500000','0','800000','4550000','PERMATA 3 BUTIR','SIZE 10.5 GRF: Galang (love full) (vintage)','putih (emas putih)','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0016','2026-06-08','2026-06-08 17:18:50','PESANAN : DP-02439','-','TBC','3200000','3200000'); 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-260608-0017','D','2026-06-08','17:18:50','TBC','PESANAN','DP-02439','23551636514','3200000','23554836514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02439','2026-06-08','2026-06-08','17:18:50','PLG0011941','DIL','2026-06-20','sby','2026-06-08 17:18:50','2.500','0','0','0','3200000','0','800000','4580000','4580000','1380000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02440','KUR','1','PER','CINCIN KAWIN PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','size cowo 17 putih dof amplas keliling grf Viona yl01','size cewe 12 putih dof semprot grf Surya SR 03','font vintage rotter','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0017','2026-06-08','2026-06-08 17:27:57','PESANAN : DP-02440','.','TBC','950000','950000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0018','D','2026-06-08','17:27:57','TBC','PESANAN','DP-02440','23554836514','950000','23555786514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02440','2026-06-08','2026-06-08','17:27:57','PLG0011942','KUR','2026-06-29','kasirbip','2026-06-08 17:27:57','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0008','kasir','1',' 700K-13-00','TOKO','MMPER','PBSD-YGBH-14-0','CINCIN SILVER 925 ','','2.250','1','100.00','46000','0','0','18100','800000','0','0','0','800000','ALIKA','00037596','PBSD','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBH-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PBSD-YGBH-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0008','2026-06-08','2.250','2026-06-08','17:30:30','PLG0011943','800000','800000','0','800000','0','kasir','2026-06-08 17:30:29','FJ-260608-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0008','2026-06-08','17:30:30','ALIKA','800000','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-260608-0018','2026-06-08','2026-06-08 17:30:29','PENJUALAN : FJ-260608-0008','0','TBC','800000','800000','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-260608-0019','D','2026-06-08','17:30:30','TBC','PENJUALAN','FJ-260608-0008','23555786514','800000','23556586514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260608-0008' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0009','kasir',' 1',' 950K-13-96','TOKO','MMPER','PMM-ZDBI-51-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','18100','1050000','0','0','0','1050000','ALIKA','00042949','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDBI-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PMM-ZDBI-51-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0009','2026-06-08','1.940','2026-06-08','17:30:30','PLG0011944','1050000','1050000','0','1050000','0','kasir','2026-06-08 17:30:29','FJ-260608-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0009','2026-06-08','17:30:30','ALIKA','1050000','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-260608-0019','2026-06-08','2026-06-08 17:30:29','PENJUALAN : FJ-260608-0009','0','TBC','1050000','1050000','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-260608-0020','D','2026-06-08','17:30:30','TBC','PENJUALAN','FJ-260608-0009','23556586514','1050000','23557636514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-260608-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0010','kasir','1',' DP-02263T ','TOKO','TFPSN','PSPRT-ZFXE-3-0','CINCIN PERAK SR-01 YL-01 ','','3.110','1','100.00','318000','0','0','18100','950000','0','0','0','950000','FIR','00043993','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXE-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPRT-ZFXE-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0010','2026-06-08','3.110','2026-06-08','18:27:02','PLG0011945','950000','950000','0','950000','0','kasir','2026-06-08 18:27:01','FJ-260608-0010','DP-02263','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0010','2026-06-08','18:27:02','FIR','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260608-0010' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0011','kasirbip','1',' DP-02183BI','TOKO','BIPPSN','PSPRT-ZFXE-8-0','CINCIN PERAK ','','1.460','1','100.00','149000','0','0','18100','850000','0','0','0','850000','SULIS','00043998','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXE-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPRT-ZFXE-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0011','2026-06-08','1.460','2026-06-08','19:15:00','PLG0011946','850000','850000','0','850000','0','kasirbip','2026-06-08 19:14:59','FJ-260608-0011','DP-02183','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0011','2026-06-08','19:15:00','SULIS','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260608-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0012','kasirbip',' 1',' DP-02184BI','TOKO','BIPPSN','PSPRT-ZFXC-2-0','CINCIN PERAK YL-10 ','','5.090','1','100.00','520000','0','0','18100','900000','0','0','0','900000','SULIS','00043936','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXC-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.090',berat_jual_asli=berat_jual_asli+'5.090',stock_jual='1',berat_akhir=berat_akhir-'5.090',berat_akhir_asli=berat_akhir_asli-'5.090',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PSPRT-ZFXC-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0012','2026-06-08','5.090','2026-06-08','19:15:00','PLG0011947','900000','900000','0','900000','0','kasirbip','2026-06-08 19:14:59','FJ-260608-0011','DP-02184','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-08','FJ-260608-0012','2026-06-08','19:15:00','SULIS','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260608-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0012'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02441','DIL','1','PLD','WEDD RING CUSTOM','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','SIZE 19.5 GRF : Zara (infinity) 30.09.26 (yaseva)','crom putih doff mix hitam glossy','untuk ukir nama depan font algerian','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0020','2026-06-08','2026-06-08 19:30:21','PESANAN : DP-02441','-','TBC','2100000','2100000'); 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-260608-0021','D','2026-06-08','19:30:21','TBC','PESANAN','DP-02441','23557636514','2100000','23559736514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02441','2026-06-08','2026-06-08','19:30:21','PLG0011948','DIL','2026-07-08','sby','2026-06-08 19:30:21','4.000','0','0','0','2100000','0','800000','3000000','3000000','900000'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02123','SULIS','1','SEPASANG SILVER','CWE SZ 14 PUTIH GLOSY CWP SZ 18 5 PUTIH DOFF AMPLASS FONT VINTAGE ROTTER','4.500','1','100000','100000'); 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-260608-0021','2026-06-08','2026-06-08 19:38:23','SERVICE : SV-02123','.','TBC','100000','100000','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-260608-0022','D','2026-06-08','19:38:23','TBC','SERVICE','SV-02123','23559736514','100000','23559836514','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-02123','2026-06-08','2026-06-08','19:38:23','PLG0011949','kasirbip','2026-06-05','kasirbip','2026-06-08 19:38:23','4.500','0','0','0','100000','0','100000','100000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-08 ','19:38:37'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02442','DIL','1','PLD','WEDD RING CUSTOM','','','4.000','','25.00','1','1200000','550000','0','950000','3150000','PERMATA 14 BUTIR','SIZE 19 GRF: Tian (infinity) 30.09.26 (yaseva)','putih glossy mix hitam glossy (detail wa)','140000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260608-0022','2026-06-08','2026-06-08 19:38:58','PESANAN : DP-02442','-','TBC','2300000','2300000'); 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-260608-0023','D','2026-06-08','19:38:58','TBC','PESANAN','DP-02442','23559836514','2300000','23562136514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02442','2026-06-08','2026-06-08','19:38:58','PLG0011950','DIL','2026-07-08','sby','2026-06-08 19:38:58','4.000','0','0','0','2300000','0','950000','3290000','3290000','990000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0013','kasirbip','1',' 1.4K-13-00','TOKO','BIPPER','LXPER-ZBBD-34-0','CINCIN SILVER 925 ','','3.550','1','100.00','363000','0','0','18100','1500000','0','0','0','1500000','SULIS','00041780','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='LXPER-ZBBD-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0013','2026-06-08','3.550','2026-06-08','19:40:52','PLG0011951','1500000','1500000','0','1500000','0','kasirbip','2026-06-08 19:40:52','FJ-260608-0013','','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-06-08','FJ-260608-0013','2026-06-08','19:40:52','SULIS','1500000','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-260608-0023','2026-06-08','2026-06-08 19:40:52','PENJUALAN : FJ-260608-0013','.','TBC','1500000','1500000','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-260608-0024','D','2026-06-08','19:40:52','TBC','PENJUALAN','FJ-260608-0013','23562136514','1500000','23563636514','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='1500000' WHERE no_faktur_jual='FJ-260608-0013' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260608-0014','kasirbip',' 1',' 750K-18-24','TOKO','BIPPER','PBDG-ZDAC-5-0','CINCIN SILVER 925 ','','2.090','1','100.00','214000','0','0','18100','900000','0','0','0','900000','SULIS','00042472','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAC-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='PBDG-ZDAC-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260608-0014','2026-06-08','2.090','2026-06-08','19:40:52','PLG0011952','900000','900000','0','900000','0','kasirbip','2026-06-08 19:40:52','FJ-260608-0013','','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-06-08','FJ-260608-0014','2026-06-08','19:40:52','SULIS','900000','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-260608-0024','2026-06-08','2026-06-08 19:40:52','PENJUALAN : FJ-260608-0014','.','TBC','900000','900000','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-260608-0025','D','2026-06-08','19:40:52','TBC','PENJUALAN','FJ-260608-0014','23563636514','900000','23564536514','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='2400000' WHERE no_faktur_jual='FJ-260608-0014' LIMIT 1; INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02439'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02439'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02439'; 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-260608-0004','K','2026-06-08','19:55:40','sby','PESANAN BATAL','DP-02439','35544200','0','35544200'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260608-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260608-0014';