options = array('title' => TEXT_FIELDTYPE_TEXT_PATTERN);
}
function get_configuration()
{
$cfg = array();
$cfg[] = array('title' => TEXT_PATTERN . fields::get_available_fields_helper($_POST['entities_id'], 'fields_configuration_pattern'),
'name' => 'pattern',
'type' => 'textarea',
'tooltip' => TEXT_ENTER_TEXT_PATTERN_INFO,
'params' => array('class' => 'form-control'));
return $cfg;
}
function render($field, $obj, $params = array())
{
return '';
}
function process($options)
{
return '';
}
function output($options)
{
global $app_user, $app_entities_cache, $app_fields_cache, $fields_access_schema_holder, $parent_items_name_holder, $app_num2str, $app_module_path, $app_session_token;
$html = '';
$cfg = new fields_types_cfg($options['field']['configuration']);
$entities_id = $options['field']['entities_id'];
$item = $options['item'];
if(isset($options['custom_pattern']))
{
$pattern = $options['custom_pattern'];
}
else
{
$pattern = $cfg->get('pattern');
}
if(strlen($pattern) > 0)
{
//hanlde current user name, id, item id etc
$pattern = str_replace([
'[current_user_name]',
'[current_user_id]',
'[id]',
], [
($app_user['name'] ?? ''),
($app_user['id'] ?? ''),
$item['id']??0,
], $pattern);
//handle date format ${Y-m-d}
if(preg_match_all('/\${([^}]+)}/', $pattern, $matches))
{
foreach($matches[1] as $matches_key => $date_format)
{
$pattern = str_replace($matches[0][$matches_key], date($date_format), $pattern);
}
}
//num2str
$pattern = $app_num2str->prepare($pattern,$item);
if(preg_match_all('/\[(\w+)\]/', $pattern, $matches))
{
//use to check if formulas fields using in text pattern
$formulas_fields = false;
foreach($matches[1] as $matches_key => $fields_id)
{
$field = false;
if(isset($app_fields_cache[$entities_id]['fieldtype_' . $fields_id]))
{
$field = $app_fields_cache[$entities_id]['fieldtype_' . $fields_id];
}
elseif(isset($app_fields_cache[$entities_id][$fields_id]))
{
$field = $app_fields_cache[$entities_id][$fields_id];
}
if($field)
{
switch($field['type'])
{
case 'fieldtype_parent_item_id':
$enitites_info = $app_entities_cache[$entities_id];
if($enitites_info['parent_id'] > 0 and $item['parent_item_id'] > 0)
{
if(!isset($parent_items_name_holder[$enitites_info['parent_id']][$item['parent_item_id']]))
{
$value = $parent_items_name_holder[$enitites_info['parent_id']][$item['parent_item_id']] = items::get_heading_field($enitites_info['parent_id'], $item['parent_item_id']);
}
else
{
$value = $parent_items_name_holder[$enitites_info['parent_id']][$item['parent_item_id']];
}
}
else
{
$value = '';
}
break;
case 'fieldtype_created_by':
$value = $item['created_by'];
break;
case 'fieldtype_date_added':
$value = $item['date_added'];
break;
case 'fieldtype_date_updated':
$value = $item['date_updated'];
break;
case 'fieldtype_action':
case 'fieldtype_id':
$value = $item['id'];
break;
case 'fieldtype_formula':
//check if formula value exist in item and if not then do extra query to calcualte it
if(strlen($item['field_' . $field['id']]??'') == 0)
{
//prepare forumulas query
if(!$formulas_fields)
{
$formulas_fields_query = db_query("select e.* " . fieldtype_formula::prepare_query_select($entities_id, '') . " from app_entity_" . $entities_id . " e where id='" . $item['id'] . "'");
$formulas_fields = db_fetch_array($formulas_fields_query);
}
$value = $item['field_' . $field['id']] = $formulas_fields['field_' . $field['id']];
}
else
{
$value = $item['field_' . $field['id']];
}
break;
default:
$value = $item['field_' . $field['id']]??'';
break;
}
$output_options = array('class' => $field['type'],
'value' => $value,
'field' => $field,
'item' => $item,
'is_export' => true,
'is_print' => true,
'is_email' => (isset($options['is_email']) ? $options['is_email'] : false),
'hide_attachments_url' => (isset($options['hide_attachments_url']) ? $options['hide_attachments_url'] : false),
'path' => (isset($options['path']) ? $options['path'] : ''));
//output full html if print option off
if(isset($options['is_print']))
{
if($options['is_print'] == 0)
{
unset($output_options['is_export']);
unset($output_options['is_print']);
}
}
if(in_array($field['type'], array('fieldtype_textarea_wysiwyg','fieldtype_qrcode')))
{
$output = trim(fields_types::output($output_options));
}
elseif(in_array($field['type'], array('fieldtype_items_by_query')) and isset($options['is_email']))
{
$output = trim(fields_types::output($output_options));
}
elseif(in_array($field['type'], array('fieldtype_user_photo')))
{
if($app_module_path == 'dashboard/select2_users_json')
{
$output = ' . '&file=' . urlencode(base64_encode($output_options['value']))) . ')
';
}
else
{
$output = fields_types::output($output_options);
}
}
elseif(in_array($field['type'], array('fieldtype_image','fieldtype_image_ajax')))
{
if(strlen($output_options['value']))
{
if($app_module_path == 'dashboard/select2_json')
{
$output = ')) . ')
';
}
elseif($app_module_path == 'dashboard/select2_ml_json')
{
$output = ')) . ')
';
}
elseif($options['is_email'] == 1)
{
$file = attachments::parse_filename($output_options['value']);
if($options['hide_attachments_url'] == 1)
{
$output = $file['name'];
}
else
{
$output = link_to($file['name'], url_for('items/info', 'path=' . $entities_id . '&action=download_attachment&file=' . urlencode(base64_encode($output_options['value'])) . '&field=' . $output_options['field']['id']), array('target' => '_blank'));
}
}
else
{
$output = ')) . ')
';
}
}
else
{
$output = '';
}
}
elseif(in_array($field['type'], ['fieldtype_parent_item_id', 'fieldtype_barcode']))
{
$output = $value;
}
elseif(!isset($output_options['is_export']) and in_array($field['type'], array('fieldtype_attachments', 'fieldtype_input_file', 'fieldtype_image','fieldtype_onlyoffice')))
{
$output = fields_types::output($output_options);
}
elseif( in_array($field['type'], array('fieldtype_todo_list')))
{
$output = trim(fields_types::output($output_options));
}
else
{
$output = trim(strip_tags((fields_types::output($output_options)??'')));
}
//handle xml pattern
if(isset($options['is_xml']))
{
if(in_array($field['type'], array('fieldtype_textarea_wysiwyg')))
{
$output = '';
}
elseif(in_array($field['type'], array('fieldtype_textarea')))
{
$output = ''), $output) . ']]>';
}
else
{
$output = htmlspecialchars($output, ENT_XML1);
}
}
//echo '
' . $fields_id . ' ' . $output . ' ' . $matches[0][$matches_key];
$pattern = str_replace($matches[0][$matches_key], $output, $pattern);
}
}
//check if fields was replaced
if(preg_replace('/\[(\d+)\]/', '', $cfg->get('pattern')) != $pattern)
{
$html = $pattern;
}
}
else
{
$html = $pattern;
}
if(preg_match_all('/^\[>([^\]]*)\]/', trim($pattern), $matches))
{
$html = trim(str_replace($matches[0][0], '', $html));
}
elseif(preg_match_all('/\[>([^\]]*)\]/', trim($html), $matches))
{
$html = trim(str_replace($matches[0][0], $matches[1][0], $html));
}
}
return $html;
}
function output_singe_text($text, $entities_id, $item, $options = [])
{
$path = (isset($options['path']) ? $options['path'] : $entities_id . '-' . $item['id']);
$output_options = array('item' => $item);
$output_options['field']['configuration'] = '';
$output_options['field']['entities_id'] = $entities_id;
$output_options['path'] = $path;
$output_options['custom_pattern'] = $text;
$output_options['is_print'] = (isset($options['is_print']) ? $options['is_print'] : true);
$output_options['is_email'] = (isset($options['is_email']) ? $options['is_email'] : false);
$output_options['hide_attachments_url'] = (isset($options['hide_attachments_url']) ? $options['hide_attachments_url'] : false);
if(isset($options['is_xml']))
$output_options['is_xml'] = $options['is_xml'];
$text = $this->output($output_options);
//prepare url
$text = str_replace('[url]', url_for('items/info', 'path=' . $path), $text);
//prepare last comment
if(strstr($text, '[comment]'))
{
$last_comment = self::get_last_comment_info($entities_id, $item['id'], $path);
$text = str_replace('[comment]', $last_comment, $text);
}
return $text;
}
static function get_last_comment_info($entities_id, $items_id, $path)
{
global $app_users_cache, $fields_access_schema_holder, $app_user;
if(!isset($fields_access_schema_holder[$entities_id]))
{
$fields_access_schema = $fields_access_schema_holder[$entities_id] = users::get_fields_access_schema($entities_id, $app_user['group_id']);
}
else
{
$fields_access_schema = $fields_access_schema_holder[$entities_id];
}
$comments_query_sql = "select * from app_comments where entities_id='" . $entities_id . "' and items_id='" . $items_id . "' order by date_added desc limit 1";
$items_query = db_query($comments_query_sql);
if($item = db_fetch_array($items_query))
{
$descripttion = $item['description'];
//include attachments
if(strlen($item['attachments']))
{
$descripttion .= "";
foreach(explode(',', $item['attachments']) as $filename)
{
$file = attachments::parse_filename($filename);
$descripttion .= "![](" . url_for_file($file[)
" . link_to($file['name'], url_for('items/info', 'path=' . $path . '&action=download_attachment&file=' . urlencode(base64_encode($filename)))) . " (" . $file['size'] . ")
";
}
$html_fields = '';
$comments_fields_query = db_query("select f.*,ch.fields_value from app_comments_history ch, app_fields f where comments_id='" . db_input($item['id']) . "' and f.id=ch.fields_id order by ch.id");
while($field = db_fetch_array($comments_fields_query))
{
//check field access
if(isset($fields_access_schema[$field['id']]))
{
if($fields_access_schema[$field['id']] == 'hide')
continue;
}
$output_options = array(
'class' => $field['type'],
'value' => $field['fields_value'],
'field' => $field,
'path' => $path);
$html_fields .= "
| • " . htmlspecialchars($field['name']) . ": |
" . htmlspecialchars(strip_tags(fields_types::output($output_options))) . " |
";
}
//include comments fileds
if(strlen($html_fields))
{
$descripttion .= "";
}
if(strlen($descripttion))
{
$html = '' . $app_users_cache[$item['created_by']]['name'] . ' - ' . format_date_time($item['date_added']) . '
';
$html .= $descripttion;
return $html;
}
}
return '';
}
}