You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
130 lines
6.1 KiB
130 lines
6.1 KiB
6 months ago
|
/*****************************************************
|
||
|
|
* @projectName alarms
|
||
|
|
* @brief 摘要
|
||
|
|
* @author Deng Zhimao
|
||
|
|
* @email 1252699831@qq.com
|
||
|
|
* @date 2020-07-08
|
||
|
|
*****************************************************/
|
||
|
|
|
||
|
|
import QtQuick 2.11
|
||
|
|
import QtQuick.LocalStorage 2.0
|
||
|
|
// Populate the model with some sample data.
|
||
|
|
ListModel {
|
||
|
|
id: alarmModel
|
||
|
|
ListElement {
|
||
|
|
hour: 6
|
||
|
|
minute: 0
|
||
|
|
day: 2
|
||
|
|
month: 8
|
||
|
|
year: 2018
|
||
|
|
activated: true
|
||
|
|
label: "起床"
|
||
|
|
repeat: true
|
||
|
|
daysToRepeat: [
|
||
|
|
ListElement { dayOfWeek: 0; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 1; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 2; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 3; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 4; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 5; repeat: false },
|
||
|
|
ListElement { dayOfWeek: 6; repeat: false }
|
||
|
|
]
|
||
|
|
}
|
||
|
|
Component.onCompleted: loadData()
|
||
|
|
Component.onDestruction: {
|
||
|
|
saveData()
|
||
|
|
if (rebootFlag)
|
||
|
|
myDesktop.systemReboot()
|
||
|
|
if (poweroffFlag)
|
||
|
|
myDesktop.systemPoweroff()
|
||
|
|
}
|
||
|
|
function loadData() {
|
||
|
|
var db = LocalStorage.openDatabaseSync("MyDB", "1.0", "My model SQL", 50000);
|
||
|
|
db.transaction(
|
||
|
|
function(tx) {
|
||
|
|
// Create the database if it doesn't already exist
|
||
|
|
tx.executeSql('CREATE TABLE IF NOT EXISTS alarmData(hour INTEGER, minute INTEGER,
|
||
|
|
activated TINYINT, label TEXT, repeat TINYINT, myValue INTEGER)');
|
||
|
|
|
||
|
|
var rs = tx.executeSql('SELECT * FROM alarmData');
|
||
|
|
var index = 0
|
||
|
|
if (rs.rows.length > 0) {
|
||
|
|
alarmModel.remove(0)
|
||
|
|
index = 0
|
||
|
|
while (index < rs.rows.length) {
|
||
|
|
var myItem = rs.rows.item(index);
|
||
|
|
//console.log(myItem.myValue)
|
||
|
|
alarmModel.append( {
|
||
|
|
"hour": myItem.hour,
|
||
|
|
"minute": myItem.minute,
|
||
|
|
"activated": myItem.activated ? true : false,
|
||
|
|
"label": myItem.label,
|
||
|
|
"repeat": myItem.repeat ? true : false,
|
||
|
|
"daysToRepeat": getMyvalue(myItem.myValue)
|
||
|
|
})
|
||
|
|
index++
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
alarmModel.remove(0)
|
||
|
|
alarmModel.append({
|
||
|
|
"hour": 6,
|
||
|
|
"minute": 0,
|
||
|
|
"activated": true,
|
||
|
|
"label": "",
|
||
|
|
"repeat": false,
|
||
|
|
"daysToRepeat": [
|
||
|
|
{ "dayOfWeek": 0, "repeat": false },
|
||
|
|
{ "dayOfWeek": 1, "repeat": false },
|
||
|
|
{ "dayOfWeek": 2, "repeat": false },
|
||
|
|
{ "dayOfWeek": 3, "repeat": false },
|
||
|
|
{ "dayOfWeek": 4, "repeat": false },
|
||
|
|
{ "dayOfWeek": 5, "repeat": false },
|
||
|
|
{ "dayOfWeek": 6, "repeat": false }
|
||
|
|
],
|
||
|
|
})
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|
||
|
|
)
|
||
|
|
}
|
||
|
|
function saveData() {
|
||
|
|
var db = LocalStorage.openDatabaseSync("MyDB", "1.0", "My model SQL", 50000);
|
||
|
|
db.transaction(
|
||
|
|
function(tx) {
|
||
|
|
tx.executeSql('DROP TABLE alarmData');
|
||
|
|
tx.executeSql('CREATE TABLE IF NOT EXISTS alarmData(hour INTEGER, minute INTEGER,
|
||
|
|
activated TINYINT, label TEXT, repeat TINYINT, myValue INTEGER)');
|
||
|
|
var index = 0
|
||
|
|
while (index < alarmModel.count) {
|
||
|
|
var myItem = alarmModel.get(index);
|
||
|
|
var daysItem = myItem.daysToRepeat
|
||
|
|
var myValue = 0
|
||
|
|
for(var i = 0; i < myItem.daysToRepeat.count; i++){
|
||
|
|
myValue += daysItem.get(i).repeat << i
|
||
|
|
}
|
||
|
|
//console.log(myValue)
|
||
|
|
tx.executeSql('INSERT INTO alarmData VALUES(?,?,?,?,?,?)', [myItem.hour, myItem.minute,
|
||
|
|
myItem.activated, myItem.label,
|
||
|
|
myItem.repeat, myValue]);
|
||
|
|
index++;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
)
|
||
|
|
}
|
||
|
|
|
||
|
|
function getMyvalue(mvalue) {
|
||
|
|
var data = [
|
||
|
|
{ "dayOfWeek": 0, "repeat": mvalue & 1 ? true : false },
|
||
|
|
{ "dayOfWeek": 1, "repeat": mvalue & 2 ? true : false },
|
||
|
|
{ "dayOfWeek": 2, "repeat": mvalue & 4 ? true : false },
|
||
|
|
{ "dayOfWeek": 3, "repeat": mvalue & 8 ? true : false },
|
||
|
|
{ "dayOfWeek": 4, "repeat": mvalue & 16 ? true : false },
|
||
|
|
{ "dayOfWeek": 5, "repeat": mvalue & 32 ? true : false },
|
||
|
|
{ "dayOfWeek": 6, "repeat": mvalue & 64 ? true : false }
|
||
|
|
]
|
||
|
|
return data
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|