年假脚本示例

【myApps/OBPM版本号】：v4.4- sp 23
【浏览器类型】：Chrome/其他
【问题描述】：年假脚本示例

1. var curDoc = getCurrentDocument();
   
2. var rtn = curDoc.getAuthor().getId();
   
3. var year = getYear(getToday());
   
4. var type = getItemValueAsString("请假类别");
   
5. if("年假".equals(type)){
   
6. var sql = "select sum(ITEM_合计天数) as ITEM_合计天数,sum(ITEM_请假小时) as ITEM_请假小时,domainid,applicationid,formid,id from tlk_请假申请单 where author ='"+rtn+"' and ITEM_请假类别='年假' and STATELABEL != '未提交' and ITEM_请假开始日期>=DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY)";
   
7. var doc=findBySQL(sql);
   
8. if(doc!=null){       
   
9.         var days = doc.getItemValueAsInt("合计天数");
   
10.         var hour = doc.getItemValueAsInt("请假小时");
    
11.         var day1 = toFloor(hour/8);
    
12.         days = days+day1;
    
13.         var hour1 = hour%8;
    
14.         var str = "已请年假："+days+"天"+hour1+"小时";
    
15.         str = "<span style='color:red;'>" + str + "</span>";
    
16.        
    
17. }else{
    
18. var str = "已请年假：0天0小时";
    
19. str = "<span style='color:red;'>" + str + "</span>";
    
20. }
    
21. str;
    
22. }

复制代码