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 edit()
{
$mainframe = JFactory::getApplication();
$option = JRequest::getCmd('option');
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'var');
$filter_sid = $mainframe->getUserStateFromRequest("{$option}.filter_sid", 'filter_sid', 0, 'int');
$filter_gid = $mainframe->getUserStateFromRequest("{$option}.filter_gid", 'filter_gid', 0, 'int');
$db = JFactory::getDBO();
$user = JFactory::getUser();
$task = JRequest::getVar('task');
$cid = JRequest::getVar('cid', array(0), '', 'array');
$section = JRequest::getVar('section');
JArrayHelper::toInteger($cid, array(0));
$row = JTable::getInstance('ranglisten', 'TableCLM');
$vname = "";
$gname = "";
$sname = "";
if ($task == 'edit') {
// illegaler Einbruchversuch über URL !
// evtl. mitschneiden !?!
$saison = JTable::getInstance('saisons', 'TableCLM');
$saison->load($row->sid);
if ($saison->archiv == "1") {
// AND clm_core::$access->getType() !== 'admin') {
JError::raiseWarning(500, JText::_('RANGLISTE_ARCHIV'));
$mainframe->redirect('index.php?option=' . $option . '§ion=vereine', $msg);
}
if ($cid[0] == "" and $task == 'edit') {
JError::raiseWarning(500, JText::_('RANGLISTE_FALSCH'));
$mainframe->redirect('index.php?option=' . $option . '§ion=vereine', $msg);
}
// load the row from the db table
$row->load($cid[0]);
$sql = " SELECT Vereinname as vname FROM #__clm_dwz_vereine " . " WHERE ZPS ='" . $row->zps . "'" . " AND sid =" . $row->sid;
$db->setQuery($sql);
$vid = $db->loadObjectList();
$vname = $vid[0]->vname;
$sql = " SELECT Gruppe as gname FROM #__clm_rangliste_name " . " WHERE id =" . $row->gid . " AND sid =" . $row->sid;
$db->setQuery($sql);
$gruppe = $db->loadObjectList();
$gname = $gruppe[0]->gname;
$sql = " SELECT name as sname FROM #__clm_saison " . " WHERE id =" . $row->sid;
$db->setQuery($sql);
$saison = $db->loadObjectList();
$sname = $saison[0]->sname;
}
// Prüfen ob die gewählte Liste bereits existiert
if ($filter_gid and $filter_vid and $filter_sid) {
$sql = " SELECT id FROM #__clm_rangliste_id " . " WHERE gid =" . intval($filter_gid) . " AND sid = " . intval($filter_sid) . " AND zps = '{$filter_vid}'";
$db->setQuery($sql);
$gid_check = $db->loadObjectList();
if (count($gid_check) == 0) {
$exist = 0;
} else {
$exist = $gid_check[0]->id;
}
} else {
$exist = 0;
}
// Prüfen ob Gruppe existiert
if ($filter_gid and $filter_sid) {
$sql = " SELECT id FROM #__clm_rangliste_name " . " WHERE sid = " . intval($filter_sid);
$db->setQuery($sql);
$gid_id = $db->loadObjectList();
$gid_exist = $gid_id[0]->id;
} else {
$gid_exist = 0;
}
// Rangliste in Abhängigkeit der Auswahl von vid,lid,sid ausgeben
if ($task == 'edit') {
$sql = " ALTER TABLE #__clm_rangliste_spieler order by sid desc,gruppe asc,zps asc,man_nr asc,Rang asc ";
$db->setQuery($sql);
$db->query();
$sql = " SELECT Meldeschluss, geschlecht, alter_grenze, `alter` " . " FROM #__clm_rangliste_name" . " WHERE id =" . $row->gid . " AND sid = " . $row->sid;
$sql_zps = $row->zps;
$sql_gid = $row->gid;
$sql_sid = $row->sid;
} else {
$sql = " SELECT Meldeschluss, geschlecht, alter_grenze, `alter` " . " FROM #__clm_rangliste_name" . " WHERE id =" . intval($filter_gid) . " AND sid = " . intval($filter_sid);
$sql_zps = $filter_vid;
$sql_gid = intval($filter_gid);
$sql_sid = intval($filter_sid);
}
$db->setQuery($sql);
$gid = $db->loadObjectList();
$ges = "";
$geb = "";
if ($gid) {
$melde = explode("-", $gid[0]->Meldeschluss);
$jahr = $melde[0];
if ($gid[0]->alter_grenze == "1") {
$geb = " AND a.Geburtsjahr < " . ($jahr - $gid[0]->alter);
}
if ($gid[0]->alter_grenze == "2") {
$geb = " AND a.Geburtsjahr > " . ($jahr - ($gid[0]->alter + 1));
}
if ($gid[0]->geschlecht == 1) {
$ges = " AND a.Geschlecht = 'W' ";
}
if ($gid[0]->geschlecht == 2) {
$ges = " AND a.Geschlecht = 'M' ";
}
}
if ($task == 'edit') {
$sql = " SELECT r.Rang, r.man_nr, a.sid,a.ZPS,a.Mgl_Nr,a.PKZ, a.DWZ," . " a.DWZ_Index,a.Geburtsjahr,a.Spielername" . " FROM #__clm_dwz_spieler as a" . " LEFT JOIN #__clm_rangliste_id as i ON i.sid = a.sid AND i.zps = a.ZPS " . " LEFT JOIN #__clm_rangliste_spieler as r ON r.sid = a.sid AND r.ZPS = a.ZPS AND r.Mgl_Nr = a.Mgl_Nr AND r.Gruppe = i.gid " . " WHERE a.ZPS = '{$sql_zps}'" . " AND i.id = " . $cid[0] . $geb . $ges . " ORDER BY r.man_nr,r.Rang ASC, a.DWZ DESC, a.DWZ_Index ASC, a.Spielername ASC ";
} else {
$sql = " SELECT a.sid,a.ZPS,a.Mgl_Nr,a.PKZ,a.DWZ,a.DWZ_Index,a.Geburtsjahr,a.Spielername" . " FROM #__clm_dwz_spieler as a" . " WHERE a.ZPS = '{$sql_zps}'" . " AND sid =" . $sql_sid . $geb . $ges . " ORDER BY a.DWZ DESC, a.DWZ_Index ASC, a.Spielername ASC ";
}
$db->setQuery($sql);
$spieler = $db->loadObjectList();
// Anzahl Einträge zählen
$sql = " SELECT COUNT(ZPS) as ZPS FROM #__clm_rangliste_spieler " . " WHERE Gruppe =" . $sql_gid . " AND sid = " . $sql_sid . " AND zps = '{$sql_zps}'";
$db->setQuery($sql);
$count_id = $db->loadObjectList();
$count = $count_id[0]->ZPS;
if (isset($row->liga)) {
$sql = " SELECT sl FROM #__clm_liga " . " WHERE id =" . $row->liga;
$db->setQuery($sql);
$lid = $db->loadObjectList();
} else {
$lid = 0;
}
$clmAccess = clm_core::$access;
if ($clmAccess->access('BE_club_edit_ranking') === false and $task == 'edit') {
JError::raiseWarning(500, JText::_('RANGLISTE_STAFFEL'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link);
}
if ($task == 'edit') {
// do stuff for existing records
$row->checkout($user->get('id'));
} else {
// do stuff for new records
$row->published = 0;
}
$lists['published'] = JHtml::_('select.booleanlist', 'published', 'class="inputbox"', $row->published);
// Saisonliste //
$sql = "SELECT id, name FROM #__clm_saison WHERE archiv =0";
$db->setQuery($sql);
$saisonlist[] = JHtml::_('select.option', '0', JText::_('RANGLISTE_SAISON_WAE'), 'id', 'name');
$saisonlist = array_merge($saisonlist, $db->loadObjectList());
$lists['sid'] = JHtml::_('select.genericlist', $saisonlist, 'filter_sid', 'class="inputbox" size="1" onchange="javascript:edit();"', 'id', 'name', intval($filter_sid));
if ($filter_sid == 0) {
$filter_sid = clm_core::$access->getSeason();
}
// Gruppenliste //
$sql = "SELECT id as gid, Gruppe FROM #__clm_rangliste_name" . " WHERE sid =" . intval($filter_sid) . " AND published = 1";
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$gruppenlist[] = JHtml::_('select.option', '0', JText::_('RANGLISTE_GRUPPE_AUS'), 'gid', 'Gruppe');
$gruppenlist = array_merge($gruppenlist, $db->loadObjectList());
$lists['gruppe'] = JHtml::_('select.genericlist', $gruppenlist, 'filter_gid', 'class="inputbox" size="1" onchange="javascript:edit();"', 'gid', 'Gruppe', intval($filter_gid));
// Vereinliste
// Vereinefilter laden
$vereinlist = CLMFilterVerein::vereine_filter(0);
$lists['vid'] = JHtml::_('select.genericlist', $vereinlist, 'filter_vid', 'class="inputbox" size="1" onchange="javascript:edit();"', 'zps', 'name', $filter_vid);
require_once JPATH_COMPONENT . DS . 'views' . DS . 'ranglisten.php';
$jid = 0;
CLMViewRanglisten::Rangliste($spieler, $row, $lists, $option, $jid, $vname, $gname, $sname, $cid, $exist, $count, $gid_exist);
}
function edit()
{
$mainframe = JFactory::getApplication();
$db = JFactory::getDBO();
$user = JFactory::getUser();
$task = JRequest::getVar('task');
$cid = JRequest::getVar('cid', array(0), '', 'array');
$option = JRequest::getCmd('option');
$section = JRequest::getVar('section');
JArrayHelper::toInteger($cid, array(0));
// Prüfen ob User Berechtigung zum editieren hat //
$row = JTable::getInstance('users', 'TableCLM');
$row->load($cid[0]);
$id = $row->jid;
$jid = $user->get('id');
//$gid = key($user->get('groups')); // 6 = Manager ; 7 = Admin; 8 = Superadmin ; 2= registered
// mit key wird hier nur der erste Schluessel (nicht content, obwohl derzeit identisch!)
// geliefert, beim späteren Zurückschreiben fehlen dann alle weiteren Rechte.
// besser also folgende Version nutzen:
$gids = $user->get('groups');
$gid = 0;
foreach ($gids as $key => $value) {
$ivalue = intval($value);
if ($ivalue == 2 || $ivalue == 6 || $ivalue == 7 || $ivalue == 8) {
if ($ivalue > $gid) {
// Reihenfolge der Values von oben beachten !
$gid = $ivalue;
}
}
}
$sid = $row->sid;
$clmAccess = clm_core::$access;
$usertypestring = $clmAccess->usertypelist();
// usertypes, die der aktive user ändern darf
// illegaler Einbruchversuch über URL !
// evtl. mitschneiden !?!
$saison = JTable::getInstance('saisons', 'TableCLM');
$saison->load($sid);
if ($task != 'add' && $saison->published == "0" && $clmAccess->access('BE_user_general')) {
JError::raiseWarning(500, JText::_('USERS_USER_BEAR'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg, "message");
}
if ($cid[0] == "" and $task == 'edit') {
JError::raiseWarning(500, JText::_('USERS_FALSCH'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg, "message");
}
$user_publish = new JUser($id);
// Es können keine Admin / Superadmin geändert werden von nicht-Superadmin-User
// Fehler: get('gid') existiert nicht mehr
// also erst wie oben gid laden, dann mit neuer gid prüfen
//if ( $user_publish->get('gid') > 6 AND $gid < 8 )
$newgid = 0;
$newgids = $user_publish->get('groups');
foreach ($newgids as $key => $value) {
$ivalue = intval($value);
if ($ivalue == 2 || $ivalue == 6 || $ivalue == 7 || $ivalue == 8) {
if ($ivalue > $newgid) {
// Reihenfolge der Values von oben beachten !
$newgid = $ivalue;
}
}
}
if ($newgid > 6 and $gid < 8) {
JError::raiseWarning(500, JText::_('USERS_NO_JOMMLA_ADMIN'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link, $msg, "message");
}
if (!$clmAccess->compare($row->usertype)) {
JError::raiseWarning(500, JText::_('USERS_BENUTZER'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link, $msg, "message");
}
if ($task == 'edit') {
// do stuff for existing records
$row->checkout($user->get('id'));
} else {
// do stuff for new records
$row->published = 0;
$row->aktive = 0;
}
// Vereinefilter laden
$vereinlist = CLMFilterVerein::vereine_filter(0);
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'string');
if ($filter_vid != "0") {
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1"', 'zps', 'name', $filter_vid);
} else {
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1"', 'zps', 'name', $row->zps);
}
// Publishliste
$lists['published'] = JHTML::_('select.booleanlist', 'published', 'class="inputbox"', $row->published);
// Saisonliste
if ($task == "edit") {
$season_list[] = JHTML::_('select.option', $sid, clm_core::$db->saison->get($sid)->name, 'sid', 'name');
$lists['saison'] = JHTML::_('select.genericlist', $season_list, 'sid', 'class="inputbox" size="1"', 'sid', 'name', $row->sid);
$sql = " SELECT u.* FROM #__users as u " . " LEFT JOIN #__clm_user as a ON u.id = a.jid AND a.sid IN ('" . $sid . "')" . " WHERE a.name IS NULL";
} else {
$season_list[] = JHTML::_('select.option', clm_core::$access->getSeason(), clm_core::$db->saison->get(clm_core::$access->getSeason())->name, 'sid', 'name');
$lists['saison'] = JHTML::_('select.genericlist', $season_list, 'sid', 'class="inputbox" size="1"', 'sid', 'name', clm_core::$access->getSeason());
$sql = " SELECT u.* FROM #__users as u " . " LEFT JOIN #__clm_user as a ON u.id = a.jid AND a.sid IN ('" . clm_core::$access->getSeason() . "')" . " WHERE a.name IS NULL";
}
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$jid_list[] = JHTML::_('select.option', '0', JText::_('USERS_USER_AUSW'), 'id', 'name');
$jid_list = array_merge($jid_list, $db->loadObjectList());
$lists['jid'] = JHTML::_('select.genericlist', $jid_list, 'pid', 'class="inputbox" size="1"', 'id', 'name', $row->jid);
// Funktionsliste
$sql = 'SELECT usertype, name FROM #__clm_usertype ';
$sql .= ' WHERE published = 1 ';
if ($usertypestring != "") {
$sql .= 'AND usertype OUT (' . $usertypestring . ' ) ';
}
$sql .= ' ORDER BY ordering ';
$db->setQuery($sql);
$usertypelist[] = JHTML::_('select.option', '', JText::_('USERS_TYP'), 'usertype', 'name');
$usertypelist = array_merge($usertypelist, $db->loadObjectList());
$lists['usertype'] = JHTML::_('select.genericlist', $usertypelist, 'usertype', 'class="inputbox" size="1"', 'usertype', 'name', $row->usertype);
require_once JPATH_COMPONENT . DS . 'views' . DS . 'users.php';
CLMViewUsers::user($row, $lists, $option);
}
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 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));
// Prüfen ob User Berechtigung zum editieren hat //
$row =& JTable::getInstance('users', 'TableCLM');
$row->load($cid[0]);
$id = $row->jid;
$jid = $user->get('id');
$gid = $user->get('gid');
$sid = $row->sid;
// illegaler Einbruchversuch über URL !
// evtl. mitschneiden !?!
$saison =& JTable::getInstance('saisons', 'TableCLM');
$saison->load($sid);
if ($saison->archiv == "1" and CLM_usertype !== 'admin') {
JError::raiseWarning(500, JText::_('USERS_USER_BEAR'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg);
}
if ($cid[0] == "" and $task == 'edit') {
JError::raiseWarning(500, JText::_('USERS_FALSCH'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg);
}
$acl =& JFactory::getACL();
$objectID = $acl->get_object_id('users', $id, 'ARO');
$groups = $acl->get_object_groups($objectID, 'ARO');
$this_group = strtolower($acl->get_group_name($groups[0], 'ARO'));
// User 62 (1. Superadmin) kann von niemanden geändert werden
$user_publish = new JUser($id);
if ($user_publish->get('id') == 62 and $user->get('id') != 62) {
JError::raiseWarning(500, JText::_('USERS_USER_NO'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link, $msg);
}
// Es können keine Admin / Superadmin geändert werden von nicht-Superadmin-User
if ($user_publish->get('gid') > 23 and $gid < 25) {
JError::raiseWarning(500, JText::_('USERS_NO_JOMMLA_ADMIN'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link, $msg);
}
// User kann nur niedrigere CLM-Berechtigungen ändern
$sql = "SELECT usertype, user_clm, jid FROM #__clm_user WHERE jid =" . $jid;
$db->setQuery($sql);
$clmuser = $db->loadObjectList();
if ($clmuser[0]->user_clm <= $row->user_clm and $jid != $row->jid and $gid != 25) {
JError::raiseWarning(500, JText::_('USERS_BENUTZER'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link, $msg);
}
if ($task == 'edit') {
// do stuff for existing records
$row->checkout($user->get('id'));
} else {
// do stuff for new records
$row->published = 0;
$row->aktive = 0;
}
// Vereinefilter laden
require_once JPATH_COMPONENT . DS . 'controllers' . DS . 'filter_vereine.php';
$vereinlist = CLMFilterVerein::vereine_filter(0);
$filter_vid = $mainframe->getUserStateFromRequest("{$option}.filter_vid", 'filter_vid', 0, 'string');
if ($filter_vid != "0") {
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1"', 'zps', 'name', $filter_vid);
} else {
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1"', 'zps', 'name', $row->zps);
}
// Publishliste
$lists['published'] = JHTML::_('select.booleanlist', 'published', 'class="inputbox"', $row->published);
// 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::_('USERS_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);
// Joomla Nutzer ohne CLM Account
$sql = " SELECT u.* FROM #__users as u " . " LEFT JOIN #__clm_user as a ON u.id = a.jid " . " WHERE a.name IS NULL";
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$jid_list[] = JHTML::_('select.option', '0', JText::_('USERS_USER_AUSW'), 'id', 'name');
$jid_list = array_merge($jid_list, $db->loadObjectList());
$lists['jid'] = JHTML::_('select.genericlist', $jid_list, 'pid', 'class="inputbox" size="1"', 'id', 'name', $row->jid);
// Funktionsliste
// sich selbst bearbeiten
if ($row->jid == $jid) {
$sql = "SELECT user_clm as user_clm, name " . " FROM #__clm_usertype WHERE user_clm < " . ($clmuser[0]->user_clm + 1);
} else {
// Admin
if ($clmuser[0]->usertype == 'admin') {
$sql = "SELECT user_clm as user_clm, name " . " FROM #__clm_usertype ";
} else {
$sql = "SELECT user_clm as user_clm, name " . " FROM #__clm_usertype WHERE user_clm < " . $clmuser[0]->user_clm;
}
}
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$usertypelist[] = JHTML::_('select.option', '0', JText::_('USERS_TYP'), 'user_clm', 'name');
$usertypelist = array_merge($usertypelist, $db->loadObjectList());
$lists['user_clm'] = JHTML::_('select.genericlist', $usertypelist, 'user_clm', 'class="inputbox" size="1"', 'user_clm', 'name', $row->user_clm);
require_once JPATH_COMPONENT . DS . 'views' . DS . 'users.php';
CLMViewUsers::user($row, $lists, $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 edit()
{
$mainframe = JFactory::getApplication();
$db = JFactory::getDBO();
$user = JFactory::getUser();
$task = JRequest::getVar('task');
$cid = JRequest::getVar('cid', array(0), '', 'array');
$option = JRequest::getCmd('option');
$section = JRequest::getVar('section');
JArrayHelper::toInteger($cid, array(0));
$row = JTable::getInstance('vereine', 'TableCLM');
// load the row from the db table
$row->load($cid[0]);
$sid = $row->sid;
// Userberechtigung abfragen
$clmAccess = clm_core::$access;
if ($clmAccess->access('BE_club_create') === false and $task == 'add') {
//if (clm_core::$access->getType() !== 'admin' AND $task =='add') {
JError::raiseWarning(500, JText::_('VEREINE_ADMIN'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg, "message");
}
if ($task == 'edit') {
// illegaler Einbruchversuch über URL !
// evtl. mitschneiden !?!
$saison = JTable::getInstance('saisons', 'TableCLM');
$saison->load($sid);
if ($saison->archiv == "1") {
//AND clm_core::$access->getType() !== 'admin') {
JError::raiseWarning(500, JText::_('VEREINE_NO_ARCHIV'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg, "message");
}
if ($cid[0] == "") {
// AND $task =='edit') {
JError::raiseWarning(500, JText::_('VEREINE_FALSCH'));
$mainframe->redirect('index.php?option=' . $option . '§ion=' . $section, $msg, "message");
}
// do stuff for existing records
$row->checkout($user->get('id'));
} else {
// do stuff for new records
$row->published = 0;
}
if ($clmAccess->access('BE_club_create') === false) {
//if ( clm_core::$access->getType() !== 'sl' AND clm_core::$access->getType() !== 'admin' AND clm_core::$access->getType() !== 'dv' AND clm_core::$access->getType() !== 'dwz') {
JError::raiseWarning(500, JText::_('VEREINE_NO_BEARBEITEN'));
$link = 'index.php?option=' . $option . '§ion=' . $section;
$mainframe->redirect($link);
}
$sql = 'SELECT id FROM #__clm_saison WHERE archiv = 0 and published = 1';
$db->setQuery($sql);
$sid = $db->loadResult();
// Vereinefilter laden
// 1 = Auswahl DB obwohl manuell aktiviert wurde !
$vereinlist = CLMFilterVerein::vereine_filter(1);
$lists['verein'] = JHTML::_('select.genericlist', $vereinlist, 'zps', 'class="inputbox" size="1" onchange="Tausch(this.id)"', 'zps', 'name', $row->zps);
// Vereinsleiterliste
if ($task == 'edit') {
$where = "WHERE ZPS = '" . $row->zps . "'";
} else {
$where = 'WHERE ZPS IS NULL';
}
$sql = 'SELECT Spielername as name, Mgl_Nr as vl' . ' FROM #__clm_dwz_spieler ' . $where . ' AND sid =' . $sid;
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=' . $option . '§ion=' . $section);
return JError::raiseWarning(500, $db->getErrorMsg());
}
$vllist[] = JHTML::_('select.option', '0', JText::_('VEREINE_VEREINSLEITER'), 'vl', 'name');
$vllist = array_merge($vllist, $db->loadObjectList());
$lists['vl'] = JHTML::_('select.genericlist', $vllist, 'vl', 'class="inputbox" size="1" onchange="VSTausch(this.id)"', 'vl', 'name', $row->vl);
// 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::_('VEREINE_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);
$lists['published'] = JHTML::_('select.booleanlist', 'published', 'class="inputbox"', $row->published);
require_once JPATH_COMPONENT . DS . 'views' . DS . 'vereine.php';
CLMViewVereine::verein($row, $lists, $option);
}
