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读取的是这个文件的每一竖列数据               
    yhms=[]                                                               #定义空数组
    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)                                         #将每一列的数据装入到空白的数组中
        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)
    #真实姓名
    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)
    #证件号码
    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)
    #手机
    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)
    #居住区域
    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)
    #详细地址
    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)
    #学历、从事行业
    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)
    #服务区域
    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)
    #服务类别
    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') == '社区服务':
            a.click()
    #time.sleep(2)
    #服务领域或行业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("申请成为实名注册志愿者").click()
    time.sleep(1)
    driver.refresh()