第一步:申请微信开放平台帐号并创建第三方平台
第二步:公众号/小程序授权给第三方平台
<?php /* * 微信第三方平台授权流程 */ namespace app\home\controller; class Weixin extends Common { private $appid = 'wx3e******165c'; //第三方平台应用appid private $appsecret = '13e**********d039'; //第三方平台应用appsecret private $token = 'ePF58******Q2Ae'; //第三方平台应用token(消息校验Token) private $encodingAesKey = 'bzH***FCamD'; //第三方平台应用Key(消息加解密Key) private $component_ticket= 'ticket@**xv-g'; //微信后台推送的ticket,用于获取第三方平台接口调用凭据 /* * 扫码授权,注意此URL必须放置在页面当中用户点击进行跳转,不能通过程序跳转,否则将出现“请确认授权入口页所在域名,与授权后回调页所在域名相同....”错误 * @params string $redirect_uri : 扫码成功后的回调地址 * @params int $auth_type : 授权类型,1公众号,2小程序,3公众号/小程序同时展现。不传参数默认都展示 */ public function startAuth($redirect_uri,$auth_type = 3) { $url = "https://mp.weixin.qq.com/cgi-bin/componentloginpage?component_appid=".$this->appid."&pre_auth_code=".$this->get_pre_auth_code()."&redirect_uri=".urlencode($redirect_uri)."&auth_type=".$auth_type; return $url; } /* * 获取第三方平台access_token * 注意,此值应保存,代码这里没保存 */ private function get_component_access_token() { $url = "https://api.weixin.qq.com/cgi-bin/component/api_component_token"; $data = '{ "component_appid":"'.$this->appid.'" , "component_appsecret": "'.$this->appsecret.'", "component_verify_ticket": "'.$this->component_ticket.'" }'; $ret = json_decode($this->https_post($url,$data)); if($ret->errcode == 0) { return $ret->component_access_token; } else { return $ret->errcode; } } /* * 第三方平台方获取预授权码pre_auth_code */ private function get_pre_auth_code() { $url = "https://api.weixin.qq.com/cgi-bin/component/api_create_preauthcode?component_access_token=".$this->get_component_access_token(); $data = '{"component_appid":"'.$this->appid.'"}'; $ret = json_decode($this->https_post($url,$data)); if($ret->errcode == 0) { return $ret->pre_auth_code; } else { return $ret->errcode; } } /* * 发起POST网络提交 * @params string $url : 网络地址 * @params json $data : 发送的json格式数据 */ private function https_post($url,$data) { $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); if (!empty($data)){ curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, $data); } curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $output = curl_exec($curl); curl_close($curl); return $output; } /* * 发起GET网络提交 * @params string $url : 网络地址 */ private function https_get($url) { $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, FALSE); curl_setopt($curl, CURLOPT_HEADER, FALSE) ; curl_setopt($curl, CURLOPT_TIMEOUT,60); if (curl_errno($curl)) { return 'Errno'.curl_error($curl); } else{$result=curl_exec($curl);} curl_close($curl); return $result; } }
<?php /* * 接收微信官方推送的ticket值以及取消授权等操作 */ namespace app\home\controller; use think\Db; class Openoauth extends Common { private $appid = 'wx3e******165c'; //第三方平台应用appid private $appsecret = '13e**********d039'; //第三方平台应用appsecret private $token = 'ePF58******Q2Ae'; //第三方平台应用token(消息校验Token) private $encodingAesKey = 'bzH***FCamD'; //第三方平台应用Key(消息加解密Key) private $component_ticket= 'ticket@**xv-g'; //微信后台推送的ticket,用于获取第三方平台接口调用凭据 /* * 接收微信官方推送的消息(每10分钟1次) * 这里需要引入微信官方提供的加解密码示例包 * 官方文档:https://open.weixin.qq.com/cgi-bin/showdocument?action=dir_list&t=resource/res_list&verify=1&id=open1419318479&token=&lang=zh_CN * 示例包下载:https://wximg.gtimg.com/shake_tv/mpwiki/cryptoDemo.zip */ public function index() { $encryptMsg = file_get_contents("php://input"); $xml_tree = new \DOMDocument(); $xml_tree->loadXML($encryptMsg); $xml_array = $xml_tree->getElementsByTagName("Encrypt"); $encrypt = $xml_array->item(0)->nodeValue; require_once('wxBizMsgCrypt.php'); $Prpcrypt = new \Prpcrypt($this->encodingAesKey); $postData = $Prpcrypt->decrypt($encrypt, $this->appid); if ($postData[0] != 0) { return $postData[0]; } else { $msg = $postData[1]; $xml = new \DOMDocument(); $xml->loadXML($msg); $array_a = $xml->getElementsByTagName("InfoType"); $infoType = $array_a->item(0)->nodeValue; if ($infoType == "unauthorized") { //取消公众号/小程序授权 $array_b = $xml->getElementsByTagName("AuthorizerAppid"); $AuthorizerAppid = $array_b->item(0)->nodeValue; //公众号/小程序appid $where = array("type" => 1, "appid" => $AuthorizerAppid); $save = array("authorizer_access_token" => "", "authorizer_refresh_token" => "", "authorizer_expires" => 0); Db::name("wxuser")->where($where)->update($save); //公众号取消授权 Db::name("wxminiprograms")->where('authorizer_appid',$AuthorizerAppid)->update($save); //小程序取消授权 } else if ($infoType == "component_verify_ticket") { //微信官方推送的ticket值 $array_e = $xml->getElementsByTagName("ComponentVerifyTicket"); $component_verify_ticket = $array_e->item(0)->nodeValue; if (Db::name("weixin_account")->where(array("type" => 1))->update(array("component_verify_ticket" => $component_verify_ticket, "date_time" => time()))) { $this->updateAccessToken($component_verify_ticket); echo "success"; } } } } /* * 更新component_access_token * @params string $component_verify_ticket * */ private function updateAccessToken($component_verify_ticket) { $weixin_account = Db::name('weixin_account')->where(['type'=>1])->field('id,appId,appSecret,component_access_token,token_expires')->find(); if($weixin_account['token_expires'] <= time() ) { $apiUrl = 'https://api.weixin.qq.com/cgi-bin/component/api_component_token'; $data = '{"component_appid":"'.$weixin_account['appId'].'" ,"component_appsecret": "'.$weixin_account['appSecret'].'","component_verify_ticket": "'.$component_verify_ticket.'"}'; $json = json_decode(_request($apiUrl,$data)); if(isset($json->component_access_token)) { Db::name('weixin_account')->where(['id'=>$weixin_account['id']])->update(['component_access_token'=>$json->component_access_token,'token_expires'=>time()+7200]); } } } }
<?php /* * 代小程序实现业务 */ namespace app\home\model; use think\Model; use think\Db; use think\Cache; class Miniprogram extends Model { private $thirdAppId; //开放平台appid private $encodingAesKey; //开放平台encodingAesKey private $thirdToken; //开放平台token private $thirdAccessToken; //开放平台access_token private $authorizer_appid; private $authorizer_access_token; private $authorizer_refresh_token; public function __construct($appid) { $weixin_account = Db::name('weixin_account')->where(['type' => 1])->field('token,encodingAesKey,appId,component_access_token')->find(); if ($weixin_account) { $this->thirdAppId = $weixin_account['appId']; $this->encodingAesKey = $weixin_account['encodingAesKey']; $this->thirdToken = $weixin_account['token']; $this->thirdAccessToken = $weixin_account['component_access_token']; $miniprogram = Db::name('wxminiprograms')->where('authorizer_appid',$appid) ->field('authorizer_access_token,authorizer_refresh_token,authorizer_expires')->find(); if($miniprogram){ $this->authorizer_appid = $appid; if(time() > $miniprogram['authorizer_expires']){ $miniapp = $this->update_authorizer_access_token($appid,$miniprogram['authorizer_refresh_token']); if($miniapp) { $this->authorizer_access_token = $miniapp->authorizer_access_token; $this->authorizer_refresh_token = $miniapp->authorizer_refresh_token; } else { $this->errorLog("更新小程序access_token失败,appid:".$this->authorizer_appid,''); exit; } } else { $this->authorizer_access_token = $miniprogram['authorizer_access_token']; $this->authorizer_refresh_token = $miniprogram['authorizer_refresh_token']; } } else { $this->errorLog("小程序不存在,appid:".$this->authorizer_appid,''); exit; } } else { $this->errorLog("请增加微信第三方公众号平台账户信息",''); exit; } } /* * 设置小程序服务器地址,无需加https前缀,但域名必须可以通过https访问 * @params string / array $domains : 域名地址。只接收一维数组。 * */ public function setServerDomain($domain = 'test.moh.cc') { $url = "https://api.weixin.qq.com/wxa/modify_domain?access_token=".$this->authorizer_access_token; if(is_array($domain)) { $https = ''; $wss = ''; foreach ($domain as $key => $value) { $https .= '"https://'.$value.'",'; $wss .= '"wss://'.$value.'",'; } $https = rtrim($https,','); $wss = rtrim($wss,','); $data = '{ "action":"add", "requestdomain":['.$https.'], "wsrequestdomain":['.$wss.'], "uploaddomain":['.$https.'], "downloaddomain":['.$https.'] }'; } else { $data = '{ "action":"add", "requestdomain":"https://'.$domain.'", "wsrequestdomain":"wss://'.$domain.'", "uploaddomain":"https://'.$domain.'", "downloaddomain":"https://'.$domain.'" }'; } $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("设置小程序服务器地址失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 设置小程序业务域名,无需加https前缀,但域名必须可以通过https访问 * @params string / array $domains : 域名地址。只接收一维数组。 * */ public function setBusinessDomain($domain = 'test.moh.cc') { $url = "https://api.weixin.qq.com/wxa/setwebviewdomain?access_token=".$this->authorizer_access_token; if(is_array($domain)) { $https = ''; foreach ($domain as $key => $value) { $https .= '"https://'.$value.'",'; } $https = rtrim($https,','); $data = '{ "action":"add", "webviewdomain":['.$https.'] }'; } else { $data = '{ "action":"add", "webviewdomain":"https://'.$domain.'" }'; } $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("设置小程序业务域名失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 成员管理,绑定小程序体验者 * @params string $wechatid : 体验者的微信号 * */ public function bindMember($wechatid) { $url = "https://api.weixin.qq.com/wxa/bind_tester?access_token=".$this->authorizer_access_token; $data = '{"wechatid":"'.$wechatid.'"}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("绑定小程序体验者操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 成员管理,解绑定小程序体验者 * @params string $wechatid : 体验者的微信号 * */ public function unBindMember($wechatid) { $url = "https://api.weixin.qq.com/wxa/unbind_tester?access_token=".$this->authorizer_access_token; $data = '{"wechatid":"'.$wechatid.'"}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("解绑定小程序体验者操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 成员管理,获取小程序体验者列表 * */ public function listMember() { $url = "https://api.weixin.qq.com/wxa/memberauth?access_token=".$this->authorizer_access_token; $data = '{"action":"get_experiencer"}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return $ret->members; } else { $this->errorLog("获取小程序体验者列表操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 为授权的小程序帐号上传小程序代码 * @params int $template_id : 模板ID * @params json $ext_json : 小程序配置文件,json格式 * @params string $user_version : 代码版本号 * @params string $user_desc : 代码描述 * */ public function uploadCode($template_id = 1, $user_version = 'v1.0.0', $user_desc = "魔盒CMS小程序模板库") { $ext_json = json_encode('{"extEnable": true,"extAppid": "wx572****bfb","ext":{"appid": "'.$this->authorizer_appid.'"}}'); $url = "https://api.weixin.qq.com/wxa/commit?access_token=".$this->authorizer_access_token; $data = '{"template_id":"'.$template_id.'","ext_json":'.$ext_json.',"user_version":"'.$user_version.'","user_desc":"'.$user_desc.'"}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("为授权的小程序帐号上传小程序代码操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 获取体验小程序的体验二维码 * @params string $path : 指定体验版二维码跳转到某个具体页面 * */ public function getExpVersion($path = '') { if($path){ $url = "https://api.weixin.qq.com/wxa/get_qrcode?access_token=".$this->authorizer_access_token."&path=".urlencode($path); } else { $url = "https://api.weixin.qq.com/wxa/get_qrcode?access_token=".$this->authorizer_access_token; } $ret = json_decode(https_get($url)); if($ret->errcode) { $this->errorLog("获取体验小程序的体验二维码操作失败,appid:".$this->authorizer_appid,$ret); return false; } else { return $url; } } /* * 提交审核 * @params string $tag : 小程序标签,多个标签以空格分开 * @params strint $title : 小程序页面标题,长度不超过32 * */ public function submitReview($tag = "魔盒CMS 微信投票 微网站 微信商城" ,$title = "魔盒CMS微信公众号营销小程序开发") { $first_class = '';$second_class = '';$first_id = 0;$second_id = 0; $address = "pages/index/index"; $category = $this->getCategory(); if(!empty($category)) { $first_class = $category[0]->first_class ? $category[0]->first_class : '' ; $second_class = $category[0]->second_class ? $category[0]->second_class : ''; $first_id = $category[0]->first_id ? $category[0]->first_id : 0; $second_id = $category[0]->second_id ? $category[0]->second_id : 0; } $getpage = $this->getPage(); if(!empty($getpage) && isset($getpage[0])) { $address = $getpage[0]; } $url = "https://api.weixin.qq.com/wxa/submit_audit?access_token=".$this->authorizer_access_token; $data = '{ "item_list":[{ "address":"'.$address.'", "tag":"'.$tag.'", "title":"'.$title.'", "first_class":"'.$first_class.'", "second_class":"'.$second_class.'", "first_id":"'.$first_id.'", "second_id":"'.$second_id.'" }] }'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { Db::name('wxminiprogram_audit')->insert([ 'appid'=>$this->authorizer_appid, 'auditid'=>$ret->auditid, 'create_time'=>date('Y-m-d H:i:s') ]); return true; } else { $this->errorLog("小程序提交审核操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 小程序审核撤回 * 单个帐号每天审核撤回次数最多不超过1次,一个月不超过10次。 * */ public function unDoCodeAudit() { $url = "https://api.weixin.qq.com/wxa/undocodeaudit?access_token=".$this->authorizer_access_token; $ret = json_decode(https_get($url)); if($ret->errcode == 0) { return true; } else { $this->errorLog("小程序审核撤回操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 查询指定版本的审核状态 * @params string $auditid : 提交审核时获得的审核id * */ public function getAuditStatus($auditid) { $url = "https://api.weixin.qq.com/wxa/get_auditstatus?access_token=".$this->authorizer_access_token; $data = '{"auditid":"'.$auditid.'"}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { $reason = $ret->reason ? $ret->reason : ''; Db::name('wxminiprogram_audit')->where(['appid'=>$this->authorizer_appid,'auditid'=>$auditid])->update([ 'status'=>$ret->status, 'reason'=>$reason ]); return true; } else { $this->errorLog("查询指定版本的审核状态操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 查询最新一次提交的审核状态 * */ public function getLastAudit() { $url = "https://api.weixin.qq.com/wxa/get_latest_auditstatus?access_token=".$this->authorizer_access_token; $ret = json_decode(https_get($url)); if($ret->errcode == 0) { $reason = $ret->reason ? $ret->reason : ''; Db::name('wxminiprogram_audit')->where(['appid'=>$this->authorizer_appid,'auditid'=>$ret->auditid])->update([ 'status'=>$ret->status, 'reason'=>$reason ]); return $ret->auditid; } else { $this->errorLog("查询最新一次提交的审核状态操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 发布已通过审核的小程序 * */ public function release() { $url = "https://api.weixin.qq.com/wxa/release?access_token=".$this->authorizer_access_token; $data = '{}'; $ret = json_decode(https_post($url,$data)); if($ret->errcode == 0) { return true; } else { $this->errorLog("发布已通过审核的小程序操作失败,appid:".$this->authorizer_appid,$ret); return $ret->errcode; } } /* * 获取授权小程序帐号的可选类目 * */ private function getCategory() { $url = "https://api.weixin.qq.com/wxa/get_category?access_token=".$this->authorizer_access_token; $ret = json_decode(https_get($url)); if($ret->errcode == 0) { return $ret->category_list; } else { $this->errorLog("获取授权小程序帐号的可选类目操作失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 获取小程序的第三方提交代码的页面配置 * */ private function getPage() { $url = "https://api.weixin.qq.com/wxa/get_page?access_token=".$this->authorizer_access_token; $ret = json_decode(https_get($url)); if($ret->errcode == 0) { return $ret->page_list; } else { $this->errorLog("获取小程序的第三方提交代码的页面配置失败,appid:".$this->authorizer_appid,$ret); return false; } } /* * 更新授权小程序的authorizer_access_token * @params string $appid : 小程序appid * @params string $refresh_token : 小程序authorizer_refresh_token * */ private function update_authorizer_access_token($appid,$refresh_token) { $url = 'https://api.weixin.qq.com/cgi-bin/component/api_authorizer_token?component_access_token=' . $this->thirdAccessToken; $data = '{"component_appid":"' . $this->thirdAppId . '","authorizer_appid":"' . $appid . '","authorizer_refresh_token":"' . $refresh_token . '"}'; $ret = json_decode(https_post($url, $data)); if (isset($ret->authorizer_access_token)) { Db::name('wxminiprograms')->where(['authorizer_appid' => $appid])->update(['authorizer_access_token' => $ret->authorizer_access_token, 'authorizer_expires' => (time() + 7200), 'authorizer_refresh_token' => $ret->authorizer_refresh_token]); return $ret; } else { $this->errorLog("更新授权小程序的authorizer_access_token操作失败,appid:".$appid,$ret); return null; } } private function errorLog($msg,$ret) { file_put_contents(ROOT_PATH . 'runtime/error/miniprogram.log', "[" . date('Y-m-d H:i:s') . "] ".$msg."," .json_encode($ret).PHP_EOL, FILE_APPEND); } }<?php //代小程序实现业务示例包 namespace app\user\controller; use app\home\model\Miniprogram; use think\Db; class Wxminiprogram extends Pub { public $appid = 'wx57****1bfb'; //需要实现业务小程序appid public function index() { return view(); } public function doAction() { if(request()->isPost()) { $action = input('action'); $mini = new Miniprogram($this->appid); if($action == 'auth') { //小程序授权 echo '<script>alert("已授权");history.back();</script>'; } elseif($action == 'setServerDomain') { //设置小程序服务器域名地址 if($mini->setServerDomain()){ echo '<script>alert("设置小程序服务器域名操作成功");history.back();</script>'; } else { echo '<script>alert("设置小程序服务器域名操作失败或已设置,请查看日志");history.back();</script>'; } } elseif($action == 'setBusinessDomain') { //设置业务域名 if($mini->setBusinessDomain()){ echo '<script>alert("设置小程序业务域名操作成功");history.back();</script>'; } else { echo '<script>alert("设置小程序业务域名操作失败或已设置,请查看日志");history.back();</script>'; } } elseif($action == 'bind') { //绑定小程序体验者 $wechatid = input('wechatid'); if($wechatid) { if($mini->bindMember($wechatid)){ echo '<script>alert("绑定小程序体验者操作成功");history.back();</script>'; } else { echo '<script>alert("绑定小程序体验者操作失败,请查看日志");history.back();</script>'; } } else { echo '<script>alert("请输入微信号");history.back();</script>'; } } elseif($action == 'uploadCode') { //上传小程序代码 if($mini->uploadCode(2)){ echo '<script>alert("上传小程序代码操作成功");history.back();</script>'; } else { echo '<script>alert("上传小程序代码操作失败,请查看日志");history.back();</script>'; } } elseif($action == 'getExpVersion') { //获取体验小程序的体验二维码 $qrcode = $mini->getExpVersion(); if($qrcode){ echo '<script>window.location.href="'.$qrcode.'";</script>'; } else { echo '<script>alert("获取体验小程序的体验二维码操作失败");history.back();</script>'; } } elseif($action == 'review') { //提交审核 $auditid = Db::name('wxminiprogram_audit')->where(['appid'=>$this->appid,'status'=>['neq',0]])->order('create_time','desc')->value('auditid'); if($auditid){ echo '<script>alert("有待处理的版本,请先处理该版本相关事项再提交新的审核。审核ID:'.$auditid.'");history.back();</script>'; } else { if($mini->submitReview()){ echo '<script>alert("小程序提交审核操作成功");history.back();</script>'; } else { echo '<script>alert("小程序提交审核操作失败,请查看日志");history.back();</script>'; } } } elseif($action == 'getAudit') { //查询指定版本的审核状态 $auditid = input('auditid'); if($auditid) { if($mini->getAuditStatus($auditid)){ $audit = Db::name('wxminiprogram_audit')->where(['appid'=>$this->appid,'auditid'=>$auditid])->field('status,reason')->find(); if($audit['status'] == 0) { echo '<script>alert("该版本审核已通过");history.back();</script>'; } elseif($audit['status'] == 1) { echo '<script>alert("该版本审核失败,原因:'.$audit['reason'].'");history.back();</script>'; } elseif($audit['status'] == 2) { echo '<script>alert("该版本小程序正在审核中......");history.back();</script>'; } else { echo '<script>alert("未知状态......");history.back();</script>'; } } else { echo '<script>alert("查询指定版本的审核状态操作失败,请查看日志");history.back();</script>'; } } else { echo '<script>alert("请输入要查询的审核ID");history.back();</script>'; } } elseif($action == 'lastAudit') { //查询最新一次提交的审核状态 $auditid = $mini->getLastAudit(); if($auditid){ $audit = Db::name('wxminiprogram_audit')->where(['appid'=>$this->appid,'auditid'=>$auditid])->field('status,reason')->find(); if($audit['status'] == 0) { echo '<script>alert("审核已通过");history.back();</script>'; } elseif($audit['status'] == 1) { echo '<script>alert("审核失败,原因:'.$audit['reason'].'");history.back();</script>'; } elseif($audit['status'] == 2) { echo '<script>alert("小程序正在审核中......");history.back();</script>'; } else { echo '<script>alert("未知状态......");history.back();</script>'; } }else { echo '<script>alert("查询最新一次提交的审核状态操作失败,请查看日志");history.back();</script>'; } } elseif($action == 'release') { //发布已通过审核的小程序 $auditid = Db::name('wxminiprogram_audit')->where(['appid'=>$this->appid,'status'=>['neq',0]])->order('create_time','desc')->value('auditid'); if($auditid){ echo '<script>alert("有待处理的版本,请先处理该版本相关事项再发布版本。审核ID:'.$auditid.'");history.back();</script>'; } else { $errcode = $mini->release(); if($errcode){ echo '<script>alert("已发版");history.back();</script>'; } else { echo '<script>alert("发版失败,错误代码:'.$errcode.'");history.back();</script>'; } } } } } }wxminiprograms数据表,保存已授权小程序的基本信息及授权相关信息(authorizer_access_token/authorizer_refresh_token)这两个值很重要,代小程序实现业务基本上是通过这两个值来实现
-- Adminer 4.6.2 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `wxminiprograms`; CREATE TABLE `wxminiprograms` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `uid` int(10) unsigned NOT NULL COMMENT '用户ID', `nick_name` varchar(45) DEFAULT NULL COMMENT '微信小程序名称', `alias` varchar(45) DEFAULT NULL COMMENT '别名', `token` varchar(45) DEFAULT NULL COMMENT '平台生成的token值', `head_img` varchar(255) DEFAULT NULL COMMENT '微信小程序头像', `verify_type_info` tinyint(1) DEFAULT NULL COMMENT '授权方认证类型,-1代表未认证,0代表微信认证', `is_show` tinyint(1) DEFAULT '0' COMMENT '是否显示,0显示,1隐藏', `user_name` varchar(45) DEFAULT NULL COMMENT '原始ID', `qrcode_url` varchar(255) DEFAULT NULL COMMENT '二维码图片的URL', `business_info` varchar(255) DEFAULT NULL COMMENT 'json格式。用以了解以下功能的开通状况(0代表未开通,1代表已开通): open_store:是否开通微信门店功能 open_scan:是否开通微信扫商品功能 open_pay:是否开通微信支付功能 open_card:是否开通微信卡券功能 open_shake:是否开通微信摇一摇功能', `idc` int(10) unsigned DEFAULT NULL COMMENT 'idc', `principal_name` varchar(45) DEFAULT NULL COMMENT '小程序的主体名称', `signature` varchar(255) DEFAULT NULL COMMENT '帐号介绍', `miniprograminfo` varchar(255) DEFAULT NULL COMMENT 'json格式。判断是否为小程序类型授权,包含network小程序已设置的各个服务器域名', `func_info` longtext COMMENT 'json格式。权限集列表,ID为17到19时分别代表: 17.帐号管理权限 18.开发管理权限 19.客服消息管理权限 请注意: 1)该字段的返回不会考虑小程序是否具备该权限集的权限(因为可能部分具备)。', `authorizer_appid` varchar(45) DEFAULT NULL COMMENT '小程序appid', `authorizer_access_token` varchar(255) DEFAULT NULL COMMENT '授权方接口调用凭据(在授权的公众号或小程序具备API权限时,才有此返回值),也简称为令牌', `authorizer_expires` int(10) unsigned DEFAULT NULL COMMENT 'refresh有效期', `authorizer_refresh_token` varchar(255) DEFAULT NULL COMMENT '接口调用凭据刷新令牌', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '授权时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信小程序授权列表'; -- 2018-07-25 09:32:49wxminiprogram_audit数据表,保存提交审核的小程序
-- Adminer 4.6.2 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `wxminiprogram_audit`; CREATE TABLE `wxminiprogram_audit` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `appid` varchar(45) NOT NULL COMMENT '小程序appid', `auditid` varchar(45) NOT NULL COMMENT '审核编号', `status` tinyint(1) unsigned NOT NULL DEFAULT '3' COMMENT '审核状态,其中0为审核成功,1为审核失败,2为审核中,3已提交审核', `reason` varchar(255) DEFAULT NULL COMMENT '当status=1,审核被拒绝时,返回的拒绝原因', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '提交审核时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信小程序提交审核的小程序'; -- 2018-07-25 09:35:07x
相关推荐:
以上就是终于整理出来了,用微信第三方平台授权小程序业务的详细内容,更多请关注php中文网其它相关文章!
微信提供公众平台、朋友圈、消息推送等功能,用户可以通过“摇一摇”、“搜索号码”、“附近的人”、扫二维码方式添加好友和关注公众平台,同时微信将内容分享给好友以及将用户看到的精彩内容分享到微信朋友圈。
……