UpgradeLogRepository.php
2.99 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
<?php
namespace domain\upgrade;
use domain\device\models\Device as DeviceModel;
use domain\manufacturer\models\Manufacturer as ManufacturerModel;
use domain\model\models\Model;
use domain\project\models\Project;
use domain\upgrade\models\UpgradeLog as UpgradeLogModel;
/**
* Class UpgradeLogRepository
* @package domain\model
*/
class UpgradeLogRepository
{
/**
* 获取分页数据
* @param $where
* @param $offset
* @param $limit
* @return array|\yii\db\ActiveRecord[]
*/
static function getPageList($where, $offset, $limit)
{
$upgradeFind = UpgradeLogModel::find()->alias("ul")
->select([
"ul.*",
"mf.name as manufacture_name",
'de.serial_no',
'de.device_id as device_device_id',
'pj.name as project_name',
'md.name as model_name',
]);
$upgradeFind->leftJoin(ManufacturerModel::tableName() . " mf", "mf.id = ul.manufacture_id");
$upgradeFind->leftJoin(DeviceModel::tableName() . " de", "de.id = ul.device_id");
$upgradeFind->leftJoin(Project::tableName() . " pj", "pj.id = ul.project_id");
$upgradeFind->leftJoin(Model::tableName() . " md", "md.id = ul.model_id");
if (!empty($where)) {
$upgradeFind->where($where);
}
if ($offset) {
$upgradeFind->offset($offset);
}
if ($limit) {
$upgradeFind->limit($limit);
}
$upgradeFind->orderBy("ul.id desc");
$upgradeFind->asArray();
$dataList = $upgradeFind->all();
return $dataList;
}
/**
* 列表页面分页器数量
* @param string $map
*/
static function getPageCount($map = '')
{
$upgradeFind = UpgradeLogModel::find()->alias("ul");
$upgradeFind->leftJoin(ManufacturerModel::tableName() . " mf", "mf.id = ul.manufacture_id");
$upgradeFind->leftJoin(DeviceModel::tableName() . " de", "de.id = ul.device_id");
$upgradeFind->leftJoin(Project::tableName() . " pj", "pj.id = ul.project_id");
$upgradeFind->leftJoin(Model::tableName() . " md", "md.id = ul.model_id");
if (!empty($map)) {
$upgradeFind->where($map);
}
$pageCount = $upgradeFind->count();
return $pageCount;
}
/**
* @param $id
* @param bool|false $asArr
* @return null|static
*/
static function selectOne($id, $asArr = false)
{
$model = UpgradeLogModel::findOne($id);
if ($asArr && $model) {
$model = $model->toArray();
}
return $model;
}
/**
* @param $id
* @param bool|false $asArr
* @return null|static
*/
static function findOne($condition)
{
$model = UpgradeLogModel::findOne($condition);
return $model;
}
}