InquiryInfoLogic.php
2.0 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
<?php
namespace App\Http\Logic\Aside\Projects;
use App\Http\Logic\Aside\BaseLogic;
use App\Models\Projects\InquiryInfo;
/**
* @remark :询盘中心
* @class :InquiryInfoLogic.php
* @author :lyh
* @time :2023/7/11 15:20
*/
class InquiryInfoLogic extends BaseLogic
{
public function __construct()
{
parent::__construct();
$this->param = $this->requestAll;
$this->model = new InquiryInfo();
}
/**
* @remark :获取列表
* @name :getInquiryLists
* @author :lyh
* @method :post
* @time :2023/7/11 15:25
*/
public function getInquiryLists($map,$page,$row,$order = 'id'){
$query = $this->model->leftJoin('gl_inquiry_user', 'gl_inquiry_user.xp_id', '=', 'gl_inquiry_info.id')
->orderBy('gl_inquiry_info.'.$order,'desc');
$query = $this->searchParam($query,$map);
$lists = $query->paginate($row, $this->selectParam(), 'page', $page);
return $this->success($lists);
}
/**
* @remark :查询字段
* @name :selectParam
* @author :lyh
* @method :post
* @time :2023/7/11 16:57
*/
public function selectParam(){
$select = [
'gl_inquiry_info.*',
'gl_inquiry_user.user_id',
'gl_inquiry_user.user_name',
'gl_inquiry_user.time',
'gl_inquiry_user.message',
'gl_inquiry_user.ip',
'gl_inquiry_user.url',
'gl_inquiry_user.`status`',
'gl_inquiry_user.yanchi',
'gl_inquiry_user.send_time'
];
return $select;
}
/**
* @name :(搜索参数处理)searchParam
* @author :lyh
* @method :post
* @time :2023/6/14 14:58
*/
public function searchParam(&$query,$map){
//搜索条件处理
if(isset($map['domain'])){
$query = $query->where('gl_inquiry_info.domain','like','%'.$map['domain'].'%');
}
return $query;
}
}