global with sharing class RequalificationEmailBatch implements Database.Batchable<sObject>{
    String query;

    global RequalificationEmailBatch() {
        Date dateField = System.today() + 1 ;
        String dateFieldString = String.valueOf(dateField).substring(0, 10);
        query = 'SELECT id, name, PersonContactIdAuto__c, Requal_Email_Response_received__c, email__c, RecordTypeName__c, ' +
                'Requal_Email_Sent_On__c, Skip_Validation_New__c, bookingDate__c, MovingoutDate__c ' +
                'FROM Opportunity WHERE (stageName = \'Closed Won\' OR stageName = \'Payment Pending\') ' +
                ' and MovingOutDate__c > ' + dateFieldString;//

        // additional condition when code executing in sandbox to avoid emails sent to real customers/emails
        //if(RequalificationEmailHelper.runningInASandbox())
        //    query += ' AND email__c = \'sf-test@movinga.de\'';

        system.debug('>>>>>>>>>>>>>  ' + query);

    }

    global Database.QueryLocator start(Database.BatchableContext BC) {
        return Database.getQueryLocator(query);
    }

    global void execute(Database.BatchableContext BC, List<sObject> scope) {
        RequalificationEmailHelper.sendEmailsAndGenerateCases(scope);
    }

    global void finish(Database.BatchableContext BC) {

    }
}