示例#1
0
 def __json__(self, request):
     return dict(
         id=self.id,
         task_id=self.task_id,
         description=self.description,
         amount=integer_to_amount(self.amount, 5),
         tva=integer_to_amount(self.tva, 2),
     )
示例#2
0
 def get_val(self, line):
     if hasattr(line, 'ht'):
         val = integer_to_amount(line.ht)
     else:
         val = integer_to_amount(line.total)
     # Le total_ht s'affiche en bas de page en mode calculée
     self.ht += integer_to_amount(line.total_ht)
     return val
示例#3
0
 def __json__(self, request):
     return dict(
         id=self.id,
         task_id=self.task_id,
         description=self.description,
         amount=integer_to_amount(self.amount, 5),
         tva=integer_to_amount(self.tva, 2),
     )
示例#4
0
 def get_val(self, line):
     if hasattr(line, 'ht'):
         val = integer_to_amount(line.ht)
     else:
         val = integer_to_amount(line.total)
     # Le total_ht s'affiche en bas de page en mode calculée
     self.ht += integer_to_amount(line.total_ht)
     return val
示例#5
0
文件: excel.py 项目: lluc/autonomie
    def write_table_footer(self, columns, lines):
        """
        Write table footer (total, ht, tva, km)

        :param list columns: The columns as described in the static vars here
        above
        :param list lines: The lines presented in this table
        """
        for column in columns:
            cell = self.get_column_cell(column)
            cell.style = FOOTER_CELL

            if not column.static:
                value = column.ht
                cell.value = value

                if value == 0 and not column.force_visible:
                    col_width = 0
                else:
                    col_width = 13
                self.set_col_width(column.start_letter, col_width)

            elif column.key == 'description':
                cell.value = "Totaux"

            elif column.key == 'total_ht':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_ht', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'tva':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_tva', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'km':
                cell.value = integer_to_amount(
                    sum(
                        [getattr(line, 'km', 0) for line in lines]
                    )
                )

            elif column.key == 'total':
                cell.value = integer_to_amount(
                    sum(
                        [line.total for line in lines]
                    )
                )

        self.index += 4
    def write_table_footer(self, columns, lines):
        """
        Write table footer (total, ht, tva, km)

        :param list columns: The columns as described in the static vars here
        above
        :param list lines: The lines presented in this table
        """
        for column in columns:
            cell = self.get_column_cell(column)
            cell.style = FOOTER_CELL

            if not column.static:
                value = column.ht
                cell.value = value

                if value == 0 and not column.force_visible:
                    col_width = 0
                else:
                    col_width = 13
                self.set_col_width(column.start_letter, col_width)

            elif column.key == 'description':
                cell.value = "Totaux"

            elif column.key == 'total_ht':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_ht', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'tva':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_tva', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'km':
                cell.value = integer_to_amount(
                    sum(
                        [getattr(line, 'km', 0) for line in lines]
                    )
                )

            elif column.key == 'total':
                cell.value = integer_to_amount(
                    sum(
                        [line.total for line in lines]
                    )
                )

        self.index += 4
示例#7
0
 def __json__(self, request):
     res = BaseExpenseLine.__json__(self, request)
     res.update(
         dict(
             ht=integer_to_amount(self.ht, 2),
             tva=integer_to_amount(self.tva, 2)
         )
     )
     return res
