Study Journals of TYRuan: 2月 2016

2016年2月16日星期二

How to do Redirect in PHP with POST and not GET

https://www.sitepoint.com/community/t/how-to-do-redirect-in-php-with-post-and-not-get/4968

<form name='fr' action='redirect.php' method='POST'>
<input type='hidden' name='var1' value='val1'>
<input type='hidden' name='var2' value='val2'>
</form>
<script type='text/javascript'>
document.fr.submit();
</script>

2016年2月15日星期一

使用PHP,Google MAPS API 呈現客戶地理資訊 example

google_map.html

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="http://code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="http://jqueryui.com/resources/demos/style.css">

<script src="http://maps.googleapis.com/maps/api/js"> </script>

<script>
//var coordinates = [[22.5805149,120.4227832,'大連化學','image3'],[22.5789818,120.3178123,'建榮冷凍食品','image2']];
var offices = {"5310" : [25.055308,121.593377, "台北分公司"],
               "5320" : [24.9545639,121.2026673, "桃園分公司"],
               "5330" : [24.673791, 120.887685, "竹苗分公司"],
               "5340" : [24.181775, 120.617205, "台中分公司"],
               "5350" : [23.041664, 120.234495, "台南分公司"],
               "5360" : [22.595090, 120.359171, "高雄分公司"]
              };
function initialize(locations)
{
   var coordinates = locations;
   var oea15 = document.getElementById("oea15");
   //alert(oea15.value);
   //alert(offices[oea15.value][0] + "," + offices[oea15.value][1]);
   var myCenter=new google.maps.LatLng(offices[oea15.value][0],offices[oea15.value][1]);
   //var myCenter=new google.maps.LatLng(22.595090, 120.359171);
   var mapProp = {
      center:myCenter,
      zoom:13,
      mapTypeId:google.maps.MapTypeId.ROADMAP
   };

   var map=new google.maps.Map(document.getElementById("googleMap"),mapProp);
   map.data.loadGeoJson('./twtown2010.4.json');
   //map.data.loadGeoJson('./twcounty2010.6.json');
   var image1 = {url : "http://labs.google.com/ridefinder/images/mm_20_red.png", size : new google.maps.Size(32, 32)};
   var image2 = {url : "http://labs.google.com/ridefinder/images/mm_20_yellow.png", size : new google.maps.Size(32, 32)};
   var image3 = {url : "http://labs.google.com/ridefinder/images/mm_20_green.png", size : new google.maps.Size(32, 32)};

   var marker=new google.maps.Marker({
       position:myCenter,
       title: offices[oea15.value][2],
      });
    marker.setMap(map);

   var idx;
   for (idx=0; idx<coordinates.length; idx++) {
      //alert(coordinates[idx]["LAT"] + "," + coordinates[idx]["LNG"] + "," + coordinates[idx]["OCC18"] + "," + coordinates[idx]["IMG"]);
      var str = "var marker=new google.maps.Marker({ position:new google.maps.LatLng(" + coordinates[idx]["LAT"] + "," + coordinates[idx]["LNG"] + "), title: '" + coordinates[idx]["OCC18"] + "', icon:" + coordinates[idx]["IMG"] + " }); marker.setMap(map);"
      eval(str);
   }
         //var marker=new google.maps.Marker({
         //    position:new google.maps.LatLng(22.5805149,120.4227832),
         //    title: '大連化學工業股份有限公司',
         //    icon: image3
         //});
         //marker.setMap(map);
}
google.maps.event.addDomListener(window, 'load', initialize);
</script>

<script>
   $(function() {
       $( "#from" ).datepicker({
         defaultDate: "+1w",
         changeMonth: true,
         numberOfMonths: 3,
         onClose: function( selectedDate ) {
           $( "#to" ).datepicker( "option", "minDate", selectedDate );
         }
       });
       $("#from").datepicker("option", "dateFormat", "yy/mm/dd");

       $( "#to" ).datepicker({
         defaultDate: "+1w",
         changeMonth: true,
         numberOfMonths: 3,
         onClose: function( selectedDate ) {
           $( "#from" ).datepicker( "option", "maxDate", selectedDate );
         }
       });
       $("#to").datepicker("option", "dateFormat", "yy/mm/dd");
   });
