mijia_team / mijia-server · Files

package com.bjivt.util;
import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.Random;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;

import org.springframework.web.multipart.MultipartFile;

import com.bjivt.entity.vo.StatisticsDecResult;
import com.bjivt.entity.vo.StatisticsIncome;
import com.bjivt.entity.vo.StatisticsResult;
import com.bjivt.entity.vo.StatisticsTwoSeries;
import com.bjivt.entity.vo.StatisticsUser;
public class StatisticsUtil {
	
	/**
	 * 一般的数据
	 * @Title: getDataxy
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getDataxy(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (StatisticsResult sr : lists) {
			datas.append("['");
			datas.append(sr.getTime());
			datas.append("',");
			datas.append(sr.getCounts()+beforeCount);
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getDatax(List<StatisticsResult> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsResult sr : lists) {
			datasx.append("'").append(sr.getTime()).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getDatay(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsResult sr : lists) {
			datasy.append(sr.getCounts()+beforeCount);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getDataCounts(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsResult sr : lists) {
				counts = counts.add(new BigDecimal(sr.getCounts()));
			}
			return counts.add(new BigDecimal(beforeCount));
		} catch (Exception e) {
			return counts;
		}
		
	}
	/**
	 * 针对小数的
	 * @Title: getDataxy
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getDataxy(List<StatisticsDecResult> lists)throws Exception{
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		for (StatisticsDecResult sr : lists) {
			datas.append("['");
			datas.append(sr.getTime());
			datas.append("',");
			String p=decimalFormat.format(sr.getCounts());//format 返回的是字符串
			datas.append(p);
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getDataDecx(List<StatisticsDecResult> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsDecResult sr : lists) {
			datasx.append("'").append(sr.getTime()).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getDatay(List<StatisticsDecResult> lists)throws Exception{
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		for (StatisticsDecResult sr : lists) {
			String p=decimalFormat.format(sr.getCounts());//format 返回的是字符串
			datasy.append(p);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getDataCounts(List<StatisticsDecResult> lists)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsDecResult sr : lists) {
				counts = counts.add(new BigDecimal(sr.getCounts()));
			}
			return counts;
		} catch (Exception e) {
			return counts;
		}
		
	}
	/**
	 * 图形结构
	 * @param lists
	 * @param datax
	 * @param datay
	 * @return
	 * @throws Exception
	 */
	public static String getDataxy(List<Map<String,Object>> lists,String datax,String datay)throws Exception{
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (Map<String, Object> map : lists) {
			datas.append("['");
			datas.append(map.get(datax));
			datas.append("',");
			datas.append(map.get(datay));
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getDatax(List<Map<String,Object>> lists,String datax)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (Map<String, Object> map : lists) {
			datasx.append("'").append(map.get(datax)).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getDatay(List<Map<String,Object>> lists,String datay)throws Exception{
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (Map<String, Object> map : lists) {
			datasy.append(map.get(datay));
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getData(List<Map<String,Object>> lists,String datax,String datay)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (Map<String, Object> map : lists) {
			datasx.append("{name: '").append(map.get(datax)).append("'");
			datasx.append(",");
			datasx.append("y: ").append(map.get(datay)).append("},");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getDataCounts(List<Map<String,Object>> lists,String data)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);;
		try {
			
			for (Map<String, Object> map : lists) {
				counts = counts.add(new BigDecimal(map.get(data).toString()));
			}
			return counts;
		} catch (Exception e) {
			return counts;
		}
		
	}

	/**
	 * 按时长的格式数据
	 * @Title: getDataxy
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getDataTimexy(List<StatisticsResult> lists)throws Exception{
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (StatisticsResult sr : lists) {
			datas.append("['");
			datas.append(sr.getTime());
			datas.append("','");
			datas.append(DateTool.formatTime(sr.getCounts()));
			datas.append("'],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getDataTimex(List<StatisticsResult> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsResult sr : lists) {
			datasx.append("'").append(sr.getTime()).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getDataTimey(List<StatisticsResult> lists)throws Exception{
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsResult sr : lists) {
			datasy.append(DateTool.formatTime(sr.getCounts()));
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getDataTimeCounts(List<StatisticsResult> lists )throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsResult sr : lists) {
				counts = counts.add(new BigDecimal(sr.getCounts()));
			}
			return counts;
		} catch (Exception e) {
			return counts;
		}
		
	}
	/**
	 * 无单引号的数据
	 * @Title: getDataxy
	 * @Description: 主要是用于存储过程的调用
	 * @author Yh.T
	 */
	public static String getFunDataxy(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (StatisticsResult sr : lists) {
			datas.append("[");
			datas.append(sr.getTime());
			datas.append(",");
			datas.append(sr.getCounts()+beforeCount);
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getFunDatax(List<StatisticsResult> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsResult sr : lists) {
			datasx.append(sr.getTime());
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getFunDatay(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsResult sr : lists) {
			datasy.append(sr.getCounts()+beforeCount);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getFunDataCounts(List<StatisticsResult> lists, int beforeCount)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsResult sr : lists) {
				counts = counts.add(new BigDecimal(sr.getCounts()));
			}
			return counts.add(new BigDecimal(beforeCount));
		} catch (Exception e) {
			return counts;
		}
		
	}

	/**
	 * 针对两个数据形式的数据
	 * @Title: getDataxy
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getSeriesDataxy(List<StatisticsTwoSeries> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (StatisticsTwoSeries sr : lists) {
			datas.append("['");
			datas.append(sr.getTime());
			datas.append("',");
			datas.append(sr.getVisitCounts());
			datas.append(",");
			String p=decimalFormat.format(sr.getTimeCounts());//format 返回的是字符串
			datas.append(p);
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getSeriesDatax(List<StatisticsTwoSeries> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsTwoSeries sr : lists) {
			datasx.append("'").append(sr.getTime()).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getSeriesDatay(List<StatisticsTwoSeries> lists)throws Exception{
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsTwoSeries sr : lists) {
			datasy.append(sr.getVisitCounts());
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	/**
	 * 为第二个纵轴（y）的值，进行赋值
	 * @Title: getSeriesDatayTo
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getSeriesDatayTo(List<StatisticsTwoSeries> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsTwoSeries sr : lists) {
			String p=decimalFormat.format(sr.getTimeCounts());//format 返回的是字符串
			datasy.append(p);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getSeriesDataCounts(List<StatisticsTwoSeries> lists)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsTwoSeries sr : lists) {
				counts = counts.add(new BigDecimal(sr.getVisitCounts()));
			}
			return counts;
		} catch (Exception e) {
			return counts;
		}
		
	}
	/**
	 * 针对显示三个数据形式的数据
	 * @Title: getDataxy
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getIncomeDataxy(List<StatisticsIncome> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		StringBuffer datas = new StringBuffer();
		datas.append("[");
		for (StatisticsIncome sr : lists) {
			datas.append("['");
			datas.append(sr.getTime());
			datas.append("',");
			String p=decimalFormat.format(sr.getRecharge());//format 返回的是字符串
			datas.append(p);
			datas.append(",");
			p=decimalFormat.format(sr.getWithdraw());//format 返回的是字符串
			datas.append(p);
			datas.append("],");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datas.substring(0,datas.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static String getIncomeDatax(List<StatisticsIncome> lists)throws Exception{
		StringBuffer datasx = new StringBuffer();
		
		datasx.append("[");
		for (StatisticsIncome sr : lists) {
			datasx.append("'").append(sr.getTime()).append("'");
			datasx.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasx.substring(0,datasx.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}

	public static String getIncomeDatay(List<StatisticsIncome> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsIncome sr : lists) {
			String p=decimalFormat.format(sr.getRecharge());//format 返回的是字符串
			datasy.append(p);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	/**
	 * 为第二个纵轴（y）的值，进行赋值
	 * @Title: getSeriesDatayTo
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getIncomeDatayTo(List<StatisticsIncome> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsIncome sr : lists) {
			String p=decimalFormat.format(sr.getWithdraw());//format 返回的是字符串
			datasy.append(p);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	/**
	 * 为第三个纵轴（y）的值，进行赋值
	 * @Title: getIncomeDatayTo
	 * @Description: TODO(这里用一句话描述这个方法的作用)
	 * @author Yh.T
	 */
	public static String getIncomeDatayTh(List<StatisticsIncome> lists)throws Exception{
		DecimalFormat decimalFormat=new DecimalFormat(".00");//构造方法的字符格式这里如果小数不足2位,会以0补足.
		
		StringBuffer datasy = new StringBuffer();
		datasy.append("[");
		for (StatisticsIncome sr : lists) {
			String p=decimalFormat.format(sr.getRecharge() - sr.getWithdraw());//format 返回的是字符串
			datasy.append(p);
			datasy.append(",");
		}
		String data="";
		if(lists!=null&&lists.size()>0){
			data = datasy.substring(0,datasy.length()-1)+"]"; 
		}else{
			data = "[]"; 
		}
		return data;
	}
	
	public static BigDecimal getIncomeDataCounts(List<StatisticsIncome> lists)throws Exception{
		
		BigDecimal counts = new BigDecimal(0);
		try {
			
			for (StatisticsIncome sr : lists) {
				counts = counts.add(new BigDecimal(sr.getRecharge() - sr.getWithdraw()));
			}
			return counts;
		} catch (Exception e) {
			return counts;
		}
		
	}
	public static String[] chars = new String[]{
        "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z",
        "0", "1", "2", "3", "4", "5", "6", "7", "8", "9",
        "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V","W", "X", "Y", "Z"
    }; 
	
	//获取文件短uuid+后缀名
	public static String getFileName(MultipartFile upload){ 
		StringBuffer stringBuffer = new StringBuffer(); 
		StringBuffer stringUUID = new StringBuffer(); 
        String fileName = upload.getOriginalFilename();
        String uuid = UUID.randomUUID().toString().replace("-", ""); 
        for (int i = 0; i < 8; i++)
        { 
            String str = uuid.substring(i * 4, i * 4 + 4); 
            int strInteger = Integer.parseInt(str, 16); 
            stringUUID.append(chars[strInteger % 0x3E]); 
        } 
        stringBuffer.append(stringUUID).append(".").append(fileName.substring(fileName.lastIndexOf(".") + 1));
        return stringBuffer.toString(); 
    }
	
	//获取文件的url路径
//	public static String getUrlPath(String filename){ 
//		StringBuffer stringurl = new StringBuffer(); 
//		return stringurl.append(Constants.domain).append("/").append(filename).toString();
//    }
	
	//根据url截取字符串
	public static String getStringByUrl(String urlname){ 
		return urlname.substring(urlname.lastIndexOf("/")+1);
    }
	
	//获取短uuid
	public static String getShortUUID(){ 
		StringBuffer stringUUID = new StringBuffer(); 
		stringUUID.append(new Date().getTime());
        String uuid = UUID.randomUUID().toString().replace("-", ""); 
        for (int i = 0; i < 8; i++)
        { 
            String str = uuid.substring(i * 4, i * 4 + 4); 
            int strInteger = Integer.parseInt(str, 16); 
            stringUUID.append(chars[strInteger % 0x3E]); 
        } 
        return stringUUID.toString(); 
    }
	
	//获取url地址
	public static String getUrl(HttpServletRequest request){ 
		StringBuffer strBackUrl = new StringBuffer();
		strBackUrl.append("http://").append(request.getServerName()); //服务器地址  
		strBackUrl.append(":");
		strBackUrl.append(request.getServerPort());//端口号  
		strBackUrl.append(request.getContextPath());//项目名称      
	   // + httpRequest.getServletPath()      //请求页面或其他地址  
	   //+ "?" + (httpRequest.getQueryString()); //参数  
		return strBackUrl.toString();
    }
	
	//随机取队列名称
}