示例#8
0
    def __json__(self, request):
        """
        Return the datas used by the json renderer to represent this task
        """
        return dict(
            id=self.id,
            name=self.name,
            created_at=self.created_at.isoformat(),
            updated_at=self.updated_at.isoformat(),

            phase_id=self.phase_id,
            business_type_id=self.business_type_id,
            status=self.status,
            status_comment=self.status_comment,
            status_person_id=self.status_person_id,
            # status_date=self.status_date.isoformat(),
            date=self.date.isoformat(),
            owner_id=self.owner_id,
            description=self.description,
            ht=integer_to_amount(self.ht, 5),
            tva=integer_to_amount(self.tva, 5),
            ttc=integer_to_amount(self.ttc, 5),
            company_id=self.company_id,
            project_id=self.project_id,
            customer_id=self.customer_id,
            project_index=self.project_index,
            company_index=self.company_index,
            official_number=self.official_number,
            internal_number=self.internal_number,
            display_units=self.display_units,
            expenses_ht=integer_to_amount(self.expenses_ht, 5),
            address=self.address,
            workplace=self.workplace,
            payment_conditions=self.payment_conditions,
            notes=self.notes,
            status_history=[
                status.__json__(request) for status in self.statuses
            ],
            discounts=[
                discount.__json__(request) for discount in self.discounts
            ],
            payments=[
                payment.__json__(request) for payment in self.payments
            ],
            mentions=[mention.id for mention in self.mentions],
            line_groups=[
                group.__json__(request) for group in self.line_groups
            ],
            attachments=[
                file_.__json__(request) for file_ in self.files
            ],
            file_requirements=[
                file_req.__json__(request)
                for file_req in self.file_requirements
            ]
        )
示例#9
0
 def __json__(self, request):
     return dict(
         id=self.id,
         order=self.order,
         index=self.order,
         description=self.description,
         cost=integer_to_amount(self.amount, 5),
         amount=integer_to_amount(self.amount, 5),
         date=self.date.isoformat(),
         task_id=self.task_id,
     )
示例#10
0
文件: task.py 项目: Swannbm/autonomie
    def __json__(self, request):
        """
        Return the datas used by the json renderer to represent this task
        """
        return dict(
            id=self.id,
            name=self.name,
            created_at=self.created_at.isoformat(),
            updated_at=self.updated_at.isoformat(),

            phase_id=self.phase_id,
            status=self.status,
            status_comment=self.status_comment,
            status_person_id=self.status_person_id,
            # status_date=self.status_date.isoformat(),
            date=self.date.isoformat(),
            owner_id=self.owner_id,
            description=self.description,
            ht=integer_to_amount(self.ht, 5),
            tva=integer_to_amount(self.tva, 5),
            ttc=integer_to_amount(self.ttc, 5),
            company_id=self.company_id,
            project_id=self.project_id,
            customer_id=self.customer_id,
            project_index=self.project_index,
            company_index=self.company_index,
            official_number=self.official_number,
            internal_number=self.internal_number,
            display_units=self.display_units,
            expenses_ht=integer_to_amount(self.expenses_ht, 5),
            address=self.address,
            workplace=self.workplace,
            payment_conditions=self.payment_conditions,
            status_history=[
                status.__json__(request) for status in self.statuses
            ],
            discounts=[
                discount.__json__(request) for discount in self.discounts
            ],
            payments=[
                payment.__json__(request) for payment in self.payments
            ],
            mentions=[mention.id for mention in self.mentions],
            line_groups=[
                group.__json__(request) for group in self.line_groups
            ],
            attachments=[
                file_.__json__(request) for file_ in self.files
            ],
            file_requirements=[
                file_req.__json__(request)
                for file_req in self.file_requirements
            ]
        )
示例#11
0
 def __json__(self, request):
     result = dict(
         id=self.id,
         order=self.order,
         cost=integer_to_amount(self.cost, 5),
         tva=integer_to_amount(self.tva, 2),
         description=self.description,
         quantity=self.quantity,
         unity=self.unity,
         group_id=self.group_id,
         product_id=self.product_id,
     )
     return result
示例#12
0
 def __json__(self, request):
     result = dict(
         id=self.id,
         order=self.order,
         cost=integer_to_amount(self.cost, 5),
         tva=integer_to_amount(self.tva, 2),
         description=self.description,
         quantity=self.quantity,
         unity=self.unity,
         group_id=self.group_id,
         product_id=self.product_id,
     )
     return result
示例#13
0
    def get_turnover(self, year):
        """
        Retrieve the annual turnover for the current company

        :param int year: The current year
        """
        ca = self._autonomie_service.get_turnover(self, year)
        return math_utils.integer_to_amount(ca, precision=5)
