wzp
2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1
web/web/GwStatisV3.ashx
@@ -10,8 +10,13 @@
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)
@@ -34,10 +39,46 @@
    
    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)
    {
@@ -81,6 +122,8 @@
        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;
        
@@ -93,7 +136,7 @@
        
        using (GwClientDao dao = new GwClientDao())
        {
             clientList = dao.LoadInfoList("", "", "", "");
             clientList = dao.LoadInfoList("", "", "", "", permissionsSQL);
        }
        
        List<GwAp> apList;
@@ -104,10 +147,10 @@
             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();
@@ -149,8 +192,6 @@
        sb.Append(@"</tr>");
        int i = 0;
        foreach (GwStatisV3Item item in list)
        {