1564 lines
62 KiB
Plaintext
1564 lines
62 KiB
Plaintext
<%@ page import="weaver.general.Util" %>
|
|
<%@ page import="weaver.conn.RecordSet" %>
|
|
<%@ page import="java.time.LocalDate" %>
|
|
<%@ page import="com.alibaba.fastjson.JSONArray" %>
|
|
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
|
<%@ page import="java.time.format.DateTimeFormatter" %>
|
|
<%@ page import="java.time.temporal.ChronoUnit" %>
|
|
<%@ page import="java.math.BigDecimal" %>
|
|
<%@ page import="java.text.DecimalFormat" %>
|
|
<%@ 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"));
|
|
|
|
JSONArray jsonArray = new JSONArray();
|
|
|
|
// 定义日期格式
|
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM");
|
|
|
|
DecimalFormat df = new DecimalFormat("0.00");
|
|
|
|
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 zxjj_rentai_xiaoji = 0.00;
|
|
// 专项奖金 华夏 小计
|
|
double zxjj_huaxia_xiaoji = 0.00;
|
|
// 专项奖金 锦绣 小计
|
|
double zxjj_jinxiu_xiaoji = 0.00;
|
|
// 专项奖金 洵洲 小计
|
|
double zxjj_xunzhou_xiaoji = 0.00;
|
|
// 专项奖金 仁泰 合计
|
|
double zxjj_heji = 0.00;
|
|
|
|
// 年终绩效 仁泰 小计
|
|
double nzjx_rentai_xiaoji = 0.00;
|
|
// 年终绩效 华夏 小计
|
|
double nzjx_huaxia_xiaoji = 0.00;
|
|
// 年终绩效 锦绣 小计
|
|
double nzjx_jinxiu_xiaoji = 0.00;
|
|
// 年终绩效 洵洲 小计
|
|
double nzjx_xunzhou_xiaoji = 0.00;
|
|
// 年终绩效 仁泰 合计
|
|
double nzjx_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 jbf_rentai_xiaoji = 0.00;
|
|
// 加班费 华夏 小计
|
|
double jbf_huaxia_xiaoji = 0.00;
|
|
// 加班费 锦绣 小计
|
|
double jbf_jinxiu_xiaoji = 0.00;
|
|
// 加班费 洵洲 小计
|
|
double jbf_xunzhou_xiaoji = 0.00;
|
|
// 加班费 仁泰 合计
|
|
double jbf_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 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 qtrgcb_rentai_xiaoji = 0.00;
|
|
// 其他人工成本 华夏 小计
|
|
double qtrgcb_huaxia_xiaoji = 0.00;
|
|
// 其他人工成本 锦绣 小计
|
|
double qtrgcb_jinxiu_xiaoji = 0.00;
|
|
// 其他人工成本 洵洲 小计
|
|
double qtrgcb_xunzhou_xiaoji = 0.00;
|
|
// 其他人工成本 仁泰 合计
|
|
double qtrgcb_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;
|
|
|
|
JSONObject json_glf = new JSONObject();
|
|
json_glf.put("zbmc","管理费");
|
|
json_glf.put("items","管理费");
|
|
json_glf.put("xuhao",2);
|
|
|
|
JSONObject json_gz = new JSONObject();
|
|
json_gz.put("zbmc","工资");
|
|
json_gz.put("items","工资");
|
|
json_gz.put("xuhao",3);
|
|
|
|
JSONObject json_zxjj = new JSONObject();
|
|
json_zxjj.put("zbmc","工资");
|
|
json_zxjj.put("items","专项奖金");
|
|
json_zxjj.put("xuhao",4);
|
|
|
|
JSONObject json_nzjx = new JSONObject();
|
|
json_nzjx.put("zbmc","工资");
|
|
json_nzjx.put("items","年终绩效");
|
|
json_nzjx.put("xuhao",5);
|
|
|
|
JSONObject json_zxjt = new JSONObject();
|
|
json_zxjt.put("zbmc","工资");
|
|
json_zxjt.put("items","专项津贴");
|
|
json_zxjt.put("xuhao",6);
|
|
|
|
JSONObject json_jbf = new JSONObject();
|
|
json_jbf.put("zbmc","工资");
|
|
json_jbf.put("items","加班费");
|
|
json_jbf.put("xuhao",7);
|
|
|
|
JSONObject json_wx = new JSONObject();
|
|
json_wx.put("zbmc","五险一金");
|
|
json_wx.put("items","五险");
|
|
json_wx.put("xuhao",8);
|
|
|
|
JSONObject json_gjj = new JSONObject();
|
|
json_gjj.put("zbmc","五险一金");
|
|
json_gjj.put("items","公积金");
|
|
json_gjj.put("xuhao",9);
|
|
|
|
JSONObject json_gzc = new JSONObject();
|
|
json_gzc.put("zbmc","福利费");
|
|
json_gzc.put("items","工作餐");
|
|
json_gzc.put("xuhao",10);
|
|
|
|
JSONObject json_tjf = new JSONObject();
|
|
json_tjf.put("zbmc","福利费");
|
|
json_tjf.put("items","体检费");
|
|
json_tjf.put("xuhao",11);
|
|
|
|
JSONObject json_jrwz = new JSONObject();
|
|
json_jrwz.put("zbmc","福利费");
|
|
json_jrwz.put("items","节日物资");
|
|
json_jrwz.put("xuhao",12);
|
|
|
|
JSONObject json_fzfy = new JSONObject();
|
|
json_fzfy.put("zbmc","劳务保护费");
|
|
json_fzfy.put("items","服装费用");
|
|
json_fzfy.put("xuhao",13);
|
|
|
|
JSONObject json_ywx = new JSONObject();
|
|
json_ywx.put("zbmc","劳务保护费");
|
|
json_ywx.put("items","意外险");
|
|
json_ywx.put("xuhao",14);
|
|
|
|
JSONObject json_fsjw = new JSONObject();
|
|
json_fsjw.put("zbmc","劳务保护费");
|
|
json_fsjw.put("items","防暑降温");
|
|
json_fsjw.put("xuhao",15);
|
|
|
|
JSONObject json_pxf = new JSONObject();
|
|
json_pxf.put("zbmc","培训费（含党务活动经费）");
|
|
json_pxf.put("items","培训费");
|
|
json_pxf.put("xuhao",16);
|
|
|
|
JSONObject json_ghjf = new JSONObject();
|
|
json_ghjf.put("zbmc","工会经费");
|
|
json_ghjf.put("items","工会经费");
|
|
json_ghjf.put("xuhao",17);
|
|
|
|
JSONObject json_dthdf = new JSONObject();
|
|
json_dthdf.put("zbmc","工会经费");
|
|
json_dthdf.put("items","党团活动费");
|
|
json_dthdf.put("xuhao",18);
|
|
|
|
JSONObject json_hdch = new JSONObject();
|
|
json_hdch.put("zbmc","工会经费");
|
|
json_hdch.put("items","活动策划");
|
|
json_hdch.put("xuhao",19);
|
|
|
|
JSONObject json_clf = new JSONObject();
|
|
json_clf.put("zbmc","其他人工成本");
|
|
json_clf.put("items","差旅费");
|
|
json_clf.put("xuhao",20);
|
|
|
|
JSONObject json_glcb = new JSONObject();
|
|
json_glcb.put("zbmc","其他人工成本");
|
|
json_glcb.put("items","管理成本");
|
|
json_glcb.put("xuhao",21);
|
|
|
|
JSONObject json_zbfwf = new JSONObject();
|
|
json_zbfwf.put("zbmc","其他人工成本");
|
|
json_zbfwf.put("items","招标服务费");
|
|
json_zbfwf.put("xuhao",22);
|
|
|
|
JSONObject json_qtrgcb = new JSONObject();
|
|
json_qtrgcb.put("zbmc","其他人工成本");
|
|
json_qtrgcb.put("items","其他人工成本");
|
|
json_qtrgcb.put("xuhao",23);
|
|
|
|
JSONObject json_sd = new JSONObject();
|
|
json_sd.put("zbmc","");
|
|
json_sd.put("items","税点");
|
|
json_sd.put("xuhao",24);
|
|
|
|
JSONObject json_hj = new JSONObject();
|
|
json_hj.put("zbmc","");
|
|
json_hj.put("items","合计：");
|
|
json_hj.put("xuhao",25);
|
|
|
|
// 循环遍历日期
|
|
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;
|
|
|
|
//=========== 管理费 =============
|
|
JSONObject jsonObject_glf = new JSONObject();
|
|
// 管理费 仁泰
|
|
double glf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"0","0");
|
|
jsonObject_glf.put("rentai",glf_rentai);
|
|
glf_rentai_xiaoji += glf_rentai;
|
|
|
|
// 管理费 华夏
|
|
double glf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"0","0");
|
|
jsonObject_glf.put("huaxia",glf_huaxia);
|
|
glf_huaxia_xiaoji += glf_huaxia;
|
|
|
|
// 管理费 锦绣
|
|
double glf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"0","0");
|
|
jsonObject_glf.put("jinxiu",glf_jinxiu);
|
|
glf_jinxiu_xiaoji += glf_jinxiu;
|
|
|
|
// 管理费 洵洲
|
|
double glf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"0","0");
|
|
jsonObject_glf.put("xunzhou",glf_xunzhou);
|
|
glf_xunzhou_xiaoji += glf_xunzhou;
|
|
|
|
json_glf.put(formattedDate,jsonObject_glf);
|
|
|
|
//=========== 工资 =============
|
|
JSONObject jsonObject_gz = new JSONObject();
|
|
// 工资 仁泰
|
|
double gz_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"1","1");
|
|
jsonObject_gz.put("rentai",gz_rentai);
|
|
gz_rentai_xiaoji += gz_rentai;
|
|
|
|
// 工资 华夏
|
|
double gz_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"1","1");
|
|
jsonObject_gz.put("huaxia",gz_huaxia);
|
|
gz_huaxia_xiaoji += gz_huaxia;
|
|
|
|
// 工资 锦绣
|
|
double gz_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"1","1");
|
|
jsonObject_gz.put("jinxiu",gz_jinxiu);
|
|
gz_jinxiu_xiaoji += gz_jinxiu;
|
|
|
|
// 工资 洵洲
|
|
double gz_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"1","1");
|
|
jsonObject_gz.put("xunzhou",gz_xunzhou);
|
|
gz_xunzhou_xiaoji += gz_xunzhou;
|
|
|
|
json_gz.put(formattedDate,jsonObject_gz);
|
|
|
|
//=========== 专项奖金 ================
|
|
JSONObject jsonObject_zxjj = new JSONObject();
|
|
// 专项奖金 仁泰
|
|
double zxjj_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"1","2");
|
|
jsonObject_zxjj.put("rentai",zxjj_rentai);
|
|
zxjj_rentai_xiaoji += zxjj_rentai;
|
|
|
|
// 专项奖金 华夏
|
|
double zxjj_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"1","2");
|
|
jsonObject_zxjj.put("huaxia",zxjj_huaxia);
|
|
zxjj_huaxia_xiaoji += zxjj_huaxia;
|
|
|
|
// 专项奖金 锦绣
|
|
double zxjj_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"1","2");
|
|
jsonObject_zxjj.put("jinxiu",zxjj_jinxiu);
|
|
zxjj_jinxiu_xiaoji += zxjj_jinxiu;
|
|
|
|
// 专项奖金 洵洲
|
|
double zxjj_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"1","2");
|
|
jsonObject_zxjj.put("xunzhou",zxjj_xunzhou);
|
|
zxjj_xunzhou_xiaoji += zxjj_xunzhou;
|
|
|
|
json_zxjj.put(formattedDate,jsonObject_zxjj);
|
|
|
|
//=========== 年终绩效 ================
|
|
JSONObject jsonObject_nzjx = new JSONObject();
|
|
// 年终绩效 仁泰
|
|
double nzjx_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"1","23");
|
|
jsonObject_nzjx.put("rentai",nzjx_rentai);
|
|
nzjx_rentai_xiaoji += nzjx_rentai;
|
|
|
|
// 年终绩效 华夏
|
|
double nzjx_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"1","23");
|
|
jsonObject_nzjx.put("huaxia",nzjx_huaxia);
|
|
nzjx_huaxia_xiaoji += nzjx_huaxia;
|
|
|
|
// 年终绩效 锦绣
|
|
double nzjx_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"1","23");
|
|
jsonObject_nzjx.put("jinxiu",nzjx_jinxiu);
|
|
nzjx_jinxiu_xiaoji += nzjx_jinxiu;
|
|
|
|
// 年终绩效 洵洲
|
|
double nzjx_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"1","23");
|
|
jsonObject_nzjx.put("xunzhou",nzjx_xunzhou);
|
|
nzjx_xunzhou_xiaoji += nzjx_xunzhou;
|
|
|
|
json_nzjx.put(formattedDate,jsonObject_nzjx);
|
|
|
|
//=========== 专项津贴 =============
|
|
JSONObject jsonObject_zxjt = new JSONObject();
|
|
// 专项津贴 仁泰
|
|
double zxjt_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"1","3");
|
|
jsonObject_zxjt.put("rentai",zxjt_rentai);
|
|
zxjt_rentai_xiaoji += zxjt_rentai;
|
|
|
|
// 专项津贴 华夏
|
|
double zxjt_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"1","3");
|
|
jsonObject_zxjt.put("huaxia",zxjt_huaxia);
|
|
zxjt_huaxia_xiaoji += zxjt_huaxia;
|
|
|
|
// 专项津贴 锦绣
|
|
double zxjt_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"1","3");
|
|
jsonObject_zxjt.put("jinxiu",zxjt_jinxiu);
|
|
zxjt_jinxiu_xiaoji += zxjt_jinxiu;
|
|
|
|
// 专项津贴 洵洲
|
|
double zxjt_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"1","3");
|
|
jsonObject_zxjt.put("xunzhou",zxjt_xunzhou);
|
|
zxjt_xunzhou_xiaoji += zxjt_xunzhou;
|
|
|
|
json_zxjt.put(formattedDate,jsonObject_zxjt);
|
|
|
|
//=========== 加班费 =============
|
|
JSONObject jsonObject_jbf = new JSONObject();
|
|
// 加班费 仁泰
|
|
double jbf_rentai = getOvertimePay("uf_gzhqmxb",formattedDate,"1",gsgs);
|
|
jsonObject_jbf.put("rentai",jbf_rentai);
|
|
|
|
// 加班费 华夏
|
|
double jbf_huaxia = getOvertimePay("uf_gzhqmxb",formattedDate,"0",gsgs);
|
|
jsonObject_jbf.put("huaxia",jbf_huaxia);
|
|
|
|
// 加班费 锦绣
|
|
double jbf_jinxiu = getOvertimePay("uf_gzhqmxb",formattedDate,"5",gsgs);
|
|
jsonObject_jbf.put("jinxiu",jbf_jinxiu);
|
|
|
|
// 加班费 洵洲
|
|
double jbf_xunzhou = getOvertimePay("uf_gzhqmxb",formattedDate,"7",gsgs);
|
|
jsonObject_jbf.put("xunzhou",jbf_xunzhou);
|
|
|
|
json_jbf.put(formattedDate,jsonObject_jbf);
|
|
|
|
//=========== 五险 =============
|
|
JSONObject jsonObject_wx = new JSONObject();
|
|
// 五险 仁泰
|
|
double wx_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"2","4");
|
|
jsonObject_wx.put("rentai",wx_rentai);
|
|
wx_rentai_xiaoji += wx_rentai;
|
|
|
|
// 五险 华夏
|
|
double wx_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"2","4");
|
|
jsonObject_wx.put("huaxia",wx_huaxia);
|
|
wx_huaxia_xiaoji += wx_huaxia;
|
|
|
|
// 五险 锦绣
|
|
double wx_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"2","4");
|
|
jsonObject_wx.put("jinxiu",wx_jinxiu);
|
|
wx_jinxiu_xiaoji += wx_jinxiu;
|
|
|
|
// 五险 洵洲
|
|
double wx_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"2","4");
|
|
jsonObject_wx.put("xunzhou",wx_xunzhou);
|
|
wx_xunzhou_xiaoji += wx_xunzhou;
|
|
|
|
json_wx.put(formattedDate,jsonObject_wx);
|
|
|
|
//=========== 公积金 =============
|
|
JSONObject jsonObject_gjj = new JSONObject();
|
|
// 公积金 仁泰
|
|
double gjj_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"2","5");
|
|
jsonObject_gjj.put("rentai",gjj_rentai);
|
|
gjj_rentai_xiaoji += gjj_rentai;
|
|
|
|
// 公积金 华夏
|
|
double gjj_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"2","5");
|
|
jsonObject_gjj.put("huaxia",gjj_huaxia);
|
|
gjj_huaxia_xiaoji += gjj_huaxia;
|
|
|
|
// 公积金 锦绣
|
|
double gjj_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"2","5");
|
|
jsonObject_gjj.put("jinxiu",gjj_jinxiu);
|
|
gjj_jinxiu_xiaoji += gjj_jinxiu;
|
|
|
|
// 公积金 洵洲
|
|
double gjj_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"2","5");
|
|
jsonObject_gjj.put("xunzhou",gjj_xunzhou);
|
|
gjj_xunzhou_xiaoji += gjj_xunzhou;
|
|
|
|
json_gjj.put(formattedDate,jsonObject_gjj);
|
|
|
|
//=========== 工作餐 =============
|
|
JSONObject jsonObject_gzc = new JSONObject();
|
|
// 工作餐 仁泰
|
|
double gzc_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"3","6");
|
|
jsonObject_gzc.put("rentai",gzc_rentai);
|
|
gzc_rentai_xiaoji += gzc_rentai;
|
|
|
|
// 工作餐 华夏
|
|
double gzc_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"3","6");
|
|
jsonObject_gzc.put("huaxia",gzc_huaxia);
|
|
gzc_huaxia_xiaoji += gzc_huaxia;
|
|
|
|
// 工作餐 锦绣
|
|
double gzc_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"3","6");
|
|
jsonObject_gzc.put("jinxiu",gzc_jinxiu);
|
|
gzc_jinxiu_xiaoji += gzc_jinxiu;
|
|
|
|
// 工作餐 洵洲
|
|
double gzc_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"3","6");
|
|
jsonObject_gzc.put("xunzhou",gzc_xunzhou);
|
|
gzc_xunzhou_xiaoji += gzc_xunzhou;
|
|
|
|
json_gzc.put(formattedDate,jsonObject_gzc);
|
|
|
|
//=========== 体检费 =============
|
|
JSONObject jsonObject_tjf = new JSONObject();
|
|
// 体检费 仁泰
|
|
double tjf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"3","7");
|
|
jsonObject_tjf.put("rentai",tjf_rentai);
|
|
tjf_rentai_xiaoji += tjf_rentai;
|
|
|
|
// 体检费 华夏
|
|
double tjf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"3","7");
|
|
jsonObject_tjf.put("huaxia",tjf_huaxia);
|
|
tjf_huaxia_xiaoji += tjf_huaxia;
|
|
|
|
// 体检费 锦绣
|
|
double tjf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"3","7");
|
|
jsonObject_tjf.put("jinxiu",tjf_jinxiu);
|
|
tjf_jinxiu_xiaoji += tjf_jinxiu;
|
|
|
|
// 体检费 洵洲
|
|
double tjf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"3","7");
|
|
jsonObject_tjf.put("xunzhou",tjf_xunzhou);
|
|
tjf_xunzhou_xiaoji += tjf_xunzhou;
|
|
|
|
json_tjf.put(formattedDate,jsonObject_tjf);
|
|
|
|
//=========== 节日物资 =============
|
|
JSONObject jsonObject_jrwz = new JSONObject();
|
|
// 节日物资 仁泰
|
|
double jrwz_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"3","8");
|
|
jsonObject_jrwz.put("rentai",jrwz_rentai);
|
|
jrwz_rentai_xiaoji += jrwz_rentai;
|
|
|
|
// 节日物资 华夏
|
|
double jrwz_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"3","8");
|
|
jsonObject_jrwz.put("huaxia",jrwz_huaxia);
|
|
jrwz_huaxia_xiaoji += jrwz_huaxia;
|
|
|
|
// 节日物资 锦绣
|
|
double jrwz_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"3","8");
|
|
jsonObject_jrwz.put("jinxiu",jrwz_jinxiu);
|
|
jrwz_jinxiu_xiaoji += jrwz_jinxiu;
|
|
|
|
// 节日物资 洵洲
|
|
double jrwz_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"3","8");
|
|
jsonObject_jrwz.put("xunzhou",jrwz_xunzhou);
|
|
jrwz_xunzhou_xiaoji += jrwz_xunzhou;
|
|
|
|
json_jrwz.put(formattedDate,jsonObject_jrwz);
|
|
|
|
//=========== 服装费用 =============
|
|
JSONObject jsonObject_fzfy = new JSONObject();
|
|
// 服装费用 仁泰
|
|
double fzfy_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"4","9");
|
|
jsonObject_fzfy.put("rentai",fzfy_rentai);
|
|
fzfy_rentai_xiaoji += fzfy_rentai;
|
|
|
|
// 服装费用 华夏
|
|
double fzfy_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"4","9");
|
|
jsonObject_fzfy.put("huaxia",fzfy_huaxia);
|
|
fzfy_huaxia_xiaoji += fzfy_huaxia;
|
|
|
|
// 服装费用 锦绣
|
|
double fzfy_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"4","9");
|
|
jsonObject_fzfy.put("jinxiu",fzfy_jinxiu);
|
|
fzfy_jinxiu_xiaoji += fzfy_jinxiu;
|
|
|
|
// 服装费用 洵洲
|
|
double fzfy_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"4","9");
|
|
jsonObject_fzfy.put("xunzhou",fzfy_xunzhou);
|
|
fzfy_xunzhou_xiaoji += fzfy_xunzhou;
|
|
|
|
json_fzfy.put(formattedDate,jsonObject_fzfy);
|
|
|
|
//=========== 意外险 =============
|
|
JSONObject jsonObject_ywx = new JSONObject();
|
|
// 意外险 仁泰
|
|
double ywx_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"4","10");
|
|
jsonObject_ywx.put("rentai",ywx_rentai);
|
|
ywx_rentai_xiaoji += ywx_rentai;
|
|
|
|
// 意外险 华夏
|
|
double ywx_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"4","10");
|
|
jsonObject_ywx.put("huaxia",ywx_huaxia);
|
|
ywx_huaxia_xiaoji += ywx_huaxia;
|
|
|
|
// 意外险 锦绣
|
|
double ywx_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"4","10");
|
|
jsonObject_ywx.put("jinxiu",ywx_jinxiu);
|
|
ywx_jinxiu_xiaoji += ywx_jinxiu;
|
|
|
|
// 意外险 洵洲
|
|
double ywx_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"4","10");
|
|
jsonObject_ywx.put("xunzhou",ywx_xunzhou);
|
|
ywx_xunzhou_xiaoji += ywx_xunzhou;
|
|
|
|
json_ywx.put(formattedDate,jsonObject_ywx);
|
|
|
|
//=========== 防暑降温 =============
|
|
JSONObject jsonObject_fsjw = new JSONObject();
|
|
// 防暑降温 仁泰
|
|
double fsjw_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"4","11");
|
|
jsonObject_fsjw.put("rentai",fsjw_rentai);
|
|
fsjw_rentai_xiaoji += fsjw_rentai;
|
|
|
|
// 防暑降温 华夏
|
|
double fsjw_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"4","11");
|
|
jsonObject_fsjw.put("huaxia",fsjw_huaxia);
|
|
fsjw_huaxia_xiaoji += fsjw_huaxia;
|
|
|
|
// 防暑降温 锦绣
|
|
double fsjw_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"4","11");
|
|
jsonObject_fsjw.put("jinxiu",fsjw_jinxiu);
|
|
fsjw_jinxiu_xiaoji += fsjw_jinxiu;
|
|
|
|
// 防暑降温 洵洲
|
|
double fsjw_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"4","11");
|
|
jsonObject_fsjw.put("xunzhou",fsjw_xunzhou);
|
|
fsjw_xunzhou_xiaoji += fsjw_xunzhou;
|
|
|
|
json_fsjw.put(formattedDate,jsonObject_fsjw);
|
|
|
|
//=========== 培训费 =============
|
|
JSONObject jsonObject_pxf = new JSONObject();
|
|
// 培训费 仁泰
|
|
double pxf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"5","12");
|
|
jsonObject_pxf.put("rentai",pxf_rentai);
|
|
pxf_rentai_xiaoji += pxf_rentai;
|
|
|
|
// 培训费 华夏
|
|
double pxf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"5","12");
|
|
jsonObject_pxf.put("huaxia",pxf_huaxia);
|
|
pxf_huaxia_xiaoji += pxf_huaxia;
|
|
|
|
// 培训费 锦绣
|
|
double pxf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"5","12");
|
|
jsonObject_pxf.put("jinxiu",pxf_jinxiu);
|
|
pxf_jinxiu_xiaoji += pxf_jinxiu;
|
|
|
|
// 培训费 洵洲
|
|
double pxf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"5","12");
|
|
jsonObject_pxf.put("xunzhou",pxf_xunzhou);
|
|
pxf_xunzhou_xiaoji += pxf_xunzhou;
|
|
|
|
json_pxf.put(formattedDate,jsonObject_pxf);
|
|
|
|
//=========== 工会经费 =============
|
|
JSONObject jsonObject_ghjf = new JSONObject();
|
|
// 工会经费 仁泰
|
|
double ghjf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"6","13");
|
|
jsonObject_ghjf.put("rentai",ghjf_rentai);
|
|
ghjf_rentai_xiaoji += ghjf_rentai;
|
|
|
|
// 工会经费 华夏
|
|
double ghjf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"6","13");
|
|
jsonObject_ghjf.put("huaxia",ghjf_huaxia);
|
|
ghjf_huaxia_xiaoji += ghjf_huaxia;
|
|
|
|
// 工会经费 锦绣
|
|
double ghjf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"6","13");
|
|
jsonObject_ghjf.put("jinxiu",ghjf_jinxiu);
|
|
ghjf_jinxiu_xiaoji += ghjf_jinxiu;
|
|
|
|
// 工会经费 洵洲
|
|
double ghjf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"6","13");
|
|
jsonObject_ghjf.put("xunzhou",ghjf_xunzhou);
|
|
ghjf_xunzhou_xiaoji += ghjf_xunzhou;
|
|
|
|
json_ghjf.put(formattedDate,jsonObject_ghjf);
|
|
|
|
//=========== 党团活动费 =============
|
|
JSONObject jsonObject_dthdf = new JSONObject();
|
|
// 党团活动费 仁泰
|
|
double dthdf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"6","14");
|
|
jsonObject_dthdf.put("rentai",dthdf_rentai);
|
|
dthdf_rentai_xiaoji += dthdf_rentai;
|
|
|
|
// 党团活动费 华夏
|
|
double dthdf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"6","14");
|
|
jsonObject_dthdf.put("huaxia",dthdf_huaxia);
|
|
dthdf_huaxia_xiaoji += dthdf_huaxia;
|
|
|
|
// 党团活动费 锦绣
|
|
double dthdf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"6","14");
|
|
jsonObject_dthdf.put("jinxiu",dthdf_jinxiu);
|
|
dthdf_jinxiu_xiaoji += dthdf_jinxiu;
|
|
|
|
// 党团活动费 洵洲
|
|
double dthdf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"6","14");
|
|
jsonObject_dthdf.put("xunzhou",dthdf_xunzhou);
|
|
dthdf_xunzhou_xiaoji += dthdf_xunzhou;
|
|
|
|
json_dthdf.put(formattedDate,jsonObject_dthdf);
|
|
|
|
//=========== 活动策划 =============
|
|
JSONObject jsonObject_hdch = new JSONObject();
|
|
// 活动策划 仁泰
|
|
double hdch_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"6","15");
|
|
jsonObject_hdch.put("rentai",hdch_rentai);
|
|
hdch_rentai_xiaoji += hdch_rentai;
|
|
|
|
// 活动策划 华夏
|
|
double hdch_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"6","15");
|
|
jsonObject_hdch.put("huaxia",hdch_huaxia);
|
|
hdch_huaxia_xiaoji += hdch_huaxia;
|
|
|
|
// 活动策划 锦绣
|
|
double hdch_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"6","15");
|
|
jsonObject_hdch.put("jinxiu",hdch_jinxiu);
|
|
hdch_jinxiu_xiaoji += hdch_jinxiu;
|
|
|
|
// 活动策划 洵洲
|
|
double hdch_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"6","15");
|
|
jsonObject_hdch.put("xunzhou",hdch_xunzhou);
|
|
hdch_xunzhou_xiaoji += hdch_xunzhou;
|
|
|
|
json_hdch.put(formattedDate,jsonObject_hdch);
|
|
|
|
//=========== 差旅费 =============
|
|
JSONObject jsonObject_clf = new JSONObject();
|
|
// 差旅费 仁泰
|
|
double clf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"7","16");
|
|
jsonObject_clf.put("rentai",clf_rentai);
|
|
clf_rentai_xiaoji += clf_rentai;
|
|
|
|
// 差旅费 华夏
|
|
double clf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"7","16");
|
|
jsonObject_clf.put("huaxia",clf_huaxia);
|
|
clf_huaxia_xiaoji += clf_huaxia;
|
|
|
|
// 差旅费 锦绣
|
|
double clf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"7","16");
|
|
jsonObject_clf.put("jinxiu",clf_jinxiu);
|
|
clf_jinxiu_xiaoji += clf_jinxiu;
|
|
|
|
// 差旅费 洵洲
|
|
double clf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"7","16");
|
|
jsonObject_clf.put("xunzhou",clf_xunzhou);
|
|
clf_xunzhou_xiaoji += clf_xunzhou;
|
|
|
|
json_clf.put(formattedDate,jsonObject_clf);
|
|
|
|
//=========== 管理成本 =============
|
|
JSONObject jsonObject_glcb = new JSONObject();
|
|
// 管理成本 仁泰
|
|
double glcb_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"7","17");
|
|
jsonObject_glcb.put("rentai",glcb_rentai);
|
|
glcb_rentai_xiaoji += glcb_rentai;
|
|
|
|
// 管理成本 华夏
|
|
double glcb_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"7","17");
|
|
jsonObject_glcb.put("huaxia",glcb_huaxia);
|
|
glcb_huaxia_xiaoji += glcb_huaxia;
|
|
|
|
// 管理成本 锦绣
|
|
double glcb_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"7","17");
|
|
jsonObject_glcb.put("jinxiu",glcb_jinxiu);
|
|
glcb_jinxiu_xiaoji += glcb_jinxiu;
|
|
|
|
// 管理成本 洵洲
|
|
double glcb_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"7","17");
|
|
jsonObject_glcb.put("xunzhou",glcb_xunzhou);
|
|
glcb_xunzhou_xiaoji += glcb_xunzhou;
|
|
|
|
json_glcb.put(formattedDate,jsonObject_glcb);
|
|
|
|
//=========== 招标服务费 =============
|
|
JSONObject jsonObject_zbfwf = new JSONObject();
|
|
// 招标服务费 仁泰
|
|
double zbfwf_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"7","24");
|
|
jsonObject_zbfwf.put("rentai",zbfwf_rentai);
|
|
zbfwf_rentai_xiaoji += zbfwf_rentai;
|
|
|
|
// 招标服务费 华夏
|
|
double zbfwf_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"7","24");
|
|
jsonObject_zbfwf.put("huaxia",zbfwf_huaxia);
|
|
zbfwf_huaxia_xiaoji += zbfwf_huaxia;
|
|
|
|
// 招标服务费 锦绣
|
|
double zbfwf_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"7","24");
|
|
jsonObject_zbfwf.put("jinxiu",zbfwf_jinxiu);
|
|
zbfwf_jinxiu_xiaoji += zbfwf_jinxiu;
|
|
|
|
// 招标服务费 洵洲
|
|
double zbfwf_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"7","24");
|
|
jsonObject_zbfwf.put("xunzhou",zbfwf_xunzhou);
|
|
zbfwf_xunzhou_xiaoji += zbfwf_xunzhou;
|
|
|
|
json_zbfwf.put(formattedDate,jsonObject_zbfwf);
|
|
|
|
//=========== 其他人工成本 =============
|
|
JSONObject jsonObject_qtrgcb = new JSONObject();
|
|
// 其他人工成本 仁泰
|
|
double qtrgcb_rentai = getSumFee("uf_wbfytz",formattedDate,"1",gsgs,"7","22");
|
|
jsonObject_qtrgcb.put("rentai",qtrgcb_rentai);
|
|
qtrgcb_rentai_xiaoji += qtrgcb_rentai;
|
|
|
|
// 其他人工成本 华夏
|
|
double qtrgcb_huaxia = getSumFee("uf_wbfytz",formattedDate,"0",gsgs,"7","22");
|
|
jsonObject_qtrgcb.put("huaxia",qtrgcb_huaxia);
|
|
qtrgcb_huaxia_xiaoji += qtrgcb_huaxia;
|
|
|
|
// 其他人工成本 锦绣
|
|
double qtrgcb_jinxiu = getSumFee("uf_wbfytz",formattedDate,"5",gsgs,"7","22");
|
|
jsonObject_qtrgcb.put("jinxiu",qtrgcb_jinxiu);
|
|
qtrgcb_jinxiu_xiaoji += qtrgcb_jinxiu;
|
|
|
|
// 其他人工成本 洵洲
|
|
double qtrgcb_xunzhou = getSumFee("uf_wbfytz",formattedDate,"7",gsgs,"7","22");
|
|
jsonObject_qtrgcb.put("xunzhou",qtrgcb_xunzhou);
|
|
qtrgcb_xunzhou_xiaoji += qtrgcb_xunzhou;
|
|
|
|
json_qtrgcb.put(formattedDate,jsonObject_qtrgcb);
|
|
|
|
rentai_hj = glf_rentai+gz_rentai+zxjj_rentai+nzjx_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+zbfwf_rentai+qtrgcb_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+zxjj_huaxia+nzjx_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+zbfwf_huaxia+qtrgcb_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+zxjj_jinxiu+nzjx_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+zbfwf_jinxiu+qtrgcb_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+zxjj_xunzhou+nzjx_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+zbfwf_jinxiu+qtrgcb_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;
|
|
|
|
//=========== 税点 =============
|
|
JSONObject jsonObject_sd = new JSONObject();
|
|
// 税点 仁泰
|
|
jsonObject_sd.put("rentai",df.format(sd_rentai));
|
|
sd_rentai_xiaoji += sd_rentai;
|
|
|
|
// 税点 华夏
|
|
jsonObject_sd.put("huaxia",df.format(sd_huaxia));
|
|
sd_huaxia_xiaoji += sd_huaxia;
|
|
|
|
// 税点 锦绣
|
|
jsonObject_sd.put("jinxiu",df.format(sd_jinxiu));
|
|
sd_jinxiu_xiaoji += sd_jinxiu;
|
|
|
|
// 税点 洵洲
|
|
jsonObject_sd.put("xunzhou",df.format(sd_xunzhou));
|
|
sd_xunzhou_xiaoji += sd_xunzhou;
|
|
|
|
json_sd.put(formattedDate,jsonObject_sd);
|
|
|
|
//=========== 合计 =============
|
|
JSONObject jsonObject_hj = new JSONObject();
|
|
// 合计 仁泰
|
|
jsonObject_hj.put("rentai",df.format(hj_rentai));
|
|
hj_rentai_xiaoji += hj_rentai;
|
|
|
|
// 合计 华夏
|
|
jsonObject_hj.put("huaxia",df.format(hj_huaxia));
|
|
hj_huaxia_xiaoji += hj_huaxia;
|
|
|
|
// 合计 锦绣
|
|
jsonObject_hj.put("jinxiu",df.format(hj_jinxiu));
|
|
hj_jinxiu_xiaoji += hj_jinxiu;
|
|
|
|
// 合计 洵洲
|
|
jsonObject_hj.put("xunzhou",df.format(hj_xunzhou));
|
|
hj_xunzhou_xiaoji += hj_xunzhou;
|
|
|
|
json_hj.put(formattedDate,jsonObject_hj);
|
|
}
|
|
|
|
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;
|
|
|
|
zxjj_heji = zxjj_rentai_xiaoji+zxjj_huaxia_xiaoji+zxjj_jinxiu_xiaoji+zxjj_xunzhou_xiaoji;
|
|
|
|
nzjx_heji = nzjx_rentai_xiaoji+nzjx_huaxia_xiaoji+nzjx_jinxiu_xiaoji+nzjx_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;
|
|
|
|
zbfwf_heji = zbfwf_rentai_xiaoji+zbfwf_huaxia_xiaoji+zbfwf_jinxiu_xiaoji+zbfwf_xunzhou_xiaoji;
|
|
|
|
qtrgcb_heji = qtrgcb_rentai_xiaoji+qtrgcb_huaxia_xiaoji+qtrgcb_jinxiu_xiaoji+qtrgcb_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;
|
|
|
|
JSONObject jsonObject_glf = new JSONObject();
|
|
jsonObject_glf.put("rentai_subtotal",df.format(glf_rentai_xiaoji));
|
|
jsonObject_glf.put("huaxia_subtotal",df.format(glf_huaxia_xiaoji));
|
|
jsonObject_glf.put("jinxiu_subtotal",df.format(glf_jinxiu_xiaoji));
|
|
jsonObject_glf.put("xunzhou_subtotal",df.format(glf_xunzhou_xiaoji));
|
|
|
|
json_glf.put("subtotal",jsonObject_glf);
|
|
json_glf.put("heji",df.format(glf_heji));
|
|
json_glf.put("notes","185元/人");
|
|
|
|
jsonArray.add(json_glf);
|
|
|
|
JSONObject jsonObject_gz = new JSONObject();
|
|
jsonObject_gz.put("rentai_subtotal",df.format(gz_rentai_xiaoji));
|
|
jsonObject_gz.put("huaxia_subtotal",df.format(gz_huaxia_xiaoji));
|
|
jsonObject_gz.put("jinxiu_subtotal",df.format(gz_jinxiu_xiaoji));
|
|
jsonObject_gz.put("xunzhou_subtotal",df.format(gz_xunzhou_xiaoji));
|
|
|
|
json_gz.put("subtotal",jsonObject_gz);
|
|
json_gz.put("heji",df.format(gz_heji));
|
|
json_gz.put("notes","");
|
|
|
|
jsonArray.add(json_gz);
|
|
|
|
JSONObject jsonObject_zxjj = new JSONObject();
|
|
jsonObject_zxjj.put("rentai_subtotal",df.format(zxjj_rentai_xiaoji));
|
|
jsonObject_zxjj.put("huaxia_subtotal",df.format(zxjj_huaxia_xiaoji));
|
|
jsonObject_zxjj.put("jinxiu_subtotal",df.format(zxjj_jinxiu_xiaoji));
|
|
jsonObject_zxjj.put("xunzhou_subtotal",df.format(zxjj_xunzhou_xiaoji));
|
|
|
|
json_zxjj.put("subtotal",jsonObject_zxjj);
|
|
json_zxjj.put("heji",df.format(zxjj_heji));
|
|
json_zxjj.put("notes","");
|
|
|
|
jsonArray.add(json_zxjj);
|
|
|
|
JSONObject jsonObject_nzjx = new JSONObject();
|
|
jsonObject_nzjx.put("rentai_subtotal",df.format(nzjx_rentai_xiaoji));
|
|
jsonObject_nzjx.put("huaxia_subtotal",df.format(nzjx_huaxia_xiaoji));
|
|
jsonObject_nzjx.put("jinxiu_subtotal",df.format(nzjx_jinxiu_xiaoji));
|
|
jsonObject_nzjx.put("xunzhou_subtotal",df.format(nzjx_xunzhou_xiaoji));
|
|
|
|
json_nzjx.put("subtotal",jsonObject_nzjx);
|
|
json_nzjx.put("heji",df.format(nzjx_heji));
|
|
json_nzjx.put("notes","");
|
|
|
|
jsonArray.add(json_nzjx);
|
|
|
|
JSONObject jsonObject_zxjt = new JSONObject();
|
|
jsonObject_zxjt.put("rentai_subtotal",df.format(zxjt_rentai_xiaoji));
|
|
jsonObject_zxjt.put("huaxia_subtotal",df.format(zxjt_huaxia_xiaoji));
|
|
jsonObject_zxjt.put("jinxiu_subtotal",df.format(zxjt_jinxiu_xiaoji));
|
|
jsonObject_zxjt.put("xunzhou_subtotal",df.format(zxjt_xunzhou_xiaoji));
|
|
|
|
json_zxjt.put("subtotal",jsonObject_zxjt);
|
|
json_zxjt.put("heji",df.format(zxjt_heji));
|
|
json_zxjt.put("notes","");
|
|
|
|
jsonArray.add(json_zxjt);
|
|
|
|
JSONObject jsonObject_jbf = new JSONObject();
|
|
jsonObject_jbf.put("rentai_subtotal",df.format(jbf_rentai_xiaoji));
|
|
jsonObject_jbf.put("huaxia_subtotal",df.format(jbf_huaxia_xiaoji));
|
|
jsonObject_jbf.put("jinxiu_subtotal",df.format(jbf_jinxiu_xiaoji));
|
|
jsonObject_jbf.put("xunzhou_subtotal",df.format(jbf_xunzhou_xiaoji));
|
|
|
|
json_jbf.put("subtotal",jsonObject_zxjt);
|
|
json_jbf.put("heji",df.format(zxjt_heji));
|
|
json_jbf.put("notes","");
|
|
|
|
jsonArray.add(json_jbf);
|
|
|
|
JSONObject jsonObject_wx = new JSONObject();
|
|
jsonObject_wx.put("rentai_subtotal",df.format(wx_rentai_xiaoji));
|
|
jsonObject_wx.put("huaxia_subtotal",df.format(wx_huaxia_xiaoji));
|
|
jsonObject_wx.put("jinxiu_subtotal",df.format(wx_jinxiu_xiaoji));
|
|
jsonObject_wx.put("xunzhou_subtotal",df.format(wx_xunzhou_xiaoji));
|
|
|
|
json_wx.put("subtotal",jsonObject_wx);
|
|
json_wx.put("heji",df.format(wx_heji));
|
|
json_wx.put("notes","");
|
|
|
|
jsonArray.add(json_wx);
|
|
|
|
JSONObject jsonObject_gjj = new JSONObject();
|
|
jsonObject_gjj.put("rentai_subtotal",df.format(gjj_rentai_xiaoji));
|
|
jsonObject_gjj.put("huaxia_subtotal",df.format(gjj_huaxia_xiaoji));
|
|
jsonObject_gjj.put("jinxiu_subtotal",df.format(gjj_jinxiu_xiaoji));
|
|
jsonObject_gjj.put("xunzhou_subtotal",df.format(gjj_xunzhou_xiaoji));
|
|
|
|
json_gjj.put("subtotal",jsonObject_gjj);
|
|
json_gjj.put("heji",df.format(gjj_heji));
|
|
json_gjj.put("notes","");
|
|
|
|
jsonArray.add(json_gjj);
|
|
|
|
JSONObject jsonObject_gzc = new JSONObject();
|
|
jsonObject_gzc.put("rentai_subtotal",df.format(gzc_rentai_xiaoji));
|
|
jsonObject_gzc.put("huaxia_subtotal",df.format(gzc_huaxia_xiaoji));
|
|
jsonObject_gzc.put("jinxiu_subtotal",df.format(gzc_jinxiu_xiaoji));
|
|
jsonObject_gzc.put("xunzhou_subtotal",df.format(gzc_xunzhou_xiaoji));
|
|
|
|
json_gzc.put("subtotal",jsonObject_gzc);
|
|
json_gzc.put("heji",df.format(gzc_heji));
|
|
json_gzc.put("notes","");
|
|
|
|
jsonArray.add(json_gzc);
|
|
|
|
JSONObject jsonObject_tjf = new JSONObject();
|
|
jsonObject_tjf.put("rentai_subtotal",df.format(tjf_rentai_xiaoji));
|
|
jsonObject_tjf.put("huaxia_subtotal",df.format(tjf_huaxia_xiaoji));
|
|
jsonObject_tjf.put("jinxiu_subtotal",df.format(tjf_jinxiu_xiaoji));
|
|
jsonObject_tjf.put("xunzhou_subtotal",df.format(tjf_xunzhou_xiaoji));
|
|
|
|
json_tjf.put("subtotal",jsonObject_tjf);
|
|
json_tjf.put("heji",df.format(tjf_heji));
|
|
json_tjf.put("notes","");
|
|
|
|
jsonArray.add(json_tjf);
|
|
|
|
JSONObject jsonObject_jrwz = new JSONObject();
|
|
jsonObject_jrwz.put("rentai_subtotal",df.format(jrwz_rentai_xiaoji));
|
|
jsonObject_jrwz.put("huaxia_subtotal",df.format(jrwz_huaxia_xiaoji));
|
|
jsonObject_jrwz.put("jinxiu_subtotal",df.format(jrwz_jinxiu_xiaoji));
|
|
jsonObject_jrwz.put("xunzhou_subtotal",df.format(jrwz_xunzhou_xiaoji));
|
|
|
|
json_jrwz.put("subtotal",jsonObject_jrwz);
|
|
json_jrwz.put("heji",df.format(jrwz_heji));
|
|
json_jrwz.put("notes","");
|
|
|
|
jsonArray.add(json_jrwz);
|
|
|
|
JSONObject jsonObject_fzfy = new JSONObject();
|
|
jsonObject_fzfy.put("rentai_subtotal",df.format(fzfy_rentai_xiaoji));
|
|
jsonObject_fzfy.put("huaxia_subtotal",df.format(fzfy_huaxia_xiaoji));
|
|
jsonObject_fzfy.put("jinxiu_subtotal",df.format(fzfy_jinxiu_xiaoji));
|
|
jsonObject_fzfy.put("xunzhou_subtotal",df.format(fzfy_xunzhou_xiaoji));
|
|
|
|
json_fzfy.put("subtotal",jsonObject_fzfy);
|
|
json_fzfy.put("heji",df.format(fzfy_heji));
|
|
json_fzfy.put("notes","");
|
|
|
|
jsonArray.add(json_fzfy);
|
|
|
|
JSONObject jsonObject_ywx = new JSONObject();
|
|
jsonObject_ywx.put("rentai_subtotal",df.format(ywx_rentai_xiaoji));
|
|
jsonObject_ywx.put("huaxia_subtotal",df.format(ywx_huaxia_xiaoji));
|
|
jsonObject_ywx.put("jinxiu_subtotal",df.format(ywx_jinxiu_xiaoji));
|
|
jsonObject_ywx.put("xunzhou_subtotal",df.format(ywx_xunzhou_xiaoji));
|
|
|
|
json_ywx.put("subtotal",jsonObject_ywx);
|
|
json_ywx.put("heji",df.format(ywx_heji));
|
|
json_ywx.put("notes","");
|
|
|
|
jsonArray.add(json_ywx);
|
|
|
|
JSONObject jsonObject_fsjw = new JSONObject();
|
|
jsonObject_fsjw.put("rentai_subtotal",df.format(fsjw_rentai_xiaoji));
|
|
jsonObject_fsjw.put("huaxia_subtotal",df.format(fsjw_huaxia_xiaoji));
|
|
jsonObject_fsjw.put("jinxiu_subtotal",df.format(fsjw_jinxiu_xiaoji));
|
|
jsonObject_fsjw.put("xunzhou_subtotal",df.format(fsjw_xunzhou_xiaoji));
|
|
|
|
json_fsjw.put("subtotal",jsonObject_fsjw);
|
|
json_fsjw.put("heji",df.format(fsjw_heji));
|
|
json_fsjw.put("notes","");
|
|
|
|
jsonArray.add(json_fsjw);
|
|
|
|
JSONObject jsonObject_pxf = new JSONObject();
|
|
jsonObject_pxf.put("rentai_subtotal",df.format(pxf_rentai_xiaoji));
|
|
jsonObject_pxf.put("huaxia_subtotal",df.format(pxf_huaxia_xiaoji));
|
|
jsonObject_pxf.put("jinxiu_subtotal",df.format(pxf_jinxiu_xiaoji));
|
|
jsonObject_pxf.put("xunzhou_subtotal",df.format(pxf_xunzhou_xiaoji));
|
|
|
|
json_pxf.put("subtotal",jsonObject_pxf);
|
|
json_pxf.put("heji",df.format(pxf_heji));
|
|
json_pxf.put("notes","");
|
|
|
|
jsonArray.add(json_pxf);
|
|
|
|
JSONObject jsonObject_ghjf = new JSONObject();
|
|
jsonObject_ghjf.put("rentai_subtotal",df.format(ghjf_rentai_xiaoji));
|
|
jsonObject_ghjf.put("huaxia_subtotal",df.format(ghjf_huaxia_xiaoji));
|
|
jsonObject_ghjf.put("jinxiu_subtotal",df.format(ghjf_jinxiu_xiaoji));
|
|
jsonObject_ghjf.put("xunzhou_subtotal",df.format(ghjf_xunzhou_xiaoji));
|
|
|
|
json_ghjf.put("subtotal",jsonObject_ghjf);
|
|
json_ghjf.put("heji",df.format(ghjf_heji));
|
|
json_ghjf.put("notes","");
|
|
|
|
jsonArray.add(json_ghjf);
|
|
|
|
JSONObject jsonObject_dthdf = new JSONObject();
|
|
jsonObject_dthdf.put("rentai_subtotal",df.format(dthdf_rentai_xiaoji));
|
|
jsonObject_dthdf.put("huaxia_subtotal",df.format(dthdf_huaxia_xiaoji));
|
|
jsonObject_dthdf.put("jinxiu_subtotal",df.format(dthdf_jinxiu_xiaoji));
|
|
jsonObject_dthdf.put("xunzhou_subtotal",df.format(dthdf_xunzhou_xiaoji));
|
|
|
|
json_dthdf.put("subtotal",jsonObject_dthdf);
|
|
json_dthdf.put("heji",df.format(dthdf_heji));
|
|
json_dthdf.put("notes","");
|
|
|
|
jsonArray.add(json_dthdf);
|
|
|
|
JSONObject jsonObject_hdch = new JSONObject();
|
|
jsonObject_hdch.put("rentai_subtotal",df.format(hdch_rentai_xiaoji));
|
|
jsonObject_hdch.put("huaxia_subtotal",df.format(hdch_huaxia_xiaoji));
|
|
jsonObject_hdch.put("jinxiu_subtotal",df.format(hdch_jinxiu_xiaoji));
|
|
jsonObject_hdch.put("xunzhou_subtotal",df.format(hdch_xunzhou_xiaoji));
|
|
|
|
json_hdch.put("subtotal",jsonObject_hdch);
|
|
json_hdch.put("heji",df.format(hdch_heji));
|
|
json_hdch.put("notes","");
|
|
|
|
jsonArray.add(json_hdch);
|
|
|
|
JSONObject jsonObject_clf = new JSONObject();
|
|
jsonObject_clf.put("rentai_subtotal",df.format(clf_rentai_xiaoji));
|
|
jsonObject_clf.put("huaxia_subtotal",df.format(clf_huaxia_xiaoji));
|
|
jsonObject_clf.put("jinxiu_subtotal",df.format(clf_jinxiu_xiaoji));
|
|
jsonObject_clf.put("xunzhou_subtotal",df.format(clf_xunzhou_xiaoji));
|
|
|
|
json_clf.put("subtotal",jsonObject_clf);
|
|
json_clf.put("heji",df.format(clf_heji));
|
|
json_clf.put("notes","");
|
|
|
|
jsonArray.add(json_clf);
|
|
|
|
JSONObject jsonObject_glcb = new JSONObject();
|
|
jsonObject_glcb.put("rentai_subtotal",df.format(glcb_rentai_xiaoji));
|
|
jsonObject_glcb.put("huaxia_subtotal",df.format(glcb_huaxia_xiaoji));
|
|
jsonObject_glcb.put("jinxiu_subtotal",df.format(glcb_jinxiu_xiaoji));
|
|
jsonObject_glcb.put("xunzhou_subtotal",df.format(glcb_xunzhou_xiaoji));
|
|
|
|
json_glcb.put("subtotal",jsonObject_glcb);
|
|
json_glcb.put("heji",df.format(glcb_heji));
|
|
json_glcb.put("notes","");
|
|
|
|
jsonArray.add(json_glcb);
|
|
|
|
JSONObject jsonObject_zbfwf = new JSONObject();
|
|
jsonObject_zbfwf.put("rentai_subtotal",df.format(zbfwf_rentai_xiaoji));
|
|
jsonObject_zbfwf.put("huaxia_subtotal",df.format(zbfwf_huaxia_xiaoji));
|
|
jsonObject_zbfwf.put("jinxiu_subtotal",df.format(zbfwf_jinxiu_xiaoji));
|
|
jsonObject_zbfwf.put("xunzhou_subtotal",df.format(zbfwf_xunzhou_xiaoji));
|
|
|
|
json_zbfwf.put("subtotal",jsonObject_zbfwf);
|
|
json_zbfwf.put("heji",df.format(zbfwf_heji));
|
|
json_zbfwf.put("notes","");
|
|
|
|
jsonArray.add(json_zbfwf);
|
|
|
|
JSONObject jsonObject_qtrgcb = new JSONObject();
|
|
jsonObject_qtrgcb.put("rentai_subtotal",df.format(qtrgcb_rentai_xiaoji));
|
|
jsonObject_qtrgcb.put("huaxia_subtotal",df.format(qtrgcb_huaxia_xiaoji));
|
|
jsonObject_qtrgcb.put("jinxiu_subtotal",df.format(qtrgcb_jinxiu_xiaoji));
|
|
jsonObject_qtrgcb.put("xunzhou_subtotal",df.format(qtrgcb_xunzhou_xiaoji));
|
|
|
|
json_qtrgcb.put("subtotal",jsonObject_qtrgcb);
|
|
json_qtrgcb.put("heji",df.format(qtrgcb_heji));
|
|
json_qtrgcb.put("notes","");
|
|
|
|
jsonArray.add(json_qtrgcb);
|
|
|
|
JSONObject jsonObject_sd = new JSONObject();
|
|
jsonObject_sd.put("rentai_subtotal",df.format(sd_rentai_xiaoji));
|
|
jsonObject_sd.put("huaxia_subtotal",df.format(sd_huaxia_xiaoji));
|
|
jsonObject_sd.put("jinxiu_subtotal",df.format(sd_jinxiu_xiaoji));
|
|
jsonObject_sd.put("xunzhou_subtotal",df.format(sd_xunzhou_xiaoji));
|
|
|
|
json_sd.put("subtotal",jsonObject_sd);
|
|
json_sd.put("heji",df.format(sd_heji));
|
|
json_sd.put("notes","");
|
|
|
|
jsonArray.add(json_sd);
|
|
|
|
JSONObject jsonObject_hj = new JSONObject();
|
|
jsonObject_hj.put("rentai_subtotal",df.format(hj_rentai_xiaoji));
|
|
jsonObject_hj.put("huaxia_subtotal",df.format(hj_huaxia_xiaoji));
|
|
jsonObject_hj.put("jinxiu_subtotal",df.format(hj_jinxiu_xiaoji));
|
|
jsonObject_hj.put("xunzhou_subtotal",df.format(hj_xunzhou_xiaoji));
|
|
|
|
json_hj.put("subtotal",jsonObject_hj);
|
|
json_hj.put("heji",df.format(hj_heji));
|
|
json_hj.put("notes","");
|
|
|
|
jsonArray.add(json_hj);
|
|
}
|
|
|
|
sum++;
|
|
%>
|
|
|
|
<%!
|
|
|
|
/**
|
|
* 获取 两个日期字符串相差的 月份数
|
|
* @param startDate
|
|
* @param endDate
|
|
* @return
|
|
*/
|
|
public 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;
|
|
}
|
|
return result;
|
|
}
|
|
|
|
/**
|
|
* 获取 金额
|
|
* @param table
|
|
* @param fygzyf
|
|
* @param wbgs
|
|
* @param fygzgs 0-华夏 1-仁泰 5-锦绣 7-洵洲
|
|
* @param yjkm
|
|
* @param ejkm
|
|
* @return
|
|
*/
|
|
public double getSumFee(String table,String fygzyf,String wbgs,String fygzgs,String yjkm,String ejkm){
|
|
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 +") ";
|
|
}
|
|
if(yjkm != null && !"".equals(yjkm)){
|
|
where += " and b.yjkm in ("+ yjkm +") ";
|
|
}
|
|
if(ejkm != null && !"".equals(ejkm)){
|
|
where += " and b.ejkm in ("+ ejkm +") ";
|
|
}
|
|
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;
|
|
}
|
|
|
|
/**
|
|
* 获取 加班费
|
|
* uf_gzhqmxb
|
|
* @param table
|
|
* @param fygzyf
|
|
* @param wbgs
|
|
* @param fygzgs
|
|
* @return
|
|
*/
|
|
public double getOvertimePay(String table,String fygzyf,String wbgs,String fygzgs){
|
|
double result = 0.00;
|
|
RecordSet rs = new RecordSet();
|
|
String where = " ";
|
|
if(fygzgs != null && !"".equals(fygzgs)){
|
|
// 0-后勤 3-实业
|
|
if("0".equals(fygzgs)){
|
|
fygzgs = "1";
|
|
}
|
|
if("3".equals(fygzgs)){
|
|
fygzgs = "0";
|
|
}
|
|
where += " and htgs in ("+ fygzgs +") ";
|
|
}
|
|
if(wbgs != null && !"".equals(wbgs)){
|
|
// 0-华夏 1-仁泰 5-锦绣 7-洵洲
|
|
// 0-锦绣 1-仁泰 2-洵洲 3-华夏
|
|
if("0".equals(wbgs)){
|
|
wbgs = "3";
|
|
}
|
|
if("5".equals(wbgs)){
|
|
wbgs = "0";
|
|
}
|
|
if("7".equals(wbgs)){
|
|
wbgs = "2";
|
|
}
|
|
where += " and wbgs in ("+ wbgs +") ";
|
|
}
|
|
rs.executeQuery("select sum(jbgz2)as count from "+table+" where yf=? "+ where,fygzyf);
|
|
while(rs.next()){
|
|
result = Util.getDoubleValue(rs.getString("count"),0.00);
|
|
}
|
|
return result;
|
|
}
|
|
|
|
/**
|
|
* 获取 下拉框 的名称
|
|
* @param fieldid
|
|
* @param value
|
|
* @return
|
|
*/
|
|
public 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 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 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 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();
|
|
}
|
|
|
|
%>
|
|
|
|
<BODY>
|
|
|
|
<h1>Congratulation Mode 666666 !</h1>
|
|
|
|
<h1> sum <%=sum%> </h1>
|
|
|
|
<h2> JSONArray <%=jsonArray%> </h2>
|
|
|
|
</BODY> |