Messages

1

Community Contributions / Re: METHOD 2: How to Add Gantt Charts (JSGantt) to Feng Office

« on: May 18, 2010, 02:05:54 am »

Hi 

This feature rocks! Took me a while to figure out that the report is in the Tasks tab though.

Sorry, I forgot put information about integration. I try to attach a screenshot but i get an error.

BTW,  Gantt integration is put as an icon in Task Tab

2

Community Contributions / Re: METHOD 2: How to Add Gantt Charts (JSGantt) to Feng Office

« on: May 14, 2010, 11:19:14 am »

Thanks! 

I'm working in other changes like sort by properties, i.e sort by completed, start date, due date, and I changed the gantt icon, rename it and replace.

I'll upload other patch soon.

If there are bugs, tell me please

3

Community Contributions / METHOD 2: How to Add Gantt Charts (JSGantt) to Feng Office

« on: May 06, 2010, 04:01:25 pm »

Thanks for interesting

I develop on gnu/linux, I can explaine for *nix systems:

Code: [Select]

cd /path/to/fengoffice/
cp /path/to/patch/fo_gantt-1.7_rc.patch.gz ./
gunzip fo_gantt-1.7_rc.patch.gz
cat fo_gantt-1.7_rc.patch |patch -p1
cp /path/to/gantt/image/gantt.png public/assets/themes/default/images/16x16/


Example:

Code: [Select]

cd /var/www/fengoffice/
cp /home/darkbalder/downloads/fo_gantt-1.7_rc.patch.gz ./
gunzip fo_gantt-1.7_rc.patch.gz
cat fo_gantt-1.7_rc.patch |patch -p1
cp /home/darkbalder/downloads/gantt.png public/assets/themes/default/images/16x16/

Here a link to patch for windows http://gnuwin32.sourceforge.net/packages/patch.htm, I dont know how to use it, but it can be useful

4

Community Contributions / METHOD 2: How to Add Gantt Charts (JSGantt) to Feng Office

« on: May 06, 2010, 02:06:32 pm »

Hi,

I was reviewing the code here:

http://forums.fengoffice.com/index.php?topic=3826.0

... and I have a gantt version using existing javascript objects (ogTasks.Tasks, ogTasks.Milestones, ...)

I provide an diff file to patch fengooffice. I tried this patch on version 1.7_rc and 1.6.2. I develop it with version 1.7_rc but  with version 1.6.2 works.

Gantt image (gantt.png) should be at public/assets/themes/default/images/16x16/ directory.


Actual features:
- Show active workspace and subworkspaces. if select *All* workspaces, it will show all workspaces.
- Show milestones, tasks subtasks. If a task has subtask, it will be showed as group;
- Task colors are based in dueDate. Completed tasks are showed in blue, pending tasks are showed in orange and late tasks are showed in red.


If you have time, help me testing and posting results, please.

Thanks for your work!  

5

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: April 22, 2010, 11:42:13 am »

Thanks for your help,

gah242s,  that's the solution!

I'm not an sql expert and php noob but I think is better work with php to code functions for get gantt data, what do you think?. I really need this module and I can contribute to develop it .

6

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: April 21, 2010, 03:39:02 pm »

I don't think that white spaces are ignored because when I documented this line:

Code: [Select]

DELETE FROM my_tblworkspaces;

there is another error in procedure's line 246:

Code: [Select]

ORDER BY pOrderBy) AS subSelect, (SELECT @rowcount:=0) AS rowcountinit;

the error:

Code: [Select]

ERROR 1064 (42000) at line 198: 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 246

BTW, In which version on mysql this script runs well?

Thanks for your time

7

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: April 21, 2010, 02:13:51 pm »

Line 198 is:

CREATE PROCEDURE fo.`get_my_workspaces`()

and procedure's Line 4:

DELETE FROM my_tblworkspaces;     

Code: [Select]


CREATE PROCEDURE fo.`get_my_workspaces`()
BEGIN

DELETE FROM my_tblworkspaces;

INSERT INTO my_tblworkspaces

...


8

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: April 21, 2010, 01:35:10 pm »

Hi,

First of all, Great work!!!

I'm trying to install but:

When I execute feng_gantt_11.2.sql, I have this error:

Code: [Select]

$ mysql -u openuser -p fo < application/views/lab/feng_gantt_11.2.sql
Enter password:
ERROR 1064 (42000) at line 198: 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
It is DELETE FROM my_tblworkspaces;

When I disable this line (using -- ), I have another error:

Code: [Select]

$ mysql -u openuser -p fo < application/views/lab/feng_gantt_11.2.sql
Enter password:
ERROR 1064 (42000) at line 198: 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 246
It is ORDER BY pOrderBy) AS subSelect, (SELECT @rowcount:=0) AS rowcountinit;

What can I do??

My mysql version:
$ mysql -V
mysql  Ver 14.12 Distrib 5.0.90, for pc-linux-gnu (x86_64) using readline 6.1