public function getMemberAdvertisements($memberID, $currentPage, $pagingAmount, $dbConnection)
{
$advertisementSearchResults = null;
$advertisementSkeletons = null;
try {
//Construct Search Parameter object
$advertisementSearchParameters = new SearchParameters();
$advertisementSearchParameters->setVariable(SearchConstants::CURRENT_PAGE_ID, $currentPage);
$advertisementSearchParameters->setVariable(SearchConstants::PAGING_AMOUNT_ID, $pagingAmount);
$advertisementSearchParameters->setVariable(AdvertisementSearchConstants::MEMBER_INPUT_ID, $memberID);
$advertisementCount = AdvertisementSearchDao::getSearchAdvertisementsCount($advertisementSearchParameters, $dbConnection);
$advertisementSkeletons = AdvertisementSearchDao::searchAdvertisements($advertisementSearchParameters, $dbConnection);
$advertisementSearchResults = new SearchResults();
$advertisementSearchResults->setVariable(SearchResults::SEARCH_PARAMETERS, $advertisementSearchParameters);
$advertisementSearchResults->setVariable(SearchResults::SKELETONS, $advertisementSkeletons);
$advertisementSearchResults->setVariable(SearchResults::COUNT, $advertisementCount);
$advertisementSearchResults->setVariable(SearchResults::PAGE_COUNT, ceil($advertisementCount / $pagingAmount));
} catch (Exception $ex) {
$advertisementSearchResults = null;
echo 'Caught exception: ' . $ex->getMessage();
}
return $advertisementSearchResults;
}
public function searchForBandMembersAdvanced($bandID, $firstName, $lastName, $gender, $ageRange, $country, $state, $city, $region, $searchType, $currentPage, $pagingAmount, $dbConnection = null)
{
$memberSearchResults = null;
$memberSkeletons = null;
$countryID = null;
$stateID = null;
$cityID = null;
$regionID = null;
try {
$memberSearchParameters = new SearchParameters();
$memberSearchParameters->setVariable(SearchConstants::SEARCH_TYPE_INPUT_ID, $searchType);
$memberSearchParameters->setVariable(SearchConstants::CURRENT_PAGE_ID, $currentPage);
$memberSearchParameters->setVariable(SearchConstants::PAGING_AMOUNT_ID, $pagingAmount);
$memberSearchParameters->setVariable(MemberSearchConstants::BAND_INPUT_ID, $bandID);
//These elements are common to both search types
$countryID = SearchUtilities::processSelectValues($country, 'defaultValue', '0');
if ($countryID != null) {
$stateID = SearchUtilities::processSelectValues($state, 'defaultValue', '0');
}
if ($stateID != null) {
$cityID = SearchUtilities::processSelectValues($city, 'defaultValue', '0');
}
if ($cityID != null) {
$regionID = SearchUtilities::processSelectValues($region, 'defaultValue', '0');
}
$memberSearchParameters->setVariable(LocationConstants::LOCATION_COUNTRY_INPUT_ID, $countryID);
$memberSearchParameters->setVariable(LocationConstants::LOCATION_STATE_INPUT_ID, $stateID);
$memberSearchParameters->setVariable(LocationConstants::LOCATION_CITY_INPUT_ID, $cityID);
$memberSearchParameters->setVariable(LocationConstants::LOCATION_REGION_INPUT_ID, $regionID);
$memberSearchParameters->setVariable(MemberSearchConstants::FIRST_NAME_INPUT_ID, $firstName);
$memberSearchParameters->setVariable(MemberSearchConstants::LAST_NAME_INPUT_ID, $lastName);
$memberSearchParameters->setVariable(MemberSearchConstants::GENDER_INPUT_ID, $gender);
$memberSearchParameters->setVariable(MemberSearchConstants::AGE_INPUT_ID, $lastName);
$memberCount = MemberSearchDao::getMemberSearchCount($memberSearchParameters, $dbConnection);
$memberSkeletons = MemberSearchDao::searchMembers($memberSearchParameters, $ageRange);
$memberSearchResults = new SearchResults();
$memberSearchResults->setVariable(SearchResults::SEARCH_PARAMETERS, $memberSearchParameters);
$memberSearchResults->setVariable(SearchResults::SKELETONS, $memberSkeletons);
$memberSearchResults->setVariable(SearchResults::COUNT, $memberCount);
$memberSearchResults->setVariable(SearchResults::PAGE_COUNT, ceil($memberCount / $pagingAmount));
} catch (Exception $e) {
$memberSearchResults = null;
echo 'Caught exception: ', $e->getMessage(), "\n";
}
return $memberSearchResults;
}
public function browseAdvertisementByLocation($country, $state, $city, $region, $searchType, $currentPage, $pagingAmount, $dbConnection = null)
{
$advertisementSearchResults = null;
$advertisementSkeletons = null;
$countryID = null;
$stateID = null;
$cityID = null;
$regionID = null;
try {
//Construct Search Parameter object
$advertisementSearchParameters = new SearchParameters();
$advertisementSearchParameters->setVariable(SearchConstants::CURRENT_PAGE_ID, $currentPage);
$advertisementSearchParameters->setVariable(SearchConstants::PAGING_AMOUNT_ID, $pagingAmount);
//These elements are common to both search types
$countryID = SearchUtilities::processSelectValues($country, 'defaultValue', '0');
if ($countryID != null) {
$stateID = SearchUtilities::processSelectValues($state, 'defaultValue', '0');
}
if ($stateID != null) {
$cityID = SearchUtilities::processSelectValues($city, 'defaultValue', '0');
}
if ($cityID != null) {
$regionID = SearchUtilities::processSelectValues($region, 'defaultValue', '0');
}
$advertisementSearchParameters->setVariable(LocationConstants::LOCATION_COUNTRY_INPUT_ID, $countryID);
$advertisementSearchParameters->setVariable(LocationConstants::LOCATION_STATE_INPUT_ID, $stateID);
$advertisementSearchParameters->setVariable(LocationConstants::LOCATION_CITY_INPUT_ID, $cityID);
$advertisementSearchParameters->setVariable(LocationConstants::LOCATION_REGION_INPUT_ID, $regionID);
$advertisementCount = AdvertisementSearchDao::getSearchAdvertisementsCount($advertisementSearchParameters, $dbConnection);
$advertisementSkeletons = AdvertisementSearchDao::searchAdvertisements($advertisementSearchParameters, $dbConnection);
$advertisementSearchResults = new SearchResults();
$advertisementSearchResults->setVariable(SearchResults::SEARCH_PARAMETERS, $advertisementSearchParameters);
$advertisementSearchResults->setVariable(SearchResults::SKELETONS, $advertisementSkeletons);
$advertisementSearchResults->setVariable(SearchResults::COUNT, $advertisementCount);
$advertisementSearchResults->setVariable(SearchResults::PAGE_COUNT, ceil($advertisementCount / $pagingAmount));
} catch (Exception $e) {
$advertisementSearchResults = null;
echo 'Caught exception: ', $e->getMessage(), "\n";
}
return $advertisementSearchResults;
}
