NatLibFi / Skosmos

     * @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) {

        $gcl = $this->graphClause;

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

        $query = <<<EOQ

SELECT *

WHERE {

  $gcl {

    <$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.

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

     * @return string sparql query

     */

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

        $gcl = $this->graphClause;

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

        $query = <<<EOQ

SELECT DISTINCT ?concept ?date ?label

WHERE {

  $gcl {

    ?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.