ovnicraft

import os
from abc import ABC, abstractmethod
from base64 import b64encode, b64decode
from secrets import randbelow
from enum import Enum

from datetime import datetime


from OpenSSL.crypto import X509Name, load_pkcs12, FILETYPE_PEM, FILETYPE_ASN1

ovnicraft

#!/bin/bash

ODOO_VERSION=12.0
ODOO_ROOT=~/development/odoo/$ODOO_VERSION/odoo
ODOO_BIN=odoo-bin
ADDONS_PATH=$ODOO_ROOT/addons

for d in $(ls -1d */); do
    ADDONS_PATH=$ADDONS_PATH,$(pwd)/$d
done

ovnicraft

id	auth_inv_id/id	date_invoice	partner_id/id_hola	partner_id/id	internal_inv_number	reference	invoice_line_ids/name	No FACTURA 	invoice_line_ids/quantity	invoice_line_ids/price_unit	invoice_line_ids/account_id/id	account_id
000082016	__export__.account_authorisation_318	2019-01-09	1719032920	1719032920	000082016	000082016	Venta: 000082016	1001000082016	1	55,00	__export__.account_account_1781	4118001

ovnicraft

how to configure queue_job in Odoo.sh

Edit /home/odoo/.config/odoo/odoo.conf

...
server_wide_modules=web,..,queue_job

[queue_job]
scheme=https

ovnicraft

### Keybase proof

I hereby claim:

  * I am ovnicraft on github.
  * I am csalamea (https://keybase.io/csalamea) on keybase.
  * I have a public key ASC619CFuYCw2nTFmbsfqz4zpqmZrClVi3bndeZ_JtzSMAo

To claim this, I am signing this object:

ovnicraft

select pp.default_code, pt.name, sloc.name, sum(product_qty) filter (where spt.code = 'incoming') as incoming, sum(product_qty) filter ( where spt.code = 'outgoing') as outgoing, spt.code 
 from stock_move sm 
  inner join stock_picking_type spt on sm.picking_type_id = spt.id 
  left join stock_location sloc on sm.location_id = sloc.id
  left join stock_location slocd on sm.location_dest_id = slocd.id
  
  inner join product_product pp on pp.id = sm.product_id
  inner join product_template pt on pt.id = pp.product_tmpl_id
   
 where sm.state = 'done'

ovnicraft

select pt.name, sloc.name, sum(product_qty) filter (where spt.code = 'incoming') as incoming, sum(product_qty) filter ( where spt.code = 'outgoing') as outgoing, spt.code 
 from stock_move sm 
  inner join stock_picking_type spt on sm.picking_type_id = spt.id 
  left join stock_location sloc on sm.location_id = sloc.id
  left join stock_location slocd on sm.location_dest_id = slocd.id
  
  inner join product_product pp on pp.id = sm.product_id
  inner join product_template pt on pt.id = pp.product_tmpl_id
   
 where sm.state = 'done'

ovnicraft

	select sum(product_qty) filter (spt.code = 'incoming') as incoming, product_id, sloc.name, sm.location_id, picking_type_id, spt.code 
	from stock_move sm 
	inner join stock_picking_type spt on sm.picking_type_id = spt.id 
	left join stock_location sloc on sm.location_id = sloc.id
	left join stock_location slocd on sm.location_dest_id = slocd.id
	where sm.state = 'done'
	and inventory_id is null
	group by product_id, sloc.name, sm.location_id, picking_type_id, spt.code;

ovnicraft

      - run:
          name: Set modules list to test
          command: |
            echo \'export MODULES=$(git show --name-only --format= | cut -d/ -f1 | sort | uniq | xargs | sed 's/ /,/g' | sed 's/.circleci/base/g')\' >> $BASH_ENV
            source $BASH_ENV
      - run:
          name: Run tests
          command: su - odoo -c "python ~/odoo-$ODOO_BRANCH/odoo-bin --addons-path=odoo-$ODOO_BRANCH/addons,$CIRCLE_WORKING_DIRECTORY --db_host=localhost -i $MODULES -r circleci -d odoo_$CIRCLE_BUILD_NUM --test-enable --stop-after-init"

ovnicraft

      - run:
          name: Set modules list to test
          command: |
            echo \'export MODULES=$(git show --name-only --format= | cut -d/ -f1 | sort | uniq | xargs | sed 's/ /,/g')\' >> $BASH_ENV
            source $BASH_ENV