function import_excel()
{
if ($_FILES['fileExcel']['tmp_name']) {
$this->_db =& JFactory::getDBO();
$dom = DOMDocument::load($_FILES['fileExcel']['tmp_name']);
$rows = $dom->getElementsByTagName('Row');
$first_row = 0;
foreach ($rows as $row) {
if ($first_row > 0) {
$id = "";
$name = "";
$price = "";
$index = 1;
$cells = $row->getElementsByTagName('Cell');
foreach ($cells as $cell) {
$key = "";
if ($index == 1) {
$key = 'id';
}
if ($index == 2) {
$key = 'name';
}
if ($index == 3) {
$key = 'price';
}
${$key} = $cell->nodeValue;
$index += 1;
}
$id = intval($id);
$price = doubleval($price);
if ($id && $price) {
$query = "update #__pr_product set price = {$price} where id= {$id}";
$this->_db->setQuery($query);
$this->_db->query();
}
}
$first_row++;
}
die("Đã cap nhat thành công gia cua " . ($first_row - 1) . "san pham");
} else {
parent::display();
}
}
function getDiscount($code)
{
$ec = new EcommerceController();
$promo = $ec->get_promo($code);
if ($promo) {
if ($promo->is_percent == 1) {
return $promo->discount / 100 * $this->getTotal();
} else {
return $promo->discount;
}
} else {
return 0;
}
}
<?php
defined('_JEXEC') or die('Restricted access');
require_once JPATH_COMPONENT . DS . 'controller.php';
JTable::addIncludePath(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ecommerce' . DS . 'tables');
$controller = new EcommerceController();
$controller->execute(JRequest::getVar('task'));
$controller->redirect();
<?php
defined('_JEXEC') or die('Restricted access');
require_once 'components/com_ecommerce/controller.php';
$ecom_config = EcommerceController::getConfig();
require JModuleHelper::getLayoutPath('mod_cart');
function ecommerce_frontend($page)
{
$ec = new EcommerceController();
include 'classes/cart.class.php';
ob_start();
$page->_executeLayout();
$output = ob_get_contents();
ob_end_clean();
$uri_arr = explode('/', $page->url);
if (in_array('products', $uri_arr)) {
$cart = new Cart('shopping_cart');
// search
if (in_array('search', $uri_arr)) {
$keywords = !empty($_GET['keywords']) ? $_GET['keywords'] : '';
$output = str_replace('<!-- ecommerce -->', $ec->products_search($keywords), $output);
}
// cart
if (in_array('cart', $uri_arr)) {
// add item to cart
if (!empty($_POST['variant_id']) && !empty($_POST['quantity'])) {
$quantity = $cart->getItemQuantity($_POST['variant_id']) + $_POST['quantity'];
$cart->setItemQuantity($_POST['variant_id'], $quantity);
}
//update cart item quantity
if (!empty($_POST['quantity'])) {
if (is_array($_POST['quantity'])) {
foreach ($_POST['quantity'] as $variant_id => $quantity) {
$cart->setItemQuantity($variant_id, $quantity);
}
}
}
// remove item from cart
if (!empty($_POST['remove'])) {
foreach ($_POST['remove'] as $variant_id) {
$cart->setItemQuantity($variant_id, 0);
}
}
if (!empty($_POST['variant_id']) || !empty($_POST['quantity']) || !empty($_POST['remove'])) {
$cart->save();
}
$output = str_replace('<!-- ecommerce -->', $cart->display(), $output);
}
// checkout
if (in_array('checkout', $uri_arr)) {
if ($cart->hasItems()) {
$output = str_replace('<!-- ecommerce -->', $ec->checkout(), $output);
} else {
$output = str_replace('<!-- ecommerce -->', '<p>You have no items in your cart.</p>', $output);
}
}
//product display
if (count($uri_arr) == 1) {
// products main page display
$output = str_replace('<!-- ecommerce -->', $ec->products_all(), $output);
} else {
// display products by type
if (in_array('types', $uri_arr)) {
if ($page->slug == 'types') {
$output = str_replace('<!-- ecommerce -->', $ec->product_types_nav(), $output);
} else {
$output = str_replace('<!-- ecommerce -->', $ec->products_by_type($page->slug), $output);
}
} else {
if (in_array('vendors', $uri_arr)) {
$output = str_replace('<!-- ecommerce -->', $ec->products_by_vendor($page->slug), $output);
} else {
$output = str_replace('<!-- ecommerce -->', $ec->product_show($page->slug), $output);
}
}
}
//add cart actions
if ($cart->hasItems()) {
$cart_actions = '<div id="cart-actions"><ul>';
if (!in_array('cart', $uri_arr)) {
$cart_actions .= '<li><a href="/products/cart">View Cart</a></li>';
}
if (!in_array('checkout', $uri_arr) && !in_array('cart', $uri_arr)) {
$cart_actions .= '<li class="last"><a href="https://www.emedamerica.com/products/checkout">Checkout</a></li>';
}
$cart_actions .= '</ul></div>';
$output = str_replace('<!-- ecommerce cart actions -->', $cart_actions, $output);
}
}
// add ecommerce stylesheet to the frontend layout
$output = str_replace('</head>', '<link rel="stylesheet" href="/public/ecommerce/ecommerce.css" type="text/css" /></head>', $output);
//add ecommerce js file
$output = str_replace('</head>', '<script type="text/javascript" charset="utf-8" src="/public/ecommerce/ecommerce.js"></script></head>', $output);
// add flash to the frontend
if ($ec->get_flash()) {
$output = str_replace('<!-- ecommerce flash -->', $ec->get_flash(), $output);
}
// write frontend output
echo $output;
// clear the flash
$_SESSION['ecommerce_flash'] = '';
die;
}
function display()
{
parent::display();
}