示例#14
0
    def get_turnover(self, year):
        """
        Retrieve the annual turnover for the current company

        :param int year: The current year
        """
        ca = self._autonomie_service.get_turnover(self, year)
        return math_utils.integer_to_amount(ca, precision=5)
示例#15
0
 def __json__(self, request):
     return dict(
         id=self.id,
         created_at=self.created_at,
         updated_at=self.updated_at,
         mode=self.mode,
         amount=math_utils.integer_to_amount(self.amount),
         bank_remittance_id=self.bank_remittance_id,
         label=self.bank_remittance_id,
         date=self.date,
         exported=self.exported,
         task_id=self.task_id,
         bank_id=self.bank_id,
         bank=self.bank.label,
         tva_id=self.tva_id,
         tva=math_utils.integer_to_amount(self.tva.value, 2),
         user_id=self.user_id,
     )
示例#16
0
 def __json__(self, request):
     return dict(
         id=self.id,
         value=integer_to_amount(self.value, 2),
         label=self.name,
         name=self.name,
         default=self.default,
         products=[product.__json__(request) for product in self.products],
     )
示例#17
0
文件: tva.py 项目: lluc/autonomie
 def __json__(self, request):
     return dict(
         id=self.id,
         value=integer_to_amount(self.value, 2),
         label=self.name,
         name=self.name,
         default=self.default,
         products=[product.__json__(request) for product in self.products],
     )
示例#18
0
 def __json__(self, request):
     return dict(
         id=self.id,
         created_at=self.created_at,
         updated_at=self.updated_at,
         mode=self.mode,
         amount=math_utils.integer_to_amount(self.amount),
         bank_remittance_id=self.bank_remittance_id,
         label=self.bank_remittance_id,
         date=self.date,
         exported=self.exported,
         task_id=self.task_id,
         bank_id=self.bank_id,
         bank=self.bank.label,
         tva_id=self.tva_id,
         tva=math_utils.integer_to_amount(self.tva.value, 2),
         user_id=self.user_id,
     )
示例#19
0
文件: sheet.py 项目: lluc/autonomie
 def __json__(self, request):
     res = BaseExpenseLine.__json__(self, request)
     res.update(
         dict(
             km=integer_to_amount(self.km),
             start=self.start,
             end=self.end,
             vehicle=self.vehicle,
         ))
     return res
示例#20
0
 def get_cell_val(self, line, column):
     """
         return the value for a given cell for the current line
     """
     if line.type_object is None:
         val = ""
     elif column.has_key('key'):
         val = getattr(line, column['key'], '')
         formatter = column.get('formatter')
         if val and formatter:
             val = formatter(val)
     elif column['code'] == line.type_object.code:
         if hasattr(line, 'ht'):
             val = integer_to_amount(line.ht)
         else:
             val = integer_to_amount(line.total)
     else:
         val = ""
     return val
示例#21
0
 def __json__(self, request):
     res = BaseExpenseLine.__json__(self, request)
     res.update(
         dict(
             km=integer_to_amount(self.km),
             start=self.start,
             end=self.end,
             vehicle=self.vehicle,
         )
     )
     return res
示例#22
0
    def serialize(self, node, appstruct):
        if appstruct is colander.null:
            return colander.null

        try:
            return str(integer_to_amount(self.num(appstruct), self.precision))
        except Exception:
            raise colander.Invalid(
                node,
                u"\"{val}\" n'est pas un montant valide".format(val=appstruct),
            )
示例#23
0
    def serialize(self, node, appstruct):
        if appstruct is colander.null:
            return colander.null

        try:
            return str(integer_to_amount(self.num(appstruct), self.precision))
        except Exception:
            raise colander.Invalid(
                node,
                u"\"{val}\" n'est pas un montant valide".format(val=appstruct),
            )
