public static function isListingPublished($listingId)
{
$listingObject = JUDirectoryHelper::getListingById($listingId);
if (!is_object($listingObject)) {
return false;
}
$catPublished = JUDirectoryFrontHelperPermission::canDoCategory($listingObject->cat_id);
if (!$catPublished) {
return false;
}
$db = JFactory::getDbo();
$nullDate = $db->getNullDate();
$nowDate = JFactory::getDate()->toSql();
$query = $db->getQuery(true);
$query->select('COUNT(*)');
$query->from('#__judirectory_listings');
$query->where('approved = 1');
$query->where('published = 1');
$query->where('(publish_up = ' . $db->quote($nullDate) . ' OR publish_up <= ' . $db->quote($nowDate) . ')');
$query->where('(publish_down = ' . $db->quote($nullDate) . ' OR publish_down >= ' . $db->quote($nowDate) . ')');
$query->where('id =' . $listingId);
$db->setQuery($query);
$result = $db->loadResult();
if ($result) {
return true;
}
return false;
}
public function display($tpl = null)
{
$app = JFactory::getApplication();
$categoryId = $app->input->getInt('id', 1);
$this->category = JUDirectoryFrontHelperCategory::getCategory($categoryId);
$error = array();
if (!JUDirectoryFrontHelperPermission::canDoCategory($this->category->id, true, $error)) {
$user = JFactory::getUser();
if ($user->id) {
return JError::raiseError($error['code'], $error['message']);
} else {
$uri = JUri::getInstance();
$loginUrl = JRoute::_('index.php?option=com_users&view=login&return=' . base64_encode($uri), false);
$app = JFactory::getApplication();
$app->redirect($loginUrl, JText::_('COM_JUDIRECTORY_YOU_ARE_NOT_AUTHORIZED_TO_ACCESS_THIS_PAGE'), 'warning');
return false;
}
}
$model = $this->getModel();
$this->model = $model;
$this->state = $this->get('State');
$this->params = $this->state->params;
if (count($errors = $this->get('Errors'))) {
JError::raiseError(500, implode("\n", $errors));
return false;
}
$this->parent_id = $this->category->id;
$this->subcategory_level = (int) $this->params->get('all_categories_subcategory_level', -1);
$this->all_categories = $model->getCategoriesRecursive($this->category->id, $this->subcategory_level);
$firstCategory = $this->all_categories[0];
$this->category->total_childs = $firstCategory->total_childs;
$this->pageclass_sfx = htmlspecialchars($this->params->get('pageclass_sfx'));
$this->_prepareDocument();
$this->_setBreadcrumb();
parent::display($tpl);
}
public function getCatIdTree($catId, $includeItSelf = true)
{
$catId = (int) $catId;
if (!$catId) {
return null;
}
if (!JUDirectoryFrontHelperPermission::canDoCategory($catId)) {
return null;
}
$cat_id_arr = array();
if ($includeItSelf) {
$cat_id_arr[] = $catId;
}
$db = JFactory::getDbo();
$query = "SELECT id FROM #__judirectory_categories WHERE parent_id = " . $catId;
$db->setQuery($query);
$child_cat_ids = $db->loadColumn();
foreach ($child_cat_ids as $child_cat_id) {
$cat_id_arr[] = $child_cat_id;
$child_cat_id_arr = $this->getCatIdTree($child_cat_id, false);
if ($child_cat_id_arr) {
$cat_id_arr = array_merge($cat_id_arr, $child_cat_id_arr);
}
}
return array_unique($cat_id_arr);
}
public function display($tpl = null)
{
$model = $this->getModel();
$this->model = $model;
$this->state = $this->get('State');
$params = $this->state->params;
$this->params = $params;
$this->token = JSession::getFormToken();
$this->root_category = JUDirectoryFrontHelperCategory::getRootCategory();
$categoryId = $this->state->get('category.id', $this->root_category->id);
if (count($errors = $this->get('Errors'))) {
JError::raiseWarning(500, implode("\n", $errors));
return false;
}
$error = array();
if (!JUDirectoryFrontHelperPermission::canDoCategory($categoryId, true, $error)) {
$user = JFactory::getUser();
if ($user->id) {
return JError::raiseError($error['code'], $error['message']);
} else {
$uri = JUri::getInstance();
$loginUrl = JRoute::_('index.php?option=com_users&view=login&return=' . base64_encode($uri), false);
$app = JFactory::getApplication();
$app->redirect($loginUrl, JText::_('COM_JUDIRECTORY_YOU_ARE_NOT_AUTHORIZED_TO_ACCESS_THIS_PAGE'), 'warning');
return false;
}
}
$topLevelCats = JUDirectoryHelper::getCatsByLevel(1, $categoryId);
if (is_array($topLevelCats) && count($topLevelCats) > 0) {
$this->tl_catid = $topLevelCats[0]->id;
}
$this->category = JUDirectoryFrontHelperCategory::getCategory($categoryId);
$this->show_feed = JUDIRPROVERSION ? $this->params->get('rss_display_icon', 1) : 0;
$this->rss_link = JRoute::_(JUDirectoryHelperRoute::getCategoryRoute($this->category->id, null, true));
if (isset($this->category->images) && !empty($this->category->images) && !empty($this->category->images->detail_image)) {
$this->category->images->detail_image_src = JUri::root(true) . '/' . JUDirectoryFrontHelper::getDirectory('category_detail_image_directory', 'media/com_judirectory/images/category/detail/', true) . $this->category->images->detail_image;
}
$this->category->images->detail_image_width = (int) $this->params->get('category_image_width', 200);
$this->category->images->detail_image_height = (int) $this->params->get('category_image_height', 200);
if ($this->params->get('category_show_description', 1)) {
$this->category->description = $this->category->introtext . $this->category->fulltext;
} else {
$this->category->description = $this->category->fulltext;
}
$categoryDescLimit = (int) $this->params->get('category_desc_limit', 0);
if ($categoryDescLimit > 0) {
$this->category->description = JUDirectoryFrontHelperString::truncateHtml($this->category->description, $categoryDescLimit);
}
if ($this->params->get('plugin_support', 0)) {
$this->category->description = JHtml::_('content.prepare', $this->category->description, '', 'com_judirectory.category');
}
$this->category->class_sfx = htmlspecialchars($this->category->class_sfx);
$relatedCatOrdering = $this->params->get('related_category_ordering', 'crel.ordering');
$relatedCatDirection = $this->params->get('related_category_direction', 'ASC');
$this->related_cats = $model->getRelatedCategories($this->category->id, $relatedCatOrdering, $relatedCatDirection);
if (is_array($this->related_cats) && count($this->related_cats) > 0) {
foreach ($this->related_cats as $relatedCategory) {
if (isset($relatedCategory->images->intro_image) && !empty($relatedCategory->images->intro_image)) {
$relatedCategory->images->intro_image_src = JUri::root(true) . '/' . JUDirectoryFrontHelper::getDirectory('category_intro_image_directory', 'media/com_judirectory/images/category/intro/', true) . $relatedCategory->images->intro_image;
}
$relatedCategory->images->intro_image_width = (int) $this->params->get('related_category_intro_image_width', 200);
$relatedCategory->images->intro_image_height = (int) $this->params->get('related_category_intro_image_height', 200);
if ($this->params->get('related_category_show_introtext', 1)) {
$relatedCategoryDescLimit = (int) $this->params->get('related_category_introtext_character_limit', 500);
if ($relatedCategoryDescLimit > 0) {
$relatedCategory->introtext = JUDirectoryFrontHelperString::truncateHtml($relatedCategory->introtext, $relatedCategoryDescLimit);
}
if ($params->get('plugin_support', 0)) {
$relatedCategory->introtext = JHtml::_('content.prepare', $relatedCategory->introtext, '', 'com_judirectory.category');
}
} else {
$relatedCategory->introtext = '';
}
}
}
$subCatOrdering = $this->params->get('subcategory_ordering', 'title');
$subCatDirection = $this->params->get('subcategory_direction', 'ASC');
$this->subcategories = $model->getSubCategories($this->category->id, $subCatOrdering, $subCatDirection);
if (is_array($this->subcategories) && count($this->subcategories) > 0) {
foreach ($this->subcategories as $subCategory) {
if (isset($subCategory->images->intro_image) && !empty($subCategory->images->intro_image)) {
$subCategory->images->intro_image_src = JUri::root(true) . '/' . JUDirectoryFrontHelper::getDirectory('category_intro_image_directory', 'media/com_judirectory/images/category/intro/', true) . $subCategory->images->intro_image;
}
$subCategory->images->intro_image_width = (int) $this->params->get('subcategory_intro_image_width', 200);
$subCategory->images->intro_image_height = (int) $this->params->get('subcategory_intro_image_height', 200);
if ($this->params->get('subcategory_show_introtext', 1)) {
$subCategoryDescLimit = (int) $this->params->get('subcategory_introtext_character_limit', 500);
if ($subCategoryDescLimit > 0) {
$subCategory->introtext = JUDirectoryFrontHelperString::truncateHtml($subCategory->introtext, $subCategoryDescLimit);
}
if ($this->params->get('plugin_support', 0)) {
$subCategory->introtext = JHtml::_('content.prepare', $subCategory->introtext, '', 'com_judirectory.category');
}
} else {
$subCategory->introtext = '';
}
}
}
$this->category->can_submit_listing = JUDirectoryFrontHelperPermission::canSubmitListing($this->category->id);
if ($this->category->can_submit_listing && $this->params->get('show_submit_listing_btn_in_category', 1)) {
$this->category->submit_listing_link = JUDirectoryFrontHelperListing::getAddListingLink($this->category->id);
}
$this->items = array();
if ($this->category->show_item) {
$user = JFactory::getUser();
$uri = JUri::getInstance();
$this->items = $this->get('Items');
foreach ($this->items as $item) {
$item->report_link = JRoute::_(JUDirectoryHelperRoute::getReportListingRoute($item->id));
$item->claim_link = JRoute::_(JUDirectoryHelperRoute::getClaimListingRoute($item->id));
if ($item->checked_out > 0 && $item->checked_out != $user->get('id')) {
if (JUDirectoryFrontHelperPermission::canCheckInListing($item->id)) {
$item->checkin_link = JRoute::_('index.php?option=com_judirectory&task=forms.checkin&id=' . $item->id . '&' . JSession::getFormToken() . '=1' . '&return=' . base64_encode(urlencode($uri)));
}
} else {
$item->edit_link = JRoute::_('index.php?option=com_judirectory&task=form.edit&id=' . $item->id . '&Itemid=' . JUDirectoryHelperRoute::findItemIdOfListing($item->id));
if ($item->published == 1) {
$item->editstate_link = JRoute::_('index.php?option=com_judirectory&task=forms.unpublish&id=' . $item->id . '&return=' . base64_encode(urlencode($uri)) . '&' . JSession::getFormToken() . '=1&Itemid=' . JUDirectoryHelperRoute::findItemIdOfListing($item->id));
} else {
$item->editstate_link = JRoute::_('index.php?option=com_judirectory&task=forms.publish&id=' . $item->id . '&return=' . base64_encode(urlencode($uri)) . '&' . JSession::getFormToken() . '=1&Itemid=' . JUDirectoryHelperRoute::findItemIdOfListing($item->id));
}
}
$item->delete_link = JRoute::_('index.php?option=com_judirectory&task=forms.delete&id=' . $item->id . '&return=' . base64_encode(urlencode($uri)) . '&' . JSession::getFormToken() . '=1&Itemid=' . JUDirectoryHelperRoute::findItemIdOfListing($item->id));
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('content');
$item->event = new stdClass();
$context = 'com_judirectory.listing_list';
$results = $dispatcher->trigger('onContentAfterTitle', array($context, &$item, &$item->params, 0));
$item->event->afterDisplayTitle = trim(implode("\n", $results));
$results = $dispatcher->trigger('onContentBeforeDisplay', array($context, &$item, &$item->params, 0));
$item->event->beforeDisplayContent = trim(implode("\n", $results));
$results = $dispatcher->trigger('onContentAfterDisplay', array($context, &$item, &$item->params, 0));
$item->event->afterDisplayContent = trim(implode("\n", $results));
}
$this->pagination = $this->get('Pagination');
//print_r($this->pagination);
}
$this->locations = JUDirectoryFrontHelper::getLocations($this->items);
//print_r($this->locations);
$this->pageclass_sfx = htmlspecialchars($this->params->get('pageclass_sfx'));
$this->_prepareData();
$this->_prepareDocument();
$this->_setBreadcrumb();
parent::display($tpl);
}
public static function canViewListing($listingId)
{
$listingObject = JUDirectoryHelper::getListingById($listingId);
if (!is_object($listingObject)) {
return false;
}
$canDoCategory = JUDirectoryFrontHelperPermission::canDoCategory($listingObject->cat_id, true);
if (!$canDoCategory) {
return false;
}
if ($listingObject->approved == 1) {
$canEditListing = JUDirectoryFrontHelperPermission::canEditListing($listingId);
$canEditStateListing = JUDirectoryFrontHelperPermission::canEditStateListing($listingObject);
$userCanDoListing = JUDirectoryFrontHelperPermission::userCanDoListing($listingId, true);
if ($canEditListing || $canEditStateListing || $userCanDoListing) {
return true;
}
}
$isListingPublished = JUDirectoryFrontHelperListing::isListingPublished($listingId);
$isListingOwner = JUDirectoryFrontHelperPermission::isListingOwner($listingId);
if ($isListingOwner) {
$params = JUDirectoryHelper::getParams(null, $listingId);
if ($listingObject->approved <= 0 || $isListingPublished || !$isListingPublished && $params->get('listing_owner_can_view_unpublished_listing', 0)) {
return true;
}
}
$isModerator = JUDirectoryFrontHelperModerator::isModerator();
if ($isModerator) {
if ($listingObject->approved == 1) {
if ($isListingPublished) {
$modCanViewListing = JUDirectoryFrontHelperModerator::checkModeratorCanDoWithListing($listingObject->cat_id, 'listing_view');
if ($modCanViewListing) {
return true;
}
} else {
$modCanViewListing = JUDirectoryFrontHelperModerator::checkModeratorCanDoWithListing($listingObject->cat_id, 'listing_view_unpublished');
if ($modCanViewListing) {
return true;
}
}
} else {
$modCanViewListing = JUDirectoryFrontHelperModerator::checkModeratorCanDoWithListing($listingObject->cat_id, 'listing_approve');
if ($modCanViewListing) {
return true;
}
}
}
return false;
}
