| | |
|---|
| | | //1为公司文件夹 |
|---|
| | | if(directory_type == 1) { |
|---|
| | | StringBuffer sql = new StringBuffer(); |
|---|
| | | sql.append(" SELECT * FROM product_oa_directory_rights a ") |
|---|
| | | .append(" LEFT JOIN product_sys_organizational_structure_storage b on a.storage_uuid = b.uuid ") |
|---|
| | | .append(" WHERE a.directory_uuid = ? ") |
|---|
| | | .append(" AND rigths like '%3%' AND concat(',',staff_ids,',') like ? ");//3为新增 |
|---|
| | | String staffId = SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("staff_id"); |
|---|
| | | staffId = "%," + staffId + ",%"; |
|---|
| | | DataTableEntity dataTableEntity = baseDao.listTable(sql.toString(), new String[]{directory_uuid, staffId}); |
|---|
| | | sql.append(" SELECT * FROM product_oa_directory_rights ") |
|---|
| | | .append(" WHERE directory_uuid = ? ") |
|---|
| | | .append(" AND rigths like '%3%' AND concat(',',storage_uuid,',') like ? ");//3为新增 |
|---|
| | | String user_id = String.valueOf(SpringMVCContextHolder.getCurrentUser().getUser_id()); |
|---|
| | | user_id = "%," + user_id + ",%"; |
|---|
| | | DataTableEntity dataTableEntity = baseDao.listTable(sql.toString(), new String[]{directory_uuid, user_id}); |
|---|
| | | row = dataTableEntity.getRows(); |
|---|
| | | } |
|---|
| | | //1为个人文件夹 |
|---|
