Location: PHPKode > projects > PhpCollab > phpCollab/calendar/viewcalendar.php
<?php
/*
** Application name: phpCollab
** Last Edit page: 04/12/2004
** Path by root: ../calendar/viewcalendar.php
** Authors: Ceam / Fullo
** =============================================================================
**
**               phpCollab - Project Managment
**
** -----------------------------------------------------------------------------
** Please refer to license, copyright, and credits in README.TXT
**
** -----------------------------------------------------------------------------
** FILE: viewcalendar.php
**
** DESC: screen: view main calendar page
**
** HISTORY:
**  2003-10-23  -   added new document info
**  15/09/2004  -   added broadcast support and subtask view
**  10/11/2004  -   fixed http://www.php-collab.org/community/viewtopic.php?t=1697
**  04/12/2004  -   fixed [ 1077236 ] Calendar bug in Client's Project site
**  21/04/2005  -   added css to calendar events
**  25/04/2006  -   replaced JavaScript Calendar functions with new DHTML calendar files.
** -----------------------------------------------------------------------------
** TO-DO:
**  add the iCal format import
**  add vCalendar format import
**  add more view (weekly, daily)
**  check for better calendar engine (PHPiCal ?)
** =============================================================================
*/


$checkSession = "true";
include_once('../includes/library.php');

if ($type == "")
{
    $type = "monthPreview";
}

function _dayOfWeek($timestamp)
{
    return intval(strftime("%w",$timestamp)+1);
}

if ($gmtTimezone != "false")
{
    $zone = 3600 * $_SESSION['timezoneSession'];
    $year = gmdate("Y", time() + $zone);
    $month = gmdate("n", time() + $zone);
    $day = gmdate("j", time() + $zone);
} else {
    $year = date("Y");
    $month = date("n");
    $day = date("j");
}

if (strlen($month) == 1)
{
    $month = "0$month";
}
if (strlen($day) == 1)
{
    $day= "0$day";
}

$dateToday = "$year-$month-$day";

if ($dateCalend != "")
{
    $year = substr("$dateCalend", 0, 4);
    $month = substr("$dateCalend", 5, 2);
    $day = substr("$dateCalend", 8, 2);
}

if ($dateCalend == "")
{
    
    if ($gmtTimezone != "false")
    {
      $zone = 3600 * $_SESSION['timezoneSession'];
      $year = gmdate("Y", time() + $zone);
      $month = gmdate("n", time() + $zone);
      $day = gmdate("d", time() + $zone);
    } else {
      $year = date("Y");
      $month = date("n");
      $day = date("d");
    }

    if (strlen($day) == 1)
    {
        $day = "0$day";
    }

    if (strlen($month) == 1)
    {
        $month = "0$month";
    }

    $dateCalend = "$year-$month-$day";
}

$yearDay = date("Y");
$monthDay = date("n");
$dayDay = date("d");

$dayName = date("w",mktime(0,0,0,$month,$day,$year));
$monthName = date("n",mktime(0,0,0,$month,$day,$year));
$dayName = $dayNameArray[$dayName];
$monthName = $monthNameArray[$monthName];

$daysmonth = date("t",mktime(0,0,0,$month,$day,$year));
$firstday = date("w",mktime(0,0,0,$month,1,$year));
$padmonth = date("m",mktime(0,0,0,$month,$day,$year));
$padday = date("d",mktime(0,0,0,$month,$day,$year));

if ($firstday == 0)
{
    $firstday = 7;
}

echo "<!-- DAB - Type: $type";

