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

小程序开发说明

开发语言：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);
    }