视图数据根据流程筛选

自己看自己数据，经办人和待办人看自己相关数据，某个角色（系统管理员、构件公司管理员）可以查看所有数据

(function(){
    var webUser = getWebUser();
    var userid = webUser.getId();
    var authSQL = "";
    var userdeptid = webUser.getDefaultDepartment();
    var roleId1 = getRoleIdByName("系统管理员");  //系统管理员
    var roleId3 = getRoleIdByName("构件公司管理员");  //构件公司管理员
    if(isThisRoleIdByUser(webUser,roleId1)||isThisRoleIdByUser(webUser,roleId3)){

    }else{
            authSQL +=" and (author ='"+userid+"'";            
            authSQL += " OR id in (select DOC_ID from T_ACTORHIS his  WHERE  his.ACTORID ='"+userid+"'  union all select DOC_ID from T_ACTORRT rt WHERE rt.ACTORID ='"+userid+"'" 
authSQL +=  " union all select DOC_ID from t_flowhistory tf where tf.ACTORID ='"+userid+"'))";
    }
    var sql = "select * from tlk_日常报告申请 where 1=1 "+wsql+authSQL;
    println(sql);
    return sql;
})();