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 indexAction()
{
/*--search---*/
$search = trim($this->_getParam('search'));
$status = trim($this->_getParam('status'));
$where = "status!='deleted' and u.id<>'-2147483648'";
$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 {$where}} ";
$this->view->linkArray = array('search' => $search);
$this->view->search = $search;
}
if ($status != "") {
if (is_null($where)) {
$where .= " status='{$status}'";
} else {
$where .= " and status='{$status}'";
}
$linkArray['status'] = $status;
$this->view->status = $status;
}
$page_size = 25;
$page = $this->_getParam('page', 1);
$model = new Security_Model_User();
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("u" => 'user'))->order('first_name 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 indexAction()
{
/*--search---*/
$search = trim($this->_getParam('search'));
/*---sorting ----*/
$order = trim($this->_getParam('order', ""));
$col = trim($this->_getParam('col', ""));
if ($order != "" && $col != "") {
if ($col == "group") {
$strOrderBy = "g.master_value {$order}";
} else {
if ($col == "subgroup") {
$strOrderBy = "sg.master_value {$order}";
} else {
if ($col == "role") {
$strOrderBy = "r.master_value {$order}";
} else {
if ($col == "supervisor") {
$strOrderBy = "su.first_name {$order}";
}
}
}
}
} else {
$strOrderBy = "u.first_name asc";
}
$this->view->sortOptions = array();
/*-----sorting----------*/
$where = "u.id<>'-2147483648'";
$this->view->linkArray = array();
$this->view->search = "";
if ($search != "") {
$where = "(u.first_name like '%{$search}%' or u.last_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("u" => 'user'), array("id", "first_name", "last_name", "username", "email", "status", "row_guid"))->join(array("g" => "system_master"), "u.group_id=g.master_id and g.master_code='fdUserGroup'", array("group_name" => 'master_value'))->join(array("sg" => "system_master"), "u.sub_group_id=sg.master_id and sg.master_code='fdUserSubGroup'", array("sub_group_name" => 'master_value'))->join(array("r" => "system_master"), "u.role_id=r.master_id and r.master_code='fdUserRole'", array("role_name" => 'master_value'))->join(array("su" => "user"), "u.supervisor_id=su.id", array("s_first_name" => 'first_name', "s_last_name" => 'last_name'))->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;
}
