function about_block_page_edit($options) { @(include dirname(dirname(__FILE__)) . "/xoops_version.php"); $page_handler =& xoops_getmodulehandler('page', 'about'); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('page_status', 1), 'AND'); $criteria->add(new Criteria('page_type', 1)); $criteria->setSort('page_order'); $criteria->setOrder('ASC'); $fields = array("page_id", "page_title", "page_image"); $pages = $page_handler->getAll($criteria, $fields, false); $page_title = ''; foreach ($pages as $k => $v) { $page_title = '<a href="' . XOOPS_URL . '/modules/' . $modversion['dirname'] . '/index.php?page_id=' . $k . '" target="_blank">' . $v['page_title'] . '</a>'; $options_page[$k] = empty($v['page_image']) ? $page_title : $page_title . '<img src="' . XOOPS_URL . '/modules/' . $modversion['dirname'] . '/images/picture.png' . '" />'; } include_once dirname(dirname(__FILE__)) . '/include/xoopsformloader.php'; $form = new XoopsBlockForm(); $page_select = new XoopsFormRadio(_MI_ABOUT_BLOCKPAGE, 'options[0]', $options[0], '<br />'); $page_select->addOptionArray($options_page); $form->addElement($page_select); $form->addElement(new XoopsFormText(_MI_ABOUT_TEXT_LENGTH, 'options[1]', 5, 5, $options[1])); $form->addElement(new XoopsFormText(_MI_ABOUT_VIEW_MORELINKTEXT, 'options[2]', 30, 50, $options[2])); $form->addElement(new XoopsFormRadioYN(_MI_ABOUT_DOTITLEIMAGE, 'options[3]', $options[3])); return $form->render(); }
/** * Constructor * * @param string $caption * @param string $name * @param mixed $value Pre-selected value (or array of them). * For an item with massive members, such as "Registered Users", "$value" should be used to store selected temporary users only instead of all members of that item * @param bool $include_anon Include user "anonymous"? * @param int $size Number or rows. "1" makes a drop-down-list. * @param bool $multiple Allow multiple selections? */ function XoopsFormSelectUser($caption, $name, $include_anon = false, $value = null, $size = 1, $multiple = false) { $limit = 200; $select_element = new XoopsFormSelect('', $name, $value, $size, $multiple); if ($include_anon) { $select_element->addOption(0, $GLOBALS['xoopsConfig']['anonymous']); } $member_handler =& xoops_gethandler('member'); $user_count = $member_handler->getUserCount(); $value = is_array($value) ? $value : (empty($value) ? array() : array($value)); if ($user_count > $limit && count($value) > 0) { $criteria = new CriteriaCompo(new Criteria('uid', '(' . implode(',', $value) . ')', 'IN')); } else { $criteria = new CriteriaCompo(); $criteria->setLimit($limit); } $criteria->setSort('uname'); $criteria->setOrder('ASC'); $users = $member_handler->getUserList($criteria); $select_element->addOptionArray($users); if ($user_count <= $limit) { $this->XoopsFormElementTray($caption, "", $name); $this->addElement($select_element); return; } xoops_loadLanguage('findusers'); $js_addusers = "<script type='text/javascript'>\r\n function addusers(opts){\r\n var num = opts.substring(0, opts.indexOf(':'));\r\n opts = opts.substring(opts.indexOf(':')+1, opts.length);\r\n var sel = xoopsGetElementById('" . $name . "');\r\n var arr = new Array(num);\r\n for (var n=0; n < num; n++) {\r\n var nm = opts.substring(0, opts.indexOf(':'));\r\n opts = opts.substring(opts.indexOf(':')+1, opts.length);\r\n var val = opts.substring(0, opts.indexOf(':'));\r\n opts = opts.substring(opts.indexOf(':')+1, opts.length);\r\n var txt = opts.substring(0, nm - val.length);\r\n opts = opts.substring(nm - val.length, opts.length);\r\n var added = false;\r\n for (var k = 0; k < sel.options.length; k++) {\r\n if(sel.options[k].value == val){\r\n added = true;\r\n break;\r\n }\r\n }\r\n if (added == false) {\r\n sel.options[k] = new Option(txt, val);\r\n sel.options[k].selected = true;\r\n }\r\n }\r\n return true;\r\n }\r\n </script>"; $token = $GLOBALS['xoopsSecurity']->createToken(); $action_tray = new XoopsFormElementTray("", " | "); $action_tray->addElement(new XoopsFormLabel('', '<a href="#" onclick="var sel = xoopsGetElementById(\'' . $name . '\');for (var i = sel.options.length-1; i >= 0; i--) {if (!sel.options[i].selected) {sel.options[i] = null;}}; return false;">' . _MA_USER_REMOVE . "</a>")); $action_tray->addElement(new XoopsFormLabel('', '<a href="#" onclick="openWithSelfMain(\'' . XOOPS_URL . '/include/findusers.php?target=' . $name . '&multiple=' . $multiple . '&token=' . $token . '\', \'userselect\', 800, 600, null); return false;" >' . _MA_USER_MORE . "</a>" . $js_addusers)); $this->XoopsFormElementTray($caption, '<br /><br />', $name); $this->addElement($select_element); $this->addElement($action_tray); }
function ifocusComponentsShow($options) { include_once XOOPS_ROOT_PATH . "/modules/spotlight/components/ifocus/config.php"; $sp_handler =& xoops_getmodulehandler('spotlight', 'spotlight'); $page_handler =& xoops_getmodulehandler('page', 'spotlight'); // spotlight object $sp_obj = $sp_handler->get($options[0]); if (!is_object($sp_obj) || empty($options[0])) { trigger_error("spotlight is not object ", E_USER_WARNING); } else { //spotlight name $block['sp_name'] = $sp_obj->getVar('sp_name'); // page list $criteria = new CriteriaCompo(); $criteria->add(new Criteria('sp_id', $options[0])); $criteria->setLimit($config['limit']); $criteria->setSort($config['sort']); $criteria->setOrder('ASC'); $pages = $page_handler->getAll($criteria, array('page_id', 'page_title', 'page_link', 'page_image', 'page_desc'), false); foreach ($pages as $k => $v) { $block['news'][$k] = $v; $block['news'][$k]['images'] = XOOPS_UPLOAD_URL . '/spotlight/image_' . $v['page_image']; $block['news'][$k]['thumbs'] = XOOPS_UPLOAD_URL . '/spotlight/thumb_' . $v['page_image']; } // component name $block['component'] = $sp_obj->getVar('component_name'); return $block; } }
/** * Constructor * * @param string $caption * @param string $name * @param mixed $value Pre-selected value (or array of them). * For an item with massive members, such as "Registered Users", "$value" should be used to store selected temporary users only instead of all members of that item * @param bool $include_anon Include user "anonymous"? * @param int $size Number or rows. "1" makes a drop-down-list. * @param bool $multiple Allow multiple selections? */ function XoopsFormSelectUser($caption, $name, $value = array(), $include_anon = false, $size = 1, $multiple = false) { $this->XoopsFormElementTray($caption, "<br /><br />", $name); $select_form = new XoopsFormSelect("", $name, $value, $size, $multiple); if ($include_anon) { $select_form->addOption(0, $GLOBALS["xoopsConfig"]['anonymous']); } $member_handler =& xoops_gethandler('member'); $criteria = new CriteriaCompo(); if (!is_array($value)) { $value = array($value); } if (is_array($value) && count($value) > 0) { $id_in = "(" . implode(",", $value) . ")"; $criteria->add(new Criteria("uid", $id_in, "IN")); $criteria->setSort('name'); $criteria->setOrder('ASC'); $users = $member_handler->getUserList($criteria); $select_form->addOptionArray($member_handler->getUserList($criteria)); } $action_tray = new XoopsFormElementTray("", " | "); $action_tray->addElement(new XoopsFormLabel('', "<a href='###' onclick='return openWithSelfMain(\"" . XOOPS_URL . "/modules/system/include/userselect.php?action=1&target=" . $name . "&multiple=" . $multiple . "\", \"userselect\", 800, 500, null);' >" . _LIST . "</a>")); $action_tray->addElement(new XoopsFormLabel('', "<a href='###' onclick='return openWithSelfMain(\"" . XOOPS_URL . "/modules/system/include/userselect.php?action=0&target=" . $name . "&multiple=" . $multiple . "\", \"userselect\", 800, 500, null);' >" . _SEARCH . "</a>")); $action_tray->addElement(new XoopsFormLabel('', "<a href='###' onclick='var sel = xoopsGetElementById(\"" . $name . "\");for (var i = sel.options.length-1; i >= 0; i--) {if (sel.options[i].selected) {sel.options[i] = null;}}'>" . _REMOVE . "</a>" . "<script type=\"text/javascript\">\n\t\t function addusers(opts){\n\t\t\t var num = opts.substring(0, opts.indexOf(\":\"));\n\t\t\t opts = opts.substring(opts.indexOf(\":\")+1, opts.length);\n \t\tvar sel = xoopsGetElementById(\"" . $name . "\");\n\t\t\t var arr = new Array(num);\n\t\t\t for(var n=0; n<num; n++){\n\t\t\t \tvar nm = opts.substring(0, opts.indexOf(\":\"));\n\t\t\t \topts = opts.substring(opts.indexOf(\":\")+1, opts.length);\n\t\t\t \tvar val = opts.substring(0, opts.indexOf(\":\"));\n\t\t\t \topts = opts.substring(opts.indexOf(\":\")+1, opts.length);\n\t\t\t \tvar txt = opts.substring(0, nm - val.length);\n\t\t\t \topts = opts.substring(nm - val.length, opts.length);\n\t\t\t\t\tvar added = false;\n\t\t\t\t\tfor (var k = 0; k < sel.options.length; k++) {\n\t\t\t\t\t\tif(sel.options[k].value == val){\n\t\t\t\t\t\t\tadded = true;\n\t\t\t\t\t\t\tbreak;\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t\tif(added==false){\n\t\t\t\t\t\tappendSelectOption(\"" . $name . "\",txt, val);\n\t \t\t}\n\t\t\t }\n\t\t\t\treturn true;\n\t\t }\n\t\t\t</script>")); $this->addElement($select_form); $this->addElement($action_tray); }
/** * Constructor * * @param string $caption * @param string $name * @param mixed $value Pre-selected value (or array of them). * For an item with massive members, such as "Registered Users", "$value" should be used to store selected temporary users only instead of all members of that item * @param bool $include_anon Include user "anonymous"? * @param int $size Number or rows. "1" makes a drop-down-list. * @param bool $multiple Allow multiple selections? */ function __construct($caption, $name, $include_anon = false, $value = null, $size = 1, $multiple = false) { $limit = 200; $select_element = new Xmf_Form_Element_Select("", $name, $value, $size, $multiple); if ($include_anon) { $select_element->addOption(0, $GLOBALS["xoopsConfig"]['anonymous']); } $member_handler =& xoops_gethandler('member'); $user_count = $member_handler->getUserCount(); $value = is_array($value) ? $value : (empty($value) ? array() : array($value)); if ($user_count > $limit && count($value) > 0) { $criteria = new CriteriaCompo(new Criteria("uid", "(" . implode(",", $value) . ")", "IN")); } else { $criteria = new CriteriaCompo(); $criteria->setLimit($limit); } $criteria->setSort('uname'); $criteria->setOrder('ASC'); $users = $member_handler->getUserList($criteria); $select_element->addOptionArray($users); if ($user_count <= $limit) { parent::__construct($caption, "", $name); $this->addElement($select_element); return; } xoops_loadLanguage("findusers"); $js_addusers = "<script type=\"text/javascript\">\r\n function addusers(opts){\r\n var num = opts.substring(0, opts.indexOf(\":\"));\r\n opts = opts.substring(opts.indexOf(\":\")+1, opts.length);\r\n var sel = xoopsGetElementById(\"" . $name . ($multiple ? "[]" : "") . "\");\r\n var arr = new Array(num);\r\n for (var n=0; n < num; n++) {\r\n var nm = opts.substring(0, opts.indexOf(\":\"));\r\n opts = opts.substring(opts.indexOf(\":\")+1, opts.length);\r\n var val = opts.substring(0, opts.indexOf(\":\"));\r\n opts = opts.substring(opts.indexOf(\":\")+1, opts.length);\r\n var txt = opts.substring(0, nm - val.length);\r\n opts = opts.substring(nm - val.length, opts.length);\r\n var added = false;\r\n for (var k = 0; k < sel.options.length; k++) {\r\n if(sel.options[k].value == val){\r\n added = true;\r\n break;\r\n }\r\n }\r\n if (added == false) {\r\n sel.options[k] = new Option(txt, val);\r\n sel.options[k].selected = true;\r\n }\r\n }\r\n return true;\r\n }\r\n </script>"; $token = $GLOBALS['xoopsSecurity']->createToken(); $action_tray = new Xmf_Form_Element_Tray("", " | "); $action_tray->addElement(new Xmf_Form_Element_Label('', "<a href='#' onclick='var sel = xoopsGetElementById(\"" . $name . ($multiple ? "[]" : "") . "\");for (var i = sel.options.length-1; i >= 0; i--) {if (!sel.options[i].selected) {sel.options[i] = null;}}; return false;'>" . _MA_USER_REMOVE . "</a>")); $action_tray->addElement(new Xmf_Form_Element_Label('', "<a href='#' onclick='openWithSelfMain(\"" . XOOPS_URL . "/include/findusers.php?target={$name}&multiple={$multiple}&token={$token}\", \"userselect\", 800, 600, null); return false;' >" . _MA_USER_MORE . "</a>" . $js_addusers)); parent::__construct($caption, "<br /><br />", $name); $this->addElement($select_element); $this->addElement($action_tray); }
function showcaseComponentsShow($options) { include XOOPS_ROOT_PATH . "/modules/spotlight/components/showcase/config.php"; $sp_handler =& xoops_getmodulehandler('spotlight', 'spotlight'); $page_handler =& xoops_getmodulehandler('page', 'spotlight'); // spotlight object $sp_obj = $sp_handler->get($options[0]); if (!is_object($sp_obj) || empty($options[0])) { trigger_error("spotlight is not object ", E_USER_WARNING); } else { //spotlight name $block['sp_name'] = $sp_obj->getVar('sp_name'); // page list $criteria = new CriteriaCompo(); $criteria->add(new Criteria('sp_id', $options[0])); $criteria->setLimit($config['limit']); $criteria->setSort($config['sort']); $criteria->setOrder('ASC'); $pages = $page_handler->getAll($criteria, array('page_id', 'page_title', 'page_link', 'page_image', 'page_desc', 'published'), false); $myts = MyTextSanitizer::getInstance(); foreach ($pages as $k => $v) { $block['news'][$k] = $v; $block['news'][$k]['images'] = XOOPS_UPLOAD_URL . '/spotlight/image_' . $v['page_image']; $block['news'][$k]['thumbs'] = XOOPS_UPLOAD_URL . '/spotlight/thumb_' . $v['page_image']; $page_desc = strip_tags($myts->undoHtmlSpecialChars(strip_tags($v['page_desc']))); $block['news'][$k]['page_desc'] = xoops_substr($page_desc, '', $config['page_desc_substr']); $block['news'][$k]['page_title'] = xoops_substr($v['page_title'], '', $config['page_title_substr']); $block['news'][$k]['published'] = formatTimestamp($v['published'], $config['timeformat']); } // component name $block['component'] = $sp_obj->getVar('component_name'); return $block; } }
public function getCategoryList($uid = 0) { $criteria = new CriteriaCompo(); if (!empty($uid)) { $criteria->add(new Criteria("uid", $uid)); } $criteria->setOrder("ASC"); $criteria->setSort("cat_id"); $categories = $this->getAll($criteria); $catarr = array(); if ($this->getCount($criteria)) { unset($criteria); $topic_handler = xoops_getmodulehandler("topics", "press"); $criteria = new CriteriaCompo(new Criteria("cat_id", "(" . implode(",", array_keys($categories)) . ")", "in")); if (!empty($uid)) { $criteria->add(new Criteria("uid", $uid)); } $criteria->setGroupby("cat_id"); $counts = $topic_handler->getCounts($criteria); foreach ($categories as $key => $obj) { $catarr[$key]["cat_name"] = $obj->getVar("cat_name"); $catarr[$key]["cat_id"] = $key; if (!empty($uid)) { $catarr[$key]["uid"] = $uid; } $catarr[$key]["cat_topics"] = isset($counts[$key]) ? $counts[$key] : 0; } return $catarr; } }
function publisher_date_to_date_show($options) { $myts = MyTextSanitizer::getInstance(); $publisher = PublisherPublisher::getInstance(); $block = array(); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('datesub', strtotime($options[0]), '>')); $criteria->add(new Criteria('datesub', strtotime($options[1]), '<')); $criteria->setSort('datesub'); $criteria->setOrder('DESC'); // creating the ITEM objects that belong to the selected category $itemsObj = $publisher->getHandler('item')->getObjects($criteria); $totalItems = count($itemsObj); if ($itemsObj) { for ($i = 0; $i < $totalItems; $i++) { $newItems['itemid'] = $itemsObj[$i]->itemid(); $newItems['title'] = $itemsObj[$i]->title(); $newItems['categoryname'] = $itemsObj[$i]->getCategoryName(); $newItems['categoryid'] = $itemsObj[$i]->categoryid(); $newItems['date'] = $itemsObj[$i]->datesub(); $newItems['poster'] = $itemsObj[$i]->linkedPosterName(); $newItems['itemlink'] = $itemsObj[$i]->getItemLink(false, isset($options[3]) ? $options[3] : 65); $newItems['categorylink'] = $itemsObj[$i]->getCategoryLink(); $block['items'][] = $newItems; } $block['lang_title'] = _MB_PUBLISHER_ITEMS; $block['lang_category'] = _MB_PUBLISHER_CATEGORY; $block['lang_poster'] = _MB_PUBLISHER_POSTEDBY; $block['lang_date'] = _MB_PUBLISHER_DATE; $modulename = $myts->displayTarea($publisher->getModule()->getVar('name')); $block['lang_visitItem'] = _MB_PUBLISHER_VISITITEM . " " . $modulename; $block['lang_articles_from_to'] = sprintf(_MB_PUBLISHER_ARTICLES_FROM_TO, $options[0], $options[1]); } return $block; }
function b_user_topusers_show($options) { $block = array(); $criteria = new CriteriaCompo(new Criteria('level', 0, '>')); $limit = (!empty($options[0])) ? $options[0] : 10; $size = count($options); for ( $i = 2; $i < $size; $i++) { $criteria->add(new Criteria('rank', $options[$i], '<>')); } $criteria->setOrder('DESC'); $criteria->setSort('posts'); $criteria->setLimit($limit); $member_handler =& xoops_gethandler('member'); $topposters =& $member_handler->getUsers($criteria); $count = count($topposters); for ($i = 0; $i < $count; $i++) { $block['users'][$i]['rank'] = $i+1; if ( $options[1] == 1 ) { $block['users'][$i]['avatar'] = $topposters[$i]->getVar('user_avatar') != 'blank.gif' ? XOOPS_UPLOAD_URL.'/'.$topposters[$i]->getVar('user_avatar') : ''; } else { $block['users'][$i]['avatar'] = ''; } $block['users'][$i]['id'] = $topposters[$i]->getVar('uid'); $block['users'][$i]['name'] = $topposters[$i]->getVar('uname'); $block['users'][$i]['posts'] = $topposters[$i]->getVar('posts'); } return $block; }
function links_block_edit($options) { include_once XOOPS_ROOT_PATH . "/modules/links/include/xoopsformloader.php"; $form = new XoopsBlockForm("", "", ""); $categories = new XoopsFormSelect(_MB_LINKS_SHOWCAT, 'options[0]', $options[0]); $categories->addOption(0, _MB_LINKS_ALL); $cat_handler = xoops_getmodulehandler('category', 'links'); $criteria = new CriteriaCompo(); $criteria->setSort('cat_order'); $criteria->setOrder('ASC'); $category = $cat_handler->getList($criteria); foreach ($cat_handler->getList($criteria) as $k => $v) { $categories->addOption($k, $v); } $form->addElement($categories, true); $sort = new XoopsFormSelect(_MB_LINKS_SORTWAY, 'options[1]', $options[1]); $sort->addOption('published', _MB_LINKS_PUBLISHTIME); $sort->addOption('datetime', _MB_LINKS_UPDATETIME); $sort->addOption('link_order', _MB_LINKS_DEFAULT); $form->addElement($sort, true); $form->addElement(new XoopsFormText(_MB_LINKS_SHOWHOWLIK, "options[2]", 5, 2, $options[2]), true); $form->addElement(new XoopsFormText(_MB_LINKS_LIKTITLEMAX, "options[3]", 5, 2, $options[3]), true); $form->addElement(new XoopsFormRadioYN(_MB_LINKS_SHOWCATTITLE, 'options[4]', $options[4]), true); $display = new XoopsFormSelect(_MB_LINKS_BYSHOW, 'options[5]', $options[5]); $display->addOption('1', _MB_LINKS_LOGOHOR); $display->addOption('2', _MB_LINKS_LOGOVER); $display->addOption('3', _MB_LINKS_TITLEHOR); $display->addOption('4', _MB_LINKS_TITLEVER); $form->addElement($display, true); return $form->render(); }
function alumniCategoryDisplayChildren($cid = 0, $categoryArray, $prefix = '', $order = '', &$class) { $xoops = Xoops::getInstance(); $moduleDirName = basename(dirname(__DIR__)); $prefix = $prefix . '<img src=\'' . XOOPS_URL . "/modules/{$moduleDirName}/images/arrow.gif'>"; foreach (array_keys($categoryArray) as $i) { $cid = $categoryArray[$i]->getVar('cid'); $pid = $categoryArray[$i]->getVar('pid'); $title = $categoryArray[$i]->getVar('title'); $img = $categoryArray[$i]->getVar('img'); $order = $categoryArray[$i]->getVar('ordre'); echo '<tr class="' . $class . '">'; echo '<td align="left">' . $prefix . ' ' . $categoryArray[$i]->getVar('title') . '</td>'; echo '<td align="center"><img src="' . XOOPS_URL . "/modules/{$moduleDirName}/images/cat/" . $categoryArray[$i]->getVar('img') . '" height="16px" title="img" alt="img"></td>'; echo '<td align="center">' . $categoryArray[$i]->getVar('ordre') . '</td>'; echo "<td align='center' width='10%'>\n\t\t\t\t\t\t<a href='category.php?op=edit_category&cid=" . $categoryArray[$i]->getVar('cid') . "'><img src='../images/edit.gif' alt='" . XoopsLocale::A_EDIT . "' title='" . XoopsLocale::A_EDIT . "'></a>\n\t\t\t\t\t\t<a href='category.php?op=delete_category&cid=" . $categoryArray[$i]->getVar('cid') . "'><img src='../images/dele.gif' alt='" . XoopsLocale::A_DELETE . "' title='" . XoopsLocale::A_DELETE . "'></a></td></tr>"; $class = $class == "even" ? "odd" : "even"; $categoriesHandler = $xoops->getModuleHandler('category', 'alumni'); $criteria2 = new CriteriaCompo(); $criteria2->add(new Criteria('pid', $categoryArray[$i]->getVar('cid'))); $criteria2->setSort('title'); $criteria2->setOrder('ASC'); $cat_pid = $categoriesHandler->getAll($criteria2); $num_pid = $categoriesHandler->getCount(); if ($num_pid != 0) { alumniCategoryDisplayChildren($cid, $cat_pid, $prefix, $order, $class); } } }
/** * @param $options * @return array */ function alumni_show($options) { $block = array(); $myts = MyTextSanitizer::getInstance(); $xoops = Xoops::getInstance(); $helper = $xoops->getModuleHelper('alumni'); $module_id = $helper->getModule()->getVar('mid'); $listingHandler = $helper->getHandler('listing'); $groups = $xoops->getUserGroups(); $alumni_ids = $xoops->getHandlerGroupPermission()->getItemIds('alumni_view', $groups, $module_id); $all_ids = implode(', ', $alumni_ids); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('valid', 1, '=')); $criteria->add(new Criteria('cid', '(' . $all_ids . ')', 'IN')); $criteria->setLimit($options[1]); $criteria->setSort('date'); $criteria->setOrder('DESC'); $block_listings = $listingHandler->getall($criteria); foreach (array_keys($block_listings) as $i) { $name = $block_listings[$i]->getVar('name'); $mname = $block_listings[$i]->getVar('mname'); $lname = $block_listings[$i]->getVar('lname'); $school = $block_listings[$i]->getVar('school'); $year = $block_listings[$i]->getVar('year'); $view = $block_listings[$i]->getVar('view'); $a_item = array(); $a_item['school'] = $school; $a_item['link'] = '<a href="' . XOOPS_URL . "/modules/alumni/listing.php?lid=" . addslashes($block_listings[$i]->getVar('lid')) . "\"><b>{$year} - {$name} {$mname} {$lname}</b><br /></a>"; $block['items'][] = $a_item; } $block['lang_title'] = AlumniLocale::BLOCKS_ITEM; $block['lang_date'] = AlumniLocale::BLOCKS_DATE; $block['link'] = "<a href=\"" . XOOPS_URL . "/modules/alumni/index.php\"><b>" . AlumniLocale::BLOCKS_ALL_LISTINGS . "</b></a></div>"; return $block; }
/** * xoopsfaq_search() * * @param mixed $queryarray * @param mixed $andor * @param mixed $limit * @param mixed $offset * @param mixed $userid * @return */ function xoopsfaq_search($queryarray, $andor, $limit, $offset, $userid) { global $xoopsDB; $ret = array(); if ($userid != 0) { return $ret; } $xfDir = basename(dirname(dirname(__FILE__))); $xfContentsHandler =& xoops_getmodulehandler('contents', $xfDir); $contentFields = array('contents_id', 'contents_cid', 'contents_title', 'contents_contents', 'contents_publish'); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('contents_active', 1, '=')); $criteria->setSort('contents_id'); $criteria->setOrder('DESC'); $criteria->setLimit(intval($limit)); $criteria->setStart(intval($offset)); if (is_array($queryarray) && !empty($queryarray)) { $criteria->add(new Criteria('contents_title', "%{$queryarray[0]}%", 'LIKE')); $criteria->add(new Criteria('contents_contents', "%{$queryarray[0]}%", 'LIKE'), 'OR'); array_shift($queryarray); //get rid of first element foreach ($queryarray as $query) { $criteria->add(new Criteria('contents_title', "%{$query}%", 'LIKE'), $andor); $criteria->add(new Criteria('contents_contents', "%{$query}%", 'LIKE'), 'OR'); } } $contentArray = $xfContentsHandler->getAll($criteria, $contentFields, false); foreach ($contentArray as $content) { $ret[] = array('image' => 'images/question2.gif', 'link' => "index.php?cat_id=" . $content['contents_cid'] . "#" . $content['contents_id'], 'title' => $content['contents_title'], 'time' => $content['contents_publish']); } unset($contentArray); return $ret; }
function flash3ComponentsShow($options) { global $xoopsModuleConfig; include_once dirname(__FILE__) . "/config.php"; $sp_handler =& xoops_getmodulehandler('spotlight', 'spotlight'); $page_handler =& xoops_getmodulehandler('page', 'spotlight'); // spotlight object $sp_obj = $sp_handler->get($options[0]); if (!is_object($sp_obj) || empty($options[0])) { trigger_error("spotlight is not object ", E_USER_WARNING); } else { //spotlight name $block['sp_name'] = $sp_obj->getVar('sp_name'); } $criteria = new CriteriaCompo(); $criteria->add(new Criteria('sp_id', $options[0])); $criteria->setLimit(5); $criteria->setSort('page_order'); $criteria->setOrder('ASC'); $pages = $page_handler->getAll($criteria, array('page_id', 'page_title', 'page_link', 'page_image', 'page_desc'), false); foreach ($pages as $k => $v) { $block['title'][] = $v['page_title']; $block['url'][] = $v['page_link']; $block['images'][] = XOOPS_UPLOAD_URL . '/spotlight/' . 'thumb_' . $v['page_image']; } $block['catid'] = $options[0]; $block['catname'] = $block['sp_name']; $block['type'] = 3; $block['title'] = implode('|', $block['title']); $block['url'] = implode('|', $block['url']); $block['images'] = implode('|', $block['images']); $block['component'] = $sp_obj->getVar('component_name'); // xoops_result($block); return $block; }
function b_categories_list_show($options) { include_once XOOPS_ROOT_PATH . "/modules/smartpartner/include/common.php"; $smartpartner_category_handler =& smartpartner_gethandler('category'); $criteria = new CriteriaCompo(); $criteria->setSort(isset($options[0]) ? $options[0] : 'name'); $criteria->setOrder(isset($options[1]) ? $options[1] : 'ASC'); $catsObj =& $smartpartner_category_handler->getobjects($criteria, true); $catArray = get_content(0, $catsObj, $options[2]); $block = array(); $block['categories'] = $catArray; $block['displaysubs'] = $options[2]; if (isset($_GET['view_category_id'])) { $current_id = $_GET['view_category_id']; $block['current'] = $catsObj[$current_id]->getVar('parentid') == 0 ? $current_id : $catsObj[$current_id]->getVar('parentid'); } elseif (isset($_GET['id'])) { $smartpartner_partner_handler =& smartpartner_gethandler('partner'); $partnerObj = $smartpartner_partner_handler->get($_GET['id']); if (is_object($partnerObj)) { $parent = $partnerObj->getVar('categoryid'); $block['current'] = $catsObj[$parent]->getVar('parentid') == 0 ? $parent : $catsObj[$parent]->getVar('parentid'); } } return $block; }
/** * Export des données * @return boolean Vrai si l'export a réussi sinon faux */ function export() { $def = array(array('o_id', 'N', 10, 0), array('o_uid', 'N', 10, 0), array('o_date', 'D'), array('o_state', 'N', 1, 0), array('o_ip', 'C', 32), array('o_lastname', 'C', 155), array('o_firstnam', 'C', 155), array('o_adress', 'C', 155), array('o_zip', 'C', 30), array('o_town', 'C', 155), array('o_country', 'C', 3), array('o_telephon', 'C', 30), array('o_email', 'C', 155), array('o_articles', 'N', 10, 0), array('o_total', 'N', 10, 2), array('o_shipping', 'N', 10, 2), array('o_bill', 'L'), array('o_password', 'C', 155), array('o_text', 'C', 155), array('o_cancel', 'C', 155), array('c_id', 'N', 10, 0), array('c_prod_id', 'N', 10, 0), array('c_qte', 'N', 10, 0), array('c_price', 'N', 10, 2), array('c_o_id', 'N', 10, 0), array('c_shipping', 'N', 10, 2), array('c_pass', 'C', 155)); /* * Correspondances * cmd_id o_id * cmd_uid o_uid * cmd_date o_date * cmd_state o_state * cmd_ip o_ip * cmd_lastname o_lastname * cmd_firstname o_firstnam * cmd_adress o_adress * cmd_zip o_zip * cmd_town o_town * cmd_country o_country * cmd_telephone o_telephon * cmd_email o_email * cmd_articles_count o_articles * cmd_total o_total * cmd_shipping o_shipping * cmd_bill o_bill * cmd_password o_password * cmd_text o_text * cmd_cancel o_cancel * caddy_id c_id * caddy_product_id c_prod_id * caddy_qte c_qte * caddy_price c_price * caddy_cmd_id c_o_id * caddy_shipping c_shipping * caddy_pass c_pass */ if (!dbase_create($this->folder . DIRECTORY_SEPARATOR . $this->filename, $def)) { $this->success = false; return false; } $dbf = dbase_open($this->folder . DIRECTORY_SEPARATOR . $this->filename, 2); if ($dbf === false) { $this->success = false; return false; } $criteria = new CriteriaCompo(); $criteria->add(new Criteria('cmd_id', 0, '<>')); $criteria->add(new Criteria('cmd_state', $this->orderType, '=')); $criteria->setSort('cmd_date'); $criteria->setOrder('DESC'); $orders = $this->handlers->h_oledrion_commands->getObjects($criteria); foreach ($orders as $order) { $carts = array(); $carts = $this->handlers->h_oledrion_caddy->getObjects(new Criteria('caddy_cmd_id', $order->getVar('cmd_id'), '=')); foreach ($carts as $cart) { dbase_add_record($dbf, array($order->getVar('cmd_id'), $order->getVar('cmd_uid'), date('Ymd', strtotime($order->getVar('cmd_date'))), $order->getVar('cmd_state'), $order->getVar('cmd_ip'), $order->getVar('cmd_lastname'), $order->getVar('cmd_firstname'), $order->getVar('cmd_adress'), $order->getVar('cmd_zip'), $order->getVar('cmd_town'), $order->getVar('cmd_country'), $order->getVar('cmd_telephone'), $order->getVar('cmd_email'), $order->getVar('cmd_articles_count'), $order->getVar('cmd_total'), $order->getVar('cmd_shipping'), $order->getVar('cmd_bill'), $order->getVar('cmd_password'), $order->getVar('cmd_text'), $order->getVar('cmd_cancel'), $cart->getVar('caddy_id'), $cart->getVar('caddy_product_id'), $cart->getVar('caddy_qte'), $cart->getVar('caddy_price'), $cart->getVar('caddy_cmd_id'), $cart->getVar('caddy_shipping'), $cart->getVar('caddy_pass'))); } } dbase_close($dbf); $this->success = true; return true; }
/** * @得到列表 * @method: * @license http://www.blags.org/ * @created:2010年05月23日 14时59分 * @copyright 1997-2010 The Martin Group * @author Martin <*****@*****.**> * */ function &getHotelServiceTypes($limit = 0, $start = 0, $sort = 'service_type_id', $order = 'ASC', $id_as_key = true) { $criteria = new CriteriaCompo(); $criteria->setSort($sort); $criteria->setOrder($order); $criteria->setStart($start); $criteria->setLimit($limit); return $this->getObjects($criteria, $id_as_key); }
public function getLatestRevision($pageId, $status = Lenum_Status::PROGRESS) { $cri = new CriteriaCompo(); $cri->add(new Criteria('page_id', $pageId)); $cri->add(new Criteria('status', $status, '>=')); $cri->setSort('revision_id', 'DESC'); $objs = $this->getObjects($cri); return count($objs) > 0 ? array_shift($objs) : null; }
function press_block_category_show($options) { $category_handler = xoops_getmodulehandler("category", "press"); $criteria = new CriteriaCompo(); $criteria->setSort('cat_id'); $criteria->setOrder('ASC'); $block = $category_handler->getList($criteria); return $block; }
public function countRelated($start = 0, $limit = 0, $sort = 'related_name', $order = 'ASC') { $criteria = new CriteriaCompo(); $criteria->setSort($sort); $criteria->setOrder($order); $criteria->setStart($start); $criteria->setLimit($limit); return parent::getCount(); }
function banners_blocks_edit($options) { $form = ''; switch ($options[0]) { case 'random': $form .= _MB_BANNERS_DISP . " \n"; $form .= "<input type=\"hidden\" name=\"options[0]\" value=\"" . $options[0] . "\" />\n"; $form .= "<input name=\"options[1]\" size=\"5\" maxlength=\"255\" value=\"" . $options[1] . "\" type=\"text\" /> " . _MB_BANNERS . "<br />\n"; switch ($options[2]) { case 'H': $checked_H = 'checked="checked"'; $checked_V = ''; break; case 'V': $checked_H = ''; $checked_V = 'checked="checked"'; break; } $form .= _MB_BANNERS_ALIGNEMENT . " : <input name=\"options[2]\" value=\"H\" type=\"radio\" " . $checked_H . "/>" . _MB_BANNERS_ALIGNEMENT_H . " \n"; $form .= "<input name=\"options[2]\" value=\"V\" type=\"radio\" " . $checked_V . "/>" . _MB_BANNERS_ALIGNEMENT_V . "<br />\n"; array_shift($options); array_shift($options); array_shift($options); $form .= _MB_BANNERS_CLIENTSTODISPLAY . "<br /><select name=\"options[]\" multiple=\"multiple\" size=\"5\">\n"; $xoops = Xoops::getInstance(); $client_Handler = $xoops->getModuleHandler('bannerclient', 'banners'); $criteria = new CriteriaCompo(); $criteria->setSort('bannerclient_name'); $criteria->setOrder('ASC'); $client_arr = $client_Handler->getAll($criteria); $form .= "<option value=\"0\" " . (array_search(0, $options) === false ? '' : 'selected="selected"') . ">" . _MB_BANNERS_ALLCLIENTS . "</option>\n"; foreach (array_keys($client_arr) as $i) { $form .= "<option value=\"" . $client_arr[$i]->getVar('cid') . "\" " . (array_search($client_arr[$i]->getVar('cid'), $options) === false ? '' : 'selected="selected"') . ">" . $client_arr[$i]->getVar('name') . "</option>\n"; } $form .= "</select>\n"; break; case 'id': $form .= _MB_BANNERS_IDDISPLAY . " \n"; $form .= "<input type=\"hidden\" name=\"options[0]\" value=\"" . $options[0] . "\" />\n"; $form .= "<input name=\"options[1]\" size=\"20\" maxlength=\"255\" value=\"" . $options[1] . "\" type=\"text\" /> " . _MB_BANNERS_SEP . "<br />\n"; switch ($options[2]) { case 'H': $checked_H = 'checked="checked"'; $checked_V = ''; break; case 'V': $checked_H = ''; $checked_V = 'checked="checked"'; break; } $form .= _MB_BANNERS_ALIGNEMENT . " : <input name=\"options[2]\" value=\"H\" type=\"radio\" " . $checked_H . "/>" . _MB_BANNERS_ALIGNEMENT_H . " \n"; $form .= "<input name=\"options[2]\" value=\"V\" type=\"radio\" " . $checked_V . "/>" . _MB_BANNERS_ALIGNEMENT_V . "<br />\n"; break; } return $form; }
function setContent($isreturn = false) { global $jieqiTpl; global $jieqiConfigs; jieqi_getconfigs('article', 'configs'); $article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl']; $article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl']; $jieqiTpl->assign('article_static_url', $article_static_url); $jieqiTpl->assign('article_dynamic_url', $article_dynamic_url); jieqi_includedb(); $query = JieqiQueryHandler::getInstance('JieqiQueryHandler'); $criteria = new CriteriaCompo(); $criteria->setFields("r.*,a.articlename"); $criteria->setTables(jieqi_dbprefix('article_reviews') . " AS r LEFT JOIN " . jieqi_dbprefix('article_article') . " AS a ON r.ownerid=a.articleid"); if ($this->exevars['istop'] == 1) { $criteria->add(new Criteria('r.istop', '1')); } elseif ($this->exevars['istop'] == 2) { $criteria->add(new Criteria('r.istop', '0')); } if ($this->exevars['isgood'] == 1) { $criteria->add(new Criteria('r.isgood', '1')); } elseif ($this->exevars['isgood'] == 2) { $criteria->add(new Criteria('r.isgood', '0')); } $criteria->setSort('r.topicid'); $criteria->setOrder('DESC'); $criteria->setLimit($this->exevars['listnum']); $criteria->setStart(0); $query->queryObjects($criteria); $reviewrows = array(); $i = 0; while ($v = $query->getObject()) { $reviewrows[$i]['reviewtitle'] = jieqi_htmlstr(str_replace(array("\r", "\n"), array('', ' '), $v->getVar('title', 'n'))); $reviewrows[$i]['ownerid'] = $v->getVar('ownerid'); $reviewrows[$i]['articlename'] = $v->getVar('articlename'); $reviewrows[$i]['topicid'] = $v->getVar('topicid'); $reviewrows[$i]['url_review'] = $article_dynamic_url . '/reviews.php?aid=' . $v->getVar('ownerid'); $reviewrows[$i]['poster'] = $v->getVar('poster'); $reviewrows[$i]['posterid'] = $v->getVar('posterid'); $reviewrows[$i]['postdate'] = date('m-d H:i', $v->getVar('posttime')); $reviewrows[$i]['posttime'] = $v->getVar('posttime'); $reviewrows[$i]['replytime'] = $v->getVar('replytime'); $reviewrows[$i]['views'] = $v->getVar('views'); $reviewrows[$i]['replies'] = $v->getVar('replies'); $reviewrows[$i]['islock'] = $v->getVar('islock'); $reviewrows[$i]['istop'] = $v->getVar('istop'); $reviewrows[$i]['isgood'] = $v->getVar('isgood'); $reviewrows[$i]['topictype'] = $v->getVar('topictype'); $reviewrows[$i]['url_articleinfo'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'info'); $reviewrows[$i]['url_articleindex'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'index'); $reviewrows[$i]['url_articleread'] = $reviewrows[$i]['url_articleindex']; $i++; } $jieqiTpl->assign_by_ref('reviewrows', $reviewrows); $jieqiTpl->assign('url_more', $article_dynamic_url . '/reviewslist.php'); }
/** * Private helper functions for traversing the category tree * * @param int $parentid ID to start from * @param int $level used in recursions * @param int $offset integer added to location * * @return void */ function getPageHelper($parentid = 0, $level = 0) { $page_handler =& xoops_getmodulehandler('page', 'alexandria'); $criteria = new CriteriaCompo(); $criteria->setSort('page_title'); $page_arr =& $page_handler->getObjects($criteria); include_once XOOPS_ROOT_PATH . "/class/tree.php"; $tree = new XoopsObjectTree($page_arr, 'page_id', 'page_parent'); $this->traversePageTree($tree, $parentid, $level); }
/** * Private helper functions for traversing the category tree * * @param int $parentid ID to start from * @param int $level used in recursions * @param int $offset integer added to location * * @return void */ function getPageHelper($parentid = 0, $level = 0) { $cat_handler =& xoops_getmodulehandler('category', 'smartsection'); $criteria = new CriteriaCompo(); $criteria->setSort('name'); $cat_arr =& $cat_handler->getObjects($criteria); include_once XOOPS_ROOT_PATH . "/class/tree.php"; $tree = new XoopsObjectTree($cat_arr, 'categoryid', 'parentid'); $this->traversePageTree($tree, $parentid, $level); }
function linksForm($action = false) { global $xoopsModuleConfig; if ($action === false) { $action = $_SERVER['REQUEST_URI']; } include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php"; $title = $this->isNew() ? _AM_LINKS_ADDLIK : _AM_LINKS_UPDATELIK; $link_status = $this->isNew() ? 1 : $this->getVar('link_status'); $form = new XoopsThemeForm($title, 'form', $action, 'post', true); $form->setExtra('enctype="multipart/form-data"'); $cat_id = isset($_REQUEST['cid']) ? $_REQUEST['cid'] : ''; if (empty($cat_id)) { $cat_id = $this->getVar("cat_id"); } $categories = new XoopsFormSelect(_AM_LINKS_CATNAME, 'cat_id', $cat_id); $cat_handler = xoops_getmodulehandler('category', 'links'); $criteria = new CriteriaCompo(); $criteria->setSort('cat_order'); $criteria->setOrder('ASC'); $categories->addOptionArray($cat_handler->getList($criteria)); $form->addElement($categories, true); $form->addElement(new XoopsFormText(_AM_LINKS_TITLE, 'link_title', 40, 50, $this->getVar('link_title')), true); if (!$this->isNew()) { $form->addElement(new XoopsFormText(_AM_LINKS_LIKADD, 'link_url', 80, 5000, $this->getVar('link_url'), true)); $form->addElement(new XoopsFormHidden('datetime', time())); } else { $form->addElement(new XoopsFormText(_AM_LINKS_LIKADD, 'link_url', 80, 5000, 'http://'), true); $form->addElement(new XoopsFormHidden('published', time())); $form->addElement(new XoopsFormHidden('datetime', time())); } $logo_image = new XoopsFormElementTray(_AM_LINKS_LIKLOGO); if (!empty($xoopsModuleConfig['logo'])) { if ($this->getVar('link_title')) { $logo_image->addElement(new XoopsFormLabel('', '<img src="' . XOOPS_URL . $xoopsModuleConfig['logo_dir'] . $this->getVar('link_image') . '"><br><br>')); $display = _AM_LINKS_LOGOWARN; } else { $display = ''; } $logo_image->addElement(new XoopsFormFile('', 'link_image', 1024 * 1024 * 2)); } else { $logo_image->addElement(new XoopsFormText('', 'link_dir', 70, 255, $this->getVar('link_dir'))); $display = _AM_LINKS_LOGOTIPS . XOOPS_URL . '/uploads/logo/logo.jpg'; } $logo_image->addElement(new XoopsFormLabel('', $display)); $form->addElement($logo_image); $form->addElement(new XoopsFormText(_AM_LINKS_SORT, 'link_order', 4, 2, $this->getVar('link_order'))); $form->addElement(new XoopsFormText(_AM_LINKS_CONTACT, 'link_contact', 60, 255, $this->getVar('link_contact'))); $form->addElement(new XoopsFormRadioYN(_AM_LINKS_SHOW, 'link_status', $link_status)); $form->addElement(new XoopsFormHidden('link_id', $this->getVar('link_id'))); $form->addElement(new XoopsFormHidden('ac', 'insert')); $form->addElement(new XoopsFormButton('', 'submit', _SUBMIT, 'submit')); return $form; }
public function search($queries, $andor, $limit, $start, $userid) { $xoops = Xoops::getInstance(); $alumni = Alumni::getInstance(); $myts = MyTextSanitizer::getInstance(); $by_cat = Request::getInt('by_cat', ''); $andor = Request::getWord('andor', 'AND'); $queries = array(); $query = Request::getString('query', ''); $start = Request::getInt('start', '0'); $helper = $xoops->getModuleHelper('alumni'); $module_id = $helper->getModule()->getVar('mid'); $listingHandler = $helper->getHandler('listing'); $groups = $xoops->getUserGroups(); $alumni_ids = $xoops->getHandlerGroupperm()->getItemIds('alumni_view', $groups, $module_id); $all_ids = implode(', ', $alumni_ids); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('valid', 1, '=')); // $criteria->add(new Criteria('date', time(), '<=')); $criteria->add(new Criteria('cid', '(' . $all_ids . ')', 'IN')); if ($userid != 0) { $criteria->add(new Criteria('usid', $userid, '=')); } if ($by_cat) { $criteria->add(new Criteria('cid', $by_cat, '=')); } $queries = array($query); $queries = implode('+', $queries); $count = 0; $i = 0; $criteria->add(new Criteria('name', '%' . $queries . '%', 'LIKE'), 'AND'); $criteria->add(new Criteria('mname', '%' . $queries . '%', 'LIKE'), 'OR'); $criteria->add(new Criteria('lname', '%' . $queries . '%', 'LIKE'), 'OR'); $criteria->add(new Criteria('school', '%' . $queries . '%', 'LIKE'), 'OR'); $criteria->add(new Criteria('year', '%' . $queries . '%', 'LIKE'), 'OR'); $criteria->setLimit($limit); $criteria->setSort('date'); $criteria->setOrder('DESC'); $criteria->setStart($start); $numrows = $listingHandler->getCount(); $this_search = $listingHandler->getall($criteria); $ret = array(); $k = 0; foreach ($this_search as $obj) { $ret[$k]['image'] = 'images/cat/default.gif'; $ret[$k]['link'] = 'listing.php?lid=' . $obj->getVar('lid') . ''; $ret[$k]['title'] = $obj->getVar('name') . ' ' . $obj->getVar('mname') . ' ' . $obj->getVar('lname') . ' --- ' . $obj->getVar('school') . ' --- ' . $obj->getVar('year'); $ret[$k]['time'] = $obj->getVar('date'); $ret[$k]['uid'] = $obj->getVar('usid'); $k++; } return $ret; }
function getSavedVars($modname) { global $jieqiRight; $criteria = new CriteriaCompo(new Criteria('modname', $modname, '=')); $criteria->setSort('rid'); $criteria->setOrder('ASC'); $this->queryObjects($criteria); while ($v = $this->getObject()) { $jieqiRight[$modname][$v->getVar('rname', 'n')] = array('caption' => $v->getVar('rtitle'), 'honors' => unserialize($v->getVar('rhonors', 'n')), 'rescription' => $v->getVar('rdescription')); } }
function getSavedVars($modname) { global $jieqiPower; $criteria = new CriteriaCompo(new Criteria('modname', $modname, '=')); $criteria->setSort('pid'); $criteria->setOrder('ASC'); $this->queryObjects($criteria); while ($v = $this->getObject()) { $jieqiPower[$modname][$v->getVar('pname', 'n')] = array('caption' => $v->getVar('ptitle'), 'groups' => unserialize($v->getVar('pgroups', 'n')), 'description' => $v->getVar('pdescription')); } }
function pruneShouts($limit) { $criteria = new CriteriaCompo(); $criteria->setSort('id'); $criteria->setOrder('DESC'); $criteria->setStart(0); $criteria->setLimit($limit); $objs = $this->getList($criteria, true); unset($criteria); $criteria = new Criteria('id', '(' . implode(',', array_keys($objs)) . ')', 'NOT IN'); return $this->deleteAll($criteria); }
/** * Export des données * @return boolean Vrai si l'export a réussi sinon faux */ function export() { $file = $this->folder . DIRECTORY_SEPARATOR . $this->filename; $fp = fopen($file, 'w'); if (!$fp) { $this->success = false; return false; } // Création de l'entête du fichier $list = $entete1 = $entete2 = array(); $s = $this->separator; $cmd = new oledrion_commands(); foreach ($cmd->getVars() as $fieldName => $properties) { $entete1[] = $fieldName; } // Ajout des infos de caddy $cart = new oledrion_caddy(); foreach ($cart->getVars() as $fieldName => $properties) { $entete2[] = $fieldName; } $list[] = array_merge($entete1, $entete2); // make item array $criteria = new CriteriaCompo(); $criteria->add(new Criteria('cmd_id', 0, '<>')); $criteria->add(new Criteria('cmd_state', $this->orderType, '=')); $criteria->setSort('cmd_date'); $criteria->setOrder('DESC'); $orders = $this->handlers->h_oledrion_commands->getObjects($criteria); foreach ($orders as $order) { $carts = array(); $carts = $this->handlers->h_oledrion_caddy->getObjects(new Criteria('caddy_cmd_id', $order->getVar('cmd_id'), '=')); $ligne = array(); foreach ($carts as $cart) { $ligne = array(); foreach ($entete1 as $commandField) { $ligne[] = $order->getVar($commandField); } foreach ($entete2 as $cartField) { $ligne[] = $cart->getVar($cartField); } // Add to main array $list[] = $ligne; } } // import information on csv file foreach ($list as $fields) { fputcsv($fp, $fields); } fclose($fp); $this->success = true; return true; }