public function findById($id)
{
$app = \App::getInstance();
$conn = $app->DB_CONNECT;
$doc = NULL;
$params = [];
$qb = new \Archive\Port\Adaptor\Persistence\QueryBuilder($params);
$query = $qb->select()->c("*")->from()->t("resources")->where()->c("id")->eq()->val($id)->fi();
$sth = $conn->prepare($query);
$sth->execute($params);
while ($row = $sth->fetch()) {
$doc = new \Archive\Port\Adaptor\Data\Archive\Documents\Document();
$doc->fromXmlStr($row["xmlview"]);
}
return $doc;
}
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;
}