/**
  * Creates a new model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  */
 public function actionCreate()
 {
     $model = new Usergroup();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['Usergroup'])) {
         $model->attributes = $_POST['Usergroup'];
         if ($model->save()) {
             $this->redirect(array('view', 'id' => $model->id));
         }
     }
     $this->render('create', array('model' => $model));
 }
Ejemplo n.º 2
0
 /**
  * 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      PropelPDO $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(PropelPDO $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 coresponding set
         // method.  This object relates to these object(s) by a
         // foreign key reference.
         if ($this->aUsergroup !== null) {
             if ($this->aUsergroup->isModified() || $this->aUsergroup->isNew()) {
                 $affectedRows += $this->aUsergroup->save($con);
             }
             $this->setUsergroup($this->aUsergroup);
         }
         if ($this->aActivity !== null) {
             if ($this->aActivity->isModified() || $this->aActivity->isNew()) {
                 $affectedRows += $this->aActivity->save($con);
             }
             $this->setActivity($this->aActivity);
         }
         // If this object has been modified, then save it to the database.
         if ($this->isModified()) {
             if ($this->isNew()) {
                 $pk = UsergroupHasActivityPeer::doInsert($this, $con);
                 $affectedRows += 1;
                 // we are assuming that there is only 1 row per doInsert() which
                 // should always be true here (even though technically
                 // BasePeer::doInsert() can insert multiple rows).
                 $this->setNew(false);
             } else {
                 $affectedRows += UsergroupHasActivityPeer::doUpdate($this, $con);
             }
             $this->resetModified();
             // [HL] After being saved an object is no longer 'modified'
         }
         $this->alreadyInSave = false;
     }
     return $affectedRows;
 }
Ejemplo n.º 3
0
 /**
  * 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      PropelPDO $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(PropelPDO $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 coresponding set
         // method.  This object relates to these object(s) by a
         // foreign key reference.
         if ($this->aRoomprofile !== null) {
             if ($this->aRoomprofile->isModified() || $this->aRoomprofile->isNew()) {
                 $affectedRows += $this->aRoomprofile->save($con);
             }
             $this->setRoomprofile($this->aRoomprofile);
         }
         if ($this->aActivity !== null) {
             if ($this->aActivity->isModified() || $this->aActivity->isNew()) {
                 $affectedRows += $this->aActivity->save($con);
             }
             $this->setActivity($this->aActivity);
         }
         if ($this->aReservationreason !== null) {
             if ($this->aReservationreason->isModified() || $this->aReservationreason->isNew()) {
                 $affectedRows += $this->aReservationreason->save($con);
             }
             $this->setReservationreason($this->aReservationreason);
         }
         if ($this->aUsergroup !== null) {
             if ($this->aUsergroup->isModified() || $this->aUsergroup->isNew()) {
                 $affectedRows += $this->aUsergroup->save($con);
             }
             $this->setUsergroup($this->aUsergroup);
         }
         if ($this->aCard !== null) {
             if ($this->aCard->isModified() || $this->aCard->isNew()) {
                 $affectedRows += $this->aCard->save($con);
             }
             $this->setCard($this->aCard);
         }
         if ($this->aUser !== null) {
             if ($this->aUser->isModified() || $this->aUser->isNew()) {
                 $affectedRows += $this->aUser->save($con);
             }
             $this->setUser($this->aUser);
         }
         if ($this->aReservationRelatedByReservationparentId !== null) {
             if ($this->aReservationRelatedByReservationparentId->isModified() || $this->aReservationRelatedByReservationparentId->isNew()) {
                 $affectedRows += $this->aReservationRelatedByReservationparentId->save($con);
             }
             $this->setReservationRelatedByReservationparentId($this->aReservationRelatedByReservationparentId);
         }
         if ($this->isNew()) {
             $this->modifiedColumns[] = ReservationPeer::ID;
         }
         // If this object has been modified, then save it to the database.
         if ($this->isModified()) {
             if ($this->isNew()) {
                 $pk = ReservationPeer::doInsert($this, $con);
                 $affectedRows += 1;
                 // we are assuming that there is only 1 row per doInsert() which
                 // should always be true here (even though technically
                 // BasePeer::doInsert() can insert multiple rows).
                 $this->setId($pk);
                 //[IMV] update autoincrement primary key
                 $this->setNew(false);
             } else {
                 $affectedRows += ReservationPeer::doUpdate($this, $con);
             }
             $this->resetModified();
             // [HL] After being saved an object is no longer 'modified'
         }
         if ($this->collReservationsRelatedByReservationparentId !== null) {
             foreach ($this->collReservationsRelatedByReservationparentId as $referrerFK) {
                 if (!$referrerFK->isDeleted()) {
                     $affectedRows += $referrerFK->save($con);
                 }
             }
         }
         if ($this->collReservationOtherMemberss !== null) {
             foreach ($this->collReservationOtherMemberss as $referrerFK) {
                 if (!$referrerFK->isDeleted()) {
                     $affectedRows += $referrerFK->save($con);
                 }
             }
         }
         $this->alreadyInSave = false;
     }
     return $affectedRows;
 }
 public function actionUpload()
 {
     parent::actionUpload();
     $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/';
     // folder for uploaded files
     $file = $folder . basename($_FILES['uploadfile']['name']);
     if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) {
         $row = 0;
         if (($handle = fopen($file, "r")) !== FALSE) {
             while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                 if ($row > 0) {
                     $model = Usergroup::model()->findByPk((int) $data[0]);
                     if ($model === null) {
                         $model = new Usergroup();
                     }
                     $model->usergroupid = (int) $data[0];
                     $useraccess = Useraccess::model()->findbyattributes(array('username' => $data[1]));
                     if ($useraccess !== null) {
                         $model->useraccessid = $useraccess->useraccessid;
                     }
                     $groupaccess = Groupaccess::model()->findbyattributes(array('groupname' => $data[2]));
                     if ($groupaccess !== null) {
                         $model->groupaccessid = $groupaccess->groupaccessid;
                     }
                     $model->recordstatus = 1;
                     try {
                         if (!$model->save()) {
                             $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
                         }
                     } catch (Exception $e) {
                         $this->messages = $this->messages . $e->getMessage();
                     }
                 }
                 $row++;
             }
         } else {
             $this->messages = $this->messages . ' memory or harddisk full';
         }
         fclose($handle);
     } else {
         $this->messages = $this->messages . ' check your directory permission';
     }
     if ($this->messages == '') {
         $this->messages = 'success';
     }
     echo $this->messages;
 }
Ejemplo n.º 5
0
 /**
  * @param int $id the id (primary key) of person
  * @param int $gid
  */
 public function updateUserGroup($userId, $newGroupId, $flag)
 {
     if ($flag == 0) {
         // Remove
         $oldModel = Usergroup::model()->find(array('select' => 'id', 'condition' => 'uid =:uid AND gid =:gid', 'params' => array(':uid' => $userId, ':gid' => $newGroupId)));
         if (isset($oldModel['id'])) {
             Usergroup::model()->findByPk($oldModel['id'])->delete();
         }
     } else {
         if ($flag == 1) {
             //Add
             $newmodel = new Usergroup();
             $newmodel->gid = $newGroupId;
             $newmodel->uid = $userId;
             $newmodel->save();
         }
     }
 }
