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