<?php

/**
 * SendXMLEmail class sends an email to the site admin when an order is finished
 * this email will contain XML for him to relay to the framing service site
 */

class SendXMLEmail extends base {

	function SendXMLEmail() {
	//$this->attach($this, array('NOTIFY_CHECKOUT_PROCESS_AFTER_SEND_ORDER_EMAIL'));

	/**
	 * This is the debug event handler it will trigger every time you add something to a cart
	 *
	 **/
	 	$_SESSION['cart']->attach($this, array('NOTIFIER_CART_ADD_CART_END'));
	}


	function update(&$class, $eventID) {

	/**
	* Check for some common error conditions
	* $order_id = 68 for testing purposes
	*/

	if ( ! $order_id)
		{
		error_email("No Order");
		}

	if ( ! is_numeric($order_id))
		{
		error_email("Order ID is not numeric");
		}


	/**
	* Boilerplate zen cart database query.
	* Note, i'm trusting the stored data (it's from another php script with no user input
	* and i'm certain there can be only one row
	*/

	global $db;
	$sql = "SELECT comments
			FROM order_status_history
			WHERE orders_id = $order_id;";
	$result = $db->Execute($sql);

	if ($result->RecordCount() == 0)
		{
		error_email("Order Not Found");
		}

	if ($result->RecordCount() > 1)
		{
		error_email("Too many order id's returned, this should be impossible");
		}

	//echo $result->fields['comments'];
	//echo "foofoofoo";

	}

}

function error_email($message) {
	//	echo $message;
}
?>