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