2021-09-26 10:29:12,533 [7] INFO poslog - [传入串][9dca8d8e-55f2-4292-b13b-66998a756e7a] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"requestId\":\"98D2A5A8-B0BA-40E5-8E30-EA0129CE31CF\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:33:03\",\"format\":\"json\",\"sign\":\"B2670E43A993A1C3DDB131AA5C1A2FA9\"}" 2021-09-26 10:29:12,720 [7] INFO poslog - [/POSSRV/cyapi/pos/order/getmaxjlbh][9dca8d8e-55f2-4292-b13b-66998a756e7a] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:33:03", "format": "json", "version": "1.0", "sign": "B2670E43A993A1C3DDB131AA5C1A2FA9", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": "98D2A5A8-B0BA-40E5-8E30-EA0129CE31CF", "companyCode": null } 2021-09-26 10:29:12,736 [7] INFO poslog - [SQL][select ID,NAME,SYSKEY,SECRETKEY,SHDM,DDLY from POS_SYSTEM WHERE SYSKEY=:SYSKEY] { "SYSKEY": "test123" } 2021-09-26 10:29:14,064 [7] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from POS_ORDER where SKTNO =:SKTNO and STATUS <> :STATUS] { "SKTNO": "001001", "STATUS": 4 } 2021-09-26 10:29:14,142 [7] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTPOS_ORDER where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:29:14,158 [7] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from XSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:29:14,174 [7] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTXSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:29:14,189 [7] INFO poslog - [/POSSRV/cyapi/pos/order/getmaxjlbh_response]_processTime[1812ms]_][9dca8d8e-55f2-4292-b13b-66998a756e7a] { "Code": "0", "Msg": "操作成功", "Tips": null, "Data": { "storeCode": "1", "ddly": null, "ddlx": null, "orderFunction": 0, "sktno": "001001", "jlbh": "106", "orderNo": null } } 2021-09-26 10:29:45,785 [7] INFO poslog - [传入串][2713e1a0-d865-4e4a-aabe-aae367c3d1d2] "{\"sys_key\":\"test123\",\"Params_json\":{\"mac\":\"paopao\",\"personCode\":\"99988\",\"version\":\"\",\"password\":\"1\",\"storeCode\":\"1\",\"sktno\":\"001001\",\"anthCode\":\"\"},\"requestId\":\"D7280519-E03C-4E79-B01C-17C276C5FFCF\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:33:51\",\"format\":\"json\",\"sign\":\"A39A6F7130440D992827F5BF2DCB0EE3\"}" 2021-09-26 10:29:45,785 [7] INFO poslog - [/POSSRV/cyapi/pos/common/login][2713e1a0-d865-4e4a-aabe-aae367c3d1d2] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:33:51", "format": "json", "version": "1.0", "sign": "A39A6F7130440D992827F5BF2DCB0EE3", "Params_json": { "mac": "paopao", "personCode": "99988", "version": "", "password": "1", "storeCode": "1", "sktno": "001001", "anthCode": "" }, "secretkey": null, "token": null, "requestId": "D7280519-E03C-4E79-B01C-17C276C5FFCF", "companyCode": null } 2021-09-26 10:29:45,814 [7] INFO poslog - [SQL][SELECT B.ID,B.CRMID,B.NAME,B.CCL,B.SXH,B.ZFSX,B.FDBH,B.URL_ZT,B.URL_POS,C.FDMC,C.FIELD1,C.FIELD2,C.FIELD3,nvl(A.CSMCDM, -1) CSMCDM FROM SKT A,SKTGROUP B,FDDEF C WHERE A.SKTNO=:SKTNO AND A.GROUPID=B.ID AND C.FDBH=A.FDBH AND C.FDBH= :FDBH ] { "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:29:45,830 [7] INFO poslog - [SQL][ SELECT C.SXLX,C.SXVAL,C.CONTENT FROM SKT A,SKTGROUP B,SKTGROUPITEM C,POS_DATA D WHERE A.SKTNO=:SKTNO AND A.GROUPID=B.ID AND C.SXVAL=D.ID AND C.SXLX=D.LX AND A.GROUPID= C.ID AND D.STATUS=1 ] { "SKTNO": "001001" } 2021-09-26 10:29:45,861 [7] INFO poslog - [Login][GetPerson] "select A.LOGIN_PASSWORD,A.OPER_STATION,A.PERSON_ID from XTCZY A,RYXX B where A.PERSON_ID=B.PERSON_ID and B.RYDM=:RYDM " 2021-09-26 10:29:45,861 [7] INFO poslog - [SQL][select A.LOGIN_PASSWORD,A.OPER_STATION,A.PERSON_ID from XTCZY A,RYXX B where A.PERSON_ID=B.PERSON_ID and B.RYDM=:RYDM ] { "RYDM": "99988" } 2021-09-26 10:29:45,876 [7] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:29:45,892 [7] INFO poslog - [SQL][ select MSG_ID,VALUE,CAPTION,LX from XTCZY_POSQX where PERSON_ID =:PERSON_ID] { "PERSON_ID": 93 } 2021-09-26 10:29:45,939 [7] INFO poslog - [SQL][select STATUS from POS_MONITOR where SKTNO=:SKTNO and FDBH=:FDBH ] { "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:29:45,955 [7] INFO poslog - [SQL][ update POS_MONITOR set STATUS=1,PERSON_ID=:PERSON_ID,CAL_VERSION=:CAL_VERSION where SKTNO=:SKTNO and FDBH=:FDBH] { "PERSON_ID": 93, "CAL_VERSION": "", "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:29:45,970 [7] INFO poslog - [SQL][select JLBH,CUR_VAL,LX FROM BFCONFIG WHERE (FDBH= '-1' OR FDBH=1)] { "JLBH": "-1" } 2021-09-26 10:29:46,001 [7] INFO poslog - [SQL][select A.PERSON_ID,A.PERSON_NAME,A.RYDM,A.DEPTID ,B.DEPT_NAME,A.SHOPID from RYXX A,BM B where A.DEPTID=B.DEPTID AND B.STATUS =0 AND A.SHOPID = :SHOPID] { "SHOPID": 0 } 2021-09-26 10:29:46,014 [7] INFO poslog - [SQL][select JLBH,CUR_VAL,LX FROM BFCONFIG WHERE (FDBH= '-1' OR FDBH=1) AND JLBH in(1500001115,1500001116,1500001113,1500001114,1080100002,1500001117,1500001102,1500001103,1500001101,1101002005)] {} 2021-09-26 10:29:46,028 [7] INFO poslog - [SQL][SELECT * from ( select DISTINCT L.SPFL,L.NAME,L.SPFLID from SPXX X, SPFL L,GTSP G WHERE substr(X.SPFL,1,2) = L.SPFL AND length(L.SPFL)=2 AND G.SP_ID=X.SP_ID AND G.DEPTID=:DEPTID ) WHERE ROWNUM >=0 and ROWNUM <=30 order by SPFL ] { "MINPAGESIZE": 0, "MAXPAGESIZE": 30, "DEPTID": "18" } 2021-09-26 10:29:46,068 [7] INFO poslog - [SQL][SELECT * from ( select NAME,SPCODE,BARCODE from SPXX where STATUS in (0,4,3,5) AND SHOPID =:SHOPID AND FDBH =:FDBH ORDER BY BARCODE,SPFL ) WHERE ROWNUM >=0 and ROWNUM <=30 ] { "SHOPID": 0, "FDBH": "1", "MAXPAGESIZE": 30 } 2021-09-26 10:29:46,091 [7] INFO poslog - [SQL][select ID,NAME,PYM,BJ_ZZJH,BJ_ZZXS,BJ_YJJX,BJ_GTSP from SPJX ] {} 2021-09-26 10:29:46,110 [7] INFO poslog - [SQL][select * from (select A.CODE,A.NAME,A.TYPE,nvl(A.YHQID,-1) YHQID,A.ZLCLFS,A.XSSX,A.HL,A.YEDY from SKFS A where A.CODE in (select g.SKFS from ZFSXDY_SKFS g, SKT s where s.SKTNO = :SKTNO and s.ZFSX = g.JLBH) UNION select A.CODE,A.NAME,A.TYPE,nvl(A.YHQID,-1) YHQID,A.ZLCLFS,A.XSSX,A.HL,A.YEDY from SKFS A where A.CODE in (select SKFSID from SKT_SKFS where SKTNO=:SKTNO)) a order by a.XSSX,a.CODE] { "SKTNO": "001001" } 2021-09-26 10:29:46,126 [7] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 1 } 2021-09-26 10:29:46,126 [7] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 4 } 2021-09-26 10:29:46,142 [7] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 5 } 2021-09-26 10:29:46,142 [7] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 6 } 2021-09-26 10:29:46,142 [7] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 8 } 2021-09-26 10:29:46,189 [7] INFO poslog - [/POSSRV/cyapi/pos/common/login_response]_processTime[365ms]_][2713e1a0-d865-4e4a-aabe-aae367c3d1d2] { "Code": "0", "Msg": null, "Tips": null, "Data": { "cashierCode": "99988", "cashierId": 93, "cashierName": "lzj_cs", "cashierDeptCode": "0001", "cashierDeptId": "18", "cashierDeptName": "一号门店", "shopName": null, "shopId": 0, "configs": [ { "id": 12, "value": "5", "desc": "人员代码长度" }, { "id": 1101002002, "value": "10", "desc": "商品编码长度" }, { "id": 1500000002, "value": "3", "desc": "柜组版销售终端小票打印份数" } ], "personList": [], "goodsList": [ { "name": "大礼包", "code": "900001", "barcode": "2190000100002", "price": null, "classType": null, "classTypeName": null } ], "spflList": null, "payList": [ { "payCode": 1, "payName": "折扣券", "payType": 4, "yhqId": 1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 4, "payName": "测试石基", "payType": 20, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 5, "payName": "订单", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 6, "payName": "方法", "payType": 6, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 7, "payName": "测试比例", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 8, "payName": "测试", "payType": 4, "yhqId": 4, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 9, "payName": "现金", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 10, "payName": "测试2", "payType": 4, "yhqId": 5, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 11, "payName": "www", "payType": 2, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 12, "payName": "11", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 13, "payName": "满百抵", "payType": 16, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 14, "payName": "测试收款方式", "payType": 19, "yhqId": -1, "changeType": 1, "zlclfs": 1, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 15, "payName": "CESXXXX", "payType": 4, "yhqId": 6, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 18, "payName": "CEEEE", "payType": 3, "yhqId": 7, "changeType": 1, "zlclfs": 1, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 19, "payName": "qqqqq", "payType": 4, "yhqId": 8, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 } ], "freetax_configs": [], "countryList": [], "permissionsList": [ { "msgId": "805", "value": "1", "caption": "班报", "lx": "0" }, { "msgId": "807", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "810", "value": "1", "caption": "销售退货", "lx": "1" }, { "msgId": "813", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "849", "value": "1", "caption": "银行查询", "lx": "1" }, { "msgId": "812", "value": "1", "caption": "更改口令", "lx": "0" }, { "msgId": "833", "value": "1", "caption": "销售", "lx": "0" }, { "msgId": "847", "value": "1", "caption": "银行接口", "lx": "1" }, { "msgId": "852", "value": "1", "caption": "银行消费", "lx": "0" }, { "msgId": "853", "value": "1", "caption": "银行结算", "lx": "0" }, { "msgId": "801", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "808", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "811", "value": "1", "caption": "取消商品", "lx": "0" }, { "msgId": "812", "value": "1", "caption": "更改口令", "lx": "1" }, { "msgId": "814", "value": "1", "caption": "补打小票", "lx": "1" }, { "msgId": "849", "value": "1", "caption": "银行查询", "lx": "0" }, { "msgId": "851", "value": "1", "caption": "银行签到", "lx": "1" }, { "msgId": "803", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "805", "value": "1", "caption": "班报", "lx": "1" }, { "msgId": "806", "value": "1", "caption": "日报", "lx": "1" }, { "msgId": "806", "value": "1", "caption": "日报", "lx": "0" }, { "msgId": "811", "value": "1", "caption": "取消商品", "lx": "1" }, { "msgId": "813", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "815", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "837", "value": "1", "caption": "收货", "lx": "0" }, { "msgId": "847", "value": "1", "caption": "银行接口", "lx": "0" }, { "msgId": "848", "value": "1", "caption": "银行重打印", "lx": "0" }, { "msgId": "852", "value": "1", "caption": "银行消费", "lx": "1" }, { "msgId": "854", "value": "1", "caption": "银行撤销", "lx": "0" }, { "msgId": "802", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "804", "value": "1", "caption": "培训模式", "lx": "1" }, { "msgId": "807", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "809", "value": "1", "caption": "前台折扣", "lx": "0" }, { "msgId": "821", "value": "1", "caption": "盘点", "lx": "0" }, { "msgId": "848", "value": "1", "caption": "银行重打印", "lx": "1" }, { "msgId": "803", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "809", "value": "1", "caption": "前台折扣", "lx": "1" }, { "msgId": "814", "value": "1", "caption": "补打小票", "lx": "0" }, { "msgId": "816", "value": "1", "caption": "取消交易", "lx": "0" }, { "msgId": "821", "value": "1", "caption": "盘点", "lx": "1" }, { "msgId": "833", "value": "1", "caption": "销售", "lx": "1" }, { "msgId": "851", "value": "1", "caption": "银行签到", "lx": "0" }, { "msgId": "853", "value": "1", "caption": "银行结算", "lx": "1" }, { "msgId": "854", "value": "1", "caption": "银行撤销", "lx": "1" }, { "msgId": "801", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "808", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "810", "value": "1", "caption": "销售退货", "lx": "0" }, { "msgId": "815", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "802", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "804", "value": "1", "caption": "培训模式", "lx": "0" }, { "msgId": "816", "value": "1", "caption": "取消交易", "lx": "1" }, { "msgId": "837", "value": "1", "caption": "收货", "lx": "1" } ], "spjxList": [ { "name": "常规机", "code": "CGJ", "id": 1, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 0, "BJ_GTSP": 0 }, { "name": "特价机", "code": "TJJ", "id": 2, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 0, "BJ_GTSP": 0 }, { "name": "样机", "code": "YJ", "id": 3, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 1, "BJ_GTSP": 0 } ], "tableList": [], "skt": { "sktno": "001001", "storeCode": "1", "permit_gz": 1, "permit_bar": -1, "permit_cy": -1, "permit_supermarket": -1, "permit_zg": 0, "permit_zk": 0, "possrvid": 0, "permit_th": 0, "permit_bb": 0, "permit_freetax": -1, "printType": 0, "qsfs": 0, "csmcCode": -1, "mcName": "一号门店", "length_verify_cashcard": 0, "length_verify_membercard": 0, "msdbh": "", "msdbm": "", "msdmc": "", "groupId": "1", "crmId": "1", "groupName": "测试组", "URL_ZT": "1", "URL_POS": "1", "slfs": "", "slfs_Gold": 4, "msjfbj": null, "ysjfbj": null, "ztcxms": null, "novip_sptype": "0", "checkVipBuyerInfo": 0, "sktconfigList": [ { "lx": "1", "id": "2", "value": "" }, { "lx": "2", "id": "1", "value": "1" }, { "lx": "3", "id": "1", "value": "" }, { "lx": "4", "id": "1", "value": "" }, { "lx": "4", "id": "2", "value": "" }, { "lx": "4", "id": "3", "value": "" }, { "lx": "4", "id": "4", "value": "" }, { "lx": "4", "id": "5", "value": "" }, { "lx": "4", "id": "6", "value": "" }, { "lx": "4", "id": "7", "value": "" }, { "lx": "4", "id": "8", "value": "" }, { "lx": "4", "id": "9", "value": "" }, { "lx": "4", "id": "10", "value": "" }, { "lx": "5", "id": "2", "value": "" }, { "lx": "5", "id": "3", "value": "2" }, { "lx": "5", "id": "4", "value": "" }, { "lx": "5", "id": "6", "value": "" }, { "lx": "5", "id": "7", "value": "" }, { "lx": "5", "id": "8", "value": "" }, { "lx": "5", "id": "9", "value": "" }, { "lx": "5", "id": "10", "value": "" }, { "lx": "6", "id": "5", "value": "" }, { "lx": "7", "id": "6", "value": "" }, { "lx": "7", "id": "7", "value": "" }, { "lx": "8", "id": "7", "value": "" }, { "lx": "8", "id": "9", "value": "" }, { "lx": "9", "id": "1", "value": "" }, { "lx": "9", "id": "2", "value": "" }, { "lx": "9", "id": "3", "value": "" }, { "lx": "9", "id": "4", "value": "" }, { "lx": "9", "id": "5", "value": "" }, { "lx": "9", "id": "6", "value": "" }, { "lx": "9", "id": "7", "value": "" }, { "lx": "9", "id": "8", "value": "" }, { "lx": "9", "id": "9", "value": "" }, { "lx": "10", "id": "1", "value": "" }, { "lx": "10", "id": "2", "value": "" } ] } } } 2021-09-26 10:29:46,439 [12] INFO poslog - [传入串][db9dd020-d9e6-4589-8784-3839165959f2] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\"},\"requestId\":\"6B10A7E5-C40E-4366-8981-53965172A07A\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:33:52\",\"format\":\"json\",\"sign\":\"2C3B51ACECC2319B12DFA8B1C59015D5\"}" 2021-09-26 10:29:46,439 [12] INFO poslog - [/POSSRV/cyapi/pos/common/getjdinfo][db9dd020-d9e6-4589-8784-3839165959f2] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:33:52", "format": "json", "version": "1.0", "sign": "2C3B51ACECC2319B12DFA8B1C59015D5", "Params_json": { "storeCode": "1" }, "secretkey": null, "token": null, "requestId": "6B10A7E5-C40E-4366-8981-53965172A07A", "companyCode": null } 2021-09-26 10:29:46,439 [12] INFO poslog - [SQL][ SELECT B.DEPTID,FD.FDBH,FD.FDMC from FDDEF F ,FDDEF FD,BM B WHERE B.DEPTID = F.DEPTID AND FD.FDLXDM = 0 AND F.FDBH=:FDBH AND F.PSZX = FD.DEPTID] { "FDBH": "1" } 2021-09-26 10:29:46,455 [12] INFO poslog - [SQL][select ID,NAME,THSX,CHFS,WLSX from SHFS] {} 2021-09-26 10:29:46,486 [12] INFO poslog - [SQL][select JLBH,CODE,QYMC from SHQY] {} 2021-09-26 10:29:46,501 [12] INFO poslog - [SQL][select NAME,LXFY from SHLX] {} 2021-09-26 10:29:46,533 [12] INFO poslog - [/POSSRV/cyapi/pos/common/getjdinfo_response]_processTime[70ms]_][db9dd020-d9e6-4589-8784-3839165959f2] { "Code": "0", "Msg": "成功", "Tips": null, "Data": { "kcdd": { "fdmc": "配送中心", "deptid": 18 }, "shfslist": [ { "id": 3, "name": "配送送货", "thsx": "0", "chfs": "0", "wlsx": "2" }, { "id": 1, "name": "门店送货", "thsx": "0", "chfs": "1", "wlsx": "2" }, { "id": 2, "name": "门店自提", "thsx": "1", "chfs": "1", "wlsx": "2" }, { "id": 4, "name": "配送自提", "thsx": "1", "chfs": "0", "wlsx": "2" } ], "shqylist": { "districtList": [ { "code": "03", "name": "广东", "jlbh": 13, "citys": [ { "code": "0301", "name": "广州", "parent": "03", "jlbh": 14, "areas": [ { "code": "030101", "name": "白云区", "parent": "0301", "jlbh": 15, "streets": [] } ] } ] }, { "code": "01", "name": "安徽", "jlbh": 1, "citys": [ { "code": "0101", "name": "合肥", "parent": "01", "jlbh": 2, "areas": [ { "code": "010102", "name": "庐阳区", "parent": "0101", "jlbh": 4, "streets": [] }, { "code": "010103", "name": "长丰区", "parent": "0101", "jlbh": 5, "streets": [] }, { "code": "010101", "name": "蜀山区", "parent": "0101", "jlbh": 3, "streets": [] } ] } ] }, { "code": "02", "name": "江苏", "jlbh": 6, "citys": [ { "code": "0202", "name": "苏州", "parent": "02", "jlbh": 8, "areas": [ { "code": "020202", "name": "吴中区", "parent": "0202", "jlbh": 12, "streets": [] }, { "code": "020201", "name": "姑苏区", "parent": "0202", "jlbh": 11, "streets": [] } ] }, { "code": "0201", "name": "玄武区", "parent": "02", "jlbh": 10, "areas": [ { "code": "020102", "name": "玄武区", "parent": "0201", "jlbh": 10, "streets": [] }, { "code": "020101", "name": "鼓楼区", "parent": "0201", "jlbh": 9, "streets": [] } ] } ] } ] }, "shlxlist": [ { "name": "市内", "money": "10" }, { "name": "市外", "money": "15" } ] } } 2021-09-26 10:29:46,705 [7] INFO poslog - [传入串][9b0c2b7a-5c9e-41e3-b4ea-2fcc79adab35] "{\"sys_key\":\"test123\",\"Params_json\":{\"operatorCode\":\"99988\",\"orderFunction\":0,\"storeCode\":\"1\",\"tableNo\":\"\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"oldOrderNo\":\"\"},\"requestId\":\"E4E00309-FB1D-4BF0-AB80-20FAFF40B52A\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:33:52\",\"format\":\"json\",\"sign\":\"B07BC51EC65466EDF6C52FF91500A619\"}" 2021-09-26 10:29:46,705 [7] INFO poslog - [/POSSRV/cyapi/pos/order/create][9b0c2b7a-5c9e-41e3-b4ea-2fcc79adab35] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:33:52", "format": "json", "version": "1.0", "sign": "B07BC51EC65466EDF6C52FF91500A619", "Params_json": { "operatorCode": "99988", "orderFunction": 0, "storeCode": "1", "tableNo": "", "sktno": "001001", "ddly": "0", "ddlx": "0", "oldOrderNo": "" }, "secretkey": null, "token": null, "requestId": "E4E00309-FB1D-4BF0-AB80-20FAFF40B52A", "companyCode": null } 2021-09-26 10:29:46,720 [7] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:29:46,736 [7] INFO poslog - [SQL][select S_POS_ORDER.Nextval as JLBH from dual ] {} 2021-09-26 10:29:46,830 [7] INFO poslog - [SQL][insert into POS_ORDER(ORDERNO,FDBH,SKTNO,DDLY,DDGN,JYLX,STATUS,KSSJ,SMG_HYID,SKY,OLDORDERNO,SKTNO_OLD,JLBH_OLD)values (:ORDERNO,:FDBH,:SKTNO,:DDLY,:DDGN,:JYLX,:STATUS,SYSDATE,:SMG_HYID,:SKY,:OLDORDERNO,:SKTNO_OLD,:JLBH_OLD)] { "ORDERNO": "10120210926102946798", "FDBH": 1, "SKTNO": "001001", "DDLY": 0, "JYLX": 0, "STATUS": 0, "DDGN": 0, "KSSJ": "2021-09-26T10:29:46.8143764+08:00", "SMG_HYID": null, "SKY": 93, "OLDORDERNO": "", "SKTNO_OLD": "", "JLBH_OLD": 0, "BJ_FREETAX": 0, "THYY": null, "TABLEID": "", "DINNERS": 0 } 2021-09-26 10:29:46,845 [7] INFO poslog - [/POSSRV/cyapi/pos/order/create_response]_processTime[138ms]_][9b0c2b7a-5c9e-41e3-b4ea-2fcc79adab35] { "Code": "0", "Msg": null, "Tips": null, "Data": { "orderNo": "10120210926102946798" } } 2021-09-26 10:29:52,908 [7] INFO poslog - [传入串][6d2a0d48-84da-48b5-914e-360794d06ff1] "{\"sys_key\":\"test123\",\"Params_json\":{\"needGoodsList\":0,\"personCode\":\"99997\",\"storeCode\":\"1\"},\"requestId\":\"C84D933E-E4F3-4B92-9540-28F4572DBBC6\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:33:58\",\"format\":\"json\",\"sign\":\"0A849BCF21841D741D434B51F42F7701\"}" 2021-09-26 10:29:52,908 [7] INFO poslog - [/POSSRV/cyapi/pos/common/getperson][6d2a0d48-84da-48b5-914e-360794d06ff1] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:33:58", "format": "json", "version": "1.0", "sign": "0A849BCF21841D741D434B51F42F7701", "Params_json": { "needGoodsList": 0, "personCode": "99997", "storeCode": "1" }, "secretkey": null, "token": null, "requestId": "C84D933E-E4F3-4B92-9540-28F4572DBBC6", "companyCode": null } 2021-09-26 10:29:52,923 [7] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.WORK_TYPE=:WORK_TYPE and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1 AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "WORK_TYPE": "2", "FDBH": "1" } 2021-09-26 10:29:52,923 [7] INFO poslog - [/POSSRV/cyapi/pos/common/getperson_response]_processTime[14ms]_][6d2a0d48-84da-48b5-914e-360794d06ff1] { "Code": "0", "Msg": "成功", "Tips": null, "Data": { "personId": 32, "personCode": "99997", "personName": "接吻猫", "personDeptId": 57, "personDeptCode": "0001010102", "personDeptName": "谢瑞麟", "goodsList": null } } 2021-09-26 10:29:57,408 [6] INFO poslog - [传入串][8c1e3969-bb9c-4833-a618-745f1d6beb4d] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926102946798\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":1,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":0,\"ticktInx\":0},\"requestId\":\"5B6CA369-FE41-44C1-B2E5-1ED5F2003AE9\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:34:03\",\"format\":\"json\",\"sign\":\"FC8D019074A9618C48056D194EDCCE0D\"}" 2021-09-26 10:29:57,408 [6] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][8c1e3969-bb9c-4833-a618-745f1d6beb4d] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:34:03", "format": "json", "version": "1.0", "sign": "FC8D019074A9618C48056D194EDCCE0D", "Params_json": { "orderNo": "10120210926102946798", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 1, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 0, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "5B6CA369-FE41-44C1-B2E5-1ED5F2003AE9", "companyCode": null } 2021-09-26 10:29:57,486 [6] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926102946798", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:29:57,533 [6] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:29:57,548 [6] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:29:57,564 [6] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:29:57,579 [6] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:29:57,596 [6] INFO poslog - [SQL][select ID,NAME,APPKEY,APPSECRET,URL,VAL1,VAL2 from POS_INTERFACE WHERE ID=:ID AND FDBH=-1] { "ID": 901, "FDBH": "" } 2021-09-26 10:29:57,626 [6] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:29:57\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":1}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:29:57,626 [6] INFO poslog - [Platform请求][加密串] "14B87E85D1A7BF7388DF545A63206914" 2021-09-26 10:29:57,820 [6] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[403ms]_][8c1e3969-bb9c-4833-a618-745f1d6beb4d] { "Code": "2001", "Msg": "商品的销售数量1超过了配送中心可用库存0", "Tips": "商品的销售数量1超过了配送中心可用库存0", "Data": null } 2021-09-26 10:31:01,392 [6] INFO poslog - [传入串][3348a34b-6d69-494c-b179-e05908403e98] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:35:07\",\"format\":\"json\",\"sign\":\"4C974EE1D5F35FB75C70AA0435E885C5\"}" 2021-09-26 10:31:01,407 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][3348a34b-6d69-494c-b179-e05908403e98] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:35:07", "format": "json", "version": "1.0", "sign": "4C974EE1D5F35FB75C70AA0435E885C5", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:31:01,423 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[19ms]_][3348a34b-6d69-494c-b179-e05908403e98] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:32:20,219 [15] INFO poslog - [传入串][3dd9a9a2-d478-49bc-90e8-44291a0fccc2] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926102946798\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":2,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":1,\"ticktInx\":0},\"requestId\":\"731E441E-F88E-43EA-BB7E-766BB71A8AA7\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:36:25\",\"format\":\"json\",\"sign\":\"AB2666B393EE0172773F792285338181\"}" 2021-09-26 10:32:20,219 [15] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][3dd9a9a2-d478-49bc-90e8-44291a0fccc2] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:36:25", "format": "json", "version": "1.0", "sign": "AB2666B393EE0172773F792285338181", "Params_json": { "orderNo": "10120210926102946798", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 2, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 1, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "731E441E-F88E-43EA-BB7E-766BB71A8AA7", "companyCode": null } 2021-09-26 10:32:20,219 [15] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926102946798", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:32:20,219 [15] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:32:20,219 [15] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:32:20,235 [15] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:32:20,235 [15] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:32:20,235 [15] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:32:20\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":2}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:32:20,235 [15] INFO poslog - [Platform请求][加密串] "DE6744A120511F9A20DB4256BB22FDE3" 2021-09-26 10:32:20,282 [15] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[70ms]_][3dd9a9a2-d478-49bc-90e8-44291a0fccc2] { "Code": "2001", "Msg": "商品的销售数量1超过了销售部门可用库存0", "Tips": "商品的销售数量1超过了销售部门可用库存0", "Data": null } 2021-09-26 10:33:02,069 [18] INFO poslog - [传入串][da8620ff-7545-439b-aefc-d962cdabaf94] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:37:07\",\"format\":\"json\",\"sign\":\"B7AE807DC014C3884AEC0EF0D55F375B\"}" 2021-09-26 10:33:02,069 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][da8620ff-7545-439b-aefc-d962cdabaf94] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:37:07", "format": "json", "version": "1.0", "sign": "B7AE807DC014C3884AEC0EF0D55F375B", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:33:02,079 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[11ms]_][da8620ff-7545-439b-aefc-d962cdabaf94] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:35:02,688 [15] INFO poslog - [传入串][b3d2ccf0-19bf-4e46-9606-025f5c2be5d8] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:39:08\",\"format\":\"json\",\"sign\":\"85189BE066EFEB11C839BBC21DFFB245\"}" 2021-09-26 10:35:02,688 [15] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][b3d2ccf0-19bf-4e46-9606-025f5c2be5d8] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:39:08", "format": "json", "version": "1.0", "sign": "85189BE066EFEB11C839BBC21DFFB245", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:35:02,703 [15] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[11ms]_][b3d2ccf0-19bf-4e46-9606-025f5c2be5d8] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:36:32,250 [21] INFO poslog - [传入串][ffd74458-a9a7-4442-b5c2-b4eff66ba13e] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:40:38\",\"format\":\"json\",\"sign\":\"F3208D7C70325DFC9F42BDA29F022D0E\"}" 2021-09-26 10:36:32,250 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][ffd74458-a9a7-4442-b5c2-b4eff66ba13e] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:40:38", "format": "json", "version": "1.0", "sign": "F3208D7C70325DFC9F42BDA29F022D0E", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:36:32,250 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[9ms]_][ffd74458-a9a7-4442-b5c2-b4eff66ba13e] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:36:32,296 [15] INFO poslog - [传入串][4a490c34-f866-440b-81e8-ac3acf79b3f7] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"requestId\":\"105C53B3-3305-4560-B4BE-25A81FADE7BA\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:40:38\",\"format\":\"json\",\"sign\":\"F3208D7C70325DFC9F42BDA29F022D0E\"}" 2021-09-26 10:36:32,296 [15] INFO poslog - [/POSSRV/cyapi/pos/common/loginout][4a490c34-f866-440b-81e8-ac3acf79b3f7] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:40:38", "format": "json", "version": "1.0", "sign": "F3208D7C70325DFC9F42BDA29F022D0E", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": "105C53B3-3305-4560-B4BE-25A81FADE7BA", "companyCode": null } 2021-09-26 10:36:32,296 [15] INFO poslog - [SQL][ update POS_MONITOR set STATUS=0 where SKTNO=:SKTNO and FDBH=:FDBH] { "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:36:32,312 [15] INFO poslog - [/POSSRV/cyapi/pos/common/loginout_response]_processTime[12ms]_][4a490c34-f866-440b-81e8-ac3acf79b3f7] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:37:25,031 [6] INFO poslog - [传入串][3d77a060-7d5f-4027-8d1f-b27b9342dd9a] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"requestId\":\"90877A3C-0490-4B3C-A141-17510664F75C\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:30\",\"format\":\"json\",\"sign\":\"663EBB634DB044F2FA8CBFDBF8D2559C\"}" 2021-09-26 10:37:25,046 [6] INFO poslog - [/POSSRV/cyapi/pos/order/getmaxjlbh][3d77a060-7d5f-4027-8d1f-b27b9342dd9a] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:30", "format": "json", "version": "1.0", "sign": "663EBB634DB044F2FA8CBFDBF8D2559C", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": "90877A3C-0490-4B3C-A141-17510664F75C", "companyCode": null } 2021-09-26 10:37:25,046 [6] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from POS_ORDER where SKTNO =:SKTNO and STATUS <> :STATUS] { "SKTNO": "001001", "STATUS": 4 } 2021-09-26 10:37:25,046 [6] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTPOS_ORDER where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:37:25,046 [6] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from XSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:37:25,062 [6] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTXSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:37:25,062 [6] INFO poslog - [/POSSRV/cyapi/pos/order/getmaxjlbh_response]_processTime[24ms]_][3d77a060-7d5f-4027-8d1f-b27b9342dd9a] { "Code": "0", "Msg": "操作成功", "Tips": null, "Data": { "storeCode": "1", "ddly": null, "ddlx": null, "orderFunction": 0, "sktno": "001001", "jlbh": "106", "orderNo": null } } 2021-09-26 10:37:32,655 [21] INFO poslog - [传入串][bea3265b-bf63-4e6d-a065-77d3987caccf] "{\"sys_key\":\"test123\",\"Params_json\":{\"mac\":\"paopao\",\"personCode\":\"99988\",\"version\":\"\",\"password\":\"1\",\"storeCode\":\"1\",\"sktno\":\"001001\",\"anthCode\":\"\"},\"requestId\":\"DF2BBE02-B2AA-4FCD-8D58-A256C3DD9E71\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:38\",\"format\":\"json\",\"sign\":\"78372DA7208D1E31EC102FE8236E7E12\"}" 2021-09-26 10:37:32,655 [21] INFO poslog - [/POSSRV/cyapi/pos/common/login][bea3265b-bf63-4e6d-a065-77d3987caccf] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:38", "format": "json", "version": "1.0", "sign": "78372DA7208D1E31EC102FE8236E7E12", "Params_json": { "mac": "paopao", "personCode": "99988", "version": "", "password": "1", "storeCode": "1", "sktno": "001001", "anthCode": "" }, "secretkey": null, "token": null, "requestId": "DF2BBE02-B2AA-4FCD-8D58-A256C3DD9E71", "companyCode": null } 2021-09-26 10:37:32,655 [21] INFO poslog - [Login][GetPerson] "select A.LOGIN_PASSWORD,A.OPER_STATION,A.PERSON_ID from XTCZY A,RYXX B where A.PERSON_ID=B.PERSON_ID and B.RYDM=:RYDM " 2021-09-26 10:37:32,655 [21] INFO poslog - [SQL][select A.LOGIN_PASSWORD,A.OPER_STATION,A.PERSON_ID from XTCZY A,RYXX B where A.PERSON_ID=B.PERSON_ID and B.RYDM=:RYDM ] { "RYDM": "99988" } 2021-09-26 10:37:32,655 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:37:32,671 [21] INFO poslog - [SQL][ select MSG_ID,VALUE,CAPTION,LX from XTCZY_POSQX where PERSON_ID =:PERSON_ID] { "PERSON_ID": 93 } 2021-09-26 10:37:32,671 [21] INFO poslog - [SQL][select STATUS from POS_MONITOR where SKTNO=:SKTNO and FDBH=:FDBH ] { "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:37:32,687 [21] INFO poslog - [SQL][ update POS_MONITOR set STATUS=1,PERSON_ID=:PERSON_ID,CAL_VERSION=:CAL_VERSION where SKTNO=:SKTNO and FDBH=:FDBH] { "PERSON_ID": 93, "CAL_VERSION": "", "SKTNO": "001001", "FDBH": "1" } 2021-09-26 10:37:32,687 [21] INFO poslog - [SQL][select A.PERSON_ID,A.PERSON_NAME,A.RYDM,A.DEPTID ,B.DEPT_NAME,A.SHOPID from RYXX A,BM B where A.DEPTID=B.DEPTID AND B.STATUS =0 AND A.SHOPID = :SHOPID] { "SHOPID": 0 } 2021-09-26 10:37:32,687 [21] INFO poslog - [SQL][SELECT * from ( select DISTINCT L.SPFL,L.NAME,L.SPFLID from SPXX X, SPFL L,GTSP G WHERE substr(X.SPFL,1,2) = L.SPFL AND length(L.SPFL)=2 AND G.SP_ID=X.SP_ID AND G.DEPTID=:DEPTID ) WHERE ROWNUM >=0 and ROWNUM <=30 order by SPFL ] { "MINPAGESIZE": 0, "MAXPAGESIZE": 30, "DEPTID": "18" } 2021-09-26 10:37:32,704 [21] INFO poslog - [SQL][SELECT * from ( select NAME,SPCODE,BARCODE from SPXX where STATUS in (0,4,3,5) AND SHOPID =:SHOPID AND FDBH =:FDBH ORDER BY BARCODE,SPFL ) WHERE ROWNUM >=0 and ROWNUM <=30 ] { "SHOPID": 0, "FDBH": "1", "MAXPAGESIZE": 30 } 2021-09-26 10:37:32,707 [21] INFO poslog - [SQL][select ID,NAME,PYM,BJ_ZZJH,BJ_ZZXS,BJ_YJJX,BJ_GTSP from SPJX ] {} 2021-09-26 10:37:32,707 [21] INFO poslog - [SQL][select * from (select A.CODE,A.NAME,A.TYPE,nvl(A.YHQID,-1) YHQID,A.ZLCLFS,A.XSSX,A.HL,A.YEDY from SKFS A where A.CODE in (select g.SKFS from ZFSXDY_SKFS g, SKT s where s.SKTNO = :SKTNO and s.ZFSX = g.JLBH) UNION select A.CODE,A.NAME,A.TYPE,nvl(A.YHQID,-1) YHQID,A.ZLCLFS,A.XSSX,A.HL,A.YEDY from SKFS A where A.CODE in (select SKFSID from SKT_SKFS where SKTNO=:SKTNO)) a order by a.XSSX,a.CODE] { "SKTNO": "001001" } 2021-09-26 10:37:32,707 [21] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 1 } 2021-09-26 10:37:32,707 [21] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 4 } 2021-09-26 10:37:32,718 [21] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 5 } 2021-09-26 10:37:32,718 [21] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 6 } 2021-09-26 10:37:32,718 [21] INFO poslog - [SQL][select ISCODED from YHQDEF where YHQID=:YHQID ] { "YHQID": 8 } 2021-09-26 10:37:32,718 [21] INFO poslog - [/POSSRV/cyapi/pos/common/login_response]_processTime[68ms]_][bea3265b-bf63-4e6d-a065-77d3987caccf] { "Code": "0", "Msg": null, "Tips": null, "Data": { "cashierCode": "99988", "cashierId": 93, "cashierName": "lzj_cs", "cashierDeptCode": "0001", "cashierDeptId": "18", "cashierDeptName": "一号门店", "shopName": null, "shopId": 0, "configs": [ { "id": 12, "value": "5", "desc": "人员代码长度" }, { "id": 1101002002, "value": "10", "desc": "商品编码长度" }, { "id": 1500000002, "value": "3", "desc": "柜组版销售终端小票打印份数" } ], "personList": [], "goodsList": [ { "name": "大礼包", "code": "900001", "barcode": "2190000100002", "price": null, "classType": null, "classTypeName": null } ], "spflList": null, "payList": [ { "payCode": 1, "payName": "折扣券", "payType": 4, "yhqId": 1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 4, "payName": "测试石基", "payType": 20, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 5, "payName": "订单", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 6, "payName": "方法", "payType": 6, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 7, "payName": "测试比例", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 8, "payName": "测试", "payType": 4, "yhqId": 4, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 9, "payName": "现金", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 10, "payName": "测试2", "payType": 4, "yhqId": 5, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 11, "payName": "www", "payType": 2, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 12, "payName": "11", "payType": 0, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 13, "payName": "满百抵", "payType": 16, "yhqId": -1, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 14, "payName": "测试收款方式", "payType": 19, "yhqId": -1, "changeType": 1, "zlclfs": 1, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 15, "payName": "CESXXXX", "payType": 4, "yhqId": 6, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 18, "payName": "CEEEE", "payType": 3, "yhqId": 7, "changeType": 1, "zlclfs": 1, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 }, { "payCode": 19, "payName": "qqqqq", "payType": 4, "yhqId": 8, "changeType": 0, "zlclfs": 0, "xssx": 0, "isCoded": 0, "rate": "1", "yedy": 0 } ], "freetax_configs": [], "countryList": [], "permissionsList": [ { "msgId": "805", "value": "1", "caption": "班报", "lx": "0" }, { "msgId": "807", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "810", "value": "1", "caption": "销售退货", "lx": "1" }, { "msgId": "813", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "849", "value": "1", "caption": "银行查询", "lx": "1" }, { "msgId": "812", "value": "1", "caption": "更改口令", "lx": "0" }, { "msgId": "833", "value": "1", "caption": "销售", "lx": "0" }, { "msgId": "847", "value": "1", "caption": "银行接口", "lx": "1" }, { "msgId": "852", "value": "1", "caption": "银行消费", "lx": "0" }, { "msgId": "853", "value": "1", "caption": "银行结算", "lx": "0" }, { "msgId": "801", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "808", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "811", "value": "1", "caption": "取消商品", "lx": "0" }, { "msgId": "812", "value": "1", "caption": "更改口令", "lx": "1" }, { "msgId": "814", "value": "1", "caption": "补打小票", "lx": "1" }, { "msgId": "849", "value": "1", "caption": "银行查询", "lx": "0" }, { "msgId": "851", "value": "1", "caption": "银行签到", "lx": "1" }, { "msgId": "803", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "805", "value": "1", "caption": "班报", "lx": "1" }, { "msgId": "806", "value": "1", "caption": "日报", "lx": "1" }, { "msgId": "806", "value": "1", "caption": "日报", "lx": "0" }, { "msgId": "811", "value": "1", "caption": "取消商品", "lx": "1" }, { "msgId": "813", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "815", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "837", "value": "1", "caption": "收货", "lx": "0" }, { "msgId": "847", "value": "1", "caption": "银行接口", "lx": "0" }, { "msgId": "848", "value": "1", "caption": "银行重打印", "lx": "0" }, { "msgId": "852", "value": "1", "caption": "银行消费", "lx": "1" }, { "msgId": "854", "value": "1", "caption": "银行撤销", "lx": "0" }, { "msgId": "802", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "804", "value": "1", "caption": "培训模式", "lx": "1" }, { "msgId": "807", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "809", "value": "1", "caption": "前台折扣", "lx": "0" }, { "msgId": "821", "value": "1", "caption": "盘点", "lx": "0" }, { "msgId": "848", "value": "1", "caption": "银行重打印", "lx": "1" }, { "msgId": "803", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "809", "value": "1", "caption": "前台折扣", "lx": "1" }, { "msgId": "814", "value": "1", "caption": "补打小票", "lx": "0" }, { "msgId": "816", "value": "1", "caption": "取消交易", "lx": "0" }, { "msgId": "821", "value": "1", "caption": "盘点", "lx": "1" }, { "msgId": "833", "value": "1", "caption": "销售", "lx": "1" }, { "msgId": "851", "value": "1", "caption": "银行签到", "lx": "0" }, { "msgId": "853", "value": "1", "caption": "银行结算", "lx": "1" }, { "msgId": "854", "value": "1", "caption": "银行撤销", "lx": "1" }, { "msgId": "801", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "808", "value": "1", "caption": "预留权限", "lx": "1" }, { "msgId": "810", "value": "1", "caption": "销售退货", "lx": "0" }, { "msgId": "815", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "802", "value": "1", "caption": "预留权限", "lx": "0" }, { "msgId": "804", "value": "1", "caption": "培训模式", "lx": "0" }, { "msgId": "816", "value": "1", "caption": "取消交易", "lx": "1" }, { "msgId": "837", "value": "1", "caption": "收货", "lx": "1" } ], "spjxList": [ { "name": "常规机", "code": "CGJ", "id": 1, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 0, "BJ_GTSP": 0 }, { "name": "特价机", "code": "TJJ", "id": 2, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 0, "BJ_GTSP": 0 }, { "name": "样机", "code": "YJ", "id": 3, "BJ_ZZJH": 0, "BJ_ZZXS": 0, "BJ_YJJX": 1, "BJ_GTSP": 0 } ], "tableList": [], "skt": { "sktno": "001001", "storeCode": "1", "permit_gz": 1, "permit_bar": -1, "permit_cy": -1, "permit_supermarket": -1, "permit_zg": 0, "permit_zk": 0, "possrvid": 0, "permit_th": 0, "permit_bb": 0, "permit_freetax": -1, "printType": 0, "qsfs": 0, "csmcCode": -1, "mcName": "一号门店", "length_verify_cashcard": 0, "length_verify_membercard": 0, "msdbh": "", "msdbm": "", "msdmc": "", "groupId": "1", "crmId": "1", "groupName": "测试组", "URL_ZT": "1", "URL_POS": "1", "slfs": "", "slfs_Gold": 4, "msjfbj": null, "ysjfbj": null, "ztcxms": null, "novip_sptype": "0", "checkVipBuyerInfo": 0, "sktconfigList": [ { "lx": "1", "id": "2", "value": "" }, { "lx": "2", "id": "1", "value": "1" }, { "lx": "3", "id": "1", "value": "" }, { "lx": "4", "id": "1", "value": "" }, { "lx": "4", "id": "2", "value": "" }, { "lx": "4", "id": "3", "value": "" }, { "lx": "4", "id": "4", "value": "" }, { "lx": "4", "id": "5", "value": "" }, { "lx": "4", "id": "6", "value": "" }, { "lx": "4", "id": "7", "value": "" }, { "lx": "4", "id": "8", "value": "" }, { "lx": "4", "id": "9", "value": "" }, { "lx": "4", "id": "10", "value": "" }, { "lx": "5", "id": "2", "value": "" }, { "lx": "5", "id": "3", "value": "2" }, { "lx": "5", "id": "4", "value": "" }, { "lx": "5", "id": "6", "value": "" }, { "lx": "5", "id": "7", "value": "" }, { "lx": "5", "id": "8", "value": "" }, { "lx": "5", "id": "9", "value": "" }, { "lx": "5", "id": "10", "value": "" }, { "lx": "6", "id": "5", "value": "" }, { "lx": "7", "id": "6", "value": "" }, { "lx": "7", "id": "7", "value": "" }, { "lx": "8", "id": "7", "value": "" }, { "lx": "8", "id": "9", "value": "" }, { "lx": "9", "id": "1", "value": "" }, { "lx": "9", "id": "2", "value": "" }, { "lx": "9", "id": "3", "value": "" }, { "lx": "9", "id": "4", "value": "" }, { "lx": "9", "id": "5", "value": "" }, { "lx": "9", "id": "6", "value": "" }, { "lx": "9", "id": "7", "value": "" }, { "lx": "9", "id": "8", "value": "" }, { "lx": "9", "id": "9", "value": "" }, { "lx": "10", "id": "1", "value": "" }, { "lx": "10", "id": "2", "value": "" } ] } } } 2021-09-26 10:37:32,859 [6] INFO poslog - [传入串][9bfbbdff-1a8f-43ee-a060-f3bb81b9be54] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\"},\"requestId\":\"F53AAC44-5A61-4026-9C2E-3F591D05F0E3\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:38\",\"format\":\"json\",\"sign\":\"D13AD2E11C6852C9D1ADCC5A406C8471\"}" 2021-09-26 10:37:32,859 [6] INFO poslog - [/POSSRV/cyapi/pos/common/getjdinfo][9bfbbdff-1a8f-43ee-a060-f3bb81b9be54] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:38", "format": "json", "version": "1.0", "sign": "D13AD2E11C6852C9D1ADCC5A406C8471", "Params_json": { "storeCode": "1" }, "secretkey": null, "token": null, "requestId": "F53AAC44-5A61-4026-9C2E-3F591D05F0E3", "companyCode": null } 2021-09-26 10:37:32,859 [6] INFO poslog - [SQL][ SELECT B.DEPTID,FD.FDBH,FD.FDMC from FDDEF F ,FDDEF FD,BM B WHERE B.DEPTID = F.DEPTID AND FD.FDLXDM = 0 AND F.FDBH=:FDBH AND F.PSZX = FD.DEPTID] { "FDBH": "1" } 2021-09-26 10:37:32,859 [6] INFO poslog - [SQL][select ID,NAME,THSX,CHFS,WLSX from SHFS] {} 2021-09-26 10:37:32,859 [6] INFO poslog - [SQL][select JLBH,CODE,QYMC from SHQY] {} 2021-09-26 10:37:32,874 [6] INFO poslog - [SQL][select NAME,LXFY from SHLX] {} 2021-09-26 10:37:32,874 [6] INFO poslog - [/POSSRV/cyapi/pos/common/getjdinfo_response]_processTime[15ms]_][9bfbbdff-1a8f-43ee-a060-f3bb81b9be54] { "Code": "0", "Msg": "成功", "Tips": null, "Data": { "kcdd": { "fdmc": "配送中心", "deptid": 18 }, "shfslist": [ { "id": 3, "name": "配送送货", "thsx": "0", "chfs": "0", "wlsx": "2" }, { "id": 1, "name": "门店送货", "thsx": "0", "chfs": "1", "wlsx": "2" }, { "id": 2, "name": "门店自提", "thsx": "1", "chfs": "1", "wlsx": "2" }, { "id": 4, "name": "配送自提", "thsx": "1", "chfs": "0", "wlsx": "2" } ], "shqylist": { "districtList": [ { "code": "03", "name": "广东", "jlbh": 13, "citys": [ { "code": "0301", "name": "广州", "parent": "03", "jlbh": 14, "areas": [ { "code": "030101", "name": "白云区", "parent": "0301", "jlbh": 15, "streets": [] } ] } ] }, { "code": "01", "name": "安徽", "jlbh": 1, "citys": [ { "code": "0101", "name": "合肥", "parent": "01", "jlbh": 2, "areas": [ { "code": "010102", "name": "庐阳区", "parent": "0101", "jlbh": 4, "streets": [] }, { "code": "010103", "name": "长丰区", "parent": "0101", "jlbh": 5, "streets": [] }, { "code": "010101", "name": "蜀山区", "parent": "0101", "jlbh": 3, "streets": [] } ] } ] }, { "code": "02", "name": "江苏", "jlbh": 6, "citys": [ { "code": "0202", "name": "苏州", "parent": "02", "jlbh": 8, "areas": [ { "code": "020202", "name": "吴中区", "parent": "0202", "jlbh": 12, "streets": [] }, { "code": "020201", "name": "姑苏区", "parent": "0202", "jlbh": 11, "streets": [] } ] }, { "code": "0201", "name": "玄武区", "parent": "02", "jlbh": 10, "areas": [ { "code": "020102", "name": "玄武区", "parent": "0201", "jlbh": 10, "streets": [] }, { "code": "020101", "name": "鼓楼区", "parent": "0201", "jlbh": 9, "streets": [] } ] } ] } ] }, "shlxlist": [ { "name": "市内", "money": "10" }, { "name": "市外", "money": "15" } ] } } 2021-09-26 10:37:33,063 [15] INFO poslog - [传入串][bc226853-2bf1-4a9d-9c2d-bba44867cb43] "{\"sys_key\":\"test123\",\"Params_json\":{\"operatorCode\":\"99988\",\"orderFunction\":0,\"storeCode\":\"1\",\"tableNo\":\"\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"oldOrderNo\":\"\"},\"requestId\":\"4AA42F56-17BE-4C34-848C-51D0447E49B0\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:38\",\"format\":\"json\",\"sign\":\"B4AE143BB5FA7E157AC0817BE2BCCF0D\"}" 2021-09-26 10:37:33,063 [15] INFO poslog - [/POSSRV/cyapi/pos/order/create][bc226853-2bf1-4a9d-9c2d-bba44867cb43] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:38", "format": "json", "version": "1.0", "sign": "B4AE143BB5FA7E157AC0817BE2BCCF0D", "Params_json": { "operatorCode": "99988", "orderFunction": 0, "storeCode": "1", "tableNo": "", "sktno": "001001", "ddly": "0", "ddlx": "0", "oldOrderNo": "" }, "secretkey": null, "token": null, "requestId": "4AA42F56-17BE-4C34-848C-51D0447E49B0", "companyCode": null } 2021-09-26 10:37:33,063 [15] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:37:33,063 [15] INFO poslog - [SQL][select S_POS_ORDER.Nextval as JLBH from dual ] {} 2021-09-26 10:37:33,077 [15] INFO poslog - [SQL][insert into POS_ORDER(ORDERNO,FDBH,SKTNO,DDLY,DDGN,JYLX,STATUS,KSSJ,SMG_HYID,SKY,OLDORDERNO,SKTNO_OLD,JLBH_OLD)values (:ORDERNO,:FDBH,:SKTNO,:DDLY,:DDGN,:JYLX,:STATUS,SYSDATE,:SMG_HYID,:SKY,:OLDORDERNO,:SKTNO_OLD,:JLBH_OLD)] { "ORDERNO": "10120210926103733077", "FDBH": 1, "SKTNO": "001001", "DDLY": 0, "JYLX": 0, "STATUS": 0, "DDGN": 0, "KSSJ": "2021-09-26T10:37:33.0778762+08:00", "SMG_HYID": null, "SKY": 93, "OLDORDERNO": "", "SKTNO_OLD": "", "JLBH_OLD": 0, "BJ_FREETAX": 0, "THYY": null, "TABLEID": "", "DINNERS": 0 } 2021-09-26 10:37:33,077 [15] INFO poslog - [/POSSRV/cyapi/pos/order/create_response]_processTime[24ms]_][bc226853-2bf1-4a9d-9c2d-bba44867cb43] { "Code": "0", "Msg": null, "Tips": null, "Data": { "orderNo": "10120210926103733077" } } 2021-09-26 10:37:41,343 [21] INFO poslog - [传入串][c736b48b-ed14-4272-9624-6b68b8331e52] "{\"sys_key\":\"test123\",\"Params_json\":{\"needGoodsList\":0,\"personCode\":\"99997\",\"storeCode\":\"1\"},\"requestId\":\"7CE3968F-FF93-4D87-BAF3-40DBF86DB210\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:47\",\"format\":\"json\",\"sign\":\"46444CF8727EC9C782FD8E0DB546D394\"}" 2021-09-26 10:37:41,343 [21] INFO poslog - [/POSSRV/cyapi/pos/common/getperson][c736b48b-ed14-4272-9624-6b68b8331e52] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:47", "format": "json", "version": "1.0", "sign": "46444CF8727EC9C782FD8E0DB546D394", "Params_json": { "needGoodsList": 0, "personCode": "99997", "storeCode": "1" }, "secretkey": null, "token": null, "requestId": "7CE3968F-FF93-4D87-BAF3-40DBF86DB210", "companyCode": null } 2021-09-26 10:37:41,343 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.WORK_TYPE=:WORK_TYPE and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1 AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "WORK_TYPE": "2", "FDBH": "1" } 2021-09-26 10:37:41,359 [21] INFO poslog - [/POSSRV/cyapi/pos/common/getperson_response]_processTime[5ms]_][c736b48b-ed14-4272-9624-6b68b8331e52] { "Code": "0", "Msg": "成功", "Tips": null, "Data": { "personId": 32, "personCode": "99997", "personName": "接吻猫", "personDeptId": 57, "personDeptCode": "0001010102", "personDeptName": "谢瑞麟", "goodsList": null } } 2021-09-26 10:37:53,890 [21] INFO poslog - [传入串][06feec54-e2a2-4f10-9fdb-8596f29dd3ca] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926103733077\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":2,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":1,\"ticktInx\":0},\"requestId\":\"73DA887C-67BA-46F3-8D9A-9D1DA0989FA5\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:41:59\",\"format\":\"json\",\"sign\":\"63900A9E61197608B0441AECC6B1B941\"}" 2021-09-26 10:37:53,890 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][06feec54-e2a2-4f10-9fdb-8596f29dd3ca] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:41:59", "format": "json", "version": "1.0", "sign": "63900A9E61197608B0441AECC6B1B941", "Params_json": { "orderNo": "10120210926103733077", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 2, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 1, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "73DA887C-67BA-46F3-8D9A-9D1DA0989FA5", "companyCode": null } 2021-09-26 10:37:53,890 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:37:53,890 [21] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:37:53,890 [21] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:37:53,905 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:37:53,905 [21] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:37:53,921 [21] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:37:53\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":2}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:37:53,921 [21] INFO poslog - [Platform请求][加密串] "AFECB55C7E8685B32E3E89B248EC4DC1" 2021-09-26 10:37:53,937 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[56ms]_][06feec54-e2a2-4f10-9fdb-8596f29dd3ca] { "Code": "2001", "Msg": "商品的销售数量1超过了销售部门可用库存0", "Tips": "商品的销售数量1超过了销售部门可用库存0", "Data": null } 2021-09-26 10:39:12,218 [6] INFO poslog - [传入串][8a68d7c8-f5ae-4d51-867e-ff2c25ba48d5] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:43:17\",\"format\":\"json\",\"sign\":\"D5967A2E24C3FBCAC2CD892E44B4A7EA\"}" 2021-09-26 10:39:12,218 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][8a68d7c8-f5ae-4d51-867e-ff2c25ba48d5] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:43:17", "format": "json", "version": "1.0", "sign": "D5967A2E24C3FBCAC2CD892E44B4A7EA", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:39:12,218 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[9ms]_][8a68d7c8-f5ae-4d51-867e-ff2c25ba48d5] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:41:12,811 [21] INFO poslog - [传入串][393203a4-2a80-4917-b2de-bbc6f358c395] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:45:18\",\"format\":\"json\",\"sign\":\"156E5D20000850F4F53CDE46216C31C9\"}" 2021-09-26 10:41:12,811 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][393203a4-2a80-4917-b2de-bbc6f358c395] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:45:18", "format": "json", "version": "1.0", "sign": "156E5D20000850F4F53CDE46216C31C9", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:41:12,811 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[11ms]_][393203a4-2a80-4917-b2de-bbc6f358c395] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:41:19,811 [20] INFO poslog - [传入串][2793e3ad-b0ab-4d4a-86b0-20d8cca3a4db] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926102946798\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":1,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":1,\"ticktInx\":0},\"requestId\":\"5B6CA369-FE41-44C1-B2E5-1ED5F2003AE9\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:34:03\",\"format\":\"json\",\"sign\":\"FC8D019074A9618C48056D194EDCCE0D\"}" 2021-09-26 10:41:19,811 [20] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][2793e3ad-b0ab-4d4a-86b0-20d8cca3a4db] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:34:03", "format": "json", "version": "1.0", "sign": "FC8D019074A9618C48056D194EDCCE0D", "Params_json": { "orderNo": "10120210926102946798", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 1, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 1, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "5B6CA369-FE41-44C1-B2E5-1ED5F2003AE9", "companyCode": null } 2021-09-26 10:41:19,811 [20] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926102946798", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:41:19,811 [20] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:41:19,811 [20] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:41:19,826 [20] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:41:19,826 [20] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:41:19,826 [20] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:41:19\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":1}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:41:19,826 [20] INFO poslog - [Platform请求][加密串] "3EFADA486AA27F28D7098DEDA065BDC1" 2021-09-26 10:41:19,842 [20] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926102946798" } 2021-09-26 10:41:19,858 [20] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926102946798", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:41:19,873 [20] INFO poslog - [SQL][select ID,NAME,APPKEY,APPSECRET,URL,VAL1,VAL2 from POS_INTERFACE WHERE ID=:ID AND (FDBH=-1 OR FDBH=:FDBH)] { "ID": 98, "FDBH": "1" } 2021-09-26 10:41:19,889 [20] INFO poslog - [SQL][ select max(TCKT_INX) TCKT_INX, NVL(max(CRMINX),-1) CRMINX from ORDER_ITEM WHERE ORDERNO= :ORDERNO AND TCKT_INX= :TCKT_INX ] { "ORDERNO": "10120210926102946798", "TCKT_INX": 0 } 2021-09-26 10:41:20,029 [20] INFO poslog - [SQL][ select INX,TCKT_INX,YYY from ORDER_ITEM WHERE ORDERNO= :ORDERNO AND TCKT_INX= :TCKT_INX order by inx desc ] { "ORDERNO": "10120210926102946798", "DEPTID": 57, "TCKT_INX": 0 } 2021-09-26 10:41:20,061 [20] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YYY,STAMP,CXSPBJ,XSDD_JLBH,SPJX,YDBJ) values (:ORDERNO,:SKTNO,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YYY,:STAMP,:CXSPBJ,:XSDD_JLBH,:SPJX,:YDBJ)] { "ORDERNO": "10120210926102946798", "SKTNO": "001001", "TCKT_INX": 0, "INX": 1, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 1, "GUID": "6bed1b2a03d84fa58fda3d735065a182", "INPUTCODE": "2100072801", "CODE": "2100072801", "YYY": 32, "STAMP": "0", "CXSPBJ": "0", "XSDD_JLBH": null, "SPJX": 1, "YDBJ": 0, "TASTEID": null, "DESCMSG": null } 2021-09-26 10:41:20,082 [20] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO AND TCKT_INX = :TCKT_INX AND INX = :INX] { "ORDERNO": "10120210926102946798", "TCKT_INX": 0, "INX": 1 } 2021-09-26 10:41:20,085 [20] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926102946798", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:41:20,174 [20] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[316ms]_][2793e3ad-b0ab-4d4a-86b0-20d8cca3a4db] { "Code": "0", "Msg": "", "Tips": "", "Data": { "ysDateList": null, "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "6bed1b2a03d84fa58fda3d735065a182", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 1, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": null, "specifications": null, "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 0, "ctrlNegSell": 0, "tasteId": null, "desc": null } } 2021-09-26 10:42:04,842 [21] INFO poslog - [传入串][04a1812c-00dc-4d6d-8ac6-bcd2c2635281] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926103733077\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":2,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":1,\"ticktInx\":0},\"requestId\":\"F00D1E8F-699F-4921-BFA2-27C343F32E0B\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:46:10\",\"format\":\"json\",\"sign\":\"9739A2972F75EF2253CCFF3BEB60B44D\"}" 2021-09-26 10:42:04,842 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][04a1812c-00dc-4d6d-8ac6-bcd2c2635281] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:46:10", "format": "json", "version": "1.0", "sign": "9739A2972F75EF2253CCFF3BEB60B44D", "Params_json": { "orderNo": "10120210926103733077", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 2, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 1, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "F00D1E8F-699F-4921-BFA2-27C343F32E0B", "companyCode": null } 2021-09-26 10:42:04,842 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:42:04,857 [21] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:42:04,857 [21] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:42:04,857 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:42:04,857 [21] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:42:04,873 [21] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:42:04\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":2}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:42:04,873 [21] INFO poslog - [Platform请求][加密串] "0C34BF68FB05D2E53BE7D39929A4758C" 2021-09-26 10:42:04,873 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[31ms]_][04a1812c-00dc-4d6d-8ac6-bcd2c2635281] { "Code": "2001", "Msg": "商品的销售数量1超过了销售部门可用库存0", "Tips": "商品的销售数量1超过了销售部门可用库存0", "Data": null } 2021-09-26 10:43:13,547 [20] INFO poslog - [传入串][29d3b936-3062-45e6-a1a6-13da485d2af1] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:47:19\",\"format\":\"json\",\"sign\":\"553DBD903C09EA71C05B29C2C4020E5C\"}" 2021-09-26 10:43:13,547 [20] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][29d3b936-3062-45e6-a1a6-13da485d2af1] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:47:19", "format": "json", "version": "1.0", "sign": "553DBD903C09EA71C05B29C2C4020E5C", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:43:13,558 [20] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[11ms]_][29d3b936-3062-45e6-a1a6-13da485d2af1] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:45:14,779 [18] INFO poslog - [传入串][3f490d98-56d5-440d-8508-24b092280245] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:49:20\",\"format\":\"json\",\"sign\":\"52D1E1AB94EF717BC57BF18CF04779B4\"}" 2021-09-26 10:45:14,779 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][3f490d98-56d5-440d-8508-24b092280245] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:49:20", "format": "json", "version": "1.0", "sign": "52D1E1AB94EF717BC57BF18CF04779B4", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:45:14,794 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[10ms]_][3f490d98-56d5-440d-8508-24b092280245] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:47:17,090 [6] INFO poslog - [传入串][0b5bbaa4-8e23-4a45-a0a0-bad1425442a4] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:51:22\",\"format\":\"json\",\"sign\":\"150CB3473AC0F858E41F03BDA86DD10E\"}" 2021-09-26 10:47:17,090 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][0b5bbaa4-8e23-4a45-a0a0-bad1425442a4] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:51:22", "format": "json", "version": "1.0", "sign": "150CB3473AC0F858E41F03BDA86DD10E", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:47:17,106 [6] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[10ms]_][0b5bbaa4-8e23-4a45-a0a0-bad1425442a4] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:49:18,871 [17] INFO poslog - [传入串][04600594-23c3-4844-8528-d51c96ea78d0] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:53:24\",\"format\":\"json\",\"sign\":\"018DB136356B386964ECC5BDBCD6B460\"}" 2021-09-26 10:49:18,871 [17] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][04600594-23c3-4844-8528-d51c96ea78d0] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:53:24", "format": "json", "version": "1.0", "sign": "018DB136356B386964ECC5BDBCD6B460", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:49:18,871 [17] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[10ms]_][04600594-23c3-4844-8528-d51c96ea78d0] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:49:19,933 [21] INFO poslog - [传入串][2fcb631d-8964-4924-bcea-fe0737816b38] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:53:25\",\"format\":\"json\",\"sign\":\"D624DC4916CBD9CEA210064D4E0E4E39\"}" 2021-09-26 10:49:19,949 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][2fcb631d-8964-4924-bcea-fe0737816b38] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:53:25", "format": "json", "version": "1.0", "sign": "D624DC4916CBD9CEA210064D4E0E4E39", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:49:19,949 [21] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[13ms]_][2fcb631d-8964-4924-bcea-fe0737816b38] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:51:20,636 [18] INFO poslog - [传入串][4144e453-bfc9-4fb0-8646-0c0bc2d4d9ef] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:55:26\",\"format\":\"json\",\"sign\":\"3762A3D00B9EEFEE438095971FC3CFBB\"}" 2021-09-26 10:51:20,636 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][4144e453-bfc9-4fb0-8646-0c0bc2d4d9ef] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:55:26", "format": "json", "version": "1.0", "sign": "3762A3D00B9EEFEE438095971FC3CFBB", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:51:20,636 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[10ms]_][4144e453-bfc9-4fb0-8646-0c0bc2d4d9ef] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:51:27,901 [18] INFO poslog - [传入串][449b89f2-7d25-4b24-8f3f-4403f521a75f] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926103733077\",\"personCode\":\"99997\",\"permit_zg\":\"0\",\"orderFunction\":\"8\",\"machineType\":1,\"giftGoods\":0,\"storeCode\":\"1\",\"stamp\":\"0\",\"sktno\":\"001001\",\"barcode\":\"2100072801\",\"count\":\"1\",\"ddly\":\"0\",\"ddlx\":\"0\",\"ckdd\":1,\"ticktInx\":0},\"requestId\":\"E04F60B6-3597-4E67-88F8-6A7D6384D13A\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:55:33\",\"format\":\"json\",\"sign\":\"1E968D4EC1093BCDB88104070A7A366C\"}" 2021-09-26 10:51:27,917 [18] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods][449b89f2-7d25-4b24-8f3f-4403f521a75f] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:55:33", "format": "json", "version": "1.0", "sign": "1E968D4EC1093BCDB88104070A7A366C", "Params_json": { "orderNo": "10120210926103733077", "personCode": "99997", "permit_zg": "0", "orderFunction": "8", "machineType": 1, "giftGoods": 0, "storeCode": "1", "stamp": "0", "sktno": "001001", "barcode": "2100072801", "count": "1", "ddly": "0", "ddlx": "0", "ckdd": 1, "ticktInx": 0 }, "secretkey": null, "token": null, "requestId": "E04F60B6-3597-4E67-88F8-6A7D6384D13A", "companyCode": null } 2021-09-26 10:51:27,919 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:51:27,920 [18] INFO poslog - [SQL][select SP_ID from SPBARCODE where BARCODE =:BARCODE] { "BARCODE": "2100072801" } 2021-09-26 10:51:27,920 [18] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:51:27,920 [18] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99997", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:51:27,933 [18] INFO poslog - [SQL][select W.DEPTID,B.BMDM from GTSP W,BM B where W.DEPTID=B.DEPTID and SHOPID=:SHOPID and SP_ID =:SP_ID] { "SHOPID": 268, "SP_ID": 2615 } 2021-09-26 10:51:27,933 [18] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:51:27\",\"data\":{\"List\":[{\"SPCODE\":\"2100072801\",\"BMDM\":\"0001010102\",\"SPJX\":1}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:51:27,933 [18] INFO poslog - [Platform请求][加密串] "7612928607834EF9E8B0ACEE6DB1FBE0" 2021-09-26 10:51:27,948 [18] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:51:27,948 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:51:27,948 [18] INFO poslog - [SQL][ select max(TCKT_INX) TCKT_INX, NVL(max(CRMINX),-1) CRMINX from ORDER_ITEM WHERE ORDERNO= :ORDERNO AND TCKT_INX= :TCKT_INX ] { "ORDERNO": "10120210926103733077", "TCKT_INX": 0 } 2021-09-26 10:51:28,059 [18] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YYY,STAMP,CXSPBJ,XSDD_JLBH,SPJX,YDBJ) values (:ORDERNO,:SKTNO,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YYY,:STAMP,:CXSPBJ,:XSDD_JLBH,:SPJX,:YDBJ)] { "ORDERNO": "10120210926103733077", "SKTNO": "001001", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YYY": 32, "STAMP": "0", "CXSPBJ": "0", "XSDD_JLBH": null, "SPJX": 1, "YDBJ": 0, "TASTEID": null, "DESCMSG": null } 2021-09-26 10:51:28,059 [18] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO AND TCKT_INX = :TCKT_INX AND INX = :INX] { "ORDERNO": "10120210926103733077", "TCKT_INX": 0, "INX": 0 } 2021-09-26 10:51:28,059 [18] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:51:28,073 [18] INFO poslog - [/POSSRV/cyapi/pos/order/addgoods_response]_processTime[165ms]_][449b89f2-7d25-4b24-8f3f-4403f521a75f] { "Code": "0", "Msg": "", "Tips": "", "Data": { "ysDateList": null, "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": null, "specifications": null, "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 0, "ctrlNegSell": 0, "tasteId": null, "desc": null } } 2021-09-26 10:52:17,589 [18] INFO poslog - [传入串][d3e4a53f-6bf2-4883-a5ad-60256557d8fa] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926103733077\",\"jDBuyerInfo\":{\"address_area\":\"15\",\"bz\":\"家电测试\",\"address\":\"西安\",\"name\":\"测试\",\"phone\":\"11122223333\"},\"transferDate\":\"\",\"orderFunction\":8,\"jDDeliveryInfo\":{\"shrq\":\"2021-09-26\",\"shlx\":\"市内(10)元\",\"shfy\":\"10\",\"shfs\":\"3\",\"ckbm\":\"1\",\"azqy3\":\"030101.白云区\",\"azqy2\":\"0301.广州\",\"azqy1\":\"03.广东\"},\"storeCode\":\"1\",\"sktno\":\"001001\",\"jlbh\":\"107\",\"ddly\":\"0\",\"ddlx\":\"0\",\"promotionGoodsSelectSign\":0},\"requestId\":\"709288D7-F890-4688-ABA8-9846C916A0A9\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:56:23\",\"format\":\"json\",\"sign\":\"75FC88BBA201CBDC7633A175A24EF4E5\"}" 2021-09-26 10:52:17,589 [18] INFO poslog - [/POSSRV/cyapi/pos/order/prepare][d3e4a53f-6bf2-4883-a5ad-60256557d8fa] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:56:23", "format": "json", "version": "1.0", "sign": "75FC88BBA201CBDC7633A175A24EF4E5", "Params_json": { "orderNo": "10120210926103733077", "jDBuyerInfo": { "address_area": "15", "bz": "家电测试", "address": "西安", "name": "测试", "phone": "11122223333" }, "transferDate": "", "orderFunction": 8, "jDDeliveryInfo": { "shrq": "2021-09-26", "shlx": "市内(10)元", "shfy": "10", "shfs": "3", "ckbm": "1", "azqy3": "030101.白云区", "azqy2": "0301.广州", "azqy1": "03.广东" }, "storeCode": "1", "sktno": "001001", "jlbh": "107", "ddly": "0", "ddlx": "0", "promotionGoodsSelectSign": 0 }, "secretkey": null, "token": null, "requestId": "709288D7-F890-4688-ABA8-9846C916A0A9", "companyCode": null } 2021-09-26 10:52:17,641 [18] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO AND CXSPBJ>0] { "ORDERNO": "10120210926103733077", "GUID": "", "CXSPBJ": 100 } 2021-09-26 10:52:17,651 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:52:17,667 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:52:17,667 [18] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926103733077", "FDBH": 1 } 2021-09-26 10:52:17,698 [18] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:52:17,714 [18] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:17,714 [18] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:17,729 [18] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from POS_ORDER where SKTNO =:SKTNO and STATUS <> :STATUS] { "SKTNO": "001001", "STATUS": 4 } 2021-09-26 10:52:17,729 [18] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTPOS_ORDER where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:52:17,745 [18] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from XSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:52:17,745 [18] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTXSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:52:17,745 [18] INFO poslog - [SQL][select (GZKCSL-XSSL) KXSSL from GTSP where DEPTID=:DEPTID and SP_ID=:SP_ID] { "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:52:17,761 [18] INFO poslog - [SQL][select NVL(SUM(XSSL),0) YXSSL from ORDER_ITEM where ORDERNO =:ORDERNO AND DEPTID =:DEPTID AND SP_ID =:SP_ID] { "ORDERNO": "10120210926103733077", "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:52:17,778 [18] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926103733077", "SKFS": 7571 } 2021-09-26 10:52:17,792 [18] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926103733077", "SKFS": "", "STATUS": "1" } 2021-09-26 10:52:17,823 [18] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926103733077", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:52:17,839 [18] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077", "SKFS": 7571 } 2021-09-26 10:52:17,839 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:17,854 [18] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:52:17,854 [18] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:17,886 [18] INFO poslog - [PreparePaymoney10120210926103733077][] "" 2021-09-26 10:52:17,917 [18] INFO poslog - [SQL][ update POS_ORDER set XSJE =:XSJE,XFJLID =:XFJLID,JLBH =:JLBH,STATUS =:STATUS ,JYJF = :JYJF,PHONE=:PHONE,JZRQ =:JZRQ,TJSJ = :TJSJ,DZRQ=:DZRQ where ORDERNO =:ORDERNO ] { "XSJE": "1", "XFJLID": 0, "JLBH": "107", "JYJF": "0", "PHONE": "", "STATUS": 2, "JSSJ": "2021-09-26T10:52:17.9173853+08:00", "JZRQ": "2021-09-26T10:52:17.9173853+08:00", "PREJZRQ": "2021-09-26T10:52:17.9173853+08:00", "DZRQ": "2021-09-26T10:52:17.9173853+08:00", "TJSJ": "2021-09-26T10:52:18", "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:17,933 [18] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077", "GUID": "", "CXSPBJ": 0 } 2021-09-26 10:52:17,933 [18] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:52:17,933 [18] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077", "TCKT_INX": -1, "INX": -1 } 2021-09-26 10:52:17,933 [18] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:52:17,973 [18] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,JLBH,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YHJE,MBYH,JF,STAMP,YYY,TCKT_INX_OLD,INX_OLD,CXSPBJ,BGH,XSDD_JLBH,SPJX,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YHJE,:MBYH,:JF,:STAMP,:YYY,:TCKT_INX_OLD,:INX_OLD,:CXSPBJ,:BGH,:XSDD_JLBH,:SPJX,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926103733077", "SKTNO": "001001", "JLBH": "107", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YHJE": "0", "MBYH": "0", "JF": "0", "STAMP": "0", "CXSPBJ": "0", "YYY": 32, "TCKT_INX_OLD": 0, "INX_OLD": 0, "BGH": "01012021092610373307711", "XSDD_JLBH": "", "SPJX": 1, "ORDERNO_ORIGINAL": "", "FDBH_ORIGINAL": 0 } 2021-09-26 10:52:17,995 [18] INFO poslog - [SQL][ delete from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:18,011 [18] INFO poslog - [SQL][insert into ORDER_PERSON(ORDERNO,SKTNO,JLBH,TCKT_INX,YYY,DEPTID)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:YYY,:DEPTID)] { "ORDERNO": "10120210926103733077", "JLBH": "107", "SKTNO": "001001", "TCKT_INX": 0, "YYY": 32, "DEPTID": 57 } 2021-09-26 10:52:18,026 [18] INFO poslog - [SQL][insert into POS_ORDER_DELIVERY(ORDERNO,FDBH,ORDERNO_ORIGINAL,FDBH_ORIGINAL,SHRQ,CKBM,SHFS,SHLX,AZQY1,AZQY2,AZQY3,SHFY,PHONE,NAME,ADDRESS,ADDRESS_AREA,BZ)values (:ORDERNO,:FDBH,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL,:SHRQ,:CKBM,:SHFS,:SHLX,:AZQY1,:AZQY2,:AZQY3,:SHFY,:PHONE,:NAME,:ADDRESS,:ADDRESS_AREA,:BZ)] { "ORDERNO": "-1", "FDBH": -1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1, "SHRQ": "2021-09-26T00:00:00", "CKBM": "1", "SHFS": "3", "SHLX": "市内(10)元", "AZQY1": "03.广东", "AZQY2": "0301.广州", "AZQY3": "030101.白云区", "SHFY": "10", "PHONE": "11122223333", "NAME": "测试", "ADDRESS": "西安", "ADDRESS_AREA": "15", "BZ": "家电测试" } 2021-09-26 10:52:18,042 [18] INFO poslog - [SQL][ delete from ORDER_PAY where ORDERNO =:ORDERNO AND SKFS=(select code from skfs where type= 16)] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:52:18,073 [18] INFO poslog - [/POSSRV/cyapi/pos/order/prepare_response]_processTime[469ms]_][d3e4a53f-6bf2-4883-a5ad-60256557d8fa] { "Code": "0", "Msg": null, "Tips": null, "Data": { "serverBillId": "0", "totalCount": "1", "totalTaxAmount": "0", "totalAmount": "1", "totalDiscount": "0", "decMoney": "0", "decPreferentialMoney": "0", "goodsList": [ { "ysDateList": [], "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": "01012021092610373307711", "specifications": "", "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 1, "ctrlNegSell": 0, "tasteId": null, "desc": null } ], "ysDateList": [], "exchangeGoodsBillInfoList": [], "giftGoodsBillList": [], "salerInfoList": [], "storeCode": "1", "ddly": "0", "ddlx": null, "orderFunction": 8, "sktno": "001001", "jlbh": "107", "orderNo": "10120210926103733077" } } 2021-09-26 10:52:19,026 [21] INFO poslog - [传入串][8f4e14f4-735c-4098-a695-0094f1e1377a] "{\"sys_key\":\"test123\",\"Params_json\":{\"operatorCode\":\"99988\",\"orderFunction\":0,\"storeCode\":\"1\",\"tableNo\":\"\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"oldOrderNo\":\"\"},\"requestId\":\"EC12147A-B678-4ABF-AAAB-654469EEAAAE\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:56:24\",\"format\":\"json\",\"sign\":\"E4D7F911AE7EF9F14FB8010FA5BA5803\"}" 2021-09-26 10:52:19,026 [21] INFO poslog - [/POSSRV/cyapi/pos/order/create][8f4e14f4-735c-4098-a695-0094f1e1377a] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:56:24", "format": "json", "version": "1.0", "sign": "E4D7F911AE7EF9F14FB8010FA5BA5803", "Params_json": { "operatorCode": "99988", "orderFunction": 0, "storeCode": "1", "tableNo": "", "sktno": "001001", "ddly": "0", "ddlx": "0", "oldOrderNo": "" }, "secretkey": null, "token": null, "requestId": "EC12147A-B678-4ABF-AAAB-654469EEAAAE", "companyCode": null } 2021-09-26 10:52:19,026 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:52:19,026 [21] INFO poslog - [SQL][select S_POS_ORDER.Nextval as JLBH from dual ] {} 2021-09-26 10:52:19,042 [21] INFO poslog - [SQL][insert into POS_ORDER(ORDERNO,FDBH,SKTNO,DDLY,DDGN,JYLX,STATUS,KSSJ,SMG_HYID,SKY,OLDORDERNO,SKTNO_OLD,JLBH_OLD)values (:ORDERNO,:FDBH,:SKTNO,:DDLY,:DDGN,:JYLX,:STATUS,SYSDATE,:SMG_HYID,:SKY,:OLDORDERNO,:SKTNO_OLD,:JLBH_OLD)] { "ORDERNO": "10120210926105219042", "FDBH": 1, "SKTNO": "001001", "DDLY": 0, "JYLX": 0, "STATUS": 0, "DDGN": 0, "KSSJ": "2021-09-26T10:52:19.0424819+08:00", "SMG_HYID": null, "SKY": 93, "OLDORDERNO": "", "SKTNO_OLD": "", "JLBH_OLD": 0, "BJ_FREETAX": 0, "THYY": null, "TABLEID": "", "DINNERS": 0 } 2021-09-26 10:52:19,061 [21] INFO poslog - [/POSSRV/cyapi/pos/order/create_response]_processTime[29ms]_][8f4e14f4-735c-4098-a695-0094f1e1377a] { "Code": "0", "Msg": null, "Tips": null, "Data": { "orderNo": "10120210926105219042" } } 2021-09-26 10:53:21,495 [18] INFO poslog - [传入串][c9e13655-6f8a-421b-886f-63d92e55a80c] "{\"sys_key\":\"test123\",\"Params_json\":{\"storeCode\":\"1\",\"sktno\":\"001001\"},\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:57:27\",\"format\":\"json\",\"sign\":\"05BCA08E516A58C35C92BE2F6922A8A7\"}" 2021-09-26 10:53:21,495 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus][c9e13655-6f8a-421b-886f-63d92e55a80c] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:57:27", "format": "json", "version": "1.0", "sign": "05BCA08E516A58C35C92BE2F6922A8A7", "Params_json": { "storeCode": "1", "sktno": "001001" }, "secretkey": null, "token": null, "requestId": null, "companyCode": null } 2021-09-26 10:53:21,510 [18] INFO poslog - [/POSSRV/cyapi/pos/common/updatesktstatus_response]_processTime[13ms]_][c9e13655-6f8a-421b-886f-63d92e55a80c] { "Code": "0", "Msg": "成功", "Tips": null, "Data": null } 2021-09-26 10:53:59,979 [21] INFO poslog - [传入串][f617508f-a383-42a8-ab6b-e77b469fe6c2] "{\"sys_key\":\"test123\",\"Params_json\":{\"operatorCode\":\"99988\",\"orderFunction\":8,\"storeCode\":\"1\",\"tableNo\":\"\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"oldOrderNo\":\"\"},\"requestId\":\"D1896E5A-F0A3-4452-9ADE-913388110681\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:05\",\"format\":\"json\",\"sign\":\"BD48286A9274767A023D6B3F4CA619A8\"}" 2021-09-26 10:53:59,979 [21] INFO poslog - [/POSSRV/cyapi/pos/order/create][f617508f-a383-42a8-ab6b-e77b469fe6c2] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:05", "format": "json", "version": "1.0", "sign": "BD48286A9274767A023D6B3F4CA619A8", "Params_json": { "operatorCode": "99988", "orderFunction": 8, "storeCode": "1", "tableNo": "", "sktno": "001001", "ddly": "0", "ddlx": "0", "oldOrderNo": "" }, "secretkey": null, "token": null, "requestId": "D1896E5A-F0A3-4452-9ADE-913388110681", "companyCode": null } 2021-09-26 10:53:59,979 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.RYDM=:RYDM and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "99988", "PERSON_ID": 0, "FDBH": "1" } 2021-09-26 10:53:59,979 [21] INFO poslog - [SQL][select S_POS_ORDER.Nextval as JLBH from dual ] {} 2021-09-26 10:53:59,995 [21] INFO poslog - [SQL][insert into POS_ORDER(ORDERNO,FDBH,SKTNO,DDLY,DDGN,JYLX,STATUS,KSSJ,SMG_HYID,SKY,OLDORDERNO,SKTNO_OLD,JLBH_OLD)values (:ORDERNO,:FDBH,:SKTNO,:DDLY,:DDGN,:JYLX,:STATUS,SYSDATE,:SMG_HYID,:SKY,:OLDORDERNO,:SKTNO_OLD,:JLBH_OLD)] { "ORDERNO": "10120210926105359995", "FDBH": 1, "SKTNO": "001001", "DDLY": 0, "JYLX": 0, "STATUS": 0, "DDGN": 8, "KSSJ": "2021-09-26T10:53:59.9950522+08:00", "SMG_HYID": null, "SKY": 93, "OLDORDERNO": "", "SKTNO_OLD": "", "JLBH_OLD": 0, "BJ_FREETAX": 0, "THYY": null, "TABLEID": "", "DINNERS": 0 } 2021-09-26 10:54:00,010 [21] INFO poslog - [/POSSRV/cyapi/pos/order/create_response]_processTime[25ms]_][f617508f-a383-42a8-ab6b-e77b469fe6c2] { "Code": "0", "Msg": null, "Tips": null, "Data": { "orderNo": "10120210926105359995" } } 2021-09-26 10:54:01,995 [21] INFO poslog - [传入串][a4650ff0-9d49-4535-9198-7f60c9c1a163] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926105359995\",\"originalOrderLists\":[{\"originalOrderNo\":\"10120210926103733077\",\"storeCode\":\"1\"}],\"storeCode\":\"1\",\"ddly\":\"0\"},\"requestId\":\"85B82CA7-3BB8-4610-A069-F8A3FF748ED7\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:07\",\"format\":\"json\",\"sign\":\"B1F874BAEE1EEC5CD3B6843353484C67\"}" 2021-09-26 10:54:01,995 [21] INFO poslog - [/POSSRV/cyapi/pos/order/ReceiveOrder][a4650ff0-9d49-4535-9198-7f60c9c1a163] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:07", "format": "json", "version": "1.0", "sign": "B1F874BAEE1EEC5CD3B6843353484C67", "Params_json": { "orderNo": "10120210926105359995", "originalOrderLists": [ { "originalOrderNo": "10120210926103733077", "storeCode": "1" } ], "storeCode": "1", "ddly": "0" }, "secretkey": null, "token": null, "requestId": "85B82CA7-3BB8-4610-A069-F8A3FF748ED7", "companyCode": null } 2021-09-26 10:54:01,995 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": null, "JLBH": null } 2021-09-26 10:54:02,010 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:02,010 [21] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:02,010 [21] INFO poslog - [SQL][select TCKT_INX,YYY,DEPTID from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,026 [21] INFO poslog - [SQL][select ORDERNO_ORIGINAL,FDBH_ORIGINAL from POS_ORDER_RECEIVE where ORDERNO =:ORDERNO and FDBH=:FDBH] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:02,041 [21] INFO poslog - [SQL][select ORDERNO,0 FLAG from POS_ORDER where FDBH =:FDBH AND ORDERNO =:ORDERNO] { "FDBH": "1", "ORDERNO": "10120210926103733077", "JLBH": "", "DDLY": "", "SKTNO": "" } 2021-09-26 10:54:02,057 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO AND STATUS =:STATUS] { "ORDERNO": "10120210926103733077", "STATUS": "2", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:02,064 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:02,073 [21] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926103733077", "FDBH": 1 } 2021-09-26 10:54:02,073 [21] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:02,073 [21] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:54:02,073 [21] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:54:02,088 [21] INFO poslog - [SQL][select TCKT_INX,YYY,DEPTID from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:54:02,088 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 32, "FDBH": "1" } 2021-09-26 10:54:02,088 [21] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from POS_ORDER where SKTNO =:SKTNO and STATUS <> :STATUS] { "SKTNO": "001001", "STATUS": 4 } 2021-09-26 10:54:02,107 [21] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTPOS_ORDER where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:02,107 [21] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from XSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:02,107 [21] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTXSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:02,120 [21] INFO poslog - [SQL][select (GZKCSL-XSSL) KXSSL from GTSP where DEPTID=:DEPTID and SP_ID=:SP_ID] { "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:02,120 [21] INFO poslog - [SQL][select NVL(SUM(XSSL),0) YXSSL from ORDER_ITEM where ORDERNO =:ORDERNO AND DEPTID =:DEPTID AND SP_ID =:SP_ID] { "ORDERNO": "10120210926105359995", "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:02,120 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,120 [21] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:54:02,135 [21] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,135 [21] INFO poslog - [PreparePaymoney10120210926105359995][] "" 2021-09-26 10:54:02,135 [21] INFO poslog - [SQL][ update POS_ORDER set XSJE =:XSJE,XFJLID =:XFJLID,JLBH =:JLBH,STATUS =:STATUS ,JYJF = :JYJF,PHONE=:PHONE,JZRQ =:JZRQ,TJSJ = :TJSJ,DZRQ=:DZRQ where ORDERNO =:ORDERNO ] { "XSJE": "1", "XFJLID": 0, "JLBH": "108", "JYJF": "0", "PHONE": "", "STATUS": 2, "JSSJ": "2021-09-26T10:54:02.1357072+08:00", "JZRQ": "2021-09-26T10:54:02.1357072+08:00", "PREJZRQ": "2021-09-26T10:54:02.1357072+08:00", "DZRQ": "2021-09-26T10:54:02.1357072+08:00", "TJSJ": "2021-09-26T10:54:02", "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,135 [21] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "GUID": "", "CXSPBJ": 0 } 2021-09-26 10:54:02,151 [21] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "TCKT_INX": -1, "INX": -1 } 2021-09-26 10:54:02,151 [21] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:54:02,151 [21] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,JLBH,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YHJE,MBYH,JF,STAMP,YYY,TCKT_INX_OLD,INX_OLD,CXSPBJ,BGH,XSDD_JLBH,SPJX,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YHJE,:MBYH,:JF,:STAMP,:YYY,:TCKT_INX_OLD,:INX_OLD,:CXSPBJ,:BGH,:XSDD_JLBH,:SPJX,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "108", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YHJE": "0", "MBYH": "0", "JF": "0", "STAMP": "0", "CXSPBJ": "0", "YYY": 32, "TCKT_INX_OLD": 0, "INX_OLD": 0, "BGH": "01012021092610373307711", "XSDD_JLBH": "", "SPJX": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:02,168 [21] INFO poslog - [SQL][ delete from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,168 [21] INFO poslog - [SQL][insert into ORDER_PERSON(ORDERNO,SKTNO,JLBH,TCKT_INX,YYY,DEPTID)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:YYY,:DEPTID)] { "ORDERNO": "10120210926105359995", "JLBH": "108", "SKTNO": "001001", "TCKT_INX": 0, "YYY": 32, "DEPTID": 57 } 2021-09-26 10:54:02,182 [21] INFO poslog - [SQL][insert into POS_ORDER_RECEIVE(ORDERNO,FDBH,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:FDBH,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926105359995", "FDBH": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:02,182 [21] INFO poslog - [SQL][ delete from ORDER_PAY where ORDERNO =:ORDERNO AND SKFS=(select code from skfs where type= 16)] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:02,198 [21] INFO poslog - [/POSSRV/cyapi/pos/order/ReceiveOrder_response]_processTime[204ms]_][a4650ff0-9d49-4535-9198-7f60c9c1a163] { "Code": "0", "Msg": null, "Tips": null, "Data": { "serverBillId": "0", "totalCount": "1", "totalTaxAmount": "0", "totalAmount": "1", "totalDiscount": "0", "decMoney": "0", "decPreferentialMoney": "0", "goodsList": [ { "ysDateList": [], "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": "01012021092610373307711", "specifications": "", "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 1, "ctrlNegSell": 0, "tasteId": null, "desc": null } ], "ysDateList": [], "exchangeGoodsBillInfoList": [], "giftGoodsBillList": [], "salerInfoList": [ { "TicktInx": 0, "PersonId": 32, "PersonCode": "99997", "PersonName": "接吻猫", "PersonDeptId": 57, "PersonDeptCode": "0001010102", "PersonDeptName": "谢瑞麟", "Password": null, "ShopID": 268, "ShopName": null, "OTherStr2": null, "OTherStr3": null, "OTherInt1": 0, "OTherInt2": 0, "OTherInt3": 0, "PermissionsList": null } ], "storeCode": "1", "ddly": "0", "ddlx": null, "orderFunction": 8, "sktno": "001001", "jlbh": "108", "orderNo": "10120210926105359995" } } 2021-09-26 10:54:03,620 [6] INFO poslog - [传入串][1f5ee48b-7503-4e6e-adec-51a8710c1c8c] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926105359995\",\"transferDate\":\"\",\"storeCode\":\"1\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"promotionGoodsSelectSign\":0},\"requestId\":\"90F8A1DC-04F3-468E-8718-BB84FC4E271F\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:09\",\"format\":\"json\",\"sign\":\"D2B8A6CEC8979A53549A9BBB124B7667\"}" 2021-09-26 10:54:03,620 [6] INFO poslog - [/POSSRV/cyapi/pos/order/preparecalculatepromotion][1f5ee48b-7503-4e6e-adec-51a8710c1c8c] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:09", "format": "json", "version": "1.0", "sign": "D2B8A6CEC8979A53549A9BBB124B7667", "Params_json": { "orderNo": "10120210926105359995", "transferDate": "", "storeCode": "1", "sktno": "001001", "ddly": "0", "ddlx": "0", "promotionGoodsSelectSign": 0 }, "secretkey": null, "token": null, "requestId": "90F8A1DC-04F3-468E-8718-BB84FC4E271F", "companyCode": null } 2021-09-26 10:54:03,635 [6] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:03,651 [6] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:03,651 [6] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:03,651 [6] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:03,666 [6] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:03,666 [6] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:03,666 [6] INFO poslog - [SQL][select (GZKCSL-XSSL) KXSSL from GTSP where DEPTID=:DEPTID and SP_ID=:SP_ID] { "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:03,666 [6] INFO poslog - [SQL][select NVL(SUM(XSSL),0) YXSSL from ORDER_ITEM where ORDERNO =:ORDERNO AND DEPTID =:DEPTID AND SP_ID =:SP_ID] { "ORDERNO": "10120210926105359995", "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:03,682 [6] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:03,682 [6] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:03,682 [6] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:03,682 [6] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:03,698 [6] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:03,698 [6] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:54:03,698 [6] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:03,713 [6] INFO poslog - [PreparePaymoney10120210926105359995][] "" 2021-09-26 10:54:03,713 [6] INFO poslog - [/POSSRV/cyapi/pos/order/preparecalculatepromotion_response]_processTime[94ms]_][1f5ee48b-7503-4e6e-adec-51a8710c1c8c] { "Code": "0", "Msg": null, "Tips": null, "Data": { "serverBillId": "0", "totalCount": "1", "totalTaxAmount": "0", "totalAmount": "1", "totalDiscount": "0", "decMoney": "0", "decPreferentialMoney": "0", "goodsList": [ { "ysDateList": [], "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": "01012021092610535999511", "specifications": "", "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 1, "ctrlNegSell": 0, "tasteId": null, "desc": null } ], "ysDateList": [], "exchangeGoodsBillInfoList": [], "giftGoodsBillList": [], "salerInfoList": [], "storeCode": "1", "ddly": "0", "ddlx": null, "orderFunction": 8, "sktno": "001001", "jlbh": "108", "orderNo": "10120210926105359995" } } 2021-09-26 10:54:04,885 [15] INFO poslog - [传入串][863ea64b-c1a0-4b69-a5e7-d427cffcecc3] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926105359995\",\"transferDate\":\"\",\"orderFunction\":8,\"storeCode\":\"1\",\"sktno\":\"001001\",\"jlbh\":\"107\",\"ddly\":\"0\",\"ddlx\":\"0\",\"promotionGoodsSelectSign\":0},\"requestId\":\"77FA0761-8770-47E0-BDC0-CDF7E3849003\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:10\",\"format\":\"json\",\"sign\":\"DF8A030E0ACA6C3FC5471943F3207947\"}" 2021-09-26 10:54:04,885 [15] INFO poslog - [/POSSRV/cyapi/pos/order/prepare][863ea64b-c1a0-4b69-a5e7-d427cffcecc3] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:10", "format": "json", "version": "1.0", "sign": "DF8A030E0ACA6C3FC5471943F3207947", "Params_json": { "orderNo": "10120210926105359995", "transferDate": "", "orderFunction": 8, "storeCode": "1", "sktno": "001001", "jlbh": "107", "ddly": "0", "ddlx": "0", "promotionGoodsSelectSign": 0 }, "secretkey": null, "token": null, "requestId": "77FA0761-8770-47E0-BDC0-CDF7E3849003", "companyCode": null } 2021-09-26 10:54:04,885 [15] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO AND CXSPBJ>0] { "ORDERNO": "10120210926105359995", "GUID": "", "CXSPBJ": 100 } 2021-09-26 10:54:04,885 [15] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:04,901 [15] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:04,901 [15] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:04,901 [15] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:04,901 [15] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:04,916 [15] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:04,916 [15] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from POS_ORDER where SKTNO =:SKTNO and STATUS <> :STATUS] { "SKTNO": "001001", "STATUS": 4 } 2021-09-26 10:54:04,916 [15] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTPOS_ORDER where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:04,916 [15] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from XSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:04,932 [15] INFO poslog - [SQL][select NVL(MAX(JLBH),0)+1 JLBH from SKTXSJL where SKTNO =:SKTNO] { "SKTNO": "001001" } 2021-09-26 10:54:04,932 [15] INFO poslog - [SQL][select (GZKCSL-XSSL) KXSSL from GTSP where DEPTID=:DEPTID and SP_ID=:SP_ID] { "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:04,932 [15] INFO poslog - [SQL][select NVL(SUM(XSSL),0) YXSSL from ORDER_ITEM where ORDERNO =:ORDERNO AND DEPTID =:DEPTID AND SP_ID =:SP_ID] { "ORDERNO": "10120210926105359995", "DEPTID": 57, "SP_ID": 2615 } 2021-09-26 10:54:04,932 [15] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:04,948 [15] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:04,948 [15] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:04,948 [15] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:04,948 [15] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:04,963 [15] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:54:04,972 [15] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:04,974 [15] INFO poslog - [PreparePaymoney10120210926105359995][] "" 2021-09-26 10:54:04,979 [15] INFO poslog - [SQL][ update POS_ORDER set XSJE =:XSJE,XFJLID =:XFJLID,JLBH =:JLBH,STATUS =:STATUS ,JYJF = :JYJF,PHONE=:PHONE,JZRQ =:JZRQ,TJSJ = :TJSJ,DZRQ=:DZRQ where ORDERNO =:ORDERNO ] { "XSJE": "1", "XFJLID": 0, "JLBH": "109", "JYJF": "0", "PHONE": "", "STATUS": 2, "JSSJ": "2021-09-26T10:54:04.9794115+08:00", "JZRQ": "2021-09-26T10:54:04.9794115+08:00", "PREJZRQ": "2021-09-26T10:54:04.9794115+08:00", "DZRQ": "2021-09-26T10:54:04.9794115+08:00", "TJSJ": "2021-09-26T10:54:05", "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:04,979 [15] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "GUID": "", "CXSPBJ": 0 } 2021-09-26 10:54:04,979 [15] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:04,979 [15] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "TCKT_INX": -1, "INX": -1 } 2021-09-26 10:54:04,995 [15] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:54:04,995 [15] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,JLBH,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YHJE,MBYH,JF,STAMP,YYY,TCKT_INX_OLD,INX_OLD,CXSPBJ,BGH,XSDD_JLBH,SPJX,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YHJE,:MBYH,:JF,:STAMP,:YYY,:TCKT_INX_OLD,:INX_OLD,:CXSPBJ,:BGH,:XSDD_JLBH,:SPJX,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "109", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YHJE": "0", "MBYH": "0", "JF": "0", "STAMP": "0", "CXSPBJ": "0", "YYY": 32, "TCKT_INX_OLD": 0, "INX_OLD": 0, "BGH": "01012021092610535999511", "XSDD_JLBH": "", "SPJX": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:04,995 [15] INFO poslog - [SQL][ delete from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:05,010 [15] INFO poslog - [SQL][insert into ORDER_PERSON(ORDERNO,SKTNO,JLBH,TCKT_INX,YYY,DEPTID)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:YYY,:DEPTID)] { "ORDERNO": "10120210926105359995", "JLBH": "109", "SKTNO": "001001", "TCKT_INX": 0, "YYY": 32, "DEPTID": 57 } 2021-09-26 10:54:05,010 [15] INFO poslog - [SQL][ delete from ORDER_PAY where ORDERNO =:ORDERNO AND SKFS=(select code from skfs where type= 16)] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:05,026 [15] INFO poslog - [/POSSRV/cyapi/pos/order/prepare_response]_processTime[137ms]_][863ea64b-c1a0-4b69-a5e7-d427cffcecc3] { "Code": "0", "Msg": null, "Tips": null, "Data": { "serverBillId": "0", "totalCount": "1", "totalTaxAmount": "0", "totalAmount": "1", "totalDiscount": "0", "decMoney": "0", "decPreferentialMoney": "0", "goodsList": [ { "ysDateList": [], "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": "01012021092610535999511", "specifications": "", "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 1, "ctrlNegSell": 0, "tasteId": null, "desc": null } ], "ysDateList": [], "exchangeGoodsBillInfoList": [], "giftGoodsBillList": [], "salerInfoList": [], "storeCode": "1", "ddly": "0", "ddlx": null, "orderFunction": 8, "sktno": "001001", "jlbh": "109", "orderNo": "10120210926105359995" } } 2021-09-26 10:54:07,307 [21] INFO poslog - [传入串][b9fc8e63-fce7-40ec-a2a5-71d92e1a86a8] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926105359995\",\"payList\":[{\"payType\":\"0\",\"payCode\":\"9\",\"payAmount\":\"1.00\"}],\"clearPay\":false,\"storeCode\":\"1\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\"},\"requestId\":\"5CFF6E2F-0216-4356-899C-681683B40577\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:13\",\"format\":\"json\",\"sign\":\"25B33BBEB504203D7B9B527D137E0599\"}" 2021-09-26 10:54:07,307 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addpay][b9fc8e63-fce7-40ec-a2a5-71d92e1a86a8] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:13", "format": "json", "version": "1.0", "sign": "25B33BBEB504203D7B9B527D137E0599", "Params_json": { "orderNo": "10120210926105359995", "payList": [ { "payType": "0", "payCode": "9", "payAmount": "1.00" } ], "clearPay": false, "storeCode": "1", "sktno": "001001", "ddly": "0", "ddlx": "0" }, "secretkey": null, "token": null, "requestId": "5CFF6E2F-0216-4356-899C-681683B40577", "companyCode": null } 2021-09-26 10:54:07,354 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:07,354 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:07,354 [21] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:07,354 [21] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:07,372 [21] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,372 [21] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,372 [21] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:07,372 [21] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:07,385 [21] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:07,385 [21] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:07,385 [21] INFO poslog - [SQL][ delete from ORDER_PAY where ORDERNO =:ORDERNO AND SKFS=:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": "9" } 2021-09-26 10:54:07,401 [21] INFO poslog - [SQL][insert into ORDER_PAY(ORDERNO,SKTNO,JLBH,SKFS,SKJE,YYJE,PAYGUID,SKJE_BB,HL,TAXAMOUNT) values (:ORDERNO,:SKTNO,:JLBH,:SKFS,:SKJE,:YYJE,:PAYGUID,:SKJE_BB,:HL,:TAXAMOUNT)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "109", "SKFS": "9", "SKJE": "1", "YYJE": "0", "PAYGUID": null, "SKJE_BB": "1.00", "HL": "1", "TAXAMOUNT": null } 2021-09-26 10:54:07,416 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:07,416 [21] INFO poslog - [SQL][ update POS_ORDER set STATUS = 3 where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,416 [21] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:07,432 [21] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:07,432 [21] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:07,432 [21] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:07,432 [21] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,448 [21] INFO poslog - [SQL][ update POS_ORDER set XSJE=:XSJE,ZLJE=:ZLJE where ORDERNO =:ORDERNO ] { "XSJE": "1", "ZLJE": "0", "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,448 [21] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "GUID": "", "CXSPBJ": 0 } 2021-09-26 10:54:07,448 [21] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:07,463 [21] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,JLBH,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YHJE,MBYH,JF,STAMP,YYY,TCKT_INX_OLD,INX_OLD,CXSPBJ,BGH,XSDD_JLBH,SPJX,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YHJE,:MBYH,:JF,:STAMP,:YYY,:TCKT_INX_OLD,:INX_OLD,:CXSPBJ,:BGH,:XSDD_JLBH,:SPJX,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "109", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YHJE": "0", "MBYH": "0", "JF": "0", "STAMP": "0", "CXSPBJ": "0", "YYY": 32, "TCKT_INX_OLD": 0, "INX_OLD": 0, "BGH": "01012021092610535999511", "XSDD_JLBH": "", "SPJX": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:07,463 [21] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "TCKT_INX": -1, "INX": -1 } 2021-09-26 10:54:07,463 [21] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:54:07,479 [21] INFO poslog - [SQL][ delete from ORDER_PAY where ORDERNO =:ORDERNO AND SKFS=(select code from skfs where type= 16)] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,479 [21] INFO poslog - [SQL][select SUM(SKJE) SKJE from ORDER_PAY where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,495 [21] INFO poslog - [SQL][select XSJE from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:07,495 [21] INFO poslog - [/POSSRV/cyapi/pos/order/addpay_response]_processTime[185ms]_][b9fc8e63-fce7-40ec-a2a5-71d92e1a86a8] { "Code": "0", "Msg": null, "Tips": null, "Data": { "totalAmount": "1", "totalDiscount": "0", "amountPayable": "0", "decMoney": "0", "decPreferentialMoney": "0", "changeAmount": "0", "goodsList": [ { "ysDateList": [], "cxysdList": null, "DiscountBillList": [], "flavorList": [], "inputCode": "2100072801", "barcode": "21210007280104", "code": "2100072801", "id": "2615", "goodsGuid": "8256d89c6f1240f7abe2457a487a7847", "name": "yezs072801测试商品", "unit": "", "price": "1", "saleCount": "1", "hasedRefundCount": "0", "saleMoney": "1", "discount": "0", "frontDiscount": "0", "preferentialMoney": "0", "deptId": "57", "deptCode": "0001010102", "shopId": null, "classType": "0", "bulkType": "0", "packaged": false, "ticktInx": 0, "ticktGoodsInx": 0, "inx": 0, "imageUrl": null, "stamp": "0", "canDecimal": false, "promoteGoodsSign": "0", "taxAmount": "0", "freeTaxAmount": "0", "wsjg": "0", "taxRate": "0", "taxed": 0, "ms_xlmc": null, "canSaleCount": null, "packageNo": "01012021092610535999511", "specifications": "", "suitCount": "0", "goldGoods_DJ": 0, "currencyRate": "1", "price_WB": "0", "processingFee": "0", "processingFee_WB": "0", "machineType": 1, "ctrlNegSell": 0, "tasteId": null, "desc": null } ] } } 2021-09-26 10:54:09,260 [17] INFO poslog - [传入串][a4bac292-7eff-4327-8dea-41a5f0b70cec] "{\"sys_key\":\"test123\",\"Params_json\":{\"orderNo\":\"10120210926105359995\",\"czkCard\":[],\"storeCode\":\"1\",\"sktno\":\"001001\",\"ddly\":\"0\",\"ddlx\":\"0\",\"yhqCard\":[]},\"requestId\":\"60E0D7E8-AF0A-4116-A173-A2CE6E508B10\",\"version\":\"1.0\",\"timestamp\":\"2021\\/9\\/26 10:58:15\",\"format\":\"json\",\"sign\":\"E06E0C1794F44978AA407A6FC5171174\"}" 2021-09-26 10:54:09,260 [17] INFO poslog - [/POSSRV/cyapi/pos/order/commit][a4bac292-7eff-4327-8dea-41a5f0b70cec] { "sys_id": null, "sys_key": "test123", "timestamp": "2021/9/26 10:58:15", "format": "json", "version": "1.0", "sign": "E06E0C1794F44978AA407A6FC5171174", "Params_json": { "orderNo": "10120210926105359995", "czkCard": [], "storeCode": "1", "sktno": "001001", "ddly": "0", "ddlx": "0", "yhqCard": [] }, "secretkey": null, "token": null, "requestId": "60E0D7E8-AF0A-4116-A173-A2CE6E508B10", "companyCode": null } 2021-09-26 10:54:09,307 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:09,307 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,307 [17] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:54:09,323 [17] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:09,323 [17] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:09,323 [17] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:09,323 [17] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:09,338 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:09,338 [17] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:09,338 [17] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:09,338 [17] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,356 [17] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,359 [17] INFO poslog - 针对crm相关扣款，再这里处理 2021-09-26 10:54:09,359 [17] INFO poslog - 开始扣款 2021-09-26 10:54:09,359 [17] INFO poslog - [SQL][select ORDERNO_ORIGINAL,FDBH_ORIGINAL from POS_ORDER_RECEIVE where ORDERNO =:ORDERNO and FDBH=:FDBH] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:09,359 [17] INFO poslog - crm的预提交 2021-09-26 10:54:09,372 [17] INFO poslog - [SQL][SELECT MAX(RQ) RQ,SYSDATE DQRQ FROM RCL] {} 2021-09-26 10:54:09,372 [17] INFO poslog - [SQL][ update POS_ORDER set XSJE =:XSJE,XFJLID =:XFJLID,JLBH =:JLBH,STATUS =:STATUS ,JYJF = :JYJF,PHONE=:PHONE,JSSJ =SYSDATE,JZRQ =:JZRQ,TJSJ = :TJSJ,DZRQ=:DZRQ where ORDERNO =:ORDERNO ] { "XSJE": "1", "XFJLID": 0, "JLBH": "109", "JYJF": "0", "PHONE": "", "STATUS": 1, "JSSJ": "2021-09-26T10:54:09.3726079+08:00", "JZRQ": "2021-09-26T00:00:00+08:00", "PREJZRQ": "2021-09-26T00:00:00+08:00", "DZRQ": "2021-09-26T00:00:00+08:00", "TJSJ": "2021-09-26T10:54:05", "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,385 [17] INFO poslog - [SQL][ delete from ORDER_ITEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "GUID": "", "CXSPBJ": 0 } 2021-09-26 10:54:09,385 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:09,385 [17] INFO poslog - [SQL][ delete from ORDER_ITEM_DISC where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "TCKT_INX": -1, "INX": -1 } 2021-09-26 10:54:09,385 [17] INFO poslog - [SQL][ delete from ORDER_ITEM_DISCCOUPON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "CRMINX": -1, "SKTNO": "" } 2021-09-26 10:54:09,401 [17] INFO poslog - [SQL][insert into ORDER_ITEM(ORDERNO,SKTNO,JLBH,TCKT_INX,INX,DEPTID,DEPTCODE,SP_ID,BARCODE,LSDJ,XSSL,XSJE,ZKJE,CRMINX,GUID,INPUTCODE,CODE,YHJE,MBYH,JF,STAMP,YYY,TCKT_INX_OLD,INX_OLD,CXSPBJ,BGH,XSDD_JLBH,SPJX,ORDERNO_ORIGINAL,FDBH_ORIGINAL)values (:ORDERNO,:SKTNO,:JLBH,:TCKT_INX,:INX,:DEPTID,:DEPTCODE,:SP_ID,:BARCODE,:LSDJ,:XSSL,:XSJE,:ZKJE,:CRMINX,:GUID,:INPUTCODE,:CODE,:YHJE,:MBYH,:JF,:STAMP,:YYY,:TCKT_INX_OLD,:INX_OLD,:CXSPBJ,:BGH,:XSDD_JLBH,:SPJX,:ORDERNO_ORIGINAL,:FDBH_ORIGINAL)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "109", "TCKT_INX": 0, "INX": 0, "DEPTID": 57, "DEPTCODE": "0001010102", "SP_ID": 2615, "BARCODE": "21210007280104", "LSDJ": "1", "XSSL": "1", "XSJE": "1", "ZKJE": "0", "CRMINX": 0, "GUID": "8256d89c6f1240f7abe2457a487a7847", "INPUTCODE": "2100072801", "CODE": "2100072801", "YHJE": "0", "MBYH": "0", "JF": "0", "STAMP": "0", "CXSPBJ": "0", "YYY": 32, "TCKT_INX_OLD": 0, "INX_OLD": 0, "BGH": "01012021092610535999511", "XSDD_JLBH": "", "SPJX": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:09,401 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:09,401 [17] INFO poslog - [SQL][ update POS_ORDER set STATUS = 6 where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926103733077" } 2021-09-26 10:54:09,416 [17] INFO poslog - [SQL][update POS_ORDER_DELIVERY set ORDERNO=:ORDERNO,FDBH=:FDBH WHERE ORDERNO_ORIGINAL = :ORDERNO_ORIGINAL AND FDBH_ORIGINAL = :FDBH_ORIGINAL] { "ORDERNO": "10120210926105359995", "FDBH": 1, "ORDERNO_ORIGINAL": "10120210926103733077", "FDBH_ORIGINAL": 1 } 2021-09-26 10:54:09,432 [17] INFO poslog - [SQL][ update ORDER_PAYMENT_DETAIL set ORDERSTATUS = 1 where ORDERNO =:ORDERNO AND ORDERSTATUS=0 AND SKFS in (select b.skfs from order_pay B WHERE b.ORDERNO = orderno)] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,432 [17] INFO poslog - [UpDateOrderPAYMENT_Detail][更新支付明细] "没有更新记录！" 2021-09-26 10:54:09,448 [17] INFO poslog - [SQL][ delete from ORDER_ITEM_PAY where ORDERNO =:ORDERNO AND SKTNO =:SKTNO] { "ORDERNO": "10120210926105359995", "SKTNO": "001001" } 2021-09-26 10:54:09,463 [17] INFO poslog - [SQL][insert into ORDER_ITEM_PAY(ORDERNO,SKTNO,JLBH,INX,TCKT_INX,SKFS,SKJE,SP_ID,GUID,DEPTID)values (:ORDERNO,:SKTNO,:JLBH,:INX,:TCKT_INX,:SKFS,:SKJE,:SP_ID,:GUID,:DEPTID)] { "ORDERNO": "10120210926105359995", "SKTNO": "001001", "JLBH": "109", "INX": 0, "TCKT_INX": 0, "SKFS": 9, "SKJE": "1", "SP_ID": 2615, "GUID": "8256d89c6f1240f7abe2457a487a7847", "DEPTID": 57 } 2021-09-26 10:54:09,588 [17] INFO poslog - [SQL][delete from CRMJYBZ where SKTNO = :SKTNO AND JLBH = :JLBH ] { "SKTNO": "001001", "CRMJYLX": -1, "JLBH": "109" } 2021-09-26 10:54:09,604 [17] DEBUG poslog - 删除冲正记录返回DBRes：0 2021-09-26 10:54:09,620 [17] INFO poslog - [SQL][select ORDERNO,FDBH,ORDERNO_ORIGINAL,FDBH_ORIGINAL,SHRQ,CKBM,SHFS,SHLX,AZQY1,AZQY2,AZQY3,SHFY,PHONE,NAME,ADDRESS,ADDRESS_AREA,BZ from POS_ORDER_DELIVERY where ORDERNO =:ORDERNO and FDBH=:FDBH] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:09,635 [17] INFO poslog - [SQL][select TCKT_INX,YYY,DEPTID from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:09,635 [17] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 32, "FDBH": "1" } 2021-09-26 10:54:09,698 [17] INFO poslog - [PlatformBase_Util][加密串] "123NB61sh12O{\"format\":\"json\",\"timestamp\":\"2021-09-26 10:54:09\",\"data\":{\"ORDERNO\":\"10120210926105359995\",\"FDBH\":\"1\",\"DDLY\":\"0\",\"JYLX\":\"0\",\"SKTNO\":\"001001\",\"JLBH\":\"109\",\"KSSJ\":\"2021/9/26 10:54:00\",\"JSSJ\":\"2021/9/26 10:54:05\",\"QXSJ\":null,\"JYJF\":\"0\",\"XFJLID\":\"0\",\"SKY\":\"93\",\"XSJE\":\"1\",\"BJ_OFFLINE\":\"0\",\"THFHR\":\"93\",\"SMG_HYID\":null,\"OLDORDERNO\":\"\",\"PHONE\":\"\",\"DJDSYRQ\":null,\"STATUS\":\"1\",\"TRANSID\":null,\"TRANSMONEY\":null,\"ZLJE\":\"0\",\"JZRQ\":\"2021/9/26 10:54:04\",\"DDGN\":\"8\",\"THYY\":\"\",\"GLKKH\":null,\"SKTNO_OLD\":null,\"JLBH_OLD\":\"0\",\"ZTDID\":null,\"DELIVERYTYPE\":null,\"DELIVERYSTATUS\":null,\"DDYF\":null,\"BZ\":null,\"TM\":null,\"DJDSTATUS\":null,\"BJ_FREETAX\":\"0\",\"TJSJ\":\"2021/9/26 10:54:05\",\"DISPOSEACCOUNT\":null,\"DJDCLORDERNO\":null,\"DZRQ\":\"2021/9/26 0:00:00\",\"DYKKH\":null,\"DYKCXDBH\":null,\"ORDERITEM\":[{\"ORDERNO\":\"10120210926105359995\",\"SKTNO\":\"001001\",\"JLBH\":\"109\",\"TCKT_INX\":\"0\",\"INX\":\"0\",\"YYY\":\"32\",\"DEPTID\":\"57\",\"DEPTCODE\":\"0001010102\",\"SP_ID\":\"2615\",\"BARCODE\":\"21210007280104\",\"CODE\":\"2100072801\",\"LSDJ\":\"1\",\"XSSL\":\"1\",\"XSJE\":\"1\",\"ZKJE\":\"0\",\"YHJE\":\"0\",\"CRMINX\":\"0\",\"MBYH\":\"0\",\"JF\":\"0\",\"GUID\":\"8256d89c6f1240f7abe2457a487a7847\",\"INPUTCODE\":\"2100072801\",\"STAMP\":\"0\",\"TCKT_INX_OLD\":\"0\",\"INX_OLD\":\"0\",\"BZ\":null,\"CXSPBJ\":\"0\",\"BGH\":null,\"XSDD_JLBH\":null,\"SPJX\":\"1\"}],\"PAYLIST\":[{\"ORDERNO\":\"10120210926105359995\",\"SKTNO\":\"001001\",\"JLBH\":\"109\",\"SKFS\":\"9\",\"SKJE\":\"1\",\"YYJE\":\"0\",\"PAYGUID\":\"\",\"SKJE_BB\":\"1\",\"HL\":\"1\",\"TAXAMOUNT\":null}],\"DISCLIST\":[],\"ITEMPAY\":[{\"ORDERNO\":\"10120210926105359995\",\"SKTNO\":\"001001\",\"JLBH\":\"109\",\"SKFS\":\"9\",\"TCKT_INX\":\"0\",\"INX\":\"0\",\"SKJE\":\"1\",\"SP_ID\":\"2615\",\"GUID\":\"8256d89c6f1240f7abe2457a487a7847\",\"DEPTID\":\"57\"}],\"PERSONLIST\":[{\"ORDERNO\":\"10120210926105359995\",\"SKTNO\":\"001001\",\"JLBH\":\"109\",\"TCKT_INX\":\"0\",\"YYY\":\"32\",\"DEPTID\":\"57\"}],\"DJDLIST\":[],\"RECEIVELIST\":[{\"ORDERNO\":\"10120210926105359995\",\"FDBH\":\"1\",\"ORDERNO_ORIGINAL\":\"10120210926103733077\",\"FDBH_ORIGINAL\":\"1\"}],\"DELIVERYLIST\":[{\"ORDERNO\":\"10120210926105359995\",\"FDBH\":\"1\",\"ORDERNO_ORIGINAL\":\"10120210926103733077\",\"FDBH_ORIGINAL\":\"1\",\"SHRQ\":\"2021/9/26 0:00:00\",\"CKBM\":\"1\",\"SHFS\":\"3\",\"SHLX\":\"市内(10)元\",\"AZQY1\":\"03.广东\",\"AZQY2\":\"0301.广州\",\"AZQY3\":\"030101.白云区\",\"SHFY\":\"10\",\"PHONE\":\"11122223333\",\"NAME\":\"测试\",\"ADDRESS\":\"西安\",\"ADDRESS_AREA\":\"15\",\"BZ\":\"家电测试\"}]},\"token\":\"\"}123NB61sh12O" 2021-09-26 10:54:09,698 [17] INFO poslog - [Platform请求][加密串] "3A4889EBC27B4418FD4BF4C011857763" 2021-09-26 10:54:10,088 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO AND DDLY =:DDLY] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "0", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:10,088 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,DDGN,KSSJ,JSSJ,QXSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO,XFJLID,SMG_HYID,PHONE,ZLJE,JZRQ,DELIVERYSTATUS,DELIVERYTYPE,ZTDID,DDYF,BZ,DJDSTATUS,TJSJ,BJ_FREETAX,DYKKH,DYKCXDBH from POS_ORDER where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995", "STATUS": "", "DDLY": "", "SKTNO": "", "JLBH": "" } 2021-09-26 10:54:10,104 [17] INFO poslog - [SQL][select A.TCKT_INX,A.INX,A.DEPTID,A.SP_ID,A.BARCODE,A.LSDJ,A.XSSL,A.XSJE,A.ZKJE,A.CRMINX,A.GUID,A.INPUTCODE,A.CODE,A.DEPTCODE,A.MBYH,A.YHJE,A.STAMP,A.YYY,A.TCKT_INX_OLD,A.INX_OLD,JF,A.BZ,A.CXSPBJ,A.BGH,A.XSDD_JLBH,A.SPJX,A.ORDERNO_ORIGINAL,A.FDBH_ORIGINAL,B.SPTYPE from ORDER_ITEM A,SPXX B where A.ORDERNO =:ORDERNO AND A.SP_ID=B.SP_ID AND B.FDBH=:FDBH ORDER BY A.TCKT_INX,A.INX ASC] { "ORDERNO": "10120210926105359995", "FDBH": 1 } 2021-09-26 10:54:10,104 [17] INFO poslog - [SQL][ select SP_ID,SPCODE,BARCODE,NAME,UNIT,SPGG,PACKED,szspbj,FKCXSBJ,SPTYPE,HSFS,LSDJ,HYLSDJ,STATUS,SPFL,SHOPID,SLYXS,FKCXSSJ from SPXX where SP_ID=:SP_ID and FDBH=:FDBH] { "SP_ID": 2615, "FDBH": 1 } 2021-09-26 10:54:10,104 [17] INFO poslog - [SQL][select ORDERNO, TCKT_INX, INX, ZKJE, ZKLX, ZKL, REFNO,CXDBH,CXDINX,CXHDDBH,ZKFTBL,SSFTFS,JKD,CXJJ_HS,ZKSL from ORDER_ITEM_DISC where ORDERNO =:ORDERNO ] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,104 [17] INFO poslog - [SQL][select THSL,TCKT_INX,INX,SP_ID from QTTHSL where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,120 [17] INFO poslog - [SQL][select A.SKFS,A.SKJE,A.YYJE,A.PAYGUID,B.NAME,B.TYPE,B.BJ_YH,B.YHQID,B.ZLCLFS,C.ISCODED,A.HL,A.TAXAMOUNT from ORDER_PAY A,SKFS B left join YHQDEF C on B.YHQID=C.YHQID where A.SKFS=B.CODE AND A.ORDERNO =:ORDERNO AND A.SKFS<>:SKFS] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:10,120 [17] INFO poslog - [SQL][select A.GUID,A.SKJE,A.LX,A.HYID,JYSJ,A.BMQCODE,A.YE,A.SKFS from ORDER_PAYMENT_CRM A where A.ORDERNO =:ORDERNO AND A.STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKFS": "", "STATUS": "1" } 2021-09-26 10:54:10,120 [17] INFO poslog - [SQL][select GUID,SKJE,SKFS,LX,KH,CKH,LSH,PZH,SHDDH,WBDDH,JYSJ,PARAM1,PARAM2,YJYRQ,YZDH,YXQ from ORDER_PAYMENT_DETAIL where JYTYPE = 0 AND ORDERSTATUS = :ORDERSTATUS AND ORDERNO =:ORDERNO AND STATUS=:STATUS ] { "ORDERNO": "10120210926105359995", "SKTNO": "", "JLBH": "", "SKFS": "", "STATUS": "1", "ORDERSTATUS": 1 } 2021-09-26 10:54:10,120 [17] INFO poslog - [SQL][select SKFS,SKJE,YYJE,PAYGUID from ORDER_PAY where SKFS=:SKFS AND ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995", "SKFS": 7571 } 2021-09-26 10:54:10,120 [17] INFO poslog - [SQL][select TCKT_INX,YYY,DEPTID from ORDER_PERSON where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,135 [17] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 32, "FDBH": "1" } 2021-09-26 10:54:10,135 [17] INFO poslog - [SQL][select ORDERNO,SKTNO,JLBH,FDBH,JYLX,DDLY,KSSJ,SKY,XSJE,STATUS,JYJF,OLDORDERNO from POS_ORDER where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,135 [17] INFO poslog - [SQL][select R.PERSON_ID,R.PERSON_NAME,R.DEPTID,R.WORK_TYPE,R.RYDM,B.BMDM,B.DEPT_NAME,R.SHOPID from RYXX R,BM B where R.DEPTID=B.DEPTID AND R.PERSON_ID=:PERSON_ID and (B.FDBH=:FDBH or B.FDBH=-1) and R.STATUS=1] { "RYDM": "", "PERSON_ID": 93, "FDBH": "1" } 2021-09-26 10:54:10,135 [17] INFO poslog - [SQL][select ORDERNO,HYID,HYKTYPE,HYKNO,LJJF,BCJF,INFO from ORDER_MEM where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,151 [17] INFO poslog - [SQL][select YE,JE,TYPE,NAME,VALIDDATE,INX,NOTE1,NOTE2 from ORDER_OFFERCOUPON where ORDERNO =:ORDERNO AND TYPE<>777] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,169 [17] INFO poslog - [SQL][select YE,JE,TYPE,NAME,VALIDDATE,INX,SPECIAL_TYPE from ORDER_OFFERCOUPON where ORDERNO =:ORDERNO AND TYPE=777] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,182 [17] INFO poslog - [SQL][select CJSJ,CODE,ID,NAME from ORDER_LOTTO where ORDERNO =:ORDERNO] { "ORDERNO": "10120210926105359995" } 2021-09-26 10:54:10,198 [17] INFO poslog - [SQL][select ID,NAME,APPKEY,APPSECRET,URL,VAL1,VAL2 from POS_INTERFACE WHERE (FDBH=-1 OR FDBH=:FDBH)] { "FDBH": "1" } 2021-09-26 10:54:10,213 [17] INFO poslog - [SQL][SELECT MC,TIME FROM SFGZDEF A,SFGZDEFITEM B where A.ID=B.ID AND MINJE<:JE AND :JE