{"id":146,"date":"2015-01-13T19:45:44","date_gmt":"2015-01-13T11:45:44","guid":{"rendered":"http:\/\/www.llku.com\/?p=146"},"modified":"2015-01-13T19:45:44","modified_gmt":"2015-01-13T11:45:44","slug":"%e6%9f%a5%e8%af%a2%e7%9b%ae%e5%89%8debs%e7%b3%bb%e7%bb%9fgl%e5%bc%80%e5%90%af%e7%9a%84%e6%9c%9f%e9%97%b4sql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=146","title":{"rendered":"\u67e5\u8be2\u76ee\u524dEBS\u7cfb\u7edfGL\u5f00\u542f\u7684\u671f\u95f4SQL"},"content":{"rendered":"<p>\n\tSELECT (P.PERIOD_NAME) PERIOD_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;TO_CHAR(P.START_DATE, &#39;YYYY-MM-DD&#39;) PERIOD_START,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;TO_CHAR(P.END_DATE, &#39;YYYY-MM-DD&#39;) PERIOD_END<br \/>\n\t&nbsp; FROM GL_PERIODS P, GL_LEDGERS B, GL_PERIOD_STATUSES S<br \/>\n\t&nbsp;WHERE P.PERIOD_SET_NAME = B.PERIOD_SET_NAME<br \/>\n\t&nbsp; &nbsp;AND B.LEDGER_ID = S.LEDGER_ID<br \/>\n\t&nbsp; &nbsp;AND S.CLOSING_STATUS = &#39;O&#39;<br \/>\n\t&nbsp; &nbsp;AND S.APPLICATION_ID = 101<br \/>\n\t&nbsp; &nbsp;AND S.PERIOD_NAME = P.PERIOD_NAME<br \/>\n\t&nbsp;ORDER BY PERIOD_END DESC;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT (P.PERIOD_NAME) PERIOD_NAME, &nbsp; &nbsp; &#038;nbsp &hellip; <a href=\"https:\/\/www.llku.com\/?p=146\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u67e5\u8be2\u76ee\u524dEBS\u7cfb\u7edfGL\u5f00\u542f\u7684\u671f\u95f4SQL<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[36],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/146"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}