from Utils.sql_handler import test_env_conn
from TestData.inbox.ticketDetail_test_data import ticketDetailData


ticket_select_sql = f'select * from `im_room` where `cate_id` = {ticketDetailData.brandId} and `status` = 1 and `is_ignore` = 0 and first_send_name != "Willdesk Team"'
ticket_select_result = test_env_conn.select_one_value(sql=ticket_select_sql)
ticket_room_id = ticket_select_result['room_id']
ticket_id = ticket_select_result['id']
customer_id = ticket_select_result['first_send_uid']
setattr(ticketDetailData, 'ticket_room_id', ticket_room_id)
setattr(ticketDetailData, 'ticket_id', ticket_id)
setattr(ticketDetailData, 'customer_id', customer_id)

customer_select_sql = f'select * from `customer` where id = {customer_id}'
customer_select_result = test_env_conn.select_one_value(sql=customer_select_sql)
customer_time_zone = customer_select_result['time_zone']
customer_location = customer_select_result['location']
customer_name = customer_select_result['name']
customer_email = customer_select_result['email']
customer_phone = customer_select_result['phone']
customer_is_visitor = customer_select_result['is_visitor']
customer_last_msg_time = ticket_select_result['last_msg_time']
setattr(ticketDetailData, 'customer_time_zone', customer_time_zone)
setattr(ticketDetailData, 'customer_location', customer_location)
setattr(ticketDetailData, 'customer_email', customer_email)
setattr(ticketDetailData, 'customer_phone', customer_phone)
setattr(ticketDetailData, 'customer_is_visitor', customer_is_visitor)
setattr(ticketDetailData, 'customer_last_msg_time', customer_last_msg_time)
setattr(ticketDetailData, 'customer_name', customer_name)