RightModel.class.php
2.81 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
107
108
109
<?php
/**
* Created by PhpStorm.
* User: liyifei2012it
* Date: 17/5/18
* Time: 11:34
*/
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;
}
/**
* 获取用户可查阅、下载的目录列表
* @author tangxingguo
* @param array $rights 权限数据
* @param int $right_type 权限类型（1=查阅权限；2=下载权限）
* @return array
*/
public function listByRight($rights, $right_type)
{
if (!is_array($rights) || empty($rights) || !in_array($right_type, [Constant::RIGHT_TYPE_IS_READ, Constant::RIGHT_TYPE_IS_DOWNLOAD])) {
return [];
}
$conds = $this->buildConds($rights);
$where = '`right_type` = ? and (' . implode(' OR ', $conds) . ') and `domain` = ? and status < ?';
$sql = "SELECT `file_id` FROM __TABLE__ WHERE {$where}";
$params = [
$right_type,
QY_DOMAIN,
$this->get_st_delete(),
];
return $this->_m->fetch_array($sql, $params);
}
/**
* 根据目录ID和权限数据计算数量
* @author tangxingguo
* @param int $file_id 课程ID
* @param array $rights 权限数据
* @param int $right_type 权限类型（1=查阅权限；2=下载权限）
* @return int
*/
public function countByRight($file_id, $rights, $right_type)
{
$count = 0;
if (!is_array($rights) || empty($rights)) {
return $count;
}
$conds = $this->buildConds($rights);
$where = '`file_id` = ? and `right_type` = ? and (' . implode(' OR ', $conds) . ') and `domain` = ? and status < ?';
$sql = "SELECT COUNT(*) FROM __TABLE__ WHERE {$where}";
$params = [
$file_id,
$right_type,
QY_DOMAIN,
$this->get_st_delete(),
];
$count = $this->_m->result($sql, $params);
return intval($count);
}
}