<?php
class sizes
{
	function size_scales_RS()
	{
		return(Database::ado_execute_query("SELECT * FROM ".Config::$db_tables['inventory_size_scales']." ORDER BY sort_order", "Sizes::size_scales_RS"));
	}
	
	function get_sizes_for_scale($size_scale_id)
	{
		$sizes = array();
		$RS = Database::ado_execute_query("SELECT a.size_id, b.size FROM ".Config::$db_tables['inventory_size_scale_sizes']." a, ".Config::$db_tables['inventory_sizes']." b WHERE a.size_id=b.id AND a.size_scale_id='$size_scale_id' ORDER BY a.sort_order", "");
		while($row = $RS->FetchRow())
		{
			$sizes[$row['size_id']] = $row['size'];
		}
		return($sizes);
	}
	
	function get_size_by_id($size_id)
	{
		return(Database::ado_get_one("SELECT size FROM ".Config::$db_tables['inventory_sizes']." WHERE id='$size_id'", "Sizes::get_size_by_id"));	
	}
	
	/*
		// make array of size scales for later use
		$sss = array(); // ssid => sizes array
		$SSRS =  Database::ado_execute_query("SELECT * FROM inventory_size_scales ORDER BY id");
		while($ssRow = $SSRS->FetchRow())
		{
			// get sizes for scale
			$SzRS = Database::ado_execute_query("SELECT size FROM inventory_sizes a, inventory_size_scale_sizes b WHERE a.id=b.size_id AND b.size_scale_id='".$ssRow['id']."' ORDER BY b.sort_order");
			while($szRow = $SzRS->FetchRow())
			{
				$sss[$ssRow['id']][] = $szRow['size'];
			}
		}
	*/
}
?>