/**
* @desc Visualiza todos los archivos de un software
**/
function showFiles()
{
global $xoopsModule, $xoopsSecurity, $tpl;
define("RMCSUBLOCATION", 'fileslist');
$item = rmc_server_var($_REQUEST, 'item', 0);
$edit = rmc_server_var($_REQUEST, 'edit', 0);
$id = rmc_server_var($_REQUEST, 'id', 0);
$db = XoopsDatabaseFactory::getDatabaseConnection();
if ($item <= 0) {
redirectMsg('items.php', __('Before to view files, you must specify a download item!', 'dtransport'), RMMSG_INFO);
}
$sw = new DTSoftware($item);
if ($sw->isNew()) {
redirectMsg('items.php', __('Specified item does not exists!', 'dtransport'), RMMSG_WARN);
}
$files = array();
// Files data container
//Archivos sin grupo
$sql = "SELECT * FROM " . $db->prefix('dtrans_files') . " WHERE id_soft={$item} AND `group`=0";
$result = $db->queryF($sql);
while ($rows = $db->fetchArray($result)) {
$fl = new DTFile();
$fl->assignVars($rows);
$files[] = array('id' => $fl->id(), 'file' => $fl->file(), 'downs' => $fl->hits(), 'group' => $fl->group(), 'default' => $fl->isDefault(), 'remote' => $fl->remote(), 'type' => 'files', 'title' => $fl->title());
}
//Grupos pertenecientes al software
$groups = $sw->filegroups();
foreach ($groups as $k) {
$gr = new DTFileGroup($k);
$files[] = array('id' => $gr->id(), 'file' => $gr->name(), 'type' => 'group');
$sql = "SELECT * FROM " . $db->prefix('dtrans_files') . " WHERE id_soft={$item} AND `group`={$k}";
$result = $db->queryF($sql);
while ($rows = $db->fetchArray($result)) {
$fl = new DTFile();
$fl->assignVars($rows);
$files[] = array('id' => $fl->id(), 'file' => $fl->file(), 'downs' => $fl->hits(), 'group' => $fl->group(), 'default' => $fl->isDefault(), 'remote' => $fl->remote(), 'type' => 'files', 'title' => $fl->title());
}
}
$groups = array();
//Lista de grupos
$sql = "SELECT * FROM " . $db->prefix('dtrans_groups') . " WHERE id_soft={$item}";
$result = $db->queryF($sql);
while ($rows = $db->fetchArray($result)) {
$group = new DTFileGroup();
$group->assignVars($rows);
$groups[] = array('id' => $group->id(), 'name' => $group->name());
}
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./items.php'>" . __('Download Items', 'dtransport') . "</a> » " . __('Files Management', 'dtransport'));
// Title
$title = sprintf(__('Files for "%s"', 'dtransport'), $sw->getVar('name'));
$tpl->assign('xoops_pagetitle', $title);
DTFunctions::toolbar();
$tpl->add_style('admin.css', 'dtransport');
include DT_PATH . '/include/js_strings.php';
$tpl->add_local_script('admin.js', 'dtransport');
$tpl->add_local_script('files.js', 'dtransport');
$tpl->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include');
xoops_cp_header();
include $tpl->get_template('admin/dtrans_files.php', 'module', 'dtransport');
xoops_cp_footer();
}
