/**
* @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;
}
