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