public function testCreateCustomValue()
{
$this->_populateOptionAndCustomGroup();
$customFieldDataType = CRM_Core_BAO_CustomField::dataType();
$dataToHtmlTypes = CRM_Core_BAO_CustomField::dataToHtml();
$count = 0;
foreach ($customFieldDataType as $dataType => $label) {
switch ($dataType) {
case 'Country':
case 'StateProvince':
$this->foreignKeyChecksOff();
case 'String':
case 'Link':
case 'Int':
case 'Float':
case 'Money':
case 'Date':
case 'Boolean':
//Based on the custom field data-type choose desired SQL operators(to test with) and basic $type
if (in_array($dataType, array('String', 'Link'))) {
$validSQLOperators = array('=', '!=', 'IN', 'NOT IN', 'LIKE', 'NOT LIKE', 'IS NOT NULL', 'IS NULL');
$type = 'string';
} elseif ($dataType == 'Boolean') {
$validSQLOperators = array('=', '!=', 'IS NOT NULL', 'IS NULL');
$type = 'boolean';
} else {
if ($dataType == 'Country') {
$type = 'country';
} elseif ($dataType == 'StateProvince') {
$type = 'state_province';
} elseif ($dataType == 'ContactReference') {
$type = 'contact';
} elseif ($dataType == 'Date') {
$type = 'date';
} else {
$type = $dataType == 'Int' ? 'integer' : 'number';
}
$validSQLOperators = array('=', '!=', 'IN', 'NOT IN', '<=', '>=', '>', '<', 'IS NOT NULL', 'IS NULL');
}
//Create custom field of $dataType and html-type $html
foreach ($dataToHtmlTypes[$count] as $html) {
$params = array('custom_group_id' => $this->ids[$type]['custom_group_id'], 'label' => "{$dataType} - {$html}", 'data_type' => $dataType, 'html_type' => $html, 'default_value' => NULL);
if (!in_array($html, array('Text', 'TextArea')) && !in_array($dataType, array('Link', 'Date', 'ContactReference', 'Boolean'))) {
$params += array('option_group_id' => $this->optionGroup[$type]['id']);
}
$customField = $this->customFieldCreate($params);
//Now test with $validSQLOperator SQL operators against its custom value(s)
$this->_testCustomValue($customField['values'][$customField['id']], $validSQLOperators, $type);
}
$count++;
break;
default:
// skipping File data-type
$count++;
break;
}
}
}
public function testCreateCustomValue()
{
$customFieldDataType = CRM_Core_BAO_CustomField::dataType();
$dataToHtmlTypes = CRM_Core_BAO_CustomField::dataToHtml();
$count = 0;
foreach ($customFieldDataType as $dataType => $label) {
switch ($dataType) {
case 'Date':
case 'StateProvince':
case 'String':
case 'Link':
case 'Int':
case 'Float':
case 'Money':
if (in_array($dataType, array('String', 'Link'))) {
$validSQLOperator = array('=', '!=', 'IN', 'NOT IN', 'LIKE', 'NOT LIKE', 'IS NOT NULL', 'IS NULL');
$type = 'string';
} else {
if ($dataType == 'Country') {
$type == 'country';
} elseif ($dataType == 'StateProvince') {
$type = 'state_province';
} elseif ($dataType == 'ContactReference') {
$type = 'contact';
} elseif ($dataType == 'Date') {
$type = 'date';
} else {
$type = $dataType == 'Int' ? 'integer' : 'number';
}
$validSQLOperator = array('=', '!=', 'IN', 'NOT IN', '<=', '>=', '>', '<', 'IS NOT NULL', 'IS NULL');
}
foreach ($dataToHtmlTypes[$count] as $html) {
$params = array('custom_group_id' => $this->ids[$type]['custom_group_id'], 'label' => "{$dataType} - {$html}", 'data_type' => $dataType, 'html_type' => $html, 'default_value' => NULL);
if (!in_array($html, array('Text', 'TextArea')) && !in_array($dataType, array('Link', 'Date', 'ContactReference'))) {
$params += array('option_group_id' => $this->optionGroup[$type]['id']);
}
$customField = $this->customFieldCreate($params);
$this->_testCustomValue($customField['values'][$customField['id']], $validSQLOperator, $type);
}
$count++;
break;
default:
//TODO: Test case of Country fields remain as it throws foreign key contraint ONLY in test environment
$count++;
break;
}
}
}
/**
* Function to set variables up before form is built
*
* @param null
*
* @return void
* @access public
*/
public function preProcess()
{
if (!self::$_dataTypeKeys) {
self::$_dataTypeKeys = array_keys(CRM_Core_BAO_CustomField::dataType());
self::$_dataTypeValues = array_values(CRM_Core_BAO_CustomField::dataType());
}
if (!self::$_dataToHTML) {
self::$_dataToHTML = CRM_Core_BAO_CustomField::dataToHtml();
}
//custom group id
$this->_gid = CRM_Utils_Request::retrieve('gid', 'Positive', $this);
if ($isReserved = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomGroup', $this->_gid, 'is_reserved', 'id')) {
CRM_Core_Error::fatal("You cannot add or edit fields in a reserved custom field-set.");
}
if ($this->_gid) {
$url = CRM_Utils_System::url('civicrm/admin/custom/group/field', "reset=1&action=browse&gid={$this->_gid}");
$session = CRM_Core_Session::singleton();
$session->pushUserContext($url);
}
//custom field id
$this->_id = CRM_Utils_Request::retrieve('id', 'Positive', $this);
//get the values form db if update.
$this->_values = array();
if ($this->_id) {
$params = array('id' => $this->_id);
CRM_Core_BAO_CustomField::retrieve($params, $this->_values);
// note_length is an alias for the text_length field
$this->_values['note_length'] = CRM_Utils_Array::value('text_length', $this->_values);
}
if (self::$_dataToLabels == NULL) {
self::$_dataToLabels = array(array('Text' => ts('Text'), 'Select' => ts('Select'), 'Radio' => ts('Radio'), 'CheckBox' => ts('CheckBox'), 'Multi-Select' => ts('Multi-Select'), 'AdvMulti-Select' => ts('Advanced Multi-Select'), 'Autocomplete-Select' => ts('Autocomplete Select')), array('Text' => ts('Text'), 'Select' => ts('Select'), 'Radio' => ts('Radio')), array('Text' => ts('Text'), 'Select' => ts('Select'), 'Radio' => ts('Radio')), array('Text' => ts('Text'), 'Select' => ts('Select'), 'Radio' => ts('Radio')), array('TextArea' => ts('TextArea'), 'RichTextEditor' => 'RichTextEditor'), array('Date' => ts('Select Date')), array('Radio' => ts('Radio')), array('StateProvince' => ts('Select State/Province'), 'Multi-Select' => ts('Multi-Select State/Province')), array('Country' => ts('Select Country'), 'Multi-Select' => ts('Multi-Select Country ')), array('File' => ts('Select File')), array('Link' => ts('Link')), array('ContactReference' => ts('Autocomplete Select')));
}
}
/**
* Check for Each data type: loop through available form input types
*/
public function testCustomFieldCreateAllAvailableFormInputs()
{
$gid = $this->customGroupCreate(array('extends' => 'Individual', 'title' => 'testAllFormInputs'));
$dtype = CRM_Core_BAO_CustomField::dataType();
$htype = CRM_Core_BAO_CustomField::dataToHtml();
$n = 0;
foreach ($dtype as $dkey => $dvalue) {
foreach ($htype[$n] as $hkey => $hvalue) {
//echo $dkey."][".$hvalue."\n";
$this->_loopingCustomFieldCreateTest($this->_buildParams($gid['id'], $hvalue, $dkey));
}
$n++;
}
}
public function testCreateCustomValue()
{
$this->_populateOptionAndCustomGroup();
$customFieldDataType = CRM_Core_BAO_CustomField::dataType();
$dataToHtmlTypes = CRM_Core_BAO_CustomField::dataToHtml();
$count = 0;
$optionSupportingHTMLTypes = array('Select', 'Radio', 'CheckBox', 'AdvMulti-Select', 'Autocomplete-Select', 'Multi-Select');
foreach ($customFieldDataType as $dataType => $label) {
switch ($dataType) {
// case 'Country':
// case 'StateProvince':
case 'String':
case 'Link':
case 'Int':
case 'Float':
case 'Money':
case 'Date':
case 'Boolean':
//Based on the custom field data-type choose desired SQL operators(to test with) and basic $type
if (in_array($dataType, array('String', 'Link'))) {
$validSQLOperators = array('=', '!=', 'IN', 'NOT IN', 'LIKE', 'NOT LIKE', 'IS NOT NULL', 'IS NULL');
$type = 'string';
} elseif ($dataType == 'Boolean') {
$validSQLOperators = array('=', '!=', 'IS NOT NULL', 'IS NULL');
$type = 'boolean';
} else {
if ($dataType == 'Country') {
$type = 'country';
} elseif ($dataType == 'StateProvince') {
$type = 'state_province';
} elseif ($dataType == 'ContactReference') {
$type = 'contact';
} elseif ($dataType == 'Date') {
$type = 'date';
} else {
$type = $dataType == 'Int' ? 'integer' : 'number';
}
$validSQLOperators = array('=', '!=', 'IN', 'NOT IN', '<=', '>=', '>', '<', 'IS NOT NULL', 'IS NULL');
}
//Create custom field of $dataType and html-type $html
foreach ($dataToHtmlTypes[$count] as $html) {
// per CRM-18568 the like operator does not currently work for fields with options.
// the LIKE operator could potentially bypass ACLs (as could IS NOT NULL) and some thought needs to be given
// to it.
if (in_array($html, $optionSupportingHTMLTypes)) {
$validSQLOperators = array_diff($validSQLOperators, array('LIKE', 'NOT LIKE'));
}
$params = array('custom_group_id' => $this->ids[$type]['custom_group_id'], 'label' => "{$dataType} - {$html}", 'data_type' => $dataType, 'html_type' => $html, 'default_value' => NULL);
if (!in_array($html, array('Text', 'TextArea')) && !in_array($dataType, array('Link', 'Date', 'ContactReference', 'Boolean'))) {
$params += array('option_group_id' => $this->optionGroup[$type]['id']);
}
$customField = $this->customFieldCreate($params);
//Now test with $validSQLOperator SQL operators against its custom value(s)
$this->_testCustomValue($customField['values'][$customField['id']], $validSQLOperators, $type);
}
$count++;
break;
default:
// skipping File data-type & state province due to caching issues
$count++;
break;
}
}
}
