Views: 119<\/p>
Three steps
\n\uff08\uff11\uff09A browser side javascript program calls PHP program at server side to process request based on period and\/or account number passed with an arguments of jQuery’s ajax.
\n\uff08\uff12\uff09A PHP program generate a query based on arguments and generate <table> then returns generated page to the browser.
\n\uff08\uff13\uff09A web browser displays a result from the server.
\n<\/p>\n
<select> element for specify period and\/or account number and\u00a0<button> element with\u00a0id=”jQbutton” are defined here.<\/p>\n
Returned result will be\u00a0\u00a0populated inside of this <div>.<\/p>\n
[html]<\/span><\/p>\n We define procedure for clicking a button with $(‘#jQbutton’).on(“click”, function() {\u3000}) [javascript]<\/span><\/p>\n [php]Define SQL and execute query<\/span><\/p>\n [php]Picking up resulting value and construct <table> element<\/span><\/p>\n Views: 119Viewing XBRL GL instance by period and\/or account number Three steps \uff08\uff11\uff09A browser side javascript pr […]<\/p>\n","protected":false},"author":1,"featured_media":427,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/648"}],"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=648"}],"version-history":[{"count":2,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/648\/revisions"}],"predecessor-version":[{"id":655,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/648\/revisions\/655"}],"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=648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<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 \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\">Cash<\/option>\r\n \u2026 \u2026\r\n <\/select>\r\n <button id=\"jQbutton\"\u3000style=\"font-size: x-large\">Find<\/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
\n$period, $account variables are defined based on <select> and calls glList.php with ajax.
\nresulting <table> are populated with $(‘#jQajax’).html(data).<\/p>\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>\nQuery by condition and display this result<\/h2>\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>\nprint '<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":"