Jump to content
Sign in to follow this  
Historian

Price List - HTML

Recommended Posts

I was after a simple price list printed from our shop. I saw contribution 1705 and thought it could be what i wanted.

However, although it appears to be fairly simple, I couldn't get it to work!

I can't make it print properly. I have checked the HTML, which looks OK, but I haven't enough knowledge to check the PHP. Can anyone help please?

 

The "working" file (before improving HTML) is as follows (apologies for such a long file):

 

<?php

require('includes/application_top.php');
// the following cPath references come from application_top.php
$category_depth = 'top';
if (isset($cPath) && tep_not_null($cPath)) {
	$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
	$cateqories_products = tep_db_fetch_array($categories_products_query);
	if ($cateqories_products['total'] > 0) {
		$category_depth = 'products'; // display products
	} else {
		$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
		$category_parent = tep_db_fetch_array($category_parent_query);
		if ($category_parent['total'] > 0) {
			$category_depth = 'nested'; // navigate through the categories
		} else {
			$category_depth = 'products'; // category has no products, but display the 'no products' message
		}
	}
}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRICELIST);

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRICELIST)); 
?>
<!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>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<style type="text/css">
<!--
td.priceListWidth{
 width:<?php echo WIDTH_PRICE_LIST; ?>px;
} 
td.priceListIndent {
 background-color:<?php echo INDENT_PRICE_LIST_COLOR; ?>;
 width:<?php echo INDENT_PRICE_LIST; ?>;
} 
--></style>

</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<?php  // print function and edit remove by willross
if ($print=="yes"){?>
<!-- column_left disabled for print //-->
<?php } else {?>
	<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<?php }?>
	<!-- body_text //-->


<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td valign="top">			<table border="0" cellspacing="0" cellpadding="2">
			 <tr>
				<td class="pageHeading"><?php echo TITLE_PRICE_LIST ?> <?php echo date(DATE_PRICE_LIST); ?><sup>
<?php  // print function and edit remove by willross
if ($print=="yes"){?>
<font style="font-size:10px"><a href="pricelist.php">[<?php echo FULL_VIEW ?>]</a></font>
<?php } else {?>
<font style="font-size:10px"><a href="pricelist.php?print=yes">[<?php echo PRINT_VIEW ?>]</a></font>
<?php }?></sup>
			   </td>
			  </tr>
			  <tr>
				<td>
<?
// groups have products?
function check_products($id_group){
$products_price_query = tep_db_query("select products_to_categories.products_id FROM products_to_categories where products_to_categories.categories_id = ".$id_group." LIMIT 0,1");
if($products_price = tep_db_fetch_array($products_price_query)){
	return true;	
}
return false;
}

// list products determined group 
function get_products($id_group){
global $currencies;
	$query = "";
if(!SHOW_MARKED_OUT_STOCK){
	$query = " and products.products_status = 1";
}
$products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_quantity <> 0".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);
	$x=0;
while ($products_price = tep_db_fetch_array($products_price_query)){
	$cell = tep_get_products_special_price($products_price['products_id']);
	if($cell == 0)
		$cell = $products_price['products_price'];
	if($x==1) {
		$col = "#F8F8F9";
		$x = 0;	
	}else{
		$col = "#FFFFFF";
		$x++;
	}
	$quantity = "";
	$model = "";
	if(SHOW_QUANTITY) 
		$quantity = "<td  align=\"right\" class=\"productListing-data\"> (".$products_price['products_quantity'].")</td>";
	if(SHOW_MODEL)
		$model = "<td align=\"LEFT\" class=\"productListing-data\">".$products_price['products_model']."</td>";
	print "<tr bgcolor=\"".$col."\"><td class=\"productListing-data\"><table align=\"LEFT\" cellpadding=\"1\" cellspacing=\"0\" ><tr><td  class=\"priceListIndent\" ></td><td class=\"productListing-data\" > </td></tr></table></td>".$model."<td class=\"productListing-data\" ><a href=" . tep_href_link( FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "> ".$products_price['products_name']."</td><td align=\"right\" class=\"productListing-data\"> " . (($products_price['products_price'] > 0) ? $currencies->display_price($cell,TAX_INCREASE) : NO_PRICE ) ."</td>".$quantity."</tr>";
}
}

// get all groups
function get_group($id_parent,$position){
	$qty_text = "";
if(SHOW_QUANTITY) {
	$qty_text = "".QUANTITY_TEXT."";
}else{
	$qty_text = " ";
}
$groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent);
while ($groups_price = tep_db_fetch_array($groups_price_query)){
	$str = "";
	for($i = 0; $i < $position; $i++){
		$str = $str . "<table align=\"LEFT\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td  class=\"priceListIndent\" ></td><td class=\"productListing-heading\" > </td></tr></table>";
	}
	$class = "productListing-heading";
	if($position == 0) {
		$class = "headerNavigation";
		print "<tr><td colspan=\"5\" class=\"priceListWidth\"><table align=\"right\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td class=\"productListing-data\">".$qty_text."</td></tr></table></td></tr>"; // dónnr? nndîer
	}
	if(check_products($groups_price['categories_id']) || $position == 0){
		print "<tr><td colspan=\"5\" class=\"".$class."\"><strong><font color=\"#FFFFFF\">".$str.$groups_price['categories_name']."</font></strong></td></tr>";
		get_products($groups_price['categories_id']);
	}
	get_group($groups_price['categories_id'],$position+1); // nëläótur? adóddr
}
}
?>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<?
 get_group(0,0);
?>
<tr>
<?php  // print function and edit remove by willross
if ($print=="yes"){?>
<!-- column_right disabled for print //-->
<?php } else {?>
		<td colspan="5"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
		</tr>

</table>					</td>
			  </tr>
		</table></td>
	<!-- body_text //-->
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>

</table>
<!-- body_eof //-->

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

<?php }?>
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

Instead of the correct printout, the printout starts as follows:

 

pricelist.jpg

 

What it's doing is printing out part of the PHP file from the end of line 138 !!

I was wondering whether it was written in PHP4 - It's now running in PHP5.

 

Can anyone please help me and say what is going on and what is wrong?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×