2021年4月29日 团队冲刺阶段03

时间:1.6个小时左右

代码:170行左右

博客:1

学习内容:完善了电影票后台的增删改查

//添加用户信息
router.post('/api/admin/addUserInfo',function(req,res){
    let {
        userName,
        avatar,
        phone,
        password,
        sex,
        sign,
        birthday
    } = req.body;
        if (!avatar){
            avatar = '/images/avatar/monkey.png'
        }
        let sqlStr = 'SELECT * FROM t_user WHERE user_name = ? LIMIT 1;';
        conn.query(sqlStr,[userName],(error,result,field)=>{
          if (error){
            console.log(error);
          } else{
            result = JSON.parse(JSON.stringify(result));
            if (result[0]){
              res.json({error_code:1,message:'用户名已存在！'});
            } else{
              sqlStr = 'SELECT * FROM t_user WHERE phone = ? LIMIT 1';
              conn.query(sqlStr,[phone],(error,result,field)=>{
                if (error){
                  console.log(error);
                } else{
                  result = JSON.parse(JSON.stringify(result));
                  if (result[0]){
                    res.json({error_code:1,message:'手机号码已注册！'});
                  } else{
                    sqlStr = 'INSERT INTO t_user(user_name,avatar,phone,password,sex,sign,birthday) VALUES(?,?,?,?,?,?,?);';
                    conn.query(sqlStr,[userName, avatar,phone, password, sex, sign, birthday],(error,result,field)=>{
                      if (error){
                        console.log(error);
                      } else{
                        res.json({success_code:200});
                      }
                    })
                  }
                }
              });
            }
          }
        });
});
//获取当前页电影
router.get('/api/admin/getCurrentPageMovie',function(req,res){
    let {
        currentPage, pageSize,input
    } = req.query;
    let start = Number((currentPage-1)*pageSize);
    pageSize = Number(pageSize);
    let sqlStr = 'SELECT * FROM t_movie WHERE name LIKE ? ORDER BY movie_id';
    let total;
    conn.query(sqlStr,["%"+input+"%"],(error,result,field)=>{
        if (error){
            console.log(error);
        } else{
            result = JSON.parse(JSON.stringify(result));
            total = result.length;
        }
    });
    sqlStr = 'SELECT * FROM t_movie WHERE name LIKE ? ORDER BY movie_id LIMIT ?,?;';
    conn.query(sqlStr,["%"+input+"%",start,pageSize],(error,result,field)=>{
        if (error){
            console.log(error);
        } else{
            result = JSON.parse(JSON.stringify(result));
            res.json({success_code:200,data:result,total:total});
        }
    })
});
//更新电影信息
router.post('/api/admin/updateMovieInfo',function(req,res){
    let {
        movieId,
        movieName,
        poster,
        director,
        actor,
        long,
        type,
        language,
        publicDate,
        intro
    } = req.body;
    let sqlStr = 'SELECT * FROM t_movie WHERE name = ? AND movie_id <> ? LIMIT 1;';
    conn.query(sqlStr,[movieName,movieId],(error,result,field)=>{
      if (error){
        console.log(error);
      } else{
        result = JSON.parse(JSON.stringify(result));
        if (result[0]){
          res.json({error_code:1,message:'电影名已存在！'});
        } else{
          //更新数据库
          let sqlStr = 'UPDATE t_movie SET name = ?,poster = ?,director = ?,actor = ? ,movie_long = ?,type = ?,language = ?,public_date = ?,intro = ? WHERE movie_id = ?;';
          conn.query(sqlStr,[movieName,poster,director,actor,long,type,language,publicDate,intro,movieId],(error,result,field)=>{
            if (error){
              console.log(error);
            } else{
              res.json({success_code:200})
            }
          })
        }
      }
    });
});
//添加电影信息
router.post('/api/admin/addMovieInfo',function(req,res){
    let {
        movieName,
        poster,
        director,
        actor,
        long,
        type,
        language,
        publicDate,
        intro
    } = req.body;
    let sqlStr = 'SELECT * FROM t_movie WHERE name = ? LIMIT 1;';
    conn.query(sqlStr,[movieName],(error,result,field)=>{
      if (error){
        console.log(error);
      } else{
        result = JSON.parse(JSON.stringify(result));
        if (result[0]){
          res.json({error_code:1,message:'电影名已存在！'});
        } else{
          let sqlStr = 'INSERT INTO t_movie(name,poster,director,actor,movie_long,type,language,public_date,intro) VALUES(?,?,?,?,?,?,?,?,?);';
          conn.query(sqlStr,[movieName,poster,director,actor,long,type,language,publicDate,intro],(error,result,field)=>{
            if (error){
              console.log(error);
            } else{
              res.json({success_code:200});
            }
          })
        }
      }
    });
});

 datatime = './public/images/movie/';
//将图片放到服务器
 storage = multer.diskStorage({
    // 如果你提供的 destination 是一个函数，你需要负责创建文件夹
    destination: datatime,
    // //给上传文件重命名，获取添加后缀名
    filename: function (req, file, cb) {
        cb(null, new Date().getTime()+'.jpg');
    }
});
 upload = multer({
    storage: storage
});
router.post('/api/admin/upLoadMovieImg',upload.any(),function (req,res) {
    res.json({success_code:200,data:req.files});
    console.log(req.files);
});
//删除电影信息
router.post('/api/admin/deleteMovieInfo',function(req,res){
    let {
        movieId
    } = req.body;
    let sqlStr = 'DELETE FROM t_movie WHERE movie_id =?';
    conn.query(sqlStr,[movieId],(error,result,field)=>{
        if (error){
            console.log(error);
        } else {
            res.json({success_code:200});
        }
    })
});