| | |
| | | $writer->save('php://output'); |
| | | } |
| | | |
| | | /** |
| | | * 连盟活动报名列表导出 |
| | | */ |
| | | public function activityUserList($list) |
| | | { |
| | | $spreadsheet = new Spreadsheet(); |
| | | $sheet = $spreadsheet->getActiveSheet(); |
| | | |
| | | //设置工作表标题名称 |
| | | $sheet->setTitle('活动报名记录表'); |
| | | |
| | | $sheet->setCellValue('A1', '用户id'); |
| | | $sheet->setCellValue('B1', '昵称'); |
| | | $sheet->setCellValue('C1', '姓名'); |
| | | $sheet->setCellValue('D1', '手机号'); |
| | | $sheet->setCellValue('E1', '报名状态'); |
| | | $sheet->setCellValue('F1', '报名时间'); |
| | | $sheet->setCellValue('G1', '活动ID'); |
| | | $sheet->setCellValue('H1', '活动标题'); |
| | | |
| | | //填充数据 |
| | | $index = 0; |
| | | foreach ($list as $item) { |
| | | $sheet->setCellValue('A' . ($index + 2), $item['user_id']); |
| | | $sheet->setCellValue('B' . ($index + 2), $nickName); |
| | | $sheet->setCellValue('C' . ($index + 2), $item['real_name']); |
| | | $sheet->setCellValue('D' . ($index + 2), $item['mobile']); |
| | | $sheet->setCellValue('E' . ($index + 2), $item['status_text']); |
| | | $sheet->setCellValue('F' . ($index + 2), $item['create_time']); |
| | | $sheet->setCellValue('G' . ($index + 2), $item['activity_id']); |
| | | $sheet->setCellValue('H' . ($index + 2), $item['activity']['name']); |
| | | $index++; |
| | | } |
| | | |
| | | //保存文件 |
| | | $writer = new Xlsx($spreadsheet); |
| | | $filename = iconv("UTF-8", "GB2312//IGNORE", '活动报名记录表') . '-' . date('YmdHis') . '.xlsx'; |
| | | |
| | | |
| | | header('Content-Type: application/vnd.ms-excel'); |
| | | header('Content-Disposition: attachment;filename="' . $filename . '"'); |
| | | header('Cache-Control: max-age=0'); |
| | | $writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); |
| | | $writer->save('php://output'); |
| | | } |
| | | |
| | | public function cutStr($str, $maxLength) { |
| | | $str=$this->filterEmoji($str); |