GanttPage - Revision history

Tvi: Added export section

2023-07-04T10:05:31Z

Added export section

← Older revision		Revision as of 12:05, 4 July 2023
Line 166:		Line 166:
	Example:<br/>		Example:<br/>
	To override the field used for Title, add ''&Gantt.Field.Title=[field-name]'' to the url		To override the field used for Title, add ''&Gantt.Field.Title=[field-name]'' to the url

			== Exporting ==
			The chart supports exporting to Excel and iCal formats.

			It's possible to overwrite the export, be declaring a javascript function named <code>customExportToExcel</code> or <code>customExportToICal</code>. Either takes one argument: the gantt object.

			Heres an example that removes html markup from the gantt titles before export.<syntaxhighlight lang="javascript" line="1">
			function customExportToExcel(gantt) {
			var data = gantt.getDatastore("task").getVisibleItems();
			var rtn = [];
			for (var i = 0; i < data.length; i++) {
			var d = new Date(data[i].start_date);
			rtn[i] = {
			color: data[i].color,
			duration: data[i].duration,
			id: data[i].id,
			open: data[i].open,
			parent: (data[i].parent == "0" \|\| data[i].parent == 0 ? "" : data[i].parent),
			progress: data[i].progress,
			start_date: d.getFullYear() + "-" + ("0"+(d.getMonth()+1)).slice(-2) + "-" + ("0" + d.getDate()).slice(-2) + " " + ("0" + d.getHours()).slice(-2) + ":" + ("0" + d.getMinutes()).slice(-2),
			text: $(data[i].text).text(),
			};
			}
			console.log(rtn);
			viewGantt({data: rtn, links: []});
			setTimeout(function() {
			gantt.exportToExcel();
			}, 5);
			setTimeout(loadGantt, 100);
			}
			</syntaxhighlight>

Tvi: 8 revisions imported

2021-12-10T10:52:41Z

8 revisions imported

← Older revision

Revision as of 12:52, 10 December 2021

old>Tvi: /* About */

2021-08-05T12:29:14Z

About

← Older revision		Revision as of 14:29, 5 August 2021
Line 2:		Line 2:
	The platform has a build-in gantt chart generator.<br/>		The platform has a build-in gantt chart generator.<br/>
	It supports zooming, nesting and relations.		It supports zooming, nesting and relations.

			The datastructure has to be a single entity.<br/>
			If your data isn't contained in a single entity use [[Gantt Sync CodeUnit]].

	=== Sample ===		=== Sample ===

old>Tvi: /* Advanced usage */

2021-07-30T11:16:26Z

Advanced usage

← Older revision		Revision as of 13:16, 30 July 2021
Line 159:		Line 159:

	== Advanced usage ==		== Advanced usage ==
	It's possible to override the static ~~config~~.<br/>		It's possible to override the static content.<br/>
	To do so, add the desired value to the url.<br/>		To do so, add the desired value to the url.<br/>
	Example:<br/>		Example:<br/>
	To override the field used for Title, add ''&Gantt.Field.Title=[field-name]'' to the url		To override the field used for Title, add ''&Gantt.Field.Title=[field-name]'' to the url

old>Tvi: /* Advanced usage */

2021-07-30T11:15:13Z

Advanced usage

← Older revision		Revision as of 13:15, 30 July 2021
Line 159:		Line 159:

	== Advanced usage ==		== Advanced usage ==
			It's possible to override the static config.<br/>
			To do so, add the desired value to the url.<br/>
			Example:<br/>
			To override the field used for Title, add ''&Gantt.Field.Title=[field-name]'' to the url

old>Tvi: /* All configurations */

2021-07-30T10:09:38Z

All configurations

@@ Line 43: / Line 43: @@
 {|
 |'''Static config'''
 |'''Description'''
 |-
 |Gantt.Field.Group
+|GROUP_VALUE
 |-
 |Gantt.Field.StartDate
+|STARTDATE
 |-
 |Gantt.Field.EndDate
+|ENDDATE
 |-
 |Gantt.Field.Code
+|CODE
 |-
 |Gantt.Field.Title
+|TITLE
 |-
 |Gantt.Field.Progress
+|
 |-
 |}
 == Advanced usage ==

old>Tvi: /* Basic setup */

2021-07-30T09:57:37Z

Basic setup

← Older revision		Revision as of 11:57, 30 July 2021
Line 8:		Line 8:
	== Basic setup ==		== Basic setup ==
	To view a gantt chart, first access the page main?command=dk.tempusserva.gantt.DhtmlXGanttPage to generate the required '''static configurations'''.<br/>		To view a gantt chart, first access the page main?command=dk.tempusserva.gantt.DhtmlXGanttPage to generate the required '''static configurations'''.<br/>
	~~Seven~~ fields are required in the table, that the data is being read from:<br/>		Six fields are required in the table, that the data is being read from:<br/>
	Code, Title, Group, Start date, End date, Progress ~~and Description~~.		Code, Title, Group, Start date, End date and Progress.

	Code and Title have to be single-line text inputs.<br/>		Code and Title have to be single-line text inputs.<br/>
	~~Description can be a multi or single-line input.<br/>~~
	Progress has to be an integer input, it represents how far along the task is, in percent.<br/>		Progress has to be an integer input, it represents how far along the task is, in percent.<br/>
	Start and End date have to be dates.<br/>		Start and End date have to be dates.<br/>

