7ik'dZddlZddlZddlmZddlZej dddlmZ ddl m Z ddl Zdge jd<gde jd<d e jd <d e jd < e j d ddddddddddddddddZdefdZd edefd!Zd"edefd#Zd$edefd%Zd&edefd'Zd(edefd)Zd1d*ed+edefd,Zd-edefd.Zd/edefd0Zy#Y`xYw)2u< 月次レポート - PDF用グラフ生成（matplotlib） N)BytesIOAggz sans-serifz font.family)zNoto Sans CJK JPz Noto Sans CJKz DejaVu SansArialzfont.sans-serifFzaxes.unicode_minus z font.size)try_read_cachez#2196F3)gp= ף?gzG?gffffff?333333?z#4CAF50)333333?gGz?gףp= ?rz#F44336)gQ?gp= ף?zG?rz#FF9800)?rgrz#9E9E9E)ףp= ?r r r)(\??rr)r rrr )r (\?p= ף?r)r rrr )r g{Gz?gq= ףp?r )primary primary_lightsuccess success_lightdanger danger_lightwarning warning_lightgray gray_lightteal teal_borderred red_borderbluereturnct}|j|ddddd|jdtj|j j d}|jtj|d |S) uCmatplotlibのfigureをbase64エンコードされた画像に変換pngtightwhitenone)formatdpi bbox_inches facecolor edgecolorrzutf-8zdata:image/png;base64,) rsavefigseekbase64 b64encodereaddecodecloseplt)figbuf img_base64s -/var/www/html/chat/reports/core/pdf_charts.py_fig_to_base64r80st )CKKEs!V5HHQK!!#((*-44W=JIIKIIcN #J< 00 daily_statsc |sy|Dcgc]}|jdddd}}|Dcgc]}t|jdd}}|Dcgc]}t|jdd}}|Dcgc]}t|jdd}}tjd \}}t j t |}d } |j|| d z z || d td|j|| d z z|| dtdt |dk\rddl m } t j|j|jt |dz} | ||} |j| | | ddtdd |j||dtddn|j||ddtdd |jd|j!d|j#d|j%||j'|d d!"|j)d#$|j+d%d&'tj,t/|Scc}wcc}wcc}wcc}w)(uC 日別回答統計グラフ（棒グラフ + 折れ線） Ndatetotal_conversationsranswered_countunanswered_countrfigsizeffffff?回答できたrlabelcolor回答できなかったr)PchipInterpolatorr- 総会話数r)rJrK linewidthorC)rK markersizezo-u日付件数u日別回答統計-rightrotationhaz upper left)locyr axisalpha)getintr3subplotsnparangelenbarCOLORSscipy.interpolaterNlinspaceminmaxplot set_xlabel set_ylabel set_title set_xticksset_xticklabelslegendgrid tight_layoutr8) r:ddatestotalanswered unansweredr4axxwidthrNx_smoothpchips r7generate_daily_chartr~<s/ -8 9QUU62 rs # 9E 9;F GaS,a0 1 GE G9DEAAEE*A./EHE=HI#aee.23IJIll7+GC #e*A EFF1uQw;%/@vFWFF1uQw; E1KSYZ_S`Fa 1v{7;;quuwQ"=!!U+ %/3nFSYNfgh 5#VF^B 5$nF6NVWXMM(MM(LL%&MM!urg6II,IGGCG  # ? : GEIsI5"I:"I?:"J comparisonc|sy|jdi}|jdi}gd}|jdd|jdd|jdd|jd d|jd dg}|jdd|jdd|jdd|jd d|jd dg}tjd \}}tjt |}d } |j || dz z || dtd|j || dz z|| dtd|jd|jd|j||j||j|jddtjt|S)u 前月比較グラフ Npreviouscurrent)rPrHrLu いいねu よくないr?rr@rA likes_countdislikes_countrCrDrFrGu前月rrIu当月rrTu 前月比較r[r r\)r_r3rarbrcrdrerfrmrnrorprqrrrsr8) rprevcurrlabels prev_data curr_datar4ryrzr{s r7generate_comparison_chartres  >>*b )D >>)R (D iF &* !1% #Q' " !1% I &* !1% #Q' " !1% Ill6*GC #f+A EFF1uQw; 5|@TFUFF1uQw; 5@WFXMM(LL MM!vIIKGGCG  # r9 hourly_statsc|sytdDcic]}|d}}|D]+}|jdd}|jdd}|||<-ttd}|Dcgc]}|| }}tjd\}} | j ||t dt d  | jd | jd | jd | j|| j|Dcgc]}|d c}dd| jddtjt|Scc}wcc}wcc}w)u% 時間帯別分布グラフ Nrhourr?rBrDrrrKr+u 時間帯 質問数u時間帯別質問数u時rUrVrWr[r r\)ranger_listr3rarerfrlrmrnrorprrrsr8) rh hour_dataitemrcounthourscountsr4rys r7generate_hourly_chartrsC  %Ry)!A)I) xx".2 $ rOE$) *qil *F *ll7+GCFF5& 76)CTFUMM+MM+LL()MM%51a1#S 1B7KGGCG  # +*+2s E % E E dow_statscb|sygd}tdDcic]}|d}}|D]+}|jdd}|jdd}|||<-tdDcgc]}|| }}tdDcgc]}|dk\r tdntd }}tjd \} } | j |||td  | j d| jd| jddtjt| Scc}wcc}wcc}w)u 曜日別グラフ N)u月u火u水u木u金u土u日r day_of_weekr?rr)rCrDrrru曜日別質問数r[r r\) rr_rfr3rarermrnrrrsr8) r day_namesiday_datardowrrcolorsr4rys r7generate_day_of_week_chartrs' AI#Ah'1'H'hh}a(.2  $)8 ,ahqk ,F ,V[\]V^ _QRaf_%VO5LL _F _ll6*GCFF9fFfY6GFHMM+LL%&GGCG  # '(- _s D" D'9D,summaryc p|sy|jdd}|jdd}|dk(r|dk(rytjd\}}||g}ddg}td td g}|j |||d d d t d|j dtjt|S)u" 回答可否円グラフ Nr@rrA)rrCrDrHrLrrz%1.1f%%Zrg?)r{)rrautopct startangle pctdistance wedgepropsu 回答可否) r_r3rarfpiedictrnrsr8)rrwrxr4rysizesrrs r7generate_resolution_pie_chartrs {{+Q/H/3J1}qll6*GC z "E!; |Dcgc]}|jdd}}|Dcgc]}|jdd}}t j d \}}t jt|}|j||td td  |j||j||jd |j||j|j!ddt j"t%|Scc}wcc}wcc}wcc}w)u( キーワード横棒グラフ Nrrkeywordr=rrrDrrru 出現回数rzr r\) isinstancertupler_r3rarbrcrdbarhrf set_yticksset_yticklabelsrlrn invert_yaxisrrrsr8) rrtop10krrr4ryr[s r7generate_keywords_chartrsH  SbME%(T5M* %&1!A$&& %&1!A$&&0561!%% 2&66-23!%%#33ll6*GC #f+AGGAvVO4y@QGRMM!vMM.!LLOOGGCG  # ''&63s E% E* E/*E4category_rankingc.|sy|dd}|Dcgc]}|d }}|Dcgc]}|d }}tjd\}}tjt |}|j ||t dt d |j||j||jd |jd |j|jd d tjt|Scc}wcc}w)u7 カテゴリ別問い合わせランキング NrrrGrrDrrru 参照回数u3カテゴリ別問い合わせランキング TOP10rzr r\)r3rarbrcrdrrfrrrlrnrrrrsr8)rrrrrr4ryr[s r7generate_category_ranking_chartr s  Sb !E#( ($d1g (F ("' ($d1g (F (ll6*GC #f+AGGAvVO4y@QGRMM!vMM.!LLFGOOGGCG  # !) (s D  Ddatac.i}|jdrt|d|d<|jdrt|d|d<|jdrt|d|d<|jdrt |d|d<|jdrt |d|d <|jd rt |d d |d <|jd rt |d d |d <|jdrt|d|d<|S)uC 全グラフを生成してbase64画像の辞書を返す r:dailyrrhourlyday_of_week_statsrrresolution_pier頻出キーワード TOP10unresolved_keywordsu未解決キーワード TOP10category_usage_rankingr)r_r~rrrrrr)rchartss r7generate_all_chartsr+s7F xx .tM/BCw xx 8l9KL| xx0n1EFx xx#$ :4@S;T U} xx #@i#Q  xx 4  ;=z xx%&(? & ')I)K$% xx()%D ) *&,!" Mr9)r)__doc__osr.ior matplotlibusematplotlib.pyplotpyplotr3matplotlib.font_manager font_managerfmnumpyrbrcParams_load_fontmanagerrfstrr8rr~rrrrrrrrr9r7rss  u$ ,n ]"_ %* !" [ B. ,,+* ) #* !( # & 13 1&d&s&R*$*3*Z@$3<4C6d3[^Dds<)d)t)e s 7C&&C*