charlie0228
charlie0228
/ visa.html
Created
December 5, 2016 11:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html> | |
| <head> | |
| <meta http-equiv="content-type" content="text/html; charset=UTF-8"> | |
| <title>Visa Check</title> | |
| <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> | |
| <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script> | |
| <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css"> | |
| <script type="text/javascript" src="googlesheet-json.js"></script> | |
| <script type="text/javascript"> | |
| function setupVisaAutocomplete(visa_data) { |
charlie0228
/ googlesheet-json.js
Created
December 5, 2016 11:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function googlesheet_json(json_link , _filter, callbackFunction) { | |
| // 本函數為GOOGLE JSON修改，可以無視GOOGLESHEET使用JSON抓取資料需要知道第一列(ROW)內容的要求 | |
| // 利用 https://spreadsheets.google.com/feeds/worksheets/YOUR_SPREADSHEET_ID/private/full 找出我們要抓起連結的工作表的真實ID (可能不是od6) | |
| // JSON link: https://spreadsheets.google.com/feeds/list/YOUR_SPREADSHEET_ID/YOUR_WORKSSHEET_ID/public/full?alt=json | |
| if (!json_link) | |
| return alert("無JSON網址"); | |
| if (_filter) | |
| json_link = json_link + "&q=" + _filter; | |
| jQuery.support.cors = true; | |
| $.ajax({ |