$totalSubsT =Subscribers::find()->all();
$i=0;
foreach($totalSubsT as $sub) {
$subSessCount = Sessions::find()->where(['subscriber_id'=>$sub->id])->asArray()->all();
$subSessDead = Sessions::find()->where(['subscriber_id'=>$sub->id, 'alive'=>0])->asArray()->all();
if(count($subSessCount) == count($subSessDead)) {
$i++;
}
}
$countries = Countries::find()->where(['alive'=>1])->all();
$output = [];
$i=0;
foreach($countries as $country) {
$output[$i] = ["country"=>$country->country, "code"=>$country->code];
$i++;
}
echo json_encode($output);
'urlManager' => [
'enablePrettyUrl' => true,
'showScriptName' => false,
'rules' => [
'/services/<service>' => 'site/view-service',
'/prices' => 'site/price',
'/projects/<project>' => 'site/view-project',
'/contacts' => 'site/contacts',
],
],
Я правильно пишу этот запрос?
HeidiSQL - отрабатывает OK, а вот Yii2 непонятно какую фигню возвращает.