azer Posted July 8, 2005 Share Posted July 8, 2005 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 ? Quote MS2 Link to comment Share on other sites More sharing options...
azer Posted July 8, 2005 Author Share Posted July 8, 2005 there is also this request : http://www.oscommerce.com/forums/index.php?sho...66entry651266 Quote MS2 Link to comment Share on other sites More sharing options...
xempel Posted October 31, 2005 Share Posted October 31, 2005 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 Quote Link to comment Share on other sites More sharing options...
Spaceboy Posted March 27, 2006 Share Posted March 27, 2006 :( 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. Quote Published modified Contributions Link to comment Share on other sites More sharing options...
Spaceboy Posted March 29, 2006 Share Posted March 29, 2006 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. Quote Published modified Contributions Link to comment Share on other sites More sharing options...
gtr_rider Posted April 22, 2006 Share Posted April 22, 2006 That patch you supplied creates a unending list of products that are continuous repeated for pages upon pages. Quote Link to comment Share on other sites More sharing options...
Spaceboy Posted May 1, 2006 Share Posted May 1, 2006 It works fine for me. Is the SQL statement correct according to you ? Quote Published modified Contributions Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2006 Share Posted August 17, 2006 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. Quote Link to comment Share on other sites More sharing options...
aapinen Posted August 21, 2006 Share Posted August 21, 2006 I have similar problem as this: http://www.oscommerce.com/forums/index.php?sho...=217288&hl= I guess here is a answet but dont know what this mean becouse it's in german: http://forums.oscommerce.de/lofiversion/in...php?t43363.html Quote Link to comment Share on other sites More sharing options...
Thenes Posted August 29, 2006 Share Posted August 29, 2006 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. Quote Link to comment Share on other sites More sharing options...
Patty Posted April 11, 2007 Share Posted April 11, 2007 :(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?? Quote Patty Link to comment Share on other sites More sharing options...
PD_Steve Posted May 8, 2007 Share Posted May 8, 2007 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 Quote My Toolbox: Crimson Editor, Adobe Photoshop CS2.0, Expression Web, Macromedia Suite 8.0, Cinema 4D, Nvu. Link to comment Share on other sites More sharing options...
squalid Posted May 30, 2007 Share Posted May 30, 2007 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 :( Quote Link to comment Share on other sites More sharing options...
renux Posted May 31, 2007 Share Posted May 31, 2007 in the store, prices display "neto" not "bruto" (VAT) :( Quote Link to comment Share on other sites More sharing options...
Elazar Posted July 11, 2007 Share Posted July 11, 2007 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2007 Share Posted July 14, 2007 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 Quote Link to comment Share on other sites More sharing options...
Elazar Posted July 15, 2007 Share Posted July 15, 2007 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 Quote Link to comment Share on other sites More sharing options...
Thenes Posted July 26, 2007 Share Posted July 26, 2007 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. Quote Link to comment Share on other sites More sharing options...
joebloggs Posted July 27, 2007 Share Posted July 27, 2007 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 Quote Link to comment Share on other sites More sharing options...
Thenes Posted July 30, 2007 Share Posted July 30, 2007 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 Quote Link to comment Share on other sites More sharing options...
joebloggs Posted July 30, 2007 Share Posted July 30, 2007 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 Quote Link to comment Share on other sites More sharing options...
Thenes Posted July 30, 2007 Share Posted July 30, 2007 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 Quote Link to comment Share on other sites More sharing options...
joebloggs Posted August 1, 2007 Share Posted August 1, 2007 Quote Link to comment Share on other sites More sharing options...
joebloggs Posted August 7, 2007 Share Posted August 7, 2007 Quote Link to comment Share on other sites More sharing options...
compuskill Posted August 9, 2007 Share Posted August 9, 2007 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.