def test_wuliu_testcase08_citylist_diaoduquery_crud(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("+str(9)+") >a").click()
driver.find_element_by_css_selector("div.container > nav > ul > li:nth-child("+appobjectwuliu.wuliutabnine_citylist+") >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("+appobjectwuliu.wuliutabnine_citylist+").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)
Select(driver.find_element_by_id("order_search_form_delivery_status")).select_by_visible_text(u"客户签收")
driver.find_element_by_name("commit").click()
time.sleep(1)
#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
queryordernumber=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 ").text
print " the queryordernumber is ",queryordernumber
time.sleep(1)
driver.find_element_by_link_text(queryordernumber).click()
time.sleep(1)
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_xpath("//div[@id='container']/div/div[4]/div/div/div[2]/div/div/button").click()
time.sleep(2)
if EC.alert_is_present:
print("Alert exists")
alert=self.driver.switch_to_alert()
#sprint "alert.text",(alert.text)#
alert.accept
print("Alert accepted")
else:
print("NO alert exists")
# 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)
#print " the dialog windows is ",driver.switch_to_alert()
''' driver.execute_script("var doc=document.getElementsByClassName('wuliu_form modal fade');doc.setAttribute('aria-hidden','');")
if EC.alert_is_present:
print("Alert exists")
alert=self.driver.switch_to_alert()
#sprint "alert.text",(alert.text)#
alert.accept
print("Alert accepted")
else:
print("NO alert exists")
#driver.switch_to_alert().accept()
time.sleep(2)
#Alert alert =driver.switchTo().alert();
wuliudiaodumodify=driver.find_element_by_css_selector("html body.modal-open div#container.container div.alert.fade.in.alert-success").text
print " the wuliudiaodumodify is ",wuliudiaodumodify
time.sleep(1)
# driver.find_element_by_id("kehu_message_form_username").clear()
# driver.find_element_by_id("kehu_message_form_username").send_keys(u"监控w23311")
# driver.find_element_by_id("kehu_message_form_tel").clear()
# driver.find_element_by_id("kehu_message_form_tel").send_keys("16155555555111")
# time.sleep(1)
# driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click()
# driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click()
# driver.find_element_by_css_selector("#new_kehu_message_form_2822532 > div.text-center > input[name=\"commit\"]").click()
# time.sleep(1)
# driver.find_element_by_xpath("(//button[@type='button'])[3]").click()
# 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)
#
#/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_testcase00_EditSitePermission(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 WuliuTestcase00EditSitePermission is ", driver.title
self.assertEqual(driver.title, u"物流")
time.sleep(2)
wuliu_utiltools.updateSignNumber()
driver.find_element_by_css_selector(
"div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(1).dropdown a"
).click()
self.assertEqual(driver.title, u"物流")
driver.find_element_by_xpath(
"/html/body/header/div/nav/ul/li[1]/ul/li[1]/a").click()
self.assertEqual(driver.title, u"物流")
driver.find_element_by_id("bagsn").clear()
driver.find_element_by_id("bagsn").send_keys(
wuliu_utiltools.signbagnumber)
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
time.sleep(2)
#html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg
qianshouresult = driver.find_element_by_css_selector(
"div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg"
).text
print " the qianshouresult failed is ", qianshouresult
assert u"签收失败！" in qianshouresult
# qianshou success for 00 permission
conn = MySQLdb.connect(host=mysqlhostname,
user=mysqlusername,
passwd=mysqlpassword,
db=mysqlrongchangdb,
charset="utf8")
global cursor
cursor = conn.cursor()
cursor.execute(
"UPDATE ims_washing_order SET status_delivery='1' ,qianshoudian_id= NULL WHERE bagsn='E0000000006'"
)
conn.commit()
n = cursor.execute(
"SELECT ordersn,bagsn,status_delivery,jiagongdian_id,qianshoudian_id FROM ims_washing_order WHERE bagsn='E0000000006'"
)
for i in xrange(cursor.rowcount):
ordersn, bagsn, status_delivery, jiagongdian_id, qianshoudian_id = cursor.fetchone(
)
print ordersn, bagsn, status_delivery, jiagongdian_id, qianshoudian_id
time.sleep(1)
driver.find_element_by_id("bagsn").clear()
driver.find_element_by_id("bagsn").send_keys(bagsn)
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
qianshouresult = driver.find_element_by_css_selector(
"div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg"
).text
print " the qianshouresult success is ", qianshouresult
# assert u"签收成功！" in qianshouresult
time.sleep(2)
driver.find_element_by_link_text(u"站点出入库管理").click()
driver.find_element_by_link_text(u"出库").click()
driver.find_element_by_id("order_key").clear()
driver.find_element_by_id("order_key").send_keys("E0000000006")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
# zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text
# print " the zhandianchukuresult null is ",zhandianchukuresult
# assert u"出库成功" in zhandianchukuresult
time.sleep(2)
# driver.find_element_by_link_text(u"站点出入库管理").click()
# driver.find_element_by_link_text(u"出库").click()
# driver.find_element_by_id("order_key").clear()
# driver.find_element_by_id("order_key").send_keys("")
# driver.find_element_by_name("commit").click()
zhandianchukuresult = driver.find_element_by_css_selector(
"html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg"
).text
print " the zhandianchukuresult null is ", zhandianchukuresult
assert u"出库成功" in zhandianchukuresult
time.sleep(2)
driver.find_element_by_link_text(u"站点出入库管理").click()
driver.find_element_by_link_text(u"出入库查询").click()
# driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
Select(driver.find_element_by_id(
"in_out_type")).select_by_visible_text(u"出库")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
Select(driver.find_element_by_id(
"target_type")).select_by_visible_text(u"加工店")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
wuliu_utiltools.getcloseconn()
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_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_testcase00_EditSitePermission(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 WuliuTestcase00EditSitePermission is ",driver.title
self.assertEqual(driver.title, u"物流")
time.sleep(2)
wuliu_utiltools.updateSignNumber()
driver.find_element_by_css_selector("div.container nav.collapse.navbar-collapse.bs-navbar-collapse ul.nav.navbar-nav li:nth-child(1).dropdown a").click()
self.assertEqual(driver.title, u"物流")
driver.find_element_by_xpath("/html/body/header/div/nav/ul/li[1]/ul/li[1]/a").click()
self.assertEqual(driver.title, u"物流")
driver.find_element_by_id("bagsn").clear()
driver.find_element_by_id("bagsn").send_keys(wuliu_utiltools.signbagnumber)
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
time.sleep(2)
#html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg
qianshouresult=driver.find_element_by_css_selector("div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg").text
print " the qianshouresult failed is ",qianshouresult
assert u"签收失败！" in qianshouresult
# qianshou success for 00 permission
conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqlrongchangdb,charset="utf8")
global cursor
cursor = conn.cursor()
cursor.execute("UPDATE ims_washing_order SET status_delivery='1' ,qianshoudian_id= NULL WHERE bagsn='E0000000006'")
conn.commit()
n = cursor.execute("SELECT ordersn,bagsn,status_delivery,jiagongdian_id,qianshoudian_id FROM ims_washing_order WHERE bagsn='E0000000006'")
for i in xrange(cursor.rowcount):
ordersn ,bagsn,status_delivery,jiagongdian_id,qianshoudian_id = cursor.fetchone()
print ordersn ,bagsn,status_delivery,jiagongdian_id,qianshoudian_id
time.sleep(1)
driver.find_element_by_id("bagsn").clear()
driver.find_element_by_id("bagsn").send_keys(bagsn)
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
qianshouresult=driver.find_element_by_css_selector("div#container.container>div.panel.panel-primary>p.text-center>b#check_in_msg").text
print " the qianshouresult success is ",qianshouresult
# assert u"签收成功！" in qianshouresult
time.sleep(2)
driver.find_element_by_link_text(u"站点出入库管理").click()
driver.find_element_by_link_text(u"出库").click()
driver.find_element_by_id("order_key").clear()
driver.find_element_by_id("order_key").send_keys("E0000000006")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
# zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text
# print " the zhandianchukuresult null is ",zhandianchukuresult
# assert u"出库成功" in zhandianchukuresult
time.sleep(2)
# driver.find_element_by_link_text(u"站点出入库管理").click()
# driver.find_element_by_link_text(u"出库").click()
# driver.find_element_by_id("order_key").clear()
# driver.find_element_by_id("order_key").send_keys("")
# driver.find_element_by_name("commit").click()
zhandianchukuresult=driver.find_element_by_css_selector("html body div#container.container div.panel.panel-primary p.text-center b#check_in_msg").text
print " the zhandianchukuresult null is ",zhandianchukuresult
assert u"出库成功" in zhandianchukuresult
time.sleep(2)
driver.find_element_by_link_text(u"站点出入库管理").click()
driver.find_element_by_link_text(u"出入库查询").click()
# driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
Select(driver.find_element_by_id("in_out_type")).select_by_visible_text(u"出库")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
Select(driver.find_element_by_id("target_type")).select_by_visible_text(u"加工店")
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title, u"物流")
wuliu_utiltools.getcloseconn()
