jl_doc/jiali_doc/markdown/v1.5保函查询升级.md/v1.5保函查询升级.md

v1实现

根据项目名称查询功能

• 在保函查询(http://www.dev.yuncaigo.com/guaranteeQuery/guaranteeEntrance.do)页面输入框输入项目名称点击查询按钮,将跳转到列表页 (http://www.dev.yuncaigo.com/guaranteeQuery/guaranteeQuery.do?projectName=项目名称)
• 列表页 /guaranteeQuery/guaranteeQuery.do jsp渲染 WebContent/WEB-INF/jsp/guaranteeQuery/guaranteeQuery.jsp 文件, 渲染module为projectName

接口代码

    @RequestMapping(value = "/guaranteeQuery", method = RequestMethod.GET)
    public String guaranteeQuery(String projectName, HttpServletRequest httpServletRequest) throws UnsupportedEncodingException {
        httpServletRequest.setAttribute("projectName", projectName);
        return "/guaranteeQuery/guaranteeQuery";
    }

jsp代码

<input type="hidden" id="projectName" value="${projectName}">

• ajax发送请求,请求接口/guaranteeQuery/queryLists.do

请求代码

        $(function () {
            $('#datagrid').datagrid({
                url: em.bp() + '/guaranteeQuery/queryLists.do',
                pagination: true,
                rownumbers: true,
                queryParams: {
                    projectName: $("#projectName").val(),
                    status: '08'
                },
            })
        })

接口代码

    @RequestMapping(value = "/queryLists", method = RequestMethod.POST)
    @ResponseBody
    public DataGridJson queryLists(DataGrid dg, ProcessInfoQuery processInfoBO) {
        String projectName = ProjectNoEncryptUtil.aesEncrypt(processInfoBO.getProjectName());
        processInfoBO.setProjectCipherName(projectName);
        try {
            return bidBonService.getBidAmountPaymentQueryLists(dg, processInfoBO);
        } catch (ServiceException e) {
            return null;
        }
    }

SELECT *
FROM (SELECT ROWNUM AS                                                                         rowno,
             t.PROJECT_CODE                                                                    PROJECTCODE,
             p.projectid,
             p.PREMIUM,
             p.bankname,
             p.companysocialno,
             p.companyName,
             p.submitType,
             p.updateStatusTime,
             p.policyNo,
             p.bailAmt,
             p.tenderTime,
             p.tenderno,
             p.policyPath,
             p.applyTime,
             (SELECT registArea FROM T_COMPANY_INFO WHERE companySocialNo = p.companysocialno) registArea,
             p.tendereeName,
             p.status,
             p.reason
      FROM (SELECT projectid,
                   (SELECT dictname FROM s_dictionary WHERE dictcode = t.bankid)                bankname,
                   (SELECT companysocialno FROM s_user_info WHERE userid = t.applyname)         companysocialno,
                   (SELECT companyname
                    FROM t_company_info
                    WHERE companysocialno =
                          (SELECT companysocialno FROM s_user_info WHERE userid = t.applyname)) companyName,
                   (CASE
                        WHEN BIZID = '03' AND GUARANTEETYPE = '1' THEN '银行保函'
                        WHEN BIZID = '03' AND GUARANTEETYPE = '2' THEN '保险保单'
                        WHEN BIZID = '03' AND GUARANTEETYPE = '3' THEN '担保保单'
                        ELSE '未知' END)                                                          submitType,
                   PREMIUM,
                   updateStatusTime                                                             updateStatusTime,
                   policyNo,
                   trim(loanAmt)                                                                bailAmt,
                   tenderTime,
                   trim(tenderno)                                                               tenderno,
                   policyPath,
                   applyTime,
                   reason,
                   trim(tendereeName)                                                           tendereeName,
                   CASE status
                       WHEN '00' THEN '申请中'
                       WHEN '01' THEN '审核中'
                       WHEN '02' THEN '审核通过'
                       WHEN '03' THEN '审核未通过'
                       WHEN '04' THEN '待支付'
                       WHEN '05' THEN '已支付'
                       WHEN '06' THEN '已放款'
                       WHEN '07' THEN '已失效'
                       WHEN '08' THEN '已生成保函'
                       WHEN '09' THEN '已作废'
                       WHEN '10' THEN '已完成'
                       WHEN '11' THEN '待放款'
                       ELSE '其他' END as                                                         status
            FROM t_process_info t
            WHERE BIZID = '03'
              AND status IN (?)
              AND PROJECTNAME2 IN (?)) p
               INNER JOIN (SELECT p.TENDER_PROJECT_CODE, p.TENDER_PROJECT_NAME, p.PROJECT_CODE
                           FROM (SELECT TENDER_PROJECT_CODE,
                                        TENDER_PROJECT_NAME,
                                        PROJECT_CODE,
                                        ROW_NUMBER()
                                                OVER ( PARTITION BY TENDER_PROJECT_CODE ORDER BY RECEIVETIME DESC ) rn
                                 FROM T_COMMON_TENDERPROJECT_INFO
                                 WHERE TENDER_PROJECT_NAME = ?) p
                           WHERE p.rn = 1) t ON t.TENDER_PROJECT_CODE = p.PROJECTID
      WHERE ROWNUM <= ?) table_alias
WHERE table_alias.rowno >= ? 

v1.5 功能

添加验证码