def search_info(request, slug, all=False):
if not request.user.is_authenticated():
cred = check_creds(request.GET, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), content_type="application/json")
search = get_object_or_404(Searches, key=slug)
purch_date_time = current_time_aware()
search_date_date = search.search_date
"""
if not all:
expired = True if (purch_date_time - search_date_date) > datetime.timedelta(minutes = 60) else False
if expired:
return HttpResponse(json.encode({'success': False, 'error': 'The quoted price has expired or the related contract has already been purchased. Please run a new search.'}), content_type="application/json")
"""
search_dict = search.__dict__
for k, v in search_dict.iteritems():
if isinstance(v,datetime.date):
search_dict[k] = conv_to_js_date(v)
del search_dict['_state']
del search_dict['open_status']
del search_dict['id']
#del search_dict['search_type']
del search_dict['holding_per']
del search_dict['error']
# convert to refund system
#search_dict = refund_format_conversion(search_dict)
search_dict['success'] = True
return HttpResponse(json.encode(search_dict), content_type="application/json")
def test_skyscan(request):
"""
# grid search
url = 'browsegrid/v1.0/GB/GBP/en-GB/LHR/FRA/2013-12/2014-01'
res = call_sky(url, data={}, method='get')
return HttpResponse(json.encode(res), content_type="application/json")
"""
"""
# price caching api - seems to pull cached fare on specific flight
url = 'pricing/v1.0/GB/GBP/en-GB/LHR/FRA/2013-12/2014-01'
res = call_sky(url, method='get')
return HttpResponse(json.encode(res), content_type="application/json")
"""
# create session
url = 'pricing/v1.0'
data = {
'country': 'US',
'currency': 'USD',
'locale': 'en-US',
'originplace': 'SFO',
'destinationplace': 'JFK',
'outbounddate': '2013-12-13',
'inbounddate': '2013-12-20',
'adults': "1",
}
res = call_sky(url, data, method='post')
return HttpResponse(json.encode(res), content_type="application/json")
def test_skyscan(request):
"""
# grid search
url = 'browsegrid/v1.0/GB/GBP/en-GB/LHR/FRA/2013-12/2014-01'
res = call_sky(url, data={}, method='get')
return HttpResponse(json.encode(res), content_type="application/json")
"""
"""
# price caching api - seems to pull cached fare on specific flight
url = 'pricing/v1.0/GB/GBP/en-GB/LHR/FRA/2013-12/2014-01'
res = call_sky(url, method='get')
return HttpResponse(json.encode(res), content_type="application/json")
"""
# create session
url = 'pricing/v1.0'
data = {
'country': 'US',
'currency': 'USD',
'locale': 'en-US',
'originplace': 'SFO',
'destinationplace': 'JFK',
'outbounddate': '2013-12-13',
'inbounddate': '2013-12-20',
'adults': "1",
}
res = call_sky(url, data, method='post')
return HttpResponse(json.encode(res), content_type="application/json")
def test_flight_search(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), content_type="application/json")
form = flight_search_form(request.POST)
if form.is_valid():
cd = form.cleaned_data
res = run_flight_search(cd['origin_code'], cd['destination_code'], cd['depart_date1'], cd['return_date1'], cd['depart_times'], cd['return_times'], cd['convenience'], airlines=cd['airlines'], cached=False)
#return HttpResponse(json.encode(res), mimetype="application/json")
build = {'form': form, 'results': res}
else:
build = {'results': {'success': False, 'error': "Invalid inputs."}}
else:
form = flight_search_form()
combined_results = None
build = {'form': form, 'results': combined_results}
return gen_search_display(request, build, clean, method='post')
def promo_details(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
form = PromoDetail(inputs)
build = {'form': form}
if (inputs) and form.is_valid():
cd = form.cleaned_data
try:
find_platform = Platform.objects.get(key=cd['platform_key'])
find_cust = Customer.objects.get(email=cd['email'], platform=find_platform)
find_promo = Promo.objects.get(customer=find_cust, code=cd['code'])
if find_promo.contract:
raise Exception("Promotional code already used.")
except (Customer.DoesNotExist):
build['error_message'] = 'The customer is not registered.'
build['results'] = {'success': False, 'error': 'The customer is not registered.'}
except (Promo.DoesNotExist):
build['error_message'] = 'The promo code is not valid.'
build['results'] = {'success': False, 'error': 'The promo code is not valid.'}
except (Exception) as err:
build['error_message'] = '%s' % err
build['results'] = {'success': False, 'error': '%s' % err}
else:
results = find_promo.__dict__
for i in ('id', 'contract_id', 'customer_id', '_state'):
if i in results:
del results[i]
if 'created_date' in results:
results['created_date'] = str(results['created_date'])
build['results'] = results
build['results']['success'] = True
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (error[0], unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
def test_wan(request):
url = 'searches'
data = {
"trips": [{
"departure_code": "SIN",
"arrival_code": "HKG",
"outbound_date": "2013-11-13",
"inbound_date": "2013-11-20"
}],
"adults_count":
1
}
res = call_wan(url, data, method='post')
return HttpResponse(json.encode(res), content_type="application/json")
def gen_search_display(request, build, clean, method=None):
if 'results' in build:
if type(build['results']) is list:
build['results'] = build['results'][0]
if clean:
if 'results' in build:
return HttpResponse(json.encode(build['results']), mimetype="application/json")
else:
return render_to_response('blank.html')
else:
if method == 'post':
return render_to_response('general_form_post.html', build, context_instance=RequestContext(request))
else:
return render_to_response('general_form.html', build, context_instance=RequestContext(request))
def search_info(request, slug, all=False):
if not request.user.is_authenticated():
cred = check_creds(request.GET, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred),
content_type="application/json")
search = get_object_or_404(Searches, key=slug)
purch_date_time = current_time_aware()
search_date_date = search.search_date
"""
if not all:
expired = True if (purch_date_time - search_date_date) > datetime.timedelta(minutes = 60) else False
if expired:
return HttpResponse(json.encode({'success': False, 'error': 'The quoted price has expired or the related contract has already been purchased. Please run a new search.'}), content_type="application/json")
"""
search_dict = search.__dict__
for k, v in search_dict.iteritems():
if isinstance(v, datetime.date):
search_dict[k] = conv_to_js_date(v)
del search_dict['_state']
del search_dict['open_status']
del search_dict['id']
#del search_dict['search_type']
del search_dict['holding_per']
del search_dict['error']
# convert to refund system
#search_dict = refund_format_conversion(search_dict)
search_dict['success'] = True
return HttpResponse(json.encode(search_dict),
content_type="application/json")
def test_wan(request):
url = 'searches'
data = {
"trips": [
{
"departure_code": "SIN",
"arrival_code": "HKG",
"outbound_date": "2013-11-13",
"inbound_date": "2013-11-20"
}
],
"adults_count": 1
}
res = call_wan(url, data, method='post')
return HttpResponse(json.encode(res), content_type="application/json")
def send_request(url, data={}, headers=None, method='get'):
try:
url_values = urllib.urlencode(data)
if method == 'get':
url = url + '?' + url_values
data = urllib2.urlopen(url)
elif method == 'post':
if headers:
if headers['Content-Type'] == 'application/json':
if 'query_params' in data:
url_values = urllib.urlencode(data['query_params'])
url = url + '?' + url_values
del data['query_params']
url_values = json.encode(data)
req = urllib2.Request(url, url_values, headers)
else:
req = urllib2.Request(url, url_values)
data = urllib2.urlopen(req)
else:
raise Exception("Impropper method: '%s'" % method)
return {'success': True, 'response': json.decode(data.read())}
except urllib2.HTTPError as e:
return {
'success':
False,
'error':
"The server couldn't fulfill the request: %s - %s" %
(e.code, e.reason)
}
except urllib2.URLError as e:
return {
'success': False,
'error': "We failed to reach a server: %s" % (e.reason)
}
except Exception as err:
return {'success': False, 'error': str(err)}
def test_google(request):
data = {
"request": {
"passengers": {
"adultCount": 1
},
"slice": [{
"origin": "BOS",
"destination": "LAX",
"date": "2014-04-05"
}, {
"origin": "LAX",
"destination": "BOS",
"date": "2014-04-10"
}]
}
}
res = call_google(data)
return HttpResponse(json.encode(res), content_type="application/json")
def test_flight_search(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred),
content_type="application/json")
form = flight_search_form(request.POST)
if form.is_valid():
cd = form.cleaned_data
res = run_flight_search(cd['origin_code'],
cd['destination_code'],
cd['depart_date1'],
cd['return_date1'],
cd['depart_times'],
cd['return_times'],
cd['convenience'],
airlines=cd['airlines'],
cached=False)
#return HttpResponse(json.encode(res), mimetype="application/json")
build = {'form': form, 'results': res}
else:
build = {'results': {'success': False, 'error': "Invalid inputs."}}
else:
form = flight_search_form()
combined_results = None
build = {'form': form, 'results': combined_results}
return gen_search_display(request, build, clean, method='post')
def test_google(request):
data = {
"request": {
"passengers": {
"adultCount": 1
},
"slice": [
{
"origin": "BOS",
"destination": "LAX",
"date": "2014-04-05"
},
{
"origin": "LAX",
"destination": "BOS",
"date": "2014-04-10"
}
]
}
}
res = call_google(data)
return HttpResponse(json.encode(res), content_type="application/json")
def send_request(url, data={}, headers=None, method='get'):
try:
url_values = urllib.urlencode(data)
if method == 'get':
url = url + '?' + url_values
data = urllib2.urlopen(url)
elif method == 'post':
if headers:
if headers['Content-Type'] == 'application/json':
if 'query_params' in data:
url_values = urllib.urlencode(data['query_params'])
url = url + '?' + url_values
del data['query_params']
url_values = json.encode(data)
req = urllib2.Request(url, url_values, headers)
else:
req = urllib2.Request(url, url_values)
data = urllib2.urlopen(req)
else:
raise Exception("Impropper method: '%s'" % method)
return {'success': True, 'response': json.decode(data.read())}
except urllib2.HTTPError as e:
return {'success': False, 'error': "The server couldn't fulfill the request: %s - %s" % (e.code, e.reason)}
except urllib2.URLError as e:
return {'success': False, 'error': "We failed to reach a server: %s" % (e.reason)}
except Exception as err:
return {'success': False, 'error': str(err)}
def hubs(request):
res = Routes.objects.values("org_code").distinct()
bank = [i['org_code'] for i in res]
bank.sort()
return HttpResponse(json.encode({'hubs': bank}), mimetype="application/json")
def price_edu_combo(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), content_type="application/json")
form = full_option_info(request.POST)
build = {'form': form}
if form.is_valid():
cd = form.cleaned_data
#inp_errors = sim_errors(self.db, cd['origin_code'], cd['destination_code'],self.lockin_per,self.start_date,self.d_date1,self.d_date2,self.r_date1,self.r_date2,self.final_proj_week, self.max_trip_length, self.geography)
open_status = Open.objects.get(pk=1)
current_time = current_time_aware()
current_date = current_time.date()
general = {'search_date': current_time, 'open_status': open_status.get_status(), 'key': gen_alphanum_key(),}
model_in = {'origin_code': cd['origin_code'],
'destination_code': cd['destination_code'],
'holding_per': cd['holding_per'],
'depart_date1': str(cd['depart_date1']),
'depart_date2': str(cd['depart_date2']),
'return_date1': str(cd['return_date1']),
'return_date2': str(cd['return_date2']),
'search_type': 'rt',
'depart_times': cd['depart_times'],
'return_times': cd['return_times'],
'convenience': cd['convenience'],
'airlines': cd['airlines']}
combined = dict(general.items() + model_in.items())
if open_status.get_status():
if (cd['depart_date2'] - cd['depart_date1']).days > 2 or (cd['return_date2'] - cd['return_date1']).days > 2:
model_out = {'error': 'Travel date ranges must not be more than two days in length'}
elif (cd['depart_date2'] < cd['depart_date1']) or (cd['return_date2'] < cd['return_date1']):
model_out = {'error': 'Travel date ranges are wrong'}
elif (cd['depart_date1'] - datetime.timedelta(days=13)) < (current_date + datetime.timedelta(days=(cd['holding_per']*7))):
model_out = {'error': 'Cannot purchase fare protection valid closer than two weeks to departure.'}
else:
flights = pull_fares_range(cd['origin_code'], cd['destination_code'], (cd['depart_date1'], cd['depart_date2']), (cd['return_date1'], cd['return_date2']), cd['depart_times'], cd['return_times'], cd['convenience'], cd['airlines'], search_key=combined['key'])
#return HttpResponse(json.encode(flights), content_type="application/json")
if flights['success']:
#prices = calc_price(cd['origin_code'], cd['destination_code'], flights['fares'], cd['holding_per']*7, [cd['depart_date1'],cd['depart_date2']], [cd['return_date1'],cd['return_date2']], general['search_date'])
prices = calc_price(cd['origin_code'], cd['destination_code'], flights['fares'], cd['holding_per']*7, general['search_date'])
model_out = {'holding_price': prices['holding_price'], 'locked_fare': prices['locked_fare'], 'expected_risk': prices['expected_risk'],
'exp_date': prices['exp_date'], 'total_flexibility': prices['total_flexibility'], 'time_to_departure': prices['time_to_departure'], 'error': prices['error'] }
else:
model_out = {'error': flights['error']}
else:
model_out = {'error': 'Due to high demand, we are currently not making any additional sales. Please check again later.'}
# save in model
combined.update(model_out.items())
search_params = Searches(**combined)
search_params.save()
search_key = search_params.key
# add current flight list if no errors and 'show_flights' is true
if not model_out['error']:
pass
#model_out = refund_format_conversion(model_out)
#combined_results = {'pricing_results': model_out, 'context': 'this flight gets expensive fast', 'inputs': model_in, 'key': search_key,}
combined_results = {'pricing_results': model_out, 'inputs': model_in, 'key': search_key,}
# convert all dates into js time-stamp
date_bank = {}
for i in ('inputs', 'pricing_results'):
date_bank[i] = {}
for k, v in combined_results[i].iteritems():
try:
date = parse(v)
combined_results[i][k] = conv_to_js_date(date)
date_bank[i]["%s_readable" % (k)] = v
except:
pass
if date_bank:
for i in ('inputs', 'pricing_results'):
combined_results[i].update(date_bank[i])
if not model_out['error']:
combined_results.update({'success': True})
#combined_results['raw'] = flights
#return HttpResponse(json.encode(combined_results), content_type="application/json")
#if cd['disp_depart_date'] and cd['disp_return_date']:
# combined_results.update({'flights': flights['flights']})
else:
# checks for short error if generated in pull_fares_range function
try:
err = flights['short_error']
except:
err = model_out['error']
combined_results.update({'success': False, 'error': err})
build = {'form': form, 'results': combined_results}
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (error[0], unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
else:
form = full_option_info()
combined_results = None
build = {'form': form, 'results': combined_results}
return gen_search_display(request, build, clean, method='post')
def hello(request):
url = "https://www.google.com/"
ex = {'url': url}
return HttpResponse(json.encode(ex), mimetype="application/json")
def pairs(request):
res = Routes.objects.all().order_by('org_code', 'dest_code')
bank = [{'hub': i.org_code, 'destination': i.dest_code} for i in res]
return HttpResponse(json.encode({'pairs': bank}),
mimetype="application/json")
def sweep_expired(request):
"""
@summary: run this daily to find prices on searches that expired within 24 hours
this will help with analysis and model building
cycle through recently expired options
"""
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), content_type="application/json")
# ensure this query is not run more than once/24hrs
current_time = current_time_aware()
run_dates = ExpiredSearchPriceCheck.objects
if not run_dates.exists() or (current_time - run_dates.latest('run_date').run_date) >= datetime.timedelta(hours=23):
latest_price_check = ExpiredSearchPriceCheck(run_date=current_time)
latest_price_check.save()
# pull searches expiring in last 24 hours
yesterday = current_time - datetime.timedelta(days=1)
recent_expired = Searches.objects.filter(exp_date__range=[yesterday, current_time])
# check expired demos
exp_demo_query = Demo.objects.filter(search__exp_date__range=[yesterday, current_time])
demo_keys = [str(i.search.key) for i in exp_demo_query]
# run flight search query on each recently expired option
expired_searches = []
expired_demos = []
for i in recent_expired:
flights = pull_fares_range(i.origin_code, i.destination_code, (i.depart_date1, i.depart_date2), (i.return_date1, i.return_date2), i.depart_times, i.return_times, i.convenience, i.airlines, cached=True)
expired_searches.append({'search': i.key, 'success': flights['success']})
# check if search relates to an expired demo contract, if so, check if customer would have saved money
if i.key in demo_keys and flights['success']:
savings_string = ""
for j in flights['fares']:
savings = math.floor(float(j['fare']) - i.locked_fare)
# don't alert customer of savings unless greater than X dollars
if savings >= 10:
"""
dep_flights = " | ".join(["%s %s" % (k['airline_short_name'], k['flight_number']) for k in j['flight']['departing']['detail']])
ret_flights = " | ".join(["%s %s" % (k['airline_short_name'], k['flight_number']) for k in j['flight']['returning']['detail']])
dep_datetime = parse(j['flight']['departing']['take_off_time']).strftime("%B %d, %Y at %I:%M%p")
ret_datetime = parse(j['flight']['returning']['take_off_time']).strftime("%B %d, %Y at %I:%M%p")
savings_string += "$%s departing %s on %s \nand returning %s on %s\n\n" % (savings, dep_datetime, dep_flights, ret_datetime, ret_flights)
"""
dep_datetime = parse(j['flight']['departing']['take_off_time']).strftime("%B %d, %Y")
ret_datetime = parse(j['flight']['returning']['take_off_time']).strftime("%B %d, %Y")
savings_string += "$%s departing %s and returning %s\n\n" % (savings, dep_datetime, ret_datetime)
# send customer email describing potential savings if savings were possible
if savings_string:
try:
title = "Here's what you could have saved by buying a Flex Fare"
body = "Thanks for checking out Level Skies and for taking a closer look at the Flex Fare. You previously signed up for a trial run of the Flex Fare and now we're hear to show you what could have happened had you actually made the purchase. Prices on the flights you were looking at went up, as they tend to do! Here are the potential savings that would have been available to you:\n\n"
body += savings_string + "\n\nWe hope you check in with us again soon becasue we'd love to save you some real cash!\n\nThe Level Skies Team"
email_address = exp_demo_query.get(search__key=i.key).customer.email
send_template_email(email_address, 'Flex Fare Trial', title, body)
except:
pass
expired_demos.append({'search': i.key, 'savings': True if savings_string else False})
# check fares on open contracts
contracts_query = Contract.objects.filter(search__exp_date__gt=current_time, ex_date=None)
open_contracts = []
for i in contracts_query:
flights = pull_fares_range(i.search.origin_code, i.search.destination_code, (i.search.depart_date1, i.search.depart_date2), (i.search.return_date1, i.search.return_date2), i.search.depart_times, i.search.return_times, i.search.convenience, i.search.airlines, cached=True)
open_contracts.append({'search': i.search.key, 'success': flights['success']})
duration = current_time_aware() - current_time
results = {'success': True, 'time_run': str(current_time), 'expired_demos': expired_demos, 'expired_searches': expired_searches, 'open_contracts': open_contracts, 'duration': str(duration), 'count': recent_expired.count()}
# send email to sysadmin summarizing expired searches
#if MODE == 'live':
try:
searches_email_string = ""
for i in expired_searches:
searches_email_string += "%s : %s\n" % (i['search'], i['success'])
contracts_email_string = ""
for i in open_contracts:
contracts_email_string += "%s : %s\n" % (i['search'], i['success'])
demos_email_string = ""
for i in expired_demos:
demos_email_string += "%s : %s\n" % (i['search'], i['savings'])
email_body = 'Completed flight search for %s expired searches with duration of %s.\n\nSearch Key : Success status\n%s\n\n' % (results['count'], results['duration'], searches_email_string)
email_body += 'Completed %s open contracts.\n\nSearch Key : Success status\n%s\n\n' % (len(open_contracts), contracts_email_string)
email_body += 'Completed %s expired demos.\n\nSearch Key : Savings\n%s' % (len(expired_demos), demos_email_string)
send_mail('Expired searches price check',
email_body,
'*****@*****.**',
['*****@*****.**'],
fail_silently=False)
except:
pass
else:
results = {'success': False, 'error': 'Expired search price check ran within last 24 hours.'}
return gen_search_display(request, {'results': results}, clean)
def display_current_flights(request, slug, convert=False):
"""
@summary: use this to find flights associated with a particular search_key
if convert - must supply two travel dates and one flight search will be provided
if not convert - this will automatically return all flights in the date ranges searched, trying cached searches first
"""
inputs = request.GET if request.GET else None
if not request.user.is_authenticated():
cred = check_creds(inputs, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred),
content_type="application/json")
try:
search = Searches.objects.get(key=slug)
if convert:
form = flights_display(inputs)
if not form.is_valid():
raise Exception(
"Valid travel dates not provided: depart_date & return_date"
)
# raise error if contract is not outstanding or has already been marked for staging process
contract = Contract.objects.get(search__key=slug)
if not contract.outstanding() or contract.staged():
raise Exception(
"This contract is no longer valid or has already been converted."
)
cd = form.cleaned_data
if (search.depart_date1 > cd['depart_date']) or (
cd['depart_date'] > search.depart_date2) or (
search.return_date1 > cd['return_date']) or (
cd['return_date'] > search.return_date2):
raise Exception(
'Selected travel dates not within locked fare range.')
# run search and format results
res = run_flight_search(search.origin_code,
search.destination_code,
cd['depart_date'],
cd['return_date'],
search.depart_times,
search.return_times,
search.convenience,
search.airlines,
slug,
cached=False)
if not res['success']:
raise Exception(
"Could not return list of current available flights: %s" %
(res['error']))
if res['min_fare'] > search.locked_fare:
res['payout'] = res['min_fare'] - search.locked_fare
else:
res['payout'] = 0
"""
# converts prices to rebate values and caps the price level of flights available to choose from
bank = []
cap = None
for index, i in enumerate(res['flights']):
add = False
if not cap:
add = True
if index == 0:
if i['fare'] < search.locked_fare:
cap = search.locked_fare
else:
if i['fare'] > search.locked_fare:
cap = i['fare']
else:
if i['fare'] <= cap + 5:
add = True
if add:
if i['fare'] < search.locked_fare:
#res['flights'][index]['rebate'] = search.locked_fare - i['fare']
res['flights'][index]['rebate'] = None
else:
res['flights'][index]['rebate'] = None
del res['flights'][index]['fare']
bank.append(res['flights'][index])
res['flights'] = bank
"""
else:
# raise error if id selected exists but refers to an search that resulted in an error or took place when no options were available for sale
# or the purchase occured after too much time had passed, and the quoted price is deemed expired
purch_date_time = current_time_aware()
search_date_date = search.search_date
expired = True if (purch_date_time -
search_date_date) > datetime.timedelta(
minutes=60) else False
if search.error or not search.get_status() or expired:
raise Exception(
"The search is expired, had an error, or was made while sales were shut off"
)
# run search and format data
res = {'success': True}
error = ""
dep_range = (search.depart_date2 - search.depart_date1).days
ret_range = (search.return_date2 - search.return_date1).days
# build empty list of fares for each flight date combination
for i in range(dep_range + 1):
depart_date = search.depart_date1 + datetime.timedelta(days=i)
for k in range(ret_range + 1):
return_date = search.return_date1 + datetime.timedelta(
days=k)
one_res = run_flight_search(search.origin_code,
search.destination_code,
depart_date,
return_date,
search.depart_times,
search.return_times,
search.convenience,
search.airlines,
slug,
cached=True)
res['%s-%s' % (depart_date, return_date)] = one_res
if not one_res['success']:
res['success'] = False
error += '%s-%s: %s ' % (depart_date, return_date,
one_res['error'])
if not res['success']:
res['error'] = error
except (Contract.DoesNotExist):
res = {
'success': False,
'error': 'The contract key entered is not valid.'
}
except (Searches.DoesNotExist):
res = {
'success': False,
'error': 'The search key entered is not valid.'
}
except Exception as err:
res = {'success': False, 'error': str(err)}
return HttpResponse(json.encode(res), content_type="application/json")
def dests(request, slug):
res = Routes.objects.filter(org_code=slug).values("dest_code")
bank = [i['dest_code'] for i in res]
bank.sort()
return HttpResponse(json.encode({'destinations': bank}),
mimetype="application/json")
def dests(request, slug):
res = Routes.objects.filter(org_code=slug).values("dest_code")
bank = [i['dest_code'] for i in res]
bank.sort()
return HttpResponse(json.encode({'destinations': bank}), mimetype="application/json")
def contest(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
contest_length = 1
promotion_value = 500
current_time = current_time_aware()
try:
filt_date = (current_time -
datetime.timedelta(days=contest_length + 1))
contest = Contest.objects.filter(expire_date__gte=filt_date)
if contest:
contest = contest.latest('expire_date')
if contest.expire_date < current_time:
contest = None
# create new contest none exist or most recent has expired
if not contest:
# select route
origins = ['SFO', 'LAX', 'JFK', 'PHL', 'ORD']
destinations = [
'SFO', 'LAX', 'JFK', 'PHL', 'ATL', 'BOS', 'ORD', 'DFW', 'SAN',
'IAD'
]
origin = random.choice(origins)
if origin in destinations:
destinations.remove(origin)
destination = random.choice(destinations)
# select decision time
decision_times = [
1,
2,
]
decision_time = random.choice(decision_times)
# select travel dates
current_date = current_time.date()
depart_date = current_date + datetime.timedelta(days=(
(decision_time * 7) + random.randrange(14, 60)))
return_date = depart_date + datetime.timedelta(
days=random.randrange(2, 20))
contest = Contest(
key=gen_alphanum_key(),
created_date=current_time,
expire_date=(current_time +
datetime.timedelta(days=contest_length)),
origin_code=origin,
destination_code=destination,
decision_time=decision_time,
depart_date=depart_date,
return_date=return_date,
value=promotion_value)
contest.save()
# add try except if can't create contest
results = contest.__dict__
for i in ('id', '_state'):
if i in results:
del results[i]
if not contest:
raise Exception(
'No contest currently available. Please check again shortly')
# build list of current flights
res = run_flight_search(contest.origin_code,
contest.destination_code,
contest.depart_date,
contest.return_date,
'any',
'any',
'any',
'any',
cached=True)
if res['success']:
for i in ('success', 'min_flight', 'airlines'):
del res[i]
results['flights'] = res
#return HttpResponse(json.encode(res), content_type="application/json")
else:
raise Exception(
'No contest currently available. Please check again shortly')
results['success'] = True
except Exception as err:
results = {'success': False, 'error': err}
# format date types for json
for k, v in results.iteritems():
if isinstance(v, (datetime.date, datetime.datetime)):
results[k] = str(v)
#return HttpResponse(json.encode(results), content_type="application/json")
return gen_search_display(request, {'results': results},
clean,
method='post')
def contest(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
contest_length = 1
promotion_value = 500
current_time = current_time_aware()
try:
filt_date = (current_time-datetime.timedelta(days=contest_length+1))
contest = Contest.objects.filter(expire_date__gte=filt_date)
if contest:
contest = contest.latest('expire_date')
if contest.expire_date < current_time:
contest = None
# create new contest none exist or most recent has expired
if not contest:
# select route
origins = ['SFO', 'LAX', 'JFK', 'PHL', 'ORD']
destinations = ['SFO', 'LAX', 'JFK', 'PHL', 'ATL', 'BOS', 'ORD', 'DFW', 'SAN', 'IAD']
origin = random.choice(origins)
if origin in destinations:
destinations.remove(origin)
destination = random.choice(destinations)
# select decision time
decision_times = [1,2,]
decision_time = random.choice(decision_times)
# select travel dates
current_date = current_time.date()
depart_date = current_date + datetime.timedelta(days=((decision_time*7)+ random.randrange(14,60)))
return_date = depart_date + datetime.timedelta(days=random.randrange(2,20))
contest = Contest(key=gen_alphanum_key(),
created_date=current_time,
expire_date=(current_time + datetime.timedelta(days=contest_length)),
origin_code=origin,
destination_code=destination,
decision_time=decision_time,
depart_date=depart_date,
return_date=return_date,
value=promotion_value)
contest.save()
# add try except if can't create contest
results = contest.__dict__
for i in ('id', '_state'):
if i in results:
del results[i]
if not contest:
raise Exception('No contest currently available. Please check again shortly')
# build list of current flights
res = run_flight_search(contest.origin_code, contest.destination_code, contest.depart_date, contest.return_date, 'any', 'any', 'any', 'any', cached=True)
if res['success']:
for i in ('success', 'min_flight', 'airlines'):
del res[i]
results['flights'] = res
#return HttpResponse(json.encode(res), content_type="application/json")
else:
raise Exception('No contest currently available. Please check again shortly')
results['success'] = True
except Exception as err:
results = {'success': False, 'error': err}
# format date types for json
for k, v in results.iteritems():
if isinstance(v, (datetime.date, datetime.datetime)):
results[k] = str(v)
#return HttpResponse(json.encode(results), content_type="application/json")
return gen_search_display(request, {'results': results}, clean, method='post')
def display_current_flights(request, slug, convert=False):
"""
@summary: use this to find flights associated with a particular search_key
if convert - must supply two travel dates and one flight search will be provided
if not convert - this will automatically return all flights in the date ranges searched, trying cached searches first
"""
inputs = request.GET if request.GET else None
if not request.user.is_authenticated():
cred = check_creds(inputs, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), content_type="application/json")
try:
search = Searches.objects.get(key=slug)
if convert:
form = flights_display(inputs)
if not form.is_valid():
raise Exception("Valid travel dates not provided: depart_date & return_date")
# raise error if contract is not outstanding or has already been marked for staging process
contract = Contract.objects.get(search__key=slug)
if not contract.outstanding() or contract.staged():
raise Exception("This contract is no longer valid or has already been converted.")
cd = form.cleaned_data
if (search.depart_date1 > cd['depart_date']) or (cd['depart_date'] > search.depart_date2) or (search.return_date1 > cd['return_date']) or (cd['return_date'] > search.return_date2):
raise Exception('Selected travel dates not within locked fare range.')
# run search and format results
res = run_flight_search(search.origin_code, search.destination_code, cd['depart_date'], cd['return_date'], search.depart_times, search.return_times, search.convenience, search.airlines, slug, cached=False)
if not res['success']:
raise Exception("Could not return list of current available flights: %s" % (res['error']))
if res['min_fare'] > search.locked_fare:
res['payout'] = res['min_fare'] - search.locked_fare
else:
res['payout'] = 0
"""
# converts prices to rebate values and caps the price level of flights available to choose from
bank = []
cap = None
for index, i in enumerate(res['flights']):
add = False
if not cap:
add = True
if index == 0:
if i['fare'] < search.locked_fare:
cap = search.locked_fare
else:
if i['fare'] > search.locked_fare:
cap = i['fare']
else:
if i['fare'] <= cap + 5:
add = True
if add:
if i['fare'] < search.locked_fare:
#res['flights'][index]['rebate'] = search.locked_fare - i['fare']
res['flights'][index]['rebate'] = None
else:
res['flights'][index]['rebate'] = None
del res['flights'][index]['fare']
bank.append(res['flights'][index])
res['flights'] = bank
"""
else:
# raise error if id selected exists but refers to an search that resulted in an error or took place when no options were available for sale
# or the purchase occured after too much time had passed, and the quoted price is deemed expired
purch_date_time = current_time_aware()
search_date_date = search.search_date
expired = True if (purch_date_time - search_date_date) > datetime.timedelta(minutes = 60) else False
if search.error or not search.get_status() or expired:
raise Exception("The search is expired, had an error, or was made while sales were shut off")
# run search and format data
res = {'success': True}
error = ""
dep_range = (search.depart_date2 - search.depart_date1).days
ret_range = (search.return_date2 - search.return_date1).days
# build empty list of fares for each flight date combination
for i in range(dep_range + 1):
depart_date = search.depart_date1 + datetime.timedelta(days=i)
for k in range(ret_range + 1):
return_date = search.return_date1 + datetime.timedelta(days=k)
one_res = run_flight_search(search.origin_code, search.destination_code, depart_date, return_date, search.depart_times, search.return_times, search.convenience, search.airlines, slug, cached=True)
res['%s-%s' % (depart_date, return_date)] = one_res
if not one_res['success']:
res['success'] = False
error += '%s-%s: %s ' % (depart_date, return_date, one_res['error'])
if not res['success']:
res['error'] = error
except (Contract.DoesNotExist):
res = {'success': False, 'error': 'The contract key entered is not valid.'}
except (Searches.DoesNotExist):
res = {'success': False, 'error': 'The search key entered is not valid.'}
except Exception as err:
res = {'success': False, 'error': str(err)}
return HttpResponse(json.encode(res), content_type="application/json")
def close_contests(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
current_time = current_time_aware()
yesterday = current_time - datetime.timedelta(days=1)
contests = Contest.objects.filter(closed=False)
contest_data = []
for i in contests:
if i.end_price_date() < current_time and i.end_price_date(
) >= yesterday:
contest_meta_data = {'key': i.key}
subs = Submission.objects.filter(
contest=i).order_by('created_date')
contest_meta_data['subs'] = subs.count()
if subs:
# build list of current flights
res = run_flight_search(i.origin_code,
i.destination_code,
i.depart_date,
i.return_date,
'any',
'any',
'any',
'any',
cached=True)
if res['success']:
#return HttpResponse(json.encode(res), mimetype="application/json")
i.end_price = res['min_fare']
if not i.end_price:
i.closed = True
i.save()
else:
try:
# find earliest-closest entry
closest = None
for k in subs:
dif = abs(k.value - i.end_price)
if not closest:
closest = (k, dif)
else:
if dif < closest[1]:
closest = (k, dif)
# create promo for this user
new_promo = Promo(customer=closest[0].customer,
created_date=current_time,
value=i.value,
code=gen_alphanum_key())
new_promo.save()
# send email
subject = "You won the fare prediction contest!"
title = "Dang, you are good."
body = "You may remember entering a fare prediction contest on %s. We told you we'd let you know if your guess was closest to the actual fare and here we are. Also as promised, here's a promo code which let's you buy a Flex Fare for just $1:\n\n%s\n\nThe Level Skies Team" % (
closest[0].created_date.strftime("%B %d"),
new_promo.code)
try:
send_template_email(closest[0].customer.email, subject,
title, body)
except:
pass
# close contest
i.closed = True
i.save()
except Exception as err:
contest_meta_data['error'] = err
contest_data.append(contest_meta_data)
results = {'success': True, 'contest_data': contest_data}
return gen_search_display(request, {'results': results},
clean,
method='post')
def price_edu_combo(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred),
content_type="application/json")
form = full_option_info(request.POST)
build = {'form': form}
if form.is_valid():
cd = form.cleaned_data
#inp_errors = sim_errors(self.db, cd['origin_code'], cd['destination_code'],self.lockin_per,self.start_date,self.d_date1,self.d_date2,self.r_date1,self.r_date2,self.final_proj_week, self.max_trip_length, self.geography)
open_status = Open.objects.get(pk=1)
current_time = current_time_aware()
current_date = current_time.date()
general = {
'search_date': current_time,
'open_status': open_status.get_status(),
'key': gen_alphanum_key(),
}
model_in = {
'origin_code': cd['origin_code'],
'destination_code': cd['destination_code'],
'holding_per': cd['holding_per'],
'depart_date1': str(cd['depart_date1']),
'depart_date2': str(cd['depart_date2']),
'return_date1': str(cd['return_date1']),
'return_date2': str(cd['return_date2']),
'search_type': 'rt',
'depart_times': cd['depart_times'],
'return_times': cd['return_times'],
'convenience': cd['convenience'],
'airlines': cd['airlines']
}
combined = dict(general.items() + model_in.items())
if open_status.get_status():
if (cd['depart_date2'] - cd['depart_date1']).days > 2 or (
cd['return_date2'] - cd['return_date1']).days > 2:
model_out = {
'error':
'Travel date ranges must not be more than two days in length'
}
elif (cd['depart_date2'] < cd['depart_date1']) or (
cd['return_date2'] < cd['return_date1']):
model_out = {'error': 'Travel date ranges are wrong'}
elif (cd['depart_date1'] - datetime.timedelta(days=13)) < (
current_date +
datetime.timedelta(days=(cd['holding_per'] * 7))):
model_out = {
'error':
'Cannot purchase fare protection valid closer than two weeks to departure.'
}
else:
flights = pull_fares_range(
cd['origin_code'],
cd['destination_code'],
(cd['depart_date1'], cd['depart_date2']),
(cd['return_date1'], cd['return_date2']),
cd['depart_times'],
cd['return_times'],
cd['convenience'],
cd['airlines'],
search_key=combined['key'])
#return HttpResponse(json.encode(flights), content_type="application/json")
if flights['success']:
#prices = calc_price(cd['origin_code'], cd['destination_code'], flights['fares'], cd['holding_per']*7, [cd['depart_date1'],cd['depart_date2']], [cd['return_date1'],cd['return_date2']], general['search_date'])
prices = calc_price(cd['origin_code'],
cd['destination_code'],
flights['fares'],
cd['holding_per'] * 7,
general['search_date'])
model_out = {
'holding_price': prices['holding_price'],
'locked_fare': prices['locked_fare'],
'expected_risk': prices['expected_risk'],
'exp_date': prices['exp_date'],
'total_flexibility': prices['total_flexibility'],
'time_to_departure': prices['time_to_departure'],
'error': prices['error']
}
else:
model_out = {'error': flights['error']}
else:
model_out = {
'error':
'Due to high demand, we are currently not making any additional sales. Please check again later.'
}
# save in model
combined.update(model_out.items())
search_params = Searches(**combined)
search_params.save()
search_key = search_params.key
# add current flight list if no errors and 'show_flights' is true
if not model_out['error']:
pass
#model_out = refund_format_conversion(model_out)
#combined_results = {'pricing_results': model_out, 'context': 'this flight gets expensive fast', 'inputs': model_in, 'key': search_key,}
combined_results = {
'pricing_results': model_out,
'inputs': model_in,
'key': search_key,
}
# convert all dates into js time-stamp
date_bank = {}
for i in ('inputs', 'pricing_results'):
date_bank[i] = {}
for k, v in combined_results[i].iteritems():
try:
date = parse(v)
combined_results[i][k] = conv_to_js_date(date)
date_bank[i]["%s_readable" % (k)] = v
except:
pass
if date_bank:
for i in ('inputs', 'pricing_results'):
combined_results[i].update(date_bank[i])
if not model_out['error']:
combined_results.update({'success': True})
#combined_results['raw'] = flights
#return HttpResponse(json.encode(combined_results), content_type="application/json")
#if cd['disp_depart_date'] and cd['disp_return_date']:
# combined_results.update({'flights': flights['flights']})
else:
# checks for short error if generated in pull_fares_range function
try:
err = flights['short_error']
except:
err = model_out['error']
combined_results.update({'success': False, 'error': err})
build = {'form': form, 'results': combined_results}
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (
error[0],
unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
else:
form = full_option_info()
combined_results = None
build = {'form': form, 'results': combined_results}
return gen_search_display(request, build, clean, method='post')
def make_submission(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
form = ContestSubmissionForm(inputs)
build = {'form': form}
if (inputs) and form.is_valid():
cd = form.cleaned_data
try:
find_platform = Platform.objects.get(key=cd['platform_key'])
find_contest = Contest.objects.get(key=cd['contest_key'])
# either find the existing customer associated with the platform and email addres or create it
try:
find_cust = Customer.objects.get(email=cd['email'], platform=find_platform)
except:
inps = {}
inps['key'] = gen_alphanum_key()
inps['reg_date'] = current_time_aware().date()
inps['platform'] = find_platform
inps['email'] = cd['email']
find_cust = Customer(**inps)
find_cust.save()
find_cust.create_highrise_account()
find_cust.add_highrise_tag('contest')
try:
sub = Submission.objects.get(customer=find_cust, contest=find_contest)
except:
sub = Submission(contest=find_contest, customer=find_cust, created_date=current_time_aware(), value=cd['value'])
sub.save()
else:
raise Exception("A submission has already been made to this contest with this email address.")
except (Contest.DoesNotExist):
build['error_message'] = 'The contest key entered is not valid.'
build['results'] = {'success': False, 'error': 'The contest key entered is not valid.'}
except (Exception) as err:
build['error_message'] = '%s' % err
build['results'] = {'success': False, 'error': 'Could not record your entry. %s' % err}
else:
# send email if subission successful
subject = "We got your submission"
title = "Now let's see how well you do..."
if find_contest.decision_time == 1:
time = "another week"
elif find_contest.decision_time == 2:
time = "another two weeks"
elif find_contest.decision_time == 3:
time = "another three weeks"
elif find_contest.decision_time == 4:
time = "another four weeks"
else:
time = "several days"
body = "This contest is over soon but we won't know the final price of the flight for %s. When that happens we'll let you know if you won and earned a discount on your next Flex Fare. Don't worry, you don't have to wait long and you can enter the next contest as soon as it starts." % (time)
try:
send_template_email(sub.customer.email, subject, title, body)
except:
pass
build['results'] = {'success': True}
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (error[0], unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
def pairs(request):
res = Routes.objects.all().order_by('org_code', 'dest_code')
bank = [{'hub': i.org_code, 'destination': i.dest_code} for i in res]
return HttpResponse(json.encode({'pairs': bank}), mimetype="application/json")
def hubs(request):
res = Routes.objects.values("org_code").distinct()
bank = [i['org_code'] for i in res]
bank.sort()
return HttpResponse(json.encode({'hubs': bank}),
mimetype="application/json")
def make_submission(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
form = ContestSubmissionForm(inputs)
build = {'form': form}
if (inputs) and form.is_valid():
cd = form.cleaned_data
try:
find_platform = Platform.objects.get(key=cd['platform_key'])
find_contest = Contest.objects.get(key=cd['contest_key'])
# either find the existing customer associated with the platform and email addres or create it
try:
find_cust = Customer.objects.get(email=cd['email'],
platform=find_platform)
except:
inps = {}
inps['key'] = gen_alphanum_key()
inps['reg_date'] = current_time_aware().date()
inps['platform'] = find_platform
inps['email'] = cd['email']
find_cust = Customer(**inps)
find_cust.save()
find_cust.create_highrise_account()
find_cust.add_highrise_tag('contest')
try:
sub = Submission.objects.get(customer=find_cust,
contest=find_contest)
except:
sub = Submission(contest=find_contest,
customer=find_cust,
created_date=current_time_aware(),
value=cd['value'])
sub.save()
else:
raise Exception(
"A submission has already been made to this contest with this email address."
)
except (Contest.DoesNotExist):
build['error_message'] = 'The contest key entered is not valid.'
build['results'] = {
'success': False,
'error': 'The contest key entered is not valid.'
}
except (Exception) as err:
build['error_message'] = '%s' % err
build['results'] = {
'success': False,
'error': 'Could not record your entry. %s' % err
}
else:
# send email if subission successful
subject = "We got your submission"
title = "Now let's see how well you do..."
if find_contest.decision_time == 1:
time = "another week"
elif find_contest.decision_time == 2:
time = "another two weeks"
elif find_contest.decision_time == 3:
time = "another three weeks"
elif find_contest.decision_time == 4:
time = "another four weeks"
else:
time = "several days"
body = "This contest is over soon but we won't know the final price of the flight for %s. When that happens we'll let you know if you won and earned a discount on your next Flex Fare. Don't worry, you don't have to wait long and you can enter the next contest as soon as it starts." % (
time)
try:
send_template_email(sub.customer.email, subject, title, body)
except:
pass
build['results'] = {'success': True}
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (
error[0],
unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
def close_contests(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
current_time = current_time_aware()
yesterday = current_time - datetime.timedelta(days=1)
contests = Contest.objects.filter(closed=False)
contest_data = []
for i in contests:
if i.end_price_date() < current_time and i.end_price_date() >= yesterday:
contest_meta_data = {'key': i.key}
subs = Submission.objects.filter(contest=i).order_by('created_date')
contest_meta_data['subs'] = subs.count()
if subs:
# build list of current flights
res = run_flight_search(i.origin_code, i.destination_code, i.depart_date, i.return_date, 'any', 'any', 'any', 'any', cached=True)
if res['success']:
#return HttpResponse(json.encode(res), mimetype="application/json")
i.end_price = res['min_fare']
if not i.end_price:
i.closed = True
i.save()
else:
try:
# find earliest-closest entry
closest = None
for k in subs:
dif = abs(k.value-i.end_price)
if not closest:
closest = (k, dif)
else:
if dif < closest[1]:
closest = (k, dif)
# create promo for this user
new_promo = Promo(customer=closest[0].customer,
created_date=current_time,
value=i.value,
code=gen_alphanum_key())
new_promo.save()
# send email
subject = "You won the fare prediction contest!"
title = "Dang, you are good."
body = "You may remember entering a fare prediction contest on %s. We told you we'd let you know if your guess was closest to the actual fare and here we are. Also as promised, here's a promo code which let's you buy a Flex Fare for just $1:\n\n%s\n\nThe Level Skies Team" % (closest[0].created_date.strftime("%B %d"), new_promo.code)
try:
send_template_email(closest[0].customer.email, subject, title, body)
except:
pass
# close contest
i.closed = True
i.save()
except Exception as err:
contest_meta_data['error'] = err
contest_data.append(contest_meta_data)
results = {'success': True, 'contest_data': contest_data}
return gen_search_display(request, {'results': results}, clean, method='post')
def promo_details(request):
if request.user.is_authenticated():
clean = False
else:
clean = True
inputs = request.POST if request.POST else None
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred), mimetype="application/json")
form = PromoDetail(inputs)
build = {'form': form}
if (inputs) and form.is_valid():
cd = form.cleaned_data
try:
find_platform = Platform.objects.get(key=cd['platform_key'])
find_cust = Customer.objects.get(email=cd['email'],
platform=find_platform)
find_promo = Promo.objects.get(customer=find_cust, code=cd['code'])
if find_promo.contract:
raise Exception("Promotional code already used.")
except (Customer.DoesNotExist):
build['error_message'] = 'The customer is not registered.'
build['results'] = {
'success': False,
'error': 'The customer is not registered.'
}
except (Promo.DoesNotExist):
build['error_message'] = 'The promo code is not valid.'
build['results'] = {
'success': False,
'error': 'The promo code is not valid.'
}
except (Exception) as err:
build['error_message'] = '%s' % err
build['results'] = {'success': False, 'error': '%s' % err}
else:
results = find_promo.__dict__
for i in ('id', 'contract_id', 'customer_id', '_state'):
if i in results:
del results[i]
if 'created_date' in results:
results['created_date'] = str(results['created_date'])
build['results'] = results
build['results']['success'] = True
else:
err_string = ""
for error in form.errors.iteritems():
err_string += "%s - %s " % (
error[0],
unicode(striptags(error[1]) if striptags else error[1]))
build['results'] = {'success': False, 'error': err_string}
return gen_search_display(request, build, clean, method='post')
def sweep_expired(request):
"""
@summary: run this daily to find prices on searches that expired within 24 hours
this will help with analysis and model building
cycle through recently expired options
"""
if request.user.is_authenticated():
clean = False
else:
clean = True
if (request.POST):
if clean:
cred = check_creds(request.POST, Platform)
if not cred['success']:
return HttpResponse(json.encode(cred),
content_type="application/json")
# ensure this query is not run more than once/24hrs
current_time = current_time_aware()
run_dates = ExpiredSearchPriceCheck.objects
if not run_dates.exists() or (current_time - run_dates.latest(
'run_date').run_date) >= datetime.timedelta(hours=23):
latest_price_check = ExpiredSearchPriceCheck(run_date=current_time)
latest_price_check.save()
# pull searches expiring in last 24 hours
yesterday = current_time - datetime.timedelta(days=1)
recent_expired = Searches.objects.filter(
exp_date__range=[yesterday, current_time])
# check expired demos
exp_demo_query = Demo.objects.filter(
search__exp_date__range=[yesterday, current_time])
demo_keys = [str(i.search.key) for i in exp_demo_query]
# run flight search query on each recently expired option
expired_searches = []
expired_demos = []
for i in recent_expired:
flights = pull_fares_range(i.origin_code,
i.destination_code,
(i.depart_date1, i.depart_date2),
(i.return_date1, i.return_date2),
i.depart_times,
i.return_times,
i.convenience,
i.airlines,
cached=True)
expired_searches.append({
'search': i.key,
'success': flights['success']
})
# check if search relates to an expired demo contract, if so, check if customer would have saved money
if i.key in demo_keys and flights['success']:
savings_string = ""
for j in flights['fares']:
savings = math.floor(float(j['fare']) - i.locked_fare)
# don't alert customer of savings unless greater than X dollars
if savings >= 10:
"""
dep_flights = " | ".join(["%s %s" % (k['airline_short_name'], k['flight_number']) for k in j['flight']['departing']['detail']])
ret_flights = " | ".join(["%s %s" % (k['airline_short_name'], k['flight_number']) for k in j['flight']['returning']['detail']])
dep_datetime = parse(j['flight']['departing']['take_off_time']).strftime("%B %d, %Y at %I:%M%p")
ret_datetime = parse(j['flight']['returning']['take_off_time']).strftime("%B %d, %Y at %I:%M%p")
savings_string += "$%s departing %s on %s \nand returning %s on %s\n\n" % (savings, dep_datetime, dep_flights, ret_datetime, ret_flights)
"""
dep_datetime = parse(
j['flight']['departing']
['take_off_time']).strftime("%B %d, %Y")
ret_datetime = parse(
j['flight']['returning']
['take_off_time']).strftime("%B %d, %Y")
savings_string += "$%s departing %s and returning %s\n\n" % (
savings, dep_datetime, ret_datetime)
# send customer email describing potential savings if savings were possible
if savings_string:
try:
title = "Here's what you could have saved by buying a Flex Fare"
body = "Thanks for checking out Level Skies and for taking a closer look at the Flex Fare. You previously signed up for a trial run of the Flex Fare and now we're hear to show you what could have happened had you actually made the purchase. Prices on the flights you were looking at went up, as they tend to do! Here are the potential savings that would have been available to you:\n\n"
body += savings_string + "\n\nWe hope you check in with us again soon becasue we'd love to save you some real cash!\n\nThe Level Skies Team"
email_address = exp_demo_query.get(
search__key=i.key).customer.email
send_template_email(email_address, 'Flex Fare Trial',
title, body)
except:
pass
expired_demos.append({
'search':
i.key,
'savings':
True if savings_string else False
})
# check fares on open contracts
contracts_query = Contract.objects.filter(
search__exp_date__gt=current_time, ex_date=None)
open_contracts = []
for i in contracts_query:
flights = pull_fares_range(
i.search.origin_code,
i.search.destination_code,
(i.search.depart_date1, i.search.depart_date2),
(i.search.return_date1, i.search.return_date2),
i.search.depart_times,
i.search.return_times,
i.search.convenience,
i.search.airlines,
cached=True)
open_contracts.append({
'search': i.search.key,
'success': flights['success']
})
duration = current_time_aware() - current_time
results = {
'success': True,
'time_run': str(current_time),
'expired_demos': expired_demos,
'expired_searches': expired_searches,
'open_contracts': open_contracts,
'duration': str(duration),
'count': recent_expired.count()
}
# send email to sysadmin summarizing expired searches
#if MODE == 'live':
try:
searches_email_string = ""
for i in expired_searches:
searches_email_string += "%s : %s\n" % (i['search'],
i['success'])
contracts_email_string = ""
for i in open_contracts:
contracts_email_string += "%s : %s\n" % (i['search'],
i['success'])
demos_email_string = ""
for i in expired_demos:
demos_email_string += "%s : %s\n" % (i['search'], i['savings'])
email_body = 'Completed flight search for %s expired searches with duration of %s.\n\nSearch Key : Success status\n%s\n\n' % (
results['count'], results['duration'], searches_email_string)
email_body += 'Completed %s open contracts.\n\nSearch Key : Success status\n%s\n\n' % (
len(open_contracts), contracts_email_string)
email_body += 'Completed %s expired demos.\n\nSearch Key : Savings\n%s' % (
len(expired_demos), demos_email_string)
send_mail('Expired searches price check',
email_body,
'*****@*****.**', ['*****@*****.**'],
fail_silently=False)
except:
pass
else:
results = {
'success': False,
'error': 'Expired search price check ran within last 24 hours.'
}
return gen_search_display(request, {'results': results}, clean)
