$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>";