public function searchMembers($memberSearchParameters, $dbConnection = null)
{
$membersList = null;
$preparedStatement = null;
try {
$memberSearchQuery = null;
$memberIDQuery = null;
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$memberIDQuery = "SELECT DISTINCT M.MEMBER_ID FROM member M WHERE 1 = 1";
$memberIDQuery .= MemberSearchDao::getMemberSearchWhereClause($memberSearchParameters);
$memberSearchQuery = MemberSearchDao::MEMBER_SEARCH_SELECT;
$memberSearchQuery .= " AND M.MEMBER_ID IN (" . $memberIDQuery . ")\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY M.LAST_NAME ASC, M.FIRST_NAME ASC\n\t\t\t\t\t\t\t\t\t\t\t\tLIMIT :pagingAmount OFFSET :startingPoint";
$preparedStatement = MemberSearchDao::getMemberSearchPreparedStatement($memberSearchQuery, $memberSearchParameters, $dbConnection);
MemberSearchDao::addPagingParameters($preparedStatement, $memberSearchParameters);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
$member = MemberSearchDao::extractMemberSearchObject($result, true);
if ($member !== null) {
$member->setVariable(Member::MEMBER_INSTRUMENTS, MemberInstrumentDao::selectMemberInstruments($member->getVariable(Member::MEMBER_ID), true, $dbConnection));
$membersList[] = $member;
}
}
$preparedStatement = null;
} catch (Exception $ex) {
echo $ex->getMessage();
$membersList = null;
}
$preparedStatement = null;
return $membersList;
}
public function getMemberInstruments($memberID, $skeleton, $dbConnection)
{
$memberInstruments = null;
try {
$memberInstruments = MemberInstrumentDao::selectMemberInstruments($memberID, $skeleton, $dbConnection);
} catch (Exception $ex) {
$memberInstruments = null;
}
return $memberInstruments;
}
public function selectMemberInstruments($memberID, $skeleton = false, $dbConnection = null)
{
$memberInstrumentsList = null;
try {
if ($memberID != null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$preparedStatement = $dbConnection->prepare(MemberInstrumentDao::MEMBER_INSTRUMENT_SELECT);
$preparedStatement->bindParam(MemberInstrumentDao::MEMBER_ID_PARAMETER, $memberID);
$preparedStatement->execute();
while ($result = $preparedStatement->fetch()) {
$memberID = $result[MemberInstrumentDao::MEMBER_ID_FIELD];
$instrumentID = $result[MemberInstrumentDao::INSTRUMENT_ID_FIELD];
if ($memberID != null) {
//Create new objects
$memberInstrument = new MemberInstrument();
$memberInstrument->setVariable(MemberInstrument::MEMBER_ID, $result[MemberInstrumentDao::MEMBER_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::INSTRUMENT_ID, $result[MemberInstrumentDao::INSTRUMENT_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::INSTRUMENT_NAME, $result[MemberInstrumentDao::INSTRUMENT_NAME_FIELD]);
if (!$skeleton) {
$memberInstrument->setVariable(MemberInstrument::EXPERIENCE_ID, $result[MemberInstrumentDao::EXPERIENCE_ID_FIELD]);
$memberInstrument->setVariable(MemberInstrument::STYLES, MemberInstrumentDao::selectMemberInstrumentsStyles($memberID, $instrumentID, $dbConnection));
}
$memberInstrumentsList[] = $memberInstrument;
}
}
$preparedStatement = null;
}
} catch (Exception $ex) {
//Do Nothing
}
return $memberInstrumentsList;
}
