$project->assign($member, $add); if ($settings["mailnotify"]) { $usr = (object) new user(); $user = $usr->getProfile($member); if (!empty($user["email"])) { $userlang = readLangfile($user['locale']); $subject = $userlang["projectassignedsubject"] . ' (' . $userlang['by'] . ' ' . $username . ')'; $mailcontent = $userlang["hello"] . ",<br /><br/>" . $userlang["projectassignedtext"] . " <a href = \"" . $url . "manageproject.php?action=showproject&id={$add}\">" . $url . "manageproject.php?action=showproject&id={$add}</a>"; // send email $themail = new emailer($settings); $themail->send_mail($user["email"], $subject, $mailcontent); } } } if ($company > 0) { $companyObj->assign($company, $add); } header("Location: manageproject.php?action=showproject&id={$add}"); } } elseif ($action == "closepro") { if ($project->close($id)) { echo "ok"; // header("Location: admin.php?action=projects&mode=closed"); } } elseif ($action == "openpro") { if ($project->open($id)) { header("Location: admin.php?action=projects&mode=opened"); } } elseif ($action == "deletepro") { if ($project->del($id)) { // header("Location: admin.php?action=projects&mode=deleted");
function addProjectFromExcel($inputFileName) { include "./include/PHPExcel/IOFactory.php"; $objReader = new PHPExcel_Reader_Excel2007(); $objPHPExcel = $objReader->load($inputFileName); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); $limiter = "#"; $projectObj = new project(); $userObj = new user(); $milestoneObj = new milestone(); $tasklistObj = new tasklist(); $taskObj = new task(); $companyObj = new company(); $projectname = $sheetData[2]["A"]; $projectdescription = $sheetData[3]["A"]; $projectdue = $sheetData[4]["A"]; $projectbudget = $sheetData[5]["A"]; $projectcustomer = $sheetData[6]["A"]; $projectpriority = $sheetData[7]["A"]; $projectId = $projectObj->add($projectname, $projectdescription, $projectdue, $projectbudget, $projectpriority); $customer = $companyObj->getCompanyByName($projectcustomer); if ($customer) { $companyObj->assign($customer["ID"], $projectId); } // USERS for ($i = 1; $i < count($sheetData); $i++) { $username = $sheetData[$i]["B"]; if ($username) { $user = $userObj->getUserByName($username); if ($user) { $projectObj->assign($user["ID"], $projectId); } } else { break; } } // MILESTONES for ($i = 1; $i < count($sheetData); $i++) { $milestone = explode($limiter, $sheetData[$i]["C"]); if ($milestone) { $milestoneObj->add($projectId, $milestone[0], $milestone[1], $milestone[2], $milestone[3]); } else { break; } } // TASK LISTS for ($i = 1; $i < count($sheetData); $i++) { $tasklist = explode($limiter, $sheetData[$i]["D"]); if ($tasklist) { if ($tasklist[3]) { $milestone = $milestoneObj->getMilestoneByName($tasklist[3]); if ($milestone) { $tasklistObj->add_liste($projectId, $tasklist[0], $tasklist[1], $tasklist[2], 0, $milestone["ID"]); } } else { $tasklistObj->add_liste($projectId, $tasklist[0], $tasklist[1], $tasklist[2]); } } else { break; } } // TASKS for ($i = 1; $i < count($sheetData); $i++) { $task = explode($limiter, $sheetData[$i]["E"]); if ($task) { $tasklist = $tasklistObj->getTasklistByName($task[5]); $taskid = $taskObj->add($task[2], $task[3], $task[0], $task[4], $tasklist["ID"], $projectId, $task[6], $task[7]); $user = $userObj->getUserByName($task[1]); if ($taskid) { if ($user) { $taskObj->assign($taskid, $user["ID"]); } } } else { break; } } return $projectId; }