"barryvdh/laravel-debugbar": "^3.6",

elseif(
            //police existe 
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){

                //dd("test2");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null, $request->input('idPolice'), $etatPolice, null, null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            //police et etat existe existe 
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') != null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){

               // dd("test3"); sp_ft2_depense_contrat_rp sp_ft6_depense_familleAss_rp
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null, $request->input('idPolice'), $etatPolice, null, null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            //etatpolice existe 
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') == null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') != null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){

                //dd("test4");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null, null, $etatPolice, null, null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // souscripteur et police et college existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') != null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') != null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){
                dd("test5");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,$request->input('idSouscripteur'),$request->input('idPolice'), $etatPolice, $request->input('idCollege'), null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(

            // police et college existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') != null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){

                dd("test6");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,$request->input('idPolice'),$etatPolice , $request->input('idCollege'), null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(

            // police et college etat police  existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') != null) && 
            ($request->has('idCollege') && $request->input('idCollege') != null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){

                dd("test7");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,$request->input('idPolice'),$etatPolice , $request->input('idCollege'), null ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // demande existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') == null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') != null) &&
            ($request->has('Sorti') && $request->input('Sorti') == null)){
                dd("test8");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,null, $etatPolice, null, $request->input('dateDemande') ,null]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // sorti existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') == null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') == null) &&
            ($request->has('Sorti') && $request->input('Sorti') != null)){

                dd("test9");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,null, $etatPolice, null, null ,$request->input('Sorti')]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // sorti existe et demande
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') == null) && 
            ($request->has('idPolice') && $request->input('idPolice') == null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') != null) &&
            ($request->has('Sorti') && $request->input('Sorti') != null)){
                dd("test10");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,null, $etatPolice, null, $request->input('dateDemande') ,$request->input('Sorti')]);
    
            $beneficiaires =  collect($queryResult);
        }elseif(
            // souscripteur police demande et sorti  existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') != null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') != null) &&
            ($request->has('Sorti') && $request->input('Sorti') != null)){
                dd("test11");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,$request->input('idSouscripteur'),$request->input('idPolice'), $etatPolice, null, $request->input('dateDemande') ,$request->input('Sorti')]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // souscripteur police demande et sorti etat  existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') != null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') != null) && 
            ($request->has('idCollege') && $request->input('idCollege') == null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') != null) &&
            ($request->has('Sorti') && $request->input('Sorti') != null)){
                dd("test12");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,$request->input('idSouscripteur'),$request->input('idPolice'), $etatPolice, null, $request->input('dateDemande') ,$request->input('Sorti')]);
            $beneficiaires =  collect($queryResult);
            
        }elseif(
            // souscripteur police demande college sorti  existe
            ($request->has('idSouscripteur') && $request->input('idSouscripteur') != null) && 
            ($request->has('idPolice') && $request->input('idPolice') != null) && 
            ($request->has('codeEtatPolice') && $request->input('codeEtatPolice') == null) && 
            ($request->has('idCollege') && $request->input('idCollege') != null) &&
            ($request->has('dateDemande') && $request->input('dateDemande') != null) &&
            ($request->has('Sorti') && $request->input('Sorti') != null)){
                dd("test13");
            if ($request->input('codeEtatPolice') == 'Tout') {
                $etatPolice = null;
            }else{
                $etatPolice  = $request->input('codeEtatPolice');
            }
            $queryResult = DB::select('call sp_imprimer_assure_rp(?, ?, ?, ?, ?, ? ,?)', 
            //PARAMETRE
            [$this->currentUser->code_garant,null,null, $etatPolice, null, $request->input('dateDemande') ,$request->input('Sorti')]);
            $beneficiaires =  collect($queryResult);
            
        }else{
             $beneficiaires= null;
        }