public static function getRunde(&$params) { global $mainframe; $db = JFactory::getDBO(); $par_liste = $params->def('liste', 0); $param['categoryid'] = $params->def('categoryid', 0); JRequest::setVar('categoryid', $param['categoryid']); if ($par_liste == 0) { $now = date("Y-m-d"); } else { $now = date("Y-01-01"); } // CategoryID vorgegeben? $addWhere_t = ''; $addWhere_e = ''; $addWhere_b = ''; if ($param['categoryid'] != '' and $param['categoryid'] > 0) { list($parentArray, $parentKeys, $parentChilds) = modCLMTermineHelper::getTree(); // für jede Kategorie Unterkategorien ermitteln $arrayAllCatid = array(); if (isset($parentChilds[$param['categoryid']])) { $arrayAllCatid = $parentChilds[$param['categoryid']]; $arrayAllCatid[] = $param['categoryid']; } else { $arrayAllCatid[] = $param['categoryid']; } $addWhere_t = ' AND ( ( t.catidAlltime = ' . implode(' OR t.catidAlltime = ', $arrayAllCatid) . ' ) OR ( t.catidEdition = ' . implode(' OR t.catidEdition = ', $arrayAllCatid) . ' ) )'; $addWhere_e = ' AND ( ( e.catidAlltime = ' . implode(' OR e.catidAlltime = ', $arrayAllCatid) . ' ) OR ( e.catidEdition = ' . implode(' OR e.catidEdition = ', $arrayAllCatid) . ' ) )'; $addWhere_b = ' AND ( ( b.catidAlltime = ' . implode(' OR b.catidAlltime = ', $arrayAllCatid) . ' ) OR ( b.catidEdition = ' . implode(' OR b.catidEdition = ', $arrayAllCatid) . ' ) )'; } $query = " (SELECT 'liga' AS source, li.datum AS datum, li.datum AS enddatum, li.sid, li.name, li.nr, li.liga AS typ_id, t.id, t.name AS typ, t.durchgang AS durchgang, t.published, t.runden AS ligarunde" . " , t.ordering, li.startzeit AS starttime " . " FROM #__clm_runden_termine AS li " . " LEFT JOIN #__clm_liga AS t ON t.id = li.liga " . " WHERE t.published != '0' AND datum >= '" . $now . "' " . $addWhere_t . " )" . " UNION ALL" . " (SELECT 'termin', e.startdate AS datum, e.enddate AS enddatum, '1', e.name, '1', '', e.id, e.address AS typ, '1', e.published, 'event' AS ligarunde " . " , e.ordering, starttime " . " FROM #__clm_termine AS e " . " WHERE e.published != '0' AND e.startdate >= '" . $now . "' " . $addWhere_e . " )" . " UNION ALL" . " (SELECT 'turnier', tu.datum AS datum, tu.datum AS enddatum, tu.sid, tu.name, tu.nr, tu.turnier AS typ_id, b.id, b.name AS typ, tu.dg AS durchgang, b.published, '' " . " , b.ordering, tu.startzeit AS starttime " . " FROM #__clm_turniere_rnd_termine AS tu " . " LEFT JOIN #__clm_turniere AS b ON b.id = tu.turnier " . " WHERE b.published != '0' AND datum >= '" . $now . "' " . $addWhere_b . " )" . " ORDER BY datum ASC, IF(starttime = '00:00:00','24:00:00',starttime) ASC, ABS(ordering) ASC, ABS(typ_id) ASC, ABS(nr) ASC "; $db->setQuery($query); $runden = $db->loadObjectList(); return $runden; }
<?php // no direct access defined('_JEXEC') or die('Restricted access'); // angemeldet require_once dirname(__FILE__) . DS . 'helper.php'; $par_liste = $params->def('liste', 0); $par_anzahl = $params->def('anzahl', 5); $par_datum = $params->def('datum', 1); $par_datum_link = $params->def('datumlink', 1); $par_name = $params->def('name', 1); $par_typ = $params->def('typ', 1); $par_termin_link = $params->def('terminlink', 1); $runden = modCLMTermineHelper::getRunde($params); require JModuleHelper::getLayoutPath('mod_clm_termine');
<span><a title="<?php echo 'Termine ' . $htext; ?> " href="<?php echo $linkname_tl . '&start=' . date('Y-m', $date) . '-01'; ?> "><?php echo $htext; ?> </a></span> <a href="index.php?timestamp=<?php echo modCLMTermineHelper::monthForward($date); ?> " class="next">›</a> <a href="index.php?timestamp=<?php echo modCLMTermineHelper::yearForward($date); ?> " class="next">»</a> <div class="clear"></div> </div> <?php modCLMTermineHelper::getCalender($date, $headline, $event, $datum_stamp); ?> <div class="clear"></div> </div> </center> <?php } ?>