def __init__(self, username_str):
self.file_list = File.objects.filter(updated_by=username_str, status=1)
self.part_list = Part.objects.filter(is_active=True)
self.package_list = Package.objects.filter(is_active=True)
self.routerMaster_list = RouterMaster.objects.filter(is_active=True)
self.order_list = Order.objects.filter()
self.project_code = self.file_list[0].project_code
self.CSV_name_str = settings.MEDIA_ROOT + '/' + FileManagement.find_file(
configPart.configs.get("UPLOAD_ORDER_PART").data,
str(self.file_list[0].file_no) + "DatabaseCSV.csv")
self.updated_by = username_str
def covert_data_list_to_serializer_list(file_list):
file_return_list = []
for file_obj in file_list:
fileSerializer = FileSerializer()
fileSerializer.customer_code = file_obj[0]
fileSerializer.project_code = file_obj[1]
fileSerializer.file_no = file_obj[2]
fileSerializer.order_count = file_obj[3]
fileSerializer.status = file_obj[4]
fileSerializer.updated_by = file_obj[5]
fileSerializer.updated_date = file_obj[6]
fileSerializer.csv_url = FileManagement.find_file(
configPart.configs.get("UPLOAD_ORDER_PART").data,
file_obj[2] + ".csv")
file_return_list.append(fileSerializer)
return file_return_list
def get_files(request):
try:
if request.method == 'GET':
file_list = File.objects.filter(updated_by= request.user.username, status = 1)
if len(file_list) > 0 :
csv_name = FileManagement.find_file(configPart.configs.get("UPLOAD_ORDER_PART").data,file_list[0].file_no+".csv")
serializer = serializerMapping.mapping_serializer_list(File_list_Serializer_DTO,file_list,"success",None,csv_name,None,None )
else :
serializer = serializerMapping.mapping_serializer_list(File_list_Serializer_DTO,[],"success",None,None,None,None )
return Response(serializer.data, status=status.HTTP_200_OK)
except Exception as e:
serializer = serializerMapping.mapping_serializer_list(FileSerializer,None,"Error",e,None,None,None )
return Response(serializer.data, status=status.HTTP_200_OK)