CourseClassModel.class.php
3.48 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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
/**
* Created by PhpStorm.
* User: liyifei2012it
* Date: 17/10/12
* Time: 18:34
*/
namespace Common\Model;
use Common\Common\Constant;
class CourseClassModel extends \Com\Model
{
// 构造方法
public function __construct()
{
parent::__construct('Class', 'oa_course_');
}
/**
* 根据层级格式化分类数据
* @author tangxingguo
* @param array $list 分类数据
* @param int $parentId 父ID
* @return array 格式化后的数据
*/
public function formatClass($list, $parentId = 0)
{
$return = [];
foreach ($list as $class) {
if ($class['parent_id'] == $parentId) {
foreach ($list as $child) {
if ($child['parent_id'] == $class['class_id']) {
$class['child'] = $this->formatClass($list, $class['class_id']);
break;
} else {
$class['child'] = [];
}
}
$return[] = $class;
}
}
return $return;
}
/**
* 以树形结构格式化数据库数据
* @author liyifei
* @return array
*/
public function formatDB()
{
// 所有分类列表
$tree = $this->list_all();
if (empty($tree)) {
return [];
}
$tree = array_combine_by_key($tree, 'class_id');
foreach ($tree as $k => $v) {
if ($v['parent_id'] != 0) {
$tree[$v['parent_id']]['child'][$v['class_id']] = &$tree[$k];
}
}
return $tree;
}
/**
* 获取当前分类及所有子分类ID
* @author liyifei
* @param int $classId 分类ID
* @param array $tree 分类树形结构
* @param array $childIds 收集子分类ID
* @return array
*/
public function getChildClassIds($classId, $tree = [], $childIds = [])
{
if (empty($tree)) {
$tree = $this->formatDB();
}
$childIds[] = $classId;
if (isset($tree[$classId]['child'])) {
foreach ($tree[$classId]['child'] as $v) {
$childIds = $this->getChildClassIds($v['class_id'], $tree[$classId]['child'], $childIds);
}
}
return $childIds;
}
/**
* @desc 获取所有已启用的分类ID（父类禁用子类不显示）
* @author tangxingguo
*/
public function getOpenClassIds()
{
$classList = $this->list_all();
$classIds = [];
if (!empty($classList)) {
// 格式化分类
$classList = array_combine_by_key($classList, 'class_id');
foreach ($classList as $k => $v) {
if ($v['parent_id'] != 0) {
$classList[$v['parent_id']]['child'][] = &$classList[$k];
}
}
// 取已开启的二级分类以及其子分类
foreach ($classList as $key => $value) {
// 父级是否开启
$parentIsOpen = isset($classList[$value['parent_id']]) ? ($classList[$value['parent_id']]['is_open'] != Constant::CLASS_IS_OPEN_FALSE) : false;
// 非一级分类 + 当前分类已开启 + 父级分类已开启
if ($value['parent_id'] != 0 && $value['is_open'] == Constant::CLASS_IS_OPEN_TRUE && $parentIsOpen) {
$classIds[] = $value['class_id'];
}
}
}
return $classIds;
}
}