예제 #1
0
 /**
  * Remove user from dept
  * @param type $person_id
  * @return type
  */
 public function removeUserFromDept($person_id)
 {
     $now = new CDbExpression('NOW()');
     $creator = Yii::app() instanceof CWebApplication ? Yii::app()->user->id : NULL;
     return Yii::app()->db->createCommand()->update(DeptUser::model()->tableName(), array('has_left' => 1, 'date_left' => $now, 'last_modified' => $now, 'last_modified_by' => $creator), '`person_id`=:t1 AND `has_left`=:t2', array(':t1' => $person_id, ':t2' => 0));
 }
예제 #2
0
 /**
  * Update user dept
  */
 public function updateDeptUser()
 {
     if (!empty($this->dept_id)) {
         if (!DeptUser::model()->exists('`person_id`=:t1 AND `dept_id`=:t2 AND `has_left`=:t3', array(':t1' => $this->id, ':t2' => $this->dept_id, ':t3' => 0))) {
             DeptUser::model()->removeUserFromDept($this->id);
             DeptUser::model()->addUserToDept(array('person_id' => $this->id, 'dept_id' => $this->dept_id, 'date_created' => new CDbExpression('NOW()'), 'created_by' => Yii::app() instanceof CWebApplication ? Yii::app()->user->id : NULL));
         }
     } else {
         DeptUser::model()->removeUserFromDept($this->id);
     }
 }