{"id":4293,"date":"2014-03-24T16:19:11","date_gmt":"2014-03-24T07:19:11","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=4293"},"modified":"2014-03-24T16:19:11","modified_gmt":"2014-03-24T07:19:11","slug":"google-apps-script%e3%82%b5%e3%82%a4%e3%83%89%e3%83%90%e3%83%bc%e3%81%8b%e3%82%89%e7%94%bb%e5%83%8f%e3%82%92%e3%83%89%e3%82%ad%e3%83%a5%e3%83%a1%e3%83%b3%e3%83%88%e3%81%ab%e6%8c%bf%e5%85%a5%e3%81%99-2","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=4293","title":{"rendered":"[Google Apps Script]\u30b5\u30a4\u30c9\u30d0\u30fc\u304b\u3089\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b(\u6587\u66f8)"},"content":{"rendered":"

\u300c[Google Apps Script]\u30b5\u30a4\u30c9\u30d0\u30fc\u304b\u3089\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b(\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8)<\/a>\u300d\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u753b\u50cf\u3092\u633f\u5165\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u6587\u66f8\u306e\u5834\u5408\u306e\u51e6\u7406\u3092\u8003\u3048\u3066\u307f\u307e\u3059\u3002<\/p>\n

\u30fb\u30b3\u30fc\u30c9.gs<\/strong><\/p>\n

var ui = DocumentApp.getUi();\r\nvar html = HtmlService.createHtmlOutputFromFile('Pixabay').setTitle('Pixabay\u304b\u3089\u753b\u50cf\u3092\u633f\u5165').setWidth(300);\r\n\r\nfunction onOpen(e){\r\n    ui.showSidebar(html);\r\n}\r\n\r\nfunction searchPixabayPhoto(txt){\r\n    var content = '';\r\n    var user = ''; \/\/Pixabay\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u3053\u3053\u306b\u5165\u529b\r\n    var key = ''; \/\/Pixabay\u306eAPI\u30ad\u30fc\u3092\u3053\u3053\u306b\u5165\u529b\r\n    var url = 'http:\/\/pixabay.com\/api\/?username=' + user + '&key=' + key + '&lang=ja&image_type=all&orientation=all&order=popular&search_term=' + encodeURIComponent(txt);\r\n    var res = UrlFetchApp.fetch(url);\r\n    var data = JSON.parse(res.getContentText());\r\n    if(parseFloat(data.totalHits) < 1){\r\n        content = '<h3>\u5199\u771f\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/h3>';\r\n    }else{\r\n        content = '<ol>';\r\n        data.hits.forEach(function(item){\r\n            content += '<li><img src="' + item.previewURL + '" alt="' + item.webformatURL + '" title="\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u753b\u50cf\u3092\u633f\u5165\u3057\u307e\u3059\u3002"><ul><li><a href="' + item.pageURL + '" target="_blank" title="\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u5199\u771f\u306e\u30da\u30fc\u30b8\u3092\u958b\u304d\u307e\u3059\u3002">PageURL<\/a><\/li><\/ul><\/li>';\r\n        });\r\n        content += '<\/ol>';\r\n    }\r\n    html.append(content);\r\n    ui.showSidebar(html); \/\/\u30b5\u30a4\u30c9\u30d0\u30fc\u518d\u63cf\u753b\r\n}\r\n\r\nfunction insertPixabayPhoto(url){\r\n    var dat = UrlFetchApp.fetch(url);\r\n    DocumentApp.getActiveDocument().getBody().insertImage(0, dat.getBlob());\r\n}<\/pre>\n
\u30fbPixabay.html<\/strong><\/p>\n
<html>\r\n    <head>\r\n        <meta charset="UTF-8">\r\n        <link rel="stylesheet" href="https:\/\/ssl.gstatic.com\/docs\/script\/css\/add-ons.css">\r\n        <style>\r\n            #main{padding:20px;}\r\n            img:hover{cursor:pointer;}\r\n        <\/style>\r\n        <script src="\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.11.0\/jquery.min.js"><\/script>\r\n        <script>\r\n            $(function(){\r\n                $("#q").keypress(function(e){\r\n                    switch(e.which){\r\n                        case 13: \/\/Enter\u30ad\u30fc\u5165\u529b\u6642\u306e\u51e6\u7406\r\n                            google.script.run.searchPixabayPhoto($(this).val());\r\n                            break;\r\n                    }\r\n                });\r\n                \r\n                $("img").click(function(){\r\n                    google.script.run.insertPixabayPhoto($(this).attr("alt"));\r\n                });\r\n            });\r\n        <\/script>\r\n    <\/head>\r\n    <body>\r\n        <div id="main">\r\n            <input id="q" type="text" title="\u30ad\u30fc\u30ef\u30fc\u30c9\u5165\u529b\u5f8cEnter\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002">\r\n        <\/div>\r\n    <\/body>\r\n<\/html><\/pre>\n
\"GoogleAppsScript_08_01\"<\/a><\/p>\n
\u300c[Google Apps Script]\u30b5\u30a4\u30c9\u30d0\u30fc\u304b\u3089\u753b\u50cf\u3092\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u633f\u5165\u3059\u308b(\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8)<\/a>\u300d\u306e\u30b3\u30fc\u30c9\u3068\u306e\u9055\u3044\u306f\u753b\u50cf\u633f\u5165\u90e8\u5206\u3060\u3051\u3067\u305d\u306e\u4ed6\u306f\u307b\u3068\u3093\u3069\u540c\u3058\u3067\u3059\u3002<\/p>\n