/[projects]/dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java
ViewVC logotype

Diff of /dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2774 by torben, Tue Nov 3 10:02:56 2015 UTC revision 2775 by torben, Thu Nov 19 15:29:36 2015 UTC
# Line 140  public class DatabaseLayerImplementation Line 140  public class DatabaseLayerImplementation
140                                    
141                                    
142                  String sql = "select orgid, a.id as targetid, afstand, LOWER(type) as type from fulddaekning.afstand_anden_rute a " +                  String sql = "select orgid, a.id as targetid, afstand, LOWER(type) as type from fulddaekning.afstand_anden_rute a " +
143                                          "join odbc.transporttype t " +                                          "LEFT join odbc.transporttype t " +
144                                          "on t.Art = 'Transpost' " +                                          "ON (t.Rute = a.Rute) " +
                                         "and ( (t.Type = 'Cykel' and a.Afstand < 1.001) or (t.Type = 'Scooter' and a.Afstand < 1.201) or (t.Type = 'Bil' and a.Afstand < 2.601) ) " +  
                                         "and t.Rute = a.Rute " +  
145                                          debugFilter1 +                                          debugFilter1 +
146                                                                                    
147                                          "UNION ALL " +                                          "UNION ALL " +
Legend:
Removed from v.2774  
changed lines
  Added in v.2775
  ViewVC Help
Powered by ViewVC 1.1.20