function buildEntityQuery($entity, &$db) { switch ($entity) { case 'group' : return "Select group_domain_id as domain_id, group_name as cn, group_id as id, group_email as mail, 'group' as kind FROM UGroup"; case 'task' : return "SELECT ".$GLOBALS['obm']['domain_id']." as domain_id, projecttask_id as id, projecttask_label as cn, projecttask_label as mail, 'task' as kind FROM ProjectTask"; break; case 'resource' : return "SELECT resource_domain_id as domain_id, resource_name AS cn, resource_name AS mail, resource_id AS id, 'resource' AS kind FROM Resource"; break; case 'user' : $c_id = "userobm_id"; $concat[0]["type"] = "field"; $concat[0]["value"] = "userobm_firstname"; $concat[1]["type"] = "string"; $concat[1]["value"] = " "; $concat[2]["type"] = "field"; $concat[2]["value"] = "userobm_lastname"; $label = sql_string_concat($db->type, $concat); return "SELECT userobm_domain_id as domain_id, $label as cn, userobm_id as id, userobm_email as mail, 'user' as kind FROM UserObm"; break; case 'contact' : $concat = array ( array( 'type' => 'field', 'value' => 'contact_firstname' ), array( 'type' => 'string', 'value' => ' ' ), array( 'type' => 'field', 'value' => 'contact_middlename' ), array( 'type' => 'string', 'value' => ' ' ), array( 'type' => 'field', 'value' => 'contact_lastname' )); $cn = sql_string_concat($db->type, $concat); return "SELECT contact_id AS id, contact_domain_id AS domain_id, $cn AS cn, email_address AS mail, 'user' AS kind FROM Contact INNER JOIN ContactEntity ON contactentity_contact_id = contact_id INNER JOIN Email ON email_entity_id = contactentity_entity_id"; break; default: return NULL; } }
function buildEntityQuery($entity, &$db) { switch ($entity) { case 'group' : return "Select group_domain_id as domain_id, group_name as cn, group_id as id, group_email as mail, 'group' as kind FROM UGroup"; case 'task' : return "SELECT ".$GLOBALS['obm']['domain_id']." as domain_id, projecttask_id as id, projecttask_label as cn, projecttask_label as mail, 'task' as kind FROM ProjectTask"; break; case 'resource' : return "SELECT resource_domain_id as domain_id, resource_name AS cn, resource_name AS mail, resource_id AS id, 'resource' AS kind FROM Resource"; break; case 'user' : $c_id = "userobm_id"; $concat[0]["type"] = "field"; $concat[0]["value"] = "userobm_firstname"; $concat[1]["type"] = "string"; $concat[1]["value"] = " "; $concat[2]["type"] = "field"; $concat[2]["value"] = "userobm_lastname"; $label = sql_string_concat($db->type, $concat); return "SELECT userobm_domain_id as domain_id, $label as cn, userobm_id as id, userobm_email as mail, 'user' as kind FROM UserObm"; break; default: return NULL; } }