def setUp(self): self.driver = webdriver.Firefox() self.driver.implicitly_wait(30) self.base_url = "https://book.citilink.co.id/" self.verificationErrors = [] self.accept_next_alert = True self.kodemaskapai = 3 self.credentials = cfg.getloginandpass(self.kodemaskapai)
def setUp(self): self.driver = webdriver.Firefox() #self.driver.implicitly_wait(30) self.base_url = "https://booking.airasia.com/LoginAgent.aspx" self.verificationErrors = [] self.accept_next_alert = True self.kodemaskapai = 3 self.login = "" self.password = "" self.cred = cfg.getloginandpass(self.kodemaskapai) self.login = self.cred[0] self.password = self.cred[1]
def setUp(self): self.driver = webdriver.Firefox() self.driver.implicitly_wait(30) self.base_url = "https://booking.airasia.com/LoginAgent.aspx" self.verificationErrors = [] self.accept_next_alert = True self.kodemaskapai = 10 self.login = "" self.password = "" self.cred = cfg.getloginandpass(self.kodemaskapai) self.login = self.cred[0] self.password = self.cred[1] cnx = mysql.connector.connect(**config) query = ( "SELECT c.*,a.firstname,a.middlename,a.lastname,a.salutation,a.tanggallahir, a.jenispenumpang,a.idmaskapaipulang,a.idmaskapaipergi,a.kodeterbangpergi,a.kodeterbangpulang,a.rute,a.tanggalpergi,a.tanggalpulang,b.teleponpelanggan FROM travel.ticketing_detail a join ticketing b on a.idticketing = b.idticketing join agent c on b.idagent = c.idagent where a.idticketing = %s" ) cursor = cnx.cursor() cursor.execute(query, (idticketing, )) self.datalist = [] count = 0 for (idagent, namaagen, alamat, telepon, email, parent, username, gambar, active, alamat2, alamat3, kota, firstname, middlename, lastname, salutation, tanggallahir, jenispenumpang, idmaskapaipulang, idmaskapaipergi, kodeterbangpergi, kodeterbangpulang, rute, tanggalpergi, tanggalpulang, teleponpelanggan) in cursor: data = dataticket.dataticket() data.idagent = idagent data.namaagen = namaagen data.alamat = alamat data.telepon = telepon data.email = email data.parent = parent data.username = username data.gambar = gambar data.active = active data.alamat2 = alamat2 data.alamat3 = alamat3 data.kota = kota data.firstname = firstname data.middlename = middlename data.lastname = lastname data.salutation = salutation data.tanggallahir = tanggallahir.isoformat() data.jenispenumpang = jenispenumpang data.idmaskapaipulang = idmaskapaipulang data.idmaskapaipergi = idmaskapaipergi data.kodeterbangpergi = kodeterbangpergi data.kodeterbangpulang = kodeterbangpulang data.rute = rute data.tanggalpergi = tanggalpergi.isoformat() data.tanggalpulang = tanggalpulang.isoformat() #print data.tanggalpergi if count == 0: temp_pattern = self.makepattern(data) self.pattern_pergi = temp_pattern[0] self.pattern_pulang = temp_pattern[1] self.tanggal_awal = data.formattanggal(data.tanggalpergi, "/", False, False) self.tanggal_akhir = data.formattanggal( data.tanggalpulang, "/", False, False) self.origin = data.getrute(0) self.dest = data.getrute(1) if scriptmode == 2: self.origin = data.getrute(1) self.dest = data.getrute(0) self.isoneway = True elif scriptmode == 1: self.isoneway = False else: self.isoneway = True self.teleponpelanggan = teleponpelanggan self.datalist.append(data) count += 1 #origin = sys.argv[4] #dest = sys.argv[5] #isoneway = sys.argv[6] #kodeterbang_pergi = sys.argv[7] #kodeterbang_pulang = sys.argv[8] #jam_pergi = sys.argv[9] #jam_pulang = sys.argv[10] #contactnumber = sys.argv[11] cursor.close() cnx.close() #print self.pattern_pergi #print self.pattern_pulang self.jumlahdewasa = 0 self.jumlahchild = 0 self.jumlahinfant = 0 for penumpang in self.datalist: if penumpang.jenispenumpang == 1: self.jumlahdewasa += 1 elif penumpang.jenispenumpang == 2: self.jumlahchild += 1 else: self.jumlahinfant += 1
def setUp(self): self.driver = webdriver.Firefox() self.driver.implicitly_wait(30) self.base_url = "https://booking.airasia.com/LoginAgent.aspx" self.verificationErrors = [] self.accept_next_alert = True self.kodemaskapai = 10 self.login = "" self.password = "" self.cred = cfg.getloginandpass(self.kodemaskapai) self.login = self.cred[0] self.password = self.cred[1] cnx = mysql.connector.connect(**config) query = ("SELECT c.*,a.firstname,a.middlename,a.lastname,a.salutation,a.tanggallahir, a.jenispenumpang,a.idmaskapaipulang,a.idmaskapaipergi,a.kodeterbangpergi,a.kodeterbangpulang,a.rute,a.tanggalpergi,a.tanggalpulang,b.teleponpelanggan FROM travel.ticketing_detail a join ticketing b on a.idticketing = b.idticketing join agent c on b.idagent = c.idagent where a.idticketing = %s") cursor = cnx.cursor() cursor.execute(query,(idticketing,)) self.datalist = [] count = 0 for (idagent,namaagen,alamat,telepon,email,parent,username,gambar,active,alamat2,alamat3,kota,firstname,middlename,lastname,salutation,tanggallahir,jenispenumpang,idmaskapaipulang,idmaskapaipergi,kodeterbangpergi,kodeterbangpulang,rute,tanggalpergi,tanggalpulang,teleponpelanggan) in cursor: data = dataticket.dataticket() data.idagent = idagent data.namaagen = namaagen data.alamat = alamat data.telepon = telepon data.email = email data.parent = parent data.username = username data.gambar = gambar data.active = active data.alamat2 = alamat2 data.alamat3 = alamat3 data.kota = kota data.firstname = firstname data.middlename = middlename data.lastname = lastname data.salutation = salutation data.tanggallahir = tanggallahir.isoformat() data.jenispenumpang = jenispenumpang data.idmaskapaipulang = idmaskapaipulang data.idmaskapaipergi= idmaskapaipergi data.kodeterbangpergi = kodeterbangpergi data.kodeterbangpulang = kodeterbangpulang data.rute = rute data.tanggalpergi = tanggalpergi.isoformat() data.tanggalpulang = tanggalpulang.isoformat() #print data.tanggalpergi if count == 0: temp_pattern = self.makepattern(data) self.pattern_pergi = temp_pattern[0] self.pattern_pulang = temp_pattern[1] self.tanggal_awal = data.formattanggal(data.tanggalpergi,"/",False,False) self.tanggal_akhir = data.formattanggal(data.tanggalpulang,"/",False,False) self.origin = data.getrute(0) self.dest = data.getrute(1) if scriptmode == 2: self.origin = data.getrute(1) self.dest = data.getrute(0) self.isoneway = True elif scriptmode == 1: self.isoneway = False else: self.isoneway = True self.teleponpelanggan = teleponpelanggan self.datalist.append(data) count += 1 #origin = sys.argv[4] #dest = sys.argv[5] #isoneway = sys.argv[6] #kodeterbang_pergi = sys.argv[7] #kodeterbang_pulang = sys.argv[8] #jam_pergi = sys.argv[9] #jam_pulang = sys.argv[10] #contactnumber = sys.argv[11] cursor.close() cnx.close() #print self.pattern_pergi #print self.pattern_pulang self.jumlahdewasa = 0 self.jumlahchild = 0 self.jumlahinfant = 0 for penumpang in self.datalist : if penumpang.jenispenumpang == 1: self.jumlahdewasa += 1 elif penumpang.jenispenumpang == 2: self.jumlahchild += 1 else: self.jumlahinfant += 1