public function save() { $result = parent::save(); $model = $this->getThisModel(); if ($result) { $id = $model->getId(); $url = TrackslibHelperRoute::getIndividualRoute($id); $this->setRedirect($url, JText::_('COM_TRACKS_INDIVIDUAL_SAVED')); return true; } return $result; }
/** * Execute and display a template script. * * @param string $tpl The name of the template file to parse; automatically searches through the template paths. * * @return mixed A string if successful, otherwise a Error object. */ public function display($tpl = null) { $mainframe = JFactory::getApplication(); $user = JFactory::getUser(); if (!$user->id) { print JText::_('COM_TRACKS_You_must_register_to_access_this_page'); return; } $model = $this->getModel(); $data = $model->getData($user->id); if (!$data->id) { // No tracks individual associated to profile $params = $mainframe->getParams('com_tracks'); if ($params->get('user_registration')) { $mainframe->redirect(TrackslibHelperRoute::getEditIndividualRoute()); } else { $msg = JText::_('COM_TRACKS_No_tracks_individual_associated_to_your_account'); $mainframe->redirect('index.php?option=com_tracks', $msg); } } $mainframe->redirect(TrackslibHelperRoute::getIndividualRoute($data->id)); }
foreach ($column as $k => $c) { ?> <td> <?php if ($k == 0) { ?> <div class="letter"><?php echo $letter; ?> </div> <?php } ?> <?php foreach ($c as $r) { $link_round = JRoute::_(TrackslibHelperRoute::getIndividualRoute($r->slug)); $l = $this->firstLetter($r->{$first}); if ($l != $letter) { $letter = $l; ?> <div class="letter"><?php echo $letter; ?> </div> <?php } ?> <a href="<?php echo $link_round; ?> "
</th> <?php } ?> <th class="points"><?php echo JText::_('COM_TRACKS_Points'); ?> </th> </tr> </thead> <tbody> <?php $i = 0; foreach ($this->rows as $ranking) { $link_ind = JRoute::_(TrackslibHelperRoute::getIndividualRoute($ranking->slug, $this->project->slug)); $link_team = JRoute::_(TrackslibHelperRoute::getTeamRoute($ranking->teamslug, $this->project->slug)); ?> <tr class="<?php echo $i ? 'd1' : 'd0'; ?> "> <td class="rank"><?php echo $ranking->rank; ?> </td> <?php if ($this->params->get('shownumber')) { ?> <td class="number"><?php
/** * Tracks Search method * * The sql must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav * * @param string $text Target search string * @param string $phrase matching option, exact|any|all * @param string $ordering ordering option, newest|oldest|popular|alpha|category * @param mixed $areas An array if the search it to be restricted to areas, null if search all * * @return array */ public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { $db = JFactory::getDbo(); $app = JFactory::getApplication(); $user = JFactory::getUser(); $groups = implode(',', $user->getAuthorisedViewLevels()); if (is_array($areas)) { if (!array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } } $limit = $this->params->def('search_limit', 50); $text = trim($text); if (!$text) { return array(); } $section = JText::_('PLG_SEARCH_TRACKS_TRACKS'); $rows = array(); if (!$areas || in_array('tracksindividuals', $areas)) { $query = $db->getQuery(true); switch ($phrase) { // Search exact case 'exact': $string = $db->Quote('%' . $db->escape($text, true) . '%', false); $wheres2 = array(); $wheres2[] = 'LOWER(i.first_name) LIKE ' . $string; $wheres2[] = 'LOWER(i.last_name) LIKE ' . $string; $wheres2[] = 'LOWER(i.nickname) LIKE ' . $string; $query->where('(' . implode(' OR ', $wheres2) . ')'); break; // Search all or any // Search all or any case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->Quote('%' . $db->escape($word, true) . '%', false); $wheres2 = array(); $wheres2[] = 'LOWER(i.first_name) LIKE ' . $word; $wheres2[] = 'LOWER(i.last_name) LIKE ' . $word; $wheres2[] = 'LOWER(i.nickname) LIKE ' . $word; $wheres[] = implode(' OR ', $wheres2); } $query->where('(' . implode($phrase == 'all' ? ') AND (' : ') OR (', $wheres) . ')'); break; } $query->order('i.last_name ASC, i.first_name ASC'); $query->select('CONCAT_WS(", ", i.last_name, i.first_name) AS title')->select('CONCAT_WS( " / ", ' . $db->Quote($section) . ', ' . $db->Quote(JText::_('PLG_SEARCH_TRACKS_INDIVIDUALS')) . ' ) AS section')->select('CASE WHEN CHAR_LENGTH( i.alias ) THEN CONCAT_WS( \':\', i.id, i.alias ) ELSE i.id END AS slug')->select('NULL AS created')->select('2 AS browsernav')->from('#__tracks_individuals AS i'); $db->setQuery($query, 0, $limit); $results = $db->loadObjectList(); // The 'output' of the displayed link foreach ($results as $key => $row) { $results[$key]->href = TrackslibHelperRoute::getIndividualRoute($row->slug); } $rows = array_merge($rows, $results); } if (!$areas || in_array('tracksteams', $areas)) { $query = $db->getQuery(true); switch ($phrase) { case 'exact': $string = $db->Quote('%' . $db->escape($text, true) . '%', false); $query->where('LOWER(t.name) LIKE ' . $string); break; case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->Quote('%' . $db->escape($word, true) . '%', false); $wheres[] = 'LOWER(t.name) LIKE ' . $word; } $query->where('(' . implode($phrase == 'all' ? ') AND (' : ') OR (', $wheres) . ')'); break; } switch ($ordering) { case 'alpha': $query->order('t.name ASC'); break; case 'oldest': case 'popular': case 'newest': default: $query->order('t.name ASC'); } $query->select('t.name AS title')->select('CONCAT_WS( " / ", ' . $db->Quote($section) . ', ' . $db->Quote(JText::_('PLG_SEARCH_TRACKS_TEAMS')) . ' ) AS section')->select('CASE WHEN CHAR_LENGTH( t.alias ) THEN CONCAT_WS( \':\', t.id, t.alias ) ELSE t.id END AS slug')->select('NULL AS created')->select('"2" AS browsernav')->from('#__tracks_teams AS t'); $db->setQuery($query, 0, $limit); $results = $db->loadObjectList(); foreach ($results as $key => $row) { $results[$key]->href = TrackslibHelperRoute::getTeamRoute($row->slug); } $rows = array_merge($rows, $results); } if (!$areas || in_array('tracksprojects', $areas)) { $query = $db->getQuery(true); switch ($phrase) { case 'exact': $string = $db->Quote('%' . $db->escape($text, true) . '%', false); $query->where('LOWER(p.name) LIKE ' . $string); break; case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->Quote('%' . $db->escape($word, true) . '%', false); $wheres[] = 'LOWER(p.name) LIKE ' . $word; } $query->where('(' . implode($phrase == 'all' ? ') AND (' : ') OR (', $wheres) . ')'); break; } switch ($ordering) { case 'alpha': $query->order('p.name ASC'); break; case 'oldest': case 'popular': case 'newest': default: $query->order('p.name ASC'); } $query->select('p.name AS title')->select('CONCAT_WS( " / ", ' . $db->Quote($section) . ', ' . $db->Quote(JText::_('PLG_SEARCH_TRACKS_PROJECTS')) . ' ) AS section')->select('CASE WHEN CHAR_LENGTH( p.alias ) THEN CONCAT_WS( \':\', p.id, p.alias ) ELSE p.id END AS slug')->select('NULL AS created')->select(' "2" AS browsernav')->from('#__tracks_projects AS p'); $db->setQuery($query, 0, $limit); $results = $db->loadObjectList(); foreach ($results as $key => $row) { $results[$key]->href = TrackslibHelperRoute::getProjectRoute($row->slug); } $rows = array_merge($rows, $results); } if (!$areas || in_array('tracksrounds', $areas)) { $query = $db->getQuery(true); switch ($phrase) { case 'exact': $string = $db->Quote('%' . $db->escape($text, true) . '%', false); $query->where('LOWER(r.name) LIKE ' . $string); break; case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->Quote('%' . $db->escape($word, true) . '%', false); $wheres[] = 'LOWER(r.name) LIKE ' . $word; } $query->where('(' . implode($phrase == 'all' ? ') AND (' : ') OR (', $wheres) . ')'); break; } switch ($ordering) { case 'alpha': $query->order('r.name ASC'); break; case 'oldest': case 'popular': case 'newest': default: $query->order('r.name ASC'); } $query->select('r.name AS title')->select('CONCAT_WS( " / ", ' . $db->Quote($section) . ', ' . $db->Quote(JText::_('PLG_SEARCH_TRACKS_ROUNDS')) . ' ) AS section')->select('CASE WHEN CHAR_LENGTH( r.alias ) THEN CONCAT_WS( \':\', r.id, r.alias ) ELSE r.id END AS slug')->select('NULL AS created')->select('"2" AS browsernav')->from('#__tracks_rounds AS r'); $db->setQuery($query, 0, $limit); $results = $db->loadObjectList(); foreach ($results as $key => $row) { $results[$key]->href = TrackslibHelperRoute::getRoundRoute($row->slug); } $rows = array_merge($rows, $results); } return $rows; }
if ($showpoints) { ?> <th><?php echo JText::_('MOD_TRACKS_RESULTS_Points'); ?> </th><?php } ?> </tr> </thead> <tbody> <?php $rank = 1; $count = 0; foreach ($list->results as $rows) { $link_ind = JRoute::_(TrackslibHelperRoute::getIndividualRoute($rows->slug, $project->slug)); $link_team = JRoute::_(TrackslibHelperRoute::getTeamRoute($rows->teamslug, $project->slug)); ?> <tr> <td><?php echo $rows->rank; ?> </td> <td> <a href="<?php echo $link_ind; ?> " title="<?php echo trim($rows->first_name . ' ' . $rows->last_name) . '::' . $rows->performance; ?>
</h3> <?php foreach ($this->individuals as $proj) { ?> <div class="project-inds"><span class="project-title"><?php echo current($proj)->project_name; ?> </span> <?php foreach ($proj as $i) { ?> <?php $text = ($i->number ? $i->number . ' ' : '') . $i->first_name . ' ' . $i->last_name; ?> <div class="team-ind"><?php echo JHTML::link(TrackslibHelperRoute::getIndividualRoute($i->slug, $i->projectslug), $text); ?> </div> <?php } ?> </div> <?php } } ?> <div class="clear"></div> <p class="copyright"> <?php echo TrackslibHelperTools::footer(); ?>