public function setInterventionAsDefault(EiSubject $ei_subject)
{
$ei_subject->save();
//$tabPackage= $ei_subject->getPackage();
$this->ei_subject = Doctrine_Core::getTable("EiSubject")->findOneById($ei_subject->getId());
$this->ei_ticket = Doctrine_Core::getTable('EiTicket')->findOneByTicketIdAndTicketRef($this->ei_subject->getPackageId(), $this->ei_subject->getPackageRef());
//On définit le package du sujet comme package courant
//On vérifie que le package par défaut du sujet est définit pour le user et le projet
$defPack = Doctrine_Core::getTable('EiUserDefaultPackage')->findOneByUserRefAndUserIdAndProjectRefAndProjectId($this->ei_user->getRefId(), $this->ei_user->getUserId(), $ei_subject->getProjectRef(), $ei_subject->getProjectId());
Doctrine_Core::getTable('EiUserDefaultPackage')->setDefaultPackage($this->ei_subject->getPackageId(), $this->ei_subject->getPackageRef(), $this->ei_project, $this->ei_user, $defPack == null ? 0 : 1);
}
public static function createNewLink(KalFunction $kal_fonction, EiSubject $bug, $automate = false, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
$newLink = new EiSubjectFunctions();
$newLink->setKalFunction($kal_fonction);
$newLink->setSubjectId($bug->getId());
$newLink->setAutomate($automate);
$currentLink = Doctrine_core::getTable('EiSubjectFunctions')->findOneBySubjectIdAndFunctionIdAndFunctionRef($bug->getId(), $kal_fonction->getFunctionId(), $kal_fonction->getFunctionRef());
if ($currentLink == null) {
$newLink->save($conn);
//La liaison n'existe pas: on la crée.
}
if ($currentLink != null && !$currentLink->getAutomate()) {
$currentLink->setAutomate($automate);
//La liaison existe mais n'est pas forte: on la rend forte.
$currentLink->save($conn);
}
}
public function getAssignAndNonAssignUserToSubject(EiSubject $ei_subject)
{
$this->alreadyAssignUsers = $ei_subject->getAssignUsers();
$this->usersToAssignToSubject = $ei_subject->getNonAssignUsers($this->alreadyAssignUsers);
}
public function checkSubjectCampaign(EiSubject $ei_subject, EiCampaign $ei_campaign)
{
$this->subjectCampaign = Doctrine_Core::getTable('EiSubjectHasCampaign')->findOneByCampaignIdAndSubjectId($ei_campaign->getId(), $ei_subject->getId());
}
public function getModifyAndExecDelFunctions(EiDelivery $ei_delivery = null, EiSubject $ei_subject = null, KalFunction $kal_function = null, $executed = true, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
$q = "select COUNT(DISTINCT(lf.ei_scenario_id)) as nbScenario ,COUNT(DISTINCT(fc.campaign_id)) as nbCamp, MAX(tsf.date_debut) as last_ex,\n df.* , tsf.* from ei_delivery_impacted_functions_vw df \n left join ei_test_set_function tsf on tsf.function_id=df.t_obj_id and tsf.function_ref=df.t_ref_obj\n left join eifunction_campaigns fc on fc.function_id=df.t_obj_id and fc.function_ref=df.t_ref_obj\n left join ei_log_function lf on lf.ei_test_set_function_id = tsf.id ";
/* On vérifie que la livraison est renseignée et on ajoute le critère de sélection*/
if ($ei_delivery != null) {
$q .= " where (df.s_delivery_id = " . $ei_delivery->getId() . " or df.s2_delivery_id = " . $ei_delivery->getId() . ") ";
/*Si on recherche les fonctions modifiées et non executées */
if (!$executed) {
$q .= " And tsf.id IS NULL";
} else {
$q .= " And tsf.id IS NOT NULL";
}
}
/* Si on recherche les fonctions pour un bug , alors :*/
if ($ei_subject != null) {
$q .= " where ( (df.s_id=" . $ei_subject->getId() . ") or (df.s2_id=" . $ei_subject->getId() . ")) ";
}
/* Si on a spécifié la fonction concernée , alors on rajoute le critère */
if ($ei_subject != null && $kal_function != null) {
$q .= " and df.t_obj_id=" . $kal_function->getFunctionId() . " and df.t_ref_obj=" . $kal_function->getFunctionRef();
}
/* On complète la requête */
$q .= " group by df.t_id order by tsf.date_debut desc ";
//throw new Exception($q);
return $conn->fetchAll($q);
}
public function setEiSubjectId(EiSubject $ei_subject)
{
$this->setSubjectId($ei_subject->getId());
}
public function removeAssignmentOnSubject(EiSubject $ei_subject, sfGuardUser $guard, sfGuardUser $author)
{
$assignment = Doctrine_Core::getTable('EiSubjectAssignment')->findOneBySubjectIdAndGuardId($ei_subject->getId(), $guard->getId());
$assignment->delete();
}
function createSubject(EiProjet $ei_project, $superAdmin)
{
$ei_subject = new EiSubject();
$ei_subject->setName("Bug" . time());
$ei_subject->setAuthorId($superAdmin->getId());
$ei_subject->setProjectId($ei_project->getProjectId());
$ei_subject->setProjectRef($ei_project->getRefId());
$ei_subject->save();
return $ei_subject;
}
public function executeCreateContext(sfWebRequest $request)
{
$this->guardUser = $this->getUser()->getGuardUser();
$this->checkProject($request);
//Récupération du projet
$this->checkProfile($request, $this->ei_project);
$this->checkCampaignGraph($request);
$context = new EiBugContext();
$context->setCampaignId($this->ei_campaign_graph->getCampaignId());
$context->setScenarioId($this->ei_campaign_graph->getScenarioId());
$context->setCampaignGraphId($this->ei_campaign_graph->getId());
$context->setEiDataSetId($this->ei_campaign_graph->getDataSetId());
$context->setProfileId($this->ei_profile->getProfileId());
$context->setProfileRef($this->ei_profile->getProfileRef());
$context->setAuthorId($this->guardUser->getId());
$subject = new EiSubject();
$subject->setProjectId($this->ei_project->getProjectId());
$subject->setProjectRef($this->ei_project->getRefId());
$subject->setAuthorId($this->guardUser->getId());
$this->form = new EiSubjectForm($subject, array('ei_project' => $this->ei_project, 'guardUser' => $this->guardUser, 'ei_bug_context' => $context));
$this->processForm($request, $this->form);
if ($this->success) {
$show = $this->urlParameters;
$show['ei_context'] = $this->ei_context;
return $this->renderText(json_encode(array('html' => $this->getPartial('bugContext/show', $show), 'success' => $this->success)));
} else {
$newContextForm = $this->urlParameters;
$newContextForm['form'] = $this->form;
$newContextForm['campaign_graph_id'] = $this->campaign_graph_id;
return $this->renderText(json_encode(array('html' => $this->getPartial('bugContext/newContextForm', $newContextForm), 'success' => $this->success)));
}
return sfView::NONE;
}
public function getSubjectWithRel(EiProjet $ei_project, $delivery_id = null, $subject_id = null, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
$q = "select * from ei_subjects_with_relations_vw where project_id=" . $ei_project->getProjectId() . " and project_ref=" . $ei_project->getRefId();
if ($delivery_id != null) {
$q .= " and delivery_id=" . $delivery_id;
}
if ($subject_id != null) {
$q .= " and id=" . $subject_id;
}
return EiSubject::parseSubjects($conn->fetchAll($q));
}
public function getBugWithImpactOrNot($delivery_id, $hasImpact = true, Doctrine_Connection $conn = null)
{
$q = "select distinct(s.id), s.name ,vwf.delivery_id, ss.name as ss_name, ss.color_code as ss_color_code,st.name as type_name,sp.name as sp_name,g.id as assign_id,g.username as assign_name\n from ei_subject s\n left join ei_subject_state ss on ss.id=s.subject_state_id\n left join ei_subject_type st on st.id=s.subject_type_id\n left join ei_subject_priority sp on sp.id=s.subject_priority_id\n left join ei_subject_assignment sa on sa.subject_id=s.id\n left join sf_guard_user g on g.id=sa.guard_id \n left join \n (\n SELECT IF(s_id is null, s2_id , s_id) as subject_id, IF(s_delivery_id is null, s2_delivery_id , s_delivery_id) as delivery_id from\n ei_delivery_impacted_functions_vw \n WHERE t_type='Function' ) as vwf\n on s.id= vwf.subject_id\n where s.delivery_id=" . $delivery_id;
if ($hasImpact) {
$q .= " and vwf.subject_id is not null";
} else {
$q .= " and vwf.subject_id is null";
}
return EiSubject::parseSubjects($conn->fetchAll($q));
}
