changes to spotcheck dao, service, api, frontend