OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 156 | Rev 182 | Go to most recent revision | 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 
    }