[update] 修正客戶若沒有未處理預約單時，改回null而非404
順便修正sql語句錯誤
| | |
|---|
| | | id bigserial NOT NULL, |
|---|
| | | appointment_id bigserial NOT NULL, |
|---|
| | | send_time timestamp NULL, |
|---|
| | | CONSTRAINT appointment_pending_notify_record_pk PRIMARY KEY (id) |
|---|
| | | CONSTRAINT appointment_expiring_notify_record_pk PRIMARY KEY (id) |
|---|
| | | ); |
|---|
| | |
|---|
| | | |
|---|
| | | ç°¡è¨åemailæ以該網åé²å
¥é¦é -> http://localhost:3000?notContactAppointmentId={ææ°ä¸çæªèçé ç´å®} |
|---|
| | | |
|---|
| | | response body: è¥ææå³200並給以ä¸è³æï¼è¥ç¡(æªæä»»ä½é¾ææªèçé ç´å®ï¼åæå404) |
|---|
| | | response body: è¥ææå³200並給以ä¸è³æï¼è¥ç¡(æªæä»»ä½é¾ææªèçé ç´å®ï¼åæånull) |
|---|
| | | { |
|---|
| | | "id": 385, |
|---|
| | | "phone": "0911223344", |
|---|
| | |
|---|
| | | Long customerId = SecurityUtils.getCustomerDBId(); |
|---|
| | | AppointmentCustomerViewDTO customerNewestExpiringAppointment = appointmentService.getCustomerNewestExpiringAppointment(customerId); |
|---|
| | | |
|---|
| | | if(Objects.nonNull(customerNewestExpiringAppointment)) { |
|---|
| | | return new ResponseEntity<>(customerNewestExpiringAppointment, HttpStatus.OK); |
|---|
| | | } |
|---|
| | | else { |
|---|
| | | return new ResponseEntity<>(HttpStatus.NOT_FOUND); |
|---|
| | | } |
|---|
| | | return new ResponseEntity<>(customerNewestExpiringAppointment, HttpStatus.OK); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @GetMapping("/consultant/pending/sum") |
|---|
