New Function #51
Updated by Deca Park over 1 year ago
<p>[Save Money process logic]</p>
<p>1.when POST signup API is done</p>
<p> 1) if save money was already created, <strong>SKIP </strong><br />
- DB: st_user_save_money<br />
- conditions: user_seq = {the user_seq} AND save_money_type = <strong>'SM02'</strong><br />
2) create save money<br />
a) if st_money_coupon.money_signup > 0 (NOT NULL)<br />
a-1) INSERT st_user_save_money<br />
user_seq = {signup user_seq}, save_money_type = <strong>'SM02'</strong><br />
save_money = {st_money_coupon.money_signup}<br />
, save_date={signup datetime}, reg_date/reg_user_seq</p>
<p>2.when POST /api/review API is done</p>
<p> <s>1) if save money was already created, <strong>SKIP </strong><br />
- DB: st_user_save_money<br />
- conditions: review_code= {the review_code} AND save_money_type = <strong>'SM03'</strong></s><br />
2) create save money<br />
a) if st_money_coupon.money_review_text > 0 (NOT NULL) OR<br />
st_money_coupon.money_review_image > 0 (NOT NULL) <br />
a-1) INSERT st_user_save_money<br />
user_seq = {write user_seq}, save_money_type = <strong>'SM03'</strong><br />
if attach_file exists<br />
- save_money = {st_money_coupon.money_review_image}<br />
else<br />
- save_money = {st_money_coupon.money_review_text}<br />
save_date={signup datetime}, reg_date/reg_user_seq</p>
<p>3.when st_order.order_status is updated with 'OS04' (구매확정: purchase confirmation) on ADMIN<br />
OR when st_order.order_status is updated with 'SS04' (수령완료: Receipt complete) on ADMIN</p>
<p> 1) if save money was already created, <strong>SKIP </strong><br />
- DB: st_user_save_money<br />
- conditions: order_no = {the order_no} AND save_money_type = <strong>'SM01' </strong><br />
2) create save money<br />
a) if st_money_coupon.money_grant_ratio > 0 (NOT NULL)<br />
a-1) INSERT st_user_save_money<br />
user_seq = {write user_seq}, save_money_type = <strong>'SM01'</strong><br />
mall_code = {the mall_code} , order_no = {the order_no}<br />
save_money = {st_order.payment_amount} * {money_grant_ratio} (%)<br />
- truncate on first number (ex: 1001 -> 1000)<br />
save_date={signup datetime}<br />
reg_date/reg_user_seq</p>