$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; } }