数据处理三之 用户在线时长和登录次数统计

1. 数据
   2016-04-18 16:00:00 {“areacode”:”浙江省丽水市”,”countAll”:0,”countCorrect”:0,”datatime”:”4134362”,”logid”:”201604181600001184409476”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966390499\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”100\”,\”imei\”:\”12345678900987654321\”,\”subjectNum\”:\”13989589062\”,\”imsi\”:\”12345678900987654321\”,\”queryNum\”:\”13989589062\”}”,”requestip”:”36.16.128.234”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”宁夏银川市”,”countAll”:0,”countCorrect”:0,”datatime”:”4715990”,”logid”:”201604181600001858043208”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966400120\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”1210\”,\”imei\”:\”A0000044ABFD25\”,\”subjectNum\”:\”15379681917\”,\”imsi\”:\”460036951451601\”,\”queryNum\”:\”\”}”,”requestip”:”115.168.93.87”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”,”userAgent”:”ZTE-Me/Mobile”}
   2016-04-18 16:00:00 {“areacode”:”黑龙江省哈尔滨市”,”countAll”:0,”countCorrect”:0,”datatime”:”5369561”,”logid”:”201604181600001068429609”,”requestinfo”:”{\”interfaceUserName\”:\”12345678900987654321\”,\”queryNum\”:\”\”,\”timestamp\”:\”1460966400139\”,\”sign\”:\”4\”,\”imsi\”:\”460030301212545\”,\”imei\”:\”35460207765269\”,\”subjectNum\”:\”55588237\”,\”subjectPro\”:\”123456\”,\”remark\”:\”4\”,\”channelno\”:\”2100\”}”,”requestip”:”42.184.41.180”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”浙江省丽水市”,”countAll”:0,”countCorrect”:0,”datatime”:”4003096”,”logid”:”201604181600001648238807”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966391025\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”100\”,\”imei\”:\”12345678900987654321\”,\”subjectNum\”:\”13989589062\”,\”imsi\”:\”12345678900987654321\”,\”queryNum\”:\”13989589062\”}”,”requestip”:”36.16.128.234”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”广西南宁市”,”countAll”:0,”countCorrect”:0,”datatime”:”4047993”,”logid”:”201604181600001570024205”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966382871\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”1006\”,\”imei\”:\”A000004853168C\”,\”subjectNum\”:\”07765232589\”,\”imsi\”:\”460031210400007\”,\”queryNum\”:\”13317810717\”}”,”requestip”:”219.159.72.3”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”海南省五指山市”,”countAll”:0,”countCorrect”:0,”datatime”:”5164117”,”logid”:”201604181600001227842048”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966399159\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”1017\”,\”imei\”:\”A000005543AFB7\”,\”subjectNum\”:\”089836329061\”,\”imsi\”:\”460036380954376\”,\”queryNum\”:\”13389875751\”}”,”requestip”:”140.240.171.71”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”山西省”,”countAll”:0,”countCorrect”:0,”datatime”:”14075772”,”logid”:”201604181600001284030648”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966400332\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”1006\”,\”imei\”:\”A000004FE0218A\”,\”subjectNum\”:\”03514043633\”,\”imsi\”:\”460037471517070\”,\”queryNum\”:\”\”}”,”requestip”:”1.68.5.227”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”四川省”,”countAll”:0,”countCorrect”:0,”datatime”:”6270982”,”logid”:”201604181600001173504863”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966398896\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”100\”,\”imei\”:\”12345678900987654321\”,\”subjectNum\”:\”13666231300\”,\”imsi\”:\”12345678900987654321\”,\”queryNum\”:\”13666231300\”}”,”requestip”:”182.144.66.97”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”010005”,”responsedata”:”无查询结果”}
   2016-04-18 16:00:00 {“areacode”:”浙江省”,”countAll”:0,”countCorrect”:0,”datatime”:”4198522”,”logid”:”201604181600001390637240”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966399464\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”12345678900987654321\”,\”channelno\”:\”100\”,\”imei\”:\”12345678900987654321\”,\”subjectNum\”:\”05533876327\”,\”imsi\”:\”12345678900987654321\”,\”queryNum\”:\”05533876327\”}”,”requestip”:”36.23.9.49”,”requesttime”:”2016-04-18 16:00:00”,”requesttype”:”0”,”responsecode”:”000000”,”responsedata”:”操作成功”}
   2016-04-18 16:00:00 {“areacode”:”江苏省连云港市”,”countAll”:0,”countCorrect”:0,”datatime”:”4408097”,”logid”:”201604181600001249944032”,”requestinfo”:”{\”sign\”:\”4\”,\”timestamp\”:\”1460966395908\”,\”remark\”:\”4\”,\”subjectPro\”:\”123456\”,\”interfaceUserName\”:\”1