$status = $_GET["status"];
$church = new Church();
$church->setId(0);
$church->setName($_GET["nameChuch"]);
$church->setType($_GET["typeChurch"]);
$church->setCode($_GET["codeChurch"]);
$church->setAddress($_GET["addressChurch"]);
$church->setColony($_GET["colonyChurch"]);
$church->setPostalCode($_GET["postalCodeChurch"]);
$church->setPhoneNumber($_GET["phoneNumberChurch"]);
$church->setIdVicar(ChurchManager::getSingleVicar('name', $_GET["vicar"])->getId());
$church->setIdDean(ChurchManager::getSingleDean('name', $_GET["dean"])->getId());
$church->setIdCity(CityManager::getSingleCity('name', $_GET["city"])->getId());
$niches = $_GET["niche"];
if ($niches == 'true') {
$niche = new Niche();
$niche->setMaxCol($_GET["maxCol"]);
$niche->setMaxRow($_GET["maxRow"]);
$niche->setSize($_GET["size"]);
$nicheT = ChurchManager::getSingleNiche('maxCol', $niche->getMaxCol(), 'maxRow', $niche->getMaxRow(), 'size', $niche->getSize());
if ($nicheT === NULL) {
ChurchManager::addNiche($niche);
$nicheT = ChurchManager::getSingleNiche('maxCol', $niche->getMaxCol(), 'maxRow', $niche->getMaxRow(), 'size', $niche->getSize());
$church->setIdNiche($nicheT->getId());
} else {
$church->setIdNiche($nicheT->getId());
}
} else {
$church->setIdNiche('NULL');
}
if ($status === 'update') {
/**
* Insert one niche in the database
*
* @author Jonathan Sandoval <*****@*****.**>
* @param Niche $niche The niche to insert
* @return boolean If was possible to insert
*/
static function addNiche($niche = null)
{
if ($niche === null) {
return false;
}
$maxCol = $niche->getMaxCol();
$maxRow = $niche->getMaxRow();
$size = $niche->getSize();
$singleNiche = self::getSingleNiche('maxCol', $maxCol, 'maxRow', $maxRow, 'size', $size);
if ($singleNiche === null) {
$tableNiche = DatabaseManager::getNameTable('TABLE_NICHE');
$query = "INSERT INTO {$tableNiche}\r\n (maxCol, maxRow, size)\r\n VALUES \r\n ('{$maxCol}', '{$maxRow}', '{$size}')";
return DatabaseManager::singleAffectedRow($query);
} else {
return false;
}
}
