-
Notifications
You must be signed in to change notification settings - Fork 57
/
Copy pathsqlquery.html
48 lines (42 loc) · 3.1 KB
/
sqlquery.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<!DOCTYPE html><html><head><meta charset='utf-8'><meta http-equiv='Access-Control-Allow-Origin' content='*'><meta http-equiv='Access-Control-Allow-Credentials' content='true'><script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script><script src='https://fustyles.github.io/webduino/SpBlocklyJS/GameElements_20190131/gameelements.js'></script><script src='https://fustyles.github.io/webduino/SpBlocklyJS/SpreadsheetSQL_20210403/spreadsheetsql.js'></script><script src='https://fustyles.github.io/webduino/SpBlocklyJS/SpreadsheetSQL_20210403/loader.js'></script></head><body><script>const delay=(seconds)=>{return new Promise((resolve)=>{setTimeout(resolve,seconds*1000);});};const main=async()=>{
var _E8_A1_A8_E6_A0_BC_E4_BB_A3_E7_A2_BC, _E8_A1_A8_E6_A0_BC_E9_9D_A0_E5_B7_A6_E8_B7_9D_E9_9B_A2, _E8_A1_A8_E6_A0_BC_E9_9D_A0_E4_B8_8A_E8_B7_9D_E9_9B_A2;
function spreadsheetsql_QueryResponse_source(res) {
spreadsheetsql_QueryResponse(res, "source");
}
window.spreadsheetsql_QueryResponse_source = spreadsheetsql_QueryResponse_source;
function spreadsheetsql_QueryResponse_query(res) {
spreadsheetsql_QueryResponse(res, "query");
}
window.spreadsheetsql_QueryResponse_query = spreadsheetsql_QueryResponse_query;
_E8_A1_A8_E6_A0_BC_E4_BB_A3_E7_A2_BC = '';
_E8_A1_A8_E6_A0_BC_E9_9D_A0_E5_B7_A6_E8_B7_9D_E9_9B_A2 = 0;
_E8_A1_A8_E6_A0_BC_E9_9D_A0_E4_B8_8A_E8_B7_9D_E9_9B_A2 = 0;
span_create('id',30,30,20,'試算表ID：',999);
span_create('sheet',30,80,20,'工作表名稱：',999);
text_create('id',400,30,150,30,'#ffffff','#000000',14,1,'1xeTHqIrT4Buj1XxpXfUlwdmmqGSBgI3x4QXlo5JT4Po',999,true);
text_create('sheet',200,30,150,80,'#ffffff','#000000',14,1,'SQL',999,true);
button_create('source',60,35,380,80,1,null,'載入',20,999,true);
async function gamebutton_source_onclick (event) {
spreadsheetsql_settings((text_get('id',"value")),(text_get('sheet',"value")), "source");
spreadsheetsql_clearDataTable('source');
spreadsheetsql_executeSql('select *', "source");
};
document.getElementById("gamebutton_source").addEventListener("click", gamebutton_source_onclick, true);
spreadsheetsql_getDataFinish_source = function(head_response, response) {
spreadsheetsql_getDataTable('source',600,14,30,150,true,"source");
};
span_create('',660,30,20,'SQL語法：',999);
textarea_create('query',660,80,80,3,'select *',1,999,true);
textarea_set('query',"draggable",false);
a_create('',60,30,800,30,"none",1,'#000000','#ffffff','#000000',20,1,'教學','https://developers.google.com/chart/interactive/docs/querylanguage',"_blank",999,true);
button_create('query',60,40,1200,30,1,null,'查詢',20,999,true);
async function gamebutton_query_onclick (event) {
spreadsheetsql_settings((text_get('id',"value")),(text_get('sheet',"value")), "query");
spreadsheetsql_clearDataTable('query');
spreadsheetsql_executeSql((textarea_get('query',"value")), "query");
};
document.getElementById("gamebutton_query").addEventListener("click", gamebutton_query_onclick, true);
spreadsheetsql_getDataFinish_query = function(head_response, response) {
spreadsheetsql_getDataTable('query',600,14,660,150,true,"query");
};
};main();</script></body></html>