<?php
/**
 * Created by PhpStorm.
 * User: Kevin
 * Date: 2018/10/7
 * Time: 10:49
 */
namespace app\admin\controller;
use think\Db;
class Money extends Base
{
    public function tixianAgreeShopOrWork($number,$money,$phone,$name,$remark='')
//    public function tixianAgreeShopOrWork()
    {
        header("Content-type:text/html;charset=UTF-8");
//        $number='444555661313131316';
//        $money='0.1';
//        $phone='15895980214';
//        $name='麻威我';
//        $remark = '';
        import('alipay.aop.AopClient',EXTEND_PATH);
        import('alipay.aop.request.AlipayFundTransToaccountTransferRequest',EXTEND_PATH);
        $aop = new \AopClient;
        $aop->gatewayUrl = 'https://openapi.alipay.com/gateway.do';
        $aop->appId = '2018090761306686';
        $aop->rsaPrivateKey = '/o35qU8Sy9f0YSeOq4JRMast8tyj7hqI5ZEb4LCHioFpK76qmUHrsgAXO48NeQ0AZPsNA7jqYVEPHemcpk+Qzva0VkinUhSb+Hvqeam314lQpg0ctpJf73yjIy9ScxCFxNnoDLybWnbptazW3OwhKNdyVQ675kp/GXVU=';
        $aop->alipayrsaPublicKey = 'dL62kXB6WVvc1Tk2jSFg1yO7ljvsbZuFq+b24VyOR6h8cXyUBpeoptlmpVk/Q3rbDltuE+PinOXgVQVKkjKBrKx9j1tl8MZrMOsCEgxYNNmi0ycJqfa3NSPunYsocld/xo39OVAZ7ophZi3dwpBIHOmqHbI+6hf90H/FHcMhERL5OnURX/t+GX4+LOl1/R0U6uQIDAQAB';
        $aop->apiVersion = '1.0';
        $aop->signType = 'RSA2';
        $aop->postCharset='UTF-8';
        $aop->format='json';
        $request = new \AlipayFundTransToaccountTransferRequest;
        $request->setBizContent("{" .
            "\"out_biz_no\":\"".$number."\"," .
            "\"payee_type\":\"ALIPAY_LOGONID\"," .
            "\"payee_account\":\"".$phone."\"," .
            "\"amount\":\"".$money."\"," .
            "\"payer_show_name\":\"红集提现到账\"," .
            "\"payee_real_name\":\"".$name."\"," .
            "\"remark\":\"".$remark."\"" .
            "}");
        $result = $aop->execute($request);
        $responseNode = str_replace(".", "_", $request->getApiMethodName()) . "_response";
        $resultCode = $result->$responseNode->code;
        if(!empty($resultCode)&&$resultCode == 10000){
            $result = array();
            $result['status'] = 200;
            $result['msg'] = 'OK';
            return $result;
        } else {
            $result = array();
            $result['status'] = 0;
            $result['msg'] = $result->alipay_fund_trans_toaccount_transfer_response->sub_msg;
            return $result;
        }
    }
    public function chaxunTixianRes($number)
    {
        header("Content-type:text/html;charset=UTF-8");
        import('alipay.aop.AopClient',EXTEND_PATH);
        import('alipay.aop.request.AlipayFundTransOrderQueryRequest',EXTEND_PATH);
        $aop = new \AopClient;
        $aop->gatewayUrl = 'https://openapi.alipay.com/gateway.do';
        $aop->appId = '2018090761306686';
        $aop->rsaPrivateKey = 'MIIEpQIBAAKCAQEA2b4GAsKv3MXAgKvPAVHJeT0MZ+XX5Ke55q74ecV/Wy9NN7wmJBUEVqf/jZEaCtxEhNUNjz74XyoTN/xvYeZ2sjtMSmCzjAuvUUM5GlAMvwg+UpIWC95J1Sz3eLOfzciPUhcd2A4yCEHXjjlgOfWB25U8HBYr8kddfHGm5sKC3IiGM88GLu4CM9MSjdDtvMOeQOh4Zptq9Gz5FVA1BO1nvd4Eb3iUyy3xeVWrYRd1NkSdHJ+TGqEOGIa9X4qtZPcwK5T9Q0I1b7QYt1JuV0j5iizDqP79qMHhX/Hmw+abmJAKM7wfNdS85NXQh+Lkdi7X0qvCzUT7pUsded6YtKYpCQIDAQABAoIBAQDKjwr6cHC3mcN+L9Zv7MzXm2I6GUihLyMypZ0DcyYKBtP3wHFe6apSjxCeetjWN5kKVUS6+KKHrRWZ5J0dXw8WuTE8k/8Tjh83IqkxgDyLTjjkCYC248Cdrqo9QCSuhCBIBrc9sd77bX0AkwGgiXKXepojqsCRL7CZPwU78MFaM3QVUimLYASE9Q6/Z3jhbEUuSK7uU96vOD+mfYVCMtohLqGx2Tk/uMFeHxpS6E/HSsgfGUJHCufFA62nwsE2tAMEfZChFJIWKSqy4CWCbgWM82AvihK94CRsAvpkROVqcB4PY0QBb99LXnB3EghQqMjo6C6q3C8LYcS4/5JOkA2dAoGBAO1Rk+LUbJBKZTIGuVUy4lZYheljo1mYCLycqPW9SqBjsBhdoX2vqc5J4FxrvrTPWSmVblmYYUkfK0Kx8MkUjCxEWzC8Itu6AQUpUAXg2E3V28RwItt8HuBRBDS79km6FNreT5RQZuzQ4eM6RBdlE2T0iv6OdABTLV0J8CsCG0gzAoGBAOrh8ccu8ncrSKZoUi7mmOrHuLq+euZlfKIGaRyOKnauWnhDfl6MpCZy0hmgfrY3iTOWGe95npESFVUMkn5LIWuxG1Fk0wIBq7uhv+CqMMMa/7ZYQTKn1wHlwGHlefW80Mzej83WehMypPcxotn4vGB9b/lWVvfA4dpGTSKwtL3TAoGBANSx5ZpJipdzpejFL/vVJBgBNNutSmz1Hvd0bNX59lVzoxLjb+ZGtyjE+4m5o21H3QCxBfrU4HR5s/sNoeGGQe82wIgYRiGqPlnS4f6yuwpfnp0bZ5JRVxbyZZOh1qXTWfejga1KtkSPHbTatsZE97HmnmBxajQUWDbnvlG9jJgTAoGBAJhTa79nXOuX8IerBBFSjz1DxTOmsIGWs5tIWQah1DwfmqB/9QZQY2xj7omcIlD990azQ6Kg1wryFU+Q1bh99PCobTT+FDIq7zrCDXQgK3t8mPWiirXVT4T1gSx76/pIN4mFlPFC9OxaXc3KLPj7bP+Omf2z1rbaKh6qlP+4ZZ7tAoGASU7kUHm/o35qU8Sy9f0YSeOq4JRMast8tyj7hqI5ZEb4LCHioFpK76qmUHrsgAXO48NeQ0AZPsNA7jqYVEPHemcpk+Qzva0VkinUhSb+Hvqeam314lQpg0ctpJf73yjIy9ScxCFxNnoDLybWnbptazW3OwhKNdyVQ675kp/GXVU=';
        $aop->alipayrsaPublicKey = 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAl52A0hQejykjLpsxv5Bp4pHlri3GFYdzHtHpk33yKZKuFglgwVm/xTxur+6wKKYssyBfBXwP7vibn+JNw/yg0WuYYpv41PIUmwIz4BMjPCb+0Yqnn+Zuk+hoJQtcXdj+q4lEvvbOvTKm7aHVE2TdL62kXB6WVvc1Tk2jSFg1yO7ljvsbZuFq+b24VyOR6h8cXyUBpeoptlmpVk/Q3rbDltuE+PinOXgVQVKkjKBrKx9j1tl8MZrMOsCEgxYNNmi0ycJqfa3NSPunYsocld/xo39OVAZ7ophZi3dwpBIHOmqHbI+6hf90H/FHcMhERL5OnURX/t+GX4+LOl1/R0U6uQIDAQAB';
        $aop->apiVersion = '1.0';
        $aop->signType = 'RSA2';
        $aop->postCharset='UTF-8';
        $aop->format='json';
        $request = new \AlipayFundTransOrderQueryRequest;
        $request->setBizContent("{" .
            "\"out_biz_no\":\"".$number."\"" .
            "  }");
        $result = $aop->execute($request);
        $responseNode = str_replace(".", "_", $request->getApiMethodName()) . "_response";
        $resultCode = $result->$responseNode->code;
        if(!empty($resultCode)&&$resultCode == 10000){
            return true;
        } else {
            return false;
        }
    }


