Commit Graph

98 Commits

Author SHA1 Message Date
Olivier Dony 9e8d29c986 [FIX] project_timesheet: analyis view must include lines without timesheet
While working on project task it is possible
to record "task work" that will automatically
create timesheet lines. These are not by default
included into any timesheet, but they need to
appear in reporting nonetheless.

These lines disappeared from the analysis view
after the performance improvement of
rev. fe31451899
which introduced a JOIN with the `totals`
CTE table - and should have been LEFT JOIN.
2015-07-01 12:48:59 +02:00
Denis Ledoux fe31451899 [FIX] hr_timesheet_sheet: timesheet report totals
This rev. is related to rev. 89093a2

If several account analytic lines where defined for a same date
within a same sheet, the report totals were multiplied by
the number of occurences of lines of the same day.

Before the above rev., only `Diff`, `Total`, `Timesheet`, were wrong
After, other totals were wrong as well.

The point of the above rev. was to gain a real performance improvment
when there was a lot of timesheets / analytic lines entered
in database. This rev. keeps this performance improvment.

opw-629857
2015-04-01 11:07:44 +02:00
Denis Ledoux 89093a2616 [FIX] hr_timesheet_sheet: performance improvment of timesheet report
It always better to avoid doing the same join multiple times when
possible.

opw-629857
2015-03-10 16:20:40 +01:00
qdc f57787e07e [IMP] Cleaning of reporting (group_by, filters), adding new favourites and default views, some renaming (py and xml files) 2014-08-26 11:56:49 +02:00
Christophe Simonis 5a5f811d23 [REVERT] commit 5e5c73e
Branch 8.0 is a **stable** branch. This mean no database schema
changes.
2014-08-22 13:59:22 +02:00
qdc 5e5c73e7ba [IMP] Cleaning of reporting (group_by, filters), adding new favourites and default views, some renaming (py and xml files) 2014-08-22 09:49:09 +02:00
Géry Debongnie 366a30db95 [FIX] correct various date issues in reporting
* remove old 'day', 'month', 'field' and replace them by the actual
date/datetime field
* remove weird cast to char when creating the view to prevent crash
when grouping on them
* remove duplicates (such as 'creation_date' and 'create_date')
* fix typing errors (field type date defined as a datetime in the
postgres view)
* fix search view definition
2014-07-30 15:11:22 +02:00
tpa-odoo d2f3bb953d [IMP] move hr timesheet analysis report in to hr_timesheet 2014-06-17 13:53:33 +02:00
Géry Debongnie 555677f14d [IMP] replace all 'Group By...' by 'Group By'
in all searchview, the 'Group By...' looks weird, next to the Custom
Reports and Filters.  This change was requested by the upper management
2014-05-22 11:44:35 +02:00
Gery Debongnie e96e86b314 [IMP] improves the reporting view Timesheet Sheet Analysis (add some measures to the table) in addon hr_timesheet_sheet
bzr revid: ged@openerp.com-20140130132007-uyvddo0eq8yssft8
2014-01-30 14:20:07 +01:00
Gery Debongnie a768f15038 [IMP] improves the reporting view Timesheet Analysis (add some measures to the table) in addon hr_timesheet_sheet
bzr revid: ged@openerp.com-20140130131737-hibhsfqurtxe7weh
2014-01-30 14:17:37 +01:00
Gery Debongnie 68a466e8a8 [IMP] improves the Timesheet Analysis reporting view : changes the axis, adds a 'this month' filter using the new pivot graph view (addon hr_timesheet_sheet)
bzr revid: ged@openerp.com-20140127130351-iu422fkjnu8059wd
2014-01-27 14:03:51 +01:00
Gery Debongnie 0b1f968fc3 [IMP] removes old tree views in reporting and replaces them by the new graph views in pivot mode by default (addon hr_timesheet_sheet)
bzr revid: ged@openerp.com-20140102110259-eyxw0qff1w4dwdzu
2014-01-02 12:02:59 +01:00
Denis Ledoux 7baee28221 [MERGE] Forward-port of latest 7.0 bugfixes, up to rev. 9642 rev-id: dle@openerp.com-20131125160315-tj8n5bv6e5yv8jku
bzr revid: dle@openerp.com-20131125143003-vjtzj1c5051pdnk3
bzr revid: dle@openerp.com-20131125160523-hecq5u2uo0mfyoq0
2013-11-25 17:05:23 +01:00
Denis Ledoux 40a7a5dc64 [FIX]hr_timesheet_sheet: report, the join clause of the view was wrong, account_analytic_line is join with hr_timesheet_sheet_sheet thanks to the sheet_id (hat.sheet_id=htss.id), not with the line_id (hat.line_id=htss.id)
bzr revid: dle@openerp.com-20131125142624-wilbjmlgy9yubcgk
2013-11-25 15:26:24 +01:00
Christophe Simonis 6a9adbca62 [MERGE] forward port of branch 7.0 up to revid 9236 mat@openerp.com-20130613160953-itt79mu5xrl7suv4
bzr revid: chs@openerp.com-20130613181503-82234mo34wxb0oap
2013-06-13 20:15:03 +02:00
Vo Minh Thu e69326ee3b [REF] removed explicit model instanciations.
bzr revid: vmt@openerp.com-20130415102349-vgcrfok2k5y10cwz
2013-04-15 12:23:49 +02:00
Pinakin Nayi (OpenERP) f97c97d672 [IMP]account_followup,hr_timesheet_sheet:in analysis report create button is there but no need of it
bzr revid: pna@tinyerp.com-20130313070029-9ojiilbnl2tn7f3g
2013-03-13 12:30:29 +05:30
Cecile Tonglet a3939acfa5 [FIX] replace from/import decimal_precision by from/import openerp.addons.decimal_precision
bzr revid: cto@openerp.com-20121217152303-8e3b1x30rlw9cb0d
2012-12-17 16:23:03 +01:00
Vo Minh Thu e7f4891d46 [IMP] use the openerp namespace.
bzr revid: vmt@openerp.com-20121206145632-0h1coh5aaem65wsy
2012-12-06 15:56:32 +01:00
Foram Katharotiya (OpenERP) 16dd332339 [IMP] remove extra column day,month,year in timesheet report
bzr revid: fka@tinyerp.com-20121022063655-r7f9hof8i4aho0oj
2012-10-22 12:06:55 +05:30
Amit Patel e7519ddcec [MERGE]:trunk
bzr revid: apa@tinyerp.com-20121018115554-pq84emgkh4eb47ij
bzr revid: apa@tinyerp.com-20121022051933-s4zgepxyu5wogswd
2012-10-22 10:49:33 +05:30
Fabien Pinckaers 6c15bcce12 [MERGE] HR
bzr revid: fp@openerp.com-20121021195925-sbsfni9i10r2o2bw
2012-10-21 21:59:25 +02:00
Amit Patel 519c621acb [FIX]:hr_timesheet:ProgrammingError: column timesheet_report.day does not exist:LINE 1: ...d) AS id, count(timesheet_report.id) AS day_count,"timesheet...
bzr revid: apa@tinyerp.com-20121017101534-pixtr1ayjw3xgk3k
2012-10-17 15:45:34 +05:30
Atul Patel (OpenERP) 53c70856c3 [MERGE]: Merged with lp:openobject-addons
bzr revid: atp@tinyerp.com-20121011153329-nssuw7jzxzfjyhm7
2012-10-11 21:03:29 +05:30
Fabien Pinckaers 20fefed4c7 [MERGE] create=false
bzr revid: fp@openerp.com-20121010200511-yjmajwybmf3yfitm
2012-10-10 22:05:11 +02:00
pankita shah (Open ERP) e65a9208b8 [Fix] when click time sheet timesheet sheet analysis in reporting
bzr revid: shp@tinyerp.com-20121010090913-lugvm9jwb43hdmmq
2012-10-10 14:39:13 +05:30
Atul Patel (OpenERP) 257d03f403 [MERGE]: Merged with lp:openobject-addons
bzr revid: atp@tinyerp.com-20121003052447-99gpby70gy2fbhih
2012-10-03 10:54:47 +05:30
niv-openerp 51ba7db167 Removed date_current
bzr revid: nicolas.vanhoren@openerp.com-20121002123906-n8nuv9181mv0md83
2012-10-02 14:39:06 +02:00
Fabien Pinckaers 00e8128412 [MERGE]
bzr revid: fp@tinyerp.com-20120928083213-7iiif73rxb2m1kxv
2012-09-28 10:32:13 +02:00
Nimesh (Open ERP) 8c42299413 [REMOVE] remove create button form all posgress report.
bzr revid: nco@tinyerp.com-20120927083839-ruhpxzwgdyasodfe
2012-09-27 14:08:39 +05:30
Foram Katharotiya (OpenERP) 942c10775d [IMP] rename quantity field into Time Quantity in timesheets
bzr revid: fka@tinyerp.com-20120921092139-v0zivzne452qc8h1
2012-09-21 14:51:39 +05:30
Twinkle Christian (OpenERP) 721adad01e [IMP]Remove type field from the whole hr module
bzr revid: tch@tinyerp.com-20120808124839-ecd1uic8mscg3s7f
2012-08-08 18:18:39 +05:30
Fabien Pinckaers ea52cfae17 [IMP] introducing new file type: html
bzr revid: fp@openerp.com-20120804143556-457q040g6q30x3fu
2012-08-04 16:35:56 +02:00
Fabien Pinckaers 4e69bdd6fc [IMP] improved menu tips - 10 firsts clicks
bzr revid: fp@openerp.com-20120804132136-2b18cfkwv0njsglj
2012-08-04 15:21:36 +02:00
Twinkle Christian (OpenERP) cb1c6c08af [IMP]Improve search view in all modules
bzr revid: tch@tinyerp.com-20120731112804-a0akxtqr1z0uew6w
2012-07-31 16:58:04 +05:30
Turkesh Patel (Open ERP) 579a41ab12 [IMP] hr_timesheet_sheet: improved search views.
bzr revid: tpa@tinyerp.com-20120720113333-4qou6upyblvy617h
2012-07-20 17:03:33 +05:30
Pinakin Nayi (OpenERP) e65b5db25a [IMP]reporting-checker-wizards-menus
bzr revid: pna@tinyerp.com-20120627115613-e6q3wh7428b217e6
2012-06-27 17:26:13 +05:30
Purnendu Singh (OpenERP) 2663cbca6e [MERGE] hr_*: make some improvements and Merge cha branch
bzr revid: psi@tinyerp.com-20120615125750-7yanak6d4282nk4u
2012-06-15 18:27:50 +05:30
Divyesh Makwana (Open ERP) d18cb96c97 [Merge] Merge with main addons.
bzr revid: mdi@tinyerp.com-20120528062205-ukjcxs41f917dsk2
2012-05-28 11:52:05 +05:30
Divyesh Makwana (Open ERP) c249a5fe31 [IMP] hr_timesheet_sheet : Removed all filters related to a date field and added the related date field in the search view.
bzr revid: mdi@tinyerp.com-20120522072837-kfzhzjliex4nmlkt
2012-05-22 12:58:37 +05:30
Saurang Suthar (OpenERP) a2a05cfc19 [IMP]:improved titles State by Status everywhere
bzr revid: ssu@tinyerp.com-20120504115748-2vd1dns7bxptg384
2012-05-04 17:27:48 +05:30
Raphael Collet e4efcb808d [IMP] hr*: remove group_extended
bzr revid: rco@openerp.com-20120425141135-9jgai7os8mxj80go
2012-04-25 16:11:35 +02:00
Numerigraphe - Lionel Sausin 779fa653c1 [IMP] Added missing vim mode lines
lp bug: https://launchpad.net/bugs/524279 fixed

