对学校老师工作统计用ES的实现

数据统计 批改网

一、需要统计的项目

二、数据来源SQL

请求：

post :http://qq.com/_sql
select * from pigaimember where school='深圳技术大学' and ts=1 limit 10000

curl：

curl 'http://qq.com/_sql' \
-H 'Connection: keep-alive' \
-H 'Accept: application/json, text/javascript, /; q=0.01' \
-H 'X-Requested-With: XMLHttpRequest' \
-H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36' \
-H 'Content-Type: application/json;charset=UTF-8' \
--data-binary $'select * from pigaimember where school="深圳技术大学 and ts=1 limit 10000'\
--compressed \
--insecure

jquery ajax:

obj={
ajax: function (sql, success) {
                var app = this;
                //console.log(app.sql);
                return $.ajax({
                    url: "http://qq.com/_sql",
                    type: "POST",
                    // async:false,
                    data: sql,
                    contentType: "application/json;charset=utf-8",
                    dataType: 'json',
                    success: success
                });
            }
};
obj.ajax('select * from pigaimember where school="深圳技术大学 and ts=1 limit 10000'
,function(rep){
console.log('rep',rep);
});

2.1 批改账号 pm

select * from pigaimember where school='深圳技术大学' and ts=1 limit 10000

2.2 收到学生作文 提交篇次 pe2

以老师为目标 统计 提交是作文数 提交篇次

SELECT t_user_id, count(*) as cnt,sum(version) as version_cnt FROM pigaiessay where school='深圳技术大学' group by t_user_id limit 10000

2.3 老师人工批改篇次 pe3

以老师为目标 统计 老师批改网的人工 作文数

SELECT t_user_id, count(*) as pigai_cnt FROM pigaiessay where school='深圳技术大学' and type=2 group by t_user_id limit 10000

2.4 老师布置 pr4

以老师为目标 统计 布置的作文数

select user_id , count(*) as request_cnt from pigairequest where school='深圳技术大学' group by user_id limit 10000