module Caboose
  class InvoicesController < Caboose::ApplicationController
    
    # @route GET /admin/invoices
    # @route GET /admin/users/:user_id/invoices
    def admin_index
      return if !user_is_allowed('invoices', 'view')

      if !params[:game_id].blank?
        game = Colonnade::Game.find(params[:game_id])
        menu = Colonnade::Menu.where(:game_id => game.id).first if game
        invoice_ids = Colonnade::SuiteMenu.where(:menu_id => menu.id).pluq(:invoice_id) if menu
        invoice_ids = invoice_ids.to_s.gsub('[','').gsub(']','')
      end
      
      @pager = Caboose::PageBarGenerator.new(params, {
        'site_id'              => @site.id,
        'customer_id'          => params[:user_id] ? params[:user_id] : '', 
        'status'               => Invoice::STATUS_PENDING,      
        'shipping_method_code' => '',
        'id'                   => '',
        'invoice_number'       => '',
        'total_lte'            => '',
        'total_gte'            => ''
      }, {
        'model'          => 'Caboose::Invoice',
        'sort'           => 'id',
        'desc'           => 1,
        'base_url'       => params[:user_id] ? "/admin/users/#{params[:user_id]}/invoices" : "/admin/invoices",
        'additional_where' => [ params[:game_id].blank? ? 'id is not null' : ( invoice_ids.blank? ? "id is null" : "id in (#{invoice_ids})" ) ],
        'use_url_params' => false,
        'items_per_page' => 100
      })
      
      @edituser = params[:user_id] ? User.find(params[:user_id]) : nil
      @invoices  = @pager.items
      @customers = Caboose::User.where(:site_id => @site.id).reorder('last_name, first_name').all
      
      render :layout => 'caboose/admin'
    end
    
    # @route GET /admin/invoices/:id/refresh-transactions
    def refresh_transactions      
      return if !user_is_allowed('invoices', 'add')
      
      resp = Caboose::StdClass.new
                  
      invoice = Invoice.find(params[:id])
      invoice.refresh_transactions            
      resp.financial_status = invoice.financial_status
      resp.invoice_transactions = invoice.invoice_transactions.reorder(:date_processed).all
      
      render :json => resp
    end
    
    # @route GET /admin/invoices/new
    def admin_new
      return if !user_is_allowed('invoices', 'add')      
      render :layout => 'caboose/admin'
    end
    
    # @route POST /admin/invoices
    def admin_add
      return if !user_is_allowed('invoices', 'add')
      invoice = Invoice.create(
        :site_id => @site.id,
        :status => Invoice::STATUS_PENDING,
        :date_created => DateTime.now,
        :financial_status => Invoice::FINANCIAL_STATUS_PENDING,
        :invoice_number => @site.store_config.next_invoice_number
      )
      InvoiceLog.create(
        :invoice_id     => invoice.id,
        :user_id        => logged_in_user.id,
        :date_logged    => DateTime.now.utc,
        :invoice_action => InvoiceLog::ACTION_INVOICE_CREATED                        
      )
      if !params[:colonnade_game_id].blank? && Colonnade::SuiteMenu.respond_to?(:to_s) && Colonnade::Campus.where(:site_id => @site.id).exists?
        game = Colonnade::Game.where(:id => params[:colonnade_game_id], :site_id => @site.id).first
        menu = Colonnade::Menu.where(:game_id => game.id, :site_id => @site.id).first if game
        user = Caboose::User.where(:site_id => @site.id, :id => params[:colonnade_user_id]).first
        suite = Colonnade::Suite.where(:id => params[:colonnade_suite_id], :site_id => @site.id).first
        if suite && menu && user && invoice
          sm = Colonnade::SuiteMenu.where(:suite_id => suite.id, :menu_id => menu.id, :user_id => user.id, :invoice_id => invoice.id).first
          sm = Colonnade::SuiteMenu.create(:suite_id => suite.id, :menu_id => menu.id, :user_id => user.id, :invoice_id => invoice.id, :site_id => @site.id, :status => 'empty') if sm.nil?
        end
        if user
          invoice.customer_id = user.id
          invoice.save
        end
      end
      render :json => { :sucess => true, :redirect => "/admin/invoices/#{invoice.id}" }
    end
        
    # @route_priority 50
    # @route GET /admin/invoices/:id
    # @route GET /admin/users/:user_id/invoices/:id
    def admin_edit
      return if !user_is_allowed('invoices', 'edit')
      @invoice = Invoice.where(:id => params[:id]).first
      @edituser = params[:user_id] ? User.find(params[:user_id]) : nil
      
      if params[:id].nil? || @invoice.nil?
        render :file => 'caboose/invoices/admin_invalid_invoice', :layout => 'caboose/admin'
        return
      end            
      render :layout => 'caboose/admin'
    end
    
    # @route GET /admin/invoices/:id/calculate-tax
    def admin_calculate_tax
      return if !user_is_allowed('invoices', 'edit')
      invoice = Invoice.find(params[:id])
      invoice.tax = invoice.calculate_tax
      invoice.total = invoice.calculate_total
      invoice.save
      render :json => { :success => true }      
    end
    
    # @route GET /admin/invoices/:id/calculate-handling
    def admin_calculate_handling
      return if !user_is_allowed('invoices', 'edit')
      invoice = Invoice.find(params[:id])
      invoice.handling = invoice.calculate_handling
      invoice.total = invoice.calculate_total
      invoice.save
      render :json => { :success => true }      
    end
    
    # @route GET /admin/invoices/:id/capture
    def capture_funds
      return if !user_is_allowed('invoices', 'edit')
           
      invoice = Invoice.find(params[:id])
      resp = invoice.capture_funds   
      
      # Tell taxcloud the invoice was captured
      #Caboose::TaxCalculator.captured(invoice)
      
      render :json => resp
    end
    
    # @route GET /admin/invoices/:id/authorize-and-capture
    def admin_authorize_and_capture
      return if !user_is_allowed('invoices', 'edit')
           
      invoice = Invoice.find(params[:id])
      resp = invoice.authorize_and_capture   
      
      # Send out emails
      #begin
      #  InvoicesMailer.configure_for_site(@site.id).customer_new_invoice(@invoice).deliver
      #  InvoicesMailer.configure_for_site(@site.id).fulfillment_new_invoice(@invoice).deliver
      #rescue
      #  puts "=================================================================="
      #  puts "Error sending out invoice confirmation emails for invoice ID #{@invoice.id}"
      #  puts "=================================================================="
      #end
      
      render :json => resp
    end
    
    # @route GET /admin/invoices/:id/void
    def admin_void
      return if !user_is_allowed('invoices', 'edit')
            
      invoice = Invoice.find(params[:id])
      resp = invoice.void
    
      render :json => resp
    end
    
    # @route GET /admin/invoices/:id/refund
    def admin_refund
      return if !user_is_allowed('invoices', 'edit')
    
      invoice = Invoice.find(params[:id])
      resp = invoice.refund 
      
      render :json => resp            
    end
    
    # @route POST /admin/invoices/:id/resend-confirmation
    def admin_resend_confirmation
      if Invoice.find(params[:id]).resend_confirmation
        render :json => { success: "Confirmation re-sent successfully." }
      else
        render :json => { error: "There was an error re-sending the email." }
      end
    end
    
    # @route GET /admin/invoices/:id/json
    def admin_json
      return if !user_is_allowed('invoices', 'edit')    
      invoice = Invoice.find(params[:id])
      if invoice.shipping_address_id.nil?
        sa = Address.create
        invoice.shipping_address_id = sa.id
        invoice.save
      end
      render :json => invoice.as_json(:include => [        
        { :line_items => { :include => { :variant => { :include => :product }}}},
        { :invoice_packages => { :include => [:shipping_package, :shipping_method] }},
        { :discounts => { :include => :gift_card }},
        :customer,
        :shipping_address,
        :billing_address,
        :invoice_transactions
      ])
    end
    
    # @route GET /admin/invoices/:id/print
    def admin_print
      return if !user_is_allowed('invoices', 'edit')           
      
      pdf = @site.store_config.custom_invoice_pdf
      pdf = "InvoicePdf" if pdf.nil? || pdf.strip.length == 0                              
      eval("pdf = #{pdf}.new")
      pdf.invoice = Invoice.find(params[:id])             
      send_data pdf.to_pdf, :filename => "invoice_#{pdf.invoice.id}.pdf", :type => "application/pdf", :disposition => "inline"   
    end
    
    # @route GET /admin/invoices/print-pending
    def admin_print_pending
      return if !user_is_allowed('invoices', 'edit')

      pdf = @site.store_config.custom_invoice_pdf
      pdf = "PendingInvoicesPdf" if pdf.blank?                      
      eval("pdf = #{pdf}.new")

      where = []
      terms = []
      where << "(id = ?)" if !params[:id].blank?
      terms << params[:id] if !params[:id].blank?
      where << "(invoice_number = ?)" if !params[:invoice_number].blank?
      terms << params[:invoice_number] if !params[:invoice_number].blank?
      where << "(customer_id = ?)" if !params[:customer_id].blank?
      terms << params[:customer_id] if !params[:customer_id].blank?
      where << "(total_gte = ?)" if !params[:total_gte].blank?
      terms << params[:total_gte] if !params[:total_gte].blank?
      where << "(total_lte = ?)" if !params[:total_lte].blank?
      terms << params[:total_lte] if !params[:total_lte].blank?
      where << "(status = ?)"
      terms << 'pending'


      if !params[:game_id].blank?
        game = Colonnade::Game.find(params[:game_id])
        menu = Colonnade::Menu.where(:game_id => game.id).first if game
        invoice_ids = Colonnade::SuiteMenu.where(:menu_id => menu.id).pluq(:invoice_id) if menu
      end

      where << "(id in (?))" if invoice_ids
      terms << invoice_ids if invoice_ids


      where2 = where.join(' AND ')

      pdf.invoices = Invoice.where(where2, *terms).all  
      if params[:print_card_details]
        pdf.print_card_details = params[:print_card_details].to_i == 1
      end
      send_data pdf.to_pdf, :filename => "pending_invoices.pdf", :type => "application/pdf", :disposition => "inline"            
    end
      
    # @route PUT /admin/invoices/:id
    def admin_update
      return if !user_is_allowed('invoices', 'edit')
      
      resp = Caboose::StdClass.new({'attributes' => {}})
      invoice = Invoice.find(params[:id])    
            
      save = true
      fields_to_log = ['tax','handling','custom_discount','financial_status','customer_id','notes','customer_notes','payment_terms','date_due','status']            
      params.each do |name,value|
        if fields_to_log.include?(name)                                                  
          InvoiceLog.create(
            :invoice_id     => invoice.id,
            :user_id        => logged_in_user.id,
            :date_logged    => DateTime.now.utc,
            :invoice_action => InvoiceLog::ACTION_INVOICE_UPDATED,
            :field          => name,
            :old_value      => invoice[name.to_sym],
            :new_value      => value                                                                  
          )
        end
        case name
          when 'tax' 
            invoice.tax = value
            invoice.total = invoice.calculate_total          
          when 'handling'
            invoice.handling = value
            invoice.total = invoice.calculate_total
          when 'custom_discount' 
            invoice.custom_discount = value
            invoice.discount = invoice.calculate_discount
            invoice.total = invoice.calculate_total
          when 'status'            
            invoice.status = value             
            invoice.date_processed = DateTime.now.utc if value == Invoice::STATUS_PROCESSED
            
          when 'financial_status'    then invoice.financial_status = value
          when 'customer_id'         then invoice.customer_id      = value          
          when 'notes'               then invoice.notes            = value
          when 'customer_notes'      then invoice.customer_notes   = value                    
          when 'payment_terms'       then invoice.payment_terms    = value          
          when 'date_due'            then invoice.date_due         = value
                            
        end                        
      end
    
      #invoice.calculate
      #invoice.calculate_total
      #resp.attributes['total'] = { 'value' => invoice.total }
      
      resp.success = save && invoice.save      
      render :json => resp
    end
    
    # @route DELETE /admin/invoices/:id
    def admin_delete
      return if !user_is_allowed('invoices', 'delete')
      Invoice.find(params[:id]).destroy      
      InvoiceLog.create(
        :invoice_id     => params[:id],
        :user_id        => logged_in_user.id,
        :date_logged    => DateTime.now.utc,
        :invoice_action => InvoiceLog::ACTION_INVOICE_DELETED                                                                          
      )      
      render :json => Caboose::StdClass.new({
        :redirect => '/admin/invoices'
      })
    end
    
    # @route GET /admin/invoices/:id/send-for-authorization
    def admin_send_for_authorization
      return if !user_is_allowed('invoices', 'edit')
      invoice = Invoice.find(params[:id])
      invoice.delay(:queue => 'caboose_store').send_payment_authorization_email
    #  invoice.send_payment_authorization_email
      render :json => { :success => true }
    end
    
    # @route GET /admin/invoices/:id/send-receipt
    def admin_send_receipt
      return if !user_is_allowed('invoices', 'edit')
      invoice = Invoice.find(params[:id])
      invoice.delay(:queue => 'caboose_store').send_receipt_email
    #  invoice.send_receipt_email        
      render :json => { :success => true }
    end
    
    # @route GET /admin/invoices/city-report
    def admin_city_report
      return if !user_is_allowed('invoices', 'view')
    
      @d1 = params[:d1] ? DateTime.strptime("#{params[:d1]} 00:00:00", '%Y-%m-%d %H:%M:%S') : DateTime.strptime(DateTime.now.strftime("%Y-%m-01 00:00:00"), '%Y-%m-%d %H:%M:%S')
      @d2 = params[:d2] ? DateTime.strptime("#{params[:d2]} 00:00:00", '%Y-%m-%d %H:%M:%S') : @d1 + 1.month      
      @rows = InvoiceReporter.city_report(@site.id, @d1, @d2)
      
      render :layout => 'caboose/admin'    
    end
    
    # @route GET /admin/invoices/summary-report
    def admin_summary_report
      return if !user_is_allowed('invoices', 'view')
    
      @d1 = params[:d1] ? DateTime.strptime("#{params[:d1]} 00:00:00", '%Y-%m-%d %H:%M:%S') : DateTime.strptime(DateTime.now.strftime("%Y-%m-01 00:00:00"), '%Y-%m-%d %H:%M:%S')
      @d2 = params[:d2] ? DateTime.strptime("#{params[:d2]} 00:00:00", '%Y-%m-%d %H:%M:%S') : @d1 + 1.month      
      @rows = InvoiceReporter.summary_report(@site.id, @d1, @d2)
      
      render :layout => 'caboose/admin'    
    end
    
    # @route GET /admin/invoices/:field-options    
    def admin_options
      return if !user_is_allowed('invoices', 'view')
      
      options = []
      case params[:field]
        when 'status'
          statuses = [
            Invoice::STATUS_CART, 
            Invoice::STATUS_PENDING, 
            Invoice::STATUS_READY_TO_SHIP, 
            Invoice::STATUS_PROCESSED,             
            Invoice::STATUS_CANCELED
          ]
          options = statuses.collect{ |s| { 'text' => s.capitalize, 'value' => s }}
        when 'financial-status'
          statuses = [
            Invoice::FINANCIAL_STATUS_PENDING             ,
            Invoice::FINANCIAL_STATUS_AUTHORIZED          ,
            Invoice::FINANCIAL_STATUS_CAPTURED            ,
            Invoice::FINANCIAL_STATUS_REFUNDED            ,
            Invoice::FINANCIAL_STATUS_VOIDED              ,
            Invoice::FINANCIAL_STATUS_PAID_BY_CHECK       ,
            Invoice::FINANCIAL_STATUS_PAID_BY_OTHER_MEANS                
          ]
          options = statuses.collect{ |s| { 'text' => s.capitalize, 'value' => s }}
        when 'payment-terms'
          options = [
            { 'value' => Invoice::PAYMENT_TERMS_PIA   , 'text' => 'Pay In Advance' },
            { 'value' => Invoice::PAYMENT_TERMS_NET7  , 'text' => 'Net 7'          },
            { 'value' => Invoice::PAYMENT_TERMS_NET10 , 'text' => 'Net 10'         },
            { 'value' => Invoice::PAYMENT_TERMS_NET30 , 'text' => 'Net 30'         },
            { 'value' => Invoice::PAYMENT_TERMS_NET60 , 'text' => 'Net 60'         },
            { 'value' => Invoice::PAYMENT_TERMS_NET90 , 'text' => 'Net 90'         },
            { 'value' => Invoice::PAYMENT_TERMS_EOM   , 'text' => 'End of Month'   }            
          ]
      end          
      render :json => options    
    end
    
    # @route GET /admin/invoices/google-feed
    def admin_google_feed
      d2 = DateTime.now
      d1 = DateTime.now
      if Caboose::Setting.exists?(:name => 'google_feed_date_last_submitted')                  
        d1 = Caboose::Setting.where(:name => 'google_feed_date_last_submitted').first.value      
        d1 = DateTime.parse(d1)
      elsif Invoice.exists?("status = ? and date_authorized is not null", Invoice::STATUS_PROCESSED)
        d1 = Invoice.where("status = ? and date_authorized is not null", Invoice::STATUS_PROCESSED).reorder("date_authorized DESC").limit(1).pluck('date_authorized')
        d1 = DateTime.parse(d1)
      end
      
      # Google Feed Docs
      # https://support.google.com/trustedstoresmerchant/answer/3272612?hl=en&ref_topic=3272286?hl=en
      tsv = ["merchant invoice id\ttracking number\tcarrier code\tother carrier name\tship date"]            
      if Invoice.exists?("status = ? and date_authorized > '#{d1.strftime("%F %T")}'", Invoice::STATUS_PROCESSED)
        Invoice.where("status = ? and date_authorized > ?", Invoice::STATUS_PROCESSED, d1).reorder(:id).all.each do |invoice|
          tracking_numbers = invoice.line_items.collect{ |li| li.tracking_number }.compact.uniq
          tn = tracking_numbers && tracking_numbers.count >= 1 ? tracking_numbers[0] : ""
          tsv << "#{invoice.id}\t#{tn}\tUPS\t\t#{invoice.date_shipped.strftime("%F")}"                              
        end
      end
      
      # Save when we made the last call
      setting = if Caboose::Setting.exists?(:name => 'google_feed_date_last_submitted')
        Caboose::Setting.where(:name => 'google_feed_date_last_submitted').first
      else
        Caboose::Setting.new(:name => 'google_feed_date_last_submitted')
      end
      
      setting.value = d2.strftime("%F %T")
      setting.save            
                   
      # Print out the lines
      render :text => tsv.join("\n")
    end
  end
end