Viên ngọc phương Đông

<?php 
/**
 * Display categories and products
 * @version 0.9
 * @author Robert Urquhart <programmer@activatedesign.co.nz>
 * @package WEP-CMS
 */
session_start();
require_once 'scripts-includes/universal.php';
require_once 'scripts-includes/display.php';

$connID = connect_to_db();
$regions = mysql_query("select * from stockist_regions order by order_id desc, region_name, region_id");

if(!$regions || mysql_num_rows($regions)<1)
{
	$table = '<p class="center">No regions found</p>';
}
else
{
	$table = '<table class="control_panel">
				<thead>
					<tr>
						<th class="pad"></th>
						<th>Region/Stockist</th>
						<th class="control">Active</th>
						<th class="control">Up/Down</th>
						<th class="control">Edit</th>
						<th class="control">Delete</th>
						<th class="pad"></th>
					</tr>
				</thead>
				<tfoot></tfoot>
				';
	$table .= build_region_table($regions); //recursive function
	$table .='</table>';	
}
head('stockists','Administration Panel');
?>
	<form name="add_stockist_region" id="add_stockist_region" action="processes/process-stockist-region-new.php" method="post" enctype="multipart/form-data">
		<p class="center">Region name: 
			<input name="region_name" id="region_name" type="text" size="30" value="" />
			&nbsp;&nbsp;
			<input type="submit" name="add" value="Add region" />
<?php 	if($regions && mysql_num_rows($regions)>0): ?>
			&nbsp;&nbsp;&nbsp;&nbsp; | &nbsp;&nbsp;&nbsp;&nbsp; 
			<a href="stockist.php">Add a stockist</a>
<?php	endif; ?>
		</p>
	</form>
<?php
echo $table;
footer();
exit;

function build_region_table($regions)
{
	$rows = '';
	while($row = mysql_fetch_assoc($regions))
	{
		$r = new stockist_region;
		$r->load_from_data($row);
		
		$rid = $r->region_id;
					
		$name = '<td class="left"><span class="tier-1"> '.$r->name.'</span></td>';
				
		$edit = '<td><a href="stockist-region.php?reg='.$rid.'">Edit</a></td>';
		
		$active = '<td><a class="toggle" href="processes/process-switch.php?f=active&amp;sreg='.$rid.'">'.onOrOff($r->active).'</a></td>';
				
		$order = '<td><a href="processes/process-order.php?sreg='.$rid.'&move=up"><img src="images/img-up.png" alt="Up" /></a><a href="processes/process-order.php?sreg='.$rid.'&move=down"><img src="images/img-down.png" alt="Down" /></a></td>';
		
		$delete = '<td><a href="processes/process-stockist-region-delete.php?reg='.$rid.'" onClick="if(confirm(\'Delete '.addslashes($r->name).' and stockists?\')){return true}else{return false}" class="delete"><img src="images/img-del.png" alt="Delete" /></a></td>';
		
		$rows .= '<tbody class="category tier-1">';
		$rows .= "<tr>
						<td>&nbsp;</td>
						$name
						$active
						$order
						$edit
						$delete
						<td>&nbsp;</td>
					</tr>
				";
		
		/*
		 * output stockists
		 */
		foreach($r->load_stockists(true) as $s)
		{
			$sid = $s->stockist_id;
				
			$rows .= '<tr class="product">
						<td>&nbsp;</td>
						';			
			
			$name = ($s->website) ? '<a href="http://'.$s->website.'" target="_blank">'.$s->name.'</a>' : $s->name;
			$name = "<td>$name</td>";
			
			$edit = '<td><a href="stockist.php?stockist='.$sid.'">Edit</a></td>';
			
			$active = '<td><a class="toggle" href="processes/process-switch.php?f=active&amp;stockist='.$sid.'">'.onOrOff($s->active).'</a></td>';
		
			$order = '<td><a href="processes/process-order.php?stockist='.$sid.'&move=up"><img src="images/img-up.png" alt="Up" /></a><a href="processes/process-order.php?stockist='.$sid.'&move=down"><img src="images/img-down.png" alt="Down" /></a></td>';
		
			$delete = '<td><a href="processes/process-stockist-delete.php?stockist='.$sid.'" onClick="if(confirm(\'Delete '.addslashes($s->name).'?\')){return true}else{return false}" class="delete"><img src="images/img-del.png" alt="Delete" /></a></td>';
		
			$rows .= "$name
					$active
					$order
					$edit
					$delete
					<td>&nbsp;</td>
				</tr>
			";

}
				
		$rows .= '
				</tbody>
				';	
		 // recursive
			
	}
	
	return $rows;
}
?>