OTHER_COMPANY_PROJECTS / ota

Blame view

domain/device/DeviceRepository.php 2.57 KB
Edit Raw Normal View History
aa2f3513   xu   1. 删除冗余的代码 
1
2
 
<?php
931eed21   xu   1. A授权接口开发 
3
 
namespace domain\device;
aa2f3513   xu   1. 删除冗余的代码 
4
37a28dcc   xu   1. F 授权接口调整，有重大的bug 
5
 
use domain\device\models\CreateBatch    as CreateBatchModel;
931eed21   xu   1. A授权接口开发 
6
7
 
use domain\device\models\Device         as DeviceModel;
37a28dcc   xu   1. F 授权接口调整，有重大的bug 
8
 
class DeviceRepository
aa2f3513   xu   1. 删除冗余的代码 
9
10
11
 
{
    /**
     * @param $where
4e3f2365   xu   common 
12
 
     * @return array|\yii\db\ActiveRecord[]
37a28dcc   xu   1. F 授权接口调整，有重大的bug 
13
14
15
16
17
18
19
 
     */
    static function getList($where, $limit = 0, $offset = 0)
    {
        $deviceFind = DeviceModel::find();
        $deviceFind->alias('a');
        $deviceFind->select(['a.*', 'm.name as manufacture','p.name as project','pd.name as production','mo.name as model']);
        $deviceFind->leftJoin(CreateBatchModel::tableName().' b','b.id = a.batch_id');
aa2f3513   xu   1. 删除冗余的代码 
20
21
22
23
24
25
26
 
        $deviceFind->leftJoin('manufacture as m', 'm.id = b.manufacture_id');
        $deviceFind->leftJoin('project as p', 'p.id = b.project_id');
        $deviceFind->leftJoin('model as mo', 'mo.id = b.model_id');
        $deviceFind->leftJoin('production as pd', 'pd.id = b.production_id');

        $deviceFind->where($where);
        $deviceFind->orderBy('created_at desc');
931eed21   xu   1. A授权接口开发 
27
 
        $deviceFind->asArray();
ff8327f6   xu   1. F 删除冗余代码 
28
 
        if ($offset) {
931eed21   xu   1. A授权接口开发 
29
30
31
32
33
34
 
            $deviceFind->offset($offset);
        }
        if ($limit) {
            $deviceFind->limit($limit);
        }
        $all = $deviceFind->all();
aa2f3513   xu   1. 删除冗余的代码 
35
34327c62   xu   1. F 完成所有接口的逻辑 
36
 
        return $all;
aa2f3513   xu   1. 删除冗余的代码 
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
 
    }

    /**
     * @param $where
     * @return int|string
     */
    static function getListCount($where)
    {
        $deviceFind = DeviceModel::find();
        $deviceFind->alias('a');
        $deviceFind->leftJoin(CreateBatchModel::tableName().' b','b.id = a.batch_id');
        $deviceFind->leftJoin('manufacture as m', 'm.id = b.manufacture_id');
        $deviceFind->leftJoin('project as p', 'p.id = b.project_id');
        $deviceFind->leftJoin('model as mo', 'mo.id = b.model_id');
        $deviceFind->leftJoin('production as pd', 'pd.id = b.production_id');
        $deviceFind->where($where);
        $all = $deviceFind->count();

        return $all;
931eed21   xu   1. A授权接口开发 
56
57
58
59
60
61
 
    }

    /**
     * @param $condition
     * @return null|static
     */
aa2f3513   xu   1. 删除冗余的代码 
62
63
64
65
66
67
68
 
    static function findOne($condition)
    {
        return DeviceModel::findOne($condition);
    }

    /**
     * @param $condition
931eed21   xu   1. A授权接口开发 
69
 
     * @return array|\yii\db\ActiveRecord[]
aa2f3513   xu   1. 删除冗余的代码 
70
71
 
     */
    static function findAll($condition)
931eed21   xu   1. A授权接口开发 
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
    {
        $deviceModel = DeviceModel::find();
        $deviceModel->where($condition);
        $list = $deviceModel->all();
        return $list;
    }

    /**
     * @param $condition
     * @return int|string
     */
    static function rowsCount($condition)
    {
        $deviceModel = DeviceModel::find();
        $deviceModel->where($condition);
        $count = $deviceModel->count();
        return $count;
    }
}
aa2f3513   xu   1. 删除冗余的代码 












931eed21
 
 xu
 
1. A授权接口开发
















37a28dcc
 
 xu
 
1. F 授权接口调整，有重大的bug
















931eed21
 
 xu
 
1. A授权接口开发
















aa2f3513
 
 xu
 
1. 删除冗余的代码
















37a28dcc
 
 xu
 
1. F 授权接口调整，有重大的bug
















4e3f2365
 
 xu
 
common
















aa2f3513
 
 xu
 
1. 删除冗余的代码