Project save: Difference between revisions
More actions
| No edit summary | No edit summary | ||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| {{HelpFiles}}  | |||
| ==== Project_save  ==== | |||
| Save a project object to the database  | |||
| '''Syntax'''  | |||
| Project_save(''projectObject'')  | |||
| '''Arguments'''  | |||
| *''projectObject'': is an ''array''. It is the project object which contains the following items | |||
| {| width="875" cellspacing="0" cellpadding="2" border="1" style="border: 1px solid rgb(1, 1, 1); border-collapse: collapse;" class="tableintopic" | |||
| |- valign="top" align="left" | |||
| | width="292" bgcolor="#c0c0c0" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| '''Index'''  | |||
| | width="116" bgcolor="#c0c0c0" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| '''Data type'''  | |||
| | width="467" bgcolor="#c0c0c0" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| '''Value'''  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">OBJECT_TYPE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Object type (Default value: 4)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_RESOURCE_ID</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Resource id (Default value: 0)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_NAME</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">string</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Project name</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_TEMPLATE_RESOURCE_ID</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Project template's resource id</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_TIME_REGISTRATION</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">bool</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">If time registration is allowed (Default value: True)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_COMPLETED</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">bool</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Complete a project (Default value: False)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_PARENT_RESOURCE_ID</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Project's path</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_CODE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">string</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Project code</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_PROPOSE_CODE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Propose Code [Read Only]</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_CLIENT_REF_NO</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">string</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Client ref no (Default value: Empty)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_TIME_BUDGET</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">number</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Time Budget</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_CALCULATED_MAN_HOURS</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">bool</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Calculated Man-Hours (Default value: False)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_PLANNED_START_DATE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">array (date time)</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Planned Start Date (Default value: MinDate)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_ACTUAL_START_DATE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">array (date time)</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Actual Start Date (Default value: MinDate)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_PLANNED_END_DATE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">array (date time)</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Planned End Date (Default value: MaxDate)</span>  | |||
| |- valign="top" align="left" | |||
| | width="292" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">PROJECT_ACTUAL_END_DATE</span>  | |||
| | width="116" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">array (date time)</span>  | |||
| | width="467" style="border: 1px solid rgb(1, 1, 1);" |  | |||
| <span class="normalise">Actual End Date (Default value: MaxDate)</span>  | |||
| |} | |||
| '''Return value'''  | |||
| '' | ''empty''   | ||
| '''Example'''   | |||
| '' | ''array project = Project_new("My new project", 15548984, 50755);''   | ||
| ''print(project);''   | |||
| '' | ''//Result: {4,0,My new project,15548984,True,False,50755,CC10014CCC,10014,,0,False,{1,1,1,7,0,0,0,1,65},{1,1,1,7,0,0,0,1,65},{9999,12,31,23,59,59,999,52,65},{9999,12,31,23,59,59,999,52,65}}''   | ||
| '' | ''project[PROJECT_PLANNED_START_DATE] = getDateTime();''   | ||
| '' | ''Project_save(project); ''   | ||
| '' | ''print(project);''   | ||
| ''project | ''//Result: {4,37279418,My new project,15548984,True,False,50755,CC10014CCC,10014,,0,False,{2011,12,22,17,14,25,187,51,65},{1,1,1,7,0,0,0,1,65},{9999,12,31,23,59,59,999,52,65},{9999,12,31,23,59,59,999,52,65}}''   | ||
| '' | '''Availability'''   | ||
| Version 5.6 __NOTOC__ <!-- imported from file: 6264.htm-->  | |||
| [[Category:Project]] | |||
Latest revision as of 10:21, 22 December 2011
Project_save
Save a project object to the database
Syntax
Project_save(projectObject)
Arguments
- projectObject: is an array. It is the project object which contains the following items
| Index | Data type | Value | 
| OBJECT_TYPE | number | Object type (Default value: 4) | 
| PROJECT_RESOURCE_ID | number | Resource id (Default value: 0) | 
| PROJECT_NAME | string | Project name | 
| PROJECT_TEMPLATE_RESOURCE_ID | number | Project template's resource id | 
| PROJECT_TIME_REGISTRATION | bool | If time registration is allowed (Default value: True) | 
| PROJECT_COMPLETED | bool | Complete a project (Default value: False) | 
| PROJECT_PARENT_RESOURCE_ID | number | Project's path | 
| PROJECT_CODE | string | Project code | 
| PROJECT_PROPOSE_CODE | number | Propose Code [Read Only] | 
| PROJECT_CLIENT_REF_NO | string | Client ref no (Default value: Empty) | 
| PROJECT_TIME_BUDGET | number | Time Budget | 
| PROJECT_CALCULATED_MAN_HOURS | bool | Calculated Man-Hours (Default value: False) | 
| PROJECT_PLANNED_START_DATE | array (date time) | Planned Start Date (Default value: MinDate) | 
| PROJECT_ACTUAL_START_DATE | array (date time) | Actual Start Date (Default value: MinDate) | 
| PROJECT_PLANNED_END_DATE | array (date time) | Planned End Date (Default value: MaxDate) | 
| PROJECT_ACTUAL_END_DATE | array (date time) | Actual End Date (Default value: MaxDate) | 
Return value
empty
Example
array project = Project_new("My new project", 15548984, 50755);
print(project);
//Result: {4,0,My new project,15548984,True,False,50755,CC10014CCC,10014,,0,False,{1,1,1,7,0,0,0,1,65},{1,1,1,7,0,0,0,1,65},{9999,12,31,23,59,59,999,52,65},{9999,12,31,23,59,59,999,52,65}}
project[PROJECT_PLANNED_START_DATE] = getDateTime();
Project_save(project);
print(project);
//Result: {4,37279418,My new project,15548984,True,False,50755,CC10014CCC,10014,,0,False,{2011,12,22,17,14,25,187,51,65},{1,1,1,7,0,0,0,1,65},{9999,12,31,23,59,59,999,52,65},{9999,12,31,23,59,59,999,52,65}}
Availability
Version 5.6
