PHP自定义导出
2021/7/26 11:07:05
本文主要是介绍PHP自定义导出,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
field参数是逗号隔开传过来的
$params = request()->param(); $info = array('name'=>'*姓名','card_no'=>'*身份证号','company'=>'*单位','duties'=>'*职务','guest_source'=>'*嘉宾来源','guests_type'=>'嘉宾类型','sex'=>'*性别(男/女)','nation'=>'*民族(汉族)','phone'=>'*联系电话','is_driver'=>'*是否自驾','public_transport'=>'*公共交通工具','train_number'=>'*抵达车次/航班','train_time'=>'*抵达时间(年-月-日 时:分:秒)','is_station'=>'*是否接站(是/否)','station_address'=>'*接站地点','special_request'=>'特殊要求','invite_soucre'=>'邀请来源','is_check_status'=>'*签到状态','check_address'=>'签到地点','check_mode'=>'签到方式','hotel_name'=>'住宿酒店','type'=>'房间类型','room_number'=>'房间号','observation_group'=>'观摩组','vehicle_number'=>'观摩分车','restaurant_name'=>'用餐场地','table'=>'用餐桌号','username'=>'一对一接待员','remarks'=>'备注'); $field = \explode(',',$params['field']); foreach($field as $key => $value){ $res[$key+1] = $info[$value]; } $header = ['序号']+$res; $data = ReceiptGuestModel::receiptGuestExport($params); foreach($data as $key => $value){ switch ($value['sex']) { case 1: $data[$key]['sex'] = '男'; break; case 2: $data[$key]['send_mode'] = '女'; break; } switch ($value['is_driver']) { case 1: $data[$key]['is_driver'] = '是'; break; case 2: $data[$key]['is_driver'] = '否'; break; } switch ($value['is_station']) { case 1: $data[$key]['is_station'] = '是'; break; case 2: $data[$key]['is_station'] = '否'; break; } switch ($value['is_check_status']) { case 1: $data[$key]['is_check_status'] = '已签到'; break; case 2: $data[$key]['is_check_status'] = '未签到'; break; } switch ($value['check_mode']) { case 0: $data[$key]['check_mode'] = ''; break; case 1: $data[$key]['check_mode'] = '手机号'; break; case 2: $data[$key]['check_mode'] = '二维码'; break; case 3: $data[$key]['check_mode'] = '后台'; break; case 4: $data[$key]['check_mode'] = '闸机'; break; } } foreach($data as $key => $value){ $record = []; $record['xuhao'] = $key+1; foreach($field as $k => $v){ $record[$v] = $value[$v]; } $body[] = $record; }
这篇关于PHP自定义导出的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-03-29env: php: no such file or directory
- 2024-03-01php foreach break
- 2024-02-26Exception参数 php-icode9专业技术文章分享
- 2023-12-30PHP文件批量上传-icode9专业技术文章分享
- 2023-12-30thinkphp6 withJoin-icode9专业技术文章分享
- 2023-12-27MagicArray:像php一样,让Go业务代码不再卷!
- 2023-11-18centos7编译安装PHP教程。
- 2023-11-18centos7编译安装phpMyAdmin教程。
- 2023-10-13唱衰这么多年,PHP 仍然还是你大爷!
- 2023-07-25PHP8,性能更好,语法更好,类型安全更完善