public static function actionAddProject($data)
{
$project = Project::getEntity($data['id']);
if ($project->getId() != null) {
// Save skills
$new_project = Project::fetchEntity($data);
$skills = $new_project->getSkills();
if (count($skills) > 0) {
foreach ($skills as $skill) {
if ($skill->isActive == 1) {
Skill::addSkillToProject($skill->id, $new_project->getId());
} else {
Skill::deleteSkillForProject($skill->id, $new_project->getId());
}
}
}
// Return to save the team member
return true;
}
return false;
}
public static function getProjectsForSkill($id)
{
$pdo = PDO2::getInstance();
$requete = $pdo->prepare("SELECT p.* \n\t\t\t\tFROM projects p, asso_projects_skills a\n\t\t\t\tWHERE a.id_skill = :id_skill\n\t\t\t\tAND a.id_project = p.id\n\t\t\t\t");
$requete->bindValue(':id_skill', $id, PDO::PARAM_STR);
$requete->execute();
$final_objects = null;
if ($objects = $requete->fetchAll(PDO::FETCH_ASSOC)) {
if (count($objects)) {
$type = get_called_class();
foreach ($objects as $object) {
$entity = new Project();
$final_objects[] = $entity->fetchEntity($object);
}
}
return $final_objects;
} else {
return false;
//print_r($requete->errorInfo());
}
}
