/**
* Search one baptism by one similar name
*
* @author Jonathan Sandoval <*****@*****.**>
* @param Baptism $baptism Pseudo-baptism with the data to search
* @param string $operator To search with 'or' or 'and'
* @param string $order The type of sort of the Baptism
* @param integer $begin The number of page to display the registry
* @return Array[Baptism] $baptisms Baptism objects with the similar name or null
*/
static function advancedSearchBaptism($baptism = null, $operator = 'AND', $order = 'id', $begin = 0)
{
if ($baptism === null) {
return null;
}
$tableBaptism = DatabaseManager::getNameTable('TABLE_BAPTISM');
$tablePerson = DatabaseManager::getNameTable('TABLE_PERSON');
$tableChurch = DatabaseManager::getNameTable('TABLE_CHURCH');
$celebrationDate = $baptism->getCelebrationDate();
$bornPlace = $baptism->getBornPlace();
$bornDate = $baptism->getBornDate();
$queryOwner = "(";
$posibleOwner = $baptism->getIdOwner()[0];
$queryFather = "(";
$posibleFather = $baptism->getIdOwner()[1];
$queryMother = "(";
$posibleMother = $baptism->getIdOwner()[2];
$queryChurch = "(";
$posibleChurch = $baptism->getIdChurch();
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 . ")";
}
if ($posibleFather !== NULL) {
for ($i = 0; $i < sizeof($posibleFather) - 1; $i++) {
$queryFather = $queryFather . $posibleFather[$i]->getId() . ",";
}
$queryFather = $queryFather . $posibleFather[sizeof($posibleFather) - 1]->getId() . ")";
$queryFather = "((fa.id IN " . $queryFather . ") OR fa.id IS NULL)";
}
if ($posibleMother !== NULL) {
for ($i = 0; $i < sizeof($posibleMother) - 1; $i++) {
$queryMother = $queryMother . $posibleMother[$i]->getId() . ",";
}
$queryMother = $queryMother . $posibleMother[sizeof($posibleMother) - 1]->getId() . ")";
$queryMother = "((mo.id IN " . $queryMother . ") OR mo.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 . ")";
}
if ($baptism->getId() == 0) {
$id = '';
} else {
$id = $baptism->getId();
}
if ($baptism->getIdBookRegistry() == 0) {
$idBookRegistry = '';
} else {
$idBookRegistry = $baptism->getIdBookRegistry()->getId();
}
$query = "SELECT b.* \r\n FROM {$tableBaptism} AS b LEFT JOIN {$tablePerson} AS o ON b.idOwner = o.id \r\n LEFT JOIN {$tablePerson} AS fa ON o.idFather = fa.id\r\n LEFT JOIN {$tablePerson} AS mo ON o.idMother = mo.id\r\n JOIN {$tableChurch} AS c ON b.idChurch = c.id\r\n WHERE b.id LIKE '%{$id}%' {$operator}\r\n b.BaptismDate LIKE '%{$celebrationDate}%' {$operator}\r\n b.bornPlace LIKE '%{$bornPlace}%' {$operator}\r\n b.bornDate LIKE '%{$bornDate}%' {$operator}";
//Join the Query with the posibiitation query
if ($queryOwner != '(') {
$query = $query . $queryOwner . " " . $operator . " ";
} else {
$query = $query . "(o.id IN ())" . $operator . " ";
}
if ($queryFather != '(') {
$query = $query . $queryFather . " " . $operator . " ";
} else {
$query = $query . "(fa.id IN ())" . $operator . " ";
}
if ($queryMother != '(') {
$query = $query . $queryMother . " " . $operator . " ";
} else {
$query = $query . "(mo.id IN ())" . $operator . " ";
}
if ($queryChurch != '(') {
$query = $query . $queryChurch . " " . $operator . " ";
} else {
$query = $query . "(c.id IN ())" . $operator . " ";
}
if ($idBookRegistry !== NULL) {
$query = $query . "b.idBookRegistry LIKE '%{$idBookRegistry}%'";
} else {
$query = $query . "b.idBookRegistry LIKE '%%'";
}
if ($order == 'nameChild') {
$query = $query . " ORDER BY o.names";
} else {
if ($order == 'nameChurch') {
$query = $query . " ORDER BY c.name";
} else {
$query = $query . " ORDER BY b.id DESC";
}
}
$query = $query . " LIMIT " . strval($begin * 10) . ", 11 ";
$arrayBaptisms = DatabaseManager::multiFetchAssoc($query);
$baptisms = array();
if ($arrayBaptisms !== NULL) {
$i = 0;
foreach ($arrayBaptisms as $baptism) {
if ($i == 10) {
continue;
}
$baptisms[] = self::ArrayToBaptism($baptism);
$i++;
}
return $baptisms;
} else {
return null;
}
}
} else {
echo "KO";
}
} else {
if ($_POST["status"] === 'update') {
ConfirmationManager::updateConfirmation($confirmation);
echo "OK";
if ($_POST["baptismId"] === '0') {
if ($_POST["baptismChurch"] != "XXXXXXXXXX") {
$bookRegistry = new BaptismRegistry();
$bookRegistry->setBook($_POST["bookBookRegistryB"]);
$bookRegistry->setPage($_POST["pageBookRegistryB"]);
$bookRegistry->setNumber($_POST["numBookRegistryB"]);
BaptismManager::addBaptismRegistry($bookRegistry);
$bookRegistry = BaptismManager::getSingleBaptismRegistry('book', $_POST["bookBookRegistryB"], 'page', $_POST["pageBookRegistryB"], 'number', $_POST["numBookRegistryB"]);
$baptism = new Baptism('0', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL');
$baptism->setIdCivilRegistry('1');
$celb = DatabaseManager::singleDateToDatabaseDate($_POST["baptismDate"]);
$baptism->setCelebrationDate($celb);
$church = ChurchManager::getSingleChurch('name', $_POST["baptismChurch"]);
if ($church !== NULL) {
$baptism->setIdChurch($church->getId());
$baptism->setIdRector(RectorManager::getSingleRector('idActualChurch', $church->getId())->getId());
}
$baptism->setIdOwner($child->getId());
$baptism->setIdBookRegistry($bookRegistry->getId());
BaptismManager::addBaptism($baptism);
}
} else {
$baptism = BaptismManager::getSingleBaptism('id', $_POST["baptismId"]);
if ($baptism !== NULL) {
$numberPage = intval($_GET["page"]);
$sortType = $_GET["sort"];
$simpleKeyword = $_GET["keyword"];
$kid = $_GET["kid"];
if ($sortType == NULL || $sortType == '') {
$sortType = 'id';
}
if ($numberPage === NULL || $numberPage < 0) {
echo "<script src='../JS/functions.js'></script><script>nextPage('set', '0')</script>";
}
//Getting all registries
if ($simpleKeyword !== NULL) {
$baptismRegistries = BaptismManager::simpleSearchBaptism($simpleKeyword, $sortType, $numberPage);
} else {
if ($kid !== NULL) {
$baptismSearch = new Baptism();
$kcelebration = DatabaseManager::singleDateToDatabaseDate($_GET["kcelebration"]);
$kbornp = $_GET["kbornp"];
$kbornd = DatabaseManager::singleDateToDatabaseDate($_GET["kbornd"]);
$knamec = $_GET["knamec"];
$klastname1c = $_GET["klastname1c"];
$klastname2c = $_GET["klastname2c"];
$knamef = $_GET["knamef"];
$klastname1f = $_GET["klastname1f"];
$klastname2f = $_GET["klastname2f"];
$knamem = $_GET["knamem"];
$klastname1m = $_GET["klastname1m"];
$klastname2m = $_GET["klastname2m"];
$kchurch = $_GET["kchurch"];
$kbook = $_GET["kbook"];
$knumber = $_GET["knumber"];
require_once __DIR__ . "/../../../Backend/PersonManager.php";
if (!isset($_POST) || $_POST["idChild"] === NULL) {
echo "KO";
die;
}
$church = ChurchManager::getSingleChurch('name', $_POST["celebrationChurch"]);
$child = new Person();
if ($_POST["idChild"] !== '0') {
$child = PersonManager::getSinglePerson('id', $_POST["idChild"]);
}
$child->setId($_POST["idChild"]);
$child->setNames($_POST["nameChild"]);
$child->setLastname1($_POST["lastname1Child"]);
$child->setLastname2($_POST["lastname2Child"]);
$child->setGender(substr($_POST["genderChild"], 0, 1));
$baptism = new Baptism();
$baptism->setId($_POST["idBaptism"]);
$celb = DatabaseManager::singleDateToDatabaseDate($_POST["celebrationDate"]);
$baptism->setCelebrationDate($celb);
$baptism->setBornDate(DatabaseManager::singleDateToDatabaseDate($_POST["bornDateChild"]));
$baptism->setBornPlace($_POST["bornPlaceChild"]);
$baptism->setIdChurch($church->getId());
$baptism->setIdRector($_POST["rectorId"]);
$legitimate = substr($_POST["legitimateChild"], 0, 1);
if ($legitimate === 'S' || $legitimate === 'Y') {
$baptism->setLegitimate('Y');
} else {
$baptism->setLegitimate('N');
}
//Data Process for the Father
$father = new Person();
