PHP block::labels方法代码示例

 $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();
 }

         $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";
         }
         $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;");

    $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);
        //--- name ----

$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->closeResults();
} else {
    $block1->noresults();
}
$block1->closeFormResults();
include '../themes/' . THEME . '/footer.php';

    $block1->paletteIcon(1, "edit", $strings["edit_status"]);
    $block1->paletteIcon(2, "remove", $strings["delete"]);
    $block1->paletteIcon(3, "info", $strings["view"]);
    $block1->closePaletteIcon();
}
$block1->sorting("support_requests", $sortingUser->sor_support_requests[0], "sr.id ASC", $sortingFields = array(0 => "sr.id", 1 => "sr.subject", 2 => "sr.priority", 3 => "sr.status", 4 => "sr.date_open", 5 => "sr.date_close"));
/*$tmpquery = "WHERE mem.id = '$idSession'";
$userDetail = new request();
$userDetail->openMembers($tmpquery);*/
$tmpquery = "WHERE sr.project = '{$id}' ORDER BY {$block1->sortingValue}";
$listRequests = new request();
$listRequests->openSupportRequests($tmpquery);
$comptListRequests = count($listRequests->sr_id);
if ($comptListRequests != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings["id"], 1 => $strings["subject"], 2 => $strings["priority"], 3 => $strings["status"], 4 => $strings["date_open"], 5 => $strings["date_close"]), "false");
    for ($i = 0; $i < $comptListRequests; $i++) {
        $comptSta = count($requestStatus);
        for ($sr = 0; $sr < $comptSta; $sr++) {
            if ($listRequests->sr_status[$i] == $sr) {
                $currentStatus = $requestStatus[$sr];
            }
        }
        $comptPri = count($priority);
        for ($rp = 0; $rp < $comptPri; $rp++) {
            if ($listRequests->sr_priority[$i] == $rp) {
                $requestPriority = $priority[$rp];
            }
        }
        $block1->openRow();
        $block1->checkboxRow($listRequests->sr_id[$i]);

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

 $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]);
         $blockProject->cellRow($listTasks->tas_due_date[$i]);

