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; }
public static function get_list($_FORM) { /* * This is the definitive method of getting a list of clients that need a sophisticated level of filtering * */ global $TPL; $filter = client::get_list_filter($_FORM); $debug = $_FORM["debug"]; $debug and print "<pre>_FORM: " . print_r($_FORM, 1) . "</pre>"; $debug and print "<pre>filter: " . print_r($filter, 1) . "</pre>"; $_FORM["return"] or $_FORM["return"] = "html"; if (is_array($filter) && count($filter)) { $filter = " WHERE " . implode(" AND ", $filter); } $cc = config::get_config_item("clientCategories"); foreach ($cc as $k => $v) { $clientCategories[$v["value"]] = $v["label"]; } $q = "SELECT client.*,clientContactName, clientContactEmail, clientContactPhone, clientContactMobile\n FROM client \n LEFT JOIN clientContact ON client.clientID = clientContact.clientID AND clientContact.clientContactActive = 1\n " . $filter . " \n GROUP BY client.clientID \n ORDER BY clientName,clientContact.primaryContact asc"; $debug and print "Query: " . $q; $db = new db_alloc(); $db2 = new db_alloc(); $db->query($q); while ($row = $db->next_record()) { $print = true; $c = new client(); $c->read_db_record($db); $row["clientCategoryLabel"] = $clientCategories[$c->get_value("clientCategory")]; $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[$c->get_id()] = $row; } return (array) $rows; }