$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');
