PHP request::openProjects方法代码示例

 function taskNotification($pAssigneeID, $pTaskID, $pTypeOfChange)
 {
     if ($num == '') {
         $num = $id;
     }
     $tmpquery = "WHERE tas.id IN({$pTaskID})";
     $taskNoti = new request();
     $taskNoti->openTasks($tmpquery);
     $tmpquery = "WHERE pro.id = '{$project}'";
     $projectNoti = new request();
     $projectNoti->openProjects($tmpquery);
     $tmpquery = "WHERE noti.member IN ({$pAssigneeID})";
     $listNotifications = new request();
     $listNotifications->openNotifications($tmpquery);
     $comptListNotifications = count($listNotifications->not_id);
     if ($listNotifications->not_taskassignment[0] == "0") {
         $this->getUserinfo($idSession, "from");
         $this->partSubject = $strings["noti_taskassignment1"];
         $this->partMessage = $strings["noti_taskassignment2"];
         if ($projectNoti->pro_org_id[0] == "1") {
             $projectNoti->pro_org_name[0] = $strings["none"];
         }
         $complValue = $taskNoti->tas_completion[0] > 0 ? $taskNoti->tas_completion[0] . "0 %" : $taskNoti->tas_completion[0] . " %";
         $idStatus = $taskNoti->tas_status[0];
         $idPriority = $taskNoti->tas_priority[0];
         $body = $this->partMessage . "\n\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . "\n" . $strings["start_date"] . " : " . $taskNoti->tas_start_date[0] . "\n" . $strings["due_date"] . " : " . $taskNoti->tas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $taskNoti->tas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
         if ($taskNoti->tas_mem_organization[0] == "1") {
             $body .= "{$root}/general/login.php?url=tasks/viewtask.php%3Fid={$num}";
         } else {
             if ($taskNoti->tas_mem_organization[0] != "1" && $projectNoti->pro_published[0] == "0" && $taskNoti->tas_published[0] == "0") {
                 $body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $projectNoti->pro_id[0];
             }
         }
         $body .= "\n\n" . $this->footer;
         $subject = $this->partSubject . " " . $taskNoti->tas_name[0];
         $this->Subject = $subject;
         if ($taskNoti->tas_priority[0] == "4" || $taskNoti->tas_priority[0] == "5") {
             $this->Priority = "1";
         } else {
             $this->Priority = "3";
         }
         $this->Body = $body;
         $this->AddAddress($listNotifications->not_mem_email_work[0], $listNotifications->not_mem_name[0]);
         $this->Send();
         $this->ClearAddresses();
     }
 }

    connectSql("{$tmpquery1}");
    if ($sendto == "filedetails") {
        headerFunction("../linkedcontent/viewfile.php?id=" . $listFiles->fil_vc_parent[0] . "&msg=deleteFile&" . session_name() . "=" . session_id());
    } else {
        if ($task != "0") {
            headerFunction("../tasks/viewtask.php?id={$task}&msg=deleteFile&" . session_name() . "=" . session_id());
            exit;
        } else {
            headerFunction("../projects/viewproject.php?id={$project}&msg=deleteFile&" . session_name() . "=" . session_id());
            exit;
        }
    }
}
$tmpquery = "WHERE pro.id = '{$project}'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
if ($task != "0") {
    $tmpquery = "WHERE tas.id = '{$task}'";
    $taskDetail = new request();
    $taskDetail->openTasks($tmpquery);
}
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));
if ($task != "0") {
    $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["unlink_files"]);

<?php

