pafranklin Posted October 10, 2018 Share Posted October 10, 2018 Hi, I'm installing a small reporting contribution that states: In the file '/admin/includes/filenames.php', add the following line: define('FILENAME_STATS_DETAILED_MONTHLY_SALES', 'stats_detailed_monthly_sales.php'); However this file does not seem to exist in 2.3. Please can someone tell me where this define now goes? Many thanks. Paul You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
♥raiwa Posted October 10, 2018 Share Posted October 10, 2018 Filename definitions are removed and filenames are now hardcoded in 2.3.4.1 BS and CE Frozen (I believe you refer to this version) in the contribution files just replace all instances of FILENAME_STATS_DETAILED_MONTHLY_SALES by: 'stats_detailed_monthly_sales.php' About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
pafranklin Posted October 10, 2018 Author Share Posted October 10, 2018 Thank you and I hadn't realised that. Files changed but now throwing a 500 Error. I don't suppose anyone can see if there is anything wrong with the enclosed code please? <? require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <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"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <? if ( ! $_REQUEST['print'] ) { require(DIR_WS_INCLUDES . 'template_top.php') ?> <? } ?> <td valign="top"> <div class="pageHeading"><?= HEADING_TITLE ?></div><br /> <table border="0" width='100%' cellspacing="0" cellpadding="2"> <? if ( isset( $_REQUEST['year'] ) && isset( $_REQUEST['month'] ) ) { if ( ! in_array( $_REQUEST['month'], explode( ',', MONTH_LIST ) ) ) { ?> <tr> <td class="pageHeading">Error!</td> </tr> <tr> <td class="dataTableContent">'<?= $_REQUEST['month'] ?>' is not a valid month!</td> </tr> <? } else { ?> <tr> <td class="pageHeading" colspan="6"><?= $_REQUEST['year'] ?> » <?= $_REQUEST['month'] ?></td> </tr> <tr> <td class="dataTableContent" colspan="3"><a href="stats_detailed_monthly_sales.php">Back</a></td> <td class="dataTableContent" colspan="3" align="right"><? if ( ! $_REQUEST['print'] ) { ?><a href="stats_detailed_monthly_sales.php?year=<?= $_REQUEST['year'] ?>&month=<?= $_REQUEST['month'] ?>&print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?> </tr> <tr> <td class="dataTableContent" colspan="6"> </td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent">Order #</td> <td class="dataTableHeadingContent">Customer</td> <td class="dataTableHeadingContent">Date</td> <td class="dataTableHeadingContent" align="right">Order Subtotal</td> <td class="dataTableHeadingContent" align="right">Shipping Total</td> <td class="dataTableHeadingContent" align="right">Tax Total</td> <td class="dataTableHeadingContent" align="right">Order Total</td> </tr> <? $orders_query = tep_db_query( "SELECT * FROM orders WHERE year( date_purchased ) = " . $_REQUEST['year'] . " AND monthname( date_purchased ) = '" . $_REQUEST['month'] . "' ORDER BY date_purchased DESC" ); $running_net_total = 0; $running_tax_total = 0; $running_shipping_total = 0; $order_count=0; while ( $orders = tep_db_fetch_array( $orders_query ) ) { $order_count++; $net_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $running_net_total += $net_total['total']; $running_shipping_total += $shipping_total['total']; $running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="invoice.php?oID=<?= $orders['orders_id'] ?>" target="_blank"><?= $orders['orders_id'] ?><a href="invoice.php?oID=<?= $orders['orders_id'] ?>"></td> <td class="dataTableContent"><?= $orders['customers_name'] ?></td> <td class="dataTableContent"><?= date( 'd/m/Y', strtotime( $orders['date_purchased'] ) ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? } ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo $order_count ?> orders</td> <td class="dataTableHeadingContent" colspan="2"> </td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total + $running_shipping_total + $running_tax_total, 2 ) ?></td> </tr> <? } } else { $count = 0; $years_query = tep_db_query( "SELECT DISTINCT( year( date_purchased ) ) AS y FROM " . TABLE_ORDERS . " ORDER BY date_purchased DESC" ); $total_running_net_total =0; $total_running_shipping_total =0; $total_running_tax_total =0; while ( $years = tep_db_fetch_array( $years_query ) ) { if ( $count > 0 ) { ?> <tr> <td class="dataTableContent"> </tr> <? } ?> <tr> <td class="pageHeading" colspan="4"><?= $years['y'] ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="20%" align="left"><?= TABLE_HEADING_MONTH ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_NET ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SHIPPING ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_TAX ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_GROSS ?></td> </tr> <? $months_query = tep_db_query( "SELECT DISTINCT( monthname( date_purchased ) ) AS month, month( date_purchased ) AS m FROM " . TABLE_ORDERS . " WHERE date_purchased LIKE '" . $years['y'] . "-%' ORDER BY date_purchased DESC" ); while ( $months = tep_db_fetch_array( $months_query ) ) { $net_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $yearly_running_net_total += $net_total['total']; $yearly_running_shipping_total += $shipping_total['total']; $yearly_running_tax_total += $tax_total['total']; $total_running_net_total += $net_total['total']; $total_running_shipping_total += $shipping_total['total']; $total_running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="stats_detailed_monthly_sales.php?year=<?= $years['y'] ?>&month=<?= $months['month'] ?>"><?= $months['month'] ?></a></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? $count ++; } ?> <tr class="dataTableHeadingRow"> <td class="dataTableContent"><?= $years['y'] ?> Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total + $yearly_running_shipping_total + $yearly_running_tax_total, 2 ) ?></td> </tr> <? $yearly_running_net_total =0; $yearly_running_shipping_total =0; $yearly_running_tax_total =0; } ?> <tr> <td colspan="5"> </td> </tr> <tr> <td class="pageHeading" colspan="5">TOTAL</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableContent">Store Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total + $total_running_shipping_total + $total_running_tax_total, 2 ) ?></td> </tr> <? } ?> </table> </td> </tr> </table> <? if ( ! $_REQUEST['print'] ) require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> </body> </html> You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
pafranklin Posted October 10, 2018 Author Share Posted October 10, 2018 I think I've found it myself and the code enclosed seems to work (so far)! <? require('includes/application_top.php'); require('includes/classes/currencies.php'); $currencies = new currencies(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <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"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <? if ( ! $_REQUEST['print'] ) { require('includes/template_top.php') ?> <? } ?> <td valign="top"> <div class="pageHeading"><?= HEADING_TITLE ?></div><br /> <table border="0" width='100%' cellspacing="0" cellpadding="2"> <? if ( isset( $_REQUEST['year'] ) && isset( $_REQUEST['month'] ) ) { if ( ! in_array( $_REQUEST['month'], explode( ',', MONTH_LIST ) ) ) { ?> <tr> <td class="pageHeading">Error!</td> </tr> <tr> <td class="dataTableContent">'<?= $_REQUEST['month'] ?>' is not a valid month!</td> </tr> <? } else { ?> <tr> <td class="pageHeading" colspan="6"><?= $_REQUEST['year'] ?> » <?= $_REQUEST['month'] ?></td> </tr> <tr> <td class="dataTableContent" colspan="3"><a href="stats_detailed_monthly_sales.php">Back</a></td> <td class="dataTableContent" colspan="3" align="right"><? if ( ! $_REQUEST['print'] ) { ?><a href="stats_detailed_monthly_sales.php?year=<?= $_REQUEST['year'] ?>&month=<?= $_REQUEST['month'] ?>&print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?> </tr> <tr> <td class="dataTableContent" colspan="6"> </td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent">Order #</td> <td class="dataTableHeadingContent">Customer</td> <td class="dataTableHeadingContent">Date</td> <td class="dataTableHeadingContent" align="right">Order Subtotal</td> <td class="dataTableHeadingContent" align="right">Shipping Total</td> <td class="dataTableHeadingContent" align="right">Tax Total</td> <td class="dataTableHeadingContent" align="right">Order Total</td> </tr> <? $orders_query = tep_db_query( "SELECT * FROM orders WHERE year( date_purchased ) = " . $_REQUEST['year'] . " AND monthname( date_purchased ) = '" . $_REQUEST['month'] . "' ORDER BY date_purchased DESC" ); $running_net_total = 0; $running_tax_total = 0; $running_shipping_total = 0; $order_count=0; while ( $orders = tep_db_fetch_array( $orders_query ) ) { $order_count++; $net_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT value AS total FROM orders_total WHERE orders_id = " . $orders['orders_id'] . " AND class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $running_net_total += $net_total['total']; $running_shipping_total += $shipping_total['total']; $running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="invoice.php?oID=<?= $orders['orders_id'] ?>" target="_blank"><?= $orders['orders_id'] ?><a href="invoice.php?oID=<?= $orders['orders_id'] ?>"></td> <td class="dataTableContent"><?= $orders['customers_name'] ?></td> <td class="dataTableContent"><?= date( 'd/m/Y', strtotime( $orders['date_purchased'] ) ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? } ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo $order_count ?> orders</td> <td class="dataTableHeadingContent" colspan="2"> </td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $running_net_total + $running_shipping_total + $running_tax_total, 2 ) ?></td> </tr> <? } } else { $count = 0; $years_query = tep_db_query( "SELECT DISTINCT( year( date_purchased ) ) AS y FROM " . TABLE_ORDERS . " ORDER BY date_purchased DESC" ); $total_running_net_total =0; $total_running_shipping_total =0; $total_running_tax_total =0; while ( $years = tep_db_fetch_array( $years_query ) ) { if ( $count > 0 ) { ?> <tr> <td class="dataTableContent"> </tr> <? } ?> <tr> <td class="pageHeading" colspan="4"><?= $years['y'] ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="20%" align="left"><?= TABLE_HEADING_MONTH ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_NET ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SHIPPING ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_TAX ?></td> <td class="dataTableHeadingContent" width="20%" align="right"><?= TABLE_HEADING_TOTAL_SALES_GROSS ?></td> </tr> <? $months_query = tep_db_query( "SELECT DISTINCT( monthname( date_purchased ) ) AS month, month( date_purchased ) AS m FROM " . TABLE_ORDERS . " WHERE date_purchased LIKE '" . $years['y'] . "-%' ORDER BY date_purchased DESC" ); while ( $months = tep_db_fetch_array( $months_query ) ) { $net_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_subtotal'" ); $net_total = tep_db_fetch_array( $net_total_query ); $shipping_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_shipping'" ); $shipping_total = tep_db_fetch_array( $shipping_total_query ); $tax_total_query = tep_db_query( "SELECT SUM( value ) AS total FROM orders_total ot, orders o WHERE ot.orders_id=o.orders_id AND year( o.date_purchased ) = " . $years['y'] . " AND month( o.date_purchased ) = " . $months['m'] . " AND ot.class = 'ot_tax'" ); $tax_total = tep_db_fetch_array( $tax_total_query ); $yearly_running_net_total += $net_total['total']; $yearly_running_shipping_total += $shipping_total['total']; $yearly_running_tax_total += $tax_total['total']; $total_running_net_total += $net_total['total']; $total_running_shipping_total += $shipping_total['total']; $total_running_tax_total += $tax_total['total']; ?> <tr class="dataTableRow"> <td class="dataTableContent"><a href="stats_detailed_monthly_sales.php?year=<?= $years['y'] ?>&month=<?= $months['month'] ?>"><?= $months['month'] ?></a></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $shipping_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $tax_total['total'], 2 ) ?></td> <td class="dataTableContent" align="right">$<?= number_format( $net_total['total'] + $shipping_total['total'] + $tax_total['total'], 2 ) ?></td> </tr> <? $count ++; } ?> <tr class="dataTableHeadingRow"> <td class="dataTableContent"><?= $years['y'] ?> Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $yearly_running_net_total + $yearly_running_shipping_total + $yearly_running_tax_total, 2 ) ?></td> </tr> <? $yearly_running_net_total =0; $yearly_running_shipping_total =0; $yearly_running_tax_total =0; } ?> <tr> <td colspan="5"> </td> </tr> <tr> <td class="pageHeading" colspan="5">TOTAL</td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableContent">Store Total</a></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_shipping_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_tax_total, 2 ) ?></td> <td class="dataTableHeadingContent" align="right">$<?= number_format( $total_running_net_total + $total_running_shipping_total + $total_running_tax_total, 2 ) ?></td> </tr> <? } ?> </table> </td> </tr> </table> <? if ( ! $_REQUEST['print'] ) require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> </body> </html> You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.