com.sshdemo.common.report.manage.service.ChartReportService.java Source code

Introduction

Here is the source code for com.sshdemo.common.report.manage.service.ChartReportService.java

Source

/**
 * Copyright (c)2010-2011 Enterprise Website Content Management System(EWCMS), All rights reserved.
 * EWCMS PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 * http://www.ewcms.com
 */
package com.sshdemo.common.report.manage.service;

import java.util.Calendar;
import java.util.Date;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Set;

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

import com.sshdemo.common.BaseException;
import com.sshdemo.common.report.manage.dao.CategoryReportDAO;
import com.sshdemo.common.report.manage.dao.ChartReportDAO;
import com.sshdemo.common.report.manage.util.ChartAnalysisUtil;
import com.sshdemo.common.report.manage.util.ParameterSetValueUtil;
import com.sshdemo.common.report.model.CategoryReport;
import com.sshdemo.common.report.model.ChartReport;
import com.sshdemo.common.report.model.Parameter;
import com.sshdemo.common.schedule.generate.job.report.dao.EwcmsJobReportDAO;
import com.sshdemo.common.schedule.generate.job.report.model.EwcmsJobReport;

/**
 * 
 * @author wu_zhijun
 *
 */
@Service
public class ChartReportService implements ChartReportServiceable {

    @Autowired
    private ChartReportDAO chartReportDAO;
    @Autowired
    private CategoryReportDAO categorReportDAO;
    @Autowired
    private EwcmsJobReportDAO ewcmsJobReportDAO;

    @Override
    public Long addChartReport(ChartReport chartReport) {
        Assert.notNull(chartReport);
        Assert.hasLength(chartReport.getChartSql());

        Set<Parameter> parameters = ChartAnalysisUtil.analysisSql(chartReport.getChartSql());
        chartReport.setParameters(parameters);

        chartReportDAO.persist(chartReport);
        return chartReport.getId();
    }

    @Override
    public Long updChartReport(ChartReport chartReport) {
        Assert.notNull(chartReport);
        Assert.hasLength(chartReport.getChartSql());

        ChartReport entity = chartReportDAO.get(chartReport.getId());

        entity.setName(chartReport.getName());
        entity.setBaseDS(chartReport.getBaseDS());
        entity.setType(chartReport.getType());
        entity.setShowTooltips(chartReport.getShowTooltips());
        entity.setChartTitle(chartReport.getChartTitle());
        entity.setFontName(chartReport.getFontName());
        entity.setFontSize(chartReport.getFontSize());
        entity.setFontStyle(chartReport.getFontStyle());
        entity.setHorizAxisLabel(chartReport.getHorizAxisLabel());
        entity.setVertAxisLabel(chartReport.getVertAxisLabel());
        entity.setDataFontName(chartReport.getDataFontName());
        entity.setDataFontSize(chartReport.getDataFontSize());
        entity.setDataFontStyle(chartReport.getDataFontStyle());
        entity.setAxisFontName(chartReport.getAxisFontName());
        entity.setAxisFontSize(chartReport.getAxisFontSize());
        entity.setAxisFontStyle(chartReport.getAxisFontStyle());
        entity.setAxisTickFontName(chartReport.getAxisTickFontName());
        entity.setAxisTickFontSize(chartReport.getAxisTickFontSize());
        entity.setAxisTickFontStyle(chartReport.getAxisTickFontStyle());
        entity.setTickLabelRotate(chartReport.getTickLabelRotate());
        entity.setShowLegend(chartReport.getShowLegend());
        entity.setLegendPosition(chartReport.getLegendPosition());
        entity.setLegendFontName(chartReport.getLegendFontName());
        entity.setLegendFontSize(chartReport.getLegendFontSize());
        entity.setLegendFontStyle(chartReport.getLegendFontStyle());
        entity.setChartHeight(chartReport.getChartHeight());
        entity.setChartWidth(chartReport.getChartWidth());
        entity.setBgColorB(chartReport.getBgColorB());
        entity.setBgColorG(chartReport.getBgColorG());
        entity.setBgColorR(chartReport.getBgColorR());
        entity.setRemarks(chartReport.getRemarks());
        entity.setUpdateDate(new Date(Calendar.getInstance().getTime().getTime()));

        if (!entity.getChartSql().equals(chartReport.getChartSql())) {
            entity.setChartSql(chartReport.getChartSql());
            Set<Parameter> icNewList = new LinkedHashSet<Parameter>();

            Set<Parameter> oldParameters = entity.getParameters();
            Set<Parameter> newParameters = ChartAnalysisUtil.analysisSql(chartReport.getChartSql());
            for (Parameter newParameter : newParameters) {
                Parameter ic = findListEntity(oldParameters, newParameter);
                if (ic == null) {
                    ic = newParameter;
                }
                icNewList.add(ic);
            }
            entity.setParameters(icNewList);
        }
        chartReportDAO.merge(entity);
        return chartReport.getId();
    }

