Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.biz.report.service.impl; import com.biz.report.dao.CustomerReportDao; import com.biz.report.domain.MappingEngine; import com.biz.report.domain.Report1; import com.biz.report.domain.Report2; import com.biz.report.dto.DataPoint; import com.biz.report.dto.ItemDTO; import com.biz.report.dto.Report1DataSet; import com.biz.report.dto.Report2DataSet; import com.biz.report.dto.Report3DataSet; import com.biz.report.dto.Report4DataSet; import com.biz.report.dto.Report5DataSet; import com.biz.report.dto.ReportDataSet; import com.biz.report.service.CustomerService; import java.util.ArrayList; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.StringUtils; import org.springframework.web.bind.annotation.ResponseBody; /** * * @author Aux-058 */ @Service public class CustomerServiceImpl implements CustomerService { @Autowired private CustomerReportDao customerReportDao; private final Log logger = LogFactory.getLog(CustomerServiceImpl.class); public List<String> readCustomers() { return customerReportDao.readCustomers(); } public List<Report1DataSet> readDataForAreaChart(String customers, String months, String year) { if (!StringUtils.isEmpty(customers) && customers.contains("[")) { customers = customers.substring(1, customers.length() - 1); } String[] typeAr; if (!StringUtils.isEmpty(customers) && customers.contains(",")) { typeAr = customers.split("[,]"); } else { typeAr = new String[] { customers }; } if (!StringUtils.isEmpty(months) && months.contains("[")) { months = months.substring(1, months.length() - 1); } String[] monthAr; if (!StringUtils.isEmpty(months) && months.contains(",")) { monthAr = months.split("[,]"); } else { monthAr = new String[] { months }; } int typeCount = typeAr.length; List list = customerReportDao.read(customers, months, year); List<Report1> reportList = new MappingEngine().getList(list); logger.info(reportList.size()); List<Report1DataSet> dataSets = new ArrayList<Report1DataSet>(); for (int i = 0; i < typeCount; i++) { List<DataPoint> dataPoints = constructDataPoints(reportList, typeAr[i].trim(), monthAr, i); dataSets.add(new Report1DataSet("stackedArea", dataPoints, typeAr[i])); } return dataSets; } public List<Report2DataSet> readDataForPieChart(String customers, String year, String months) { if (!StringUtils.isEmpty(customers) && customers.contains("[")) { customers = customers.substring(1, customers.length() - 1); } if (!StringUtils.isEmpty(months) && months.contains("[")) { months = months.substring(1, months.length() - 1); } List list = customerReportDao.readByMonth(customers, months, year); List<Report2> reportList = new MappingEngine().getPieChartReport(list); List<Report2DataSet> dataSets = new ArrayList<Report2DataSet>(); for (Report2 r : reportList) { dataSets.add(new Report2DataSet(r.getTypeName(), r.getAmount())); } return dataSets; } public List<Report3DataSet> readDataForBarChart(String customers, String year, String months) { if (!StringUtils.isEmpty(customers) && customers.contains("[")) { customers = customers.substring(1, customers.length() - 1); } if (!StringUtils.isEmpty(months) && months.contains("[")) { months = months.substring(1, months.length() - 1); } List list = customerReportDao.readByMonth(customers, months, year); List<Report2> reportList = new MappingEngine().getPieChartReport(list); List<Report3DataSet> dataSets = new ArrayList<Report3DataSet>(); for (Report2 r : reportList) { dataSets.add(new Report3DataSet(r.getTypeName(), r.getAmount())); } return dataSets; } public List<Report4DataSet> readDataForColumnChart(String customers, String months, String year) { if (!StringUtils.isEmpty(customers) && customers.contains("[")) { customers = customers.substring(1, customers.length() - 1); } String[] typeAr; if (!StringUtils.isEmpty(customers) && customers.contains(",")) { typeAr = customers.split("[,]"); } else { typeAr = new String[] { customers }; } if (!StringUtils.isEmpty(months) && months.contains("[")) { months = months.substring(1, months.length() - 1); } String[] monthAr; if (!StringUtils.isEmpty(months) && months.contains(",")) { monthAr = months.split("[,]"); } else { monthAr = new String[] { months }; } int typeCount = typeAr.length; List list = customerReportDao.read(customers, months, year); List<Report1> reportList = new MappingEngine().getList(list); logger.info(reportList.size()); List<Report4DataSet> dataSets = new ArrayList<Report4DataSet>(); for (int i = 0; i < typeCount; i++) { List<DataPoint> dataPoints = constructDataPoints(reportList, typeAr[i].trim(), monthAr, i); dataSets.add(new Report4DataSet("column", dataPoints, typeAr[i])); } return dataSets; } public List<Report5DataSet> readDataForLineChart(String customers, String months, String year) { if (!StringUtils.isEmpty(customers) && customers.contains("[")) { customers = customers.substring(1, customers.length() - 1); } String[] typeAr; if (!StringUtils.isEmpty(customers) && customers.contains(",")) { typeAr = customers.split("[,]"); } else { typeAr = new String[] { customers }; } if (!StringUtils.isEmpty(months) && months.contains("[")) { months = months.substring(1, months.length() - 1); } String[] monthAr; if (!StringUtils.isEmpty(months) && months.contains(",")) { monthAr = months.split("[,]"); } else { monthAr = new String[] { months }; } int typeCount = typeAr.length; List list = customerReportDao.read(customers, months, year); List<Report1> reportList = new MappingEngine().getList(list); logger.info(reportList.size()); List<Report5DataSet> dataSets = new ArrayList<Report5DataSet>(); for (int i = 0; i < typeCount; i++) { List<DataPoint> dataPoints = constructDataPoints(reportList, typeAr[i].trim(), monthAr, i); dataSets.add(new Report5DataSet(dataPoints, typeAr[i])); } return dataSets; } @Override public List<ItemDTO> readByCustomerName(String customers, String year, String month) { if (!StringUtils.isEmpty(month) && month.contains("[")) { month = month.substring(1, month.length() - 1); } if (!StringUtils.isEmpty(customers) && !customers.contains("'")) { customers = "'" + customers + "'"; } List list = customerReportDao.readTableData(customers, year, month); List<ItemDTO> itemDTOs = new ArrayList<ItemDTO>(); for (Object object : list) { ItemDTO itemDTO = constructItemDTO(object); itemDTOs.add(itemDTO); } return itemDTOs; } private ItemDTO constructItemDTO(Object ob) { Object[] obAr = (Object[]) ob; ItemDTO itemDTO = new ItemDTO(); itemDTO.setInvoiceNo(obAr[0].toString()); itemDTO.setDate(obAr[1].toString().substring(0, 10)); itemDTO.setItemName(obAr[2].toString()); itemDTO.setQty(obAr[3].toString()); itemDTO.setSellingPrice(obAr[4].toString()); return itemDTO; } public ReportDataSet getReports(String customers, String months, String year) { List<Report1DataSet> report1 = readDataForAreaChart(customers, months, year); List<Report2DataSet> report2 = readDataForPieChart(customers, year, months); List<Report3DataSet> report3 = readDataForBarChart(customers, year, months); List<Report4DataSet> report4 = readDataForColumnChart(customers, months, year); List<Report5DataSet> report5 = readDataForLineChart(customers, months, year); return new ReportDataSet(report1, report2, report3, report4, report5); } @ResponseBody private List<DataPoint> constructDataPoints(List<Report1> reportList, String customer, String[] monthAr, int i) { List<DataPoint> dataPoints = new ArrayList<DataPoint>(); List<String> monthList = new ArrayList<String>(); for (String month : monthAr) { monthList.add(month.trim()); } List<Report1> reportList1 = getReportList(customer, reportList); for (String month : monthList) { double sellingPrice = 0; for (Report1 report : reportList1) { if (month.equalsIgnoreCase("'" + report.getMonthName().trim() + "'")) { sellingPrice = report.getSellingPrice(); break; } } DataPoint dataPoint = new DataPoint(); dataPoint.setMonth(month); dataPoint.setSellingPrice(sellingPrice); dataPoints.add(dataPoint); } return dataPoints; } public List<Report1> getReportList(String customer, List<Report1> reportList) { List<Report1> list = new ArrayList<Report1>(); for (Report1 report1 : reportList) { String typeName = "'" + report1.getTypeName().trim() + "'"; if (customer.equalsIgnoreCase(typeName)) { list.add(report1); } } return list; } }