微信小程序的预约安装调整

xinyb

2024-06-18 c973af4904bd6ed1b9e106817862b79f0ea46e36

微信小程序的预约安装调整

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

@@ -245,7 +245,7 @@
            sql += " exec sp_newdoccode 640210,'SYSTEM',@docCode output\n";
            sql += "insert into t640210H(docCode,formId,docDate,periodID,ccCode,ccName,DocStatus,LastDocStatus,PostCode,PostName,companyId,companyName,AcceptSource,cltCode,cltName,tel," +
                    "PropertyAddress,PreSendDate,Memo,enterDate,UploadFiles,seq,Longitude,Latitude,FullAddressName,Street)" +
                    " values (@docCode," + param.getFormId() + ",convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@ccCode,@ccName,0,0,'system','小程序端',@companyId,@companyName,'预约',@cltCode," +
                    " values (@docCode," + param.getFormId() + ",convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),@ccCode,@ccName,0,0,'system','小程序端',@companyId,@companyName,'预约安装',@cltCode," +
                    "@cltName," + GridUtils.prossSqlParm(param.getTel()) + ",@FullAddress," +
                    GridUtils.prossSqlParm(param.getPreSendDate()) + "," +
                    GridUtils.prossSqlParm(param.getMemo()) + ",getdate()," + GridUtils.prossSqlParm(param.getUploadFiles()) + "," +
@@ -270,7 +270,7 @@
                    " when isnull(a.DocStatus,0)=100 then 3 \n" +
                    " else 1 end) docStatus,isnull(a.lastDocStatus,0) lastDocStatus,a.memo \n" +
                    "from t640210H a join t110203 b on a.CltCode=b.CltCode and b.MiniAppOpenId=" + GridUtils.prossSqlParm(openId) + "\n" +
                    "where a.AcceptSource='预约' ";
                    "where a.AcceptSource='预约安装' ";
            if (docStatus == 1) {
                sql += "  and isnull(a.DocStatus,0) < 100";
            } else if (docStatus == 3) {