if ($type == "calendEdit") {
    if ($action == "update")
    {
        if ($recurring == "")
        {
            $recurring = "0";
        }
        else
        {
            $dateStart_A = substr("$dateStart", 0, 4);
            $dateStart_M = substr("$dateStart", 5, 2);
            $dateStart_J = substr("$dateStart", 8, 2);
            $dayRecurr = _dayOfWeek(mktime(12,12,12,$dateStart_M,$dateStart_J,$dateStart_A));
        }
        $subject = convertData($subject);
        $description = convertData($description);
        $tmpquery = "UPDATE ".$tableCollab["calendar"]." SET subject='$subject',description='$description',location='$location',shortname='$shortname',date_start='$dateStart',date_end='$dateEnd',time_start='$time_start',time_end='$time_end',reminder='$reminder',recurring='$recurring',recur_day='$dayRecurr',broadcast='$broadcast' WHERE id = '$dateEnreg'";
        connectSql("$tmpquery");
        headerFunction("../calendar/viewcalendar.php?dateEnreg=$dateEnreg&dateCalend=$dateCalend&type=calendDetail&msg=update&".session_name()."=".session_id());
    }

    if ($action == "add")
    {
        if($shortname == "")
        {
            $error = $strings["blank_fields"];
        }
        else
        {
            if ($recurring == "")
            {
                $recurring = "0";
            }
            else
            {
                $dateStart_A = substr("$dateStart", 0, 4);
                $dateStart_M = substr("$dateStart", 5, 2);
                $dateStart_J = substr("$dateStart", 8, 2);
                $dayRecurr = _dayOfWeek(mktime(12,12,12,$dateStart_M,$dateStart_J,$dateStart_A));
            }

            $subject = convertData($subject);
            $description = convertData($description);
            $shortname = convertData($shortname);
            $tmpquery = "INSERT INTO ".$tableCollab["calendar"]."(owner,subject,description,location,shortname,date_start,date_end,time_start,time_end,reminder,broadcast,recurring,recur_day) VALUES('$idSession','$subject','$description','$location','$shortname','$dateStart','$dateEnd','$time_start','$time_end','$reminder','$broadcast','$recurring','$dayRecurr')";
            connectSql("$tmpquery");
            $tmpquery = $tableCollab["calendar"];
            last_id($tmpquery);
            $num = $lastId[0];
            unset($lastId);
            headerFunction("../calendar/viewcalendar.php?dateEnreg=$num&dateCalend=$dateCalend&type=calendDetail&msg=add&".session_name()."=".session_id());
        }
    }
}

if ($type == "calendEdit")
{
    if ($dateEnreg == "" && $id != "")
    {
        $dateEnreg = $id;
    }

    if ($id != "")
    {
        $tmpquery = "WHERE cal.owner = '$idSession' AND cal.id = '$dateEnreg'";
        $detailCalendar = new request();
        $detailCalendar->openCalendar($tmpquery);
        $comptDetailCalendar = count($detailCalendar->cal_id);

        if ($comptDetailCalendar == "0")
        {
            headerFunction("../calendar/viewcalendar.php?".session_name()."=".session_id());
        }
    }
}

if ($type == "calendDetail")
{
    if ($dateEnreg == "" && $id != "")
    {
        $dateEnreg = $id;
    }

    $tmpquery = "WHERE (cal.owner = '$idSession' AND cal.id = '$dateEnreg') OR (cal.broadcast = '1' AND cal.id = '$dateEnreg')";  //changed to $idSession
    $detailCalendar = new request();
    $detailCalendar->openCalendar($tmpquery);
    $comptDetailCalendar = count($detailCalendar->cal_id);

    if ($comptDetailCalendar == "0")
    {
        headerFunction("../calendar/viewcalendar.php?".session_name()."=".session_id());
    }
}

if ($type == "calendEdit")
{
    $bodyCommand = "onLoad=\"document.calendForm.shortname.focus();\"";
}

/** Do the title calcs here.. we __HAVE__ to do it before the include **/
switch ($type) {
    case 'monthPreview':
        $setTitle .= " : View Calendar ($monthName $year)";
        break;
    case 'dayList':
        $setTitle .= " : View Calendar ($dateCalend)";
        break;
    case 'calendEdit':
        if ($id == "") 
            $setTitle .= " : Add Calendar Entry ($dateCalend)";
        if ($id != "") 
            $setTitle .= " : Edit Calendar Entry ($dateCalend - " . $detailCalendar->cal_shortname[0] . ")";
        break;
    case 'calendDetail':
        $setTitle .= " : Calendar Entry (" . $detailCalendar->cal_shortname[0] . ")";
        break;
}
$includeCalendar = true; //Include Javascript files for the pop-up calendar 
include('../themes/'.THEME.'/header.php');

