Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Missing admin/includes/filenames.php


pafranklin

Recommended Posts

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

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'

 

Link to comment
Share on other sites

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'] ?> &raquo; <?= $_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'] ?>&amp;month=<?= $_REQUEST['month'] ?>&amp;print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?>
						</tr>
						<tr>
							<td class="dataTableContent" colspan="6">&nbsp;</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">&nbsp;</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">&nbsp;
						</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'] ?>&amp;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">&nbsp;</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

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'] ?> &raquo; <?= $_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'] ?>&amp;month=<?= $_REQUEST['month'] ?>&amp;print=true" target="_blank">Printer Friendly Version (New Window)</a></td><? } ?>
						</tr>
						<tr>
							<td class="dataTableContent" colspan="6">&nbsp;</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">&nbsp;</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">&nbsp;
						</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'] ?>&amp;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">&nbsp;</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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...