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