2597: $this->recursiveDelete($toDelete, (int) $row['id_category']); 2598: } 2599: } 2600: 2601: /** 2602: * Get all ids of all subcategories of the current category 2603: * 2604: * @since 1.0.0 2605: * @version 1.0.0 Initial version 2606: * @return array list of ids of the subcategories 2607: * @throws PrestaShopDatabaseException 2608: * @throws PrestaShopException 2609: */ 2610: public function getAllSubcategories() 2611: { 2612: return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS( 2613: (new DbQuery()) 2614: ->select('`id_category`') 2615: ->from('category') 2616: ->where('`nleft` > '.$this->nleft.' AND `nright` < '.$this->nright) 2617: ); 2618: } 2619: 2620: /** 2621: * @param $table \CoreUpdater\TableSchema 2622: */ 2623: public static function processTableSchema($table) 2624: { 2625: if ($table->getNameWithoutPrefix() === 'category_lang') { 2626: $table->reorderColumns(['id_category', 'id_shop', 'id_lang']);