public function anexos(Request $request, $technical_consult_id = null, $email_message_id = null)
 {
     $email = EmailMessage::find($email_message_id);
     if ($email) {
         return view('arquivos.table')->with('files', $email->attachments);
     } else {
         return null;
     }
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request, Validator $validator)
 {
     $data = $request->all();
     if (!isset($data['email_message']['project_id'])) {
         return 'Informe a obra';
     }
     $obra = Obra::find(@$data['email_message']['project_id']);
     $data['technical_consult']['cod'] = $obra->consultas_tecnicas->max('cod') + 1;
     switch (@$data['email_message']['type']) {
         case 0:
             // CRIA ACONTECIMENTO
             $technical_consult = ConsultaTecnica::create($data['technical_consult']);
             // CRIA EMAIL MESSAGE
             $email_message = new EmailMessage();
             break;
         case 2:
             // REGISTRAR RETORNO
             $technical_consult = ConsultaTecnica::find($data['technical_consult']['id']);
             // CRIA EMAIL MESSAGE
             $email_message = new EmailMessage();
             $email_message->email_message_id = $data['email_message']['email_message_id'];
             break;
         default:
             // CRIA CONSULTA TÉCNICA
             $technical_consult = new ConsultaTecnica();
             $technical_consult->owner_id = $request->user()->id;
             $technical_consult->color = (new Alfred())->randomColor();
             $technical_consult->project_id = @$data['technical_consult']['project_id'];
             $technical_consult->project_stage_id = @$data['technical_consult']['project_stage_id'];
             $technical_consult->project_discipline_id = @$data['technical_consult']['project_discipline_id'];
             $technical_consult->title = @$data['technical_consult']['title'];
             $technical_consult->cod = $data['technical_consult']['cod'];
             $technical_consult->save();
             // CRIA EMAIL MESSAGE
             $email_message = new EmailMessage();
             break;
     }
     if (isset($data['email_message']['date'])) {
         $date = str_replace('/', '-', $data['email_message']['date']);
     } else {
         $date = date('Y-m-d');
     }
     $data['email_message']['date'] = empty($data['email_message']['date']) ? date('Y-m-d') : date('Y-m-d', strtotime($date));
     $data['email_message']['time'] = empty($data['email_message']['time']) ? date('H:i') : $data['email_message']['time'];
     $email_message->date = date('Y-m-d H:i:s', strtotime($data['email_message']['date'] . ' ' . $data['email_message']['time']));
     // DADOS PARA O CORPO DO EMAIL
     $email_data = $data['email_message'];
     $email_data['obra'] = $technical_consult->project->title;
     $email_data['subject'] = $technical_consult->title;
     $email_data['consulta_tecnica_id'] = $technical_consult->formattedCod('CT #');
     $email_data['etapa'] = $technical_consult->projectstage ? $technical_consult->projectstage->title : '';
     $email_data['disciplina'] = $technical_consult->projectdiscipline ? $technical_consult->projectdiscipline->title : '';
     $email_data['body_html'] = $email_data['description'];
     // dd($email_data);
     $contatos = array();
     $email_data_to['contato_emails'] = array();
     $email_message->type = null !== @$email_data['type'] ? $email_data['type'] : 1;
     if (null == @$email_data['to']) {
         $email_data['to'] = EmailMessage::find($email_message->email_message_id)->to;
         $email_data['to'] = explode(',', @$email_data['to']);
     }
     foreach ($email_data['to'] as $contato_id) {
         $contato = Contato::find($contato_id);
         if (null !== $contato) {
             $contatos[] = $contato;
             $email_data_to['contato_emails'][] = $contato->email;
         }
     }
     $email_message->to = implode(',', $email_data_to['contato_emails']);
     $email_message->from = $request->user()->email;
     $email_message->subject = $email_data['subject'];
     $email_message->consulta_tecnica_id = $technical_consult->id;
     $email_message->owner_id = $request->user()->id;
     $email_message->body_html = $email_data['description'];
     $email_message->rating = @$email_data['rating'];
     $email_message->private = null === @$email_data['private'] ? false : true;
     // SALVA EMAIL MESSAGE
     $email_message->save();
     if (!$technical_consult) {
         $this->sys_notifications[] = array('type' => 'danger', 'message' => 'Erro ao adicionar consulta técnica');
         $request->session()->flash('sys_notifications', $this->sys_notifications);
         return back()->withInput($request->all());
     }
     if (!$email_message) {
         $this->sys_notifications[] = array('type' => 'danger', 'message' => $validator->errors()->first());
         $request->session()->flash('sys_notifications', $this->sys_notifications);
         return back()->withInput($request->all());
     }
     // ENVIAR EMAIL
     if ($email_message->type == 1 && "on" == @$data['sendnow']) {
         // ATTACH FILES
         $files = $request->file('file');
         if ($files[0] != null) {
             $filesupload = (new FileEntryController())->upload($request, false, $email_message->id);
             if ($filesupload['uploaded'] > 0) {
                 // $this->sys_notifications[] = array('type' => 'success', 'message' => $filesupload['uploaded'] . ' arquivos anexados');
             }
         }
         $anexos = array();
         if (!empty($filesupload['ids'])) {
             foreach ($filesupload['ids'] as $key => $fileid) {
                 $entry = FileEntry::find($fileid);
                 $entry->email_message_id = $email_message->id;
                 $entry->save();
                 $anexos[] = $entry;
             }
         }
         // SEND MAIL TO ME
         if (null !== @$data['sendtome']) {
             $email_data['bcc'] = $request->user()->email;
         }
         // PROCESS THE JOB
         $this->dispatch(new SendEmail($email_data, $anexos, $request, $email_message, $technical_consult, $contatos));
         // return view('emails.message', compact('email_data', 'anexos', 'request', 'email_message', 'technical_consult', 'contatos'));
         $this->sys_notifications[] = array('type' => 'success', 'message' => 'E-mail enviado!');
     }
     $this->sys_notifications[] = array('type' => 'success', 'message' => 'Consulta Técnica registrada com sucesso!');
     $request->session()->flash('sys_notifications', $this->sys_notifications);
     return redirect('obras/' . $technical_consult->project_id);
 }