government __un4wR3dIPBHkN2vQCXT __ZLuP7RGirprZZ6SCdiX true 05 false false false true relatedForm false 0 month normal false __0rM6c9M0LSlhA762THX public " + categoryName); var cateCode = getCodeWithCategoryName(categoryName); println('cateCode ==================>' + cateCode); var sqlUser="select * FROM tlk_categorypermissions WHERE ITEM_PEOPLE LIKE '%"+getWebUser().getId()+"%'"; println("执行sql ==========================>"+sqlUser); var users = queryBySQL(sqlUser); println("获取数据 ==========================>"+users); //可获取的地区数据 var sceneData = ''; var areaData = '' var dutyData = '' if(users!=null){ println("判断成功进入if分支 ==========================>"); var iter =users.iterator(); if(iter != null && iter.hasNext()){ doc = iter.next(); sceneData += doc.getItemValueAsString('scene'); areaData += doc.getItemValueAsString('area'); dutyData += doc.getItemValueAsString('duty'); } println("dutyData ==========================>"+dutyData); } var arr = areaData.split(";"); println("arr ==================== >"+arr); println("arr0 ==================== >"+arr[0]); println("arr1 ==================== >"+arr[1]); var sqlTemp = '' var sql = "SELECT * FROM tlk_attendance_site_base_info WHERE ITEM_ATTENDANCESITETYPE = "+cateCode+" and ITEM_DOMAIN_ID = '"+getDomainid()+"' and '"+dutyData+"' like concat('%',(ITEM_ATTENDANCESITETYPE),'%') and (" for(var i = 0;i" + sql ) return sql; })()]]> 1 02