基于微信小程序的高校餐厅食品留样管理系统-计算机毕业设计源码

小程序开发说明

开发语言：Java

框架：ssm

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

小程序框架：uniapp

小程序开发软件：HBuilder X

小程序运行软件：微信开发者

数据库脚本：

DROP TABLE IF EXISTS `bingju`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `bingju` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`bingjubianhao` varchar(200) DEFAULT NULL COMMENT '冰柜编号',

`bingjupinpai` varchar(200) DEFAULT NULL COMMENT '冰柜品牌',

`bingjuguige` varchar(200) DEFAULT NULL COMMENT '冰柜规格',

`bingjurongliang` varchar(200) DEFAULT NULL COMMENT '冰柜容量',

`bingjuweizhi` varchar(200) DEFAULT NULL COMMENT '冰柜位置',

`bingjubiaoqian` varchar(200) DEFAULT NULL COMMENT '冰柜标签',

PRIMARY KEY (`id`),

UNIQUE KEY `bingjubianhao` (`bingjubianhao`)

) ENGINE=InnoDB AUTO_INCREMENT=1650985154674 DEFAULT CHARSET=utf8 COMMENT='冰柜';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `bingju`

--

LOCK TABLES `bingju` WRITE;

/*!40000 ALTER TABLE `bingju` DISABLE KEYS */;

INSERT INTO `bingju` VALUES (31,'2022-04-26 14:53:09','冰柜编号1','冰柜品牌1','冰柜规格1','冰柜容量1','冰柜位置1','冰柜标签1'),(32,'2022-04-26 14:53:09','冰柜编号2','冰柜品牌2','冰柜规格2','冰柜容量2','冰柜位置2','冰柜标签2'),(33,'2022-04-26 14:53:09','冰柜编号3','冰柜品牌3','冰柜规格3','冰柜容量3','冰柜位置3','冰柜标签3'),(34,'2022-04-26 14:53:09','冰柜编号4','冰柜品牌4','冰柜规格4','冰柜容量4','冰柜位置4','冰柜标签4'),(35,'2022-04-26 14:53:09','冰柜编号5','冰柜品牌5','冰柜规格5','冰柜容量5','冰柜位置5','冰柜标签5'),(36,'2022-04-26 14:53:09','冰柜编号6','冰柜品牌6','冰柜规格6','冰柜容量6','冰柜位置6','冰柜标签6'),(1650985154673,'2022-04-26 14:59:14','001','美的','100*160','60L','东食堂','基于微信小程序的高校餐厅食品留样管理系统');

/*!40000 ALTER TABLE `bingju` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `chuangkoufuzeren`

--

DROP TABLE IF EXISTS `chuangkoufuzeren`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chuangkoufuzeren` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',

`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',

`mima` varchar(200) DEFAULT NULL COMMENT '密码',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',

`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',

`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',

`shhf` longtext COMMENT '审核回复',

PRIMARY KEY (`id`),

UNIQUE KEY `chuangkoubianhao` (`chuangkoubianhao`)

) ENGINE=InnoDB AUTO_INCREMENT=1650985355380 DEFAULT CHARSET=utf8 COMMENT='窗口负责人';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `chuangkoufuzeren`

--

LOCK TABLES `chuangkoufuzeren` WRITE;

/*!40000 ALTER TABLE `chuangkoufuzeren` DISABLE KEYS */;

INSERT INTO `chuangkoufuzeren` VALUES (11,'2022-04-26 14:53:09','窗口编号1','负责人1','123456','男','13823888881','upload/chuangkoufuzeren_touxiang1.jpg','否','要审核通过才能登录'),(12,'2022-04-26 14:53:09','窗口编号2','负责人2','123456','男','13823888882','upload/chuangkoufuzeren_touxiang2.jpg','是',''),(13,'2022-04-26 14:53:09','窗口编号3','负责人3','123456','男','13823888883','upload/chuangkoufuzeren_touxiang3.jpg','是',''),(14,'2022-04-26 14:53:09','窗口编号4','负责人4','123456','男','13823888884','upload/chuangkoufuzeren_touxiang4.jpg','是',''),(15,'2022-04-26 14:53:09','窗口编号5','负责人5','123456','男','13823888885','upload/chuangkoufuzeren_touxiang5.jpg','是',''),(16,'2022-04-26 14:53:09','窗口编号6','负责人6','123456','男','13823888886','upload/chuangkoufuzeren_touxiang6.jpg','是',''),(1650985355379,'2022-04-26 15:02:35','111','胡月','111','女','13612514514','upload/1650985478777.jpg','是','11');

