function showCoachs()
{
global $xoopsModule, $tpl, $db;
$result = $db->query("SELECT * FROM " . $db->prefix("coach_coachs") . " ORDER BY name");
$coachs = array();
while ($row = $db->fetchArray($result)) {
$coach = new TCCoach();
$coach->assignVars($row);
$coachs[] = array('id' => $coach->id(), 'name' => $coach->name(), 'image' => $coach->image(), 'created' => $coach->created());
}
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . _AS_TC_COACHSLOC);
xoops_cp_header();
include RMTemplate::get()->get_template("admin/coach_coachs.php", 'module', 'team');
xoops_cp_footer();
}
function formTeams($edit = 0)
{
global $db, $xoopsModule, $mc, $xoopsConfig;
if ($edit) {
$id = TCFunctions::get('id');
if ($id <= 0) {
redirectMsg('teams.php', __('Id not valid', 'admin_team'), 1);
die;
}
$team = new TCTeam($id);
if ($team->isNew()) {
redirectMsg('teams.php', __('No existe el equipo especificado', 'admin_team'), 1);
die;
}
}
xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » <a href='./teams.php'>" . __('Equipos', 'admin_team') . "</a>\n\t\t\t» " . ($edit ? __('Editar Equipo', 'admin_team') : __('Crear Equipo', 'admin_team')));
xoops_cp_header();
$form = new RMForm($edit ? __('Editar Equipo', 'admin_team') : __('Crear Equipo', 'admin_team'), 'frmTeam', 'teams.php');
$form->setExtra('enctype="multipart/form-data"');
$form->oddClass('oddForm');
$ele = new RMFormRadio(__('Categoría', 'admin_team'), 'cat', 0, 1, 1);
$result = $db->query("SELECT * FROM " . $db->prefix("coach_categos") . " ORDER BY name");
while ($row = $db->fetchArray($result)) {
$ele->addOption($row['name'], $row['id_cat'], $edit ? $team->category() == $row['id_cat'] ? 1 : 0 : 0);
}
$form->addElement($ele, true, 'checked');
$form->addElement(new RMFormText(__('Nombre', 'admin_team'), 'name', 50, 100, $edit ? $team->name() : ''), true);
if ($edit) {
$form->addElement(new RMFormText(__('Nombre corto', 'admin_team'), 'nameid', 50, 100, $edit ? $team->nameId() : ''));
}
$form->addElement(new RMFormFile(__('Imagen', 'admin_team'), 'image', 46, $mc['filesize'] * 1024));
if ($edit && $team->image() != '') {
$form->addElement(new RMFormLabel(__('Imagen actual', 'admin_team'), '<img src="' . XOOPS_URL . '/uploads/teams/ths/' . $team->image() . '" alt="" />'));
}
$form->addElement(new RMFormEditor(__('Información', 'admin_team'), 'desc', '90%', '300px', $edit ? $team->desc('e') : ''));
if ($edit) {
$html = $team->getVar('dohtml');
$xcode = $team->getVar('doxcode');
$doimage = $team->getVar('doimage');
$smiley = $team->getVar('dosmiley');
$br = $team->getVar('dobr');
} else {
$html = $xoopsConfig['editor_type'] == 'tiny' ? 1 : 0;
$xcode = $xoopsConfig['editor_type'] == 'tiny' ? 0 : 1;
$doimage = $xoopsConfig['editor_type'] == 'tiny' ? 0 : 1;
$smiley = $xoopsConfig['editor_type'] == 'tiny' ? 0 : 1;
$br = $xoopsConfig['editor_type'] == 'tiny' ? 0 : 1;
}
$form->addElement(new RMFormTextOptions(__('Opciones', 'admin_team'), $html, $xcode, $doimage, $smiley, $br));
$form->addElement(new RMFormSubTitle(__('Entrenadores', 'admin_team'), 1));
$ele = new RMFormCheck(__('Entrenadores', 'admin_team'));
$ele->asTable(3);
$result = $db->query("SELECT * FROM " . $db->prefix("coach_coachs") . " ORDER BY name");
if ($edit) {
$coachs = $team->coachs(false);
}
while ($row = $db->fetchArray($result)) {
$coach = new TCCoach();
$coach->assignVars($row);
$ele->addOption($coach->name(), 'coachs[]', $coach->id(), $edit ? in_array($coach->id(), $coachs) ? 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=\'teams.php\';"');
$form->addElement($ele);
$form->addElement(new RMFormHidden('op', $edit ? 'saveedit' : 'save'));
if ($edit) {
$form->addElement(new RMFormHidden('id', $team->id()));
}
$form->display();
xoops_cp_footer();
}
/**
* @desc Devuelve los entrenadores del equipo
* @return array Objetos {@link TCCoach}
*/
public function coachs($obj = true)
{
if (empty($this->_coachs)) {
$this->_teams = array();
$this->_teamsid = array();
$tbl1 = $this->db->prefix("coach_coachs");
$tbl2 = $this->db->prefix("coach_teamcoach");
$sql = "SELECT a.* FROM {$tbl1} a, {$tbl2} b WHERE b.id_team='" . $this->id() . "' AND a.id_coach=b.id_coach";
$result = $this->db->query($sql);
while ($row = $this->db->fetchArray($result)) {
$coach = new TCCoach();
$coach->assignVars($row);
$this->_coachs[] = $coach;
$this->_coachsid[] = $coach->id();
}
}
return $obj ? $this->_coachs : $this->_coachsid;
}
