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 test_gen_cancelinvoice_payment(dbsession, invoice, tva):
invoice.payments = [Payment(mode="c", amount=120000000, tva=tva)]
cinv = invoice.gen_cancelinvoice(invoice.owner)
assert len(cinv.default_line_group.lines) == len(
invoice.default_line_group.lines) + len(invoice.discounts) + 1
assert cinv.default_line_group.lines[-1].cost == 100000000
assert cinv.default_line_group.lines[-1].tva == 2000
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 invoice(project, user, customer, company, phase):
invoice = Invoice(
company,
customer,
project,
phase,
user,
)
invoice.line_groups = [TaskLineGroup(lines=[TaskLine(**LINE)])]
for i in PAYMENTS:
invoice.payments.append(Payment(**i))
return invoice
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
def test_payment_get_amount():
payment = Payment(**PAYMENTS[1])
assert payment.get_amount() == 1895
def invoice():
inv = Invoice(**INVOICE)
inv.lines = [InvoiceLine(**LINE)]
for i in PAYMENTS:
inv.payments.append(Payment(**i))
return inv
def test_payment_get_amount():
payment = Payment(**PAYMENTS[1])
assert payment.get_amount() == 1895
