protected function getInput()
{
$app = JFactory::getApplication();
$modId = $app->input->getInt('id', 0);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('user_id');
$query->from('#__judownload_moderators');
$query->where('id =' . $modId);
$db->setQuery($query);
$query = $db->getQuery(true);
$query->select('cat_id');
$query->from('#__judownload_moderators_xref');
$query->where('mod_id = ' . $modId);
$db->setQuery($query);
$categoryIdsAssignedMod = $db->loadColumn();
$html = "<div id=\"moderator-assign\" class=\"moderator-assign pull-left\">";
$select_cat_class = 'select-cat';
$html .= '<div class="btn-group pull-left">';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', !jQuery(this).is(\':checked\')); });">' . JText::_('JGLOBAL_SELECTION_INVERT') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', false); });">' . JText::_('JGLOBAL_SELECTION_NONE') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', true); });">' . JText::_('JGLOBAL_SELECTION_ALL') . '</button>';
$html .= '</div>';
$categoryTree = JUDownloadHelper::getCategoryTree();
$html .= "<ul id=\"" . $this->id . "\" class=\"nav\">";
foreach ($categoryTree as $category) {
$html .= "<li>";
if (in_array($category->id, $categoryIdsAssignedMod)) {
if (!in_array($category->id, $categoryIdsAssignedMod)) {
$html .= "<input id=\"catid-" . $category->id . "\" disabled type=\"checkbox\" value=\"" . $category->id . "\" name=\"jform[assigntocats][]\"/>";
} else {
$html .= "<input id=\"catid-" . $category->id . "\" class=\"" . $select_cat_class . "\" checked type=\"checkbox\" value=\"" . $category->id . "\" name=\"jform[assigntocats][]\"/>";
}
} else {
$html .= "<input id=\"catid-" . $category->id . "\" class=\"" . $select_cat_class . "\" type=\"checkbox\" value=\"" . $category->id . "\" name=\"jform[assigntocats][]\"/>";
}
$html .= "<label for=\"catid-" . $category->id . "\">" . str_repeat('<span class="gi">|—</span>', $category->level) . "<a href='index.php?option=com_judownload&task=category.edit&id=" . $category->id . "'>" . $category->title . "</a></label>";
$html .= "</li>";
}
$html .= "</ul>";
$html .= "</div>";
if ($modId != 0) {
return $html;
} else {
$html = "<div id=\"moderator-assign\" class=\"moderator-assign pull-left\">";
$html .= JText::_('COM_JUDOWNLOAD_PLEASE_SELECT_USER_BEFORE_SELECT_CATEGORY');
$html .= "</div>";
return $html;
}
}
protected function getInput()
{
$fieldgroup_id = $this->form->getValue('id');
$rootCategory = JUDownloadFrontHelperCategory::getRootCategory();
$categoryTree = JUDownloadHelper::getCategoryTree($rootCategory->id);
$html = "<div id=\"categoriestoassignfieldgroup\" class=\"categoriestoassignfieldgroup\">";
if ($this->form->getValue('id') == 1) {
$html .= '<input type="text" class="readonly" readonly="readonly" value="' . JText::_('JALL') . '"/>';
} else {
$select_cat_class = 'select-cat';
$html .= '<div class="btn-group pull-left">';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', !jQuery(this).is(\':checked\')); });">' . JText::_('JGLOBAL_SELECTION_INVERT') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', false); });">' . JText::_('JGLOBAL_SELECTION_NONE') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', true); });">' . JText::_('JGLOBAL_SELECTION_ALL') . '</button>';
$html .= '</div>';
$html .= "<ul id=\"" . $this->id . "\" class=\"nav\">";
$html .= "<li>";
$html .= "<input id=\"catid-" . $rootCategory->id . "\" type=\"checkbox\" value=\"" . $rootCategory->id . "\" disabled=\"true\" />";
$html .= "<label for=\"catid-" . $rootCategory->id . "\">" . str_repeat('<span class="gi">|—</span>', $rootCategory->level) . $rootCategory->title . "</label>";
$html .= "</li>";
foreach ($categoryTree as $category) {
if ($category->id == $rootCategory->id) {
continue;
}
$link_edit_fieldgroup = '';
$html .= "<li>";
if ($category->selected_fieldgroup == -1 && $category->fieldgroup_id > 0) {
$html .= "<span class=\"inherited-value\" title=\"" . JText::_("COM_JUDOWNLOAD_INHERIT") . "\">" . JText::_('COM_JUDOWNLOAD_INHERIT') . "</span>";
} elseif ($category->fieldgroup_id == $fieldgroup_id) {
$html .= "<input class =\"" . $select_cat_class . "\" id=\"catid-" . $category->id . "\" type=\"checkbox\" value=\"" . $category->id . "\" checked=\"checked\" name=\"" . $this->name . "[]\"/>";
} elseif ($category->fieldgroup_id > 0) {
$link_edit_fieldgroup = "<span><a href=\"index.php?option=com_judownload&task=fieldgroup.edit&id=" . $category->fieldgroup_id . "\" title=\"" . $this->getFieldGroupName($category->fieldgroup_id) . "\" >[" . $this->getFieldGroupName($category->fieldgroup_id) . "]</a></span>";
$html .= "<input id=\"catid-" . $category->id . "\" type=\"checkbox\" checked=\"checked\" value=\"" . $category->id . "\" disabled=\"true\" />";
} else {
$html .= "<input class =\"" . $select_cat_class . "\" id=\"catid-" . $category->id . "\" type=\"checkbox\" value=\"" . $category->id . "\" name=\"" . $this->name . "[]\"/>";
}
$html .= "<label for=\"catid-" . $category->id . "\">" . str_repeat('<span class="gi">|—</span>', $category->level) . $category->title . "</label>";
$html .= $link_edit_fieldgroup;
$html .= "</li>";
}
$html .= "</ul>";
}
$html .= "</div>";
return $html;
}
protected function _prepareQuery($fieldNames, $filter)
{
if (empty($fieldNames)) {
return false;
}
$db = $this->getDbo();
$fieldNames = array_map(function ($element) {
$element = 'd.' . $element;
return $element;
}, $fieldNames);
$catIds = isset($filter['csv_cat_filter']) ? $filter['csv_cat_filter'] : array();
$rootCat = JUDownloadFrontHelperCategory::getRootCategory();
if (count($catIds) == 1 && $catIds[0] == $rootCat->id) {
$catIds = array();
}
if (isset($filter['csv_sub_cat']) && !empty($catIds)) {
$tmp = array();
foreach ($catIds as $catId) {
$categoryTree = JUDownloadHelper::getCategoryTree($catId);
foreach ($categoryTree as $category) {
$tmp[] = $category->id;
}
}
$catIds = array_unique(array_merge($catIds, $tmp));
}
$tags = $filter['csv_tag_filter'];
$tags = array_filter($tags);
$licenses = array_filter($filter['licenses']);
$query = $db->getQuery(true);
$query->select(implode(',', $fieldNames))->from("#__judownload_documents AS d")->join("", "#__judownload_documents_xref AS dx ON dx.doc_id = d.id")->join("", "#__judownload_categories AS c ON dx.cat_id = c.id");
if (!empty($catIds)) {
$query->where("dx.cat_id IN (" . implode(',', $catIds) . ")");
}
if (!empty($tags)) {
$query->join("LEFT", "#__judownload_tags_xref AS tx ON tx.doc_id = d.id");
$query->where("tx.tag_id IN (" . implode(",", $tags) . ")");
}
if (!empty($filter['csv_publishing_filter'])) {
$filterConditions = array();
$nullDate = $db->getNullDate();
$now = JFactory::getDate()->toSql();
foreach ($filter['csv_publishing_filter'] as $value) {
$condition = array();
switch (trim($value)) {
case 'published':
$condition[] = 'd.published = 1';
$condition[] = '(d.publish_up = ' . $db->quote($nullDate) . ' OR d.publish_up <= ' . $db->quote($now) . ')';
$condition[] = '(d.publish_down = ' . $db->quote($nullDate) . ' OR d.publish_down >= ' . $db->quote($now) . ')';
$condition[] = 'd.approved = 1';
break;
case 'unpublished':
$condition[] = 'd.published = 0';
$condition[] = 'd.approved = 1';
break;
case 'pending':
$condition[] = 'd.publish_up < ' . $db->quote($now);
$condition[] = 'd.published = 1';
$condition[] = 'd.approved = 1';
break;
case 'expired':
$condition[] = 'd.publish_down < ' . $db->quote($now);
$condition[] = 'd.published = 1';
$condition[] = 'd.approved = 1';
break;
case 'pending_approval':
$condition[] = 'd.approved = 0 ';
break;
case 'approved':
$condition[] = 'd.approved = 1';
break;
}
if (!empty($condition)) {
$filterConditions[] = '( ' . implode(' AND ', $condition) . ' )';
}
}
if (!empty($filterConditions)) {
$query->where('(' . implode(' OR ', $filterConditions) . ')');
}
}
$offset = JFactory::getUser()->getParam('timezone', JFactory::getConfig()->get('offset'));
if (!empty($filter['csv_created_from_filter'])) {
$time = JFactory::getDate($filter['csv_created_from_filter'], $offset)->toSql();
$query->where('d.created >= ' . $db->quote($time));
}
if (!empty($filter['csv_created_to_filter'])) {
$time = JFactory::getDate($filter['csv_created_to_filter'], $offset)->toSql();
$query->where('d.created <= ' . $db->quote($time));
}
if (!empty($licenses)) {
$query->where('d.license_id IN (' . implode(',', $licenses) . ')');
}
$query->group('d.id');
return $query;
}
public static function getFieldGroupsByCatIds($catIds, $search_sub_categories = false)
{
if (!$catIds) {
return null;
}
$field_groups = array();
foreach ($catIds as $catId) {
if ($search_sub_categories) {
$categoryTree = JUDownloadHelper::getCategoryTree($catId, true, true);
foreach ($categoryTree as $sub_category) {
if ($sub_category->fieldgroup_id > 0) {
$field_groups[] = $sub_category->fieldgroup_id;
}
}
} else {
$catObj = JUDownloadHelper::getCategoryById($catId);
$field_groups[] = $catObj->fieldgroup_id ? $catObj->fieldgroup_id : 1;
}
}
$field_groups = array_unique($field_groups);
if ($field_groups) {
return implode(",", $field_groups);
} else {
return null;
}
}
protected function getInput()
{
$db = JFactory::getDbo();
$app = JFactory::getApplication();
$style_id = $app->input->getInt('id', 0);
$db->setQuery("SELECT id FROM #__judownload_categories WHERE style_id = " . $style_id);
$catIds = $db->loadColumn();
$rootCategory = JUDownloadFrontHelperCategory::getRootCategory();
$categoryTree = JUDownloadHelper::getCategoryTree($rootCategory->id);
$html = "<div id=\"categoriestoassignstyle\" class=\"categoriestoassignstyle\">";
$select_cat_class = 'select-cat';
$html .= '<div class="btn-group pull-left">';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', !jQuery(this).is(\':checked\')); });">' . JText::_('JGLOBAL_SELECTION_INVERT') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', false); });">' . JText::_('JGLOBAL_SELECTION_NONE') . '</button>';
$html .= '<button type="button" class="btn btn-mini" onclick="jQuery(\'.' . $select_cat_class . '\').each(function(el) { jQuery(this).prop(\'checked\', true); });">' . JText::_('JGLOBAL_SELECTION_ALL') . '</button>';
$html .= '</div>';
$html .= "<ul class=\"nav\" id=\"" . $this->id . "\">";
foreach ($categoryTree as $category) {
$html .= "<li>";
$cat_style_id = "";
if ($category->id == 1) {
$cat_style_id = $category->style_id;
$inherit = "";
} elseif ($category->style_id == $style_id) {
$html .= "<input class =\"" . $select_cat_class . "\" id=\"catid-" . $category->id . "\" type='checkbox' name='" . $this->name . "[]' value = '" . $category->id . "' checked>";
$cat_style_id = $style_id;
$inherit = "";
} elseif ($category->style_id == -1) {
$html .= "<input class =\"" . $select_cat_class . "\" id=\"catid-" . $category->id . "\" type='checkbox' name='" . $this->name . "[]' value = '" . $category->id . "'";
$db->setQuery("SELECT id FROM #__judownload_categories WHERE lft <" . $category->lft . " AND rgt > " . $category->rgt);
$parentCatIds = $db->loadColumn();
$parentCatIds = array_reverse($parentCatIds);
if (is_array($catIds) && !empty($catIds)) {
foreach ($parentCatIds as $parentCatId) {
if (in_array($parentCatId, $catIds)) {
$html .= " checked";
}
}
}
$html .= ">";
foreach ($parentCatIds as $parentCatId) {
$styleId = $this->getStyleIdByCategoryId($parentCatId);
if ($styleId > -1 || $styleId == -2) {
$cat_style_id = $styleId;
break;
}
}
$inherit = "<span class=\"inherited-value\" title=\"" . JText::_("COM_JUDOWNLOAD_INHERIT") . "\">" . JText::_("COM_JUDOWNLOAD_INHERIT") . "</span>";
} elseif ($category->style_id == -2) {
$html .= "<input type='checkbox' name='" . $this->name . "[]' value = '" . $category->id . "'>";
$inherit = "";
$db->setQuery("SELECT id FROM #__judownload_template_styles WHERE home = 1");
$cat_style_id = $db->loadResult();
} else {
$html .= "<input class =\"" . $select_cat_class . "\" id=\"catid-" . $category->id . "\" type='checkbox' name='" . $this->name . "[]' value = '" . $category->id . "' />";
$inherit = "";
$cat_style_id = $category->style_id;
}
if ($cat_style_id == -2) {
$style_title = $this->getStyleTitle(0, true);
} else {
$style_title = $this->getStyleTitle($cat_style_id);
}
$style_title = $style_title ? " [" . $style_title . "] " : "";
$html .= "<label for=\"catid-" . $category->id . "\">" . str_repeat('<span class="gi">|—</span>', $category->level);
if ($category->id == 1) {
$html .= $category->title;
} else {
$html .= "<a href=\"" . JRoute::_('index.php?option=com_judownload&task=category.edit&id=' . $category->id) . "\">" . $category->title . "</a>";
}
$html .= " <span class=\"style-title\">" . $style_title . "</span>" . $inherit . "</label>";
$html .= "</li>";
}
$html .= "</ul>";
$html .= "</div>";
return $html;
}
