+function get_contacts_for_branch($branch)
+{
+ $sql = "SELECT p.*, r.action, r.type, CONCAT(r.type,'.',r.action) as ext_type
+ FROM ".TB_PREF."crm_persons p,".TB_PREF."crm_contacts r WHERE r.person_id=p.id AND r.type='cust_branch'
+ AND r.entity_id=".db_escape($branch);
+ $res = db_query($sql, "can't retrieve branch contacts");
+ $results = array();
+ while($contact = db_fetch($res))
+ $results[] = $contact;
+ return $results;
+}