{"id":59462,"date":"2025-04-23T09:59:34","date_gmt":"2025-04-23T01:59:34","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59462\/"},"modified":"2025-04-23T09:59:34","modified_gmt":"2025-04-23T01:59:34","slug":"ecshop%e5%90%8e%e5%8f%b0%e6%b7%bb%e5%8a%a0%e4%b8%80%e4%b8%aa%e5%ae%8c%e6%95%b4%e7%9a%84%e7%bb%9f%e8%ae%a1%e7%94%a8%e6%88%b7%e4%bf%a1%e6%81%af%e7%9a%84%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59462\/","title":{"rendered":"ecshop\u540e\u53f0\u6dfb\u52a0\u4e00\u4e2a\u5b8c\u6574\u7684\u7edf\u8ba1\u7528\u6237\u4fe1\u606f\u7684\u529f\u80fd"},"content":{"rendered":"

\u5f00\u53d1ecshop\u5927\u6982\u6709\u534a\u5e74\u591a\u65f6\u95f4\u4e86\uff0c\u6bcf\u6b21\u6539\u7684\u529f\u80fd\u4e5f\u6ca1\u6709\u505a\u603b\u7ed3\u548c\u8bb0\u5f55\uff0c\u4eca\u5929\u6dfb\u52a0\u5b8c\u4e00\u4e2a\u529f\u80fd\uff0c\u8bb0\u5f55\u4e00\u4e0b\u5427\uff0c\u7701\u5f97\u4ee5\u540e\u5fd8\u8bb0\u53c8\u8981\u9ebb\u70e6\u53bb\u67e5\u627e\u3002<\/p>\n

\u9700\u6c42:\u5728\u540e\u53f0\u83dc\u5355-\u62a5\u8868\u7edf\u8ba1-\u4e0b\u9762\u6dfb\u52a0-\u7528\u6237\u60c5\u51b5-\u7684\u529f\u80fd\uff0c\u5305\u62ec\uff1a\u6bcf\u5468\u65b0\u589e\u6ce8\u518c\u7528\u6237\uff0c\u6bcf\u5468\u7d2f\u79ef\u6ce8\u518c\u7528\u6237\uff0c\u6d3b\u8dc3\u7528\u6237-\u5468\u5185\u81f3\u5c11\u767b\u9646\uff11\u6b21\uff0c\u6bcf\u6708\u8bbf\u95ee\u91cf\u7b49\u7b49\u3002<\/p>\n

\u7b2c\u4e00\u6b65\uff1a\u5efa\u7acb\u6570\u636e\u5e93\u7684\u8868<\/p>\n

 <\/p>\n

\"ecshop\u540e\u53f0\u6dfb\u52a0\u4e00\u4e2a\u5b8c\u6574\u7684\u7edf\u8ba1\u7528\u6237\u4fe1\u606f\u7684\u529f\u80fd\u63d2\u56fe\"
\u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u6570\u636e\u5e93\u662f\uff1aeshop\uff0c\u65b0\u5efa\u8868\u540d\uff1aecs_user_situation\u3002<\/p>\n

\u7b2c\u4e8c\u6b65\uff1a\u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b<\/p>\n

DELIMITER $$  <\/span> <\/p>\n

    \n
  1.   <\/span><\/li>\n
  2. DROP<\/span> <\/span>PROCEDURE<\/span> IF EXISTS `eshop`.`pro_users`$$  <\/span><\/span><\/li>\n
  3.   <\/span><\/li>\n
  4. CREATE<\/span> DEFINER=`root`@`localhost` <\/span>PROCEDURE<\/span> `pro_users`()  <\/span><\/span><\/li>\n
  5. BEGIN<\/span>  <\/span><\/span><\/li>\n
  6.     DECLARE<\/span> week_count <\/span>INT<\/span>;  <\/span><\/span><\/li>\n
  7.     DECLARE<\/span> user_count <\/span>INT<\/span>;  <\/span><\/span><\/li>\n
  8.     DECLARE<\/span> over_count <\/span>INT<\/span>;  <\/span><\/span><\/li>\n
  9.     DECLARE<\/span> month_count <\/span>INT<\/span>;  <\/span><\/span><\/li>\n
  10.     — \u6bcf\u5468\u6ce8\u518c\u7528\u6237<\/span>  <\/span><\/span><\/li>\n
  11.     SELECT<\/span> <\/span>COUNT<\/span>(*) <\/span>INTO<\/span> week_count <\/span>FROM<\/span> ecs_users <\/span>WHERE<\/span> reg_time>(UNIX_TIMESTAMP(NOW())-7*24*60*60);  <\/span><\/span><\/li>\n
  12.     — \u603b\u6ce8\u518c\u7528\u6237<\/span>  <\/span><\/span><\/li>\n
  13.     SELECT<\/span> <\/span>COUNT<\/span>(*) <\/span>INTO<\/span> user_count <\/span>FROM<\/span> ecs_users;  <\/span><\/span><\/li>\n
  14.     — \u6bcf\u5468\u7684\u6d3b\u8dc3\u7528\u6237<\/span>  <\/span><\/span><\/li>\n
  15.     SELECT<\/span> <\/span>COUNT<\/span>(*) <\/span>INTO<\/span> over_count <\/span>FROM<\/span> ecs_users <\/span>WHERE<\/span> last_login>(UNIX_TIMESTAMP(NOW())-7*24*60*60);  <\/span><\/span><\/li>\n
  16.     — \u6bcf\u6708\u7684\u8bbf\u95ee\u91cf<\/span>  <\/span><\/span><\/li>\n
  17.     SELECT<\/span> <\/span>COUNT<\/span>(*) <\/span>INTO<\/span> month_count <\/span>FROM<\/span> ecs_stats <\/span>WHERE<\/span> access_time>UNIX_TIMESTAMP(DATE_SUB(DATE_SUB(DATE_FORMAT(NOW(),<\/span>‘%y-%m-%d 00:00:00’<\/span>),INTERVAL EXTRACT(<\/span>DAY<\/span> <\/span>FROM<\/span> NOW())-1 <\/span>DAY<\/span>),INTERVAL 0 <\/span>MONTH<\/span>));  <\/span><\/span><\/li>\n
  18.       <\/span><\/li>\n
  19.     INSERT<\/span> <\/span>INTO<\/span> ecs_user_situation(week_count,user_count,over_count,month_count,week_time) <\/span>VALUES<\/span> (week_count,user_count,over_count,month_count,NOW());  <\/span><\/span><\/li>\n
  20.     END<\/span>$$  <\/span><\/span><\/li>\n
  21.   <\/span><\/li>\n
  22. DELIMITER ;  <\/span><\/li>\n<\/ol>\n

    \u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u5b58\u50a8\u8fc7\u7a0b\u540d\u5b57\uff1apro_users\u3002<\/span> <\/p>\n

    \u7b2c\u4e09\u6b65\uff1a\u5efa\u7acb\u89e6\u53d1\u5668<\/p>\n

    [sql]<\/b> view plaincopyprint?   <\/p>\n

      \n
    1. DELIMITER $$  <\/span><\/span><\/li>\n
    2.   <\/span><\/li>\n
    3. ALTER<\/span> EVENT `eve_users` <\/span>ON<\/span> SCHEDULE EVERY 1 <\/span>HOUR<\/span> STARTS <\/span>‘2013-09-02 12:11:14’<\/span> <\/span>ON<\/span> COMPLETION PRESERVE ENABLE DO <\/span>BEGIN<\/span>  <\/span><\/span><\/li>\n
    4.         CALL pro_users();  <\/span><\/li>\n
    5.     END<\/span>$$  <\/span><\/span><\/li>\n
    6.   <\/span><\/li>\n
    7. DELIMITER ;  <\/span><\/li>\n<\/ol>\n

      \u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u89e6\u53d1\u5668\u540d\u5b57\uff1aeve_users\u3002<\/p>\n

      \u7b2c\u56db\u6b65\uff1a\u6dfb\u52a0\u540e\u53f0\u83dc\u5355<\/p>\n

      1.\u6dfb\u52a0\u83dc\u5355URL<\/p>\n

      \u5728\u76ee\u5f55admin\/includes\/inc_menu.php\u7684-\u62a5\u8868\u7edf\u8ba1-\u7684\u90a3\u90e8\u5206\u4ee3\u7801\u4e0b\u9762\u6dfb\u52a0\uff1a<\/p>\n

        <\/p>\n

        \n
      1. $modules<\/span>[<\/span>’06_stats’<\/span>][<\/span>‘user_situation’<\/span>]  = <\/span>‘user_situation.php?act=list’<\/span>;  <\/span><\/span><\/li>\n<\/ol>\n

        2.\u6dfb\u52a0\u83dc\u5355\u540d\u79f0<\/p>\n

        \u5728\u76ee\u5f55languages\/zh_cn\/admin\/common.php\u7684\/* \u62a5\u8868\u7edf\u8ba1 *\/\u7684\u90a3\u90e8\u5206\u4ee3\u7801\u4e0b\u9762\u6dfb\u52a0\uff1a<\/p>\n

          <\/p>\n

          \n
        1. $_LANG<\/span>[<\/span>‘user_situation’<\/span>] = <\/span>‘\u7528\u6237\u60c5\u51b5’<\/span>;  <\/span><\/span><\/li>\n<\/ol>\n

          3.\u6dfb\u52a0\u83dc\u5355\u6743\u9650<\/p>\n

          \u5728\u76ee\u5f55admin\/includes\/inc_priv.php\u7684-\u62a5\u8868\u7edf\u8ba1\u6743\u9650-\u7684\u90a3\u90e8\u5206\u4ee3\u7801\u4e0b\u9762\u6dfb\u52a0\uff1a<\/p>\n

          $purview<\/span>
          \n[<\/span>
          \n‘user_situation’<\/span>
          \n]       = <\/span>
          \n‘user_situation’<\/span>
          \n;  <\/span> <\/p>\n

          4.\u6dfb\u52a0\u7ba1\u7406\u6743\u9650<\/p>\n

          \u5728\u76ee\u5f55languages\/zh_cn\/admin\/priv_action.php\u6dfb\u52a0\u4e0b\u9762\u7684\u4ee3\u7801\uff1a<\/p>\n

          $_LANG<\/span>
          \n[<\/span>
          \n‘user_situation’<\/span>
          \n] = <\/span>
          \n‘\u7528\u6237\u60c5\u51b5’<\/span>
          \n;  <\/span> <\/p>\n

          5.\u6dfb\u52a0\u6570\u636e\u5e93\u6743\u9650\u8bb0\u5f55<\/p>\n

          INSERT<\/span>
          \n <\/span>
          \nINTO<\/span>
          \n ecs_admin_action(parent_id,action_code) <\/span>
          \nVALUES<\/span>
          \n(6,<\/span>
          \n‘user_situation’<\/span>
          \n);  <\/span> <\/p>\n

          \u7b2c\u4e94\u6b65\uff1a\u4e1a\u52a1\u903b\u8f91\u4ee3\u7801<\/p>\n

          \u5728\u76ee\u5f55admin\u4e0b\u9762\u6dfb\u52a0user_situation.php\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n

            <\/p>\n

            \n
          1. <?php  <\/span><\/span><\/li>\n
          2. \/**<\/span> <\/span><\/li>\n
          3.  * add by zbl 2013-08-29<\/span> <\/span><\/li>\n
          4.  * \u65b0\u589e\u6ce8\u518c\u7528\u6237\uff0c\u7d2f\u79ef\u6ce8\u518c\u7528\u6237\uff0c\u6d3b\u8dc3\u7528\u6237-\u5468\u5185\u81f3\u5c11\u767b\u9646\uff11\u6b21\uff0c\u6bcf\u6708\u8bbf\u95ee\u91cf<\/span> <\/span><\/li>\n
          5.  * @var unknown_type<\/span> <\/span><\/li>\n
          6.  *\/<\/span>  <\/span><\/span><\/li>\n
          7. define(‘IN_ECS’<\/span>, true);  <\/span><\/span><\/li>\n
          8. \/\/\u9875\u9762\u5f15\u7528<\/span>  <\/span><\/span><\/li>\n
          9. require<\/span>(dirname(<\/span>__FILE__<\/span>) . <\/span>‘\/includes\/init.php’<\/span>);  <\/span><\/span><\/li>\n
          10. require_once<\/span>(ROOT_PATH . <\/span>‘\/’<\/span> . ADMIN_PATH . <\/span>‘\/includes\/lib_goods.php’<\/span>);  <\/span><\/span><\/li>\n
          11.   <\/span><\/li>\n
          12. if<\/span>(<\/span>$_REQUEST<\/span>[<\/span>‘act’<\/span>]==<\/span>‘list’<\/span>){  <\/span><\/span><\/li>\n
          13.       <\/span><\/li>\n
          14.     $user_situation<\/span>=get_user_situation();  <\/span><\/span><\/li>\n
          15.       <\/span><\/li>\n
          16.     $smarty<\/span>->assign(<\/span>‘user_situation_list’<\/span>, <\/span>$user_situation<\/span>[<\/span>‘user_situation_list’<\/span>]);  <\/span><\/span><\/li>\n
          17.     $smarty<\/span>->assign(<\/span>‘filter’<\/span>,       <\/span>$user_situation<\/span>[<\/span>‘filter’<\/span>]);  <\/span><\/span><\/li>\n
          18.     $smarty<\/span>->assign(<\/span>‘record_count’<\/span>, <\/span>$user_situation<\/span>[<\/span>‘record_count’<\/span>]);  <\/span><\/span><\/li>\n
          19.     $smarty<\/span>->assign(<\/span>‘page_count’<\/span>,   <\/span>$user_situation<\/span>[<\/span>‘page_count’<\/span>]);  <\/span><\/span><\/li>\n
          20.     $smarty<\/span>->assign(<\/span>‘full_page’<\/span>,    1);<\/span>\/\/\u89e3\u51b3\u5206\u9875\u67e5\u8be2\u51fa\u73b0\u9875\u9762\u91cd\u590d\u60c5\u51b5<\/span>  <\/span><\/span><\/li>\n
          21.       <\/span><\/li>\n
          22.     $smarty<\/span>->assign(<\/span>‘ur_here’<\/span>, <\/span>$_LANG<\/span>[<\/span>‘user_situation’<\/span>]);  <\/span><\/span><\/li>\n
          23.       <\/span><\/li>\n
          24.     \/* \u5728\u9875\u811a\u663e\u793a\u5185\u5b58\u4fe1\u606f *\/<\/span>  <\/span><\/span><\/li>\n
          25.     assign_query_info();  <\/span><\/li>\n
          26.     $smarty<\/span>->display(<\/span>‘user_situation.htm’<\/span>);  <\/span><\/span><\/li>\n
          27.       <\/span><\/li>\n
          28. }elseif<\/span>(<\/span>$_REQUEST<\/span>[<\/span>‘act’<\/span>]==<\/span>‘query’<\/span>){  <\/span><\/span><\/li>\n
          29.       <\/span><\/li>\n
          30.     $user_situation<\/span>=get_user_situation();  <\/span><\/span><\/li>\n
          31.       <\/span><\/li>\n
          32.     $smarty<\/span>->assign(<\/span>‘user_situation_list’<\/span>, <\/span>$user_situation<\/span>[<\/span>‘user_situation_list’<\/span>]);  <\/span><\/span><\/li>\n
          33.     $smarty<\/span>->assign(<\/span>‘filter’<\/span>,       <\/span>$user_situation<\/span>[<\/span>‘filter’<\/span>]);  <\/span><\/span><\/li>\n
          34.     $smarty<\/span>->assign(<\/span>‘record_count’<\/span>, <\/span>$user_situation<\/span>[<\/span>‘record_count’<\/span>]);  <\/span><\/span><\/li>\n
          35.     $smarty<\/span>->assign(<\/span>‘page_count’<\/span>,   <\/span>$user_situation<\/span>[<\/span>‘page_count’<\/span>]);  <\/span><\/span><\/li>\n
          36.       <\/span><\/li>\n
          37.     $smarty<\/span>->assign(<\/span>‘ur_here’<\/span>, <\/span>$_LANG<\/span>[<\/span>‘user_situation’<\/span>]);  <\/span><\/span><\/li>\n
          38.     $tpl<\/span> =  <\/span>‘user_situation.htm’<\/span>;  <\/span><\/span><\/li>\n
          39.     make_json_result($smarty<\/span>->fetch(<\/span>$tpl<\/span>), <\/span>”<\/span>,<\/span>array<\/span>(<\/span>‘filter’<\/span> => <\/span>$user_situation<\/span>[<\/span>‘filter’<\/span>], <\/span>‘page_count’<\/span> => <\/span>$user_situation<\/span>[<\/span>‘page_count’<\/span>]));  <\/span><\/span><\/li>\n
          40. }  <\/span><\/li>\n
          41. ?>  <\/span><\/li>\n<\/ol>\n

            \u8bf4\u660e\uff1a\u8fd9\u91cc\u6709\u4e24\u4e2a\u65b9\u6cd5\uff0c\u4e00\u4e2a\u662f\u5217\u8868\u6570\u636e\u67e5\u8be2\uff0c\u53e6\u5916\u4e00\u4e2a\u662f\u5206\u9875\u67e5\u8be2\uff0c\u6bcf\u884c\u7684\u4ee3\u7801\u89e3\u6790\u5c31\u4e0d\u8be6\u7ec6\u8bf4\u3002<\/p>\n

            \u7b2c\u516d\u6b65\uff1a\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/span> <\/p>\n

            \u5728\u76ee\u5f55admin\/includes\/lib_goods.php\u91cc\u9762\u6dfb\u52a0get_user_situation\uff08\uff09\u65b9\u6cd5\uff1a<\/p>\n

              <\/p>\n

              \n
            1. \/**<\/span> <\/span><\/li>\n
            2.  * zbl add 20130902<\/span> <\/span><\/li>\n
            3.  * Enter description here …<\/span> <\/span><\/li>\n
            4.  *\/<\/span>  <\/span><\/span><\/li>\n
            5. function<\/span> get_user_situation(){  <\/span><\/span><\/li>\n
            6.     \/\/\u5206\u9875<\/span>  <\/span><\/span><\/li>\n
            7.     $filter<\/span>[<\/span>‘record_count’<\/span>]=<\/span>$GLOBALS<\/span>[<\/span>‘db’<\/span>]->GetOne(<\/span>‘SELECT count(*) FROM ‘<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘user_situation’<\/span>));  <\/span><\/span><\/li>\n
            8.     $filter<\/span> = page_and_size(<\/span>$filter<\/span>);  <\/span><\/span><\/li>\n
            9.       <\/span><\/li>\n
            10.     \/\/\u6392\u5e8f<\/span>  <\/span><\/span><\/li>\n
            11.     $filter<\/span>[<\/span>‘sort_by’<\/span>]    = <\/span>empty<\/span>(<\/span>$_REQUEST<\/span>[<\/span>‘sort_by’<\/span>]) ? <\/span>‘week_time’<\/span> : trim(<\/span>$_REQUEST<\/span>[<\/span>‘sort_by’<\/span>]);  <\/span><\/span><\/li>\n
            12.     $filter<\/span>[<\/span>‘sort_order’<\/span>] = <\/span>empty<\/span>(<\/span>$_REQUEST<\/span>[<\/span>‘sort_order’<\/span>]) ? <\/span>‘DESC’<\/span> : trim(<\/span>$_REQUEST<\/span>[<\/span>‘sort_order’<\/span>]);  <\/span><\/span><\/li>\n
            13.       <\/span><\/li>\n
            14.     \/\/\u67e5\u8be2<\/span>  <\/span><\/span><\/li>\n
            15.     $sql<\/span>=<\/span>‘SELECT week_count,user_count,over_count,month_count,week_time FROM ‘<\/span>.<\/span>$GLOBALS<\/span>[<\/span>‘ecs’<\/span>]->table(<\/span>‘user_situation’<\/span>).<\/span>‘ order by ‘<\/span>.<\/span>$filter<\/span>[sort_by].<\/span>‘ ‘<\/span>.<\/span>$filter<\/span>[sort_order].<\/span>‘ LIMIT ‘<\/span> . <\/span>$filter<\/span>[<\/span>‘start’<\/span>] . <\/span>‘,’<\/span> . <\/span>$filter<\/span>[page_size];  <\/span><\/span><\/li>\n
            16.     \/\/echo $sql;<\/span>  <\/span><\/span><\/li>\n
            17.     $row<\/span> = <\/span>$GLOBALS<\/span>[<\/span>‘db’<\/span>]->getAll(<\/span>$sql<\/span>);  <\/span><\/span><\/li>\n
            18.       <\/span><\/li>\n
            19.     \/\/\u8fd4\u56de\u6570\u636e<\/span>  <\/span><\/span><\/li>\n
            20.     return<\/span> <\/span>array<\/span>(<\/span>‘user_situation_list’<\/span> => <\/span>$row<\/span>, <\/span>‘filter’<\/span> => <\/span>$filter<\/span>, <\/span>‘page_count’<\/span> => <\/span>$filter<\/span>[<\/span>‘page_count’<\/span>], <\/span>‘record_count’<\/span> => <\/span>$filter<\/span>[<\/span>‘record_count’<\/span>]);  <\/span><\/span><\/li>\n
            21. }  <\/span><\/li>\n<\/ol>\n

              \u8bf4\u660e\uff1a\u8fd9\u91cc\u7684\u4ee3\u7801\u987a\u5e8f\u4e0d\u80fd\u653e\u9519\uff0c$sql\u7684where\u540e\u9762\u67e5\u8be2\u6761\u4ef6\u5fc5\u987b\u52a0\u4e0a\u624d\u53ef\u4ee5\u5b9e\u73b0\u5206\u9875\u529f\u80fd\uff0c\u6240\u4ee5$filter[‘sort_by’]\u548c$filter[‘sort_order’]\u8fd9\u4e24\u4e2a\u53c2\u6570\u4e0d\u80fd\u7f3a\u5c11\uff0c\u8be6\u7ec6\u8bf7\u67e5\u770b\/admin\/js\/listtable.js\u7684listTable.sort\uff08\uff09\u65b9\u6cd5\u3002<\/span> <\/p>\n

              \u7b2c\u4e03\u6b65\uff1a\u6dfb\u52a0\u663e\u793a\u9875\u9762<\/p>\n

              \u5728\u76ee\u5f55\/admin\/templates\u4e0b\u9762\u6dfb\u52a0user_situation.htm\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n

                <\/p>\n

                \n
              1. <!– $Id: user_situation.htm 16752 2013-08-28  zbl $ –><\/span>  <\/span><\/span><\/li>\n
              2. {if $full_page}  <\/span><\/li>\n
              3. {include file<\/span>=<\/span>“pageheader.htm”<\/span>}  <\/span><\/span><\/li>\n
              4. {insert_scripts files<\/span>=<\/span>“..\/js\/utils.js,listtable.js”<\/span>}  <\/span><\/span><\/li>\n
              5.   <\/span><\/li>\n
              6. <<\/span>form<\/span> <\/span>method<\/span>=<\/span>“post”<\/span> <\/span>action<\/span>=<\/span>“”<\/span> <\/span>name<\/span>=<\/span>“listForm”<\/span> <\/span>onsubmit<\/span>=<\/span>“return confirmSubmit(this)”<\/span>><\/span>  <\/span><\/span><\/li>\n
              7. <<\/span>div<\/span> <\/span>class<\/span>=<\/span>“list-div”<\/span> <\/span>id<\/span>=<\/span>“listDiv”<\/span>><\/span>  <\/span><\/span><\/li>\n
              8. {\/if}  <\/span><\/li>\n
              9.     <<\/span>table<\/span> <\/span>cellpadding<\/span>=<\/span>“3”<\/span> <\/span>cellspacing<\/span>=<\/span>“1”<\/span>><\/span>  <\/span><\/span><\/li>\n
              10.       <<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              11.         <<\/span>th<\/span>><\/span><<\/span>a<\/span> <\/span>href<\/span>=<\/span>“javascript:listTable.sort(‘week_time’); “<\/span>><\/span>{$lang.week_time}<\/span><\/<\/span>a<\/span>><\/span><\/<\/span>th<\/span>><\/span>  <\/span><\/span><\/li>\n
              12.         <<\/span>th<\/span>><\/span><<\/span>a<\/span> <\/span>href<\/span>=<\/span>“javascript:listTable.sort(‘week_count’); “<\/span>><\/span>{$lang.week_count}<\/span><\/<\/span>a<\/span>><\/span><\/<\/span>th<\/span>><\/span>  <\/span><\/span><\/li>\n
              13.         <<\/span>th<\/span>><\/span><<\/span>a<\/span> <\/span>href<\/span>=<\/span>“javascript:listTable.sort(‘user_count’); “<\/span>><\/span>{$lang.user_count}<\/span><\/<\/span>a<\/span>><\/span><\/<\/span>th<\/span>><\/span>  <\/span><\/span><\/li>\n
              14.         <<\/span>th<\/span>><\/span><<\/span>a<\/span> <\/span>href<\/span>=<\/span>“javascript:listTable.sort(‘over_count’); “<\/span>><\/span>{$lang.over_count}<\/span><\/<\/span>a<\/span>><\/span><\/<\/span>th<\/span>><\/span>  <\/span><\/span><\/li>\n
              15.         <<\/span>th<\/span>><\/span><<\/span>a<\/span> <\/span>href<\/span>=<\/span>“javascript:listTable.sort(‘month_count’); “<\/span>><\/span>{$lang.month_count}<\/span><\/<\/span>a<\/span>><\/span><\/<\/span>th<\/span>><\/span>  <\/span><\/span><\/li>\n
              16.       <<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              17.       {foreach from<\/span>=$user_situation_list <\/span>item<\/span>=<\/span>user_situation<\/span>}  <\/span><\/span><\/li>\n
              18.           <<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              19.             <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“center”<\/span>><\/span>{$user_situation.week_time}<\/span><\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              20.             <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“center”<\/span>><\/span>{$user_situation.week_count}<\/span><\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              21.             <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“center”<\/span>><\/span>{$user_situation.user_count}<\/span><\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              22.             <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“center”<\/span>><\/span>{$user_situation.over_count}<\/span><\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              23.             <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“center”<\/span>><\/span>{$user_situation.month_count}<\/span><\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              24.           <\/<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              25.       {foreachelse}  <\/span><\/li>\n
              26.           <<\/span>tr<\/span>><\/span><<\/span>td<\/span> <\/span>class<\/span>=<\/span>“no-records”<\/span> <\/span>colspan<\/span>=<\/span>“10”<\/span>><\/span>{$lang.no_records}<\/span><\/<\/span>td<\/span>><\/span><\/<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              27.       {\/foreach}  <\/span><\/li>\n
              28.     <\/<\/span>table<\/span>><\/span>  <\/span><\/span><\/li>\n
              29.       <\/span><\/li>\n
              30.     <!– \u5206\u9875 –><\/span>  <\/span><\/span><\/li>\n
              31.     <<\/span>table<\/span> <\/span>id<\/span>=<\/span>“page-table”<\/span> <\/span>cellspacing<\/span>=<\/span>“0”<\/span>><\/span>  <\/span><\/span><\/li>\n
              32.       <<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              33.         <<\/span>td<\/span> <\/span>align<\/span>=<\/span>“right”<\/span> <\/span>nowrap<\/span>=<\/span>“true”<\/span>><\/span>  <\/span><\/span><\/li>\n
              34.         {include file<\/span>=<\/span>“page.htm”<\/span>}  <\/span><\/span><\/li>\n
              35.         <\/<\/span>td<\/span>><\/span>  <\/span><\/span><\/li>\n
              36.       <\/<\/span>tr<\/span>><\/span>  <\/span><\/span><\/li>\n
              37.     <\/<\/span>table<\/span>><\/span>  <\/span><\/span><\/li>\n
              38. {if $full_page}  <\/span><\/li>\n
              39. <\/<\/span>div<\/span>><\/span>  <\/span><\/span><\/li>\n
              40. <\/<\/span>form<\/span>><\/span>  <\/span><\/span><\/li>\n
              41. <<\/span>script<\/span> <\/span>type<\/span>=<\/span>“text\/javascript”<\/span>><\/span>  <\/span><\/span><\/li>\n
              42.   listTable.recordCount<\/span> = {$record_count};  <\/span><\/span><\/li>\n
              43.   listTable.pageCount<\/span> = {$page_count};  <\/span><\/span><\/li>\n
              44.   {foreach from<\/span>=$filter <\/span>item<\/span>=<\/span>item<\/span> <\/span>key<\/span>=<\/span>key<\/span>}  <\/span><\/span><\/li>\n
              45.   listTable.filter.{$key} = ‘{$item}’;  <\/span><\/li>\n
              46.   {\/foreach}  <\/span><\/li>\n
              47. <\/<\/span>script<\/span>><\/span>  <\/span><\/span><\/li>\n
              48. {include file<\/span>=<\/span>“pagefooter.htm”<\/span>}  <\/span><\/span><\/li>\n
              49. {\/if}  <\/span><\/li>\n<\/ol>\n

                \u8bf4\u660e\uff1ahtml\u9875\u9762\u6ce8\u610f\u5f15\u5165js\u6587\u4ef6\u548c\u7528{if $full_page}{\/if}\u6765\u5305\u542b\u9996\u4f4d\u4ee3\u7801\u6765\u89e3\u51b3\u5206\u9875\u67e5\u8be2\u51fa\u73b0\u7684\u91cd\u590d\u9875\u9762\u3002<\/span> <\/p>\n

                 <\/p>\n

                \u7b2c\u516b\u6b65\uff1a\u6dfb\u52a0\u663e\u793a\u9875\u9762\u7684\u5217\u8868\u540d\u5b57<\/p>\n

                \u5728\u76ee\u5f55languages\/zh_cn\/admin\/\u4e0b\u9762\u6dfb\u52a0user_situation.php\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n

                <?php  <\/span> <\/p>\n

                  \n
                1. \/**<\/span> <\/span><\/li>\n
                2.  * add by zbl 2013-08-30<\/span> <\/span><\/li>\n
                3.  * Enter description here …<\/span> <\/span><\/li>\n
                4.  * @var unknown_type<\/span> <\/span><\/li>\n
                5.  *\/<\/span>  <\/span><\/span><\/li>\n
                6. $_LANG<\/span>[<\/span>‘week_time’<\/span>] = <\/span>‘\u65f6\u95f4’<\/span>;  <\/span><\/span><\/li>\n
                7. $_LANG<\/span>[<\/span>‘week_count’<\/span>] = <\/span>‘\u6bcf\u5468\u6ce8\u518c\u7528\u6237\u6570’<\/span>;  <\/span><\/span><\/li>\n
                8. $_LANG<\/span>[<\/span>‘user_count’<\/span>] = <\/span>‘\u7d2f\u79ef\u6ce8\u518c\u7528\u6237\u6570’<\/span>;  <\/span><\/span><\/li>\n
                9. $_LANG<\/span>[<\/span>‘over_count’<\/span>] = <\/span>‘\u6bcf\u5468\u6d3b\u8dc3\u7528\u6237\u6570’<\/span>;  <\/span><\/span><\/li>\n
                10. $_LANG<\/span>[<\/span>‘month_count’<\/span>] = <\/span>‘\u6bcf\u6708\u8bbf\u95ee\u91cf’<\/span>;  <\/span><\/span><\/li>\n
                11. ?>  <\/span><\/li>\n<\/ol>\n

                  \u7b2c\u4e5d\u6b65\uff1a\u6d4b\u8bd5\u8fd0\u884c<\/span> <\/p>\n

                   <\/p>\n

                   <\/p>\n

                  \"ecshop\u540e\u53f0\u6dfb\u52a0\u4e00\u4e2a\u5b8c\u6574\u7684\u7edf\u8ba1\u7528\u6237\u4fe1\u606f\u7684\u529f\u80fd\u63d2\u56fe1\"<\/p>\n

                  \u8bf4\u660e\uff1a\u672c\u4eba\u8fd9\u91cc\u90fd\u662f\u4fee\u6539\u89e6\u53d1\u5668\u51fa\u73b0\u7684\u5f53\u5929\u6570\u636e\u3002<\/p>\n

                   <\/p>\n

                  \u8fd9\u4e2a\u6d41\u7a0b\u4ece\u4fee\u6539\u6570\u636e\u5e93\u5230\u9876\u5c42\u9875\u9762\u90fd\u6709\u8bf4\u660e\uff0cecshop\u7684\u4e8c\u6b21\u5f00\u53d1\u6309\u7167\u8fd9\u4e2a\u6d41\u7a0b\u57fa\u672c\u80fd\u5f00\u53d1\u6240\u6709\u529f\u80fd\u4e86\u3002\u8be6\u7ec6\u7684\u529f\u80fd\u5b9e\u73b0\u4ee3\u7801\u518d\u6162\u6162\u7814\u7a76\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

                  \u5f00\u53d1ecshop\u5927\u6982\u6709\u534a\u5e74\u591a\u65f6\u95f4\u4e86\uff0c\u6bcf\u6b21\u6539\u7684\u529f\u80fd\u4e5f\u6ca1\u6709\u505a\u603b\u7ed3\u548c\u8bb0\u5f55\uff0c\u4eca\u5929\u6dfb\u52a0\u5b8c\u4e00\u4e2a\u529f\u80fd\uff0c\u8bb0\u5f55\u4e00\u4e0b\u5427\uff0c\u7701\u5f97\u4ee5\u540e\u5fd8\u8bb0\u53c8\u8981\u9ebb\u70e6\u53bb\u67e5\u627e\u3002 \u9700\u6c42:\u5728\u540e\u53f0\u83dc\u5355-\u62a5\u8868\u7edf\u8ba1-\u4e0b\u9762\u6dfb\u52a0-\u7528\u6237\u60c5\u51b5-\u7684\u529f\u80fd\uff0c\u5305\u62ec\uff1a\u6bcf\u5468\u65b0\u589e\u6ce8\u518c\u7528\u6237\uff0c\u6bcf\u5468\u7d2f\u79ef\u6ce8\u518c\u7528\u6237\uff0c\u6d3b\u8dc3\u7528\u6237-\u5468\u5185\u81f3\u5c11\u767b\u9646\uff11\u6b21\uff0c\u6bcf\u6708\u8bbf\u95ee\u91cf\u7b49\u7b49\u3002 \u7b2c\u4e00\u6b65\uff1a\u5efa\u7acb\u6570\u636e\u5e93\u7684\u8868   \u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u6570\u636e\u5e93\u662f\uff1aeshop\uff0c\u65b0\u5efa\u8868\u540d\uff1aecs_user_situation\u3002 \u7b2c\u4e8c\u6b65\uff1a\u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b DELIMITER $$      DROP PROCEDURE IF EXISTS `eshop`.`pro_users`$$      CREATE DEFINER=`root`@`localhost` PROCEDURE `pro_users`()   BEGIN       DECLARE week_count INT;       DECLARE user_count INT;       DECLARE over_count INT;       DECLARE month_count INT;       — \u6bcf\u5468\u6ce8\u518c\u7528\u6237       SELECT COUNT(*) INTO week_count FROM ecs_users WHERE reg_time>(UNIX_TIMESTAMP(NOW())-7*24*60*60);       — \u603b\u6ce8\u518c\u7528\u6237       SELECT COUNT(*) INTO user_count FROM ecs_users;       — \u6bcf\u5468\u7684\u6d3b\u8dc3\u7528\u6237       SELECT COUNT(*) INTO over_count FROM ecs_users WHERE last_login>(UNIX_TIMESTAMP(NOW())-7*24*60*60);       — \u6bcf\u6708\u7684\u8bbf\u95ee\u91cf       SELECT COUNT(*) INTO month_count FROM ecs_stats WHERE access_time>UNIX_TIMESTAMP(DATE_SUB(DATE_SUB(DATE_FORMAT(NOW(),‘%y-%m-%d 00:00:00’),INTERVAL EXTRACT(DAY FROM NOW())-1 DAY),INTERVAL 0 MONTH));              INSERT INTO ecs_user_situation(week_count,user_count,over_count,month_count,week_time) VALUES (week_count,user_count,over_count,month_count,NOW());       END$$      DELIMITER ;   \u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u5b58\u50a8\u8fc7\u7a0b\u540d\u5b57\uff1apro_users\u3002 \u7b2c\u4e09\u6b65\uff1a\u5efa\u7acb\u89e6\u53d1\u5668 [sql] view plaincopyprint?   DELIMITER $$      ALTER EVENT `eve_users` ON SCHEDULE EVERY 1 HOUR STARTS ‘2013-09-02 12:11:14’ ON COMPLETION PRESERVE ENABLE DO BEGIN           CALL pro_users();       END$$      DELIMITER ;   \u8bf4\u660e\uff1a\u4e2a\u4eba\u672c\u5730\u89e6\u53d1\u5668\u540d\u5b57\uff1aeve_users\u3002 \u7b2c\u56db\u6b65\uff1a\u6dfb\u52a0\u540e\u53f0\u83dc\u5355 1.\u6dfb\u52a0\u83dc\u5355URL \u5728\u76ee\u5f55admin\/includes\/inc_menu.php\u7684-\u62a5\u8868\u7edf\u8ba1-\u7684\u90a3\u90e8\u5206\u4ee3\u7801\u4e0b\u9762\u6dfb\u52a0\uff1a   $modules[’06_stats’][‘user_situation’]  = ‘user_situation.php?act=list’;   2.\u6dfb\u52a0\u83dc\u5355\u540d\u79f0 \u5728\u76ee\u5f55languages\/zh_cn\/admin\/common.php\u7684\/* \u62a5\u8868\u7edf\u8ba1 *\/\u7684\u90a3\u90e8\u5206\u4ee3\u7801\u4e0b\u9762\u6dfb\u52a0\uff1a   $_LANG[‘user_situation’] = ‘\u7528\u6237\u60c5\u51b5’;   3.\u6dfb\u52a0\u83dc\u5355\u6743\u9650 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-59462","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=59462"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59462\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}