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("http://dbpedia.org/ontology/city", $jsonDescription)) {
  302.                 if (is_array($jsonDescription["http://dbpedia.org/ontology/city"])) $descstruct["ville"] = $jsonDescription["http://dbpedia.org/ontology/city"]["@value"];
  303.                 else $descstruct["ville"] = $jsonDescription["http://dbpedia.org/ontology/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.   graph ?g 
  401.   {  <__uri__> wdt:P31 ?o .
  402.       ?o  <http://www.wikidata.org/prop/direct/P279>* ?super.
  403.   ?o rdfs:label ?label .
  404.   ?super rdfs:label ?superlabel .
  405.   bind(lang(?superlabel) as ?lang)
  406.   filter((lang(?superlabel)='en') ||(lang(?superlabel)='en') ) 
  407.      }
  408.   }
  409. txt;
  410.         $queryClasses =  str_replace( "__uri__" , $uriclass , $classTemplate);
  411.         $requestURL = $endpoint.'?'
  412.             .'query='.urlencode($queryClasses)
  413.             .'&format=json';
  414.         $classes = json_decode(self::request($requestURL, $auth), true);
  415.         $classArray = array();
  416.         foreach ($classes["results"]["bindings"] as $item) {
  417.             $lang = "";
  418.             if(array_key_exists("xml:lang", $item["label"]))
  419.                 $lang = $item["label"]["xml:lang"];
  420.             if ($lang=="en") $classArray[$item["o"]["value"]] = [ "class"=> $item["o"]["value"], "label" =>$item["label"]["value"], "lang"=>$lang];
  421.             if(array_key_exists("super", $item)){
  422.                 if(array_key_exists("xml:lang", $item["superlabel"])) $lang = $item["superlabel"]["xml:lang"]; else $lang = "";
  423.                 if ($lang=="en")
  424.                     $classArray[$item["super"]["value"]] = [ "class"=> $item["super"]["value"], "label" =>$item["superlabel"]["value"], "lang"=>$lang];
  425.             }
  426.         }
  427.         return $classArray;
  428.         //return array($queryClasses);
  429.     }
  431.     function getGuestBookContribCount($endpoint, $urisite)
  432.     {
  433.         $sparqltemplate = <<<txt
  434. PREFIX schema: <http://schema.org/>
  435. select (count(distinct ?s) as ?cl)(count(distinct ?user) as ?cu) 
  436. where
  437. {
  438.   values ?graph { <http://datamusee.givingsense.eu/livredor/parismusees> <http://datamusee.givingsense.eu/livredor/cmn> }
  439.     graph ?graph {
  440.     ?app schema:about <__uri__> .
  441.     ?s a <http://datamusee.givingsense.eu/onto/contribution>; 
  442.        <http://datamusee.givingsense.eu/onto/contribution/hasUser> ?user;
  443.        <http://datamusee.givingsense.eu/onto/contribution/hasAppli> ?app . 
  444.   }
  445. } 
  446. txt;
  447.         $format = "application/sparql-results+json";
  448.         $query =  str_replace( "__uri__" , $urisite , $sparqltemplate);
  449.         $user = $this->getParameter('app.sparql_user');
  450.         $pass = $this->getParameter('app.sparql_pass');
  451.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  452.        $requestURL = $endpoint.'?'
  453.             .'query='.urlencode($query)
  454.             .'&format='.urlencode($format);
  455.         $res = json_decode(self::request($requestURL, $auth), true);
  456.         $count = array(); $count["countcontrib"] = $count["countuser"] = 0;
  457.         if ($res) {
  458.             $count["countcontrib"]  = $res["results"]["bindings"][0]["cl"]["value"];
  459.             $count["countuser"] = $res["results"]["bindings"][0]["cu"]["value"];
  460.         }
  461.         //return $query;
  462.         return $count;
  463.     }
  465.     function getSellActionCount($endpoint, $graph)
  466.     {
  467.         $sparqltemplate = <<<txt
  468. PREFIX schema: <http://schema.org/>
  469. select (count(distinct ?s) as ?sellactioncount) (count(distinct ?buyer) as ?buyerscount) (count(distinct ?product) as ?productscount) 
  470. {
  471.   graph <__uri__> {
  472.     ?s a schema:SellAction ;
  473.     schema:buyer ?buyer ;
  474.     <http://datamusee.givingsense.eu/onto/product/hasProduct> ?product
  475.   }
  476. }
  477. txt;
  479.         $format = "application/sparql-results+json";
  480.         $query =  str_replace( "__uri__" , $graph , $sparqltemplate);
  481.         $user = $this->getParameter('app.sparql_user');
  482.         $pass = $this->getParameter('app.sparql_pass');
  483.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  484.         $requestURL = $endpoint.'?'
  485.             .'query='.urlencode($query)
  486.             .'&format='.urlencode($format);
  487.         $res = json_decode(self::request($requestURL, $auth), true);
  488.         $count = array(); $count["countcontrib"] = $count["countuser"] = 0;
  489.         if ($res) {
  490.             $count["salescount"]  = $res["results"]["bindings"][0]["sellactioncount"]["value"];
  491.             $count["buyerscount"] = $res["results"]["bindings"][0]["buyerscount"]["value"];
  492.             $count["productscount"] = $res["results"]["bindings"][0]["productscount"]["value"];
  493.         }
  494.         return $count;
  495.     }
  497.     /**
  498.     @Route("/onto/sites/debug", name="sitesd")
  499.      */
  500.     public function ontoListeSitesDebug()
  501.     {
  502.         $desc = array();
  503.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  504.         $desc["dataset"] = "dmsites";
  505.         $desc["graph"] = "";
  506.         $desc["dmticketinggraph"] = "https://kg.grains-de-culture.fr/dmmeta/sparql";
  507.         $desc["comment"] = "Sites du CMN et de Paris Musées";
  508.         $desc["uri"] = "http://datamusee.givingsense.efu/onto/sites";
  509.         $uri = $desc["uri"];
  510.         $sparqltemplate = <<<txt
  511. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
  512. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  513. SELECT distinct ?s ?label
  514. WHERE 
  515. { 
  516.     values ?g { <http://datamusee.givingsense.eu/graph/sites/cmn> <http://datamusee.givingsense.eu/graph/sites/parismusees>}
  517.     graph ?g {
  518.     ?s  skos:prefLabel ?label .
  519.     FILTER(LANG(?label) = "" || LANGMATCHES(LANG(?label), "fr"))
  520.     filter(contains(str(?s),"http://datamusee.givingsense.eu/onto/site/"))
  521.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P31> ?s } 
  522.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P279> ?s }
  523.     }
  524. }
  525. txt;
  527.         $query = str_replace("__uri__", $uri, $sparqltemplate);
  528.         $descstruct["query"] = $query;
  529.         $description = "";
  530.         return $this->render('testTemplateSite.html.twig', [
  531.             'desc' => $desc,
  532.             'descstruct' => $descstruct,
  533.             'description' => $description
  534.         ]);
  535.     }
  537.     /**
  538.     @Route("/onto/sites.{_format}", defaults={"_format": "html"}, name="sites")
  539.      */
  540.     public function ontoListeSites(Request $request)
  541.     {
  542.         // $lang = $request->getLocale();
  543.         $format = $this->getFormat($request);
  544.         /*
  545.         $format = $request->getRequestFormat();
  546.         $requestedContentTypes = $request->getAcceptableContentTypes();
  547.         foreach ($requestedContentTypes as $rType) {
  548.             if ($rType == 'application/json') { $format = 'json'; break; }
  549.             if ($rType == 'application/x-turtle') { $format = 'ttl'; break; }
  550.             if ($rType == 'application/rdf+xml') { $format = 'xml'; break; }
  551.         }
  552.         */
  553.         $desc = array();
  554.         $user = $this->getParameter('app.sparql_user');
  555.         $pass = $this->getParameter('app.sparql_pass');
  556.         // $auth = "student:igr2018%"; // le dataset dmsites devrait être en libre accès
  557.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  558.         // temporaire cause redirection mal gérée $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  559.         $desc["endpoint"] = "http://137.194.211.97/test20240630/sparql";
  560.         $desc["dataset"] = "dmsites";
  561.         $desc["graph"] = "";
  562.         $desc["dmticketinggraph"] = "";
  563.         $desc["comment"] = "Sites du CMN et de Paris Musées";
  564.         $desc["uri"] = "http://datamusee.givingsense.eu/onto/sites";
  565.         $uri = $desc["uri"];
  566.         $sformat = "application/sparql-results+json";
  567.         $sparqltemplate = <<<txt
  568. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
  569. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  570. SELECT distinct ?s ?label
  571. WHERE 
  572. { 
  573.     values ?g { <http://datamusee.givingsense.eu/graph/sites/cmn> <http://datamusee.givingsense.eu/graph/sites/parismusees>}
  574.     graph ?g {
  575.     ?s  skos:prefLabel ?label .
  576.     FILTER(LANG(?label) = "" || LANGMATCHES(LANG(?label), "fr"))
  577.     filter(contains(str(?s),"http://datamusee.givingsense.eu/onto/site/"))
  578.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P31> ?s } 
  579.     filter not exists { ?q <http://www.wikidata.org/prop/direct/P279> ?s }
  580.     }
  581. }
  582. txt;
  584.         $query =  str_replace( "__uri__" , $uri , $sparqltemplate);
  585.         $requestURL = $desc["endpoint"].'?'
  586.             .'query='.urlencode($query)
  587.             .'&format='.urlencode($sformat);
  588.         $sites = json_decode(self::request($requestURL, $auth), true);
  589.         $descstruct["dataset"] = "dmsites";
  590.         $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  591.         $descstruct["query"] = $query;
  592.         $descstruct["jsonarray"] = self::request($requestURL, $auth);
  593.         $descstruct["url"] = $requestURL;
  594.         $descstruct["uri"] = $uri;
  595.         $descstruct["debug"] = $query;
  596.         $descstruct["sites"] = $sites["results"]["bindings"];
  597.         $descstruct["entitytype"] = "Sites partenaire de Data&Musée";
  598.         switch($format) {
  599.             case 'json':
  600.             //case 'ttl':
  601.             case 'xml':
  602.                 $call = $desc["endpoint"].'?'
  603.                     .'query='.urlencode($query)
  604.                     .'&format='.$this->mimetype($format)
  605.                     .'&output='.$format;
  606.                 $mime = $this->mimetype($format);
  607.                 //$ch = curl_init($call);
  608.                 //curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  609.                 //curl_setopt($ch, CURLOPT_HEADER, false);
  610.                 //$result .= curl_exec($ch);
  611.                 //curl_close($ch);
  612.                 $result =self::request($call, $auth);
  613.                 $response = new Response($result,
  614.                     Response::HTTP_OK,
  615.                     array('content-type' => $mime)
  616.                 );
  617.                 break;
  618.             case 'gql':
  619.                 $gqlquery = <<<txt
  620. {sites{ 
  621.     edges {     node {id
  622.         prefLabel}}}}
  623. txt;
  624.                 $gqldesc["query"] = $gqlquery;
  625.                 $json = json_decode($this->graphqlQuery('http://dm.givingsense.eu/graphql4/graphql', $gqlquery, ""), true, 512, JSON_UNESCAPED_UNICODE);
  626.                 $descstruct["sites"] = array();
  627.                 foreach ($json["data"]["sites"]["edges"] as $edge) {
  628.                     $site = array();
  629.                     $site["s"] = array();
  630.                     $site["s"]["value"] = $edge["node"]["id"];
  631.                     $site["label"] = array();
  632.                     $site["label"]["value"] = $edge["node"]["prefLabel"];
  633.                     array_push($descstruct["sites"], $site);
  634.                 }
  635.                 $response = $this->render('site/dmsites.html.twig', [
  636.                 //$response = $this->render('testGraphQL.html.twig', [
  637.                     'desc' => $desc,
  638.                     'descstruct' => $descstruct,
  639.                     'entitytype' => $descstruct["entitytype"]
  640.                 ]);
  641.                 break;
  642.             default:
  643.                 $response = $this->render('site/dmsites.html.twig', [
  644.                     'desc' => $desc,
  645.                     'descstruct' => $descstruct,
  646.                     'entitytype' => $descstruct["entitytype"],
  647.                     'description' => $sites
  648.                 ]);
  649.                 break;
  650.         }
  651.         $response->headers->addCacheControlDirective('must-revalidate', true);
  652.         $response->setSharedMaxAge(3600);
  653.         //$response->headers->set('Content-Type', 'application/json');
  654.         return $response;
  655.     }
  657.     /**
  658.     @Route("onto/site/{id}/debug")
  659.      */
  660.     public function cmnsitenewDebug($id)
  661.     {
  662.         $desc = array();
  663.         // temporaire cause redirection mal gérée $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  664.         $desc["endpoint"] = "http://137.194.211.97/test20240630/sparql";
  665.         $desc["dataset"] = "dmsites";
  666.         $desc["graph"] = "http://givingsense.eu/datamusee/onto/dmsites";
  667.         $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/".$id;
  668.         $desc["comment"] = "Site référencé par Data&Musée";
  669.         $desc["id"] = $id;
  670.         $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/".$desc["id"];
  671.         $desc["query"]= $this->getElementaryQuery($desc["uri"]);
  672.         $result = $this->getElementaryDescription($desc["endpoint"], $desc["uri"], "json");
  673.         return self::newSiteDescription($desc, $result, true);
  674.         //return self::jocondeSiteDescription($desc, $result, true);
  675.     }
  677.     public function getElementaryQuery($uri)
  678.     {
  679.         $sparqlTemplate = self::getPrefixes() . <<<txt
  680. prefix owl: <http://www.w3.org/2002/07/owl#>
  681. construct { ?s ?p ?o ; a ?t} 
  682. WHERE 
  683. { 
  684.     graph ?g
  685.     {
  686.         {
  687.             bind(<__uri__> as ?s) .
  688.            ?s ?p ?o .
  689.            ?s <http://www.wikidata.org/prop/direct/P31> ?t .
  690.         } UNION
  691.         {
  692.             bind(<__uri__> as ?sameas) .
  693.             ?s owl:sameAs ?sameas . 
  694.             ?s ?p ?o .
  695.             ?s <http://www.wikidata.org/prop/direct/P31> ?t .
  696.         }
  697.     }
  698. } 
  699. txt;
  701.         $query =  str_replace( "__uri__" , $uri , $sparqlTemplate);
  702.         return $query;
  703.     }
  705.     public function getElementaryDescription($endpoint, $uri, $format)
  706.     {
  707.         $user = $this->getParameter('app.sparql_user');
  708.         $pass = $this->getParameter('app.sparql_pass');
  709.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  710.         //#graph <http://datamusee.givingsense.eu/graph/sites/cmn>
  711.         $query =  $this->getElementaryQuery($uri); //str_replace( "__uri__" , $uri , $sparqlTemplate);
  712.         $call = $endpoint.'?'
  713.             .'query='.urlencode($query)
  714.             . '&format=' . $this->mimetype($format)
  715.             .'&output='.$format;
  716.         $result =self::request($call, $auth);
  717.         //$mime = $this->mimetype($format);
  718.         //$response = new Response($result,
  719.         //    Response::HTTP_OK,
  720.         //    array('content-type' => $mime)
  721.         //);
  722.         //return $response;
  723.         //echo htmlentities($query);
  724.         return $result;
  725.     }
  727.     /**
  728.     @Route("/onto/site/{id}.{_format}", defaults={"_format": "html"}, requirements={
  729.      *         "_format": "html|json|xml|ttl"
  730.      *     })
  731.      */
  732.     public function cmnsitenew(Request $request, $id)
  733.     {
  734.         $format = $this->getFormat($request);
  735.         // initialize some keys
  736.         $desc = array();
  737.         # echo intval($id);
  738.         if ((intval($id)!=0)or($id[0]=='M')or($id[0]=='P')) { // expected to be a Data&Musée site
  739.             // temporaire cause redirection mal gérée $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  740.             $desc["endpoint"] = "http://137.194.211.97/test20240630/sparql";
  741.             $desc["ticketendpoint"] = "https://kg.grains-de-culture.fr/dm/sparql";
  742.             $desc["dataset"] = "dmsites";
  743.             $desc["graph"] = "";
  744.             $desc["ticketdataset"] = "dm";
  745.             $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/" . $id;
  746.             $desc["comment"] = "Site membre du CMN";
  747.             $desc["id"] = $id;
  748.             $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/" . $desc["id"];
  749.             $desc["query"]= $this->getElementaryQuery($desc["uri"]);
  750.             $elemDescMethod = 'getElementaryDescription';
  751.             $descMethod = 'newSiteDescription';
  752.         } else { // expected to be a SemJoconde site
  753.             // temporaire cause redirection mal gérée $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  754.             $desc["endpoint"] = "http://137.194.211.97/test20240630/sparql";
  755.             $desc["ticketendpoint"] = "";
  756.             $desc["dataset"] = "SemJoconde";
  757.             $desc["graph"] = "http://joconde.givingsense.eu/graph/dmsites";
  758.             $desc["ticketdataset"] = "";
  759.             $desc["dmticketinggraph"] = "";
  760.             $desc["comment"] = "Site référencé dans la base Joconde";
  761.             $desc["id"] = $id;
  762.             $desc["uri"] = "http://datamusee.givingsense.eu/onto/site/" . $desc["id"];
  763.             $elemDescMethod = 'getElementaryDescription';
  764.             $descMethod = 'jocondeSiteDescription';
  765.         }
  766.         switch($format) {
  767.             case 'json': case 'ttl': case 'xml':
  768.                 // syntaxe suivante supposée permettre l'appel d'une méthode, donnée par soon nom, de la classe désignée par $this
  769.                 // $result = [$this, $elemDescMethod]($desc["endpoint"], $desc["uri"], $format);
  770.                 $result = $this->{$elemDescMethod}($desc["endpoint"], $desc["uri"], $format);
  771.                 $mime = $this->mimetype($format);
  772.                 $response = new Response($result,
  773.                     Response::HTTP_OK,
  774.                     array('content-type' => $mime)
  775.                 );
  776.                 break;
  777.             default:
  778.                 // $result = [$this, $elemDescMethod]($desc["endpoint"], $desc["uri"], "json");
  779.                 $result = $this->{$elemDescMethod}($desc["endpoint"], $desc["uri"], "json");
  780.                 // echo $result;
  781.                 // $response = [$this, $descMethod]($desc, $result);
  782.                 $response = $this->{$descMethod}($desc, $result);
  783.                 $response->headers->set('Content-Type', 'text/html');
  784.                 break;
  785.         }
  786.         $response->headers->addCacheControlDirective('must-revalidate', true);
  787.         $response->setSharedMaxAge(3600);
  788.         return $response;
  789.     }
  791.     /**
  792.     @Route("/onto/musee/cmn/{id}")
  793.      */
  794.     public function cmnsite($id)
  795.     {
  796.         $desc = array();
  797.         $desc["endpoint"] = "https://kg.grains-de-culture.fr/dmsites/sparql";
  798.         $desc["dataset"] = "dm";
  799.         $desc["graph"] = "";
  800.         $desc["dmticketinggraph"] = "http://datamusee.givingsense.eu/graph/billetterie/site/".$id;
  801.         $desc["comment"] = "Site du CMN";
  802.         $desc["id"] = $id;
  803.         $desc["uri"] = "http://givingsense.eu/datamusee/onto/musee/cmn/".$desc["id"];
  804.         return self::siteDescription($desc);
  805.     }
  806. }