How to Add Gantt Charts (JSGantt) to Feng Office

[allenlook]

Sorry, I don't understand.  Is there a reason you are trying to attach it to the forum?

[LunAnder]

lol - sry - i wasnt very specific. I tried to attach the SQL file I've modded containing all the additional "delimiter" changes alot of us need to do in order to be able to run the query in phpmysql.
I thought I'd share it so that others don't need to do all the edits aswell.
I also changed some uppercase tablenames that needed to be lowercase.

/Anders

[allenlook]

Ah understood.  Thank you.

The SQL changes from time to time as we add improvements, so it might only help for a little while to post updated code.

We've gone ahead and made everything lowercase in the scripts and the code if I'm not mistaken, so that part is fixed.

I don't have phpmysql so I can't vouch for the delimiter problem.

[LunAnder]

yea i know its gonna change but it takes awhile doing the changes so i thought id share it anyway.

There are actually 2 tablenames that still are UpperCase:

Code: [Select]

DROP PROCEDURE IF EXISTS fengoffice_dev.get_my_milestones;
CREATE PROCEDURE fengoffice_dev.`get_my_milestones`()
BEGIN

DELETE FROM my_tblMileStones;

INSERT INTO my_tblMileStones

SELECT CONCAT(my_getworkspacerow(pParent), '.', '5', LPAD(@rowcount:=@rowcount+1, 4, '0')) AS rowcount, subSelect.*
FROM(
select ...


[allenlook]

Fixed (in the SQL).

[emjay]

Hi,
I get the SQL-Error #1418 using phpmyadmin for the SQL-statements:

SQL-Befehl:

CREATE FUNCTION opengoo16fresh.`my_getworkspace` (

sCHAR( 20 )
) RETURNS CHAR( 128 ) CHARSET latin1 RETURN (
SELECT pID
FROM my_workspaces
WHERE pID = s
);

MySQL meldet:

#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)



hmmm, whats wrong?

emjay

[allenlook]

Haven't seen that one before - and I'm no MySQL expert, but I'd start here:

Code: [Select]

#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

[selyay]

@allenlook i have character problems in "Select Workspace","Resources" and "task name" areas,
i m from turkey and our charset is "ISO 8859-9".i tried to change Latin 9 in drop down menu to ISO 8859-9 from index.php source code but it didn't work

Feng office displays Turkish characters without any problems
thanks for your support

[allenlook]

It was my understanding that PHP could display the following character sets, so they are the ones I added to the array in the source code for the selection form:

Code: [Select]

'ISO-8859-15', 'ISO-8859-1', 'cp1252', 'UTF-8', 'cp866', 'cp1251', 'KOI8-R', 'BIG5', 'GB2312', 'BIG5-HKSCS', 'Shift_JIS', 'EUC-JP'
I'm not sure what would happen if you added your ISO code and description to the arrays in the source code.  Are you saying you tried that and it did not help?

The only thing I can think of is to select the same code as your database and see if that works, or select UniCode (UTF-8) and see if that works.  Sorry I'm not much help.

[neurvanaedge]

Hi Allen,

great work on this! I have a few issues though, but I am not sure what might be causing them.

I put the gantt code in /gantt and changed all the reference to same, but for some reason when i click a workspace to view and a person assigned then click submit i simply get returned to the seletion page with no chart.

2nd thing i ran into was a sql error during import:

SQL query:

CREATE PROCEDURE admin_org.`get_my_workspaces` (
) BEGIN DELETE FROM my_tblworkspaces;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

Any ideas?

[allenlook]

Post #3 of this thread has some troubleshooting tips.

For your second problem - I think you have a delimiter problem.  You can look back a page for a possible solution to that (actually the solution is on page 10 IIRC).

For your first problem, I suspect you have a missing object or bad security setting.  You can do a "View Page Source" and see the error at the bottom of the page (HTML) probably.

[gah242s]

Allen,

Thank you very much for adding the ability to use a global config file in 13.1.  However, the index.php file references the views folder instead of the lab folder.  I think that the index.php file should have a single dot instead of a double dot on line 203.

New proposal:

   include './chartglobal.php';

instead of:

   include '../chartglobal.php';

Thanks

[allenlook]

It is written that way so I can conveniently zip all the files each time a new revision is created, and I don't have to worry about including my credentials for our Feng Office installation, which happened several times in the past. 

[selyay]

It was my understanding that PHP could display the following character sets, so they are the ones I added to the array in the source code for the selection form:

Code: [Select]

'ISO-8859-15', 'ISO-8859-1', 'cp1252', 'UTF-8', 'cp866', 'cp1251', 'KOI8-R', 'BIG5', 'GB2312', 'BIG5-HKSCS', 'Shift_JIS', 'EUC-JP'
I'm not sure what would happen if you added your ISO code and description to the arrays in the source code.  Are you saying you tried that and it did not help?

The only thing I can think of is to select the same code as your database and see if that works, or select UniCode (UTF-8) and see if that works.  Sorry I'm not much help.

does those code  selections effect Workspaces and Resources listings?
also some workspaces and resources don't shown, just blank lines
thanks

[allenlook]

Workspaces and Resources are processed and displayed using the "htmlentities" function, per this line of code:

Code: [Select]

$pName = htmlentities($row_RsFeng['pName'], 3, "UTF-8", false); //ENT_NOQUOTES=DEFAULT, ENT_COMPAT=2, ENT_QUOTES=3

You may want to change the UTF-8 argument to something that works better, or the second argument, which handles translation.