howlinks/request_input_output.php at master · paolo7/howlinks · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php

	// find processes that produce a dbpedia ingredient
	function look_for_dbpedia_input($entityURI,$dbpedia,$db_link,$db_dbpedia) {
		$entityURI=explode('---',$entityURI)[1];
		$children=array();
		$result=sparql_request("PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
								PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
								PREFIX prohow: <http://w3id.org/prohow#>

								SELECT ?method ?exact


								WHERE {
									?node rdf:type <".$dbpedia."> .
									?node prohow:has_method ?method .
									?method rdfs:label ?exact .
								}",$db_link);

		while( $row = sparql_fetch_array( $result ) )
		{
			$child= array(
				'id' => $row['method'],
				'name' => $row['exact'],
				'annotation' => 'supplier',
				'image' => '',
				'dbpedia' => '',
				'children' => array()
			);

			$children[] = $child;
		}
		return $children;
	}
	// find processes that need a particular dbpedia ingredient
	function look_for_dbpedia_output($entityURI,$dbpedia,$db_link,$db_dbpedia,$limit) {
		$entityURI=explode('---',$entityURI)[1];
		$children=array();
		$result=sparql_request('PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
								PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
								PREFIX prohow: <http://w3id.org/prohow#>

								SELECT ?method ?exact

								WHERE {
									?node rdf:type <'.$dbpedia.'> .
									?method prohow:requires ?node .
									?method rdfs:label ?exact .
								} limit 50',$db_link);
		if(sparql_num_rows($result)>$limit) {

			$count=0;
			while( $row = sparql_fetch_array( $result ) )
			{
				$child= array(
					'id' => $row['method'],
					'name' => $row['exact'],
					'annotation' => 'supplied',
					'image' => '',
					'dbpedia' => '',
					'children' => array()
				);

				$children[] = $child;

				if($count++>=$limit) break;
			}

			$fake_children=array();
			while( $row = sparql_fetch_array( $result ) )
			{
				$child= array(
					'id' => $row['method'],
					'name' => $row['exact'],
					'annotation' => 'supplied',
					'image' => '',
					'dbpedia' => '',
					'children' => array()
				);
				$fake_children[] = $child;
			}

			$fake_node= array(
				'id' => 'http_extension',
				'name' => 'More supplied process',
				'annotation' => 'supplied_extension',
				'image' => '',
				'dbpedia' => '',
				'children' => $fake_children
			);
			$children[] = $fake_node;
		}
		else
			while( $row = sparql_fetch_array( $result ) )
			{
				$child= array(
					'id' => $row['method'],
					'name' => $row['exact'],
					'annotation' => 'supplied',
					'image' => '',
					'dbpedia' => '',
					'children' => array()
				);

				$children[] = $child;
			}
		return $children;
	}
?>