<?php
// https://twitter.com/snippetbucket
include_once 'openerp.class.php';
print "<pre/>\nOpenERP PHP connector : It support version 6 and 7++ <br/>\n Author : Tejas Tank, Tejas.tank.mca@gmail.com\n";
print "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n";
$rpc = new OpenERP();
$x = $rpc->login("admin", "a", "mobile_client", "http://127.0.0.1:8069/xmlrpc/");
print $x;
#echo $rpc->create( array('name'=>'teja22s', 'code'=> "bakbak"), "res.country");
//echo $rpc->create( array('name'=>'teja22s', 'login'=> "bakbak"), "res.users");
//print_r($rpc->get_fields('sale.order'));
//print_r($rpc->get_default_values('sale.order'));
$data = $rpc->read(array(1, 2), array(), "product.product");
#$data = $rpc->searchread( array(array('name','=','Service')), "product.product"); // CORRECT
//$data = $rpc->searchread( array(array('email','!=','')), "res.partner"); // CORRECT
##$data = $rpc->read(array(1,2,3,4,5,6,7,8,9), array(), "res.users");
##foreach($data as $p){
## echo "{$p[name]},{$p[phone]},{$p[email]} {$p[login]} {$p[password]}<br/>";
##}
/////print $partners = $x->unlink(array(19), "res.partner");
<div class="container">
<div class="in">
<div class="alert alert-info">
<center>
<strong>AVISO:</strong>
</center>
<br>
Estimado usuario le informamos que a partir del 15 de agosto de 2016 la
oficina del Registro Público de la Propiedad de Dolores Hidalgo, C. I. N.,
Gto., estará ubicada en Calle Rivera del Rio Norte #55-A, Colonia Centro,
de dicha ciudad" </div> "</strong></center>
<?php
$rpc = new OpenERP();
$rpc->login("admin", "admin", "registro8", "localhost:8069/xmlrpc/");
//---------------------------------------------------------------//
$domain = array();
$office_ids = $rpc->search('registros.directorio', $domain);
// READ-----
$fields = array('id', 'responsable_id', 'municipio_id', 'municipio_ids', 'domicilio_id', 'telefono_rp', 'tel_particular', 'correo');
$result = $rpc->read($office_ids, $fields, "registros.directorio");
echo "\n <div class='table-responsive banner-content'>\n <table class='table table-striped'>\n <thead>\n <tr>\n <th> REGISTRADOR </th>\n <th>OFICINA</th>\n <th>DOMICILIO </th>\n <th>TEL. REGISTRO PÚBLICO </th>\n <th>CORREO</th>\n <th>PARTIDO JUDICIAL</th>\n </tr>\n <thead/>\n <tbody>";
foreach ($result as $p) {
$responsable = $rpc->read(array($p['responsable_id'][0]), array('name'), "res.users");
$municipio = $rpc->read(array($p['municipio_id'][0]), array('name'), "municipio");
$domicilio = $rpc->read(array($p['domicilio_id'][0]), array('name'), "registros.domicilio");
$pjudicial = $rpc->read($p['municipio_ids'], array('name'), "municipio");
echo "<tr>";
echo "<td>" . $responsable[0]['name'] . "</td>";
echo "<td>" . $municipio[0]['name'] . "</td>";
echo "<td>" . $domicilio[0]['name'] . "</td>";
echo "<td>" . $p['telefono_rp'] . "</td>";
<?php
include_once 'openerp.class.php';
$rpc = new OpenERP();
$rpc->login("admin", "admin", "registro", "localhost:8069/xmlrpc/");
// SEARCH
$filter = array(array('name', 'ilike', 'andrea'));
$partner_by_name_ids = $rpc->search('res.partner', $filter);
echo 'SEARCH PARTNERS BY NAME IDS:<br />';
print_r($partner_by_name_ids);
$new_filter = array(array('id', '>', 100), array('id', '<', 120));
$partner_by_id_ids = $rpc->search('res.partner', $new_filter);
echo 'SEARCH PARTNERS BY ID IDS:<br />';
print_r($partner_by_id_ids);
// READ
$fields = array('id', 'name', 'ref');
$partners = $rpc->read($partner_by_name_ids, $fields, "res.partner");
echo 'READ PARTNERS:<br />';
foreach ($partners as $p) {
echo $p['ref'] . ' - ' . $p['name'] . '<br />';
}
// CREATE
$vals = array('name' => new xmlrpcval('John Doe', "string"), 'phone' => new xmlrpcval('000-45679845697', "string"));
$new_partner_id = $rpc->create($vals, "res.partner");
// CALL ON_CHANGHE FUNCTION
// Call the onchange_partner_id function in sale.order for order with id 6 and partner_id 7
$ids = array(6);
$vals = array('part' => array(7, 'int'));
$res = $rpc->call_function('sale.order', 'onchange_partner_id', $ids, $vals);
$res_val = $res->structmem('value');
$user_id = $res_val->structmem('user_id')->scalarval();
* @Contact : https://www.linkedin.com/profile/view?id=112839004
*
*
*/
/*
https://www.odoo.com/documentation/8.0/api_integration.html#connection
*/
include_once 'openerp.class.php';
$config = (include 'config.php');
$conn = new mysqli($config['dbhost'], $config['dbuser'], $config['dbpassword'], $config['dbname']);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "\nConnected successfully\n\n";
$rpc = new OpenERP();
$x = $rpc->login("admin", "m1e2s3h4-", "meshcom", $config['odoourl'] . "xmlrpc/2/");
sync_user($conn, $rpc);
//sync_operator($conn,$rpc);
create_contract($conn, $rpc);
update_contract($conn, $rpc);
die;
function sync_operator(&$conn, &$rpc)
{
echo "Sincronizzo operatori \n";
$operator = (include 'config.operator.php');
foreach ($operator as $key => $value) {
$sql = "SELECT * FROM `operator_users` WHERE `operator_id` =" . $key;
$ids = mysqli_query($conn, $sql) or die("\nError 01: " . mysql_error() . "\n");
while ($row = mysqli_fetch_object($ids)) {
if ($row->user_id == "") {
<?php
//Conector Odoo-PHP
//---------------------------------------------------------------//
include_once '../openerp.class.php';
$rpc = new OpenERP();
$rpc->login("admin", "admin", "registro", "localhost:8069/xmlrpc/");
//---------------------------------------------------------------//
// SEARCH
$domain = array();
$users_directory = array(array('directorio', 'like', 'res.users'));
$office_ids = $rpc->search('registros.directorio', 'partido.judicial', $domain, $users_directory);
echo 'Resultado del SEARCH:<br />';
print_r($office_ids);
echo "<br/>";
// READ-----
$fields = array('id', 'name', 'municipio_id', 'telefono_rp', 'tel_particular', 'correo');
$result = $rpc->read($office_ids, $fields, "registros.directorio", "partido.judicial");
echo 'Resultado del READ:<br />';
echo "<table> <thead> <tr><th> Nombre </th> <th>municipio_id</th> <th>telefono_rp </th> \n <th>tel_particular </th> <th>correo </th> </tr><thead/>\n <tbody>";
foreach ($result as $p) {
echo "<tr>";
echo "<td>" . $p['name'] . "</td>" . "<td>" . $p['municipio_id'][0] . "</td>" . "<td>" . $p['telefono_rp'] . "</td>" . "<td>" . $p['tel_particular'] . "</td>" . "<td>" . $p['correo'] . "</td>";
echo "</tr>";
}
echo "</tbody>, </table>";
$new_filter = array('municipio_id');
$oficina_id = $rpc->search('partido.judicial', $new_filter);
echo 'Busqueda de Oficinas por Nombre:<br />';
print_r($oficina_id);
// READ
