rewrite this function to support multistore in PrestaShop: public function deleteorderbyid($id, $return = 0) { if (version_compare('1.7', _PS_VERSION_) <= 0) { $thisorder = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('SELECT id_cart FROM ' . _DB_PREFIX_ . 'orders WHERE id_order = ' . $id); if (isset($thisorder[0])) { $q = 'DELETE a,b FROM ' . _DB_PREFIX_ . 'order_return AS a LEFT JOIN ' . _DB_PREFIX_ . 'order_return_detail AS b ON a.id_order_return = b.id_order_return WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } // deleting order_slip $q = 'DELETE a,b FROM ' . _DB_PREFIX_ . 'order_slip AS a LEFT JOIN ' . _DB_PREFIX_ . 'order_slip_detail AS b ON a.id_order_slip = b.id_order_slip WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'cart_product WHERE id_cart="' . $thisorder[0]['id_cart'] . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_history WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_detail_tax WHERE id_order_detail IN (SELECT id_order_detail FROM ' . _DB_PREFIX_ . 'order_detail WHERE id_order ="' . $id . '")'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_detail WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_payment WHERE order_reference IN (SELECT reference FROM ' . _DB_PREFIX_ . 'orders WHERE id_order="' . $id . '")'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'orders WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_carrier WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_invoice_tax WHERE id_order_invoice IN (SELECT id_order_invoice FROM ' . _DB_PREFIX_ . 'order_invoice WHERE id_order="' . $id . '")'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_invoice WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_invoice_payment WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } $q = 'DELETE FROM ' . _DB_PREFIX_ . 'order_cart_rule WHERE id_order="' . $id . '"'; if (!Db::getInstance()->Execute($q)) { $this->errorlog = $this->l('ERROR'); } if (empty($this->errorlog)) { if ($return == 1) { $this->context->controller->confirmations[] = $this->l('Order deleted'); } else { return $this->l('Order deleted'); } } else { if ($return == 1) { $this->context->controller->errors[] = $this->l('Something wrong'); } else { return $this->l('Something wrong'); } } } else { if ($return == 1) { $this->context->controller->errors[] = $this->l('Order doesnt exists'); } else { return $this->l('Order doesnt exists'); } } } }

function deleteorder($id)
{
    if (version_compare('1.7', _PS_VERSION_) <= 0) {
        $thisorder = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('SELECT id_cart FROM ' . _DB_PREFIX_ . 'orders WHERE id_order = ' . $id);
        if (isset($thisorder[0])) {
            $q = 'DELETE a,b FROM ' . _DB_PREFIX_ . 'order_return AS a LEFT JOIN ' . _DB_PREFIX_ . 'order_return_detail AS b ON a.id_order_return = b.id_order_return WHERE id_order="' . $id . '"';
            if (!Db::getInstance()->Execute($q)) {
                $this->errorlog = $this->l('ERROR');
            }

            // deleting order_slip
            $q = 'DELETE a,b FROM ' . _DB_PREFIX_ . 'order_