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();
}
