public function getDefaultInterventionWithScenarioVersion(EiProjet $ei_project, EiVersion $ei_version, Doctrine_Connection $conn = null) { if ($conn == null) { $conn = Doctrine_Manager::connection(); } return $conn->fetchRow("select sp.*, s.id as subject_id ,s.name as subject_name from ei_scenario_package sp\n inner join ei_subject s on sp.package_id= s.package_id and sp.package_ref=s.package_ref\n where sp.ei_scenario_id= " . $ei_version->getEiScenarioId() . " and sp.ei_version_id=" . $ei_version->getId() . " and s.project_id=" . $ei_project->getProjectId() . " and s.project_ref=" . $ei_project->getRefId()); }
/** * Créer la version par defaut pour le scénario en cours de création et * en retourne son identifiant. * * @return integer */ public function createDefaultVersion(EiUserDefaultPackage $ei_user_default_package = null, Doctrine_Connection $conn = null) { if ($conn == null) { $conn = Doctrine_Manager::connection(); } //creation de la version par defaut du scénario $def_version = new EiVersion(); $def_version->ei_scenario_id = $this->getId(); $def_version->libelle = 'S' . $this->getId() . '-version1'; $def_version->save($conn); if ($ei_user_default_package != null) { //Création de la relation entre la version du scénario et le package $ei_scenario_package = new EiScenarioPackage(); $ei_scenario_package->setEiScenarioId($this->getId()); $ei_scenario_package->setPackageId($ei_user_default_package->getTicketId()); $ei_scenario_package->setPackageRef($ei_user_default_package->getTicketRef()); $ei_scenario_package->setEiVersionId($def_version->getId()); $ei_scenario_package->save($conn); } $ei_version_structure = new EiVersionStructure(); $ei_version_structure->setName("Root"); $ei_version_structure->setEiVersion($def_version); $ei_version_structure->setType(EiVersionStructure::$TYPE_BLOCK); $ei_version_structure->save($conn); $treeObject = Doctrine_Core::getTable('EiVersionStructure')->getTree(); $treeObject->createRoot($ei_version_structure); return $def_version->getId(); }