<ls user="api" />.model_cr
def init(self):
'''Create the view'''
tools.drop_view_if_exists(self.env.cr, self._table)
self.env.cr.execute("""
CREATE OR REPLACE VIEW %s AS (
SELECT
CASE WHEN c.id != 0 THEN COUNT(*) ELSE 0 END AS count,
CASE WHEN c.x_kzevent_status IN ('ok', 'wait') THEN COUNT(*) ELSE 0 END AS nbr_ok_kzevent,
CASE WHEN c.stage_id >= '15' THEN COUNT(*) ELSE 0 END AS nbr_agreement,
((CASE WHEN c.x_kzevent_status IN ('ok', 'wait') THEN COUNT(*) ELSE 0 END)/(CASE WHEN c.id != 0 THEN COUNT(*) ELSE NULL END)) as efficiency_kzevent_contact,
((CASE WHEN c.stage_id >= '15' THEN COUNT(*) ELSE NULL END)/(CASE WHEN c.x_kzevent_status IN ('ok', 'wait') THEN COUNT(*) ELSE NULL END)) as efficiency_agreement_kzevent
FROM
"crm_lead" c
LEFT JOIN "crm_stage" stage
ON stage.id = c.stage_id
GROUP BY c.id, stage.name
)""" % (self._table,))
<template id="minimal_layout_inherit" inherit_id="report.layout">
<xpath expr="//head" position="inside">
<link rel='stylesheet' href="/sale_kp/main.css"/>
</xpath>
</template>
127.0.0.1:8069/sale_kp/main.css net::ERR_ABORTED
sudo apt-get install wkhtmltopdfhttps://www.getopenerp.com/wkhtmltopdf-for-odoo8//etc/init.d/odoo restartTraceback (most recent call last):
File "/opt/odoo/odoo/openerp/http.py", line 537, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/odoo/openerp/http.py", line 1413, in _dispatch_nodb
func, arguments = self.nodb_routing_map.bind_to_environ(request.httprequest.environ).match()
File "/usr/local/lib/python2.7/dist-packages/werkzeug/routing.py", line 1430, in match
raise NotFound()
NotFound: 404: Not Found