public function execute($id) { $app = \App::getInstance(); $docs = new \Archive\Port\Adaptor\Data\Archive\Documents(); $conn = $app->DB_CONNECT; $params = array(); $params[":id"] = $id; $ref = new \Archive\Port\Adaptor\Data\Archive\Refs\Ref(); $ref->setRel("source"); $ref->setHref($id); $docs->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`.`destination`=`r`.`id`\n\t\t LEFT JOIN `documents_keys` AS `dk` ON `l`.`destination`=`dk`.`documentId`\n\t\t WHERE `l`.`source`=:id AND `r`.`type`='document'\n\t\t ORDER BY `dk`.`year`;"; $sth = $conn->prepare($query); $sth->execute($params); while ($row = $sth->fetch()) { $doc = new \Archive\Port\Adaptor\Data\Archive\Documents\Document(); $doc->fromXmlStr($row["rxmlview"]); $link = new \Archive\Port\Adaptor\Data\Archive\Links\Link(); $link->fromXmlStr($row["lxmlview"]); $doc->setLink($link); $docs->setDocument($doc); } return $docs; }