Class: LedgerEntriesController

Inherits:

CrmController

Object
ActionController::Base
ApplicationController
CrmController
LedgerEntriesController

show all

Defined in:: app/controllers/ledger_entries_controller.rb

Overview

== Schema Information

Table name: ledger_entries

id :integer not null, primary key
ledger_transaction_id :integer not null
ledger_company_account_id :integer not null
currency :string(3) not null
description :string(255)
creator_id :integer
updater_id :integer
created_at :datetime
updated_at :datetime
ledger_detail_project_id :integer
amount :decimal(12, 2)
company_exchange_rate :float
company_amount :decimal(12, 2)
consolidated_exchange_rate :float
consolidated_amount :decimal(12, 2)
business_unit_id :integer
reconciled :boolean default(FALSE)
reconciled_by_id :integer
reconciled_at :datetime
bank_date :date

Constant Summary

Constants included from Www::SeoHelper

Constants included from IconHelper

IconHelper::CUSTOM_ICON_MAP, IconHelper::CUSTOM_SVG_DIR, IconHelper::DEFAULT_FAMILY

Methods inherited from CrmController

#access_denied, #context_id, #context_object, #crm_home_path, #current_ability, #default_url_options, #download_temp, #get_tempfile_path_for_download, #initialize_crm_lazy_chunks, #record_not_found, #redirect_to_job_or_fallback, #render_edit_action, #set_context, #set_download_path, #stash_file_for_temp_download

Methods inherited from ApplicationController

#account_impersonated?, #add_to_flash, #append_token, #bypass_forgery_protection?, #chat_enabled?, #cloudflare_cleared?, #default_catalog, #default_url_options, #enable_turbo_frames, #find_publication, #fix_invalid_accept_header, #init_js_utils, #is_globals_call?, #layout_by_resource, #locale_store, #redirect_to, #require_employee_for_crm, #set_base_host, #set_real_ip, #set_report_errors_for, #should_render_layout?, #stamp_impersonation_context, #warmlyyours_canada_ip?, #warmlyyours_ip?, #y

Methods included from Controllers::ReturnPathHandling

#check_for_return_path, #redirect_to_return_path_or_default

Methods included from Controllers::AnalyticsEvents

#consume_queued_analytics_events, #track_event

Methods included from Controllers::DeviceDetection

#device_detector, #is_ie?

Methods included from Controllers::SubdomainDetection

#is_crm_request?, #is_www_request?, #json_request?

Methods included from Controllers::TrackingDetection

#bot_request?, #gdpr_country?, #gdpr_country_data, #prevent_bots, #set_tracking_cookie, #track_visitor?

Methods included from Controllers::AcceleratedFileSending

#send_file_accelerated, #send_upload_accelerated

Methods included from Controllers::ErrorRendering

#excp_string, #mail_to_for_error_reporting, #render_400, #render_404, #render_406, #render_410, #render_500, #render_invalid_authenticity_token, #render_ip_spoof_error, #safe_referer_or_fallback

Methods included from Controllers::TurnstileVerification

#load_turnstile_script_tag, #turnstile_lazy_widget, #turnstile_script_tag, #turnstile_widget, #validate_turnstile!

Methods included from Controllers::CloudflareCaching

edge_cached, #edge_cached_action?, #reset_cloudflare_cache, #set_cloudflare_cache, #skip_session

Methods included from Controllers::Webpackable

#preload_webpack_fonts, #webpack_css_include, #webpack_css_url, #webpack_js_include, #wpd_is_running?

Methods included from Controllers::Localizable

#cloudflare_country_locale, #determine_request_locale, #geocoder_locale, #guest_user_locale_check, #locale_optional_www_auth_path?, #param_locale, #set_locale, #set_request_locale, #skip_localization?, #warmlyyours_ip_locale

Methods included from Controllers::Authenticable

#access_denied, #authenticate_account, #authenticate_account!, #authenticate_account_from_login_token!, #authenticate_account_from_token!, #check_is_a_manager, #check_is_a_sales_manager, #check_is_an_admin, #check_is_an_employee, #check_party, #clear_mismatched_guest_user, #create_guest_user, #credentials?, #current_or_guest_user, #current_or_guest_user_id_read_only, #current_user, #devise_mapping, #fully_logged_in?, #generate_bot_id, #guest_user, #identifiable?, #init_current_user, #initialize_guest, #load_context_user, #logging_in, #resource, #resource_name, #restrict_access_for_non_employees, #scrubbed_request_path, #user_object, #warn_on_session_guest_id_leak

Methods included from ApplicationHelper