</script>

<script>
var Submit=function(){
   var URLs="http://10.1.100.201/eip/report/google_map/getDNLatLng.php";

   $.ajax({
       url: URLs,
       data: $('#DNLatLng').serialize(),
       type:"POST",
       dataType:'json',

       success: function(msg){
           //alert(msg);
           initialize(msg)
       },

        error:function(xhr, ajaxOptions, thrownError){
           alert(xhr.status);
           alert(thrownError);
        }
   });

}
</script>

</head>
<body>
<form id="DNLatLng">
   <label for="分公司">分公司</label>
   <select name="oea15" id="oea15">
     <option value="NA" selected="selected">===請選擇===</option>
     <option value="5310">台北分公司</option>
     <option value="5320">桃園分公司</option>
     <option value="5330">竹苗分公司</option>
     <option value="5340">台中分公司</option>
     <option value="5350">台南分公司</option>
     <option value="5360">高雄分公司</option>
   </select>

   <label for="from">送貨日期 From</label>
   <input type="text" id="from" name="from">
   <label for="to"> to</label>
   <input type="text" id="to" name="to">
   <input type=button id=btn1 value=送出 onClick="Submit()"> </input>
</form>
<div id="googleMap" style="width:800;height:900px;"></div>
</body>
</html>

getDNLatLng.php

<?php
$oea15 = $_REQUEST['oea15'];
$oea02b = $_REQUEST['from'];
$oea02e = $_REQUEST['to'];

$dbstr = "(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST=tiptopdb)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = topprod)))";
$dbconn = oci_connect("echo01","echo01","$dbstr","utf8");

