/** * Event method to set a project on a task. * Get the last inserted id from the task and then check * if there is a project then add to project_task */ function eventSetProjectTask(EventControler $evtcl) { $project_name = trim($evtcl->fields["project"]); $idtask = $evtcl->insertid; $q = new sqlQuery($this->getDbCon()); if ($project_name != '') { $do_project = new Project(); $do_project_task = new ProjectTask(); $idproject = $do_project->getProjectIdByName($project_name); if ($idproject !== false) { $q->query("INSERT INTO project_task (idtask, idproject) VALUES (" . $idtask . ", " . $idproject . ")"); } else { $do_project->addNew(); $do_project->iduser = $_SESSION['do_User']->iduser; $do_project->name = $project_name; $do_project->status = 'open'; $do_project->add(); $idproject = $do_project->getPrimaryKeyValue(); $q->query("INSERT INTO project_task (idtask, idproject) VALUES (" . $idtask . ", " . $idproject . ")"); } } }