RE: [Phpgroupware-users] Category sub-Category, again.

[Brian Johnson]

Sorry, I guess my install (0.9.14.005) works the same as yours


Looks like the event selection for display is done in
calendar/inc/class.socalendar.inc.php by the function list_events

                function
list_events($startYear,$startMonth,$startDay,$endYear=0,$endMonth=0,$endDay=0,$owner_id=0)
                {
                        $extra = '';
                        $extra .= (strpos($this->filter,'private')?'AND
phpgw_cal.is_public=0 ':'');
                        $extra .= ($this->cat_id?"AND phpgw_cal.category like
'%".$this->cat_id."%' ":'');

this last line looks like $this->cat_id is the category being checked against 
and
phpgw_cal.category if the db field of the recod being checked

You would have to add a loop to get the children of $this->cat_id (with a SQL 
select
statement) and add their ids to the $extra string (that is being used as a SQL
select statement) with an OR function

OR

you could just pick both the parent and child category when creating/editing the
event (they can be assigned more than one category)



Mike Norton (address@hidden) wrote:
>
>Does your month view show all things in a category and then sub-categories?
>Or does it just show what is in the main category?
>
>The problem I have with this is that lets say I have a category for Church,
>then a sub category of church/sunday_school and church/special_events.
>
>When I look at the overall church category I need to see everything that
>affects the Church category.  If I want to focus in on just special events
>then I can select that subcategory.
>
>I just looked at the code and im lost.  Goes beyond my codeing ability.
>
>Any help would be great.
>
>Mike Norton
>
>-----Original Message-----
>From: address@hidden
>[mailto:address@hidden
>Behalf Of Brian Johnson
>Sent: Thursday, July 24, 2003 11:01 AM
>To: address@hidden
>Subject: Re: [Phpgroupware-users] Category sub-Category, again.
>
>
>What was the problem again?
>
>My monthly view seems to work logically
>
>
>
>
>Mike Norton (address@hidden) wrote:
>>
>>Does anyone have a code hack to make the main category show all sub
>>categories in the calendar?
>>
>>Please im desperate.
>>
>>Mike Norton
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
Brian Johnson
* This is where my witty signature line would be if I bothered to edit this 
line :) *