#2018-04-16 def action_create_purc(self,cr,uid,ids,context=None):        mrp_origin_obj=self.browse(cr,uid,ids,context)        mod_obj = self.pool.get('ir.model.data')        purchaseobj=self.pool('purchase.origin')        date_now=mrp_origin_obj.date        origin=mrp_origin_obj.name        #变量初始化        record=[]         var_part_name=0        i=1        for pro_line_id in mrp_origin_obj.pro_mate_id:            # 变量赋值，供应商的id            part_name=pro_line_id.partner_id.id #第一条数据判断 如果是第一条            if var_part_name==0:                     record.append((0,0,{
   'sequence':i,'product_id':pro_line_id.product_id.id,'product_qty':pro_line_id.qty,'product_uom':pro_line_id.uom_id.id,'date_planned':date_now,                                    'price_unit':pro_line_id.price,   }))                     #明细加数据，供应商重新赋值                    var_part_name=part_name #第2、3、4.。。。。N条数据判断，如果与第一条相同，数据就直接加入明细中            elif part_name==var_part_name :                #当供应商相等时，直接添加明细+1                 record.append((0,0,{
   'sequence':i,'product_id':pro_line_id.product_id.id,'product_qty':pro_line_id.qty,'product_uom':pro_line_id.uom_id.id,'date_planned':date_now,                                    'price_unit':pro_line_id.price,   }))            else:  #part_name!=firstvar_part_name :当他不相等时                    # 1、首先把之前的record创建成采购订单                    ctx={
   'partner_id':var_part_name,'ref_sale_name':origin,'order_type':'rawmaterial','location_id':19,'date_planned':date_now,'pricelist_id':1,'picking_type_id':8,'line_id':record}                    purchase_new_id= purchaseobj.create(cr,uid,ctx,context=context)                    #2、把record变成空，重新添加一条                    record=[]                    ctx={}                    record.append((0,0,{
    'product_id':pro_line_id.product_id.id,'product_qty':pro_line_id.qty,'product_uom':pro_line_id.uom_id.id,'date_planned':date_now,                                    'price_unit':pro_line_id.price   }))                    var_part_name=part_name        #当最后一条，相等或不等时都要执行这一句。        ctx={
   'partner_id':var_part_name,'ref_sale_name':origin,'order_type':'rawmaterial','location_id':19,'date_planned':date_now,'pricelist_id':1,'picking_type_id':8,'line_id':record}        purchase_new_id= purchaseobj.create(cr,uid,ctx,context=context)        return  purchase_new_id

def action_pro_mate(self,cr,uid,ids,context=None):        result={}        assert len(ids)==1        id=ids[0] #生产单有保存销售单id        pro_mateobj=self.pool.get('sale.product.material')        mrpobj=self.pool.get('mrp.production')        mrpobj_ids=mrpobj.search(cr,uid,[('sale_origin_id','=',id)],context=context) #查询有关的生产单        mrpobjres=mrpobj.browse(cr,uid,mrpobj_ids,context=context)        seq=1        vals={}        sql=" select feeding_name,partner_id,COALESCE(SUM(feeding_number),0)  product_qty,COALESCE (price_unit,0) price_unit,(COALESCE(SUM(feeding_number),0)*COALESCE( price_unit,0)) as je from feeding_order where production_id in (select id from  mrp_production where sale_origin_id=%d) GROUP BY feeding_name,partner_id,price_unit ORDER BY partner_id"%(id)        cr.execute(sql)        dict=cr.dictfetchall()        num=len(dict)        pro_mate_ids=[]        i=0        #将查询好的数据，添加到表中，通过sql语句查询分组汇总        for i in range(num):            print i            pro_mate_ids.append((0,0,{ 'sale_origin_id':id,                                     'sequence':i+1,                                     'product_id':dict[i]['feeding_name'],                                     'partner_id':dict[i]['partner_id'],                                     'price':dict[i]['price_unit'],                                     'qty':dict[i]['product_qty'],                                     'je':dict[i]['je'],                                      }))            i+=1        vals={
   'pro_mate_id':pro_mate_ids}         最后添加进去        self.write(cr,uid,[id],vals,context=context)        return True #排序 record= sorted(record, key=lambda record : record[2]['product_id'])