function orderList() { $mod = M('Exchange_order'); $where['sid'] = $_REQUEST['sid']; // $where['paytime'] = array('like', '%' . date('Y-m-d') . '%'); $where['uid'] = getwxuserid(); $where['status'] = 2; $data = $mod->where($where)->order('paytime desc')->select(); //echo $mod->getLastSql(); $this->assign('list', $data); $this->display('order'); }
function requestQrcode() { header("Content-type: text/html; charset=utf-8"); $url = I('path.2'); //获取加密参数 $linkurl = explode('&', $url); //echo count($linkurl);exit; if (count($linkurl) > 1) { $value = base64_decode($linkurl[0]); } else { $value = base64_decode($url); } // echo $value;exit; $key = explode('&', $value); $qid = str_replace("?id=", "", $key[0]); $uid = str_replace("uid=", "", $key[1]); $mod = M('Score_qrcode'); $info = $mod->where('id=' . $qid)->find(); //查询二维码基本信息 //echo $value;exit; //echo exp;exit; if ($uid == getwxuserid()) { redirect('/ldh/store.php/Store/qrcode?qid=' . $qid . '&sid=' . $info['sid']); } else { $huiyuaninfo = check_vip(wx_openid()); // print_r($huiyuaninfo);exit; if ($huiyuaninfo) { $vm = D('QrcodeproductView'); $data = $vm->where('Score_qrcode.id=' . $qid)->select(); foreach ($data as $key => $value) { $title .= $value['title'] . ','; $pids .= $value['pid'] . ','; } $order = M('Score_order'); $where['qid'] = $qid; $where['uid'] = $uid; //$where['status'] = 1; $rs = $order->where($where)->find(); //查询订单信息 //print_r($rs); if ($info['status'] == 1) { $arr['sid'] = $info['sid']; $arr['pid'] = rtrim($pids, ','); $arr['uid'] = $uid; $arr['qid'] = $qid; $arr['title'] = rtrim($title, ','); $arr['huiyuanname'] = $huiyuaninfo['huiyuan_name']; $arr['huiyuantel'] = $huiyuaninfo['huiyuan_tel']; $arr['openid'] = $huiyuaninfo['open_id']; $arr['price'] = $data[0]['price']; $arr['score'] = $data[0]['score']; $arr['status'] = 1; $arr['card_no'] = $huiyuaninfo['card_no']; $arr['ctime'] = $this->crtTime(); if (!$rs) { $state = $order->add($arr); $this->assign('status', 1); } else { $this->assign('status', $rs['status']); } } else { if ($rs['openid'] == $huiyuaninfo['open_id']) { $this->assign('info', '已支付'); } else { $this->assign('info', '二维码已失效'); } } $this->assign('score', $data[0]['score']); //赋值积分 $this->assign('sid', $info['sid']); //赋值商户ID $this->assign('uid', $info['uid']); //赋值商户ID $this->assign('qid', $qid); //赋值二维码ID $this->assign('name', $huiyuaninfo['huiyuan_name']); $this->assign('tel', $huiyuaninfo['huiyuan_tel']); $this->assign('img', getWxBaseInfo($huiyuaninfo['open_id'])); $this->getQrproductByQid($qid); //获取二维码订单基本信息 $this->display('index'); } else { $fs['openid'] = wx_openid(); $fsdata = M('Fsopenid')->where($fs)->find(); if ($fsdata) { $redirec_url = 'http://a.forcent.cn/ldh/store.php/PayM/requestQrcode/' . $url; redirect('http://a.forcent.cn/iHuiyuan/user/Integral?url=' . $redirec_url); } else { redirect('http://mp.weixin.qq.com/s?biz=MjM5ODg1MDI2OA==&mid=209800739&idx=1&sn=54b350a36b6655303eadca02c425ddb9#rd'); } } //插入二维码扫描日志 $arr['qid'] = $qid; $arr['ip'] = get_client_ip(); $arr['mobile'] = $_SERVER['HTTP_USER_AGENT']; // $arr['huiyuanname'] = $huiyuaninfo['huiyuan_name']; $arr['openid'] = wx_openid(); // $arr['huiyuantel'] = $huiyuaninfo['huiyuan_tel']; $arr['ctime'] = $this->crtTime(); $qrsan = M('Score_qrscanlog'); $qrsan->add($arr); } }