public function bind_lstAdress() { $criteria_p = new TActiveRecordCriteria(); $criteria_p->Condition = 'idta_partei = :idta_partei'; $criteria_p->Parameters[':idta_partei'] = $this->idta_partei->Text; $templisteadresse = ParteiAdresseRecord::finder()->findAll($criteria_p); $listeadresse = (array) $templisteadresse; $mydata = array(); foreach ($listeadresse as $walker) { $conditionx = new TActiveRecordCriteria(); $conditionx->Condition = 'idta_adresse = :idta_adresse'; $conditionx->Parameters[':idta_adresse'] = $walker->idta_adresse; array_push($mydata, AdresseRecord::finder()->find($conditionx)); } //print_r($mydata); $this->lstAdress->DataSource = $mydata; $this->lstAdress->dataBind(); }
public function onInit($param) { //first i like to get all records... $mydata = array(); // populates post data into the repeater $companies = $this->buildData(); foreach ($companies as $companie) { $criteria_p = new TActiveRecordCriteria(); $criteria_p->Condition = 'idta_partei = :idta_partei'; $criteria_p->Parameters[':idta_partei'] = $companie->idta_partei; $templisteadresse = ParteiAdresseRecord::finder()->findAll($criteria_p); $listeadresse = (array) $templisteadresse; //print_r($listeadresse); foreach ($listeadresse as $walker) { $conditionx = new TActiveRecordCriteria(); $conditionx->Condition = 'idta_adresse = :idta_adresse'; $conditionx->Parameters[':idta_adresse'] = $walker->idta_adresse; array_push($mydata, AdresseRecord::finder()->find($conditionx)); } } //print_r($mydata); $ii = 0; foreach ($mydata as $mylocaladress) { $marker = prado::createComponent('BActiveGoogleMapMarker'); $marker->setID("p" . $ii); //$marker->setTitle('Adress:'.$mylocaladress->adresse_town."-".$mylocaladress->adresse_street); $marker->setTitle('Standort'); $marker->setPoint(array($mylocaladress->adresse_lat, $mylocaladress->adresse_long)); $marker->setVisible(true); $infobulle = prado::createComponent('TLabel'); $infobulle->setID('greentradeinfo' . $mylocaladress->idta_adresse); $infobulle->setText("Klappt"); $marker->addedControl($infobulle); $this->GoogleMap->addMarker($marker); if ($ii == 0) { $this->GoogleMap->setCenter("(" . implode(",", array($mylocaladress->adresse_lat, $mylocaladress->adresse_long)) . ")"); } $ii++; } }
public function dataBindRepeater2($sender, $param) { $item = $param->Item; if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') { $criteria_p = new TActiveRecordCriteria(); $criteria_p->Condition = 'idta_partei = :idta_partei'; $criteria_p->Parameters[':idta_partei'] = $item->data->idta_partei; $templisteadresse = ParteiAdresseRecord::finder()->findAll($criteria_p); $listeadresse = (array) $templisteadresse; //print_r($listeadresse); $mydata = array(); foreach ($listeadresse as $walker) { $conditionx = new TActiveRecordCriteria(); $conditionx->Condition = 'idta_adresse = :idta_adresse'; $conditionx->Parameters[':idta_adresse'] = $walker->idta_adresse; array_push($mydata, AdresseRecord::finder()->find($conditionx)); } //print_r($mydata); $item->Repeater2->DataSource = $mydata; $item->Repeater2->dataBind(); } }