/** * * @return sfDoctrinePager */ protected function getPager() { $p = new sfDoctrinePager('sfGuardUser', 10); $p->setQuery($this->getQuery()); $p->setPage($this->getPage()); return $p; }
protected function getPager(Doctrine_Query $q, $page, $size) { $pager = new sfDoctrinePager('Bbs', $size); $pager->setQuery($q); $pager->setPage($page); return $pager; }
/** * Retrieves a pager of recent associations * @param string model name * @return Pager */ public static function listRecentChangesPager($doc_id = null, $users = null, $orderby = null, $npp = 25) { // TODO: possibility to filter on association type? $pager = new sfDoctrinePager('AssociationLog', $npp); $q = $pager->getQuery(); $q->select('al.*, mi.name, mi.search_name, li.name, li.search_name, u.username, u.login_name, u.topo_name')->from('AssociationLog al')->leftJoin('al.mainI18n mi')->leftJoin('al.linkedI18n li')->leftJoin('al.user_private_data u'); // filter on a specific doc if needed if ($doc_id) { $q->addWhere('al.main_id=? OR al.linked_id=?', array($doc_id, $doc_id)); } // filter on a specific user if needed if ($users) { $users = explode('-', $users); if (count($users)) { $where_ids = array(); foreach ($users as $uid) { $where_ids[] = '?'; } $where_ids = implode(', ', $where_ids); if (count($where_ids) == 1) { $where = ' = ' . $where_ids; } else { $where = ' IN ( ' . $where_ids . ' )'; } $q->addWhere('u.id' . $where, $users); } } if (empty($orderby)) { $q->orderBy('al.associations_log_id DESC'); // ~ decreasing time (but faster, since there is an index on this field). } elseif ($orderby == 'uid') { $q->orderBy('u.id ASC'); } return $pager; }
public function buildDataGrid(sfWebRequest $request) { if ($this->table_method) { $typeTable = Doctrine_Core::getTable($this->ContentType->name); $method = $this->table_method; $q = $typeTable->{$method}($this, $request); if ($q instanceof sfSympalDataGrid) { $dataGrid = $q; } else { if ($q instanceof sfDoctrinePager || $q instanceof Doctrine_Query_Abstract) { $dataGrid = sfSympalDataGrid::create($q); } else { throw new sfException(sprintf('ContentList table_method must return an instance of sfSympalDataGrid, sfDoctrinePager or Doctrine_Query_Abstract. An instance of "%s" was returned.', get_class($q))); } } } else { $pager = new sfDoctrinePager('sfSympalContent'); $pager->setQuery($this->_buildQuery($request)); $dataGrid = sfSympalDataGrid::create($pager)->addColumn('c.title', 'renderer=sympal_data_grid/default_title')->addColumn('c.date_published')->addColumn('u.username', 'label=Created By'); } if ($this->sort_column) { $dataGrid->setDefaultSort($this->sort_column, $this->sort_order); } $dataGrid->setMaxPerPage($this->rows_per_page > 0 ? $this->rows_per_page : sfSympalConfig::get('rows_per_page', null, 10)); $dataGridRequestInfo = $request->getParameter($dataGrid->getId()); return $dataGrid; }
/** * Get the navigation links for given sfDoctrinePager instance * * @param sfDoctrinePager $pager * @param string $uri The uri to prefix to the links * @return string $html */ function get_sympal_pager_navigation($pager, $uri, $requestKey = 'page') { sympal_use_stylesheet('/sfSympalPlugin/css/pager.css'); $navigation = '<div class="sympal_pager_navigation">'; if ($pager->haveToPaginate()) { $uri .= (preg_match('/\\?/', $uri) ? '&' : '?') . $requestKey . '='; // First and previous page if ($pager->getPage() != 1) { $navigation .= link_to(image_tag('/sf/sf_admin/images/first.png', 'align=absmiddle'), $uri . '1'); $navigation .= link_to(image_tag('/sf/sf_admin/images/previous.png', 'align=absmiddle'), $uri . $pager->getPreviousPage()) . ' '; } // Pages one by one $links = array(); foreach ($pager->getLinks() as $page) { $links[] = '<span>' . link_to_unless($page == $pager->getPage(), $page, $uri . $page) . '</span>'; } $navigation .= join(' ', $links); // Next and last page if ($pager->getPage() != $pager->getLastPage()) { $navigation .= ' ' . link_to(image_tag('/sf/sf_admin/images/next.png', 'align=absmiddle'), $uri . $pager->getNextPage()); $navigation .= link_to(image_tag('/sf/sf_admin/images/last.png', 'align=absmiddle'), $uri . $pager->getLastPage()); } } $navigation .= '</div>'; return $navigation; }
public function getRecentPager($page = 1, $size = 20) { $pager = new sfDoctrinePager('PluginPackage', $size); $pager->setQuery($this->getRecentReleaseQuery($size)); $pager->setPage($page); $pager->init(); return $pager; }
protected function getPager(Doctrine_Query $query) { $pager = new sfDoctrinePager('Fortune', sfConfig::get('app_fortunes_max_items', 10)); $pager->setQuery($query); $pager->setPage($this->getRequest()->getParameter('page', 1)); $pager->init(); return $pager; }
public function getPager() { $pager = new sfDoctrinePager('NewItem', 5); $pager->setQuery($this->getNewsQuery()); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); return $pager; }
public function getPager(Member $member, $page = 1, $size = 20) { $q = $this->getQuery($member); $pager = new sfDoctrinePager('DiaryCommentUpdate', $size); $pager->setQuery($q); $pager->setPage($page); return $pager; }
public function getResultListPager(Doctrine_Query $query, $page = 1, $size = 20) { $pager = new sfDoctrinePager('CommunityTopic', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getMangaListPagerByMemberId($memberId, $page = 1, $size = 20) { $q = $this->createQuery()->where('member_id', $memberId)->orderBy('updated_at'); $pager = new sfDoctrinePager('CcccManga', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
protected function getPager( $size = 50 ) { $pager = new sfDoctrinePager('dsPerson', $size); // adusting size possible !! set 0 to deactivate $pager->setQuery($this->buildQuery()); $pager->setPage($this->getRequest()->getParameter('page')); $pager->init(); return $pager; }
public function getListPager($memberId, $page = 1, $size = 20) { $pager = new sfDoctrinePager('OpenIDTrustLog', $size); $q = $this->createQuery()->andWhere('member_id = ?', $memberId); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
/** * get pager for assets * @param array $params * @param string $sort * @param integer $page * @param integer $size * @return sfPager */ public function getPager(array $params, $sort = 'name', $page = 1, $size = 20) { $query = $this->search($params, $sort); $pager = new sfDoctrinePager('sfAsset', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getMemberPager($memberId, $accessMemberId, $size, $page = 1) { $q = $this->createQuery("g")->where("g.member_id = ?", $memberId)->orderBy("id DESC"); $pager = new sfDoctrinePager("Geocode", $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
public function getForUserPager($user_id, $page = 1, $max_per_page = 10) { $q = $this->getForUserCriteria($user_id); $pager = new sfDoctrinePager('sfSimpleForumTopic', $max_per_page); $pager->setPage($page); $pager->setQuery($q); $pager->init(); return $pager; }
/** * 下書きメッセージ一覧 * @param $member_id * @param $page * @param $size * @return Message object(の配列) */ public function getDraftMessagePager($member_id, $page = 1, $size = 20) { $q = $this->createQuery()->andWhere('member_id = ?', $member_id)->andWhere('is_deleted = ?', false)->andWhere('is_send = ?', false)->orderBy('created_at DESC'); $pager = new sfDoctrinePager('SendMessageData', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
protected function getPager(sfWebRequest $request) { $q = Doctrine::getTable('AlbumComment')->createQuery()->where('album_id = ?', $this->album->id)->orderBy('created_at DESC'); $pager = new sfDoctrinePager('AlbumComment'); $pager->setQuery($q); $pager->setPage($request['commentPage']); $pager->setMaxPerPage($this->size); return $pager; }
/** * Get introFriend pager * @param int $memberIdTo member id * @param int $page page number * @param int $size show number * @return pager pager */ public function getListPager($memberIdTo, $page = 1, $size = 20) { $pager = new sfDoctrinePager('IntroFriend', $size); $pager->setQuery($this->getListQuery($memberIdTo)); $pager->setPage($page); $pager->init(); return $pager; }
public function getPager($packageId, $page = 1, $size = 20) { $q = Doctrine::getTable('Member')->createQuery('m')->where('p.package_id = ?', $packageId)->innerJoin('m.PluginMember p'); $pager = new sfDoctrinePager('Member', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
public function getListPager($op2CommunityId, $page = 1, $size = 20) { $query = $this->createQuery()->where('op2_community_id = ?', $op2CommunityId)->orderBy('created_at DESC'); $pager = new sfDoctrinePager('Op2CommunityEvent', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getListPager($page = 1, $size = 20) { $query = $this->createQuery()->orderBy('updated_at DESC'); $pager = new sfDoctrinePager('VoteQuestion', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getListPager($page = 1, $size = 20) { $query = $this->createQuery('r')->leftJoin('r.ChatContent c')->groupBy('r.id')->orderBy('MAX(c.created_at) DESC'); $pager = new sfDoctrinePager('ChatRoom', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getListPager($room, $page = 1, $size = 20) { $query = $this->createQuery()->where('chat_room_id = ?', $room->id)->andWhere('level >= 5')->orderBy('number'); $pager = new sfDoctrinePager('ChatContent', $size); $pager->setQuery($query); $pager->setPage($page); $pager->init(); return $pager; }
public function getMemberPluginPager($memberId, $page = 1, $size = 20) { $q = $this->createQuery()->where('id IN (SELECT pm.package_id FROM PluginMember pm WHERE pm.member_id = ? AND pm.is_active = ?)', array($memberId, true)); $pager = new sfDoctrinePager('PluginPackage', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
public function getTrackPager( $page = 0 ) { $pager = new sfDoctrinePager('dsClass', 20); $pager->setQuery( $this->getTrackQuery() ); $pager->setPage( $page ); $pager->init(); return $pager; }
public function getFriendListPager($memberId, $page = 1, $size = 20) { $subQuery = Doctrine::getTable('MemberRelationship')->createQuery()->select('mr.member_id_to')->from('MemberRelationship mr')->where('member_id_from = ?')->andWhere('is_friend = ?'); $q = Doctrine::getTable('Member')->createQuery()->where('id IN (' . $subQuery->getDql() . ')', array($memberId, true)); $pager = new sfDoctrinePager('Member', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
/** * 削除済みメッセージ一覧 * @param integer $memberId * @param integer $page * @param integer $size * @return DeletedMessage object(の配列) */ public function getDeletedMessagePager($memberId = null, $page = 1, $size = 20) { $q = $this->addDeleteMessageQuery($this->createQuery(), $memberId); $q->orderBy('created_at DESC'); $pager = new sfDoctrinePager('DeletedMessage', $size); $pager->setQuery($q); $pager->setPage($page); $pager->init(); return $pager; }
/** * Fetch images from pool according to any default tag(s) option specified * in the global schema.yml. * Override added to specify per tag in MooEditable * * @return sfDoctrinePager */ public function getPager($per_page = 12, $page = 1, $tagged_object = null, $tag = null) { $pager = new sfDoctrinePager($this->getClassnameToReturn(), $per_page); $im = new sfImagePoolImage(); if (!$im->option('tagging')) { $tagged_object = $tag = null; } $im->free(true); if (isset($tagged_object) && ($tag = $tagged_object->getTagRestriction())) { $query = TagTable::getObjectTaggedWithQuery($this->getClassnameToReturn(), $tag, $pager->getQuery(), array('nb_common_tags' => 1)); $pager->setQuery($query); } else { if (!empty($tag)) { // If only tags we have no taggable object // So get images tagged with this query and do a whereIn on the ids $tags = explode(',', $tag); $images = TagTable::getObjectTaggedWith($tags, array('model' => 'sfImagePoolImage', 'nb_common_tags' => 1)); $image_ids = array(); foreach ($images as $image) { $image_ids[] = $image->id; } if (!empty($image_ids)) { $pager->getQuery()->whereIn('sfImagePoolImage.id', $image_ids); } else { $pager->getQuery()->where('false'); } // we have no images tagged } } $pager->getQuery()->orderBy('updated_at DESC'); $pager->setPage($page); $pager->init(); return $pager; }
public function getPager($page = 1, $size = 20, $isCheckActive = false, $isPc = null, $isMobile = null) { if (!$this->isValid()) { throw $this->getErrorSchema(); } $query = Doctrine::getTable('Application')->createQuery('a')->leftJoin('a.Translation t'); if ($isCheckActive) { $query->where('a.is_active = ?', true); } if (null !== $isPc) { $query->andWhere('a.is_pc = ?', $isPc); } if (null !== $isMobile) { $query->andWhere('a.is_mobile = ?', $isMobile); } $keywords = $this->getValue('keyword'); if ($keywords) { if (!is_array($keywords)) { $keywords = array($keywords); } foreach ($keywords as $keyword) { $query->addWhere('t.title LIKE ?', '%' . $keyword . '%'); } } $orderBy = $this->getValue('order_by'); if (!$orderBy) { $orderBy = 'created_at_desc'; } $isDesc = false; if (preg_match('/_desc$/', $orderBy)) { $isDesc = true; $orderBy = substr($orderBy, 0, strlen($orderBy) - 5); } $orderByDql = null; switch ($orderBy) { case 'created_at': $orderByDql = 't.created_at'; break; case 'users': $subquery = Doctrine::getTable('MemberApplication')->createQuery('ma')->select('COUNT(*)')->where('ma.application_id = a.id'); $query->select('*, (' . $subquery->getDql() . ') AS users'); $orderByDql = 'users'; } if ($orderByDql) { if ($isDesc) { $orderByDql .= ' DESC'; } $query->orderBy($orderByDql); } $pager = new sfDoctrinePager('Application', $size); $pager->setQuery($query); $pager->getPage($page); $pager->init(); return $pager; }