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;
}
