一,后端修改文件:
1,/admin/goodscat.php
2,/admin/goods.php
3,/admin/comcat.php
4,/include/goods.fun.php
5,/admin/templates/list_goods_cat.htm
6,/admin/templates/add_goods_cat.htm
7,/admin/templates/edit_goods_cat.htm
8,/admin/templates/index.htm
9,/admin/templates/list_com_cat.htm
10,/admin/templates/add_com_cat.htm
11,/admin/templates/edit_com_cat.htm
12,/admin/templates/list_goods.htm
13,/admin/templates/add_goods.htm
14,/admin/templates/edit_goods.htm
15,/admin/templates/edit_admin.htm
16,/admin/templates/add_admin.htm
17,/api/goods.php
18,/api/upload.php
19,/api/postgoods.php
20,/api/com.php
21,/api/member.php
22,/include/global.fun.php
二,前端修改文件:
1,/pages/user/upload_all.vue
2,/pages/user/upload_one.vue
3,/pages/index/user.vue
三,新增数据库表:
1,新增goods表
CREATE TABLE `sijicms_goods` (
`goodsid` int(10) NOT NULL AUTO_INCREMENT,
`goodsbh` varchar(11) NOT NULL,
`userid` varchar(30) NOT NULL,
`comid` int(8) NOT NULL,
`goodsname` varchar(100) NOT NULL,
`catid` varchar(5) NOT NULL,
`oldprice` varchar(8) NOT NULL DEFAULT '0',
`nowprice` varchar(8) NOT NULL DEFAULT '0',
`content` mediumtext,
`picture` varchar(255) NOT NULL,
`pre_picture` varchar(255) NOT NULL,
`tuijian` tinyint(1) NOT NULL,
`cuxiao` tinyint(1) NOT NULL,
`remai` tinyint(1) NOT NULL,
`onsale` tinyint(1) NOT NULL DEFAULT '9',
`hit` int(10) NOT NULL,
`dateline` int(10) NOT NULL,
`areaid` mediumint(6) NOT NULL,
`cont_sign` varchar(50) NOT NULL DEFAULT '0',
PRIMARY KEY (`goodsid`),
KEY `userid` (`userid`,`catid`),
KEY `cityid` (`areaid`),
KEY `goodsname` (`goodsname`) USING BTREE,
KEY `picture` (`picture`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=65849 DEFAULT CHARSET=utf8;
2,新增goods_cat表
CREATE TABLE `sijicms_goods_cat` (
`catid` mediumint(6) NOT NULL AUTO_INCREMENT,
`catname` varchar(32) NOT NULL,
`keywords` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`parentid` int(11) DEFAULT NULL COMMENT '大类ID',
`catorder` smallint(6) NOT NULL COMMENT '排序',
`goods_cats` varchar(100) NOT NULL DEFAULT '-1' COMMENT '允许发布的商品分类ID;-1是不允许,0是不限制,其他值表示限制对应分类',
PRIMARY KEY (`catid`),
KEY `parentid` (`parentid`),
KEY `catname` (`catname`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
3,com_cat 表增加 goods_cats
ALTER TABLE `sijicms_com_cat`
ADD COLUMN `goods_cats` varchar(100) NOT NULL DEFAULT '-1'
COMMENT '允许发布的商品分类ID;-1是不允许,0是不限制,其他值表示限制对应分类'
AFTER `catorder`;