PHP block::sorting方法代码示例

        }
    }
    $query .= ")";
}
//--- header ---
$breadcrumbs[] = buildLink("../reports/createreport.php?", $strings["reports"], LINK_INSIDE);
if ($id != "") {
    $breadcrumbs[] = $reportDetail->rep_name[0];
} else {
    $breadcrumbs[] = $strings["report_results"];
}
$pageSection = 'reports';
require_once "../themes/" . THEME . "/header.php";
//--- content ----
$block1 = new block();
$block1->sorting("report_tasks", $sortingUser->sor_report_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.id", 1 => "tas.name", 2 => "tas.priority", 3 => "tas.status", 4 => "tas.due_date", 5 => "tas.complete_date", 6 => "mem2.login", 7 => "pro.name", 8 => "tas.published"));
if ($projectsFilter == "true") {
    $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
    $tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '" . $_SESSION['idSession'] . "' ORDER BY pro.id";
    $listProjectsTasks = new request();
    $listProjectsTasks->openProjects($tmpquery);
    $comptListProjectsTasks = count($listProjectsTasks->pro_id);
    if ($comptListProjectsTasks != "0") {
        for ($i = 0; $i < $comptListProjectsTasks; $i++) {
            $filterTasks .= $listProjectsTasks->pro_id[$i];
            if ($comptListProjectsTasks - 1 != $i) {
                $filterTasks .= ",";
            }
        }
        if ($query != "") {
            $tmpquery = "{$queryStart} {$query} AND pro.id IN({$filterTasks}) ORDER BY {$block1->sortingValue}";

 $block2->headingToggle($strings["linked_content"]);
 $block2->openPaletteIcon();
 if ($teamMember == "true" || $_SESSION['profilSession'] == "5") {
     $block2->paletteIcon(0, "add", $strings["add"]);
     $block2->paletteIcon(1, "remove", $strings["delete"]);
     if ($sitePublish == "true") {
         $block2->paletteIcon(2, "add_projectsite", $strings["add_project_site"]);
         $block2->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]);
     }
 }
 $block2->paletteIcon(4, "info", $strings["view"]);
 if ($teamMember == "true" || $_SESSION['profilSession'] == "5") {
     $block2->paletteIcon(5, "edit", $strings["edit"]);
 }
 $block2->closePaletteIcon();
 $block2->sorting("meetings_attachment", $sortingUser->sor_meetings_attachment[0], "mat.name ASC", $sortingFields = array(0 => "mat.extension", 1 => "mat.name", 2 => "mat.date", 3 => "mat.status", 4 => "mat.published"));
 $tmpquery = "WHERE mat.meeting = '{$id}' AND mat.vc_parent = '0' ORDER BY {$block2->sortingValue}";
 $listAttachments = new request();
 $listAttachments->openMeetingsAttachment($tmpquery);
 $comptListFiles = count($listAttachments->mat_id);
 if ($comptListFiles != "0") {
     $block2->openResults();
     $block2->labels($labels = array(0 => $strings["type"], 1 => $strings["name"], 2 => $strings["date"], 3 => $strings["approval_tracking"], 4 => $strings["published"]), "true");
     require_once "../includes/files_types.php";
     for ($i = 0; $i < $comptListFiles; $i++) {
         $existFile = "false";
         $idStatus = $listAttachments->mat_status[$i];
         $idPublish = $listAttachments->mat_published[$i];
         $type = file_info_type($listAttachments->mat_extension[$i]);
         if (file_exists("../files/" . $listAttachments->mat_project[$i] . "/meetings/" . $listAttachments->mat_meeting[$i] . "/" . $listAttachments->mat_name[$i])) {
             $existFile = "true";

$block9->openPaletteScript();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block9->paletteScript(0, 'add', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']);
    $block9->paletteScript(1, 'remove', '../tasks/deletetasks.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
    $block9->paletteScript(2, 'copy', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0] . '&cpy=true', 'false,true,false', $strings['copy']);
}
$block9->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block9->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']);
}
$block9->closePaletteScript($comptListMilestones, $listMilestones->tas_id);
$block10 = new block();
//--- block header ----
$block10->form = 'wbTuuC';
$block10->openForm("../phases/listphases.php?id={$id}#" . $block10->form . "Anchor");
$block10->sorting('tasks_closed', $sortingUser->sor_tasks_closed[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'tas.parent_phase', 'mem.login', 'tas.published'));
$block10->borne = $blockPage->returnBorne('1');
$block10->rowsLimit = '20';
//--- get data from sql ---------
$tmpquery = "WHERE tas.project = '{$id}' AND tas.status NOT IN(0,2,3) AND tas.milestone = '1' ORDER BY {$block10->sortingValue}";
$block10->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
//--- list ---------
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block10->borne, $block10->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
$block10->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>');
$block10->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block10->paletteIcon(0, 'add', $strings['add']);
    $block10->paletteIcon(1, 'remove', $strings['delete']);
    $block10->paletteIcon(2, 'copy', $strings['copy']);

include_once '../includes/library.php';
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["organizations"], in));
$blockPage->itemBreadcrumbs($strings["organizations"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
    include '../includes/messages.php';
    $blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->form = "clientList";
$block1->openForm("../clients/listclients.php?" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor");
$block1->heading($strings["organizations"]);
$block1->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.phone", 2 => "org.url"));
$tmpquery = "WHERE org.id != '1' ORDER BY {$block1->sortingValue}";
$listOrganizations = new request();
$listOrganizations->openOrganizations($tmpquery);
$comptListOrganizations = count($listOrganizations->org_id);
if ($comptListOrganizations != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false");
    for ($i = 0; $i < $comptListOrganizations; $i++) {
        $block1->openRow();
        $block1->checkboxRow($listOrganizations->org_id[$i]);
        $block1->cellRow($blockPage->buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], in));
        $block1->cellRow($listOrganizations->org_phone[$i]);
        $block1->cellRow($blockPage->buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], out));
        $block1->closeRow();
    }

$block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\" \r\nsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>");
echo "\r\n<tr class='odd'>\r\n  <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n  <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n</tr>\r\n<tr class='odd'>\r\n  <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n  <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n</tr>\r\n<tr class='odd'>\r\n  <td valign='top' class='leftvalue'>&nbsp;</td>\r\n  <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n</tr>";
$block1->closeContent();
$block1->closeForm();
// This will display time log detail for the current meeting
$block2 = new block();
$block2->form = "ahT";
$block2->openForm("../meetings/addmeetingtime.php?id={$id}#" . $block2->form . "Anchor");
$block2->heading($strings["meeting_time"] . ' : ' . $strings["details"]);
$block2->openPaletteIcon();
$block2->paletteIcon(0, "remove", $strings["delete"]);
$block2->paletteIcon(1, "edit", $strings["edit"]);
$block2->closePaletteIcon();
$block2->borne = $blockPage->returnBorne("1");
$block2->rowsLimit = "20";
$block2->sorting('meetings_time', $sortingUser->sor_meetings_time[0], 'mti.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mti.date', 2 => 'mti.hours', 3 => 'mti.created', 4 => 'mti.modified', 5 => 'mti.comments'));
$tmpquery = "WHERE mti.meeting = '{$id}' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest["meetings_time"] . " " . $tmpquery);
$listMeetingTimes = new request();
$listMeetingTimes->openMeetingTime($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListMeetingTimes = count($listMeetingTimes->mti_id);
if ($comptListMeetingTimes != "0") {
    $block2->openResults();
    $block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
    // display logged hours for project
    for ($i = 0; $i < $comptListMeetingTimes; $i++) {
        // only PM, PMA, and OWNERS can modify/delete
        if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listMeetingTimes->mti_owner[$i]) {
            $block2->openRow($listMeetingTimes->mti_id[$i]);
            $block2->checkboxRow($listMeetingTimes->mti_id[$i], 'true');
            $block2->cellRow($listMeetingTimes->mti_mem_name[$i]);

    $block1->paletteIcon(2, "copy", $strings["copy"]);
    // $block1->paletteIcon(3,"export",$strings["export"]);
    if ($sitePublish == "true") {
        $block1->paletteIcon(4, "add_projectsite", $strings["add_project_site"]);
        $block1->paletteIcon(5, "remove_projectsite", $strings["remove_project_site"]);
    }
}
$block1->paletteIcon(6, "info", $strings["view"]);
if ($teamMember == "true") {
    $block1->paletteIcon(7, "edit", $strings["edit"]);
    $block1->paletteIcon(8, "timelog", $strings["loghours"]);
}
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "20";
$block1->sorting("meetings", $sortingUser->sor_meetings[0], 'mee.date DESC', $sortingFields = array(0 => 'mee.id', 1 => 'mee.name', 2 => 'mee.priority', 3 => 'mee.status', 4 => 'mee.date'));
$tmpquery = "WHERE mee.project = '{$project}' ORDER BY {$block1->sortingValue}";
$block1->recordsTotal = compt($initrequest["meetings"] . " " . $tmpquery);
$listMeetings = new request();
$listMeetings->openMeetings($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListMeetings = count($listMeetings->mee_id);
if ($comptListMeetings != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings['id'], 1 => $strings['meeting'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['date']), 'true');
    for ($i = 0; $i < $comptListMeetings; $i++) {
        $idStatus = $listMeetings->mee_status[$i];
        $idPriority = $listMeetings->mee_priority[$i];
        $idPublish = $listMeetings->mee_published[$i];
        $block1->openRow($listMeetings->mee_id[$i]);
        $block1->checkboxRow($listMeetings->mee_id[$i]);
        $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_id[$i], LINK_INSIDE));

 $block1 = new block();
 $block1->form = "calendList";
 $block1->openForm("../calendar/viewcalendar.php?viewCalend={$viewCalend}&type={$type}&dateCalend={$dateCalend}#" . $block1->form . "Anchor");
 if ($viewCalend == 0) {
     $heading_posfix = "(" . $strings['cal_personal'] . $strings['calendar'] . ")";
 } else {
     $heading_posfix = "(" . $strings['project'] . $strings['calendar'] . "-" . $listTeam->tea_pro_name[0] . ")";
 }
 $block1->heading("{$dayName} {$day} {$monthName} {$year}" . $heading_posfix);
 $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));
 if ($viewCalend == 0) {
     $tmpquery = "WHERE cal.owner = '" . $_SESSION['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}')) ORDER BY cal.shortname";
 } else {
     $tmpquery = "WHERE cal.project = '{$viewCalend}' 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";
 }
 // $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' 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($listCalendar->cal_id[$i]);

