/** * @desc Muestra todos los equipos registrados */ function showTeams() { global $db, $tpl, $xoopsModule, $xoopsConfig, $adminTemplate; $tpl->assign('lang_existing', _AS_TC_EXISTING); $tpl->assign('lang_id', _AS_TC_ID); $tpl->assign('lang_image', _AS_TC_IMAGE); $tpl->assign('lang_name', _AS_TC_NAME); $tpl->assign('lang_catego', _AS_TC_CATEGO); $tpl->assign('lang_coachs', _AS_TC_COACHS); $tpl->assign('lang_options', _OPTIONS); $tpl->assign('lang_edit', _EDIT); $tpl->assign('lang_delete', _DELETE); $tpl->assign('lang_confirmm', _AS_TC_CONFM); $tpl->assign('lang_confirm', _AS_TC_CONFDEL); $tpl->assign('lang_date', _AS_TC_DATE); $tpl->assign('lang_players', _AS_TC_PLAYERS); $result = $db->query("SELECT * FROM " . $db->prefix("coach_teams") . " ORDER BY name"); $teams = array(); while ($row = $db->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $cat = new TCCategory($team->category()); $coachs = ''; foreach ($team->coachs(true) as $coach) { $coachs .= $coachs == '' ? $coach->name() : '<br />' . $coach->name(); } $teams[] = array('id' => $team->id(), 'name' => $team->name(), 'image' => $team->image(), 'catego' => $cat->name(), 'coachs' => $coachs, 'date' => formatTimestamp($team->created(), 'c')); } xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . _AS_TC_TEAMSLOC); xoops_cp_header(); include RMTemplate::get()->get_template("admin/coach_teams.php", 'module', 'team'); xoops_cp_footer(); }
function showPlayers() { global $xoopsModule, $mc, $adminTemplate, $tpl, $db; $gteam = TCFunctions::get('team'); $team = new TCTeam($gteam); // Equipos $tpl->assign('team', $team->isNew() ? 0 : $team->id()); $result = $db->query("SELECT * FROM " . $db->prefix("coach_teams") . " ORDER BY name"); $teams = array(); while ($row = $db->fetchArray($result)) { $ct = new TCTeam(); $ct->assignVars($row); $cat =& $ct->category(true); $teams[] = array('id' => $ct->id(), 'name' => $ct->name() . " (" . $cat->name() . ")"); } // Entrenadores $coachs = array(); if (!$team->isNew()) { foreach ($team->coachs(true) as $coach) { $coachs[] = array('id' => $coach->id(), 'name' => $coach->name(), 'image' => $coach->image()); } } // Jugadores $result = $db->query("SELECT * FROM " . $db->prefix("coach_players") . " WHERE team='" . $team->id() . "'"); $players = array(); while ($row = $db->fetchArray($result)) { $player = new TCPlayer(); $player->assignVars($row); $players[] = array('id' => $player->id(), 'name' => $player->name(), 'image' => $player->image(), 'number' => $player->number(), 'age' => $player->age(), 'date' => formatTimestamp($player->date(), 'c')); } xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . __('Jugadores', 'admin_team')); xoops_cp_header(); include RMTemplate::get()->get_template("admin/coach_players.php", 'module', 'team'); xoops_cp_footer(); }
function formCoachs($edit = 0) { global $xoopsModule, $db, $mc, $xoopsConfig; if ($edit) { $id = TCFunctions::get('id'); if ($id <= 0) { redirectMsg('coachs.php', __('Id no válido', 'admin_team'), 1); die; } $coach = new TCCoach($id); if ($coach->isNew()) { redirectMsg('coachs.php', __('El entrenador especificado no existe', 'admin_team'), 1); die; } } xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./coachs.php'>" . __('Entrenadores', 'admin_team') . "</a> » " . ($edit ? __('Editar entrenador', 'admin_team') : __('Crear entrenador', 'admin_team'))); $cHead = '<link href="' . TC_URL . '/styles/admin.css" media="all" rel="stylesheet" type="text/css" />'; xoops_cp_header($cHead); $form = new RMForm($edit ? __('Editar Entrenador', 'admin_team') : __('Crear Entrenador', 'admin_team'), 'frmNew', 'coachs.php', 'post'); $form->oddClass('oddForm'); $form->setExtra('enctype="multipart/form-data"'); $form->addElement(new RMFormText(__('Nombre', 'admin_team'), 'name', 50, 150, $edit ? $coach->name() : ''), true); if ($edit) { $form->addElement(new RMFormText(__('Nombre corto', 'admin_team'), 'nameid', 50, 150, $coach->nameId())); } $form->addElement(new RMFormText(__('Cargo', 'admin_team'), 'role', 50, 150, $edit ? $coach->role() : ''), true); $form->addElement(new RMFormFile(__('Imagen', 'admin_team'), 'image', 45, $mc['filesize'] * 1024)); if ($edit && $coach->image() != '') { $form->addElement(new RMFormLabel(__('Imagen actual', 'admin_team'), "<img src='" . XOOPS_URL . "/uploads/teams/coachs/ths/" . $coach->image() . "' alt='' />")); } $form->addElement(new RMFormEditor(__('Biografía', 'admin_team'), 'bio', '90%', '300px', $edit ? $coach->bio('e') : '')); $form->addElement(new RMFormSubTitle(__('Equipos', 'admin_team'), 1)); $ele = new RMFormCheck(__('Seleccionar equipos', 'admin_team')); $ele->asTable(3); $sql = "SELECT * FROM " . $db->prefix("coach_teams") . " ORDER BY name"; $result = $db->query($sql); if ($edit) { $teams = $coach->teams(false); } while ($row = $db->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $cat =& $team->category(true); $ele->addOption($team->name() . " <span class='coachNameCat'>(" . $cat->name() . ")</span>", 'teams[]', $team->id(), $edit ? in_array($team->id(), $teams) ? 1 : 0 : 0); } $form->addElement($ele); $ele = new RMFormButtonGroup(); $ele->addButton('sbt', __('Enviar', 'admin_team'), 'submit'); $ele->addButton('cancel', __('Cancelar', 'admin_team'), 'button', 'onclick="window.location=\'coachs.php\';"'); $form->addElement($ele); $form->addElement(new RMFormHidden('op', $edit ? 'saveedit' : 'save')); if ($edit) { $form->addElement(new RMFormHidden('id', $id)); } $form->display(); xoops_cp_footer(); }
public function teams() { if (empty($this->teams)) { $result = $this->db->query("SELECT * FROM " . $this->db->prefix("coach_teams") . " WHERE cat='" . $this->id() . "'"); while ($row = $this->db->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $this->teams[] = $team; } } return $this->teams; }
function tc_block_players_edit($options, &$form) { $form->addElement(new RMSubTitle(_AS_BKM_BOPTIONS, 1)); // Equipos $ele = new RMSelect(_BK_TC_TEAM, 'options[0]'); $ele->addOption(0, _BK_TC_ALLTEAM, $options[0] > 0 ? 0 : 1); $db =& XoopsDatabaseFactory::getDatabaseConnection(); $result = $db->query("SELECT * FROM " . $db->prefix("coach_teams") . " ORDER BY name"); while ($row = $db->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $cat = $team->category(true); $ele->addOption($row['id_team'], $row['name'] . " (" . $cat->name() . ")", $row['id_team'] == $options[0] ? 1 : 0); } $form->addElement($ele); $form->addElement(new RMText(_BK_TC_NUMBER, 'options[1]', 10, 3, $options[1])); $form->addElement(new RMText(_BK_TC_COLNUMBER, 'options[2]', 10, 3, $options[2])); return $form; }
if ($xoopsDB->getRowsNum($result) == 1) { $row = $xoopsDB->fetchArray($result); $link = XOOPS_URL . "/modules/team/" . ($mc['urlmode'] ? "t/{$row['nameid']}/" : "team.php?id={$row['nameid']}"); header('Location: ' . $link); die; } $xoopsOption['template_main'] = "coach_index.html"; include 'header.php'; $tpl->assign('coach_title', _MS_TC_TITLE); $tpl->assign('lang_comment', _MS_TC_COMMENT); // Categorías $tpl->assign('lang_categos', _MS_TC_CATTITLE); $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("coach_categos") . " ORDER BY name"); $cats = array(); while ($row = $xoopsDB->fetchArray($result)) { $cat = new TCCategory(); $cat->assignVars($row); $cats[$cat->id()] = $cat; $link = TC_URL . '/' . ($mc['urlmode'] ? 'cat/' . $cat->nameId() . '/' : 'category.php?id=' . $cat->id()); $tpl->append('categos', array('id' => $cat->id(), 'name' => $cat->name(), 'desc' => $cat->desc(), 'link' => $link)); } // Equipos $tpl->assign('lang_teams', _MS_TC_TEAMSTITLE); $result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("coach_teams") . " ORDER BY name"); while ($row = $xoopsDB->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $link = TC_URL . '/' . ($mc['urlmode'] ? 't/' . $team->nameId() . '/' : 'team.php?id=' . $team->id()); $tpl->append('teams', array('id' => $team->id(), 'name' => $team->name() . " <em>(" . $cats[$team->category(false)]->name() . ")</em>", 'link' => $link)); } include 'footer.php';
/** * @desc Devuelve los equipos a los que pertenece el entrenador * @return array Objetos {@link TCTeam} */ public function teams($obj = true) { if (empty($this->_teams)) { $this->_teams = array(); $this->_teamsid = array(); $tbl1 = $this->db->prefix("coach_teams"); $tbl2 = $this->db->prefix("coach_teamcoach"); $sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_coach='" . $this->id() . "' AND a.id_team=b.id_team"; $result = $this->db->query($sql); while ($row = $this->db->fetchArray($result)) { $team = new TCTeam(); $team->assignVars($row); $this->_teams[] = $team; $this->_teamsid[] = $team->id(); } } return $obj ? $this->_teams : $this->_teamsid; }