is_demande_achat_serie.py

# -*- coding: utf-8 -*-
from openerp import models,fields,api
from openerp.tools.translate import _
from openerp.exceptions import Warning
import datetime
from res_partner import type_commande_list


class is_demande_achat_serie(models.Model):
    _name='is.demande.achat.serie'
    _inherit=['mail.thread']
    _order='name desc'


    @api.depends('line_ids')
    def _compute(self):
        uid=self._uid
        for obj in self:
            montant_total = 0
            for line in obj.line_ids:
                obj.product_id=line.product_id.id
                montant_total+=line.montant
            nb_lignes=len(obj.line_ids)
            if nb_lignes>1:
                raise Warning('Une seule ligne autorisée !')
            obj.nb_lignes     = nb_lignes
            obj.montant_total = montant_total

            vsb=False
            if obj.state!='brouillon' and uid==obj.acheteur_id.id:
                vsb=True
            obj.vers_brouillon_vsb=vsb
            vsb=False
            if obj.state=='brouillon':
                vsb=True
            obj.vers_transmis_achat_vsb=vsb
            vsb=False
            if obj.state=='transmis_achat' and uid==obj.acheteur_id.id:
                vsb=True
            obj.vers_solde_vsb=vsb
            vsb=False
            if obj.state=='brouillon' and uid==obj.createur_id.id:
                vsb=True
            if obj.state=='transmis_achat' and uid==obj.acheteur_id.id:
                vsb=True
            obj.vers_annule_vsb=vsb



    name                 = fields.Char("N° demande achat série", readonly=True)
    createur_id          = fields.Many2one('res.users', 'Demandeur', required=True)
    date_creation        = fields.Date("Date de création", required=True)
    acheteur_id          = fields.Many2one('res.users', 'Acheteur', required=True)
    fournisseur_id       = fields.Many2one('res.partner', 'Fournisseur', domain=[('is_company','=',True)], required=True)
    pricelist_id         = fields.Many2one('product.pricelist', "Liste de prix", related='fournisseur_id.property_product_pricelist_purchase', readonly=True)
    is_type_cde_fournisseur = fields.Selection(type_commande_list, "Type commande fourniseur", related='fournisseur_id.is_type_cde_fournisseur', readonly=True)
    delai_livraison      = fields.Date("Délai de livraison", required=True)
    lieu_livraison_id    = fields.Many2one('res.partner', 'Lieu de livraison', domain=[('is_company','=',True)], required=True)
    is_incoterm          = fields.Many2one('stock.incoterms', "Incoterm  / Conditions de livraison", related='fournisseur_id.is_incoterm', readonly=True)
    is_lieu              = fields.Char("Lieu", related='fournisseur_id.is_lieu', readonly=True)
    motif                = fields.Selection([
        ('pas_tarif'    , "Pas de tarif de créé"),
        ('fin_vie'      , "Produit en fin de vie (Lot trop important)"),
        ('inf_lot_appro', "Besoin inférieur au lot d'appro"),
        ('gest_18'      , "Gest 18 = Achat réalisé par le service achat"),
    ], "Motif")
    commentaire          = fields.Text("Commentaire")
    state                = fields.Selection([
        ('brouillon'     , 'Brouillon'),
        ('transmis_achat', 'Transmis achat'),
        ('solde'         , 'Soldé'),
        ('annule'        , 'Annulé'),
    ], "Etat")
    line_ids                = fields.One2many('is.demande.achat.serie.line'  , 'da_id', u"Lignes", copy=True)
    montant_total           = fields.Float("Montant Total", compute='_compute', readonly=True, store=True)
    order_id                = fields.Many2one('purchase.order', 'Commande générée', readonly=True, copy=False)
    nb_lignes               = fields.Integer("Nombre de lignes", compute='_compute', readonly=True, store=True)
    product_id              = fields.Many2one('product.product', 'Article', compute='_compute', readonly=True, store=True)
    vers_brouillon_vsb      = fields.Boolean('Champ technique', compute='_compute', readonly=True, store=False)
    vers_transmis_achat_vsb = fields.Boolean('Champ technique', compute='_compute', readonly=True, store=False)
    vers_solde_vsb          = fields.Boolean('Champ technique', compute='_compute', readonly=True, store=False)
    vers_annule_vsb         = fields.Boolean('Champ technique', compute='_compute', readonly=True, store=False)



    @api.multi
    def _lieu_livraison_id(self):
        user = self.env['res.users'].browse(self._uid)
        partner_id = user.company_id.partner_id.id
        return partner_id


    _defaults = {
        'date_creation'    : lambda *a: fields.datetime.now(),
        'createur_id'      : lambda obj, cr, uid, context: uid,
        'state'            : 'brouillon',
        'lieu_livraison_id': lambda self,cr,uid,context: self._lieu_livraison_id(cr,uid,context),
    }


    @api.multi
    def fournisseur_id_on_change(self,fournisseur_id):
        res={}
        if fournisseur_id:
            res['value']={}
            partner = self.env['res.partner'].browse(fournisseur_id)
            lieu_livraison_id=partner.is_livre_a_id.id
            if lieu_livraison_id:
                res['value']['lieu_livraison_id']=lieu_livraison_id
        return res


    @api.model
    def create(self, vals):
        data_obj = self.env['ir.model.data']
        sequence_ids = data_obj.search([('name','=','is_demande_achat_serie_seq')])
        if sequence_ids:
            sequence_id = data_obj.browse(sequence_ids[0].id).res_id
            vals['name'] = self.env['ir.sequence'].get_id(sequence_id, 'id')
        obj = super(is_demande_achat_serie, self).create(vals)
        return obj


    @api.multi
    def vers_brouillon_action(self):
        for obj in self:
            if obj.acheteur_id.id==self._uid or self._uid==1:
                obj.sudo().state="brouillon"


    @api.multi
    def vers_transmis_achat_action(self):
        for obj in self:
            article=u''
            for line in obj.line_ids:
                article=u' ('+line.product_id.is_code+u' / '+line.product_id.name+u')'
            subject=u'['+obj.name+u'] Transmis achat'+article
            email_to=obj.acheteur_id.email
            user  = self.env['res.users'].browse(self._uid)
            email_from = user.email
            email_cc   = email_from
            nom   = user.name
            base_url = self.env['ir.config_parameter'].sudo().get_param('web.base.url')
            url=base_url+u'/web#id='+str(obj.id)+u'&view_type=form&model=is.demande.achat.serie'
            body_html=u"""
                <p>Bonjour,</p>
                <p>"""+nom+""" vient de passer la demande d'achat série <a href='"""+url+"""'>"""+obj.name+"""</a> à l'état 'Transmis achat'.</p>
                <p>Merci d'en prendre connaissance.</p>
            """
            self.envoi_mail(email_from,email_to,email_cc,subject,body_html)
            obj.state="transmis_achat"


    @api.multi
    def vers_solde_action(self):
        for obj in self:
            order_obj      = self.env['purchase.order']
            order_line_obj = self.env['purchase.order.line']
            partner=obj.fournisseur_id
            if partner.property_product_pricelist_purchase:
                vals={
                    'partner_id'      : partner.id,
                    'is_livre_a_id'   : obj.lieu_livraison_id.id,
                    'location_id'     : partner.is_source_location_id.id,
                    'fiscal_position' : partner.property_account_position.id,
                    'payment_term_id' : partner.property_supplier_payment_term.id,
                    'pricelist_id'    : partner.property_product_pricelist_purchase.id,
                    'currency_id'     : partner.property_product_pricelist_purchase.currency_id.id,
                    'is_num_da'       : obj.name,
                    'is_demandeur_id' : obj.createur_id.id,
                    'incoterm_id'     : partner.is_incoterm.id,
                    'is_lieu'         : partner.is_lieu,
                }
                order=order_obj.create(vals)
                obj.order_id=order.id
                line=False
                if len(obj.line_ids)==1:
                    line=obj.line_ids[0]
                test=True
                if order and line:
                    vals={}
                    try:
                        res=order_line_obj.onchange_product_id(
                            order.pricelist_id.id, 
                            line.product_id.id, 
                            line.quantite, 
                            line.uom_id.id, 
                            partner.id, 
                            #date_order         = False, 
                            date_order         = str(obj.delai_livraison)+' 12:00:00', 
                            fiscal_position_id = partner.property_account_position.id, 
                            date_planned       = False, 
                            name               = False, 
                            price_unit         = False, 
                            state              = 'draft'
                        )
                        vals=res['value']
                    except:
                        test=False
                    vals['product_qty']  = line.quantite
                    vals['price_unit']   = line.prix
                    vals['order_id']     = order.id
                    vals['date_planned'] = obj.delai_livraison
                    vals['product_id']   = line.product_id.id
                    if 'taxes_id' in vals:
                        vals.update({'taxes_id': [[6, False, vals['taxes_id']]]})
                    order_line=order_line_obj.create(vals)
                    order.wkf_bid_received() 
                    order.wkf_confirm_order()
                    order.action_picking_create() 
                    order.wkf_approve_order()
                    obj.state="solde"

                    subject=u'['+obj.name+u'] Soldé ('+line.product_id.is_code+u' / '+line.product_id.name+u')'
                    email_to=obj.createur_id.email
                    user  = self.env['res.users'].browse(self._uid)
                    email_from = user.email
                    nom   = user.name
                    base_url = self.env['ir.config_parameter'].sudo().get_param('web.base.url')
                    url=base_url+u'/web#id='+str(obj.id)+u'&view_type=form&model=is.demande.achat.serie'
                    body_html=u"""
                        <p>Bonjour,</p>
                        <p>"""+nom+""" vient de passer la demande d'achat série <a href='"""+url+"""'>"""+obj.name+"""</a> à l'état 'Soldé'.</p>
                        <p>Merci d'en prendre connaissance.</p>
                    """
                    self.envoi_mail(email_from,email_to,'',subject,body_html)


    @api.multi
    def vers_annule_action(self):
        for obj in self:
            if obj.createur_id.id==self._uid or obj.acheteur_id.id==self._uid:
                obj.sudo().state="annule"


    @api.multi
    def envoi_mail(self, email_from,email_to,email_cc,subject,body_html):
        for obj in self:
            vals={
                'email_from'    : email_from, 
                'email_to'      : email_to, 
                'email_cc'      : email_cc,
                'subject'       : subject,
                'body_html'     : body_html, 
            }
            email=self.env['mail.mail'].create(vals)
            if email:
                self.env['mail.mail'].send(email)


