David Amsellem

from odoo import models, fields, api
from odoo.exceptions import ValidationError


class ResPartnerExtended(models.Model):
    _inherit = 'res.partner'

    x_segment    = fields.Selection([
        ('enterprise', 'Enterprise'),
        ('sme',        'PYME'),
        ('startup',   'Startup'),
    ], string='Segmento')
    x_arr        = fields.Float(string='ARR (€)', compute='_compute_arr', store=True)
    x_sla_level  = fields.Selection([
        ('basic',    'Basic'),
        ('premium',  'Premium'),
        ('critical', 'Critical 24/7'),
    ], string='SLA', default='basic')

    @api.depends('sale_order_ids.amount_total')
    def _compute_arr(self):
        for rec in self:
            rec.x_arr = sum(rec.sale_order_ids.mapped('amount_total'))

    @api.constrains('x_sla_level', 'x_segment')
    def _check_sla_segment(self):
        for rec in self:
            if rec.x_sla_level == 'critical' and rec.x_segment == 'startup':
                raise ValidationError(
                    "Las startups no pueden tener SLA Critical."
                )

import express     from 'express'
import OdooClient  from '../lib/odoo.js'
import { auth }    from '../middleware/auth.js'

const router = express.Router()
const odoo   = new OdooClient(process.env.ODOO_URL)

/** GET /api/partners?segment=enterprise */
router.get('/', auth, async (req, res) => {
  const { segment, page = 1, limit = 20 } = req.query

  const domain = segment
    ? [['x_segment', '=', segment]]
    : []

  const [records, total] = await Promise.all([
    odoo.searchRead('res.partner', domain, {
      fields: ['name', 'email', 'x_segment', 'x_arr'],
      offset: (page - 1) * limit,
      limit:  +limit,
    }),
    odoo.searchCount('res.partner', domain),
  ])

  res.json({ records, total, page: +page, pages: Math.ceil(total / limit) })
})

export default router