PHP block::openResults方法代码示例

    $block1->paletteIcon(0, "add", $strings["add"]);
    $block1->paletteIcon(1, "remove", $strings["delete"]);
    if ($sitePublish == "true") {
        $block1->paletteIcon(2, "add_projectsite", $strings["add_project_site"]);
        $block1->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]);
    }
}
$block1->paletteIcon(4, "info", $strings["view"]);
$block1->paletteIcon(5, "email", $strings["email"]);
$block1->closePaletteIcon();
$block1->sorting("team", $sortingUser->sor_team[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected", 5 => "tea.published"));
$tmpquery = "WHERE tea.project = '{$id}' AND mem.profil != '3' ORDER BY {$block1->sortingValue}";
$listTeam = new request();
$listTeam->openTeams($tmpquery);
$comptListTeam = count($listTeam->tea_id);
$block1->openResults();
$block1->labels($labels = array(0 => $strings["full_name"], 1 => $strings["title"], 2 => $strings["user_name"], 3 => $strings["work_phone"], 4 => $strings["connected"], 5 => $strings["published"]), "true");
for ($i = 0; $i < $comptListTeam; $i++) {
    if ($listTeam->tea_mem_phone_work[$i] == "") {
        $listTeam->tea_mem_phone_work[$i] = $strings["none"];
    }
    $idPublish = $listTeam->tea_published[$i];
    $block1->openRow();
    $block1->checkboxRow($listTeam->tea_mem_id[$i]);
    $block1->cellRow($blockPage->buildLink("../users/viewuser.php?id=" . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], in));
    $block1->cellRow($listTeam->tea_mem_title[$i]);
    $block1->cellRow($blockPage->buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], mail));
    $block1->cellRow($listTeam->tea_mem_phone_work[$i]);
    if ($listTeam->tea_log_connected[$i] > $dateunix - 5 * 60) {
        $block1->cellRow($strings["yes"] . " " . $z);
    } else {

$block2->openForm("../tasks/addtasktime.php?id={$id}#" . $block2->form . "Anchor");
$block2->heading($strings["task_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('tasks_time', $sortingUser->sor_tasks_time[0], 'tim.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'tim.date', 2 => 'tim.hours', 3 => 'tim.created', 4 => 'tim.modified', 5 => 'tim.comments'));
$tmpquery = "WHERE tim.task = '{$id}' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest["tasks_time"] . " " . $tmpquery);
$listTaskTimes = new request();
$listTaskTimes->openTaskTime($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTaskTimes = count($listTaskTimes->tim_id);
if ($comptListTaskTimes != "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 < $comptListTaskTimes; $i++) {
        // only PM, PMA, and OWNERS can modify/delete
        if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listTaskTimes->tim_owner[$i]) {
            $block2->openRow($listTaskTimes->tim_id[$i]);
            $block2->checkboxRow($listTaskTimes->tim_id[$i], 'true');
            $block2->cellRow($listTaskTimes->tim_mem_name[$i]);
            $block2->cellRow($listTaskTimes->tim_date[$i]);
            $block2->cellRow($listTaskTimes->tim_hours[$i]);
            $block2->cellRow($listTaskTimes->tim_created[$i]);
            $block2->cellRow($listTaskTimes->tim_modified[$i]);
            // truncate large comments to keep the display clean
            $comments = $listTaskTimes->tim_comments[$i];
            $lenComm = 40;

    $block10->paletteIcon(1, 'remove', $strings['delete']);
    $block10->paletteIcon(2, 'copy', $strings['copy']);
    // $block10->paletteIcon(3,'export',$strings['export']);
    if ($sitePublish == 'true') {
        $block10->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
        $block10->paletteIcon(5, 'remove_projectsite', $strings['remove_project_site']);
    }
}
$block10->paletteIcon(6, 'info', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block10->paletteIcon(7, 'edit', $strings['edit']);
    $block10->paletteIcon(8, 'timelog', $strings['loghours']);
}
$block10->closePaletteIcon();
if ($comptListTasks != '0') {
    $block10->openResults();
    $block10->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $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];
        $complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . '0 %' : $listTasks->tas_completion[$i] . ' %';
        $block10->openRow($listTasks->tas_id[$i]);
        $block10->checkboxRow($listTasks->tas_id[$i]);
        //--- id ----
        #$block10->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_id[$i], LINK_INSIDE));
        //--- prio ---
        $block10->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true);

 $blockProject->contentRow($strings["created"], createDate($listProjects->pro_created[$j], $_SESSION['timezoneSession']));
 $blockProject->contentRow($strings["modified"], createDate($listProjects->pro_modified[$j], $_SESSION['timezoneSession']));
 if ($listProjects->pro_org_id[$j] == "1") {
     $blockProject->contentRow($strings["organization"], $strings["none"]);
 } else {
     $blockProject->contentRow($strings["organization"], buildLink("../clients/viewclient.php?id=" . $listProjects->pro_org_id[$j], $listProjects->pro_org_name[$j], LINK_INSIDE));
 }
 $blockProject->contentRow($strings["status"], $status[$listProjects->pro_status[$j]]);
 $queryTask = " WHERE tas.project = '{$projectId}'";
 $tmpqueryTask = "{$queryTask} ORDER BY tas.due_date";
 $blockProject->closeContent();
 $blockProject->heading_close();
 $listTasks = new request();
 $listTasks->openTasks($tmpqueryTask);
 $comptListTasks = count($listTasks->tas_id);
 $blockProject->openResults("false");
 $blockProject->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["due_date"], 4 => $strings["completed"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true");
 if ($comptListProjects != "0") {
     for ($i = 0; $i < $comptListTasks; $i++) {
         if ($listTasks->tas_due_date[$i] == "--" or $listTasks->tas_due_date[$i] == "") {
             $listTasks->tas_due_date[$i] = $strings["none"];
         }
         $idStatus = $listTasks->tas_status[$i];
         $idPriority = $listTasks->tas_priority[$i];
         $idPublished = $listTasks->tas_published[$i];
         $complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . "0 %" : $listTasks->tas_completion[$i] . " %";
         $blockProject->openRow();
         $blockProject->checkboxRow($listTasks->tas_id[$i], $checkbox = "false");
         $blockProject->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE));
         $blockProject->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">&nbsp;' . $priority[$idPriority], '', true);
         $blockProject->cellRow($status[$idStatus]);

$breadcrumbs[] = $strings["organizations"];
require_once "../themes/" . THEME . "/header.php";
$block1 = new block();
$block1->form = "clientList";
$block1->openForm("../clients/listclients.php#" . $block1->form . "Anchor");
$block1->heading($strings["organizations"]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$tmpquery = "WHERE org.id != '1' ORDER BY org.url DESC";
$listOrganizations = new request();
$listOrganizations->openOrganizations($tmpquery);
$comptListOrganizations = count($listOrganizations->org_id);
if ($comptListOrganizations != "0") {
    $block1->openResults($checkbox = "false");
    $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false", $sorting = "false", $sortingOff = array(0 => "2", 1 => "DESC"));
    for ($i = 0; $i < $comptListOrganizations; $i++) {
        $block1->openRow();
        $block1->checkboxRow($listOrganizations->org_id[$i], $checkbox = "false");
        $block1->cellRow(buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], LINK_INSIDE));
        $block1->cellRow($listOrganizations->org_phone[$i]);
        $block1->cellRow(buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], LINK_OUT));
        $block1->closeRow();
    }
    $block1->closeResults();
} else {
    $block1->noresults();
}
$block1->closeFormResults();
$block1->openPaletteScript();

    $block5->bornesFooter("5", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}");
    $block5->closeToggle();
    $block3->headingForm_close();
    $block5->closeFormResults();
    /*$block5->openPaletteScript();
    $block5->paletteScript(0,"export","../projects/exportproject.php?languageSession=" . $_SESSION['languageSession'] . "&type=project","false,true,false",$strings["export"]);
    $block5->closePaletteScript($comptListTopics,$listTopics->top_id);*/
}
if ($comptListNotes != "0") {
    $block6->form = "notesForm";
    $block6->openForm("../search/resultssearch.php?searchfor={$searchfor}&heading={$heading}#" . $block6->form . "Anchor");
    $block6->headingForm($strings["search_results"] . " : " . $strings["notes"] . " ({$block6->recordsTotal})");
    /*$block6->openPaletteIcon();
    $block6->paletteIcon(0,"export",$strings["export"]);
    $block6->closePaletteIcon();*/
    $block6->openResults();
    if ($comptTopic != "0") {
        $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["topic"], 2 => $strings["date"], 3 => $strings["owner"], 4 => $strings["published"]), "true");
    } else {
        $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["date"], 2 => $strings["owner"], 3 => $strings["published"]), "true");
    }
    for ($i = 0; $i < $comptListNotes; $i++) {
        $idPublish = $listNotes->note_published[$i];
        $block6->openRow($listNotes->note_id[$i]);
        $block6->checkboxRow($listNotes->note_id[$i]);
        $block6->cellRow(buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], LINK_INSIDE));
        if ($comptTopic != "0") {
            $block6->cellRow($topicNote[$listNotes->note_topic[$i]]);
        }
        $block6->cellRow($listNotes->note_date[$i]);
        $block6->cellRow(buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], LINK_MAIL));

