=CURRENT_TIMESTAMP ORDER BY eventdate ASC limit $offset,10";
}else if(!is_null($zipcode) && !is_null($order) && $order == "created_at"){
$query = "select socialeventid,title,summary,imagethumburl,createdtimestamp,eventdate,submitterusername From SOCIALEVENT as se,ADDRESS as a where se.eventtimestamp>=CURRENT_TIMESTAMP and se.ADDRESS_addressid=a.addressid and a.zip='$zipcode' ORDER BY se.createdtimestamp DESC limit $offset,10";
}else if(!is_null($zipcode) && !is_null($order) && $order == "event_date"){
$query = "select socialeventid,title,summary,imagethumburl,createdtimestamp,eventdate,submitterusername From SOCIALEVENT as se,ADDRESS as a where se.eventtimestamp>=CURRENT_TIMESTAMP and se.ADDRESS_addressid=a.addressid and a.zip='$zipcode' ORDER BY se.eventdate ASC limit $offset,10";
}
return $query;
}
function getNumPages($zipcode,$eventdate,$connection){
if(!is_null($eventdate)){
$query = "select count(*) as count From SOCIALEVENT where eventdate='$eventdate'";
}else if(!is_null($_REQUEST['zipcode']) ){
$query = "select count(*) as count From SOCIALEVENT as se,ADDRESS as a where se.eventtimestamp>=CURRENT_TIMESTAMP and se.ADDRESS_addressid=a.addressid and a.zip='$zipcode' ";
}else{
$query = "select count(*) as count From SOCIALEVENT where eventtimestamp>=CURRENT_TIMESTAMP";
}
$result = $connection->query($query);
$row = $result->getArray();
$numEvents = $row['count'];
//Calcuate total pages
$numPages = ceil($numEvents / 10);
unset($result);
return $numPages;
}
function getIndexEvents($zipcode,$order,$eventdate,$offset,$seid,$signedinuser,$connection){
if(!is_null($seid)){
$eventsQuery="select socialeventid,title,summary,imagethumburl,createdtimestamp,eventdate,submitterusername from SOCIALEVENT where socialeventid='$seid' ";
}else if(!is_null($eventdate) ){
$eventsQuery=" select socialeventid,title,summary,imagethumburl,createdtimestamp,eventdate,submitterusername From SOCIALEVENT as se,ADDRESS as a where se.ADDRESS_addressid=a.addressid and se.eventdate='$eventdate' ORDER BY se.eventdate ASC limit $offset,10";
}else{
$eventsQuery=$this->getHomePageEvents($zipcode,$order,$offset);
}
$result = $connection->query($eventsQuery);
$dateFormat = "l, F j, Y, h:i A";
ob_start();
while($row = $result->getArray()) {
$rowsFound = true;
$title = $row['title'];
$se = $row['socialeventid'];
$image = $row['imagethumburl'];
$summary = $row['summary'];
$submitter = $row['submitterusername'];
$ed = $row['eventdate'];
$cd = trim($this->formatdatetime($dateFormat,$row['createdtimestamp']));
require("../views/indexEvents.php");
}
unset($result);
$indexEvents = ob_get_contents();
ob_end_clean();
return $indexEvents;
}
function getNumAttendees($se,$connection) {
$query="select count(username) as count from PERSON_SOCIALEVENT where socialeventid = '$se'";
$result = $connection->query($query);
$row = $result->getArray();
$count = $row['count'];
unset($result);
return $count;
}
function getRecentlyPostedEventsOfUser($user,$connection,$flag,$offset){
if (!$flag){
//$query="select socialeventid,title from SOCIALEVENT where submitterusername='$user' and createdtimestamp between date_add(now(),interval -15 day) and now() and eventtimestamp>=CURRENT_TIMESTAMP order by eventdate asc limit 10";
$query="select socialeventid,title from SOCIALEVENT where submitterusername='$user' and createdtimestamp<=now() and eventtimestamp>=CURRENT_TIMESTAMP order by eventdate asc limit 10";
$count = 1;
}else if ($flag){
//$query="select socialeventid,title from SOCIALEVENT where submitterusername='$user' and createdtimestamp between date_add(now(),interval -90 day) and now() and eventtimestamp>=CURRENT_TIMESTAMP order by eventdate asc limit 30";
$query="select socialeventid,title from SOCIALEVENT where submitterusername='$user' and createdtimestamp<=now() and eventtimestamp>=CURRENT_TIMESTAMP order by eventdate asc limit $offset,10";
$count = 1 + $offset;
}
$result = $connection->query($query);
while($row = $result->getArray()) {
$rowsFound = true;
$title = $row['title'];
$se = $row['socialeventid'];
$recentPostedEvents = $recentPostedEvents." ".''.$count.'. '.$title.'
';
$count++;
}
unset($result);
return $recentPostedEvents;
}
function getUpcomingEventsForUser($user,$connection,$flag,$offset){
if (!$flag){
$query = "select se.socialeventid,se.title From SOCIALEVENT as se,PERSON_SOCIALEVENT as ps where se.socialeventid=ps.socialeventid and se.eventtimestamp>=CURRENT_TIMESTAMP and ps.username='$user' ORDER BY se.eventdate ASC limit 3";
$count = 1;
}else if ($flag){
$query = "select se.socialeventid,se.title From SOCIALEVENT as se,PERSON_SOCIALEVENT as ps where se.socialeventid=ps.socialeventid and se.eventtimestamp>=CURRENT_TIMESTAMP and ps.username='$user' ORDER BY se.eventdate ASC limit $offset,10";
$count = 1 + $offset;
}
$result = $connection->query($query);
while($row = $result->getArray()) {
$rowsFound = true;
$title = $row['title'];
$se = $row['socialeventid'];
$upcomingEvents = $upcomingEvents." ".''.$count.'. '.$title.'
';
$count++;
}
unset($result);
return $upcomingEvents;
}
static function getInstance() {
$instance = new Events_Controller();
return $instance;
}
}
?>