<s> from django . utils . translation import ugettext as _ <EOL> from sqlagg import SumColumn <EOL> from sqlagg . columns import SimpleColumn <EOL> from corehq . apps . reports . sqlreport import SqlData , DatabaseColumn <EOL> class AncHmisCaseSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SimpleColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" ] <EOL> class ProjectIndicatorsCaseSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SimpleColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" , "<STR_LIT>" ] <EOL> class LdHmisCaseSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SimpleColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" ] <EOL> class ImmunizationHmisCaseSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SimpleColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" ] <EOL> class McctMonthlyAggregateFormSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SimpleColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" ] <EOL> class AllHmisCaseSqlData ( SqlData ) : <EOL> table_name = "<STR_LIT>" <EOL> def __init__ ( self , domain , datespan ) : <EOL> self . domain = domain <EOL> self . datespan = datespan <EOL> @ property <EOL> def filter_values ( self ) : <EOL> return dict ( <EOL> domain = self . domain , <EOL> startdate = self . datespan . startdate_utc . date ( ) , <EOL> enddate = self . datespan . enddate_utc . date ( ) <EOL> ) <EOL> @ property <EOL> def filters ( self ) : <EOL> return [ <EOL> "<STR_LIT>" , <EOL> "<STR_LIT>" <EOL> ] <EOL> @ property <EOL> def columns ( self ) : <EOL> return [ <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) , <EOL> DatabaseColumn ( _ ( "<STR_LIT>" ) , <EOL> SumColumn ( "<STR_LIT>" ) ) <EOL> ] <EOL> @ property <EOL> def group_by ( self ) : <EOL> return [ "<STR_LIT>" , "<STR_LIT>" ] </s>
