public static function get_list($_FORM)
{
global $TPL;
$filter = clientContact::get_list_filter($_FORM);
if (is_array($filter) && count($filter)) {
$filter = " WHERE " . implode(" AND ", $filter);
}
$q = "SELECT clientContact.*, client.*\n FROM clientContact\n LEFT JOIN client ON client.clientID = clientContact.clientID\n " . $filter . " \n GROUP BY clientContact.clientContactID \n ORDER BY clientContactName,clientContact.primaryContact asc";
$db = new db_alloc();
$db->query($q);
while ($row = $db->next_record()) {
$c = new client();
$c->read_db_record($db);
$row["clientLink"] = $c->get_client_link($_FORM);
$row["clientContactEmail"] and $row["clientContactEmail"] = "<a href=\"mailto:" . page::htmlentities($row["clientContactName"] . " <" . $row["clientContactEmail"] . ">") . "\">" . page::htmlentities($row["clientContactEmail"]) . "</a>";
$rows[] = $row;
}
return $rows;
}
