public function getGraphNodeChildren(EiCampaignGraph $ei_campaign_graph, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
return $conn->createQuery()->from('EiCampaignGraph cg')->leftJoin('cg.graphCampaignChildren cc')->leftJoin('cg.EiCampaign c')->where('c.id= ? ', array($ei_campaign_graph->getCampaignId()))->andWhere('cc.parent_id =' . $ei_campaign_graph->getId())->execute();
}
public function addStepAsNextOf(EiCampaignGraph $step_before, EiCampaignGraph $new_step, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
try {
$conn->beginTransaction();
$new_step->save($conn);
//Ajout de la relation père fils
$child_of_step_before = Doctrine_Core::getTable('EiCampaignGraphHasGraph')->findOneByParentId($step_before->getId());
if ($child_of_step_before != null) {
//L'élément a bien un fils, on intercale le nouveau step entre les deux
$new_relation = new EiCampaignGraphHasGraph();
$new_relation->setParentId($new_step->getId());
$new_relation->setChildId($child_of_step_before->getChildId());
$new_relation->setCampaignId($step_before->getCampaignId());
$new_relation->save($conn);
//Modification de l'ancienne relation
$child_of_step_before->setChildId($new_step->getId());
$child_of_step_before->save($conn);
$conn->commit();
return $new_step;
} else {
//L'élément est root
$new_relation = new EiCampaignGraphHasGraph();
$new_relation->setParentId($step_before->getId());
$new_relation->setChildId($new_step->getId());
$new_relation->setCampaignId($step_before->getCampaignId());
$new_relation->save($conn);
$conn->commit();
return $new_step;
}
$conn->close();
return null;
} catch (Exception $e) {
$conn->rollback();
throw $e;
}
}
