public function __construct($id = null)
{
if ($id) {
$this->setId($id);
}
$this->_db = Jfactory::getDbo();
}
/**
* Function to return event access (access levels, approval and event access status)
*
* @access public static
* @param $id - id of the event
* @return list array of access levels, approval and event access status
*
* @since 3.4.0
*/
public static function eventAccess($id = null)
{
// Preparing connection to db
$db = Jfactory::getDbo();
// Preparing the query
$query = $db->getQuery(true);
$query->select('e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess')->from($db->qn('#__icagenda_events') . ' AS e')->where($db->qn('e.id') . ' = ' . $db->q($id));
$query->select('v.title AS accessName')->join('LEFT', $db->quoteName('#__viewlevels') . ' AS v ON v.id = e.access');
$db->setQuery($query);
$eventAccess = $db->loadObject();
if ($eventAccess) {
return $eventAccess;
} else {
return false;
}
}
function showTopicComments($data)
{
$_JLMS_PLUGINS =& JLMSFactory::getPlugins();
$option = 'com_joomla_lms';
$db =& Jfactory::getDbo();
$botParams = $_JLMS_PLUGINS->getPluginParams('jc_integration');
$search_jc = JRequest::getVar('search_jc', '', 'request', 'int');
$search_jc_text = JRequest::getVar('search_jc_text', '', 'request', 'string');
$obj_data = new stdClass();
if ($botParams->get('topic_comments', 1)) {
$comments = JPATH_SITE . '/components/com_jcomments/jcomments.php';
if (file_exists($comments)) {
require_once $comments;
$obj_data->form = '';
if ($botParams->get('search_topic_comments', 1)) {
$obj_data->form .= showSearchCommentsStandard(1);
}
if ($search_jc) {
$comments_form = JLMS_JComments::showComments($data->id, $data->component, $data->title, $search_jc_text);
} else {
$comments_form = JComments::showComments($data->id, $data->component, $data->title);
}
$obj_data->form .= $comments_form;
}
}
if (isset($obj_data->form)) {
JLMS_TMPL::OpenTS();
echo $obj_data->form;
JLMS_TMPL::CloseTS();
}
return $obj_data;
}
/**
*
* ALL EVENTS DISPLAY
*
*/
public function count_Events()
{
// Get Params Menu
$app = JFactory::getApplication();
$iCmenuParams = $app->getParams();
// Get Data
$db = Jfactory::getDbo();
$query = $db->getQuery(true);
$query->select('count(e.id) AS nbevents')->from('#__icagenda_events AS e');
// Adding Filter if State Published
$where = "(e.state = 1)";
// Adding Filter per Category in Navigation
$mcatid = $iCmenuParams->get('mcatid');
if (is_array($mcatid)) {
$selcat = implode(', ', $mcatid);
if (!in_array('0', $mcatid)) {
$where .= " AND (e.catid IN ({$selcat}))";
}
}
// UTC datetime is converted in joomla config time zone
// Get a date object based on UTC.
$config = JFactory::getConfig();
if (version_compare(JVERSION, '3.0', 'ge')) {
$offset = $config->get('offset');
} else {
$offset = $config->getValue('config.offset');
}
$joomlaTZ_datetime = JFactory::getDate('now', $offset);
$joomlaTZ_date = date('Y-m-d', strtotime($joomlaTZ_datetime));
// Adding Filter per Time in Navigation
$filter_time = $iCmenuParams->get('time');
// if($filter_time==1) $where.=' AND e.next >= (CURDATE())';
// if($filter_time==2) $where.=' AND e.next < (CURDATE())';
// if($filter_time==3) $where.=' AND e.next >= (NOW())';
// if($filter_time==4) $where.=' AND (e.next >= (CURDATE()) AND (e.next < (CURDATE() + INTERVAL 1 DAY)))';
if ($filter_time == 1) {
$where .= ' AND ' . $db->qn('e.next') . ' >= ' . $db->q($joomlaTZ_date) . '';
}
// COM_ICAGENDA_OPTION_TODAY_AND_UPCOMING
if ($filter_time == 2) {
$where .= ' AND ' . $db->qn('e.next') . ' < ' . $db->q($joomlaTZ_date) . '';
}
// COM_ICAGENDA_OPTION_PAST
if ($filter_time == 3) {
$where .= ' AND ' . $db->qn('e.next') . ' > ' . $db->q($joomlaTZ_datetime) . '';
}
// COM_ICAGENDA_OPTION_FUTURE
if ($filter_time == 4) {
$where .= ' AND (' . $db->qn('e.next') . ' >= ' . $db->q($joomlaTZ_date) . '';
$where .= ' AND (' . $db->qn('e.next') . ' < (' . $db->q($joomlaTZ_date) . ' + INTERVAL 1 DAY)))';
}
// Language Control
$lang = JFactory::getLanguage();
$langcur = $lang->getTag();
$langcurrent = $langcur;
$where .= " AND ((e.language = '{$langcurrent}') OR (e.language = '*') OR (e.language = NULL) OR (e.language = ''))";
// Access Control
$user = JFactory::getUser();
$userID = $user->id;
$userLevels = $user->getAuthorisedViewLevels();
if (version_compare(JVERSION, '3.0', 'lt')) {
$userGroups = $user->getAuthorisedGroups();
} else {
$userGroups = $user->groups;
}
$groupid = JComponentHelper::getParams('com_icagenda')->get('approvalGroups', array("8"));
jimport('joomla.access.access');
$adminUsersArray = array();
foreach ($groupid as $gp) {
$adminUsers = JAccess::getUsersByGroup($gp, False);
$adminUsersArray = array_merge($adminUsersArray, $adminUsers);
}
// Test if user has Access Permissions
if (!in_array('8', $userGroups)) {
$useraccess = implode(', ', $userLevels);
$where .= ' AND e.access IN (' . $useraccess . ')';
}
// Test if user logged-in has Approval Rights
if (!in_array($userID, $adminUsersArray) and !in_array('8', $userGroups)) {
$where .= ' AND e.approval <> 1';
} else {
$where .= ' AND e.approval < 2';
}
$query->where($where);
$db->setQuery($query);
$result = $db->loadObject()->nbevents;
return $result;
}
</td>
<!-- Status Joomla -->
<?php
if (isset($this->items[0]->state)) {
?>
<td class="center">
<?php
// Control of dates if valid (EDIT SINCE VERSION 3.0)
// if (($nextdate == '943916400') OR ($nextdate == '943920000')) {
if ($item->next == '0000-00-00 00:00:00') {
//echo JHtml::_('jgrid.published', $item->state, $i, 'events.', '', 'cb');
echo '<br/><i class="icon-warning"></i><br/><span style="color:red;"><strong>' . JText::_('COM_ICAGENDA_NO_VALID_DATE') . '</strong></span>';
if ($item->state == '1') {
//$state = 0;
$db = Jfactory::getDbo();
$query = $db->getQuery(true);
$query->clear();
$query->update(' #__icagenda_events ');
$query->set(' state = 0 ');
$query->where(' id = ' . (int) $item->id);
$db->setQuery((string) $query);
$db->query($query);
}
} else {
echo JHtml::_('jgrid.published', $item->state, $i, 'events.', $canChange, 'cb');
// echo JHtml::_('approveEvent', $item->approval, $i, 'events.', $canChange, 'cb');
}
?>
</td>
<td class="center">
public function getRating($docId, $commentId)
{
$userId = JFactory::getUser()->id;
$db = Jfactory::getDbo();
$query = $db->getQuery(true);
$query->select('r.*')
->from('#__judownload_rating AS r')
->join('LEFT', '#__judownload_comments AS cm ON cm.rating_id = r.id')
->where('r.user_id = ' . $userId)
->where('r.doc_id = ' . $docId)
->where('cm.id = ' . $commentId)
->order('r.created DESC');
$db->setQuery($query, 0, 1);
return $db->loadObject();
}
/**
* Method to parse mod_redshop_lettersearch module parameter.
*
* @return void
*/
public function GetlettersearchParameters()
{
$db = Jfactory::getDbo();
$sel = 'SELECT params from #__extensions where element = "mod_redshop_lettersearch" ';
$db->setQuery($sel);
$params = $db->loadResult();
$letterparamArr = array();
$allparams = explode("\n", $params);
for ($i = 0; $i < count($allparams); $i++) {
$letter_param = explode('=', $allparams[$i]);
if (!empty($letter_param)) {
$letterparamArr[$letter_param[0]] = $letter_param[1];
}
}
return $letterparamArr;
}
protected function ManagerIcons($i)
{
$app = JFactory::getApplication();
// Get Current Itemid
$this_itemid = JRequest::getInt('Itemid');
// Get Current Url
$returnURL = base64_encode(JURI::getInstance()->toString());
$event_slug = empty($i->alias) ? $i->id : $i->id . ':' . $i->alias;
// Set Manager Actions Url
$managerActionsURL = 'index.php?option=com_icagenda&view=list&layout=event&id=' . $event_slug . '&Itemid=' . $this_itemid;
// Set Email Notification Url to event
$linkEmailUrl = JURI::base() . 'index.php?option=com_icagenda&view=list&layout=event&id=' . $event_slug . '&Itemid=' . $this_itemid;
// Get Approval Status
$approved = $i->approval;
// Get User groups allowed to approve event submitted
$groupid = JComponentHelper::getParams('com_icagenda')->get('approvalGroups', array("8"));
$groupid = is_array($groupid) ? $groupid : array($groupid);
// Get User Infos
$user = JFactory::getUser();
$icid = $user->get('id');
$icu = $user->get('username');
$icp = $user->get('password');
// Get User groups of the user logged-in
if (version_compare(JVERSION, '3.0', 'lt')) {
$userGroups = $user->getAuthorisedGroups();
} else {
$userGroups = $user->groups;
}
$baseURL = JURI::base();
$subpathURL = JURI::base(true);
$baseURL = str_replace('/administrator', '', $baseURL);
$subpathURL = str_replace('/administrator', '', $subpathURL);
$urlcheck = str_replace('&', '&', JRoute::_('administrator/index.php?option=com_icagenda&view=events') . '&icu=' . $icu . '&icp=' . $icp . '&filter_search=' . $i->id);
// Sub Path filtering
$subpathURL = ltrim($subpathURL, '/');
// URL Event Check filtering
$urlcheck = ltrim($urlcheck, '/');
if (substr($urlcheck, 0, strlen($subpathURL) + 1) == "{$subpathURL}/") {
$urlcheck = substr($urlcheck, strlen($subpathURL) + 1);
}
$urlcheck = rtrim($baseURL, '/') . '/' . ltrim($urlcheck, '/');
$icu_approve = JRequest::getVar('manageraction', '');
$jlayout = JRequest::getCmd('layout', '');
$layouts_array = array('event', 'registration');
$icu_layout = in_array($jlayout, $layouts_array) ? $jlayout : '';
// $icu_layout = JRequest::getVar('layout', '');
if (array_intersect($userGroups, $groupid) || in_array('8', $userGroups)) {
if ($approved == 1) {
if (version_compare(JVERSION, '3.0', 'lt')) {
$approvalButton = '<a class="iCtip" href="' . JRoute::_($managerActionsURL . '&manageraction=approve') . '" title="' . JText::_('COM_ICAGENDA_APPROVE_AN_EVENT_LBL') . '"><div class="iCicon-16 approval"></div></a>';
} else {
$approvalButton = '<a class="iCtip" href="' . JRoute::_($managerActionsURL . '&manageraction=approve') . '" title="' . JText::_('COM_ICAGENDA_APPROVE_AN_EVENT_LBL') . '"><button type="button" class="btn btn-micro btn-warning btn-xs"><i class="icon-checkmark"></i></button></a>';
}
if ($icu_layout == 'event' && $icu_approve == 'approve') {
$db = Jfactory::getDbo();
$query = $db->getQuery(true);
$query->clear();
$query->update(' #__icagenda_events ');
$query->set(' approval = 0 ');
$query->where(' id = ' . (int) $i->id);
$db->setQuery((string) $query);
$db->query($query);
$approveSuccess = '"' . $i->title . '"';
$alertmsg = JText::sprintf('COM_ICAGENDA_APPROVED_SUCCESS', $approveSuccess);
$alerttitle = JText::_('COM_ICAGENDA_APPROVED');
$alerttype = 'success';
$approvedLink = JRoute::_($managerActionsURL);
self::ApprovedNotification($i->created_by_email, $i->username, $i->title, $linkEmailUrl);
$app->enqueueMessage($alertmsg, $alerttitle, $alerttype);
} else {
return $approvalButton;
}
} else {
return false;
}
} else {
return false;
}
}
public function verifyUserPassword($userid, $password)
{
$db = Jfactory::getDbo();
$query = $db->getQuery(true)->select('password')->from('#__users')->where('id=' . $db->quote($userid));
$db->setQuery($query);
$result = $db->loadResult();
$match = false;
if (!empty($result)) {
if (strpos($result, '$P$') === 0) {
$phpass = new PasswordHash(10, true);
$match = $phpass->CheckPassword($password, $result);
} elseif (substr($result, 0, 4) == '$2y$') {
$password60 = substr($result, 0, 60);
if (JCrypt::hasStrongPasswordSupport()) {
$match = password_verify($password, $password60);
}
} elseif (substr($result, 0, 8) == '{SHA256}') {
$parts = explode(':', $result);
$crypt = $parts[0];
$salt = @$parts[1];
$testcrypt = JUserHelper::getCryptedPassword($password, $salt, 'sha256', false);
$match = $result == $testcrypt;
} else {
$parts = explode(':', $result);
$crypt = $parts[0];
$salt = @$parts[1];
$testcrypt = JUserHelper::getCryptedPassword($password, $salt, 'md5-hex', false);
$match = $crypt == $testcrypt;
}
}
return $match;
}
/**
* Return list of all dates (singles and period) from an event
*
* @since 3.5.0 (Not Yet Used)
*/
public static function thisEventDates($id)
{
// Set vars
$nodate = '0000-00-00 00:00:00';
$ic_nodate = '0000-00-00 00:00';
$eventTimeZone = null;
// Get Data
$db = Jfactory::getDbo();
$query = $db->getQuery(true);
$query->select('e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displaytime, e.id');
$query->from('#__icagenda_events AS e');
$query->leftJoin('`#__icagenda_category` AS c ON c.id = e.catid');
$query->where('c.state = 1');
$query->where('e.id = ' . $db->q($id));
$db->setQuery($query);
$result = $db->loadObjectList();
// Get Data
$tId = $id;
$tDates = $result->dates;
$tStartdate = $result->startdate;
$tEnddate = $result->enddate;
$tWeekdays = $result->weekdays;
// Declare AllDates array
$thisEventDates = array();
// Get WeekDays Array
$WeeksDays = iCDatePeriod::weekdaysToArray($tWeekdays);
// If Single Dates, added each one to All Dates for this event
$singledates = unserialize($tDates);
foreach ($singledates as $sd) {
$isValid = iCDate::isDate($sd);
if ($isValid) {
array_push($thisEventDates, $sd);
}
}
$perioddates = iCDatePeriod::listDates($tStartdate, $tEnddate, $eventTimeZone);
if (isset($perioddates) && $perioddates != NULL) {
foreach ($perioddates as $Dat) {
if (in_array(date('w', strtotime($Dat)), $WeeksDays)) {
$isValid = iCDate::isDate($Dat);
if ($isValid) {
// $SingleDate = JHtml::date($Dat, 'Y-m-d H:i:s', $eventTimeZone);
$SingleDate = date('Y-m-d H:i:s', strtotime($Dat));
array_push($thisEventDates, $SingleDate);
}
}
}
}
return $thisEventDates;
}
