function display()
{
global $mainframe, $option;
$section = JRequest::getVar('section');
$db =& JFactory::getDBO();
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$filter_mgl = $mainframe->getUserStateFromRequest("{$option}.filter_mgl", 'filter_mgl', 0, 'int');
$filter_sort = $mainframe->getUserStateFromRequest("{$option}.filter_sort", 'filter_sort', 0, 'string');
// Wenn Verein und Spieler gewählt wurden dann Daten für Anzeige laden
if ($filter_vid != "0" and $filter_mgl != "0") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid}'" . " AND Mgl_Nr =" . $filter_mgl;
$db->setQuery($sql);
$spieler = $db->loadObjectList();
}
// Wenn Verein gewählt wurden dann Daten für Anzeige laden
if ($filter_vid != "0") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid}'";
if ($filter_sort != "0") {
$sql = $sql . " ORDER BY " . $filter_sort;
} else {
$sql = $sql . " ORDER BY Spielername ASC ";
}
$db->setQuery($sql);
$verein = $db->loadObjectList();
}
// Filter
// Saison
$sql = 'SELECT id, name FROM #__clm_saison WHERE archiv =0';
$db->setQuery($sql);
$lists['saison'] = $db->loadObjectList();
// Saisonfilter
$sql = 'SELECT id, name FROM #__clm_saison WHERE archiv =0';
$db->setQuery($sql);
$saisonlist[] = JHTML::_('select.option', '0', JText::_('DWZ_SAISON'), 'id', 'name');
$saisonlist = array_merge($saisonlist, $db->loadObjectList());
$lists['sid'] = JHTML::_('select.genericlist', $saisonlist, 'filter_sid', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'id', 'name', intval($filter_sid));
// Vereinefilter laden
require_once JPATH_COMPONENT . DS . 'controllers' . DS . 'filter_vereine.php';
$vlist = CLMFilterVerein::vereine_filter(0);
$lists['vid'] = JHTML::_('select.genericlist', $vlist, 'filter_vid', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'zps', 'name', $filter_vid);
// Spielerfilter
if ($filter_zps != "0") {
$sql = 'SELECT Mgl_Nr, Spielername FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0 " . " AND ZPS ='{$filter_vid}'" . " ORDER BY Spielername ASC";
$db->setQuery($sql);
$mlist[] = JHTML::_('select.option', '0', JText::_('DWZ_SPIELER'), 'Mgl_Nr', 'Spielername');
$mlist = array_merge($mlist, $db->loadObjectList());
$lists['mgl'] = JHTML::_('select.genericlist', $mlist, 'filter_mgl', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'Mgl_Nr', 'Spielername', $filter_mgl);
}
require_once JPATH_COMPONENT . DS . 'views' . DS . 'dwz.php';
CLMViewDWZ::DWZ($spieler, $verein, $lists, $pageNav, $option);
}
function display($cachable = false, $urlparams = array())
{
$mainframe = JFactory::getApplication();
$option = JRequest::getCmd('option');
$section = JRequest::getVar('section');
$db = JFactory::getDBO();
//CLM parameter auslesen
$config = clm_core::$db->config();
$countryversion = $config->countryversion;
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$filder_vid_to = "0";
$filter_vid_from = $mainframe->getUserStateFromRequest("{$option}.filter_vid_from", 'filter_vid_from', 0, 'var');
$filter_sort = $mainframe->getUserStateFromRequest("{$option}.filter_sort", 'filter_sort', 0, 'string');
if ($countryversion == "de") {
$filter_mgl = $mainframe->getUserStateFromRequest("{$option}.filter_mgl", 'filter_mgl', 0, 'int');
// Wenn Verein und Spieler gewählt wurden dann Daten für Anzeige laden
if ($filter_vid != "0" and $filter_mgl != "0") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid}'" . " AND Mgl_Nr =" . $filter_mgl;
$db->setQuery($sql);
$spieler = $db->loadObjectList();
} else {
$spieler = array();
}
} else {
$filter_PKZ = $mainframe->getUserStateFromRequest("{$option}.filter_PKZ", 'filter_PKZ', 0, 'string');
// Wenn Verein und Spieler gewählt wurden dann Daten für Anzeige laden
if ($filter_vid != "0" and $filter_PKZ != "") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid}'" . " AND PKZ =" . $filter_PKZ;
$db->setQuery($sql);
$spieler = $db->loadObjectList();
} else {
$spieler = array();
}
}
// Wenn Verein gewählt wurden dann Daten für Anzeige laden
if ($filter_vid != "0") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid}'";
if ($filter_sort != "0") {
$sql = $sql . " ORDER BY " . $filter_sort;
} else {
$sql = $sql . " ORDER BY Spielername ASC ";
}
$db->setQuery($sql);
$verein = $db->loadObjectList();
}
// Wenn FROM-Verein gewählt wurden dann Daten für Anzeige laden
if ($filter_vid_from != "0") {
$sql = 'SELECT * FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0" . " AND ZPS ='{$filter_vid_from}'";
if ($filter_sort != "0") {
$sql = $sql . " ORDER BY " . $filter_sort;
} else {
$sql = $sql . " ORDER BY Spielername ASC ";
}
$db->setQuery($sql);
$verein_from = $db->loadObjectList();
}
// Saison
$sql = 'SELECT id, name FROM #__clm_saison WHERE published = 1 AND archiv = 0';
$db->setQuery($sql);
$lists['saison'] = $db->loadObjectList();
// Vereinefilter laden
$vlist = CLMFilterVerein::vereine_filter(0);
$lists['vid'] = JHTML::_('select.genericlist', $vlist, 'filter_vid', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'zps', 'name', $filter_vid);
$lists['vid_to'] = JHTML::_('select.genericlist', $vlist, 'filter_vid_to', 'class="inputbox" size="1" ', 'zps', 'name', $filter_vid_to);
$lists['vid_from'] = JHTML::_('select.genericlist', $vlist, 'filter_vid_from', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'zps', 'name', $filter_vid_from);
// Spielerfilter
//if ($filter_zps !="0" ) {
if ($filter_vid != "0") {
if ($countryversion == "de") {
$sql = 'SELECT Mgl_Nr, Spielername FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0 " . " AND ZPS ='{$filter_vid}'" . " ORDER BY Spielername ASC";
$db->setQuery($sql);
$mlist[] = JHTML::_('select.option', '0', JText::_('DWZ_SPIELER'), 'Mgl_Nr', 'Spielername');
$mlist = array_merge($mlist, $db->loadObjectList());
$lists['mgl'] = JHTML::_('select.genericlist', $mlist, 'filter_mgl', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'Mgl_Nr', 'Spielername', $filter_mgl);
} else {
$sql = 'SELECT PKZ, Spielername FROM #__clm_dwz_spieler as a' . ' LEFT JOIN #__clm_saison AS s ON s.id = a.sid' . " WHERE s.archiv = 0 " . " AND ZPS ='{$filter_vid}'" . " ORDER BY Spielername ASC";
$db->setQuery($sql);
$mlist[] = JHTML::_('select.option', '0', JText::_('DWZ_SPIELER'), 'PKZ', 'Spielername');
$mlist = array_merge($mlist, $db->loadObjectList());
$lists['PKZ'] = JHTML::_('select.genericlist', $mlist, 'filter_PKZ', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'PKZ', 'Spielername', $filter_PKZ);
}
}
if (!isset($verein)) {
$verein = array();
}
if (!isset($verein_from)) {
$verein_from = array();
}
require_once JPATH_COMPONENT . DS . 'views' . DS . 'dwz.php';
CLMViewDWZ::DWZ($spieler, $verein, $verein_from, $lists, '', $option);
}
function DWZ($spieler, $verein, $lists, $pageNav, $option)
{
CLMViewDWZ::setDWZToolbar($vname);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
?>
<script language="javascript" type="text/javascript">
<!--
function edit()
{
var task = document.getElementsByName ( "task") [0];
var pre_task = document.getElementsByName ( "pre_task") [0];
task.value = "add";
pre_task.value = "add";
document.adminForm.submit();
}
function submitbutton(pressbutton) {
var form = document.adminForm;
var pre_task = document.getElementsByName ( "pre_task") [0];
else {
if (pre_task.value == 'add') {
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.filter_vid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_1', true);
?>
" );
} else if (form.filter_sid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_2', true);
?>
" );
} else if (form.filter_gid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_3', true);
?>
" );
} else {
submitform( pressbutton );
}
}
else {
submitform( pressbutton );
}
}
}
-->
</script>
<form action="index.php" method="post" name="adminForm">
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_DATA');
?>
</legend>
<?php
echo $lists['vid'];
?>
<?php
echo $lists['mgl'];
?>
<?php
global $mainframe;
$filter_sort = $mainframe->getUserStateFromRequest("{$option}.filter_mgl", 'filter_sort', 0, 'string');
?>
<select name="filter_sort" id="filter_sort" class="inputbox" size="1" onchange="document.adminForm.submit();">
<option value="0" <?php
if ($filter_sort == "0") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_1');
?>
</option>
<option value="(0+Mgl_Nr) DESC" <?php
if ($filter_sort == "(0+Mgl_Nr) DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_2');
?>
</option>
<option value="(0+Mgl_Nr) ASC" <?php
if ($filter_sort == "(0+Mgl_Nr) ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_3');
?>
</option>
<option value="Spielername DESC" <?php
if ($filter_sort == "Spielername DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_4');
?>
</option>
<option value="Spielername ASC" <?php
if ($filter_sort == "Spielername ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_5');
?>
</option>
<option value="DWZ DESC" <?php
if ($filter_sort == "DWZ DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_6');
?>
</option>
<option value="DWZ ASC" <?php
if ($filter_sort == "DWZ ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_7');
?>
</option>
</select>
</fieldset>
<?php
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
?>
<div class="col width-40">
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_1');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_2');
?>
</th>
<th width="20%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_3');
?>
</th>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_4');
?>
</th>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_5');
?>
</th>
<th width="3%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_31');
?>
</th>
</tr>
<?php
for ($x = 0; $x < count($verein); $x++) {
?>
<tr>
<td class="key" width="20%" nowrap="nowrap">
<?php
echo $x + 1;
?>
</td>
<td class="key" width="20%" nowrap="nowrap">
<?php
echo $verein[$x]->Spielername;
?>
</td>
<td class="key" width="20%" nowrap="nowrap">
<?php
echo $verein[$x]->Mgl_Nr;
?>
</td>
<td class="key" width="20%" nowrap="nowrap">
<?php
echo $verein[$x]->DWZ;
?>
</td>
<td class="key" width="20%" nowrap="nowrap">
<?php
echo $verein[$x]->Status;
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_6');
}
?>
</fieldset>
</div>
<div class="col width-60">
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_7');
?>
</legend>
<?php
echo JText::_('MEMBER_TABLE_8');
?>
</fieldset>
</div>
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_9');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="name"><?php
echo JText::_('MEMBER_TABLE_10');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="name" id="name" size="40" maxlength="60" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Spielername;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_11');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="mglnr"><?php
echo JText::_('MEMBER_TABLE_12');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="mglnr" id="mglnr" size="7" maxlength="7" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Mgl_Nr;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_13');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="dwz"><?php
echo JText::_('MEMBER_TABLE_14');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="dwz" id="dwz" size="7" maxlength="4" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->DWZ;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_15');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="dwz_index"><?php
echo JText::_('MEMBER_TABLE_16');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="dwz_index" id="dwz_index" size="7" maxlength="4" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->DWZ_Index;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_17');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="geschlecht"><?php
echo JText::_('MEMBER_TABLE_18');
?>
</label>
</td>
<td>
<select size="1" name="geschlecht" id="geschlecht">
<option value="0" <?php
if ($spieler[0]->Geschlecht != "M" and $spieler[0]->Geschlecht != "W") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_19');
?>
</option>
<option value="M" <?php
if ($spieler[0]->Geschlecht == "M") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_20');
?>
</option>
<option value="W" <?php
if ($spieler[0]->Geschlecht == "W") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_21');
?>
</option>
</td>
<td>Bspl. W</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="geburtsjahr"><?php
echo JText::_('MEMBER_TABLE_22');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="geburtsjahr" id="geburtsjahr" size="7" maxlength="4" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Geburtsjahr;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_23');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="status"><?php
echo JText::_('MEMBER_TABLE_32');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="status" id="status" size="1" maxlength="1" <?php
if ($filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Status;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_33');
?>
</td>
</tr>
<tr>
<td colspan="2"><?php
echo JText::_('MEMBER_TABLE_24');
?>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_25');
?>
</td>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_26');
}
?>
</fieldset>
</div>
<div>
<?php
$zps = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$spl = CLMControllerDWZ::spieler($zps);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_27');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" nowrap="nowrap">
<select size="1" name="spieler">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($spl); $x++) {
?>
<option value="<?php
echo $spl[$x]->Mgl_Nr;
?>
"><?php
echo $spl[$x]->Spielername;
?>
</option>
<?php
}
?>
</select>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
</fieldset>
</div>
<?php
if (CLM_usertype === 'admin' or CLM_usertype === 'dv' or CLM_usertype === 'dwz') {
?>
<div>
<?php
$zps = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$spl = CLMControllerDWZ::spieler($zps);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_30');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" nowrap="nowrap">
<select size="1" name="del_spieler">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($verein); $x++) {
?>
<option value="<?php
echo $verein[$x]->Mgl_Nr;
?>
"><?php
echo $verein[$x]->Mgl_Nr . ' - ' . $verein[$x]->Spielername;
?>
</option>
<?php
}
?>
</select>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
</fieldset>
</div>
<?php
}
?>
</div>
<div class="clr"></div>
<?php
if (!isset($verein[0]->sid)) {
$verein[0]->sid = $lists['saison'][0]->id;
}
?>
<input type="hidden" name="section" value="dwz" />
<input type="hidden" name="option" value="com_clm" />
<input type="hidden" name="zps" value="<?php
echo $filter_vid;
?>
" />
<input type="hidden" name="mgl" value="<?php
echo $filter_mgl;
?>
" />
<input type="hidden" name="sid" value="<?php
echo $verein[0]->sid;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHTML::_('form.token');
?>
</form>
<?php
}
static function DWZ($spieler, $verein, $verein_from, $lists, $pageNav, $option)
{
// Konfigurationsparameter auslesen
$config = clm_core::$db->config();
$countryversion = $config->countryversion;
CLMViewDWZ::setDWZToolbar($countryversion);
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
$clmAccess = clm_core::$access;
?>
<script language="javascript" type="text/javascript">
function edit()
{
var task = document.getElementsByName ( "task") [0];
var pre_task = document.getElementsByName ( "pre_task") [0];
task.value = "add";
pre_task.value = "add";
document.adminForm.submit();
}
Joomla.submitbutton = function (pressbutton) {
var form = document.adminForm;
var pre_task = document.getElementsByName ( "pre_task") [0];
if (pre_task.value == 'add') {
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.filter_vid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_1', true);
?>
" );
} else if (form.filter_sid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_2', true);
?>
" );
} else if (form.filter_gid.value == "0") {
alert( "<?php
echo JText::_('MEMBER_JS_3', true);
?>
" );
} else {
submitform( pressbutton );
}
} else {
submitform( pressbutton );
}
}
</script>
<form action="index.php" method="post" name="adminForm" id="adminForm">
<table class="admintable">
<tr><td>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_DATA');
?>
</legend>
<?php
echo $lists['vid'];
?>
<?php
if (isset($lists['mgl'])) {
echo $lists['mgl'];
}
?>
<?php
$mainframe = JFactory::getApplication();
$filter_sort = $mainframe->getUserStateFromRequest("{$option}.filter_sort", 'filter_sort', 0, 'string');
?>
<select name="filter_sort" id="filter_sort" class="inputbox" size="1" onchange="document.adminForm.submit();">
<option value="0" <?php
if ($filter_sort == "0") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_1');
?>
</option>
<option value="(0+Mgl_Nr) DESC" <?php
if ($filter_sort == "(0+Mgl_Nr) DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_2');
?>
</option>
<option value="(0+Mgl_Nr) ASC" <?php
if ($filter_sort == "(0+Mgl_Nr) ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_3');
?>
</option>
<option value="Spielername DESC" <?php
if ($filter_sort == "Spielername DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_4');
?>
</option>
<option value="Spielername ASC" <?php
if ($filter_sort == "Spielername ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_5');
?>
</option>
<option value="DWZ DESC" <?php
if ($filter_sort == "DWZ DESC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_6');
?>
</option>
<option value="DWZ ASC" <?php
if ($filter_sort == "DWZ ASC") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_DD_7');
?>
</option>
</select>
</fieldset>
</td>
</tr>
</table>
<?php
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
?>
<div class="width-40 fltlft">
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_1');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<th width="4%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_2');
?>
</th>
<th width="20%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_3');
?>
</th>
<?php
if ($countryversion == "de") {
?>
<th width="4%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_4');
?>
</th>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_5');
?>
</th>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_51');
?>
</th>
<?php
} else {
?>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_5E');
?>
</th>
<th width="5%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_51E');
?>
</th>
<?php
}
?>
<th width="3%" class="key" nowrap="nowrap"><?php
echo JText::_('St');
?>
</th>
<th width="4%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_53');
?>
</th>
<th width="3%" class="key" nowrap="nowrap"><?php
echo JText::_('MEMBER_TABLE_54');
?>
</th>
</tr>
<?php
for ($x = 0; $x < count($verein); $x++) {
?>
<tr>
<td class="key" nowrap="nowrap">
<?php
echo $x + 1;
?>
</td>
<td class="key" width="25%" nowrap="nowrap">
<?php
echo $verein[$x]->Spielername;
?>
</td>
<?php
if ($countryversion == "de") {
?>
<td class="key" nowrap="nowrap">
<?php
echo $verein[$x]->Mgl_Nr;
?>
</td>
<td class="key" nowrap="nowrap">
<?php
echo $verein[$x]->DWZ . " - " . $verein[$x]->DWZ_Index;
?>
</td>
<?php
} else {
?>
<td class="key" nowrap="nowrap">
<?php
echo $verein[$x]->DWZ;
?>
</td>
<?php
}
?>
<td class="key" nowrap="nowrap">
<?php
echo $verein[$x]->PKZ;
?>
</td>
<td class="key" nowrap="nowrap">
<?php
echo $verein[$x]->Status;
?>
</td>
<td class="key" nowrap="nowrap">
<?php
if ($verein[$x]->Geburtsjahr != '0000') {
echo $verein[$x]->Geburtsjahr;
}
?>
</td>
<td class="key" nowrap="nowrap">
<?php
if ($verein[$x]->Geschlecht != 'M') {
echo $verein[$x]->Geschlecht;
}
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_6');
}
?>
</fieldset>
</div>
<div class="width-60 fltrt">
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_7');
?>
</legend>
<?php
echo JText::_('MEMBER_TABLE_8');
?>
</fieldset>
</div>
<div>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_9');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="name"><?php
echo JText::_('MEMBER_TABLE_10');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="name" id="name" size="40" maxlength="60" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Spielername;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_11');
?>
</td>
</tr>
<?php
if ($countryversion == "de") {
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="mglnr"><?php
echo JText::_('MEMBER_TABLE_12');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="mglnr" id="mglnr" size="7" maxlength="7" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Mgl_Nr;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_13');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="mglnr"><?php
echo JText::_('MEMBER_TABLE_121');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="PKZ" id="PKZ" size="10" maxlength="10" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->PKZ;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_131');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="dwz"><?php
echo JText::_('MEMBER_TABLE_14');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="dwz" id="dwz" size="7" maxlength="4" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->DWZ;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_15');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="dwz_index"><?php
echo JText::_('MEMBER_TABLE_16');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="dwz_index" id="dwz_index" size="7" maxlength="4" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->DWZ_Index;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_17');
?>
</td>
</tr>
<?php
} else {
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="mglnr"><?php
echo JText::_('MEMBER_TABLE_12E');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="mglnr" id="mglnr" size="7" maxlength="7" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Mgl_Nr;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_13E');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="mglnr"><?php
echo JText::_('MEMBER_TABLE_121E');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="PKZ" id="PKZ" size="10" maxlength="10" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->PKZ;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_131E');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="dwz"><?php
echo JText::_('MEMBER_TABLE_14E');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="dwz" id="dwz" size="7" maxlength="4" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->DWZ;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_15E');
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="geschlecht"><?php
echo JText::_('MEMBER_TABLE_18');
?>
</label>
</td>
<td>
<select size="1" name="geschlecht" id="geschlecht">
<option value="0" <?php
if (isset($filter_mgl) and $spieler[0]->Geschlecht != "M" and $spieler[0]->Geschlecht != "W") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_19');
?>
</option>
<option value="M" <?php
if (isset($filter_mgl) and $spieler[0]->Geschlecht == "M") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_20');
?>
</option>
<option value="W" <?php
if (isset($filter_mgl) and $spieler[0]->Geschlecht == "W") {
?>
selected="selected"<?php
}
?>
><?php
echo JText::_('MEMBER_TABLE_21');
?>
</option>
</td>
<td>Bspl. W</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="geburtsjahr"><?php
echo JText::_('MEMBER_TABLE_22');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="geburtsjahr" id="geburtsjahr" size="7" maxlength="4" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Geburtsjahr;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_23');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="status"><?php
echo JText::_('MEMBER_TABLE_32');
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="status" id="status" size="1" maxlength="1" <?php
if (isset($filter_mgl) and $filter_mgl != "0") {
?>
value="<?php
echo $spieler[0]->Status;
?>
"<?php
}
?>
/>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_33');
?>
</td>
</tr>
<tr>
<td colspan="2"><?php
echo JText::_('MEMBER_TABLE_24');
?>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_25');
?>
</td>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_26');
}
?>
</fieldset>
</div>
<div>
<?php
$zps = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$spl = CLMControllerDWZ::spieler($zps);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_27');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" nowrap="nowrap">
<select size="1" name="spieler">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($spl); $x++) {
?>
<?php
if ($countryversion == "de") {
?>
<option value="<?php
echo $spl[$x]->Mgl_Nr;
?>
"><?php
echo $spl[$x]->Spielername;
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $spl[$x]->PKZ;
?>
"><?php
echo $spl[$x]->Spielername;
?>
</option>
<?php
}
}
?>
</select>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
</fieldset>
</div>
<?php
if ($clmAccess->access('BE_club_edit_member') === true) {
?>
<div>
<?php
$zps = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$spl = CLMControllerDWZ::spieler($zps);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_30');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" nowrap="nowrap">
<select size="1" name="del_spieler">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($verein); $x++) {
?>
<?php
if ($countryversion == "de") {
?>
<option value="<?php
echo $verein[$x]->Mgl_Nr;
?>
"><?php
echo $verein[$x]->Mgl_Nr . ' - ' . $verein[$x]->Spielername;
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $verein[$x]->PKZ;
?>
"><?php
echo $verein[$x]->PKZ . ' - ' . $verein[$x]->Spielername;
?>
</option>
<?php
}
}
?>
</select>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
</fieldset>
</div>
<?php
}
?>
<?php
if ($clmAccess->access('BE_database_general') === true and $countryversion == "en") {
?>
<div>
<?php
$zps = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$spl = CLMControllerDWZ::spieler($zps);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_MOVE_0');
?>
</legend>
<?php
if ($filter_vid != "0") {
?>
<table class="admintable">
<tr>
<td class="key" nowrap="nowrap">
<select size="1" name="spieler_to">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($verein); $x++) {
?>
<?php
if ($countryversion == "de") {
?>
<option value="<?php
echo $verein[$x]->Mgl_Nr;
?>
"><?php
echo $verein[$x]->Mgl_Nr . ' - ' . $verein[$x]->Spielername;
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $verein[$x]->PKZ;
?>
"><?php
echo $verein[$x]->PKZ . ' - ' . $verein[$x]->Spielername;
?>
</option>
<?php
}
}
?>
</select>
</td>
<td><?php
echo JText::_('MEMBER_TABLE_MOVE_TO');
?>
</td>
<td><?php
echo $lists['vid_to'];
?>
</td>
</tr>
</table>
<?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
</fieldset>
</div>
<?php
}
if ($clmAccess->access('BE_database_general') === true and $countryversion == "en") {
?>
<div>
<?php
//$zps = $mainframe->getUserStateFromRequest( "$option.filter_vid",'filter_vid',0,'var' );
//$spl = CLMControllerDWZ::spieler($filter_vid_from);
?>
<fieldset class="adminform">
<legend><?php
echo JText::_('MEMBER_TABLE_MOVE_1');
?>
</legend>
<!--- <?php
if ($filter_vid_from != "0") {
?>
-->
<table class="admintable">
<tr>
<td><?php
echo JText::_('MEMBER_TABLE_MOVE_FROM');
?>
</td>
<td><?php
echo $lists['vid_from'];
?>
</td>
<td><?php
echo ' ';
?>
</td>
<td class="key" nowrap="nowrap">
<select size="1" name="spieler_from">
<option value="0"><?php
echo JText::_('MEMBER_TABLE_28');
?>
</option>
<?php
for ($x = 0; $x < count($verein_from); $x++) {
?>
<?php
if ($countryversion == "de") {
?>
<option value="<?php
echo $verein_from[$x]->Mgl_Nr;
?>
"><?php
echo $verein_from[$x]->Mgl_Nr . ' - ' . $verein_from[$x]->Spielername;
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $verein_from[$x]->PKZ;
?>
"><?php
echo $verein_from[$x]->PKZ . ' - ' . $verein_from[$x]->Spielername;
?>
</option>
<?php
}
}
?>
</select>
</td>
</tr>
</table>
<!--- <?php
} else {
echo JText::_('MEMBER_TABLE_29');
}
?>
-->
</fieldset>
</div>
<?php
}
?>
</div>
<div class="clr"></div>
<?php
if (isset($verein[0]->sid)) {
$sid = $verein[0]->sid;
} elseif (isset($lists['saison'][0]->id)) {
$sid = $lists['saison'][0]->id;
} else {
$sid = false;
}
?>
<input type="hidden" name="section" value="dwz" />
<input type="hidden" name="option" value="com_clm" />
<input type="hidden" name="zps" value="<?php
echo $filter_vid;
?>
" />
<?php
if (isset($filter_mgl)) {
?>
<input type="hidden" name="mgl" value="<?php
echo $filter_mgl;
?>
" />
<?php
}
?>
<?php
if (!($sid === false)) {
echo '<input type="hidden" name="sid" value="' . $sid . '" />';
}
?>
<input type="hidden" name="task" value="" />
<input type="hidden" name="pre_task" value="" />
<?php
echo JHtml::_('form.token');
?>
</form>
<?php
}
