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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
<?php
/**
* @desc This file was generated from Database class
*
* */
class RecrutementCandidature extends BaseRecrutementCandidature {
public function __construct() {
parent::__construct();
}
public function __destruct() {
parent::__destruct();
}
public function listCand(){
$sql = " SELECT *
FROM `{$this->table}` {$this->alias}";
if($rc = Database::execute_sql($sql))
$reponses = $this->parseResults($rc);
}
/**
* Enter description here ...
* @desc Liste des dernières candidatures en fonction de la langue
* @param string $langCode
* @param int $activatePages (0 / 1)
* @param int $page
* @param int $rowPerPage
* @return object result
*/
public function getLastCand($langCode, $activatePages=0, $page=0, $rowPerPage=0, $isObject=true){
$sql = " SELECT {$this->alias}.`candidatId`,
{$this->alias}.`offreId`,
{$this->alias}.`candidatNom`,
{$this->alias}.`candidatPrenom`,
{$this->alias}.`candidatCv`,
{$this->alias}.`candidatLm`,
{$this->alias}.`candidatDate`,
{$this->alias}.`langCode`,
ot.`offreTitre`";
$sqlTmp = " FROM `{$this->table}` {$this->alias}
LEFT JOIN `thermidor_language` l ON {$this->alias}.`langCode` = l.`langCode`
LEFT JOIN `recrutement_offre_text` ot
ON {$this->alias}.`offreId` = ot.`offreId`
AND ot.`langCode` = l.`langCode`
WHERE {$this->alias}.langCode = '{$langCode}'
";
$sql .= $sqlTmp;
$sql .= "ORDER BY {$this->alias}.`candidatDate` DESC";
$page == "" ? $page = 0 : $page-1;
if($activatePages == 1){
$sql .= " LIMIT {$page}, {$rowPerPage} ";
}
if($activatePages == 1){
$sqlMax = "SELECT COUNT({$this->alias}.`candidatId`) as count ";
$sqlMax .= $sqlTmp;
$resMax = Database::execute_sql($sqlMax);
$reponseMax = $this->parseResult($resMax, $isObject);
}
if($rc = Database::execute_sql($sql))
$reponses = $this->parseResults($rc,$isObject);
if($activatePages == 1){
if($isObject == false){
return array($reponses, $reponseMax['count'], $rowPerPage);
}else{
return array($reponses, $reponseMax->count, $rowPerPage);
}
}else{
return $reponses;
}
}
} |
Partager