Skip to content

simplicitesoftware/module_project_management

BranchesTags

Repository files navigation

ProjectManagement module definition

Project management modules with tickets and tasks management.

PmGroup business object definition

Groups of rights of the module.

Fields

Name Type Required Updatable Personal Description

PmResponsability business object definition

Users’ responsibilities on groups in the module.

Fields

Name Type Required Updatable Personal Description
rsp_login_id link to PmUser id yes* yes -
rsp_group_id link to PmGroup id yes* yes -
row_module_id link to Module id yes yes Module
Ref. row_module_id.mdl_name regexp(100) Module name

PmTaskHistoric business object definition

Historic of tasks

Fields

Name Type Required Updatable Personal Description
row_ref_id link to PmTask id yes* Record row ID
row_idx int(11) yes* yes History record index
created_by_hist char(100) yes* Created by
created_dt_hist datetime yes* Created date
pmTskNumber char(100) yes* -
pmTskTitle char(100) yes yes -
pmTskDescription text(4000) yes -
pmTskStatus enum(100) using PM_TSK_STATUT list yes yes -
pmTskPriority enum(100) using PM_TSK_PRIORITE list yes yes -
pmTskClose date yes yes -
pmTskVrsId link to PmVersion id yes* yes -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -
Ref. pmTskVrsId.pmVrsName char(200) Concatenation of project name and version number
pmTskType enum(100) using PM_TSK_TYPE list yes yes -

Lists

  • PM_TSK_STATUT
    • DRAFT Draft
    • TODO To do
    • DOING Doing
    • DONE Done
    • CLOSED Closed
    • CANCEL Cancel
    • REJECTED Rejected
  • PM_TSK_PRIORITE
    • LOW Faible
    • NORMAL Normal
    • HIGH Haute
    • URGENT Urgent
    • IMMEDIATE Immédiat
  • PM_TSK_TYPE
    • BUG Defect
    • MEE Meeting
    • TSK TASK

PmUser business object definition

Users of the module.

Fields

Name Type Required Updatable Personal Description
pmUsrNbTask int(100) -
usr_lang enum(3) using LANG list yes yes yes Language
usr_active enum(1) using USER_STATUS list yes -
usr_home_id link to View id yes -
Ref. usr_home_id.viw_name char(100) -
row_module_id link to Module id yes yes Module
Ref. row_module_id.mdl_name regexp(100) Module name

Lists

  • LANG
    • ENU English language
    • FRA French language
  • USER_STATUS
    • 0 Disabled
    • 1 Enabled
    • 2 Pending
    • 3 Web services only

PmProject business object definition

Fields

Name Type Required Updatable Personal Description
pmPrjName char(100) yes* yes -
pmPrjService enum(100) using PM_PRJ_SERVICE list yes yes -
pmPrjDescription text(1000) yes -
pmPrjBudget float(100, 2) yes -

Lists

  • PM_PRJ_SERVICE
    • SERVICEA Service A
    • SERVICEB Service B
    • SERVICEC Service C

PmVersion business object definition

Project version

Fields

Name Type Required Updatable Personal Description
pmVrsVersion char(100) yes* yes -
pmVrsPublicationDate date yes yes -
pmVrsStatus enum(100) using PM_VRS_STATUS list yes yes -
pmVrsName char(200) Concatenation of project name and version number
pmVrsPrjId link to PmProject id yes* yes -
Ref. pmVrsPrjId.pmPrjName char(100) -
pmVrsCompletion int(100) -

Lists

  • PM_VRS_STATUS
    • ALPHA Alpha
    • BETA Beta
    • PUBLISHED Published version

Custom actions

  • PM_DEFER_TASK:
  • PM_UPDATE_GANTT:

PmTask business object definition

Tasks of project

Fields

