POS-Server/app/controllers/sales_controller.rb

class SalesController < ApplicationController
  ##--- Abilities
  load_and_authorize_resource
  ##--- Breadcrum_rails
  add_breadcrumb I18n.t("breadcrumbs." + controller_name), :sales_path
  add_breadcrumb "Nueva " + I18n.t("breadcrumbs." + controller_name).singularize, :new_sale_path, only: :new
  add_breadcrumb "Detalle de la " + I18n.t("breadcrumbs." + controller_name).singularize, :sale_path, only: :show
  add_breadcrumb "Editar " + I18n.t("breadcrumbs." + controller_name).singularize, :edit_sale_path, only: :edit

  before_action :set_sale, only: [:show, :edit, :update, :destroy]
  before_action :get_filters, only: [:index, :show, :edit, :new, :sales_reserved]

  # GET /sales
  # GET /sales.json
  def index
    today = Date.current
    thirty_day_ago = today - 30
    @sales = current_user.usertype == "A" || current_user.usertype == "SS" ? Sale.includes(:customer, :user, :seller, :sales_details).where(date_sale: thirty_day_ago..today).where.not(saletype: 2).order(" created_at DESC ") : Pointsale.find(current_user.pointsale_id).sales.includes(:customer, :user, :seller).where(date_sale: thirty_day_ago..today).where.not(saletype: 2).order("created_at DESC")
  end

  def sales_reserved
    beg_of_month = Date.current.beginning_of_month
    end_of_month = Date.current.end_of_month
    @has_open_cash_register =  if current_user.usertype == 'C'
                                session[:open_cash_register_id].present?
                              elsif current_user.usertype == 'G'
                                current_user.pointsale.get_open_cash_register.present?
                              elsif current_user.usertype == 'A'
                                false
                              end
    @sales = current_user.usertype == "A" || current_user.usertype == "SS" ? Sale.where(saletype: 2).order(" created_at DESC ") : Pointsale.find(current_user.pointsale_id).sales.where(saletype: 2).order(" created_at DESC")
  end

  # GET /sales/1
  # GET /sales/1.json
  def show
    @payments = CashRegistersMove.where(sale_id: @sale.id, status: 1)
    # saca la devolucion si es que hay.
    @products_return = ProductsReturn.find_by(sale_id: @sale.id)
    @returned_prods_ids = Array.new
    @returned_prods_ids = @products_return.products_return_ins.pluck(:product_id) if @products_return.present?
  end

  # GET /sales/new
  def new
    @sale = Sale.new
    @sale.sales_details.new
    @general_public_id = Customer.find_by(is_public: 1).id
    @pre_sales = PreSale.where(user_id: current_user.id)
    @sale.saletype = 'cash'
    # se desactivan cuando tienen pre sales, para mantener la congruencia de los datos.
    @disabled_select = false
    @disabled_button = true
    @enable_radios = true
    pointsale = Pointsale.find(current_user.pointsale_id)
    @opened_cash_registers = pointsale.open_cash_registers.abiertas
    @sale.open_cash_register_id = session[:open_cash_register_id] || nil
    @seller = @sale.seller_id.present? ? @sale.seller_id : (pointsale.sales.present? ? pointsale.sales.activas.last.seller_id : nil)
    if @pre_sales.present?
      @sale.saletype = @pre_sales[0].sale_type
      @sale.customer_id = @pre_sales[0].customer_id
      @sale.open_cash_register_id = @pre_sales[0].open_cash_register_id
      @disabled_select = true
      @disabled_button = false
      @enable_radios = false
    end
  end

  # GET /sales/1/edit
  def edit; end

  # POST /sales
  # POST /sales.json
  # rubocop:disable Metrics/BlockLength
  def create
    @sale = Sale.new(sale_params)
    @pre_sales = PreSale.where(user_id: current_user.id)
    @sale.user_id = current_user.id
    # @sale.open_cash_register_id = session[:open_cash_register_id]
    @sale.status = :notpaid
    @sale.expiration_date = Date.today + @pos_config.days_cancel_reserved if @sale.reserved?

    respond_to do |format|
      if @sale.save
        @sale.audit_comment = "Venta #{@sale.sale_code} por #{@sale.total} creada."
        # agregar detalles de la venta
        @pre_sales.each do |pre_sale|
          detail = SalesDetail.new(product_id: pre_sale.product_id, unit_price: pre_sale.unit_price, quantity: pre_sale.quantity, amount: pre_sale.amount, tax: pre_sale.tax, discount: pre_sale.discount, total: pre_sale.total, special_price_id: pre_sale.special_price_id, status: :active, haggle: pre_sale.haggle, haggle_percent: pre_sale.haggle_percent)
          @sale.sales_details << detail
          pre_sale.destroy
          # actualizar stock del producto
          stock_product = AvailableProduct.find_by(product_id: detail.product_id, pointsale_id: @sale.get_pointsale.id)
          next if stock_product.blank?
          if stock_product.stock.present?
            stock_product.stock -= detail.quantity
            stock_product.save
          else
            errors.add(:base, "No se tiene registrado el stock de alguno de los productos. Es necesario configurarlo antes de generar una venta")
            format.json { render json: @sale.errors.values, status: :unprocessable_entity }
          end
          # guardar en bitacora de inventario
          move = InventoriesMove.new(product_id: detail.product_id, sale_id: @sale.id, quantity: detail.quantity, move_type: "outgoing", reason: "sale")
          move.save
        end
        # dependiendo el tipo de venta: contado/credito determina que hacer
        if @sale.cash?
          format.js { redirect_to new_cash_registers_move_path(sale: @sale.id) }
        elsif @sale.credit?
          credit = Credit.new(customer_id: @sale.customer_id, pointsale_id: current_user.pointsale_id, sale_id: @sale.id, total: @sale.total, rest: @sale.total, status: "active", credit_note: @sale.credit_note.present? ? @sale.credit_note : "")
          credit.save
          flash[:success] = "Venta a crédito registrada al cliente: #{@sale.customer.nick_name} por $ #{@sale.total}"
          format.js { render 'create_credit_sale' }
        elsif @sale.reserved?
          format.js { redirect_to new_cash_registers_move_path(sale: @sale.id) }
        end
      else
        format.js
        format.json { render json: @sale.errors, status: :unprocessable_entity }
      end
    end
  end
  # rubocop:enable Metrics/BlockLength

  # PATCH/PUT /sales/1
  # PATCH/PUT /sales/1.json
  def update
    respond_to do |format|
      if @sale.update(sale_params)
        format.html { redirect_to @sale, notice: 'Venta modificada.' }
        format.json { render :show, status: :ok, location: @sale }
      else
        format.html { render :edit }
        format.json { render json: @sale.errors, status: :unprocessable_entity }
      end
    end
  end

  # DELETE /sales/1
  # DELETE /sales/1.json
  # rubocop:disable Metrics/BlockLength
  def destroy
    respond_to do |format|
      @sale.audit_comment = "Venta #{@sale.sale_code} cancelada."
      if @sale.update_attributes(status: :cancelled)
        # rubocop:disable Metrics/BlockNesting
        if @sale.reserved?
          return_cash = params[:return_cash]
          if return_cash == 'true'
            moves = CashRegistersMove.where(sale_id: @sale.id, move_type: 1)
            if moves.present?
              if moves[0].open_cash_register.closed?
                quantity_to_return = moves.sum(:quantity)
                new_cash_move = CashRegistersMove.new(open_cash_register_id: session[:open_cash_register_id], payment_method_id: PaymentMethod.find_by(isCash: 1).id, quantity: quantity_to_return, move_type: :egreso, sale_id: @sale.id, concept: :sale, status: :active)
                new_cash_move.skip_received_validation = true
                new_cash_move.save
              else
                moves.destroy_all
              end
            end
          end
        elsif @sale.cash?
          # checa si hay pagos de esta venta
          moves = CashRegistersMove.where(sale_id: @sale.id)
          # si la caja sigue abierta, solo elimina los moves, si ya corto, genera un egreso por esa cantidad
          if moves.present?
            if moves[0].open_cash_register.closed?
              new_cash_move = CashRegistersMove.new(open_cash_register_id: session[:open_cash_register_id], payment_method_id: PaymentMethod.find_by(isCash: true).id, quantity: moves.sum(:quantity), move_type: :egreso, sale_id: moves[0].sale_id, concept: :sale, ticket: moves[0].sale.sale_code, status: :active)
              new_cash_move.skip_received_validation = true
              new_cash_move.save
            else
              moves.destroy_all
            end
          end
        elsif @sale.credit?
          credit = Credit.find_by(sale_id: @sale.id, customer_id: @sale.customer_id)
          credit.update_attributes(status: :cancelled)
        end
        # rubocop:enable Metrics/BlockNesting
        @sale.sales_details.each do |detail|
          detail.update_attributes(status: :inactive)
          stock_product = AvailableProduct.find_by(product_id: detail.product_id, pointsale_id: @sale.get_pointsale.id)
          next if stock_product.blank?
          # sumarle al stock del producto
          stock = stock_product.stock + detail.quantity
          stock_product.update_attributes(stock: stock)
          # guardar en bitacora de inventario
          move = InventoriesMove.new(product_id: detail.product_id, sale_id: @sale.id, quantity: detail.quantity, move_type: "incoming", reason: (@sale.reserved? ? "sale_reserved_cancelled" : "sale_cancel"))
          move.save
        end
        format.html { redirect_to (@sale.reserved? ? sales_reserved_path : sales_url), warning: (@sale.reserved? ? "Apartado con folio #{@sale.sale_code} cancelado." : "Venta con folio #{@sale.sale_code} cancelado.") }
        format.json { head :no_content }
      end
    end
  end
  # rubocop:enable Metrics/BlockLength

  def find_sales_by_date
    if params[:begin_date].present? && params[:end_date].present?
      start_date = DateTime.parse(params[:begin_date])
      end_date = DateTime.parse(params[:end_date])
    else
      start_date = Date.today.beginning_of_month
      end_date = Date.today.end_of_month
    end
    @sales = current_user.usertype == "A" || current_user.usertype == "SS" ? Sale.includes(:customer, :user, :seller, :sales_details).where(date_sale: start_date..end_date).where.not(saletype: 2).order(" created_at DESC ") : Pointsale.find(current_user.pointsale_id).sales.includes(:customer, :user, :seller, :sales_details).where(date_sale: start_date..end_date).where.not(saletype: 2).order(" created_at DESC ")
    respond_to do |format|
      format.js
    end
  end

  def find_customer_sales_by_date
    if params[:begin_date].present? && params[:end_date].present?
      start_date = DateTime.parse(params[:begin_date])
      end_date = DateTime.parse(params[:end_date])
    else
      start_date = Date.today.beginning_of_month
      end_date = Date.today.end_of_month
    end
    cliente = params[:cliente]
    @sales = Sale.where(date_sale: start_date..end_date, customer_id: cliente).where.not(saletype: 2).order(" id DESC ")

    respond_to do |format|
      format.js { render action: "find_sales_by_date" }
    end
  end

  def find_reserved_sales_by_date
    if params[:begin_date].present? && params[:end_date].present?
      start_date = DateTime.parse(params[:begin_date])
      end_date = DateTime.parse(params[:end_date])
    else
      start_date = Date.today.beginning_of_month
      end_date = Date.today.end_of_month
    end
    @sales = current_user.usertype == "A" || current_user.usertype == "SS" ? Sale.includes(:customer, :user, :seller, :sales_details).where(date_sale: start_date..end_date, saletype: 2).order(" created_at DESC ") : Pointsale.find(current_user.pointsale_id).sales.includes(:customer, :user, :seller, :sales_details).where(date_sale: start_date..end_date).where(saletype: 2).order(" created_at DESC ")

    respond_to do |format|
      format.js
    end
  end

  def return_expired
    @sale = Sale.find(params[:sale_id])
    respond_to do |format|
      if @sale.update_attributes(status: :cancelled_by_expiration)
        @sale.sales_details.each do |detail|
          detail.update_attributes(status: :inactive)
          stock_product = AvailableProduct.find_by(product_id: detail.product_id, pointsale_id: @sale.get_pointsale.id)
          next if stock_product.blank?
          # sumarle al stock del producto
          stock = stock_product.stock + detail.quantity
          stock_product.update_attributes(stock: stock)
          # guardar en bitacora de inventario
          move = InventoriesMove.new(product_id: detail.product_id, sale_id: @sale.id, quantity: detail.quantity, move_type: "incoming", reason: "sale_expired")
          move.save
        end
        format.html { redirect_to sales_reserved_url, warning: "Productos reingresados al inventario del apartado #{@sale.sale_code}." }
        format.json { head :no_content }
      end
    end
  end

  def liquidate_reserve
    respond_to do |format|
      @sale = Sale.find(params[:sale_id])
      @payments = CashRegistersMove.where(sale_id: @sale.id, status: 1)
      format.js { redirect_to new_cash_registers_move_path(sale: @sale.id) }
    end
  end

  def cancel_reserved_sale
    @sale = Sale.find(params[:sale_id])
  end

  def print_receipt
    respond_to do |format|
      sale = Sale.find(params[:sale_id])
      format.pdf do
        render pdf: "ticket_venta_#{sale.id}", template: "sales/receipt.pdf.erb", layout: 'receipt.html.erb', locals: { sale: sale }, show_as_html: params.key?('debug'), page_width: '80mm', page_height: '300mm'
      end
    end
  end

  def print_reserve_receipt
    # ticket para apartado
    respond_to do |format|
      sale = Sale.find(params[:sale_id])
      # debt = sale.cash_registers_moves.first.quantity
      debt = sale.cash_registers_moves.sum(:quantity)
      format.pdf do
        render pdf: "ticket_apartado_#{sale.id}", template: "sales/receipt_reserve.pdf.erb", layout: 'receipt.html.erb', locals: { sale: sale, debt: debt }, show_as_html: params.key?('debug'), page_width: '80mm', page_height: '300mm'
      end
    end
  end

  def print_credit_receipt
    # ticket para credito
    respond_to do |format|
      sale = Sale.find(params[:sale_id])
      debt = sale.customer.credits.activos.sum(:rest)

      format.pdf do
        render pdf: "ticket_credito_#{sale.id}", template: "sales/receipt_credit.pdf.erb", layout: 'receipt.html.erb', locals: { sale: sale, debt: debt }, show_as_html: params.key?('debug'), page_width: '80mm', page_height: '300mm'
      end
    end
  end

  def print_partial_payment_receipt
    # ticket para abonos a apartado
    respond_to do |format|
      sale = Sale.find(params[:sale_id])
      new_moves = CashRegistersMove.where(id: params[:new_moves_array])
      quantity = new_moves.sum(:quantity)
      format.pdf do
        render pdf: "ticket_abono_apartado_#{sale.id}", template: "sales/receipt_partial_payment.pdf.erb", layout: 'receipt.html.erb', locals: { sale: sale, new_payments_quantity: quantity, moves: new_moves }, show_as_html: params.key?('debug'), page_width: '80mm', page_height: '300mm'
      end
    end
  end

  def print_credit_payment_receipt
    # ticket para abonos a credito
    respond_to do |format|
      sale = Sale.find(params[:sale_id])
      deuda = params[:debts].to_f
      cash_move = CashRegistersMove.where(sale_id: sale.id).last
      quantity = cash_move.quantity
      debt = Credit.where(customer_id: sale.customer_id).sum(:rest)

      format.pdf do
        render pdf: "ticket_abono_credito_#{sale.id}", template: "sales/receipt_credit_payment.pdf.erb", layout: 'receipt.html.erb', locals: { sale: sale, new_payment: quantity, debt: debt, deuda: deuda, move: cash_move }, show_as_html: params.key?('debug'), page_width: '80mm', page_height: '300mm'
      end
    end
  end

  def add_haggle
    @pre_sale = PreSale.find(params[:pre_sale])
    @haggle_percent = !current_user.pointsale.haggle_percent.blank? ? current_user.pointsale.haggle_percent : @pos_config.haggle_in_sale_percent
    @suggested_haggle = (@haggle_percent.to_f / 100) * @pre_sale.unit_price_w_discount
  end

  def create_haggle
    @pre_sale = PreSale.find(params[:pre_sale])
    @haggle_percent = params[:haggle_percent].present? ? params[:haggle_percent].to_f : nil
    @haggle_quantity = params[:haggle_quantity].present? ? params[:haggle_quantity].to_f : nil

    if @haggle_percent.present?
      @pre_sale.haggle_percent = @haggle_percent
    elsif @haggle_quantity.present?
      @pre_sale.haggle = @haggle_quantity
    end
    @pre_sale.get_totals

    respond_to do |format|
      if @pre_sale.save
        format.js
      end
    end
  end

  def find_sales_by_dates_or_code
    respond_to do |format|
      if params[:sale_code].present?
        @sales = Pointsale.find(current_user.pointsale_id).sales.activas.where(sale_code: params[:sale_code], saletype: 1).order("id DESC")
      else
        start_date = DateTime.parse(params[:start_date])
        end_date = DateTime.parse(params[:end_date])
        product_id = params[:product_id]
        @sales = product_id.present? ? Pointsale.find(current_user.pointsale_id).sales.activas.where(date_sale: start_date..end_date, saletype: 1).joins(:sales_details).where('sales_details.product_id = (?)', product_id).order("id DESC") : Pointsale.find(current_user.pointsale_id).sales.activas.where(date_sale: start_date..end_date, saletype: 1).joins(:sales_details).order("id DESC")
      end
      format.js
    end
  end

  def sales_per_month_report
    @pointsales = Pointsale.vigentes
  end

  def sales_per_month
    # start_date = DateTime.parse(params[:start_date])
    # end_date = DateTime.parse(params[:end_date])
    start_date = DateTime.parse(params[:start_date]).in_time_zone(Time.zone).beginning_of_day + 1.days
    end_date = DateTime.parse(params[:end_date]).in_time_zone(Time.zone).end_of_day + 1.days
    category = params[:category]
    subcategory = params[:subcategory]
    ids =
      if subcategory.present?
        subcategory
      elsif category.present?
        category = Category.find(category)
        [category.id, category.children.ids].flatten
      end
    @cash_sales_total = 0
    @reserved_sales_total = 0
    @credit_sales_total = 0

    if params[:pointsale_id].present?
      @pointsale = Pointsale.find(params[:pointsale_id])
      @incomes_in_period = @pointsale.cash_registers_moves.joins(:sale).where(move_type: '1', created_at: start_date..end_date)
      @sales = @pointsale.sales.joins(:products, products: :category).includes(:user, :seller).activas.where(created_at: start_date..end_date).order("id DESC")
    else
      @incomes_in_period = CashRegistersMove.joins(:sale).where(move_type: '1', created_at: start_date..end_date)
      @sales = Sale.joins(:products, products: :category).includes(:user, :seller).activas.where(created_at: start_date..end_date).order("id DESC")
    end

    if category.present?
      @sales = @sales.where(category: { id: ids })
      @incomes_in_period = @incomes_in_period.where(sale_id: @sales.ids)
    end

    @sales_quantity = @sales.size
    @prods_total = SalesDetail.where("sale_id IN (?)", @sales.pluck(:id)).sum(:quantity).round
    # @cash_sales_income = CashRegistersMove.activos.where("sale_id IN (?)", @sales.where(saletype: 1).pluck(:id)).where(created_at: start_date..end_date).sum(:quantity)
    # @reserved_sales_income = CashRegistersMove.activos.where("sale_id IN (?)", @sales.where(saletype: 2).pluck(:id)).where(created_at: start_date..end_date).sum(:quantity)
    # @credit_sales_income = CashRegistersMove.activos.where("sale_id IN (?)", @sales.where(saletype: 0).pluck(:id)).where(created_at: start_date..end_date).sum(:quantity)
    @cash_sales_income = @incomes_in_period.where('sales.saletype = ?', 1).sum(:quantity)
    @reserved_sales_income = @incomes_in_period.where('sales.saletype = ?', 2).sum(:quantity)
    @credit_sales_income = @incomes_in_period.where('sales.saletype = ?', 0).sum(:quantity)
    @sales_income = @incomes_in_period.sum(:quantity)

    @cash_sales_total = @sales.where(saletype: 1).sum(:total)
    @reserved_sales_total = @sales.where(saletype: 2).sum(:total)
    @credit_sales_total = @sales.where(saletype: 0).sum(:total)
    @sales_total = @sales.sum(:total)
    respond_to do |format|
      format.js
    end
  end

  private

  # Use callbacks to share common setup or constraints between actions.
  def set_sale
    @sale = Sale.find(params[:id])
  end

  def get_filters
    @current_page = params[:current_page].blank? ? 1 : params[:filter]
    @filter = params[:filter]
  end

  # Never trust parameters from the scary internet, only allow the white list through.
  def sale_params
    params.require(:sale).permit(:customer_id, :saletype, :amount, :tax, :discount, :total, :date_sale, :user_id, :seller_id, :sale_code, :credit_note, :open_cash_register_id)
  end
end