/**
* @param array $categoriesObj
* @param array $status
*
* @return array
*/
public function getLastPublishedByCat($categoriesObj, $status = array(_PUBLISHER_STATUS_PUBLISHED))
{
$ret = array();
$catIds = array();
foreach ($categoriesObj as $parentid) {
foreach ($parentid as $category) {
$catId = $category->getVar('categoryid');
$catIds[$catId] = $catId;
}
}
if (empty($catIds)) {
return $ret;
}
/*$cat = array();
$sql = "SELECT categoryid, MAX(datesub) as date FROM " . $this->db->prefix('publisher_items') . " WHERE status IN (" . implode(',', $status) . ") GROUP BY categoryid";
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$cat[$row['categoryid']] = $row['date'];
}
if (count($cat) == 0) return $ret;
$sql = "SELECT categoryid, itemid, title, short_url, uid, datesub FROM " . $this->db->prefix('publisher_items');
$criteriaBig = new CriteriaCompo();
foreach ($cat as $id => $date) {
$criteria = new CriteriaCompo(new Criteria('categoryid', $id));
$criteria->add(new Criteria('datesub', $date));
$criteriaBig->add($criteria, 'OR');
unset($criteria);
}
$sql .= " " . $criteriaBig->renderWhere();
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$item = new PublisherItem();
$item->assignVars($row);
$ret[$row['categoryid']] = $item;
unset($item);
}
*/
$sql = "SELECT mi.categoryid, mi.itemid, mi.title, mi.short_url, mi.uid, mi.datesub";
$sql .= " FROM (SELECT categoryid, MAX(datesub) AS date FROM " . $this->db->prefix('publisher_items');
$sql .= " WHERE status IN (" . implode(',', $status) . ")";
$sql .= " AND categoryid IN (" . implode(',', $catIds) . ")";
$sql .= " GROUP BY categoryid)mo";
$sql .= " JOIN " . $this->db->prefix('publisher_items') . " mi ON mi.datesub = mo.date";
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$item = new PublisherItem();
$item->assignVars($row);
$ret[$row['categoryid']] = $item;
unset($item);
}
return $ret;
}
/**
* @param PublisherItem $obj
*/
public function __construct(PublisherItem $obj)
{
$xoops = Xoops::getInstance();
$publisher = Publisher::getInstance();
$allowed_editors = PublisherUtils::getEditors($publisher->getPermissionHandler()->getGrantedItems('editors'));
$group = $xoops->getUserGroups();
parent::__construct('title', 'form', $xoops->getEnv('PHP_SELF'));
$this->setExtra('enctype="multipart/form-data"');
$tabtray = new Xoops\Form\TabTray('', 'uniqueid', $xoops->getModuleConfig('jquery_theme', 'system'));
$mainTab = new Xoops\Form\Tab(_CO_PUBLISHER_TAB_MAIN, 'maintab');
// Category
$category_select = new Xoops\Form\Select(_CO_PUBLISHER_CATEGORY, 'categoryid', $obj->getVar('categoryid', 'e'));
$category_select->setDescription(_CO_PUBLISHER_CATEGORY_DSC);
$category_select->addOptionArray($publisher->getCategoryHandler()->getCategoriesForSubmit());
$mainTab->addElement($category_select);
// ITEM TITLE
$mainTab->addElement(new Xoops\Form\Text(_CO_PUBLISHER_TITLE, 'title', 50, 255, $obj->getVar('title', 'e')), true);
// SUBTITLE
if ($this->_isGranted(_PUBLISHER_SUBTITLE)) {
$mainTab->addElement(new Xoops\Form\Text(_CO_PUBLISHER_SUBTITLE, 'subtitle', 50, 255, $obj->getVar('subtitle', 'e')));
}
// SHORT URL
if ($this->_isGranted(_PUBLISHER_ITEM_SHORT_URL)) {
$text_short_url = new Xoops\Form\Text(_CO_PUBLISHER_ITEM_SHORT_URL, 'item_short_url', 50, 255, $obj->getVar('short_url', 'e'));
$text_short_url->setDescription(_CO_PUBLISHER_ITEM_SHORT_URL_DSC);
$mainTab->addElement($text_short_url);
}
// TAGS
if ($xoops->isActiveModule('tag') && $this->_isGranted(_PUBLISHER_ITEM_TAG)) {
include_once \XoopsBaseConfig::get('root-path') . '/modules/tag/include/formtag.php';
$text_tags = new Xoops\Form\Tag('item_tag', 60, 255, $obj->getVar('item_tag', 'e'), 0);
$mainTab->addElement($text_tags);
}
// SELECT EDITOR
$nohtml = false;
if (count($allowed_editors) == 1) {
$editor = $allowed_editors[0];
} else {
if (count($allowed_editors) > 0) {
$editor = @$_POST['editor'];
if (!empty($editor)) {
PublisherUtils::setCookieVar('publisher_editor', $editor);
} else {
$editor = PublisherUtils::getCookieVar('publisher_editor');
if (empty($editor) && $xoops->isUser()) {
$editor = $xoops->user->getVar('publisher_editor');
// Need set through user profile
}
}
$editor = empty($editor) || !in_array($editor, $allowed_editors) ? $publisher->getConfig('submit_editor') : $editor;
$form_editor = new Xoops\Form\SelectEditor($this, 'editor', $editor, $nohtml, $allowed_editors);
$mainTab->addElement($form_editor);
} else {
$editor = $publisher->getConfig('submit_editor');
}
}
$editor_configs = array();
$editor_configs["rows"] = !$publisher->getConfig('submit_editor_rows') ? 35 : $publisher->getConfig('submit_editor_rows');
$editor_configs["cols"] = !$publisher->getConfig('submit_editor_cols') ? 60 : $publisher->getConfig('submit_editor_cols');
$editor_configs["width"] = !$publisher->getConfig('submit_editor_width') ? "100%" : $publisher->getConfig('submit_editor_width');
$editor_configs["height"] = !$publisher->getConfig('submit_editor_height') ? "400px" : $publisher->getConfig('submit_editor_height');
// SUMMARY
if ($this->_isGranted(_PUBLISHER_SUMMARY)) {
// Description
//$summary_text = new Xoops\Form\TextArea(_CO_PUBLISHER_SUMMARY, 'summary', $obj->getVar('summary', 'e'), 7, 60);
$editor_configs["name"] = "summary";
$editor_configs["value"] = $obj->getVar('summary', 'e');
$summary_text = new Xoops\Form\Editor(_CO_PUBLISHER_SUMMARY, $editor, $editor_configs, $nohtml, $onfailure = null);
$summary_text->setDescription(_CO_PUBLISHER_SUMMARY_DSC);
$mainTab->addElement($summary_text);
}
// BODY
$editor_configs["name"] = "body";
$editor_configs["value"] = $obj->getVar('body', 'e');
$body_text = new Xoops\Form\Editor(_CO_PUBLISHER_BODY, $editor, $editor_configs, $nohtml, $onfailure = null);
$body_text->setDescription(_CO_PUBLISHER_BODY_DSC);
$mainTab->addElement($body_text);
// VARIOUS OPTIONS
if ($this->_isGranted(_PUBLISHER_DOHTML) || $this->_isGranted(_PUBLISHER_DOSMILEY) || $this->_isGranted(_PUBLISHER_DOXCODE) || $this->_isGranted(_PUBLISHER_DOIMAGE) || $this->_isGranted(_PUBLISHER_DOLINEBREAK)) {
if ($this->_isGranted(_PUBLISHER_DOHTML)) {
$html_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_DOHTML, 'dohtml', $obj->getVar('dohtml'));
$mainTab->addElement($html_radio);
}
if ($this->_isGranted(_PUBLISHER_DOSMILEY)) {
$smiley_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_DOSMILEY, 'dosmiley', $obj->getVar('dosmiley'));
$mainTab->addElement($smiley_radio);
}
if ($this->_isGranted(_PUBLISHER_DOXCODE)) {
$xcode_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_DOXCODE, 'doxcode', $obj->getVar('doxcode'));
$mainTab->addElement($xcode_radio);
}
if ($this->_isGranted(_PUBLISHER_DOIMAGE)) {
$image_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_DOIMAGE, 'doimage', $obj->getVar('doimage'));
$mainTab->addElement($image_radio);
}
if ($this->_isGranted(_PUBLISHER_DOLINEBREAK)) {
$linebreak_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_DOLINEBREAK, 'dolinebreak', $obj->getVar('dobr'));
$mainTab->addElement($linebreak_radio);
}
}
// Available pages to wrap
if ($this->_isGranted(_PUBLISHER_AVAILABLE_PAGE_WRAP)) {
$wrap_pages = XoopsLists::getHtmlListAsArray(PublisherUtils::getUploadDir(true, 'content'));
$available_wrap_pages_text = array();
foreach ($wrap_pages as $page) {
$available_wrap_pages_text[] = "<span onclick='publisherPageWrap(\"body\", \"[pagewrap={$page}] \");' onmouseover='style.cursor=\"pointer\"'>{$page}</span>";
}
$available_wrap_pages = new Xoops\Form\Label(_CO_PUBLISHER_AVAILABLE_PAGE_WRAP, implode(', ', $available_wrap_pages_text));
$available_wrap_pages->setDescription(_CO_PUBLISHER_AVAILABLE_PAGE_WRAP_DSC);
$mainTab->addElement($available_wrap_pages);
}
// Uid
/* We need to retrieve the users manually because for some reason, on the frxoops.org server,
the method users::getobjects encounters a memory error
*/
// Trabis : well, maybe is because you are getting 6000 objects into memory , no??? LOL
if ($this->_isGranted(_PUBLISHER_UID)) {
$uid_select = new Xoops\Form\SelectUser(_CO_PUBLISHER_UID, 'uid', true, array($obj->getVar('uid', 'e')), 1, false);
$uid_select->setDescription(_CO_PUBLISHER_UID_DSC);
//$sql = "SELECT uid, uname FROM " . $obj->db->prefix('users') . " ORDER BY uname ASC";
//$result = $obj->db->query($sql);
//$users_array = array();
//$users_array[0] = $xoops->getConfig('anonymous');
//while ($myrow = $obj->db->fetchArray($result)) {
// $users_array[$myrow['uid']] = $myrow['uname'];
//}
//$uid_select->addOptionArray($users_array);
$mainTab->addElement($uid_select);
}
/* else {
$hidden = new Xoops\Form\Hidden('uid', $obj->getVar('uid'));
$this->addElement($hidden);
unset($hidden);
}*/
// Author Alias
if ($this->_isGranted(_PUBLISHER_AUTHOR_ALIAS)) {
$element = new Xoops\Form\Text(_CO_PUBLISHER_AUTHOR_ALIAS, 'author_alias', 50, 255, $obj->getVar('author_alias', 'e'));
$element->setDescription(_CO_PUBLISHER_AUTHOR_ALIAS_DSC);
$mainTab->addElement($element);
unset($element);
}
// STATUS
if ($this->_isGranted(_PUBLISHER_STATUS)) {
$options = array(_PUBLISHER_STATUS_PUBLISHED => _CO_PUBLISHER_PUBLISHED, _PUBLISHER_STATUS_OFFLINE => _CO_PUBLISHER_OFFLINE, _PUBLISHER_STATUS_SUBMITTED => _CO_PUBLISHER_SUBMITTED, _PUBLISHER_STATUS_REJECTED => _CO_PUBLISHER_REJECTED);
$status_select = new Xoops\Form\Select(_CO_PUBLISHER_STATUS, 'status', $obj->getVar('status'));
$status_select->addOptionArray($options);
$status_select->setDescription(_CO_PUBLISHER_STATUS_DSC);
$mainTab->addElement($status_select);
unset($status_select);
}
// Datesub
if ($this->_isGranted(_PUBLISHER_DATESUB)) {
$datesub = $obj->getVar('datesub') == 0 ? time() : $obj->getVar('datesub');
$datesub_datetime = new PublisherFormDateTime(_CO_PUBLISHER_DATESUB, 'datesub', $size = 15, $datesub);
$datesub_datetime->setDescription(_CO_PUBLISHER_DATESUB_DSC);
$mainTab->addElement($datesub_datetime);
}
// NOTIFY ON PUBLISH
if ($this->_isGranted(_PUBLISHER_NOTIFY)) {
$notify_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_NOTIFY, 'notify', $obj->getVar('notifypub'));
$mainTab->addElement($notify_radio);
}
$tabtray->addElement($mainTab);
if ($xoops->isActiveModule('images') && $this->_hasTab(_CO_PUBLISHER_TAB_IMAGES)) {
$imagesTab = new Xoops\Form\Tab(_CO_PUBLISHER_TAB_IMAGES, 'imagestab');
// IMAGE
if ($this->_isGranted(_PUBLISHER_IMAGE_ITEM)) {
$imgcat_handler = Images::getInstance()->getHandlerCategories();
$image_handler = Images::getInstance()->getHandlerImages();
$objimages = $obj->getImages();
$mainarray = is_object($objimages['main']) ? array($objimages['main']) : array();
$mergedimages = array_merge($mainarray, $objimages['others']);
$objimage_array = array();
/* @var $imageObj ImagesImage */
foreach ($mergedimages as $imageObj) {
$objimage_array[$imageObj->getVar('image_name')] = $imageObj->getVar('image_nicename');
}
$catlist = $imgcat_handler->getListByPermission($group, 'imgcat_read', 1);
$catids = array_keys($catlist);
$imageObjs = array();
if (!empty($catids)) {
$criteria = new CriteriaCompo(new Criteria('imgcat_id', '(' . implode(',', $catids) . ')', 'IN'));
$criteria->add(new Criteria('image_display', 1));
$criteria->setSort('image_nicename');
$criteria->setOrder('ASC');
$imageObjs = $image_handler->getObjects($criteria, true);
unset($criteria);
}
$image_array = array();
foreach ($imageObjs as $imageObj) {
$image_array[$imageObj->getVar('image_name')] = $imageObj->getVar('image_nicename');
}
$image_array = array_diff($image_array, $objimage_array);
$image_select = new Xoops\Form\Select('', 'image_notused', '', 5);
$image_select->addOptionArray($image_array);
$image_select->setExtra("onchange='showImgSelected(\"image_display\", \"image_notused\", \"uploads/\", \"\", \"" . \XoopsBaseConfig::get('url') . "\")'");
//$image_select->setExtra( "onchange='appendMySelectOption(\"image_notused\", \"image_item\")'");
unset($image_array);
$image_select2 = new Xoops\Form\Select('', 'image_item', '', 5, true);
$image_select2->addOptionArray($objimage_array);
$image_select2->setExtra("onchange='publisher_updateSelectOption(\"image_item\", \"image_featured\"), showImgSelected(\"image_display\", \"image_item\", \"uploads/\", \"\", \"" . \XoopsBaseConfig::get('url') . "\")'");
$buttonadd = new Xoops\Form\Button('', 'buttonadd', _CO_PUBLISHER_ADD);
$buttonadd->setExtra("onclick='publisher_appendSelectOption(\"image_notused\", \"image_item\"), publisher_updateSelectOption(\"image_item\", \"image_featured\")'");
$buttonremove = new Xoops\Form\Button('', 'buttonremove', _CO_PUBLISHER_REMOVE);
$buttonremove->setExtra("onclick='publisher_appendSelectOption(\"image_item\", \"image_notused\"), publisher_updateSelectOption(\"image_item\", \"image_featured\")'");
$opentable = new Xoops\Form\Label('', "<table><tr><td>");
$addcol = new Xoops\Form\Label('', "</td><td>");
$addbreak = new Xoops\Form\Label('', "<br />");
$closetable = new Xoops\Form\Label('', "</td></tr></table>");
$xoops->theme()->addScript(PUBLISHER_URL . '/js/ajaxupload.3.9.js');
//todo, find replacement for error class
$js_data = new Xoops\Form\Label('', '
<script type= "text/javascript">/*<![CDATA[*/
$(document).ready(function(){
var button = $("#publisher_upload_button"), interval;
new AjaxUpload(button,{
action: "' . PUBLISHER_URL . '/include/ajax_upload.php", // I disabled uploads in this example for security reasons
responseType: "text/html",
name: "publisher_upload_file",
onSubmit : function(file, ext){
// change button text, when user selects file
$("#publisher_upload_message").html(" ");
button.html("<img src=\'' . PUBLISHER_URL . '/images/loadingbar.gif\'/>"); this.setData({
"image_nicename": $("#image_nicename").val(),
"imgcat_id" : $("#imgcat_id").val()
});
// If you want to allow uploading only 1 file at time,
// you can disable upload button
this.disable();
interval = window.setInterval(function(){
}, 200);
},
onComplete: function(file, response){
button.text("' . _CO_PUBLISHER_IMAGE_UPLOAD_NEW . '");
window.clearInterval(interval);
// enable upload button
this.enable();
// add file to the list
var result = eval(response);
if (result[0] == "success") {
$("#image_item").append("<option value=\'" + result[1] + "\' selected=\'selected\'>" + result[2] + "</option>");
publisher_updateSelectOption(\'image_item\', \'image_featured\');
showImgSelected(\'image_display\', \'image_item\', \'uploads/\', \'\', \'' . \XoopsBaseConfig::get('url') . '\')
} else {
$("#publisher_upload_message").html("<div class=\'errorMsg\'>" + result[1] + "</div>");
}
}
});
});
/*]]>*/</script>
');
$messages = new Xoops\Form\Label('', "<div id='publisher_upload_message'></div>");
$button = new Xoops\Form\Label('', "<div id='publisher_upload_button'>" . _CO_PUBLISHER_IMAGE_UPLOAD_NEW . "</div>");
$nicename = new Xoops\Form\Text('', 'image_nicename', 30, 30, _CO_PUBLISHER_IMAGE_NICENAME);
$catlist = $imgcat_handler->getListByPermission($group, 'imgcat_read', 1);
$imagecat = new Xoops\Form\Select('', 'imgcat_id', '', 1);
$imagecat->addOptionArray($catlist);
$image_upload_tray = new Xoops\Form\ElementTray(_CO_PUBLISHER_IMAGE_UPLOAD, '');
$image_upload_tray->addElement($js_data);
$image_upload_tray->addElement($messages);
$image_upload_tray->addElement($opentable);
$image_upload_tray->addElement($imagecat);
$image_upload_tray->addElement($addbreak);
$image_upload_tray->addElement($nicename);
$image_upload_tray->addElement($addbreak);
$image_upload_tray->addElement($button);
$image_upload_tray->addElement($closetable);
$imagesTab->addElement($image_upload_tray);
$image_tray = new Xoops\Form\ElementTray(_CO_PUBLISHER_IMAGE_ITEMS, '');
$image_tray->addElement($opentable);
$image_tray->addElement($image_select);
$image_tray->addElement($addbreak);
$image_tray->addElement($buttonadd);
$image_tray->addElement($addcol);
$image_tray->addElement($image_select2);
$image_tray->addElement($addbreak);
$image_tray->addElement($buttonremove);
$image_tray->addElement($closetable);
$image_tray->setDescription(_CO_PUBLISHER_IMAGE_ITEMS_DSC);
$imagesTab->addElement($image_tray);
$imagename = is_object($objimages['main']) ? $objimages['main']->getVar('image_name') : '';
$imageforpath = $imagename != '' ? $imagename : 'blank.gif';
$image_select3 = new Xoops\Form\Select(_CO_PUBLISHER_IMAGE_ITEM, 'image_featured', $imagename, 1);
$image_select3->addOptionArray($objimage_array);
$image_select3->setExtra("onchange='showImgSelected(\"image_display\", \"image_featured\", \"uploads/\", \"\", \"" . \XoopsBaseConfig::get('url') . "\")'");
$image_select3->setDescription(_CO_PUBLISHER_IMAGE_ITEM_DSC);
$imagesTab->addElement($image_select3);
$image_preview = new Xoops\Form\Label(_CO_PUBLISHER_IMAGE_PREVIEW, "<img width='500' src='" . \XoopsBaseConfig::get('url') . "/uploads/" . $imageforpath . "' name='image_display' id='image_display' alt='' />");
$imagesTab->addElement($image_preview);
}
$tabtray->addElement($imagesTab);
}
if ($this->_hasTab(_CO_PUBLISHER_TAB_FILES)) {
$filesTab = new Xoops\Form\Tab(_CO_PUBLISHER_TAB_FILES, 'filestab');
// File upload UPLOAD
if ($this->_isGranted(_PUBLISHER_ITEM_UPLOAD_FILE)) {
// NAME
$name_text = new Xoops\Form\Text(_CO_PUBLISHER_FILENAME, 'item_file_name', 50, 255, '');
$name_text->setDescription(_CO_PUBLISHER_FILE_NAME_DSC);
$filesTab->addElement($name_text);
unset($name_text);
// DESCRIPTION
$description_text = new Xoops\Form\TextArea(_CO_PUBLISHER_FILE_DESCRIPTION, 'item_file_description', '');
$description_text->setDescription(_CO_PUBLISHER_FILE_DESCRIPTION_DSC);
$filesTab->addElement($description_text);
unset($description_text);
$status_select = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_FILE_STATUS, 'item_file_status', 1);
//1 - active
$status_select->setDescription(_CO_PUBLISHER_FILE_STATUS_DSC);
$filesTab->addElement($status_select);
unset($status_select);
$file_box = new Xoops\Form\File(_CO_PUBLISHER_ITEM_UPLOAD_FILE, "item_upload_file");
$file_box->setDescription(_CO_PUBLISHER_ITEM_UPLOAD_FILE_DSC);
$file_box->setExtra("size ='50'");
$filesTab->addElement($file_box);
unset($file_box);
if (!$obj->isNew()) {
$filesObj = $publisher->getFileHandler()->getAllFiles($obj->getVar('itemid'));
if (count($filesObj) > 0) {
$table = '';
$table .= "<table width='100%' cellspacing=1 cellpadding=3 border=0 class = outer>";
$table .= "<tr>";
$table .= "<td width='50' class='bg3' align='center'><strong>ID</strong></td>";
$table .= "<td width='150' class='bg3' align='left'><strong>" . _AM_PUBLISHER_FILENAME . "</strong></td>";
$table .= "<td class='bg3' align='left'><strong>" . _AM_PUBLISHER_DESCRIPTION . "</strong></td>";
$table .= "<td width='60' class='bg3' align='center'><strong>" . _AM_PUBLISHER_HITS . "</strong></td>";
$table .= "<td width='100' class='bg3' align='center'><strong>" . _AM_PUBLISHER_UPLOADED_DATE . "</strong></td>";
$table .= "<td width='60' class='bg3' align='center'><strong>" . _AM_PUBLISHER_ACTION . "</strong></td>";
$table .= "</tr>";
/* @var $fileObj PublisherFile */
foreach ($filesObj as $fileObj) {
$modify = "<a href='file.php?op=mod&fileid=" . $fileObj->getVar('fileid') . "'><img src='" . PUBLISHER_URL . "/images/links/edit.gif' title='" . _CO_PUBLISHER_EDITFILE . "' alt='" . _CO_PUBLISHER_EDITFILE . "' /></a>";
$delete = "<a href='file.php?op=del&fileid=" . $fileObj->getVar('fileid') . "'><img src='" . PUBLISHER_URL . "/images/links/delete.png' title='" . _CO_PUBLISHER_DELETEFILE . "' alt='" . _CO_PUBLISHER_DELETEFILE . "'/></a>";
if ($fileObj->getVar('status') == 0) {
$not_visible = "<img src='" . PUBLISHER_URL . "/images/no.gif'/>";
} else {
$not_visible = '';
}
$table .= "<tr>";
$table .= "<td class='head' align='center'>" . $fileObj->getVar('fileid') . "</td>";
$table .= "<td class='odd' align='left'>" . $not_visible . $fileObj->getFileLink() . "</td>";
$table .= "<td class='even' align='left'>" . $fileObj->getVar('description') . "</td>";
$table .= "<td class='even' align='center'>" . $fileObj->getVar('counter') . "";
$table .= "<td class='even' align='center'>" . $fileObj->datesub() . "</td>";
$table .= "<td class='even' align='center'> {$modify} {$delete} </td>";
$table .= "</tr>";
}
$table .= "</table>";
$files_box = new Xoops\Form\Label(_CO_PUBLISHER_FILES_LINKED, $table);
$filesTab->addElement($files_box);
unset($files_box, $filesObj, $fileObj);
}
}
}
$tabtray->addElement($filesTab);
}
if ($this->_hasTab(_CO_PUBLISHER_TAB_OTHERS)) {
$othersTab = new Xoops\Form\Tab(_CO_PUBLISHER_TAB_OTHERS, 'otherstab');
// Meta Keywords
if ($this->_isGranted(_PUBLISHER_ITEM_META_KEYWORDS)) {
$text_meta_keywords = new Xoops\Form\TextArea(_CO_PUBLISHER_ITEM_META_KEYWORDS, 'item_meta_keywords', $obj->getVar('meta_keywords', 'e'), 7, 60);
$text_meta_keywords->setDescription(_CO_PUBLISHER_ITEM_META_KEYWORDS_DSC);
$othersTab->addElement($text_meta_keywords);
}
// Meta Description
if ($this->_isGranted(_PUBLISHER_ITEM_META_DESCRIPTION)) {
$text_meta_description = new Xoops\Form\TextArea(_CO_PUBLISHER_ITEM_META_DESCRIPTION, 'item_meta_description', $obj->getVar('meta_description', 'e'), 7, 60);
$text_meta_description->setDescription(_CO_PUBLISHER_ITEM_META_DESCRIPTION_DSC);
$othersTab->addElement($text_meta_description);
}
// COMMENTS
if ($this->_isGranted(_PUBLISHER_ALLOWCOMMENTS)) {
$addcomments_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_ALLOWCOMMENTS, 'allowcomments', $obj->getVar('cancomment'));
$othersTab->addElement($addcomments_radio);
}
// WEIGHT
if ($this->_isGranted(_PUBLISHER_WEIGHT)) {
$othersTab->addElement(new Xoops\Form\Text(_CO_PUBLISHER_WEIGHT, 'weight', 5, 5, $obj->getVar('weight')));
}
$tabtray->addElement($othersTab);
}
$this->addElement($tabtray);
//COMMON TO ALL TABS
$button_tray = new Xoops\Form\ElementTray('', '');
if (!$obj->isNew()) {
$button_tray->addElement(new Xoops\Form\Button('', 'additem', XoopsLocale::A_SUBMIT, 'submit'));
//orclone
} else {
$button_tray->addElement(new Xoops\Form\Button('', 'additem', _CO_PUBLISHER_CREATE, 'submit'));
$button_tray->addElement(new Xoops\Form\Button('', '', _CO_PUBLISHER_CLEAR, 'reset'));
}
$button_tray->addElement(new Xoops\Form\Button('', 'preview', _CO_PUBLISHER_PREVIEW, 'submit'));
$butt_cancel = new Xoops\Form\Button('', '', _CO_PUBLISHER_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement($butt_cancel);
$this->addElement($button_tray);
$hidden = new Xoops\Form\Hidden('itemid', $obj->getVar('itemid'));
$this->addElement($hidden);
unset($hidden);
}
/**
* Build the others tab
*
* @param PublisherItem $obj data source
* @param ContainerInterface $othersTab add elements to this tab/form
*
* @return void
*/
private function buildOthersTab(PublisherItem $obj, ContainerInterface $othersTab)
{
// Meta Keywords
if ($this->isGranted(_PUBLISHER_ITEM_META_KEYWORDS)) {
$text_meta_keywords = new Xoops\Form\TextArea(_CO_PUBLISHER_ITEM_META_KEYWORDS, 'item_meta_keywords', $obj->getVar('meta_keywords', 'e'), 7, 60);
$text_meta_keywords->setDescription(_CO_PUBLISHER_ITEM_META_KEYWORDS_DSC);
$othersTab->addElement($text_meta_keywords);
}
// Meta Description
if ($this->isGranted(_PUBLISHER_ITEM_META_DESCRIPTION)) {
$text_meta_description = new Xoops\Form\TextArea(_CO_PUBLISHER_ITEM_META_DESCRIPTION, 'item_meta_description', $obj->getVar('meta_description', 'e'), 7, 60);
$text_meta_description->setDescription(_CO_PUBLISHER_ITEM_META_DESCRIPTION_DSC);
$othersTab->addElement($text_meta_description);
}
// COMMENTS
if ($this->isGranted(_PUBLISHER_ALLOWCOMMENTS)) {
$addcomments_radio = new Xoops\Form\RadioYesNo(_CO_PUBLISHER_ALLOWCOMMENTS, 'allowcomments', $obj->getVar('cancomment'));
$othersTab->addElement($addcomments_radio);
}
// WEIGHT
if ($this->isGranted(_PUBLISHER_WEIGHT)) {
$othersTab->addElement(new Xoops\Form\Text(_CO_PUBLISHER_WEIGHT, 'weight', 5, 5, $obj->getVar('weight')));
}
}
/**
* @param array $categoriesObj
* @param array $status
*
* @return array
*/
public function getLastPublishedByCat($categoriesObj, $status = array(_PUBLISHER_STATUS_PUBLISHED))
{
$ret = array();
$catIds = array();
/* @var $category PublisherCategory */
foreach ($categoriesObj as $parentid) {
foreach ($parentid as $category) {
$catId = $category->getVar('categoryid');
$catIds[$catId] = $catId;
}
}
if (empty($catIds)) {
return $ret;
}
// $sql = "SELECT mi.categoryid, mi.itemid, mi.title, mi.short_url, mi.uid, mi.datesub";
// $sql .= " FROM (SELECT categoryid, MAX(datesub) AS date FROM " . $this->db->prefix('publisher_items');
// $sql .= " WHERE status IN (" . implode(',', $status) . ")";
// $sql .= " AND categoryid IN (" . implode(',', $catIds) . ")";
// $sql .= " GROUP BY categoryid)mo";
// $sql .= " JOIN " . $this->db->prefix('publisher_items') . " mi ON mi.datesub = mo.date";
$qb = $this->db2->createXoopsQueryBuilder();
$qb->select('mi.categoryid', 'mi.itemid', 'mi.title', 'mi.short_url', 'mi.uid', 'mi.datesub');
$subqb = $this->db2->createXoopsQueryBuilder();
$subqb->select('categoryid', 'MAX(datesub) AS date')->fromPrefix('publisher_items', '')->where($subqb->expr()->in('status', $status))->andWhere($subqb->expr()->in('categoryid', $catIds))->groupBy('categoryid');
$subquery = '(' . $subqb->getSQL() . ')';
$qb->from($subquery, 'mo')->joinPrefix('mo', 'publisher_items', 'mi', 'mi.datesub = mo.date');
$result = $qb->execute();
while ($row = $result->fetch(\PDO::FETCH_ASSOC)) {
$item = new PublisherItem();
$item->assignVars($row);
$ret[$row['categoryid']] = $item;
unset($item);
}
return $ret;
}
/**
* @param array $status
*
* @return array
*/
public function getLastPublishedByCat($status = array(_PUBLISHER_STATUS_PUBLISHED))
{
$ret = array();
$cat = array();
$sql = "SELECT categoryid, MAX(datesub) as date FROM " . $this->db->prefix('publisher_items') . " WHERE status IN (" . implode(',', $status) . ") GROUP BY categoryid";
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$cat[$row['categoryid']] = $row['date'];
}
if (count($cat) == 0) {
return $ret;
}
$sql = "SELECT categoryid, itemid, title, short_url, uid, datesub FROM " . $this->db->prefix('publisher_items');
$criteriaBig = new CriteriaCompo();
foreach ($cat as $id => $date) {
$criteria = new CriteriaCompo(new Criteria('categoryid', $id));
$criteria->add(new Criteria('datesub', $date));
$criteriaBig->add($criteria, 'OR');
unset($criteria);
}
$sql .= " " . $criteriaBig->renderWhere();
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$item = new PublisherItem();
$item->assignVars($row);
$ret[$row['categoryid']] = $item;
unset($item);
}
return $ret;
}