class is_demande_achat_serie_line(models.Model):
    _name='is.demande.achat.serie.line'
    _order='da_id,sequence'


    @api.depends('product_id','quantite','prix')
    def _compute(self):
        for obj in self:
            if obj.product_id:
                obj.uom_id=obj.product_id.uom_po_id
            obj.montant=obj.quantite*obj.prix

    da_id                  = fields.Many2one('is.demande.achat.serie', "Demande d'achat", required=True, ondelete='cascade', readonly=True)
    sequence               = fields.Integer('Ordre')
    product_id             = fields.Many2one('product.product', 'Article', domain=[('is_category_id.name','<','62')], required=True)
    uom_id                 = fields.Many2one('product.uom', "Unité d'achat", compute='_compute', readonly=True, store=True)
    quantite               = fields.Float("Quantité", digits=(14,4), required=True)
    prix                   = fields.Float("Prix"    , digits=(14,4))
    montant                = fields.Float("Montant", compute='_compute', readonly=True, store=True)


    @api.multi
    def product_id_on_change(self,parent,product_id,quantite):
        cr=self._cr
        res={}
        fournisseur_id=parent.fournisseur_id
        if fournisseur_id:
            partner = self.env['res.partner'].browse(fournisseur_id)
            pricelist_id=partner.property_product_pricelist_purchase.id
            if product_id:
                res['value']={}
                product = self.env['product.product'].browse(product_id)
                now=datetime.datetime.now().strftime('%Y-%m-%d')
                sql="""
                    select 
                        is_prix_achat("""+str(pricelist_id)+""", """+str(product_id)+""", """+str(quantite)+""", '"""+now+"""') 
                    from product_product
                    where id="""+str(product_id)+"""
                """
                cr.execute(sql)
                prix=0
                for row in cr.fetchall():
                    prix=row[0]
                res['value']['prix']=prix
        return res