function action_export_items($input)
{
TikiLib::lib('tiki')->allocate_extra('tracker_export_items', function () use($input) {
$trackerId = $input->trackerId->int();
$definition = Tracker_Definition::get($trackerId);
if (!$definition) {
throw new Services_Exception_NotFound();
}
$perms = Perms::get('tracker', $trackerId);
if (!$perms->export_tracker) {
throw new Services_Exception_Denied(tr('Not allowed to export'));
}
$fields = array();
foreach ((array) $input->listfields->int() as $fieldId) {
if ($f = $definition->getField($fieldId)) {
$fields[$fieldId] = $f;
}
}
if (0 === count($fields)) {
throw new Services_Exception(tr('No valid field selected for export'), 400);
}
$showItemId = $input->showItemId->int();
$showStatus = $input->showStatus->int();
$showCreated = $input->showCreated->int();
$showLastModif = $input->showLastModif->int();
$keepItemlinkId = $input->keepItemlinkId->int();
$keepCountryId = $input->keepCountryId->int();
$dateFormatUnixTimestamp = $input->dateFormatUnixTimestamp->int();
$encoding = $input->encoding->text();
if (!in_array($encoding, array('UTF-8', 'ISO-8859-1'))) {
$encoding = 'UTF-8';
}
$separator = $input->separator->none();
$delimitorR = $input->delimitorR->none();
$delimitorL = $input->delimitorL->none();
$cr = $input->CR->none();
$recordsMax = $input->recordsMax->int();
$recordsOffset = $input->recordsOffset->int() - 1;
$writeCsv = function ($fields) use($separator, $delimitorL, $delimitorR, $encoding, $cr) {
$values = array();
foreach ($fields as $v) {
$values[] = "{$delimitorL}{$v}{$delimitorR}";
}
$line = implode($separator, $values);
$line = str_replace(array("\r\n", "\n", "<br/>", "<br />"), $cr, $line);
if ($encoding === 'ISO-8859-1') {
echo utf8_decode($line) . "\n";
} else {
echo $line . "\n";
}
};
session_write_close();
$trklib = TikiLib::lib('trk');
$trklib->write_export_header($encoding, $trackerId);
$header = array();
if ($showItemId) {
$header[] = 'itemId';
}
if ($showStatus) {
$header[] = 'status';
}
if ($showCreated) {
$header[] = 'created';
}
if ($showLastModif) {
$header[] = 'lastModif';
}
foreach ($fields as $f) {
$header[] = $f['name'] . ' -- ' . $f['fieldId'];
}
$writeCsv($header);
/** @noinspection PhpParamsInspection */
$items = $trklib->list_items($trackerId, $recordsOffset, $recordsMax, 'itemId_asc', $fields);
$smarty = TikiLib::lib('smarty');
$smarty->loadPlugin('smarty_modifier_tiki_short_datetime');
foreach ($items['data'] as $row) {
$toDisplay = array();
if ($showItemId) {
$toDisplay[] = $row['itemId'];
}
if ($showStatus) {
$toDisplay[] = $row['status'];
}
if ($showCreated) {
if ($dateFormatUnixTimestamp) {
$toDisplay[] = $row['created'];
} else {
$toDisplay[] = smarty_modifier_tiki_short_datetime($row['created'], '', 'n');
}
}
if ($showLastModif) {
if ($dateFormatUnixTimestamp) {
$toDisplay[] = $row['lastModif'];
} else {
$toDisplay[] = smarty_modifier_tiki_short_datetime($row['lastModif'], '', 'n');
}
}
foreach ($row['field_values'] as $val) {
if ($keepItemlinkId && $val['type'] == 'r') {
$toDisplay[] = $val['value'];
} elseif ($keepCountryId && $val['type'] == 'y') {
$toDisplay[] = $val['value'];
} elseif ($dateFormatUnixTimestamp && $val['type'] == 'f') {
$toDisplay[] = $val['value'];
} elseif ($dateFormatUnixTimestamp && $val['type'] == 'j') {
$toDisplay[] = $val['value'];
} else {
$toDisplay[] = $trklib->get_field_handler($val, $row)->renderOutput(array('list_mode' => 'csv', 'CR' => $cr, 'delimitorL' => $delimitorL, 'delimitorR' => $delimitorR));
}
}
$writeCsv($toDisplay);
}
});
exit;
}
<td style="text-align:right;" class="<?php
echo smarty_function_cycle(array('advance' => false), $this);
?>
"><?php
echo $this->_tpl_vars['listpages'][$this->_sections['changes']['index']]['hits'];
?>
</td>
<?php
}
if ($this->_tpl_vars['wiki_list_lastmodif'] == 'y') {
?>
<td class="<?php
echo smarty_function_cycle(array('advance' => false), $this);
?>
"><?php
echo is_array($_tmp = $this->_tpl_vars['listpages'][$this->_sections['changes']['index']]['lastModif']) ? $this->_run_mod_handler('tiki_short_datetime', true, $_tmp) : smarty_modifier_tiki_short_datetime($_tmp);
?>
</td>
<?php
}
if ($this->_tpl_vars['wiki_list_creator'] == 'y') {
?>
<td class="<?php
echo smarty_function_cycle(array('advance' => false), $this);
?>
"><?php
echo is_array($_tmp = $this->_tpl_vars['listpages'][$this->_sections['changes']['index']]['creator']) ? $this->_run_mod_handler('userlink', true, $_tmp) : smarty_modifier_userlink($_tmp);
?>
</td>
<?php
}
"><?php
echo $this->_tpl_vars['msgs'][$this->_sections['ix']['index']]['subject'];
?>
</a>
</td>
<td class="<?php
echo smarty_function_cycle(array('advance' => false), $this);
?>
"><?php
echo $this->_tpl_vars['msgs'][$this->_sections['ix']['index']]['user_from'];
?>
</td><td class="<?php
echo smarty_function_cycle(array(), $this);
?>
"><?php
echo is_array($_tmp = $this->_tpl_vars['msgs'][$this->_sections['ix']['index']]['date']) ? $this->_run_mod_handler('tiki_short_datetime', true, $_tmp) : smarty_modifier_tiki_short_datetime($_tmp);
?>
</td></tr>
<?php
}
}
?>
</table>
</div>
</div>
<?php
}
?>
<?php
if ($this->_tpl_vars['feature_tasks'] == 'y' && $this->_tpl_vars['mytiki_tasks'] == 'y') {
function action_export_items($input)
{
@ini_set('max_execution_time', 0);
//will not work in safe_mode is on
$trackerId = $input->trackerId->int();
$definition = Tracker_Definition::get($trackerId);
if (!$definition) {
throw new Services_Exception_NotFound();
}
$perms = Perms::get('tracker', $trackerId);
if (!$perms->export_tracker) {
throw new Services_Exception(tr('Not allowed to export'), 403);
}
$fields = array();
foreach ((array) $input->listfields->int() as $fieldId) {
if ($f = $definition->getField($fieldId)) {
$fields[$fieldId] = $f;
}
}
if (0 === count($fields)) {
throw new Services_Exception(tr('No valid field selected for export'), 400);
}
$showItemId = $input->showItemId->int();
$showStatus = $input->showStatus->int();
$showCreated = $input->showCreated->int();
$showLastModif = $input->showLastModif->int();
$keepItemlinkId = $input->keepItemlinkId->int();
$encoding = $input->encoding->text();
if (!in_array($encoding, array('UTF-8', 'ISO-8859-1'))) {
$encoding = 'UTF-8';
}
$separator = $input->separator->none();
$delimitorR = $input->delimitorR->none();
$delimitorL = $input->delimitorL->none();
$cr = $input->CR->none();
$recordsMax = $input->recordsMax->int();
$recordsOffset = $input->recordsOffset->int() - 1;
session_write_close();
$trklib = TikiLib::lib('trk');
$trklib->write_export_header($encoding, $trackerId);
$header = array();
if ($showItemId) {
$header[] = 'itemId';
}
if ($showStatus) {
$header[] = 'status';
}
if ($showCreated) {
$header[] = 'created';
}
if ($showLastModif) {
$header[] = 'lastModif';
}
foreach ($fields as $f) {
$header[] = $f['name'] . ' -- ' . $f['fieldId'];
}
$this->writeCsv($header, $separator, $delimitorL, $delimitorR, $encoding);
$items = $trklib->list_items($trackerId, $recordsOffset, $recordsMax, 'itemId_asc', $fields);
$smarty = TikiLib::lib('smarty');
$smarty->loadPlugin('smarty_modifier_tiki_short_datetime');
foreach ($items['data'] as $row) {
$toDisplay = array();
if ($showItemId) {
$toDisplay[] = $row['itemId'];
}
if ($showStatus) {
$toDisplay[] = $row['status'];
}
if ($showCreated) {
$toDisplay[] = smarty_modifier_tiki_short_datetime($row['created'], '', 'n');
}
if ($showLastModif) {
$toDisplay[] = smarty_modifier_tiki_short_datetime($row['lastModif'], '', 'n');
}
foreach ($row['field_values'] as $val) {
if ($keepItemlinkId && $val['type'] == 'r') {
$toDisplay[] = $val['value'];
} else {
$toDisplay[] = $trklib->get_field_handler($val)->renderOutput(array('list_mode' => 'csv'));
}
}
$this->writeCsv($toDisplay, $separator, $delimitorL, $delimitorR, $encoding, $cr);
}
exit;
}
smarty_core_load_plugins(array('plugins' => array(array('modifier', 'tiki_short_datetime', 'tiki-top_bar.tpl', 4, false), array('function', 'phplayers', 'tiki-top_bar.tpl', 12, false))), $this);
?>
This is TikiWiki 1.9.5 -Sirius- © 2002–2006 by the <a href="http://tikiwiki.org"
title="tikiwiki.org">Tiki community</a>
<?php
if ($this->_tpl_vars['feature_calendar'] == 'y' && $this->_tpl_vars['tiki_p_view_calendar'] == 'y') {
?>
<a href="tiki-calendar.php"><?php
echo is_array($_tmp = time()) ? $this->_run_mod_handler('tiki_short_datetime', true, $_tmp) : smarty_modifier_tiki_short_datetime($_tmp);
?>
</a>
<?php
} else {
?>
<?php
echo is_array($_tmp = time()) ? $this->_run_mod_handler('tiki_short_datetime', true, $_tmp) : smarty_modifier_tiki_short_datetime($_tmp);
?>
<?php
}
if ($this->_tpl_vars['tiki_p_admin'] == 'y' && $this->_tpl_vars['feature_debug_console'] == 'y') {
?>
 // <a href="javascript:toggle('debugconsole');">debug</a>
<?php
}
if ($this->_tpl_vars['feature_phplayers'] == 'y' && $this->_tpl_vars['feature_siteidentity'] == 'y' && $this->_tpl_vars['feature_sitemenu'] == 'y') {
echo smarty_function_phplayers(array('id' => 42, 'type' => 'horiz'), $this);
?>
<?php
}
