$ts_expense_vat = $array_expense['ts_expense_vat']; $ts_expense_verified = $array_expense['ts_expense_verified']; $ts_expense_reimburse = $array_expense['ts_expense_reimburse']; $ts_expense_invoice = $array_expense['ts_expense_invoice']; $ts_expense_p11d = $array_expense['ts_expense_p11d']; $proj_fee_track = $array_expense['proj_fee_track']; $proj_num = $array_expense['proj_num']; $expense_cat_name = $array_expense['expense_cat_name']; //check for duplicates if ($ts_expense_vat == $ts_expense_vat_duplicate and $ts_expense_verified == 0 and $show_non_personal == NULL or array_search($ts_expense_vat, $array_duplicate) == TRUE and $ts_expense_verified == 0 and $show_non_personal == NULL) { $ts_expense_desc = $ts_expense_desc . " - <strong>DUPLICATE ENTRY?</strong>"; } if ($array_expense['ts_expense_notes'] != NULL) { $ts_expense_desc = $ts_expense_desc . "<br />[Note: " . $array_expense['ts_expense_notes'] . "]"; } $ts_expense_desc = DeCode(RemoveShit($ts_expense_desc)); if ($ts_expense_p11d == 1) { if ($ts_expense_reimburse == 0 and $ts_expense_verified == 0) { $style_add = "background-color: #f6d1d1; color: #e24141"; $total_queried = $total_queried + $ts_expense_vat; } else { $style_add = NULL; } echo "<tr><td style=\"{$style_add}\"><a href=\"index2.php?page=timesheet_expense_view&ts_expense_id={$ts_expense_id}\">{$ts_expense_id}</a></td><td style=\"{$style_add}\">{$ts_expense_date}</td><td colspan=\"2\" style=\"{$style_add}\">{$ts_expense_desc}</td><td style=\"{$style_add}\">{$expense_cat_name}</td>"; echo "<td style=\"text-align: right; width: 15%; {$style_add}\">" . CashFormat($ts_expense_vat) . "</td>"; $col1 = $col1 + $ts_expense_vat; if ($ts_expense_reimburse > 0 and $ts_expense_verified == 0) { echo "<td style=\"text-align: right; width: 15%; {$style_add}\">" . CashFormat($ts_expense_vat) . "</td>"; $col2 = $col2 + $ts_expense_vat; } else { echo "<td style=\"text-align: right; width: 15%; {$style_add}\"> - </td>";
$contact_postcode = $array_client['contact_postcode']; $contact_country = $array_client['contact_country']; // Get contact prefix $sql_prefix = "SELECT * FROM contacts_prefixlist WHERE prefix_id = '{$contact_prefix}' LIMIT 1"; $result_prefix = mysql_query($sql_prefix, $conn) or die(mysql_error()); $array_prefix = mysql_fetch_array($result_prefix); if (mysql_num_rows > 0) { $prefix_name = DeCode($array_prefix['prefix_name']) . " "; } else { $prefix_name = NULL; } if ($contact_company > 0) { $sql_company = "SELECT * FROM contacts_companylist WHERE company_id = '{$contact_company}' LIMIT 1"; $result_company = mysql_query($sql_company, $conn) or die(mysql_error()); $array_company = mysql_fetch_array($result_company); $contact_companyname = DeCode($array_company['company_name']); $contact_address = $array_company['company_address']; $contact_city = $array_company['company_city']; $contact_county = $array_company['company_county']; $contact_postcode = $array_company['company_postcode']; $contact_country = $array_company['company_country']; } else { $contact_companyname = NULL; } if ($company_country != NULL) { $contact_country = $company_country; } // Determine the country $sql_country = "SELECT country_printable_name FROM intranet_contacts_countrylist where country_id = '{$contact_country}' LIMIT 1"; $result_country = mysql_query($sql_country, $conn); $array_country = mysql_fetch_array($result_country);
$sql_contact = "SELECT * FROM contacts_contactlist WHERE contact_company = '{$company_id}' ORDER BY contact_namesecond"; $result_contact = mysql_query($sql_contact, $conn) or die(mysql_error()); if (mysql_num_rows($result_contact) > 0) { print "<fieldset><legend>Company Contacts</legend>"; print "<table width=\"100%\">"; while ($array_contact = mysql_fetch_array($result_contact)) { $contact_id = $array_contact['contact_id']; $contact_namefirst = $array_contact['contact_namefirst']; $contact_namesecond = $array_contact['contact_namesecond']; $contact_mobile = $array_contact['contact_mobile']; $contact_telephone = $array_contact['contact_telephone']; $contact_email = $array_contact['contact_email']; print "<tr>"; print "<td class=\"color\"><a href=\"index2.php?page=contacts_view_detailed&contact_id={$contact_id}\">{$contact_namefirst} {$contact_namesecond}</td>"; if ($contact_mobile != "") { print "<td class=\"color\" align=\"center\">M</td><td class=\"color\">{$contact_mobile}</td>"; } elseif ($contact_telephone != "") { print "<td class=\"color\" align=\"center\">T</td><td class=\"color\">{$contact_telephone}</td>"; } elseif ($contact_email != "") { print "<td class=\"color\" align=\"center\">E</td><td class=\"color\"><a href=\"mailto:{$contact_email}\">{$contact_email}</a></td>"; } else { echo "<td colspan=\"2\"></td>"; } print "</tr>"; } print "</table>"; print "</fieldset>"; } if ($company_notes != NULL) { echo "<fieldset><legend>Notes</legend><blockquote>" . DeCode($company_notes) . "</blockquote></fieldset>"; }