1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
| import {
| initData
| } from "../common/sql";
| import {
| executeSql,
| query
| } from "../common/sqlite"
|
| export default {
| async getOrderSeq() {
| const seqs = await query('select * from seq where id = 1');
| if (seqs.length === 0) {
| await executeSql(initData.initSeq);
| return 1;
| } else {
| const date = new Date();
| const currentDate = `${date.getFullYear()}-${(date.getMonth() + 1)
| .toString()
| .padStart(2, "0")}-${date
| .getDate()
| .toString()
| .padStart(2, "0")}`
| if (seqs[0].date === currentDate) {
| const result = seqs[0].seq + 1;
| const sql = 'UPDATE seq set seq = ' + result + `, date = '${currentDate}' where id = 1`;
| await executeSql(sql);
| return seqs[0].seq;
| } else {
| const sql = `UPDATE seq set seq = 2, date = '${currentDate}' where id = 1`;
| await executeSql(sql);
| return 1;
| }
| }
| }
| }
|
|
