equal
deleted
inserted
replaced
18 $ids[] = $ligne[0]; |
18 $ids[] = $ligne[0]; |
19 } |
19 } |
20 |
20 |
21 pg_free_result($rq); |
21 pg_free_result($rq); |
22 |
22 |
23 $sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet WHERE tag_id IN (" . join(",", $ids) . ")"; |
23 $sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet V WHERE tag_id IN (" . join(",", $ids) . ") AND EXISTS (SELECT * FROM hdabo_datasheet W WHERE V.datasheet_id = W.id AND W.validated=TRUE)"; |
24 |
24 |
25 $rq = pg_query($sql); |
25 $rq = pg_query($sql); |
26 |
26 |
27 if ($ligne = pg_fetch_row($rq)) { |
27 if ($ligne = pg_fetch_row($rq)) { |
28 $resobj["content_count"] = $ligne[0]; |
28 $resobj["content_count"] = $ligne[0]; |
36 $resobj["dbpedia_uri"] = $ligne[0]; |
36 $resobj["dbpedia_uri"] = $ligne[0]; |
37 $resobj["wikipedia_url"] = $ligne[1]; |
37 $resobj["wikipedia_url"] = $ligne[1]; |
38 } |
38 } |
39 |
39 |
40 pg_free_result($rq); |
40 pg_free_result($rq); |
41 |
41 /* |
42 if (isset($resobj["dbpedia_uri"]) and $resobj["dbpedia_uri"]) { |
42 if (isset($resobj["dbpedia_uri"]) and $resobj["dbpedia_uri"]) { |
43 $uri = $resobj["dbpedia_uri"]; |
43 $uri = $resobj["dbpedia_uri"]; |
44 $sql = "SELECT abstract, label, thumbnail FROM dbpedia_fields WHERE dbpedia_uri = '$uri'"; |
44 $sql = "SELECT abstract, label, thumbnail FROM dbpedia_fields WHERE dbpedia_uri = '$uri'"; |
45 $rq = pg_query($sql); |
45 $rq = pg_query($sql); |
46 if ($ligne = pg_fetch_row($rq)) { |
46 if ($ligne = pg_fetch_row($rq)) { |
49 $resobj["thumbnail"] = $ligne[2]; |
49 $resobj["thumbnail"] = $ligne[2]; |
50 } |
50 } |
51 |
51 |
52 pg_free_result($rq); |
52 pg_free_result($rq); |
53 } |
53 } |
54 |
54 */ |
55 $sql = "SELECT * FROM hdaviz_simple_tag_links WHERE subject ILIKE '$label' OR object ILIKE '$label'"; |
55 $sql = "SELECT * FROM hdaviz_simple_tag_links WHERE subject ILIKE '$label' OR object ILIKE '$label'"; |
56 $rq = pg_query($sql); |
56 $rq = pg_query($sql); |
57 |
57 |
58 $resobj["links"] = pg_fetch_all($rq); |
58 $resobj["links"] = pg_fetch_all($rq); |
59 pg_free_result($rq); |
59 pg_free_result($rq); |