/** * 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); }