<?php
        // Ripcord can be cloned from https://github.com/poef/ripcord
        require_once('ripcord/ripcord.php');

        // Login information
        $url = 'http://localhost:8069';
        $url_auth = $url . '/xmlrp/common';
        $url_exec = $url . '/xmlrpc/object';

        $db = 'openerp';
        $username = 'admin';
        $password = 'admin';

        // Login
        $common = ripcord::client("$url/xmlrpc/common");

        //$common = ripcord::client($url_auth);
        $uid = $common->authenticate($db, $username, $password, array());


        $models = ripcord::client($url_exec);

        include "config.php";
        $sql = "SELECT so.id as id,
                       so.cust_id,
                       so.numb,
                       p.ktr,
                       p.store_id,
                       so.write_date,
                       p.store_name,
                       p.sales_id
                FROM sales_order so
                INNER JOIN store p on p.store_id = so.store_id
               ";

        $exec = pg_query($sql);

        while ($row = pg_fetch_array($exec)){

            $query = pg_query(
                "SELECT sod.product_id, sod.qty_sales, p.name
                               FROM sales_order_line sod
                               INNER JOIN product p on p.id = sod.product_id
                               WHERE sales_order_id = ".$row['id']
            );

            while ($data = pg_fetch_array($query)) {

                $id = $models->execute_kw($db, $uid, $password,
                    'sale.order', 'create',
                    array(array(
                        'partner_id' => $row['store_id'],
                        'sales_id' => $row['sales_id'],
                        'order_line' => [array(
                            0, false, array(
                                'product_id' => $data['product_id'],
                                'name' => $data['name'],
                                'qty' => $data['quantity'])
                        )]
                    )));

                var_dump($id);

            }
        }
    ?>