/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Speciality::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$query->joinWith('faculty');
$query->joinWith('cathedra');
$dataProvider->setSort(['attributes' => ['speciality_name' => ['asc' => ['speciality_name' => SORT_ASC], 'desc' => ['speciality_name' => SORT_DESC]], 'id_cathedra' => ['asc' => ['cathedra.cathedra_name' => SORT_ASC], 'desc' => ['cathedra.cathedra_name' => SORT_DESC]], 'id_faculty' => ['asc' => ['faculty.faculty_name' => SORT_ASC], 'desc' => ['faculty.faculty_name' => SORT_DESC]]]]);
$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(['speciality_id' => $this->speciality_id, 'id_edebo' => $this->id_edebo]);
$query->andFilterWhere(['like', 'speciality_name', $this->speciality_name])->andFilterWhere(['like', 'faculty.faculty_name', $this->id_faculty])->andFilterWhere(['like', 'cathedra.cathedra_name', $this->id_cathedra]);
return $dataProvider;
}
?>
<?php
echo $form->field($model, 'course_get')->dropDownList($course)->label("Курс");
?>
<?php
echo $form->field($model, 'id_faculty')->dropDownList(ArrayHelper::map(Faculty::find()->all(), 'faculty_id', 'faculty_name'), ['prompt' => 'Оберіть факультет', 'onchange' => '
$.post("index.php?r=timetable/lessons/speciality_list&id=' . '"+$(this).val(), function( data ) {
$( "select#lessons-id_speciality" ).html( data );
});
'])->label("Факультет");
?>
<?php
echo $form->field($model, 'id_speciality')->dropDownList(ArrayHelper::map(Speciality::find()->all(), 'speciality_id', 'speciality_name'), ['prompt' => 'Оберіть спеціальність', 'onchange' => '
$.post("index.php?r=timetable/lessons/groups_list&id=' . '"+$(this).val()+"&course=' . '"+$("#lessons-course_get").val(), function( data ) {
$( "select#lessons-id_group" ).html( data );
});
'])->label("Спеціальність");
?>
<?php
echo $form->field($model, 'id_group')->dropDownList(ArrayHelper::map(Groups::findAll(['is_subgroup' => 0]), 'group_id', 'main_group_name'), ['prompt' => 'Оберіть групу'])->label("Група");
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? 'Обрати' : 'Оновити', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
public function actionSpeciality_list($id)
{
$countPosts = Speciality::find()->where(['id_faculty' => $id])->count();
$posts = Speciality::find()->where(['id_faculty' => $id])->orderBy('id_faculty DESC')->all();
if ($countPosts > 0) {
echo "<option>Оберіть спеціальність</option>";
foreach ($posts as $post) {
echo "<option value='" . $post->speciality_id . "'>" . $post->speciality_name . "</option>";
}
} else {
echo "<option>-</option>";
}
}
<?php
ActiveForm::end();
?>
<?php
} else {
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'main_group_name')->textInput(['maxlength' => 50]);
?>
<?php
echo $form->field($model, 'id_speciality')->widget(Select2::classname(), ['data' => ArrayHelper::map(Speciality::find()->all(), 'speciality_id', 'speciality_name'), 'language' => 'uk', 'disabled' => true, 'pluginOptions' => ['allowClear' => true]]);
?>
<?php
echo $form->field($model, 'inflow_year')->textInput(['disabled' => true]);
?>
<?php
echo $form->field($model, 'number_of_students')->textInput();
?>
<?php
echo $form->field($model, 'id_edebo')->textInput();
?>
