function encoder_redirect_success(Building $building)
{
$building_name = $building->getName();
$building_name_amharic = $building->getNameAmharic();
$dir = "VIEW/html/Encoder/Add_Building/Add_Building.php?success=1&building_name={$building_name}&building_name_amharic={$building_name_amharic}";
$url = BASE_URL . $dir;
header("Location:{$url}");
//redirect the encoder to the regions add place
exit;
}
public function update(Building $object)
{
$q = "UPDATE " . self::TABLE . " SET `name`='" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "' WHERE buildingId='" . addslashes($object->getBuildingId()) . "'";
$pk = $object->getBuildingId();
if ($object->isNew()) {
if (empty($pk)) {
$q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')";
} else {
$q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getBuildingId()) . "', '" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')";
}
}
$this->db->updateQuery($q);
if (empty($pk)) {
$pk = $this->db->selectQuery("SELECT buildingId from " . self::TABLE . " ORDER BY buildingId DESC limit 1")->getSingleton();
}
$result = $this->findByPrimaryKey($pk);
parent::$dbCache->resetEntity("Building");
parent::$dbCache->setSingle("Building", $pk, $result);
return $result;
}
function Building_Exists(Building $building)
{
$name = $building->getName();
$query = "SELECT * FROM Building WHERE Name='{$name}'";
$result = mysqli_query($this->getDbc(), $query);
if (mysqli_num_rows($result) >= 1) {
return TRUE;
} else {
if (mysqli_num_rows($result) == 0) {
return FALSE;
}
}
}
function Edit_Building(Building $Building, $BUL_ID, Place $Place, $Place_ID, Direction $Dir, $Direction_ID)
{
//start the transaction
$query1 = "START TRANSACTION";
$result1 = mysqli_query($this->getDbc(), $query1);
$Building_Name = $Building->getName();
$Building_Name_Amharic = $Building->getNameAmharic();
$Building_Description = $Building->getBuildingDescription();
$Building_Description_Amharic = $Building->getBuildingDescriptionAmharic();
$Parking_Area = $Building->getParkingArea();
$Building_ID = $BUL_ID;
//now edit the company;
$query2 = "Update Building set\n\t\tName='{$Building_Name}',Name_Amharic = '{$Building_Name_Amharic}'\n\t\t,Building_Description='{$Building_Description}'\n\t\t,Building_Description_Amharic='{$Building_Description_Amharic}',\n\t\tParking_Area='{$Parking_Area}' where ID='{$Building_ID}'";
$result2 = mysqli_query($this->getDbc(), $query2);
if ($result2) {
echo "result 2";
}
//edit the place
$Region_ID = $Place->getRegionID();
$City_ID = $Place->getCityID();
$Sub_City_ID = $Place->getSubCityID();
$Wereda_ID = $Place->getWeredaID();
$Sefer_ID = $Place->getSeferID();
$Street_ID = $Place->getStreetID();
$query3 = "update place set\n\t\t\t\tRegion='{$Region_ID}',City='{$City_ID}',Sub_City='{$Sub_City_ID}',Wereda='{$Wereda_ID}',Sefer='{$Sefer_ID}',Street='{$Street_ID}'\n\t\t\t\twhere ID='{$Place_ID}'";
$result3 = mysqli_query($this->getDbc(), $query3);
if ($result3) {
echo "result 3";
}
//update direction
$Direction = $Dir->getDirection();
$Direction_Amharic = $Dir->getDirectionAmharic();
$query4 = "update direction set\n\t\t\t\t\tDirection='{$Direction}',Direction_Amharic='{$Direction_Amharic}'\n\t\t\t\t\twhere ID='{$Direction_ID}'";
$result4 = mysqli_query($this->getDbc(), $query4);
if ($result4) {
echo "result 4";
}
if ($result1 and $result2 and $result3 and $result4) {
$query_last = "COMMIT";
mysqli_query($this->getDbc(), $query_last);
return TRUE;
} else {
$query_last = "ROLLBACK";
mysqli_query($this->getDbc(), $query_last);
return FALSE;
}
}