if ($type == "calendEdit")
{
    if ($id != "")
    {
        $subject = $detailCalendar->cal_subject[0];
        $description = $detailCalendar->cal_description[0];
        $location = $detailCalendar->cal_location[0];
        $shortname = $detailCalendar->cal_shortname[0];
        $date_start = $detailCalendar->cal_date_start[0];
        $date_end = $detailCalendar->cal_date_end[0];
        $time_start = $detailCalendar->cal_time_start[0];
        $time_end = $detailCalendar->cal_time_end[0];
        $reminder = $detailCalendar->cal_reminder[0];
        $broadcast = $detailCalendar->cal_broadcast[0];
        $recurring = $detailCalendar->cal_recurring[0];

        if ($reminder == "0")
        {
            $checked1_b = "checked"; //false
        } else {
            $checked2_b = "checked"; //true
        }

        if ($broadcast == "0")
        {
            $checked3_b = "checked"; //false
        }
        else
        {
            $checked4_b = "checked"; //true
        }
        if ($recurring == "1")
        {
            $checked2_a = "checked"; //true
        }
    }
    else
    {
        $checked2_b = "checked"; //true
        $checked3_b = "checked";
        $checked2_a = "";
    }

    $blockPage = new block();
    $blockPage->openBreadcrumbs();
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview",$strings["calendar"],in));
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview&dateCalend=$dateCalend","$monthName $year",in));
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=dayList&dateCalend=$dateCalend","$dayName $day $monthName $year",in));

    if ($id != "")
    {
        $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=calendDetail&dateCalend=$dateCalend&dateEnreg=$dateEnreg",$detailCalendar->cal_shortname[0],in));
        $blockPage->itemBreadcrumbs($strings["edit"]);
    }
    else
    {
        $blockPage->itemBreadcrumbs($strings["add"]);
    }
    $blockPage->closeBreadcrumbs();

    if ($msg != "")
    {
        include('../includes/messages.php');
        $blockPage->messagebox($msgLabel);
    }

    $block1 = new block();

    $block1->form = "calend";

    if ($id != "")
    {
        $block1->openForm("../calendar/viewcalendar.php?".session_name()."=".session_id()."&dateEnreg=$dateEnreg&dateCalend=$dateCalend&type=$type&action=update#".$block1->form."Anchor");
    }
    else
    {
        $block1->openForm("../calendar/viewcalendar.php?".session_name()."=".session_id()."&dateEnreg=$dateEnreg&dateCalend=$dateCalend&type=$type&action=add#".$block1->form."Anchor");
    }

    if ($error != "")
    {
        $block1->headingError($strings["errors"]);
        $block1->contentError($error);
    }

    if ($id != "")
    {
        $block1->heading($strings["edit"].": ".$detailCalendar->cal_shortname[0]);
    }
    else
    {
        $block1->heading($strings["add"].":");
    }

    $block1->openContent();
    $block1->contentTitle($strings["details"]);

    echo "
        <tr class='odd'>
            <td valign='top' class='leftvalue'>* ".$strings["shortname"].$block1->printHelp("calendar_shortname")." :</td>
            <td><input size='24' style='width: 250px;' maxlength='128' type='text' name='shortname' value='$shortname'></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["subject"]." :</td>
            <td><input size='24' style='width: 250px;' maxlength='128' type='text' name='subject' value='$subject'></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["description"]." :</td>
            <td><textarea style='width: 400px; height: 50px;' name='description' cols='35' rows='2'>$description</textarea></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["location"]." :</td>
            <td><input size='24' style='width: 250px;' maxlength='128' type='text' name='location' value='$location'></td>
        </tr>";

    if ($date_start == "")
    {
        $date_start = $dateCalend;
    }
    if ($date_end == "")
    {
        $date_end = $dateCalend;
    }

    $block1->contentRow($strings["date_start"],"<input type='text' name='dateStart' id='dateStart' size='20' value='$date_start'><input type='button' value=' ... ' id=\"trigDateStart\">");
	echo "
	<script type='text/javascript'>
	    Calendar.setup({
        	inputField     :    'dateStart',
        	button         :    'trigDateStart',
        	$calendar_common_settings
	    });
	</script>
	";
    $block1->contentRow($strings["date_end"],"<input type='text' name='dateEnd' id='dateEnd' size='20' value='$date_end'><input type='button' value=' ... ' id=\"trigDateEnd\">");
	echo "
	<script type='text/javascript'>
	    Calendar.setup({
        	inputField     :    'dateEnd',
	        button         :    'trigDateEnd',
        	$calendar_common_settings
    	});
	</script>
	";
    echo "      </td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["time_start"]." :</td>
            <td><input size='24' style='width: 250px;' maxlength='128' type='text' name='time_start' value='$time_start'></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["time_end"]." :</td>
            <td><input size='24' style='width: 250px;' maxlength='128' type='text' name='time_end' value='$time_end'></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["calendar_reminder"]." :</td>
            <td><input type='radio' name='reminder' value='0' $checked1_b> ".$strings["no"]."&nbsp;<input type='radio' name='reminder' value='1' $checked2_b> ".$strings["yes"]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["calendar_broadcast"]." :</td>
            <td><input type='radio' name='broadcast' value='0' $checked3_b> ".$strings["no"]."&nbsp;<input type='radio' name='broadcast' value='1' $checked4_b> ".$strings["yes"]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["calendar_recurring"]." :</td>
            <td><input type='checkbox' name='recurring' value='1' $checked2_a></td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>&nbsp;</td>
            <td><input type='SUBMIT' value='".$strings["save"]."'></td>
        </tr>";

    $block1->closeContent();
    $block1->closeForm();
}

