public JSONObject getBusiExtTime(JSONObject json ){
JSONArray array=json.getJSONArray("rows");
if(null!=array && array.size()>0){
for (int i = 0; i < array.size(); i++) {
JSONObject cells=array.getJSONObject(i).getJSONObject("cell");
//事项已完成时,求超出时间(完成时间-承诺时间)
if(cells.containsKey("FINISH_TIME") && cells.containsKey("TIME_LIMIT")&&null != cells.getDate("FINISH_TIME")&&null != cells.getDate("TIME_LIMIT")){
cells.put("EXTTIME", this.organizationService.getWorkDay(cells.getDate("TIME_LIMIT"), cells.getDate("FINISH_TIME")));
}else
//当事项未完成时,求超出时间(当前时间-承诺时间)
if(cells.containsKey("TIME_LIMIT") && null != cells.getDate("TIME_LIMIT")&&cells.containsKey("FINISH_TIME")&&null == cells.getDate("FINISH_TIME")){
cells.put("EXTTIME", this.organizationService.getWorkDay(cells.getDate("TIME_LIMIT"), new Date()));
}else{
cells.put("EXTTIME","");
}
//事项已完成时,求花费时间(完成时间-提交时间)
if(cells.containsKey("SUBMIT_TIME") && cells.containsKey("FINISH_TIME")&&null != cells.getDate("SUBMIT_TIME")&&null != cells.getDate("FINISH_TIME")){
cells.put("ALLTIME", this.organizationService.getWorkDay(cells.getDate("SUBMIT_TIME"), cells.getDate("FINISH_TIME")));
}else
//事项未完成时,求花费时间(当前时间-提交时间)
if(cells.containsKey("SUBMIT_TIME") && null != cells.getDate("SUBMIT_TIME")&&cells.containsKey("FINISH_TIME")&&null == cells.getDate("FINISH_TIME")){
cells.put("ALLTIME", this.organizationService.getWorkDay(cells.getDate("SUBMIT_TIME"), new Date()));
}else{
cells.put("ALLTIME","");
}
}
}
return json;
}
JSONArray array=json.getJSONArray("rows");
if(null!=array && array.size()>0){
for (int i = 0; i < array.size(); i++) {
JSONObject cells=array.getJSONObject(i).getJSONObject("cell");
//事项已完成时,求超出时间(完成时间-承诺时间)
if(cells.containsKey("FINISH_TIME") && cells.containsKey("TIME_LIMIT")&&null != cells.getDate("FINISH_TIME")&&null != cells.getDate("TIME_LIMIT")){
cells.put("EXTTIME", this.organizationService.getWorkDay(cells.getDate("TIME_LIMIT"), cells.getDate("FINISH_TIME")));
}else
//当事项未完成时,求超出时间(当前时间-承诺时间)
if(cells.containsKey("TIME_LIMIT") && null != cells.getDate("TIME_LIMIT")&&cells.containsKey("FINISH_TIME")&&null == cells.getDate("FINISH_TIME")){
cells.put("EXTTIME", this.organizationService.getWorkDay(cells.getDate("TIME_LIMIT"), new Date()));
}else{
cells.put("EXTTIME","");
}
//事项已完成时,求花费时间(完成时间-提交时间)
if(cells.containsKey("SUBMIT_TIME") && cells.containsKey("FINISH_TIME")&&null != cells.getDate("SUBMIT_TIME")&&null != cells.getDate("FINISH_TIME")){
cells.put("ALLTIME", this.organizationService.getWorkDay(cells.getDate("SUBMIT_TIME"), cells.getDate("FINISH_TIME")));
}else
//事项未完成时,求花费时间(当前时间-提交时间)
if(cells.containsKey("SUBMIT_TIME") && null != cells.getDate("SUBMIT_TIME")&&cells.containsKey("FINISH_TIME")&&null == cells.getDate("FINISH_TIME")){
cells.put("ALLTIME", this.organizationService.getWorkDay(cells.getDate("SUBMIT_TIME"), new Date()));
}else{
cells.put("ALLTIME","");
}
}
}
return json;
}