/**
  * Search one rector by one similar name
  * 
  * @author Jonathan Sandoval <*****@*****.**>
  * @param  Rector        $rector      pseudo-rector with the data to search
  * @param  string        $operator    To search with 'OR' or 'AND'
  * @param  string        $order       The type of sort of the Rector
  * @param  integer       $begin       The number of page to display the registry
  * @return Array[Rector] $rectors     Rector objects with the similar name or null
  */
 static function advancedSearchRector($rector = null, $operator = 'AND', $order = 'id', $begin = 0)
 {
     if ($rector === null) {
         return null;
     }
     $tableRector = DatabaseManager::getNameTable('TABLE_RECTOR');
     $tablePerson = DatabaseManager::getNameTable('TABLE_PERSON');
     $tableChurch = DatabaseManager::getNameTable('TABLE_CHURCH');
     $rector->getId() == 0 ? $id = '' : ($id = $rector->getId());
     $type = $rector->getType();
     $status = $rector->getStatus();
     $position = $rector->getPosition();
     $queryOwner = "(";
     $posibleOwner = $rector->getIdPerson();
     $queryChurch = "(";
     $posibleChurch = $rector->getIdActualChurch();
     if ($posibleOwner !== NULL) {
         for ($i = 0; $i < sizeof($posibleOwner) - 1; $i++) {
             $queryOwner = $queryOwner . $posibleOwner[$i]->getId() . ",";
         }
         $queryOwner = $queryOwner . $posibleOwner[sizeof($posibleOwner) - 1]->getId() . ")";
         $queryOwner = "(o.id IN " . $queryOwner . " OR o.id IS NULL)";
     }
     if ($posibleChurch !== NULL) {
         for ($i = 0; $i < sizeof($posibleChurch) - 1; $i++) {
             $queryChurch = $queryChurch . $posibleChurch[$i]->getId() . ",";
         }
         $queryChurch = $queryChurch . $posibleChurch[sizeof($posibleChurch) - 1]->getId() . ")";
         $queryChurch = "(c.id IN " . $queryChurch . " OR c.id IS NULL)";
     }
     $query = "SELECT r.* \r\n                        FROM {$tableRector} AS r LEFT JOIN {$tablePerson} AS o ON r.idPerson = o.id \r\n                        JOIN {$tableChurch} AS c  ON r.idActualChurch = c.id\r\n                        WHERE r.id       LIKE '%{$id}%'       {$operator}\r\n                              r.type     LIKE '%{$type}%'     {$operator}\r\n                              r.status   LIKE '%{$status}%'   {$operator}\r\n                              r.position LIKE '%{$position}%' {$operator}";
     if ($queryOwner != '(') {
         $query = $query . $queryOwner . " " . $operator . " ";
     } else {
         $query = $query . "(o.id IN ())" . $operator . " ";
     }
     if ($queryChurch != '(') {
         $query = $query . $queryChurch . " ";
     } else {
         $query = $query . "(c.id IN ()) ";
     }
     if ($order == 'name') {
         $query = $query . " ORDER BY o.names";
     } else {
         if ($order == 'church') {
             $query = $query . " ORDER BY c.name";
         } else {
             $query = $query . " ORDER BY r.id";
         }
     }
     $query = $query . " LIMIT " . strval($begin * 10) . ", 11 ";
     $arrayRectors = DatabaseManager::multiFetchAssoc($query);
     $rectors = array();
     if ($arrayRectors !== NULL) {
         $i = 0;
         foreach ($arrayRectors as $rector) {
             if ($i == 10) {
                 continue;
             }
             $rectors[] = self::ArrayToRector($rector);
             $i++;
         }
         return $rectors;
     } else {
         return null;
     }
 }
<?php

require_once __DIR__ . "/../../../Backend/SessionManager.php";
require_once __DIR__ . "/../../../Backend/RectorManager.php";
require_once __DIR__ . "/../../../Backend/ChurchManager.php";
require_once __DIR__ . "/../../../Backend/PersonManager.php";
if (!isset($_GET) || $_GET["name"] === NULL) {
    echo "KO";
    die;
}
$status = $_GET["status"];
$rector = new Rector();
$person = PersonManager::getSinglePerson('names', $_GET["name"], 'lastname1', $_GET["lastname1"], 'lastname2', $_GET["lastname2"]);
if ($person === NULL) {
    $person = new Person(0, $_GET["name"], $_GET["lastname1"], $_GET["lastname2"]);
    PersonManager::addPerson($person);
    $person = PersonManager::getSinglePerson('names', $_GET["name"], 'lastname1', $_GET["lastname1"], 'lastname2', $_GET["lastname2"]);
}
$church = ChurchManager::getSingleChurch('name', $_GET["actualChurch"]);
$rector->setIdPerson($person->getId());
$rector->setType($_GET["type"]);
$rector->setPosition($_GET["position"]);
$rector->setIdActualChurch($church->getId());
if ($_GET["statusR"] === 'Activo' || $_GET["statusR"] === 'Active') {
    $rector->setStatus('A');
} else {
    $rector->setStatus('I');
}
if ($status === 'update') {
    $rector->setId($_GET["id"]);
    if (RectorManager::updateRector($rector)) {
예제 #3
0
}
//Getting all registries
if ($simpleKeyword !== NULL) {
    $rectorRegistries = RectorManager::searchRector($simpleKeyword, 'OR', $sortType, $numberPage);
} else {
    if ($kid !== NULL) {
        $rectorSearch = new Rector();
        $kid = $_GET["kid"];
        $kname = $_GET["kname"];
        $klastname1 = $_GET["klastname1"];
        $klastname2 = $_GET["klastname2"];
        $kchurch = $_GET["kchurch"];
        $ktype = $_GET["ktype"];
        $kstatus = $_GET["kstatus"];
        $kposition = $_GET["kposition"];
        $rector = new Rector();
        $rector->setId($kid);
        $rector->setType($ktype);
        $rector->setStatus($kstatus);
        $rector->setPosition($kposition);
        $posibleNames = PersonManager::searchPersonsByNames($kname, $klastname1, $klastname2, false);
        $rector->setIdPerson($posibleNames);
        $posibleChurch = ChurchManager::simpleSearchChurch($kchurch, 'id', -1);
        $rector->setIdActualChurch($posibleChurch);
        $rectorRegistries = RectorManager::advancedSearchRector($rector, 'AND', $sortType, $numberPage);
    } else {
        $rectorRegistries = RectorManager::getAllRectors($sortType, $numberPage);
    }
}
//Get the total of registries
$totalRegistries = DatabaseManager::getAffectedRows();