gonghuixiangqin/application/common.php

<?php

use think\Db;
use app\common\library\QRcode;
use OSS\OssClient;

/**
 * 导出excel文件
 */
function phpExcelListNew($field = [], $list = [], $title = '文件')
{
        $PHPExcel = new \PHPExcel();
        $PHPSheet = $PHPExcel->getActiveSheet();
        $PHPSheet->setTitle('demo'); //给当前活动sheet设置名称
        foreach ($list as $key => $value) {
            foreach ($field as $k => $v) {
                if ($key == 0) {
                    $PHPSheet = $PHPExcel->getActiveSheet()->setCellValue($k . '1', $v[0]);
                }
                $i = $key + 2;
                $PHPExcel->getActiveSheet()->setCellValue($k . $i, $value[$v[0]]);

            }
        }
        $PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007'); //按照指定格式生成Excel文件，
        header('Content-Type: application/vnd.ms-excel'); // 告诉浏览器生成一个excel05版的表格
        header("Content-Disposition: attachment;filename={$title}.xls"); //告诉浏览器输出文件的名称
        header('Cache-Control: max-age=0'); //禁止缓存
        $PHPWriter->save("php://output"); //输出到浏览器

}

/*
 * 活动状态
 */
function av_status($id)
{
    //1活动未开始、2活动报名中、3报名已满、4报名结束、5活动进中、6活动结束

    $avtivity = Db::name('store_activity')->where('id', $id)->field('av_statime,av_endtime,sig_statime,sig_endtime,av_number,status')->find();
    $sing = Db::name('store_activity_sing')->where('a_id', $id)->count();
    $av_statime = strtotime($avtivity['av_statime']);
    $av_endtime = strtotime($avtivity['av_endtime']);
    $sig_statime = strtotime($avtivity['sig_statime']);
    $sig_endtime = strtotime($avtivity['sig_endtime']);
    $time = time();
    if ($sig_statime < $time) {
        $status = 2;
    }
    if ($sig_statime < $time && $avtivity['av_number'] <= $sing) {
        $status = 3;
    }
    if ($sig_endtime < $time) {
        $status = 4;
    }
    if ($av_statime > $time&&$sig_endtime < $time) {
        $status = 1;
    }
    if ($av_statime < $time && $av_endtime > $time) {
        $status = 5;
    }
    if ($av_endtime < $time) {
        $status = 6;
    }
    if(isset($status)) {
        Db::name('store_activity')->where('id', $id)->update(['status' => $status]);
        return $status;
    }
    return $avtivity['status'];

}

/**
 * 获取系统配置
 * @param $array
 * @return array
 * @throws \think\db\exception\DataNotFoundException
 * @throws \think\db\exception\ModelNotFoundException
 * @throws \think\exception\DbException
 */
function getConfig($array)
{
    $set = Db::table('system_config')->where('name', 'in', $array)->select();
    $ret = [];
    foreach ($set as $value) {
        $ret[$value['name']] = $value['value'];
    }
    return $ret;
}

/**
 * 是不是关注好友
 * @param $array

 * @throws \think\db\exception\DataNotFoundException
 * @throws \think\db\exception\ModelNotFoundException
 * @throws \think\exception\DbException
 */
function is_follow($mid, $fid)
{
    $set = Db::table('store_member_follow')->where(array('mid' => $mid, 'fid' => $fid))->find();
    $ret = 0;
    if ($set) $ret = 1;
    return $ret;
}/**
 * 论坛是不是点赞了


 * @throws \think\db\exception\DataNotFoundException
 * @throws \think\db\exception\ModelNotFoundException
 * @throws \think\exception\DbException
 */
function is_give($mid,$fid)
{
    $set = Db::table('store_forum_give')->where(array('m_id' => $mid, 'f_id' => $fid))->find();
    $ret = 0;
    if ($set) $ret = 1;
    return $ret;
}
function is_interested($mid,$fid){
    $set = Db::table('store_member_interested')->where(array('mid'=>$mid,'i_id'=>$fid))->find();
    $ret = 0;
    if ($set) $ret = 1;
    return $ret;
}
/**
 * 地址名
 * @param $array

 * @throws \think\db\exception\DataNotFoundException
 * @throws \think\db\exception\ModelNotFoundException
 * @throws \think\exception\DbException
 */
function areaname($pid)
{
    $set = Db::table('store_area')->where('id',$pid)->value('shortname');

    return $set;
}

/**
 * @param $mid
 * @param $aid
 * @return int
 * @throws \think\db\exception\DataNotFoundException
 * @throws \think\db\exception\ModelNotFoundException
 * @throws \think\exception\DbException
 * 是否报名
 */
