MySQL
- 2 ответа
- 0 вопросов
1
Вклад в тег
SELECT
`purchase_users`. *,
`numbers`.`counter`
FROM
`purchase_users`
LEFT JOIN
(SELECT `track_code`, COUNT(*) AS `counter` FROM `purchase_users` GROUP BY `track_code`) AS `numbers`
ON `purchase_users`.`track_code` = `numbers`.`track_code`'components'=>[],
'on beforeRequest' => function () {
$user = Yii::$app->user->identity;
if ($user && $user->passwordChaged) {
$user->passwordChaged = false;
$user->save();
Yii::$app->user->logout();
}
},