215 lines
8.0 KiB
Plaintext
215 lines
8.0 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 3,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"C:\\Users\\杨国栋\\AppData\\Local\\Temp/ipykernel_2228/4239557569.py:23: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
|
|
" driver = webdriver.Chrome(executable_path=r'C:\\chromedriver\\chromedriver_107\\chromedriver.exe')\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"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",
|
|
"import datetime\n",
|
|
"import pandas as pd\n",
|
|
"from xlutils.copy import copy\n",
|
|
"from selenium.webdriver.common.keys import Keys\n",
|
|
"from selenium.webdriver.common.action_chains import ActionChains\n",
|
|
"from selenium.webdriver.common.by import By\n",
|
|
"\n",
|
|
"#获取会员卡基础信息\n",
|
|
"name = '15882131247'\n",
|
|
"password = 'Ff123456'\n",
|
|
"option_chrome = webdriver.ChromeOptions()\n",
|
|
"option_chrome.add_argument('--headless')\n",
|
|
"\n",
|
|
"http='https://m.f6car.cn/'\n",
|
|
"\n",
|
|
"driver = webdriver.Chrome(executable_path=r'C:\\chromedriver\\chromedriver_113\\chromedriver.exe')\n",
|
|
"driver.maximize_window()\n",
|
|
"driver.implicitly_wait(5)\n",
|
|
"driver.get(http)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[1]/div/div/input').send_keys(name)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[2]/div/div[1]/input').send_keys(password)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[3]/div/button/span').click()\n",
|
|
"\n",
|
|
"time.sleep(4)#预设时间\n",
|
|
"\n",
|
|
"df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\会员卡信息 (23).xlsx',sheet_name='会员卡详情',dtype='string') \n",
|
|
"for item in df.index:\n",
|
|
" try:\n",
|
|
" cardid= df.loc[item,'卡实体id']\n",
|
|
" https='https://yunxiu.f6car.cn/kzf6/consumeBill/index.do?page=view/index.html%23/marketing/cardEdit/'+cardid\n",
|
|
" driver.get(https)\n",
|
|
" time.sleep(0.5)\n",
|
|
"\n",
|
|
" #点击全选，多车牌\n",
|
|
" \n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/div/div/div/div/label/span/span').click()\n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/div/div/div/div/label/span/span').click()\n",
|
|
" time.sleep(0.5)\n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/button[1]/span').click()\n",
|
|
" time.sleep(0.5)\n",
|
|
" # #点击勾选，单车牌\n",
|
|
" # driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div[1]/div/div/div/div/div/div/div/label/span/span').click()\n",
|
|
" # time.sleep(0.5)\n",
|
|
" # driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/button[1]/span').click()\n",
|
|
" # time.sleep(0.5)\n",
|
|
" except:\n",
|
|
" pass"
|
|
]
|
|
},
|
|
{
|
|
"attachments": {},
|
|
"cell_type": "markdown",
|
|
"metadata": {},
|
|
"source": [
|
|
"## 卡选择不限制车牌使用"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 1,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stderr",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\_distributor_init.py:30: UserWarning: loaded more than 1 DLL from .libs:\n",
|
|
"c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\.libs\\libopenblas.EL2C6PLE4ZYW3ECEVIV3OXXGRN2NRFM2.gfortran-win_amd64.dll\n",
|
|
"c:\\Users\\admin\\.conda\\envs\\F6processing\\lib\\site-packages\\numpy\\.libs\\libopenblas64__v0.3.21-gcc_10_3_0.dll\n",
|
|
" warnings.warn(\"loaded more than 1 DLL from .libs:\"\n"
|
|
]
|
|
},
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"成功：11961263688167485444\n",
|
|
"成功：11961263687672553540\n",
|
|
"成功：11961263687613837405\n",
|
|
"成功：11961263687047606309\n",
|
|
"成功：11961263686603010082\n",
|
|
"成功：11961263686032580698\n",
|
|
"成功：11961263685915144279\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"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",
|
|
"import datetime\n",
|
|
"import pandas as pd\n",
|
|
"from xlutils.copy import copy\n",
|
|
"from selenium.webdriver.common.keys import Keys\n",
|
|
"from selenium.webdriver.common.action_chains import ActionChains\n",
|
|
"from selenium.webdriver.common.by import By\n",
|
|
"\n",
|
|
"#获取会员卡基础信息\n",
|
|
"name = '15888265981'\n",
|
|
"password = 'Ff123456'\n",
|
|
"option_chrome = webdriver.ChromeOptions()\n",
|
|
"option_chrome.add_argument('--headless')\n",
|
|
"\n",
|
|
"http='https://m.f6car.com/'\n",
|
|
"\n",
|
|
"driver = webdriver.Chrome(executable_path=r\"C:\\Users\\admin\\Desktop\\Python脚本\\chromedriver.exe\")\n",
|
|
"\n",
|
|
"driver.maximize_window()\n",
|
|
"\n",
|
|
"driver.implicitly_wait(5)\n",
|
|
"\n",
|
|
"driver.get(http)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[1]/div/div/input').send_keys(name)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[2]/div/div[1]/input').send_keys(password)\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"pane-username\"]/form/div[3]/div/button/span').click()\n",
|
|
"#新手引导关闭\n",
|
|
"driver.find_element(By.XPATH,'/html/body/div/div/div[1]/button').click()\n",
|
|
"driver.find_element(By.XPATH,'//*[@id=\"subMain\"]/div/div[3]/div/div/div/span[2]').click()\n",
|
|
"\n",
|
|
"df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\会员卡信息 (23).xlsx',sheet_name='会员卡详情',dtype='string') \n",
|
|
"\n",
|
|
"for item in range(0,693):\n",
|
|
" try:\n",
|
|
" time.sleep(2)\n",
|
|
" # 点击首页\n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"main\"]/div/div/div/div/div/div/div[1]/div/div/span').click()\n",
|
|
" time.sleep(2)\n",
|
|
" cardid= df.loc[item,'卡实体id']\n",
|
|
" https='https://yunxiu.f6car.com/erp/view/index.html#/macan-view/cardManage/cardEdit/'+cardid\n",
|
|
" driver.get(https)\n",
|
|
" time.sleep(2)\n",
|
|
"\n",
|
|
" #点击不限制车牌使用\n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/div/div/div/div/div[1]/label/span/span').click()\n",
|
|
" time.sleep(1)\n",
|
|
" #点击保存\n",
|
|
" driver.find_element(By.XPATH,'//*[@id=\"app\"]/div/div/div/div/div/div/button[1]/span').click()\n",
|
|
" time.sleep(2)\n",
|
|
" #点击确定\n",
|
|
" driver.find_element(By.XPATH,'/html/body/div[5]/div/div/button[1]/span').click()\n",
|
|
"\n",
|
|
" print(\"成功：\"+str(cardid))\n",
|
|
" except:\n",
|
|
" pass"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 3,
|
|
"metadata": {},
|
|
"outputs": [],
|
|
"source": [
|
|
"from selenium import webdriver\n",
|
|
"from selenium.webdriver.chrome.service import Service\n",
|
|
"\n",
|
|
"# create a new ChromeDriver service\n",
|
|
"service = Service(r'C:\\chromedriver\\chromedriver_113\\chromedriver.exe')\n",
|
|
"\n",
|
|
"# create a new ChromeDriver instance using the service\n",
|
|
"driver = webdriver.Chrome(service=service)"
|
|
]
|
|
}
|
|
],
|
|
"metadata": {
|
|
"kernelspec": {
|
|
"display_name": "base",
|
|
"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.12.4"
|
|
},
|
|
"orig_nbformat": 4
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 2
|
|
}
|