Skip to content

Instantly share code, notes, and snippets.

@HarshalBhoir
Forked from ilyasProgrammer/xml_rpc.py
Created May 28, 2020 06:58
Show Gist options
  • Save HarshalBhoir/96e3b42435e3eba5306a05fc4a92f627 to your computer and use it in GitHub Desktop.
Save HarshalBhoir/96e3b42435e3eba5306a05fc4a92f627 to your computer and use it in GitHub Desktop.
Odoo xml rpc example
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})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment