public function updateAdvertisement($memberID, $advertisementDetails, $dbConnection)
{
$preparedStatement = null;
$processed = false;
try {
if ($memberID != null & $advertisementDetails->getVariable(Advertisement::ADVERTISEMENT_ID) !== null) {
$updateQuery = AdvertisementDao::getAdvertisementUpdateQuery($advertisementDetails);
$preparedStatement = AdvertisementDao::getAdvertisementUpdatePreparedStatement($updateQuery, $memberID, $advertisementDetails, $dbConnection);
if ($preparedStatement->execute()) {
}
$processed = true;
$preparedStatement = null;
}
} catch (Exception $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
}
return $processed;
}
/**
* Updates an advertisement object. Uses a change key to determine if values have been updated.
*
* @param int $memberID
* @param String $changeKey
* @param int $advertisementID
* @param int $advertisementTypeID
* @param int $bandID
* @param String $summary
* @param String $inspirations
* @param String $description
* @param String $locationChangeKey
* @param int $countryID
* @param int $stateID
* @param int $cityID
* @param int $regionID
* @param connection $dbConnection
* @return boolean
*/
public function updateAdvertisement($memberID, $changeKey, $advertisementID, $advertisementTypeID, $bandID, $summary, $inspirations, $description, $locationChangeKey, $countryID, $stateID, $cityID, $regionID, $dbConnection = null)
{
$success = false;
$update = false;
try {
$advertisementDetails = new Advertisement();
$advertisementDetails->setVariable(Advertisement::ADVERTISEMENT_ID, $advertisementID);
if ($changeKey != null) {
ChangeUtilities::processChangeItem($advertisementDetails, $changeKey, AdvertisementEditConstants::FOR_INPUT_CHANGE_KEY, Advertisement::ADVERTISEMENT_TYPE_ID, $advertisementTypeID, $update);
ChangeUtilities::processChangeItem($advertisementDetails, $changeKey, AdvertisementEditConstants::BAND_INPUT_CHANGE_KEY, Advertisement::BAND_ID, $bandID, $update);
ChangeUtilities::processChangeItem($advertisementDetails, $changeKey, AdvertisementEditConstants::SUMMARY_INPUT_CHANGE_KEY, Advertisement::SUMMARY, $summary, $update);
ChangeUtilities::processChangeItem($advertisementDetails, $changeKey, AdvertisementEditConstants::INSPIRATION_INPUT_CHANGE_KEY, Advertisement::INSPIRATIONS, $inspirations, $update);
ChangeUtilities::processChangeItem($advertisementDetails, $changeKey, AdvertisementEditConstants::DESCRIPTION_INPUT_CHANGE_KEY, Advertisement::OTHER_INFORMATION, $description, $update);
}
//If any location value has been changed, update all location fields.
if (stripos($locationChangeKey, LocationConstants::REGION_CHANGE_KEY) !== false || stripos($locationChangeKey, LocationConstants::CITY_CHANGE_KEY) !== false || stripos($locationChangeKey, LocationConstants::STATE_CHANGE_KEY) !== false || stripos($locationChangeKey, LocationConstants::COUNTRY_CHANGE_KEY) !== false) {
if ($countryID == 'defaultOption' || $countryID == '0') {
$countryID = 0;
$stateID = 0;
$cityID = 0;
$regionID = 0;
} else {
if ($stateID == 'defaultOption' || $stateID == '0') {
$stateID = 0;
$cityID = 0;
$regionID = 0;
} else {
if ($cityID == 'defaultOption' || $cityID == '0') {
$cityID = 0;
$regionID = 0;
} else {
if ($regionID == 'defaultOption' || $regionID == '0') {
$regionID = 0;
}
}
}
}
$advertisementDetails->setVariable(LocationConstants::COUNTRY_ID, $countryID);
$advertisementDetails->setVariable(LocationConstants::STATE_ID, $stateID);
$advertisementDetails->setVariable(LocationConstants::CITY_ID, $cityID);
$advertisementDetails->setVariable(LocationConstants::REGION_ID, $regionID);
$update = true;
}
if ($update) {
AdvertisementDao::updateAdvertisement($memberID, $advertisementDetails, $dbConnection);
}
//Success is indicated by reaching this point, we are not concerned if no update was made.
$success = true;
} catch (Exception $ex) {
// echo 'Caught exception: ', $ex->getMessage(), "\n";
$success = false;
}
return $success;
}
