Navigation

    Odoo 中文社区

    • Register
    • Login
    • Search
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Odoo中文社区可以通过以下两个域名访问:shine-it.net , odoo.net.cn

    由于系统升迁的原因,本论坛部分较早期的内容存在格式和链接损坏失效的问题,并非本论坛系统本身的缺陷,望谅解

    本社区没有维护任何QQ群讨论组,任何与本社区同名的QQ群讨论组的言论与本社区无关!

    开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

    如果您登录系统碰到问题,请在微信公众号留言:

    [求助] 采购订单报表中增加了2个字段 显示库存信息,但是无法读取出来数据 odoo

    Odoo 开发与实施交流
    1
    2
    1533
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Y
      yanggg1133 last edited by

      [求组] 采购订单报表中增加了2个字段 显示库存信息,但是无法读取出来数据 odoo


      class purchase_order_line(osv.osv):
          ................

          def _stock1(self, cr, uid, ids, field_name, arg, context=None):
              res = {}
              for order_line in self.browse(cr, uid, ids, context=context):
      res[order_line.id] = self.pool.get('stock.history').read_group(cr, uid, [
      ('product_id', '=', order_line.product_id.id)
      ], fields=['quantity'], groupby=['location_id'], context=context)

              return res


          _columns = {
              'name': fields.text('Description', required=True),
              'product_id': fields.many2one('product.product', 'Product', domain=[('purchase_ok','=',True)], change_default=True),
      ........
              'stock1': fields.function(_stock1, method=True, type='float',  string='Stock1', help="This is Stock1"),
              'stock2': fields.function(_amount_line, string='Subtotal', digits_compute= dp.get_precision('Account')),
              }

      ==================
      stock1 这个仓库信息 显示不来数据,程序能编译通过

      最终想弄成这样子
          def _stock1(self, cr, uid, ids, field_name, arg, context=None):
              res = {}
              for order_line in self.browse(cr, uid, ids, context=context):
      res[order_line.id] = self.pool.get('stock.history').read_group(cr, uid, [
      ('product_id', '=', order_line.product_id.id),
      ('location_id', 'ilike', '物理库位 / JG / 库存')
      ], fields=['quantity'], groupby=['location_id'], context=context)

      1 Reply Last reply Reply Quote 0
      • First post
        Last post