自建票券取券邏輯.md
1 additions, 1 deletions
| ... | ... | @@ -4,7 +4,7 @@ |
| 4 | 4 | * 業務邏輯： |
| 5 | 5 | * 檢查庫存是否 = 0 , 是則寄送庫存不足通知信給客服群組與卡金群組 |
| 6 | 6 | ```sql |
| 7 | - select count(*) from SELFGEN_VOUCHER where PRODUCT_ID = :productId and is_exchanged='0' and STATUS='AVAILABLE' and TICKET_END_TIME > current_timestamp"); | |
| 7 | + select count(*) from SELFGEN_VOUCHER where PRODUCT_ID = :productId and is_exchanged='0' and STATUS='AVAILABLE' and TICKET_END_TIME > current_timestamp; | |
| 8 | 8 | ``` |
| 9 | 9 | * 查詢庫存數量：以下語法count數量就是庫存數量 |
| 10 | 10 | * 信件群組: select * from DBMT.T_MONITOR_USR_INFO where category = 'selfgen_getVoucher'; |