Ejemplo n.º 6
0
 /**
  * Updates a particular model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param integer $id the ID of the model to be updated
  */
 public function actionUpdate($id)
 {
     $model = $this->loadModel($id);
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['User'])) {
         $model->attributes = $_POST['User'];
         $model->pw_md5 = md5($_POST['User']['password']);
         if ($model->save()) {
             /* REMOVE PAST GRPS*/
             $pastGrps = Usergroup::model()->findAllByAttributes(array('uid' => $id));
             foreach ($pastGrps as $ug) {
                 $m = Usergroup::model()->findByPk($ug['id']);
                 $m->delete();
             }
             /* ADD NEW GRPS */
             if (isset($_POST['User']['g_id'])) {
                 $grps = $_POST['User']['g_id'];
                 foreach ($grps as $grp) {
                     $model1 = new Usergroup();
                     $model1->uid = $model->id;
                     $model1->gid = $grp;
                     $model1->save();
                 }
             }
             /* REMOVE PAST DEPTS*/
             $pastDepts = Userdept::model()->findAllByAttributes(array('uid' => $id));
             foreach ($pastDepts as $ud) {
                 $m = Userdept::model()->findByPk($ud['id']);
                 $m->delete();
             }
             /* ADD NEW DEPTS */
             if (isset($_POST['User']['dept_id'])) {
                 $depts = $_POST['User']['dept_id'];
                 foreach ($depts as $d) {
                     $model1 = new Userdept();
                     $model1->uid = $model->id;
                     $model1->dept_id = $d;
                     $model1->save();
                 }
             }
             $this->redirect(array('view', 'id' => $model->id));
         }
     } else {
         $grpsRow = Usergroup::model()->findAllByAttributes(array('uid' => $id));
         $grps = [];
         foreach ($grpsRow as $row) {
             $grps[] = $row['gid'];
         }
         $model->g_id = $grps;
         $deptsRow = Userdept::model()->findAllByAttributes(array('uid' => $id));
         $depts = [];
         foreach ($deptsRow as $row) {
             $depts[] = $row['dept_id'];
         }
         $model->dept_id = $depts;
     }
     $this->render('update', array('model' => $model));
 }