<?php

	/* 
	** File: report_inventory
	** Description: Give the admin a nice inventory report. 
	** Version: $Revision: 1.4 $
	** Created: 6/30/99
	** Author: Shannon -jj Behrens
	** Email: shannon.behrens@clearink.com
	** CVS Author: $Author: leon $
	** Last Revised: $Date: 1999/11/08 22:32:30 $
	** Log : $Log: report_inventory,v $
	** Log : Revision 1.4  1999/11/08 22:32:30  leon
	** Log : Added prepareText() function to use everywhere we were using htmlentities.
	** Log :
	** Log : Revision 1.3  1999/10/13 22:19:07  chris
	** Log : Moving text into constants in preparation of localization support.
	** Log :
	** Log : Revision 1.2  1999/08/18 22:32:21  leon
	** Log : Returning opening PHP tag to XML-friendly tag
	** Log :
	** Log : Revision 1.1  1999/07/28 19:41:12  leon
	** Log : Mass update based on code donation from a live project
	** Log :
	**
	** Copyright (c) 1999 Working Dogs. All rights reserved. 
	*/

	/* Make sure the user has admin rights. */
	if( !$UserInfo["Permission"]["Administrate"] )
	{
		print(L_REPORTINVENTORY_DENIED . "<BR>\n");
	}
	else
	{
		$query = "SELECT i.name, s.Name, s.ExternalSKU, x.Available, " . 
			"x.Reserve, x.Backorder ";
		$query .= "FROM item i, sku s, inventory x ";
		$query .= "WHERE i.ID = s.Item ";
		$query .= "AND s.ID = x.SKU ";
		$query .= "ORDER BY i.DisplayPrecedence, i.Name, s.DisplayPrecedence, " . 
			"s.Name";
		/* Execute the query. */
		if ( !($recordSet = mysql_query($query, $DatabaseLink)) )
		{
			print("<!-- " . mysql_errno() . ": " . mysql_error() . 
				"   Query was: $query -->\n");
			print("<P><I>" . L_REPORTINVENTORY_UNABLETOQUERYDB . "<BR>\n");
		}
		else
		{
			/* Try to get a row. */ 
			if ( !(mysql_num_rows($recordSet)) )
			{
				print("<P><I>" . L_REPORTINVENTORY_EMPTYINVENTORY . "</I>\n");
			}
			/* Yahoo! We've got a valid list of records. */
			else
			{
				/* 
				** Start the table and headings. We'll do an outer table (for 
				** a nice outline) and an inner table for the data. 
				*/ 
				print("<TABLE WIDTH=\"100%\" BORDER=\"1\">\n<TR><TD>\n");
				print("<TABLE WIDTH=\"100%\">\n<TR>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_NAME . "</B></TD>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_SKU . "</B></TD>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_EXTERNALSKU . "</B></TD>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_AVAILABLE . "</B></TD>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_RESERVE . "</B></TD>\n");
				print("<TD VALIGN=\"TOP\"><B>" . L_REPORTINVENTORY_BACKORDERSALLOWED . "</B></TD>\n");
				print("</TR>\n");

				/* Output a row for each item. */
				while ($row = mysql_fetch_row($recordSet))
				{
					/* Parse the data. */ 
					$i = 0;
					$Name = $row[$i++];
					$SKU = $row[$i++];
					$ExternalSKU = $row[$i++];
					$Available = $row[$i++];
					$Reserve = $row[$i++];
					$Backorders = $row[$i++];
					print("<TR>\n");
					print("<TD>" . prepareText($Name) . "</TD>\n");
					print("<TD>$SKU</TD>\n");
					print("<TD>" . prepareText($ExternalSKU) . "</TD>\n");
					print("<TD>$Available</TD>\n");
					print("<TD>$Reserve</TD>\n");
					print("<TD>" . prepareText($Backorders) . "</TD>\n");
					print("</TR>\n");
				}

				/* Finish up the tables. */
				print("</TABLE>\n");
				print("</TD></TR>\n</TABLE>\n");
			}
		}
	}

?>
