~jgrandguillaume-c2c/openobject-addons/multi-company-cost-price

« back to all changes in this revision

Viewing changes to project_planning/project_planning.py

  • Committer: Joël Grand-Guillaume
  • Date: 2010-04-08 09:00:10 UTC
  • mfrom: (2533.3.664)
  • Revision ID: joel.grandguillaume@camptocamp.com-20100408090010-c0pqjan341s18bxs
[MRG] Merge from last trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
286
286
        cr.execute(""" CREATE OR REPLACE VIEW report_account_analytic_planning_user AS (
287
287
        SELECT
288
288
            planning.id AS planning_id,
289
 
            planning.id::varchar(32) || '-' || COALESCE(users.id,0)::varchar(32) AS id,
 
289
            (1000*(planning.id) + users.id)::integer AS id,
290
290
            planning.business_days,
291
291
            users.id AS user_id,
292
292
            (SELECT sum(line1.amount_in_base_uom)
330
330
 
331
331
        SELECT
332
332
            planning.id AS planning_id,
333
 
            planning.id::varchar(32) || '-' || '0' AS id,
 
333
            (1000*(planning.id) - 1)::integer AS id,
334
334
            planning.business_days,
335
335
            line.user_id,
336
336
            (SELECT SUM(line1.amount_in_base_uom)