<?php include('_mod_security.php'); ?>
<h1>Driver List</h1>
<?php
	$default_region = 0;
	$sql = "SELECT * FROM regions WHERE region_id IN (".get_regions().") ORDER BY region_name";
	$result = $db->query($sql) or die('Database Error!');
	if ($result->rowCount() <= 0) :
		echo '<h2>You are not defined to view any regions!</h2>';
		return;
	endif;
?>
<div class="input_column">
	<div class="input_field">
		<label for="region">Select Region</label>
		<select name="region" id="region" onchange="window.location.href='index.php?IX=drivers&region=' + $(this).val();">
		<?php
			$current_region = nz($_GET['region'], '0');
			$i = 0;
			while ($row = $result->fetch(PDO::FETCH_OBJ)) :
				$i++;
				if ($i == 1) :
					$default_region = $row->region_id;
				endif;
				$selected = '';
				if ($current_region == $row->region_id) :
					$selected = ' selected="selected" ';
				endif;
		?>
				<option value="<?php echo $row->region_id; ?>" <?php echo $selected; ?> ><?php echo $row->region_name; ?></option>
		<?php
			endwhile;
			if ($current_region == 0) :
				$current_region = $default_region;
			endif;
		?>
		</select>
	</div>
</div>
<?php
	$ref = urlencode('drivers&region='.nz($current_region, '0'));
	$ix_form_driver = 'driver_form&ref='.$ref.'&region_id='.nz($current_region, '-1');
?>
<?php db_navigator_bar(array('table_id'=>'db_grid_main', 'form'=>$ix_form_driver, 'xls_sql'=>$xls_sql, 'print_section'=>'db_grid_main', 'call'=>'drivers_ajax', 'sort_col'=>'1', 'sort_order'=>'0', 'parm1'=>nz($current_region, '-1'), 'func'=>'grid' )); ?>