NatLibFi / Skosmos

     * @param int $offset offset of results to retrieve; 0 for beginning of list

     * @return string sparql query

     */

    private function generateChangeListQuery($lang, $offset, $prop) {

        $fcl = $this->generateFromClause();

        $offset = ($offset) ? 'OFFSET ' . $offset : '';

        $query = <<<EOQ

SELECT DISTINCT ?concept ?date ?label $fcl

WHERE {

  ?concept a skos:Concept .

  ?concept $prop ?date .

  ?concept skos:prefLabel ?label .

  FILTER (langMatches(lang(?label), '$lang'))

}

ORDER BY DESC(YEAR(?date)) DESC(MONTH(?date)) LCASE(?label)

LIMIT 200 $offset

EOQ;

        return $query;

    }

    /**

     * Transforms the sparql query result into an array.

     * @param boolean $anylang if you want a label even when it isn't available in the language you requested.

     * @return string sparql query

     */

    private function generatePropertyQuery($uri, $prop, $lang, $anylang) {

        $fcl = $this->generateFromClause();

        $anylang = $anylang ? "OPTIONAL { ?object skos:prefLabel ?label }" : "";

        $query = <<<EOQ

SELECT * $fcl

WHERE {

  <$uri> a skos:Concept .

  OPTIONAL {

    <$uri> $prop ?object .

    OPTIONAL {

      ?object skos:prefLabel ?label .

      FILTER (langMatches(lang(?label), "$lang"))

    }

    OPTIONAL {

      ?object skos:prefLabel ?label .

      FILTER (lang(?label) = "")

    }

    $anylang

  }

}

EOQ;

        return $query;

    }

    /**

     * Transforms the sparql query result into an array or null if the concept doesn't exist.