lófasz

public function getRecipientsXMLList($user_id,$search_term)
    {
        $user=$this->fetchUserById($user_id);
        $company_id=$user->group[0]->identifier;
        $stm=$this->dbAdapter->createStatement("SELECT * FROM `users` WHERE (`first_name` LIKE '%".$search_term."%' OR 'last_name' LIKE '%".$search_term."%') AND `company` = :company_id AND `deleted` = 0 ORDER BY `first_name` ASC");

        $params=array(
            "company_id"=>$company_id
        );
        $users=$stm->execute($params);
        $rowXML=[];
        $rowXML[]="<recipients>";
        foreach($users as $row) {
            $id=$row['id'];
            $name= sprintf("%s %s",$row['first_name'],$row['last_name']);
            $profileimage=$row['profileimage'];
            $rowXML[]="<user>";
            $rowXML[]=sprintf("<id>%s</id>",$id);
            $rowXML[]=sprintf("<name>%s</name>",$name);
            $rowXML[]=sprintf("<profileimage>%s</profileimage>",$profileimage);
            $rowXML[]="</user>";
        }
        $stm=$this->dbAdapter->createStatement("SELECT * FROM user_group ug INNER JOIN user_group_connection ugc ON ug.id = ugc.group_id WHERE ug.group_name LIKE '%".$search_term."%' AND ugc.active = 1 AND ug.deleted=0 AND ugc.user_id= :user_id");
        $params=array(
            "user_id"=>$user_id
        );
        $user_groups=$stm->execute($params);
        foreach($user_groups as $row) {
            $id=$row['group_id'];
            $name= sprintf("%s",$row['group_name']);
            $rowXML[]="<group>";
            $rowXML[]=sprintf("<id>%s</id>",$id);
            $rowXML[]=sprintf("<name>%s</name>",$name);
            $rowXML[]="</group>";
        }

        $rowXML[]="</recipients>";
        $ret=implode("",$rowXML);
        return $ret;
    }