I have used Zend's ChainedSelector script to build a country and region (state, province, or city) selector pulldown where the country selected modifies the second region pulldown.
My problem is that the ChainedSelector script was written to only display the first selector item IF there was a coresponding match for the second selector. So my country list ends up only being those countries that have regions in the region table. I need all the countries to display but still build the array with the other regions that are needed for the second selector.
Any help getting this to work would be welcome. ~ Thanks!
Here is the ChainedSelector.php script (slightly modified to allow for the users records to display as SELECTED).
<?php
/
Class: chainedSelectors
Description: This class allows you to create two selectors. Selections
made in the first selector cause the second selector to be updated.
PHP is used to dynamically create the necessary JavaScript.
/
//These constants make the code a bit more readable. They should be
//used in in the creation of the input data arrays, too.
define("CS_FORM", 0);
define("CS_FIRST_SELECTOR", 1);
define("CS_SECOND_SELECTOR", 2);
define("CS_SOURCE_ID", 0);
define("CS_SOURCE_LABEL", 1);
define("CS_TARGET_ID", 2);
define("CS_TARGET_LABEL", 3);
class chainedSelectors
{
/
** Properties
/
//Array of names for the form and the two selectors.
//Should take the form of array("myForm", "Selector1", "Selector2")
var $names;
//Array of data used to fill the two selectors
var $data;
//Unique set of choices for the first selector, generated on init
var $uniqueChoices;
//Calculated counts
var $maxTargetChoices;
var $longestTargetChoice;
/
** Methods
/
//constructor
function chainedSelectors($names, $data)
{
/
**copy parameters into properties
/
$this->names = $names;
$this->data = $data;
/
** traverse data, create uniqueChoices, get limits
/
foreach($data as $row)
{
//create list of unique choices for first selector
$this->uniqueChoices[($row[CS_SOURCE_ID])] = $row[CS_SOURCE_LABEL];
//find the maximum choices for target selector
$maxPerChoice[($row[CS_SOURCE_ID])]++;
//find longest value for target selector
if(strlen($row[CS_TARGET_LABEL]) > $this->longestTargetChoice)
{
$this-> longestTargetChoice=strlen($row[CS_TARGET_LABEL]);
}
}
$this->maxTargetChoices = max($maxPerChoice);
}
//prints the JavaScript function to update second selector
function printUpdateFunction()
{
global $userinfo;
/
Create some variables to make the code
more readable.
/
$sourceSelector = "document." . $this->names[CS_FORM] . "." .
$this->names[CS_FIRST_SELECTOR];
$targetSelector = "document." . $this->names[CS_FORM] . "." .
$this->names[CS_SECOND_SELECTOR];
/
** Start the function
/
print("function update" .$this->names[CS_SECOND_SELECTOR] . "()\n");
print("{\n");
/
** Add code to clear out next selector
/
print("\t//clear " . $this->names[CS_SECOND_SELECTOR] . "\n");
print("\tfor(index=0; index < $this->maxTargetChoices; index++)\n");
print("\t{\n");
print("\t\t" . $targetSelector . ".options[index].text = '';\n");
print("\t\t" . $targetSelector . ".options[index].value = '';\n");
print("\t}\n\n");
print("\t" . $targetSelector . ".options[0].selected = true;\n\n");
/
** Add code to find which was selected
/
print("whichSelected = " . $sourceSelector . ".selectedIndex;\n");
/
Add giant "if" tree that puts values into target selector
based on which selection was made in source selector
/
//loop over each value of this selector
foreach($this->uniqueChoices as $sourceValue=>$sourceLabel)
{
print("\tif(" . $sourceSelector .
".options[whichSelected].value == " .
"'$sourceValue')\n");
print("\t{\n");
$count=0;
foreach($this->data as $row)
{
if($row[0] == $sourceValue)
{
$optionValue = $row[CS_TARGET_ID];
$optionLabel = $row[CS_TARGET_LABEL];
print("\t\t" . $targetSelector .
".options[$count].value = '$optionValue';\n");
if($optionValue==$userinfo[region])
print("\t\t" . $targetSelector .
".options[$count].selected = true;\n\n");
print("\t\t" . $targetSelector .
".options[$count].text = '$optionLabel';\n\n");
$count++;
}
}
print("\t}\n\n");
}
print("\treturn true;\n");
print("}\n\n");
}
//print the two selectors
function printSelectors()
{
global $userinfo;
/
**create prefilled first selector
/
print("<select name=\"" . $this->names[CS_FIRST_SELECTOR] . "\" " .
"onChange=\"update".$this->names[CS_SECOND_SELECTOR]."();\">\n");
foreach($this->uniqueChoices as $key=>$value)
{
print("\t<option value=\"$key\"");
if($key==$userinfo['country']) {
print (" SELECTED");
}
print(">$value</option>\n");
}
print("</select> <img src=\"images/global/recommended_info.gif\" align=\"absbottom\" border=\"0\" alt=\""._RECOMMENDED."\"><p>\n");
/
**create empty target selector
/
$dummyData = str_repeat("X", $this->longestTargetChoice);
print("<select name=\"".$this->names[CS_SECOND_SELECTOR]."\">\n");
for($i=0; $i < $this->maxTargetChoices; $i++)
{
print("\t<option value=\"\">$dummyData</option>\n");
}
print("</select>\n");
}
//prints a call to the update function
function initialize()
{
print("update" .$this->names[CS_SECOND_SELECTOR] . "();\n");
}
}
?>
