コード例 #1
0
ファイル: NestedCategory.php プロジェクト: family-guy/webCms
 /**
  * Recursively deletes all records in database which are descendants of NestedCategory object
  * @param Db object <code>$db</code>
  */
 public function delete_descendants(Db $db)
 {
     if (isset($this->children)) {
         foreach ($this->children as $child) {
             $nested_category = new NestedCategory();
             $nested_category->set_id((int) $child['id']);
             $nested_category->db_props($db);
             if (null !== $nested_category->get_droite() && null !== $nested_category->get_gauche()) {
                 $diff = $nested_category->get_droite() - $nested_category->get_gauche();
                 $db->delete("id = {$child['id']}", self::$table);
                 if ($diff > 1) {
                     $nested_category->children($db);
                     $nested_category->delete_descendants($db);
                 }
             }
         }
     }
 }
コード例 #2
0
 /**
  * Deletes nested category and all descendant categories from database as per given id
  * Checks if id of nested category being deleted belongs to user. If so, updates <code>$nested_categories</code> property of <code>$user</code> property and saves User object into Session variable
  * @param Db object <code>$db</code>, string <code>$id</code>, UserController object <code>$user_controller</code>
  */
 public function delete(Db $db, $id, UserController $user_controller)
 {
     $id_clean = filter_var($id, FILTER_SANITIZE_STRING);
     $user = $user_controller->get_user();
     $user_nested_categories = $user->get_nested_categories();
     $deletion_valid = false;
     foreach ($user_nested_categories as $user_nested_category) {
         if ($user_nested_category['id'] == $id_clean) {
             $deletion_valid = true;
         }
     }
     if ($deletion_valid) {
         $nested_cat_to_del = new NestedCategory();
         $nested_cat_to_del->set_id((int) $id_clean);
         $nested_cat_to_del->db_props($db);
         $nested_cat_to_del->delete($db);
         // delete all descendant categories
         $nested_cat_to_del->children($db);
         $nested_cat_to_del->delete_descendants($db);
         // adjust values in <code>nested_categories</code> table accordingly
         if (null !== $nested_cat_to_del->get_droite() && null !== $nested_cat_to_del->get_gauche()) {
             $diff = $nested_cat_to_del->get_droite() - $nested_cat_to_del->get_gauche();
             $nested_cat_to_del->nested_cats_to_update_after_del($db);
             $nested_cats_to_update = $nested_cat_to_del->get_nested_cats_to_update_after_del();
             if (isset($nested_cats_to_update)) {
                 foreach ($nested_cats_to_update as $x) {
                     $gauche = $x['gauche'];
                     $droite = $x['droite'];
                     $nested_cat_to_update = new NestedCategory();
                     $nested_cat_to_update->set_id((int) $x['id']);
                     if ($gauche > $nested_cat_to_del->get_droite()) {
                         $nested_cat_to_update->set_gauche($gauche - $diff - 1);
                     }
                     $nested_cat_to_update->set_droite($droite - $diff - 1);
                     $nested_cat_to_update->save($db);
                 }
             }
         }
         $user->nested_categories($db);
         $_SESSION['user'] = serialize($user);
         // userProfileHome.php
         $this->username = $user->get_username();
         $this->user_nested_categories = $user->get_nested_categories();
     }
 }