Example #1
0
    public static function removeProductSale($id_product, $qty = 1)
    {
        $total_sales = ProductSale::getNbrSales($id_product);
        if ($total_sales > 1) {
            return Db::getInstance()->execute('
				UPDATE ' . _DB_PREFIX_ . 'product_sale
				SET `quantity` = `quantity` - ' . (int) $qty . ', `sale_nbr` = `sale_nbr` - 1, `date_upd` = NOW()
				WHERE `id_product` = ' . (int) $id_product);
        } elseif ($total_sales == 1) {
            return Db::getInstance()->delete('product_sale', 'id_product = ' . (int) $id_product);
        }
        return true;
    }