def test_wuliu_testcase08_citylist_xiaoemanagerLogistics(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print " the testcase test_wuliu_testcase08_citylist_xiaoemanagerLogistics is ",driver.title
        #self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        
        conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")    
        global cursor 
        cursor = conn.cursor() 
        
        driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        
        self.assertEqual(driver.title, u"物流")
     
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(5)").click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_link_text(u"新建小e管家").click()
    
        self.assertEqual(driver.title, u"物流")
#         telephonenumber="18611111"+str(random.randint(0,999))
#         identitnumber="152528198801280"+str(random.randint(0,999))
#         
        telephonenumber=random.choice(['139','188','185','136','158','151'])+"".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumber is ",telephonenumber
        #identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId=wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ",identifiedCardId

        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("xiaoeguanjiazhangsankuaiduyuan")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys("9111000029922921113")
        time.sleep(1)
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        driver.find_element_by_id("courier_form_zhuanyun").click()
        driver.find_element_by_id("parent_xiyi").click()
        driver.find_element_by_id("courier_form_kuaixi").click()
        driver.find_element_by_id("courier_form_luxury_logistic").click()
        driver.find_element_by_id("courier_form_is_zhongtui").click()
        driver.find_element_by_id("courier_form_is_employee").click()
        #driver.find_element_by_id("courier_form_is_zancun").click()
        #driver.find_element_by_id("courier_form_is_owner").click()
        time.sleep(1)
        driver.find_element_by_id("courier_form_start_time").send_keys(str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("27").click()
        driver.find_element_by_name("commit").click()
        
        time.sleep(1)
        self.assertEqual(driver.title, u"物流")
        #driver.find_element_by_xpath("//tr[@id='courier_21']/td[6]").click()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("xiaoeguanjiazhangsankuaiduyuan")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("xiaoeguanjiazhangsankuaiduyuan111")
        driver.find_element_by_name("commit").click()
    
        self.assertEqual(driver.title, u"物流")
    
        cursor.execute("DELETE FROM ims_washing_courier where tel='"+telephonenumber+"'")
        conn.commit()
        cursor.close()
        conn.close()
Esempio n. 2
0
    def test_wuliu_testcase08_citylist_selfmanagedLogistics(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print driver.title
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a"
        ).click()
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4)"
        ).click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_link_text(u"新建自营物流").click()
        #telephonenumber="1861111"+str(random.randint(0,9999))
        telephonenumber = random.choice([
            '139', '188', '185', '136', '158', '151'
        ]) + "".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumber is ", telephonenumber
        #identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId = wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ", identifiedCardId
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "ziyingwuliuguanlli")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(
            telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(
            identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys(
            "9111000029922921113")
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        #driver.find_element_by_id("courier_form_is_zhongtui").click()

        driver.find_element_by_id("courier_form_start_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("26").click()

        #         driver.find_element_by_id("realname").clear()
        #         driver.find_element_by_id("realname").send_keys("ziyingwuliuguanlli")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        #click query button
        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info"
        ).click()
        self.assertEqual(driver.title, u"物流")
        #html body div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info
        #html body div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info
        driver.find_element_by_link_text(u"编辑").click()
        telephonenumberedit = random.choice([
            '139', '188', '185', '136', '158', '151'
        ]) + "".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumberedit is ", telephonenumberedit
        identifiedCardIdedit = wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardIdedit is ", identifiedCardIdedit
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(
            identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(
            telephonenumberedit)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "ziyingwuliuguanlli11")
        #driver.find_element_by_id("courier_form_is_employee").click()
        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("ziyingwuliuguanlli")
        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_id("check-ban").click()
        time.sleep(2)
        #driver.find_element_by_xpath("//*[@id="check-ban"]")
        #         self.assertEqual(u"今日之前的请假信息不可添加删除修改!", self.close_alert_and_get_its_text())
        #         self.assertEqual(u"今日之前的请假信息不可添加删除修改!", self.close_alert_and_get_its_text())
        #         qingjiaselector="#"+str(wuliu_utiltools.get_day_of_day(1))+" > p"
        #         print " the qingjiaselector is ",qingjiaselector
        #         driver.find_element_by_css_selector(qingjiaselector).click()
        #         time.sleep(1)
        #         driver.find_element_by_xpath("(//input[@name='vacation_reason'])[2]").click()
        #         driver.find_element_by_id("vacation_plan_reason_submit").click()
        #         time.sleep(1)
        # #         driver.find_element_by_css_selector("#"+str(wuliu_utiltools.get_day_of_day(31))+" > p").click()
        # #
        # #         self.assertEqual(u"请选择请假原因!", self.close_alert_and_get_its_text())
        # #         driver.find_element_by_xpath("(//input[@name='vacation_reason'])[2]").click()

        driver.find_element_by_id("vacation_plan_submit").click()
        #self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        self.assertEqual(u"是否保存修改?", self.close_alert_and_get_its_text())
        time.sleep(2)
        self.assertEqual(u"更新成功", self.close_alert_and_get_its_text())
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        #html body div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child
        actiontargetid = driver.find_element_by_css_selector(
            "div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child"
        ).text
        print " the actiontargetid is ", actiontargetid
        driver.find_element_by_xpath(
            "//div[@onclick=\"$('#action_target').val(" + actiontargetid +
            "); $('#map_box').css('visibility', 'visible')\"]").click()
        driver.find_element_by_css_selector(
            "div.pull-right > div.pull-right").click()
        self.assertEqual(driver.title, u"物流")
Esempio n. 3
0
    def test_wuliu_testcase08_citylist_xiaoeyizhansitepersonmanage(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print driver.title
        self.assertEqual(driver.title, u"物流")

        conn = MySQLdb.connect(host=mysqlhostname,
                               user=mysqlusername,
                               passwd=mysqlpassword,
                               db=mysqlrongchangdb,
                               charset="utf8")
        global cursor
        cursor = conn.cursor()

        driver.find_element_by_css_selector(
            "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a"
        ).click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(11)"
        ).click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container a.btn.btn-info.col-md-1").click()
        userrname = "lukejujnjun" + str(random.randint(0, 999))
        telephonenumber = "18611111" + str(random.randint(0, 999))
        identitnumber = "152528198801280" + str(random.randint(0, 999))
        print " the telephonenumber,identitnumber is ", telephonenumber, identitnumber
        self.assertEqual(driver.title, u"物流")
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(userrname)
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(
            telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(
            identitnumber)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123456")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys(
            "9111000029922921113")
        driver.find_element_by_id("courier_form_is_zancun").click()
        driver.find_element_by_id("courier_form_is_owner").click()

        driver.find_element_by_id("courier_form_start_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("24").click()

        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        driver.find_element_by_css_selector(
            "div.col-md-2.input-group > span.input-group-btn > input[name=\"commit\"]"
        ).click()
        driver.find_element_by_id("realname").click()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        time.sleep(3)

        self.assertEqual(driver.title, u"物流")
        #html body div#container.container>div#courier_search_container>table.table.table-striped>tbody>tr:nth-child(2)>td:last-child>a
        driver.find_element_by_css_selector(
            "div#container.container>div#courier_search_container>table.table.table-striped>tbody>tr:nth-child(2)>td:last-child>a"
        ).click()
        #driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "lukejujnjun111")
        driver.find_element_by_name("commit").click()
        time.sleep(3)

        cursor.execute("DELETE FROM ims_washing_courier where tel='" +
                       telephonenumber + "'")
        conn.commit()
        cursor.close()
        conn.close()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        time.sleep(3)
        driver.find_element_by_link_text(u"超时订单").click()
        driver.find_element_by_id("timeout_qu_list_btn").click()
        driver.find_element_by_id("timeout_song_list_btn").click()
        driver.find_element_by_id("warning_qu_list_btn").click()
        driver.find_element_by_id("warning_song_list_btn").click()
        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08_citylist_jiagongdian_factorybalance(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        time.sleep(2)
        print " the testcase test_wuliu_testcase08_citylist_jiagongdian_factorybalance is ",driver.title
        self.assertEqual(driver.title, u"物流")
        
        #testdata=appobjectwuliu.testcase08_jiagongdian_forbalantestdata
        conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")    
        global cursor 
        cursor = conn.cursor() 
        cursor.execute("DELETE FROM outlet_rules")
        conn.commit()
        cursor.close()
        conn.close()
        #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        #driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+str(9)+") >a").click()
        driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+appobjectwuliu.wuliutabnine_citylist+") >a").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child("+str(10)+")").click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")
    
        driver.find_element_by_css_selector("div#container.container >table.table.table-striped> tbody > tr:nth-child(2) > td:nth-last-child(2) > a:last-child").click()
        #div#container.container > tbody > tr:nth-child(2) > td:nth-last-child(2) > a:last-child
        #html body div#container.container table.table.table-striped tbody tr#outlets_279 td a.btn.btn-primary.btn-sm
        self.assertEqual(driver.title, u"物流")
    
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(appobjectwuliu.testcase08_jiagongdian_forbalantestdata)
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("22")

        driver.execute_script("window.scrollBy(0,200)","")  #
        driver.execute_script("window.scrollBy(0,document.body.scrollHeight)","")  #folloing down to page

        print str(wuliu_utiltools.today())
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()

        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        
        
        hell=driver.find_element_by_css_selector("div#container.container>div#outlet_rule>table.table.table-striped>tbody>tr:last-child>td:last-child>a").text
        print "the hell rules is ",hell
        #html body div#container.container div#outlet_rule table.table.table-striped tbody tr:last-child td:last-child a.btn.btn-sm.btn-danger
        #driver.find_element_by_xpath(u"(//a[contains(text(),'删除')])[4]").click()
        driver.find_element_by_css_selector("div#container.container>div#outlet_rule>table.table.table-striped>tbody>tr:last-child>td:last-child>a").click()
        #print driver.switch_to_alert().text()
        time.sleep(1)
        self.assertRegexpMatches(self.close_alert_and_get_its_text(), u"^确认删除吗[\s\S]$")
        
        self.assertEqual(driver.title, u"物流")
    
    
        #driver.find_element_by_link_text(u"创建规则").click()
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(appobjectwuliu.testcase08_jiagongdian_forbalantestdata_xiyi)
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("100")
        
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
    
        time.sleep(2)

#         driver.find_element_by_id("outlet_rule_form_start_time_display").click()
#         driver.find_element_by_link_text("6").click()
#         driver.find_element_by_id("outlet_rule_form_end_time").click()
#         driver.find_element_by_link_text("20").click()
#         driver.find_element_by_name("commit").click()
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(appobjectwuliu.testcase08_jiagongdian_forbalantestdata_xixie)
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("2")
        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        
        #Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"奢侈品")
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(appobjectwuliu.testcase08_jiagongdian_forbalantestdata)
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
#         driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("12")
        
        #driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08_citylist_selfmanagedLogistics(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print driver.title
        self.assertEqual(driver.title, u"物流")
        
        driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        self.assertEqual(driver.title, u"物流")
        
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4)").click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")
        
        driver.find_element_by_link_text(u"新建自营物流").click()
        #telephonenumber="1861111"+str(random.randint(0,9999))
        telephonenumber=random.choice(['139','188','185','136','158','151'])+"".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumber is ",telephonenumber
        #identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId=wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ",identifiedCardId
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("ziyingwuliuguanlli")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys("9111000029922921113")
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        #driver.find_element_by_id("courier_form_is_zhongtui").click()
        
        driver.find_element_by_id("courier_form_start_time").send_keys(str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("26").click()

#         driver.find_element_by_id("realname").clear()
#         driver.find_element_by_id("realname").send_keys("ziyingwuliuguanlli")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        #click query button
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info").click()
        self.assertEqual(driver.title, u"物流")
        #html body div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info
        #html body div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info
        driver.find_element_by_link_text(u"编辑").click()
        telephonenumberedit=random.choice(['139','188','185','136','158','151'])+"".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumberedit is ",telephonenumberedit
        identifiedCardIdedit=wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardIdedit is ",identifiedCardIdedit
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(telephonenumberedit)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("ziyingwuliuguanlli11")
        #driver.find_element_by_id("courier_form_is_employee").click()
        driver.find_element_by_name("commit").click()
        
        self.assertEqual(driver.title, u"物流")
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("ziyingwuliuguanlli")
        driver.find_element_by_name("commit").click()
        
        self.assertEqual(driver.title, u"物流")
        
        driver.find_element_by_id("check-ban").click()
        time.sleep(2)
        #driver.find_element_by_xpath("//*[@id="check-ban"]")
#         self.assertEqual(u"今日之前的请假信息不可添加删除修改!", self.close_alert_and_get_its_text())
#         self.assertEqual(u"今日之前的请假信息不可添加删除修改!", self.close_alert_and_get_its_text())
#         qingjiaselector="#"+str(wuliu_utiltools.get_day_of_day(1))+" > p"
#         print " the qingjiaselector is ",qingjiaselector
#         driver.find_element_by_css_selector(qingjiaselector).click()
#         time.sleep(1)
#         driver.find_element_by_xpath("(//input[@name='vacation_reason'])[2]").click()
#         driver.find_element_by_id("vacation_plan_reason_submit").click()
#         time.sleep(1)
# #         driver.find_element_by_css_selector("#"+str(wuliu_utiltools.get_day_of_day(31))+" > p").click()
# #         
# #         self.assertEqual(u"请选择请假原因!", self.close_alert_and_get_its_text())
# #         driver.find_element_by_xpath("(//input[@name='vacation_reason'])[2]").click()

        driver.find_element_by_id("vacation_plan_submit").click()
        #self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        self.assertEqual(u"是否保存修改?", self.close_alert_and_get_its_text())
        time.sleep(2)
        self.assertEqual(u"更新成功", self.close_alert_and_get_its_text())
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        #html body div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child
        actiontargetid=driver.find_element_by_css_selector("div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child").text
        print " the actiontargetid is ",actiontargetid
        driver.find_element_by_xpath("//div[@onclick=\"$('#action_target').val("+actiontargetid+"); $('#map_box').css('visibility', 'visible')\"]").click()
        driver.find_element_by_css_selector("div.pull-right > div.pull-right").click()
        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08_citylist_diaoduquery_fanxidan(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        time.sleep(2)
  
        #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child(8) >a").click()
        time.sleep(1)
        conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")    
        global cursor 
        cursor = conn.cursor() 
        self.assertEqual(driver.title, u"物流")
        #driver.find_element_by_link_text(u"新建城市").click()
        #driver.find_elements_by_css_selector("div#container.container a.btn.btn-infos").click()
        driver.find_element_by_xpath("/html/body/div/a").click()
        time.sleep(1)
        cityidname=driver.find_element_by_css_selector("div#container.container div.panel.panel-primary div.panle-body div.orders_container form#new_map_city.form-horizontal.new_map_city div.form-inputs div.form-group.select.required.map_city_api_city_id div.col-sm-8 select#map_city_api_city_id.select.required.form-control option:nth-child(2)").text
        print cityidname
        Select(driver.find_element_by_id("map_city_api_city_id")).select_by_visible_text(cityidname)

        driver.find_element_by_id("map_city_center_lat").clear()
        driver.find_element_by_id("map_city_center_lat").send_keys("-5")

        driver.find_element_by_id("map_city_center_lng").clear()
        driver.find_element_by_id("map_city_center_lng").send_keys("-3")

        driver.find_element_by_id("map_city_search_radius").clear()
        driver.find_element_by_id("map_city_search_radius").send_keys("-5")
        
        driver.find_element_by_id("map_city_gaode_map_code").clear()
        driver.find_element_by_id("map_city_gaode_map_code").send_keys("beijinggaode")
        
        driver.find_element_by_name("commit").click()
        time.sleep(1)
        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")
        
        addsuccess=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text
        print addsuccess
        #shtml body div#container.container>div:nth-child(2)>a.btn.btn-default
        time.sleep(1)
        driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
                
        self.assertEqual(driver.title, u"物流")
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(2)").click()
        #.btn.btn-success
        self.assertEqual(driver.title, u"物流")
        
        cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',status_delivery='3',STATUS='7',paytype='1' WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'")
        conn.commit()
        
        n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id  FROM ims_washing_order WHERE status_delivery='3' AND ordersn='"+wuliu_utiltools.ordersnnumber+"'") 
        for i in xrange(cursor.rowcount):
            ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone()
        print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id
        
        driver.find_element_by_id("order_search_form_ordersn").clear()
        driver.find_element_by_id("order_search_form_ordersn").send_keys(wuliu_utiltools.ordersnnumber)
        driver.find_element_by_name("commit").click()
        
        time.sleep(1)
        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")
        #driver.find_element_by_css_selector("div#container.container> div#paidan_list_container> div.panel.panel-primary.tab-content> div>form> table.table> tbody tr:first-child> td:nth-child(2)> a").click()
        driver.find_element_by_css_selector("div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a").click()
        #html body div#container.container div.checkout-order div.panle-body div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a
        #html body div#container.container div#paidan_list_container div.panel.panel-primary.tab-content div#order_1039373 form#form_1039373.single_order_form table.table tbody tr:first-child td:nth-child(2) a
        #cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'")
        
        #n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery=3 AND fanxidan_id=0 AND bagsn IS NOT NULL  AND id=(SELECT MIN(id) FROM ims_washing_order) ORDER BY id") 
        #for i in xrange(cursor.rowcount):
        #    ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone()
        #print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id
        #print driver.title
        #cursor.execute("DELETE FROM  map_cities WHERE gaode_map_code LIKE 'beijinggaode%'")
#         winBeforeHandle = driver.current_window_handle
#         print "winBeforeHandle==",winBeforeHandle
#         winHandles = driver.window_handles
#         print "winHandles==",winHandles
#         for handle in winHandles:
#             if winBeforeHandle != handle:
#                 driver.switch_to_window(handle)
#         
        self.assertEqual(driver.title, u"物流")        
        time.sleep(1)
        driver.find_element_by_css_selector("div#container.container>a#fanxi_button.btn.btn-info").click()
        driver.find_element_by_xpath("//*[@id='fanxi_button']").click()
        #driver.find_element_by_css_selector("div#container.container>a#fanxi_button.btn.btn-info").click()
#         html body div#container.container a#f''anxi_button.btn.btn-info
        time.sleep(1)
        self.assertEqual(driver.title, u"物流")
        #html body div#container.container a#fanxi_button.btn.btn-info
        #submit to database
     
        fanxiwashingtime=driver.find_element_by_xpath("/html/body/div[1]/form/table/tbody/tr[8]/td[2]/div/div/select/option[2]").text
        #fanxiwashingtime=driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_1039230.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:nth-last-child(4) td:last-child div.form-group.select.required.fanxi_order_form_washing_time div.col-sm-8 select#fanxi_order_form_washing_time.select.required.form-control option:nth-child(2)").text
        print " the fanxiwashingtime is ",fanxiwashingtime
        Select(driver.find_element_by_id("fanxi_order_form_washing_time")).select_by_visible_text(fanxiwashingtime)
        
        driver.find_element_by_id("fanxi_order_form_remark").clear()
        driver.find_element_by_id("fanxi_order_form_remark").send_keys("beijingjiangtailu")
        
        driver.find_element_by_id("fanxi_order_form_washing_date").clear()
        driver.find_element_by_id("fanxi_order_form_washing_date").send_keys(str(wuliu_utiltools.get_day_of_day(2)))
        
        #driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_254.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:last-child td:last-child input.button.btn.btn-info.btn-style-width").click()
        driver.find_element_by_xpath("//input[@type='submit']").click()
        #/html/body/div[1]/form/table/tbody/tr[11]/td[2]/input
        
        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")
        cursor.execute("UPDATE ims_washing_order SET fanxidan_id='0',paytype='1',pay_status='1',fan_id='"+wuliu_utiltools.fansfanidnumber+"',status_delivery='3'  WHERE ordersn='"+wuliu_utiltools.ordersnnumber+"'")
        conn.commit()
        
        wuliuconn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlwuliudb,charset="utf8")    
        global wuliucursor 
        wuliucursor = wuliuconn.cursor() 
        
        wuliucursor.execute("DELETE FROM  map_cities WHERE gaode_map_code LIKE 'beijinggaode%'")
        
        wuliuconn.commit()
        wuliucursor.close()
        cursor.close()
        wuliuconn.close()
        conn.close()
        wuliu_utiltools.getcloseconn()
    def test_wuliu_testcase08_citylist_xiaoeyizhansitepersonmanage(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print driver.title
        self.assertEqual(driver.title, u"物流")
        
        conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")    
        global cursor 
        cursor = conn.cursor() 

        
        driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        
        self.assertEqual(driver.title, u"物流")
     
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(11)").click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
    
        self.assertEqual(driver.title, u"物流")
    
        driver.find_element_by_css_selector("div#container.container a.btn.btn-info.col-md-1").click()
        userrname="lukejujnjun"+str(random.randint(0,999))
        telephonenumber="18611111"+str(random.randint(0,999))
        identitnumber="152528198801280"+str(random.randint(0,999))
        print " the telephonenumber,identitnumber is ",telephonenumber,identitnumber
        self.assertEqual(driver.title, u"物流")
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(userrname)
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(identitnumber)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123456")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys("9111000029922921113")
        driver.find_element_by_id("courier_form_is_zancun").click()
        driver.find_element_by_id("courier_form_is_owner").click()
                
        
        driver.find_element_by_id("courier_form_start_time").send_keys(str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("24").click()

        driver.find_element_by_name("commit").click()
      
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        driver.find_element_by_css_selector("div.col-md-2.input-group > span.input-group-btn > input[name=\"commit\"]").click()
        driver.find_element_by_id("realname").click()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        time.sleep(3)
        
        self.assertEqual(driver.title, u"物流")
        #html body div#container.container>div#courier_search_container>table.table.table-striped>tbody>tr:nth-child(2)>td:last-child>a
        driver.find_element_by_css_selector("div#container.container>div#courier_search_container>table.table.table-striped>tbody>tr:nth-child(2)>td:last-child>a").click()
        #driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("lukejujnjun111")
        driver.find_element_by_name("commit").click()
        time.sleep(3)
        
        cursor.execute("DELETE FROM ims_washing_courier where tel='"+telephonenumber+"'")
        conn.commit()
        cursor.close()
        conn.close()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys("luke")
        driver.find_element_by_name("commit").click()
        time.sleep(3)
        driver.find_element_by_link_text(u"超时订单").click()
        driver.find_element_by_id("timeout_qu_list_btn").click()
        driver.find_element_by_id("timeout_song_list_btn").click()
        driver.find_element_by_id("warning_qu_list_btn").click()
        driver.find_element_by_id("warning_song_list_btn").click()
        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08_citylist_luxuriesLogistics(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        time.sleep(1)
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print " the testcase WuliuTestcase08CitylistluxuriesLogistics is ", driver.title
        self.assertTrue(driver.title, u"物流")

        time.sleep(1)
        # driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+str(9)+") >a").click()
        driver.find_element_by_css_selector(
            "div.container > nav > ul > li:nth-child(" + appobjectwuliu.wuliutabnine_citylist + ") >a"
        ).click()
        # driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child("+str(9)+").active a").click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child("
            + str(7)
            + ")"
        ).click()
        # html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success

        self.assertEqual(driver.title, u"物流")

        #         driver.find_element_by_link_text(u"奢侈品物流").click()
        driver.find_element_by_link_text(u"新建奢侈品物流").click()
        self.assertEqual(driver.title, u"物流")
        telephonenumber = random.choice(["139", "188", "185", "136", "158", "151"]) + "".join(
            random.choice("0123456789") for i in range(8)
        )
        print " the telephonenumber is ", telephonenumber
        # identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId = wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ", identifiedCardId
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("shechipinwuliu")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys("9111000029922921113")
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        driver.find_element_by_id("courier_form_zhuanyun").click()
        driver.find_element_by_id("courier_form_luxury_logistic").click()
        driver.find_element_by_id("parent_xiyi").click()
        driver.find_element_by_id("courier_form_start_time").send_keys(str(wuliu_utiltools.get_day_of_day(1)))
        #         driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(8)))
        #         driver.find_element_by_link_text("26").click()

        # driver.find_element_by_id("courier_form_is_employee").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")

        time.sleep(2)

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info"
        ).click()
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys("shechipinwuliu11")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info"
        ).click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)

        driver.find_element_by_id("check-ban").click()
        time.sleep(2)

        driver.find_element_by_id("vacation_plan_submit").click()
        # self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        self.assertEqual(u"是否保存修改?", self.close_alert_and_get_its_text())
        time.sleep(2)
        self.assertEqual(u"更新成功", self.close_alert_and_get_its_text())
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)

        actiontargetid = driver.find_element_by_css_selector(
            "div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child"
        ).text
        print " the actiontargetid is ", actiontargetid
        driver.find_element_by_xpath(
            "//div[@onclick=\"$('#action_target').val("
            + actiontargetid
            + "); $('#map_box').css('visibility', 'visible')\"]"
        ).click()
        driver.find_element_by_css_selector("div.pull-right > div.pull-right").click()

        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08_citylist_xiaoemanagerLogistics(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print " the testcase test_wuliu_testcase08_citylist_xiaoemanagerLogistics is ", driver.title
        #self.assertEqual(driver.title, u"物流")
        time.sleep(1)

        conn = MySQLdb.connect(host=mysqlhostname,
                               user=mysqlusername,
                               passwd=mysqlpassword,
                               db=mysqlrongchangdb,
                               charset="utf8")
        global cursor
        cursor = conn.cursor()

        driver.find_element_by_css_selector(
            "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a"
        ).click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(5)"
        ).click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_link_text(u"新建小e管家").click()

        self.assertEqual(driver.title, u"物流")
        #         telephonenumber="18611111"+str(random.randint(0,999))
        #         identitnumber="152528198801280"+str(random.randint(0,999))
        #
        telephonenumber = random.choice([
            '139', '188', '185', '136', '158', '151'
        ]) + "".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumber is ", telephonenumber
        #identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId = wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ", identifiedCardId

        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "xiaoeguanjiazhangsankuaiduyuan")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(
            telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(
            identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys(
            "9111000029922921113")
        time.sleep(1)
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        driver.find_element_by_id("courier_form_zhuanyun").click()
        driver.find_element_by_id("parent_xiyi").click()
        driver.find_element_by_id("courier_form_kuaixi").click()
        driver.find_element_by_id("courier_form_luxury_logistic").click()
        driver.find_element_by_id("courier_form_is_zhongtui").click()
        driver.find_element_by_id("courier_form_is_employee").click()
        #driver.find_element_by_id("courier_form_is_zancun").click()
        #driver.find_element_by_id("courier_form_is_owner").click()
        time.sleep(1)
        driver.find_element_by_id("courier_form_start_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(1)))
        #driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(5)))
        #driver.find_element_by_link_text("27").click()
        driver.find_element_by_name("commit").click()

        time.sleep(1)
        self.assertEqual(driver.title, u"物流")
        #driver.find_element_by_xpath("//tr[@id='courier_21']/td[6]").click()
        driver.find_element_by_id("realname").clear()
        driver.find_element_by_id("realname").send_keys(
            "xiaoeguanjiazhangsankuaiduyuan")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "xiaoeguanjiazhangsankuaiduyuan111")
        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")

        cursor.execute("DELETE FROM ims_washing_courier where tel='" +
                       telephonenumber + "'")
        conn.commit()
        cursor.close()
        conn.close()
    def test_wuliu_testcase08_citylist_luxuriesLogistics(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        time.sleep(1)
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print " the testcase WuliuTestcase08CitylistluxuriesLogistics is ", driver.title
        self.assertTrue(driver.title, u"物流")

        time.sleep(1)
        driver.find_element_by_css_selector(
            "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a"
        ).click()

        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(6)"
        ).click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success

        self.assertEqual(driver.title, u"物流")

        #         driver.find_element_by_link_text(u"奢侈品物流").click()
        driver.find_element_by_link_text(u"新建奢侈品物流").click()
        self.assertEqual(driver.title, u"物流")
        telephonenumber = random.choice([
            '139', '188', '185', '136', '158', '151'
        ]) + "".join(random.choice("0123456789") for i in range(8))
        print " the telephonenumber is ", telephonenumber
        #identifiedCardId="152528198801280"+str(random.randint(0,999))
        identifiedCardId = wuliu_utiltools.makeNewIdentifiedCardId()
        print " the identifiedCardId is ", identifiedCardId
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "shechipinwuliu")
        driver.find_element_by_id("courier_form_tel").clear()
        driver.find_element_by_id("courier_form_tel").send_keys(
            telephonenumber)
        driver.find_element_by_id("courier_form_id_number").clear()
        driver.find_element_by_id("courier_form_id_number").send_keys(
            identifiedCardId)
        driver.find_element_by_id("courier_form_password").clear()
        driver.find_element_by_id("courier_form_password").send_keys("123")
        driver.find_element_by_id("courier_form_bank_name").clear()
        driver.find_element_by_id("courier_form_bank_name").send_keys(u"建设银行")
        driver.find_element_by_id("courier_form_bank_card").clear()
        driver.find_element_by_id("courier_form_bank_card").send_keys(
            "9111000029922921113")
        driver.find_element_by_id("courier_form_saofen").click()
        driver.find_element_by_id("courier_form_shouka").click()
        driver.find_element_by_id("courier_form_zhuanyun").click()
        driver.find_element_by_id("courier_form_luxury_logistic").click()
        driver.find_element_by_id("parent_xiyi").click()
        driver.find_element_by_id("courier_form_start_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(1)))
        #         driver.find_element_by_link_text("21").click()
        driver.find_element_by_id("courier_form_end_time").send_keys(
            str(wuliu_utiltools.get_day_of_day(8)))
        #         driver.find_element_by_link_text("26").click()

        #driver.find_element_by_id("courier_form_is_employee").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")

        time.sleep(2)

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info"
        ).click()
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_link_text(u"编辑").click()
        driver.find_element_by_id("courier_form_realname").clear()
        driver.find_element_by_id("courier_form_realname").send_keys(
            "shechipinwuliu11")
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order div.panle-body div.orders_container form div.col-md-4.input-group span.input-group-btn input.btn.btn-info"
        ).click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)

        driver.find_element_by_id("check-ban").click()
        time.sleep(2)

        driver.find_element_by_id("vacation_plan_submit").click()
        #self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        self.assertEqual(u"是否保存修改?", self.close_alert_and_get_its_text())
        time.sleep(2)
        self.assertEqual(u"更新成功", self.close_alert_and_get_its_text())
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)

        actiontargetid = driver.find_element_by_css_selector(
            "div#container.container div#courier_search_container table.table.table-striped tbody tr:nth-child(2) td:first-child"
        ).text
        print " the actiontargetid is ", actiontargetid
        driver.find_element_by_xpath(
            "//div[@onclick=\"$('#action_target').val(" + actiontargetid +
            "); $('#map_box').css('visibility', 'visible')\"]").click()
        driver.find_element_by_css_selector(
            "div.pull-right > div.pull-right").click()

        self.assertEqual(driver.title, u"物流")
    def test_wuliu_testcase08citylist_diaodupaidan_fanxidan_yipandan(self):
        driver = self.driver

        driver.get(self.base_url + "/")

        time.sleep(1)
        loginclick = driver.find_element_by_css_selector(
            "div#container.container h3.text-center.text-primary a.btn.btn-success.text-center"
        )
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        print " the testcase test_wuliu_testcase08citylist_diaodupaidan_fanxidan_yipandan is ", driver.title
        time.sleep(1)
        #self.assertTrue(driver.title, u"物流")
        #self.assertEqual(driver.title, u"物流")

        #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        driver.find_element_by_css_selector(
            "div.container > nav > ul > li:nth-child(8) >a").click()

        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        conn = MySQLdb.connect(host=mysqlhostname,
                               user=mysqlusername,
                               passwd=mysqlpassword,
                               db=mysqlrongchangdb,
                               charset="utf8")
        global cursor
        cursor = conn.cursor()

        #driver.find_element_by_link_text(u"新建城市").click()
        #driver.find_elements_by_css_selector("div#container.container a.btn.btn-infos").click()
        driver.find_element_by_xpath("/html/body/div/a").click()
        cityidname = driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary div.panle-body div.orders_container form#new_map_city.form-horizontal.new_map_city div.form-inputs div.form-group.select.required.map_city_api_city_id div.col-sm-8 select#map_city_api_city_id.select.required.form-control option:nth-child(2)"
        ).text
        print cityidname
        Select(driver.find_element_by_id(
            "map_city_api_city_id")).select_by_visible_text(cityidname)

        driver.find_element_by_id("map_city_center_lat").clear()
        driver.find_element_by_id("map_city_center_lat").send_keys("-5")

        driver.find_element_by_id("map_city_center_lng").clear()
        driver.find_element_by_id("map_city_center_lng").send_keys("-3")

        driver.find_element_by_id("map_city_search_radius").clear()
        driver.find_element_by_id("map_city_search_radius").send_keys("-5")

        driver.find_element_by_id("map_city_gaode_map_code").clear()
        driver.find_element_by_id("map_city_gaode_map_code").send_keys(
            "beijinggaode")

        driver.find_element_by_name("commit").click()

        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        #addsuccess=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text
        #print addsuccess
        #shtml body div#container.container>div:nth-child(2)>a.btn.btn-default

        driver.find_element_by_css_selector(
            "div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a"
        ).click()
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a"
        ).click()
        #.btn.btn-success
        self.assertEqual(driver.title, u"物流")

        n = cursor.execute(
            "SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id  FROM ims_washing_order WHERE status_delivery='3' AND ordersn='15072110393738'"
        )
        for i in xrange(cursor.rowcount):
            ordersn, username, tel, address, status_delivery, STATUS, fanxidan_id = cursor.fetchone(
            )
        print ordersn, username, tel, address, status_delivery, STATUS, fanxidan_id

        print " the ordersn is ", ordersn
        driver.find_element_by_id("order_search_form_ordersn").clear()
        driver.find_element_by_id("order_search_form_ordersn").send_keys(
            ordersn)

        driver.find_element_by_name("commit").click()
        time.sleep(2)
        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")

        driver.find_element_by_css_selector(
            "div#container.container> div#paidan_list_container> div.panel.panel-primary.tab-content> div>form> table.table> tbody tr:first-child> td:nth-child(2)> a"
        ).click()
        #html body div#container.container div#paidan_list_container div.panel.panel-primary.tab-content div#order_1039373 form#form_1039373.single_order_form table.table tbody tr:first-child td:nth-child(2) a
        #cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'")

        #n = cursor.execute("SELECT ordersn ,username,tel,address ,status_delivery,STATUS ,fanxidan_id FROM ims_washing_order WHERE status_delivery=3 AND fanxidan_id=0 AND bagsn IS NOT NULL  AND id=(SELECT MIN(id) FROM ims_washing_order) ORDER BY id")
        #for i in xrange(cursor.rowcount):
        #    ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id = cursor.fetchone()
        #print ordersn ,username,tel,address,status_delivery,STATUS ,fanxidan_id
        self.assertEqual(driver.title, u"物流")

        print driver.title
        #cursor.execute("DELETE FROM  map_cities WHERE gaode_map_code LIKE 'beijinggaode%'")
        winBeforeHandle = driver.current_window_handle
        print "winBeforeHandle==", winBeforeHandle
        winHandles = driver.window_handles
        print "winHandles==", winHandles
        for handle in winHandles:
            if winBeforeHandle != handle:
                driver.switch_to_window(handle)

        driver.find_element_by_css_selector(
            "div#container.container a#fanxi_button").click()

        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")

        #html body div#container.container form#new_fanxi_order_form_1039373.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr td div.form-group.select.optional.fanxi_order_form_courier_qu div.col-sm-8 select#fanxi_order_form_courier_qu.select.optional.form-control option
        time.sleep(2)
        diaoduperson = driver.find_element_by_xpath(
            "/html/body/div[1]/form/table/tbody/tr[6]/td[2]/div/div/select/option[2]"
        ).text

        print " the diaoduperson is ", diaoduperson

        Select(driver.find_element_by_id("fanxi_order_form_courier_qu")
               ).select_by_visible_text(diaoduperson)

        fanxiwashingtime = driver.find_element_by_xpath(
            "/html/body/div[1]/form/table/tbody/tr[8]/td[2]/div/div/select/option[2]"
        ).text
        #fanxiwashingtime=driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_1039230.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:nth-last-child(4) td:last-child div.form-group.select.required.fanxi_order_form_washing_time div.col-sm-8 select#fanxi_order_form_washing_time.select.required.form-control option:nth-child(2)").text
        print " the fanxiwashingtime is ", fanxiwashingtime
        Select(driver.find_element_by_id("fanxi_order_form_washing_time")
               ).select_by_visible_text(fanxiwashingtime)

        driver.find_element_by_id("fanxi_order_form_remark").clear()
        driver.find_element_by_id("fanxi_order_form_remark").send_keys(
            "beijingjiangtailu")

        driver.find_element_by_id("fanxi_order_form_washing_date").clear()
        driver.find_element_by_id("fanxi_order_form_washing_date").send_keys(
            str(wuliu_utiltools.get_day_of_day(1)))

        #driver.find_element_by_css_selector("div#container.container form#new_fanxi_order_form_254.form-horizontal.new_fanxi_order_form table.table.table-striped.search-table tbody tr:last-child td:last-child input.button.btn.btn-info.btn-style-width").click()
        driver.find_element_by_xpath("//input[@type='submit']").click()
        #/html/body/div[1]/form/table/tbody/tr[11]/td[2]/input

        #self.assertTrue(driver.title, u"物流")
        self.assertEqual(driver.title, u"物流")

        daioduconfirm = driver.find_element_by_css_selector(
            "div#container.container div.info-div div.row div.col-md-6 div.panel.panel-primary.checkout-order div.panle-body table.table tbody tr:first-child.success td:nth-child(2) span"
        ).text
        #html body div#container.container div.info-div div.row div.col-md-6 div.panel.panel-primary.checkout-order div.panle-body table.table tbody tr:first-child.success td:nth-child(2) span.label.label-primary
        print daioduconfirm
        self.assertEqual(daioduconfirm, u"调度已派单")
        #self.assertEqual(driver.title, u"物流")

        cursor.execute(
            "UPDATE ims_washing_order SET fanxidan_id='0',paytype='1',pay_status='1',fan_id='"
            + wuliu_utiltools.fansfanidnumber +
            "',status_delivery='3' WHERE ordersn='" +
            wuliu_utiltools.ordersnnumber + "'")
        conn.commit()

        wuliuconn = MySQLdb.connect(host=mysqlhostname,
                                    user=mysqlusername,
                                    passwd=mysqlpassword,
                                    db=mysqlwuliudb,
                                    charset="utf8")
        global wuliucursor
        wuliucursor = wuliuconn.cursor()

        wuliucursor.execute(
            "DELETE FROM  map_cities WHERE gaode_map_code LIKE 'beijinggaode%'"
        )

        wuliuconn.commit()
        wuliucursor.close()
        cursor.close()
        wuliuconn.close()
        conn.close()
    def test_wuliu_testcase08_citylist_jiagongdian_factorybalance(self):
        driver = self.driver
        
        driver.get(self.base_url + "/")

        loginclick=driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center")
        ActionChains(driver).double_click(loginclick).perform()
        driver.find_element_by_id("username").clear()
        driver.find_element_by_id("username").send_keys(USER_NAME)
        driver.find_element_by_id("password").clear()
        driver.find_element_by_id("password").send_keys(PASS_WORD)
        driver.find_element_by_id("login-submit").click()
        time.sleep(2)
        print " the testcase test_wuliu_testcase08_citylist_jiagongdian_factorybalance is ",driver.title
        self.assertEqual(driver.title, u"物流")
        
        conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")    
        global cursor 
        cursor = conn.cursor() 
        cursor.execute("DELETE FROM outlet_rules")
        conn.commit()
        cursor.close()
        conn.close()
        #driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(8).active a").click()
        driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child(8) >a").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(1)
        driver.find_element_by_css_selector("div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(9)").click()
        #html body div#container.container div.panel.panel-primary.checkout-order table.table.table-striped.city-table tbody tr:nth-child(2) td:nth-child(2).btn-link a:nth-child(4).btn.btn-success
        self.assertEqual(driver.title, u"物流")
    
        driver.find_element_by_css_selector("div#container.container >table.table.table-striped> tbody > tr:nth-child(2) > td:nth-last-child(2) > a:last-child").click()
        #div#container.container > tbody > tr:nth-child(2) > td:nth-last-child(2) > a:last-child
        #html body div#container.container table.table.table-striped tbody tr#outlets_279 td a.btn.btn-primary.btn-sm
        self.assertEqual(driver.title, u"物流")
    
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"家纺")
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("22")

        print str(wuliu_utiltools.today())
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(3)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        hell=driver.find_element_by_css_selector("div#container.container>div#outlet_rule>table.table.table-striped>tbody>tr:last-child>td:last-child>a").text
        print "the hell rules is ",hell
        #html body div#container.container div#outlet_rule table.table.table-striped tbody tr:last-child td:last-child a.btn.btn-sm.btn-danger
        #driver.find_element_by_xpath(u"(//a[contains(text(),'删除')])[4]").click()
        driver.find_element_by_css_selector("div#container.container>div#outlet_rule>table.table.table-striped>tbody>tr:last-child>td:last-child>a").click()
        #print driver.switch_to_alert().text()
        time.sleep(1)
        self.assertRegexpMatches(self.close_alert_and_get_its_text(), u"^确认删除吗[\s\S]$")
        
        self.assertEqual(driver.title, u"物流")
    
    
        #driver.find_element_by_link_text(u"创建规则").click()
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"洗衣")
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("100")
        
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(3)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")
    
        time.sleep(2)

#         driver.find_element_by_id("outlet_rule_form_start_time_display").click()
#         driver.find_element_by_link_text("6").click()
#         driver.find_element_by_id("outlet_rule_form_end_time").click()
#         driver.find_element_by_link_text("20").click()
#         driver.find_element_by_name("commit").click()
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"洗鞋")
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(3)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("2")
        driver.find_element_by_name("commit").click()

        self.assertEqual(driver.title, u"物流")
        time.sleep(2)
        
        #Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"奢侈品")
        Select(driver.find_element_by_id("outlet_rule_form_category_id")).select_by_visible_text(u"家纺")
        driver.find_element_by_id("outlet_rule_form_discount").clear()
        driver.find_element_by_id("outlet_rule_form_discount").send_keys("12")
        
        driver.find_element_by_id("outlet_rule_form_start_time_display").send_keys(str(wuliu_utiltools.today()))
        #driver.find_element_by_link_text("6").click()
        driver.find_element_by_id("outlet_rule_form_end_time").send_keys(str(wuliu_utiltools.get_day_of_day(3)))
        #driver.find_element_by_link_text("20").click()
        driver.find_element_by_name("commit").click()
        self.assertEqual(driver.title, u"物流")