{"id":466,"date":"2015-04-16T18:02:37","date_gmt":"2015-04-16T10:02:37","guid":{"rendered":"http:\/\/www.llku.com\/?p=466"},"modified":"2015-04-17T08:39:16","modified_gmt":"2015-04-17T00:39:16","slug":"%e8%8e%b7%e5%8f%96%e5%91%98%e5%b7%a5%e4%b8%bb%e7%ae%a1%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=466","title":{"rendered":"\u83b7\u53d6\u5458\u5de5\u4e3b\u7ba1\u4fe1\u606f"},"content":{"rendered":"<p>\n\tSELECT PP.LAST_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u5458\u5de5\u59d3\u540d,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PP.PERSON_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u5458\u5de5ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PP.SEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u6027\u522b,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PP.EMAIL_ADDRESS\u3000&nbsp; \u7535\u5b50\u90ae\u4ef6,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PPF.LAST_NAME\u3000&nbsp;&nbsp;&nbsp;&nbsp; \u4e3b\u7ba1\u59d3\u540d,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PPF.EMAIL_ADDRESS\u3000 \u4e3b\u7ba1EMAIL<br \/>\n\t&nbsp; FROM PER_PEOPLE_F PP, PER_ASSIGNMENTS_F PA, PER_PEOPLE_F PPF<br \/>\n\t&nbsp;WHERE PP.PERSON_ID = PA.PERSON_ID<br \/>\n\t&nbsp;&nbsp; AND SYSDATE BETWEEN PA.EFFECTIVE_START_DATE AND PA.EFFECTIVE_END_DATE<br \/>\n\t&nbsp;&nbsp; AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND PP.EFFECTIVE_END_DATE<br \/>\n\t&nbsp;&nbsp; AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE<br \/>\n\t&nbsp;&nbsp; AND PA.SUPERVISOR_ID = PPF.PERSON_ID<br \/>\n\t&nbsp;&nbsp; ORDER BY PP.CREATION_DATE ASC;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT PP.LAST_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &hellip; <a href=\"https:\/\/www.llku.com\/?p=466\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u83b7\u53d6\u5458\u5de5\u4e3b\u7ba1\u4fe1\u606f<\/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":[],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/466"}],"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=466"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":469,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/466\/revisions\/469"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}