BrendsController.php
1.41 KB
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
<?php
namespace frontend\controllers;
use Yii;
use yii\web\Controller;
use common\models\Brends;
use common\models\Products;
use yii\web\HttpException;
use yii\data\Pagination;
class BrendsController extends Controller
{
public function actionShow()
{
if(!$brend = Brends::find()->where(['translit'=>$_GET['translit']])->one())
throw new HttpException(404, 'Данной странице не существует!');
$query = Products::find()->where('brend_id=:brend_id',[':brend_id' => $brend->id])->with(['catalog'])->innerJoinWith(['cost']);
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize'=>18]);
$pages->forcePageParam = false;
$pages->pageSizeParam = false;
$products = $query->offset($pages->offset)
->limit($pages->limit)
->all();
return $this->render('show', [
'brend'=>$brend,
'products'=>$products,
'pages'=>$pages,
]);
}
public function actionIndex()
{
$brends = Brends::find()->orderBy('sort ASC')->all();
return $this->render('index', [
'brends'=>$brends,
]);
}
}