if ($type == "calendDetail")
{
    $reminder = $detailCalendar->cal_reminder[0];
    $broadcast = $detailCalendar->cal_broadcast[0];
    $recurring = $detailCalendar->cal_recurring[0];

    if ($reminder == "0")
    {
        $reminder = $strings["no"];
    } else {
        $reminder = $strings["yes"];
    }

    if ($broadcast == "0")
    {
        $broadcast = $strings["no"];
    } else {
        $broadcast = $strings["yes"];
    }

    if ($recurring == "0")
    {
        $recurring = $strings["no"];
    } else {
        $recurring = $strings["yes"];
    }

    $blockPage = new block();
    $blockPage->openBreadcrumbs();
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview",$strings["calendar"],in));
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview&dateCalend=$dateCalend","$monthName $year",in));
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=dayList&dateCalend=$dateCalend","$dayName $day $monthName $year",in));
    $blockPage->itemBreadcrumbs($detailCalendar->cal_shortname[0]);
    $blockPage->closeBreadcrumbs();

    if ($msg != "")
    {
        include('../includes/messages.php');
        $blockPage->messagebox($msgLabel);
    }

    $block1 = new block();

    $block1->form = "calend";
    $block1->openForm("../calendar/viewcalendar.php?".session_name()."=".session_id()."#".$block1->form."Anchor");

    if ($error != "")
    {
        $block1->headingError($strings["errors"]);
        $block1->contentError($error);
    }

    $block1->heading($detailCalendar->cal_shortname[0]);

    $block1->openPaletteIcon();

    //not sure about this...
    if ($detailCalendar->cal_owner[0] == $idSession)
    {
        $block1->paletteIcon(0,"remove",$strings["delete"]);
        $block1->paletteIcon(1,"edit",$strings["edit"]);
    }
    $block1->paletteIcon(2,"export",$strings["export"]);
    $block1->closePaletteIcon();

    $block1->openContent();
    $block1->contentTitle($strings["details"]);


    echo "
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["subject"]." :</td>
            <td>".$detailCalendar->cal_subject[0]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["description"]." :</td>
            <td>".nl2br($detailCalendar->cal_description[0])."&nbsp;</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["shortname"].$block1->printHelp("calendar_shortname")." :</td>
            <td>".$detailCalendar->cal_shortname[0]."&nbsp;</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["location"]." :</td>
            <td>".$detailCalendar->cal_location[0]."&nbsp;</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["date_start"]." :</td>
            <td>".$detailCalendar->cal_date_start[0]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["date_end"]." :</td>
            <td>".$detailCalendar->cal_date_end[0]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["time_start"]." :</td>
            <td>".$detailCalendar->cal_time_start[0]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["time_end"]." :</td>
            <td>".$detailCalendar->cal_time_end[0]."</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["calendar_reminder"]." :</td>
            <td>$reminder</td>
        </tr>
        <tr class='odd'>
            <td valign='top' class='leftvalue'>".$strings["calendar_broadcast"]." :</td>
            <td>$broadcast</td>
        </tr>
        <tr class='odd'
        ><td valign='top' class='leftvalue'>".$strings["calendar_recurring"]." :</td>
            <td>$recurring</td>
        </tr>";

    $block1->closeContent();
    $block1->closeForm();

    $block1->openPaletteScript();
    if ($detailCalendar->cal_owner[0] == $idSession)
    {
        $block1->paletteScript(0,"remove","../calendar/deletecalendar.php?id=$dateEnreg","true,true,true",$strings["delete"]);
        $block1->paletteScript(1,"edit","../calendar/viewcalendar.php?id=$dateEnreg&type=calendEdit&dateCalend=$dateCalend","true,true,true",$strings["edit"]);
    }

    $block1->paletteScript(2,"export","../calendar/exportcalendar.php?id=$dateEnreg","true,true,true",$strings["export"]);
    $block1->closePaletteScript("","");
}

$blockPage = new block();

