/**
* Ferme le noeud $node_id de l'utilisateur $user. (suppression de la relation)
*
* @param type $node_id
* @param type $user
*/
public function closeNode($node_id, $user)
{
$opened = Doctrine_Core::getTable('EiNodeOpenedBy')->findOneByUserIdAndRefIdAndEiNodeId($user->getUserId(), $user->getRefId(), $node_id);
if ($opened) {
$opened->delete();
}
}
/**
* Ferme le noeud $node_id de l'utilisateur $user. (suppression de la relation)
*
* @param type $node_id
* @param type $user
*/
public function closeNode($node_id, $user, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
$user_id = $user->getUserId();
$user_ref = $user->getRefId();
self::$tabIds = "";
$tabIds = self::closeNodes($node_id, $user_id, $user_ref, self::$tabIds, $conn);
if (self::$tabIds != "") {
$conn->execute("delete from ei_tree_opened_by where user_id=" . $user_id . " and ref_id=" . $user_ref . " and ei_tree_id IN (" . substr(self::$tabIds, 0, strlen(self::$tabIds) - 1) . ")");
}
}
/**
* Update an item
* @param type $basketObj
* @return type
*/
public static function updateBasket($basketObj)
{
$userId = \Core\Db::escape($basketObj->getUserId());
$petId = \Core\Db::escape($basketObj->getPetId());
$id = $basketObj->getId();
$sql = <<<q
UPDATE `basket` SET
`user_id` = '{$userId}',
`pet_id` = '{$petId}'
WHERE `id` = {$id};
q;
//echo "<br/><br/>" . $sql . "<br/><br/>";
$res = \Core\Db::execute($sql);
return $res === false ? false : true;
}
/**
* Créer une nouvelle instance de EiNodeOpenedBy et l'enregistre en base de données.
* @param type $type Type de noeuf (folder ou scenario)
* @param type $user
* @return type
*/
public function openNode($user)
{
$opened = Doctrine_Core::getTable('EiNodeOpenedBy')->findOneByUserIdAndRefIdAndEiNodeId($user->getUserId(), $user->getRefId(), $this->getId());
if ($opened == null) {
$opened = new EiNodeOpenedBy();
$opened->setRefId($user->getRefId());
$opened->setUserId($user->getUserId());
$opened->setEiNodeId($this->getId());
$opened->save();
}
}
