public function getExportMouvementsByDate($date,$type_bon,$mission_id){
        $reqDate=' ';
        $reqMission=' ';
       
        if ($date!=NULL) {
            $reqDate = " and ms.date_depart='$date'";
        }
       
        if($mission_id!=null){
            $reqMission="  and m.mission_id=$mission_id";
        }
        $results=DB::select("SELECT DISTINCT(m.mouvement_id),
                    m.montant_total,m.montant_total_ht,
                    m.mouvement_numero_complet,m.mouvement_date_day,ms.date_depart,
                    c.contact_reference_interne,r.ressource_designation,
                    (case when c.contact_nom is not null and c.contact_prenom is not null then concat(c.contact_nom,' ',c.contact_prenom) 
                                                                else (case when c.contact_nom is not null then c.contact_nom 
                                                                                else (case when c.contact_prenom is not null then c.contact_prenom 
                                                                                                                    else c.contact_raison_sociale end) 
                                                                                                                                                    end)  
                                                                                                                                                    end) as client,
                   (case when c2.contact_nom is not null and c2.contact_prenom is not null then concat(c2.contact_nom,' ',c2.contact_prenom) 
                                                                else (case when c2.contact_nom is not null then c2.contact_nom 
                                                                                else (case when c2.contact_prenom is not null then c2.contact_prenom 
                                                                                                                    else c2.contact_raison_sociale end) 
                                                                                                                                                    end)  
                                                                                                                                                    end) as vendeur,
                             
                    c2.contact_reference_interne as code_vendeur,
                    c.contact_registre_commerce ,c.contact_numero_identification_nationale ,
                    c.contact_identification_fiscal,c.contact_article_imposition,c.contact_adresse,ci.contact_info_value
                    
                    FROM mouvement_ligne ml
                    Inner join mouvement m on m.mouvement_id=ml.mouvement_id
                    left outer join mouvement_mouvement mm on mm.mouvement_id2=m.mouvement_id 
                    left outer join mouvement m2 on m2.mouvement_id=mm.mouvement_id2
                    left outer join mission ms on ms.mission_id=m.mission_id
                    left outer join mission ms2 on ms.mission_id=m2.mission_id
                    left outer join contact c on c.contact_id=m.concern_contact_id
                    left outer join contact c2 on c2.contact_id=ms2.transporter_id
                    left outer join contact_info ci on ci.contact_id=m.concern_contact_id and ci.contact_info_type_id=123
                    left outer join ressource r on r.ressource_id=ms.vehicle_id
                 
                    where m.mouvement_type_id=$type_bon  $reqDate  $reqMission  ");
        return $results;  
    }