一. 用户表 user_info

username
passwd

1.1 用户登录

{
    "username"
    "passwd"
}

{
    "status": 1
    "msg" :
    "data" : {
        "uname": "echo"
    }
}

二. 分类表 category_info

category_id
category_name
order_num

2.1 添加分类 addCategoryInfo

{
 "category_name": "分类一",
 "order_num": 1
}

2.2 移除分类 removeCategoryInfo

{
  "category_id": "12345"
}

2.3 更新分类 updateCategoryInfo

{
    "category_id": "12345"
    "category_name": "分类一",
    "order_num": 1
}

2.4 查询分类 queryAllCategoryInfo

{
    "category_id": "12345"
    "category_name": "分类一",
    "order_num": 1
}

三. 商品信息表 product_info

product_id
product_name
product_price
show_price 0 显示, 1 面议
thumbnail_id
mini_video_url:
category_id
detail_desc: txt
delete_flag: 0, 1 删除
order_num:

3.1 addProductInfo [需校验权限]

{
    product_name
    category_id
    product_price
    show_price 0 显示, 1 面议
    thumbnail_id
    mini_video_url:
    detail_desc: txt
    order_num:
}

3.2 updateProductInfo [需校验权限]

{
    product_name
    category_id
    product_price
    show_price 0 显示, 1 面议
    thumbnail_id
    mini_video_url:
    detail_desc: txt
    order_num:
}

3.3 removeProductInfo [需校验权限]

{
  product_id:
}

3.4 queryProductInfoByPage

{
    pageNum: 1,
    pageSize: 20,
    product_name: 
}

3.5 queryProductInfoByCategory

{
  "category_id": "12345"
}

3.6 uploadFile api

request

文件流

response

{
    fileStorePath
}

thumbnail_info

id
product_id
pic_url
order_num

四 客户信息 customer_info

customer_id
customer_name
phone_number
visit_status
create_date

addCustomerInfo

{
  customer_name
  phone_number
  visit_status  
}

updateCustomerInfo

{
  customer_id
  customer_name
  customer_address
  phone_number
  visit_status  -- 0 新增， 1-已回访 2-潜在客户 3-无效客户
}

queryCustomerInfoByPage

{
    pageNum: 1
    pageSize: 20
    visit_status:
    phone_number:
}

五 首页信息

home_slide

home_id
image_url: imageUrl1,imageUrl2,imageUrl3
home_content

addHomeInfo

{
    image_url:
    home_content:
}

updateHomeInfo

{   
    home_id:
    image_url:
    home_content:
}

queryHomeInfo

{   
    home_id:
    image_url:
    home_content:
}

六 案例菜单

案例表结构 case_info

case_id
case_title
case_image_url
jump_url 跳转公众号url
order_num
create_date
delete_flag 0 1

addCaseInfo

{
    case_title:
    case_image_url:
    jump_url:
    order_num:
}

updateCaseInfo

{   
    case_id:
    case_title:
    case_image_url:
    jump_url:
    order_num:
}

removeCaseInfo

{
    case_id:  ""
} 

queryCaseInfoByPage

{
    pageNum: 1
    pageSize: 20
}