/**
* count user defined publications
*
* @access public
* @param int $uid user id
* @return array publication count by item type id
*/
function getCountPublications($uid)
{
$join = new XooNIpsJoinCriteria('xoonips_item_basic', 'item_id', 'item_id', 'INNER', 'ib');
$criteria = new Criteria('uid', $uid, '=', $this->db->prefix($this->__table_name));
$criteria->setGroupby('ib.item_type_id');
$res = $this->open($criteria, 'item_type_id, COUNT(DISTINCT ib.item_id)', false, $join);
$nums = array();
while ($obj =& $this->getNext($res)) {
$item_type_id = $obj->getExtraVar('item_type_id');
$count = $obj->getExtraVar('COUNT(DISTINCT ib.item_id)');
$nums[$item_type_id] = $count;
}
$this->close($res);
return $nums;
}
$criteria = new CriteriaCompo();
$count = $handler->getCount($criteria);
$start = isset($_REQUEST['start']) ? intval($_REQUEST['start']) : 0;
$limit = 20;
$criteria->setStart($start);
$criteria->setLimit($limit);
if (isset($sortby) && $sortby != "") {
$criteria->setSort($sortby);
$criteria->setOrder($order);
}
$objects =& $handler->getObjects($criteria, true, false);
unset($criteria);
if (count($objects) > 0) {
$xoopsTpl->assign('objects', $objects);
$criteria = new Criteria('newsletterid', "(" . implode(',', array_keys($objects)) . ")", "IN");
$criteria->setGroupby("newsletterid");
$subscriber_handler = xoops_getmodulehandler('subscriber');
$xoopsTpl->assign('receiver_counts', $subscriber_handler->getCount($criteria));
}
$smartOption['template_main'] = $typetemplate;
if ($count > $limit) {
include_once XOOPS_ROOT_PATH . "/class/pagenav.php";
$nav = new XoopsPageNav($count, $limit, $start, "start");
$xoopsTpl->assign("pagenav", $nav->renderNav(20));
}
/**
* Implementing the SmartObject Table
* Tobe continued...
*/
/*
include_once SMARTOBJECT_ROOT_PATH."class/smartobjecttable.php";
function _findDuplicateItemIds($item)
{
//Item A:title=A,B,C,C
//Item B:title=A,B,B,C
//Item C:title=A,B,C
//Item D:title=A,B,C,C
//
//Item A != Item B
//Item A != Item C
//Item A == Item D
//Item B != Item C
//Item B != Item D
//Item C != Item D
global $xoopsDB, $xoopsUser;
$basic =& $item->getVar('basic');
$title_handler =& xoonips_getormhandler('xoonips', 'title');
$titles = array();
foreach ($item->getVar('titles') as $title) {
if (array_key_exists($title->get('title'), $titles)) {
$titles[$title->get('title')]++;
} else {
$titles[$title->get('title')] = 1;
}
}
// title matching
// select item that has same number of each titles
//
$item_ids = array();
foreach ($titles as $title => $count) {
$criteria = new CriteriaCompo(new Criteria('title', $title));
$criteria->add(new Criteria('item_type_id', $basic->get('item_type_id')));
$criteria->add(new Criteria('uid', $xoopsUser->getVar('uid')));
if (count($item_ids) > 0) {
$criteria->add(new Criteria('tb.item_id', '(' . implode(',', $item_ids) . ')', 'IN'));
}
$criteria->setGroupby('tb.item_id,title having count(*)=' . $count);
$join = new XooNIpsJoinCriteria('xoonips_item_basic', 'item_id', 'item_id', 'LEFT', 'tb');
$results =& $title_handler->getObjects($criteria, false, '*, count(*)', null, $join);
$item_ids = array();
foreach ($results as $result) {
$item_ids[] = $result->get('item_id');
}
}
if (count($item_ids) == 0) {
// return only doi conflict item id
// if no conflict items of title matching
return $this->_findDoiConflictItemIds($item);
}
//
// select item that has same number of title
//
$criteria = new Criteria('item_id', '(' . implode(',', $item_ids) . ')', 'IN');
$criteria->setGroupby('item_id having count(*)=' . count($item->getVar('titles')));
$titles =& $title_handler->getObjects($criteria);
if (count($titles) == 0) {
return array();
}
// no conflict item
$item_ids = array();
foreach ($titles as $title) {
$item_ids[] = $title->get('item_id');
}
$ids = array_unique(array_merge($item_ids, $this->_findDoiConflictItemIds($item)));
return $ids;
}
$criteria->setSort(array('meta_key', 'meta_id'));
$postmetaObjects =& $postmetaHandler->getObjects($criteria);
$postmetaRows = array();
if ($postmetaObjects) {
$_style = "";
foreach ($postmetaObjects as $postmetaObject) {
$_style = 'class="odd"' == $_style ? 'class="even"' : 'class="odd"';
$postmetaRow =& $postmetaObject->getVarArray("e");
$postmetaRow['style'] = $_style;
$postmetaRows[] =& $postmetaRow;
}
}
$criteria = new Criteria(1, 1);
$criteria->setSort('meta_id');
$criteria->setOrder('DESC');
$criteria->setGroupby('meta_key');
$postmetaKeys = array();
$postmetakeyObjects =& $postmetaHandler->getObjects($criteria, false);
if ($postmetakeyObjects) {
foreach ($postmetakeyObjects as $postmetakeyObject) {
$postmetaKeys[] = $postmetakeyObject->getVar('meta_key');
}
}
$_wpTpl =& new WordPresTpl('wp-admin');
$_wpTpl->assign('user_ID', $user_ID);
$_wpTpl->assign('user_level', $user_level);
$_wpTpl->assign('post_ID', $post_ID);
$_wpTpl->assign('post_status', $post_status);
$_wpTpl->assign('post_password', $post_password);
$_wpTpl->assign('mode', $mode);
$_wpTpl->assign('edited_post_title', $edited_post_title);
