/**
* The default action - show the guestbook entries
*/
public function indexAction()
{
$method = __METHOD__;
$cacheid = str_replace("::", "_", $method) . intval($this->getRequest()->getParam('page', 1));
$can_edit = false;
if (Zoo::getService('acl')->checkAccess('edit')) {
$cacheid .= "_edit";
$can_edit = true;
}
$content = $this->checkCache($cacheid);
if (!$content) {
$limit = 20;
// Offset = items per page multiplied by the page number minus 1
$offset = ($this->getRequest()->getParam('page', 1) - 1) * $limit;
$options = array('active' => true, 'nodetype' => 'guestbook_entry', 'order' => 'created DESC', 'render' => true);
$select = Zoo::getService('content')->getContentSelect($options, $offset, $limit);
$this->view->items = Zoo::getService('content')->getContent($options, $offset, $limit);
// Pagination
Zend_Paginator::setDefaultScrollingStyle('Elastic');
Zend_View_Helper_PaginationControl::setDefaultViewPartial(array('pagination_control.phtml', 'zoo'));
$adapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setItemCountPerPage($limit);
$paginator->setCurrentPageNumber($this->getRequest()->getParam('page', 1));
$paginator->setView($this->view);
$this->view->assign('paginator', $paginator);
$this->view->can_edit = $can_edit;
$content = $this->getContent();
$this->cache($content, $cacheid, array('nodelist', 'guestbook_list'));
}
$this->view->pagetitle = Zoo::_('Guestbook');
$this->renderContent($content);
}
/**
* listAction
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('core->controllers->FolderController->listAction()');
$strSearchValue = $this->getRequest()->getParam('search');
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : '';
$strOrderSort = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : '';
$intPortalId = $this->getRequest()->getParam('portalId');
$intFolderId = $this->getRequest()->getParam('folderId');
$this->getModelGlobals();
$objFolderSelect = $this->objModelGlobals->loadFolderContentById($intFolderId, $strSearchValue, $strOrderColumn, $strOrderSort);
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objFolderSelect);
$objFolderPaginator = new Zend_Paginator($objAdapter);
$objFolderPaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objFolderPaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objFolderPaginator->setView($this->view);
$this->view->assign('folderPaginator', $objFolderPaginator);
$this->view->assign('intFolderId', $intFolderId);
$this->view->assign('strOrderColumn', $strOrderColumn);
$this->view->assign('strOrderSort', $strOrderSort);
$this->view->assign('strSearchValue', $strSearchValue);
}
public function testGetsAndSetsView()
{
$this->_paginator->setView(new Zend_View());
$this->assertType('Zend_View_Interface', $this->_paginator->getView());
}
/**
* listAction
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('users->controllers->ResourceController->listAction()');
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : 'title';
$strSortOrder = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : 'asc';
$strSearchValue = $this->getRequest()->getParam('search') != '' ? $this->getRequest()->getParam('search') : '';
$objSelect = $this->getModelUsers()->getResourceTable()->select();
$objSelect->setIntegrityCheck(false);
$objSelect->from($this->getModelUsers()->getResourceTable(), array('id', 'title', 'key'));
$objSelect->joinLeft('users', 'users.id = resources.idUsers', array('CONCAT(`users`.`fname`, \' \', `users`.`sname`) AS editor', 'resources.changed'));
if ($strSearchValue != '') {
$objSelect->where('resources.title LIKE ?', '%' . $strSearchValue . '%');
$objSelect->orWhere('resources.key LIKE ?', '%' . $strSearchValue . '%');
}
$objSelect->order($strOrderColumn . ' ' . strtoupper($strSortOrder));
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objSelect);
$objResourcesPaginator = new Zend_Paginator($objAdapter);
$objResourcesPaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objResourcesPaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objResourcesPaginator->setView($this->view);
$this->view->assign('resourcePaginator', $objResourcesPaginator);
$this->view->assign('orderColumn', $strOrderColumn);
$this->view->assign('sortOrder', $strSortOrder);
$this->view->assign('searchValue', $strSearchValue);
}
public function testGetsAndSetsView()
{
$this->_paginator->setView(new View\PhpRenderer());
$this->assertInstanceOf('Zend\\View\\Renderer', $this->_paginator->getView());
}
/**
* listAction
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('properties->controllers->LocationController->listAction()');
$intUnitId = $this->getRequest()->getParam('folderId', 0);
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : 'name';
$strSortOrder = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : 'asc';
$strSearchValue = $this->getRequest()->getParam('search') != '' ? $this->getRequest()->getParam('search') : '';
$objSelect = $this->getModelLocations()->getLocationsTable()->select();
$objSelect->setIntegrityCheck(false);
$objSelect->from($this->getModelLocations()->getLocationsTable(), array('id', 'name', 'type' => new Zend_Db_Expr("'location'")));
$objSelect->joinInner('genericForms', 'genericForms.id = locations.idGenericForms', array('genericForms.genericFormId', 'genericForms.version'));
$objSelect->joinLeft('users', 'users.id = locations.idUsers', array('CONCAT(`users`.`fname`, \' \', `users`.`sname`) AS editor', 'locations.changed'));
$objSelect->where('locations.idUnits = ?', $intUnitId);
if ($strSearchValue != '') {
$objSelect->where('locations.name LIKE ?', '%' . $strSearchValue . '%');
}
$objSelect->order($strOrderColumn . ' ' . strtoupper($strSortOrder));
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objSelect);
$objGroupsPaginator = new Zend_Paginator($objAdapter);
$objGroupsPaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objGroupsPaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objGroupsPaginator->setView($this->view);
$this->view->assign('paginator', $objGroupsPaginator);
$this->view->assign('orderColumn', $strOrderColumn);
$this->view->assign('sortOrder', $strSortOrder);
$this->view->assign('searchValue', $strSearchValue);
}
public function testGetsAndSetsView()
{
$this->_paginator->setView(new View\View());
$this->assertType('Zend\\View\\ViewEngine', $this->_paginator->getView());
}
/**
* Set the View object
*
* @param \Zend_View_Interface $view
* @return \MUtil_Html_PagePanel (continuation pattern)
*/
public function setView(\Zend_View_Interface $view)
{
if ($this->_paginator) {
$this->_paginator->setView($view);
}
return parent::setView($view);
}
/**
* listAction
* @author Cornelius Hansjakob <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('contacts->controllers->MemberController->listAction()');
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : 'sname';
$strSortOrder = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : 'asc';
$strSearchValue = $this->getRequest()->getParam('search') != '' ? $this->getRequest()->getParam('search') : '';
$objSelect = $this->getModelMembers()->getMembersTable()->select();
$objSelect->setIntegrityCheck(false);
$objSelect->from($this->getModelMembers()->getMembersTable(), array('id', 'fname', 'sname', 'company' => 'companies.name', 'username', 'status' => 'contactStatus.title', 'type' => new Zend_Db_Expr("'member'")));
$objSelect->joinInner('genericForms', 'genericForms.id = members.idGenericForms', array('genericForms.genericFormId', 'genericForms.version'));
$objSelect->joinLeft('users', 'users.id = members.idUsers', array('members.changed'));
$objSelect->joinLeft('companies', 'companies.id = members.company', array());
$objSelect->joinLeft('contactStatus', 'contactStatus.id = members.status', array());
$objSelect->where('members.idRootLevels = ?', $this->getRequest()->getParam('rootLevelId'));
if ($strSearchValue != '') {
$objSelect->where('members.fname LIKE ?', '%' . $strSearchValue . '%');
$objSelect->orWhere('members.sname LIKE ?', '%' . $strSearchValue . '%');
$objSelect->orWhere('companies.name LIKE ?', '%' . $strSearchValue . '%');
$objSelect->orWhere('contactStatus.title = ?', $strSearchValue);
}
$objSelect->order($strOrderColumn . ' ' . strtoupper($strSortOrder));
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objSelect);
$objGroupsPaginator = new Zend_Paginator($objAdapter);
$objGroupsPaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objGroupsPaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objGroupsPaginator->setView($this->view);
$this->view->assign('paginator', $objGroupsPaginator);
$this->view->assign('orderColumn', $strOrderColumn);
$this->view->assign('sortOrder', $strSortOrder);
$this->view->assign('searchValue', $strSearchValue);
}
/**
* listAction
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('global->controllers->ElementController->listAction()');
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : 'title';
$strSortOrder = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : 'asc';
$strSearchValue = $this->getRequest()->getParam('search') != '' ? $this->getRequest()->getParam('search') : '';
$objSelect = $this->getModelGlobals()->getGlobalTable()->select();
$objSelect->setIntegrityCheck(false);
$objSelect->from($this->getModelGlobals()->getGlobalTable(), array('id'))->joinInner('globalProperties', 'globalProperties.globalId = globals.globalId AND globalProperties.version = globals.version AND globalProperties.idLanguages = ' . $this->core->dbh->quote(Zend_Auth::getInstance()->getIdentity()->languageId, Zend_Db::INT_TYPE), array())->joinInner('globalTitles', 'globalTitles.globalId = globals.globalId AND globalTitles.version = globals.version AND globalProperties.idLanguages = ' . $this->core->dbh->quote(Zend_Auth::getInstance()->getIdentity()->languageId, Zend_Db::INT_TYPE), array('title'))->joinLeft(array('editor' => 'users'), 'editor.id = globalProperties.idUsers', array('editor' => 'CONCAT(`editor`.`fname`, \' \', `editor`.`sname`)', 'globalProperties.changed'))->where('idParent = ?', $this->getRequest()->getParam('rootLevelId'))->where('idParentTypes = ?', $this->core->sysConfig->parent_types->rootlevel)->where('isStartGlobal = 0')->where('globalTitles.idLanguages = ?', Zend_Auth::getInstance()->getIdentity()->languageId);
if ($strSearchValue != '') {
$objSelect->where('globalTitles.title LIKE ?', '%' . $strSearchValue . '%');
}
$objSelect->order($strOrderColumn . ' ' . strtoupper($strSortOrder));
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objSelect);
$objGlobalsPaginator = new Zend_Paginator($objAdapter);
$objGlobalsPaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objGlobalsPaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objGlobalsPaginator->setView($this->view);
$this->view->assign('paginator', $objGlobalsPaginator);
$this->view->assign('orderColumn', $strOrderColumn);
$this->view->assign('sortOrder', $strSortOrder);
$this->view->assign('searchValue', $strSearchValue);
$this->getModelFolders();
$objRootLevels = $this->objModelFolders->loadAllRootLevels($this->core->sysConfig->modules->global);
$this->view->assign('rootLevels', $objRootLevels);
$this->view->assign('folderFormDefaultId', $this->core->sysConfig->form->ids->folders->default);
$this->view->assign('elementFormDefaultId', $this->core->sysConfig->global_types->product->default_formId);
$this->view->assign('elementTemplateDefaultId', $this->core->sysConfig->global_types->product->default_templateId);
$this->view->assign('elementTypeDefaultId', $this->core->sysConfig->global_types->product->id);
}
/**
* Job basic for seo.
* show all the jobs in the city.
* @return unknown_type
*/
function businessAction()
{
//echo "jobs";
$this->view = $this->_setRequiredParamsToView($this->view);
$this->view->category = $this->_busType;
try {
$this->view->business = $this->getBusiness();
$this->view->form = $this->getForm($this->view->business, $this->view->location);
//$values['cat4'] = Location::getStateIdByName($this->view->location->getState());
// $values['cat5'] = Location::getCityIdByName($this->view->location->getCity());
$cat1 = $this->view->paramsHolder->cat1;
$additonalData = $this->_getAdditionalData($this->view);
$select = $this->view->business->search($this->view->location, $this->view->limit, $this->view->offset, $this->view->paramsHolder->query, $cat1, $this->view->paramsHolder->cat2, $this->view->paramsHolder->cat3, $this->view->paramsHolder->cat4, $this->view->paramsHolder->cat5, $additonalData);
if (!empty($select)) {
logfire('------select: ', $select->__toString());
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setItemCountPerPage($this->view->limit);
$paginator->setCurrentPageNumber($this->view->offset);
Zend_Paginator::setDefaultScrollingStyle('Sliding');
Zend_View_Helper_PaginationControl::setDefaultViewPartial('sitetemplate/_pagination.phtml');
$this->view->currentItemCount = $paginator->getCurrentItemCount();
$this->view->itemCount = $paginator->getTotalItemCount();
//echo '------currentItemCoutn: ' . $this->view->currentItemCount;
$paginator->setView($this->view);
$this->view->postings = $paginator;
/*
foreach($this->view->postings as $key=>$value)
{
print_r($value);break;
}
*/
}
} catch (Exception $e) {
echo $e;
}
//$this->renderScript('jobs/index.phtml');
// echo Tag::link('jobsbasic',$this->view->location->toStdClass(),'test');
}
/**
* listAction
* @author Cornelius Hansjakob <*****@*****.**>
* @version 1.0
*/
public function listAction()
{
$this->core->logger->debug('media->controllers->ViewController->listAction()');
$strSearchValue = $this->getRequest()->getParam('search');
$strOrderColumn = $this->getRequest()->getParam('order') != '' ? $this->getRequest()->getParam('order') : '';
$strOrderSort = $this->getRequest()->getParam('sort') != '' ? $this->getRequest()->getParam('sort') : '';
$objRequest = $this->getRequest();
$intFolderId = $objRequest->getParam('folderId');
/**
* get files
*/
$this->getModelFiles();
$objFilesSelect = $this->objModelFiles->loadFiles($intFolderId, -1, false, true, $strSearchValue, $strOrderColumn, $strOrderSort);
$objAdapter = new Zend_Paginator_Adapter_DbTableSelect($objFilesSelect);
$objFilePaginator = new Zend_Paginator($objAdapter);
$objFilePaginator->setItemCountPerPage((int) $this->getRequest()->getParam('itemsPerPage', $this->core->sysConfig->list->default->itemsPerPage));
$objFilePaginator->setCurrentPageNumber($this->getRequest()->getParam('page'));
$objFilePaginator->setView($this->view);
$this->view->assign('filePaginator', $objFilePaginator);
$this->view->assign('intFolderId', $intFolderId);
$this->view->assign('strOrderColumn', $strOrderColumn);
$this->view->assign('strOrderSort', $strOrderSort);
$this->view->assign('strSearchValue', $strSearchValue);
$this->assignSecurityOptions();
}
public function testGetsAndSetsView()
{
$this->_paginator->setView(new Zend_View());
$this->assertTrue($this->_paginator->getView() instanceof Zend_View_Interface);
}
/**
* List files in a category
*/
public function listAction()
{
$found = Zoo::getService('content')->find($this->_request->getParam('id'));
if ($found->count() == 0) {
throw new Zend_Controller_Action_Exception(Zoo::_("Category does not exist"), 404);
}
$category = $found->current();
$this->view->assign('category', $category);
$limit = $this->getRequest()->getParam('limit', 20);
// Offset = items per page multiplied by the page number minus 1
$offset = ($this->getRequest()->getParam('page', 1) - 1) * $limit;
$order = $this->getRequest()->getParam('order', "created DESC");
$nodetype = $this->getRequest()->getParam('nodetype', "filemanager_file");
$options = array('active' => true, 'nodetype' => $nodetype, 'parent' => $category->id, 'order' => $order, 'render' => false);
$select = Zoo::getService('content')->getContentSelect($options, $offset, $limit);
$this->view->items = Zoo::getService('content')->getContent($options, $offset, $limit);
// Pagination
Zend_Paginator::setDefaultScrollingStyle('Elastic');
Zend_View_Helper_PaginationControl::setDefaultViewPartial('file/pagination_control.phtml');
$adapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setItemCountPerPage($limit);
$paginator->setCurrentPageNumber($this->getRequest()->getParam('page', 1));
$paginator->setView($this->view);
$this->view->assign('paginator', $paginator);
}
public function testGetSetView()
{
$this->_restorePaginatorDefaults();
$this->_paginator->setView(new Zend_View());
$this->assertType('Zend_View_Interface', $this->_paginator->getView());
}
