def importFromXLS4():
import xlrd
customList = xlrd.open_workbook("ALL PARTY DETAILS.xlsx")
worksheet = customList.sheet_by_name("Sheet1")
for i in range(2, 50):
customer = worksheet.cell(i, 0).value
city = worksheet.cell(i, 3).value
address = worksheet.cell(i, 10).value
customerObject = Customer()
customerObject.cName = customer
customerObject.address = address
customerObject.city = city
customerObject.save()
def save(self, user):
try:
data = user.get_profile()
except:
data = Customer(user=user)
print 'Inside save method of UserRegForm'
data.first_name = self.cleaned_data["first_name"]
data.last_name = self.cleaned_data["last_name"]
data.address = self.cleaned_data["address"]
data.city = self.cleaned_data["city"]
data.zip = self.cleaned_data["zip"]
data.date_of_birth = self.cleaned_data["date_of_birth"]
data.save()
def importFromXLS():
import xlrd
customList = xlrd.open_workbook("list.xls")
worksheet = customList.sheet_by_name("Sheet1")
for i in range(9, 3582):
if worksheet.cell(i, 9).value != "":
city = worksheet.cell(i, 9).value
if worksheet.cell(i, 7).value != "":
uniqueCode = worksheet.cell(i, 3).value
customer = worksheet.cell(i, 7).value
address = worksheet.cell(i, 14).value
customerObject = Customer()
customerObject.cName = customer
customerObject.address = address
customerObject.city = city
customerObject.usn = uniqueCode
customerObject.save()
def importFromXLS1():
import xlrd
customList = xlrd.open_workbook("VVM STOCKIEST LIST.XLS")
worksheet = customList.sheet_by_name("Sheet1")
for i in range(5, 707, 6):
code = worksheet.cell(i, 1).value
customer = worksheet.cell(i, 3).value
address1 = worksheet.cell(i + 1, 3).value
address2 = worksheet.cell(i + 2, 3).value
address3 = worksheet.cell(i + 3, 3).value
city = worksheet.cell(i + 4, 3).value
customerObject = Customer()
customerObject.cName = customer
customerObject.address = address1 + " " + address2 + " " + address3
customerObject.city = city
customerObject.usn = code
customerObject.save()
def register_customer():
if request.method == 'POST':
token = request.headers.get('token')
if not token:
return Response(json.dumps(
{"Message": "Please supply proper credentials"}),
status=400,
content_type="application/json")
if not check_auth(token):
return Response(json.dumps({"Message": "Unauthorized access"}),
status=401,
content_type="application/json")
json_request = json.loads(request.data)
c = Customer()
try:
c.first_name = json_request['first_name']
c.last_name = json_request['last_name']
c.address = json_request['address']
c.contact_no = json_request['contact_no']
c.driving_licence_link = json_request['driving_licence_link']
c.email = json_request['email']
c.password = json_request['password']
vehicles = json_request['vehicles']
except:
return Response(json.dumps({"Message": "In-Complete form data"}),
status=400,
content_type="application/json")
try:
if not (int(c.contact_no) > 1000000000
and int(c.contact_no) <= 9999999999):
return Response(json.dumps(
{"Message": "Contact no. not valid"}),
status=400,
content_type="application/json")
except:
return Response(json.dumps({"Message": "Contact no. not valid"}),
status=400,
content_type="application/json")
for vehicle in vehicles:
v = Vehicle()
try:
v.vehicle_type = vehicle['vehicle_type']
v.vehicle_number = vehicle['vehicle_number']
v.vehicle_rc_link = vehicle['vehicle_rc_link']
except:
return Response(json.dumps(
{"Message": "In-Complete form data"}),
status=400,
content_type="application/json")
v.save()
c.vehicles.append(v)
try:
c.save()
except NotUniqueError:
for vehicle in c.vehicles:
v = Vehicle.objects.get(vid=vehicle.vid)
v.delete()
return Response(json.dumps(
{"Message": "Customer with same e-mail already exists"}),
status=400,
content_type="application/json")
ewallet_reg_url = "http://0.0.0.0:8000/login?x=1&name=" + str(
c.cid) + "&password="******"QR_CODE_DATA": c.QR_CODE_DATA}),
status=200,
content_type="application/json")
