gonghuixiangqin/application/common.php

<?php
use think\Db;
/**
 * 导出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[1]);
            }
            $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')->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($av_statime>$time){
        $status = 1;
    }
    if($av_statime<$time&&$av_endtime>$time){
        $status = 5;
    }
    if($av_statime<$time&&$sig_statime<$time){
        $status = 2;
    }
    if($av_statime<$time&&$sig_statime<$time&&$avtivity['av_number']<$sing){
        $status = 3;
    }
    if($av_statime<$time&&$sig_endtime<$time){
        $status = 4;
    }
    if($av_endtime<$time){
        $status = 6;
    }
    Db::name('store_activity')->where('id',$id)->update(['status'=>$status]);
    return $status;

}