| | |
|---|
| | | { |
|---|
| | | $spreadsheet = new Spreadsheet(); |
|---|
| | | $sheet = $spreadsheet->getActiveSheet(); |
|---|
| | | |
|---|
| | | $title = $list[0]['activity']['branch']['name'] . '-' . $list[0]['activity']['name'] . '-' . '活动报名记录表'; |
|---|
| | | //设置工作表标题名称 |
|---|
| | | $sheet->setTitle('活动报名记录表'); |
|---|
| | | $sheet->setTitle($title); |
|---|
| | | |
|---|
| | | $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', '活动标题'); |
|---|
| | | |
|---|
| | | /*$sheet->setCellValue('A1', '用户id'); |
|---|
| | | $sheet->setCellValue('B1', '昵称');*/ |
|---|
| | | $sheet->setCellValue('A1', '姓名'); |
|---|
| | | $sheet->setCellValue('B1', '手机号'); |
|---|
| | | $sheet->setCellValue('C1', '邀请人'); |
|---|
| | | $sheet->setCellValue('D1', '邀请人手机号'); |
|---|
| | | $sheet->setCellValue('E1', '所属分会');/* |
|---|
| | | $sheet->setCellValue('F1', '报名状态'); |
|---|
| | | $sheet->setCellValue('G1', '报名时间'); |
|---|
| | | $sheet->setCellValue('H1', '活动ID'); |
|---|
| | | $sheet->setCellValue('I1', '活动标题');*/ |
|---|
| | | foreach(range('A','E') as $columnID) { |
|---|
| | | $sheet->getColumnDimension($columnID)->setAutoSize(true); |
|---|
| | | } |
|---|
| | | //填充数据 |
|---|
| | | $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']); |
|---|
| | | $sheet->setCellValue('A' . ($index + 2), $item['real_name']); |
|---|
| | | $sheet->setCellValueExplicit('B' . ($index + 2), $item['mobile'] , \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); |
|---|
| | | $sheet->setCellValue('C' . ($index + 2), $item['recommend_name']); |
|---|
| | | $sheet->setCellValueExplicit('D' . ($index + 2), $item['recommend_mobile'] , \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING); |
|---|
| | | |
|---|
| | | $sheet->setCellValue('E' . ($index + 2), empty($item['branch']) ? '无' : $item['branch']['name']);/* |
|---|
| | | $sheet->setCellValue('F' . ($index + 2), $item['status_text']); |
|---|
| | | $sheet->setCellValue('G' . ($index + 2), $item['create_time']); |
|---|
| | | $sheet->setCellValue('H' . ($index + 2), $item['activity_id']); |
|---|
| | | $sheet->setCellValue('I' . ($index + 2), $item['activity']['name']);*/ |
|---|
| | | $index++; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //保存文件 |
|---|
| | | $writer = new Xlsx($spreadsheet); |
|---|
| | | $filename = iconv("UTF-8", "GB2312//IGNORE", '活动报名记录表') . '-' . date('YmdHis') . '.xlsx'; |
|---|
| | | $filename = iconv("UTF-8", "GB2312//IGNORE", $title) . '-' . date('YmdHis') . '.xlsx'; |
|---|
| | | |
|---|
| | | |
|---|
| | | header('Content-Type: application/vnd.ms-excel'); |
|---|
