public function getLocation() { $nhserver = Nhserver::find($this->location_id); if ($nhserver) { return $nhserver->province; } return ''; }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function update(Request $request) { // $input = $request->all(); $messages = array('host.required' => '请填写服务器!', 'port.required' => '请填写端口!', 'province.required' => '请填写所在省!'); $validator = $this->getValidationFactory()->make($input, ['host' => 'required', 'port' => 'required', 'province' => 'required'], $messages); if ($validator->fails()) { $messages = $validator->messages(); return $messages; } $id = $request->id; $nhserver = Nhserver::find($id); $nhserver->host = $request->host; $nhserver->port = $request->port; $nhserver->province = $request->province; $nhserver->save(); echo json_encode("1"); }
public function export(Request $request) { $tag = $request->tag; $ids = $request->session()->get($tag . '.tids', array()); // if(count($ids) == 0){ // return json_encode(array('msg'=>'请选择要导出的数据')); // } $heads = ['location', 'time_log', 'WFormId', 'Identifier', 'WFormSetTime', 'ReplyDue', 'IsChecked', 'ArriveDue', 'WFormContent', 'OrgName', 'InstallAddress', 'ModelId', 'BrandId', 'Engineer', 'RepairCreateTime', 'RespTime', 'ArrivalTime', 'RepairformSts', 'MaintianComTel', 'GivenArrivalTime', 'Mobile', 'ebs_id']; $cellData[] = $heads; foreach ($ids as $id) { $ticket = Ticket::find($id); $location = ''; if ($ticket->location_id != 0) { $nhserver = Nhserver::find($ticket->location_id); if ($nhserver) { $location = $nhserver->province; } } $cell = [$location, $ticket->time_log, $ticket->WFormId, $ticket->Identifier, $ticket->WFormSetTime, $ticket->ReplyDue, $ticket->IsChecked, $ticket->ArriveDue, $ticket->WFormContent, $ticket->OrgName, $ticket->InstallAddress, $ticket->ModelId, $ticket->BrandId, $ticket->Engineer, $ticket->RepairCreateTime, $ticket->RespTime, $ticket->ArrivalTime, $ticket->RepairformSts, $ticket->MaintianComTel, $ticket->GivenArrivalTime, $ticket->Mobile, $ticket->ebs_id]; $cellData[] = $cell; } Excel::create(time(), function ($excel) use($cellData) { $excel->sheet('data', function ($sheet) use($cellData) { $sheet->rows($cellData); }); })->export('xls'); }
public function export(Request $request) { $tag = $request->tag; $ids = $request->session()->get($tag . '.tids', array()); // if(count($ids) == 0){ // return json_encode(array('msg'=>'请选择要导出的数据')); // } $heads = ['地区', '记录时间', '工单编号', '前置编号', '工单开始时间', '未响应时间', '是否响应', '到场超时时间', '故障内容', '机构名称', '安装地址', '型号', '品牌', '反馈工程师', '报修时间', '响应时间', '到场认证时间', '报修状态', '厂商的维保电话', '厂商给出的预计到达时间', '农行报修人的电话', 'EBS返回的编码']; $cellData[] = $heads; foreach ($ids as $id) { $ticket = Ticket::find($id); $location = ''; if ($ticket->location_id != 0) { $nhserver = Nhserver::find($ticket->location_id); if ($nhserver) { $location = $nhserver->province; } } $cell = [$location, $ticket->time_log, $ticket->WFormId, $ticket->Identifier, $ticket->WFormSetTime, $ticket->ReplyDue, $ticket->IsChecked, $ticket->ArriveDue, $ticket->WFormContent, $ticket->OrgName, $ticket->InstallAddress, $ticket->ModelId, $ticket->BrandId, $ticket->Engineer, $ticket->RepairCreateTime, $ticket->RespTime, $ticket->ArrivalTime, $ticket->RepairformSts, $ticket->MaintianComTel, $ticket->GivenArrivalTime, $ticket->Mobile, $ticket->ebs_id]; $cellData[] = $cell; } Excel::create(time(), function ($excel) use($cellData) { $excel->sheet('data', function ($sheet) use($cellData) { $sheet->rows($cellData); }); })->export('xls'); }