o ¿ÔiRã@s<ddlmZmZmZddlmZddlmZmZdd„ZdS)é)ÚFlaskÚrequestÚjsonify)Úconnect_to_database)ÚdatetimeÚ timedeltac Cs.tj}| d¡}| d¡}|r|stddiƒdfSd}d}z_zÚtƒ}|jdd}| d|f¡| ¡sTtd d iƒd fWW|rD| ¡nd|rQ|  ¡rQ| ¡SdSt   ¡}d }|d krÅ| d|f¡| ¡r“| d|f¡|  ¡td diƒdfWW|rƒ| ¡nd|r|  ¡r| ¡SdS| d||f¡| d|f¡|  ¡td diƒdfWW|rµ| ¡nd|rÂ|  ¡rÂ| ¡SdS|dkrP| d|f¡| ¡}|sötd diƒdfWW|ræ| ¡nd|ró|  ¡ró| ¡SdS|dpý|d}||  ¡} |dr|d  ¡nd} t| | |ƒ} | d| ||df¡| d|f¡|  ¡td diƒdfWW|r>| ¡nd|rM|  ¡rM| ¡SdS|d krÙ| d!|f¡| ¡}|s…td diƒdfWW|rs| ¡nd|r‚|  ¡r‚| ¡SdS||d  ¡} |d"r˜|d"  ¡nd} t| | |ƒ}| d#|||df¡| d$|f¡|  ¡td d%iƒdfWW|rÇ| ¡nd|rÖ|  ¡rÖ| ¡SdStd d&iƒdfWW|ré| ¡nd|rø|  ¡rø| ¡SdStjjy<}z3|r | ¡ndtdd'|›iƒd(fWYd}~W|r&| ¡nd|r5|  ¡r5| ¡SdSd}~wty}}z5|rK| ¡ndtdd)t|ƒ›iƒd(fWYd}~W|rg| ¡nd|rv|  ¡rv| ¡SdSd}~ww|r…| ¡nd|r”|  ¡r”| ¡wdw)*NÚuser_idÚstatusÚerrorzuser_id and status are requirediT)Ú dictionaryz"SELECT id FROM users WHERE id = %sÚmessagezUser not foundi”io.ÚactivezvSELECT id FROM user_activity_management WHERE user_id = %s AND is_active = 1 LIMIT 1z=UPDATE users SET useractivity_status = 'active' WHERE id = %szUser already activeéÈz™INSERT INTO user_activity_management (user_id, status, last_login_time, is_active) VALUES (%s, 'active', %s, 1)zNew active sessionéÉZonlinez·SELECT id, updated_at, last_login_time, total_online_time FROM user_activity_management WHERE user_id = %s AND is_active = 1 LIMIT 1zNo active sessionÚ updated_atZlast_login_timeZtotal_online_timerzÅUPDATE user_activity_management SET status = 'online', total_online_time = SEC_TO_TIME(%s), updated_at = %s WHERE id = %sÚidz=UPDATE users SET useractivity_status = 'online' WHERE id = %szOnline time updatedZinactivez«SELECT id, last_login_time, total_active_time FROM user_activity_management WHERE user_id = %s AND is_active = 1 LIMIT 1Ztotal_active_timezñUPDATE user_activity_management SET status = 'inactive', total_active_time = SEC_TO_TIME(%s), is_active = 0, last_logout_time = %s WHERE id = %sz?UPDATE users SET useractivity_status = 'inactive' WHERE id = %sz Session endedzInvalid statuszDatabase error: iôzServer error: )rÚjsonÚgetrrÚcursorÚexecuteÚfetchoneÚcloseÚ is_connectedrÚnowÚcommitÚ total_secondsÚminÚmysqlÚ connectorÚErrorÚrollbackÚ ExceptionÚstr)Údatarr ÚconnrÚ current_timeZMAX_TIME_SECONDSZactivityZ last_updateZ time_diffZcurrent_onlineZ new_onlineZactive_secondsZcurrent_activeÚ new_activeÚerrÚe©r)úO/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/UserActivity.pyÚmanage_user_activitysú   q€üþ_€¢üþR€ ¯ûE€¼  ú þ.€  Óû!€ à ù þ € ö € ø€"€ €û€&€ €û€ r+N) ÚflaskrrrÚconfrrrr+r)r)r)r*Ús