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;
			}
		}
	}
}