public function update($id, Request $request)
 {
     $hbl = Hbl::findOrFail($id);
     $hbl->update($request->all());
     Session::flash('flash_message', 'Hbl successfully updated!');
     return redirect('mbl');
 }
 public function concluirfaturamentomaritimo(Request $request)
 {
     $ag = $request->agente;
     $agente = DB::table('agentes')->where('nome', '=', $ag)->get();
     foreach ($agente as $item) {
     }
     $valor = $item->valordesconsolmaritimo;
     $nf = $request->nf;
     $regselect = $request->admin;
     if ($nf == '') {
         return redirect('notafiscal');
     }
     $nota = DB::table('notafiscals')->where('numero', '=', $nf)->get();
     foreach ($nota as $item) {
     }
     $id = $item->id;
     $data = $item->data;
     foreach ($regselect as $key) {
         $registroshbl = Hbl::findOrFail($key);
         DB::table('hbls')->where('id', '=', $registroshbl->id)->update(['notafiscal_id' => $id, 'faturado' => '1', 'finalizado' => '1', 'vlrDesconsol' => $valor, 'dataFaturamento' => $data]);
         DB::table('faturamentos')->where('hbl_id', '=', $key)->update(['status' => '1']);
         $mbl = DB::table('mbls')->where('NMbl', '=', $registroshbl->NMbl)->get();
         foreach ($mbl as $key1) {
         }
         DB::table('mbls')->where('id', '=', $key1->id)->update(['id_notafiscal' => $id, 'faturado' => '1', 'finalizado' => '1', 'dataFaturamento' => $data]);
     }
     $notafiscals = notafiscal::find($id);
     $registros = $notafiscals->hbls;
     DB::table('notafiscals')->where('id', '=', $id)->update(['status' => '1']);
     return view('faturamento.faturadomaritimo', compact('registros'));
 }