1:控制器里
if ($act) {
//执行导出Excel
$fileName = C('MSG_CONTENT_1') . '-' . date('Ymd', time());
header('Content-Type:application/octet-stream');
header('Accept-Ranges:bytes');
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename=' . $fileName . '.xls');
header('Pragma: no-cache');
header('Expires: 0');
$this->display('Finance/outputOrdersList');
}
2:视图层里
{__NOLAYOUT__}
<table class="layui-table text-center margin-top-1" border="1">
<thead>
<tr>
<th>ID</th>
<th>商家</th>
<th>会员</th>
<th>金额</th>
<th>支付方式</th>
<th>订单状态</th>
<th>支付前商家余额</th>
<th>支付后商家余额</th>
<th>事业部</th>
<th>时间</th>
</tr>
</thead>
<tbody>
<volist name="ordersList" id="orders">
<tr>
<td>{$orders.id}</td>
<td>{$orders.sellername}</td>
<td>{$orders.username}</td>
<td>{$orders.money}</td>
<td>
<switch name="orders[pay_type]">
<case value="1">微信</case>
<case value="2">现金</case>
<case value="3">泽百钱包</case>
<case value="4">泽百券</case>
</switch>
</td>
<td><if condition="$orders[status] eq 1">未完成<else />已完成</if></td>
<td>{$orders.score_before}</td>
<td>{$orders.score_after}</td>
<td>{$orders.companyname}</td>
<td>{$orders.ctime}</td>
</tr>
</volist>
</tbody>
</table>