/**
* Wyświetlenie użytkowników
*/
public function indexAction()
{
$model = new Feedback();
$select = $model->select()->from('feedback');
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'created_at');
$order = $request->getParam('order', 'desc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('created_at', 'message_content');
}
public function indexAction()
{
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$announcementModel = new Announcement();
$select = $announcementModel->select()->where('ghost = false');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('created_at', 'title', 'created_by', 'valid_since', 'valid_until', 'id_branch');
}
public function indexAction()
{
$model = new Message();
$select = $model->select()->from('message');
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('message', 'is_important');
}
public function indexAction()
{
$model = new GroupMain();
$select = $model->select();
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'group_main_name');
$order = $request->getParam('order', 'asc');
$select->where('ghost = false');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('group_main_name');
}
public function blockadehistoryAction()
{
$model = new Blockade();
$this->view->data = $model->getLast();
$select = $model->select();
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'created_at');
$order = $request->getParam('order', 'desc');
$select->where('ghost = false');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('created_by', 'created_at', 'is_blocked');
}
/**
* indexAction() - pokazuje listę wszystkich filtrów
*
* @todo prawodpodobnie do zmiany (będzie w ogóle lista wszystkich filtrów?)
*/
public function indexAction()
{
$model = new Filter();
$select = $model->select()->from('filter')->where('ghost = false');
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
//$logic = new Logic_Kontakt();
//$table = $this->addStandardActions($paginator, $logic->getTableActions());
//$this->view->headerMappings = $logic->getHeaderMappings();
// debug($paginator->getCurrentItems());die;
$this->view->paginator = $paginator;
$this->view->headers = array('filter_name', 'form_name', 'is_public');
}
public function indexAction()
{
$request = $this->getRequest();
$model = new Role();
$searchForm = new Logic_Role_Form_Filter();
$this->view->form = $searchForm;
$filter = $request->getParam('filter_is_deleted', false);
$ghost = "false";
if ($filter) {
$searchForm->getElement('filter_is_active')->setChecked(false);
$searchForm->getElement('filter_is_deleted')->setChecked(true);
$ghost = "true";
}
$select = $model->select()->from('role')->where('ghost = ' . $ghost);
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('role_name');
$this->view->headScript()->appendFile('/static/js/filtr_active.js');
}
public function showAction()
{
$request = $this->getRequest();
$id = $this->_helper->IdConvert->hexToStr($request->getParam('id'));
$logic = new Logic_Dictionary();
$data = array();
try {
list($data, $entries) = $logic->showDictionary($id);
} catch (Logic_Branch_Exception $e) {
$this->_helper->messenger->error();
$this->_helper->redirector('index');
return;
}
$entries->order($request->getParam('sort', 'id') . ' ' . $request->getParam('order', 'asc'));
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($entries));
$paginator->setCurrentPageNumber($request->getParam('page', 1));
$this->view->data = $data;
$this->view->entries = $paginator;
$this->view->headers = array('id_entry', 'entry');
}
public function listgroupsAction()
{
$options = $this->getFrontController()->getParam('bootstrap')->getApplication()->getOptions();
$model = new BranchGroup();
$select = $model->select();
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'branch_group_name');
$order = $request->getParam('order', 'asc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('branch_group_name', 'description');
}
public function baseinterestAction()
{
$request = $this->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', null);
$order = $request->getParam('order', null);
$baseInterest = new BaseInterest();
$select = $baseInterest->select();
if ($sort === null && $order === null) {
$select->order(array('created_at desc', 'period asc'));
} else {
if ($sort == 'created_at') {
$select->order(array($sort . ' ' . $order, 'period asc'));
} else {
$select->order($sort . ' ' . $order);
}
}
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('created_at', 'code', 'value');
}
public function showuserhistoryAction()
{
$request = $this->getRequest();
$id = $this->_helper->IdConvert->hexToStr($request->getParam('id'));
$logic = new Logic_User();
$select = $logic->getSqlToUserHistory($id);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($request->getParam('page', 1));
$model = new User();
$userRow = $model->findOne($id);
$back = new Zend_Session_Namespace('back');
$back->referer = '/user/showuserhistory/id/' . $request->getParam('id');
$this->view->user = $userRow;
$this->view->paginator = $paginator;
$this->view->headers = array('id_user', 'created_at', 'message', 'description');
}
/**
* Pobranie listy delegacji i zwrócenie paginatora
* @param Zend_Db_Table_Select $statement - warunki dla których ma być pobrana lista
* @return Zend_Paginator - lista delegacji
*/
private function get_items_list_paginator(Zend_Db_Table_Select $statement)
{
$request = Zend_Controller_Front::getInstance()->getRequest();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$statement->order("{$sort} {$order}");
$adapter = new Zend_Paginator_Adapter_DbTableSelect($statement);
$paginator = new Base_Paginator($adapter);
$paginator->setCurrentPageNumber($page);
return $paginator;
}
public function indextooltipAction()
{
$request = $this->getRequest();
$tooltipModel = new Tooltip();
$tooltips = $tooltipModel->select();
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$tooltips->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($tooltips));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('label', 'description');
}
public function paginator($namespace = null, $moreActions = array())
{
$this->getFilterData($namespace);
if (!$this->paginator) {
$db = $this->dbModelTable;
$expr = new Zend_Db_Expr('(' . $this->getSql() . ')');
$select = $db->select()->from($expr)->setIntegrityCheck(false);
if (isset($this->sort) && isset($this->order)) {
$select->order($this->sort . ' ' . $this->order);
}
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
if ($this->getCountSql()) {
$adapter->setRowCount($db->select()->from(new Zend_Db_Expr('(' . $this->getCountSql() . ')'), array(Zend_Paginator_Adapter_DbSelect::ROW_COUNT_COLUMN => 'zend_paginator_row_count'))->setIntegrityCheck(false));
}
$paginator = new Base_Paginator($adapter, $moreActions);
$paginator->setCurrentPageNumber(isset($this->page) ? $this->page : 1);
if ($this->page_size) {
$paginator->setItemCountPerPage($this->page_size);
}
$this->paginator = $paginator;
}
return $this->paginator;
}