public static function canViewDocument($documentId) { $documentObject = JUDownloadHelper::getDocumentById($documentId); if (!is_object($documentObject)) { return false; } $canDoCategory = JUDownloadFrontHelperPermission::canDoCategory($documentObject->cat_id, true); if (!$canDoCategory) { return false; } if ($documentObject->approved == 1) { $canEditDocument = JUDownloadFrontHelperPermission::canEditDocument($documentId); $canEditStateDocument = JUDownloadFrontHelperPermission::canEditStateDocument($documentObject); $userCanDoDocument = JUDownloadFrontHelperPermission::userCanDoDocument($documentId, true); if ($canEditDocument || $canEditStateDocument || $userCanDoDocument) { return true; } } $isDocumentPublished = JUDownloadFrontHelperDocument::isDocumentPublished($documentId); $isDocumentOwner = JUDownloadFrontHelperPermission::isDocumentOwner($documentId); if ($isDocumentOwner) { $params = JUDownloadHelper::getParams(null, $documentId); if ($documentObject->approved <= 0 || $isDocumentPublished || (!$isDocumentPublished && $params->get('document_owner_can_view_unpublished_document', 0))) { return true; } } $isModerator = JUDownloadFrontHelperModerator::isModerator(); if ($isModerator) { if ($documentObject->approved == 1) { if ($isDocumentPublished) { $modCanViewDocument = JUDownloadFrontHelperModerator::checkModeratorCanDoWithDocument($documentObject->cat_id, 'document_view'); if ($modCanViewDocument) { return true; } } else { $modCanViewDocument = JUDownloadFrontHelperModerator::checkModeratorCanDoWithDocument($documentObject->cat_id, 'document_view_unpublished'); if ($modCanViewDocument) { return true; } } } else { $modCanViewDocument = JUDownloadFrontHelperModerator::checkModeratorCanDoWithDocument($documentObject->cat_id, 'document_approve'); if ($modCanViewDocument) { return true; } } } 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; }
public static function appendDataToDocumentObjList(&$documentObjectList, $params, $usingForMod = false) { if (is_array($documentObjectList) && count($documentObjectList)) { $user = JFactory::getUser(); $token = JSession::getFormToken(); $return = base64_encode(urlencode(JUri::getInstance())); foreach ($documentObjectList AS $documentObject) { JUDownloadHelper::getDocumentById($documentObject->id, false, $documentObject); $documentObject->params = JUDownloadFrontHelperDocument::getDocumentDisplayParams($documentObject->id); if (!isset($documentObject->total_files)) { $documentObject->total_files = JUDownloadFrontHelperDocument::getTotalPublishedFilesOfDocument($documentObject->id); } if (!$user->get('guest')) { $canEditDocument = JUDownloadFrontHelperPermission::canEditDocument($documentObject->id); $canEditStateDocument = JUDownloadFrontHelperPermission::canEditStateDocument($documentObject); $canDeleteDocument = JUDownloadFrontHelperPermission::canDeleteDocument($documentObject->id); $documentObject->params->set('access-edit', $canEditDocument); $documentObject->params->set('access-edit-state', $canEditStateDocument); $documentObject->params->set('access-delete', $canDeleteDocument); } if ($params->get('show_report_btn_in_listview', 1) || $usingForMod) { $canReportDocument = JUDownloadFrontHelperPermission::canReportDocument($documentObject->id); $documentObject->params->set('access-report', $canReportDocument); } if ($params->get('show_download_btn_in_listview', 1) || $usingForMod) { $canDownloadDocument = JUDownloadFrontHelperPermission::canDownloadDocument($documentObject->id, false); $documentObject->params->set('access-download', $canDownloadDocument); $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); } $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; } } } if ($documentObject->published != 1) { $documentObject->label_unpublished = true; } else { $documentObject->label_unpublished = false; } $documentObject->label_pending = false; $nowDate = JFactory::getDate()->toSql(); if (intval($documentObject->publish_up) > 0) { if (strtotime($documentObject->publish_up) > strtotime($nowDate)) { $documentObject->label_pending = true; } } $documentObject->label_expired = false; if (intval($documentObject->publish_down) > 0) { if (intval($documentObject->publish_up) > 0) { if (strtotime($documentObject->publish_up) <= strtotime($nowDate)) { if (strtotime($documentObject->publish_down) < strtotime($nowDate)) { $documentObject->label_expired = true; } } } else { if (strtotime($documentObject->publish_down) < strtotime($nowDate)) { $documentObject->label_expired = true; } } } 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; } } } }