Hi all,

Just wondering whether anyone had any experience of customising the AJAX combo to only list FK items that didn't already exist in the current table.

Scenario
I have a table productfinishes that stores 2 Foreign Keys - product & finish. When the user selects the product, I want the finish field to display all available finishes (from finishes table) that don't currently exist in productfnishes WHERE product = the user selected product.

To clarify this, products can have multiple finishes and finishes can belong to many products but the combination of product + finish must be unique. I will be handling this at DB level using a UNIQUE index on (product, finish) as per post here: www.j-cook.pro/forum/12-new-functionalit...k-combination-unique

However, I want to make the input stage dummy-proof to prevent the user from being able to enter incorrect combinations in the first place.

Any help on modifications to achieve this would be most welcomed!

Many thanks!

Gez

Always the same reflex you must have.

1. Create a new SQL query context (in the appropriate collection model)
2. Receive possible state vars to customize from the caller (to receive important filter vars for your query)
3. From the caller, define 'context' state var , define your parameters to send (state vars)

Now in your example, AJAX is generated in the view file. Function displayAjax(). You will find all there.

Very important :
the state vars need to be sent BEFORE $model->getItems()

I think you have everything that you need.

I need to do something similar.
I need the user to select the supplier from a combo, then an ajax event needs to fire to update the style combo with only valid options for this supplier.
I've looked at the code an kind of understand what's happening. I need to know how to trigger the ajax call to populate the second combo box, using your ajax code in dom. If I understand correctly, the ajax call is triggered on load of page?

Update : DOES THIS LOOK OK? SEEMS TO BE WORKING - ADDED THIS TO THE TEMPLATE
jQuery("#jform_supplier").change(function()
{ var supplier = jQuery(this).val();
var vars = {"values": [ "" , supplier ]};
jQuery("#_ajax_style_select1").jdomAjax({
"namespace":"supplierportal.style.ajax.select1",
"vars": vars
});
});

Hi
I also just found that I had to add this to the displayAjax() function in View
$model->setState('list.limit','');
Otherwise, only a few items were displayed.

Update
Oeps I see this should be set in the model :

// Disable the pagination
$this->setState('list.limit', null);
$this->setState('list.start', null);

This will be solved in 2.0 release.
The problem is because the model context is not properly handled.

In the new coming version, the ajax calls will be much better handled (no possible conflicts with others permanent vars or filters, no conflicts of pagination...)

Thank you for your reply. I love your app, thank you so much! At last I understand the ajax code and I managed to do what was required from me by using your ajax code. Working like a charm!