$sql = "
select lat,lng,occ18,case when max(交運方式) != min(交運方式) then 'image2' when max(交運方式) = '外車' then 'image1' when max(交運方式) = '其它' then 'image3' end img
from (
        select substr(to_char(oea02,'yyyymm'),1,6) yyyymm,oea15,oea43,ged02,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end 交運方式,
               count(*) 次數,oea04,occ18,occ11,--oeb04,replace(oeb06,',',null) oeb06,
               sum(oeb14*oea24) oeb14,oeb01,
               oeauser,zx02,oeb04,oeb06,oeb12
          from echo01.oea_file a,ged_file b,echo01.occ_file,echo01.oeb_file,echo01.zx_file,ima_file
         where oea43 = b.ged01
           and oea04 = occ01
           and oea01 = oeb01
           and oeaconf = 'Y'
           and a.oeauser = zx01
           and oeb04 = ima01
           and imaud03 is null --冰品
           and regexp_like(oea01,'SO[123789]-')
           and ta_oea04 != '3'
           and oea15 = :oea15
           and oea02 between to_date(:oea02b,'yyyy/mm/dd') and to_date(:oea02e,'yyyy/mm/dd')
         group by substr(to_char(oea02,'yyyymm'),1,6),oea43,ged02,oea15,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end,oea04,occ18,occ11,--oeb04,oeb06,
               oeauser,zx02,oeb01,oeb04,oeb06,oeb12
        having sum(oeb12*ta_ima003/1000) < 200 -- < 200L
         union all
        select substr(to_char(oea02,'yyyymm'),1,6) yyyymm,oea15,oea43,ged02,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end 交運方式,
               count(*) 次數,oea04,occ18,occ11,--oeb04,replace(oeb06,',',null) oeb06,
               sum(oeb14*oea24) oeb14,oeb01,
               oeauser,zx02,oeb04,oeb06,oeb12
          from echo02.oea_file a,ged_file b,echo01.occ_file,echo01.oeb_file,echo01.zx_file,ima_file
         where oea43 = b.ged01
           and oea04 = occ01
           and oea01 = oeb01
           and oeaconf = 'Y'
           and oeb04 = ima01
           and imaud03 is null --冰品
           and regexp_like(oea01,'SO[123789]-')
           and ta_oea04 != '3'
           and oea15 = :oea15
           and oea02 between to_date(:oea02b,'yyyy/mm/dd') and to_date(:oea02e,'yyyy/mm/dd')
         group by substr(to_char(oea02,'yyyymm'),1,6),oea43,ged02,oea15,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end,oea04,occ18,occ11,--oeb04,oeb06,
               oeauser,zx02,oeb01,oeb04,oeb06,oeb12
        having sum(oeb12*ta_ima003/1000) < 200
         union all
        select substr(to_char(oea02,'yyyymm'),1,6) yyyymm,oea15,oea43,ged02,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end 交運方式,
               count(*) 次數,oea04,occ18,occ11,--oeb04,replace(oeb06,',',null) oeb06,
               sum(oeb14*oea24) oeb14,oeb01,
               oeauser,zx02,oeb04,oeb06,oeb12
          from echo03.oea_file a,ged_file b,echo01.occ_file,echo01.oeb_file,echo01.zx_file,ima_file
         where oea43 = b.ged01
           and oea04 = occ01
           and oea01 = oeb01
           and oeaconf = 'Y'
           and oeb04 = ima01
           and imaud03 is null --冰品
           and regexp_like(oea01,'SO[123789]-')
           and ta_oea04 != '3'
           and oea15 = :oea15
           and oea02 between to_date(:oea02b,'yyyy/mm/dd') and to_date(:oea02e,'yyyy/mm/dd')
         group by substr(to_char(oea02,'yyyymm'),1,6),oea43,ged02,oea15,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end,oea04,occ18,occ11,--oeb04,oeb06,
               oeauser,zx02,oeb01,oeb04,oeb06,oeb12
        having sum(oeb12*ta_ima003/1000) < 200
         union all
        select substr(to_char(oea02,'yyyymm'),1,6) yyyymm,oea15,oea43,ged02,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end 交運方式,
               count(*) 次數,oea04,occ18,occ11,--oeb04,replace(oeb06,',',null) oeb06,
               sum(oeb14*oea24) oeb14,oeb01,
               oeauser,zx02,oeb04,oeb06,oeb12
          from echo3a.oea_file a,ged_file b,echo01.occ_file,echo01.oeb_file,echo01.zx_file,ima_file
         where oea43 = b.ged01
           and oea04 = occ01
           and oea01 = oeb01
           and oeaconf = 'Y'
           and oeb04 = ima01
           and imaud03 is null --冰品
           and regexp_like(oea01,'SO[123789]-')
           and ta_oea04 != '3'
           and oea15 = :oea15
           and oea02 between to_date(:oea02b,'yyyy/mm/dd') and to_date(:oea02e,'yyyy/mm/dd')
         group by substr(to_char(oea02,'yyyymm'),1,6),oea43,ged02,oea15,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end,oea04,occ18,occ11,--oeb04,oeb06,
               oeauser,zx02,oeb01,oeb04,oeb06,oeb12
        having sum(oeb12*ta_ima003/1000) < 200
         union all
        select substr(to_char(oea02,'yyyymm'),1,6) yyyymm,oea15,oea43,ged02,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end 交運方式,
               count(*) 次數,oea04,occ18,occ11,--oeb04,replace(oeb06,',',null) oeb06,
               sum(oeb14*oea24) oeb14,oeb01,
               oeauser,zx02,oeb04,oeb06,oeb12
          from echo06.oea_file a,ged_file b,echo01.occ_file,echo01.oeb_file,echo01.zx_file,ima_file
         where oea43 = b.ged01
           and oea04 = occ01
           and oea01 = oeb01
           and oeaconf = 'Y'
           and oeb04 = ima01
           and imaud03 is null --冰品
           and regexp_like(oea01,'SO[123789]-')
           and ta_oea04 != '3'
           and oea15 = :oea15
           and oea02 between to_date(:oea02b,'yyyy/mm/dd') and to_date(:oea02e,'yyyy/mm/dd')
         group by substr(to_char(oea02,'yyyymm'),1,6),oea43,ged02,oea15,
               case when regexp_like(ged02,'大榮|大誠|日通|超峰|黑貓') then '外車' else '其它' end,oea04,occ18,occ11,--oeb04,oeb06,
               oeauser,zx02,oeb01,oeb04,oeb06,oeb12
        having sum(oeb12*ta_ima003/1000) < 200
       ),clq_file
