Change Log of Joomsport: [VIEW]晉級圖-主席盃、碟及盾：给match表增加三个字段：grp_id，ordering，level(synchronized with ser

Target:

For extended functionalities of [赛事晋级图]. Match table should have at least more 3 fields: grp_id, ordering and level.

grp_id: the match belongs to witch Group: A组, B组...

ordering: the order of the matches within the same group

level: the level of the match, 四分之一决赛(quarterfinal)，半决赛(semi-final)，决赛(final match)

let's add these fields to database:

The type of 'level' is ENUM, which is the first time I use it, just for using it, because never tried.

PHP Change:

/administrator/components/com_joomsport/admin.joomsport.class.php:

note the lines following coment:

class JTableMatch extends JTable
{
	var $id						= null;
	var $m_id 					= null;
	var $team1_id 				= null;
	var $team2_id				= null;
	var $score1 				= null;
	var $score2 				= null;
	var $match_descr			= null;
	var $published				= null;
	var $is_extra				= null;
	var $m_played				= null;
	var $m_date					= null;
	var $m_time					= null;
	var $m_location				= null;
	var $bonus1					= null;
	var $bonus2					= null;
	var $m_remark				= null;

	//added by Vincent 5th Dec 2011
	var $grp_id					= null;
	var $ordering				= null;
	var $level					= null;

	function __construct( &$db )
	{
		parent::__construct( '#__bl_match', 'id', $db );
	}
}

go to: /administrator/components/com_joomsport/admin.joomsport.php

add lines to function 'BL_MatchEdit':

	// added by Vincent Zhang 6th-Dec-2011

	$levels = array();
	$levels[] = JHTML::_('select.option',  0, JText::_('選擇比賽級別'), 'id', 'lev_name' );
	$levels[] = JHTML::_('select.option',  1, JText::_('八強賽'), 'id', 'lev_name' );
	$levels[] = JHTML::_('select.option',  2, JText::_('四強賽'), 'id', 'lev_name' );
	$levels[] = JHTML::_('select.option',  3, JText::_('決賽'), 'id', 'lev_name' );

	$lists['levels'] = $levels;

	// end

and we can leave function 'BL_MatchSave' definition as it be.

/administrator/components/com_joomsport/admin.joomsport.html.php

add lines to function 'bl_editMatch':

<!-- level added by Vincent 6th-Dec-2011 -->
<tr>
	<td>

		<?php echo JText::_( "級別" ); ?>

	</td>
	<td>
		<?php
			echo JHTML::_('select.genericlist',
				$lists['levels'],
				'level',
				'class="inputbox"',
				'id',
				'lev_name',
				( (isset($row->level)) ? $row->level : 0 )
				);


		  ?>
	</td>
</tr>

For 'grp_id', add lines to function 'BL_MatchEdit':

	$is_groups = array();
	$query = "SELECT id, group_name FROM #__bl_groups WHERE s_id = ".$season_id;
	$db->setQuery($query);
	$groups = $db->loadObjectList();
	$is_groups[] = JHTML::_('select.option',  0, JText::_('BLBE_SELGROUP'), 'id', 'group_name' );
	$groupis = array_merge($is_groups, $groups);
	$lists['groups'] = JHTML::_('select.genericlist', $groupis, 'grp_id', 'class="inputbox" size="1"', 'id', 'group_name', ( (isset($row->grp_id)) ? $row->grp_id : 0 ));

Please note that:

1.  the last parameter passed to JHTML::_ is the field name in database table: group_name, otherwise, the drop-down list item doesn't have label;

2. the 3rd parameter passed ot JHTML::_('select.genericlist') is the field name, namely the member variable's name of this match class: 'grp_id', it must be the same, because it is used as this HTML input control's name.

/administrator/components/com_joomsport/admin.joomsport.html.php:

<!-- ordering added by Vincent 6th-Dec-2011 -->
<tr>
	<td width="100">
		<?php echo JText::_( 'BLBE_GROUPNAME' ); ?>
	</td>
	<td>
		<?php echo $lists['groups'];?>
	</td>
</tr>

<!-- ordering added by Vincent 6th-Dec-2011 -->
<tr>
	<td>
		<?php echo JText::_('BLBE_ORDERING');?>

	</td>
	<td>
		<input type="text" maxlength="1" size="2" name="ordering" value="<?php echo htmlspecialchars($row->ordering);?>" />

	</td>
</tr>