CiviCRM Community Forums (archive)

Thanks to the 3.2 udpate, country and state are available as drop down menus if you expose them as drupal views filters. 

The problem is that they don't have any of the Civi handling to limit the states by the country selected.  That means if you enable all countries, you'll have about 3700 options in the state drop down.  The attached patch modifies the /civicrm/drupal/modules/views/civicrm/civicrm_handler_filter_state.inc file so that if a country filter and state/province filter exist, the state/province will be conditional based on the country selected.

For those who don't use patches, here's the added code:
        /*
         * code to add country->state/province conditional options
         * first determine if there's a country filter on this view
         * if there is, load the country->state options into a JSON
         * object we can attach via javascript.  Remove the state
         * options set above and attach the javascript handler
         */
       
        // get the country filter
        foreach ($this->view->filter as $name=>$handler) {
            if ($handler->definition['handler'] == 'civicrm_handler_filter_country') {
                $country = $handler->field;

                $result = db_query('SELECT country_id, id, name FROM {civicrm_state_province} WHERE country_id IN (%s)', implode(', ', array_keys($handler->value_options)));
                $countries = array();
                while ($row = db_fetch_array($result)) {
                    $countries[$row['country_id']] .= '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
                }
                $c_object = json_encode($countries);
            }
        }//end foreach

       // country filter exists, remove options, add js
       if ($country) {
           $this->value_options = array();

           $js = 'var stateCountryOptions = ' . $c_object . ';
               jQuery("select[name=' . $country . ']").change( function() {
                   var selectedCountry = jQuery(this).val();
                   // get the string of options
                   var stateList = \'<option value="All">&lt;Any&gt;</option>\' + ((stateCountryOptions[selectedCountry])? stateCountryOptions[selectedCountry] : \'\');
                   jQuery("select[name=' . $this->field . ']").empty();
                   jQuery("select[name=' . $this->field . ']").html(stateList);
               });';
           drupal_add_js($js, 'inline', 'footer');
       } // end if country filter

insert on line 59 right after the if block, but before the end of the get_value_options() function

Did anything come out of it?

Not sure if it will be approved of, but i went ahead and made a ticket and attached the above - i suspec the above will need some love before it is 4.3/4.4 viable

http://issues.civicrm.org/jira/browse/CRM-12462