Validation help - In stock check

[amminist]

Hi
I would like to create a script to check if the order quantity is less than the quantity in stock and <500.
I have two tables
Product
ID
Description
Quantity in sotck (As calculated field from child Order - sum of quantity)
...

Order
ID
Product_ID
Quantity (int)
...



thanks to udemy course i created a table-dv.js ( order-dv.js) to verify that the quantity does not exceed 500 ( and it works! ) but i don't know how to get Quantity_in_stock.Product to compare with the entered quantity.order

Code: Select all

function show_error(field, msg){
	modal_window({
		message: '<div class="alert alert-danger">' + msg + '</div>',
		title: 'Error in ' + field,
		close: function(){
			$j('#' + field).focus();
			$j('#' + field).parents('.form-group').addClass('has-error');
		}
	});

	return false;
}

$j(function(){
	$j('#update, #insert').click(function(){

		/* Quantity < 500 */
		var quantita = $j('#Quantita').val();



		if(isNaN(quantita) || quantita < 500 ){
			return show_error('Quantita', 'Inserire un numero < 500.');
		}


	});
})

Can anyone help me?


Ivan

[pböttcher]

Hi,

at the time the user enters the Quantity (on change event) you could retrive the Quantity in stock via ajax and check if enough is available.

[fdissait]

ok !
but how retrieve a look-up value from another table using ajax ?
I try several weeks without any success.
François

[pböttcher]

Hi,
can you explain a bit detailled how your stucture looks like?

[amminist]

Same problem, do you know any site to understand the basics of ajax call in java script? I would like to understand and study how to create the call and how to use its result as a js variable.. Thanks
Ivan

[jsetzer]

W3schools has some nice tutorials:
https://www.w3schools.com/js/js_ajax_intro.asp

There is also help on Bootstrap, for example.