function prj_displayMyProjectTasks(&$blockPage)
{
    global $_TABLES, $_CONF, $_USER, $_COOKIE, $subTaskImg, $progress, $priority, $strings, $labels, $_PRJCONF;
    $limitbase = $_COOKIE['alltasksmin'];
    if ($limitbase == '') {
        $limitbase = 0;
    }
    $useThisTIDforAjax = 0;
    $filterCSV = COM_applyFilter($_COOKIE['filterTasks']);
    if ($blockPage == NULL or $blockPage == '') {
        $blockPage = new block();
    }
    $block2 = new block();
    if ($msg != "") {
        require_once "includes/messages.php";
        $blockPage->messagebox($msgLabel);
    }
    if (!isset($_USER['uid']) or $_USER['uid'] == "") {
        $uid = 1;
    } else {
        $uid = $_USER['uid'];
    }
    //my tasks
    $blockPage->bornesNumber = "2";
    $block2 = new block();
    $block2->form = "taP";
    $block2->openForm($_CONF['site_url'] . "/nexproject/index.php?" . "#" . $block2->form . "Anchor");
    $headingTitle = $strings['my_tasks'];
    $headingStatusArea = '<span id="ajaxstatus_tasks" class="pluginInfo" style="display:none">&nbsp;</span>';
    $block2->headingToggle($headingTitle, $headingStatusArea);
    $block2->borne = $blockPage->returnBorne("2");
    $block2->rowsLimit = $_PRJCONF['task_block_rows'];
    $lim = $limitbase * $block2->rowsLimit;
    echo '<!--startMyTasks-->';
    echo '<div id="divMyTasks">';
    $sql = "SELECT {$_TABLES['prj_tasks']}.tid FROM {$_TABLES['prj_tasks']}, {$_TABLES['prj_task_users']}, {$_TABLES['users']} ";
    $sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
    $sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.uid={$uid} ";
    $sql .= "AND {$_TABLES['prj_task_users']}.role='o' AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
    $result = DB_query($sql);
    $block2->recordsTotal = DB_numrows($result);
    $lim = $limitbase * $block2->rowsLimit;
    $sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
    $sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
    $sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid  FROM {$_TABLES['prj_tasks']}, ";
    $sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
    $sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
    $sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
    $sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
    $sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
    if ($filterCSV != '') {
        $sql .= "AND  {$_TABLES['prj_tasks']}.pid  in ({$filterCSV})";
    }
    $sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
    $sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
    $result = DB_query($sql, true);
    $comptListTasks = DB_numrows($result);
    if ($result == FALSE) {
        //remove the filterCSV as there might be a cookie issue with it...
        $sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
        $sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
        $sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid  FROM {$_TABLES['prj_tasks']}, ";
        $sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
        $sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
        $sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
        $sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
        $sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
        $sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
        $sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
        $result = DB_query($sql);
        $comptListTasks = DB_numrows($result);
    }
    if ($comptListTasks != "0") {
        $block2->openResults(false);
        $block2->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["project"], 3 => $strings["start_date"], 4 => $strings["estimated_end_date"]), "true");
        for ($i = 0; $i < DB_numrows($result); $i++) {
            list($tid, $idProgress, $projectname, $idPriority, $taskname, $estenddate, $startdate, $pid) = DB_fetchArray($result);
            $full_projectname = $projectname;
            $full_taskname = $taskname;
            if (strlen($taskname) > 25) {
                $taskname = substr($taskname, 0, 25) . "....";
            }
            if (strlen($projectname) > 20) {
                $projectname = substr($projectname, 0, 20) . "....";
            }
            $block2->openRow();
            //$block2->checkboxRow($pid);
            $block2->cellProgress($progress[$idProgress]);
            $block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?mode=view&id={$tid}", $taskname, "mytaskcontext", $full_taskname, '', $tid));
            $block2->cellRow($priority[$idPriority]);
            $block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?pid={$pid}", $projectname, "context", $full_projectname, $pid));
            $block2->cellRow(strftime("%Y/%m/%d", $startdate));
            $block2->cellRow(strftime("%Y/%m/%d", $estenddate));
            $block2->closeRow();
        }
        $block2->closeResults();
        $pages = intval($block2->recordsTotal / $block2->rowsLimit);
        if (fmod($block2->recordsTotal, $block2->rowsLimit) > 0) {
            $pages += 1;
        }
