StraboSpot-Server/buildCenters.php at master · StraboSpot/StraboSpot-Server · 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
<?php
/**
 * File: buildCenters.php
 * Description: Handles buildCenters operations - helper script
 *
 * @package    StraboSpot Web Site
 * @author     Jason Ash <jasonash@ku.edu>
 * @copyright  2025 StraboSpot
 * @license    https://opensource.org/licenses/MIT MIT License
 * @link       https://strabospot.org
 */

exit();
ini_set('max_execution_time', 0);
include("logincheck.php");
include("prepare_connections.php");

echo str_repeat(" ", 256);

if($userpkey != 3) exit();

$userRows = $db->get_results("SELECT * FROM users WHERE pkey != 3 AND pkey > 4493 ORDER BY pkey");

foreach($userRows as $userRow){

	$upkey = $userRow->pkey;
	$name = $userRow->firstname." ".$userRow->lastname;
	echo "User: $name<br>";

	//Get projects
	$safe_upkey = addslashes($upkey);
	$projectRows = $neodb->get_results("match (p:Project) where p.userpkey = $safe_upkey return p;");
	foreach($projectRows as $prow){
		$prow = $prow->get("p");
		$prow=(object)$prow->values();
		$pcentroid = trim($prow->centroid);
		$pstraboid = $prow->id;
		$projectname = $prow->desc_project_name;

		echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$projectname<br>";

		if($pcentroid != "" && $pstraboid != ""){
			$db->prepare_query("UPDATE project SET location = ST_GeomFromText($1) WHERE strabo_project_id = $2 AND user_pkey = $3",
				array($pcentroid, $pstraboid, $upkey));
		}

		$safe_pstraboid = addslashes($pstraboid);
		$datasetRows = $neodb->get_results("match (p:Project)-[HAS_DATASET]->(d:Dataset) where p.userpkey = $safe_upkey and p.id=$safe_pstraboid return d;");
		foreach($datasetRows as $drow){
			$drow = $drow->get("d");
			$drow=(object)$drow->values();
			$dcentroid = trim($drow->centroid);
			$dstraboid = $drow->id;
			$datasetname = $drow->name;

			if($dcentroid != "" && $dstraboid != ""){
				$db->prepare_query("UPDATE dataset SET location = ST_GeomFromText($1) WHERE strabo_dataset_id = $2 AND user_pkey = $3",
					array($pcentroid, $dstraboid, $upkey));
			}

			$safe_dstraboid = addslashes($dstraboid);
			$querystring = "match (a:Dataset)-[r:HAS_SPOT]->(s:Spot) where a.userpkey=$safe_upkey and a.id=$safe_dstraboid optional match (s)-[c:HAS_IMAGE]-(i:Image) with s, collect(i) as i RETURN s,i;";
			$json = $strabo->getPGFeatureCollection($querystring);

			$spots = $json['features'];

			$spotcount = count($spots);

			echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dataset: $datasetname ($spotcount spots)<br>";
			flush();
			ob_flush();

			foreach($spots as $spot){
				$strabo_spot_id = $spot['properties']['id'];

				if($spot['geometry']->type!=""){
					$locjson = json_encode($spot['geometry']);
					$mywkt=geoPHP::load($locjson,"json");
					$spotlocation = $mywkt->out('wkt');
				}else{
					$spotlocation="null";
				}

				if($spotlocation != "null"){
					$db->prepare_query("UPDATE spot SET location = ST_GeomFromText($1) WHERE strabo_spot_id = $2 AND user_pkey = $3",
						array($spotlocation, $strabo_spot_id, $upkey));
				}
			}

		}

	}

}

?>