/**
* Finds the Student model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Student the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findStudentModel($id)
{
$student = Student::findOne($id);
if (!isset($student)) {
throw new NotFoundHttpException('The requested page does not exist.');
}
return $student;
}
public function getAllStudentsAsMappedArray($condition = null, $userId = null)
{
$userId = isset($userId) ? $userId : Yii::$app->user->id;
$models = Student::find()->where(['user_id' => $userId]);
if (isset($condition)) {
$models->andWhere($condition);
}
return ArrayHelper::map($models->all(), 'id', 'fullname');
}
/**
* Новая модель student и связанная с ней новая модель student_education
* @return mixed
*/
public function actionCreate($idParent = null)
{
/* @var $student Student */
/* @var $studentEducation StudentEducation */
$student = new Student();
$studentEducation = new StudentEducation();
$studentEducation->id_program = $idParent;
if ($student->load(Yii::$app->request->post()) && $student->save()) {
$studentEducation->load(Yii::$app->request->post());
$studentEducation->id_student = $student->id;
$studentEducation->year = YearHelper::getYear();
$studentEducation->save();
return 'Item is succesfully created.';
// alert message
} else {
return $this->renderAjax('update', ['student' => $student, 'studentEducation' => $studentEducation]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Student::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(['id' => $this->id, 'user_id' => $this->user_id, 'lesson_cost' => $this->lesson_cost, 'is_active' => $this->is_active, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'lastname', $this->lastname])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'avatar', $this->avatar]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Student::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->setSort(['attributes' => ['fullname' => ['asc' => ['user.last_name' => SORT_ASC], 'desc' => ['user.last_name' => SORT_DESC]], 'groupName' => ['asc' => ['group.name' => SORT_ASC], 'desc' => ['group.name' => SORT_DESC]], 'srb']]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'group_id' => $this->group_id, 'education_start_date' => $this->education_start_date, 'education_end_date' => $this->education_end_date, 'srb' => $this->srb]);
$query->joinWith(['user' => function ($q) {
$q->where('user.first_name LIKE "%' . $this->fullname . '%" ' . 'OR user.last_name LIKE "%' . $this->fullname . '%"' . 'OR user.middle_name LIKE "%' . $this->fullname . '%"');
}]);
$query->joinWith(['group' => function ($q) {
$q->where('group.name LIKE "%' . $this->groupName . '%" ');
}]);
return $dataProvider;
}
public function actionUpdateStudent($studentId)
{
$student = Student::findOne($studentId);
$studentAppointment = null;
if (empty($student->studentAppointments)) {
$studentAppointment = new StudentAppointment();
$studentAppointment->student_id = $studentId;
} else {
$studentAppointment = $student->studentAppointments[0];
}
if (!isset($student)) {
throw new HttpException(404, 'The requested page does not exist.');
}
if ($student->load(Yii::$app->request->post()) && $student->save() && $studentAppointment->load(Yii::$app->request->post()) && $studentAppointment->save()) {
if ($student->avatarManager->isImageSavedToDiskOk) {
Yii::$app->session->setFlash('info', Yii::t('app', "{$student} updated successfully"));
} else {
Yii::$app->session->setFlash('info', Yii::t('app', 'There was some error uploading your avatar Image'));
}
return $this->redirect(['default/list-students']);
}
return $this->render('update-student', compact('student', 'studentAppointment'));
}
/**
* @return \yii\db\ActiveQuery
*/
public function getStudent()
{
return $this->hasOne(\common\models\Student::className(), ['id' => 'student_id']);
}
/**
* Finds the Student model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Student the loaded model
* @throws HttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Student::findOne($id)) !== null) {
return $model;
} else {
throw new HttpException(404, 'The requested page does not exist.');
}
}
public function getSteward()
{
return $this->hasOne(Student::className(), ['id' => 'steward_student_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getStudents()
{
return $this->hasMany(\common\models\Student::className(), ['user_id' => 'id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIdStudent()
{
return $this->hasOne(Student::className(), ['id' => 'id_student']);
}
public function actionStudentfromgroup()
{
$out = [];
if (isset($_POST['depdrop_parents'])) {
$parents = $_POST['depdrop_parents'];
if ($parents != null) {
$cat_id = $parents[0];
$ghd = \common\models\Student::find()->where(['group_id' => $cat_id])->all();
$out = \yii\helpers\ArrayHelper::map($ghd, 'id', 'user.fullname');
$arr = array();
foreach ($out as $key => $o) {
$arr[$key]['id'] = $key;
$arr[$key]['name'] = $o;
}
echo Json::encode(['output' => $arr, 'selected' => '']);
return;
}
}
echo Json::encode(['output' => '', 'selected' => '']);
}
<div class="group-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'name')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'speciality_id')->dropDownList(ArrayHelper::map(Speciality::find()->all(), 'id', 'name'));
?>
<?php
echo $form->field($model, 'steward_student_id')->dropDownList(ArrayHelper::map(Student::find()->where(['group_id' => $model->id])->all(), 'id', 'user.fullname'), ['prompt' => '-- Выберите студента --']);
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? 'Добавить' : 'Сохранить', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
</div>
public function getStudent()
{
return $this->hasOne(Student::className(), ['user_id' => 'id']);
}
/**
* @inheritdoc
* Удаляем связанную дисциплину, если не осталось для нее записи с именем
*/
public function afterDelete()
{
if (!static::find()->where(['id_student' => $this->id_student_cached])->exists()) {
Student::findOne($this->id_student_cached)->delete();
}
}
