优惠券订单及其他脚本

excel_third_order_0825.log 3.5KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. https://pub.alimama.com/report/getTbkThirdPaymentDetails.json?DownloadID=DOWNLOAD_REPORT_TK3_PUB&queryType=2&payStatus=&startTime=2018-08-25%2000:00:00&endTime=2018-08-26%2000:00:00
  2. / ************************ order1-Start ************************* /
  3. order_id:176275123238116499|| goods_id:552105993508|| orderstatus:1|| order_balance_at:|| update_time:1535350802|| predict_income:286|| adzone_id:17309850442
  4. User:不存在
  5. action:更新操作
  6. orderupdate:0
  7. / ** order1-End ** /
  8. / ************************ order2-Start ************************* /
  9. order_id:206989646751950578|| goods_id:546841801804|| orderstatus:1|| order_balance_at:|| update_time:1535350802|| predict_income:204|| adzone_id:651084086
  10. User:存在
  11. action:插入操作
  12. orderinsert:143080
  13. rebateinsert_self:32884
  14. rebateinsert_sup1:32885
  15. rebateinsert_YysManage:3367
  16. / ** order2-End ** /
  17. / ************************ order3-Start ************************* /
  18. order_id:207049060541137576|| goods_id:525465793012|| orderstatus:1|| order_balance_at:|| update_time:1535350803|| predict_income:15|| adzone_id:17310550134
  19. User:不存在
  20. action:更新操作
  21. orderupdate:0
  22. / ** order3-End ** /
  23. / ************************ order4-Start ************************* /
  24. order_id:207085043927668688|| goods_id:554829725649|| orderstatus:1|| order_balance_at:|| update_time:1535350803|| predict_income:30|| adzone_id:644264902
  25. User:存在
  26. action:更新操作
  27. 更新数据-> orderstatus:1 order_balance_at:
  28. order/reabte_update:0
  29. / ** order4-End ** /
  30. / ************************ order5-Start ************************* /
  31. order_id:206956438848535461|| goods_id:546335810997|| orderstatus:1|| order_balance_at:|| update_time:1535350803|| predict_income:147|| adzone_id:40352826
  32. User:不存在
  33. action:更新操作
  34. orderupdate:0
  35. / ** order5-End ** /
  36. / ************************ order6-Start ************************* /
  37. order_id:207743085567802734|| goods_id:557443222373|| orderstatus:1|| order_balance_at:|| update_time:1535350803|| predict_income:6|| adzone_id:17309850442
  38. User:不存在
  39. action:更新操作
  40. orderupdate:0
  41. / ** order6-End ** /
  42. / ************************ order7-Start ************************* /
  43. order_id:207576624927122805|| goods_id:573323475370|| orderstatus:1|| order_balance_at:|| update_time:1535350803|| predict_income:164|| adzone_id:651194238
  44. User:存在
  45. action:插入操作
  46. orderinsert:143081
  47. rebateinsert_self:32886
  48. rebateinsert_sup1:32887
  49. rebateinsert_YysManage:3368
  50. / ** order7-End ** /
  51. / ************************ order8-Start ************************* /
  52. order_id:206782558632238240|| goods_id:559114190110|| orderstatus:1|| order_balance_at:|| update_time:1535350804|| predict_income:80|| adzone_id:40352826
  53. User:不存在
  54. action:更新操作
  55. orderupdate:0
  56. / ** order8-End ** /
  57. / ************************ order9-Start ************************* /
  58. order_id:206835255824761984|| goods_id:567804662718|| orderstatus:1|| order_balance_at:|| update_time:1535350804|| predict_income:79|| adzone_id:17311650203
  59. User:不存在
  60. action:更新操作
  61. orderupdate:0
  62. / ** order9-End ** /
  63. Array
  64. (
  65. [total_num] => 9
  66. [generalinsert_num] => 2
  67. [generalupdate_num] => 0
  68. [nouserinsert_num] => 0
  69. [nouserupdate_num] => 0
  70. [fail_insert_num] => 0
  71. [fail_insert_ids] =>
  72. [fail_insertno_num] => 0
  73. [fail_insertno_ids] =>
  74. [fail_update_num] => 1
  75. [fail_update_ids] => 207085043927668688|
  76. [fail_updateno_num] => 6
  77. [fail_updateno_ids] => 176275123238116499|207049060541137576|206956438848535461|207743085567802734|206782558632238240|206835255824761984|
  78. )