[naapak]

Hello we need to enter the companies employee number in the user registration form. So is it possible to create custom USR_ID for the users? If so where is the user form being called in the code to alter it? and how do I set it in the MySql?

This way we can use the employee number in the dynaforms. Any help here will be appreciated.

[amosbatto]

I don't have time to test this, but the basic steps would be:
1. Edit the file processmaker/gulliver/bin/tasks/templates/schema.xml.tpl. In <table name="USERS">, add extra columns to the USERS table.

2. Then, edit workflow/engine/classes/model/om/BaseUsersPeer.php and add your fields.

3. Then, enter these commands in the terminal of your PM server:
su or sudo su -
cd /opt/processmaker
php processmaker database-upgrade

This will add extra fields to the USERS table in the database.

4. Then, edit workflow/engine/templates/users/users.js and add your fields.

5. If you need any special processing when the user form is submitted, then also edit workflow/engine/methods/users/usersAjax.php and add code to the section under:
case 'userData':

I might be forgetting something, but start there and let me know if it works.

[naapak]

Thank you Amosbatto. This will be a great first steps for me to start. I will let you know how it goes.

I don't have time to test this, but the basic steps would be:
1. Edit the file processmaker/gulliver/bin/tasks/templates/schema.xml.tpl. In <table name="USERS">, add extra columns to the USERS table.

2. Then, edit workflow/engine/classes/model/om/BaseUsersPeer.php and add your fields.

3. Then, enter these commands in the terminal of your PM server:
su or sudo su -
cd /opt/processmaker
php processmaker database-upgrade

This will add extra fields to the USERS table in the database.

4. Then, edit workflow/engine/templates/users/users.js and add your fields.

5. If you need any special processing when the user form is submitted, then also edit workflow/engine/methods/users/usersAjax.php and add code to the section under:
case 'userData':

I might be forgetting something, but start there and let me know if it works.

[naapak]

Hello Amosbatto,

I tried this your way but I Coudnt go past the field after creating it in the users.js. Thinking where I was wrong and All I wanted was to enter the employee number to the field. Since we already have to access of USR_ID from the database in

Code: Select all

var data = Ext.util.JSON.decode(r.responseText);
            usertmp = data.user;

in workflow/engine/templates/users/users.js and that I need to alter this number. So here is all that I changed in the users.js file to get the results.

Code: Select all

{
          id         : 'USR_ID',
          fieldLabel : '<span style=\"color:red;\" ext:qtip="'+ _('ID_FIELD_REQUIRED', _('Employee #')) +'"> * </span>' + _('Employee #'),
          xtype      : 'textfield',
          width      : 260,
          allowBlank : false
        },

in the var informationFields

Code: Select all

Ext.getCmp("frmDetails").getForm().setValues({
                USR_FIRSTNAME: data.user.USR_FIRSTNAME,
                USR_LASTNAME: data.user.USR_LASTNAME,
                USR_USERNAME: data.user.USR_USERNAME,
                USR_EMAIL: data.user.USR_EMAIL,
                USR_ADDRESS: data.user.USR_ADDRESS,
                USR_ZIP_CODE: data.user.USR_ZIP_CODE,
                USR_ID:data.user.USR_ID,
                USR_PHONE: data.user.USR_PHONE,
                USR_POSITION: data.user.USR_POSITION,
                USR_DUE_DATE: data.user.USR_DUE_DATE,
                USR_STATUS: data.user.USR_STATUS,
                /*----------------------------------********---------------------------------*/
                USR_LOGGED_NEXT_TIME: data.user.USR_LOGGED_NEXT_TIME
            });

in the loadUserData function

Code: Select all

Ext.getCmp("USR_ID2").setText(data.user.USR_ID);

in if (infoMode) in the loadUserData function.

End result is we have a new field Employee # in the user form. Where we can see the USR_ID and change this number. The only issue I see is that when we try to save new user with an existing USR_ID number, it does not save as there is error but the client does not see it.

Please let me know if you think there is a major issues you find with this method. Thank you so much for your help.

[amosbatto]

You will have to reapply these changes after every upgrade, but otherwise it looks fine to me.