<?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;

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();
    }

}

class PersonalcenterController extends WeChatBaseController{

    /**
     * 显示个人中心页
     */
    public function personal_center(){

        $uid = cmf_get_current_user_id();
        $my_user_status = Db::name('my_user') -> where('uid',$uid) -> find();
        $weixin = Db::name('user') -> where('id',$uid) -> find();
        $this -> assign('weixin',$weixin);
        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){
            if($my_user_status['status'] == 0){
                $this -> assign('status',0);
            }
            if($my_user_status['status'] == 1 || $my_user_status['status'] == 5 || $my_user_status['status'] == 6){
                $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();
        }
        //业务员个人中心页
        if($my_user_status['status'] == 2){
            $this -> assign('weixin',$weixin);
            return $this -> fetch('personalcenter/salesman_center');
        }

    }

    /**
     * 完善个人信息页
     */
    public function perfect_information(){

        $uid = cmf_get_current_user_id();
        $my_user_status = Db::name('my_user') -> where('uid',$uid) -> find();
        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();
        }

    }


    /**
     * 我的收藏页
     */
    public function personal_collect(){

        $uid = cmf_get_current_user_id();
        $data = Db::name('collect') -> where("uid =".$uid) -> select() -> toArray();
        $data_count = count($data);
        if(!empty($data)){
            foreach($data as $key => $val){
                $data_goods[] = Db::name('goods') -> where("id =".$val['goods_id']) -> find();
            }
            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];
            }
        }else{
            $data_goods = '';
        }
        $this -> assign('data_count',$data_count);
        $this -> assign('data_goods',$data_goods);
        return $this -> fetch();

    }

    /**
     * 填写个人信息页
     */
    public function add_information(){

        return $this -> fetch();

    }

    /**
     * 浏览记录
     */
    public function browsing_history(){

        $uid = cmf_get_current_user_id();
        $data = Db::name('browsing_history') -> where("uid =".$uid) -> select();
        foreach($data as $key => $val){
            $data_goods[] = Db::name('goods') -> where('id',$val['goods_id']) -> find();
        }
        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];
            }
        }else{
            $data_goods = '';
        }
        $this -> assign('data_goods',$data_goods);
        return $this -> fetch();

    }

    /**
     * 收货地址页
     */
    public function shop_address(){

        $uid = cmf_get_current_user_id();
        $data = Db::name('address') -> where("delete_time = 0 and uid =".$uid) ->  select() -> toArray();
        if(!empty($data)){
            foreach($data as $key => $val){
                $detailed = explode(',',$val['detailed']);
                $data[$key]['detailed'] = $detailed[0].$detailed[1];
            }
        }
        $this -> assign('data',$data);
        return $this -> fetch();

    }

    /**
     * 新增地址页
     */
    public function add_shop_address(){

        if($this -> request -> isPost()){
            $uid = cmf_get_current_user_id();
            $_POST['uid'] = $uid;
            $add = Db::name('address') -> insert($_POST);
            if($add){
               return true;
            }else{
                return false;
            }
        }else{
            return $this -> fetch();
        }

    }

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

        $uid = cmf_get_current_user_id();
        Db::name('address') -> where('uid',$uid) -> update(['default_address'=>0]);
        $data = Db::name('address') -> where('id',$_POST['id']) -> update(['default_address'=>1]);
        if($data){
            return true;
        }else{
            return false;
        }

    }

    /**
     * 删除地址
     */
    public function address_del(){

        $delete_time = time();
        $data = Db::name('address') -> where('id',$_POST['id']) ->  update(['delete_time'=>$delete_time]);
        if($data){
            return true;
        }else{
            return false;
        }

    }

    /**
     * 编辑地址
     */
    public function address_edit(){

        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();
            $detailed = explode(',',$data['detailed']);
            $data['detailed0'] = $detailed[0];
            $data['detailed1'] = $detailed[1];
            $this -> assign('data',$data);
            return $this -> fetch();
        }

    }

    /**
     * 发送短信
     */
    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)];
        }
        session('code',$key);
        $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;
        }

    }

    /**
     * 添加审核信息
     */
    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){
                Db::name('my_user') -> where('uid',$data['uid']) -> update(['status'=>5]);
                return 1;
            }else{
               return 2;
            }
        }else{
            return 3;
        }

    }

    /**
     * 我的钱包页
     */
    public function my_wallet(){

        $uid = cmf_get_current_user_id();
        $balance = Db::name('my_user') -> where("uid",$uid) -> find();
        $balance['balance'] = $balance['balance'] - $balance['balance']*0.006;
        $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;
        $money_ratio = Db::name('money_ratio') -> where('id',1) -> find();
        $this -> assign('money_ratio',$money_ratio);
        $this -> assign('balance',$balance['balance']);
        $this -> assign('cumulative_money',$cumulative_money);
        $money_expend = Db::name('money_expend') -> where('uid='.$uid." and state=0") -> select();
        $money = 0;
        foreach ($money_expend as $key => $val){
            $money += $val['money'];
        }
        $money = $money-$money*0.006;
        $this -> assign('status',$balance['status']);
        $this -> assign('money',$money);
        return $this -> fetch();

    }

    /**
     * 将提现金额存入支出明细表
     */
    public function add_money_expend(){

        $_POST['uid'] = cmf_get_current_user_id();
        $_POST['create_time'] = time();
        $_POST['state'] = 0;
        $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'];
        }
        $user_balance['balance'] = $user_balance['balance']-$user_balance['balance']*0.006;
        if($money_expend > $user_balance['balance'] ){
            return false;
        }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;
            }
        }

    }

    /**
     * 邀请名单
     */
    public function invitation_list(){

        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        if($my_user['status'] == 3){
            $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();
            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;
                    }
                    $student[$key]['cumulative_money'] = $cumulative_money;

                }
            }else{
                $student = null;
            }
            $this -> assign('type',3);
            $this -> assign('student',$student);
        }elseif ($my_user['status'] == 2){
            //查找业务员下级老师
            $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){
                            $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){
                                $student_money_income = Db::name('money_income') -> where("indent_id =".$val3['id']." and uid = ".$val['uid']) -> select() -> toArray();
                                $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;
                            }
                            $teacher[$key]['student'][$key2]['indent_money'] = $student_indent_money;
                        }
                    }
                }
            }else{
                $teacher = null;
            }
            $this -> assign('type',2);
            $this -> assign('teacher',$teacher);
        }
        return $this -> fetch();

    }

    /**
     * 收入记录
     */
    public function income_record(){

        $uid = cmf_get_current_user_id();
        $my_user = Db::name('my_user') -> where('uid',$uid) -> find();
        $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];
            }

        }
        if(empty($res)){
            $res = null;
        }
        $this -> assign('res',$res);

        return $this -> fetch();

    }

    /**
     * 提现明细
     */
    public function withdrawal_subsidiary(){

        $uid = cmf_get_current_user_id();
        $data = Db::name('money_expend') -> where('uid='.$uid) -> where("state = 1")  -> select();
        $this -> assign('data',$data);
        return $this -> fetch();

    }

    /**
     * 显示商场盈利
     */
    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();
                $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();
            }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();
                /*$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();
            }

            $total_money = 0;
            foreach ($indent_money as $key => $val){
                $total_money += $val['money'];
            }
            $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){
                $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();
                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){
                    $student_indent[$key1] = Db::name('indent') -> where("indent_type=1 and uid=".$val1['uid']) -> where("state = 2 or state = 3 or state = 5") -> select();
                    //查询学生订单下属于业务员的收入记录
                    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;
                        }
                    }
                }
            }
            if(empty($platform_money)){
                $platform_money = null;
            }
            $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;
        }

    }

    /**
     * 但图片上传
     */
    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));
    }

















}