微信小程序开发-酒店营销版一体包.zip

<?php $sql="CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `weid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属帐号', `storeid` varchar(1000) NOT NULL COMMENT '门店id', `uid` int(10) unsigned NOT NULL DEFAULT '0', `from_user` varchar(100) NOT NULL DEFAULT '', `accountname` varchar(50) NOT NULL DEFAULT '', `password` varchar(200) NOT NULL DEFAULT '', `salt` varchar(10) NOT NULL DEFAULT '', `pwd` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `email` varchar(20) NOT NULL, `username` varchar(50) NOT NULL, `pay_account` varchar(200) NOT NULL, `displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '状态', `role` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:店长,2:店员', `lastvisit` int(10) unsigned NOT NULL DEFAULT '0', `lastip` varchar(15) NOT NULL, `areaid` int(10) NOT NULL DEFAULT '0' COMMENT '区域id', `is_admin_order` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_order` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_queue` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_service` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_notice_boss` tinyint(1) NOT NULL DEFAULT '0', `remark` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注', `lat` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '经度', `lng` decimal(18,10) NOT NULL DEFAULT '0.0000000000' COMMENT '纬度', `authority` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL COMMENT '轮播图标题', `logo` varchar(200) NOT NULL COMMENT '图片', `status` int(11) NOT NULL COMMENT '1.开启 2.关闭', `src` varchar(100) NOT NULL COMMENT '链接', `orderby` int(11) NOT NULL COMMENT '排序', `xcx_name` varchar(20) NOT NULL, `appid` varchar(20) NOT NULL, `uniacid` int(11) NOT NULL COMMENT '小程序id', `type` int(11) NOT NULL COMMENT '1开屏', `wb_src` varchar(300) NOT NULL COMMENT '外部链接', `state` int(4) NOT NULL DEFAULT '1' COMMENT '1内部，2外部,3跳转', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_assess` ( `id` int(11) NOT NULL AUTO_INCREMENT, `seller_id` int(11) NOT NULL COMMENT '商家ID', `score` int(11) NOT NULL COMMENT '分数', `content` text NOT NULL COMMENT '评价内容', `img` varchar(1000) NOT NULL COMMENT '图片', `time` int(11) NOT NULL COMMENT '创建时间', `user_id` int(11) NOT NULL COMMENT '用户ID', `uniacid` varchar(50) NOT NULL, `reply` varchar(1000) NOT NULL COMMENT '商家回复', `status` int(4) NOT NULL COMMENT '评价状态1，未回复，2已回复', `reply_time` int(11) NOT NULL COMMENT '回复时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评价表'; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_commission_withdrawal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝', `time` int(11) NOT NULL COMMENT '申请时间', `sh_time` int(11) NOT NULL COMMENT '审核时间', `uniacid` int(11) NOT NULL, `user_name` varchar(20) NOT NULL COMMENT '姓名', `account` varchar(100) NOT NULL COMMENT '账号', `tx_cost` decimal(10,2) NOT NULL COMMENT '提现金额', `sj_cost` decimal(10,2) NOT NULL COMMENT '实际到账金额', `note` varchar(50) NOT NULL DEFAULT '提现', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金提现'; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_coupons` ( `id` int(11) NOT NULL AUTO_INCREMENT, `seller_id` int(11) NOT NULL COMMENT '门店ID', `user_id` int(11) NOT NULL COMMENT '用户id', `name` varchar(50) NOT NULL COMMENT '优惠券名称', `start_time` varchar(20) NOT NULL COMMENT '开始时间', `end_time` varchar(20) NOT NULL COMMENT '结束时间', `conditions` varchar(100) NOT NULL COMMENT '优惠条件', `number` int(11) NOT NULL COMMENT '发布数量', `cost` decimal(10,2) NOT NULL COMMENT '金额', `type` int(4) NOT NULL COMMENT '发布类型1,平台,2门店', `introduce` varchar(100) NOT NULL COMMENT '说明', `lq_num` int(11) NOT NULL COMMENT '领取数量', `klqzs` int(11) NOT NULL DEFAULT '1' COMMENT '每人可领取张数', `time` int(11) NOT NULL, `uniacid` int(11) NOT NULL COMMENT '小程序id', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='优惠券'; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_czhd` ( `id` int(11) NOT NULL AUTO_INCREMENT, `full` int(11) NOT NULL, `reduction` int(11) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_distribution` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `time` int(11) NOT NULL, `user_name` varchar(20) NOT NULL, `user_tel` varchar(20) NOT NULL, `state` int(11) NOT NULL COMMENT '1.审核中2.通过3.拒绝', `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销申请'; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_dyj` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dyj_title` varchar(50) NOT NULL COMMENT '打印机标题', `dyj_id` varchar(50) NOT NULL COMMENT '打印机编号', `dyj_key` varchar(50) NOT NULL COMMENT '打印机key', `uniacid` varchar(50) NOT NULL, `type` int(11) NOT NULL COMMENT '1.365 2.易联云，3飞蛾', `name` varchar(20) NOT NULL COMMENT '打印机名称', `mid` varchar(100) NOT NULL COMMENT '打印机终端号', `api` varchar(100) NOT NULL COMMENT 'API密钥', `seller_id` int(11) NOT NULL COMMENT '商家ID', `state` int(11) NOT NULL COMMENT '1开启2关闭', `yy_id` varchar(20) NOT NULL COMMENT '用户id', `token` varchar(50) NOT NULL COMMENT '打印机终端密钥', `dyj_title2` varchar(50) NOT NULL, `dyj_id2` varchar(50) NOT NULL, `dyj_key2` varchar(50) NOT NULL, `fezh` varchar(40) NOT NULL COMMENT '飞蛾账号', `fe_ukey` varchar(50) NOT NULL COMMENT 'ukey', `fe_dycode` varchar(20) NOT NULL COMMENT '打印机编号', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_earnings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL COMMENT '订单ID', `user_id` int(11) NOT NULL, `son_id` int(11) NOT NULL COMMENT '下线', `money` decimal(10,2) NOT NULL, `time` int(11) NOT NULL, `note` varchar(50) NOT NULL COMMENT '备注', `state` int(4) NOT NULL COMMENT '佣金状态,1冻结,2有效,3无效', `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='佣金收益表'; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_fxset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fx_details` text NOT NULL COMMENT '分销商申请协议', `tx_details` text NOT NULL COMMENT '佣金提现协议', `is_fx` int(11) NOT NULL COMMENT '1.开启分销审核2.不开启', `is_ej` int(11) NOT NULL COMMENT '是否开启二级分销1.是2.否', `tx_rate` int(11) NOT NULL COMMENT '提现手续费', `commission` varchar(10) NOT NULL COMMENT '一级佣金', `commission2` varchar(10) NOT NULL COMMENT '二级佣金', `tx_money` int(11) NOT NULL COMMENT '提现门槛', `img` varchar(100) NOT NULL COMMENT '分销中心图片', `img2` varchar(100) NOT NULL COMMENT '申请分销图片', `uniacid` int(11) NOT NULL, `is_open` int(11) NOT NULL DEFAULT '1' COMMENT '1.开启2关闭', `instructions` text NOT NULL COMMENT '分销商说明', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_zh_jdgjb_fxuser` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '一级分销', `fx_user` int(11) NOT NU