czt
2024-04-18 b23dea952d3964c66d8823ebd3f84cabbe978eae
增加统一编码管理页面及数据拉取
已添加7个文件
已修改1个文件
714 ■■■■■ 文件已修改
src/main/java/com/fzzy/api/dto/GbCodingData.java 22 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/dto/ReqGbCoding.java 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/dto/RespGbCoding.java 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/entity/GbUnifiedCoding.java 72 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/view/GbUnifiedCoding.view.xml 414 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/view/pr/GbUnifiedCodingPR.java 141 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/view/repository/GbUnifiedCodingRep.java 19 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/templates/home/home.html 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/fzzy/api/dto/GbCodingData.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
package com.fzzy.api.dto;
import com.fzzy.api.entity.GbUnifiedCoding;
import lombok.Data;
import java.io.Serializable;
import java.util.List;
/**
 * @Description ç»Ÿä¸€ç¼–码二层封装
 * @Author CZT
 * @Date 2024/4/18 14:23
 */
@Data
public class GbCodingData implements Serializable {
    public int total;
    /**
     * è¯´æ˜Ž
     */
    public List<GbUnifiedCoding> list;
}
src/main/java/com/fzzy/api/dto/ReqGbCoding.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
package com.fzzy.api.dto;
import lombok.Data;
import java.io.Serializable;
/**
 * @Description
 * @Author CZT
 * @Date 2024/4/18 14:55
 */
@Data
public class ReqGbCoding implements Serializable {
    public String dwdm;
    public ReqGbCoding() {
    }
    public ReqGbCoding(String dwdm) {
        this.dwdm = dwdm;
    }
}
src/main/java/com/fzzy/api/dto/RespGbCoding.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
package com.fzzy.api.dto;
import lombok.Data;
import java.io.Serializable;
/**
 * @Description ç»Ÿä¸€ç¼–码返回数据封装
 * @Author CZT
 * @Date 2024/4/18 14:19
 */
@Data
public class RespGbCoding<T> implements Serializable {
    public String code;
    public String msg;
    public T data;
}
src/main/java/com/fzzy/api/entity/GbUnifiedCoding.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,72 @@
package com.fzzy.api.entity;
import com.bstek.dorado.annotation.PropertyDef;
import lombok.Data;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;
/**
 * @Description ç»Ÿä¸€ç¼–码实体类
 * @Author CZT
 * @Date 2024/4/18 9:56
 */
