/**
* Get current items to display on current page
* @access public
* @return object ArrayIterator
*/
public function getCurrentItems()
{
$this->_paginator->setItemCountPerPage($this->_itemCountPerPage);
$this->_paginator->setCurrentPageNumber($this->_currentPage);
if ($this->_currentItems === null) {
$this->_currentItems = $this->_paginator->getCurrentItems();
}
return $this->_currentItems;
}
protected function _addPaginator($oOperation)
{
//dodaj standardowe metody grida
// list($sDBSort, $sDBOrder) = $this->_getDatabaseSort();
// $oOperation->setSort($sDBSort);
// $oOperation->setOrder($sDBOrder);
// $oOperation->setSearch($this->_getDatabaseSearch());
$oOperation->init();
//grid paginowany
$page = $this->getRequest()->getParam('page', 1);
// $iResultLimit = $this->_getDatabaseResultLimit();
if (method_exists($oOperation, 'pageLimit')) {
$iResultLimit = $oOperation->pageLimit();
}
$adapter = new Zend_Paginator_Adapter_DbSelect($oOperation->getSelect());
$adapter->setRowCount($oOperation->getSelectCount());
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber($page);
$paginator->setItemCountPerPage($iResultLimit);
if ($paginator->count() == 0) {
Message_Operation_Flash::setMsg('Brak rekordów', Message_Operation_Flash::LEVEL_DANGER);
}
$this->view->paginator = $paginator;
//config
$this->view->config_url = $this->_oConfig->url;
}
public function indexAction()
{
/**
* Form cadastro
*/
$formPropostaCadastro = new Form_Site_PropostaCadastro();
$formPropostaCadastro->submit->setLabel("CADASTRAR");
//$formPropostaCadastro->proposta_numero->setValue($this->getNumeroProposta());
$this->view->formPropostaCadastro = $formPropostaCadastro;
/**
* Busca as propostas
*/
$page = $this->getRequest()->getParam('page', 1);
//get curent page param, default 1 if param not available.
$modelProposta = new Model_DbTable_Proposta();
$data = $modelProposta->getQuery();
$adapter = new Zend_Paginator_Adapter_DbSelect($data);
//adapter
$paginator = new Zend_Paginator($adapter);
// setup Pagination
$paginator->setItemCountPerPage(Zend_Registry::get("config")->resource->rowspage);
// Items perpage, in this example is 10
$paginator->setCurrentPageNumber($page);
// current page
//Zend_Paginator::setDefaultScrollingStyle('Sliding');
//Zend_View_Helper_PaginationControl::setDefaultViewPartial('partials/pagination.phtml');
$this->view->propostas = $paginator;
}
public function testNoPagesBeforeSecondLastPageEqualsPageRangeMinTwo()
{
$this->_paginator->setPageRange(3);
$this->_paginator->setCurrentPageNumber(19);
$pages = $this->_paginator->getPages('Elastic');
$this->assertEquals(5, count($pages->pagesInRange));
}
public function getAll($active = false, $lng = 'nl', $paginator = true, $pindex = 1, $perpage = 25, $cache = true)
{
if ($cache == true) {
$cacheId = $this->generateCacheId(get_class($this) . '_' . __FUNCTION__, func_get_args());
$cache = Zend_Registry::get('cache');
if (true == ($result = $cache->load($cacheId))) {
return $result;
}
}
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('n' => 'News'), array('*'))->joinLeft(array('t' => 'NewsTsl', array('lng', 'title', 'summary', 'content', 'url', 'seo_keywords', 'seo_title', 'seo_description', 'active')), 'n.nid = t.nid')->where('t.lng = ?', $lng);
if ($active) {
$select->where('t.active = 1')->where('n.date_published <= NOW()')->where('n.date_expired > NOW() OR n.date_expired is NULL')->order('n.date_message DESC')->order('n.date_published DESC');
} else {
$select->order('n.date_published DESC')->order('n.date_created DESC');
}
if ($paginator === true) {
$adapter = new Base_PaginatorAdapter($select);
$adapter->setMapper($this->_mapper);
$data = new Zend_Paginator($adapter);
$data->setCurrentPageNumber((int) $pindex);
$data->setItemCountPerPage((int) $perpage);
} else {
$results = $db->fetchAll($select);
$data = $this->_mapper->mapAll($results);
}
if ($cache == true) {
$cacheTags = $this->generateCacheTags(get_class($this) . '_' . __FUNCTION__);
$cache->save($data, $cacheId, $cacheTags);
}
return $data;
}
public function selectAll($pageNumber = 1, $filter = array())
{
$db = $this->siteDbAdapter->select()->from($this->tablename);
foreach ($filter as $key => $val) {
if ($val) {
if (is_int($val)) {
$db->where($key . ' = ?', $val);
} else {
$db->where($key . ' LIKE ?', '%' . $val . '%');
}
}
}
$db->order('log_date DESC');
$adapter = new Zend_Paginator_Adapter_DbSelect($db);
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage($this->countPerPage);
$paginator->setPageRange($this->pageRange);
return $paginator;
/*
$select = $this->siteDbAdapter->select();
$select->from($this->tablename);
$select->order(array('log_id'));
$log = $this->siteDbAdapter->fetchAll($select->__toString());
return $log;
*/
}
public function indexAction()
{
$query = trim($this->getRequest()->getQuery('q', ''));
$this->view->query = $query;
if (!empty($query)) {
$count = 10;
$page = (int) $this->getRequest()->getQuery('p', 1);
if ($page < 1) {
$page = 1;
}
// Prepare the common options
$options = array('market' => 'en-GB');
// We want web and image search results
$sources = array('web' => array('count' => $count, 'offset' => $count * ($page - 1)));
// Adjust the query to only search the noginn.com domain
$query .= ' site:noginn.com';
// Perform the search!
$bing = new Noginn_Service_Bing('__APP_ID__');
$result = $bing->search($query, $sources, $options);
$webResults = $result->getSource('web');
$this->view->webResults = $webResults;
// Paginate the results
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Null($webResults->getTotal()));
$paginator->setCurrentPageNumber($page);
$paginator->setItemCountPerPage($count);
$this->view->paginator = $paginator;
}
}
public function getAll($paginator = true, $pindex = 1, $perpage = 25, $cache = true)
{
if ($cache == true) {
$cacheId = $this->generateCacheId(get_class($this) . '_' . __FUNCTION__, func_get_args());
$cache = Zend_Registry::get('cache');
if (true == ($result = $cache->load($cacheId))) {
return $result;
}
}
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('a' => 'Sheets'), array('*'))->join(array('t' => 'SheetsTsl'), 'a.id = t.s_id', array('lng', 'name', 't_desc', 't_file'))->join(array('ty' => 'SheetsSubtype'), 'a.subtype = ty.subtype_id', array())->join(array('tyt' => 'SheetsSubtypeTsl'), 'ty.subtype_id = tyt.subtype_id', array('name as subtypename'))->join(array('st' => 'SheetsType'), 'a.type = st.type_id', array())->join(array('stt' => 'SheetsTypeTsl'), 'st.type_id = stt.type_id', array('name as typename'))->where('t.lng = ?', $_SESSION['System']['lng'])->where('tyt.lng = ?', $_SESSION['System']['lng'])->where('stt.lng = ?', $_SESSION['System']['lng'])->order('st.position ASC')->order('ty.position ASC')->order('a.place ASC');
if ($paginator === true) {
$adapter = new Base_PaginatorAdapter($select);
$adapter->setMapper($this->_mapper);
$data = new Zend_Paginator($adapter);
$data->setCurrentPageNumber((int) $pindex);
$data->setItemCountPerPage((int) $perpage);
} else {
$results = $db->fetchAll($select);
$data = $this->_mapper->mapAll($results);
}
if ($cache == true) {
$cacheTags = $this->generateCacheTags(get_class($this) . '_' . __FUNCTION__);
$cache->save($data, $cacheId, $cacheTags);
}
return $data;
}
/**
* Consulta notas para exportar RPS
*/
public function rpsConsultarAction()
{
parent::noTemplate();
$aParametros = $this->getRequest()->getParams();
/**
* Verifica se foi informado mês e ano da competência
*/
if (!empty($aParametros['mes_competencia']) && !empty($aParametros['ano_competencia'])) {
$oContribuinte = $this->_session->contribuinte;
$sCodigosContribuintes = implode(',', $oContribuinte->getContribuintes());
$oPaginatorAdapter = new DBSeller_Controller_Paginator(Contribuinte_Model_Nota::getQuery(), 'Contribuinte_Model_Nota', 'Contribuinte\\Nota');
/**
* Monta a query de consulta
*/
$oPaginatorAdapter->where("e.id_contribuinte in ({$sCodigosContribuintes})");
$oPaginatorAdapter->andWhere("e.mes_comp = {$aParametros['mes_competencia']}");
$oPaginatorAdapter->andWhere("e.ano_comp = {$aParametros['ano_competencia']}");
if (!empty($aParametros['numero_rps'])) {
$oPaginatorAdapter->andWhere("e.nota = {$aParametros['numero_rps']}");
}
$oPaginatorAdapter->orderBy('e.nota', 'DESC');
/**
* Monta a paginação do GridPanel
*/
$oResultado = new Zend_Paginator($oPaginatorAdapter);
$oResultado->setItemCountPerPage(10);
$oResultado->setCurrentPageNumber($this->_request->getParam('page'));
foreach ($oResultado as $oNota) {
$oNota->oContribuinte = $oContribuinte;
$oNota->lNaoGeraGuia = !$oNota->getEmite_guia();
$oNota->lGuiaEmitida = Contribuinte_Model_Guia::existeGuia($oContribuinte, $oNota->getMes_comp(), $oNota->getAno_comp(), Contribuinte_Model_Guia::$DOCUMENTO_ORIGEM_NFSE);
/**
* Informações da nota substituta
*/
$oNota->oNotaSubstituida = NULL;
if ($oNota->getIdNotaSubstituida()) {
$oNota->oNotaSubstituida = Contribuinte_Model_Nota::getById($oNota->getIdNotaSubstituida());
}
/**
* Informações da nota substituta
*/
$oNota->oNotaSubstituta = NULL;
if ($oNota->getIdNotaSubstituta()) {
$oNota->oNotaSubstituta = Contribuinte_Model_Nota::getById($oNota->getIdNotaSubstituta());
}
}
/**
* Valores da pesquisa para montar a paginação
*/
if (is_array($aParametros)) {
foreach ($aParametros as $sParametro => $sParametroValor) {
if ($sParametroValor) {
$sParametroValor = str_replace('/', '-', $sParametroValor);
$this->view->sBusca .= "{$sParametro}/{$sParametroValor}/";
}
}
}
$this->view->oDadosNota = $oResultado;
}
}
function adminlistAction()
{
$this->rowsPerPage = 4;
if ($this->_request->getParam('page')) {
$this->curPage = $this->_request->getParam('page');
} else {
$this->curPage = 1;
}
$messages = $this->_mail->getUniqueId();
//print_r($curPage);die;
$content = array();
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($messages));
if (count($messages)) {
for ($i = ($this->curPage - 1) * $this->rowsPerPage + 1; $i <= $this->curPage * $this->rowsPerPage; $i++) {
$message[$i] = $this->_mail->getMessage($i);
$content[$i] = $message[$i]->getContent();
}
}
$this->view->paginator = $paginator;
$paginator->setCurrentPageNumber($this->curPage)->setItemCountPerPage($this->rowsPerPage);
$this->view->controller = $this->_request->getControllerName();
$this->view->action = $this->_request->getActionName();
$this->view->content = $content;
$this->view->message = $message;
$this->view->inbox = $this->_inbox;
//print_r ( $this->_inbox );
//die ();
}
/**
* List all Queues
*/
public function indexAction()
{
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Queues")));
$this->view->url = $this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName();
$db = Zend_Registry::get('db');
$select = $db->select()->from("queue");
if ($this->_request->getPost('filtro')) {
$field = mysql_escape_string($this->_request->getPost('campo'));
$query = mysql_escape_string($this->_request->getPost('filtro'));
$select->where("{$field} LIKE '%{$query}%'");
}
$page = $this->_request->getParam('page');
$this->view->page = isset($page) && is_numeric($page) ? $page : 1;
$this->view->filtro = $this->_request->getParam('filtro');
$paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($paginatorAdapter);
$paginator->setCurrentPageNumber($this->view->page);
$paginator->setItemCountPerPage(Zend_Registry::get('config')->ambiente->linelimit);
$this->view->queues = $paginator;
$this->view->pages = $paginator->getPages();
$this->view->PAGE_URL = "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/";
$opcoes = array("name" => $this->view->translate("Name"), "musiconhold" => $this->view->translate("Audio Class"), "strategy" => $this->view->translate("Strategy"), "servicelevel" => $this->view->translate("SLA"), "timeout" => $this->view->translate("Timeout"));
$filter = new Snep_Form_Filter();
$filter->setAction($this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName() . '/index');
$filter->setValue($this->_request->getPost('campo'));
$filter->setFieldOptions($opcoes);
$filter->setFieldValue($this->_request->getPost('filtro'));
$filter->setResetUrl("{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/page/{$page}");
$this->view->form_filter = $filter;
$this->view->filter = array(array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/add/", "display" => $this->view->translate("Add Queue"), "css" => "include"));
}
/**
* 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);
}
public function listAction()
{
// get the filter form
$listToolsForm = new Form_BugReportListToolsForm();
$listToolsForm->setAction('/bug/list');
$listToolsForm->setMethod('post');
$this->view->listToolsForm = $listToolsForm;
// set the sort and filter criteria. you need to update this to use the request,
// as these values can come in from the form post or a url parameter
$sort = $this->_request->getParam('sort', null);
$filterField = $this->_request->getParam('filter_field', null);
$filterValue = $this->_request->getParam('filter');
if (!empty($filterField)) {
$filter[$filterField] = $filterValue;
} else {
$filter = null;
}
// now you need to manually set these controls values
$listToolsForm->getElement('sort')->setValue($sort);
$listToolsForm->getElement('filter_field')->setValue($filterField);
$listToolsForm->getElement('filter')->setValue($filterValue);
// fetch the bug paginator adapter
$bugModels = new Model_Bug();
$adapter = $bugModels->fetchPaginatorAdapter($filter, $sort);
$paginator = new Zend_Paginator($adapter);
// show 10 bugs per page
$paginator->setItemCountPerPage(10);
// get the page number that is passed in the request.
//if none is set then default to page 1.
$page = $this->_request->getParam('page', 1);
$paginator->setCurrentPageNumber($page);
// pass the paginator to the view to render
$this->view->paginator = $paginator;
}
public function CusFevRestauarants(User_Model_FevRestById $userid, $offset)
{
try {
$id = $userid->getUserId();
$query = $this->getDbTable()->select();
$query->setIntegrityCheck(false);
$query->from(array('crc' => 'rd.customer_restaurant_choice'), array('crcfk_user', 'crcrestaurant_id'));
$query->join(array('res' => 'rd.restaurant_details'), 'res.resid = crc.crcrestaurant_id', array('resid', 'resname', 'resaddress', 'resdescription', 'resimage'));
$query->join(array('nbh' => 'rd.neighborhood_bd'), 'nbh.id = res.resneighborhood_id', array('description as neighbor'));
$query->join(array('rgn' => 'rd.region_bd'), 'rgn.id = res.resregion_id', array('description as region'));
$query->join(array('cty' => 'rd.city_bd'), 'cty.id = res.rescity_id', array('description as city'));
$query->join(array('sbd' => 'rd.state_bd'), 'sbd.id = res.resstate_id', array('description as state'));
$query->where('crc.crcstatus =? ', 'TRUE');
$query->where('crc.crcfk_user = ?', $id);
$query->where('rescategory_id = 2');
$query->order('crcid DESC');
//$Result = $this->getDbTable()->fetchAll($query);
$Result = new Zend_Paginator(new Zend_Paginator_Adapter_DbTableSelect($query));
$Result->setItemCountPerPage(10);
$Result->setCurrentPageNumber($offset);
$resultList = array();
foreach ($Result as $value) {
$resdesc = $value->resdescription;
if (strlen($resdesc) > 1000) {
$resdesc = substr($resdesc, 0, 1000) . "...";
}
$obj = new User_Model_CustomerRestChoice();
$obj->setRestId($value->resid)->setRestaurantname($value->resname)->setRestneighboorhood($value->neighbor)->setRestRegion($value->city)->setRestCity($value->city)->setRestState($value->state)->setResAddress($value->resaddress)->setResDesc($resdesc)->setRestImage($value->resimage);
$resultList[] = $obj;
}
return $Result;
} catch (Exception $ex) {
throw new Exception($ex->getMessage());
}
}
/**
* Get all reviews
*
*/
public function getReviews($paged = null, $order = array(), $filter = null)
{
$grid = array();
$grid['cols'] = $this->getGridColumns();
$grid['primary'] = $this->_primary;
$select = $this->select();
if (!empty($order[0])) {
$order = $order[0] . ' ' . $order[1];
} else {
$order = 'inserted ASC';
}
$select->order($order);
$select->from('reviews', array_keys($this->getGridColumns()));
if ($filter) {
$select->where('submission_id = ?', (int) $filter);
}
if ($paged) {
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber((int) $paged)->setItemCountPerPage(20);
$grid['rows'] = $paginator;
return $grid;
}
$grid['rows'] = $this->fetchAll($select);
return $grid;
}
public function getAll($lng, $paginator = true, $pindex = 1, $perpage = 25, $cache = true)
{
if ($cache == true) {
$cacheId = $this->generateCacheId(get_class($this) . '_' . __FUNCTION__, func_get_args());
$cache = Zend_Registry::get('cache');
if (true == ($result = $cache->load($cacheId))) {
return $result;
}
}
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('a' => 'ContentBlocks'), array('a.*'))->join(array('t' => 'ContentBlocksTsl'), 'a.id = t.b_id', array('t.*'))->where('t.lng = ?', $lng);
$results = $db->fetchAll($select);
if ($paginator === true) {
$adapter = new Base_PaginatorAdapter($select);
$adapter->setMapper($this->_mapper);
$data = new Zend_Paginator($adapter);
$data->setCurrentPageNumber((int) $pindex);
$data->setItemCountPerPage((int) $perpage);
} else {
$results = $db->fetchAll($select);
$data = $this->_mapper->mapAll($results);
}
if ($cache == true) {
$cacheTags = $this->generateCacheTags(get_class($this) . '_' . __FUNCTION__);
$cache->save($data, $cacheId, $cacheTags);
}
return $data;
}
public function getUsers($paged = null, $order = array(), $filter = null)
{
$grid = array();
$grid['cols'] = $this->getGridColumns();
$grid['primary'] = $this->_primary;
$select = $this->select();
if (!empty($order[0])) {
$order = 'lower(' . $order[0] . ') ' . $order[1];
} else {
$order = 'lower(lname) ASC';
}
$select->order($order)->from('vw_users', array_keys($this->getGridColumns()));
if ($filter) {
// apply filters to grid
if ($filter->filters) {
foreach ($filter->filters as $field => $value) {
if (is_array($value)) {
$select->where($field . ' IN (?)', $value);
} else {
$select->where($field . ' = ?', $value);
}
}
}
}
if ($paged) {
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber((int) $paged)->setItemCountPerPage(20);
$grid['rows'] = $paginator;
return $grid;
}
$grid['rows'] = $this->fetchAll($select);
return $grid;
}
/**
* List all Contacts
*/
public function indexAction()
{
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Contacts")));
$this->view->url = $this->getFrontController()->getBaseUrl() . "/" . $this->getRequest()->getControllerName();
$db = Zend_Registry::get('db');
$select = $db->select()->from(array("n" => "contact"), array("n.id_contact as id", "n.ds_name as name", "n.ds_city as city", "n.ds_state as state", "n.ds_cep as cep", "n.ds_phone as phone", "n.ds_cell_phone as cellphone", "g.ds_name as group"))->join(array("g" => "contact_group"), 'n.id_contact_group = g.id_contact_group', array())->order('n.id_contact');
if ($this->_request->getPost('filtro')) {
$field = pg_escape_string($this->_request->getPost('campo'));
$query = pg_escape_string($this->_request->getPost('filtro'));
$select->where("{$field} like '%{$query}%'");
}
$page = $this->_request->getParam('page');
$this->view->page = isset($page) && is_numeric($page) ? $page : 1;
$this->view->filtro = $this->_request->getParam('filtro');
$paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($paginatorAdapter);
$paginator->setCurrentPageNumber($this->view->page);
$paginator->setItemCountPerPage(Zend_Registry::get('config')->ambiente->linelimit);
$this->view->contacts = $paginator;
$this->view->pages = $paginator->getPages();
$this->view->PAGE_URL = "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/";
/*Opcoes do Filtro*/
$opcoes = array("n.ds_name" => $this->view->translate("Name"), "n.ds_city" => $this->view->translate("City"), "n.ds_state" => $this->view->translate("State"), "n.ds_cep" => $this->view->translate("ZIP Code"), "n.ds_phone" => $this->view->translate("Phone"), "n.ds_cell_phone" => $this->view->translate("Cellphone"));
$filter = new Snep_Form_Filter();
$filter->setAction($this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName() . '/index');
$filter->setValue($this->_request->getPost('campo'));
$filter->setFieldOptions($opcoes);
$filter->setFieldValue($this->_request->getPost('filtro'));
$filter->setResetUrl("{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/page/{$page}");
$this->view->form_filter = $filter;
$this->view->filter = array(array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/add/", "display" => $this->view->translate("Add Contact"), "css" => "include"), array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/multi-remove/", "display" => $this->view->translate("Remove Multiple"), "css" => "exclude"), array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/import/", "display" => $this->view->translate("Import CSV"), "css" => "import"), array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/export/", "display" => $this->view->translate("Export CSV"), "css" => "export"));
}
public function getAll($paginator = true, $pindex = 1, $perpage = 25, $cache = true)
{
if ($cache == true) {
$cacheId = 'SxModule_Pageform_Subscription_Meta_getAll_' . sha1(var_export($paginator, true) . '_' . var_export($pindex, true) . '_' . var_export($perpage, true));
$cache = Zend_Registry::get('cache');
if (true == ($result = $cache->load($cacheId))) {
return $result;
}
}
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('i' => $this->_tablename()), array('*'));
if ($paginator === true) {
$adapter = new Base_PaginatorAdapter($select);
$adapter->setMapper($this->_mapper);
$data = new Zend_Paginator($adapter);
$data->setCurrentPageNumber((int) $pindex);
$data->setItemCountPerPage((int) $perpage);
} else {
$results = $db->fetchAll($select);
$data = $this->_mapper->mapAll($results);
}
if ($cache == true) {
$cacheTags = array('SxModule_Pageform_Subscription_Meta', 'SxModule_Pageform_Subscription_Meta_getAll', 'SxModule_Pageform_Subscription', 'SxModule_Pageform');
$cache->save($data, $cacheId, $cacheTags);
}
return $data;
}
public function indexAction()
{
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Pickup Groups")));
$db = Zend_Registry::get('db');
$select = $db->select()->from("pickup_group");
if ($this->_request->getPost('filtro')) {
$field = mysql_escape_string($this->_request->getPost('campo'));
$query = mysql_escape_string($this->_request->getPost('filtro'));
$select->where("`{$field}` like '%{$query}%'");
}
$page = $this->_request->getParam('page');
$this->view->page = isset($page) && is_numeric($page) ? $page : 1;
$this->view->filtro = $this->_request->getParam('filtro');
$paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($paginatorAdapter);
$paginator->setCurrentPageNumber($this->view->page);
$paginator->setItemCountPerPage(Zend_Registry::get('config')->ambiente->linelimit);
$this->view->pickupgroups = $paginator;
$this->view->pages = $paginator->getPages();
$this->view->URL = "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/";
$this->view->PAGE_URL = "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/";
$opcoes = array("ds_name" => $this->view->translate("Name"));
// Formulário de filtro.
$filter = new Snep_Form_Filter();
$filter->setAction($this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName() . '/index');
$filter->setValue($this->_request->getPost('campo'));
$filter->setFieldOptions($opcoes);
$filter->setFieldValue($this->_request->getPost('filtro'));
$filter->setResetUrl("{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/page/{$page}");
$this->view->form_filter = $filter;
$this->view->filter = array(array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/add", "display" => $this->view->translate("Add Pickup Group"), "css" => "include"));
}
public function testToJson()
{
$this->_paginator->setCurrentPageNumber(1);
$json = $this->_paginator->toJson();
$expected = '"0":1,"1":2,"2":3,"3":4,"4":5,"5":6,"6":7,"7":8,"8":9,"9":10';
$this->assertContains($expected, $json);
}
public function listAction()
{
// create search form
$searchForm = new Admin_Form_RouteSearch();
$searchForm->setAction('/admin/route/list')->setMethod('post');
$this->view->searchForm = $searchForm;
// get params from request
$sorter = $this->_request->getParam('sorter', null);
$filter = $this->_request->getParam('filter', null);
$filterText = $this->_request->getParam('filterText', null);
// populate them to form
$searchForm->getElement('sorter')->setValue($sorter);
$searchForm->getElement('filter')->setValue($filter);
$searchForm->getElement('filterText')->setValue($filterText);
// list route
$routeModel = new Admin_Model_Route();
$routeAdapter = $routeModel->getRoutePaginatorAdapter($filter, $filterText, $sorter);
if ($routeAdapter) {
$paginator = new Zend_Paginator($routeAdapter);
$page = $this->_request->getParam('page', 1);
$paginator->setItemCountPerPage(5);
$paginator->setCurrentPageNumber($page);
$paginator->setPageRange(8);
$this->view->paginator = $paginator;
}
}
/**
* @param string $modelName
* @param array $options
* @param Doctrine_Query_Abstract $query
* @return string
*/
public function modelList($modelName, array $options = array(), Doctrine_Query_Abstract $query = null)
{
$options = array_merge(self::$_defaultOptions, $options);
if (!$options['paginationScript']) {
$options['paginationScript'] = 'partials/pagination.phtml';
}
$table = Doctrine_Core::getTable($modelName);
if (!$query) {
$query = $table->createQuery();
}
$adapter = new FansubCMS_Paginator_Adapter_Doctrine($query);
$paginator = new Zend_Paginator($adapter);
$front = Zend_Controller_Front::getInstance();
$request = $front->getRequest();
$currentPage = $request->getParam('page', 1);
$paginator->setCurrentPageNumber($currentPage);
$paginator->setItemCountPerPage($options['itemsPerPage']);
if (!isset($options['listScript'])) {
$options['listScript'] = 'partials/table.phtml';
}
if (!isset($options['showFieldNames'])) {
$fieldNames = $this->getAutoFieldNames($table);
} else {
$fieldNames = $options['showFieldNames'];
}
return $this->view->partial($options['listScript'], array('modelName' => $modelName, 'paginator' => $paginator, 'currentPage' => $currentPage, 'options' => $options, 'fieldNames' => $fieldNames));
}
function adminimagereportAction()
{
$this->view->title = 'Reports';
$this->view->activeTab = 'Reports';
$this->_helper->layout->setLayout("layout_admin");
$this->view->campaign_id = $this->_request->getParam('id');
$curPage = 1;
$rowsPerPage = 50;
if ($this->_request->getParam('page')) {
$curPage = $this->_request->getParam('page');
}
$db = Zend_Registry::get('db');
$select = $db->select();
$select->from('image_report', array('id', 'image', 'state', 'create_date', 'consumer_id', 'thumb_width', 'thumb_height'))->join('consumer', 'consumer.id = image_report.consumer_id', array('email', 'name', 'recipients_name', 'language_pref'))->joinLeft('image_report_reply', 'image_report_reply.image_report_id = image_report.id', 'content')->joinLeft('reward_point_transaction_record', 'reward_point_transaction_record.id = image_report.reward_point_transaction_record_id', 'point_amount')->where('campaign_id = ?', $this->view->campaign_id)->where('consumer.pest is null')->order('create_date desc');
$this->view->imageReports = $db->fetchAll($select);
//paging
$this->view->controller = $this->_request->getControllerName();
$this->view->action = $this->_request->getActionName();
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($this->view->imageReports));
$paginator->setCurrentPageNumber($curPage)->setItemCountPerPage($rowsPerPage);
$this->view->paginator = $paginator;
// Zend_Debug::dump($this->view->duplicatedUrlArray);
Zend_View_Helper_PaginationControl::setDefaultViewPartial('pagination/pagelist.phtml');
$this->view->NoInitValue = ($curPage - 1) * $rowsPerPage + 1;
}
/**
* Display a list of all users in the system.
*
*/
public function indexAction()
{
$filterStatus = $this->_getParam('status', 'any');
$filterTrigger = $this->_getParam('trigger', 'any');
$filterSort = $this->_getParam('sort', 'queueDt');
$filterDirection = $this->_getParam('direction', 'asc');
$form = new Ot_Form_EmailqueueSearch();
$form->populate($_GET);
$eq = new Ot_Model_DbTable_EmailQueue();
$select = new Zend_Db_Table_Select($eq);
if ($filterStatus != '' && $filterStatus != 'any') {
$select->where('status = ?', $filterStatus);
}
if ($filterTrigger != '' && $filterTrigger != 'any') {
$select->where('attributeName = ?', 'triggerActionId');
$select->where('attributeId = ?', $filterTrigger);
}
$select->order($filterSort . ' ' . $filterDirection);
$adapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber($this->_getParam('page', 1));
$ta = new Ot_Model_DbTable_TriggerAction();
$actions = $ta->fetchAll();
$triggers = array();
foreach ($actions as $a) {
$triggers[$a->triggerActionId] = $a;
}
$this->_helper->pageTitle('ot-emailqueue-index:title');
$this->view->assign(array('paginator' => $paginator, 'form' => $form, 'interface' => true, 'sort' => $filterSort, 'direction' => $filterDirection, 'triggers' => $triggers));
}
public function indexAction()
{
// @todo localização das datas na listagem da view
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Users")));
$this->view->url = $this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName();
$db = Zend_Registry::get('db');
$select = $db->select()->from("user");
if ($this->_request->getPost('filtro')) {
$field = mysql_escape_string($this->_request->getPost('campo'));
$query = mysql_escape_string($this->_request->getPost('filtro'));
$select->where("{$field} LIKE '%{$query}%'");
}
$page = $this->_request->getParam('page');
$this->view->page = isset($page) && is_numeric($page) ? $page : 1;
$this->view->filtro = $this->_request->getParam('filtro');
$paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($select);
$paginator = new Zend_Paginator($paginatorAdapter);
$paginator->setCurrentPageNumber($this->view->page);
$paginator->setItemCountPerPage(Zend_Registry::get('config')->ambiente->linelimit);
$this->view->users = $paginator;
$this->view->pages = $paginator->getPages();
$this->view->PAGE_URL = "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/";
$opcoes = array('ds_login' => $this->view->translate('Name'), 'ds_mail' => $this->view->translate('E-mail'));
$this->view->active = array(1 => $this->view->translate('Yes'), 0 => $this->view->translate('No'));
$filter = new Snep_Form_Filter();
$filter->setAction($this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName() . '/index');
$filter->setValue($this->_request->getPost('campo'));
$filter->setFieldOptions($opcoes);
$filter->setFieldValue($this->_request->getPost('filtro'));
$filter->setResetUrl("{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/index/page/{$page}");
$this->view->form_filter = $filter;
$this->view->filter = array(array("url" => "{$this->getFrontController()->getBaseUrl()}/{$this->getRequest()->getControllerName()}/add/", "display" => $this->view->translate("Add User"), "css" => "include"));
}
public function getAll($lng = 'nl', $active = false, $paginator = true, $pindex = 1, $perpage = 25, $cache = true)
{
if ($cache == true) {
$cacheId = $this->generateCacheId(get_class($this) . '_' . __FUNCTION__, func_get_args());
$cache = Zend_Registry::get('cache');
if (true == ($result = $cache->load($cacheId))) {
return $result;
}
}
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('a' => 'WebTv'), array('*'))->join(array('t' => 'WebTvTsl'), 'a.id = t.webtv_id', array('url', 'lng', 'title', 'description', 'active'))->where('t.lng = ?', $lng)->order('a.date_published DESC');
if ($active) {
$select->where('t.active = 1')->where('a.date_published <= CURDATE()');
}
if ($paginator === true) {
$adapter = new Base_PaginatorAdapter($select);
$adapter->setMapper($this->_mapper);
$data = new Zend_Paginator($adapter);
$data->setCurrentPageNumber((int) $pindex);
$data->setItemCountPerPage((int) $perpage);
} else {
$results = $db->fetchAll($select);
$data = $this->_mapper->mapAll($results);
}
if ($cache == true) {
$cacheTags = $this->generateCacheTags(get_class($this) . '_' . __FUNCTION__);
$cache->save($data, $cacheId, $cacheTags);
}
return $data;
}
/**
* Consulta as guias dos contribuintes por competência
*/
public function consultarAction()
{
parent::noTemplate();
$aParametros = $this->getRequest()->getParams();
/**
* Verifica se foi informado mês e ano da competência
*/
if (!empty($aParametros['mes_competencia']) && !empty($aParametros['ano_competencia'])) {
$iMesCompetencia = str_pad($aParametros['mes_competencia'], 2, '0', STR_PAD_LEFT);
$iAnoCompetencia = $aParametros['ano_competencia'];
$aGuiasCompetencia = Contribuinte_Model_Competencia::getByGuiasContribuinteAndCompetencia($iMesCompetencia, $iAnoCompetencia);
$oPaginatorAdapter = new DBSeller_Controller_PaginatorArray($aGuiasCompetencia);
$oPaginator = new Zend_Paginator($oPaginatorAdapter);
$oPaginator->setItemCountPerPage(10);
$oPaginator->setCurrentPageNumber($this->_request->getParam('page'));
/**
* Valores da pesquisa para montar a paginação
*/
if (is_array($aParametros)) {
foreach ($aParametros as $sParametro => $sParametroValor) {
if ($sParametroValor) {
$sParametroValor = str_replace('/', '-', $sParametroValor);
$this->view->sBusca .= "{$sParametro}/{$sParametroValor}/";
}
}
}
$this->view->oGuiasCompetencia = $oPaginator;
}
}
public function getPosters($paged = null, $order = array(), $filter = null)
{
$grid = array();
$grid['cols'] = $this->getGridColumns();
$grid['primary'] = $this->_primary;
$select = $this->select();
if (!empty($order[0])) {
$order = $order[0] . ' ' . $order[1];
} else {
$order = 'lower(title) ASC';
}
$select->order($order);
$select->from('posters', array_keys($this->getGridColumns()))->where('conference_id = ?', $this->getConferenceId());
if ($filter) {
$select->where('category = ?', (int) $filter);
}
if ($paged) {
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setCurrentPageNumber((int) $paged)->setItemCountPerPage(20);
$grid['rows'] = $paginator;
return $grid;
}
$grid['rows'] = $this->fetchAll($select);
return $grid;
}
/**
* listAction方法是列出全部的礼品
* Enter description here ...
*/
function listAction()
{
$this->view->title = $this->view->translate("Wildfire") . " - " . $this->view->translate("GIFT_LIST");
$this->view->consumer = $this->_currentUser;
$productModel = new Product();
$today = date("Y-m-d", time());
if ($this->_request->getParam('t') != null && $this->_request->getParam('t') == 'mine') {
$db = Zend_Registry::get('db');
// $selectAmountPoint = $db->select();
// $selectAmountPoint->from('reward_point_transaction_record', 'SUM(point_amount)')
// ->where("consumer_id = ?", $this->_currentUser->id);
// $amountPoints = (int)$db->fetchOne($selectAmountPoint);
$amountPoints = $db->fetchOne("SELECT sum(point_amount) FROM reward_point_transaction_record WHERE (consumer_id = :temp and date <:temp2) or (consumer_id = :temp and date >=:temp2 and transaction_id=4) ", array('temp' => $this->_currentUser->id, 'temp2' => date("Y-m-d", strtotime("{$today} -30 day"))));
$products = $productModel->fetchAll('point <= ' . $amountPoints . ' and state ="STOCK"', 'point desc')->toArray();
} else {
if ($this->_request->getParam('p2') != null && (int) $this->_request->getParam('p2') > 0) {
$products = $productModel->fetchAll('point >= ' . $this->_request->getParam('p1') . ' and point <= ' . $this->_request->getParam('p2') . ' and state ="STOCK"', 'point')->toArray();
} else {
if ($this->_request->getParam('t') != null && $this->_request->getParam('t') != 'none') {
if ($this->_request->getParam('t') == "NEW") {
//添加最新上架 Bruce.Liu
$products = $productModel->fetchAll(' state ="STOCK" ', 'id desc', 18, 'point')->toArray();
// Zend_Debug::dump($products);die();
} else {
$products = $productModel->fetchAll("category = '" . $this->_request->getParam('t') . "'" . ' and state ="STOCK"', 'point')->toArray();
}
} else {
$products = $productModel->fetchAll('state ="STOCK"', 'point')->toArray();
}
}
}
//2011-04-14 ham.bao page links modification
if ($this->_request->getParams('t') != NULL) {
$this->view->t = $this->_request->getParam('t');
}
if ($this->_request->getParam('p2') != null) {
$this->view->p1 = $this->_request->getParam('p1');
$this->view->p2 = $this->_request->getParam('p2');
}
// get total points
$db = Zend_Registry::get('db');
if ($this->_currentUser != null) {
// $selectAmountPoint = $db->select();
// $selectAmountPoint->from('reward_point_transaction_record', 'SUM(point_amount)')
// ->where("consumer_id = ?", $this->_currentUser->id);
$this->view->amountPoints = $db->fetchOne("SELECT sum(point_amount) FROM reward_point_transaction_record WHERE (consumer_id = :temp and date <:temp2) or (consumer_id = :temp and date >=:temp2 and transaction_id=4) ", array('temp' => $this->_currentUser->id, 'temp2' => date("Y-m-d", strtotime("{$today} -30 day"))));
}
if ($this->_request->getParam('page')) {
$this->_curPage = $this->_request->getParam('page');
}
//paging
$this->view->controller = $this->_request->getControllerName();
$this->view->action = $this->_request->getActionName();
//Zend_Debug::dump($products);die;
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($products));
$paginator->setCurrentPageNumber($this->_curPage)->setItemCountPerPage($this->_rowsPerPage);
$this->view->products = $paginator;
//set the No. inital value in view page
$this->view->NoInitValue = ($this->_curPage - 1) * $this->_rowsPerPage + 1;
}
