########## AP PAYMENTS ########## tmp = ActiveRecord::Base.connection.select_all "SELECT DISTINCT app.accounting_date, app.voucher_number, app.status, app. [source], app.payment_amount AS amount FROM ap_payments app LEFT JOIN gl_transactions glt ON glt.object_type = 'ApPayment' AND glt.voucher_number = app.voucher_number WHERE glt.id IS NULL AND app.status in('Paid', 'Voided')" vouchers = tmp.map {|a| a["voucher_number"]}.uniq paid_records = [] records = ApPayment.where(voucher_number: vouchers) records.each do |r| paid_records << r.id if r.status == "Paid" r.update_attributes status: "Approved" VoucherPostState.where(voucher_number: r.voucher_number).delete_all ApPaymentGlPoster.new.post(r.voucher_number, true) end;nil ApPayment.where(id: paid_records).update_all status: "Paid"