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); }