[update] 修正上次登入時間應為最近日期,故sql需為倒序查詢
| | |
| | | |
| | | @Repository |
| | | public interface LoginRecordRepository extends JpaRepository<LoginRecord, Long> { |
| | | Optional<LoginRecord> findTopByAccountAndResultOrderByLoginDate(String account, LoginResult loginResult); |
| | | Optional<LoginRecord> findTopByAccountAndResultOrderByLoginDateDesc(String account, LoginResult loginResult); |
| | | } |
| | |
| | | LoginRecordRepository loginRecordRepository; |
| | | |
| | | public Optional<LoginRecord> findLatestLoginRecord(String account, LoginResult loginResult) { |
| | | return loginRecordRepository.findTopByAccountAndResultOrderByLoginDate(account, loginResult); |
| | | return loginRecordRepository.findTopByAccountAndResultOrderByLoginDateDesc(account, loginResult); |
| | | } |
| | | |
| | | public void saveOTPLoginSuccessRecord(String account) { |