if ($type == "dayList")
{
    $blockPage->openBreadcrumbs();
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview",$strings["calendar"],in));
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?type=monthPreview&dateCalend=$dateCalend","$monthName $year",in));
    $blockPage->itemBreadcrumbs("$dayName $day $monthName $year");
    $blockPage->closeBreadcrumbs();

    $block1 = new block();

    $block1->form = "calendList";
    $block1->openForm("../calendar/viewcalendar.php?type=$type&dateCalend=$dateCalend&".session_name()."=".session_id()."#".$block1->form."Anchor");

    $block1->heading("$dayName $day $monthName $year");

    $block1->openPaletteIcon();

    $block1->paletteIcon(0,"add",$strings["add"]);
    $block1->paletteIcon(1,"remove",$strings["delete"]);
    $block1->paletteIcon(2,"info",$strings["view"]);
    $block1->paletteIcon(3,"edit",$strings["edit"]);

    $block1->closePaletteIcon();

    $block1->sorting("calendar",$sortingUser->sor_calendar[0],"cal.date_end DESC",$sortingFields = array(0=>"cal.shortname",1=>"cal.subject",2=>"cal.date_start",3=>"cal.date_end"));

    $dayRecurr = _dayOfWeek(mktime(12,12,12,$month,$day,$year));
    $tmpquery = "WHERE (cal.owner = '$idSession' AND ((cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' AND cal.recurring = '0') OR ((cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend') AND cal.recurring = '1' AND cal.recur_day = '$dayRecurr'))) OR (cal.broadcast = '1' AND ((cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' AND cal.recurring = '0') OR ((cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend') AND cal.recurring = '1' AND cal.recur_day = '$dayRecurr'))) ORDER BY cal.shortname";  //changed
    //$tmpquery = "WHERE cal.owner = '$calId' AND cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' ORDER BY $block1->sortingValue";
    $listCalendar = new request();
    $listCalendar->openCalendar($tmpquery);
    $comptListCalendar = count($listCalendar->cal_id);

    if ($comptListCalendar != "0")
    {
        $block1->openResults();

        $block1->labels($labels = array(0=>$strings["shortname"],1=>$strings["subject"],2=>$strings["date_start"],3=>$strings["date_end"]),"false");

        for ($i=0;$i<$comptListCalendar;$i++)
        {
            $block1->openRow();
            $block1->checkboxRow($listCalendar->cal_id[$i]);
            $block1->cellRow($blockPage->buildLink("../calendar/viewcalendar.php?$dateEnreg=".$listCalendar->cal_id[$i]."&type=calendDetail&dateCalend=$dateCalend",$listCalendar->cal_shortname[$i],in));
            $block1->cellRow($listCalendar->cal_subject[$i]);
            $block1->cellRow($listCalendar->cal_date_start[$i]);
            $block1->cellRow($listCalendar->cal_date_end[$i]);
            $block1->closeRow();
        }

        $block1->closeResults();
    }
    else
    {
        $block1->noresults();
    }

    $block1->closeFormResults();

    $block1->openPaletteScript();
    $block1->paletteScript(0,"add","../calendar/viewcalendar.php?dateCalend=$dateCalend&type=calendEdit","true,false,false",$strings["add"]);
    $block1->paletteScript(1,"remove","../calendar/deletecalendar.php?","false,true,true",$strings["delete"]);
    $block1->paletteScript(2,"info","../calendar/viewcalendar.php?dateCalend=$dateCalend&type=calendDetail","false,true,false",$strings["view"]);
    $block1->paletteScript(3,"edit","../calendar/viewcalendar.php?dateCalend=$dateCalend&type=calendEdit","false,true,false",$strings["edit"]);
    $block1->closePaletteScript($comptListCalendar,$listCalendar->cal_id);
}

