毕业设计-扫码点餐多人同步 2.0.0-整站商业源码.zip

<?php //升级数据表 pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_card_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '门店id', `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额', `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡的id', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值', `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间', `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员', `paytype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1现金2微信支付3支付宝4银行卡', `money` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='办卡充值记录'; "); if(!pdo_fieldexists('dy_card_log','id')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('dy_card_log','sid')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `sid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '门店id'");} if(!pdo_fieldexists('dy_card_log','price')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额'");} if(!pdo_fieldexists('dy_card_log','cid')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡的id'");} if(!pdo_fieldexists('dy_card_log','type')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值'");} if(!pdo_fieldexists('dy_card_log','time')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间'");} if(!pdo_fieldexists('dy_card_log','cashier')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员'");} if(!pdo_fieldexists('dy_card_log','paytype')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `paytype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1现金2微信支付3支付宝4银行卡'");} if(!pdo_fieldexists('dy_card_log','money')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `money` int(10) NOT NULL DEFAULT '0'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_card_order` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '门店id', `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡id', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值 3消费 4冲正', `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间', `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额', `ons` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1店内2手机', `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员id', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='会员卡办卡消费充值记录'; "); if(!pdo_fieldexists('dy_card_order','id')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('dy_card_order','sid')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '门店id'");} if(!pdo_fieldexists('dy_card_order','cid')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡id'");} if(!pdo_fieldexists('dy_card_order','type')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值 3消费 4冲正'");} if(!pdo_fieldexists('dy_card_order','time')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间'");} if(!pdo_fieldexists('dy_card_order','price')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额'");} if(!pdo_fieldexists('dy_card_order','ons')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `ons` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1店内2手机'");} if(!pdo_fieldexists('dy_card_order','cashier')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员id'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_desk` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家', `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id', `number` varchar(32) NOT NULL DEFAULT '' COMMENT '桌台号', `people` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '可座人数', `sort` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '空闲挂单付款0 1 2', `reserve` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '预订 1开0关', `type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='餐桌'; "); if(!pdo_fieldexists('dy_desk','id')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('dy_desk','sid')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家'");} if(!pdo_fieldexists('dy_desk','cid')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id'");} if(!pdo_fieldexists('dy_desk','number')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `number` varchar(32) NOT NULL DEFAULT '' COMMENT '桌台号'");} if(!pdo_fieldexists('dy_desk','people')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `people` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '可座人数'");} if(!pdo_fieldexists('dy_desk','sort')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `sort` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '排序'");} if(!pdo_fieldexists('dy_desk','status')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '空闲挂单付款0 1 2'");} if(!pdo_fieldexists('dy_desk','reserve')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `reserve` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '预订 1开0关'");} if(!pdo_fieldexists('dy_desk','type')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `type` tinyint(1) NOT NULL DEFAULT '0'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_desk_cate` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家id', `cate` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称', `minimum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最低消费', `imprest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '预付款', `tea_money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '茶水费', `additional` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '小于最低收取', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='餐桌分类'; "); if(!pdo_fieldexists('dy_desk_cate','id')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");} if(!pdo_fieldexists('dy_desk_cate','sid')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家id'");} if(!pdo_fieldexists('dy_desk_cate','cate')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `cate` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称'");} if(!pdo_fieldexists('dy_desk_cate','minimum')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `minimum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最低消费'");} if(!pdo_fieldexists('dy_desk_cate','i