Name Type Required Updatable Personal Description
pmTskNumber char(100) yes* -
pmTskTitle char(100) yes yes -
pmTskDescription text(4000) yes -
pmTskStatus enum(100) using PM_TSK_STATUT list yes yes -
pmTskPriority enum(100) using PM_TSK_PRIORITE list yes yes -
pmTskCreation date yes yes -
pmTskClose date yes yes -
pmTskEffectiveClosingDate date -
pmTskExpectedDuration int(100) yes -
pmTskActualDuration int(100) -
pmTskTimeLeft int(100) -
pmTskUsrId link to PmUser id -
Ref. pmTskUsrId.usr_login regexp(100) yes Login
Ref. pmTskUsrId.usr_first_name char(50) yes First name
Ref. pmTskUsrId.usr_last_name char(50) yes Last name
pmTskPrjVirtualId link to PmProject id yes -
pmTskVrsId link to PmVersion id yes* yes -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -
Ref. pmTskVrsId.pmVrsStatus enum(100) using PM_VRS_STATUS list -
Ref. pmTskVrsId.pmVrsName char(200) Concatenation of project name and version number
Ref. pmTskVrsId.pmVrsPublicationDate date -
pmTskCompletion int(100) yes yes -
pmTskType enum(100) using PM_TSK_TYPE list yes yes -
pmTskLastCron datetime -

Lists

  • PM_TSK_STATUT
    • DRAFT Draft
    • TODO To do
    • DOING Doing
    • DONE Done
    • CLOSED Closed
    • CANCEL Cancel
    • REJECTED Rejected
  • PM_TSK_PRIORITE
    • LOW Faible
    • NORMAL Normal
    • HIGH Haute
    • URGENT Urgent
    • IMMEDIATE Immédiat
  • PM_VRS_STATUS
    • ALPHA Alpha
    • BETA Beta
    • PUBLISHED Published version
  • PM_TSK_TYPE
    • BUG Defect
    • MEE Meeting
    • TSK TASK

Custom actions

  • PM_ASSIGN:
  • PM_TASK_MSG_DELETION:
  • PM_TASK_NOTIF:
  • PM_UPDATE_GANTT:

PmArrayOfTask business object definition

dependency between tasks

Fields

Name Type Required Updatable Personal Description
pmAotPrvTskId link to PmTask id yes* yes -
Ref. pmAotPrvTskId.pmTskNumber char(100) -
Ref. pmAotPrvTskId.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmAotPrvTskId.pmTskStatus enum(100) using PM_TSK_STATUT list -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -
pmAotNextTskId link to PmTask id yes* yes -
Ref. pmAotNextTskId.pmTskNumber char(100) -
Ref. pmAotNextTskId.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmAotNextTskId.pmTskStatus enum(100) using PM_TSK_STATUT list -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -

Lists

  • PM_TSK_STATUT
    • DRAFT Draft
    • TODO To do
    • DOING Doing
    • DONE Done
    • CLOSED Closed
    • CANCEL Cancel
    • REJECTED Rejected

PmDocument business object definition

Useful documents for a task or a project

Fields

Name Type Required Updatable Personal Description
pmDocAttachment document yes -
pmDocTitle char(100) yes* yes -
pmDocTskId link to PmTask id yes -
Ref. pmDocTskId.pmTskNumber char(100) -
Ref. pmDocTskId.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmDocTskId.pmTskTitle char(100) -
Ref. pmVrsPrjId.pmPrjName char(100) -
pmDocPrjId link to PmProject id yes -
Ref. pmDocPrjId.pmPrjName char(100) -
pmDocStatus enum(100) using PM_DOC_STATUS list yes yes -
pmDocType enum(100) using PM_DOC_TYPE list yes yes -

Lists

  • PM_DOC_STATUS
    • WFV Waiting for validation
    • V Valid
  • PM_DOC_TYPE
    • REQ Required
    • DOC Document
    • SPEC Specification

PmRole business object definition

Fields

Name Type Required Updatable Personal Description
pmRolPrjId link to PmProject id yes* yes -
Ref. pmRolPrjId.pmPrjName char(100) -
pmRolUsrId link to PmUser id yes* yes -
Ref. pmRolUsrId.usr_login regexp(100) yes Login
pmRolRole enum(100) using PM_ROL_ROLE list yes yes -

Lists

  • PM_ROL_ROLE
    • ADMIN Admin
    • USER User
    • MANAGER Manager

PmMessage business object definition

Messaging on a task

Fields

Name Type Required Updatable Personal Description
pmMsgTitle char(100) yes* yes -
pmMsgMessage text(100) yes -
pmMsgPublicationDate date yes -
pmMsgUsrId link to PmUser id yes* -
Ref. pmMsgUsrId.usr_login regexp(100) yes Login
pmMsgTskId link to PmTask id * yes -
Ref. pmMsgTskId.pmTskNumber char(100) -
Ref. pmMsgTskId.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmMsgTskId.pmTskTitle char(100) -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -

PmAssignment business object definition

