## 20170711工作内容 #### 挽回活动数据统计 > SELECT SUM(pai.`amount`) AS amount, SUM(pai.`annul_amount`) AS annulAmount FROM crm_pay_info pai WHERE pai.`pay_status` = 2 AND pai.`crm_merchant_id` = 261 AND pai.`activity_set_detail_id` IN (SELECT masd.`id` FROM crm_cashier_merchant_activity_set_detail masd WHERE masd.`occupy_status` = 1 AND masd.`use_status` = 1 AND masd.`activity_set_id` IN (SELECT mas.`id` FROM crm_cashier_merchant_activity_set mas WHERE mas.`activity_fee_pay_status` = 1 AND mas.`activity_type` = 3 AND mas.`merchant_id` = 261)) ; #### 微信运动数据获取 + 后台api