Windows环境

  1. from PIL import Image
  2. from io import BytesIO
  3. from docx import Document
  4. from docx.shared import Inches
  5. from bs4 import BeautifulSoup
  6. from http import cookiejar
  8. import datetime
  9. import glob
  10. import shutil
  11. import os
  12. import re
  13. import requests
  14. import urllib
  16. #路径变量
  17. SOURCEPATH=""
  18. Ops=""
  19. INSPECTION=""
  20. MONITOR=""
  21. SHELVES=""
  23. #地点变量
  24. add = "ADDRESS"
  26. #获取cookie
  27. FILENAME = open("cookie.txt", 'w+')
  28. filename = 'cookie.txt'
  30. ###
  31. #def GetCookie():
  32. #    url = ''
  33. #    file=urllib.request.urlopen(url)
  34. #    #print(file.getcode)
  35. #    message = file.info()
  36. #    CookieStr = str(message)
  37. #    CookieVlue = re.findall(r'Cacti=[a-zA-Z0-9]+',CookieStr)[0]
  38. #    print(CookieVlue,file=FILENAME)
  39. #    print(CookieVlue)
  40. #    url=''
  41. #    headers = {
  42. #        'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36',
  43. #        'Cookie':CookieVlue,
  44. #        'Referer': '',
  45. #        'Host': '',
  46. #    }
  47. #
  48. #    First_Page = requests.get(url,headers=headers)
  49. #    print (First_Page.text)
  50. #    
  51. #GetCookie()
  52. ###
  56. def GetCookie():
  57.     url = 'url'
  58.     file=urllib.request.urlopen(url)
  59.     #print(file.getcode)
  60.     message = file.info()
  61.     CookieStr = str(message)
  62.     CookieVlue = re.findall(r'Cacti=[a-zA-Z0-9]+',CookieStr)[0]
  63.     print(CookieVlue)
  64.     return CookieVlue
  66. #爬取数据
  67. document = Document()
  68. url='url'
  69. headers = {
  70.     'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36',
  71.     'Cookie':'Cacti=fdsafdsaw32342',
  72. }
  75. for i in (2,3,4,5,6,7,8,9,10,11,34,35,36):
  76.     #目标页面
  77.     for n in (1,3,6):
  78.         #目标目录
  79.         payload1 = {'action':'tree','tree_id':'2','leaf_id':'%s'%i,'page':'%d'%n}
  81.         for m in(350,410,528,472,588,110,170,230,290,1085,1116,1142):
  82.             #流量图ID号
  84.             #正则规则
  85.             Regular1 = '(graph\Simage\Sphp.*local_graph_id=%d.*end=\d+)'%m
  86.             print (Regular1)
  87.             First_Page = requests.get(url,headers=headers,params=payload1)
  88.             print (First_Page.url)
  90.             #清洗数据,获取流量图URL
  91.             plt = re.findall(Regular1,First_Page.text)
  92.             print(plt)
  93.             if len(plt):
  94.                 a=(plt[0])
  95.             else:
  96.                 True
  97.             JPG_url = ( '<URL>'+ a)
  98.             print( '<URL>'+ a)
  99.             JPG_url_r = JPG_url.replace(';','&')
  100.             print(JPG_url_r)
  102.             #获取图片二进制数据，并保存成doc
  103.             r = requests.get(JPG_url_r,headers=headers)
  104.             image = Image.open(BytesIO(r.content))
  105.             image.save('image%d.bmp'%i)
  106.     document.add_picture('image%d.bmp'%i, width=Inches(6))
  107. document.save('FRALYCHEN.docx')
  109. #复制巡检报告文件并标记日期
  110. T=datetime.datetime.now()
  112. src_file = '00' + add + 'FRALYCHEN.xls'
  113. dst_file = "2019.{}.{}".format(T.month, T.day) + add + 'FRALYCHEN.xls'
  114. shutil.copyfile(SOURCEPATH + src_file,INSPECTION + dst_file)
  116. MonScfile = '00' + add + 'FRALYCHEN.docx'
  117. MonDtfile = "2019.{}.{}".format(T.month, T.day) + add + 'FRALYCHEN.docx'
  118. shutil.copyfile(SOURCEPATH + MonScfile,MONITOR + MonDtfile)
  120. #删除文件
  121. os.remove(SOURCEPATH + MonScfile)
  122. for infile in glob.glob(os.path.join(SOURCEPATH,'*.bmp')):
  123.     os.remove(infile)
  125. #SVN提交
  126. def SvnCommit():
  127.     os.chdir(Ops)
  128.     os.system('svn cleanup')
  129.     r=os.popen('svn st')
  130.     info=r.readlines()
  131.     print(info)
  133.     for line in info:
  134.         line=line.strip('\n').split('       ')
  135.         one=line[0]
  136.         two=line[1]
  137.         print(two)
  138.         if one == '?':
  139.             os.system('svn add %s' % two)
  140.             os.system('svn commit -m %s' % two)
  141.         elif one == '！':
  142.             os.system('svn del %s' %two)
  143.             os.system('svn commit -m "clear"')
  144. SvnCommit()

‘