1.sap请求日志记录

王佳豪

2021-06-25 eb3f8587aa7466fd6d2d3ca712d0f9baf4e27dcb

1.sap请求日志记录

 src/main/java/com/slcf/controller/ReportQueryController.java

@@ -1,30 +1,20 @@
package com.slcf.controller;

import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.slcf.pojo.*;
import com.slcf.service.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.slcf.pojo.UserBean;
import com.slcf.pojo.ViewInOutBean;
import com.slcf.pojo.ViewLocMapBean;
import com.slcf.pojo.ViewStayTimeBean;
import com.slcf.pojo.ViewStockUseBean;
import com.slcf.pojo.ViewWorkInBean;
import com.slcf.bean.LocDetailCondition;
import com.slcf.pojo.AdjDetailBean;
import com.slcf.pojo.PlcCommandBean;
import com.slcf.pojo.SysLogBean;
import com.slcf.service.LocDetailService;
import com.slcf.service.ReportQueryService;
import com.slcf.service.RoleService;
import com.slcf.service.SysLogService;
import com.slcf.util.AuthorityCode;

/**
@@ -44,6 +34,30 @@
    LocDetailService locDetailService;
    @Autowired
    RoleService roleService;
    @Autowired
    SapRequestLogService sapRequestLogService;

    @RequestMapping("/goViewSapRequestLog.action")
    public String goViewSapRequestLog(HttpServletRequest request){
        try {
            String rid = request.getSession().getAttribute("ROLEID").toString();
            String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid),
                    AuthorityCode.ViewStockUseCode);
            request.getSession().setAttribute("AUTHCODE",authCode);
            // æ’入日志
            UserBean user = (UserBean) request.getSession().getAttribute("USER");
            SysLogBean sysLog = new SysLogBean();
            sysLog.setLogin_no(user.getUser_account());
            sysLog.setMachine_ip(request.getRemoteAddr());
            sysLog.setForm_no("goViewStockUse.action");
            sysLog.setTts_keyname("访问:SAP请求日志");
            sysLog.setModi_user(user.getUser_account());
            sysLogService.insertSysLog(sysLog);
        }catch (Exception e) {
            System.out.println(e.getMessage());
        }
        return "sapRequestLog";
    }

    @RequestMapping("/goViewStockUse.action")
    public String goViewStockUsePage(HttpServletRequest request){

 src/main/java/com/slcf/controller/SapRequestLogController.java

New file
@@ -0,0 +1,46 @@
package com.slcf.controller;

import com.slcf.bean.WorkDetailLogCondition;
import com.slcf.bean.WorkMastLogCondition;
import com.slcf.pojo.SapRequestLogBean;
import com.slcf.pojo.SysLogBean;
import com.slcf.pojo.UserBean;
import com.slcf.pojo.WorkMastLogBean;
import com.slcf.service.RoleService;
import com.slcf.service.SapRequestLogService;
import com.slcf.service.SysLogService;
import com.slcf.service.WorkFileLogService;
import com.slcf.util.AuthorityCode;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
import java.util.Map;

/**
 * å·¥ä½œåŽ†å²æ¡£æŽ§åˆ¶å™¨å±‚
 * @author admin
 * @date 2018å¹´11月23日
 */
@Controller
@RequestMapping("/sap")
public class SapRequestLogController {

    @Autowired
    SapRequestLogService sapRequestLogService;


    /* æŸ¥è¯¢sap请求日志 */
    @ResponseBody
    @RequestMapping("/querySapLog.action")
    public List<SapRequestLogBean> querySapLog(){
        List<SapRequestLogBean> list = sapRequestLogService.querySapLog();
        return list;
    }
}

 src/main/java/com/slcf/dao/SapRequestLogDao.java

New file
@@ -0,0 +1,19 @@
package com.slcf.dao;

import com.slcf.pojo.SapRequestLogBean;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Repository
public interface SapRequestLogDao {

    // æŸ¥è¯¢sap请求日志
    public List<SapRequestLogBean> querySapLog();

    // æ–°å¢žsap请求日志
    public Integer addSapLog(@Param("matnr") String matnr, @Param("request") String request, @Param("response") String response, @Param("create_time") Date create_time, @Param("type") Integer type, @Param("remark") String remark);
}

 src/main/java/com/slcf/filter/UpdateThread.java

@@ -5,11 +5,16 @@
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.Date;

import javax.annotation.Resource;

