public function execute($id) { $app = \App::getInstance(); $events = new \Archive\Port\Adaptor\Data\Archive\Events(); $conn = $app->DB_CONNECT; $params = array(); $params[":id"] = $id; $ref = new \Archive\Port\Adaptor\Data\Archive\Refs\Ref(); $ref->setRel("destination"); $ref->setHref($id); $events->setRef($ref); $query = "SELECT `r`.`xmlview` AS `rxmlview`,`l`.`xmlview` AS `lxmlview` FROM `links` AS `l` \n\t\t LEFT JOIN `resources` AS `r` ON `l`.`source`=`r`.`id`\n\t\t WHERE `l`.`destination`=:id AND `r`.`type`='event'\n\t\t ORDER BY `l`.`autoid`;"; $sth = $conn->prepare($query); $sth->execute($params); while ($row = $sth->fetch()) { $event = new \Archive\Port\Adaptor\Data\Archive\Events\Event(); $event->fromXmlStr($row["rxmlview"]); $link = new \Archive\Port\Adaptor\Data\Archive\Links\Link(); $link->fromXmlStr($row["lxmlview"]); $event->setLink($link); $events->setEvent($event); } return $events; }