SalesmanorderController.php
3.9 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
<?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'];
}
$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;
}
}
}