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);
}
function paarung(&$row, $paarung, $man, $count_man, $option, $cid, &$lists)
{
CLMViewPaarung::setPaarungToolbar($row);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
?>
<h1><?php
echo JText::_('PAARUNG_WARNING_LINE1');
?>
</h1>
<h1><?php
echo JText::_('PAARUNG_WARNING_LINE2');
?>
</h1>
<br>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE3');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE4');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE5');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE6');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE7');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE8');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE9');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE10');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE11');
?>
</h3>
<br>
<form action="index.php" method="post" name="adminForm">
<div class="col width-40">
<fieldset class="adminform">
<legend><?php
echo JText::_('PAARUNG_AKTUELL');
?>
</legend>
<table class="admintable">
<?php
$count = 0;
if ($row->durchgang > 1) {
$runden_counter = 2 * $row->runden;
} else {
$runden_counter = $row->runden;
}
for ($x = 0; $x < $runden_counter; $x++) {
?>
<?php
if ($row->runden_modus == 4) {
$pairings = pow(2, $row->runden - 1 - $x);
} elseif ($row->runden_modus == 5) {
$pairings = pow(2, $row->runden - 2 - $x);
if ($pairings < 1) {
$pairings = 1;
}
} else {
$pairings = $row->teil / 2;
}
?>
<tr>
<td class="key" nowrap="nowrap" colspan="7" height="24"><?php
echo $paarung[$count]->rname;
//JText::_( 'PAARUNG_RUNDE' ).' '.$paarung[$count]->runde;
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap" height="24"><?php
echo JText::_('PAARUNG_DG');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_RUNDE');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_PAAR');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
</tr>
<?php
for ($y = 0; $y < $pairings; $y++) {
?>
<tr>
<td class="key" nowrap="nowrap" height="24"><?php
echo $paarung[$count]->dg;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->runde;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->paar;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->tln_nr;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->gegner;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->hname;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->gname;
?>
</td>
</tr>
<?php
$count++;
}
}
?>
</table>
</fieldset>
</div>
<div class="col width-40">
<fieldset class="adminform">
<legend><?php
echo JText::_('PAARUNG_CHANGED');
?>
</legend>
<table class="admintable">
<?php
$count = 0;
if ($row->durchgang > 1) {
$runden_counter = 2 * $row->runden;
} else {
$runden_counter = $row->runden;
}
for ($x = 0; $x < $runden_counter; $x++) {
if ($row->runden_modus == 4) {
$pairings = pow(2, $row->runden - 1 - $x);
} elseif ($row->runden_modus == 5) {
$pairings = pow(2, $row->runden - 2 - $x);
if ($pairings < 1) {
$pairings = 1;
}
} else {
$pairings = $row->teil / 2;
}
if ($x + 1 > $row->runden) {
$dg = 2;
$cnt = $x - $row->runden;
} else {
$dg = 1;
$cnt = $x;
}
?>
<tr>
<td class="key" nowrap="nowrap" colspan="7" height="24"><?php
echo $paarung[$count]->rname;
// JText::_( 'PAARUNG_RUNDE' ).' '.$paarung[$count]->runde;
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap" height="24"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
</tr>
<?php
for ($y = 0; $y < $pairings; $y++) {
?>
<tr>
<td class="key" nowrap="nowrap" height="24">
<select size="1" name="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Heim';
?>
" id="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Heim';
?>
">
<option value="0"><?php
echo JText::_('PAARUNG_HEIM_WAEHLEN');
?>
</option>
<?php
for ($z = 0; $z < $count_man[0]->tln_nr; $z++) {
if ($row->runden_modus != 4 and $row->runden_modus != 5 or $row->runden_modus == 4 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or ($row->runden_modus == 5 and ($x < $row->runden - 1 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1) or $x == $row->runden - 1 and $man[$z]->rankingpos == $paarung[$count]->runde - 3)) {
//mtmt
?>
<option value="<?php
echo $man[$z]->tln_nr;
?>
" <?php
if ((int) $paarung[$count]->tln_nr == (int) $z + 1) {
?>
selected="selected" <?php
}
?>
><?php
echo $man[$z]->name;
?>
</option>
<?php
}
}
?>
</select>
</td>
<td class="key" nowrap="nowrap">
<select size="1" name="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Gast';
?>
" id="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Gast';
?>
">
<option value="0"><?php
echo JText::_('PAARUNG_GAST_WAEHLEN');
?>
</option>
<?php
for ($z = 0; $z < $count_man[0]->tln_nr; $z++) {
if ($row->runden_modus != 4 and $row->runden_modus != 5 or $row->runden_modus == 4 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or ($row->runden_modus == 5 and ($x < $row->runden - 1 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1) or $x == $row->runden - 1 and $man[$z]->rankingpos == $paarung[$count]->runde - 3)) {
//mtmt
?>
<option value="<?php
echo $man[$z]->tln_nr;
?>
" <?php
if ((int) $paarung[$count]->gegner == (int) $z + 1) {
?>
selected="selected" <?php
}
?>
><?php
echo $man[$z]->name;
?>
</option>
<?php
}
}
?>
</select>
</td>
</tr>
<?php
$count++;
}
}
?>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="section" value="paarung" />
<input type="hidden" name="option" value="com_clm" />
<input type="hidden" name="id" value="<?php
echo $row->id;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHTML::_('form.token');
?>
</form>
<?php
}
public static function paarung(&$row, $paarung, $man, $count_man, $option, $cid, &$lists)
{
CLMViewPaarung::setPaarungToolbar($row);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
//Liga-Parameter aufbereiten
$paramsStringArray = explode("\n", $row->params);
$lparams = array();
foreach ($paramsStringArray as $value) {
$ipos = strpos($value, '=');
if ($ipos !== false) {
$key = substr($value, 0, $ipos);
if (substr($key, 0, 2) == "\\'") {
$key = substr($key, 2, strlen($key) - 4);
}
if (substr($key, 0, 1) == "'") {
$key = substr($key, 1, strlen($key) - 2);
}
$lparams[$key] = substr($value, $ipos + 1);
}
}
if (!isset($lparams['round_date'])) {
//Standardbelegung
$lparams['round_date'] = '0';
}
?>
<h1><?php
echo JText::_('PAARUNG_WARNING_LINE1');
?>
</h1>
<h1><?php
echo JText::_('PAARUNG_WARNING_LINE2');
?>
</h1>
<br>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE3');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE4');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE5');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE6');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE7');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE8');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE9');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE10');
?>
</h3>
<h3><?php
echo JText::_('PAARUNG_WARNING_LINE11');
?>
</h3>
<br>
<form action="index.php" method="post" name="adminForm" id="adminForm">
<div class="width-40 fltlft">
<fieldset class="adminform">
<legend><?php
echo JText::_('PAARUNG_AKTUELL');
?>
</legend>
<table class="paramlist admintable">
<?php
$count = 0;
if ($row->durchgang > 1) {
$runden_counter = $row->durchgang * $row->runden;
} else {
$runden_counter = $row->runden;
}
for ($x = 0; $x < $runden_counter; $x++) {
?>
<?php
if ($row->runden_modus == 4) {
$pairings = pow(2, $row->runden - 1 - $x);
} elseif ($row->runden_modus == 5) {
$pairings = pow(2, $row->runden - 2 - $x);
if ($pairings < 1) {
$pairings = 1;
}
} else {
$pairings = $row->teil / 2;
}
?>
<tr>
<td class="key" nowrap="nowrap" colspan="7" height="24"><b><br><?php
echo $paarung[$count]->rname;
?>
</b></td>
</tr>
<tr>
<td class="key" nowrap="nowrap" height="24"><?php
echo JText::_('PAARUNG_DG');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_RUNDE');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_PAAR');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
<?php
if ($lparams['round_date'] == '1') {
?>
<td class="key" nowrap="nowrap"> <?php
echo JText::_('PAARUNG_DATE');
?>
</td>
<td class="key" nowrap="nowrap"> <?php
echo JText::_('PAARUNG_TIME');
?>
</td>
<?php
}
?>
</tr>
<?php
for ($y = 0; $y < $pairings; $y++) {
?>
<tr>
<td class="key" nowrap="nowrap" height="37"><?php
echo $paarung[$count]->dg;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->runde;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->paar;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->tln_nr;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->gegner;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->hname;
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo $paarung[$count]->gname;
?>
</td>
<?php
if ($lparams['round_date'] == '1') {
?>
<td class="key" nowrap="nowrap"> <?php
echo $paarung[$count]->pdate;
?>
</td>
<td class="key" nowrap="nowrap"> <?php
echo substr($paarung[$count]->ptime, 0, 5);
?>
</td>
<?php
}
?>
</tr>
<?php
$count++;
}
}
?>
</table>
</fieldset>
</div>
<div class="width-60 fltrt">
<fieldset class="adminform">
<legend><?php
echo JText::_('PAARUNG_CHANGED');
?>
</legend>
<table class="paramlist admintable">
<?php
$count = 0;
if ($row->durchgang > 1) {
$runden_counter = $row->durchgang * $row->runden;
} else {
$runden_counter = $row->runden;
}
for ($x = 0; $x < $runden_counter; $x++) {
if ($row->runden_modus == 4) {
$pairings = pow(2, $row->runden - 1 - $x);
} elseif ($row->runden_modus == 5) {
$pairings = pow(2, $row->runden - 2 - $x);
if ($pairings < 1) {
$pairings = 1;
}
} else {
$pairings = $row->teil / 2;
}
if ($x + 1 > 3 * $row->runden) {
$dg = 4;
$cnt = $x - 3 * $row->runden;
} elseif ($x + 1 > 2 * $row->runden) {
$dg = 3;
$cnt = $x - 2 * $row->runden;
} elseif ($x + 1 > $row->runden) {
$dg = 2;
$cnt = $x - $row->runden;
} else {
$dg = 1;
$cnt = $x;
}
?>
<tr>
<td class="key" nowrap="nowrap" colspan="7" height="24"><b><br><?php
echo $paarung[$count]->rname;
?>
</b></td>
</tr>
<tr>
<td class="key" nowrap="nowrap" height="24"><?php
echo JText::_('PAARUNG_HEIM');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_GAST');
?>
</td>
<?php
if ($lparams['round_date'] == '1') {
?>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_DATE');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_TIME');
?>
</td>
<?php
}
?>
</tr>
<?php
for ($y = 0; $y < $pairings; $y++) {
?>
<tr>
<td class="key" nowrap="nowrap" height="24">
<select size="1" name="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Heim';
?>
" id="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Heim';
?>
">
<option value="0"><?php
echo JText::_('PAARUNG_HEIM_WAEHLEN');
?>
</option>
<?php
for ($z = 0; $z < $count_man[0]->tln_nr; $z++) {
if ($row->runden_modus != 4 and $row->runden_modus != 5 or $row->runden_modus == 4 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or $row->runden_modus == 5 and ($x < $row->runden - 1 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or $x == $row->runden - 1 and $man[$z]->rankingpos == $paarung[$count]->runde - 3)) {
//mtmt
?>
<option value="<?php
echo $man[$z]->tln_nr;
?>
" <?php
if ((int) $paarung[$count]->tln_nr == (int) $z + 1) {
?>
selected="selected" <?php
}
?>
><?php
echo $man[$z]->name;
?>
</option>
<?php
}
}
?>
</select>
</td>
<td class="key" nowrap="nowrap">
<select size="1" name="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Gast';
?>
" id="<?php
echo 'D' . $dg . 'R' . ($cnt + 1) . 'P' . ($y + 1) . 'Gast';
?>
">
<option value="0"><?php
echo JText::_('PAARUNG_GAST_WAEHLEN');
?>
</option>
<?php
for ($z = 0; $z < $count_man[0]->tln_nr; $z++) {
if ($row->runden_modus != 4 and $row->runden_modus != 5 or $row->runden_modus == 4 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or $row->runden_modus == 5 and ($x < $row->runden - 1 and $man[$z]->rankingpos >= $paarung[$count]->runde - 1 or $x == $row->runden - 1 and $man[$z]->rankingpos == $paarung[$count]->runde - 3)) {
//mtmt
?>
<option value="<?php
echo $man[$z]->tln_nr;
?>
" <?php
if ((int) $paarung[$count]->gegner == (int) $z + 1) {
?>
selected="selected" <?php
}
?>
><?php
echo $man[$z]->name;
?>
</option>
<?php
}
}
?>
</select>
</td>
<?php
if ($lparams['round_date'] == '1') {
$ndate = 'D' . $paarung[$count]->dg . 'R' . $paarung[$count]->runde . 'P' . $paarung[$count]->paar . 'Date';
$ntime = 'D' . $paarung[$count]->dg . 'R' . $paarung[$count]->runde . 'P' . $paarung[$count]->paar . 'Time';
if ($paarung[$count]->pdate < '1970-01-02' and $paarung[$count]->datum > '1970-01-01') {
$paarung[$count]->pdate = $paarung[$count]->datum;
$paarung[$count]->ptime = $paarung[$count]->startzeit;
}
?>
<td>
<?php
echo JHtml::_('calendar', $paarung[$count]->pdate, $ndate, $ndate, '%Y-%m-%d', array('class' => 'text_area', 'size' => '8', 'maxlength' => '12'));
?>
</td>
<td>
<input class="inputbox" type="time" name="<?php
echo $ntime;
?>
" id="<?php
echo $ntime;
?>
" size="3" maxlength="5" value="<?php
echo substr($paarung[$count]->ptime, 0, 5);
?>
" />
</td>
<?php
}
?>
</tr>
<?php
$count++;
}
}
?>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="section" value="paarung" />
<input type="hidden" name="option" value="com_clm" />
<input type="hidden" name="id" value="<?php
echo $row->id;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHtml::_('form.token');
?>
</form>
<?php
}
