server/src/app/Repositories/RdfDocumentRepository.php
changeset 445 b1e5ad6b2a29
parent 405 f239c8c5bb94
child 489 18613f052d56
equal deleted inserted replaced
444:63e798616b6a 445:b1e5ad6b2a29
    31         = "SELECT".
    31         = "SELECT".
    32         "    ?uri".
    32         "    ?uri".
    33         "    ?doc".
    33         "    ?doc".
    34         "    ?title".
    34         "    ?title".
    35         "    ?issued".
    35         "    ?issued".
       
    36         "    ?created".
    36         "    ?modified".
    37         "    ?modified".
    37         "    (group_concat(distinct ?language;separator=\", \") as ?lang) ".
    38         "    (group_concat(distinct ?language;separator=\", \") as ?lang) ".
    38         "    (group_concat(distinct ?publisher;separator=\", \") as ?publishers) ".
    39         "    (group_concat(distinct ?publisher;separator=\", \") as ?publishers) ".
    39         "  WHERE {".
    40         "  WHERE {".
    40         "    GRAPH ?uri { ?doc a <http://www.europeana.eu/schemas/edm/ProvidedCHO>.".
    41         "    GRAPH ?uri { ?doc a <http://www.europeana.eu/schemas/edm/ProvidedCHO>.".
    41         "      ?doc <http://purl.org/dc/elements/1.1/title> ?title.".
    42         "      ?doc <http://purl.org/dc/elements/1.1/title> ?title.".
    42         "      OPTIONAL {?doc <http://purl.org/dc/elements/1.1/language> ?language.} ".
    43         "      OPTIONAL {?doc <http://purl.org/dc/elements/1.1/language> ?language.} ".
    43         "      OPTIONAL {?doc <http://purl.org/dc/terms/issued> ?issued.} ".
    44         "      OPTIONAL {?doc <http://purl.org/dc/terms/issued> ?issued.} ".
       
    45         "      OPTIONAL {?doc <http://purl.org/dc/terms/created> ?created.} ".
    44         "      OPTIONAL {?doc <http://purl.org/dc/terms/modified> ?modified.} ".
    46         "      OPTIONAL {?doc <http://purl.org/dc/terms/modified> ?modified.} ".
    45         "      OPTIONAL {?doc <http://purl.org/dc/elements/1.1/publisher> ?publisher.}".
    47         "      OPTIONAL {?doc <http://purl.org/dc/elements/1.1/publisher> ?publisher.}".
    46         "    }. ".
    48         "    }. ".
    47         "    %s".
    49         "    %s".
    48         "  } ".
    50         "  } ".
    49         "  GROUP BY ?uri ?doc ?title ?issued ?modified ";
    51         "  GROUP BY ?uri ?doc ?title ?issued ?created ?modified ";
    50 
    52 
    51     const ADDITIONAL_DOC_QUERIES = [
    53     const ADDITIONAL_DOC_QUERIES = [
    52         "SELECT".
    54         "SELECT".
    53         "    ?uri".
    55         "    ?uri".
    54         "    ?doc".
    56         "    ?doc".