Ging_knowledge_sharing: ทำ Form แสดงข้อมูลสถานีโทรมาตร

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script language="JavaScript" src="calendars/calendar2.js"></script>
<script language="javascript">
function check()
{
//alert(document.getElementById('sel_station').value);
var data1 =document.getElementById('sel_station');
var dlist =data1;
/*if(data2 == ""){
var dlist == data1;
} else {
var dlist == data2;
}*/
//dlist.value =="<?//$_POST['sel_station']?>";
//alert(data1.value);
if(dlist.value =="TU01" || dlist.value =="TU05" ||dlist.value =="TU06" || dlist.value =="TU08" || dlist.value =="TU09" || dlist.value =="TU10" || dlist.value =="TD05" || dlist.value =="TD07" )
{
document.getElementById('mywater').style.visibility= 'hidden';
document.getElementById('myrain').style.visibility= 'visible';
//document.getElementById('w_rain').checked='true';
//document.getElementById('w_level').checked='';
}else if(dlist.value =="TD01") {
document.getElementById('myrain').style.visibility= 'hidden';
document.getElementById('mywater').style.visibility= 'visible';
//document.getElementById('w_level').checked='true';
//document.getElementById('w_rain').checked='';
}else{
document.getElementById('mywater').style.visibility= 'visible';
document.getElementById('myrain').style.visibility= 'visible';
//document.getElementById('w_level').checked='true';
//document.getElementById('w_rain').checked='';
//alert(document.getElementById('sel_station').value)
}
//alert(diskt1);
}
function MM_showHideLayers() { //v9.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3)
with (document) if (getElementById && ((obj=getElementById(args[i]))!=null)) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
</script>

</head>

<body onload="check();">
เลือกข้อมูล
<form id="tstest" name="tstest" method="POST" action="">
<table border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">

<tr>
<td>เลือกสถานี
<label>
<select name="sel_station" id="sel_station" onchange="check();">
<option value="TU01" <?php if (!(strcmp("TU01", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU01 อ.ทุ่งช้าง (N.13B) </option>
<option value="TU02" <?php if (!(strcmp("TU02", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU02 อ.ท่าวังผา (N.64) </option>
<option value="TU03" <?php if (!(strcmp("TU03", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU03 อ.เมืองน่าน (N.1) </option>
<option value="TU04" <?php if (!(strcmp("TU04", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU04 อ.เวียงสา(N.13B) น้ำน่าน</option>
<option value="TU05" <?php if (!(strcmp("TU05", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU05 อ.บ่อเกลือ</option>
<option value="TU06" <?php if (!(strcmp("TU06", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU06 อ.แม่จริม</option>
<option value="TU07" <?php if (!(strcmp("TU07", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU07 อ.เวียงสา (N.75) น้ำว้า</option>
<option value="TU08" <?php if (!(strcmp("TU08", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU08 อ.นาน้อย</option>
<option value="TU09" <?php if (!(strcmp("TU09", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU09 อ.นาหมื่น</option>
<option value="TU10" <?php if (!(strcmp("TU10", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TU10 เหนือเขื่อนสิริกิติ์</option>
<option value="TD01" <?php if (!(strcmp("TD01", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD01 ท้ายเขื่อนสิริกิติ์ </option>
<option value="TD02" <?php if (!(strcmp("TD02", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD02 การประปาผาจุก</option>
<option value="TD03" <?php if (!(strcmp("TD03", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD03 กระชังปลาบ้านวังกระพี้</option>
<option value="TD04" <?php if (!(strcmp("TD04", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD04 อ.ตรอน (N.60) </option>
<option value="TD05" <?php if (!(strcmp("TD05", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD05 อ.ฟากท่า (N.39) </option>
<option value="TD06" <?php if (!(strcmp("TD06", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD06 อ.น้ำปาด (N.33)</option>
<option value="TD07" <?php if (!(strcmp("TD07", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD07 คลองตรอน (N.28B) </option>
<option value="TD08" <?php if (!(strcmp("TD08", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD08 อ.ทองแสนขัน (N.72) </option>
<option value="TD09" <?php if (!(strcmp("TD09", $_POST['sel_station']))) {echo "selected=\"selected\"";} ?>>TD09 อ.วัดโบสถ์(N.40)</option>
</select>
</label></td>
<td>
<div align="center">
<span id="myrain">    
<input <?php if (!(strcmp($_POST['w_level'],"rain"))) {echo "checked=\"checked\"";} ?> type="radio" name="w_level" id="w_level" value="rain" checked="checked" />
น้ำฝน </span>
<span style="visibility:hidden" id="mywater">
 
<input <?php if (!(strcmp($_POST['w_level'],"water"))) {echo "checked=\"checked\"";} ?> type="radio" name="w_level" id="w_level" value="water" />
ระดับน้ำ/ปริมาณน้ำ 
</span>
</div>
</td>
</tr>
<tr>
<td valign="top">แสดง
<select name="sel_inteval" id="sel_inteval">
<option value="15" selected="selected" <?php if (!(strcmp(15, $_POST['sel_inteval']))) {echo "selected=\"selected\"";} ?>>15 นาที</option>
<option value="30" <?php if (!(strcmp(30, $_POST['sel_inteval']))) {echo "selected=\"selected\"";} ?>>30 นาที</option>
<option value="60" <?php if (!(strcmp(60, $_POST['sel_inteval']))) {echo "selected=\"selected\"";} ?>>1 ชั่วโมง</option>
</select>
<label></label></td>
<td valign="top"> แสดงย้อนหลัง
<input <?php if (!(strcmp($_POST['sel_m'],"1m"))) {echo "checked=\"checked\"";} ?> type="radio" name="sel_m" id="sel_m" value="1m" checked="checked" />
1 เดือน
<input <?php if (!(strcmp($_POST['sel_m'],"2m"))) {echo "checked=\"checked\"";} ?> type="radio" name="sel_m" id="sel_m" value="2m" />
2 เดือน
<input <?php if (!(strcmp($_POST['sel_m'],"3m"))) {echo "checked=\"checked\"";} ?> type="radio" name="sel_m" id="sel_m" value="3m" />
3 เดือน
<label></label>
<input name="cm" type="button" id="cm" onclick="MM_showHideLayers('c_date','','show')" value="กำหนดเอง" /></td>
</tr>
<tr id="c_date" style="visibility:hidden">
<td colspan="2"><div align="center">วันเริ่มต้น :
<input type="Text" name="input5">
<a href="javascript:cal5.popup();"><img src="images/tigracal.gif" width="16" height="16" border="0"></a>ถึง
<input type="Text" name="input6">
<a href="javascript:cal6.popup();"><img src=images/tigracal.gif width="16" height="16" border="0" alt="Click Here to Pick up the date"></a></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="button5" id="button5" value="แสดงข้อมูล" />
</div></td>
</tr>
</table>
</form>
<script language="JavaScript">

</script>
<div align="center" id="mytest" style="visibility:none"><?php echo $_POST['sel_station']."//".$_POST['w_level']."//".$_POST['w_rain']."//".$_POST['sel_inteval']."//".$_POST['sel_m']."//".$_POST['input5']."//". $_POST['input6']?><br />
<?php
if($_POST['sel_station'] !=""){

if($_POST['sel_station']=="TU01"){
$id = 1;
}elseif($_POST['sel_station']=="TU02" && $_POST['w_level']=="water") {
$id = 7;
}elseif ($_POST['sel_station']=="TU02" && $_POST['w_level']=="rain"){
$id = 8;
}elseif($_POST['sel_station']=="TU03" && $_POST['w_level']=="water") {
$id = 9;
}elseif ($_POST['sel_station']=="TU03" && $_POST['w_level']=="rain") {
$id = 10;
}elseif($_POST['sel_station']=="TU04" && $_POST['w_level']=="water") {
$id = 11;
}elseif ($_POST['sel_station']=="TU04" && $_POST['w_level']=="rain") {
$id = 12;
}elseif($_POST['sel_station']=="TU05") {
$id = 13;
}elseif($_POST['sel_station']=="TU06") {
$id = 14;
}elseif ($_POST['sel_station']=="TU07" && $_POST['w_level']=="water") {
$id = 15;
}elseif ($_POST['sel_station']=="TU07" && $_POST['w_level']=="rain") {
$id = 16;
}elseif($_POST['sel_station']=="TU08") {
$id = 17;
}elseif($_POST['sel_station']=="TU09") {
$id = 18;
}elseif($_POST['sel_station']=="TU10") {
$id = 19;
}elseif($_POST['sel_station']=="TD01") {
$id = 20;
}elseif ($_POST['sel_station']=="TD02" && $_POST['w_level']=="water") {
$id = 21;
}elseif ($_POST['sel_station']=="TD02" && $_POST['w_level']=="rain") {
$id = 22;
}elseif ($_POST['sel_station']=="TD03" && $_POST['w_level']=="water") {
$id = 23;
}elseif ($_POST['sel_station']=="TD03" && $_POST['w_level']=="rain") {
$id = 24;
}elseif ($_POST['sel_station']=="TD04" && $_POST['w_level']=="water") {
$id = 25;
}elseif ($_POST['sel_station']=="TD04" && $_POST['w_level']=="rain") {
$id = 26;
}elseif($_POST['sel_station']=="TD05") {
$id = 27;
}elseif ($_POST['sel_station']=="TD06" && $_POST['w_level']=="water") {
$id = 28;
}elseif ($_POST['sel_station']=="TD06" && $_POST['w_level']=="rain") {
$id = 29;
}elseif($_POST['sel_station']=="TD07") {
$id = 30;
}elseif ($_POST['sel_station']=="TD08" && $_POST['w_level']=="water") {
$id = 31;
}elseif ($_POST['sel_station']=="TD08" && $_POST['w_level']=="rain") {
$id = 32;
}elseif ($_POST['sel_station']=="TD09" && $_POST['w_level']=="water"){
$id = 33;
}else{
$id = 34;
}

if($_POST['sel_inteval'] ==15){
$set_in = "";
}elseif($_POST['sel_inteval'] ==30){
$set_in = "GROUP BY DATE(rawdata_t.TimeTag_DT), HOUR(rawdata_t.TimeTag_DT)";
}else{
$set_in = "GROUP BY DATE(rawdata_t.TimeTag_DT), HOUR(rawdata_t.TimeTag_DT), FLOOR(MINUTE(rawdata_t.TimeTag_DT)/30)";
}

if($_POST['input5'] ==""){
$s_date = "BETWEEN DATE_ADD(curdate(), interval -30".$_POST['sel_inteval']." DAY) AND CURDATE() ";
}else {
$s_date = 'BETWEEN "'.$_POST['input5'].'" AND "'.$_POST['input6'].'"';// -------------> แสดง "2011-01-01" AND "2011-02-10"

}
}else{
echo "เลือกข้อมูล !!!!";
}
?>

sql =

SELECT rawdata_t.TimeTag_DT, rawdata_t.Device_ID, rawdata_t.Reading_FL FROM rawdata_t WHERE rawdata_t.Device_ID = 7 <u><?php echo $id ?></u> AND DATE_FORMAT(rawdata_t.TimeTag_DT, '%Y-%m-%d') <u> <?php echo $s_date ;?></u> GROUP BY DATE(rawdata_t.TimeTag_DT), HOUR(rawdata_t.TimeTag_DT) <u> <?php echo $set_in; ?></u> ORDER BY rawdata_t.TimeTag_DT DESC";<br />
<br />
</div>
</body>
</html>

Ging_knowledge_sharing

วันพฤหัสบดีที่ 22 กันยายน พ.ศ. 2554

ทำ Form แสดงข้อมูลสถานีโทรมาตร

ไม่มีความคิดเห็น:

แสดงความคิดเห็น