Monday, 29 May 2017

Odoo: Upload binary images from backend using API

If you want to upload binary image to odoo using API..here are the steps:

controllers/main.py

# -*- coding: utf-8 -*-
from odoo.tools.translate import _
from odoo import http
from odoo.http import request
from odoo.addons import web
from time import strftime
import functools
import datetime
import json
import base64
import sys
import copy
from dateutil import parser
import logging
from operator import itemgetter
logger = logging.getLogger(__name__)


def serialize_exception(f):
    @functools.wraps(f)
    def wrap(*args, **kwargs):
        try:
            return f(*args, **kwargs)
        except Exception, e:
            logger.debug("An exception occured during an http request")
            #se = _serialize_exception(e)
            error = {
                'code': 200,
                'message': "Odoo Server Error",
                'data': str(e)
            }
            return json.dumps(error)
    return wrap


class Binary(web.controllers.main.Binary):
    @http.route('/api/upload_images', type='http', auth="public", csrf=False)
    @serialize_exception
    def upload_attachment(self, uid, ufile, ufile_name):
        user_model = request.env['res.users']
        user_ids = user_model.sudo().browse([('id', '=', uid)])
        if user_ids:
            user_obj = user_ids[0]
            try:
                user_obj.write({
                    'uploaded_files': base64.encodestring(ufile.read()),
                    'uploaded_files_filename': ufile_name,
                })
            except Exception:
                args = {'status': 0, 'error': "Something horrible happened."}
                return json.dumps(args)
            return json.dumps({'status': 1, 'message': 'File uploaded successfully'})
        else:
            return json.dumps({'status': 0, 'message': 'User does not exist.'})



Where fields are:

uploaded_files = fields.Binary(string=_('Files'), attachment=True, store=True)
uploaded_files_filename = fields.Char("Filename")

and JS code is:

<script>
    // grab your file object from a file input
    // Where fileInput is
    // <input id="fileInput" type="file" />
    $('#fileInput').change(function () {
        sendFile(this.files[0]);
    });

    function sendFile(file) {
        var querydata = new FormData();
        querydata.append('ufile',file);
        querydata.append('ufile_name',file.name);
        querydata.append('uid', 10);
        //querydata.append('multi', 'true');
        $.ajax({
            url: "http://xxxxx:8069/api/upload_images",
            data: querydata,
            type: "POST",
            cache: false,
            processData: false, 
            contentType: false,
            dataType: "json",
            beforeSend: function (xhr) {

            },
            success: function (result) {
                console.log(result);
                console.log(result.status);   
            },
            error: function (err) {
                console.log(err);
            }
        });
    }
</script>


References:

https://www.odoo.com/forum/help-1/question/openerp-multiple-file-upload-54736 
https://code.tutsplus.com/tutorials/base64-encoding-and-decoding-using-python--cms-25588
https://www.odoo.com/forum/help-1/question/change-filename-on-field-binary-52235

Thanks!!!!!!!!!! Enjoy Programming!!! :) 

Monday, 8 May 2017

Write web services using Odoo controllers

In Odoo you can write web-services for outside world. Let's discuss how it can be done using controllers.

Suppose I need cross domain API which will return data in json format. For that we have to enable CORS and have to setup nginx reverse proxy.

Example: API to send teachers data from odoo:

# -*- coding: utf-8 -*-
from odoo.tools.translate import _
from odoo import http
from odoo.http import request
import json
import sys

class odoo_public_data(http.Controller):
    @http.route('/get/teachers', type='http', methods=['GET'], auth="public")

    def get_teachers(self, **kwargs):
        teacher_model = request.env['dps.teacher']
        teacher_ids = teacher_model.sudo().search([])
        teacher_list = {'status': 1, 'data': []}
        try:
            if teacher_ids:
                for teacher in teacher_ids:
                    vals = {
                        'id': teacher.id,
                        'name': teacher.name,
                        'email': teacher.email,
                        'phone': teacher.phone,
                        'school': teacher.partner_id.name,
                    }
                    teacher_list['data'].append(vals)
            return json.dumps(teacher_list)
        except Exception as e:
            print str(e)
            return json.dumps({'status': 0, 'data': 'Some problem with API'})


Please set reverse proxy using tutorial if it's not already set. After that add lines from link(https://enable-cors.org/server_nginx.html) in location block, to enable CORS, of virtual host config file.

Thanks!!!!! Enjoy Programming!!! :)

Nginx reverse proxy on odoo

Let's discuss how to set nginx reverse proxy in odoo

Why we need revese proxy?

Odoo runs on 8069 port by default and if you want to route it through other port, say 80 we can use nginx reverse proxy for that. It will also help to handle web services, if any, your odoo instance is providing to outside world.

What to do?

1. Install nginx

2. Create virtual host for your website/odoo instance. Let's say you want to run it on myodoo.com. Please create config file at location:


/etc/nginx/sites-available/myodoo.domain.com

CREATE symbolic link for this at

/etc/nginx/sites-enabled/myodoo.domain.com

Following is the code for ssl enabled config file

upstream myodoo {
    server 127.0.0.1:8069;
}
server {
        listen 443 default;
        server_name myodoo.domain.com;
        access_log /var/log/nginx/oddo.access.log;
        error_log /var/log/nginx/oddo.error.log;
        if ($scheme = http) {
                return 301 https://myodoo.domain.com$request_uri;
        }
        # SSL cerificate details
        ssl on;
        ssl_certificate /etc/letsencrypt/live/myodoo.domain.com/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/myodoo.domain.com/privkey.pem; keepalive_timeout 60;
        ssl_ciphers EECDH+AES128:RSA+AES128:EECDH+AES256:RSA+AES256:EECDH+3DES:RSA+3DES:!MD5;
        ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
        ssl_prefer_server_ciphers on;
        proxy_buffers 16 64k;
        proxy_buffer_size 128k;
        location / {
                proxy_next_upstream error timeout invalid_header http_500 http_502  http_503 http_504;
                proxy_redirect off;
                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto https;
                proxy_pass http://myodoo;
        }
        location ~* /web/static/ {
                proxy_cache_valid 200 60m;
                proxy_buffering on;
                expires 864000;
                proxy_pass http://myodoo;
        }
}

## http redirects to https ##
server {
    listen      80;
    server_name myodoo.domain.com;
    # Strict Transport Security
    add_header Strict-Transport-Security max-age=2592000;
    rewrite ^/.*$ https://$host$request_uri? permanent;
}


After this reload/restart your nginx (
sudo /etc/init.d/nginx reload) and your odoo instance will run on https://myodoo.domain.com and http will be rediected to https

I hope it will work for you as well. Please let me know if you are facing any issue.

Thanks!!!! Enjoy Programming!! :)

Gmail: Download blocked file

Hi, today we are going to learn, how to download blocked file in gmail. Sometimes you see following message in gmail: and you can...