osCommerceITalia

Inviato: **26/10/2010, 17:49**

Esiste una contrib. che mi dia il totale vendite per marche ?

Inviato: **26/10/2010, 18:05**

non penso cmq prova a cercare su http://addons.oscommerce.com/

Inviato: **26/10/2010, 19:43**

non l'ho mai sentito.
forse qualcosa in quel link trovi.... ma la vedo molto dura.
se conosci bene l'inglese scrivi sul forum inglese magari trovi qualcosa....
altrimenti mi ricordo qualcosa tipo margin report, ma se non erro funzionava per categorie non per marche.

Inviato: **26/10/2010, 20:33**

Si ho cercato nel sito delle contrib.

Posso dire 'INCREDDDIBBILE' !?!??!

Che strano che a nessuno fin'ora sia interessato quale marca gli fa vendere di più
Boh vedro' di riuscire a farmela

Inviato: **26/10/2010, 21:48**

Via vi metto una prima bozza da verificare se i totali son giusti

Codice: Seleziona tutto

<?php
/*
  $Id: stats_manufacturers.php 2010-10-26 R.Buso $

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

  Copyright (c) 2010 R.Buso

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  require(DIR_WS_CLASSES . 'currencies.php');
  $currencies = new currencies();
?>
<!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>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
        </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
            <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td>
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_MANUFACTURERS; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_PURCHASED; ?> </td>
              </tr>
<?php
  if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS;
  $manufacturers_query_raw = "select m.manufacturers_name, sum(op.products_quantity * op.final_price) as ordersum from " . TABLE_MANUFACTURERS . " m, " . TABLE_ORDERS_PRODUCTS .  " op, " . TABLE_PRODUCTS . " p, " . TABLE_ORDERS . " o where m.manufacturers_id = p.manufacturers_id and p.products_id = op.products_id and o.orders_id = op.orders_id group by m.manufacturers_name order by ordersum DESC";
  $manufacturers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $manufacturers_query_raw, $manufacturers_query_numrows);
// fix counted manufacturers
  $manufacturers_query_numrows = tep_db_query("select manufacturers_id from " . TABLE_MANUFACTURERS . " group by manufacturers_id");
  $manufacturers_query_numrows = tep_db_num_rows($manufacturers_query_numrows);

  $rows = 0;
  $manufacturers_query = tep_db_query($manufacturers_query_raw);
  while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
    $rows++;

    if (strlen($rows) < 2) {
      $rows = '0' . $rows;
    }
?>
              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_MANUFACTURERS, 'search=' . $manufacturers['manufacturers_name'], 'NONSSL'); ?>'">
                <td class="dataTableContent"><?php echo $rows; ?>.</td>
                <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_MANUFACTURERS, 'search=' . $manufacturers['manufacturers_name'], 'NONSSL') . '">' . $manufacturers['manufacturers_name'] . '</a>'; ?></td>
                <td class="dataTableContent" align="right"><?php echo $currencies->format($manufacturers['ordersum']); ?> </td>
              </tr>
<?php
  }
?>
            </table></td>
          </tr>
          <tr>
            <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr>
                <td class="smallText" valign="top"><?php echo $manufacturers_split->display_count($manufacturers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_MANUFACTURERS); ?></td>
                <td class="smallText" align="right"><?php echo $manufacturers_split->display_links($manufacturers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?> </td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

osCommerceITalia

Esiste un Totale vendite per marca ?

Esiste un Totale vendite per marca ?

Re: Esiste un Totale vendite per marca ?

Re: Esiste un Totale vendite per marca ?

Re: Esiste un Totale vendite per marca ?

Re: Esiste un Totale vendite per marca ?