public function execute()
 {
     try {
         if ($id = waRequest::post('id')) {
             $price_model = new shopPricePluginModel();
             $price_model->deleteById($id);
             $sql = "ALTER TABLE `shop_product_skus` DROP `price_plugin_" . $price_model->escape($id) . "`";
             $price_model->query($sql);
         }
     } catch (Exception $e) {
         $this->setError($e->getMessage());
     }
 }
Exemplo n.º 2
0
<?php

$price_model = new shopPricePluginModel();
$prices = $price_model->getAll();
try {
    foreach ($prices as $price) {
        $sql = "ALTER TABLE `shop_product_skus` DROP `price_plugin_" . $price_model->escape($price['id']) . "`";
        $price_model->query($sql);
        $price_model->deleteById($price['id']);
    }
} catch (waDbException $e) {
}