bg-light"> = 1) && $config_module_enable_accounting == 1) { ?> = 2) { ?> "; } $contact_id = intval($row['contact_id']); $contact_name = nullable_htmlentities($row['contact_name']); $contact_title = nullable_htmlentities($row['contact_title']); $contact_phone_country_code = nullable_htmlentities($row['contact_phone_country_code']); $contact_phone = nullable_htmlentities(formatPhoneNumber($row['contact_phone'], $contact_phone_country_code)); $contact_extension = nullable_htmlentities($row['contact_extension']); $contact_mobile_country_code = nullable_htmlentities($row['contact_mobile_country_code']); $contact_mobile = nullable_htmlentities(formatPhoneNumber($row['contact_mobile'], $contact_mobile_country_code)); $contact_email = nullable_htmlentities($row['contact_email']); $client_website = nullable_htmlentities($row['client_website']); $client_rate = floatval($row['client_rate']); $client_currency_code = nullable_htmlentities($row['client_currency_code']); $client_net_terms = intval($row['client_net_terms']); $client_tax_id_number = nullable_htmlentities($row['client_tax_id_number']); $client_referral = nullable_htmlentities($row['client_referral']); $client_abbreviation = nullable_htmlentities($row['client_abbreviation']); $client_notes = nullable_htmlentities($row['client_notes']); $client_created_at = date('Y-m-d', strtotime($row['client_created_at'])); $client_updated_at = nullable_htmlentities($row['client_updated_at']); $client_archived_at = nullable_htmlentities($row['client_archived_at']); $client_is_lead = intval($row['client_lead']); // Abbreviation if (empty($client_abbreviation)) { $client_abbreviation = shortenClient($client_name); } // Counts // Contact Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('contact_id') AS num FROM contacts WHERE contact_client_id = $client_id AND contact_archived_at IS NULL")); $contact_count = $row['num']; if ($contact_count) { $contact_count_display = "$contact_count"; } else { $contact_count_display = ''; } // Vendors Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('vendor_id') AS num FROM vendors WHERE vendor_client_id = $client_id AND vendor_archived_at IS NULL")); $vendor_count = $row['num']; if ($vendor_count) { $vendor_count_display = "$vendor_count"; } else { $vendor_count_display = ''; } // Asset Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('asset_id') AS num FROM assets WHERE asset_client_id = $client_id AND asset_archived_at IS NULL")); $asset_count = $row['num']; if ($asset_count) { $asset_count_display = "$asset_count"; } else { $asset_count_display = ''; } // Credential Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('credential_id') AS num FROM credentials WHERE credential_client_id = $client_id AND credential_archived_at IS NULL")); $credential_count = $row['num']; if ($credential_count) { $credential_count_display = "$credential_count"; } else { $credential_count_display = ''; } // Software Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('software_id') AS num FROM software WHERE software_client_id = $client_id AND software_archived_at IS NULL")); $software_count = $row['num']; if ($software_count) { $software_count_display = "$software_count"; } else { $software_count_display = ''; } // Ticket Count $row = mysqli_fetch_assoc(mysqli_query($mysqli, "SELECT COUNT('ticket_id') AS num FROM tickets WHERE ticket_client_id = $client_id AND ticket_archived_at IS NULL")); $ticket_count = $row['num']; if ($ticket_count) { $ticket_count_display = "$ticket_count"; } else { $ticket_count_display = ''; } // Client Tags $client_tag_name_display_array = array(); $client_tag_id_array = array(); $sql_client_tags = mysqli_query($mysqli, "SELECT * FROM client_tags LEFT JOIN tags ON client_tags.tag_id = tags.tag_id WHERE client_id = $client_id ORDER BY tag_name ASC"); while ($row = mysqli_fetch_array($sql_client_tags)) { $client_tag_id = intval($row['tag_id']); $client_tag_name = nullable_htmlentities($row['tag_name']); $client_tag_color = nullable_htmlentities($row['tag_color']); if (empty($client_tag_color)) { $client_tag_color = "dark"; } $client_tag_icon = nullable_htmlentities($row['tag_icon']); if (empty($client_tag_icon)) { $client_tag_icon = "tag"; } $client_tag_id_array[] = $client_tag_id; $client_tag_name_display_array[] = "$client_tag_name"; } $client_tags_display = implode('', $client_tag_name_display_array); //Add up all the payments for the invoice and get the total amount paid to the invoice $sql_invoice_amounts = mysqli_query($mysqli, "SELECT SUM(invoice_amount) AS invoice_amounts FROM invoices WHERE invoice_client_id = $client_id AND invoice_status != 'Draft' AND invoice_status != 'Cancelled' AND invoice_status != 'Non-Billable' "); $row = mysqli_fetch_array($sql_invoice_amounts); $invoice_amounts = floatval($row['invoice_amounts']); $sql_amount_paid = mysqli_query($mysqli, "SELECT SUM(payment_amount) AS amount_paid FROM payments, invoices WHERE payment_invoice_id = invoice_id AND invoice_client_id = $client_id"); $row = mysqli_fetch_array($sql_amount_paid); $amount_paid = floatval($row['amount_paid']); $balance = $invoice_amounts - $amount_paid; //set Text color on balance if ($balance > 0) { $balance_text_color = "text-danger font-weight-bold"; } else { $balance_text_color = ""; } // Get Credit Balance $sql_credit_balance = mysqli_query($mysqli, "SELECT SUM(credit_amount) AS credit_balance FROM credits WHERE credit_client_id = $client_id"); $row = mysqli_fetch_array($sql_credit_balance); $credit_balance = floatval($row['credit_balance']); //Get Monthly Recurring Total $sql_recurring_monthly_total = mysqli_query($mysqli, "SELECT SUM(recurring_invoice_amount) AS recurring_monthly_total FROM recurring_invoices WHERE recurring_invoice_status = 1 AND recurring_invoice_frequency = 'month' AND recurring_invoice_client_id = $client_id"); $row = mysqli_fetch_array($sql_recurring_monthly_total); $recurring_monthly_total = floatval($row['recurring_monthly_total']); //Get Yearly Recurring Total $sql_recurring_yearly_total = mysqli_query($mysqli, "SELECT SUM(recurring_invoice_amount) AS recurring_yearly_total FROM recurring_invoices WHERE recurring_invoice_status = 1 AND recurring_invoice_frequency = 'year' AND recurring_invoice_client_id = $client_id"); $row = mysqli_fetch_array($sql_recurring_yearly_total); $recurring_yearly_total = floatval($row['recurring_yearly_total']) / 12; $recurring_monthly = $recurring_monthly_total + $recurring_yearly_total; ?> = 1) && $config_module_enable_accounting == 1) { ?> = 2) { ?>

	Client Name	Primary Location	Primary Contact		Billing	Action
	Abbreviation: Created:				Balance Paid 0) { ?> Credit Monthly Hourly Rate	Edit Restore Archive