    public function WeChatPayReady($order,$type=null){
        // 获取配置项
        $data=array(
            'appid'=>$weixinpay_config2['APPID'],
            'mch_id'=>$weixinpay_config2['MCHID'],
            'nonce_str'=>'test',
            'spbill_create_ip'=>$_SERVER['REMOTE_ADDR'],
            'notify_url'=>$weixinpay_config2['NOTIFY_URL']
        );
        // 生成签名
        $sign=$this->makeSign($data);
        $data['sign']=$sign;
        $xml=$this->toXml($data);
        $url = 'https://api.mch.weixin.qq.com/pay/unifiedorder';//接收xml数据的文件
        $header[] = "Content-type: text/xml";//定义content-type为xml,注意是数组
        $ch = curl_init ($url);
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
        curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,FALSE);//严格校验
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
        $response = curl_exec($ch);
        if(curl_errno($ch)){
            print curl_error($ch);
        }
        curl_close($ch);
        $result=$this->toArray($response);
        if($result['return_code'] == 'FAIL'){
            $returnerr['msg'] = $result['return_msg'];
            $returnerr['type'] = 'error';
            return $returnerr;
        }else{
            $result['sign']=$sign;
            $result['nonce_str']='test';
            $result2 = $this->getOrder($result['prepay_id']);
            return $result2;///
        }

    }
    /**
     * 生成签名
     * @return 签名,本函数不覆盖sign成员变量,如要设置签名需要调用SetSign方法赋值
     */
    public function makeSign($data){
        // 去空
        $data=array_filter($data);
        //签名步骤一:按字典序排序参数
        ksort($data);
        $string_a=http_build_query($data);
        $string_a=urldecode($string_a);
        //签名步骤二:在string后加入KEY
        $config2=$this->config2;
        $string_sign_temp=$string_a."&key=".$config2['KEY'];
        //签名步骤三:MD5加密
        $sign = md5($string_sign_temp);
        // 签名步骤四:所有字符转为大写
        $result=strtoupper($sign);
        return $result;
    }
    /**
     * 输出xml字符
     * @throws WxPayException
     **/
    public function toXml($data){
        //var_dump($data);
        if(!is_array($data) || count($data) <= 0){
            //throw new WxPayException("数组数据异常!");
        }
        $xml = "<xml>";
        foreach ($data as $key=>$val){
            if (is_numeric($val)){
                $xml.="<".$key.">".$val."</".$key.">";
            }else{
                $xml.="<".$key."><![CDATA[".$val."]]></".$key.">";
            }
        }
        $xml.="</xml>";
        return $xml;
    }
    /**
     * 将xml转为array
     * @param  string $xml xml字符串
     * @return array       转换得到的数组
     */
    public function toArray($xml){
        //禁止引用外部xml实体
        libxml_disable_entity_loader(true);
        $result= json_decode(json_encode(simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
        return $result;
    }
    //获取指定长度的随机字符串
    function getRandChar($length){
        $str = null;
        $strPol = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz";
        $max = strlen($strPol)-1;

        for($i=0;$i<$length;$i++){
            $str.=$strPol[rand(0,$max)];//rand($min,$max)生成介于min和max两个数之间的一个随机整数
        }

        return $str;
    }

//    /**   原支付宝提现,打开即用
//     * r_id,type 1是同意 2是拒绝,remark(备注)
//     * @return \think\response\Json
//     */
//    public function agreeOrRefuseTixian($r_id,$type,$remark)
//    {
//        $jilu = Db::name('work_jilu')->where('r_id',$r_id)->find();
//        if($jilu['r_status'] != 1){
//            return ['code'=>0,'msg'=>'已经操作过了,请刷新!'];
//        }else{
//            $today = date('Y-m-d H:i:s');
//            if($type == 1){//同意
//                $have = $this->chaxunTixianRes($jilu['r_water']);
//                if($have){
//                    return ['code'=>0,'msg'=>'此订单号已经体现过了'];
//                }else{
//                    $res = $this->tixianAgreeShopOrWork($jilu['r_water'],$jilu['r_money'],$jilu['r_acc_num'],$jilu['r_acc_username'],$remark);
//                    if($res['status'] == 200){
//                        $last = Db::name('work_jilu')->where('r_id',$r_id)
//                            ->update(['r_status'=>2,'r_remark'=>$remark,'r_res'=>2,'r_dotime'=>$today]);//r_res没用。。。
//                        if($last){
//                            //入消息和推送
//                            if ($jilu['r_type'] == 1) {//商户
//                                $where = 2;
//                            } else {
//                                $where = 3;
//                            }
//                            //消息和推送
//                            allInNotice('提现到账通知','您申请的'.$jilu['r_money'].'元的提现,已到账,请注意查收',$jilu['r_user_id']);
//                            sendJpush("{$jilu['r_user_id']}", '您申请的'.$jilu['r_money'].'元的提现,已到账,请注意查收', array('a' => 'b'), 2, 2, $where);
//                            return ['code'=>200,'msg'=>'操作成功'];
//                        }else{
//                            return ['code'=>0,'msg'=>'提现成功但状态更改失败,请忽略此申请!'];
//                        }
//                    }else{
//                        return ['code'=>0,'msg'=>$res['msg']];
//                    }
//                }
//            }else{
//                Db::startTrans();
//                try {
//                    Db::name('work_jilu')->where('r_id', $r_id)
//                        ->update(['r_status' => 3, 'r_remark' => $remark, 'r_res' => 3,'r_dotime'=>$today]);//r_res没用。。。
//                    if ($jilu['r_type'] == 1) {//商户
//                        $where = 2;
//                        Db::table('up_shops')->where('s_id', $jilu['r_user_id'])->setInc('s_money', $jilu['r_money']);
//                    } else {
//                        $where = 3;
//                        Db::table('up_work_user')->where('user_id', $jilu['r_user_id'])->setInc('user_money', $jilu['r_money']);
//                    }
//                    Db::commit();
//                    //消息和推送
//                    allInNotice('提现驳回通知','您申请的'.$jilu['r_money'].'元的提现申请被驳回,原因:'.$remark,$jilu['r_user_id']);
//                    sendJpush("{$jilu['r_user_id']}", '您申请的'.$jilu['r_money'].'元的提现申请被驳回', array('a' => 'b'), 2, 2, $where);
//                    return ['status' => 200, 'msg' => '操作成功'];
//                } catch (\Exception $e) {
//                    Db::rollback();
//                    return ['status' => 0, 'msg' => '操作失败'];
//                }
//            }
//        }
//    }

    /**
     * r_id,type 1是同意 2是拒绝,remark(备注)
     * @return \think\response\Json
     */
    public function agreeOrRefuseTixian($r_id,$type,$remark)
    {
        $jilu = Db::name('work_jilu')->where('r_id',$r_id)->find();
        if($jilu['r_where'] == 1){
            if($jilu['r_status'] != 1){
                return ['code'=>0,'msg'=>'已经操作过了,请刷新!'];
            }else{
                $today = date('Y-m-d H:i:s');
                $today2 = date('Y-m-d');
                if($type == 1){//同意
                    $last = Db::name('work_jilu')->where('r_id',$r_id)
                        ->update(['r_status'=>2,'r_remark'=>$remark,'r_res'=>2,'r_dotime'=>$today,'r_dodate'=>$today2,'r_doadmin'=>session('username')]);//r_res没用。。。
                    if($last){
                        //入消息和推送
                        if ($jilu['r_type'] == 1) {//商户
                            $where = 2;
                        } else {
                            $where = 3;
                        }
                        //消息和推送
//                        allInNotice('提现到账通知','您申请的'.$jilu['r_money'].'元的提现,已到账,请注意查收',$jilu['r_user_id']);
//                        sendJpush("{$jilu['r_user_id']}", '您申请的'.$jilu['r_money'].'元的提现,已到账,请注意查收', array('a' => 'b'), 2, 2, $where);
                        return ['code'=>200,'msg'=>'操作成功'];
                    }else{
                        return ['code'=>0,'msg'=>'操作失败!'];
                    }
                }else{
                    Db::startTrans();
                    try {
                        Db::name('work_jilu')->where('r_id', $r_id)
                            ->update(['r_status' => 3, 'r_remark' => $remark, 'r_res' => 3,'r_dotime'=>$today,'r_dodate'=>$today2,'r_doadmin'=>session('username')]);//r_res没用。。。
                        if ($jilu['r_type'] == 1) {//商户
                            $where = 2;
                            Db::table('up_shops')->where('s_id', $jilu['r_user_id'])->setInc('s_money', $jilu['r_all_money']);
                        } else {
                            $where = 3;
                            Db::table('up_work_user')->where('user_id', $jilu['r_user_id'])->setInc('user_money', $jilu['r_all_money']);
                        }
                        Db::commit();
                        //消息和推送
                        allInNotice('提现驳回通知','您申请的'.$jilu['r_all_money'].'元的提现申请被驳回,原因:'.$remark,$jilu['r_user_id']);
                        sendJpush("{$jilu['r_user_id']}", '您申请的'.$jilu['r_all_money'].'元的提现申请被驳回', array('a' => 'b'), 2, 2, $where);
                        return ['status' => 200, 'msg' => '操作成功'];
                    } catch (\Exception $e) {
                        Db::rollback();
                        return ['status' => 0, 'msg' => '操作失败'];
                    }
                }
            }
        }else{
            return ['status' => 0, 'msg' => '暂未开放支付宝和微信提现'];
        }
    }


    /*
     * 商户提现
     */
    public function businessMoney()
    {
        if(request()->isAjax ()){
            extract(input());
            $map = [];
            if(isset($key)&&$key!="")
            {
                $map['r_acc_username|r_water'] = ['like',"%" . $key . "%"];
            }
            if(isset($who)&&$who!="")
            {
                $map['r_doadmin'] = $who;
            }
            if(isset($start)&&$start!=""&&isset($end)&&$end=="")
            {
                $map['r_dodate'] = ['>= time',$start];
            }
            if(isset($end)&&$end!=""&&isset($start)&&$start=="")
            {
                $map['r_dodate'] = ['<= time',$end];
            }
            if(isset($start)&&$start!=""&&isset($end)&&$end!="")
            {
                $map['r_dodate'] = ['between time',[$start,$end]];
            }
            $map['r_type'] = 1;
            $Nowpage = input('page') ? input('page'):1;
            $limits = input("limit")?input("limit"):10;// 获取总条数;
            $count = Db::name('work_jilu j')
                ->join('shops u','u.s_id = j.r_user_id','left')
                ->where($map)
                ->count();
            $lists = Db::name('work_jilu j')
                ->join('shops u','u.s_id = j.r_user_id','left')
                ->field('r_id,s_name as user_username,s_phone,r_money,r_all_money,r_status,r_acc_bank,r_time,r_water,r_acc_num,r_acc_username,r_where,r_doadmin')
                ->where($map)
                ->page($Nowpage,$limits)
                ->order('r_time desc')
                ->select();
            return json(['code'=>0,'msg'=>'','count'=>$count,'data'=>$lists]);
        }
        $shenhes = $count = Db::name('work_jilu')
            ->where('r_type',1)
            ->field('r_doadmin')
            ->group('r_doadmin')
            ->select();
        $this->assign('shenhes',$shenhes);
        return $this->fetch('money/business_money');
    }

    /*
     * 商户提现
     */
    public function getShopMoney(){
        extract(input());
        $res = $this->agreeOrRefuseTixian($r_id,$type,$remark);
        return json($res);
    }

    /*
     * 商户批量提现
     */
    public function shopBatchMoney(){
        extract(input());
        if($r_id == ''){
            return json(['code'=>100,'msg'=>'请选择要提现的记录!']);
        }
        $ids = explode(',',$r_id);
        foreach($ids as $key=>$vo){
            $res = $this->agreeOrRefuseTixian($vo,$type,$remark);
            if($res['code'] != 200){
                return json(['code'=>100,'msg'=>'ID:'.$vo.'商户提现失败']);
            }
        }
        return json(['code'=>200,'msg'=>'批量提现成功']);
    }

    /*
     * 业务员提现
     */
    public function salesmanMoney()
    {
        if(request()->isAjax ()){
            extract(input());
            $map = [];
            if(isset($key)&&$key!="")
            {
                $map['r_acc_username|r_water'] = ['like',"%" . $key . "%"];
            }
            if(isset($who)&&$who!="")
            {
                $map['r_doadmin'] = $who;
            }
            if(isset($start)&&$start!=""&&isset($end)&&$end=="")
            {
                $map['r_dodate'] = ['>= time',$start];
            }
            if(isset($end)&&$end!=""&&isset($start)&&$start=="")
            {
                $map['r_dodate'] = ['<= time',$end];
            }
            if(isset($start)&&$start!=""&&isset($end)&&$end!="")
            {
                $map['r_dodate'] = ['between time',[$start,$end]];
            }
            $map['r_type'] = 2;
            $Nowpage = input('page') ? input('page'):1;
            $limits = input("limit")?input("limit"):10;// 获取总条数;
            $count = Db::name('work_jilu j')
                ->join('work_user u','u.user_id = j.r_user_id','left')
                ->where($map)
                ->count();
            $lists = Db::name('work_jilu j')
                ->join('work_user u','u.user_id = j.r_user_id','left')
                ->field('r_id,user_name,user_phone,r_money,r_all_money,r_status,r_acc_bank,r_time,r_water,r_acc_num,r_acc_username,r_where,r_doadmin')
                ->where($map)
                ->page($Nowpage,$limits)
                ->order('r_time desc')
                ->select();
            return json(['code'=>0,'msg'=>'','count'=>$count,'data'=>$lists]);
        }
        $shenhes = $count = Db::name('work_jilu')
            ->where('r_type',2)
            ->field('r_doadmin')
            ->group('r_doadmin')
            ->select();
        $this->assign('shenhes',$shenhes);
        return $this->fetch('money/salesman_money');
    }

    /*
     * 业务员提现
     */
    public function getSaleMoney(){
        extract(input());
        $res = $this->agreeOrRefuseTixian($r_id,$type,$remark);
        return json($res);
    }

    /*
    * 业务员批量提现
    */
    public function shopSaleMoney(){
        extract(input());
        if($r_id == ''){
            return json(['code'=>100,'msg'=>'请选择要提现的记录!']);
        }
        $ids = explode(',',$r_id);
        foreach($ids as $key=>$vo){
            $res = $this->agreeOrRefuseTixian($vo,$type,$remark);
            if($res['code'] != 200){
                return json(['code'=>100,'msg'=>'ID:'.$vo.'业务员提现失败']);
            }
        }
        return json(['code'=>200,'msg'=>'批量提现成功']);
    }

}

<?php
/**
 * Created by PhpStorm.
 * User: 戎大富
 * Date: 2018/6/13
 * Time: 10:40
 */
namespace app\work\controller;
use think\Controller;
use think\Db;

class  Base extends Controller {
    protected $_error;
    protected $_header;//用户的请求头信息
    protected $config = array(
        'partner'=>'2088621781822784',//用不着
        'seller_id'=>'admin@bagepanzi.com',//用不着
        'sign_type'=>'RSA2',// 直接写死了
        'it_b_pay'=>'10m',//用不着
        'md5'=>'djqm7budkdlki6a76yasuyb9s1riiu1j',//用不着
        'ali_public'=>'',
        'public_key'=>"",
        'private_key'=>''
    );
    // 定义配置项
    private $config2=array(
        'APPID'              => 'wxa6a14bfed0d430bf', // 微信支付APPID.
        'MCHID'              => '1515748591', // 微信支付MCHID 商户收款账号
        'KEY'                => '', // 微信支付KEY
        'APPSECRET'          => '', // 公众帐号secert (公众号支付专用)
        'NOTIFY_URL'         => 'http://red.hjv5.com/work/Index/huidiaoWx', // 接收支付状态的连接

    );
    public function __construct()
    {

//        parent::__construct();

    }

    /**
     * 验证唯一——单点登录
     * user_id,time,salt,value
     * @return string
     */
    public  function checkAll($uid,$time,$value,$reqKey){//$uid,$time,$value
        header("Access-Control-Allow-Origin:*");
        if($uid == '0'){
            return true;
        }else{
            $user = Db::table('up_work_user')->where('user_id',$uid)->find();
            if(!$user){return false;}
            if($user['user_status'] != 1){
                return false;
            }
            $token = $user['user_token'];
            $appId = "A6070308312682";
            $appkey = "9AF807B0-BE12-F521-6998-6D57B0CCE8BB";
            $myreqKey = md5($appId . 'XW' . $appkey . 'XW' . $time);
            $myvalue = md5($uid . 'XW' . $token . 'XW' . $time);
            if($myvalue != $value || $myreqKey != $reqKey){
                return false;
            }else{
                return true;
            }
        }
    }

    /**
     * 云之讯发送短信
     * @param $phone
     * @param $num
     * @return mixed
     */
    public function duaxin($phone,$num){
        $body_json = array(
            'sid'=>'2b6e76df39bef2e4a99eee7b77225c91',
            'token'=>'26a41e1a5b90f6a0bd2e4fb4fb6a713e',
            'appid'=>'760e6b2f0a45439585835cbed2e12e18',
            'templateid'=>'373248',
            'param'=>$num,
            'mobile'=>$phone,
            'uid'=>'',
        );
        $body = json_encode($body_json);
        $header = array(
            'Accept:application/json',
            'Content-Type:application/json;charset=utf-8',
        );
        $url = 'https://open.ucpaas.com/ol/sms/sendsms';
        $ch = curl_init($url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
        curl_setopt($ch,CURLOPT_POST,1);
        curl_setopt($ch,CURLOPT_POSTFIELDS,$body);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
        $result = curl_exec($ch);
        curl_close($ch);
        $res = json_decode($result,true);
        return $res;
    }

    function diffBetweenTwoDays ($day2)
    {
        $day1 = date('Y-m-d');
        $second1 = strtotime($day1);
        $second2 = strtotime($day2);
        if ($second1 < $second2) {
            $tmp = $second2;
            $second2 = $second1;
            $second1 = $tmp;
        }
        return ($second1 - $second2) / 86400;
    }

    /**
     * 获取任意长度的随机字符串
     * @param $length
     * @return string
     */
//    function getRandChar($length)
//    {
//        $chars = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h',
//            'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's',
//            't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'B', 'C', 'D',
//            'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O',
//            'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z',
//            '0', '1', '2', '3', '4', '5', '6', '7', '8', '9');
//        $char_txt = '';
//        for ($i = 0; $i < $length; $i++) {
//            $char_txt .= $chars[array_rand($chars)];
//        }
//        return $char_txt;
//    }

    public function uuid($prefix = '')
    {
        $chars = md5(uniqid(mt_rand(), true));
        $uuid  = substr($chars,0,8);
        $uuid .= substr($chars,8,4);
        $uuid .= substr($chars,12,4);
        $uuid .= substr($chars,16,4);
        $uuid .= substr($chars,20,12);
        return $prefix . $uuid;
    }
    /**
     * 获取我的专属编号
     * @param $unique_no
     * @return bool|string
     */
    public function getMyNum($unique_no){
        $num = Db::table('up_work_user')->where('user_mynum',$unique_no)->find();
        if($num){
            $unique_no = substr(base_convert(md5(uniqid(md5(microtime(true)),true)), 16, 10), 0, 5);
            return $this->getMyNum($unique_no);
        }else{
            return $unique_no;
        }

    }
    /**
     * 验证码
     * @param $length
     * @return string
     */
    function getCodeChar($length)
    {
        $chars = array(
            '0', '1', '2', '3', '4', '5', '6', '7', '8', '9');
        $char_txt = '';
        for ($i = 0; $i < $length; $i++) {
            $char_txt .= $chars[array_rand($chars)];
        }
        return $char_txt;
    }
    public function getAcount()
    {
        //==========base里放到===============
        $zimu = range('a','z');
        $one = rand(0,25);
        $two = rand(0,25);
        $thr = rand(0,25);
        $four = rand(0,25);
        $zimu2 = $zimu[$one].$zimu[$two].$zimu[$thr].$zimu[$four];
        $num = rand(100000,999999);
        return $zimu2.$num;
        //=========================
    }


    /**
     * @param $no
     * @param $money
     * @return string
     * 支付宝支付
     */
    public function getParam($no,$money){
//        header("Content-type: text/html; charset=utf-8");
        require_once '/data/wwwroot/red.hjv5.com/extend/aliqrcode/f2fpay/model/builder/AlipayTradePrecreateContentBuilder.php';
        require_once '/data/wwwroot/red.hjv5.com/extend/aliqrcode/f2fpay/service/AlipayTradeService.php';
        $outTradeNo = $no;
        // (必填) 订单标题,粗略描述用户的支付目的。如“xxx品牌xxx门店当面付扫码消费”
        $subject = '商户入驻';
        // (必填) 订单总金额,单位为元,不能超过1亿元
        // 如果同时传入了【打折金额】,【不可打折金额】,【订单总金额】三者,则必须满足如下条件:【订单总金额】=【打折金额】+【不可打折金额】
        $totalAmount = $money;
        // 订单描述,可以对交易或商品进行一个详细地描述,比如填写"购买商品2件共15.00元"
        $body = "商户入驻费用";
        // 支付超时,线下扫码交易定义为5分钟
        $timeExpress = "5m";
        // 创建请求builder,设置请求参数
        $qrPayRequestBuilder = new \AlipayTradePrecreateContentBuilder();
        $qrPayRequestBuilder->setOutTradeNo($outTradeNo);
        $qrPayRequestBuilder->setTotalAmount($totalAmount);
        $qrPayRequestBuilder->setTimeExpress($timeExpress);
        $qrPayRequestBuilder->setSubject($subject);
        $qrPayRequestBuilder->setBody($body);
        // 调用qrPay方法获取当面付应答
        $alipay_config = array(
            'gatewayUrl'=>'https://openapi.alipay.com/gateway.do',//用不着
            'app_id'=>'2018090761306686',//用不着
            'sign_type'=>'RSA2',// 直接写死了
            'merchant_private_key'=>'MIIEpQIBAAKCAQEA2b4GAsKv3MXAgKvPAVHJeT0MZ+XX5Ke55q74ecV/Wy9NN7wmJBUEVqf/jZEaCtxEhNUNjz74XyoTN/xvYeZ2sjtMSmCzjAuvUUM5GlAMvwg+UpIWC95J1Sz3eLOfzciPUhcd2A4yCEHXjjlgOfWB25U8HBYr8kddfHGm5sKC3IiGM88GLu4CM9MSjdDtvMOeQOh4Zptq9Gz5FVA1BO1nvd4Eb3iUyy3xeVWrYRd1NkSdHJ+TGqEOGIa9X4qtZPcwK5T9Q0I1b7QYt1JuV0j5iizDqP79qMHhX/Hmw+abmJAKM7wfNdS85NXQh+Lkdi7X0qvCzUT7pUsded6YtKYpCQIDAQABAoIBAQDKjwr6cHC3mcN+L9Zv7MzXm2I6GUihLyMypZ0DcyYKBtP3wHFe6apSjxCeetjWN5kKVUS6+KKHrRWZ5J0dXw8WuTE8k/8Tjh83IqkxgDyLTjjkCYC248Cdrqo9QCSuhCBIBrc9sd77bX0AkwGgiXKXepojqsCRL7CZPwU78MFaM3QVUimLYASE9Q6/Z3jhbEUuSK7uU96vOD+mfYVCMtohLqGx2Tk/uMFeHxpS6E/HSsgfGUJHCufFA62nwsE2tAMEfZChFJIWKSqy4CWCbgWM82AvihK94CRsAvpkROVqcB4PY0QBb99LXnB3EghQqMjo6C6q3C8LYcS4/5JOkA2dAoGBAO1Rk+LUbJBKZTIGuVUy4lZYheljo1mYCLycqPW9SqBjsBhdoX2vqc5J4FxrvrTPWSmVblmYYUkfK0Kx8MkUjCxEWzC8Itu6AQUpUAXg2E3V28RwItt8HuBRBDS79km6FNreT5RQZuzQ4eM6RBdlE2T0iv6OdABTLV0J8CsCG0gzAoGBAOrh8ccu8ncrSKZoUi7mmOrHuLq+euZlfKIGaRyOKnauWnhDfl6MpCZy0hmgfrY3iTOWGe95npESFVUMkn5LIWuxG1Fk0wIBq7uhv+CqMMMa/7ZYQTKn1wHlwGHlefW80Mzej83WehMypPcxotn4vGB9b/lWVvfA4dpGTSKwtL3TAoGBANSx5ZpJipdzpejFL/vVJBgBNNutSmz1Hvd0bNX59lVzoxLjb+ZGtyjE+4m5o21H3QCxBfrU4HR5s/sNoeGGQe82wIgYRiGqPlnS4f6yuwpfnp0bZ5JRVxbyZZOh1qXTWfejga1KtkSPHbTatsZE97HmnmBxajQUWDbnvlG9jJgTAoGBAJhTa79nXOuX8IerBBFSjz1DxTOmsIGWs5tIWQah1DwfmqB/9QZQY2xj7omcIlD990azQ6Kg1wryFU+Q1bh99PCobTT+FDIq7zrCDXQgK3t8mPWiirXVT4T1gSx76/pIN4mFlPFC9OxaXc3KLPj7bP+Omf2z1rbaKh6qlP+4ZZ7tAoGASU7kUHm/o35qU8Sy9f0YSeOq4JRMast8tyj7hqI5ZEb4LCHioFpK76qmUHrsgAXO48NeQ0AZPsNA7jqYVEPHemcpk+Qzva0VkinUhSb+Hvqeam314lQpg0ctpJf73yjIy9ScxCFxNnoDLybWnbptazW3OwhKNdyVQ675kp/GXVU=',//用不着
            'alipay_public_key'=>'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAl52A0hQejykjLpsxv5Bp4pHlri3GFYdzHtHpk33yKZKuFglgwVm/xTxur+6wKKYssyBfBXwP7vibn+JNw/yg0WuYYpv41PIUmwIz4BMjPCb+0Yqnn+Zuk+hoJQtcXdj+q4lEvvbOvTKm7aHVE2TdL62kXB6WVvc1Tk2jSFg1yO7ljvsbZuFq+b24VyOR6h8cXyUBpeoptlmpVk/Q3rbDltuE+PinOXgVQVKkjKBrKx9j1tl8MZrMOsCEgxYNNmi0ycJqfa3NSPunYsocld/xo39OVAZ7ophZi3dwpBIHOmqHbI+6hf90H/FHcMhERL5OnURX/t+GX4+LOl1/R0U6uQIDAQAB',//用不着
            'charset'=>'UTF-8',
            'MaxQueryRetry'=>"5",
            'QueryDuration'=>'5',
            'notify_url'=>'http://red.hjv5.com/work/Index/huidiao'
        );
        $qrPay = new \AlipayTradeService($alipay_config);
        $qrPayResult = $qrPay->qrPay($qrPayRequestBuilder);
        if ($qrPayResult->getTradeStatus() == 'SUCCESS'){
            $response = $qrPayResult->getResponse();
            $qrcode = $response->qr_code;
            return array('status'=>200,'msg'=>$qrcode);
        }else{
            return array('status'=>0,'msg'=>'失败');
        }
    }

    public function checkReturn(){
        import('alipay.aop.AopClient',EXTEND_PATH);
        $aop = new \AopClient;
        $aop->alipayrsaPublicKey = $this->config['ali_public'];
        $flag = $aop->rsaCheckV1($_POST, NULL, "RSA2");
        if($flag){
            return $_POST;
        }else{
            return false;
        }
    }
    /**
     *支付宝的原路退款接口
     */
    public function refund($payInfo){
        //仨参数:order_id,order_user_pay,order_number
        import('alipay.aop.AopClient',EXTEND_PATH);
        import('alipay.aop.request.AlipayTradeRefundRequest',EXTEND_PATH);
        $aop = new \AopClient;
        $aop->gatewayUrl = 'https://openapi.alipay.com/gateway.do';
        $aop->appId = '2018090761306686';
        $aop->rsaPrivateKey = $this->config['private_key'];
        $aop->alipayrsaPublicKey=$this->config['ali_public'];
        $aop->apiVersion = '1.0';
        $aop->signType = 'RSA2';
        $aop->postCharset='UTF-8';
        $aop->format='json';
        $request = new \AlipayTradeRefundRequest;
        $refundAmount = $payInfo['money'];
//        $refundAmount = 0.01;
        $request->setBizContent("{" .
            "\"out_trade_no\":\"".$payInfo['number']."\"," .
            "\"trade_no\":\"\"," .
            "\"refund_amount\":".$refundAmount."," .
            "\"refund_reason\":\"退款\"" .
            "  }");
        $result = $aop->execute($request);
        $responseNode = str_replace(".", "_", $request->getApiMethodName()) . "_response";
        $resultCode = $result->$responseNode->code;
        if(!empty($resultCode) && $resultCode == 10000){
            return array('status'=>200,'msg'=>'操作成功');
        }else{
            return array('status'=>0,'msg'=>'调用接口失败');
        }
    }

    //-------------------------**********************微信支付***********************------------------------------------
    //-------------------------**********************微信支付***********************------------------------------------
    //-------------------------**********************微信支付***********************------------------------------------
    //-------------------------**********************微信支付***********************------------------------------------

    public function WeChatPayReady($order,$type=false){
        // 获取配置项
        $weixinpay_config2=$this->config2;
        $config2 = array(
            'appid'=>$weixinpay_config2['APPID'],
            'mch_id'=>$weixinpay_config2['MCHID'],
            'nonce_str'=>'test',
            'spbill_create_ip'=>$_SERVER['REMOTE_ADDR'],
            'notify_url'=>$weixinpay_config2['NOTIFY_URL']
        );
        if($type){
            $config2['notify_url']=$type;
        }
        // 合并配置数据和订单数据
        $data=array_merge($order,$config2);

        // 生成签名
        $sign=$this->makeSign($data);
        $data['sign']=$sign;
        $xml=$this->toXml($data);
        $url = 'https://api.mch.weixin.qq.com/pay/unifiedorder';//接收xml数据的文件
        $header[] = "Content-type: text/xml";//定义content-type为xml,注意是数组
        $ch = curl_init ($url);
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
        curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,FALSE);//严格校验
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
        $response = curl_exec($ch);
        if(curl_errno($ch)){
            print curl_error($ch);
        }
        curl_close($ch);
        $result=$this->toArray($response);
        if($result['return_code'] == 'FAIL'){
            $returnerr['msg'] = $result['return_msg'];
            $returnerr['type'] = 'error';
            return $returnerr;
        }else{
            $result['sign']=$sign;
            $result['nonce_str']='test';
            $result2 = $this->getOrder($result['prepay_id']);
            return $result;///
        }

    }
    /**
     * 获取时间
     * @return array
     */
    public function getDateBytimeDate($string){
        $replacement = '-';
        $replacement2 = ':';
        $a = substr_replace($string, $replacement, 4, 0);
        $b = substr_replace($a, $replacement, 7, 0);
        $c = substr_replace($b, ' ', 10, 0);
        $d = substr_replace($c, $replacement2, 13, 0);
        $e = substr_replace($d, $replacement2, 16, 0);
        return $e;
    }


    /**
     * 输出xml字符
     * @throws WxPayException
     **/
    public function toXml($data){
        //var_dump($data);
        if(!is_array($data) || count($data) <= 0){
            //throw new WxPayException("数组数据异常!");
        }
        $xml = "<xml>";
        foreach ($data as $key=>$val){
            if (is_numeric($val)){
                $xml.="<".$key.">".$val."</".$key.">";
            }else{
                $xml.="<".$key."><![CDATA[".$val."]]></".$key.">";
            }
        }
        $xml.="</xml>";
        return $xml;
    }

    /**
     * 生成签名
     * @return 签名,本函数不覆盖sign成员变量,如要设置签名需要调用SetSign方法赋值
     */
    public function makeSign($data){
        // 去空
        $data=array_filter($data);
        //签名步骤一:按字典序排序参数
        ksort($data);
        $string_a=http_build_query($data);
        $string_a=urldecode($string_a);
        //签名步骤二:在string后加入KEY
        $config2=$this->config2;
        $string_sign_temp=$string_a."&key=".$config2['KEY'];
        //签名步骤三:MD5加密
        $sign = md5($string_sign_temp);
        // 签名步骤四:所有字符转为大写
        $result=strtoupper($sign);
        return $result;
    }

    /**
     * 将xml转为array
     * @param  string $xml xml字符串
     * @return array       转换得到的数组
     */
    public function toArray($xml){
        //禁止引用外部xml实体
        libxml_disable_entity_loader(true);
        $result= json_decode(json_encode(simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
        return $result;
    }
    //获取指定长度的随机字符串
    function getRandChar($length){
        $str = null;
        $strPol = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz";
        $max = strlen($strPol)-1;

        for($i=0;$i<$length;$i++){
            $str.=$strPol[rand(0,$max)];//rand($min,$max)生成介于min和max两个数之间的一个随机整数
        }

        return $str;
    }
    //执行第二次签名,才能返回给客户端使用
    public function getOrder($prepayId){
        $data["appid"] = $this->config2["APPID"];
        $data["noncestr"] = $this->getRandChar(32);
        $data["package"] = "Sign=WXPay";
        $data["partnerid"] = $this->config2['MCHID'];
        $data["prepayid"] = $prepayId;
        $data["timestamp"] = time();
        $s = $this->makeSign($data, false);
        $data["sign"] = $s;

        return $data;
    }

    /**
     * app支付统一退款
     */
    public function refundWx($payInfo,$refundNo=''){
        $refundNo = date('YmdHis') . rand(100000, 999999);
        //transaction_id,money,number
//    public function refundWx(){
        header("content-type:text/html;charset=utf-8");
        $url = "https://api.mch.weixin.qq.com/secapi/pay/refund";
        $data["appid"]           = $this->config2['APPID'];//微信开放平台审核通过的应用APPID
        $data["mch_id"]       = $this->config2['MCHID'];//商户号
        $data["nonce_str"]       = $this->getRandChar(32);//随机字符串
        $data["out_refund_no"]   = $refundNo;
        $data["refund_fee"] = $payInfo['money']*100;
//        $data["refund_fee"] = 1;//todo 测试阶段全部按一分进行计算
        $data["total_fee"]  = $data['refund_fee'];//总金额按乘以100进行计算
        $data["transaction_id"]   = $payInfo['transaction_id'];//微信官方唯一订单识别号
        $data["out_trade_no"] = $payInfo['number'];
        $data["refund_fee_type"] = "CNY";
        $data["refund_account"] = "REFUND_SOURCE_UNSETTLED_FUNDS";
        $sign=$this->getSignRefund($data,$this->config2['KEY']);
        $data['sign']=$sign;
        $xml=$this->toXml($data);
        $response     = $this->postXmlCurl($xml, $url,'',true,'/workcert/apiclient_cert.pem','/workcert/apiclient_key.pem');
        $responseArr=$this->toArray($response);
        if(!is_array($responseArr) || count($responseArr)<=0){
            $return['msg'] = '网络请求繁忙';
            $return['status'] = 0;
        }else if($responseArr['return_code'] == 'FAIL'){
            $return['msg'] = $responseArr['return_msg'];
            $return['status'] = 0;
        }else{
            $chaxun = $this->refundWxChaxun($refundNo);
            if($chaxun['status'] == 200){
                //二次签名
                $return['text'] = $responseArr;
//            直接返回
                $return['status'] = 200;
            }else{
                $return['msg'] = $chaxun['msg'];
                $return['status'] = 0;
            }
        }
        return $return;
    }


    /**
     * app支付统一退款查询:微信退款就算余额不足也会返回成功,所以要先查询判断
     */
    public function refundWxChaxun($refundNo){
//    public function refundWxChaxun(){
//        $refundNo = '4200000209201812224948560415';
//        header("content-type:text/html;charset=utf-8");
        $url = "https://api.mch.weixin.qq.com/pay/refundquery";
        $data["appid"]           = $this->config2['APPID'];//微信开放平台审核通过的应用APPID
        $data["mch_id"]       = $this->config2['MCHID'];;//商户号
        $data["nonce_str"]       = $this->getRandChar(32);//随机字符串
        $data["out_refund_no"]   = $refundNo;
        $sign=$this->getSignRefund($data,'MqIgEfTSiVhudPBnp5dyERv6qxi9Ixhq');
        $data['sign']=$sign;
        $xml=$this->toXml($data);
        $response     = $this->postXmlCurl($xml, $url,'',false,'','');
        $responseArr=$this->toArray($response);
        if(!is_array($responseArr) || count($responseArr)<=0){
            $return['msg'] = '网络请求繁忙';
            $return['status'] = 0;
        }else if($responseArr['return_code'] == 'FAIL'){
            $return['msg'] = $responseArr['return_msg'];
            $return['status'] = 0;
        }else{
            if($responseArr['result_code'] == 'SUCCESS'){
                $return['msg'] = 'ok';
                $return['status'] = 200;
            }else{
                if($responseArr['err_code_des'] == 'not exist'){
                    $responseArr['err_code_des'] = '商户平台余额不足,请联系管理员充值';
                }
                $return['msg'] = $responseArr['err_code_des'];
                $return['status'] = 0;
//                $return = $responseArr;
            }
        }
//        dump($return);die;
        return $return;
    }


    /**
     * app支付统一退款(商户推荐的商户 退款)
     */
    public function refundWxShop($payInfo,$refundNo=''){
        $refundNo = date('YmdHis') . rand(100000, 999999);
        //transaction_id,money,number
//    public function refundWx(){
        header("content-type:text/html;charset=utf-8");
        $url = "https://api.mch.weixin.qq.com/secapi/pay/refund";
        $data["appid"]           = 'wx8ab4cc1831384ba3';//微信开放平台审核通过的应用APPID
        $data["mch_id"]       = '1515746111';//商户号
        $data["nonce_str"]       = $this->getRandChar(32);//随机字符串
        $data["out_refund_no"]   = $refundNo;
        $data["refund_fee"] = $payInfo['money']*100;
//        $data["refund_fee"] = 1;//todo 测试阶段全部按一分进行计算
        $data["total_fee"]  = $data['refund_fee'];//总金额按乘以100进行计算
        $data["transaction_id"]   = $payInfo['transaction_id'];//微信官方唯一订单识别号
        $data["out_trade_no"] = $payInfo['number'];
        $data["refund_fee_type"] = "CNY";
        $data["refund_account"] = "REFUND_SOURCE_UNSETTLED_FUNDS";
        $sign=$this->getSignRefund($data,'2XWCaOA2m2u1Se2SrMjeNvXSSUcZjMkN');
        $data['sign']=$sign;
        $xml=$this->toXml($data);
        $response     = $this->postXmlCurl($xml, $url,'',true,'/shopcert/apiclient_cert.pem','/shopcert/apiclient_key.pem');
        $responseArr=$this->toArray($response);
        if(!is_array($responseArr) || count($responseArr)<=0){
            $return['msg'] = '网络请求繁忙';
            $return['status'] = 0;
        }else if($responseArr['return_code'] == 'FAIL'){
            $return['msg'] = $responseArr['return_msg'];
            $return['status'] = 0;
        }else{
            //二次签名
            $return['text'] = $responseArr;
//            直接返回
            $return['status'] = 200;
        }
        return $return;
    }
    function getSignRefund($obj, $api_key)
    {
        foreach ($obj as $k => $v)
        {
            $Parameters[strtolower($k)] = $v;
        }
        //签名步骤一:按字典序排序参数
        ksort($Parameters);
        $String = $this->formatBizQueryParaMap($Parameters, false);

        //签名步骤二:在string后加入KEY
        $String = $String."&key=".$api_key;
        //签名步骤三:MD5加密
        $result = strtoupper(md5($String));
//        $result = hash_hmac("sha256",stringSignTemp,key);
        return $result;
    }

    function formatBizQueryParaMap($paraMap, $urlencode)
    {
        $buff = "";
        ksort($paraMap);
        foreach ($paraMap as $k => $v)
        {
            if($urlencode)
            {
                $v = urlencode($v);
            }
            $buff .= strtolower($k) . "=" . $v . "&";
        }
        $reqPar = '';
        if (strlen($buff) > 0)
        {
            $reqPar = substr($buff, 0, strlen($buff)-1);
        }
        return $reqPar;
    }
    function postXmlCurl($xml, $url, $second=30, $useCert=false, $sslcert_path, $sslkey_path)
    {
        $ch = curl_init();
        //设置超时
        curl_setopt($ch, CURLOPT_TIMEOUT, $second);
        curl_setopt($ch,CURLOPT_URL, $url);

        //设置header
        curl_setopt($ch, CURLOPT_HEADER, FALSE);
        //要求结果为字符串且输出到屏幕上
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
        curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
        curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,FALSE);

        if($useCert == true){
            curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,false);
            curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,false);
//            curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,TRUE);
//            curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,1);//严格校验
            //设置证书
            $path = $_SERVER['DOCUMENT_ROOT'];
            curl_setopt($ch,CURLOPT_SSLCERTTYPE,'PEM');
            curl_setopt($ch,CURLOPT_SSLCERT, $path.$sslcert_path);
            curl_setopt($ch,CURLOPT_SSLKEYTYPE,'PEM');
            curl_setopt($ch,CURLOPT_SSLKEY, $path.$sslkey_path);
//            curl_setopt($ch,CURLOPT_CAINFO, __DIR__.'/cert/rootca.pem');
        }
        //post提交方式
        curl_setopt($ch, CURLOPT_POST, TRUE);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
        //运行curl
        $data = curl_exec($ch);
        //返回结果
        if($data){
            curl_close($ch);
            return $data;
        } else {
            $error = curl_errno($ch);
            curl_close($ch);
            return false;
        }
    }
}

