/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Subject::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$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;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'subject_name', $this->subject_name]);
return $dataProvider;
}
public function beforeSave($insert)
{
if (parent::beforeSave($insert)) {
$cur_subject = Subject::findOne(['id' => $this->subject_id]);
$this->section = $cur_subject->section;
$question = new Question();
$subjects = Subject::find()->where(['section' => $cur_subject->section, 'type' => 1])->all();
$q_ids = '';
foreach ($subjects as $subject) {
$q_ids .= $question->getSubjectQuestionsIds($subject->id) . ',';
}
$q_ids .= $question->getSubjectQuestionsIds($cur_subject->id);
$this->questions_ids = $q_ids;
return true;
}
return false;
}
function postCapnhat($id)
{
// Get data
$input['id'] = $id;
$input['name'] = Input::get('name');
$input['description'] = Input::get('description');
// Validate
$rules = ['id' => 'required|numeric|exists:shifts,id', 'name' => 'required|string|min:2|max:200', 'description' => 'required|string|min:2|max:200'];
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
$errors_validate = $validator->messages()->all();
return back()->with('errors_validate', $errors_validate)->withInput();
}
// If validate Ok
$the_shift = Subject::find($input['id'])->update($input);
add_message('Cập nhật thành công');
return back();
}
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use app\models\Subject;
$subjects = Subject::find()->all();
$lsubjects = ArrayHelper::toArray($subjects, ['app\\models\\Subject' => ['id', 'title', 'section' => function ($subject) {
if ($subject->section == 0) {
return 'Русское отделение';
} else {
return 'Казахское отделение';
}
}]]);
$listOfSubjects = ArrayHelper::map($lsubjects, 'id', 'title', 'section');
/* @var $this yii\web\View */
/* @var $model app\models\SubjectTest */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="subject-test-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'subject_id')->dropDownList($listOfSubjects);
?>
<div class="form-group">
/**
* Search in Subject the Materials
*
* @param id
* @return Response with materials
*/
public function getMaterials($id)
{
$subjects = Subject::find($id);
return response()->json($subjects->materials);
}
public function actionRemove()
{
$subjects = Subject::find()->all();
foreach ($subjects as $subject) {
for ($i = 1; $i <= 25; $i++) {
if ($i <= 15) {
$question = Question::findOne(['description' => 'Легкий вопрос ' . $i]);
} elseif ($i > 15 && $i <= 25) {
$question = Question::findOne(['description' => 'Средний вопрос ' . $i]);
$question->description = 'Средний вопрос ' . $i;
$question->level = 1;
} else {
$question = Question::findOne(['description' => 'Сложный вопрос ' . $i]);
}
$question->delete();
}
}
return 111;
}
/**
* Lists all Subject models.
* @return mixed
*/
public function actionIndex()
{
$dataProvider = new ActiveDataProvider(['query' => Subject::find()]);
return $this->render('index', ['dataProvider' => $dataProvider]);
}
public function updateSubject($id, Subject $subject, Setting $setting, Request $request)
{
$title = $request->input('title');
$sub = $subject->find($id);
$sub->title = $title;
$sub->save();
session(array('subject_id' => $id));
$old_setting = $setting->find($id);
$uploads_path = realpath(__DIR__ . '/../../../uploads');
if ($request->session()->has('uploads')) {
if ($old_setting->lec_xlsx) {
unlink($uploads_path . '/' . $old_setting->lec_xlsx);
}
if ($old_setting->lab_xlsx) {
unlink($uploads_path . '/' . $old_setting->lab_xlsx);
}
}
$sheet_number = $request->input('sheet_number');
$name_cell = $request->input('name_cell');
$grade_cell = $request->input('grade_cell');
$cell_range = $request->input('cell_range');
$header_row = $request->input('header_row');
$start_row = $request->input('start_row');
$end_row = $request->input('end_row');
$new_setting = array('sheet_number' => $sheet_number, 'name_cell' => $name_cell, 'grade_cell' => $grade_cell, 'cell_range' => $cell_range, 'header_row' => $header_row, 'start_row' => $start_row, 'end_row' => $end_row);
if ($request->session()->has('uploads')) {
$new_setting['lec_xlsx'] = session('uploads')[0];
$new_setting['lab_xlsx'] = session('uploads')[1];
}
$setting = DB::table('settings')->where('subject_id', '=', $id)->update($new_setting);
return redirect("activities/{$id}/add");
}
/**
* Remove the specified resource from storage.
* DELETE /subjects/{id}
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$subject = Subject::find($id);
$subject->delete();
return Redirect::route('subjects.index')->with('okmessage', 'Subject deleted');
}
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use app\models\Subject;
$subjects = Subject::find()->where(['type' => 0])->all();
$lsubjects = ArrayHelper::toArray($subjects, ['app\\models\\Subject' => ['id', 'title', 'section' => function ($subject) {
if ($subject->section == 0) {
return 'Русское отделение';
} else {
return 'Казахское отделение';
}
}]]);
$listOfSubjects = ArrayHelper::map($lsubjects, 'id', 'title', 'section');
/* @var $this yii\web\View */
/* @var $model app\models\EntTest */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="ent-test-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'subject_id')->dropDownList($listOfSubjects);
?>
<div class="form-group">
use yii\widgets\DetailView;
use yii\widgets\ActiveForm;
use yii\widgets\ListView;
use yii\data\ActiveDataProvider;
use app\models\Question;
use app\models\Subject;
use app\models\UserScore;
use app\models\HardQuestion;
/* @var $this yii\web\View */
/* @var $model app\models\SubjectTest */
$this->title = 'Тест № ' . $model->id;
$this->params['breadcrumbs'][] = ['label' => 'Тест по предметам', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
$count = 1;
$isFirst = true;
$subjects = Subject::find()->where(['type' => 1, 'section' => $model->section])->all();
$user_score = UserScore::find()->where(['user_id' => Yii::$app->user->identity->id, 'test_id' => $model->id, 'test_type' => 1])->one();
?>
<div class="subject-test-view">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
if (Yii::$app->session->hasFlash('TestChecked')) {
?>
<div class="alert alert-success">
Ваш результат: <?php
public static function getSubjectUser()
{
$res = yii\helpers\ArrayHelper::map(Subject::find()->joinWith('subjectHasUsers')->where(['subject_has_user.user_id' => Yii::$app->user->getId()])->all(), 'id', 'subject_name');
return $res;
}
