/**
* 导出店铺csv
*/
public function export_csv(){
$where = array();//搜索条件
$shop_name = I('shop_name');//接收搜索条件
$manager_name = I('manager_name');
$order_ids = I('order_ids');
if($shop_name){
$where['shop_name'] = ['like','%'.$shop_name.'%'];
}
if($manager_name){
$where['manager_name'] = ['like','%'.$manager_name.'%'];
}
if($order_ids){
$where['id'] = ['in', $order_ids];
}
$userList = M('shop')->where($where)->order('id')->limit($start.','.$end)->select();//查出需要导出的数据
header('Content-Type: application/vnd.ms-excel'); //header设置
header("Content-Disposition: attachment;filename=".$fileName.".csv");
header('Cache-Control: max-age=0');
$fp = fopen('php://output','a'); //打开php文件句柄,php://output表示直接输出到PHP缓存,a表示将输出的内容追加到文件末尾
$head = array('店铺ID','店铺名称','掌柜ID','累计订单任务量','完成任务量','订单任务金额','实际完成任务金额'); //表头信息
foreach($head as $k=>$v){
$head[$k] = iconv("UTF-8","GBK//IGNORE",$v); //将utf-8编码转为gbk。理由是: Excel 以 ANSI 格式打开,不会做编码识别。如果直接用 Excel 打开 UTF-8 编码的 CSV 文件会导致汉字部分出现乱码。
}
fputcsv($fp,$head); //fputcsv() 函数将行格式$head化为 CSV 并写入一个打开的文件$fp。
if (!empty($userList)) {
$data = []; //要导出的数据的顺序与表头一致;提前将最后的值准备好(比如:时间戳转为日期等)
foreach ($userList as $key => $val) {
$data['id'] = "xm-".$val['id'];
$data['shop_name'] = $val['shop_name'];
$data['manager_name'] = $val['manager_name'];
$data['task_num'] = $val['task_num'];
$data['finish_task'] = $val['finish_task'];
$data['all_money'] = (float)$val['all_money'];
$data['finish_money'] = $val['finish_money'];
foreach($data as $i=> $item){ //$item为一维数组哦
$data[$i] = iconv("UTF-8","GBK//IGNORE",$item); //转为gbk的时候可能会遇到特殊字符‘-’之类的会报错,加 ignore表示这个特殊字符直接忽略不做转换。
}
fputcsv($fp,$data);
}
exit; //记得加这个,不然会跳转到某个页面。
}
}