/**
* 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));
}
/**
* 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;
}
/**
* 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;
}
/**
* @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();
}
}
}
/**
* 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));
}
