1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
public function getDomainesDetails($langCode, $isObject= true){
$sql = "SELECT {$this->alias}.`domaineId` as id,
{$this->alias}.`domaineParentId` as parent,
{$this->alias}.`domaineDateCreation`,
{$this->alias}.`domaineDateModif`,
dt.`domaineTextId`,
dt.`domaineId`,
dt.`langCode`,
dt.`domaineTitre` as name,
dt.`domaineMetaTitle`,
dt.`domaineMetaKeywords`,
dt.`domaineMetaDescription`,
dt.`domaineAliasUrl`,
(SELECT COUNT(offreId) FROM recrutement_offre o WHERE o.`domaineId` = {$this->alias}.`domaineId` AND dt.langCode = '{$langCode}' AND o.`offreActive` = 1 ) as nbOffres
FROM `{$this->table}` {$this->alias}
INNER JOIN `recrutement_domaine_text` dt ON {$this->alias}.`domaineId` = dt.`domaineId`
LEFT JOIN `thermidor_language` l ON dt.`langCode` = l.`langCode`
WHERE dt.langCode = '{$langCode}'
";
if($results = Database::execute_sql($sql))
return $this->parseResults($results, $isObject);
} |
Partager