protected $_renameTags = 1;
- protected $_sitePrefix = 'Site 1'; function __construct(&$params) {
+ protected $_sitePrefix = 'Site 1';
+
+ function __construct(&$params) {
foreach ($params as $name => $value) {
$varName = '_' . $name;
$this->$varName = $value;
function &splitContactIDs(&$contactIDs) {
// contactIDs could be a real large array, so we split it up into
// smaller chunks and then general xml for each chunk
- $chunks = array();
- $current = 0;
+ $chunks = array();
+ $current = 0;
$chunks[$current] = array();
- $count = 0;
+ $count = 0;
foreach ($contactIDs as $k => $v) {
$chunks[$current][$k] = $v;
function auxTable($tables) {
foreach ($tables as $tableName => $daoName) {
- $fields = &$this->dbFields($daoName, TRUE);
+ $fields = & $this->dbFields($daoName, TRUE);
$sql = "SELECT * from $tableName";
$this->sql($sql, $tableName, $fields);
FROM civicrm_option_group
WHERE name IN ( $nameString )
";
- $fields = &$this->dbFields('CRM_Core_DAO_OptionGroup', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_OptionGroup', TRUE);
$this->sql($sql, 'civicrm_option_group', $fields);
$sql = "
INNER JOIN civicrm_option_group g ON v.option_group_id = g.id
WHERE g.name IN ( $nameString )
";
- $fields = &$this->dbFields('CRM_Core_DAO_OptionValue', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_OptionValue', TRUE);
$this->sql($sql, 'civicrm_option_value', $fields);
}
function table(&$ids,
- $tableName,
- &$fields,
- $whereField,
- $additionalWhereCond = NULL
+ $tableName,
+ &$fields,
+ $whereField,
+ $additionalWhereCond = NULL
) {
if (empty($ids)) {
return;
}
function sql($sql, $tableName, &$fields) {
- $dao = &CRM_Core_DAO::executeQuery($sql);
+ $dao = & CRM_Core_DAO::executeQuery($sql);
while ($dao->fetch()) {
$value = array();
}
function contact(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Contact_DAO_Contact', TRUE);
+ $fields = & $this->dbFields('CRM_Contact_DAO_Contact', TRUE);
$this->table($contactIDs, 'civicrm_contact', $fields, 'id', NULL);
}
function note(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_Note', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Note', TRUE);
$this->table($contactIDs, 'civicrm_note', $fields, 'entity_id', "entity_table = 'civicrm_contact'");
}
function phone(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_Phone', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Phone', TRUE);
$this->table($contactIDs, 'civicrm_phone', $fields, 'contact_id', NULL);
}
function email(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_Email', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Email', TRUE);
$this->table($contactIDs, 'civicrm_email', $fields, 'contact_id', NULL);
}
function im(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_IM', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_IM', TRUE);
$this->table($contactIDs, 'civicrm_im', $fields, 'contact_id', NULL);
}
function website(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_Website', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Website', TRUE);
$this->table($contactIDs, 'civicrm_website', $fields, 'contact_id', NULL);
}
function address(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_Email', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Email', TRUE);
$this->table($contactIDs, 'civicrm_address', $fields, 'contact_id', NULL);
}
function groupContact(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Contact_DAO_GroupContact', TRUE);
+ $fields = & $this->dbFields('CRM_Contact_DAO_GroupContact', TRUE);
$this->table($contactIDs, 'civicrm_group_contact', $fields, 'contact_id', NULL);
}
}
}
- $fields = &$this->dbFields('CRM_Contact_DAO_Group', TRUE);
+ $fields = & $this->dbFields('CRM_Contact_DAO_Group', TRUE);
$this->table($groupIDs, 'civicrm_group', $fields, 'id');
$this->savedSearch($groupIDs);
WHERE g.id IN ( $idString )
";
- $fields = &$this->dbFields('CRM_Contact_DAO_SavedSearch', TRUE);
+ $fields = & $this->dbFields('CRM_Contact_DAO_SavedSearch', TRUE);
$this->sql($sql, 'civicrm_saved_search', $fields);
}
function entityTag(&$contactIDs) {
- $fields = &$this->dbFields('CRM_Core_DAO_EntityTag', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_EntityTag', TRUE);
$this->table($contactIDs, 'civicrm_entity_tag', $fields, 'entity_id', "entity_table = 'civicrm_contact'");
}
}
}
- $fields = &$this->dbFields('CRM_Core_DAO_Tag', TRUE);
+ $fields = & $this->dbFields('CRM_Core_DAO_Tag', TRUE);
$this->table($tagIDs, 'civicrm_tag', $fields, 'id');
}
";
$fields = $this->dbFields('CRM_Contact_DAO_Relationship', TRUE);
- $dao = &CRM_Core_DAO::executeQuery($sql);
+ $dao = & CRM_Core_DAO::executeQuery($sql);
while ($dao->fetch()) {
if (isset($_relationshipsHandled[$dao->id])) {
continue;
$this->appendValue($dao->id, 'civicrm_relationship', $relationship);
$this->addAdditionalContacts(array(
- $dao->contact_id_a,
+ $dao->contact_id_a,
$dao->contact_id_b,
),
$additionalContacts
function activity(&$contactIDs, &$additionalContacts) {
static $_activitiesHandled = array();
+ $activityContacts = CRM_Core_OptionGroup::values('activity_contacts', FALSE, FALSE, FALSE, NULL, 'name');
+ $assigneeID = CRM_Utils_Array::key('Activity Assignees', $activityContacts);
+ $targetID = CRM_Utils_Array::key('Activity Targets', $activityContacts);
$ids = implode(',', $contactIDs);
$sql = "(
SELECT a.*
FROM civicrm_activity a
- INNER JOIN civicrm_activity_contact aa ON aa.activity_id = a.id AND aa.record_type = 'Assignee'
+ INNER JOIN civicrm_activity_contact aa ON aa.activity_id = a.id AND aa.record_type_id = $assigneeID
WHERE aa.contact_id IN ( $ids )
AND ( a.activity_type_id != 3 AND a.activity_type_id != 20 )
) UNION (
SELECT a.*
FROM civicrm_activity a
- INNER JOIN civicrm_activity_contact at ON at.activity_id = a.id AND at.record_type = 'Target'
+ INNER JOIN civicrm_activity_contact at ON at.activity_id = a.id AND at.record_type_id = $targetID
WHERE at.contact_id IN ( $ids )
AND ( a.activity_type_id != 3 AND a.activity_type_id != 20 )
)
";
- $fields = &$this->dbFields('CRM_Activity_DAO_Activity', TRUE);
+ $fields = & $this->dbFields('CRM_Activity_DAO_Activity', TRUE);
$activityIDs = array();
- $dao = &CRM_Core_DAO::executeQuery($sql);
+ $dao = & CRM_Core_DAO::executeQuery($sql);
while ($dao->fetch()) {
if (isset($_activitiesHandled[$dao->id])) {
continue;
$activityIDString = implode(",", $activityIDs);
// now get all assignee contact ids and target contact ids for this activity
- $sql = "SELECT * FROM civicrm_activity_contact WHERE activity_id IN ($activityIDString) AND record_type = 'Assignee'";
- $aaDAO = &CRM_Core_DAO::executeQuery($sql);
+ $sql = "SELECT * FROM civicrm_activity_contact WHERE activity_id IN ($activityIDString) AND record_type = 'Assignee'";
+ $aaDAO = &CRM_Core_DAO::executeQuery($sql);
+
$activityContacts = array();
while ($aaDAO->fetch()) {
$activityAssignee = array(
$sql = "SELECT * FROM civicrm_activity_contact WHERE activity_id IN ($activityIDString) AND record_type = 'Target'";
$atDAO = &CRM_Core_DAO::executeQuery($sql);
+
while ($atDAO->fetch()) {
$activityTarget = array(
'id' => $atDAO->id,
) . '.php';
include_once ($daoFile);
- $daoFields = &$daoName::fields();
+ $daoFields = & $daoName::fields();
foreach ($daoFields as $key => & $value) {
$_fieldsRetrieved[$daoName][$value['name']] = array(
}
function export(&$contactIDs) {
- $chunks = &$this->splitContactIDs($contactIDs);
+ $chunks = & $this->splitContactIDs($contactIDs);
$additionalContactIDs = array();
}
function run($fileName,
- $lastExportTime = NULL,
- $discoverContacts = FALSE
+ $lastExportTime = NULL,
+ $discoverContacts = FALSE
) {
$this->_discoverContacts = $discoverContacts;
}
- $dao = &CRM_Core_DAO::executeQuery($sql);
+ $dao = & CRM_Core_DAO::executeQuery($sql);
$contactIDs = array();
while ($dao->fetch()) {