src/Controller/EventController.php line 223

Open in your IDE?
  1. <?php
  2. // src/Controller/EventController.php
  3. namespace App\Controller;
  5. use Symfony\Component\Routing\Annotation\Route;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use App\Controller\DMAbstractController;
  10. class EventController  extends DMAbstractController
  11. {
  12.     public function getElementaryQuery($uri)
  13.     {
  14.         $sparqlTemplate = <<<txt
  15. construct { ?s ?p ?o } 
  16. WHERE 
  17. {
  18.     graph ?g { 
  19.             bind(<__uri__> as ?s) .
  20.            graph ?g { ?s ?p ?o } .
  21.            }
  22. } 
  23. txt;
  25.         $query =  str_replace( "__uri__" , $uri , $sparqlTemplate);
  26.         return $query;
  27.     }
  29.     function getCreatorName($endpoint, $uri) {
  30.         $user = $this->getParameter('app.sparql_user');
  31.         $pass = $this->getParameter('app.sparql_pass');
  32.         $name = "Données sur le créateur inconnues dans cette base";
  33.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  34.         $queryTemplate = "select ?creatorName where { graph ?g { <__uri__> <http://www.w3.org/2004/02/skos/core#prefLabel> ?creatorName  }}";
  35.         $query = str_replace( "__uri__" , $uri , $queryTemplate);
  36.         $requestURL = $endpoint.'?'
  37.             .'query='.urlencode($query)
  38.             .'&format=json';
  39.         $jsonres = self::request($requestURL, $auth);
  40.         $description = json_decode($jsonres, true);
  41.         // echo "description".print_r($description, true)."<br/>";
  42.         if (array_key_exists("results", $description)) {
  43.             if (array_key_exists("bindings", $description["results"])) {
  44.                 if (count($description["results"]["bindings"]))  {
  45.                     if (array_key_exists("creatorName",  $description["results"]["bindings"][0])) {
  46.                         $name = $description["results"]["bindings"][0]["creatorName"]["value"];
  47.                     } else {
  48.                         $name = "Données sur le créateur non accessible"; // le recuperer sur le concept associé
  49.                     }
  50.                 }
  51.             }
  52.         }
  53.         return $name;
  54.     }
  56.     function getTitle($endpoint, $uri) {
  57.         $user = $this->getParameter('app.sparql_user');
  58.         $pass = $this->getParameter('app.sparql_pass');
  59.         $title = "Titre inconnu dans cette base";
  60.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  61.         $queryTemplate = "select ?title where { graph ?g { <__uri__> <http://www.cidoc-crm.org/cidoc-crm/P149_is_identified_by> ?title  }}";
  62.         $query = str_replace( "__uri__" , $uri , $queryTemplate);
  63.         $requestURL = $endpoint.'?'
  64.             .'query='.urlencode($query)
  65.             .'&format=json';
  66.         $jsonres = self::request($requestURL, $auth);
  67.         //echo "jsonres: ". print_r($jsonres, true)."<br/>";
  68.         $description = json_decode($jsonres, true);
  69.         // echo "description".print_r($description, true)."<br/>";
  70.         if (array_key_exists("results", $description)) {
  71.             if (array_key_exists("bindings", $description["results"])) {
  72.                 if (count($description["results"]["bindings"]))  {
  73.                     if (array_key_exists("title",  $description["results"]["bindings"][0])) {
  74.                         $title = $description["results"]["bindings"][0]["title"]["value"];
  75.                     } else {
  76.                         $title = "Non accessible"; // le recuperer sur le concept associé
  77.                     }
  78.                 }
  79.             }
  80.         }
  81.         return $title;
  82.     }
  84.     function eventStructurer($description) {
  85.         $descstruct = array();
  86.         $descstruct["types"] = array();
  87.         $descstruct["phys"] = $descstruct["concept"]  ="";
  88.         $descstruct["creatoruri"] = array();
  89.         // echo "description: ".print_r($description, true)."\n"; a permis de détecter que certains événements n'ont pas de P108 et P94 associé!
  90.         if ($description) {
  91.             if (array_key_exists("http://www.cidoc-crm.org/cidoc-crm/P108_has_produced", $description)) $descstruct["phys"] = $description["http://www.cidoc-crm.org/cidoc-crm/P108_has_produced"]["@id"];
  92.             if (array_key_exists("http://www.cidoc-crm.org/cidoc-crm/P94_has_created", $description)) $descstruct["concept"] = $description["http://www.cidoc-crm.org/cidoc-crm/P94_has_created"]["@id"];
  93.             if (array_key_exists("cur:P108_has_produced", $description)) $descstruct["phys"] = str_replace("ex:",$description["@context"]["ex"],$description["cur:P108_has_produced"]["@id"]);
  94.             if (array_key_exists("cur:P94_has_created", $description)) $descstruct["concept"] = str_replace("ex:",$description["@context"]["ex"],$description["cur:P94_has_created"]["@id"]);
  95.             if (array_key_exists("http://www.cidoc-crm.org/cidoc-crm/P14_carried_out_by", $description)) {
  96.                 if (array_key_exists("@id",$description["http://www.cidoc-crm.org/cidoc-crm/P14_carried_out_by"])) {
  97.                     array_push($descstruct["creatoruri"], $description["http://www.cidoc-crm.org/cidoc-crm/P14_carried_out_by"]["@id"]);
  98.                 } else {
  99.                     foreach ($description["http://www.cidoc-crm.org/cidoc-crm/P14_carried_out_by"] as $crea) {
  100.                         array_push($descstruct["creatoruri"], $crea["@id"]);
  101.                     }
  103.                 }
  104.             }
  105.             if (array_key_exists("http://www.cidoc-crm.org/cidoc-crm/P4_has_time_span", $description)) $descstruct["timespan"] = $description["http://www.cidoc-crm.org/cidoc-crm/P4_has_time_span"]["@id"];
  106.             #if (array_key_exists("@type", $description)) $descstruct["types"] = $description["@type"];
  107.         }
  108.         return $descstruct;
  109.     }
  111.     function eventDescription($desc, $format)
  112.     {
  113.         $uri = $desc["uri"];
  114.         $user = $this->getParameter('app.sparql_user');
  115.         $pass = $this->getParameter('app.sparql_pass');
  116.         // $auth = "student:igr2018%"; // le dataset dmsites devrait être en libre accès
  117.         $auth = $user . ":" . $pass; // le dataset dmsites devrait être en libre accès
  118.         //$format = "json";
  119.         $query = self::getElementaryQuery($uri);
  120.         $requestURL = $desc["eventendpoint"].'?'
  121.             .'query='.urlencode($query)
  122.             .'&format=json';
  123.         // echo "eventendpoint: ". print_r($desc["eventendpoint"], true)."<br/>";
  124.         // echo "uri: ". print_r($uri, true)."<br/>";
  125.         // echo "query: ". print_r($query, true)."<br/>";
  126.         $jsonres = self::request($requestURL, $auth);
  127.         // echo "jsonres: ". print_r($jsonres, true)."<br/>";
  128.         $description = json_decode($jsonres, true);
  129.         $descstruct = array();
  130.         $descstruct["class"] = array();
  131.         $descstruct = self::eventStructurer($description);
  132.         // aller chercher le titre
  133.         $descstruct["title"] = $this->getTitle($desc["eventendpoint"], $descstruct["concept"]);
  135.         $descstruct["altLabel"] = array();
  136.         $descstruct["dataset"] = "dmexpo ou SemJoconde";
  137.         // $descstruct["triplestore"] = "https://kg.grains-de-culture.fr/";
  138.         $descstruct["triplestore"] = "https://graphpat.telecom-paris.fr/";
  139.         $descstruct["query"] = $query;
  140.         $descstruct["jsonarray"] = $description;
  141.         $descstruct["url"] = $requestURL;
  142.         $descstruct["uri"] = $uri;
  143.         $descstruct["entitytype"] = "Evènement (exposition, acte de création...)";
  144.         $descstruct["entityid"] = $desc["id"];
  145.         if (count($descstruct["creatoruri"])) {
  146.             $descstruct["creatorLink"] = $descstruct["creatoruri"][0];
  147.             $descstruct["creatorName"] = $this->getCreatorName($desc["eventendpoint"], $descstruct["creatoruri"][0]);
  148.         } else {
  149.             $descstruct["creatorLink"] = "";
  150.             $descstruct["creatorName"] = "Créateur inconnu dans cette base";
  151.         }
  152.         if (!array_key_exists("timespan", $descstruct))
  153.             $descstruct["timespan"] = "<inconnue>";
  154.         $descstruct["jsonld"] = "";
  155.         $descstruct["altLabel"] = "";
  156.         $descstruct["uriville"] = "";
  157.         $descstruct["urljson"] = $descstruct["uri"].".json";
  158.         $yasguilink = "https://grains-de-culture.fr/fuseki/ui/#"
  159.             .'query='.urlencode(
  160.                 str_replace("construct { ?s ?p ?o }", "select ?s ?p ?o", $query))
  161.             .'&contentTypeConstruct='.urlencode("text/turtle")
  162.             .'&contentTypeSelect='.urlencode("application/sparql-results+json")
  163.             .'&endpoint='.urlencode($desc["eventendpoint"])
  164.             .'&requestMethod=POST'
  165.             .'&tabTitle='.urlencode("Propriétés")
  166.             .'&headers=%7B%7D'
  167.             .'&outputFormat=table';
  168.         $descstruct["yasguilink"] = $yasguilink;
  169.         switch($format) {
  170.             case 'json':
  171.                 $mime = $this->mimetype($format);
  172.                 $response = new Response($jsonres,
  173.                     Response::HTTP_OK,
  174.                     array('content-type' => $mime)
  175.                 );
  176.                 break;
  177.             case 'xml':
  178.                 $call = $desc["eventendpoint"].'?'
  179.                     .'query='.urlencode($query)
  180.                     .'&format='.$this->mimetype($format)
  181.                     .'&output='.$format;
  182.                 $mime = $this->mimetype($format);
  183.                 $result =self::request($call, $auth);
  184.                 $response = new Response($result,
  185.                     Response::HTTP_OK,
  186.                     array('content-type' => $mime)
  187.                 );
  188.                 break;
  189.             default:
  190.                 $response = $this->render('event/dmcreationevent.html.twig', [
  191.                 # $response = $this->render('work/dmdebugevent.html.twig', [
  192.                     'desc' => $desc,
  193.                     'descstruct' => $descstruct,
  194.                     'entitytype' => $descstruct["entitytype"],
  195.                     'description' => $description
  196.                 ]);
  197.                 break;
  198.         }
  199.         $response->headers->addCacheControlDirective('must-revalidate', true);
  200.         $response->setSharedMaxAge(3600);
  201.         //$response->headers->set('Content-Type', 'application/json');
  202.         return $response;
  203.     }
  205.     /**
  206.     @Route("onto/event/creation/{id}.{_format}", defaults={"_format": "html"}, requirements={
  207.      *         "_format": "html|json|xml|ttl"
  208.      *     })
  209.      */
  210.     public function dmcreationevent(Request $request, $id)
  211.     {
  212.         // exemple: http://datamusee.givingsense.eu/onto/event/creation/AE037477
  213.         $format = $this->getFormat($request);
  214.         $desc = array();
  215.         // 26/6/2024 changement de point car le report sur TPT ne marche pas actuellement
  216.         //$desc["eventendpoint"] = "https://kg.grains-de-culture.fr/SemJoconde/sparql";
  217.         $desc["eventendpoint"] = "https://graphpat.telecom-paris.fr/SemJoconde/sparql";
  218.         $desc["eventdataset"] = "SemJoconde";
  219.         $desc["eventgraph"] = "";
  220.         $desc["comment"] = "";
  221.         $desc["id"] = $id;
  222.         $desc["uri"] = "http://datamusee.givingsense.eu/onto/event/creation/".$desc["id"];
  223.         return self::eventDescription($desc, $format);
  224.     }
  225. }