[Vtigercrm-developers] Multiple user assignment

Joe Bordes joe at tsolucio.com
Tue Dec 4 12:29:41 PST 2012


Well, we have to keep saving the banks and giving money to the people 
who don't know where to put it anymore. We have nothing better to do 
with the money ;-)

That said, the thing is more a question of time. I have a bunch of 
people waiting on me already, so dedicating 10-20min to remember what 
project(s) we did this on then undig it from svn (thank goodness for 
subversion, thank you!!) and answer the email is a luxury. I try my best 
to answer questions, but generally can only get at those that I can 
answer very quickly.

As I remembered the additional change was on the delete action which 
needs some code modifications, although I see that we created a specific 
method for the list which I didn't remember.

Hope that helps.

Note: support to keep the banks happy is welcome  :-)


Let us know how it goes.

Regards
Joe
TSolucio



On 04/12/12 20:34, Richard Hills wrote:
> Hi Joe,
>
> I also considered using the _crmentityrel table however am still having
> issues with my custom timesheets loading from this table despite
> covering indexes (the list query is taking like 30 minutes). I realise
> that my own queries won't suffer from this lag however was thinking it
> might be safer to avoid it all together. The fact you also did it that
> way changes my mind however and I guess we will do it the same way
> (saves all those custom fields for users).
>
> Thanks for your input. If you want to share what script you adjusted
> then feel free, though I am aware you most likely will use this as a
> commercial product :)
>
> On 04/12/12 22:15, Joe Bordes wrote:
>> We have done this in the past a few times for very specific situations.
>> What we do is create a vtlib related list that saves the users in
>> _crmentityrel. You have to modify some code (don't remember exactly
>> what), but it is very little.
>> This way you avoid having to create new uitypes and the like.
>> Obviously you still have to modify the privileges system.
>>
>> In case that helps
>>
>> On 03/12/12 23:14, Richard Hills wrote:
>>> Hi guys,
>>>
>>> I have been looking at extending our vtiger installations to allow
>>> multiple users to be assigned a single entity. Currently I am looking at
>>> doing the following to achieve this:
>>>
>>> 1 - add a new uitype 52 field (or more than one) to the modules I wish
>>> to use.
>>> 2 - adjust the getNonAdminAccessControlQuery to return a where clause
>>> instead of an inner join.
>>> 3 - adjust the modules where getNonAdminAccessControlQuery is used to
>>> place the query change properly.
>>> 4 - further tweak the query to include a where for each of the
>>> "smownerid" custom fields for this module as well as the smownerid field.
>>>
>>> If anyone can tell me something which obviously won't work, or can
>>> suggest a better solution I would be open to hearing about it.
>>>
>>> Groups will not work as we would end up with a group for every entity
>>> and the administration of these groups would be more work than simply
>>> assigning the entity to 2-3 users.
>>>
>>> Thank you
>>>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: account_user_rel.diff
Type: text/x-patch
Size: 5527 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20121204/c768ea1a/attachment.bin 


More information about the vtigercrm-developers mailing list