ansysqgis008_shinmojirelay

File "ctrl.php"

Full path: /www/ansys/qgis/008_shinmoji/relay/ctrl.php
File size: 3.38 KiB (3457 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php
//===============================================
//	Common
//	備考		：	
//	更新		：	2015/01/27 KMK-Teraoka
//===============================================
$HOST       = "192.168.100.153";
$DB         = "ansys";
$USER       = "postgres";
$PASS       = "am#71ZJ*";
$MSG_HEADER = "ArduinoRelayCtrlService";
$TITLE      = "リレー制御";
$CONST_ID   = "11";
$APP_ID     = "19";

print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>". $TITLE. "</title>";
print "</head>";

print "<body>";
print "<form method=\"post\">";

try
{
  $btnCtrlSend = isset($_POST["btnCtrlSend"]) ? htmlspecialchars($_POST["btnCtrlSend"]) : "";
  if (strcmp($btnCtrlSend, "送信") == 0)
  {
    $opf_user = isset($_POST["selTerminalInfo"]) ? htmlspecialchars($_POST["selTerminalInfo"]) : "";
    $ctrlMessage = isset($_POST["rdiSelectMsg"]) ? htmlspecialchars($_POST["rdiSelectMsg"]) : "";
    $cmd = "cd /www/ansys/xmpp;/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/bin/java send send_user send ". $opf_user. " '". $MSG_HEADER. ",". $ctrlMessage. "' > /dev/null &";
    
    print $cmd;
    exec($cmd);
  }
  
  $conn = pg_connect("
    host     = ". $HOST. "
    dbname   = ". $DB.   "
    user     = ". $USER. "
    password = ". $PASS. "
  ");
  if (!$conn)
    throw new Exception("データベースへの接続に失敗しました");
  
  // 端末とユーザの一覧取得
  $selectTerminal =  "SELECT qgis.ts_terminal.android_id, terminal_name, login_user";
  $selectTerminal .= " FROM qgis.ts_terminal LEFT JOIN qgis.opf_user ON qgis.ts_terminal.android_id = qgis.opf_user.android_id";
  $selectTerminal .= " WHERE qgis.ts_terminal.const_id='". $CONST_ID. "' AND qgis.ts_terminal.app_id='". $APP_ID. "' AND login_user != ''";
  $selectTerminal .= " ORDER BY qgis.ts_terminal.terminal_name;";
  
  if (!($resTerminal = pg_query($conn, $selectTerminal)))
    throw new Exception("ログインユーザ一覧の取得に失敗\n". $resTerminal. "\n". pg_last_error(). "\n");
  $cntTerminal = pg_num_rows($resTerminal);
  
  print "<select name=\"selTerminalInfo\">";
  for($i = 0; $i < $cntTerminal; $i++)
  {
    $rowTerminal = pg_fetch_assoc($resTerminal, $i);
    print "<option value=\"". $rowTerminal["login_user"]. "\">". $rowTerminal["terminal_name"]. "</option>";
  }
  print "</select>";
  print "&nbsp;&nbsp;";
  print "<button type=\"submit\" value=\"送信\" name=\"btnCtrlSend\">送信</button><br>";
  
  print "<p>";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"2\" checked>「IO2」ON";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"6\">「IO2」OFF<br>";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"3\">「IO3」ON";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"7\">「IO3」OFF<br>";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"4\">「IO4」ON";
  print "<input type=\"radio\" name=\"rdiSelectMsg\" value=\"8\">「IO4」OFF<br>";
  print "</p>";
  print "<font color=\"#FF0000\">※IO1は動作確認用の為制御不可</font>";
  print "</form>";
}
catch(Exception $exc)
{
  print "<font color=\"#FF0000\">";
  print "【スクリプトエラー】<br>";
  print $exc->getMessage(). "<br>";
  print "</font>";
}

?>

PHP File Manager