一. 用戶(hù)表 user_info

username
passwd

1.1 用戶(hù)登錄

{
    "username"
    "passwd"
}

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

二. 分類(lèi)表 category_info

category_id
category_name
order_num

2.1 添加分類(lèi) addCategoryInfo

{
 "category_name": "分類(lèi)一",
 "order_num": 1
}

2.2 移除分類(lèi) removeCategoryInfo

{
  "category_id": "12345"
}

2.3 更新分類(lèi) updateCategoryInfo

{
    "category_id": "12345"
    "category_name": "分類(lèi)一",
    "order_num": 1
}

2.4 查詢(xún)分類(lèi) queryAllCategoryInfo

{
    "category_id": "12345"
    "category_name": "分類(lèi)一",
    "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 [需校驗(yàn)權(quán)限]

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

3.2 updateProductInfo [需校驗(yàn)權(quán)限]

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

3.3 removeProductInfo [需校驗(yàn)權(quán)限]

{
  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

四 客戶(hù)信息 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-潛在客戶(hù) 3-無(wú)效客戶(hù)
}

queryCustomerInfoByPage

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

五 首頁(yè)信息

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:
}

六 案例菜單

案例表結(jié)構(gòu) case_info

case_id
case_title
case_image_url
jump_url 跳轉(zhuǎn)公眾號(hào)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
}