Sha256: 5ceb2d231bdea92772495cf35ceafb9e4aec29ec487b297c81df7379b4b77c24
Contents?: true
Size: 1.85 KB
Versions: 21
Compression:
Stored size: 1.85 KB
Contents
module Comee
module Core
class ShipmentItemsController < ApplicationController
include Common
def filter
@shipment_item = Comee::Core::ShipmentItem.ransack(params[:q]).result
render json: {success: true, data: serialize(@shipment_item)}
end
def filter_with_status
items = ShipmentItem.includes(sales_order_item: %i[sales_order product unit])
.ransack(params[:q]).result
statuses = ItemStatus.where(shipment_item_id: items.map(&:id))
.select("MAX(id) AS max_id, shipment_item_id")
.group(:shipment_item_id)
.all
ids = statuses.map(&:max_id)
statuses = ItemStatus.where(id: ids).each_with_object({}) { |status, res| res[status.shipment_item_id] = status }
result = items.each_with_object([]) do |item, res|
status = statuses[item.id]
data = {
sales_order_no: item.sales_order_item.sales_order.order_number,
customer_item_no: item.sales_order_item.customer_item_no,
product_code: item.sales_order_item.product.code,
unit: item.sales_order_item.unit.code,
quantity: item.sales_order_item.quantity,
delivery_date: item.sales_order_item.delivery_date,
handover_date: item.sales_order_item.sales_order.handover_date,
po_reference: item.sales_order_item.po_reference,
status: status&.status
}
res << data.merge(status&.details)
end
render json: {success: true, data: result}
end
private
def model_params
params.require(:payload).permit(:sales_order_item_id, :quantity, :shipment_status, :status, :handover_date, :delivery_date,
:pallet_no)
end
end
end
end
Version data entries
21 entries across 21 versions & 1 rubygems