RightModel.class.php
2.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?php
/**
* Created by PhpStorm.
* User: tangxingguo
* Date: 2017/4/12
* Time: 10:33
*/
namespace Common\Model;
use Common\Common\Constant;
class RightModel extends AbstractModel
{
// 构造方法
public function __construct()
{
parent::__construct();
}
/**
* 根据权限数据构建查询条件
* @author zhonglei
* @param array $rights 权限数据
* @return array
*/
public function buildConds($rights)
{
$conds = [];
if (!is_array($rights) || empty($rights)) {
return $conds;
}
foreach ($rights as $k => $v) {
switch ($k) {
// 全公司
case Constant::RIGHT_TYPE_ALL:
$conds[] = "`obj_type` = {$k}";
break;
// 部门、标签、人员、职位、角色
default:
$obj_id = implode("','", $v);
$conds[] = "(`obj_type` = {$k} and `obj_id` in ('{$obj_id}'))";
}
}
return $conds;
}
/**
* 根据新闻ID和权限数据计算数量
* @author zhonglei
* @param int $article_id 新闻ID
* @param array $rights 权限数据
* @return int
*/
public function countByRight($article_id, $rights)
{
$count = 0;
if (!is_array($rights) || empty($rights)) {
return $count;
}
$conds = $this->buildConds($rights);
$where = '`article_id` = ? and (' . implode(' OR ', $conds) . ') and `domain` = ? and status < ?';
$sql = "SELECT COUNT(*) FROM __TABLE__ WHERE {$where}";
$params = [
$article_id,
QY_DOMAIN,
$this->get_st_delete(),
];
$count = $this->_m->result($sql, $params);
return intval($count);
}
/**
* 根据需要的数据类型和权限数据获取数据
* @author liyifei
* @param array $rights 权限数据
* @return array
*/
public function listByRight($rights)
{
if (!is_array($rights) || empty($rights)) {
return [];
}
$conds = $this->buildConds($rights);
$where = '`article_id` > ? and (' . implode(' OR ', $conds) . ') and `domain` = ? and status < ?';
$sql = "SELECT `article_id` FROM __TABLE__ WHERE {$where}";
$params = [
0,
QY_DOMAIN,
$this->get_st_delete(),
];
return $this->_m->fetch_array($sql, $params);
}
}