��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/lib/core/lhchat/searchattr/chatsstatistic_tab.php

��ѧ٧ѧ�
<?php $fieldsSearch = array(); $fieldsSearch['region'] = array ( 'type' => 'text', 'trans' => 'Sort by', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'like', 'filter_table_field' => 'city', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['country_ids'] = array ( 'type' => 'text', 'trans' => 'Country', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'country_code', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'string', array(), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['group_chart_type'] = array ( 'type' => 'text', 'trans' => 'Sort by', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'filter_table_field' => '', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['report'] = array ( 'type' => 'text', 'trans' => 'Report', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['group_limit'] = array ( 'type' => 'text', 'trans' => 'Group Field', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'group_limit', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 3, 'max_range' => 50) ) ); $fieldsSearch['wait_time_from'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergt', 'filter_table_field' => 'wait_time', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['wait_time_till'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterlte', 'filter_table_field' => 'wait_time', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['chart_type'] = array ( 'type' => 'text', 'trans' => 'Department', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'chart_type', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'string', array(), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['frt_from'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergt', 'filter_table_field' => 'frt', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['frt_till'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterlte', 'filter_table_field' => 'frt', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['mart_from'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergt', 'filter_table_field' => 'mart', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['mart_till'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterlte', 'filter_table_field' => 'mart', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['aart_from'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergt', 'filter_table_field' => 'aart', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['aart_till'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterlte', 'filter_table_field' => 'aart', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['group_field'] = array ( 'type' => 'text', 'trans' => 'Group Field', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'group_field', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'string', array() ) ); $fieldsSearch['has_unread_op_messages'] = array ( 'type' => 'text', 'trans' => 'Has unread operator messages', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'has_unread_op_messages', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0) ) ); $fieldsSearch['bot_ids'] = array ( 'type' => 'text', 'trans' => 'Bot ID', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'gbot_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['cls_us'] = array ( 'type' => 'text', 'trans' => 'Visitor status', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'cls_us', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0) ) ); $fieldsSearch['subject_ids'] = array ( 'type' => 'text', 'trans' => 'Bot ID', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin_elastic', 'filter_table_field' => 'subject_ids', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['timefrom'] = array ( 'type' => 'text', 'trans' => 'Timefrom', 'required' => false, 'valid_if_filled' => false, 'datatype' => 'datetime', 'filter_type' => 'filtergte', 'filter_table_field' => 'time', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['timeto'] = array ( 'type' => 'text', 'trans' => 'Timeto', 'required' => false, 'valid_if_filled' => false, 'datatype' => 'datetime', 'filter_type' => 'filterlte', 'filter_table_field' => 'time', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['group_id'] = array ( 'type' => 'text', 'trans' => 'Group', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['department_id'] = array ( 'type' => 'text', 'trans' => 'Department', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['invitation_id'] = array ( 'type' => 'text', 'trans' => 'Invitation', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'invitation_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['invitation_ids'] = array ( 'type' => 'text', 'trans' => 'Invitation', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'invitation_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['proactive_chat'] = array( 'type' => 'text', 'trans' => 'Proactive chat', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'chat_initiator', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['not_invitation'] = array( 'type' => 'text', 'trans' => 'Not invitation', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'invitation_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['department_group_id'] = array ( 'type' => 'text', 'trans' => 'Department group', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['user_id'] = array ( 'type' => 'text', 'trans' => 'User', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'user_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['groupby'] = array ( 'type' => 'text', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'filter_table_field' => 'user_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0) ) ); $fieldsSearch['exclude_offline'] = array ( 'type' => 'text', 'trans' => 'Exclude offline', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filternot', 'filter_table_field' => 'status_sub', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['online_offline'] = array ( 'type' => 'text', 'trans' => 'Only offline', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'status_sub', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['user_ids'] = array ( 'type' => 'text', 'trans' => 'Department', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'user_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['group_ids'] = array ( 'type' => 'text', 'trans' => 'Group', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['department_ids'] = array ( 'type' => 'text', 'trans' => 'Department', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['department_group_ids'] = array ( 'type' => 'text', 'trans' => 'Group', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'dep_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1), FILTER_REQUIRE_ARRAY ) ); // Boolean filters $fieldsSearch['no_operator'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['filter' => ['user_id' => 0]], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['has_unread_messages'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['filter' => ['has_unread_messages' => 1]], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['abandoned_chat'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['customfilter' => ['((`lsync` < (`pnd_time` + `wait_time`) AND `wait_time` > 1) OR (`lsync` > (`pnd_time` + `wait_time`) AND `wait_time` > 1 AND `lh_chat`.`user_id` = 0))']], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['transfer_happened'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['customfilter' => ['(`transfer_uid` > 0 AND `transfer_uid` != `lh_chat`.`user_id`)']], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['dropped_chat'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['customfilter' => ['(`lsync` > (`pnd_time` + `wait_time`) AND `has_unread_op_messages` = 1 AND `lh_chat`.`user_id` > 0)']], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['has_operator'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['filtergt' => ['user_id' => 0]], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['with_bot'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['filtergt' => ['gbot_id' => 0]], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['without_bot'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'manual', 'filter_table_field' => ['filter' => ['gbot_id' => 0]], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldSortAttr = array ( 'field' => false, 'default' => false, 'serialised' => true, 'disabled' => true, 'options' => array() ); return array( 'filterAttributes' => $fieldsSearch, 'sortAttributes' => $fieldSortAttr );

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