some fixes

1 files changed, 40 insertions, 6 deletions

diff --git a/MainController.php b/MainController.php
index a426018..aae6d69 100644
--- a/MainController.php
+++ b/MainController.php
@@ -22,15 +22,16 @@ class MainController
   private $defaultAction = '';      // Method to run when none specified
   
   const OrderBy     = '';           // which column to order the results by
+  const GroupBy			= '';						// which column to group the results by
   const HasMany     = '';         
   const TableName   = '';
   const ManyToMany  = '';
   const ForeignKey  = '';
-  const TableSelect = '';         // extra fields to select
+  const TableSelect = '';         	// extra fields to select
   
-  public $data;                   // data returned from DB
-  private $table;                 // corresponding Db table
-  private $primary_key;           // name of primary key column
+  public $data;                   	// data returned from DB
+  private $table;                		// corresponding Db table
+  private $primary_key;           	// name of primary key column
   
   ////
   // create controller object
@@ -106,6 +107,24 @@ class MainController
 	  }
 	}
 	
+	/**
+	 * Return one thing, without the relatives
+	 */
+	public function one($where)
+	{
+	  if (is_numeric($where)) {
+      $where = array('id' => $where);
+	  }
+	  
+	  list($key, $value) = each($where);
+	  
+	  $sql = 'SELECT * FROM `%s` WHERE `%s` = ? LIMIT 1';
+	  $sql = sprintf($sql, $this->table, $key);
+
+	  return MainDb::one($sql, array($value));
+	  
+	}
+	
   ////
   // the New Find
 	public function find($where = null, $sort = false, $limit = false)
@@ -209,6 +228,7 @@ class MainController
 		
 		foreach ($fk as $child)
 		{
+			$group_by = '';
 		  $order_by = '';
   		
   		$table = ($child::TableName) ? $child::TableName : $child;
@@ -217,11 +237,24 @@ class MainController
   		  $order_by = sprintf('ORDER BY `%s`.%s', $table, $ob);
   		}
   		
+  		if ($gb = $child::GroupBy) {
+  		  $group_by = sprintf('GROUP BY `%s`.%s', $table, $gb);
+  		}
+			
 		  // determine nature of relationship
 			$one_to_many = explode(',', $child::ForeignKey);
       $many_to_many = explode(',', $child::ManyToMany);
       
-      $sql = "SELECT * FROM `$table` WHERE `{$this->table}_id` = ? $order_by";
+      $sql = 'SELECT *';
+      
+			// allow custom selections
+			if ($child::TableSelect) {
+				$sql .= ', ' . $child::TableSelect;
+			}
+			
+      $sql .= " FROM `$table` WHERE `{$this->table}_id` = ? 
+      $group_by
+      $order_by";
       
 			if (in_array($this->table, $many_to_many)) // m/n
 			{
@@ -236,7 +269,7 @@ class MainController
 			else if (@in_array($table, $ref_schema['belongsTo'])) { // 1/m
 			  $sql = "SELECT * FROM `$ref` WHERE `$ref`.`{$table}_id` = ?";
 			}
-      
+			
       $stmt = MainDb::query($sql, array($id));
       
       if (!$stmt) {
@@ -315,6 +348,7 @@ class MainController
 	
   ////
   // delete This Thing
+  // @return whatever MainDb returns
 	public function delete($where, $limit = '')
 	{
 		if (empty($where)) {