报废单导出

futian.liu

2023-11-30 86fdf3673cd8b3f34ed57a80556512cdcabdb202

 consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java

@@ -2,12 +2,9 @@

import com.consum.base.Constants;
import com.consum.base.pojo.FinSysTenantDepartmentParam;
import com.consum.base.util.IdUtil;
import com.consum.model.po.BaseCategory;
import com.consum.model.po.FinSysTenant;
import com.consum.base.core.utils.IdUtil;
import com.consum.model.po.FinSysTenantDepartment;
import com.consum.model.po.FinSysTenantUser;
import com.iplatform.model.po.S_user_core;
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.DateUtils;
import com.walker.infrastructure.utils.StringUtils;
@@ -47,7 +44,6 @@
            sql.append(" and TENANT_ID =:TENANT_ID ");
            paramts.put("TENANT_ID", tenantId);
        }

        return this.get(sql.toString(), paramts, new FinSysTenantDepartment());
    }

@@ -149,4 +145,21 @@
        department.setUpdateBy(currentUser.getUserName());
        return this.update(department);
    }

    /**
     * 根据机构id查询部门
     * @param agencyId
     * @return
     */
    public List<FinSysTenantDepartment> getByTenantId(Long agencyId) {
        StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 and is_delete = 0 ");
        HashMap<String, Object> paramts = new HashMap<>();

        //机构id
        if (agencyId != null) {
            sql.append(" and TENANT_ID =:TENANT_ID ");
            paramts.put("TENANT_ID", agencyId);
        }
        return this.select(sql.toString(), paramts, new FinSysTenantDepartment());
    }
}