{"id":1826,"date":"2018-09-02T10:01:24","date_gmt":"2018-09-02T02:01:24","guid":{"rendered":"http:\/\/ufqi.com\/blog\/?p=1826"},"modified":"2018-09-02T16:23:56","modified_gmt":"2018-09-02T08:23:56","slug":"gmis-groupbyseg-addbycopy-etc","status":"publish","type":"post","link":"https:\/\/ufqi.com\/blog\/gmis-groupbyseg-addbycopy-etc\/","title":{"rendered":"-gMIS \u5409\u5bc6\u65af\u4f18\u5316\u66f4\u65b0+\u5206\u7ec4\u9879\u533a\u6bb5AddGroupBySeg\/+\u590d\u5236AddByCopy\u7b49"},"content":{"rendered":"

-gMIS \u5409\u5bc6\u65af\u6301\u7eed\u66f4\u65b0\u4f18\u5316\u5347\u7ea7\uff0c\u6700\u8fd1\u4e00\u6bb5\u65f6\u95f4\u7684\u529f\u80fd\u6539\u8fdb\u5305\u62ec\u5982\u4e0b\u51e0\u9879\uff0c\u5907\u5fd8\u5982\u4e0b\u3002<\/p>\n

    \n
  1. \u6570\u636e\u900f\u89c6Pivot\u6a21\u5757\uff1a +\u5206\u7ec4\u9879\u533a\u6bb5AddGroupBySeg<\/strong>
    \u8fd9\u4e2a\u529f\u80fd\u9762\u4e34\u7684\u573a\u666f\u662f\uff0c\u5f53\u6211\u4eec\u5728\u4f7f\u7528\u6570\u636e”\u900f\u89c6\u201c\u529f\u80fd\u65f6\uff0c\u5206\u7ec4group by\u7edf\u8ba1\u65f6\uff0c\u603b\u662f\u5c06\u6574\u4e2a\u5b57\u6bb5\u7684\u503c\u53c2\u4e0e\u8ba1\u7b97\uff0c\u6b64\u524d\u5df2\u7ecf\u63d0\u4f9b\u4e86 addGroupByDateYmd \u2014\u2014 Ymd\u7684\u529f\u80fd\u662f\u683c\u5f0f\u5316\u65f6\u95f4\u76f8\u5173\u7684\u5b57\u6bb5\uff0c\u4ee5Ymd\u7684\u5f62\u5f0f\u53c2\u4e0e\u8ba1\u7b97\u3002
    addGroupBySeg \u5219\u5728\u6b64\u57fa\u7840\u4e0a\u66f4\u8fdb\u4e00\u6b65\uff0c\u53ef\u4ee5\u63d0\u4f9b\u4e86\u622a\u53d6\u5b57\u6bb5\u503c\u7684\u7ed9\u5b9a\u533a\u95f4\u90e8\u5206\u53c2\u4e0e\u8ba1\u7b97\u3002\u4f8b\u5982 iname\u5b57\u6bb5\u7684\u503c\u662f abc123efg456\uff0c \u5982\u679c\u9700\u6c42\u5e0c\u671b\u622a\u53d6iname\u7684\u524d\u4e09\u4e2a\u5b57\u7b26\u53c2\u4e0e\u8ba1\u7b97\uff0c\u5219\u53ef\u4ee5\u8c03\u7528 addGroupBySeg\u529f\u80fd\uff0c\u540c\u6837\u5730\uff0c\u4e5f\u53ef\u4ee5\u622a\u53d6\u4e2d\u95f4\u7684 “efg” \u51fa\u6765\u3002
    “\u6570\u636e\u900f\u89c6Pivot\u201c\u6a21\u5757\u529f\u80fd\u6e90\u81ea Microsoft Excel\uff0c\u8fd9\u4e00\u523b\u8d77\uff0c\u5dee\u4e0d\u591a\u8981\u8d85\u4e4e Excel\u7684\u6570\u636e\u900f\u89c6\u529f\u80fd\u4e86\u3002\n<\/li>\n
  2. \u6570\u636e\u64cd\u4f5c\uff1a +\u590d\u5236AddByCopy<\/strong>
    \u5728\u7ba1\u7406\u4fe1\u606f\u7cfb\u7edf\uff08MIS\uff09\u4e2d\uff0c\u5f55\u5165\u6570\u636e\u662f\u4e00\u4ef6\u7e41\u7410\u7684\u4e8b\uff0c\u6709\u5148\u540e\u76f8\u90bb\u4e24\u6761\u8bb0\u5f55\u5dee\u522b\u4e0d\u591a\u65f6\uff0c\u53ef\u4ee5\u901a\u8fc7\u590d\u5236\u524d\u4e00\u6761\u5e76\u505a\u5c11\u91cf\u4fee\u6539\u6765\u6ee1\u8db3\u5b9e\u73b0\u5feb\u901f\u5f55\u5165\u6570\u636e\u7684\u9700\u6c42\u3002AddByCopy \u5373\u662f\u5728\u6b64\u80cc\u666f\u4e0b\u521b\u5efa\u7684\uff0c\u5f53\u6211\u4eec\u8981\u8f93\u5165\u76f8\u4f3c\u3001\u76f8\u90bb\u7684\u8bb0\u5f55\u65f6\uff0c\u53ef\u4ee5\u4f7f\u7528\u590d\u5236\u529f\u80fd\uff0c\u5feb\u901f\u4f7f\u7528\u6b64\u524d\u521a\u521a\u5f55\u5165\u7684\u6570\u636e\uff0c\u6781\u5927\u5730\u52a0\u5feb\u6570\u636e\u5f55\u5165\uff0c\u63d0\u5347\u5de5\u4f5c\u6548\u7387\u3002\n

    <\/li>\n

  3. \u9875\u9762Tititle\u4fee\u6539\u4e3a\u4e09\u7ea7\u9012\u8fdb\u6539\u8fdb<\/strong>
    \u6539\u8fdb\u540e\uff1a\u6a21\u5757\u540d\u79f0 – \u76ee\u5f55\u540d\u79f0 – \u5409\u5bc6\u65af\uff08\u9ed8\u8ba4\uff09\u3002\n

    <\/li>\n

  4. List\u6a21\u5f0f\uff1a +\u5b57\u6bb5\u5728title hint\u65f6\u6700\u957f\u9650\u5236<\/strong>
    \u6b64\u524d\u6709\u5b57\u6bb5\u9650\u5236\u5728\u5217\u8868\u4e2d\u663e\u793a\u7684\u5b57\u6bb5\u503c\u6700\u5927\u957f\u5ea6\uff0c
    list_disp_limit = 38
    \u65b0\u589e\u52a0\u5728title hint\u65f6\u7684\u5b57\u6bb5\u957f\u5ea6\u9650\u5236\uff0c
    list_disp_title_max_length = 300
    \u5982\u679c\u4e0d\u52a0 title hint\u65f6\u7684\u957f\u5ea6\u9650\u5236\uff0c\u5f53\u9047\u5230\u6709\u5b57\u6bb5\u7c7b\u578b\u4e3a text \u7684\u8d85\u957f\u6587\u672c\u65f6\uff0c\u4f1a\u618b\u574f\u6574\u4e2a\u6d4f\u89c8\u5668\u8fdb\u7a0b\/\u7ebf\u7a0b\u3002\n

    <\/li>\n

  5. \u6ce8\u518c\u52a8\u4f5cregisterAct\uff1a \u6539\u8fdb\u589e\u52a0 Base62x.class.js<\/strong>
    \u8ba1\u5212\u4e86\u5f88\u4e45\u7684\u4e8b\u60c5\uff0cregisterAct \u672c\u8eab\u7531\u4e8e JavaScript\u7684 escape\u6709bug\uff0c\u5f53 Base62x.class.js \u521b\u5236\u5b8c\u6210\u4e4b\u540e\u5c31\u60f3\u7740\u66ff\u6362\uff0c\u73b0\u5728\u7ec8\u4e8e\u627e\u5230\u5408\u9002\u7684\u65f6\u673a\uff0c\u5728\u670d\u52a1\u5668\u7aef\u4f7f\u7528PHP\u7248\u672c\u7684 Base62x.class.php \u5bf9\u5f85\u6ce8\u518c\u7684\u52a8\u4f5c\u8fdb\u884c\u7f16\u7801\uff0c\u7136\u540e\u5728\u6d4f\u89c8\u5668\u7ec8\u7aef\uff0c\u4f7f\u7528JavaScript\u7248\u672c\u7684 Base62x.class.js \u5bf9\u5f85\u6ce8\u518c\u7684\u52a8\u4f5c\u8fdb\u884c\u89e3\u7801\uff0c\u8fdb\u800c\u8fdb\u884c\u52a8\u4f5c\u6ce8\u518c\uff0c\u4e00\u6c14\u5475\u6210\u3002
    \u6ce8\u518c\u52a8\u4f5cregisterAct \u662f -gMIS \u53d1\u73b0\u7684\u4e00\u4e2aJavaScript\u8fdb\u884c\u900f\u4f20\u5f85\u6267\u884c\u52a8\u4f5c\u7684\u65b9\u6cd5\u3002\u901a\u5e38\u4f7f\u7528 Ajax \u6216\u8005 iFrame \u7b49\u65b9\u5f0f\u8fdb\u884c\u670d\u52a1\u5668\u7aef\/\u6d4f\u89c8\u5668\u7aef\u8fdb\u884c\u6570\u636e\u4ea4\u4e92\u65f6\uff0c\u65e0\u6cd5\u5c06\u5236\u5b9a\u7684 JavaScript\u65b9\u6cd5\u91ca\u653e\u5230\u6307\u5b9a\u7684\u6267\u884c\u57df\u8fdb\u884c\u6267\u884c\uff0cregisterAct \u5c31\u662f\u4e3a\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u800c\u8bbe\u8ba1\u7684\u3002\u00a0\n

    \u540c\u65f6\u5f97\u76ca\u4e8e Base62x.class.js \u7684\u5f15\u5165\uff0c switchEdit \u7b49\u51fd\u6570\u4e5f\u5c06\u83b7\u5f97\u66f4\u597d\u7684\u517c\u5bb9\u6027\uff0cinline\u6a21\u5f0f\u7684\u53cc\u51fb\u5373\u7f16\u8f91\u4e5f\u5c06\u5f97\u5230\u6539\u5584\u3002<\/p>\n<\/li>\n

  6. \u6838\u5fc3\u6a21\u5757\uff1adb\u8fde\u63a5\u589e\u52a0\u957f\u8fde\u63a5<\/strong>
    \u5f97\u76ca\u4e8e -GWA2 \u7684\u5347\u7ea7\u6539\u8fdb\uff0c-gMIS \u5728\u8bfb\u53d6\u6570\u636e\u5e93\u6570\u636e\u65f6\uff0c\u5982\u679c\u63a2\u6d4b\u6216\u8005\u6839\u636e\u8bbe\u7f6e\uff0c\u5f53PHP\u8fd0\u884c\u65f6\u73af\u5883\u652f\u6301\u6570\u636e\u5e93\u957f\u8fde\u63a5\u65f6\uff0c\u5219\u542f\u52a8\u6570\u636e\u5e93\u957f\u8fde\u63a5\u3002
    \u81f3\u6b64\u5728\u8fd9\u65b9\u9762\u7684\u901f\u5ea6\u4f18\u5316\uff0c\u53c8\u63d0\u5347\u4e00\u70b9\u70b9\u3002
    PHP + MySQL\u7684\u6570\u636e\u5e93\u957f\u8fde\u63a5\u662f\u57fa\u4e8e\u8fdb\u7a0b\u7684\uff0c\u4e5f\u5373\u957f\u8fde\u63a5\u5728\u8fdb\u7a0b\u8303\u56f4\u5185\u5171\u4eab\uff0c\u5176MySQL\u5e76\u53d1\u7684\u8fde\u63a5\u6570\u5927\u81f4\u76f8\u5f53\u4e8e\uff1a
    Nginx\/Apache\u6240\u89e6\u53d1\u7684PHP\u8fdb\u7a0b\u6570 * Request\u5e76\u53d1\u6570 * \u6bcf\u4e2aRequest\u5b9e\u4f8b\u5316\u7684\u6570\u636e\u5e93\u8fde\u63a5\u6570.\n

    <\/li>\n

  7. \u5b89\u5168\u6a21\u5757Sid\uff1a+&db=<\/strong>
    \u6539\u8fdb comm\/ido.js , \u9488\u5bf9 appendSid\uff0c\u589e\u52a0\u4e86 &db= \u4e3a\u8fdb\u4e00\u6b65\u7684\u591a\u6570\u636e\u5e93\u7684\u652f\u6301\u63d0\u4f9b\u4fdd\u8bc1.\n<\/li>\n
  8. \u5b89\u5168\u6a21\u5757\u79fb\u9664 eval<\/strong>
    \u6539\u8fdb comm\/header.inc.php \u4e2d\u5bf9 eval \u7684\u5e94\u7528\uff0c\u964d\u4f4e\u5916\u90e8\u8f93\u5165\u5e26\u6765\u6076\u610f\u4ee3\u7801\u6267\u884c\u7684\u98ce\u9669\u3002 PHP eval \u7c7b\u4f3c JavaScript eval \u4e00\u6837\uff0c\u5177\u6709\u4e0d\u4e25\u8c28\u7684\u53cd\u5c04(Reflection), \u5bf9\u5f85\u6267\u884c\u7684\u811a\u672c\u5982\u679c\u68c0\u6d4b\u4e0d\u591f\u4e25\u683c\uff0c\u53ef\u80fd\u4f1a\u6709\u9884\u7559\u540e\u95e8\u7684\u9690\u60a3\uff0c\u5df2\u6d88\u9664\u3002
    eval \u51fd\u6570\u5728 -PHP \u5b98\u7f51\uff08\u00a0-R\/P2ST<\/a>\u00a0<\/b> \uff09\u4e0a\u4e5f\u88ab\u660e\u663e\u63d0\u793a\u662f\u201c\u5371\u9669\u201d\u7684\u3002
    \n

    Caution<\/strong><\/p>\n

    The\u00a0eval()<\/strong><\/span>\u00a0language construct is\u00a0very dangerous<\/em>\u00a0because it allows execution of arbitrary PHP code.\u00a0Its use thus is discouraged.<\/em>\u00a0If you have carefully verified that there is no other option than to use this construct, pay special attention\u00a0not to pass any user provided data<\/em>\u00a0into it without properly validating it beforehand.<\/p>\n<\/blockquote>\n<\/li>\n

  9. \n

    \u00a0\u66f4\u65b0getUrlByTime<\/strong>
    \u589e\u52a0\u9488\u5bf9\u5b57\u6bb5\u540d\u79f0\u4e2d\u542b\u6709 \u201dtime\u201c\u7684\uff0c\u542f\u7528”00:00:00″ — “23:59:59” \u7684\u652f\u6301\u3002<\/p>\n<\/li>\n

  10. \n

    \u6539\u8fdb\u7ad9\u5185\u641c\u7d22InSiteSearch \u521d\u59cb\u5316\u7684\u903b\u8f91<\/strong>
    \u4f7f\u4e4b\u80fd\u591f\u517c\u5bb9\u4e0d\u540c\u7684\u6570\u636e\u5e93\u7684\u60c5\u51b5.
    \u6539\u8fdb\u5224\u5b9a\u662f\u5426\u53ef\u68c0\u7d22\u5b57\u6bb5\u7684\u5224\u65ad\u7cfb\u6570\u3002<\/p>\n<\/li>\n

  11. \n

    \u6539\u8fdb\u9519\u8bef\u8f93\u51faError Print<\/strong>
    \u5f53\u6709\u6570\u636e\u5e93\u6570\u636e\u8bfb\u53d6\u5f02\u5e38\u65f6\uff0c\u663e\u793a\u66f4\u4e3a\u53cb\u5584\u7684\u63d0\u793a\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u201c\u53cd\u9988\u7ed9\u7ba1\u7406\u5458\u201d\u7684\u90ae\u4ef6\u94fe\u63a5\uff0c\u4f7f\u5f02\u5e38\u5904\u7406\u66f4\u4eba\u6027\u5316\u4e00\u4e9b\u3002
    \u5bf9\u4e8e\u5199\u91cd\u590d\u7b49\u4fe1\u606f\uff0c\u63d0\u4f9b\u4e86\u66f4\u76f4\u767d\u7684\u663e\u793a\u548c\u89e3\u91ca\u3002<\/p>\n

    \"gmis-logo-201606\"<\/p>\n

    -gMIS \u662f\u4e00\u79cd\u57fa\u4e8e -GWA2 \u7684\u901a\u7528\u7ba1\u7406\u4fe1\u606f\u7cfb\u7edf(Management Information System)\u5e94\u7528\u8f6f\u4ef6\uff0c\u5177\u6709\u53ef\u914d\u7f6e\u7684\u8f93\u5165\u548c\u8f93\u51fa\u63a5\u53e3\u3001\u5f00\u7bb1\u5373\u7528\u7b49\u7279\u5f81\u3002
    \u53ef\u4ee5\u5728\u5176\u4e0a\u6784\u5efa\u5404\u79cd\u7ba1\u7406\u5e94\u7528\u8f6f\u4ef6\u7cfb\u7edf\uff0c\u5982
    \u5185\u5bb9\u7ba1\u7406\u7cfb\u7edf\uff08CMS), \u5ba2\u6237\u8d44\u6e90\u7ba1\u7406(CRM), \u4f01\u4e1a\u8d44\u6e90\u8ba1\u5212\u7ba1\u7406\uff08ERP\uff09\uff0c
    \u529e\u516c\u81ea\u52a8\u5316\u7cfb\u7edf\uff08OA\uff09\u7b49, \u4ee5\u53ca\u5404\u79cd\u884c\u4e1a\u5e94\u7528\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6\uff0c\u5982
    \u4eba\u529b\u8d44\u6e90\u7ba1\u7406\u7cfb\u7edf\uff08HR\uff09\uff0c\u5b66\u751f\u7ba1\u7406\uff0c\u6863\u6848\u7ba1\u7406\uff0c\u65c5\u6e38\u7ba1\u7406\uff0c\u56fe\u4e66\u7ba1\u7406\uff0c
    \u5546\u54c1\u7ba1\u7406\u53ca\u4e1a\u52a1\u8fd0\u8425\u652f\u6491\u7cfb\u7edf\uff08BOSS\uff09\u7b49\u7b49\u3002
    \u5b9e\u73b0\u96f6\u4ee3\u7801\u5f00\u53d1\u3001\u5feb\u901f\u642d\u5efa\u5404\u79cd\u7ba1\u7406\u4fe1\u606f\u7cfb\u7edf\uff08MIS\uff09.<\/p>\n

    -gMIS is a -GWA2 based Management Information System (MIS) software with characteristics like configurable input and output interfaces, open-box-to-use.
    Various management application software systems can be built on it, such as
    Content Management System (CMS), Customer Resource Management (CRM), Enterprise Resource Planning Management (ERP),
    Office automation systems (OA), as well as different industry application management system softwares, such as
    Human Resource Management System (HR), Student Management, Archive Management, Tourism Management, Book Management,
    Commodity management and business operations support systems (BOSS), etc.
    With zero code development, -gMIS can build a set of management information systems (MIS) software in a few minutes.<\/p>\n

    Lower Costs,
    <\/b>Better Productivity<\/b>.
    \u964d\u4f4e\u6210\u672c,
    \u63d0\u9ad8\u6548\u7387.<\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    -gMIS \u5409\u5bc6\u65af\u6301\u7eed\u66f4\u65b0\u4f18\u5316\u5347\u7ea7\uff0c\u6700\u8fd1\u4e00\u6bb5\u65f6\u95f4\u7684\u529f\u80fd\u6539\u8fdb\u5305\u62ec\u5982\u4e0b\u51e0\u9879\uff0c\u5907\u5fd8\u5982\u4e0b … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[41,42,161,2],"tags":[20,154,86,152,168],"_links":{"self":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1826"}],"collection":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/comments?post=1826"}],"version-history":[{"count":13,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1826\/revisions"}],"predecessor-version":[{"id":1843,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1826\/revisions\/1843"}],"wp:attachment":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/media?parent=1826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/categories?post=1826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/tags?post=1826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}