Быстрое удаление рубрик и товаров в InstantShop

 
public function deleteItem($id){
...
...
$this->reorder('cms_shop_items_cats', 'category_id', 'item_id');
 

 
/* ========================================================================== */
/* ========================================================================== */
 
    public function deleteItems($items) {
 
        if (!is_array($items)){ return false; }
 
        $list_categories = array(); //здесь мы сохраняем все категории, которые потом будем упорядочивать
        foreach($items as $item_id){
           $sql = "SELECT category_id, item_id FROM cms_shop_items_cats WHERE item_id={$item_id} GROUP BY category_id"; //получаем все категории где встречается товар
           $res = $this->inDB->query($sql);
           while($r = $this->inDB->fetch_assoc($res)){
              $list_categories[$r['category_id']] = $r['category_id'];
           } 
 
           $this->deleteItem($item_id, false); //удааляем товар БЕЗ упорядочивания (для скорости)
        }
 
        foreach($list_categories as $key=>$category_id) {
           $this->reorderShopCategory($category_id);
        }
 
        return true;
 
    }
 

 
/* ========================================================================== */
/* ========================================================================== */
 
	public function deleteItem($id, $reorder=true){
        //$reorder - говорит о том, надо ли потом делать упорядочивание 
 
        $imageurl   = 'shop'.$id.'.jpg';
 
        @chmod($_SERVER['DOCUMENT_ROOT']."/images/photos/$imageurl", 777);
        @chmod($_SERVER['DOCUMENT_ROOT']."/images/photos/small/$imageurl", 777);
        @chmod($_SERVER['DOCUMENT_ROOT']."/images/photos/medium/$imageurl", 777);
        @chmod($_SERVER['DOCUMENT_ROOT']."/images/photos/group/$imageurl", 777);
 
        @unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/'.$imageurl);
        @unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/small/'.$imageurl);
        @unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/medium/'.$imageurl);
        @unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/group/'.$imageurl);
 
        //удаляем дополнительные изображения
        $files = $this->getItemImages($id);
        $this->dropItemImages($files);
 
 
        $this->inDB->query("DELETE FROM cms_shop_items WHERE id={$id}");
        $this->inDB->query("DELETE FROM cms_shop_items_bind WHERE item_id={$id}");
        $this->inDB->query("DELETE FROM cms_shop_chars_val WHERE item_id={$id}");
        $this->inDB->query("DELETE FROM cms_shop_chars_val WHERE item_id={$id}");
        $this->inDB->query("DELETE FROM cms_tags WHERE target='shop' AND item_id = {$id}");
        $this->inDB->query("DELETE FROM cms_comments WHERE target = 'shop' AND target_id = {$id}");
        $this->inDB->query("DELETE FROM cms_ratings WHERE target = 'shop' AND item_id = {$id}");
 
 
        if($reorder) {
           $this->reorderShopItems($id);
        } else {
           $this->inDB->query("DELETE FROM cms_shop_items_cats WHERE item_id={$id}"); //эта функция вызывается в reorderShopItems, если она вызывается
        }
 
    }
 
 

 
/* ==================================================================================================== */
/* ==================================================================================================== */
 
    public function reorderShopItems($item_id) {
 
        if(!$item_id) return false;
        $sql = "SELECT category_id, item_id FROM cms_shop_items_cats WHERE item_id={$item_id} GROUP BY category_id"; //получаем все категории где встречается товар
        $res = $this->inDB->query($sql);
 
        $this->inDB->query("DELETE FROM cms_shop_items_cats WHERE item_id={$item_id}");
 
        while($r = $this->inDB->fetch_assoc($res)){
            $ord = 1;
 
            $sql2 = "SELECT item_id 
                     FROM cms_shop_items_cats
                     WHERE category_id = {$r['category_id']}
                     ORDER BY ordering";
            $res2 = $this->inDB->query($sql2);
 
            while($r2 = $this->inDB->fetch_assoc($res2)){
                $this->inDB->query("UPDATE cms_shop_items_cats SET ordering = {$ord} WHERE item_id={$r2['item_id']} AND category_id={$r['category_id']}");
                $ord++;
            }
 
        }
 
        return true;
 
    }