$defuntionRegistries = DefuntionManager::simpleSearchDefuntion($simpleKeyword, $sortType, $numberPage); } else { if ($kid !== NULL) { $defuntionSearch = new Defuntion(); $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"]; $kchurch = $_GET["kchurch"]; $defuntionSearch->setId($kid); $defuntionSearch->setDeadDate($kcelebration); $posibleNames[0] = PersonManager::searchPersonsByNames($knamec, $klastname1c, $klastname2c, false); $defuntionSearch->setIdOwner($posibleNames); $posibleChurch = ChurchManager::simpleSearchChurch($kchurch, 'id', -1); $defuntionSearch->setIdChurch($posibleChurch); $defuntionRegistries = DefuntionManager::advancedSearchDefuntion($defuntionSearch, 'AND', $sortType, $numberPage); } else { $defuntionRegistries = DefuntionManager::getAllDefuntions($sortType, $numberPage); } } //Get the total of registries $totalRegistries = DatabaseManager::getAffectedRows(); $affectedRegistries = DatabaseManager::registriesAffectedLastQuery(); $lastPage = floor($affectedRegistries / 10); if ($affectedRegistries % 10 === 0) { $lastPage = floor($affectedRegistries / 10) - 1; } if ($totalRegistries === 0 && $numberPage !== 0) {
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"]); $defuntion = new Defuntion(); $defuntion->setId($_POST["idDefuntion"]); $defuntion->setDeadDate(DatabaseManager::singleDateToDatabaseDate($_POST["celebrationDate"])); $defuntion->setIdChurch($church->getId()); $defuntion->setIdOwner($child->getId()); //Get the defuntion Crypt if ($_POST["idCrypt"] == '0') { if ($_POST["inCrypt"] == "true") { $myCrypt = new Crypt(); $myCrypt->setIdNiche($church->getIdNiche()); $myCrypt->setCol($_POST["cryptColumn"]); $myCrypt->setRow($_POST["cryptRow"]); $myCrypt->setNumber($_POST["cryptNumber"]); DefuntionManager::addCrypt($myCrypt); $singleCrypt = DefuntionManager::getSingleCrypt('col', $myCrypt->getCol(), 'row', $myCrypt->getRow(), 'idNiche', $myCrypt->getIdNiche(), 'number', $myCrypt->getNumber()); $defuntion->setIdCrypt($singleCrypt->getId()); } else { $defuntion->setIdCrypt(NULL); } } else {