server/src/app/Repositories/RdfDocumentRepository.php
changeset 489 18613f052d56
parent 445 b1e5ad6b2a29
child 499 b5cff30efa0a
equal deleted inserted replaced
488:0161e028afb7 489:18613f052d56
   202                 array_push($limitsClauses, "LIMIT $limit");
   202                 array_push($limitsClauses, "LIMIT $limit");
   203             }
   203             }
   204             if(!empty($limitsClauses)) {
   204             if(!empty($limitsClauses)) {
   205                 $limitsClausesStr = "\n" . join(" ", $limitsClauses);
   205                 $limitsClausesStr = "\n" . join(" ", $limitsClauses);
   206             }
   206             }
   207             $sortClauseStr = "\n ORDER BY ?uri";
   207             $sortClauseStr = "\n ORDER BY ASC(?title)";
   208             $total = $this->getCount();
   208             $total = $this->getCount();
   209         } else {
   209         } else {
   210             $esRes = $this->queryES($filters, $offset, $limit);
   210             $esRes = $this->queryES($filters, $offset, $limit, ["title.raw" => 'asc']);
   211             // WARNING: we count on the fact that php keep keys order
   211             // WARNING: we count on the fact that php keep keys order
   212             $total = intval($esRes['total']);
   212             $total = intval($esRes['total']);
   213             foreach($esRes['documents'] as $esDocId) {
   213             foreach($esRes['documents'] as $esDocId) {
   214                 $uri = config('corpusparole.corpus_doc_id_base_uri_prefix').$esDocId;
   214                 $uri = config('corpusparole.corpus_doc_id_base_uri_prefix').$esDocId;
   215                 $resDocs[$uri] = null;
   215                 $resDocs[$uri] = null;