AllProjectController.php
2.5 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
<?php
/**
* @remark :
* @name :AllProjectController.php
* @author :lyh
* @method :post
* @time :2024/11/12 9:34
*/
namespace App\Http\Controllers\Aside\Project;
use App\Enums\Common\Code;
use App\Http\Controllers\Aside\BaseController;
use App\Models\Domain\DomainInfo;
use App\Models\Project\CountAllProject;
use Illuminate\Support\Facades\DB;
/**
* @remark :统计所有项目（4.0,5.0,6.0）
* @name :AllProjectController
* @author :lyh
* @method :post
* @time :2024/11/12 9:34
*/
class AllProjectController extends BaseController
{
/**
* @remark :统计所有项目列表
* @name :lists
* @author :lyh
* @method :post
* @time :2024/11/12 9:35
*/
public function lists(CountAllProject $allProject){
if(isset($this->map['product_domain']) && !empty($this->map['product_domain'])){
$parsedUrl = parse_url($this->map['product_domain']);
$this->map['product_domain'] = $parsedUrl['host'] ?? $this->map['product_domain'];
$this->map['product_domain'] = ['like','%'.$this->map['product_domain'].'%'];
}
if(isset($this->map['test_domain']) && !empty($this->map['test_domain'])){
$this->map['test_domain'] = ['like','%'.$this->map['test_domain'].'%'];
}
if(isset($this->map['title']) && !empty($this->map['title'])){
$this->map['title'] = ['like','%'.$this->map['title'].'%'];
}
if(isset($this->map['company']) && !empty($this->map['company'])){
$this->map['company'] = ['like','%'.$this->map['company'].'%'];
}
$data = $allProject->lists($this->map,$this->page,$this->row);
if (!empty($data['data'])) {
foreach ($data['data'] as $key => $value) {
$ticketProject = null;
if ($value['version'] == 1) {
// version 为 1：6.0
$ticketProject = DB::table('gl_ticket_projects')
->where('table_id', $value['project_id'])
->where('project_cate', 2)
->first();
} else {
// version 不为 1
$ticketProject = DB::table('gl_ticket_projects')
->where('post_id', $value['project_id'])
->where('project_cate', 1)
->first();
}
$data['data'][$key]['uuid'] = $ticketProject ? $ticketProject->uuid : null;
}
}
$this->response('success',Code::SUCCESS,$data);
}
}