PHP block::openRow方法代码示例

     $listHours->connectClass();
     $listHours->query($tmpquery);
     $totalHours = 0;
     $theor_weekly_hours = $work_package[PROJECT_WEEKLY_HOURS];
     //$project_begin=new DateTime($work_package[PROJECT_BEGIN]);
     $project_begin = $work_package[PROJECT_BEGIN];
     //echo $work_package[PROJECT_BEGIN];
     //$project_now=new DateTime();
     $project_now = "NOW";
     //$project_duration_interval=date_diff($project_begin,$project_now);
     //$project_duration=($project_duration_interval->format("%d"));
     $project_duration_interval = date_diff_outdated($project_begin, $project_now, "w");
     //echo $project_duration;
     //echo $project_duration_interval;
     while ($row = $listHours->fetch()) {
         $block2->openRow($db_date_index);
         $block2->cellRow("");
         $block2->cellRow("{$row[0]} > {$row[1]}");
         $block2->cellRow("{$row[2]}");
         $block2->closeRow();
         $totalHours += intval($row[2]);
     }
     $pract_weekly_hours = round($totalHours / $project_duration_interval, 2);
     $theor_total_hours = round($theor_weekly_hours * $project_duration_interval, 2);
     $block2->openRow($db_date_index);
     $block2->cellRow("");
     $block2->cellRow("Total");
     $block2->cellRow("{$totalHours} (theor: {$theor_total_hours}) > {$pract_weekly_hours} hours weekly (theor: {$theor_weekly_hours})");
     $block2->closeRow();
 }
 $projectsList = rtrim($projectsList, ",");

 $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";
         }
         $block2->openRow($listAttachments->mat_id[$i]);
         $block2->checkboxRow($listAttachments->mat_id[$i]);
         if ($existFile == "true") {
             $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $type, icone));
         } else {
             $block2->cellRow("&nbsp;");
         }
         if ($existFile == "true") {
             $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $listAttachments->mat_name[$i], LINK_INSIDE));
         } else {
             $block2->cellRow($strings["missing_file"] . " (" . $listAttachments->mat_name[$i] . ")");
         }
         $block2->cellRow($listAttachments->mat_date[$i]);
         $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $statusFile[$idStatus], LINK_INSIDE));
         if ($sitePublish == "true") {
             $block2->cellRow($statusPublish[$idPublish]);

    $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);
        //--- name ----
        if ($idStatus == 1) {
            $block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_STRIKE), "99%");
        } else {
            $block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE), "99%");
        }
        //--- status ----
        $block10->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '">&nbsp;' . $status[$idStatus], '', true);
        //--- complete ----
        $block10->cellRow($complValue);

$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$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($listTeam->tea_mem_id[$i]);
    $block1->checkboxRow($listTeam->tea_mem_id[$i]);
    $block1->cellRow(buildLink("../users/viewuser.php?id=" . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], LINK_INSIDE));
    $block1->cellRow($listTeam->tea_mem_title[$i]);
    $block1->cellRow(buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], LINK_MAIL));
    $block1->cellRow($listTeam->tea_mem_phone_work[$i]);
    if ($listTeam->tea_log_connected[$i] > $dateunix - 5 * 60) {
        $block1->cellRow($strings["yes"] . " " . $z);
    } else {
        $block1->cellRow($strings["no"]);
    }
    if ($sitePublish == "true") {
        $block1->cellRow($statusPublish[$idPublish]);
    }
    $block1->closeRow();
}

$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]);
            $block2->cellRow($listMeetingTimes->mti_date[$i]);
            $block2->cellRow($listMeetingTimes->mti_hours[$i]);
            $block2->cellRow($listMeetingTimes->mti_created[$i]);
            $block2->cellRow($listMeetingTimes->mti_modified[$i]);
            // truncate large comments to keep the display clean
            $comments = $listMeetingTimes->mti_comments[$i];
            $lenComm = 40;
            if (strLen($comments) > $lenComm) {
                $comments = substr($listMeetingTimes->mti_comments[$i], 0, $lenComm) . ' ...';
            }
            $block2->cellRow($comments);
            $block2->closeRow();
        }

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;
        }
//.........这里部分代码省略.........

$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();
$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($listOrganizations->org_id[$i]);
        $block1->checkboxRow($listOrganizations->org_id[$i]);
        $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();
$block1->paletteScript(0, "add", "../clients/editclient.php?", "true,false,false", $strings["add"]);
$block1->paletteScript(1, "remove", "../clients/deleteclients.php?", "false,true,true", $strings["delete"]);
$block1->closePaletteScript($comptListOrganizations, $listOrganizations->org_id);

 $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();
 }
 echo '<input type="hidden" name="pid" value="' . $pid . '">';
 $block5->closeToggle();
 $block5->closeFormResults();

