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 = 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