<?php
//require_once 'config.php';
require_once 'define.php';
require_once 'init_class.php';
require_once 'database_class.php';
require_once 'cart_func_class.php';
/*********************************************************
*                 CHECKOUT FUNCTIONS 
*********************************************************/
class checkout_func_class{
	function saveOrder()
	{
		$init=new init_class;
		$db=new database_class;
		$cart_func=new cart_func_class;
		$orderId       = 0;
		$shippingCost  = 5;
		$requiredField = array('hidShippingFirstName', 'hidShippingLastName', 'hidShippingAddress1', 'hidShippingCity', 	'hidShippingPostalCode',
							   'hidPaymentFirstName', 'hidPaymentLastName', 'hidPaymentAddress1', 'hidPaymentCity', 	'hidPaymentPostalCode');
		if ($init->checkRequiredPost($requiredField)) {
		    extract($_POST);
			// make sure the first character in the 
			// customer and city name are properly upper cased
			$hidShippingFirstName = ucwords($hidShippingFirstName);
			$hidShippingLastName  = ucwords($hidShippingLastName);
			$hidPaymentFirstName  = ucwords($hidPaymentFirstName);
			$hidPaymentLastName   = ucwords($hidPaymentLastName);
			$hidShippingCity      = ucwords($hidShippingCity);
			$hidPaymentCity       = ucwords($hidPaymentCity);
			$cartContent = $cart_func->getCartContent();
			$numItem     = count($cartContent);
			// save order & get order id
			$sql = "INSERT INTO ".PREFIX."order(od_date, od_last_update, od_shipping_first_name, od_shipping_last_name, 	od_shipping_address1, 
			                              od_shipping_address2, od_shipping_phone, od_shipping_state, od_shipping_city, 	od_shipping_postal_code, od_shipping_cost,
	                                      od_payment_first_name, od_payment_last_name, od_payment_address1, 	od_payment_address2, 
										  od_payment_phone, od_payment_state, od_payment_city, od_payment_postal_code)
	                VALUES (NOW(), NOW(), '$hidShippingFirstName', '$hidShippingLastName', '$hidShippingAddress1', 
					        '$hidShippingAddress2', '$hidShippingPhone', '$hidShippingState', '$hidShippingCity', '$hidShippingPostalCode', '$shippingCost',
							'$hidPaymentFirstName', '$hidPaymentLastName', '$hidPaymentAddress1', 
							'$hidPaymentAddress2', '$hidPaymentPhone', '$hidPaymentState', '$hidPaymentCity', '$hidPaymentPostalCode')";
			$result=$db->dbQuery($sql);
			// get the order id
			$orderId = $db->dbInsertId();
			if ($orderId) {
				// save order items
				for ($i = 0; $i < $numItem; $i++) {
					$sql = "INSERT INTO ".PREFIX."order_item(od_id, pd_id, od_qty)
							VALUES ($orderId, {$cartContent[$i]['pd_id']}, {$cartContent[$i]['ct_qty']})";
					$db->dbQuery($sql);					
				}
				// update product stock
				for ($i = 0; $i < $numItem; $i++) {
					$sql = "UPDATE ".PREFIX."product 
					        SET pd_qty = pd_qty - {$cartContent[$i]['ct_qty']}
							WHERE pd_id = {$cartContent[$i]['pd_id']}";
					$db->dbQuery($sql);					
				}	
				// then remove the ordered items from cart
				for ($i = 0; $i < $numItem; $i++) {
					$sql = "DELETE FROM ".PREFIX."cart
					        WHERE ct_id = {$cartContent[$i]['ct_id']}";
					$db->dbQuery($sql);					
				}							
			}					
		}
		return $orderId;
	}

	/*
		Get order total amount ( total purchase + shipping cost )
	*/
	function getOrderAmount($orderId)
	{
		$db=new database_class;
		$orderAmount = 0;
		$sql = "SELECT SUM(pd_price * od_qty)
		        FROM ".PREFIX."order_item oi, ".PREFIX."product p 
			    WHERE oi.pd_id = p.pd_id and oi.od_id = $orderId
				UNION
				SELECT od_shipping_cost 
				FROM ".PREFIX."order
				WHERE od_id = $orderId";
		$result=$db->dbQuery($sql);
		if ($db->dbNumRows($result) == 2) {
			$row = $db->dbFetchRow($result);
			$totalPurchase = $row[0];
			$row = $db->dbFetchRow($result);
			$shippingCost = $row[0];
			$orderAmount = $totalPurchase + $shippingCost;
		}		
		return $orderAmount;	
	}
}
?>