public function saveSubject(Request $request, Subject $subject, Setting $setting)
{
$title = $request->input('title');
$subject->title = $title;
$subject->save();
$subject_id = $subject->id;
session(array('subject_id' => $subject_id));
$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');
$setting->subject_id = $subject_id;
$setting->lec_xlsx = session('uploads')[0];
$setting->lab_xlsx = session('uploads')[1];
$setting->sheet_number = $sheet_number;
$setting->name_cell = $name_cell;
$setting->grade_cell = $grade_cell;
$setting->cell_range = $cell_range;
$setting->header_row = $header_row;
$setting->start_row = $start_row;
$setting->end_row = $end_row;
$setting->save();
return redirect('activities/add');
}
/**
* Creates a new Subject model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Subject();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', ['model' => $model]);
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(SubjectRequest $request)
{
$data = $request->all();
unset($data['Id']);
$subject = new Subject();
$subject->fromArray($data);
$subject->save();
flash()->success("ADDED");
session(['attribute' => \Lang::get('general.SUBJECT')]);
return redirect($this->main_page);
}
/**
* Creates a new Subject model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Subject();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
$subjechHasUserModel = new SubjectHasUser();
$subjechHasUserModel->user_id = Yii::$app->user->getId();
$subjechHasUserModel->id = $model->id;
$userModel = User::findOne(Yii::$app->user->getId());
$subjechHasUserModel->user_department_id = $userModel->department_id;
$subjechHasUserModel->save();
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', ['model' => $model]);
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aPeriod !== null) {
if ($this->aPeriod->isModified() || $this->aPeriod->isNew()) {
$affectedRows += $this->aPeriod->save($con);
}
$this->setPeriod($this->aPeriod);
}
if ($this->aSubject !== null) {
if ($this->aSubject->isModified() || $this->aSubject->isNew()) {
$affectedRows += $this->aSubject->save($con);
}
$this->setSubject($this->aSubject);
}
if ($this->aStudent !== null) {
if ($this->aStudent->isModified() || $this->aStudent->isNew()) {
$affectedRows += $this->aStudent->save($con);
}
$this->setStudent($this->aStudent);
}
if ($this->aSchoolYear !== null) {
if ($this->aSchoolYear->isModified() || $this->aSchoolYear->isNew()) {
$affectedRows += $this->aSchoolYear->save($con);
}
$this->setSchoolYear($this->aSchoolYear);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
if ($this->applicationRequestsScheduledForDeletion !== null) {
if (!$this->applicationRequestsScheduledForDeletion->isEmpty()) {
foreach ($this->applicationRequestsScheduledForDeletion as $applicationRequest) {
// need to save related object because we set the relation to null
$applicationRequest->save($con);
}
$this->applicationRequestsScheduledForDeletion = null;
}
}
if ($this->collApplicationRequests !== null) {
foreach ($this->collApplicationRequests as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aCourse !== null) {
if ($this->aCourse->isModified() || $this->aCourse->isNew()) {
$affectedRows += $this->aCourse->save($con);
}
$this->setCourse($this->aCourse);
}
if ($this->aProfessor !== null) {
if ($this->aProfessor->isModified() || $this->aProfessor->isNew()) {
$affectedRows += $this->aProfessor->save($con);
}
$this->setProfessor($this->aProfessor);
}
if ($this->aSubject !== null) {
if ($this->aSubject->isModified() || $this->aSubject->isNew()) {
$affectedRows += $this->aSubject->save($con);
}
$this->setSubject($this->aSubject);
}
if ($this->aSchoolYear !== null) {
if ($this->aSchoolYear->isModified() || $this->aSchoolYear->isNew()) {
$affectedRows += $this->aSchoolYear->save($con);
}
$this->setSchoolYear($this->aSchoolYear);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
