public function uninstall()
{
Utils_RecordBrowserCommon::delete_record_field('company', 'County');
Utils_RecordBrowserCommon::delete_record_field('contact', 'County');
Utils_RecordBrowserCommon::delete_record_field('contact', 'Home County');
return true;
}
<?php
defined("_VALID_ACCESS") || die('Direct access forbidden');
if (DB::GetOne('SELECT 1 FROM utils_attachment_field WHERE field=%s', array('Date'))) {
Utils_RecordBrowserCommon::new_record_field('utils_attachment', array('name' => _M('Edited on'), 'type' => 'timestamp', 'extra' => false, 'visible' => true, 'required' => false, 'display_callback' => array('Utils_AttachmentCommon', 'display_date'), 'QFfield_callback' => array('Utils_AttachmentCommon', 'QFfield_date'), 'position' => 'Date'));
DB::Execute('UPDATE utils_attachment_data_1 SET f_edited_on=f_date');
Utils_RecordBrowserCommon::delete_record_field('utils_attachment', 'Date');
Utils_RecordBrowserCommon::wipe_access('utils_attachment');
Utils_RecordBrowserCommon::add_access('utils_attachment', 'view', 'ACCESS:employee', array('(!permission' => 2, '|:Created_by' => 'USER_ID'));
Utils_RecordBrowserCommon::add_access('utils_attachment', 'delete', 'ACCESS:employee', array(':Created_by' => 'USER_ID'));
Utils_RecordBrowserCommon::add_access('utils_attachment', 'delete', array('ACCESS:employee', 'ACCESS:manager'));
Utils_RecordBrowserCommon::add_access('utils_attachment', 'add', 'ACCESS:employee', array(), array('edited_on'));
Utils_RecordBrowserCommon::add_access('utils_attachment', 'edit', 'ACCESS:employee', array('(permission' => 0, '|:Created_by' => 'USER_ID'), array('edited_on'));
}
public function view_field($action = 'add', $field = null) {
if (!$action) $action = 'add';
if ($this->is_back()) return false;
if ($this->check_for_jump()) return;
$data_type = array(
'autonumber'=>__('Autonumber'),
'currency'=>__('Currency'),
'checkbox'=>__('Checkbox'),
'date'=>__('Date'),
'time' => __('Time'),
'timestamp' => __('Timestamp'),
'integer'=>__('Integer'),
'float'=>__('Float'),
'text'=>__('Text'),
'long text'=>__('Long text'),
'select'=>__('Select field')
);
natcasesort($data_type);
load_js('modules/Utils/RecordBrowser/js/field_admin.js');
$form = $this->init_module('Libs/QuickForm');
switch ($action) {
case 'add': $form->addElement('header', null, __('Add new field'));
break;
case 'edit': $form->addElement('header', null, __('Edit field properties'));
break;
}
$form->addElement('text', 'field', __('Field'), array('maxlength'=>32));
$form->registerRule('check_if_column_exists', 'callback', 'check_if_column_exists', $this);
$this->current_field = $field;
$form->registerRule('check_if_no_id', 'callback', 'check_if_no_id', $this);
$form->addRule('field', __('Field required'), 'required');
$form->addRule('field', __('Field with this name already exists.'), 'check_if_column_exists');
$form->addRule('field', __('Field length cannot be over 32 characters.'), 'maxlength', 32);
$form->addRule('field', __('Invalid field name.'), 'regex', '/^[a-zA-Z][a-zA-Z \(\)\%0-9]*$/');
$form->addRule('field', __('Invalid field name.'), 'check_if_no_id');
$form->addElement('text', 'caption', __('Caption'), array('maxlength'=>255, 'placeholder' => __('Leave empty to use default label')));
if ($action=='edit') {
$row = DB::GetRow('SELECT field, caption, type, visible, required, param, filter, export, tooltip, extra, position FROM '.$this->tab.'_field WHERE field=%s',array($field));
switch ($row['type']) {
case 'select':
$row['select_data_type'] = 'select';
$row['select_type'] = 'select';
$row['data_source'] = 'rset';
$ref = explode(';', $row['param']);
$refe = explode('::',$ref[0]);
$row['rset'] = array_filter(explode(',',$refe[0]));
$row['label_field'] = isset($refe[1]) ? str_replace('|', ',', $refe[1]) : '';
break;
case 'multiselect':
$row['select_data_type'] = 'select';
$row['select_type'] = 'multiselect';
$ref = explode(';', $row['param']);
$refe = explode('::',$ref[0]);
$tab = $refe[0];
if ($tab=='__COMMON__') {
$row['data_source'] = 'commondata';
$order = isset($refe[2])?$refe[2]:'value';
$row['order_by'] = ($order=='key'?'key':'value');
$row['commondata_table'] = $refe[1];
} else {
$row['label_field'] = '';
if (isset($refe[1]))
$row['label_field'] = str_replace('|', ',', $refe[1]);
$row['data_source'] = 'rset';
$row['rset'] = array_filter(explode(',',$tab));
}
break;
case 'commondata':
$row['select_data_type'] = 'select';
$row['select_type'] = 'select';
$row['data_source'] = 'commondata';
$param = Utils_RecordBrowserCommon::decode_commondata_param($row['param']);
$form->setDefaults(array('order_by'=>$param['order_by_key']?'key':'value', 'commondata_table'=>$param['array_id']));
break;
case 'autonumber':
$row['select_data_type'] = 'autonumber';
Utils_RecordBrowserCommon::decode_autonumber_param($row['param'], $autonumber_prefix, $autonumber_pad_length, $autonumber_pad_mask);
$row['autonumber_prefix'] = $autonumber_prefix;
$row['autonumber_pad_length'] = $autonumber_pad_length;
$row['autonumber_pad_mask'] = $autonumber_pad_mask;
break;
case 'text':
$row['select_data_type'] = $row['type'];
$row['text_length'] = $row['param'];
break;
case 'time':
case 'timestamp':
$row['select_data_type'] = $row['type'];
$row['minute_increment'] = $row['param'];
break;
default:
$row['select_data_type'] = $row['type'];
if (!isset($data_type[$row['type']]))
$data_type[$row['type']] = _V(ucfirst($row['type'])); // ****** - field type
}
if (!isset($row['rset'])) $row['rset'] = array('contact');
if (!isset($row['data_source'])) $row['data_source'] = 'commondata';
$form->setDefaults($row);
$selected_data = $row['type'];
$this->admin_field_type = $row['select_data_type'];
$this->admin_field = $row;
} else {
$selected_data = $form->exportValue('select_data_type');
$form->setDefaults(array('visible'=>1,
'autonumber_prefix'=>'#',
'autonumber_pad_length'=>'6',
'autonumber_pad_mask'=>'0'));
}
$this->admin_field_mode = $action;
$this->admin_field_name = $field;
$form->addElement('select', 'select_data_type', __('Data Type'), $data_type, array('id'=>'select_data_type', 'onchange'=>'RB_hide_form_fields()'));
$form->addElement('text', 'text_length', __('Maximum Length'), array('id'=>'length'));
$minute_increment_values = array(1=>1,2=>2,5=>5,10=>10,15=>15,20=>20,30=>30,60=>__('Full hours'));
$form->addElement('select', 'minute_increment', __('Minutes Interval'), $minute_increment_values, array('id'=>'minute_increment'));
$form->addElement('select', 'data_source', __('Source of Data'), array('rset'=>__('Recordset'), 'commondata'=>__('CommonData')), array('id'=>'data_source', 'onchange'=>'RB_hide_form_fields()'));
$form->addElement('select', 'select_type', __('Type'), array('select'=>__('Single value selection'), 'multiselect'=>__('Multiple values selection')), array('id'=>'select_type'));
$form->addElement('select', 'order_by', __('Order by'), array('key'=>__('Key'), 'value'=>__('Value')), array('id'=>'order_by'));
$form->addElement('text', 'commondata_table', __('CommonData table'), array('id'=>'commondata_table'));
$tables = Utils_RecordBrowserCommon::list_installed_recordsets();
asort($tables);
$form->addElement('multiselect', 'rset', '<span id="rset_label">'.__('Recordset').'</span>', $tables, array('id'=>'rset'));
$form->addElement('text', 'label_field', __('Related field(s)'), array('id'=>'label_field'));
$form->addFormRule(array($this, 'check_field_definitions'));
$form->addElement('checkbox', 'visible', __('Table view'));
$form->addElement('checkbox', 'tooltip', __('Tooltip view'));
$form->addElement('checkbox', 'required', __('Required'), null, array('id'=>'required'));
$form->addElement('checkbox', 'filter', __('Filter enabled'), null, array('id' => 'filter'));
$form->addElement('checkbox', 'export', __('Export'));
$form->addElement('text', 'autonumber_prefix', __('Prefix string'), array('id' => 'autonumber_prefix'));
$form->addRule('autonumber_prefix', __('Double underscore is not allowed'), 'callback', array('Utils_RecordBrowser', 'qf_rule_without_double_underscore'));
$form->addElement('text', 'autonumber_pad_length', __('Pad length'), array('id' => 'autonumber_pad_length'));
$form->addRule('autonumber_pad_length', __('Only integer numbers are allowed.'), 'regex', '/^[0-9]*$/');
$form->addElement('text', 'autonumber_pad_mask', __('Pad character'), array('id' => 'autonumber_pad_mask'));
$form->addRule('autonumber_pad_mask', __('Double underscore is not allowed'), 'callback', array('Utils_RecordBrowser', 'qf_rule_without_double_underscore'));
$form->addElement('checkbox', 'advanced', __('Edit advanced properties'), null, array('onchange'=>'RB_advanced_settings()', 'id'=>'advanced'));
$form->addElement('text', 'display_callback', __('Value display function'), array('maxlength'=>255, 'style'=>'width:300px', 'id'=>'display_callback'));
$form->addElement('text', 'QFfield_callback', __('Field generator function'), array('maxlength'=>255, 'style'=>'width:300px', 'id'=>'QFfield_callback'));
if ($action=='edit') {
$form->freeze('field');
$form->freeze('select_data_type');
$form->freeze('data_source');
$form->freeze('rset');
}
if ($action=='edit') {
$display_callbacback = DB::GetOne('SELECT callback FROM '.$this->tab.'_callback WHERE freezed=1 AND field=%s', array($field));
$QFfield_callbacback = DB::GetOne('SELECT callback FROM '.$this->tab.'_callback WHERE freezed=0 AND field=%s', array($field));
$form->setDefaults(array('display_callback'=>$display_callbacback));
$form->setDefaults(array('QFfield_callback'=>$QFfield_callbacback));
}
if ($form->validate()) {
$data = $form->exportValues();
$data['caption'] = trim($data['caption']);
$data['field'] = trim($data['field']);
$type = DB::GetOne('SELECT type FROM '.$this->tab.'_field WHERE field=%s', array($field));
if (!isset($data['select_data_type'])) $data['select_data_type'] = $type;
if ($action=='add')
$field = $data['field'];
$id = preg_replace('/[^a-z0-9]/','_',strtolower($field));
$new_id = preg_replace('/[^a-z0-9]/','_',strtolower($data['field']));
if (preg_match('/^[a-z0-9_]*$/',$id)==0) trigger_error('Invalid column name: '.$field);
if (preg_match('/^[a-z0-9_]*$/',$new_id)==0) trigger_error('Invalid new column name: '.$data['field']);
$param = '';
switch ($data['select_data_type']) {
case 'autonumber':
$data['required'] = false;
$data['filter'] = false;
$param = Utils_RecordBrowserCommon::encode_autonumber_param(
$data['autonumber_prefix'],
$data['autonumber_pad_length'],
$data['autonumber_pad_mask']);
// delete field and add again later to generate values
if ($action != 'add') {
Utils_RecordBrowserCommon::delete_record_field($this->tab, $field);
$action = 'add';
$field = $data['field'];
}
break;
case 'checkbox':
$data['required'] = false;
break;
case 'text': if ($action=='add') $param = $data['text_length'];
else {
if ($data['text_length']<$row['param']) trigger_error('Invalid field length', E_USER_ERROR);
$param = $data['text_length'];
if ($data['text_length']!=$row['param']) {
if(DB::is_postgresql())
DB::Execute('ALTER TABLE '.$this->tab.'_data_1 ALTER COLUMN f_'.$id.' TYPE VARCHAR('.$param.')');
else
DB::Execute('ALTER TABLE '.$this->tab.'_data_1 MODIFY f_'.$id.' VARCHAR('.$param.')');
}
}
break;
case 'select':
if ($data['data_source']=='commondata') {
if ($data['select_type']=='select') {
$param = Utils_RecordBrowserCommon::encode_commondata_param(array('order_by_key'=>$data['order_by']=='key', 'array_id'=>$data['commondata_table']));
$data['select_data_type'] = 'commondata';
} else {
$param = '__COMMON__::'.$data['commondata_table'].'::'.$data['order_by'];
$data['select_data_type'] = 'multiselect';
}
} else {
$data['select_data_type'] = $data['select_type'];
if (!isset($row) || !isset($row['param'])) $row['param'] = ';::';
$props = explode(';', $row['param']);
$change_param = false;
if($data['rset']) {
$fs = explode(',', $data['label_field']);
if($data['label_field']) foreach($data['rset'] as $rset) {
$ret = $this->detranslate_field_names($rset, $fs);
if (!empty($ret)) trigger_error('Invalid fields: '.implode(',',$fs));
}
$data['rset'] = implode(',',$data['rset']);
$data['label_field'] = implode('|',$fs);
$change_param = true;
} else if ($action == 'add') {
$data['rset'] = '__RECORDSETS__';
$data['label_field'] = '';
$change_param = true;
}
if ($change_param) {
$props[0] = $data['rset'].'::'.$data['label_field'];
$param = implode(';', $props);
} else {
$param = $row['param'];
}
}
if (isset($row) && isset($row['type']) && $row['type']=='multiselect' && $data['select_type']=='select') {
$ret = DB::Execute('SELECT id, f_'.$id.' AS v FROM '.$this->tab.'_data_1 WHERE f_'.$id.' IS NOT NULL');
while ($rr = $ret->FetchRow()) {
$v = Utils_RecordBrowserCommon::decode_multi($rr['v']);
$v = array_pop($v);
DB::Execute('UPDATE '.$this->tab.'_data_1 SET f_'.$id.'=%s WHERE id=%d', array($v, $rr['id']));
}
}
if (isset($row) && isset($row['type']) && $row['type']!='multiselect' && $data['select_type']=='multiselect') {
if(DB::is_postgresql())
DB::Execute('ALTER TABLE '.$this->tab.'_data_1 ALTER COLUMN f_'.$id.' TYPE TEXT');
else
DB::Execute('ALTER TABLE '.$this->tab.'_data_1 MODIFY f_'.$id.' TEXT');
$ret = DB::Execute('SELECT id, f_'.$id.' AS v FROM '.$this->tab.'_data_1 WHERE f_'.$id.' IS NOT NULL');
while ($rr = $ret->FetchRow()) {
$v = Utils_RecordBrowserCommon::encode_multi($rr['v']);
DB::Execute('UPDATE '.$this->tab.'_data_1 SET f_'.$id.'=%s WHERE id=%d', array($v, $rr['id']));
}
}
break;
case 'time':
case 'timestamp':
$param = $data['minute_increment'];
break;
default: if (isset($row) && isset($row['param']))
$param = $row['param'];
break;
}
if ($action=='add') {
$id = $new_id;
if (in_array($data['select_data_type'], array('time','timestamp','currency','integer')))
$style = $data['select_data_type'];
else
$style = '';
$new_field_data = array('name' => $data['field'], 'type' => $data['select_data_type'], 'param' => $param, 'style' => $style);
if (isset($this->admin_field['position']) && $this->admin_field['position']) {
$new_field_data['position'] = (int) $this->admin_field['position'];
}
Utils_RecordBrowserCommon::new_record_field($this->tab, $new_field_data);
}
if(!isset($data['visible']) || $data['visible'] == '') $data['visible'] = 0;
if(!isset($data['required']) || $data['required'] == '') $data['required'] = 0;
if(!isset($data['filter']) || $data['filter'] == '') $data['filter'] = 0;
if(!isset($data['export']) || $data['export'] == '') $data['export'] = 0;
if(!isset($data['tooltip']) || $data['tooltip'] == '') $data['tooltip'] = 0;
foreach($data as $key=>$val)
if (is_string($val)) $data[$key] = htmlspecialchars($val);
/* DB::StartTrans();
if ($id!=$new_id) {
Utils_RecordBrowserCommon::check_table_name($this->tab);
if(DB::is_postgresql())
DB::Execute('ALTER TABLE '.$this->tab.'_data_1 RENAME COLUMN f_'.$id.' TO f_'.$new_id);
else {
$old_param = DB::GetOne('SELECT param FROM '.$this->tab.'_field WHERE field=%s', array($field));
DB::RenameColumn($this->tab.'_data_1', 'f_'.$id, 'f_'.$new_id, Utils_RecordBrowserCommon::actual_db_type($type, $old_param));
}
}*/
DB::Execute('UPDATE '.$this->tab.'_field SET caption=%s, param=%s, type=%s, field=%s, visible=%d, required=%d, filter=%d, export=%d, tooltip=%d WHERE field=%s',
array($data['caption'], $param, $data['select_data_type'], $data['field'], $data['visible'], $data['required'], $data['filter'], $data['export'], $data['tooltip'], $field));
/* DB::Execute('UPDATE '.$this->tab.'_edit_history_data SET field=%s WHERE field=%s',
array($new_id, $id));
DB::CompleteTrans();*/
DB::Execute('DELETE FROM '.$this->tab.'_callback WHERE freezed=1 AND field=%s', array($field));
if ($data['display_callback'])
DB::Execute('INSERT INTO '.$this->tab.'_callback (callback,freezed,field) VALUES (%s,1,%s)', array($data['display_callback'], $data['field']));
DB::Execute('DELETE FROM '.$this->tab.'_callback WHERE freezed=0 AND field=%s', array($field));
if ($data['QFfield_callback'])
DB::Execute('INSERT INTO '.$this->tab.'_callback (callback,freezed,field) VALUES (%s,0,%s)', array($data['QFfield_callback'], $data['field']));
$this->init(true, true);
return false;
}
$form->display_as_column();
eval_js('RB_hide_form_fields();');
eval_js('RB_advanced_confirmation = "'.Epesi::escapeJS(__('Changing these settings may often cause system unstability. Are you sure you want to see advanced settings?')).'";');
eval_js('RB_advanced_settings();');
Base_ActionBarCommon::add('save', __('Save'), $form->get_submit_form_href());
Base_ActionBarCommon::add('back', __('Cancel'), $this->create_back_href());
return true;
}
public function uninstall()
{
Utils_RecordBrowserCommon::delete_addon('company', 'CRM_Contacts_ParentCompany', 'parent_company_addon');
Utils_RecordBrowserCommon::delete_record_field('company', 'Parent Company');
return true;
}
public function delete_record_field($field_name)
{
Utils_RecordBrowserCommon::delete_record_field($this->tab, $field_name);
}
public function uninstall()
{
Utils_RecordBrowserCommon::delete_record_field('company', 'Account Manager');
Utils_RecordBrowserCommon::delete_browse_mode_details_callback('company', 'CRM/Contacts/AccountManager', 'browse_mode_details');
return true;
}
defined("_VALID_ACCESS") || die('Direct access forbidden');
$deadline_field_is_not_timestamp = !DB::GetOne('SELECT 1 FROM task_field WHERE field=%s AND type=%s', array('Deadline', 'timestamp'));
if ($deadline_field_is_not_timestamp) {
PatchUtil::db_alter_column('task_data_1', 'f_deadline', 'T');
DB::Execute('UPDATE task_field SET type=%s WHERE field=%s', array('timestamp', 'Deadline'));
}
$tab = 'task';
$field = array('name' => _M('Timeless'), 'type' => 'checkbox', 'required' => false, 'extra' => false, 'position' => 'Deadline', 'QFfield_callback' => 'CRM_TasksCommon::QFfield_timeless');
Utils_RecordBrowserCommon::new_record_field($tab, $field);
$deadline_time_field_exists = DB::GetOne('SELECT 1 FROM task_field WHERE field=%s', array('Deadline Time'));
$sql = false;
if ($deadline_time_field_exists) {
if (DB::is_mysql()) {
$sql = 'UPDATE task_data_1 SET f_deadline = TIMESTAMP(f_deadline, TIME(f_deadline_time)), f_timeless = (f_deadline_time IS NULL)';
} else {
$sql = 'UPDATE task_data_1 SET f_deadline = f_deadline + CAST(f_deadline_time as time), f_timeless = (f_deadline_time IS NULL)::int';
}
} elseif ($deadline_field_is_not_timestamp) {
if (DB::is_mysql()) {
$sql = 'UPDATE task_data_1 SET f_deadline = TIMESTAMP(f_deadline, \'12:00:00\'), f_timeless = 1';
} else {
$sql = 'UPDATE task_data_1 SET f_deadline = f_deadline + CAST(\'12:00:00\' as time), f_timeless = 1';
}
}
if ($sql) {
DB::Execute($sql);
}
if ($deadline_time_field_exists) {
Utils_RecordBrowserCommon::delete_record_field('task', 'Deadline Time');
}
<?php
defined("_VALID_ACCESS") || die('Direct access forbidden');
//addons table
$fields = array(array('name' => _M('Recordset'), 'type' => 'text', 'param' => 64, 'display_callback' => array('CRM_PhoneCallCommon', 'display_recordset'), 'QFfield_callback' => array('CRM_PhoneCallCommon', 'QFfield_recordset'), 'required' => true, 'extra' => false, 'visible' => true));
Utils_RecordBrowserCommon::install_new_recordset('phonecall_related', $fields);
Utils_RecordBrowserCommon::set_caption('phonecall_related', _M('Meeting Related Recordsets'));
Utils_RecordBrowserCommon::register_processing_callback('phonecall_related', array('CRM_PhoneCallCommon', 'processing_related'));
Utils_RecordBrowserCommon::add_access('phonecall_related', 'view', 'ACCESS:employee');
Utils_RecordBrowserCommon::add_access('phonecall_related', 'add', 'ADMIN');
Utils_RecordBrowserCommon::add_access('phonecall_related', 'edit', 'SUPERADMIN');
Utils_RecordBrowserCommon::add_access('phonecall_related', 'delete', 'SUPERADMIN');
Utils_RecordBrowserCommon::new_record_field('phonecall', array('name' => _M('Related'), 'type' => 'multiselect', 'param' => '__RECORDSETS__::;CRM_PhoneCallCommon::related_crits', 'QFfield_callback' => array('CRM_PhoneCallCommon', 'QFfield_related'), 'extra' => false, 'required' => false, 'visible' => true));
$rel = Utils_RecordBrowserCommon::get_records('phonecall', array('!related_to' => ''));
foreach ($rel as $r) {
$rr = array();
foreach ($r['related_to'] as $id) {
$rr[] = 'contact/' . $id;
}
Utils_RecordBrowserCommon::update_record('phonecall', $r['id'], array('related' => $rr), false, null, true);
}
Utils_RecordBrowserCommon::delete_record_field('phonecall', 'Related to');
<?php
defined("_VALID_ACCESS") || die('Direct access forbidden');
if (ModuleManager::is_installed('CRM_Roundcube') >= 0) {
Utils_RecordBrowserCommon::delete_record_field('rc_mails', 'Direction');
}