where oea04 = occ01
   and lat is not null
group by occ18,lat,lng
";

$stid = oci_parse($dbconn, $sql);
oci_bind_by_name($stid, ":oea15", $oea15);
oci_bind_by_name($stid, ":oea02b", $oea02b);
oci_bind_by_name($stid, ":oea02e", $oea02e);
oci_execute($stid);

$rows = array();
while($row = oci_fetch_assoc($stid)) {
   $rows[] = $row;
}
$locations =(json_encode($rows));
echo $locations;
?>

2016年2月14日星期日

Ubuntu11.10 使用 k3b 備份有CSS保護的DVD

https://jerry2yang.wordpress.com/2012/02/13/ubuntu11-10-%E4%BD%BF%E7%94%A8-k3b-%E5%82%99%E4%BB%BD%E6%9C%89css%E4%BF%9D%E8%AD%B7%E7%9A%84dvd/

Posted on 2012 年 02 月 13 日

要如何讓 k3b 可以備份有 CSS 保護的 DVD 呢？重點就是在如何安裝「libdvdcss」這個套件的方法了。
安裝「libdvdcss」：
拜訪 Linux Package Search，Search 「libdvdcss」套件，找出符合系統版本的連結並依照說明安裝「libdvdcss-dev」套件。

安裝步驟：

Add the following line to /etc/apt/sources.list:
```
deb http://www.deb-multimedia.org wheezy main
```
Update the package index:
```
# sudo apt-get update
```

Install GPG key of the repository:

# sudo apt-get install deb-multimedia-keyring

Install libdvdcss2 deb package:
```
# sudo apt-get install libdvdcss2
```

操作：
接著就和正常的操作一樣，直接複製媒體。在必要時可能要需要使用「忽略讀取錯誤」進階選項。

2016年2月2日星期二

Google Maps API example

http://www.w3schools.com/googleapi/google_maps_overlays.asp
https://developers.google.com/maps/documentation/javascript/markers?hl=zh-tw
https://developers.google.com/maps/documentation/javascript/symbols?hl=zh-tw

example 1:
<!DOCTYPE html>
<html>
<head>
<script
src="http://maps.googleapis.com/maps/api/js">
</script>

<script>
var myCenter=new google.maps.LatLng(51.508742,-0.120850);

