Пример #1
0
 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);
 }
Пример #2
0
 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);
 }
Пример #3
0
    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'];
        ?>
&nbsp;&nbsp;
		<?php 
        echo $lists['mgl'];
        ?>
&nbsp;&nbsp;
		<?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 
    }
Пример #4
0
    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'];
        ?>
&nbsp;&nbsp;
		<?php 
        if (isset($lists['mgl'])) {
            echo $lists['mgl'];
        }
        ?>
&nbsp;&nbsp;
		<?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 '&nbsp;&nbsp;';
                ?>
</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 
    }