| | |
| | | logger.info("getUserInfo start..."); |
| | | |
| | | List<SysUser> userList = sysUserService.getSysUserInfoList(startTime, endTime); |
| | | List<SysLaboratoryContainer> allLaboratoryContainerList = sysLaboratoryContainerService.getSysLaboratoryContainerList(null,null,null,null,null); |
| | | List<SysLaboratoryContainer> allLaboratoryContainerList = sysLaboratoryContainerService.getSysLaboratoryContainerList(null,null,null,null,null,null,null); |
| | | List<SysWarehouseContainer> allWarehouseContainerList = sysWarehouseContainerService.getSysWarehouseContainerList(null,null,null,null,null); |
| | | |
| | | List<String> containerCodeList = new ArrayList<String>(); |
| | |
| | | |
| | | private String laboratoryType; |
| | | private String laboratoryName; |
| | | private String project; |
| | | private String controllerName; |
| | | |
| | | private int action; |
| | | |
| | |
| | | List<SysLaboratoryContainer> list = null; |
| | | try { |
| | | int count = sysLaboratoryContainerService.getSysLaboratoryContainerTotalCount(laboratoryType, |
| | | laboratoryName,null); |
| | | laboratoryName,null,project,controllerName); |
| | | this.setRowCount(count); |
| | | if (count > 0) { |
| | | list = sysLaboratoryContainerService.getSysLaboratoryContainerList(laboratoryType, |
| | | laboratoryName,null, first, pageSize); |
| | | laboratoryName,null,project,controllerName, first, pageSize); |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error(e); |
| | |
| | | this.controllers = controllers; |
| | | } |
| | | |
| | | public String getProject() { |
| | | return project; |
| | | } |
| | | |
| | | public void setProject(String project) { |
| | | this.project = project; |
| | | } |
| | | |
| | | public String getControllerName() { |
| | | return controllerName; |
| | | } |
| | | |
| | | public void setControllerName(String controllerName) { |
| | | this.controllerName = controllerName; |
| | | } |
| | | } |
| | |
| | | private List<SysLaboratory> selectedList; |
| | | private String type; |
| | | private String name; |
| | | private String project; |
| | | |
| | | private int action; |
| | | |
| | |
| | | Map<String, Object> filters) { |
| | | List<SysLaboratory> list = null; |
| | | try { |
| | | int count = sysLaboratoryService.getSysLaboratoryTotalCount(type, name); |
| | | int count = sysLaboratoryService.getSysLaboratoryTotalCount(type, name,project); |
| | | this.setRowCount(count); |
| | | if (count > 0) { |
| | | list = sysLaboratoryService.getSysLaboratoryList(type, name, first, pageSize); |
| | | list = sysLaboratoryService.getSysLaboratoryList(type, name,project, first, pageSize); |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error(e); |
| | |
| | | public void setType(String type) { |
| | | this.type = type; |
| | | } |
| | | |
| | | public String getProject() { |
| | | return project; |
| | | } |
| | | |
| | | public void setProject(String project) { |
| | | this.project = project; |
| | | } |
| | | } |
| | |
| | | |
| | | private Hashtable printTable; |
| | | |
| | | private String containerCode; |
| | | |
| | | public String getHouseName() { |
| | | return houseName; |
| | | } |
| | |
| | | Map<String, Object> filters) { |
| | | List<OpeUseFlow> list = null; |
| | | try { |
| | | int count = opeUseFlowService.getOpeUseFlowTotalCountByName(houseName,reagentId, reagentCode, null, getUserId(),startDate,endDate); |
| | | int count = opeUseFlowService.getOpeUseFlowTotalCountByName(houseName,reagentId, reagentCode, containerCode,null, getUserId(),startDate,endDate); |
| | | this.setRowCount(count); |
| | | if (count > 0) { |
| | | list = opeUseFlowService.getOpeUseFlowListByName(houseName,reagentId, reagentCode, null, getUserId(),startDate,endDate, first, pageSize); |
| | | list = opeUseFlowService.getOpeUseFlowListByName(houseName,reagentId, reagentCode, containerCode,null, getUserId(),startDate,endDate, first, pageSize); |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error(e); |
| | |
| | | public void setPrintTable(Hashtable printTable) { |
| | | this.printTable = printTable; |
| | | } |
| | | |
| | | public String getContainerCode() { |
| | | return containerCode; |
| | | } |
| | | |
| | | public void setContainerCode(String containerCode) { |
| | | this.containerCode = containerCode; |
| | | } |
| | | } |
| | |
| | | private Map<String, List<SysWarehouseContainer>> warehouseIdContainerMap; |
| | | |
| | | public void initRukuPage() { |
| | | this.userSelectList = this.sysUserService.getSysUserList(null, null, null, null, null); |
| | | this.userSelectList = this.sysUserService.getSysUserList(null, null, null, null, null,null,null); |
| | | //将admin置于首位 |
| | | for (int i = 0; i < userSelectList.size(); i++) { |
| | | if ("admin".equals(userSelectList.get(i).getAccount())){ |
| | |
| | | |
| | | private void initUserSelectList() { |
| | | logger.info("WarehouseStockMngController initUserSelectList start"); |
| | | this.setUserSelectList(this.sysUserService.getSysUserList(null, null, null, null, null)); |
| | | this.setUserSelectList(this.sysUserService.getSysUserList(null, null, null, null, null,null,null)); |
| | | } |
| | | public void setUserSelectList(List<SysUser> userSelectList) { |
| | | this.userSelectList = userSelectList; |
| | |
| | | private List<BaseMeta> codeList; |
| | | private List<BaseRole> roleList; |
| | | private List<Waster> wasterSelectList; |
| | | private String project; |
| | | private String company; |
| | | |
| | | public List<BaseRole> getRoleList() { |
| | | return roleList; |
| | |
| | | public List<SysUser> load(int first, int pageSize, String sortField, SortOrder sortOrder, Map<String, Object> filters) { |
| | | List<SysUser> list = null; |
| | | try { |
| | | int count = sysUserService.getSysUserTotalCount(arp, name,departmentName); |
| | | int count = sysUserService.getSysUserTotalCount(arp, name,departmentName,project,company); |
| | | this.setRowCount(count); |
| | | if (count > 0) { |
| | | list = sysUserService.getSysUserList(arp, name,departmentName, first, pageSize); |
| | | list = sysUserService.getSysUserList(arp, name,departmentName,project,company, first, pageSize); |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error(e); |
| | |
| | | public void setDepartmentName(String departmentName) { |
| | | this.departmentName = departmentName; |
| | | } |
| | | |
| | | public String getProject() { |
| | | return project; |
| | | } |
| | | |
| | | public void setProject(String project) { |
| | | this.project = project; |
| | | } |
| | | |
| | | public String getCompany() { |
| | | return company; |
| | | } |
| | | |
| | | public void setCompany(String company) { |
| | | this.company = company; |
| | | } |
| | | } |
| | |
| | | private String endReagentCode; |
| | | private String startReagentCodeForPerson; |
| | | private String endReagentCodeForPerson; |
| | | private String warehouseName; |
| | | |
| | | private Integer editFlag; |
| | | private StreamedContent file; |
| | |
| | | |
| | | private void initUserSelectList() { |
| | | logger.info("WarehouseStockMngController initUserSelectList start"); |
| | | this.setUserSelectList(this.sysUserService.getSysUserList(null, null, null, null, null)); |
| | | this.setUserSelectList(this.sysUserService.getSysUserList(null, null, null, null, null,null,null)); |
| | | /**if(sysUserService.getSysUser(userId) == null) |
| | | { |
| | | this.laboratory = this.sysLaboratoryService.getSysLaboratoryListByDep(this.getUserDepartment()); |
| | |
| | | Map<String, Object> filters) { |
| | | List<OpeWarehouseReserve> list = null; |
| | | try { |
| | | int count = opeWarehouseReserveService.getOpeWarehouseReserveTotalCountByName(reagentId, supplierId,productSn); |
| | | int count = opeWarehouseReserveService.getOpeWarehouseReserveTotalCountByName(reagentId, supplierId,productSn,warehouseName); |
| | | this.setRowCount(count); |
| | | if (count > 0) { |
| | | list = opeWarehouseReserveService.getOpeWarehouseReserveListByName(reagentId, supplierId, first, |
| | | pageSize,productSn); |
| | | pageSize,productSn,warehouseName); |
| | | } |
| | | } catch (Exception e) { |
| | | logger.error(e); |
| | |
| | | realDataList=selectedList; |
| | | }else { |
| | | realDataList = opeWarehouseReserveService.getOpeWarehouseReserveListByName(reagentId, supplierId, null, |
| | | null,productSn); |
| | | null,productSn,warehouseName); |
| | | } |
| | | List<String> headerList = new ArrayList<>(); |
| | | headerList.add("试剂名称"); |
| | |
| | | list.add(sysUser); |
| | | applyUserSelectList = list; |
| | | } else { |
| | | applyUserSelectList = this.sysUserService.getSysUserList(null, null, null, null, null); |
| | | applyUserSelectList = this.sysUserService.getSysUserList(null, null, null, null, null,null,null); |
| | | } |
| | | } |
| | | return applyUserSelectList; |
| | |
| | | } |
| | | |
| | | public List getConsignee() { |
| | | List<SysUser> dataList = this.sysUserService.getSysUserList(null, null, null, null, null); |
| | | List<SysUser> dataList = this.sysUserService.getSysUserList(null, null, null, null, null,null,null); |
| | | //将admin置于首位 |
| | | for (int i = 0; i < dataList.size(); i++) { |
| | | if ("admin".equals(dataList.get(i).getAccount())){ |
| | |
| | | public void setReceiptNumber(String receiptNumber) { |
| | | this.receiptNumber = receiptNumber; |
| | | } |
| | | |
| | | public String getWarehouseName() { |
| | | return warehouseName; |
| | | } |
| | | |
| | | public void setWarehouseName(String warehouseName) { |
| | | this.warehouseName = warehouseName; |
| | | } |
| | | } |
| | |
| | | <if test="endDate != null and endDate !=''"> |
| | | and oa.create_time <= #{endDate} |
| | | </if> |
| | | <if test="containerCode != null and containerCode !=''"> |
| | | and wc.container_code = #{containerCode} |
| | | or lc.container_code =#{containerCode} |
| | | </if> |
| | | </sql> |
| | | |
| | | <sql id="queryColumns"> |
| | |
| | | <if test="productSn != null and productSn != ''"> |
| | | and sr.product_sn like concat('%',#{productSn},'%') |
| | | </if> |
| | | <if test="warehouseName != null and warehouseName != ''"> |
| | | and sw.name like concat('%',#{warehouseName},'%') |
| | | </if> |
| | | </sql> |
| | | |
| | | <sql id="queryColumns"> |
| | |
| | | <if test="laboratoryName != null and laboratoryName != ''"> |
| | | and ss.name like #{laboratoryName} |
| | | </if> |
| | | <if test="project != null and project != ''"> |
| | | and su.project like concat("%",#{project},"%") |
| | | </if> |
| | | <if test="controllerName != null and controllerName != ''"> |
| | | and sc.controller_name like concat("%",#{controllerName},"%") |
| | | </if> |
| | | order by ss.name ASC,sc.controller_name,su.container_code,su.name |
| | | <if test="first != null and pageSize != null"> |
| | | limit #{first}, #{pageSize} |
| | |
| | | <if test="editId != null and editId != ''"> |
| | | and su.id != #{editId} |
| | | </if> |
| | | <if test="project != null and project != ''"> |
| | | and su.project like concat("%",#{project},"%") |
| | | </if> |
| | | <if test="controllerName != null and controllerName != ''"> |
| | | and sc.controller_name like concat("%",#{controllerName},"%") |
| | | </if> |
| | | </select> |
| | | |
| | | <insert id="insertSysLaboratoryContainer" parameterType="com.nanometer.smartlab.entity.SysLaboratoryContainer"> |
| | |
| | | <if test="waster != null"> |
| | | and su.waster = #{waster} |
| | | </if> |
| | | <if test="project != null and project != ''"> |
| | | and su.project like concat("%",#{project},"%") |
| | | </if> |
| | | <if test="company != null and company != ''"> |
| | | and bm1.meta_value like concat("%",#{company},"%") |
| | | </if> |
| | | </sql> |
| | | |
| | | <select id="getSysUser" parameterType="java.lang.String" resultMap="SysUser" > |
| | |
| | | select su.*, br.name as roleName from sys_user as su |
| | | left join base_role as br on su.role_id = br.id |
| | | left join base_meta bm on su.department = bm.id |
| | | left join base_meta bm1 on bm1.id = su.company |
| | | where su.valid_flag = 1 |
| | | <if test="departmentNameLike != null and departmentNameLike != ''"> |
| | | and bm.meta_value like #{departmentNameLike} |
| | |
| | | </select> |
| | | |
| | | <select id="getSysUserTotalCount" parameterType="java.util.Map" resultType="int"> |
| | | select count(1) from sys_user as su left join base_meta bm on su.department = bm.id |
| | | select count(1) from sys_user as su |
| | | left join base_meta bm on su.department = bm.id |
| | | left join base_meta bm1 on bm1.id = su.company |
| | | where su.valid_flag = 1 |
| | | <if test="departmentNameLike != null and departmentNameLike != ''"> |
| | | and bm.meta_value like #{departmentNameLike} |
| | |
| | | |
| | | int getOpeUseFlowTotalCount(String reagentId, String reagentCode, Integer status, String userId); |
| | | |
| | | List<OpeUseFlow> getOpeUseFlowListByName(String houseName,String reagentId, String reagentCode, Integer status, String userId, Date startDate,Date endDate, |
| | | List<OpeUseFlow> getOpeUseFlowListByName(String houseName,String reagentId, String reagentCode,String containerCode, Integer status, String userId, Date startDate,Date endDate, |
| | | Integer first, Integer pageSize); |
| | | |
| | | int getOpeUseFlowTotalCountByName(String houseName, String reagentId, String reagentCode, Integer status, String userId, Date startDate,Date endDate); |
| | | int getOpeUseFlowTotalCountByName(String houseName, String reagentId, String reagentCode,String containerCode, Integer status, String userId, Date startDate,Date endDate); |
| | | |
| | | boolean update(OpeUseFlow opeUseFlow); |
| | | |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<OpeUseFlow> getOpeUseFlowListByName(String houseName,String reagentId, String reagentCode, Integer status, String userId, |
| | | public List<OpeUseFlow> getOpeUseFlowListByName(String houseName,String reagentId, String reagentCode,String containerCode, Integer status, String userId, |
| | | Date startDate,Date endDate,Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | |
| | | |
| | | params.put("status", status); |
| | | params.put("houseName", houseName); |
| | | params.put("containerCode", containerCode); |
| | | addParamByUserId(userId, params); |
| | | |
| | | params.put("first", first); |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getOpeUseFlowTotalCountByName(String houseName,String reagentId, String reagentCode, Integer status, String userId,Date startDate,Date endDate) { |
| | | public int getOpeUseFlowTotalCountByName(String houseName,String reagentId, String reagentCode,String containerCode, Integer status, String userId,Date startDate,Date endDate) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("reagentName", reagentId); |
| | |
| | | } |
| | | |
| | | params.put("houseName", houseName); |
| | | params.put("containerCode", containerCode); |
| | | addParamByUserId(userId, params); |
| | | |
| | | params.put("status", status); |
| | |
| | | Integer pageSize); |
| | | int getOpeWarehouseReserveTotalCount(String reagentId, String supplierId); |
| | | List<OpeWarehouseReserve> getOpeWarehouseReserveListByName(String reagentId, String supplierId, Integer first, |
| | | Integer pageSize,String productSn); |
| | | int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn); |
| | | Integer pageSize,String productSn,String warehouseName); |
| | | int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn,String warehouseName); |
| | | OpeWarehouseReserve getOpeWarehouseReserve(String reagentId, String articleNumber); |
| | | OpeWarehouseReserve getOpeWarehouseReserve2(String reagentId, String articleNumber,String warehouseId); |
| | | |
| | |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<OpeWarehouseReserve> getOpeWarehouseReserveListByName(String reagentId, String supplierId, Integer first, |
| | | Integer pageSize,String productSn) { |
| | | Integer pageSize,String productSn,String warehouseName) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("reagentName", reagentId); |
| | |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | params.put("productSn", productSn); |
| | | params.put("warehouseName", warehouseName); |
| | | return this.opeWarehouseReserveDao.getOpeWarehouseReserveList(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn) { |
| | | public int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn,String warehouseName) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("reagentName", reagentId); |
| | | params.put("supplierId", supplierId); |
| | | params.put("productSn", productSn); |
| | | params.put("warehouseName", warehouseName); |
| | | return this.opeWarehouseReserveDao.getOpeWarehouseReserveTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | */ |
| | | public interface SysLaboratoryContainerService { |
| | | |
| | | List<SysLaboratoryContainer> getSysLaboratoryContainerList(String laboratoryType, String laboratoryName, String laboratoryId, Integer first, Integer pageSize); |
| | | List<SysLaboratoryContainer> getSysLaboratoryContainerList(String laboratoryType, String laboratoryName, String laboratoryId |
| | | ,String project,String controllerName, Integer first, Integer pageSize); |
| | | List<SysLaboratoryContainer> getSysLaboratoryContainerList(String laboratoryId); |
| | | int getSysLaboratoryContainerTotalCount(String laboratoryType, String laboratoryName,String laboratoryId); |
| | | int getSysLaboratoryContainerTotalCount(String laboratoryType, String laboratoryName,String laboratoryId,String project,String controllerName); |
| | | SysLaboratoryContainer getSysLaboratoryContainer(String id); |
| | | SysLaboratoryContainer getSysLaboratoryContainerByContainerCode(String containerCode); |
| | | SysLaboratoryContainer insertSysLaboratoryContainer(SysLaboratoryContainer sysLaboratory); |
| | |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<SysLaboratoryContainer> getSysLaboratoryContainerList(String laboratoryType, String laboratoryName, |
| | | String laboratoryId, Integer first, Integer pageSize) { |
| | | String laboratoryId,String project,String controllerName, Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(laboratoryType)) { |
| | |
| | | if (StringUtils.isNotBlank(laboratoryId)) { |
| | | params.put("laboratoryId", laboratoryId); |
| | | } |
| | | params.put("project", project); |
| | | params.put("controllerName", controllerName); |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | return this.sysLaboratoryContainerDao.getSysLaboratoryContainerList(params); |
| | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<SysLaboratoryContainer> getSysLaboratoryContainerList( |
| | | String laboratoryId) { |
| | | return getSysLaboratoryContainerList(null,null,laboratoryId,null,null); |
| | | return getSysLaboratoryContainerList(null,null,laboratoryId,null,null,null,null); |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getSysLaboratoryContainerTotalCount(String laboratoryType, String laboratoryName, String laboratoryId) { |
| | | public int getSysLaboratoryContainerTotalCount(String laboratoryType, String laboratoryName, String laboratoryId,String project,String controllerName) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(laboratoryType)) { |
| | |
| | | if (StringUtils.isNotBlank(laboratoryId)) { |
| | | params.put("laboratoryId", laboratoryId); |
| | | } |
| | | params.put("project", project); |
| | | params.put("controllerName", controllerName); |
| | | return this.sysLaboratoryContainerDao.getSysLaboratoryContainerTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | */ |
| | | public interface SysLaboratoryService { |
| | | |
| | | List<SysLaboratory> getSysLaboratoryList(String type, String name, Integer first, Integer pageSize); |
| | | List<SysLaboratory> getSysLaboratoryList(String type, String name, String project, Integer first, Integer pageSize); |
| | | |
| | | List<SysLaboratory> getAllSysLaboratoryList(); |
| | | |
| | | List<SysLaboratory> getSysLaboratoryListByDep(String depId); |
| | | |
| | | int getSysLaboratoryTotalCount(String type, String name); |
| | | int getSysLaboratoryTotalCount(String type, String name,String project); |
| | | |
| | | boolean isSysLaboratoryExist(String barCode, String editId); |
| | | |
| | |
| | | SysUserDao sysUserDao; |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<SysLaboratory> getSysLaboratoryList(String type, String name, Integer first, Integer pageSize) { |
| | | public List<SysLaboratory> getSysLaboratoryList(String type, String name,String project,Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(type)) { |
| | |
| | | if (StringUtils.isNotBlank(name)) { |
| | | params.put("name", "%" + name + "%"); |
| | | } |
| | | params.put("project", project); |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | return this.sysLaboratoryDao.getSysLaboratoryList(params); |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getSysLaboratoryTotalCount(String type, String name) { |
| | | public int getSysLaboratoryTotalCount(String type, String name,String project) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(type)) { |
| | |
| | | if (StringUtils.isNotBlank(name)) { |
| | | params.put("name", "%" + name + "%"); |
| | | } |
| | | params.put("project", project); |
| | | return this.sysLaboratoryDao.getSysLaboratoryTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | @Transactional |
| | | public void importProject(FileUploadEvent event,SysUser currentUser) throws Exception { |
| | | |
| | | List<SysUser> userList = sysUserService.getSysUserList(null, null, null, null, null); |
| | | List<SysUser> userList = sysUserService.getSysUserList(null, null, null, null, null,null,null); |
| | | List<SysProject> sysProjectList = sysProjectDao.getSysProjectList(new HashMap()); |
| | | Map<String,String> userMap = new HashMap(); |
| | | Map<String,String> projectMap = new HashMap(); |
| | |
| | | */ |
| | | public interface SysUserService { |
| | | |
| | | List<SysUser> getSysUserList(String arp, String name,String departmentName, Integer first, Integer pageSize); |
| | | int getSysUserTotalCount(String arp, String name,String departmentName); |
| | | List<SysUser> getSysUserList(String arp, String name,String departmentName,String project,String company,Integer first, Integer pageSize); |
| | | int getSysUserTotalCount(String arp, String name,String departmentName,String project,String company); |
| | | SysUser getSysUser(String id); |
| | | SysUser getSysUserForSuppllier(String id); |
| | | SysUser getSysUserByAccount(String account); |
| | |
| | | SysUserDao sysUserDao; |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<SysUser> getSysUserList(String arp, String name,String departmentName, Integer first, Integer pageSize) { |
| | | public List<SysUser> getSysUserList(String arp, String name,String departmentName,String project,String company, Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(arp)) { |
| | |
| | | if (StringUtils.isNotBlank(departmentName)) { |
| | | params.put("departmentNameLike", "%" + departmentName + "%"); |
| | | } |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | return this.sysUserDao.getSysUserList(params); |
| | |
| | | } |
| | | } |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getSysUserTotalCount(String arp, String name,String departmentName) { |
| | | public int getSysUserTotalCount(String arp, String name,String departmentName,String project,String company) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(arp)) { |
| | |
| | | if (StringUtils.isNotBlank(departmentName)) { |
| | | params.put("departmentNameLike", "%" + departmentName + "%"); |
| | | } |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | return this.sysUserDao.getSysUserTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | <h:form id="laboratoryContainerMngForm"> |
| | | <p:panel styleClass="center-header"> |
| | | <p:outputLabel styleClass="title" value="实验室临时存储库管理"></p:outputLabel> |
| | | <p:panelGrid styleClass="filter" columns="5"> |
| | | <p:panelGrid styleClass="filter" columns="9"> |
| | | <p:outputLabel value="实验室类型:"></p:outputLabel> |
| | | <p:selectOneMenu value="#{laboratoryContainerMngController.laboratoryType}"> |
| | | <f:selectItem itemLabel="全部" itemValue="#{null}" noSelectionOption="true"></f:selectItem> |
| | |
| | | <p:outputLabel value="实验室名:"></p:outputLabel> |
| | | <p:inputText value="#{laboratoryContainerMngController.laboratoryName}"></p:inputText> |
| | | |
| | | <p:outputLabel value="课题名称:"></p:outputLabel> |
| | | <p:inputText value="#{laboratoryContainerMngController.project}"></p:inputText> |
| | | |
| | | <p:outputLabel value="主控名称:"></p:outputLabel> |
| | | <p:inputText value="#{laboratoryContainerMngController.controllerName}"></p:inputText> |
| | | |
| | | <p:commandLink styleClass="search" process="@form" update="@form"></p:commandLink> |
| | | </p:panelGrid> |
| | | </p:panel> |
| | |
| | | <h:form id="laboratoryMngForm"> |
| | | <p:panel styleClass="center-header"> |
| | | <p:outputLabel styleClass="title" value="实验室管理"></p:outputLabel> |
| | | <p:panelGrid styleClass="filter" columns="5"> |
| | | <p:panelGrid styleClass="filter" columns="7"> |
| | | <p:outputLabel value="实验室类型:"></p:outputLabel> |
| | | <p:selectOneMenu value="#{laboratoryMngController.type}"> |
| | | <f:selectItem itemLabel="全部" itemValue="#{null}" noSelectionOption="true"></f:selectItem> |
| | |
| | | <p:outputLabel value="实验室名:"></p:outputLabel> |
| | | <p:inputText value="#{laboratoryMngController.name}"></p:inputText> |
| | | |
| | | <p:outputLabel value="课题组:"></p:outputLabel> |
| | | <p:inputText value="#{laboratoryMngController.project}"></p:inputText> |
| | | |
| | | <p:commandLink styleClass="search" process="@form" update="@form"></p:commandLink> |
| | | </p:panelGrid> |
| | | </p:panel> |
| | |
| | | <p:outputLabel styleClass="title" value="试剂流向追踪"></p:outputLabel> |
| | | |
| | | <p:panel styleClass="center-header"> |
| | | <p:panelGrid styleClass="filter" columns="11"> |
| | | <p:panelGrid styleClass="filter" columns="13"> |
| | | <p:outputLabel value="开始时间:"></p:outputLabel> |
| | | <p:calendar value="#{opeUseFlowInfoController.startDate}"></p:calendar> |
| | | |
| | |
| | | <p:outputLabel value="条形码:"></p:outputLabel> |
| | | <p:inputText value="#{opeUseFlowInfoController.reagentCode}"></p:inputText> |
| | | |
| | | <p:outputLabel value="柜号:"></p:outputLabel> |
| | | <p:inputText value="#{opeUseFlowInfoController.containerCode}"></p:inputText> |
| | | |
| | | <p:outputLabel value="场所名:"></p:outputLabel> |
| | | <p:inputText value="#{opeUseFlowInfoController.houseName}"></p:inputText> |
| | | <p:commandLink styleClass="search" process="@form" update="@form"></p:commandLink> |
| | |
| | | <p:panel styleClass="center-header"> |
| | | <p:outputLabel styleClass="title" value="用户管理"></p:outputLabel> |
| | | |
| | | <p:panelGrid styleClass="filter" columns="7"> |
| | | <p:panelGrid styleClass="filter" columns="11"> |
| | | <p:outputLabel value="ARP号:"></p:outputLabel> |
| | | <p:inputText value="#{userMngController.arp}"></p:inputText> |
| | | |
| | | <p:outputLabel value="姓名:"></p:outputLabel> |
| | | <p:inputText value="#{userMngController.name}"></p:inputText> |
| | | |
| | | <p:outputLabel value="课题组:"></p:outputLabel> |
| | | <p:inputText value="#{userMngController.project}"></p:inputText> |
| | | |
| | | <p:outputLabel value="部门:"></p:outputLabel> |
| | | <p:inputText value="#{userMngController.departmentName}"></p:inputText> |
| | | |
| | | <p:outputLabel value="单位:"></p:outputLabel> |
| | | <p:inputText value="#{userMngController.company}"></p:inputText> |
| | | |
| | | <p:commandLink styleClass="search" process="@form" update="@form"></p:commandLink> |
| | | </p:panelGrid> |
| | | </p:panel> |
| | |
| | | <br/> |
| | | <h:form id="warehouseStockMngForm"> |
| | | <p:panel styleClass="center-header"> |
| | | <p:panelGrid styleClass="filter" columns="7"> |
| | | <p:panelGrid styleClass="filter" columns="9"> |
| | | |
| | | <p:outputLabel value="试剂名称:"></p:outputLabel> |
| | | <p:inputText value="#{warehouseStockMngController.reagentId}"></p:inputText> |
| | |
| | | var="item" itemLabel="#{item.name}" itemValue="#{item.id}"></f:selectItems> |
| | | </p:selectOneMenu> |
| | | |
| | | <p:outputLabel value="仓库名:"></p:outputLabel> |
| | | <p:inputText value="#{warehouseStockMngController.warehouseName}"></p:inputText> |
| | | |
| | | <p:outputLabel value="产品编号:"></p:outputLabel> |
| | | <p:inputText value="#{warehouseStockMngController.productSn}"></p:inputText> |
| | | |