审查视图

app/portal/controller/PersonalcenterController.php 28.1 KB
anyv authored
1 2 3 4 5 6 7 8 9 10 11 12
<?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;

use cmf\controller\WeChatBaseController;
use think\Db;
anyv authored
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

class sendAPI {
    public $data;	//发送数据
    public $timeout = 30; //超时
    private $apiUrl;	//发送地址
    private $username;	//用户名
    private $password;	//密码

    function __construct($url, $username, $password) {
        $this->apiUrl 	= $url;
        $this->username = $username;
        $this->password = $password;
    }

    private function httpGet() {
        $url = $this->apiUrl . '?' . http_build_query($this->data);
        $curl = curl_init();
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($curl, CURLOPT_TIMEOUT, $this->timeout);
        curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
        curl_setopt($curl, CURLOPT_URL, $url);
        $res = curl_exec($curl);
        if (curl_errno($curl)) {
            echo 'Error GET '.curl_error($curl);
        }
        curl_close($curl);
        return $res;
    }

    private function httpPost(){ // 模拟提交数据函数
        $curl = curl_init(); // 启动一个CURL会话
        curl_setopt($curl, CURLOPT_URL, $this->apiUrl); // 要访问的地址
        curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); // 对认证证书来源的检查
        curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); // 从证书中检查SSL加密算法是否存在
        curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); // 模拟用户使用的浏览器
        curl_setopt($curl, CURLOPT_POST, true); // 发送一个常规的Post请求
        curl_setopt($curl, CURLOPT_POSTFIELDS,  http_build_query($this->data)); // Post提交的数据包
        curl_setopt($curl, CURLOPT_TIMEOUT, $this->timeout); // 设置超时限制防止死循环
        curl_setopt($curl, CURLOPT_HEADER, false); // 显示返回的Header区域内容
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); // 获取的信息以文件流的形式返回
        $result = curl_exec($curl); // 执行操作
        if (curl_errno($curl)) {
            echo 'Error POST'.curl_error($curl);
        }
        curl_close($curl); // 关键CURL会话
        return $result; // 返回数据
    }

    /**
     * @param $type|提交类型 POST/GET
     * @param $isTranscoding|是否需要转 $isTranscoding 是否需要转utf-8 默认 false
     * @return mixed
     */
    public function sendSMS($type, $isTranscoding = false) {
        $this->data['content'] 	= $isTranscoding === true ? mb_convert_encoding($this->data['content'], "UTF-8") : $this->data['content'];
        $this->data['username'] = $this->username;
        $this->data['tkey'] 	= date('YmdHis');
        $this->data['password'] = md5(md5($this->password) . $this->data['tkey']);
        return  $type == "POST" ? $this->httpPost() : $this->httpGet();
    }

}
anyv authored
76 77 78 79 80 81

class PersonalcenterController extends WeChatBaseController{

