manyi/script/spider/yongxing_save_device_pic.py

# -*- coding: utf-8 -*-
# !/usr/bin/env python

import os, sys,time,datetime
import urllib
import requests
from mongoengine import register_connection, PointField, DynamicDocument, StringField,Document
import simplejson as json
import simplejson as json
import base64
import sys
import json
import base64
import urllib2
from urllib import quote_plus
from urllib2 import urlopen
from urllib2 import Request
from urllib2 import URLError
from urllib import urlencode

# from django.db.models.fields import DateTimeField
# 
# 
# os.environ.setdefault("DJANGO_SETTINGS_MODULE", "configs.testing")
# 
# from script.base import init_env
# 
# init_env(interactive = False)

import pyautogui
import qrcode

IS_PY3 = sys.version_info.major == 3
if IS_PY3:
    from urllib.request import urlopen
    from urllib.request import Request
    from urllib.error import URLError
    from urllib.parse import urlencode
    from urllib.parse import quote_plus
else:
    import urllib2
    from urllib import quote_plus
    from urllib2 import urlopen
    from urllib2 import Request
    from urllib2 import URLError
    from urllib import urlencode

# 防止https证书校验不正确
import ssl

# while True:
#     a = pyautogui.getWindowsWithTitle(u'图片查看')
#     time.sleep(1)
    
ssl._create_default_https_context = ssl._create_unverified_context

# 利用百度APP，直接解析截图中的地址，以及端口编号。
API_KEY = 'OVcN78LP40CBEwWk5REF2Hyu'
SECRET_KEY = 'a7luZBdbzjsfU9oE2GD3yPeTBgPty03t'
OCR_URL = "https://aip.baidubce.com/rest/2.0/ocr/v1/accurate_basic"
TOKEN_URL = 'https://aip.baidubce.com/oauth/2.0/token'

register_connection(alias = 'spider',
                    name = 'spider',
                    host = '211.159.224.10',
                    port = 27119,
                    username = 'service',
                    password = 'oOzjoQcO5DyyiN97AY0NpzJ6vztjNpx5',
                    authentication_source = 'admin')

class yongxing(Document):    
    devNo = StringField(default = '')
    phone = StringField(default = '')

    meta = {
        'collection': 'yongxing',
        'db_alias': 'spider',
        'unique_together': {'devNo'}
    }
    
def fetch_token():
    params = {'grant_type': 'client_credentials',
              'client_id': API_KEY,
              'client_secret': SECRET_KEY}
    post_data = urlencode(params)
    if (IS_PY3):
        post_data = post_data.encode('utf-8')
    req = Request(TOKEN_URL, post_data)
    try:
        f = urlopen(req, timeout=5)
        result_str = f.read()
    except URLError as err:
        print(err)
    
    if (IS_PY3):
        result_str = result_str.decode()
        
    result = json.loads(result_str)

    if ('access_token' in result.keys() and 'scope' in result.keys()):
        if not 'brain_all_scope' in result['scope'].split(' '):
            print ('please ensure has check the  ability')
            exit()
        return result['access_token']
    else:
        print ('please overwrite the correct API_KEY and SECRET_KEY')
        exit()
        
request_url = "https://aip.baidubce.com/rest/2.0/ocr/v1/general_basic" # accurate_basic

def read_file(image_path):
    f = None
    try:
        f = open(image_path, 'rb')
        return f.read()
    except:
        print('read image file fail')
        return None
    finally:
        if f:
            f.close()
            
def request(url, data):
    req = Request(url, data.encode('utf-8'))
    has_error = False
    try:
        f = urlopen(req)
        result_str = f.read()
        if (IS_PY3):
            result_str = result_str.decode()
        return result_str
    except  URLError as err:
        print(err)
        
