"; print ""; //print ""; //print ""; print "". $SCRIPT_TITLE. ""; print ""; ?> "; print ""; print ""; print "". $SCRIPT_TITLE. "
"; print ""; print ""; print ""; */ print ""; //=============================================== // HTML-BODY部開始- // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; // =============================================== // 上で保存した画像を表示 // 備考 ： // 更新 ： 2010/09/08 KMK T.Teraoka // =============================================== //POSTデータをチェック if($_POST) { // print_r($_POST); if($ListId) { if($Col != 9999) { $upArea = "UPDATE qgis.area_status_fill_t SET "; $upArea .= "area_name = '" .$AreaName ."',"; $upArea .= "legend_color='" .$Col ."',"; $upArea .= "upddatetime=" ."current_timestamp"; $upArea .= " WHERE list_id =" .$ListId .";"; // print $upArea ."
"; if (!($resData = pg_query($conn, $upArea))) { // print pg_last_error(). "
"; // throw new Exception("データの登録に失敗しました
". $insArea. "
". pg_last_error(). "
"); } } else { $upArea = "UPDATE qgis.area_status_fill_t SET "; $upArea .= "area_name = '" .$AreaName ."',"; $upArea .= "upddatetime=" ."current_timestamp"; $upArea .= " WHERE list_id =" .$ListId .";"; // print $upArea ."
"; if (!($resData = pg_query($conn, $upArea))) { // print pg_last_error(). "
"; // throw new Exception("データの登録に失敗しました
". $insArea. "
". pg_last_error(). "
"); } } $upArea = "UPDATE qgis.hitachinaka_point_t SET "; $upArea .= "area_id = '" .$ListId ."',"; $upArea .= "upddatetime=" ."current_timestamp"; $upArea .= " WHERE pno =" .$FillId .";"; // print $upArea ."
"; if (!($resData = pg_query($conn, $upArea))) { // print pg_last_error(). "
"; // throw new Exception("データの登録に失敗しました
". $insArea. "
". pg_last_error(). "
"); } } else { $upArea = "UPDATE qgis.hitachinaka_point_t SET "; $upArea .= "area_id = null,"; $upArea .= "upddatetime=" ."current_timestamp"; $upArea .= " WHERE pno =" .$FillId .";"; // print $upArea ."
"; if (!($resData = pg_query($conn, $upArea))) { // print pg_last_error(). "
"; // } } //セル描画データをテキストファイルで出力 //////////////////////////////////////////////////////////////////////// $selArea = "SELECT * FROM qgis.hitachinaka_point_t"; $selArea .= " WHERE NOT area_id is null"; $selArea .= " ORDER BY pno"; $selArea .= ";"; // print $selArea ."
"; if (!($resArea = pg_query($conn, $selArea))) { $resArea. "
". pg_last_error(). "
"; //throw new Exception("データ取得に失敗
". $resArea. "
". pg_last_error(). "
"); //print pg_last_error() ; } $rowA = pg_num_rows($resArea); $fp = fopen($AreaFileName, "w"); //エリアのステータス情報のみを取得(凡例用) $selSts0 = "SELECT * FROM qgis.area_status_fill_t"; $selSts0 .= " WHERE const_id='". $CONST_ID. "'"; $selSts0 .= " AND app_id='". $APPLICATION_ID. "'"; $selSts0 .= " AND del_flg = FALSE order by list_id"; $selSts0 .= ";"; if (!($resSts0 = pg_query($conn, $selSts0))) { //print pg_last_error() ; } $rowStsCt = pg_num_rows($resSts0); for($s = 0; $s < $rowStsCt;$s++) { $rowSts0 = pg_fetch_array($resSts0, $s, PGSQL_ASSOC); $OutputData .= $rowSts0['area_name']."," .$rowSts0['legend_color']; if(($rowStsCt-1) != $s) $OutputData .= ","; } $OutputData .= "#"; for($iCount = 0; $iCount < $rowA; $iCount++) { $rowArea = pg_fetch_array($resArea, $iCount, PGSQL_ASSOC); //エリアのステータスを取得 $selSts = "SELECT * FROM qgis.area_status_fill_t"; $selSts .= " WHERE const_id='". $CONST_ID. "'"; $selSts .= " AND app_id='". $APPLICATION_ID. "'"; $selSts .= " AND list_id='". $rowArea['area_id'] ."'"; $selSts .= " AND del_flg = FALSE"; $selSts .= ";"; if (!($resSts = pg_query($conn, $selSts))) { //throw new Exception("データ取得に失敗
". $resArea. "
". pg_last_error(). "
"); //print pg_last_error() ; } $rowSts = pg_fetch_array($resSts, 0, PGSQL_ASSOC); $OutputData .= $rowArea['pno'] ."," .$rowArea['x'] ."," .$rowArea['y'] ."," .$rowSts['legend_color']; if(($rowA-1) != $iCount) $OutputData .= "#"; } fwrite($fp, $OutputData); fclose($fp); //////////////////////////////////////////////////////////////////////////////////////////////////////////// } else { // print "データなし"; } print "
"; print "QGIS"; print ""; $HtSelect = "SELECT * FROM qgis.hitachinaka_point_t order by id;"; if (!($resHt = pg_query($conn, $HtSelect))) { // print pg_last_error() ."
"; // throw new Exception("データ取得に失敗
". $DelArea. "
". pg_last_error(). "
"); } $ba = 0.6; $Csize =12; $row = pg_num_rows($resHt); // print $row ."
"; for($iCount = 0; $iCount < $row; $iCount++) { $rowHt = pg_fetch_array($resHt, $iCount, PGSQL_ASSOC); //print_r($rowHt); //print "
"; if($iCount < 77) { print "\"円形\""; } else if($iCount < 109) { if(($iCount%2) == 1) { print "\"四角\""; } else { print "\"四角\""; } } else if($iCount < 111) { if(($iCount%2) == 1) { print "\"四角\""; } else { print "\"四角\""; } } else if($iCount < 177) { if(($iCount%2) == 1) { print "\"四角\""; } else { print "\"四角\""; } } else if($iCount < 179) { if(($iCount%2) == 1) { print "\"四角\""; } else { print "\"四角\""; } } else { if(($iCount%2) == 1) { print "\"四角\""; } else { print "\"四角\""; } } } print ""; $selArea = "SELECT * FROM qgis.area_status_fill_t"; $selArea .= " order by list_id;"; $selArea .= ";"; if (!($resArea = pg_query($conn, $selArea))) { //throw new Exception("データ取得に失敗
". $resArea. "
". pg_last_error(). "
"); //print pg_last_error() ; } $CountArea = pg_num_rows($resArea); print "
"; print "
"; print "      "; print "エリア名称    設定色
"; for($ii = 0 ;$ii < $CountArea-3;$ii++) { $rowArea = pg_fetch_array($resArea, $ii, PGSQL_ASSOC); if(!$ListId) { $chkd[0] = " checked"; } else { if($ListId == $rowArea['list_id']) $chkd[$ii] = " checked"; } print ""; print "  "; print ""; print ""; print ""; print "  "; print "■"; print "
"; } print "
"; print "
"; print "      "; print "エリア名称    設定色
"; for($ii = 3 ;$ii < $CountArea;$ii++) { $rowArea = pg_fetch_array($resArea, $ii, PGSQL_ASSOC); if(!$ListId) { $chkd[0] = " checked"; } else { if($ListId == $rowArea['list_id']) $chkd[$ii] = " checked"; } print ""; print "  "; print ""; print ""; print ""; print "  "; print "■"; print "
"; } print "
"; print "
"; print "   "; print "色の選択

"; print "設定中の色"; print "                "; print "   "; print "
"; print "■"; print "    "; print "■"; print "    "; print "■"; print "    "; print "■"; print "
"; print "■"; print "    "; print "■"; print "    "; print "■"; print "    "; print "■"; print "
"; print "■"; print "    "; print "■"; print "    "; print "■"; print "    "; print "■"; print "
"; print ""; print "
"; print "
"; // 戻る //print "
"; //print "戻る"; //=============================================== // HTML終了処理 // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; ?>