ProjectRepository.php
1.84 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
<?php
namespace domain\project;
use domain\project\models\Project as ProjectModel;
/**
* Class ProjectRepository
* @package domain\model
*/
class ProjectRepository
{
/**
* 获取分页数据
* @param $where
* @param $offset
* @param $limit
* @return array|\yii\db\ActiveRecord[]
*/
static function getPageList($where, $offset, $limit)
{
$modelFind = ProjectModel::find()->alias("p")
->select([
"p.*"
]);
if (!empty($where)) {
$modelFind->where($where);
}
if ($offset) {
$modelFind->offset($offset);
}
if ($limit) {
$modelFind->limit($limit);
}
$modelFind->andWhere(["is_delete" => 0]);
$modelFind->orderBy("p.id desc");
$modelFind->asArray();
$dataList = $modelFind->all();
return $dataList;
}
/**
* 列表页面分页器数量
* @param string $map
*/
static function getPageCount($map = '')
{
$modelFind = ProjectModel::find()->alias("p");
if (!empty($map)) {
$modelFind->where($map);
}
$modelFind->andWhere(["is_delete" => 0]);
$pageCount = $modelFind->count();
return $pageCount;
}
/**
* @param $id
* @param bool|false $asArr
* @return null|static
*/
static function selectOne($id, $asArr = false)
{
$model = ProjectModel::findOne($id);
if ($asArr && $model) {
$model = $model->toArray();
}
return $model;
}
/**
* @param $id
* @param bool|false $asArr
* @return null|static
*/
static function findOne($condition)
{
$model = ProjectModel::findOne($condition);
return $model;
}
}