<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:template match="/">
		<HTML>
			<head>
				<title>Vacation Time Info</title>
			</head>
			<BODY style="background-color: LightBlue">
				<div style="font-size: 22pt; font-weight: bold">Remaining Employee Vacation Time</div><br/><br/>
				<table style="display: table;border-collapse:collapse; margin-left: 25px">
					<tr style="font-weight: bold">
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 5px; padding-right: 5px">Employee Name</td>			
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 5px; padding-right: 5px">Position</td>
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 5px; padding-right: 5px">Library</td>
						<td style="width: 150px; border-style: solid; border-width: thin; text-align: center; padding-left: 5px; padding-right: 5px">Remaining Vacation Time (Hours)</td>
					</tr>
					<xsl:for-each select="library_info/library/employee_info/employee/employee_name">
						<xsl:sort select="last" order="ascending" data-type="text"/>
						<tr>
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 8px; padding-right: 8px"><xsl:value-of select="concat(last,',',' ',first)"/></td>
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 8px; padding-right: 8px"><xsl:value-of select="@position"/></td>
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 11px; padding-right: 11px"><xsl:value-of select="ancestor::library/library_name"/></td>
						<td style="border-style: solid; border-width: thin; text-align: center; padding-left: 5px; padding-right: 5px"><xsl:value-of select="../vacation_available_hours"/></td>
						</tr>
					</xsl:for-each>
				</table>
				
			</BODY>
		</HTML>
	</xsl:template>
</xsl:stylesheet>
