退货计划设计

工作 Today

http://10.10.10.12:8081/swagger/?type=10#!/dapeng/get_api_dapeng_rack_listStore

alter table refund_plan_item
  drop column buying_price,
  drop column selling_price,
  drop column input_tax,
  drop column output_tax,
  drop column mark,
  drop column order_multiple,
  drop column sku_total_amount;
alter table refund_plan 
    drop column logistics_center,
    drop column amount;
alter table refund_plan add column store_ids text comment '执行计划的门店财务店号，店号以逗号分隔';
--
create table store_refund_plan_rel(
  id bigint not null primary key comment '主键',
  store_id char(8) not null default '' comment '财务店号',
  refund_plan_id bigint not null default 0 comment '执行的退货计划id',
  status tinyint(3) not null default 1 comment '状态,10:待处理(to_be_handled);20:已处理(handled);30:已完结(finished)',
  refund_total_num int not null default 0 comment '退货总数',
  refund_total_amount decimal(16, 4) default 0 comment '退货总金额',
  created_at datetime not null comment '创建时间',
  created_by int not null comment '特指后台创建人(公司员工 id)',
  updated_at timestamp default CURRENT_TIMESTAMP not null comment '更新时间',
  updated_by int not null comment '特指后台更新人(公司员工 id)',
  remark varchar(255) not null default '' comment '备注',
  unique key store_refund_plan(store_id, refund_plan_id)
) comment '门店退货计划关联表' charset = utf8mb4;
-- 门店填写退货计划
update store_refund_plan_rel set
  status = 20,
  refund_total_amount = 100000,
  refund_total_num = 1000,
  updated_at = now(),
  updated_by = 1
where id = 1000;
-- 门店修改退货计划
update store_refund_plan_rel set
  refund_total_amount = 100000,
  refund_total_num = 1000,
  updated_at = now(),
  updated_by = 1
where id = 1000;
-- 门店查询退货计划
select rp.*,srpr.refund_total_num, srpr.refund_total_amount from store_refund_plan_rel srpr
  left join refund_plan rp on srpr.refund_plan_id = rp.id
  where srpr.store_id = 11712000;

1.增加AddStoreRefundPlanRelAction 6h 曹璐

2.门店查询

http://10.10.10.12:8081/swagger/?type=10#!/dapeng/get_api_dapeng_rack_listStore

2.退货计划接口调整 6h 曹璐

CreateRefundRequest : 增加list<string> storeIds字段，删除logisticsCenter 字段
CreateRefundPlanAction： 数据入库调整
AuditRefundPlanAction: 审核成功后，
// 建议异步处理：
    refundPlan.storeIds.foreach { storeId => 
        new AddStoreRefundPlanRelAction(storeId, refundPlanId, status = 10)
    }

3.门店执行退货计划 8h 曹佳林

ConfirmRefundPlanAction: 
    更新门店退货计划关联表信息
    updateStoreRefundPlanRel(
        storeId, 
        refundPlanId, 
        status = 20,
        refundTotalNum = 退货单.skuTotalNum,
        refundTotalAmount = 退货单.orderAmount,
        )
/**
update store_refund_plan_rel set
  status = 20,
  refund_order_id = 3455555,
  refund_total_amount = 100000,
  refund_total_num = 1000,
  updated_at = now(),
  updated_by = 1
where store_id = 1000 and refund_plan_id = 23;
*/ 
UpdateStoreRefundPlanAction: 
    更新门店退货计划关联表信息
    updateStoreRefundPlanRel(
        storeId, 
        refundPlanId,
        refundTotalNum = 退货单.skuTotalNum,
        refundTotalAmount = 退货单.orderAmount,
        )
/**
update store_refund_plan_rel set
  refund_order_id = 3455555,
  refund_total_amount = 100000,
  refund_total_num = 1000,
  updated_at = now(),
  updated_by = 1
where store_id = 1000 and refund_plan_id = 23;
*/

4.查询门店退货计划 6h 曹佳林

TListStoreRefundPlanRequest {
    1: optional i64 refundPlanCreatedAtStart
    2: optional i64 refundPlanCreatedAtEnd,
    3: optional i64 refundPlanStart,
    3: optional i64 refundPlanEnd,
    4: 分页
}
TListStoreRefundPlanResponse {
    1: pageResponse
    2: list<TStoreRefundPlan> storeRefundPlans
}
ListStoreRefundPlanAction
select rp.*,srpr.refund_total_num, srpr.refund_total_amount from store_refund_plan_rel srpr
  left join refund_plan rp on srpr.refund_plan_id = rp.id
  where srpr.store_id = 11712000 and srpr.status = 状态;

转闭店方案： 下周三下班提交接口 张俊

TSwitchStoreRequest {
    /**
    * 转出店财务店号
    **/
    1: string fromStoreId,
    /**
    * 转入店财务店号
    **/
    2: string toStoreId
}
void switchStore(1: TSwitchStoreRequest request)
涉及单据： 
叫货单（待验收，部分验收） store_id, store_name
配送单（待配送，配送中） 修改字段 to_id,to_name, to_code
采购单（待确认，待发货，待门店收货，）  store_id
出入库单 (待入库） to_id， to_name
update delivery_order set 
    to_id = 新店号,
    to_code = 新店号,
    to_name = 新店名,
    remark = concat(ifnull(remark, '') , ' 发生转店：A店号 => B店号')
where to_id = 老店号