public function suggestUser($sender, $param) { // Get the token $token = $param->getToken(); // Sender is the Suggestions repeater $mySQL = "SELECT idtm_user,user_name FROM tm_user WHERE user_name LIKE '%" . $token . "%'"; $sender->DataSource = PFH::convertdbObjectSuggest(TActiveRecord::finder('UserRecord')->findAllBySQL($mySQL), array('idtm_user', 'user_name')); $sender->dataBind(); }
public function suggestOrganisation($sender, $param) { // Get the token $token = $param->getToken(); // Sender is the Suggestions repeater $mySQL = "SELECT idtm_organisation,org_name,org_vorname FROM tm_organisation WHERE org_name LIKE '%" . $token . "%'"; $sender->DataSource = PFH::convertdbObjectSuggest(TActiveRecord::finder('OrganisationRecord')->findAllBySQL($mySQL), array('idtm_organisation', 'org_name', 'org_vorname')); $sender->dataBind(); }