项目信息和出库信息高级搜索

354798ggg

2023-11-14 443b575f774d8eb50c16d4eefccce5218fb8de2a

 product-server-project-management/src/main/java/com/product/project/management/service/ProjectInfoService.java

@@ -13,7 +13,7 @@
import com.product.core.exception.BaseException;
import com.product.core.permission.PermissionService;
import com.product.core.service.support.AbstractBaseService;
import com.product.core.spring.context.SpringMVCContextHolder;
import com.product.core.service.support.QueryFilterService;
import com.product.project.management.config.Cmnconst;
import com.product.project.management.config.SystemCode;
import com.product.util.BaseUtil;
@@ -29,22 +29,26 @@
    @Autowired
    PermissionService permissionService;
    
    @Autowired
    QueryFilterService queryFilterService;
    
    /**
     *    项目信息列表
     * @param cpage
     * @param pageSize
     * @return
     */
    public DataTableEntity listProjectByCreated(Integer cpage, Integer pageSize) {

       String queryFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
    	
    	
       FieldSetEntity fseCurrentUser = SpringMVCContextHolder.getCurrentUser().getCurrentStaff();
       String leaderCode = fseCurrentUser.getString("leader_tricode")+"%";
    	
       String filter =" project_leader in (select user_id from product_sys_staffs where leader_tricode like ?) OR materialman in (select user_id from product_sys_staffs where leader_tricode like ?)";
       DataTableEntity dt = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_QXLW, filter, new Object [] {leaderCode, leaderCode}, null, Cmnconst.CREATED_UTC_DATETIME_DESC, pageSize, cpage);
    public DataTableEntity listProjectByCreated(FieldSetEntity fse) {
       String queryFilter = " 1 = 1 ";
       String searchFilter = queryFilterService.getQueryFilter(fse);
       if (!BaseUtil.strIsNull(searchFilter)) {
          queryFilter += " AND " + searchFilter;
      }
       String limitFilter = permissionService.getDataFilter(Cmnconst.PRODUCT_PROJECT_QXLW, "project_leader,materialman");
       if (!BaseUtil.strIsNull(limitFilter)) {
         queryFilter += " AND " + limitFilter;
      }
       DataTableEntity dt = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_QXLW, queryFilter, new Object [] {}, null, Cmnconst.CREATED_UTC_DATETIME_DESC, fse.getInteger(Cmnconst.PAGESIZE), fse.getInteger(Cmnconst.CPAGE));
       baseDao.loadPromptData(dt);
       return dt;
    }