分类： Icolumn

1.数据迁移 5days

2.前端按照旧版重构 

VMS - Finance Stock Level Alert（send_finance_stock_notification）

旧版里transfer to marcom 可以通过voucher的activate_time来判断

transfer有channel的&&不是transfer to marcom的 会记录voucher info tranfer

所以在重构overview的时候可以得到数据

OVERVIEW 页面重构 1.5days

Create 页面基本一致 看看能否不需要修改 2days

Receive 页面重构2day

Transfer to marcom & Transfer 页面重构 3days

Return 页面重构 1days

只可以操作status是transferred的voucher 也就是说 只可以return trasnfer to customer的voucher

Tenant Submit 页面重构3days

tenant submit continue complete功能开发 2days

Pending Reimbursement Edit Store 0.5days

Reimburse 页面重构 2days

Search (2+1+1+1+0.5+1+1+1 = 8.5)

search voucher no 2days

search voucher status 1days

search campaign/oraganisation 1days

search voucher range 1days

search submission id 0.5days

search monthly report 1days

search Tenant Submit But Not Reimbruse Vouchers From 1days

search Report of Issued and not submitted by Tenant 1days

Investigation 2days

Extend 1days

Void 1days

Operation 1days

Operation Investigation 3days

1.5+2+2+3+1+3+2+0.5+2+8.5+2+1+1+1+3

SELECT b.voucher_value, CONCAT(b.prefix, b.voucher_no) AS voucher_no, c.channel_description, b.issue_time, b.expiry_time, d.status_description
FROM voucher_action a, voucher b, voucher_lkup_channel c, voucher_lkup_status d
WHERE action_time BETWEEN '2016-01-01 00:00:00' AND '2017-01-01 00:00:00' 
AND action_id = 6 
AND a.voucher_id = b.voucher_id 
AND b.transfer_channel = c.channel_id 
AND b.status_id = d.status_id

CSM:

    INBOUND:

        LOINFO_VTS_

        PAYINFO_VTS_

    OUTBOUND:

        CSM_REIM_

        CSM_OTH_

        CSM_ISS_

—————————————-

PR:

    INBOUND:

        LOINFO_VTS_

        PAYINFO_VTS_

    OUTBOUND:

        PR_REIM_

        PR_OTH_

        PR_ISS_

        VTS_VOUCHER_

        CTS_CAMP_

—————————————-

QI:

    INBOUND:

        LOINFO_VTS_

        PAYINFO_VTS_

    OUTBOUND:

        QI_REIM_

        QI_OTH_

        QI_ISS_

—————————————-

LOINFO_VTS_: 每天更新一份store列表
PAYINFO_VTS_：每天接收payment的voucher

XX_REIM: Reimburse,Unreimburse

XX_OTH：Void,Expiry

XX_ISS:Replace,UnIssue,Issue (CSM Voucher & Tenant Voucher)

VTS_VOUCHER_:Cancel,Miss,Void

CTS_CAMP_:在有效时间内的 promotion&promotion_a&p 的 Campaign

select group_concat(a_id) as voucher_ids from (
	select a.voucher_id as a_id, b.voucher_id as b_id
	from voucher_campaign_issue a left join voucher_action b on (b.action_id = 6 and a.voucher_id = b.voucher_id and b.action_time  between '2016-12-01' and '2017-12-01') 
	where a.issue_date  between '2016-12-01' and '2017-12-01' having b.voucher_id is NULL
) x