/**
* Экшн поиска людей по улице и сроку флюры.
* @return mixed
*/
public function actionPprintfind($streetId)
{
$model = new Peoples();
$peoplesArr = Peoples::find()->where(['peopleStreet' => $streetId])->all();
foreach ($peoplesArr as $p) {
$findRes = graftsPeoples::find()->where(['peopleId' => $p['peopleId']])->all();
if (empty($findRes)) {
continue;
} else {
foreach ($findRes as $f) {
$graftName = Grafts::find()->where(['graftId' => $f['graftId']])->all();
$arr[$p['peopleId']][] = $graftName[0]['graftName'];
}
}
}
return $this->render('pprintFind', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model, 'dt' => $peoplesArr]);
}
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'peopleFIO', ['attribute' => 'peopleBirthday', 'format' => 'raw', 'value' => function ($data) {
return date('d.m.Y', strtotime($data->peopleBirthday));
}], ['attribute' => 'peopleWorking', 'value' => 'peopleWorking0.workingName'], ['attribute' => 'fluInfo', 'format' => 'raw', 'value' => function ($data) {
$res = "";
if ($data->peopleFluResult == 0) {
$res = '<span class="label label-danger">Патологія</span>';
} else {
$res = '<span class="label label-success">Норма</span>';
}
return $data->peopleFluNumber . "<br/>" . date('d.m.Y', strtotime($data->peopleFluDate)) . "<br/>" . $res;
}], ['attribute' => 'graft', 'format' => 'raw', 'value' => function ($data) {
$r = "";
$findRes = graftsPeoples::find()->where(['peopleId' => $data->peopleId])->all();
foreach ($findRes as $f) {
$graftName = Grafts::find()->where(['graftId' => $f['graftId']])->all();
$r .= '<span class="label label-primary">' . $graftName[0]['graftName'] . '</span> ';
}
return $r;
}], ['attribute' => 'chronic', 'format' => 'raw', 'value' => function ($data) {
$r = "";
$findRes = chronicDiseasesPeoples::find()->where(['peopleId' => $data->peopleId])->all();
foreach ($findRes as $f) {
$chronicDiseasesName = chronicDiseases::find()->where(['chronicDiseasesId' => $f['chronicDiseasesId']])->all();
$r .= '<span class="label label-primary">' . $chronicDiseasesName[0]['chronicDiseasesName'] . '</span> ';
}
return $r;
}], ['attribute' => 'peopleStreet', 'value' => 'peopleStreet0.streetName', 'filter' => ArrayHelper::map(Streets::find()->all(), 'streetId', 'streetName')], 'peopleAdress', ['class' => 'yii\\grid\\ActionColumn']]]);
?>
<?php
echo $form->field($model, 'peopleFluTerm')->hiddenInput()->label(false);
?>
<?php
echo Html::label("Вулиця");
echo Select2::widget(['model' => $model, 'attribute' => 'peopleStreet', 'language' => 'ru', 'data' => ArrayHelper::map(Streets::find()->all(), 'streetId', 'streetName')]);
?>
<?php
echo $form->field($model, 'peopleAdress')->textInput();
?>
<?php
echo Html::label("Щеплення");
echo Select2::widget(['model' => $model, 'attribute' => 'graft', 'language' => 'ru', 'data' => ArrayHelper::map(Grafts::find()->all(), 'graftId', 'graftName'), 'options' => ['multiple' => true]]);
?>
<?php
echo Html::label("Хвороби");
echo Select2::widget(['model' => $model, 'attribute' => 'chronic', 'language' => 'ru', 'data' => ArrayHelper::map(chronicDiseases::find()->all(), 'chronicDiseasesId', 'chronicDiseasesName'), 'options' => ['multiple' => true]]);
?>
<div class="form-group">
<br>
<?php
echo Html::submitButton($model->isNewRecord ? 'Додати' : 'Редагувати', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
