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