123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193 |
- <?php
- namespace App\Http\Controllers\Web\Talent;
- use App\Http\Controllers\Web\WebBaseController;
- use App\Models\RecruitPost;
- use App\Services\Common\SmsService;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\IOFactory;
- use PhpOffice\PhpSpreadsheet\Cell\DataType;
- use PhpOffice\PhpWord\IOFactory as WordIOFactory;
- use PhpOffice\PhpWord\Settings;
- use PhpOffice\PhpWord\TemplateProcessor;
- use Illuminate\Support\Facades\DB;
- use App\Exceptions\ResponseException;
- use Illuminate\Http\Request;
- class JjhcController extends WebBaseController
- {
- private $smsService;
- public function __construct(SmsService $smsService)
- {
- $this->smsService = $smsService;
- }
- public function yqfk()
- {
- return view("app.talent.jjhc.yqfk");
- }
- public function chaxun(Request $request)
- {
- $data = array('msg'=>'查无此用户!','status' => 0);
- return response()->json($data);
- $info = DB::connection('fangyi')->table('fillinfo')
- ->where(['lxdh'=>$request->tel])->first();
- if($info){
- $data = array('status'=>1,'msg'=>'查到已存在数据!','info'=>$info);
- }else{
- $data = array('msg'=>'查无此用户!','status' => 0);
- }
- return response()->json($data);
- }
- public function test(Request $request)
- {
- $keyword = $request->input('keyword');
- if($keyword != "j0vOW5mBREZxdo3P"){
- throw new ResponseException("who are you?", [], 404);
- }
- $spreadsheet = new Spreadsheet();
- $sheet = $spreadsheet->getActiveSheet();
- $header = ['姓名','身份证','准考证','报考岗位'];
- foreach ($header as $key => $value) {
- $sheet->setCellValueByColumnAndRow($key+1, 1, $value);
- }
- $row = 2;
- $sheet->getStyle('S')->getNumberFormat()->setFormatCode('0');
- $list = DB::table("recruit_ticket")->leftJoin("recruit_appoint_info","recruit_ticket.appoint_id",'=','recruit_appoint_info.id')->where("recruit_appoint_info.recruit_id",'16')->orderBy('recruit_appoint_info.post_id','ASC')->orderBy('recruit_appoint_info.id','ASC')->get()->toArray();
- $post_data = RecruitPost::where('recruit_id',16)->where('status',1)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
- foreach ($list as $k => $v){
- $sheet->setCellValueByColumnAndRow('1',$row, $v->realname);
- $sheet->setCellValueExplicitByColumnAndRow('2',$row, $v->card,DataType::TYPE_STRING);
- $sheet->setCellValueExplicitByColumnAndRow('3',$row, $v->ex_number,DataType::TYPE_STRING);
- $sheet->setCellValueByColumnAndRow('4',$row, $post_data[$v->post_id]);
- $row++;
- }
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header('Content-Disposition: attachment;filename="'.time().'.xlsx"');
- header('Cache-Control: max-age=0');
-
- header('Cache-Control: max-age=1');
-
- header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
- header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
- header('Cache-Control: cache, must-revalidate');
- header('Pragma: public');
- $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
- $writer->save('php://output');
- echo "success";
- }
- }
|