public function getEiProjet($project_id, $project_ref, $ei_user)
{
$query = " SELECT projet.*\n \n FROM ei_projet projet\n LEFT JOIN ei_project_user puser \n \n ON puser.project_id = projet.project_id AND puser.project_ref = projet.ref_id\n WHERE puser.user_id =" . $ei_user->getUserId() . "\n AND puser.user_ref =" . $ei_user->getRefId() . "\n AND projet.project_id = " . $project_id . "\n AND projet.ref_id = " . $project_ref;
$projet = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAll($query);
if (count($projet) == 0) {
return null;
}
$projet = $projet[0];
$eiProjet = new EiProjet();
$eiProjet->setArray($projet);
return $eiProjet;
}