public static function checkPassword($documentObject)
{
$isDocumentOwner = JUDownloadFrontHelperPermission::isDocumentOwner($documentObject->id);
$isModerator = JUDownloadFrontHelperModerator::isModerator();
if ($isDocumentOwner)
{
$asset = 'com_judownload.document.' . $documentObject->id;
$user = JFactory::getUser();
if ($user->authorise('judl.document.download.own.no_restrict', $asset))
{
return true;
}
}
if ($isModerator)
{
$mainCategory = JUDownloadFrontHelperCategory::getMainCategory($documentObject->id);
$modCanDownload = JUDownloadFrontHelperModerator::checkModeratorCanDoWithDocument($mainCategory->id, 'document_download');
if ($modCanDownload)
{
return true;
}
if ($documentObject->approved < 1)
{
$modCanApproval = JUDownloadFrontHelperModerator::checkModeratorCanDoWithDocument($mainCategory->id, 'document_approve');
if ($modCanApproval)
{
return true;
}
}
}
$session = JFactory::getSession();
if ($session->get('judl-download-password-' . $documentObject->id, '') === $documentObject->download_password)
{
return true;
}
else
{
return false;
}
}
public function getItem()
{
$params = $this->getState('params');
$documentId = (int) $this->getState('document.id');
if (!$documentId)
{
JError::raiseError(404, JText::_('COM_JUDOWNLOAD_DOCUMENT_NOT_FOUND'));
return false;
}
$user = JFactory::getUser();
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('d.*, c.id AS cat_id');
$query->from('#__judownload_documents AS d');
$query->join('', '#__judownload_documents_xref AS dxref ON d.id = dxref.doc_id AND dxref.main=1');
$query->join('', '#__judownload_categories AS c ON c.id = dxref.cat_id');
$query->select('(SELECT COUNT(*) FROM #__judownload_files AS f WHERE f.doc_id = d.id AND f.published = 1) AS total_files');
$query->select('(SELECT COUNT(*) FROM #__judownload_comments AS cm WHERE cm.doc_id = d.id AND cm.approved = 1 AND cm.published = 1) AS total_comments');
$query->select('(SELECT COUNT(*) FROM #__judownload_subscriptions AS sub WHERE sub.item_id = d.id AND sub.type = "document" AND sub.published = 1) AS total_subscriptions');
$query->select('(SELECT COUNT(*) FROM #__judownload_reports AS r WHERE r.item_id = d.id AND r.type = "document") AS total_reports');
$query->select('(SELECT GROUP_CONCAT(catids.id ORDER BY dx_catids.main DESC, dx_catids.ordering ASC SEPARATOR ",") FROM (#__judownload_categories AS catids JOIN #__judownload_documents_xref AS dx_catids ON catids.id = dx_catids.cat_id) WHERE d.id = dx_catids.doc_id GROUP BY d.id) AS cat_ids');
$query->select('(SELECT GROUP_CONCAT(cattitles.title ORDER BY dx_cattitles.main DESC, dx_cattitles.ordering ASC SEPARATOR "|||") FROM (#__judownload_categories AS cattitles JOIN #__judownload_documents_xref AS dx_cattitles ON cattitles.id = dx_cattitles.cat_id) WHERE d.id = dx_cattitles.doc_id GROUP BY d.id) AS cat_titles');
$accessLevel = implode(',', $user->getAuthorisedViewLevels());
$db = JFactory::getDbo();
$date = JFactory::getDate();
$nullDate = $db->quote($db->getNullDate());
$nowDate = $db->quote($date->toSql());
$fieldQuery = $db->getQuery(true);
$fieldQuery->select('field.id');
$fieldQuery->from('#__judownload_fields AS field');
$fieldQuery->where('field.group_id != 1');
$fieldQuery->where('field.details_view = 1');
$fieldQuery->where('field.published = 1');
$fieldQuery->where('field.publish_up <= ' . $nowDate);
$fieldQuery->where('(field.publish_down = ' . $nullDate . ' OR field.publish_down > ' . $nowDate . ')');
$fieldQuery->where('(field.access IN (' . $accessLevel . ') OR field.who_can_download_can_access = 1)');
$category = JUDownloadFrontHelperCategory::getMainCategory($documentId);
if (is_object($category))
{
$fieldQuery->where('field.group_id = ' . $category->fieldgroup_id);
}
$fieldQuery->join('', '#__judownload_fields_groups AS field_group ON field.group_id = field_group.id');
$fieldQuery->where('field_group.published = 1');
$fieldQuery->where('field_group.access IN (' . $accessLevel . ')');
$fieldQuery->group('field.id');
$db->setQuery($fieldQuery);
$fields = $db->loadObjectList();
foreach ($fields AS $field)
{
$query->select('IFNULL (fields_values_' . $field->id . '.value, "") AS field_values_' . $field->id);
$query->join('LEFT', '#__judownload_fields_values AS fields_values_' . $field->id . ' ON fields_values_' . $field->id . '.doc_id = d.id AND fields_values_' . $field->id . '.field_id = ' . $field->id);
}
$query->where('d.id = ' . $documentId);
$db->setQuery($query);
$documentObject = $db->loadObject();
if (!is_object($documentObject))
{
JError::raiseError(404, JText::_('COM_JUDOWNLOAD_DOCUMENT_NOT_FOUND'));
return false;
}
$documentObject->params = JUDownloadFrontHelperDocument::getDocumentDisplayParams($documentObject->id);
if (!$user->get('guest'))
{
$canEditDocument = JUDownloadFrontHelperPermission::canEditDocument($documentObject->id);
$canDeleteDocument = JUDownloadFrontHelperPermission::canDeleteDocument($documentObject->id);
$canEditStateDocument = JUDownloadFrontHelperPermission::canEditStateDocument($documentObject);
$documentObject->params->set('access-edit', $canEditDocument);
$documentObject->params->set('access-edit-state', $canEditStateDocument);
$documentObject->params->set('access-delete', $canDeleteDocument);
}
$canReportDocument = JUDownloadFrontHelperPermission::canReportDocument($documentObject->id);
$canContactDocument = JUDownloadFrontHelperPermission::canContactDocument($documentObject->id);
$canRateDocument = JUDownloadFrontHelperPermission::canRateDocument($documentObject->id);
$canDownloadDocument = JUDownloadFrontHelperPermission::canDownloadDocument($documentObject->id, false);
$canCommentDocument = JUDownloadFrontHelperPermission::canComment($documentObject->id);
$documentObject->params->set('access-report', $canReportDocument);
$documentObject->params->set('access-contact', $canContactDocument);
$documentObject->params->set('access-rate', $canRateDocument);
$documentObject->params->set('access-download', $canDownloadDocument);
$documentObject->params->set('access-comment', $canCommentDocument);
$hasPassword = JUDownloadFrontHelperDocument::documentHasPassword($documentObject);
$documentObject->params->set('has-password', $hasPassword);
if ($hasPassword)
{
$validPassword = JUDownloadFrontHelperPassword::checkPassword($documentObject);
}
else
{
$validPassword = true;
}
$documentObject->params->set('valid-password', $validPassword);
if ($canDownloadDocument && !$validPassword)
{
$documentObject->allow_enter_password = JUDownloadFrontHelperPassword::allowEnterPassword($documentObject->id);
}
$token = JSession::getFormToken();
$return = base64_encode(urlencode(JUri::getInstance()));
$documentObject->download_link = JRoute::_('index.php?option=com_judownload&task=download.download&doc_id=' . $documentObject->id . '&' . $token . '=1');
$documentObject->download_link .= '&return=' . $return;
if ($params->get('show_rule_messages', 'modal') != 'hide')
{
$downloadRuleErrorMessages = JUDownloadFrontHelperDocument::getDownloadRuleErrorMessages($documentObject->id);
if ($downloadRuleErrorMessages !== true)
{
$documentObject->error_msg = $downloadRuleErrorMessages;
}
}
$documentObject->template_params = new JRegistry($documentObject->template_params);
if ($params->get('show_new_label', 1) && JUDownloadFrontHelper::isWithinXDays($documentObject->publish_up, $params->get('num_day_to_show_as_new', 10)))
{
$documentObject->label_new = true;
}
else
{
$documentObject->label_new = false;
}
if ($params->get('show_updated_label', 1) && JUDownloadFrontHelper::isWithinXDays($documentObject->updated, $params->get('num_day_to_show_as_updated', 10)))
{
$documentObject->label_updated = true;
}
else
{
$documentObject->label_updated = false;
}
if ($params->get('show_hot_label', 1) && JUDownloadFrontHelperDocument::checkHotDocument($documentObject->publish_up, $params->get('num_download_per_day_to_be_hot', 10), $documentObject->downloads))
{
$documentObject->label_hot = true;
}
else
{
$documentObject->label_hot = false;
}
if ($params->get('show_featured_label', 1) && $documentObject->featured)
{
$documentObject->label_featured = true;
}
else
{
$documentObject->label_featured = false;
}
$documentObject->next_item = $this->getNextPrevItem($documentObject, 'next');
$documentObject->prev_item = $this->getNextPrevItem($documentObject, 'prev');
$documentObject->is_subscriber = $this->isSubscriber($user->id, $documentObject->id, 'document');
return $documentObject;
}
