安卓拉计提数据999++2024/3/8 10:10:03：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"1","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"1","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
machineId：001003001002001001001001003002003001---errorCode：99
machineId：001003001002001001001001003002003001---errorCode：99
machineId：001003001002001001001001003002003001---errorCode：4099
machineId：001003001002001001001001003002003001---errorCode：3099
machineId：001003001002001001001001003002003001---errorCode：799
machineId：001003001002001001001001003002003001---errorCode：8899
machineId：001003001002001001001001003002003001---errorCode：199
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：0
安卓拉计提数据999++2024/3/8 11:41:31：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"1","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"1","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00001
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7656]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[4141087232]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308114141401-00001]]></out_trade_no><product_id><![CDATA[00001]]></product_id><sign><![CDATA[8d98df599a406717ecf60f4671fb617e62e3e65fba9e09e157754e38bbd10df8]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308114242]]></time_expire><time_start><![CDATA[20240308114140]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7656]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[4141087232]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308114141401-00001]]></out_trade_no><product_id><![CDATA[00001]]></product_id><sign><![CDATA[8d98df599a406717ecf60f4671fb617e62e3e65fba9e09e157754e38bbd10df8]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308114242]]></time_expire><time_start><![CDATA[20240308114140]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7656
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7656
3:[{"JPushId":"120c83f76122c314375","payMoney":0.01,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"1","ordersInformactions":[{"MealCode":"001003002003001","bowls":"1","name":"笋干菜黄豆猪蹄"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308114141401-00001
5:00001
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308114141401-00001
8:4200002163202403087577177394
9:OTHERS
10:0.01
11:0.01
12:2024/3/8 11:41:55
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00001
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00001"}
自动退款第一步2024/3/8 11:45:00：[{"errorCode":1099,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00001","refundMeals":[{"mealCode":"001003002003001"}]}]}]
错误代码001003001002001001001001003002003001：1099
自动退款第二步2024/3/8 11:45:00： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00001' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002163202403087577177394
自动退款第三步2024/3/8 11:45:00：4200002163202403087577177394=1
machineId：001003001002001001001001003002003001---errorCode：1099
yyyyyyy：00002
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7657]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[683650847]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308114733210-00002]]></out_trade_no><product_id><![CDATA[00002]]></product_id><sign><![CDATA[2618e750938419dc7f3feb68125225c3c1b3a64a7d26cc58ecf65c7dc8e0d865]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308114834]]></time_expire><time_start><![CDATA[20240308114732]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7657]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[683650847]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308114733210-00002]]></out_trade_no><product_id><![CDATA[00002]]></product_id><sign><![CDATA[2618e750938419dc7f3feb68125225c3c1b3a64a7d26cc58ecf65c7dc8e0d865]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308114834]]></time_expire><time_start><![CDATA[20240308114732]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7657
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7657
3:[{"JPushId":"120c83f76122c314375","payMoney":0.02,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"2","ordersInformactions":[{"MealCode":"001003002003002","bowls":"1","name":"酱烧鲈鱼"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308114733210-00002
5:00002
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308114733210-00002
8:4200002155202403083794803440
9:OTHERS
10:0.02
11:0.02
12:2024/3/8 11:47:48
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00002
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00002"}
yyyyyyy：00003
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7658]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[2833058768]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115055439-00003]]></out_trade_no><product_id><![CDATA[00003]]></product_id><sign><![CDATA[dd1b569238cf7d5c0f8ad90cb26eefd89e0425e2b6aa069026b1f680eee99576]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115156]]></time_expire><time_start><![CDATA[20240308115054]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7658]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[2833058768]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115055439-00003]]></out_trade_no><product_id><![CDATA[00003]]></product_id><sign><![CDATA[dd1b569238cf7d5c0f8ad90cb26eefd89e0425e2b6aa069026b1f680eee99576]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115156]]></time_expire><time_start><![CDATA[20240308115054]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7658
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7658
3:[{"JPushId":"120c83f76122c314375","payMoney":0.02,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"3","ordersInformactions":[{"MealCode":"001003002003002","bowls":"1","name":"酱烧鲈鱼"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308115055439-00003
5:00003
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308115055439-00003
8:4200002154202403081042015866
9:OTHERS
10:0.02
11:0.02
12:2024/3/8 11:51:09
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00003
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00003"}
自动退款第一步2024/3/8 11:53:11：[{"errorCode":1199,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00003","refundMeals":[{"mealCode":"001003002003002"}]}]}]
错误代码001003001002001001001001003002003001：1199
自动退款第二步2024/3/8 11:53:11： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00003' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002154202403081042015866
自动退款第三步2024/3/8 11:53:11：4200002154202403081042015866=2
machineId：001003001002001001001001003002003001---errorCode：1199
安卓拉计提数据999++2024/3/8 11:53:37：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"1","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"1","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"1","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00004
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7659]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[3609816368]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115419654-00004]]></out_trade_no><product_id><![CDATA[00004]]></product_id><sign><![CDATA[42cae1bb5b6f64b99e3e6c6469a244d39910a4466b55bb2e5fb909b9a4cee5cf]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115520]]></time_expire><time_start><![CDATA[20240308115418]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7659]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[3609816368]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115419654-00004]]></out_trade_no><product_id><![CDATA[00004]]></product_id><sign><![CDATA[42cae1bb5b6f64b99e3e6c6469a244d39910a4466b55bb2e5fb909b9a4cee5cf]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115520]]></time_expire><time_start><![CDATA[20240308115418]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7659
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7659
3:[{"JPushId":"120c83f76122c314375","payMoney":0.02,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"4","ordersInformactions":[{"MealCode":"001003002003002","bowls":"1","name":"酱烧鲈鱼"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308115419654-00004
5:00004
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308115419654-00004
8:4200002169202403080793990624
9:OTHERS
10:0.02
11:0.02
12:2024/3/8 11:54:29
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00004
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00004"}
自动退款第一步2024/3/8 11:56:28：[{"errorCode":1299,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00004","refundMeals":[{"mealCode":"001003002003002"}]}]}]
错误代码001003001002001001001001003002003001：1299
自动退款第二步2024/3/8 11:56:28： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00004' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002169202403080793990624
自动退款第三步2024/3/8 11:56:28：4200002169202403080793990624=2
machineId：001003001002001001001001003002003001---errorCode：1299
yyyyyyy：00005
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7660]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[890785493]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115740615-00005]]></out_trade_no><product_id><![CDATA[00005]]></product_id><sign><![CDATA[d025b6347ed241dae312a713398f8721744b24dfc08b7fb2244d6c9569a3b547]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115841]]></time_expire><time_start><![CDATA[20240308115739]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7660]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[890785493]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308115740615-00005]]></out_trade_no><product_id><![CDATA[00005]]></product_id><sign><![CDATA[d025b6347ed241dae312a713398f8721744b24dfc08b7fb2244d6c9569a3b547]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308115841]]></time_expire><time_start><![CDATA[20240308115739]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7660
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7660
3:[{"JPushId":"120c83f76122c314375","payMoney":0.01,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"5","ordersInformactions":[{"MealCode":"001003002003001","bowls":"1","name":"笋干菜黄豆猪蹄"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308115740615-00005
5:00005
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308115740615-00005
8:4200002158202403080189641814
9:OTHERS
10:0.01
11:0.01
12:2024/3/8 11:57:51
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00005
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00005"}
machineId：001003001002001001001001003002003001---errorCode：1399
machineId：001003001002001001001001003002003001---errorCode：4099
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：0
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：0
安卓拉计提数据999++2024/3/8 15:56:53：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"1","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"2","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00006
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7661]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[105402067]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308155656307-00006]]></out_trade_no><product_id><![CDATA[00006]]></product_id><sign><![CDATA[9db6465810bedbdcb4c639193d44f520a9544414759def6d2f49f565d576681b]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308155757]]></time_expire><time_start><![CDATA[20240308155655]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7661]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[105402067]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308155656307-00006]]></out_trade_no><product_id><![CDATA[00006]]></product_id><sign><![CDATA[9db6465810bedbdcb4c639193d44f520a9544414759def6d2f49f565d576681b]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308155757]]></time_expire><time_start><![CDATA[20240308155655]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7661
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7661
3:[{"JPushId":"120c83f76122c314375","payMoney":0.01,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"6","ordersInformactions":[{"MealCode":"001003002003001","bowls":"1","name":"笋干菜黄豆猪蹄"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308155656307-00006
5:00006
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308155656307-00006
8:4200002160202403086443588727
9:OTHERS
10:0.01
11:0.01
12:2024/3/8 15:57:07
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00006
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00006"}
machineId：001003001002001001001001003002003001---errorCode：1399
yyyyyyy：00007
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7662]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[619241793]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308160018407-00007]]></out_trade_no><product_id><![CDATA[00007]]></product_id><sign><![CDATA[2b4c4df07426d52ac60778f5915a3658662428805176c6373728aec2a7fe7928]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308160119]]></time_expire><time_start><![CDATA[20240308160017]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7662]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[619241793]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308160018407-00007]]></out_trade_no><product_id><![CDATA[00007]]></product_id><sign><![CDATA[2b4c4df07426d52ac60778f5915a3658662428805176c6373728aec2a7fe7928]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308160119]]></time_expire><time_start><![CDATA[20240308160017]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7662
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7662
3:[{"JPushId":"120c83f76122c314375","payMoney":0.02,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"7","ordersInformactions":[{"MealCode":"001003002003002","bowls":"1","name":"酱烧鲈鱼"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308160018407-00007
5:00007
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308160018407-00007
8:4200002159202403085410031162
9:OTHERS
10:0.02
11:0.02
12:2024/3/8 16:00:29
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00007
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00007"}
machineId：001003001002001001001001003002003001---errorCode：899
自动退款第一步2024/3/8 16:02:34：[{"errorCode":899,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00007","refundMeals":[{"mealCode":"001003002003002"}]}]}]
错误代码001003001002001001001001003002003001：899
自动退款第二步2024/3/8 16:02:34： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00007' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002159202403085410031162
自动退款第三步2024/3/8 16:02:35：4200002159202403085410031162=2
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：0
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：0
安卓拉计提数据999++2024/3/8 16:37:44：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"0","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"1","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00008
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7663]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[276564165]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308164216233-00008]]></out_trade_no><product_id><![CDATA[00008]]></product_id><sign><![CDATA[e1e36ce1f8285654d2e2ce6bbf9d54f7fe691d2e7039396afc94866ac44b539d]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308164317]]></time_expire><time_start><![CDATA[20240308164215]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7663]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[276564165]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308164216233-00008]]></out_trade_no><product_id><![CDATA[00008]]></product_id><sign><![CDATA[e1e36ce1f8285654d2e2ce6bbf9d54f7fe691d2e7039396afc94866ac44b539d]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308164317]]></time_expire><time_start><![CDATA[20240308164215]]></time_start><total_fee>2</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7663
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7663
3:[{"JPushId":"120c83f76122c314375","payMoney":0.02,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"8","ordersInformactions":[{"MealCode":"001003002003002","bowls":"1","name":"酱烧鲈鱼"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308164216233-00008
5:00008
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308164216233-00008
8:4200002140202403085816273837
9:OTHERS
10:0.02
11:0.02
12:2024/3/8 16:42:31
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00008
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00008"}
自动退款第一步2024/3/8 16:43:56：[{"errorCode":899,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00008","refundMeals":[{"mealCode":"001003002003002"}]}]}]
错误代码001003001002001001001001003002003001：899
自动退款第二步2024/3/8 16:43:56： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00008' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002140202403085816273837
自动退款第三步2024/3/8 16:43:57：4200002140202403085816273837=2
yyyyyyy：00009
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7664]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[2782173991]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308164929110-00009]]></out_trade_no><product_id><![CDATA[00009]]></product_id><sign><![CDATA[d1ad5a28f08801ac8c33e8989fa46c5c5d267b3ddfbc6be1aebc88653ae44746]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308165030]]></time_expire><time_start><![CDATA[20240308164928]]></time_start><total_fee>3</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7664]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[2782173991]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308164929110-00009]]></out_trade_no><product_id><![CDATA[00009]]></product_id><sign><![CDATA[d1ad5a28f08801ac8c33e8989fa46c5c5d267b3ddfbc6be1aebc88653ae44746]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308165030]]></time_expire><time_start><![CDATA[20240308164928]]></time_start><total_fee>3</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7664
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7664
3:[{"JPushId":"120c83f76122c314375","payMoney":0.03,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"9","ordersInformactions":[{"MealCode":"001003002003003","bowls":"1","name":"尖椒鸡腿肉"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308164929110-00009
5:00009
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308164929110-00009
8:4200002169202403083479144016
9:OTHERS
10:0.03
11:0.03
12:2024/3/8 16:49:43
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00009
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00009"}
自动退款第一步2024/3/8 16:51:10：[{"errorCode":899,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00009","refundMeals":[{"mealCode":"001003002003003"}]}]}]
错误代码001003001002001001001001003002003001：899
自动退款第二步2024/3/8 16:51:10： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00009' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002169202403083479144016
自动退款第三步2024/3/8 16:51:10：4200002169202403083479144016=3
machineId：001003001002001001001001003002003001---errorCode：899
machineId：001003001002001001001001003002003001---errorCode：9999
machineId：001003001002001001001001003002003001---errorCode：9999
补货数据999++2024/3/8 17:18:09：[{"batch":"2024038171810915","beginTime":"2024-03-08 17:18:08.618","endTime":"2024-03-08 17:18:10.916","jPushId":"120c83f76122c314375","machineId":"001003001002001001001001003002003001","repair":[{"replenishmentCode":"1","replenishmentValue":"1"},{"replenishmentCode":"2","replenishmentValue":"1"},{"replenishmentCode":"3","replenishmentValue":"1"},{"replenishmentCode":"4","replenishmentValue":"0"},{"replenishmentCode":"5","replenishmentValue":"0"},{"replenishmentCode":"6","replenishmentValue":"0"},{"replenishmentCode":"7","replenishmentValue":"0"},{"replenishmentCode":"8","replenishmentValue":"0"},{"replenishmentCode":"9","replenishmentValue":"0"},{"replenishmentCode":"10","replenishmentValue":"0"},{"replenishmentCode":"11","replenishmentValue":"0"},{"replenishmentCode":"12","replenishmentValue":"0"},{"replenishmentCode":"13","replenishmentValue":"0"},{"replenishmentCode":"14","replenishmentValue":"0"},{"replenishmentCode":"15","replenishmentValue":"0"},{"replenishmentCode":"16","replenishmentValue":"0"},{"replenishmentCode":"17","replenishmentValue":"0"},{"replenishmentCode":"18","replenishmentValue":"0"},{"replenishmentCode":"19","replenishmentValue":"0"},{"replenishmentCode":"20","replenishmentValue":"0"},{"replenishmentCode":"21","replenishmentValue":"0"}]}]
安卓拉计提数据999++2024/3/8 17:18:10：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"1","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00010
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7665]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[1447609400]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308171911521-00010]]></out_trade_no><product_id><![CDATA[00010]]></product_id><sign><![CDATA[6b5762f49e484c00df3bc12a31e4c59d346a9bdf736709b498aad9e232d325bd]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308172012]]></time_expire><time_start><![CDATA[20240308171910]]></time_start><total_fee>4</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7665]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[1447609400]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308171911521-00010]]></out_trade_no><product_id><![CDATA[00010]]></product_id><sign><![CDATA[6b5762f49e484c00df3bc12a31e4c59d346a9bdf736709b498aad9e232d325bd]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308172012]]></time_expire><time_start><![CDATA[20240308171910]]></time_start><total_fee>4</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7665
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7665
3:[{"JPushId":"120c83f76122c314375","payMoney":0.04,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"10","ordersInformactions":[{"MealCode":"001003002003001","bowls":"4","name":"笋干菜黄豆猪蹄"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308171911521-00010
5:00010
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308171911521-00010
8:4200002173202403084090618713
9:OTHERS
10:0.04
11:0.04
12:2024/3/8 17:19:28
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00010
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00010"}
自动退款第一步2024/3/8 17:20:19：[{"errorCode":899,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00010","refundMeals":[{"mealCode":"001003002003001"},{"mealCode":"001003002003001"},{"mealCode":"001003002003001"},{"mealCode":"001003002003001"}]}]}]
错误代码001003001002001001001001003002003001：899
自动退款第二步2024/3/8 17:20:19： select oi.id as ordersInformationIndex,ops.oid as ordersIndex,o.ordersId,ops.paysMoney,o.orderSort  , ops.paysInterface, ops.paysId,ops.out_trade_no,oi.MealCode, oi.payMoney  from orders o left join ordersInformations oi on o.id = oi.oid  left join ordersPaysStream ops on o.ordersId=ops.ordersId  where o.macAddress ='301F9A895CB1'  and o.machineId ='001003001002001001001001003002003001'  and ops.paysTime between DATEADD(day,0,datediff(DAY,0,getdate())) and getdate() and ( o.orderSort='00010' )  order by o.ordersId,o.orderSort;
自动退款第二+步4200002173202403084090618713
自动退款第二+步4200002173202403084090618713
自动退款第二+步4200002173202403084090618713
自动退款第二+步4200002173202403084090618713
自动退款第三步2024/3/8 17:20:19：4200002173202403084090618713=4
machineId：001003001002001001001001003002003001---errorCode：899
补货数据999++2024/3/8 17:23:19：[{"batch":"2024038172320436","beginTime":"2024-03-08 17:23:17.073","endTime":"2024-03-08 17:23:20.437","jPushId":"120c83f76122c314375","machineId":"001003001002001001001001003002003001","repair":[{"replenishmentCode":"1","replenishmentValue":"1"},{"replenishmentCode":"2","replenishmentValue":"1"},{"replenishmentCode":"3","replenishmentValue":"1"},{"replenishmentCode":"4","replenishmentValue":"0"},{"replenishmentCode":"5","replenishmentValue":"0"},{"replenishmentCode":"6","replenishmentValue":"0"},{"replenishmentCode":"7","replenishmentValue":"0"},{"replenishmentCode":"8","replenishmentValue":"0"},{"replenishmentCode":"9","replenishmentValue":"0"},{"replenishmentCode":"10","replenishmentValue":"0"},{"replenishmentCode":"11","replenishmentValue":"0"},{"replenishmentCode":"12","replenishmentValue":"0"},{"replenishmentCode":"13","replenishmentValue":"0"},{"replenishmentCode":"14","replenishmentValue":"0"},{"replenishmentCode":"15","replenishmentValue":"0"},{"replenishmentCode":"16","replenishmentValue":"0"},{"replenishmentCode":"17","replenishmentValue":"0"},{"replenishmentCode":"18","replenishmentValue":"0"},{"replenishmentCode":"19","replenishmentValue":"0"},{"replenishmentCode":"20","replenishmentValue":"0"},{"replenishmentCode":"21","replenishmentValue":"0"}]}]
安卓拉计提数据999++2024/3/8 17:23:19：{"buildingCode":"001003001002001001","machinesId":"001003001002001001001","name":"测试大厦无人售货柜-机组","machins":[{"machineType":"001003002003","machineSort":"001","machineId":"001003001002001001001001003002003001","meals":[{"MealName":"笋干菜黄豆猪蹄","MealCode":"001003002003001","MealPlc":"1","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/1-174914532.png","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"9"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"酱烧鲈鱼","MealCode":"001003002003002","MealPlc":"2","sale":"0.02","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/2-174927390.png","step":[{"temperature":"001003002003002001001","second":"60"},{"temperature":"001003002003002001002","second":"11"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"尖椒鸡腿肉","MealCode":"001003002003003","MealPlc":"3","sale":"0.03","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/default/box/3-17506179.png","step":[{"temperature":"001003002003003001001","second":"60"},{"temperature":"001003002003003001002","second":"12"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"牛蛙","MealCode":"001003002003004","MealPlc":"4","sale":"0.04","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/三-183632661-171726297.png","step":[{"temperature":"001003002003004001001","second":"60"},{"temperature":"001003002003004001002","second":"13"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"111","MealCode":"001003002003005","MealPlc":"5","sale":"0.05","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/四-183656267-17183118.png","step":[{"temperature":"001003002003005001001","second":"60"},{"temperature":"001003002003005001002","second":"15"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"测试三套餐","MealCode":"001003002003006","MealPlc":"6","sale":"0.06","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/五-183731172-171829730.png","step":[{"temperature":"001003002003006001001","second":"60"},{"temperature":"001003002003006001002","second":"16"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"测试四套餐","MealCode":"001003002003007","MealPlc":"7","sale":"0.08","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/六-18381689-171851230.png","step":[{"temperature":"001003002003007001001","second":"60"},{"temperature":"001003002003007001002","second":"17"},{"temperature":"001003002003007001003","second":"3"}]}],"aisle":[{"aisle":"1","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"2","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"3","goodsId":"001003002003001","inventory":"2","stock":"2","stade":"1"},{"aisle":"4","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"5","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"6","goodsId":"001003002003002","inventory":"2","stock":"0","stade":"1"},{"aisle":"7","goodsId":"001003002003003","inventory":"2","stock":"1","stade":"1"},{"aisle":"8","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"9","goodsId":"001003002003003","inventory":"2","stock":"2","stade":"1"},{"aisle":"10","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"11","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"12","goodsId":"001003002003004","inventory":"2","stock":"2","stade":"1"},{"aisle":"13","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"15","goodsId":"001003002003005","inventory":"2","stock":"2","stade":"1"},{"aisle":"16","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"17","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"18","goodsId":"001003002003006","inventory":"2","stock":"2","stade":"1"},{"aisle":"19","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"2","stade":"1"}],"aisleByGoodsId":[{"aisleByGoodsIdMachineId":"001003001002001001001001003002003001","aisleByGoodsIdList":[{"aisleByGoodsIdGoodsIds":"001003002003001","aisleByGoodsIdAisleListArray":"1|2|3|"},{"aisleByGoodsIdGoodsIds":"001003002003002","aisleByGoodsIdAisleListArray":"4|5|6|"},{"aisleByGoodsIdGoodsIds":"001003002003003","aisleByGoodsIdAisleListArray":"7|8|9|"},{"aisleByGoodsIdGoodsIds":"001003002003004","aisleByGoodsIdAisleListArray":"10|11|12|"},{"aisleByGoodsIdGoodsIds":"001003002003005","aisleByGoodsIdAisleListArray":"13|14|15|"},{"aisleByGoodsIdGoodsIds":"001003002003006","aisleByGoodsIdAisleListArray":"16|17|18|"},{"aisleByGoodsIdGoodsIds":"001003002003007","aisleByGoodsIdAisleListArray":"19|20|21|"}]}]}]}
yyyyyyy：00011
欣欣0：1
欣欣1：wx53f7c6c2b71db1c4
欣欣2：1513565941
<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7666]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[1388320121]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308172339254-00011]]></out_trade_no><product_id><![CDATA[00011]]></product_id><sign><![CDATA[8c23153851c8a112755ccc75fe1f893c2195f87f6cdd20d380b2d5e51cbaf810]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308172440]]></time_expire><time_start><![CDATA[20240308172338]]></time_start><total_fee>4</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx53f7c6c2b71db1c4]]></appid><attach><![CDATA[001003001002001001001001003002003001-7666]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1513565941]]></mch_id><nonce_str><![CDATA[1388320121]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[594120240308172339254-00011]]></out_trade_no><product_id><![CDATA[00011]]></product_id><sign><![CDATA[8c23153851c8a112755ccc75fe1f893c2195f87f6cdd20d380b2d5e51cbaf810]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240308172440]]></time_expire><time_start><![CDATA[20240308172338]]></time_start><total_fee>4</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2019022663440078
ali0-merchant_private_key：MIIEpQIBAAKCAQEA5tCWSohjrp+VwoV/hstEMVSLmkBgC2UyGMj3d6TgMpvm9G6zqIP1og+nerU8gGoeOTjPO7TViFIoWuOTAFwr78r0i7JshD10NUVUUPfVPszIrrXceswUWOXqtiWUIg5b0KbsvwaJ5GPTxuSng+G66lab7swYCyp706N04mrzWFQGcVg7S0tvGKznZXE2DCeErbCGGGDxN2Uh7uK0bTd2XEyl/GRLMKMpx6jYoWMraX6MeT1fQS/4X5aazbceePNCjPYSJfrjWyVgi+OylgXghlWbvliQB1f/T9IiJTRgJrjfo85y666tvRnksw2G2MIMekAu2VDs0WPAacQPXygjfQIDAQABAoIBAQC4zf/Xk1aExX/KLMtLqMpj2PahvbNozFCNKbOCVz+vJcaIpW4xmd59MJ1/EUds5gpm9IZwnrxtlqJ7C0Vy/1mqeEzO4UAjrXSzBlyZK6XQz3RK9o+evnH4L7Z6uqHdlrOK32wlEt4rQIaa9A7v+DeJU2ksjLsfjZdxf6mhc9J9P9xXlnwOhdZXQklJmrbpq/VD2z8sMg+E7DkK3cPXroDy2Mm3hvoG2+3OU6A2I1E8WW37ZbCOtBfYSq1eYMWRnLL/jDaIVNzY5OE1LXDc7TWVZDhmgIjT7M+7HJqDbK9n+aOFF6f3cQJYp37bnnKZXiMwhJyerS4H6bN2ZqHHMWdBAoGBAPT9AKnvFkOJQEoTg5cM49VsQ6QYTzkbdHELb+dtNRGyD3L739DZBUAthFHMmxiWhcwMStiYbs0Y8L3+rQjXcj6g10jSY7/a4EzeQEtUznumbDyEsc4UQISZMpQstAy0THi9C/eeiKqOym02w0NBvA5gaGEhg4jjLBDWDomeyxZxAoGBAPEwfq1dJ5ko5nUXP0h59F3z9DaBxy8NSmzQx1IfeGunitxJVqUKm1aTjeiqNlmOn2vKbgLQt7sgnuq7dyIpkdCIpv1Ur6h8X4JYrq2FV5nJPcKF0WaVfGHd1OyrxyLgVKAp/MCmzzEvDYEU03Y1FHXIMaxmYfZ7ORbODZAG3VvNAoGBAOEWFucKwOTaFJQ6q5s7f5SV/OumXht06x31ySHTB4AzndgiLHfg/N8DMuBI4XLM0S8xWA76tkqAEKgvdmF6OP/rnQDONFGQUqatSFsuFuwqcqWDsS1LFB//9SWIkQBfIyeHYZhnMt+pg7imKO8BVTvMPfqH5Sb+uXzafs7Yc3UxAoGAOfpYWUBNZonobDk8YyW90l/0Uq37vZnKTEIbx+f8wJQz0yRmCaJ1GOi7cjSIgBrCw9yTeWXG5NrAmNibmMC5ZpGS4s7asvvC0ciTpO6q0jMH/5y/a5N/pN74cjQQ2JdogF/XfFAc+ku/SUpCUuYLlwyatECgR+nzHUJHDFo6F/kCgYEAmos9eXrVGe34jer/2iDf7HcS1HjVRuH2d6WZ/sg9d9GzjUpv71WChuFXXcfixtc3crdmfKh31fnmOcUMt19pxxp0q6tCRCSHcK3XIzK9GRG7L/zqSmi6+igCdwBccJdHnI63ZHYtA5LMk/PcyjoMPMqyUtkoRmC3iNfPM4KoXgQ=
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjMt3BTfuzRnqIG8CDv2JefHEDFL3jN56li3t2wom1irb8AqPh5OqKAbXId45anPlsRYpSF110s61fVx8GFJa18Qlt8RC/GYj4JK58tQ9Oz18qTumMc5M9bu0thbnDtrYByjr9wrRFtelZdB41YNRG+sSg7tVG8donBRdc3NRbHaVRn53yG8lyajvh6AH1m/TyBkVGneuK7UM7kzo5vLv3UVVuqt+PAQrQppfDBnSbvOSrqLLkovdAqWxrEkvIjsO/FaImzWjSEQO3yhKnAhObfC6p6srykWNNh+vPrYC/gXgnBvE5uVjYIvURTTbZ96TrLOqlscuUreZEDceIh8KNwIDAQAB
1:001003001002001001001001003002003001-7666
新-1:1
通2:wx53f7c6c2b71db1c4
通3:1513565941
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:7666
3:[{"JPushId":"120c83f76122c314375","payMoney":0.04,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"11","ordersInformactions":[{"MealCode":"001003002003001","bowls":"4","name":"笋干菜黄豆猪蹄"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:594120240308172339254-00011
5:00011
6:oGiBQ5raFDJJmOAy4_GenEXmbdyI
7:594120240308172339254-00011
8:4200002159202403080627087707
9:OTHERS
10:0.04
11:0.04
12:2024/3/8 17:23:54
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00011
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00011"}
machineId：001003001002001001001001003002003001---errorCode：3299
machineId：001003001002001001001001003002003001---errorCode：3099
machineId：001003001002001001001001003002003001---errorCode：3099
machineId：001003001002001001001001003002003001---errorCode：3099
machineId：001003001002001001001001003002003001---errorCode：3299
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001---errorCode：3099
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001jPushId：120c83f76122c314375yw：1
machineId：001003001002001001001001003002003001---errorCode：3199