[TEP-COMMIT] [CVS admin] show summary reports on the index page

hpdl-OfajU3CKLf1/[email protected] 24 Aug 2004 11:06:16 -0000
Newsgroups gmane.comp.web.oscommerce.cvs
Message-ID <[email protected]> 
Commit in admin/admin on MAIN

index.php +3 -247 1.21 -> 1.22

includes/classes/summary.php +51 added 1.1

includes/languages/english.php +4 1.118 -> 1.119

/espanol.php +4 1.113 -> 1.114

/german.php +4 1.112 -> 1.113

includes/languages/english/index.php +1 -30 1.3 -> 1.4

includes/languages/english/modules/summary/customers.php +18 added 1.1

/orders.php +19 added 1.1

/products.php +19 added 1.1

/reviews.php +19 added 1.1

includes/languages/espanol/index.php +1 -30 1.5 -> 1.6

includes/languages/espanol/modules/summary/customers.php +18 added 1.1

/orders.php +19 added 1.1

/products.php +19 added 1.1

/reviews.php +19 added 1.1

includes/languages/german/index.php +2 -31 1.6 -> 1.7

includes/languages/german/modules/summary/customers.php +18 added 1.1

/orders.php +19 added 1.1

/products.php +19 added 1.1

/reviews.php +19 added 1.1

includes/modules/summary/customers.php +66 added 1.1

/orders.php +70 added 1.1

/products.php +77 added 1.1

/reviews.php +70 added 1.1

templates/default/header.php +30 -6 1.1 -> 1.2

templates/default/images/icons/16x16/locked.png [binary] added 1.1

/people.png [binary] added 1.1

/unlocked.png [binary] added 1.1

templates/pages/index.php +76 added 1.1

+684 -344

21 added + 8 modified, total 29 files

show summary reports on the index page

each summary report is a module

----------

admin /admin

index.php 1.21 -> 1.22

diff -u -r1.21 -r1.22
--- index.php 2004/07/22 23:33:00 1.21
+++ index.php 2004/08/24 11:05:50 1.22
@@ -12,253 +12,9 @@

require('includes/application_top.php');

- $cat = array(array('title' => BOX_HEADING_CONFIGURATION,
- 'image' => 'configuration.gif',
- 'href' => tep_href_link(FILENAME_CONFIGURATION, 'gID=1'),
- 'children' => array(array('title' => BOX_CONFIGURATION_MYSTORE, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'gID=1')),
- array('title' => BOX_CONFIGURATION_LOGGING, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'gID=10')),
- array('title' => BOX_CONFIGURATION_CACHE, 'link' => tep_href_link(FILENAME_CONFIGURATION, 'gID=11')))),
- array('title' => BOX_HEADING_MODULES,
- 'image' => 'modules.gif',
- 'href' => tep_href_link(FILENAME_MODULES, 'set=payment'),
- 'children' => array(array('title' => BOX_MODULES_PAYMENT, 'link' => tep_href_link(FILENAME_MODULES, 'set=payment')),
- array('title' => BOX_MODULES_SHIPPING, 'link' => tep_href_link(FILENAME_MODULES, 'set=shipping')))),
- array('title' => BOX_HEADING_CATALOG,
- 'image' => 'catalog.gif',
- 'href' => tep_href_link(FILENAME_CATEGORIES),
- 'children' => array(array('title' => CATALOG_CONTENTS, 'link' => tep_href_link(FILENAME_CATEGORIES)),
- array('title' => BOX_CATALOG_MANUFACTURERS, 'link' => tep_href_link(FILENAME_MANUFACTURERS)))),
- array('title' => BOX_HEADING_LOCATION_AND_TAXES,
- 'image' => 'location.gif',
- 'href' => tep_href_link(FILENAME_COUNTRIES),
- 'children' => array(array('title' => BOX_TAXES_COUNTRIES, 'link' => tep_href_link(FILENAME_COUNTRIES)),
- array('title' => BOX_TAXES_GEO_ZONES, 'link' => tep_href_link(FILENAME_GEO_ZONES)))),
- array('title' => BOX_HEADING_CUSTOMERS,
- 'image' => 'customers.gif',
- 'href' => tep_href_link(FILENAME_CUSTOMERS),
- 'children' => array(array('title' => BOX_CUSTOMERS_CUSTOMERS, 'link' => tep_href_link(FILENAME_CUSTOMERS)),
- array('title' => BOX_CUSTOMERS_ORDERS, 'link' => tep_href_link(FILENAME_ORDERS)))),
- array('title' => BOX_HEADING_LOCALIZATION,
- 'image' => 'localization.gif',
- 'href' => tep_href_link(FILENAME_CURRENCIES),
- 'children' => array(array('title' => BOX_LOCALIZATION_CURRENCIES, 'link' => tep_href_link(FILENAME_CURRENCIES)),
- array('title' => BOX_LOCALIZATION_LANGUAGES, 'link' => tep_href_link(FILENAME_LANGUAGES)))),
- array('title' => BOX_HEADING_REPORTS,
- 'image' => 'reports.gif',
- 'href' => tep_href_link(FILENAME_STATISTICS),
- 'children' => array(array('title' => BOX_REPORTS_STATISTICS, 'link' => tep_href_link(FILENAME_STATISTICS)))),
- array('title' => BOX_HEADING_TOOLS,
- 'image' => 'tools.gif',
- 'href' => tep_href_link(FILENAME_BACKUP),
- 'children' => array(array('title' => TOOLS_BACKUP, 'link' => tep_href_link(FILENAME_BACKUP)),
- array('title' => TOOLS_BANNERS, 'link' => tep_href_link(FILENAME_BANNER_MANAGER)),
- array('title' => TOOLS_FILES, 'link' => tep_href_link(FILENAME_FILE_MANAGER)))));

+ $page_contents = 'index.php';

- $languages = tep_get_languages();
- $languages_array = array();
- $languages_selected = DEFAULT_LANGUAGE;
- for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
- $languages_array[] = array('id' => $languages[$i]['code'],
- 'text' => $languages[$i]['name']);

+ require('templates/default.php');

- if ($languages[$i]['directory'] == $osC_Session->value('language')) {
- $languages_selected = $languages[$i]['code'];
- }
- }

+ require('includes/application_bottom.php');

?>

