if ($request->data == null) {
            $dia = Carbon::now()->format('Y-m-d');

            $notas = NF::leftjoin("n_v_e_s", "n_v_e_s.chave", "n_f_s.key")
                    ->leftjoin("n_f_p_d_v_e_s_s", "n_f_p_d_v_e_s_s.cnpj", "n_v_e_s.cnpj_dest")
                    ->leftjoin("clientes", "clientes.Cliente_ID", "n_f_s.client_id")
                    ->leftjoin("n_f_statuses", "n_f_statuses.id", "n_f_s.status_id")
                    ->leftjoin("n_f_obs", "n_f_obs.id", "n_f_s.obs_status_id")
                    ->leftjoin("routes", "routes.id", "n_f_s.route_id")  
                    ->leftjoin("n_f_produtos", "n_f_produtos.nfe_id", "n_v_e_s.id")               
                    //->leftjoin("n_f_produtos", "n_f_produtos.nfe_id", "n_f_s.id")            
                    //->leftjoin("dataloggers", "dataloggers.MOTORISTA_ID", "routes.driver_id")   
                    /* ->groupby(
                        "n_f_s.delivery_date", "clientes.Cliente_Nome", "clientes.Cliente_ID",
                                "n_f_s.nf as NF", "n_f_statuses.name as NF_Status",
                                "n_f_s.horariodata_entrega", "n_f_obs.name",
                                //"dataloggers.TEMPERATURA", "n_f_s.nfphoto",
                                "n_f_s.nfphoto",
                                "n_f_s.id as canhotoid", "n_f_s.status_id", "n_f_s.id as id_nf",
                                "n_v_e_s.chave", "n_f_produtos.nome_produto"
                    ) */
                    ->where("n_v_e_s.cnpj_dest", $request->session()->get('usuario'))              
                    ->whereDate("n_f_s.delivery_date",  Carbon::now()->format('Y-m-d'))
                    ->select("delivery_date", "Cliente_Nome", "clientes.Cliente_ID as Cliente",
                                "n_f_s.nf as NF", "n_f_statuses.name as NF_Status",
                                "n_f_s.horariodata_entrega", "n_f_obs.name as Obs_Status",
                                "n_f_s.nfphoto",
                                "n_f_s.status_id", "n_f_s.id as id_nf",
                                "n_v_e_s.chave"
                            ) 
                    ->groupby(
                        "n_f_s.delivery_date", "clientes.Cliente_Nome", "clientes.Cliente_ID",
                                "n_f_s.nf", "n_f_statuses.name",
                                "n_f_s.horariodata_entrega", "n_f_obs.name",
                                "n_f_s.nfphoto",
                                "n_f_s.status_id", "n_f_s.id",
                                "n_v_e_s.chave"
                    ) 
                    ->when($notaNome, function ($query) use ($notaNome) {
                        return $query->where('n_v_e_s.nf', $notaNome);
                    })
                    ->get();
            
        }else{
            
            $dia = $request->data;
            

            $notas = NF::leftjoin("n_v_e_s", "n_v_e_s.chave", "n_f_s.key")
                    ->leftjoin("n_f_p_d_v_e_s_s", "n_f_p_d_v_e_s_s.cnpj", "n_v_e_s.cnpj_dest")
                    ->join("clientes", "clientes.Cliente_ID", "n_f_s.client_id")
                    ->join("n_f_statuses", "n_f_statuses.id", "n_f_s.status_id")
                    ->leftjoin("n_f_obs", "n_f_obs.id", "n_f_s.obs_status_id")
                    ->leftjoin("routes", "routes.id", "n_f_s.route_id")            
                    ->leftjoin("n_f_produtos", "n_f_produtos.nfe_id", "n_v_e_s.id")     
                    ->select("delivery_date", "Cliente_Nome", "clientes.Cliente_ID as Cliente",
                                "n_f_s.nf as NF", "n_f_statuses.name as NF_Status",
                                "n_f_s.horariodata_entrega", "n_f_obs.name as Obs_Status",
                                "n_f_s.nfphoto",
                                "n_f_s.status_id", "n_f_s.id as id_nf",
                                "n_v_e_s.chave"
                            )       
                    ->groupby(
                        "n_f_s.delivery_date", "clientes.Cliente_Nome", "clientes.Cliente_ID",
                                "n_f_s.nf", "n_f_statuses.name",
                                "n_f_s.horariodata_entrega", "n_f_obs.name",
                                "n_f_s.nfphoto",
                                "n_f_s.status_id", "n_f_s.id",
                                "n_v_e_s.chave"
                    )                   
                    ->where("n_v_e_s.cnpj_dest", $request->session()->get('usuario'))                    
                    ->when($notaNome, function ($query) use ($notaNome) {
                        return $query->where('n_v_e_s.nf', $notaNome);
                    })
                    ->when($cliente_id, function ($query) use ($cliente_id) {
                        return $query->where('n_v_e_s.cliente_id', $cliente_id);
                    })
                    ->when($dia, function ($query) use ($dia) {
                        return $query->whereDate("n_f_s.delivery_date", $dia);
                    })
                    ->when($produtos, function ($query) use ($produtos) { 
                        return $query->where("n_f_produtos.nome_produto", 'LIKE', "%{$produtos}%");
                    })
                    ->get();
                    
        }