public function indexAction()
{
$params = array();
$modul = $this->getRequest()->getParam('modul');
$action = $this->getRequest()->getParam('actionType');
$data_inceput = $this->getRequest()->getParam('data_inceput');
$data_sfarsit = $this->getRequest()->getParam('data_sfarsit');
//form cautare dupa modul/tip de actiune/data
$form = new Default_Form_SearchLogs();
$form->modul->setValue($modul);
$form->actionType->setValue($action);
$form->data_inceput->setValue($data_inceput);
$form->data_sfarsit->setValue($data_sfarsit);
$form->setDecorators(array('ViewScript', array('ViewScript', array('viewScript' => 'forms/logs/search.phtml'))));
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
if ($form->isValid($this->getRequest()->getPost())) {
$post = $this->getRequest()->getPost();
$model = new Default_Model_Logs();
$model->setOptions($form->getValues());
}
}
//end form
//fetch loguri
$logs = new Default_Model_Logs();
$select = $logs->getMapper()->getDbTable()->select();
if (!empty($action)) {
$params['actionType'] = $action;
$select->where('actionType = ?', $action);
}
if (!empty($modul)) {
$params['modul'] = $modul;
$select->where('modul = ?', $modul);
}
if (!empty($data_inceput)) {
$params['data_inceput'] = $data_inceput;
$select->where("DATE(created) >= ?", $data_inceput);
}
if (!empty($data_sfarsit)) {
$params['data_sfarsit'] = $data_sfarsit;
$select->where("DATE(created) <= ?", $data_sfarsit);
}
$select->order('created DESC');
$result = $logs->fetchAll($select);
if (NULL != $result) {
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(10);
$paginator->setCurrentPageNumber($this->_getParam('page'));
$paginator->setPageRange(5);
$this->view->result = $paginator;
$this->view->itemCountPerPage = $paginator->getItemCountPerPage();
$this->view->totalItemCount = $paginator->getTotalItemCount();
Zend_Paginator::setDefaultScrollingStyle('Sliding');
Zend_View_Helper_PaginationControl::setDefaultViewPartial(array('_pagination.phtml', $params));
}
}
public function fetchRow($select, Default_Model_Logs $model)
{
$result = $this->getDbTable()->fetchRow($select);
if (0 == count($result)) {
return;
}
$model->setOptions($result->toArray());
return $model;
}
