<?php
session_start();
$pageselect="adminpooledjobs";//so the correct sqls from sqlqueries.php are executed
include('sqlqueries.php');//plugs in the sqlqueries.php file
function newjobheader(){
//The code below echos out the header fields for the new jobs
echo"<table class=\"style1\" id=\"table0\" width=\"580\" border=\"2\" cellspacing=\"2\" cellpadding=\"0\"><tr bgcolor=\"#1C78B7\">
<td><div align=\"center\">Job ID</div></td>
<td><div align=\"center\">Client</td>
<td><div align=\"center\">Date Created</div></td>
<td><div align=\"center\">Desc Summary</div></td>
<td><div align=\"center\">Type ID</div></td>
<td><div align=\"center\">Problem ID</div></td>
<td><div align=\"center\">Comments</div></td>
<td><div align=\"center\">Exp Date</div></td>
<td><div align=\"center\"></div></td></tr>";
}//end of newjobheader function
function assignedjobheader(){
//The code below echos out the header fields for the new jobs
echo"<table table class=\"style1\" id=\"table1\" width=\"740\" border=\"2\" cellspacing=\"2\" cellpadding=\"0\"><tr bgcolor=\"#1C78B7\">
<td><div align=\"center\"><span class=\"style1\">Job ID</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Client</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Date Created</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Desc Summary</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Technician</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Type ID</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Problem ID</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Expected Date</span></div></td>
<td><div align=\"center\"><span class=\"style1\">Comments</span></div></td>
<td><div align=\"center\"><span class=\"style1\"></span></div></td>
<td><div align=\"center\"><span class=\"style1\"></span></div></td></tr>";
}//end of newjobheader function
function newjobrecords(){
global $row;
global $count;
//<input type=\"hidden\" name=\"description\" value=\"".$row[2]."\">
echo"<td><span class=\"style2\"> $row[0]</span></td>
<td><span class=\"style2\"> $row[4]</span></td>
<td><span class=\"style2\"> $row[3]</span></td>
<td><span class=\"style2\"> <a href=\"javascript:Avaa('description.php?id1=$row[0]&id2=$row[2]')\">$row[1]</a></span></td>
<td><span class=\"style2\"> $row[5]</span></td>
<td><span class=\"style2\"> $row[6]</span></td>
<td><span class=\"style2\"> $row[7]</span></td>
<td><form name=\"myform\"><span class=\"style2\"> <input type=\"Text\" name=\"mytext\" value=\"\"><a href=\"javascript:call.popup();\"><img src=\"images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Click Here to Pick up the date\"></a> </span></form>
<script language=\"JavaScript\">
var call = new calendar1(document.forms['myform'].elements['mytext']);
call.year_scroll = true;
call.time_comp = false;
</script>
</td>
<td><form name=\"assignjob".$row[0]."\" method=\"post\" action=\"\" onSubmit=\"\">
<input type=\"hidden\" name=\"assignthejob\" value=\"".$row[0]."\">
<input type=\"submit\" name=\"assign\" value=\"Assign\">
</form>
</td>
</tr>\n";
$count++;
}
function adminjobrecords(){
// <input type=\"hidden\" name=\"description\" value=\"".$rowassigend[2]."\">
global $rowassigend;
echo"<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[0]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[6]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[3]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[1]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[4]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[7]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[8]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[5]</font></span></td>
<td><span class=\"style2\"> <font color=\"$rowassigend[10]\">$rowassigend[9]</font></span></td>
<td align=\"center\"><input name=\"Submit\" type=\"submit\" value=\"Edit\">
<td align=\"center\"><input name=\"Submit\" type=\"submit\" value=\"Close\"></td>
</tr>\n";
}
// needed to create a space at the beginning of the table
//$rowassigend[10] gets the colour from the database
?>
<html>
<head>
<title>Pooled Jobs</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK REL="[URL unfurl="true"]http://128.1.1.68/hdesk/"[/URL]
HREF="images/favicon.ico">
<script language="JavaScript" src="calendar/calendar1.js"></script><!-- Date only with year scrolling -->
<script type="text/javascript">
function Avaa(newin) {
flyout=window.open(newin,"flyout","resizable=no,scrollbars=no,width=325,height=330,top=200,left=230")
//flyout is an object that can be closed etc, newin is for the URL, flyout is the name, and the rest is the window properties
}
</script>
<script src="sorttable.js">//this is used to sort the tables</script>
</head>
<body bgcolor="#1c78b7" onLoad='initTable("table0"); initTable("table1");'>
<?
include("menu/header.php");
?>
<table align="center" bgcolor="white" width="620" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/topleft.jpg" width="20" height="20"></td>
</tr>
</table></td>
<td width="580" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="580" height="20"> </td>
</tr>
</table></td>
<td width="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/topright.jpg" width="20" height="20"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" height="20"> </td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<td width="580" height="20">
<?php
newjobheader();//function displays the new job header info
while($row = mysql_fetch_array($newadminjobs, MYSQL_NUM)){
newjobrecords();
?>
<script language="JavaScript">
// var call = new calendar1(document.forms['form'].elements['text']);
// call.year_scroll = true;
// call.time_comp = false;
//document.write(document.forms['form']);
</script>
<?
}//end of while
echo"</table>";//end of the table new jobs
?>
</td>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/bottomleft.jpg" width="20" height="20"></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="580" height="20"> </td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/bottomright.jpg" width="20" height="20"></td>
</tr>
</table></td>
</tr>
</table>
<p>
</p>
<!--assigned jobs------------------------------------------------------------------------------------------->
<table align="center" bgcolor="white" width="780" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/topleft.jpg" width="20" height="20"></td>
</tr>
</table></td>
<td width="740" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="740" height="20"> </td>
</tr>
</table></td>
<td width="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/topright.jpg" width="20" height="20"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" height="20"> </td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<td width="740" height="20">
<?php
assignedjobheader();//function displays the new job header info
while($rowassigend = mysql_fetch_array($assignedadminjobs, MYSQL_NUM)){
adminjobrecords();
}
echo"</table>";
?>
</td>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/bottomleft.jpg" width="20" height="20"></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="740" height="20"> </td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="20" height="20" valign="top"><img src="images/bottomright.jpg" width="20" height="20"></td>
</tr>
</table></td>
</tr>
</table>
<?
include("menu/footer.php");
?>
</body>
</html>