forked from kuafuRace/phprap
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathModule.php
More file actions
executable file
·155 lines (130 loc) · 3.92 KB
/
Module.php
File metadata and controls
executable file
·155 lines (130 loc) · 3.92 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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
<?php
namespace app\models;
use app\widgets\LinkPager;
use Yii;
use yii\data\Pagination;
/**
* This is the model class for table "doc_module".
*
* @property int $id
* @property string $encode_id 加密id
* @property int $project_id 项目id
* @property string $title 模块名称
* @property string $remark 项目描述
* @property int $status 模块状态
* @property int $sort 模块排序
* @property int $creater_id 创建者id
* @property int $updater_id 更新者id
* @property string $created_at 创建时间
* @property string $updated_at 更新时间
*/
class Module extends Model
{
/**
* 绑定数据表
*/
public static function tableName()
{
return '{{%module}}';
}
/**
* 验证规则
*/
public function rules()
{
return [
[['encode_id', 'project_id', 'title', 'status', 'creater_id'], 'required'],
[['project_id', 'status', 'sort', 'creater_id', 'updater_id'], 'integer'],
[['encode_id'], 'string', 'max' => 50],
[['title'], 'string', 'max' => 50],
[['remark'], 'string', 'max' => 250],
[['encode_id'], 'unique'],
[['created_at', 'updated_at'], 'safe'],
];
}
/**
* 字段字典
* @return array
*/
public function attributeLabels()
{
return [
'id' => 'ID',
'encode_id' => '加密id',
'project_id' => '项目id',
'version_id' => '版本id',
'title' => '模块名称',
'remark' => '项目描述',
'status' => '模块状态',
'sort' => '模块排序',
'creater_id' => '创建者id',
'updater_id' => '更新者id',
'created_at' => '创建时间',
'updated_at' => '更新时间',
];
}
/**
* 获取所属项目
* @return \yii\db\ActiveQuery
*/
public function getProject()
{
return $this->hasOne(Project::className(),['id'=>'project_id']);
}
/**
* 获取模块接口
* @return \yii\db\ActiveQuery
*/
public function getApis()
{
$filter = [
'status' => Api::ACTIVE_STATUS
];
$sort = [
'sort' => SORT_DESC,
'id' => SORT_DESC
];
return $this->hasMany(Api::className(), ['module_id' => 'id'])->where($filter)->orderBy($sort);
}
/**
* 模块搜索
* @param array $params
* @return $this
* @throws \Exception
*/
public function search($params = [])
{
$this->params = array2object($params);
$query = self::find();
$this->params->status && $query->andFilterWhere([
'status' => $this->params->status,
]);
$query->andFilterWhere(['like', 'title', $this->params->title]);
$this->params->start_date && $query->andFilterWhere(['>=', 'created_at', $this->params->start_date . ' 00:00:00']);
$this->params->end_date && $query->andFilterWhere(['<=', 'created_at', $this->params->end_date . ' 23:59:59']);
$this->count = $query->count();
$pagination = new Pagination([
'pageSizeParam' => false,
'totalCount' => $this->count,
'pageSize' => $this->pageSize,
'validatePage' => false,
]);
$this->models = $query
->offset($pagination->offset)
->limit($pagination->limit)
->orderBy('id DESC')
->all();
$this->sql = $query->createCommand()->getRawSql();
// dump($this->sql);
$this->pages = LinkPager::widget([
'pagination' => $pagination,
'nextPageLabel' => '下一页',
'prevPageLabel' => '上一页',
'firstPageLabel' => '首页',
'lastPageLabel' => '尾页',
'hideOnSinglePage' => true,
'maxButtonCount' => 5,
]);
return $this;
}
}