function display($cachable = false, $urlparams = array())
{
$mainframe = JFactory::getApplication();
$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->liga_mt == "0") {
$mppoint = 'league';
$csection = 'ligen';
} else {
$mppoint = 'teamtournament';
$csection = 'mturniere';
}
$clmAccess = clm_core::$access;
// Prüfen ob User Berechtigung hat
//if ( $liga->sl !== clm_core::$access->getJid() AND clm_core::$access->getType() !== 'admin') {
if ($row->sl !== clm_core::$access->getJid() and $clmAccess->access('BE_' . $mppoint . '_edit_fixture') !== true or $clmAccess->access('BE_' . $mppoint . '_edit_fixture') === false) {
//if ( $row->sl !== clm_core::$access->getJid() AND clm_core::$access->getType() !== 'admin') {
JError::raiseWarning(500, JText::_('PAARUNG_LIGEN'));
$link = 'index.php?option=' . $option . '§ion=' . $csection;
$mainframe->redirect($link);
}
// Prüfen ob Runden erstellt sind
if ($row->rnd < 1) {
JError::raiseWarning(500, JText::_('PAARUNG_RUND'));
$link = 'index.php?option=' . $option . '§ion=' . $csection;
$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, rt.datum, rt.startzeit, rt.enddatum " . " 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 . 'pairingdates.php';
CLMViewPairingDates::pairingdates($row, $paarung, $man, $count_man, $option, $cid, $lists);
}
public static function pairingdates(&$row, $paarung, $man, $count_man, $option, $cid, &$lists)
{
CLMViewPairingDates::setPairingDatesToolbar($row);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
?>
<!--- <br> --->
<form action="index.php" method="post" name="adminForm" id="adminForm">
<div class="width-50 fltlft">
<fieldset class="adminform">
<!--- <legend><?php
echo JText::_('PAARUNG_AKTUELL');
?>
</legend> --->
<table class="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"><h3><?php
echo $paarung[$count]->rname;
if (isset($paarung[$count]->datum) and $paarung[$count]->datum > '1900-01-01') {
echo ' ' . JText::_('ON_DAY') . ' ' . JHTML::_('date', $paarung[$count]->datum, JText::_('DATE_FORMAT_CLM_F'));
if (isset($paarung[$count]->enddatum) and $paarung[$count]->enddatum > '1970-01-01' and $paarung[$count]->enddatum != $paarung[$count]->datum) {
echo ' - ' . JHTML::_('date', $paarung[$count]->enddatum, JText::_('DATE_FORMAT_CLM_F'));
}
}
?>
</h3></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>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_DATE');
?>
</td>
<td class="key" nowrap="nowrap"><?php
echo JText::_('PAARUNG_TIME');
?>
</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>
<?php
$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';
//echo "<br>ndate:".$ndate." pdate:".$paarung[$count]->pdate." datum:".$paarung[$count]->datum;
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;
//echo "<br>Jndate:".$ndate." pdate:".$paarung[$count]->pdate." datum:".$paarung[$count]->datum;
}
?>
<td>
<?php
echo JHtml::_('calendar', $paarung[$count]->pdate, $ndate, $ndate, '%Y-%m-%d', array('class' => 'text_area', 'size' => '12', 'maxlength' => '12'));
?>
</td>
<td>
<input class="inputbox" type="time" name="<?php
echo $ntime;
?>
" id="<?php
echo $ntime;
?>
" size="6" maxlength="6" value="<?php
echo substr($paarung[$count]->ptime, 0, 5);
?>
" />
</td>
</tr>
<?php
$count++;
}
}
?>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="section" value="pairingdates" />
<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
}
