public function updateAdvertisementPosition($advertisementPositionID, $changeKey, $advertisementID, $memberID, $positionNumber, $instrumentID, $durationID, $description, $experienceID, $ageRangeID, $genderID, $dbConnection = null)
{
$processed = false;
$update = false;
try {
if ($changeKey != null) {
$position = new AdvertisementPosition();
$position->setVariable(AdvertisementPosition::ADVERTISEMENT_POSITION_ID, $advertisementPositionID);
$position->setVariable(AdvertisementPosition::ADVERTISEMENT_ID, $advertisementID);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_NUMBER_CHANGE_KEY, AdvertisementPosition::POSITION_NUMBER, $positionNumber, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_TYPE_CHANGE_KEY, AdvertisementPosition::INSTRUMENT_ID, $instrumentID, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_DURATION_CHANGE_KEY, AdvertisementPosition::DURATION_ID, $durationID, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_EXP_CHANGE_KEY, AdvertisementPosition::EXPERIENCE_ID, $experienceID, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_AGE_CHANGE_KEY, AdvertisementPosition::AGE_RANGE_ID, $ageRangeID, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_GENDER_CHANGE_KEY, AdvertisementPosition::GENDER_ID, $genderID, $update);
ChangeUtilities::processChangeItem($position, $changeKey, AdvertisementPositionConstants::POSITION_OTHER_CHANGE_KEY, AdvertisementPosition::DESCRIPTION, $description, $update);
if ($update) {
$processed = AdvertisementPositionDao::updateAdvertisementPosition($memberID, $position, $dbConnection);
}
}
} catch (Exception $ex) {
$processed = false;
echo 'Caught exception: ' . $ex->getMessage();
}
return $processed;
}
$advertisementID = AdvertisementController::createAdvertisement($memberID, $_POST[AdvertisementCreateConstants::FOR_INPUT_ID], $_POST[AdvertisementCreateConstants::SUMMARY_INPUT_ID], $_POST[AdvertisementCreateConstants::DESCRIPTION_INPUT_ID], $_POST[AdvertisementCreateConstants::INSPIRATIONS_INPUT_ID], $_POST[AdvertisementCreateConstants::BAND_INPUT_ID], $_POST[LocationConstants::LOCATION_COUNTRY_INPUT_ID], $_POST[LocationConstants::LOCATION_STATE_INPUT_ID], $_POST[LocationConstants::LOCATION_CITY_INPUT_ID], $_POST[LocationConstants::LOCATION_REGION_INPUT_ID], $dbConnection);
if ($advertisementID > 0) {
//If advertisement is for a position in a band.
if ($_POST[AdvertisementCreateConstants::FOR_INPUT_ID] == 2) {
$bandID = $_POST[AdvertisementCreateConstants::BAND_INPUT_ID];
if (BandMemberController::isBandMemberAdmin($bandID, $memberID, $dbConnection)) {
BandAdvertisementController::createBandAdvertisement($bandID, $advertisementID, $dbConnection);
}
}
if (AdvertisementGenreController::createAdvertisementGenres($advertisementID, $memberID, $_POST[AdvertisementCreateConstants::GENRE_INPUT_ID], $dbConnection)) {
$positionCount = $_POST[AdvertisementCreateConstants::POSITION_COUNT_ID];
echo "Position Count : " . $positionCount;
$positionList = null;
for ($i = 1; $i <= $positionCount; $i++) {
$position = new AdvertisementPosition();
$position->setVariable(AdvertisementPosition::ADVERTISEMENT_ID, $advertisementID);
$position->setVariable(AdvertisementPosition::POSITION_NUMBER, $i);
$position->setVariable(AdvertisementPosition::INSTRUMENT_ID, $_POST[AdvertisementPositionConstants::POSITION_TYPE_INPUT_ID . $i]);
$position->setVariable(AdvertisementPosition::DURATION_ID, $_POST[AdvertisementPositionConstants::POSITION_DURATION_INPUT_ID . $i]);
$position->setVariable(AdvertisementPosition::EXPERIENCE_ID, $_POST[AdvertisementPositionConstants::POSITION_EXP_INPUT_ID . $i]);
$position->setVariable(AdvertisementPosition::GENDER_ID, $_POST[AdvertisementPositionConstants::POSITION_GENDER_INPUT_ID . $i]);
$position->setVariable(AdvertisementPosition::AGE_RANGE_ID, $_POST[AdvertisementPositionConstants::POSITION_AGE_INPUT_ID . $i]);
$position->setVariable(AdvertisementPosition::DESCRIPTION, $_POST[AdvertisementPositionConstants::POSITION_OTHER_INPUT_ID . $i]);
$positionList[] = $position;
}
$processed = AdvertisementPositiionController::createAdvertisementPositions($advertisementID, $memberID, $positionList, $dbConnection);
}
}
} else {
echo "Security Check Fail \n";
}
/**
* 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;
}
private function extractAdvertisementPosition(&$result)
{
$advertisementPosition = null;
try {
if ($result[AdvertisementPositionDao::ADVERTISEMENT_ID_FIELD] != null) {
$advertisementPosition = new AdvertisementPosition();
$advertisementPosition->setVariable(AdvertisementPosition::ADVERTISEMENT_POSITION_ID, $result[AdvertisementPositionDao::ADVERTISEMENT_POSITION_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::ADVERTISEMENT_ID, $result[AdvertisementPositionDao::ADVERTISEMENT_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::POSITION_NUMBER, $result[AdvertisementPositionDao::POSITION_NUMBER_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::INSTRUMENT_ID, $result[AdvertisementPositionDao::INSTRUMENT_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::INSTRUMENT_NAME, $result[AdvertisementPositionDao::INSTRUMENT_NAME_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::DURATION_ID, $result[AdvertisementPositionDao::DURATION_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::DESCRIPTION, $result[AdvertisementPositionDao::DESCRIPTION_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::EXPERIENCE_ID, $result[AdvertisementPositionDao::EXPERIENCE_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::GENDER_ID, $result[AdvertisementPositionDao::GENDER_ID_FIELD]);
$advertisementPosition->setVariable(AdvertisementPosition::AGE_RANGE_ID, $result[AdvertisementPositionDao::AGE_RANGE_ID_FIELD]);
}
} catch (Exception $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
$advertisementPosition = null;
}
return $advertisementPosition;
}