CreateBatchRepository.php
1.78 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
<?php
namespace domain\device;
use domain\device\models\CreateBatch as CreateBatchModel;
use yii\db\Query;
class CreateBatchRepository
{
/**
* @param $condition
* @return null|static
*/
static function findOne($condition)
{
return CreateBatchModel::findOne($condition);
}
/**
* @param $type
* @param $keyword
* @return array
*/
static function getSerialNoComponent($type, $keyword)
{
if ('manufacture' == $type) {
$q = new Query();
$q->select('id,manufacture_no, name');
$q->from('manufacture');
$q->where('name like "%'.$keyword.'%" or manufacture_no like "%'.$keyword.'%"');
$q->limit(20);
$list = $q->all();
return $list;
} elseif('project' == $type) {
$q = new Query();
$q->select('id,project_no, name');
$q->from('project');
$q->where('name like "%'.$keyword.'%" or project_no like "%'.$keyword.'%"');
$q->limit(20);
$list = $q->all();
return $list;
} elseif ('model' == $type) {
$q = new Query();
$q->select('id,model_no, name');
$q->from('model');
$q->where('name like "%'.$keyword.'%" or model_no like "%'.$keyword.'%"');
$q->limit(20);
$list = $q->all();
return $list;
} elseif ('production' == $type) {
$q = new Query();
$q->select('id,production_no, name');
$q->from('production');
$q->where('name like "%'.$keyword.'%" or production_no like "%'.$keyword.'%"');
$q->limit(20);
$list = $q->all();
return $list;
} else {
return [];
}
}
}