1: <?php
2:
3: $sidPlaceNews = 1;
4: $campusDomain = 1;
5: $buildingsDomain = 2;
6: $roomDomain = 3;
7: $iidName = 1;
8: $iidTyp = 2;
9: $iidSName = 3;
10: $iidSDesc = 4;
11: $iidRLayer = 5;
12: $iidRoom = 6;
13: $iidAccessibility = 7;
14: $iidTheme = 8;
15:
16:
17: LoadDomain();
18: LoadInfo();
19: LoadService();
20: LoadPlace("../../map/campusse.csv", 0, 1, 4, array(1, 5), array($campusDomain), array($iidName => 2, $iidTyp => 3, $iidSName => 5, $iidSDesc => 6));
21: LoadPlace("../../map/campus-cottbus-mitte-gebäude.csv", 0, 1, 4, array(1, 5), array($buildingsDomain), array($iidName => 2, $iidTyp => 3, $iidSName => 5, $iidSDesc => 6));
22: LoadPlace("../../map/campus-cottbus-nord-gebäude.csv", 0, 1, 4, array(1, 5), array($buildingsDomain), array($iidName => 2, $iidTyp => 3, $iidSName => 5, $iidSDesc => 6));
23: LoadPlace("../../map/campus-cottbus-süd-gebäude.csv", 0, 1, 4, array(1, 5), array($buildingsDomain), array($iidName => 2, $iidTyp => 3, $iidSName => 5, $iidSDesc => 6));
24: LoadPlace("../../map/campus-senftenberg-gebäude.csv", 0, 1, 4, array(1, 5), array($buildingsDomain), array($iidName => 2, $iidTyp => 3, $iidSName => 5, $iidSDesc => 6));
25: LoadPlace("../../map/Obergeschoss MZG.csv.old", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7, $iidRoom => 3, $iidRLayer => 2, $iidTyp => 4, $iidAccessibility =>6));
26: LoadPlace("../../map/Erdgeschoss MZG.csv.old", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7, $iidRoom => 3, $iidRLayer => 2, $iidTyp => 4, $iidAccessibility =>6));
27: LoadPlace("../../map/1. UG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
28: LoadPlace("../../map/1. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
29: LoadPlace("../../map/2. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
30: LoadPlace("../../map/3. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
31: LoadPlace("../../map/4. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
32: LoadPlace("../../map/5. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
33: LoadPlace("../../map/6. OG IKMZ.csv", 0, 1, 5, array(1), array($roomDomain), array($iidName => 7,$iidRLayer => 2, $iidTyp => 3, $iidAccessibility => 6, $iidTheme => 4));
34:
35: function LoadDomain() {
36: global $campusDomain, $buildingsDomain, $roomDomain;
37:
38: echo "INSERT INTO `domain`(`id`, `name`) VALUES ($campusDomain, 'CampusEbene');\n";
39: echo "INSERT INTO `domain`(`id`, `name`) VALUES ($buildingsDomain, 'GebaeudeEbene');\n";
40: echo "INSERT INTO `domain`(`id`, `name`) VALUES ($roomDomain, 'RaumEbene');\n";
41: }
42:
43: function LoadInfo() {
44: global $iidName, $iidTyp, $iidSName, $iidSDesc, $iidRLayer, $iidRoom, $iidAccessibility, $iidTheme;
45: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidName, 'Name');\n";
46: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidTyp, 'Typ');\n";
47: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidSName, 'Kurzname');\n";
48: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidSDesc, 'Kurzbeschreibung');\n";
49: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidRLayer, 'Ebene');\n";
50: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidRoom, 'Raumnummer');\n";
51: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidAccessibility, 'Barrierefreiheit');\n";
52: echo "INSERT INTO `information`(`id`, `name`) VALUES ($iidTheme, 'Thema');\n";
53: }
54:
55: function LoadService() {
56: global $sidPlaceNews;
57:
58: echo "INSERT INTO `service`(`id`, `name`, `sap`) VALUES ($sidPlaceNews,'PlaceNews','http://141.43.76.140:8080');\n";
59: }
60:
61: function LoadPlace($path, $planIndex = -1, $idIndex = -1, $parentIndex = -1, $alias = array(), $domain = array(), $infos = array(), $service = array(), $newsFlag = true) {
62: $sidPlaceNews = 1;
63:
64: if (($handle = fopen(utf8_decode($path), "r")) !== FALSE) {
65: $firstRow = true;
66:
67: while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {
68:
69: if ($firstRow) {
70: $firstRow = FALSE;
71: continue;
72: }
73:
74: $insertAlias = "";
75: $insertInfos = "";
76: $insertDomain = "";
77: $insertService = "";
78: $insertPlace = "";
79:
80: if ($planIndex == -1) {
81: $plan = "NULL";
82: } else {
83: $plan = trim($data[$planIndex]);
84: if (!$plan) {
85: $plan = "NULL";
86: }
87: }
88:
89: if ($idIndex == -1) {
90: $id = "NULL";
91: } else {
92: $id = trim($data[$idIndex]);
93: if (!$id) {
94: $id = "NULL";
95: }
96: }
97:
98: if ($parentIndex == -1) {
99: $parent = "NULL";
100: } else {
101: $parent = trim($data[$parentIndex]);
102: if (!$parent) {
103: $parent = "NULL";
104: }
105: }
106:
107: $insertPlace .= "INSERT INTO `place`(`id`, `plan`,parent) VALUES ($id,GeomFromText('$plan'),$parent);\n";
108:
109: foreach ($alias as $dataIndex) {
110: $tmpVal = $data[$dataIndex];
111: if ($tmpVal) {
112: $tmpValTrim = str_replace(" ", "", trim($tmpVal));
113: $insertAlias .= "INSERT INTO `placealias`(`pid`, `alias`) VALUES ($id,'$tmpValTrim');\n";
114: }
115: }
116:
117: foreach ($domain as $i => $did) {
118: $tmpVal = $did;
119: if ($tmpVal) {
120: $tmpValTrim = trim($tmpVal);
121: $insertDomain .= "INSERT INTO `placedomain`(`pid`, `did`) VALUES ($id,$tmpValTrim);\n";
122: }
123: }
124:
125: foreach ($infos as $iid => $dataIndex) {
126: $tmpVal = $data[$dataIndex];
127: if ($tmpVal) {
128: $tmpValTrim = trim($tmpVal);
129: $insertInfos .= "INSERT INTO `placeinformation`(`pid`, `iid`, `value`) VALUES ($id,$iid,'$tmpValTrim');\n";
130: }
131: }
132:
133: foreach ($service as $sid => $tmpVal) {
134: if ($tmpVal) {
135: $tmpValTrim = trim($tmpVal);
136:
137: $insertService .= "INSERT INTO `placeservice`(`pid`, `sid`, `request`) VALUES ($id,$sid,'$tmpValTrim');\n";
138: }
139: }
140:
141: echo $insertPlace;
142: echo $insertAlias;
143: echo $insertDomain;
144: echo $insertInfos;
145: echo $insertService;
146: if ($newsFlag == true) {
147: echo "INSERT INTO `placeservice`(`pid`, `sid`, `request`) VALUES ($id,$sidPlaceNews,'/p/$id');\n";
148: }
149: }
150: fclose($handle);
151: }
152: }
153:
154: ?>
155: