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