PHP Purchase::updates Examples

Example #1

File: Customer.php Project: robbiespire/paQui

	function load_orders ($filters=array()) {
		if (empty($this->id)) return false;
		global $Ecart;
		$db =& DB::get();

		$where = '';
		if (isset($filters['where'])) $where = " AND {$filters['where']}";
		$orders = DatabaseObject::tablename(Purchase::$table);
		$purchases = DatabaseObject::tablename(Purchased::$table);
		$query = "SELECT o.* FROM $orders AS o WHERE o.customer=$this->id $where ORDER BY created DESC";
		$Ecart->purchases = $db->query($query,AS_ARRAY);
		foreach($Ecart->purchases as &$p) {
			$Purchase = new Purchase();
			$Purchase->updates($p);
			$p = $Purchase;
		}
	}

Example #2

File: Customer.php Project: kennethreitz-archive/wordpress-skeleton

 function load_orders($filters = array())
 {
     if (empty($this->id)) {
         return false;
     }
     global $Shopp;
     $db =& DB::get();
     $where = '';
     if (isset($filters['where'])) {
         $where = " AND {$filters['where']}";
     }
     $orders = DatabaseObject::tablename(Purchase::$table);
     $purchases = DatabaseObject::tablename(Purchased::$table);
     $query = "SELECT o.* FROM {$orders} AS o LEFT JOIN {$purchases} AS p ON p.purchase=o.id WHERE o.customer={$this->id} {$where} ORDER BY created DESC";
     $Shopp->purchases = $db->query($query, AS_ARRAY);
     foreach ($Shopp->purchases as &$p) {
         $Purchase = new Purchase();
         $Purchase->updates($p);
         $p = $Purchase;
     }
 }