$result[0]['end_time'] = formatTimestamp($finish, 'Y-m-d');
$result[0]['timestamp'] = $begin;
$result[0]['next_timestamp'] = $finish;
$result[0]['subscribe'] = 0;
$result[0]['unsubscribe'] = 0;
$result[0]['count'] = 0;
if (!empty($logs)) {
foreach ($logs as $k => $v) {
if ($v['subscribe_action'] == 1) {
$result[0]['subscribe'] = $result[0]['subscribe'] + 1;
} else {
$result[0]['unsubscribe'] = $result[0]['unsubscribe'] + 1;
}
$result[0]['count'] = $result[0]['count'] + 1;
unset($logs[$k]);
}
}
break;
}
$xoopsTpl->assign('result', $result);
$sort_list = array('asc' => '遞增排序', 'desc' => '遞減排序');
$xoopsTpl->assign('sort_list', $sort_list);
$xoopsTpl->assign('sort', $sort);
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$beginout = new XoopsFormDateTime("從", 'begin', 15, @$begin);
$finishout = new XoopsFormDateTime("到", 'finish', 15, @$finish);
$search['begin'] = $beginout->render();
$search['finish'] = $finishout->render();
$xoopsTpl->assign('search', $search);
$xoopsTpl->display("db:newsletter_admin_count.html");
include 'footer.php';
function edititem($showmenu = false, $itemid = 0)
{
global $smartsection_file_handler, $smartsection_item_handler, $smartsection_category_handler, $xoopsUser, $xoopsModule, $xoopsConfig, $xoopsDB;
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
// If there is a parameter, and the id exists, retrieve data: we're editing a item
if ($itemid != 0) {
// Creating the ITEM object
$itemObj = new ssItem($itemid);
if ($itemObj->notLoaded()) {
redirect_header("item.php", 1, _AM_SS_NOITEMSELECTED);
exit;
}
switch ($itemObj->status()) {
case _SS_STATUS_SUBMITTED:
$breadcrumb_action1 = _AM_SS_SUBMITTED;
$breadcrumb_action2 = _AM_SS_APPROVING;
$page_title = _AM_SS_SUBMITTED_TITLE;
$page_info = _AM_SS_SUBMITTED_INFO;
$button_caption = _AM_SS_APPROVE;
$new_status = _SS_STATUS_PUBLISHED;
break;
case _SS_STATUS_PUBLISHED:
$breadcrumb_action1 = _AM_SS_PUBLISHED;
$breadcrumb_action2 = _AM_SS_EDITING;
$page_title = _AM_SS_PUBLISHEDEDITING;
$page_info = _AM_SS_PUBLISHEDEDITING_INFO;
$button_caption = _AM_SS_MODIFY;
$new_status = _SS_STATUS_PUBLISHED;
break;
case _SS_STATUS_OFFLINE:
$breadcrumb_action1 = _AM_SS_OFFLINE;
$breadcrumb_action2 = _AM_SS_EDITING;
$page_title = _AM_SS_OFFLINEEDITING;
$page_info = _AM_SS_OFFLINEEDITING_INFO;
$button_caption = _AM_SS_MODIFY;
$new_status = _SS_STATUS_OFFLINE;
break;
case "default":
default:
break;
}
$categoryObj =& $itemObj->category();
if ($showmenu) {
ss_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
}
echo "<br />\n";
ss_collapsableBar('edititemtable', 'edititemicon', $page_title, $page_info);
} else {
// there's no parameter, so we're adding an item
$itemObj =& $smartsection_item_handler->create();
$categoryObj =& $smartsection_category_handler->create();
$breadcrumb_action1 = _AM_SS_ITEMS;
$breadcrumb_action2 = _AM_SS_CREATINGNEW;
$button_caption = _AM_SS_CREATE;
$new_status = _SS_STATUS_PUBLISHED;
if ($showmenu) {
ss_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
}
$sel_categoryid = isset($_GET['categoryid']) ? $_GET['categoryid'] : 0;
$categoryObj->setVar('categoryid', $sel_categoryid);
ss_collapsableBar('createitemtable', 'createitemicon', _AM_SS_ITEM_CREATING, _AM_SS_ITEM_CREATING_DSC);
}
// ITEM FORM
$sform = new XoopsThemeForm(_AM_SS_ITEMS, "op", xoops_getenv('PHP_SELF'));
$sform->setExtra('enctype="multipart/form-data"');
// CATEGORY
$mytree = new XoopsTree($xoopsDB->prefix("smartsection_categories"), "categoryid", "parentid");
ob_start();
$sform->addElement(new XoopsFormHidden('categoryid', $categoryObj->categoryid()));
$mytree->makeMySelBox("name", "weight", $categoryObj->categoryid());
$category_label = new XoopsFormLabel(_AM_SS_CATEGORY, ob_get_contents());
$category_label->setDescription(_AM_SS_CATEGORY_DSC);
$sform->addElement($category_label);
ob_end_clean();
// TITLE
$title_text = new XoopsFormText(_AM_SS_TITLE, 'title', 50, 255, $itemObj->title(0, 'e'));
$sform->addElement($title_text, true);
// SUMMARY
$summary_text = ss_getEditor(_AM_SS_SUMMARY, 'summary', $itemObj->summary(0, 'e'));
$summary_text->setDescription(_AM_SS_SUMMARY_DSC);
$sform->addElement($summary_text, false);
// DISPLAY_SUMMARY
$display_summary_radio = new XoopsFormRadioYN(_AM_SS_DISPLAY_SUMMARY, 'display_summary', $itemObj->display_summary(), ' ' . _AM_SS_YES . '', ' ' . _AM_SS_NO . '');
$sform->addElement($display_summary_radio);
// BODY
$body_text = ss_getEditor(_AM_SS_BODY, 'body', $itemObj->body(0, 'e'));
//$body_text = new XoopsFormDhtmlTextArea(_AM_SS_BODY, 'body', $itemObj->body(0, 'e'), 20, 60);
$body_text->setDescription(_AM_SS_BODY_DSC);
$sform->addElement($body_text, true);
// IMAGE
$image_array =& XoopsLists::getImgListAsArray(ss_getImageDir('item'));
$image_select = new XoopsFormSelect('', 'image', $itemObj->image());
//$image_select -> addOption ('-1', '---------------');
$image_select->addOptionArray($image_array);
$image_select->setExtra("onchange='showImgSelected(\"image3\", \"image\", \"" . 'uploads/smartsection/images/item/' . "\", \"\", \"" . XOOPS_URL . "\")'");
$image_tray = new XoopsFormElementTray(_AM_SS_IMAGE_ITEM, ' ');
$image_tray->addElement($image_select);
$image_tray->addElement(new XoopsFormLabel('', "<br /><br /><img src='" . ss_getImageDir('item', false) . $itemObj->image() . "' name='image3' id='image3' alt='' />"));
$image_tray->setDescription(_AM_SS_IMAGE_ITEM_DSC);
$sform->addElement($image_tray);
// IMAGE UPLOAD
$max_size = 5000000;
$file_box = new XoopsFormFile(_AM_SS_IMAGE_UPLOAD, "image_file", $max_size);
$file_box->setExtra("size ='45'");
$file_box->setDescription(_AM_SS_IMAGE_UPLOAD_ITEM_DSC);
$sform->addElement($file_box);
// Uid
/* We need to retreive the users manually because for some reason, on the frxoops.org server,
the method users::getobjects encounters a memory error
*/
$uid = $itemObj->uid() == 0 ? $xoopsUser->uid() : $itemObj->uid();
$uid_select = new XoopsFormSelect(_AM_SS_UID, 'uid', $uid, 1, false);
$uid_select->setDescription(_AM_SS_UID_DSC);
$sql = "SELECT uid, uname FROM " . $xoopsDB->prefix('users') . " ORDER BY uname ASC";
$result = $xoopsDB->query($sql);
$users_array = array();
while ($myrow = $xoopsDB->fetchArray($result)) {
$users_array[$myrow['uid']] = $myrow['uname'];
}
$uid_select->addOptionArray($users_array);
$sform->addElement($uid_select);
// Datesub
$datesub = $itemObj->getVar('datesub') == 0 ? time() : $itemObj->getVar('datesub');
$datesub_datetime = new XoopsFormDateTime(_AM_SS_DATESUB, 'datesub', $size = 15, $datesub);
$datesub_datetime->setDescription(_AM_SS_DATESUB_DSC);
$sform->addElement($datesub_datetime);
// STATUS
$options = array(_SS_STATUS_PUBLISHED => _AM_SS_PUBLISHED, _SS_STATUS_OFFLINE => _AM_SS_OFFLINE);
$status_select = new XoopsFormSelect(_AM_SS_STATUS, 'status', $new_status);
$status_select->addOptionArray($options);
$status_select->setDescription(_AM_SS_STATUS_DSC);
$sform->addElement($status_select);
// WEIGHT
$sform->addElement(new XoopsFormText(_AM_SS_WEIGHT, 'weight', 5, 5, $itemObj->weight()), true);
// COMMENTS
$addcomments_radio = new XoopsFormRadioYN(_AM_SS_ALLOWCOMMENTS, 'cancomment', $itemObj->cancomment(), ' ' . _AM_SS_YES . '', ' ' . _AM_SS_NO . '');
$sform->addElement($addcomments_radio);
// PER ITEM PERMISSIONS
$member_handler =& xoops_gethandler('member');
$group_list =& $member_handler->getGroupList();
$groups_checkbox = new XoopsFormCheckBox(_AM_SS_PERMISSIONS_ITEM, 'groups[]', $itemObj->getGroups_read());
$groups_checkbox->setDescription(_AM_SS_PERMISSIONS_ITEM_DSC);
foreach ($group_list as $group_id => $group_name) {
if ($group_id != XOOPS_GROUP_ADMIN) {
$groups_checkbox->addOption($group_id, $group_name);
}
}
$sform->addElement($groups_checkbox);
// VARIOUS OPTIONS
$options_tray = new XoopsFormElementTray(_AM_SS_OPTIONS, '<br />');
$html_checkbox = new XoopsFormCheckBox('', 'dohtml', $itemObj->dohtml());
$html_checkbox->addOption(1, _AM_SS_DOHTML);
$options_tray->addElement($html_checkbox);
$smiley_checkbox = new XoopsFormCheckBox('', 'dosmiley', $itemObj->dosmiley());
$smiley_checkbox->addOption(1, _AM_SS_DOSMILEY);
$options_tray->addElement($smiley_checkbox);
$xcodes_checkbox = new XoopsFormCheckBox('', 'doxcode', $itemObj->doxcode());
$xcodes_checkbox->addOption(1, _AM_SS_DOXCODE);
$options_tray->addElement($xcodes_checkbox);
$images_checkbox = new XoopsFormCheckBox('', 'doimage', $itemObj->doimage());
$images_checkbox->addOption(1, _AM_SS_DOIMAGE);
$options_tray->addElement($images_checkbox);
$linebreak_checkbox = new XoopsFormCheckBox('', 'dobr', $itemObj->dobr());
$linebreak_checkbox->addOption(1, _AM_SS_DOLINEBREAK);
$options_tray->addElement($linebreak_checkbox);
$sform->addElement($options_tray);
// item ID
$sform->addElement(new XoopsFormHidden('itemid', $itemObj->itemid()));
$button_tray = new XoopsFormElementTray('', '');
$hidden = new XoopsFormHidden('op', 'additem');
$button_tray->addElement($hidden);
if (!$itemid) {
// there's no itemid? Then it's a new item
// $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SS_CREATE, 'submit' ) );
$butt_create = new XoopsFormButton('', '', _AM_SS_CREATE, 'submit');
$butt_create->setExtra('onclick="this.form.elements.op.value=\'additem\'"');
$button_tray->addElement($butt_create);
$butt_clear = new XoopsFormButton('', '', _AM_SS_CLEAR, 'reset');
$button_tray->addElement($butt_clear);
$butt_cancel = new XoopsFormButton('', '', _AM_SS_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement($butt_cancel);
$sform->addElement($button_tray);
$sform->display();
ss_close_collapsable('createitemtable', 'createitemicon');
} else {
// else, we're editing an existing item
// $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SS_MODIFY, 'submit' ) );
$butt_create = new XoopsFormButton('', '', $button_caption, 'submit');
$butt_create->setExtra('onclick="this.form.elements.op.value=\'additem\'"');
$button_tray->addElement($butt_create);
$butt_cancel = new XoopsFormButton('', '', _AM_SS_CANCEL, 'button');
$butt_cancel->setExtra('onclick="history.go(-1)"');
$button_tray->addElement($butt_cancel);
$sform->addElement($button_tray);
$sform->display();
ss_close_collapsable('edititemtable', 'edititemicon');
}
unset($hidden);
if ($itemid != 0) {
showfiles($itemObj);
}
}