PHP CRM_Core_BAO_CustomGroup::createTable方法代码示例

 function createGroup($group, $extends = null, $isMultiple = false)
 {
     if (empty($group)) {
         $group = array('title' => 'Test_Group', 'name' => 'test_group', 'extends' => $extends, 'style' => 'Inline', 'is_multiple' => $isMultiple, 'is_active' => 1);
     }
     require_once 'CRM/Core/BAO/CustomGroup.php';
     require_once 'CRM/Utils/String.php';
     $customGroupBAO =& new CRM_Core_BAO_CustomGroup();
     $customGroupBAO->copyValues($group);
     $customGroup = $customGroupBAO->save();
     $customGroup->table_name = "civicrm_value_" . strtolower(CRM_Utils_String::munge($group['title'], '_', 32));
     $customGroup->table_name = $customGroup->table_name . '_' . $customGroup->id;
     $customGroup = $customGroupBAO->save();
     $customTable = CRM_Core_BAO_CustomGroup::createTable($customGroup);
     return $customGroup;
 }

 /**
  * @param $xml
  * @param $idMap
  */
 public function customGroups(&$xml, &$idMap)
 {
     foreach ($xml->CustomGroups as $customGroupsXML) {
         foreach ($customGroupsXML->CustomGroup as $customGroupXML) {
             $customGroup = new CRM_Core_DAO_CustomGroup();
             if (!$this->copyData($customGroup, $customGroupXML, TRUE, 'name')) {
                 $idMap['custom_group'][$customGroup->name] = $customGroup->id;
                 continue;
             }
             $saveAgain = FALSE;
             if (!isset($customGroup->table_name) || empty($customGroup->table_name)) {
                 // fix table name
                 $customGroup->table_name = "civicrm_value_" . strtolower(CRM_Utils_String::munge($customGroup->title, '_', 32)) . "_{$customGroup->id}";
                 $saveAgain = TRUE;
             }
             // fix extends stuff if it exists
             if (isset($customGroupXML->extends_entity_column_value_option_group) && isset($customGroupXML->extends_entity_column_value)) {
                 $valueIDs = array();
                 $optionValues = explode(",", $customGroupXML->extends_entity_column_value);
                 $optValues = implode("','", $optionValues);
                 if (trim($customGroup->extends) != 'Participant') {
                     if ($customGroup->extends == 'Relationship') {
                         foreach ($optionValues as $key => $value) {
                             $relTypeId = CRM_Core_DAO::getFieldValue('CRM_Contact_BAO_RelationshipType', $value, 'id', 'name_a_b');
                             $valueIDs[] = $relTypeId;
                         }
                     } elseif (in_array($customGroup->extends, array('Individual', 'Organization', 'Household'))) {
                         $valueIDs = $optionValues;
                     } else {
                         $sql = "\nSELECT     v.value\nFROM       civicrm_option_value v\nINNER JOIN civicrm_option_group g ON g.id = v.option_group_id\nWHERE      g.name = %1\nAND        v.name IN ('{$optValues}')\n";
                         $params = array(1 => array((string) $customGroupXML->extends_entity_column_value_option_group, 'String'));
                         $dao =& CRM_Core_DAO::executeQuery($sql, $params);
                         while ($dao->fetch()) {
                             $valueIDs[] = $dao->value;
                         }
                     }
                     if (!empty($valueIDs)) {
                         $customGroup->extends_entity_column_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $valueIDs) . CRM_Core_DAO::VALUE_SEPARATOR;
                         unset($valueIDs);
                         // Note: No need to set extends_entity_column_id here.
                         $saveAgain = TRUE;
                     }
                 } else {
                     // when custom group extends 'Participant'
                     $sql = "\nSELECT     v.value\nFROM       civicrm_option_value v\nINNER JOIN civicrm_option_group g ON g.id = v.option_group_id\nWHERE      g.name = 'custom_data_type'\nAND        v.name = %1\n";
                     $params = array(1 => array((string) $customGroupXML->extends_entity_column_value_option_group, 'String'));
                     $valueID = (int) CRM_Core_DAO::singleValueQuery($sql, $params);
                     if ($valueID) {
                         $customGroup->extends_entity_column_id = $valueID;
                     }
                     $optionIDs = array();
                     switch ($valueID) {
                         case 1:
                             // ParticipantRole
                             $condition = "AND v.name IN ( '{$optValues}' )";
                             $optionIDs = CRM_Core_OptionGroup::values('participant_role', FALSE, FALSE, FALSE, $condition, 'name');
                             break;
                         case 2:
                             // ParticipantEventName
                             $condition = "( is_template IS NULL OR is_template != 1 ) AND title IN( '{$optValues}' )";
                             $optionIDs = CRM_Event_PseudoConstant::event(NULL, FALSE, $condition);
                             break;
                         case 3:
                             // ParticipantEventType
                             $condition = "AND v.name IN ( '{$optValues}' )";
                             $optionIDs = CRM_Core_OptionGroup::values('event_type', FALSE, FALSE, FALSE, $condition, 'name');
                             break;
                     }
                     if (is_array($optionIDs) && !empty($optionIDs)) {
                         $customGroup->extends_entity_column_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, array_keys($optionIDs)) . CRM_Core_DAO::VALUE_SEPARATOR;
                         $saveAgain = TRUE;
                     }
                 }
             }
             if ($saveAgain) {
                 $customGroup->save();
             }
             CRM_Core_BAO_CustomGroup::createTable($customGroup);
             $idMap['custom_group'][$customGroup->name] = $customGroup->id;
         }
     }
 }

 function customGroups(&$xml, &$idMap)
 {
     require_once 'CRM/Core/BAO/CustomGroup.php';
     require_once 'CRM/Utils/String.php';
     foreach ($xml->CustomGroups as $customGroupsXML) {
         foreach ($customGroupsXML->CustomGroup as $customGroupXML) {
             $customGroup = new CRM_Core_DAO_CustomGroup();
             if (!$this->copyData($customGroup, $customGroupXML, true, 'name')) {
                 $idMap['custom_group'][$customGroup->name] = $customGroup->id;
                 continue;
             }
             $saveAgain = false;
             if (!isset($customGroup->table_name) || empty($customGroup->table_name)) {
                 // fix table name
                 $customGroup->table_name = "civicrm_value_" . strtolower(CRM_Utils_String::munge($customGroup->title, '_', 32)) . "_{$customGroup->id}";
                 $saveAgain = true;
             }
             // fix extends stuff if it exists
             if (isset($customGroupXML->extends_entity_column_value_option_group) && isset($customGroupXML->extends_entity_column_value_option_value)) {
                 $optValues = explode(",", $customGroupXML->extends_entity_column_value_option_value);
                 $optValues = implode("','", $optValues);
                 if (trim($customGroup->extends) != 'Participant') {
                     $sql = "\nSELECT     v.value\nFROM       civicrm_option_value v\nINNER JOIN civicrm_option_group g ON g.id = v.option_group_id\nWHERE      g.name = %1\nAND        v.name IN (%2)\n";
                     $params = array(1 => array((string) $customGroupXML->extends_entity_column_value_option_group, 'String'), 2 => array((string) $optValues, 'String'));
                     $dao =& CRM_Core_DAO::executeQuery($sql, $params);
                     $valueIDs = array();
                     while ($dao->fetch()) {
                         $valueIDs[] = $dao->value;
                     }
                     if (!empty($valueIDs)) {
                         $customGroup->extends_entity_column_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, $valueIDs) . CRM_Core_DAO::VALUE_SEPARATOR;
                         // Note: No need to set extends_entity_column_id here.
                         $saveAgain = true;
                     }
                 } else {
                     // when custom group extends 'Participant'
                     $sql = "\nSELECT     v.value\nFROM       civicrm_option_value v\nINNER JOIN civicrm_option_group g ON g.id = v.option_group_id\nWHERE      g.name = 'custom_data_type'\nAND        v.name = %1\n";
                     $params = array(1 => array((string) $customGroupXML->extends_entity_column_value_option_group, 'String'));
                     $valueID = (int) CRM_Core_DAO::singleValueQuery($sql, $params);
                     if ($valueID) {
                         $customGroup->extends_entity_column_id = $valueID;
                     }
                     $optionIDs = array();
                     switch ($valueID) {
                         case 1:
                             // ParticipantRole
                             require_once 'CRM/Core/OptionGroup.php';
                             $condition = "AND v.name IN ( '{$optValues}' )";
                             $optionIDs = CRM_Core_OptionGroup::values('participant_role', false, false, false, $condition, 'name');
                             break;
                         case 2:
                             // ParticipantEventName
                             require_once 'CRM/Event/PseudoConstant.php';
                             $condition = "( is_template IS NULL OR is_template != 1 ) AND title IN( '{$optValues}' )";
                             $optionIDs = CRM_Event_PseudoConstant::event(null, false, $condition);
                             break;
                         case 3:
                             // ParticipantEventType
                             require_once 'CRM/Core/OptionGroup.php';
                             $condition = "AND v.name IN ( '{$optValues}' )";
                             $optionIDs = CRM_Core_OptionGroup::values('event_type', false, false, false, $condition, 'name');
                             break;
                     }
                     if (is_array($optionIDs) && !empty($optionIDs)) {
                         $customGroup->extends_entity_column_value = CRM_Core_DAO::VALUE_SEPARATOR . implode(CRM_Core_DAO::VALUE_SEPARATOR, array_keys($optionIDs)) . CRM_Core_DAO::VALUE_SEPARATOR;
                         $saveAgain = true;
                     }
                 }
             }
             if ($saveAgain) {
                 $customGroup->save();
             }
             CRM_Core_BAO_CustomGroup::createTable($customGroup);
             $idMap['custom_group'][$customGroup->name] = $customGroup->id;
         }
     }
 }

 /**
  * Function to test createTable()
  */
 function testCreateTable()
 {
     $customGrouptitle = 'My Custom Group';
     $groupParams = array('title' => $customGrouptitle, 'name' => 'my_custom_group', 'style' => 'Tab', 'extends' => 'Individual', 'is_active' => 1);
     require_once 'CRM/Core/BAO/CustomGroup.php';
     $customGroupBAO =& new CRM_Core_BAO_CustomGroup();
     $customGroupBAO->copyValues($groupParams);
     $customGroup = $customGroupBAO->save();
     $tableName = 'civicrm_value_test_group_' . $customGroup->id;
     $customGroup->table_name = $tableName;
     $customGroup = $customGroupBAO->save();
     $customTable = CRM_Core_BAO_CustomGroup::createTable($customGroup);
     $customGroupId = $customGroup->id;
     //check db for custom group.
     $dbCustomGroupTitle = $this->assertDBNotNull('CRM_Core_DAO_CustomGroup', $customGroupId, 'title', 'id', 'Database check for custom group record.');
     //check for custom group table name
     $this->assertDBCompareValue('CRM_Core_DAO_CustomGroup', $customGroupId, 'table_name', 'id', $tableName, 'Database check for custom group table name.');
     //check for group title
     $this->assertEquals($customGrouptitle, $dbCustomGroupTitle);
     //cleanup DB by deleting customGroup
     Custom::deleteGroup($customGroup);
 }

 /**
  *  Test civicrm_activity_get() with a good activity ID which
  *  has associated custom data
  */
 function testActivityGetGoodIDCustom()
 {
     //  Insert rows in civicrm_activity creating activities 4 and
     //  13
     $op = new PHPUnit_Extensions_Database_Operation_Insert();
     $op->execute($this->_dbconn, new PHPUnit_Extensions_Database_DataSet_XMLDataSet(dirname(__FILE__) . '/dataset/activity_4_13.xml'));
     //  Insert rows in civicrm_custom_group and civicrm_custom_field
     //  creating Activity Custom to extend activity type 5
     $op = new PHPUnit_Extensions_Database_Operation_Insert();
     $op->execute($this->_dbconn, new PHPUnit_Extensions_Database_DataSet_FlatXMLDataSet(dirname(__FILE__) . '/dataset/custom_group_activity_type_5.xml'));
     //  Drop and create table civicrm_value_activity_custom_9
     $query = 'DROP TABLE IF EXISTS civicrm_value_activity_custom_9';
     AllTests::$utils->do_query($query);
     $group = new CRM_Core_DAO_CustomGroup();
     $group->extends = "Activity";
     $group->table_name = 'civicrm_value_activity_custom_9';
     $group->is_multiple = 0;
     $group->is_active = 1;
     CRM_Core_BAO_CustomGroup::createTable($group);
     //  Add column activity_custom_11 to the custom table
     $customField =& new CRM_Core_DAO_CustomField();
     $customField->column_name = 'activity_custom_11';
     $customField->custom_group_id = 9;
     $customField->is_required = 0;
     $customField->is_active = 1;
     $customField->data_type = 'String';
     $customField->text_length = 255;
     CRM_Core_BAO_CustomField::createField($customField, 'add');
     //  Insert a test value into the new table
     $query = "INSERT INTO civicrm_value_activity_custom_9" . "( entity_id, activity_custom_11 )" . " VALUES ( 4,  'bite my test data' )";
     AllTests::$utils->do_query($query);
     //  Retrieve the test value
     $params = array('activity_id' => 4, 'activity_type_id' => 5);
     $result = civicrm_activity_get($params, true);
     $this->assertEquals(0, $result['is_error'], "Error message: " . $result['error_message']);
     $this->assertEquals(4, $result['result']['id'], 'In line ' . __LINE__);
     $this->assertEquals(17, $result['result']['source_contact_id'], 'In line ' . __LINE__);
     $this->assertEquals(5, $result['result']['activity_type_id'], 'In line ' . __LINE__);
     $this->assertEquals('test activity type id', $result['result']['subject'], 'In line ' . __LINE__);
     $this->assertEquals('bite my test data', $result['result']['custom_11_1'], 'In line ' . __LINE__);
 }

 /**
  * Test createTable()
  */
 public function testCreateTable()
 {
     $groupParams = array('title' => 'My Custom Group', 'name' => 'my_custom_group', 'style' => 'Tab', 'extends' => 'Individual', 'is_active' => 1, 'version' => 3);
     $customGroupBAO = new CRM_Core_BAO_CustomGroup();
     $customGroupBAO->copyValues($groupParams);
     $customGroup = $customGroupBAO->save();
     $tableName = 'civicrm_value_test_group_' . $customGroup->id;
     $customGroup->table_name = $tableName;
     $customGroup = $customGroupBAO->save();
     CRM_Core_BAO_CustomGroup::createTable($customGroup);
     $customGroupId = $customGroup->id;
     //check db for custom group.
     $dbCustomGroupTitle = $this->assertDBNotNull('CRM_Core_DAO_CustomGroup', $customGroupId, 'title', 'id', 'Database check for custom group record.');
     //check for custom group table name
     $this->assertDBCompareValue('CRM_Core_DAO_CustomGroup', $customGroupId, 'table_name', 'id', $tableName, 'Database check for custom group table name.');
     $this->customGroupDelete($customGroup->id);
 }

 function customGroups(&$xml, &$idMap)
 {
     require_once 'CRM/Core/BAO/CustomGroup.php';
     require_once 'CRM/Utils/String.php';
     foreach ($xml->CustomGroups as $customGroupsXML) {
         foreach ($customGroupsXML->CustomGroup as $customGroupXML) {
             $customGroup = new CRM_Core_DAO_CustomGroup();
             $this->copyData($customGroup, $customGroupXML, true);
             // fix table name
             $customGroup->table_name = "civicrm_value_" . strtolower(CRM_Utils_String::munge($customGroup->title, '_', 32)) . "_{$customGroup->id}";
             $customGroup->save();
             CRM_Core_BAO_CustomGroup::createTable($customGroup);
             $idMap['custom_group'][$customGroup->title] = $customGroup->id;
         }
     }
 }