    /**
     * 显示个人中心页
     */
4  
anyv authored
82
    public function personal_center(){
5  
anyv authored
83
5  
anyv authored
84 85
        $uid = cmf_get_current_user_id();
        $my_user_status = Db::name('my_user') -> where('uid',$uid) -> find();
anyv authored
86 87
        $weixin = Db::name('user') -> where('id',$uid) -> find();
        $this -> assign('weixin',$weixin);
5  
anyv authored
88
        if($my_user_status['status'] == 0 || $my_user_status['status'] == 1 || $my_user_status['status'] == 3 || $my_user_status['status'] == 4 || $my_user_status['status'] == 5 || $my_user_status['status'] == 6){
5  
anyv authored
89 90 91
            if($my_user_status['status'] == 0){
                $this -> assign('status',0);
            }
5  
anyv authored
92
            if($my_user_status['status'] == 1 || $my_user_status['status'] == 5 || $my_user_status['status'] == 6){
5  
anyv authored
93 94 95 96 97 98 99 100 101 102
                $this -> assign('status',1);
            }
            if($my_user_status['status'] == 3){
                $this -> assign('status',3);
            }
            if($my_user_status['status'] == 4){
                $this -> assign('status',4);
            }
            return $this -> fetch();
        }
5  
anyv authored
103
        //业务员个人中心页
5  
anyv authored
104
        if($my_user_status['status'] == 2){
1  
anyv authored
105
            $this -> assign('weixin',$weixin);
5  
anyv authored
106
            return $this -> fetch('personalcenter/salesman_center');
5  
anyv authored
107
        }
5  
anyv authored
108
8  
anyv authored
109
    }
5  
anyv authored
110
8  
anyv authored
111 112 113 114
    /**
     * 完善个人信息页
     */
    public function perfect_information(){
5  
anyv authored
115
8  
anyv authored
116
        $uid = cmf_get_current_user_id();
5  
anyv authored
117
        $my_user_status = Db::name('my_user') -> where('uid',$uid) -> find();
5  
anyv authored
118 119 120 121 122 123 124 125 126 127 128 129 130 131 132
        if($my_user_status['status'] == 2){
            $this -> redirect('Personalcenter/personal_center');
        }else{
            if($my_user_status['status'] == 1){
                $this -> assign('status',1);
            }
            if($my_user_status['status'] == 5){
                $this -> assign('status',5);
            }
            if($my_user_status['status'] == 6){
                $this -> assign('status',6);
            }
            $weixin = Db::name('user') -> where('id',$uid) -> find();
            $this -> assign('weixin',$weixin);
            return $this -> fetch();
5  
anyv authored
133
        }
5  
anyv authored
134
anyv authored
135 136
    }
8  
anyv authored
137
7  
anyv authored
138 139 140 141 142
    /**
     * 我的收藏页
     */
    public function personal_collect(){
4  
anyv authored
143
        $uid = cmf_get_current_user_id();
anyv authored
144
        $data = Db::name('collect') -> where("uid =".$uid) -> select() -> toArray();
4  
anyv authored
145 146 147 148 149
        $data_count = count($data);
        if(!empty($data)){
            foreach($data as $key => $val){
                $data_goods[] = Db::name('goods') -> where("id =".$val['goods_id']) -> find();
            }
8  
anyv authored
150 151 152 153 154 155 156 157
            foreach ($data_goods as $key => $val){
                $price = explode('.',$val['price']);
                $pricing = explode('.',$val['pricing']);
                $data_goods[$key]['price0'] = $price[0];
                $data_goods[$key]['price1'] = $price[1];
                $data_goods[$key]['pricing0'] = $pricing[0];
                $data_goods[$key]['pricing1'] = $pricing[1];
            }
4  
anyv authored
158 159
        }else{
            $data_goods = '';
4  
anyv authored
160
        }
5  
anyv authored
161
        $this -> assign('data_count',$data_count);
8  
anyv authored
162
        $this -> assign('data_goods',$data_goods);
7  
anyv authored
163 164 165 166
        return $this -> fetch();

    }
5  
anyv authored
167 168 169 170 171 172 173 174
    /**
     * 填写个人信息页
     */
    public function add_information(){

        return $this -> fetch();

    }
7  
anyv authored
175
4  
anyv authored
176 177 178 179 180
    /**
     * 浏览记录
     */
    public function browsing_history(){
5  
anyv authored
181
        $uid = cmf_get_current_user_id();
5  
anyv authored
182
        $data = Db::name('browsing_history') -> where("uid =".$uid) -> select();
5  
anyv authored
183 184 185
        foreach($data as $key => $val){
            $data_goods[] = Db::name('goods') -> where('id',$val['goods_id']) -> find();
        }
5  
anyv authored
186 187 188 189 190 191 192 193
        if(!empty($data_goods)){
            foreach($data_goods as $key => $val){
                $price = explode('.',$val['price']);
                $classification_name = Db::name('classification') -> where('id',$val['classify_id']) -> find();
                $data_goods[$key]['classification_name'] = $classification_name['name'];
                $data_goods[$key]['price0'] = $price[0];
                $data_goods[$key]['price1'] = $price[1];
            }
anyv authored
194 195
        }else{
            $data_goods = '';
4  
anyv authored
196
        }
5  
anyv authored
197
        $this -> assign('data_goods',$data_goods);
4  
anyv authored
198 199 200
        return $this -> fetch();

    }
7  
anyv authored
201
5  
anyv authored
202 203 204 205 206
    /**
     * 收货地址页
     */
    public function shop_address(){
anyv authored
207 208
        $uid = cmf_get_current_user_id();
        $data = Db::name('address') -> where("delete_time = 0 and uid =".$uid) ->  select() -> toArray();
5  
anyv authored
209
        $this -> assign('data',$data);
5  
anyv authored
210 211 212
        return $this -> fetch();

    }
7  
anyv authored
213
5  
anyv authored
214 215 216 217 218
    /**
     * 新增地址页
     */
    public function add_shop_address(){
5  
anyv authored
219
        if($this -> request -> isPost()){
5  
anyv authored
220 221
            $uid = cmf_get_current_user_id();
            $_POST['uid'] = $uid;
5  
anyv authored
222 223 224 225 226 227
            $add = Db::name('address') -> insert($_POST);
            if($add){
               return true;
            }else{
                return false;
            }
5  
anyv authored
228 229 230 231
        }else{
            return $this -> fetch();
        }
5  
anyv authored
232 233 234 235 236 237 238 239
    }

