$listTasks = new request();
$listTasks->openTasks($tmpquery);
$comptListTasks = count($listTasks->tas_id);
for ($i = 0; $i < $comptListTasks; $i++) {
if ($fileManagement == "true") {
delDir("../files/" . $listTasks->tas_project[$i] . "/" . $listTasks->tas_id[$i]);
}
}
connectSql("{$tmpquery1}");
connectSql("{$tmpquery2}");
connectSql("{$tmpquery3}");
//recompute number of completed tasks of the project
$tmpquery = "WHERE pro.id = '" . $listTasks->tas_project[0] . "'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
projectComputeCompletion($listTasks->tas_project[$i], $tableCollab["projects"]);
if ($project != "") {
headerFunction("../projects/viewproject.php?id={$project}&msg=delete&" . session_name() . "=" . session_id());
exit;
} else {
headerFunction("../general/home.php?msg=delete&" . session_name() . "=" . session_id());
exit;
}
}
$tmpquery = "WHERE pro.id = '{$project}'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
if ($project != "") {
}
$tmpquery = "WHERE project = '{$project}'";
$detailInvoice = new request();
$detailInvoice->openInvoices($tmpquery);
if ($detailInvoice->inv_status[0] == "0") {
//$tmpquery3 = "INSERT INTO ".$tableCollab["invoices_items"]." SET title='$task_name',description='$d',invoice='".$detailInvoice->inv_id[0]."',created='$dateheure',active='$invoicing',completed='$completeItem',mod_type='1',mod_value='$num',worked_hours='$worked_hours'";
$tmpquery3 = "INSERT INTO " . $tableCollab["invoices_items"] . " (title,description,invoice,created,active,completed,mod_type,mod_value,worked_hours) VALUES ('{$task_name}','{$d}','" . fixInt($detailInvoice->inv_id[0]) . "','{$dateheure}','{$invoicing}','{$completeItem}','1','{$num}','{$worked_hours}')";
connectSql($tmpquery3);
}
}
if ($st == "1") {
$tmpquery6 = "UPDATE " . $tableCollab["tasks"] . " SET complete_date='{$date}' WHERE id = '{$num}'";
connectSql($tmpquery6);
}
//recompute number of completed tasks of the project
$projectDetail->pro_name[0] = projectComputeCompletion($projectDetail, $tableCollab["projects"]);
//if assigned_to not blank, set assigned date
if ($at != "0") {
$tmpquery6 = "UPDATE " . $tableCollab["tasks"] . " SET assigned='{$dateheure}' WHERE id = '{$num}'";
connectSql($tmpquery6);
}
$tmpquery2 = "INSERT INTO " . $tableCollab["assignments"] . "(task,owner,assigned_to,assigned) VALUES('{$num}','{$idSession}','{$at}','{$dateheure}')";
connectSql($tmpquery2);
//if assigned_to not blank, add to team members (only if doesn't already exist)
//add assigned_to in team members (only if doesn't already exist)
if ($at != "0") {
$tmpquery = "WHERE tea.project = '{$project}' AND tea.member = '{$at}'";
$testinTeam = new request();
$testinTeam->openTeams($tmpquery);
$comptTestinTeam = count($testinTeam->tea_id);
if ($comptTestinTeam == "0") {
