function start() { global $lC_Language, $lC_Currencies, $lC_Vqmod; include $lC_Vqmod->modCheck('includes/classes/currencies.php'); $lC_Currencies = new lC_Currencies(); if (isset($_SESSION['currency']) == false || isset($_GET['currency']) || USE_DEFAULT_LANGUAGE_CURRENCY == '1' && $lC_Currencies->getCode($lC_Language->getCurrencyID()) != $_SESSION['currency']) { if (isset($_GET['currency']) && $lC_Currencies->exists($_GET['currency'])) { $_SESSION['currency'] = $_GET['currency']; } else { $_SESSION['currency'] = USE_DEFAULT_LANGUAGE_CURRENCY == '1' ? $lC_Currencies->getCode($lC_Language->getCurrencyID()) : DEFAULT_CURRENCY; } if (isset($_SESSION['cartID'])) { unset($_SESSION['cartID']); } } return true; }
protected function _setData() { global $lC_Database, $lC_Language, $lC_Vqmod; if (!$this->enabled) { $this->_data = ''; } else { require_once $lC_Vqmod->modCheck('../includes/classes/currencies.php'); $lC_Currencies = new lC_Currencies(); $lastMonth = @date("m", @strtotime("-1 month")); $currentDay = @date("d"); $currentMonth = @date("m"); $currentYear = @date("Y"); $Qorders = $lC_Database->query('select o.orders_id, ot.value as order_total, greatest(o.date_purchased, ifnull(o.last_modified, "1970-01-01")) as date_last_modified from :table_orders o, :table_orders_total ot where o.orders_id = ot.orders_id and ot.class = "total" order by date_last_modified desc limit 6'); $Qorders->bindTable(':table_orders', TABLE_ORDERS); $Qorders->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL); $Qorders->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qorders->bindInt(':language_id', $lC_Language->getID()); $Qorders->execute(); $last = 0; $today = 0; $current = 0; $annual = 0; while ($Qorders->next()) { $year = substr($Qorders->value('date_last_modified'), 0, 4); $month = substr($Qorders->value('date_last_modified'), 5, 2); $day = substr($Qorders->value('date_last_modified'), 8, 2); if ($currentYear == $year) { $annual += $Qorders->valueDecimal('order_total'); if ($month == $currentMonth) { $current += $Qorders->valueDecimal('order_total'); if ($day == $currentDay) { $today += $Qorders->valueDecimal('order_total'); } } if ($month == $lastMonth) { $last += $Qorders->valueDecimal('order_total'); } } } $llast = $last > 0 ? $last : 0.01; $growth = ($current - $last) / $llast; $ribbonText = $growth > 0 ? '<span class="ribbon-inner green-gradient glossy"><span class="fact-progress">+' . number_format($growth, 1) . '% ▲</span></span>' : '<span class="ribbon-inner red-gradient glossy"><span class="fact-progress">-' . number_format($growth, 1) . '% ▼</span></span>'; $this->_data = '<div class="four-columns six-columns-tablet twelve-columns-mobile">' . ' <style>#revenueTable h3, h4 { margin:0; }</style>' . ' <div class="block large-margin-bottom">' . ' <h3 class="block-title">' . $this->_title . '</h3>' . ' <span class="ribbon">' . $ribbonText . '</span>' . ' <div class="with-padding">' . ' <table width="100%" id="revenueTable" class="responsive-table">' . ' <tr>' . ' <td height="24px;" width="99px" class="orange" style="border-right:1px solid #ccc; padding:8px 0 0 10px;"><h3>' . $lC_Currencies->format($today) . '</h3></td>' . ' <td height="24px;" style="padding:12px 0 0 10px;"><h4>' . $lC_Language->get('summary_revenue_text_todays') . ' ' . $lC_Language->get('summary_revenue_text_totals') . '</h4></td>' . ' </tr>' . ' <tr><td colspan="2"><hr></td></tr>' . ' <tr>' . ' <td height="24px;" width="99px" style="border-right:1px solid #ccc; padding:8px 0 0 10px;"><h3>' . $lC_Currencies->format($current) . '</h3></td>' . ' <td height="24px;" style="padding:12px 0 0 10px;"><h4>' . $lC_Language->get('month_' . $currentMonth) . ' ' . $lC_Language->get('summary_revenue_text_totals') . '</h4></td>' . ' </tr>' . ' <tr><td colspan="2"><hr></td></tr>' . ' <tr>' . ' <td height="24px;" width="99px" style="border-right:1px solid #ccc; padding:8px 0 0 10px;"><h3>' . $lC_Currencies->format($last) . '</h3></td>' . ' <td height="24px;" style="padding:12px 0 0 10px;"><h4>' . $lC_Language->get('month_' . $lastMonth) . ' ' . $lC_Language->get('summary_revenue_text_totals') . '</h4></td>' . ' </tr>' . ' <tr><td colspan="2"><hr></td></tr>' . ' <tr>' . ' <td height="24px;" width="99px" style="border-right:1px solid #ccc; padding:8px 0 0 10px;"><h3>' . $lC_Currencies->format($annual) . '</h3></td>' . ' <td height="24px;" style="padding:12px 0 0 10px;"><h4>' . $currentYear . ' ' . $lC_Language->get('summary_revenue_heading_yearly') . ' ' . $lC_Language->get('summary_revenue_text_totals') . '</h4></td>' . ' </tr>' . ' </table>' . ' </div>' . ' </div>' . '</div>'; $Qorders->freeResult(); } }
protected function _setData() { global $lC_Database, $lC_Language, $lC_Currencies, $lC_Vqmod; if (!$this->enabled) { $this->_data = ''; } else { $this->_data = '<div class="four-columns six-columns-tablet twelve-columns-mobile clear-both">' . ' <h2 class="relative thin">' . $this->_title . '</h2>' . ' <ul class="list spaced">'; if (!isset($lC_Currencies)) { if (!class_exists('lC_Currencies')) { include $lC_Vqmod->modCheck('../includes/classes/currencies.php'); } $lC_Currencies = new lC_Currencies(); } $Qproducts = $lC_Database->query('select p.products_id, greatest(p.products_date_added, p.products_last_modified) as date_last_modified, pd.products_name from :table_products p, :table_products_description pd where parent_id = 0 and p.products_id = pd.products_id and pd.language_id = :language_id order by date_last_modified desc limit 6'); $Qproducts->bindTable(':table_products', TABLE_PRODUCTS); $Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); $Qproducts->bindInt(':language_id', $lC_Language->getID()); $Qproducts->execute(); while ($Qproducts->next()) { $data = lC_Products_Admin::get($Qproducts->valueInt('products_id')); $products_icon = lc_icon_admin('products.png'); $products_price = $data['products_price']; if (!empty($data['variants'])) { $products_icon = lc_icon_admin('attach.png'); $products_price = null; foreach ($data['variants'] as $variant) { if ($products_price === null || $variant['data']['price'] < $products_price) { $products_price = $variant['data']['price']; } } if ($products_price === null) { $products_price = 0; } } $this->_data .= ' <li>' . ' <span class="list-link icon-bag icon-blue" title="' . $lC_Language->get('edit') . '">' . ' <strong>' . (!empty($data['variants']) ? $lC_Language->get('text_from') . ' ' : '') . $lC_Currencies->format($products_price) . '</strong> <span class="anthracite">' . lc_output_string_protected($data['products_name']) . '</span>' . ' </span>' . ' <div class="absolute-right compact show-on-parent-hover">' . ' <a href="' . ((int) ($_SESSION['admin']['access']['products'] < 3) ? '#' : lc_href_link_admin(FILENAME_DEFAULT, 'products=' . $Qproducts->valueInt('products_id') . '&cID=' . $category_id . '&action=save')) . '" class="button icon-pencil' . ((int) ($_SESSION['admin']['access']['products'] < 3) ? ' disabled' : NULL) . '">' . $lC_Language->get('icon_edit') . '</a>' . ' <a href="' . ((int) ($_SESSION['admin']['access']['products'] < 3) ? '#' : 'javascript://" onclick="copyProduct(\'' . $Qproducts->valueInt('products_id') . '\', \'' . urlencode($Qproducts->value('products_name')) . '\')') . '" class="button icon-pages with-tooltip' . ((int) ($_SESSION['admin']['access']['products'] < 3) ? ' disabled' : NULL) . '" title="' . $lC_Language->get('icon_copy') . '"></a>' . ' <a href="' . ((int) ($_SESSION['admin']['access']['products'] < 4) ? '#' : 'javascript://" onclick="deleteProduct(\'' . $Qproducts->valueInt('products_id') . '\', \'' . urlencode($Qproducts->value('products_name')) . '\')') . '" class="button icon-trash with-tooltip' . ((int) ($_SESSION['admin']['access']['products'] < 4) ? ' disabled' : NULL) . '" title="' . $lC_Language->get('icon_delete') . '"></a>' . ' </div>' . ' </li>'; } $this->_data .= ' </ul>' . '</div>'; $Qproducts->freeResult(); $this->_data .= $this->loadModal(); } }
public static function getData($id) { global $lC_Database; $lC_Currencies = new lC_Currencies(); $lC_Tax = new lC_Tax_Admin(); $lC_GeoIP = lC_GeoIP_Admin::load(); if ($lC_GeoIP->isInstalled()) { $lC_GeoIP->activate(); } $Qwho = $lC_Database->query('select * from :table_whos_online where session_id = :session_id'); $Qwho->bindTable(':table_whos_online', TABLE_WHOS_ONLINE); $Qwho->bindValue(':session_id', $id); $Qwho->execute(); $data = $Qwho->toArray(); $data['timeOnline'] = gmdate('H:i:s', time() - $Qwho->value('time_entry')); $data['ipAddress'] = $Qwho->value('ip_address'); if ($lC_GeoIP->isActive() && $lC_GeoIP->isValid($Qwho->value('ip_address'))) { $data['ipAddress'] .= '<p>' . implode('<br />', $lC_GeoIP->getData($Qwho->value('ip_address'))) . '</p>'; } $data['entryTime'] = @date('H:i:s', $Qwho->value('time_entry')); $data['lastClick'] = @date('H:i:s', $Qwho->value('time_last_click')); $Qwho->freeResult(); // get cart contents if (STORE_SESSIONS == 'database') { $Qsession = $lC_Database->query('select value from :table_sessions where id = :id'); $Qsession->bindTable(':table_sessions', TABLE_SESSIONS); $Qsession->bindValue(':id', $id); $Qsession->execute(); $session_data = trim($Qsession->value('value')); } else { if (file_exists($lC_Session->getSavePath() . '/sess_' . $id) && filesize($lC_Session->getSavePath() . '/sess_' . $id) > 0) { $session_data = trim(file_get_contents($lC_Session->getSavePath() . '/sess_' . $id)); } } $navigation = unserialize(lc_get_serialized_variable($session_data, 'lC_NavigationHistory_data', 'array')); $last_page = end($navigation); $last_page_url = $last_page['page']; if (isset($last_page['get']['osCsid'])) { unset($last_page['get']['osCsid']); } if (sizeof($last_page['get']) > 0) { $last_page_url .= '?' . lc_array_to_string($last_page['get']); } $currency = unserialize(lc_get_serialized_variable($session_data, 'currency', 'string')); $cart = unserialize(lc_get_serialized_variable($session_data, 'lC_ShoppingCart_data', 'array')); $data['cartContents'] = ''; if (!empty($cart['contents'])) { $data['cartContents'] .= '<tr>' . "\n" . ' <td colspan="2"> </td>' . "\n" . '</tr>' . "\n" . '<tr>' . "\n" . ' <td width="200px" valign="top"><b>' . $lC_Language->get('field_shopping_cart_contents') . '</b></td>' . "\n" . ' <td><table border="0" cellspacing="0" cellpadding="2">' . "\n"; foreach ($cart['contents'] as $product) { $data['cartContents'] .= '<tr>' . "\n" . ' <td align="right">' . $product['quantity'] . ' x</td>' . "\n" . ' <td>' . $product['name'] . '</td>' . "\n" . '</tr>' . "\n"; } $data['cartContents'] .= ' </table></td>' . "\n" . '</tr>' . "\n" . '<tr>' . "\n" . ' <td width="200px"><b>' . $lC_Language->get('field_shopping_cart_total') . '</b></td>' . "\n" . ' <td>' . $lC_Currencies->format($cart['total_cost'], true, $currency) . '</td>' . "\n" . '</tr>' . "\n"; } return $data; }
<?php /** @package catalog::admin::applications @author Loaded Commerce @copyright Copyright 2003-2014 Loaded Commerce, LLC @copyright Portions Copyright 2003 osCommerce @copyright Template built on Developr theme by DisplayInline http://themeforest.net/user/displayinline under Extended license @license https://github.com/loadedcommerce/loaded7/blob/master/LICENSE.txt @version $Id: invoice.php v1.0 2013-08-08 datazen $ */ global $lC_Vqmod; require_once $lC_Vqmod->modCheck('../includes/classes/currencies.php'); $lC_Currencies = new lC_Currencies(); require_once $lC_Vqmod->modCheck('includes/classes/tax.php'); $lC_Tax = new lC_Tax_Admin(); $lC_Order = new lC_Order($_GET['oid']); ?> <!-- Main content --> <section role="main" id="main"> <noscript class="message black-gradient simpler"><?php echo $lC_Language->get('ms_error_javascript_not_enabled_warning'); ?> </noscript> <hgroup id="main-title" class="thin"> <h1><?php echo $lC_Template->getPageTitle(); ?> </h1> </hgroup> <div class="with-padding-no-top">