8 //use yii\data\ActiveDataProvider;
9 use yii\data\SqlDataProvider;
11 use app\models\Regions;
12 use app\models\Locations;
14 /* @var $this yii\web\View */
18 // $query = Regions::find()
19 // ->joinWith(['locations as l'])
20 // ->where(['locations.region_id' => 'regions.id'])
21 // ->select('regions.*, l.name as lname');
22 // $query = (new Query())
23 // ->select(' regions.*, l.name as lname')
25 // ->rightJoin(['locations as l on l.region_id = id']);
27 // $dataProvider = new ActiveDataProvider([
31 // $dataProvider->setSort([
32 // 'defaultOrder' => [
33 // 'name' => SORT_ASC,
37 $count = Yii::$app->db->createCommand('
38 SELECT COUNT(*) FROM regions
41 $dataProvider = new SqlDataProvider([
47 LEFT JOIN locations AS l
50 ON i.location_id = l.id
56 'totalCount' => $count,
68 $countg = Yii::$app->db->createCommand('
69 SELECT COUNT(*) FROM types
72 $dataProviderg = new SqlDataProvider([
85 'totalCount' => $countg,
97 $this->title = Yii::t('app','Inventory');
99 <div class="site-index">
100 <h2>Количество оборудования по подразделениям</h2>
101 <?= GridView::widget([
102 'dataProvider' => $dataProvider,
106 'attribute' => 'rname',
107 'label' => Yii::t('regions', 'Regions'),
111 'attribute' => 'icount',
112 'label' => Yii::t('regions', 'Total items count'),
119 <h2>Количество оборудования по типам</h2>
120 <?= GridView::widget([
121 'dataProvider' => $dataProviderg,
125 'attribute' => 'tname',
126 'label' => Yii::t('types', 'Types'),
130 'attribute' => 'icount',
131 'label' => Yii::t('types', 'Total items count'),