Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Looking for the pla...
 
Notifications
Clear all

Looking for the planning file code

8 Posts
2 Users
0 Reactions
4,727 Views
(@sogeti)
Posts: 135
Active Member
Topic starter
 
[#5856]

Hello,

I am looking for the code which generates the "Reports=>Planning=>monthly planning resource/project/activity".
Can you please tell me which file(s) have this code ?

Thank you in advance.


 
Posted : 21 Mar 2019 14H01
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

/report/detailPlan.php


 
Posted : 22 Mar 2019 11H49
(@sogeti)
Posts: 135
Active Member
Topic starter
 

I have another question.
I can't find the variables which give us these results in the file you mentioned.

Can you please tell me their name ?
Also, which tables in the DB stores this information ?

Thank you in advance


 
Posted : 27 Mar 2019 16H16
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

This report uses tables "work" and "plannedwork"


 
Posted : 27 Mar 2019 19H17
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Thank you.
And do you have a variable in the file which show the result on the web ?


 
Posted : 28 Mar 2019 12H13
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Sorry, I don't understand your request.


 
Posted : 28 Mar 2019 18H11
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Actually, I wanted to know if there is a variable for this result in the report.

I saw the variable called $lineSum but it doesn't seem to be the good one.
I am looking for the variable who add each "work" per day and give us the total of assigned work for the day.

I don't know if it is clear now.


 
Posted : 28 Mar 2019 19H29
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

the $lineSum is not a DB field.
It is caculated in php script from sum of work.work and plannewwork.work for given resource and day.


 
Posted : 30 Mar 2019 16H36
Share:

Scroll to Top