+- UserSpice (https://userspice.com/forums)
+-- Forum: Miscellaneous (https://userspice.com/forums/forumdisplay.php?fid=28)
+--- Forum: Off-topic Discussions (https://userspice.com/forums/forumdisplay.php?fid=10)
+--- Thread: User defined Module (/showthread.php?tid=965)
User defined Module - brahm.pragya - 02-22-2018
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
User defined Module - Brandin - 02-22-2018
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
User defined Module - brahm.pragya - 02-22-2018
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
User defined Module - Brandin - 02-22-2018
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.
User defined Module - brahm.pragya - 02-23-2018
Yes It works fine.
Thank You