/*!40000 ALTER TABLE `chuangkoufuzeren` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `chuangkouyuangong`

--

DROP TABLE IF EXISTS `chuangkouyuangong`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chuangkouyuangong` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',

`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',

`mima` varchar(200) DEFAULT NULL COMMENT '密码',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',

`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',

`chuangkoubianhao` varchar(200) DEFAULT NULL COMMENT '窗口编号',

PRIMARY KEY (`id`),

UNIQUE KEY `yuangonggonghao` (`yuangonggonghao`)

) ENGINE=InnoDB AUTO_INCREMENT=1650985500526 DEFAULT CHARSET=utf8 COMMENT='窗口员工';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `chuangkouyuangong`

--

LOCK TABLES `chuangkouyuangong` WRITE;

/*!40000 ALTER TABLE `chuangkouyuangong` DISABLE KEYS */;

INSERT INTO `chuangkouyuangong` VALUES (21,'2022-04-26 14:53:09','员工工号1','员工姓名1','123456','男','13823888881','upload/chuangkouyuangong_touxiang1.jpg','窗口编号1'),(22,'2022-04-26 14:53:09','员工工号2','员工姓名2','123456','男','13823888882','upload/chuangkouyuangong_touxiang2.jpg','窗口编号2'),(23,'2022-04-26 14:53:09','员工工号3','员工姓名3','123456','男','13823888883','upload/chuangkouyuangong_touxiang3.jpg','窗口编号3'),(24,'2022-04-26 14:53:09','员工工号4','员工姓名4','123456','男','13823888884','upload/chuangkouyuangong_touxiang4.jpg','窗口编号4'),(25,'2022-04-26 14:53:09','员工工号5','员工姓名5','123456','男','13823888885','upload/chuangkouyuangong_touxiang5.jpg','窗口编号5'),(26,'2022-04-26 14:53:09','员工工号6','员工姓名6','123456','男','13823888886','upload/chuangkouyuangong_touxiang6.jpg','窗口编号6'),(1650985500525,'2022-04-26 15:05:00','222','李继军','222','男','13612512514','upload/1650985499959.jpg','111');

/*!40000 ALTER TABLE `chuangkouyuangong` ENABLE KEYS */;

业务逻辑代码：

/**

* 冰柜

* 后端接口

* @author

* @email

* @date 2022-04-26 22:52:55

*/

@RestController

@RequestMapping("/bingju")

public class BingjuController {

@Autowired

private BingjuService bingjuService;

/**

* 后端列表

*/

@RequestMapping("/page")

public R page(@RequestParam Map<String, Object> params,BingjuEntity bingju,

HttpServletRequest request){

EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();

PageUtils page = bingjuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, bingju), params), params));

return R.ok().put("data", page);

}

/**

* 前端列表

*/

@RequestMapping("/list")

public R list(@RequestParam Map<String, Object> params,BingjuEntity bingju,

HttpServletRequest request){

EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();

PageUtils page = bingjuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, bingju), params), params));

return R.ok().put("data", page);

}

/**

* 列表

*/

@RequestMapping("/lists")

public R list( BingjuEntity bingju){

EntityWrapper<BingjuEntity> ew = new EntityWrapper<BingjuEntity>();

ew.allEq(MPUtil.allEQMapPre( bingju, "bingju"));

return R.ok().put("data", bingjuService.selectListView(ew));

}

/**

* 查询

*/

@RequestMapping("/query")

public R query(BingjuEntity bingju){

EntityWrapper< BingjuEntity> ew = new EntityWrapper< BingjuEntity>();

ew.allEq(MPUtil.allEQMapPre( bingju, "bingju"));

BingjuView bingjuView = bingjuService.selectView(ew);

return R.ok("查询冰柜成功").put("data", bingjuView);

}

/**

* 后端详情

*/

@RequestMapping("/info/{id}")

public R info(@PathVariable("id") Long id){

BingjuEntity bingju = bingjuService.selectById(id);

return R.ok().put("data", bingju);

}

/**

* 前端详情

*/

@RequestMapping("/detail/{id}")

public R detail(@PathVariable("id") Long id){

BingjuEntity bingju = bingjuService.selectById(id);

return R.ok().put("data", bingju);

}