-<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
-<html <?php echo HTML_PARAMS; ?>>
-<head>
-<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
-<title><?php echo TITLE; ?></title>
-<style type="text/css"><!--
-a { color:#080381; text-decoration:none; }
-a:hover { color:#aabbdd; text-decoration:underline; }
-a.text:link, a.text:visited { color: #000000; text-decoration: none; }
-a:text:hover { color: #000000; text-decoration: underline; }
-a.main:link, a.main:visited { color: #ffffff; text-decoration: none; }
-A.main:hover { color: #ffffff; text-decoration: underline; }
-a.sub:link, a.sub:visited { color: #dddddd; text-decoration: none; }
-A.sub:hover { color: #dddddd; text-decoration: underline; }
-.heading { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 20px; font-weight: bold; line-height: 1.5; color: #D3DBFF; }
-.main { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 17px; font-weight: bold; line-height: 1.5; color: #ffffff; }
-.sub { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; line-height: 1.5; color: #dddddd; }
-.text { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; line-height: 1.5; color: #000000; }
-.menuBoxHeading { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #ffffff; font-weight: bold; background-color: #7187bb; border-color: #7187bb; border-style: solid; border-width: 1px; }
-.infoBox { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #080381; background-color: #f2f4ff; border-color: #7187bb; border-style: solid; border-width: 1px; }
-.smallText { font-family: Verdana, Arial, sans-serif; font-size: 10px; }
-//--></style>
-</head>
-<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
-
-<table border="0" width="600" height="100%" cellspacing="0" cellpadding="0" align="center" valign="middle">
- <tr>
- <td><table border="0" width="600" height="440" cellspacing="0" cellpadding="1" align="center" valign="middle">
- <tr bgcolor="#000000">
- <td><table border="0" width="600" height="440" cellspacing="0" cellpadding="0">
- <tr bgcolor="#ffffff" height="50">
- <td height="50"><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td>
- <td align="right" class="text" nowrap><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . HEADER_TITLE_ADMINISTRATION . '</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="' . tep_catalog_href_link() . '">' . HEADER_TITLE_ONLINE_CATALOG . '</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://www.oscommerce.com" target="_blank">' . HEADER_TITLE_SUPPORT_SITE . '</a>'; ?>&nbsp;&nbsp;</td>
- </tr>
- <tr bgcolor="#080381">
- <td colspan="2"><table border="0" width="460" height="390" cellspacing="0" cellpadding="2">
- <tr valign="top">
- <td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2">
- <tr>
- <td valign="top"><br>
-<?php
- $heading = array();
- $contents = array();
-
- $heading[] = array('params' => 'class="menuBoxHeading"',
- 'text' => 'osCommerce');
-
- $contents[] = array('params' => 'class="infoBox"',
- 'text' => '<a href="http://www.oscommerce.com" target="_blank">' . BOX_ENTRY_SUPPORT_SITE . '</a><br>' .
- '<a href="http://forums.oscommerce.com" target="_blank">' . BOX_ENTRY_SUPPORT_FORUMS . '</a><br>' .
- '<a href="http://www.oscommerce.com/community" target="_blank">' . BOX_ENTRY_MAILING_LISTS . '</a><br>' .
- '<a href="http://www.oscommerce.com/community/bugs" target="_blank">' . BOX_ENTRY_BUG_REPORTS . '</a><br>' .
- '<a href="http://wiki.oscommerce.com" target="_blank">' . BOX_ENTRY_FAQ . '</a><br>' .
- '<a href="http://www.oscommerce.com/community/cvs" target="_blank">' . BOX_ENTRY_CVS_REPOSITORY . '</a>');
-
- $box = new box;
- echo $box->menuBox($heading, $contents);
-
- echo '<br>';
-
- $orders_contents = '';
- $Qos = $osC_Database->query('select orders_status_name, orders_status_id from :table_orders_status where language_id = :language_id');
- $Qos->bindRaw(':table_orders_status', TABLE_ORDERS_STATUS);
- $Qos->bindInt(':language_id', $osC_Session->value('languages_id'));
- $Qos->execute();
-
- while ($Qos->next()) {
- $Qop = $osC_Database->query('select count(*) as count from :table_orders where orders_status = :orders_status');
- $Qop->bindRaw(':table_orders', TABLE_ORDERS);
- $Qop->bindInt(':orders_status', $Qos->valueInt('orders_status_id'));
- $Qop->execute();
-
- $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'status=' . $Qos->valueInt('orders_status_id')) . '">' . $Qos->value('orders_status_name') . '</a>: ' . $Qop->value('count') . '<br>';
- }
- $orders_contents = substr($orders_contents, 0, -4);
-
- $heading = array();
- $contents = array();
-
- $heading[] = array('params' => 'class="menuBoxHeading"',
- 'text' => BOX_TITLE_ORDERS);
-
- $contents[] = array('params' => 'class="infoBox"',
- 'text' => $orders_contents);
-
- $box = new box;
- echo $box->menuBox($heading, $contents);
-
- echo '<br>';
-
- $Qcustomers = $osC_Database->query('select count(*) as count from :table_customers');
- $Qcustomers->bindRaw(':table_customers', TABLE_CUSTOMERS);
- $Qcustomers->execute();
-
- $Qproducts = $osC_Database->query('select count(*) as count from :table_products');
- $Qproducts->bindRaw(':table_products', TABLE_PRODUCTS);
- $Qproducts->execute();
-
- $Qreviews = $osC_Database->query('select count(*) as count from :table_reviews');
- $Qreviews->bindRaw(':table_reviews', TABLE_REVIEWS);
- $Qreviews->execute();
-
- $heading = array();
- $contents = array();
-
- $heading[] = array('params' => 'class="menuBoxHeading"',
- 'text' => BOX_TITLE_STATISTICS);
-
- $contents[] = array('params' => 'class="infoBox"',
- 'text' => '<a href="' . tep_href_link(FILENAME_CUSTOMERS) . '">' . BOX_ENTRY_CUSTOMERS . '</a>: ' . $Qcustomers->value('count') . '<br>' .
- '<a href="' . tep_href_link(FILENAME_CATEGORIES) . '">' . BOX_ENTRY_PRODUCTS . '</a>: ' . $Qproducts->value('count') . '<br>' .
- '<a href="' . tep_href_link(FILENAME_REVIEWS) . '">' . BOX_ENTRY_REVIEWS . '</a>: ' . $Qreviews->value('count'));
-
- $box = new box;
- echo $box->menuBox($heading, $contents);
-
- echo '<br>';
-
- $contents = array();
-
- if ($request_type == 'SSL') {
- $contents[] = array('params' => 'class="infoBox"',
- 'text' => tep_image(DIR_WS_ICONS . 'locked.gif', ICON_LOCKED, '', '', 'align="right"') . sprintf(BOX_CONNECTION_PROTECTED, (isset($_SERVER['SSL_CIPHER_ALGKEYSIZE']) ? $_SERVER['SSL_CIPHER_ALGKEYSIZE'] . '-bit' : '<i>' . BOX_CONNECTION_UNKNOWN . '</i>')));
- } else {
- $contents[] = array('params' => 'class="infoBox"',
- 'text' => tep_image(DIR_WS_ICONS . 'unlocked.gif', ICON_UNLOCKED, '', '', 'align="right"') . BOX_CONNECTION_UNPROTECTED);
- }
-
- $box = new box;
- echo $box->tableBlock($contents);
-?>
- </td>
- </tr>
- </table></td>
- <td width="460"><table border="0" width="460" height="390" cellspacing="0" cellpadding="2">
- <tr>
- <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">
- <tr><?php echo tep_draw_form('languages', 'index.php', '', 'get'); ?>
- <td class="heading"><?php echo HEADING_TITLE; ?></td>
- <td align="right"><?php echo tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"'); ?></td>
- </form></tr>
- </table></td>
- </tr>
-<?php
- $col = 2;
- $counter = 0;
- for ($i = 0, $n = sizeof($cat); $i < $n; $i++) {
- $counter++;
- if ($counter < $col) {
- echo ' <tr>' . "\n";
- }
-
- echo ' <td valign="top"><table border="0" cellspacing="0" cellpadding="2">' . "\n" .
- ' <tr>' . "\n" .
- ' <td valign="top"><a href="' . $cat[$i]['href'] . '">' . tep_image(DIR_WS_IMAGES . 'categories/' . $cat[$i]['image'], $cat[$i]['title'], '32', '32') . '</a></td>' . "\n" .
- ' <td valign="top"><table border="0" cellspacing="0" cellpadding="2">' . "\n" .
- ' <tr>' . "\n" .
- ' <td class="main"><a href="' . $cat[$i]['href'] . '" class="main">' . $cat[$i]['title'] . '</a></td>' . "\n" .
- ' </tr>' . "\n" .
- ' <tr>' . "\n" .
- ' <td class="sub">';
-
- $children = '';
- for ($j = 0, $k = sizeof($cat[$i]['children']); $j < $k; $j++) {
- $children .= '<a href="' . $cat[$i]['children'][$j]['link'] . '" class="sub">' . $cat[$i]['children'][$j]['title'] . '</a>, ';
- }
- echo substr($children, 0, -2);
-
- echo '</td> ' . "\n" .
- ' </tr>' . "\n" .
- ' </table></td>' . "\n" .
- ' </tr>' . "\n" .
- ' </table></td>' . "\n";
-
- if ($counter >= $col) {
- echo ' </tr>' . "\n";
- $counter = 0;
- }
- }
-?>
- </table></td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>
- <tr>
- <td><?php require('includes/footer.php'); ?></td>
- </tr>
- </table></td>
- </tr>
-</table>
-
-</body>
-
-</html>

----------

admin /admin /includes /classes

summary.php added at 1.1

diff -N summary.php
--- /dev/null Tue Aug 24 13:05:47 2004
+++ /tmp/cvsAAA7oaaau Tue Aug 24 13:05:51 2004
@@ -0,0 +1,51 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ class osC_Summary {
+
+/* Private methods */
+
+ var $_title,
+ $_title_link,
+ $_data;
+
+/* Public methods */
+
+ function getTitle() {
+ return $this->_title;
+ }
+
+ function getTitleLink() {
+ return $this->_title_link;
+ }
+
+ function hasTitleLink() {
+ if (isset($this->_title_link) && !empty($this->_title_link)) {
+ return true;
+ }
+
+ return false;
+ }
+
+ function getData() {
+ return $this->_data;
+ }
+
+ function hasData() {
+ if (isset($this->_data) && !empty($this->_data)) {
+ return true;
+ }
+
+ return false;
+ }
+ }
+?>

----------

admin /admin /includes /languages

english.php 1.118 -> 1.119

diff -u -r1.118 -r1.119
--- english.php 2004/08/18 11:56:29 1.118
+++ english.php 2004/08/24 11:05:51 1.119
@@ -54,6 +54,10 @@

define('HEADER_TITLE_ONLINE_CATALOG', 'Online Catalog');
define('HEADER_TITLE_ADMINISTRATION', 'Administration');

+define('BOX_CONNECTION_PROTECTED', 'You are protected by a %s secure SSL connection.');
+define('BOX_CONNECTION_UNPROTECTED', 'You are <font color="#ff0000">not</font> protected by a secure SSL connection.');
+define('BOX_CONNECTION_UNKNOWN', 'unknown');
+

// text for gender
define('MALE', 'Male');
define('FEMALE', 'Female');

----------

admin /admin /includes /languages

espanol.php 1.113 -> 1.114

diff -u -r1.113 -r1.114
--- espanol.php 2004/08/18 11:56:29 1.113
+++ espanol.php 2004/08/24 11:05:51 1.114
@@ -54,6 +54,10 @@

define('HEADER_TITLE_ONLINE_CATALOG', 'Cat&aacute;logo');
define('HEADER_TITLE_ADMINISTRATION', 'Administraci&oacute;n');

+define('BOX_CONNECTION_PROTECTED', 'Esta protegido por una conexi&oacute;n SSL %s.');
+define('BOX_CONNECTION_UNPROTECTED', '<font color="#ff0000">No</font> esta protegido por una conexi&oacute;n segura SSL.');
+define('BOX_CONNECTION_UNKNOWN', 'desconocido');
+

// text for gender
define('MALE', 'Var&oacute;n');
define('FEMALE', 'Mujer');

----------

admin /admin /includes /languages

german.php 1.112 -> 1.113

diff -u -r1.112 -r1.113
--- german.php 2004/08/18 11:56:29 1.112
+++ german.php 2004/08/24 11:05:51 1.113
@@ -54,6 +54,10 @@

define('HEADER_TITLE_ONLINE_CATALOG', 'Online Katalog');
define('HEADER_TITLE_ADMINISTRATION', 'Administration');

+define('BOX_CONNECTION_PROTECTED', 'Sie sind gesichert durch eine %s sichere SSL Verbindung.');
+define('BOX_CONNECTION_UNPROTECTED', 'Sie sind <font color="#ff0000">nicht</font> durch eine sichere SSL Verbindung gesichert.');
+define('BOX_CONNECTION_UNKNOWN', 'unbekannt');
+

// text for gender
define('MALE', 'Herr');
define('FEMALE', 'Frau');

----------

admin /admin /includes /languages /english

index.php 1.3 -> 1.4

diff -u -r1.3 -r1.4
--- index.php 2004/07/22 23:17:20 1.3
+++ index.php 2004/08/24 11:05:53 1.4
@@ -10,34 +10,5 @@

Released under the GNU General Public License
*/

-define('HEADING_TITLE', 'Choose an action..');
-
-define('BOX_TITLE_ORDERS', 'Orders');
-define('BOX_TITLE_STATISTICS', 'Statistics');
-
-define('BOX_ENTRY_SUPPORT_SITE', 'Support Site');
-define('BOX_ENTRY_SUPPORT_FORUMS', 'Support Forums');
-define('BOX_ENTRY_MAILING_LISTS', 'Mailing Lists');
-define('BOX_ENTRY_BUG_REPORTS', 'Bug Reports');
-define('BOX_ENTRY_FAQ', 'FAQ');
-define('BOX_ENTRY_LIVE_DISCUSSIONS', 'Live Discussions');
-define('BOX_ENTRY_CVS_REPOSITORY', 'CVS Repository');
-define('BOX_ENTRY_INFORMATION_PORTAL', 'Information Portal');
-
-define('BOX_ENTRY_CUSTOMERS', 'Customers');
-define('BOX_ENTRY_PRODUCTS', 'Products');
-define('BOX_ENTRY_REVIEWS', 'Reviews');
-
-define('BOX_CONNECTION_PROTECTED', 'You are protected by a %s secure SSL connection.');
-define('BOX_CONNECTION_UNPROTECTED', 'You are <font color="#ff0000">not</font> protected by a secure SSL connection.');
-define('BOX_CONNECTION_UNKNOWN', 'unknown');
-
-define('CATALOG_CONTENTS', 'Contents');
-
-define('REPORTS_PRODUCTS', 'Products');
-define('REPORTS_ORDERS', 'Orders');
-
-define('TOOLS_BACKUP', 'Backup');
-define('TOOLS_BANNERS', 'Banners');
-define('TOOLS_FILES', 'Files');

+ define('TEXT_NUMBER_OF_CUSTOMERS_ONLINE', 'There are currently %s customers online.');

?>

----------

admin /admin /includes /languages /english /modules /summary

customers.php added at 1.1

diff -N customers.php
--- /dev/null Tue Aug 24 13:05:47 2004
+++ /tmp/cvsAAA5daacu Tue Aug 24 13:05:54 2004
@@ -0,0 +1,18 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_CUSTOMERS_TITLE', 'Newest Customers');

+

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_CUSTOMERS', 'Customers');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /english /modules /summary

orders.php added at 1.1

diff -N orders.php
--- /dev/null Tue Aug 24 13:05:47 2004
+++ /tmp/cvsAAABfaqcu Tue Aug 24 13:05:54 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_ORDERS_TITLE', 'Latest Orders');

+

+ define('MODULE_SUMMARY_ORDERS_HEADING_ORDERS', 'Orders');

+ define('MODULE_SUMMARY_ORDERS_HEADING_TOTAL', 'Total');

+ define('MODULE_SUMMARY_ORDERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_ORDERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /english /modules /summary

products.php added at 1.1

diff -N products.php
--- /dev/null Tue Aug 24 13:05:47 2004
+++ /tmp/cvsAAAfpaOcu Tue Aug 24 13:05:55 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_PRODUCTS_TITLE', 'Latest Products');

+

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRICE', 'Price');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /english /modules /summary

reviews.php added at 1.1

diff -N reviews.php
--- /dev/null Tue Aug 24 13:05:55 2004
+++ /tmp/cvsAAA8za4cu Tue Aug 24 13:05:56 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_REVIEWS_TITLE', 'Latest Reviews');

+

+ define('MODULE_SUMMARY_REVIEWS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_LANGUAGE', 'Language');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_RATING', 'Rating');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_DATE', 'Date');

+?>

----------

admin /admin /includes /languages /espanol

index.php 1.5 -> 1.6

diff -u -r1.5 -r1.6
--- index.php 2004/07/22 23:18:42 1.5
+++ index.php 2004/08/24 11:05:56 1.6
@@ -10,34 +10,5 @@

Released under the GNU General Public License
*/

-define('HEADING_TITLE', 'Seleccione una opci&oacute;n..');
-
-define('BOX_TITLE_ORDERS', 'Pedidos');
-define('BOX_TITLE_STATISTICS', 'Estadisticas');
-
-define('BOX_ENTRY_SUPPORT_SITE', 'Soporte');
-define('BOX_ENTRY_SUPPORT_FORUMS', 'Foros');
-define('BOX_ENTRY_MAILING_LISTS', 'Listas de Correo');
-define('BOX_ENTRY_BUG_REPORTS', 'Notificar Fallos');
-define('BOX_ENTRY_FAQ', 'PUF (FAQ)');
-define('BOX_ENTRY_LIVE_DISCUSSIONS', 'Discusiones');
-define('BOX_ENTRY_CVS_REPOSITORY', 'Repositorio CVS');
-define('BOX_ENTRY_INFORMATION_PORTAL', 'Portal');
-
-define('BOX_ENTRY_CUSTOMERS', 'Clientes');
-define('BOX_ENTRY_PRODUCTS', 'Productos');
-define('BOX_ENTRY_REVIEWS', 'Comentarios');
-
-define('BOX_CONNECTION_PROTECTED', 'Esta protegido por una conexi&oacute;n SSL %s.');
-define('BOX_CONNECTION_UNPROTECTED', '<font color="#ff0000">No</font> esta protegido por una conexi&oacute;n segura SSL.');
-define('BOX_CONNECTION_UNKNOWN', 'desconocido');
-
-define('CATALOG_CONTENTS', 'Contenido');
-
-define('REPORTS_PRODUCTS', 'Productos');
-define('REPORTS_ORDERS', 'Pedidos');
-
-define('TOOLS_BACKUP', 'Copias');
-define('TOOLS_BANNERS', 'Banners');
-define('TOOLS_FILES', 'Ficheros');

+ define('TEXT_NUMBER_OF_CUSTOMERS_ONLINE', 'There are currently %s customers online.');

?>

----------

admin /admin /includes /languages /espanol /modules /summary

customers.php added at 1.1

diff -N customers.php
--- /dev/null Tue Aug 24 13:05:57 2004
+++ /tmp/cvsAAA.7aaeu Tue Aug 24 13:05:58 2004
@@ -0,0 +1,18 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_CUSTOMERS_TITLE', 'Newest Customers');

+

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_CUSTOMERS', 'Customers');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /espanol /modules /summary

orders.php added at 1.1

diff -N orders.php
--- /dev/null Tue Aug 24 13:05:58 2004
+++ /tmp/cvsAAAXbaqeu Tue Aug 24 13:05:58 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_ORDERS_TITLE', 'Latest Orders');

+

+ define('MODULE_SUMMARY_ORDERS_HEADING_ORDERS', 'Orders');

+ define('MODULE_SUMMARY_ORDERS_HEADING_TOTAL', 'Total');

+ define('MODULE_SUMMARY_ORDERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_ORDERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /espanol /modules /summary

products.php added at 1.1

diff -N products.php
--- /dev/null Tue Aug 24 13:05:58 2004
+++ /tmp/cvsAAAGmaGeu Tue Aug 24 13:05:59 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_PRODUCTS_TITLE', 'Latest Products');

+

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRICE', 'Price');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /espanol /modules /summary

reviews.php added at 1.1

diff -N reviews.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAAvaWeu Tue Aug 24 13:05:59 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_REVIEWS_TITLE', 'Latest Reviews');

+

+ define('MODULE_SUMMARY_REVIEWS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_LANGUAGE', 'Language');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_RATING', 'Rating');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_DATE', 'Date');

+?>

----------

admin /admin /includes /languages /german

index.php 1.6 -> 1.7

diff -u -r1.6 -r1.7
--- index.php 2004/07/22 23:19:57 1.6
+++ index.php 2004/08/24 11:06:00 1.7
@@ -10,34 +10,5 @@

Released under the GNU General Public License
*/

-define('HEADING_TITLE', 'Option w&auml;hlen ...');
-
-define('BOX_TITLE_ORDERS', 'Bestellungen');
-define('BOX_TITLE_STATISTICS', 'Statistik');
-
-define('BOX_ENTRY_SUPPORT_SITE', 'Support Seite');
-define('BOX_ENTRY_SUPPORT_FORUMS', 'Support Forum');
-define('BOX_ENTRY_MAILING_LISTS', 'Mailing Listen');
-define('BOX_ENTRY_BUG_REPORTS', 'Fehler Reporte');
-define('BOX_ENTRY_FAQ', 'Fragen und Antworten');
-define('BOX_ENTRY_LIVE_DISCUSSIONS', 'Live Diskussionen');
-define('BOX_ENTRY_CVS_REPOSITORY', 'CVS Repository');
-define('BOX_ENTRY_INFORMATION_PORTAL', 'Informations Portal');
-
-define('BOX_ENTRY_CUSTOMERS', 'Kunden');
-define('BOX_ENTRY_PRODUCTS', 'Produkte');
-define('BOX_ENTRY_REVIEWS', 'Bewertungen');
-
-define('BOX_CONNECTION_PROTECTED', 'Sie sind gesichert durch eine %s sichere SSL Verbindung.');
-define('BOX_CONNECTION_UNPROTECTED', 'Sie sind <font color="#ff0000">nicht</font> durch eine sichere SSL Verbindung gesichert.');
-define('BOX_CONNECTION_UNKNOWN', 'unbekannt');
-
-define('CATALOG_CONTENTS', 'Inhalt');
-
-define('REPORTS_PRODUCTS', 'Produkte');
-define('REPORTS_ORDERS', 'Bestellungen');
-
-define('TOOLS_BACKUP', 'Datensicherung');
-define('TOOLS_BANNERS', 'Bannerverwaltung');
-define('TOOLS_FILES', 'Dateiverwaltung');
-?>

\ No newline at end of file

+ define('TEXT_NUMBER_OF_CUSTOMERS_ONLINE', 'There are currently %s customers online.');
+?>

----------

admin /admin /includes /languages /german /modules /summary

customers.php added at 1.1

diff -N customers.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAY4aqgu Tue Aug 24 13:06:02 2004
@@ -0,0 +1,18 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_CUSTOMERS_TITLE', 'Newest Customers');

+

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_CUSTOMERS', 'Customers');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_CUSTOMERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /german /modules /summary

orders.php added at 1.1

diff -N orders.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAv.aGgu Tue Aug 24 13:06:02 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_ORDERS_TITLE', 'Latest Orders');

+

+ define('MODULE_SUMMARY_ORDERS_HEADING_ORDERS', 'Orders');

+ define('MODULE_SUMMARY_ORDERS_HEADING_TOTAL', 'Total');

+ define('MODULE_SUMMARY_ORDERS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_ORDERS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /german /modules /summary

products.php added at 1.1

diff -N products.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAckaWgu Tue Aug 24 13:06:03 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_PRODUCTS_TITLE', 'Latest Products');

+

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_PRICE', 'Price');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_DATE', 'Date');

+ define('MODULE_SUMMARY_PRODUCTS_HEADING_STATUS', 'Status');

+?>

----------

admin /admin /includes /languages /german /modules /summary

reviews.php added at 1.1

diff -N reviews.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAjuaahu Tue Aug 24 13:06:03 2004
@@ -0,0 +1,19 @@

+<?php

+/*

+ $Id$

+

+ osCommerce, Open Source E-Commerce Solutions

+ http://www.oscommerce.com

+

+ Copyright (c) 2004 osCommerce

+

+ Released under the GNU General Public License

+*/

+

+ define('MODULE_SUMMARY_REVIEWS_TITLE', 'Latest Reviews');

+

+ define('MODULE_SUMMARY_REVIEWS_HEADING_PRODUCTS', 'Products');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_LANGUAGE', 'Language');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_RATING', 'Rating');

+ define('MODULE_SUMMARY_REVIEWS_HEADING_DATE', 'Date');

+?>

----------

admin /admin /includes /modules /summary

customers.php added at 1.1

diff -N customers.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAMSaWhu Tue Aug 24 13:06:05 2004
@@ -0,0 +1,66 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ if (!class_exists('osC_Summary')) {
+ include('includes/classes/summary.php');
+ }
+
+ if (!defined('MODULE_SUMMARY_CUSTOMERS_TITLE')) {
+ include('includes/languages/' . $osC_Session->value('language') . '/modules/summary/customers.php');
+ }
+
+ class osC_Summary_customers extends osC_Summary {
+
+/* Class constructor */
+
+ function osC_Summary_customers() {
+ $this->_title = MODULE_SUMMARY_CUSTOMERS_TITLE;
+ $this->_title_link = tep_href_link(FILENAME_CUSTOMERS);
+
+ $this->_setData();
+ }
+
+/* Private methods */
+
+ function _setData() {
+ global $osC_Database, $template;
+
+ $this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
+ ' <thead>' .
+ ' <tr>' .
+ ' <th>' . MODULE_SUMMARY_CUSTOMERS_HEADING_CUSTOMERS . '</th>' .
+ ' <th>' . MODULE_SUMMARY_CUSTOMERS_HEADING_DATE . '</th>' .
+ ' <th>' . MODULE_SUMMARY_CUSTOMERS_HEADING_STATUS . '</th>' .
+ ' </tr>' .
+ ' </thead>' .
+ ' <tbody>';
+
+ $Qcustomers = $osC_Database->query('select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_status, ci.customers_info_date_account_created from :table_customers c, :table_customers_info ci where c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created desc limit 6');
+ $Qcustomers->bindTable(':table_customers', TABLE_CUSTOMERS);
+ $Qcustomers->bindTable(':table_customers_info', TABLE_CUSTOMERS_INFO);
+ $Qcustomers->execute();
+
+ while ($Qcustomers->next()) {
+ $this->_data .= ' <tr onMouseOver="rowOverEffect(this);" onMouseOut="rowOutEffect(this);">' .
+ ' <td><a href="' . tep_href_link(FILENAME_CUSTOMERS, 'cID=' . $Qcustomers->valueInt('customers_id') . '&action=cEdit') . '">' . tep_image('templates/' . $template . '/images/icons/16x16/personal.png', ICON_PREVIEW, '16', '16') . '&nbsp;' . $Qcustomers->valueProtected('customers_firstname') . ' ' . $Qcustomers->valueProtected('customers_lastname') . '</a></td>' .
+ ' <td>' . $Qcustomers->value('customers_info_date_account_created') . '</td>' .
+ ' <td align="center">' . tep_image('templates/' . $template . '/images/icons/' . (($Qcustomers->valueInt('customers_status') === 1) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif')) . '</td>' .
+ ' </tr>';
+ }
+
+ $Qcustomers->freeResult();
+
+ $this->_data .= ' </tbody>' .
+ '</table>';
+ }
+ }
+?>

----------

admin /admin /includes /modules /summary

orders.php added at 1.1

diff -N orders.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAA24aaiu Tue Aug 24 13:06:06 2004
@@ -0,0 +1,70 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ if (!class_exists('osC_Summary')) {
+ include('includes/classes/summary.php');
+ }
+
+ if (!defined('MODULE_SUMMARY_ORDERS_TITLE')) {
+ include('includes/languages/' . $osC_Session->value('language') . '/modules/summary/orders.php');
+ }
+
+ class osC_Summary_orders extends osC_Summary {
+
+/* Class constructor */
+
+ function osC_Summary_orders() {
+ $this->_title = MODULE_SUMMARY_ORDERS_TITLE;
+ $this->_title_link = tep_href_link(FILENAME_ORDERS);
+
+ $this->_setData();
+ }
+
+/* Private methods */
+
+ function _setData() {
+ global $osC_Database, $osC_Session, $template;
+
+ $this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
+ ' <thead>' .
+ ' <tr>' .
+ ' <th>' . MODULE_SUMMARY_ORDERS_HEADING_ORDERS . '</th>' .
+ ' <th>' . MODULE_SUMMARY_ORDERS_HEADING_TOTAL . '</th>' .
+ ' <th>' . MODULE_SUMMARY_ORDERS_HEADING_DATE . '</th>' .
+ ' <th>' . MODULE_SUMMARY_ORDERS_HEADING_STATUS . '</th>' .
+ ' </tr>' .
+ ' </thead>' .
+ ' <tbody>';
+
+ $Qorders = $osC_Database->query('select o.orders_id, o.customers_name, greatest(o.date_purchased, o.last_modified) as date_last_modified, s.orders_status_name, ot.text as order_total from :table_orders o, :table_orders_total ot, :table_orders_status s where o.orders_id = ot.orders_id and ot.class = "ot_total" and o.orders_status = s.orders_status_id and s.language_id = :language_id 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', $osC_Session->value('languages_id'));
+ $Qorders->execute();
+
+ while ($Qorders->next()) {
+ $this->_data .= ' <tr onMouseOver="rowOverEffect(this);" onMouseOut="rowOutEffect(this);">' .
+ ' <td><a href="' . tep_href_link(FILENAME_ORDERS, 'oID=' . $Qorders->valueInt('orders_id') . '&action=oEdit') . '">' . tep_image('templates/' . $template . '/images/icons/16x16/orders.png', ICON_PREVIEW, '16', '16') . '&nbsp;' . $Qorders->valueProtected('customers_name') . '</a></td>' .
+ ' <td>' . strip_tags($Qorders->value('order_total')) . '</td>' .
+ ' <td>' . $Qorders->value('date_last_modified') . '</td>' .
+ ' <td>' . $Qorders->value('orders_status_name') . '</td>' .
+ ' </tr>';
+ }
+
+ $Qorders->freeResult();
+
+ $this->_data .= ' </tbody>' .
+ '</table>';
+ }
+ }
+?>

----------

admin /admin /includes /modules /summary

products.php added at 1.1

diff -N products.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAAy9aqiu Tue Aug 24 13:06:06 2004
@@ -0,0 +1,77 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ if (!class_exists('osC_Summary')) {
+ include('includes/classes/summary.php');
+ }
+
+ if (!defined('MODULE_SUMMARY_PRODUCTS_TITLE')) {
+ include('includes/languages/' . $osC_Session->value('language') . '/modules/summary/products.php');
+ }
+
+ class osC_Summary_products extends osC_Summary {
+
+/* Class constructor */
+
+ function osC_Summary_products() {
+ $this->_title = MODULE_SUMMARY_PRODUCTS_TITLE;
+ $this->_title_link = tep_href_link(FILENAME_CATEGORIES);
+
+ $this->_setData();
+ }
+
+/* Private methods */
+
+ function _setData() {
+ global $osC_Database, $osC_Session, $osC_Currencies, $template;
+
+ if (!isset($osC_Currencies)) {
+ if (!class_exists('osC_Currencies')) {
+ include('../includes/classes/currencies.php');
+ }
+
+ $osC_Currencies = new osC_Currencies();
+ }
+
+ $this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
+ ' <thead>' .
+ ' <tr>' .
+ ' <th>' . MODULE_SUMMARY_PRODUCTS_HEADING_PRODUCTS . '</th>' .
+ ' <th>' . MODULE_SUMMARY_PRODUCTS_HEADING_PRICE . '</th>' .
+ ' <th>' . MODULE_SUMMARY_PRODUCTS_HEADING_DATE . '</th>' .
+ ' <th>' . MODULE_SUMMARY_PRODUCTS_HEADING_STATUS . '</th>' .
+ ' </tr>' .
+ ' </thead>' .
+ ' <tbody>';
+
+ $Qproducts = $osC_Database->query('select p.products_id, pd.products_name, p.products_price, greatest(p.products_date_added, p.products_last_modified) as date_last_modified, p.products_status from :table_products p, :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id order by date_last_modified desc, pd.products_name limit 6');
+ $Qproducts->bindTable(':table_products', TABLE_PRODUCTS);
+ $Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
+ $Qproducts->bindInt(':language_id', $osC_Session->value('languages_id'));
+ $Qproducts->execute();
+
+ while ($Qproducts->next()) {
+ $this->_data .= ' <tr onMouseOver="rowOverEffect(this);" onMouseOut="rowOutEffect(this);">' .
+ ' <td><a href="' . tep_href_link(FILENAME_CATEGORIES, 'pID=' . $Qproducts->valueInt('products_id') . '&action=new_product') . '">' . tep_image('templates/' . $template . '/images/icons/16x16/products.png', ICON_PREVIEW, '16', '16') . '&nbsp;' . $Qproducts->value('products_name') . '</a></td>' .
+ ' <td>' . $osC_Currencies->format($Qproducts->value('products_price')) . '</td>' .
+ ' <td>' . $Qproducts->value('date_last_modified') . '</td>' .
+ ' <td align="center">' . tep_image('templates/' . $template . '/images/icons/' . (($Qproducts->valueInt('products_status') === 1) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif')) . '</td>' .
+ ' </tr>';
+ }
+
+ $Qproducts->freeResult();
+
+ $this->_data .= ' </tbody>' .
+ '</table>';
+ }
+ }
+?>

----------

admin /admin /includes /modules /summary

reviews.php added at 1.1

diff -N reviews.php
--- /dev/null Tue Aug 24 13:05:59 2004
+++ /tmp/cvsAAA8iaOiu Tue Aug 24 13:06:07 2004
@@ -0,0 +1,70 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ if (!class_exists('osC_Summary')) {
+ include('includes/classes/summary.php');
+ }
+
+ if (!defined('MODULE_SUMMARY_REVIEWS_TITLE')) {
+ include('includes/languages/' . $osC_Session->value('language') . '/modules/summary/reviews.php');
+ }
+
+ class osC_Summary_reviews extends osC_Summary {
+
+/* Class constructor */
+
+ function osC_Summary_reviews() {
+ $this->_title = MODULE_SUMMARY_REVIEWS_TITLE;
+ $this->_title_link = tep_href_link(FILENAME_REVIEWS);
+
+ $this->_setData();
+ }
+
+/* Private methods */
+
+ function _setData() {
+ global $osC_Database, $template;
+
+ $this->_data = '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="dataTable">' .
+ ' <thead>' .
+ ' <tr>' .
+ ' <th>' . MODULE_SUMMARY_REVIEWS_HEADING_PRODUCTS . '</th>' .
+ ' <th>' . MODULE_SUMMARY_REVIEWS_HEADING_LANGUAGE . '</th>' .
+ ' <th>' . MODULE_SUMMARY_REVIEWS_HEADING_RATING . '</th>' .
+ ' <th>' . MODULE_SUMMARY_REVIEWS_HEADING_DATE . '</th>' .
+ ' </tr>' .
+ ' </thead>' .
+ ' <tbody>';
+
+ $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, greatest(r.date_added, r.last_modified) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.directory as languages_directory, l.image as languages_image from :table_reviews r, :table_reviews_description rd left join :table_products_description pd on (r.products_id = pd.products_id and rd.languages_id = pd.language_id), :table_languages l where r.reviews_id = rd.reviews_id and rd.languages_id = l.languages_id order by date_last_modified desc limit 6');
+ $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
+ $Qreviews->bindTable(':table_reviews_description', TABLE_REVIEWS_DESCRIPTION);
+ $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
+ $Qreviews->bindTable(':table_languages', TABLE_LANGUAGES);
+ $Qreviews->execute();
+
+ while ($Qreviews->next()) {
+ $this->_data .= ' <tr onMouseOver="rowOverEffect(this);" onMouseOut="rowOutEffect(this);">' .
+ ' <td><a href="' . tep_href_link(FILENAME_REVIEWS, 'rID=' . $Qreviews->valueInt('reviews_id') . '&action=rEdit') . '">' . tep_image('templates/' . $template . '/images/icons/16x16/write.png', ICON_PREVIEW, '16', '16') . '&nbsp;' . $Qreviews->value('products_name') . '</a></td>' .
+ ' <td align="center">' . tep_image(DIR_WS_CATALOG_LANGUAGES . $Qreviews->value('languages_directory') . '/images/' . $Qreviews->value('languages_image'), $Qreviews->value('languages_name')) . '</td>' .
+ ' <td align="center">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . 'stars_' . $Qreviews->valueInt('reviews_rating') . '.gif', $Qreviews->valueInt('reviews_rating') . '/5') . '</td>' .
+ ' <td>' . $Qreviews->value('date_last_modified') . '</td>' .
+ ' </tr>';
+ }
+
+ $Qreviews->freeResult();
+
+ $this->_data .= ' </tbody>' .
+ '</table>';
+ }
+ }
+?>

----------

admin /admin /templates /default

header.php 1.1 -> 1.2

diff -u -r1.1 -r1.2
--- header.php 2004/07/22 23:25:00 1.1
+++ header.php 2004/08/24 11:06:07 1.2
@@ -5,22 +5,46 @@

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

- Copyright (c) 2002 osCommerce

+ Copyright (c) 2004 osCommerce

Released under the GNU General Public License
*/

+ $languages = tep_get_languages();
+ $languages_array = array();
+ $languages_selected = DEFAULT_LANGUAGE;
+ for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
+ $languages_array[] = array('id' => $languages[$i]['code'],
+ 'text' => $languages[$i]['name']);
+
+ if ($languages[$i]['directory'] == $osC_Session->value('language')) {
+ $languages_selected = $languages[$i]['code'];
+ }
+ }
+

if ($messageStack->size > 0) {
echo $messageStack->output();
}
?>

+

<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>

- <td><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td>
- <td align="right"><?php echo '<a href="http://www.oscommerce.com" target="_blank">' . tep_image(DIR_WS_IMAGES . 'header_support.gif', HEADER_TITLE_SUPPORT_SITE, '50', '50') . '</a>&nbsp;&nbsp;<a href="' . tep_catalog_href_link() . '">' . tep_image(DIR_WS_IMAGES . 'header_checkout.gif', HEADER_TITLE_ONLINE_CATALOG, '53', '50') . '</a>&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'header_administration.gif', HEADER_TITLE_ADMINISTRATION, '50', '50') . '</a>'; ?>&nbsp;&nbsp;</td>

+ <td><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50') . '</a>'; ?></td>
+ <td width="150" align="right" class="smallText">
+<?php
+ if ($request_type == 'SSL') {
+ echo sprintf(BOX_CONNECTION_PROTECTED, (isset($_SERVER['SSL_CIPHER_ALGKEYSIZE']) ? $_SERVER['SSL_CIPHER_ALGKEYSIZE'] . '-bit' : '<i>' . BOX_CONNECTION_UNKNOWN . '</i>')) . tep_image('templates/' . $template . '/images/icons/16x16/locked.png', ICON_LOCKED);
+ } else {
+ echo BOX_CONNECTION_UNPROTECTED . ' ' . tep_image('templates/' . $template . '/images/icons/16x16/unlocked.png', ICON_UNLOCKED);
+ }
+?>
+ </td>

</tr>

+</table>
+
+<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr class="headerBar">

- <td class="headerBarContent">&nbsp;&nbsp;<?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_TOP . '</a>'; ?></td>
- <td class="headerBarContent" align="right"><?php echo '<a href="http://www.oscommerce.com" class="headerLink">' . HEADER_TITLE_SUPPORT_SITE . '</a> &nbsp;|&nbsp; <a href="' . tep_catalog_href_link() . '" class="headerLink">' . HEADER_TITLE_ONLINE_CATALOG . '</a> &nbsp;|&nbsp; <a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_ADMINISTRATION . '</a>'; ?>&nbsp;&nbsp;</td>

+ <td class="headerBarContent">&nbsp;&nbsp;<?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '" class="headerLink">' . HEADER_TITLE_TOP . '</a>'; ?></td>
+ <td class="headerBarContent" align="right"><?php echo '<a href="http://www.oscommerce.com" class="headerLink">' . HEADER_TITLE_SUPPORT_SITE . '</a> &nbsp;|&nbsp; <a href="' . tep_catalog_href_link() . '" class="headerLink">' . HEADER_TITLE_ONLINE_CATALOG . '</a> &nbsp;|&nbsp; ' . tep_draw_form('languages', FILENAME_DEFAULT, '', 'get') . tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"') . '</form>'; ?>&nbsp;&nbsp;</td>

</tr>

-</table>

\ No newline at end of file

+</table>

----------

admin /admin /templates /pages

index.php added at 1.1

diff -N index.php
--- /dev/null Tue Aug 24 13:06:10 2004
+++ /tmp/cvsAAAjhaqlu Tue Aug 24 13:06:11 2004
@@ -0,0 +1,76 @@

+<?php
+/*
+ $Id$
+
+ osCommerce, Open Source E-Commerce Solutions
+ http://www.oscommerce.com
+
+ Copyright (c) 2004 osCommerce
+
+ Released under the GNU General Public License
+*/
+
+ require('includes/classes/directory_listing.php');
+ $osC_DirectoryListing = new osC_DirectoryListing('includes/modules/summary');
+ $osC_DirectoryListing->setIncludeDirectories(false);
+ $files = $osC_DirectoryListing->getFiles();
+
+ $Qonline = $osC_Database->query('select count(*) as total from :table_whos_online where time_last_click >= :time_last_click');
+ $Qonline->bindTable(':table_whos_online', TABLE_WHOS_ONLINE);
+ $Qonline->bindInt(':time_last_click', (time() - 900));
+ $Qonline->execute();
+?>
+
+<p><?php echo '<a href="' . tep_href_link(FILENAME_WHOS_ONLINE) . '">' . tep_image('templates/' . $template . '/images/icons/16x16/people.png', ICON_PREVIEW, '16', '16') . '&nbsp;' . sprintf(TEXT_NUMBER_OF_CUSTOMERS_ONLINE, $Qonline->valueInt('total')); ?></p>
+
+<table border="0" width="100%" cellspacing="0" cellpadding="2">
+
+<?php
+ $col = 0;
+
+ foreach ($files as $file) {
+ include('includes/modules/summary/' . $file['name']);
+
+ $module = 'osC_Summary_' . substr($file['name'], 0, strrpos($file['name'], '.'));
+
+ $$module = new $module();
+
+ if ($$module->hasData()) {
+ if ($col === 0) {
+ echo ' <tr>' . "\n";
+ }
+
+ $col++;
+
+ if ($col <= 2) {
+ echo ' <td width="50%" valign="top">' . "\n";
+ }
+
+ if ($$module->hasTitleLink()) {
+ echo '<a href="' . $$module->getTitleLink() . '">';
+ }
+
+ echo '<h1>' . $$module->getTitle() . '</h1>';
+
+ if ($$module->hasTitleLink()) {
+ echo '</a>';
+ }
+
+ echo $$module->getData();
+
+ if ($col <= 2) {
+ echo ' </td>' . "\n";
+ }
+
+ if ( (next($files) === false) || ($col === 2) ) {
+ $col = 0;
+
+ echo ' </tr>' . "\n";
+ }
+ }
+
+ unset($$module);
+ }
+?>
+
+</table>

CVSspam 0.2.9

-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285