global $tableName_ws_connect;
global $pdo;
$tName_ws = "workingState" . $num;
$ws_sum = 0;
$sql = "SELECT * FROM " . $tName_ws . " ORDER BY id DESC LIMIT 0,5";
$stmt = $pdo->prepare($sql);
$stmt->execute();
foreach ($stmt as $row) {
$ws_sum += $row['ws'];
}
return $ws_sum;
}
$ws_sum_user1 = floor(getWorkingState(1) / 5);
$ws_sum_user2 = floor(getWorkingState(2) / 5);
$ws_sum_user3 = floor(getWorkingState(3) / 5);
$ws_sum_user4 = floor(getWorkingState(4) / 5);
//Arduino1に相手の作業度を渡す
$jsonArr = array("user_1" => $ws_sum_user1, "user_2" => $ws_sum_user2, "user_3" => $ws_sum_user3, "user_4" => $ws_sum_user4);
echo json_encode($jsonArr);
/*--------------------------------データベースとの接続を切る--------------------------------*/
$pdo = null;
/*------------------------------以下はcalcWorkingState()のためのメソッド------------------------------*/
//先ほど格納した最新のセンサデータその時のrandIDを取得する
function getNewData()
{
global $pdo;
global $tableName;
$stmt = $pdo->prepare("SELECT * FROM " . $tableName . " ORDER BY id DESC LIMIT 1");
$hoge = $stmt->execute();
foreach ($stmt as $row) {
$arr = array($row['sensorData1'], $row['sensorData2'], $row['sensorData3'], $row['sensorData4'], $row['sensorData5'], $row['sensorData6'], $row['randID']);
{
$ws_sum = 0;
if ($num == 1) {
$sql = sprintf("SELECT * FROM workingState1 ORDER BY id DESC LIMIT 0,10");
} else {
/*-------つながる相手によってテーブル名を変える必要あり------*/
$sql = sprintf("SELECT * FROM workingState2 ORDER BY id DESC LIMIT 0,10");
}
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$ws_sum += $row['ws'];
}
return $ws_sum;
}
$ws_sum_self = getWorkingState(1);
$ws_sum_partner = getWorkingState(2);
//Arduino1に相手の作業度を渡す
echo '^';
echo $ws_sum_self, ',';
//自分の作業度
echo $ws_sum_partner, ',';
//相手の作業度
/*--------------------------------データベースとの接続を切る--------------------------------*/
mysql_close($link);
/*------------------------------以下はcalcWorkingState()のためのメソッド------------------------------*/
//先ほど格納した最新のセンサデータその時のrandIDを取得する
function getNewData()
{
$sql = sprintf("SELECT * FROM ArduinoInfo1_6sensors ORDER BY id DESC LIMIT 1");
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
