/** * Экшн поиска людей по улице и сроку флюры. * @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