function is_sing($mid,$aid){
    $is_sing = Db::name('store_activity_sing')->where(array('a_id'=>$aid,'m_id'=>$mid))->find();
    $is_sig=2;
    if($is_sing){
        $is_sig = 1;
    }
    return $is_sig;
}
/**
 * 获取单个系统配置信息
 */
function getConfigValue($name){
    return Db::name('system_config')->where('name',$name)->value('value');
}
function get_order_sn(){
    $order_id_main = date('YmdHis') . rand(10000000,99999999);
    $order_id_len = strlen($order_id_main);
    $order_id_sum = 0;
    for($i=0; $i<$order_id_len; $i++){
        $order_id_sum += (int)(substr($order_id_main,$i,1));
    }
    $osn = $order_id_main . str_pad((100 - $order_id_sum % 100) % 100,2,'0',STR_PAD_LEFT);
    return $osn;
}

/**
 * 生成二维码
 */
function setqrcode($value,$name){
    $dir = dirname(realpath(dirname($_SERVER['SCRIPT_FILENAME']))) . '/public/user';
    if(!file_exists($dir)){
        //检查是否有该文件夹，如果没有就创建，并给予最高权限
        mkdir($dir, 0700,true);
    }
    $filename = $dir.'/'.$name.'.png';
    QRcode::png($value,$filename,QR_ECLEVEL_L,7);

    $storage_type = getConfigValue('storage_type');
    if ($storage_type == 'oss'){
        $ossClient = new OssClient(getConfigValue('storage_oss_keyid'), getConfigValue('storage_oss_secret'), getConfigValue('storage_oss_endpoint'));
        $file_path = dirname($_SERVER['SCRIPT_FILENAME']) . "/user/".$name.".png";
        $newName = date('Ymd').'/'.get_order_sn().'.png';
        $result = $ossClient->uploadFile(getConfigValue('storage_oss_bucket'), $newName, $file_path);
        $url = $result['info']['url'];
        unlink($file_path);
    }else{
        $url = 'https://'.$_SERVER['SERVER_NAME']."/user/".$name.'.png';
    }
    return $url;
}

//生成报名二维码
function setintivecode($id){
    $name = $id."_".time();
    https://xiangqin.zhousi.hdlkeji.com/h5/#/
    $address = 'https://'.$_SERVER['SERVER_NAME'].'/h5/#/pages/index/index?id='.$id;

    $url = setqrcode($address,$name);
    return $url;
}
//生成邀请二维码
function setsingcode($id){
    $name = $id."_".time();
    $address = 'https://'.$_SERVER['SERVER_NAME'].'/h5/#/pages/index/sing?id='.$id;

    $url = setqrcode($address,$name);
    return $url;
}
function gettag($mid,$now){
    if ($now<10){
        $re = $mid.'000'.$now;
    }elseif ($now>=10 && $now<100){
        $re = $mid.'00'.$now;
    }elseif ($now>=100 && $now<1000){
        $re = $mid.'0'.$now;
    }else{
        $re = $mid.$now;
    }
    return $re;
}
function curl_post($url,$data){
    $headerArray =array("Content-type:application/json;charset='utf-8'","Accept:application/json");
    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt($curl, CURLOPT_SSL_VERIFYHOST,FALSE);
    curl_setopt($curl, CURLOPT_POST, 1);
    curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
    curl_setopt($curl,CURLOPT_HTTPHEADER,$headerArray);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
    $output = curl_exec($curl);
    curl_close($curl);
}
/**
 * @param $url
 * @param array $headers
 * @param array $body
 * @param string $method
 * @return bool|string
 */
function curlRequest($url, $headers = [], $body = [], $method = "GET")
{

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);//设置请求头
    curl_setopt($ch, CURLOPT_POSTFIELDS, $body);//设置请求体
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $method); //定义请求类型
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_HTTP_VERSION, 'CURL_HTTP_VERSION_1_1');
    $output = curl_exec($ch);
    curl_close($ch);
    return $output;
}
function vip_level($mid){
    $vip = Db::name('store_member')->where('id',$mid)->value('vip_level');
    return $vip;
}

/**
 * @param $education
 * @return false|string
 * 学历筛选
 */
function education($education){
    if($education=='高中')
    {
        $data =array('高中','大专','本科','研究生','博士');
    }
    if($education=='大专')
    {
        $data =array('高中','大专','本科','研究生','硕士','博士');
    }
    if($education=='本科')
    {
        $data =array('大专','本科','研究生','博士');
    }
    if($education=='研究生')
    {
        $data =array('研究生','博士');
    }if($education=='博士')
    {
        $data =array('博士');
    }
    return json_encode($data);

    
}
function common_url(){
    $http_type = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') || (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https')) ? 'https://' : 'http://';
    return  $http_type . $_SERVER['HTTP_HOST'];
}