xixie/application/api/controller/Qc.php

<?php

namespace app\api\controller;
use app\common\model\ChinaArea;
use app\common\model\ForumReply;
use app\common\model\GoodsOrder;
use app\common\model\LevelOrder;
use app\common\model\LevelOrder as LOM;
use app\common\model\StoreGoods;
use app\common\model\User;
use think\cache\driver\Redis;
use think\Db;
class Qc extends Base {

    public function index()
    {
        var_dump(config('mini_program')['app_id'],config('mini_program')['secret']);

    }



    /**
     * @title 获取分享的签名
     * @desc 获取分享的签名
     * @url /api/qc/getWeChatSign
     * @method POST
     * @tag 基础
     *
     **/
    public function getWeChatSign(){
        $urls = input('url');
        $appid = config('app.official_account')['appid'];
        $secret =  config('app.official_account')['secret'];
        $redis = new Redis();
        $access_token = $redis->get('access_token');
        if (!$access_token){
            $access_token = '';
            $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
            $res= http_curl($url);
            if (isset($res['access_token'])){
                $redis->set('access_token',$res['access_token'],'7000');
                $access_token = $res['access_token'];
            }
        }

        $url2 ="https://api.weixin.qq.com/cgi-bin/ticket/getticket?access_token=".$access_token."&type=jsapi";
        $res2=http_curl($url2);
        if (!isset($res2) || $res2['errcode']!=0) $this->error('获取ticket失败');
        $timestamp = time();
        $noncestr = get32Str(15);
        $string = "jsapi_ticket=".$res2['ticket']."&noncestr=$noncestr&timestamp=$timestamp&url=".$urls;
        $sign = sha1($string);
        $return = [
            'appid'=>$appid,
            'noncestr'=>$noncestr,
            'timestamp'=>$timestamp,
            'url'=>$urls,
            'sign'=>$sign,
            'ticket'=>$res2['ticket']
        ];
        $this->success('成功',$return);
    }

    /**
     * 导入子项目数据
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function import()
    {
        $get = $this->request->get();
        $import_path = $_SERVER['DOCUMENT_ROOT'].'/'.$get['path'];
        $project_id = $get['project_id'];
        $num = 5;
        try {
            $objReader =\PHPExcel_IOFactory::createReader('Excel2007');
            $objExcel = $objReader->load($import_path);

            $list = $objExcel->getActiveSheet()->toArray();
            if (!isset($list[2][15]) || !$list[2][15]){
                $this->error('失败');
            }
            if (isset($list[2][16])){
                $this->error('失败');
            }
            Db::name($this->table3)->where('project_id',$project_id)->delete();
            Db::name($this->table)->where('id',$project_id)->update(['url'=>$get['url']]);
            $result = 0;
            foreach ($list as $k=>$v){
                if($k>=$num-1){
                    if(array_filter($v)){
                        $data=[];
                        foreach ($v as $kk=>$vv){
                            $data[IntToChr($kk)]=trim($vv);
                        }
                        $date['project_id'] = $project_id;
                        $date['number'] = $data['A'];
                        $date['cost_project'] = $data['B'];
                        $date['area_calculating_aperture'] = $data['C'];
                        $date['single_party_cost'] = $data['D'];
                        $date['single_party_cost1'] = str_replace(',','',$data['D']);
                        $date['total_price_included'] = $data['E'];
                        $date['total_price_included1'] = str_replace(',','',$data['E']);
                        $date['single_party_cost_excluding'] = $data['F'];
                        $date['single_party_cost_excluding1'] = str_replace(',','',$data['F']);
                        $date['total_price_included_excluding'] = $data['G'];
                        $date['total_price_included_excluding1'] = str_replace(',','',$data['G']);

                        $date['single_party_cost_tax'] = $data['H'];
                        $date['single_party_cost_tax1'] = str_replace(',','',$data['H']);
                        $date['single_party_cost_no_tax'] = $data['I'];
                        $date['single_party_cost_no_tax1'] = str_replace(',','',$data['I']);

                        $date['quantities'] = $data['J'];
                        $date['quantities1'] = str_replace(',','',$data['J']);
                        $date['calculating_unit'] = $data['K'];
                        $date['unilateral_content'] = $data['L'];
                        $date['unilateral_content1'] = str_replace(',','',$data['L']);
                        $date['unilateral_content_excluding'] = $data['M'];
                        $date['unilateral_content_excluding1'] = str_replace(',','',$data['M']);

                        $date['saleable_single_party_tax'] = $data['N'];
                        $date['saleable_single_party_tax1'] = str_replace(',','',$data['N']);

                        $date['saleable_single_party_no_tax'] = $data['O'];
                        $date['saleable_single_party_no_tax1'] = str_replace(',','',$data['O']);

                        $date['note'] = $data['P'];
                        $date['create_at'] = date('Y-m-d H:i:s');

                        $numbers = explode('.',$data['A']);
                        if (count($numbers)>1){
                            array_pop($numbers); //去掉数组最后一组元素
                            $number = implode('.',$numbers);
                            $date['pid'] = Db::name($this->table3)->where('project_id',$project_id)->where('number',$number)->value('id');
                            $date['pname'] = Db::name($this->table3)->where('project_id',$project_id)->where('number',$number)->value('cost_project');
                        }else{
                            $date['pid'] = 0;
                            $date['pname'] = '';
                        }
                        if (Db::table($this->table3)->insertGetId($date)){
                            $result = 1;
                        }else{
                            $result = 0;
                            break;
                        }
                    }
                }
            }
            if ($result==1){
                $this->success('成功');
            }else{
                $this->error('失败');
            }
        } catch (\think\exception\ValidateException $e) {
            $this->error($e->getMessage());

        }
    }

    function excelToArray(){
        //加载excel文件
        $filename = dirname(__FILE__).'/result.xlsx';
        $objPHPExcelReader = \PHPExcel_IOFactory::load($filename);

        $sheet = $objPHPExcelReader->getSheet(0);        // 读取第一个工作表(编号从 0 开始)
        $highestRow = $sheet->getHighestRow();           // 取得总行数
        $highestColumn = $sheet->getHighestColumn();     // 取得总列数

        $arr = 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');
        // 一次读取一列
        $res_arr = array();
        for ($row = 2; $row <= $highestRow; $row++) {
            $row_arr = array();
            for ($column = 0; $arr[$column] != 'F'; $column++) {
                $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
                $row_arr[] = $val;
            }

            $res_arr[] = $row_arr;
        }

        return $res_arr;
    }






    public function index_match()
    {
        $password = "123456879_/";
        //密码必须包含大小写字母/数字/符号任意两者组合
        $regStr = "/^(?![0-9]+$)(?![a-z]+$)(?![A-Z]+$)(?!([^(0-9a-zA-Z)]|[\(\)])+$)([^(0-9a-zA-Z)]|[\(\)]|[a-z]|[A-Z]|[0-9]){6,16}$/";
        var_dump(preg_match($regStr, $password));

    }




}