//.........这里部分代码省略.........

$block4 = new block();
$block4->form = "wbSe";
$block4->openForm("../general/home.php#" . $block4->form . "Anchor");
$block4->sorting("home_reports", $sortingUser->sor_home_reports[0], "rep.name ASC", $sortingFields = array(0 => "rep.name", 1 => "rep.created"));
$tmpquery = "WHERE rep.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block4->sortingValue}";
$listReports = new request();
$listReports->openReports($tmpquery);
$comptListReports = count($listReports->rep_id);
$block4->headingToggle($strings["my_reports"] . " <span class=addition>({$comptListReports})</span>");
$block4->openPaletteIcon();
$block4->paletteIcon(0, "add", $strings["new"]);
$block4->paletteIcon(1, "remove", $strings["delete"]);
$block4->paletteIcon(2, "info", $strings["view"]);
$block4->closePaletteIcon();
if ($comptListReports != "0") {
    $block4->openResults();
    $block4->labels($labels = array(0 => $strings["name"], 1 => $strings["created"]), "false");
    for ($i = 0; $i < $comptListReports; $i++) {
        $block4->openRow($listReports->rep_id[$i]);
        $block4->checkboxRow($listReports->rep_id[$i]);
        $block4->cellRow(buildLink("../reports/resultsreport.php?id=" . $listReports->rep_id[$i], $listReports->rep_name[$i], LINK_INSIDE), "31");
        $block4->cellRow(createDate($listReports->rep_created[$i], $_SESSION['timezoneSession']));
        $block4->closeRow();
    }
    $block4->closeResults();
} else {
    $block4->noresults();
}
$block4->closeToggle();
$block4->closeFormResults();
$block4->openPaletteScript();