示例#24
0
 def write_total(self):
     """
         write the final total
     """
     cell = self.get_merged_cells('A', 'D')
     cell.value = u"Total des frais professionnel à payer"
     cell.style = LARGE_FOOTER_CELL
     cell = self.get_merged_cells('E', 'E')
     cell.value = integer_to_amount(self.model.total)
     cell.style = LARGE_FOOTER_CELL
     self.index += 2
示例#25
0
 def write_total(self):
     """
         write the final total
     """
     cell = self.get_merged_cells('A', 'D')
     cell.value = u"Total des dépenses professionnelles à payer"
     cell.style = LARGE_FOOTER_CELL
     cell = self.get_merged_cells('E', 'E')
     cell.value = integer_to_amount(self.model.total)
     cell.style = LARGE_FOOTER_CELL
     self.index += 2
示例#26
0
    def write_table(self, columns, lines):
        """
            write a table with headers and content
            :param columns: list of dict
            :params lines: list of models to be written
        """
        self.write_table_header(columns)
        for line in lines:
            for column in columns:
                cell = self.get_column_cell(column)
                cell.value = self.get_cell_val(line, column)
                if column.has_key('number_format'):
                    cell.style.number_format.format_code = \
                            column['number_format']
            self.index += 1

        for column in columns:
            cell = self.get_column_cell(column)
            cell.style.font.bold = True
            self.set_color(cell, Color.footer)
            cell.style.number_format.format_code = '0.00'
            if column.has_key('code'):
                val = sum([line.ht for line in lines \
                                     if line.type_object \
                                     and line.type_object.code==column['code']])
                cell.value = integer_to_amount(val)
                if val == 0:
                    self.set_col_width(column['letter'], 0)
                else:
                    self.set_col_width(column['letter'], 13)
            elif column.get('key') == 'description':
                cell.value = "Totaux"
            elif column.get('key') == 'tva':
                cell.value = integer_to_amount(
                        sum([getattr(line, 'tva', 0) for line in lines]))
                cell.style.number_format.format_code = '0.00'
            elif column.get('key') == 'total':
                cell.value = integer_to_amount(
                        sum([line.total for line in lines]))
                cell.style.number_format.format_code = '0.00'
        self.index += 4
示例#27
0
 def __json__(self, request):
     """
     Json repr of our model
     """
     return dict(
         id=self.id,
         label=self.label,
         ref=self.ref,
         description=self.description,
         tva=integer_to_amount(self.tva, 2),
         value=self.value,
         unity=self.unity,
         category_id=self.category_id,
         category=self.category.title,
     )
示例#28
0
 def write_total(self):
     """
         write the final total
     """
     cell = self.get_merged_cells('A', 'D')
     cell.value = u"Total des frais professionnel à payer"
     cell.style.font.bold = True
     cell.style.font.size = 16
     self.set_color(cell, Color.footer)
     cell = self.get_merged_cells('E', 'E')
     cell.style.font.bold = True
     cell.style.font.size = 16
     cell.value = integer_to_amount(self.model.total)
     cell.style.number_format.format_code = '0.00'
     self.set_color(cell, Color.footer)
     self.index += 2
示例#29
0
    def __json__(self, request):
        """
        Build a Json representation of this object

        :rtype: dict
        """
        return dict(
            id=self.id,
            created_at=self.created_at,
            updated_at=self.updated_at,
            mode=self.mode,
            amount=math_utils.integer_to_amount(self.amount, 5),
            bank_remittance_id=self.bank_remittance_id,
            date=self.date,
            exporter=self.exported,
            task_id=self.task_id,
            bank_id=self.bank_id,
            tva_id=self.tva_id,
            user_id=self.user_id,
        )
示例#30
0
    def __json__(self, request):
        """
        Build a Json representation of this object

        :rtype: dict
        """
        return dict(
            id=self.id,
            created_at=self.created_at,
            updated_at=self.updated_at,
            mode=self.mode,
            amount=math_utils.integer_to_amount(self.amount, 5),
            bank_remittance_id=self.bank_remittance_id,
            date=self.date,
            exporter=self.exported,
            task_id=self.task_id,
            bank_id=self.bank_id,
            tva_id=self.tva_id,
            user_id=self.user_id,
        )
