TAB_USER Class

Account.

Corresponding to a manager, an administrator or a resource with an intranet.

Show:

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Resource.


Default: 0

ID_ROLE

Int(11)

TAB_ROLE.ID_ROLE.

Role.


Default: 0

ID_USER

Int(11)

Unique identifier.

USER_ABONNEMENT

Tinyint(1)

Subscription's type :

  • 0 : Inactive
  • 1 : Demonstration
  • 3 : Active


Default: 0

USER_ALLOW_ABSENCES

Tinyint(1)

Enable/disabled to enter absences on timesheets :

  • 1 : Customised
  • 0 : Disable


Default: -1

USER_ALLOW_INTERNAL_ACTIVITY

Tinyint(1)

Enable/disabled to enter internal activity on timesheets :

  • 1 : Customised
  • 0 : Disable


Default: -1

USER_ALLOW_PRODUCTION

Tinyint(1)

Enable/disabled to enter production on timesheets :

  • 1 : Customised
  • 0 : Disable


Default: -1

USER_ALLOWABSENCESTYPEHREF

Varchar(250)

References of work unit's type (Only those which design absences) that a user can enter on timesheets and requests of absences, cf. TAB_TYPEHEURE.TYPEH_REF.

Each reference is separated by | character.


Default: ''

Example:

10|11

USER_ALLOWTEMPSEXCEPTION

Tinyint(1)

Enable/disabled to enter exceptional activity on timesheets :

  • 1 : Customised
  • 0 : Disable


Default: -1

USER_APIACCESS

Tinyint(1)

Enable/disable to access api from login/password :

  • 1 : Enable
  • 0 : Disable


Default: 0

USER_CONNECTIONTYPE

Tinyint(1)

Enable/disable the unique authentication from a trusted third party (Google, ...) :

  • 1 : Enable
  • 0 : Disable


Default: 0

USER_DEFAULTSEARCH

Tinyint(1)

Enable/disable to save by default each search :

  • 1 : Enable
  • 0 : Disable


Default: 1

USER_HOMEPAGE

Varchar(250)

Default's user route.

Corresponding to routes on our Ember's Front-End.


Default: 'dashboard'

USER_INTERNAL_ACTIVITY_TYPEHREF

Varchar(250)

References of work unit's type (Only those which design internal activity) that a user can enter on timesheets, cf. TAB_TYPEHEURE.TYPEH_REF.

Each reference is separated by | character.


Default: ''

Example:

10|11

USER_ISLOCKED

Tinyint(1)

Lock/unlock entirely an account :

  • 1 : Lock
  • 0 : Unlock


Default: 0

USER_JOINCATEGORY

Tinyint(1)

Select the default operator used to join perimeter's categories (Agencies, Poles, Business Units, Managers) during searches :

  • 1 : AND
  • 0 : OR


Default: 0

USER_LANGUE

Char(3)

Default user's language :

  • fr : French
  • en : English


Default: 'fr'

USER_LASTCONNEXION

Datetime

Date on which user was logged in the last session following format YYYY-MM-DD HH:MM:SS.

This property can be null.

USER_LOGIN

Varchar(100)

Login.


Default: ''

USER_NUMBEROFFAILEDLOGIN

Tinyint(1)

Number of wrong credentials from the last login :

  • 1 : Enable
  • 0 : Disable


Default: 0

USER_PRODUCTION_TYPEHREF

Varchar(250)

References of work unit's type (Only those which design production) that a user can enter on timesheets, cf. TAB_TYPEHEURE.TYPEH_REF.

Each reference is separated by | character.


Default: ''

Example:

10|11

USER_PWD

Char(32)

Password.


Default: ''

USER_SECURITYALERT

Tinyint(1)

Enable/disable to send an email when a new device is connecting :

  • 1 : Enable
  • 0 : Disable


Default: 1

USER_SECURITYCOOKIE

Tinyint(1)

Enable/disable the management of a devices list allowed to connect :

  • 1 : Enable
  • 0 : Disable


Default: 0

USER_TAUXHORAIRE

Decimal(15,5)

Work unit's rate.

This property can be null, accordingly the default's work unit's rate will be the one of user's agency TAB_GROUPECONFIG.GRPCONF_TAUXHORAIRE.


Default: null

USER_TEMPSEXCEPTION_TYPEHREF

Varchar(250)

References of work unit's type (Only those which design exceptional activity) that a user can enter on timesheets, cf. TAB_TYPEHEURE.TYPEH_REF.

Each reference is separated by | character.


Default: ''

Example:

10|11

USER_THEME

Enum('light', 'dark', 'system')

Theme selected by user


Default: 'system'

USER_TIMEZONE

Varchar(250)

Timezone.

cf. https://www.iana.org/time-zones


Default: 'Europe/Paris'

USER_TPSFRSETAT

Tinyint(1)

Enable/disable the automatic creation and the email's sending of timesheets & expenses :

  • 3 : Enable only for timesheets
  • 2 : Enable only for expenses
  • 1 : Enable for both
  • 0 : Disable for both


Default: 1

USER_TPSFRSSTART

Date

Starting date of timesheets & expenses entering.

This property can be null.

if USER_TPSFRSSTART is :

  • null : Hiring date, cf. TAB_CONTRAT
  • 3000-01-01 : Inactive
  • YYYY-MM-01 : From the year & month indicated, 1970 <= YYYY <= 2038 and 1 <= MM <= 12

USER_TYPE

Tinyint(1)

Type :

  • 0 : Visitor
  • 2 : Manager
  • 4 : Administrator
  • 6 : Resource


Default: 0

USER_VALIDATIONABSENCES

Varchar(250)

Requests of absences validation circuit.

This property can be null, accordingly the default's validation circuit will be the one of user's agency TAB_GROUPECONFIG.GRPCONF_VALIDATIONABSENCES.

If USER_VALIDATIONABSENCES<>null then it is a list of validator separated by | character.

A validator's value is :

  • integer : TAB_USER.ID_USER, obligatorily the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: null

Example:

"0|-1|100"

USER_VALIDATIONFRAIS

Varchar(250)

Expenses validation circuit.

This property can be null, accordingly the default's validation circuit will be the one of user's agency TAB_GROUPECONFIG.GRPCONF_VALIDATIONFRAIS.

If USER_VALIDATIONFRAIS<>null then it is a list of validator separated by | character.

A validator's value is :

  • integer : TAB_USER.ID_USER, obligatorily the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: null

Example:

"0|-1|100"

USER_VALIDATIONTEMPS

Varchar(250)

Timesheets validation circuit.

This property can be null, accordingly the default's validation circuit will be the one of user's agency TAB_GROUPECONFIG.property_GRPCONF_VALIDATIONTEMPS.

If USER_VALIDATIONTEMPS<>null then it is a list of validator separated by | character.

A validator value can be :

  • integer : TAB_USER.ID_USER, obligatorily the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: null

Example:

"0|-1|100"