Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Quick Price Updates - official support


azer

Recommended Posts

hi , i searched in all the forum couldn't find any official support thread for this awesome contribution :

 

Quick Price Updates

contrib

 

there are three question in my mind :

 

1.the number that u can enter as a price for a product is a prixe tax EXcluded and the javascript allow to see the price taht would be the product tax included .

is there any way to enter the price TAX included , and show the without tax price with javascript ?

 

2.can a full 2.8 version with all the language and a propoer install could be provided without the Bluestrat "Quick Products 2.7 w/ cost and retail price columns" version beacuase it begin really confusing .

 

3.Request : won't it be a good idea to be able to set the widht of each fields , i got small model numbers and long product name , and the sapce is really wasted ?

MS2

Link to comment
Share on other sites

  • Replies 112
  • Created
  • Last Reply

Top Posters In This Topic

  • 3 months later...

Bug in Quick Price Updates.

 

I have a name like samsung 17" lcd-monitor.

When i open Quick Price Updates it cuts " and evering after it..

It does so whit all my products that have a " sign..

 

Quick Price Updates is the program i use the most.. thx for a super program.

 

//PAtrik N

Link to comment
Share on other sites

  • 4 months later...

:(

This contribution has a MAJOR flaw : the manufacturer_id MUST be supplied for each product. As no outer join is used in the sql statements, the contrib is only displaying products that have a manufacturer. All products without a manufacturer are simply ignored !!!

 

I'm working on a patch for this.

 

Didier.

Link to comment
Share on other sites

Replace these sql commands in admin/quick_updates.php :

 

////  select categories
 if ($current_category_id == 0){
	  if($manufacturer){
	  //vendors//  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
				   $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
		 }else{
	  //vendors//  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' $sort_by ";
				   $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' $sort_by ";

	  }
 } else {
	 if($manufacturer){
	 //vendors//  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
				  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
		 }else{
	 //vendors//  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
				  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
	  }
 }

 

by

 

////  select categories
 if ($current_category_id == 0){
	  if($manufacturer){
		  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
		 }else{
		  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd left join ". TABLE_MANUFACTURERS ." m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by ";

	  }
 } else {
	 if($manufacturer){
			   $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
		 }else{
			  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc left join ". TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
	  }
 }

 

A join has been added between tables "products" and "manufacturers".

 

Didier.

Link to comment
Share on other sites

  • 4 weeks later...
  • 2 weeks later...
  • 3 months later...

I've another problem. This contribution work wery good but when i've not very many products in categories. When i've 200 or more products and i try update one of them i'm log out.

Link to comment
Share on other sites

  • 2 weeks later...
I've another problem. This contribution work wery good but when i've not very many products in categories. When i've 200 or more products and i try update one of them i'm log out.

 

I'm having this exact same problem, plus it's a little worse now, nothing seems to work - it won't navigate through the pages nor can I use a pull down menu, sort or anything - either it does nothing or takes me back to the login page.

 

(I also installed the Register Globals fix after it.) I've got a few contribs, and I've tried checking them but to no avail - :( I think I've just about given up trying to make it work.

 

 

aapinen:

Just use altavista.com they have a translator called Babble Fish, it's not perfect but it will give you the general idea of what they are talking about. I use it all the time.

Link to comment
Share on other sites

  • 7 months later...
:(

This contribution has a MAJOR flaw : the manufacturer_id MUST be supplied for each product. As no outer join is used in the sql statements, the contrib is only displaying products that have a manufacturer. All products without a manufacturer are simply ignored !!!

 

I'm working on a patch for this.

 

Didier.

I'm having the same problem in a client's store. It only shows products that have a manufacturer.

 

I cannot apply the patch provided on the last update of this contribution, it's too different from the statement in the last quick_updates.php. Has someone found a way to fix this? Please??

Patty

Link to comment
Share on other sites

  • 4 weeks later...

Hi Everyone

 

I just wanted to know if anyone is interested in the changes I have made to this contribution. I haven't added it on the contributions page yet because I am not sure that all will welcome the changes made. They are what I felt needed to be done to make this fully workable.

 

1. I made the price column to be inclusive of VAT and allow a VAT inclusive price to be entered. I did not use the contribution that has two columns. This is all done using one. The VAT is hardcoded for UK and does not use the tax-rate variable of osCommerce. So, this contribution will only work for UK shops that use VAT on all products.

 

Because of the way this contribution works combined with the above VAT change the code thinks that every single price has changed, so updating will update every single price at once (regardless of it you have made changes.. it just overwrites the same value). To offset this, I added checkbox next to the price column. Ticking this will allow the price to be updated for that product and any that are not ticked will not be updated (only applicable for price.. the rest of the columns work as normal)

 

2. I fixed the manufacturing drop down bug to allow products with no manufacturers to appear. The changes are similar to the ones supplied above but are created for new shops so that it works on all.

 

3. I expanded the boxes for the product and model name so that you can see all the text.

 

4. I removed the code for the margin increases. I am not a big lover of anything that globally changes a value and especially one as critical as prices.

 

If anyone wants this contribution, I'll add it to the contributions page be take note of what is above. It will only work for the UK shops that use VAT.

 

I am willing to explain how I made the changes if anyone wants just the code. I'll simply explain what needs to be adjusted in order to achieve what you need. That way you can make changes suitable for your store.

 

Cheers

 

Steve

My Toolbox: Crimson Editor, Adobe Photoshop CS2.0, Expression Web, Macromedia Suite 8.0, Cinema 4D, Nvu.

Link to comment
Share on other sites

  • 4 weeks later...
2. I fixed the manufacturing drop down bug to allow products with no manufacturers to appear. The changes are similar to the ones supplied above but are created for new shops so that it works on all.

 

any chance of showing that ? i have tried the fix above and amended it - but got an error :(

Link to comment
Share on other sites

  • 1 month later...

Hi,

 

Could someone help please?

I installed this contribution by ledave and it works good. But it only shows me only all the products that have manufacturer ! Products that do not have manufacturer are not showing in the list.

 

here is the file:

 

<?php

/*

$Id: quick_updates.php 2005/09/14 13:55:34 HRB Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Based on the original script contributed by Burt ([email protected])

and by Henri Bredehoeft ([email protected])

 

Changelog: by Infobroker

[email protected]

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

($row_by_page) ? define('MAX_DISPLAY_ROW_BY_PAGE' , $row_by_page ) : $row_by_page = MAX_DISPLAY_SEARCH_RESULTS; define('MAX_DISPLAY_ROW_BY_PAGE' , MAX_DISPLAY_SEARCH_RESULTS );

 

//// Tax Row

$tax_class_array = array(array('id' => '0', 'text' => NO_TAX_TEXT));

$tax_class_query = tep_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");

while ($tax_class = tep_db_fetch_array($tax_class_query)) {

$tax_class_array[] = array('id' => $tax_class['tax_class_id'],

'text' => $tax_class['tax_class_title']);

}

 

////Info Row pour le champ fabriquant

$manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER));

$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");

while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {

$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],

'text' => $manufacturers['manufacturers_name']);

}

 

// Display the list of the manufacturers

function manufacturers_list(){

global $manufacturer;

 

$manufacturers_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m order by m.manufacturers_name ASC");

$return_string = '<select name="manufacturer" onChange="this.form.submit();">';

$return_string .= '<option value="' . 0 . '">' . TEXT_ALL_MANUFACTURERS . '</option>';

while($manufacturers = tep_db_fetch_array($manufacturers_query)){

$return_string .= '<option value="' . $manufacturers['manufacturers_id'] . '"';

if($manufacturer && $manufacturers['manufacturers_id'] == $manufacturer) $return_string .= ' SELECTED';

$return_string .= '>' . $manufacturers['manufacturers_name'] . '</option>';

}

$return_string .= '</select>';

return $return_string;

}

 

##// Uptade database

switch ($HTTP_GET_VARS['action']) {

case 'update' :

$count_update=0;

$item_updated = array();

if($HTTP_POST_VARS['product_new_model']){

foreach($HTTP_POST_VARS['product_new_model'] as $id => $new_model) {

if (trim($HTTP_POST_VARS['product_new_model'][$id]) != trim($HTTP_POST_VARS['product_old_model'][$id])) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_model='" . $new_model . "', products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_name']){

foreach($HTTP_POST_VARS['product_new_name'] as $id => $new_name) {

if (trim($HTTP_POST_VARS['product_new_name'][$id]) != trim($HTTP_POST_VARS['product_old_name'][$id])) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . " SET products_name='" . $new_name . "' WHERE products_id=$id and language_id=" . $languages_id);

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_sort_order']){

foreach($HTTP_POST_VARS['product_new_sort_order'] as $id => $new_sort_order) {

if ($HTTP_POST_VARS['product_new_sort_order'][$id] != $HTTP_POST_VARS['product_old_sort_order'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_sort_order=$new_sort_order, products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_price']){

foreach($HTTP_POST_VARS['product_new_price'] as $id => $new_price) {

if ($HTTP_POST_VARS['product_new_price'][$id] != $HTTP_POST_VARS['product_old_price'][$id] && $HTTP_POST_VARS['update_price'][$id] == 'yes') {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_price=$new_price, products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_weight']){

foreach($HTTP_POST_VARS['product_new_weight'] as $id => $new_weight) {

if ($HTTP_POST_VARS['product_new_weight'][$id] != $HTTP_POST_VARS['product_old_weight'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_weight=$new_weight, products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_quantity']){

foreach($HTTP_POST_VARS['product_new_quantity'] as $id => $new_quantity) {

if ($HTTP_POST_VARS['product_new_quantity'][$id] != $HTTP_POST_VARS['product_old_quantity'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity=$new_quantity, products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_manufacturer']){

foreach($HTTP_POST_VARS['product_new_manufacturer'] as $id => $new_manufacturer) {

if ($HTTP_POST_VARS['product_new_manufacturer'][$id] != $HTTP_POST_VARS['product_old_manufacturer'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET manufacturers_id=$new_manufacturer, products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_image']){

foreach($HTTP_POST_VARS['product_new_image'] as $id => $new_image) {

if (trim($HTTP_POST_VARS['product_new_image'][$id]) != trim($HTTP_POST_VARS['product_old_image'][$id])) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_image='" . $new_image . "', products_last_modified=now() WHERE products_id=$id");

}

}

}

if($HTTP_POST_VARS['product_new_status']){

foreach($HTTP_POST_VARS['product_new_status'] as $id => $new_status) {

if ($HTTP_POST_VARS['product_new_status'][$id] != $HTTP_POST_VARS['product_old_status'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

tep_set_product_status($id, $new_status);

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_last_modified=now() WHERE products_id=$id");

 

}

}

}

if($HTTP_POST_VARS['product_new_tax']){

foreach($HTTP_POST_VARS['product_new_tax'] as $id => $new_tax_id) {

if ($HTTP_POST_VARS['product_new_tax'][$id] != $HTTP_POST_VARS['product_old_tax'][$id]) {

$count_update++;

$item_updated[$id] = 'updated';

mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_tax_class_id=$new_tax_id, products_last_modified=now() WHERE products_id=$id");

}

}

}

$count_item = array_count_values($item_updated);

if ($count_item['updated'] > 0) $messageStack->add($count_item['updated'].' '.TEXT_PRODUCTS_UPDATED . " $count_update " . TEXT_QTY_UPDATED, 'success');

break;

 

case 'calcul' :

if ($HTTP_POST_VARS['spec_price']) $preview_global_price = 'true';

break;

}

 

//// explode string parameters from preview product

if($info_back && $info_back!="-") {

$infoback = explode('-',$info_back);

$sort_by = $infoback[0];

$page = $infoback[1];

$current_category_id = $infoback[2];

$row_by_page = $infoback[3];

$manufacturer = $infoback[4];

}

 

//// define the step for rollover lines per page

$row_bypage_array = array(array());

for ($i = 10; $i <=100 ; $i=$i+5) {

$row_bypage_array[] = array('id' => $i,

'text' => $i);

}

 

##// Let's start displaying page with forms

?>

<!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">

</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 //-->

 

<script language="javascript">

<!--

var browser_family;

var up = 1;

 

if (document.all && !document.getElementById)

browser_family = "dom2";

else if (document.layers)

browser_family = "ns4";

else if (document.getElementById)

browser_family = "dom2";

else

browser_family = "other";

 

function display_ttc(action, prix, taxe, up){

if(action == 'display'){

if(up != 1)

valeur = Math.round((prix + (taxe / 100) * prix) * 100) / 100;

}else{

if(action == 'keyup'){

valeur = Math.round((parseFloat(prix) + (taxe / 100) * parseFloat(prix)) * 100) / 100;

}else{

valeur = '0';

}

}

switch (browser_family){

case 'dom2':

document.getElementById('descDiv').innerHTML = '<?php echo TOTAL_COST; ?> : '+valeur;

break;

case 'ie4':

document.all.descDiv.innerHTML = '<?php echo TOTAL_COST; ?> : '+valeur;

break;

case 'ns4':

document.descDiv.document.descDiv_sub.document.write(valeur);

document.descDiv.document.descDiv_sub.document.close();

break;

case 'other':

break;

}

}

-->

</script>

 

<!-- 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" colspan="3" valign="top"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right">

<?php

if($current_category_id != 0){

$image_query = tep_db_query("select c.categories_image from " . TABLE_CATEGORIES . " c where c.categories_id=" . $current_category_id);

$image = tep_db_fetch_array($image_query);

echo tep_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $image['categories_image'], '', 40);

}else{

if($manufacturer){

$image_query = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id=" . $manufacturer);

$image = tep_db_fetch_array($image_query);

echo tep_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $image['manufacturers_image'], '', 40);

}

}

?>

</td></tr>

</table></td></tr>

<tr><td align="center">

<table width="100%" cellspacing="0" cellpadding="0" border="1" bgcolor="#F3F9FB" bordercolor="#D1E7EF" height="100"><tr align="left"><td valign="middle">

<table width="100%" cellspacing="0" cellpadding="0" border="0">

<tr><td height="5"></td></tr>

<tr align="center">

<td class="smalltext"><?php echo tep_draw_form('row_by_page', FILENAME_QUICK_UPDATES, '', 'get'); echo tep_draw_hidden_field( 'manufacturer', $manufacturer); echo tep_draw_hidden_field( 'cPath', $current_category_id);?></td>

<td class="smallText"><?php echo TEXT_MAXI_ROW_BY_PAGE . '  ' . tep_draw_pull_down_menu('row_by_page', $row_bypage_array, $row_by_page, 'onChange="this.form.submit();"'); ?></form></td>

<?php echo tep_draw_form('categorie', FILENAME_QUICK_UPDATES, '', 'get'); echo tep_draw_hidden_field( 'row_by_page', $row_by_page); echo tep_draw_hidden_field( 'manufacturer', $manufacturer); ?>

<td class="smallText" align="center" valign="top"><?php echo DISPLAY_CATEGORIES . '  ' . tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); ?></td></form>

<?php echo tep_draw_form('manufacturers', FILENAME_QUICK_UPDATES, '', 'get'); echo tep_draw_hidden_field( 'row_by_page', $row_by_page); echo tep_draw_hidden_field( 'cPath', $current_category_id);?>

<td class="smallText" align="center" valign="top"><?php echo DISPLAY_MANUFACTURERS . '  ' . manufacturers_list(); ?></td></form>

</tr>

</table>

 

<table width="100%" cellspacing="0" cellpadding="0" border="0">

<tr align="center">

 

 

<td align="center">

<table border="0" cellspacing="0">

<form name="spec_price" <?php echo 'action="' . tep_href_link(FILENAME_QUICK_UPDATES, tep_get_all_get_params(array('action', 'info', 'pID')) . "action=calcul&page=$page&sort_by=$sort_by&cPath=$current_category_id&row_by_page=$row_by_page&manufacturer=$manufacturer" , 'NONSSL') . '"'; ?> method="post">

<tr>

<td class="main" align="center" valign="middle" nowrap> <?php echo TEXT_INPUT_SPEC_PRICE; ?></td>

<td align="center" valign="middle"> <?php echo tep_draw_input_field('spec_price',0,'size="5"'); ?> </td>

<td class="smalltext" align="center" valign="middle"><?php

if ($preview_global_price != 'true') {

echo '  ' . tep_image_submit('button_preview.gif', IMAGE_PREVIEW, "page=$page&sort_by=$sort_by&cPath=$current_category_id&row_by_page=$row_by_page&manufacturer=$manufacturer");

} else echo '  <a href="' . tep_href_link(FILENAME_QUICK_UPDATES, "page=$page&sort_by=$sort_by&cPath=$current_category_id&row_by_page=$row_by_page&manufacturer=$manufacturer") . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';?></td>

</tr>

<tr>

<td class="smalltext" align="center" valign="middle" colspan="3" nowrap>

<?php if ($preview_global_price != 'true') {

echo TEXT_SPEC_PRICE_INFO1 ;

} else echo TEXT_SPEC_PRICE_INFO2;?>

</td>

</tr>

</form>

</table>

</td>

</tr>

<tr><td height="5"></td></tr>

 

</td></tr>

<br>

<table width="100%" cellspacing="0" cellpadding="0" border="0">

<tr align="center">

 

 

<form name="update" method="POST" action="<?php echo "$PHP_SELF?action=update&page=$page&sort_by=$sort_by&cPath=$current_category_id&row_by_page=$row_by_page&manufacturer=$manufacturer"; ?>">

<td class="smalltext" align="middle"><?php echo WARNING_MESSAGE; ?> </td>

<?php echo "<td class=\"pageHeading\" align=\"right\">" . '<script language="javascript"><!--

switch (browser_family)

{

case "dom2":

case "ie4":

document.write(\'<div id="descDiv">\');

break;

default:

document.write(\'<ilayer id="descDiv"><layer id="descDiv_sub">\');

break;

}

-->

</script>' . "</td>\n";

?>

<td align="right" valign="middle"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE, "action=update&cPath=$current_category_id&page=$page&sort_by=$sort_by&row_by_page=$row_by_page");?></td>

</tr>

</table>

</td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<!-- Arbeitsfarbe -->

<td valign="top"><table border="0" bordercolor="#FF0000" width="100%" cellspacing="0" cellpadding="2">

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" align="left" valign="top"> <!-- Modell ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_MODEL == 'true')echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_model ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_MODEL . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_model DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_MODEL . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" .TABLE_HEADING_MODEL; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"><?php echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=pd.products_name ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_PRODUCTS . TEXT_ASCENDINGLY)."</a><a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=pd.products_name DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_PRODUCTS . ' ' . TEXT_DESCENDINGLY)."</a><br>" .TABLE_HEADING_PRODUCTS; ?></td>

<td class="dataTableHeadingContent" align="left" valign="top"><!-- Status ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_STATUT == 'true')echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_status ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . 'OFF ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_status DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . 'ON ' . TEXT_ASCENDINGLY)."</a>

<br>" .TABLE_HEADING_STATUS; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"><!-- Gewicht ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_WEIGHT == 'true')echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_weight ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_WEIGHT . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_weight DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_WEIGHT . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_WEIGHT; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"><!-- Stück ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_QUANTITY == 'true')echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_quantity ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_QUANTITY . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_quantity DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_QUANTITY . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_QUANTITY; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"><!-- Bild ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_IMAGE == 'true')echo "<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_image ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_IMAGE . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_image DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_IMAGE . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_IMAGE; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"><!-- Hersteller ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_MANUFACTURER == 'true')echo "<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=m.manufacturers_name ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_MANUFACTURERS . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=m.manufacturers_name DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_MANUFACTURERS . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_MANUFACTURERS; ?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"> <!-- Preis ++++++++++++++++++++++++++++++++++ -->

<?php echo "<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_price ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_PRICE . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_price DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_PRICE . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_PRICE;?>

</td>

<td class="dataTableHeadingContent" align="left" valign="top"> <!-- MwSt ++++++++++++++++++++++++++++++++++ -->

<?php if(DISPLAY_TAX == 'true')echo "<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_tax_class_id ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_TAX . ' ' . TEXT_ASCENDINGLY)."</a>

<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_tax_class_id DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_TAX . ' ' . TEXT_DESCENDINGLY)."</a>

<br>" . TABLE_HEADING_TAX; ?>

</td>

<td class="dataTableHeadingContent" align="center" valign="middle"> </td>

<td class="dataTableHeadingContent" align="center" valign="middle"> </td>

</tr><tr class="datatableRow">

<?php

//// control string sort page

if ($sort_by && !ereg('order by',$sort_by)) $sort_by = 'order by '.$sort_by ;

//// define the string parameters for good back preview product

$origin = FILENAME_QUICK_UPDATES."?info_back=$sort_by-$page-$current_category_id-$row_by_page-$manufacturer";

//// controle lenght (lines per page)

$split_page = $page;

if ($split_page > 1) $rows = $split_page * MAX_DISPLAY_ROW_BY_PAGE - MAX_DISPLAY_ROW_BY_PAGE;

 

//// select categories

if ($current_category_id == 0){

if($manufacturer){

$products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by ";

}else{

$products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join ". TABLE_MANUFACTURERS ." m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by ";

 

}

} else {

if($manufacturer){

$products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";

}else{

$products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc left join ". TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";

}

}

 

//// page splitter and display each products info

$products_split = new splitPageResults($split_page, MAX_DISPLAY_ROW_BY_PAGE, $products_query_raw, $products_query_numrows);

$products_query = tep_db_query($products_query_raw);

while ($products = tep_db_fetch_array($products_query)) {

$rows++;

if (strlen($rows) < 2) {

$rows = '0' . $rows;

}

//// check for global add value or rates, calcul and round values rates

if ($HTTP_POST_VARS['spec_price']){

$flag_spec = 'true' ;

if (substr($HTTP_POST_VARS['spec_price'],-1) == '%') {

if($HTTP_POST_VARS['marge'] && substr($HTTP_POST_VARS['spec_price'],0,1) != '-'){

$valeur = (1 - (ereg_replace("%", "", $HTTP_POST_VARS['spec_price']) / 100));

$price = sprintf("%01.2f", round($products['products_price'] / $valeur,2));

}else{

$price = sprintf("%01.2f", round($products['products_price'] + (($spec_price / 100) * $products['products_price']),2));

}

} else $price = sprintf("%01.2f", round($products['products_price'] + $spec_price,2));

} else $price = $products['products_price'] ;

 

//// Check Tax_rate for displaying TTC

$tax_query = tep_db_query("select r.tax_rate, c.tax_class_title from " . TABLE_TAX_RATES . " r, " . TABLE_TAX_CLASS . " c where r.tax_class_id=" . $products['products_tax_class_id'] . " and c.tax_class_id=" . $products['products_tax_class_id']);

$tax_rate = tep_db_fetch_array($tax_query);

if($tax_rate['tax_rate'] == '')$tax_rate['tax_rate'] = 0;

 

if(MODIFY_MANUFACTURER == 'false'){

$manufacturer_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id=" . $products['manufacturers_id']);

$manufacturer = tep_db_fetch_array($manufacturer_query);

}

//// display infos per row

if($flag_spec){echo '<tr class="dataTableRow" onmouseover="'; if(DISPLAY_TVA_OVER == 'true'){echo 'display_ttc(\'display\', ' . $price . ', ' . $tax_rate['tax_rate'] . ');';} echo 'this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="'; if(DISPLAY_TVA_OVER == 'true'){echo 'display_ttc(\'delete\');';} echo 'this.className=\'dataTableRow\'">'; }else{ echo '<tr class="dataTableRow" onmouseover="'; if(DISPLAY_TVA_OVER == 'true'){echo 'display_ttc(\'display\', ' . $products['products_price'] . ', ' . $tax_rate['tax_rate'] . ');';} echo 'this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="'; if(DISPLAY_TVA_OVER == 'true'){echo 'display_ttc(\'delete\', \'\', \'\', 0);';} echo 'this.className=\'dataTableRow\'">';}

 

if(DISPLAY_MODEL == 'true'){if(MODIFY_MODEL == 'true')echo "<td class=\"smallText\"><input type=\"text\" size=\"6\" name=\"product_new_model[".$products['products_id']."]\" value=\"".$products['products_model']."\"></td>\n";else echo "<td class=\"smallText\" align=\"left\">" . $products['products_model'] . "</td>\n";}else{ echo "<td class=\"smallText\" align=\"left\">";}

if(MODIFY_NAME == 'true')echo "<td class=\"smallText\"><input type=\"text\" size=\"35\" name=\"product_new_name[".$products['products_id']."]\" value=\"".$products['products_name']."\"></td>\n";else echo "<td class=\"smallText\" align=\"left\">".$products['products_name']."</td>\n";

//// Product status radio button

if(DISPLAY_STATUT == 'true'){

if ($products['products_status'] == '1') {

echo "<td class=\"smallText\"><input type=\"radio\" name=\"product_new_status[".$products['products_id']."]\" value=\"0\" ><input type=\"radio\" name=\"product_new_status[".$products['products_id']."]\" value=\"1\" checked ></td>\n";

} else {

echo "<td class=\"smallText\"><input type=\"radio\" style=\"background-color: #EEEEEE\" name=\"product_new_status[".$products['products_id']."]\" value=\"0\" checked ><input type=\"radio\" style=\"background-color: #EEEEEE\" name=\"product_new_status[".$products['products_id']."]\" value=\"1\"></td>\n";

}

}

if(DISPLAY_WEIGHT == 'true')echo "<td class=\"smallText\"><input type=\"text\" size=\"5\" name=\"product_new_weight[".$products['products_id']."]\" value=\"".$products['products_weight']."\"></td>\n";else echo "<td class=\"smallText\" align=\"center\"></td>";

if(DISPLAY_QUANTITY == 'true')echo "<td class=\"smallText\"><input type=\"text\" size=\"3\" name=\"product_new_quantity[".$products['products_id']."]\" value=\"".$products['products_quantity']."\"></td>\n";else echo "<td class=\"smallText\" align=\"center\"></td>";

if(DISPLAY_IMAGE == 'true')echo "<td class=\"smallText\"><input type=\"text\" size=\"8\" name=\"product_new_image[".$products['products_id']."]\" value=\"".$products['products_image']."\"></td>\n";else echo "<td class=\"smallText\" align=\"center\"></td>";

if(DISPLAY_MANUFACTURER == 'true'){if(MODIFY_MANUFACTURER == 'true')echo "<td class=\"smallText\">".tep_draw_pull_down_menu("product_new_manufacturer[".$products['products_id']."]\"", $manufacturers_array, $products['manufacturers_id'])."</td>\n";else echo "<td class=\"smallText\">" . $manufacturer['manufacturers_name'] . "</td>";}else{ echo "<td class=\"smallText\" align=\"center\"></td>";}

//// get the specials products list

$specials_array = array();

$specials_query = tep_db_query("select p.products_id, s.products_id, s.specials_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = p.products_id");

while ($specials = tep_db_fetch_array($specials_query)) {

$specials_array[] = $specials['products_id'];

}

//// check specials

if ( in_array($products['products_id'],$specials_array)) {

$spec_query = tep_db_query("select s.products_id, s.specials_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = " . (int)$products['products_id'] . "");

$spec = tep_db_fetch_array($spec_query);

 

echo "<td class=\"smallText\" align=\"left\"><input type=\"text\" size=\"6\" name=\"product_new_price[".$products['products_id']."]\" value=\"".$products['products_price']."\" disabled > <a target=blank href=\"".tep_href_link (FILENAME_SPECIALS, 'sID='.$spec['specials_id']).'&action=edit'."\">". tep_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) ."</a></td>\n";

} else {

if ($flag_spec == 'true') {

echo "<td class=\"smallText\" align=\"left\"><input type=\"text\" size=\"6\" name=\"product_new_price[".$products['products_id']."]\" "; if(DISPLAY_TVA_UP == 'true'){ echo "onKeyUp=\"display_ttc('keyup', this.value" . ", " . $tax_rate['tax_rate'] . ", 1);\"";} echo " value=\"".$price ."\">".tep_draw_checkbox_field('update_price['.$products['products_id'].']','yes','checked','no')."</td>\n";

} else { echo "<td class=\"smallText\" align=\"left\"><input type=\"text\" size=\"6\" name=\"product_new_price[".$products['products_id']."]\" "; if(DISPLAY_TVA_UP == 'true'){ echo "onKeyUp=\"display_ttc('keyup', this.value" . ", " . $tax_rate['tax_rate'] . ", 1);\"";} echo " value=\"".$price ."\">".tep_draw_hidden_field('update_price['.$products['products_id'].']','yes'). "</td>\n";}

}

if(DISPLAY_TAX == 'true'){if(MODIFY_TAX == 'true')echo "<td class=\"smallText\" align=\"left\">".tep_draw_pull_down_menu("product_new_tax[".$products['products_id']."]\"", $tax_class_array, $products['products_tax_class_id'])."</td>\n";else echo "<td class=\"smallText\" align=\"left\">" . $tax_rate['tax_class_title'] . "</td>";}else{ echo "<td class=\"smallText\" align=\"center\"></td>";}

//// links to preview or full edit

if(DISPLAY_PREVIEW == 'true')echo "<td class=\"smallText\" align=\"left\"><a href=\"".tep_href_link (FILENAME_CATEGORIES, 'pID='.$products['products_id'].'&action=new_product_preview&read=only&sort_by='.$sort_by.'&page='.$split_page.'&origin='.$origin)."\">". tep_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_IMAGE_PREVIEW) ."</a></td>\n";

if(DISPLAY_EDIT == 'true')echo "<td class=\"smallText\" align=\"left\"><a href=\"".tep_href_link (FILENAME_CATEGORIES, 'pID='.$products['products_id'].'&cPath='.$categories_products[0].'&action=new_product')."\">". tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', TEXT_IMAGE_SWITCH_EDIT) ."</a></td>\n";

 

//// Hidden parameters for cache old values

if(MODIFY_NAME == 'true') echo tep_draw_hidden_field('product_old_name['.$products['products_id'].'] ',$products['products_name']);

if(MODIFY_MODEL == 'true') echo tep_draw_hidden_field('product_old_model['.$products['products_id'].'] ',$products['products_model']);

echo tep_draw_hidden_field('product_old_sort_order['.$products['products_id'].']',$products['products_sort_order']);

 

 

echo tep_draw_hidden_field('product_old_make_an_offer['.$products['products_id'].']',$products['products_make_an_offer']);

 

echo tep_draw_hidden_field('product_old_zusatz3['.$products['products_id'].']',$products['products_zusatz3']);

echo tep_draw_hidden_field('product_old_status['.$products['products_id'].']',$products['products_status']);

echo tep_draw_hidden_field('product_old_quantity['.$products['products_id'].']',$products['products_quantity']);

echo tep_draw_hidden_field('product_old_image['.$products['products_id'].']',$products['products_image']);

if(MODIFY_MANUFACTURER == 'true')echo tep_draw_hidden_field('product_old_manufacturer['.$products['products_id'].']',$products['manufacturers_id']);

echo tep_draw_hidden_field('product_old_weight['.$products['products_id'].']',$products['products_weight']);

 

echo tep_draw_hidden_field('product_old_base_price['.$products['products_id'].']',$products['products_base_price']);

 

echo tep_draw_hidden_field('product_old_base_unit['.$products['products_id'].']',$products['products_base_unit']);

echo tep_draw_hidden_field('product_old_price_ek['.$products['products_id'].']',$products['products_price_ek']);

echo tep_draw_hidden_field('product_old_price['.$products['products_id'].']',$products['products_price']);

if(MODIFY_TAX == 'true')echo tep_draw_hidden_field('product_old_tax['.$products['products_id'].']',$products['products_tax_class_id']);

//// hidden display parameters

echo tep_draw_hidden_field( 'row_by_page', $row_by_page);

echo tep_draw_hidden_field( 'sort_by', $sort_by);

echo tep_draw_hidden_field( 'page', $split_page);

}

echo "</table>\n";

 

?>

</td>

</tr>

</table></td>

</tr>

<tr>

<td align="right">

<?php

//// display bottom page buttons

echo '<a href="java script:window.print()">' . tep_image_submit('button_print.gif', PRINT_TEXT) . '</a>  ';

echo tep_image_submit('button_update.gif', IMAGE_UPDATE);

echo '  <a href="' . tep_href_link(FILENAME_QUICK_UPDATES,"row_by_page=$row_by_page") . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';

?></td>

</tr>

</form>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, $split_page, TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>

<td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page); ?></td>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

<!-- body_text_eof //-->

</tr>

</table>

<!-- body_eof //-->

</tr>

</table>

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

thanks in advance !

 

Great day,

Elazar

Link to comment
Share on other sites

Elazar,

 

I have been waiting for a reply too, but there is none coming obviously.

 

I too matters in my own hand and assigned myself as a manufacturer to the items that had none.

 

To speed things up (I have 600 items on my site) I went to the SQL Database and did a query on on product.

 

Than copied that line into a text file about 50 times (have to add a ; at the end) type all product id's that nee changing, run about 12 queries and all my products now show up.

 

A little work, but that goes with a free cart like oscommerce.

 

Good Luck.

 

Wolfgang

Link to comment
Share on other sites

Elazar,

 

I have been waiting for a reply too, but there is none coming obviously.

 

I too matters in my own hand and assigned myself as a manufacturer to the items that had none.

 

To speed things up (I have 600 items on my site) I went to the SQL Database and did a query on on product.

 

Than copied that line into a text file about 50 times (have to add a ; at the end) type all product id's that nee changing, run about 12 queries and all my products now show up.

 

A little work, but that goes with a free cart like oscommerce.

 

Good Luck.

 

Wolfgang

 

Hi,

 

Thanks for your reply!

 

I understand what you mean Wolfgang. I thought about entering a string like: "xxxx" to the 'manufacturer by' field to all those products, that their manufacturer field is empty. then it will do the trick...

 

The thing is that I do not know about doing this SQL query. If you will help me what SQL query I should run, then I will be very glad!

 

Waiting please for your advice..

 

Great day to you and many thanks for your attention !

 

Elazar

Link to comment
Share on other sites

  • 2 weeks later...

Just in case anyone is looking for the Manufacturer's Patch for Quick Price Update:

 

If you install Quick Price Update you may find if your products aren't linked to a Manufacturer or don't have a Manufacturer the products will not show up in Quick Price Update. With this, you will be able to see all products, including those that do not have Manufacturers.

 

Find:

  } else {
	if($manufacturer){
			 $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_MANUFACTURERS . " m where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
	  }else{
			$products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_MANUFACTURERS . " m where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = m.manufacturers_id and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
	}
 }

Comment out & add or replace with:

//Quick Price Update Manfacturers Patch
 } else {
	 if($manufacturer){
			   $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
		 }else{
			  $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc left join ". TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
	  }
 }

 

I can confirm it works with Quick Price Update 2.5b & Quick Add Product & Ajax Attribute Manager. Using Spaceboy's (Didier Debbaut) initial patch, I only removed p.products_price1 - p.products_price8 because it was causing a 1054 error.

 

Seems to work well, Quick Price Updates is a real time saver & this patch saves having to go back & link products to Manufacturers to get it to work - which would be double the work!

 

Thanks to Spaceboy.

Link to comment
Share on other sites

Hey Thenes

 

Just tried your update and got this error inside where the products should be. Any idea ?

 

1054 - Unknown column 'p.manufacturers_id' in 'on clause'

 

select count(*) as total from products p, products_description pd, products_to_categories pc left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '27'

 

[TEP STOP]

 

Hope i can get this working because it seems like a great contribution

 

Joe

Link to comment
Share on other sites

Hi Joe,

 

What version of Quick Price Updates are you using? I can only confirm that I've been able to get it to work with version 2.5b. This is using the latest osC 2.2 Release.

 

I also realised I didn't specify which 2.5b version of Quick Price Updates I used. http://www.oscommerce.com/community/contributions,122

 

1. quick price update almost everything FULL from ledave 13 March 2007

2. Corrected quick_updates.php from ledave 19 March 2007

 

Also - the Manufacturer Patch (I know you know this, but I might not have been clear for others.) needs to be applied to quick_updates.php.

 

I'm hope that this helps. I have read this 1054 can be caused by different MYSQL versions but, that's to do with another contribution.

 

Please let me know how you go.

 

Hey Thenes

 

Just tried your update and got this error inside where the products should be. Any idea ?

 

1054 - Unknown column 'p.manufacturers_id' in 'on clause'

 

select count(*) as total from products p, products_description pd, products_to_categories pc left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '27'

 

[TEP STOP]

 

Hope i can get this working because it seems like a great contribution

 

Joe

Link to comment
Share on other sites

Hi Thenes,

 

Thank you so much for your reply ! i have exactly what you have running.

 

1. quick price update almost everything FULL from ledave 13 March 2007

2. Corrected quick_updates.php from ledave 19 March 2007

 

And Also - the Manufacturer Patch .

 

I tried it all again this morning !

 

And im still getting the same error.

 

1054 - Unknown column 'p.manufacturers_id' in 'on clause'

 

select count(*) as total from products p, products_description pd, products_to_categories pc left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '17'

 

Think i might just have to forget about the contribution now. Wish i could get it working .

 

Joe

Link to comment
Share on other sites

Hi Joe,

 

Just out of curiousity, are you using any other Contributions or Mods? Also, just to double check, did you run the quick_update.sql?

 

Lastly, I wouldn't mind taking a look at your quick_updates.php if you like. (Just copy & paste it into a msg for me.)

 

Last year I had a problem with it working as well - but I had so many Contributions & Mods, my attention was too divided. Anyhow, I can't promise anything but I don't mind taking a look.

 

Hi Thenes,

 

Thank you so much for your reply ! i have exactly what you have running.

 

1. quick price update almost everything FULL from ledave 13 March 2007

2. Corrected quick_updates.php from ledave 19 March 2007

 

And Also - the Manufacturer Patch .

 

I tried it all again this morning !

 

And im still getting the same error.

 

1054 - Unknown column 'p.manufacturers_id' in 'on clause'

 

select count(*) as total from products p, products_description pd, products_to_categories pc left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '17'

 

Think i might just have to forget about the contribution now. Wish i could get it working .

 

Joe

Link to comment
Share on other sites

Hi,

 

thank you for the contrib. But I was wondering if there was a way to modify the prices and the special prices just the way you can do it with the weight, for example, i. e. all products, prices and special prices on one single page. Am I too stupid to configure the contrib correctly? I have installed Quick Price Vers. 3 -26.06.2007-

 

Thank you,

 

compuskill

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...