public function deleteInactiveFunctions(EiProjet $ei_project, Doctrine_Connection $conn)
{
if ($ei_project == null) {
return null;
}
//Suppression de l'objet EiFonction
$conn->createQuery()->from('EiFonction f')->where('KalFunction.function_id=f.function_id And KalFunction.function_ref=f.function_ref')->andWhere('KalFunction.project_id=? And KalFunction.project_ref=? And KalFunction.is_active = false', array($ei_project->getProjectId(), $ei_project->getRefId()))->execute()->delete();
//Suppression de la fonction sous Script
$conn->createQuery()->delete()->from('KalFunction f')->where('f.project_id=? And f.project_ref=? And f.is_active = false', array($ei_project->getProjectId(), $ei_project->getRefId()))->execute();
}
public function findVersionForPackage(EiTicket $ei_package, Doctrine_Connection $conn = null)
{
return $conn->createQuery()->from('EiVersion v')->leftJoin('v.EiVersionPackage sp')->where('sp.package_id=' . $ei_package->getTicketId() . ' And sp.package_ref=' . $ei_package->getTicketRef() . ' And sp.ei_scenario_id=' . $this->getId())->execute();
}