#better_number_to_currency, #check_force_logout, #check_or_cross, #check_or_times, #error_messages, #general_disclaimer_on_product_installation_and_local_codes, #gridjs_from_html_table, #gridjs_table, #is_wy_ip, #line_break, #parent_layout, #pass_or_fail, #render_error_messages_list, #render_video_card, #resolved_auth_form_turbo_frame, #return_path_or, #safe_css_color, #set_return_path_if_present, #set_section_if_present, #tab_frame_id, #to_underscore, #track_page?, #turbo_section_wrapper, #turbo_tabs_request?, #url_on_same_domain_as_request, #widget_index_daily_focus_index_path, #working_hours?, #yes_or_no, #yes_or_no_highlighted, #yes_or_no_with_check_or_cross, #youtube_video

Methods included from UppyUploaderHelper

#file_uploader, #image_uploader, #large_file_uploader_s3, #lead_sketch_uploader, #rma_image_uploader, #rma_image_uploader_s3, #uppy_uploader, #video_uploader

Methods included from Www::ImagesHelper

#image_asset_tag, #image_asset_url

Methods included from Www::SeoHelper

#add_page_schema, #canada?, #company_social_links, #ensure_context_json, #json_ld_script_tag, #local_business_schema, #online_store_id, #online_store_schema, #page_main_entity, #page_main_entity_json, #render_auto_collection_page_schema, #render_collection_page_schema, #render_local_business_schema, #render_online_store_schema, #render_page_schemas, #render_page_video_schemas, #render_webpage_schema, #render_webpage_schema_with_collections, #usa?

Methods included from UrlsHelper

#catalog_breadcrumb_links, #catalog_link, #catalog_link_for_product_line, #catalog_link_for_sku, #cms_link, #delocalized_path, #path_to_sales_product_sku, #path_to_sales_product_sku_for_product_line, #path_to_sales_product_sku_for_product_line_slug, #product_line_from_catalog_link, #protocol_neutral_url, #sanitize_external_url, #valid_external_url?

Methods included from IconHelper

#account_nav_icon, #fa_icon, #star_rating_html

Instance Method Details

#do_po_reconcile ⇒ `Object`

# File 'app/controllers/ledger_entries_controller.rb', line 125

