index.php

<?php 
  // in the views/order directory 
?>
<div id="content-right">
		
	
	
							
				
				<!-- Recent Orders Table -->
				<h2>Orders</h2>
				<table class="overview-table">
				<tbody>
				<tr>
				<th scope="col">Name</th><th scope="col">Date</th>
				<th scope="col" class="num">Items</th><th scope="col" class="num">Total</th>
				<th scope="col" class="num">Status</th></tr></tbody>
				
				<tbody>
				<?php while($row = $page->orders->fetch_object() ): ?>
					
					<tr class="<?php if($row->id % 2 > 0) echo 'alt-row' ?>">
						
						<td> <?php echo $row->name ?></td>
						<td> <?php echo strftime("%m/%d/%Y", strtotime($row->date) ) ?></td>
						<td> 2 </td>
						<td> $123.32</td>
						<td>New Order </td>
					</tr>
				<?php endwhile; ?>
				
				
				<tr><td><a href="link" title="">Becca Davis</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$143.00</td>
				<td class="num">New Order</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Carl Cornista</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$97.00</td>
				<td class="num">New Order</td></tr>
				
				<tr><td><a href="link" title="">Richard Wallace</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$19.74</td>
				<td class="num">New Order</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Rachel Olsen</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$213.21</td>
				<td class="num">Processing</td></tr>
				
				<tr><td><a href="link" title="">Renee Herman</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$104.19</td>
				<td class="num">Processing</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Beth Dantes</a></td>
				<td>2010/01/29</td>
				<td class="num">2</td>
				<td class="num">$143.00</td>
				<td class="num">Shipped</td></tr>
				
				<tr><td><a href="link" title="">Joel Wilson</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$62.23</td><td class="num">Shipped</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Josh Darren</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$374.45</td><td class="num">Shipped</td></tr>
				
				<tr><td><a href="link" title="">Joel Wilson</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$62.23</td><td class="num">Shipped</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Josh Darren</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$374.45</td><td class="num">Shipped</td></tr>
				
				<tr><td><a href="link" title="">Joel Wilson</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$62.23</td><td class="num">Shipped</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Josh Darren</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$374.45</td><td class="num">Shipped</td></tr>
				
				<tr><td><a href="link" title="">Joel Wilson</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$62.23</td><td class="num">Shipped</td></tr>
				
				<tr class="alt-row"><td><a href="link" title="">Josh Darren</a></td>
				<td>2010/01/29</td><td class="num">2</td>
				<td class="num">$374.45</td><td class="num">Shipped</td></tr>
				
				<tr><td colspan="5">
				<a href="/account/orders/">Paging System Goes Here &raquo;</a></td></tr></tbody></table>
				
				
	
	
		
		</div>
		

order.php

<?php
/**
*  The Order Controller
*/
require_once(PEPPER_ROOT . "/account/classes/Controller.class.php");

class Order extends Controller {
	public $title;
	public $layout;
	
	function __construct() {
		//define layout here
	}
	
	function index() {
		global $orders;
		$this->title = "Order Management";
		
		$order = new OrderModel;
		$this->orders = $order->get_order_details("orders");
	
	}
	
	function new_order() {
		$this->title = "Order Management";
	}
	function search_orders(){
		$this->title = "Order Search";
	}
	function order_options(){
		$this->title = "Order Options";
	}
	
}
?>

order.php

<?php
/**
* Order Model
*/
require_once(PEPPER_ROOT . "/account/classes/Model.class.php");
class OrderModel extends Model {
	function get_order_details(){
		$sql = "SELECT o.id, CONCAT(u.first_name, ' ', u.last_name) as name, o.created_at as date  FROM pepper_orders as o
					LEFT JOIN pepper_user_details as u on o.user_id = u.user_id";
		return $this->find_by_sql($sql);
	}
}

?>