Thank you very much for the reply. I have been looking high and low for a solution. I will let you know how I go with this. Thanks
Themselves wrote: > > I have spent WAY too much time getting this exact scenario working using > Zend Dojo forms and an MVC environment, and I plan on building an > extensive > article explaining it all soon, but for now, here's the really quick and > dirty version. I haven't gotten my version perfect yet, I'm still not > happy > with the URLs I'm calling to retrieve the data, but that's not a huge > deal. > Anyway, on with the show. > > First of all, here's your two form elements. > > $this->addElement('FilteringSelect', 'fk_client_id', array( > 'label' => 'Client:', > 'storeId' => 'clientStore', > 'storeType'=> 'dojo.data.ItemFileReadStore', > 'storeParams' => array( 'url' => > '/clients/autocomplete/format/ajax?autocomplete=1&str=*',), > 'autoComplete' => 'false', > 'hasDownArrow' => 'true', > 'id' => 'fk_client_id', > )); > > $this->addElement('FilteringSelect', 'fk_client_contact_id', > array( > 'label' => 'Client contact:', > 'storeId' => 'clientContactStore', > 'storeType'=> 'dojo.data.ItemFileReadStore', > 'autoComplete' => 'false', > 'hasDownArrow' => 'true', > 'id' => 'fk_client_contact_id', > )); > > Now for the javascript, this has to appear somewhere on the page that > contains the form. > > dojo.connect(dijit.byId('fk_client_id'), 'onChange', function () { > dijit.byId('fk_client_contact_id').store = new > dojo.data.ItemFileReadStore({ url: > "/clientcontacts/autocomplete/format/ajax?autocomplete=1&fk_client_id=" + > dijit.byId("fk_client_id").value }); > }); > > > As for the URLs for the Datastores, they are kind of an exercise for the > reader, other than to say they obviously should filter correctly on the > passed parameters, and they have to return JSON. This part was pretty > annoying, but I eventually found that a function like this returns the > correct JSON format: > > public function prepareAutoCompletion($data) { > $items = array(); > foreach ($data as $key => $value) { > $items[] = array('label' => $value, 'name' => $value, 'key' => > $key); > } > $final = array( > 'identifier' => 'key', > 'items' => $items, > ); > return $this->encodeJson($final); > } > > > You pass in to the function an array of id => value pairs, and it will > output the correct JSON for the FilteringSelects. If you use the built in > AutoCompleteDojo helper, it won't use the id from your table as the value > that the form submits, which is pretty much useless. > > Oh, and one more trick, for the Edit action, you are going to need to > include something like this: > > $form->populate($row); > $form->getElement('fk_client_contact_id')->setStoreParams(array( 'url' => > '/clientcontacts/autocomplete/format/ajax?&autocomplete=1&fk_client_id=' . > $form->getElement('fk_client_id')->getValue() )); > > So that it prepopulates the form correctly. > > I promise I'll write up a really impressive document that spells this > whole > thing out in painstaking detail, I'm just absolutely flat out until > christmas, I haven't had any time! > > > On Tue, Dec 9, 2008 at 10:58 AM, Ace Paul <[EMAIL PROTECTED]> > wrote: > >> >> I have a form, which I would like to use dependent drop downs in. I can't >> seem to find anything about it hear, after looking all morning trying to >> work it out. >> I have one field "race_country" >> when an option is selected I would like to show the cities in that >> country. >> The following is what I have currently in the form, which will show all >> countries and all cities. >> Any help would be great. thanks >> >> $table = new Country(); >> foreach ($table->fetchAll() as $c) { >> $country->addMultiOption($c->country_id, $c->country_name); >> } >> $this->addElement( $country); >> >> $city = new Zend_Form_Element_Select('race_city'); >> $city->setLabel('City') >> ->setRequired(true); >> >> $table = new City(); >> foreach ($table->fetchAll() as $c) { >> $city->addMultiOption($c->city_id, $c->city_name); >> } >> $this->addElement( $city); >> -- >> View this message in context: >> http://www.nabble.com/How-to-set-up-dependant-dropdowns-in-form-tp20907379p20907379.html >> Sent from the Zend Framework mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/How-to-set-up-dependant-dropdowns-in-form-tp20907379p20910287.html Sent from the Zend Framework mailing list archive at Nabble.com.