public function testSetRoomScheduleCourse() { $roomsched = new RoomSchedule(); $course = new Course(); $course->setCourseCode("IT 197"); $roomsched->setCourseCode($course->getCourseCode()); $this->assertEquals("IT 197", $course->getCourseCode()); $this->assertEquals("IT 197", $roomsched->getCourseCode()); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(CourseRequest $request) { $data = $request->all(); unset($data['Id']); $course = new Course(); $course->fromArray($data); $course->save(); flash()->success("ADDED"); session(['attribute' => \Lang::get('general.COURSE')]); return redirect($this->main_page); }
public function testSetCourse() { $course = new Course(); $course->setCourseCode("IT 197"); $course->setDescription("Supervised On-the-Job Training"); $course->setUnits(12); $course->setSemester("2nd"); $this->assertEquals("IT 197", $course->getCourseCode()); if ($course->getCourseCode() == "IT 197") { $this->assertEquals("Supervised On-the-Job Training", $course->getDescription()); $this->assertEquals(12, $course->getUnits()); $this->assertEquals("2nd", $course->getSemester()); } }
/** * Show the form for creating a new resource. * * @param $courseId * @return \Illuminate\Http\Response */ public function create($courseId) { $userId = Auth::user()->id; $tests = Test::where('user_id', '=', $userId)->get(); $course = Course::find($courseId); return view('course.lesson.create', ['course' => $course, 'tests' => $tests]); }
/** * @param $courseId * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function show($courseId) { $course = Course::findOrFail($courseId); $lessons = $course->lessons; $members = $course->users; return view('mark.show', ['members' => $members, 'lessons' => $lessons, 'course' => $course]); }
/** * Creates a new Task model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $course_id = Yii::$app->request->get('course_id'); $model = new Task(); if ($model->load(Yii::$app->request->post())) { $model = $model->validateAttr($model); if (empty($model->errors)) { $resourceModel = new Resource(); $model = $resourceModel->uploadImg($model, 'image'); if ($model->save()) { return $this->redirect(['view', 'id' => $model->id]); } } } $model->course_id = $course_id; if (!json_decode($model->answer_json)) { $model->answer_json = ''; } $chapterName = $courseName = null; if (!empty($course_id)) { $chapterName = Course::findModel($course_id)->name; $courseName = Course::findRoot($course_id)->name; } return $this->render('create', ['model' => $model, 'courseId' => $course_id, 'chapterName' => $chapterName, 'courseName' => $courseName]); }
public function getInstitute() { if ($this->course_id != NULL) { $institute_id = Course::find()->select(['institute_id'])->where(['id' => $this->course_id])->one()->institute_id; $institute = Institute::findOne(['id' => $institute_id]); return $institute; } }
protected function findModel($id) { if (($model = Course::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function postCreate(Request $request) { $input = $request->only(['year', 'name']); $input['user_id'] = Auth::id(); Course::create($input); flash()->success('Kurz bol vytvorený'); return redirect()->back(); }
public function detachFrom(Request $request) { $this->validate($request, ['classroom_id' => 'required', 'course_id' => 'required'], ['required' => 'Kolom :attribute diperlukan']); $course = Course::findOrFail($request->course_id); $course->classrooms()->detach($request->classroom_id); \Flash::success('Materi berhasil batalkan.'); return redirect()->back(); }
/** * get User Courses * @param type $userId * @return type */ public static function getUserCourses($userId = null) { if (empty($userId)) { $userId = \app\components\OvcUser::getCurrentUser()->id; } $userCourseIds = self::getCourseIdsByUserId($userId); return Course::findAll(['id' => $userCourseIds]); }
public function actionDelete($id) { $item = Course::findByPK($id); if (empty($item)) { $this->redirect('/admin/courses'); } $item->delete(); $this->redirect('/admin/courses'); }
public static function courseDropDown() { $courses = Course::find()->all(); //$courses = Course::courseDropDown(); //$courseList = ArrayHelper::map($courses, 'id', 'courseName'); foreach ((array) $courses as $course) { echo "<option value='" . $course->id . "'>" . $course->courseName . "</option>"; } }
public static function getQuestionList($courseId) { $courseModel = Course::findOneById($courseId); if (Course::isRoot($courseModel)) { return static::find()->where(['root_id' => $courseId])->orderBy('create_time DESC')->all(); } if (Course::isFile($courseModel)) { return static::find()->where(['course_id' => $courseId])->orderBy('create_time DESC')->all(); } }
/** * 显示学生详细成绩单 * @author FuRongxin * @date 2016-01-25 * @version 2.0 * @param string $kch 8位课程号 * @return \Illuminate\Http\Response 学生成绩单 */ public function show($kch) { // 过程成绩 $detail = Dtscore::detailScore(Auth::user(), $kch)->select('xh', 'xm', 'kcxh', 'kcpt', 'kcxz', 'nd', 'xq', 'kh', 'cj1', 'cj2', 'cj3', 'cj4', 'cj5', 'cj6', 'zpcj', 'kszt', 'tjzt'); // 补考成绩 $makeup = Muscore::makeupScore(Auth::user(), $kch)->select('xh', 'xm', 'kcxh', 'kcpt', 'kcxz', 'nd', 'xq', 'kh', 'cj1', 'cj2', 'cj3', 'cj4', 'cj5', 'cj6', 'zpcj', 'kszt', 'tjzt'); $scores = $detail->union($makeup)->orderBy('nd', 'desc')->orderBy('xq', 'desc')->get(); $ratios = $this->_arrangeScores($scores); return view('score.show')->withTitle(Course::find($kch)->kcmc . '课程详细成绩单')->withRatios($ratios); }
public static function commentList($courseId) { $courseModel = Course::findModel($courseId); if (Course::isFile($courseModel)) { return static::find()->where(['course_id' => $courseId, 'comment_type' => self::COMMENT_TYPE_COMMENT])->orderBy('comment_time DESC')->all(); } if (Course::isRoot($courseModel)) { return static::find()->where(['root_id' => $courseId, 'comment_type' => self::COMMENT_TYPE_COMMENT])->orderBy('comment_time DESC')->all(); } }
public function actionCertification() { //$searchModel = new CourseSearch(); //$dataProvider = $searchModel->search(Yii::$app->request->queryParams); //$dataProvider->pagination->pageSize = 0; $query = Course::find()->where(['category_id' => '5']); $dataProvider = new ActiveDataProvider(['query' => $query]); $cat = new Category(); return $this->render('mos', ['dataProvider' => $dataProvider, 'cat' => $cat]); //return $this->render('mos'); }
public function actionDefault($course = null) { if (null === $course) { $this->data->course = 'all'; $this->data->courses = Course::findAll(); } else { $this->data->course = Course::findByPK($course); $this->data->item = new Lesson(); $this->data->item->course = $this->data->course; } }
public static function getLearnPercent($userId, $courseId) { $fileCount = Course::fileCount($courseId); $userPlayModels = static::findAll(['user_id' => $userId, 'learn_status' => self::LEARN_STATUS_FINISH]); $count = 0; foreach ($userPlayModels as $userPlayModel) { if (Course::findOneById($userPlayModel->chapter_id)->root == $courseId) { $count++; } } return round($count / $fileCount, 2); }
public function addOperation() { if ($this->currency_id != '1') { $course = new Course(); if (!$course->checkCourse($this->currency_id)) { $course->currency_id = $this->currency_id; $currency = Currency::findOne($this->currency_id); $course->course = $course->getCourse($currency->iso); if (!$course->save()) { throw new ErrorException('Курс не обновлен' . var_dump($course)); } } } $operation = new Operation(); $operation->user_id = Yii::$app->getUser()->id; $operation->category_id = $this->category_id === '' ? 1 : $this->category_id; $operation->currency_id = $this->currency_id === '' ? 1 : $this->currency_id; $operation->summ = $this->operation_type == 'income' ? $this->summ * 100 : $this->summ * -100; $operation->description = $this->description; return $operation->save() ? $operation : null; }
/** * @GET("/profile", as="profile.index") * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function index() { $profile = $this->profile->profileWithUser(); $courses_raw = Course::with('currency')->get(); $courses = $courses_raw->filter(function ($value) { return $value->id != 11; }); if (!$profile->wallet) { \Session::flash('message', 'Пожалуйста, укажите Elcoin кошелек и полностью заполните профиль, если у Вас нет кошелька, зарегистрируйтесь в системе Elephant: https://elcoin.space'); } return view('profile.profile', compact('profile', 'courses')); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Course::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Yii::$app->params['pageSize']]]); $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, 'created_at' => $this->created_at, 'modified_at' => $this->modified_at]); $query->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Course::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, 'name' => $this->name, 'leerlijn_id' => $this->leerlijn_id]); $query->andFilterWhere(['like', 'tud_id', $this->tud_id]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Course::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(['category_id' => $this->category_id, 'price' => $this->price, 'created_dt' => $this->created_dt]); $query->andFilterWhere(['like', 'course_id', $this->course_id])->andFilterWhere(['like', 'course_name', $this->course_name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'course_detail', $this->course_detail])->andFilterWhere(['like', 'duration', $this->duration])->andFilterWhere(['like', 'f_jan', $this->f_jan])->andFilterWhere(['like', 'f_feb', $this->f_feb])->andFilterWhere(['like', 'f_mar', $this->f_mar])->andFilterWhere(['like', 'f_apr', $this->f_apr])->andFilterWhere(['like', 'f_may', $this->f_may])->andFilterWhere(['like', 'f_jun', $this->f_jun])->andFilterWhere(['like', 'f_july', $this->f_july])->andFilterWhere(['like', 'f_aug', $this->f_aug])->andFilterWhere(['like', 'f_sep', $this->f_sep])->andFilterWhere(['like', 'f_oct', $this->f_oct])->andFilterWhere(['like', 'f_nov', $this->f_nov])->andFilterWhere(['like', 'f_dec', $this->f_dec])->andFilterWhere(['like', 'level', $this->level])->andFilterWhere(['like', 'status', $this->status])->andFilterWhere(['like', 'photo', $this->photo]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Course::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->joinWith('crsCt'); $query->andFilterWhere(['crs_id' => $this->crs_id, 'crs_duration' => $this->crs_duration, 'crs_days' => $this->crs_days, 'crs_wkly_hrs' => $this->crs_wkly_hrs, 'crs_active' => $this->crs_active]); $query->andFilterWhere(['like', 'crs_desc', $this->crs_desc])->andFilterWhere(['like', 'crs_drtn_type', $this->crs_drtn_type])->andFilterWhere(['like', 'crs_disp_id', $this->crs_disp_id])->andFilterWhere(['like', 'course_type.ct_desc', $this->crs_ct_id]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Course::find(); $query->joinWith(['institute']); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['institute'] = ['asc' => ['institute.name' => SORT_ASC], 'desc' => ['institute.name' => SORT_DESC]]; if (!($this->load($params) && $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, 'institute_id' => $this->institute_id]); $query->andFilterWhere(['like', 'name', $this->name]); $query->andFilterWhere(['like', 'institute.name', $this->institute]); return $dataProvider; }
public function actionRegister($co = null, $cl = null) { $model = new Student(); if ($model->load(Yii::$app->request->post())) { $model->course_id = $co; $model->classid = $cl; $model->created_dt = date('Y-m-d H:i:s'); $model->save(); return $this->redirect(['success']); //return $this->redirect(['view', 'id' => $model->id]); } else { if (!empty($co)) { $courselist = Course::findOne($co); } return $this->render('register', ['model' => $model, 'courselist' => $courselist]); } }
/** * Deletes an existing CourseType model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { try { // $this->findModel($id)->delete(); $ct = $this->findModel($id); //$crs = $ct->courses; //$cls = $ct->clsses; $crs_count = Course::find()->where(['crs_ct_id' => $id])->count(); $cls_count = Clss::find()->where(['clss_ct_id' => $id])->count(); Yii::$app->session->setFlash('message', "You cannot delete this record!"); if ($crs_count == 0 && $cls_count == 0) { $ct->delete(); // Yii::$app->session->setFlash('success','The car was successfully deleted'); // foreach (Yii::$app->session->getAllFlashes() as $key => $message) { echo '<div class="alert alert-success">' . 'The car was successfully deleted' . '</div>'; // } } else { //header("HTTP/1.0 400 Relation Restriction"); Yii::$app->session->setFlash('message', "You cannot delete this record!"); } } catch (CDbException $e) { if ($e->errorInfo[1] == 1451) { header("HTTP/1.0 400 Relation Restriction"); echo "Your error message.\n"; } else { throw $e; } // } catch (IntegrityException $e) { // if($e->getCode()===23000){ //You can have nother error handling // header("HTTP/1.0 400 Relation Restriction"); // }else{ // throw $e; //} } return $this->redirect(['index']); }
/** * @POST("/purchase", as="purchase.store") * @param Purchase $purchase * @param Request $request * @return \Illuminate\Http\RedirectResponse */ public function store(Purchase $purchase, Request $request) { $data = $request->all(); if ((int) $data['amount'] <= 0) { return redirect()->route('profile.index')->with('message', 'Некорректная сумма вклада!'); } $type1 = TypePurchase::where('id', 1)->first(); $type2 = TypePurchase::where('id', 2)->first(); $type3 = TypePurchase::where('id', 3)->first(); $user = User::where('id', $request->input('user_id'))->first(); $course = Course::where('currency_id', $request->input('currency_id'))->first(); $data['course'] = $course->course_purchase; if ($request->input('status_trust') === 'true') { $data['status_trust'] = 1; $purchase->fill($data); $purchase->type()->associate($type2); $purchase->user()->associate($user); $purchase->course()->associate($course); $purchase->save(); } elseif (!$request->input('total')) { $data['total'] = $request->input('amount'); $purchase->fill($data); $purchase->type()->associate($type3); $purchase->user()->associate($user); $purchase->course()->associate($course); $purchase->save(); } else { $purchase->fill($data); $purchase->type()->associate($type1); $purchase->user()->associate($user); $purchase->course()->associate($course); $purchase->save(); } return redirect()->route('profile.index')->with('message', 'Заявка сделана! Свои оперции Вы можете посмотреть в разделе "Мои операции"'); }
/** * 显示评教结果 * @author FuRongxin * @date 2016-03-30 * @version 2.0 * @param \Illuminate\Http\Request $request 评教结果请求 * @param string $kcxh 12位课程序号 * @return \Illuminate\Http\Response 评教结果 */ public function show(Request $request, $kcxh) { $inputs = $request->all(); $table = $inputs['year'] . $inputs['term'] . 't'; $mark = $inputs['year'] . $inputs['term'] . 'Mark'; // 获取评教分值 $data = DB::connection('pgset')->selectOne('SELECT AVG(s_jxtd) AS jxtd, AVG(s_jxnr) AS jxnr, AVG(s_jxff) AS jxff, AVG(s_jxxg) AS jxxg, AVG(s_zhpf) As zhpf FROM "' . $table . '" WHERE c_kcxh = ? and c_jsgh = ? GROUP BY c_kcbh, c_jsgh', [$kcxh, Auth::user()->jsgh]); $scores = []; if (count($data)) { $scores = ['1' => sprintf('%.2f', $data->jxtd), '2' => sprintf('%.2f', $data->jxnr), '3' => sprintf('%.2f', $data->jxff), '4' => sprintf('%.2f', $data->jxxg), 'zhpf' => sprintf('%.2f', $data->zhpf)]; $categories = DB::connection('pgset')->select('SELECT a.zb_id, a.zb_mc, COUNT(*) AS total FROM t_zb_yjzb a, t_zb_ejzb b WHERE a.zb_id = b.zb_id GROUP BY a.zb_id, a.zb_mc ORDER BY a.zb_id'); foreach ($categories as $category) { $items = DB::connection('pgset')->select('SELECT ejzb_id, ejzb_mc, AVG(s_mark) AS mark FROM "' . $mark . '", t_zb_ejzb WHERE c_xm = CAST(ejzb_id AS TEXT) AND zb_id = ? AND c_kcxh = ? AND c_jsgh = ? GROUP BY ejzb_id, ejzb_mc, c_kcbh, c_jsgh, c_xm ORDER BY ejzb_id', [$category->zb_id, $kcxh, Auth::user()->jsgh]); $scores['zb'][$category->zb_id] = ['zb_mc' => $category->zb_mc, 'total' => $category->total]; foreach ($items as $item) { $scores['zb'][$category->zb_id]['ejzb'][] = ['ejzb_id' => $item->ejzb_id, 'ejzb_mc' => $item->ejzb_mc, 'score' => sprintf('%.2f', $item->mark)]; } } } // 获取评教评语 $comments = DB::connection('pgset')->select('SELECT c_yd, c_qd, c_one, c_xh FROM t_zl_xspy a INNER JOIN "' . $table . '" b ON a.c_kcxh = b.c_kcxh WHERE a.c_nd = ? AND a.c_xq = ? AND b.c_jsgh = ? AND b.c_kcxh = ?', [$inputs['year'], $inputs['term'], Auth::user()->jsgh, $kcxh]); $title = $inputs['year'] . '年度' . Term::find($inputs['term'])->mc . '学期' . $kcxh . Course::find(Helper::getCno($kcxh))->kcmc . '课程'; return view('set.show')->withTitle($title . '评教结果')->withScores($scores)->withComments($comments); }