function getListQuery() { $params = $this->state->params; $jinput = JFactory::getApplication()->input; $task = $jinput->getCmd('task'); $user = JFactory::getUser(); // Create a new query object. $query = parent::getListQuery(); // limit output so only future events the user attends will be shown if ($params->get('filtermyregs')) { $query->where(' DATE_SUB(NOW(), INTERVAL ' . (int) $params->get('myregspast') . ' DAY) < (IF (a.enddates IS NOT NULL, a.enddates, a.dates)) '); } // then if the user is attending the event $query->join('LEFT', '#__jem_register AS r ON r.event = a.id'); $query->where('r.uid = ' . $user->id); return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { $params = $this->state->params; $jinput = JFactory::getApplication()->input; $task = $jinput->getCmd('task'); // Create a new query object. $query = parent::getListQuery(); $query->where('a.locid = ' . $this->_id); // here we can extend the query of the Eventslist model return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { // Let parent create a new query object. $query = parent::getListQuery(); // here we can extend the query of the Eventslist model $query->select('DATEDIFF(a.enddates, a.dates) AS datesdiff,DAYOFMONTH(a.dates) AS start_day, YEAR(a.dates) AS start_year, MONTH(a.dates) AS start_month'); return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { $params = $this->state->params; $jinput = JFactory::getApplication()->input; $task = $jinput->getCmd('task'); // Create a new query object. $query = parent::getListQuery(); $query->select('DATEDIFF(a.enddates, a.dates) AS datesdiff,DAYOFWEEK(a.dates) AS weekday, DAYOFMONTH(a.dates) AS start_day, YEAR(a.dates) AS start_year, MONTH(a.dates) AS start_month, WEEK(a.dates) AS weeknumber'); return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { $params = $this->state->params; $jinput = JFactory::getApplication()->input; $task = $jinput->getCmd('task'); // Create a new query object. $query = parent::getListQuery(); $query->select('DATEDIFF(a.enddates, a.dates) AS datesdiff,DAYOFMONTH(a.dates) AS start_day, YEAR(a.dates) AS start_year, MONTH(a.dates) AS start_month'); // here we can extend the query of the Eventslist model return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { $params = $this->state->params; $jinput = JFactory::getApplication()->input; $task = $jinput->get('task','','cmd'); $requestVenueId = $this->getState('filter.req_venid'); // Create a new query object. $query = parent::getListQuery(); if ($requestVenueId){ $query->where(' a.locid = '.$this->_db->quote($requestVenueId)); } // Second is to only select events of the specified day $query->where('('.$this->_db->quote($this->_date).' BETWEEN (a.dates) AND (IF (a.enddates >= a.dates, a.enddates, a.dates)) OR '.$this->_db->quote($this->_date).' = a.dates)'); return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { //$params = $this->state->params; //$jinput = JFactory::getApplication()->input; //$task = $jinput->get('task','','cmd'); // Create a new query object. $query = parent::getListQuery(); // here we can extend the query of the Eventslist model return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { // Let parent create a new query object. $query = parent::getListQuery(); $query->select('DATEDIFF(a.enddates, a.dates) AS datesdiff, DAYOFWEEK(a.dates) AS weekday, DAYOFMONTH(a.dates) AS start_day, YEAR(a.dates) AS start_year, MONTH(a.dates) AS start_month, WEEK(a.dates) AS weeknumber'); return $query; }
/** * @return JDatabaseQuery */ function getListQuery() { // Create a new query object. $query = parent::getListQuery(); // here we can extend the query of the Eventslist model $query->where('a.locid = '.(int)$this->_id); return $query; }