o æi×ã@s¢ddlmZmZddlZddlmZddlmZddl m Z m Z m Z edƒZ dd„Z d d „Zd d „Zd d„Zdd„Zdd„Zdd„Zdd„Zdedefdd„ZdS)é)ÚListÚDictN)Ú get_db_config)Úlogger)ÚdatetimeÚtimezoneÚ timedeltaÚ Sales_B_DBc Cs†z'tjjdit¤Ž}| ¡}d}| ||||f¡| ¡| ¡| ¡WdStyB}zt   d|›¡WYd}~dSd}~ww)NzGINSERT INTO daily_log (session_id, sender, message) VALUES (%s, %s, %s)zDaily Log Save Error: ©) ÚmysqlÚ connectorÚconnectÚ B_DB_CONFIGÚcursorÚexecuteÚcommitÚcloseÚ ExceptionrÚerror)Ú session_idÚsenderÚmessageÚconnrÚsqlÚer r ú=/home/air/goalskill_sales/back/app/models/report_db_module.pyÚsave_daily_logs€ÿrc Cs z4tjjdit¤Ž}| ¡}d}| ||||||f¡| ¡| ¡| ¡t  d|›d|›¡WdSt yO}zt  d|›¡WYd}~dSd}~ww)Nzš INSERT INTO daily_note (session_id, date, learning, today_mindset, ai_comment) VALUES (%s, %s, %s, %s, %s) zDaily Note Saved: z - zDaily Note Save Error: r © r r r rrrrrrÚinforr) rÚdateÚlearningÚmindsetÚ ai_commentrrrrr r rÚsave_structured_diarys€ÿr#c Cóˆz'tjjdit¤Ž}|jdd}d}| ||f¡| ¡}| ¡| ¡|WStyC}zt   d|›¡gWYd}~Sd}~ww)NT©Ú dictionaryzWSELECT sender, message, created_at FROM daily_log WHERE session_id = %s ORDER BY id ASCzDaily Log Load Error: r © r r r rrrÚfetchallrrrr)rrrrÚrowsrr r rÚget_daily_log_from_db1s €þr*c Cr$)NTr%zz SELECT * FROM daily_note WHERE session_id = %s ORDER BY date DESC, id DESC zAll Daily Notes Load Error: r r')rrrrÚresultsrr r rÚget_all_daily_notesAs €þr,c Cs†z'tjjdit¤Ž}|jdd}d}| ||f¡| ¡}| ¡| ¡|WStyB}zt   d|›¡WYd}~dSd}~ww)NTr%z SELECT * FROM daily_note WHERE session_id = %s ORDER BY date DESC, id DESC LIMIT 1 zLatest Data Load Error: r ) r r r rrrÚfetchonerrrr)rrrrÚresultrr r rÚget_yesterday_dataWs €þr/c Cs¦z7ttddƒ}t |¡ d¡}tjjdit¤Ž}|j dd}d}|  |||f¡|  ¡}|  ¡|  ¡|WSt yR}zt d|›¡WYd}~dSd}~ww) Né ©Úhoursú%Y-%m-%dTr%zUSELECT * FROM daily_note WHERE session_id = %s AND date = %s ORDER BY id DESC LIMIT 1zToday Data Load Error: r )rrrÚnowÚstrftimer r r rrrr-rrrr)rÚJSTÚ today_strrrrr.rr r rÚget_today_datans  €þr8c Cs–z/tjjdit¤Ž}| ¡}d}| ||||f¡| ¡| ¡| ¡t  d|›¡WdSt yJ}zt  d|›¡WYd}~dSd}~ww)Nz@UPDATE daily_note SET ai_comment = %s, advice = %s WHERE id = %szUpdated AI Feedback for ID: zAI Feedback Update Error: r r)rr"Úadvicerrrrr r rÚupdate_yesterday_ai_feedback‚s€ÿr:c Cs¬z:tjjdit¤Ž}| ¡}d}| ||||f¡| ¡|j}| ¡| ¡t   d|›d|›d|›¡|dkWSt yU}zt   d|›¡WYd}~dSd}~ww) NzKUPDATE daily_note SET boss_comment = %s WHERE session_id = %s AND date = %szUpdated Boss Comment for z on z . Affected: rzBoss Comment Update Error: Fr ) r r r rrrrÚrowcountrrrrr)rrÚ boss_commentrrrÚ row_countrr r rÚupdate_boss_comment•s  €þr>rÚreturnc CsÈd}zÚstrÚboolrBr r r rÚs