PHP request::openMembers方法代码示例

 function getUserinfo($idUser, $type)
 {
     $tmpquery = "WHERE mem.id = '{$idUser}'";
     $detailUser = new request();
     $detailUser->openMembers($tmpquery);
     if ($type == "from") {
         $this->From = $detailUser->mem_email_work[0];
         $this->FromName = $detailUser->mem_name[0];
     }
     if ($type == 'to') {
         $this->AddAddress($detailUser->mem_email_work[0], $detailUser->mem_name[0]);
     }
 }

        } else {
            $body .= "{$root}/general/login.php?url=support/viewrequest.php%3Fid={$num} \n\n";
        }
        if ($listTeam->tea_mem_email_work[$i] != "") {
            $mail->Subject = $subject;
            $mail->Priority = "3";
            $mail->Body = $body;
            $mail->AddAddress($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_name[$i]);
            $mail->Send();
            $mail->ClearAddresses();
        }
    }
} else {
    $tmpquery = "WHERE mem.id = '1'";
    $userDetail = new request();
    $userDetail->openMembers($tmpquery);
    if ($userDetail->mem_email_work[0] != "") {
        $mail->partSubject = $strings["support"] . " " . $strings["support_id"];
        $mail->partMessage = $strings["noti_support_request_new2"];
        $subject = $mail->partSubject . ": " . $requestDetail->sr_id[0];
        $body = $mail->partMessage . "";
        $body .= "" . $requestDetail->sr_subject[0] . "";
        $body .= "\n\n" . $strings["id"] . " : " . $requestDetail->sr_id[0] . "\n" . $strings["subject"] . " : " . $requestDetail->sr_subject[0] . "\n" . $strings["status"] . " : " . $requestStatus[$requestDetail->sr_status[0]] . "\n" . $strings["details"] . " : ";
        $body .= "{$root}/general/login.php?url=support/viewrequest.php%3Fid={$num} \n\n";
        $mail->Subject = $subject;
        $mail->Priority = "3";
        $mail->Body = $body;
        $mail->AddAddress($userDetail->mem_email_work[0], $userDetail->mem_name[0]);
        $mail->Send();
        $mail->ClearAddresses();
    }

$block1->contentRow($strings["me_agenda"], nl2br($meetingDetail->mee_agenda[0]));
$block1->contentRow($strings["me_location"], nl2br($meetingDetail->mee_location[0]));
if ($meetingDetail->mee_chairman_login[0] == "") {
    $block1->contentRow($strings["me_chairman"], "");
} else {
    $block1->contentRow($strings["me_chairman"], buildLink('../users/viewuser.php?id=' . $meetingDetail->mee_chairman[0], $meetingDetail->mee_chairman_name[0], LINK_INSIDE) . ' (' . buildLink($meetingDetail->mee_chairman_email[0], $meetingDetail->mee_chairman_login[0], LINK_MAIL) . ')');
}
for ($i = 0; $i < $comptAttendantDetail; $i++) {
    if ($i == 0) {
        $column1 = $strings["attendants"];
    } else {
        $column1 = "";
    }
    $tmpquery = "WHERE mem.organization = '" . $projectDetail->pro_org_id[0] . "' AND mem.profil = '3' AND mem.id = '" . $attendantDetail->att_mem_id[$i] . "'";
    $clientMem = new request();
    $clientMem->openMembers($tmpquery);
    $column2 = $attendantDetail->att_mem_login[$i] . " / " . $attendantDetail->att_mem_name[$i];
    if (count($clientMem->mem_id) != 0) {
        $column2 .= " (" . $strings["client_user"] . ")";
    }
    $block1->contentRow($column1, $column2);
}
if ($meetingDetail->mee_recorder_login[0] == "") {
    $block1->contentRow($strings["me_recorder"], "");
} else {
    $block1->contentRow($strings["me_recorder"], buildLink('../users/viewuser.php?id=' . $meetingDetail->mee_recorder[0], $meetingDetail->mee_recorder_name[0], LINK_INSIDE) . ' (' . buildLink($meetingDetail->mee_recorder_email[0], $meetingDetail->mee_recorder_login[0], LINK_MAIL) . ')');
}
$block1->contentRow($strings["me_minutes"], nl2br($meetingDetail->mee_minutes[0]));
$block1->contentRow($strings['ical_url'], buildLink("{$root}/calendar/icalendar.php", "{$root}/calendar/icalendar.php", LINK_OUT));
if ($sitePublish == "true") {
    $block1->contentRow($strings["published"], $statusPublish[$idPublish]);

    header("Location: ../general/home.php?msg=permissiondenied");
    exit;
}
$tmpquery = "WHERE org.id = '{$organization}'";
$clientDetail = new request();
$clientDetail->openOrganizations($tmpquery);
$comptClientDetail = count($clientDetail->org_id);
// case add client user
// test if login already exists
if ($action == "add") {
    if (!ereg("^[A-Za-z0-9]+\$", $un)) {
        $error = $strings["alpha_only"];
    } else {
        $tmpquery = "WHERE mem.login = '{$un}'";
        $existsUser = new request();
        $existsUser->openMembers($tmpquery);
        $comptExistsUser = count($existsUser->mem_id);
        if ($comptExistsUser != "0") {
            $error = $strings["user_already_exists"];
        } else {
            // test if 2 passwords match
            if ($pw != $pwa || $pw == "") {
                $error = $strings["new_password_error"];
            } else {
                // replace quotes by html code in name and address
                $fn = convertData($fn);
                $tit = convertData($tit);
                $c = convertData($c);
                $pw = get_password($pw);
                $tmpquery1 = "INSERT INTO " . $tableCollab["members"] . "(organization,login,name,title,email_work,phone_work,phone_home,mobile,fax,comments,password,profil,created,timezone) VALUES('{$clod}','{$un}','{$fn}','{$tit}','{$em}','{$wp}','{$hp}','{$mp}','{$fax}','{$c}','{$pw}','3','{$dateheure}','0')";
                connectSql("{$tmpquery1}");

$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 pro.id FROM " . $tableCollab["projects"] . " pro WHERE pro.owner IN({$id})";
compt($tmpquery);
$totalProjects = $countEnregTotal;
$tmpquery = "SELECT tas.id FROM " . $tableCollab["tasks"] . " tas WHERE tas.assigned_to IN({$id})";
compt($tmpquery);
$totalTasks = $countEnregTotal;
$block1->contentTitle($strings["reassignment_user"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td>" . $strings["there"] . " {$totalProjects} " . $strings["projects"] . " " . $strings["owned_by"] . "</td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td>" . $strings["there"] . " {$totalTasks} " . $strings["tasks"] . " " . $strings["owned_by"] . "</td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td><b>" . $strings["reassign_to"] . " : </b> ";
$tmpquery = "WHERE mem.profil != '3' AND mem.id NOT IN({$id}) ORDER BY mem.name";
$reassign = new request();
$reassign->openMembers($tmpquery);
$comptReassign = count($reassign->mem_id);
echo "<select name=\"at\">\r\n<option value=\"0\" selected>" . $strings["unassigned"] . "</option>";
for ($i = 0; $i < $comptReassign; $i++) {
    echo "<option value=\"" . $reassign->mem_id[$i] . "\">" . $reassign->mem_login[$i] . " / " . $reassign->mem_name[$i] . "</option>";
}
echo "</select></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td><input type=\"submit\" name=\"delete\" value=\"" . $strings["delete"] . "\"> <input type=\"button\" name=\"cancel\" value=\"" . $strings["cancel"] . "\" onClick=\"history.back();\"><input type=\"hidden\" value=\"{$id}\" name=\"id\"></td></tr>";
$block1->closeContent();
$block1->headingForm_close();
$block1->closeForm();
require_once "../themes/" . THEME . "/footer.php";

$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") {
        echo " (" . $strings["client_user"] . ")";
    }
    echo "</option>";
}
echo "</select></td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["organization"] . ":</td><td>";
$listOrganizations = new request();
$listOrganizations->openOrganizations("");
$comptListOrganizations = count($listOrganizations->org_id);
echo "<select name=\"S_ORSEL[]\"><option selected value=\"ALL\">" . $strings["select_all"] . "</option>";

$comptPri = count($priority);
for ($i = 0; $i < $comptPri; $i++) {
    if ($projectDetail->pro_priority[0] == $i) {
        echo '<option value="' . $i . '" selected>' . $priority[$i] . '</option>';
    } else {
        echo '<option value="' . $i . '">' . $priority[$i] . '</option>';
    }
}
echo "</select></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['description'] . " :</td><td><textarea rows=\"10\" style=\"width: 400px; height: 160px;\" name=\"d\" cols=\"47\">{$d}</textarea></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['url_dev'] . " :</td><td><input size=\"44\" value=\"{$url_dev}\" style=\"width: 400px\" name=\"url_dev\" maxlength=\"100\" type=\"text\"></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['url_prod'] . " :</td><td><input size=\"44\" value=\"{$url_prod}\" style=\"width: 400px\" name=\"url_prod\" maxlength=\"100\" type=\"text\"></td></tr>\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings['owner'] . " :</td><td><select name=\"pown\">";
if ($demoMode == true) {
    $tmpquery = "WHERE (mem.profil = '1' OR mem.profil = '0' OR mem.profil = '5') ORDER BY mem.name";
} else {
    $tmpquery = "WHERE (mem.profil = '1' OR mem.profil = '0' OR mem.profil = '5') AND mem.id != '2' ORDER BY mem.name";
}
$assignOwner = new request();
$assignOwner->openMembers($tmpquery);
$comptAssignOwner = count($assignOwner->mem_id);
for ($i = 0; $i < $comptAssignOwner; $i++) {
    if ($projectDetail->pro_mem_id[0] == $assignOwner->mem_id[$i]) {
        echo '<option value="' . $assignOwner->mem_id[$i] . '" selected>' . $assignOwner->mem_login[$i] . ' / ' . $assignOwner->mem_name[$i] . '</option>';
    } else {
        echo '<option value="' . $assignOwner->mem_id[$i] . '">' . $assignOwner->mem_login[$i] . ' / ' . $assignOwner->mem_name[$i] . '</option>';
    }
}
echo '</select></td></tr>
<tr class="odd"><td valign="top" class="leftvalue">' . $strings['organization'] . ' :</td><td><select name="clod">';
if ($clientsFilter == 'true' && $_SESSION['profilSession'] == '1') {
    $tmpquery = "WHERE org.owner = '" . $_SESSION['idSession'] . "' AND org.id != '1' ORDER BY org.name";
} else {
    $tmpquery = "WHERE org.id != '1' ORDER BY org.name";
}

    //	echo "$tmpquery<br>";
}
$block3 = new block();
$block3->borne = $blockPage->returnBorne("3");
$block3->rowsLimit = "10";
$block3->sorting("users", $sortingUser->sor_users[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.login", 2 => "mem.email_work", 3 => "mem.phone_work", 4 => "log.connected"));
if ($demoMode == true) {
    $tmpquery = "{$searchMembers} ) ORDER BY {$block3->sortingValue}";
} else {
    $tmpquery = "{$searchMembers} ) AND mem.id != '2' ORDER BY {$block3->sortingValue}";
}
$comptListMembers = "0";
if ($validMembers == "true") {
    $block3->recordsTotal = compt($initrequest["members"] . " " . $tmpquery);
    $listMembers = new request();
    $listMembers->openMembers($tmpquery, $block3->borne, $block3->rowsLimit);
    $comptListMembers = count($listMembers->mem_id);
    // echo "$tmpquery<br>";
}
$block4 = new block();
$block4->borne = $blockPage->returnBorne("4");
$block4->rowsLimit = "10";
$block4->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.url", 2 => "org.phone"));
if ($clientsFilter == "true" && $_SESSION['profilSession'] == "2") {
    $teamMember = "false";
    $tmpquery = "WHERE tea.member = '" . $_SESSION['idSession'] . "'";
    $memberTest = new request();
    $memberTest->openTeams($tmpquery);
    $comptMemberTest = count($memberTest->tea_id);
    if ($comptMemberTest == "0") {
        $listClients = "false";

 if ($id == "") {
     echo "\t<a name='" . $block1->form . "Anchor'></a>\n <form accept-charset='UNKNOWN' method='POST' action='../newsdesk/editnews.php?action=add&" . session_name() . "=" . session_id() . "' name='ecDForm'>\n";
     $block1->heading($strings["add_newsdesk"]);
 } else {
     echo "\t<a name='" . $block1->form . "Anchor'></a>\n <form accept-charset='UNKNOWN' method='POST' action='../newsdesk/editnews.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "' name='ecDForm'>\n";
     $block1->heading($strings["edit_newsdesk"] . " : " . $newsDetail->news_title[0]);
 }
 $block1->openContent();
 $block1->contentTitle($strings["details"]);
 // add
 if ($id == "") {
     $block1->contentRow($strings["author"], "<input type='hidden' name='author' value='{$idSession}'><b>{$nameSession}</b>");
 } else {
     $tmpquery_user = "WHERE mem.id = '" . $newsDetail->news_author[0] . "' ";
     $newsAuthor = new request();
     $newsAuthor->openMembers($tmpquery_user);
     $block1->contentRow($strings["author"], "<input type='hidden' name='author' value='" . $newsDetail->news_author[0] . "'><b>" . $newsAuthor->mem_name[0] . "</b>");
 }
 $block1->contentRow($strings["title"], "<input type='text' name='title' value='{$title}' style='width: 300px;'>");
 // 04/11/2003 related news by fullo
 // admin can post news on all projects
 if ($profilSession == "0") {
     if ($databaseType == "postgresql") {
         $tmpquery = " GROUP BY pro.id, pro.name, tea.id";
     } else {
         $tmpquery = "  GROUP BY pro.id ";
     }
 } else {
     if ($databaseType == "postgresql") {
         $tmpquery = "AND tea.member = '{$idSession}' OR pro.id = '0' GROUP BY pro.id, pro.name, tea.id";
     } else {

$tasks->openTasks($tmpquery);
$comptTasks = count($tasks->tas_id);
echo "\n\t<tr class='odd'>\n\t  <td valign='top' class='leftvalue'>" . $strings['tasks'] . " :</td>\n\t  <td><select name='task_id'>";
// get Clients listing
for ($i = 0; $i < $comptTasks; $i++) {
    $selected = "";
    if ($task_id == $tasks->tas_id[$i]) {
        $selected = " selected";
    }
    echo "<option value='" . $tasks->tas_id[$i] . "'" . $selected . ">" . $tasks->tas_name[$i] . "</option>";
}
//*** Travailleur ***
$tmpquery = " WHERE mem.profil != 3 AND mem.profil!= 0";
$tmpquery .= " ORDER BY mem.name";
$projmem = new request();
$projmem->openMembers($tmpquery);
$comptProjmem = count($projmem->mem_id);
echo "\n\t<tr class='odd'>\n\t  <td valign='top' class='leftvalue'>" . $strings['assigned'] . " :</td>\n\t  <td>";
//Seulement pour Admin et Assistant
//	if(false) {
if (loggedUserIsAdmin() || loggedUserIsAssistant()) {
    echo "<select name='worker_id'>";
    //get project team listing for owner select lists, default to logged user
    for ($i = 0; $i < $comptProjmem; $i++) {
        $selected = "";
        if ($worker_id == $projmem->mem_id[$i] || $worker_id == 0 && $_SESSION['idSession'] == $projmem->mem_id[$i]) {
            $selected = " selected";
        }
        echo "<option value='" . $projmem->mem_id[$i] . "'" . $selected . ">" . $projmem->mem_name[$i] . "{$clientUser}</option>";
    }
    echo "</select>" . "</td></tr>";

 if ($loginCookie != '' && $passwordCookie != '' && $tokenCookie != '') {
     $loginForm = $loginCookie;
 }
 // query in members table (demo user not listed if demo mode false,
 // to prohibit the access)
 if ($demoMode != true) {
     if ($ssl) {
         $tmpquery = "WHERE mem.email_work = '{$ssl_email}' AND mem.login != 'demo' AND mem.profil != '4'";
     } else {
         $tmpquery = "WHERE mem.login = '{$loginForm}' AND mem.login != 'demo' AND mem.profil != '4'";
     }
 } else {
     $tmpquery = "WHERE mem.login = '{$loginForm}' AND mem.profil != '4'";
 }
 $loginUser = new request();
 $loginUser->openMembers($tmpquery);
 $comptLoginUser = count($loginUser->mem_id);
 // test if user exits
 if ($comptLoginUser == '0') {
     $error = $strings['invalid_login'];
     setcookie('NetOfficeAuthCookie', '', time() - 3600, $base_uri);
 } else {
     // test password
     if ($loginCookie != '' && $passwordCookie != '' && $tokenCookie != '') {
         if (!$ssl && $passwordCookie != $loginUser->mem_password[0]) {
             $error = $strings['invalid_login'];
             setcookie('NetOfficeAuthCookie', '', time() - 3600, $base_uri);
         } else {
             // password passed, now test token
             if (!$ssl && $tokenCookie != md5($loginCookie . $cryptKey)) {
                 $error = $strings['invalid_login'];

    // save to the session
    $_SESSION['logouttimeSession'] = $logout_time;
    $_SESSION['timezoneSession'] = $tz;
    $_SESSION['dateunixSession'] = date("U");
    $_SESSION['nameSession'] = $fn;
    // if mantis bug tracker enabled
    if ($enableMantis == "true") {
        // Call mantis function for user profile changes..!!!
        require_once "../mantis/user_profile.php";
    }
    header("Location: ../preferences/updateuser.php?msg=update");
    exit;
}
$tmpquery = "WHERE mem.id = '" . $_SESSION['idSession'] . "'";
$userPrefs = new request();
$userPrefs->openMembers($tmpquery);
$comptUserPrefs = count($userPrefs->mem_id);
if ($comptUserPrefs == "0") {
    header("Location: ../users/listusers.php?msg=blankUser");
    exit;
}
//--- header ---
$breadcrumbs[] = $strings["preferences"];
if ($notifications == "true") {
    $breadcrumbs[] = $strings["user_profile"] . "  |  " . buildLink("../preferences/updatepassword.php?", $strings["change_password"], LINK_INSIDE) . "  |  " . buildLink("../preferences/updatenotifications.php?", $strings["notifications"], LINK_INSIDE);
} else {
    $breadcrumbs[] = $strings["user_profile"] . "  |  " . buildLink("../preferences/updatepassword.php?", $strings["change_password"], LINK_INSIDE);
}
$bodyCommand = "onLoad=\"document.user_edit_profileForm.fn.focus();\"";
$pageSection = 'preferences';
require_once "../themes/" . THEME . "/header.php";

    $block1->headingError($strings["errors"]);
    $block1->contentError($error);
}
if ($id == "") {
    $block1->heading($strings["add_organization"]);
}
if ($id != "") {
    $block1->heading($strings["edit_organization"] . " : " . $clientDetail->org_name[0]);
}
$block1->openContent();
$block1->contentTitle($strings["details"]);
if ($clientsFilter == "true") {
    $selectOwner = "<select name='cown'>";
    $tmpquery = "WHERE (mem.profil = '1' OR mem.profil = '0') AND mem.login != 'demo' ORDER BY mem.name";
    $clientOwner = new request();
    $clientOwner->openMembers($tmpquery);
    $comptClientOwner = count($clientOwner->mem_id);
    for ($i = 0; $i < $comptClientOwner; $i++) {
        if ($clientDetail->org_owner[0] == $clientOwner->mem_id[$i] || $idSession == $clientOwner->mem_id[$i]) {
            $selectOwner .= "<option value='" . $clientOwner->mem_id[$i] . "' selected>" . $clientOwner->mem_login[$i] . " / " . $clientOwner->mem_name[$i] . "</option>";
        } else {
            $selectOwner .= "<option value='" . $clientOwner->mem_id[$i] . "'>" . $clientOwner->mem_login[$i] . " / " . $clientOwner->mem_name[$i] . "</option>";
        }
    }
    $selectOwner .= "</select>";
    $block1->contentRow($strings["owner"], $selectOwner);
}
$block1->contentRow("* " . $strings["name"], "<input size='44' value='{$cn}' style='width: 400px' name='cn' maxlength='100' type='TEXT' />");
$block1->contentRow($strings["address"], "<textarea rows='3' style='width: 400px; height: 50px;' name='add' cols='43'>{$add}</textarea>");
$block1->contentRow($strings["phone"], "<input size='32' value='{$client_phone}' style='width: 250px' name='client_phone' maxlength='32' type='TEXT' />");
$block1->contentRow($strings["url"], "<input size='44' value='{$url}' style='width: 400px' name='url' maxlength='2000' type='TEXT' />");

echo "</select></td></tr>";
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["organization"] . " :</td><td>" . $projectDetail->pro_org_name[0] . "</td></tr>";
$block1->contentTitle($strings["details"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["name"] . " :</td><td><input size=\"44\" value=\"";
if ($cpy == "true") {
    echo $strings["copy_of"];
}
echo "{$mn}\" style=\"width: 400px\" name=\"mn\" maxlength=\"100\" type=\"TEXT\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["me_agenda"] . " :</td><td><textarea rows=\"4\" style=\"width: 400px; height: 64px;\" name=\"ma\" cols=\"47\">{$ma}</textarea></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["me_location"] . " :</td><td><textarea rows=\"2\" style=\"width: 400px; height: 32px;\" name=\"ml\" cols=\"47\">{$ml}</textarea></td></tr>";
$tmpquery = "WHERE tea.project = '{$project}' AND mem.profil != '3'";
$listTeam = new request();
$listTeam->openTeams($tmpquery);
$comptListTeam = count($listTeam->tea_id);
if ($projectDetail->pro_org_id[0] != "1") {
    $tmpquery = "WHERE mem.organization = '" . $projectDetail->pro_org_id[0] . "' AND mem.profil = '3'";
    $listClientMem = new request();
    $listClientMem->openMembers($tmpquery);
    $comptListClientMem = count($listClientMem->mem_id);
} else {
    $comptListClientMem = "0";
}
$comptListSum = $comptListTeam + $comptListClientMem;
if ($comptListSum != "0") {
    echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["me_chairman"] . " :</td><td><select name=\"S_CSEL[]\">";
    for ($i = 0; $i < $comptListTeam; $i++) {
        echo "<option value=\"" . $listTeam->tea_mem_id[$i] . "\"";
        if ($id != "") {
            if ($listTeam->tea_mem_id[$i] == $mc) {
                echo " selected";
            }
        } else {
            if ($listTeam->tea_mem_id[$i] == $_SESSION['idSession']) {

$block1->form = "batT";
$block1->openForm("../tasks/updatetasks.php?action=update&" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor");
if ($error != "") {
    $block1->headingError($strings["errors"]);
    $block1->contentError($error);
}
$block1->heading($strings["edit_multiple_tasks"]);
$block1->openContent();
$block1->contentTitle($strings["details"]);
echo "\t<tr class='odd'>\n\t\t\t<td valign='top' class='leftvalue'>&nbsp;</td>\n\t\t\t<td>{$comptListTasks} " . $strings["tasks_selected"] . "</td>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td valign='top' class='leftvalue'>" . $strings["assigned_to"] . "</td>\n\t\t\t<td>\n\t\t\t\t<select name='at'>\n\t\t\t\t\t<option value='" . $strings["no_change"] . "' selected>" . $strings["no_change"] . " :</option>\n\t\t\t\t\t<option value='0'>" . $strings["unassigned"] . "</option>";
if ($idSession == "1") {
    echo "<option value='1'>" . $strings["administrator"] . "</option>";
}
$tmpquery = "WHERE mem.id != '1' AND mem.profil != '3' ORDER BY mem.name";
$assignTo = new request();
$assignTo->openMembers($tmpquery);
$comptAssignTo = count($assignTo->mem_id);
for ($i = 0; $i < $comptAssignTo; $i++) {
    echo "<option value='" . $assignTo->mem_id[$i] . "'>" . $assignTo->mem_name[$i] . "</option>";
}
echo "\t\t</select></td>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td valign='top' class='leftvalue'>" . $strings["assignment_comment"] . " :</td>\n\t\t\t<td><textarea rows='3' style='width: 400px; height: 50px;' name='acomm' cols='43'></textarea></td>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td valign='top' class='leftvalue'>" . $strings["status"] . " :</td>\n\t\t\t<td><select name='st' onchange='changeSt(this)'>\n\t\t\t\t<option value='" . $strings["no_change"] . "' selected>" . $strings["no_change"] . "</option>";
$comptSta = count($status);
for ($i = 0; $i < $comptSta; $i++) {
    echo "<option value='{$i}'>{$status[$i]}</option>";
}
echo "\t\t</select></td>\n\t\t</tr>\n\t\t<tr class='odd'>\n\t\t\t<td valign='top' class='leftvalue'>" . $strings["completion"] . " :</td>\n\t\t\t<td><input name='compl' type='hidden' value=''>\n\t\t\t\t<select name='completion' onchange='changeCompletion(this)'>\n\t\t\t\t\t<option value='" . $strings["no_change"] . "' selected>" . $strings["no_change"] . "</option>";
for ($i = 0; $i < 11; $i++) {
    $complValue = $i > 0 ? $i . "0 %" : $i . " %";
    echo "<option value='" . $i . "'>" . $complValue . "</option>";
}
echo "</select></td></tr>\n<tr class='odd'>\n\t<td valign='top' class='leftvalue'>" . $strings["priority"] . " : </td>\n\t<td><select name='pr'>\n\t\t\t<option value='" . $strings["no_change"] . "' selected>" . $strings["no_change"] . "</option>";