public function actionIndex($token)
{
echo $token;
try{...}
}
В таблице тип поля timestamp.
andWhere( 'date >= 2018-04-01 AND date <= 2018-08-01')
И в доках не написано об этом ни слова.
app\modules\catalog\models\Catalog Object
(
[_locateArray:app\modules\catalog\models\Catalog:private] =>
[_attributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 2
[name] => Игровые комплексы
[_oldAttributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 2
[name] => Игровые комплексы
)
[_related:yii\db\BaseActiveRecord:private] => Array
(
[categories] => Array
(
[0] => app\modules\catalog\models\Catalog Object
(
[_locateArray:app\modules\catalog\models\Catalog:private] =>
[_attributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 4
[name] => Детские домики
)
[_oldAttributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 4
[name] => Детские домики
)
[_related:yii\db\BaseActiveRecord:private] => Array
(
[products] => Array
(
[0] => app\modules\production\models\Products Object
(
[_attributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 15
[title] => Домик Mochtoys игровой
)
[1] => app\modules\production\models\Products Object
(
[_attributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 16
[title] => Домик Mochtoys с зеленой крышей
)
[2] => app\modules\production\models\Products Object
(
[_attributes:yii\db\BaseActiveRecord:private] => Array
(
[id] => 17
[title] => Игровой дом Keter Фунтик с горкой
)
$query = Catalog::find()
->from(['catalog' => Catalog::tableName()])
->where(['catalog.status' => Catalog::STATUS_ACTIVE, 'catalog.parent_id' => null])
->with(['categories'])
->innerJoinWith([
'categories categories',
'categories.products prod' => function(ActiveQuery $query){
$query->andOnCondition(['prod.status' => Products::STATUS_ACTIVE]);
}
]);
$dataProvider = new ActiveDataProvider([
'query' => $query
]);
// $dataProvider передаёте в представление.
echo ListView::widget([
'dataProvider' => $dataProvider,
'layout' => '{items}',
'itemView' => '_includes/_list_view'
])
Дайте дам базы, полный.