# 二进制方式打开图片文件
# 获取access token
token = fetch_token()
# 拼接通用文字识别高精度url
#
def get_phone(devNo,path):
    try:
        f = open(path, 'rb')
        img = base64.b64encode(f.read())
        if f:
            f.close()
        # 调用文字识别服务
        params = {"image":img}
        request_url1 = request_url + "?access_token=" + token
        headers = {'content-type': 'application/x-www-form-urlencoded'}
        response = requests.post(request_url1, data=params, headers=headers)

        # 解析返回结果
        result_json = response.json()
        
        for words_result in result_json["words_result"]:
            text = words_result["words"]
            
            if u'打' in text and len(text)>7:
                phone = text.replace(u'打',"")
                print u'获取到一条电话！！',devNo,phone
                try:
                    yongxing(devNo,phone).save()
                    break
                except Exception,e:
                    break
        
    except Exception,e:
        print u"解析图片报错了！！！！",e
        
    
for ii in range(0,84217):
    jj = 84217 - ii
    print jj
    qrStr = 'https://a.nblinks.cn/c?d=1000%04d' % jj
    img =qrcode.make(qrStr)
    filePath = "Q:/temp/%s" % jj
    img.save(filePath)
#     time.sleep(0.2)
       
    weixin = pyautogui.getWindowsWithTitle(u'微信')[0]
    if not weixin:
        break
    weixin.activate()
    
    # 点击文件按钮
    pyautogui.click(x=761, y=777)
    time.sleep(0.2)
       
    # 输入二维码文件名称
    pyautogui.click(x=1083, y=928)
    pyautogui.write("%s" % jj)
    time.sleep(0.2)
       
    # 选择该文件,传到编辑框
    with pyautogui.hold('alt'):
        pyautogui.press('o')
    time.sleep(0.1)
    
    # 双击打开二维码
    pyautogui.doubleClick(x=791, y=816)
    time.sleep(1)
    
    # 右键打开
    pyautogui.rightClick(x=983,y=468)
    time.sleep(0.1)
    # 点击识别二维码
    pyautogui.click(x=1084,y=553)
     
    # 等待小程序启动界面出来.如果
    time.sleep(1.7)
    title = pyautogui.getActiveWindowTitle()
    timeCount = 0
    if title != u'富连e充':
        print u" 无法拉起来小程序"
        time.sleep(1800)
    
    # 截图
    file1 = pyautogui.screenshot(region=(758,113,402,765))
    picPath = u'Q:/友商信息/涌鑫/小程序截图/' + '%s.png' % int(time.time()*1000)
    file1.save(picPath)
    get_phone('1000%04d' % jj, picPath)
    
    pyautogui
    #  加按几次esc，用于消掉一些提示
    pyautogui.press('esc')
    time.sleep(0.5)
    
#     # 点击关闭小程序
#     pyautogui.click(x=1135, y=124)
#     time.sleep(0.1)
#     
#     # 关闭截图
#     pyautogui.click(x=983,y=468)
#     time.sleep(0.2)
#     pyautogui.press('esc')
#     time.sleep(0.2)
    
    # 删除截图
#     pyautogui.click(x=791, y=816)
    weixin = pyautogui.getWindowsWithTitle(u'微信')[0]
    weixin.activate()
    
    pyautogui.click(x=1413, y=800)
    time.sleep(0.5)
    
    with pyautogui.hold('ctrl'):
        pyautogui.press('a')
    pyautogui.press('delete')
#     time.sleep(0.1)
# 
# 
# while True:
#     a= auto.GetFocusedControl()
#     time.sleep(2)
#     print a
#     print a.Name
#     time.sleep(2)


# while True:
#     pyautogui.moveTo(987,574)
#     file1 = pyautogui.screenshot(region=(766,220,412,575))
#     file1.save(u'Q:/友商信息/汽车桩/星星充电/站列表截图/%s.png' % int(time.time()*1000))
#     ii += 1
#     print ii
#     pyautogui.scroll(-400)
#     time.sleep(0.2)
    
print 'OK'