任务描述
暂无
需求描述

一、数据说明：WISH账号的余额

二、采集时间：每天采集

三、采集字段：（采集字段+登录账号+添加时间）

登录账号
添加时间
当前余额
待确认余额


四、采集路径：WISH卖家后台首页





验收标准
暂无
历史记录  
  1. 2022-04-13 19:15:54, 由 林鸿贵 创建。
  2. 2022-04-15 19:24:48, 由 林鸿贵 启动。
    修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2022-04-15 19:24:45"。
    修改了 任务状态，旧值为 "wait"，新值为 "doing"。
  3. 2022-04-15 19:24:57, 由 林鸿贵 编辑。
    修改了 最初预计，旧值为 "21"，新值为 "24"。
  4. 2022-04-19 18:03:49, 由 林鸿贵 完成。
    修改了 总计消耗，旧值为 "0"，新值为 "16"。
    修改了 实际完成，旧值为 ""，新值为 "2022-04-19 18:03:22"。
    修改了 任务状态，旧值为 "doing"，新值为 "done"。
    修改了 预计剩余，旧值为 "21"，新值为 "0"。
    修改了 由谁完成，旧值为 ""，新值为 "linhonggui"。

    --主表
    select * from WishRawContentEntity_20220401 where  __LoginUserName='default_.wish.com\feliceci@163.com' and CreateTime>='2022-04-15 00:00:00' order by CreateTime desc
    --DELETE WishRawContentEntity_20220401;


    --后台余额
    select Id
    ,Account
    ,convert(varchar(518),CurrentMoney,120) AS '当前余额'
    ,convert(varchar(518),UnsureMoney,120) AS '待确认余额'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
     from WishHomeAccountMoney_20220401;
    --DELETE WishHomeAccountMoney_20220401;


    --打款汇总
    select Id
    ,convert(varchar(518),PaymentId,120) AS '付款ID'
    ,convert(varchar(518),PaymentDate,120) AS '付款日期'
    ,convert(varchar(518),Provider,120) AS '服务商'
    ,convert(varchar(518),ProviderPhone,120) AS '服务商电话'
    ,convert(varchar(518),ProviderEmail,120) AS '服务商电子邮箱'
    ,convert(varchar(518),Amount,120) AS '总额'
    ,convert(varchar(518),TotalCost,120) AS '交易款项'
    ,convert(varchar(518),TotalRefund,120) AS '退款扣除'
    ,convert(varchar(518),Fee,120) AS '其他费用'
    ,convert(varchar(518),Fine,120) AS '赔款或暂扣货款金额'
    ,convert(varchar(518),Currency,120) AS '付款币种'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
     from WishHistoryPayment_20220401;
    --DELETE WishHistoryPayment_20220401;


    --交易款项
    select Id
    ,convert(varchar(518),PaymentId,120),'付款ID'
    ,convert(varchar(518),TransactionDate,120) AS '交易日期'
    ,convert(varchar(518),OrderId,120) AS '订单ID'
    ,convert(varchar(518),TransactionId,120) AS '交易ID'
    ,convert(varchar(518),SKU,120) AS 'SKU'
    ,convert(varchar(518),ProductId,120) AS '产品ID'
    ,convert(varchar(518),Quantity,120) AS '数量'
    ,convert(varchar(518),RevShare,120) AS 'Rev份额 (%)'
    ,convert(varchar(518),Currency,120) AS '货币'
    ,convert(varchar(518),PriceEach,120) AS '价格 (每个)'
    ,convert(varchar(518),ShippingEach,120) AS '运输 (每个)'
    ,convert(varchar(518),CostEach,120) AS '成本 (每个)'
    ,convert(varchar(518),ShippingCostEach,120) AS '运费 (每个)'
    ,convert(varchar(518),WishPostShipping,120) AS 'Wish邮运输'
    ,convert(varchar(518),TotalCost,120) AS '总成本'
    ,convert(varchar(518),RefundType,120) AS '退款类型'
    ,convert(varchar(518),RefundedAmount,120) AS '退款金额'
    ,convert(varchar(518),RefundResponsibilityPercentage,120) AS '退款责任百分比'
    ,convert(varchar(518),RefundResponsibility,120) AS '退款责任'
    ,convert(varchar(518),Tax,120) AS '净税'
    ,convert(varchar(518),PaidAmount,120) AS '支付金额'
    ,convert(varchar(518),ShippedOn,120) AS '发货日期'
    ,convert(varchar(518),Provider,120) AS '供应商'
    ,convert(varchar(518),Tracking,120) AS '跟踪'
    ,convert(varchar(518),Name,120) AS '名称'
    ,convert(varchar(518),StreetAddress1,120) AS '街道地址1'
    ,convert(varchar(518),StreetAddress2,120) AS '街道地址2'
    ,convert(varchar(518),StreetAddress3,120) AS '街道地址3'
    ,convert(varchar(518),City,120) AS '城市'
    ,convert(varchar(518),State,120) AS '状态'
    ,convert(varchar(518),ZipCode,120) AS '邮编'
    ,convert(varchar(518),CountryCode,120) AS '国家代码'
    ,convert(varchar(518),PhoneNumber,120) AS '电话号码'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
    ,convert(varchar(518),TaxCurrency,120) AS '税的币种'
     from WishHistoryPaymentTotalCost_20220401;
    --DELETE WishHistoryPaymentTotalCost_20220401;

    --其他费用
    select Id
    ,convert(varchar(518),PaymentId,120) AS '付款ID'
    ,convert(varchar(518),Date,120) AS '付款日期'
    ,convert(varchar(518),Reason,120) AS '原因'
    ,convert(varchar(518),Currency,120) AS '货币'
    ,convert(varchar(518),Amount,120) AS '金额'
    ,convert(varchar(518),ItemId,120) AS '记录ID'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
     from WishHistoryPaymentFineDetailFee_20220401;
    --DELETE WishHistoryPaymentFineDetailFee_20220401;

    --退款扣除
    select     Id
    ,convert(varchar(518),PaymentId,120) AS '付款ID'
    ,convert(varchar(518),Date,120) AS '付款日期'
    ,convert(varchar(518),Reason,120) AS '原因'
    ,convert(varchar(518),Currency,120) AS '货币'
    ,convert(varchar(518),Amount,120) AS '金额'
    ,convert(varchar(518),ItemId,120) AS '记录ID'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
     from WishHistoryPaymentFineDetailFine_20220401;
    --DELETE WishHistoryPaymentFineDetailFine_20220401;


    --暂扣金额
    select Id
    ,convert(varchar(518),PaymentId,120) AS '付款ID'
    ,convert(varchar(518),TransactionDate,120) AS '交易日期'
    ,convert(varchar(518),OrderId,120) AS '订单ID'
    ,convert(varchar(518),TransactionId,120) AS '交易ID'
    ,convert(varchar(518),SKU,120) AS 'SKU'
    ,convert(varchar(518),ProductId,120) AS '产品ID'
    ,convert(varchar(518),Quantity,120) AS '数量'
    ,convert(varchar(518),RevShare,120) AS 'Rev份额 (%)'
    ,convert(varchar(518),Currency,120) AS '货币'
    ,convert(varchar(518),PriceEach,120) AS '价格 (每个)'
    ,convert(varchar(518),ShippingEach,120) AS '运输 (每个)'
    ,convert(varchar(518),CostEach,120) AS '成本 (每个)'
    ,convert(varchar(518),ShippingCostEach,120) AS '运费 (每个)'
    ,convert(varchar(518),WishPostShipping,120) AS 'Wish邮运输'
    ,convert(varchar(518),TotalCost,120) AS '总成本'
    ,convert(varchar(518),RefundType,120) AS '退款类型'
    ,convert(varchar(518),RefundedAmount,120) AS '退款金额'
    ,convert(varchar(518),RefundResponsibilityPercentage,120) AS '退款责任百分比'
    ,convert(varchar(518),RefundResponsibility,120) AS '退款责任'
    ,convert(varchar(518),Tax,120) AS '净税'
    ,convert(varchar(518),PaidAmount,120) AS '支付金额'
    ,convert(varchar(518),ShippedOn,120) AS '发货日期'
    ,convert(varchar(518),Provider,120) AS '供应商'
    ,convert(varchar(518),Tracking,120) AS '跟踪'
    ,convert(varchar(518),Name,120) AS '名称'
    ,convert(varchar(518),StreetAddress1,120) AS '街道地址1'
    ,convert(varchar(518),StreetAddress2,120) AS '街道地址2'
    ,convert(varchar(518),StreetAddress3,120) AS '街道地址3'
    ,convert(varchar(518),City,120) AS '城市'
    ,convert(varchar(518),State,120) AS '状态'
    ,convert(varchar(518),ZipCode,120) AS '邮编'
    ,convert(varchar(518),CountryCode,120) AS '国家代码'
    ,convert(varchar(518),PhoneNumber,120) AS '电话号码'
    ,convert(varchar(518),__TaskId,120) AS '任务Id'
    ,convert(varchar(518),__CrawlDate,120) AS '爬取时间'
    ,convert(varchar(518),__LoginUserName,120) AS '登录账号'
    ,convert(varchar(518),__Api,120) AS 'Api'
    ,convert(varchar(518),__ApiType,120) AS 'Api类型'
    ,convert(varchar(518),__RawContentRefId,120) AS 'RawContent数据Id'
    ,convert(varchar(518),__CreateDateTime,120) AS '创建数据的时间'
    ,convert(varchar(518),__StepName,120) AS '流程阶段名称'
    ,convert(varchar(518),TaxCurrency,120) AS '税的币种'
     from WishHistoryPaymentTotalWithheld_20220401;
    --DELETE WishHistoryPaymentTotalWithheld_20220401;


  5. 2022-04-20 10:40:09, 由 林鸿贵 指派给 梁贵荣。
    修改了 指派给，旧值为 "linhonggui"，新值为 "liangguirong"。
  6. 2022-05-06 13:36:56, 由 梁贵荣 关闭。
    修改了 任务状态，旧值为 "done"，新值为 "closed"。
    修改了 指派给 ，旧值为 "liangguirong"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "liangguirong"。
    修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2022-05-06 13:36:56"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
所属迭代 平台财务数据自动化获取（接口/小工具）
所属模块 /
相关需求 WISH后台余额采集
指派给 Closed 于 2022-05-06 13:36:56
任务类型 测试
任务标签 初始
开发组
任务状态 已关闭
进度 100%
优先级 P1
关键词
抄送给
由谁创建 林鸿贵 于 2022-04-13 19:15:54
由谁完成 林鸿贵 于 2022-04-19 18:03:22
由谁取消 暂无
由谁关闭 梁贵荣 于 2022-05-06 13:36:56
关闭原因 已完成
最后编辑 梁贵荣 于 2022-05-06 13:36:56
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 24工时
总计消耗 16工时
预计剩余 0工时
预计开始 0000-00-00
实际开始 2022-04-15
截止日期 0000-00-00