Odoo xml rpc example

xml_rpc.py

import xmlrpclib
from datetime import datetime

# url = "http://localhost:8069"
# db = "RAJO"
# username = 'a'
# password = 'a'
url = "https://erp.atlantis-kw.com"
db = "RAJO_TEST"
username = 'api'
password = 'api'
common = xmlrpclib.ServerProxy('{}/xmlrpc/2/common'.format(url))
uid = common.authenticate(db, username, password, {})
models = xmlrpclib.ServerProxy('{}/xmlrpc/2/object'.format(url))


class Partners():
    def read(self):
        # Read customers
        model_name = 'res.partner'
        partner_ids = models.execute_kw(db, uid, password, model_name, 'search', [[['customer', '=', True]]])
        partner_records = models.execute_kw(db, uid, password, model_name, 'read', [partner_ids])
        return partner_records

    def create(self):
        # Create customer
        model_name = 'res.partner'
        vals = {
            'name': "New Customer",
        }
        new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
        return new_id

    def update(self, id):
        # Update customer
        model_name = 'res.partner'
        models.execute_kw(db, uid, password, model_name, 'write', [[id], {
            'name': "Newer partner"
        }])


class Product():
    # Read product
    def read(self):
        model_name = 'product.product'
        product = models.execute_kw(db, uid, password, model_name, 'search_read', [[]], {'limit': 1})[0]


class Candidate():
    def read(self):
        # # Read candidate
        model_name = 'rajo.candidate'
        candidate = models.execute_kw(db, uid, password, model_name, 'search_read', [[]], {'limit': 1})[0]


class SaleOrder():
    def read(self):
        # Read sale order
        model_name = 'sale.order'
        order_ids = models.execute_kw(db, uid, password, model_name, 'search', [[]])
        order_records = models.execute_kw(db, uid, password, model_name, 'read', [order_ids])

    def create(self, partner_id, candidate_id, line_name, product_id):
        # Create sale order
        model_name = 'sale.order'
        vals = {
            'origin': "A555",
            'client_order_ref': "B555",
            'partner_id': partner_id,  # api partner
            'pricelist_id': 1,  # Public Pricelist (KWD)
            'partner_invoice_id': partner_id,
            'partner_shipping_id': partner_id,
            'order_line': [(0, 0, {
                'name': line_name,
                'product_id': product_id,
                'product_uom_qty': 2,
                'qty_delivered': 2,
                'price_unit': 1000.00,
                'candidate_id': candidate_id,
            })]
        }
        new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
        return new_id


class Ticket():
    def read(self):
        # Read ticket
        model_name = 'helpdesk.ticket'
        tickets = models.execute_kw(db, uid, password, model_name, 'search_read', [[['partner_id', '=', partner['id']]]])

    def create(self, partner_id, candidate_id):
        # Create ticket
        model_name = 'helpdesk.ticket'
        vals = {
            'name': "Test ticket",
            'partner_id': partner_id,
            'candidate_id': candidate_id,
        }
        new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
        return new_id


class Payment():
    def create(self, sale_order_id):
        # Create invoice and register payment
        model_name = 'sale.order'
        models.execute_kw(db, uid, password, model_name, 'action_confirm', [[sale_order_id]])
        new_invoice_id = models.execute_kw(db, uid, password, model_name, 'action_invoice_create', [[sale_order_id]])
        model_name = 'account.invoice'
        models.execute_kw(db, uid, password, model_name, 'action_invoice_open', new_invoice_id)
        ctx = {'active_model': 'account.invoice', 'active_ids': new_invoice_id}
        vals = {
            'payment_date': str(datetime.now()),
            'journal_id': 7,  # Bank journal ID
            'payment_method_id': 1,  # manual
            'amount': 2000.00,
        }
        model_name = 'account.register.payments'
        registered_payment_id = models.execute_kw(db, uid, password, model_name, 'create', [vals], {'context': ctx})
        models.execute_kw(db, uid, password, model_name, 'create_payment', [[registered_payment_id]], {'context': ctx})

jos

Jos Orang Purwantoro

I am not able to create invoices ,here is my code (odoo 14)
s = models.execute_kw(db, uid, password, 'sale.order', 'create', [{
'partner_id': 1, 'validity_date': "2021-08-09",
'order_line': [(0, 0, {'product_id': 2, 'product_uom_qty': 2, 'price_unit': 10.00}),
(0, 0, {'product_id': 5, 'product_uom_qty': 4, 'price_unit': 20.00}),
],
}])
models.execute_kw(db, uid, password, 'sale.order', 'action_confirm', [[s]])

models.execute_kw(db, uid, password, 'sale.advance.payment.inv', 'write', [[s], {
'advance_payment_method': 'delivered',
}])

new = models.execute_kw(db, uid, password, 'sale.advance.payment.inv', 'create_invoices', [[s]])

Work in Odoo 15
Expept payment_method_id and amount in val

  def payment(self, invoice_id=None):

      context = {
          'active_model': 'account.move',
          'active_ids': invoice_id,
      }

      values = {
          'payment_date': datetime.now().strftime("%Y-%m-%d"),
          'journal_id': 7,  # Bank journal ID
      }
          # 'payment_method_id': 1,  # manual
          # 'amount': 2000.00,

      model_name = 'account.payment.register'
      registered_payment_id = self.models.execute_kw(
          self.db, self.uid, self.apikey, model_name, 'create', [values], {'context': context})

      payment = self.models.execute_kw(
          self.db, self.uid, self.apikey, model_name, 'action_create_payments', [[registered_payment_id]], {'context': context})

      query = self.read('account.move', id=invoice_id, fields=['id', 'payment_state'] )
      invoice = query[0]

      return invoice['payment_state']

Used here :

https://github.com/TiBillet/TiBillet-Odoo-module/blob/main/extra-addons/tibillet/controllers/controllers.py