|
public static Table QueryAttendanceCalculate(String endDate,String startDate,String departmentID)throws Exception{
String msSql = "";
//按日期条件查询视图sql
msSql = "select Calculate.fKQH as fKQH,Calculate.fXM as fXM,Calculate.fRQ as fRQ,Calculate.fKQZT as fKQZT,Calculate.fQDSJ as fQDSJ,Calculate.fQTSJ as fQTSJ from OA_AttendanceCalculate Calculate where Calculate.fRQ between '"+startDate+"' and '"+endDate+"'";
//如果按部门查询增加条件
if(departmentID!=null &&!"".equals(departmentID)){
msSql+= " and Calculate.fSZBMID = '"+departmentID+"'";
}
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put("MSSQL",msSql);
Table table = SQL.select(sqlMap,null,attendanceCalculateModel);
Iterator<Row> result=table.iterator();
//遍历Table
while(result.hasNext()){
Row row = result.next();
String fRQ = row.getString("fRQ");
//上班时间
String workTimeStart = "";
//下班时间
String workTimeEnd = "";
//获取上下班时间
String workTime = getTSRYWorkTime(fRQ,row.getString("fKQH"));
if(!"-".equals(workTime)){
workTimeStart = workTime.split("-")[0];
workTimeEnd = workTime.split("-")[1];
}else{
workTime = getWorkTime("2015-01-01");
if(!"-".equals(workTime)){
workTimeStart = workTime.split("-")[0];
workTimeEnd = workTime.split("-")[1];
}
}
if("-".equals(workTime)){
throw new Exception("上下班时间的开始日期和结束日期设置不正确!");
}
System.out.println(getWorkTime("2015-12-12"));
String fKQZT = row.getString("fKQZT");
String fQDSJ = row.getString("fQDSJ");
String fQTSJ = row.getString("fQTSJ");
}
return table;
}
|
|