# -*- coding: utf-8 -*- """ diacamma.condominium.system package @author: Laurent GAY @organization: sd-libre.fr @contact: info@sd-libre.fr @copyright: 2018 sd-libre.fr @license: This file is part of Lucterios. Lucterios is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. Lucterios is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Lucterios. If not, see . """ from django.utils.translation import gettext_lazy as _ from lucterios.framework.error import LucteriosException, IMPORTANT, GRAVE from lucterios.CORE.models import Parameter from lucterios.CORE.parameters import Params from lucterios.framework.tools import same_day_months_after, get_date_formating from diacamma.accounting.tools import correct_accounting_code, currency_round, current_system_account from diacamma.accounting.models import ChartsAccount, EntryAccount, EntryLineAccount, Journal, FiscalYear from diacamma.condominium.system.default import DefaultSystemCondo from diacamma.condominium.models import CallFunds, Set, CallDetail class FrenchSystemCondo(DefaultSystemCondo): def initialize_system(self): Parameter.change_value('condominium-default-owner-account', correct_accounting_code('450')) Parameter.change_value('condominium-default-owner-account1', correct_accounting_code('450')) Parameter.change_value('condominium-default-owner-account2', correct_accounting_code('450')) Parameter.change_value('condominium-default-owner-account3', correct_accounting_code('450')) Parameter.change_value('condominium-default-owner-account4', correct_accounting_code('450')) Parameter.change_value('condominium-default-owner-account5', correct_accounting_code('450')) Parameter.change_value('condominium-current-revenue-account', correct_accounting_code('701')) Parameter.change_value('condominium-exceptional-revenue-account', correct_accounting_code('702')) Parameter.change_value('condominium-fundforworks-revenue-account', correct_accounting_code('705')) Parameter.change_value('condominium-exceptional-reserve-account', correct_accounting_code('120')) Parameter.change_value('condominium-advance-reserve-account', correct_accounting_code('103')) Parameter.change_value('condominium-fundforworks-reserve-account', correct_accounting_code('105')) Parameter.change_value('condominium-mode-current-callfunds', 0) Params.clear() def get_config_params(self, new_params): if Params.getvalue("condominium-old-accounting") and not new_params: param_lists = ['condominium-default-owner-account'] else: param_lists = ['condominium-default-owner-account1', 'condominium-default-owner-account2', 'condominium-default-owner-account3', 'condominium-default-owner-account4', 'condominium-default-owner-account5', 'condominium-current-revenue-account', 'condominium-exceptional-revenue-account', 'condominium-fundforworks-revenue-account', 'condominium-exceptional-reserve-account', 'condominium-advance-reserve-account', 'condominium-fundforworks-reserve-account', 'condominium-mode-current-callfunds', 'condominium-payoff-calloffunds'] return param_lists def get_callfunds_list(self, complete=False): callfunds_list = [(0, _('current')), (1, _('exceptional')), (2, _('cash advance')), (4, _('fund for works'))] if complete: callfunds_list.append((3, _('borrowing'))) return callfunds_list def CurrentCallFundsAdding(self, to_create): if to_create: nb_seq = CallFunds.getNbSequence() year = FiscalYear.get_current() for num in range(nb_seq): date = same_day_months_after(year.begin, int(num * 12 / nb_seq)) new_call = CallFunds.objects.create(date=date, comment=_("Call of funds #%(num)d of year from %(begin)s to %(end)s") % {'num': num + 1, 'begin': get_date_formating(year.begin), 'end': get_date_formating(year.end)}, status=0) for category in Set.objects.filter(type_load=0, is_active=True): CallDetail.objects.create(set=category, type_call=0, callfunds=new_call, price=category.get_current_budget() / nb_seq, designation=_("%(type)s - #%(num)d") % {'type': _('current'), 'num': num + 1}) else: year = FiscalYear.get_current() calls = CallFunds.objects.filter(date__gte=year.begin, date__lte=year.end, calldetail__type_call=0, calldetail__set__isnull=False).distinct() return len(calls) == 0 def _generate_account_callfunds_by_type(self, new_entry, type_call, calldetails): detail_account_filter = None if type_call == 0: detail_account_filter = Params.getvalue("condominium-current-revenue-account") if type_call == 1: detail_account_filter = Params.getvalue("condominium-exceptional-reserve-account") if type_call == 2: detail_account_filter = Params.getvalue("condominium-advance-reserve-account") if type_call == 4: detail_account_filter = Params.getvalue("condominium-fundforworks-reserve-account") detail_account = ChartsAccount.get_account(detail_account_filter, new_entry.year) if detail_account is None: raise LucteriosException(IMPORTANT, _("incorrect account for call of found")) total = 0 for calldetail in calldetails: EntryLineAccount.objects.create(account=detail_account, amount=calldetail.price, entry=new_entry, costaccounting=calldetail.set.current_cost_accounting) total += calldetail.price calldetail.entry = new_entry calldetail.save() return total def _generate_revenue_for_expense_oldaccounting(self, expense_detail, is_asset, fiscal_year): revenue_code = expense_detail.set.revenue_account cost_accounting = expense_detail.set.current_cost_accounting revenue_account = ChartsAccount.get_account(revenue_code, fiscal_year) if revenue_account is None: raise LucteriosException(IMPORTANT, _("code account %s unknown!") % revenue_code) price = currency_round(expense_detail.price) new_entry = EntryAccount.objects.create(year=fiscal_year, date_value=expense_detail.expense.date, designation=expense_detail.__str__(), journal=Journal.objects.get(id=Journal.DEFAULT_SELLING)) EntryLineAccount.objects.create(account=revenue_account, amount=is_asset * price, entry=new_entry, costaccounting=cost_accounting) for ratio in expense_detail.expenseratio_set.all(): third_account = expense_detail.expense.get_third_account(current_system_account().get_societary_mask(), fiscal_year, ratio.owner.third) EntryLineAccount.objects.create(account=third_account, amount=ratio.value, entry=new_entry, third=ratio.owner.third) no_change, debit_rest, credit_rest = new_entry.serial_control(new_entry.get_serial()) if not no_change or (abs(debit_rest) > 0.001) or (abs(credit_rest) > 0.001): message = _("Error in accounting generator!") message += "{[br/]} no_change=%s debit_rest=%.3f credit_rest=%.3f" % (no_change, debit_rest, credit_rest) raise LucteriosException(GRAVE, message) expense_detail.entry = new_entry expense_detail.save() def generate_revenue_for_expense(self, expense, is_asset, fiscal_year): if Params.getvalue("condominium-old-accounting"): for detail in expense.expensedetail_set.all(): self._generate_revenue_for_expense_oldaccounting(detail, is_asset, fiscal_year) elif len(expense.expensedetail_set.filter(set__type_load=1)) > 0: total = 0 revenue_code = Params.getvalue("condominium-exceptional-revenue-account") revenue_account = ChartsAccount.get_account(revenue_code, fiscal_year) if revenue_account is None: raise LucteriosException(IMPORTANT, _("code account %s unknown!") % revenue_code) reserve_code = Params.getvalue("condominium-exceptional-reserve-account") reserve_account = ChartsAccount.get_account(reserve_code, fiscal_year) if revenue_account is None: raise LucteriosException(IMPORTANT, _("code account %s unknown!") % reserve_code) new_entry = EntryAccount.objects.create(year=fiscal_year, date_value=expense.expense.date, designation=expense.__str__(), journal=Journal.objects.get(id=Journal.DEFAULT_SELLING)) for detail in expense.expensedetail_set.all(): detail.generate_ratio(is_asset) if detail.set.type_load == 1: cost_accounting = detail.set.current_cost_accounting price = currency_round(detail.price) EntryLineAccount.objects.create(account=revenue_account, amount=is_asset * price, entry=new_entry, costaccounting=cost_accounting) total += price detail.entry = new_entry detail.save() EntryLineAccount.objects.create(account=reserve_account, amount=-1 * is_asset * total, entry=new_entry) no_change, debit_rest, credit_rest = new_entry.serial_control(new_entry.get_serial()) if not no_change or (abs(debit_rest) > 0.001) or (abs(credit_rest) > 0.001): message = _("Error in accounting generator!") message += "{[br/]} no_change=%s debit_rest=%.3f credit_rest=%.3f" % (no_change, debit_rest, credit_rest) raise LucteriosException(GRAVE, message)