示例#31
0
    def write_table(self, columns, lines):
        """
        write a table with headers and content
        :param columns: list of dict
        :params lines: list of models to be written
        """
        self.write_table_header(columns)
        for line in lines:
            got_value = False

            for column in columns:
                cell = self.get_column_cell(column)

                if column.static:
                    # On récupère les valeurs pour les colonnes fixes
                    value = self.get_formatted_cell_val(
                        line,
                        column,
                    )
                else:
                    # On récupère les valeurs pour les colonnes spécifiques à
                    # chaque type de données

                    # Première passe on essaye de remplir les colonnes pour la
                    # ligne de dépense données en fonction de l'id du type de
                    # dépense associé
                    value = self.get_cell_val(line, column, by_id=True)
                    if value:
                        got_value = True

                cell.value = value
                if column.style:
                    cell.style = column.style

            # Deuxième passe, on a rempli aucune case pour cette ligne on va
            # essayer de remplir les colonnes en recherchant le type de dépense
            # par code
            if not got_value:
                for column in columns:
                    cell = self.get_column_cell(column)

                    if not column.static and not got_value:
                        value = self.get_cell_val(
                            line,
                            column,
                            by_id=False,
                        )
                        if value:
                            got_value = True

                        cell.value = value

                        if column.style:
                            cell.style = column.style

            self.index += 1

        for column in columns:
            cell = self.get_column_cell(column)
            cell.style = FOOTER_CELL

            if not column.static:
                value = column.ht
                cell.value = value

                if value == 0 and not column.force_visible:
                    col_width = 0
                else:
                    col_width = 13
                self.set_col_width(column.start_letter, col_width)

            elif column.key == 'description':
                cell.value = "Totaux"

            elif column.key == 'tva':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_tva', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'total':
                cell.value = integer_to_amount(
                    sum(
                        [line.total for line in lines]
                    )
                )

        self.index += 4
示例#32
0
    def write_table(self, columns, lines):
        """
        write a table with headers and content
        :param columns: list of dict
        :params lines: list of models to be written
        """
        self.write_table_header(columns)
        for line in lines:
            got_value = False

            for column in columns:
                cell = self.get_column_cell(column)

                if column.static:
                    # On récupère les valeurs pour les colonnes fixes
                    value = self.get_formatted_cell_val(
                        line,
                        column,
                    )
                else:
                    # On récupère les valeurs pour les colonnes spécifiques à
                    # chaque type de données

                    # Première passe on essaye de remplir les colonnes pour la
                    # ligne de frais données en fonction de l'id du type de
                    # frais associé
                    value = self.get_cell_val(line, column, by_id=True)
                    if value:
                        got_value = True

                cell.value = value
                if column.style:
                    cell.style = column.style

            # Deuxième passe, on a rempli aucune case pour cette ligne on va
            # essayer de remplir les colonnes en recherchant le type de frais
            # par code
            if not got_value:
                for column in columns:
                    cell = self.get_column_cell(column)

                    if not column.static and not got_value:
                        value = self.get_cell_val(
                            line,
                            column,
                            by_id=False,
                        )
                        if value:
                            got_value = True

                        cell.value = value

                        if column.style:
                            cell.style = column.style

            self.index += 1

        for column in columns:
            cell = self.get_column_cell(column)
            cell.style = FOOTER_CELL

            if not column.static:
                value = column.ht
                cell.value = value

                if value == 0 and not column.force_visible:
                    col_width = 0
                else:
                    col_width = 13
                self.set_col_width(column.start_letter, col_width)

            elif column.key == 'description':
                cell.value = "Totaux"

            elif column.key == 'tva':
                cell.value = integer_to_amount(
                    sum(
                        [
                            getattr(line, 'total_tva', 0) for line in lines
                        ]
                    )
                )

            elif column.key == 'total':
                cell.value = integer_to_amount(
                    sum(
                        [line.total for line in lines]
                    )
                )

        self.index += 4