/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = PriceModel::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['product_id' => $this->product_id, 'price_category_id' => $this->price_category_id, 'price' => $this->price, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]); return $dataProvider; }
public function save($validate = true) { if ($validate && !$this->validate()) { return false; } foreach ($this->prices as $ct_id => $value) { $model = Price::findOne(['product_id' => $this->id, 'price_category_id' => $ct_id]); $model = $model ?: new Price(['product_id' => $this->id, 'price_category_id' => $ct_id]); $model->price = $value; if (!$model->save()) { return false; } } return true; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = ProductModel::find()->select(['p.*', 'pc.*'])->from(ProductModel::tableName() . ' p')->joinWith(['prices' => function ($q) { $q->from(Price::tableName() . ' pc'); }]); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['p.id' => $this->id, 'p.group_id' => $this->group_id, 'p.category_id' => $this->category_id, 'p.status' => $this->status, 'pc.price_category_id' => $this->price_category_id]); $query->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
/** * Finds the Price model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $product_id * @param integer $price_category_id * @return Price the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($product_id, $price_category_id) { if (($model = Price::findOne(['product_id' => $product_id, 'price_category_id' => $price_category_id])) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
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; }