/* INFO! return the DB  about table Ordini information from a python script */
$(function()  {
	$("select#year").change(function() {
		$.getJSON("select_orderId", {yearval: $(this).val()}, function(j) {
			var options = '';
			for (var i = 0; i < j.length; i++) {
				options += '<option value="' + j[i].ID + '">' + j[i].ID+ '</option>';
			}
			if ($("select#year").val() == "Tutti gli anni")
              {
                $("#order-id:first").html("<option selected='selected' value='Tutti gli ordini'>Tutti gli ordini</option>");
              }
            else
            {
				$("#order-id").html(options);
				$("#order-id:first").prepend("<option selected='selected' value='Tutti gli ordini'>Tutti gli ordini</option>");
            }
		})
	})
})

/* INFO! return the DB information about table tblprovince from a python script */
$(function()  {
	$("select#reg-id").change(function() {
		$.getJSON("select_province", {regId: $(this).val()}, function(j) {
			var options = '';
			for (var i = 0; i < j.length; i++) {
				options += '<option value="' + j[i].IdProvincia + '">' + j[i].strProvincia + '</option>';
			}
            if ($("select#reg-id").val() == "")
              {
                $("#prov-id:first").html("<option selected='selected' value='0'>Seleziona Provincia</option>");
              }
            else
            {
              $("#prov-id").html(options);
              $("#prov-id:first").prepend("<option selected='selected' value='0'>Seleziona Provincia</option>");
            }
		})
	})
})