<?php
class Cart
{
	var $cookie_name = 'cid';
	var $id;
	var $num_items;
	var $items_amount; // not including tax
	var $html;
	var $cross_sell_html;
	private $items_RS;
	
	function __Construct($Designers, $Items, $Sizes, $Template, $Promotion)
	{
		if(!$this->_exists()) // sets id if exists
		{
			$this->_set();
			$this->num_items = 0;
			$this->items_amount = 0;			
		}
		else
		{
			$this->set_items($Designers, $Items, $Sizes, $Template, $Promotion);
		}
	}
		
	function _exists()
	{
		// returns true if cart is set
		if(isset($_COOKIE[$this->cookie_name]))
		{
			$this->_get();
			return(TRUE);
		}
		else
		{
			return(FALSE);
		}
	}
	
	function _get()
	{
		$this->id = $_COOKIE[$this->cookie_name];
	}
	
	function _set()
	{
		$this->_insert();
		setcookie($this->cookie_name, $this->id, time()+60*60*24*90, '/'); // 90 days
	}
	
	function _insert()
	{
		$ins = "INSERT INTO ".Config::$db_tables['carts']." VALUES(NULL, NOW(), '".Tracker::$cookie_id."')";
		return($this->id = Database::ado_execute_query($ins, 'Cart::insert_cart'));
	}
	
	function _delete()
	{
		Database::ado_execute_query("DELETE FROM ".Config::$db_tables['cart_items']." WHERE cart_id='".$this->id."'", "Cart::delete cart items");
		$del = "DELETE FROM ".Config::$db_tables['carts']." WHERE id='$this->id' LIMIT 1";
		return(Database::ado_execute_query($del, 'Cart::_delete'));
	}
	
	function update_item_quantity($cart_item_id, $qty)
	{
		$upd = "UPDATE ".Config::$db_tables['cart_items']." SET item_qty='$qty' WHERE id='$cart_item_id' LIMIT 1";
		return(Database::ado_execute_query($upd, 'Cart::update_item_quantity'));
	}
	
	function insert_item($item_id, $item_color_id, $size_id, $quantity=1)
	{
		// if item already there just update qty if nec
		if($cart_item_record = $this->item_search($item_id, $item_color_id, $size_id))
		{
			return($this->update_item_quantity($cart_item_record['id'], $quantity));
		}
		else
		{
			$ins_fields = array(
				'id' => 'NULL',
				'cart_id' => $this->id,
				'item_id' => $item_id,
				'item_qty' => $quantity,
				'item_color_id' => $item_color_id,
				'size_id' => $size_id,
				'enter_dt' => 'NOW()'
			);
			return(Database::_insert(Config::$db_tables['cart_items'], $ins_fields, 'Cart::insert_item'));
		}
	}
	
	function item_search($item_id, $item_color_id, $size_id)
	{
		// returns cart_item_id or FALSE
		return(Database::ado_get_row("SELECT id FROM ".Config::$db_tables['cart_items']." WHERE cart_id=".$this->id." AND item_id='$item_id' AND item_color_id='$item_color_id' AND size_id='$size_id'", "Cart:: item_search"));
	}
	
	function is_item_in($item_id)
	{
		// just checks for item in general, not specific color/size combo - see item_search
		$sel = "SELECT * FROM ".Config::$db_tables['cart_items']." WHERE cart_id=".$this->id." AND  item_id='$item_id'";
		return(Database::ado_get_row($sel, 'Cart::is_item_in'));
	}
	
	function remove_cookie()
	{
		setcookie($$this->cookie_name, $this->id, time()-60000, '/'); // 90 days
	}
	
	function remove_item($cart_item_id)
	{
		$del = "DELETE FROM ".Config::$db_tables['cart_items']." WHERE id='$cart_item_id' LIMIT 1";
		return(Database::ado_execute_query($del, 'Cart::remove_item'));
	}
	
	function _empty()
	{
		$del = "DELETE FROM ".Config::$db_tables['cart_items']." WHERE cart_id='".$this->id."'";
		return(Database::ado_execute_query($del, 'Cart::_empty'));
	}
		
	function get_items_RS($echo = FALSE)
	{
		if(!isset($this->items_RS))
		{
			if($echo){echo 'setting items RS';}
			$this->set_items_RS();
		}
		else
		{
			if($echo){echo 'NOT setting items RS';}
		}
		return($this->items_RS);
	}
	
	function set_items_RS()
	{
		$sel = "SELECT * FROM ".Config::$db_tables['cart_items']." WHERE cart_id='".$this->id."' ORDER BY id DESC";
		//echo $sel;
		$this->items_RS = Database::ado_execute_query($sel, "Cart::set_items_RS");
	}
	
