public static function getProduct($product_id) { $wpdb = rev_db_class::rev_db_instance(); $sql = "SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id) AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int) $product_id . "' AND pd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int) sdsconfig::get_current_store() . "'"; $query = $wpdb->get_results($sql); if (isset($query) && !empty($query)) { $query = $query[0]; } if (isset($query) && !empty($query)) { $get_mainsite_url = get_mainsite_url(); $img_path = $get_mainsite_url . 'image/'; $lnk = new Url($get_mainsite_url); return array('product_id' => $query['product_id'], 'link' => $lnk->link('product/product', 'product_id=' . $query['product_id']), 'id_product' => $query['product_id'], 'name' => $query['name'], 'description' => $query['description'], 'meta_description' => $query['meta_description'], 'meta_keyword' => $query['meta_keyword'], 'tag' => $query['tag'], 'model' => $query['model'], 'sku' => $query['sku'], 'upc' => $query['upc'], 'ean' => $query['ean'], 'jan' => $query['jan'], 'isbn' => $query['isbn'], 'mpn' => $query['mpn'], 'location' => $query['location'], 'quantity' => $query['quantity'], 'stock_status' => $query['stock_status'], 'image' => $img_path . $query['image'], 'manufacturer_id' => $query['manufacturer_id'], 'manufacturer' => $query['manufacturer'], 'price' => $query['discount'] ? $query['discount'] : $query['price'], 'special' => $query['special'], 'reward' => $query['reward'], 'points' => $query['points'], 'tax_class_id' => $query['tax_class_id'], 'date_available' => $query['date_available'], 'weight' => $query['weight'], 'weight_class_id' => $query['weight_class_id'], 'length' => $query['length'], 'width' => $query['width'], 'height' => $query['height'], 'length_class_id' => $query['length_class_id'], 'subtract' => $query['subtract'], 'rating' => round($query['rating']), 'reviews' => $query['reviews'] ? $query['reviews'] : 0, 'minimum' => $query['minimum'], 'sort_order' => $query['sort_order'], 'status' => $query['status'], 'date_added' => $query['date_added'], 'date_modified' => $query['date_modified'], 'viewed' => $query['viewed']); } else { return false; } }
<?php $layouts = sdsconfig::getLayouts(); $allslides = sdsconfig::getrevslide(); $store_id = (int) sdsconfig::get_current_store(); $pos_modules = sdsconfig::getval('revslideropencart_module', $store_id, 'revslideropencart'); $modules_data = unserialize($pos_modules); $getpositions = array(); require_once dirname(__FILE__) . '/../../position/position.php'; ?> <div class="title_line"> <div class="view_title"> <?php echo ControllerModulerevslideropencart::$lang_var['Setup_Slider_Position']; ?> </div> </div> <div class="postbox"> <form action="<?php //echo $action; ?> " method="post" enctype="multipart/form-data" id="sds_rev_mod_form"> <table id="module" class="list"> <thead> <tr> <td class="left"><?php echo ControllerModulerevslideropencart::$lang_var['SLIDER']; ?> </td>