Merge remote-tracking branch 'origin/master'
| | |
| | | .selectAs(SystemUser::getMobile,UserRel::getUserPhone) |
| | | .selectAs(SystemUser::getOpenid,UserRel::getOpenid) |
| | | .leftJoin(SystemUser.class,SystemUser::getId,UserRel::getUserId) |
| | | .eq(UserRel::getObjType, MeetConstants.ONE) |
| | | // .eq(UserRel::getObjType, MeetConstants.ONE) |
| | | .eq(UserRel::getObjId, bookings.getId()) |
| | | .eq(UserRel::getIsdeleted, MeetConstants.ZERO) |
| | | .isNotNull(SystemUser::getOpenid) |
| | |
| | | .eq(SystemUser::getDeleted,Constants.ZERO) |
| | | .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
| | | .leftJoin(Member.class,Member::getId,SystemUser::getMemberId) |
| | | .leftJoin(" position p on p.id = t2.POSITION_ID ") |
| | | .and(StringUtils.isNotBlank(systemUser.getUsername()),ms->ms.like(SystemUser::getUsername,systemUser.getUsername()) |
| | | .or().like(SystemUser::getMobile,systemUser.getUsername()) |
| | | .or().like(SystemUser::getRealname,systemUser.getUsername())) |
| | |
| | | .like(StringUtils.isNotBlank(systemUser.getUsername()),SystemUser::getUsername,systemUser.getUsername()) |
| | | .like(StringUtils.isNotBlank(systemUser.getCompanyName()),Company::getName,systemUser.getCompanyName()) |
| | | .apply(StringUtils.isNotBlank(systemUser.getCompanySpecialId())," find_in_set('"+systemUser.getCompanySpecialId()+"',REPLACE(t1.company_path,'/',','))") |
| | | .orderByAsc( Company::getPinyin ) |
| | | .orderByAsc( Company::getSortnum ) |
| | | .orderByAsc( " p.SORTNUM " ) |
| | | .orderByAsc(SystemUser::getPinyin) |
| | | ; |
| | | List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, wrapper); |
| | |
| | | MPJLambdaWrapper<SystemUser> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(SystemUser.class); |
| | | queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId); |
| | | queryWrapper.eq(Company::getType,Constants.ONE); |
| | | queryWrapper.orderByAsc(SystemUser::getPinyin); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
| | | .leftJoin(" position p on p.id = t2.POSITION_ID "); |
| | | queryWrapper.eq(Company::getType,Constants.ONE) |
| | | .orderByAsc( Company::getSortnum ) |
| | | .orderByAsc( " p.SORTNUM " ) |
| | | .orderByAsc(SystemUser::getPinyin); |
| | | List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, queryWrapper); |
| | | return result; |
| | | } |
| | |
| | | String jsc = "jsc";//物业后勤 |
| | | String kqgzt = "attendance_workstand";//考勤管理 |
| | | String kqdbcl = "process_apply";//考勤代办处理 |
| | | String xfzx = "010200"; //消费中心 |
| | | String stxf = "010320"; //食堂 |
| | | String hqzx = "002656"; //后勤中心 |
| | | } |
| | | |
| | | /** |
| | |
| | | componentId = HKConstants.MenuPageId.componentIds[1]; |
| | | menuId = HKConstants.MenuPageId.kqdbcl; |
| | | }else if(Constants.equalsInteger(type,Constants.SIX)){ |
| | | //https://10.50.250.253:443/xauthplus-plugin/thirdLogin?type=third&componentId=cems&componentMenuId=010200 |
| | | return "https://10.50.250.253:443/xauthplus-plugin/thirdLogin?type=third&service=https://10.50.250.253:443/cems/config/generalCard&token="+token; |
| | | // componentId = HKConstants.MenuPageId.componentIds[2]; |
| | | // menuId = HKConstants.MenuPageId.xfzx; |
| | | componentId = HKConstants.MenuPageId.componentIds[2]; |
| | | menuId = HKConstants.MenuPageId.stxf; |
| | | // return "https://10.50.250.253:443/xauthplus-plugin/thirdLogin?type=third&service=https://10.50.250.253:443/cems/config/generalCard&token="+token; |
| | | }else if(Constants.equalsInteger(type,7)){ |
| | | menuId = HKConstants.MenuPageId.hqzx; |
| | | componentId = ""; |
| | | // return "https://10.50.250.253:443/portal/ui/index?menuId=002656&token="+token; |
| | | } |
| | | log.info("【海康获取工作台菜单免密登陆调整地址】================开始====menuId:"+menuId+"==token:"+token); |
| | | try { |
| | |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,Constants.ZERO); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"c.name",pageWrap.getModel().getParentName()); |
| | | queryWrapper.orderByAsc(Company::getPinyin); |
| | | queryWrapper.orderByAsc(Company::getSortnum); |
| | | IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); |
| | | return PageData.from(companyIPage); |
| | | } |
| | |
| | | |
| | | wrapper.eq(Company::getIsdeleted,Constants.ZERO) |
| | | .eq(Constants.equalsInteger(type,Constants.ONE),Company::getType,type) |
| | | .orderByAsc(Company::getPinyin); |
| | | .orderByAsc(Company::getSortnum); |
| | | List<Company> companies = companyMapper.selectList(wrapper); |
| | | return getCompanyTree( companies, null); |
| | | } |
| | |
| | | // .eq(Member::getStatus,Constants.Status.ENABLE.getValue()) |
| | | // .eq(Member::getType,Constants.memberType.internal) |
| | | .eq(pageWrap.getModel().getHkStatus()!=null,Member::getHkStatus,pageWrap.getModel().getHkStatus()) |
| | | .orderByAsc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getPinyin) |
| | | .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getEditDate); |
| | | |
| | | .orderByAsc(Company::getSortnum) |
| | | .orderByAsc(Position::getSortnum); |
| | | // .orderByAsc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getPinyin) |
| | | // .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getEditDate); |
| | | if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){ |
| | | queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId()); |
| | | }else{ |
| | |
| | | .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Member::getStatus,pageWrap.getModel().getStatus()) |
| | | .eq(Member::getType,Constants.memberType.visitor) |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .orderByAsc(Member::getPinyin); |
| | | .orderByAsc(Company::getSortnum) |
| | | .orderByAsc(Position::getSortnum); |
| | | |
| | | |
| | | if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){ |
| | | queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId()); |
| | | }else{ |