    @Override
    public void delChartReport(Long chartReportId) {
        ChartReport chartReport = chartReportDAO.get(chartReportId);
        Assert.notNull(chartReport);
        List<CategoryReport> categories = chartReportDAO.findCategoryReportByChartReportId(chartReportId);
        if (categories != null && !categories.isEmpty()) {
            for (CategoryReport categoryReport : categories) {
                Set<ChartReport> chartReports = categoryReport.getCharts();
                if (chartReports.isEmpty())
                    continue;
                chartReports.remove(chartReport);
                categoryReport.setCharts(chartReports);
                categorReportDAO.merge(categoryReport);
            }
        }
        List<EwcmsJobReport> ewcmsJobReports = chartReportDAO.findEwcmsJobReportByChartReportId(chartReportId);
        if (ewcmsJobReports != null && !ewcmsJobReports.isEmpty()) {
            for (EwcmsJobReport ewcmsJobReport : ewcmsJobReports) {
                if (ewcmsJobReport.getTextReport() == null) {
                    ewcmsJobReportDAO.remove(ewcmsJobReport);
                } else {
                    ewcmsJobReport.setChartReport(null);
                    ewcmsJobReportDAO.merge(ewcmsJobReport);
                }
            }
        }
        chartReportDAO.removeByPK(chartReportId);
    }

    @Override
    public ChartReport findChartReportById(Long chartReportId) {
        return chartReportDAO.get(chartReportId);
    }

    @Override
    public List<ChartReport> findAllChartReport() {
        return chartReportDAO.findAll();
    }

    @Override
    public Long updChartReportParameter(Long chartReportId, Parameter parameter) throws BaseException {
        if (chartReportId == null || chartReportId.intValue() == 0)
            throw new BaseException("", "????");
        ChartReport chart = chartReportDAO.get(chartReportId);
        if (chart == null)
            throw new BaseException("", "???");

        parameter = ParameterSetValueUtil.setParametersValue(parameter);

        Set<Parameter> parameters = chart.getParameters();
        parameters.remove(parameter);
        parameters.add(parameter);
        chart.setParameters(parameters);

        chartReportDAO.merge(chart);

        return parameter.getId();
    }

    /**
     * ???????
     * 
     * @param oldParameters
     *            ???
     * @param newParameter ?
     *            
     * @return Parameter
     */
    private Parameter findListEntity(Set<Parameter> oldParameters, Parameter newParameter) {
        for (Parameter parameter : oldParameters) {
            String rpEnName = parameter.getEnName();
            if (newParameter.getEnName().trim().equals(rpEnName.trim())) {
                parameter.setClassName(newParameter.getClassName());
                parameter.setDefaultValue(newParameter.getDefaultValue());
                parameter.setDescription(newParameter.getDescription());
                return parameter;
            }
        }
        return null;
    }
}