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();
}
public function bindListRfCValue()
{
$this->ChangeListe->VirtualItemCount = count(RfCRecord::finder()->findAll());
$criteria = new TActiveRecordCriteria();
$criteria->setLimit($this->ChangeListe->PageSize);
$criteria->setOffset($this->ChangeListe->PageSize * $this->ChangeListe->CurrentPageIndex);
$this->ChangeListe->DataKeyField = 'idtm_rcvalue';
$this->ChangeListe->VirtualItemCount = count(RfCRecord::finder()->findAll());
$this->ChangeListe->DataSource = RfCRecord::finder()->findAll($criteria);
$this->ChangeListe->dataBind();
}
public function bindListPivotBerichtValue()
{
$this->PivotBerichtListe->VirtualItemCount = count(PivotBerichtRecord::finder()->findAll());
$criteria = new TActiveRecordCriteria();
$criteria->setLimit($this->PivotBerichtListe->PageSize);
$criteria->setOffset($this->PivotBerichtListe->PageSize * $this->PivotBerichtListe->CurrentPageIndex);
$this->PivotBerichtListe->DataKeyField = 'idta_pivot_bericht';
$this->PivotBerichtListe->VirtualItemCount = count(PivotBerichtRecord::finder()->findAll());
$this->PivotBerichtListe->DataSource = PivotBerichtRecord::finder()->findAll($criteria);
$this->PivotBerichtListe->dataBind();
}
public function bindListCostActivityValue()
{
$SQL = "SELECT a.idtm_activity AS idtm_activity, a.act_name AS act_name, a.act_dauer AS act_dauer,SUM( act_dauer * res_kosten *8 ) AS ttact_kosten FROM tm_activity a INNER JOIN tm_organisation b ON a.idtm_organisation = b.idtm_organisation INNER JOIN tm_ressource c ON b.idtm_ressource = c.idtm_ressource GROUP BY act_name, idtm_activity ORDER BY act_startdate";
$this->ActivityKostenListe->VirtualItemCount = count(ActivityRecord::finder()->findAllBySQL($SQL));
$criteria = new TActiveRecordCriteria();
$criteria->setLimit($this->ActivityKostenListe->PageSize);
$criteria->setOffset($this->ActivityKostenListe->PageSize * $this->ActivityKostenListe->CurrentPageIndex);
$this->ActivityKostenListe->DataKeyField = 'idta_activity';
$this->ActivityKostenListe->DataSource = ActivityRecord::finder()->findAllBySQL($SQL);
$this->ActivityKostenListe->dataBind();
$this->generateRisikoGraph(ActivityRecord::finder()->findAllBySQL($SQL));
}
public function searchOrg($sender, $param)
{
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "ris_name LIKE :suchtext";
$criteria->Parameters[':suchtext'] = "%" . $this->find_org->Text . "%";
$criteria->setLimit($this->OrgListe->PageSize);
$criteria->setOffset($this->OrgListe->PageSize * $this->OrgListe->CurrentPageIndex);
$this->OrgListe->DataKeyField = 'idtm_risiko';
$this->OrgListe->VirtualItemCount = count(RisikoRecord::finder()->withristype()->find($criteria));
$this->OrgListe->DataSource = RisikoRecord::finder()->withristype()->findAll($criteria);
$this->OrgListe->dataBind();
}
/**
* @return TActiveRecordCriteria sort/search/paging criteria
*/
protected function getRecordCriteria()
{
$total = $this->_list->getVirtualItemCount();
$limit = $this->_list->getPageSize();
$offset = $this->_list->getCurrentPageIndex() * $limit;
if ($offset + $limit > $total) {
$limit = $total - $offset;
}
$criteria = new TActiveRecordCriteria($this->getSearchCondition(), $this->getSearchParameters());
if ($limit > 0) {
$criteria->setLimit($limit);
if ($offset <= $total) {
$criteria->setOffset($offset);
}
}
$order = explode(' ', $this->_sort->getSelectedValue(), 2);
if (is_array($order) && count($order) === 2) {
$criteria->OrdersBy[$order[0]] = $order[1];
}
return $criteria;
}
public function clearProStep()
{
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "prostep_name LIKE :suchtext";
$criteria->Parameters[':suchtext'] = "%leer%";
$criteria->setLimit($this->ProStepListe->PageSize);
$criteria->setOffset($this->ProStepListe->PageSize * $this->ProStepListe->CurrentPageIndex);
$this->ProStepListe->DataKeyField = 'idtm_prozess_step';
$this->ProStepListe->VirtualItemCount = count(ProzessStepRecord::finder()->find($criteria));
$this->ProStepListe->DataSource = ProzessStepRecord::finder()->findAll($criteria);
$this->ProStepListe->dataBind();
}
public function clearProStep($agent_x)
{
$criteria = new TActiveRecordCriteria();
$criteria->Condition = "idtm_ziele = :suchtext";
$criteria->Parameters[':suchtext'] = $agent_x;
$criteria->setLimit($this->ProStepListe->PageSize);
$criteria->setOffset($this->ProStepListe->PageSize * $this->ProStepListe->CurrentPageIndex);
$this->ProStepListe->DataKeyField = 'idtt_ziele';
$this->ProStepListe->VirtualItemCount = count(TTZieleRecord::finder()->find($criteria));
$this->ProStepListe->DataSource = TTZieleRecord::finder()->findAll($criteria);
$this->ProStepListe->dataBind();
}