User defined Module

[brahm.pragya]

Can I create one module for company?
I have requirement that there can be some master table for company
And in manually add user there is one company drop down and I can add selected company's id or name in user table.
If anyone have some solution for this then please reply

Thank u in advance

[Brandin]

You can just create a table called companies, and then create a column in the users table called company_id which is the ID of the company from the companies table. You would then use the DB class to call this on both the manual add form and the admin_user.php setup. Here is a video on interacting with the DB:

https://www.youtube.com/watch?v=rb0kD5tCENM&t=1479s

[brahm.pragya]

Can I use the company column in user table?
If I use the company column then it affect the system login/registration process?
As I have taken the drop down of company in manually add user popup

[Brandin]

You're welcome to, yes. I don't believe it is currently used for anything (I could be wrong-so test this before being solid on using it). I was just thinking for ease of modification using the DB-but it is definitely up to you.

[brahm.pragya]

Yes It works fine.
Thank You