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