| | |
| | | public class GwStatisV3 : PageHandler<SysUser> |
| | | { |
| | | private GwStatisV3Dao _Dao = new GwStatisV3Dao(); |
| | | private GwOrderDao orderDao = new GwOrderDao(); |
| | | private GwSpPrePatternDao spPrePatternDao = new GwSpPrePatternDao(); |
| | | private GwAuditCacheDao gwAuditCacheDao = new GwAuditCacheDao(); |
| | | private GwEventLogDao gwEventLogDao = new GwEventLogDao(); |
| | | |
| | | private int _userId = -1; |
| | | private int _userType = -1; |
| | | private string _userType = ""; |
| | | private string _account = ""; |
| | | |
| | | public override JsonPageResult ProcessRequestInternal(PageContext<Model.SysUser> context) |
| | |
| | | |
| | | private JsonPageResult GetRealtimeStatis5m(PageContext<SysUser> context) |
| | | { |
| | | |
| | | string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null); |
| | | |
| | | var oplist = _Dao.GetRealtimeStatis5mOut(); |
| | | var aplist = _Dao.GetRealtimeStatis5mIn(); |
| | | |
| | | //活动客户:客户-发送量【当日】 |
| | | var activeClientDayList = _Dao.GetActiveClientDay(permissionsSQL); |
| | | //通道-发送量【当日】 |
| | | var opSendDayList = _Dao.GetOpSendDay(permissionsSQL); |
| | | //产品-发送量【当日】 |
| | | var productSendDayList = _Dao.GetProductSendDay(permissionsSQL); |
| | | //订单:今日已完成订单 |
| | | var orderDayList = orderDao.GetOrderDay(permissionsSQL); |
| | | //订单:待审核订单 |
| | | var orderAuditList = orderDao.GetOrderAudit(permissionsSQL); |
| | | //发送内容:待审核 |
| | | var sendAuditList = gwAuditCacheDao.GetSendAudit(permissionsSQL); |
| | | //发送内容:二次待审核 |
| | | var sendAuditTowList = gwAuditCacheDao.GetSendAuditTow(permissionsSQL); |
| | | //账号报备内容:待审核 |
| | | var spPrePatternAuditList = spPrePatternDao.GetSpPrePatternAudit(permissionsSQL); |
| | | //通道状态 |
| | | var opStatusList = gwEventLogDao.GetOpStatus(permissionsSQL); |
| | | |
| | | |
| | | |
| | | return new JsonPageResult(true, new { ApList = aplist, OpList = oplist } ); |
| | | return new JsonPageResult(true, new { |
| | | ApList = aplist, |
| | | OpList = oplist, |
| | | ActiveClientDayList = activeClientDayList, |
| | | OpSendDayList = opSendDayList, |
| | | ProductSendDayList = productSendDayList, |
| | | OrderDayList = orderDayList, |
| | | OrderAuditList = orderAuditList, |
| | | SendAuditList = sendAuditList, |
| | | SendAuditTowList = sendAuditTowList, |
| | | SpPrePatternAuditList = spPrePatternAuditList, |
| | | OpStatusList = opStatusList |
| | | } ); |
| | | } |
| | | private string GetApName(List<GwAp>aplist, int apID) |
| | | { |
| | |
| | | string opID = context.GetString("opid"); |
| | | string statistype = context.GetString("statistype"); |
| | | StatisOption statisoption = (StatisOption)context.GetInt("statisoption"); |
| | | |
| | | string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null); |
| | | |
| | | List<GwOp> opList; |
| | | |
| | |
| | | |
| | | using (GwClientDao dao = new GwClientDao()) |
| | | { |
| | | clientList = dao.LoadInfoList("", "", "", ""); |
| | | clientList = dao.LoadInfoList("", "", "", "", permissionsSQL); |
| | | } |
| | | |
| | | List<GwAp> apList; |
| | |
| | | |
| | | apList = dao.LoadInfoList("", "", "", out recordCount, 99999, 1); |
| | | } |
| | | |
| | | //var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, (StatisOption)statisoption); |
| | | |
| | | //根据系统用户获取有权限客户 |
| | | string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null); |
| | | |
| | | var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, permissionsSQL, (StatisOption)statisoption); |
| | | |
| | | System.Text.StringBuilder sb = new System.Text.StringBuilder(); |