/**
* 获取所有默认角色
*
* @return array
*/
public function getAllDefaultRoles()
{
if (null == self::$_allDefaultRoles) {
self::$_allDefaultRoles = $this->_cache->load('acl_all_default_roles');
if (self::$_allDefaultRoles == false) {
$rows = $this->_db->select()->from(array('role' => 'acl_role'), array('role_name', 'mod_name'))->join('acl_module', 'acl_module.mod_name=role.mod_name', array())->where('role.is_guest=0')->where('role.is_default=1');
$rows = $this->_db->fetchAll($rows);
$roles = array();
foreach ($rows as $row) {
$roles[$row['mod_name']] = "{$row['mod_name']}.{$row['role_name']}";
}
self::$_allDefaultRoles = $roles;
$this->_cache->save($roles, 'acl_all_default_roles');
}
}
return self::$_allDefaultRoles;
}
/**
* Get the list of the products for all categories
*
*
* @return array
*/
public function getListOfAllNewProducts()
{
$products = array();
$this->getDataByName();
$oProducts = new ProductsObject();
$oSubCat = new SubCategoriesObject();
$oCategory = new CatalogCategoriesObject();
$subCategories = $oSubCat->getSubCatByCategory(0, false, $this->_currentLang);
$oCategory->setQuery($subCategories);
$categoryQuery = $oCategory->getDataCatagory($this->_currentLang, false);
$oProducts->setQuery($categoryQuery);
$select = $oProducts->getProducts($this->_currentLang, false);
$select->where('P_New = 1');
$select->order('PI_Name ASC');
$products = $this->_db->fetchAll($select);
//echo $select;
return $products;
}
/**
* get roles and resources from db, build Zend_Acl structure and add permissions
* @param Zend_Db $db
*/
protected function makeAcl($db)
{
$acl = new Zend_Acl();
$res = $db->fetchAll('select * from system_role');
foreach ($res as $obj) {
if ($obj['inherit_role'] != '') {
if ($acl->hasRole($obj['inherit_role'])) {
$acl->addRole(new Zend_Acl_Role($obj['role']), $obj['inherit_role']);
} else {
/**
* @todo very simply system to order roles, add role before inherited role
*/
$res[] = $obj;
continue;
}
} else {
$acl->addRole(new Zend_Acl_Role($obj['role']));
}
}
$res = $db->fetchAll('select * from system_resource');
foreach ($res as $obj) {
$acl->addResource(new Zend_Acl_Resource($obj['resource']));
}
$res = $db->fetchAll('select r.role as role, rs.resource as resource, permission, privilege ' . 'from system_role as r join system_role_has_system_resource as m on ' . '(r.id = m.system_role_id) join system_resource as rs on (m.system_resource_id = rs.id)');
foreach ($res as $obj) {
$privilege = explode(',', $obj['privilege']);
if ($obj['permission'] == 'allow') {
$acl->allow($obj['role'], $obj['resource'], $privilege);
} else {
$acl->deny($obj['role'], $obj['resource'], $privilege);
}
}
return $acl;
}
/**
* Enter description here ...
* @return unknown
*/
public function getAllIntroAdmin()
{
$row = $this->db->fetchAll("SELECT * FROM intro");
return $row;
}
