POS-Server/app/models/cash_registers_move.rb

class CashRegistersMove < ActiveRecord::Base
	belongs_to :open_cash_register
	belongs_to :payment_method

	belongs_to :expense
	belongs_to :sale
	belongs_to :purchase
	belongs_to :credit_payment
	belongs_to :products_return

	##--- Llevar registro de Actividad del usuario
	audited

	enum move_type: [ :egreso, :ingreso ]
	enum status: [ :inactive, :active ]
	enum concept: [:sale, :purchase, :expense, :credit_payment, :reserved_payment, :products_return]

	attr_accessor :skip_received_validation

	validates_presence_of :quantity, message: "Debe indicar cantidad."
	validates_presence_of :payment_method_id, message: "Debe seleccionar metodo de pago."
	validates_presence_of :received, message: "Debe seleccionar monto recibido.", if: :is_in_cash?, unless: :skip_received_validation

	scope :activos, -> { where( "cash_registers_moves.status = 1") }

	def is_in_cash?
		cash_payment_id = PaymentMethod.find_by(:isCash => 1).id
		if self.payment_method_id == cash_payment_id
			return true
		else
			return false
		end
	end

	def calculate_quantities
		cash_payment_method_id = PaymentMethod.find_by(:isCash => 1).id

		# ventas
		if self.sale.present?
			if self.sale.cash?
				if self.payment_method_id == cash_payment_method_id

			      	sale_total = self.sale.total

			      	already_paid = CashRegistersMove.where(:sale_id => self.sale_id,
			        	:open_cash_register_id => self.open_cash_register_id).sum(:quantity)

			      	rest = sale_total - already_paid
			      	if self.received.present?
			        	self.change = self.received - (sale_total - already_paid)
			            self.quantity = self.received > rest ? rest : self.received
			      	end
				else
			        self.quantity = self.received
			        self.change = 0
				end
			elsif self.sale.reserved? || self.sale.credit?
				if self.received.present?
					self.change = self.received - self.quantity
				else
					self.change = 0
				end
			end
		# devoluciones
		elsif self.products_return.present?
			if self.payment_method_id == cash_payment_method_id
		      	total = self.products_return.difference_amount

		      	already_paid = CashRegistersMove.where(:products_return_id => self.products_return_id,
		        	:open_cash_register_id => self.open_cash_register_id).sum(:quantity)

		      	rest = total - already_paid
		      	if self.received.present?
		        	self.change = self.received - (total - already_paid)
		            self.quantity = self.received > rest ? rest : self.received
		      	end
			else
		        self.quantity = self.received
		        self.change = 0
			end
		end

	end

	def self.incomings_per_period(period)
		all_incomings = Array.new
		case period
			when 'day'
			    beg_period = Date.current.beginning_of_day
			    end_period = Date.current.end_of_day
			when 'week'
		      	beg_period = Date.current.beginning_of_week
		      	end_period = Date.current.end_of_week
			when 'month'
			    beg_period = Date.current.beginning_of_month
			    end_period = Date.current.end_of_month
		end

      	Pointsale.activos.each do |pointsale|
        	obj = {}
	        obj[:pointsale] = pointsale.name.gsub(" ", "\n")
	        obj[:total] = pointsale.open_cash_registers.where(:created_at => beg_period..end_period).joins(:cash_registers_moves).where("cash_registers_moves.move_type = '1' and cash_registers_moves.status = '1'").sum(:quantity)
	        all_incomings << obj
      	end
      	all_incomings = all_incomings.to_json
      	return all_incomings
	end
end