499
499
+ " and prm.templatemessage is not NULL and prm.templatemessage != '' "
500
500
+ " and pg.type='" + ProgramType.WITH_REGISTRATION.name() + "' and prm.daysallowedsendmessage is not null " + " and ( DATE(now()) - DATE( pi."
501
501
+ dateToCompare + " ) ) = prm.daysallowedsendmessage " + " and prm.dateToCompare='" + dateToCompare
505
505
private String sendMessageToUsersSql( String dateToCompare )