tp中导出数据表格

 

 

 前端页面

//前端页面form表单提交条件到控制器

<form action="__CONTROLLER__/exp_acc" method="post" style="float:right;width:180px;">
<input type="hidden" name="s_time" value="{$_GET['act_start_time']}">
<input type="hidden" name="e_time" value="{$_GET['act_stop_time']}">
<input class="btn btn-primary btn6 mr10" value="下载表格Excel" type="submit">
</form>

 

 

 

 

//后台控制器

function exp_acc(){//导出Excel
$xlsName = "Account";
$xlsCell = array(
array('flag','状态'),
array('username','客户姓名'),
array('phone','联系电话'),
array('kind','消费项目'),
array('money','金额'),
array('collect_way','收款方式'),
array('collect_meb','操作人'),
array('shui_tea','水浴师'),
array('addtime','添加时间'),
);
$xlsModel = M('account');
$s_time = strtotime($_POST['s_time']).'<br/>';
$e_time = strtotime($_POST['e_time']); 

if ($_POST) {
//die('11');
/*$xlsData = $xlsModel ->Field('flag, kind, money, collect_way, collect_meb, addtime')->where(" addtime >='$s_time' && addtime <='$e_time' ") ->select();*/
$xlsData = $xlsModel ->where(" addtime >='$s_time' && addtime <='$e_time' ") -> order('addtime desc')->select();
}
foreach ($xlsData as $k => $v)
{
$xlsData[$k]['addtime']= date("Y-m-d h:i:s", $v['addtime']);
$xlsData[$k]['money'] = $v['money'].'元';
if($v['flag']== 1){
$xlsData[$k]['flag']= '消费';
}elseif($v['flag']== 2){
$xlsData[$k]['flag']= '退款';
}else{
$xlsData[$k]['flag']= '充值';
}
if($v['collect_way']== 0){
$xlsData[$k]['collect_way']= '微信';
}elseif($v['collect_way']== 1){
$xlsData[$k]['collect_way']= '支付宝';
}elseif($v['collect_way']== 2){
$xlsData[$k]['collect_way']= '现金';
}else{
$xlsData[$k]['collect_way']= '刷卡';
}
$uid = $v['uid'];
$res = M('user')->find($uid);
$xlsData[$k]['username'] = $res['u_name'];
$xlsData[$k]['phone'] = $res['u_phone'];

}
/*dump($xlsData);
die;*/
$this->exportExcel($xlsName,$xlsCell,$xlsData);
}