[Kosta100]

// update project donehours per department
var query2 = "SELECT SUM(FilteredReut_assignment.reut_donehours) AS DoneHours FROM FilteredReut_assignment INNER JOIN FilteredReut_project ON FilteredReut_assignment.reut_projectid = FilteredReut_project.reut_projectid WHERE (FilteredReut_assignment.reut_taskstatus = 3) AND (FilteredReut_project.reut_projectid ='" + Project +"') AND (FilteredReut_assignment.reut_department = " + Department +")";
var rs2 = new ActiveXObject("ADODB.Recordset");
rs2.Open(query2, connection, 1, 2);
var ProjDoneHours=rs2.Fields(0).Value;
switch (Department)
{
case "1":
var query3 = "UPDATE FilteredReut_project SET reut_managementdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')";
break;
case "2":
var query3 = "UPDATE FilteredReut_project SET reut_engineeringdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')";
break;
case "3":
var query3 = "UPDATE FilteredReut_project SET reut_operationdone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')";
break;
case "4":
var query3 = "UPDATE FilteredReut_project SET reut_manufacturedone =" + ProjDoneHours + " WHERE (reut_projectid = '" + Project +"')";
break;
}