|  |  |  | 
|---|
|  |  |  | jkKeys.setEditor(loginUserInfo.getId()); | 
|---|
|  |  |  | jkKeys.setIsdeleted(Constants.ZERO); | 
|---|
|  |  |  | jkKeys.setStatus(Constants.ZERO); | 
|---|
|  |  |  | jkKeys.setCarCode(cars.getCode()); | 
|---|
|  |  |  | jkKeysMapper.insert(jkKeys); | 
|---|
|  |  |  | return jkKeys.getId(); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | 
|---|
|  |  |  | LoginUserInfo loginUserInfo = jkKeys.getLoginUserInfo(); | 
|---|
|  |  |  | jkKeys.setEditDate(new Date()); | 
|---|
|  |  |  | jkKeys.setEditor(loginUserInfo.getId()); | 
|---|
|  |  |  | jkKeys.setCarCode(cars.getCode()); | 
|---|
|  |  |  | jkKeysMapper.updateById(jkKeys); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public List<JkKeys> findList(JkKeys jkKeys) { | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | jkKeys.setIsdeleted(Constants.ZERO); | 
|---|
|  |  |  | QueryWrapper<JkKeys> wrapper = new QueryWrapper<>(jkKeys); | 
|---|
|  |  |  | return jkKeysMapper.selectList(wrapper); | 
|---|
|  |  |  | return jkKeysMapper.selectList(new QueryWrapper<JkKeys>() | 
|---|
|  |  |  | .lambda().eq(JkKeys::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  |  | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | 
|---|
|  |  |  | JkKeys model = pageWrap.getModel(); | 
|---|
|  |  |  | MPJLambdaWrapper<JkKeys> wrapper = new MPJLambdaWrapper<JkKeys>() | 
|---|
|  |  |  | .selectAll(JkKeys.class) | 
|---|
|  |  |  | .selectAs(JkCabinetGrid::getCode,JkKeys::getGridCode) | 
|---|
|  |  |  | .selectAs(JkCabinet::getName,JkKeys::getCabinetName) | 
|---|
|  |  |  | .select("j.code",JkKeys::getGridCode) | 
|---|
|  |  |  | .select("j1.name",JkKeys::getCabinetName) | 
|---|
|  |  |  | .leftJoin(Cars.class,Cars::getId,JkKeys::getCarId) | 
|---|
|  |  |  | .leftJoin(JkCabinetGrid.class,JkCabinetGrid::getKeyId,JkKeys::getId) | 
|---|
|  |  |  | .leftJoin(JkCabinet.class,JkCabinet::getId,JkCabinetGrid::getCabinetId) | 
|---|
|  |  |  | .leftJoin(" jk_cabinet_grid j on j.key_id = t.id and j.isdeleted = 0  ") | 
|---|
|  |  |  | .leftJoin(" jk_cabinet j1 on j.CABINET_ID = j1.id ") | 
|---|
|  |  |  | .eq(JkKeys::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | //                .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .like(StringUtils.isNotBlank(model.getCode()),JkKeys::getCode,model.getCode()) | 
|---|
|  |  |  | .like(StringUtils.isNotBlank(model.getCarCode()),JkKeys::getCarCode,model.getCode()); | 
|---|
|  |  |  | IPage<JkKeys> iPage = jkKeysMapper.selectJoinPage(page,JkKeys.class,wrapper); | 
|---|