# -*- coding: utf-8 -*-
# © 2016 Lorenzo Battistini - Agile Business Group
# License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl.html).

from openerp import tools
from openerp import models, fields


class StockAnalysis(models.Model):
    _name = 'stock.analysis'
    _auto = False
    _rec_name = 'product_id'

    product_id = fields.Many2one(
        'product.product', string='Producto', readonly=True)
    location_id = fields.Many2one(
        'stock.location', string='Ubicacion', readonly=True)
    qty = fields.Float(string='Cantidad', readonly=True)
    lot_id = fields.Many2one(
        'stock.production.lot', string='Lote', readonly=True)
    package_id = fields.Many2one(
        'stock.quant.package', string='Paquete', readonly=True)
    in_date = fields.Datetime('Fecha entrante', readonly=True)
    categ_id = fields.Many2one(
        'product.category', string='Categoria', readonly=True)
    company_id = fields.Many2one(
        'res.company', string='Compañia', readonly=True)

    def init(self, cr):
        tools.drop_view_if_exists(cr, self._table)
        cr.execute(
            """CREATE or REPLACE VIEW %s as (
            SELECT
                quant.id AS id,
                quant.product_id AS product_id,
                quant.location_id AS location_id,
                quant.qty AS qty,
                quant.lot_id AS lot_id,
                quant.package_id AS package_id,
                quant.in_date AS in_date,
                quant.company_id,
                template.categ_id AS categ_id
            FROM stock_quant AS quant
            JOIN product_product prod ON prod.id = quant.product_id
            JOIN product_template template
                ON template.id = prod.product_tmpl_id
            )"""
            % (self._table)
        )