(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
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
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
Check /tool/parametersLocation.php.
It contains location of parameters.php file that you must change.
Done and it's the good one
parameters?php :
<?php
$parametersLocation = '../files/config/parameters.php';
I don't understand why it's doing nothing
Then display Planning...
I added it to my first message I didn't find how to insert message in a response..
I've look for a new option on projeqtor but didn't find this out.
Do we agree that the queries should appear in the log ?
Really, I you cannot find out how to get a debug log (wich is one of the simplest part of Projeqtor) you'd better give up with trying to evolve Gantt chart (which is one of the most complex part of Projeqtor)
Thank you for the quick answer, but giving up is not in my habits, and I still have a lot of time to realize it.
What's more you didn't see what I got in my log(C:UsersCachatortueDocumentskairosbtpv6fileslogs) (last log) :
===== TRACE ===== NEW CONNECTED USER 'admin'
2018-07-18 23:21:32.428 ===== TRACE ===== DISCONNECTED USER 'admin'
2018-07-18 23:21:37.366 ----- DEBUG ----- loginCheck : current db version = 'V6.5.6'
2018-07-18 23:21:37.374 ----- DEBUG ----- User->authenticate('admin', 'f71f4fc87e6d1a0b3705ea792a9986f3')
2018-07-18 23:21:37.384 ----- DEBUG ----- User->authenticate : md5 encryption
2018-07-18 23:21:37.391 ----- DEBUG ----- User->authenticate : Successfull login
2018-07-18 23:21:37.417 ===== TRACE ===== NEW CONNECTED USER 'admin'
So nothing about Gantt chart in there, and this is the only log file that I found, although I explore projeqtor since a week.
Yet I included what you asked me in the right parameters.php
<?php
// =======================================================================================
// Automatically generated parameter file
// on 2018-07-05 13:00:26
// =======================================================================================
$paramDbType='mysql';
$paramDbHost='localhost';
$paramDbPort='3306';
$paramDbUser='root';
$paramDbPassword='';
$paramDbName='projeqtor';
$paramDbPrefix='';
$SslKey='';
$SslCert='';
$SslCa='';
$logFile='../files/logs/projeqtor_${date}.log';
$logLevel='3';
$debugJsonQuery=false;
$enforceUTF8='1';
//======= END
I think it will work better with
$debugJsonQuery=true;
(my fault)
No probem I should have test it with true, but was late .
I have all the queries in my logs I'm working on it, thank you again for your help !