function fetch_menu_list($pid = 0)
{
//$mn = new model_cnotify;
$select = new database_select();
$select->from(array('i' => $this->name))->order('i.orderid')->where('i.parentid = ?', $pid);
return $this->entity_all($this->adapter->fetch_all($select));
}
function fetch_list($w = array())
{
$select = new database_select();
$select->from(array('i' => $this->name));
if (@(string) $w['id']) {
$select->where('stitle', (string) $w['id']);
}
return $select;
}
function fetch_role_title_by_role($rule)
{
$mr = new model_crole();
$select = new database_select();
$select->from(array('i' => $this->name), array('r.title'));
$select->join(array('r' => $mr->name), 'r.id = i.role', '');
$select->where(array('i.parentid' => $rule));
$select->order('r.title');
$select->group('r.id');
return $this->adapter->fetch_col($select);
}
function fetch_control_no_read()
{
$select = new database_select();
$select->from($this->name, array('id', 'title', 'style'));
$select->where(array('`is_read` = ?' => 0, '`menu` = ?' => 0));
$select->order('date');
$select->limit(50);
return $this->adapter->fetch_all($select);
}
function fetch_control_list($where = null, $order = null, $count = null, $offset = null)
{
$select = new database_select(null, $this->adapter);
$select->from($this->name);
if ($where) {
$select->where($where);
}
if ($order) {
$select->order($order);
}
if ($count) {
$select->limit($count, $offset);
}
return $select;
}
public function init_acl()
{
if (!$this->model_role || !$this->model_rule || !$this->model_resource || !$this->model_role2role || !$this->model_rule2role || !$this->model_rule2resource) {
return false;
}
$this->_acl = new acl();
// Добавляем роли
$roles = $this->model_role->fetch_col('id');
if (!$roles) {
return false;
}
foreach ($roles as $el) {
$select = new database_select();
$select->from(array('i' => $this->model_role->name), array('i.id'))->join(array('r' => $this->model_role2role->name), 'i.id = r.role', '')->group('i.id')->where('r.parentid = ?', $el);
$parents = $this->model_role->adapter->fetch_col($select);
$this->_acl->add_role($el, $parents);
}
// Добавляем ресурсы
$select = new database_select();
$select->from(array('i' => $this->model_resource->name), array('i.id'))->join_left(array('r' => $this->model_resource->name), 'i.parentid = r.id', array('parentid' => 'r.id'))->group('i.id');
$resources = $this->model_resource->fetch_all($select);
if (!$resources) {
return false;
}
foreach ($resources as $el) {
$this->_acl->add_resource($el->id, $el->parentid);
}
// Добавляем правила
$rules = $this->model_rule->fetch_all(null, 'orderid');
if (!$rules) {
return false;
}
foreach ($rules as $el) {
$select_1 = new database_select();
$select_1->from(array('i' => $this->model_role->name), array('i.id'))->join(array('r' => $this->model_rule2role->name), 'i.id = r.role', '')->group('i.id')->where('r.parentid = ?', $el->id);
$roles_refer = $this->model_role->adapter->fetch_col($select_1);
$select_2 = new database_select();
$select_2->from(array('i' => $this->model_resource->name), array('i.id'))->join(array('r' => $this->model_rule2resource->name), 'i.id = r.resource', '')->group('i.id')->where('r.parentid = ?', $el->id);
$resources_refer = $this->model_resource->adapter->fetch_col($select_2);
$this->_acl->{$el->is_allow ? 'allow' : 'deny'}($roles_refer, $resources_refer);
}
}
function finished_quant($oid = null, $id = null)
{
$select = new database_select();
$select->from(array('i' => $this->_model_order_item->name), array('quant' => '(SUM(i.quant))'))->join(array('o' => $this->_model_order->name), 'o.id = i.parentid', '')->where('o.id = ?', $oid)->group('o.id');
if ($id != null) {
$select->where('i.' . $this->_field_order_item_id . ' = ?', $id);
}
return (int) $this->_model_order_item->adapter->fetch_one($select);
}