Odoo中文网|Odoo实施培训

标题: odoo sql [打印本页]

作者: 店小2 时间: 2016-10-28 23:03
标题: odoo sql
odoo 中虽然系统已经代码进行封装　搜索，查询，写入新建都不用ｓｑｌ
但是在有的时候用ｓｑｌ的话会很方便　，而且还会提高效率

      cr.execute('SELECT rel.purchase_id '

   'FROM purchase_invoice_rel AS rel, account_invoice AS inv ' + purchase_clause +
               'WHERE rel.invoice_id = inv.id ' + clause)
      res = cr.fetchall()

SELECT po.id AS po_id,po.name,
                           po.amount_total-COALESCE(sum(pol.product_qty* pol.price_unit),0) AS sum_uninvoiced
                  FROM purchase_order AS po
                  LEFT JOIN purchase_order_line AS pol  ON pol.order_id=po.id
                  WHERE pol.invoiced=True
                  GROUP BY po.id order by po.id

欢迎光临 Odoo中文网|Odoo实施培训 (http://www.chinaodoo.net/)