--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/08/23 16:17:56 2664 +++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/08/25 08:46:29 2665 @@ -215,11 +215,11 @@ } @Override - public void saveRequestLog(String brugerid, String postnr, String adresse, SearchResult result) throws SQLException { + public void saveRequestLog(String brugerid, String postnr, String adresse, String omdelingsdag, SearchResult result) throws SQLException { String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; - String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, indlast) " + - "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; + String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, omdelingsdag, indlast) " + + "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; @@ -241,7 +241,8 @@ stmt.setString( 8, result.splitResult.lejlighed); stmt.setString( 9, result.splitResult.resten); stmt.setString(10, brugerid); - stmt.setInt(11, getStatusInt(result.status) ); + stmt.setString(11, omdelingsdag); + stmt.setInt(12, getStatusInt(result.status) ); stmt.executeUpdate();