|  |  | 
 |  |  |                         .selectAs(SystemUser::getMobile,YwDeviceRecord::getMobile) | 
 |  |  |                         .selectAs(Company::getName,YwDeviceRecord::getCompanyName) | 
 |  |  |                         .selectAs(YwDevice::getName,YwDeviceRecord::getDeviceName) | 
 |  |  |                         .selectAs(YwDevice::getCode,YwDeviceRecord::getDeviceCode) | 
 |  |  |                         .leftJoin(SystemUser.class,SystemUser::getId,YwDeviceRecord::getUserId) | 
 |  |  |                         .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) | 
 |  |  |                         .leftJoin(YwDevice.class,YwDevice::getId,YwDeviceRecord::getDeviceId) | 
 |  |  | 
 |  |  |                         .last(" limit  1 ") | 
 |  |  |         ); | 
 |  |  |         List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() | 
 |  |  |                 .eq(Multifile::getObjId,id).eq(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_RECORD_FILE)); | 
 |  |  |                 .eq(Multifile::getObjId,id).eq(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_RECORD_FILE.getKey())); | 
 |  |  |         if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifiles)) { | 
 |  |  |             String path = systemDictDataBiz.queryByCode(Constants.FTP, Constants.FTP_RESOURCE_PATH).getCode() | 
 |  |  |                     + systemDictDataBiz.queryByCode(Constants.FTP, Constants.YW_DEVICE).getCode(); |