/** * Searches passengers by some criteria * @param int $max Maximum people per page * @param int $page * @return sfPropelPager */ public static function getPager($max = 10, $page = 1, $firstname = null, $lastname = null, $city = null, $state = null, $country = null, $county = null, $exclude_ids = array()) { $c = new Criteria(); $c->addJoin(self::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); if ($firstname) { $c->add(PersonPeer::FIRST_NAME, $firstname . '%', Criteria::LIKE); } if ($lastname) { $c->add(PersonPeer::LAST_NAME, $lastname . '%', Criteria::LIKE); } if ($city) { $c->add(PersonPeer::CITY, $city . '%', Criteria::LIKE); } if ($state) { $c->add(PersonPeer::STATE, $state . '%', Criteria::LIKE); } if ($country) { $c->add(PersonPeer::COUNTRY, $country . '%', Criteria::LIKE); } if ($county) { $c->add(PersonPeer::COUNTY, $county . '%', Criteria::LIKE); } if (!empty($exclude_ids)) { $c->add(self::ID, $exclude_ids, Criteria::NOT_IN); } $c->addAscendingOrderByColumn(PersonPeer::FIRST_NAME); $pager = new sfPropelPager('Passenger', $max); $pager->setPeerMethod('doSelectJoinPerson'); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
/** * Executes index action * * @param sfWebRequest $request */ public function executeIndex(sfWebRequest $request) { $this->filter = new PropertyFormFilter(); //$this->property_list = PropertyPeer::doSelect(new Criteria()); $this->sort = $this->getRequestParameter('sort'); $this->sort_type = $this->getRequestParameter('sort_type'); $criteria = new Criteria(); if (!is_null($this->sort)) { if (!is_null($this->sort_type) && $this->sort_type == 'desc') { $criteria->addDescendingOrderByColumn(PropertyPeer::$this->sort); } elseif (!is_null($this->sort_type) && $this->sort_type == 'asc') { $criteria->addAscendingOrderByColumn(PropertyPeer::$this->sort); } } if ($request->hasParameter('property_filters')) { $property_filters = $request->getParameter('property_filters'); $this->filter->bind($property_filters); if ($this->filter->isValid()) { !empty($property_filters['municipality']['text']) ? $criteria->add(PropertyPeer::MUNICIPALITY, "%" . $property_filters['municipality']['text'] . "%", Criteria::LIKE) : null; !empty($property_filters['offer_id']) ? $criteria->add(PropertyPeer::OFFER_ID, $property_filters['offer_id']) : null; !empty($property_filters['type_id']) ? $criteria->add(PropertyPeer::TYPE_ID, $property_filters['type_id']) : null; !empty($property_filters['typology_id']) ? $criteria->add(PropertyPeer::TYPOLOGY_ID, $property_filters['typology_id']) : null; !empty($property_filters['state_id']) ? $criteria->add(PropertyPeer::STATE_ID, $property_filters['state_id']) : null; !empty($property_filters['price']['text']) ? $criteria->add(PropertyPeer::PRICE, $property_filters['price']['text'], Criteria::LESS_EQUAL) : null; } } $pager = new sfPropelPager('Property', sfConfig::get('app_max_propertyes_list', 20)); $pager->setPeerMethod('doSelectJoinAll'); $pager->setCriteria($criteria); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; }
public static function getWidgetOrderedPager($order, $pageSize, $page, $criteria = null) { $c = $criteria; if ($c == null) { $c = new Criteria(); } if ($order) { $order_dir = 1; if ($order[0] == '+' || $order[0] == '-') { $order_dir = $order[0] == '+' ? $order_dir = 1 : ($order_dir = -1); $order = substr($order, 1); } $fixed_order = "widget_log." . strtoupper($order); $should_sort = in_array($fixed_order, array(WidgetLogPeer::ID, WidgetLogPeer::KSHOW_ID, WidgetLogPeer::ENTRY_ID, WidgetLogPeer::REFERER, WidgetLogPeer::VIEWS, WidgetLogPeer::PLAYS, WidgetLogPeer::IP1_COUNT, WidgetLogPeer::CREATED_AT)); if ($should_sort) { if ($order_dir == 1) { $c->addAscendingOrderByColumn($fixed_order); } else { $c->addDescendingOrderByColumn($fixed_order); } } } $pager = new sfPropelPager('WidgetLog', $pageSize); $pager->setPeerMethod("doSelectJoinentry"); $pager->setPeerCountMethod("doCountJoinentry"); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
public function executeList() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $c = new Criteria(); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(AcademicCalendarPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN); $filters = null; if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('AcademicCalendar', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); $filter_string = ""; if ($filters) { foreach ($filters as $key => $val) { $filter_string .= "&filters[{$key}]={$val}"; } $filter_string = preg_replace('/^&/', '', $filter_string); } $this->actions = $actions; }
public function executeList() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $c = new Criteria(); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(ClassGroupPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $this->getUser()->setAttribute('max_per_page', $rpp, 'class_group'); $pager = new sfPropelPager('ClassGroup', $rpp); $pager->setCriteria($c); $pager->setPeerMethod('doSelectFiltered'); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'class_group')); $this->getUser()->setAttribute('page', $page, 'class_group'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(); if ($acl->getAddPriv()) { array_unshift($actions, array('name' => 'add', 'url' => 'class_group/create', 'color' => 'black')); } $this->actions = $actions; }
public function executeList() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $c = new Criteria(); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'counseling_spec')); $this->getUser()->setAttribute('max_per_page', $rpp, 'counseling_spec'); $pager = new sfPropelPager('CounselingSpec', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'counseling_spec')); $this->getUser()->setAttribute('page', $page, 'counseling_spec'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(); if ($acl->getAddPriv()) { array_unshift($actions, array('name' => 'Tambah', 'url' => 'counseling_spec/create', 'color' => 'black')); } $this->actions = $actions; $this->subtitle = ''; }
/** * get pager for assets * @param array $params * @param string $sort * @param integer $page * @param integer $size * @return sfPager */ public static function getPager(array $params, $sort = 'name', $page = 1, $size = 20) { $c = self::search($params, $sort); $pager = new sfPropelPager('sfAsset', $size); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinFolder'); $pager->init(); return $pager; }
public static function getForUserPager($user_id, $page = 1, $max_per_page = 10) { $c = self::getForUserCriteria($user_id); $pager = new sfPropelPager('sfSimpleForumTopic', $max_per_page); $pager->setPage($page); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinAll'); $pager->init(); return $pager; }
public function getTopicsPager($page = 1, $max_per_page = 10) { $c = $this->getTopicsCriteria(); $pager = new sfPropelPager('sfSimpleForumTopic', $max_per_page); $pager->setPage($page); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinsfSimpleForumPost'); $pager->init(); return $pager; }
public static function getRecentPager($page) { $pager = new sfPropelPager('Answer', sfConfig::get('app_pager_homepage_max')); $c = new Criteria(); $c->addDescendingOrderByColumn(self::CREATED_AT); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinUser'); $pager->init(); return $pager; }
public static function getTaggedPager($tag, $max, $page) { $pager = new sfPropelPager('sfSimpleBlogPost', $max); $c = new Criteria(); $c->addJoin(sfSimpleBlogTagPeer::SF_BLOG_POST_ID, self::ID); $c->add(sfSimpleBlogTagPeer::TAG, $tag); $c->add(self::IS_PUBLISHED, true); $c->addDescendingOrderByColumn(self::CREATED_AT); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinAll'); $pager->init(); return $pager; }
public static function retrievePager($c = null, $page = 1, $max = 10) { if ($c == null) { $c = new Criteria(); } $c->addDescendingOrderByColumn(self::LAST_NAME); $c->setIgnoreCase(true); $pager = new sfPropelPager('sfGuardUserProfile', $max); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinSfGuardUser'); $pager->setPage($page); $pager->init(); return $pager; }
public function executeList() { $type = $this->getRequestParameter('type', 'all'); $c = $this->{'list' . $type}(); $c->addDescendingOrderByColumn(PostPeer::CREATED_AT); $c->add(PostPeer::DELETED, false); $pager = new sfPropelPager('Post', sfConfig::get('app_post_per_page', 7)); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->setPeerMethod('doSelectJoinAll'); $pager->init(); $this->pager = $pager; $r = sfRouting::getInstance(); $this->iuri = $r->getCurrentRouteName() == 'homepage' ? '@posts?page=1' : $r->getCurrentInternalUri(true); }
protected function getPager($feed_id) { $pager = new sfPropelPager('Torrent', 20); $pager->setPeerMethod('doSelectJoinAll'); $c = new Criteria(); $c->addAscendingOrderByColumn(TorrentPeer::UPDATED_AT); $c->addAscendingOrderByColumn(TorrentPeer::CREATED_AT); // todo exclude future if ($feed_id) { $c->add(TorrentPeer::FEED_ID, $feed_id); } $pager->setCriteria($c); $pager->setPage(1); return $pager; }
public static function getReportedSpamPager($page) { $pager = new sfPropelPager('Answer', sfConfig::get('app_pager_homepage_max')); $c = new Criteria(); $c->add(self::REPORTS, 0, Criteria::GREATER_THAN); $c->setLimit(20); $c->addDescendingOrderByColumn(self::REPORTS); $c->addAscendingOrderByColumn(self::CREATED_AT); $c = self::addPermanentTagToCriteria($c); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinUser'); $pager->init(); return $pager; }
/** * This function returns a pager object holding the specified comments' entries * sorted by a given sort order. * each entry holds the kuser object of its host. * * @param int $subjectType = the type of the object the commens refers to * @param int $subjectId = the id of the object the comments refers to * @param int $pageSize = number of kshows in each page * @param int $page = the requested page * @return the pager object */ public static function getOrderedPager($commentType, $subjectId, $pageSize, $page) { $c = new Criteria(); $c->add(commentPeer::COMMENT_TYPE, $commentType); $c->add(commentPeer::SUBJECT_ID, $subjectId); $c->addDescendingOrderByColumn(commentPeer::BASE_DATE); $c->addJoin(commentPeer::KUSER_ID, kuserPeer::ID, Criteria::INNER_JOIN); $pager = new sfPropelPager('comment', $pageSize); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinkuser'); $pager->setPeerCountMethod('doCountJoinkuser'); $pager->init(); return $pager; }
public function executeList() { $group = $this->getContext()->getUser()->getAttribute('group', null, 'bo'); if ($group != 'root') { $this->forward('default', 'index'); } $c = new Criteria(); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'menu_template')); $this->getUser()->setAttribute('max_per_page', $rpp, 'menu_template'); $pager = new sfPropelPager('JobTemplate', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'menu_template')); $this->getUser()->setAttribute('page', $page, 'menu_template'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); array_unshift($actions, array('name' => 'add', 'url' => 'menu_template/create', 'color' => 'black')); $this->actions = $actions; $this->subtitle = ''; }
public function executeListTotalMember() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); $c = new Criteria(); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if ($f != null && $f != '') { $defined_filter = true; break; } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('Department', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $this->subtitle = ''; $filter_string = ""; if ($this->filters) { foreach ($this->filters as $key => $val) { $filter_string .= "&filters[{$key}]={$val}"; } $filter_string = preg_replace('/^&/', '', $filter_string); } $this->filter_string = $filter_string; $actions = array(array('name' => 'filter', 'color' => 'white')); array_unshift($actions, array('name' => '_AS_CSV_', 'url' => "rpt_borang/listTotalMemberAsCSV?{$filter_string}", 'color' => 'white', 'type' => 'direct')); array_unshift($actions, array('name' => '_AS_PDF_', 'url' => "rpt_borang/listTotalMemberAsPDF?{$filter_string}", 'color' => 'white', 'type' => 'direct')); $this->actions = $actions; }
public function executeList() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c = new Criteria(); $c->add(DepartmentPeer::ID, $dept->getChildRecurs(), Criteria::IN); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if ($f != null && $f != '') { $defined_filter = true; break; } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('Department', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; }
/** * Executes index action * * @param sfWebRequest $request */ public function executeIndex(sfWebRequest $request) { //$this->customer_list = CustomerPeer::doSelect(new Criteria()); $this->sort = $this->getRequestParameter('sort'); $this->sort_type = $this->getRequestParameter('sort_type'); $criteria = new Criteria(); if (!is_null($this->sort)) { if (!is_null($this->sort_type) && $this->sort_type == 'desc') { $criteria->addDescendingOrderByColumn(CustomerPeer::$this->sort); } elseif (!is_null($this->sort_type) && $this->sort_type == 'asc') { $criteria->addAscendingOrderByColumn(CustomerPeer::$this->sort); } } $pager = new sfPropelPager('Customer', sfConfig::get('app_max_customer_list', 20)); $pager->setPeerMethod('doSelect'); $pager->setCriteria($criteria); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; }
public function executeGetCounseling() { $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c = new Criteria(); $c->add(DepartmentPeer::ID, $dept->getChildRecurs(), Criteria::IN); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if ($f != null && $f != '') { $defined_filter = true; break; } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('Department', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $this->subtitle = 'Rekap Kepegawaian - ' . $academic_calendar->getName(); $actions = array(); $this->actions = $actions; $this->academic_calendar = $academic_calendar; }
public function executeSearch() { // We keep the search params in the session for easier pagination if ($this->getRequest()->hasParameter('search_params')) { $search_params = $this->getRequestParameter('search_params'); if (isset($search_params['created_at']['from']) && $search_params['created_at']['from'] !== '') { $search_params['created_at']['from'] = sfI18N::getTimestampForCulture($search_params['created_at']['from'], $this->getUser()->getCulture()); } if (isset($search_params['created_at']['to']) && $search_params['created_at']['to'] !== '') { $search_params['created_at']['to'] = sfI18N::getTimestampForCulture($search_params['created_at']['to'], $this->getUser()->getCulture()); } $this->getUser()->getAttributeHolder()->removeNamespace('sf_admin/sf_asset/search_params'); $this->getUser()->getAttributeHolder()->add($search_params, 'sf_admin/sf_asset/search_params'); } $this->search_params = $this->getUser()->getAttributeHolder()->getAll('sf_admin/sf_asset/search_params'); $c = $this->processSearch(); $pager = new sfPropelPager('sfAsset', sfConfig::get('app_sfAssetsLibrary_search_pager_size', 20)); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->setPeerMethod('doSelectJoinsfAssetFolder'); $pager->init(); $this->pager = $pager; $this->removeLayoutIfPopup(); }
public function executePrintCounseling() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id')); $this->forward404Unless($academic_calendar); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl = $this->getRequestParameter('tgl_cetak'); $c = new Criteria(); $c->add(TempTablePeer::COUNSELING_ID, $counseling->getId()); $c->add(TempTablePeer::TIME, $time); $c->addJoin(VStudentActivePeer::ID, TempTablePeer::STUDENT_ID); $c->addAscendingOrderByColumn(VStudentActivePeer::CLASS_NAME); $students = VStudentActivePeer::doSelect($c); $this->forward404Unless($students); $ce = new Criteria(); $ce->add(DepartmentDetailPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $this->department_detail = DepartmentDetailPeer::doSelectOne($ce); $c = new Criteria(); $c->add(CounselingSpecPeer::PARENT, 0); $c->addAscendingOrderByColumn(CounselingSpecPeer::ID); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'counseling_spec')); $this->getUser()->setAttribute('max_per_page', $rpp, 'counseling_spec'); $pager = new sfPropelPager('CounselingSpec', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'counseling_spec')); $this->getUser()->setAttribute('page', $page, 'counseling_spec'); $pager->setPage($page); $pager->init(); $this->pager = $pager; ## Menentukan Aturan Penilaian $cd = new Criteria(); $cd->add(ClassGroupPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $cd->addJoin(ScoreRulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $cd->add(ScoreRulePeer::TYPE, 6); $score_rule = ScoreRulePeer::doSelectOne($cd); $this->score_rule = $score_rule; $this->students = $students; $this->subtitle = ''; $this->counseling = $counseling; $this->tanggal = $time; $this->tgl_cetak = $tgl; $this->time2 = $time2; $this->academic_calendar = $academic_calendar; $this->papersize = 'a4'; $this->orientation = 'portrait'; $this->setViewClass('sfDomPDF'); }
public function executeList() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $c = new Criteria(); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if ($f != null && $f != '') { $defined_filter = true; break; } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('PaymentModel', $rpp); $pager->setPeerMethod('doSelectOrdered'); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); if ($acl->getAddPriv()) { array_unshift($actions, array('name' => 'add', 'url' => 'payment_model/create', 'color' => 'black')); } $this->actions = $actions; $cw = new Criteria(); $cw->add(JobPeer::PARENT, 240); $parent = JobPeer::doSelectOne($cw); $cr = new Criteria(); $cton1 = $cr->getNewCriterion(JobPeer::PARENT, $parent->getParent(), Criteria::IN); $cton2 = $cr->getNewCriterion(JobPeer::ID, $job->getId(), Criteria::NOT_IN); $cton3 = $cr->getNewCriterion(JobPeer::CODE, 'academic_process', Criteria::NOT_IN); $cton4 = $cr->getNewCriterion(JobPeer::CODE, 'payer_type', Criteria::NOT_IN); $cton3->addAnd($cton4); $cton2->addAnd($cton3); $cton1->addAnd($cton2); $cr->add($cton1); $modules = JobPeer::doSelect($cr); $this->modules = $modules; $actions2 = array(array('name' => '<span>Komponen Biaya Sekolah</span>', 'url' => 'academic_cost_component/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Proses Akademik</span>', 'url' => 'academic_process/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Tipe Siswa</span>', 'url' => 'payer_type/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>' . $job->getName() . '</span>', 'url' => $job->getCode(), 'color' => 'sun', 'type' => 'direct')); $this->actions2 = $actions2; }
function executeListgridjson() { $start = $this->request->getParameterHolder()->has('start') ? $this->request->getParameterHolder()->get('start') : 0; $limit = $this->request->getParameterHolder()->has('limit') ? $this->request->getParameterHolder()->get('limit') : 20; $anode = $this->request->getParameterHolder()->has('anode') ? $this->request->getParameterHolder()->get('anode') : null; $uid = $this->request->getParameterHolder()->get('uid'); $page = $start == 0 ? 1 : ceil($start / $limit) + 1; $parser = $this->getUser()->getAttributeHolder()->getAll('parser/grid'); $host = "https://" . $this->getRequest()->getHost(); foreach ($parser as $data) { if ($data["uid"] == $uid) { $parser = $data; break; } } $pager = new sfPropelPager($parser["class"], $parser["limit"]); if ($anode === null) { $c = $parser["criteria"]; } else { $parser["datasource"]["method"]["params"]["criteria"] = $parser["criteria"]; $parser["datasource"]["method"]["params"]["gid"] = $anode; $c = afCall::funcArray(array($parser["datasource"]["class"], $parser["datasource"]["method"]["name"]), $parser["datasource"]["method"]["params"]); } $pager->setPeerMethod($parser["select_method"]); $pager->setPage($page); $pager->setCriteria($c); $pager->init(); $grid_data = new afExtjsGridData(); $grid_data->totalCount = $pager->getNbResults(); $items = array(); $i = $j = 0; foreach ($pager->getResults() as $object) { foreach ($parser["columns"] as $column) { $j = 0; $id = $object->getId(); if (method_exists($object, "get" . $column["phpname"])) { $tmp = call_user_func(array($object, "get" . $column["phpname"])); } else { $tmp = ""; } if ($tmp && in_array($column["phpname"], $parser["foreign_keys"])) { $items[$i][$column["column"]] = call_user_func(array($tmp, "__toString")); } else { $items[$i][$column["column"]] = $tmp; } $items[$i]["_id"] = $anode == null ? $id : rand(); $items[$i]["_parent"] = $anode; $items[$i]["_is_leaf"] = $anode == null ? false : true; foreach ($parser["rowactions"] as $k => $action) { if (!strstr($host . $action["attributes"]["url"], "?")) { $host . ($action["attributes"]["url"] .= "?"); } if ($anode !== null) { $items[$i]["action" . ($j + 1)] = $host . $action["attributes"]["url"] . "id=" . $id . "&"; } $j++; } } $i++; } foreach ($items as $item) { $grid_data->addRowData($item); } return $this->renderText($grid_data->end()); }
public static function getMopPager($wing_id, $max = 10, $page = 1, $flag, $ispilot) { if ($ispilot == 1) { $c = new Criteria(); $c->addJoin(PilotPeer::MEMBER_ID, MemberPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MemberPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(MemberPeer::ACTIVE, 1); $c->add(MemberPeer::WING_ID, $wing_id); $c->add(PilotPeer::MOP_ORIENTED_DATE, NULL, Criteria::ISNOTNULL); $c->add(PilotPeer::MOP_ACTIVE_STATUS, 1, Criteria::EQUAL); $c->addAscendingOrderByColumn(PersonPeer::FIRST_NAME); $pager = new sfPropelPager('Pilot', $max); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinMember'); $pager->setPage($page); $pager->init(); } else { $c = new Criteria(); $c->addJoin(PilotPeer::MEMBER_ID, MemberPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MemberPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(MemberPeer::ACTIVE, 1); if ($flag == 1) { $c->add(PilotPeer::MOP_ORIENTED_DATE, NULL, Criteria::ISNULL); } else { $c->add(MemberPeer::WING_ID, $wing_id); $c->add(PilotPeer::MOP_ORIENTED_DATE, NULL, Criteria::ISNOTNULL); } $c->addAscendingOrderByColumn(PersonPeer::FIRST_NAME); $pager = new sfPropelPager('Pilot', $max); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinMember'); $pager->setPage($page); $pager->init(); } return $pager; }
/** * This function returns a pager object holding the set of shows for which given user contributed media. * * @param int $kuserId = the requested user * @param int $pageSize = number of kshows in each page * @param int $page = the requested page * @return the pager object */ public static function getUserShowsPartOf($kuserId, $pageSize, $page, $order) { $c = new Criteria(); $c->addJoin(self::ID, entryPeer::KSHOW_ID, Criteria::INNER_JOIN); $c->add(entryPeer::KUSER_ID, $kuserId); $c->add(self::PRODUCER_ID, $kuserId, Criteria::NOT_EQUAL); self::setOrder($c, $order); $c->setDistinct(); $pager = new sfPropelPager('kshow', $pageSize); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinkuser'); $pager->setPeerCountMethod('doCountJoinkuser'); $pager->init(); return $pager; }
public static function getForUserPager($user_id, $page = 1, $max_per_page = 10) { sfContext::getInstance()->getLogger()->info('Grabbing pager of user\'s latest posts, for user: [' . $user_id . '], page: [' . $page . '] max: [' . $max_per_page . ']'); $c = self::getForUserCriteria($user_id); $pager = new sfPropelPager('sfSimpleForumPost', $max_per_page); $pager->setPage($page); $pager->setCriteria($c); $pager->setPeerMethod('doSelectJoinsfSimpleForumForum'); $pager->init(); return $pager; sfContext::getInstance()->getLogger()->info('Finished pager of user\'s latest posts'); }
/** * Mostra les reserves pendents que tenim * * @param int $Pagina * @return Reservaespais */ static function getReservesSelect($CERCA = "", $SEL = 0, $Pagina = 1, $idS) { $C = new Criteria(); if (!empty($CERCA)) { $C1 = $C->getNewCriterion(self::NOM, '%' . $CERCA . '%', CRITERIA::LIKE); $C2 = $C->getNewCriterion(self::REPRESENTACIO, '%' . $CERCA . '%', CRITERIA::LIKE); $C3 = $C->getNewCriterion(self::RESPONSABLE, '%' . $CERCA . '%', CRITERIA::LIKE); $C4 = $C->getNewCriterion(self::PERSONALAUTORITZAT, '%' . $CERCA . '%', CRITERIA::LIKE); $C5 = $C->getNewCriterion(self::ORGANITZADORS, '%' . $CERCA . '%', CRITERIA::LIKE); $C6 = $C->getNewCriterion(self::DATAACTIVITAT, '%' . $CERCA . '%', CRITERIA::LIKE); $C7 = $C->getNewCriterion(UsuarisPeer::NOM, '%' . $CERCA . '%', CRITERIA::LIKE); $C8 = $C->getNewCriterion(UsuarisPeer::DNI, '%' . $CERCA . '%', CRITERIA::LIKE); $C9 = $C->getNewCriterion(UsuarisPeer::COG1, '%' . $CERCA . '%', CRITERIA::LIKE); $C10 = $C->getNewCriterion(UsuarisPeer::COG2, '%' . $CERCA . '%', CRITERIA::LIKE); $C1->addOr($C2); $C1->addOr($C3); $C1->addOr($C4); $C1->addOr($C5); $C1->addOr($C6); $C1->addOr($C7); $C1->addOr($C8); $C1->addOr($C9); $C1->addOr($C10); $C->add($C1); } $C->add(self::SITE_ID, $idS); $C->add(self::ESTAT, self::ESBORRADA, CRITERIA::NOT_EQUAL); if ($SEL >= 0) { $C->add(self::ESTAT, $SEL); } $C->addDescendingOrderByColumn(self::DATAALTA); $P = new sfPropelPager('Reservaespais', 20); $P->setPeerMethod('doSelectJoinUsuaris'); $P->setCriteria($C); $P->setPage($Pagina); $P->init(); return $P; }
public static function getUserEntries($kuserId, $pageSize, $page) { $c = new Criteria(); $c->addJoin(entryPeer::KUSER_ID, kuserPeer::ID, Criteria::INNER_JOIN); $c->add(entryPeer::KUSER_ID, $kuserId); $c->add(entryPeer::TYPE, entryType::MEDIA_CLIP); $c->addAscendingOrderByColumn(entryPeer::CREATED_AT); $pager = new sfPropelPager('entry', $pageSize); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinkuser'); $pager->setPeerCountMethod('doCountJoinkuser'); $pager->init(); return $pager; }