if ($type == "monthPreview")
{
    $blockPage->openBreadcrumbs();
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../calendar/viewcalendar.php?",$strings["calendar"],in));
    $blockPage->itemBreadcrumbs("$monthName $year");
    $blockPage->closeBreadcrumbs();

    // include('memlist.php');

    $block2 = new block();

    $block2->heading("$monthName $year");

    echo "<table border='0' cellpadding='0' cellspacing='2' width='100%' class='listing'><tr>";
    for($daynumber = 1; $daynumber < 8; $daynumber++)
    {
        echo "<td width='14%' class='calendDays'>&nbsp;$dayNameArray[$daynumber]</td>";
    }
    echo "</tr>";

    //  Print the calendar
    echo "<tr>";

    $tmpquery = "WHERE tas.assigned_to = '$idSession' ORDER BY tas.name";
    $listTasks = new request();
    $listTasks->openTasks($tmpquery);
    $comptListTasks = count($listTasks->tas_id);

    $tmpquery = "WHERE subtas.assigned_to = '$idSession' ORDER BY subtas.name"; //Leave as calId
    $listSubtasks = new request();
    $listSubtasks->openSubtasks($tmpquery);
    $comptListSubtasks = count($listSubtasks->subtas_id);
    $comptListCalendarScan = "0";
    for ($g=0;$g<$comptListTasks;$g++)
    {
        if (substr($listTasks->tas_start_date[$g],0,7) == substr($dateCalend,0,7))
        {
            $gantt = "true";
        }
    }

    //hack to check the td
    $weekremain = ($daysmonth -(7-($firstday - 1)));
    $daysremain = ($weekremain -(floor($weekremain / 7))*7);
    $colsremain = ((7-$daysremain));

    for ($i = 1; $i < $daysmonth + $firstday; $i++)
    {

        $a = $i - $firstday + 1;
        $day = $i - $firstday + 1;

        if (strlen($a) == 1)
        {
            $a = "0$a";
        }

        if (strlen($month) == 1)
        {
            $month = "0$month";
        }

        $dateLink = "$year-$month-$a";
        $todayClass = "";
        $dayRecurr = _dayOfWeek(mktime(12,12,12,$month,$a,$year));

        $tmpquery = "WHERE (cal.owner = '$idSession' AND ((cal.date_start <= '$dateLink' AND cal.date_end >= '$dateLink' AND cal.recurring = '0') OR ((cal.date_start <= '$dateLink' AND cal.date_end <= '$dateLink') AND cal.recurring = '1' AND cal.recur_day = '$dayRecurr'))) OR (cal.broadcast = '1' AND ((cal.date_start <= '$dateLink' AND cal.date_end >= '$dateLink' AND cal.recurring = '0') OR ((cal.date_start <= '$dateLink' AND cal.date_end <= '$dateLink') AND cal.recurring = '1' AND cal.recur_day = '$dayRecurr'))) ORDER BY cal.shortname";
        $listCalendarScan = new request();
        $listCalendarScan->openCalendar($tmpquery);
        $comptListCalendarScan = count($listCalendarScan->cal_id);

        if (($i < $firstday) || ($a == "00"))
        {
            echo "<td width='14%' class='even'>&nbsp;</td>";
        }
        else
        {
            if ($dateLink == $dateToday)
            {
                $classCell = "old";
            }
            else
            {
                $classCell = "odd";
            }

        echo "<td width='14%' align='left' valign='top' class='$classCell' onmouseover=\"this.style.backgroundColor='".$block2->highlightOn."'\" onmouseout=\"this.style.backgroundColor='".$highlightOff."'\"><div align='right'>".$blockPage->buildLink("../calendar/viewcalendar.php?dateCalend=$dateLink&type=dayList",$day,in)."</div>";

        if ($comptListCalendarScan != "0")
        {
            for ($h=0;$h<$comptListCalendarScan;$h++)
            {
                // echo $blockPage->buildLink("../calendar/viewcalendar.php?dateEnreg=".$listCalendarScan->cal_id[$h]."&type=calendDetail&dateCalend=$dateLink",$listCalendarScan->cal_shortname[$h],in)."<br/>";
                if ($listCalendarScan->cal_broadcast[$h] == "0" && $listCalendarScan->cal_owner[$h] == $idSession)
                {
                    echo "<div align='center' class='calendar-regular-event'><a href='../calendar/viewcalendar.php?dateEnreg=".$listCalendarScan->cal_id[$h]."&type=calendDetail&dateCalend=$dateLink' class='calendar-regular-todo-event'>".$listCalendarScan->cal_shortname[$h]."</a></div>";
                }
                else if ($listCalendarScan->cal_broadcast[$h] != "0" && $listCalendarScan->cal_owner[$h] == $idSession)
                {
                    echo "<div align='center' class='calendar-regular-event'><a href='../calendar/viewcalendar.php?dateEnreg=".$listCalendarScan->cal_id[$h]."&type=calendDetail&dateCalend=$dateLink' class='calendar-regular-todo-event'><b>".$listCalendarScan->cal_shortname[$h]."</b></a></div>";
                }
                else
                {
                    echo "<div align='center' class='calendar-broadcast-event'><a href='../calendar/viewcalendar.php?dateEnreg=".$listCalendarScan->cal_id[$h]."&type=calendDetail&dateCalend=$dateLink' class='calendar-broadcast-todo-event'><b>".$listCalendarScan->cal_shortname[$h]."</b></a></div>";
                }
            }
        }

        if ($comptListTasks != "0")
        {
            for ($h=0;$h<$comptListTasks;$h++)
            {
                $idPriority = $listTasks->tas_priority[$h];

                if ($listTasks->tas_status[$h] == "3" || $listTasks->tas_status[$h] == "2")
                {
                    if ($listTasks->tas_start_date[$h] == $dateLink && $listTasks->tas_start_date[$h] != $listTasks->tas_due_date[$h])
                    {
                        echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["task"]."</b>: ";
                        echo "<a href='../tasks/viewtask.php?id=".$listTasks->tas_id[$h]."' class='calendar-results-start-date'>".$listTasks->tas_name[$h]."</a><br /><br />";
                    }

                    if ($listTasks->tas_due_date[$h] == $dateLink && $listTasks->tas_start_date[$h] != $listTasks->tas_due_date[$h])
                    {

                        if ($listTasks->tas_due_date[$h] <= $date && $listTasks->tas_completion[$h] != "10")
                        {
                            echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["task"]."</b>: ";
                            echo "<a href='../tasks/viewtask.php?id=".$listTasks->tas_id[$h]."' class='calendar-results-due-date'><b>".$listTasks->tas_name[$h]."</b></a><br /><br />";
                        }
                        else
                        {
                            echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["task"]."</b>: ";
                            echo "<a href='../tasks/viewtask.php?id=".$listTasks->tas_id[$h]."' class='calendar-results-due-date'>".$listTasks->tas_name[$h]."</a><br /><br />";
                        }
                    }

                    if ($listTasks->tas_start_date[$h] == $dateLink && $listTasks->tas_due_date[$h] == $dateLink)
                    {

                        if ($listTasks->tas_due_date[$h] <= $date && $listTasks->tas_completion[$h] != "10")
                        {
                            echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["task"]."</b>: ";
                            echo "<a href='../tasks/viewtask.php?id=".$listTasks->tas_id[$h]."' class='calendar-results-due-date'><b>".$listTasks->tas_name[$h]."</b></a><br /><br />";
                        }
                        else
                        {
                            echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["task"]."</b>: ";
                            echo "<a href='../tasks/viewtask.php?id=".$listTasks->tas_id[$h]."' class='calendar-results-due-date'>".$listTasks->tas_name[$h]."</a><br /><br />";
                        }
                    }

                }
                else
                {

                    if ($listTasks->tas_start_date[$h] == $dateLink && $listTasks->tas_start_date[$h] != $listTasks->tas_due_date[$h])
                    {
                        echo $blockPage->buildLink("../tasks/viewtask.php?id=".$listTasks->tas_id[$h],$listTasks->tas_name[$h],in)." (".$strings["start_date"].")<br/>";
                    }

                    if ($listTasks->tas_due_date[$h] == $dateLink && $listTasks->tas_start_date[$h] != $listTasks->tas_due_date[$h])
                    {
                        if ($listTasks->tas_due_date[$h] <= $date && $listTasks->tas_completion[$h] != "10")
                        {
                            echo $blockPage->buildLink("../tasks/viewtask.php?id=".$listTasks->tas_id[$h],"<b>".$listTasks->tas_name[$h]."</b>",in)." (".$strings["due_date"].")<br/>";
                        }
                        else
                        {
                            echo $blockPage->buildLink("../tasks/viewtask.php?id=".$listTasks->tas_id[$h],$listTasks->tas_name[$h],in)." (".$strings["due_date"].")<br/>";
                        }
                    }

                    if ($listTasks->tas_start_date[$h] == $dateLink && $listTasks->tas_due_date[$h] == $dateLink)
                    {

                        if ($listTasks->tas_due_date[$h] <= $date && $listTasks->tas_completion[$h] != "10")
                        {
                            echo $blockPage->buildLink("../tasks/viewtask.php?id=".$listTasks->tas_id[$h],"<b>".$listTasks->tas_name[$h]."</b>",in)."<br/>";
                        }
                        else
                        {
                            echo $blockPage->buildLink("../tasks/viewtask.php?id=".$listTasks->tas_id[$h],$listTasks->tas_name[$h],in)."<br/>";

                        }
                    }
                }

            }
        }

        if ($comptListSubtasks != "0")
        {

            for ($h=0;$h<$comptListSubtasks;$h++)
            {
                $idPriority = $listSubtasks->subtas_priority[$h];

                if ($listSubtasks->subtas_status[$h] == "3" || $listSubtasks->subtas_status[$h] == "2")
                {
                    if ($listSubtasks->subtas_start_date[$h] == $dateLink && $listSubtasks->subtas_start_date[$h] != $listSubtasks->subtas_due_date[$h])
                    {
                        echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."' class='calendar-results-start-date'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                    }

                    if ($listSubtasks->subtas_due_date[$h] == $dateLink && $listSubtasks->subtas_start_date[$h] != $listSubtasks->subtas_due_date[$h])
                    {
                        echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";                        if ($listSubtasks->subtas_due_date[$h] <= $date && $listSubtasks->subtas_completion[$h] != "10") {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."' class='calendar-results-due-date'><b>".$listSubtasks->subtas_name[$h]."</b></a><br /><br />";
                    }
                    else
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."' class='calendar-results-due-date'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                    }
                }

                if ($listSubtasks->subtas_start_date[$h] == $dateLink && $listSubtasks->subtas_due_date[$h] == $dateLink)
                {
                    echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";

                    if ($listSubtasks->subtas_due_date[$h] <= $date && $listSubtasks->subtas_completion[$h] != "10")
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."' class='calendar-results-due-date'><b>".$listSubtasks->subtas_name[$h]."</b></a><br /><br />";
                    }
                    else
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."' class='calendar-results-due-date'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                    }
                }
            }
            else
            {
                if ($listSubtasks->subtas_start_date[$h] == $dateLink && $listSubtasks->subtas_start_date[$h] != $listSubtasks->subtas_due_date[$h])
                {
                    echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";
                    echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                }

                if ($listSubtasks->subtas_due_date[$h] == $dateLink && $listSubtasks->subtas_start_date[$h] != $listSubtasks->subtas_due_date[$h])
                {
                    echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";

                    if ($listSubtasks->subtas_due_date[$h] <= $date && $listSubtasks->subtas_completion[$h] != "10")
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."'><b>".$listSubtasks->subtas_name[$h]."</b></a><br /><br />";
                    }
                    else
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                    }
                }

                if ($listSubtasks->subtas_start_date[$h] == $dateLink && $listSubtasks->subtas_due_date[$h] == $dateLink)
                {
                    echo "<img src=\"../themes/".THEME."/gfx_priority/".$idPriority.".gif\" alt='".$strings["priority"].": ".$priority[$idPriority]."' /> <b>".$strings["subtask"]."</b>: ";

                    if ($listSubtasks->subtas_due_date[$h] <= $date && $listSubtasks->subtas_completion[$h] != "10")
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."'><b>".$listSubtasks->subtas_name[$h]."</b></a><br /><br />";
                    }
                    else
                    {
                        echo "<a href='../subtasks/viewsubtask.php?id=".$listSubtasks->subtas_id[$h]."&task=".$listSubtasks->subtas_task[$h]."'>".$listSubtasks->subtas_name[$h]."</a><br /><br />";
                    }
                }
            }
        }
    }

        if ($comptListTasks == "0" ||  $comptListSubtasks == "0" || $comptListCalendarScan == "0")
        {
            echo "<br />";
        }

    echo "</td>";

    }

    if (($i%7) == "0")
    {
        echo "</tr>\n";
    }
}


