package com.product.server.report.service;
|
|
|
import org.apache.log4j.Logger;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.entity.Report;
|
import com.product.core.exception.BaseException;
|
import com.product.server.report.service.idel.ListReportConfigService;
|
|
@Service
|
public class ListReportConfigServiceImple implements ListReportConfigService {
|
|
@Autowired
|
public BaseDao baseDao;
|
public BaseDao getBaseDao() {
|
return baseDao;
|
}
|
public void setBaseDao(BaseDao baseDao) {
|
this.baseDao = baseDao;
|
}
|
public ListReportServer reportServerNew;
|
|
public ListReportServer getReportServerNew() {
|
return reportServerNew;
|
}
|
public void setReportServerNew(ListReportServer reportServerNew) {
|
this.reportServerNew = reportServerNew;
|
}
|
public static Logger logger=Logger.getLogger(ListReportConfigServiceImple.class);
|
//根据表名获取报表
|
public String createReportInfo(String tableUuid) throws BaseException{
|
//获取配置报表
|
FieldSetEntity felset = baseDao.getFieldSetEntity("product_sys_reoprt_config", tableUuid, false);
|
DataTableEntity data = null;
|
if(felset.getString("report_table_name") != null && !felset.getString("report_table_name").isEmpty()){
|
data = baseDao.listTable(felset.getString("report_table_name"));
|
}else if(felset.getString("report_data_sql") != null){
|
data = baseDao.listTable(felset.getString("report_data_sql"), new String[]{});
|
}
|
DataTableEntity fieldData = baseDao.listTable("product_sys_report_field_properties", "report_uuid = '"+tableUuid+"'", "order_number");
|
Report rc=new Report();
|
if(fieldData.getRows() > 0){
|
int row = fieldData.getRows();
|
String[] showField = new String[row];//字段名
|
int[][] showColspan = new int[1][row];//跨列
|
String[][] showTitle = new String[1][row];//字段描述
|
int[][] showRowspan = new int[1][row];//跨行
|
boolean[] showTotalField = new boolean[row];//是否总计
|
int[] showColWidth = new int[row];//列宽
|
String[] showFormat = new String[row];//字段格式
|
boolean[] showGroupField = new boolean[row];//是否分组
|
String[] url = new String[row];//穿透地址
|
for(int i=0;i<fieldData.getRows();++i){
|
FieldSetEntity set = fieldData.getFieldSetEntity(i);
|
showField[i] = set.getString("table_field_name");//字段名
|
System.out.println(set.getString("table_field_description"));
|
showTitle[0][i] = set.getString("table_field_description");//字段中文名
|
showColspan[0][i] = 1;
|
showRowspan[0][i] = 1;
|
System.out.println(set.getString("end_total_type"));
|
if(set.getString("end_total_type").equals("false")){//是否最后总计
|
showTotalField[i] = false;
|
}else{
|
showTotalField[i] = true;
|
}
|
showColWidth[i] = set.getInteger("show_width");//宽度比例
|
System.out.println("数据格式："+set.getString("data_format"));
|
if(set.getString("data_format") == null || set.getString("data_format").isEmpty() || set.getString("data_format").equals("null")){
|
showFormat[i] = null;
|
}else{
|
showFormat[i] = set.getString("data_format");
|
}
|
if(set.getString("is_group_field").equals("1")){
|
showGroupField[i] = true;//是否分组
|
}else{
|
showGroupField[i] = false;//是否分组
|
}
|
}
|
//是否固定表头
|
if(felset.getString("fix_header").equals("1")){
|
rc.setFixHeader(true);
|
}else{
|
rc.setFixHeader(false);
|
}
|
//是否最后总计
|
if(felset.getString("last_total").equals("1")){
|
rc.setTotal(true);
|
}else{
|
rc.setTotal(false);
|
}
|
//是否分页
|
// if(felset.getString("is_page").equals("1")){
|
// rc.setPage(true);
|
// rc.setPageSize(felset.getInteger("page_size"));
|
// }else{
|
// rc.setPage(false);
|
// }
|
DataTableEntity headerData = baseDao.listTable("product_sys_report_header_properties", "report_uuid = '"+tableUuid+"'");
|
if(headerData.getRows() > 0){
|
int headerY = headerData.getRows() / fieldData.getRows();//二维数组y
|
int[][] headerColspan = new int[headerY][fieldData.getRows()];//跨列
|
String[][] headerTitle = new String[headerY][fieldData.getRows()];//字段描述
|
int[][] headerRowspan = new int[headerY][fieldData.getRows()];//跨行
|
int y = 0;
|
for(int j=0;j<headerData.getRows();++j){
|
FieldSetEntity header = headerData.getFieldSetEntity(j);
|
int x = Integer.parseInt(header.getString("header_index").split("-")[0]);
|
//列发生改变
|
if(y != Integer.parseInt(header.getString("header_index").split("-")[1])){
|
y = Integer.parseInt(header.getString("header_index").split("-")[1]);
|
|
}
|
headerTitle[y][x] = header.getString("header_name");
|
headerColspan[y][x] = Integer.parseInt(header.getString("header_colspan"));
|
headerRowspan[y][x] = Integer.parseInt(header.getString("header_rowspan"));
|
}
|
showTitle = headerTitle;
|
showColspan = headerColspan;
|
showRowspan = headerRowspan;
|
}
|
url[3] = "~bottom_x2~,asdasd,asdasd,sadasd,aasdsad";
|
rc.setUrl(url);
|
rc.setTitle(showTitle);//字段中文描述
|
rc.setColspan(showColspan);//跨列
|
rc.setRowspan(showRowspan);//跨行
|
rc.setField(showField);//表头字段
|
rc.setTotalField(showTotalField);//是否总计
|
if(!(felset.getString("report_data_width") == null || felset.getString("report_data_width").isEmpty())){
|
rc.setWidth(felset.getInteger("report_data_width"));//表报宽度
|
}
|
rc.setColWidth(showColWidth);//列宽比例
|
rc.setFormat(showFormat);//字段格式
|
rc.setGroupField(showGroupField);//是否分组
|
}
|
|
System.out.println(data.getRows());
|
// rc.setCurrentPage(1);//当前页
|
// rc.setTotalPage(data.getRows() / felset.getInteger("page_size"));//总页数
|
// rc.setTotalRow(data.getRows());//总条数
|
rc.setDt(data);
|
System.out.println(rc.getDt().getRows());
|
System.out.println(rc.getGroupField());
|
System.out.println(reportServerNew);
|
ListReportServer reportServerNew = new ListReportServer();
|
reportServerNew.setReport(rc);
|
String error=reportServerNew.toCheckReport();//参数检测
|
if(error==null){
|
return reportServerNew.toCreateGroupReport();
|
} else{
|
return "错误："+error;
|
}
|
}
|
public JSONObject getReportName(String table_uuid) throws BaseException{
|
FieldSetEntity fSetEntity = baseDao.getFieldSetEntity("product_sys_reoprt_config", table_uuid, false);
|
JSONObject object = new JSONObject();
|
//加载表名
|
object.put("report_name", fSetEntity.getString("report_name"));
|
//加载页眉页脚
|
object.put("report_head_title_left",fSetEntity.getString("report_head_title_left"));//头部报表标题—左
|
object.put("report_head_title_center",fSetEntity.getString("report_head_title_center"));//头部报表标题—中
|
object.put("report_head_title_right",fSetEntity.getString("report_head_title_right"));//头部报表标题—右
|
object.put("report_tail_title_left",fSetEntity.getString("report_tail_title_left"));//尾部报表标题—左
|
object.put("report_tail_title_center",fSetEntity.getString("report_tail_title_center"));//尾部报表标题—中
|
object.put("report_tail_title_right",fSetEntity.getString("report_tail_title_right"));//尾部报表标题—右
|
return object;
|
}
|
}
|
