# Sendy Mail List Spec
* Using rails to get member groups from kdan cloud
* Using gem Sequel to access sendy mysql db

# Story
* Need a one-time promotion mail list creater. 
* Need to do a/b testing on a certain event.
* Should not bother opt-out users.
* Should not sent to mark-as-spam users.
* Should not sent to invalid email address.

# Features
1. To create list
      * prefix: [ZCR]
      * manually enter description

2. To add subscriber into list
  * member_center
      * from\_application (member.from\_application)
      * comfirmed (member.confirmed\_at)
      * location (member.identity.location)
      * language (member.identity.language)   
  * iap_service
      * app\_series (receipt.product.app.app_series)
      * pack (receipt.product.pack)
      * platform (receipt.product.app.device)
      * subscription\_status (kdan.subscriptions)
  * A/B Testing
      * Main version %, default 100%

3. To prevent unsubscribed, bounced, complaint emails into the list
  * Unsubscribe flag should be considered as global

4. To delete list

# Models
## Member Center
### Member
~~~ruby
add_column :members, :sendy_sub_status, enum: [:active, :unsubscribed, :bounced, :bounced_soft, :complaint]
~~~
### Schedule.rb
* update :sendy\_sub\_status every 15m
* select subscribers.timestamp \> 15.minutes.ago

## IAP Service
### Kdan
~~~ruby
has_many :subscriptions, class: 'KdanPackSubscription'
~~~
### KdanProduct
~~~ruby
has_many :subscriptions, class: 'KdanPackSubscription'
~~~
### KdanPackSubscription
* only apply to following packs
  * Creativity 365
  * ~~Creativity 365 Teacher & Student~~
  * Document 365
  * ~~Creativity 365 Education~~
  * ~~Creativity 365 Business~~
  * ~~Document 365 Volume Licensing~~

~~~ruby
belongs_to :kdan
belongs_to :kdan_product
~~~
~~~ruby
{
  kdan_id:integer,
  kdan_product_id:integer,
  stauts:[free_trial, subscribed, expired, refund, cancel]
}
~~~
* outsider: Not subscribed yet on pack
* free\_trial: Subscription is in free trial period.
* subscribed: Subscription is active now.
* expired: Only for customer service/creative store offered products 
* cancel: Auto-renew canceled but current subscription not changed.
* refund: Auto-renew canceled and current subscription rollbacked.
* **status priority based on receipts.purchase_date**

### Schedule.rb
* update KdanPackSubscriptionStatus every 15m
	* select kdan\_ids from kdan.updated_at in 15min
	* select kdan\_ids from receipts.end\_of\_date in 15min
	* distinct kdan\_ids
	* cals\_pack\_subscription_status(kdan.receipts)

## CR System
### SendyMailList
~~~ruby
{
  description:string,
  sendy_list_long_id:string,
  sendy_list_short_id:integer,
  select_criteria:json,
  email_count:integer,
  sendy_delete_at:datetime,
}
~~~

* query from backup db: meber\_center and iap\_center 
* sequel to insert sendy list and subscriber

# Views
## CR System

### Select Criteria
* member\_center
      * from\_application
      * comfirmed
      * location
      * language    
* iap\_service
      * app\_series
      * pack
      * platform
      * subscription_status
* A/B Testing
      * Main version %, default 100%

### Search Result

Going to Build up Sendy list [Go]

* List Name: [ZCR] my list
* List Count: 100
* List Content: 
  * kdan\_id, email, from\_application, comfirmed, location, language, app\_series, pack, platform

----

* List Name: [ZCR] my list ver. A
* List Count: 50
* List Content: 
  * kdan\_id, email, from\_application, comfirmed, location, language, app\_series, pack, platform

* List Name: [ZCR] my list ver. B
* List Count: 50
* List Content: 
  * kdan\_id, email, from\_application, comfirmed, location, language, app\_series, pack, platform