/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Housing::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['housing_id' => $this->housing_id]); $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
function classHous($val) { $classes = ClassRooms::findOne(['classrooms_id' => $val]); $housing = Housing::findOne(['housing_id' => $classes['id_housing']]); return $classes['classrooms_number'] . ' - ' . $housing['name']; }
/* @var $model app\module\timetable\models\Lessons */ /* @var $form yii\widgets\ActiveForm */ $lesson_number = $_GET['lesson_number']; $day = $_GET['day']; $id_faculty = $_GET['id_faculty']; $id_speciality = $_GET['id_speciality']; $course = $_GET['course']; $semester = $_GET['semester']; $is_numerator = $_GET['is_numerator']; $id_group = $_GET['id_group']; $id_okr = $_GET['id_okr']; $students_in_group = Groups::find()->where(['group_id' => $id_group])->all(); $sig = $students_in_group[0]['number_of_students'] + 5; $classes = ClassRooms::find()->Where('seats>' . $sig)->orderBy('classrooms_number ASC')->all(); foreach ($classes as $cl) { $housing = Housing::findOne(['housing_id' => $cl['id_housing']]); $classroomsArray[$cl['classrooms_id']] = $cl['classrooms_number'] . ' - ' . $housing['name']; } $d = Discipline::findAll(['id_group' => $id_group]); if (empty($d)) { $d = Discipline::findAll(['id_group' => $students_in_group[0]['parent_group']]); } if (empty($d)) { echo '<div class="alert alert-danger" role="alert">Для даної групи немає дисциплін!</div>'; exit; } foreach ($d as $dd) { //$disciplines = Discipline::findAll(['discipline_distribution_id' => $dd['id_discipline']]); $disciplines = Discipline::findAll(['id_discipline' => $dd['id_discipline']]); foreach ($disciplines as $disc) { $disc_name = DisciplineList::findOne(['discipline_id' => $disc['id_discipline']]);
/** * @return \yii\db\ActiveQuery */ public function getHousing() { return $this->hasOne(Housing::className(), ['housing_id' => 'id_housing']); }
public function actionClass_list($id, $seats) { if ($id == true) { $posts = ClassRooms::find()->orderBy('classrooms_number ASC')->all(); foreach ($posts as $cl) { $housing = Housing::findOne(['housing_id' => $cl['id_housing']]); echo "<option value='" . $cl['classrooms_id'] . "'>" . $cl['classrooms_number'] . ' - ' . $housing['name'] . "</option>"; } } else { $classes = ClassRooms::find()->Where('seats>' . $seats)->orderBy('classrooms_number ASC')->all(); foreach ($classes as $cl) { $housing = Housing::findOne(['housing_id' => $cl['id_housing']]); echo "<option value='" . $cl['classrooms_id'] . "'>" . $cl['classrooms_number'] . ' - ' . $housing['name'] . "</option>"; } } }
/** * Finds the Housing model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Housing the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Housing::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/* @var $model app\module\handbook\models\ClassRooms */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="classrooms-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'classrooms_number')->textInput(['maxlength' => 4]); ?> <?php echo $form->field($model, 'id_housing')->dropDownList(ArrayHelper::map(Housing::find()->all(), 'housing_id', 'name')); ?> <?php echo $form->field($model, 'seats')->textInput(); ?> <?php echo $form->field($model, 'comp_number')->textInput(); ?> <?php echo Html::label("Тип аудиторії"); echo Select2::widget(['model' => $model, 'attribute' => 'options', 'language' => 'ru', 'data' => ArrayHelper::map(Specclasses::find()->all(), 'spec_class_id', 'spec_class_name'), 'options' => ['multiple' => true]]); ?> <br/>
function getHousingName($id_classroom) { $classroom_array = ClassRooms::findOne(['classrooms_id' => $id_classroom]); $housing_name = Housing::findOne(['housing_id' => $classroom_array['id_housing']]); return $housing_name['name']; }