from app.backend.db.models import HealthModel, RegimeModel, EmployeeLaborDatumModel, SocialLawModel, EmployeeLaborDatumModel, PayrollEmployeeModel from app.backend.classes.payroll_item_value_class import PayrollItemValueClass from app.backend.classes.medical_license_class import MedicalLicenseClass from app.backend.classes.helper_class import HelperClass class SocialLawClass: def __init__(self, db): self.db = db def get_totals(self, period): # Obtener todos los empleados de nómina para el período dado payroll_employees = self.db.query(PayrollEmployeeModel).filter(PayrollEmployeeModel.period == period).order_by('rut').all() # Inicializar un diccionario para almacenar los totales de cada empleado totals_dict = {} # Iterar sobre los empleados de nómina for payroll_employee in payroll_employees: # Inicializar totales para este empleado medical_license_total = 0 entrance_total = 0 exit_total = 0 absenteeism_total = 0 total_days = 0 # Calcular total de licencia médica para este empleado medical_license_total = MedicalLicenseClass(self.db).how_many_medical_license_days(payroll_employee.rut, period) # Calcular total de días de entrada para este empleado entrance_total = HelperClass.how_many_entrance_days(payroll_employee.entrance_company) exit_total = HelperClass.how_many_exit_days(payroll_employee.exit_company) date = HelperClass().split(str(period), "-") last_day_month = HelperClass.full_last_day_month(date[0], date[1]) payroll_item_value = PayrollItemValueClass(self.db).get_with_period(payroll_employee.rut, 13, period) if payroll_item_value is not None: absenteeism_total = payroll_item_value.amount else: absenteeism_total = 0 total_days = last_day_month - medical_license_total - entrance_total - exit_total - absenteeism_total if total_days < 0: total_days = 0 if medical_license_total > 0 or entrance_total > 0 or exit_total > 0: totals_dict[payroll_employee.id] = { 'rut': payroll_employee.rut, 'names': payroll_employee.names, 'father_lastname': payroll_employee.father_lastname, 'mother_lastname': payroll_employee.mother_lastname, 'visual_rut': payroll_employee.visual_rut, 'medical_license_total': medical_license_total, 'entrance_total': entrance_total, 'exit_total': exit_total, 'absenteeism_total': absenteeism_total, 'total_days': total_days } # Retornar los totales para todos los empleados return totals_dict def movements(self, period): # Obtener todos los empleados de nómina para el período dado payroll_employees = self.db.query(PayrollEmployeeModel).filter(PayrollEmployeeModel.period == period).order_by('rut').all() # Inicializar un diccionario para almacenar los totales de cada empleado totals_dict = {} # Iterar sobre los empleados de nómina for payroll_employee in payroll_employees: # Inicializar totales para este empleado medical_license_total = 0 entrance_total = 0 exit_total = 0 absenteeism_total = 0 total_days = 0 date = HelperClass().split(str(period), "-") last_day_month = HelperClass.last_day_month(date[0], date[1]) # Calcular total de licencia médica para este empleado medical_license_total = MedicalLicenseClass(self.db).how_many_medical_license_days(payroll_employee.rut, period) if last_day_month == 28: medical_license_total = (medical_license_total - last_day_month) + 2 elif last_day_month == 29: medical_license_total = (medical_license_total - last_day_month) + 1 elif last_day_month == 31: medical_license_total = (medical_license_total - last_day_month) - 1 # Calcular total de días de entrada para este empleado entrance_total = HelperClass.how_many_entrance_days(payroll_employee.entrance_company) exit_total = HelperClass.how_many_exit_days(payroll_employee.exit_company) if exit_total == last_day_month: exit_total = 0 payroll_item_value = PayrollItemValueClass(self.db).get_with_period(payroll_employee.rut, 13, period) if payroll_item_value is not None: absenteeism_total = payroll_item_value.amount else: absenteeism_total = 0 total_days = last_day_month - medical_license_total - entrance_total - exit_total - absenteeism_total if total_days < 0: total_days = 0 payroll_item_value_data = {} payroll_item_value_data['item_id'] = 55 payroll_item_value_data['rut'] = payroll_employee.rut payroll_item_value_data['period'] = period payroll_item_value_data['amount'] = total_days PayrollItemValueClass(self.db).store(payroll_item_value_data) def store(self, period): try: social_laws = self.db.query(SocialLawModel).filter(SocialLawModel.period == period).all() for social_law in social_laws: employee_labor_data = self.db.query(EmployeeLaborDatumModel).filter(EmployeeLaborDatumModel.rut == social_law.rut).first() payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 70, period) regime = self.db.query(RegimeModel).filter(RegimeModel.id == employee_labor_data.regime_id).first() disability_insurance_quote = payroll_item_value.amount payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 4, period) pention_voluntary_savings = payroll_item_value.amount payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 41, period) health = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 29, period) extra_health = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 24, period) ccaf_personal_credit = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 71, period) ccaf_secure_life = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 72, period) ccaf_leasing_discount = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 73, period) ccaf_no_isapre_affiliate_quote = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 10, period) ccaf_family_discount_members = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 74, period) mutuality_value = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 30, period) worker_unemployment_insurance = payroll_item_value payroll_item_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 61, period) employer_unemployment_insurance = payroll_item_value health_data = self.db.query(HealthModel).filter(HealthModel.id == employee_labor_data.health_id).first() taxable_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 38, period) pention_value = PayrollItemValueClass(self.db).get_with_period(social_law.rut, 59, period) social_law_employee = self.db.query(SocialLawModel).filter(SocialLawModel.rut == social_law.rut).first() social_law_employee.pention_taxable_income = taxable_value.value social_law_employee.pention_mandatory_contribution = pention_value.value social_law_employee.disability_insurance_quote = disability_insurance_quote.value social_law_employee.pention_voluntary_savings = pention_voluntary_savings.value social_law_employee.apvi_number_contract = 1 social_law_employee.apvi_payment_type = 1 social_law_employee.apvc_payment_type = 1 social_law_employee.voluntary_affiliate_movement_code = social_law.movement_code social_law_employee.voluntary_affiliate_since_date = social_law.period_since social_law_employee.voluntary_affiliate_since_date = social_law.period_until social_law_employee.number_quote_periods = 1 social_law_employee.ips_isl_fonasa_taxable_value = social_law.taxable_value if employee_labor_data.regime_id == 1: social_law_employee.ex_cashier_regime_code = regime.social_law_code if employee_labor_data.health_id == 2: social_law_employee.fonasa_health_quote = health.value social_law_employee.health_institution_code = health_data.social_law social_law_employee.plan_payment_type = 1 else: social_law_employee.isapre_taxable_value = 0 social_law_employee.health_institution_code = health_data.social_law social_law_employee.plan_payment_type = 2 social_law_employee.isapre_quote = employee_labor_data.extra_health_amount social_law_employee.isapre_mandatory_quote = health.amount social_law_employee.isapre_aditional_quote = extra_health.amount social_law_employee.ccaf_code = 1 social_law_employee.ccaf_taxable_value = social_law.taxable_value social_law_employee.ccaf_personal_credit = ccaf_personal_credit.amount social_law_employee.ccaf_secure_life = ccaf_secure_life.amount social_law_employee.ccaf_leasing_discount = ccaf_leasing_discount.amount social_law_employee.ccaf_no_isapre_affiliate_quote = ccaf_no_isapre_affiliate_quote.amount social_law_employee.ccaf_family_discount_members = ccaf_family_discount_members.amount social_law_employee.mutuality_code = 1 social_law_employee.mutuality_taxable_code = social_law.taxable_value social_law_employee.mutuality_work_accident = mutuality_value.amount social_law_employee.unemployment_insurance_taxable_value = social_law.taxable_value social_law_employee.unemployment_insurance_employee_quote = worker_unemployment_insurance.amount social_law_employee.unemployment_insurance_employeer_quote = employer_unemployment_insurance.amount if social_law.movement_code == 3: social_law_employee.subsidy_payer_rut = health_data.rut social_law_employee.subsidy_payer_dv = health_data.dv self.db.add(social_laws) self.db.commit() return social_law_employee.id except Exception as e: error_message = str(e) return f"Error: {error_message}"