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