function wikiplugin_trackerlist($data, $params)
{
global $tiki_p_admin_trackers, $prefs, $tiki_p_view_trackers, $user, $page, $tiki_p_tracker_vote_ratings, $tiki_p_tracker_view_ratings, $tiki_p_export_tracker, $tiki_p_watch_trackers, $tiki_p_edit;
$userlib = TikiLib::lib('user');
$tikilib = TikiLib::lib('tiki');
$trklib = TikiLib::lib('trk');
$smarty = TikiLib::lib('smarty');
$notificationlib = TikiLib::lib('notification');
static $iTRACKERLIST = 0;
++$iTRACKERLIST;
$smarty->assign('iTRACKERLIST', $iTRACKERLIST);
$default = array('calendarfielddate' => '', 'wiki' => '', 'calendarviewmode' => 'month', 'calendarstickypopup' => 'n', 'calendarbeginmonth' => 'y', 'calendarviewnavbar' => 'y', 'calendartitle' => '', 'calendardelta' => '', 'force_compile' => 'n', 'editable' => array(), 'editableall' => 'n');
$params = array_merge($default, $params);
extract($params, EXTR_SKIP);
$skip_status_perm_check = false;
if (isset($force_separate_compile) && $force_separate_compile == 'y') {
$smarty->assign('force_separate_compile', 'y');
}
if ($prefs['feature_trackers'] != 'y' || !isset($trackerId) || !($tracker_info = $trklib->get_tracker($trackerId))) {
return $smarty->fetch("wiki-plugins/error_tracker.tpl");
} else {
global $auto_query_args;
$auto_query_args_local = array('trackerId', 'tr_initial', "tr_sort_mode{$iTRACKERLIST}", 'tr_user', 'filterfield', 'filtervalue', 'exactvalue', 'itemId', "tr_offset{$iTRACKERLIST}");
$auto_query_args = empty($auto_query_args) ? $auto_query_args_local : array_merge($auto_query_args, $auto_query_args_local);
$smarty->assign('listTrackerId', $trackerId);
$definition = Tracker_Definition::get($trackerId);
$tracker_info = $definition->getInformation();
if (!isset($sort)) {
$sort = 'n';
}
$perms = $tikilib->get_perm_object($trackerId, 'tracker', $tracker_info, false);
if ($perms['tiki_p_view_trackers'] != 'y' && !$user) {
return;
}
$userCreatorFieldId = $definition->getAuthorField();
$groupCreatorFieldId = $definition->getWriterGroupField();
if ($perms['tiki_p_view_trackers'] != 'y' && !$definition->isEnabled('writerCanModify') && !$definition->isEnabled('userCanSeeOwn') && empty($userCreatorFieldId) && empty($groupCreatorFieldId)) {
return;
}
$smarty->assign_by_ref('perms', $perms);
if (!empty($fields)) {
$limit = $fields;
} else {
$limit = '';
}
// Make sure limit is an array
if (!is_array($limit) && !empty($limit)) {
$limit = explode(':', $limit);
}
if (!empty($filterfield) && !empty($limit)) {
$limit = array_unique(array_merge($limit, $filterfield));
}
// for some reason if param popup is set but empty, the array contains 2 empty elements. We filter them out.
if (isset($popup)) {
$popup = array_filter($popup);
if (!empty($popup)) {
$limit = array_unique(array_merge($limit, $popup));
}
}
if (!empty($calendarfielddate)) {
$limit = array_unique(array_merge($limit, $calendarfielddate));
}
if (!empty($limit) && $trklib->test_field_type($limit, array('C'))) {
$limit = array();
}
$allfields = $trklib->list_tracker_fields($trackerId, 0, -1, 'position_asc', '', true, '', $trklib->flaten($limit));
if (!empty($fields)) {
$listfields = $fields;
//We must include the $calendarfielddate, even if they are not in the listfields
if (!empty($calendarfielddate)) {
foreach ($calendarfielddate as $f) {
if (!in_array($f, $listfields)) {
$listfields[] = $f;
}
}
}
if ($sort == 'y') {
$allfields = $trklib->sort_fields($allfields, $listfields);
}
} elseif (!empty($wiki) || !empty($tpl) || !empty($tplwiki)) {
if (!empty($wiki)) {
$listfields = $trklib->get_pretty_fieldIds($wiki, 'wiki', $prettyModifier, $trackerId);
} elseif (!empty($tplwiki)) {
$listfields = $trklib->get_pretty_fieldIds($tplwiki, 'wiki', $prettyModifier, $trackerId);
} else {
$listfields = $trklib->get_pretty_fieldIds($tpl, 'tpl', $prettyModifier, $trackerId);
}
} else {
$listfields = '';
}
if (!empty($compute) && !empty($listfields)) {
if (preg_match_all('/[0-9.]+/', $compute, $matches)) {
foreach ($matches[0] as $f) {
if (!in_array($f, $listfields)) {
$listfields[] = $f;
}
}
}
}
/*** tablesorter ***/
//note whether ajax is needed
$tsServer = isset($params['server']) && $params['server'] === 'y' ? true : false;
$tsOn = isset($sortable) && $sortable !== 'n' && Table_Check::isEnabled($tsServer);
$smarty->assign('tsOn', $tsOn);
//note whether this is the initial tablesorter ajax call or a subsequent ajax call
$tsAjax = Table_Check::isAjaxCall();
$smarty->assign('tsAjax', $tsAjax);
if ($tsAjax) {
// if status is enabled, need to adjust field index by -1 - need to check both - tracker config and plugin config
$adjustCol = isset($showstatus) && $showstatus == 'y' && $definition->isEnabled('showStatus') ? -1 : 0;
//convert tablesorter filter syntax to tiki syntax
if (!empty($_REQUEST['filter'])) {
$i = 0;
$tsfiltersArray = explode('|', $tsfilters);
foreach ($_REQUEST['filter'] as $col => $ajaxfilter) {
$fieldtype = $allfields['data'][$col + $adjustCol]['type'];
$id = $allfields['data'][$col + $adjustCol]['fieldId'];
//handle status filter
if ($adjustCol === -1 && $col === 0 && in_array($ajaxfilter, ['o', 'p', 'c'])) {
$status = $ajaxfilter;
/*
* handle date filter - these are always one filter, in the form of:
* from: >=1427389832000; to: <=1427389832000; both from and to: 1427389832000 - 1427880000000
* which is unix timestamp in milliseconds
*/
} elseif (strpos($tsfiltersArray[$col], 'type:date') !== false && in_array($fieldtype, ['f', 'j'])) {
$datefilter = explode(' - ', $ajaxfilter);
$filterfield[$i] = $id;
//a range (from and to filters) will have 2 items in the array
if (count($datefilter) == 2) {
$filterfield[$i + 1] = $id;
//use substr to leave off milliseconds since date is stored in seconds in the database
$exactvalue[$i] = 'greaterequal(@' . substr($datefilter[0], 0, 10) . ')';
$exactvalue[$i + 1] = 'lessequal(@' . substr($datefilter[1], 0, 10) . ')';
} else {
//use substr to leave off milliseconds since date is stored in seconds in the database
$stamp = '(@' . substr($datefilter[0], 2, 10) . ')';
$symbol = substr($datefilter[0], 0, 2);
if ($symbol === '<=') {
$compare = 'lessequal';
} elseif ($symbol === '>=') {
$compare = 'greaterequal';
}
$exactvalue[$i] = $compare . $stamp;
}
} else {
$filterfield[$i] = $id;
//convert category filters entered as text
if ($fieldtype === 'e' && !is_numeric($ajaxfilter)) {
$categlib = TikiLib::lib('categ');
$ajaxfilter = $categlib->get_category_id($ajaxfilter);
}
$filtervalue[$i] = $ajaxfilter;
}
$i++;
}
}
//convert tablesorter sort syntax to tiki syntax
if (!empty($_REQUEST['sort'])) {
foreach ($_REQUEST['sort'] as $sortcol => $ajaxsort) {
if ($ajaxsort == '0') {
$dir = '_asc';
} elseif ($ajaxsort == '1') {
$dir = '_desc';
}
//avoid setting sort_mode based on status field - will return error. Handle later once records are retrieved
if ($adjustCol !== -1 || $sortcol !== 0) {
$sort_mode = 'f_' . $allfields['data'][$sortcol + $adjustCol]['fieldId'] . $dir;
}
}
}
//set max records
if (isset($_REQUEST['numrows'])) {
$max = $_REQUEST['numrows'];
}
}
/*** end first tablesorter section ***/
if (!empty($filterfield)) {
if (is_array($filterfield)) {
foreach ($filterfield as $ff) {
unset($filterfieldok);
if (is_array($ff)) {
// already checked in trackerfilter
$filterfieldok = true;
break;
} else {
foreach ($allfields['data'] as $f) {
if ($f['fieldId'] == $ff) {
$filterfieldok = true;
break;
}
}
}
if (!isset($filterfieldok)) {
break;
}
}
} else {
foreach ($allfields['data'] as $f) {
if ($f['fieldId'] == $filterfield) {
$filterfieldok = true;
break;
}
}
}
if (!isset($filterfieldok)) {
return tra('incorrect filterfield');
}
}
$filter = array();
if (isset($periodQuantity)) {
switch ($periodUnit) {
case 'hour':
$periodUnit = 3600;
break;
case 'day':
$periodUnit = 86400;
break;
case 'week':
$periodUnit = 604800;
break;
case 'month':
$periodUnit = 2628000;
break;
default:
break;
}
if (!isset($periodType)) {
$periodType = 'c';
}
if (is_int($periodUnit) && $periodType == 'm') {
$filter['lastModifAfter'] = $tikilib->now - $periodQuantity * $periodUnit;
$filter['lastModifBefore'] = $tikilib->now;
} elseif (is_int($periodUnit)) {
# case for periodType beig c or anything else (therefore, set as case for default)
$filter['createdAfter'] = $tikilib->now - $periodQuantity * $periodUnit;
$filter['createdBefore'] = $tikilib->now;
}
}
if (isset($_REQUEST['reloff']) && empty($_REQUEST['itemId']) && !empty($_REQUEST['trackerId'])) {
//coming from a pagination
$items = $trklib->list_items($_REQUEST['trackerId'], $_REQUEST['reloff'], 1, '', '', isset($_REQUEST['filterfield']) ? preg_split('/\\s*:\\s*/', $_REQUEST['filterfield']) : '', isset($_REQUEST['filtervalue']) ? preg_split('/\\s*:\\s*/', $_REQUEST['filtervalue']) : '', isset($_REQUEST['status']) ? preg_split('/\\s*:\\s*/', $_REQUEST['status']) : '', isset($_REQUEST['initial']) ? $_REQUEST['initial'] : '', isset($_REQUEST['exactvalue']) ? preg_split('/\\s*:\\s*/', $_REQUEST['exactvalue']) : '', $filter);
if (isset($items['data'][0]['itemId'])) {
$_REQUEST['cant'] = $items['cant'];
$_REQUEST['itemId'] = $items['data'][0]['itemId'];
}
}
if (!empty($_REQUEST['itemId']) && $tiki_p_tracker_vote_ratings == 'y' && $user) {
$hasVoted = false;
foreach ($allfields['data'] as $f) {
if ($f['type'] == 's' && $definition->isEnabled('useRatings') && ($f['name'] == 'Rating' || ($f['name'] = tra('Rating')))) {
$i = $f['fieldId'];
if (isset($_REQUEST["ins_{$i}"]) && ($_REQUEST["ins_{$i}"] == 'NULL' || in_array($_REQUEST["ins_{$i}"], explode(',', $tracker_info['ratingOptions'])))) {
$trklib->replace_rating($trackerId, $_REQUEST['itemId'], $i, $user, $_REQUEST["ins_{$i}"]);
$hasVoted = true;
}
} elseif ($f['type'] == '*' || $f['type'] == 'STARS') {
$i = $f['fieldId'];
if (isset($_REQUEST["ins_{$i}"])) {
$trklib->replace_star($_REQUEST["ins_{$i}"], $trackerId, $_REQUEST['itemId'], $f, $user);
$hasVoted = true;
}
}
}
if ($hasVoted) {
// Must strip NULL for remove my vote case
$url = preg_replace('/[(\\?)|&]vote=y/', '$1', preg_replace('/[(\\?)|&]ins_[0-9]+=-?[0-9|N|U|L]*/', '$1', $_SERVER['REQUEST_URI']));
// reduce duplicate itemIds in query string
$occurences = preg_match_all('/[(\\?)|&]itemId=[0-9]+/', $url, $matches);
if ($params['list_mode'] == 'y' && $occurences > 0) {
$url = preg_replace('/[(\\?)|&]itemId=[0-9]+/', '$1', $url, $occurences);
} elseif ($occurences > 1) {
$url = preg_replace('/&itemId=[0-9]+/', '', $url, $occurences - 1);
}
header("Location: {$url}");
die;
}
}
if (!empty($showwatch) && $showwatch == 'y' && $prefs['feature_user_watches'] == 'y' && $tiki_p_watch_trackers == 'y' && !empty($user)) {
if (isset($_REQUEST['watch']) && isset($_REQUEST['trackerId']) && $_REQUEST['trackerId'] == $trackerId) {
if ($_REQUEST['watch'] == 'add') {
$tikilib->add_user_watch($user, 'tracker_modified', $trackerId, 'tracker', $tracker_info['name'], "tiki-view_tracker.php?trackerId=" . $trackerId);
} elseif ($_REQUEST['watch'] == 'stop') {
$tikilib->remove_user_watch($user, 'tracker_modified', $trackerId, 'tracker');
}
}
if ($tikilib->user_watches($user, 'tracker_modified', $trackerId, 'tracker')) {
$smarty->assign('user_watching_tracker', 'y');
} else {
$smarty->assign('user_watching_tracker', 'n');
}
} else {
$smarty->clear_assign('user_watching_tracker');
}
if (empty($showrss) || $showrss == 'n') {
$smarty->assign('showrss', 'n');
} else {
$smarty->assign('showrss', 'y');
}
if (empty($listfields)) {
foreach ($allfields['data'] as $f) {
$listfields[] = $f['fieldId'];
}
}
if (!empty($popup)) {
$popupfields = $popup;
} else {
$popupfields = array();
}
$smarty->assign_by_ref('tracker_info', $tracker_info);
//$query_array = array();
//$quarray = array();
//TikiLib::parse_str($_SERVER['QUERY_STRING'],$query_array);
if (isset($stickypopup) && $stickypopup == 'y') {
$stickypopup = true;
} else {
$stickypopup = false;
}
$smarty->assign_by_ref('stickypopup', $stickypopup);
if (!isset($showtitle)) {
$showtitle = 'n';
}
$smarty->assign_by_ref('showtitle', $showtitle);
if (!isset($showlinks)) {
$showlinks = 'n';
}
$smarty->assign_by_ref('showlinks', $showlinks);
if (!isset($showdesc)) {
$showdesc = 'n';
}
$smarty->assign_by_ref('showdesc', $showdesc);
if (!isset($showinitials)) {
$showinitials = 'n';
}
$smarty->assign_by_ref('showinitials', $showinitials);
if (!isset($shownbitems)) {
$shownbitems = 'n';
}
$smarty->assign_by_ref('shownbitems', $shownbitems);
if (!isset($showstatus)) {
$showstatus = 'n';
}
$smarty->assign_by_ref('showstatus', $showstatus);
if (!isset($showfieldname)) {
$showfieldname = 'y';
}
$smarty->assign_by_ref('showfieldname', $showfieldname);
if (!isset($showitemrank)) {
$showitemrank = 'n';
}
$smarty->assign_by_ref('showitemrank', $showitemrank);
if (!isset($showdelete)) {
$showdelete = 'n';
}
$smarty->assign_by_ref('showdelete', $showdelete);
if (!isset($showpenditem)) {
$showpenditem = 'n';
}
$smarty->assign_by_ref('showpenditem', $showpenditem);
if (!isset($showcloseitem)) {
$showcloseitem = 'n';
}
$smarty->assign_by_ref('showcloseitem', $showcloseitem);
if (!isset($showopenitem)) {
$showopenitem = 'n';
}
$smarty->assign_by_ref('showopenitem', $showopenitem);
if (!isset($showpagination)) {
$showpagination = 'y';
}
$smarty->assign_by_ref('showpagination', $showpagination);
if (!isset($sortchoice)) {
$sortchoice = '';
} else {
foreach ($sortchoice as $i => $sc) {
$sc = explode('|', $sc);
$sortchoice[$i] = array('value' => $sc[0], 'label' => empty($sc[1]) ? $sc[0] : $sc[1]);
}
}
$smarty->assign_by_ref('sortchoice', $sortchoice);
if (!isset($status)) {
$status = 'o';
}
$tr_status = $status;
$smarty->assign_by_ref('tr_status', $tr_status);
if (!isset($list_mode)) {
$list_mode = 'y';
}
$smarty->assign_by_ref('list_mode', $list_mode);
if (!isset($showcreated)) {
$showcreated = $tracker_info['showCreated'];
}
$smarty->assign_by_ref('showcreated', $showcreated);
if (!isset($showlastmodif)) {
$showlastmodif = $tracker_info['showLastModif'];
}
$smarty->assign_by_ref('showlastmodif', $showlastmodif);
if (!isset($showlastmodifby)) {
$showlastmodifby = $tracker_info['showLastModifBy'];
}
$smarty->assign_by_ref('showlastmodifby', $showlastmodifby);
if (!isset($more)) {
$more = 'n';
}
$smarty->assign_by_ref('more', $more);
if (!isset($moreurl)) {
$moreurl = 'tiki-view_tracker.php';
}
$smarty->assign_by_ref('moreurl', $moreurl);
if (!isset($url)) {
$url = '';
}
$smarty->assign_by_ref('url', $url);
if (!isset($export)) {
$export = 'n';
}
$smarty->assign_by_ref('export', $export);
if (!empty($ldelim)) {
$smarty->left_delimiter = $ldelim;
}
if (!empty($rdelim)) {
$smarty->right_delimiter = $rdelim;
}
if (isset($checkbox)) {
$check = array('ix' => -1, 'type' => 'checkbox');
$cb = explode('/', $checkbox);
if (isset($cb[0])) {
$check['fieldId'] = $cb[0];
}
if (isset($cb[1])) {
$check['name'] = $cb[1];
}
if (isset($cb[2])) {
$check['title'] = $cb[2];
}
if (isset($cb[3])) {
$check['submit'] = $cb[3];
}
if (isset($cb[4])) {
$check['action'] = $cb[4];
}
if (isset($cb[5])) {
$check['tpl'] = $cb[5];
}
if (isset($cb[6]) && $cb[6] == 'radio') {
$check['radio'] = 'y';
$check['type'] = 'radio';
}
if (isset($cb[6]) && $cb[6] == 'dropdown') {
$check['dropdown'] = 'y';
}
// is this actually used?
$smarty->assign_by_ref('checkbox', $check);
}
if (isset($_REQUEST["tr_sort_mode{$iTRACKERLIST}"])) {
$sort_mode = $_REQUEST["tr_sort_mode{$iTRACKERLIST}"];
} elseif (!isset($sort_mode)) {
if (!empty($tracker_info['defaultOrderKey'])) {
if ($tracker_info['defaultOrderKey'] == -1) {
$sort_mode = 'lastModif';
} elseif ($tracker_info['defaultOrderKey'] == -2) {
$sort_mode = 'created';
} elseif ($tracker_info['defaultOrderKey'] == -3) {
$sort_mode = 'itemId';
} else {
$sort_mode = 'f_' . $tracker_info['defaultOrderKey'];
}
if (isset($tracker_info['defaultOrderDir'])) {
$sort_mode .= "_" . $tracker_info['defaultOrderDir'];
} else {
$sort_mode .= "_asc";
}
} else {
$sort_mode = '';
}
} elseif ($sort_mode != 'created_asc' && $sort_mode != 'lastModif_asc' && $sort_mode != 'created_desc' && $sort_mode != 'lastModif_desc' && !preg_match('/f_[0-9]+_(asc|desc)/', $sort_mode)) {
return tra('Incorrect param') . ' sort_mode';
}
$tr_sort_mode = $sort_mode;
$smarty->assign_by_ref('tr_sort_mode', $tr_sort_mode);
if (!isset($max)) {
$max = $prefs['maxRecords'];
}
if (isset($_REQUEST["tr_offset{$iTRACKERLIST}"]) && (!isset($forceoffset) || $forceoffset == 'n')) {
$tr_offset = $_REQUEST["tr_offset{$iTRACKERLIST}"];
} else {
if (isset($offset) && $offset >= 0) {
$tr_offset = $offset;
} else {
$tr_offset = 0;
}
}
$smarty->assign_by_ref("tr_offset{$iTRACKERLIST}", $tr_offset);
$tr_initial = '';
if ($showinitials == 'y') {
if (isset($_REQUEST['tr_initial'])) {
//$query_array['tr_initial'] = $_REQUEST['tr_initial'];
$tr_initial = $_REQUEST['tr_initial'];
}
$smarty->assign('initials', explode(' ', 'a b c d e f g h i j k l m n o p q r s t u v w x y z'));
}
$smarty->assign_by_ref('tr_initial', $tr_initial);
if (isset($view) && $view == 'user' || isset($view_user) || isset($_REQUEST['tr_user'])) {
if ($f = $definition->getAuthorField()) {
$filterfield[] = $f;
$filtervalue[] = '';
if (!isset($_REQUEST['tr_user'])) {
$exactvalue[] = isset($view) ? empty($user) ? 'Anonymous' : $user : $view_user;
} else {
$exactvalue[] = $_REQUEST['tr_user'];
$smarty->assign_by_ref('tr_user', $exactvalue);
}
if ($definition->isEnabled('writerCanModify') or $definition->isEnabled('userCanSeeOwn')) {
$skip_status_perm_check = true;
}
}
}
if (isset($view) && $view == 'page' && isset($_REQUEST['page'])) {
if ($f = $trklib->get_page_field($trackerId)) {
$filterfield[] = $f['fieldId'];
$filtervalue[] = '';
$exactvalue[] = $_REQUEST['page'];
}
}
if (isset($view) && $view == 'ip') {
if ($f = $definition->getAuthorIpField()) {
$filterfield[] = $f;
$filtervalue[] = '';
$ip = $tikilib->get_ip_address();
$exactvalue[] = $ip;
}
}
if (!isset($filtervalue)) {
$filtervalue = '';
} else {
foreach ($filtervalue as $i => $f) {
if ($f == '#user') {
$filtervalue[$i] = $user;
} else {
if ($f == '#default_group') {
$filtervalue[$i] = $_SESSION['u_info']['group'];
}
}
}
}
if (!isset($exactvalue)) {
$exactvalue = '';
} else {
foreach ($exactvalue as $i => $f) {
if ($f == '#user') {
$exactvalue[$i] = $user;
}
}
}
if (!empty($_REQUEST['itemId']) && (empty($ignoreRequestItemId) || $ignoreRequestItemId != 'y')) {
$itemId = $_REQUEST['itemId'];
}
if (isset($itemId)) {
if (is_string($itemId) && strstr($itemId, ':')) {
// JB Tiki7: This doesn't quite make sense as itemId is an array
$itemId = explode(':', $itemId);
// Probably just some redundant code TOKIL
}
$filter['tti.`itemId`'] = $itemId;
}
$newItemRateField = false;
$status_types = $trklib->status_types();
$smarty->assign('status_types', $status_types);
if (!isset($filterfield)) {
$filterfield = '';
} else {
if (!empty($filterfield)) {
if (!empty($filtervalue)) {
$fvs = $filtervalue;
unset($filtervalue);
for ($i = 0, $count_ff = count($filterfield); $i < $count_ff; ++$i) {
$filtervalue[] = isset($fvs[$i]) ? $fvs[$i] : '';
}
}
if (!empty($exactvalue)) {
$evs = $exactvalue;
unset($exactvalue);
for ($i = 0, $count_ff2 = count($filterfield); $i < $count_ff2; ++$i) {
if (isset($evs[$i])) {
if (is_array($evs[$i])) {
// already processed
$exactvalue[] = $evs[$i];
} elseif (preg_match('/(not)?categories\\(([0-9]+)\\)/', $evs[$i], $matches)) {
$categlib = TikiLib::lib('categ');
if (ctype_digit($matches[2]) && $matches[2] > 0) {
$cfilter = array('identifier' => $matches[2], 'type' => 'descendants');
} else {
$cfilter = NULL;
}
$categs = $categlib->getCategories($cfilter, true, false);
$l = array($matches[2]);
foreach ($categs as $cat) {
$l[] = $cat['categId'];
}
if (empty($matches[1])) {
$exactvalue[] = $l;
} else {
$exactvalue[] = array('not' => $l);
}
} elseif (preg_match('/(not)?preference\\((.*)\\)/', $evs[$i], $matches)) {
if (empty($matches[1])) {
$exactvalue[] = $prefs[$matches[2]];
} else {
$exactvalue[] = array('not' => $prefs[$matches[2]]);
}
} elseif (preg_match('/(not)?field\\(([0-9]+)(,([0-9]+|user)(,([0-9]+))?)?\\)/', $evs[$i], $matches)) {
// syntax field(fieldId, user, trackerId) or field(fieldId)(need the REQUEST['itemId'] or field(fieldId, itemId) or field(fieldId, user)
if (empty($matches[4]) && !empty($_REQUEST['itemId'])) {
// user the itemId of the url
$matches[4] = $_REQUEST['itemId'];
}
if (!empty($matches[4]) && $matches[4] == 'user') {
if (!empty($matches[6])) {
// pick the user item of this tracker
$t_i = $trklib->get_tracker($matches[6]);
$matches[4] = $trklib->get_user_item($matches[6], $t_i, $user);
} elseif ($prefs['userTracker'] == 'y') {
//pick the generic user tracker
$utid = $userlib->get_tracker_usergroup($user);
$matches[4] = $trklib->get_item_id($utid['usersTrackerId'], $utid['usersFieldId'], $user);
}
}
if (!empty($matches[4])) {
$l = $trklib->get_item_value(0, $matches[4], $matches[2]);
$field = $trklib->get_tracker_field($matches[2]);
if ($field['type'] == 'r') {
$refItemId = $l;
$l = $trklib->get_item_value($field['options_array'][0], $refItemId, $field['options_array'][3]);
}
}
if (empty($matches[1])) {
$exactvalue[] = $l;
} else {
$exactvalue[] = array('not' => $l);
}
} elseif (preg_match('/(less|greater|lessequal|greaterequal)\\((.+)\\)/', $evs[$i], $matches)) {
$conv = array('less' => '<', 'greater' => '>', 'lessequal' => '<=', 'greaterequal' => '>=');
$field = $trklib->get_tracker_field($filterfield[$i]);
if ($field['type'] == 'f' || $field['type'] == 'j') {
if ($matches[2] == 'now') {
$matches[2] = $tikilib->now;
} elseif (($r = strtotime($matches[2])) !== false) {
$matches[2] = $r;
}
}
$exactvalue[] = array($conv[$matches[1]] => $matches[2]);
} elseif (preg_match('/not\\((.+)\\)/', $evs[$i], $matches)) {
$exactvalue[] = array('not' => $matches[1]);
} else {
$exactvalue[] = $evs[$i];
}
} else {
$exactvalue[] = '';
}
}
}
}
}
if ($tiki_p_admin_trackers != 'y' && $perms['tiki_p_view_trackers'] != 'y' && ($definition->isEnabled('writerCanModify') or $definition->isEnabled('userCanSeeOwn')) && $user && $userCreatorFieldId) {
//patch this should be in list_items
if ($filterfield != $userCreatorFieldId || is_array($filterfield) && !in_array(${$userCreatorFieldId}, $filterfield)) {
if (is_array($filterfield)) {
$filterfield[] = $userCreatorFieldId;
} elseif (empty($filterfield)) {
$filterfield = $userCreatorFieldId;
} else {
$filterfield = array($filterfield, $fieldId);
}
if (is_array($exactvalue)) {
$exactvalue[] = $user;
} elseif (empty($exactvalue)) {
$exactvalue = $user;
} else {
$exactvalue = array($exactvalue, $user);
}
}
}
if ($tiki_p_admin_trackers != 'y' && $perms['tiki_p_view_trackers'] != 'y' && $user && $groupCreatorFieldId) {
if ($filterfield != $groupCreatorFieldId || is_array($filterfield) && !in_array($groupCreatorFieldId, $filterfield)) {
$groups = $userlib->get_user_groups($user);
if (is_array($filterfield)) {
$filterfield[] = $groupCreatorFieldId;
} elseif (empty($filterfield)) {
$filterfield = $groupCreatorFieldId;
} else {
$filterfield = array($filterfield, $fieldId);
}
if (is_array($exactvalue)) {
$exactvalue[] = array_merge($exactvalue, $groups);
} elseif (empty($exactvalue)) {
$exactvalue = $groups;
} else {
$exactvalue = array_merge(array($exactvalue), $groups);
}
global $group;
// awful trick - but the filter garantee that the group is ok
$smarty->assign_by_ref('ours', $group);
$perms = array_merge($perms, $trklib->get_special_group_tracker_perm($tracker_info));
}
}
for ($i = 0, $count_allf = count($allfields['data']); $i < $count_allf; $i++) {
if ($allfields['data'][$i]['type'] == 'C') {
$infoComputed = $trklib->get_computed_info($allfields['data'][$i]['options_array'][0], $trackerId, $allfields['data']);
if (!empty($infoComputed)) {
$allfields['data'][$i] = array_merge($infoComputed, $allfields['data'][$i]);
}
} elseif ($allfields["data"][$i]['type'] == 'w') {
/* keep track of dynamic list items referring to user selectors */
$refFieldId = $allfields["data"][$i]['options_array'][3];
$refField = $trklib->get_tracker_field($refFieldId);
if ($refField['type'] == 'u') {
$allfields["data"][$i]['type'] = $refField['type'];
}
}
// If listfields is a colon separated string, convert it to an array
if (!is_array($listfields)) {
$listfields = explode(':', $listfields);
}
if ((in_array($allfields["data"][$i]['fieldId'], $listfields) or in_array($allfields["data"][$i]['fieldId'], $popupfields)) and $allfields["data"][$i]['isPublic'] == 'y') {
$passfields["{$allfields["data"][$i]['fieldId']}"] = $allfields["data"][$i];
}
if (isset($check['fieldId']) && $allfields["data"][$i]['fieldId'] == $check['fieldId']) {
$passfields["{$allfields["data"][$i]['fieldId']}"] = $allfields["data"][$i];
if (!in_array($allfields["data"][$i]['fieldId'], $listfields)) {
$allfields["data"][$i]['isPublic'] == 'n';
}
//don't show it
$check['ix'] = count($passfields) - 1;
}
if ($allfields["data"][$i]['name'] == 'page' && empty($filterfield) && empty($displayList) && !empty($view) && $view == 'page') {
$filterfield = $allfields["data"][$i]['fieldId'];
$filtervalue = $_REQUEST['page'];
}
if ($definition->isEnabled('useRatings') and $allfields["data"][$i]['type'] == 's' and $allfields["data"][$i]['name'] == 'Rating') {
$newItemRateField = $allfields["data"][$i]['fieldId'];
}
}
$nonPublicFieldsWarning = '';
if ($tiki_p_edit === 'y') {
foreach ($allfields['data'] as $field) {
if ($field['isPublic'] !== 'y' && in_array($field['fieldId'], array_merge($listfields, $popupfields))) {
$nonPublicFieldsWarning = tra('You have attempted to view data of a tracker field which is not public. You need to ask the admin to change the setting to public for this field.');
}
}
}
if ($editableall == 'y') {
$editable = $listfields;
}
$smarty->assign('nonPublicFieldsWarning', $nonPublicFieldsWarning);
$smarty->assign_by_ref('filterfield', $filterfield);
$smarty->assign_by_ref('filtervalue', $filtervalue);
$smarty->assign_by_ref('fields', $passfields);
$smarty->assign_by_ref('exactvalue', $exactvalue);
$smarty->assign_by_ref('listfields', $listfields);
$smarty->assign_by_ref('popupfields', $popupfields);
$smarty->assign('editableFields', $editable);
if (!empty($filterfield)) {
$urlquery['filterfield'] = is_array($filtervalue) ? implode(':', $filterfield) : $filterfield;
if (!is_array($filtervalue)) {
$filtervalue = array($filtervalue);
}
$urlquery['filtervalue'] = is_array($filtervalue) ? implode(':', $filtervalue) : $filtervalue;
$urlquery['exactvalue'] = is_array($exactvalue) ? implode(':', $exactvalue) : $exactvalue;
$urlquery['trackerId'] = $trackerId;
$smarty->assign('urlquery', $urlquery);
} else {
$smarty->assign('urlquery', '');
}
if (!empty($export) && $export != 'n' && $perms['tiki_p_export_tracker'] == 'y') {
$smarty->loadPlugin('smarty_function_service');
$exportParams = array('controller' => 'tracker', 'action' => 'export', 'trackerId' => $trackerId);
if (!empty($fields)) {
$exportParams['displayedFields'] = is_array($fields) ? implode(':', $fields) : $fields;
}
if (is_array($filterfield)) {
foreach ($filterfield as $i => $fieldId) {
$exportParams["f_{$fieldId}"] = empty($filtervalue[$i]) ? $exactvalue[$i] : $filtervalue[$i];
}
} elseif (!empty($filterfield)) {
$exportParams["f_{$filterfield}"] = empty($filtervalue) ? $exactvalue : $filtervalue;
}
$exportUrl = smarty_function_service($exportParams, $smarty);
$smarty->assign('exportUrl', $exportUrl);
}
if (!empty($_REQUEST['delete'])) {
$itemToDelete = Tracker_Item::fromId($_REQUEST['delete']);
if ($itemToDelete->canRemove()) {
$trklib->remove_tracker_item($_REQUEST['delete']);
}
if (!empty($urlafterdelete)) {
header("Location: {$urlafterdelete}");
exit;
}
}
if (!empty($_REQUEST['closeitem'])) {
$itemToModify = Tracker_Item::fromId($_REQUEST['closeitem']);
if ($itemToModify->canModify()) {
$trklib->change_status(array(array('itemId' => $_REQUEST['closeitem'])), 'c');
}
}
if (!empty($_REQUEST['penditem'])) {
$itemToModify = Tracker_Item::fromId($_REQUEST['penditem']);
if ($itemToModify->canModify()) {
$trklib->change_status(array(array('itemId' => $_REQUEST['penditem'])), 'p');
}
}
if (!empty($_REQUEST['openitem'])) {
$itemToModify = Tracker_Item::fromId($_REQUEST['openitem']);
if ($itemToModify->canModify()) {
$trklib->change_status(array(array('itemId' => $_REQUEST['openitem'])), 'o');
}
}
if (!empty($calendarfielddate)) {
$calendarlib = TikiLib::lib('calendar');
$focusDate = empty($_REQUEST['todate']) ? $tikilib->now : $_REQUEST['todate'];
$focus = $calendarlib->infoDate($focusDate);
if (!empty($calendardelta)) {
if ($calendardelta[0] == '-') {
$focus = $calendarlib->focusPrevious($focus, str_replace('-', '', $calendardelta));
} else {
$focus = $calendarlib->focusNext($focus, str_replace('+', '', $calendardelta));
}
}
$calendarlib->focusStartEnd($focus, $calendarviewmode, $calendarbeginmonth, $startPeriod, $startNextPeriod);
$cell = $calendarlib->getTableViewCells($startPeriod, $startNextPeriod, $calendarviewmode, $calendarlib->firstDayofWeek($user));
if (is_array($filterfield) == false) {
$filterfield = array($filterfield);
}
if (is_array(${$filtervalue}) == false) {
$filtervalue = array($filtervalue);
}
$filterfield[] = $calendarfielddate[0];
$filtervalue[] = '';
$exactvalue[] = array('>=' => $startPeriod['date']);
$filterfield[] = empty($calendarfielddate[1]) ? $calendarfielddate[0] : $calendarfielddate[1];
$filtervalue[] = '';
$exactvalue[] = array('<' => $startNextPeriod['date']);
}
if (count($passfields)) {
// Optimization: Group category fields using AND logic indicated by sub-array
$catfilters = array();
$catfiltervalue = array();
$catfilternotvalue = array();
if (!empty($filterfield)) {
foreach ($filterfield as $k => $ff) {
$filterfieldinfo = $trklib->get_tracker_field($ff);
if ($filterfieldinfo['type'] == 'e') {
$catfilters[] = $k;
if (!empty($filtervalue[$k]) && empty($exactvalue[$k])) {
// Some people use filtervalue instead of exactvalue for category filters
$exactvalue[$k] = $filtervalue[$k];
for ($i = 0; $i < $k; $i++) {
if (!isset($exactvalue[$i])) {
$exactvalue[$i] = '';
}
}
}
if (array_key_exists('not', array($exactvalue[$k]))) {
$catfilternotfield[0] = $ff;
$catfilternotvalue[] = array($exactvalue[$k]);
} else {
$catfilterfield[0] = $ff;
$catfiltervalue[] = array($exactvalue[$k]);
}
}
}
}
if ($catfilters) {
foreach ($catfilters as $cf) {
unset($filterfield[$cf]);
unset($exactvalue[$cf]);
}
if ($catfiltervalue) {
// array_merge is used because it reindexes
$filterfield = array_merge($filterfield, $catfilterfield);
$exactvalue = array_merge($exactvalue, array($catfiltervalue));
}
if ($catfilternotvalue) {
$filterfield = array_merge($filterfield, $catfilternotfield);
$exactvalue[] = array('not' => $catfilternotvalue);
}
}
// End Optimization
//fetch tracker items
$items = $trklib->list_items($trackerId, $tr_offset, $max, $tr_sort_mode, $passfields, !empty($calendarfielddate) ? null : $filterfield, $filtervalue, $tr_status, $tr_initial, $exactvalue, $filter, $allfields, $skip_status_perm_check);
/*** tablesorter ***/
if ($tsOn && !$tsAjax) {
// when using serverside filtering check wether a dropdown is in use
// and we must take params from tracker definition because no explicit options have been defined
if ($tsServer) {
//format from plugin: type:text|type:dropdown;option:1=Open;option:2=Closed|type:text|type:nofilter|type:nofilter|type:nofilter
if (!empty($tsfilters) && strpos($tsfilters, 'dropdown') !== false) {
$tsfiltersArray = explode('|', $tsfilters);
$adjustCol = isset($showstatus) && $showstatus == 'y' && $definition->isEnabled('showStatus') ? -1 : 0;
foreach ($tsfiltersArray as $col => &$tsfilterField) {
// only consider dropdown definitions without explicit option
if (strpos($tsfilterField, 'dropdown') !== false && strpos($tsfilterField, 'option') === false) {
//content from options (json object): {"options":["1=Open"," 2=Closed]} - note there can be whitespaces - it should not but there can be - yet another fix required
if ($allfields['data'][$col + $adjustCol]['type'] == 'd') {
$options = $allfields['data'][$col + $adjustCol]['options'];
$options = json_decode($options);
$options = $options->options;
// construct the new dropdown filterfield entry from the trackerfield definition
$newTsfilterField = 'type:dropdown';
foreach ($options as $option) {
$newTsfilterField .= ";option:" . trim($option);
}
// update field - note that we used a ref
$tsfilterField = $newTsfilterField;
}
}
}
// update tsfilters
$tsfilters = implode('|', $tsfiltersArray);
}
}
$ts_id = 'wptrackerlist' . $trackerId . '-' . $iTRACKERLIST;
$ts = new Table_Plugin();
$ts->setSettings($ts_id, isset($server) ? $server : null, $sortable, isset($sortList) ? $sortList : null, isset($tsortcolumns) ? $tsortcolumns : null, isset($tsfilters) ? $tsfilters : null, isset($tsfilteroptions) ? $tsfilteroptions : null, isset($tspaginate) ? $tspaginate : null, isset($tscolselect) ? $tscolselect : null, $GLOBALS['requestUri'], $items['cant'], isset($tstotals) ? $tstotals : null, isset($tstotalformat) ? $tstotalformat : null, isset($tstotaloptions) ? $tstotaloptions : null);
//loads the jquery tablesorter code
if (is_array($ts->settings)) {
$ts->settings['ajax']['offset'] = 'tr_offset' . $iTRACKERLIST;
Table_Factory::build('PluginWithAjax', $ts->settings);
}
}
//determine whether totals will be added to bottom of table
if (isset($ts->settings)) {
Table_Totals::setTotals($ts->settings);
}
//handle certain tablesorter sorts
if (isset($sortcol) && $items['cant'] > 1) {
$fieldtype = $items['data'][0]['field_values'][$sortcol + $adjustCol]['type'];
//convert categoryId sort to category name sort when tablesorter server side sorting is used
if ($fieldtype === 'e') {
foreach ($items['data'] as $key => $record) {
$catfield = $record['field_values'][$sortcol + $adjustCol];
$sortarray[$key] = $catfield['list'][$catfield['value']]['name'];
}
//sort status
} elseif ($adjustCol === -1 && $sortcol === 0) {
$sortarray = array_column($items['data'], 'status');
}
array_multisort($sortarray, $dir == '_desc' ? SORT_DESC : SORT_ASC, $items['data']);
}
/*** end second tablesorter section ***/
if (isset($silent) && $silent == 'y' && empty($items['cant'])) {
return;
}
if (isset($items['cant']) && $items['cant'] == 1 && isset($goIfOne) && ($goIfOne == 'y' || $goIfOne == 1)) {
header('Location: tiki-view_tracker_item.php?itemId=' . $items['data'][0]['itemId'] . '&trackerId=' . $items['data'][0]['trackerId']);
die;
}
if ($newItemRateField && !empty($items['data'])) {
foreach ($items['data'] as $f => $v) {
$items['data'][$f]['my_rate'] = $tikilib->get_user_vote("tracker." . $trackerId . '.' . $items['data'][$f]['itemId'], $user);
}
}
if (!empty($items['data']) && ($definition->isEnabled('useComments') && $definition->isEnabled('showComments') || $definition->isEnabled('showLastComment'))) {
foreach ($items['data'] as $itkey => $oneitem) {
if ($definition->isEnabled('showComments')) {
$items['data'][$itkey]['comments'] = $trklib->get_item_nb_comments($items['data'][$itkey]['itemId']);
}
if ($definition->isEnabled('showLastComment')) {
$l = $trklib->list_last_comments($items['data'][$itkey]['trackerId'], $items['data'][$itkey]['itemId'], 0, 1);
$items['data'][$itkey]['lastComment'] = !empty($l['cant']) ? $l['data'][0] : '';
}
}
}
if (!empty($items['data']) && ($definition->isEnabled('useAttachments') && $definition->isEnabled('showAttachments'))) {
foreach ($items["data"] as $itkey => $oneitem) {
$res = $trklib->get_item_nb_attachments($items["data"][$itkey]['itemId']);
$items["data"][$itkey]['attachments'] = $res['attachments'];
}
}
if (!empty($compute) && !empty($items['data'])) {
$fs = preg_split('/ *: */', $compute);
foreach ($fs as $fieldId) {
if (strstr($fieldId, "/")) {
list($fieldId, $oper) = preg_split('/ *\\/ */', $fieldId);
$oper = strtolower($oper);
if ($oper == 'average') {
$oper = 'avg';
} elseif ($oper != 'sum' && $oper != 'avg') {
$oper = 'sum';
}
} else {
$oper = 'sum';
}
foreach ($items['data'] as $i => $item) {
foreach ($item['field_values'] as $field) {
if ($field['fieldId'] == $fieldId) {
if (preg_match('/^ *$/', $field['value']) || !is_numeric($field['value'])) {
$amount[$i] = '0';
} else {
$amount[$i] = $field['value'];
}
break;
}
}
}
$value = array_sum($amount);
if ($oper == 'avg') {
$value = round($value / count($amount));
}
$computedFields[$fieldId][] = array_merge(array('computedtype' => 'n', 'operator' => $oper, 'value' => $value), $passfields[$fieldId]);
}
$smarty->assign_by_ref('computedFields', $computedFields);
} else {
$smarty->assign('computedFields', '');
}
if (!empty($calendarfielddate)) {
foreach ($items['data'] as $i => $item) {
if (!empty($wiki)) {
$smarty->assign('fields', $item['field_values']);
$smarty->assign('item', $item);
$smarty->assign('wiki', "wiki:{$wiki}");
$smarty->assign('showpopup', 'n');
$items['data'][$i]['over'] = $smarty->fetch('tracker_pretty_item.tpl');
}
if (!empty($tplwiki)) {
$smarty->assign('fields', $item['field_values']);
$smarty->assign('item', $item);
$smarty->assign('wiki', "tplwiki:{$tplwiki}");
$smarty->assign('showpopup', 'n');
$items['data'][$i]['over'] = $smarty->fetch('tracker_pretty_item.tpl');
}
if (empty($items['data'][$i]['over'])) {
$items['data'][$i]['over'] = $trklib->get_isMain_value($trackerId, $item['itemId']);
}
$items['data'][$i]['visible'] = 'y';
}
$trklib->fillTableViewCell($items['data'], $calendarfielddate, $cell);
$smarty->assign('cell', $cell);
$smarty->assign('show_calendar_module', 'y');
$calendarlib->getDayNames($calendarlib->firstDayofWeek($user), $daysnames, $daysnames_abr);
$smarty->assign('daysnames_abr', $daysnames_abr);
$smarty->assign('focusmonth', TikiLib::date_format("%m", $focusDate));
$smarty->assign('module_params', array('viewmode' => 'n', 'showaction' => 'n', 'notitle' => empty($calendartitle) ? 'y' : 'n', 'title' => $calendartitle, 'viewnavbar' => $calendarviewnavbar, 'decorations' => empty($calendartitle) ? 'n' : 'y'));
$smarty->assign('tpl_module_title', tra($calendartitle));
$smarty->assign('now', $tikilib->now);
$smarty->assign('calendarViewMode', $calendarviewmode);
$smarty->assign('viewmodelink', $calendarviewmode);
$smarty->assign('viewmode', $calendarviewmode);
$focus_prev = $calendarlib->focusPrevious($focus, $calendarviewmode);
$smarty->assign('focus_prev', $focus_prev['date']);
$focus_next = $calendarlib->focusNext($focus, $calendarviewmode);
$smarty->assign('focus_next', $focus_next['date']);
$smarty->assign('daystart', $startPeriod['date']);
$dayend = $calendarlib->infoDate($startNextPeriod['date'] - 1);
$smarty->assign('dayend', $dayend['date']);
$smarty->assign('today', TikiLib::make_time(0, 0, 0, TikiLib::date_format('%m'), TikiLib::date_format('%d'), TikiLib::date_format('%Y')));
$smarty->assign('sticky_popup', $calendarstickypopup);
$smarty->assign('calendar_popup', $calendarpopup);
$smarty->assign('showpopup', 'n');
$headerlib = TikiLib::lib('header');
$headerlib->add_cssfile('themes/base_files/feature_css/calendar.css', 20);
return $smarty->fetch('modules/mod-calendar_new.tpl');
}
if (!empty($wiki)) {
$tpl = "wiki:{$wiki}";
} elseif (!empty($tplwiki)) {
$tpl = "tplwiki:{$tplwiki}";
} elseif (empty($tpl)) {
$tpl = '';
}
if (!empty($tpl)) {
$smarty->security = true;
}
$smarty->assign('tpl', $tpl);
if (!empty($itemId) && $showpagination == 'y' && !empty($_REQUEST['cant'])) {
$smarty->assign('max', 1);
$smarty->assign('count_item', $_REQUEST['cant']);
$smarty->assign('offset_arg', 'reloff');
$smarty->assign("tr_offset{$iTRACKERLIST}", $_REQUEST['reloff']);
} else {
$smarty->assign_by_ref('max', $max);
$smarty->assign_by_ref('item_count', $items['cant']);
$smarty->assign_by_ref('count_item', $items['cant']);
$smarty->assign('offset_arg', "tr_offset{$iTRACKERLIST}");
}
$smarty->assign_by_ref('items', $items["data"]);
$smarty->assign('daformat', $tikilib->get_long_date_format() . " " . tra("at") . " %H:%M");
if (!empty($params['showmap']) && $params['showmap'] == 'y') {
$smarty->assign('trackerlistmapview', true);
$smarty->assign('trackerlistmapname', "trackerlistmap_{$iTRACKERLIST}");
} else {
$smarty->assign('trackerlistmapview', false);
}
if (isset($items['data'])) {
foreach ($items['data'] as $score_item) {
$item_info = $trklib->get_tracker_item($score_item['itemId']);
$currentItemId = $score_item['itemId'];
TikiLib::events()->trigger('tiki.trackeritem.view', array('type' => 'trackeritem', 'object' => $currentItemId, 'owner' => $item_info['createdBy'], 'user' => $GLOBALS['user']));
}
}
$tracker = $trklib->get_tracker($trackerId, 0, -1);
/*foreach ($query_array as $k=>$v) {
if (!is_array($v)) { //only to avoid an error: eliminate the params that are not simple (ex: if you have in the same page a tracker list plugin and a tracker plugin, filling the tracker plugin interfers with the tracker list. In any case this is buggy if two tracker list plugins in the same page and if one needs the query value....
$quarray[] = urlencode($k) ."=". urlencode($v);
}
}
if (is_array($quarray)) {
$query_string = implode("&",$quarray);
} else {
$quering_string = '';
}
$smarty->assign('query_string', $query_string);
*/
if (!$tracker) {
$smarty->assign('msg', tra("Error in tracker ID"));
return $smarty->fetch("error_raw.tpl");
} else {
$save_fc = null;
if (!empty($wiki) && $params['force_compile'] === 'y') {
// some pretty trackers need to compile fresh for each item
$save_fc = $smarty->force_compile;
$smarty->force_compile = true;
}
//this options preloads the javascript for displaying sheets
if (!empty($displaysheet) && $displaysheet == 'y') {
$headerlib = TikiLib::lib("header");
$sheetlib = TikiLib::lib("sheet");
$sheetlib->setup_jquery_sheet();
$headerlib->add_jq_onready('$("div.trackercontainer").sheet($.extend($.sheet.tikiOptions,{
editable:false,
buildSheet: true,
minSize: {rows: 0, cols: 0}
}));');
$smarty->assign('displaysheet', 'true');
}
//this method sets up the sheet just like it would for jquery.sheet, but assumes that the javascript will be handled elsewere
if (!empty($tableassheet) && $tableassheet == 'y') {
$smarty->assign('tableassheet', 'true');
}
$smarty->assign('context', $params);
try {
$str = $smarty->fetch('wiki-plugins/wikiplugin_trackerlist.tpl');
} catch (SmartyException $e) {
$str = $e->getMessage();
}
if ($save_fc !== null) {
$smarty->force_compile = $save_fc;
// presumably will be false but put it back anyway
}
return $str;
}
} else {
$smarty->assign('msg', tra("No field indicated"));
return $smarty->fetch("error_raw.tpl");
}
}
return $back;
}
function wikiplugin_fancytable($data, $params)
{
global $prefs;
$tagremove = array();
$pluginremove = array();
static $iFancytable = 0;
++$iFancytable;
extract($params, EXTR_SKIP);
if (empty($sortable)) {
$sortable = 'n';
}
$msg = '';
if (isset($sortable) && $sortable != 'n') {
if (Table_Check::isEnabled()) {
$ts = new Table_Plugin();
$ts->setSettings('wpfancytable' . $iFancytable, 'n', $sortable, isset($sortList) ? $sortList : null, isset($tsortcolumns) ? $tsortcolumns : null, isset($tsfilters) ? $tsfilters : null, isset($tsfilteroptions) ? $tsfilteroptions : null, isset($tspaginate) ? $tspaginate : null, isset($tscolselect) ? $tscolselect : null, null, null, isset($tsmathoptions) ? $tsmathoptions : null);
if (is_array($ts->settings)) {
$ts->settings['resizable'] = true;
Table_Factory::build('plugin', $ts->settings);
$sort = true;
} else {
$sort = false;
}
} else {
$sort = false;
}
if ($sort === false) {
if ($prefs['feature_jquery_tablesorter'] === 'n') {
$msg = '<em>' . tra('The jQuery Sortable Tables feature must be activated for the sort feature to work.') . '</em>';
} elseif ($prefs['javascript_enabled'] !== 'y') {
$msg = '<em>' . tra('Javascript must be enabled for the sort feature to work.') . '</em>';
} else {
$msg = '<em>' . tra('Unable to load the jQuery Sortable Tables feature.') . '</em>';
}
}
} else {
$sort = false;
}
//Start the table
$style = $sort === true ? ' style="visibility:hidden"' : '';
$wret = '<div id="wpfancytable' . $iFancytable . '-div"' . $style . ' class="ts-wrapperdiv">' . "\r\t";
$wret .= '<table class="table table-striped table-hover normal" id="wpfancytable' . $iFancytable . '">' . "\r\t";
//Header
if (isset($head)) {
//set header class
if (!empty($headclass)) {
$tdhdr = "\r\t\t\t" . '<th class="' . $headclass . '"';
} else {
$tdhdr = "\r\t\t\t<th";
}
//replace tiki tags, plugins and other enclosing characters with hash strings before creating table so that any
//pipes (| or ~|~) inside aren't mistaken for cell dividers
preprocess_section($head, $tagremove, $pluginremove);
if ($sort) {
$type = 'hs';
} else {
$type = 'h';
}
//now create header table rows
$headrows = process_section($head, $type, '>>', $tdhdr, '</th>', isset($colwidths) ? $colwidths : '', isset($headaligns) ? $headaligns : '', isset($headvaligns) ? $headvaligns : '');
//restore original tags and plugin syntax
$headhtml = $headrows['html'];
postprocess_section($headhtml, $tagremove, $pluginremove);
$wret .= '<thead>' . $headhtml . "\r\t" . '</thead>' . "\r\t";
}
//Body
//replace tiki tags, plugins and other enclosing characters with hash strings before creating table so that any
//pipes (| or ~|~) inside aren't mistaken for cell dividers
preprocess_section($data, $tagremove, $pluginremove);
if ($sort) {
$type = 'bs';
//sortable body rows - do not assign odd/even class to these since jquery will do it
} else {
$type = 'b';
//plain body rows
}
//now create table body rows
$bodyrows = process_section($data, $type, "\n", "\r\t\t\t" . '<td', '</td>', isset($colwidths) ? $colwidths : '', isset($colaligns) ? $colaligns : '', isset($colvaligns) ? $colvaligns : '');
//restore original tags and plugin syntax
$bodyhtml = $bodyrows['html'];
postprocess_section($bodyhtml, $tagremove, $pluginremove);
//end the tbody
$wret .= '<tbody>' . $bodyhtml . "\r\t" . '</tbody>';
if (isset($ts->settings)) {
$footer = Table_Totals::getTotalsHtml($ts->settings, $bodyrows['cols']);
if ($footer) {
$wret .= $footer;
}
}
$wret .= "\r" . '</table></div>' . "\r" . $msg;
return $wret;
}
