<?php // $Revision: 1.7 $
/* vim: set expandtab ts=4 sw=4 sts=4: */

/**
 * $Id: deleteusers.php,v 1.7 2003/11/22 03:43:39 madbear Exp $
 * 
 * Copyright (c) 2003 by the NetOffice developers
 * 
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 */

$checkSession = true;
require_once("../includes/library.php");
// CVS library
require_once("../includes/cvslib.php");

if ($action == "delete") {
    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')";

            connectSql("$tmpquery");
        } 
    } 
    // if CVS repository enabled
    if ($enable_cvs == "true") {
        $pieces = explode(",", $id);
        for ($j = 0;$j < (count($pieces));$j++) {
            // remove the users from every repository
            $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.member = '$pieces[$j]'";
            $listTeams = new request();
            $listTeams->openTeams($tmpquery);
            $comptListTeams = count($listTeams->tea_id);
            for ($i = 0;$i < $comptListTeams;$i++) {
                cvs_delete_user($listTeams->tea_mem_login[$i], $listTeams->tea_pro_id[$i]);
            } 
        } 
    } 
    connectSql("$tmpquery1");
    connectSql("$tmpquery2");
    connectSql("$tmpquery3");
    connectSql("$tmpquery4");
    connectSql("$tmpquery5");
    connectSql("$tmpquery6");
    connectSql("$tmpquery7");
    // if mantis bug tracker enabled
    if ($enableMantis == "true") {
        // Call mantis function to remove user
        require_once ("../mantis/user_delete.php");
    } 

    header("Location: ../users/listusers.php?msg=delete");
    exit;
} 

require_once("../themes/" . THEME . "/header.php");

$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../administration/admin.php?", $strings["administration"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../users/listusers.php?", $strings["user_management"], in));
$blockPage->itemBreadcrumbs($strings["delete_users"]);
$blockPage->closeBreadcrumbs();

if ($msg != "") {
    require_once("../includes/messages.php");
    $blockPage->messagebox($msgLabel);
} 

$block1 = new block();

$block1->form = "user_delete";
$block1->openForm("../users/deleteusers.php?action=delete");

$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 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>
<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">&nbsp;</td><td>" . $strings["there"] . " $totalTasks " . $strings["tasks"] . " " . $strings["owned_by"] . "</td></tr>
<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\">
<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>
<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->closeForm();

require_once("../themes/" . THEME . "/footer.php");

?>