[Vtigercrm-developers] projects on the calendar

[Manu urs]

Hi  Alan ,

Thanks  for addressing the issue. Here is a trac
<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8645> link .

Regards,
Manu Urs

On Mon, Oct 19, 2015 at 2:42 PM, Alan Bell <alan.bell at libertus.co.uk> wrote:

> in modules/Calendar/actions/Feed.php in the pullProjects function at line
> 337 there is:
>
>         $params = array_merge($params,$userAndGroupIds);
>
> which then gets used in this query  . . .
>
>                 $query = "SELECT projectname, startdate, targetenddate,
> crmid FROM vtiger_project";
>                 $query.= " INNER JOIN vtiger_crmentity ON
> vtiger_project.projectid = vtiger_crmentity.crmid";
>                 $query.= " WHERE vtiger_crmentity.deleted=0 AND smownerid
> IN (". generateQuestionMarks($userAndGroupIds) .") AND ";
>                 $query.= " ((startdate >= ? AND targetenddate < ?) OR (
> targetenddate >= ?))";
>                 $queryResult = $db->pquery($query, $params);
>
> however, the questionmarks for the users and groups come before the date
> parameters, so it doesn't work and projects don't display on the calendar,
> changing line 337 to put the users and groups first fixes it:
>
>         $params = array_merge($userAndGroupIds,$params);
>
>
> Alan.
> _______________________________________________
> http://www.vtiger.com/
>



-- 
Regards,
Manu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20151019/2c745ee5/attachment.html>