OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Rev

Rev 156 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 156 Rev 174
Line 28... Line 28...
28
public class TicketCaisseSQLElement extends ComptaSQLConfElement {
28
public class TicketCaisseSQLElement extends ComptaSQLConfElement {
29
 
29
 
30
    static public final String UNARCHIVED_WHERE = SQLBase.quoteIdentifier("ARCHIVE") + " = " + 0;
30
    static public final String UNARCHIVED_WHERE = SQLBase.quoteIdentifier("ARCHIVE") + " = " + 0;
31
    static public final String DATE_WHERE = UNARCHIVED_WHERE + " and " + SQLBase.quoteIdentifier("FILE_HASH") + " is not null";
31
    static public final String DATE_WHERE = UNARCHIVED_WHERE + " and " + SQLBase.quoteIdentifier("FILE_HASH") + " is not null";
32
 
32
 
-
 
33
    // needed until H2 databases are upgraded to use JS code
33
    static public final class UniqueNumber_PartialUniqueTrigger extends PartialUniqueTrigger {
34
    static public final class UniqueNumber_PartialUniqueTrigger extends PartialUniqueTrigger {
34
        public UniqueNumber_PartialUniqueTrigger() {
35
        public UniqueNumber_PartialUniqueTrigger() {
35
            super(Arrays.asList("NUMERO"), UNARCHIVED_WHERE);
36
            super(Arrays.asList("NUMERO"), UNARCHIVED_WHERE);
36
        }
37
        }
37
    }
38
    }
38
 
39
 
-
 
40
    // needed until H2 databases are upgraded to use JS code
39
    static public final class UniqueDate_PartialUniqueTrigger extends PartialUniqueTrigger {
41
    static public final class UniqueDate_PartialUniqueTrigger extends PartialUniqueTrigger {
40
        public UniqueDate_PartialUniqueTrigger() {
42
        public UniqueDate_PartialUniqueTrigger() {
41
            super(Arrays.asList("ID_CAISSE", "DATE"), DATE_WHERE);
43
            super(Arrays.asList("ID_CAISSE", "DATE"), DATE_WHERE);
42
        }
44
        }
43
    }
45
    }