package com.ruoyi.web.controller.api; import cn.afterturn.easypoi.excel.ExcelExportUtil; import cn.afterturn.easypoi.excel.entity.ExportParams; import com.alibaba.fastjson2.JSONArray; import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.utils.WebUtils; import com.ruoyi.system.importExcel.TErpCloudGoodsExcel; import com.ruoyi.system.model.TSysCloudConfig; import com.ruoyi.system.service.TCrmClinicCloudWarehouseService; import com.ruoyi.system.service.TSysCloudConfigService; import com.ruoyi.web.controller.yuncang.api.basic.WarehouseQuery; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.apache.poi.ss.usermodel.Workbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.net.URLEncoder; import java.sql.Wrapper; import java.util.ArrayList; import java.util.List; import java.util.Objects; /** *

* 诊所仓库 前端控制器 *

* * @author xiaochen * @since 2026-02-03 */ @Api(tags = "诊所云仓仓库") @RestController @RequestMapping("/t-crm-clinic-cloud-warehouse") public class TCrmClinicCloudWarehouseController { private final TCrmClinicCloudWarehouseService tCrmClinicCloudWarehouseService; private final TSysCloudConfigService sysCloudConfigService; @Autowired public TCrmClinicCloudWarehouseController(TCrmClinicCloudWarehouseService tCrmClinicCloudWarehouseService, TSysCloudConfigService sysCloudConfigService) { this.tCrmClinicCloudWarehouseService = tCrmClinicCloudWarehouseService; this.sysCloudConfigService = sysCloudConfigService; } @ApiOperation(value = "查询云仓仓库列表",notes = "cloudWarehouse:云仓类型 1=旺店通") @GetMapping("/queryCloudWarehouseList") public R queryCloudWarehouseList(@RequestParam Integer cloudWarehouse) { // 查询云仓配置 TSysCloudConfig sysCloudConfig = sysCloudConfigService.getOne(Wrappers.lambdaQuery(TSysCloudConfig.class) .eq(TSysCloudConfig::getCloudWarehouse, cloudWarehouse) .last("LIMIT 1")); JSONObject jsonObject = WarehouseQuery.warehouseQuery(sysCloudConfig.getSid(), sysCloudConfig.getAppKey(), sysCloudConfig.getAppSecret(), sysCloudConfig.getUrl()); if (Objects.nonNull(jsonObject)){ JSONArray warehouses = jsonObject.getJSONArray("warehouses"); return R.ok(warehouses); } return R.ok(); } }