/**
* Main function
*
* @return void
*/
function main()
{
global $BE_USER, $LANG, $BACK_PATH, $TCA_DESCR, $TCA, $CLIENT, $TYPO3_CONF_VARS;
$this->content .= $this->doc->header($GLOBALS['LANG']->getLL('adminLog'));
$this->content .= $this->doc->spacer(5);
// Menu compiled:
$menuU = t3lib_BEfunc::getFuncMenu(0, 'SET[users]', $this->MOD_SETTINGS['users'], $this->MOD_MENU['users']);
$menuM = t3lib_BEfunc::getFuncMenu(0, 'SET[max]', $this->MOD_SETTINGS['max'], $this->MOD_MENU['max']);
$menuT = t3lib_BEfunc::getFuncMenu(0, 'SET[time]', $this->MOD_SETTINGS['time'], $this->MOD_MENU['time']);
$menuA = t3lib_BEfunc::getFuncMenu(0, 'SET[action]', $this->MOD_SETTINGS['action'], $this->MOD_MENU['action']);
$menuW = t3lib_BEfunc::getFuncMenu(0, 'SET[workspaces]', $this->MOD_SETTINGS['workspaces'], $this->MOD_MENU['workspaces']);
$groupByPage = t3lib_BEfunc::getFuncCheck(0, 'SET[groupByPage]', $this->MOD_SETTINGS['groupByPage']);
$style = ' style="margin:4px 2px;padding:1px;vertical-align:middle;width: 115px;"';
$inputDate = '<input type="text" value="' . ($this->MOD_SETTINGS['manualdate'] ? $this->MOD_SETTINGS['manualdate'] : '') . '" name="SET[manualdate]" id="tceforms-datetimefield-manualdate"' . $style . ' />';
$pickerInputDate = '<img' . t3lib_iconWorks::skinImg($this->backPath, 'gfx/datepicker.gif', '', 0) . ' style="cursor:pointer; vertical-align:middle;" alt=""' . ' id="picker-tceforms-datetimefield-manualdate" />';
$inputDate_end = '<input type="text" value="' . ($this->MOD_SETTINGS['manualdate_end'] ? $this->MOD_SETTINGS['manualdate_end'] : '') . '" name="SET[manualdate]" id="tceforms-datetimefield-manualdate_end"' . $style . ' />';
$pickerInputDate_end = '<img' . t3lib_iconWorks::skinImg($this->backPath, 'gfx/datepicker.gif', '', 0) . ' style="cursor:pointer; vertical-align:middle;" alt=""' . ' id="picker-tceforms-datetimefield-manualdate_end" />';
$setButton = '<input type="button" value="' . $GLOBALS['LANG']->getLL('set') . '" onclick="jumpToUrl(\'mod.php?&id=0&M=tools_log&SET[manualdate]=\'+escape($(\'tceforms-datetimefield-manualdate\').value)+\'&SET[manualdate_end]=\'+escape($(\'tceforms-datetimefield-manualdate_end\').value),this);" />';
$this->content .= $this->doc->section('', $this->doc->menuTable(array(array($GLOBALS['LANG']->getLL('users'), $menuU), array($GLOBALS['LANG']->getLL('time'), $menuT . ($this->MOD_SETTINGS['time'] == 30 ? '<br />' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:from', true) . ' ' . $inputDate . $pickerInputDate . ' ' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:to', true) . ' ' . $inputDate_end . $pickerInputDate_end . ' ' . $setButton : ''))), array(array($GLOBALS['LANG']->getLL('max'), $menuM), array($GLOBALS['LANG']->getLL('action'), $menuA)), array($GLOBALS['BE_USER']->workspace !== 0 ? array($GLOBALS['LANG']->getLL('workspace'), '<strong>' . $GLOBALS['BE_USER']->workspace . '</strong>') : array($GLOBALS['LANG']->getLL('workspace'), $menuW), array($GLOBALS['LANG']->getLL('groupByPage'), $groupByPage))));
$codeArr = $this->lF->initArray();
$oldHeader = '';
$c = 0;
// Action (type):
$where_part = '';
if ($this->MOD_SETTINGS['action'] > 0) {
$where_part .= ' AND type=' . intval($this->MOD_SETTINGS['action']);
} elseif ($this->MOD_SETTINGS['action'] == -1) {
$where_part .= ' AND error != 0';
}
$starttime = 0;
$endtime = $GLOBALS['EXEC_TIME'];
// Time:
switch ($this->MOD_SETTINGS['time']) {
case 0:
// This week
$week = (date('w') ? date('w') : 7) - 1;
$starttime = mktime(0, 0, 0) - $week * 3600 * 24;
break;
case 1:
// Last week
$week = (date('w') ? date('w') : 7) - 1;
$starttime = mktime(0, 0, 0) - ($week + 7) * 3600 * 24;
$endtime = mktime(0, 0, 0) - $week * 3600 * 24;
break;
case 2:
// Last 7 days
$starttime = mktime(0, 0, 0) - 7 * 3600 * 24;
break;
case 10:
// This month
$starttime = mktime(0, 0, 0, date('m'), 1);
break;
case 11:
// Last month
$starttime = mktime(0, 0, 0, date('m') - 1, 1);
$endtime = mktime(0, 0, 0, date('m'), 1);
break;
case 12:
// Last 31 days
$starttime = mktime(0, 0, 0) - 31 * 3600 * 24;
break;
case 30:
$starttime = $this->theTime;
if ($this->theTime_end) {
$endtime = $this->theTime_end;
} else {
$endtime = $GLOBALS['EXEC_TIME'];
}
}
if ($starttime) {
$where_part .= ' AND tstamp>=' . $starttime . ' AND tstamp<' . $endtime;
}
// Users
$selectUsers = array();
if (substr($this->MOD_SETTINGS['users'], 0, 3) == "gr-") {
// All users
$this->be_user_Array = t3lib_BEfunc::blindUserNames($this->be_user_Array, array(substr($this->MOD_SETTINGS['users'], 3)), 1);
if (is_array($this->be_user_Array)) {
foreach ($this->be_user_Array as $val) {
if ($val['uid'] != $BE_USER->user['uid']) {
$selectUsers[] = $val['uid'];
}
}
}
$selectUsers[] = 0;
$where_part .= ' AND userid in (' . implode($selectUsers, ',') . ')';
} elseif (substr($this->MOD_SETTINGS['users'], 0, 3) == "us-") {
// All users
$selectUsers[] = intval(substr($this->MOD_SETTINGS['users'], 3));
$where_part .= ' AND userid in (' . implode($selectUsers, ',') . ')';
} elseif ($this->MOD_SETTINGS['users'] == -1) {
$where_part .= ' AND userid=' . $BE_USER->user['uid'];
// Self user
}
// Workspace
if ($GLOBALS['BE_USER']->workspace !== 0) {
$where_part .= ' AND workspace=' . intval($GLOBALS['BE_USER']->workspace);
} elseif ($this->MOD_SETTINGS['workspaces'] != -99) {
$where_part .= ' AND workspace=' . intval($this->MOD_SETTINGS['workspaces']);
}
// Finding out which page ids are in the log:
$logPids = array();
if ($this->MOD_SETTINGS['groupByPage']) {
$log = $GLOBALS['TYPO3_DB']->exec_SELECTquery('event_pid', 'sys_log', '1=1' . $where_part, 'event_pid');
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($log)) {
$logPids[] = $row['event_pid'];
}
// Overview:
$overviewList = array();
foreach ($logPids as $pid) {
if ((int) $pid > 0) {
$overviewList[] = htmlspecialchars(sprintf($GLOBALS['LANG']->getLL('pagenameWithUID'), t3lib_BEfunc::getRecordPath($pid, '', 20), $pid));
}
}
sort($overviewList);
$this->content .= $this->doc->divider(5);
$this->content .= $this->doc->section($GLOBALS['LANG']->getLL('overview'), sprintf($GLOBALS['LANG']->getLL('timeInfo'), date($this->dateFormat, $starttime), date($this->dateFormat, $endtime)) . '<br /><br /><br />' . implode('<br />', $overviewList), 1, 1, 0);
$this->content .= $this->doc->spacer(30);
} else {
$logPids[] = '_SINGLE';
}
foreach ($logPids as $pid) {
$codeArr = $this->lF->initArray();
$this->lF->reset();
$oldHeader = '';
$this->content .= $this->doc->divider(5);
switch ($pid) {
case '_SINGLE':
$insertMsg = '';
break;
case '-1':
$insertMsg = ' ' . $GLOBALS['LANG']->getLL('forNonPageRelatedActions') . ' ';
break;
case '0':
$insertMsg = ' ' . $GLOBALS['LANG']->getLL('forRootLevel') . ' ';
break;
default:
$insertMsg = ' ' . sprintf($GLOBALS['LANG']->getLL('forPage'), t3lib_BEfunc::getRecordPath($pid, '', 20), $pid) . ' ';
break;
}
$this->content .= $this->doc->section(sprintf($GLOBALS['LANG']->getLL('logForNonPageRelatedActionsOrRootLevelOrPage'), $insertMsg, date($this->dateFormat, $starttime), date($this->dateFormat, $endtime)), '', 1, 1, 0);
$log = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'sys_log', '1=1' . $where_part . ($pid != '_SINGLE' ? ' AND event_pid=' . intval($pid) : ''), '', 'uid DESC', intval($this->MOD_SETTINGS['max']));
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($log)) {
$header = $this->doc->formatTime($row['tstamp'], 10);
if (!$oldHeader) {
$oldHeader = $header;
}
if ($header != $oldHeader) {
$this->content .= $this->doc->spacer(10);
$this->content .= $this->doc->section($oldHeader, $this->doc->table($codeArr));
$codeArr = $this->lF->initArray();
$oldHeader = $header;
$this->lF->reset();
}
$i++;
$codeArr[$i][] = $this->lF->getTimeLabel($row['tstamp']);
$codeArr[$i][] = $this->lF->getUserLabel($row['userid'], $row['workspace']);
$codeArr[$i][] = $this->lF->getTypeLabel($row['type']);
$codeArr[$i][] = $row['error'] ? $this->lF->getErrorFormatting($this->lF->errorSign[$row['error']], $row['error']) : '';
$codeArr[$i][] = $this->lF->getActionLabel($row['type'] . '_' . $row['action']);
$codeArr[$i][] = $this->lF->formatDetailsForList($row);
}
$this->content .= $this->doc->spacer(10);
$this->content .= $this->doc->section($header, $this->doc->table($codeArr));
$GLOBALS['TYPO3_DB']->sql_free_result($log);
}
// Setting up the buttons and markers for docheader
$docHeaderButtons = $this->getButtons();
//$markers['CSH'] = $docHeaderButtons['csh'];
$markers['CONTENT'] = $this->content;
// Build the <body> for the module
$this->content = $this->doc->startPage($GLOBALS['LANG']->getLL('adminLog'));
$this->content .= $this->doc->moduleBody($this->pageinfo, $docHeaderButtons, $markers);
$this->content .= $this->doc->endPage();
$this->content = $this->doc->insertStylesAndJS($this->content);
}