|hQ &ddlmZddlmZmZddlmZddlZddlZ ddlm Z ddlm Z ddl m Z mZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZmZmZddlmZeeZeZGddeZdZ ededede eefdefdZ!ededede eefdeeeeffdZ"ededede eefdeeeeffdZ#ededede eefdeeeeffdZ$ededede eefdeeeeffdZ%ededede eefdeeeeffdZ&ededede eefdeeeeffdZ'ededede eefdeeeeffdZ(ededede eefdeeeeffd Z)d!e*defd"Z+d#Z,y)$)tool)ListDict) VectorStoreN)Error) Annotated) ToolMessage AIMessage) MessagesState)InjectedToolCallId) add_messages) TypedDict)Command)datetime timedeltatimezone)uuid4c6eZdZUeeefed<eed<eed<y)StatemessagesnameroomnoN)__name__ __module__ __qualname__rlistr __annotations__str,/home/kushmeetdev/Regenta/Chatbot/mytools.pyrrsl*++ I Lr rcHtjjdS)z5Return the current time in UTC as a formatted string.z%Y-%m-%d %H:%M:%S)rutcnowstrftimerr r!get_current_timer%s ??  % %&9 ::r guestnameroom_no tool_call_idreturnctdtd|d|||td|gd}td|dd|d t| S) z Captures guests name and Room number Args: name (str): Guest Name roomno (str): Guest Room Number z**Invoking TOOL GetGuestDetails guestname: ,room no: u0Thank you for providing Your name and Room Nor()rrrz GUESTNAME: rrupdate)printr r)r&r'r( state_updates r!get_GuestDetailsr2so +- K {+gY 78 !SbnopsL K V,-[h9O8P QR , ''r querystatec 0td|jd}|jd}td|d||dk(s(|dk(s#|dk(s|d k(s|d k(s|d k(s|d k(s |d k(s|dk(rtdtd|giS|dk(s|dk(s|dk(s |dk(s|dk(rtdtd|giSt t }d|d||ddt t d|d }t|}t|tj|}|S)a Looks up information in a knowledge base to help with answering customer questions regarding ordering food and beverages. For example Can I order food to my room? Is the restaurant open now? Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL FnBrrzGUESTNAMEFNB: r,Guest Room NumberrequiredNone guest_nameGuest Your nameguest Guest Namer May I have your name please?🤗r-r. room_numberunknownnull Room Number(May I have your room number, please?🤗3answer to queryNew1 BUID RequestIDToDept FromRoomNo RequestDescp BotResponseStatusRequestCreatedAt LastUpdatedAt AttendedBy GuestNamer3) r0getrr rrr% add_request vector_store query_fnbr3r4r(rr' request_id sample_dataresults r!tool_fnbr_1s ! 99V Dii!G N4& G9 56 rzW 33tj7H4RX=\`dp\ptx}DuDHLP[H[_cgn_nrvzFrF %GVbcd   "}=0Gy4HGW]L]ahkxax %O^jkl   UWJ(,.)+ K %F 6N  " " " /E Lr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)al Looks up information in a knowledge base to help with answering customer questions regarding the hotel and its Amenities Inquiries. For example: where is the swimming pool located. What are the gym timings. Is there any train station nearby etcetera. check out timings parking facilities. Can you arrange a taxi for me? Are there any good restaurants serving Arabian cuisine? Can you recommend restaurants near the hotel? Payment & Billing issue and other info enquires Can I split the bill between multiple payment methods I noticed a charge on my bill that I don't recognize. Can you help? Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Receptionrrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrE2rGrHrIrJrV) r0rWrrrr r%rXrYquery_receptionr[s r!tool_receptionrcas( %' 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}$77']:RV]ajVjnuynDKN[D[ %O^jkl   (,.)+ K %F 6N  ( (u ( 5E Lr c td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|y)a^ Captures queries that the bot cannot confidently answer and logs them for reception follow-up. Args: query (str): The unresolved user query state (Dict): Current conversation state tool_call_id (str): Unique tool call identifier Returns: Command to update the state and log the unresolved query z-**Invoking TOOL Catchall for unresolved queryrrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrEraz5Unable to resolve query - Requires human intervention Unresolved0rJN)r0rWrrrr r%rXr[s r! tool_catchallrgsh 9; 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}$77']:RV]ajVjnuynDKN[D[ %O^jkl   N,.)+ K %F &Mr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)a. Looks up information in a knowledge base to help with answering customer regarding hotel's room service. For example Can I have a towel please Can I have a toothbrush please Can I get my room cleaned. Please help to clean my room I need a baby crib or cot Can I switch to a room with a better view . Room Preferences What are the pool hours?. What are the fitness center hours? Do you have vegetarian or special dietary options? what are breakfast hour or timings Can I get a couple of water bottles sent to my room Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Room Servicerrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrErIrGrHrJrV) r0rWrrrr r%rXrYquery_roomservicer[s r!tool_roomservicerjs* (* 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}#66']:RV]ajVjnuynDKN[D[ %O^jkl   (,.)+ K %F 6N  * * * 7E Lr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)a  Looks up information in a knowledge base to help with answering customer questions AND helping them if they face any technical difficulty. for example My Wifi is not working My TV is now working. OR I am unable to get the TV channels Is there a business center where I can print documents? Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Tech Helprrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrE4rGrHrIrJrV) r0rWrrrr r%rXrYquery_techhelpr[s r! tool_techhelprns %' 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}#66']:RV]ajVjnuynDKN[D[ %O^jkl   (,.)+ K %F 6N  ' 'e ' 4E Lr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)ag Looks up information in a knowledge base to help with answering customer questions AND helping them if they face any Concierge related difficulty. for example Does the hotel offer shuttle service to the airport? How do I get to the nearest subway/metro station. or Is there a good jogging path nearby? Can you recommend a good spa nearby? Do you offer babysitting services? Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Conciergerrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrE5rGrHrIrJrV) r0rWrrrr r%rXrYquery_concierger[s r!tool_conciergerr/s %' 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}#66']:RV]ajVjnuynDKN[D[ %O^jkl   (,.)+ K %F 6N  ( (u ( 5E Lr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)a Looks up information in a knowledge base to help with answering customer questions AND helping them if they face any maintenance difficulty. for example The air conditioning in my room isn't working properly There's a light bulb out in my bathroom The shower drain is clogged. Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Maintenancerrr+r,r6r8r9r:r;r<r=r>rr?r-r.r7r@rArBrCrDrE7rGrHrIrJrV) r0rWrrrr r%rXrYquery_maintenancer[s r!tool_maintenancerv`s ') 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}$777m;SW^bkWkov{ApAELO\E\ %O^jkl   (,.)+ K %F 6N  * * * 7E Lr c 0td|jd}|jd}td|d|tt}|dk(s#|dk(s|dk(s|d k(s|d k(s|d k(s |d k(s|d k(rt dt d|giS|dk(s|dk(s|dk(s|dk(s |dk(s|dk(rt dt d|giSd|d||ddt t d|d }t|}t|tj|}|S)a  Looks up information in a knowledge base to help with answering customer questions AND helping them if they face any safety and security related difficulty. for example I lost my room key. What should I do? What should I do in case of an emergency? Does the hotel have a safe in the room? Args: query (str): Question to ask the knowledge base Return: List[Dict[str, str]]: Potentially relevant question and answer pairs from the knowledge base z**Invoking TOOL Security rrr+r,r6r8r9r:r;r<r=r>rr?r-r.r@rArBrCr7rDrE8rGrHrIrJrV) r0rWrrrr r%rXrYquery_securityr[s r! tool_securityrzs~ %' 99V Dii!G Kv[ 23UWJ rzTJ&$-4<;OSW[bSbfjnyfy~BFM~MPTXdPd %GVbcd   "}=0Gy4HGW]L]ahkxax}DH[}[ %O^jkl   (,.)+ K %F 6N  ' 'e ' 4E Lr datac t}|r|j}d}|j||d|d|d|d|d|d|d|d |d |d |d f |j |r2|j r!|j |j y y y |r2|j r!j |j yyy#t $rL}dt|cYd}~r2|j r!j |j SSSd}~wwxYw#r2|j r!j |j wwwxYw)z4Add a request to the t_requestmaster table in MySQL.z INSERT INTO t_Requests(BUID,RequestID, ToDept, FromRoomNo, RequestDescp,BotResponse, Status, RequestCreatedAt,LastUpdatedAt,AttendedBy, GuestName) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) rKrLrMrNrOrPrQrRrSrTrUzRequest added successfully.Error: N)get_mysql_connectioncursorexecutecommit is_connectedcloserr)r{ connectionr sql_queryes r!rXrXsz)+ &&(FI NN9V [!X\"^$]#X'(_%\"[! '     0 *113 LLN    4:1 0 *113 LLN    4: "Q!! *113 LLN    4:" *113 LLN    4:s0A,C D/# D*0D/1D2*D//D226E(c tjjdddd}|jr t d|St dy#t $r}t d|Yd}~yd}~wwxYw)Nz157.173.210.15 testagent1 RoyalOrchid)hostuserpassworddatabasezConnected to MySQL databasez"ERROR Connecting to MySQL databaser})mysql connectorconnectrr0r)rrs r!r~r~sv__,,!!" -  " " $ / 0  6 7  sms?A A A/A**A/)-langchain_core.toolsrtypingrrrYr sqlalchemymysql.connectorrrrlangchain_core.messagesr r langgraph.graphr r langgraph.graph.messager typing_extensionsrlanggraph.typesrrrruuidrrr\rr%r2r_rcrgrjrnrrrvrzdictrXr~rr r!rs%%$!;)30'#22 \ } I ;((c(3PbKbAc(il((&-C--YsDV?V5W-\`aefiknfnao\p--^3#3e39SJ\E\;]3bfgkloqtltgubv33j,,T,3HZCZ9[,`deijmorjres`t,,^4C44YsL^G^=_4dhimnqsvnviwdx44l--U-)CI[D[:\-aefjknpsksftau--`-#-e-9SJ\E\;]-bfgkloqtltgubv--`-C--YsL^G^=_-dhimnqsvnviwdx--`--U-)CI[D[:\-aefjknpsksftau--`dsBr