if ($colsremain != "7"){
    for ($j=0;$j<$colsremain;$j++){
        echo "<td class='even'>&nbsp;</td>\n";
        }
}

echo "</tr></table>";

    if ($month == 1) {
        $pyear = $year - 1;
        $pmonth = 12;
    } else {
        $pyear = $year;
        $pmonth = $month - 1;
    }

    if ($month == 12) {
        $nyear = $year + 1;
        $nmonth = 1;
    } else {
        $nyear = $year;
        $nmonth = $month + 1;
    }

    $year = date("Y");
    $month = date("n");
    $day = date("j");
    if (strlen($month) == 1) {
        $month = "0$month";
    }
    if (strlen($pmonth) == 1) {
        $pmonth = "0$pmonth";
    }
    if (strlen($nmonth) == 1) {
        $nmonth = "0$nmonth";
    }
    if (strlen($day) == 1) {
        $day= "0$day";
    }

    $datePast = "$pyear-$pmonth-01";
    $dateNext = "$nyear-$nmonth-01";

    $dateToday = "$year-$month-$day";
        echo "<table><tr><td class='calend'> </td></tr></table>";

    echo "  <table cellspacing='0' width='100%' border='0' cellpadding='0'>
            <tr>
                <td nowrap align='right' class='footerCell'>".$blockPage->buildLink("../calendar/viewcalendar.php?dateCalend=$datePast",$strings["previous"],in)." | ".$blockPage->buildLink("../calendar/viewcalendar.php?dateCalend=$dateToday",$strings["today"],in)." | ".$blockPage->buildLink("../calendar/viewcalendar.php?dateCalend=$dateNext",$strings["next"],in)."</td>
            </tr>
            <tr>
                <td height='5' colspan='2'><img width='1' height='5' border='0' src='../themes/".THEME."/spacer.gif' alt=''></td>
            </tr>
            </table>";

    if ($activeJpgraph == "true" && $gantt == "true")
    {
		echo "
			<div id='ganttChart_taskList' class='ganttChart'>
				<img src='graphtasks.php?".session_name()."=".session_id()."&dateCalend=$dateCalend' alt=''><br/>
				<span class='listEvenBold''>".$blockPage->buildLink("http://www.aditus.nu/jpgraph/","JpGraph",powered)."</span>	
			</div>
		";
    }
}

include('../themes/'.THEME.'/footer.php');
?>
Return current item: PhpCollab