nvn-odoo

-- CHECK DIFF BEWEEN TWO DATABASES (A and B) 
-----------------------------------------------

/*********************************************
 * 1.0 CREATE THE APPROPRIATE CONFIGURATION
 *********************************************/

-- create a new database AB (from terminal)

nvn-odoo

DO
$do$
declare
	v_product_product_id int;
	v_product_category_id int;
    v_product_name varchar;
	v_stock_valuation_account int;
	v_company_id int;
	v_stock_qty_with_date float;

nvn-odoo

#!/bin/bash

# This tool creates a database $3 from database $1 and database $2
# database $1 will ends in the schema a
# database $2 will ends in the schema b
# this will allow comparisons between two schemas in the same database

if [ "$1" = "" ]; then
  echo "USAGE: $0 <DBNAME_A> <DBNAME_B> <DBNAME_AB>" >&2
  exit 1

nvn-odoo

##################################################
#            Fix landed cost issues
###################################################

counterpart_account_id_original = 1080
am_prefix = '[MIG:FIX LC]' # prefix to add to the created account_moves
aml_prefix = '[MIG:FIX LC]' # prefix to add to the created account_move_lines

def fix_it(cr, version):
    """ Fix wrong landed cost

nvn-odoo

#!/bin/bash

set -e

command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }

MAX_CMD_TRIES=100

BASE_WORK_DIR=${HOME}/odoo_upgrade_request

nvn-odoo

// use cjs to run javascript on pages.

String.prototype.replaceAll = function(search, replacement) {
    var target = this;
    return target.replace(new RegExp(search, 'g'), replacement);
};

setInterval(function(){ 
    $('.o_thread_message_content').each(function(i, el) {
      if($(el).html() !== "" ) {

nvn-odoo

quants = env['stock.quant'].search([])
move_line_ids = []
warning = ''
for quant in quants:
    move_lines = env["stock.move.line"].search([
        ('product_id', '=', quant.product_id.id),
        ('location_id', '=', quant.location_id.id),
        ('lot_id', '=', quant.lot_id.id),
        ('package_id', '=', quant.package_id.id),
        ('owner_id', '=', quant.owner_id.id),

nvn-odoo

quants = env['stock.quant'].search([])
move_line_ids = []

warning = ''
for quant in quants:
    move_lines = env["stock.move.line"].search([
        ('product_id', '=', quant.product_id.id),
        ('location_id', '=', quant.location_id.id),
        ('lot_id', '=', quant.lot_id.id),
        ('package_id', '=', quant.package_id.id),

nvn-odoo

#!/bin/bash

set -e

command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }

# REQUIRED PARAMETERS:
REQUEST_ID="17654"
KEY="0zWIetJPo7kIWSxVWKUDTQ=="

nvn-odoo

#!/bin/bash

set -e

command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }

MAX_CMD_TRIES=100

BASE_WORK_DIR=${HOME}/odoo_upgrade