	function set_items($Designers, $Items, $Sizes, $Template, $Promotion)
	{
		$this->html = '
			<form name="cart" action="'.$_SERVER['PHP_SELF'].'" method="POST">
			<table cellspacing="0" class="cartTable" border="0">';
			
		$items_html = ''; // either gets populated with item rows and total info or bag is empty message and featured designer
		$preorders = array(); // stores preorder dates
		$backorders = array(); // stores backorder dates
		// note - not necessarily all items in cart are still avail on web. loop thru cart items, adding avail ones to this array and deleting unavail ones
		$i = 0;
		while($row = $this->get_items_RS()->FetchRow()) // :: for some reason does not work
		{
			++$i;
			$Item = new Item($row['item_id']);
			$Item->set_data();

			if(!$Item->is_live_web($Items))
			{
				$this->remove_item($row['id']);
			}
			else
			{
				$item_designer = $Designers->get_name($Item->data['designer_id'], 'Cart::set_html');
				$spcr_cell = '<td><img src="/images/spacer.gif" width="10" height="1" alt="" /></td>';
				if($i == 1)
				{
					$items_html .= '
				<tr>
					<td colspan="20" align="left" class="blackText24Bold">SHOPPING BAG</td>
				</tr>
				<tr>
					<td colspan="20"><img src="/images/spacer.gif" width="1" height="8" alt="" /></td>
				</tr>
				<tr>
					<td colspan="20" align="left" class="blackTextBold14"><a href="javascript:svcpop = window.open(\'/popups/custSvc.hello\', \'servicePopup\', \'resizable=yes,directories=no,toolbars=no,scrollbars=yes,status=no,width=500,height=530,top=300,left=400\'); svcpop.focus(); void 0;">Need help?</a></td>
				</tr>
				<tr>
					<td colspan="20"><img src="/images/spacer.gif" width="1" height="30" alt="" /></td>
				</tr>
				<tr class="blackTextBold12">
					<td>ITEM</td>
					'.$spcr_cell.'
					<td>DESCRIPTION</td>
					'.$spcr_cell.'
					<td>COLOR</td>
					'.$spcr_cell.'
					<td>SIZE</td>
					'.$spcr_cell.'
					<td>PRICE</td>
					'.$spcr_cell.'
					<td align="center">QTY</td>
					'.$spcr_cell.'
					<td align="right">AMOUNT</td>
					'.$spcr_cell.'
					<td align="right">&nbsp;</td>
				</tr>
				<tr>
					<td colspan="5"><img src="/images/spacer.gif" width="1" height="5" alt="" /></td>
				</tr>';
				}
				else
				{
					$items_html .= '
				<tr>
					<td colspan="5"><img src="/images/spacer.gif" width="1" height="5" alt="" /></td>
				</tr>';
	
				}
				$Item->set_cross_sells();
				if( (!isset($this->cross_sell_html) || $this->cross_sell_html == '') && count($Item->cross_sells) > 0)
				{
					// a cross sell row for the last item added to the cart (or prior items if the last item has no cross sells)
					$this->set_cross_sell_html($Items, $Sizes, $Designers, $Item);
				}
				/////////////////////////////////////////////////
				// item cell (pic)
				$Item->set_images($Items);
				$Item->set_web_images($Items);
				{
					$item_cell = '<a href="/dressing_room/?id='.$Item->data['id'].'&ref=cart" title="view item">'.$Item->img_html($Items, 'thumb').'</a>';
				}
				// description cell
				$Item->set_web_colors_and_sizes($Sizes);
				$asterisks = '';
				// check if it is a preorder or a backorder
				if($Item->is_preorder($row['item_color_id'], $row['size_id']))
				{
					$preorders[] = Utilities::informal_date($Item->data['available_date']);
					foreach($preorders as $preorder)
					{
						$asterisks .= "*";
					}				
					foreach($backorders as $backorder)
					{
						$asterisks .= "*";
					}
				}
				elseif($row['item_color_id'] != '' && $row['item_color_id'] != '0' && $back = $Item->backorder_date($row['item_color_id']))
				{
					$backorders[] = $back;
					foreach($preorders as $preorder)
					{
						$asterisks .= "*";
					}				
					foreach($backorders as $backorder)
					{
						$asterisks .= "*";
					}
				}
				$item_name = ($Item->data['short_name'] != '') ? $Item->data['short_name'] : substr($Item->data['name'], 0 , 21);
				$link_title = (count($Item->web_colors) > 1) ? 'add this in more colors' : 'view item';
				$description_cell = '<span class="blackTextVerdana13Bold">'.$asterisks.'</span>' . '<a href="/dressing_room/?id='.$Item->data['id'].'&ref=cart" title="'.$link_title.'">'.Utilities::quotes_to_html($item_designer).' '.Utilities::quotes_to_html($item_name).'</a>';
				$color_cell = ($row['item_color_id'] != '' && $row['item_color_id'] != '0') ? $Item->colors[$row['item_color_id']]['name'] : '&nbsp;';
				$size_cell = ($row['size_id'] != '' && $row['size_id'] != '0') ? $Item->sizes[$row['size_id']] : '&nbsp;';
				/////////////////////////////////////////////////
				$price = $Item->get_web_price($Promotion);
				$price_cell = '';
				if($Item->get_on_sale('web') || $Item->get_on_promotion_web($Promotion))
				{
					$price_cell .= '<strike>$'.number_format($Item->data['price_web'], 2).'</strike>&nbsp;';
				}
				$price_cell .= '$'.number_format($price, 2);
				$Item->set_web_qty_max($row['item_color_id'], $row['size_id']);
				$quantity_cell = $Item->web_quantity_select($row['item_qty'], 'qty['.$row['id'].']', 'location.href=\''.$_SERVER['PHP_SELF'].'?qty['.$row['id'].']=\'+this.value', '');// document.forms[\'cart\'].submit(); 2nd param is field name - need cart_item_id to know which to change
				$this->num_items += $row['item_qty'];
				$item_amount = $row['item_qty'] * $price;
				$this->items_amount += $item_amount;
				$amount_cell = '$'.number_format($item_amount, 2);
				$remove_cell = '&nbsp;&nbsp;<a href="'.$_SERVER['PHP_SELF'].'?ri='.$row['id'].'" title="remove this item from your bag">remove</a>';
				$items_html .= '
				<tr bgcolor="#EEEEEE">
					<td nowrap="nowrap" class="blackTextBold12">'.$item_cell.'</td>
					'.$spcr_cell.'
					<td nowrap="nowrap" class="blackTextBold12">'.$description_cell.'</td>
					'.$spcr_cell.'
					<td nowrap="nowrap" class="blackTextBold12">'.$color_cell.'</td>
					'.$spcr_cell.'
					<td align="center" nowrap="nowrap" class="blackTextBold12">'.$size_cell.'</td>
					'.$spcr_cell.'
					<td class="blackTextBold12">'.$price_cell.'</td>
					'.$spcr_cell.'
					<td align="center" class="blackTextBold12">'.$quantity_cell.'</td>
					'.$spcr_cell.'
					<td align="right" class="blackTextBold12">'.$amount_cell.'</td>
					'.$spcr_cell.'
					<td align="center" nowrap="nowrap" class="blackTextBold12">'.$remove_cell.'</td>
				</tr>';

			}

		} // while
		$this->get_items_RS()->MoveFirst(); // reset for next loop if nec
		if($this->num_items > 0)
		{
	//echo 'p id: '.$Promotion->get_id().'<br />p err'.$Promotion->get_error_msg();
			$promo_code = '';
			$code_value = ''; // default field value
			$promo_fields = ' <input type="text" name="code" size="10" maxlength="20" value="'.$code_value.'" />&nbsp;&nbsp;<input type="submit" name="apply" value="APPLY" />&nbsp;&nbsp;&nbsp;&nbsp;';
			if($Promotion->is_error())
			{
				$promo_code .= '<span class="error">'.$Promotion->get_error_msg().'</span>:'.$promo_fields;
				$code_value = $Promotion->get_code();
			}			
			elseif(!$Promotion->get_id())
			{
				// prompt for code - none has been applied
				$promo_code .= 'If you have a PROMOTION CODE, enter it here:'.$promo_fields;
			}
			else
			{
				// promo applied
				$promo_text = '<span class="redTextBold12">Thank you for participating in the  '.strtoupper($Promotion->get_code()).' promotion!</span>';
			}
			$items_html .= '
			<tr>
				<td colspan="12">&nbsp;</td>
				<td align="right">______</td>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td colspan="13" align="right" class="formLabelCellLeft">Items Total: <span class="">$'.number_format($this->items_amount, 2).'</span></td>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td colspan="20"><img src="/images/spacer.gif" width="1" height="6" alt="" /></td>
			</tr>';
			if(isset($promo_text))
			{
				$items_html .= '
			<tr>
				<td colspan="13" align="right">'.$promo_text.'</td>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td colspan="20"><img src="/images/spacer.gif" width="1" height="6" alt="" /></td>
			</tr>';
			}
			$items_html .= '
			<tr>
				<td colspan="20" align="right">
				<table width="300">
				<tr>
					<td class="formNote" align="right">*The total shown here excludes taxes (CT residents only) and shipping costs, which are calculated based on your shipping destination. The complete cost of your order will be displayed on the Payment page.</td>
				</tr>
				</table>
				</td>
			</tr>';
			if(isset($promo_code))
			{
				$items_html .= '
			<tr>
				<td colspan="20"><img src="/images/spacer.gif" width="1" height="12" alt="" /></td>
			</tr>
			<tr>
				<td colspan="13" align="right" class="formLabelCellLeft">'.$promo_code.'</td>
				<td>&nbsp;</td>
			</tr>';
			}
			$items_html .= '
			</table>
			</form>
			<table class="checkoutLinkTable" cellspacing="0">
			<tr>
				<td><input type="submit" onclick="location.href=\'/designers/\';" value=" &lt; continue shopping " class="redButton" />&nbsp;</td>
				<td colspan="3" align="right"><input type="submit" onclick="location.href=\'/checkout/ship.hello\';" value=" c h e c k o u t  &gt; " class="orangeButton" />&nbsp;</td>
			</tr>';
			if(count($preorders) > 0 || count($backorders) > 0)
			{
				$Template->set_preorder_policy_text();
				$Template->set_backorder_policy_text();
				$preorder_text = '';
				$asterisks = '';
				// there will be a bug with the asterisks if both backorders and preorders are made in the same order - they will increment properly in the cart but may not match up here
				foreach($preorders as $preorder_date)
				{
					$asterisks .= "*";
					$preorder_text .= $asterisks . ' This item is a preorder and is scheduled to ship on or before '.$preorder_date.'<br />';
				}
				$backorder_text = '';
				$asterisks = '';
				foreach($backorders as $backorder_date)
				{
					$asterisks .= "*";
					$backorder_text .= $asterisks . ' This item is backordered until '.$backorder_date.'<br />';
				}
				$items_html .= '
				<tr>
					<td colspan="5"><img src="/images/spacer.gif" width="1" height="14" alt="" /></td>
				</tr>';
				if($preorder_text != '')
				{
					$items_html .= '
				<tr>
					<td colspan="5" class="blackTextVerdana12">'.$preorder_text.'</td>
				</tr>';
				}
				if($backorder_text != '')
				{
					$items_html .= '
				<tr>
					<td colspan="5" class="blackTextVerdana12">'.$backorder_text.'</td>
				</tr>';
				}
				$items_html .= '
				<tr>
					<td colspan="5"><img src="/images/spacer.gif" width="1" height="14" alt="" /></td>
				</tr>';
				if(count($preorders) > 0)
				{
					$items_html .= '
				<tr>
					<td colspan="5" class="blackTextVerdana12"><span class="boldedText">Preorders Policy</span><br />'.$Template->preorder_policy_text.'</td>
				</tr>';
				}
				if(count($backorders) > 0)
				{
					$items_html .= '
				<tr>
					<td colspan="5" class="blackTextVerdana12"><span class="boldedText">Backorders Policy</span><br />'.$Template->backorder_policy_text.'</td>
				</tr>';
				}
				//Utilities::notify(Config::$tech_email, "backordered item in cart", "cart id: ".$this->id."\n\n$backorder_text");
			}
			$items_html .= '
			</table>';
		}
		else
		{
			$FeaturedDesigners = new FeaturedDesigners();
			$items_html = '
			<tr>
				<td colspan="5" class="blackTextBold12"><div align="center">There are currently no items in your Shopping Bag.</div><br /><br /><br /><span class="blackTextVerdana11">Note: You must have cookies enabled in your web browser<br />in order to add items to your bag.</span></td>
			</tr>
			<tr>
				<td colspan="5"><img src="/images/spacer.gif" width="1" height="24" alt="" /></td>
			</tr>
			</table>
			</form>
			<table>
			<tr>
				<td><img src="/images/spacer.gif" width="1" height="40" alt="" /></td>
			</tr>
			<tr>
				<td align="center" valign="middle">'.$FeaturedDesigners->get_random($Designers, $Items, $Sizes).'</td>
			</tr>
			</table>';
		}
		$this->html .= $items_html;	
		
	}

	function set_cross_sell_html($Items, $Sizes, $Designers, $crItem)
	{
		$CrossSellItems = new CrossSellItems($Items, $crItem->cross_sells, $this);
		$this->cross_sell_html = $CrossSellItems->html; // a table if avail web items exist or else blank
	}
}
?>