if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block4->paletteScript(0, 'add', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']);
    $block4->paletteScript(1, 'remove', '../tasks/deletetasks.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
    $block4->paletteScript(2, 'copy', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0] . '&cpy=true', 'false,true,false', $strings['copy']);
}
$block4->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block4->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']);
}
$block4->closePaletteScript($comptListMilestones, $listMilestones->tas_id);
$block3 = new block();
//--- block header ----
$block3->form = 'saTlC';
$block3->openForm("../tasks/listtasks.php?project={$project}#" . $block3->form . "Anchor");
if (isset($flag_phases) && $flag_phases == true) {
    $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[0], "tas.due_date ASC", $sortingFields = array("tas.priority", "tas.name", "tas.status", "tas.completion", "tas.due_date", 'tas.parent_phase', "mem.login", "tas.published"));
} else {
    $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[0], "tas.due_date ASC", $sortingFields = array("tas.priority", "tas.name", "tas.status", "tas.completion", "tas.due_date", "mem.login", "tas.published"));
}
$block3->borne = $blockPage->returnBorne('1');
$block3->rowsLimit = '20';
//--- get data from sql ---------
$tmpquery = "WHERE tas.project = '{$project}' AND tas.status NOT IN(0,2,3,5) AND tas.milestone = '1' ORDER BY {$block3->sortingValue}";
$block3->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
//--- list ---------
$listClosedTasks = new request();
$listClosedTasks->openTasks($tmpquery, $block3->borne, $block3->rowsLimit);
$comptListTasks = count($listClosedTasks->tas_id);
$block3->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>');
$block3->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {

        }
    }
    $block5->paletteScript(4, 'info', '../linkedcontent/viewfile.php', 'false,true,false', $strings['view']);
    if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
        $block5->paletteScript(5, 'edit', '../linkedcontent/viewfile.php?edit=true', 'false,true,false', $strings['edit']);
    }
    $block5->closePaletteScript($comptListFiles, $listFiles->fil_id);
}
$block6 = new block();
$block6->form = 'wbJ';
$block6->openForm('../projects/viewproject.php?id=' . $projectDetail->pro_id[0] . '#' . $block6->form . 'Anchor');
$block6->borne = $blockPage->returnBorne('4');
$block6->rowsLimit = '5';
$comptTopic = count($topicNote);
if ($comptTopic != '0') {
    $block6->sorting('notes', $sortingUser->sor_notes[0], 'note.date DESC', $sortingFields = array(0 => 'note.subject', 1 => 'note.topic', 2 => 'note.date', 3 => 'mem.login', 4 => 'note.published'));
} else {
    $block6->sorting('notes', $sortingUser->sor_notes[0], 'note.date DESC', $sortingFields = array(0 => 'note.subject', 1 => 'note.date', 2 => 'mem.login', 3 => 'note.published'));
}
$tmpquery = "WHERE note.project = '{$id}' ORDER BY {$block6->sortingValue}";
$block6->recordsTotal = compt($initrequest['notes'] . ' ' . $tmpquery);
$listNotes = new request();
$listNotes->openNotes($tmpquery, $block6->borne, $block6->rowsLimit);
$comptListNotes = count($listNotes->note_id);
$block6->headingToggle($strings['notes'] . ' <span class=addition>(' . $comptListNotes . ')</span>');
$block6->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block6->paletteIcon(0, 'add', $strings['add']);
    $block6->paletteIcon(1, 'remove', $strings['delete']);
    // $block6->paletteIcon(2,'export',$strings['export']);
    if ($sitePublish == 'true') {

$block1->openPaletteIcon();
$block1->paletteIcon(0, 'add', $strings['add']);
if ($view == 'my') {
    $block1->paletteIcon(1, 'remove', $strings['delete']);
}
/*if ($sitePublish == "true") {
	$block1->paletteIcon(3,"add_projectsite",$strings["add_project_site"]);
	$block1->paletteIcon(4,"remove_projectsite",$strings["remove_project_site"]);
}*/
$block1->paletteIcon(5, 'info', $strings['view']);
if ($view == 'my') {
    $block1->paletteIcon(6, 'edit', $strings['edit']);
}
$block1->closePaletteIcon();
if ($view == 'my') {
    $block1->sorting('bookmarks', $sortingUser->sor_bookmarks[0], 'boo.name ASC', $sortingFields = array(0 => 'boo.name', 1 => 'boo.category', 2 => 'boo.shared'));
} else {
    $block1->sorting('bookmarks', $sortingUser->sor_bookmarks[0], 'boo.name ASC', $sortingFields = array(0 => 'boo.name', 1 => 'boo.category', 2 => 'mem.login'));
}
if ($view == 'my') {
    $tmpquery = "WHERE boo.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
} else {
    if ($view == 'private') {
        $tmpquery = "WHERE boo.users LIKE '%|" . $_SESSION['idSession'] . "|%' ORDER BY {$block1->sortingValue}";
    } else {
        $tmpquery = "WHERE boo.shared = '1' OR boo.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
    }
}
$listBookmarks = new request();
$listBookmarks->openBookmarks($tmpquery);
$comptListBookmarks = count($listBookmarks->boo_id);

 }
 if ($A[is_using_forum_flag] == 'Y') {
     $blockPage->bornesNumber = "5";
     $block5 = new block();
     $block5->form = "forP";
     $block5->openForm($_CONF['site_url'] . "/nexproject/viewproject.php?" . "#" . $block2->form . "Anchor");
     $block5->headingToggle($strings["forum"]);
     if ($membertoken != 0) {
         $block5->openPaletteIcon();
         $block5->paletteIcon(0, "view", $strings["view"]);
         $block5->paletteIcon(1, "info", $strings["add"]);
         $block5->closePaletteIcon();
     }
     $block5->borne = $blockPage->returnBorne("5");
     $block5->rowsLimit = 5;
     $block5->sorting('discussions', $sortingUser[forum], "{$_TABLES['gf_topic']}.lastupdated DESC", $sortingFields = array(0 => "{$_TABLES['gf_topic']}.subject", 1 => "{$_TABLES['gf_topic']}.name", 2 => "{$_TABLES['gf_topic']}.lastupdated", 3 => "{$_TABLES['gf_topic']}.replies"));
     $sql = "SELECT {$_TABLES['gf_topic']}.id,{$_TABLES['gf_topic']}.pid,";
     $sql .= "{$_TABLES['gf_topic']}.subject,{$_TABLES['users']}.fullname,";
     $sql .= "{$_TABLES['gf_topic']}.lastupdated,{$_TABLES['gf_topic']}.replies ";
     $sql .= "FROM {$_TABLES['gf_topic']}, {$_TABLES['users']} ";
     $sql .= "WHERE forum={$A['fid']} AND pid=0 ";
     $sql .= "AND {$_TABLES['gf_topic']}.uid={$_TABLES['users']}.uid ";
     $sql .= "ORDER BY {$block5->sortingValue}";
     $result = DB_query($sql);
     $block5->recordsTotal = DB_numrows($result);
     $sql = "SELECT {$_TABLES['gf_topic']}.id,{$_TABLES['gf_topic']}.pid,";
     $sql .= "{$_TABLES['gf_topic']}.subject,{$_TABLES['users']}.fullname,";
     $sql .= "{$_TABLES['gf_topic']}.lastupdated,{$_TABLES['gf_topic']}.replies ";
     $sql .= "FROM {$_TABLES['gf_topic']}, {$_TABLES['users']} ";
     $sql .= "WHERE forum={$A['fid']} AND pid=0 ";
     $sql .= "AND {$_TABLES['gf_topic']}.uid={$_TABLES['users']}.uid ";

    $block1->paletteIcon(1, "remove", $strings["delete"]);
    $block1->paletteIcon(2, "copy", $strings["copy"]);
    //$block1->paletteIcon(3,"export",$strings["export"]);
    if ($sitePublish == "true") {
        $block1->paletteIcon(4, "add_projectsite", $strings["add_project_site"]);
        $block1->paletteIcon(5, "remove_projectsite", $strings["remove_project_site"]);
    }
}
$block1->paletteIcon(6, "info", $strings["view"]);
if ($teamMember == "true") {
    $block1->paletteIcon(7, "edit", $strings["edit"]);
}
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "20";
$block1->sorting("tasks", $sortingUser->sor_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.name", 1 => "tas.priority", 2 => "tas.status", 3 => "tas.completion", 4 => "tas.due_date", 5 => "mem.login", 6 => "tas.published"));
$tmpquery = "WHERE tas.project = '{$project}' ORDER BY {$block1->sortingValue}";
$block1->recordsTotal = compt($initrequest["tasks"] . " " . $tmpquery);
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
if ($comptListTasks != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["completion"], 4 => $strings["due_date"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true");
    for ($i = 0; $i < $comptListTasks; $i++) {
        if ($listTasks->tas_due_date[$i] == "") {
            $listTasks->tas_due_date[$i] = $strings["none"];
        }
        $idStatus = $listTasks->tas_status[$i];
        $idPriority = $listTasks->tas_priority[$i];
        $idPublish = $listTasks->tas_published[$i];

$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../teams/listusers.php?id=" . $projectDetail->pro_id[0], $strings["team_members"], in));
$blockPage->itemBreadcrumbs($strings["add_team"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->form = "atpt";
$block1->openForm("../teams/adduser.php?" . session_name() . "=" . session_id() . "&project={$project}#" . $block1->form . "Anchor");
$block1->heading($strings["add_team"]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "info", $strings["view"]);
$block1->paletteIcon(2, "edit", $strings["edit"]);
$block1->closePaletteIcon();
$block1->sorting("users", $sortingUser->sor_users[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected"));
$tmpquery = "WHERE tea.project = '{$project}' AND mem.profil != '3'";
$concatMembers = new request();
$concatMembers->openTeams($tmpquery);
$comptConcatMembers = count($concatMembers->tea_id);
for ($i = 0; $i < $comptConcatMembers; $i++) {
    $membersTeam .= $concatMembers->tea_mem_id[$i];
    if ($i < $comptConcatMembers - 1) {
        $membersTeam .= ",";
    }
}
if ($demoMode == "true") {
    $tmpquery = "WHERE mem.id NOT IN({$membersTeam}) AND mem.profil != '3' ORDER BY {$block1->sortingValue}";
} else {
    $tmpquery = "WHERE mem.id NOT IN({$membersTeam}) AND mem.profil != '3' AND mem.id != '2' ORDER BY {$block1->sortingValue}";
}

    if ($S_COMPLETEDATE != "ALL" && $S_EDATE2 != "") {
        if ($query != "") {
            $query .= " AND tas.complete_date <= '{$S_EDATE2}'";
        } else {
            $query .= "tas.complete_date <= '{$S_EDATE2}'";
        }
    }
    $query .= ")";
}
$blockPage = new block();
if ($msg != "") {
    include '../includes/messages.php';
    $blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->sorting("report_tasks", $sortingUser->sor_report_tasks[0], "tas.complete_date DESC", $sortingFields = array(0 => "tas.name", 1 => "tas.project", 2 => "tas.actual_time", 3 => "tas.completion", 4 => "tas.status", 5 => "tas.start_date", 6 => "tas.due_date", 7 => "tas.complete_date", 8 => "mem.login", 9 => "tas.description", 10 => "tas.comments"));
if ($projectsFilter == "true") {
    $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
    $tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '{$idSession}' ORDER BY pro.id";
    $listProjectsTasks = new request();
    $listProjectsTasks->openProjects($tmpquery);
    $comptListProjectsTasks = count($listProjectsTasks->pro_id);
    if ($comptListProjectsTasks != "0") {
        for ($i = 0; $i < $comptListProjectsTasks; $i++) {
            $filterTasks .= $listProjectsTasks->pro_id[$i];
            if ($comptListProjectsTasks - 1 != $i) {
                $filterTasks .= ",";
            }
        }
        if ($query != "") {
            $tmpquery = "{$queryStart} {$query} AND pro.id IN({$filterTasks}) ORDER BY {$block1->sortingValue}";

// configuration options
// today's date
$datenow = date("Y-m-d");
// end of configuration
$checkSession = true;
require_once "../includes/library.php";
$breadcrumbs[] = $strings['reports'];
$breadcrumbs[] = buildLink('../reports/createreport.php?typeReports=create', $strings["create_report"], in) . ' | ' . buildLink('../reports/createreport.php?typeReports=custom', $strings['custom_reports'], LINK_INSIDE);
$pageSection = 'reports';
require_once "../themes/" . THEME . "/header.php";
// start the first block
$block1 = new block();
$block1->form = "xwbT";
$block1->openForm("../reports/overdue.php#" . $block1->form . "Anchor");
$block1->openContent();
$block1->sorting("home_tasks", $sortingUser->sor_home_tasks[0], "tas.priority DESC", $sortingFields = array(0 => "tas.name", 1 => "pro.name", 2 => "tas.status", 3 => "tas.completion", 4 => "tas.due_date", 5 => "mem.login", 6 => "tas.priority"));
$query = " WHERE tas.status > 1 and (tas.due_date < '{$datenow}' AND tas.due_date <> '--')";
$tmpquery = "{$query} ORDER BY {$block1->sortingValue}";
$listTasks = new request();
$listTasks->openTasks($tmpquery);
$comptListTasks = count($listTasks->tas_id);
$block0 = new block();
$block0->openContent();
$block0->contentTitle($strings["report_results"]);
if ($comptListTasks == "0") {
    $block0->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]);
}
if ($comptListTasks == "1") {
    $block0->contentRow("", "1 " . $strings["match"]);
}
if ($comptListTasks > "1") {