src/Controller/SiteController.php line 329

Open in your IDE?
  1. <?php
  2. // src/Controller/SiteController.php
  3. namespace App\Controller;
  5. use Symfony\Component\Routing\Annotation\Route;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\HttpFoundation\Request;
  9. class SiteController  extends DMAbstractController
  10. {
  11.     function jocondeSiteDescription($desc, $jsonld, $debug=false)
  12.     {
  13.         $lang = "fr";
  14.         $jsonDescription = json_decode($jsonld, TRUE);
  15.         $descstruct["uri"] = $desc["uri"];
  16.         $descstruct["jsonld"] = "";
  17.         $descstruct["entityid"]  = "????";
  18.         $descstruct["altLabel"]  = array();
  19.         $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  20.         $descstruct["dataset"] = "SemJoconde";
  21.         $descstruct["uriville"]  = "";
  22.         $descstruct["ville"] = "?";
  23.         $descstruct["latitude"] = "?";
  24.         $descstruct["longitude"] = "?";
  25.         $descstruct["sameAs"] = array();
  26.         $descstruct["query"] = "";
  28.         if  ($jsonDescription){
  29.             $descstruct = array();
  30.             // types devraient être ajoutés au json-ld comme attribut @type
  31.             $descstruct["@type"] = array();
  32.             if (array_key_exists("P31", $jsonDescription)) {
  33.                 if (is_array($jsonDescription["P31"])) {
  34.                     foreach ($jsonDescription["P31"] as $isA) {
  35.                         array_push($descstruct["@type"], $isA);
  36.                     }
  37.                 } else array_push($descstruct["@type"], $jsonDescription["P31"]);
  38.             }
  39.             $descstruct["jsonld"] = $jsonld; //str_replace("&quot;", '"', $jsonld);
  40.             if (array_key_exists("@id", $jsonDescription)){
  41.                 $descstruct["uri"] = $jsonDescription["@id"];
  42.             }else {
  43.                 $descstruct["uri"] = "";
  44.             }
  45.             $descstruct["entityid"]  = "????";
  47.             if (array_key_exists("prefLabel", $jsonDescription)){
  48.                 if(is_object($jsonDescription["prefLabel"])) {
  49.                     foreach ($jsonDescription["prefLabel"] as $pLabel) {
  50.                         $newlabel = "";
  51.                         if (array_key_exists("@language", $pLabel)) {
  52.                             if ($pLabel["@language"] == $lang) {
  53.                                 $newlabel = $pLabel["@value"];
  54.                                 break;
  55.                             }
  56.                         }
  57.                     }
  58.                 }
  59.                 else {
  60.                     // Checking if $jsonDescription["prefLabel"] is sequentialor asociative array
  61.                     $arr = $jsonDescription["prefLabel"];
  62.                     if (array_keys($arr) !== range(0, count($arr) - 1)) {
  63.                         // associative array
  64.                         $newlabel = "";
  65.                         if (array_key_exists("@language", $jsonDescription["prefLabel"])) {
  66.                             $newlabel = "titi";
  67.                             if ($jsonDescription["prefLabel"]["@language"] == $lang) {
  68.                                 $newlabel = $jsonDescription["prefLabel"]["@value"];
  69.                             }
  70.                         }
  71.                     } else {
  72.                         // sequential array
  73.                         foreach ($jsonDescription["prefLabel"] as $pLabel) {
  74.                             $newlabel = "";
  75.                             if (array_key_exists("@language", $pLabel)) {
  76.                                 if ($pLabel["@language"] == $lang) {
  77.                                     $newlabel = $pLabel["@value"];
  78.                                     break;
  79.                                 }
  80.                             }
  81.                         }
  82.                     }
  83.                 }
  84.             } else {
  85.                 @$newlabel = "";
  86.             }
  87.             if ($newlabel!="") {
  88.                 $descstruct["entityid"]  = $newlabel;
  89.             }
  91.             $descstruct["altLabel"]  = array();
  92.             if (array_key_exists("label", $jsonDescription)) {
  93.                 foreach ($jsonDescription["label"] as $label) {
  94.                     $newlabel = "";
  95.                     if (is_array($label)) {
  96.                         if ($label["@language"] == $lang) {
  97.                             $newlabel = $label["@value"];
  98.                         }
  99.                     } else $newlabel = $label;
  100.                     if (($newlabel != "") and (!in_array($newlabel, $descstruct["altLabel"]))) {
  101.                         array_push($descstruct["altLabel"], $newlabel);
  102.                     }
  103.                 }
  104.             }
  105.             $descstruct["dataset"] = "SemJoconde";
  106.             $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  108.             $descstruct["uriville"]  = "";
  109.             if (array_key_exists("city", $jsonDescription)) {
  110.                 if (is_array($jsonDescription["city"])) $descstruct["ville"] = $jsonDescription["city"]["@value"];
  111.                 else $descstruct["ville"] = $jsonDescription["city"];
  112.             } else {
  113.                 $descstruct["ville"] = "";
  114.             }
  115.             if(array_key_exists("http://www.w3.org/2003/01/geo/wgs84_pos#lat", $jsonDescription)) {
  116.                 $lat =  $jsonDescription["http://www.w3.org/2003/01/geo/wgs84_pos#lat"];
  117.                 echo($lat[0]);
  118.                 if (is_array($lat)) $descstruct["latitude"] = "!"; //$lat[0];
  119.                 else $descstruct["latitude"] = "!!";//$lat;
  120.             } else $descstruct["latitude"] = "?";
  121.             if(array_key_exists("http://www.w3.org/2003/01/geo/wgs84_pos#long", $jsonDescription)) {
  122.                 $lon =  $jsonDescription["http://www.w3.org/2003/01/geo/wgs84_pos#long"];
  123.                 if (is_array($lon)) $descstruct["longitude"] = "&";//$lon[0];
  124.                 else $descstruct["longitude"] = "&&";//$lon;
  125.             } else $descstruct["longitude"] = "?";
  126.             $descstruct["sameAs"] = array();
  127.             if(array_key_exists("sameAs", $jsonDescription)) {
  128.                 if (is_array($jsonDescription["sameAs"])) {
  129.                     foreach ($jsonDescription["sameAs"] as $same) {
  130.                         array_push($descstruct["sameAs"], $same);
  131.                     }
  132.                 } else array_push($descstruct["sameAs"], $jsonDescription["sameAs"]);
  133.             }
  134.         }
  135.         $descstruct["countcontrib"] = 0;
  136.         $descstruct["countuser"] =  0;
  137.         $descstruct["countcontrib"] = 0;
  138.         $descstruct["entitytype"] = "Site culturel";
  139.         if ($jsonDescription) {
  140.             if (array_key_exists("@id", $jsonDescription)) {
  141.                 $count = self::getGuestBookContribCount("https://kg.grains-de-culture.fr/dm/sparql", $jsonDescription["@id"]);
  142.                 $descstruct["countcontrib"] = $count["countcontrib"];
  143.                 $descstruct["countuser"] = $count["countuser"];
  144.                 $descstruct["countcontrib"] = $count["countcontrib"];
  145.             }
  146.             /*
  147.              *
  148.              $sellcount = self::getSellActionCount("https://kg.grains-de-culture.fr/dm/query",
  149.                                         str_replace("http://datamusee.givingsense.eu/onto/site/",
  150.                                             "http://datamusee.givingsense.eu/graph/billetterie/site/",
  151.                                             $jsonDescription["@id"]));
  152.             $descstruct["salescount"] =  $sellcount["salescount"];
  153.             $descstruct["productscount"] =  $sellcount["productscount"];
  154.             $descstruct["buyerscount"] =  $sellcount["buyerscount"];
  155.             */
  157.             if (array_key_exists("@id", $jsonDescription)) {
  158.                 $descstruct["class"] = $this->getClasses($jsonDescription["@id"], $desc["endpoint"]);
  159.             } else {
  160.                 $descstruct["class"] = array();
  161.             }
  162.             $descstruct["urljson"] = $descstruct["uri"] . ".json";
  163.             $yasguilink = "";
  164.             if (array_key_exists("@id", $jsonDescription)) {
  165.                 $yasguilink = "https://grains-de-culture.fr/fuseki/ui/#"
  166.                     . 'query=' . urlencode(
  167.                         str_replace("construct { ?s ?p ?o ; a ?t}", "select ?s ?p ?o", self::getElementaryQuery($jsonDescription["@id"])))
  168.                     . '&contentTypeConstruct=' . urlencode("text/turtle")
  169.                     . '&contentTypeSelect=' . urlencode("application/sparql-results+json")
  170.                     . '&endpoint=' . urlencode($desc["endpoint"])
  171.                     . '&requestMethod=POST'
  172.                     . '&tabTitle=' . urlencode("Propriétés")
  173.                     . '&headers=%7B%7D'
  174.                     . '&outputFormat=table';
  175.             }
  176.             $descstruct["yasguilink"] = $yasguilink;
  177.             $descstruct["entitytype"] = "Site culturel";
  178.             $template = 'site/dmjocsite.html.twig';
  179.         }
  180.         if ($debug) $template = "testTemplateSite.html.twig";
  181.         $response = $this->render($template, [
  182.             //return $this->render('testTemplateSite.html.twig', [
  183.             'desc' => $desc,
  184.             'descstruct' => $descstruct,
  185.             'entitytype' => $descstruct["entitytype"],
  186.             'description' => ""//$description
  187.         ]);
  188.         return  $response;
  189.     }
  191.     function newSiteDescription($desc, $jsonld, $debug=false)
  192.     {
  193.         $lang = "fr";
  194.         $jsonDescription = json_decode($jsonld, TRUE);
  195.         $descstruct["uri"] = $desc["uri"];
  196.         $descstruct["uri"] = $desc["uri"];
  197.         $descstruct["jsonld"] = $jsonld;
  198.         $descstruct["entityid"]  = "????";
  199.         $descstruct["altLabel"]  = array();
  200.         $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  201.         $descstruct["dataset"] = "SemJoconde";
  202.         $descstruct["uriville"]  = "";
  203.         $descstruct["ville"] = "?";
  204.         $descstruct["latitude"] = "?";
  205.         $descstruct["longitude"] = "?";
  206.         $descstruct["sameAs"] = array();
  207.         $descstruct["query"] = "";
  209.         if  ($jsonDescription){
  210.             $descstruct = array();
  211.             $descstruct["query"] = $desc["query"];
  212.             // types devraient être ajoutés au json-ld comme attribut @type
  213.             $descstruct["@type"] = array();
  214.             if (array_key_exists("P31", $jsonDescription)) {
  215.                 if (is_array($jsonDescription["P31"])) {
  216.                     foreach ($jsonDescription["P31"] as $isA) {
  217.                         array_push($descstruct["@type"], $isA);
  218.                     }
  219.                 } else array_push($descstruct["@type"], $jsonDescription["P31"]);
  220.             }
  221.             $descstruct["jsonld"] = $jsonld; //str_replace("&quot;", '"', $jsonld);
  222.             if (array_key_exists("@id", $jsonDescription)){
  223.                 $descstruct["uri"] = $jsonDescription["@id"];
  224.             } else {
  225.                 $descstruct["uri"] = "";
  226.             }
  227.             $descstruct["entityid"]  = "??????";
  229.             if (array_key_exists("skos:prefLabel", $jsonDescription)){
  230.                 // $descstruct["entityid"]  = "!!!!!!";
  231.                 if(is_object($jsonDescription["skos:prefLabel"])) {
  232.                     // $descstruct["entityid"]  = "!?!?!?";
  233.                     foreach ($jsonDescription["skos:prefLabel"] as $pLabel) {
  234.                         $newlabel = "";
  235.                         if (array_key_exists("@language", $pLabel)) {
  236.                             if ($pLabel["@language"] == $lang) {
  237.                                 $newlabel = $pLabel["@value"];
  238.                                 break;
  239.                             }
  240.                         }
  241.                     }
  242.                 }
  243.                 else {
  244.                     //$descstruct["entityid"]  = ";;;;;";
  245.                     // Checking if $jsonDescription["prefLabel"] is sequentialor asociative array
  246.                     $arr = $jsonDescription["skos:prefLabel"];
  247.                     if (array_keys($arr) !== range(0, count($arr) - 1)) {
  248.                         //$descstruct["entityid"]  = "$$$$$$";
  249.                         // associative array
  250.                         $newlabel = "";
  251.                         if (array_key_exists("@language", $jsonDescription["skos:prefLabel"])) {
  252.                             $newlabel = "titi";
  253.                             if ($jsonDescription["skos:prefLabel"]["@language"] == $lang) {
  254.                                 $newlabel = $jsonDescription["skos:prefLabel"]["@value"];
  255.                             }
  256.                         }
  257.                     } else {
  258.                         //$descstruct["entityid"]  = "******";
  259.                         // sequential array
  260.                         foreach ($jsonDescription["skos:prefLabel"] as $pLabel) {
  261.                             $newlabel = "";
  262.                             if (is_array($pLabel)) {
  263.                                 if (array_key_exists("@language", $pLabel)) {
  264.                                     if ($pLabel["@language"] == $lang) {
  265.                                         $newlabel = $pLabel["@value"];
  266.                                         break;
  267.                                     }
  268.                                 }
  269.                             } else {
  270.                                 $descstruct["entityid"]  = $pLabel;
  271.                                 $newlabel = $pLabel;
  272.                             }
  273.                         }
  274.                     }
  275.                 }
  276.             } else {
  277.                 @$newlabel = "";
  278.             }
  279.             if ($newlabel!="") {
  280.                 $descstruct["entityid"]  = $newlabel;
  281.             }
  283.             $descstruct["altLabel"]  = array();
  284.             if (array_key_exists("rdfs:label", $jsonDescription)) {
  285.                 foreach ($jsonDescription["rdfs:label"] as $label) {
  286.                     $newlabel = "";
  287.                     if (is_array($label)) {
  288.                         if ($label["@language"] == $lang) {
  289.                             $newlabel = $label["@value"];
  290.                         }
  291.                     } else $newlabel = $label;
  292.                     if (($newlabel != "") and (!in_array($newlabel, $descstruct["altLabel"]))) {
  293.                         array_push($descstruct["altLabel"], $newlabel);
  294.                     }
  295.                 }
  296.             }
  297.             $descstruct["dataset"] = "dmsites";
  298.             $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  300.             $descstruct["uriville"]  = "_";
  301.             if (array_key_exists("city", $jsonDescription)) {
  302.                 if (is_array($jsonDescription["city"])) $descstruct["ville"] = $jsonDescription["city"]["@value"];
  303.                 else $descstruct["ville"] = $jsonDescription["city"];
  304.             } else {
  305.                 $descstruct["ville"] = "?";
  306.             }
  307.             if(array_key_exists("http://www.w3.org/2003/01/geo/wgs84_pos#lat", $jsonDescription)) {
  308.                 $lat =  $jsonDescription["http://www.w3.org/2003/01/geo/wgs84_pos#lat"];
  309.                 if (is_array($lat)) $descstruct["latitude"] = floatval($lat["@value"]);
  310.                 else $descstruct["latitude"] = floatval($lat["@value"]);
  311.             } else $descstruct["latitude"] = "?";
  312.             if(array_key_exists("http://www.w3.org/2003/01/geo/wgs84_pos#long", $jsonDescription)) {
  313.                 $lon =  $jsonDescription["http://www.w3.org/2003/01/geo/wgs84_pos#long"];
  314.                 if (is_array($lon)) $descstruct["longitude"] = floatval($lon["@value"]);
  315.                 else $descstruct["longitude"] = floatval($lon["@value"]);
  316.             } else $descstruct["longitude"] = "?";
  317.             $descstruct["sameAs"] = array();
  318.             if(array_key_exists("sameAs", $jsonDescription)) {
  319.                 if (is_array($jsonDescription["sameAs"])) {
  320.                     foreach ($jsonDescription["sameAs"] as $same) {
  321.                         array_push($descstruct["sameAs"], $same);
  322.                     }
  323.                 } else array_push($descstruct["sameAs"], $jsonDescription["sameAs"]);
  324.             }
  325.         }
  326.         $descstruct["countcontrib"] = 0;
  327.         $descstruct["countuser"] =  0;
  328.         $descstruct["countcontrib"] = 0;
  329.         if(array_key_exists("@id", $jsonDescription)) {
  330.             $count = self::getGuestBookContribCount("https://kg.grains-de-culture.fr/dm/sparql", $jsonDescription["@id"]);
  331.             $descstruct["countcontrib"] = $count["countcontrib"];
  332.             $descstruct["countuser"] =  $count["countuser"];
  333.             $descstruct["countcontrib"] = $count["countcontrib"];
  334.         }
  336.         /*
  337.          *
  338.          $sellcount = self::getSellActionCount("https://kg.grains-de-culture.fr/dm/query",
  339.                                     str_replace("http://datamusee.givingsense.eu/onto/site/",
  340.                                         "http://datamusee.givingsense.eu/graph/billetterie/site/",
  341.                                         $jsonDescription["@id"]));
  342.         $descstruct["salescount"] =  $sellcount["salescount"];
  343.         $descstruct["productscount"] =  $sellcount["productscount"];
  344.         $descstruct["buyerscount"] =  $sellcount["buyerscount"];
  345.         */
  347.         if(array_key_exists("@id", $jsonDescription)) {
  348.             $descstruct["class"] = $this->getClasses($jsonDescription["@id"], $desc["endpoint"]);
  349.         } else {
  350.             $descstruct["class"] = array();
  351.         }
  352.         $descstruct["urljson"] = $descstruct["uri"].".json";
  353.         $yasguilink = "";
  354.         if(array_key_exists("@id", $jsonDescription)) {
  355.             $yasguilink = "https://grains-de-culture.fr/fuseki/ui/#"
  356.                 . 'query=' . urlencode(
  357.                     str_replace("construct { ?s ?p ?o ; a ?t}", "select ?s ?p ?o", self::getElementaryQuery($jsonDescription["@id"])))
  358.                 . '&contentTypeConstruct=' . urlencode("text/turtle")
  359.                 . '&contentTypeSelect=' . urlencode("application/sparql-results+json")
  360.                 . '&endpoint=' . urlencode($desc["endpoint"])
  361.                 . '&requestMethod=POST'
  362.                 . '&tabTitle=' . urlencode("Propriétés")
  363.                 . '&headers=%7B%7D'
  364.                 . '&outputFormat=table';
  365.         }
  366.         $descstruct["yasguilink"] = $yasguilink;
  367.         $descstruct["entitytype"] = "Site culturel";
  368.         $template = 'site/dmsite.html.twig';
  369.         if ($debug) $template = "testTemplateSite.html.twig";
  370.         $response = $this->render($template, [
  371.             //return $this->render('testTemplateSite.html.twig', [
  372.             'desc' => $desc,
  373.             'descstruct' => $descstruct,
  374.             'entitytype' => $descstruct["entitytype"],
  375.             'description' => ""//$description
  376.         ]);
  377.         return  $response;
  378.     }
  380.     function getPrefixes()
  381.     {
  382.         $prefixes = <<<txt
  383. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
  384. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  385. PREFIX wdt: <http://www.wikidata.org/prop/direct/>
  386. PREFIX owl: <http://www.w3.org/2002/07/owl#>
  387. prefix cmn: <http://givingsense.eu/datamusee/onto/musee/cmn/>
  388. txt;
  389.         return $prefixes;
  390.     }
  392.     function getClasses($uriclass, $endpoint)
  393.     {
  394.         $user = $this->getParameter('app.sparql_user');
  395.         $pass = $this->getParameter('app.sparql_pass');
  396.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  397.         $classTemplate = self::getPrefixes() . <<<txt
  398. SELECT distinct ?o ?label ?super ?superlabel 
  399. WHERE { 
  400.   <__uri__> wdt:P31 ?o .
  401.       ?o  <http://www.wikidata.org/prop/direct/P279>* ?super.
  402.   ?o rdfs:label ?label .
  403.   ?super rdfs:label ?superlabel .
  404.   bind(lang(?superlabel) as ?lang)
  405.   filter((lang(?superlabel)='en') ||(lang(?superlabel)='en') ) 
  406.      }
  407.   
  408. txt;
  409.         $queryClasses =  str_replace( "__uri__" , $uriclass , $classTemplate);
  410.         $requestURL = $endpoint.'?'
  411.             .'query='.urlencode($queryClasses)
  412.             .'&format=json';
  413.         $classes = json_decode(self::request($requestURL, $auth), true);
  414.         $classArray = array();
  415.         foreach ($classes["results"]["bindings"] as $item) {
  416.             $lang = "";
  417.             if(array_key_exists("xml:lang", $item["label"]))
  418.                 $lang = $item["label"]["xml:lang"];
  419.             if ($lang=="en") $classArray[$item["o"]["value"]] = [ "class"=> $item["o"]["value"], "label" =>$item["label"]["value"], "lang"=>$lang];
  420.             if(array_key_exists("super", $item)){
  421.                 if(array_key_exists("xml:lang", $item["superlabel"])) $lang = $item["superlabel"]["xml:lang"]; else $lang = "";
  422.                 if ($lang=="en")
  423.                     $classArray[$item["super"]["value"]] = [ "class"=> $item["super"]["value"], "label" =>$item["superlabel"]["value"], "lang"=>$lang];
  424.             }
  425.         }
  426.         return $classArray;
  427.         //return array($queryClasses);
  428.     }
  430.     function getGuestBookContribCount($endpoint, $urisite)
  431.     {
  432.         $sparqltemplate = <<<txt
  433. PREFIX schema: <http://schema.org/>
  434. select (count(distinct ?s) as ?cl)(count(distinct ?user) as ?cu) 
  435. where
  436. {
  437.   values ?graph { <http://datamusee.givingsense.eu/livredor/parismusees> <http://datamusee.givingsense.eu/livredor/cmn> }
  438.     graph ?graph {
  439.     ?app schema:about <__uri__> .
  440.     ?s a <http://datamusee.givingsense.eu/onto/contribution>; 
  441.        <http://datamusee.givingsense.eu/onto/contribution/hasUser> ?user;
  442.        <http://datamusee.givingsense.eu/onto/contribution/hasAppli> ?app . 
  443.   }
  444. } 
  445. txt;
  446.         $format = "application/sparql-results+json";
  447.         $query =  str_replace( "__uri__" , $urisite , $sparqltemplate);
  448.         $user = $this->getParameter('app.sparql_user');
  449.         $pass = $this->getParameter('app.sparql_pass');
  450.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  451.        $requestURL = $endpoint.'?'
  452.             .'query='.urlencode($query)
  453.             .'&format='.urlencode($format);
  454.         $res = json_decode(self::request($requestURL, $auth), true);
  455.         $count = array(); $count["countcontrib"] = $count["countuser"] = 0;
  456.         if ($res) {
  457.             $count["countcontrib"]  = $res["results"]["bindings"][0]["cl"]["value"];
  458.             $count["countuser"] = $res["results"]["bindings"][0]["cu"]["value"];
  459.         }
  460.         //return $query;
  461.         return $count;
  462.     }
  464.     function getSellActionCount($endpoint, $graph)
  465.     {
  466.         $sparqltemplate = <<<txt
  467. PREFIX schema: <http://schema.org/>
  468. select (count(distinct ?s) as ?sellactioncount) (count(distinct ?buyer) as ?buyerscount) (count(distinct ?product) as ?productscount) 
  469. {
  470.   graph <__uri__> {
  471.     ?s a schema:SellAction ;
  472.     schema:buyer ?buyer ;
  473.     <http://datamusee.givingsense.eu/onto/product/hasProduct> ?product
  474.   }
  475. }
  476. txt;
  478.         $format = "application/sparql-results+json";
  479.         $query =  str_replace( "__uri__" , $graph , $sparqltemplate);
  480.         $user = $this->getParameter('app.sparql_user');
  481.         $pass = $this->getParameter('app.sparql_pass');
  482.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  483.         $requestURL = $endpoint.'?'
  484.             .'query='.urlencode($query)
  485.             .'&format='.urlencode($format);
  486.         $res = json_decode(self::request($requestURL, $auth), true);
  487.         $count = array(); $count["countcontrib"] = $count["countuser"] = 0;
  488.         if ($res) {
  489.             $count["salescount"]  = $res["results"]["bindings"][0]["sellactioncount"]["value"];
  490.             $count["buyerscount"] = $res["results"]["bindings"][0]["buyerscount"]["value"];
  491.             $count["productscount"] = $res["results"]["bindings"][0]["productscount"]["value"];
  492.         }
  493.         return $count;
  494.     }
  496.     /**
  497.     @Route("/onto/sites/debug", name="sitesd")
  498.      */
  499.     public function ontoListeSitesDebug()
  500.     {
  501.         $desc = array();
  502.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  503.         $desc["dataset"] = "dmsites";
  504.         $desc["graph"] = "";
  505.         $desc["dmticketinggraph"] = "https://kg.grains-de-culture.fr/dmmeta/sparql";
  506.         $desc["comment"] = "Sites du CMN et de Paris Musées";
  507.         $desc["uri"] = "http://datamusee.givingsense.efu/onto/sites";
  508.         $uri = $desc["uri"];
  509.         $sparqltemplate = <<<txt
  510. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
  511. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  512. SELECT distinct ?s ?label
  513. WHERE 
  514. { 
  515.     values ?g { <http://datamusee.givingsense.eu/graph/sites/cmn> <http://datamusee.givingsense.eu/graph/sites/parismusees>}
  516.     graph ?g {
  517.     ?s  skos:prefLabel ?label .
  518.     FILTER(LANG(?label) = "" || LANGMATCHES(LANG(?label), "fr"))
  519.     filter(contains(str(?s),"http://datamusee.givingsense.eu/onto/site/"))
  520.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P31> ?s } 
  521.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P279> ?s }
  522.     }
  523. }
  524. txt;
  526.         $query = str_replace("__uri__", $uri, $sparqltemplate);
  527.         $descstruct["query"] = $query;
  528.         $description = "";
  529.         return $this->render('testTemplateSite.html.twig', [
  530.             'desc' => $desc,
  531.             'descstruct' => $descstruct,
  532.             'description' => $description
  533.         ]);
  534.     }
  536.     /**
  537.     @Route("/onto/sites.{_format}", defaults={"_format": "html"}, name="sites")
  538.      */
  539.     public function ontoListeSites(Request $request)
  540.     {
  541.         // $lang = $request->getLocale();
  542.         $format = $this->getFormat($request);
  543.         /*
  544.         $format = $request->getRequestFormat();
  545.         $requestedContentTypes = $request->getAcceptableContentTypes();
  546.         foreach ($requestedContentTypes as $rType) {
  547.             if ($rType == 'application/json') { $format = 'json'; break; }
  548.             if ($rType == 'application/x-turtle') { $format = 'ttl'; break; }
  549.             if ($rType == 'application/rdf+xml') { $format = 'xml'; break; }
  550.         }
  551.         */
  552.         $desc = array();
  553.         $user = $this->getParameter('app.sparql_user');
  554.         $pass = $this->getParameter('app.sparql_pass');
  555.         // $auth = "student:igr2018%"; // le dataset dmsites devrait être en libre accès
  556.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  557.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  558.         $desc["dataset"] = "dmsites";
  559.         $desc["graph"] = "";
  560.         $desc["dmticketinggraph"] = "";
  561.         $desc["comment"] = "Sites du CMN et de Paris Musées";
  562.         $desc["uri"] = "http://datamusee.givingsense.eu/onto/sites";
  563.         $uri = $desc["uri"];
  564.         $sformat = "application/sparql-results+json";
  565.         $sparqltemplate = <<<txt
  566. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
  567. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  568. SELECT distinct ?s ?label
  569. WHERE 
  570. { 
  571.     values ?g { <http://datamusee.givingsense.eu/graph/sites/cmn> <http://datamusee.givingsense.eu/graph/sites/parismusees>}
  572.     graph ?g {
  573.     ?s  skos:prefLabel ?label .
  574.     FILTER(LANG(?label) = "" || LANGMATCHES(LANG(?label), "fr"))
  575.     filter(contains(str(?s),"http://datamusee.givingsense.eu/onto/site/"))
  576.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P31> ?s } 
  577.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P279> ?s }
  578.     }
  579. }
  580. txt;
  582.         $query =  str_replace( "__uri__" , $uri , $sparqltemplate);
  583.         $requestURL = $desc["endpoint"].'?'
  584.             .'query='.urlencode($query)
  585.             .'&format='.urlencode($sformat);
  586.         $sites = json_decode(self::request($requestURL, $auth), true);
  587.         $descstruct["dataset"] = "dmsites";
  588.         $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  589.         $descstruct["query"] = $query;
  590.         $descstruct["jsonarray"] = self::request($requestURL, $auth);
  591.         $descstruct["url"] = $requestURL;
  592.         $descstruct["uri"] = $uri;
  593.         $descstruct["debug"] = $query;
  594.         $descstruct["sites"] = $sites["results"]["bindings"];
  595.         $descstruct["entitytype"] = "Sites partenaire de Data&Musée";
  596.         switch($format) {
  597.             case 'json':
  598.             //case 'ttl':
  599.             case 'xml':
  600.                 $call = $desc["endpoint"].'?'
  601.                     .'query='.urlencode($query)
  602.                     .'&format='.$this->mimetype($format)
  603.                     .'&output='.$format;
  604.                 $mime = $this->mimetype($format);
  605.                 //$ch = curl_init($call);
  606.                 //curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  607.                 //curl_setopt($ch, CURLOPT_HEADER, false);
  608.                 //$result .= curl_exec($ch);
  609.                 //curl_close($ch);
  610.                 $result =self::request($call, $auth);
  611.                 $response = new Response($result,
  612.                     Response::HTTP_OK,
  613.                     array('content-type' => $mime)
  614.                 );
  615.                 break;
  616.             case 'gql':
  617.                 $gqlquery = <<<txt
  618. {sites{ 
  619.     edges {     node {id
  620.         prefLabel}}}}
  621. txt;
  622.                 $gqldesc["query"] = $gqlquery;
  623.                 $json = json_decode($this->graphqlQuery('http://dm.givingsense.eu/graphql4/graphql', $gqlquery, ""), true, 512, JSON_UNESCAPED_UNICODE);
  624.                 $descstruct["sites"] = array();
  625.                 foreach ($json["data"]["sites"]["edges"] as $edge) {
  626.                     $site = array();
  627.                     $site["s"] = array();
  628.                     $site["s"]["value"] = $edge["node"]["id"];
  629.                     $site["label"] = array();
  630.                     $site["label"]["value"] = $edge["node"]["prefLabel"];
  631.                     array_push($descstruct["sites"], $site);
  632.                 }
  633.                 $response = $this->render('site/dmsites.html.twig', [
  634.                 //$response = $this->render('testGraphQL.html.twig', [
  635.                     'desc' => $desc,
  636.                     'descstruct' => $descstruct,
  637.                     'entitytype' => $descstruct["entitytype"]
  638.                 ]);
  639.                 break;
  640.             default:
  641.                 $response = $this->render('site/dmsites.html.twig', [
  642.                     'desc' => $desc,
  643.                     'descstruct' => $descstruct,
  644.                     'entitytype' => $descstruct["entitytype"],
  645.                     'description' => $sites
  646.                 ]);
  647.                 break;
  648.         }
  649.         $response->headers->addCacheControlDirective('must-revalidate', true);
  650.         $response->setSharedMaxAge(3600);
  651.         //$response->headers->set('Content-Type', 'application/json');
  652.         return $response;
  653.     }
  655.     /**
  656.     @Route("onto/site/{id}/debug")
  657.      */
  658.     public function cmnsitenewDebug($id)
  659.     {
  660.         $desc = array();
  661.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  662.         $desc["dataset"] = "dmsites";
  663.         $desc["graph"] = "http://givingsense.eu/datamusee/onto/dmsites";
  664.         $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/".$id;
  665.         $desc["comment"] = "Site référencé par Data&Musée";
  666.         $desc["id"] = $id;
  667.         $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/".$desc["id"];
  668.         $desc["query"]= $this->getElementaryQuery($desc["uri"]);
  669.         $result = $this->getElementaryDescription($desc["endpoint"], $desc["uri"], "json");
  670.         return self::newSiteDescription($desc, $result, true);
  671.         //return self::jocondeSiteDescription($desc, $result, true);
  672.     }
  674.     public function getElementaryQuery($uri)
  675.     {
  676.         $sparqlTemplate = self::getPrefixes() . <<<txt
  677. prefix owl: <http://www.w3.org/2002/07/owl#>
  678. construct { ?s ?p ?o ; a ?t} 
  679. WHERE 
  680. { 
  681.     {
  682.         {
  683.             bind(<__uri__> as ?s) .
  684.            ?s ?p ?o .
  685.            ?s <http://www.wikidata.org/prop/direct/P31> ?t .
  686.         } UNION
  687.         {
  688.             bind(<__uri__> as ?sameas) .
  689.             ?s owl:sameAs ?sameas . 
  690.             ?s ?p ?o .
  691.             ?s <http://www.wikidata.org/prop/direct/P31> ?t .
  692.         }
  693.     }
  694. } 
  695. txt;
  697.         $query =  str_replace( "__uri__" , $uri , $sparqlTemplate);
  698.         return $query;
  699.     }
  701.     public function getElementaryDescription($endpoint, $uri, $format)
  702.     {
  703.         $user = $this->getParameter('app.sparql_user');
  704.         $pass = $this->getParameter('app.sparql_pass');
  705.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  706.         //#graph <http://datamusee.givingsense.eu/graph/sites/cmn>
  707.         $query =  $this->getElementaryQuery($uri); //str_replace( "__uri__" , $uri , $sparqlTemplate);
  708.         $call = $endpoint.'?'
  709.             .'query='.urlencode($query)
  710.             . '&format=' . $this->mimetype($format)
  711.             .'&output='.$format;
  712.         $result =self::request($call, $auth);
  713.         //$mime = $this->mimetype($format);
  714.         //$response = new Response($result,
  715.         //    Response::HTTP_OK,
  716.         //    array('content-type' => $mime)
  717.         //);
  718.         //return $response;
  719.         //echo htmlentities($query);
  720.         return $result;
  721.     }
  723.     /**
  724.     @Route("/onto/site/{id}.{_format}", defaults={"_format": "html"}, requirements={
  725.      *         "_format": "html|json|xml|ttl"
  726.      *     })
  727.      */
  728.     public function cmnsitenew(Request $request, $id)
  729.     {
  730.         $format = $this->getFormat($request);
  731.         // initialize some keys
  732.         $desc = array();
  733.         # echo intval($id);
  734.         if ((intval($id)!=0)or($id[0]=='M')or($id[0]=='P')) { // expected to be a Data&Musée site
  735.             $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  736.             $desc["ticketendpoint"] = "https://kg.grains-de-culture.fr/dm/sparql";
  737.             $desc["dataset"] = "dmsites";
  738.             $desc["graph"] = "";
  739.             $desc["ticketdataset"] = "dm";
  740.             $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/" . $id;
  741.             $desc["comment"] = "Site membre du CMN";
  742.             $desc["id"] = $id;
  743.             $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/" . $desc["id"];
  744.             $desc["query"]= $this->getElementaryQuery($desc["uri"]);
  745.             $elemDescMethod = 'getElementaryDescription';
  746.             $descMethod = 'newSiteDescription';
  747.         } else { // expected to be a SemJoconde site
  748.             $desc["endpoint"] = "https://kg.grains-de-culture.fr/SemJoconde/sparql";
  749.             $desc["ticketendpoint"] = "";
  750.             $desc["dataset"] = "SemJoconde";
  751.             $desc["graph"] = "http://joconde.givingsense.eu/graph/dmsites";
  752.             $desc["ticketdataset"] = "";
  753.             $desc["dmticketinggraph"] = "";
  754.             $desc["comment"] = "Site référencé dans la base Joconde";
  755.             $desc["id"] = $id;
  756.             $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/" . $desc["id"];
  757.             $elemDescMethod = 'getElementaryDescription';
  758.             $descMethod = 'jocondeSiteDescription';
  759.         }
  760.         switch($format) {
  761.             case 'json': case 'ttl': case 'xml':
  762.                 // syntaxe suivante supposée permettre l'appel d'une méthode, donnée par soon nom, de la classe désignée par $this
  763.                 // $result = [$this, $elemDescMethod]($desc["endpoint"], $desc["uri"], $format);
  764.                 $result = $this->{$elemDescMethod}($desc["endpoint"], $desc["uri"], $format);
  765.                 $mime = $this->mimetype($format);
  766.                 $response = new Response($result,
  767.                     Response::HTTP_OK,
  768.                     array('content-type' => $mime)
  769.                 );
  770.                 break;
  771.             default:
  772.                 // $result = [$this, $elemDescMethod]($desc["endpoint"], $desc["uri"], "json");
  773.                 $result = $this->{$elemDescMethod}($desc["endpoint"], $desc["uri"], "json");
  774.                 // echo $result;
  775.                 // $response = [$this, $descMethod]($desc, $result);
  776.                 $response = $this->{$descMethod}($desc, $result);
  777.                 $response->headers->set('Content-Type', 'text/html');
  778.                 break;
  779.         }
  780.         $response->headers->addCacheControlDirective('must-revalidate', true);
  781.         $response->setSharedMaxAge(3600);
  782.         return $response;
  783.     }
  785.     /**
  786.     @Route("/onto/musee/cmn/{id}")
  787.      */
  788.     public function cmnsite($id)
  789.     {
  790.         $desc = array();
  791.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  792.         $desc["dataset"] = "dm";
  793.         $desc["graph"] = "";
  794.         $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/".$id;
  795.         $desc["comment"] = "Site du CMN";
  796.         $desc["id"] = $id;
  797.         $desc["uri"] = "http://givingsense.eu/datamusee/onto/musee/cmn/".$desc["id"];
  798.         return self::siteDescription($desc);
  799.     }
  800. }