from  selenium import webdriver
from selenium.webdriver.support.select import Select

from selenium.webdriver.common.keys import Keys
import time
import csv
import sys
import datetime
import os

with open(r'D:\wenjian\data_zhz.csv') as csvfile:   
    readCSV = csv.reader(csvfile, delimiter=',')        #readCSV讀取的是這個(gè)文件的每一豎列數(shù)據(jù)               
    yhms=[]                                                               #定義空數(shù)組
    mms=[]
    dzyxs=[]
    xms=[]
    zjhms=[]
    sjs=[]
    xxdzs=[]
    zgxls=[]
    cyzks=[]
    for row in readCSV:
        yhm=row[0]                                                            #每一列命名
        mm=row[1]
        dzyx=row[2]
        xm=row[3]
        zjhm=row[4]
        sj=row[5]
        xxdz=row[6]
        zgxl=row[7]
        cyzk=row[8]
        yhms.append(yhm)                                         #將每一列的數(shù)據(jù)裝入到空白的數(shù)組中
        mms.append(mm)
        dzyxs.append(dzyx)
        xms.append(xm)
        zjhms.append(zjhm)
        sjs.append(sj)
        xxdzs.append(xxdz)
        zgxls.append(zgxl)
        cyzks.append(cyzk)
n=len(yhms)                                                             #需要知道總共CSV文件有多少行
driver = webdriver.Chrome()
for i in range(1842,n):
    yh=yhms[i]                                                                           
    m=mms[i]
    dzy=dzyxs[i]
    x=xms[i]
    zjh=zjhms[i]
    s=sjs[i]
    xxd=xxdzs[i]
    zgx=zgxls[i]
    cyz=cyzks[i]
    time.sleep(2)
    driver.get("https://hb.chinavolunteer.cn/app/user/register.php")

    #driver.maximize_window()
    driver.refresh()
    time.sleep(2)
    # 用戶名
    yhm_txt = driver.find_element_by_id("login_name").get_attribute("value")

    driver.find_element_by_id("login_name").send_keys(yh)
    #time.sleep(1)
    #確定用戶名
    qdyhm_txt = driver.find_element_by_id("login_name_repeat").get_attribute("value")

    driver.find_element_by_id("login_name_repeat").send_keys(yh)
    #time.sleep(1)
    #密碼
    mm_txt = driver.find_element_by_id("login_pass").get_attribute("value")

    driver.find_element_by_id("login_pass").send_keys(m)
    #time.sleep(1)
    #確定密碼
    qdmm_txt = driver.find_element_by_id("login_pass_repeat").get_attribute("value")

    driver.find_element_by_id("login_pass_repeat").send_keys(m)
    #time.sleep(1)
    #電子郵箱
    dzyx_txt = driver.find_element_by_id("login_email").get_attribute("value")

    driver.find_element_by_id("login_email").send_keys(dzy)
    #time.sleep(1)
    #確定電子郵箱
    qddzyx_txt = driver.find_element_by_id("login_email_repeat").get_attribute("value")

    driver.find_element_by_id("login_email_repeat").send_keys(dzy)
    #time.sleep(1)
    #真實(shí)姓名
    zsxm_txt = driver.find_element_by_id("vol_true_name").get_attribute("value")

    driver.find_element_by_id("vol_true_name").send_keys(x)
    #time.sleep(2)
    #證件號(hào)碼
    zjhm_txt = driver.find_element_by_id("vol_cert_number").get_attribute("value")

    driver.find_element_by_id("vol_cert_number").send_keys(zjh)
    time.sleep(2)
    #政治面貌
    sell=driver.find_element_by_id("vol_political")                                        #下拉框的選擇方法
    Select(sell).select_by_value("4859")
    time.sleep(1)
    #籍貫
    sel=driver.find_element_by_id("nat_district1")
    Select(sel).select_by_value("7385")
    time.sleep(2)
    sel=driver.find_element_by_id("nat_district2")
    Select(sel).select_by_value("7500")
    time.sleep(2)
    sel=driver.find_element_by_id("nat_district3")
    Select(sel).select_by_value("23694")
    time.sleep(1)
    #手機(jī)
    sj_txt = driver.find_element_by_id("login_mobile").get_attribute("value")

    driver.find_element_by_id("login_mobile").send_keys(s)
    #time.sleep(1)
    #居住區(qū)域
    time.sleep(2)
    sel=driver.find_element_by_id("house_district1")
    Select(sel).select_by_value("7500")
    time.sleep(2)
    sel=driver.find_element_by_id("house_district2")
    Select(sel).select_by_value("23694")
    #time.sleep(1)
    #詳細(xì)地址
    xxdz_txt = driver.find_element_by_id("vol_address").get_attribute("value")

    driver.find_element_by_id("vol_address").send_keys(xxd)
    time.sleep(1)
    #學(xué)歷、從事行業(yè)
    sel=driver.find_element_by_id("vol_edu_degree")
    Select(sel).select_by_value("4542")
    time.sleep(1)
    sel=driver.find_element_by_id("vol_job_title")
    Select(sel).select_by_value("23276")
    time.sleep(1)
    #服務(wù)區(qū)域
    time.sleep(2)
    sel=driver.find_element_by_id("district1")                       
    Select(sel).select_by_value("7500")
    time.sleep(3)
    sel=driver.find_element_by_id("district2")
    Select(sel).select_by_value("23694")
    #time.sleep(2)
    #服務(wù)類別
    checkboxes = driver.find_elements_by_css_selector('input[type=checkbox]')              #多選框的選擇
    for a in checkboxes:
        if a.get_attribute('value') == '清潔家園':
            a.click()
        elif a.get_attribute('value') == '社區(qū)服務(wù)':
            a.click()
    #time.sleep(2)
    #服務(wù)領(lǐng)域或行業(yè)register
    driver.find_element_by_id("stype_23392").click()
    driver.find_element_by_id("stype_23393").click()
    #time.sleep(1)
    driver.find_element_by_link_text("申請(qǐng)成為實(shí)名注冊(cè)志愿者").click()
    time.sleep(1)
    driver.refresh()