/** * Extracts an Advertisement object from an input PDO query result object. * * @param PDOItem $result * @param boolean $skeleton */ public function extractAdvertisementObject(&$result) { $advertisement = null; try { if ($result[AdvertisementDao::ADVERTISEMENT_ID_FIELD] !== null) { $advertisement = new Advertisement(); $advertisement->setVariable(Advertisement::ADVERTISEMENT_ID, $result[AdvertisementDao::ADVERTISEMENT_ID_FIELD]); $advertisement->setVariable(Advertisement::ADVERTISEMENT_TYPE_ID, $result[AdvertisementDao::ADVERTISEMENT_TYPE_ID_FIELD]); $advertisement->setVariable(Advertisement::SUMMARY, $result[AdvertisementDao::ADVERTISEMENT_SUMMARY_FIELD]); $advertisement->setVariable(Advertisement::INSPIRATIONS, $result[AdvertisementDao::INSPIRATIONS_FIELD]); $advertisement->setVariable(Advertisement::OTHER_INFORMATION, $result[AdvertisementDao::OTHER_INFORMATION_FIELD]); $advertisement->setVariable(Advertisement::END_DATE, $result[AdvertisementDao::END_DATE_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_ID, $result[AdvertisementDao::MEMBER_ID_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_FIRST_NAME, $result[AdvertisementDao::MEMBER_FIRST_NAME_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_LAST_NAME, $result[AdvertisementDao::MEMBER_LAST_NAME_FIELD]); // $advertisement->setVariable(Advertisement::BAND_ID, $result[AdvertisementDao::BAND_ID_FIELD]); $advertisement->setVariable(Advertisement::BAND_NAME, $result[AdvertisementDao::BAND_NAME_FIELD]); $advertisement->setVariable(Advertisement::START_DATE, $result[AdvertisementDao::START_DATE_FIELD]); $advertisement->setVariable(Advertisement::COUNTRY_ID, $result[AdvertisementDao::COUNTRY_ID_FIELD]); $advertisement->setVariable(Advertisement::STATE_ID, $result[AdvertisementDao::STATE_ID_FIELD]); $advertisement->setVariable(Advertisement::CITY_ID, $result[AdvertisementDao::CITY_ID_FIELD]); $advertisement->setVariable(Advertisement::REGION_ID, $result[AdvertisementDao::REGION_ID_FIELD]); } } catch (PDOException $ex) { $advertisement = null; echo "extractAdvertisementObject error: " . $ex->getMessage(); } return $advertisement; }
/** * Extracts an Advertisement object from an input PDO query result object. * * @param PDOItem $result * @param boolean $skeleton */ public function extractAdvertisementSearchObject(&$result) { $advertisement = null; try { if ($result[AdvertisementSearchDao::ADVERTISEMENT_ID_FIELD] !== null) { $genreList = null; $positionList = null; $advertisement = new Advertisement(); $advertisement->setVariable(Advertisement::ADVERTISEMENT_ID, $result[AdvertisementSearchDao::ADVERTISEMENT_ID_FIELD]); $advertisement->setVariable(Advertisement::ADVERTISEMENT_TYPE_ID, $result[AdvertisementSearchDao::ADVERTISEMENT_TYPE_ID_FIELD]); $advertisement->setVariable(Advertisement::SUMMARY, $result[AdvertisementSearchDao::ADVERTISEMENT_SUMMARY_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_ID, $result[AdvertisementSearchDao::MEMBER_ID_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_FIRST_NAME, $result[AdvertisementSearchDao::MEMBER_FIRST_NAME_FIELD]); $advertisement->setVariable(Advertisement::MEMBER_LAST_NAME, $result[AdvertisementSearchDao::MEMBER_LAST_NAME_FIELD]); $i = 1; for ($i = 1; $i <= AdvertisementSearchDao::POSITION_COUNT; $i++) { $positionID = $result[AdvertisementSearchDao::INSTRUMENT_ID_FIELD . $i]; if ($positionID != null) { $position = new AdvertisementPosition(); $position->setVariable(AdvertisementPosition::INSTRUMENT_ID, $positionID); $position->setVariable(AdvertisementPosition::INSTRUMENT_NAME, $result[AdvertisementSearchDao::INSTRUMENT_NAME_FIELD . $i]); $positionList[] = $position; } } $advertisement->setVariable(Advertisement::POSITION_LIST, $positionList); $advertisement->setVariable(Advertisement::START_DATE, $result[AdvertisementSearchDao::START_DATE_FIELD]); $advertisement->setVariable(LocationConstants::COUNTRY_ID, $result[AdvertisementSearchDao::COUNTRY_ID_FIELD]); $advertisement->setVariable(LocationConstants::STATE_ID, $result[AdvertisementSearchDao::STATE_ID_FIELD]); $advertisement->setVariable(LocationConstants::CITY_ID, $result[AdvertisementSearchDao::CITY_ID_FIELD]); $advertisement->setVariable(LocationConstants::REGION_ID, $result[AdvertisementSearchDao::REGION_ID_FIELD]); } } catch (PDOException $Exception) { echo "extractAdvertisementObject error: " . $Exception->getMessage(); } return $advertisement; }
/** * 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; }