审查视图

app/portal/controller/IndexController.php 23.5 KB
anyv authored
1 2 3 4 5 6 7 8 9 10
<?php
// +----------------------------------------------------------------------
// | bronet [ 以客户为中心 以奋斗者为本 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2017 http://www.bronet.cn All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
namespace app\portal\controller;
anyv authored
11 12
use cmf\controller\WeChatBaseController;
use think\Db;
anyv authored
13
anyv authored
14
class IndexController extends WeChatBaseController
anyv authored
15
{
anyv authored
16 17 18
    /**
     * 显示首页
     */
anyv authored
19 20
    public function index(){
anyv authored
21
        //显示分类
anyv authored
22 23
        $data_classif= Db::name('classification') -> select();
        $this -> assign('data_classif',$data_classif);
anyv authored
24
        //热门推荐
anyv authored
25
        $data_goods_hot = Db::name('goods') -> alias('a') -> field('a.*,b.name') -> join('classification b','a.classify_id = b.id','LEFT') -> where("recommend_hot=1 and type = 1") -> select() -> toArray();
anyv authored
26 27 28 29 30 31
        if(!empty($data_goods_hot)){
            foreach($data_goods_hot as $key => $val){
                $price = explode('.',$data_goods_hot[$key]['price']);
                $data_goods_hot[$key]['price0'] = $price[0];
                $data_goods_hot[$key]['price1'] = $price[1];
            }
anyv authored
32
        }
anyv authored
33 34 35
        //首页轮播图
        $slideshow = Db::name('slide_item') -> select();
        $this -> assign('slideshow',$slideshow);
anyv authored
36 37 38 39 40
        //判断用户是否存在
        $uid = cmf_get_current_user_id();
        $data_my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($data_my_user){
            //用户是否为自由人 是自由人则绑定 不是自由人判断是不是老师
anyv authored
41
            if($data_my_user['status'] == 0 || $data_my_user['status'] == 1 || $data_my_user['status'] == 5 || $data_my_user['status'] == 6){
anyv authored
42 43 44 45 46 47 48 49 50 51 52 53 54 55
                $data_id = $this -> request -> param();
                //判断跳转链接是否存在数据 存在则绑定关系
                if(!empty($data_id)){
                    //判断数据是老师还是业务员
                    if($data_id['status_id'] == 2){
                        //业务员分享 更改用户身份为老师
                        $my_user_phone = Db::name('my_user') -> where('id',$data_id['my_user_id']) -> find();
                        $data_update['status'] = 3;
                        $data_update['inviter_phone'] = $my_user_phone['phone'];
                        $data_update['is_pro'] = 1;
                        $data_update['pid'] = $my_user_phone['id'];
                        $data_update['bind_time'] = time();
                        $data_update['bind_status'] = 1;
                        Db::name('my_user') -> where('uid',$uid) -> update($data_update);
8  
anyv authored
56
                        $data_goods = Db::name('goods') -> where('uid',$my_user_phone['uid']) -> limit(3) -> select() -> toArray();
anyv authored
57 58 59 60 61 62 63 64 65 66
                    }elseif ($data_id['status_id'] == 3){
                        //老师分享 更改用户身份为学生
                        $my_user_phone = Db::name('my_user') -> where('id',$data_id['my_user_id']) -> find();
                        $data_update['status'] = 4;
                        $data_update['inviter_phone'] = $my_user_phone['phone'];
                        $data_update['is_pro'] = 0;
                        $data_update['pid'] = $my_user_phone['id'];
                        $data_update['bind_time'] = time();
                        $data_update['bind_status'] = 1;
                        Db::name('my_user') -> where('uid',$uid) -> update($data_update);
anyv authored
67
                        $salesman_id = Db::name('my_user') -> where('id',$my_user_phone['pid']) -> find();
8  
anyv authored
68
                        $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
                    }
                }
            }else{
                $data_id = $this -> request -> param();
                //判断跳转链接是否存在数据
                if(!empty($data_id)){
                    //判断用户是不是老师
                    if($data_my_user['status'] == 3){
                        //是老师则判断老师绑定状态
                        if($data_my_user['bind_status'] = 2){
                            //判断是否为业务员分享的链接
                            if($data_id['status_id'] == 2){
                                //是业务员分享则更新老师的pid
                                $my_user_phone = Db::name('my_user') -> where('id',$data_id['my_user_id']) -> find();
                                $data_update['pid'] = $my_user_phone['id'];
anyv authored
84 85
                                $data_update['bind_time'] = time();
                                $data_update['bind_status'] = 1;
anyv authored
86
                                Db::name('my_user') -> where('uid',$uid) -> update($data_update);
8  
anyv authored
87
                                $data_goods = Db::name('goods') -> where('uid',$my_user_phone['uid']) -> limit(3) -> select() -> toArray();
anyv authored
88 89
                            }else{
                                $salesman_id = Db::name('my_user') -> where('id',$data_my_user['pid']) -> find();
8  
anyv authored
90
                                $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
91 92 93
                            }
                        }else{
                            $salesman_id = Db::name('my_user') -> where('id',$data_my_user['pid']) -> find();
8  
anyv authored
94
                            $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
95 96 97 98
                        }
                    }else{
                        //当为业务员时显示的数据
                        if($data_my_user['status'] == 2){
8  
anyv authored
99
                            $data_goods = Db::name('goods') -> where('uid',$data_my_user['uid']) -> limit(3) -> select() -> toArray();
anyv authored
100 101 102 103 104
                        }
                        //当为学生时显示的数据
                        if($data_my_user['status'] == 4){
                            $teacher_id = Db::name('my_user') -> where('id',$data_my_user['pid']) -> find();
                            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
8  
anyv authored
105
                            $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
106 107 108 109 110
                        }
                    }
                }else{
                    //当为业务员时显示的数据
                    if($data_my_user['status'] == 2){
8  
anyv authored
111
                        $data_goods = Db::name('goods') -> where('uid',$data_my_user['uid']) -> limit(3) -> select() -> toArray();
anyv authored
112 113 114 115
                    }
                    //当为老师时显示的数据
                    if($data_my_user['status'] == 3){
                        $salesman_id = Db::name('my_user') -> where('id',$data_my_user['pid']) -> find();
8  
anyv authored
116
                        $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
117 118 119 120 121
                    }
                    //当为学生时显示的数据
                    if($data_my_user['status'] == 4){
                        $teacher_id = Db::name('my_user') -> where('id',$data_my_user['pid']) -> find();
                        $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
8  
anyv authored
122
                        $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144
                    }
                }


            }
        }else{
            $data_id = $this -> request -> param();
            //判断跳转链接是否存在数据 如果不存在添加一条自由人用户
            if(!empty($data_id)){
                //判断数据是老师还是业务员
                if($data_id['status_id'] == 2){
                    //业务员分享 添加老师
                    $my_user_phone = Db::name('my_user') -> where('id',$data_id['my_user_id']) -> find();
                    $data_inser['status'] = 3;
                    $data_inser['uid'] = $uid;
                    $data_inser['inviter_phone'] = $my_user_phone['phone'];
                    $data_inser['create_time'] = time();
                    $data_inser['is_pro'] = 1;
                    $data_inser['pid'] = $my_user_phone['id'];
                    $data_inser['bind_time'] = time();
                    $data_inser['bind_status'] = 1;
                    Db::name('my_user') -> insert($data_inser);
8  
anyv authored
145
                    $data_goods = Db::name('goods') -> where('uid',$my_user_phone['uid']) -> limit(3) -> select() -> toArray();
anyv authored
146 147 148 149 150 151 152 153 154 155 156 157
                }elseif ($data_id['status_id'] == 3){
                    //老师分享 添加学生
                    $my_user_phone = Db::name('my_user') -> where('id',$data_id['my_user_id']) -> find();
                    $data_inser['status'] = 4;
                    $data_inser['uid'] = $uid;
                    $data_inser['inviter_phone'] = $my_user_phone['phone'];
                    $data_inser['create_time'] = time();
                    $data_inser['is_pro'] = 0;
                    $data_inser['pid'] = $my_user_phone['id'];
                    $data_inser['bind_time'] = time();
                    $data_inser['bind_status'] = 1;
                    Db::name('my_user') -> insert($data_inser);
anyv authored
158
                    $salesman_id = Db::name('my_user') -> where('id',$my_user_phone['pid']) -> find();
8  
anyv authored
159
                    $data_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> limit(3) -> select() -> toArray();
anyv authored
160 161 162 163 164 165 166 167 168 169
                }
            }else{
                $data_inser['status'] = 0;
                $data_inser['uid'] = $uid;
                $data_inser['create_time'] = time();
                $data_inser['is_pro'] = 0;
                Db::name('my_user') -> insert($data_inser);
            }

        }
anyv authored
170 171
        if(empty($data_goods)) {
            $data_goods = null;
5  
anyv authored
172
            $limit_num = 3;
5  
anyv authored
173 174
        }else{
            $limit_num = 3-count($data_goods);
anyv authored
175
        }
anyv authored
176
        $this -> assign('data_goods',$data_goods);
anyv authored
177
        //推荐新品
8  
anyv authored
178
        if($limit_num != 0){
4  
anyv authored
179
            $data_goods_recommend_new = Db::name('goods') -> alias('a') -> field('a.*,b.name') -> join('classification b','a.classify_id = b.id','LEFT') -> where("recommend_new=1 and is_out = 1 and type = 1") -> limit($limit_num) -> select() -> toArray();
5  
anyv authored
180 181
        }else{
            $data_goods_recommend_new = null;
8  
anyv authored
182
        }
anyv authored
183
        $this -> assign('data_goods_recommend_new',$data_goods_recommend_new);
anyv authored
184
        $this -> assign('data_goods_hot',$data_goods_hot);
anyv authored
185 186
        return $this -> fetch();
anyv authored
187
    }
anyv authored
188
anyv authored
189 190 191 192 193
    /**
     * 首页搜索
     */
    public function search_salesman_goods(){
anyv authored
194
        $book_name = $this -> request -> param();
anyv authored
195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210
        $uid = cmf_get_current_user_id();
        $data_status = Db::name('my_user') -> where("uid",$uid) -> find();
        $where = ['type'=>1];
        if($data_status['status'] == 2){
            $where = "type = 1 or uid = ".$uid;
        }
        if($data_status['status'] == 3){
           $salesman_uid = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_uid['uid'];
        }
        if($data_status['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_id['uid'];
        }
anyv authored
211
        if(empty($book_name['book_name'])){
anyv authored
212
            $book_name = '';
anyv authored
213
            $data_salesman_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> select() -> toArray();
9  
anyv authored
214
        }else{
anyv authored
215
            $book_name = $book_name['book_name'];
anyv authored
216
            $data_salesman_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> where('book_name','like',"%".$book_name."%") -> select() -> toArray();
9  
anyv authored
217
        }
anyv authored
218 219 220 221 222 223 224
        if(!empty($data_salesman_goods)){
            foreach ($data_salesman_goods as $key => $val){
                $price = explode('.',$data_salesman_goods[$key]['price']);
                $data_salesman_goods[$key]['price0'] = $price[0];
                $data_salesman_goods[$key]['price1'] = $price[1];
            }
        }
anyv authored
225
        $this -> assign('search_content',$book_name);
anyv authored
226
        $this -> assign('data_salesman_goods',$data_salesman_goods);
anyv authored
227
        return $this -> fetch();
anyv authored
228
anyv authored
229
    }
anyv authored
230
anyv authored
231 232 233 234 235
    /**
     * 首页搜索结果页 销量排序
     */
    public function search_sales_order(){
anyv authored
236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251
        $uid = cmf_get_current_user_id();
        $data_status = Db::name('my_user') -> where("uid",$uid) -> find();
        $where = ['type'=>1];
        if($data_status['status'] == 2){
            $where = "type = 1 or uid = ".$uid;
        }
        if($data_status['status'] == 3){
            $salesman_uid = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_uid['uid'];
        }
        if($data_status['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_id['uid'];
        }
anyv authored
252
        $search_content = $_POST['search_content'];
anyv authored
253
        $search_content_data = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> where('book_name','like',"%".$search_content."%") -> order('sales desc') -> select() -> toArray();
6  
anyv authored
254 255 256 257 258
        if(!empty($search_content_data)){
            foreach ($search_content_data as $key => $val){
                $price = explode('.',$search_content_data[$key]['price']);
                $search_content_data[$key]['price0'] = $price[0];
                $search_content_data[$key]['price1'] = $price[1];
6  
anyv authored
259
                $search_content_data[$key]['show_img'] = cmf_get_image_url($search_content_data[$key]['show_img']);
6  
anyv authored
260 261 262
            }
        }
        return json_encode($search_content_data);
anyv authored
263 264

    }
anyv authored
265
5  
anyv authored
266 267 268 269 270
    /**
     * 首页搜索结果页 价格排序
     */
    public function search_price_order(){
anyv authored
271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286
        $uid = cmf_get_current_user_id();
        $data_status = Db::name('my_user') -> where("uid",$uid) -> find();
        $where = ['type'=>1];
        if($data_status['status'] == 2){
            $where = "type = 1 or uid = ".$uid;
        }
        if($data_status['status'] == 3){
            $salesman_uid = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_uid['uid'];
        }
        if($data_status['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_id['uid'];
        }
5  
anyv authored
287
        $search_content = $_POST['search_content'];
anyv authored
288
        $search_content_data = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> where('book_name','like',"%".$search_content."%") -> order('price desc') -> select() -> toArray();
5  
anyv authored
289 290 291 292 293 294 295 296 297 298 299
        if(!empty($search_content_data)){
            foreach ($search_content_data as $key => $val){
                $price = explode('.',$search_content_data[$key]['price']);
                $search_content_data[$key]['price0'] = $price[0];
                $search_content_data[$key]['price1'] = $price[1];
                $search_content_data[$key]['show_img'] = cmf_get_image_url($search_content_data[$key]['show_img']);
            }
        }
        return json_encode($search_content_data);

    }
anyv authored
300
5  
anyv authored
301 302 303 304
    /**
     * 首页搜索结果页 综合
     */
    public function search_synthesis_order(){
anyv authored
305
anyv authored
306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321
        $uid = cmf_get_current_user_id();
        $data_status = Db::name('my_user') -> where("uid",$uid) -> find();
        $where = ['type'=>1];
        if($data_status['status'] == 2){
            $where = "type = 1 or uid = ".$uid;
        }
        if($data_status['status'] == 3){
            $salesman_uid = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_uid['uid'];
        }
        if($data_status['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_id['uid'];
        }
5  
anyv authored
322
        $book_name = $_POST['search_content'];
anyv authored
323
        $data_salesman_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> where('book_name','like',"%".$book_name."%") -> select() -> toArray();
5  
anyv authored
324 325 326 327 328 329 330 331 332
        if(!empty($data_salesman_goods)){
            foreach ($data_salesman_goods as $key => $val){
                $price = explode('.',$data_salesman_goods[$key]['price']);
                $data_salesman_goods[$key]['price0'] = $price[0];
                $data_salesman_goods[$key]['price1'] = $price[1];
                $data_salesman_goods[$key]['show_img'] = cmf_get_image_url($data_salesman_goods[$key]['show_img']);
            }
        }
        return json_encode($data_salesman_goods);
anyv authored
333
5  
anyv authored
334
    }
anyv authored
335
anyv authored
336 337 338 339 340 341
    /**
     * 搜索跳转详情页
     */
    public function search_goods_details(){

        $goods_id =  $this -> request -> param();
7  
anyv authored
342
        $data = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where('a.id',$goods_id['goods_id']) -> find();
anyv authored
343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361
        $price = explode('.',$data['price']);
        $pricing = explode('.',$data['pricing']);
        $data['price0'] = $price[0];
        $data['price1'] = $price[1];
        $data['pricing0'] = $pricing[0];
        $data['pricing1'] = $pricing[1];
        $data['det_img'] = json_decode($data['det_img'],true);
        $this -> assign('det_img',$data['det_img']);
        $this -> assign('data',$data);
        $data_label = Db::name('label') -> alias('a') -> field("a.*,b.goods_id,b.label_id") -> join('goods_label b','a.id=b.label_id','LEFT') -> where("b.goods_id = ".$goods_id['goods_id']) -> select();
        $this -> assign('data_label',$data_label);
        if($data['type'] == 1){
            //相关推荐
            $data_recomm = Db::name('goods') -> where("classify_id =".$data['classify_id']." and type = 1") -> limit(3) -> select();
            $this -> assign('data_recomm',$data_recomm);
            $this -> assign('is_recomm',1);
        }else{
            $this -> assign('is_recomm',2);
        }
anyv authored
362 363 364 365 366 367 368 369
        //添加浏览记录
        $uid = cmf_get_current_user_id();
        $data_browsing_history = Db::name('browsing_history') -> where("uid = ".$uid." and goods_id =".$goods_id['goods_id']) -> find();
        if(empty($data_browsing_history)){
            $browsing_history['uid'] = $uid;
            $browsing_history['goods_id'] = $goods_id['goods_id'];
            Db::name('browsing_history') -> insert($browsing_history);
        }
anyv authored
370 371 372
        return $this -> fetch();

    }
anyv authored
373
5  
anyv authored
374 375 376 377 378
    /**
     * 显示业务员商城页
     */
    public function salesman_goods(){
4  
anyv authored
379 380 381 382 383
        $uid = cmf_get_current_user_id();
        $user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($user['status'] == 0 || $user['status'] == 1 || $user['status'] == 5 || $user['status'] == 6){
            $salesman_goods = null;
        }elseif ($user['status'] == 2){
5  
anyv authored
384
            $salesman_goods = Db::name('goods') -> where('uid',$uid) -> where('is_out',1) -> order("sort desc") -> select() -> toArray();
4  
anyv authored
385 386
        }elseif ($user['status'] == 3){
            $salesman_id = Db::name('my_user') -> where('id',$user['pid']) -> find();
5  
anyv authored
387
            $salesman_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> where('is_out',1) -> order("sort desc") -> select() -> toArray();
4  
anyv authored
388 389 390
        }elseif ($user['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$user['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
5  
anyv authored
391
            $salesman_goods = Db::name('goods') -> where('uid',$salesman_id['uid']) -> where('is_out',1) -> order("sort desc") -> select() -> toArray();
4  
anyv authored
392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409
        }
        if(!empty($salesman_goods)){
            foreach ($salesman_goods as $key => $val){
                $price = explode('.',$salesman_goods[$key]['price']);
                $salesman_goods[$key]['price0'] = $price[0];
                $salesman_goods[$key]['price1'] = $price[1];
            }
        }
        $this -> assign('salesman_goods',$salesman_goods);
        $goods = Db::name('goods') -> where("type = 1 and is_out = 1 and recommend_new = 1") -> select() -> toArray();
        if(!empty($goods)){
            foreach($goods as $key => $val){
                $price = explode('.',$goods[$key]['price']);
                $goods[$key]['price0'] = $price[0];
                $goods[$key]['price1'] = $price[1];
            }
        }
        $this -> assign('goods',$goods);
5  
anyv authored
410 411 412 413
        return $this -> fetch();

    }
5  
anyv authored
414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430
    /**
     * 显示热门推荐页
     */
    public function hot_goods(){

        $hot_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join("classification b","a.classify_id = b.id","LEFT") -> where("a.type = 1 and a.is_out = 1 and recommend_hot = 1") -> select() -> toArray();
        if(!empty($hot_goods)){
            foreach ($hot_goods as $key => $val){
                $price = explode('.',$hot_goods[$key]['price']);
                $hot_goods[$key]['price0'] = $price[0];
                $hot_goods[$key]['price1'] = $price[1];
            }
        }
        $this -> assign('hot_goods',$hot_goods);
        return $this -> fetch();

    }
5  
anyv authored
431
anyv authored
432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468
    /**
     *搜索页点击搜索
     */
    public function my_search(){

        $uid = cmf_get_current_user_id();
        $data_status = Db::name('my_user') -> where("uid",$uid) -> find();
        $where = ['type'=>1];
        if($data_status['status'] == 2){
            $where = "type = 1 or uid = ".$uid;
        }
        if($data_status['status'] == 3){
            $salesman_uid = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_uid['uid'];
        }
        if($data_status['status'] == 4){
            $teacher_id = Db::name('my_user') -> where('id',$data_status['pid']) -> find();
            $salesman_id = Db::name('my_user') -> where('id',$teacher_id['pid']) -> find();
            $where = "type = 1 or uid =".$salesman_id['uid'];
        }
        if(empty($_POST['book_name'])){
            $book_name = '';
            $data_salesman_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> select() -> toArray();
        }else{
            $book_name = $_POST['book_name'];
            $data_salesman_goods = Db::name('goods') -> alias('a') -> field("a.*,b.name") -> join('classification b','a.classify_id = b.id','LEFT') -> where($where) -> where('book_name','like',"%".$book_name."%") -> select() -> toArray();
        }
        if(!empty($data_salesman_goods)){
            foreach ($data_salesman_goods as $key => $val){
                $price = explode('.',$data_salesman_goods[$key]['price']);
                $data_salesman_goods[$key]['price0'] = $price[0];
                $data_salesman_goods[$key]['price1'] = $price[1];
            }
        }
        return json_encode($data_salesman_goods);

    }
anyv authored
469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495


























anyv authored
496
}