def test_kefu_testcase03_orderlist_createorder(self):
driver = self.driver
#driver.get(self.base_url + "/orders/new")
driver.get(self.base_url + "/")
#driver.find_element_by_link_text(u"登陆").click()
driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click()
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_kefu_testcase03_orderlist_createorder is ",driver.title,USER_NAME,PASS_WORD
self.assertEqual(driver.title,u"客服系统")
time.sleep(1)
driver.find_element_by_css_selector("div.container>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child("+appobjectkefu.kefu_tab_orderlist+")>a").click()
self.assertEqual(driver.title,u"客服系统")
#html body div#container.container>div#content-container>a.btn.btn-info.col-md-1
#createorderclick=driver.find_element_by_css_selector("div#container.container>div#content-container>a.btn.btn-info.col-md-1")
createorderclick=driver.find_element_by_xpath("/html/body/div[2]/div/form/a[1]")
ActionChains(driver).double_click(createorderclick).perform()
self.assertEqual(driver.title,u"客服系统")
#driver.find_element_by_css_selector(css_selector)
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_good div.col-sm-8 select#new_order_form_good.select.required.form-control option
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.optional.new_order_form_good div.col-sm-8 select#new_order_form_good.select.optional.form-control option:nth-child(2)
goodnanemtext=driver.find_element_by_css_selector("div#container.container>div.sidebar_container>form>div>div.col-sm-8>select>option:nth-child(2)").text
print " the goodnanemtext is ",goodnanemtext
Select(driver.find_element_by_id("new_order_form_good")).select_by_visible_text(goodnanemtext)
driver.find_element_by_id("new_order_form_totalnum").clear()
driver.find_element_by_id("new_order_form_totalnum").send_keys("10")
driver.find_element_by_id("new_order_form_coupon_sn").clear()
driver.find_element_by_id("new_order_form_coupon_sn").send_keys("82170")
Select(driver.find_element_by_id("new_order_form_user_type")).select_by_visible_text(u"客服下单")
driver.find_element_by_id("new_order_form_username").clear()
driver.find_element_by_id("new_order_form_username").send_keys("testlukeuser")
driver.find_element_by_id("new_order_form_tel").clear()
driver.find_element_by_id("new_order_form_tel").send_keys("121323232")
Select(driver.find_element_by_id("new_order_form_city")).select_by_visible_text(u"北京")
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child
cityareaname=driver.find_element_by_css_selector("div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child").text
print " the cityareaname is ",cityareaname
Select(driver.find_element_by_id("new_order_form_area")).select_by_visible_text(cityareaname)
driver.find_element_by_id("new_order_form_address").clear()
driver.find_element_by_id("new_order_form_address").send_keys("beijingjiangtailu")
#driver.find_element_by_id("new_order_form_washing_date").click()
#driver.find_element_by_link_text("29").click()
datestr=str(PythonDateUtils.get_day_of_day(2))
print " the datestr is ",datestr
datestrfinalstr=str(datestr[-2:])
print " the datestrfinalstr is ",datestrfinalstr
driver.find_element_by_id("new_order_form_washing_date").send_keys(datestr)
driver.find_element_by_link_text(datestrfinalstr).click()
# time.sleep(1)
# winBeforeHandle = driver.current_window_handle
# winHandles = driver.window_handles
# for handle in winHandles:
# if winBeforeHandle != handle:
# driver.switch_to_window(handle)
# driver.find_element_by_id(datestrfinalstr).click()
time.sleep(1)
Select(driver.find_element_by_id("new_order_form_washing_time")).select_by_visible_text("08:00-10:00")
time.sleep(1)
driver.find_element_by_id("new_order_form_remark").clear()
driver.find_element_by_id("new_order_form_remark").send_keys("hellodedaixi")
time.sleep(1)
#driver.find_element_by_name("commit").click()
#driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").send_keys(Keys.ENTER)
#html body div#container.container div.alert.fade.in.alert-success
#createorderresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text
#driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").click()
#driver.find_element_by_xpath("/html/body/div[2]/div/form/input").click()
driver.execute_script("window.scrollBy(0,200)","") #
driver.execute_script("window.scrollBy(0,document.body.scrollHeight)","")
time.sleep(2)
driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").click()
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form input.button.btn.btn-info.btn-style-width
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form input.button.btn.btn-info.btn-style-width
self.assertEqual(driver.title,u"客服系统")
try:
wearesorrytext=driver.find_element_by_css_selector("body > div > h1").text
print " the wearesorrytext result is ",wearesorrytext
if wearesorrytext in "We're sorry, but something went wrong":
raise "We are Sorry"
else:
finalresult=driver.find_element_by_css_selector("html body div#container.container div.alert.fade.in.alert-success").text
print " the finalresult is ",finalresult
assert u"订单已添加" in finalresult
except Exception,e:
#print Exception,":",e
pass
finalresult=driver.find_element_by_css_selector("html body div#container.container div.alert.fade.in.alert-success").text
print " the finalresult is ",finalresult
assert u"订单已添加" in finalresult
def test_kefu_testcase03_orderlist_createfanxiorder(self):
driver = self.driver
#driver.get(self.base_url + "/orders/new")
driver.get(self.base_url + "/")
#driver.find_element_by_link_text(u"登陆").click()
driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click()
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_kefu_testcase03_orderlist_createfanxiorder is ",driver.title
#self.assertEqual(driver.title,u"客服系统")
time.sleep(1)
driver.find_element_by_css_selector("div.container>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child(3)>a").click()
conn=MySQLdb.connect(host=mysqlhostname,user=mysqlusername,passwd=mysqlpassword,db=mysqldatabase,charset="utf8")
global cursor
cursor = conn.cursor()
# n = cursor.execute("SELECT ordersn,fan_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")
# #print " the cursor.fetchone() is ",cursor.fetchone()
# for i in xrange(cursor.rowcount):
# ordersn,fan_id=cursor.fetchone()
# #print " the cursor.fetchone() is ",cursor.fetchone()
# print "ordersn,fan_id is ",ordersn,fan_id
#
# global ordernumber
# cursor.execute("SELECT ordersn,fan_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,fan_id = cursor.fetchone()
# #print ordersn,fan_id
# ordernumber=ordersn
# global ordersn
# n = cursor.execute("SELECT ordersn 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 = cursor.fetchone()
# ordervrnum=ordersn
# print ordervrnum
# cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0 WHERE ordersn='"+ordersn+"'")
#This is test data for kefu create fanxidan business
#ordersn="0723821336144"
driver.find_element_by_id("order_search_form_ordersn").clear()
driver.find_element_by_id("order_search_form_ordersn").send_keys(PythonDateUtils.fanxiordersnnumber)
driver.find_element_by_name("commit").click()
self.assertEqual(driver.title,u"客服系统")
print " the PythonDateUtils.fanxiordersnnumber is ",PythonDateUtils.fanxiordersnnumber
time.sleep(1)
driver.find_element_by_css_selector("div#container.container div#content-container div#content div.panel.panel-primary form.form-horizontal.batch_update table.table.table-striped tbody tr:first-child td:nth-child(2) a").click()
self.assertEqual(driver.title,u"客服系统")
driver.find_element_by_css_selector("div#container.container a#fanxi_button.btn.btn-info").click()
self.assertEqual(driver.title,u"客服系统")
winBeforeHandle = driver.current_window_handle
winHandles = driver.window_handles
for handle in winHandles:
if winBeforeHandle != handle:
driver.switch_to_window(handle)
#datestr=str(PythonDateUtils.get_day_of_day(1))[-2:]
datestr=str(PythonDateUtils.get_day_of_day(3))
print " the datestr is ",datestr
driver.find_element_by_id("fanxi_order_form_washing_date").clear()
driver.find_element_by_id("fanxi_order_form_washing_date").send_keys(datestr)
driver.find_element_by_id("fanxi_order_form_washing_date").click()
#driver.find_element_by_link_text(datestr).click()
fanxiwashingtime=driver.find_element_by_xpath("/html/body/div[2]/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_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()
#driver.find_elements(By.XPATH, "//input[@type='submit']").click()
self.assertEqual(driver.title,u"客服系统")
createfanxidanresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text
print " the createfanxidanresult is ",createfanxidanresult
#self.assertEqual(createfanxidanresult,u"客服系统")
cursor.execute("UPDATE ims_washing_order SET status_delivery='3' ,STATUS='1' ,fanxidan_id=0,fan_id='"+PythonDateUtils.fanstableidnumber+"' WHERE ordersn='"+PythonDateUtils.ordersnnumber+"'")
#提交到数据库执行
conn.commit()
cursor.close()
conn.close()
PythonDateUtils.getcloseconn()
def test_kefu_testcase03_orderlist_createorder(self):
driver = self.driver
#driver.get(self.base_url + "/orders/new")
driver.get(self.base_url + "/")
#driver.find_element_by_link_text(u"登陆").click()
driver.find_element_by_css_selector("div#container.container h3.text-center.text-primary a.btn.btn-success.text-center").click()
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>div.navbar-collapse.collapse.navbar-responsive-collapse>ul.nav.navbar-nav>li:nth-child(3)>a").click()
self.assertEqual(driver.title,u"客服系统")
#html body div#container.container>div#content-container>a.btn.btn-info.col-md-1
#createorderclick=driver.find_element_by_css_selector("div#container.container>div#content-container>a.btn.btn-info.col-md-1")
createorderclick=driver.find_element_by_xpath("/html/body/div[2]/div/form/a[1]")
ActionChains(driver).double_click(createorderclick).perform()
self.assertEqual(driver.title,u"客服系统")
#driver.find_element_by_css_selector(css_selector)
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_good div.col-sm-8 select#new_order_form_good.select.required.form-control option
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.optional.new_order_form_good div.col-sm-8 select#new_order_form_good.select.optional.form-control option:nth-child(2)
goodnanemtext=driver.find_element_by_css_selector("div#container.container>div.sidebar_container>form>div>div.col-sm-8>select>option:nth-child(2)").text
print " the goodnanemtext is ",goodnanemtext
Select(driver.find_element_by_id("new_order_form_good")).select_by_visible_text(goodnanemtext)
driver.find_element_by_id("new_order_form_totalnum").clear()
driver.find_element_by_id("new_order_form_totalnum").send_keys("10")
driver.find_element_by_id("new_order_form_coupon_sn").clear()
driver.find_element_by_id("new_order_form_coupon_sn").send_keys("8217005292233")
Select(driver.find_element_by_id("new_order_form_user_type")).select_by_visible_text(u"客服下单")
driver.find_element_by_id("new_order_form_username").clear()
driver.find_element_by_id("new_order_form_username").send_keys("testlukeuser")
driver.find_element_by_id("new_order_form_tel").clear()
driver.find_element_by_id("new_order_form_tel").send_keys("beijingjiangtailu")
Select(driver.find_element_by_id("new_order_form_city")).select_by_visible_text(u"北京")
#html body div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child
cityareaname=driver.find_element_by_css_selector("div#container.container div.sidebar_container form#new_new_order_form.form-horizontal.new_new_order_form div.form-group.select.required.new_order_form_area div.col-sm-8 select#new_order_form_area.select.required.form-control option:first-child").text
print " the cityareaname is ",cityareaname
Select(driver.find_element_by_id("new_order_form_area")).select_by_visible_text(cityareaname)
driver.find_element_by_id("new_order_form_address").clear()
driver.find_element_by_id("new_order_form_address").send_keys("beijingjiangtailu")
#driver.find_element_by_id("new_order_form_washing_date").click()
#driver.find_element_by_link_text("29").click()
datestr=str(PythonDateUtils.get_day_of_day(2))
print " the datestr is ",datestr
driver.find_element_by_id("new_order_form_washing_date").send_keys(datestr)
Select(driver.find_element_by_id("new_order_form_washing_time")).select_by_visible_text("08:00-10:00")
driver.find_element_by_id("new_order_form_remark").clear()
driver.find_element_by_id("new_order_form_remark").send_keys("hellodedaixi")
driver.find_element_by_name("commit").click()
#driver.find_element_by_css_selector("input.button.btn.btn-info.btn-style-width").send_keys(Keys.ENTER)
#html body div#container.container div.alert.fade.in.alert-success
#createorderresult=driver.find_element_by_css_selector("div#container.container div.alert.fade.in.alert-success").text
self.assertEqual(driver.title,u"客服系统")
