$witness2->setNames($_POST["nameWitness2"]);
$witness2->setLastname1($_POST["lastname1Witness2"]);
$witness2->setLastname2($_POST["lastname2Witness2"]);
PersonManager::addPerson($witness2, 'true');
$witness2 = PersonManager::getSinglePerson('id', PersonManager::getLastID());
}
$marriage->setIdWitness2($witness2->getId());
}
//Get The Book Registry Data
$reverse = substr($_POST["reverseBookRegistry"], 0, 1);
if ($reverse === 'Y' || $reverse === 'S') {
$reverse = 'Y';
}
$bookRegistry = MarriageManager::getSingleMarriageRegistry('book', $_POST["bookBookRegistry"], 'page', $_POST["pageBookRegistry"], 'number', $_POST["numBookRegistry"], 'reverse', $reverse);
if ($bookRegistry === NULL) {
$bookRegistry = new MarriageRegistry();
$bookRegistry->setBook($_POST["bookBookRegistry"]);
$bookRegistry->setPage($_POST["pageBookRegistry"]);
$bookRegistry->setNumber($_POST["numBookRegistry"]);
$bookRegistry->setReverse($reverse);
MarriageManager::addMarriageRegistry($bookRegistry);
$bookRegistry = MarriageManager::getSingleMarriageRegistry('book', $_POST["bookBookRegistry"], 'page', $_POST["pageBookRegistry"], 'number', $_POST["numBookRegistry"], 'reverse', substr($reverse, 0, 1));
}
$marriage->setIdBookRegistry(1);
if ($bookRegistry !== NULL) {
$marriage->setIdBookRegistry($bookRegistry->getId());
}
//Add the registry
if ($_SESSION["user_type"] != 'A') {
if ($_SESSION["user_church"] == $church->getId()) {
if ($_POST["status"] === 'insert') {
/**
* insert one marriageRegistry in the database
*
* @author Jonathan Sandoval <*****@*****.**>
* @param MarriageRegistry $marriageRegistry The marriageRegistry to insert
* @return boolean If was possible to insert
*/
static function addMarriageRegistry($marriageRegistry = null)
{
if ($marriageRegistry === null) {
return false;
}
$number = $marriageRegistry->getNumber();
$book = $marriageRegistry->getBook();
$page = $marriageRegistry->getPage();
$reverse = $marriageRegistry->getReverse();
$singleMarriageRegistry = self::getSingleMarriageRegistry('number', $number, 'book', $book, 'page', $page, 'reverse', $reverse);
if ($singleMarriageRegistry === null) {
$tableMarriageRegistry = DatabaseManager::getNameTable('TABLE_MARRIAGE_REGISTRY');
$query = "INSERT INTO {$tableMarriageRegistry}\r\n (number, book, page, reverse)\r\n VALUES \r\n ('{$number}', '{$book}', '{$page}', '{$reverse}')";
return DatabaseManager::singleAffectedRow($query);
} else {
return false;
}
}
