描述:警保部下面的部门的人申请的单子,警保部的负责审批的人看不到
解决:
1.点击页面找到请求url
2.运用阿楠给我的工具,可以获取后台的url
拷贝前台项目到D盘,然后在此处设置好路径
双击testFrom0(),得到
3.找到代码
修改代码:
修改好代码:
断点打印正确的sql:
断点打印的错误的sql:
select create_time,
apply_id as applyId,
veh_user_name as vehUserName,
veh_use_org_id as vehUseOrgId,
veh_use_dept_id as vehUseDeptId,
veh_use_type as vehUseType,
host_no as hostNo,
driver_Name as driverName,
approver_Name as approverName,
approver_Name as deptApproverName,
guarantee_Approver_Name as guaranteeApproverName,
apply_status,
passenger_num as passengerNum,
is_Guarantee as isGuarantee
from vd_veh_use_apply_info t
where 1 = 1
and t.apply_status <> 4
and is_guarantee != 1
and t.create_org_id = 23551
and t.create_dept_id = 0
order by create_time desc
查表发现问题:
因为警保部的单位编号create_dept_id或(update_dept_id)是为0的,而下属机构都是不同的,要想看到下属机构,必须要用in
修改好测试OK~~