安卓拉计提数据999++2024/6/17 10:37: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/custom/001003001002001001/box/1-141036552.jpg","step":[{"temperature":"001003002003001001001","second":"40"},{"temperature":"001003002003001001002","second":"7"},{"temperature":"001003002003001001003","second":"3"}]},{"MealName":"辣酱叉烧豚骨拉面","MealCode":"001003002003002","MealPlc":"2","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/2-1411052.jpg","step":[{"temperature":"001003002003002001001","second":"40"},{"temperature":"001003002003002001002","second":"7"},{"temperature":"001003002003002001003","second":"3"}]},{"MealName":"高汤鸡丝面","MealCode":"001003002003003","MealPlc":"3","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/3-14112068.jpg","step":[{"temperature":"001003002003003001001","second":"40"},{"temperature":"001003002003003001002","second":"7"},{"temperature":"001003002003003001003","second":"3"}]},{"MealName":"红烧牛肉面","MealCode":"001003002003004","MealPlc":"4","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/4-14120220.jpg","step":[{"temperature":"001003002003004001001","second":"45"},{"temperature":"001003002003004001002","second":"7"},{"temperature":"001003002003004001003","second":"3"}]},{"MealName":"咸菜肉丝面","MealCode":"001003002003005","MealPlc":"5","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/5-141230916.jpg","step":[{"temperature":"001003002003005001001","second":"40"},{"temperature":"001003002003005001002","second":"7"},{"temperature":"001003002003005001003","second":"3"}]},{"MealName":"虾仁面","MealCode":"001003002003006","MealPlc":"6","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/6-141256711.jpg","step":[{"temperature":"001003002003006001001","second":"40"},{"temperature":"001003002003006001002","second":"7"},{"temperature":"001003002003006001003","second":"3"}]},{"MealName":"酸菜肥牛面","MealCode":"001003002003007","MealPlc":"7","sale":"0.01","foodIcon":"http://www.bjyx.ltd:8088/revolution/machineSettingPic/custom/001003001002001001/box/7-141311564.jpg","step":[{"temperature":"001003002003007001001","second":"40"},{"temperature":"001003002003007001002","second":"7"},{"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":"2","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":"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":"0","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":"0","stade":"1"},{"aisle":"14","goodsId":"001003002003005","inventory":"2","stock":"0","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":"0","stade":"1"},{"aisle":"20","goodsId":"001003002003007","inventory":"2","stock":"0","stade":"1"},{"aisle":"21","goodsId":"001003002003007","inventory":"2","stock":"1","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：3199
yyyyyyy：00001
欣欣0：2
欣欣1：wx2c7d4d4684312a7c
欣欣2：1582814841
<xml><appid><![CDATA[wx2c7d4d4684312a7c]]></appid><attach><![CDATA[001003001002001001001001003002003001-8020]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1582814841]]></mch_id><nonce_str><![CDATA[2270516440]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[4841202406171502449-00001]]></out_trade_no><product_id><![CDATA[00001]]></product_id><sign><![CDATA[d5e6d0c916ddf4b2df723d76236b6909a9aa774811e4af60842dee7e1192558f]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240617150345]]></time_expire><time_start><![CDATA[20240617150243]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx2c7d4d4684312a7c]]></appid><attach><![CDATA[001003001002001001001001003002003001-8020]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1582814841]]></mch_id><nonce_str><![CDATA[2270516440]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[4841202406171502449-00001]]></out_trade_no><product_id><![CDATA[00001]]></product_id><sign><![CDATA[d5e6d0c916ddf4b2df723d76236b6909a9aa774811e4af60842dee7e1192558f]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240617150345]]></time_expire><time_start><![CDATA[20240617150243]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2021004144627994
ali0-merchant_private_key：MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC5+tNqQ0BmLPOfU8nMbG7b6SgTrsifIDsz1HzELkxKsaUrKcgH7NOQSp2nlWAdHF72/mbVBH237kCh95GslMhoUeLP9PxcNC2Y0giNZwfpGAIxcJmGm2qHRISOy0goHDu0osANlraFE+boxpSn5w14EA5nsyI7cng8nELiaAYOnKVV62012bTpINN+XLu1QNQd8z2bx02hNFGpHiXstjsYHkIna6DITGDD5G6hsqy2YCK6roFiEZBNUHQ+OhYQ0eWIf+3b+0+idps8gNukqxWdsLVBd4TYSaCcAnfpoEdzNK1ohaump+jh7C5+e7P2T1DW0JLIZFCGzhqHToH0wI1zAgMBAAECggEBAJuh7eefzbVzao/rMxUxrHe1HoeSHWskMsbFy370a32aOWjsdutC4Sx/dHz4AM17n3C8Jdue/YG9DDM+FJbCjw7Vb6OtFL4oH/whz2xdSv5hy/wJiUBesH/v86n3LTP7pG8ePu9gLu8gX3xuKZp0PQ47CYL4Ie5zdXDrJwGGIYN5XNiM//wFi5Nq5dCbzlRXzRga0DTtms2fqSKGMkC2PXhIRfRvl6h4vjcV3ASQ69b2rTyu5oGgb4Xf0VYP91WhoyBct8UvWkp6iwk8BaE6SHwtQ8ok5DzxnOYUNFMsBTscQSGJukijpjgGoKK3wMFNvPNtW6U8IrmMwYQZ4MJSBMECgYEA9u6RDmwe8/onbC8a7BQDkksEPjB61gTU9SFVgmAAF1jG0I1XDIJEvuON2Ehx0ojcNToE6SUwzFwcWrlsRt7PuQjBU4U6L8YbugeMAkygO3cdxnzqTGd8MD/7bZJ9dBR+rEEo9M/ppnRE/NvoOp0RtH0wrAJ6HzFE4M2/4nKLUCECgYEAwM896ZUVMgzXeyZ9Ws07vO9PXBsGtjqvkhHsU2Xo66kYgEdts9BlyhYORHtHGJGvd/y+P8ZIHIEWygVVE+TuyN0CYmiu4CLC4dL1etPlOJuIhNG4oA3aitd8zeAtrTRw7aEH5lxXtjKcJFbgGq8VzU0glcAHl1VOGOaqY2KyOxMCgYA1Bkud1jfbWjdG8uKMGUwfCP7TP+PQu17jeJH9GhJK8SRYOlGb/Qk4GHMoI35VoE/xGhFd4z+UUp9AGBsZKNVgPXIONkilY5wmmWJGSCAMROre6YoCeCJh1gtunwtTducwpBlgYJkixkreJXa7x2i64jsmZK3GrvTEdUokHUavIQKBgHfCgh9LNZ4f8dwRfT1gSyHAt1drhhC8hP9C2Lq4iyONpaVQOKi+4erTJkuNEw0EuKvbtkQgofvqhsA27bBsu5DSDkAX679WeBwSj92aLj+qA/MT3Qy1bjBdRq0N+PEjqJ1BL4n7g5Os/eVofMy2QeGCbaH2ZACwwNCgveb7j983AoGBALaz7Gqex0EGWcZuAu0YGvzK5Ar1THGJB7ALfIn+pt7J1pd9PsdsxHIYblYeK1rlA5l/NA/9aABLamNiAA28frHnJl40iHRqcHPZLm7RC+xUpfByXTFkLxklmtHERDriTdky7YV1O1bJ1EBFlGQQP7qKucTHcjxavT/QS8oI3Pkr
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjdLHtuopqlh1XEGUFDykG5kBem/VQDQXbJBWBhqAUOGB8ySZ7gkGfb4zRgR+HXL9qqMTwLIQ7+nGiGApTUHl3XNf0BXGHHKw4T+Ztnr0mD9wNh0Eat+6ZSZ3aPQ0VaQnVZYlethYGwYitXVtc0CTvX3o634UcivLQ6UtAUySt5rM+r5eTs27BqRFR+DEOIE1CqT0Y6HjNkvshj2tzdkdylG6x98ukpWIb5homC+YAdErfzzAeo1h4sub+DB+ulwTXvVXEPs6jA5l4OG2FklpALdmoVDhVg6dwMmsBVuF+E9y4Jx8bZ+g6/6miNffHxMoumTJHPaSSwPtiGexdDhVBQIDAQAB
测试微信付款返回
1:001003001002001001001001003002003001-8020
新-1:2
通2:wx2c7d4d4684312a7c
通3:1582814841
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:8020
3:[{"JPushId":"120c83f76122c314375","payMoney":0.01,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"1","ordersInformactions":[{"MealCode":"001003002003005","bowls":"1","name":"咸菜肉丝面"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:4841202406171502449-00001
5:00001
6:o5PgIj4YNJ6zOJB070qKU0Pau6qw
7:4841202406171502449-00001
8:4200002304202406178209012748
9:OTHERS
10:0.01
11:0.01
12:2024/6/17 15:03:04
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00001
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00001"}
自动退款第一步2024/6/17 15:03:41：[{"errorCode":199,"machineid":"001003001002001001001001003002003001","macId":"301F9A895CB1","refundInformactions":[{"orderSort":"00001","refundMeals":[{"mealCode":"001003002003005"}]}]}]
错误代码001003001002001001001001003002003001：199
自动退款第二步2024/6/17 15:03:41： 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;
自动退款第二+步4200002304202406178209012748
自动退款第三步2024/6/17 15:03:41：4200002304202406178209012748=1
machineId：001003001002001001001001003002003001---errorCode：199
yyyyyyy：00002
欣欣0：2
欣欣1：wx2c7d4d4684312a7c
欣欣2：1582814841
<xml><appid><![CDATA[wx2c7d4d4684312a7c]]></appid><attach><![CDATA[001003001002001001001001003002003001-8021]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1582814841]]></mch_id><nonce_str><![CDATA[2351415786]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[484120240617151838189-00002]]></out_trade_no><product_id><![CDATA[00002]]></product_id><sign><![CDATA[eed80d43c16246652d8e068d1c280c11f0f45ac968fa0cfbc43db7b99e149d51]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240617151939]]></time_expire><time_start><![CDATA[20240617151837]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
欣欣3：<xml><appid><![CDATA[wx2c7d4d4684312a7c]]></appid><attach><![CDATA[001003001002001001001001003002003001-8021]]></attach><body><![CDATA[享·食无人面馆]]></body><goods_tag><![CDATA[YX]]></goods_tag><mch_id><![CDATA[1582814841]]></mch_id><nonce_str><![CDATA[2351415786]]></nonce_str><notify_url><![CDATA[http://www.bjyx.ltd/api/FindWxNotify/WxNotify]]></notify_url><out_trade_no><![CDATA[484120240617151838189-00002]]></out_trade_no><product_id><![CDATA[00002]]></product_id><sign><![CDATA[eed80d43c16246652d8e068d1c280c11f0f45ac968fa0cfbc43db7b99e149d51]]></sign><sign_type><![CDATA[HMAC-SHA256]]></sign_type><spbill_create_ip><![CDATA[0.0.0.0]]></spbill_create_ip><time_expire><![CDATA[20240617151939]]></time_expire><time_start><![CDATA[20240617151837]]></time_start><total_fee>1</total_fee><trade_type><![CDATA[NATIVE]]></trade_type></xml>
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
ali0-appId：2021004144627994
ali0-merchant_private_key：MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC5+tNqQ0BmLPOfU8nMbG7b6SgTrsifIDsz1HzELkxKsaUrKcgH7NOQSp2nlWAdHF72/mbVBH237kCh95GslMhoUeLP9PxcNC2Y0giNZwfpGAIxcJmGm2qHRISOy0goHDu0osANlraFE+boxpSn5w14EA5nsyI7cng8nELiaAYOnKVV62012bTpINN+XLu1QNQd8z2bx02hNFGpHiXstjsYHkIna6DITGDD5G6hsqy2YCK6roFiEZBNUHQ+OhYQ0eWIf+3b+0+idps8gNukqxWdsLVBd4TYSaCcAnfpoEdzNK1ohaump+jh7C5+e7P2T1DW0JLIZFCGzhqHToH0wI1zAgMBAAECggEBAJuh7eefzbVzao/rMxUxrHe1HoeSHWskMsbFy370a32aOWjsdutC4Sx/dHz4AM17n3C8Jdue/YG9DDM+FJbCjw7Vb6OtFL4oH/whz2xdSv5hy/wJiUBesH/v86n3LTP7pG8ePu9gLu8gX3xuKZp0PQ47CYL4Ie5zdXDrJwGGIYN5XNiM//wFi5Nq5dCbzlRXzRga0DTtms2fqSKGMkC2PXhIRfRvl6h4vjcV3ASQ69b2rTyu5oGgb4Xf0VYP91WhoyBct8UvWkp6iwk8BaE6SHwtQ8ok5DzxnOYUNFMsBTscQSGJukijpjgGoKK3wMFNvPNtW6U8IrmMwYQZ4MJSBMECgYEA9u6RDmwe8/onbC8a7BQDkksEPjB61gTU9SFVgmAAF1jG0I1XDIJEvuON2Ehx0ojcNToE6SUwzFwcWrlsRt7PuQjBU4U6L8YbugeMAkygO3cdxnzqTGd8MD/7bZJ9dBR+rEEo9M/ppnRE/NvoOp0RtH0wrAJ6HzFE4M2/4nKLUCECgYEAwM896ZUVMgzXeyZ9Ws07vO9PXBsGtjqvkhHsU2Xo66kYgEdts9BlyhYORHtHGJGvd/y+P8ZIHIEWygVVE+TuyN0CYmiu4CLC4dL1etPlOJuIhNG4oA3aitd8zeAtrTRw7aEH5lxXtjKcJFbgGq8VzU0glcAHl1VOGOaqY2KyOxMCgYA1Bkud1jfbWjdG8uKMGUwfCP7TP+PQu17jeJH9GhJK8SRYOlGb/Qk4GHMoI35VoE/xGhFd4z+UUp9AGBsZKNVgPXIONkilY5wmmWJGSCAMROre6YoCeCJh1gtunwtTducwpBlgYJkixkreJXa7x2i64jsmZK3GrvTEdUokHUavIQKBgHfCgh9LNZ4f8dwRfT1gSyHAt1drhhC8hP9C2Lq4iyONpaVQOKi+4erTJkuNEw0EuKvbtkQgofvqhsA27bBsu5DSDkAX679WeBwSj92aLj+qA/MT3Qy1bjBdRq0N+PEjqJ1BL4n7g5Os/eVofMy2QeGCbaH2ZACwwNCgveb7j983AoGBALaz7Gqex0EGWcZuAu0YGvzK5Ar1THGJB7ALfIn+pt7J1pd9PsdsxHIYblYeK1rlA5l/NA/9aABLamNiAA28frHnJl40iHRqcHPZLm7RC+xUpfByXTFkLxklmtHERDriTdky7YV1O1bJ1EBFlGQQP7qKucTHcjxavT/QS8oI3Pkr
ali0-alipay_public_key：MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjdLHtuopqlh1XEGUFDykG5kBem/VQDQXbJBWBhqAUOGB8ySZ7gkGfb4zRgR+HXL9qqMTwLIQ7+nGiGApTUHl3XNf0BXGHHKw4T+Ztnr0mD9wNh0Eat+6ZSZ3aPQ0VaQnVZYlethYGwYitXVtc0CTvX3o634UcivLQ6UtAUySt5rM+r5eTs27BqRFR+DEOIE1CqT0Y6HjNkvshj2tzdkdylG6x98ukpWIb5homC+YAdErfzzAeo1h4sub+DB+ulwTXvVXEPs6jA5l4OG2FklpALdmoVDhVg6dwMmsBVuF+E9y4Jx8bZ+g6/6miNffHxMoumTJHPaSSwPtiGexdDhVBQIDAQAB
测试微信付款返回
1:001003001002001001001001003002003001-8021
新-1:2
通2:wx2c7d4d4684312a7c
通3:1582814841
往服务器写入数据成功
获取服务端返回成功
获取服务端返回数据成功
2:8021
3:[{"JPushId":"120c83f76122c314375","payMoney":0.01,"machineType":"001003002003","macId":"301F9A895CB1","macAddress":"301F9A895CB1","ordersId":"2","ordersInformactions":[{"MealCode":"001003002003003","bowls":"1","name":"高汤鸡丝面"}],"machineId":"001003001002001001001001003002003001","machinesId":"001003001002001001001"}]
4:484120240617151838189-00002
5:00002
6:o5PgIj5pOBXNAq9okMZ11rUNqm8g
7:484120240617151838189-00002
8:4200002144202406174772079055
9:OTHERS
10:0.01
11:0.01
12:2024/6/17 15:19:01
开始执行zfsetorders
插入数据完成120c83f76122c314375
13：001003001002001001001001003002003001
14：00002
15：120c83f76122c314375
16：120c83f76122c314375
17：{"type":"2","machineid":"001003001002001001001001003002003001","numbersPayComplete":"00002"}