[Vtigercrm-developers] Multiple user assignment

[Richard Hills]

Thank you Joe, with this script I was indeed able to quickly add the 
user selection system and throughout the day have managed to adjust 
queries as needed to the point where we almost have a working solution 
(at least for accounts, but the replication to other modules would be 
simple).

Unfortunately, the user selection in this manner seems to only work for 
administrators (I guess because only admins have access to the users 
information). Can anyone suggest a solution for me where I will be able 
to use a related list of users and allow all users to adjust it?

Thank you in advance

On 05/12/12 09:29, Joe Bordes wrote:
> 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
>>>>
>>
>
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130110/fb83d367/attachment.html