public function fetchAll($page) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbModule = $this->getDbTable()->info(); $dbModuleName = $dbModule['name']; $select = $db->select()->from("{$dbModuleName}"); $rows = $db->fetchAll($select); $paginator = Zend_Paginator::factory($rows); $paginator->setItemCountPerPage(2); $paginator->setCurrentPageNumber($page); return $paginator; }
public function getMaxOrder($id) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $stmt = $db->query("SELECT max(ordering) as max from menu_items\r\n\t\t\t WHERE menu_cat_id = {$id} and parent_id = 0"); $row = $stmt->fetch(); if (null == $row['max']) { return 0; } else { return $row['max']; } }
public function getAccessPrivilege() { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbPrivilege = $this->getDbTable()->info(); $dbPrivilegeName = $dbPrivilege['name']; $moduleMapper = new Cloud_Model_Module_CloudModuleMapper(); $dbModule = $moduleMapper->getDbTable()->info(); $dbModuleName = $dbModule['name']; $privilegeTypeMapper = new Cloud_Model_PrivilegeType_CloudPrivilegeTypeMapper(); $dbPrivilegeType = $privilegeTypeMapper->getDbTable()->info(); $dbPrivilegeTypeName = $dbPrivilegeType['name']; $select = $db->select()->from(array('p' => $dbPrivilegeName), array('id'))->join(array('m' => $dbModuleName), 'p.module_id = m.id', array('name'))->join(array('pt' => $dbPrivilegeTypeName), 'p.pri_type_id = pt.id', array())->where("pt.description = 'Access'"); return $db->fetchAll($select); }
public function getButton2V2ById($id, $moduleId) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbPrivilegeType = $this->getDbTable()->info(); $dbPrivilegeTypeName = $dbPrivilegeType['name']; $privilegeMapper = new Cloud_Model_Privilege_CloudPrivilegeMapper(); $dbPrivilege = $privilegeMapper->getDbTable()->info(); $dbPrivilegeName = $dbPrivilege['name']; $select = $db->select()->from(array('p' => $dbPrivilegeName), array())->join(array('pt' => $dbPrivilegeTypeName), 'p.pri_type_id = pt.id', array('button2'))->where("p.id in ({$id})")->where('p.module_id = ?', $moduleId)->where("pt.description != 'access'")->where("pt.description != 'Edit'")->where("pt.description != 'Delete'"); return $db->fetchAll($select); }
public function showPaging($page, $key, $number) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbArticle = $this->getDbTable()->info(); $dbArticleName = $dbArticle['name']; $stmt = $db->query("SELECT count(*) as count from articles\r\n\t\t\t\t\t\t\t\tWHERE title like '%{$key}%'"); $row = $stmt->fetch(); $totalPages = ceil((int) $row['count'] / (int) $number); return $this->paging(5, $totalPages, $page, $key); }
public function getAliasByArticle($articleId) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbCategory = $this->getDbTable()->info(); $dbCategoryName = $dbCategory['name']; $articleMapper = new Cloud_Model_Article_CloudArticleMapper(); $dbArticle = $articleMapper->getDbTable()->info(); $dbArticleName = $dbArticle['name']; $select = $db->select()->from(array('a' => $dbArticleName), array())->join(array('c' => $dbCategoryName), 'a.cat_id = c.id', array('alias as sub_alias', 'parent_id'))->where('a.id = ?', $articleId); $row1 = $db->fetchRow($select); $select = $db->select()->from(array('c' => $dbCategoryName), array('alias as parent_alias'))->where('id = ?', $row1['parent_id']); $row2 = $db->fetchRow($select); $row = array(); $row['sub_alias'] = $row1['sub_alias']; $row['parent_alias'] = $row2['parent_alias']; return $row; }
public function getMaxOrder($pageId, $position) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $stmt = $db->query("SELECT max(ordering) as max from page_widget\r\n\t\t\t WHERE page_id = {$pageId} and position = '{$position}'"); $row = $stmt->fetch(); if (null == $row['max']) { return 0; } else { return $row['max']; } }
public function getMinOrder() { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $stmt = $db->query('SELECT min(ordering) as min from components'); $row = $stmt->fetch(); if (null == $row['min']) { return 0; } else { return $row['min']; } }
public function getMaxOrder() { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $stmt = $db->query('SELECT max(ordering) as max from pages'); $row = $stmt->fetch(); if (null == $row['max']) { return 0; } else { return $row['max']; } }
public function updateTotalPages($number) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $sessionMapper = new Cloud_Model_UserSession_CloudUserSessionMapper(); $dbSession = $sessionMapper->getDbTable()->info(); $dbSessionName = $dbSession['name']; $stmt = $db->query("SELECT count(*) as count from {$dbSessionName} \r\n\t\t\t\t\t\t\t\tWHERE user_id != 0"); $row = $stmt->fetch(); $totalPages = ceil((int) $row['count'] / (int) $number); return $totalPages; }
public function checkUniqueWidgetAlias($componentId, $pageId, $alias, $widgetId = null) { $widgetId = $widgetId == null ? '' : $widgetId; $pageArray = explode(',', $pageId); $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbWidget = $this->getDbTable()->info(); $dbWidgetName = $dbWidget['name']; $PageWidgetMapper = new Cloud_Model_PageWidget_CloudPageWidgetMapper(); $dbPageWidget = $PageWidgetMapper->getDbTable()->info(); $dbPageWidgetName = $dbPageWidget['name']; $PageMapper = new Cloud_Model_Page_CloudPageMapper(); $dbPage = $PageMapper->getDbTable()->info(); $dbPageName = $dbPage['name']; $listAlias = array(); for ($i = 0; $i < count($pageArray); $i++) { $pageId = $pageArray[$i]; $select = $db->select()->from(array('w' => $dbWidgetName), array('id'))->join(array('pw' => $dbPageWidgetName), 'w.id = pw.widget_id', array())->join(array('p' => $dbPageName), 'pw.page_id = p.id', array('title'))->where('w.id != ?', $widgetId)->where('w.alias = ?', $alias)->where('p.component_id = ?', $componentId)->where('pw.page_id = ?', $pageId); $rs = $db->fetchRow($select); if ($rs['title'] != null) { array_push($listAlias, $rs['title']); } } return $listAlias; }