eneldoserrata

# -*- coding: utf-8 -*-
# Estas cedulas fueron emitidas por la JCE, pero no cumplen con el
# digito verificador, por lo cual deben ser verificadas por separado.

import csv
import cPickle

__author__ = 'eneldoserrata'

excepcionesCedulas = ['00000000018', '11111111123', '00100759932', '00105606543', '00114272360', '00200123640',

eneldoserrata

# -*- coding: utf-8 -*-
import cherrypy
from cherrypy.process.plugins import SimplePlugin
from mako import exceptions
from mako.lookup import TemplateLookup

# todo-eneldo Documentar
# todo-eneldo capturar exceptions
# todo-eneldo crear test units

eneldoserrata

from cherrypy.process.plugins import SimplePlugin
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base, declared_attr
from sqlalchemy.orm.scoping import scoped_session
from sqlalchemy.orm.session import sessionmaker
from sqlalchemy.schema import Column
from sqlalchemy.types import Integer
import sqlamp
import cherrypy

eneldoserrata

from itertools import ifilter

UNIDADES = (
    '',
    'UN ',
    'DOS ',
    'TRES ',
    'CUATRO ',
    'CINCO ',
    'SEIS ',

eneldoserrata

import urllib2
import httplib
import json

# have to export the DER certify recived from azul to base64
# openssl x509 -inform der -in MYCERT.cer -out my_cert.crt
# I ended up solving this by concatenating
# the private key you use to generate crs with your converted cert
# cat my_key.key my_cert.crt > certify.pem
CERT = "certify.pem"

eneldoserrata

DELETE FROM stock_pack_operation;
DELETE FROM stock_picking;
DELETE FROM stock_move;
DELETE FROM sale_order_line;
DELETE FROM sale_order;
DELETE FROM account_invoice_line;
DELETE FROM account_invoice;
DELETE FROM account_move_line;
DELETE FROM account_move;
DELETE FROM pos_order_line;

eneldoserrata

DELETE FROM account_partial_reconcile;
delete from pos_order;
delete from pos_session;
DELETE FROM stock_pack_operation;
DELETE FROM stock_picking;
DELETE FROM stock_move;
DELETE FROM sale_order_line;
DELETE FROM sale_order;
DELETE FROM account_invoice_line;
DELETE FROM account_invoice;

eneldoserrata

upstream odoo {
    server localhost:8069 weight=1 fail_timeout=3000s;
}

upstream polling {
    server localhost:8072 weight=1 fail_timeout=3000s;
}

eneldoserrata

server {
    listen      443;
    server_name fhisa.tabla.si;

    access_log  /var/log/nginx/fhisa.access.log;
    error_log   /var/log/nginx/fhisa.error.log;

    ssl on;
    ssl_certificate     /etc/nginx/ssl/fhisa.crt;
    ssl_certificate_key /etc/nginx/ssl/fhisa.key;

eneldoserrata

import openpyxl
from openerp import models, fields, api, _
from tempfile import TemporaryFile

class ExcelReader(models.TransientModel):
    _name="reader_excel"

    excel_file = fields.Binary(string='Excel File')

    def import_excel(self):