1.每分钟定时执行一次规则:
每1分钟执行: */1 * * * *或者* * * * *
每5分钟执行: */5 * * * *

2.每小时定时执行一次规则:
每小时执行: 0 * * * *或者0 */1 * * *
每天上午7点执行:0 7 * * *
每天上午7点10分执行:10 7 * * *

3.每天定时执行一次规则:
每天执行 0 0 * * *

4.每周定时执行一次规则:
每周执行 0 0 * * 0

5.每月定时执行一次规则:
每月执行 0 0 1 * *

6.每年定时执行一次规则:
每年执行 0 0 1 1 *

7.其他例子
5 * * * * 指定每小时的第5分钟执行一次ls命令
30 5 * * * ls 指定每天的 5:30 执行ls命令
30 7 8 * * ls 指定每月8号的7:30分执行ls命令
30 5 8 6 * ls 指定每年的6月8日5:30执行ls命令
30 6 * * 0 ls 指定每星期日的6:30执行ls命令[注:0表示星期天,1表示星期1,以此类推,也可以用英文来表示,sun表示星期天,mon表示星期一等。]
30 3 10,20 * * ls 每月10号及20号的3:30执行ls命令[注:“,”用来连接多个不连续的时段]
25 8-11 * * * ls 每天8-11点的第25分钟执行ls命令[注:“-”用来连接连续的时段]
*/15 * * * * ls 每15分钟执行一次ls命令 [即每个小时的第0 15 30 45 60分钟执行ls命令 ]
30 6 */10 * * ls 每个月中,每隔10天6:30执行一次ls命令[即每月的1、11、21、31日是的6:30执行一次ls命令。 ]

