[Vtigercrm-developers] Calendar - Show Projects

[Alan Bell]

yeah, will be fixed in 6.5 
http://code.vtiger.com/vtiger/vtigercrm/issues/2 glad it helped you!

Alan.

On 11/03/16 22:49, Vladimir Karažija wrote:
> Hi,
>
> I searched vtigercrm-developer list and found solution from Alan Bell.
>
> Thnx Alan ;)
>
> 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);
>
> regards, Vladimir
>
>
> Vladimir Karažija
> Kosa crta d.o.o.
> Jagnedje 1
> 10090 Zagreb
> OIB: 57724075047
>
> t. +385 1 777 33 85
> m. +385 91 122 0511
> www.kosacrta.hr <http://www.kosacrta.hr>
>
> On Fri, Mar 11, 2016 at 11:38 PM, Vladimir Karažija 
> <vladimir at kosacrta.hr <mailto:vladimir at kosacrta.hr>> wrote:
>
>     Hi,
>
>     I am testing Projects module and cannot make vtiger 6.4 to show
>     Projects Activity Types in Calendar.
>
>     I am able to see Project Tasks in All-Day view that are related to
>     Project but cannot see Projects in Calendar.
>
>     I have added Start Date & End Date as instructed on
>     http://www.boruapps.com/vtiger-tip-modules-on-the-vtiger-calendar/
>     but still there is no Projects Activity Type shown in Calendar.
>
>     Anyone with same experience?
>
>     regards, Vladimir
>
>
>     Vladimir Karažija
>     Kosa crta d.o.o.
>     Jagnedje 1
>     10090 Zagreb
>     OIB: 57724075047
>
>     t. +385 1 777 33 85 <tel:%2B385%201%20777%2033%2085>
>     m. +385 91 122 0511 <tel:%2B385%2091%20122%200511>
>     www.kosacrta.hr <http://www.kosacrta.hr>
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160314/a8330985/attachment.html>