获取某几个月客户销量【业务逻辑函数】

函数格式：
getCustomerSalesByMonths(customerno, startDate, isLastYear, beginNum, endNum)
函数说明：
customerno: 客户号
startDate: 日期，根据此日期获取财务年
isLastYear: 是否上年
beginNum: 开始月份
endNum: 结束月份
示例：
实现getCustomerSalesByMonths(customerno, startDate, isLastYear, beginNum, endNum)函数的应用

1. 
   
2. function getCustomerSalesByMonths(customerno, startDate, isLastYear, beginNum, endNum) {
   
3.         var year = "";
   
4.         var strDate = "";
   
5.         var iyear = 0; //var startDate = getItemValueAsDate("startdate");
   
6.         if (startDate != null) {
   
7.                 strDate = format(startDate, "yyyy-MM-dd");
   
8.         }
   
9.         var sql = "select * from TLK_CALENDAR where '" + strDate + "' between ITEM_FROM and ITEM_TO";
   
10.         var cal = findBySQL(sql);
    
11.         year = cal.getItemValueAsString("year");
    
12.         if (year != null && year.length() > 3) {
    
13.                 iyear = parseInt(year.substring(2, year.length()));
    
14.                 if (isLastYear) iyear = iyear - 1;
    
15.         }
    
16.         var syear = "FY" + iyear;
    
17. 
    
18.          //var customerno = getItemValue("customerno");
    
19.         var countSql = "select SUM(item_sales) from tlk_customersales  where ITEM_customerno='" + customerno + "'"
    
20.                 + " and ITEM_SALESSTARTDATE >= (select MIN(item_from) from TLK_CALENDAR where ITEM_YEAR='" + syear + "' and item_num between "+beginNum+" and "+endNum+")"
    
21.                 + " and ITEM_SALEENDDATE <= (select MAX(item_to) from TLK_CALENDAR where ITEM_YEAR='" + syear + "' and item_num between "+beginNum+" and "+endNum+")";
    
22.         var value = sumBySQL(countSql);
    
23.         return value;
    
24. }
    

复制代码

调用

1. 
   
2. #include " businesslib";
   
3. getCustomerSalesByMonths ("customerno", " startDate", " isLastYear", " beginNum", " endNum");
   

复制代码