{"id":5326,"date":"2019-09-04T08:40:58","date_gmt":"2019-09-04T00:40:58","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=5326"},"modified":"2019-09-04T08:40:58","modified_gmt":"2019-09-04T00:40:58","slug":"t100%e5%a4%9a%e9%a1%b5%e7%ad%be%e6%b1%87%e5%87%baexcel","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=5326","title":{"rendered":"T100\u591a\u9875\u7b7e\u6c47\u51faexcel"},"content":{"rendered":"
ON ACTION exporttoexcel\r\n            LET g_action_choice=\"exporttoexcel\"\r\n            IF cl_auth_chk_act(\"exporttoexcel\") THEN\r\n               #(ver:62) ---start---\r\n               #\u56e0\u61c9\u532f\u51faexcel\u898f\u5247\u8abf\u6574\uff0c\u9700\u540c\u6642\u7b26\u5408\u65b0\u820a\u505a\u6cd5\r\n               LET lb_get_type = cl_get_exporttoexcel_type()\r\n               #add-point:ON ACTION exporttoexcel name=\"ui_dialog.exporttoexcel_type_change\"\r\n\r\n               #END add-point\r\n               DISPLAY \"lb_get_type:\",lb_get_type\r\n \r\n               CASE\r\n                  WHEN lb_get_type = \"poi\"   #\u4f7f\u7528poi\u6a23\u677f\r\n                     #browser\r\n                     CALL g_export_node.clear()\r\n                     IF g_main_hidden = 1 THEN\r\n                        LET l_arr_len = g_browser.getLength()\r\n                        LET g_export_tabname[1] = \"s_browse\"\r\n                        LET g_export_tag[1] = rec_arr_type.create(l_arr_len)\r\n                        FOR l_arr_cnt = 1 TO l_arr_len\r\n                           LET g_export_tag[1][l_arr_cnt] = g_browser[l_arr_cnt]\r\n                        END FOR\r\n \r\n                        #add-point:ON ACTION exporttoexcel name=\"menu.exporttoexcel_browser_poi\"\r\n                        \r\n                        #END add-point\r\n                        CALL cl_export_poi()\r\n                        #add-point:ON ACTION exporttoexcel name=\"menu.exporttoexcel_browser_after_poi\"\r\n\r\n                        #END add-point\r\n                     #\u975ebrowser\r\n                     ELSE\r\n                        LET l_arr_len = g_xcck_d.getLength()\r\n                        LET g_export_tag[1] = rec_arr_type.create(l_arr_len)\r\n                        LET g_export_tabname[1] = \"s_detail1\"\r\n                        FOR l_arr_cnt = 1 TO l_arr_len\r\n                           LET g_export_tag[1][l_arr_cnt] = g_xcck_d[l_arr_cnt]\r\n                        END FOR\r\n \r\n \r\n                        #add-point:ON ACTION exporttoexcel name=\"menu.exporttoexcel_poi\"\r\n                        LET l_arr_len = g_xcck2_d.getLength()\r\n                        LET g_export_tag[2] = rec_arr_type.create(l_arr_len)\r\n                        LET g_export_tabname[2] = \"s_detail2\"\r\n                        FOR l_arr_cnt = 1 TO l_arr_len\r\n                           LET g_export_tag[2][l_arr_cnt] = g_xcck2_d[l_arr_cnt]\r\n                        END FOR\r\n                        #END add-point\r\n                        CALL cl_export_to_excel_getpage()\r\n                        CALL cl_export_poi()\r\n                        #add-point:ON ACTION exporttoexcel name=\"menu.exporttoexcel_after_poi\"\r\n\r\n                        #END add-point\r\n                     END IF<\/code><\/pre>\n
 <\/p>\n
ON\u00a0ACTION\u00a0exporttoexcel
\nLET\u00a0g_action_choice=”exporttoexcel”
\nIF\u00a0cl_auth_chk_act(“exporttoexcel”)\u00a0THEN
\n#(ver:62) —start—
\n#\u56e0\u61c9\u532f\u51faexcel\u898f\u5247\u8abf\u6574\uff0c\u9700\u540c\u6642\u7b26\u5408\u65b0\u820a\u505a\u6cd5
\nLET\u00a0lb_get_type\u00a0=\u00a0cl_get_exporttoexcel_type()
\n#add-point:ON ACTION exporttoexcel name=”ui_dialog.exporttoexcel_type_change”<\/p>\n
#END add-point
\nDISPLAY\u00a0“lb_get_type:”,lb_get_type<\/p>\n
CASE
\nWHEN\u00a0lb_get_type\u00a0=\u00a0“poi”\u00a0\u00a0\u00a0#\u4f7f\u7528poi\u6a23\u677f
\n#browser
\nCALL\u00a0g_export_node.clear()
\nIF\u00a0g_main_hidden\u00a0=\u00a01\u00a0THEN
\nLET\u00a0l_arr_len\u00a0=\u00a0g_browser.getLength()
\nLET\u00a0g_export_tabname[1]\u00a0=\u00a0“s_browse”
\nLET\u00a0g_export_tag[1]\u00a0=\u00a0rec_arr_type.create(l_arr_len)
\nFOR\u00a0l_arr_cnt\u00a0=\u00a01\u00a0TO\u00a0l_arr_len
\nLET\u00a0g_export_tag[1][l_arr_cnt]\u00a0=\u00a0g_browser[l_arr_cnt]
\nEND\u00a0FOR<\/p>\n
#add-point:ON ACTION exporttoexcel name=”menu.exporttoexcel_browser_poi”<\/p>\n
#END add-point
\nCALL\u00a0cl_export_poi()
\n#add-point:ON ACTION exporttoexcel name=”menu.exporttoexcel_browser_after_poi”<\/p>\n
#END add-point
\n#\u975ebrowser
\nELSE
\nLET\u00a0l_arr_len\u00a0=\u00a0g_xcck_d.getLength()
\nLET\u00a0g_export_tag[1]\u00a0=\u00a0rec_arr_type.create(l_arr_len)
\nLET\u00a0g_export_tabname[1]\u00a0=\u00a0“s_detail1″
\nFOR\u00a0l_arr_cnt\u00a0=\u00a01\u00a0TO\u00a0l_arr_len
\nLET\u00a0g_export_tag[1][l_arr_cnt]\u00a0=\u00a0g_xcck_d[l_arr_cnt]
\nEND\u00a0FOR<\/p>\n
#add-point:ON ACTION exporttoexcel name=”menu.exporttoexcel_poi”
\nLET\u00a0l_arr_len\u00a0=\u00a0g_xcck2_d.getLength()
\nLET\u00a0g_export_tag[2]\u00a0=\u00a0rec_arr_type.create(l_arr_len)
\nLET\u00a0g_export_tabname[2]\u00a0=\u00a0“s_detail2″
\nFOR\u00a0l_arr_cnt\u00a0=\u00a01\u00a0TO\u00a0l_arr_len
\nLET\u00a0g_export_tag[2][l_arr_cnt]\u00a0=\u00a0g_xcck2_d[l_arr_cnt]
\nEND\u00a0FOR
\n#END add-point
\nCALL\u00a0cl_export_to_excel_getpage()
\nCALL\u00a0cl_export_poi()
\n#add-point:ON ACTION exporttoexcel name=”menu.exporttoexcel_after_poi”<\/p>\n
#END add-point
\nEND\u00a0IF<\/p>\n
#s_detail2\u5c31\u662f\u7b2c\u4e8c\u4e2a\u9875\u7b7e\uff0c\u591a\u4e2a\u9875\u7b7e\u76f8\u540c\u53c2\u7167s_detail2\u6765\u6dfb\u52a0<\/p>\n
 <\/p>\n
\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » T100\u591a\u9875\u7b7e\u6c47\u51faexcel<\/a><\/p>","protected":false},"excerpt":{"rendered":"
ON ACTION exporttoexcel LET g_action_choice=”exporttoexcel” IF cl_auth_chk_act(“exporttoexcel”) THEN #(ver:62) —start— #\u56e0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[490],"tags":[824,825,763],"class_list":["post-5326","post","type-post","status-publish","format-standard","hentry","category-490","tag-exporttoexcel","tag-get","tag-type"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5326"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5326\/revisions"}],"predecessor-version":[{"id":5327,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5326\/revisions\/5327"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}