    /**
     * 设置默认地址
     */
    public function set_default_address(){

        $uid = cmf_get_current_user_id();
anyv authored
240
        Db::name('address') -> where('uid',$uid) -> update(['default_address'=>0]);
5  
anyv authored
241 242 243 244 245 246
        $data = Db::name('address') -> where('id',$_POST['id']) -> update(['default_address'=>1]);
        if($data){
            return true;
        }else{
            return false;
        }
5  
anyv authored
247 248

    }
7  
anyv authored
249
5  
anyv authored
250
    /**
5  
anyv authored
251
     * 删除地址
5  
anyv authored
252 253
     */
    public function address_del(){
7  
anyv authored
254
5  
anyv authored
255 256
        $delete_time = time();
        $data = Db::name('address') -> where('id',$_POST['id']) ->  update(['delete_time'=>$delete_time]);
5  
anyv authored
257 258 259 260 261
        if($data){
            return true;
        }else{
            return false;
        }
7  
anyv authored
262
5  
anyv authored
263
    }
7  
anyv authored
264
5  
anyv authored
265 266 267 268 269
    /**
     * 编辑地址
     */
    public function address_edit(){
anyv authored
270 271 272 273 274 275 276 277 278 279 280 281 282
        if($this -> request -> isPost()){
            $data_update = Db::name('address') -> update($_POST);
            if($data_update){
               return true;
            }else{
                return false;
            }
        }else{
            $id = $this -> request -> param();
            $data = Db::name('address') -> where('id',$id['id']) -> find();
            $this -> assign('data',$data);
            return $this -> fetch();
        }
5  
anyv authored
283 284

    }
7  
anyv authored
285
anyv authored
286 287 288 289 290 291 292 293 294 295 296 297 298 299
    /**
     * 发送短信
     */
    public function send_message(){

        $url 		= "http://www.ztsms.cn/sendNSms.do";//提交地址
        $username 	= 'xuekaowuyou';//用户名
        $password 	= 'Cxz307312';//原密码
        $sendAPI = new sendAPI($url, $username, $password);
        $key = '';
        $pattern='1234567890';
        for( $i=0; $i<6; $i++ ) {
            $key .= $pattern[mt_rand(0, 9)];
        }
5  
anyv authored
300
        session('code',$key);
anyv authored
301 302 303 304 305 306 307 308 309 310 311 312 313 314 315
        $rand_name = "验证码:".$key."【学考无忧】";
        $phone = $_POST['phone'];
        $data = array(
            'content' 	=> $rand_name,//短信内容
            'mobile' 	=> $phone,//手机号码
            'productid' => '676767',//产品id
            'xh'		=> ''//小号
        );
        $sendAPI->data = $data;//初始化数据包
        $return = $sendAPI->sendSMS('POST');//GET or POST
        if($return){
           return true;
        }else{
            return false;
        }
7  
anyv authored
316
anyv authored
317
    }
7  
anyv authored
318
5  
anyv authored
319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334
    /**
     * 添加审核信息
     */
    public function add_audit(){

        $code = session('code');
        if($code == $_POST['code']){
            $data['name'] = $_POST['name'];
            $data['phone'] = $_POST['phone'];
            $data['id_number'] = $_POST['id_num'];
            $data['img_front'] = $_POST['img0'];
            $data['img_back'] = $_POST['img1'];
            $data['create_time'] = time();
            $data['uid'] = cmf_get_current_user_id();
            $inser = Db::name('sale_audit') -> insert($data);
            if($inser){
5  
anyv authored
335
                Db::name('my_user') -> where('uid',$data['uid']) -> update(['status'=>5,'phone'=>$data['phone']]);
5  
anyv authored
336 337 338 339 340 341 342 343 344
                return 1;
            }else{
               return 2;
            }
        }else{
            return 3;
        }

    }
7  
anyv authored
345
5  
anyv authored
346 347 348 349 350
    /**
     * 我的钱包页
     */
    public function my_wallet(){
anyv authored
351 352
        $uid = cmf_get_current_user_id();
        $balance = Db::name('my_user') -> where("uid",$uid) -> find();
5  
anyv authored
353
        $balance['balance'] = $balance['balance'] - $balance['balance']*0.006;
7  
anyv authored
354
        $balance['balance'] = sprintf("%.2f", $balance['balance']);
1  
anyv authored
355 356 357 358 359 360
        $money_income = Db::name("money_income") -> where('uid',$uid) -> select();
        $cumulative_money = 0;
        foreach ($money_income as $key => $val){
            $cumulative_money += $val['money'];
        }
        $cumulative_money = $cumulative_money-$cumulative_money*0.006;
5  
anyv authored
361 362
        $money_ratio = Db::name('money_ratio') -> where('id',1) -> find();
        $this -> assign('money_ratio',$money_ratio);
anyv authored
363
        $this -> assign('balance',$balance['balance']);
1  
anyv authored
364
        $this -> assign('cumulative_money',$cumulative_money);
6  
anyv authored
365
        $money_expend = Db::name('money_expend') -> where('uid='.$uid." and state=0") -> select();
5  
anyv authored
366 367 368 369
        $money = 0;
        foreach ($money_expend as $key => $val){
            $money += $val['money'];
        }
5  
anyv authored
370
anyv authored
371
        $this -> assign('status',$balance['status']);
5  
anyv authored
372
        $this -> assign('money',$money);
5  
anyv authored
373 374 375
        return $this -> fetch();

    }
7  
anyv authored
376
5  
anyv authored
377 378 379 380 381 382 383 384
    /**
     * 将提现金额存入支出明细表
     */
    public function add_money_expend(){

        $_POST['uid'] = cmf_get_current_user_id();
        $_POST['create_time'] = time();
        $_POST['state'] = 0;
2  
anyv authored
385 386 387 388 389
        $user_balance = Db::name('my_user') -> where('uid',$_POST['uid']) -> find();
        $user_money_expend = Db::name('money_expend') -> where("uid=".$_POST['uid']." and state =0") -> select();
        $money_expend = $_POST['money'];
        foreach ($user_money_expend as $key => $val){
            $money_expend += $val['money'];
5  
anyv authored
390
        }
2  
anyv authored
391 392
        $user_balance['balance'] = $user_balance['balance']-$user_balance['balance']*0.006;
        if($money_expend > $user_balance['balance'] ){
5  
anyv authored
393
            return false;
2  
anyv authored
394 395 396 397 398 399 400 401 402 403 404 405
        }else{
            $data = Db::name('money_expend') -> insert($_POST);
            $money_expend = Db::name('money_expend') -> where('uid='.$_POST['uid']." and state=0") -> select();
            $money = 0;
            foreach ($money_expend as $key => $val){
                $money += $val['money'];
            }
            if($data){
                return $money;
            }else{
                return false;
            }
5  
anyv authored
406 407 408 409
        }

    }
anyv authored
410 411 412 413 414
    /**
     * 邀请名单
     */
    public function invitation_list(){
5  
anyv authored
415 416 417
        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($my_user['status'] == 3){
anyv authored
418
            $student = Db::name('my_user') -> alias('a') -> field("a.*,b.user_nickname,b.avatar") -> join("user b","a.uid = b.id",'LEFT') -> where("a.pid",$my_user['id']) -> select() -> toArray();
anyv authored
419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434
            if(!empty($student)){
                foreach ($student as $key => $val){
                    $student[$key]['indent'] = Db::name('indent') -> where('uid',$val['uid']) -> where("state = 2 or state = 3 or state = 5") -> select() -> toArray();
                    $name = $val['user_nickname'];
                    $avatar = $val['avatar'];
                    $cumulative_money = 0;
                    foreach ($student[$key]['indent'] as $key1 => $val1){
                        $student[$key]['indent'][$key1]['user_name'] = $name;
                        $student[$key]['indent'][$key1]['avatar'] = $avatar;
                        $money_income = Db::name('money_income') -> where("indent_id =".$val1['id']." and uid = ".$uid) -> select() -> toArray();
                        $money = 0;
                        foreach ($money_income as $key2 => $val2){
                            $money += $val2['money'];
                        }
                        $student[$key]['indent'][$key1]['total_money'] = $money;
                        $cumulative_money += $money;
anyv authored
435
                    }
anyv authored
436
                    $student[$key]['cumulative_money'] = $cumulative_money;
anyv authored
437
anyv authored
438 439 440 441 442
                }
            }else{
                $student = null;
            }
            $this -> assign('type',3);
anyv authored
443 444
            $this -> assign('student',$student);
        }elseif ($my_user['status'] == 2){
anyv authored
445 446 447 448 449 450 451 452 453 454 455 456 457 458
            //查找业务员下级老师
            $teacher = Db::name('my_user') -> alias('a') -> field("a.*,b.user_nickname,b.avatar") -> join("user b","a.uid = b.id",'LEFT') -> where("a.pid",$my_user['id']) -> select() -> toArray();
            if(!empty($teacher)){
                foreach ($teacher as $key => $val){
                    $money_income = Db::name('money_income') -> where("uid",$val['uid']) -> select();
                    $total_commission = 0;
                    foreach ($money_income as $key1 => $val1){
                        $total_commission += $val1['money'];
                    }
                    $teacher[$key]['total_commission'] = $total_commission;
                    //查找老师下面的学生
                    $teacher[$key]['student'] = Db::name('my_user') -> alias('a') -> field("a.*,b.user_nickname,b.avatar") -> join("user b","a.uid = b.id",'LEFT') -> where("a.pid",$val['id']) -> select() -> toArray();
                    if(!empty($teacher[$key]['student'])){
                        foreach ($teacher[$key]['student'] as $key2 => $val2){
anyv authored
459 460 461
                            $teacher[$key]['student'][$key2]['indent'] = Db::name('indent') -> where('uid',$val2['uid']) -> where("state = 2 or state = 3 or state = 5") -> select() -> toArray();
                            $student_indent_money = 0;
                            foreach ($teacher[$key]['student'][$key2]['indent'] as $key3 => $val3){
anyv authored
462
                                $student_money_income = Db::name('money_income') -> where("indent_id =".$val3['id']." and uid = ".$val['uid']) -> select() -> toArray();
anyv authored
463 464 465 466 467 468
                                $student_money_income_money = 0;
                                foreach ($student_money_income as $key4 => $val4){
                                    $student_money_income_money += $val4['money'];
                                }
                                $teacher[$key]['student'][$key2]['indent']['student_money_income_money'] = $student_money_income_money;
                                $student_indent_money += $student_money_income_money;
anyv authored
469
                            }
anyv authored
470
                            $teacher[$key]['student'][$key2]['indent_money'] = $student_indent_money;
anyv authored
471 472 473 474 475 476
                        }
                    }
                }
            }else{
                $teacher = null;
            }
anyv authored
477
            $this -> assign('type',2);
anyv authored
478
            $this -> assign('teacher',$teacher);
anyv authored
479 480
        }
        return $this -> fetch();
anyv authored
481
anyv authored
482
    }
5  
anyv authored
483
anyv authored
484 485 486 487 488 489 490
    /**
     * 收入记录
     */
    public function income_record(){

        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
4  
anyv authored
491
        //搜索老师下级学生用户
anyv authored
492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507
        $student = Db::name('my_user') -> alias('a') -> field("a.*,b.user_nickname,b.avatar") -> join("user b","a.uid = b.id",'LEFT') -> where("a.pid",$my_user['id']) -> select() -> toArray();
        foreach ($student as $key => $val){
            $data[$key] = Db::name('indent') -> where('uid',$val['uid']) -> where("state = 2 or state = 3 or state = 5") -> select() -> toArray();
            $name = $val['user_nickname'];
            $avatar = $val['avatar'];
          foreach ($data[$key] as $key1 => $val1){
              $data[$key][$key1]['user_name'] = $name;
              $data[$key][$key1]['avatar'] = $avatar;
                $money_income = Db::name('money_income') -> where("indent_id =".$val1['id']." and uid = ".$uid) -> select() -> toArray();
                $money = 0;
                foreach ($money_income as $key2 => $val2){
                    $money += $val2['money'];
                }
              $data[$key][$key1]['total_money'] = $money;
              $res[] = $data[$key][$key1];
            }
5  
anyv authored
508 509

        }
anyv authored
510 511 512
        if(empty($res)){
            $res = null;
        }
anyv authored
513
        $this -> assign('res',$res);
4  
anyv authored
514 515 516 517 518 519 520 521 522
        //搜索老师用户
        $teacher_avatar = Db::name('user') -> where('id',$uid) -> find();
        $teacher = Db::name('indent') -> where('uid',$uid) -> where("state = 2 or state = 3 or state = 5") -> select() -> toArray();
        foreach($teacher as $key => $val){
            $teacher_data[$key]['user_name'] = $teacher_avatar['user_nickname'];
            $teacher_data[$key]['avatar'] = $teacher_avatar['avatar'];
            $tea_money_income = Db::name('money_income') -> where("indent_id =".$val['id']." and uid = ".$uid) -> select() -> toArray();
            $money = 0;
            foreach ($tea_money_income as $key2 => $val2){
5  
anyv authored
523
                $money += $val2['money'];
4  
anyv authored
524
            }
5  
anyv authored
525 526 527 528
            $teacher_data[$key]['total_money'] = $money;
            $teacher_data[$key]['indent_type'] = $val['indent_type'];
            $teacher_data[$key]['create_time'] = $val['create_time'];
            $my_res[] = $teacher_data[$key];
4  
anyv authored
529
        }
5  
anyv authored
530 531 532 533
        if(empty($my_res)){
            $my_res = null;
        }
        $this -> assign('my_res',$my_res);
anyv authored
534 535 536
        return $this -> fetch();

    }
5  
anyv authored
537
anyv authored
538 539 540
    /**
     * 提现明细
     */
4  
anyv authored
541
    public function withdrawal_subsidiary(){
5  
anyv authored
542
anyv authored
543
        $uid = cmf_get_current_user_id();
4  
anyv authored
544
        $data = Db::name('money_expend') -> where('uid='.$uid) -> where("state = 1 or state = 2")  -> select();
anyv authored
545
        $this -> assign('data',$data);
4  
anyv authored
546 547 548
        return $this -> fetch();

    }
5  
anyv authored
549
anyv authored
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575
    /**
     * 显示商场盈利
     */
    public function mall_profit(){

        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($my_user['status'] == 2){
            $res = $this -> request -> param();
            if(count($res) != 0){
                $where = [
                    'a.indent_type' => 2,
                    'a.salesman_uid' => $uid
                ];
                if($res['grade_class'] != ''){
                    $school_grade_class = explode(' ',$res['grade_class']);
                    $where['a.school'] = $school_grade_class[0];
                    $where['a.grade'] = $school_grade_class[1];
                    $where['a.class'] = $school_grade_class[3];
                }
                if($res['start_time'] != '' && $res['end_time'] != ''){
                    $start_time = strtotime($res['start_time']);
                    $end_time = strtotime($res['end_time']);
                    $where['a.pay_time'] = [['>=',$start_time],['<=',$end_time]];
                }
                $indent_goods = Db::name('indent') -> alias('a') -> field("a.*,b.indent_id,b.book_name,b.pricing,b.price,b.number,b.thumbnail") -> join('indent_goods b','a.id=b.indent_id','LEFT') -> where($where) -> where("a.state =2 or a.state=3 or a.state=5") -> select();
anyv authored
576
                $indent_money = Db::name('indent') -> alias('a') -> field("a.id,b.*") -> join('money_income b','a.id=b.indent_id','LEFT') -> where($where) -> where("a.state =2 or a.state=3 or a.state=5") -> where("b.uid =".$uid) -> select();
anyv authored
577 578
            }else{
                $indent_goods = Db::name('indent') -> alias('a') -> field("a.*,b.indent_id,b.book_name,b.pricing,b.price,b.number,b.thumbnail") -> join('indent_goods b','a.id=b.indent_id','LEFT') -> where('a.indent_type=2 and a.salesman_uid='.$uid) -> where("a.state =2 or a.state=3 or a.state=5") -> select();
anyv authored
579 580
                /*$indent_money = Db::name('indent') -> alias('a') -> field("a.id,b.*") -> join('money_income b','a.id=b.indent_id','LEFT') -> where('a.indent_type=2 and a.salesman_uid='.$uid) -> where("a.state =2 or a.state=3 or a.state=5") -> select();*/
                $indent_money = Db::name('money_income') -> where("uid =".$uid) -> select();
anyv authored
581 582 583 584 585 586
            }

            $total_money = 0;
            foreach ($indent_money as $key => $val){
                $total_money += $val['money'];
            }
5  
anyv authored
587
            $total_money = $total_money-$total_money*0.006;
anyv authored
588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603
            $this -> assign('total_money',$total_money);
            //显示学校年级
            $school = Db::name('school') -> where('uid',$uid) -> select();
            $grade_class = Db::name('grade_class') -> where("school_id",$school[0]['id']) -> select();
            foreach ($grade_class as $key => $val){
                $class = explode('-',$val['class']);
                for($i=$class[0];$i<=$class[1];$i++){
                    $grade_class_show[] = $val['grade'].' - '.$i."班";
                }
            }
            $this -> assign('school',$school);
            $this -> assign('grade_class_show',$grade_class_show);
            //显示平台盈利
            //查询业务员下级所有老师的订单
            $teacher_user = Db::name('my_user') -> where("pid",$my_user['id']) -> select() -> toArray();
            foreach ($teacher_user as $key => $val){
anyv authored
604
                $teacher_indent[$key] = Db::name('indent') -> where("indent_type=1 and uid=".$val['uid']) -> where("state = 2 or state = 3 or state = 5") -> select() -> toArray();
anyv authored
605 606 607 608 609 610 611 612 613 614 615 616 617
                foreach ($teacher_indent[$key] as $key1 => $val1){
                    $money_income = Db::name('money_income') -> where("indent_id=".$val1['id']." and uid=".$my_user['uid']) -> select();
                    foreach ($money_income as $key3 => $val3){
                        $platform_money[] = $val3;
                    }
                }
            }
            //查询老师下学生的订单
            foreach ($teacher_user as $key => $val){
                //查询老师下的所有学生
                $student[$key] = Db::name('my_user') -> where("pid",$val['id']) -> select();
                //查询学生的所有订单
                foreach ($student[$key] as $key1 => $val1){
anyv authored
618
                    $student_indent[$key1] = Db::name('indent') -> where("indent_type=1 and uid=".$val1['uid']) -> where("state = 2 or state = 3 or state = 5") -> select();
anyv authored
619 620 621 622 623 624 625 626 627
                    //查询学生订单下属于业务员的收入记录
                    foreach ($student_indent[$key1] as $key2 => $val2){
                        $student_money_income = Db::name('money_income') -> where("indent_id=".$val2['id']." and uid=".$my_user['uid']) -> select();
                        foreach ($student_money_income as $key3 => $val3){
                            $platform_money[] = $val3;
                        }
                    }
                }
            }
anyv authored
628 629 630
            if(empty($platform_money)){
                $platform_money = null;
            }
anyv authored
631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661
            $this -> assign('platform_money',$platform_money);
         }else{
            $this -> error('非业务员不能进去此页');
        }

        $this -> assign('indent_goods',$indent_goods);
        return $this -> fetch();

    }

