package com.shlanbao.tzsc.pms.sys.user.service.impl;

import java.util.Date;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.SchStatFaultDaoI;
import com.shlanbao.tzsc.base.dao.SysUserDaoI;
import com.shlanbao.tzsc.base.mapping.SchStatFault;
import com.shlanbao.tzsc.base.mapping.SysModelPermis;
import com.shlanbao.tzsc.base.mapping.SysUser;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.sys.user.beans.UserBean;
import com.shlanbao.tzsc.pms.sys.user.service.UserServiceI;
import com.shlanbao.tzsc.pms.sys.user.service.schStatFaultServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.MD5Util;
import com.shlanbao.tzsc.utils.tools.StringUtil;
/**
 * 用户管理业务实现类
 * @author Leejean
 * @create 2014年9月16日上午10:43:37
 */
@Service
public class schStatFaultServiceImpl extends BaseService implements schStatFaultServiceI{
	@Autowired
	private SchStatFaultDaoI schStatDao;

	@Override
	public List<?> getSchStatFault() {
		// TODO Auto-generated method stub
		StringBuffer sb =new StringBuffer();
		sb.append(" SELECT * FROM ( SELECT scf.*, ROWNUM AS rowno FROM ( ");
		sb.append(" SELECT NAME,SUM (s. TIME) TIME,SUM (s. TIMES) TIMES,SUM (s.FLAG) flag ");
		sb.append(" FROM SCH_STAT_FAULT s where status=0  GROUP BY s. NAME ORDER BY time DESC ) scf ");
		sb.append("WHERE ROWNUM <= '5') table_alias WHERE table_alias.rowno >= '1'");
		return schStatDao.queryBySql(sb.toString());
	}
	
	
}