/**
* Return select object for the Restudy Kanji list.
*
* @param integer $userId
*
* @return coreDatabaseSelect
*/
public static function getAllRestudyKanjiSelect($userId)
{
$select = self::getInstance()->select(array('reviews.framenum', 'keyword', 'successcount', 'failurecount', 'ts_lastreview' => 'UNIX_TIMESTAMP(lastreview)'))->joinLeftUsing(KanjisPeer::getInstance()->getName(), 'framenum')->where('leitnerbox=1 AND totalreviews>0');
return self::filterByUserId($select, $userId);
}
/**
* Returns Select object for My Stories component.
*
* @param
* @return
*/
public static function getMyStoriesSelect($user_id)
{
return self::getInstance()->select(array('stories.framenum', 'kanji', 'keyword', 'story' => 'text', 'stars', 'kicks', 'updated_on', 'dispdate' => 'DATE_FORMAT(updated_on, \'%b. %e, %Y\')'))->joinUsing(KanjisPeer::getInstance()->getName(), 'framenum')->joinLeft(StoryScoresPeer::TABLE, sprintf('authorid=%d AND stories.framenum=storiesscores.framenum', $user_id))->where('userid = ?', $user_id);
}
