php不使用框架,导出Excel，这里有代码，全解

控制层

//卖场销售明细,导出Excel
public function store_detail()
{
    $data = input("get.");

    $list = $this->storeOrderModel->getStoreModel($data);

    $firstRowTitle = '卖场销售明细(';
    $start_str = empty($data['start']) ? ' - ' : $data['start'];
    $end_str = empty($data['end']) ? ' - ' : $data['end'];

    $firstRowTitle .= '时间：' . $start_str . '至' . $end_str;

    $firstRowTitle .= ')';
    down_excel($list, '卖场销售明细表', $firstRowTitle, ['门店编号', '门店名称', '销售总额'], [20, 28, 20]);

}

模型层

/**
     * 卖场销售明细
     * @param $data
     */
    public function getStoreModel($data)
    {
        //步骤1：从store_order表，查询订单价格，购买日期，导购员id，list
        //步骤2：遍历list，根据userid，下单时间data，从表store_countoff查找门店id。
        //步骤3：根据门店id，去store表，找到需要的门店名称，和store_gene_id，并赋值给新数组array
        // 步骤4： 遍历array数组将金额累加得到门店的总金额；
        $where = [];
        foreach ($data as $k => $v) {
            if ($v === 0) {
                continue;
            }
            if (empty($v)) {
                unset($data[$k]);
            }
        }
        if (!empty($data['start'])&&!empty($data['end'])){
            $start = strtotime($data['start']);
            $end = strtotime($data['end']);
            $where['create_time'] = ['between', [$start, $end]];
        }
       if(!empty($data['start'])&&empty($data['end'])){
           $start = strtotime($data['start']);