4 replies to this topic

[BdMdesigN]

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

[BdMdesigN]

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, 18 July 2012 - 03:05 PM.

[BdMdesigN]

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 by BdMdesigN, 22 July 2012 - 03:03 AM.

[psytanium]

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 ?

[psytanium]

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