柠檬记账

柠檬记账"/>

柠檬记账

1. 先创建数据库，数据表(数据集合)
   

• user 用户表
  
• bill 账单表
  
• classify 类别表
  
• icon 图标
  

2. 建立远程仓库连接
3. 建文件目录
   
4. 写接口

• 用户登录

router.post('/api/logon', (req, res, next) => {var name = req.body.name;var pwd = req.body.pwd;mongo.find(db, user, { "name": name, "pwd": pwd }, (result) => {if (!result) {res.json({code: 0,mes: "没有找到！"})} else {if (result.length > 0) {let obj = {id: result[0]._id,name: result[0].name}res.json({code: 1,mes: "找到了！",data: obj})} else {res.json({code: 3,mes: "用户不存在，用户名或者密码不匹配！"})}}})
});

• 根据用户查找账单

router.post("/api/getBill", (req, res, next) => {let id = req.body.id;let time = new RegExp(req.body.time);  //数据库模糊搜索mongo.find(db, bill, {"uid": id,"time":time}, (result) => {if (!result) {res.json({code: 0,mes: "error"})} else {res.json({code: 1,mes: "ok",data: result})}})
})

• 删除单条账单

router.post("/api/deltBill", (req, res, next) => {let id = req.body.idmongo.remove(db, bill, { "_id": id }, (result) => {if (!result) {res.json({code: 0,mes: "error"})} else {res.json({code: 1,mes: "ok",data: result})}})
})

5. 前端时间 —— mui 时间 年月日时分
   

• mui 时间，需要手动引入 js 和 css 文件 ，需要初始化
  • 在 mui 文档找日期选择(移动端)
    
  • 找 css ，js ,右键 Save as 保存到本地文件夹
    
  • 手动引入,require 配置路径

<link rel="stylesheet" href="../css/mui.picker.min.css">
require.config({paths: {"mui": "./libs/mui.min","picker": "./libs/mui.picker.min"},shim: {"picker": {deps: ["mui"]}}
})
let dtPicker = new mui.DtPicker();
dtPicker.show((selectItems) => {console.log(selectItems.y)console.log(selectItems.m)
})

7. mui 时间月份
   

• 引入方法同上，需要修改初始值 type 为 month , 手动设置文本

let picker = new mui.DtPicker({"type": "month"
});
let popPicker = new mui.PopPicker();
popPicker.setData([{value: "year",text: "年"},{value: "month",text: "月"}
])
let tYear = document.querySelector("[data-id='title-y']") //<h5 data-id="title-y">年</h5>
let tMonth = document.querySelector("[data-id='title-m']")
let dYear = document.querySelector("[data-id=picker-y]");
let dMonth = document.querySelector("[data-id=picker-m]");