Menu
▾
▴
#44 Projects custom attributes
Develop a new administration page which will enable the administrator to create new project attribute's categories, allowing each category to be free text or not, multi or single value, and to define a set of possible values. This development must include the protection of the values which are already used by a project.
Those optional attributes can afterwards be filled at the creation/modification of projects.
Logged In: YES
user_id=1760219
Originator: NO
As a first part of development of this feature, only the modifications required on the database have been performed.
Two new tables "project_attribute" and "project_attribute_value" have been added. The first one contains the definitions of new custom attributes. The second one contains the values of those new attributes, whatever they are predefined values, or values set in a particular project.
Note: if the value of the column PRJATB_IsCompulsory is set to 1, it means that the project must have a value defined for this attribute at project creation. And once it has a value, it is possible to change it but no more possible to remove it completely.
But, when modifying a project created before a compulsory attribute was defined, it should be possible to modify the project without giving a value to this new attribute. The attribute will become compulsory for this project only after a value has been given to it.
Once used, a project attribute in a project cannot be deleted.
Still to perform:
- Create a page for creating/modifying project custom attributes.
- Modify the project creation/modification page, in order to add the management of project custom attributes, as described above.
- Modify the project export process to export also the custom attributes for which a project has a value.
Modified files:
htdocs/fonctions/migration_fonctions.php
htdocs/install/base.sql
SVN revision at this stage: 231
This part of the development has been realized under version v1.4, for a later release.