public function bindList()
{
$SQL1 = "SELECT ta_adresse.idta_adresse FROM ta_adresse INNER JOIN ta_partei_has_ta_adresse ON ta_adresse.idta_adresse = ta_partei_has_ta_adresse.idta_adresse INNER JOIN ta_partei ON ta_partei_has_ta_adresse.idta_partei = ta_partei.idta_partei WHERE ta_partei.idtm_user = "******"idta_adresse = '0'";
}
$criteria->Condition = $myCondition;
$criteria->setLimit($this->RepeaterWaren->PageSize);
$criteria->setOffset($this->RepeaterWaren->PageSize * $this->RepeaterWaren->CurrentPageIndex);
if (is_Object(WarenRecord::finder()->find($criteria))) {
$this->RepeaterWaren->VirtualItemCount = WarenRecord::finder()->find($criteria)->count();
}
$this->RepeaterWaren->DataSource = WarenRecord::finder()->findAll($criteria);
$this->RepeaterWaren->DataBind();
}
private function bindListed()
{
$SQL1 = "SELECT ta_adresse.* FROM ta_adresse INNER JOIN ta_partei_has_ta_adresse ON ta_adresse.idta_adresse = ta_partei_has_ta_adresse.idta_adresse INNER JOIN ta_partei ON ta_partei_has_ta_adresse.idta_partei = ta_partei.idta_partei WHERE ta_partei.idtm_user = "******" LIMIT " . $this->AdresseListe->PageSize * $this->AdresseListe->CurrentPageIndex . "," . $this->AdresseListe->PageSize;
$this->edAdresseListe->DataKeyField = 'edlstidta_adresse';
$validate = PFH::checkCountStatement(AdresseRecord::finder()->findBySql($SQL1));
if ($validate) {
$this->edAdresseListe->VirtualItemCount = AdresseRecord::finder()->findBySql($SQL1)->Count();
} else {
$this->edAdresseListe->VirtualItemCount = 0;
}
$this->edAdresseListe->DataSource = $adressen = AdresseRecord::finder()->findAllBySql($SQL1);
$this->edAdresseListe->dataBind();
}
private function edbindList()
{
$SQL1 = "SELECT tm_termin.* FROM tm_termin ORDER BY ter_startdate DESC";
$SQL1 .= " LIMIT " . $this->edActListe->PageSize * $this->edActListe->CurrentPageIndex . "," . $this->edActListe->PageSize;
$this->edActListe->DataKeyField = 'idtm_termin';
$validate = PFH::checkCountStatement(TerminRecord::finder()->findBySql($SQL1));
if ($validate) {
$this->edActListe->VirtualItemCount = TerminRecord::finder()->findBySql($SQL1)->Count();
} else {
$this->edActListe->VirtualItemCount = 0;
}
$this->edActListe->DataSource = TerminRecord::finder()->findAllBySql($SQL1);
$this->edActListe->dataBind();
}