    /**
     * 点击学校时获取年级班级
     */
    public function get_grade_class(){

        $school_id = $_POST['id'];
        $grade_class = Db::name('grade_class') -> where("school_id",$school_id) -> select() -> toArray();
        if(!empty($grade_class)){
            foreach ($grade_class as $key => $val){
                $class = explode('-',$val['class']);
                for($i=$class[0];$i<=$class[1];$i++){
                    $grade_class_show[] = $val['grade'].' - '.$i."班";
                }
            }
            return json_encode($grade_class_show);
        }else{
            return false;
        }

    }
anyv authored
662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695
    /**
     * 但图片上传
     */
    public function image_one_up(){

        $file = request()->file('avatar');

        // 移动到框架应用根目录/public/uploads/ 目录下
        if($file){
            $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
            if($info){
                // 成功上传后 获取上传信息
                // 输出 jpg
                $image = $info->getSaveName();
                $this->apiResponse(1,'成功',$image);
                // 输出 20160820/42a79759f284b767dfcb2a0197904287.jpg
            }else{
                // 上传失败获取错误信息
                echo $file->getError();
            }
        }

    }

    public function apiResponse($code = '', $msg = '',$data = array()){
        header('Access-Control-Allow-Origin: *');
        header('Content-Type:application/json; charset=utf-8');
        $result = array(
            'code'=>$code,
            'msg'=>$msg,
            'data'=>$data,
        );
        die(json_encode($result,JSON_UNESCAPED_UNICODE));
    }
anyv authored
696
5  
anyv authored
697 698 699 700 701 702 703 704 705 706 707 708 709 710
    /**
     *判断是否首次提现
     */
    public function id_first_withdrawal(){

        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($my_user['is_withdrawal'] == '1'){
            return true;
        }else{
            return false;
        }

    }
anyv authored
711
5  
anyv authored
712 713 714 715 716 717 718 719 720 721 722 723 724 725 726
    /**
     * 首次提现手机验证码判断
     */
    public function is_money_code(){

        $uid = cmf_get_current_user_id();
        $code = session('code');
        if($code == $_POST['yzm']){
            Db::name('my_user') -> where('uid',$uid) -> update(['is_withdrawal'=>2]);
            return true;
        }else{
            return false;
        }

    }
anyv authored
727 728 729


5  
anyv authored
730 731 732 733 734




7  
anyv authored
735 736 737 738



anyv authored
739 740 741 742



}