vtiger

[sumanrs]

Hi,

I've been looking at enhancing custom views using variables. For example, allowing a view called "My Leads" in leads in which the "Assigned To" field can be set to a variable called CURRENTUSER, and anyone who chooses this custom view will see the leads belonging only to him or her.

I notice that this blog post Customizing vTiger custom views with dynamic “variables” - II is what I need.

However, it appears that the Code: $current_user variable sometimes works and sometimes does not. :( Does anyone know why it seems to work sometimes and not at other times?

Thanks,
SRS

[prasad.a]

Hi sumanrs,

$current_user is set in index.php. If it is being used in anyother files, preferably it should be declared first as

Code: global $current_user

Regards,
Prasad
vtiger Team

[sumanrs]

Hi Prasad,

Thanks a lot - I was indeed using that, but that didn't work using the "hack" I was using for the Custom Views.

I found out the reason - the SQL being generated for the username is actually being taken from the function getRealValues() in the same file (/modules/CustomView/CustomView.php), so I made one additional change to get the current user variable to work (changes inbetween comments that say HACK):

Code:
function getRealValues($tablename,$fieldname,$comparator,$value,$datatype)
        {
                if($fieldname == "smownerid" || $fieldname == "inventorymanager")
                {
                        /* HACK - to get current user */
                        global $current_user;
                        if ($value == "CURRENTUSER")
                                $value = $current_user->user_name;
                        /* End HACK */

                        $value = $tablename.".".$fieldname.$this->getAdvComparator($comparator,getUserId_Ol($value),$datatype);
                }else if($fieldname == "parentid")

[prasad.a]

Hi sumanrs,

Thank you for sharing the details.

Would be nice if you can update the author about the same.

Regards,
Prasad
vtiger Team