UpgradeLogController.php
3.86 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
namespace app\ht\modules\datas\controllers;
use Yii;
use yii\data\Pagination;
use domain\upgrade\UpgradeLogRepository;
use domain\upgrade\UpgradeStatus;
use app\ht\controllers\BaseController;
/**
* 版本日志管理
* Class UpgradeLogController
* @package app\ht\modules\upgrade\controllers
*/
class UpgradeLogController extends BaseController
{
/**
* 版本日志管理
*/
public function actionIndex()
{
$params = $this->dataList(1);
/**
* 渲染模板
*/
return $this->render('index', $params);
}
/**
* 查询数据列表
*/
protected function dataList($type = '')
{
$request = Yii::$app->request;
$creatTime = $request->get('creatTime');
$endTime = $request->get('endTime');
$status = $request->get('status');
$current_version = $request->get('current_version');
$target_version = $request->get('target_version');
$manufacture_name = $request->get('manufacture_name');
$device_no = $request->get('device_no');
$barcode = $request->get('barcode');
$error_code = $request->get('error_code');
$device_device_id = $request->get('device_device_id');
$dataType = !empty($request->get('type')) ? $request->get('type') : UpgradeStatus::TYPE_APP;
$gets = [
'creatTime' => $creatTime,
'endTime' => $endTime,
'status' => $status,
'current_version' => $current_version,
'target_version' => $target_version,
'manufacture_name' => $manufacture_name,
'device_no' => $device_no,
'barcode' => $barcode,
'error_code' => $error_code,
'device_device_id' => $device_device_id,
'type' => $dataType,
];
$where = ['and'];
if ($creatTime) {
$creatTime = strtotime($creatTime);
$where[] = ['>=', 'ul.created_at', $creatTime];
}
if ($endTime) {
$endTime = strtotime($endTime) + 86400;
$where[] = ['<=', 'ul.created_at', $endTime];
}
if ($status) {
$where[] = ['=', 'ul.status', $status];
}
if ($current_version) {
$where[] = ['like', 'ul.current_version', $current_version];
}
if ($target_version) {
$where[] = ['like', 'ul.target_version', $target_version];
}
if ($manufacture_name) {
$where[] = ['like', 'mf.name', $manufacture_name];
}
if ($device_no) {
$where[] = ['like', 'md.name', $device_no];
}
if ($barcode) {
$where[] = ['like', 'ul.barcode', $barcode];
}
if ($error_code) {
$where[] = ['like', 'ul.error_code', $error_code];
}
if ($device_device_id) {
$where[] = ['like', 'de.device_id', $device_device_id];
}
if ($dataType) {
$where[] = ['=', 'ul.type', $dataType];
}
if ($type == 0) {
$pageList = UpgradeLogRepository::getPageList($where, 0 , 0);
$pages = null;
} else {
$pageSize = 20;
$pages = new Pagination(['totalCount' => UpgradeLogRepository::getPageCount($where), 'pageSize' => $pageSize]);
$pageList = UpgradeLogRepository::getPageList($where, $pages->offset, $pages->limit);
}
/**
* 数据整理
*/
return [
'listdata' => $pageList,
'pages' => $pages,
'gets' => $gets
];
}
/**
* 导出版本日志数据
* @return string
*/
public function actionExport()
{
$params = $this->dataList(0);
return $this->renderPartial('export', $params);
}
}