}
?>
</define-tag>
-
-<define-tag assign>
-<?
-function assignments($person, $starttime, $endtime)
-{
- global $dbh;
- $query = sprintf("SELECT job.title, assignment.starttime, assignment.endtime, " .
- " assignment.oid, fragment.comment, fragment.id from " .
- " assignment, fragment, job " .
- " where person = '%s' and assignment.starttime < '%s' and " .
- " assignment.endtime > '%s' and fragment.id = assignment.fragment " .
- " and fragment.job = job.id",
- addslashes($person), addslashes($endtime), addslashes($starttime));
- $sth = pg_exec($dbh, $query) or die ("Cannot execute query");
- if (pg_NumRows($sth)> 0)
- {
- ?>
- The person is assigned to the following fragments during this fragment<br>
- <table cellpadding=0 cellspacing=1>
- <tr>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Title</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Starttime</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Endtime</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Comment</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Edit</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Delete</b></font></td>
- </tr>
- <?
- for ($x = 0; $x < pg_NumRows($sth); $x++)
- {
- $row = pg_fetch_array($sth, $x);
}
?>
</define-tag>
-
-<define-tag assign>
-<?
-function assignments($person, $starttime, $endtime)
-{
- global $dbh;
- $query = sprintf("SELECT job.title, assignment.starttime, assignment.endtime, " .
- " assignment.oid, fragment.comment, fragment.id from " .
- " assignment, fragment, job " .
- " where person = '%s' and assignment.starttime < '%s' and " .
- " assignment.endtime > '%s' and fragment.id = assignment.fragment " .
- " and fragment.job = job.id",
- addslashes($person), addslashes($endtime), addslashes($starttime));
- $sth = pg_exec($dbh, $query) or die ("Cannot execute query");
- if (pg_NumRows($sth)> 0)
- {
- ?>
- The person is assigned to the following fragments during this fragment<br>
- <table cellpadding=0 cellspacing=1>
- <tr>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Title</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Starttime</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Endtime</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Comment</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Edit</b></font></td>
- <td bgcolor="<colh>"><font face="Helvetica,Arial"><b>Delete</b></font></td>
- </tr>
- <?
- for ($x = 0; $x < pg_NumRows($sth); $x++)
- {
- $row = pg_fetch_array($sth, $x);