def do_po_reconcile
  reconciliation_date = params[:po_reconcile_save][:reconciliation_date].present? ? params[:po_reconcile_save][:reconciliation_date].to_date : Date.current
  materials_in_transit_le = params[:materials_in_transit_ledger_entries].to_h
  receipts_not_vouchered_le = params[:receipts_not_vouchered_ledger_entries].to_h
  mit_ids = materials_in_transit_le.map { |id, attrs| id.to_i if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq
  rnv_ids = receipts_not_vouchered_le.map { |id, attrs| id.to_i if attrs[:po_reconciled].to_i.positive? }.compact.uniq
  mit_company = materials_in_transit_le.map { |_id, attrs| attrs[:company_id] if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq
  rnv_company = receipts_not_vouchered_le.map { |_id, attrs| attrs[:company_id] if attrs[:po_reconciled].to_i.positive? }.compact.uniq

  if mit_company.count > 1 || rnv_company.count > 1 || (mit_company.present? && rnv_company.present? && mit_company != rnv_company)
    flash[:error] =
      '<p>The selected values are in different company account. Materials in transit and Recaipts not vouchered must be in the same company account.</p>'
    redirect_back_or_to root_path
    return
  end

  mit_selected = LedgerEntry.where(id: mit_ids)
  rnv_selected = LedgerEntry.where(id: rnv_ids)

  if params[:po_reconcile_save][:company_id].present?
    company_id = params[:po_reconcile_save][:company_id].to_i
  elsif mit_company.present? && rnv_company.present?
    company_id = (mit_company + rnv_company).uniq.first.to_i
  elsif mit_company.present? && rnv_company.empty?
    company_id = mit_company.uniq.first.to_i
  elsif mit_company.empty? && rnv_company.present?
    company_id = rnv_company.uniq.first.to_i
  end
  # tr_company = rnv_ids.present? ? receipts_not_vouchered_le.map{ |id,attrs| attrs[:company_id].to_i if attrs[:po_reconciled].to_i.positive? }.compact.uniq.first : materials_in_transit_le.map{ |id,attrs| attrs[:company_id].to_i if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq.first
  # tr_currency = rnv_ids.present? ? receipts_not_vouchered_le.map{ |id,attrs| attrs[:currency] if attrs[:po_reconciled].to_i.positive? }.compact.uniq.first : materials_in_transit_le.map{ |id,attrs| attrs[:currency] if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq.first
  tr_currency = Company.find(company_id).currency
  description = if mit_ids.present?
                  materials_in_transit_le.map do |_id, attrs|
                    attrs[:description] if attrs[:vcr_reconciled].to_i.positive?
                  end.compact.uniq.first
                else
                  receipts_not_vouchered_le.map do |_id, attrs|
                    attrs[:description] if attrs[:po_reconciled].to_i.positive?
                  end.compact.uniq.first
                end

  if mit_ids.present? || rnv_ids.present?
    if mit_ids.present?
      mit_total = mit_selected.map(&:company_amount).sum
      bu = mit_selected.map(&:business_unit_id).compact.uniq.first.nil? ? BusinessUnit.find_by(number: (company_id * 10_000)) : BusinessUnit.find(mit_selected.map(&:business_unit_id).compact.uniq.first)
    else
      mit_total = 0
    end

    if rnv_ids.present?
      rnv_total = rnv_selected.map(&:company_amount).sum
      bu = rnv_selected.map(&:business_unit_id).compact.uniq.first.nil? ? BusinessUnit.find_by(number: (company_id * 10_000)) : BusinessUnit.find(rnv_selected.map(&:business_unit_id).compact.uniq.first)
    else
      rnv_total = 0
    end

    balance = mit_total.abs - rnv_total.abs
    reconciled = mit_total.abs == rnv_total.abs
    lca_mit = LedgerCompanyAccount.where(company_id: company_id, ledger_detail_account_id: LedgerAccount.find_by(number: 1415).id).first
    lca_rnv = LedgerCompanyAccount.where(company_id: company_id, ledger_detail_account_id: LedgerAccount.find_by(number: 4120).id).first
    ledger_transaction = LedgerTransaction.new(company_id: company_id, transaction_type: 'JOURNAL_ENTRY', transaction_date: reconciliation_date,
                                               currency: tr_currency)
    ledger_transaction.ledger_entries << LedgerEntry.new(ledger_company_account: lca_rnv, amount: mit_total, business_unit: bu,
                                                         description: description, reconciled: reconciled)
    ledger_transaction.ledger_entries << LedgerEntry.new(ledger_company_account: lca_mit, amount: rnv_total, business_unit: bu,
                                                         description: description, reconciled: reconciled)

    if balance.zero? && mit_total.abs.positive? && rnv_total.abs.positive?
      ledger_transaction.save!
      mit_selected.update_all(reconciled: true)
      rnv_selected.update_all(reconciled: true)

      flash[:info] =
        "<p>Ledger Transaction <b>#{ledger_transaction.id}</b> was successfully created. Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) and Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    elsif mit_total.abs.zero? && rnv_total.abs.zero? && mit_selected.present? && rnv_selected.present?
      mit_selected.update_all(reconciled: true)
      rnv_selected.update_all(reconciled: true)

      flash[:info] =
        "<p>Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) and Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    elsif mit_total.abs.zero? && rnv_total.abs.zero? && (mit_selected.present? || rnv_selected.present?)
      if mit_selected.present?
        mit_selected.update_all(reconciled: true)
        notice_message = "<p>Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      elsif rnv_selected.present?
        rnv_selected.update_all(reconciled: true)
        notice_message = "<p>Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      end
      flash[:info] = notice_message
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    else
      flash[:error] = "<p>There is still a balance of #{number_to_currency(balance)} that has to be reviewed.</p>"
      company_criteria = params[:po_reconcile_save][:company_id]
      params[:po_reconcile_save][:company_id] = company_id.to_s
      redirect_to review_reconcile_ledger_transactions_path(company_criteria: company_criteria,
                                                            tr_currency: tr_currency,
                                                            bu_id: bu.id,
                                                            description: description,
                                                            rnv_total: -rnv_total,
                                                            mit_total: -mit_total,
                                                            balance: balance,
                                                            mit_ids: mit_ids,
                                                            rnv_ids: rnv_ids,
                                                            po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }))
    end
  else
    flash[:error] = '<p>You must select at least a record either from materials in transit or receipts not vouchered.</p>'
    redirect_back_or_to root_path
  end
end

#do_reconcile ⇒ `Object`

# File 'app/controllers/ledger_entries_controller.rb', line 63

