Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.
Module: Project
Entity: project.project
Compute Method: _compute_attached_docs_count
| Inputs | Method | Outputs |
|---|---|---|
|
- docs_count = {} - if self.ids: - self.env.cr.execute( - """ - WITH docs AS ( - SELECT res_id as id, count(*) as count - FROM ir_attachment - WHERE res_model = 'project.project' - AND res_id IN %(project_ids)s - GROUP BY res_id - - UNION ALL - - SELECT t.project_id as id, count(*) as count - FROM ir_attachment a - JOIN project_task t ON a.res_model = 'project.task' AND a.res_id = t.id - WHERE t.project_id IN %(project_ids)s - GROUP BY t.project_id - ) - SELECT id, sum(count) - FROM docs - GROUP BY id - """, - {"project_ids": tuple(self.ids)} - ) - docs_count = dict(self.env.cr.fetchall()) - for project in self: - project.doc_count = docs_count.get(project.id, 0) |
|
