{j@#dZddlZddlZddlZddlZddlZddlmZddlm Z m Z m Z m Z m Z ddlmZmZeGddZeGdd ZGd d ZdS) a  Isolated Feedback & Suggestions Database Service for FreeExile. Manages a dedicated database to collect bug reports, gameplay suggestions, balance adjustments, and system diagnostics from players. Decoupled completely from game state and financial ledger databases. N)contextmanager)DictListOptionalAnyTuple) dataclassasdictceZdZUdZeed<dZeed<dZeed<dZe ed<d Z e ed <d Z eed <d Z e ed<d Ze ed<d Ze ed<dZeed<dS)SystemDiagnosticsDTOiOSclient_platformziOS 18.2 os_versionziPhone 16 Pro Max device_modelg^@ current_fpscurrent_ping_msuCổ Trấn Huyết Lâncurrent_zone_namegplayer_xplayer_yplayer_zzv2.0-Authoritativegame_build_versionN)__name__ __module__ __qualname__rstr__annotations__rrrfloatrintrrrrr9C:\Projects\FreeExile\server\feedback\feedback_service.pyr r s OS    J   +L#+++KOS7s777HeHeHe222222r!r ceZdZUeed<eed<eed<eed<eed<eed<eeefed<eed<d Zeed <d Z eed <d Z eed <dS)FeedbackRecord feedback_id player_id player_namecategorytitlecontent diagnosticsstatusadmin_responser created_at_ms updated_at_msN) rrrrrrrrr.r/r0r r!r"r$r$ sNNNMMM JJJ LLLc3h KKKNCM3M3r!r$c*eZdZddeefdZedZddZ dde ded ed ed ed ee de e eeffd Z dedeefdZ ddeed eede de deef dZ ddededede fdZdeeeffdZdS)FeedbackServiceNdb_pathc|stjd}|stjtjtjtddd}tj|dtj|d}||_ | dS)NFEEDBACK_DB_PATHz..dataT)exist_okzfeedback_store.db) osenvirongetpathabspathjoindirname__file__makedirsr3_init_database)selfr3base_dirs r"__init__zFeedbackService.__init__0s 9jnn%788G Bwrw||BGOOH4M4MtUY[a'b'bccH K4 0 0 0 0gll8-@AAG  r!c#Ktj|j}tj|_ |V|dS#|wxYwN)sqlite3connectr3Row row_factoryclose)rBconns r"_get_connectionzFeedbackService._get_connection;sRt|,,"; JJJ JJLLLLLDJJLLLLs AAreturncX|5}|}|d|d|d|d|ddddS#1swxYwYdS)z1Initializes the dedicated player feedback schema.at CREATE TABLE IF NOT EXISTS player_feedback ( feedback_id TEXT PRIMARY KEY, player_id INTEGER NOT NULL, player_name TEXT NOT NULL, category TEXT NOT NULL, title TEXT NOT NULL, content TEXT NOT NULL, diagnostics_json TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'NEW', admin_response TEXT DEFAULT '', created_at_ms INTEGER NOT NULL, updated_at_ms INTEGER NOT NULL ) zICREATE INDEX IF NOT EXISTS idx_feedback_status ON player_feedback(status)zMCREATE INDEX IF NOT EXISTS idx_feedback_category ON player_feedback(category)zLCREATE INDEX IF NOT EXISTS idx_feedback_player ON player_feedback(player_id)N)rMcursorexecutecommit)rBrLrPs r"rAzFeedbackService._init_databaseDs  ! ! # # t[[]]F NN    NNf g g g NNj k k k NNi j j j KKMMM)                  sA=BB#&B#r&r'r(r)r*r+c |}|}|sdSt|dkrdSdttjdt jjdd}ttjdz}|rt|ntt} | 5} | } | d ||||||tj | d ||f | dddn #1swxYwYd } d || fS#t$r} d ddt!| fcYd} ~ Sd} ~ wwxYw)z{ Submits new player feedback into the dedicated database. Returns: (success, feedback_id, message) )Fr-u2Tiêu đề góp ý không được để trống! )Fr-u8Nội dung góp ý phải có tối thiểu 10 ký tự!fb__NaU INSERT INTO player_feedback ( feedback_id, player_id, player_name, category, title, content, diagnostics_json, status, admin_response, created_at_ms, updated_at_ms ) VALUES (?, ?, ?, ?, ?, ?, ?, 'NEW', '', ?, ?) F) ensure_asciiusCảm ơn đại hiệp đã gửi góp ý! Ban Quản Trị FreeExile đã ghi nhận vào sổ bộ độc lập.Tr-u%Lỗi hệ thống khi lưu góp ý: )striplenrtimeuuiduuid4hexr r rMrPrQjsondumpsrR Exceptionr)rBr&r'r(r)r*r+r%now_ms diag_dictrLrPack_msges r"submit_feedbackzFeedbackService.submit_feedback\s --// SRR w<<"  XXEC ,,EEtz||/?/CEE TY[[4'((+6ZF;'''FCWCYCYNEWPLANNEDREJECTEDRESOLVED UNDER_REVIEWFrXz UPDATE player_feedback SET status = ?, admin_response = ?, updated_at_ms = ? WHERE feedback_id = ? rN)rr\rMrPrQrRrowcount)rBr%rzr.valid_statusesrcrLrPs r"update_feedback_statusz&FeedbackService.update_feedback_statussTSS ^ + +5TY[[4'((  ! ! # # 't[[]]F NNnfkB  D D D KKMMM?Q& ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' 'sA BB #B ciidd}|5}|}|d|D]/}|d|d|d<|dxx|dz cc<0|d|D]}|d|d |d < d d d n #1swxYwY|S) z5Provides statistics for GM / Product Team dashboards.r) by_status by_categorytotalzCSELECT status, COUNT(*) as cnt FROM player_feedback GROUP BY statuscntrr,rzGSELECT category, COUNT(*) as cnt FROM player_feedback GROUP BY categoryrr(N)rMrPrQru)rBmetricsrLrPrms r"get_feedback_metricsz$FeedbackService.get_feedback_metricssN022PQ"R"R  ! ! # # Et[[]]F NN` a a a(( / /69%j $S]3   CJ.    NNd e e e(( E E:=e* &s:77 E E E E E E E E E E E E E E E EsB1CC CrF)rNN)NNror)r-)rrrrrrDrrMrArr rboolrgr$rnrryrrrrr r!r"r2r2/s      ^>7;-O-O-O-O -O  -O  -O23-O tS#~ -O-O-O-O^ch~6N0!%"& && &3-& &  & n  &&&&X! '''' '  ''''0d38nr!r2)__doc__r8rGr`r]r\ contextlibrtypingrrrrr dataclassesr r r r$r2r r!r"rs6  %%%%%%33333333333333))))))))  3 3 3 3 3 3 3  3          @@@@@@@@@@r!