/** * Execute /../stock/listItem * * @param type $request */ public function execute($request) { $head = sfYaml::load(sfConfig::get('sf_app_dir') . '/lib/list/item_list.yml'); $itemlist_headers = array($head['listItem']['header1'], $head['listItem']['header2'], $head['listItem']['header3'], $head['listItem']['header6']); $columns = 'id,name,sales_unit_price,stock_available'; $recordsLimit = 5; //have to take from lists if (!$request->hasParameter('pageNo')) { $pageNo = 1; } else { $pageNo = $request->getParameter('pageNo', 1); } $pager = new SimplePager('Item', $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($this->getItemService()->countItems()); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $paramHolder = new sfParameterHolder(); $paramHolder->set('columns', $columns); $paramHolder->set('offset', $offset); $paramHolder->set('limit', $recordsLimit); $itemlist_data = $this->getItemService()->getItems($paramHolder); $listContainer = new ListContainer(); $listContainer->setListName('ItemList'); $listContainer->setListHeaders($itemlist_headers); $listContainer->setListContent($itemlist_data); $listContainer->setRowLink("stock/showItem?id="); $listContainer->setPager($pager); $this->listcontainer = $listContainer; }
public function execute($request) { $head = sfYaml::load(sfConfig::get('sf_app_dir') . '/lib/list/seller_list.yml'); $sellerlist_headers = array($head['listSeller']['header1'], $head['listSeller']['header2'], $head['listSeller']['header3'], $head['listSeller']['header4']); $columns = 'id,name,address,tp_hp'; $recordsLimit = 5; //have to take from lists if (!$request->hasParameter('pageNo')) { $pageNo = 1; } else { $pageNo = $request->getParameter('pageNo', 1); } $pager = new SimplePager('Seller', $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($this->getSellerService()->countSellers()); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $paramHolder = new sfParameterHolder(); $paramHolder->set('columns', $columns); $paramHolder->set('offset', $offset); $paramHolder->set('limit', $recordsLimit); $sellerlist_data = $this->getSellerService()->getSellers($paramHolder); $listContainer = new ListContainer(); $listContainer->setListName('SellerList'); $listContainer->setListHeaders($sellerlist_headers); $listContainer->setListContent($sellerlist_data); $listContainer->setRowLink("seller/showSeller?id="); $listContainer->setPager($pager); $this->listcontainer = $listContainer; }
/** * * @param sfRequest $request */ public function execute($request) { $this->setTemplateVariables(); $this->params = array(); foreach ($this->getVarHolder()->getAll() as $param => $val) { $this->params[$param] = $val; } $recordsLimit = self::$itemsPerPage; //sfConfig::get('app_items_per_page'); $pageNo = $request->getParameter('pageNo', 1); if (self::$pageNumber) { $pageNo = self::$pageNumber; } else { $pageNo = $request->getParameter('pageNo', 1); } $numberOfRecords = self::$numberOfRecords; //replace with the count of all the records(self::$listData instanceof Doctrine_Collection) ? self::$listData->count() : count(self::$listData); // TODO: Remove the dependancy of ORM here; Use a Countable interface and a Iterator interface $pager = new SimplePager($this->className, $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($numberOfRecords); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $this->offset = $offset; $this->pager = $pager; $this->recordLimit = $recordsLimit; $this->currentSortField = $request->getParameter('sortField', ''); $this->currentSortOrder = $request->getParameter('sortOrder', ''); $this->showGroupHeaders = self::$configurationFactory->showGroupHeaders(); $this->headerGroups = self::$configurationFactory->getHeaderGroups(); $this->columns = self::$configurationFactory->getHeaders(); $this->data = self::$listData; $this->className = self::$configurationFactory->getClassName(); $this->partial = self::$headerPartial; $this->footerPartial = self::$footerPartial; $this->listForm = empty(self::$listForm) ? new DefaultListForm(array(), array(), true) : self::$listForm; $this->applyRuntimeDefinitions(); $this->makePluginCalls(); }
public function execute($request) { $request->setParameter('initialActionName', 'viewDirectory'); $isPaging = $request->getParameter('hdnAction') == 'search' ? 1 : $request->getParameter('pageNo', 1); $pageNumber = $isPaging; if (!empty($empNumber) && $this->getUser()->hasAttribute('pageNumber')) { $pageNumber = $this->getUser()->getAttribute('pageNumber'); } $noOfRecords = sfConfig::get('app_items_per_page'); $offset = $pageNumber >= 1 ? ($pageNumber - 1) * $noOfRecords : ($request->getParameter('pageNo', 1) - 1) * $noOfRecords; // Reset filters if requested to if ($request->hasParameter('reset')) { $this->setFilters(array()); $this->setSortParameter(array("field" => NULL, "order" => NULL)); $this->setPage(1); } $this->setForm(new EmployeeDirectorySearchForm($this->getFilters())); //handles post method if ($request->isMethod('post')) { $this->form->bind($request->getParameter($this->form->getName())); if ($this->form->isValid()) { if ($this->form->getValue('isSubmitted') == 'yes') { $this->setSortParameter(array("field" => NULL, "order" => NULL)); } $this->setFilters($this->form->getValues()); } else { $this->setFilters(array()); } $this->setPage(1); } //handles get method if ($request->isMethod('get')) { $sortParam = array("field" => $request->getParameter('sortField'), "order" => $request->getParameter('sortOrder')); $this->setSortParameter($sortParam); $this->setPage(1); } $filters = $this->getFilters(); if (isset($filters['emp_name']) && $filters['emp_name']['empName'] != __('Type for hints...')) { if (strpos($filters['emp_name']['empName'], __('Past Employee')) !== false) { $filters['termination'] = EmployeeSearchForm::WITH_TERMINATED; } $filters['employee_name'] = str_replace(' (' . __('Past Employee') . ')', '', $filters['emp_name']['empName']); } $this->filterApply = !empty($filters); $empList = $this->getEmployeeService()->getEmployeeIdList(); if (count($empList) > 0) { $filters['employee_id_list'] = $empList; $count = $this->getDirectoryService()->getSearchEmployeeCount($filters); $parameterHolder = new EmployeeSearchParameterHolder(); $parameterHolder->setOrderField($sortField); $parameterHolder->setOrderBy($sortOrder); $parameterHolder->setLimit($noOfRecords); $parameterHolder->setOffset($offset); $parameterHolder->setFilters($filters); $this->list = $this->getDirectoryService()->searchEmployees($parameterHolder); } else { $count = 0; $list = array(); } $recordsLimit = sfConfig::get('app_items_per_page'); //self::$itemsPerPage;// $pageNo = $request->getParameter('pageNo', 1); /* * if (self::$pageNumber) { $pageNo = self::$pageNumber; } else { */ //$pageNo = 1; //$request->getParameter('pageNo', 1); //} $numberOfRecords = $count; //replace with the count of all the records(self::$listData instanceof Doctrine_Collection) ? self::$listData->count() : count(self::$listData); // TODO: Remove the dependancy of ORM here; Use a Countable interface and a Iterator interface if ($recordsLimit < $numberOfRecords) { $this->isPaginated = TRUE; } $pager = new SimplePager($this->className, $recordsLimit); $pager->setPage($pageNo); $pager->setNumResults($numberOfRecords); $pager->init(); $offset = $pager->getOffset(); $offset = empty($offset) ? 0 : $offset; $this->offset = $offset; $this->pager = $pager; $this->recordLimit = $recordsLimit; //$this->currentSortField = $request->getParameter('sortField', ''); //$this->currentSortOrder = $request->getParameter('sortOrder', ''); }