View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Some help about the code in order to evolve Gantt chart - ProjeQtOr
 
 

[SOLVED] Some help about the code in order to evolve Gantt chart

More
18 Jul 2018 14:14 - 18 Jul 2018 23:26 #1 by Gaspard
(I don't know if I should post this in ask question or submit evolution ?)
Hello everyone,

As part of an internship I have to evolve the Gantt chart by adding the possibility to order Gantt chart per ressources. (planning per ressources is not what I want)

I've already look in many files and read the code, but projeqtor code is oversized. So I'd like to ask for your help Babynus, or anyone who know the architecture of the source code.
Actually the files who seem the most interesting are "jsonResourcesplanning.php" , "SqlElement.php".

I'd like to find the array that stock the SQLrequest that go find the ressources in DB for each activity in a project and try to order this array per ressources.
Actually my notion of SQL request are naive, I mean I write the request completly, but I don't find any naive request of this kind. Like I'd like to find a request that say :
"SELECT idResource FROM activity (and I would add ORDER BY id resource) ;" But of course this is not that easy.
I would understand how the request are made and/or where. It would be very helpfull because I could understand how the exchanges with DB works.

Can you help me please ?

Thank you for responding.
here is the planning

Attachments:
Last edit: 18 Jul 2018 23:26 by Gaspard.

Please Log in or Create an account to join the conversation.

More
18 Jul 2018 17:19 #2 by babynus
Hi,

Requests are much more complex than a query in a single table :)

If you set in parameters.php
$logLevel='3';
$debugJsonQuery=false;
You will have trace of queries for planning display

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
18 Jul 2018 17:57 - 18 Jul 2018 17:57 #3 by Gaspard
I suspected it :pinch: , thank you for your help.

I added this in config/parameters.php (I added it in view/parameter.php first time..) then I checked the log and I don't see trace of query, then I checked all the directory but nothing. Can the trace be somewhere else than in the log ? I'm actually on v6.5.6
Last edit: 18 Jul 2018 17:57 by Gaspard.

Please Log in or Create an account to join the conversation.

More
18 Jul 2018 18:16 #4 by babynus
Check /tool/parametersLocation.php.
It contains location of parameters.php file that you must change.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
18 Jul 2018 19:06 #5 by Gaspard
Done and it's the good one
parameters?php :
<?php
$parametersLocation = '../files/config/parameters.php';

I don't understand why it's doing nothing

Please Log in or Create an account to join the conversation.

More
18 Jul 2018 20:29 #6 by babynus
Then display Planning...

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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