| | |
| | | //查询所有的权限 |
| | | public Response getAllPermit() { |
| | | List<Category> list=mapper.getAllPermit(); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"权限信息"); |
| | | return new Response().setII(1,list.size()>0,list,"权限信息"); |
| | | } |
| | | } |
| | |
| | | wrapper.orderByAsc("id"); |
| | | List<DocDepart> list=mapper.selectList(wrapper); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"返回数据"); |
| | | } |
| | | } |
| | |
| | | wrapper.set("url",""); |
| | | wrapper.eq("face_id",faceId); |
| | | int bl=mapper.update(null,wrapper); |
| | | return new Response().setII(1,bl>0?true:false,bl,"删除返回"); |
| | | return new Response().setII(1,bl>0,bl,"删除返回"); |
| | | } |
| | | } |
| | |
| | | dlog.setOperationTypeStr(UserOperation.getNameByType(dlog.getOprateType())); |
| | | }); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"数据返回"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"数据返回"); |
| | | } |
| | | //操作对应关系 |
| | | public Response getOperate() { |
| | |
| | | wrapper.orderByAsc("id"); |
| | | List<DocDepart> list=mapper.selectList(wrapper); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"返回数据"); |
| | | } |
| | | } |
| | |
| | | PageHelper.startPage(pageCurr,pageSize); |
| | | List<DocUser> list=mapper.getAllUser(docUser); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list!=null?true:false,pageInfo,"数据返回"); |
| | | return new Response().setII(1,list!=null,pageInfo,"数据返回"); |
| | | } |
| | | //编辑所有用户信息 |
| | | public Response updateUser(MultipartFile file,DocUser docUser) { |
| | |
| | | wrapper.set("dload_flag",docUser.getDloadFlag()); |
| | | wrapper.eq("id",docUser.getId()); |
| | | int bl=mapper.update(null,wrapper); |
| | | return new Response().set(1,bl>0?true:false); |
| | | return new Response().set(1,bl>0); |
| | | } |
| | | //新添加用户信息 |
| | | public Response addUser(MultipartFile file,DocUser docUser) { |
| | |
| | | docUser.setFaceId(String.valueOf(faceId)); |
| | | docUser.setCreTime(new Date()); |
| | | int bl=mapper.insert(docUser); |
| | | return new Response().set(1,bl>0?true:false); |
| | | return new Response().set(1,bl>0); |
| | | } |
| | | |
| | | //检测是否存在重新上传的人脸 |
| | |
| | | UpdateWrapper wrapper=new UpdateWrapper(); |
| | | wrapper.eq("id",id); |
| | | int bl=mapper.delete(wrapper); |
| | | return new Response().setII(1,bl>0?true:false,bl,"删除返回"); |
| | | return new Response().setII(1,bl>0,bl,"删除返回"); |
| | | } |
| | | |
| | | public Response login(String name, String snId, HttpServletRequest request) { |
| | |
| | | wrapper.set("sn_id",RSAUtil.encrypt(newId,RSAUtil.getPublicKey())); |
| | | wrapper.eq("name",name); |
| | | int bl=mapper.update(null,wrapper); |
| | | return new Response().set(1,bl>0?true:false,"修改成功"); |
| | | return new Response().set(1,bl>0,"修改成功"); |
| | | }else { |
| | | return new Response().set(1,false,"修改失败"); |
| | | } |
| | |
| | | wrapper.eq("role_id",roleId); |
| | | wrapper.select("id","name"); |
| | | List<DocUser> list=mapper.selectList(wrapper); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,list,"返回数据"); |
| | | } |
| | | //查询所有用户(权限管理用) |
| | | public Response getAllDocUser() { |
| | | List<DocUser> list=mapper.getAllDocUser(); |
| | | return new Response().setII(1,list!=null?true:false,list,"数据返回"); |
| | | return new Response().setII(1,list!=null,list,"数据返回"); |
| | | } |
| | | } |
| | |
| | | //查询所有的权限组 |
| | | public Response getAllGroup() { |
| | | List list=mapper.getAllGroup(); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"权限组信息"); |
| | | return new Response().setII(1,list.size()>0,list,"权限组信息"); |
| | | } |
| | | //添加权限组 |
| | | public Response addGroup(String groupName) { |
| | |
| | | group.setGroupId(String.valueOf(groupIdMax+1)); |
| | | group.setGroupName(groupName); |
| | | int flag=mapper.insert(group); |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //删除权限组 |
| | | @Transactional |
| | |
| | | int flagU=userGroupMapper.delete(wrapper); |
| | | //删除权限组 |
| | | int flag=mapper.delete(wrapper); |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //编辑权限组名 |
| | | public Response updateGroup(String groupId,String groupName) { |
| | |
| | | wrapper.eq("group_id",groupId); |
| | | wrapper.set("group_name",groupName); |
| | | int flag=mapper.update(null,wrapper); |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //权限组下加用户 |
| | | @Transactional |
| | | public Response addUserToGroup(List<UserGroup> users) { |
| | | int flag=userGroupMapper.insertBatchSomeColumn(users); |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //权限组下移除用户 |
| | | @Transactional |
| | |
| | | wrapper.eq("group_id",userGroup.getGroupId()); |
| | | flag+=userGroupMapper.delete(wrapper); |
| | | } |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | |
| | | //(组合操作)权限组下加用户和移除用户 |
| | |
| | | @Transactional |
| | | public Response addPermitToGroup(List<PermitGroup> permits) { |
| | | int flag=permitGroupMapper.insertBatchSomeColumn(permits); |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //权限组下移除权限 |
| | | @Transactional |
| | |
| | | wrapper.eq("group_id",permitGroup.getGroupId()); |
| | | flag+=permitGroupMapper.delete(wrapper); |
| | | } |
| | | return new Response().set(1,flag>0?true:false,"返回"); |
| | | return new Response().set(1,flag>0,"返回"); |
| | | } |
| | | //(组合操作)权限组下加权限和移除权限 |
| | | @Transactional |
| | |
| | | List<Material> list=mapper.selectList(wrapper);*//* |
| | | List<Material> list=mapper.getAllMaterial(category,subCode,subName,subModel); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回所有的散装件"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"返回所有的散装件"); |
| | | }*/ |
| | | //查询所有的散装件信息不分页 |
| | | /*public Response getMaterialWithoutSub(String parentModel, String subName,int version) { |
| | | List<Material> list=mapper.getMaterialWithoutSub(parentModel,subName,version); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回子件没有添加过联系的散装件"); |
| | | return new Response().setII(1,list.size()>0,list,"返回子件没有添加过联系的散装件"); |
| | | }*/ |
| | | //删除散装件(将散装件标识为不可用) |
| | | /*public Response deleteMaterial(int id) { |
| | |
| | | wrapper.set("status",0); |
| | | wrapper.eq("id",id); |
| | | int bl=mapper.update(null,wrapper); |
| | | return new Response().setII(1,bl>0?true:false,bl,"将散装件标识为不可用"); |
| | | return new Response().setII(1,bl>0,bl,"将散装件标识为不可用"); |
| | | }*/ |
| | | |
| | | public List<Material> getList() { |
| | |
| | | PageHelper.startPage(pageCurr,pageSize); |
| | | List<Material> list=mapper.getMaterialLimit(subCode,subName,subModel); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"查询所有物料(分页,模糊查询)"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"查询所有物料(分页,模糊查询)"); |
| | | } |
| | | //建立关联时查询所有的物料(不分页) |
| | | public Response getAllMaterialNoLimit() { |
| | |
| | | wrapper.ne("status",0); |
| | | wrapper.orderByAsc("id"); |
| | | List<Material> list=mapper.selectList(wrapper); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"查询所有物料(不分页)"); |
| | | return new Response().setII(1,list.size()>0,list,"查询所有物料(不分页)"); |
| | | } |
| | | |
| | | public List<String> getListByCodeList(List<String> codeList) { |
| | |
| | | public Response getPermitsByUname() { |
| | | DocUser docUser= ActionUtil.getUser(); |
| | | List list=mapper.getPermitsByUname(docUser.getName()); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回"); |
| | | return new Response().setII(1,list.size()>0,list,"返回"); |
| | | } |
| | | } |
| | |
| | | wrapper.eq("sub_name",sname); |
| | | wrapper.orderByAsc("s_version"); |
| | | List list=mapper.selectList(wrapper); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,list,"返回数据"); |
| | | } |
| | | |
| | | /**指定版本的产品bom*/ |
| | |
| | | }); |
| | | } |
| | | } |
| | | return new Response().setII(1,list.size()>0?true:false,list,""); |
| | | return new Response().setII(1,list.size()>0,list,""); |
| | | }*/ |
| | | //历史产品信息查看(根据历史产品产品id和版本查询子件及其关联的物料信息) |
| | | public Response getBomHistoryAndMaterial(int productId, int version) { |
| | |
| | | } |
| | | } |
| | | } |
| | | return new Response().setIIII(1,list.size()>0?true:false,list,listsoft,files,"返回物料信息及关联物料"); |
| | | return new Response().setIIII(1,list.size()>0,list,listsoft,files,"返回物料信息及关联物料"); |
| | | } |
| | | //历史产品下载(产品id和版本<下载的版本>) |
| | | public void downloadProductHistory(HttpServletRequest req, HttpServletResponse resp, int productId, int version) { |
| | |
| | | PageHelper.startPage(pageCurr,pageSize); |
| | | List list=mapper.searchCadDrawer(productBom); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"数据返回"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"数据返回"); |
| | | } |
| | | /* //图纸文件下载 |
| | | public void downloadCadDrawer(HttpServletRequest req, HttpServletResponse resp, List<ProductBom> boms) { |
| | |
| | | wrapper.eq("sub_code",scode); |
| | | wrapper.last("limit 1"); |
| | | ProductBom productBom=mapper.selectOne(wrapper); |
| | | return new Response().setII(1,productBom!=null?true:false,productBom,"返回数据"); |
| | | return new Response().setII(1,productBom!=null,productBom,"返回数据"); |
| | | } |
| | | |
| | | /**获取产品的信息(不包含子料)*/ |
| | |
| | | } |
| | | List list=mapper.selectList(wrapper); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list!=null?true:false,pageInfo,"返回数据"); |
| | | return new Response().setII(1,list!=null,pageInfo,"返回数据"); |
| | | }*/ |
| | | //产品下载(产品id和版本) |
| | | public void downloadProduct(HttpServletRequest req, HttpServletResponse resp, int productId , int version) { |
| | |
| | | //查询所有产品中没有与指定散装件关联的子件 |
| | | public Response getAllSubWithOutMaterial(int materialId) { |
| | | List<ProductBom> list=mapper.getAllSubWithOutMaterial(materialId); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,list,"返回数据"); |
| | | } |
| | | //根据母料型号查询子件信息及有最新版本关联的散装件信息 |
| | | /*public Response getSubByMaterialProduct(String parentModel) { |
| | |
| | | } |
| | | ); |
| | | } |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,list,"返回数据"); |
| | | }*/ |
| | | //根据产品id查询子件及其关联的物料信息 |
| | | public Response getBomAndMaterial(int productId,int version) { |
| | | List<ProductBom> list=mapper.getBomAndMaterial(productId,version); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回物料信息及关联物料"); |
| | | return new Response().setII(1,list.size()>0,list,"返回物料信息及关联物料"); |
| | | } |
| | | |
| | | //将物料存放为一个bom为下载做准备 |
| | |
| | | wrapper.eq("custom_code",customCode); |
| | | wrapper.orderByDesc("create_time"); |
| | | List<ProductHistory> list=mapper.selectList(wrapper); |
| | | return new Response().setII(1,list.size()>0?true:false,list,"返回产品版信息"); |
| | | return new Response().setII(1,list.size()>0,list,"返回产品版信息"); |
| | | } |
| | | |
| | | /**新增追加的版本并将原先的版本的启用设置为未启用*/ |
| | |
| | | wrapper.set("enabled",0); |
| | | flag=mapper.update(null,wrapper); |
| | | } |
| | | return new Response().set(1,flag>0?true:false,"历史版本可用性设定"); |
| | | return new Response().set(1,flag>0,"历史版本可用性设定"); |
| | | } |
| | | } |
| | |
| | | wrapper.orderByAsc("id"); |
| | | List list=mapper.selectList(wrapper); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回产品信息"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"返回产品信息"); |
| | | } |
| | | |
| | | public Product getVersion(String parentCode, String customCode) { |
| | |
| | | wrapper.orderByAsc("id"); |
| | | List list=mapper.selectList(wrapper); |
| | | PageInfo pageInfo=new PageInfo(list); |
| | | return new Response().setII(1,list.size()>0?true:false,pageInfo,"返回数据"); |
| | | return new Response().setII(1,list.size()>0,pageInfo,"返回数据"); |
| | | } |
| | | //根据软件名称实现软件下载 |
| | | public void downLoadSoftware(HttpServletRequest req, HttpServletResponse resp, String softwareName) { |