<script type="text/javascript">
    /**
     * 到底加载
     */
    var flag=1;
    var rgb = 0;
    $(window).bind("scroll", function () {
        if(getScrollHeight() < getDocumentTop() + getWindowHeight() + 250){ //+200是底部,到250留点距离
            //当滚动条到底时,这里是触发内容
            //异步请求数据,局部刷新dom
            pageNum++;
            //ajax_function()
//            if (flag == 1) {
//                flag=0;
//                var temp = `<div style="height:500px; background:rgb(100,${rgb},${rgb});"></div>`;
//                $('body').append(temp);
//                rgb = rgb + 20;
//                flag = 1;
//            }
        }
    });

    //文档高度
    function getDocumentTop() {
        var scrollTop =  0, bodyScrollTop = 0, documentScrollTop = 0;
        if (document.body) {
            bodyScrollTop = document.body.scrollTop;
        }
        if (document.documentElement) {
            documentScrollTop = document.documentElement.scrollTop;
        }
        scrollTop = (bodyScrollTop - documentScrollTop > 0) ? bodyScrollTop : documentScrollTop;
        console.log("scrollTop:"+scrollTop);
        return scrollTop;
    }

    //可视窗口高度
    function getWindowHeight() {
        var windowHeight = 0;
        if (document.compatMode == "CSS1Compat") {
            windowHeight = document.documentElement.clientHeight;
        } else {
            windowHeight = document.body.clientHeight;
        }
        console.log("windowHeight:"+windowHeight);
        return windowHeight;
    }

    //滚动条滚动高度
    function getScrollHeight() {
        var scrollHeight = 0, bodyScrollHeight = 0, documentScrollHeight = 0;
        if (document.body) {
            bodyScrollHeight = document.body.scrollHeight;
        }
        if (document.documentElement) {
            documentScrollHeight = document.documentElement.scrollHeight;
        }
        scrollHeight = (bodyScrollHeight - documentScrollHeight > 0) ? bodyScrollHeight : documentScrollHeight;
        console.log("scrollHeight:"+scrollHeight);
        return scrollHeight;
    }
