tcc-web/serverJSON.php at master · alipsilv/tcc-web · 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
<?php
require_once "lib/nusoap.php";

function insertDataJSON($data) {

	$host = "mysql.hostinger.com.br";
    $database = "u191786021_ws";
    $user = "u191786021_aline";
    $pass= "weather";

    $dateTimeW =  date("Y-m-d"). "+" . date("H"). "%3A". date("i"). "%3A". date("s");
    $dateTimeSQL =  date("Y-m-d H:i:s");
    $arr = json_decode($data,true);

    $con = mysql_connect($host,$user,$pass) or print (mysql_error());
    mysql_select_db($database, $con) or print(mysql_error());

    foreach($arr as $item) {
    	$sql = "insert into data(wstn_prmt_seq, wstn_value, wstn_date) values(" . $item['wstn_prmt_seq'] . "," . $item['wstn_value'] . "," . "'". $dateTimeSQL ."')";
    	$result = mysql_query($sql, $con);
    	/*
    	 * O Location Wunderground seguirá uma lógica qndo dispusermos do módulo gps
    	 * 1 - Parâmetro de temperatura fahrenheit F
    	 * 2 - Humidade em %
    	 *
    	 */

    	switch ($item['wstn_prmt_seq']) {
    		case "1":
        		$tempf = $item['wstn_value'];
        		break;
   		    case "2":
        		$humidity = $item['wstn_value'];
        		break;
		}
	}
	mysql_close($con);

	//Grava no Wunderground
	$url = "http://weatherstation.wunderground.com/weatherstation/updateweatherstation.php?ID=ISOPAULO84&PASSWORD=aWe513&dateutc=". $dateTimeW."&tempf=". $tempf;
	$cURL = curl_init($url);
	curl_setopt($cURL, CURLOPT_RETURNTRANSFER, true);
	$result = curl_exec($cURL);
	curl_close($cURL);

    return  "sucess" ;
}


$server = new soap_server();
$server->configureWSDL("serverJSON", "urn:serverJSON");

$server->register("insertDataJSON",
		array("data" => "xsd:string"),
		array("return" => "xsd:string"),
		"urn:serverJSON",
		"urn:serverJSON#insertDataJSON",
		"rpc",
		"encoded",
		"Insert data into table");

$server->service($HTTP_RAW_POST_DATA);
?>