{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 : 20ad8c3f-f38c-44e5-8a15-3a628a6fa7e7 : 刘光春120天联系情况 (任务ID: 17638970176)\n",
      "1 : 20ad8c3f-f38c-44e5-8a15-3a628a6fa7e7 : 孙海程120天联系情况 (任务ID: 17638970177)\n",
      "1 : 20ad8c3f-f38c-44e5-8a15-3a628a6fa7e7 : 刘光春90天联系情况 (任务ID: 18848447864)转交\n",
      "1 : 20ad8c3f-f38c-44e5-8a15-3a628a6fa7e7 : 孙海程90天联系情况 (任务ID: 18848447865)转交\n",
      "3 : ddc3afd8-3713-4fac-a3da-ad907da168cc : 刘光春120天联系情况 (任务ID: 17638948064)\n",
      "3 : ddc3afd8-3713-4fac-a3da-ad907da168cc : 孙海程120天联系情况 (任务ID: 17638948065)\n",
      "3 : ddc3afd8-3713-4fac-a3da-ad907da168cc : 刘光春90天联系情况 (任务ID: 18848452813)转交\n",
      "3 : ddc3afd8-3713-4fac-a3da-ad907da168cc : 孙海程90天联系情况 (任务ID: 18848452814)转交\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏子淇120天联系情况 (任务ID: 15892338363)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 于睿120天联系情况 (任务ID: 15892338364)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏子淇90天联系情况 (任务ID: 15900786588)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 于睿90天联系情况 (任务ID: 15900786589)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏子淇60天联系情况 (任务ID: 15900776454)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 于睿60天联系情况 (任务ID: 15900776455)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏子淇30天联系情况 (任务ID: 17637537874)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏元盟[已离职]30天联系情况 (任务ID: 17637537875)\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 魏子淇0天处理情况 (任务ID: 18848808661)转交\n",
      "5 : 236e5255-00b9-49cc-9f4f-46b6c025d987 : 邢恒岭0天处理情况 (任务ID: 18848808662)转交\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏子淇120天联系情况 (任务ID: 15892353039)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 于睿120天联系情况 (任务ID: 15892353040)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏子淇90天联系情况 (任务ID: 15900771544)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 于睿90天联系情况 (任务ID: 15900771545)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏子淇60天联系情况 (任务ID: 15900762865)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 于睿60天联系情况 (任务ID: 15900762866)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏子淇30天联系情况 (任务ID: 17637517924)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏元盟[已离职]30天联系情况 (任务ID: 17637517925)\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 魏子淇0天处理情况 (任务ID: 18848844378)转交\n",
      "7 : 2521c7e4-9e12-4f3f-b0af-fdb044b91d51 : 邢恒岭0天处理情况 (任务ID: 18848844379)转交\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏子淇120天联系情况 (任务ID: 15892328579)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 于睿120天联系情况 (任务ID: 15892328580)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏子淇90天联系情况 (任务ID: 15900770193)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 于睿90天联系情况 (任务ID: 15900770194)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏子淇60天联系情况 (任务ID: 15900777049)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 于睿60天联系情况 (任务ID: 15900777050)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏子淇30天联系情况 (任务ID: 16979825894)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏元盟[已离职]30天联系情况 (任务ID: 16979825895)\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 魏子淇0天处理情况 (任务ID: 18848809419)转交\n",
      "9 : 9d71df55-6d28-41e0-acc1-d76de361e1cb : 邢恒岭0天处理情况 (任务ID: 18848809420)转交\n",
      "11 : f1cc3292-d2d6-40e2-ad9c-2e16811741ab : 霍创业120天联系情况 (任务ID: 17638953320)\n",
      "11 : f1cc3292-d2d6-40e2-ad9c-2e16811741ab : 肖佳文120天联系情况 (任务ID: 17638953321)\n",
      "11 : f1cc3292-d2d6-40e2-ad9c-2e16811741ab : 李子晗120天联系情况 (任务ID: 17992079265)\n",
      "11 : f1cc3292-d2d6-40e2-ad9c-2e16811741ab : 李子晗90天联系情况 (任务ID: 18848478633)转交\n",
      "11 : f1cc3292-d2d6-40e2-ad9c-2e16811741ab : 霍创业90天联系情况 (任务ID: 18848478634)转交\n",
      "13 : c04eebfb-b55a-4663-a2a5-dd277f167a7c : 霍创业120天联系情况 (任务ID: 17638878861)\n",
      "13 : c04eebfb-b55a-4663-a2a5-dd277f167a7c : 肖佳文120天联系情况 (任务ID: 17638878862)\n",
      "13 : c04eebfb-b55a-4663-a2a5-dd277f167a7c : 李子晗120天联系情况 (任务ID: 17992052787)\n",
      "13 : c04eebfb-b55a-4663-a2a5-dd277f167a7c : 李子晗90天联系情况 (任务ID: 18848511040)转交\n",
      "13 : c04eebfb-b55a-4663-a2a5-dd277f167a7c : 霍创业90天联系情况 (任务ID: 18848511041)转交\n",
      "15 : 4b627008-ab7a-4339-baf0-356b83313311 : 肖佳文120天联系情况 (任务ID: 17638899486)\n",
      "15 : 4b627008-ab7a-4339-baf0-356b83313311 : 霍创业120天联系情况 (任务ID: 17638899487)\n",
      "15 : 4b627008-ab7a-4339-baf0-356b83313311 : 李子晗120天联系情况 (任务ID: 17992105002)\n",
      "15 : 4b627008-ab7a-4339-baf0-356b83313311 : 李子晗90天联系情况 (任务ID: 18848487658)转交\n",
      "15 : 4b627008-ab7a-4339-baf0-356b83313311 : 霍创业90天联系情况 (任务ID: 18848487659)转交\n",
      "17 : 226c2e12-2bdf-40de-bfab-33e97d04f841 : 肖佳文120天联系情况 (任务ID: 17638892490)\n",
      "17 : 226c2e12-2bdf-40de-bfab-33e97d04f841 : 霍创业120天联系情况 (任务ID: 17638892491)\n",
      "17 : 226c2e12-2bdf-40de-bfab-33e97d04f841 : 李子晗120天联系情况 (任务ID: 17992100073)\n",
      "17 : 226c2e12-2bdf-40de-bfab-33e97d04f841 : 李子晗90天联系情况 (任务ID: 18848448899)转交\n",
      "17 : 226c2e12-2bdf-40de-bfab-33e97d04f841 : 霍创业90天联系情况 (任务ID: 18848448900)转交\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 霍创业120天联系情况 (任务ID: 15892640145)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 李子晗120天联系情况 (任务ID: 15892640147)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 霍创业90天联系情况 (任务ID: 15902520557)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 李子晗90天联系情况 (任务ID: 15902520558)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 霍创业60天联系情况 (任务ID: 17637400035)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 李子晗60天联系情况 (任务ID: 17637400036)\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 霍创业30天联系情况 (任务ID: 18848686438)转交\n",
      "19 : b1512f52-bf5b-4cb8-b763-017dc86eab77 : 陈致欣30天联系情况 (任务ID: 18848686439)转交\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 霍创业120天联系情况 (任务ID: 15892603463)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 李子晗120天联系情况 (任务ID: 15892603464)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 霍创业90天联系情况 (任务ID: 15902541393)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 李子晗90天联系情况 (任务ID: 15902541394)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 霍创业60天联系情况 (任务ID: 17637384272)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 李子晗60天联系情况 (任务ID: 17637384273)\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 霍创业30天联系情况 (任务ID: 18848654846)转交\n",
      "21 : 627af790-2a58-456c-a1aa-b5f292252efe : 陈致欣30天联系情况 (任务ID: 18848654847)转交\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 霍创业120天联系情况 (任务ID: 15892603653)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 李子晗120天联系情况 (任务ID: 15892603654)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 霍创业90天联系情况 (任务ID: 15902474990)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 李子晗90天联系情况 (任务ID: 15902474991)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 霍创业60天联系情况 (任务ID: 17637381284)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 李子晗60天联系情况 (任务ID: 17637381285)\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 霍创业30天联系情况 (任务ID: 18848694662)转交\n",
      "23 : ebc3f59c-fee3-43e1-b2d3-233bdfbfd4ac : 赵禄军30天联系情况 (任务ID: 18848694663)转交\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 霍创业120天联系情况 (任务ID: 15892603651)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 李子晗120天联系情况 (任务ID: 15892603652)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 霍创业90天联系情况 (任务ID: 15902538314)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 李子晗90天联系情况 (任务ID: 15902538315)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 霍创业60天联系情况 (任务ID: 17637397071)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 李子晗60天联系情况 (任务ID: 17637397072)\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 霍创业30天联系情况 (任务ID: 18848718060)转交\n",
      "25 : 9c1f8993-6fb3-4898-9b6b-30f70ec34032 : 赵禄军30天联系情况 (任务ID: 18848718061)转交\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 霍创业120天联系情况 (任务ID: 15892602505)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 李子晗120天联系情况 (任务ID: 15892602506)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 霍创业90天联系情况 (任务ID: 15902464948)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 李子晗90天联系情况 (任务ID: 15902464949)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 霍创业60天联系情况 (任务ID: 17637372417)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 李子晗60天联系情况 (任务ID: 17637372418)\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 霍创业30天联系情况 (任务ID: 18848712195)转交\n",
      "27 : ae47b212-ea2b-4a15-ad1e-b007bade32f9 : 崔智杰30天联系情况 (任务ID: 18848712196)转交\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 霍创业120天联系情况 (任务ID: 15892338356)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 李子晗120天联系情况 (任务ID: 15892338358)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 霍创业90天联系情况 (任务ID: 15900762921)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 李子晗90天联系情况 (任务ID: 15900762922)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 霍创业60天联系情况 (任务ID: 15900746981)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 李子晗60天联系情况 (任务ID: 15900746982)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 霍创业30天联系情况 (任务ID: 17637552704)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 杜浩30天联系情况 (任务ID: 17637552705)\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 霍创业0天处理情况 (任务ID: 18848820584)转交\n",
      "29 : 35da88f1-aa56-4b0d-8bd8-7bab98708eb1 : 陈博0天处理情况 (任务ID: 18848820585)转交\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 霍创业120天联系情况 (任务ID: 15892353038)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 李子晗120天联系情况 (任务ID: 15892353041)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 霍创业90天联系情况 (任务ID: 15900806064)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 李子晗90天联系情况 (任务ID: 15900806065)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 霍创业60天联系情况 (任务ID: 15900772584)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 李子晗60天联系情况 (任务ID: 15900772585)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 霍创业30天联系情况 (任务ID: 17637573162)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 李壮壮30天联系情况 (任务ID: 17637573163)\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 霍创业0天处理情况 (任务ID: 18848792885)转交\n",
      "31 : af777438-4bde-407c-9f6b-ab278da6a808 : 吴间锐0天处理情况 (任务ID: 18848792886)转交\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 霍创业120天联系情况 (任务ID: 15892280671)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 李子晗120天联系情况 (任务ID: 15892280672)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 霍创业90天联系情况 (任务ID: 15900788476)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 李子晗90天联系情况 (任务ID: 15900788477)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 霍创业60天联系情况 (任务ID: 15900799272)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 李子晗60天联系情况 (任务ID: 15900799273)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 霍创业30天联系情况 (任务ID: 17637556151)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 杨君毅30天联系情况 (任务ID: 17637556152)\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 霍创业0天处理情况 (任务ID: 18848856039)转交\n",
      "33 : 272049a6-ba5e-4d0c-93db-e3036e4ebe3d : 崔智杰0天处理情况 (任务ID: 18848856040)转交\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 霍创业120天联系情况 (任务ID: 15892328630)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 李子晗120天联系情况 (任务ID: 15892328631)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 霍创业90天联系情况 (任务ID: 15900818150)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 李子晗90天联系情况 (任务ID: 15900818151)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 霍创业60天联系情况 (任务ID: 15900812115)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 李子晗60天联系情况 (任务ID: 15900812116)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 霍创业30天联系情况 (任务ID: 17637540633)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 赵旭伟30天联系情况 (任务ID: 17637540634)\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 霍创业0天处理情况 (任务ID: 18848829615)转交\n",
      "35 : 727b46f9-34c2-4c85-8a95-4f3cb1d93e99 : 陈博0天处理情况 (任务ID: 18848829616)转交\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 霍创业120天联系情况 (任务ID: 15892318739)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 李子晗120天联系情况 (任务ID: 15892318740)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 霍创业90天联系情况 (任务ID: 15900771315)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 李子晗90天联系情况 (任务ID: 15900771316)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 霍创业60天联系情况 (任务ID: 15900779720)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 李子晗60天联系情况 (任务ID: 15900779721)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 霍创业30天联系情况 (任务ID: 17637559325)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 陈致欣30天联系情况 (任务ID: 17637559326)\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 霍创业0天处理情况 (任务ID: 18848855124)转交\n",
      "37 : c3aaaf45-2553-4c36-a369-fc68b7696b55 : 崔智杰0天处理情况 (任务ID: 18848855125)转交\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 霍创业120天联系情况 (任务ID: 15892330278)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 李子晗120天联系情况 (任务ID: 15892330279)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 霍创业90天联系情况 (任务ID: 15900757225)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 李子晗90天联系情况 (任务ID: 15900757226)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 霍创业60天联系情况 (任务ID: 15900758958)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 李子晗60天联系情况 (任务ID: 15900758959)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 霍创业30天联系情况 (任务ID: 17637469855)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 韩磊帅30天联系情况 (任务ID: 17637469856)\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 霍创业0天处理情况 (任务ID: 18848852139)转交\n",
      "39 : 24574903-2eb9-4d71-b238-4aafb79df59e : 陈博0天处理情况 (任务ID: 18848852140)转交\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 霍创业120天联系情况 (任务ID: 15892313860)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 李子晗120天联系情况 (任务ID: 15892313861)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 霍创业90天联系情况 (任务ID: 15900688747)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 李子晗90天联系情况 (任务ID: 15900688748)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 霍创业60天联系情况 (任务ID: 15900772343)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 李子晗60天联系情况 (任务ID: 15900772344)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 霍创业30天联系情况 (任务ID: 17637585049)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 吴间锐30天联系情况 (任务ID: 17637585050)\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 霍创业0天处理情况 (任务ID: 18848841214)转交\n",
      "41 : 8d7a37c2-4740-42c9-b4bd-960d2d0643c1 : 吴间锐0天处理情况 (任务ID: 18848841215)转交\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 霍创业120天联系情况 (任务ID: 15892318820)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 李子晗120天联系情况 (任务ID: 15892318821)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 霍创业90天联系情况 (任务ID: 15900797319)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 李子晗90天联系情况 (任务ID: 15900797320)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 霍创业60天联系情况 (任务ID: 15900816162)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 李子晗60天联系情况 (任务ID: 15900816163)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 霍创业30天联系情况 (任务ID: 17637512813)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 赵涛30天联系情况 (任务ID: 17637512814)\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 霍创业0天处理情况 (任务ID: 18848868041)转交\n",
      "43 : 1c48a729-cbad-4c10-8779-09e9e4a7dc66 : 陈博0天处理情况 (任务ID: 18848868042)转交\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 杨挺120天联系情况 (任务ID: 15892512784)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 申晓勇120天联系情况 (任务ID: 15892512785)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 杨挺90天联系情况 (任务ID: 15901918794)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 申晓勇90天联系情况 (任务ID: 15901918795)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 杨挺60天联系情况 (任务ID: 16422183250)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 申晓勇60天联系情况 (任务ID: 16422183251)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 杨挺30天联系情况 (任务ID: 17308603775)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 孟祥宇30天联系情况 (任务ID: 17308603776)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 杨挺0天处理情况 (任务ID: 18847005370)\n",
      "45 : 746b392b-1a39-459d-80c0-de70169e4384 : 武宏超0天处理情况 (任务ID: 18847005371)\n"
     ]
    }
   ],
   "source": [
    "# -*- coding:UTF-8 -*-\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import Select\n",
    "from selenium.webdriver import ActionChains\n",
    "import time\n",
    "import xlrd\n",
    "import xlwt\n",
    "import re\n",
    "from xlutils.copy import copy\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "import datetime\n",
    "import pandas as pd\n",
    "\n",
    "option_chrome = webdriver.ChromeOptions()\n",
    "option_chrome.add_argument('--headless')\n",
    "\n",
    "http='https://login.dingtalk.com/oauth2/challenge.htm?redirect_uri=https%3A%2F%2Ff6car.aliwork.com%2Fdingtalk_sso_call_back%3Fcontinue%3Dhttps%253A%252F%252Ff6car.aliwork.com%252FAPP_UYZ0KG6L0CCNV80GZ66O%252Fadmin%252FFORM-PE866MD1MJMU0WGLYRFLYEN5YN9L1I55Z7ZUK22%252FdataManage&response_type=code&client_id=suite9xvlxxerybljwheo&scope=openid+corpid'\n",
    "#进入链接获取json\n",
    "# driver = webdriver.Chrome(chrome_options=option_chrome)\n",
    "driver = webdriver.Chrome(executable_path=r\"C:\\Users\\admin\\Desktop\\Python脚本\\chromedriver.exe\")\n",
    "driver.maximize_window()\n",
    "driver.implicitly_wait(2)\n",
    "driver.get(http)\n",
    "time.sleep(20)#预设时间\n",
    "driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/div').click() #触发搜索\n",
    "time.sleep(1)\n",
    "driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(\"填充\") #输入实例id\n",
    "time.sleep(1)\n",
    "data = pd.read_excel(r\"C:\\Users\\admin\\Desktop\\新建XLS 工作表 (2).xls\",sheet_name=\"Sheet4\")\n",
    "ABC = 0\n",
    "for i in data['实例ID']:\n",
    "    try:\n",
    "        ABC = ABC + 1\n",
    "        driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/span[2]/span/i').click() #清空\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(i) #输入实例id\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/span[1]/i').click() #点击搜索\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[2]/div[1]/div/div[1]/div[2]/div[2]/table/tbody/tr/td[2]/div/span/i').click() #点击>号\n",
    "        time.sleep(1)\n",
    "        for a in range(1,100):\n",
    "            try:\n",
    "                input = driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[2]/div[1]/div/div[1]/div[2]/div[2]/table/tbody/tr[2]/td/div/div/div/div[1]/div[{}]/p[1]'.format(a)).text\n",
    "                print(ABC,\":\",i,\":\",input)\n",
    "            except:\n",
    "                break\n",
    "    except:\n",
    "        try:\n",
    "            driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/div').click() #触发搜索\n",
    "            time.sleep(1)\n",
    "            driver.find_element_by_xpath('//*[@id=\"dataManageInstance\"]/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(\"填充\") #输入实例id\n",
    "            time.sleep(1)\n",
    "        except:\n",
    "            pass"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# V2 2024/02/21"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding:UTF-8 -*-\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.support.ui import Select\n",
    "from selenium.webdriver import ActionChains\n",
    "import time\n",
    "import xlrd\n",
    "import xlwt\n",
    "import re\n",
    "from xlutils.copy import copy\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "import datetime\n",
    "import pandas as pd\n",
    "\n",
    "option_chrome = webdriver.ChromeOptions()\n",
    "option_chrome.add_argument('--headless')\n",
    "\n",
    "http='https://f6car.aliwork.com/APP_UYZ0KG6L0CCNV80GZ66O/admin/FORM-PE866MD1MJMU0WGLYRFLYEN5YN9L1I55Z7ZUK22/dataManage'\n",
    "#进入链接获取json\n",
    "# driver = webdriver.Chrome(chrome_options=option_chrome)\n",
    "driver = webdriver.Chrome(executable_path=r\"C:\\Users\\admin\\Desktop\\Python脚本\\chromedriver.exe\")\n",
    "driver.maximize_window()\n",
    "driver.implicitly_wait(2)\n",
    "driver.get(http)\n",
    "time.sleep(20)#预设时间\n",
    "driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/div').click() #触发搜索\n",
    "time.sleep(1)\n",
    "driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(\"填充\") #输入实例id\n",
    "time.sleep(1)\n",
    "data = pd.read_excel(r\"C:\\Users\\admin\\Desktop\\新建XLS 工作表 (2).xls\",sheet_name=\"Sheet1\")\n",
    "ABC = 0\n",
    "for i in data['实例ID']:\n",
    "    try:\n",
    "        ABC = ABC + 1\n",
    "        driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/span[2]/span/i').click() #清空\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(i) #输入实例id\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/span[1]/i').click() #点击搜索\n",
    "        time.sleep(1)\n",
    "        driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[2]/div[1]/div/div[1]/div[2]/div[2]/table/tbody/tr[1]/td[2]/div/span/i').click() #点击>号\n",
    "        time.sleep(1)\n",
    "        for a in range(1,100):\n",
    "            try:\n",
    "                input = driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[2]/div[1]/div/div[1]/div[2]/div[2]/table/tbody/tr[2]/td/div/div/div/div[1]/div[{}]/p[1]'.format(a)).text\n",
    "                print(ABC,\":\",i,\":\",input)\n",
    "            except:\n",
    "                break\n",
    "    except:\n",
    "        try:\n",
    "            driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/div').click() #触发搜索\n",
    "            time.sleep(1)\n",
    "            driver.find_element_by_xpath('//*[@id=\"App\"]/section/section/section/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div/div[1]/span/span/span/span[1]/input').send_keys(\"填充\") #输入实例id\n",
    "            time.sleep(1)\n",
    "        except:\n",
    "            pass"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "F6processing",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}