def upgrade():
op.add_column('payment', sa.Column('created_at', sa.DateTime()))
op.add_column('payment', sa.Column('updated_at', sa.DateTime()))
op.add_column('payment', sa.Column('bank_id', sa.Integer(), nullable=True))
op.add_column('payment', sa.Column('exported', sa.Boolean(),
default=False))
op.add_column(
'payment',
sa.Column(
'tva_id',
sa.Integer(),
sa.ForeignKey('tva.id'),
nullable=True,
))
op.add_column('payment',
sa.Column('remittance_amount', sa.Integer(), nullable=True))
op.add_column('tva', sa.Column('compte_a_payer',
sa.String(125),
default=''))
from autonomie.models.base import DBSESSION
from autonomie.models.task import Payment
session = DBSESSION()
for payment in Payment.query():
payment.remittance_amount = payment.amount
payment.exported = True
payment.created_at = payment.updated_at = payment.date
session.merge(payment)
def upgrade():
op.add_column('payment', sa.Column('created_at', sa.DateTime()))
op.add_column('payment', sa.Column('updated_at', sa.DateTime()))
op.add_column('payment', sa.Column('bank_id', sa.Integer(), nullable=True))
op.add_column('payment', sa.Column('exported', sa.Boolean(), default=False))
op.add_column('payment', sa.Column(
'tva_id',
sa.Integer(),
sa.ForeignKey('tva.id'),
nullable=True,
))
op.add_column(
'payment',
sa.Column('remittance_amount', sa.Integer(), nullable=True)
)
op.add_column(
'tva',
sa.Column('compte_a_payer', sa.String(125), default='')
)
from autonomie_base.models.base import DBSESSION
from autonomie.models.task import Payment
session = DBSESSION()
for payment in Payment.query():
payment.remittance_amount = payment.amount
payment.exported = True
payment.created_at = payment.updated_at = payment.date
session.merge(payment)
def query(self, query_params_dict):
"""
Retrieve the exports we want to export
"""
query = Payment.query()
if 'start_date' in query_params_dict:
start_date = query_params_dict['start_date']
end_date = query_params_dict['end_date']
query = self._filter_date(query, start_date, end_date)
elif 'official_number' in query_params_dict:
official_number = query_params_dict['official_number']
financial_year = query_params_dict['financial_year']
query = self._filter_number(
query,
official_number,
financial_year,
)
if 'exported' not in query_params_dict or \
not query_params_dict.get('exported'):
query = query.filter(Payment.exported == False)
return query
def query(self, query_params_dict, form_name):
query = Payment.query()
if form_name == "period_form":
start_date = query_params_dict['start_date']
end_date = query_params_dict['end_date']
query = self._filter_date(query, start_date, end_date)
elif form_name == 'invoice_number_form':
start = query_params_dict['start']
end = query_params_dict['end']
financial_year = query_params_dict['financial_year']
query = self._filter_number(
query, start, end, financial_year,
)
if 'exported' not in query_params_dict or \
not query_params_dict.get('exported'):
query = query.filter(Payment.exported == False)
return query
def query(self, query_params_dict):
"""
Retrieve the exports we want to export
"""
query = Payment.query()
if 'start_date' in query_params_dict:
start_date = query_params_dict['start_date']
end_date = query_params_dict['end_date']
query = self._filter_date(query, start_date, end_date)
elif 'official_number' in query_params_dict:
official_number = query_params_dict['official_number']
financial_year = query_params_dict['financial_year']
query = self._filter_number(
query, official_number, financial_year,
)
if 'exported' not in query_params_dict or \
not query_params_dict.get('exported'):
query = query.filter(Payment.exported == False)
return query
def query(self, query_params_dict, form_name):
query = Payment.query()
if form_name == "period_form":
start_date = query_params_dict['start_date']
end_date = query_params_dict['end_date']
query = self._filter_date(query, start_date, end_date)
elif form_name == 'invoice_number_form':
start = query_params_dict['start']
end = query_params_dict['end']
financial_year = query_params_dict['financial_year']
query = self._filter_number(
query,
start,
end,
financial_year,
)
if 'exported' not in query_params_dict or \
not query_params_dict.get('exported'):
query = query.filter(Payment.exported == False)
return query
