SalesmanorderController.php
4.4 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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
namespace app\admin\controller;
use app\admin\model\RouteModel;
use cmf\controller\AdminBaseController;
use function GuzzleHttp\Psr7\str;
use think\Db;
class SalesmanorderController extends AdminBaseController{
/**
* 业务员订单列表
*/
public function sale_order_list(){
if($this -> request -> isPost()){
$where = [
'indent_type' => 2
];
if(!empty($_POST['start_time']) && !empty($_POST['end_time'])){
$start_time = strtotime($_POST['start_time']);
$end_time = strtotime($_POST['end_time']);
$where['create_time'] = [['>=',$start_time],['<=',$end_time]];
}
if(!empty($_POST['keyword'])){
$where['order_number'] = $_POST['keyword'];
}
if(!empty($_POST['state'])){
$where['state'] = $_POST['state'];
}
if(!empty($_POST['uid'])){
$where['salesman_uid'] = $_POST['uid'];
}
if(!empty($_POST['school'])){
$where['school'] = $_POST['school'];
}
if(!empty($_POST['grade'])){
$where['grade'] = $_POST['grade'];
}
$data = Db::name('indent') -> where($where) -> paginate(1000000);
$data_arr = $data -> toArray();
}else{
$data = Db::name('indent') -> where('indent_type',2) -> paginate(12);
$data_arr = $data -> toArray();
}
$money = 0;
foreach($data_arr['data'] as $key => $val){
$data_arr['data'][$key]['grade_class'] = $val['school'].'-'.$val['grade'].$val['class'];
}
foreach ($data_arr['data'] as $key => $val){
if($val['state'] == 2 || $val['state'] == 3 || $val['state'] == 5){
$money += $data_arr['data'][$key]['money'];
}
}
$data_school = Db::name('school') -> group('school') -> select() -> toArray();
foreach($data_school as $key => $val){
$school[$key] = $val['school'];
}
$uid = Db::name('my_user') -> alias('a') -> join('user b','a.uid = b.id','LEFT') -> where('a.status = 2') -> select();
/* foreach($uid as $key => $val){
$sales[$key]['uid'] = $val['id'];
$sales[$key]['name'] = $val['user_nickname'];
}*/
$this -> assign('data_arr',$data);
$this -> assign('school',$school);
$this -> assign('sales',$uid);
$this -> assign('money',$money);
$this -> assign('data',$data_arr['data']);
return $this -> fetch();
}
/**
* 业务员订单查看
*/
public function sale_order_show(){
$id = $this -> request -> param();
$data = Db::name('indent') -> where('id',$id['id']) -> find();
//判断订单是业务员订单还是平台订单
if($data['indent_type'] == 1){
if(!empty($data['indent_address'])){
$address = Db::name('address') -> where("id",$data['indent_address']) -> find();
$address_region = $address['region'].$address['detailed'];
}else{
$address_region = '';
}
}else{
$address_region = $data['region'].$data['school'].$data['grade'].$data['class'];
}
//判断订单是统一配送还是快递配送
if($data['is_courier'] == 1){
$logistics = $data['start_time'];
$this -> assign('logistics',$logistics);
}else{
$bird = new BirdController();
$logistics = $bird -> getOrder($id['id']);
if($logistics['code'] == 40000){
$this -> assign('logistics',4);
}else{
$this -> assign('logistics',$logistics['data']['traces']);
}
}
$data_content = Db::name('indent_goods') -> where('indent_id',$id['id']) -> select();
$this -> assign('data',$data);
$this -> assign('address_region',$address_region);
$this -> assign('data_content',$data_content);
return $this -> fetch();
}
/**
* 业务员订单删除
*/
public function sale_order_del(){
$id = $_POST['id'];
$data = Db::name('indent') -> delete($id);
$goods = Db::name('indent_goods') -> where('indent_id',$id) -> delete();
if($data){
return true;
}else{
return false;
}
}
}