public Cursor getDatePaieeForYYYY2(String Date) {
 
Cursor c = mDb.rawQuery("SELECT SUM(ttc) FROM "+TABLE_NAME+" WHERE  date_paiement = '"+Date+"'", null);
        if (c != null) {
            c.moveToFirst();
        }
        return c;
 
}

cm.open() ;
cursorC = cm.getDatePaieeForYYYY2(annee.getText().toString());
                if (cursorC.moveToFirst()){
                    do {
                        RESULTAT = cursorC.getString(Integer.parseInt(String.valueOf(cursorC.getColumnIndex(compta_manager.KEY_LOYER_TTC))));
                    }while (cursorC.moveToNext());
                }
cm.close() ;
 
Log.i("RESULTAT()"," "+RESULTAT);

 
import 'package:firebase_auth/firebase_auth.dart';
import 'package:flutter/material.dart';
import 'package:google_sign_in/google_sign_in.dart';
 
/// A screen that provides a button to trigger Google Sign-In and handles the
/// entire authentication flow with Firebase.
class SignInDemo extends StatefulWidget {
  const SignInDemo({super.key});
 
  @override
  State<SignInDemo> createState() => _SignInDemoState();
}
 
class _SignInDemoState extends State<SignInDemo> {
  // A single, reusable instance of the GoogleSignIn client.
  final GoogleSignIn _googleSignIn = GoogleSignIn();
 
  // State to manage the loading indicator on the button.
  bool _isSigningIn = false;
 
  /// Performs the entire Google Sign-In flow and authenticates with Firebase.
  Future<void> _signInWithGoogle() async {
    // Prevent multiple sign-in attempts.
    if (_isSigningIn) return;
 
    setState(() {
      _isSigningIn = true;
    });
 
    try {
      // 1. Initiate the Google Sign-In flow.
      final GoogleSignInAccount? googleUser = await _googleSignIn.signIn();
 
      // If the user canceled the process, stop here.
      if (googleUser == null) {
        if (mounted) {
          ScaffoldMessenger.of(context).showSnackBar(
            const SnackBar(content: Text('Sign-in canceled by user.')),
          );
        }
        return; // Early exit
      }
 
      // 2. Obtain the authentication details from the Google user account.
      final GoogleSignInAuthentication googleAuth = await googleUser.authentication;
 
      // 3. Create a new Firebase credential using the Google tokens.
      final AuthCredential credential = GoogleAuthProvider.credential(
        accessToken: googleAuth.accessToken,
        idToken: googleAuth.idToken,
      );
 
      // 4. Sign in to Firebase with the new credential.
      // This action will be picked up by the StreamBuilder in AuthWrapper,
      // which will then navigate to the main application screen.
      await FirebaseAuth.instance.signInWithCredential(credential);
 
    } catch (e) {
      // Handle any errors that occur during the process.
      print('Error during Google sign-in: $e');
      if (mounted) {
        ScaffoldMessenger.of(context).showSnackBar(
          SnackBar(content: Text('Error: ${e.toString()}')),
        );
      }
    } finally {
      // Ensure the loading state is always reset, even if an error occurs.
      if (mounted) {
        setState(() {
          _isSigningIn = false;
        });
      }
    }
  }
 
  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: const Text('Sign In'),
        elevation: 2,
      ),
      body: Center(
        child: Padding(
          padding: const EdgeInsets.all(24.0),
          child: Column(
            mainAxisAlignment: MainAxisAlignment.center,
            children: <Widget>[
              const Text(
                'Welcome to Mesh Masks',
                style: TextStyle(fontSize: 24, fontWeight: FontWeight.bold),
              ),
              const SizedBox(height: 16),
              const Text(
                'Please sign in with your Google account to continue.',
                textAlign: TextAlign.center,
              ),
              const SizedBox(height: 48),
              _isSigningIn
                  ? const CircularProgressIndicator()
                  : ElevatedButton.icon(
                      icon: const Icon(Icons.login), // Example icon
                      onPressed: _signInWithGoogle,
                      label: const Text('Sign In with Google'),
                      style: ElevatedButton.styleFrom(
                        minimumSize: const Size(double.infinity, 50), // Make button wider
                      ),
                    ),
            ],
          ),
        ),
      ),
    );
  }
}