function display()
{
global $mainframe, $option;
$db =& JFactory::getDBO();
$user =& JFactory::getUser();
$task = JRequest::getVar('task');
$cid = JRequest::getVar('cid', array(0), '', 'array');
$option = JRequest::getCmd('option');
$section = JRequest::getVar('section');
JArrayHelper::toInteger($cid, array(0));
$row =& JTable::getInstance('ligen', 'TableCLM');
// load the row from the db table
$row->load($cid[0]);
// Prüfen ob User Berechtigung zum editieren hat
if ($row->sl !== CLM_ID and CLM_usertype !== 'admin') {
JError::raiseWarning(500, JText::_('PAARUNG_LIGEN'));
if ($row->liga_mt == 1) {
//mtmt
$link = 'index.php?option=' . $option . '§ion=mturniere';
} else {
$link = 'index.php?option=' . $option . '§ion=ligen';
}
$mainframe->redirect($link);
}
// Prüfen ob Runden erstellt sind
if ($row->rnd < 1) {
JError::raiseWarning(500, JText::_('PAARUNG_RUND'));
if ($row->liga_mt == 1) {
//mtmt
$link = 'index.php?option=' . $option . '§ion=mturniere';
} else {
$link = 'index.php?option=' . $option . '§ion=ligen';
}
$mainframe->redirect($link);
}
$row->checkout($user->get('id'));
// Teilnehmer zusammenstellen
$sql = "SELECT a.*, m.name as hname, m.tln_nr as htln, n.name as gname, n.tln_nr as gtln, rt.name as rname " . " FROM #__clm_rnd_man as a" . " LEFT JOIN #__clm_mannschaften as m ON m.tln_nr = a.tln_nr AND m.liga = a.lid AND m.sid = a.sid" . " LEFT JOIN #__clm_mannschaften as n ON n.tln_nr = a.gegner AND n.liga = a.lid AND n.sid = a.sid" . " LEFT JOIN #__clm_liga as l ON a.lid = l.id " . " LEFT JOIN #__clm_runden_termine as rt ON rt.liga = a.lid AND rt.nr = (a.runde + (a.dg-1) * l.runden) " . " WHERE a.sid = " . $row->sid . " AND a.lid = " . $row->id . " AND a.heim = 1" . " ORDER BY a.dg ASC, a.runde ASC, a.paar ASC";
$db->setQuery($sql);
$paarung = $db->loadObjectList();
// Mannschaftsliste
$sql = "SELECT tln_nr, name, rankingpos FROM #__clm_mannschaften " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " ORDER BY tln_nr ASC ";
$db->setQuery($sql);
$man = $db->loadObjectList();
// Mannschaftsliste
$sql = "SELECT COUNT(tln_nr) as tln_nr FROM #__clm_mannschaften " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " ";
$db->setQuery($sql);
$count_man = $db->loadObjectList();
// "spielfrei(e)" Mannschaft suchen //mtmt
$query = " SELECT COUNT(id) as anzahl FROM #__clm_mannschaften as a " . " WHERE sid = " . $row->sid . " AND liga = " . $row->id . " " . " AND a.name = 'spielfrei'" . " ORDER BY a.tln_nr ";
$db->setQuery($query);
$spielfreiNumber = $db->loadObjectList();
if ($spielfreiNumber[0]->anzahl > 1) {
foreach ($man as $key => $value) {
if ($value->name == 'spielfrei') {
$value->name .= " " . $value->tln_nr;
}
}
}
require_once JPATH_COMPONENT . DS . 'views' . DS . 'paarung.php';
CLMViewPaarung::paarung($row, $paarung, $man, $count_man, $option, $cid, $lists);
}
