def run(self):
"""
执行下单脚本
:return:
"""
if self.isSuperOrder is 1:
U.Logging.info("超级下单模式启动！！！")
self.httpClint.set_cookies(
**{
'__jsl_clearance':
'1542724753.772|0|jEk7Pox1MgRAqWglunFCxiwTcQo%3D',
'CACHE_VARY':
'6e04e60e11bbf84e0cb12445f159bacd-9244d31d67c9dff15c6a27bbbb77f6ac',
'MEMBER_IDENT': '6527184',
'MEMBER_LEVEL_ID': '1',
'UNAME': '15618715583',
'_SID': 'a1d2a1e22a9353eef6d8ca3d0473d237',
'_VMC_UID': 'fd324c0d6731f564aa3f09cf249067cf',
'__jsluid': '1f332e270ca18439f914d862d1f065a1'
})
self.isStock = True
self.loginData = {
"member_lv_id": "1",
"experience": None,
"order_num": 24,
"member_id": "6527184"
}
t = threading.Thread(target=getVcode, args=(self, )) # 验证码线程
t.setDaemon(True)
t.start()
createOrder(self, "912062478dab182484af7324ce5a3561",
"413c771f53a3095d66cd389458ded39f")
else:
login(self)
def get_info():
config = configparser.ConfigParser()
try:
config.read('config.info')
stuId = config['information']['userid']
except:
login()
config.read('config.info')
stuId = config['information']['userid']
data = {
'userId': stuId
}
html = requests.post(url=info_url, data=data).json()
if html['code'] == -1:
print("系统检测到您是第一次登陆或者信息已失效，所以请重新登陆！")
login()
config.read('config.info')
stuId = config['information']['userid']
schoolId = config['information']['schoolId']
return {
'stuId': stuId,
'schoolId': schoolId
}
else:
return print_info(html)
def init_config(self):
if self.login is True:
if AUTO_FILED in self.header and isinstance(self.header, dict):
HEADERS[AUTO_FILED] = self.header.get(AUTO_FILED)
elif self.username and self.password:
LOGIN_DATA['username'] = self.username
LOGIN_DATA['password'] = self.password
else:
if LOGIN_DATA.get('username') == USERNAME and LOGIN_DATA.get('password') == PASSWORD:
raise Exception('Must input password and username')
login()
def calamt(tradedate):
urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)
#登录链接
loginurl = "https://query.99bill.com/report/login.do"
#登录信息
login_data = {"username": "******", "password": "******"}
#搜索链接
searchurl = "https://query.99bill.com/report/query/doQuery.do"
#头文件
header = {
"User-Agent":
"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36"
}
#日期
tradedata = "2019-10-15"
#初始表名
tablestart = 0
totalamt = 0
#初始数据库名
dbs = {
"db1": "ate0101",
"db2": "ate0102",
"db3": "ate0201",
"db4": "ate0202",
"db5": "ate0301",
"db6": "ate0302"
}
#打开会话
ss = requests.session()
login(ss, loginurl, login_data, header)
#循环主体
tablenum = 20
start = 0
for db in dbs:
for j in range(tablenum):
index = "{:0>3d}".format(start + j)
sql_data = {
"ds": dbs[db],
"sql": SpellSql.sumtotalamt(index, tradedate)
}
res = searchamt(ss, searchurl, sql_data, header)
amt = getresult(res)
totalamt = float(totalamt) + float(amt)
#print("表" + str(index) + "中是：" + str(amt) + "总数是:" + str(totalamt))
start = start + tablenum
ss.close()
return totalamt
def regend():
test = input(
"1. Return to main menu\n2. Logout and return to login screen\nOPTION: "
)
if test == "":
print("This field cannot be blank.")
elif test == "1":
from menuUI import mainmenu
mainmenu()
elif test == "2":
from Login import login
login()
else:
print("Error Message: Invalid input... please enter a valid number...")
regend()
def test_setlogin(self):
self.login = login()
self.login.login()
self.a = self.login.login1()
sleep(2)
if self.a == "第一次登陆":
self.project = project()
self.project.project()
self.dow = download()
self.dow.download()
self.DropDown = DropDown()
print(self)
# def test_affiche(self):
self.rpage = Returnpage()
self.taffiche = Affiche()
try:
self.taffiche.affiche()
self.title = self.taffiche.Unread()
except BaseException as e:
self.assertEqual(0, 1, "公告模块,未读测试未通过")
if self.title != '无未读公告':
try:
self.taffiche.Read(self.title)
except BaseException:
self.assertEqual(0, 1, "公告模块，已读测试未通过")
else:
print('无未读公告')
sleep(1)
self.rpage.returnpage()
def run(conf):
email = conf.facebook_login_email
password = conf.facebook_login_password
if email == "" or password == "":
print(
"Your email or password is missing. These must both be in conf.py")
exit()
reader = PostReader(scrollDepth=conf.depth)
debug('logging in')
login(email, password)
posts = []
command = conf.command
if command == "watch-poll":
if conf.post is None and len(conf.groups) == 0:
parser.error(
"--post or --group option must be provided for watch-poll command"
)
return
url = conf.post if not (conf.post is None) else conf.groups[0]
while (True):
debug('reading post')
post_rep = reader.read_post_as(PollPost.PostInFeed, url=url)
if post_rep.is_poll():
debug('post contains poll')
if post_rep.is_open():
debug('post poll is open')
do_watch_poll(conf, reader, url)
elif not (conf.post is None):
posts.append(Post(reader.read_post(conf.post)))
else:
if conf.groups:
for groupId in conf.groups:
posts.extend(
[Post(rep) for rep in reader.read_group_posts(groupId)])
if conf.pages:
for pageName in conf.pages:
posts.extend(
[Post(rep) for rep in reader.read_page_posts(pageName)])
inform_user(encode(posts))
def redirect(res) :
if(res == "Keluar") :
print("Keluar dari program...")
sleep(1)
system("cls")
exit()
elif(res == "Login") :
username = input("Username : "******"Password : "******"cls")
MainMenu(True, user)
elif(res == "Signup") :
signup()
sleep(1)
system("cls")
MainMenu(False)
def login_clk(self):
from Login import login
global username
username = self.ui.Username.text()
password = self.ui.Password.text()
result = login(username, password)
if result == "UNE":
msg = QMessageBox()
msg.setText("This user does not exist.")
msg.exec()
elif result == "WP":
msg = QMessageBox()
msg.setText("Wrong Password")
msg.exec()
elif result == True:
self.hide()
MainWindow.show()
MainWindow.load_info()
MainWindow.table_refresh_clk()
MainWindow.refresh_table_clk()
MainWindow.schedule_table_refresh_clk()
def jumpToSCF(browser,idName,jump,jumPath,needLogin,env='c',username='******',passwd='aaa111'):
for i in range(5):
if jump:
try:
if needLogin:browser=login(username,passwd,env=env,bro=browser)#资金方经办员登陆
except SCENSEE:
pass
browser.get(f'{domainDic[env]}/electronicVoucher/html?sup_menu=navItem3&sub_menu=-electronicVoucher-html&convertId={electVouchIdDic[env]}')
browser,text=waitTo(browser,SCENSEE,way='xpath',name='//*[@id="windows"]/h2',operate='getText')
if '即将跳转' not in text:
print('电子凭证跳转失败: {text}')
goonORquit('恢复后按回车继续，退出输入q：')
continue
try:browser=waitTo(browser,SCENSEE,way='xpath',name='//*[@id="insertDiv"]/div/button[1]',operate='click')#点击确认跳转
except SCEENVE:browser=waitTo(browser,SCENSEE,way='xpath',name='//*[@id="windows"]/div/button[1]',operate='click')#点击确认跳转
browser.get(f'{FSCFdomainDic[env]}/index.html#/{jumPath}')
time.sleep(1)
browser,tenantCode=waitTo(browser,SCENSEE,way='id',name=idName,operate='getAttribute',value='value')
if tenantCode:return browser,tenantCode
else:
needLogin+=1;jump=1
out(f'跳转电子凭证系统失败！第 {needLogin} 次重试……\t\t\t\t')
#Determines which accounts you are following that are not following you back
#and allows you to unfollow them right from the Python Terminal
from Login import login
login = login()
API = login[1]
user_id = login[0]
API.getUsernameInfo(user_id)
API.LastJson
following = []
followers = []
next_max_id = True
while next_max_id:
if next_max_id == True: next_max_id = ''
_ = API.getUserFollowings(user_id, maxid=next_max_id)
following.extend(API.LastJson.get('users', []))
_ = API.getUserFollowers(user_id, maxid=next_max_id)
followers.extend(API.LastJson.get('users', []))
next_max_id = API.LastJson.get('next_max_id', '')
users_following = []
for user in following:
user_info = [user['username'], user['pk']]
users_following.append(user_info)
users_followers = []
for user in followers:
user_info = [user['username'], user['pk']]
def QT(self, event):
login()
def AutoFill(username,passwd,env='k',bankCode='',elecAgree='y',iousAgree='y',renewal='n',reFill='y',oFill=0,pLegalID=0,JBC=0,robot=0,path='',**bro):
if robot:saveFileRobot("开始进件，登录门户")
if not bro:browser=login(username,passwd,env=env,menhuPath=path)
else:browser=bro['bro']
applicateIdDic={'k':'85010','c':'76008','p':'32013','s':'32013'}
if elecAgree=='y':#是否需要签电子协议
flag=5
while flag:
try:
if robot:saveFileRobot("勾选电子协议,立即签约")
browser.find_element_by_id('agreeSign').click()#勾选电子协议
browser.find_element_by_id('signBtn').click()#点击立即签约
time.sleep(1)
if browser.find_element_by_css_selector('body>div.message_mask>div.message>div.message_msg').text=='签约成功':
browser.find_element_by_xpath('/html/body/div[9]/div[2]/div[1]/a').click()#点击关闭弹窗
else:
print('电子协议签约失败：',browser.find_element_by_css_selector('body>div.message_mask>div.message>div.message_msg').text)
out('10秒后继续……\t\t\t')
time.sleep(10)
break
except SCENSEE:
time.sleep(1);flag-=1
continue
# browser=waitTo(browser,SCEECIE,way='id',name='navItem3',operate='click')#点击资金管理
if robot:saveFileRobot("进入资金管理")
browser.get(f'{domainDic[env]}/moneyManagement/index?sup_menu=navItem3&sub_menu=-moneyManagement-index&convertId=&tabCode=&selectId=&tmnId=&tmnCode=&tmnAddress=')#进入资金管理
browser=waitTo(browser,(SCEECIE,SCENSEE),way='id',name=applicateIdDic[env],operate='click')#点击申请管理
time.sleep(2)
if iousAgree=='y':#是否需要签白条协议
try:
if robot:saveFileRobot("签约白条协议")
browser.find_element_by_id('agreeSign').click()#勾选白条协议
browser.find_element_by_id('signBtn').click()#点击立即签约
time.sleep(1)
if browser.find_element_by_css_selector('body>div.message_mask>div.message>div.message_msg').text=='签约成功':
browser.find_element_by_xpath('/html/body/div[6]/div[2]/div[1]/a').click()#点击关闭弹窗
else:
print('白条协议签约失败：',browser.find_element_by_css_selector('body>div.message_mask>div.message>div.message_msg').text)
out('10秒后继续……\t\t\t')
time.sleep(10)
except SCENSEE:pass
time.sleep(1)
try:browser.find_element_by_xpath('/html/body/div[3]/div[3]/div[1]/div[2]/input').click()#点击去确认
except SCENSEE:pass
time.sleep(2)
if renewal=='y':#是否需要资质更新
# if env in ['s','p']:Del_Fill(browser.find_element_by_id('legalPhone'),'18682097559')#修改为于豪的手机号
try:browser.find_element_by_id('bizLicensePhoto').send_keys(bizLicensepath)#营业执照
except SCENSEE:pass
try:browser.find_element_by_id('orgCodePhoto').send_keys(taxRegpath)#组织机构代码证
except SCENSEE:pass
try:browser.find_element_by_id('taxRegCodePhoto').send_keys(legalApath)#税务登记证
except SCENSEE:pass
try:browser.find_element_by_id('openAcctPermitPhoto').send_keys(openAcctpath)#银行开户许可证
except SCENSEE:pass
try:browser.find_element_by_id('legalIdNumTPhoto').send_keys(handIDpath)#法人身份证正面
except SCENSEE:pass
try:browser.find_element_by_id('legalIdNumBPhoto').send_keys(legalBpath)#法人身份证反面
except SCENSEE:pass
try:browser.find_element_by_id('handHeldIDPhoto').send_keys(orgCodepath)#手持身份证正面照
except SCENSEE:pass
time.sleep(2)
try:browser.find_element_by_id('submitButton').click()#点击提交申请
except SCENSEE:pass
time.sleep(2)
#转到大总管页面，如果需要登陆则登陆
browser.get(f'{BBdomainDic[env]}/pbs/page/pbsAuditService/manager.html')
try:
if browser.find_element_by_id('captcha'):
browser=LoginBboss(env=env,bro=browser)
browser.get(f'{BBdomainDic[env]}/pbs/page/pbsAuditService/manager.html')
except SCENSEE:pass
# browser=bbossCheck(username,env=env,op='2',login=False,bro=browser)#开始审核
out('大总管审核中……\t\t\t')
bbCheckData=bbossCheck(username,env=env,op='2',path=path)
if bbCheckData['auditSta']=='审核通过':
out('大总管审核通过……\t\t\t')
else:
print(bbCheckData['auditSta'],bbCheckData['respCode'],bbCheckData['respMsg'])
sys.exit()
browser.get(f'{domainDic[env]}/moneyManagement/applicationManagement?sup_menu=navItem3&sub_menu=-moneyManagement-applicationManagement&convertId={applicateIdDic[env]}')
else:
time.sleep(2)
browser=waitTo(browser,(SCEECIE,SCENSEE),way='id',name='submitButton',operate='click')#点击提交申请
# try:browser.find_element_by_id('submitButton').click()
# except SCENSEE:pass
if reFill=='y':#是否需要重填资料
if robot:saveFileRobot("开始进件")
if referer:
try:refererId=choice(refererIdDic[env])
except IndexError:refererId=''
browser=waitTo(browser,SCENSEE,way='id',name='refereeId',operate='send_keys',value=refererId,timeout=10)#推荐人ID
browser=waitTo(browser,SCENSEE,way='id',name='brtype_combobox_default',operate='click')#点击工商登记类型
browser.find_element_by_css_selector(f'#brtype_combobox_ul>li:nth-child({randint(2,13)})').click()
if oFill:overFill(browser,'registAddress',fake.address(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('registAddress'),fake.address())#登记注册地址
if oFill:overFill(browser,'grantApplicationInfoDTO.takings',str(randint(100,1000)),way='name',comId='refereeId')
else:Del_Fill(browser.find_element_by_name('grantApplicationInfoDTO.takings'),randint(100,1000))#年营业收入
if oFill:overFill(browser,'coAcctName',fake.name(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('coAcctName'),fake.name())#电信返佣银行账户名
if oFill:overFill(browser,'coBankName','招商银行',comId='refereeId')
else:Del_Fill(browser.find_element_by_id('coBankName'),'招商银行')# 电信返佣银行账户开户行
Del_Fill(browser.find_element_by_id('coAcctNo'),bankCode)# 电信返佣银行账户账号
if oFill:overFill(browser,'paperadd',fake.address(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('paperadd'),fake.address())#身份证证件地址
Del_Fill(browser.find_element_by_id('bankCode'),bankCode)#银行卡号
browser.find_element_by_id('educsign_combobox_default').click()#最高学历
browser.find_element_by_css_selector(f'#educsign_combobox_ul>li:nth-child({randint(2,11)})').click()
browser.find_element_by_id('degreesign_combobox_default').click()#最高学位
browser.find_element_by_css_selector(f'#degreesign_combobox_ul>li:nth-child({randint(2,7)})').click()
Del_Fill(browser.find_element_by_id('bindingCardPhone'),LXMTel)#银行卡预留手机号
Del_Fill(browser.find_element_by_id('eMail'),fake.email())
if oFill:overFill(browser,'address',fake.address(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('address'),fake.address())#详细地址
browser.find_element_by_id('addrType_combobox_default').click()#居住性质
browser.find_element_by_css_selector(f'#addrType_combobox_ul>li:nth-child({randint(2,7)})').click()
if oFill:overFill(browser,'yearincoStr',str(randint(50,100)),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('yearincoStr'),randint(50,100))#年收入
browser.find_element_by_id('marrsign_combobox_default').click()#婚姻状况
if pLegalID:
browser.find_element_by_css_selector('#marrsign_combobox_ul > li:nth-child(3)').click()#已婚
browser=waitTo(browser,(SCEECIE,SCEENVE),way='id',name='familycustnameP',operate='send_keys',value=fake.name())#配偶姓名
Del_Fill(browser.find_element_by_id('paperidP'),pLegalID)#配偶证件号码
Del_Fill(browser.find_element_by_id('mobileP'),fake.phone_number())#配偶手机号码
if oFill:overFill(browser,'workcorpP',fake.company(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('workcorpP'),fake.company())#配偶工作单位
if oFill:overFill(browser,'addrP',fake.address(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('addrP'),fake.address())#配偶地址
else:
browser.find_element_by_css_selector('#marrsign_combobox_ul>li:nth-child(2)').click()#未婚
#法人单位信息
if oFill:overFill(browser,'workcorp',fake.company(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('workcorp'),fake.company())#工作单位
if oFill:overFill(browser,'corpaddr',fake.address(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('corpaddr'),fake.address())#单位地址
if oFill:overFill(browser,'companyRelationName',fake.name(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('companyRelationName'),fake.name())#单位联系人
Del_Fill(browser.find_element_by_id('companyRelationMobile'),fake.phone_number())#单位联系人电话
# Del_Fill(browser.find_element_by_id('companyRelationPosition'),translate(fake.job().split(',')[0]))
if oFill:overFill(browser,'companyRelationPosition',fake.job(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('companyRelationPosition'),fake.job())
#法人关系人信息
if oFill:overFill(browser,'name',fake.name(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('name'),fake.name())
#1#与客户关系
browser.find_element_by_id('relaSign_combobox_default').click()
browser.find_element_by_css_selector(f'#relaSign_combobox_ul>li:nth-child({randint(2,22)})').click()
#1#关系人-证件类型
Del_Fill(browser.find_element_by_id('certificatenbr'),fake.ssn())#关系人-证件号码
if oFill:overFill(browser,'workUnit',fake.company(),comId='refereeId')
else:Del_Fill(browser.find_element_by_id('workUnit'),fake.company())#关系人-工作单位
if oFill:overFill(browser,'grantApplicationInfoDTO.shipList[0].address',fake.address().split()[0],way='name',comId='refereeId')
else:Del_Fill(browser.find_element_by_name('grantApplicationInfoDTO.shipList[0].address'),fake.address().split()[0])#关系人-联系地址
Del_Fill(browser.find_element_by_id('shipList-mobile'),'18834465333')#关系人-手机
browser.find_element_by_id('save_btn').click()#点击保存
time.sleep(1)
for i in range(10):
if i==9:sys.exit()
if '成功' in browser.find_element_by_class_name('message_msg').text:
browser.find_element_by_class_name('ui-dialog-close').click()#点击关闭弹窗
break
else:
print('保存失败：',browser.find_element_by_class_name('message_msg').text)
out('10秒后继续……\t\t\t')
time.sleep(10)
browser.find_element_by_class_name('ui-dialog-close').click()#点击关闭弹窗
browser.find_element_by_id('save_btn').click()#点击保存
time.sleep(2)
else:
time.sleep(1)
if robot:saveFileRobot("进件信息填写完成")
browser=waitTo(browser,SCEECIE,way='id',name='nextStepBtn',operate='click')#点击下一步
# out('10秒后继续……\t\t\t')
# time.sleep(10)
time.sleep(1)
# if not JBC:
# browser=waitTo(browser,SCEECIE,way='css',name='#goModal>div>div>div.modal-footer.taa>button',operate='click')#点击前往验证
# while True:
# browser=waitTo(browser,(SCEECIE,SCEENVE,SCEWDE),way='id',name='getCode',operate='click')#点击获取验证码
# browser,text=waitTo(browser,SCEECIE,way='id',name='getCode',operate='getText')#点击获取验证码
# if re.search(r'\d+',text):break
# browser.find_element_by_id('binding_code').send_keys('123456')#输入验证码
# browser.find_element_by_xpath('//*[@id="myModal"]/div/div/div[3]/button').click()#点击确定
time.sleep(1)
browser=waitTo(browser,(SCENSEE,SCEECIE),way='xpath',name='//*[@id="authForm"]/div[3]/input[2]',operate='click')#图片页面点击下一步
time.sleep(1)
browser=waitTo(browser,SCEECIE,way='css',name='#face_center01>div>input',operate='click')#点击身份核验
browser=waitTo(browser,SCEECIE,way='id',name='checkFaceOcr',operate='click')#点击获取核验结果
while True:#征信授权勾选同意
try:
browser.find_element_by_id('agreeSign').click()#点击勾选
break
except SCEECIE:
time.sleep(1)
continue
except SCENSEE:
break
browser.find_element_by_id('agree').click()#点击确定
browser=waitTo(browser,SCEECIE,way='id',name='signBtn',operate='click')#确定提交
browser=waitTo(browser,SCEECIE,way='id',name='submitButton',operate='click')#确定提交
browser,result=waitTo(browser,SCENSEE,way='css',name='.auditing',operate='getText')#获取结果 待授信
return browser,result
AutoBUY = 'on'
AutoSELL = 'on'
UNDERVALUED_USER_ALERT = 'on'
"""----------------------------------------"""
driver = webdriver.Chrome(ChromeDriverManager().install())
os.system('find . | grep -E "(__pycache__|\.pyc|\.pyo$)" | xargs rm -rf')
print('░ WELCOME TO BITCLOUT BOT!')
EMAIL_ADDITION = input(
"░ What is your email address for alerts from BITCLOUT BOT?: ")
time.sleep(1)
login(driver, time)
if AutoLike == 'on':
# TODO: Run like function
like(driver, time)
else:
print("░ AutoLike IS NOT ON.. SKIPPING...")
pass
if AutoComment == 'on':
# TODO: Run comment function
comment(driver)
else:
print("░ AutoComment IS NOT ON.. SKIPPING...")
pass
from colorama import Back, Fore, Style
from Welcomepage import *
from Login import accounts, login
from Menu import *
################
# Login Page #
################
login_status = True
print_welcome_page()
while not login():
print("Access Denied !")
print_welcome_page()
#############
# Menu Page #
#############
while login_status == True:
print_menu()
navigation = input("What would you like to do today? : ").upper()
if navigation == "P1":
P1()
elif navigation == "P2":
for url in url_list:
weibo_text = self.get_weibo(url)
f.write(weibo_text + '\n')
f.flush()
count += 1
print(count)
if self.page_num > 1:
for page in range(2, self.page_num + 1):
url_list = self.get_weibo_url(id, page)
for url in url_list:
try:
weibo_text = self.get_weibo(url)
f.write(weibo_text + '\n')
f.flush()
except:
pass
count += 1
print(count)
f.close()
if __name__ == "__main__":
if os.path.exists(r'./cookies.txt'):
with open(r'./cookies.txt', 'r') as f:
cookie = f.read()
else:
cookie = login()
weibo = WeiBo(cookie, ['2386568184', '2386774894', '1264046551'])
weibo.start()
from selenium import webdriver
from selenium.webdriver import ActionChains
from selenium.webdriver.common.by import By
from time import sleep
# options = webdriver.ChromeOptions()
# options.add_argument(r"user-data-dir=C:\Users\Dixon\AppData\Local\Google\Chrome\User Data")
#C:\Users\ASUS\AppData\Local\Google\Chrome\User Data
#browser = webdriver.Chrome()
from Login import login
from windows import get_new_window
#http://home.ydyksoft.cn:8088/webhis/
#http://192.168.0.4:8080/webhis
driver = webdriver.Chrome()
driver.get('http://home.ydyksoft.cn:8088/webhis/')
login(driver)
get_new_window(driver)
driver.find_element_by_link_text('挂号管理').click()
driver.find_element_by_link_text('挂号管理').click()
sleep(2)
driver.find_element_by_link_text('挂号维护').click()
get_new_window(driver)
sleep(2)
ghwh = driver.switch_to.frame(1)
#driver.switch_to.frame('baidu)
ghwh_mzh = driver.find_element_by_id('CMZH')
actions = ActionChains(driver)
actions.move_to_element(ghwh_mzh)
actions.double_click()
actions.perform()
sleep(3)
driver.switch_to.default_content()
def muti_control(id_list):
pool = ThreadPool(7)
proxypool = ProxyPool(redis_host, redis_port)
#模拟登陆
s = requests.Session()
is_login = 0
while not is_login:
ip, timestamp = get_ip_from_proxiesPool()
is_login = login(s, ip)
#time.sleep(10)
print('suss login')
proxies = {
'http': 'http://{}'.format(ip),
'https': 'https://{}'.format(ip)
}
requests.post(
url=
'http://www.pss-system.gov.cn/sipopublicsearch/patentsearch/pageIsUesd-pageUsed.shtml',
proxies=proxies,
cookies=s.cookies)
print('tou ming zhuang ')
while True:
#用于记录ip使用次数
#datetime_info = get_data_from_datetime(threads, sub_duty[0], sub_duty[-1])
datetime_info = get_data_from_datetime(10, id_list)
if len(datetime_info) == 0:
print(time.asctime())
break
else:
task = [list(t) for t in datetime_info]
for i in task:
i.append(s.cookies)
i.append(ip)
result = pool.map(spider, task)
#根据返回的结果判断是否需要换Ip、cookies
needIp = 0
needCookies = 0
for r in result:
#id = r[0]
#status = r[1]
#content = r[2]
if r[1] == 1:
#正常的数据，写入数据库
write_db(r[0], r[2])
elif r[1] == 2:
#cookies,
print(r[0], 'cookies wrong')
needCookies = 1
needIp = 1
elif r[1] == 3:
#ip过期
print(r[0], 'ip wrong')
needIp = 1
#根据结果 更新session的状态
if needCookies:
is_login = 0
while not is_login:
print('login again...')
ip, timestamp = get_ip_from_proxiesPool()
is_login = login(s, ip)
requests.post(
url=
'http://www.pss-system.gov.cn/sipopublicsearch/patentsearch/pageIsUesd-pageUsed.shtml',
proxies=proxies,
cookies=s.cookies)
print('tou ming zhuang ')
proxypool.push_ip(ip, timestamp)
elif needIp:
while True:
ip, timestamp = get_ip_from_proxiesPool()
print('renew ip ...')
proxies = {
'http': 'http://{}'.format(ip),
'https': 'https://{}'.format(ip)
}
try:
rsp_ipTest = requests.get(
'http://www.pss-system.gov.cn/sipopublicsearch/portal/uiIndex.shtml',
proxies=proxies,
timeout=10)
if rsp_ipTest.status_code == 200 and '访问受限' not in rsp_ipTest.text:
try:
requests.post(
url=
'http://www.pss-system.gov.cn/sipopublicsearch/patentsearch/pageIsUesd-pageUsed.shtml',
proxies=proxies,
cookies=s.cookies,
timeout=7)
print('tou ming zhuang ')
break
except:
pass
except:
pass
def main(**bro):
try:
global newpassword,paypassword,manHead,liaHead,browserFund
if args.getRegUrl:
longUrl=f"{domain}/bestpay/register?{encryptRegData(company.loginID,time.strftime('%Y%m%d%H%M%S',time.localtime()),platCode)}"
shortUrl=getShortUrl(longUrl)
if shortUrl:
print(shortUrl)
else:
print(longUrl)
print()
sys.exit()
if bro:
browser=bro['bro']
browser.get(f"{domain}/bestpay/register?{encryptRegData(company.loginID,time.strftime('%Y%m%d%H%M%S',time.localtime()),platCode,company.email)}")
else:
browser=openurl(f"{domain}/bestpay/register?{encryptRegData(company.loginID,time.strftime('%Y%m%d%H%M%S',time.localtime()),platCode,company.email)}")
if args.mode=='b':
print('-'*50,'注册:',gradeDic[args.grade],'-'*50)
if args.robot:saveFileRobot(f"{'-'*50} 注册:{gradeDic[args.grade]} {'-'*50}")
print(f"PC {envDict[args.env]} {time.strftime('%Y-%m-%d %X',time.localtime())}")
if args.robot:saveFileRobot(f"PC {envDict[args.env]} {time.strftime('%Y-%m-%d %X',time.localtime())}")
if saveToMysql:mysqlOpt(f"""INSERT INTO registerinfo (CreateDate,Environmental,Grade,loginID,RegistTypes) VALUES ("{time.strftime('%Y-%m-%d %X',time.localtime())}","PC {envDict[args.env]}","{gradeDic[args.grade]}","{company.loginID}","{regTypeDic[args.type]}")""")
else:save_file(f'登录号： {company.loginID}\n{regTypeDic[args.type]}')
print(f'登录号： {company.loginID}\n{regTypeDic[args.type]}')
if args.robot:saveFileRobot(f'登录号： {company.loginID}\n{regTypeDic[args.type]}')
# if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET RegistTypes='{regTypeDic[args.type]}' WHERE LoginID='{company.loginID}'")
# else:save_file(regTypeDic[args.type])
# print(regTypeDic[args.type])
if args.type=='1':browser=fillbankinfor(postpic0(beneficiaryInfo(legalinformation(Putong(browser)))),0)
elif args.type=='2':browser=fillbankinfor(postpic1(beneficiaryInfo(legalinformation(Sanzhengheyi(browser)))),1)
elif args.type=='3':browser=fillbankinfor(postpic2(beneficiaryInfo(legalinformation(Getigongshanghu(browser)))),2)
elif args.type=='4':browser=fillbankinfor(postpic3(Geti(browser)),3)
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET IsReview=0,IsPreCredit=0,IsApplicate=0 WHERE LoginID='{company.loginID}'")
if args.noCheck:#小CEO批量模式
# browser.quit()
return '提交完成',browser
if args.robot:saveFileRobot('已提交开户申请，下一步大总管审核……')
# browser=bbossCheck(company.loginID,env=args.env,bro=browser)
out('大总管审核中……\t\t\t')
auditSta=3 if args.auditSta else 2
bbCheckData=bbossCheck(company.loginID,env=args.env,op='1',auditSta=auditSta,path=args.path)
if bbCheckData['auditSta']=='审核通过':
out('大总管审核通过……\t\t\t')
else:
print('大总管',bbCheckData['auditSta'],bbCheckData['respCode'],bbCheckData['respMsg'])
sys.exit()
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET IsReview=1 WHERE LoginID='{company.loginID}'")
if args.robot:saveFileRobot('大总管已审核，下一步获取初始密码……')
if args.env in ['k','c']:
# browser,om_cookie=loginOM(env=args.env,bro=browser)
out('正在获取初始密码...')
password=getOMpassword(company.loginID,company.legalTel,env=args.env,path=args.path)#获取初始密码
out('正在获取商户号...')
merchantNum=getMerchantNum(company.loginID,env=args.env,path=args.path)#获取商户号
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET MerchantNum='{merchantNum}' WHERE LoginID='{company.loginID}'")
elif args.env in ['p','s']:
if args.robot:
sendInput('请发送初始密码，格式：初始密码 xxxx')
password=getInput('初始密码')
else:
password=input('输入初始密码后按回车，退出请按"q"：')
if password=='q':
browser.quit()
sys.exit(0)
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET InitialPWD='{password}' WHERE LoginID='{company.loginID}'")
else:save_file(f'初始密码： {password}')
print(f'初始密码： {password}\t\t\t\t')
if args.robot:saveFileRobot(f'初始密码： {password}')
if noPic or args.env=='k':#H5没有开发环境
# if 1==1:
browser=changePassword(company.loginID,password,newpassword,paypassword,env=args.env,bro=browser)
else:#不禁止加载图片则可以去H5页面修改密码
browser1=loginH5(username=company.loginID,passwd=password,env=args.env,menhuPath=args.path)#初始密码登陆
browser1,newpassword=changePasswordH5(loginId=company.loginID,password=password,newpassword=newpassword,paypassword=paypassword,env=args.env,menhuPath=args.path,bro=browser1)
browser1.quit()
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET Password='******',Payword='{paypassword}' WHERE LoginID='{company.loginID}'")
else:save_file(f'登陆密码： {newpassword}\t支付密码： {paypassword}')
print(f'登陆密码： {newpassword}\t支付密码： {paypassword}')
if args.robot:saveFileRobot(f'登陆密码： {newpassword}\t支付密码： {paypassword}')
result='密码修改完成！'
creditTypeDic={'1':'佣金','2':'采购','3':'小CEO',}
if args.mode=='a':
if args.precredit=='y':
creditHead=0
for creditType in args.creditType:
out(f'正在导入预授信，类型 {creditTypeDic[creditType]}...')
save_excel(company.BLRN,company.companyName,creditType,args.daddy)
creditResult,creditHead=uploadExcel(idlist=[company.BLRN],env=args.env,head=creditHead,menhuPath=args.path)
addWhiteList(args.env,creditHead,company,args.daddy,args.robot)
if not creditResult:#预授信
if args.robot:
print(f'导入预授信失败，类型 {creditTypeDic[creditType]}')
sys.exit()
else:
s=input(f'导入预授信失败，类型 {creditTypeDic[creditType]} ,请手动完成后按回车，退出请按"q"：')
if s=='q':
browser.quit()
sys.exit(0)
else:
if args.robot:
sendInput('请手动导入预授信后发送 已完成预授信')
getInput('已完成预授信')
else:
s=input('请手动完成预授信后按回车，退出请按"q"：')
if s=='q':
browser.quit()
sys.exit(0)
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET IsPreCredit=1 WHERE LoginID='{company.loginID}'")
else:save_file('已完成预授信')
print('已完成预授信\t\t')
if args.robot:saveFileRobot('已完成预授信\t\t')
if args.all=='y':
JBC=True if args.daddy=='2' else False
browser,result=AutoFill(company.loginID,newpassword,env=args.env,bankCode=company.bankCode,oFill=args.overfill,pLegalID=company.getPlegalID(company.legalID),JBC=JBC,robot=args.robot,path=args.path,bro=login(company.loginID,newpassword,env=args.env,menhuPath=args.path,bro=browser))
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET IsApplicate=1 WHERE LoginID='{company.loginID}'")
else:save_file(f"完成！ {time.strftime('%Y-%m-%d %X',time.localtime())}")
browser.quit()
return f'{result}\t\t\t\t'
elif args.mode=='b':
browser=login(username=company.loginID,passwd=newpassword,env=args.env,menhuPath=args.path,bro=browser)#改完密码后登陆
browser,initialPWD=addOperator(opLoginID=company.opLoginID,env=args.env,newRole=1,bro=browser)#新增操作员
if saveToMysql:mysqlOpt(f"""INSERT INTO registerinfo (CreateDate,Environmental,Grade,loginID,RegistTypes,InitialPWD) VALUES ("{time.strftime('%Y-%m-%d %X',time.localtime())}","PC {envDict[args.env]}","{gradeDic[args.grade]}","{company.opLoginID}","操作员","{initialPWD}")""")
else:save_file(f'操作员登录号： {company.opLoginID}')
print(f'操作员登录号： {company.opLoginID}\t初始密码：{initialPWD}')
if args.robot:saveFileRobot(f'操作员登录号： {company.opLoginID}\t初始密码：{initialPWD}')
if noPic or args.env=='k':#H5没有开发环境
browser=changePassword(company.opLoginID,initialPWD,newpassword,paypassword,env=args.env,bro=browser)
else:#不禁止加载图片则可以去H5页面修改密码
# browser.quit()
browser1=loginH5(username=company.opLoginID,passwd=initialPWD,env=args.env,menhuPath=args.path)#初始密码登陆
browser1,newpassword=changePasswordH5(loginId=company.opLoginID,password=initialPWD,newpassword=newpassword,paypassword=paypassword,env=args.env,menhuPath=args.path,bro=browser1)
browser1.quit()
if saveToMysql:mysqlOpt(f"UPDATE registerinfo SET Password='******',Payword='{paypassword}' WHERE LoginID='{company.opLoginID}'")
else:save_file(f'操作员登陆密码： {newpassword}\t操作员支付密码： {paypassword}')
print(f'操作员登陆密码： {newpassword}\t操作员支付密码： {paypassword}')
if args.robot:saveFileRobot(f'操作员登陆密码： {newpassword}\t操作员支付密码： {paypassword}')
#电子凭证授信
company.cusType='CORE' if args.grade=='1' else 'CUSTOMER'
browser.maximize_window()
browser,result,manHead,liaHead=AutoFillElect(company=company,renewal='n',reFill='y',passwd=newpassword,bro=browser)
print(f'{result}\t\t\t\t')
if args.robot:saveFileRobot(result)
# 翼融平台客户录入
browser.find_element_by_id('login').click()#登出
if browserFund:
browserFund=entryCustInfo(company=company,jump=0,needLogin=0,bro=browserFund)#换资金方经办员录入客户信息
else:
browserFund=entryCustInfo(company=company,jump=1,needLogin=1)#换资金方经办员录入客户信息
print('翼融平台客户录入成功！\t\t\t\t\t\n')
if args.robot:saveFileRobot('翼融平台客户录入成功！')
return browser,browserFund
except Exception as err:
reason=getErrReason(browser)
if not reason:reason=err
print('开户失败！原因：',reason)
sys.exit()
import time
import json
import math
from multiprocessing import Pool as ThreadPool
import random
from DataPersistence import DataPesistence
import threading
import asyncio
# 一个用来存放已经爬取过的token的集合
old_user_packet = set()
# 待爬取的队列， 用来存放未使用的token
new_user_packge = set()
# login()
requests = login()
# def get_first_person():
person_headers = {
'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
'Accept-Encoding': 'gzip, deflate, sdch, br',
'Accept-Language': 'zh-CN,zh;q=0.8',
'Cache-Control': 'max-age=0',
'Connection': 'keep-alive',
'Host': 'www.zhihu.com',
'Referer': 'https://www.zhihu.com/',
'Upgrade-Insecure-Requests': '1',
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36',
}
def main():
login()
headers = {
'Accept':
'application/json, text/plain, */*',
'Content-Type':
'application/x-www-form-urlencoded',
'DNT':
'1',
'Origin':
'https://message.bilibili.com',
'Referer':
'https://message.bilibili.com/',
'User-Agent':
'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36'
}
sess, csrf = login()
def msg_send(id, msg: str):
data = {
'msg[sender_uid]': '106592867',
'msg[receiver_id]': str(id),
'msg[receiver_type]': '1',
'msg[msg_type]': '1',
'msg[msg_status]': '0',
'msg[content]': json.dumps({'content': msg}, ensure_ascii=False),
'msg[timestamp]': int(time.time()),
'msg[dev_id]': '',
'build': '0',
'mobi_app': 'web',
'csrf_token': csrf
continue
else:
print('新增操作员失败！')
os.system('pause')
time.sleep(3)
def getParseAddOperator():
parser=argparse.ArgumentParser(description='程序功能：\n 新增操作员',formatter_class=argparse.RawTextHelpFormatter)
parser.add_argument('-e',dest='env',help="运行环境（默认 c）：\n k: 开发(46)环境\n c: 测试环境\n p: 准生产环境\n s: 生产环境",required=False,default='c',choices=['k','c','p','s'])
parser.add_argument("-u",dest='username',help="登录号",required=True)
parser.add_argument("-p",dest='password',help="登陆密码（默认 aaa111）",required=False,default='aaa111')
parser.add_argument("-r",dest='newRole',help="是否需要新增角色（默认 1）：\n 0: 否\n 1: 是",required=False,default='1',choices=[0,1],type=int)
args=parser.parse_args()
return args
if __name__ == '__main__':
args=getParseAddOperator()
# args.env=args.env if args.env else 'c'
# args.password=args.password if args.password else 'aaa111'
# args.newRole=int(args.newRole) if args.newRole else 1
browser=login(username=args.username,passwd=args.password,env=args.env)
opLoginID=f'{args.username}b'
browser,initialPWD=addOperator(opLoginID=opLoginID,env=args.env,newRole=args.newRole,bro=browser)
print(f'操作员登录号： {opLoginID}\t初始密码：{initialPWD}')
newpassword='******';paypassword='******'
if args.env=='k':#H5没有开发环境
browser=changePassword(opLoginID,initialPWD,newpassword,paypassword,env=args.env,bro=browser)
else:#不禁止加载图片则可以去H5页面修改密码
browser=loginH5(username=opLoginID,passwd=initialPWD,env=args.env,bro=browser)#初始密码登陆
browser,newpassword=changePasswordH5(loginId=opLoginID,password=initialPWD,newpassword=newpassword,paypassword=paypassword,env=args.env,bro=browser)
print(f'操作员登陆密码： {newpassword}\t操作员支付密码： {paypassword}')
from Frequency_Distribution import freq_distribution
from Login import login
from Association_UserInput import association_userInput
from Registration import registration
from Menu import menu
conn = sqlite3.connect('LeVinEmployee.db')
#-------------------------------------------Beginning of Code---------------------------------------------
print("\n===============================================================================")
print(" WELCOME TO LE VIN COUPE")
print(" Where wine and quality engineering collide!")
print("===============================================================================")
login()
active = True
while active:
menu()
while True:
menu_choice = input("\nPlease select an option from the following (enter the letter): ").lower().strip()
if menu_choice == "a" or menu_choice == "b" or menu_choice == "c" or menu_choice == "d" or menu_choice == "e":
break
else:
print("\nYou must select only one menu choice from above by typing the letter. Please try again.")
if menu_choice == "a":
registration()
if menu_choice == "b":
def AutoFillElect(company, renewal='n', reFill='y', passwd='aaa111', **bro):
if not bro: browser = login(company.loginID, passwd, env=company.env)
else: browser = bro['bro']
applicateIdDic = {'k': '85010', 'c': '125007', 'p': '76008', 's': '32013'}
eleIdDic = {'k': '85010', 'c': '110007', 'p': '76008', 's': '32013'}
browser.get(
f'{domainDic[company.env]}/electronicVoucher/html?sup_menu=navItem3&sub_menu=-electronicVoucher-html&convertId={eleIdDic[company.env]}'
) #进入电子凭证跳转页面
time.sleep(1)
try:
browser.find_element_by_css_selector(
'#addInfo > input').click() #点击去确认
except SCENSEE:
pass
time.sleep(2)
if renewal == 'y': #是否需要资质更新
# if env in ['s','p']:Del_Fill(browser.find_element_by_id('legalPhone'),'18682097559')#修改为于豪的手机号
try:
browser.find_element_by_id('bizLicensePhoto').send_keys(
bizLicensepath) #营业执照
except SCENSEE:
pass
try:
browser.find_element_by_id('orgCodePhoto').send_keys(
taxRegpath) #组织机构代码证
except SCENSEE:
pass
try:
browser.find_element_by_id('taxRegCodePhoto').send_keys(
legalApath) #税务登记证
except SCENSEE:
pass
try:
browser.find_element_by_id('openAcctPermitPhoto').send_keys(
openAcctpath) #银行开户许可证
except SCENSEE:
pass
try:
browser.find_element_by_id('legalIdNumTPhoto').send_keys(
handIDpath) #法人身份证正面
except SCENSEE:
pass
try:
browser.find_element_by_id('legalIdNumBPhoto').send_keys(
legalBpath) #法人身份证反面
except SCENSEE:
pass
try:
browser.find_element_by_id('handHeldIDPhoto').send_keys(
orgCodepath) #手持身份证正面照
except SCENSEE:
pass
time.sleep(2)
try:
browser.find_element_by_id('submitButton').click() #点击提交申请
except SCENSEE:
pass
time.sleep(2)
#转到大总管页面，如果需要登陆则登陆
browser.get(
f'{BBdomainDic[company.env]}/pbs/page/pbsAuditService/manager.html'
)
try:
if browser.find_element_by_id('captcha'):
browser = LoginBboss(env=company.env, bro=browser)
browser.get(
f'{BBdomainDic[company.env]}/pbs/page/pbsAuditService/manager.html'
)
except SCENSEE:
pass
out('大总管审核中……\t\t\t')
bbCheckData = bbossCheck(company.loginID, env=company.env, op='2')
if bbCheckData['auditSta'] == '审核通过':
out('大总管审核通过……\t\t\t')
else:
print(bbCheckData['auditSta'], bbCheckData['respCode'],
bbCheckData['respMsg'])
sys.exit()
# browser=bbossCheck(company.loginID,env=company.env,op='2',login=False,bro=browser)#开始审核
browser.get(
f'{domainDic[company.env]}/electronicVoucher/html?sup_menu=navItem3&sub_menu=-electronicVoucher-html&convertId={applicateIdDic[company.env]}'
)
else:
browser = waitTo(browser,
SCENSEE,
way='id',
name='submitButton',
operate='click')
if reFill == 'y': #是否需要重填资料
# 开始进件
Del_Fill(browser.find_element_by_id('registeredCapital'),
company.regCapital) #注册资金
browser.find_element_by_id(
'enterpriseType_combobox_default').click() #点击公司类型
browser.find_element_by_css_selector(
f'#enterpriseType_combobox_ul > li:nth-child({randint(2,11)})'
).click()
browser.find_element_by_id(
'enterpriseNature_combobox_default').click() #点击企业性质
browser.find_element_by_css_selector(
f'#enterpriseNature_combobox_ul > li:nth-child({randint(2,13)})'
).click()
Del_Fill(browser.find_element_by_id('enterpriseScale'),
randint(500, 10000)) #员工人数
Del_Fill(browser.find_element_by_id('registrationAuthority'),
f'{company.fake.city()}工商局') #登记机关
Del_Fill(browser.find_element_by_id('businessScope'), company.scope)
Del_Fill(browser.find_element_by_id('nationalTaxNo'),
company.taxRegCode)
Del_Fill(browser.find_element_by_id('tel'), company.legalTel)
Del_Fill(browser.find_element_by_id('fax'), '020689745')
Del_Fill(browser.find_element_by_id('email'), company.email)
Del_Fill(browser.find_element_by_id('developingProcess'), '测试发展过程')
Del_Fill(browser.find_element_by_id('managementStructure'), '测试管理结构')
browser.find_element_by_id(
'busiPlacesNature_combobox_default').click() #点击经营场所性质
browser.find_element_by_css_selector(
'#busiPlacesNature_combobox_ul > li:nth-child(2)').click()
Del_Fill(browser.find_element_by_id('busiPlacesArea'), '100.00')
Del_Fill(browser.find_element_by_id('actualController'),
company.legalName)
Del_Fill(browser.find_element_by_id('actualControllerCertNo'),
company.legalID)
Del_Fill(browser.find_element_by_id('actualControllerMobile'),
company.legalTel)
browser = waitTo(browser,
SCENSEE,
way='id',
name='agreeCheckBox',
operate='click') #勾选并同意上述授权书
browser.find_element_by_id('nextStepBtn').click() #点击提交
browser, text = waitTo(browser,
SCENSEE,
way='css',
name='#auditing > div',
operate='getText') #
if text == '您的审请正在审核中':
pass
else:
print('电子凭证授信申请提交失败！')
os.system('pause')
result, manHead, liaHead = MMcredit(loginID=company.loginID,
cusType=company.cusType,
companyName=company.companyName,
env=company.env)
return browser, result, manHead, liaHead
def loginUser(self):
if login(self.username.text(), self.password.text()):
self.parent().closeLogin()
else:
print("Failure")
def scrapingConfirmarPin():
session, token = login()
data = {
'servico': 'ItemSolicitacao',
'columns.0': 'UF',
'columns.1': 'CNPJ do Rementente',
'columns.2': 'Razão Social',
'columns.3': 'N° Nota',
'columns.4': 'Valor da Nota',
'columns.5': 'Data de Emissão',
'columns.6': 'Valor Total Item',
'columns.7': 'Data Limite de Vistoria',
'columns.8': 'Qtde de dias Restantes P/ Vistoria',
'columns.9': 'Situação',
'columns.10': 'Qtde de Itens',
'fields.0': 'sigleUfRemetente',
'fields.1': 'numeroCNPJRemetente',
'fields.2': 'razaoSocialRemetente',
'fields.3': 'numeroNota',
'fields.4': 'valorTotalNFE',
'fields.5': 'dataHoraEmissaoFormatada',
'fields.6': 'valorTotalItem',
'fields.7': 'dataLimiteVistoriaFormatada',
'fields.8': 'qtdDiasRestanteVistoria',
'fields.9': 'situacaoNfe',
'fields.10': 'quatidadeItem',
'maxlength': '44',
'page': '1'
}
dados_confirmar_pin = session.get(
'https://appsimnac.suframa.gov.br/ItemSolicitacao',
data=data,
headers={'Authorization': 'Bearer ' + token},
verify=False)
dados_confirmar_pin = json.loads(dados_confirmar_pin.text)
data = dados_confirmar_pin["items"]
if data:
cursor, conn = newConnection()
cursor.execute(
"""INSERT INTO scraping.confirmarpin (idNFE , idSolicitacaoPin ,sigleUfRemetente ,numeroCNPJRemetente ,razaoSocialRemetente ,numeroNota ,dataHoraEmissao ,valorTotalNFE ,valorTotalItem ,dataLimiteVistoria ,qtdDiasRestanteVistoria ,situacaoNfe ,quantidadeItem ,numeroChaveAcesso ,codigoSituacao ,codigoMunicipioDestinatario ,numeroCNPJDestinatario ,valorNotaFiscalFormatado ,valorTotalItemFormatado ,idNfeSituacao ,usuarioSolicitacao ,ano ,numeroPin ,dataSelagemSefaz ,dataHoraEmissaoFormatada ,dataLimiteVistoriaFormatada ,codigosSolicitacaoPin ,codigoSetor ,descricaoSetor ,mensagemSituacaoNfe ,justificativaRecusada ,codigoSelecaoAssistiva ,nfeCartaCorrecaoPIN) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s) """,
(data["idNFE"], data["idSolicitacaoPin"], data["sigleUfRemetente"],
data["numeroCNPJRemetente"], data["razaoSocialRemetente"],
data["numeroNota"], data["dataHoraEmissao"],
data["valorTotalNFE"], data["valorTotalItem"],
data["dataLimiteVistoria"], data["qtdDiasRestanteVistoria"],
data["situacaoNfe"], data["quantidadeItem"],
data["numeroChaveAcesso"], data["codigoSituacao"],
data["codigoMunicipioDestinatario"],
data["numeroCNPJDestinatario"], data["valorNotaFiscalFormatado"],
data["valorTotalItemFormatado"], [
"idNfeSituacao"
], data["usuarioSolicitacao"], data["ano"], data["numeroPin"],
data["dataSelagemSefaz"], data["dataHoraEmissaoFormatada"],
data["dataLimiteVistoriaFormatada"],
data["codigosSolicitacaoPin"], data["codigoSetor"],
data["descricaoSetor"], data["mensagemSituacaoNfe"],
data["justificativaRecusada"], data["codigoSelecaoAssistiva"],
"NADA POR ENQUANTO"))
cursor.commit()
#stopConnection(conn)
exitSession(session)