$tmpquery = "WHERE tas.id IN({$id})";
$taskNoti = new request();
$taskNoti->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '{$project}'";
$projectNoti = new request();
$projectNoti->openProjects($tmpquery);
$tmpquery = "WHERE noti.member IN({$at})";
$listNotifications = new request();
$listNotifications->openNotifications($tmpquery);
$comptListNotifications = count($listNotifications->not_id);
if ($listNotifications->not_statustaskchange[0] == "0") {
    $mail = new notification();
    $mail->getUserinfo($idSession, "from");
    $mail->partSubject = $strings["noti_prioritytaskchange1"];
    $mail->partMessage = $strings["noti_prioritytaskchange2"];
    if ($projectNoti->pro_org_id[0] == "1") {
        $projectNoti->pro_org_name[0] = $strings["none"];
    }
    $complValue = $taskNoti->tas_completion[0] > 0 ? $taskNoti->tas_completion[0] . "0 %" : $taskNoti->tas_completion[0] . " %";
    $idStatus = $taskNoti->tas_status[0];
    $idPriority = $taskNoti->tas_priority[0];
    $body = $mail->partMessage . "\n\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . "\n" . $strings["start_date"] . " : " . $taskNoti->tas_start_date[0] . "\n" . $strings["due_date"] . " : " . $taskNoti->tas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $taskNoti->tas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
    if ($taskNoti->tas_mem_organization[0] == "1") {
        $body .= "{$root}/general/login.php?url=tasks/viewtask.php%3Fid={$id}";
    } else {
        if ($taskNoti->tas_mem_organization[0] != "1" && $projectNoti->pro_published[0] == "0" && $taskNoti->tas_published[0] == "0") {
            $body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $projectNoti->pro_id[0];
        }
    }

 if ($at == "0") {
     $atProject = "1";
 } else {
     $atProject = $at;
 }
 $id = str_replace("**", ",", $id);
 $tmpquery1 = "DELETE FROM " . $tableCollab["members"] . " WHERE id IN({$id})";
 $tmpquery2 = "UPDATE " . $tableCollab["projects"] . " SET owner='{$atProject}' WHERE owner IN({$id})";
 $tmpquery3 = "UPDATE " . $tableCollab["tasks"] . " SET assigned_to='{$at}' WHERE assigned_to IN({$id})";
 $tmpquery4 = "UPDATE " . $tableCollab["assignments"] . " SET assigned_to='{$at}',assigned='{$dateheure}' WHERE assigned_to IN({$id})";
 $tmpquery5 = "DELETE FROM " . $tableCollab["sorting"] . " WHERE member IN({$id})";
 $tmpquery6 = "DELETE FROM " . $tableCollab["notifications"] . " WHERE member IN({$id})";
 $tmpquery7 = "DELETE FROM " . $tableCollab["teams"] . " WHERE member IN({$id})";
 $tmpquery = "WHERE pro.owner IN({$id})";
 $listProjects = new request();
 $listProjects->openProjects($tmpquery);
 $comptListProjects = count($listProjects->pro_id);
 for ($i = 0; $i < $comptListProjects; $i++) {
     $listTeams->tea_id = "";
     $listTeams->tea_project = "";
     $listTeams->tea_member = "";
     $listTeams->tea_published = "";
     $listTeams->tea_authorized = "";
     $listTeams->tea_mem_login = "";
     $listTeams->tea_pro_id = "";
     $tmpquery = "WHERE tea.project = '" . $listProjects->pro_id[$i] . "' AND tea.member = '{$atProject}'";
     $listTeams = new request();
     $listTeams->openTeams($tmpquery);
     $comptListTeams = count($listTeams->tea_id);
     if ($comptListTeams == "0") {
         $tmpquery = "INSERT INTO " . $tableCollab["teams"] . "(project,member,published,authorized) VALUES('" . $listProjects->pro_id[$i] . "','{$atProject}','1','0')";

             if ($i < $comptSuppTeamClient - 1) {
                 $membersTeam .= ',';
             }
             if ($htaccessAuth == 'true') {
                 $Htpasswd->initialize('../files/' . $id . '/.htpasswd');
                 $Htpasswd->deleteUser($suppTeamClient->mem_login[$i]);
             }
         }
         $tmpquery4 = 'DELETE FROM ' . $tableCollab['teams'] . " WHERE project = '{$id}' AND member IN({$membersTeam})";
         connectSql($tmpquery4);
     }
 }
 // -------------------------------------------------------------------------------------------------
 $tmpquery = "WHERE pro.id = '{$id}'";
 $targetProject = new request();
 $targetProject->openProjects($tmpquery);
 // Delete old or unused phases
 if ($targetProject->pro_phase_set[0] != $thisPhase) {
     $tmpquery = 'DELETE FROM ' . $tableCollab['phases'] . " WHERE project_id = {$id}";
     connectSql($tmpquery);
 }
 // Create new Phases
 if ($targetProject->pro_phase_set[0] != $thisPhase) {
     $comptThisPhase = count($phaseArraySets[$thisPhase]);
     for ($i = 0; $i < $comptThisPhase; $i++) {
         $tmpquery = 'INSERT INTO ' . $tableCollab['phases'] . "(project_id,order_num,status,name) VALUES('{$id}','{$i}','0','" . $phaseArraySets[$thisPhase][$i] . "')";
         connectSql($tmpquery);
     }
     // Get a listing of project tasks and files and re-assign them to new phases if the phase set of a project is changed.
     $tmpquery = "WHERE tas.project = '" . $targetProject->pro_id[0] . "'";
     $listTasks = new request();

if ($validProjects == "true") {
    $block1->recordsTotal = compt($initrequest["projects"] . " " . $tmpquery);
    $listProjects = new request();
    $listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
    $comptListProjects = count($listProjects->pro_id);
    // echo "$tmpquery<br>";
}
$block2 = new block();
$block2->borne = $blockPage->returnBorne("2");
$block2->rowsLimit = "10";
$block2->sorting("home_tasks", $sortingUser->sor_home_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.name", 1 => "tas.priority", 2 => "tas.status", 3 => "tas.due_date", 4 => "mem.login", 5 => "tas.project", 6 => "tas.published"));
if ($projectsFilter == "true") {
    $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
    $tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '" . $_SESSION['idSession'] . "' ORDER BY pro.id";
    $listProjectsFilter = new request();
    $listProjectsFilter->openProjects($tmpquery);
    $comptListProjectsFilter = count($listProjectsFilter->pro_id);
    if ($comptListProjectsFilter != "0") {
        for ($i = 0; $i < $comptListProjectsFilter; $i++) {
            $filterResults .= $listProjectsFilter->pro_id[$i];
            if ($comptListProjectsFilter - 1 != $i) {
                $filterResults .= ",";
            }
        }
    }
}
if ($projectsFilter == "true") {
    if ($comptListProjectsFilter != "0") {
        $tmpquery = "{$searchTasks} AND pro.id IN({$filterResults}) ORDER BY {$block2->sortingValue}";
    } else {
        $validTasks = "false";

    $selected = "";
    if ($client_id == $clients->org_id[$i]) {
        $selected = " selected";
    }
    echo "<option value='" . $clients->org_id[$i] . "'" . $selected . ">" . $clients->org_name[$i] . "{$clientUser}</option>";
}
echo "</select><input type='SUBMIT' value='update'>" . "</td></tr>";
//*** Projet ***
if ($client_id == 0 || $client_id == "") {
    $client_id = 0;
}
$tmpquery = " WHERE org.id = " . $client_id;
$tmpquery .= $project_query_type;
$tmpquery .= " ORDER BY pro.name";
$projets = new request();
$projets->openProjects($tmpquery);
$comptProjects = count($projets->pro_id);
echo "\n\t<tr class='even'>\n\t  <td valign='top' class='leftvalue'>" . $strings['projects'] . " :</td>\n\t  <td><select name='project_id' ";
if ($comptProjects <= 1) {
    $event = "Blur";
} else {
    $event = "Change";
}
echo "on" . $event . "='this.form.submit();'>";
// get Clients listing
for ($i = 0; $i < $comptProjects; $i++) {
    $selected = "";
    if ($project_id == $projets->pro_id[$i]) {
        $selected = " selected";
    }
    echo "<option value='" . $projets->pro_id[$i] . "'" . $selected . ">" . $projets->pro_name[$i] . "{$clientUser}</option>";

    }
}
if ($enableHelpSupport != "true") {
    header("Location: ../general/permissiondenied.php");
    exit;
}
if ($supportType == "admin") {
    if ($_SESSION['profilSession'] != "0") {
        header("Location: ../general/permissiondenied.php");
        exit;
    }
}
if ($supportType == "team") {
    $tmpquery = "WHERE pro.id = '{$project}'";
    $requestProject = new request();
    $requestProject->openProjects($tmpquery);
}
//--- header ---
$pageSection = 'projects';
if ($supportType == "team") {
    $breadcrumbs[] = buildLink("../projects/listprojects.php?", $strings["projects"], LINK_INSIDE);
    $breadcrumbs[] = buildLink("../projects/viewproject.php?id=" . $requestProject->pro_id[0], $requestProject->pro_name[0], LINK_INSIDE);
    $breadcrumbs[] = buildLink("../support/listrequests.php?id=" . $requestProject->pro_id[0], $strings["support_requests"], LINK_INSIDE);
} else {
    if ($supportType == "admin") {
        $breadcrumbs[] = buildLink("../administration/admin.php?", $strings["administration"], LINK_INSIDE);
        $breadcrumbs[] = buildLink("../administration/support.php?", $strings["support_management"], LINK_INSIDE);
    }
}
if ($action == "new") {
    $breadcrumbs[] = $strings["new_requests"];

    } else {
        $tmpquery = "WHERE pro.status IN(0,1,4) ORDER BY {$block1->sortingValue}";
    }
} else {
    if ($typeProjects == "active") {
        if ($projectsFilter == "true") {
            $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
            $tmpquery .= "WHERE pro.status IN(2,3) AND teams.member = '{$idSession}' ORDER BY {$block1->sortingValue}";
        } else {
            $tmpquery = "WHERE pro.status IN(2,3)  ORDER BY {$block1->sortingValue}";
        }
    }
}
$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(0 => $strings["id"], 1 => $strings["project"], 2 => $strings["priority"], 3 => $strings["organization"], 4 => $strings["status"], 5 => $strings["owner"], 6 => $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();
        $block1->checkboxRow($listProjects->pro_id[$i]);
        $block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_id[$i], in));
        $block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], in));
        $block1->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);

}
if ($_GET['action'] == "removeToSite") {
    $tmpquery1 = "UPDATE " . $tableCollab["topics"] . " SET published='1' WHERE id = '" . $_GET['id'] . "'";
    connectSql("{$tmpquery1}");
    $msg = "removeToSite";
}
$tmpquery = "WHERE topic.id = '{$id}'";
$detailTopic = new request();
$detailTopic->openTopics($tmpquery);
$tmpquery = "WHERE pos.topic = '" . $detailTopic->top_id[0] . "' ORDER BY pos.created DESC";
$listPosts = new request();
$listPosts->openPosts($tmpquery);
$comptListPosts = count($listPosts->pos_id);
$tmpquery = "WHERE pro.id = '" . $detailTopic->top_project[0] . "'";
$detailProject = new request();
$detailProject->openProjects($tmpquery);
$teamMember = "false";
$tmpquery = "WHERE tea.project = '" . $detailTopic->top_project[0] . "' AND tea.member = '" . $_SESSION['idSession'] . "'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == "0") {
    $teamMember = "false";
} else {
    $teamMember = "true";
}
if ($teamMember == "false" && $projectsFilter == "true") {
    header("Location:../general/permissiondenied.php");
    exit;
}
if ($detailProject->pro_org_id[0] == "1") {

$block1->openPaletteIcon();
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
    //$block1->paletteIcon(0,"add",$strings["add"]);
    $block1->paletteIcon(1, "remove", $strings["delete"]);
}
$block1->paletteIcon(2, "info", $strings["view"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
    $block1->paletteIcon(3, "edit", $strings["edit"]);
}
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "20";
$block1->sorting("invoices", $sortingUser->sor_invoices[0], "inv.id ASC", $sortingFields = array(0 => "inv.id", 1 => "pro.name", 2 => "inv.total_inc_tax", 3 => "inv.date_sent", 4 => "inv.published"));
$tmpquery = "WHERE pro.owner = '{$idSession}' ORDER BY pro.id";
$projectsTest = new request();
$projectsTest->openProjects($tmpquery);
$comptProjectsTest = count($projectsTest->pro_id);
if ($comptProjectsTest == "0") {
    $listProjects = "false";
} else {
    for ($i = 0; $i < $comptProjectsTest; $i++) {
        $projectsOk .= $projectsTest->pro_id[$i];
        if ($comptProjectsTest - 1 != $i) {
            $projectsOk .= ",";
        }
    }
    if ($projectsOk == "") {
        $listProjects = "false";
    } else {
        $tmpquery = "WHERE inv.project IN({$projectsOk}) AND inv.active = '1' AND inv.status = '{$status}' ORDER BY {$block1->sortingValue}";
    }