66936+零象废品回收小程序V2.3.0+前端+开源版.rar

<?php //升级数据表 pdo_query("CREATE TABLE IF NOT EXISTS `ims_ox_reclaim_address` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) DEFAULT NULL, `uniacid` int(10) DEFAULT NULL, `latitude` decimal(10,4) DEFAULT NULL COMMENT 'mapx', `longitude` decimal(11,4) DEFAULT NULL COMMENT 'mapy', `province` varchar(20) DEFAULT NULL COMMENT '省', `city` varchar(20) DEFAULT NULL COMMENT '市', `district` varchar(20) DEFAULT NULL COMMENT '区/县', `name` varchar(20) DEFAULT NULL COMMENT '联系人', `phone` varchar(11) DEFAULT NULL COMMENT '联系方式', `address` varchar(50) DEFAULT NULL COMMENT '服务地址', `address_detail` varchar(50) DEFAULT NULL COMMENT '详细地址', `default` tinyint(4) DEFAULT NULL COMMENT '1 是默认', `create_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; "); if(!pdo_fieldexists('ox_reclaim_address','id')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `id` int(10) NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('ox_reclaim_address','uid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `uid` int(10) DEFAULT NULL");} if(!pdo_fieldexists('ox_reclaim_address','uniacid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `uniacid` int(10) DEFAULT NULL");} if(!pdo_fieldexists('ox_reclaim_address','latitude')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `latitude` decimal(10,4) DEFAULT NULL COMMENT 'mapx'");} if(!pdo_fieldexists('ox_reclaim_address','longitude')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `longitude` decimal(11,4) DEFAULT NULL COMMENT 'mapy'");} if(!pdo_fieldexists('ox_reclaim_address','province')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `province` varchar(20) DEFAULT NULL COMMENT '省'");} if(!pdo_fieldexists('ox_reclaim_address','city')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `city` varchar(20) DEFAULT NULL COMMENT '市'");} if(!pdo_fieldexists('ox_reclaim_address','district')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `district` varchar(20) DEFAULT NULL COMMENT '区/县'");} if(!pdo_fieldexists('ox_reclaim_address','name')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `name` varchar(20) DEFAULT NULL COMMENT '联系人'");} if(!pdo_fieldexists('ox_reclaim_address','phone')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `phone` varchar(11) DEFAULT NULL COMMENT '联系方式'");} if(!pdo_fieldexists('ox_reclaim_address','address')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `address` varchar(50) DEFAULT NULL COMMENT '服务地址'");} if(!pdo_fieldexists('ox_reclaim_address','address_detail')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `address_detail` varchar(50) DEFAULT NULL COMMENT '详细地址'");} if(!pdo_fieldexists('ox_reclaim_address','default')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `default` tinyint(4) DEFAULT NULL COMMENT '1 是默认'");} if(!pdo_fieldexists('ox_reclaim_address','create_time')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_address')." ADD `create_time` int(11) DEFAULT NULL");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_ox_reclaim_banner` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(10) DEFAULT NULL COMMENT '小程序id', `img` varchar(100) DEFAULT NULL COMMENT '图片地址', `url` varchar(255) DEFAULT NULL COMMENT '链接地址', `sort` int(10) DEFAULT NULL COMMENT '排序', `create_time` int(10) DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; "); if(!pdo_fieldexists('ox_reclaim_banner','id')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('ox_reclaim_banner','uniacid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `uniacid` int(10) DEFAULT NULL COMMENT '小程序id'");} if(!pdo_fieldexists('ox_reclaim_banner','img')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `img` varchar(100) DEFAULT NULL COMMENT '图片地址'");} if(!pdo_fieldexists('ox_reclaim_banner','url')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `url` varchar(255) DEFAULT NULL COMMENT '链接地址'");} if(!pdo_fieldexists('ox_reclaim_banner','sort')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `sort` int(10) DEFAULT NULL COMMENT '排序'");} if(!pdo_fieldexists('ox_reclaim_banner','create_time')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_banner')." ADD `create_time` int(10) DEFAULT NULL COMMENT '创建时间'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_ox_reclaim_city` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '开通城市id', `uniacid` int(10) DEFAULT NULL COMMENT '小程序id', `province` varchar(20) DEFAULT NULL COMMENT '省份名称', `city_name` varchar(20) DEFAULT NULL COMMENT '城市名称', `status` tinyint(4) DEFAULT '0' COMMENT '开通状态 0 未开通 1 已开通', `create_time` int(10) DEFAULT NULL COMMENT '申请时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; "); if(!pdo_fieldexists('ox_reclaim_city','id')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '开通城市id'");} if(!pdo_fieldexists('ox_reclaim_city','uniacid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `uniacid` int(10) DEFAULT NULL COMMENT '小程序id'");} if(!pdo_fieldexists('ox_reclaim_city','province')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `province` varchar(20) DEFAULT NULL COMMENT '省份名称'");} if(!pdo_fieldexists('ox_reclaim_city','city_name')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `city_name` varchar(20) DEFAULT NULL COMMENT '城市名称'");} if(!pdo_fieldexists('ox_reclaim_city','status')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `status` tinyint(4) DEFAULT '0' COMMENT '开通状态 0 未开通 1 已开通'");} if(!pdo_fieldexists('ox_reclaim_city','create_time')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_city')." ADD `create_time` int(10) DEFAULT NULL COMMENT '申请时间'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_ox_reclaim_cycle` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uniacid` int(10) DEFAULT NULL, `uid` int(10) DEFAULT NULL, `order_id` int(10) DEFAULT NULL COMMENT '订单id', `account` decimal(10,2) DEFAULT NULL COMMENT '订单金额', `create_time` int(10) DEFAULT NULL COMMENT '创建时间', `admin_uid` int(11) unsigned DEFAULT NULL COMMENT '操作员id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; "); if(!pdo_fieldexists('ox_reclaim_cycle','id')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `id` int(10) NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('ox_reclaim_cycle','uniacid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `uniacid` int(10) DEFAULT NULL");} if(!pdo_fieldexists('ox_reclaim_cycle','uid')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `uid` int(10) DEFAULT NULL");} if(!pdo_fieldexists('ox_reclaim_cycle','order_id')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `order_id` int(10) DEFAULT NULL COMMENT '订单id'");} if(!pdo_fieldexists('ox_reclaim_cycle','account')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `account` decimal(10,2) DEFAULT NULL COMMENT '订单金额'");} if(!pdo_fieldexists('ox_reclaim_cycle','create_time')) {pdo_query("ALTER TABLE ".tablename('ox_reclaim_cycle')." ADD `create_time` int(10) DEFAULT NULL COMMENT '创建时间'");} if(!pdo_fieldexists('ox_reclaim_cycle','admin_uid')) {pdo_query("ALT