import com.slcf.pojo.SapRequestLogBean;
import com.slcf.service.SapRequestLogService;
import net.sf.json.JSONString;
import org.activiti.engine.impl.transformer.IntegerToString;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RequestMapping;
@@ -40,6 +45,8 @@
//    WaitPakOutService waitPakOutService;
//    @Resource
//    private static WaitPakInServiceImpl waitPakInService;
    @Autowired
    SapRequestLogService sapRequestLogService;
    
    Logger logger=Logger.getLogger(UpdateThread.class);
    
@@ -66,9 +73,9 @@
        waitPakOutService = getWaitPakOutService();
        while(true) {
            try {
                updateWaitPakInData();
                sendPickPrintCmd();
                updateWaitPakOutData();
                updateWaitPakInData(); // å…¥åº“
                sendPickPrintCmd(); // æ‰“印
                updateWaitPakOutData(); // å‡ºåº“
//                updateWaitCheckData();
                Thread.sleep(5000);
            } catch (InterruptedException e) {
@@ -124,6 +131,14 @@
            if(sessionCookie==null || sessionCookie.length()<1)
            {
                logger.error("SAP ERROR-----调用上架完成接口，get请求获取cookie失败");
                // SAP INFO-----调用上架完成接口，日志记录
                SapRequestLogBean logInfo = new SapRequestLogBean();
                logInfo.setMatnr(waitPakIn.getMatnr());
                logInfo.setRequest("获取cookie失败,cookie值:" + sessionCookie);
                logInfo.setResponse("SAP ERROR-----调用上架完成接口，get请求获取cookie失败");
                logInfo.setCreate_time(new Date());
                logInfo.setType(2);
                sapRequestLogService.addSapLog(logInfo);
                return result;
            }
            String[] sessionId = sessionCookie.split(";");
@@ -133,6 +148,14 @@
//            token = map.get("x-csrf-token").toString();
        } catch (Exception e1) {
            logger.error("SAP ERROR-----调用上架完成接口1，get请求获取cookie失败。" + e1.getMessage());
            // SAP INFO-----调用上架完成接口，日志记录
            SapRequestLogBean logInfo = new SapRequestLogBean();
            logInfo.setMatnr(waitPakIn.getMatnr());
            logInfo.setRequest("获取cookie失败");
            logInfo.setResponse("SAP ERROR-----调用上架完成接口1，get请求获取cookie失败。" + e1.getMessage());
            logInfo.setCreate_time(new Date());
            logInfo.setType(2);
            sapRequestLogService.addSapLog(logInfo);
//            e1.printStackTrace();
        }finally {
            if(connection1!=null){
@@ -221,11 +244,29 @@
                        }catch(Exception em) {
                        }
                        if(zstatus.equals("s") || message.contains("已经完全提供")) {//上报SAP成功,转历史档
                            // SAP INFO-----调用上架完成接口，日志记录
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakIn.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setRemark("上架完成接口:" + message);
                            logInfo.setType(1);
                            sapRequestLogService.addSapLog(logInfo);
//                        if(zstatus.equals("s")) {
                            waitPakIn.setIo_status("Y");
                            waitPakInService.upWaitPakIn(waitPakIn);
                            waitPakInService.moveToLog(waitPakIn);
                        }else if(zstatus.equals("e")) {//上报SAP失败,更新io_status=X
                            // SAP INFO-----调用上架完成接口，日志记录
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakIn.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setRemark("上架完成接口:" + message);
                            logInfo.setType(2);
                            sapRequestLogService.addSapLog(logInfo);
                            waitPakIn.setIo_status("X");
                            waitPakIn.setMemo(message);
                            waitPakInService.upWaitPakIn(waitPakIn);
@@ -300,6 +341,14 @@
            if(sessionCookie==null || sessionCookie.length()<1)
            {
                logger.error("调用下架完成接口，get请求获取cookie失败");
                // SAP INFO-----调用上架完成接口，日志记录
                SapRequestLogBean logInfo = new SapRequestLogBean();
                logInfo.setMatnr(waitPakOut.getMatnr());
                logInfo.setRequest("获取cookie值失败,cookie：" + sessionCookie);
                logInfo.setResponse("调用出库完成接口，get请求获取cookie失败");
                logInfo.setCreate_time(new Date());
                logInfo.setType(2);
                sapRequestLogService.addSapLog(logInfo);
                return result;
            }
            String[] sessionId = sessionCookie.split(";");
@@ -310,6 +359,14 @@
//            token = map.get("x-csrf-token").toString();
        } catch (Exception e1) {
            logger.error("调用下架完成接口，get请求获取cookie失败" + e1.getMessage());
            // SAP INFO-----调用上架完成接口，日志记录
            SapRequestLogBean logInfo = new SapRequestLogBean();
            logInfo.setMatnr(waitPakOut.getMatnr());
            logInfo.setRequest("获取cookie失败");
            logInfo.setResponse("调用出库完成接口，get请求获取cookie失败");
            logInfo.setCreate_time(new Date());
            logInfo.setType(2);
            sapRequestLogService.addSapLog(logInfo);
//            e1.printStackTrace();
        }finally{
            if(connection1!=null){
@@ -411,11 +468,29 @@
                        }catch(Exception em) {
                        }
                        if(zstatus.equals("s") || message.contains("已经完全提供") || message.contains("已确认")) {
                            // SAP INFO-----调用下架完成接口，日志记录
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakOut.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setType(1);
                            logInfo.setRemark("出库完成接口:" + message);
                            sapRequestLogService.addSapLog(logInfo);
//                        if(zstatus.equals("s")) {//上报SAP成功,转历史档
                            waitPakOut.setIo_status("Y");
                            waitPakOutService.upWaitPakOut(waitPakOut,0);
                            waitPakOutService.moveToLog(waitPakOut);
                        }else if(zstatus.equals("e")) {//上报SAP失败,更新io_status=X
                            // SAP INFO-----调用下架完成接口，日志记录
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakOut.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setType(2);
                            logInfo.setRemark("出库完成接口:" + message);
                            sapRequestLogService.addSapLog(logInfo);
                            waitPakOut.setIo_status("X");
                            waitPakOut.setMemo(message);
                            waitPakOutService.upWaitPakOut(waitPakOut,0);
@@ -491,6 +566,14 @@
            if(sessionCookie==null || sessionCookie.length()<1)
            {
                logger.error("调用打印接口，get请求获取cookie失败");
                // è°ƒç”¨sap打印接口,记录日志
                SapRequestLogBean logInfo = new SapRequestLogBean();
                logInfo.setMatnr(waitPakOut.getMatnr());
                logInfo.setRequest("调用打印接口，get请求获取cookie失败");
                logInfo.setResponse(sessionCookie);
                logInfo.setCreate_time(new Date());
                logInfo.setType(2);
                sapRequestLogService.addSapLog(logInfo);
                return result;
            }
            String[] sessionId = sessionCookie.split(";");
@@ -500,6 +583,14 @@
//            token = map.get("x-csrf-token").toString();
        } catch (Exception e1) {
            logger.error("sendPrinCommand1-----调用打印接口请求cookie失败" + waitPakOut.getMaktx() + e1.getMessage());
            // è°ƒç”¨sap打印接口,记录日志
            SapRequestLogBean logInfo = new SapRequestLogBean();
            logInfo.setMatnr(waitPakOut.getMatnr());
            logInfo.setRequest("sendPrinCommand1-----调用打印接口请求cookie失败"  + waitPakOut.getMaktx());
            logInfo.setResponse(e1.getMessage());
            logInfo.setCreate_time(new Date());
            logInfo.setType(2);
            sapRequestLogService.addSapLog(logInfo);
            e1.printStackTrace();
        }finally{
            if(connection1!=null){
@@ -600,11 +691,29 @@
                            waitPakOutService.upWaitPakOut(waitPakOut,0);
                            logger.error("sendPrinCommand5---调用打印接口成功，请求json数据--" + jsObj.toString());
                            logger.info("sendPrinCommand5---调用打印接口成功，返回json数据--" + sb.toString());
                            // è°ƒç”¨sap打印接口,记录日志
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakOut.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setRemark(message);
                            logInfo.setType(1);
                            sapRequestLogService.addSapLog(logInfo);
                        }else if(zstatus.equals("e")) {//上报SAP失败,更新io_status=X
                            waitPakOut.setPrnstatus(3);     //打印失败
                            waitPakOut.setMemo(message);
                            waitPakOutService.upWaitPakOut(waitPakOut,0);
                            logger.error("sendPrinCommand6---调用打印接口失败，请求json数据--" + message);
                            // è°ƒç”¨sap打印接口,记录日志
                            SapRequestLogBean logInfo = new SapRequestLogBean();
                            logInfo.setMatnr(waitPakOut.getMatnr());
                            logInfo.setRequest(jsObj.toString());
                            logInfo.setResponse(sb.toString());
                            logInfo.setCreate_time(new Date());
                            logInfo.setRemark(message);
                            logInfo.setType(2);
                            sapRequestLogService.addSapLog(logInfo);
                        }
                    }
                }
@@ -614,6 +723,15 @@
                waitPakOut.setMemo(e.getMessage());
                waitPakOutService.upWaitPakOut(waitPakOut,0);
                logger.error("sendPrinCommand7---调用打印接口回报异常--"+waitPakOut.getMatnr() + "---" + e.getMessage());
                // è°ƒç”¨sap打印接口,记录日志
                SapRequestLogBean logInfo = new SapRequestLogBean();
                logInfo.setMatnr(waitPakOut.getMatnr());
                logInfo.setRequest(jsObj.toString());
                logInfo.setResponse("sendPrinCommand7---调用打印接口回报异常--"+waitPakOut.getMatnr() + "---");
                logInfo.setCreate_time(new Date());
                logInfo.setRemark(e.getMessage());
                logInfo.setType(2);
                sapRequestLogService.addSapLog(logInfo);
//                System.out.println(e.getMessage());
            }finally{
                if(connection!=null){
@@ -625,6 +743,15 @@
            waitPakOut.setMemo(e.getMessage());
            waitPakOutService.upWaitPakOut(waitPakOut,0);
            logger.error("sendPrinCommand8---调用打印接口回报异常--"+waitPakOut.getMatnr() + "---" + e.getMessage());
            // è°ƒç”¨sap打印接口,记录日志
            SapRequestLogBean logInfo = new SapRequestLogBean();
            logInfo.setMatnr(waitPakOut.getMatnr());
            logInfo.setRequest("打印请求失败");
            logInfo.setResponse("sendPrinCommand8---调用打印接口回报异常--"+waitPakOut.getMatnr() + "---");
            logInfo.setCreate_time(new Date());
            logInfo.setRemark(e.getMessage());
            logInfo.setType(2);
            sapRequestLogService.addSapLog(logInfo);
//            System.out.println(e.getMessage());
        }
        return result;

 src/main/java/com/slcf/pojo/SapRequestLogBean.java

New file
@@ -0,0 +1,84 @@
package com.slcf.pojo;


import java.text.SimpleDateFormat;
import java.util.Date;

public class SapRequestLogBean {
    private int id;

    private String matnr;

    private String request;

    private String response;

    private Date create_time;

    private String remark;

    private Integer type;

    public String getCreate_time$(){
        if (null == this.create_time){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.create_time);
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getMatnr() {
        return matnr;
    }

    public void setMatnr(String matnr) {
        this.matnr = matnr;
    }

    public String getRequest() {
        return request;
    }

    public void setRequest(String request) {
        this.request = request;
    }

    public String getResponse() {
        return response;
    }

    public void setResponse(String response) {
        this.response = response;
    }

    public Date getCreate_time() {
        return create_time;
    }

    public void setCreate_time(Date create_time) {
        this.create_time = create_time;
    }

    public Integer getType() {
        return type;
    }

    public void setType(Integer type) {
        this.type = type;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }
}

 src/main/java/com/slcf/service/SapRequestLogService.java

New file
@@ -0,0 +1,16 @@
package com.slcf.service;

import com.slcf.bean.WorkDetailLogCondition;
import com.slcf.bean.WorkMastLogCondition;
import com.slcf.pojo.SapRequestLogBean;
import com.slcf.pojo.WorkMastLogBean;

import java.util.List;
import java.util.Map;

/* æŸ¥è¯¢sap请求日志 */
public interface SapRequestLogService {
    public List<SapRequestLogBean> querySapLog();

    public Integer addSapLog(SapRequestLogBean param);
}

 src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java

New file
@@ -0,0 +1,36 @@
package com.slcf.service.impl;

import com.slcf.dao.SapRequestLogDao;
import com.slcf.pojo.SapRequestLogBean;
import com.slcf.service.SapRequestLogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * å·¥ä½œåŽ†å²æ¡£æŽ¥å£å®žçŽ°
 * @author admin
 * @date 2018å¹´11月23日
 */
@Service
public class SapRequestLogServiceImpl implements SapRequestLogService {

    @Autowired
    SapRequestLogDao sapRequestLogDao;

    /**
     * æŸ¥è¯¢sap请求日志
     */
    public List<SapRequestLogBean> querySapLog() {
        List<SapRequestLogBean> list = sapRequestLogDao.querySapLog();
        return list;
    }

    public Integer addSapLog(SapRequestLogBean param) {
        Integer result = sapRequestLogDao.addSapLog(param.getMatnr(), param.getRequest(), param.getResponse(), param.getCreate_time(), param.getType(), param.getRemark());
        return result;
    }
}

 src/main/resources/mapper/SapRequestLogMapper.xml

New file
@@ -0,0 +1,26 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.slcf.dao.SapRequestLogDao">

<!-- mapper不支持sql语句嵌套时，采用sql片段包含方式，解决xml标签问题 -->
<resultMap id="BaseResult" type="com.slcf.pojo.SapRequestLogBean">
    <result column="id" property="id"></result>
    <result column="matnr" property="matnr"></result>
    <result column="request" property="request"></result>
    <result column="response" property="response"></result>
    <result column="create_time" property="create_time"></result>
    <result column="remark" property="remark"></result>
    <result column="type" property="type"></result>
</resultMap>

<select id="querySapLog" resultMap="BaseResult">
    SELECT * FROM sap_request_log ORDER BY create_time desc;
</select>

<insert id="addSapLog">
    INSERT INTO sap_request_log(matnr, request, response, create_time, type, remark) VALUES (#{matnr}, #{request}, #{response}, #{create_time}, #{create_time}, #{remark})
</insert>


</mapper>

 src/main/webapp/WEB-INF/pages/sapRequestLog.jsp

New file
@@ -0,0 +1,20 @@
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ include file="../../include/core.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>

<script type="text/javascript" src="${path }/jsFiles/sapRequestLog.js"></script>
<style type="text/css">

</style>
</head>
<body>

<table id="test-table" class="table table-hover table-striped table-condensed table-bordered"></table>

</body>
</html>

 src/main/webapp/jsFiles/sapRequestLog.js

New file
@@ -0,0 +1,100 @@
/**
 * åº“位使用率
 */
$(function () {
    $('#test-table').bootstrapTable('destroy')
    $('#test-table').bootstrapTable({
        method: 'GET',
        url: "sap/querySapLog.action",
        cache: false,
        striped: true,
        showColumns: true, //显示隐藏列
        showRefresh: false, //显示刷新按钮
        showExport: false,
        toolbar: "#toolbar",
        singleselect: true,
        clickToSelect: true, // å•å‡»è¡Œå³å¯ä»¥é€‰ä¸­
        search: false,//显示搜素表单
        silent: true, //刷新事件必须设置
        sidePagination: "client", //前端分页
        columns: [
            {
                field: "matnr",
                title: "物料编码",
                align: "center",
                valign: "middle",
                // sortable: "true"
            }, {
                field: "request",
                title: "请求参数",
                align: "center",
                valign: "middle",
                sortable: "true"
            }, {
                field: "response",
                title: "返回参数",
                align: "center",
                valign: "middle",
                sortable: "true"
            }, {
                field: "create_time$",
                title: "记录时间",
                align: "center",
                valign: "middle",
                sortable: "true"
            },
            {
                field: "remark",
                title: "其他信息",
                align: "center",
                valign: "middle",
                sortable: "true"
            },
            {
                field: "type",
                title: "请求结果",
                align: "center",
                valign: "middle",
                sortable: "true",
                formatter: function (item) {
                    if (item == 1) {
                        return "成功";
                    }
                    if (item == 2) {
                        return "失败"
                    }
                }
            },
        ],
        queryParamsType: "undefined",
        queryParams: function queryParams(params) {   //设置查询参数
            // var param = {
            //     pageNumber: params.pageNumber,
            //     pageSize: params.pageSize
            //     // searchText: params.searchText
            // };
            // return param;
        },
        formatLoadingMessage: function () {
            return "请稍等，正在加载中...";
        },

        formatNoMatches: function () {
            return '无符合条件的记录';
        },
        //注册加载子表的事件。注意下这里的三个参数！
        onExpandRow: function (index, row, $detail) {
            // oInit.InitSubTable(index, row, $detail);
        }

    });
});

/**
 * æ¡ä»¶æŸ¥è¯¢
 * @returns
 */
function getViewStockUseByCon() {
//    $("#test-table").bootstrapTable('refresh');
    $("#test-table").bootstrapTable('refreshOptions', {pageNumber: 1}); //分页后重新搜索时，初始化页码为1
}

 version/ÐÂÔö±í½á¹¹/table

New file
@@ -0,0 +1,44 @@
USE [klsasrs]
GO

/****** Object:  Table [dbo].[sap_request_log]    Script Date: 2021/6/25 11:01:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[sap_request_log](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [matnr] [varchar](250) NULL,
    [request] [varchar](max) NULL,
    [response] [varchar](max) NULL,
    [create_time] [datetime] NULL,
    [remark] [varchar](max) NULL,
    [type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'matnr'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求入参' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'request'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求回参' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'response'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'create_time'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型 (1.请求成功,2.请求失败)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'type'
GO