Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Availability & Warranty Manager 1.0.5 for 2.3.1


BdMdesigN

Recommended Posts

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

Link to comment
Share on other sites

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 by BdMdesigN
Link to comment
Share on other sites

  • 3 weeks later...

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 ?

Link to comment
Share on other sites

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

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