/**
* Recover all the rector from one church
*
* @author Jonathan Sandoval <*****@*****.**>
* @param string $idChurch Id of one church
* @return Array[Church] Rector that worked in the church
*/
static function getAllFormerChurchs($idRector = '', $order = 'id', $begin = -1)
{
if ($idRector == '') {
return null;
} else {
$tableRector = DatabaseManager::getNameTable('TABLE_RECTOR');
$tableChurch = DatabaseManager::getNameTable('TABLE_CHURCH');
$tablePerson = DatabaseManager::getNameTable('TABLE_PERSON');
$tableUnion = DatabaseManager::getNameTable('TABLE_FORMER_RECTOR_CHURCH');
$query = "SELECT {$tableChurch}.*\r\n FROM {$tableChurch}\r\n LEFT JOIN {$tableUnion}\r\n ON {$tableUnion}.idChurch = {$tableChurch}.id\r\n WHERE {$tableUnion}.idRector = {$idRector}\r\n ORDER BY {$order}";
if ($begin !== -1) {
$query = $query . " LIMIT " . strval($begin * 10) . ", 11 ";
}
$arrayChurchs = DatabaseManager::multiFetchAssoc($query);
$churchs = array();
if ($arrayChurchs === null) {
return null;
} else {
if ($begin !== -1) {
$i = 0;
foreach ($arrayChurchs as $church) {
if ($i == 10) {
continue;
}
$churchs[] = ChurchManager::ArrayToChurch($church);
$i++;
}
} else {
foreach ($arrayChurchs as $church) {
$churchs[] = ChurchManager::ArrayToChurch($church);
}
}
return $churchs;
}
}
}
