# record2solve

**Repository Path**: vansl/record2solve

## Basic Information

- **Project Name**: record2solve
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-21
- **Last Updated**: 2022-04-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# record2solve

> 金华市中医院信息科日常工作问题记录工具

#### bug解决

- element table不显示：`let whiteListedModules = ['vue']`添加element-ui组件修改为`let whiteListedModules = ['vue', 'element-ui']`

#### todo

- [x] <del>集成sqlite</del>集成lowdb
- [x] <del>绑定快捷键保存截图到某个文件夹</del>
- [x] 查看其他日期记录
- [ ] 可配置数据库文件路径、radmin路径
- [ ] 统一修改和输入时字段验证规则
- [x] 可清空输入框
- [x] 统计：按小时、按日期、按电话号码，日均工作量，平均问题处理时长
- [ ] 输入电话时自动输入部门
- [x] 绑定enter键确认输入
- [ ] 备份数据文件
- [ ] 根据文字搜索记录

#### 其他

- 工作量统计：
  - 按小时统计：
    - sqlite:`SELECT strftime('%H',r.createTime/1000, 'unixepoch','localtime') AS create_hour,count(*) AS amt FROM record2solve_db r GROUP BY create_hour`
    - lowdb:`this.$db.get('record').countBy(n => {return new Date(n.createTime).toTimeString().substring(0, 2)}).toPairs().sortBy(n => {return n[0]}).value()`
  - 按日期统计：
    - sqlite:`SELECT strftime('%Y-%m-%d',r.createTime/1000, 'unixepoch','localtime') AS create_date,COUNT(*) AS amt FROM record2solve_db r GROUP BY create_date`
    - lowdb:`this.$db.get('record').countBy(n => {return new Date(n.createTime).toLocaleDateString()}).toPairs().sortBy(n => {return n[0]}).value()`
  - 按电话号码统计：
    - sqlite:`SELECT r.phone,COUNT(*) AS amt FROM record2solve_db r GROUP BY r.phone ORDER BY amt DESC`
    - lowdb:`this.$db.get('record').countBy('phone').toPairs().sortBy(n => {return n[1]}).value()`
  - 日均工作量：
    - sqlite:`SELECT (CAST (COUNT(*) AS float)) / COUNT (DISTINCT strftime('%Y-%m-%d',r.createTime/1000, 'unixepoch','localtime'))  FROM record2solve_db r`
    - lowdb:`this.$db.get('record').size().value() / this.$db.get('record').countBy(n => {return new Date(n.createTime).toLocaleDateString()}).size().value()`