public function indexAction() { $code = "fdUserBookmark"; $usersNs = new Zend_Session_Namespace("members"); $mapId1 = $usersNs->userId; $model = new Security_Model_SystemMapping(); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "master_value") { $strOrderBy = "sm.master_value {$order}"; } else { if ($col == "map_id3") { $strOrderBy = "s.map_id3 {$order}"; } } } else { $strOrderBy = "s.map_id3"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "s.map_id1='{$mapId1}' and s.map_code='{$code}'"; $this->view->linkArray = array(); $this->view->search = ""; $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("sm" => 'system_master'), array("master_value"))->join(array("s" => "system_mapping"), "s.map_code='fdUserBookmark' and s.map_id1='{$mapId1}' and sm.master_code='fdMenu' and sm.master_id=s.map_id2", array("map_id1" => 'map_id1', "map_id2" => 'map_id2', "map_id3" => 'map_id3'))->group("s.map_id2")->order($strOrderBy); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; /*if($search<>"" && $search<>"Search...") { $where="(first_name like '%{$search}%' or last_name like '%{$search}%' or email like '%{$search}%' or d.title like '%{$search}%' or username like '%{$search}%' ) and status!='deleted'"; $this->view->linkArray=array('search'=>$search); $this->view->search=$search; }*/ $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Application_Model_UserPrivilege(); $table = $model->getMapper()->getDbTable(); // $select = $table->select()->setIntegrityCheck(false)->from('user_privilege',array('user_id', 'screen_id', 'action_id','menu_id'))->order('user_id ASC')->where($where); $select = $table->select()->setIntegrityCheck(false)->from(array("up" => 'user_privilege'))->join(array("u" => 'user'), 'up.user_id=u.id', array('first_name' => 'first_name', 'last_nae' => 'last_name'))->order('user_id ASC')->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); // echo '<pre>'; print_r($paginator); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { $menu_title = trim($this->_getParam('menu_title')); $this->view->linkArray = array(); $menu = new Base_Security_Menu(); $pages = $menu->getChildPages(0, 0); $this->view->sortOptions = array(); $this->view->menu_title = ""; if ($menu_title != "") { $this->view->linkArray['menu_title'] = $menu_title; $this->view->menu_title = $menu_title; $arrObj = new Base_Array(); $pages = $arrObj->search($pages, 'menu_title', $menu_title); $this->view->sortOptions['menu_title'] = $menu_title; } /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { $arrObj = new Base_Array(); $arrObj->orderBy($pages, $col, $order); } /*----------------*/ $page_size = Zend_Registry::get('page_size'); $this->view->page = $page = $this->_getParam('page', 1); $paginator = Base_Paginator::factory($pages); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->paginator = $paginator; }
public function workflowListAction() { /*--search---*/ $search = trim($this->_getParam('search')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { $strOrderBy = "w.{$col} {$order}"; } else { $strOrderBy = "w.workflow_name asc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "w.id<>'-2147483648' and w.is_deleted<>1"; $this->view->linkArray = array(); $this->view->search = ""; if ($search != "") { $where = "w.workflow_name like '%{$search}%' and {$where} "; $this->view->linkArray = array('search' => $search); $this->view->search = $search; $this->view->sortOptions['search'] = $search; } $model = new Security_Model_User(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("w" => 'workflow_master'), array("id", "workflow_name", "row_guid", "is_deleted"))->order($strOrderBy)->where($where); //echo $sql = $select->__toString(); exit; $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function fetchPageDataResult($result, $page, $countPerPage = 10) { $this->setTotalCount(count($result)); $paginator = Base_Paginator::factory($result); $paginator->setItemCountPerPage($countPerPage); $paginator->setCurrentPageNumber($page); return $paginator; }
public function projectsAction() { /*--search options---*/ $search = trim($this->_getParam('search')); $status = trim($this->_getParam('status')); $project_manager_id = trim($this->_getParam('project_manager_id')); $team_leader_id = trim($this->_getParam('team_leader_id')); $where = '1=1'; $linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(p.title like '%{$search}%' or p.description like '%{$search}%' or p.client_info like '%{$search}%' or p.start_date like '%{$search}%' or p.end_date like '%{$search}%' or pm.first_name like '%{$search}%' or pm.last_name like '%{$search}%' or tl.first_name like '%{$search}%' or tl.last_name like '%{$search}%')"; $linkArray['search'] = $search; $this->view->search = $search; } if ($status != "") { if (is_null($where)) { $where .= " p.status='{$status}'"; } else { $where .= " and p.status='{$status}'"; } $linkArray['status'] = $status; $this->view->status = $status; } if ($project_manager_id != "") { if (is_null($where)) { $where .= " p.project_manager_id='{$project_manager_id}'"; } else { $where .= " and p.project_manager_id='{$project_manager_id}'"; } $linkArray['project_manager_id'] = $project_manager_id; $this->view->project_manager_id = $project_manager_id; } if ($team_leader_id != "") { if (is_null($where)) { $where .= " p.team_leader_id='{$team_leader_id}'"; } else { $where .= " and p.team_leader_id='{$team_leader_id}'"; } $linkArray['team_leader_id'] = $team_leader_id; $this->view->team_leader_id = $team_leader_id; } /*----search options----*/ $this->view->linkArray = $linkArray; $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_Project(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("p" => 'project'))->join(array("pm" => "user"), 'pm.id=p.project_manager_id', array("pm_first_name" => 'first_name', "pm_last_name" => 'last_name', 'pm_id' => 'id'))->join(array("tl" => "user"), 'tl.id=p.team_leader_id', array("tl_first_name" => 'first_name', "tl_last_name" => 'last_name', 'tl_id' => 'id'))->order('status Asc')->order('addedon desc')->where($where); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; $this->view->projectManagers = $model->getActiveProjectManagers(); $this->view->teamLeaders = $model->getActiveTeamLeaders(); }
public function indexAction() { /*--search---*/ $search_name = trim($this->_getParam('search_name')); $search_city = trim($this->_getParam('search_city')); $search_phone = trim($this->_getParam('search_phone')); $search_email = trim($this->_getParam('search_email')); //$status = trim($this->_getParam('status')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "phone") { $strOrderBy = "c.phone {$order}"; } else { if ($col == "fax") { $strOrderBy = "c.fax {$order}"; } else { if ($col == "email") { $strOrderBy = "c.email {$order}"; } } } } else { $strOrderBy = "c.first_name asc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "c.id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->search = ""; if ($search_name != "" || $search_city != "" || $search_phone != "" || $search_email != "") { $where = "((first_name like '%{$search_name}%') OR (bfirst_name like '%{$search_name}%') OR (last_name like '%{$search_name}%') OR (blast_name like '%{$search_name}%')) AND ((city like '%{$search_city}%') OR (bcity like '%{$search_city}%')) AND (phone like '%{$search_phone}%') AND (email like '%{$search_email}%') and {$where} "; $this->view->linkArray = array('search_name' => $search_name); $this->view->search_name = $search_name; $this->view->search_city = $search_city; $this->view->search_phone = $search_phone; $this->view->search_email = $search_email; $this->view->sortOptions['search_name'] = $search_name; $this->view->sortOptions['search_city'] = $search_city; $this->view->sortOptions['search_phone'] = $search_phone; $this->view->sortOptions['search_email'] = $search_email; } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Admin_Model_Customer(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("c" => 'customer'))->order("{$strOrderBy}")->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { /*--search---*/ $search = trim($this->_getParam('orgName')); //$status = trim($this->_getParam('status')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "city") { $strOrderBy = "s.city {$order}"; } else { if ($col == "state") { $strOrderBy = "s.state {$order}"; } else { if ($col == "zip") { $strOrderBy = "s.zip {$order}"; } } } } else { $strOrderBy = "s.first_name asc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "s.id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->search = ""; if ($search != "") { $where = "(org_name like '%{$search}%')and {$where} "; $this->view->linkArray = array('search' => $search); $this->view->search = $search; $this->view->sortOptions['orgName'] = $search; } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Admin_Model_Supplier(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'supplier'))->order("{$strOrderBy}")->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { /*--search---*/ $this->view->pageHeading = "List Location"; $search = trim($this->_getParam('title')); $this->view->assign('searchText', $search); //$status = trim($this->_getParam('status')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "title") { $strOrderBy = "l.title {$order}"; } // else if($col=="weight") // $strOrderBy="l.weight {$order}"; } else { $strOrderBy = "l.id desc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "l.id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->search = ""; if ($search != "") { $where = "(title like '%{$search}%')and {$where} "; $this->view->linkArray = array('search' => $search); $this->view->search = $search; $this->view->sortOptions['title'] = $search; } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Admin_Model_Location(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("l" => 'location'))->order("{$strOrderBy}")->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function databaseConfigsAction() { $search = trim($this->_getParam('search')); $where = "dbcnf_id<>'-2147483648'"; $this->view->search = ""; if ($search != "") { $where = "(db_name like '%{$search}%')"; $this->view->search = $search; } $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Security_Model_DatabaseConfig(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from('dbconfiguration')->order('dbcnf_id ASC')->where($where); //$sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function databaseConfigsAction() { $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(db_server_name like '%{$search}%' or db_name like '%{$search}%' or db_user like '%{$search}%')"; $this->view->search = $search; } $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_DatabaseConfig(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from('dbconfiguration')->order('dbcnf_id ASC')->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function albumsAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(title like '%{$search}%' or description like '%{$search}%' or first_name like '%{$search}%' or last_name like '%{$search}%' or middle_name like '%{$search}%')"; $this->view->linkArray = array('search' => $search); $this->view->search = $search; } $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_Album(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("a" => 'album'))->join(array("u" => 'user'), 'u.id=a.user_id', array('first_name', 'last_name', 'middle_name', "user_id" => 'id', 'employee_code'))->order('addedon desc')->order('updatedon desc')->order('title ASC')->where($where); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->paginator = $paginator; }
public function groupsAction() { $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "title like '%{$search}%'"; $this->view->linkArray = array('search' => $search); $this->view->search = $search; } $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_Group(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->order('addedon DESC')->where($where); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage("{$page_size}"); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function errorLogsAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(machine_name like '%{$search}%' or app_name like '%{$search}%' or process_name like '%{$search}%' or module_name like '%{$search}%' or method_name like '%{$search}%' )"; $this->view->linkArray = array('search' => $search); $this->view->search = $search; } $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Application_Model_ErrorLog(); $table = $model->getMapper()->getDbTable(); // $select = $table->select()->setIntegrityCheck(false)->from('user_privilege',array('user_id', 'screen_id', 'action_id','menu_id'))->order('user_id ASC')->where($where); $select = $table->select()->setIntegrityCheck(false)->from('error_log')->order('log_id ASC')->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); // echo '<pre>'; print_r($paginator); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { $Pstatus = "Knocked"; if ($this->_getParam('inputs')) { $search_input = trim(implode(',', $this->_getParam('inputs'))); } else { $search_input = ''; } $form = new Mps_Form_Compliance(); $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('data'); $element->removeDecorator('Label'); $element->removeDecorator('row'); } //Used in listing $model2 = new Base_Security_Privilege(); $arrCondumnSubValue = $model2->getCondumnValues('fdCondumnSubStatus'); $this->view->condumnSubValue = $arrCondumnSubValue; //End /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "breed") { $strOrderBy = "s2.master_value {$order}"; } else { if ($col == "type") { $strOrderBy = "s.master_value {$order}"; } else { if ($col == "color") { $strOrderBy = "s3.master_value {$order}"; } else { if ($col == "auction_tag") { $strOrderBy = "p.auction_tag {$order}"; } else { if ($col == "ear_tag") { $strOrderBy = "p.ear_tag {$order}"; } else { if ($col == "trich") { $strOrderBy = "p.trich {$order}"; } else { if ($col == "trich") { $strOrderBy = "p.trich {$order}"; } else { if ($col == 'id') { $strOrderBy = "p.id {$order}"; } } } } } } } } } else { $strOrderBy = "p.id"; } $this->view->sortOptions = array(); /*-----sorting----------*/ /*--search---*/ $search = trim($this->_getParam('search')); $where = "p.id<>'-2147483648' and p.process_status='{$Pstatus}'"; $this->view->linkArray = array(); if ($search != "") { $params = $this->_getAllParams(); $breed = trim($this->_getParam('breed')); $type = trim($this->_getParam('type')); $color = trim($this->_getParam('color')); $id = trim($this->_getParam('id')); $supplier = trim($this->_getParam('supplier')); if (!empty($breed)) { $where .= " and breed='{$breed}'"; } if (!empty($type)) { $where .= " and type='{$type}'"; } if (!empty($color)) { $where .= " and color = '{$color}'"; } if (!empty($id)) { $where = " and id = '{$id}' and p.process_status='{$Pstatus}'"; } if (!empty($supplier)) { $where .= " and supplier_id = '{$supplier}'"; } if (!empty($search_input)) { $where .= " and condumn_sub_status like '%{$search_input}%'"; } $where = "{$where}"; $this->view->sortOptions['inputs'] = $search_input; $form->populate($params); } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Mps_Model_RawProduct(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("p" => 'raw_product'), array("*"))->join(array("s" => "system_master"), "s.master_code='fdAnimalType' and s.master_id=p.type", array("type" => "master_value"))->join(array("s2" => "system_master"), "s2.master_code='fdAnimal' and s2.master_id=p.breed", array("breed" => "master_value"))->join(array("s3" => "system_master"), "s3.master_code='fdAnimalColor' and s3.master_id=p.color", array("color" => "master_value"))->order("{$strOrderBy}")->where($where); // echo $sql = $select->__toString(); die; $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; //End Listing $this->view->form = $form; }
public function currentJobOpeningsAction() { /*--search options---*/ $search = trim($this->_getParam('search')); $department_id = trim($this->_getParam('department_id')); $where = "status='open'"; $linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(j.title like '%{$search}%' or j.description like '%{$search}%' or d.title like '%{$search}%')"; $linkArray['search'] = $search; $this->view->search = $search; } if ($department_id != "") { if (is_null($where)) { $where .= " j.department_id='{$department_id}'"; } else { $where .= " and j.department_id='{$department_id}'"; } $linkArray['department_id'] = $department_id; $this->view->department_id = $department_id; } /*----search options----*/ $this->view->linkArray = $linkArray; $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_Job(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("j" => 'job'))->join(array("d" => "department"), 'd.id=j.department_id', array('department_title' => 'title'))->order('addedon desc')->where($where); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; $department = new Application_Model_Department(); $this->view->departments = $department->getDepartment(); }
public function messagesAction() { /*--search---*/ $categoryName = trim($this->_getParam('categoryName')); $severityName = trim($this->_getParam('severityName')); $typeName = trim($this->_getParam('typeName')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "category") { $strOrderBy = "c.master_value {$order}"; } else { if ($col == "severity") { $strOrderBy = "s.master_value {$order}"; } else { if ($col == "type") { $strOrderBy = "t.master_value {$order}"; } } } } else { $strOrderBy = "m.message_id desc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "m.message_id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->categoryName = ""; if ($categoryName != "") { $where .= " and c.master_value like '%{$categoryName}%' "; $this->view->linkArray['categoryName'] = $categoryName; $this->view->categoryName = $categoryName; $this->view->sortOptions['categoryName'] = $categoryName; } $this->view->severityName = ""; if ($severityName != "") { $where .= " and s.master_value like '%{$severityName}%' "; $this->view->linkArray['severityName'] = $severityName; $this->view->severityName = $severityName; $this->view->sortOptions['severityName'] = $severityName; } $this->view->typeName = ""; if ($typeName != "") { $where .= " and t.master_value like '%{$typeName}%' "; $this->view->linkArray['typeName'] = $typeName; $this->view->typeName = $typeName; $this->view->sortOptions['typeName'] = $typeName; } $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Security_Model_SysMessage(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("m" => 'sys_message'))->join(array("c" => "system_master"), "m.category_id=c.master_id and c.master_code='fdSysMessageCategory'", array("category_name" => 'master_value'))->join(array("s" => "system_master"), "m.severity_id=s.master_id and s.master_code='fdSysMessageSeverity'", array("severity_name" => 'master_value'))->join(array("t" => "system_master"), "m.type_id=t.master_id and t.master_code='fdSysMessageType'", array("type_name" => 'master_value'))->order($strOrderBy)->where($where); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function historyAction() { $bookId = $this->_getParam("id"); $model = new Application_Model_Book(); $book = $model->find($bookId); if (false === $book) { exit("Operation failed!"); } $this->view->book = $book; $model = new Application_Model_BookUser(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("bu" => 'book_user'))->join(array('u' => 'user'), ' bu.user_id = u.id ', array("first_name" => "first_name", "last_name" => "last_name", "employee_code" => "employee_code", "email" => "email", "profile_picture" => "profile_picture"))->order("issue_date asc")->where("book_id='{$bookId}'"); //$this->view->bookUser=$bookUser=$table->fetchAll($select); $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function indexAction() { /*--search---*/ $search_pid = trim($this->_getParam('productIdentifier')); $search_pname = trim($this->_getParam('labelCase')); if ($this->_getParam('packLocation')) { $search_plocation = trim(implode(',', $this->_getParam('packLocation'))); } else { $search_plocation = ''; } /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); $form = new Admin_Form_Product(); $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); $element->removeDecorator('row'); $element->removeDecorator('data'); $element->removeDecorator('required'); //$element->removeDecorator('Errors'); } //remove fields do not need to display in Edit $usersNs = new Zend_Session_Namespace("members"); $form->removeElement('caseFormat'); $form->removeElement('partNumber'); $form->removeElement('sellByDays'); $form->removeElement('priceLb'); $form->removeElement('palletId'); $form->removeElement('desLine1'); $form->removeElement('desLine2'); $form->removeElement('desLine3'); $form->removeElement('desLine4'); $form->removeElement('lowerWeight'); $form->removeElement('fixedWeight'); $form->removeElement('heighWeight'); $form->removeElement('tareWeight'); $form->removeElement('requiredApp'); if ($order != "" && $col != "") { if ($col == "pack_location") { $strOrderBy = "p.pack_location {$order}"; } } else { $strOrderBy = "p.product_identifier asc"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "p.id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->search = ""; if ($search_pid != "" || $search_pname != "" || $search_plocation != "") { $params = $this->_getAllParams(); $where = "(product_identifier like '%{$search_pid}%') AND (label_case like '%{$search_pname}%') AND (pack_location like '%{$search_plocation}%') AND {$where} "; $this->view->linkArray = array('productIdentifier' => $search_pid); //$form->productIdentifier->setValue($search_pid); //$form->labelCase->setValue($search_pname); $this->view->sortOptions['productIdentifier'] = $search_pid; $this->view->sortOptions['labelCase'] = $search_pname; $this->view->sortOptions['packLocation'] = $search_plocation; $form->populate($params); //print_r($params); } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Admin_Model_Product(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("p" => 'product'))->order("{$strOrderBy}")->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; $this->view->form = $form; }
public function weighingAction() { $model = new Mps_Model_RawProduct(); $Pstatus = "Weighing"; $code = "fdCondumnStatus"; $model2 = new Base_Security_Privilege(); $arrValues = $model2->getCondumnValues($code); $arrSubcondumn = $model2->getCondumnValues('fdCondumnSubStatus'); $this->view->condumnValue = $arrValues; $this->view->condumnSubValue = $arrSubcondumn; $where = "p.id<>'-2147483648' and process_status='{$Pstatus}'"; //Edit cow weight values $request = $this->getRequest(); $options = $request->getPost(); $cowid = trim($this->_getParam('cowid')); $weight = trim($this->_getParam("weight")); $this->view->cowid = $cowid; if ($request->isPost()) { if (isset($options['submit'])) { //Update Cow weight $isExist = $model->isExist("id='{$cowid}' and process_status='{$Pstatus}'"); if ($isExist) { $model = $model->fetchRow("id='{$cowid}' and process_status='{$Pstatus}'"); if ($model !== false) { $model->setWeight($weight); $model->save(); } $this->_flashMessenger->addMessage(array('success' => 'Cow weight has been updated successfully!')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid)); } else { $this->_flashMessenger->addMessage(array('error' => 'Cow ID does not exist!')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid)); } //End Update Cow weight } else { //Update condumn status and weight $condumnStatus = trim($this->_getParam("condumnStatus")); //get condumn id on the basis of condumn value while ($value = current($arrValues)) { if ($value == $condumnStatus) { $condumnID = key($arrValues); } next($arrValues); } $model = $model->fetchRow("id='{$cowid}' and process_status='{$Pstatus}'"); if ($model !== false && !empty($condumnID)) { $model->setWeight($weight); $model->setStatusOn($condumnID); $model->save(); $this->_flashMessenger->addMessage(array('success' => 'Condumn status has been updated successfully!')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/cowid/' . $cowid)); } else { $this->_flashMessenger->addMessage(array('error' => 'Invalid Condumn status')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/mps/production/weighing/')); } //End Update condumn status and weight } } //End Edit /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "id") { $strOrderBy = "p.id {$order}"; } else { if ($col == "knocked_date") { $strOrderBy = "p.knocked_date {$order}"; } else { if ($col == "first_name") { $strOrderBy = array("s.first_name {$order}", "s.last_name {$order}"); } } } } else { $strOrderBy = "p.knocked_date desc"; //"p.knocked_date desc" } $this->view->sortOptions = array(); /*-----sorting----------*/ /*--search---*/ $this->view->linkArray = array(); $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'supplier'), array("first_name", "last_name"))->join(array("p" => "raw_product"), "s.id=p.supplier_id and p.process_status='{$Pstatus}' and s.id!='-2147483648'", array("*"))->order($strOrderBy); // echo $sql = $select->__toString(); die; $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
public function listSystemMasterAction() { /*--search---*/ $this->view->pageHeading = "List System Master"; $search = trim($this->_getParam('master_code')); $this->view->assign('searchText', $search); //$status = trim($this->_getParam('status')); /*---sorting ----*/ $order = trim($this->_getParam('order', "")); $col = trim($this->_getParam('col', "")); if ($order != "" && $col != "") { if ($col == "master_code") { $strOrderBy = "s.master_code {$order}"; } else { if ($col == "master_id") { $strOrderBy = "s.master_id {$order}"; } else { if ($col == "master_value") { $strOrderBy = "s.master_value {$order}"; } else { if ($col == "status") { $strOrderBy = "s.status {$order}"; } } } } } else { $strOrderBy = "s.master_code"; } $this->view->sortOptions = array(); /*-----sorting----------*/ $where = "1"; $groupby = "s.master_code"; $this->view->linkArray = array(); $this->view->search = ""; if ($search != "") { $where = "(master_code like '%{$search}%')and {$where} "; //$where="(master_code like '%{$search}%') and status='1'"; $this->view->linkArray = array('search' => $search); $this->view->search = $search; $this->view->sortOptions['master_code'] = $search; } $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Security_Model_SystemMaster(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from(array("s" => 'system_master'))->order("{$strOrderBy}")->where($where)->group($groupby); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }