########## JOURNAL ENTRIES ########## ActiveRecord::Base.connection.execute "SELECT DISTINCT voucher_number INTO #glt_vouchers FROM gl_transactions WHERE object_type = 'JournalEntry'" tmp = ActiveRecord::Base.connection.select_all "SELECT DISTINCT je.accounting_date, je.voucher_number, je.status, je.[source], count(gld.id) AS gld_count, sum(gld.amount) AS amount FROM journal_entries je JOIN gl_distributions gld ON gld.object_id = je.id AND gld.object_type = 'JournalEntry' LEFT JOIN #glt_vouchers gv on gv.voucher_number = je.voucher_number WHERE gv.voucher_number IS NULL AND je.status in('Posted') GROUP BY je.accounting_date, je.voucher_number, je.status, je.[source]" vouchers = tmp.map {|a| a["voucher_number"]}.uniq records = JournalEntry.where(voucher_number: vouchers) records.each do |r| r.update_attributes status: "Approved" VoucherPostState.where(voucher_number: r.voucher_number).delete_all JournalEntryGlPoster.new.post(r.voucher_number, true) end;nil ActiveRecord::Base.connection.execute "DROP TABLE #glt_vouchers"