/**
* 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;
}
/**
* @得到列表
* @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 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 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');
}
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 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);
}
public function getAllPid(oledrion_parameters $parameters)
{
$parameters = $parameters->extend(new oledrion_parameters(array('start' => 0, 'limit' => 0, 'sort' => 'location_id', 'order' => 'ASC')));
$critere = new CriteriaCompo();
$critere->add(new Criteria('location_type', 'parent'));
$critere->setLimit($parameters['limit']);
$critere->setStart($parameters['start']);
$critere->setSort($parameters['sort']);
$critere->setOrder($parameters['order']);
$pid = array();
$pid = $this->getObjects($critere);
return $pid;
}
function billboard_slides_show()
{
include_once ICMS_ROOT_PATH . '/modules/billboard/include/common.php';
$billboard_slide_handler = icms_getModuleHandler('slide', 'billboard');
$billboard_config = icms_getModuleConfig('billboard');
$criteria = new CriteriaCompo();
$criteria->setStart(0);
$criteria->setLimit(10);
$criteria->setSort('slide_order');
$criteria->setOrder('ASC');
$block = array();
$block['slides'] = $billboard_slide_handler->getObjects($criteria, true, false);
$block['config'] = $billboard_config;
return $block;
}
function user_index($start = 0)
{
global $xoopsTpl, $xoopsUser, $xoopsConfig, $limit;
$myts =& MyTextSanitizer::getInstance();
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
$this_handler =& xoops_getModuleHandler('user', 'subscribers');
$module_handler =& xoops_getHandler('module');
$query = isset($_POST['query']) ? $_POST['query'] : null;
$xoopsTpl->assign('query', $query);
$criteria = null;
if (!is_null($query)) {
$criteria = new Criteria('user_email', $myts->addSlashes($query) . '%', 'LIKE');
}
$count = $this_handler->getCount($criteria);
$xoopsTpl->assign('count', $count);
$mHandler =& xoops_getHandler('member');
$users_count = $mHandler->getUserCount(new Criteria('level', 0, '>'));
$xoopsTpl->assign('users_count', $users_count);
$xoopsTpl->assign('total_count', $users_count + $count);
$criteria = new CriteriaCompo($criteria);
$criteria->setSort('user_id');
$criteria->setOrder('DESC');
$criteria->setStart($start);
$criteria->setLimit($limit);
$objs = $this_handler->getObjects($criteria);
unset($criteria);
if ($count > 0) {
if ($count > $limit) {
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$nav = new XoopsPageNav($count, $limit, $start, 'start', 'op=list');
$xoopsTpl->assign('pag', '<div style="float:left; padding-top:2px;" align="center">' . $nav->renderNav() . '</div>');
} else {
$xoopsTpl->assign('pag', '');
}
} else {
$xoopsTpl->assign('pag', '');
}
include_once XOOPS_ROOT_PATH . '/class/xoopslists.php';
$countries = XoopsLists::getCountryList();
foreach ($objs as $obj) {
$objArray = $obj->toArray();
$objArray['user_country'] = $countries[$objArray['user_country']];
$xoopsTpl->append('objs', $objArray);
unset($objArray);
}
$xoopsTpl->assign('add_form', user_form());
return $xoopsTpl->fetch(XOOPS_ROOT_PATH . '/modules/subscribers/templates/static/subscribers_admin_user.html');
}
function getByItemId($module_id, $item_id, $order = null, $status = null, $limit = null, $start = 0)
{
$criteria = new CriteriaCompo(new Criteria('com_modid', $module_id));
$criteria->add(new Criteria('com_itemid', $item_id));
if (isset($status)) {
$criteria->add(new Criteria('com_status', $status));
}
if (isset($order)) {
$criteria->setOrder($order);
}
if (isset($limit)) {
$criteria->setLimit($limit);
$criteria->setStart($start);
}
return $this->getObjects($criteria);
}
function defacer_index($start = 0, $limit = 0)
{
global $xoopsTpl;
$defacer =& DefacerDefacer::getInstance();
$grouplist_handler =& xoops_gethandler('group');
$grouplist = $grouplist_handler->getObjects(null, true);
foreach (array_keys($grouplist) as $i) {
$groups[$i] = $grouplist[$i]->getVar('name');
}
$xoopsTpl->assign('groups', $groups);
$count = $defacer->getHandler('permission')->getCount();
$xoopsTpl->assign('count', $count);
$criteria = new CriteriaCompo();
$criteria->setStart($start);
$criteria->setLimit($limit);
$objs = $defacer->getHandler('permission')->getObjects($criteria);
if ($count > $limit) {
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$nav = new XoopsPageNav($count, $limit, $start, 'start', 'op=list');
$xoopsTpl->assign('pagenav', '<div style="float:left; padding-top:2px;" align="center">' . $nav->renderNav() . '</div>');
}
foreach ($objs as $obj) {
$item = $obj->getValues();
$page = $defacer->getHandler('page')->get($obj->getVar('permission_id'));
$item['module'] = $page->getVar('name');
$item['permission_title'] = $page->getVar('page_title');
$item['permission_url'] = $page->getVar('page_url');
$item['permission_status'] = $page->getVar('page_status');
if (substr($page->getVar('page_url'), -1) == '*') {
$item['permission_vurl'] = 0;
} else {
if ($page->getVar('page_moduleid') == 1) {
$item['permission_vurl'] = XOOPS_URL . '/' . $page->getVar('page_url');
} else {
$item['permission_vurl'] = XOOPS_URL . '/modules/' . $page->getVar('dirname') . '/' . $page->getVar('page_url');
}
}
$xoopsTpl->append('items', $item);
}
$xoopsTpl->assign('form', defacer_form());
return $xoopsTpl->fetch('db:defacer_admin_permission.html');
}
function setContent($isreturn = false)
{
global $jieqiTpl;
include_once JIEQI_ROOT_PATH . '/class/userlink.php';
$userlink_handler =& JieqiUserlinkHandler::getInstance('JieqiUserlinkHandler');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('userid', $this->blockvars['cacheid']));
if ($this->exevars['istop'] == 1) {
$criteria->add(new Criteria('toptime', 0, '>'));
} elseif ($this->exevars['istop'] == 2) {
$criteria->add(new Criteria('toptime', 0));
}
$criteria->setSort($this->exevars['field']);
if ($this->exevars['asc'] == 1) {
$criteria->setOrder('ASC');
} else {
$criteria->setOrder('DESC');
}
$criteria->setLimit($this->exevars['listnum']);
$criteria->setStart(0);
$userlink_handler->queryObjects($criteria);
$linkrows = array();
$k = 0;
while ($v = $userlink_handler->getObject()) {
$linkrows[$k]['ulid'] = $v->getVar('ulid');
$linkrows[$k]['ultitle'] = $v->getVar('ultitle');
$linkrows[$k]['ulurl'] = $v->getVar('ulurl');
$linkrows[$k]['ulinfo'] = $v->getVar('ulinfo');
$linkrows[$k]['userid'] = $v->getVar('userid');
$linkrows[$k]['username'] = $v->getVar('username');
$linkrows[$k]['score'] = $v->getVar('score');
$linkrows[$k]['weight'] = $v->getVar('weight');
$linkrows[$k]['toptime'] = $v->getVar('toptime');
$linkrows[$k]['addtime'] = $v->getVar('addtime');
$linkrows[$k]['allvisit'] = $v->getVar('allvisit');
$k++;
}
$jieqiTpl->assign_by_ref('linkrows', $linkrows);
$jieqiTpl->assign('ownerid', $this->blockvars['cacheid']);
$jieqiTpl->assign('url_more', JIEQI_URL . '/userlink.php?uid=' . $this->blockvars['cacheid']);
}
function waiting_index($start = 0)
{
global $xoopsTpl, $xoopsUser, $xoopsConfig, $limit;
include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
include_once XOOPS_ROOT_PATH . '/modules/subscribers/include/functions.php';
subscribers_sendEmails();
$this_handler =& xoops_getModuleHandler('waiting', 'subscribers');
$count = $this_handler->getCount();
$xoopsTpl->assign('count', $count);
$criteria = new CriteriaCompo();
$criteria->setSort('wt_priority DESC, wt_created');
$criteria->setOrder('ASC');
$criteria->setStart($start);
$criteria->setLimit($limit);
$objs = $this_handler->getObjects($criteria);
if ($count > 0) {
if ($count > $limit) {
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$nav = new XoopsPageNav($count, $limit, $start, 'start', 'op=list');
$xoopsTpl->assign('pag', '<div style="float:left; padding-top:2px;" align="center">' . $nav->renderNav() . '</div>');
} else {
$xoopsTpl->assign('pag', '');
}
} else {
$xoopsTpl->assign('pag', '');
}
include_once XOOPS_ROOT_PATH . '/class/xoopslists.php';
$countries = XoopsLists::getCountryList();
foreach ($objs as $obj) {
$objArray = $obj->toArray();
$objArray['wt_created'] = formatTimestamp($objArray['wt_created']);
$xoopsTpl->append('objs', $objArray);
unset($objArray);
}
return $xoopsTpl->fetch(XOOPS_ROOT_PATH . '/modules/subscribers/templates/static/subscribers_admin_waiting.html');
}
public function countPage($start = 0, $limit = 0, $sort = 'content_weight ASC, content_title', $order = 'ASC')
{
$criteria = new CriteriaCompo();
$criteria->setSort($sort);
$criteria->setOrder($order);
$criteria->setStart($start);
$criteria->setLimit($limit);
return parent::getCount($criteria);
}
/**
* @得到列表
* @method:
* @license http://www.blags.org/
* @created :2010年05月23日 14时59分
* @copyright 1997-2010 The Martin Group
* @author Martin <*****@*****.**>
* @param int $limit
* @param int $start
* @param string $sort
* @param string $order
* @param bool $id_as_key
* @return array
*/
public function &getRooms($limit = 0, $start = 0, $sort = 'room_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);
}
$pagenumrows = 1000;
include_once JIEQI_ROOT_PATH . '/admin/header.php';
$cardrows = array();
$totalrows = 0;
$_REQUEST['keyword'] = trim($_REQUEST['keyword']);
if (!empty($_REQUEST['keyword'])) {
include_once $jieqiModules['pay']['path'] . '/class/paycard.php';
$paycard_handler =& JieqiPaycardHandler::getInstance('JieqiPaycardHandler');
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('batchno', $_REQUEST['keyword']));
if ($_REQUEST['paytype'] == 1) {
$criteria->add(new Criteria('ispay', 1));
} elseif ($_REQUEST['paytype'] == 2) {
$criteria->add(new Criteria('ispay', 0));
}
$criteria->setStart(($_REQUEST['page'] - 1) * $pagenumrows);
$criteria->setLimit($pagenumrows);
$paycard_handler->queryObjects($criteria);
$k = 0;
while ($v = $paycard_handler->getObject()) {
$cardrows[$k]['order'] = ($_REQUEST['page'] - 1) * $pagenumrows + $k + 1;
$cardrows[$k]['batchno'] = $v->getVar('batchno');
$cardrows[$k]['cardno'] = $v->getVar('cardno');
$cardrows[$k]['cardpass'] = $v->getVar('cardpass');
$cardrows[$k]['cardtype'] = $v->getVar('cardtype');
$cardrows[$k]['payemoney'] = $v->getVar('payemoney');
$cardrows[$k]['ispay'] = $v->getVar('ispay');
if ($v->getVar('paytime') > 0) {
$cardrows[$k]['paytime'] = date('Y-m-d H:i:s', $v->getVar('paytime'));
} else {
$cardrows[$k]['paytime'] = '';
/**
* retrieve all files
*
* @param int $itemid
* @param int $status
* @param int $limit
* @param int $start
* @param string $sort
* @param string $order
* @param array $category
*
* @return array array of {@link PublisherFile} objects
*/
public function &getAllFiles($itemid = 0, $status = -1, $limit = 0, $start = 0, $sort = 'datesub', $order = 'DESC', $category = array())
{
$this->table_link = $this->db->prefix('publisher_items');
$this->field_object = 'itemid';
$this->field_link = 'itemid';
$hasStatusCriteria = false;
$criteriaStatus = new CriteriaCompo();
if (is_array($status)) {
$hasStatusCriteria = true;
foreach ($status as $v) {
$criteriaStatus->add(new Criteria('o.status', $v), 'OR');
}
} elseif ($status != -1) {
$hasStatusCriteria = true;
$criteriaStatus->add(new Criteria('o.status', $status), 'OR');
}
$hasCategoryCriteria = false;
$criteriaCategory = new CriteriaCompo();
$category = (array) $category;
if (count($category) > 0 && $category[0] != 0) {
$hasCategoryCriteria = true;
foreach ($category as $cat) {
$criteriaCategory->add(new Criteria('l.categoryid', $cat), 'OR');
}
}
$criteriaItemid = new Criteria('o.itemid', $itemid);
$criteria = new CriteriaCompo();
if ($itemid != 0) {
$criteria->add($criteriaItemid);
}
if ($hasStatusCriteria) {
$criteria->add($criteriaStatus);
}
if ($hasCategoryCriteria) {
$criteria->add($criteriaCategory);
}
$criteria->setSort($sort);
$criteria->setOrder($order);
$criteria->setLimit($limit);
$criteria->setStart($start);
$files = $this->getByLink($criteria, array('o.*'), true);
return $files;
}
$crit_to = new CriteriaCompo(new Criteria('to_delete', 0));
$crit_to->add(new Criteria('to_save', 1));
$crit_to->add(new Criteria('to_userid', $GLOBALS['xoopsUser']->getVar('uid')));
$crit_from = new CriteriaCompo(new Criteria('from_delete', 0));
$crit_from->add(new Criteria('from_save', 1));
$crit_from->add(new Criteria('from_userid', $GLOBALS['xoopsUser']->getVar('uid')));
$criteria = new CriteriaCompo($crit_to);
$criteria->add($crit_from, "OR");
} else {
$criteria = new CriteriaCompo(new Criteria('to_delete', 0));
$criteria->add(new Criteria('to_userid', $GLOBALS['xoopsUser']->getVar('uid')));
$criteria->add(new Criteria('to_save', 0));
}
}
$criteria->setLimit(1);
$criteria->setStart($start);
$criteria->setSort('msg_time');
$criteria->setOrder("DESC");
list($pm) = $pm_handler->getObjects($criteria);
}
include_once $GLOBALS['xoops']->path('class/xoopsformloader.php');
$pmform = new XoopsForm('', 'pmform', 'readpmsg.php', 'post', true);
if (is_object($pm) && !empty($pm)) {
if ($pm->getVar('from_userid') != $GLOBALS['xoopsUser']->getVar('uid')) {
$reply_button = new XoopsFormButton('', 'send', _PM_REPLY);
$reply_button->setExtra("onclick='javascript:openWithSelfMain(\"" . XOOPS_URL . "/modules/pm/pmlite.php?reply=1&msg_id=" . $pm->getVar("msg_id") . "\", \"pmlite\", 565,500);'");
$pmform->addElement($reply_button);
}
$pmform->addElement(new XoopsFormButton('', 'delete_message', _PM_DELETE, 'submit'));
$pmform->addElement(new XoopsFormButton('', 'move_message', $_REQUEST['op'] == 'save' ? _PM_UNSAVE : _PM_TOSAVE, 'submit'));
$pmform->addElement(new XoopsFormButton('', 'email_message', _PM_EMAIL, 'submit'));
/**
* @param array $queryarray
* @param string $andor
* @param int $limit
* @param int $offset
* @param int $userid
* @param array $categories
* @param int $sortby
* @param string $searchin
* @param string $extra
*
* @return array
*/
public function getItemsFromSearch($queryarray = array(), $andor = 'AND', $limit = 0, $offset = 0, $userid = 0, $categories = array(), $sortby = 0, $searchin = "", $extra = "")
{
global $xoopsUser, $publisher_isAdmin;
$ret = array();
$gperm_handler =& xoops_gethandler('groupperm');
$groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
$searchin = empty($searchin) ? array("title", "body", "summary") : (is_array($searchin) ? $searchin : array($searchin));
if (in_array("all", $searchin) || count($searchin) == 0) {
$searchin = array("title", "subtitle", "body", "summary", "meta_keywords");
}
if (is_array($userid) && count($userid) > 0) {
$userid = array_map("intval", $userid);
$criteriaUser = new CriteriaCompo();
$criteriaUser->add(new Criteria('uid', '(' . implode(',', $userid) . ')', 'IN'), 'OR');
} elseif (is_numeric($userid) && $userid > 0) {
$criteriaUser = new CriteriaCompo();
$criteriaUser->add(new Criteria('uid', $userid), 'OR');
}
$count = count($queryarray);
if (is_array($queryarray) && $count > 0) {
$criteriaKeywords = new CriteriaCompo();
for ($i = 0; $i < count($queryarray); $i++) {
$criteriaKeyword = new CriteriaCompo();
if (in_array('title', $searchin)) {
$criteriaKeyword->add(new Criteria('title', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
}
if (in_array('subtitle', $searchin)) {
$criteriaKeyword->add(new Criteria('subtitle', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
}
if (in_array('body', $searchin)) {
$criteriaKeyword->add(new Criteria('body', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
}
if (in_array('summary', $searchin)) {
$criteriaKeyword->add(new Criteria('summary', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
}
if (in_array('meta_keywords', $searchin)) {
$criteriaKeyword->add(new Criteria('meta_keywords', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
}
$criteriaKeywords->add($criteriaKeyword, $andor);
unset($criteriaKeyword);
}
}
if (!$publisher_isAdmin && count($categories) > 0) {
$criteriaPermissions = new CriteriaCompo();
// Categories for which user has access
$categoriesGranted = $gperm_handler->getItemIds('category_read', $groups, $this->publisher->getModule()->getVar('mid'));
if (count($categories) > 0) {
$categoriesGranted = array_intersect($categoriesGranted, $categories);
}
if (count($categoriesGranted) == 0) {
return $ret;
}
$grantedCategories = new Criteria('categoryid', "(" . implode(',', $categoriesGranted) . ")", 'IN');
$criteriaPermissions->add($grantedCategories, 'AND');
} elseif (count($categories) > 0) {
$criteriaPermissions = new CriteriaCompo();
$grantedCategories = new Criteria('categoryid', "(" . implode(',', $categories) . ")", 'IN');
$criteriaPermissions->add($grantedCategories, 'AND');
}
$criteriaItemsStatus = new CriteriaCompo();
$criteriaItemsStatus->add(new Criteria('status', _PUBLISHER_STATUS_PUBLISHED));
$criteria = new CriteriaCompo();
if (!empty($criteriaUser)) {
$criteria->add($criteriaUser, 'AND');
}
if (!empty($criteriaKeywords)) {
$criteria->add($criteriaKeywords, 'AND');
}
if (!empty($criteriaPermissions)) {
$criteria->add($criteriaPermissions);
}
if (!empty($criteriaItemsStatus)) {
$criteria->add($criteriaItemsStatus, 'AND');
}
$criteria->setLimit($limit);
$criteria->setStart($offset);
if (empty($sortby)) {
$sortby = "datesub";
}
$criteria->setSort($sortby);
$order = 'ASC';
if ($sortby == "datesub") {
$order = 'DESC';
}
$criteria->setOrder($order);
$ret = $this->getObjects($criteria);
return $ret;
}
$criteria = new CriteriaCompo();
if (!empty($_REQUEST['group'])) {
$criteria->add(new Criteria('groupid', $_REQUEST['group']));
$criteria->setSort('uid');
$criteria->setOrder('DESC');
} elseif (!empty($_REQUEST['initial'])) {
$criteria->add(new Criteria('initial', strtoupper($_REQUEST['initial']), '='));
$criteria->setSort('uname');
$criteria->setOrder('ASC');
}
if (isset($_REQUEST['isvip']) && is_numeric($_REQUEST['isvip'])) {
$_REQUEST['isvip'] = intval($_REQUEST['isvip']);
$criteria->add(new Criteria('isvip', $_REQUEST['isvip']));
}
$criteria->setLimit($jieqiConfigs['system']['userpnum']);
$criteria->setStart(($_REQUEST['page'] - 1) * $jieqiConfigs['system']['userpnum']);
$users_handler->queryObjects($criteria);
$userrows = array();
$i = 0;
while ($v = $users_handler->getObject()) {
$userrows[$i]['uid'] = $v->getVar('uid');
$userrows[$i]['uname'] = $v->getVar('uname');
$userrows[$i]['name'] = $v->getVar('name');
if (strlen($userrows[$i]['name']) == 0) {
$userrows[$i]['name'] = $userrows[$i]['uname'];
}
$userrows[$i]['qq'] = $v->getVar('qq');
$userrows[$i]['icq'] = $v->getVar('icq');
$userrows[$i]['man'] = $v->getVar('man');
$userrows[$i]['email'] = $v->getVar('email');
$userrows[$i]['viewemail'] = $v->getVar('viewemail');
function getItems($id = null, $start = 0, $limit = 0, $status = MYINVITER_STATUS_WAITING)
{
if ($id != null) {
$id = new Criteria('id', $id);
}
$criteria = new CriteriaCompo($id);
$criteria->add(new Criteria('status', $status));
$criteria->setSort('date');
$criteria->setOrder('DESC');
$criteria->setLimit($limit);
$criteria->setStart($start);
$ret = $this->getObjects($criteria);
return $ret;
}
function displayUsers()
{
global $xoopsDB, $xoopsConfig, $xoopsModule;
$userstart = isset($_GET['userstart']) ? intval($_GET['userstart']) : 0;
xoops_cp_header();
$member_handler =& xoops_gethandler('member');
$usercount = $member_handler->getUserCount();
$nav = new XoopsPageNav($usercount, 200, $userstart, "userstart", "fct=users");
$editform = new XoopsThemeForm(_AM_EDEUSER, "edituser", "admin.php", 'GET');
$user_select = new XoopsFormSelect('', "uid");
$criteria = new CriteriaCompo();
$criteria->setSort('uname');
$criteria->setOrder('ASC');
$criteria->setLimit(200);
$criteria->setStart($userstart);
$user_select->addOptionArray($member_handler->getUserList($criteria));
$user_select_tray = new XoopsFormElementTray(_AM_NICKNAME, "<br />");
$user_select_tray->addElement($user_select);
$user_select_nav = new XoopsFormLabel('', $nav->renderNav(4));
$user_select_tray->addElement($user_select_nav);
$op_select = new XoopsFormSelect("", "op");
$op_select->addOptionArray(array("modifyUser" => _AM_MODIFYUSER, "delUser" => _AM_DELUSER));
$submit_button = new XoopsFormButton("", "submit", _AM_GO, "submit");
$fct_hidden = new XoopsFormHidden("fct", "users");
$editform->addElement($user_select_tray);
$editform->addElement($op_select);
$editform->addElement($submit_button);
$editform->addElement($fct_hidden);
$editform->display();
echo "<br />\n";
$uid_value = "";
$uname_value = "";
$name_value = "";
$email_value = "";
$email_cbox_value = 0;
$url_value = "";
// $avatar_value = "blank.gif";
// $theme_value = $xoopsConfig['default_theme'];
$timezone_value = $xoopsConfig['default_TZ'];
$icq_value = "";
$aim_value = "";
$yim_value = "";
$msnm_value = "";
$location_value = "";
$occ_value = "";
$interest_value = "";
$sig_value = "";
$sig_cbox_value = 0;
$umode_value = $xoopsConfig['com_mode'];
$uorder_value = $xoopsConfig['com_order'];
// RMV-NOTIFY
include_once XOOPS_ROOT_PATH . '/include/notification_constants.php';
$notify_method_value = XOOPS_NOTIFICATION_METHOD_PM;
$notify_mode_value = XOOPS_NOTIFICATION_MODE_SENDALWAYS;
$bio_value = "";
$rank_value = 0;
$mailok_value = 0;
$op_value = "addUser";
$form_title = _AM_ADDUSER;
$form_isedit = false;
$groups = array(XOOPS_GROUP_USERS);
include XOOPS_ROOT_PATH . "/modules/system/admin/users/userform.php";
xoops_cp_footer();
}
/**
* @param int $limit
* @param int $start
* @param int $parentid
* @param string $sort
* @param string $order
* @param bool $idAsKey
*
* @return array
*/
public function &getCategories($limit = 0, $start = 0, $parentid = 0, $sort = 'weight', $order = 'ASC', $idAsKey = true)
{
// global $publisherIsAdmin;
$criteria = new CriteriaCompo();
$criteria->setSort($sort);
$criteria->setOrder($order);
if ($parentid != -1) {
$criteria->add(new Criteria('parentid', $parentid));
}
if (!$GLOBALS['publisherIsAdmin']) {
$categoriesGranted = $this->publisher->getHandler('permission')->getGrantedItems('category_read');
if (count($categoriesGranted) > 0) {
$criteria->add(new Criteria('categoryid', '(' . implode(',', $categoriesGranted) . ')', 'IN'));
} else {
return array();
}
if (is_object($GLOBALS['xoopsUser'])) {
$criteria->add(new Criteria('moderator', $GLOBALS['xoopsUser']->getVar('uid')), 'OR');
}
}
$criteria->setStart($start);
$criteria->setLimit($limit);
$ret =& $this->getObjects($criteria, $idAsKey);
return $ret;
}
$stoptime = JIEQI_NOW_TIME;
}
if (!is_numeric($stoptime)) {
$stoptime = mktime((int) substr($stoptime, 11, 2), (int) substr($stoptime, 14, 2), (int) substr($stoptime, 17, 2), (int) substr($stoptime, 5, 2), (int) substr($stoptime, 8, 2), (int) substr($stoptime, 0, 5));
}
include_once $jieqiModules['article']['path'] . '/class/article.php';
$article_handler =& JieqiArticleHandler::getInstance('JieqiArticleHandler');
if (empty($startlimit)) {
$startlimit = 0;
}
$criteria = new CriteriaCompo(new Criteria('lastupdate', $starttime, '>='));
$criteria->add(new Criteria('lastupdate', $stoptime, '<='));
$criteria->add(new Criteria('display', 2, '!='));
$criteria->setSort('lastupdate');
$criteria->setOrder('ASC');
$criteria->setStart($startlimit);
$criteria->setLimit(1);
$article_handler->queryObjects($criteria);
$article = $article_handler->getObject();
if (is_object($article)) {
$articlename = $article->getVar('articlename');
include_once $jieqiModules['article']['path'] . '/include/repack.php';
$ptypes = array();
foreach ($_REQUEST['flagary'] as $v) {
$ptypes[$v] = 1;
}
echo ' ';
echo sprintf($jieqiLang['article']['batch_repack_doing'], $articlename, date('Y-m-d H:i:s', $starttime), date('Y-m-d H:i:s', $stoptime), date('Y-m-d H:i:s', $article->getVar('lastupdate')), $article->getVar('articleid'));
ob_flush();
flush();
article_repack($article->getVar('articleid'), $ptypes, 1);
public static function manage()
{
$publisher =& PublisherPublisher::getInstance();
global $imagearray, $start, $limit, $aSortBy, $aOrderBy, $aLimitBy, $aSearchBy;
if (XoopsRequest::getString('deleteMimes', '', 'POST')) {
$aMimes = XoopsRequest::getArray('mimes', array(), 'POST');
$crit = new Criteria('mime_id', '(' . implode($aMimes, ',') . ')', 'IN');
if ($publisher->getHandler('mimetype')->deleteAll($crit)) {
header('Location: ' . PUBLISHER_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}");
} else {
redirect_header(PUBLISHER_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}", 3, _AM_PUBLISHER_MESSAGE_DELETE_MIME_ERROR);
}
}
if (XoopsRequest::getString('add_mime', '', 'POST')) {
// header("Location: " . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=add&start=$start&limit=$limit");
redirect_header(PUBLISHER_ADMIN_URL . "/mimetypes.php?op=add&start={$start}&limit={$limit}", 3, _AM_PUBLISHER_MIME_CREATEF);
// exit();
}
if (XoopsRequest::getString('mime_search', '', 'POST')) {
// header("Location: " . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=search");
redirect_header(PUBLISHER_ADMIN_URL . '/mimetypes.php?op=search', 3, _AM_PUBLISHER_MIME_SEARCH);
// exit();
}
publisherCpHeader();
////publisher_adminMenu(4, _AM_PUBLISHER_MIMETYPES);
publisherOpenCollapsableBar('mimemanagetable', 'mimemanageicon', _AM_PUBLISHER_MIME_MANAGE_TITLE, _AM_PUBLISHER_MIME_INFOTEXT);
$crit = new CriteriaCompo();
$order = XoopsRequest::getString('order', 'ASC', 'POST');
$sort = XoopsRequest::getString('sort', 'mime_ext', 'POST');
$crit->setOrder($order);
$crit->setStart($start);
$crit->setLimit($limit);
$crit->setSort($sort);
$mimetypes =& $publisher->getHandler('mimetype')->getObjects($crit);
// Retrieve a list of all mimetypes
$mimeCount =& $publisher->getHandler('mimetype')->getCount();
$nav = new XoopsPageNav($mimeCount, $limit, $start, 'start', "op=manage&limit={$limit}");
echo "<table width='100%' cellspacing='1' class='outer'>";
echo "<tr><td colspan='6' align='right'>";
echo "<form action='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=search' style='margin:0; padding:0;' method='post'>";
echo '<table>';
echo '<tr>';
echo "<td align='right'>" . _AM_PUBLISHER_TEXT_SEARCH_BY . '</td>';
echo "<td align='left'><select name='search_by'>";
foreach ($aSearchBy as $value => $text) {
$sort == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
unset($value, $text);
echo '</select></td>';
echo "<td align='right'>" . _AM_PUBLISHER_TEXT_SEARCH_TEXT . '</td>';
echo "<td align='left'><input type='text' name='search_text' id='search_text' value='' /></td>";
echo "<td><input type='submit' name='mime_search' id='mime_search' value='" . _AM_PUBLISHER_BUTTON_SEARCH . "' /></td>";
echo '</tr></table></form></td></tr>';
echo "<tr><td colspan='6'>";
echo "<form action='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=manage' style='margin:0; padding:0;' method='post'>";
echo "<table width='100%'>";
echo "<tr><td align='right'>" . _AM_PUBLISHER_TEXT_SORT_BY . "\n <select name='sort'>";
foreach ($aSortBy as $value => $text) {
$sort == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
unset($value, $text);
echo '</select>
' . _AM_PUBLISHER_TEXT_ORDER_BY . "\n <select name='order'>";
foreach ($aOrderBy as $value => $text) {
$order == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
unset($value, $text);
echo '</select>
' . _AM_PUBLISHER_TEXT_NUMBER_PER_PAGE . "\n <select name='limit'>";
foreach ($aLimitBy as $value => $text) {
$limit == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
unset($value, $text);
echo "</select>\n <input type='submit' name='mime_sort' id='mime_sort' value='" . _AM_PUBLISHER_BUTTON_SUBMIT . "' />\n </td>\n </tr>";
echo '</table>';
echo '</td></tr>';
echo "<tr><th colspan='6'>" . _AM_PUBLISHER_MIME_MANAGE_TITLE . '</th></tr>';
echo "<tr class='head'>\n <td>" . _AM_PUBLISHER_MIME_ID . '</td>
<td>' . _AM_PUBLISHER_MIME_NAME . "</td>\n <td align='center'>" . _AM_PUBLISHER_MIME_EXT . "</td>\n <td align='center'>" . _AM_PUBLISHER_MIME_ADMIN . "</td>\n <td align='center'>" . _AM_PUBLISHER_MIME_USER . "</td>\n <td align='center'>" . _AM_PUBLISHER_MINDEX_ACTION . '</td>
</tr>';
foreach ($mimetypes as $mime) {
echo "<tr class='even'>\n <td><input type='checkbox' name='mimes[]' value='" . $mime->getVar('mime_id') . "' />" . $mime->getVar('mime_id') . '</td>
<td>' . $mime->getVar('mime_name') . "</td>\n <td align='center'>" . $mime->getVar('mime_ext') . "</td>\n <td align='center'>\n <a href='" . PUBLISHER_ADMIN_URL . '/mimetypes.php?op=updateMimeValue&id=' . $mime->getVar('mime_id') . '&mime_admin=' . $mime->getVar('mime_admin') . '&limit=' . $limit . '&start=' . $start . "'>\n " . ($mime->getVar('mime_admin') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td align='center'>\n <a href='" . PUBLISHER_ADMIN_URL . '/mimetypes.php?op=updateMimeValue&id=' . $mime->getVar('mime_id') . '&mime_user='******'mime_user') . '&limit=' . $limit . '&start=' . $start . "'>\n " . ($mime->getVar('mime_user') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td align='center'>\n <a href='" . PUBLISHER_ADMIN_URL . '/mimetypes.php?op=edit&id=' . $mime->getVar('mime_id') . '&limit=' . $limit . '&start=' . $start . "'>" . $imagearray['editimg'] . "</a>\n <a href='" . PUBLISHER_ADMIN_URL . '/mimetypes.php?op=delete&id=' . $mime->getVar('mime_id') . '&limit=' . $limit . '&start=' . $start . "'>" . $imagearray['deleteimg'] . '</a>
</td>
</tr>';
}
// unset($mime);
echo "<tr class='foot'>\n <td colspan='6' valign='top'>\n <a href='http://www.filext.com' style='float: right;' target='_blank'>" . _AM_PUBLISHER_MIME_FINDMIMETYPE . "</a>\n <input type='checkbox' name='checkAllMimes' value='0' onclick='selectAll(this.form,\"mimes[]\",this.checked);' />\n <input type='submit' name='deleteMimes' id='deleteMimes' value='" . _AM_PUBLISHER_BUTTON_DELETE . "' />\n <input type='submit' name='add_mime' id='add_mime' value='" . _AM_PUBLISHER_MIME_CREATEF . "' class='formButton' />\n </td>\n </tr>";
echo '</table>';
echo "<div id='staff_nav'>" . $nav->renderNav() . '</div><br/>';
publisherCloseCollapsableBar('mimemanagetable', 'mimemanageicon');
// xoops_cp_footer();
include_once __DIR__ . '/admin_footer.php';
}
/**
* Renvoie la liste de toutes les TVA du module
*
* @param integer $start Position de départ
* @param integer $limit Nombre total d'enregistrements à renvoyer
* @param string $order Champ sur lequel faire le tri
* @param string $order Ordre du tri
* @param boolean $idaskey Indique si le tableau renvoyé doit avoir pour clé l'identifiant unique de l'enregistrement
* @return array tableau d'objets de type TVA
*/
public function getCountryVats($country)
{
$parameters = new oledrion_parameters(array('start' => 0, 'limit' => 0, 'sort' => 'vat_id', 'order' => 'ASC', 'idaskey' => true));
$critere = new CriteriaCompo();
if (!empty($country)) {
$critere->add(new Criteria('vat_country', $country, 'LIKE'));
}
$critere->setLimit($parameters['limit']);
$critere->setStart($parameters['start']);
$critere->setSort($parameters['sort']);
$critere->setOrder($parameters['order']);
$vats = array();
$vats = $this->getObjects($critere, $parameters['idaskey']);
return $vats;
}
oledrion_adminMenu(0);
oledrion_utils::htitle(_MI_OLEDRION_ADMENU10, 4);
$itemsCount = 5;
// Nombre d'éléments à afficher
if ($h_oledrion_products->getCount() > 0) {
echo "<table border='0' width='100%' cellpadding='2' cellspacing='2'>";
echo "<tr>\n";
// Dernières commandes ************************************************
echo "<td valign='top' width='50%' align='center'><b>" . _AM_OLEDRION_LAST_ORDERS . "</b>";
$tblTmp = array();
$criteria = new CriteriaCompo();
$criteria->add(new Criteria('cmd_id', 0, '<>'));
$criteria->setSort('cmd_date');
$criteria->setOrder('DESC');
$criteria->setLimit($itemsCount);
$criteria->setStart(0);
$tblTmp = $h_oledrion_commands->getObjects($criteria);
echo "<table border='0' cellpadding='2' cellspacing='2' width='100%'>";
echo "<tr><th align='center'>" . _AM_OLEDRION_DATE . "</th><th align='center'>" . _AM_OLEDRION_ID . "</th><th align='center'>" . _OLEDRION_TOTAL . "</th></tr>\n";
foreach ($tblTmp as $item) {
$date = formatTimestamp(strtotime($item->getVar('cmd_date')), 's');
echo "<tr><td align='center'>" . $date . "</td><td align='center'>" . $item->getVar('cmd_id') . "</td><td align='right'>" . $oledrion_Currency->amountForDisplay($item->getVar('cmd_total')) . "</td></tr>";
}
echo "</table>";
// Stocks bas *********************************************************
echo "</td><td valign='top' width='50%' align='center'><b>" . _MI_OLEDRION_ADMENU9 . "</b>";
$tblTmp = array();
$tblTmp = $h_oledrion_products->getLowStocks(0, $itemsCount);
echo "<table border='0' cellpadding='2' cellspacing='2' width='100%'>";
echo "<tr><th align='center'>" . _OLEDRION_TITLE . "</th><th align='center'>" . _OLEDRION_STOCK_QUANTITY . "</th></tr>\n";
foreach ($tblTmp as $item) {
}
if (!empty($_POST['mail_regd_min'])) {
$time = strtotime(trim($_POST['mail_regd_min']));
if ($time > 0) {
$criteria[] = "user_regdate > {$time}";
}
}
if (!empty($_POST['mail_regd_max'])) {
$time = strtotime(trim($_POST['mail_regd_max']));
if ($time > 0) {
$criteria[] = "user_regdate < {$time}";
}
}
if (!empty($criteria) || !empty($_POST['mail_to_group'])) {
$criteria_object = new CriteriaCompo();
$criteria_object->setStart(@$_POST['mail_start']);
$criteria_object->setLimit($limit);
foreach ($criteria as $c) {
list($field, $op, $value) = explode(' ', $c);
$crit = new Criteria($field, $value, $op);
$crit->prefix = 'u';
$criteria_object->add($crit, 'AND');
}
$member_handler = xoops_getHandler('member');
$groups = empty($_POST['mail_to_group']) ? array() : array_map('intval', $_POST['mail_to_group']);
$getusers = $member_handler->getUsersByGroupLink($groups, $criteria_object, true);
$count_criteria = $member_handler->getUserCountByGroupLink($groups, $criteria_object);
foreach ($getusers as $getuser) {
if (!in_array($getuser->getVar('uid'), $added_id)) {
$added[] = $getuser;
$added_id[] = $getuser->getVar('uid');
function &getCategoriesWithOpenQuestion($limit = 0, $start = 0, $parentid = 0, $sort = 'weight', $order = 'ASC')
{
include_once XOOPS_ROOT_PATH . '/modules/smartfaq/include/functions.php';
$criteria = new CriteriaCompo();
$criteria->setSort($sort);
$criteria->setOrder($order);
if ($parentid != -1) {
$criteria->add(new Criteria('c.parentid', $parentid));
}
if (!sf_userIsAdmin()) {
$smartPermHandler =& xoops_getmodulehandler('permission', 'smartfaq');
$categoriesGranted = $smartPermHandler->getPermissions('category');
$criteria->add(new Criteria('categoryid', "(" . implode(',', $categoriesGranted) . ")", 'IN'));
}
$criteria->add(new Criteria('f.status', _SF_STATUS_OPENED));
$criteria->setStart($start);
$criteria->setLimit($limit);
$ret = array();
$limit = $start = 0;
$sql = 'SELECT DISTINCT c.categoryid, c.parentid, c.name, c.description, c.total, c.weight, c.created FROM ' . $this->db->prefix('smartfaq_categories') . ' AS c INNER JOIN ' . $this->db->prefix('smartfaq_faq') . ' AS f ON c.categoryid = f.categoryid';
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
$sql .= ' ' . $criteria->renderWhere();
if ($criteria->getSort() != '') {
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
}
$limit = $criteria->getLimit();
$start = $criteria->getStart();
}
//echo "<br />" . $sql . "<br />";
$result = $this->db->query($sql, $limit, $start);
if (!$result) {
return $ret;
}
while ($myrow = $this->db->fetchArray($result)) {
$category = new sfCategory();
$category->assignVars($myrow);
$ret[] =& $category;
unset($category);
}
return $ret;
}
//页码
if (empty($_REQUEST['page']) || !is_numeric($_REQUEST['page'])) {
$_REQUEST['page'] = 1;
}
include_once $jieqiModules['obook']['path'] . '/class/osale.php';
$osale_handler =& JieqiOsaleHandler::getInstance('JieqiOsaleHandler');
$criteria = new CriteriaCompo(new Criteria('accountid', $_SESSION['jieqiUserId']));
if (!empty($_REQUEST['oid'])) {
$criteria->add(new Criteria('obookid', intval($_REQUEST['oid'])));
} elseif (!empty($_REQUEST['oname'])) {
$criteria->add(new Criteria('obookname', $_REQUEST['oname']));
}
$criteria->setSort('osaleid');
$criteria->setOrder('DESC');
$criteria->setLimit($jieqiConfigs['obook']['pagenum']);
$criteria->setStart(($_REQUEST['page'] - 1) * $jieqiConfigs['obook']['pagenum']);
$osale_handler->queryObjects($criteria);
$osalerows = array();
$k = 0;
while ($v = $osale_handler->getObject()) {
$osalerows[$k]['osaleid'] = $v->getVar('osaleid');
//销售序号
$osalerows[$k]['buytime'] = date(JIEQI_DATE_FORMAT, $v->getVar('buytime'));
//购买日期
$osalerows[$k]['osaleid'] = $v->getVar('osaleid');
$osalerows[$k]['accountid'] = $v->getVar('accountid');
$osalerows[$k]['account'] = $v->getVar('account');
$osalerows[$k]['obookid'] = $v->getVar('obookid');
$osalerows[$k]['ochapterid'] = $v->getVar('ochapterid');
$osalerows[$k]['obookname'] = $v->getVar('obookname');
$osalerows[$k]['chaptername'] = $v->getVar('chaptername');
