Stock Request Tier Validation

Name: Team Lead Approval
Model: Stock Request
Sequence: 10
Reviewer: Team Lead group
Domain: [('product_qty', '<=', 50)]
Approve Sequence: False

Name: Department Head Approval  
Model: Stock Request
Sequence: 20
Reviewer: Department Head group
Domain: [('product_qty', '>', 50), ('product_qty', '<=', 500)]
Approve Sequence: True

Name: Manager Approval
Model: Stock Request
Sequence: 30
Reviewer: Stock Request Manager group
Domain: [('product_qty', '>', 500)]
Approve Sequence: True
Comment Required: True

class StockRequest(models.Model):
    _name = 'stock.request'
    _inherit = ['stock.request', 'tier.validation']
    _state_from = ['draft']
    _state_to = ['open']
    
    # Tier validation fields (from tier.validation mixin)
    review_ids = fields.One2many(
        'tier.review',
        'res_id',
        domain=lambda self: [('model', '=', self._name)],
        string='Reviews'
    )
    
    validated = fields.Boolean(
        compute='_compute_validated_rejected',
        string='Validated'
    )
    
    need_validation = fields.Boolean(
        compute='_compute_need_validation',
        string='Need Validation'
    )
    
    reviewer_ids = fields.Many2many(
        'res.users',
        compute='_compute_reviewer_ids',
        string='Reviewers'
    )

class TierReview(models.Model):
    _name = 'tier.review'
    
    model = fields.Char()              # Model name
    res_id = fields.Integer()          # Record ID
    definition_id = fields.Many2one(   # Tier definition
        'tier.definition'
    )
    reviewer_id = fields.Many2one(     # Assigned reviewer
        'res.users'
    )
    status = fields.Selection([        # Review status
        ('pending', 'Pending'),
        ('approved', 'Approved'),
        ('rejected', 'Rejected'),
    ])
    comment = fields.Text()            # Reviewer comment
    review_date = fields.Datetime()    # When reviewed

<header>
    <!-- Request validation button -->
    <button name="request_validation" 
            type="object" 
            string="Request Validation"
            class="oe_highlight"
            attrs="{'invisible': ['|', 
                                  ('need_validation', '=', False),
                                  ('review_ids', '!=', [])]}"/>
    
    <!-- Confirm button (appears after validation) -->
    <button name="action_confirm" 
            type="object" 
            string="Confirm"
            class="oe_highlight"
            attrs="{'invisible': ['|',
                                  ('validated', '=', False),
                                  ('state', '!=', 'draft')]}"/>
</header>

<!-- Reviews tab -->
<page string="Reviews" 
      name="reviews"
      attrs="{'invisible': [('review_ids', '=', [])]}">
    <field name="review_ids" mode="tree">
        <tree>
            <field name="definition_id"/>
            <field name="reviewer_id"/>
            <field name="status" widget="badge"/>
            <field name="review_date"/>
            <field name="comment"/>
        </tree>
    </field>
</page>

<filter name="needs_my_review" 
        string="Needs my Review"
        domain="[('reviewer_ids', 'in', uid)]"/>

# Tier 1
[('product_qty', '<=', 100)]

# Tier 2  
[('product_qty', '>', 100), ('product_qty', '<=', 500)]

# Tier 3
[('product_qty', '>', 500)]

# IT Department requests
Name: IT Manager Approval
Domain: [('requested_by.department_id.name', '=', 'IT')]
Reviewer: IT Manager

# Production requests
Name: Production Supervisor Approval
Domain: [('requested_by.department_id.name', '=', 'Production')]
Reviewer: Production Supervisor

# Hazardous materials
Name: Safety Officer Approval
Domain: [('product_id.categ_id.name', '=', 'Hazardous')]
Reviewer: Safety Officer
Comment Required: True

# High-value items
Name: CFO Approval
Domain: [('product_id.categ_id.name', '=', 'Equipment')]
Reviewer: CFO

# In tier definition, use Python Expression field:

# Check if product cost above threshold
result = record.product_id.standard_price * record.product_qty > 10000

# Check requester's manager
result = record.requested_by.parent_id.id == 5

# Business day check
from datetime import datetime
result = datetime.now().weekday() < 5  # Monday-Friday only

# In tier definition, Reviewer Type = Python Code:

# Assign to requester's manager
result = record.requested_by.parent_id

# Assign to warehouse manager
result = record.warehouse_id.manager_id

# Assign to product category responsible
result = record.product_id.categ_id.manager_id

# Weekend requests need extra approval
from datetime import datetime
result = datetime.now().weekday() >= 5  # Saturday or Sunday

# End of month requests
from datetime import datetime
result = datetime.now().day > 25

# Urgent requests (short lead time)
result = (record.expected_date - fields.Datetime.now()).days < 2

# Find reviews pending for current user
my_pending_reviews = env['tier.review'].search([
    ('model', '=', 'stock.request'),
    ('reviewer_id', '=', env.user.id),
    ('status', '=', 'pending'),
])

# Approve a review
review.write({
    'status': 'approved',
    'review_date': fields.Datetime.now(),
    'comment': 'Approved - within budget',
})

# Check if stock request fully validated
if stock_request.validated:
    stock_request.action_confirm()

class StockRequest(models.Model):
    _inherit = 'stock.request'
    
    def request_validation(self):
        # Custom pre-validation checks
        for request in self:
            if not request.route_id:
                raise UserError("Please select a route before requesting validation.")
        
        # Call original method
        return super().request_validation()

<!-- data/stock_request_tier_definition.xml -->
<record id="tier_definition_stock_request_manager" 
        model="tier.definition">
    <field name="name">Stock Request Manager Approval</field>
    <field name="model_id" ref="stock_request.model_stock_request"/>
    <field name="review_type">group</field>
    <field name="reviewer_group_id" 
           ref="stock_request.group_stock_request_manager"/>
    <field name="sequence">10</field>
</record>