?>
</td>
<td align="center">
<?php
echo JHTML::_('date', $row->datum, JText::_('DATE_FORMAT_CLM'));
?>
</td>
<td align="center">
<?php
$adminLink = new AdminLink();
$adminLink->view = "turroundmatches";
$adminLink->more = array('turnierid' => $this->param['id'], 'roundid' => $row->id);
$adminLink->makeURL();
echo '<a href="' . $adminLink->url . '">' . CLMText::sgpl($row->countMatches, JText::_('MATCH'), JText::_('MATCHES')) . '</a>';
?>
</td>
<td align="center">
<?php
echo $row->countAssigned . " " . JText::_('MATCHES_ASSIGNED');
echo '<br />' . $row->countResults . " " . JText::_('MATCHES_PLAYED');
?>
</td>
<td align="center">
<?php
echo $published;
?>
</td>
function _removeDo()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
// Turnierdaten holen
$turnier = JTable::getInstance('turniere', 'TableCLM');
$turnier->load($this->id);
// Daten zu dieser ID laden
// Turnier existent?
if (!$turnier->id) {
JError::raiseWarning(500, CLMText::errorText('TOURNAMENT', 'NOTEXISTING'));
return false;
}
$clmAccess = clm_core::$access;
if ($turnier->tl != clm_core::$access->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false) {
//if (clm_core::$access->getType() != 'admin' AND clm_core::$access->getType() != 'tl') {
JError::raiseWarning(500, JText::_('TOURNAMENT_NO_ACCESS'));
return false;
}
// Wenn Ergebnisse gemeldet keine nachträgliche Löschung erlauben
$tournament = new CLMTournament($this->id);
$tournament->checkTournamentStarted();
if ($tournament->started) {
JError::raiseWarning(500, JText::_('DELETION_NOT_POSSIBLE') . ": " . JText::_('RESULTS_ENTERED'));
return false;
}
// ausgewählte Einträge
$cid = JRequest::getVar('cid', array(), '', 'array');
JArrayHelper::toInteger($cid);
if (count($cid) < 1) {
JError::raiseWarning(500, JText::_('NO_ITEM_SELECTED', true));
return false;
}
// alle Checks erledigt
$cids = implode(',', $cid);
$query = 'DELETE FROM #__clm_turniere_tlnr' . ' WHERE turnier = ' . $turnier->id . ' AND id IN ( ' . $cids . ' )';
$this->_db->setQuery($query);
if (!$this->_db->query()) {
JError::raiseWarning(500, JText::_('DB_ERROR', true));
return false;
}
$text = CLMText::sgpl(count($cid), JText::_('PLAYER'), JText::_('PLAYERS')) . " " . JText::_('DELETED');
// Log schreiben
$clmLog = new CLMLog();
$clmLog->aktion = $text;
$clmLog->params = array('sid' => $turnier->sid, 'tid' => $turnier->id, 'cids' => count($cid));
$clmLog->write();
// Message
$app = JFactory::getApplication();
$app->enqueueMessage($text);
return true;
}
function publish()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
// termine? evtl global inconstruct anlegen
$user = JFactory::getUser();
$cid = JRequest::getVar('cid', array(), '', 'array');
JArrayHelper::toInteger($cid);
$task = JRequest::getCmd('task');
$publish = $task == 'publish';
// zu vergebender Wert 0/1
// Inhalte übergeben?
if (empty($cid)) {
JError::raiseWarning(500, 'NO_ITEM_SELECTED');
} else {
// ja, Inhalte vorhanden
// erst jetzt alle Einträge durchgehen
foreach ($cid as $key => $value) {
// load the row from the db table
$row = JTable::getInstance('termine', 'TableCLM');
$row->load($value);
// Daten zu dieser ID laden
// Änderung nötig?
if ($row->published != $publish) {
// Log
$clmLog = new CLMLog();
$clmLog->aktion = JText::_('TERMINE') . " " . $row->name . ": " . $task;
$clmLog->params = array();
$clmLog->write();
// Log geschrieben - Änderungen später
} else {
unset($cid[$key]);
}
}
// alle Einträge geprüft
// immer noch Einträge vorhanden?
if (!empty($cid)) {
$row = JTable::getInstance('termine', 'TableCLM');
$row->publish($cid, $publish);
// Meldung erstellen
$app = JFactory::getApplication();
if ($publish) {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('TERMINE_TASK'), JText::_('TERMINE_TASKS')) . " " . JText::_('CLM_PUBLISHED'));
} else {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('TERMINE_TASK'), JText::_('TERMINE_TASKS')) . " " . JText::_('CLM_UNPUBLISHED'));
}
} else {
$app = JFactory::getApplication();
$app->enqueueMessage(JText::_('NO_CHANGES'));
}
}
$this->adminLink->makeURL();
$this->setRedirect($this->adminLink->url);
}
function publish()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
// Instanz der Tabelle
$row = JTable::getInstance('turniere', 'TableCLM');
$row->load($this->id);
// Daten zu dieser ID laden
$clmAccess = clm_core::$access;
if ($row->tl != clm_core::$access->getJid() and $clmAccess->access('BE_tournament_edit_detail') !== true or $clmAccess->access('BE_tournament_edit_detail') === false) {
//if (clm_core::$access->getType() != 'admin' AND clm_core::$access->getType() != 'tl') {
JError::raiseWarning(500, JText::_('TOURNAMENT_NO_ACCESS'));
return false;
}
// TODO? evtl global inconstruct anlegen
$user = JFactory::getUser();
$cid = JRequest::getVar('cid', array(), '', 'array');
JArrayHelper::toInteger($cid);
$task = JRequest::getCmd('task');
$publish = $task == 'publish';
// zu vergebender Wert 0/1
// Inhalte übergeben?
if (empty($cid)) {
JError::raiseWarning(500, 'NO_ITEM_SELECTED');
} else {
// ja, Inhalte vorhanden
$cids = implode(',', $cid);
$query = 'UPDATE #__clm_turniere_rnd_termine' . ' SET published = ' . (int) $publish . ' WHERE id IN ( ' . $cids . ' )' . ' AND ( checked_out = 0 OR ( checked_out = ' . (int) $user->get('id') . ' ) )';
$this->_db->setQuery($query);
if (!$this->_db->query()) {
JError::raiseWarning(500, JText::_('DB_ERROR', true));
}
$app = JFactory::getApplication();
if ($publish) {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('ROUND'), JText::_('ROUNDS')) . " " . JText::_('CLM_PUBLISHED'));
} else {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('ROUND'), JText::_('ROUNDS')) . " " . JText::_('CLM_UNPUBLISHED'));
}
// Log
$clmLog = new CLMLog();
$clmLog->aktion = JText::_('ROUND') . " " . $row->name . ": " . $task;
$clmLog->params = array('tid' => $this->id);
// TurnierID wird als LigaID gespeichert
$clmLog->write();
}
$this->adminLink->makeURL();
$this->setRedirect($this->adminLink->url);
}
}
echo '</tr>';
// Ende der Zeile
}
// Abschlußzeile
echo '<tr class="ende">';
// total
echo '<td colspan="3"> ';
echo JText::_('TEAM_TOTAL');
echo '</td>';
// TWZ-Schnitt
echo '<td class="tp_col_4">';
if ($this->player->countTWZplayers > 0) {
echo 'Ø ' . floor($this->player->sumTWZ / $this->player->countTWZplayers);
if ($this->player->countTWZplayersNone > 0) {
echo '<br />(' . CLMText::sgpl($this->player->countTWZplayers, JText::_('TOURNAMENT_PLAYER'), JText::_('TOURNAMENT_PLAYERS'), $complete_string = TRUE) . ')';
}
} else {
echo '-';
}
echo '</td>';
// Pkt
echo '<td class="tp_col_5">';
echo $this->player->sum_punkte . " / " . $this->player->countMatchesPlayed;
echo '<br />' . CLMText::getPosString($this->player->rankingPos, 2);
echo '</td>';
echo '</tr>';
?>
</table>
<!--Bereich für pgn-Viewer-->
function _resetDo()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
// Instanz der Tabelle
$row = JTable::getInstance('turniere', 'TableCLM');
$row->load($this->turnierid);
$clmAccess = clm_core::$access;
if ($row->tl != clm_core::$access->getJid() and $clmAccess->access('BE_tournament_edit_round') !== true or $clmAccess->access('BE_tournament_edit_round') === false) {
JError::raiseWarning(500, JText::_('TOURNAMENT_NO_ACCESS'));
return false;
}
$user = JFactory::getUser();
// Reale RundenNummer, DG aus RundenID ermitteln, tl_ok
$query = 'SELECT nr, dg, tl_ok' . ' FROM #__clm_turniere_rnd_termine' . ' WHERE id = ' . $this->roundid;
$this->_db->setQuery($query);
list($runde, $dg, $tl_ok) = $this->_db->loadRow();
// wenn Runde schon bestätigt, zurücksetzen nicht erlauben
if ($tl_ok == 1) {
JError::raiseWarning(500, CLMText::errorText('ROUND', 'ALREADYAPPROVED'));
return false;
}
// sind überhaupt Ergebnisse eingetragen?
$query = "SELECT COUNT(*) FROM #__clm_turniere_rnd_spl" . " WHERE turnier = " . $this->turnierid . " AND runde = " . $runde . " AND dg = " . $dg . " AND ergebnis IS NOT NULL";
$this->_db->setQuery($query);
$resultCount = $this->_db->loadResult();
if ($resultCount == 0) {
JError::raiseWarning(500, CLMText::errorText('RESULTS', 'NOTEXISTING'));
return false;
}
// Runde anpassen
$query = "UPDATE #__clm_turniere_rnd_termine" . " SET gemeldet = NULL, zeit ='000e0-00-00 00:00:00', editor = " . $user->id . ", edit_zeit = NOW()" . " WHERE id = " . $this->roundid;
$this->_db->setQuery($query);
$this->_db->query();
// Ergebnisse löschen
$query = "UPDATE #__clm_turniere_rnd_spl" . " SET ergebnis = NULL, tiebrS = 0, tiebrG = 0, gemeldet = NULL " . " WHERE turnier = " . $this->turnierid . " AND runde = " . $runde . " AND dg = " . $dg;
$this->_db->setQuery($query);
$this->_db->query();
// Teilnehmer zurücksetzen bei KO-Turnier
if ($row->typ == '3' or $row->typ == '5') {
$query = "UPDATE #__clm_turniere_tlnr" . " SET koRound = " . ($runde - 1) . ", koStatus = '1' " . " WHERE turnier = " . $this->turnierid . " AND koRound >= " . $runde;
$this->_db->setQuery($query);
$this->_db->query();
}
JError::raiseNotice(500, CLMText::sgpl($resultCount / 2, JText::_('RESULT'), JText::_('RESULTS')) . " " . JText::_('RESET'));
// Rangliste neu berechnen!
$tournament = new CLMTournament($this->turnierid, true);
$tournament->calculateRanking();
$tournament->setRankingPositions();
// Log schreiben
$clmLog = new CLMLog();
$clmLog->aktion = JText::_('RESULTS') . " " . JText::_('RESET');
//$clmLog->params = array('tid' => $this->turnierid, 'rnd' => $this->roundid); // TurnierID wird als LigaID gespeichert
$clmLog->params = array('tid' => $this->turnierid, 'rnd' => $runde);
// TurnierID wird als LigaID gespeichert
$clmLog->write();
return true;
}
function _resetDo()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
if (CLM_usertype != 'admin' and CLM_usertype != 'tl') {
JError::raiseWarning(500, JText::_('TOURNAMENT_NO_ACCESS'));
return FALSE;
}
$user =& JFactory::getUser();
// Reale RundenNummer, DG aus RundenID ermitteln, tl_ok
$query = 'SELECT nr, dg, tl_ok' . ' FROM #__clm_turniere_rnd_termine' . ' WHERE id = ' . $this->roundid;
$this->_db->setQuery($query);
list($runde, $dg, $tl_ok) = $this->_db->loadRow();
// wenn Runde schon bestätigt, zurücksetzen nicht erlauben
if ($tl_ok == 1) {
JError::raiseWarning(500, CLMText::errorText('ROUND', 'ALREADYAPPROVED'));
return FALSE;
}
// sind überhaupt Ergebnisse eingetragen?
$query = "SELECT COUNT(*) FROM #__clm_turniere_rnd_spl" . " WHERE turnier = " . $this->turnierid . " AND runde = " . $runde . " AND dg = " . $dg . " AND ergebnis IS NOT NULL";
$this->_db->setQuery($query);
$resultCount = $this->_db->loadResult();
if ($resultCount == 0) {
JError::raiseWarning(500, CLMText::errorText('RESULTS', 'NOTEXISTING'));
return FALSE;
}
// Runde anpassen
$query = "UPDATE #__clm_turniere_rnd_termine" . " SET gemeldet = NULL, zeit ='000e0-00-00 00:00:00', editor = " . $user->id . ", edit_zeit = NOW()" . " WHERE id = " . $this->roundid;
$this->_db->setQuery($query);
$this->_db->query();
// Ergebnisse löschen
$query = "UPDATE #__clm_turniere_rnd_spl" . " SET ergebnis = NULL" . " WHERE turnier = " . $this->turnierid . " AND runde = " . $runde . " AND dg = " . $dg;
$this->_db->setQuery($query);
$this->_db->query();
JError::raiseNotice(500, CLMText::sgpl($resultCount / 2, JText::_('RESULT'), JText::_('RESULTS')) . " " . JText::_('RESET'));
// Rangliste neu berechnen!
$tournament = new CLMTournament($this->turnierid, TRUE);
$tournament->calculateRanking();
$tournament->setRankingPositions();
// Log schreiben
$clmLog = new CLMLog();
$clmLog->aktion = JText::_('RESULTS') . " " . JText::_('RESET');
$clmLog->params = array('tid' => $this->turnierid, 'rnd' => $this->roundid);
// TurnierID wird als LigaID gespeichert
$clmLog->write();
return TRUE;
}
function publish()
{
// Check for request forgeries
JRequest::checkToken() or die('Invalid Token');
// TODO? evtl global inconstruct anlegen
$user =& JFactory::getUser();
$cid = JRequest::getVar('cid', array(), '', 'array');
JArrayHelper::toInteger($cid);
$task = JRequest::getCmd('task');
$publish = $task == 'publish';
// zu vergebender Wert 0/1
// Inhalte übergeben?
if (empty($cid)) {
JError::raiseWarning(500, 'NO_ITEM_SELECTED');
} else {
// ja, Inhalte vorhanden
// erst jetzt alle Einträge durchgehen
foreach ($cid as $key => $value) {
// load the row from the db table
$row =& JTable::getInstance('turniere', 'TableCLM');
$row->load($value);
// Daten zu dieser ID laden
// Prüfen ob User Berechtigung für dieses Turnier hat
if (CLM_usertype != 'admin' and CLM_usertype != 'tl') {
JError::raiseWarning(500, $row->name . ": " . JText::_('TOURNAMENT_NO_ACCESS'));
// daher diesen Eintrag aus dem cid-Array löschen
unset($cid[$key]);
} else {
// Berechtigung vorhanden
// Änderung nötig?
if ($row->published != $publish) {
// Log
$clmLog = new CLMLog();
$clmLog->aktion = JText::_('TOURNAMENT') . " " . $row->name . ": " . $task;
$clmLog->params = array('sid' => $row->sid, 'tid' => $value);
// TurnierID wird als LigaID gespeichert
$clmLog->write();
// Log geschrieben - Änderungen später
} else {
unset($cid[$key]);
}
}
}
// alle Einträge geprüft
// immer noch Einträge vorhanden?
if (!empty($cid)) {
$row =& JTable::getInstance('turniere', 'TableCLM');
$row->publish($cid, $publish);
// Meldung erstellen
$app =& JFactory::getApplication();
if ($publish) {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('TOURNAMENT'), JText::_('TOURNAMENTS')) . " " . JText::_('CLM_PUBLISHED'));
} else {
$app->enqueueMessage(CLMText::sgpl(count($cid), JText::_('TOURNAMENT'), JText::_('TOURNAMENTS')) . " " . JText::_('CLM_UNPUBLISHED'));
}
} else {
$app =& JFactory::getApplication();
$app->enqueueMessage(JText::_('NO_CHANGES'));
}
}
$this->adminLink->makeURL();
$this->setRedirect($this->adminLink->url);
}
