def get_upload_list_schema():
"""
Build a schema for Accounting Operation upload listing
"""
schema = BaseListsSchema().clone()
del schema['search']
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='filetype',
widget=deform.widget.SelectWidget(
values=(
('all', u'Tous les types de fichier'),
('general_ledger', u"Grand livre"),
('analytical_balance', u"Balance analytique"),
)
),
default='all',
missing=colander.drop,
)
)
schema.insert(
0,
YearPeriodSchema(
name='period',
widget=CleanMappingWidget(),
missing=colander.drop,
)
)
return schema
def get_income_statement_measures_list_schema():
"""
Build the schema used to list treasury measures
:returns: A form schema
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
del schema['search']
del schema['page']
del schema['items_per_page']
def get_year_options(kw):
cid = kw['request'].context.get_company_id()
years = IncomeStatementMeasureGrid.get_years(company_id=cid)
current_year = datetime.date.today().year
if current_year not in years:
years.append(current_year)
return years
node = forms.year_select_node(
name='year',
query_func=get_year_options,
title=u"Année"
)
schema.insert(0, node)
return schema
def get_income_statement_measures_list_schema():
"""
Build the schema used to list treasury measures
:returns: A form schema
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
del schema['search']
del schema['page']
del schema['items_per_page']
def get_year_options(kw):
cid = kw['request'].context.get_company_id()
years = IncomeStatementMeasureGrid.get_years(company_id=cid)
current_year = datetime.date.today().year
if current_year not in years:
years.append(current_year)
return years
node = forms.year_select_node(name='year',
query_func=get_year_options,
title=u"Année")
schema.insert(0, node)
return schema
def get_list_schema():
schema = BaseListsSchema().clone()
schema['search'].description = u"Entreprise ou contact principal"
schema.add(
colander.SchemaNode(colander.Boolean(),
name='archived',
missing=False,
widget=deform.widget.HiddenWidget()))
return schema
def get_list_schema():
schema = BaseListsSchema().clone()
schema['search'].description = u"Entreprise ou contact principal"
schema.add(colander.SchemaNode(
colander.Boolean(),
name='archived',
missing=False,
widget=deform.widget.HiddenWidget())
)
return schema
def get_list_schema():
"""
Return a list schema for user datas
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Nom, prénom, entreprise"
schema.insert(
0,
colander.SchemaNode(
colander.Integer(),
name='situation_situation',
widget=get_deferred_select(CaeSituationOption,
empty_filter_msg=u"Tous les status"),
validator=get_deferred_select_validator(CaeSituationOption),
missing=colander.drop,
))
schema.insert(0, conseiller_filter_node_factory())
antenne_filter_node = colander.SchemaNode(
colander.Integer(),
name="situation_antenne_id",
widget=get_deferred_select(AntenneOption,
empty_filter_msg=u"Toutes les antennes"),
validator=get_deferred_select_validator(AntenneOption),
missing=colander.drop)
schema.insert(0, antenne_filter_node)
return schema
def get_list_schema():
"""
Return the schema for the customer search list
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Entreprise ou contact principal"
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='archived',
label=u"Inclure les clients archivés",
))
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='individual',
label=u"Inclure les particuliers",
default=True,
))
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='company',
label=u"Inclure les personnes morales \
(entreprises, association ...)",
default=True,
))
return schema
def get_operation_list_schema():
"""
Build a schema listing operations
"""
schema = BaseListsSchema().clone()
del schema['search']
schema.insert(
0,
colander.SchemaNode(
colander.Boolean(),
name='include_associated',
title="",
label=u"Inclure les opérations associées à une entreprise",
default=True,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='analytical_account',
title="",
widget=deferred_analytical_account_widget,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='general_account',
title="",
widget=deferred_general_account_widget,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.Integer(),
name='company_id',
title="",
widget=deferred_company_id_widget,
missing=colander.drop
)
)
return schema
class MailHistoryView(BaseListView):
"""
A view showing the history of sent emails
"""
schema = BaseListsSchema()
default_sort = 'send_at'
default_direction = 'desc'
sort_columns = {'send_at': 'send_at'}
title = u"Historique des mails envoyés"
def query(self):
return MailHistory.query()
def _build_return_value(self, schema, appstruct, query):
"""
add month and years attribute to each file record
"""
result = BaseListView._build_return_value(self, schema, appstruct,
query)
for obj in result['records']:
splitted = obj.filepath.split('/')
month = splitted[-2]
year = splitted[-3]
obj.month = month
obj.year = year
return result
def filter_company_id(self, query, appstruct):
search = appstruct.get('search')
if search:
query = query.filter(MailHistory.company_id == search)
return query
def get_upload_list_schema():
"""
Build a schema for Accounting Operation upload listing
"""
schema = BaseListsSchema().clone()
del schema['search']
schema.insert(
0,
YearPeriodSchema(
name='period',
widget=CleanMappingWidget(),
missing=colander.drop,
)
)
return schema
def get_training_list_schema(is_admin):
"""
Build the Training list filter schema
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Numéro de facture"
if is_admin:
schema.add_before(
"items_per_page",
company_filter_node_factory(name='company_id')
)
schema.add_before(
"items_per_page",
customer_filter_node_factory(name='customer_id', is_admin=is_admin)
)
schema.add_before(
"items_per_page",
colander.SchemaNode(
colander.Boolean(),
name="include_closed",
label=u"Inclure les affaires clôturées",
missing=False
)
)
return schema
def get_list_schema():
"""
Return the schema for the customer search list
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Entreprise ou contact principal"
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='archived',
label=u"Inclure les clients archivés",
)
)
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='individual',
label=u"Inclure les particuliers",
default=True,
)
)
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='company',
label=u"Inclure les personnes morales \
(entreprises, association ...)",
default=True,
)
)
return schema
def get_list_schema():
"""
Return a list schema for user datas
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Nom, prénom, entreprise"
schema.insert(0, colander.SchemaNode(
colander.Integer(),
name='situation_situation',
widget=get_deferred_select(
CaeSituationOption, empty_filter_msg=u"Tous les status"
),
validator=get_deferred_select_validator(CaeSituationOption),
missing=colander.drop,
))
schema.insert(0, conseiller_filter_node_factory(
name='situation_follower_id'
))
antenne_filter_node = colander.SchemaNode(
colander.Integer(),
name="situation_antenne_id",
widget=get_deferred_select(
AntenneOption, empty_filter_msg=u"Toutes les antennes"
),
validator=get_deferred_select_validator(AntenneOption),
missing=colander.drop
)
schema.insert(0, antenne_filter_node)
return schema
def get_list_schema():
"""
Return the schema for the project search form
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Nom de l'affaire"
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='closed',
label=u"Inclure les affaires terminées",
missing=True,
))
return schema
def get_operation_list_schema():
"""
Build a schema listing operations
"""
schema = BaseListsSchema().clone()
del schema['search']
schema.insert(
0,
colander.SchemaNode(
colander.Boolean(),
name='include_associated',
title="",
label=u"Inclure les opérations associées à une entreprise",
default=True,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='analytical_account',
title="",
widget=deferred_analytical_account_widget,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='general_account',
title="",
widget=deferred_general_account_widget,
missing=colander.drop,
)
)
schema.insert(
0,
colander.SchemaNode(
colander.Integer(),
name='company_id',
title="",
widget=deferred_company_id_widget,
missing=colander.drop
)
)
return schema
def get_list_schema():
"""
Return the schema for the project search form
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Nom de l'affaire"
schema.add(
colander.SchemaNode(
colander.Boolean(),
name='closed',
label=u"Inclure les affaires terminées",
missing=True,
)
)
return schema
def get_treasury_measures_list_schema():
"""
Build the schema used to list treasury measures
:returns: A form schema
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
del schema['search']
def get_year_options(kw):
return TreasuryMeasureGrid.get_years()
node = forms.year_select_node(name='year',
query_func=get_year_options,
missing=-1,
description=u"Année de dépôt")
schema.insert(0, node)
return schema
def get_upload_list_schema():
"""
Build a schema for Accounting Operation upload listing
"""
schema = BaseListsSchema().clone()
del schema['search']
schema.insert(
0,
colander.SchemaNode(
colander.String(),
name='filetype',
widget=deform.widget.SelectWidget(values=(
('all', u'Tous les types de fichier'),
('general_ledger', u"Grand livre"),
('analytical_balance', u"Balance analytique"),
)),
default='all',
missing=colander.drop,
))
schema.insert(
0,
YearPeriodSchema(
name='period',
widget=CleanMappingWidget(),
missing=colander.drop,
))
return schema
def get_treasury_measures_list_schema():
"""
Build the schema used to list treasury measures
:returns: A form schema
:rtype: colander.Schema
"""
schema = BaseListsSchema().clone()
del schema['search']
def get_year_options(kw):
return TreasuryMeasureGrid.get_years()
node = forms.year_select_node(
name='year',
query_func=get_year_options,
missing=-1,
description=u"Année de dépôt"
)
schema.insert(0, node)
return schema
def get_training_list_schema(is_admin):
"""
Build the Training list filter schema
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Numéro de facture"
schema.add_before("items_per_page",
company_filter_node_factory(name='company_id'))
schema.add_before(
"items_per_page",
customer_filter_node_factory(name='customer_id', is_admin=is_admin))
schema.add_before(
"items_per_page",
colander.SchemaNode(colander.Boolean(),
name="include_closed",
label=u"Inclure les affaires clôturées",
missing=False))
return schema
def get_list_schema():
"""
Return a list schema for user datas
"""
schema = BaseListsSchema().clone()
schema['search'].description = u"Nom, prénom, entreprise"
schema.insert(0, colander.SchemaNode(
colander.Integer(),
name='situation_situation',
widget=deferred_situation_select,
validator=deferred_situation_id_validator,
missing=colander.drop,
)
)
schema.insert(0, conseiller_filter_node_factory())
return schema