function initialize()
{
var mapProp = {
center:myCenter,
zoom:8,
mapTypeId:google.maps.MapTypeId.ROADMAP
};

var map=new google.maps.Map(document.getElementById("googleMap"),mapProp);

var marker=new google.maps.Marker({
position:new google.maps.LatLng(51.508742,-0.120850),
icon: {
      path: google.maps.SymbolPath.CIRCLE,
      scale: 3
    },
});
marker.setMap(map);
var marker=new google.maps.Marker({
position:new google.maps.LatLng(52,-0.120850),
icon: {
      path: google.maps.SymbolPath.BACKWARD_CLOSED_ARROW,
      scale: 3
    },
});
marker.setMap(map);
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>
</head>

<body>
<div id="googleMap" style="width:500px;height:380px;"></div>
</body>
</html>

example 2:
<!DOCTYPE html>
<html>
<head>
<script
src="http://maps.googleapis.com/maps/api/js">
</script>

<script>
var myCenter=new google.maps.LatLng(25.03174,121.5297);

function initialize()
{
var mapProp = {
center:myCenter,
zoom:13,
mapTypeId:google.maps.MapTypeId.ROADMAP
};

var map=new google.maps.Map(document.getElementById("googleMap"),mapProp);
var image1 = {url : "http://labs.google.com/ridefinder/images/mm_20_yellow.png", size : new google.maps.Size(32, 32)};
var image2 = {url : "http://labs.google.com/ridefinder/images/mm_20_red.png", size : new google.maps.Size(32, 32)};

var marker=new google.maps.Marker({
    position:new google.maps.LatLng(24.9785,121.41),
    icon: image1
   });
marker.setMap(map);

var marker=new google.maps.Marker({
    position:new google.maps.LatLng(24.988,121.412),
    icon: image1
   });
marker.setMap(map);

}

google.maps.event.addDomListener(window, 'load', initialize);
</script>
</head>

<body>
<div id="googleMap" style="width:800;height:900px;"></div>
</body>
</html>

example 3:
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="http://code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="http://jqueryui.com/resources/demos/style.css">
<script
src="http://maps.googleapis.com/maps/api/js">
</script>
<script>
var myCenter=new google.maps.LatLng(22.595090, 120.359171);
var coordinates = [[22.5805149,120.4227832,'大連化學','image3'],[22.5789818,120.3178123,'建榮冷凍食品','image2']];
function initialize()
{
   var mapProp = {
      center:myCenter,
      zoom:13,
      mapTypeId:google.maps.MapTypeId.ROADMAP
   };

   var map=new google.maps.Map(document.getElementById("googleMap"),mapProp);
   var image1 = {url : "http://labs.google.com/ridefinder/images/mm_20_red.png", size : new google.maps.Size(32, 32)};
   var image2 = {url : "http://labs.google.com/ridefinder/images/mm_20_yellow.png", size : new google.maps.Size(32, 32)};
   var image3 = {url : "http://labs.google.com/ridefinder/images/mm_20_green.png", size : new google.maps.Size(32, 32)};

   var idx;
   for (idx=0; idx<coordinates.length; idx++) {
      var str = "var marker=new google.maps.Marker({ position:new google.maps.LatLng(" + coordinates[idx][0] + "," + coordinates[idx][1] + "), title: '" + coordinates[idx][2] + "', icon:" + coordinates[idx][3] + " }); marker.setMap(map);"
      eval(str);
   }
         //var marker=new google.maps.Marker({
         //    position:new google.maps.LatLng(22.5805149,120.4227832),
         //    title: '大連化學工業股份有限公司',
         //    icon: image3
         //});
         //marker.setMap(map);
}
google.maps.event.addDomListener(window, 'load', initialize);
</script>

<script>
$(function() {
    $( "#from" ).datepicker({
      defaultDate: "+1w",
      changeMonth: true,
      numberOfMonths: 3,
      onClose: function( selectedDate ) {
        $( "#to" ).datepicker( "option", "minDate", selectedDate );
      }
    });
    $("#from").datepicker("option", "dateFormat", "yy/mm/dd");

    $( "#to" ).datepicker({
      defaultDate: "+1w",
      changeMonth: true,
      numberOfMonths: 3,
      onClose: function( selectedDate ) {
        $( "#from" ).datepicker( "option", "maxDate", selectedDate );
      }
    });
    $("#to").datepicker("option", "dateFormat", "yy/mm/dd");
});
</script>

</head>
<body>

<label for="分公司">分公司</label>
<input type=text id=txt1> </input>
<label for="from">From</label>
<input type="text" id="from" name="from">
<label for="to">to</label>
<input type="text" id="to" name="to">
<input type=button id=btn1 value=提交> </input>
<div id="googleMap" style="width:800;height:900px;"></div>
</body>
</html>

2016年2月16日 星期二