TYPO3 Formidable - PasteBin

Generate a dynamic AJAX LISTBOX with a SELECTOR

Permalink to this snippet:

http://formidable.typo3.ug/pastebin/snippet/115.html

The authors comment:

It was hard to create a AJAX's dynamic list from another list. I did not succeded neither with dependcies, nor two SELECTOR, so I made this kind of "workaround" but that's working.

Hope it will help !

USING FORMIDABLE 2.0.421

Antoine Rochefort, 2010-08-31@15:22:55, pasted:

<renderlet:SELECTOR defaultWrap="false" name="region" style="height : 200px" class="selector" label="Regions *" activeListable="true" >
    <validators>
        <validator:STANDARD>
            <required message="Sélectionnez au moins une région pour obtenir la liste des département correspondant. Cette informations est requise." />
        </validator:STANDARD>
    </validators>
    <available>
        <data>
            <userobj>
                <php><![CDATA[

/*$aRow = $this->oDataHandler->getListData();
                    $numregion = $aRow["uid"]; */

$result= $GLOBALS["TYPO3_DB"]->exec_SELECTgetRows(
                    "uid as value, region as caption",
                    "tx_bdd_regions",
                    "pid = 63", //AND  tx_bdd_departements.id_region = " . $numregion ,
                    "",
                    "region ASC");
                    
                    return $result;
                    
                ]]></php>
            </userobj>
        </data>

<onChange runat="ajax" params="encapsulation.region" when="before-init-renderlets" >
            <userobj>
                <php><![CDATA[
                    $aParams = func_get_arg(1);
                    $sText = implode(',', array_merge($aParams["encapsulation.region"]["selected"], $aParams["encapsulation.region"]["available_active"] ));
                    $this->oSandBox->liste_regions = $sText;

$aItems = $this->aORenderlets["encapsulation"]->aChilds["departement"]->_getItems();
                    return $this->aORenderlets["encapsulation"]->aChilds["departement"]->majixReplaceData($aItems);

//return array($this->aORenderlets["encapsulation"]->aChilds["departement.available"]->majixRepaint());
                ]]></php>
            </userobj>
        </onChange>
    </available>

<buttonRemove type="IMAGE" label="" path="EXT:ameos_formidable/api/base/rdt_selector/res/img/remove.gif" >
        <onClick runat="ajax" params="encapsulation.region" when="before-init-renderlets" >
            <userobj>
                <php><![CDATA[
                    $aParams = func_get_arg(1);
                    //return $this->majixDebug($aParams["encapsulation.region"]);
                    $sText = implode(',', $aParams["encapsulation.region"]["selected"]);
                    $this->oSandBox->liste_regions = $sText;

]]></php>
            </userobj>
        </onClick>
    </buttonRemove>
    
</renderlet:SELECTOR>

<renderlet:LISTBOX multiple="true" defaultWrap="false" name="departement" class="selector" label="CTRL + clic pour en sélectionner plusieurs" style="float:left;" activeListable="true" >
                
    
        <data>
            <userobj>
                <php><![CDATA[
                    //$aRow = $this->oDataHandler->getStoredData();
                    //$regions = $aRow["region"];

if ($this->oSandBox->liste_regions == "init" ) {
                        $aRow = $this->oDataHandler->getStoredData();
                        $regions = $aRow["region"];
                    } else {
                        $regions = $this->oSandBox->liste_regions;
                    }

$regions = explode(",", $regions);
                    
                    $result = array();
                    //debugster($regions);

foreach($regions as $une_region) {
                        $res = $GLOBALS["TYPO3_DB"]->exec_SELECTgetRows(
                        "uid as value, CONCAT('&nbsp;', numero, ' - ',departement ) as caption, departement",
                        "tx_bdd_departements",
                        "id_region = " . $une_region ,
                        "",
                        "");
                        foreach ($res as $value) {
                            $result[$value['departement']] = $value;
                        }
                    }

sort($result);
                    return $result;
                    
                ]]></php>
            </userobj>
        </data>

</renderlet:LISTBOX>

Generate a dynamic AJAX LISTBOX with a SELECTOR

Download

Features

Documentation

Many thanks to

Latest snippets