{"id":642,"date":"2013-10-13T11:04:06","date_gmt":"2013-10-13T02:04:06","guid":{"rendered":"http:\/\/www.sambuichi.jp\/?p=642"},"modified":"2014-07-25T16:51:49","modified_gmt":"2014-07-25T07:51:49","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%9c","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=642&lang=en","title":{"rendered":"XBRL GL Instance Viewing Service [Prototype](1\/3)"},"content":{"rendered":"

Views: 174<\/p>

XBRL GL Instance Viewing Service<\/h1>\n

These are prototype services for viewing XBRL GL instance documents generated by accounting softwares.
\n(You can find source programs at the GitHub<\/a>\u00a0site..)<\/p>\n

1. iphix sample(XBRL 2.1)
\nhttp:\/\/www.sambuichi.jp\/xbrlgl\/index.html<\/a>
\nOriginal file location http:\/\/gl.iphix.net\/files.htm<\/a><\/p>\n

2. PCA (XBRL 2.0a)
\n2.1 View of \u00a0document structure \u00a0of XBRL GL instance for each entry
\nhttp:\/\/www.sambuichi.jp\/xbrlgl\/pca.html<\/a>
\n2.2 View of journal entry by entered slip
\nhttp:\/\/www.sambuichi.jp\/xbrlgl\/journal_entry.html<\/a>
\n2.3 View of summary by month and\/or chart of accounts. These documents are stored in database.
\nhttp:\/\/www.sambuichi.jp\/xbrlgl\/list.html<\/a>
\n<\/p>\n

Programming TIPS: jQuery’s XML function<\/h1>\n

We processed XBRL files\u00a0with\u00a0HTML5, CSS3, jQuery, javascript in samples\u00a01. 2. 2.1. 2.2 .
\nXBRL GL instance documents are XML documents. We can use jQuery’s XML function.
\nXBRL GL instance documents are stored in a database at Amazon Web Service.
\nWhen you click a button, the next function load selected file with load_xmlfile().<\/p>\n

[javascript] glLoad function<\/span><\/p>\n

\n
function glLoad() {\r\n    var glSelectList = $('select#glselect');\r\n    var url = $('option:selected', glSelectList).val();\r\n    load_xmlfile(url);\r\n}\r\n<\/code><\/pre>\n<\/div>\n
load_xmlfile(url) reads XBRL GL instance document stored at the location defied by URL then process this document to generate page.<\/p>\n
[javascript] load_xmlfile function<\/span><\/p>\n
\n
function load_xmlfile(url) {\r\n    $.ajax({\r\n        url : url,\r\n        type : 'GET',\r\n        dataType : 'text',\r\n        timeout : 1000,\r\n        error : fnc_xmlerr, \/\/call \"fnc_xmlerr\" on failure\r\n        success : fnc_xml   \/\/call \"fnc_xml\" on success\r\n    });\r\n};<\/code><\/pre>\n<\/div>\n
When program consumed XBRL GL instance normally, this document is passed to fnc_xml(xml) function as an argument xml. XML function of jQuery can process this as a XML document.
\nWith fundamental knowledge of XBRL GL taxonomy, program was coded by an author. This version can only process a standard taxonomy. In case of extending taxonomy, you need special coding for handling extended items and\/or special error condition based on extended taxonomy.
\nXBRL GL instance document is \u00a0also a xml document, $(xml).find(“\u3000condition\u3000”) can find any items within a document.
\nFirstly, we lookup XBRL GL’s <gl-cor:accountingEntries>item.<\/p>\n
[javascript] Repeating process for loook up accountingEntries, entryHeader, entryDetail structure<\/span><\/p>\n
\n
\/\/ accountingEntries\r\n$accountingEntries = $(xml).find(\"gl-cor\\:accountingEntries\");\r\n\/\/ entryHeader\r\n$entryHeaders = $accountingEntries.find(\"gl-cor\\:entryHeader\");\r\n$entryHeaders.each(function(num, header) {\r\n    \/\/ entryDetail\r\n    $entryDetails = $(header).find(\"gl-cor\\:entryDetail\");\r\n    $entryDetails.each(function(line, detail) {\r\n        $account = $(detail).find(\"gl-cor\\:account\");\r\n        $accountMainDescription = $account.find(\"gl-cor\\:accountMainDescription\");\r\n        $accountSub = $account.find(\"gl-cor\\:accountSub\");\r\n        $accountSubDescription = $accountSub.find(\"gl-cor\\:accountSubDescription\");\r\n        $accountSubType = $accountSub.find(\"gl-cor\\:accountSubType\");\r\n        $amount = $(detail).find(\"gl-cor\\:amount\");\r\n        $debitCreditCode = $(detail).find(\"gl-cor\\:debitCreditCode\");\r\n        $postingDate = $(detail).find(\"gl-cor\\:postingDate\");\r\n        $detailComment = $(detail).find(\"gl-cor\\:detailComment\");\r\n    }    \r\n}<\/code><\/pre>\n<\/div>\n
[html] <div> element for defining a dynamic <table><\/span><\/p>\n
\n
<div id=\"trace\"><\/div>\r\n<\/code><\/pre>\n<\/div>\n
[javascript]\u3000Repeating process for generate <table> contents<\/span><\/p>\n
\n
$entryHeaders.each(function(num, header) {\r\n  \/\/ entryDetail\r\n  \/\/ Define <table>\r\n  $tableDetail = $('<table class=\"detail\" width=\"97%\" border=\"1\" cellpadding=\"5\"><\/table>');\r\n  $(\"#trace\").append($tableDetail);\r\n  \/\/ Look up entryDetail items and store contents in variables\r\n  $entryDetails = $(header).find(\"gl-cor\\:entryDetail\");\r\n  $entryDetails.each(function(line, detail) {\r\n        \u2026 \u2026\r\n      if ($debitCreditCode.text()=='debit') {\r\n        $tableDetail.append($(\"<tr\/>\")\r\n          .append($('<td><\/td>').text($postingDate.text()))\r\n          .append($('<td><\/td>').text($accountMainDescription.text()))\r\n          .append($('<td><\/td>').text($accountSubDescription.text()+\"(\"+$accountSubType.text()+\")\"))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td align=\"right\"><\/td>').text(addFigure($amount.text())))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td><\/td>').text($detailComment.text()))\r\n        );\r\n      }\r\n      else if ($debitCreditCode.text()=='credit') {\r\n        $tableDetail.append($(\"<tr\/>\")\r\n          .append($('<td><\/td>').text($postingDate.text()))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td><\/td>').text($accountMainDescription.text()))\r\n          .append($('<td><\/td>').text($accountSubDescription.text()+\"(\"+$accountSubType.text()+\")\"))\r\n          .append($('<td><\/td>').text(\"\"))\r\n          .append($('<td align=\"right\"><\/td>').text(addFigure($amount.text())))\r\n          .append($('<td><\/td>').text($detailComment.text()))\r\n        );\r\n      }\r\n    }\r\n  }\r\n}<\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Views: 174XBRL GL Instance Viewing Service These are prototype services for viewing XBRL GL instance documents […]<\/p>\n","protected":false},"author":1,"featured_media":532,"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\/642"}],"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=642"}],"version-history":[{"count":2,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":674,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions\/674"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}