Subversion Repositories SmartDukaan

Rev

Rev 34716 | Rev 34764 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34716 Rev 34763
Line 101... Line 101...
101 
        String startDateString = startDate.toString();
 101 
        String startDateString = startDate.toString();
102 
 
 102 
 
103 
        final NativeQuery<?> nativeQuery = session.createNativeQuery(
 103 
        final NativeQuery<?> nativeQuery = session.createNativeQuery(
104 
                "SELECT (DATEDIFF(LAST_DAY(:startDate), :startDate) + 1) " +
 104 
                "SELECT (DATEDIFF(LAST_DAY(:startDate), :startDate) + 1) " +
105 
                        " - (FLOOR((DATEDIFF(LAST_DAY(:startDate), :startDate) + (WEEKDAY(:startDate) + 1)) / 7)) " +
 105 
                        " - (FLOOR((DATEDIFF(LAST_DAY(:startDate), :startDate) + (WEEKDAY(:startDate) + 1)) / 7)) " +
106 
                        " - (CASE WHEN WEEKDAY(:startDate) = 6 THEN 1 ELSE 0 END) " +
 - 
 
107 
                        " - (SELECT COUNT(*) " +
 106 
                        " - (SELECT COUNT(*) " +
108 
                        " FROM logistics.publicholidays " +
 107 
                        " FROM logistics.publicholidays " +
109 
                        " WHERE date BETWEEN :startDate AND LAST_DAY(:startDate) " +
 108 
                        " WHERE date BETWEEN :startDate AND LAST_DAY(:startDate) " +
110 
                        " AND WEEKDAY(date) != 6) AS working_days"
 109 
                        " AND WEEKDAY(date) != 6) AS working_days"
111 
        );
 110 
        );