const XML_VALUE_SEPARATOR = ":;:;:;";
+ /**
+ * @var array description of export field mapping
+ *
+ * @code
+ * 'exampleEntityMappingName' => array(
+ * 'data' => array(), // placeholder; this will get filled-in during execution
+ * 'name' => 'CustomGroup', // per-item XML tag name
+ * 'scope' => 'CustomGroups', // container XML tag name
+ * 'required' => FALSE, // whether we *must* find records of this type
+ * 'idNameFields' => array('id', 'name'), // name of the (local/autogenerated) "id" and (portable) "name" columns
+ * 'idNameMap' => array(), // placeholder; this will get filled-in during execution
+ * ),
+ * @endcode
+ */
protected $_xml;
function __construct() {
$optionGroups = "( 'activity_type', 'event_type', 'mapping_type' )";
$sql = "
-SELECT distinct(g.id), g.*
-FROM civicrm_option_group g
-WHERE g.name IN $optionGroups
-";
+ SELECT distinct(g.id), g.*
+ FROM civicrm_option_group g
+ WHERE g.name IN $optionGroups
+ ";
$this->fetch('optionGroup', 'CRM_Core_DAO_OptionGroup', $sql);
$sql = "
-SELECT distinct(g.id), g.*
-FROM civicrm_option_group g,
- civicrm_custom_field f,
- civicrm_custom_group cg
-WHERE f.option_group_id = g.id
-AND f.custom_group_id = cg.id
-AND cg.is_active = 1
-";
+ SELECT distinct(g.id), g.*
+ FROM civicrm_option_group g,
+ civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE f.option_group_id = g.id
+ AND f.custom_group_id = cg.id
+ AND cg.is_active = 1
+ ";
$this->fetch('optionGroup', 'CRM_Core_DAO_OptionGroup', $sql);
$sql = "
-SELECT v.*, g.name as prefix
-FROM civicrm_option_value v,
- civicrm_option_group g
-WHERE v.option_group_id = g.id
-AND g.name IN $optionGroups
-";
+ SELECT v.*, g.name as prefix
+ FROM civicrm_option_value v,
+ civicrm_option_group g
+ WHERE v.option_group_id = g.id
+ AND g.name IN $optionGroups
+ ";
$this->fetch('optionValue', 'CRM_Core_DAO_OptionValue', $sql);
$sql = "
-SELECT distinct(v.id), v.*, g.name as prefix
-FROM civicrm_option_value v,
- civicrm_option_group g,
- civicrm_custom_field f,
- civicrm_custom_group cg
-WHERE v.option_group_id = g.id
-AND f.option_group_id = g.id
-AND f.custom_group_id = cg.id
-AND cg.is_active = 1
-";
+ SELECT distinct(v.id), v.*, g.name as prefix
+ FROM civicrm_option_value v,
+ civicrm_option_group g,
+ civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE v.option_group_id = g.id
+ AND f.option_group_id = g.id
+ AND f.custom_group_id = cg.id
+ AND cg.is_active = 1
+ ";
$this->fetch('optionValue', 'CRM_Core_DAO_OptionValue', $sql);
$sql = "
-SELECT rt.*
-FROM civicrm_relationship_type rt
-WHERE rt.is_active = 1
-";
+ SELECT rt.*
+ FROM civicrm_relationship_type rt
+ WHERE rt.is_active = 1
+ ";
$this->fetch('relationshipType', 'CRM_Contact_DAO_RelationshipType', $sql);
$sql = "
-SELECT lt.*
-FROM civicrm_location_type lt
-WHERE lt.is_active = 1
-";
+ SELECT lt.*
+ FROM civicrm_location_type lt
+ WHERE lt.is_active = 1
+ ";
$this->fetch('locationType', 'CRM_Core_DAO_LocationType', $sql);
$sql = "
-SELECT cg.*
-FROM civicrm_custom_group cg
-WHERE cg.is_active = 1
-";
+ SELECT cg.*
+ FROM civicrm_custom_group cg
+ WHERE cg.is_active = 1
+ ";
$this->fetch('customGroup', 'CRM_Core_DAO_CustomGroup', $sql);
$sql = "
-SELECT f.*
-FROM civicrm_custom_field f,
- civicrm_custom_group cg
-WHERE f.custom_group_id = cg.id
-AND cg.is_active = 1
-";
+ SELECT f.*
+ FROM civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE f.custom_group_id = cg.id
+ AND cg.is_active = 1
+ ";
$this->fetch('customField', 'CRM_Core_DAO_CustomField', $sql);
$this->fetch('profileGroup', 'CRM_Core_DAO_UFGroup');
$this->fetch('profileField', 'CRM_Core_DAO_UFField');
$sql = "
-SELECT *
-FROM civicrm_uf_join
-WHERE entity_table IS NULL
-AND entity_id IS NULL
-";
+ SELECT *
+ FROM civicrm_uf_join
+ WHERE entity_table IS NULL
+ AND entity_id IS NULL
+ ";
$this->fetch('profileJoin', 'CRM_Core_DAO_UFJoin', $sql);
$this->fetch('mappingGroup', 'CRM_Core_DAO_Mapping');
$this->fetch('mappingField', 'CRM_Core_DAO_MappingField');
}
+ /**
+ * @param array $customGroupIds list of custom groups to export
+ * @return void
+ */
+ function buildCustomGroups($customGroupIds) {
+ $customGroupIdsSql = implode(',', array_filter($customGroupIds, 'is_numeric'));
+ if (empty($customGroupIdsSql)) {
+ return;
+ }
+
+ $sql = "
+ SELECT distinct(g.id), g.*
+ FROM civicrm_option_group g,
+ civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE f.option_group_id = g.id
+ AND f.custom_group_id = cg.id
+ AND cg.id in ($customGroupIdsSql)
+ ";
+ $this->fetch('optionGroup', 'CRM_Core_DAO_OptionGroup', $sql);
+
+ $sql = "
+ SELECT distinct(v.id), v.*, g.name as prefix
+ FROM civicrm_option_value v,
+ civicrm_option_group g,
+ civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE v.option_group_id = g.id
+ AND f.option_group_id = g.id
+ AND f.custom_group_id = cg.id
+ AND cg.id in ($customGroupIdsSql)
+ ";
+
+ $this->fetch('optionValue', 'CRM_Core_DAO_OptionValue', $sql);
+
+ $sql = "
+ SELECT cg.*
+ FROM civicrm_custom_group cg
+ WHERE cg.id in ($customGroupIdsSql)
+
+ ";
+ $this->fetch('customGroup', 'CRM_Core_DAO_CustomGroup', $sql);
+
+ $sql = "
+ SELECT f.*
+ FROM civicrm_custom_field f,
+ civicrm_custom_group cg
+ WHERE f.custom_group_id = cg.id
+ AND cg.id in ($customGroupIdsSql)
+ ";
+ $this->fetch('customField', 'CRM_Core_DAO_CustomField', $sql);
+ }
+
/**
* Render the in-memory representation as XML
*
return $buffer;
}
+ /**
+ * Generate an array-tree representation of the exported elements.
+ *
+ * @return array
+ */
+ function toArray() {
+ $result = array();
+ foreach (array_keys($this->_xml) as $key) {
+ if (!empty($this->_xml[$key]['data'])) {
+ $result[ $this->_xml[$key]['name'] ] = array_values($this->_xml[$key]['data']);
+ }
+ }
+ return $result;
+ }
+
function fetch($groupName, $daoName, $sql = NULL) {
$idNameFields = isset($this->_xml[$groupName]['idNameFields']) ? $this->_xml[$groupName]['idNameFields'] : NULL;
$mappedFields = isset($this->_xml[$groupName]['mappedFields']) ? $this->_xml[$groupName]['mappedFields'] : NULL;
}
while ($dao->fetch()) {
- $this->_xml[$groupName]['data'][] = $this->exportDAO($this->_xml[$groupName]['name'], $dao, $mappedFields);
+ $this->_xml[$groupName]['data'][$dao->id] = $this->exportDAO($this->_xml[$groupName]['name'], $dao, $mappedFields);
if ($idNameFields) {
// index the id/name fields so that we can translate from FK ids to FK names
if (isset($idNameFields[2])) {