/**
* Method to get a single record.
*
* @param integer The id of the primary key.
*
* @return mixed Object on success, false on failure.
*/
public function getItem($pk = null)
{
$jemsettings = JEMAdmin::config();
if ($item = parent::getItem($pk)) {
$files = JEMAttachment::getAttachments('venue'.$item->id);
$item->attachments = $files;
}
$item->author_ip = $jemsettings->storeip ? JemHelper::retrieveIP() : false;
if (empty($item->id)) {
$item->country = $jemsettings->defaultCountry;
}
return $item;
}
/**
* Method to get the selected members
*
* @access public
* @return string
*
*/
protected function _members()
{
$item = parent::getItem();
//get selected members
if ($item->id == null) {
$this->_members = null;
} else {
if ($item->id) {
$query = 'SELECT member'
. ' FROM #__jem_groupmembers'
. ' WHERE group_id = '.(int)$item->id;
$this->_db->setQuery ($query);
$member_ids = $this->_db->loadColumn();
if (is_array($member_ids)) {
$this->_members = implode(',', $member_ids);
}
}
}
return $this->_members;
}
/**
* Method to get a single record.
*
* @param integer The id of the primary key.
*
* @return mixed Object on success, false on failure.
*/
public function getItem($pk = null)
{
$jemsettings = JEMAdmin::config();
if ($item = parent::getItem($pk)){
// Convert the params field to an array.
$registry = new JRegistry;
$registry->loadString($item->attribs);
$item->attribs = $registry->toArray();
// Convert the metadata field to an array.
$registry = new JRegistry;
$registry->loadString($item->metadata);
$item->metadata = $registry->toArray();
$item->articletext = trim($item->fulltext) != '' ? $item->introtext . "<hr id=\"system-readmore\" />" . $item->fulltext : $item->introtext;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select(array('count(id)'));
$query->from('#__jem_register');
$query->where(array('event= '.$db->quote($item->id), 'waiting= 0'));
$db->setQuery($query);
$res = $db->loadResult();
$item->booked = $res;
$files = JEMAttachment::getAttachments('event'.$item->id);
$item->attachments = $files;
if ($item->id){
// Store current recurrence values
$item->recurr_bak = new stdClass;
foreach (get_object_vars($item) as $k => $v) {
if (strncmp('recurrence_', $k, 11) === 0) {
$item->recurr_bak->$k = $v;
}
}
$item->recurrence_type = '';
$item->recurrence_number = '';
$item->recurrence_byday = '';
$item->recurrence_counter = '';
$item->recurrence_first_id = '';
$item->recurrence_limit = '';
$item->recurrence_limit_date = '';
}
$item->author_ip = $jemsettings->storeip ? JemHelper::retrieveIP() : false;
if (empty($item->id)){
$item->country = $jemsettings->defaultCountry;
}
}
return $item;
}
