/** * @desc Visualiza las plataformas existentes y muestra formulario de plataformas **/ function showPlatforms($edit = 0) { global $xoopsSecurity, $xoopsModule; $id = rmc_server_var($_REQUEST, 'id', 0); $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT * FROM " . $db->prefix('dtrans_platforms'); $result = $db->queryF($sql); $platforms = array(); while ($rows = $db->fetchArray($result)) { $plat = new DTPlatform(); $plat->assignVars($rows); $platforms[] = array('id' => $plat->id(), 'name' => $plat->name()); } if ($edit) { //Verificamos si plataforma es válida if ($id <= 0) { redirectMsg('platforms.php', __('You must specified a valid platform ID!', 'dtransport'), 1); die; } //Verificamos si plataforma existe $plat = new DTPlatform($id); if ($plat->isNew()) { redirectMsg('platforms.php', __('Sepecified platform does not exists!', 'dtransport'), 1); die; } } RMTemplate::get()->add_xoops_style('admin.css', 'dtransport'); RMTemplate::get()->add_local_script('jquery.validate.min.js', 'rmcommon', 'include'); RMTemplate::get()->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include'); RMTemplate::get()->add_local_script('admin.js', 'dtransport'); RMTemplate::get()->add_head('<script type="text/javascript"> var dt_message = "' . __('Do you really want to delete selected platforms', 'dtransport') . '"; var dt_select_message = "' . __('Select at least one platform to delete!', 'dtransport') . '"; </script>'); DTFunctions::toolbar(); xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . ($edit ? __('Edit Platform', 'dtransport') : __('New Platform', 'dtransport'))); xoops_cp_header(); include RMTemplate::get()->get_template('admin/dtrans_platforms.php', 'module', 'dtransport'); xoops_cp_footer(); }
/** * @desc Obtiene las plataformas a las que pertenece el elemento * @param bool True obtiene los objetos {@link DTPlatform} * @return array */ public function platforms($asobj = false) { $tbl1 = $this->db->prefix("dtrans_platsoft"); $tbl2 = $this->db->prefix("dtrans_platforms"); if (empty($this->_platforms) || $asobj && !is_a($this->_platforms, 'DTPlatform')) { $this->_platforms = array(); $sql = "SELECT b.* FROM {$tbl1} a, {$tbl2} b WHERE a.id_soft='" . $this->id() . "' AND b.id_platform=a.id_platform"; $result = $this->db->queryF($sql); while ($rows = $this->db->fetchArray($result)) { if ($asobj) { $tmp = new DTPlatform(); $tmp->assignVars($rows); } else { $tmp = $rows['id_platform']; } $this->_platforms[] = $tmp; } } return $this->_platforms; }
/** * @desc Formulario de Elementos **/ function formItems($edit = 0) { global $xoopsModule, $xoopsConfig, $xoopsModuleConfig, $rmc_config, $xoopsSecurity, $functions; define('RMCSUBLOCATION', 'newitem'); // Get layout data $id = intval(rmc_server_var($_REQUEST, 'id', 0)); $page = intval(rmc_server_var($_REQUEST, 'page', 0)); $search = rmc_server_var($_REQUEST, 'search', ''); $sort = rmc_server_var($_REQUEST, 'sort', 'id_soft'); $mode = intval(rmc_server_var($_REQUEST, 'mode', 0)); $catid = intval(rmc_server_var($_REQUEST, 'car', 0)); $type = rmc_server_var($_REQUEST, 'type', ''); $ev = RMEvents::get(); $params = '?page=' . $page . '&search=' . $search . '&sort=' . $sort . '&mode=' . $mode . '&cat=' . $catid . '&type=' . $type; if ($edit) { //Verificamos que el software sea válido if ($id <= 0) { redirectMsg('items.php' . $params, __('Download item has not been specified!', 'dtransport'), 1); die; } //Verificamos que el software exista if ($type == 'edit') { $sw = new DTSoftwareEdited($id); $location = __('Verifying edited item!', 'dtransport'); } else { $sw = new DTSoftware($id); $location = __('Editing download item', 'dtransport'); } if ($sw->isNew()) { redirectMsg('./items.php' . $params, __('Specified download item does not exists!', 'dtransport'), 1); die; } } else { $sw = new DTSoftware(); $location = __('New Download Item', 'dtransport'); } $form = new RMForm('', '', ''); $ed = new RMFormEditor('', 'desc', '99%', '300px', $edit ? $sw->getVar('desc', $rmc_config['editor_type'] != 'tiny' ? 'e' : 's') : '', $rmc_config['editor_type']); $ed->addClass('required'); $db = XoopsDatabaseFactory::getDatabaseConnection(); //Lista de categorías $categos = array(); $swcats = $sw->categories(); DTFunctions::getCategos($categos, 0, 0, array(), false); foreach ($categos as $row) { $cat = new DTCategory(); $cat->assignVars($row); $categories[] = array('id' => $cat->id(), 'name' => $cat->name(), 'parent' => $cat->parent(), 'active' => $cat->active(), 'description' => $cat->desc(), 'indent' => $row['jumps'], 'selected' => $edit ? in_array($cat->id(), $swcats) : ''); } unset($categos); // Licencias $sql = "SELECT * FROM " . $db->prefix('dtrans_licences'); $result = $db->queryF($sql); $lics = array(); $lics[] = array('id' => 0, 'name' => __('Other license', 'dtransport'), 'selected' => !$edit || in_array(0, $sw->licences()) ? 1 : 0); while ($row = $db->fetchArray($result)) { $lic = new DTLicense(); $lic->assignVars($row); $lics[] = array('id' => $lic->id(), 'name' => $lic->name(), 'selected' => $edit ? in_array($lic->id(), $sw->licences()) : ''); } unset($lic); // Plataformas $sql = "SELECT * FROM " . $db->prefix('dtrans_platforms'); $result = $db->queryF($sql); $oss = array(); $oss[] = array('id' => 0, 'name' => __('Other platform', 'dtransport'), 'selected' => !$edit || in_array(0, $sw->platforms()) ? 1 : 0); while ($row = $db->fetchArray($result)) { $os = new DTPlatform(); $os->assignVars($row); $oss[] = array('id' => $os->id(), 'name' => $os->name(), 'selected' => $edit ? in_array($os->id(), $sw->platforms()) : ''); } unset($os); // Allowed groups $field = new RMFormGroups('', 'groups', 1, 1, 1, $edit ? $sw->getVar('groups') : array(1, 2)); $groups = $field->render(); // Tags $ftags = $sw->tags(true); $tags = array(); foreach ($ftags as $tag) { $tags[] = $tag->getVar('tag'); } unset($ftags); RMTemplate::get()->add_style('admin.css', 'dtransport'); RMTemplate::get()->add_style('items.css', 'dtransport'); RMTemplate::get()->add_local_script('itemsform.js', 'dtransport'); RMTemplate::get()->add_local_script('jquery.validate.min.js', 'rmcommon', 'include'); include DT_PATH . '/include/js_strings.php'; DTFunctions::toolbar(); xoops_cp_location($location); xoops_cp_header(); include RMTemplate::get()->get_template('admin/dtrans_formitems.php', 'module', 'dtransport'); xoops_cp_footer(); }