function getOutput()
{
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
$output = '<table class="table table-hover">
<thead>
<tr class="info">
<th>' . OSCOM::getDef('module_admin_dashboard_orders_title') . '</th>
<th>' . OSCOM::getDef('module_admin_dashboard_orders_total') . '</th>
<th>' . OSCOM::getDef('module_admin_dashboard_orders_date') . '</th>
<th>' . OSCOM::getDef('module_admin_dashboard_orders_order_status') . '</th>
</tr>
</thead>
<tbody>';
$Qorders = $OSCOM_Db->get(['orders o', 'orders_total ot', 'orders_status s'], ['o.orders_id', 'o.customers_name', 'greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified', 's.orders_status_name', 'ot.text as order_total'], ['o.orders_id' => ['rel' => 'ot.orders_id'], 'ot.class' => 'ot_total', 'o.orders_status' => ['rel' => 's.orders_status_id'], 's.language_id' => $OSCOM_Language->getId()], 'date_last_modified desc', 6);
while ($Qorders->fetch()) {
$output .= ' <tr>
<td><a href="' . OSCOM::link(FILENAME_ORDERS, 'oID=' . $Qorders->valueInt('orders_id') . '&action=edit') . '">' . $Qorders->valueProtected('customers_name') . '</a></td>
<td>' . strip_tags($Qorders->value('order_total')) . '</td>
<td>' . DateTime::toShort($Qorders->value('date_last_modified')) . '</td>
<td>' . $Qorders->value('orders_status_name') . '</td>
</tr>';
}
$output .= ' </tbody>
</table>';
return $output;
}
function getData()
{
global $request_type, $oscTemplate;
$OSCOM_Db = Registry::get('Db');
$data = '';
$Qmanufacturers = $OSCOM_Db->query('select manufacturers_id, manufacturers_name from :table_manufacturers order by manufacturers_name');
$manufacturers = $Qmanufacturers->fetchAll();
if (!empty($manufacturers)) {
if (count($manufacturers) <= MAX_DISPLAY_MANUFACTURERS_IN_A_LIST) {
// Display a list
$manufacturers_list = '<ul class="nav nav-pills nav-stacked">';
foreach ($manufacturers as $m) {
$manufacturers_name = strlen($m['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN ? substr($m['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $m['manufacturers_name'];
if (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] == $m['manufacturers_id']) {
$manufacturers_name = '<strong>' . $manufacturers_name . '</strong>';
}
$manufacturers_list .= '<li><a href="' . OSCOM::link('index.php', 'manufacturers_id=' . (int) $m['manufacturers_id']) . '">' . $manufacturers_name . '</a></li>';
}
$manufacturers_list .= '</ul>';
$data = $manufacturers_list;
} else {
// Display a drop-down
$manufacturers_array = array();
if (MAX_MANUFACTURERS_LIST < 2) {
$manufacturers_array[] = array('id' => '', 'text' => PULL_DOWN_DEFAULT);
}
foreach ($manufacturers as $m) {
$manufacturers_name = strlen($m['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN ? substr($m['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $m['manufacturers_name'];
$manufacturers_array[] = array('id' => $m['manufacturers_id'], 'text' => $manufacturers_name);
}
$data = HTML::form('manufacturers', OSCOM::link('index.php', '', $request_type, false), 'get', null, ['session_id' => true]) . HTML::selectField('manufacturers_id', $manufacturers_array, isset($_GET['manufacturers_id']) ? $_GET['manufacturers_id'] : '', 'onchange="this.form.submit();" size="' . MAX_MANUFACTURERS_LIST . '"') . '</form>';
}
}
return $data;
}
function execute()
{
global $PHP_SELF, $oscTemplate;
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
if (isset($_SESSION['customer_id'])) {
// retreive the last x products purchased
$Qorders = $OSCOM_Db->prepare('select distinct op.products_id from :table_orders o, :table_orders_products op, :table_products p where o.customers_id = :customers_id and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = 1 group by op.products_id order by o.date_purchased desc limit :limit');
$Qorders->bindInt(':customers_id', $_SESSION['customer_id']);
$Qorders->bindInt(':limit', MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX);
$Qorders->execute();
if ($Qorders->fetch() !== false) {
$product_ids = [];
do {
$product_ids[] = $Qorders->valueInt('products_id');
} while ($Qorders->fetch());
$customer_orders_string = null;
$Qproducts = $OSCOM_Db->prepare('select products_id, products_name from :table_products_description where products_id in (' . implode(', ', $product_ids) . ') and language_id = :language_id order by products_name');
$Qproducts->bindInt(':language_id', $OSCOM_Language->getId());
$Qproducts->execute();
while ($Qproducts->fetch()) {
$customer_orders_string .= '<li><span class="pull-right"><a href="' . OSCOM::link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=cust_order&pid=' . $Qproducts->valueInt('products_id')) . '"><span class="fa fa-shopping-cart"></span></a></span><a href="' . OSCOM::link('product_info.php', 'products_id=' . $Qproducts->valueInt('products_id')) . '">' . $Qproducts->value('products_name') . '</a></li>';
}
ob_start();
include 'includes/modules/boxes/templates/order_history.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
}
}
function pass()
{
$backup_directory = OSCOM::getConfig('dir_root') . 'includes/backups/';
$backup_file = null;
if (is_dir($backup_directory)) {
$dir = dir($backup_directory);
$contents = array();
while ($file = $dir->read()) {
if (!is_dir($backup_directory . $file)) {
$ext = substr($file, strrpos($file, '.') + 1);
if (in_array($ext, array('zip', 'sql', 'gz')) && !isset($contents[$ext])) {
$contents[$ext] = $file;
if ($ext != 'sql') {
// zip and gz (binaries) are prioritized over sql (plain text)
break;
}
}
}
}
if (isset($contents['zip'])) {
$backup_file = $contents['zip'];
} elseif (isset($contents['gz'])) {
$backup_file = $contents['gz'];
} elseif (isset($contents['sql'])) {
$backup_file = $contents['sql'];
}
}
$result = true;
if (isset($backup_file)) {
$request = $this->getHttpRequest(OSCOM::link('includes/backups/' . $backup_file));
$result = $request['http_code'] != 200;
}
return $result;
}
function execute()
{
global $current_category_id, $oscTemplate;
$OSCOM_Db = Registry::get('Db');
if (!isset($_GET['products_id'])) {
if (isset($current_category_id) && $current_category_id > 0) {
$sql = 'select distinct p.products_id, pd.products_name from :table_products p, :table_products_description pd, :table_products_to_categories p2c, :table_categories c where p.products_status = 1 and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and :category_id in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit :limit';
} else {
$sql = 'select distinct p.products_id, pd.products_name from :table_products p, :table_products_description pd where p.products_status = 1 and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = :language_id order by p.products_ordered desc, pd.products_name limit :limit';
}
$Qbest = $OSCOM_Db->prepare($sql);
$Qbest->bindInt(':language_id', $_SESSION['languages_id']);
if (isset($current_category_id) && $current_category_id > 0) {
$Qbest->bindInt(':category_id', $current_category_id);
}
$Qbest->bindInt(':limit', MAX_DISPLAY_BESTSELLERS);
$Qbest->execute();
$best = $Qbest->fetchAll();
if (count($best) >= MIN_DISPLAY_BESTSELLERS) {
$bestsellers_list = '';
foreach ($best as $b) {
$bestsellers_list .= '<li><a href="' . OSCOM::link('product_info.php', 'products_id=' . $b['products_id']) . '">' . $b['products_name'] . '</a></li>';
}
ob_start();
include 'includes/modules/boxes/templates/best_sellers.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
}
}
function confirm()
{
$OSCOM_Db = Registry::get('Db');
$Qmail = $OSCOM_Db->get('customers', 'count(*) as count', ['customers_newsletter' => '1']);
$confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" . ' <tr>' . "\n" . ' <td class="main"><font color="#ff0000"><strong>' . OSCOM::getDef('text_count_customers', ['count' => $Qmail->valueInt('count')]) . '</strong></font></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td> </td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main"><strong>' . $this->title . '</strong></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td> </td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main">' . "\n" . ' <ul class="nav nav-tabs" role="tablist">' . "\n" . ' <li role="presentation" class="active"><a href="#html_preview" aria-controls="html_preview" role="tab" data-toggle="tab">' . OSCOM::getDef('email_type_html') . '</a></li>' . "\n" . ' <li role="presentation"><a href="#plain_preview" aria-controls="plain_preview" role="tab" data-toggle="tab">' . OSCOM::getDef('email_type_plain') . '</a></li>' . "\n" . ' </ul>' . "\n" . ' <div class="tab-content">' . "\n" . ' <div role="tabpanel" class="tab-pane active" id="html_preview">' . "\n" . ' <iframe id="emailHtmlPreviewContent" style="width: 100%; height: 400px; border: 0;"></iframe>' . "\n" . ' <script id="emailHtmlPreview" type="x-tmpl-mustache">' . "\n" . ' ' . HTML::outputProtected($this->content_html) . "\n" . ' </script>' . "\n" . ' <script>' . "\n" . ' $(function() {' . "\n" . ' var content = $(\'<div />\').html($(\'#emailHtmlPreview\').html()).text();' . "\n" . ' $(\'#emailHtmlPreviewContent\').contents().find(\'html\').html(content);' . "\n" . ' });' . "\n" . ' </script>' . "\n" . ' </div>' . "\n" . ' <div role="tabpanel" class="tab-pane" id="plain_preview">' . "\n" . ' ' . nl2br(HTML::outputProtected($this->content)) . "\n" . ' </div>' . "\n" . ' </div>' . "\n" . ' </td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td> </td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="smallText" align="right">' . HTML::button(OSCOM::getDef('image_send'), 'fa fa-envelope', OSCOM::link(FILENAME_NEWSLETTERS, 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'] . '&action=confirm_send')) . HTML::button(OSCOM::getDef('image_cancel'), 'fa fa-close', OSCOM::link(FILENAME_NEWSLETTERS, 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'])) . '</td>' . "\n" . ' </tr>' . "\n" . '</table>';
return $confirm_string;
}
function execute()
{
global $oscTemplate;
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
if (isset($_GET['products_id'])) {
$Qmanufacturer = $OSCOM_Db->prepare('select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from :table_manufacturers m left join :table_manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id), :table_products p where p.products_id = :products_id and p.manufacturers_id = m.manufacturers_id');
$Qmanufacturer->bindInt(':languages_id', $OSCOM_Language->getId());
$Qmanufacturer->bindInt(':products_id', $_GET['products_id']);
$Qmanufacturer->execute();
if ($Qmanufacturer->fetch() !== false) {
$manufacturer_info_string = null;
if (!empty($Qmanufacturer->value('manufacturers_image'))) {
$manufacturer_info_string .= '<div>' . HTML::image(OSCOM::linkImage($Qmanufacturer->value('manufacturers_image')), $Qmanufacturer->value('manufacturers_name')) . '</div>';
}
if (!empty($Qmanufacturer->value('manufacturers_url'))) {
$manufacturer_info_string .= '<div class="text-center"><a href="' . OSCOM::link('redirect.php', 'action=manufacturer&manufacturers_id=' . $Qmanufacturer->valueInt('manufacturers_id')) . '" target="_blank">' . OSCOM::getDef('module_boxes_manufacturer_info_box_homepage', ['manufacturers_name' => $Qmanufacturer->value('manufacturers_name')]) . '</a></div>';
}
ob_start();
include 'includes/modules/boxes/templates/manufacturer_info.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
}
}
function execute()
{
global $new_products_id_in_cart, $currencies, $oscTemplate;
$cart_contents_string = '';
if ($_SESSION['cart']->count_contents() > 0) {
$cart_contents_string = '<ul class="list-unstyled">';
$products = $_SESSION['cart']->get_products();
for ($i = 0, $n = sizeof($products); $i < $n; $i++) {
$cart_contents_string .= '<li';
if (isset($_SESSION['new_products_id_in_cart']) && $new_products_id_in_cart == $products[$i]['id']) {
$cart_contents_string .= ' class="newItemInCart"';
}
$cart_contents_string .= '>';
$cart_contents_string .= $products[$i]['quantity'] . ' x ';
$cart_contents_string .= '<a href="' . OSCOM::link('product_info.php', 'products_id=' . $products[$i]['id']) . '">';
$cart_contents_string .= $products[$i]['name'];
$cart_contents_string .= '</a></li>';
if (isset($_SESSION['new_products_id_in_cart']) && $new_products_id_in_cart == $products[$i]['id']) {
unset($_SESSION['new_products_id_in_cart']);
}
}
$cart_contents_string .= '</ul>';
$cart_footer_string = '<div class="panel-footer text-right">' . $currencies->format($_SESSION['cart']->show_total()) . '</div>';
} else {
$cart_contents_string .= '<p>' . MODULE_BOXES_SHOPPING_CART_BOX_CART_EMPTY . '</p>';
$cart_footer_string = NULL;
}
ob_start();
include 'includes/modules/boxes/templates/shopping_cart.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
public function execute()
{
global $login_customer_id;
$OSCOM_Db = Registry::get('Db');
if (is_int($login_customer_id) && $login_customer_id > 0) {
if (SESSION_RECREATE == 'True') {
tep_session_recreate();
}
$Qcustomer = $OSCOM_Db->prepare('select c.customers_firstname, c.customers_default_address_id, ab.entry_country_id, ab.entry_zone_id from :table_customers c left join :table_address_book ab on (c.customers_id = ab.customers_id and c.customers_default_address_id = ab.address_book_id) where c.customers_id = :customers_id');
$Qcustomer->bindInt(':customers_id', $login_customer_id);
$Qcustomer->execute();
$_SESSION['customer_id'] = $login_customer_id;
$_SESSION['customer_default_address_id'] = $Qcustomer->valueInt('customers_default_address_id');
$_SESSION['customer_first_name'] = $Qcustomer->value('customers_firstname');
$_SESSION['customer_country_id'] = $Qcustomer->valueInt('entry_country_id');
$_SESSION['customer_zone_id'] = $Qcustomer->valueInt('entry_zone_id');
$Qupdate = $OSCOM_Db->prepare('update :table_customers_info set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1, password_reset_key = null, password_reset_date = null where customers_info_id = :customers_info_id');
$Qupdate->bindInt(':customers_info_id', $_SESSION['customer_id']);
$Qupdate->execute();
// reset session token
$_SESSION['sessiontoken'] = md5(tep_rand() . tep_rand() . tep_rand() . tep_rand());
// restore cart contents
$_SESSION['cart']->restore_contents();
if (count($_SESSION['navigation']->snapshot) > 0) {
$origin_href = OSCOM::link($_SESSION['navigation']->snapshot['page'], tep_array_to_string($_SESSION['navigation']->snapshot['get'], array(session_name())), $_SESSION['navigation']->snapshot['mode']);
$_SESSION['navigation']->clear_snapshot();
HTTP::redirect($origin_href);
}
OSCOM::redirect('index.php');
}
}
function execute()
{
global $new_products_id_in_cart, $currencies, $oscTemplate;
$cart_contents_string = '';
if ($_SESSION['cart']->count_contents() > 0) {
$cart_contents_string = NULL;
$products = $_SESSION['cart']->get_products();
for ($i = 0, $n = sizeof($products); $i < $n; $i++) {
$cart_contents_string .= '<li';
if (isset($_SESSION['new_products_id_in_cart']) && $new_products_id_in_cart == $products[$i]['id']) {
$cart_contents_string .= ' class="newItemInCart"';
}
$cart_contents_string .= '>';
$cart_contents_string .= $products[$i]['quantity'] . ' x ';
$cart_contents_string .= '<a href="' . OSCOM::link('product_info.php', 'products_id=' . $products[$i]['id']) . '">';
$cart_contents_string .= $products[$i]['name'];
$cart_contents_string .= '</a></li>';
if (isset($_SESSION['new_products_id_in_cart']) && $new_products_id_in_cart == $products[$i]['id']) {
unset($_SESSION['new_products_id_in_cart']);
}
}
$cart_contents_string .= '<li class="text-right"><hr>' . $currencies->format($_SESSION['cart']->show_total()) . '</li>';
} else {
$cart_contents_string .= '<p>' . OSCOM::getDef('module_boxes_shopping_cart_box_cart_empty') . '</p>';
}
ob_start();
include 'includes/modules/boxes/templates/shopping_cart.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
function getOutput()
{
$button_height = (int) MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_HEIGHT;
if (MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_ANNOTATION == 'Vertical-Bubble') {
$button_height = 60;
}
$output = '<div class="g-plus" data-action="share" data-href="' . OSCOM::link('product_info.php', 'products_id=' . $_GET['products_id'], false) . '" data-annotation="' . strtolower(MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_ANNOTATION) . '"';
if ((int) MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_WIDTH > 0) {
$output .= ' data-width="' . (int) MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_WIDTH . '"';
}
$output .= ' data-height="' . $button_height . '" data-align="' . strtolower(MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_SHARE_ALIGN) . '"></div>';
$output .= '<script>
if ( typeof window.___gcfg == "undefined" ) {
window.___gcfg = { };
}
if ( typeof window.___gcfg.lang == "undefined" ) {
window.___gcfg.lang = "' . HTML::outputProtected($this->lang->get('code')) . '";
}
(function() {
var po = document.createElement(\'script\'); po.type = \'text/javascript\'; po.async = true;
po.src = \'https://apis.google.com/js/plusone.js\';
var s = document.getElementsByTagName(\'script\')[0]; s.parentNode.insertBefore(po, s);
})();
</script>';
return $output;
}
function getOutput()
{
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
$output = '<table class="table table-hover">
<thead>
<tr class="info">
<th>' . OSCOM::getDef('module_admin_dashboard_reviews_title') . '</th>
<th>' . OSCOM::getDef('module_admin_dashboard_reviews_date') . '</th>
<th>' . OSCOM::getDef('module_admin_dashboard_reviews_reviewer') . '</th>
<th class="text-right">' . OSCOM::getDef('module_admin_dashboard_reviews_rating') . '</th>
<th class="text-right">' . OSCOM::getDef('module_admin_dashboard_reviews_review_status') . '</th>
</tr>
</thead>
<tbody>';
$Qreviews = $OSCOM_Db->get(['reviews r', 'products_description pd'], ['r.reviews_id', 'r.date_added', 'pd.products_name', 'r.customers_name', 'r.reviews_rating', 'r.reviews_status'], ['pd.products_id' => ['rel' => 'r.products_id'], 'pd.language_id' => $OSCOM_Language->getId()], 'r.date_added desc', 6);
while ($Qreviews->fetch()) {
$output .= ' <tr>
<td><a href="' . OSCOM::link(FILENAME_REVIEWS, 'rID=' . $Qreviews->valueInt('reviews_id') . '&action=edit') . '">' . $Qreviews->value('products_name') . '</a></td>
<td>' . DateTime::toShort($Qreviews->value('date_added')) . '</td>
<td>' . $Qreviews->valueProtected('customers_name') . '</td>
<td class="text-right">' . str_repeat('<i class="fa fa-star text-info"></i>', $Qreviews->valueInt('reviews_rating')) . str_repeat('<i class="fa fa-star-o"></i>', 5 - $Qreviews->valueInt('reviews_rating')) . '</td>
<td class="text-right"><i class="fa fa-circle ' . ($Qreviews->valueInt('reviews_status') === 1 ? 'text-success' : 'text-danger') . '"></i></td>
</tr>';
}
$output .= ' </tbody>
</table>';
return $output;
}
function getOutput()
{
global $lng;
if (!isset($lng) || isset($lng) && !is_object($lng)) {
$lng = new language();
}
foreach ($lng->catalog_languages as $lkey => $lvalue) {
if ($lvalue['id'] == $_SESSION['languages_id']) {
$language_code = $lkey;
break;
}
}
$output = '<div class="g-plusone" data-href="' . OSCOM::link('product_info.php', 'products_id=' . $_GET['products_id'], 'NONSSL', false) . '" data-size="' . strtolower(MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_ONE_SIZE) . '" data-annotation="' . strtolower(MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_ONE_ANNOTATION) . '"';
if (MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_ONE_ANNOTATION == 'Inline') {
$output .= ' data-width="' . (int) MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_ONE_WIDTH . '" data-align="' . strtolower(MODULE_SOCIAL_BOOKMARKS_GOOGLE_PLUS_ONE_ALIGN) . '"';
}
$output .= '></div>';
$output .= '<script>
if ( typeof window.___gcfg == "undefined" ) {
window.___gcfg = { };
}
if ( typeof window.___gcfg.lang == "undefined" ) {
window.___gcfg.lang = "' . tep_output_string_protected($language_code) . '";
}
(function() {
var po = document.createElement(\'script\'); po.type = \'text/javascript\'; po.async = true;
po.src = \'https://apis.google.com/js/plusone.js\';
var s = document.getElementsByTagName(\'script\')[0]; s.parentNode.insertBefore(po, s);
})();
</script>';
return $output;
}
function getOutput()
{
$style = MODULE_SOCIAL_BOOKMARKS_FACEBOOK_LIKE_STYLE == 'Standard' ? 'standard' : 'button_count';
$faces = MODULE_SOCIAL_BOOKMARKS_FACEBOOK_LIKE_FACES == 'True' ? 'true' : 'false';
$width = MODULE_SOCIAL_BOOKMARKS_FACEBOOK_LIKE_WIDTH;
$action = MODULE_SOCIAL_BOOKMARKS_FACEBOOK_LIKE_VERB == 'Like' ? 'like' : 'recommend';
$scheme = MODULE_SOCIAL_BOOKMARKS_FACEBOOK_LIKE_SCHEME == 'Light' ? 'light' : 'dark';
return '<iframe src="http://www.facebook.com/plugins/like.php?href=' . urlencode(OSCOM::link('product_info.php', 'products_id=' . $_GET['products_id'], 'NONSSL', false)) . '&layout=' . $style . '&show_faces=' . $faces . '&width=' . $width . '&action=' . $action . '&colorscheme=' . $scheme . '&height=35" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:' . $width . 'px; height:35px;" allowTransparency="true"></iframe>';
}
function execute()
{
global $request_type, $oscTemplate;
$form_output = HTML::form('quick_find', OSCOM::link('advanced_search_result.php', '', $request_type, false), 'get', null, ['session_id' => true]) . '<div class="input-group">' . HTML::inputField('keywords', '', 'required aria-required="true" placeholder="' . TEXT_SEARCH_PLACEHOLDER . '"', 'search') . '<span class="input-group-btn"><button type="submit" class="btn btn-search"><i class="glyphicon glyphicon-search"></i></button></span></div>' . HTML::hiddenField('search_in_description', '0') . '</form>';
ob_start();
include 'includes/modules/boxes/templates/search.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
function getOutput()
{
$OSCOM_Db = Registry::get('Db');
$days = array();
for ($i = 0; $i < 7; $i++) {
$days[date('Y-m-d', strtotime('-' . $i . ' days'))] = 0;
}
$Qorders = $OSCOM_Db->query('select date_format(customers_info_date_account_created, "%Y-%m-%d") as dateday, count(*) as total from :table_customers_info where date_sub(curdate(), interval 7 day) <= customers_info_date_account_created group by dateday');
while ($Qorders->fetch()) {
$days[$Qorders->value('dateday')] = $Qorders->value('total');
}
$days = array_reverse($days, true);
$chart_label = HTML::output(OSCOM::getDef('module_admin_dashboard_total_customers_chart_link'));
$chart_label_link = OSCOM::link(FILENAME_CUSTOMERS);
$data_labels = json_encode(array_keys($days));
$data = json_encode(array_values($days));
$output = <<<EOD
<h5 class="text-center"><a href="{$chart_label_link}">{$chart_label}</a></h5>
<div id="d_total_customers"></div>
<script>
\$(function() {
var data = {
labels: {$data_labels},
series: [ {$data} ]
};
var options = {
fullWidth: true,
height: '200px',
showPoint: false,
showArea: true,
axisY: {
labelInterpolationFnc: function skipLabels(value, index) {
return index % 2 === 0 ? value : null;
}
}
}
var chart = new Chartist.Line('#d_total_customers', data, options);
chart.on('draw', function(context) {
if (context.type === 'line') {
context.element.attr({
style: 'stroke: green;'
});
} else if (context.type === 'area') {
context.element.attr({
style: 'fill: green;'
});
}
});
});
</script>
EOD;
return $output;
}
public function getImage($language_code, $width = null, $height = null)
{
if (!isset($width) || !is_int($width)) {
$width = 16;
}
if (!isset($height) || !is_int($height)) {
$height = 12;
}
return HTML::image(OSCOM::link('Shop/public/third_party/flag-icon-css/flags/4x3/' . $this->get('image', $language_code) . '.svg', null, false), $this->get('name', $language_code), $width, $height);
}
function execute()
{
global $PHP_SELF, $oscTemplate;
$OSCOM_Db = Registry::get('Db');
$OSCOM_Language = Registry::get('Language');
if (basename($PHP_SELF) == 'product_info.php') {
$Qproduct = $OSCOM_Db->prepare('select
p.products_id,
pd.products_name,
pd.products_description,
p.products_image,
p.products_price,
p.products_quantity,
p.products_tax_class_id,
p.products_date_available
from
:table_products p,
:table_products_description pd
where
p.products_id = :products_id
and p.products_status = 1
and p.products_id = pd.products_id
and pd.language_id = :language_id');
$Qproduct->bindInt(':products_id', $_GET['products_id']);
$Qproduct->bindInt(':language_id', $OSCOM_Language->getId());
$Qproduct->execute();
if ($Qproduct->fetch() !== false) {
$data = array('og:type' => 'product', 'og:title' => $Qproduct->value('products_name'), 'og:site_name' => STORE_NAME);
$product_description = substr(trim(preg_replace('/\\s\\s+/', ' ', strip_tags($Qproduct->value('products_description')))), 0, 197) . '...';
$data['og:description'] = $product_description;
$products_image = $Qproduct->value('products_image');
$Qimage = $OSCOM_Db->get('products_images', 'image', ['products_id' => $Qproduct->valueInt('products_id')], 'sort_order', 1);
if ($Qimage->fetch() !== false) {
$products_image = $Qimage->value('image');
}
$data['og:image'] = OSCOM::linkImage($products_image);
if ($new_price = tep_get_products_special_price($Qproduct->valueInt('products_id'))) {
$products_price = $this->format_raw($new_price);
} else {
$products_price = $this->format_raw($Qproduct->value('products_price'));
}
$data['product:price:amount'] = $products_price;
$data['product:price:currency'] = $_SESSION['currency'];
$data['og:url'] = OSCOM::link('product_info.php', 'products_id=' . $Qproduct->valueInt('products_id'), false);
$data['product:availability'] = $Qproduct->valueInt('products_quantity') > 0 ? OSCOM::getDef('module_header_tags_product_opengraph_text_in_stock') : OSCOM::getDef('module_header_tags_product_opengraph_text_out_of_stock');
$result = '';
foreach ($data as $key => $value) {
$result .= '<meta property="' . HTML::outputProtected($key) . '" content="' . HTML::outputProtected($value) . '" />' . PHP_EOL;
}
$oscTemplate->addBlock($result, $this->group);
}
}
}
function execute()
{
global $PHP_SELF, $oscTemplate, $currencies;
$OSCOM_Db = Registry::get('Db');
if ($PHP_SELF == 'product_info.php' && isset($_GET['products_id'])) {
$Qproduct = $OSCOM_Db->prepare('select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_date_available from :table_products p, :table_products_description pd where p.products_id = :products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id');
$Qproduct->bindInt(':products_id', $_GET['products_id']);
$Qproduct->bindInt(':language_id', $_SESSION['languages_id']);
$Qproduct->execute();
if ($Qproduct->fetch() !== false) {
$data = array('card' => 'product', 'title' => $Qproduct->value('products_name'));
if (tep_not_null(MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_SITE_ID)) {
$data['site'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_SITE_ID;
}
if (tep_not_null(MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_USER_ID)) {
$data['creator'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_USER_ID;
}
$product_description = substr(trim(preg_replace('/\\s\\s+/', ' ', strip_tags($Qproduct->value('products_description')))), 0, 197);
if (strlen($product_description) == 197) {
$product_description .= ' ..';
}
$data['description'] = $product_description;
$products_image = $Qproduct->value('products_image');
$Qimage = $OSCOM_Db->get('products_images', 'image', ['products_id' => $Qproduct->valueInt('products_id')], 'sort_order', 1);
if ($Qimage->fetch() !== false) {
$products_image = $Qimage->value('image');
}
$data['image:src'] = OSCOM::link(DIR_WS_IMAGES . $products_image, '', 'NONSSL', false, false);
if ($new_price = tep_get_products_special_price($Qproduct->valueInt('products_id'))) {
$products_price = $currencies->display_price($new_price, tep_get_tax_rate($Qproduct->valueInt('products_tax_class_id')));
} else {
$products_price = $currencies->display_price($Qproduct->value('products_price'), tep_get_tax_rate($Qproduct->valueInt('products_tax_class_id')));
}
$data['data1'] = $products_price;
$data['label1'] = $_SESSION['currency'];
if ($Qproduct->value('products_date_available') > date('Y-m-d H:i:s')) {
$data['data2'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_TEXT_PRE_ORDER;
$data['label2'] = tep_date_short($Qproduct->value('products_date_available'));
} elseif ($Qproduct->valueInt('products_quantity') > 0) {
$data['data2'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_TEXT_IN_STOCK;
$data['label2'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_TEXT_BUY_NOW;
} else {
$data['data2'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_TEXT_OUT_OF_STOCK;
$data['label2'] = MODULE_HEADER_TAGS_TWITTER_PRODUCT_CARD_TEXT_CONTACT_US;
}
$result = '';
foreach ($data as $key => $value) {
$result .= '<meta name="twitter:' . tep_output_string_protected($key) . '" content="' . tep_output_string_protected($value) . '" />' . "\n";
}
$oscTemplate->addBlock($result, $this->group);
}
}
}
function execute()
{
global $PHP_SELF, $cPath, $oscTemplate;
if (basename($PHP_SELF) == 'product_info.php') {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('product_info.php', 'products_id=' . (int) $_GET['products_id'], 'NONSSL', false) . '" />' . "\n", $this->group);
} elseif (basename($PHP_SELF) == 'index.php') {
if (isset($cPath) && tep_not_null($cPath)) {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('index.php', 'cPath=' . $cPath, 'NONSSL', false) . '" />' . "\n", $this->group);
} elseif (isset($_GET['manufacturers_id']) && tep_not_null($_GET['manufacturers_id'])) {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('index.php', 'manufacturers_id=' . (int) $_GET['manufacturers_id'], 'NONSSL', false) . '" />' . "\n", $this->group);
}
}
}
function execute()
{
global $oscTemplate;
$content_width = MODULE_CONTENT_CUSTOMER_GREETING_CONTENT_WIDTH;
if (isset($_SESSION['customer_id'])) {
$customer_greeting = OSCOM::getDef('module_content_customer_greeting_personal', ['customer_first_name' => HTML::outputProtected($_SESSION['customer_first_name']), 'products_new_link' => OSCOM::link('products_new.php')]);
} else {
$customer_greeting = OSCOM::getDef('module_content_customer_greeting_guest', ['guest_login_link' => OSCOM::link('login.php'), 'guest_create_account_link' => OSCOM::link('create_account.php')]);
}
ob_start();
include 'includes/modules/content/' . $this->group . '/templates/customer_greeting.php';
$template = ob_get_clean();
$oscTemplate->addContent($template, $this->group);
}
function execute()
{
global $oscTemplate;
$content_width = (int) MODULE_CONTENT_FOOTER_ACCOUNT_CONTENT_WIDTH;
if (isset($_SESSION['customer_id'])) {
$account_content = '<li><a href="' . OSCOM::link('account.php', '', 'SSL') . '">' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_ACCOUNT . '</a></li>' . '<li><a href="' . OSCOM::link('address_book.php', '', 'SSL') . '">' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_ADDRESS_BOOK . '</a></li>' . '<li><a href="' . OSCOM::link('account_history.php', '', 'SSL') . '">' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_ORDER_HISTORY . '</a></li>' . '<li><br><a class="btn btn-danger btn-sm btn-block" role="button" href="' . OSCOM::link('logoff.php', '', 'SSL') . '"><i class="glyphicon glyphicon-log-out"></i> ' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_LOGOFF . '</a></li>';
} else {
$account_content = '<li><a href="' . OSCOM::link('create_account.php', '', 'SSL') . '">' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_CREATE_ACCOUNT . '</a></li>' . '<li><br><a class="btn btn-success btn-sm btn-block" role="button" href="' . OSCOM::link('login.php', '', 'SSL') . '"><i class="glyphicon glyphicon-log-in"></i> ' . MODULE_CONTENT_FOOTER_ACCOUNT_BOX_LOGIN . '</a></li>';
}
ob_start();
include DIR_WS_MODULES . 'content/' . $this->group . '/templates/account.php';
$template = ob_get_clean();
$oscTemplate->addContent($template, $this->group);
}
function execute()
{
global $oscTemplate;
$content_width = MODULE_CONTENT_HEADER_SEARCH_CONTENT_WIDTH;
$search_box = '<div class="searchbox-margin">';
$search_box .= HTML::form('quick_find', OSCOM::link('advanced_search_result.php', '', false), 'get', 'class="form-horizontal"', ['session_id' => true]);
$search_box .= ' <div class="input-group">' . HTML::inputField('keywords', '', 'required placeholder="' . OSCOM::getDef('text_search_placeholder') . '"', 'search') . '<span class="input-group-btn"><button type="submit" class="btn btn-info"><i class="fa fa-search"></i></button></span>' . ' </div>';
$search_box .= '</form>';
$search_box .= '</div>';
ob_start();
include 'includes/modules/content/' . $this->group . '/templates/search.php';
$template = ob_get_clean();
$oscTemplate->addContent($template, $this->group);
}
function execute()
{
global $oscTemplate;
$content_width = (int) MODULE_CONTENT_FOOTER_ACCOUNT_CONTENT_WIDTH;
if (isset($_SESSION['customer_id'])) {
$account_content = '<li><a href="' . OSCOM::link('account.php') . '">' . OSCOM::getDef('module_content_footer_account_box_account') . '</a></li>' . '<li><a href="' . OSCOM::link('address_book.php') . '">' . OSCOM::getDef('module_content_footer_account_box_address_book') . '</a></li>' . '<li><a href="' . OSCOM::link('account_history.php') . '">' . OSCOM::getDef('module_content_footer_account_box_order_history') . '</a></li>' . '<li><br><a class="btn btn-danger btn-sm btn-block" role="button" href="' . OSCOM::link('logoff.php') . '"><i class="fa fa-sign-out"></i> ' . OSCOM::getDef('module_content_footer_account_box_logoff') . '</a></li>';
} else {
$account_content = '<li><a href="' . OSCOM::link('create_account.php') . '">' . OSCOM::getDef('module_content_footer_account_box_create_account') . '</a></li>' . '<li><br><a class="btn btn-success btn-sm btn-block" role="button" href="' . OSCOM::link('login.php') . '"><i class="fa fa-sign-in"></i> ' . OSCOM::getDef('module_content_footer_account_box_login') . '</a></li>';
}
ob_start();
include 'includes/modules/content/' . $this->group . '/templates/account.php';
$template = ob_get_clean();
$oscTemplate->addContent($template, $this->group);
}
function execute()
{
global $PHP_SELF, $oscTemplate;
if (substr(basename($PHP_SELF), 0, 8) != 'checkout') {
$languages = $this->lang->getAll();
$languages_string = '';
foreach ($languages as $code => $value) {
$languages_string .= ' <a href="' . OSCOM::link($PHP_SELF, tep_get_all_get_params(array('language', 'currency')) . 'language=' . $code) . '">' . $this->lang->getImage($value['code']) . '</a> ';
}
ob_start();
include 'includes/modules/boxes/templates/languages.php';
$data = ob_get_clean();
$oscTemplate->addBlock($data, $this->group);
}
}
function execute()
{
global $oscTemplate;
$message = OSCOM::getDef('module_header_tags_cookie_message_text');
$dismiss = OSCOM::getDef('module_header_tags_cookie_dismiss_text');
$more = OSCOM::getDef('module_header_tags_cookie_more_text');
$link = OSCOM::link(MODULE_HEADER_TAGS_COOKIE_PAGE);
$theme = OSCOM::link('ext/cookieconsent2/' . MODULE_HEADER_TAGS_COOKIE_THEME . '.css', null, false);
$script_src = OSCOM::link('ext/cookieconsent2/cookieconsent.min.js', null, false);
$output = <<<EOD
<script>window.cookieconsent_options = {"message":"{$message}", "dismiss":"{$dismiss}", "learnMore":"{$more}", "link":"{$link}", "theme":"{$theme}"};</script>
<script src="{$script_src}"></script>
EOD;
$oscTemplate->addBlock($output . "\n", $this->group);
}
protected function _buildBranch($parent_id, $level = 0)
{
$result = $level === 0 && $this->parent_group_apply_to_root === true || $level > 0 ? $this->parent_group_start_string : null;
if (isset($this->_data[$parent_id])) {
foreach ($this->_data[$parent_id] as $category_id => $category) {
if ($this->breadcrumb_usage === true) {
$category_link = $this->buildBreadcrumb($category_id);
} else {
$category_link = $category_id;
}
$result .= $this->child_start_string;
if (isset($this->_data[$category_id])) {
$result .= $this->parent_start_string;
}
if ($level === 0) {
$result .= $this->root_start_string;
}
if ($this->follow_cpath === true && in_array($category_id, $this->cpath_array)) {
$link_title = $this->cpath_start_string . $category['name'] . $this->cpath_end_string;
} else {
$link_title = $category['name'];
}
$result .= '<a href="' . OSCOM::link('index.php', 'cPath=' . $category_link) . '">';
$result .= str_repeat($this->spacer_string, $this->spacer_multiplier * $level);
$result .= $link_title . '</a>';
if ($level === 0) {
$result .= $this->root_end_string;
}
if (isset($this->_data[$category_id])) {
$result .= $this->parent_end_string;
}
if (isset($this->_data[$category_id]) && ($this->max_level == '0' || $this->max_level > $level + 1)) {
if ($this->follow_cpath === true) {
if (in_array($category_id, $this->cpath_array)) {
$result .= $this->_buildBranch($category_id, $level + 1);
}
} else {
$result .= $this->_buildBranch($category_id, $level + 1);
}
}
$result .= $this->child_end_string;
}
}
$result .= $level === 0 && $this->parent_group_apply_to_root === true || $level > 0 ? $this->parent_group_end_string : null;
return $result;
}
function getOutput()
{
$params = array('url=' . urlencode(OSCOM::link('product_info.php', 'products_id=' . $_GET['products_id'], 'NONSSL', false)));
if (strlen(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_ACCOUNT) > 0) {
$params[] = 'via=' . urlencode(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_ACCOUNT);
}
if (strlen(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_RELATED_ACCOUNT) > 0) {
$params[] = 'related=' . urlencode(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_RELATED_ACCOUNT) . (strlen(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_RELATED_ACCOUNT_DESC) > 0 ? ':' . urlencode(MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_RELATED_ACCOUNT_DESC) : '');
}
if (MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_COUNT_POSITION == 'Vertical') {
$params[] = 'count=vertical';
} elseif (MODULE_SOCIAL_BOOKMARKS_TWITTER_BUTTON_COUNT_POSITION == 'None') {
$params[] = 'count=none';
}
$params = implode('&', $params);
return '<script src="http://platform.twitter.com/widgets.js" type="text/javascript"></script><a href="http://twitter.com/share?' . $params . '" target="_blank" class="twitter-share-button">' . tep_output_string_protected($this->public_title) . '</a>';
}
function execute()
{
global $PHP_SELF, $cPath, $oscTemplate, $category_depth;
if (basename($PHP_SELF) == 'product_info.php') {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('product_info.php', 'products_id=' . (int) $_GET['products_id'], false) . '" />' . "\n", $this->group);
} elseif (basename($PHP_SELF) == 'index.php') {
if (isset($cPath) && tep_not_null($cPath) && $category_depth == 'products') {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('index.php', 'view=all&cPath=' . $cPath, false) . '" />' . "\n", $this->group);
} elseif (isset($_GET['manufacturers_id']) && tep_not_null($_GET['manufacturers_id'])) {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link('index.php', 'view=all&manufacturers_id=' . (int) $_GET['manufacturers_id'], false) . '" />' . "\n", $this->group);
}
} else {
$view_all_pages = array('products_new.php', 'specials.php');
if (in_array(basename($PHP_SELF), $view_all_pages)) {
$oscTemplate->addBlock('<link rel="canonical" href="' . OSCOM::link($PHP_SELF, 'view=all', false) . '" />' . "\n", $this->group);
}
}
}
public function execute()
{
global $login_customer_id, $oscTemplate, $breadcrumb;
$this->page->setFile('login.php');
// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
if (session_status() !== PHP_SESSION_ACTIVE) {
if (!isset($_GET['cookie_test'])) {
$all_get = tep_get_all_get_params(['Account', 'LogIn', 'Process']);
OSCOM::redirect('index.php', 'Account&LogIn&' . $all_get . (empty($all_get) ? '' : '&') . 'cookie_test=1', 'SSL');
}
OSCOM::redirect('cookie_usage.php');
}
// login content module must return $login_customer_id as an integer after successful customer authentication
$login_customer_id = false;
$this->page->data['content'] = $oscTemplate->getContent('login');
require OSCOM::BASE_DIR . 'languages/' . $_SESSION['language'] . '/login.php';
$breadcrumb->add(NAVBAR_TITLE, OSCOM::link('index.php', 'Account&LogIn', 'SSL'));
}
