public function findById($id)
{
$app = \App::getInstance();
$conn = $app->DB_CONNECT;
$link = NULL;
$query = "SELECT * FROM `links` WHERE id=?;";
$sth = $conn->prepare($query);
$sth->execute(array($id));
while ($row = $sth->fetch()) {
$link = new \Archive\Port\Adaptor\Data\Archive\Links\Link();
$link->fromXmlStr($row["xmlview"]);
}
return $link;
}
public function execute()
{
$app = \App::getInstance();
$conn = $app->DB_CONNECT;
$links = new \Archive\Port\Adaptor\Data\School\Archive();
$params = array();
$qb = new \Archive\Port\Adaptor\Persistence\QueryBuilder($params);
//print( \PDO::PARAM_INT );exit;
$query = $qb->select()->c("*")->from()->t("links", "d")->where()->c("type")->eq()->val(isset($app->QUERY["type"]) ? $app->QUERY["type"] : null, $qb::NOT_NULL)->andTrue()->c("source")->eq()->val(isset($app->QUERY["source"]) ? $app->QUERY["source"] : null, $qb::NOT_NULL)->andTrue()->c("destination")->eq()->val(isset($app->QUERY["destination"]) ? $app->QUERY["destination"] : null, $qb::NOT_NULL)->limit(isset($app->QUERY["start"]) ? (int) $app->QUERY["start"] : 0, isset($app->QUERY["count"]) ? (int) $app->QUERY["count"] : 100)->fi();
//error_log($query);
$sth = $conn->prepare($query);
$sth->execute($params);
while ($row = $sth->fetch()) {
$link = new \Archive\Port\Adaptor\Data\Archive\Links\Link();
$link->fromXmlStr($row["xmlview"]);
$links->setLink($link);
}
return $links;
}
public function execute()
{
$app = \App::getInstance();
$persons = new \Archive\Port\Adaptor\Data\Archive\Persons();
$conn = $app->DB_CONNECT;
$params = array();
$start = isset($app->QUERY['start']) ? intval($app->QUERY['start']) : 0;
$count = isset($app->QUERY['count']) ? intval($app->QUERY['count']) : (isset($app->QUERY['search']) ? 100 : 100);
$where = "";
if (isset($app->QUERY['fn']) && $app->QUERY['fn'] != "") {
$where = " AND `pk`.`fullName` LIKE :fn";
$params[":fn"] = "%" . trim($app->QUERY['fn']) . "%";
$ref = new \Archive\Port\Adaptor\Data\Archive\Refs\Ref();
$ref->setRel("fn");
$ref->setHref(trim($app->QUERY['fn']));
$persons->setRef($ref);
}
if (isset($app->QUERY['in']) && $app->QUERY['in'] != "") {
$where .= " AND ((`l`.`dt_start` <= :start AND `l`.`dt_start` IS NOT NULL) AND (`l`.`dt_end` >= :end AND `l`.`dt_end` IS NOT NULL))";
$params[":start"] = trim($app->QUERY['in']);
$params[":end"] = trim($app->QUERY['in']);
$ref = new \Archive\Port\Adaptor\Data\Archive\Refs\Ref();
$ref->setRel("in");
$ref->setHref(trim($app->QUERY['in']));
$persons->setRef($ref);
}
$query = "SELECT `r`.`xmlview`, `l`.`xmlview` AS `lxmlview` FROM `resources` AS `r` \n\t\t LEFT JOIN `persons_keys` AS `pk` ON `pk`.`personId`=`r`.`id`\n\t\t LEFT JOIN `links` as `l` ON `r`.`id`=`l`.`source`\n\t\t WHERE `r`.`type`='person' {$where}\n\t\t ORDER BY `pk`.`lastName`,`pk`.`dob` LIMIT {$start},{$count};";
$sth = $conn->prepare($query);
$sth->execute($params);
while ($row = $sth->fetch()) {
$person = new \Archive\Port\Adaptor\Data\Archive\Persons\Person();
$person->fromXmlStr($row["xmlview"]);
$link = new \Archive\Port\Adaptor\Data\Archive\Links\Link();
$link->fromXmlStr($row["lxmlview"]);
$person->setLink($link);
$persons->setPerson($person);
}
$persons->setPI(str_replace($app->API_VERSION . $app->PATH_INFO, "", $_SERVER["SCRIPT_URI"]) . "/stylesheets/Archive/Persons.xsl");
return $persons;
}
public function execute($id)
{
$app = \App::getInstance();
$unions = new \Archive\Port\Adaptor\Data\Archive\Unions();
$conn = $app->DB_CONNECT;
$params = array();
$params[":id"] = $id;
$ref = new \Archive\Port\Adaptor\Data\Archive\Refs\Ref();
$ref->setRel("destination");
$ref->setHref($id);
$unions->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`='union'\n\t\t ORDER BY `l`.`autoid`;";
$sth = $conn->prepare($query);
$sth->execute($params);
while ($row = $sth->fetch()) {
$union = new \Archive\Port\Adaptor\Data\Archive\Unions\Union();
$union->fromXmlStr($row["rxmlview"]);
$link = new \Archive\Port\Adaptor\Data\Archive\Links\Link();
$link->fromXmlStr($row["lxmlview"]);
$union->setLink($link);
$unions->setUnion($union);
}
return $unions;
}
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;
}