@Data
@Entity
@Table(name = "GB_UNIFIED_CODING")
public class GbUnifiedCoding implements Serializable {
    @Id
    @PropertyDef(label = "廒间编码")
    @Column(name = "ajdm", length = 40)
    private String ajdm;
    @PropertyDef(label = "廒间名称")
    @Column(name = "ajmc", length = 100)
    private String ajmc;
    @PropertyDef(label = "单位名称")
    @Column(name = "dwmc", length = 200)
    private String dwmc;
    @PropertyDef(label = "单位编码")
    @Column(name = "frdwdm", length = 40)
    private String frdwdm;
    @PropertyDef(label = "企业性质")
    @Column(name = "qyxz", length = 10)
    private String qyxz;
    @PropertyDef(label = "库区名称")
    @Column(name = "kqmc", length = 100)
    private String kqmc;
    @PropertyDef(label = "库区编码")
    @Column(name = "kqdm", length = 40)
    private String kqdm;
    @PropertyDef(label = "仓房编码")
    @Column(name = "cfdm", length = 40)
    private String cfdm;
    @PropertyDef(label = "仓房名称")
    @Column(name = "cfmc", length = 100)
    private String cfmc;
    @PropertyDef(label = "创建时间")
    @Column(name = "createTime")
    private Date createTime;
    @PropertyDef(label = "上级单位名称")
    @Column(name = "sjDeptName", length = 200)
    private String sjDeptName;
    @PropertyDef(label = "更新时间")
    @Column(name = "updateTime")
    private Date updateTime;
}
src/main/java/com/fzzy/api/view/GbUnifiedCoding.view.xml
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,414 @@
<?xml version="1.0" encoding="UTF-8"?>
<ViewConfig>
  <Arguments/>
  <Context/>
  <Model>
    <DataType name="dtMain">
      <Property name="creationType">com.fzzy.api.entity.GbUnifiedCoding</Property>
      <PropertyDef name="ajdm">
        <Property></Property>
        <Property name="label">廒间编码</Property>
      </PropertyDef>
      <PropertyDef name="ajmc">
        <Property></Property>
        <Property name="label">廒间名称</Property>
      </PropertyDef>
      <PropertyDef name="dwmc">
        <Property></Property>
        <Property name="label">单位名称</Property>
      </PropertyDef>
      <PropertyDef name="frdwdm">
        <Property></Property>
        <Property name="label">单位编码</Property>
      </PropertyDef>
      <PropertyDef name="qyxz">
        <Property></Property>
        <Property name="label">企业性质</Property>
        <Property name="mapping">
          <Property name="keyProperty">code</Property>
          <Property name="valueProperty">name</Property>
          <Property name="mapValues">
            <Collection>
              <Entity>
                <Property name="code">10</Property>
                <Property name="name">10-中储粮直属企业(包括分库及控股企业)</Property>
              </Entity>
              <Entity>
                <Property name="code">20</Property>
                <Property name="name">20-其他中央企业(中粮、供销、中化等,不含租仓库点)</Property>
              </Entity>
              <Entity>
                <Property name="code">30</Property>
                <Property name="name">30-省属国有及国有控股企业</Property>
              </Entity>
              <Entity>
                <Property name="code">31</Property>
                <Property name="name">31-市属国有及国有控股企业</Property>
              </Entity>
              <Entity>
                <Property name="code">32</Property>
                <Property name="name">32-县级国有及国有控股企业</Property>
              </Entity>
              <Entity>
                <Property name="code">40</Property>
                <Property name="name">40-民营及其他非国有控股股份制企业</Property>
              </Entity>
              <Entity>
                <Property name="code">50</Property>
                <Property name="name">50-外资企业</Property>
              </Entity>
            </Collection>
          </Property>
        </Property>
      </PropertyDef>
      <PropertyDef name="kqmc">
        <Property></Property>
        <Property name="label">库区名称</Property>
      </PropertyDef>
      <PropertyDef name="kqdm">
        <Property></Property>
        <Property name="label">库区编码</Property>
      </PropertyDef>
      <PropertyDef name="cfdm">
        <Property></Property>
        <Property name="label">仓房编码</Property>
      </PropertyDef>
      <PropertyDef name="cfmc">
        <Property></Property>
        <Property name="label">仓房名称</Property>
      </PropertyDef>
      <PropertyDef name="createTime">
        <Property name="dataType">DateTime</Property>
        <Property name="label">创建时间</Property>
      </PropertyDef>
      <PropertyDef name="sjDeptName">
        <Property></Property>
        <Property name="label">上级单位名称</Property>
      </PropertyDef>
      <PropertyDef name="updateTime">
        <Property name="dataType">DateTime</Property>
        <Property name="label">更新时间</Property>
      </PropertyDef>
    </DataType>
    <DataType name="dtParam">
      <PropertyDef name="dwmc">
        <Property></Property>
        <Property name="label">单位名称</Property>
      </PropertyDef>
      <PropertyDef name="kqmc">
        <Property></Property>
        <Property name="label">库区名称</Property>
      </PropertyDef>
      <PropertyDef name="ajmc">
        <Property></Property>
        <Property name="label">廒间名称</Property>
      </PropertyDef>
    </DataType>
    <DataType name="dtParam2">
      <Property name="creationType">com.fzzy.api.data.ApiParam</Property>
      <PropertyDef name="dwdm">
        <Property></Property>
        <Property name="label">单位信息</Property>
        <Property name="required">true</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;api1101PR#listAll&quot;).getResult()}</Property>
          <Property name="keyProperty">dwdm</Property>
          <Property name="valueProperty">dwmc</Property>
        </Property>
      </PropertyDef>
    </DataType>
  </Model>
  <View layout="regionPadding:10">
    <Property name="packages">font-awesome,css-common</Property>
    <DataSet id="dsMain">
      <Property name="dataType">[dtMain]</Property>
      <Property name="dataProvider">gbUnifiedCodingPR#pageList</Property>
      <Property name="pageSize">20</Property>
    </DataSet>
    <DataSet id="dsQuery">
      <ClientEvent name="onReady">self.insert();</ClientEvent>
      <Property name="dataType">dtParam</Property>
    </DataSet>
    <DataSet id="dsQuery2">
      <ClientEvent name="onReady">self.insert();</ClientEvent>
      <Property name="dataType">dtParam2</Property>
    </DataSet>
    <AutoForm>
      <Property name="dataSet">dsQuery</Property>
      <Property name="cols">*,*,*,500px</Property>
      <Property name="labelAlign">right</Property>
      <Property name="labelSeparator">:</Property>
      <Property name="labelWidth">90</Property>
      <AutoFormElement>
        <Property name="name">dwmc</Property>
        <Property name="property">dwmc</Property>
        <Editor/>
      </AutoFormElement>
      <AutoFormElement>
        <Property name="name">kqmc</Property>
        <Property name="property">kqmc</Property>
        <Editor/>
      </AutoFormElement>
      <AutoFormElement>
        <Property name="name">ajmc</Property>
        <Property name="property">ajmc</Property>
        <Editor/>
      </AutoFormElement>
      <ToolBar>
        <ToolBarButton>
          <ClientEvent name="onClick">var query = view.get(&quot;#dsQuery&quot;).getData();&#xD;
view.get(&quot;#dsMain&quot;).set(&quot;parameter&quot;,query).flushAsync();</ClientEvent>
          <Property name="caption">查询</Property>
          <Property name="iconClass">fa fa-search</Property>
          <Property name="width">100</Property>
          <Property name="exClassName">toolbar-button-push</Property>
        </ToolBarButton>
        <ToolBarButton>
          <ClientEvent name="onClick">var cur = view.get(&quot;#dgMain&quot;).getCurrentItem();&#xD;
if(cur){&#xD;
    view.get(&quot;#dialogMain&quot;).show();&#xD;
}else{&#xD;
    $alert(&quot;请勾选想要查看的数据!&quot;);&#xD;
}&#xD;
</ClientEvent>
          <Property name="caption">详情</Property>
          <Property name="iconClass">fa fa-search</Property>
          <Property name="width">100</Property>
          <Property name="exClassName">toolbar-button</Property>
          <Property name="hideMode">display</Property>
          <Property name="visible">true</Property>
        </ToolBarButton>
        <ToolBarButton>
          <ClientEvent name="onClick">var cur = view.get(&quot;#dgMain&quot;).getCurrentItem();&#xD;
view.get(&quot;#ajaxDel&quot;).set(&quot;parameter&quot;,cur).execute(function(result){&#xD;
    if(result){&#xD;
        $alert(result);&#xD;
    } else{&#xD;
        cur.remove();&#xD;
    }&#xD;
});&#xD;
</ClientEvent>
          <Property name="caption">删除</Property>
          <Property name="iconClass">fa fa-minus</Property>
          <Property name="exClassName">toolbar-button-warn</Property>
          <Property name="width">100</Property>
          <Property name="visible">true</Property>
          <Property name="hideMode">display</Property>
        </ToolBarButton>
        <ToolBarButton>
          <ClientEvent name="onClick">view.get(&quot;#dialogPull&quot;).show();</ClientEvent>
          <Property name="caption">拉取统一编码</Property>
          <Property name="iconClass">fa fa-minus</Property>
          <Property name="exClassName">toolbar-button-warm</Property>
          <Property name="width">150</Property>
        </ToolBarButton>
      </ToolBar>
    </AutoForm>
    <DataGrid id="dgMain">
      <Property name="dataSet">dsMain</Property>
      <Property name="selectionMode">multiRows</Property>
      <Property name="readOnly">true</Property>
      <RowNumColumn/>
      <RowSelectorColumn>
        <Property name="caption">上传</Property>
      </RowSelectorColumn>
      <DataColumn>
        <Property name="property">ajdm</Property>
        <Property name="align">center</Property>
        <Property name="name">ajdm</Property>
        <Property name="width">240</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">ajmc</Property>
        <Property name="align">center</Property>
        <Property name="name">ajmc</Property>
        <Property name="width">100</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">cfdm</Property>
        <Property name="align">center</Property>
        <Property name="name">cfdm</Property>
        <Property name="width">220</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">cfmc</Property>
        <Property name="align">center</Property>
        <Property name="name">cfmc</Property>
        <Property name="width">100</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">kqdm</Property>
        <Property name="visible">true</Property>
        <Property name="align">center</Property>
        <Property name="name">kqdm</Property>
        <Property name="width">200</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">kqmc</Property>
        <Property name="name">kqmc</Property>
        <Property name="align">center</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">frdwdm</Property>
        <Property name="name">frdwdm</Property>
        <Property name="width">190</Property>
        <Property name="align">center</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">qyxz</Property>
        <Property name="name">qyxz</Property>
        <Property name="align">center</Property>
      </DataColumn>
      <DataColumn>
        <Property name="property">updateTime</Property>
        <Property name="name">updateTime</Property>
        <Property name="align">center</Property>
        <Property name="width">150</Property>
      </DataColumn>
    </DataGrid>
    <ToolBar layoutConstraint="bottom">
      <Fill/>
      <DataPilot>
        <Property name="itemCodes">pageSize,pages</Property>
        <Property name="dataSet">dsMain</Property>
      </DataPilot>
    </ToolBar>
    <Dialog id="dialogMain">
      <Property name="width">1000</Property>
      <Property name="caption">详细信息</Property>
      <Property name="iconClass">fa fa-sliders</Property>
      <Property name="closeable">false</Property>
      <Property name="height">90%</Property>
      <Buttons>
        <Button>
          <ClientEvent name="onClick">var cur = view.get(&quot;#dgMain&quot;).getCurrentItem();&#xD;
self.get(&quot;parent&quot;).hide();&#xD;
if(cur) cur.cancel();</ClientEvent>
          <Property name="caption">关闭</Property>
          <Property name="iconClass">fa fa-times</Property>
          <Property name="exClassName">toolbar-button-warn</Property>
        </Button>
      </Buttons>
      <Children>
        <AutoForm>
          <Property name="dataSet">dsMain</Property>
          <Property name="cols">*,*</Property>
          <Property name="labelWidth">100</Property>
          <Property name="labelAlign">left</Property>
          <Property name="labelSeparator">:</Property>
          <Property name="labelPosition">top</Property>
          <AutoFormElement>
            <Property name="name">ajdm</Property>
            <Property name="property">ajdm</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">ajmc</Property>
            <Property name="property">ajmc</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">cfdm</Property>
            <Property name="property">cfdm</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">cfmc</Property>
            <Property name="property">cfmc</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">kqdm</Property>
            <Property name="property">kqdm</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">kqmc</Property>
            <Property name="property">kqmc</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">frdwdm</Property>
            <Property name="property">frdwdm</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">dwmc</Property>
            <Property name="property">dwmc</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">qyxz</Property>
            <Property name="property">qyxz</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">sjDeptName</Property>
            <Property name="property">sjDeptName</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">createTime</Property>
            <Property name="property">createTime</Property>
            <Editor/>
          </AutoFormElement>
          <AutoFormElement>
            <Property name="name">updateTime</Property>
            <Property name="property">updateTime</Property>
            <Editor/>
          </AutoFormElement>
        </AutoForm>
      </Children>
      <Tools/>
    </Dialog>
    <Dialog id="dialogPull">
      <Property name="width">600</Property>
      <Property name="caption">统一编码数据拉取</Property>
      <Buttons>
        <Button>
          <ClientEvent name="onClick">var data = view.get(&quot;#dsQuery2.data&quot;);&#xD;
&#xD;
if (data.validate() != 'ok') {&#xD;
    $alert(&quot;请填写完成参数&quot;);&#xD;
    return;&#xD;
}&#xD;
&#xD;
var dwdm = data.get(&quot;dwdm&quot;);&#xD;
&#xD;
view.get(&quot;#ajaxPullData&quot;).set(&quot;parameter&quot;,dwdm).execute(function(result){&#xD;
    view.get(&quot;#dialogPull&quot;).hide();&#xD;
    $alert(result);&#xD;
});</ClientEvent>
          <Property name="caption">确认执行</Property>
          <Property name="iconClass">fa fa-check</Property>
          <Property name="exClassName">toolbar-button</Property>
        </Button>
        <Button>
          <ClientEvent name="onClick">self.get(&quot;parent&quot;).hide();</ClientEvent>
          <Property name="caption">取消关闭</Property>
          <Property name="iconClass">fa fa-times</Property>
          <Property name="exClassName">toolbar-button-warn</Property>
        </Button>
      </Buttons>
      <Children>
        <AutoForm>
          <Property name="dataSet">dsQuery2</Property>
          <Property name="cols">*</Property>
          <AutoFormElement layoutConstraint="colSpan:2">
            <Property name="name">dwdm</Property>
            <Property name="property">dwdm</Property>
            <Editor/>
          </AutoFormElement>
        </AutoForm>
      </Children>
      <Tools/>
    </Dialog>
    <AjaxAction id="ajaxDel">
      <Property name="service">gbUnifiedCodingPR#delData</Property>
      <Property name="confirmMessage">当前数据删除后无法恢复,请确认要删除么?</Property>
    </AjaxAction>
    <AjaxAction id="ajaxPullData">
      <Property name="service">gbUnifiedCodingPR#pullData</Property>
    </AjaxAction>
  </View>
</ViewConfig>
src/main/java/com/fzzy/api/view/pr/GbUnifiedCodingPR.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,141 @@
package com.fzzy.api.view.pr;
import com.alibaba.fastjson.JSONObject;
import com.bstek.dorado.annotation.DataProvider;
import com.bstek.dorado.annotation.Expose;
import com.bstek.dorado.data.provider.Page;
import com.fzzy.api.dto.GbCodingData;
import com.fzzy.api.dto.ReqGbCoding;
import com.fzzy.api.dto.RespGbCoding;
import com.fzzy.api.entity.GbUnifiedCoding;
import com.fzzy.api.view.repository.GbUnifiedCodingRep;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Component;
import org.springframework.web.client.RestTemplate;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
/**
 * @Description ç»Ÿä¸€ç¼–码数据管理
 * @Author CZT
 * @Date 2024/4/18 10:28
 */
@Slf4j
@Component
public class GbUnifiedCodingPR {
    private static final String GB_CODING_URL = "http://121.36.17.6:28088/admin-api/coding/fmxx/queryDataInfo";
    @Autowired
    private GbUnifiedCodingRep codingRep;
    @Autowired
    private RestTemplate restTemplate;
    /**
     * gbUnifiedCodingPR#pageList
     *
     * @return
     */
    @SuppressWarnings("serial")
    @DataProvider
    public void pageList(Page<GbUnifiedCoding> page, Map<String, Object> param) {
        //多参数分页查询
        Pageable pageable = PageRequest.of(page.getPageNo() - 1, page.getPageSize(), Sort.Direction.DESC, "updateTime");
        if (null == param) {
            org.springframework.data.domain.Page<GbUnifiedCoding> japPage = codingRep.findAll(pageable);
            page.setEntityCount((int) japPage.getTotalElements());
            page.setEntities(japPage.getContent());
            return;
        }
        Specification<GbUnifiedCoding> specification = new Specification<GbUnifiedCoding>() {
            public Predicate toPredicate(Root<GbUnifiedCoding> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
                List<Predicate> predicates = new ArrayList<Predicate>(); //所有的断言
                String str = (String) param.get("ajmc");
                if (StringUtils.isNotBlank(str)) {
                    Predicate predicate1 = cb.equal(root.get("ajmc"), str);
                    predicates.add(predicate1);
                }
                str = (String) param.get("cfmc");
                if (StringUtils.isNotBlank(str)) {
                    Predicate predicate2 = cb.equal(root.get("cfmc"),str);
                    predicates.add(predicate2);
                }
                str = (String) param.get("kqmc");
                if (StringUtils.isNotBlank(str)) {
                    Predicate predicate3 = cb.equal(root.get("kqmc"),str);
                    predicates.add(predicate3);
                }
                return cb.and(predicates.toArray(new Predicate[0]));
            }
        };
        log.debug("---------分页参数查询----------{}", param.toString());
        org.springframework.data.domain.Page<GbUnifiedCoding> japPage = codingRep.findAll(specification, pageable);
        page.setEntityCount((int) japPage.getTotalElements());
        page.setEntities(japPage.getContent());
    }
    /**
     * gbUnifiedCodingPR#delData
     *
     * @param data
     */
    @Expose
    public String delData(GbUnifiedCoding data) {
        codingRep.deleteById(data.getAjdm());
        return null;
    }
    /**
     * gbUnifiedCodingPR#pullData
     * æ‹‰å–统一编码数据
     *
     * @param dwdm
     * @return
     */
    @Expose
    public String pullData(String dwdm) {
        if (StringUtils.isEmpty(dwdm)) {
            return "执行失败:单位编码为空,请核查!";
        }
        //设置参数
        ReqGbCoding reqGbCoding = new ReqGbCoding(dwdm);
        RespGbCoding respGbCoding = restTemplate.postForObject(GB_CODING_URL, reqGbCoding, RespGbCoding.class);
        if(null == respGbCoding){
            return "拉取数据失败,请重试!";
        }
        if(!"0".equals(respGbCoding.getCode())){
            return respGbCoding.getMsg();
        }
        GbCodingData data = JSONObject.parseObject(JSONObject.toJSONString(respGbCoding.getData()), GbCodingData.class);
        if(null == data || data.getList().isEmpty()){
            return "拉取数据为空,请重试!";
        }
        for (GbUnifiedCoding gbUnifiedCoding : data.getList()) {
            gbUnifiedCoding.setUpdateTime(new Date());
            gbUnifiedCoding.setQyxz(gbUnifiedCoding.getFrdwdm().substring(0, 2));
            codingRep.save(gbUnifiedCoding);
        }
        return "同步命令发送完成,请稍等刷新数据查看";
    }
}
src/main/java/com/fzzy/api/view/repository/GbUnifiedCodingRep.java
¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,19 @@
package com.fzzy.api.view.repository;
import com.fzzy.api.entity.GbUnifiedCoding;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.transaction.annotation.Transactional;
/**
 * @Description
 * @Author CZT
 * @Date 2024/4/18 10:30
 */
public interface GbUnifiedCodingRep extends JpaRepository<GbUnifiedCoding, String>, JpaSpecificationExecutor<GbUnifiedCoding> {
}
src/main/resources/templates/home/home.html
@@ -98,6 +98,9 @@
                            <dd>
                                <a lay-href="com.fzzy.sys.User.d">用户管理</a>
                            </dd>
                            <dd>
                                <a lay-href="com.fzzy.api.view.GbUnifiedCoding.d">统一编码管理</a>
                            </dd>
                        </dl>
                    </li>