Пример #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = ProductUomModel::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['product_id' => $this->product_id, 'uom_id' => $this->uom_id, 'isi' => $this->isi, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]);
     return $dataProvider;
 }
Пример #2
0
 public static function getMasters($masters)
 {
     $masters = array_flip($masters);
     $result = [];
     // master product
     if (isset($masters['products'])) {
         $query_product = Product::find()->select(['id', 'cd' => 'code', 'text' => 'name', 'label' => 'name'])->andWhere(['status' => Product::STATUS_ACTIVE])->indexBy('id')->asArray();
         $products = $query_product->all();
         $query_uom = ProductUom::find()->select(['pu.product_id', 'pu.uom_id', 'pu.isi', 'uom_nm' => 'u.name'])->from(ProductUom::tableName() . ' pu')->joinWith(['uom' => function ($q) {
             $q->from(Uom::tableName() . ' u');
         }])->orderBy(['pu.product_id' => SORT_ASC, 'pu.isi' => SORT_ASC])->asArray();
         foreach ($query_uom->all() as $row) {
             $products[$row['product_id']]['uoms'][] = ['id' => $row['uom_id'], 'nm' => $row['uom_nm'], 'isi' => $row['isi']];
         }
         $result['products'] = $products;
     }
     // barcodes
     if (isset($masters['barcodes'])) {
         $barcodes = [];
         $query_barcode = ProductChild::find()->select(['barcode' => 'lower(barcode)', 'id' => 'product_id'])->union(Product::find()->select(['lower(code)', 'id']))->asArray();
         foreach ($query_barcode->all() as $row) {
             $barcodes[$row['barcode']] = $row['id'];
         }
         $result['barcodes'] = $barcodes;
     }
     // price_category
     if (isset($masters['price_category'])) {
         $price_category = [];
         $query_price_category = PriceCategory::find()->asArray();
         foreach ($query_price_category->all() as $row) {
             $price_category[$row['id']] = $row['name'];
         }
         $result['price_category'] = $price_category;
     }
     // prices
     if (isset($masters['prices'])) {
         $prices = [];
         $query_prices = Price::find()->asArray();
         foreach ($query_prices->all() as $row) {
             $prices[$row['product_id']][$row['price_category_id']] = $row['price'];
         }
         $result['prices'] = $prices;
     }
     // customer
     if (isset($masters['customers'])) {
         $result['customers'] = Customer::find()->select(['id', 'label' => 'name'])->asArray()->all();
     }
     // supplier
     if (isset($masters['suppliers'])) {
         $result['suppliers'] = Supplier::find()->select(['id', 'label' => 'name'])->asArray()->all();
     }
     // product_supplier
     if (isset($masters['product_supplier'])) {
         $prod_supp = [];
         $query_prod_supp = ProductSupplier::find()->select(['supplier_id', 'product_id'])->asArray();
         foreach ($query_prod_supp->all() as $row) {
             $prod_supp[$row['supplier_id']][] = $row['product_id'];
         }
         $result['product_supplier'] = $prod_supp;
     }
     // product_stock
     if (isset($masters['product_stock'])) {
         $prod_stock = [];
         $query_prod_stock = ProductStock::find()->select(['warehouse_id', 'product_id'])->asArray();
         foreach ($query_prod_stock->all() as $row) {
             $prod_stock[$row['warehouse_id']][$row['product_id']] = $row['qty'];
         }
         $result['product_stock'] = $prod_stock;
     }
     // supplier
     if (isset($masters['coa'])) {
         $result['coa'] = Coa::find()->select(['id', 'cd' => 'code', 'text' => 'name', 'label' => 'name'])->asArray()->all();
     }
     return $result;
 }