コード例 #1
0
ファイル: class.project.php プロジェクト: Setrino/collabtive
 /**
  * Removes a user from a project
  *
  * @param int $user User ID of user to remove
  * @param int $id Project ID of project to remove from
  * @return bool
  */
 function deassign($user, $id)
 {
     global $conn;
     $sqlStmt = $conn->prepare("DELETE FROM projekte_assigned WHERE user = ? AND projekt = ?");
     $milestone = new milestone();
     // Delete the users assignments to closed milestones
     $donemiles = $milestone->getDoneProjectMilestones($id);
     if (!empty($donemiles)) {
         $sql1Stmt = $conn->prepare("DELETE FROM milestones_assigned WHERE user = ? AND milestone = ?");
         foreach ($donemiles as $dm) {
             $sql1 = $sql1Stmt->execute(array((int) $user, $dm['ID']));
         }
     }
     // Delete the users assignments to open milestones
     $openmiles = $milestone->getAllProjectMilestones($id, 100000);
     if (!empty($openmiles)) {
         $sql2Stmt = $conn->prepare("DELETE FROM milestones_assigned WHERE user = ? AND milestone = ?");
         foreach ($openmiles as $om) {
             $sql2 = $sql2Stmt->execute(array((int) $user, $om['ID']));
         }
     }
     $task = new task();
     $tasks = $task->getProjectTasks($id);
     // Delete tasks assignments of the user
     if (!empty($tasks)) {
         $sql3Stmt = $conn->prepare("DELETE FROM tasks_assigned WHERE user = ? AND task = ?");
         foreach ($tasks as $t) {
             $sql3 = $sql3Stmt->execute(array((int) $user, $t['ID']));
         }
     }
     // Finally remove the user from the project
     $del = $sqlStmt->execute(array((int) $user, (int) $id));
     if ($del) {
         $userObj = new user();
         $user = $userObj->getProfile($user);
         $this->mylog->add($user["name"], 'user', 7, $id);
         return true;
     } else {
         return false;
     }
 }
コード例 #2
0
 /**
  * Entfernt ein Projekt aus der Zuweisung an ein bestimmtes Mitglied
  *
  * @param int $user User ID
  * @param int $id Project ID
  * @return bool
  */
 function deassign($user, $id)
 {
     $user = mysql_real_escape_string($user);
     $id = mysql_real_escape_string($id);
     $user = (int) $user;
     $id = (int) $id;
     $sql = "DELETE FROM projekte_assigned WHERE user = {$user} AND projekt = {$id}";
     $milestone = new milestone();
     $donemiles = $milestone->getDoneProjectMilestones($id);
     if (!empty($donemiles)) {
         foreach ($donemiles as $dm) {
             $sql1 = mysql_query("DELETE FROM milestones_assigned WHERE user = {$user} AND milestone = {$dm['ID']}");
         }
     }
     $openmiles = $milestone->getAllProjectMilestones($id, 100000);
     if (!empty($openmiles)) {
         foreach ($openmiles as $om) {
             $sql2 = mysql_query("DELETE FROM milestones_assigned WHERE user = {$user} AND milestone = {$om['ID']}");
         }
     }
     $task = new task();
     $tasks = $task->getProjectTasks($id);
     if (!empty($tasks)) {
         foreach ($tasks as $t) {
             $sql3 = mysql_query("DELETE FROM tasks_assigned WHERE user = {$user} AND task = {$t['ID']}");
         }
     }
     $del = mysql_query($sql);
     if ($del) {
         $userObj = new user();
         $user = $userObj->getProfile($user);
         $this->mylog->add($user["name"], 'user', 7, $id);
         return true;
     } else {
         return false;
     }
 }