| | |
|---|
| | | dsm.*, |
|---|
| | | ds.scene_name as defense_scene_name |
|---|
| | | from ja_fw_defense_scene_manage dsm |
|---|
| | | left join ja_fw_defense_scene ds on ds.id::VARCHAR = dsm.defense_scene_id::VARCHAR and ds.is_deleted = 0 |
|---|
| | | left join ja_fw_area_divide ad on ad.id = ANY(string_to_array(ds.area_divide_ids, ',')::bigint[]) and ad.is_deleted = 0 |
|---|
| | | left join ja_fw_defense_scene ds on ds.id::text = dsm.defense_scene_id::text and ds.is_deleted = 0 |
|---|
| | | left join ja_fw_area_divide ad on ad.id::text = ANY(string_to_array(replace(ds.area_divide_ids, ' ', ''), ',')) and ad.is_deleted = 0 |
|---|
| | | inner join ( |
|---|
| | | SELECT |
|---|
| | | d.id |
|---|
| | |
|---|
| | | <if test="fwBaseInfo.currentDeptId != null and fwBaseInfo.currentDeptId != '' "> |
|---|
| | | or d.id in ( |
|---|
| | | SELECT device_id FROM ja_fw_device_per_share |
|---|
| | | WHERE loan_to_dept_id = #{fwBaseInfo.currentDeptId} |
|---|
| | | WHERE |
|---|
| | | loan_to_dept_id = #{fwBaseInfo.currentDeptId}::bigint |
|---|
| | | AND is_deleted = 0 |
|---|
| | | ) |
|---|
| | | </if> |
|---|
