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; }