/**
* @desc Visualiza todos los logs existentes para un determinado software
**/
function showLogs()
{
global $tpl, $xoopsConfig, $xoopsModule, $functions, $xoopsSecurity;
define('RMCSUBLOCATION', 'itemlogs');
$item = isset($_REQUEST['item']) ? intval($_REQUEST['item']) : 0;
$sw = new DTSoftware($item);
$db = XoopsDatabaseFactory::getDatabaseConnection();
$tc = TextCleaner::getInstance();
$tf = new RMTimeFormatter(0, __('%m%-%d%-%Y%', 'dtransport'));
$sql = "SELECT * FROM " . $db->prefix('dtrans_logs') . " WHERE id_soft={$item}";
$result = $db->queryF($sql);
while ($rows = $db->fetchArray($result)) {
$log = new DTLog();
$log->assignVars($rows);
$logs[] = array('id' => $log->id(), 'title' => $log->title(), 'log' => $tc->truncate($tc->clean_disabled_tags($log->log()), 80), 'date' => $tf->format($log->date()));
}
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./items.php'>" . sprintf(_AS_DT_SW, $sw->getVar('name')) . "</a> » " . _AS_DT_LOGS);
$functions->toolbar();
$tpl->add_style('admin.css', 'dtransport');
$tpl->add_local_script('admin.js', 'dtransport');
$tpl->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include');
include DT_PATH . '/include/js_strings.php';
xoops_cp_header();
include $tpl->get_template('admin/dtrans_logs.php', 'module', 'dtransport');
xoops_cp_footer();
}
/**
* Save feature
*/
function dt_save_log($edit)
{
global $item, $log, $tpl, $xoopsTpl, $mc, $dtfunc;
$query = '';
foreach ($_POST as $k => $v) {
${$k} = $v;
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
if ($edit) {
//Verificamos que la característica exista
$lg = new DTLog($log);
if ($lg->isNew()) {
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/logs/' . $item->id() . '/' : '/?p=cpanel&action=logs&id=' . $item->id()), 1, __('Specified log does not exists!', 'dtransport'));
}
} else {
$lg = new DTLog();
}
$tc = TextCleaner::getInstance();
//Comprueba que el título de la característica no exista
$sql = "SELECT COUNT(*) FROM " . $db->prefix('dtrans_logs') . " WHERE title='{$title}' AND id_log!=" . $lg->id() . " AND id_soft=" . $item->id();
list($num) = $db->fetchRow($db->queryF($sql));
if ($num > 0) {
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/logs/' . $item->id() . '/edit/' . $lg->id() : '/?p=cpanel&action=logs&id=' . $item->id() . '/&op=edit&log=' . $lg->id()), 1, __('Another log with same title already exists!', 'dtransport'));
}
$lg->setSoftware($item->id());
$lg->setTitle($title);
$lg->setLog($content);
$lg->setDate(time());
if (!$lg->save()) {
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/logs/' . $item->id() . '/' : '/?p=cpanel&action=logs&id=' . $item->id()), 1, __('Log could not be saved! Please try again.', 'dtransport'));
}
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/logs/' . $item->id() . '/' : '/?p=cpanel&action=logs&id=' . $item->id()), 1, __('Log saved successfully!', 'dtransport'));
}