bzr revid: ls@numerigraphe.fr-20111122085138-x6u2lcl6vrpyybp9
2011-11-22 09:51:38 +01:00
Fabien Pinckaers e2fbf93799 [IMP] analysis view, filter OR year/month
bzr revid: fp@tinyerp.com-20111114091831-h6mx15bpnti694pa
2011-11-14 10:18:31 +01:00
Jagdish Panchal (Open ERP) 671a010604 [imp] improvement Analysis HR
bzr revid: jap@tinyerp.com-20111111104606-td601olh0ypgz2cz
2011-11-11 16:16:06 +05:30
Fabien Pinckaers 05d6d35cc8 [Merge]
bzr revid: fp@tinyerp.com-20110917110317-34apz3spz1h9azjl
2011-09-17 13:03:17 +02:00
Xavier Morel 178fec5c64 [FIX] str 'in' str (singletons missing tuple-building comma), in @colors attributes. Replace by string equality
bzr revid: xmo@openerp.com-20110911135025-v9yct8pnjfj21tyj
2011-09-11 15:50:25 +02:00
Xavier Morel 4e6a9ea55c [REM] all @col and @colspan attributes on groups in search views: search views are not laid out by columns, therefore these attributes do not belong
bzr revid: xmo@openerp.com-20110315140859-uh9w3exdit84qz47
2011-03-15 15:08:59 +01:00
qdp-launchpad@tinyerp.com 9597d00cc6 [MERGE] merged the olt branch related to decimal precision
bzr revid: qdp-launchpad@tinyerp.com-20101230141937-xo00esnrjga0gdy0
2010-12-30 15:19:37 +01:00