<?php

namespace app\admin\controller;

use app\api\controller\Pay;
use app\common\controller\Backend;
use think\Db;
use app\nsms\nsms;

/**
 * 苹果用户购买素材订单
 *
 * @icon fa fa-circle-o
 */
class Iphone extends Backend
{
    
    /**
     * Iphone模型对象
     * @var \app\admin\model\Iphone
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\Iphone;

    }
    
    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */
    

    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags']);
        if ($this->request->isAjax())
        {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField'))
            {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $total = $this->model
                    ->with(['pic','video'])
                    ->where($where)
                    ->order($sort, $order)
                    ->count();

            $list = $this->model
                    ->with(['pic','video'])
                    ->where($where)
                    ->order($sort, $order)
                    ->limit($offset, $limit)
                    ->select();

            foreach ($list as $row) {
                $row->getRelation('pic')->visible(['title']);
            }
            $list = collection($list)->toArray();
            foreach ($list as &$v){
                if(!empty($v['video_id'])){
                    $video_id = unserialize($v['video_id']);
                    //获取视频标题
                    $v['video.title'] = Db::name('video')->where('id',$video_id['id'])->value('title');
                }
                $v['user_phone'] = Db::name('user')->where('id',$v['user_id'])->value('mobile');
                $v['user_id'] = Db::name('user')->where('id',$v['user_id'])->value('nickname');
            }
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }

    /**
     * 编辑
     */
    public function edit($ids = null)
    {
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        $adminIds = $this->getDataLimitAdminIds();
        if (is_array($adminIds)) {
            if (!in_array($row[$this->dataLimitField], $adminIds)) {
                $this->error(__('You have no permission'));
            }
        }
        if ($this->request->isPost()) {
            $params = $this->request->post("row/a");
            if ($params) {
                $params = $this->preExcludeFields($params);


                //先查询一遍数据是否已经是支付状态
                $data = Db::name('iphone')->where('id',$ids)->find();

                //查询用户余额
                $user_info = Db::name('user')->where('id',$data['user_id'])->find();


                $result = false;
                Db::startTrans();
                try {
                    //是否采用模型验证
                    if ($this->modelValidate) {
                        $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
                        $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate;
                        $row->validateFailException(true)->validate($validate);
                    }

                    if($user_info['is_vip'] == 1){
                        //未支付状态下才变更用户余额
                        if($data['status'] == 1){
                            if($params['status'] == 2){
                                //判断金额是否充足
                                if($user_info['money'] < $data['total']){
                                    $this->error('您的余额不足,请充值后购买');
                                }else{


                                    //用户购买的什么素材
                                    if(empty($data['video_id'])){
                                        $pic = Db::name('pic')->where('id',$data['pic_id'])->find();

                                        //发送短信，通知客户
                                        $mobile = $user_info['mobile'];
                                        $content = "【仁甲看见SHOP】,感谢您购买仁甲看见SHOP素材。图片标题:$pic[title],云盘地址:$pic[url]";
                                        //发送短信

                                        $this->sms($mobile,$content);

                                    }elseif (empty($data['pic_id'])){
                                        $video_id = unserialize($data['video_id']);
                                        $video = Db::name('video')->where('id',$video_id['id'])->find();
                                        //发送短信，通知客户
                                        $mobile = $user_info['mobile'];
                                        if($video_id['attr'] == 1){
                                            $content = "【仁甲看见SHOP】,感谢您购买仁甲看见SHOP素材。视频标题:$video[title],云盘地址:$video[two_url]";
                                        }elseif ($video_id['attr'] == 2){
                                            $content = "【仁甲看见SHOP】,感谢您购买仁甲看见SHOP素材。视频标题:$video[title],云盘地址:$video[four_url]";
                                        }elseif ($video_id['attr'] == 3){
                                            $content = "【仁甲看见SHOP】,感谢您购买仁甲看见SHOP素材。视频标题:$video[title],云盘地址:$video[eight_url]";
                                        }
                                        //发送短信
                                        $this->sms($mobile,$content);
                                    }
                                    $update = $user_info['money'] - $data['total'];
                                    Db::name('user')->where('id',$user_info['id'])->update(['money'=>$update]);
                                }
                            }
                        }
                    }



                    $result = $row->allowField(true)->save($params);
                    Db::commit();
                } catch (ValidateException $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                } catch (PDOException $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                } catch (Exception $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                }
                if ($result !== false) {
                    $this->success();
                } else {
                    $this->error(__('No rows were updated'));
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $this->view->assign("row", $row);
        return $this->view->fetch();
    }



    //发送短信
    public function sms($mobile,$content){
        $note = array(
            'content' 	=> $content,//短信内容
            'mobile' 	=> $mobile,//手机号码
            'productid' => '676767',//模板id
            'xh'		=> ''//小号
        );
        $result = $this->send_sms($note);
        return $result;
    }
    function send_sms($data){
        //todo 短信账号密码
//        require_once EXTEND_PATH . 'nsms/nsms.php';
        $url 		= "http://www.ztsms.cn/sendNSms.do";
        $username 	= 'hangpai';
        $password 	= 'Cxz307312';
        $sendAPI = new nsms($url, $username, $password);
        $sendAPI->data = $data;/*初始化数据包*/
        $return = $sendAPI->sendSMS('POST');
        return $return;
    }

}