cirandas.net

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85

module SuppliersPlugin
  class ProductPageSerializer < ApplicationSerializer

    attribute :default_margin_percentage
    has_one :filter

    has_many :products, serializer: ProductSerializer
    has_many :units
    has_many :categories
    has_many :suppliers

    def default_margin_percentage
      profile.margin_percentage
    end

    def categories
      hash = {"0": scope.t('suppliers_plugin.views.product.all_the_categories')}
      Product.product_categories_of(products).each do |pc|
        hash[pc.id] = pc.name
      end
      hash
    end

    def suppliers
      hash = {"0": scope.t("suppliers_plugin.views.product.supplier")}
      s = profile.suppliers.order(:name_abbreviation, :name)
      s = s.active if params[:available] == 'true'

      s.each do |supplier|
        hash[supplier.id] = supplier.abbreviation_or_name
      end
      hash
    end

    def products
      params[:available] ||= 'true'

      # FIXME: joins(:from_products) is hiding own products (except baskets)
      profile.products
        .unarchived
        .supplied
        .joins(:from_products, :suppliers)
        .includes(:image)
        .includes(:supplier_image)
        .order('from_product_name ASC')
        .where(suppliers_plugin_suppliers: {active: true})
        .select('products.*')
        .select('from_products_products.name    AS from_product_name')
        .select('from_products_products.unit_id AS from_product_unit_id')
        .select('from_products_products.price   AS from_product_price')
        .select('suppliers_plugin_suppliers.id  AS supplier_id')
        .group('suppliers_plugin_suppliers.id')
        .group('from_products_products.name')
        .group('from_products_products.unit_id')
        .group('from_products_products.price')
        .where("products.available": params['available'])
    end

    def units
      profile.environment.units.map do |unit|
        {name: unit.singular, id: unit.id}
      end
    end

    def filter
      {
        supplier:instance_options[:supplier_id],
        category:instance_options[:category],
        unit:instance_options[:unit_id],
        name:instance_options[:name],
      }
    end

    protected

    def profile
      object
    end

    def params
      instance_options
    end

  end
end