/** * @param array $ids */ static function delete($ids) { if (!is_array($ids)) { $ids = array($ids); } $db = DevblocksPlatform::getDatabaseService(); $id_list = implode(',', $ids); // Orgs $sql = sprintf("DELETE QUICK FROM contact_org WHERE id IN (%s)", $id_list); $db->Execute($sql) or die(__CLASS__ . '(' . __LINE__ . ')' . ':' . $db->ErrorMsg()); /* @var $rs ADORecordSet */ // Clear any associated addresses $sql = sprintf("UPDATE address SET contact_org_id = 0 WHERE contact_org_id IN (%s)", $id_list); $db->Execute($sql) or die(__CLASS__ . '(' . __LINE__ . ')' . ':' . $db->ErrorMsg()); /* @var $rs ADORecordSet */ // Tasks DAO_Task::deleteBySourceIds('cerberusweb.tasks.org', $ids); // Custom fields DAO_CustomFieldValue::deleteBySourceIds(ChCustomFieldSource_Org::ID, $ids); // Notes DAO_Note::deleteBySourceIds(ChNotesSource_Org::ID, $ids); }
static function delete($ids) { if (!is_array($ids)) { $ids = array($ids); } $db = DevblocksPlatform::getDatabaseService(); $ids_list = implode(',', $ids); // Opps $db->Execute(sprintf("DELETE QUICK FROM crm_opportunity WHERE id IN (%s)", $ids_list)); // Custom fields DAO_CustomFieldValue::deleteBySourceIds(CrmCustomFieldSource_Opportunity::ID, $ids); // Notes DAO_Note::deleteBySourceIds(CrmNotesSource_Opportunity::ID, $ids); return true; }
/** * Enter description here... * * @param array $ids */ static function delete($ids) { if (!is_array($ids)) { $ids = array($ids); } $db = DevblocksPlatform::getDatabaseService(); if (empty($ids)) { return; } $ids_list = implode(',', $ids); // Tasks $db->Execute(sprintf("DELETE QUICK FROM task WHERE id IN (%s)", $ids_list)); // Custom fields DAO_CustomFieldValue::deleteBySourceIds(ChCustomFieldSource_Task::ID, $ids); // Notes DAO_Note::deleteBySourceIds(ChNotesSource_Task::ID, $ids); return true; }