PHP block::openForm方法代码示例

$blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["clients"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/viewclient.php?id=" . $projectDetail->pro_org_id[0], $projectDetail->pro_org_name[0], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../invoicing/listinvoices.php?client=" . $projectDetail->pro_organization[0], $strings["invoices"], in));
if ($id != "") {
    $blockPage->itemBreadcrumbs($blockPage->buildLink("../invoicing/viewinvoice.php?id=" . $detailInvoice->inv_id[0], $detailInvoice->inv_id[0], in));
    $blockPage->itemBreadcrumbs($strings["edit_invoice"]);
}
$blockPage->closeBreadcrumbs();
if ($msg != "") {
    include '../includes/messages.php';
    $blockPage->messagebox($msgLabel);
}
$block1 = new block();
if ($id != "") {
    $block1->form = "invoice";
    $block1->openForm("../invoicing/editinvoice.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor");
}
if ($error != "") {
    $block1->headingError($strings["errors"]);
    $block1->contentError($error);
}
if ($id != "") {
    $block1->heading($strings["edit_invoice"] . " : " . $detailInvoice->inv_id[0]);
}
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["header_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"header_note\" cols=\"47\">{$header_note}</textarea>");
$block1->contentRow($strings["footer_note"], "<textarea rows=\"10\" style=\"width: 400px; height: 100px;\" name=\"footer_note\" cols=\"47\">{$footer_note}</textarea>");
$tmpquery = "WHERE invitem.invoice = '{$id}' AND invitem.active = '1' ORDER BY invitem.position ASC";
$listInvoicesItems = new request();
$listInvoicesItems->openInvoicesItems($tmpquery);

    }
}
echo '
	  </select></td>
	</tr>';
if ($ld == '') {
    $ld = $date;
}
$block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\"\r\n\tsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n\t<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>");
echo "\r\n\t<tr class='odd'>\r\n\t  <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n\t  <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t  <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n\t  <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t  <td valign='top' class='leftvalue'>&nbsp;</td>\r\n\t  <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n\t</tr>";
$block1->closeContent();
$block1->block_close();
$block1->closeForm();
$block2 = new block();
$block2->form = "ahT";
$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();

