接口文档

# 客户名获取接口 express库,z_company表 返回company_name字段的值 ,取 update_time 大于2020-02-17 00:00:00 的 ![image.png](https://cos.easydoc.net/81242367/files/k6u1nyio.png) #### 链接地址:http://poststation.pengpengwaimai.top/company/index http://poststation.pengpengwaimai.top/company/index1 奉贤鲁总用户列表接口 # 数据上传接口 app前端上传的数据,插入到express库,z_weight表,不用做去重判断,直接插入就可以,成功返回code 0 ![image.png](https://cos.easydoc.net/81242367/files/k6u1qfxk.png) #### 链接地址:http://poststation.pengpengwaimai.top/company/weight #### 参数:post传参,参数包括data #### data参数格式:json格式 [{ "yundanbianhao": "75308065407870", "kehuzhongliang": "8.83", "shoujianren": "唐伟", "createtime": "2020-03-04 12:33" }, { "yundanbianhao": "75308065407870", "kehuzhongliang": "8.83", "shoujianren": "唐伟", "createtime": "2020-03-04 12:33" }] # 数据查询接口 传入日期,返回 该日期,每个客户的发货数量,和发货总数 查询sql举例: SELECT count(DISTINCT(yundanbianhao)) as number, shoujianren FROM `z_weight` where createtime > '2019-11-01 00:00:00' and createtime < '2019-11-02 00:00:00' GROUP BY shoujianren; ![image.png](https://cos.easydoc.net/81242367/files/k6u1x79p.png) SELECT count(DISTINCT(yundanbianhao)) as number FROM `z_weight` where createtime > '2019-11-01 00:00:00' and createtime < '2019-11-02 00:00:00'; ![image.png](https://cos.easydoc.net/81242367/files/k6u1yfdf.png) #### 链接地址:http://poststation.pengpengwaimai.top/company/goods #### 参数:post传参,参数包括(time)