File "index_20130422.php"
Full path: /www/ansys/qgis/003_asahikawa/map/Backup/index_20130422.php
File size: 9.34 KiB (9565 bytes)
MIME-type: text/xml
Charset: utf-8
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Refresh" content="30 ;URL=index.php">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta equiv="expires" content="0">
<title>運行管理システム-旭川-</title>
<meta http-equiv="imagetoolbar" content="no">
<!--ie image gizmo OFF!-->
<style type="text/css">
#map {
width: 952px;
height: 842px;
border: 1px solid black;
}
h1 {
font-family: Utopia,Arial, Helvetica, sans-serif;
font-size: 28px;
line-height: 32px;
color: #005599;
}
#features {
margin-top: 5px;
font-size: small;
}
table, table td, table th {
border: 1px solid #DDD;
border-collapse: collapse;
margin: 0;
text-align: center;
padding: 1px 3px;
}
table th {
background-color: #EEE;
font-weight: bold;
}
.olControlButtonItemActive {
position : absolute;
top : 0px;
right : 0px;
background : red;
width : 16px;
height : 18px;
}
.olControlPanel {
top : 85px;
right : 917px;
width : 16px;
height : 18px;
border : 1px solid black;
}
.Panel1 {
width: 18px;
height: 54px;
cursor: pointer;
right: 10px;
top: 10px;
}
.Panel2 {
width: 18px;
height: 54px;
cursor: pointer;
right: 10px;
top: 74px;
}
.Panel3 {
width: 18px;
height: 54px;
cursor: pointer;
right: 10px;
top: 138px;
}
.firstItemInactive,.secondItemInactive {
background: #30d5c8;
border: 2px solid #075f67;
width: 18px;
height: 18px;
}
.firstItemActive, .secondItemActive {
background: #ffffdd;
border: 2px solid #dddddd;
width: 18px;
height: 18px;
}
.olControlLayerSwitcher .layersDiv {
background-color: #ff0000;
height: 100%;
padding: 5px 75px 5px 10px;
width: 100%;
}
</style>
<?php
//データベース接続
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
") or die("接続エラー". $HOST. "--". $DB. "--". $USER. "--". $PASS. pg_last_error());
$sql = "SELECT * FROM qgis.ts_terminal WHERE app_id='6' AND const_id='2' ORDER BY regdatetime;";
$res = pg_query($conn, $sql) or die (pg_last_error(). "<br>". $sql. "<br />");
$Ct = pg_num_rows($res);
for($iCount = 0; $iCount < $Ct; $iCount++)
{
$row = pg_fetch_array($res, $iCount);
$lat[$iCount] = $row["lat"];
$lon[$iCount] = $row["lon"];
$w_status[$iCount] = $row["work_status"];
$t_name[$iCount] = $row["terminal_name"];
}
$lat_php = join(",", $lat);
$lon_php = join(",", $lon);
$w_status_php = join(",", $w_status);
$t_name_php = join(",", $t_name);
?>
<script src="./OpenLayers.js"></script>
<script type="text/javascript" charset="utf-8">
//<!--
var map;
var chimeiView = 1;
function init()
{
//■PHPで抽出したデータをJavaScript側の変数へ代入⇒カンマ区切りデータを配列に格納
var dct = "<?php echo $Ct; ?>";
var lat_js = "<?php echo $lat_php ?>";
var lon_js = "<?php echo $lon_php ?>";
var ws_js = "<?php echo $w_status_php ?>";
var t_name_js = "<?php echo $t_name_php ?>";
var Lat = lat_js.split(",");
var Lon = lon_js.split(",");
var Ws = ws_js.split(",");
var Tn = t_name_js.split(",");
var lon;
var lat;
var zoom;
var vectorLayer = new Array(dct);
var style = new Array(dct);
var MapFilePath = "/www/ansys/qgis/003_asahikawa/map/wms.map";
var options = {
projection : "EPSG:4326",
scales : [5000,10000,15000,25000,1000000],
minZoomLevel : 1,
numZoomLevels : 5
};
map = new OpenLayers.Map("map", options);
if((GetCookie("lon") == null) || (GetCookie("lon") == 0))
{
lon = 142.380151;
document.cookie = "lon=" + encodeURIComponent(lon);
}
else
{
lon = GetCookie("lon");
}
if((GetCookie("lat") == null) || (GetCookie("lat") == 0))
{
lat = 43.812047;
document.cookie = "lat=" + encodeURIComponent(lat);
}
else
{
lat = GetCookie("lat");
}
if(GetCookie("zoom") == null)
{
zoom = 2;
document.cookie = "zoom=" + encodeURIComponent(zoom);
}
else
{
zoom = GetCookie("zoom");
}
if(GetCookie("chimei_view") == null)
{
chimeiView = 0;
document.cookie = "chimei_view=" + encodeURIComponent(chimeiView);
}
else
{
chimeiView = GetCookie("chimei_view");
}
map.events.register("mousemove", map, onMouseMove);
map.events.register("zoomend", map, onZoom);
map.addControl(new OpenLayers.Control.ScaleLine());
//============================================================
var button = new OpenLayers.Control.Button(
{
displayClass : "olControlButton",
trigger : buttonClicked,
title : "初期位置に戻る"
});
var panel = new OpenLayers.Control.Panel({defaultControl : button});
panel.addControls([button]);
map.addControl (panel);
//============================================================
//============================================================
var panel_type2 = new OpenLayers.Control.Panel(
{displayClass: "Panel2"}
);
map.addControl(panel_type2);
var _aBtn2 = new OpenLayers.Control.Button(
{
displayClass : "first",
type : OpenLayers.Control.TYPE_TOGGLE,
eventListeners : {
"activate" : objActive(chimeiView),
"deactivate" : objInactive(chimeiView)
}
});
panel_type2.addControls([_aBtn2]);
//============================================================
var host = location.protocol + "//" + location.hostname;
if (location.port != "")
host += ":" + location.port;
var chimei = "";
if (chimeiView == 1)
{
chimei = ",c_kamikawa";
}
alert(chimei);
var msLayer = new OpenLayers.Layer.WMS(
"WMSレイヤー",
host + "/cgi-bin/mapserv-i18n?map=" + MapFilePath +"&",
{
layers : "d_kamikawa,t_kamikawa,g_kamikawa,k_kamikawa" + chimei,
transparent : true,
format : "image/gif"
},
{
isBaseLayer : true,
singleTile : true,
opacity : 0.7
}
);
map.addLayer(msLayer);
var renderer = OpenLayers.Util.getParameters(window.location.href).renderer;
renderer = (renderer) ? [renderer] : OpenLayers.Layer.Vector.prototype.renderers;
for(var iCount = 0; iCount < dct; iCount++)
{
setObject(map, Tn[iCount], Lon[iCount], Lat[iCount], Ws[iCount], 35, 10);
}
setObject(map, "TC生コン(株)", 142.421092, 43.821570, -1, 35, 10);
setObject(map, "(株)野田生コン", 142.421092, 43.821570, -1, 35, -10);
setObject(map, "三共宇部生コン(株)", 142.478953, 43.792178, -1, 35, 10);
var map_center = new OpenLayers.Geometry.Point(lon, lat);
map.setCenter(new OpenLayers.LonLat(map_center.x, map_center.y), zoom);
}
function objActive(object_)
{
object_ = 1;
document.cookie = "chimei_view=" + encodeURIComponent(object_);
}
function objInactive()
{
object_ = 0;
document.cookie = "chimei_view=" + encodeURIComponent(object_);
}
function buttonClicked()
{
deleteCookie();
location.reload();
}
function setObject(map_, name_, lon_, lat_, workStatus_, xOffset_, yOffset_)
{
var objStyle = {
fillOpacity : 0.5,
strokeWidth: 1,
pointRadius: 5,
label : name_,
fontSize : 12,
labelXOffset : xOffset_,
labelYOffset : yOffset_
};
var point = new OpenLayers.Geometry.Point(lon_, lat_);
point.transform(
new OpenLayers.Projection("EPSG:4326"),
map_.getProjectionObject()
);
switch(workStatus_)
{
case "0":
objStyle.strokeColor = "red";
objStyle.fillColor = "red";
break;
case "1":
objStyle.strokeColor = "green";
objStyle.fillColor = "green";
break;
case "2":
objStyle.strokeColor = "blue";
objStyle.fillColor = "blue";
break;
case "3":
objStyle.strokeColor = "pink";
objStyle.fillColor = "pink";
break;
default:
objStyle.strokeColor = "black";
objStyle.fillColor = "black";
break;
}
var vectorLayer = new OpenLayers.Layer.Vector(name_, {style : objStyle});
var pointFeature = new OpenLayers.Feature.Vector(point, null, objStyle);
vectorLayer.addFeatures(pointFeature);
map_.addLayer(vectorLayer);
}
function onMouseMove()
{
var lonLat = map.getCenter();
document.cookie = "lon=" + encodeURIComponent(lonLat.lon);
document.cookie = "lat=" + encodeURIComponent(lonLat.lat);
}
function onZoom()
{
var lonLat = map.getCenter();
var ZoomSts = map.getZoom();
document.cookie = "zoom=" + encodeURIComponent(ZoomSts);
document.cookie = "lon=" + encodeURIComponent(lonLat.lon);
document.cookie = "lat=" + encodeURIComponent(lonLat.lat);
}
function deleteCookie()
{
var dTime = new Date();
dTime.setYear(0);
document.cookie = "zoom=" + ";expires=" + dTime.toGMTString();
document.cookie = "lon=" + ";expires=" + dTime.toGMTString();
document.cookie = "lat=" + ";expires=" + dTime.toGMTString();
}
function GetCookie(name)
{
var result = null;
var cookieName = name + '=';
var allcookies = document.cookie;
var position = allcookies.indexOf(cookieName);
if(position != -1)
{
var startIndex = position + cookieName.length;
var endIndex = allcookies.indexOf(';', startIndex);
if(endIndex == -1)
endIndex = allcookies.length;
result = decodeURIComponent(allcookies.substring(startIndex, endIndex));
}
return result;
}
// -->
</script>
</head>
<body onload="init()">
<div id="map" name="map"></div>
</body>
</html>