优惠券订单及其他脚本

1.log 11KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296
  1. https://pub.alimama.com/report/getTbkThirdPaymentDetails.json?DownloadID=DOWNLOAD_REPORT_TK3_PUB&queryType=2&payStatus=&startTime=2018-09-18%2000:00:00&endTime=2018-09-19%2000:00:00
  2. / ************************ order1-Start ************************* /
  3. order_id:222313902422650712|| goods_id:544299909418|| orderstatus:1|| order_balance_at:|| update_time:1537324250|| predict_income:184|| adzone_id:17309850442
  4. User:不存在
  5. action:插入操作
  6. orderinsert:252977
  7. / ** order1-End ** /
  8. / ************************ order2-Start ************************* /
  9. order_id:222984835650256791|| goods_id:572517635627|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:25|| adzone_id:21436950465
  10. User:不存在
  11. action:插入操作
  12. orderinsert:252978
  13. / ** order2-End ** /
  14. / ************************ order3-Start ************************* /
  15. order_id:222946435137613665|| goods_id:523803337531|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:69|| adzone_id:17309850442
  16. User:不存在
  17. action:插入操作
  18. orderinsert:252979
  19. / ** order3-End ** /
  20. / ************************ order4-Start ************************* /
  21. order_id:222585057503617756|| goods_id:529411927274|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:499|| adzone_id:651234394
  22. User:存在
  23. action:插入操作
  24. orderinsert:252980
  25. rebateinsert_self:46106
  26. rebateinsert_sup1:46107
  27. rebateinsert_YysManage:8017
  28. / ** order4-End ** /
  29. / ************************ order5-Start ************************* /
  30. order_id:222862755141755855|| goods_id:543284710577|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:49|| adzone_id:17309850442
  31. User:不存在
  32. action:插入操作
  33. orderinsert:252981
  34. / ** order5-End ** /
  35. / ************************ order6-Start ************************* /
  36. order_id:222852323282781961|| goods_id:573870612563|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:11|| adzone_id:21436950465
  37. User:不存在
  38. action:插入操作
  39. orderinsert:252982
  40. / ** order6-End ** /
  41. / ************************ order7-Start ************************* /
  42. order_id:222360032704781961|| goods_id:554829627486|| orderstatus:0|| order_balance_at:|| update_time:1537324251|| predict_income:0|| adzone_id:21436950465
  43. User:不存在
  44. action:插入操作
  45. orderinsert:252983
  46. / ** order7-End ** /
  47. / ************************ order8-Start ************************* /
  48. order_id:222031341261189626|| goods_id:26336348792|| orderstatus:1|| order_balance_at:|| update_time:1537324251|| predict_income:276|| adzone_id:651206400
  49. User:存在
  50. action:插入操作
  51. orderinsert:252984
  52. rebateinsert_self:46108
  53. rebateinsert_sup1:46109
  54. rebateinsert_YysManage:8018
  55. / ** order8-End ** /
  56. / ************************ order9-Start ************************* /
  57. order_id:222555906702807584|| goods_id:19789624507|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:110|| adzone_id:17311650203
  58. User:不存在
  59. action:插入操作
  60. orderinsert:252985
  61. / ** order9-End ** /
  62. / ************************ order10-Start ************************* /
  63. order_id:222360879295929502|| goods_id:542925692908|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:6|| adzone_id:22951700189
  64. User:不存在
  65. action:插入操作
  66. orderinsert:252986
  67. / ** order10-End ** /
  68. / ************************ order11-Start ************************* /
  69. order_id:222500226102264081|| goods_id:561363851114|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:202|| adzone_id:17312750365
  70. User:不存在
  71. action:插入操作
  72. orderinsert:252987
  73. / ** order11-End ** /
  74. / ************************ order12-Start ************************* /
  75. order_id:222500226102264081|| goods_id:561363851114|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:145|| adzone_id:17312750365
  76. User:不存在
  77. action:更新操作
  78. orderupdate:0
  79. / ** order12-End ** /
  80. / ************************ order13-Start ************************* /
  81. order_id:222500226102264081|| goods_id:561363851114|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:101|| adzone_id:17312750365
  82. User:不存在
  83. action:更新操作
  84. orderupdate:0
  85. / ** order13-End ** /
  86. / ************************ order14-Start ************************* /
  87. order_id:222500226102264081|| goods_id:561363851114|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:145|| adzone_id:17312750365
  88. User:不存在
  89. action:更新操作
  90. orderupdate:0
  91. / ** order14-End ** /
  92. / ************************ order15-Start ************************* /
  93. order_id:222082382509443117|| goods_id:525248995106|| orderstatus:1|| order_balance_at:|| update_time:1537324252|| predict_income:202|| adzone_id:17309850442
  94. User:不存在
  95. action:插入操作
  96. orderinsert:252988
  97. / ** order15-End ** /
  98. / ************************ order16-Start ************************* /
  99. order_id:222263616922748695|| goods_id:570783819649|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:269|| adzone_id:17312750365
  100. User:不存在
  101. action:插入操作
  102. orderinsert:252989
  103. / ** order16-End ** /
  104. / ************************ order17-Start ************************* /
  105. order_id:222284111659140747|| goods_id:571939460018|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:75|| adzone_id:17311650203
  106. User:不存在
  107. action:插入操作
  108. orderinsert:252990
  109. / ** order17-End ** /
  110. / ************************ order18-Start ************************* /
  111. order_id:221897741720426100|| goods_id:554476508327|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:399|| adzone_id:17312750365
  112. User:不存在
  113. action:插入操作
  114. orderinsert:252991
  115. / ** order18-End ** /
  116. / ************************ order19-Start ************************* /
  117. order_id:222343617479829173|| goods_id:563681739842|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:149|| adzone_id:17309850442
  118. User:不存在
  119. action:插入操作
  120. orderinsert:252992
  121. / ** order19-End ** /
  122. / ************************ order20-Start ************************* /
  123. order_id:221770156050198321|| goods_id:566293960538|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:149|| adzone_id:17309850442
  124. User:不存在
  125. action:插入操作
  126. orderinsert:252993
  127. / ** order20-End ** /
  128. / ************************ order21-Start ************************* /
  129. order_id:222369570758115163|| goods_id:547480886985|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:434|| adzone_id:17312750365
  130. User:不存在
  131. action:插入操作
  132. orderinsert:252994
  133. / ** order21-End ** /
  134. / ************************ order22-Start ************************* /
  135. order_id:222275969829611287|| goods_id:44550494128|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:151|| adzone_id:17312750365
  136. User:不存在
  137. action:插入操作
  138. orderinsert:252995
  139. / ** order22-End ** /
  140. / ************************ order23-Start ************************* /
  141. order_id:222154688781900061|| goods_id:570208685303|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:299|| adzone_id:17309850442
  142. User:不存在
  143. action:插入操作
  144. orderinsert:252996
  145. / ** order23-End ** /
  146. / ************************ order24-Start ************************* /
  147. order_id:222559939613138076|| goods_id:565009580336|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:173|| adzone_id:17309850442
  148. User:不存在
  149. action:插入操作
  150. orderinsert:252997
  151. / ** order24-End ** /
  152. / ************************ order25-Start ************************* /
  153. order_id:221576205600667026|| goods_id:575711189129|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:74|| adzone_id:21436950465
  154. User:不存在
  155. action:插入操作
  156. orderinsert:252998
  157. / ** order25-End ** /
  158. / ************************ order26-Start ************************* /
  159. order_id:222224322012535074|| goods_id:563741525260|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:32|| adzone_id:22951700189
  160. User:不存在
  161. action:插入操作
  162. orderinsert:252999
  163. / ** order26-End ** /
  164. / ************************ order27-Start ************************* /
  165. order_id:221788526225040040|| goods_id:534933938464|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:49|| adzone_id:17311650203
  166. User:不存在
  167. action:插入操作
  168. orderinsert:253000
  169. / ** order27-End ** /
  170. / ************************ order28-Start ************************* /
  171. order_id:221555820411118736|| goods_id:550428735047|| orderstatus:1|| order_balance_at:|| update_time:1537324253|| predict_income:23|| adzone_id:22951700189
  172. User:不存在
  173. action:插入操作
  174. orderinsert:253001
  175. / ** order28-End ** /
  176. / ************************ order29-Start ************************* /
  177. order_id:221978752326660484|| goods_id:538308688994|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:345|| adzone_id:17309850442
  178. User:不存在
  179. action:插入操作
  180. orderinsert:253002
  181. / ** order29-End ** /
  182. / ************************ order30-Start ************************* /
  183. order_id:222176546380528894|| goods_id:559203584536|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:254|| adzone_id:17312750365
  184. User:不存在
  185. action:插入操作
  186. orderinsert:253003
  187. / ** order30-End ** /
  188. / ************************ order31-Start ************************* /
  189. order_id:222437123045289998|| goods_id:560848221440|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:15|| adzone_id:17309850442
  190. User:不存在
  191. action:插入操作
  192. orderinsert:253004
  193. / ** order31-End ** /
  194. / ************************ order32-Start ************************* /
  195. order_id:221973199049691229|| goods_id:570189601573|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:18|| adzone_id:17311650203
  196. User:不存在
  197. action:插入操作
  198. orderinsert:253005
  199. / ** order32-End ** /
  200. / ************************ order33-Start ************************* /
  201. order_id:221482444306872711|| goods_id:562542537394|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:23|| adzone_id:21436950465
  202. User:不存在
  203. action:插入操作
  204. orderinsert:253006
  205. / ** order33-End ** /
  206. / ************************ order34-Start ************************* /
  207. order_id:221482444306872711|| goods_id:562542537394|| orderstatus:1|| order_balance_at:|| update_time:1537324254|| predict_income:23|| adzone_id:21436950465
  208. User:不存在
  209. action:更新操作
  210. orderupdate:0
  211. / ** order34-End ** /
  212. Array
  213. (
  214. [total_num] => 34
  215. [generalinsert_num] => 2
  216. [generalupdate_num] => 0
  217. [nouserinsert_num] => 28
  218. [nouserupdate_num] => 0
  219. [fail_insert_num] => 0
  220. [fail_insert_ids] =>
  221. [fail_insertno_num] => 0
  222. [fail_insertno_ids] =>
  223. [fail_update_num] => 0
  224. [fail_update_ids] =>
  225. [fail_updateno_num] => 4
  226. [fail_updateno_ids] => 222500226102264081|222500226102264081|222500226102264081|221482444306872711|
  227. )