$orderby = jTipsGetParam($_REQUEST, 'filter_order', 'round'); if (empty($orderby)) { $orderby = 'round'; } $params = array('order' => array('type' => 'order', 'direction' => "{$direction},", 'by' => $orderby), 'order1' => array('type' => 'order', 'direction' => 'ASC', 'by' => 'name'), 'join' => array('type' => 'join', 'join_table' => '#__jtips_seasons', 'lhs_table' => '#__jtips_rounds', 'lhs_key' => 'season_id', 'rhs_table' => '#__jtips_seasons', 'rhs_key' => 'id')); //has the season select been used? if ($season_id = jTipsGetParam($_REQUEST, 'season_id', false)) { $params['season_id'] = $season_id; } //if ($status = jTipsGetParam($_REQUEST, 'status', '')) { // $params['status'] = $status; //} $limit = jTipsGetParam($_REQUEST, 'limit', 25); $limitstart = jTipsGetParam($_REQUEST, 'limitstart', 0); $pageNav = new mosPageNav($focus->getCount($params), $limitstart, $limit); $jRounds = forceArray($focus->loadByParams($params, $limit, $limitstart)); $formData = array('title' => $jLang['_ADMIN_ROUND_TITLE'], 'editTask' => 'edit', 'module' => 'Rounds', 'icon' => 'rounds'); $currentDir = jTipsGetParam($_REQUEST, 'filter_order_Dir', 'desc'); if ($currentDir == 'desc') { $dir = 'asc'; } else { $dir = 'desc'; } //The header row $header = array('', "<a href='javascript:tableOrdering(\"round\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_ROUND_ROUND'] . "</a>", "<a href='javascript:tableOrdering(\"name\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_ROUND_SEASON'] . "</a>", "<a href='javascript:tableOrdering(\"#__jtips_rounds.start_time\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_ROUND_START'] . "</a>", "<a href='javascript:tableOrdering(\"#__jtips_rounds.end_time\", \"{$dir}\", \"list\");'>" . $jLang['_ADMIN_ROUND_END'] . "</a>", $jLang['_ADMIN_ROUND_STATUS']); //The row data for each for $data = array(); $i = 0; foreach ($jRounds as $round) { $status = $round->getStatus(); if ($status === FALSE) {
$season_id = jTipsGetParam($_REQUEST, 'season_id', false); $round_id = jTipsGetParam($_REQUEST, 'round_id', false); $user_id = jTipsGetParam($_REQUEST, 'user_id', false); } //need to select the season, then the round, then list the games //get the seasons $jSeason = new jSeason($database); $jSeasons = forceArray($jSeason->loadByParams(array())); //make a set of options for a select list $season_options = objectsToSelectList($jSeasons, 'name'); $filters = array('Select Season' => makeSelectList($season_options, 'season_id', "id='season_id' onChange='this.form.submit();'", $season_id)); //Load the Rounds if ($season_id) { $params = array('season_id' => $season_id); $jRound = new jRound($database); $jRounds = forceArray($jRound->loadByParams($params)); $round_options = objectsToSelectList($jRounds, 'round'); $filters['Select Round'] = makeSelectList($round_options, 'round_id', "id='round_id' onChange='this.form.submit();'", $round_id); } //Load the users if ($round_id and $season_id) { $params = array('season_id' => $season_id); $jTipsUser = new jTipsUser($database); $jTipsUsers = forceArray($jTipsUser->loadByParams($params)); $user_options = objectsToSelectList($jTipsUsers, 'getName', true); asort($user_options); $filters['Select User'] = makeSelectList($user_options, 'user_id', "id='user_id' onChange='this.form.submit();'", $user_id); } $tpl->selectLists = $filters; $data = array(); //Now we have the preliminary options, get the set of games
*/ global $database; require_once 'components/com_jtips/classes/jround.class.php'; require_once 'components/com_jtips/classes/jseason.class.php'; ob_clean(); $season_id = jTipsGetParam($_REQUEST, 'season_id', false); $round_id = jTipsGetParam($_REQUEST, 'round_id', false); if (empty($season_id)) { $js = "\$('round_id').length = 0;\n"; $js .= "\$('round_id').options[0] = new Option('--None--', '-1');\n"; die($js . "\$('round_id').disabled = true;"); } $js = "\$('round_id').length = 0;\n"; $jRound = new jRound($database); $params = array('season_id' => $season_id); $jRounds = $jRound->loadByParams($params); if (!is_array($jRounds)) { if ($jRound->exists()) { $jRounds = array($jRound); } else { $jRounds = array(); } } $i = $selectedIndex = 0; foreach ($jRounds as $jr) { $js .= "\$('round_id').options[{$i}] = new Option('" . $jr->round . "', '" . $jr->id . "');\n"; if ($round_id == $jr->id) { $selectedIndex = $i; } $i++; }
//Do we have an existing Season? $id = array_shift($ids); if (is_numeric($id)) { $jComment->load($id); } if (!$jComment->exists()) { mosRedirect('index2.php?option=com_jtips&task=list&module=Comments', $jLang['_ADMIN_COMMENT_LOAD_ERROR']); } $jTipsUser = new jTipsUser($database); $jTipsUser->load($jComment->user_id); $title = $jLang['_ADMIN_DASH_COMMENT_MANAGER'] . ": " . $jLang['_ADMIN_OTHER_EDIT']; $mainframe->addCustomHeadTag("<script type='text/javascript' src='components/com_jtips/modules/Comments/Comments.js'></script>"); //what seasons are there $jSeason = new jSeason($database); $jSeasons = forceArray($jSeason->loadByParams(array())); $jSeasonOptions = array(jTipsHTML::makeOption('', $jLang['_ADMIN_CONF_NONE'])); jTipsSortArrayObjects($jSeasons, 'name', 'ASC'); foreach ($jSeasons as $season) { $jSeasonOptions[] = jTipsHTML::makeOption($season->id, $season->name); } //which season is this in? $jRound = new jRound($database); $jRound->load($jComment->round_id); $jRounds = forceArray($jRound->loadByParams(array('season_id' => $jRound->season_id))); $jRoundOptions = array(jTipsHTML::makeOption('', $jLang['_ADMIN_CONF_NONE'])); jTipsSortArrayObjects($jSeasons, 'name', 'ASC'); foreach ($jRounds as $round) { $jRoundOptions[] = jTipsHTML::makeOption($round->id, $round->round); } $formData = array('basic' => array('legend' => '_ADMIN_COMM_EDIT_COMMENT', 'fields' => array('id' => array('field' => array('type' => 'hidden', 'attributes' => array('type' => 'hidden', 'name' => 'id', 'id' => 'id', 'value' => $jComment->id))), 'orig_round_id' => array('field' => array('type' => 'hidden', 'attributes' => array('type' => 'hidden', 'name' => 'orig_round_id', 'id' => 'orig_round_id', 'value' => $jComment->round_id))), 'user_id' => array('label' => '_COM_DASH_USER', 'field' => array('type' => 'hidden', 'attributes' => array('type' => 'hidden', 'name' => 'user_id', 'id' => 'user_id', 'value' => $jComment->user_id))), 'user' => array('label' => '_COM_DASH_USER', 'field' => array('type' => 'label', 'attributes' => array('type' => 'label', 'value' => $jTipsUser->getUserField('name') . " (" . $jTipsUser->getUserField('username') . ")"))), 'season_id' => array('label' => '_ADMIN_ROUND_SEASON', 'field' => array('type' => 'select', 'attributes' => array('name' => 'season_id', 'id' => 'season_id', 'class' => 'inputbox', 'onChange' => 'getTheRounds(this);'), 'options' => $jSeasonOptions, 'selected' => $jRound->season_id)), 'round_id' => array('label' => '_ADMIN_ROUND_ROUND', 'field' => array('type' => 'select', 'attributes' => array('name' => 'round_id', 'id' => 'round_id', 'class' => 'inputbox'), 'options' => $jRoundOptions, 'selected' => $jComment->round_id)), 'comment' => array('label' => '_ADMIN_COMM_EDIT_COMMENT', 'field' => array('type' => 'text', 'attributes' => array('size' => 50, 'name' => 'comment', 'id' => 'comment', 'class' => 'inputbox', 'type' => 'text', 'value' => jTipsStripslashes(htmlentities($jComment->comment, ENT_QUOTES))))), 'updatedlabel' => array('label' => '_COM_TIPS_LASTUP', 'field' => array('type' => 'label', 'attributes' => array('type' => 'label', 'value' => TimeDate::toDisplayDateTime($jComment->updated))), 'description' => '_ADMIN_COMMENTS_UDPATED_DESCRIPTION')))); jTipsAdminDisplay::EditView($title, $formData, 'comments');