Assignment of a user to a task, allows the establishment of a timesheet

Fields

Name Type Required Updatable Personal Description
pmAssRole enum(100) using PM_ASS_ROLE list yes yes -
pmAssPmUserid link to PmUser id yes* yes -
Ref. pmAssPmUserid.usr_login regexp(100) yes Login
Ref. pmAssPmUserid.pmUsrNbTask int(100) -
pmAssPmTaskid link to PmTask id yes* yes -
Ref. pmAssPmTaskid.pmTskNumber char(100) -
Ref. pmAssPmTaskid.pmTskTitle char(100) -
Ref. pmAssPmTaskid.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsName char(200) Concatenation of project name and version number
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmAssPmTaskid.pmTskStatus enum(100) using PM_TSK_STATUT list -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmVrsPrjId.pmPrjName char(100) -
Ref. pmAssPmTaskid.pmTskPriority enum(100) using PM_TSK_PRIORITE list -
Ref. pmAssPmTaskid.pmTskCreation date -
Ref. pmAssPmTaskid.pmTskClose date -
pmAssQuantity float(6, 2) yes -
pmAssConsumed float(100, 2) yes -

Lists

  • PM_ASS_ROLE
    • DEVELOPER Developpeur
    • MANAGER Manager
  • PM_TSK_STATUT
    • DRAFT Draft
    • TODO To do
    • DOING Doing
    • DONE Done
    • CLOSED Closed
    • CANCEL Cancel
    • REJECTED Rejected
  • PM_TSK_PRIORITE
    • LOW Faible
    • NORMAL Normal
    • HIGH Haute
    • URGENT Urgent
    • IMMEDIATE Immédiat

PmAssignmentPmTimeSheetAssign business object definition

Timesheet of PmAssignmentPmTimeSheetAssign

Fields

Name Type Required Updatable Personal Description
tsh_parent_id link to PmAssignment id yes* yes Assign reference
tsh_year char(4) yes* yes Year
tsh_month char(2) yes* yes Month
tsh_input1 char(255) yes -
tsh_total1 float(11, 2) yes -
Ref. tsh_parent_id.pmAssPmUserid id -
Ref. pmAssPmUserid.usr_login regexp(100) yes Login
Ref. tsh_parent_id.pmAssPmTaskid id -
Ref. pmAssPmTaskid.pmTskNumber char(100) -
Ref. pmAssPmTaskid.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -
Ref. pmTskVrsId.pmVrsVersion char(100) -

PmLabel business object definition

task label, useful for task categorization

Fields

Name Type Required Updatable Personal Description
pmLblName char(100) yes* yes -
pmLblIcone image yes -

PmTskLbl business object definition

Labeling of tasks

Fields

Name Type Required Updatable Personal Description
pmTsklblTskId link to PmTask id yes* yes -
Ref. pmTsklblTskId.pmTskNumber char(100) -
Ref. pmTsklblTskId.pmTskVrsId id -
Ref. pmTskVrsId.pmVrsVersion char(100) -
Ref. pmTsklblTskId.pmTskTitle char(100) -
Ref. pmTskVrsId.pmVrsPrjId id -
Ref. pmVrsPrjId.pmPrjName char(100) -
pmTsklblLblId link to PmLabel id yes* yes -
Ref. pmTsklblLblId.pmLblName char(100) -
Ref. pmTskVrsId.pmVrsVersion char(100) -

PmTaskCreate business process definition

Activities

  • Begin: Begin activity
  • ProjectSelect: Select the project to which the task belongs
  • VersionSelect: Select the version on which to add the task
  • TaskCreation: Creation of the task
  • PreviousTask: Selection of the task on which the task depends
  • NextTask: Selection of the task which will depend on the task
  • Labelling:
  • Assignment: Reflective creation of all assignment
  • End: End activity

PmProjectCalendar external object definition

External object for display calendar of versions and tasks on project form.

PmProjectGantt external object definition

External object for display gantt of versions and tasks on project form.

PmProjectUserTask external object definition

External object for display user task on specific project in project form.

PmTaskWAssingExt external object definition

External object for display unassigned task in menu

PmTimesheetExt external object definition

External object for display user imputation in menu.

PmTimesheetRecapExt external object definition

External object for display details on user imputation view.

About

No description, website, or topics provided.

Resources

Readme
Activity
Custom properties

Stars

0 stars

Watchers

3 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •  

Languages