insertDailyLog method
insert daily logs report based on userId and log date
Implementation
Future<int> insertDailyLog(
Map<String, dynamic> data, String logDate, String customerId) async {
Database? db = await instance.database;
/// Check if found logs on provided date
int? recordExist = Sqflite.firstIntValue(await db!.rawQuery(
"SELECT COUNT(*) FROM $tableDailyUserSymptomsLogsData WHERE $columnLogDate='$logDate' AND $columnCustomerId='$customerId'"));
//printLogs("Found Data : $recordExist");
if (recordExist! > 0) {
/// remove old logs
await db.rawDelete(
"DELETE FROM $tableDailyUserSymptomsLogsData WHERE $columnLogDate='$logDate' AND $columnCustomerId='$customerId'");
//printLogs("Delete Data $deleted");
}
///insert a new logs
int id = await db.insert(tableDailyUserSymptomsLogsData, data);
//printLogs("Insert Data");
return id;
}