{"id":695,"date":"2020-04-25T10:02:27","date_gmt":"2020-04-25T01:02:27","guid":{"rendered":"http:\/\/sensor.krict.re.kr\/?p=695"},"modified":"2020-06-15T21:11:38","modified_gmt":"2020-06-15T12:11:38","slug":"plot-sensor-db","status":"publish","type":"post","link":"https:\/\/www.gassensor.kr\/?p=695","title":{"rendered":"Plot Sensor DB (NO2: Google Drive DB)"},"content":{"rendered":"<p><span id=\"filelist\"><\/span> <button id=\"plot_graph\">\ub370\uc774\ud130\uadf8\ub9ac\uae30<\/button><br \/>\n<span id=\"filename\"><\/span><\/p>\n<div id=\"output_graph\"><\/div>\n<p><script src=\"https:\/\/cdn.plot.ly\/plotly-latest.min.js\"><\/script><br \/>\n<script>\njQuery(document).ready(function(){\n  jQuery.post(ajaxurl, {\n    action: 'ajax_action',\n    url: 'https:\/\/script.google.com\/a\/korea.ac.kr\/macros\/s\/AKfycbxXUtWUBcZtAkwQpFILfTTqpHWm3p-SlNLB_wTX0A\/exec',\n    param: 'folderid=1JyigACDb-4cZp0PAiT9yMhkkGgthJEkb'\n  }, function(data) {\n    var res_contents_json = JSON.parse(data);\n    jQuery(\"#filelist\").html(selectJsonMenu(res_contents_json.files,\"txtfilelist\",0));\n    jQuery(\"#plot_graph\").click(function(){\n       jQuery.post(ajaxurl, {\n         action: 'ajax_action',\n         url: 'https:\/\/script.google.com\/a\/korea.ac.kr\/macros\/s\/AKfycbxXUtWUBcZtAkwQpFILfTTqpHWm3p-SlNLB_wTX0A\/exec',\n         param: 'fid=' + jQuery(\"#txtfilelist option:selected\").val()\n       }, function(res) {\n         var res_json = JSON.parse(res);\n         var data_arr = transpose(res_json.data);\n         jQuery(\"#filename\").html('\ud30c\uc77c\uba85: '.concat(res_json.filename));\n         var trace1  = {\n           x: data_arr[0],\n           y: data_arr[2],\n           mode: 'markers',\n           type: 'scatter'\n         };\n         var data = [trace1];\n         Plotly.newPlot('output_graph', data);\n       });\n    });\n  });  \n});\nfunction transpose(matrix) {\n  const rows = matrix.length, cols = matrix[0].length;\n  const grid = [];\n  for (let j = 0; j < cols; j++) {\n    grid[j] = Array(rows);\n  }\n  for (let i = 0; i < rows; i++) {\n    for (let j = 0; j < cols; j++) {\n      grid[j][i] = matrix[i][j];\n    }\n  }\n  return grid;\n}\n\/\/ json \ubc30\uc5f4, selectbox\uc758 id, \ucd08\uae30 \uc778\ub371\uc2a4 \uac12\uc73c\ub85c\ubd80\ud130 \uba54\ub274\uad6c\uc131\nfunction selectJsonMenu(json_array,id,init_index){\n  var menu = '<select id=\"' + id + '\">';\n  for (var i = 0; i < json_array.length; i++) {\n    if (i == init_index) {\n      menu += '<option value=\"' + json_array[i].id + '\" selected>' + json_array[i].name + '<\/option>';\n    } else {\n      menu += '<option value=\"' + json_array[i].id + '\">' + json_array[i].name + '<\/option>';\n    }\n  }\n  menu += '<\/select>';\n  return menu;\n}\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p> [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"post-templates\/post_nosidebar.php","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"inline_featured_image":false},"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/posts\/695"}],"collection":[{"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=695"}],"version-history":[{"count":22,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/posts\/695\/revisions"}],"predecessor-version":[{"id":1111,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=\/wp\/v2\/posts\/695\/revisions\/1111"}],"wp:attachment":[{"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gassensor.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}