if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
    $block3->paletteIcon(0, 'add', $strings['add']);
    $block3->paletteIcon(1, 'remove', $strings['delete']);
}
$block3->paletteIcon(2, 'info', $strings['view']);
if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
    $block3->paletteIcon(3, 'edit', $strings['edit']);
}
$block3->closePaletteIcon();
$block3->sorting('users', $sortingUser->sor_users[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.login', 2 => 'mem.email_work', 3 => 'mem.profil', 4 => 'connected'));
$tmpquery = "WHERE mem.organization = '{$id}' ORDER BY {$block3->sortingValue}";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
if ($comptListMembers != '0') {
    $block3->openResults();
    $block3->labels($labels = array(0 => $strings['full_name'], 1 => $strings['user_name'], 2 => $strings['email'], 3 => $strings['work_phone'], 4 => $strings['connected']), 'false');
    for ($i = 0; $i < $comptListMembers; $i++) {
        $block3->openRow($listMembers->mem_id[$i]);
        $block3->checkboxRow($listMembers->mem_id[$i]);
        $block3->cellRow(buildLink('../users/viewclientuser.php?id=' . $listMembers->mem_id[$i] . "&amp;organization={$id}", $listMembers->mem_name[$i], LINK_INSIDE));
        $block3->cellRow($listMembers->mem_login[$i]);
        $block3->cellRow(buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], LINK_MAIL));
        $block3->cellRow($listMembers->mem_phone_work[$i]);
        $z = '(Client on project site)';
        if ($listMembers->mem_log_connected[$i] > $dateunix - 5 * 60) {
            $block3->cellRow($strings['yes'] . ' ' . $z);
        } else {
            $block3->cellRow($strings['no']);
        }
    }

 $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 ";
 $sql .= "ORDER BY {$block5->sortingValue} LIMIT {$block5->borne},{$block5->rowsLimit}";
 $result = DB_query($sql);
 $comptListTasks = DB_numrows($result);
 if ($comptListTasks != "0") {
     $block5->openResults();
     $block5->labels($labels = array(0 => $strings["Subject"], 1 => $strings["Author"], 2 => $strings["lastUpdated"], 3 => $strings["Replies"]), "true");
     for ($i = 0; $i < $comptListTasks; $i++) {
         list($listForum->topic[$i], $parent, $listForum->subject[$i], $listForum->author[$i], $listForum->date[$i], $listForum->replies[$i]) = DB_fetchArray($result);
         $block5->openRow();
         $block5->checkboxRow($listForum->topic[$i]);
         $block5->cellRow($blockPage->buildLink($_CONF['site_url'] . "/forum/viewtopic.php?forum=" . $A[fid] . "&showtopic=" . $listForum->topic[$i], $listForum->subject[$i], "in", 'Click to View Discussion'));
         $block5->cellRow($listForum->author[$i]);
         $block5->cellRow(strftime("%Y/%m/%d %H:%M", $listForum->date[$i]));
         $block5->cellRow($listForum->replies[$i]);
         $block5->closeRow();
     }
     $block5->closeResults();
     $block5->bornesFooter("5", $blockPage->bornesNumber, "", "pid={$pid}");
 } else {
     $block5->noresults();

}
$block0->closeContent();
if ($comptListProjects != "0") {
    for ($j = 0; $j < $comptListProjects; $j++) {
        $projectTitle = $listProjects->pro_name[$j];
        $projectId = $listProjects->pro_id[$j];
        $projectPriority = $listProjects->pro_priority[$j];
        $blockProject = new block();
        $blockProject->headingForm(buildLink("../projects/viewproject.php?id=" . $projectId, $projectTitle, LINK_INSIDE));
        //         $blockProject->openContent();
        $queryPhase = "WHERE pha.project_id = '{$projectId}' ";
        $queryPhase .= "ORDER BY pha.order_num";
        $listPhases = new request();
        $listPhases->openPhases($queryPhase);
        $comptListPhases = count($listPhases->pha_id);
        $blockProject->openResults($checkbox = "false");
        // $blockProject->labels($labels = array(0=>$strings["phase"],1=>$strings["status"],2=>$strings["total_tasks"],3=>$strings["uncomplete_tasks"],4=>$strings["date_start"],5=>$strings["date_end"],6=>$strings['completion']),"true");
        $blockProject->labels($labels = array(0 => $strings["phase"], 1 => $strings["status"], 2 => $strings["total_tasks"], 3 => $strings["uncomplete_tasks"], 4 => $strings["date_start"], 5 => $strings["date_end"]), "true");
        if ($comptListProjects != "0") {
            for ($i = 0; $i < $comptListPhases; $i++) {
                $phaseNum = $listPhases->pha_order_num[$i];
                $phaseName = $listPhases->pha_name[$i];
                $phaseStart = $listPhases->pha_date_start[$i];
                $phaseEnd = $listPhases->pha_date_end[$i];
                $tmpquery = "WHERE tas.project = '{$projectId}' ";
                $tmpquery .= "AND tas.parent_phase = '{$phaseNum}'";
                $countPhaseTasks = new request();
                $countPhaseTasks->openTasks($tmpquery);
                $comptlistTasks = count($countPhaseTasks->tas_id);
                $comptlistTasksRow = "0";
                $comptUncompleteTasks = "0";

}
if ($action == 'delete') {
    $tmpquery = 'DELETE FROM ' . $tableCollab['logs'];
    connectSql($tmpquery);
}
//--- header ---
$breadcrumbs[] = buildLink('../administration/admin.php?', $strings['administration'], LINK_INSIDE);
$breadcrumbs[] = $strings['logs'];
$pageSection = 'admin';
require_once '../themes/' . THEME . '/header.php';
//--- content ----
$block1 = new block();
$block1->form = 'adminD';
$block1->openForm('../administration/listlogs.php?action=delete&id=' . $id . '#' . $block1->form . 'Anchor');
$block1->headingForm($strings['logs']);
$block1->openResults($checkbox = false);
$block1->labels($labels = array(0 => $strings['user_name'], 1 => $strings['ip'], 2 => $strings['session'], 3 => $strings['compteur'], 4 => $strings['last_visit'], 5 => $strings['connected']), false, $sorting = false, $sortingOff = array(0 => '4', 1 => 'DESC'));
$tmpquery = 'ORDER BY last_visite DESC';
$listLogs = new request();
$listLogs->openLogs($tmpquery);
$comptListLogs = count($listLogs->log_id);
$dateunix = date("U");
for ($i = 0; $i < $comptListLogs; $i++) {
    $block1->openRow();
    $block1->checkboxRow($listLogs->log_id[$i], $checkbox = false);
    $block1->cellRow($listLogs->log_login[$i]);
    $block1->cellRow($listLogs->log_ip[$i]);
    $block1->cellRow($listLogs->log_session[$i]);
    $block1->cellRow($listLogs->log_compt[$i]);
    $block1->cellRow(createDate($listLogs->log_last_visite[$i], $_SESSION['timezoneSession']));
    if ($listLogs->log_mem_profil[$i] == 3) {

if ($totalTasks > "1") {
    $block0->contentRow("", $totalTasks . " " . $strings["matches"]);
}
$block0->closeContent();
$block1->form = "Tasks";
$block1->openForm("../reports/resultsreport.php?" . session_name() . "=" . session_id() . "&tri=true&id={$id}#" . $block1->form . "Anchor");
$block1->heading($strings["report_results"]);
if ($comptListTasks != "0") {
    /** 
    you cannot export or delete a not saved report
    $block1->openPaletteIcon();
    $block1->paletteIcon(0,"export",$strings["export"]);
    $block1->paletteIcon(1,"remove",$strings["delete"]);
    $block1->closePaletteIcon();
    */
    $block1->openResults('false');
    $block1->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["due_date"], 4 => $strings["complete_date"], 5 => $strings["assigned_to"], 6 => $strings["project"], 7 => $strings["published"]), "true");
    for ($i = 0; $i < $comptListTasks; $i++) {
        $idStatus = $listTasks->tas_status[$i];
        $idPriority = $listTasks->tas_priority[$i];
        $idPublish = $listTasks->tas_published[$i];
        $block1->openRow();
        //$block1->checkboxRow($listTasks->tas_id[$i]);
        $block1->cellRow('');
        $block1->cellRow($blockPage->buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_name[$i], in));
        $block1->cellRow("<img src='../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif' alt=''> " . $priority[$idPriority]);
        $block1->cellRow($status[$idStatus]);
        if ($listTasks->tas_due_date[$i] <= $date && $listTasks->tas_completion[$i] != "10") {
            $block1->cellRow("<b>" . $listTasks->tas_due_date[$i] . "</b>");
        } else {
            $block1->cellRow($listTasks->tas_due_date[$i]);

 $block7->headingToggle($strings["phases"]);
 $block7->openPaletteIcon();
 $block7->paletteIcon(0, "info", $strings["view"]);
 if ($teamMember == "true" || $profilSession == "5") {
     if ($idSession == $projectDetail->pro_owner[0] || $profilSession == "0" || $profilSession == "5") {
         $block7->paletteIcon(1, "edit", $strings["edit"]);
     }
 }
 $block7->closePaletteIcon();
 $block7->sorting("phases", $sortingUser->sor_phases[0], "pha.order_num ASC", $sortingFields = array(0 => "pha.order_num", 1 => "pha.name", 2 => "none", 3 => "none", 4 => "pha.status", 5 => "pha.date_start", 6 => "pha.date_end"));
 $tmpquery = "WHERE pha.project_id = '{$id}' ORDER BY {$block7->sortingValue}";
 $listPhases = new request();
 $listPhases->openPhases($tmpquery);
 $comptListPhases = count($listPhases->pha_id);
 if ($comptListPhases != "0") {
     $block7->openResults();
     $block7->labels($labels = array(0 => $strings["order"], 1 => $strings["name"], 2 => $strings["total_tasks"], 3 => $strings["uncomplete_tasks"], 4 => $strings["status"], 5 => $strings["date_start"], 6 => $strings["date_end"]), "false");
     $tmpquery = "WHERE tas.project = '{$id}'";
     $countPhaseTasks = new request();
     $countPhaseTasks->openTasks($tmpquery);
     $comptlistTasks = count($countPhaseTasks->tas_id);
     for ($i = 0; $i < $comptListPhases; $i++) {
         $comptlistTasksRow = "0";
         $comptUncompleteTasks = "0";
         for ($k = 0; $k < $comptlistTasks; $k++) {
             if ($listPhases->pha_order_num[$i] == $countPhaseTasks->tas_parent_phase[$k]) {
                 $comptlistTasksRow = $comptlistTasksRow + 1;
                 if ($countPhaseTasks->tas_status[$k] == "2" || $countPhaseTasks->tas_status[$k] == "3" || $countPhaseTasks->tas_status[$k] == "4") {
                     $comptUncompleteTasks = $comptUncompleteTasks + 1;
                 }
             }