控制器php
/**
* 列表
*/
public function index(){
$type=input('type');
$url='https://'.$_SERVER['SERVER_NAME'].'/admin/liqu/index/type/';
if($type=="" || $type==-1){
$data['type']=1;
$type=-1;
}
else{
$data['type']=1;
$data['is_hexiao']=$type;
}
$list = Db::name('hexiao')->where($data)->paginate(10);
$page =$list->render();
$list_to_array = $list->toArray();
foreach($list_to_array['data'] as $kk=>$vv){
$list_to_array['data'][$kk]['liqu_addtime']=date('Y-m-d H:i:s',$vv['liqu_addtime']);
if($vv['hexiao_addtime']){
$list_to_array['data'][$kk]['hexiao_addtime']=date('Y-m-d H:i:s',$vv['hexiao_addtime']);
}else{
$vv['hexiao_addtime']='';
}
}
$this->assign('list', $list_to_array['data']);
$this->assign("page",$page);
$this->assign("type",$type);
$this->assign("url",$url);
return $this->fetch();
}
//核销数据导出
public function daochu(){
$type=input('type');
if($type=="" || $type==-1){
$data['type']=1;
}
else{
$data['type']=1;
$data['is_hexiao']=$type;
}
$list = Db::name('hexiao')->where($data)->select();
foreach($list as $kk=>$vv){
$list[$kk]['liqu_addtime']=date('Y-m-d H:i:s',$vv['liqu_addtime']);
if($vv['hexiao_addtime']){
$list[$kk]['hexiao_addtime']=date('Y-m-d H:i:s',$vv['hexiao_addtime']);
}else{
$vv['hexiao_addtime']='';
}
}
$date_time=date('Y-m-d H:i:s',time());
require_once './PHPExcel-1.8/Classes/PHPExcel.php';//引入PHPExcel.php
$resultPHPExcel = new \PHPExcel();
//设值
$resultPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
$resultPHPExcel->getActiveSheet()->setCellValue('B1', '礼包名称');
$resultPHPExcel->getActiveSheet()->setCellValue('C1', '领取人昵称');
$resultPHPExcel->getActiveSheet()->setCellValue('D1', '领取人手机号');
$resultPHPExcel->getActiveSheet()->setCellValue('E1', '领取时间');
$resultPHPExcel->getActiveSheet()->setCellValue('F1', '是否核销');
$resultPHPExcel->getActiveSheet()->setCellValue('G1', '核销人昵称');
$resultPHPExcel->getActiveSheet()->setCellValue('H1', '核销时间');
$i = 2;
foreach ($list as $item) {
$resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $item['id']);
$resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $item['lipin_title']);
$resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $item['liqu_nickname']);
$resultPHPExcel->getActiveSheet()->setCellValue('D' . $i, $item['liqu_phone']);
$resultPHPExcel->getActiveSheet()->setCellValue('E' . $i, $item['liqu_addtime']);
if($item['is_hexiao']==0){
$resultPHPExcel->getActiveSheet()->setCellValue('F' . $i, '未核销');
}else{
$resultPHPExcel->getActiveSheet()->setCellValue('F' . $i, '已核销');
}
$resultPHPExcel->getActiveSheet()->setCellValue('G' . $i, $item['hexiao_nickaname']);
$resultPHPExcel->getActiveSheet()->setCellValue('H' . $i, $item['hexiao_addtime']);
$i++;
}
//设置导出文件名
$outputFileName = "$date_time"."到店核销礼包领取记录明细表".".xls";
$xlsWriter = new \PHPExcel_Writer_Excel5($resultPHPExcel);
ob_end_clean();
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-Disposition:inline;filename="' . $outputFileName . '"');
header("Content-Transfer-Encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$xlsWriter->save("php://output");
}
html页面:
{extend name="admin@public/base_content" /}
{block name="body">}
<body>
{include file="admin@public/common" /}
<style type="text/css">
.hexiao{
width: 100px;
height: 30px;
border: 1px solid #dedede;
}
.shaunxuan{
font-size: 16px;
margin-right: 10px;
color: #252525;
}
.tiaojian{
display: inline-block;
height: 30px;
line-height: 30px;
}
.daochu_row{
width: 100%;
padding-left: 22px;
}
</style>
<div class="daochu_row">
<div class="tiaojian">
<label class="shaunxuan">筛选:</label>
<select name="hexiao" class="hexiao" onchange="self.location.href=options[selectedIndex].value">
<option value="{$url}-1.html" {if $type==-1}selected{/if} data-type="-1">全部</option>
<option value="{$url}0.html" {if $type==0}selected{/if} data-type="0">未核销</option>
<option value="{$url}1.html" {if $type==1}selected{/if} data-type="1">已核销</option>
</select>
</div>
<a target="_blank" class="layui-btn layui-btn-small layui-btn-danger daochu" alt="$type" style="margin-left:2%;margin-top: -5px;" href="{:url('liqu/daochu',array('type'=>$type))}">导出数据</a>
</div>
<div class="layui-form">
<table class="layui-table lay-even">
<thead>
<tr>
<th width="80">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='list' id='item'}
<tr>
<td>{$item['id']}</td>
<td>{$item['lipin_title']}</td>
<td>{$item['liqu_nickname']}</td>
<td><img src="{$item['liqu_header_img']}" style="width:60px;height:60px;"/></td>
<td>{$item['liqu_phone']}</td>
<td>{$item['liqu_addtime']}</td>
{if $item['is_hexiao']==0}
<td>否</td>
{else}
<td>是</td>
{/if}
<td>{$item['hexiao_nickaname']}</td>
{if $item['hexiao_header_pic']}
<td><img src="{$item['hexiao_header_pic']}" style="width:60px;height:60px;"/></td>
{else}
<td></td>
{/if}
<td>{$item['hexiao_addtime']}</td>
</tr>
{/volist}
</tbody>
{$page}
</table>
<script>
function delCheck(id)
{
var flag=window.confirm("是否删除分类");
if(flag==true){
$.ajax({
type:"POST",
dataType: 'json',
data:{ id: id},
url:"{:url('fengyong/del')}",
success:function(data){
if(data==1){
alert('广告删除成功')
window.location.reload();//自动刷新
}else{
alert("广告删除失败!");
}
},
error:function(){
alert("广告删除失败!");
}
});
}
else{
return false;
}
}
</script>
</div>
</body>
{/block}
导出数据大佬的链接:https://blog.csdn.net/m0_45010567/article/details/105199359