if ($view == "my") {
    $tmpquery = "WHERE boo.owner = '{$idSession}' ORDER BY {$block1->sortingValue}";
} else {
    if ($view == "private") {
        $tmpquery = "WHERE boo.users LIKE '%|{$idSession}|%' ORDER BY {$block1->sortingValue}";
    } else {
        $tmpquery = "WHERE boo.shared = '1' OR boo.owner = '{$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();
        $block1->checkboxRow($listBookmarks->boo_id[$i]);
        $block1->cellRow($blockPage->buildLink("../bookmarks/viewbookmark.php?view={$view}&id=" . $listBookmarks->boo_id[$i], $listBookmarks->boo_name[$i], in) . " " . $blockPage->buildLink($listBookmarks->boo_url[$i], "(" . $strings["url"] . ")", 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);

    $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']);
        }
    }
    $block3->closeResults();

    $block3->paletteIcon(0, "add", $strings["add"]);
    $block3->paletteIcon(1, "remove", $strings["delete"]);
}
$block3->paletteIcon(2, "info", $strings["view"]);
if ($profilSession == "0" || $profilSession == "1") {
    $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();
        $block3->checkboxRow($listMembers->mem_id[$i]);
        $block3->cellRow($blockPage->buildLink("../users/viewclientuser.php?id=" . $listMembers->mem_id[$i] . "&organization={$id}", $listMembers->mem_name[$i], in));
        $block3->cellRow($listMembers->mem_login[$i]);
        $block3->cellRow($blockPage->buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], 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"]);
        }
    }
    $block3->closeResults();

    }
}
$block1->paletteIcon(5, "info", $strings["view"]);
$block1->closePaletteIcon();
$block1->sorting("discussions", $sortingUser->sor_discussions[0], "topic.last_post DESC", $sortingFields = array(0 => "topic.subject", 1 => "mem.login", 2 => "topic.posts", 3 => "topic.last_post", 4 => "topic.status", 5 => "topic.published"));
if ($project != "") {
    $tmpquery = "WHERE topic.project = '{$project}' ORDER BY {$block1->sortingValue}";
} else {
    $tmpquery = "WHERE topic.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
}
$listTopics = new request();
$listTopics->openTopics($tmpquery);
$comptListTopics = count($listTopics->top_id);
if ($comptListTopics != "0") {
    $block1->openResults();
    $block1->labels($labels = array(0 => $strings["topic"], 1 => $strings["owner"], 2 => $strings["posts"], 3 => $strings["last_post"], 4 => $strings["status"], 5 => $strings["published"]), "true");
    for ($i = 0; $i < $comptListTopics; $i++) {
        $idStatus = $listTopics->top_status[$i];
        $idPublish = $listTopics->top_published[$i];
        $block1->openRow($listTopics->top_id[$i]);
        $block1->checkboxRow($listTopics->top_id[$i]);
        $block1->cellRow(buildLink("../topics/viewtopic.php?id=" . $listTopics->top_id[$i], $listTopics->top_subject[$i], LINK_INSIDE));
        $block1->cellRow(buildLink($listTopics->top_mem_email_work[$i], $listTopics->top_mem_login[$i], LINK_MAIL));
        $block1->cellRow($listTopics->top_posts[$i]);
        if ($listTopics->top_last_post[$i] > $_SESSION['lastvisiteSession']) {
            $block1->cellRow("<b>" . createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession']) . "</b>");
        } else {
            $block1->cellRow(createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession']));
        }
        $block1->cellRow($statusTopic[$idStatus]);
        if ($sitePublish == "true") {

        $tmpquery = "WHERE org.owner = '" . $_SESSION['idSession'] . "' AND org.id != '1' ORDER BY {$block1->sortingValue}";
    } else {
        $tmpquery = "WHERE org.id != '1' ORDER BY {$block1->sortingValue}";
    }
}
$block1->recordsTotal = compt($initrequest['organizations'] . ' ' . $tmpquery);
if ($listClients != 'false') {
    $listOrganizations = new request();
    $listOrganizations->openOrganizations($tmpquery, $block1->borne, $block1->rowsLimit);
    $comptListOrganizations = count($listOrganizations->org_id);
} else {
    $comptListOrganizations = 0;
}
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();
    $block1->bornesFooter("1", $blockPage->bornesNumber, "", "");
} else {
    $block1->noresults();
}
$block1->headingForm_close();
$block1->closeFormResults();

    $block6->paletteIcon(1, 'remove', $strings['delete']);
    // $block6->paletteIcon(2,'export',$strings['export']);
    if ($sitePublish == 'true') {
        $block6->paletteIcon(3, 'add_projectsite', $strings['add_project_site']);
        $block6->paletteIcon(4, 'remove_projectsite', $strings['remove_project_site']);
    }
}
$block6->paletteIcon(5, 'info', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
    $block6->paletteIcon(6, 'edit', $strings['edit']);
}
$block6->closePaletteIcon();
if ($comptListNotes != '0') {
    $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));
        if ($sitePublish == 'true') {
            $block6->cellRow($statusPublish[$idPublish]);

$block1->closePaletteScript("", "");
$block2 = new block();
$block2->form = "invoiceItems";
$block2->openForm("../invoicing/viewinvoice.php?id={$id}&" . session_name() . "=" . session_id() . "#" . $block2->form . "Anchor");
$block2->headingToggle($strings["invoice_items"]);
$block2->openPaletteIcon();
//$block2->paletteIcon(6,"info",$strings["view"]);
$block2->paletteIcon(7, "edit", $strings["edit"]);
$block2->closePaletteIcon();
$tmpquery = "WHERE invitem.invoice = '{$id}' AND invitem.active = '1' ORDER BY invitem.position ASC";
$listInvoicesItems = new request();
$listInvoicesItems->openInvoicesItems($tmpquery);
$comptListInvoicesItems = count($listInvoicesItems->invitem_id);
if ($comptListInvoicesItems != "0") {
    $block2->openResults();
    $block2->labels($labels = array(0 => $strings["position"], 1 => $strings["title"], 2 => $strings["rate_type"], 3 => $strings["rate_value"], 4 => $strings["amount_ex_tax"], 5 => $strings["completed"]), "false", $sorting = "false", $sortingOff = array(0 => "0", 1 => "ASC"));
    for ($i = 0; $i < $comptListInvoicesItems; $i++) {
        if ($listInvoicesItems->invitem_rate_type[$i] == "a") {
            $rate_type_value = "0";
        } else {
            if ($listInvoicesItems->invitem_rate_type[$i] == "b") {
                $rate_type_value = "1";
            } else {
                if ($listInvoicesItems->invitem_rate_type[$i] == "c") {
                    $rate_type_value = "2";
                } else {
                    if (is_numeric($listInvoicesItems->invitem_rate_type[$i])) {
                        $rate_type_value = "3";
                    }
                }
            }

 $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]);
         $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();