满意度接口和报修或投诉单关联

xinyb

2024-05-24 a236bf6cf152e2975f1c5cffa77a9b60d138ab6d

满意度接口和报修或投诉单关联

 src/com/yc/sdk/weixincp3rd/action/AfterSales.java

@@ -215,6 +215,10 @@
            } else {
                param.setOpenId(openId);
            }
            if(StringUtils.isBlank(param.getRefCode())){
                msg.setError("缺少报修单或投诉单的单号，请提交报修单或投诉单后再执行");
                return msg;
            }
            String dbId = (String) request.getSession().getAttribute(SessionKey.SHOPPING_DBID);
            SpObserver.setDBtoInstance("_" + dbId);
            afterSalesIfc.saveSatisfaction(param);

 src/com/yc/sdk/weixincp3rd/entity/AfterSalesParameters.java

@@ -20,6 +20,9 @@
    private String preSendDate;//预约上门时间
    private String memo;//申报原因或投诉内容


    private String refCode;//关联报修单或投诉单的单号
    private Integer refFormId;//关联报修单或投诉单的功能号
    private String overallEvaluationScore;//总体评价
    private String installEvaluationScore;//安装师傅满意度
    private String afterSalesEvaluationScore;//售后人员满意度

 src/com/yc/sdk/weixincp3rd/service/AfterSalesImpl.java

@@ -149,9 +149,9 @@
                        " end \n";
            }
            sql += " exec sp_newdoccode 640402,'SYSTEM',@docCode output\n";
            sql += "insert into t640402H(docCode,formId,DocStatus,companyId,companyName,docDate,cltCode,cltName,tel,EnterDate,OverallEvaluationScore,InstallEvaluationScore,AfterSalesEvaluationScore," +
            sql += "insert into t640402H(docCode,formId,refCode,refFormId,DocStatus,companyId,companyName,docDate,cltCode,cltName,tel,EnterDate,OverallEvaluationScore,InstallEvaluationScore,AfterSalesEvaluationScore," +
                    "DeliveryEvaluationScore,HDMemo,UploadFiles)" +
                    " values (@docCode,640402,0,@companyId,@companyName,convert(varchar(10),getdate(),120),@cltCode,@cltName,@tel,getdate()," +
                    " values (@docCode,640402,"+GridUtils.prossSqlParm(param.getRefCode())+","+param.getRefFormId()+",0,@companyId,@companyName,convert(varchar(10),getdate(),120),@cltCode,@cltName,@tel,getdate()," +
                    GridUtils.prossSqlParm(param.getOverallEvaluationScore()) + "," + GridUtils.prossSqlParm(param.getInstallEvaluationScore()) + "," +
                    GridUtils.prossSqlParm(param.getAfterSalesEvaluationScore()) + "," + GridUtils.prossSqlParm(param.getDeliveryEvaluationScore()) + "," +
                    GridUtils.prossSqlParm(param.getHDMemo()) + "," + GridUtils.prossSqlParm(param.getUploadFiles()) + ")";