def validate_orderQry_list(self):
orderQry_list = [
x for x in self.order_list if x[2] > 5 and not x[0].isnumeric()
]
for orderQry_error in orderQry_list:
validate_error_obj = validateError()
if orderQry_error[0] is None or orderQry_error[0] == "":
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_QUANTITY_REQUIRED").data
validate_error_obj.row = orderQry_error[1]
validate_error_obj.column = get_column_letter(
orderQry_error[2])
elif not orderQry_error[0].isnumeric():
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_QUANTITY_INTEGER").data
validate_error_obj.row = orderQry_error[1]
validate_error_obj.column = get_column_letter(
orderQry_error[2])
self.error_list.append(validate_error_obj)
return self.error_list
def validate_item_list(self):
item_list = [
x for x in self.order_list
if x[2] == 1 and (not x[0].isnumeric() or x[0] == "")
]
for item_error in item_list:
validate_error_obj = validateError()
if item_error[0] is None or item_error[0] == "":
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_ITEM_REQUIRED").data
validate_error_obj.row = item_error[1]
validate_error_obj.column = get_column_letter(item_error[2])
elif not item_error[0].isnumeric():
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_ITEM_INTEGER").data
validate_error_obj.row = item_error[1]
validate_error_obj.column = get_column_letter(item_error[2])
self.error_list.append(validate_error_obj)
return self.error_list
def validate_customer_code(self,customer_code) :
validateError_obj = validateError()
if not str(customer_code) :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_CUSTOMERCODE_REQUIRED").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 1
self.validateError_list.append(validateError_obj)
return None
else :
customer_list = Customer.objects.filter(customer_code__iexact = str(customer_code))
if len(customer_list) <=0 :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_CUSTOMERCODE_EXISTING").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 1
self.validateError_list.append(validateError_obj)
return None
else :
return str(customer_code)
def validate_plant_list(self):
plant_list = [
x for x in self.order_list
if x[0].upper() in list(self.get_plant_codet_in_workbook())
and x[2] == 5
]
for plant_error in plant_list:
validate_error_obj = validateError()
station_len_int = len(
Station.objects.filter(station_code__iexact=str(
plant_error[0]),
station_type__iexact="PLANT",
is_active=True))
if plant_error[0] is None or plant_error[0] == "":
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_PLANTCODE_REQUIRED").data
validate_error_obj.row = plant_error[1]
validate_error_obj.column = get_column_letter(plant_error[2])
elif station_len_int == 0:
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_PLANTCODE_DATABASE").data
validate_error_obj.row = plant_error[1]
validate_error_obj.column = get_column_letter(plant_error[2])
self.error_list.append(validate_error_obj)
return self.error_list
def validate_project_code(self,project_code) :
validateError_obj = validateError()
if not str(project_code) :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PROJECTCODE_REQUIRED").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 2
self.validateError_list.append(validateError_obj)
return None
else :
project_list = Project.objects.filter(project_code__iexact = str(project_code))
if len(project_list) <=0 :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PROJECTCODE_EXISTING").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 2
self.validateError_list.append(validateError_obj)
return None
else :
return str(project_code)
def validate_plant_code(self,plant_code) :
validateError_obj = validateError()
if not str(plant_code) :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PLANTCODE_REQUIRED").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 5
self.validateError_list.append(validateError_obj)
return None
else :
plant_list = Station.objects.filter(station_code__iexact=str(plant_code).strip(),station_type__iexact="PLANT",is_active=True)
if len(plant_list) <=0 :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PLANTCODE_EXISTING").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 6
self.validateError_list.append(validateError_obj)
return None
else :
return str(plant_code)
def validate_route_code(self,route_code) :
validateError_obj = validateError()
if not str(route_code) :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_ROUTECODE_REQUIRED").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 3
self.validateError_list.append(validateError_obj)
return None
else :
return str(route_code)
def validate_pickup_before(self,pickup_before) :
validateError_obj = validateError()
if not pickup_before.isdigit() :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PICKUPBEFORE_INTEGER").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 7
self.validateError_list.append(validateError_obj)
return None
else :
return int(pickup_before)
def validate_complete_time(self,complete_time) :
validateError_obj = validateError()
if not isinstance(complete_time, int) :
if rex.match(str(complete_time)):
return str(complete_time)
else :
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_COMPLETETIME_INCORRECT_FORMAT").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 12
self.validateError_list.append(validateError_obj)
return None
def validate_delivery_time(self,delivery_time) :
validateError_obj = validateError()
if not isinstance(delivery_time, int) :
if rex.match(str(delivery_time)):
return str(delivery_time)
else:
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_DELIVERYTIME_INCORRECT_FORMAT").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 11
self.validateError_list.append(validateError_obj)
return None
def validate_pickup_time(self,pickup_time) :
validateError_obj = validateError()
if not isinstance(pickup_time, int) :
if rex.match(str(pickup_time)):
return str(pickup_time)
else:
validateError_obj.error = configMessage.configs.get("ROUTE_MASTER_PICKUPTIME_INCORRECT_FORMAT").data
validateError_obj.row = self.row_int + 1
validateError_obj.column = 9
self.validateError_list.append(validateError_obj)
return None
def validate_partNumber_list(self):
partNumber_list = [
x for x in self.order_list if x[2] == 2 and x[0] == ""
]
for partNumber_error in partNumber_list:
validate_error_obj = validateError()
if partNumber_error[0] is None or partNumber_error[0] == "":
validate_error_obj.error = configMessage.configs.get(
"UPLOAD_ORDER_PARTNUMBER_REQUIRED").data
validate_error_obj.row = partNumber_error[1]
validate_error_obj.column = get_column_letter(
partNumber_error[2])
self.error_list.append(validate_error_obj)
return self.error_list