openerp学习笔记 计算字段、关联字段（7.0中非计算字段、关联字段只读时无法修改保存的问题暂未解决）

计算字段、关联字段，对象修改时自动变更保存（当 store=True 时），当 store=False 时，默认不支持过滤和分组
7.0中非计算字段、关联字段只读时无法修改保存的问题暂未解决

示例代码： 

class dispatch_work_order(osv.osv):
    _name="dispatch.work_order"
    _description="工单"
    _order = "id asc"
        
    def _get_bill_month(self, cr, uid, ids, field_name, arg, context=None):
        res = {}
        if context is None:
            context = {}
        DATETIME_FORMAT = "%Y-%m-%d"
        for rec in self.browse(cr, uid, ids, context=context):
            billdate = datetime.datetime.strptime(rec.bill_date, DATETIME_FORMAT)
            res[rec.id] = billdate.strftime('%Y') + '-' + billdate.strftime('%m')
        return res
   
    def _get_done_month(self, cr, uid, ids, field_name, arg, context=None):
        res = {}
        if context is None:
            context = {}
        DATETIME_FORMAT = "%Y-%m-%d"
        for rec in self.browse(cr, uid, ids, context=context):
            if rec.done_date:
                donedate = datetime.datetime.strptime(rec.done_date, DATETIME_FORMAT)
                res[rec.id] = donedate.strftime('%Y') + '-' + donedate.strftime('%m')
        return res

    _columns={
        "name":fields.char("服务单号",size=64, select=True, required=True, readonly=True),
        "bill_date":fields.date("开单日期", select=True, required=True, readonly=True),
        'bill_month':fields.function(_get_bill_month, method=True, type='char', size=10, string = u'开单月份', store=True, invisible=True),
        "customer":fields.many2one("dispatch.customer","客户", select=True, required=True, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "mobile":fields.char("手机",size=64,required=True, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "phone":fields.char("电话",size=64, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "area":fields.many2one("dispatch.area","区域",required=True, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        'workload':fields.related('area', 'workload', string=u'分值', type='float', readonly=True, store=True),
        'travelling_expenses':fields.related('area', 'travelling_expenses', string=u'交通费', type='float', readonly=True, store=True),
        "address":fields.char("客户地址", size=200, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "buy_date":fields.date("购机日期", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "brand":fields.many2one("dispatch.brand","品牌型号", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
     "description_of_fault":fields.char("故障描述", size=500, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "note":fields.char("备注", size=500, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "client_source":fields.many2one("dispatch.client_source","客户来源", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "warranty_type":fields.many2one("dispatch.warranty_type","保修类型", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "appointment_date":fields.date("预约日期", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "appointment_time":fields.selection([("morning","上午"),("afternoon","下午"),("evening","晚上"),],"预约时段", translate=True,  readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "repair_method":fields.many2one("dispatch.repair_method","维修方式", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "series_number":fields.char("序列号",size=64, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "buy_address":fields.many2one("dispatch.buy_address","购机地点", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "service_card":fields.many2one("dispatch.service_card","服务卡", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        'service_card_remaining_times':fields.related('service_card', 'remaining_times', string=u'卡余次数', type='integer', readonly=True, store=True),
        "engineer":fields.many2one("hr.employee","工程师",readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        'department':fields.related('engineer', 'department_id', string=u'部门', type='many2one', relation='hr.department', readonly=True, store=True),
        "state":fields.selection([
            ("draft","已接单"),
            ("dealing","已派工"),
            ("done","已完工"),
            ("reply","已交单"),
            ("visit","已回访"),],"状态", readonly=True),
        "check_result":fields.char("检测结果", size=500, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "measure":fields.char("处理措施", size=500, readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "service_time_1":fields.datetime("服务开始时间", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "service_time_2":fields.datetime("服务结束时间", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "amount":fields.float("实收费用",digits=(7,2), readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "state_use_card":fields.selection([
            ("0","不扣卡"),
            ("1","需扣卡"),],"扣卡", readonly=True, states={'draft':[('readonly',False)], 'dealing':[('readonly',False)]}),
        "visit_time":fields.datetime("回访时间", readonly=True),
        "evaluate":fields.selection([
            ("very_satisfied","非常满意"),
            ("satisfied","满意"),
            ("discontent","不满"),
            ("very_discontent","非常不满"),],"客户评价"),
        "customer_feedback":fields.char("客户反馈", size=500),
        "reduce":fields.boolean("已扣卡", readonly=True),
        "done_date":fields.date("完工日期", readonly=True),
        'done_month':fields.function(_get_done_month, method=True, type='char', size=10, string = u'完工月份', store=True, invisible=True),
        'create_uid': fields.many2one('res.users', u"创建用户", invisible=False, readonly=True), #需要在记录中读取该字段或者在视图中显示该字段时，对象中必须包含
    }
   
dispatch_work_order()

 

class lx_purchase_order(osv.osv):

    def _get_order(self, cr, uid, ids, context=None):
        result = {}
        for line in self.pool.get('lx.purchase.order.line').browse(cr, uid, ids, context=context):
            result[line.order_id.id] = True
        return result.keys()

    def _amount_all(self, cr, uid, ids, field_name, arg, context=None):
        res = {}
        for order in self.browse(cr, uid, ids, context=context):
            res[order.id] = {
                "amount_total": 0.0,
                }
            val = 0.0
            for line in order.order_line:
                val+= line.subtotal
            res[order.id]['amount_total']=val
        return res

    _name='lx.purchase.order'
    _description=u"lx采购单"
    _columns={
        'name':fields.char(u'单号',size=64,required=True, readonly=True),
        'create_uid': fields.many2one('res.users', u"创建用户", invisible=False, readonly=True), #需要在记录中读取该字段或者在视图中显示该字段时，对象中必须包含
        'employee_id':fields.many2one('hr.employee',u'员工',required=True, readonly=True, states={'draft':[('readonly',False)]}),
        'department_id':fields.many2one('hr.department',u'部门',required=True,select=True, readonly=True, states={'draft':[('readonly',False)]}),
        'date':fields.date(u'日期',select=True, readonly=True, states={'draft':[('readonly',False)]}),
        'supplier':fields.char(u'供应商',size=64,required=True, readonly=True, states={'draft':[('readonly',False)]}),
        'state': fields.selection([('draft', u'草稿'),('confirmed', u'已确认')], u'状态', readonly=True),
        'note':fields.text(u'备注', readonly=True, states={'draft':[('readonly',False)]}),
        'order_line':fields.one2many('lx.purchase.order.line','order_id',u'采购单明细', readonly=True, states={'draft':[('readonly',False)]}),
        'amount_total': fields.function(_amount_all, digits=(18, 2), string=u'合计',
                                        store={
                                            'lx.purchase.order.line': (_get_order, None, 10),
                                            }, multi='sums'),
    }
       

lx_purchase_order()

class lx_purchase_order_line(osv.osv):

    def _amount_line(self, cr, uid, ids, prop, arg, context=None):
        res={}
        for line in self.browse(cr,uid,ids,context=context):
            a=self.read(cr,uid,line.id,["price","product_qty"])
            res[line.id]=a["price"]*a["product_qty"]
        return res

    _name='lx.purchase.order.line'
    _description=u"lx采购单明细"
    _columns={
        'order_id':fields.many2one('lx.purchase.order',u'采购单ID',select=True, ondelete='cascade'),
        'product':fields.char(u'产品',size=128,required=True),
        'price':fields.float(u'价格', digits_compute = dp.get_precision('lx_purchase_price'), required=True),
        'product_qty':fields.integer(u'数量',required=True),
        'unit': fields.char(u'计量单位',size=6),
        'subtotal':fields.function(_amount_line, string=u'小计', digits=(18, 2)),
    }
lx_purchase_order_line()