Wasting $52K on Slow Dev? Call JSON RPC in Odoo 18 Web Controllers

from odoo import http
from odoo.http import request


class ProductController(http.Controller):
    """Controller for product-related JSON RPC calls."""
    
    @http.route('/my/get_products', type='json', auth='user', methods=['POST'])
    def get_products(self, category_id=None, limit=10):
        """
        Fetch products from database.
        
        Args:
            category_id (int, optional): Filter by category
            limit (int): Maximum products to return
            
        Returns:
            dict: {'success': True, 'products': [...]}
        """
        try:
            # Build domain filter
            domain = []
            if category_id:
                domain.append(('categ_id', '=', category_id))
            
            # Query products
            products = request.env['product.product'].search(
                domain,
                limit=limit,
                order='name'
            )
            
            # Format response
            product_list = []
            for product in products:
                product_list.append({
                    'id': product.id,
                    'name': product.name,
                    'price': product.list_price,
                    'qty_available': product.qty_available,
                    'image_url': f'/web/image/product.product/{product.id}/image_128'
                })
            
            return {
                'success': True,
                'products': product_list,
                'count': len(product_list)
            }
            
        except Exception as e:
            return {
                'success': False,
                'error': str(e)
            }

from . import main

from . import controllers
from . import models

/** @odoo-module **/

import { rpc } from "@web/core/network/rpc";

// Simple RPC call
async function loadProducts() {
    try {
        const result = await rpc('/my/get_products', {
            category_id: 5,
            limit: 20
        });
        
        if (result.success) {
            console.log('Products loaded:', result.products);
            console.log('Count:', result.count);
            
            // Use product data
            displayProducts(result.products);
        } else {
            console.error('Error:', result.error);
        }
    } catch (error) {
        console.error('RPC failed:', error);
    }
}

function displayProducts(products) {
    const container = document.querySelector('#product-list');
    
    products.forEach(product => {
        const productHTML = `
            

                
                
${product.name}
                
Price: $${product.price}
                
Stock: ${product.qty_available}
            
        `;
        container.innerHTML += productHTML;
    });
}

/** @odoo-module **/

import publicWidget from "@web/legacy/js/public/public_widget";
import { rpc } from "@web/core/network/rpc";

publicWidget.registry.ProductLoader = publicWidget.Widget.extend({
    selector: '.o_product_widget',
    events: {
        'click .load-products-btn': '_onLoadProducts',
        'change .category-filter': '_onCategoryChange',
    },
    
    start: function () {
        // Initialize widget
        return this._super(...arguments).then(() => {
            // Load products on page load
            this._loadProducts();
        });
    },
    
    async _loadProducts(categoryId = null) {
        const $loader = this.$('.product-loader');
        $loader.show();
        
        try {
            const result = await rpc('/my/get_products', {
                category_id: categoryId,
                limit: 50
            });
            
            if (result.success) {
                this._renderProducts(result.products);
            } else {
                this._showError(result.error);
            }
        } catch (error) {
            this._showError('Failed to load products');
        } finally {
            $loader.hide();
        }
    },
    
    _renderProducts: function (products) {
        const $container = this.$('.product-list');
        $container.empty();
        
        products.forEach(product => {
            const $productCard = $(`
                

                    

                        
                        

                            
${product.name}
                            
$${product.price}
                            
                                Add to Cart
                            
                        
                    
                
            `);
            $container.append($productCard);
        });
    },
    
    _onLoadProducts: function (ev) {
        ev.preventDefault();
        this._loadProducts();
    },
    
    _onCategoryChange: function (ev) {
        const categoryId = parseInt($(ev.currentTarget).val());
        this._loadProducts(categoryId);
    },
    
    _showError: function (message) {
        alert('Error: ' + message);
    }
});

export default publicWidget.registry.ProductLoader;

@http.route('/my/create_lead', type='json', auth='public', methods=['POST'])
def create_lead(self, name, email, phone, message):
    """Create CRM lead from contact form."""
    try:
        lead = request.env['crm.lead'].sudo().create({
            'name': name,
            'email_from': email,
            'phone': phone,
            'description': message,
            'type': 'lead',
        })
        
        return {
            'success': True,
            'lead_id': lead.id,
            'message': 'Thank you! We will contact you soon.'
        }
    except Exception as e:
        return {
            'success': False,
            'error': 'Failed to submit form. Please try again.'
        }

async function submitContactForm(event) {
    event.preventDefault();
    
    const formData = {
        name: document.querySelector('#name').value,
        email: document.querySelector('#email').value,
        phone: document.querySelector('#phone').value,
        message: document.querySelector('#message').value,
    };
    
    const submitBtn = document.querySelector('.submit-btn');
    submitBtn.disabled = true;
    submitBtn.textContent = 'Submitting...';
    
    try {
        const result = await rpc('/my/create_lead', formData);
        
        if (result.success) {
            alert(result.message);
            document.querySelector('#contact-form').reset();
        } else {
            alert(result.error);
        }
    } catch (error) {
        alert('Network error. Please try again.');
    } finally {
        submitBtn.disabled = false;
        submitBtn.textContent = 'Submit';
    }
}

@http.route('/my/dashboard_stats', type='json', auth='user', methods=['POST'])
def get_dashboard_stats(self):
    """Get real-time dashboard statistics."""
    user = request.env.user
    
    # Calculate stats
    open_leads = request.env['crm.lead'].search_count([
        ('user_id', '=', user.id),
        ('type', '=', 'lead'),
        ('active', '=', True)
    ])
    
    won_opportunities = request.env['crm.lead'].search_count([
        ('user_id', '=', user.id),
        ('type', '=', 'opportunity'),
        ('stage_id.is_won', '=', True)
    ])
    
    total_revenue = sum(request.env['sale.order'].search([
        ('user_id', '=', user.id),
        ('state', '=', 'sale')
    ]).mapped('amount_total'))
    
    return {
        'success': True,
        'stats': {
            'open_leads': open_leads,
            'won_opportunities': won_opportunities,
            'total_revenue': total_revenue,
            'username': user.name,
        }
    }

class DashboardWidget {
    constructor() {
        this.refreshInterval = null;
        this.init();
    }
    
    init() {
        this.loadStats();
        // Auto-refresh every 30 seconds
        this.refreshInterval = setInterval(() => {
            this.loadStats();
        }, 30000);
    }
    
    async loadStats() {
        try {
            const result = await rpc('/my/dashboard_stats', {});
            
            if (result.success) {
                this.updateUI(result.stats);
            }
        } catch (error) {
            console.error('Failed to load stats:', error);
        }
    }
    
    updateUI(stats) {
        document.querySelector('#open-leads').textContent = stats.open_leads;
        document.querySelector('#won-opps').textContent = stats.won_opportunities;
        document.querySelector('#total-revenue').textContent = 
            `$${stats.total_revenue.toLocaleString()}`;
        document.querySelector('#username').textContent = stats.username;
    }
    
    destroy() {
        if (this.refreshInterval) {
            clearInterval(this.refreshInterval);
        }
    }
}

// Initialize dashboard
const dashboard = new DashboardWidget();