public function register($attr, $image) { $check = User::model()->findByAttributes(array('email' => $attr['email'])); if ($check) { return 'USER_EXIST'; } else { $model = new User(); $model->setAttributes($attr); $model->password = md5($attr['password']); if ($model->save(FALSE)) { $image_url = NULL; if (isset($image)) { $image_url = $image; } $model->avatar = $image_url; $model->save(FALSE); $subjects = Subject::model()->findAll(); foreach ($subjects as $subject) { $user_subject = new UserSubject(); $user_subject->subject_id = $subject->subject_id; $user_subject->user_id = $model->userid; $user_subject->save(FALSE); } return 'SUCCESS'; } return 'SERVER_ERROR'; } }
public function getSubjectByUser($user_id) { $data = UserSubject::model()->findAllByAttributes(array('user_id' => $user_id)); $returnArr = array(); foreach ($data as $item) { $itemArr = array(); $itemArr = $this->findSubjectById($item->subject_id); $returnArr[] = $itemArr; } return $returnArr; }
public function getPostBySubjectUser($user_id, $limit, $offset) { $returnArr = array(); $subject_arr = array(); $subject = UserSubject::model()->findAllByAttributes(array('user_id' => $user_id)); foreach ($subject as $item) { $itemArr = array(); $itemArr = $item->subject_id; $subject_arr[] = $itemArr; } $criteria = new CDbCriteria(); $criteria->addInCondition('subject_id', $subject_arr); $criteria->order = 'post_id'; $criteria->limit = $limit; $criteria->offset = $offset; $post = PostSubject::model()->findAll($criteria); foreach ($post as $item) { $itemArr = array(); $itemArr = $this->getPostById($item->post_id); $returnArr[] = $itemArr; } return $returnArr; }