$sql_client = "SELECT proj_num, proj_name, proj_id FROM intranet_projects WHERE proj_client_contact_id = '{$contact_id}'";
$result_client = mysql_query($sql_client, $conn);
if (mysql_num_rows($result_client) > 0) {
echo "<fieldset><legend>Client for projects</legend>";
echo "<table>";
while ($array_client = mysql_fetch_array($result_client)) {
$proj_id = $array_client['proj_id'];
$proj_num = $array_client['proj_num'];
$proj_name = $array_client['proj_name'];
echo "<tr><td style=\"width: 15%;\"><a href=\"index2.php?page=project_view&proj_id={$proj_id}\">{$proj_num}</a></td><td>{$proj_name}</td></tr>";
}
echo "</table></fieldset>";
}
// Add notes if any
if ($contact_reference != NULL) {
echo "<fieldset><legend>Notes</legend><blockquote>" . PresentText($contact_reference) . "</blockquote></fieldset>";
}
// Any file notes or phone records which relate to this client?
$sql_blog = "SELECT blog_id, blog_date, blog_title FROM intranet_projects_blog WHERE blog_contact = '{$contact_id}' ORDER BY blog_date";
$result_blog = mysql_query($sql_blog, $conn);
if (mysql_num_rows($result_blog) > 0) {
echo "<fieldset><legend>Journal Entries</legend>";
echo "<table>";
while ($array_blog = mysql_fetch_array($result_blog)) {
$blog_id = $array_blog['blog_id'];
$blog_date = $array_blog['blog_date'];
$blog_title = $array_blog['blog_title'];
echo "<tr><td style=\"width: 25%;\"><a href=\"index2.php?page=datebook_view_day&time={$blog_date}\">" . TimeFormat($blog_date) . "</a></td><td><a href=\"index2.php?page=project_blog_view&blog_id={$blog_id}\">{$blog_title}</a></td></tr>";
}
echo "</table></fieldset>";
}
print "<td {$rowspan} {$bg}>";
if ($user_usertype_current > 3 and $ts_expense_invoiced > 1) {
$sql_invoice = "SELECT invoice_id, invoice_ref FROM intranet_timesheet_invoice WHERE invoice_id = {$ts_expense_invoiced} LIMIT 1";
$result_invoice = mysql_query($sql_invoice, $conn) or die(mysql_error());
$array_invoice = mysql_fetch_array($result_invoice);
$invoice_id = $array_invoice['invoice_id'];
$invoice_ref = $array_invoice['invoice_ref'];
print "<a href=\"index2.php?page=timesheet_invoice_view&invoice_id={$invoice_id}\">{$invoice_ref}</a>";
} elseif ($ts_expense_p11d == 1) {
echo "P11d";
} else {
print "No";
}
print "<input type=\"hidden\" name=\"ts_expense_id[]\" value=\"{$ts_expense_id}\" /><input type=\"hidden\" name=\"ts_expense_desc[]\" value=\"{$ts_expense_desc}\" /></td></tr>";
if ($ts_expense_notes != NULL) {
print "<tr><td colspan=\"3\" {$bg}><span class=\"minitext\">Notes: " . PresentText($ts_expense_notes) . "</span></td></tr>";
}
}
print "<tr><td colspan=\"5\"><strong>TOTAL</strong></td><td colspan=\"3\" style=\"text-align:right;\"><strong>" . MoneyFormat($expense_total) . "</strong></td></tr>";
} else {
if ($_GET[user_id] > 0) {
print "<p>You have no outstanding expenses on the system.</p>";
} else {
print "<p>There are no expenses to verify.</p>";
}
}
if ($user_usertype_current > 3 and $_GET[user_id] == NULL) {
print "<tr><td colspan=\"8\"><input type=\"reset\" value=\"Clear\" /> <input type=\"submit\" value=\"Verify expenses (" . TimeFormat(time()) . ")\" /></td></tr>";
}
print "</table>";
print "</form>";
print "<p class=\"submenu_bar\">";
print "<a href=\"index2.php?page=timesheet_expense_edit&proj_id={$proj_id}\" class=\"submenu_bar\">Add Expenses</a>";
print "</p>";
print "<h2>Expenses</h2>";
$sql = "SELECT * FROM intranet_timesheet_expense WHERE ts_expense_project = '{$proj_id}' order by ts_expense_date";
$result = mysql_query($sql, $conn) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
print "<table summary=\"List of expenses for {$proj_num} {$proj_name}\">";
print "<tr><td style=\"width: 25%;\"><strong>Date</strong></td><td><strong>Description</strong></td><td><strong>Verified</strong></td><td><strong>Invoiced</strong></td><td><strong>Value</strong></td></tr>";
$ts_expense_value_invoiced = 0;
$ts_expense_value_total = 0;
while ($array = mysql_fetch_array($result)) {
$ts_expense_project = $array['ts_expense_project'];
$ts_expense_value = $array['ts_expense_value'];
$ts_expense_date = $array['ts_expense_date'];
$ts_expense_desc = PresentText($array['ts_expense_desc']);
$ts_expense_user = UserDetails($array['ts_expense_user']);
$ts_expense_verified = $array['ts_expense_verified'];
$ts_expense_vat = $array['ts_expense_vat'];
$ts_expense_id = $array['ts_expense_id'];
$ts_expense_invoiced = $array['ts_expense_invoiced'];
if ($ts_expense_verified == NULL) {
$ts_expense_verified = 0;
}
print "<tr>";
print "<td>" . TimeFormat($ts_expense_date) . "</td>";
print "<td><a href=\"index2.php?page=timesheet_expense_view&ts_expense_id={$ts_expense_id}\">" . $ts_expense_desc . "</a>";
if ($user_usertype_current > 3 and $ts_expense_verified == 0 or $ts_expense_user == $user_id_current and $ts_expense_verified == 0 or $proj_rep_black == $_COOKIE[user] and $ts_expense_verified == 0) {
print " <a href=\"index2.php?page=timesheet_expense_edit&status=edit&ts_expense_id={$ts_expense_id}\"><img src=\"images/button_edit.png\" alt=\"Edit\" /></a>";
}
print "</td>";
print "No";
}
print "</td></tr>";
// Pull the corresponding results from the Invoice Item list
$sql2 = "SELECT * FROM intranet_timesheet_invoice_item WHERE invoice_item_invoice = '{$invoice_id}'";
$result2 = mysql_query($sql2, $conn) or die(mysql_error());
// Pull the corresponding results from the Expenses List
$sql3 = "SELECT ts_expense_id, ts_expense_desc, ts_expense_vat, ts_expense_value FROM intranet_timesheet_expense WHERE ts_expense_invoiced = '{$invoice_id}'";
$result3 = mysql_query($sql3, $conn) or die(mysql_error());
$rowspan = mysql_num_rows($result2) + 2;
print "<tr><td colspan=\"2\"><strong>Invoice Details</strong></td></tr>";
// Output the Invoice Item details
if (mysql_num_rows($result2) > 0) {
while ($array2 = mysql_fetch_array($result2)) {
$invoice_item_id = $array2['invoice_item_id'];
$invoice_item_desc = PresentText($array2['invoice_item_desc']);
$invoice_item_novat = $array2['invoice_item_novat'];
$invoice_item_vat = $array2['invoice_item_vat'];
print "<tr><td>" . $invoice_item_desc . "";
// Allow to edit if invoice hasn't been issued
if ($invoice_date < time()) {
$confirm = "onClick=\"javascript:return confirm('This item has been invoiced - are you sure you want to edit it?')\"";
}
if ($invoice_date > time() or $user_usertype_current > 2) {
print " <a href=\"index2.php?page=timesheet_invoice_items_edit&invoice_item_id={$invoice_item_id}&proj_id={$proj_id}\" {$confirm}><img src=\"images/button_edit.png\" alt=\"Edit Invoice\" /></a>";
}
print "</td><td style=\"text-align: right;\">" . MoneyFormat($invoice_item_novat) . "</td></tr>";
$invoice_total_all = $invoice_total_all + $invoice_item_vat;
$invoice_total_sub = $invoice_total_sub + $invoice_item_novat;
}
print "<tr><td><u>Fees Sub Total (excl. VAT)</u></td><td style=\"text-align: right;\"><u>" . MoneyFormat($invoice_total_sub) . "</u></td></tr>";
