Esiste un Totale vendite per marca ?

Questo forum è dedicato alle discussioni riguardanti le contribution per osCommerce

Moderatore: mod Generali

Rispondi
robysoldtamiya
membro Baby
membro Baby
Messaggi: 73
Iscritto il: 10/09/2008, 23:31

Esiste un Totale vendite per marca ?

Messaggio da robysoldtamiya »

Esiste una contrib. che mi dia il totale vendite per marche ?
dynamo
membro Master
membro Master
Messaggi: 1976
Iscritto il: 13/11/2007, 17:47
Contatta:

Re: Esiste un Totale vendite per marca ?

Messaggio da dynamo »

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

visitate e criticate se è il caso... solo con le critiche posso migliorarlo ^_^
maury2ma
membro Master
membro Master
Messaggi: 1669
Iscritto il: 10/02/2006, 14:04
Contatta:

Re: Esiste un Totale vendite per marca ?

Messaggio da maury2ma »

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.
robysoldtamiya
membro Baby
membro Baby
Messaggi: 73
Iscritto il: 10/09/2008, 23:31

Re: Esiste un Totale vendite per marca ?

Messaggio da robysoldtamiya »

Si ho cercato nel sito delle contrib.

Posso dire 'INCREDDDIBBILE' !?!??!
:D

Che strano che a nessuno fin'ora sia interessato quale marca gli fa vendere di più
Boh vedro' di riuscire a farmela :(
robysoldtamiya
membro Baby
membro Baby
Messaggi: 73
Iscritto il: 10/09/2008, 23:31

Re: Esiste un Totale vendite per marca ?

Messaggio da robysoldtamiya »

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

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'); ?>
Rispondi