从github下载PHPExcel:PHPExcel
将下载好的PHPExcel文件夹跟PHPExcel放置在框架中的Vendor目录下,注意目录的结构,按照我的代码来基本上直接引用就能使用,附上结构,如下图:
1、如果使用Ajax请求:
Html代码部分:
<form class="layui-form " method="post">
<div class="layui-input-inline w150">
<select name="status" id="sel">
<option value="">选择状态</option>
<option value="0" {if condition="$param['status'] eq '0'"}selected {/if}>未审核</option>
<option value="1" {if condition="$param['status'] eq '1'"}selected {/if}>已审核</option>
</select>
</div>
<div class="layui-input-inline w150">
<select name="group" id="group">
<option value="">选择会员组</option>
{volist name="group_list" id="vo"}
<option value="{$vo.group_id}" {if condition="$param['group'] eq $vo.group_id"}selected {/if}>{$vo.group_name}</option>
{/volist}
</select>
</div>
<div class="layui-input-inline w320">
<input size="16" type="text" value="{$start_time}" id="datetimeStart" readonly class="form_datetime" name="start_time" placeholder="请选择开始时间" style="height: 38px;" />
-
<input size="16" type="text" value="{$end_time}" id="datetimeEnd" readonly class="form_datetime" name="end_time" placeholder="请选择结束时间" style="height: 38px;" />
</div>
<div class="layui-input-inline">
<input type="text" autocomplete="off" placeholder="请输入搜索条件" class="layui-input" name="wd" value="{$param['wd']}">
</div>
<button class="layui-btn mgl-20 j-search" >查询</button>
<button class="layui-btn mgl-20" type="button" id="btnExport" onclick="excel()">导出</button>
</form>
Js部分代码:
//Excel导出事件
function excel()
{
var status = $("#sel option:selected").val();
var group = $("#group option:selected").val();
var start_time = $('#datetimeStart').val();
var end_time = $('#datetimeEnd').val();
$.ajax({
url: "{:url('admin/user/export')}",
d