1634 lines
64 KiB
Plaintext
1634 lines
64 KiB
Plaintext
<%@ page import="weaver.general.Util" %>
|
||
<%@ page import="weaver.conn.RecordSet" %>
|
||
<%@ page import="java.time.LocalDate" %>
|
||
<%@ page import="java.time.format.DateTimeFormatter" %>
|
||
<%@ page import="java.time.temporal.ChronoUnit" %>
|
||
<%@ page import="java.math.BigDecimal" %>
|
||
<%@ page import="java.text.DecimalFormat" %>
|
||
<%@ page import="org.apache.poi.ss.usermodel.*" %>
|
||
<%@ page import="org.apache.poi.ss.util.CellRangeAddress" %>
|
||
<%@ page import="org.apache.poi.ss.util.RegionUtil" %>
|
||
<%@ page import="java.util.List" %>
|
||
<%@ page import="java.util.ArrayList" %>
|
||
<%@ page import="java.util.Map" %>
|
||
<%@ page import="java.util.HashMap" %>
|
||
<%@ page import="java.io.FileOutputStream" %>
|
||
<%@ page import="org.apache.poi.hssf.usermodel.*" %>
|
||
<%@ page import="weaver.general.BaseBean" %>
|
||
<%@ page import="java.io.IOException" %>
|
||
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
||
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
||
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
|
||
<%
|
||
int sum = 0;
|
||
|
||
String ksrq = Util.null2String(request.getParameter("ksrq"));
|
||
String jsrq = Util.null2String(request.getParameter("jsrq"));
|
||
String gsgs = Util.null2String(request.getParameter("gsgs"));
|
||
|
||
Map<String, Object> apidatas = new HashMap<String, Object>();
|
||
|
||
// 定义日期格式
|
||
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM");
|
||
|
||
DecimalFormat df = new DecimalFormat("0.00");
|
||
|
||
|
||
List<List<Object>> rowDataList = new ArrayList<List<Object>>();
|
||
|
||
List<Object> dataList_glf = new ArrayList<Object>();
|
||
List<Object> dataList_gz = new ArrayList<Object>();
|
||
List<Object> dataList_nzjzyhq = new ArrayList<Object>();
|
||
List<Object> dataList_zxjt = new ArrayList<Object>();
|
||
List<Object> dataList_wx = new ArrayList<Object>();
|
||
List<Object> dataList_gjj = new ArrayList<Object>();
|
||
List<Object> dataList_gzc = new ArrayList<Object>();
|
||
List<Object> dataList_tjf = new ArrayList<Object>();
|
||
List<Object> dataList_jrwz = new ArrayList<Object>();
|
||
List<Object> dataList_fzfy = new ArrayList<Object>();
|
||
List<Object> dataList_ywx = new ArrayList<Object>();
|
||
List<Object> dataList_fsjw = new ArrayList<Object>();
|
||
List<Object> dataList_pxf = new ArrayList<Object>();
|
||
List<Object> dataList_ghjf = new ArrayList<Object>();
|
||
List<Object> dataList_dthdf = new ArrayList<Object>();
|
||
List<Object> dataList_hdch = new ArrayList<Object>();
|
||
List<Object> dataList_clf = new ArrayList<Object>();
|
||
List<Object> dataList_glcb = new ArrayList<Object>();
|
||
List<Object> dataList_dksyx = new ArrayList<Object>();
|
||
List<Object> dataList_ycxbcj = new ArrayList<Object>();
|
||
List<Object> dataList_rzxtsjwhf = new ArrayList<Object>();
|
||
List<Object> dataList_dksdf = new ArrayList<Object>();
|
||
List<Object> dataList_zbfwf = new ArrayList<Object>();
|
||
List<Object> dataList_sd = new ArrayList<Object>();
|
||
List<Object> dataList_hj = new ArrayList<Object>();
|
||
|
||
|
||
if(ksrq!=null && !"".equals(ksrq) && jsrq!=null && !"".equals(jsrq)){
|
||
int ks_year = Integer.parseInt(ksrq.substring(0,4));
|
||
int ks_month = Integer.parseInt(ksrq.substring(5,7));
|
||
|
||
int js_year = Integer.parseInt(jsrq.substring(0,4));
|
||
int js_month = Integer.parseInt(jsrq.substring(5,7));
|
||
|
||
// 定义起始日期和结束日期
|
||
LocalDate startDate = LocalDate.of(ks_year, ks_month, 1);
|
||
LocalDate endDate = LocalDate.of(js_year, js_month, 1);
|
||
|
||
// 管理费 仁泰 小计
|
||
double glf_rentai_xiaoji = 0.00;
|
||
// 管理费 华夏 小计
|
||
double glf_huaxia_xiaoji = 0.00;
|
||
// 管理费 锦绣 小计
|
||
double glf_jinxiu_xiaoji = 0.00;
|
||
// 管理费 洵洲 小计
|
||
double glf_xunzhou_xiaoji = 0.00;
|
||
// 管理费 仁泰 合计
|
||
double glf_heji = 0.00;
|
||
|
||
// 工资 仁泰 小计
|
||
double gz_rentai_xiaoji = 0.00;
|
||
// 工资 华夏 小计
|
||
double gz_huaxia_xiaoji = 0.00;
|
||
// 工资 锦绣 小计
|
||
double gz_jinxiu_xiaoji = 0.00;
|
||
// 工资 洵洲 小计
|
||
double gz_xunzhou_xiaoji = 0.00;
|
||
// 工资 仁泰 合计
|
||
double gz_heji = 0.00;
|
||
|
||
// 年终奖、卓越后勤人等 仁泰 小计
|
||
double nzjzyhq_rentai_xiaoji = 0.00;
|
||
// 年终奖、卓越后勤人等 华夏 小计
|
||
double nzjzyhq_huaxia_xiaoji = 0.00;
|
||
// 年终奖、卓越后勤人等 锦绣 小计
|
||
double nzjzyhq_jinxiu_xiaoji = 0.00;
|
||
// 年终奖、卓越后勤人等 洵洲 小计
|
||
double nzjzyhq_xunzhou_xiaoji = 0.00;
|
||
// 年终奖、卓越后勤人等 仁泰 合计
|
||
double nzjzyhq_heji = 0.00;
|
||
|
||
// 专项津贴 仁泰 小计
|
||
double zxjt_rentai_xiaoji = 0.00;
|
||
// 专项津贴 华夏 小计
|
||
double zxjt_huaxia_xiaoji = 0.00;
|
||
// 专项津贴 锦绣 小计
|
||
double zxjt_jinxiu_xiaoji = 0.00;
|
||
// 专项津贴 洵洲 小计
|
||
double zxjt_xunzhou_xiaoji = 0.00;
|
||
// 专项津贴 仁泰 合计
|
||
double zxjt_heji = 0.00;
|
||
|
||
// 五险 仁泰 小计
|
||
double wx_rentai_xiaoji = 0.00;
|
||
// 五险 华夏 小计
|
||
double wx_huaxia_xiaoji = 0.00;
|
||
// 五险 锦绣 小计
|
||
double wx_jinxiu_xiaoji = 0.00;
|
||
// 五险 洵洲 小计
|
||
double wx_xunzhou_xiaoji = 0.00;
|
||
// 五险 仁泰 合计
|
||
double wx_heji = 0.00;
|
||
|
||
// 公积金 仁泰 小计
|
||
double gjj_rentai_xiaoji = 0.00;
|
||
// 公积金 华夏 小计
|
||
double gjj_huaxia_xiaoji = 0.00;
|
||
// 公积金 锦绣 小计
|
||
double gjj_jinxiu_xiaoji = 0.00;
|
||
// 公积金 洵洲 小计
|
||
double gjj_xunzhou_xiaoji = 0.00;
|
||
// 公积金 仁泰 合计
|
||
double gjj_heji = 0.00;
|
||
|
||
// 工作餐 仁泰 小计
|
||
double gzc_rentai_xiaoji = 0.00;
|
||
// 工作餐 华夏 小计
|
||
double gzc_huaxia_xiaoji = 0.00;
|
||
// 工作餐 锦绣 小计
|
||
double gzc_jinxiu_xiaoji = 0.00;
|
||
// 工作餐 洵洲 小计
|
||
double gzc_xunzhou_xiaoji = 0.00;
|
||
// 工作餐 仁泰 合计
|
||
double gzc_heji = 0.00;
|
||
|
||
// 体检费 仁泰 小计
|
||
double tjf_rentai_xiaoji = 0.00;
|
||
// 体检费 华夏 小计
|
||
double tjf_huaxia_xiaoji = 0.00;
|
||
// 体检费 锦绣 小计
|
||
double tjf_jinxiu_xiaoji = 0.00;
|
||
// 体检费 洵洲 小计
|
||
double tjf_xunzhou_xiaoji = 0.00;
|
||
// 体检费 仁泰 合计
|
||
double tjf_heji = 0.00;
|
||
|
||
// 节日物资 仁泰 小计
|
||
double jrwz_rentai_xiaoji = 0.00;
|
||
// 节日物资 华夏 小计
|
||
double jrwz_huaxia_xiaoji = 0.00;
|
||
// 节日物资 锦绣 小计
|
||
double jrwz_jinxiu_xiaoji = 0.00;
|
||
// 节日物资 洵洲 小计
|
||
double jrwz_xunzhou_xiaoji = 0.00;
|
||
// 节日物资 仁泰 合计
|
||
double jrwz_heji = 0.00;
|
||
|
||
// 服装费用 仁泰 小计
|
||
double fzfy_rentai_xiaoji = 0.00;
|
||
// 服装费用 华夏 小计
|
||
double fzfy_huaxia_xiaoji = 0.00;
|
||
// 服装费用 锦绣 小计
|
||
double fzfy_jinxiu_xiaoji = 0.00;
|
||
// 服装费用 洵洲 小计
|
||
double fzfy_xunzhou_xiaoji = 0.00;
|
||
// 服装费用 仁泰 合计
|
||
double fzfy_heji = 0.00;
|
||
|
||
// 意外险 仁泰 小计
|
||
double ywx_rentai_xiaoji = 0.00;
|
||
// 意外险 华夏 小计
|
||
double ywx_huaxia_xiaoji = 0.00;
|
||
// 意外险 锦绣 小计
|
||
double ywx_jinxiu_xiaoji = 0.00;
|
||
// 意外险 洵洲 小计
|
||
double ywx_xunzhou_xiaoji = 0.00;
|
||
// 意外险 仁泰 合计
|
||
double ywx_heji = 0.00;
|
||
|
||
// 防暑降温 仁泰 小计
|
||
double fsjw_rentai_xiaoji = 0.00;
|
||
// 防暑降温 华夏 小计
|
||
double fsjw_huaxia_xiaoji = 0.00;
|
||
// 防暑降温 锦绣 小计
|
||
double fsjw_jinxiu_xiaoji = 0.00;
|
||
// 防暑降温 洵洲 小计
|
||
double fsjw_xunzhou_xiaoji = 0.00;
|
||
// 防暑降温 仁泰 合计
|
||
double fsjw_heji = 0.00;
|
||
|
||
// 培训费 仁泰 小计
|
||
double pxf_rentai_xiaoji = 0.00;
|
||
// 培训费 华夏 小计
|
||
double pxf_huaxia_xiaoji = 0.00;
|
||
// 培训费 锦绣 小计
|
||
double pxf_jinxiu_xiaoji = 0.00;
|
||
// 培训费 洵洲 小计
|
||
double pxf_xunzhou_xiaoji = 0.00;
|
||
// 培训费 仁泰 合计
|
||
double pxf_heji = 0.00;
|
||
|
||
// 工会经费 仁泰 小计
|
||
double ghjf_rentai_xiaoji = 0.00;
|
||
// 工会经费 华夏 小计
|
||
double ghjf_huaxia_xiaoji = 0.00;
|
||
// 工会经费 锦绣 小计
|
||
double ghjf_jinxiu_xiaoji = 0.00;
|
||
// 工会经费 洵洲 小计
|
||
double ghjf_xunzhou_xiaoji = 0.00;
|
||
// 工会经费 仁泰 合计
|
||
double ghjf_heji = 0.00;
|
||
|
||
// 党团活动费 仁泰 小计
|
||
double dthdf_rentai_xiaoji = 0.00;
|
||
// 党团活动费 华夏 小计
|
||
double dthdf_huaxia_xiaoji = 0.00;
|
||
// 党团活动费 锦绣 小计
|
||
double dthdf_jinxiu_xiaoji = 0.00;
|
||
// 党团活动费 洵洲 小计
|
||
double dthdf_xunzhou_xiaoji = 0.00;
|
||
// 党团活动费 仁泰 合计
|
||
double dthdf_heji = 0.00;
|
||
|
||
// 活动策划 仁泰 小计
|
||
double hdch_rentai_xiaoji = 0.00;
|
||
// 活动策划 华夏 小计
|
||
double hdch_huaxia_xiaoji = 0.00;
|
||
// 活动策划 锦绣 小计
|
||
double hdch_jinxiu_xiaoji = 0.00;
|
||
// 活动策划 洵洲 小计
|
||
double hdch_xunzhou_xiaoji = 0.00;
|
||
// 活动策划 仁泰 合计
|
||
double hdch_heji = 0.00;
|
||
|
||
// 差旅费 仁泰 小计
|
||
double clf_rentai_xiaoji = 0.00;
|
||
// 差旅费 华夏 小计
|
||
double clf_huaxia_xiaoji = 0.00;
|
||
// 差旅费 锦绣 小计
|
||
double clf_jinxiu_xiaoji = 0.00;
|
||
// 差旅费 洵洲 小计
|
||
double clf_xunzhou_xiaoji = 0.00;
|
||
// 差旅费 仁泰 合计
|
||
double clf_heji = 0.00;
|
||
|
||
// 管理成本 仁泰 小计
|
||
double glcb_rentai_xiaoji = 0.00;
|
||
// 管理成本 华夏 小计
|
||
double glcb_huaxia_xiaoji = 0.00;
|
||
// 管理成本 锦绣 小计
|
||
double glcb_jinxiu_xiaoji = 0.00;
|
||
// 管理成本 洵洲 小计
|
||
double glcb_xunzhou_xiaoji = 0.00;
|
||
// 管理成本 仁泰 合计
|
||
double glcb_heji = 0.00;
|
||
|
||
// 抵扣生育险 仁泰 小计
|
||
double dksyx_rentai_xiaoji = 0.00;
|
||
// 抵扣生育险 华夏 小计
|
||
double dksyx_huaxia_xiaoji = 0.00;
|
||
// 抵扣生育险 锦绣 小计
|
||
double dksyx_jinxiu_xiaoji = 0.00;
|
||
// 抵扣生育险 洵洲 小计
|
||
double dksyx_xunzhou_xiaoji = 0.00;
|
||
// 抵扣生育险 仁泰 合计
|
||
double dksyx_heji = 0.00;
|
||
|
||
// 一次性补偿金 仁泰 小计
|
||
double ycxbcj_rentai_xiaoji = 0.00;
|
||
// 一次性补偿金 华夏 小计
|
||
double ycxbcj_huaxia_xiaoji = 0.00;
|
||
// 一次性补偿金 锦绣 小计
|
||
double ycxbcj_jinxiu_xiaoji = 0.00;
|
||
// 一次性补偿金 洵洲 小计
|
||
double ycxbcj_xunzhou_xiaoji = 0.00;
|
||
// 一次性补偿金 仁泰 合计
|
||
double ycxbcj_heji = 0.00;
|
||
|
||
// 人资系统升级维护费 仁泰 小计
|
||
double rzxtsjwhf_rentai_xiaoji = 0.00;
|
||
// 人资系统升级维护费 华夏 小计
|
||
double rzxtsjwhf_huaxia_xiaoji = 0.00;
|
||
// 人资系统升级维护费 锦绣 小计
|
||
double rzxtsjwhf_jinxiu_xiaoji = 0.00;
|
||
// 人资系统升级维护费 洵洲 小计
|
||
double rzxtsjwhf_xunzhou_xiaoji = 0.00;
|
||
// 人资系统升级维护费 仁泰 合计
|
||
double rzxtsjwhf_heji = 0.00;
|
||
|
||
// 代扣水电费 仁泰 小计
|
||
double dksdf_rentai_xiaoji = 0.00;
|
||
// 代扣水电费 华夏 小计
|
||
double dksdf_huaxia_xiaoji = 0.00;
|
||
// 代扣水电费 锦绣 小计
|
||
double dksdf_jinxiu_xiaoji = 0.00;
|
||
// 代扣水电费 洵洲 小计
|
||
double dksdf_xunzhou_xiaoji = 0.00;
|
||
// 代扣水电费 仁泰 合计
|
||
double dksdf_heji = 0.00;
|
||
|
||
// 招标服务费 仁泰 小计
|
||
double zbfwf_rentai_xiaoji = 0.00;
|
||
// 招标服务费 华夏 小计
|
||
double zbfwf_huaxia_xiaoji = 0.00;
|
||
// 招标服务费 锦绣 小计
|
||
double zbfwf_jinxiu_xiaoji = 0.00;
|
||
// 招标服务费 洵洲 小计
|
||
double zbfwf_xunzhou_xiaoji = 0.00;
|
||
// 招标服务费 仁泰 合计
|
||
double zbfwf_heji = 0.00;
|
||
|
||
// 税点 仁泰 小计
|
||
double sd_rentai_xiaoji = 0.00;
|
||
// 税点 华夏 小计
|
||
double sd_huaxia_xiaoji = 0.00;
|
||
// 税点 锦绣 小计
|
||
double sd_jinxiu_xiaoji = 0.00;
|
||
// 税点 洵洲 小计
|
||
double sd_xunzhou_xiaoji = 0.00;
|
||
// 税点 仁泰 合计
|
||
double sd_heji = 0.00;
|
||
|
||
// 合计 仁泰 小计
|
||
double hj_rentai_xiaoji = 0.00;
|
||
// 合计 华夏 小计
|
||
double hj_huaxia_xiaoji = 0.00;
|
||
// 合计 锦绣 小计
|
||
double hj_jinxiu_xiaoji = 0.00;
|
||
// 合计 洵洲 小计
|
||
double hj_xunzhou_xiaoji = 0.00;
|
||
// 合计 仁泰 合计
|
||
double hj_heji = 0.00;
|
||
|
||
dataList_glf.add("管理费");
|
||
|
||
dataList_gz.add("工资");
|
||
|
||
dataList_nzjzyhq.add("年终奖、卓越后勤人等");
|
||
|
||
dataList_zxjt.add("专项津贴");
|
||
|
||
dataList_wx.add("五险");
|
||
|
||
dataList_gjj.add("公积金");
|
||
|
||
dataList_gzc.add("工作餐");
|
||
|
||
dataList_tjf.add("体检费");
|
||
|
||
dataList_jrwz.add("节日物资");
|
||
|
||
dataList_fzfy.add("服装费用");
|
||
|
||
dataList_ywx.add("意外险");
|
||
|
||
dataList_fsjw.add("防暑降温");
|
||
|
||
dataList_pxf.add("培训费");
|
||
|
||
dataList_ghjf.add("工会经费");
|
||
|
||
dataList_dthdf.add("党团活动费");
|
||
|
||
dataList_hdch.add("活动策划");
|
||
|
||
dataList_clf.add("差旅费");
|
||
|
||
dataList_glcb.add("管理成本");
|
||
|
||
dataList_dksyx.add("抵扣生育险");
|
||
|
||
dataList_ycxbcj.add("一次性补偿金");
|
||
|
||
dataList_rzxtsjwhf.add("人资系统升级维护费");
|
||
|
||
dataList_dksdf.add("代扣水电费");
|
||
|
||
dataList_zbfwf.add("招标服务费");
|
||
|
||
dataList_sd.add("税点");
|
||
|
||
dataList_hj.add("合计");
|
||
|
||
// 循环遍历日期
|
||
LocalDate currentDate = startDate;
|
||
while (!currentDate.isAfter(endDate)) { // 确保当前日期在结束日期之前或当天结束
|
||
// 格式化并打印当前日期
|
||
String formattedDate = currentDate.format(formatter);
|
||
// 将当前日期增加一个月（因为我们想要按月遍历）
|
||
currentDate = currentDate.plusMonths(1); // 注意：这将直接跳到下一个月的第一天
|
||
|
||
// 仁泰 合计
|
||
double rentai_hj = 0.00;
|
||
double hj_rentai = 0.00;
|
||
// 华夏 合计
|
||
double huaxia_hj = 0.00;
|
||
double hj_huaxia = 0.00;
|
||
// 锦绣 合计
|
||
double jinxiu_hj = 0.00;
|
||
double hj_jinxiu = 0.00;
|
||
// 洵洲 合计
|
||
double xunzhou_hj = 0.00;
|
||
double hj_xunzhou = 0.00;
|
||
|
||
// 仁泰 合计 税点
|
||
double rentai_hj_sd = 0.00;
|
||
// 华夏 合计 税点
|
||
double huaxia_hj_sd = 0.00;
|
||
// 锦绣 合计 税点
|
||
double jinxiu_hj_sd = 0.00;
|
||
// 洵洲 合计 税点
|
||
double xunzhou_hj_sd = 0.00;
|
||
|
||
// 仁泰 税点
|
||
double sd_rentai = 0.00;
|
||
// 华夏 税点
|
||
double sd_huaxia = 0.00;
|
||
// 锦绣 税点
|
||
double sd_jinxiu = 0.00;
|
||
// 洵洲 税点
|
||
double sd_xunzhou = 0.00;
|
||
|
||
//=========== 管理费 =============
|
||
// 管理费 仁泰
|
||
double glf_rentai = getSumFee("uf_glfgjtz",formattedDate,"1",gsgs);
|
||
dataList_glf.add(glf_rentai);
|
||
glf_rentai_xiaoji += glf_rentai;
|
||
|
||
|
||
// 管理费 华夏
|
||
double glf_huaxia = getSumFee("uf_glfgjtz",formattedDate,"0",gsgs);
|
||
dataList_glf.add(glf_huaxia);
|
||
glf_huaxia_xiaoji += glf_huaxia;
|
||
|
||
// 管理费 锦绣
|
||
double glf_jinxiu = getSumFee("uf_glfgjtz",formattedDate,"5",gsgs);
|
||
dataList_glf.add(glf_jinxiu);
|
||
glf_jinxiu_xiaoji += glf_jinxiu;
|
||
|
||
// 管理费 洵洲
|
||
double glf_xunzhou = getSumFee("uf_glfgjtz",formattedDate,"7",gsgs);
|
||
dataList_glf.add(glf_xunzhou);
|
||
glf_xunzhou_xiaoji += glf_xunzhou;
|
||
|
||
//=========== 工资 =============
|
||
// 工资 仁泰
|
||
double gz_rentai = getSumFee("uf_gzgltz",formattedDate,"1",gsgs);
|
||
dataList_gz.add(gz_rentai);
|
||
gz_rentai_xiaoji += gz_rentai;
|
||
|
||
// 工资 华夏
|
||
double gz_huaxia = getSumFee("uf_gzgltz",formattedDate,"0",gsgs);
|
||
dataList_gz.add(gz_huaxia);
|
||
gz_huaxia_xiaoji += gz_huaxia;
|
||
|
||
// 工资 锦绣
|
||
double gz_jinxiu = getSumFee("uf_gzgltz",formattedDate,"5",gsgs);
|
||
dataList_gz.add(gz_jinxiu);
|
||
gz_jinxiu_xiaoji += gz_jinxiu;
|
||
|
||
// 工资 洵洲
|
||
double gz_xunzhou = getSumFee("uf_gzgltz",formattedDate,"7",gsgs);
|
||
dataList_gz.add(gz_xunzhou);
|
||
gz_xunzhou_xiaoji += gz_xunzhou;
|
||
|
||
//=========== 年终奖、卓越后勤人等 ================
|
||
// 年终奖、卓越后勤人等 仁泰
|
||
double nzjzyhq_rentai = getSumFee("uf_nzjzyhq",formattedDate,"1",gsgs);
|
||
dataList_nzjzyhq.add(nzjzyhq_rentai);
|
||
nzjzyhq_rentai_xiaoji += nzjzyhq_rentai;
|
||
|
||
// 年终奖、卓越后勤人等 华夏
|
||
double nzjzyhq_huaxia = getSumFee("uf_nzjzyhq",formattedDate,"0",gsgs);
|
||
dataList_nzjzyhq.add(nzjzyhq_huaxia);
|
||
nzjzyhq_huaxia_xiaoji += nzjzyhq_huaxia;
|
||
|
||
// 年终奖、卓越后勤人等 锦绣
|
||
double nzjzyhq_jinxiu = getSumFee("uf_nzjzyhq",formattedDate,"5",gsgs);
|
||
dataList_nzjzyhq.add(nzjzyhq_jinxiu);
|
||
nzjzyhq_jinxiu_xiaoji += nzjzyhq_jinxiu;
|
||
|
||
// 年终奖、卓越后勤人等 洵洲
|
||
double nzjzyhq_xunzhou = getSumFee("uf_nzjzyhq",formattedDate,"7",gsgs);
|
||
dataList_nzjzyhq.add(nzjzyhq_xunzhou);
|
||
nzjzyhq_xunzhou_xiaoji += nzjzyhq_xunzhou;
|
||
|
||
//=========== 专项津贴 =============
|
||
// 专项津贴 仁泰
|
||
double zxjt_rentai = getSumFee("uf_zxjt",formattedDate,"1",gsgs);
|
||
dataList_zxjt.add(zxjt_rentai);
|
||
zxjt_rentai_xiaoji += zxjt_rentai;
|
||
|
||
// 专项津贴 华夏
|
||
double zxjt_huaxia = getSumFee("uf_zxjt",formattedDate,"0",gsgs);
|
||
dataList_zxjt.add(zxjt_huaxia);
|
||
zxjt_huaxia_xiaoji += zxjt_huaxia;
|
||
|
||
// 专项津贴 锦绣
|
||
double zxjt_jinxiu = getSumFee("uf_zxjt",formattedDate,"5",gsgs);
|
||
dataList_zxjt.add(zxjt_jinxiu);
|
||
zxjt_jinxiu_xiaoji += zxjt_jinxiu;
|
||
|
||
// 专项津贴 洵洲
|
||
double zxjt_xunzhou = getSumFee("uf_zxjt",formattedDate,"7",gsgs);
|
||
dataList_zxjt.add(zxjt_xunzhou);
|
||
zxjt_xunzhou_xiaoji += zxjt_xunzhou;
|
||
|
||
//=========== 五险 =============
|
||
// 五险 仁泰
|
||
double wx_rentai = getSumFee("uf_wx",formattedDate,"1",gsgs);
|
||
dataList_wx.add(wx_rentai);
|
||
wx_rentai_xiaoji += wx_rentai;
|
||
|
||
// 五险 华夏
|
||
double wx_huaxia = getSumFee("uf_wx",formattedDate,"0",gsgs);
|
||
dataList_wx.add(wx_huaxia);
|
||
wx_huaxia_xiaoji += wx_huaxia;
|
||
|
||
// 五险 锦绣
|
||
double wx_jinxiu = getSumFee("uf_wx",formattedDate,"5",gsgs);
|
||
dataList_wx.add(wx_jinxiu);
|
||
wx_jinxiu_xiaoji += wx_jinxiu;
|
||
|
||
// 五险 洵洲
|
||
double wx_xunzhou = getSumFee("uf_wx",formattedDate,"7",gsgs);
|
||
dataList_wx.add(wx_xunzhou);
|
||
wx_xunzhou_xiaoji += wx_xunzhou;
|
||
|
||
//=========== 公积金 =============
|
||
// 公积金 仁泰
|
||
double gjj_rentai = getSumFee("uf_gjj",formattedDate,"1",gsgs);
|
||
dataList_gjj.add(gjj_rentai);
|
||
gjj_rentai_xiaoji += gjj_rentai;
|
||
|
||
// 公积金 华夏
|
||
double gjj_huaxia = getSumFee("uf_gjj",formattedDate,"0",gsgs);
|
||
dataList_gjj.add(gjj_huaxia);
|
||
gjj_huaxia_xiaoji += gjj_huaxia;
|
||
|
||
// 公积金 锦绣
|
||
double gjj_jinxiu = getSumFee("uf_gjj",formattedDate,"5",gsgs);
|
||
dataList_gjj.add(gjj_jinxiu);
|
||
gjj_jinxiu_xiaoji += gjj_jinxiu;
|
||
|
||
// 公积金 洵洲
|
||
double gjj_xunzhou = getSumFee("uf_gjj",formattedDate,"7",gsgs);
|
||
dataList_gjj.add(gjj_xunzhou);
|
||
gjj_xunzhou_xiaoji += gjj_xunzhou;
|
||
|
||
//=========== 工作餐 =============
|
||
// 工作餐 仁泰
|
||
double gzc_rentai = getSumFee("uf_zzc",formattedDate,"1",gsgs);
|
||
dataList_gzc.add(gzc_rentai);
|
||
gzc_rentai_xiaoji += gzc_rentai;
|
||
|
||
// 工作餐 华夏
|
||
double gzc_huaxia = getSumFee("uf_zzc",formattedDate,"0",gsgs);
|
||
dataList_gzc.add(gzc_huaxia);
|
||
gzc_huaxia_xiaoji += gzc_huaxia;
|
||
|
||
// 工作餐 锦绣
|
||
double gzc_jinxiu = getSumFee("uf_zzc",formattedDate,"5",gsgs);
|
||
dataList_gzc.add(gzc_jinxiu);
|
||
gzc_jinxiu_xiaoji += gzc_jinxiu;
|
||
|
||
// 工作餐 洵洲
|
||
double gzc_xunzhou = getSumFee("uf_zzc",formattedDate,"7",gsgs);
|
||
dataList_gzc.add(gzc_xunzhou);
|
||
gzc_xunzhou_xiaoji += gzc_xunzhou;
|
||
|
||
//=========== 体检费 =============
|
||
// 体检费 仁泰
|
||
double tjf_rentai = getSumFee("uf_tjf",formattedDate,"1",gsgs);
|
||
dataList_tjf.add(tjf_rentai);
|
||
tjf_rentai_xiaoji += tjf_rentai;
|
||
|
||
// 体检费 华夏
|
||
double tjf_huaxia = getSumFee("uf_tjf",formattedDate,"0",gsgs);
|
||
dataList_tjf.add(tjf_huaxia);
|
||
tjf_huaxia_xiaoji += tjf_huaxia;
|
||
|
||
// 体检费 锦绣
|
||
double tjf_jinxiu = getSumFee("uf_tjf",formattedDate,"5",gsgs);
|
||
dataList_tjf.add(tjf_jinxiu);
|
||
tjf_jinxiu_xiaoji += tjf_jinxiu;
|
||
|
||
// 体检费 洵洲
|
||
double tjf_xunzhou = getSumFee("uf_tjf",formattedDate,"7",gsgs);
|
||
dataList_tjf.add(tjf_xunzhou);
|
||
tjf_xunzhou_xiaoji += tjf_xunzhou;
|
||
|
||
//=========== 节日物资 =============
|
||
// 节日物资 仁泰
|
||
double jrwz_rentai = getSumFee("uf_jrwz",formattedDate,"1",gsgs);
|
||
dataList_jrwz.add(jrwz_rentai);
|
||
jrwz_rentai_xiaoji += jrwz_rentai;
|
||
|
||
// 节日物资 华夏
|
||
double jrwz_huaxia = getSumFee("uf_jrwz",formattedDate,"0",gsgs);
|
||
dataList_jrwz.add(jrwz_huaxia);
|
||
jrwz_huaxia_xiaoji += jrwz_huaxia;
|
||
|
||
// 节日物资 锦绣
|
||
double jrwz_jinxiu = getSumFee("uf_jrwz",formattedDate,"5",gsgs);
|
||
dataList_jrwz.add(jrwz_jinxiu);
|
||
jrwz_jinxiu_xiaoji += jrwz_jinxiu;
|
||
|
||
// 节日物资 洵洲
|
||
double jrwz_xunzhou = getSumFee("uf_jrwz",formattedDate,"7",gsgs);
|
||
dataList_jrwz.add(jrwz_xunzhou);
|
||
jrwz_xunzhou_xiaoji += jrwz_xunzhou;
|
||
|
||
//=========== 服装费用 =============
|
||
// 服装费用 仁泰
|
||
double fzfy_rentai = getSumFee("uf_fzfy",formattedDate,"1",gsgs);
|
||
dataList_fzfy.add(fzfy_rentai);
|
||
fzfy_rentai_xiaoji += fzfy_rentai;
|
||
|
||
// 服装费用 华夏
|
||
double fzfy_huaxia = getSumFee("uf_fzfy",formattedDate,"0",gsgs);
|
||
dataList_fzfy.add(fzfy_huaxia);
|
||
fzfy_huaxia_xiaoji += fzfy_huaxia;
|
||
|
||
// 服装费用 锦绣
|
||
double fzfy_jinxiu = getSumFee("uf_fzfy",formattedDate,"5",gsgs);
|
||
dataList_fzfy.add(fzfy_jinxiu);
|
||
fzfy_jinxiu_xiaoji += fzfy_jinxiu;
|
||
|
||
// 服装费用 洵洲
|
||
double fzfy_xunzhou = getSumFee("uf_fzfy",formattedDate,"7",gsgs);
|
||
dataList_fzfy.add(fzfy_xunzhou);
|
||
fzfy_xunzhou_xiaoji += fzfy_xunzhou;
|
||
|
||
//=========== 意外险 =============
|
||
// 意外险 仁泰
|
||
double ywx_rentai = getSumFee("uf_ywx",formattedDate,"1",gsgs);
|
||
dataList_ywx.add(ywx_rentai);
|
||
ywx_rentai_xiaoji += ywx_rentai;
|
||
|
||
// 意外险 华夏
|
||
double ywx_huaxia = getSumFee("uf_ywx",formattedDate,"0",gsgs);
|
||
dataList_ywx.add(ywx_huaxia);
|
||
ywx_huaxia_xiaoji += ywx_huaxia;
|
||
|
||
// 意外险 锦绣
|
||
double ywx_jinxiu = getSumFee("uf_ywx",formattedDate,"5",gsgs);
|
||
dataList_ywx.add(ywx_jinxiu);
|
||
ywx_jinxiu_xiaoji += ywx_jinxiu;
|
||
|
||
// 意外险 洵洲
|
||
double ywx_xunzhou = getSumFee("uf_ywx",formattedDate,"7",gsgs);
|
||
dataList_ywx.add(ywx_xunzhou);
|
||
ywx_xunzhou_xiaoji += ywx_xunzhou;
|
||
|
||
//=========== 防暑降温 =============
|
||
// 防暑降温 仁泰
|
||
double fsjw_rentai = getSumFee("uf_fsjw",formattedDate,"1",gsgs);
|
||
dataList_fsjw.add(fsjw_rentai);
|
||
fsjw_rentai_xiaoji += fsjw_rentai;
|
||
|
||
// 防暑降温 华夏
|
||
double fsjw_huaxia = getSumFee("uf_fsjw",formattedDate,"0",gsgs);
|
||
dataList_fsjw.add(fsjw_huaxia);
|
||
fsjw_huaxia_xiaoji += fsjw_huaxia;
|
||
|
||
// 防暑降温 锦绣
|
||
double fsjw_jinxiu = getSumFee("uf_fsjw",formattedDate,"5",gsgs);
|
||
dataList_fsjw.add(fsjw_jinxiu);
|
||
fsjw_jinxiu_xiaoji += fsjw_jinxiu;
|
||
|
||
// 防暑降温 洵洲
|
||
double fsjw_xunzhou = getSumFee("uf_fsjw",formattedDate,"7",gsgs);
|
||
dataList_fsjw.add(fsjw_xunzhou);
|
||
fsjw_xunzhou_xiaoji += fsjw_xunzhou;
|
||
|
||
//=========== 培训费 =============
|
||
// 培训费 仁泰
|
||
double pxf_rentai = getSumFee("uf_pxf",formattedDate,"1",gsgs);
|
||
dataList_pxf.add(pxf_rentai);
|
||
pxf_rentai_xiaoji += pxf_rentai;
|
||
|
||
// 培训费 华夏
|
||
double pxf_huaxia = getSumFee("uf_pxf",formattedDate,"0",gsgs);
|
||
dataList_pxf.add(pxf_huaxia);
|
||
pxf_huaxia_xiaoji += pxf_huaxia;
|
||
|
||
// 培训费 锦绣
|
||
double pxf_jinxiu = getSumFee("uf_pxf",formattedDate,"5",gsgs);
|
||
dataList_pxf.add(pxf_jinxiu);
|
||
pxf_jinxiu_xiaoji += pxf_jinxiu;
|
||
|
||
// 培训费 洵洲
|
||
double pxf_xunzhou = getSumFee("uf_pxf",formattedDate,"7",gsgs);
|
||
dataList_pxf.add(pxf_xunzhou);
|
||
pxf_xunzhou_xiaoji += pxf_xunzhou;
|
||
|
||
//=========== 工会经费 =============
|
||
// 工会经费 仁泰
|
||
double ghjf_rentai = getSumFee("uf_ghjf",formattedDate,"1",gsgs);
|
||
dataList_ghjf.add(ghjf_rentai);
|
||
ghjf_rentai_xiaoji += ghjf_rentai;
|
||
|
||
// 工会经费 华夏
|
||
double ghjf_huaxia = getSumFee("uf_ghjf",formattedDate,"0",gsgs);
|
||
dataList_ghjf.add(ghjf_huaxia);
|
||
ghjf_huaxia_xiaoji += ghjf_huaxia;
|
||
|
||
// 工会经费 锦绣
|
||
double ghjf_jinxiu = getSumFee("uf_ghjf",formattedDate,"5",gsgs);
|
||
dataList_ghjf.add(ghjf_jinxiu);
|
||
ghjf_jinxiu_xiaoji += ghjf_jinxiu;
|
||
|
||
// 工会经费 洵洲
|
||
double ghjf_xunzhou = getSumFee("uf_ghjf",formattedDate,"7",gsgs);
|
||
dataList_ghjf.add(ghjf_xunzhou);
|
||
ghjf_xunzhou_xiaoji += ghjf_xunzhou;
|
||
|
||
//=========== 党团活动费 =============
|
||
// 党团活动费 仁泰
|
||
double dthdf_rentai = getSumFee("uf_dthdf",formattedDate,"1",gsgs);
|
||
dataList_dthdf.add(dthdf_rentai);
|
||
dthdf_rentai_xiaoji += dthdf_rentai;
|
||
|
||
// 党团活动费 华夏
|
||
double dthdf_huaxia = getSumFee("uf_dthdf",formattedDate,"0",gsgs);
|
||
dataList_dthdf.add(dthdf_huaxia);
|
||
dthdf_huaxia_xiaoji += dthdf_huaxia;
|
||
|
||
// 党团活动费 锦绣
|
||
double dthdf_jinxiu = getSumFee("uf_dthdf",formattedDate,"5",gsgs);
|
||
dataList_dthdf.add(dthdf_jinxiu);
|
||
dthdf_jinxiu_xiaoji += dthdf_jinxiu;
|
||
|
||
// 党团活动费 洵洲
|
||
double dthdf_xunzhou = getSumFee("uf_dthdf",formattedDate,"7",gsgs);
|
||
dataList_dthdf.add(dthdf_xunzhou);
|
||
dthdf_xunzhou_xiaoji += dthdf_xunzhou;
|
||
|
||
//=========== 活动策划 =============
|
||
// 活动策划 仁泰
|
||
double hdch_rentai = getSumFee("uf_hdch",formattedDate,"1",gsgs);
|
||
dataList_hdch.add(hdch_rentai);
|
||
hdch_rentai_xiaoji += hdch_rentai;
|
||
|
||
// 活动策划 华夏
|
||
double hdch_huaxia = getSumFee("uf_hdch",formattedDate,"0",gsgs);
|
||
dataList_hdch.add(hdch_huaxia);
|
||
hdch_huaxia_xiaoji += hdch_huaxia;
|
||
|
||
// 活动策划 锦绣
|
||
double hdch_jinxiu = getSumFee("uf_hdch",formattedDate,"5",gsgs);
|
||
dataList_hdch.add(hdch_jinxiu);
|
||
hdch_jinxiu_xiaoji += hdch_jinxiu;
|
||
|
||
// 活动策划 洵洲
|
||
double hdch_xunzhou = getSumFee("uf_hdch",formattedDate,"7",gsgs);
|
||
dataList_hdch.add(hdch_xunzhou);
|
||
hdch_xunzhou_xiaoji += hdch_xunzhou;
|
||
|
||
//=========== 差旅费 =============
|
||
// 差旅费 仁泰
|
||
double clf_rentai = getSumFee("uf_clfdj",formattedDate,"1",gsgs);
|
||
dataList_clf.add(clf_rentai);
|
||
clf_rentai_xiaoji += clf_rentai;
|
||
|
||
// 差旅费 华夏
|
||
double clf_huaxia = getSumFee("uf_clfdj",formattedDate,"0",gsgs);
|
||
dataList_clf.add(clf_huaxia);
|
||
clf_huaxia_xiaoji += clf_huaxia;
|
||
|
||
// 差旅费 锦绣
|
||
double clf_jinxiu = getSumFee("uf_clfdj",formattedDate,"5",gsgs);
|
||
dataList_clf.add(clf_jinxiu);
|
||
clf_jinxiu_xiaoji += clf_jinxiu;
|
||
|
||
// 差旅费 洵洲
|
||
double clf_xunzhou = getSumFee("uf_clfdj",formattedDate,"7",gsgs);
|
||
dataList_clf.add(clf_xunzhou);
|
||
clf_xunzhou_xiaoji += clf_xunzhou;
|
||
|
||
//=========== 管理成本 =============
|
||
// 管理成本 仁泰
|
||
double glcb_rentai = getSumFee("uf_glcb",formattedDate,"1",gsgs);
|
||
dataList_glcb.add(glcb_rentai);
|
||
glcb_rentai_xiaoji += glcb_rentai;
|
||
|
||
// 管理成本 华夏
|
||
double glcb_huaxia = getSumFee("uf_glcb",formattedDate,"0",gsgs);
|
||
dataList_glcb.add(glcb_huaxia);
|
||
glcb_huaxia_xiaoji += glcb_huaxia;
|
||
|
||
// 管理成本 锦绣
|
||
double glcb_jinxiu = getSumFee("uf_glcb",formattedDate,"5",gsgs);
|
||
dataList_glcb.add(glcb_jinxiu);
|
||
glcb_jinxiu_xiaoji += glcb_jinxiu;
|
||
|
||
// 管理成本 洵洲
|
||
double glcb_xunzhou = getSumFee("uf_glcb",formattedDate,"7",gsgs);
|
||
dataList_glcb.add(glcb_xunzhou);
|
||
glcb_xunzhou_xiaoji += glcb_xunzhou;
|
||
|
||
//=========== 抵扣生育险 =============
|
||
// 抵扣生育险 仁泰
|
||
double dksyx_rentai = getSumFee("uf_dksyx",formattedDate,"1",gsgs);
|
||
dataList_dksyx.add(dksyx_rentai);
|
||
dksyx_rentai_xiaoji += dksyx_rentai;
|
||
|
||
// 抵扣生育险 华夏
|
||
double dksyx_huaxia = getSumFee("uf_dksyx",formattedDate,"0",gsgs);
|
||
dataList_dksyx.add(dksyx_huaxia);
|
||
dksyx_huaxia_xiaoji += dksyx_huaxia;
|
||
|
||
// 抵扣生育险 锦绣
|
||
double dksyx_jinxiu = getSumFee("uf_dksyx",formattedDate,"5",gsgs);
|
||
dataList_dksyx.add(dksyx_jinxiu);
|
||
dksyx_jinxiu_xiaoji += dksyx_jinxiu;
|
||
|
||
// 抵扣生育险 洵洲
|
||
double dksyx_xunzhou = getSumFee("uf_dksyx",formattedDate,"7",gsgs);
|
||
dataList_dksyx.add(dksyx_xunzhou);
|
||
dksyx_xunzhou_xiaoji += dksyx_xunzhou;
|
||
|
||
//=========== 一次性补偿金 =============
|
||
// 一次性补偿金 仁泰
|
||
double ycxbcj_rentai = getSumFee("uf_bcj",formattedDate,"1",gsgs);
|
||
dataList_ycxbcj.add(ycxbcj_rentai);
|
||
ycxbcj_rentai_xiaoji += ycxbcj_rentai;
|
||
|
||
// 一次性补偿金 华夏
|
||
double ycxbcj_huaxia = getSumFee("uf_bcj",formattedDate,"0",gsgs);
|
||
dataList_ycxbcj.add(ycxbcj_huaxia);
|
||
ycxbcj_huaxia_xiaoji += ycxbcj_huaxia;
|
||
|
||
// 一次性补偿金 锦绣
|
||
double ycxbcj_jinxiu = getSumFee("uf_bcj",formattedDate,"5",gsgs);
|
||
dataList_ycxbcj.add(ycxbcj_jinxiu);
|
||
ycxbcj_jinxiu_xiaoji += ycxbcj_jinxiu;
|
||
|
||
// 一次性补偿金 洵洲
|
||
double ycxbcj_xunzhou = getSumFee("uf_bcj",formattedDate,"7",gsgs);
|
||
dataList_ycxbcj.add(ycxbcj_xunzhou);
|
||
ycxbcj_xunzhou_xiaoji += ycxbcj_xunzhou;
|
||
|
||
//=========== 人资系统升级维护费 =============
|
||
// 人资系统升级维护费 仁泰
|
||
double rzxtsjwhf_rentai = getSumFee("uf_sjwhf",formattedDate,"1",gsgs);
|
||
dataList_rzxtsjwhf.add(rzxtsjwhf_rentai);
|
||
rzxtsjwhf_rentai_xiaoji += rzxtsjwhf_rentai;
|
||
|
||
// 人资系统升级维护费 华夏
|
||
double rzxtsjwhf_huaxia = getSumFee("uf_sjwhf",formattedDate,"0",gsgs);
|
||
dataList_rzxtsjwhf.add(rzxtsjwhf_huaxia);
|
||
rzxtsjwhf_huaxia_xiaoji += rzxtsjwhf_huaxia;
|
||
|
||
// 人资系统升级维护费 锦绣
|
||
double rzxtsjwhf_jinxiu = getSumFee("uf_sjwhf",formattedDate,"5",gsgs);
|
||
dataList_rzxtsjwhf.add(rzxtsjwhf_jinxiu);
|
||
rzxtsjwhf_jinxiu_xiaoji += rzxtsjwhf_jinxiu;
|
||
|
||
// 人资系统升级维护费 洵洲
|
||
double rzxtsjwhf_xunzhou = getSumFee("uf_sjwhf",formattedDate,"7",gsgs);
|
||
dataList_rzxtsjwhf.add(rzxtsjwhf_xunzhou);
|
||
rzxtsjwhf_xunzhou_xiaoji += rzxtsjwhf_xunzhou;
|
||
|
||
//=========== 代扣水电费 =============
|
||
// 代扣水电费 仁泰
|
||
double dksdf_rentai = getSumFee("uf_dksdf",formattedDate,"1",gsgs);
|
||
dataList_dksdf.add(dksdf_rentai);
|
||
dksdf_rentai_xiaoji += dksdf_rentai;
|
||
|
||
// 代扣水电费 华夏
|
||
double dksdf_huaxia = getSumFee("uf_dksdf",formattedDate,"0",gsgs);
|
||
dataList_dksdf.add(dksdf_huaxia);
|
||
dksdf_huaxia_xiaoji += dksdf_huaxia;
|
||
|
||
// 代扣水电费 锦绣
|
||
double dksdf_jinxiu = getSumFee("uf_dksdf",formattedDate,"5",gsgs);
|
||
dataList_dksdf.add(dksdf_jinxiu);
|
||
dksdf_jinxiu_xiaoji += dksdf_jinxiu;
|
||
|
||
// 代扣水电费 洵洲
|
||
double dksdf_xunzhou = getSumFee("uf_dksdf",formattedDate,"7",gsgs);
|
||
dataList_dksdf.add(dksdf_xunzhou);
|
||
dksdf_xunzhou_xiaoji += dksdf_xunzhou;
|
||
|
||
//=========== 招标服务费 =============
|
||
// 招标服务费 仁泰
|
||
double zbfwf_rentai = getSumFee("uf_zbfwf",formattedDate,"1",gsgs);
|
||
dataList_zbfwf.add(zbfwf_rentai);
|
||
zbfwf_rentai_xiaoji += zbfwf_rentai;
|
||
|
||
// 招标服务费 华夏
|
||
double zbfwf_huaxia = getSumFee("uf_zbfwf",formattedDate,"0",gsgs);
|
||
dataList_zbfwf.add(zbfwf_huaxia);
|
||
zbfwf_huaxia_xiaoji += zbfwf_huaxia;
|
||
|
||
// 招标服务费 锦绣
|
||
double zbfwf_jinxiu = getSumFee("uf_zbfwf",formattedDate,"5",gsgs);
|
||
dataList_zbfwf.add(zbfwf_jinxiu);
|
||
zbfwf_jinxiu_xiaoji += zbfwf_jinxiu;
|
||
|
||
// 招标服务费 洵洲
|
||
double zbfwf_xunzhou = getSumFee("uf_zbfwf",formattedDate,"7",gsgs);
|
||
dataList_zbfwf.add(zbfwf_xunzhou);
|
||
zbfwf_xunzhou_xiaoji += zbfwf_xunzhou;
|
||
|
||
rentai_hj = glf_rentai+gz_rentai+nzjzyhq_rentai+zxjt_rentai+wx_rentai+gjj_rentai+gzc_rentai+tjf_rentai+jrwz_rentai+fzfy_rentai+ywx_rentai+fsjw_rentai+pxf_rentai+
|
||
ghjf_rentai+dthdf_rentai+hdch_rentai+clf_rentai+glcb_rentai+dksyx_rentai+ycxbcj_rentai+rzxtsjwhf_rentai+dksdf_rentai+zbfwf_rentai;
|
||
|
||
rentai_hj_sd = rentai_hj - glf_rentai - zbfwf_rentai;
|
||
sd_rentai = Double.parseDouble(floatMultiply(String.valueOf(rentai_hj_sd),"0.06"));
|
||
hj_rentai = rentai_hj + sd_rentai;
|
||
|
||
huaxia_hj = glf_huaxia+gz_huaxia+nzjzyhq_huaxia+zxjt_huaxia+wx_huaxia+gjj_huaxia+gzc_huaxia+tjf_huaxia+jrwz_huaxia+fzfy_huaxia+ywx_huaxia+fsjw_huaxia+pxf_huaxia+
|
||
ghjf_huaxia+dthdf_huaxia+hdch_huaxia+clf_huaxia+glcb_huaxia+dksyx_huaxia+ycxbcj_huaxia+rzxtsjwhf_huaxia+dksdf_huaxia+zbfwf_huaxia;
|
||
|
||
huaxia_hj_sd = huaxia_hj - glf_huaxia - zbfwf_huaxia;
|
||
sd_huaxia = Double.parseDouble(floatMultiply(String.valueOf(huaxia_hj_sd),"0.06"));
|
||
hj_huaxia = huaxia_hj + sd_huaxia;
|
||
|
||
jinxiu_hj = glf_jinxiu+gz_jinxiu+nzjzyhq_jinxiu+zxjt_jinxiu+wx_jinxiu+gjj_jinxiu+gzc_jinxiu+tjf_jinxiu+jrwz_jinxiu+fzfy_jinxiu+ywx_jinxiu+fsjw_jinxiu+pxf_jinxiu+
|
||
ghjf_jinxiu+dthdf_jinxiu+hdch_jinxiu+clf_jinxiu+glcb_jinxiu+dksyx_jinxiu+ycxbcj_jinxiu+rzxtsjwhf_jinxiu+dksdf_jinxiu+zbfwf_jinxiu;
|
||
|
||
jinxiu_hj_sd = jinxiu_hj - glf_jinxiu - zbfwf_jinxiu;
|
||
sd_jinxiu = Double.parseDouble(floatMultiply(String.valueOf(jinxiu_hj_sd),"0.06"));
|
||
hj_jinxiu = jinxiu_hj + sd_jinxiu;
|
||
|
||
xunzhou_hj = glf_xunzhou+gz_xunzhou+nzjzyhq_xunzhou+zxjt_xunzhou+wx_xunzhou+gjj_xunzhou+gzc_xunzhou+tjf_xunzhou+jrwz_xunzhou+fzfy_xunzhou+ywx_xunzhou+fsjw_xunzhou+pxf_xunzhou+
|
||
ghjf_xunzhou+dthdf_xunzhou+hdch_xunzhou+clf_xunzhou+glcb_xunzhou+dksyx_xunzhou+ycxbcj_xunzhou+rzxtsjwhf_xunzhou+dksdf_xunzhou+zbfwf_xunzhou;
|
||
|
||
xunzhou_hj_sd = xunzhou_hj - glf_xunzhou - zbfwf_xunzhou;
|
||
sd_xunzhou = Double.parseDouble(floatMultiply(String.valueOf(xunzhou_hj_sd),"0.06"));
|
||
hj_xunzhou = xunzhou_hj + sd_xunzhou;
|
||
|
||
//=========== 税点 =============
|
||
// 税点 仁泰
|
||
dataList_sd.add(sd_rentai);
|
||
sd_rentai_xiaoji += sd_rentai;
|
||
|
||
// 税点 华夏
|
||
dataList_sd.add(sd_huaxia);
|
||
sd_huaxia_xiaoji += sd_huaxia;
|
||
|
||
// 税点 锦绣
|
||
dataList_sd.add(sd_jinxiu);
|
||
sd_jinxiu_xiaoji += sd_jinxiu;
|
||
|
||
// 税点 洵洲
|
||
dataList_sd.add(sd_xunzhou);
|
||
sd_xunzhou_xiaoji += sd_xunzhou;
|
||
|
||
//=========== 合计 =============
|
||
// 合计 仁泰
|
||
dataList_hj.add(df.format(hj_rentai));
|
||
hj_rentai_xiaoji += hj_rentai;
|
||
|
||
// 合计 华夏
|
||
dataList_hj.add(df.format(hj_huaxia));
|
||
hj_huaxia_xiaoji += hj_huaxia;
|
||
|
||
// 合计 锦绣
|
||
dataList_hj.add(df.format(hj_jinxiu));
|
||
hj_jinxiu_xiaoji += hj_jinxiu;
|
||
|
||
// 合计 洵洲
|
||
dataList_hj.add(df.format(hj_xunzhou));
|
||
hj_xunzhou_xiaoji += hj_xunzhou;
|
||
|
||
}
|
||
|
||
glf_heji = glf_rentai_xiaoji+glf_huaxia_xiaoji+glf_jinxiu_xiaoji+glf_xunzhou_xiaoji;
|
||
|
||
gz_heji = gz_rentai_xiaoji+gz_huaxia_xiaoji+gz_jinxiu_xiaoji+gz_xunzhou_xiaoji;
|
||
|
||
nzjzyhq_heji = nzjzyhq_rentai_xiaoji+nzjzyhq_huaxia_xiaoji+nzjzyhq_jinxiu_xiaoji+nzjzyhq_xunzhou_xiaoji;
|
||
|
||
zxjt_heji = zxjt_rentai_xiaoji+zxjt_huaxia_xiaoji+zxjt_jinxiu_xiaoji+zxjt_xunzhou_xiaoji;
|
||
|
||
wx_heji = wx_rentai_xiaoji+wx_huaxia_xiaoji+wx_jinxiu_xiaoji+wx_xunzhou_xiaoji;
|
||
|
||
gjj_heji = gjj_rentai_xiaoji+gjj_huaxia_xiaoji+gjj_jinxiu_xiaoji+gjj_xunzhou_xiaoji;
|
||
|
||
gzc_heji = gzc_rentai_xiaoji+gzc_huaxia_xiaoji+gzc_jinxiu_xiaoji+gzc_xunzhou_xiaoji;
|
||
|
||
tjf_heji = tjf_rentai_xiaoji+tjf_huaxia_xiaoji+tjf_jinxiu_xiaoji+tjf_xunzhou_xiaoji;
|
||
|
||
jrwz_heji = jrwz_rentai_xiaoji+jrwz_huaxia_xiaoji+jrwz_jinxiu_xiaoji+jrwz_xunzhou_xiaoji;
|
||
|
||
fzfy_heji = fzfy_rentai_xiaoji+fzfy_huaxia_xiaoji+fzfy_jinxiu_xiaoji+fzfy_xunzhou_xiaoji;
|
||
|
||
ywx_heji = ywx_rentai_xiaoji+ywx_huaxia_xiaoji+ywx_jinxiu_xiaoji+ywx_xunzhou_xiaoji;
|
||
|
||
fsjw_heji = fsjw_rentai_xiaoji+fsjw_huaxia_xiaoji+fsjw_jinxiu_xiaoji+fsjw_xunzhou_xiaoji;
|
||
|
||
pxf_heji = pxf_rentai_xiaoji+pxf_huaxia_xiaoji+pxf_jinxiu_xiaoji+pxf_xunzhou_xiaoji;
|
||
|
||
ghjf_heji = ghjf_rentai_xiaoji+ghjf_huaxia_xiaoji+ghjf_jinxiu_xiaoji+ghjf_xunzhou_xiaoji;
|
||
|
||
dthdf_heji = dthdf_rentai_xiaoji+dthdf_huaxia_xiaoji+dthdf_jinxiu_xiaoji+dthdf_xunzhou_xiaoji;
|
||
|
||
hdch_heji = hdch_rentai_xiaoji+hdch_huaxia_xiaoji+hdch_jinxiu_xiaoji+hdch_xunzhou_xiaoji;
|
||
|
||
clf_heji = clf_rentai_xiaoji+clf_huaxia_xiaoji+clf_jinxiu_xiaoji+clf_xunzhou_xiaoji;
|
||
|
||
glcb_heji = glcb_rentai_xiaoji+glcb_huaxia_xiaoji+glcb_jinxiu_xiaoji+glcb_xunzhou_xiaoji;
|
||
|
||
dksyx_heji = dksyx_rentai_xiaoji+dksyx_huaxia_xiaoji+dksyx_jinxiu_xiaoji+dksyx_xunzhou_xiaoji;
|
||
|
||
ycxbcj_heji = ycxbcj_rentai_xiaoji+ycxbcj_huaxia_xiaoji+ycxbcj_jinxiu_xiaoji+ycxbcj_xunzhou_xiaoji;
|
||
|
||
rzxtsjwhf_heji = rzxtsjwhf_rentai_xiaoji+rzxtsjwhf_huaxia_xiaoji+rzxtsjwhf_jinxiu_xiaoji+rzxtsjwhf_xunzhou_xiaoji;
|
||
|
||
dksdf_heji = dksdf_rentai_xiaoji+dksdf_huaxia_xiaoji+dksdf_jinxiu_xiaoji+dksdf_xunzhou_xiaoji;
|
||
|
||
zbfwf_heji = zbfwf_rentai_xiaoji+zbfwf_huaxia_xiaoji+zbfwf_jinxiu_xiaoji+zbfwf_xunzhou_xiaoji;
|
||
|
||
sd_heji = sd_rentai_xiaoji+sd_huaxia_xiaoji+sd_jinxiu_xiaoji+sd_xunzhou_xiaoji;
|
||
|
||
hj_heji = hj_rentai_xiaoji+hj_huaxia_xiaoji+hj_jinxiu_xiaoji+hj_xunzhou_xiaoji;
|
||
|
||
|
||
dataList_glf.add(df.format(glf_rentai_xiaoji));
|
||
dataList_glf.add(df.format(glf_huaxia_xiaoji));
|
||
dataList_glf.add(df.format(glf_jinxiu_xiaoji));
|
||
dataList_glf.add(df.format(glf_xunzhou_xiaoji));
|
||
dataList_glf.add(df.format(glf_heji));
|
||
dataList_glf.add("185元/人");
|
||
|
||
rowDataList.add(dataList_glf);
|
||
|
||
dataList_gz.add(df.format(gz_rentai_xiaoji));
|
||
dataList_gz.add(df.format(gz_huaxia_xiaoji));
|
||
dataList_gz.add(df.format(gz_jinxiu_xiaoji));
|
||
dataList_gz.add(df.format(gz_xunzhou_xiaoji));
|
||
dataList_gz.add(df.format(gz_heji));
|
||
dataList_gz.add("");
|
||
|
||
rowDataList.add(dataList_gz);
|
||
|
||
dataList_nzjzyhq.add(df.format(nzjzyhq_rentai_xiaoji));
|
||
dataList_nzjzyhq.add(df.format(nzjzyhq_huaxia_xiaoji));
|
||
dataList_nzjzyhq.add(df.format(nzjzyhq_jinxiu_xiaoji));
|
||
dataList_nzjzyhq.add(df.format(nzjzyhq_xunzhou_xiaoji));
|
||
dataList_nzjzyhq.add(df.format(nzjzyhq_heji));
|
||
dataList_nzjzyhq.add("");
|
||
|
||
rowDataList.add(dataList_nzjzyhq);
|
||
|
||
dataList_zxjt.add(df.format(zxjt_rentai_xiaoji));
|
||
dataList_zxjt.add(df.format(zxjt_huaxia_xiaoji));
|
||
dataList_zxjt.add(df.format(zxjt_jinxiu_xiaoji));
|
||
dataList_zxjt.add(df.format(zxjt_xunzhou_xiaoji));
|
||
dataList_zxjt.add(df.format(zxjt_heji));
|
||
dataList_zxjt.add("");
|
||
|
||
rowDataList.add(dataList_zxjt);
|
||
|
||
dataList_wx.add(df.format(wx_rentai_xiaoji));
|
||
dataList_wx.add(df.format(wx_huaxia_xiaoji));
|
||
dataList_wx.add(df.format(wx_jinxiu_xiaoji));
|
||
dataList_wx.add(df.format(wx_xunzhou_xiaoji));
|
||
dataList_wx.add(df.format(wx_heji));
|
||
dataList_wx.add("");
|
||
|
||
rowDataList.add(dataList_wx);
|
||
|
||
dataList_gjj.add(df.format(gjj_rentai_xiaoji));
|
||
dataList_gjj.add(df.format(gjj_huaxia_xiaoji));
|
||
dataList_gjj.add(df.format(gjj_jinxiu_xiaoji));
|
||
dataList_gjj.add(df.format(gjj_xunzhou_xiaoji));
|
||
dataList_gjj.add(df.format(gjj_heji));
|
||
dataList_gjj.add("");
|
||
|
||
rowDataList.add(dataList_gjj);
|
||
|
||
dataList_gzc.add(df.format(gzc_rentai_xiaoji));
|
||
dataList_gzc.add(df.format(gzc_huaxia_xiaoji));
|
||
dataList_gzc.add(df.format(gzc_jinxiu_xiaoji));
|
||
dataList_gzc.add(df.format(gzc_xunzhou_xiaoji));
|
||
dataList_gzc.add(df.format(gzc_heji));
|
||
dataList_gzc.add("");
|
||
|
||
rowDataList.add(dataList_gzc);
|
||
|
||
dataList_tjf.add(df.format(tjf_rentai_xiaoji));
|
||
dataList_tjf.add(df.format(tjf_huaxia_xiaoji));
|
||
dataList_tjf.add(df.format(tjf_jinxiu_xiaoji));
|
||
dataList_tjf.add(df.format(tjf_xunzhou_xiaoji));
|
||
dataList_tjf.add(df.format(tjf_heji));
|
||
dataList_tjf.add("");
|
||
|
||
rowDataList.add(dataList_tjf);
|
||
|
||
dataList_jrwz.add(df.format(jrwz_rentai_xiaoji));
|
||
dataList_jrwz.add(df.format(jrwz_huaxia_xiaoji));
|
||
dataList_jrwz.add(df.format(jrwz_jinxiu_xiaoji));
|
||
dataList_jrwz.add(df.format(jrwz_xunzhou_xiaoji));
|
||
dataList_jrwz.add(df.format(jrwz_heji));
|
||
dataList_jrwz.add("");
|
||
|
||
rowDataList.add(dataList_jrwz);
|
||
|
||
dataList_fzfy.add(df.format(fzfy_rentai_xiaoji));
|
||
dataList_fzfy.add(df.format(fzfy_huaxia_xiaoji));
|
||
dataList_fzfy.add(df.format(fzfy_jinxiu_xiaoji));
|
||
dataList_fzfy.add(df.format(fzfy_xunzhou_xiaoji));
|
||
dataList_fzfy.add(df.format(fzfy_heji));
|
||
dataList_fzfy.add("");
|
||
|
||
rowDataList.add(dataList_fzfy);
|
||
|
||
dataList_ywx.add(df.format(ywx_rentai_xiaoji));
|
||
dataList_ywx.add(df.format(ywx_huaxia_xiaoji));
|
||
dataList_ywx.add(df.format(ywx_jinxiu_xiaoji));
|
||
dataList_ywx.add(df.format(ywx_xunzhou_xiaoji));
|
||
dataList_ywx.add(df.format(ywx_heji));
|
||
dataList_ywx.add("");
|
||
|
||
rowDataList.add(dataList_ywx);
|
||
|
||
dataList_fsjw.add(df.format(fsjw_rentai_xiaoji));
|
||
dataList_fsjw.add(df.format(fsjw_huaxia_xiaoji));
|
||
dataList_fsjw.add(df.format(fsjw_jinxiu_xiaoji));
|
||
dataList_fsjw.add(df.format(fsjw_xunzhou_xiaoji));
|
||
dataList_fsjw.add(df.format(fsjw_heji));
|
||
dataList_fsjw.add("");
|
||
|
||
rowDataList.add(dataList_fsjw);
|
||
|
||
dataList_pxf.add(df.format(pxf_rentai_xiaoji));
|
||
dataList_pxf.add(df.format(pxf_huaxia_xiaoji));
|
||
dataList_pxf.add(df.format(pxf_jinxiu_xiaoji));
|
||
dataList_pxf.add(df.format(pxf_xunzhou_xiaoji));
|
||
dataList_pxf.add(df.format(pxf_heji));
|
||
dataList_pxf.add("");
|
||
|
||
rowDataList.add(dataList_pxf);
|
||
|
||
dataList_ghjf.add(df.format(ghjf_rentai_xiaoji));
|
||
dataList_ghjf.add(df.format(ghjf_huaxia_xiaoji));
|
||
dataList_ghjf.add(df.format(ghjf_jinxiu_xiaoji));
|
||
dataList_ghjf.add(df.format(ghjf_xunzhou_xiaoji));
|
||
dataList_ghjf.add(df.format(ghjf_heji));
|
||
dataList_ghjf.add("");
|
||
|
||
rowDataList.add(dataList_ghjf);
|
||
|
||
dataList_dthdf.add(df.format(dthdf_rentai_xiaoji));
|
||
dataList_dthdf.add(df.format(dthdf_huaxia_xiaoji));
|
||
dataList_dthdf.add(df.format(dthdf_jinxiu_xiaoji));
|
||
dataList_dthdf.add(df.format(dthdf_xunzhou_xiaoji));
|
||
dataList_dthdf.add(df.format(dthdf_heji));
|
||
dataList_dthdf.add("");
|
||
|
||
rowDataList.add(dataList_dthdf);
|
||
|
||
dataList_hdch.add(df.format(hdch_rentai_xiaoji));
|
||
dataList_hdch.add(df.format(hdch_huaxia_xiaoji));
|
||
dataList_hdch.add(df.format(hdch_jinxiu_xiaoji));
|
||
dataList_hdch.add(df.format(hdch_xunzhou_xiaoji));
|
||
dataList_hdch.add(df.format(hdch_heji));
|
||
dataList_hdch.add("");
|
||
|
||
rowDataList.add(dataList_hdch);
|
||
|
||
dataList_clf.add(df.format(clf_rentai_xiaoji));
|
||
dataList_clf.add(df.format(clf_huaxia_xiaoji));
|
||
dataList_clf.add(df.format(clf_jinxiu_xiaoji));
|
||
dataList_clf.add(df.format(clf_xunzhou_xiaoji));
|
||
dataList_clf.add(df.format(clf_heji));
|
||
dataList_clf.add("");
|
||
|
||
rowDataList.add(dataList_clf);
|
||
|
||
dataList_glcb.add(df.format(glcb_rentai_xiaoji));
|
||
dataList_glcb.add(df.format(glcb_huaxia_xiaoji));
|
||
dataList_glcb.add(df.format(glcb_jinxiu_xiaoji));
|
||
dataList_glcb.add(df.format(glcb_xunzhou_xiaoji));
|
||
dataList_glcb.add(df.format(glcb_heji));
|
||
dataList_glcb.add("");
|
||
|
||
rowDataList.add(dataList_glcb);
|
||
|
||
dataList_dksyx.add(df.format(dksyx_rentai_xiaoji));
|
||
dataList_dksyx.add(df.format(dksyx_huaxia_xiaoji));
|
||
dataList_dksyx.add(df.format(dksyx_jinxiu_xiaoji));
|
||
dataList_dksyx.add(df.format(dksyx_xunzhou_xiaoji));
|
||
dataList_dksyx.add(df.format(dksyx_heji));
|
||
dataList_dksyx.add("");
|
||
|
||
rowDataList.add(dataList_dksyx);
|
||
|
||
dataList_ycxbcj.add(df.format(ycxbcj_rentai_xiaoji));
|
||
dataList_ycxbcj.add(df.format(ycxbcj_huaxia_xiaoji));
|
||
dataList_ycxbcj.add(df.format(ycxbcj_jinxiu_xiaoji));
|
||
dataList_ycxbcj.add(df.format(ycxbcj_xunzhou_xiaoji));
|
||
dataList_ycxbcj.add(df.format(ycxbcj_heji));
|
||
dataList_ycxbcj.add("");
|
||
|
||
rowDataList.add(dataList_ycxbcj);
|
||
|
||
dataList_rzxtsjwhf.add(df.format(rzxtsjwhf_rentai_xiaoji));
|
||
dataList_rzxtsjwhf.add(df.format(rzxtsjwhf_huaxia_xiaoji));
|
||
dataList_rzxtsjwhf.add(df.format(rzxtsjwhf_jinxiu_xiaoji));
|
||
dataList_rzxtsjwhf.add(df.format(rzxtsjwhf_xunzhou_xiaoji));
|
||
dataList_rzxtsjwhf.add(df.format(rzxtsjwhf_heji));
|
||
dataList_rzxtsjwhf.add("");
|
||
|
||
rowDataList.add(dataList_rzxtsjwhf);
|
||
|
||
dataList_dksdf.add(df.format(dksdf_rentai_xiaoji));
|
||
dataList_dksdf.add(df.format(dksdf_huaxia_xiaoji));
|
||
dataList_dksdf.add(df.format(dksdf_jinxiu_xiaoji));
|
||
dataList_dksdf.add(df.format(dksdf_xunzhou_xiaoji));
|
||
dataList_dksdf.add(df.format(dksdf_heji));
|
||
dataList_dksdf.add("");
|
||
|
||
rowDataList.add(dataList_dksdf);
|
||
|
||
dataList_zbfwf.add(df.format(zbfwf_rentai_xiaoji));
|
||
dataList_zbfwf.add(df.format(zbfwf_huaxia_xiaoji));
|
||
dataList_zbfwf.add(df.format(zbfwf_jinxiu_xiaoji));
|
||
dataList_zbfwf.add(df.format(zbfwf_xunzhou_xiaoji));
|
||
dataList_zbfwf.add(df.format(zbfwf_heji));
|
||
dataList_zbfwf.add("");
|
||
|
||
rowDataList.add(dataList_zbfwf);
|
||
|
||
dataList_sd.add(df.format(sd_rentai_xiaoji));
|
||
dataList_sd.add(df.format(sd_huaxia_xiaoji));
|
||
dataList_sd.add(df.format(sd_jinxiu_xiaoji));
|
||
dataList_sd.add(df.format(sd_xunzhou_xiaoji));
|
||
dataList_sd.add(df.format(sd_heji));
|
||
dataList_sd.add("");
|
||
|
||
rowDataList.add(dataList_sd);
|
||
|
||
dataList_hj.add(df.format(hj_rentai_xiaoji));
|
||
dataList_hj.add(df.format(hj_huaxia_xiaoji));
|
||
dataList_hj.add(df.format(hj_jinxiu_xiaoji));
|
||
dataList_hj.add(df.format(hj_xunzhou_xiaoji));
|
||
dataList_hj.add(df.format(hj_heji));
|
||
dataList_hj.add("");
|
||
|
||
rowDataList.add(dataList_hj);
|
||
}
|
||
apidatas.put("data",rowDataList);
|
||
|
||
new BaseBean().writeLog("======== WorkReportServiceImpl dataMap ========== "+ apidatas);
|
||
|
||
String fileName = "aaaaaabbbbbbbb.xls";
|
||
String filePath = "D:\\WEAVER\\"+fileName;
|
||
String fileRealPath = "D:\\WEAVER\\"+fileName;
|
||
FileOutputStream fout = null;
|
||
|
||
// 创建workbook
|
||
HSSFWorkbook workbook = new HSSFWorkbook();
|
||
//单元格样式
|
||
HSSFCellStyle titleStyle = titleStyle(workbook);
|
||
HSSFCellStyle cellStyle = cellStyle(workbook);
|
||
HSSFCellStyle cellStyle1 = cellStyle(workbook);
|
||
|
||
int nums = 0;
|
||
LocalDate startDate = null;
|
||
LocalDate endDate = null;
|
||
int ks_year = 0;
|
||
if(ksrq!=null && !"".equals(ksrq) && jsrq!=null && !"".equals(jsrq)) {
|
||
nums = getBetweenMonths(ksrq+"-01",jsrq+"-01");
|
||
ks_year = Integer.parseInt(ksrq.substring(0, 4));
|
||
int ks_month = Integer.parseInt(ksrq.substring(5, 7));
|
||
|
||
int js_year = Integer.parseInt(jsrq.substring(0, 4));
|
||
int js_month = Integer.parseInt(jsrq.substring(5, 7));
|
||
|
||
// 定义起始日期和结束日期
|
||
startDate = LocalDate.of(ks_year, ks_month, 1);
|
||
endDate = LocalDate.of(js_year, js_month, 1);
|
||
}
|
||
try {
|
||
// 添加表头
|
||
HSSFSheet sheet = workbook.createSheet();
|
||
workbook.setSheetName(0, "外包费用报表");
|
||
|
||
HSSFRow row0 = sheet.createRow(0); //创建第0行 表头
|
||
row0.setHeightInPoints(30);// 设置标题行的高度
|
||
|
||
HSSFCell celll = row0.createCell(0);
|
||
celll.setCellStyle(titleStyle);
|
||
celll.setCellValue(ks_year + "年外包费用明细表");
|
||
|
||
HSSFRow row = sheet.createRow(1); //创建第1行 表头
|
||
row.setHeightInPoints(30);// 设置标题行的高度
|
||
|
||
HSSFCell cell0 = row.createCell(0);
|
||
cell0.setCellStyle(titleStyle);
|
||
cell0.setCellValue("序号");
|
||
|
||
HSSFCell cell1 = row.createCell(1);
|
||
cell1.setCellStyle(titleStyle);
|
||
cell1.setCellValue("名目");
|
||
|
||
// 循环遍历日期
|
||
LocalDate currentDate = startDate;
|
||
int num = 2;
|
||
while (!currentDate.isAfter(endDate)) { // 确保当前日期在结束日期之前或当天结束
|
||
// 格式化并打印当前日期
|
||
String formattedDate = currentDate.format(formatter);
|
||
// 将当前日期增加一个月（因为我们想要按月遍历）
|
||
currentDate = currentDate.plusMonths(1); // 注意：这将直接跳到下一个月的第一天
|
||
|
||
HSSFCell cell2 = row.createCell(num);
|
||
cell2.setCellStyle(titleStyle);
|
||
cell2.setCellValue(formattedDate);
|
||
|
||
num++;
|
||
}
|
||
|
||
HSSFCell cell3 = row.createCell(num);
|
||
cell3.setCellStyle(titleStyle);
|
||
cell3.setCellValue("小计");
|
||
|
||
HSSFCell cell4 = row.createCell(num+1);
|
||
cell4.setCellStyle(titleStyle);
|
||
cell4.setCellValue("合计");
|
||
|
||
HSSFCell cell5 = row.createCell(num+2);
|
||
cell5.setCellStyle(titleStyle);
|
||
cell5.setCellValue("备注");
|
||
|
||
HSSFRow row2 = sheet.createRow(2); //创建第1行 表头
|
||
row2.setHeightInPoints(30);// 设置标题行的高度
|
||
|
||
HSSFCell cell2_0 = row2.createCell(0);
|
||
cell2_0.setCellStyle(titleStyle);
|
||
cell2_0.setCellValue("1");
|
||
|
||
HSSFCell cell2_1 = row2.createCell(1);
|
||
cell2_1.setCellStyle(titleStyle);
|
||
cell2_1.setCellValue("外包单位");
|
||
|
||
// 循环遍历日期
|
||
LocalDate currentDate2 = startDate;
|
||
int num2 = 2;
|
||
while (!currentDate2.isAfter(endDate)) { // 确保当前日期在结束日期之前或当天结束
|
||
// 格式化并打印当前日期
|
||
String formattedDate = currentDate.format(formatter);
|
||
// 将当前日期增加一个月（因为我们想要按月遍历）
|
||
currentDate = currentDate.plusMonths(1); // 注意：这将直接跳到下一个月的第一天
|
||
|
||
HSSFCell cell2_2 = row.createCell(num2);
|
||
cell2_2.setCellStyle(titleStyle);
|
||
cell2_2.setCellValue("仁泰");
|
||
|
||
HSSFCell cell2_3 = row.createCell(num2+1);
|
||
cell2_3.setCellStyle(titleStyle);
|
||
cell2_3.setCellValue("华夏");
|
||
|
||
HSSFCell cell2_4 = row.createCell(num2+2);
|
||
cell2_4.setCellStyle(titleStyle);
|
||
cell2_4.setCellValue("锦绣");
|
||
|
||
HSSFCell cell2_5 = row.createCell(num2+3);
|
||
cell2_5.setCellStyle(titleStyle);
|
||
cell2_5.setCellValue("洵洲");
|
||
|
||
num2 = num2 + 4;
|
||
}
|
||
|
||
HSSFCell cell2_8 = row2.createCell(num2+4);
|
||
cell2_8.setCellStyle(titleStyle);
|
||
cell2_8.setCellValue("");
|
||
|
||
HSSFCell cell2_9 = row2.createCell(num2+5);
|
||
cell2_9.setCellStyle(titleStyle);
|
||
cell2_9.setCellValue("");
|
||
|
||
|
||
//表头合并单元格，new CellRangeAddress(从第几行开始, 到第几行结束, 从第几列开始, 到第几列结束);
|
||
CellRangeAddress region1 = new CellRangeAddress(0, 0, 0, 7+4*nums);
|
||
setBorderStyle(region1,sheet);
|
||
sheet.addMergedRegion(region1);
|
||
|
||
//从dao获取报表数据
|
||
new BaseBean().writeLog("======== WorkReportServiceImpl dataMap ========== "+ apidatas);
|
||
List<List<Object>> dataList = (List<List<Object>>) apidatas.get("data");
|
||
|
||
//添加数据
|
||
int totalSize = dataList.size()+1;
|
||
for(int i=2;i<totalSize;i++){
|
||
HSSFRow newRow = sheet.createRow(i);
|
||
newRow.setHeightInPoints(30);// 设置数据行的高度
|
||
|
||
//第一列序号
|
||
HSSFCell indexCell = newRow.createCell(0);
|
||
indexCell.setCellStyle(cellStyle1);
|
||
indexCell.setCellValue(i);
|
||
|
||
List<Object> rowDataList1 = dataList.get(i-2);
|
||
for (int j = 1; j <= rowDataList1.size(); j++) {
|
||
HSSFCell cell = newRow.createCell(j);
|
||
Boolean isNum = false;//data是否为数值型
|
||
Boolean isInteger=false;//data是否为整数
|
||
Boolean isPercent=false;//data是否为百分数
|
||
Object data = rowDataList1.get(j-1);
|
||
if (data != null && !"".equals(data)) {
|
||
//判断data是否为数值型
|
||
isNum = data.toString().matches("^(-?\\d+)(\\.\\d+)?$");
|
||
//判断data是否为整数（小数部分是否为0）
|
||
isInteger=data.toString().matches("^[-\\+]?[\\d]*$");
|
||
//判断data是否为百分数（是否包含“%”）
|
||
isPercent=data.toString().contains("%");
|
||
}
|
||
|
||
//如果单元格内容是数值类型，涉及到金钱（金额、本、利），则设置cell的类型为数值型，设置data的类型为数值类型
|
||
if (isNum && !isPercent) {
|
||
HSSFDataFormat dfd = workbook.createDataFormat(); // 此处设置数据格式
|
||
if (isInteger) {
|
||
cellStyle.setDataFormat(dfd.getBuiltinFormat("#,#0"));//数据格式只显示整数
|
||
}else{
|
||
cellStyle.setDataFormat(dfd.getBuiltinFormat("#,##0.00"));//保留两位小数点
|
||
}
|
||
// 设置单元格格式
|
||
cell.setCellStyle(cellStyle);
|
||
// 设置单元格内容为double类型
|
||
cell.setCellValue(Double.parseDouble(data.toString()));
|
||
} else {
|
||
cell.setCellStyle(cellStyle);
|
||
// 设置单元格内容为字符型
|
||
cell.setCellValue(data.toString());
|
||
}
|
||
}
|
||
}
|
||
|
||
fout = new FileOutputStream(filePath);
|
||
workbook.write(fout);
|
||
workbook.close();
|
||
}catch (Exception e) {
|
||
e.printStackTrace();
|
||
} finally {
|
||
try {
|
||
if(fout!=null){
|
||
fout.close();
|
||
}
|
||
|
||
} catch (IOException e) {
|
||
e.printStackTrace();
|
||
}
|
||
}
|
||
|
||
JSONObject resJson = new JSONObject();
|
||
resJson.put("file",fileRealPath);
|
||
out.println(resJson.toString());
|
||
|
||
sum++;
|
||
%>
|
||
|
||
<%!
|
||
|
||
/**
|
||
* 获取 两个日期字符串相差的 月份数
|
||
* @param startDate
|
||
* @param endDate
|
||
* @return
|
||
*/
|
||
public static int getBetweenMonths(String startDate,String endDate){
|
||
int result = 0;
|
||
// 定义日期格式
|
||
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
||
// 解析日期字符串为LocalDate对象
|
||
LocalDate date1 = LocalDate.parse(startDate, formatter);
|
||
LocalDate date2 = LocalDate.parse(endDate, formatter);
|
||
// 计算两个日期之间的月份差
|
||
long monthsBetween = ChronoUnit.MONTHS.between(date1, date2);
|
||
if(monthsBetween>0){
|
||
result = (int)monthsBetween;
|
||
}
|
||
result++;
|
||
return result;
|
||
}
|
||
|
||
/**
|
||
* 设置单元格样式
|
||
* @return
|
||
*/
|
||
public static HSSFCellStyle cellStyle(HSSFWorkbook wb){
|
||
HSSFCellStyle cellStyle = wb.createCellStyle();
|
||
cellStyle.setWrapText(true);// 设置自动换行
|
||
cellStyle.setAlignment(HorizontalAlignment.CENTER); //HSSFCellStyle.ALIGN_CENTER
|
||
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // HSSFCellStyle.VERTICAL_CENTER // 创建一个居中格式
|
||
cellStyle.setBorderBottom(BorderStyle.THIN); // HSSFCellStyle.BORDER_THIN
|
||
cellStyle.setBorderLeft(BorderStyle.THIN);
|
||
cellStyle.setBorderRight(BorderStyle.THIN);
|
||
cellStyle.setBorderTop(BorderStyle.THIN);
|
||
HSSFFont headerFont1 = (HSSFFont) wb.createFont(); // 创建字体样式
|
||
headerFont1.setFontName("宋体"); // 设置字体类型
|
||
headerFont1.setFontHeightInPoints((short) 10); // 设置字体大小
|
||
cellStyle.setFont(headerFont1); // 为标题样式设置字体样式
|
||
return cellStyle;
|
||
|
||
}
|
||
|
||
// 标题第一行样式
|
||
public static HSSFCellStyle titleStyle(HSSFWorkbook wb) {
|
||
HSSFCellStyle cellStyle = wb.createCellStyle();
|
||
cellStyle.setAlignment(HorizontalAlignment.CENTER);
|
||
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
|
||
cellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
|
||
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
|
||
cellStyle.setBorderBottom(BorderStyle.THIN); // HSSFCellStyle.BORDER_THIN
|
||
cellStyle.setBorderLeft(BorderStyle.THIN);
|
||
cellStyle.setBorderRight(BorderStyle.THIN);
|
||
cellStyle.setBorderTop(BorderStyle.THIN);
|
||
HSSFFont headerFont = (HSSFFont) wb.createFont(); // 创建字体样式
|
||
headerFont.setFontName("宋体"); // 设置字体类型
|
||
headerFont.setFontHeightInPoints((short) 12); // 设置字体大小
|
||
cellStyle.setFont(headerFont); // 为标题样式设置字体样式
|
||
return cellStyle;
|
||
}
|
||
|
||
public static void setBorderStyle(CellRangeAddress region, HSSFSheet sheet){
|
||
RegionUtil.setBorderBottom(BorderStyle.THIN,region,sheet);
|
||
RegionUtil.setBorderLeft(BorderStyle.THIN,region,sheet);
|
||
RegionUtil.setBorderRight(BorderStyle.THIN,region,sheet);
|
||
RegionUtil.setBorderTop(BorderStyle.THIN,region,sheet);
|
||
}
|
||
|
||
/**
|
||
* 获取 金额
|
||
* @param table
|
||
* @param fygzyf
|
||
* @param wbgs
|
||
* @param fygzgs
|
||
* @return
|
||
*/
|
||
public static double getSumFee(String table,String fygzyf,String wbgs,String fygzgs){
|
||
double result = 0.00;
|
||
RecordSet rs = new RecordSet();
|
||
String tableDt1 = table+"_dt1";
|
||
String where = " ";
|
||
if(fygzgs != null && !"".equals(fygzgs)){
|
||
where += " and b.fygzgs in ("+ fygzgs +") ";
|
||
}
|
||
rs.executeQuery("select sum(b.bxje)as count from "+table+" a,"+tableDt1+" b where a.id=b.mainid and a.fygzyf=? and b.wbgs=? "+ where,fygzyf,wbgs);
|
||
while(rs.next()){
|
||
result = Util.getDoubleValue(rs.getString("count"),0.00);
|
||
}
|
||
return result;
|
||
}
|
||
|
||
/**
|
||
* 获取 下拉框 的名称
|
||
* @param fieldid
|
||
* @param value
|
||
* @return
|
||
*/
|
||
public static String getSelectName(String fieldid,String value) {
|
||
String result = "";
|
||
RecordSet rs = new RecordSet();
|
||
rs.executeQuery("select selectname from workflow_selectitem where cancel=0 and fieldid = ? and selectvalue = ?", fieldid, value);
|
||
if (rs.next()) {
|
||
result = Util.null2String(rs.getString("selectname"));
|
||
}
|
||
return result;
|
||
}
|
||
|
||
/**
|
||
* 获取 字段 id
|
||
* @param billid
|
||
* @param fieldname
|
||
* @return
|
||
*/
|
||
public static String getFieldId(String billid,String fieldname){
|
||
RecordSet rs = new RecordSet();
|
||
String fieldid = "";
|
||
rs.executeQuery("select * from workflow_billfield where billid=? and viewtype=0 and fieldname=?",billid,fieldname);
|
||
if(rs.next()){
|
||
fieldid = Util.null2String(rs.getString("id"));
|
||
}
|
||
return fieldid;
|
||
}
|
||
|
||
/**
|
||
*
|
||
* 方法描述 : 对两个字符串进行金额的相减
|
||
* @param a
|
||
* @param b
|
||
* @return
|
||
* String
|
||
*/
|
||
public static String floatSubtract(String a, String b) {
|
||
a=a.equals("")?"0":a;
|
||
b=b.equals("")?"0":b;
|
||
BigDecimal bg1 = new BigDecimal(a);
|
||
BigDecimal bg2 = new BigDecimal(b);
|
||
BigDecimal bd = bg1.subtract(bg2);
|
||
return bd.toString();
|
||
}
|
||
|
||
/**
|
||
*
|
||
* 方法描述 : 对两个字符串进行金额的相乘
|
||
* @param a
|
||
* @param b
|
||
* @return
|
||
* String
|
||
*/
|
||
public static String floatMultiply(String a, String b) {
|
||
a=a.equals("")?"0":a;
|
||
b=b.equals("")?"0":b;
|
||
BigDecimal bg1 = new BigDecimal(a);
|
||
BigDecimal bg2 = new BigDecimal(b);
|
||
BigDecimal bd = bg1.multiply(bg2).setScale(4, BigDecimal.ROUND_HALF_UP);
|
||
return bd.toString();
|
||
}
|
||
|
||
%> |