</script>

/***
     * @return \think\response\Json
     * 更新城市json数据
     */
    public function makejsonareas(){
        set_time_limit(0);
        $pro = Db::table('up_area')
            ->where('level',1)
//            ->where('district_id',1001)
            ->field('district_id id,district name')
            ->select();
        $shi = Db::table('up_area')
            ->where('level',2)
            ->field('district_id id,district name,pid parentId')
            ->select();
        $qu = Db::table('up_area')
            ->where('level',3)
            ->field('district_id id,district name,pid parentId')
            ->select();
        $street = Db::table('up_area')
            ->where('level',4)
            ->field('district_id id,district name,pid parentId')
            ->select();
        foreach ($qu as $k=>$v){
            foreach ($street as $kk=>$vv){
                if($vv['parentId'] == $v['id']){
                    $qu[$k]['sub'][] = $vv;
                }
            }
        }
        foreach ($shi as $k=>$v){
            foreach ($qu as $kk=>$vv){
                if($vv['parentId'] == $v['id']){
                    $shi[$k]['sub'][] = $vv;
                }
            }
        }
        foreach($pro as $k=>$v){
            $pro[$k]['parentId'] = 0;
            foreach ($shi as $kk=>$vv){
                if($vv['parentId'] == $v['id']){
                    $pro[$k]['sub'][] = $vv;
                }
            }
        }
        $root = $_SERVER['DOCUMENT_ROOT'];
        $myfile = fopen("$root/static/test.json", "w") or die("Unable to open file!");
        $txt = json_encode($pro);
        fwrite($myfile, $txt);
        fclose($myfile);
        return json(['code' => 200, 'msg' => '更新成功']);
    }