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

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

��ѧ٧ѧ�
<?php $fieldsSearch = array(); $fieldsSearch['ipp'] = array ( 'type' => 'text', 'trans' => 'View', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 20, 'max_range' => 200) ) ); $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['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['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` != `user_id`)']], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['cls_time'] = array ( 'type' => 'boolean', 'trans' => 'groupby', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $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['email'] = array ( 'type' => 'text', 'trans' => 'Sort by', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'likeright', 'filter_table_field' => 'email', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['phone'] = array ( 'type' => 'text', 'trans' => 'Phone', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'likeright', 'filter_table_field' => 'phone', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $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['country_ids'] = array ( 'type' => 'text', 'trans' => 'Country IDS', '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['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['view'] = array ( 'type' => 'text', 'trans' => 'View', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'none', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['online_user_id'] = array ( 'type' => 'text', 'trans' => 'Online user ID', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'online_user_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $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['chat_status_ids'] = array ( 'type' => 'text', 'trans' => 'Chat status', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'status', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $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_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' ) ); $fieldsSearch['nick'] = array ( 'type' => 'text', 'trans' => 'Nick', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'like', 'filter_table_field' => 'nick', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'unsafe_raw' ) ); $fieldsSearch['ip'] = array ( 'type' => 'text', 'trans' => 'Nick', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'ip', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'unsafe_raw' ) ); $fieldsSearch['chat_id'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'multiple_id' => true, 'filter_type' => 'filter', 'filter_table_field' => '`lh_chat`.`id`', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['visitor_id'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'multiple_id' => true, 'filter_type' => 'filter', 'filter_table_field' => '`lh_chat`.`online_user_id`', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'string' ) ); $fieldsSearch['subject_id'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'id', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['invitation_id'] = array ( 'type' => 'text', 'trans' => 'id', '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['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['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['chat_duration_from'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergt', 'filter_table_field' => 'chat_duration', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $fieldsSearch['chat_duration_till'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterlte', 'filter_table_field' => 'chat_duration', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $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['timefromts'] = array ( 'type' => 'text', 'trans' => 'id', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filtergte', 'filter_table_field' => 'time', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'int' ) ); $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['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['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['group_id'] = array ( 'type' => 'text', 'trans' => 'Group', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'user_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['product_id'] = array ( 'type' => 'text', 'trans' => 'Product', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'product_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 1) ) ); $fieldsSearch['fbst'] = array ( 'type' => 'text', 'trans' => 'Feedback status', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'fbst', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0) ) ); $fieldsSearch['chat_status'] = array ( 'type' => 'text', 'trans' => 'Chats status', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'status', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0,'max_range' => 1000) ) ); $fieldsSearch['hum'] = array ( 'type' => 'checkbox', 'trans' => 'Group results', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'has_unread_messages', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['una'] = array ( 'type' => 'checkbox', 'trans' => 'Group results', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'unanswered_chat', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['anonymized'] = array ( 'type' => 'checkbox', 'trans' => 'Anonymized', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filter', 'filter_table_field' => 'anonymized', 'validation_definition' => new ezcInputFormDefinitionElement ( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $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['iwh_ids'] = array ( 'type' => 'text', 'trans' => 'Department', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'iwh_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'int', array( 'min_range' => 0), FILTER_REQUIRE_ARRAY ) ); $fieldsSearch['theme_ids'] = array ( 'type' => 'text', 'trans' => 'Theme', 'required' => false, 'valid_if_filled' => false, 'filter_type' => 'filterin', 'filter_table_field' => 'theme_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 ) ); $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['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 `user_id` = 0))']], '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 `user_id` > 0)']], 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'boolean' ) ); $fieldsSearch['sortby'] = array ( 'type' => 'text', 'trans' => 'Sort by', 'required' => false, 'valid_if_filled' => false, 'filter_type' => false, 'filter_table_field' => 'user_id', 'validation_definition' => new ezcInputFormDefinitionElement( ezcInputFormDefinitionElement::OPTIONAL, 'string') ); $fieldSortAttr = array ( 'field' => 'sortby', 'default' => 'id_desc', 'serialised' => true, 'options' => array( 'id_desc' => array('sort_column' => '`lh_chat`.`id` DESC'), 'id_asc' => array('sort_column' => '`lh_chat`.`id` ASC'), 'lmt_dsc' => array('sort_column' => '`lh_chat`.`last_msg_id` DESC'), 'lmt_asc' => array('sort_column' => '`lh_chat`.`last_msg_id` ASC'), ) ); return array( 'filterAttributes' => $fieldsSearch, 'sortAttributes' => $fieldSortAttr );

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