$projectDetail->openProjects($tmpquery);
$comptProjectDetail = count($projectDetail->pro_id);
if ($comptProjectDetail == "0") {
    headerFunction("../projects/listprojects.php?msg=blank&" . session_name() . "=" . session_id());
    exit;
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
$blockPage->itemBreadcrumbs($strings["team_members"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->form = "saM";
$block1->openForm("../teams/listusers.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block1->form . "Anchor");
$block1->heading($strings["team_members"]);
$block1->openPaletteIcon();
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == "5") {
    $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}";

                $idlist = explode('**', $_GET['id']);
                save_translation($_GET['language'], '', $idlist);
            } else {
                echo text('Internal_Error');
            }
            break;
    }
    $topblock->headingForm_close();
    $topblock->block_close();
    echo "<BR>";
}
$block1 = new block();
$block1->headingForm(text('administration'));
// Language Selection Form
$block1->form = "langsel";
$block1->openForm("../administration/edit_language.php?offset=" . $offset);
$block1->openContent();
$block1->contentTitle(text('language_intro'));
echo "<TR><TD ALIGN='center'>";
// build up language select list
asort($langValue);
reset($langValue);
$select = "";
foreach ($langValue as $key => $language) {
    $select .= "<option value='" . $key . "'" . ($sellang == $key ? " SELECTED" : "") . ">" . $language . "</option>";
}
echo text("Choose_Language") . ": <SELECT name='sellang' onChange='submit();'>" . $select . "</SELECT>";
echo "</TD></TR>";
$block1->closeContent();
$block1->closeForm();
// Label Add Form

}
$bodyCommand = "onLoad=\"document.assignment_commentForm.acomm.focus();\"";
include '../themes/' . THEME . '/header.php';
$tmpquery = "WHERE tas.id = '{$task}'";
$taskDetail = new request();
$taskDetail->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '" . $taskDetail->tas_project[0] . "'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/listtasks.php?project=" . $projectDetail->pro_id[0], $strings["tasks"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/viewtask.php?id=" . $taskDetail->tas_id[0], $taskDetail->tas_name[0], in));
$blockPage->itemBreadcrumbs($strings["assignment_comment"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->form = "assignment_comment";
$block1->openForm("../tasks/assignmentcomment.php?action=update&id={$id}&task={$task}&" . session_name() . "=" . session_id());
if ($error != "") {
    $block1->headingError($strings["errors"]);
    $block1->contentError($error);
}
$block1->heading($strings["assignment_comment"]);
$block1->openContent();
$block1->contentTitle($strings["assignment_comment_info"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["task"] . " :</td><td>" . $taskDetail->tas_name[0] . "</td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><input style=\"width: 400px;\" maxlength=\"128\" size=\"44\" name=\"acomm\"></input></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["save"] . "\"></td></tr>";
$block1->closeContent();
$block1->closeForm();
include '../themes/' . THEME . '/footer.php';

$tmpquery = "WHERE org.id = '{$id}'";
$clientDetail = new request();
$clientDetail->openOrganizations($tmpquery);
$comptClientDetail = count($clientDetail->org_id);
if ($comptClientDetail == "0") {
    header('Location: ../clients/listclients.php?msg=blankClient');
    exit;
}
//--- header ---
$breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["organizations"], LINK_INSIDE);
$breadcrumbs[] = $strings["organizations"];
//--- content ----
require_once "../themes/" . THEME . "/header.php";
$block1 = new block();
$block1->form = "ecD";
$block1->openForm("../projects/listprojects.php#" . $block1->form . "Anchor");
$block1->headingToggle($strings["organization"] . " : " . $clientDetail->org_name[0]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "remove", $strings["delete"]);
$block1->paletteIcon(1, "edit", $strings["edit"]);
$block1->closePaletteIcon();
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["name"], $clientDetail->org_name[0]);
$block1->contentRow($strings["address"], $clientDetail->org_address1[0]);
$block1->contentRow($strings["phone"], $clientDetail->org_phone[0]);
$block1->contentRow($strings["url"], buildLink($clientDetail->org_url[0], $clientDetail->org_url[0], LINK_OUT));
$block1->contentRow($strings["email"], buildLink($clientDetail->org_email[0], $clientDetail->org_email[0], LINK_MAIL));
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["comments"], nl2br($clientDetail->org_comments[0]));
$block1->contentRow($strings["created"], createDate($clientDetail->org_created[0], $_SESSION['timezoneSession']));

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

 * ../reports/selecthours.php
 * 
 * select options for report of hours logged
 * 
 * TODO:
 */
$checkSession = true;
require_once "../includes/library.php";
$breadcrumbs[] = $strings['reports'];
$breadcrumbs[] = buildLink('../reports/createreport.php?typeReports=create', $strings["create_report"], in) . ' | ' . buildLink('../reports/createreport.php?typeReports=custom', $strings['custom_reports'], LINK_INSIDE);
$pageSection = 'reports';
require_once "../themes/" . THEME . "/header.php";
// start the first block
$block1 = new block();
$block1->form = "xwbT";
$block1->openForm("../reports/hours.php#" . $block1->form . "Anchor");
$block1->openContent();
echo "<table>\n";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["loggedby"] . " :</td><td>";
if ($demoMode == true) {
    $tmpquery = "ORDER BY mem.name";
} else {
    $tmpquery = "WHERE mem.id != '2' ORDER BY mem.name";
}
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
echo "<select name=\"S_ATSEL[]\" size=\"4\" multiple><option selected value=\"ALL\">" . $strings["select_all"] . "</option><option value=\"0\">" . $strings["unassigned"] . "</option>";
for ($i = 0; $i < $comptListMembers; $i++) {
    echo "<option value=\"" . $listMembers->mem_id[$i] . "\">" . $listMembers->mem_login[$i];
    if ($listMembers->mem_profil[$i] == "3") {

    exit;
}
if ($action == "create") {
    $tmpquery = "UPDATE " . $tableCollab["projects"] . " SET published='0' WHERE id = '{$id}'";
    connectSql("{$tmpquery}");
    headerFunction("../projects/viewprojectsite.php?id={$id}&msg=createProjectSite&" . session_name() . "=" . session_id());
    exit;
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id={$id}", $projectDetail->pro_name[0], in));
$blockPage->itemBreadcrumbs($strings["create_projectsite"]);
$blockPage->closeBreadcrumbs();
$block1 = new block();
$block1->form = "csdD";
$block1->openForm("../projects/addprojectsite.php?action=create&id={$id}&" . session_name() . "=" . session_id());
$block1->heading($strings["create_projectsite"]);
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["project"], $blockPage->buildLink("../projects/viewproject.php?id={$id}", $projectDetail->pro_name[0], in));
if ($projectDetail->pro_org_id[0] == "1") {
    $block1->contentRow($strings["organization"], $strings["none"]);
} else {
    $block1->contentRow($strings["organization"], $blockPage->buildLink("../clients/viewclient.php?id=" . $projectDetail->pro_org_id[0], $projectDetail->pro_org_name[0], in));
}
$block1->contentRow("", "<input type=\"SUBMIT\" value=\"" . $strings["create"] . "\">");
$block1->closeContent();
$block1->closeForm();
include '../themes/' . THEME . '/footer.php';

    exit;
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["clients"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/viewclient.php?id=" . $detailOrganization->org_id[0], $detailOrganization->org_name[0], in));
$blockPage->itemBreadcrumbs($strings["delete_users"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
    include '../includes/messages.php';
    $blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->form = "client_user_delete";
$block1->openForm("../users/deleteclientusers.php?organization={$organization}&action=delete&" . session_name() . "=" . session_id());
$block1->heading($strings["delete_users"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE mem.id IN({$id}) ORDER BY mem.name";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
for ($i = 0; $i < $comptListMembers; $i++) {
    echo "<tr class='odd'><td valign='top' class='leftvalue'>&nbsp;</td><td>" . $listMembers->mem_login[$i] . "&nbsp;(" . $listMembers->mem_name[$i] . ")</td></tr>";
}
$tmpquery = "SELECT tas.id FROM " . $tableCollab["tasks"] . " tas WHERE tas.assigned_to IN({$id})";
compt($tmpquery);
$totalTasks = $countEnregTotal;
$block1->contentTitle($strings["reassignment_clientuser"]);

        $organization = "";
        require_once "../teams/noti_removeprojectteam.php";
    }
    header("Location: ../projects/viewprojectsite.php?id={$project}&msg=removeClientToSite");
    exit;
}
//--- header ---
$breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewprojectsite.php?id=" . $projectDetail->pro_id[0], $strings["project_site"], LINK_INSIDE);
$breadcrumbs[] = $strings["remove_team_client"];
require_once "../themes/" . THEME . "/header.php";
//--- content ----
$block1 = new block();
$block1->form = "crM";
$block1->openForm("../teams/deleteclientusers.php?project={$project}&action=delete&id={$id}");
$block1->headingForm($strings["remove_team_client"]);
$block1->openContent();
$block1->contentTitle($strings["remove_team_info"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE mem.id IN({$id}) ORDER BY mem.name";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
for ($i = 0; $i < $comptListMembers; $i++) {
    $block1->contentRow("#" . $listMembers->mem_id[$i], $listMembers->mem_login[$i] . " (" . $listMembers->mem_name[$i] . ")");
}
$block1->contentRow("", "<input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\">&#160;<input type=\"BUTTON\" value=\"" . $strings["remove"] . "\" onClick=\"history.back();\">");
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();

        if ($comptHolidayList != "0") {
            #reschedule($holidayList->hol_date[0]);
        }
        $msg = 'delete';
    }
}
$breadcrumbs[] = buildLink('../administration/admin.php', $strings['administration'], LINK_INSIDE);
$breadcrumbs[] = $strings['holidays'];
$pageSection = 'admin';
require_once '../themes/' . THEME . '/header.php';
//--- content -----
$block1 = new block();
$block1->headingForm($strings['new_holiday']);
$block1->openContent();
$block1->form = 'hoT';
$block1->openForm("../administration/listholidays.php?action=add&d=" . $d . "&c=" . $c . "#" . $block1->form . "Anchor");
$block1->contentRow($strings["date"], "<input type=\"text\" style=\"width: 150px;\" name=\"d\" id=\"sel1\" size=\"20\" value=\"{$sd}\"><button type=\"reset\" id=\"trigger_a\">...</button><script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>");
$block1->contentRow($strings["comments"], "<textarea rows=\"10\" style=\"width: 400px; height: 160px;\" name=\"c\" cols=\"47\">{$c}</textarea>");
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td><input type=\"SUBMIT\" value=\"" . $strings["save"] . "\"></td></tr>";
$block1->closeContent();
$block1->heading($strings["holidays"]);
$block1->openPaletteIcon();
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$tmpquery = " ORDER BY hol.date DESC";
$holidayList = new request();
$holidayList->openHoliday($tmpquery);
$comptHolidayList = count($holidayList->hol_id);
$block1->recordsTotal = $comptHolidayList;
if ($comptHolidayList > 0) {
    $block1->openResults();

            $mail->AddAddress($userDetail->mem_email_work[0], $userDetail->mem_name[0]);
            $mail->Send();
            $mail->ClearAddresses();
            // redirect to login page with message
            header('Location: ../general/login.php?msg=emailpwd');
            exit;
        } else {
            $error = $strings['no_email'];
        }
    }
    $send = 'on';
}
$notLogged = true;
$bodyCommand = 'onLoad="document.sendForm.loginForm.focus();"';
require_once '../themes/' . THEME . '/header.php';
$block1 = new block();
$block1->form = 'send';
$block1->openForm('../general/sendpassword.php?action=send');
if ($error != '') {
    $block1->headingError($strings['errors']);
    $block1->contentError($error);
}
$block1->headingForm('NetOffice : ' . $strings['password']);
$block1->openContent();
$block1->contentTitle($strings['enter_login']);
$block1->contentRow('* ' . $strings['user_name'], '<input style="width: 125px" maxlength="16" size="16" value="' . $loginForm . '" type="text" name="loginForm">');
$block1->contentRow('', '<input type="submit" name="send" value="' . $strings['send'] . '">');
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once '../themes/' . THEME . '/footer.php';

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

$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
$tmpquery = "WHERE mee.id = '{$meeting}'";
$meetingDetail = new request();
$meetingDetail->openMeetings($tmpquery);
//--- header ----
$breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], LINK_INSIDE);
$breadcrumbs[] = buildLink("../meetings/listmeetings.php?project=" . $projectDetail->pro_id[0], $strings["meetings"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../meetings/viewmeeting.php?id=" . $meetingDetail->mee_id[0], $meetingDetail->mee_name[0], LINK_INSIDE);
$breadcrumbs[] = $strings["unlink_files"];
require_once "../themes/" . THEME . "/header.php";
//--- content ----
$block1 = new block();
$block1->form = "saC";
$block1->openForm("../meetings/deletefiles.php?project={$project}&meeting={$meeting}&action=delete&id={$id}&sendto={$sendto}");
$block1->headingForm($strings["unlink_files"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE mat.id IN({$id}) ORDER BY mat.name";
$listFiles = new request();
$listFiles->openMeetingsAttachment($tmpquery);
$comptListFiles = count($listFiles->mat_id);
for ($i = 0; $i < $comptListFiles; $i++) {
    echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td>" . $listFiles->mat_name[$i] . "</td></tr>";
}
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td><input type=\"SUBMIT\" value=\"" . $strings["delete"] . "\">&#160;<input type=\"BUTTON\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\"></td></tr>";
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();