public function getUserSearchResult($searchKeyword)
{
$query = "select uid, firstname, lastname from users where firstname like '%" . $searchKeyword . "%' or lastname like '%" . $searchKeyword . "%' group by uid limit 0, 200";
$queryResult = parent::query($query);
$userSearch = array();
while ($result = parent::fetchArray($queryResult)) {
$userSearch[] = array('uid' => $result['uid'], 'name' => $result['firstname'] . ' ' . $result['lastname'], 'firstname' => $result['firstname'], 'eventCount' => application_frontend_event_model::getEventOfThisWeek($result['uid']));
}
return $userSearch;
}
public function getAllRequest($uid)
{
$query = "select fr.request, u.firstname, u.lastname from friendRequest as fr, users as u where fr.request = u.uid and fr.accept = " . $uid;
$queryResult = parent::query($query);
$requestList = array();
while ($result = parent::fetchArray($queryResult)) {
$requestList[] = array('request' => $result['request'], 'name' => $result['firstname'] . ' ' . $result['lastname'], 'firstname' => $result['firstname'], 'lastname' => $result['lastname'], 'eventCount' => application_frontend_event_model::getEventOfThisWeek($result['request']));
}
return $requestList;
}
