public static function meldeliste(&$row, $row_spl, $row_sel, $max, $liga, $abgabe, $option)
{
CLMViewMeldelisten::setMeldelisteToolbar($row);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
// Konfigurationsparameter auslesen
$config = clm_core::$db->config();
$countryversion = $config->countryversion;
?>
<form action="index.php" method="post" name="adminForm" id="adminForm">
<div class="width-50 fltlft">
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MELDELISTE_STAMMSPIELER');
?>
</legend>
<table class="admintable">
<tr>
<th width="10">
<?php
echo JText::_('MELDELISTE_BRETT');
?>
</th>
<th width="10">
<?php
echo JText::_('MELDELISTE_SPIELERNAME');
?>
</th>
<th width="10">
<?php
echo JText::_('MELDELISTE_BLOCK');
?>
</th>
</tr>
<?php
if (isset($liga[0])) {
for ($i = 0; $i < $liga[0]->stamm; $i++) {
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="sid">
<?php
echo JText::_('MELDELISTE_BRETT_NR') . ' ' . ($i + 1) . ' : ';
?>
</label>
</td>
<td>
<select size="1" name="<?php
echo 'spieler' . ($i + 1);
?>
" id="<?php
echo $i + 1;
?>
">
<option value="0"><?php
echo JText::_('MELDELISTE_SPIELER_AUSWAEHLEN');
?>
</option>
<?php
for ($x = 0; $x < $max[0]->max; $x++) {
?>
<!--- <option value="<?php
//echo $row_spl[$x]->id.'-'.$row_spl[$x]->zps;
?>
" <?php
//if (((int)$row_spl[$x]->id) == ((int)$row_sel[$i]->mgl_nr) AND ($row_spl[$x]->zps == $row_sel[$i]->zps)) {
?>
selected="selected" <?php
//}
?>
><?php
//echo $row_spl[$x]->id.' ';if((int)$row_spl[$x]->id < 1000) {echo " ";} echo "- ".$row_spl[$x]->name;
?>
</option> --->
<option value="<?php
echo $row_spl[$x]->id . '-' . $row_spl[$x]->zps;
?>
" <?php
if ($countryversion == "de") {
if (isset($row_sel[$i]) and (int) $row_spl[$x]->id == (int) $row_sel[$i]->mgl_nr and $row_spl[$x]->zps == $row_sel[$i]->zps) {
?>
selected="selected" <?php
}
?>
><?php
} else {
if (isset($row_sel[$i]) and (int) $row_spl[$x]->id == $row_sel[$i]->PKZ and $row_spl[$x]->zps == $row_sel[$i]->zps) {
?>
selected="selected" <?php
}
?>
><?php
}
echo $row_spl[$x]->name . ' - ' . $row_spl[$x]->id;
?>
</option>
<?php
}
?>
</select>
</td>
<td align="center">
<input type="checkbox" name="check<?php
echo $i + 1;
?>
" value="1" <?php
if (isset($row_sel[$i]) and $row_sel[$i]->gesperrt == "1") {
echo 'checked="checked"';
}
?>
>
</td>
</tr>
<?php
}
}
?>
</table>
</fieldset>
</div>
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MELDELISTE_DETAILS');
?>
</legend>
<table class="admintable">
<tr>
<tr>
<td class="key" nowrap="nowrap"><?php
echo JText::_('MELDELISTE_MELDER') . ' : ';
?>
</td>
<td class="key" nowrap="nowrap"><?php
if (!isset($abgabe[0]->name)) {
echo "---";
} else {
echo $abgabe[0]->name;
}
?>
</td>
</tr>
<td class="key" nowrap="nowrap"><?php
echo JText::_('JDATE') . ' : ';
?>
</td>
<td class="key" nowrap="nowrap"><?php
if (!isset($abgabe[0]->datum) or $abgabe[0]->datum == "0000-00-00 00:00:00") {
echo "---";
} else {
echo JHtml::_('date', $abgabe[0]->datum, JText::_('DATE_FORMAT_LC2'));
}
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><?php
echo JText::_('MELDELISTE_LAST_UPDATE') . ' : ';
?>
</td>
<td class="key" nowrap="nowrap"><?php
if (!isset($abgabe[0]->editor)) {
echo "---";
} else {
echo $abgabe[0]->name;
}
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><?php
echo JText::_('JDATE') . ' : ';
?>
</td>
<td class="key" nowrap="nowrap"><?php
if (!isset($abgabe[0]->edit_datum) or $abgabe[0]->edit_datum == "0000-00-00 00:00:00") {
echo "---";
} else {
echo JHtml::_('date', $abgabe[0]->edit_datum, JText::_('DATE_FORMAT_LC2'));
}
?>
</td>
</tr>
</table>
</fieldset>
</div>
</div>
<div class="width-50 fltrt">
<fieldset class="adminform">
<legend><?php
echo JText::_('MELDELISTE_ERSATZSPIELER');
?>
</legend>
<table class="admintable">
<tr>
<th width="10">
<?php
echo JText::_('MELDELISTE_BRETT');
?>
</th>
<th width="10">
<?php
echo JText::_('MELDELISTE_SPIELERNAME');
?>
</th>
<th width="10">
<?php
echo JText::_('MELDELISTE_BLOCK');
?>
</th>
</tr>
<?php
// Ersatzspieler
if (isset($liga[0])) {
for ($i = $liga[0]->stamm; $i < $liga[0]->stamm + $liga[0]->ersatz; $i++) {
?>
<tr>
<td class="key" nowrap="nowrap"><label for="sid"><?php
echo JText::_('MELDELISTE_BRETT_NR') . ' ' . ($i + 1) . ' : ';
?>
</label>
</td>
<td>
<select size="1" name="<?php
echo 'spieler' . ($i + 1);
?>
" id="<?php
echo $i + 1;
?>
">
<option value="0"><?php
echo JText::_('MELDELISTE_SPIELER_AUSWAEHLEN');
?>
</option>
<?php
for ($x = 0; $x < $max[0]->max; $x++) {
?>
<!--- <option value="<?php
//echo $row_spl[$x]->id.'-'.$row_spl[$x]->zps;
?>
" <?php
//if (((int)$row_spl[$x]->id) == ((int)$row_sel[$i]->mgl_nr) AND ($row_spl[$x]->zps == $row_sel[$i]->zps)) {
?>
selected="selected" <?php
//}
?>
><?php
//echo $row_spl[$x]->id.' ';if((int)$row_spl[$x]->id < 1000) {echo " ";} echo "- ".$row_spl[$x]->name;
?>
</option> --->
<option value="<?php
echo $row_spl[$x]->id . '-' . $row_spl[$x]->zps;
?>
" <?php
if ($countryversion == "de") {
if (isset($row_sel[$i]) and (int) $row_spl[$x]->id == (int) $row_sel[$i]->mgl_nr and $row_spl[$x]->zps == $row_sel[$i]->zps) {
?>
selected="selected" <?php
}
?>
><?php
} else {
if (isset($row_sel[$i]) and (int) $row_spl[$x]->id == $row_sel[$i]->PKZ and $row_spl[$x]->zps == $row_sel[$i]->zps) {
?>
selected="selected" <?php
}
?>
><?php
}
echo $row_spl[$x]->name . ' - ' . $row_spl[$x]->id;
?>
</option>
<?php
}
?>
</select>
</td>
<td align="center">
<input type="checkbox" name="check<?php
echo $i + 1;
?>
" value="1" <?php
if (isset($row_sel[$i]) and $row_sel[$i]->gesperrt == "1") {
echo 'checked="checked"';
}
?>
>
</td>
</tr>
<?php
}
}
?>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="section" value="mannschaften" />
<input type="hidden" name="option" value="com_clm" />
<input type="hidden" name="id" value="<?php
echo $row->id;
?>
" />
<input type="hidden" name="cid" value="<?php
echo $row->cid;
?>
" />
<input type="hidden" name="liga" value="<?php
echo $row->liga;
?>
" />
<input type="hidden" name="zps" value="<?php
echo $row->zps;
?>
" />
<input type="hidden" name="sid" value="<?php
echo $row->sid;
?>
" />
<input type="hidden" name="mnr" value="<?php
echo $row->man_nr;
?>
" />
<input type="hidden" name="stamm" value="<?php
echo $liga[0]->stamm;
?>
" />
<input type="hidden" name="ersatz" value="<?php
echo $liga[0]->ersatz;
?>
" />
<input type="hidden" name="max" value="<?php
echo $max[0]->max;
?>
" />
<input type="hidden" name="editor" value="<?php
echo $abgabe[0]->name;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHtml::_('form.token');
?>
</form>
<?php
}
function edit()
{
$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');
$liga = JRequest::getVar('liga');
JArrayHelper::toInteger($cid, array(0));
$row = JTable::getInstance('mannschaften', 'TableCLM');
// load the row from the db table
$row->load($cid[0]);
// Prüfen ob User Berechtigung zum editieren hat
$sql = " SELECT sl FROM #__clm_liga " . " WHERE id =" . $row->liga;
$db->setQuery($sql);
$lid = $db->loadObjectList();
$clmAccess = clm_core::$access;
if ($clmAccess->access('BE_team_registration_list') === false) {
$section = 'info';
JError::raiseWarning(500, JText::_('TEAM_NO_ACCESS'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link);
}
if (isset($lid[0]) && $lid[0]->sl !== clm_core::$access->getJid() and $clmAccess->access('BE_team_registration_list') !== true and $task == 'edit') {
JError::raiseWarning(500, JText::_('MELDELISTEN_STAFFEL'));
$link = 'index.php?option=' . $option . '§ion=mannschaften';
$mainframe->redirect($link);
}
// MaxDaten für DropDown Menue
$maxsql = "SELECT COUNT(*) as max FROM #__clm_dwz_spieler" . " WHERE ( ZPS ='" . $row->zps . "' OR FIND_IN_SET(ZPS,'" . $row->sg_zps . "') != 0 )" . " AND sid =" . $row->sid;
$db->setQuery($maxsql);
$max = $db->loadObjectList();
// Daten Stamm, Ersatz für DropDown Menue
$ligasql = "SELECT stamm, ersatz FROM #__clm_liga" . " WHERE id =" . $row->liga . " AND sid =" . $row->sid;
$db->setQuery($ligasql);
$liga = $db->loadObjectList();
// Daten für DropDown Menue
// Konfigurationsparameter auslesen
$config = clm_core::$db->config();
$val = $config->meldeliste;
if ($val == 1) {
$order = "Spielername ASC";
} else {
$order = "DWZ DESC";
}
$sql = "SELECT mgl_nr as id, Spielername as name, DWZ as dwz, ZPS as zps FROM #__clm_dwz_spieler" . " WHERE ( ZPS ='" . $row->zps . "' OR FIND_IN_SET(ZPS,'" . $row->sg_zps . "') != 0 )" . " AND sid =" . $row->sid . " ORDER BY " . $order;
$db->setQuery($sql);
$row_spl = $db->loadObjectList();
// Daten für Abgabe
$sql = "SELECT u.name, a.datum,v.name as editor, a.edit_datum FROM #__clm_mannschaften as a" . " LEFT JOIN #__clm_user as u ON u.jid = a.liste AND u.sid = a.sid" . " LEFT JOIN #__clm_user as v ON v.jid = a.edit_liste AND v.sid = a.sid" . " WHERE a.zps = '" . $row->zps . "'" . " AND a.man_nr = " . $row->man_nr . " AND a.sid =" . $row->sid . " AND u.name <> '' ";
$db->setQuery($sql);
$abgabe = $db->loadObjectList();
//Stammspieler
$selsql = "SELECT mgl_nr,snr,zps, gesperrt FROM #__clm_meldeliste_spieler" . " WHERE ( ZPS ='" . $row->zps . "' OR FIND_IN_SET(ZPS,'" . $row->sg_zps . "') != 0 )" . " AND mnr = " . $row->man_nr . " AND lid = " . $row->liga . " AND sid = " . $row->sid . " ORDER BY snr ASC";
$db = JFactory::getDBO();
$db->setQuery($selsql);
$row_sel = $db->loadObjectList();
require_once JPATH_COMPONENT . DS . 'views' . DS . 'meldelisten.php';
CLMViewMeldelisten::meldeliste($row, $row_spl, $row_sel, $max, $liga, $abgabe, $option);
}
