215 |
} |
} |
216 |
|
|
217 |
@Override |
@Override |
218 |
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 { |
219 |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
220 |
|
|
221 |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, indlast) " + |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, OmdelingDag, indlast) " + |
222 |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
223 |
|
|
224 |
|
|
225 |
|
|
241 |
stmt.setString( 8, result.splitResult.lejlighed); |
stmt.setString( 8, result.splitResult.lejlighed); |
242 |
stmt.setString( 9, result.splitResult.resten); |
stmt.setString( 9, result.splitResult.resten); |
243 |
stmt.setString(10, brugerid); |
stmt.setString(10, brugerid); |
244 |
stmt.setInt(11, getStatusInt(result.status) ); |
stmt.setString(11, omdelingsdag); |
245 |
|
stmt.setInt(12, getStatusInt(result.status) ); |
246 |
|
|
247 |
stmt.executeUpdate(); |
stmt.executeUpdate(); |
248 |
|
|