old>Tvi: /* All configurations */

2021-07-30T09:57:16Z

All configurations

← Older revision		Revision as of 11:57, 30 July 2021
Line 42:		Line 42:
	== All configurations ==		== All configurations ==

			{\|
			\|'''Static config'''
			\|'''Description'''
			\|-

			\|Gantt.Field.Group
			\|
			\|-

			\|Gantt.Field.StartDate
			\|
			\|-

			\|Gantt.Field.EndDate
			\|
			\|-

			\|Gantt.Field.Code
			\|
			\|-

			\|Gantt.Field.Title
			\|
			\|-

			\|Gantt.Field.Progress
			\|
			\|-
			\|}

	== Advanced usage ==		== Advanced usage ==

old>Tvi: /* Relations */

2021-07-30T09:52:16Z

Relations

← Older revision		Revision as of 11:52, 30 July 2021
Line 33:		Line 33:

	From and To have to store the DataID of the tasks that should be linked via a relation. This setup is the same as Group.<br/>		From and To have to store the DataID of the tasks that should be linked via a relation. This setup is the same as Group.<br/>
	Type has to have value of 1 or 0, any other value is overwritten to 0. This defines whether the relation is drawn from the beginning or end of the From-task.		Type has to have value of 1 or 0, any other value is overwritten to 0. This defines whether the relation is drawn from the beginning (1) or end (0) of the From-task.

	To view the gantt chart, access: main?command=dk.tempusserva.gantt.DhtmlXGanttPage&SagID=[SagID]&LinkSagID=[RelationSagID]		To view the gantt chart, access: main?command=dk.tempusserva.gantt.DhtmlXGanttPage&SagID=[SagID]&LinkSagID=[RelationSagID]

old>Tvi: Created page with "== About == The platform has a build-in gantt chart generator.
It supports zooming, nesting and relations. === Sample === File:GanttSample.png == Basic setup == To..."

2021-07-30T09:51:08Z

Created page with "== About == The platform has a build-in gantt chart generator. It supports zooming, nesting and relations. === Sample === File:GanttSample.png == Basic setup == To..."

New page

== About ==
The platform has a build-in gantt chart generator. 
It supports zooming, nesting and relations.

=== Sample ===
[[File:GanttSample.png]]

== Basic setup ==
To view a gantt chart, first access the page main?command=dk.tempusserva.gantt.DhtmlXGanttPage to generate the required '''static configurations'''. 
Seven fields are required in the table, that the data is being read from: 
Code, Title, Group, Start date, End date, Progress and Description.

Code and Title have to be single-line text inputs. 
Description can be a multi or single-line input. 
Progress has to be an integer input, it represents how far along the task is, in percent. 
Start and End date have to be dates. 
Group should store the DataID of the parent-task. Here a database-lookup is used, executing query: SELECT DataID, Resume FROM data_ganttdata and displaying field Resume.

Also at least 5 statuses: 
Active, Suspended, Completed, Failed and Waiting. 
All other statuses will be marked as Undefined.

To view the gantt chart, access: main?command=dk.tempusserva.gantt.DhtmlXGanttPage&SagID=[SagID]

=== Sample ===
[[File:GanttSetupSample.png]]

== Relations ==
To view relations between tasks, create another table. 
Two fields are required: 
From and To. 
A third field Type can be added, but isn't required.

From and To have to store the DataID of the tasks that should be linked via a relation. This setup is the same as Group. 
Type has to have value of 1 or 0, any other value is overwritten to 0. This defines whether the relation is drawn from the beginning or end of the From-task.

To view the gantt chart, access: main?command=dk.tempusserva.gantt.DhtmlXGanttPage&SagID=[SagID]&LinkSagID=[RelationSagID]

=== Sample ===
[[File:GanttRelationSetupSample.png]]

== All configurations ==

== Advanced usage ==

GanttPage - Revision history

Tvi: Added export section

Tvi: 8 revisions imported

old>Tvi: /* About */

old>Tvi: /* Advanced usage */

old>Tvi: /* Advanced usage */

old>Tvi: /* All configurations */

old>Tvi: /* Basic setup */

old>Tvi: /* All configurations */

old>Tvi: /* Relations */

old>Tvi: Created page with "== About == The platform has a build-in gantt chart generator. It supports zooming, nesting and relations. === Sample === File:GanttSample.png == Basic setup == To..."

old>Tvi: Created page with "== About == The platform has a build-in gantt chart generator.
It supports zooming, nesting and relations. === Sample === File:GanttSample.png == Basic setup == To..."