public static function mannschaft(&$row, $lists, $option)
{
CLMViewMannschaften::setMannschaftToolbar();
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
?>
<script language="javascript" type="text/javascript">
Joomla.submitbutton = function (pressbutton) {
var form = document.adminForm;
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.name.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_NAMEN_ANGEBEN', true);
?>
" );
} else if (form.man_nr.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_NUMMER_ANGEBEN', true);
?>
" );
} else if (form.tln_nr.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_TEILNEHMER_NR_ANGEBEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','sid') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_SAISON_AUSWAEHLEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','liga') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_LIGA_AUSWAEHLEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','zps') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_VEREIN_AUSWAEHLEN', true);
?>
" );
} else {
submitform( pressbutton );
}
}
</script>
<form action="index.php" method="post" name="adminForm" id="adminForm">
<div class="width-50 fltlft">
<fieldset class="adminform">
<legend><?php
echo JText::_('Details');
?>
</legend>
<table class="admintable">
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="name">
<span class="editlinktip hasTip" title="<?php
echo JText::_('MANNSCHAFT_HINT');
?>
">
<?php
echo JText::_('MANNSCHAFT') . " : ";
?>
</span></label>
</td>
<td>
<input class="inputbox" type="text" name="name" id="name" size="50" maxlength="60" value="<?php
echo $row->name;
?>
" />
</td>
</tr>
<?php
if ($lists['pgntype'] > 3) {
?>
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="sname"><?php
echo JText::_('MANNSCHAFT_SHORT') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="sname" id="sname" size="50" maxlength="60" value="<?php
echo $row->sname;
?>
" />
</td>
</tr>
<?php
}
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="contact"><?php
echo JText::_('MANNSCHAFT_NUMMER') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="man_nr" id="man_nr" size="50" maxlength="60" value="<?php
echo $row->man_nr;
?>
" />
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="tln_nr"><?php
echo JText::_('MANNSCHAFT_TEILNEHMER_NR') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="tln_nr" id="tln_nr" size="50" maxlength="60" value="<?php
echo $row->tln_nr;
?>
" />
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="sid"><?php
echo JText::_('MANNSCHAFT_SAISON') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['saison'];
?>
</td>
</tr>
<tr>
<td class="key" ><label for="liga"><?php
echo JText::_('MANNSCHAFT_LIGA') . " :";
?>
</label>
</td>
<td>
<?php
echo $lists['liga'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="verein">
<span class="editlinktip hasTip" title="<?php
echo JText::_('MANNSCHAFT_HINT');
?>
">
<?php
echo JText::_('MANNSCHAFT_VEREIN') . " : ";
?>
</span></label>
</td>
<td>
<?php
echo $lists['verein'];
?>
</td>
</tr>
<?php
for ($i = 0; $i < $lists['anz_sgp']; $i++) {
?>
<tr>
<td class="key" nowrap="nowrap"><label for="<?php
echo 'sg_zps' . $i;
?>
"><?php
echo JText::_('MANNSCHAFT_PARTNERVEREIN') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['sg' . $i];
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="key" nowrap="nowrap"><label for="mf"><?php
echo JText::_('MANNSCHAFT_FUEHRER') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['mf'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="published"><?php
echo JText::_('JPUBLISHED') . " : ";
?>
</label>
</td>
<td><fieldset class="radio">
<?php
echo $lists['published'];
?>
</fieldset></td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="abzug"><?php
echo JText::_('MANNSCHAFT_ABZUG') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="abzug" id="abzug" size="10" maxlength="10" value="<?php
echo $row->abzug;
?>
" />
</td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td class="key" nowrap="nowrap">
<label for="lokal">
<span class="editlinktip hasTip" title="<?php
echo JText::_('MANNSCHAFT_HINT');
?>
">
<?php
echo JText::_('MANNSCHAFT_SPIELLOKAL') . " : ";
?>
</span></label>
</td>
<td>
<?php
echo JText::_('CLM_KOMMA') . "<br><br>";
?>
<textarea class="inputbox" name="lokal" id="lokal" cols="40" rows="2" style="width:100%"><?php
echo $row->lokal;
?>
</textarea>
<br><?php
echo JText::_('CLM_ADDRESS');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_ADRESSE') . " : ";
?>
</label>
</td>
<td>
<textarea class="inputbox" name="adresse" id="adresse" cols="40" rows="2" style="width:100%"><?php
echo $row->adresse;
?>
</textarea>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_TERMINE') . " : ";
?>
</label>
</td>
<td>
<textarea class="inputbox" name="termine" id="termine" cols="40" rows="2" style="width:100%"><?php
echo $row->termine;
?>
</textarea>
<br><?php
echo JText::_('CLM_TERMINE');
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_HOMEPAGE') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="homepage" id="homepage" size="50" value="<?php
echo $row->homepage;
?>
" />
</td>
</tr>
</table>
</fieldset>
</div>
<div class="width-50 fltrt">
<fieldset class="adminform">
<legend><?php
echo JText::_('REMARKS');
?>
</legend>
<table class="adminlist">
<legend><?php
echo JText::_('REMARKS_PUBLIC');
?>
</legend>
<br>
<tr>
<td width="100%" valign="top">
<textarea class="inputbox" name="bemerkungen" id="bemerkungen" cols="40" rows="5" style="width:90%"><?php
echo str_replace('&', '&', $row->bemerkungen);
?>
</textarea>
</td>
</tr>
</table>
<table class="adminlist">
<tr><legend><?php
echo JText::_('REMARKS_INTERNAL');
?>
</legend>
<br>
<td width="100%" valign="top">
<textarea class="inputbox" name="bem_int" id="bem_int" cols="40" rows="5" style="width:90%"><?php
echo str_replace('&', '&', $row->bem_int);
?>
</textarea>
</td>
</tr>
</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="pre_man" value="<?php
echo $row->man_nr;
?>
" />
<input type="hidden" name="cid" value="<?php
echo $row->cid;
?>
" />
<input type="hidden" name="client_id" value="<?php
echo $row->cid;
?>
" />
<input type="hidden" name="liste" value="<?php
echo $row->liste;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHtml::_('form.token');
?>
</form>
<?php
}
function edit()
{
global $mainframe, $option;
$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');
JArrayHelper::toInteger($cid, array(0));
$row =& JTable::getInstance('mannschaften', 'TableCLM');
// load the row from the db table
$row->load($cid[0]);
$sid = $row->sid;
if ($task == "add") {
$sql = 'SELECT id FROM #__clm_saison WHERE archiv = 0 and published = 1';
$db->setQuery($sql);
$sid = $db->loadResult();
}
// Prüfen ob User Berechtigung zum editieren hat
$sql = " SELECT sl, params FROM #__clm_liga " . " WHERE id =" . $row->liga;
$db->setQuery($sql);
$lid = $db->loadObjectList();
if ($task == 'edit') {
$saison =& JTable::getInstance('saisons', 'TableCLM');
$saison->load($sid);
// illegaler Einbruchversuch über URL !
// evtl. mitschneiden !?!
if ($saison->archiv == "1" and CLM_usertype !== 'admin') {
JError::raiseWarning(500, JText::_('MANNSCHAFTEN_ERROR_LIGA_ARCHIV'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg);
}
if ($lid[0]->sl != CLM_ID and CLM_usertype !== 'admin') {
JError::raiseWarning(500, JText::_('MANNSCHAFTEN_ERROR_MANNSCHAFT_STAFFEL'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link);
}
// do stuff for existing records
$row->checkout($user->get('id'));
} else {
// do stuff for new records
$row->published = 0;
}
// Ligaliste
$sql = " SELECT a.id as liga, a.name FROM #__clm_liga as a" . " LEFT JOIN #__clm_saison as s ON s.id = a.sid " . " WHERE s.archiv = 0 AND a.sl = " . CLM_ID;
// wenn User Admin
if (CLM_usertype === 'admin') {
$sql = "SELECT a.id as liga, a.name FROM #__clm_liga as a" . " LEFT JOIN #__clm_saison as s ON s.id = a.sid " . " WHERE s.archiv = 0 ";
}
$db->setQuery($sql);
$non_sl = $db->loadObjectList();
// Falls kein SL einer Liga dann kann auch keine Mannschaft angelegt werden
if (!isset($non_sl[0]->liga) and CLM_usertype !== 'admin') {
JError::raiseWarning(500, JText::_('MANNSCHAFTEN_ERROR_STAFFEL_MANNSCHAFT'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link);
}
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$ligalist[] = JHTML::_('select.option', '0', JText::_('MANNSCHAFTEN_LIGA'), 'liga', 'name');
$ligalist = array_merge($ligalist, $db->loadObjectList());
$lists['liga'] = JHTML::_('select.genericlist', $ligalist, 'liga', 'class="inputbox" size="1"', 'liga', 'name', $row->liga);
$lists['published'] = JHTML::_('select.booleanlist', 'published', 'class="inputbox"', $row->published);
// Vereinefilter laden
require_once JPATH_COMPONENT . DS . 'controllers' . DS . 'filter_vereine.php';
$vereinlist = CLMFilterVerein::vereine_filter(0);
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1" ', 'zps', 'name', $row->zps);
// Spielgemeinschaft
$lists['sg'] = JHTML::_('select.genericlist', $vereinlist, 'sg_zps', 'class="inputbox" size="1" ', 'zps', 'name', $row->sg_zps);
// MFliste
if ($task == 'edit') {
$where = " AND ( a.zps = '" . $row->zps . "' OR a.zps = '" . $row->sg_zps . "') AND a.published = 1";
} else {
$where = ' AND a.zps = 0 AND a.published = 1';
}
$tql = ' SELECT a.jid as mf, a.name as mfname' . ' FROM #__clm_user AS a ' . " LEFT JOIN #__clm_saison as s ON s.id = a.sid " . " WHERE s.archiv = 0 " . $where;
$db->setQuery($tql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$mflist[] = JHTML::_('select.option', '0', JText::_('MANNSCHAFTEN_MANNSCHAFTFUEHRER'), 'mf', 'mfname');
$mflist = array_merge($mflist, $db->loadObjectList());
$lists['mf'] = JHTML::_('select.genericlist', $mflist, 'mf', 'class="inputbox" size="1"', 'mf', 'mfname', $row->mf);
// Saisonliste
if ($task == "edit") {
$sql = 'SELECT id as sid, name FROM #__clm_saison WHERE id=' . $sid;
} else {
$sql = 'SELECT id as sid, name FROM #__clm_saison WHERE archiv =0';
}
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
if ($task != "edit") {
$saisonlist[] = JHTML::_('select.option', '0', JText::_('MANNSCHAFTEN_SAISON'), 'sid', 'name');
$saisonlist = array_merge($saisonlist, $db->loadObjectList());
} else {
$saisonlist = $db->loadObjectList();
}
$lists['saison'] = JHTML::_('select.genericlist', $saisonlist, 'sid', 'class="inputbox" size="1"', 'sid', 'name', $row->sid);
//Liga-Parameter aufbereiten
$paramsStringArray = explode("\n", $lid[0]->params);
$lid_params = array();
foreach ($paramsStringArray as $value) {
$ipos = strpos($value, '=');
if ($ipos !== false) {
$lid_params[substr($value, 0, $ipos)] = substr($value, $ipos + 1);
}
}
if (isset($lid_params[pgntype])) {
$lists['pgntype'] = $lid_params[pgntype];
} else {
$lists['pgntype'] = 0;
}
require_once JPATH_COMPONENT . DS . 'views' . DS . 'mannschaft.php';
CLMViewMannschaften::mannschaft($row, $lists, $option);
}
function mannschaft(&$row, $lists, $option)
{
CLMViewMannschaften::setMannschaftToolbar();
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'extrainfo');
?>
<script language="javascript" type="text/javascript">
<!--
function submitbutton(pressbutton) {
var form = document.adminForm;
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.name.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_NAMEN_ANGEBEN', true);
?>
" );
} else if (form.man_nr.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_NUMMER_ANGEBEN', true);
?>
" );
} else if (form.tln_nr.value == "") {
alert( "<?php
echo JText::_('MANNSCHAFT_TEILNEHMER_NR_ANGEBEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','sid') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_SAISON_AUSWAEHLEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','liga') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_LIGA_AUSWAEHLEN', true);
?>
" );
} else if ( getSelectedValue('adminForm','zps') == 0 ) {
alert( "<?php
echo JText::_('MANNSCHAFT_VEREIN_AUSWAEHLEN', true);
?>
" );
} else {
submitform( pressbutton );
}
}
//-->
</script>
<form action="index.php" method="post" name="adminForm">
<div class="col width-50">
<fieldset class="adminform">
<legend><?php
echo JText::_('Details');
?>
</legend>
<table class="admintable">
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="name"><?php
echo JText::_('MANNSCHAFT') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="name" id="name" size="50" maxlength="60" value="<?php
echo $row->name;
?>
" />
</td>
</tr>
<?php
if ($lists['pgntype'] > 3) {
?>
<tr>
<td class="key" width="20%" nowrap="nowrap">
<label for="sname"><?php
echo JText::_('MANNSCHAFT_SHORT') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="sname" id="sname" size="50" maxlength="60" value="<?php
echo $row->sname;
?>
" />
</td>
</tr>
<?php
}
?>
<tr>
<td class="key" nowrap="nowrap">
<label for="contact"><?php
echo JText::_('MANNSCHAFT_NUMMER') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="man_nr" id="man_nr" size="50" maxlength="60" value="<?php
echo $row->man_nr;
?>
" />
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="tln_nr"><?php
echo JText::_('MANNSCHAFT_TEILNEHMER_NR') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="tln_nr" id="tln_nr" size="50" maxlength="60" value="<?php
echo $row->tln_nr;
?>
" />
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="sid"><?php
echo JText::_('MANNSCHAFT_SAISON') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['saison'];
?>
</td>
</tr>
<tr>
<td class="key" ><label for="liga"><?php
echo JText::_('MANNSCHAFT_LIGA') . " :";
?>
</label>
</td>
<td>
<?php
echo $lists['liga'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="verein"><?php
echo JText::_('MANNSCHAFT_VEREIN') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['verein'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="sg_zps"><?php
echo JText::_('MANNSCHAFT_PARTNERVEREIN') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['sg'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="mf"><?php
echo JText::_('MANNSCHAFT_FUEHRER') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['mf'];
?>
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_SPIELLOKAL') . " : ";
?>
</label>
</td>
<td>
<textarea class="inputbox" name="lokal" id="lokal" cols="40" rows="3" style="width:90%"><?php
echo $row->lokal;
?>
</textarea>
</td>
<td>
<?php
echo JText::_('CLM_KOMMA') . "<br><br>";
?>
( max. 3 Zeilen werden im Frontend dargestellt)
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_ADRESSE') . " : ";
?>
</label>
</td>
<td>
<textarea class="inputbox" name="adresse" id="adresse" cols="40" rows="2" style="width:90%"><?php
echo $row->adresse;
?>
</textarea>
</td>
<td>( max. 3 Zeilen werden im Frontend dargestellt)
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_TERMINE') . " : ";
?>
</label>
</td>
<td>
<textarea class="inputbox" name="termine" id="termine" cols="40" rows="2" style="width:90%"><?php
echo $row->termine;
?>
</textarea>
</td>
<td>( max. 3 Zeilen werden im Frontend dargestellt)
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="lokal"><?php
echo JText::_('MANNSCHAFT_HOMEPAGE') . " : ";
?>
</label>
</td>
<td>
<input class="inputbox" type="text" name="homepage" id="homepage" size="50" value="<?php
echo $row->homepage;
?>
" />
<br>
</td>
<td>z.B.: http://www.beispiel.de
</td>
</tr>
<tr>
<td class="key" nowrap="nowrap"><label for="published"><?php
echo JText::_('PUBLISHED') . " : ";
?>
</label>
</td>
<td>
<?php
echo $lists['published'];
?>
</td>
</tr>
</table>
</fieldset>
</div>
<div class="col width-50">
<fieldset class="adminform">
<legend><?php
echo JText::_('MANNSCHAFT_BEMERKUNGEN');
?>
</legend>
<table class="adminlist">
<legend><?php
echo JText::_('MANNSCHAFT_OEFFENTLICH');
?>
</legend>
<br>
<tr>
<td width="100%" valign="top">
<textarea class="inputbox" name="bemerkungen" id="bemerkungen" cols="40" rows="5" style="width:90%"><?php
echo str_replace('&', '&', $row->bemerkungen);
?>
</textarea>
</td>
</tr>
</table>
<table class="adminlist">
<tr><legend><?php
echo JText::_('MANNSCHAFT_INTERN');
?>
</legend>
<br>
<td width="100%" valign="top">
<textarea class="inputbox" name="bem_int" id="bem_int" cols="40" rows="5" style="width:90%"><?php
echo str_replace('&', '&', $row->bem_int);
?>
</textarea>
</td>
</tr>
</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="pre_man" value="<?php
echo $row->man_nr;
?>
" />
<input type="hidden" name="cid" value="<?php
echo $row->cid;
?>
" />
<input type="hidden" name="client_id" value="<?php
echo $row->cid;
?>
" />
<input type="hidden" name="liste" value="<?php
echo $row->liste;
?>
" />
<input type="hidden" name="task" value="" />
<?php
echo JHTML::_('form.token');
?>
</form>
<?php
}