View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Changing ressources cost - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Changing ressources cost

More
19 Sep 2017 22:55 #1 by Durou C
I would like to change the journaly cost of ressources, when i change the cost of each ressources, its take a long time. Sometime its works, sometime i get a error message.

I suppose that every affectation must be change with the new journaly cost, is it possible to change it without error message ?

Please Connexion or Create an account to join the conversation.

More
20 Sep 2017 09:19 #2 by Durou C
Replied by Durou C on topic Changing ressources cost
show the error in log files:

2017-09-20 08:48:30.150 ===== TRACE ===== NEW CONNECTED USER 'jop'
2017-09-20 08:48:42.618 ***** ERROR ***** [V6.4.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idProduct' in 'IN/ALL/ANY subquery'
2017-09-20 08:48:42.618 ***** ERROR ***** [V6.4.0] For query : select * from work where ( ((idProject in (3, 83, 85, 86, 87, 88, 221, 84, 12, 104, 165, 267, 338, 109, 157, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 7, 144, 135, 166, 187, 188, 189, 190, 191, 192, 193, 241, 242, 243, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 186, 197, 198, 236, 325, 326, 327, 344, 238, 259, 245, 240, 239, 196, 222, 225, 223, 224, 235, 234, 304, 322, 347, 60, 136, 73, 228, 276, 33, 285, 283, 284, 286, 287, 288, 289, 290, 291, 292, 71) or (idProject is null and idProduct in (select idProduct from version existV, versionproject existVP where existV.id=existVP.idVersion and existVP.idProject in (3, 83, 85, 86, 87, 88, 221, 84, 12, 104, 165, 267, 338, 109, 157, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 7, 144, 135, 166, 187, 188, 189, 190, 191, 192, 193, 241, 242, 243, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 186, 197, 198, 236, 325, 326, 327, 344, 238, 259, 245, 240, 239, 196, 222, 225, 223, 224, 235, 234, 304, 322, 347, 60, 136, 73, 228, 276, 33, 285, 283, 284, 286, 287, 288, 289, 290, 291, 292, 71)))) or ((1=4) and idProject in (0) ) or ((1=3) and idProject in (0) )) and (idProject not in (0) or idProject is null ) or idResource=6) and month='201709' and idResource='6'
2017-09-20 08:48:42.618 ***** ERROR ***** [V6.4.0] Strack trace :
2017-09-20 08:48:42.618 ***** ERROR ***** [V6.4.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2250]
2017-09-20 08:48:42.618 ***** ERROR ***** [V6.4.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/report/work.php:133]
2017-09-20 09:04:03.937 ===== TRACE ===== NEW CONNECTED USER 'chd'

Please Connexion or Create an account to join the conversation.

More
20 Sep 2017 18:01 #3 by babynus
Replied by babynus on topic Changing ressources cost
Log file deals with error ir report work.php.
Nothing to do with changing resource cost.

What you possibly try to do is change an existing cost for resource with existing work for long period.
Projector changes cost for all real work already entered (in the past) so this may be quite long...
I guess what you expect to to is add a new cost, from current day...

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Sep 2017 18:05 #4 by Durou C
Replied by Durou C on topic Changing ressources cost
thanks for your explain.

Projeqtor take automatically the new cost in new affectation ?

Please Connexion or Create an account to join the conversation.

More
20 Sep 2017 18:08 - 20 Sep 2017 18:08 #5 by babynus
Replied by babynus on topic Changing ressources cost
In new assignment, yes.
And if you enter past date for new cost, it takes it into account also for real work in the past.

Babynus
Administrator of ProjeQtOr web site
Last edit: 20 Sep 2017 18:08 by babynus.
The following user(s) said Thank You: Durou C

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.043 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.