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(); }