
    O5j                         d dl mZmZ d dlmZ d dlmZmZ  ej                  d      d        Z	 ej                  d      d        Z
y)	    )jsonifyrequest)api_bp)spending_by_category_monthlymonthly_totalsz/analytics/spending-by-categoryc                  2   t         j                  j                  ddt              } t	        |       }t        |D ch c]  }|j                  |j                  f c}      }|D cg c]  \  }}| d|d }}}t        |D ch c]  }|j                   c}      }|||D ci c]8  |D cg c]%  \  t        t        fd|D        d            ' c}}: c}}}d	}	t        |	      S c c}w c c}}w c c}w c c}}w c c}}}w )
Nmonths   )type)months_back-02dc              3      K   | ]@  }|j                   k(  s|j                  k(  s#|j                  k(  s3|j                   B y w)N)yearmonthcategory_nametotal).0rcatmys     8/var/www/html/financials/app/blueprints/api/analytics.py	<genexpr>z1analytics_spending_by_category.<locals>.<genexpr>   s5     faffkagglqbeOeQWWfs   A	A	A	A	r   )labels
categoriesseries)r   argsgetintr   sortedr   r   r   floatnextr   )
r   rowsr   months_seenr   r   month_labelsr   r   datas
       ``  ` r   analytics_spending_by_categoryr(      s   ,,""8Rc":K'K@DT:166177+:;K/:;tq!qc1S'N;L;$7Q78J  "	
 	
  
 ( 
 Aq	 dfdf  	
D 4=# ;;7
	
s)   C<*DD-D:*D$DDz/analytics/monthly-totalsc            
          t        d      } t        | D cg c]/  }|j                  |j                  t	        |j
                        d1 c}      S c c}w )N   )r   r   r   )r   r   r   r   r"   r   )r	   r   s     r   analytics_monthly_totalsr+      sK    BF !''E!''NC   s   4AN)flaskr   r   app.blueprints.apir   &app.services.analytics.trend_analyticsr   r   router(   r+        r   <module>r2      sN    " % _ /0 1. )* +r1   