/**
     * 上传文件映射表
     */
    @RestController
    @RequestMapping("file")
    @SuppressWarnings({"unchecked","rawtypes"})
    public class FileController{
      @Autowired
        private ConfigService configService;
      /**
      * 上传文件
      */
      @RequestMapping("/upload")
      public R upload(@RequestParam("file") MultipartFile file,String type) throws Exception {
      if (file.isEmpty()) {
        throw new EIException("上传文件不能为空");
      }
      String fileExt = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")+1);
      File path = new File(ResourceUtils.getURL("classpath:static").getPath());
      if(!path.exists()) {
          path = new File("");
      }
      File upload = new File(path.getAbsolutePath(),"/upload/");
      if(!upload.exists()) {
          upload.mkdirs();
      }
      String fileName = new Date().getTime()+"."+fileExt;
      File dest = new File(upload.getAbsolutePath()+"/"+fileName);
      file.transferTo(dest);
      /**
         * 如果使用idea或者eclipse重启项目，发现之前上传的图片或者文件丢失，将下面一行代码注释打开
          * 请将以下的"D:\\springbootq33sd\\src\\main\\resources\\static\\upload"替换成你本地项目的upload路径，
        * 并且项目路径不能存在中文、空格等特殊字符
        */
    //  FileUtils.copyFile(dest, new File("D:\\springbootq33sd\\src\\main\\resources\\static\\upload"+"/"+fileName)); /**修改了路径以后请将该行最前面的//注释去掉**/
      if(StringUtils.isNotBlank(type) && type.equals("1")) {
        ConfigEntity configEntity = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "faceFile"));
        if(configEntity==null) {
        configEntity = new ConfigEntity();
        configEntity.setName("faceFile");
        configEntity.setValue(fileName);
        } else {
        configEntity.setValue(fileName);
        }
        configService.insertOrUpdate(configEntity);
      }
      return R.ok().put("file", fileName);
      }
      /**
      * 下载文件
      */
      @IgnoreAuth
      @RequestMapping("/download")
      public ResponseEntity<byte[]> download(@RequestParam String fileName) {
      try {
        File path = new File(ResourceUtils.getURL("classpath:static").getPath());
        if(!path.exists()) {
           path = new File("");
        }
        File upload = new File(path.getAbsolutePath(),"/upload/");
        if(!upload.exists()) {
           upload.mkdirs();
        }
        File file = new File(upload.getAbsolutePath()+"/"+fileName);
        if(file.exists()){
        /*if(!fileService.canRead(file, SessionManager.getSessionUser())){
          getResponse().sendError(403);
        }*/
        HttpHeaders headers = new HttpHeaders();
           headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);    
           headers.setContentDispositionFormData("attachment", fileName);    
           return new ResponseEntity<byte[]>(FileUtils.readFileToByteArray(file),headers, HttpStatus.CREATED);
        }
      } catch (IOException e) {
        e.printStackTrace();
      }
      return new ResponseEntity<byte[]>(HttpStatus.INTERNAL_SERVER_ERROR);
      }
    }
    RestController
    @RequestMapping("/kechengchengji")
    public class KechengchengjiController {
        @Autowired
        private KechengchengjiService kechengchengjiService;
        /**
         * 后端列表
         */
        @RequestMapping("/page")
        public R page(@RequestParam Map<String, Object> params,KechengchengjiEntity kechengchengji,
      HttpServletRequest request){
      String tableName = request.getSession().getAttribute("tableName").toString();
      if(tableName.equals("jiaoshi")) {
        kechengchengji.setJiaoshizhanghao((String)request.getSession().getAttribute("username"));
      }
      if(tableName.equals("xuesheng")) {
        kechengchengji.setXuehao((String)request.getSession().getAttribute("username"));
      }
            EntityWrapper<KechengchengjiEntity> ew = new EntityWrapper<KechengchengjiEntity>();
      PageUtils page = kechengchengjiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, kechengchengji), params), params));
            return R.ok().put("data", page);
        }
        /**
         * 前端列表
         */
      @IgnoreAuth
        @RequestMapping("/list")
        public R list(@RequestParam Map<String, Object> params,KechengchengjiEntity kechengchengji, 
      HttpServletRequest request){
            EntityWrapper<KechengchengjiEntity> ew = new EntityWrapper<KechengchengjiEntity>();
      PageUtils page = kechengchengjiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, kechengchengji), params), params));
            return R.ok().put("data", page);
        }
      /**
         * 列表
         */
        @RequestMapping("/lists")
        public R list( KechengchengjiEntity kechengchengji){
            EntityWrapper<KechengchengjiEntity> ew = new EntityWrapper<KechengchengjiEntity>();
            ew.allEq(MPUtil.allEQMapPre( kechengchengji, "kechengchengji")); 
            return R.ok().put("data", kechengchengjiService.selectListView(ew));
        }
      /**
         * 查询
         */
        @RequestMapping("/query")
        public R query(KechengchengjiEntity kechengchengji){
            EntityWrapper< KechengchengjiEntity> ew = new EntityWrapper< KechengchengjiEntity>();
        ew.allEq(MPUtil.allEQMapPre( kechengchengji, "kechengchengji")); 
      KechengchengjiView kechengchengjiView =  kechengchengjiService.selectView(ew);
      return R.ok("查询课程成绩成功").put("data", kechengchengjiView);
        }
        /**
         * 后端详情
         */
        @RequestMapping("/info/{id}")
        public R info(@PathVariable("id") Long id){
            KechengchengjiEntity kechengchengji = kechengchengjiService.selectById(id);
            return R.ok().put("data", kechengchengji);
        }
        /**
         * 前端详情
         */
      @IgnoreAuth
        @RequestMapping("/detail/{id}")
        public R detail(@PathVariable("id") Long id){
            KechengchengjiEntity kechengchengji = kechengchengjiService.selectById(id);
            return R.ok().put("data", kechengchengji);
        }
        /**
         * 后端保存
         */
        @RequestMapping("/save")
        public R save(@RequestBody KechengchengjiEntity kechengchengji, HttpServletRequest request){
          kechengchengji.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
          //ValidatorUtils.validateEntity(kechengchengji);
            kechengchengjiService.insert(kechengchengji);
            return R.ok();
        }
        /**
         * 前端保存
         */
        @RequestMapping("/add")
        public R add(@RequestBody KechengchengjiEntity kechengchengji, HttpServletRequest request){
          kechengchengji.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
          //ValidatorUtils.validateEntity(kechengchengji);
            kechengchengjiService.insert(kechengchengji);
            return R.ok();
        }
        /**
         * 修改
         */
        @RequestMapping("/update")
        public R update(@RequestBody KechengchengjiEntity kechengchengji, HttpServletRequest request){
            //ValidatorUtils.validateEntity(kechengchengji);
            kechengchengjiService.updateById(kechengchengji);//全部更新
            return R.ok();
        }
        /**
         * 删除
         */
        @RequestMapping("/delete")
        public R delete(@RequestBody Long[] ids){
            kechengchengjiService.deleteBatchIds(Arrays.asList(ids));
            return R.ok();
        }
        /**
         * 提醒接口
         */
      @RequestMapping("/remind/{columnName}/{type}")
      public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
           @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
      map.put("column", columnName);
      map.put("type", type);
      if(type.equals("2")) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Calendar c = Calendar.getInstance();
        Date remindStartDate = null;
        Date remindEndDate = null;
        if(map.get("remindstart")!=null) {
        Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
        c.setTime(new Date()); 
        c.add(Calendar.DAY_OF_MONTH,remindStart);
        remindStartDate = c.getTime();
        map.put("remindstart", sdf.format(remindStartDate));
        }
        if(map.get("remindend")!=null) {
        Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
        c.setTime(new Date());
        c.add(Calendar.DAY_OF_MONTH,remindEnd);
        remindEndDate = c.getTime();
        map.put("remindend", sdf.format(remindEndDate));
        }
      }
      Wrapper<KechengchengjiEntity> wrapper = new EntityWrapper<KechengchengjiEntity>();
      if(map.get("remindstart")!=null) {
        wrapper.ge(columnName, map.get("remindstart"));
      }
      if(map.get("remindend")!=null) {
        wrapper.le(columnName, map.get("remindend"));
      }
      String tableName = request.getSession().getAttribute("tableName").toString();
      if(tableName.equals("jiaoshi")) {
        wrapper.eq("jiaoshizhanghao", (String)request.getSession().getAttribute("username"));
      }
      if(tableName.equals("xuesheng")) {
        wrapper.eq("xuehao", (String)request.getSession().getAttribute("username"));
      }
      int count = kechengchengjiService.selectCount(wrapper);
      return R.ok().put("count", count);
      }
    }