if ($comptListTasks != '0') {
    $block3->openResults();
    if (isset($flag_phases) && $flag_phases == true) {
        $block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $strings['published']), 'true');
    } else {
        $block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['assigned_to'], $strings['published']), 'true');
    }
    for ($i = 0; $i < $comptListTasks; $i++) {
        if ($listClosedTasks->tas_due_date[$i] == '') {
            $listClosedTasks->tas_due_date[$i] = $strings['none'];
        }
        $idStatus = $listClosedTasks->tas_status[$i];
        $idPriority = $listClosedTasks->tas_priority[$i];
        $idPublish = $listClosedTasks->tas_published[$i];
        $complValue = $listClosedTasks->tas_completion[$i] > 0 ? $listClosedTasks->tas_completion[$i] . '0 %' : $listClosedTasks->tas_completion[$i] . ' %';
        $block3->openRow($listClosedTasks->tas_id[$i]);
        $block3->checkboxRow($listClosedTasks->tas_id[$i]);
        //--- id ----
        #$block3->cellRow(buildLink("../tasks/viewtask.php?id=" . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_id[$i], LINK_INSIDE));
        //--- prio ---
        $block3->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true);
        //--- name ----
        if ($idStatus == 1 or $idStatus == 6) {
            $block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_STRIKE), "99%");
        } else {
            $block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_INSIDE), "99%");
        }
        //--- status ----
        $block3->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '">&nbsp;' . $status[$idStatus], '', true);
        //--- complete ----
        $block3->cellRow($complValue);

$tmpquery = "WHERE subtas.task = '{$id}' ORDER BY {$block4->sortingValue}";
$listSubtasks = new request();
$listSubtasks->openSubtasks($tmpquery);
$comptListSubtasks = count($listSubtasks->subtas_id);
if ($comptListSubtasks != "0") {
    $block4->openResults();
    $block4->labels($labels = array(0 => $strings["subtask"], 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 < $comptListSubtasks; $i++) {
        if ($listSubtasks->subtas_due_date[$i] == "") {
            $listSubtasks->subtas_due_date[$i] = $strings["none"];
        }
        $idStatus = $listSubtasks->subtas_status[$i];
        $idPriority = $listSubtasks->subtas_priority[$i];
        $idPublish = $listSubtasks->subtas_published[$i];
        $complValue = $listSubtasks->subtas_completion[$i] > 0 ? $listSubtasks->subtas_completion[$i] . "0 %" : $listSubtasks->subtas_completion[$i] . " %";
        $block4->openRow();
        $block4->checkboxRow($listSubtasks->subtas_id[$i]);
        $block4->cellRow($blockPage->buildLink("../subtasks/viewsubtask.php?id=" . $listSubtasks->subtas_id[$i] . "&task={$id}", $listSubtasks->subtas_name[$i], in));
        $block4->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);
        $block4->cellRow($status[$idStatus]);
        $block4->cellRow($complValue);
        if ($listSubtasks->subtas_due_date[$i] <= $date && $listSubtasks->subtas_completion[$i] != "10") {
            $block4->cellRow("<b>" . $listSubtasks->subtas_due_date[$i] . "</b>");
        } else {
            $block4->cellRow($listSubtasks->subtas_due_date[$i]);
        }
        if ($listSubtasks->subtas_start_date[$i] != "--" && $listSubtasks->subtas_due_date[$i] != "--") {
            $gantt = "true";
        }
        if ($listSubtasks->subtas_assigned_to[$i] == "0") {
            $block4->cellRow($strings["unassigned"]);

    } 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 ($comptListBookmarks != '0') {
    $block1->openResults();
    if ($view == 'my') {
        $block1->labels($labels = array(0 => $strings['name'], 1 => $strings['bookmark_category'], 2 => $strings['shared']), 'false');
    } else {
        $block1->labels($labels = array(0 => $strings['name'], 1 => $strings['bookmark_category'], 2 => $strings['owner']), 'false');
    }
    for ($i = 0; $i < $comptListBookmarks; $i++) {
        $block1->openRow($listBookmarks->boo_id[$i]);
        $block1->checkboxRow($listBookmarks->boo_id[$i]);
        $block1->cellRow(buildLink('../bookmarks/viewbookmark.php?view=' . $view . '&amp;id=' . $listBookmarks->boo_id[$i], $listBookmarks->boo_name[$i], LINK_INSIDE) . ' ' . buildLink($listBookmarks->boo_url[$i], '(' . $strings['url'] . ')', LINK_OUT));
        $block1->cellRow($listBookmarks->boo_boocat_name[$i]);
        if ($view == 'my') {
            if ($listBookmarks->boo_shared[$i] == '1') {
                $printShared = $strings['yes'];
            } else {
                $printShared = $strings['no'];
            }
            $block1->cellRow($printShared);
        } else {
            $block1->cellRow(buildLink($listBookmarks->boo_mem_email_work[$i], $listBookmarks->boo_mem_login[$i], LINK_MAIL));
        }
        $block1->closeRow();
    }

     $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;
                 }
             }
         }
         $block7->openRow();
         $block7->checkboxRow($listPhases->pha_id[$i]);
         $block7->cellRow($listPhases->pha_order_num[$i]);
         $block7->cellRow($blockPage->buildLink("../phases/viewphase.php?id=" . $listPhases->pha_id[$i], $listPhases->pha_name[$i], in));
         $block7->cellRow($comptlistTasksRow);
         $block7->cellRow($comptUncompleteTasks);
         $block7->cellRow($phaseStatus[$listPhases->pha_status[$i]]);
         $block7->cellRow($listPhases->pha_date_start[$i]);
         $block7->cellRow($listPhases->pha_date_end[$i]);
         $block7->closeRow();
     }
     $block7->closeResults();
 } else {
     $block7->noresults();
 }
 $block7->closeToggle();

