商品表字段
```
`goods_id` int(11) : '商品id',
`cate_id` int(11) : '分類id',
`shop_id` int(11) : '店鋪id',
`goods_name` varchar(50) : '商品名稱',
`goods_price` decimal(5,1) : '商品價格',
`goods_stock` int(11) : '商品庫存',
`goods_about` varchar(100) : '商品描述',
`goods_account` varchar(100) : '商品使用說明',
`stock_type` int(2) : '減庫存方式:0未支付,1已支付',
`camilo_type` int(2) : '卡密類型:1標準卡2循環卡',
`camilo_show` varchar(50) : '卡密展示字段',
`is_play` int(2) : '商品狀態:0下架1上架',
`sell_num` int(11) : '賣出數量',
`update_time` datetime : '更新時間',
`create_time` datetime : '創建時間'
```
1.商品創建
~~~[api]
post:http://test.qingdabao.com/goods/goods_create
cate_id=1#分類id
shop_id=1#店鋪id
goods_name#商品名稱
goods_price#商品價格
goods_about#商品描述
goods_account#商品使用說明
stock_type#減庫存方式:0點擊未支付,1已支付
camilo_type#卡密類型:1標準卡2循環卡
camilo_show#卡密展示字段
is_play#商品上下架:0下架1上架
<<<
success
success
<<<
error
error
~~~
2.商品信息查詢
~~~[api]
get:http://test.qingdabao.com/goods/goods_find
goods_id=1#商品id
<<<
success
{
"status":?0,
"message":?"ok",
"data":?{
"goods_id":?1,
"cate_id":?1,
"shop_id":?1,
"goods_name":?"愛奇藝會員",
"goods_price":?"15.0",
"goods_stock":?50,
"goods_about":?"愛奇藝會員一月充值卡",
"goods_account":?"不能轉讓,只能使用一次",
"stock_type":?1,
"camilo_type":?1,
"camilo_show":?"account,password,pay_time,order_id",
"is_play":?1,
"camilo_num":?0,
"sell_num":?0,
"update_time":?"2020-04-01?16:57:09",
"create_time":?"2020-04-01?15:17:39"
????}
}
<<<
error
error
~~~
3.商品編輯
禁止修改字段['goods_id'=>'******','shop_id'=>'******','is_play'=>'******','camilo_num'=>'******','sell_num'=>'******','update_time'=>'******','create_time'=>'******'];
~~~[api]
put:http://test.qingdabao.com/goods/goods_edit
goods_id=1#商品id
array#一維數組:需要編輯的字段
<<<
success
success
<<<
error
error
~~~
4.商品刪除
~~~[api]
delete:http://test.qingdabao.com/goods/goods_del
goods_id=1#商品id
<<<
success
success
<<<
error
error
~~~
5.商品上下架
~~~[api]
put:http://test.qingdabao.com/goods/goods_display
goods_id=1#商品id
type#兩種情況:0=>下架,1=>上架
<<<
success
success
<<<
error
error
~~~
6.商品列表
查詢字段['shop_id'=>'**','cate_id'=>'**','is_play'=>'**']
shop_id不能為空,必須有初始值
search:
~~~[api]
post:http://test.qingdabao.com/goods/goods_list
page=1#頁碼(第幾頁)
type#兩種情況:1=>沒有搜說詞,2有搜索詞
array#查詢條件,一維數組
search#搜索關鍵詞,可選,對應type=2
<<<
success
success
<<<
error
error
~~~
7.下拉商品
~~~[api]
get:http://test.qingdabao.com/goods/goods_down_list
shop_id#店鋪id
cate_id#分類id
<<<
success
{
"status":?0,
"message":?"ok",
"data":?[
????????{
"goods_id":?1,
"cate_id":?1,
"shop_id":?1,
"goods_name":?"愛奇藝會員",
"goods_price":?"15.0",
"goods_stock":?50,
"goods_about":?"愛奇藝會員一月充值卡",
"goods_account":?"不能轉讓,只能使用一次",
"stock_type":?1,
"camilo_type":?1,
"camilo_show":?"account,password,pay_time,order_id",
"is_play":?1,
"camilo_num":?0,
"sell_num":?0,
"update_time":?"2020-04-01?16:57:09",
"create_time":?"2020-04-01?15:17:39"
????????}
????]
}
<<<
error
error
~~~