select * from hrmpslmanagement where psldays > 0 and leavetype =41 and pslyear = 2022
--分部带薪假查询
--leavetype:带薪假类型 resourceid:人员id pslyear:有效期年 psldays status:状态
select a.lastname 姓名,c.departmentname 部门,e.psldays as 天数,e.pslyear as 年份
from hrmresource a
inner join HrmSubCompany b on a.subcompanyid1=b.id
inner join HrmDepartment c on a.departmentid=c.id
inner join hrmpslmanagement e on e.resourceid = a.id
E9/8:公司分部带薪假查询
于 2022-11-21 10:43:51 首次发布