$block1->heading($strings["service_management"]);
$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();
$tmpquery = "ORDER BY serv.name ASC";
$listServices = new request();
$listServices->openServices($tmpquery);
$comptListServices = count($listServices->serv_id);
if ($comptListServices != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["hourly_rate"]), "false", $sorting = "false", $sortingOff = array(0 => "0", 1 => "ASC"));
    for ($i = 0; $i < $comptListServices; $i++) {
        $block1->openRow($listServices->serv_id[$i]);
        $block1->checkboxRow($listServices->serv_id[$i]);
        $block1->cellRow(buildLink("../services/viewservice.php?id=" . $listServices->serv_id[$i], $listServices->serv_name[$i], LINK_INSIDE));
        $block1->cellRow($listServices->serv_hourly_rate[$i]);
        $block1->closeRow();
    }
    $block1->closeResults();
} else {
    $block1->noresults();
}
$block1->closeFormResults();
$block1->openPaletteScript();
$block1->paletteScript(0, "add", "../services/editservice.php?", "true,true,true", $strings["add"]);
$block1->paletteScript(1, "remove", "../services/deleteservices.php?", "false,true,true", $strings["delete"]);
$block1->paletteScript(2, "info", "../services/viewservice.php?", "false,true,false", $strings["view"]);
$block1->paletteScript(3, "edit", "../services/editservice.php?", "false,true,false", $strings["edit"]);

    }
}
$block1->recordsTotal = compt($initrequest['projects'] . ' ' . $tmpquery);
$listProjects = new request();
$listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListProjects = count($listProjects->pro_id);
if ($comptListProjects != 0) {
    $block1->openResults();
    $block1->labels($labels = array("P", $strings['project'], $strings['organization'], $strings['status'], $strings['owner'], $strings['project_site']), 'true');
    for ($i = 0; $i < $comptListProjects; $i++) {
        if ($listProjects->pro_org_id[$i] == 1) {
            $listProjects->pro_org_name[$i] = $strings['none'];
        }
        $idStatus = $listProjects->pro_status[$i];
        $idPriority = $listProjects->pro_priority[$i];
        $block1->openRow($listProjects->pro_id[$i]);
        $block1->checkboxRow($listProjects->pro_id[$i]);
        //--- id ---
        //$block1->cellRow(buildLink('../projects/viewproject.php?id=' . $listProjects->pro_id[$i], $listProjects->pro_id[$i], LINK_INSIDE));
        //--- prio ----
        $block1->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" title="' . $priority[$idPriority] . '">', "1", true);
        //--- name  ---
        $block1->cellRow(buildLink('../projects/viewproject.php?id=' . $listProjects->pro_id[$i], $listProjects->pro_name[$i], LINK_INSIDE), "30");
        //--- client ----
        $block1->cellRow($listProjects->pro_org_name[$i]);
        //--- status ---
        $block1->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '">&nbsp;' . $status[$idStatus], '', true);
        //--- owner ----
        $block1->cellRow(buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_login[$i], LINK_MAIL), false, true);
        //--- project-site ------
        if ($sitePublish == 'true') {

 $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]);
         $block1->checkboxRow($listCalendar->cal_id[$i]);
         $block1->cellRow(buildLink("../calendar/viewcalendar.php?{$dateEnreg}=" . $listCalendar->cal_id[$i] . "&amp;viewCalend={$viewCalend}&amp;type=calendDetail&amp;dateCalend={$dateCalend}", $listCalendar->cal_shortname[$i], LINK_INSIDE));
         $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?viewCalend={$viewCalend}&dateCalend={$dateCalend}&type=calendEdit", "true,false,false", $strings["add"]);
 $block1->paletteScript(1, "remove", "../calendar/deletecalendar.php?", "false,true,true", $strings["delete"]);