def activate(request, uidb64, token):
try:
id = force_text(urlsafe_base64_decode(uidb64))
with connection.cursor() as cur:
cur.execute(
"SELECT NAME , ISVERIFIED FROM CUSTOMER WHERE customerId = %s",
[id])
result = cur.fetchone()
if result is None:
messages.success(request, "You have not created any account")
return redirect('login:index')
else:
customer = Customer(customer_id=id,
name=result[0],
isVerified=result[1])
if not account_activation_token.check_token(customer, token):
messages.success(request,
"Your account is already activated")
return redirect('login:index')
cur.execute(
"UPDATE CUSTOMER SET ISVERIFIED = 'YES' WHERE customerId = %s",
[id])
messages.success(request, "Account Activated Successfully")
return redirect('login:index')
except Exception as ex:
pass
return redirect('login:index')
def process_item(self, item, spider):
if item['table_type'] == 'customer_order':
try:
cust = Customer.objects.get(source_id=item['source_id'],
source_type=item['source_type'])
except Customer.DoesNotExist:
cust = Customer()
cust.source_type = item['source_type']
cust.source_id = item['source_id']
cust.name = item['name']
cust.save()
logger.info(u'Added {}'.format(str(cust)))
cust_ord = CustomerOrder()
cust_ord.customer = cust
cust_ord.order_id = item['order_id']
if item['member'].lower().strip() == 'yes':
cust_ord.member = True
elif item['member'].lower().strip() == 'no':
cust_ord.member = False
cust_ord.caregiver = item['caregiver']
cust_ord.date = datetime.strptime(item['date'], '%m/%d/%y').date()
cust_ord.order_total = item['order_total'].lstrip('$')
cust_ord.save()
logger.info(u'Added {}'.format(str(cust_ord)))
elif item['table_type'] == 'transaction':
try:
cust_ord = CustomerOrder.objects.get(
order_id=item['order_id'],
customer__source_type=item['source_type'])
except Customer.DoesNotExist:
logger.error(u'There is no customer order #{}!'.format(
item['order_id']))
else:
trans = Transaction()
trans.order = cust_ord
trans.description = item['description']
trans.qty_dispensed = item['qty_dispensed']
trans.qty_sold = item['qty_sold']
trans.price = item['price'].lstrip('$')
trans.subtotal = item['subtotal'].lstrip('$')
trans.discount = item['discount']
trans.tax = item['tax']
trans.cashier = item['cashier']
trans.save()
logger.info(u'Added {}'.format(str(trans)))
return item
def get_customer_info(customer_id):
with connection.cursor() as cur:
cur.execute(
"SELECT NAME , EMAIL , USERNAME , GENDER , STREET , ZIPCODE , CITY , COUNTRY , "
"PHONE_NUM , ISVERIFIED FROM CUSTOMER WHERE customerId = %s",
[customer_id])
result = cur.fetchone()
global customer
customer = Customer(customer_id=customer_id,
name=result[0],
email=result[1],
username=result[2],
gender=result[3],
street=result[4],
zipcode=result[5],
city=result[6],
country=result[7],
phone=result[8],
isVerified=result[9])
cur.execute(
"SELECT CARD_NUMBER , CARD_USERNAME , CARD_TYPE , CVC , EXPIRATION FROM CREDIT_CARD "
"WHERE customerId = %s", [customer_id])
result = cur.fetchone()
if result:
customer.card_number = result[0]
customer.card_username = result[1]
customer.card_type = result[2]
customer.cvc = result[3]
customer.expiration = str(result[4].date())
cur.execute(
"SELECT PHONE_NUMBER , SERVICE_PROVIDER , CUSTOMERID FROM MOBILE_BANKING "
"WHERE customerId = %s", [customer_id])
result = cur.fetchone()
if result:
customer.mob_banking_phone_number = result[0]
customer.mob_banking_service_provider = result[1]
def sign_up(request):
v1 = request.POST.get('name')
v2 = request.POST.get('email')
v3 = request.POST.get('username')
v4 = request.POST.get('password')
v4 = hashlib.md5(v4.encode()).hexdigest()
v5 = request.POST.get('gender')
v6 = request.POST.get('street')
v7 = request.POST.get('zipcode')
v8 = request.POST.get('city')
v9 = request.POST.get('country')
v10 = request.POST.get('phone')
if v1 == "":
print("No name")
elif v2 == "":
print("No email")
elif v3 == "":
print("No username")
elif v4 == "":
print("No password")
elif v5 == "":
print("No gender")
elif v6 == "":
print("No street")
elif v7 == "":
print("No zipcode")
elif v8 == "":
print("No city")
elif v9 == "":
print("No country")
elif v10 == "":
print("No phone")
else:
with connection.cursor() as cur:
customer_id = cur.callfunc(
'REGISTER', int, [v1, v2, v3, v4, v5, v6, v7, v8, v9, v10])
if customer_id == 0:
alert_message = "This username is already taken"
return render(request, 'register/index.html', {
'invalid_username': True,
'alert_message': alert_message
})
customer = Customer(customer_id=customer_id,
name=v1,
isVerified='NO')
current_site = get_current_site(request)
email_body = {
'user': customer.name,
'domain': current_site.domain,
'uid':
urlsafe_base64_encode(force_bytes(customer.customer_id)),
'token': account_activation_token.make_token(customer),
}
link = reverse('register:activate',
kwargs={
'uidb64': email_body['uid'],
'token': email_body['token']
})
activate_url = 'http://' + current_site.domain + link
email_subject = "Activate your innOcity Account"
email_body = 'Hi ' + v1 + ', Please click the link to activate your account : ' + activate_url
email = EmailMessage(
email_subject,
email_body,
settings.EMAIL_HOST_USER,
[v2],
)
email.fail_silently = False
email.send()
messages.success(
request, "Please check your e-mail and verify your account")
return redirect('login:index')
alert_message = "Complete the form"
return render(request, 'register/index.html', {
'alert_flag': True,
'alert_message': alert_message
})
from django.views.decorators.csrf import csrf_exempt
from django.db import connection
from dashboard.models import Customer
from django.core.mail import EmailMultiAlternatives
from easy_pdf.rendering import render_to_pdf
from django.conf import settings
import math
app_name = 'hotel'
session_id = 0
sessions = {}
customer = Customer(0)
@csrf_exempt
def available(request):
destination = request.POST.get('destination').upper()
room_no = request.POST.get('rooms')
checkin_input = request.POST.get('checkin')
checkout_input = request.POST.get('checkout')
request.session['checkin_input'] = checkin_input
request.session['checkout_input'] = checkout_input
logged_in = request.session.has_key('customer_id')
