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;
}
}
