public function getEventFromWeek($firstDayOfWeek, $lastDayOfWeek) { $query = "select ue.id, ue.eid, ue.attending, e.owner, e.name, e.address, e.adjustable, e.location, e.description, e.joinable, ue.dateFrom, ue.timeFrom, ue.timeTo, ue.privacy, ue.remember, ue.modify\n from userEvent as ue, event as e\n where ue.eid = e.eid and ue.dateFrom >= '" . $firstDayOfWeek . "' and ue.dateFrom <= '" . $lastDayOfWeek . "' and ue.uid = " . $this->user['uid'] . " and " . $this->user['relation'] . " <= ue.privacy\n order by timeFrom"; $queryResult = parent::query($query); $event = array(); while ($result = parent::fetchArray($queryResult)) { $event[] = array('id' => $result['id'], 'eid' => $result['eid'], 'attending' => $result['attending'], 'owner' => $result['owner'], 'name' => $result['name'], 'address' => $result['address'], 'adjustable' => $result['adjustable'], 'location' => $result['location'], 'description' => $result['description'], 'joinable' => $result['joinable'], 'dateFrom' => $result['dateFrom'], 'timeFrom' => $result['timeFrom'], 'timeTo' => $result['timeTo'], 'privacy' => $result['privacy'], 'remember' => $result['remember'], 'modify' => $result['modify']); } return $event; }
public function getAttenders($eid) { $query = "select u.uid, u.firstname, u.lastname from users as u, userEvent as ue where u.uid = ue.uid and ue.eid = " . $eid . " and ue.privacy = 3 group by ue.uid order by u.firstname"; $queryResult = parent::query($query); $attenders = array(); while ($result = parent::fetchArray($queryResult)) { $attenders[] = array('uid' => $result['uid'], 'name' => $result['firstname'] . ' ' . $result['lastname']); } return $attenders; }
public function getEventSearchResult($searchKeyword) { $query = "select e.eid, e.owner, e.name, e.description, e.dateFrom, e.timeFrom, e.timeTo, e.joinable, u.firstname, u.lastname\n from event as e, users as u\n where e.owner = u.uid and e.searchable = 1 and (e.name like '%" . $searchKeyword . "%' or e.description like '%" . $searchKeyword . "%') group by e.eid desc limit 0, 200"; $queryResult = parent::query($query); $eventSearch = array(); while ($result = parent::fetchArray($queryResult)) { $eventSearch[] = array('eid' => $result['eid'], 'owner' => $result['owner'], 'eventName' => $result['name'], 'name' => $result['firstname'] . ' ' . $result['lastname'], 'description' => $result['description'], 'joinable' => $result['joinable'], 'dateFrom' => $result['dateFrom'], 'timeFrom' => $result['timeFrom'], 'timeTo' => $result['timeTo']); } return $eventSearch; }
public function getUser($uid) { $query = "select firstname, lastname, email from users where uid = " . $uid; $queryResult = parent::query($query); $userData = array(); while ($result = parent::fetchArray($queryResult)) { $userData = array('name' => $result['firstname'] . ' ' . $result['lastname'], 'firstname' => $result['firstname'], 'lastname' => $result['lastname'], 'email' => $result['email']); } return $userData; }
public function getFriendInvitationFromHash($hash) { $query = "select uid, email from friendEmailInvitation where hash = '" . $hash . "'"; $queryResult = parent::query($query); $invitation = array(); while ($result = parent::fetchArray($queryResult)) { $invitation = array('uid' => $result['uid'], 'email' => $result['email']); } return $invitation; }
public function getAllPrivatemsgGetSub($pid) { $query = "select ps.id, ps.writer, ps.content, ps.readed, ps.created, u.firstname, u.lastname from privatemsgSub as ps, users as u where ps.writer = u.uid and ps.pid = " . $pid . " order by ps.created"; $queryResult = parent::query($query); $privatemsgGetSub = array(); while ($result = parent::fetchArray($queryResult)) { $privatemsgGetSub[] = array('id' => $result['id'], 'writer' => $result['writer'], 'name' => $result['firstname'] . ' ' . $result['lastname'], 'content' => $result['content'], 'created' => date('d F \\a\\t H:i', strtotime($result['created']))); } return $privatemsgGetSub; }
public function getEventRecommend() { $query = "select eid, owner, name from event where eid in (select eid from userEvent) and searchable = 1 and joinable > 1 order by dateFrom desc limit 0, 50"; $queryResult = parent::query($query); $eventRecommend = array(); $i = 0; while ($result = parent::fetchArray($queryResult)) { if (self::getAttenderCount($result['eid']) > 1 && $i < 7) { $eventRecommend[] = array('eid' => $result['eid'], 'owner' => $result['owner'], 'name' => $result['name']); $i++; } } return $eventRecommend; }
public function getShortInfo($uid) { $query = "select pb.gender, pb.birth, pb.relationship, pb.aboutMe, pb.location, pv.view from profileBasic as pb, pageView as pv where pv.uid = pb.uid and pb.uid = " . $uid; $queryResult = parent::query($query); return parent::fetchArray($queryResult); }
public function getEmailEventUser($eid, $uid) { $query = "select u.email, u.uid, u.firstname from users as u, userEvent as ue, notificationSetting as ns where u.uid = ns.uid and u.uid = ue.uid and ns.eventComment = 1 and ue.uid != " . $uid . " and ue.eid = " . $eid . " group by u.uid"; $queryResult = parent::query($query); $sendEmailToArray = array(); while ($result = parent::fetchArray($queryResult)) { $sendEmailToArray[] = array('uid' => $result['uid'], 'firstname' => $result['firstname'], 'email' => $result['email']); } return $sendEmailToArray; }
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; }
public function getNotificationSetting($uid) { $query = "select comment, commentSub, eventInvite, eventComment, eventRequest, eventUpdate, privateMessage, friendRequest from notificationSetting where uid = " . $uid; $queryResult = parent::query($query); return parent::fetchArray($queryResult); }