{"id":388,"date":"2013-10-13T12:26:18","date_gmt":"2013-10-13T03:26:18","guid":{"rendered":"http:\/\/www.sambuichi.jp\/?p=388"},"modified":"2014-07-25T10:25:34","modified_gmt":"2014-07-25T01:25:34","slug":"xbrl-gl%e9%96%b2%e8%a6%a7%e3%82%b5%e3%83%bc%e3%83%93%e3%82%b9%e8%a9%a6%e4%bd%9c33","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=388","title":{"rendered":"XBRL GL\u95b2\u89a7\u30b5\u30fc\u30d3\u30b9[\u8a66\u4f5c](3\/3)"},"content":{"rendered":"

Views: 123<\/p>

\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u305fXBRL GL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6587\u66f8\u8868\u793a<\/h1>\n

\u6b21\u306e3\u6bb5\u968e\u306e\u51e6\u7406\u3067\u3059\u3002
\n\uff08\uff11\uff09javascript\u304b\u3089jQuery\u306eajax\u3067\u3001\u671f\u9593\u304a\u3088\u3073\u79d1\u76ee\u3092\u6307\u5b9a\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u306ePHP\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002
\n\uff08\uff12\uff09PHP\u3067\u306f\u3001\u6307\u5b9a\u3055\u308c\u305f\u671f\u9593\u304a\u3088\u3073\u79d1\u76ee\u3092\u6761\u4ef6\u3068\u3059\u308bSQL\u6587\u3092\u7d44\u307f\u7acb\u3066\u3066\u691c\u7d22\u3092\u5b9f\u884c\u3057\u3001\u8fd4\u3055\u308c\u305f\u7d50\u679c\u304b\u3089<table>\u3092\u4f5c\u6210\u3057\u3001\u30d6\u30e9\u30a6\u30b6\u30fc\u306b\u8fd4\u3057\u307e\u3059\u3002
\n\uff08\uff13\uff09\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u306f\u3001\u5e30\u3063\u3066\u304d\u305f<table>\u3092\u30da\u30fc\u30b8\u306b\u914d\u7f6e\u3059\u308b\u3053\u3068\u3067\u7d50\u679c\u3092\u8868\u793a\u3057\u307e\u3059\u3002
\n<\/p>\n

jQuery\u304b\u3089ajax\u3067PHP\u8d77\u52d5<\/h2>\n

\u671f\u9593\u304a\u3088\u3073\u79d1\u76ee\u3092\u6307\u5b9a\u3059\u308b<select>\u306a\u3089\u3073\u306bid=”jQbutton”\u3067\u691c\u7d22\u3092\u6307\u793a\u3059\u308b<button>\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u307e\u3059\u3002
\n\u4e0a\u8a18\u30b9\u30c6\u30c3\u30d7(3)\u306e\u691c\u7d22\u7d50\u679c\u306f\u3001id=”jQajax”\u306e<div>\u306b\u5c55\u958b\u3055\u308c\u307e\u3059\u3002<\/p>\n

[html]<\/span><\/p>\n

\n
<div id=\"jQ\">\r\n        <select name=\"period\" id=\"period\">\r\n                <option value=\"\" style=\"font-size: x-large\">Select period ...<\/option>\r\n                <option value=\"2009-04\" style=\"font-size: x-large\">2009-04<\/option>\r\n                  \u2026 \u7701\u7565 \u2026\r\n        <\/select>\r\n        <select name=\"account\" id=\"account\"\u3000style=\"font-size: x-large\">\r\n                <option value=\"\">Select account ...<\/option>\r\n                <option value=\"111\">\u73fe\u91d1<\/option>\r\n                  \u2026 \u7701\u7565 \u2026\r\n        <\/select>\r\n    <button id=\"jQbutton\"\u3000style=\"font-size: x-large\">\u691c\u7d22<\/button>\r\n    <p>\r\n        <span id=\"jQtextStatus\"><\/span>\r\n    <\/p>\r\n    <div id=\"jQajax\"><\/div>\r\n<\/div><\/code><\/pre>\n<\/div>\n
javascript\u3067\u306f\u3001$(‘#jQbutton’).on(“click”, function() {\u3000…\u3000\u306e\u7b87\u6240\u3067\u30dc\u30bf\u30f3\u62bc\u4e0b\u6642\u306e\u51e6\u7406\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u307e\u3059\u3002
\n<select>\u304b\u3089\u6307\u5b9a\u3055\u308c\u305f\u5024\u3092$period\u3068$account\u306b\u8a2d\u5b9a\u3057\u3066\u3001ajax\u3092\u4f7f\u3044PHP\u95a2\u6570glList.php\u3092\u547c\u3073\u51fa\u3057\u307e\u3059\u3002
\nPHP\u3067\u7d44\u307f\u7acb\u3066\u305f\u7d50\u679c\u30c6\u30fc\u30d6\u30eb\u3092\u3000 $(‘#jQajax’).html(data);\u3000\u3067\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
[javascript]<\/span><\/p>\n
\n
<script>\r\n    $(function() {\r\n        $('#jQbutton').on(\"click\",\r\n                function() {\r\n                    $periodList = $(\"select#period\");\r\n                    $period = $(\"option:selected\", $periodList).val();\r\n                    $accountList = $(\"select#account\");\r\n                    $account = $(\"option:selected\", $accountList).val();\r\n                    $.ajax({\r\n                        url : 'glList.php',\r\n                        data : {\r\n                            period : $period,\r\n                            account : $account\r\n                        },\r\n                        success : function(data) {\r\n                            $('#jQajax').html(data);\r\n                        },\r\n                        error : function(data) {\r\n                            $('#jQtextStatus').text('\u30a8\u30e9\u30fc\uff01');\r\n                        }\r\n                    });\r\n                }\r\n        );\r\n    });\r\n<\/script><\/code><\/pre>\n<\/div>\n
\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u305f\u691c\u7d22\u3068\u305d\u306e\u7d50\u679c\u8868\u793a<\/h2>\n
[php]SQL\u5b9a\u7fa9\u3068\u691c\u7d22\u5b9f\u884c<\/span><\/p>\n
\n
$sql = \"SELECT postingdate,entrynumber,detailcomment,\";\r\n    $sql .= \"CASE debitcreditcode WHEN 'debit' \";\r\n    $sql .= \"THEN accountmaindescription ELSE '' END AS account_d, \";\r\n    $sql .= \"CASE debitcreditcode WHEN 'credit' \";\r\n    $sql .= \"THEN accountmaindescription ELSE '' END AS account_c,\";\r\n    $sql .= \"CASE debitcreditcode WHEN 'debit' \";\r\n    $sql .= \"THEN amount ELSE '' END AS debit,\";\r\n    $sql .= \"CASE debitcreditcode WHEN 'credit' \";\r\n    $sql .= \"THEN amount ELSE '' END AS credit \";\r\n    $sql .= \"FROM entryheaders h, entrydetails d \";\r\n    $sql .= \"WHERE \";\r\n    $sql .= \"entryHeadersID = h.id \";\r\n    if ($period)\r\n        $sql .= \"AND postingdate~'\".$period.\"' \";\r\n    if($account) {\r\n        $sql .= \"AND entryHeadersID IN (\";\r\n        $sql .= \"SELECT entryHeadersID FROM entrydetails WHERE accountmainid='\".$account.\"')\";\r\n    }\r\n    $sql .= \"ORDER BY postingdate,h.id,d.id;\";\r\n    $stmt = $pdo -> query($sql);<\/code><\/pre>\n<\/div>\n
[php]\u691c\u7d22\u7d50\u679c\u306e\u53d6\u308a\u51fa\u3057\u3068<table>\u4f5c\u6210<\/span><\/p>\n
\n
print '<table border=\"1\" cellpadding=\"4\">';\r\nprint '<tr>\u65e5\u4ed8<\/td><td>\uff03<\/td><td>\u6458\u8981<\/td>';\r\nprint '<td>\u501f\u65b9\u79d1\u76ee<\/td><td>\u8cb8\u65b9\u79d1\u76ee<\/td><td>\u501f\u65b9<\/td><td>\u8cb8\u65b9<\/td><\/tr>';\r\nwhile ($row = $stmt -> fetch(PDO::FETCH_ASSOC)) {\r\n    print \"<tr>\";\r\n    $postingdate = $row['postingdate'];\r\n    print \"<td>\".$postingdate.\"<\/td>\";\r\n    $entrynumber = $row['entrynumber'];\r\n    print \"<td align='right'>\".$entrynumber.\"<\/td>\";\r\n    $detailcomment = $row['detailcomment'];\r\n    print \"<td>\".$detailcomment.\"<\/td>\";\r\n    $account_d = $row['account_d'];\r\n    print \"<td>\".$account_d.\"<\/td>\";\r\n    $account_c = $row['account_c'];\r\n    print \"<td>\".$account_c.\"<\/td>\";\r\n    $debit = $row['debit'];\r\n    if (is_numeric($debit))\r\n        print \"<td align='right'>\".number_format($debit).\"<\/td>\";\r\n    else\r\n        print \"<td><\/td>\";\r\n    $credit = $row['credit'];\r\n    if (is_numeric($credit))\r\n        print \"<td align='right'>\".number_format($credit).\"<\/td>\";\r\n    else\r\n        print \"<td><\/td>\";\r\n    print \"<\/tr>\";\r\n}\r\nprint \"<\/table>\";<\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Views: 123\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u305fXBRL GL\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6587\u66f8\u8868\u793a \u6b21\u306e3\u6bb5\u968e\u306e\u51e6\u7406\u3067\u3059\u3002 \uff08\uff11\uff09javascript\u304b\u3089jQuery\u306eajax\u3067\u3001\u671f\u9593\u304a\u3088\u3073\u79d1\u76ee\u3092\u6307\u5b9a\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u306ePHP\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002 \uff08\uff12\uff09PHP\u3067 […]<\/p>\n","protected":false},"author":1,"featured_media":427,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/388"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":25,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"predecessor-version":[{"id":657,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions\/657"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/427"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}