BdMdesigN Posted July 18, 2012 Share Posted July 18, 2012 I have awake the AddOn Availability 1.0.4 to a new Live in osC 2.3.1. You can with a Switch turn on/off the Traffic Light Availability image for each Product in the Product Configuratin Page (categories.php) You have 5 categories.phpOptions (text and images) Warranty Option in categories.php added You can get the AddOn here: http://addons.oscommerce.com/info/4948 (Availability & Warranty Manager 1.0.5 for 2.3.1) http://addons.oscommerce.com/info/8496 (Availability & Warranty Manager 1.0.4 for 2.3.1) Best Regards Peter Quote Link to comment Share on other sites More sharing options...
BdMdesigN Posted July 18, 2012 Author Share Posted July 18, 2012 (edited) Traffic Light ON/OFF switch fix: open in catalog/YourAdminFolder/categories.php serch for line 218: tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id)); break; case 'insert_product': case 'update_product': if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); $products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null'; $sql_data_array = array('products_quantity' => (int)tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), // BOF: Availability + Warranty 'warranty_id' => tep_db_prepare_input($_POST['warranty_id']), ->> 'availability_status' => tep_db_prepare_input($_POST['products_status']), 'availability_id_in_stock' => tep_db_prepare_input($_POST['availability_id_in_stock']), 'availability_id_in_stock2' => tep_db_prepare_input($_POST['availability_id_in_stock2']), 'availability_id_in_stock3' => tep_db_prepare_input($_POST['availability_id_in_stock3']), change to: 'availability_status' => tep_db_prepare_input($_POST['availability_status']), search for line 384: // BOF: Availability + Warranty Added: , warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, availability_id_out_of_stock_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero $product_query = tep_db_query("select products_quantity, products_model, warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_out_of_stock_image, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, products_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); // EOF: Availability + Warranty cange to: // BOF: Availability + Warranty Added: , warranty_id, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, availability_id_out_of_stock_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero $product_query = tep_db_query("select products_quantity, products_model, warranty_id, availability_status, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, availability_id_out_of_stock_image, availability_id_in_stock_image, availability_id_in_stock2_image, availability_id_in_stock3_image, availability_id_in_stock_special_image, products_image, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); // EOF: Availability + Warranty search for line 499 - 504: if (!isset($pInfo->products_status)) $pInfo->products_status = '1'; switch ($pInfo->products_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } add after it: // BOF: Availability if (!isset($pInfo->availability_status)) $pInfo->availability_status = '1'; switch ($pInfo->availability_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } // EOF: Availability thats all. Now the switch works correctly. Best Regards Peter Edited July 18, 2012 by BdMdesigN Quote Link to comment Share on other sites More sharing options...
BdMdesigN Posted July 22, 2012 Author Share Posted July 22, 2012 (edited) Update to Availability & Warranty Manager 1.0.7 for 2.3.1 now under http://addons.oscommerce.com/info/8496 available. Best Regards Peter Edited July 22, 2012 by BdMdesigN Quote Link to comment Share on other sites More sharing options...
Psytanium Posted August 10, 2012 Share Posted August 10, 2012 Hi Peter, i appreciate your work on this important addon. i have done working on the 1.0.4 version. the problem is when i try to insert a new product i get this error message: 1054 - Unknown column 'warranty_id' in 'field list' insert into products (products_quantity, warranty_id, availability_status, availability_id_in_stock, availability_id_in_stock2, availability_id_in_stock3, availability_id_in_stock_special, availability_id_out_of_stock, quantity_stock, quantity_stock_2, quantity_stock_3, quantity_stock_special, quantity_stock_zero, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('0', '3', '1', '1', '3', '1', '5', '2', '', '', '', '', '', 'test model', '34', null, '0', '1', '0', '97', 'orfali-url-final.png', now()) i think i have done something wrong with the sql setup. can you point me to the problem plz ? Quote Link to comment Share on other sites More sharing options...
Psytanium Posted August 10, 2012 Share Posted August 10, 2012 never mind the above post... the problem was some missing columns in the products table. i have insert them column by column from the phpmyadmin. Now the new question (sorry for bothering)... how can i remove all the quantity related options ? i just need to tell if the product is available or not. (only those 2 options) nothing related to the quantity. BIG THX 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.