def do_reconcile
  unless params[:ledger_entries].nil?
    params[:ledger_entries].each do |id, attrs|
      attrs[:reconciled] ||= '0'
      le = LedgerEntry.find(id)
      le.attributes = attrs
      if le.reconciled_changed? and le.reconciled?
        le.reconciled_by = @context_user
        le.reconciled_at = Time.current
        begin
          le.save!
        rescue StandardError => e
          flash[:error] = "Unable to save all ledger entries, message : #{e}"
        end
      elsif le.reconciled? and le.bank_date_changed?
        begin
          le.save!
        rescue StandardError => e
          flash[:error] = "Unable to save all ledger entries, message : #{e}"
        end
      elsif !le.reconciled?
        le.reconciled_by = nil
        le.reconciled_at = nil
        le.bank_date = nil
        begin
          le.save! if le.changed?
        rescue StandardError => e
          flash[:error] = "Unable to save all ledger entries, message : #{e}"
        end
      end
    end
  end
  redirect_back_or_to root_path
end

#index ⇒ `Object`



30
31

# File 'app/controllers/ledger_entries_controller.rb', line 30

def index
end

#po_reconcile ⇒ `Object`

# File 'app/controllers/ledger_entries_controller.rb', line 98

def po_reconcile
  init_params = {
    company_id: '1',
    mit_gl_date_gteq: Date.current.beginning_of_month,
    mit_gl_date_lteq: Date.current.end_of_month,
    rnv_gl_date_gteq: Date.current.beginning_of_month,
    rnv_gl_date_lteq: Date.current.end_of_month,
    po_number_ref: '',
    reconciled: 'false',
    reconciliation_date: Date.current
  }

  params[:po_reconcile_params] ||= init_params
  @po_reconcile_params = OpenStruct.new(params[:po_reconcile_params])

  @company_id = @po_reconcile_params[:company_id]
  @mit_gl_date_gteq = @po_reconcile_params[:mit_gl_date_gteq]
  @mit_gl_date_lteq = @po_reconcile_params[:mit_gl_date_lteq]
  @rnv_gl_date_gteq = @po_reconcile_params[:rnv_gl_date_gteq]
  @rnv_gl_date_lteq = @po_reconcile_params[:rnv_gl_date_lteq]
  @po_number_ref = @po_reconcile_params[:po_number_ref]
  @reconciled = @po_reconcile_params[:reconciled]
  @reconciliation_date = @po_reconcile_params[:reconciliation_date]
  @materials_in_transit = LedgerEntry.get_materials_in_transit(@company_id, @mit_gl_date_gteq, @mit_gl_date_lteq, @po_number_ref, @reconciled)
  @receipts_not_vouchered = LedgerEntry.get_receipts_not_vouchered(@company_id, @rnv_gl_date_gteq, @rnv_gl_date_lteq, @po_number_ref, @reconciled)
end

#reconcile ⇒ `Object`

# File 'app/controllers/ledger_entries_controller.rb', line 33

def reconcile
  params[:reconcile_params] ||= { company_account_id: ['', LedgerCompanyAccount.get_by_identifier('100.1122').id.to_s], reconciled: false }
  @reconcile_params = OpenStruct.new(params[:reconcile_params])
  @account_ids = BankAccount.all.collect { |ba| ba.ledger_company_account_id }
  @accounts = LedgerCompanyAccount.quick_list("ledger_company_accounts.id in (#{@account_ids.join(',')})")

  @ledger_entries = LedgerEntry.filter(params[:reconcile_params])
  @ledger_transactions = LedgerTransaction.filter(params[:reconcile_params]).uniq

  @book_balance = @ledger_entries.sum('ledger_entries.company_amount')
  @outstanding_debits = @ledger_entries.where(reconciled: false).where('ledger_entries.company_amount > 0').sum(:amount)
  @outstanding_credits = @ledger_entries.where(reconciled: false).where('ledger_entries.company_amount < 0').sum(:amount)

  @bank_balance = if params[:reconcile_params][:bank_balance].present?
                    BigDecimal(Normalizr.normalize(params[:reconcile_params][:bank_balance],
                                                   :currency))
                  else
                    BigDecimal(0)
                  end
  @adjusted_bank_balance = @bank_balance.nil? ? nil : @bank_balance + @outstanding_debits + @outstanding_credits
  @amount_to_reconcile = @adjusted_bank_balance.nil? ? nil : @adjusted_bank_balance - @book_balance

  params[:reconcile_params][:reconciled] = params[:reconcile_params][:reconciled].to_b if params[:reconcile_params][:reconciled].present?
  if [false, true].include?(params[:reconcile_params][:reconciled])
    @ledger_entries = @ledger_entries.where('ledger_entries.reconciled = ?',
                                            params[:reconcile_params][:reconciled])
  end
  @pagy, @ledger_entries = pagy(@ledger_entries, limit: 500)
end