/**
* Finds the Product model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Product the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Product::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Finds the Product model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $alias
* @return Product the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($alias)
{
if (($model = Product::findOne(['alias' => $alias, 'active' => 1])) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Product::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'image_id' => $this->image_id, 'brand_id' => $this->brand_id, 'mark_id' => $this->mark_id, 'typebeer_id' => $this->typebeer_id, 'size_id' => $this->size_id, 'shop_id' => $this->shop_id, 'price' => $this->price, 'date' => $this->date, 'created' => $this->created]);
return $dataProvider;
}
public function actionShowOrder($id = null)
{
$model = new Order();
$model = $model::findOne(['id' => $id]);
//var_dump($model->product_id);die();
$products = Product::find()->asArray()->all();
$listProducts = ArrayHelper::map($products, 'id', 'name');
$categories = Category::find()->asArray()->all();
$listCategories = ArrayHelper::map($categories, 'id', 'name');
$subCategories = SubCategory::find()->asArray()->all();
$listSubCategories = ArrayHelper::map($subCategories, 'id', 'name');
return $this->render('showOrder', ['model' => $model, 'listProducts' => $listProducts, 'listCategories' => $listCategories, 'listSubCategories' => $listSubCategories]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Product::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['product_id' => $this->product_id, 'cost' => $this->cost, 'number' => $this->number]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'code', $this->code]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
// ленивая загрузка. каждая категория выбирается отдельным запросом
//$query = Product::find();
//жадная загрузка. все категории выбираются одним запросом
$query = Product::find()->with('category');
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'price' => $this->price, 'created' => $this->created, 'updated' => $this->updated, 'active' => $this->active, 'category_id' => $this->category_id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'keywords', $this->keywords])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'screen_size', $this->screen_size])->andFilterWhere(['like', 'os', $this->os])->andFilterWhere(['like', 'standart', $this->standart]);
return $dataProvider;
}
/**
* Displays a single Category model.
* @param string $alias
* @return mixed
*/
public function actionView($alias)
{
$model = $this->findModel($alias);
$menu_items_product = Product::getItemsProductMenu($model->id);
$menu_items_category = Category::getItemsCategoryMenu($model->parent_category_id);
$sort = new Sort(['attributes' => ['price' => ['asc' => ['price' => SORT_ASC], 'desc' => ['price' => SORT_DESC], 'default' => SORT_DESC]]]);
$query = Product::find()->where(['active' => 1, 'category_id' => $model->id]);
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count(), 'defaultPageSize' => Yii::$app->params['PageSize']]);
$items_product = $query->offset($pages->offset)->limit($pages->limit)->orderBy($sort->orders)->all();
// тут вытягиваем все главные картинки одним запросом
$arItems = [];
foreach ($items_product as $value) {
$arItems[] = $value->id;
}
$images = $model->getImagesMain($arItems, 'Product');
return $this->render('view', ['model' => $model, 'menu_items_product' => $menu_items_product, 'menu_items_category' => $menu_items_category, 'items_product' => $items_product, 'pages' => $pages, 'sort' => $sort, 'images' => $images]);
}
public function getProduct()
{
return $this->hasOne(Product::className(), ['product_id' => 'product_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getProducts()
{
return $this->hasMany(Product::className(), ['image_id' => 'id']);
}
public function getName()
{
return $this->hasOne(Product::className(), ['id' => 'product_id'])->one()->name;
}
