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