getSymptomsLogReport function
get symptoms report BETWEEN start & end date based on userId
Implementation
Future<List<UserSymptomsLogData>> getSymptomsLogReport(
{required String? userId,
required String? startDate,
required String? endDate}) async {
List<UserSymptomsLogData> usersLogDataList = [];
final dbHelper = MenstrualCycleDbHelper.instance;
Database? db = await dbHelper.database;
final List<Map<String, dynamic>> queryResponse = await db!.rawQuery(
"Select * from ${MenstrualCycleDbHelper.tableDailyUserSymptomsLogsData} WHERE ${MenstrualCycleDbHelper.columnCustomerId}='$userId' AND ${MenstrualCycleDbHelper.columnLogDate} BETWEEN '$startDate' AND '$endDate'");
List.generate(queryResponse.length, (i) {
UserSymptomsLogData userLogsData = UserSymptomsLogData();
userLogsData.id = queryResponse[i][MenstrualCycleDbHelper.columnID];
userLogsData.customerId =
queryResponse[i][MenstrualCycleDbHelper.columnCustomerId];
userLogsData.symptomData = Encryption.instance.decrypt(
queryResponse[i][MenstrualCycleDbHelper.columnUserEncryptData]);
userLogsData.logDate =
queryResponse[i][MenstrualCycleDbHelper.columnLogDate];
userLogsData.createdAt =
queryResponse[i][MenstrualCycleDbHelper.columnCreatedDateTime];
usersLogDataList.add(userLogsData);
});
return usersLogDataList;
}