下单相关接口

# 下单接口 post http://testingapi.pengpengwaimai.top/order/down ### 前端传入 黑色括号里面的字段 INSERT INTO `testing`.`orders` (`createtime`, `sender`, `sendmobile`, `sendaddress`, `sendarea`, `sendcity`, `sendprovince`, `receiver`, `receivemobile`, `receiveaddress`, `receiveprovince`, `receivecity`, `receivearea`, `goodstype`, `transtype`, `appointment`, `staffid`, `companyid`, `status`, `note`) VALUES ( 【创建时间】, 【寄件人】, 【寄件手机号】, 【寄件地址】, 【寄件区县】,【寄件城市】, 【寄件省份】, 【收件人】, 【收件手机号】, 【收件地址】, 【收件省份】,【收件城市】, 【收件区县】,【物品类型string】,【运输方式string】,【预约时间】, 【月结账号id,可能为空】, 【companyid,可能为空】, 0,【备注信息string】); http://testingapi.pengpengwaimai.top/order/down?sender=1& sendprovince=江苏&receiver=1&receivemobile=13000000000&receiveaddress=1&receiveprovince=江苏&receivecity=盐城&receivearea=1&goodstype=干冰&transtype=冷藏&appointment=2019-12-09 12:00:00&staffid=1&companyid=1&status=0&note=量大&sendmobile=13000000000&sendaddress=1&sendarea=1&sendcity=连云港 ![image.png](https://cos.easydoc.net/81242367/files/k3xsz3fp.png) # 智能解析接口 http://testingapi.pengpengwaimai.top/user/get-area 需要按照用户填写的数据进行解析,需要写个算法,后续补充 http://testingapi.pengpengwaimai.top/user/get-area?contect=桐乡市文化小区576栋 {"status":"success","data":{"original":"桐乡市文化小区576栋","phone":"","mobile":"","name":"","note":"","province_id":"334","province_name":"浙江省","province_shortname":"浙江","city_id":"1149","city_name":"嘉兴市","city_shortname":"嘉兴","county_id":"1218","county_name":"桐乡市","county_shortname":"桐乡","detail":"文化小区576栋"}} # 获取省市区接口 http://testingapi.pengpengwaimai.top/index/area 方法 get,返回了全部的省市区信息 ## 最新测试结果 可用 ![image.png](https://cos.easydoc.net/81242367/files/k3xt3xmd) # 查询订单接口 http://testingapi.pengpengwaimai.top/order/index ### 前端传入openid,或者传入openid + 手机号 select * from orders where openid = '' ### 或者 select * from orders where (sendmobile ='' or receivemobile = '') and openid = '' 返回订单表的所有字段,可能是多个 ## 最新测试结果 可用 请求 http://testingapi.pengpengwaimai.top/order/index?openid=111222 或http://testingapi.pengpengwaimai.top/order/index?openid=111222&mobile=1000000000 返回 {"status":"success","data":{"order_list":[{"id":"1","createtime":"2019-12-09 10:19:55","sender":"寄件人","sendmobile":"1300000000","sendaddress":"11","sendarea":"1","sendcity":"1","sendprovince":"1","receiver":"yalkng","receivemobile":"1000000000","receiveaddress":"1","receiveprovince":"1","receivecity":"1","receivearea":"1","goodstype":"1","transtype":"1","appointment":"2019-12-03 16:28:41","staffid":"1","companyid":"1","money":"1.00","status":"0","expressname":"1","expressno":"1","note":null,"openid":"111222"}]}}