<?php
	/*
	** File: department
	** Description: show departments and items contained in them
	** Version: $Revision: 1.11 $
	** Created: 04/22/1999
	** Author: Leon Atkinson
	** Email: leon@clearink.com
	** CVS Author: $Author: leon $
	** Last Revised: $Date: 2000/02/02 18:59:48 $
	** Log : $Log: department,v $
	** Log : Revision 1.11  2000/02/02 18:59:48  leon
	** Log : Fixing bugs reported by Ted Henigson.
	** Log :
	** Log : Revision 1.10  1999/11/04 21:35:40  leon
	** Log : Cleaned up the use of paths.  Paths are now all set in index.php3 as
	** Log : constants.  Example settings for Apache/Unix, Apache/Win32, and IIS.
	** Log :
	** Log : Revision 1.9  1999/10/30 22:07:15  leon
	** Log : Fixed some problems with images associated with items and departments.
	** Log : Defined the directories for items and departments inside global_settings.
	** Log :
	** Log : Revision 1.8  1999/10/12 00:39:10  chris
	** Log : Moving text into constants in preparation of localization support.
	** Log :
	** Log : Revision 1.7  1999/10/11 23:04:08  leon
	** Log : Removed all require()'s, added block to stop double include()'s
	** Log :
	** Log : Require wasn't giving any performance advantage because it was always
	** Log : being called with a variable.  Futhermore, using return inside a
	** Log : require()'d file does not work in PHP4.
	** Log :
	** Log : Revision 1.6  1999/08/18 22:32:14  leon
	** Log : Returning opening PHP tag to XML-friendly tag
	** Log :
	** Log : Revision 1.5  1999/07/28 19:27:30  leon
	** Log : Mass update based on code donation from a live project
	** Log :
	**
	** Copyright (c) 1999 Working Dogs.  All rights reserved.
	*/

	$department = intval($department);

	//show sub-departments
	$Query = "SELECT ID, Name, Graphic, Description ";
	$Query .= "FROM department ";
	$Query .= "WHERE Parent=$department ";
	$Query .= "ORDER BY DisplayPrecedence, Name ";
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	while($DatabaseRow = mysql_fetch_object($DatabaseResult))
	{
		print("<A HREF=\"" . ScreenURL("department") . "&department=$DatabaseRow->ID\">");

		if(($DatabaseRow->Graphic) AND file_exists(DEPARTMENT_IMAGES_DIR . '/' . $DatabaseRow->Graphic))
		{
			$department_Graphic_size = getimagesize(DEPARTMENT_IMAGES_DIR . '/' . $DatabaseRow->Graphic);

			print("<IMG SRC=\"" . DEPARTMENT_IMAGES_DIR . '/' . $DatabaseRow->Graphic . "\"");
			print(" $department_Graphic_size[3] BORDER=\"0\" ALIGN=\"left\">\n");
		}
		
		print("<B>$DatabaseRow->Name</B>");
		
		print("</A>");
		print("<BR>\n");
		
		print($DatabaseRow->Description);
		print("<BR CLEAR=\"all\">\n");
		print("<BR>\n");
		
	
	}
	
		
	//show items in this department
	$Query = "SELECT i.ID, i.Name, i.Thumbnail ";
	$Query .= "FROM item i, department_item di ";
	$Query .= "WHERE di.Department = $department ";
	$Query .= "AND i.ID = di.Item ";
	$Query .= "ORDER BY i.DisplayPrecedence, i.Name ";
	$DatabaseResult = mysql_query($Query, $DatabaseLink);
	while($DatabaseRow = mysql_fetch_object($DatabaseResult))
	{
		print("<A HREF=\"".ScreenURL("item")."&item=$DatabaseRow->ID\">");
		if(($DatabaseRow->Thumbnail) AND 
			file_exists(ITEM_IMAGES_DIR . "/" . $DatabaseRow->Thumbnail))
		{
			$Thumbnail_Graphic_size = getimagesize(ITEM_IMAGES_DIR . "/" . $DatabaseRow->Thumbnail);
			print("<IMG SRC=\"" . ITEM_IMAGES_DIR . "/" . $DatabaseRow->Thumbnail . "\"");
			print(" $Thumbnail_Graphic_size[3] BORDER=\"0\" ALIGN=\"left\">\n");
		}
		print("<B>$DatabaseRow->Name</B>");
		print("</A>");
		print("<BR CLEAR=\"all\">\n");
		print("<BR>\n");

	}

?>
