Example #1
0
 /**
  * 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 . ")");
         }
     }
 }