/**
* Delete a contact
*
* @param Integer $c_id contact_id
* @return Boolean
*/
function DeleteContact($c_id) {
global $cdg_sql, $c_use_connectors;
$sql_id = sql_parse_id($c_id, true);
$this->logger->debug("Delete contact $c_id");
$obm_q = new DB_OBM;
$query = "SELECT contact_company_id, contact_birthday_id, contact_usercreate, contact_addressbook_id FROM Contact
WHERE contact_id $sql_id";
$this->logger->core($query);
$obm_q->query($query);
$obm_q->next_record();
$comp_id = $obm_q->f('contact_company_id');
$birthday_id = $obm_q->f('contact_birthday_id');
$uid = $obm_q->f('contact_usercreate');
$ad = $obm_q->f('contact_addressbook_id');
// Hook : Pre
if (function_exists('hook_pre_run_query_contact_delete')) {
if (! hook_pre_run_query_contact_delete($c_id)) {
return false;
}
}
run_query_global_delete_document_links($c_id, 'contact');
$ret = of_userdata_query_delete('contact', $c_id);
// BEGIN birthday support
$query = "DELETE FROM Event WHERE event_id = '$birthday_id'";
$this->logger->core($query);
$obm_q->query($query);
// END birthday support
of_entity_delete('contact', $c_id);
$query = "DELETE FROM Contact WHERE contact_id $sql_id";
$this->logger->core($query);
$obm_q->query($query);
// If connectors in use
if ($c_use_connectors) {
$query = "INSERT INTO
DeletedContact (deletedcontact_contact_id, deletedcontact_addressbook_id, deletedcontact_timestamp, deletedcontact_origin)
VALUES ($c_id, $ad, NOW(), '$GLOBALS[c_origin_cron]')";
$this->logger->core($query);
$obm_q->query($query);
}
// After contact deletion to get correct number
run_query_global_company_contact_number_update($comp_id);
// Delete index
OBM_IndexingService::delete('contact', $c_id);
}
private static function storeAnniversary($date='birthday', $contact_id, $contact_usercreate, $event_id, $contact_fullname, $old_value, $new_value) {
global $cdg_sql, $obm;
global $l_birthday_event_title, $l_anniversary_event_title;
list($nope_event, $insert_event, $update_event, $delete_event) = array(0,1,2,3);
if ($event_id == null) {
if ($new_value != null) {
$do = $insert_event;
}
} else {
if ($new_value == null) {
$do = $delete_event;
} else if ($new_value->compare($old_value) != 0) {
$do = $update_event;
}
}
$obm_q = new DB_OBM;
$multidomain_contact = sql_multidomain('contact');
$multidomain_event = sql_multidomain('event');
switch ($do) {
case $insert_event:
$duration = 3600*24;
$label = ${"l_${date}_event_title"};
$title = str_replace('\'', '\\\'', sprintf($label, $contact_fullname));
$ext_id = get_obm_info('product_id').sha1(uniqid()).sha1($GLOBALS['obm']['domain_name']).sha1(mktime()*rand());
$query = "INSERT INTO Event
(event_timeupdate,
event_timecreate,
event_usercreate,
event_origin,
event_owner,
event_ext_id,
event_timezone,
event_title,
event_date,
event_description,
event_properties,
event_location,
event_category1_id,
event_priority,
event_privacy,
event_duration,
event_repeatkind,
event_repeatfrequence,
event_repeatdays,
event_allday,
event_color,
event_endrepeat,
event_domain_id,
event_opacity)
VALUES
(
NOW(),
NOW(),
'$contact_usercreate',
'$GLOBALS[c_origin_web]',
'$contact_usercreate',
'$ext_id',
'".Of_Date::getOption('timezone')."',
'$title',
'$new_value',
'',
'',
'',
NULL,
'2',
'0',
'$duration',
'yearly',
'1',
'0000000',
'1',
'',
NULL,
'$obm[domain_id]',
'TRANSPARENT')";
$obm_q->query($query);
display_debug_msg($query, $cdg_sql, 'run_query_contact_birthday_update(insert event)');
$insert_event_id = $obm_q->lastid();
if ($insert_event_id) {
of_entity_insert('event', $insert_event_id);
$sql_id = sql_parse_id($contact_id);
$query = "UPDATE Contact
SET contact_${date}_id = $insert_event_id
WHERE
contact_id = $sql_id
$multidomain_contact";
$obm_q->query($query);
display_debug_msg($query, $cdg_sql, "run_query_contact_birthday_update(update birthday id)");
$entity_id = of_entity_get('user', $contact_usercreate);
$query = "INSERT INTO EventLink (
eventlink_timecreate,
eventlink_usercreate,
eventlink_event_id,
eventlink_entity_id,
eventlink_state)
VALUES (
NOW(),
$contact_usercreate,
$insert_event_id,
$entity_id,
'ACCEPTED')";
$obm_q->query($query);
display_debug_msg($query, $cdg_sql, "run_query_contact_birthday_update(insert entity)");
}
break;
case $update_event:
$sql_id = sql_parse_id($event_id);
$query = "UPDATE Event SET
event_date = '$new_value',
event_origin = '$GLOBALS[c_origin_web]'
WHERE
event_id = $sql_id
$multidomain_event";
$obm_q->query($query);
display_debug_msg($query, $cdg_sql, 'run_query_contact_birthday_update(update event)');
break;
case $delete_event:
of_entity_delete('event',$event_id);
$sql_id = sql_parse_id($event_id);
$query = "DELETE FROM Event WHERE event_id = $sql_id
$multidomain_event";
$obm_q->query($query);
display_debug_msg($query, $cdg_sql, 'run_query_contact_birthday_update(delete event)');
break;
}
}