def addrecord_android(request):
if request.method == 'POST':
# form = RecordForm(request.POST)
# if form.is_valid():
reqJson = simplejson.loads(request.raw_post_data)
record = Record()
record.user = request.user
record.companyname_cn = reqJson['companyname_cn']
record.city = reqJson['city']
record.post = reqJson['post']
# record.date = reqJson['date']
# record.time = reqJson['time']
record.date_time = reqJson['dateTime']
record.location = reqJson['location']
record.state = reqJson['state']
record.orig_record_id = reqJson['orig_record_id']
# record.post = reqJson['post']
try:
record.save()
except Exception,e:
print str(e)
return HttpResponse(str(e))
else:
return HttpResponse("added")
def post(self, request):
# 上传的文件都在request.FILES里面获取，所以这里要多传一个这个参数
excel_form = UploadExcelForm(request.POST, request.FILES)
next_url = request.GET.get('next', '')
if excel_form.is_valid():
excel_file = excel_form.cleaned_data["excel_file"]
case_file = File()
case_file.excel_file = excel_file
case_file.save()
excel_file_name = os.path.join(MEDIA_ROOT,
case_file.excel_file.name)
wb = openpyxl.load_workbook(excel_file_name)
sheet = wb.get_active_sheet()
for i in range(1, sheet.max_row):
record = Record()
record.asin = sheet.cell(row=i + 1, column=1).value
record.c_price = sheet.cell(row=i + 1, column=2).value
record.purchase_cost = sheet.cell(row=i + 1, column=3).value
record.product_profit = sheet.cell(row=i + 1, column=4).value
record.product_upload_time = sheet.cell(row=i + 1,
column=5).value
# record.brush_number = sheet.cell(row=i + 1, column=6).value
record.sale_30_number = sheet.cell(row=i + 1, column=6).value
record.sale_7_number = sheet.cell(row=i + 1, column=7).value
record.record_src = sheet.cell(row=i + 1, column=8).value
record.now_score = sheet.cell(row=i + 1, column=9).value
record.now_review_number = sheet.cell(row=i + 1,
column=10).value
review_type = sheet.cell(row=i + 1, column=11).value
record.review_type = review_type
if review_type == "留评":
record.direct_review = '0'
record.free_review_number = '0'
record.feedback = '0'
elif review_type == "直评":
record.review_number = '0'
record.free_review_number = '0'
record.feedback = '0'
elif review_type == "免评":
record.review_number = '0'
record.direct_review = '0'
record.feedback = '0'
elif review_type == "feedback":
record.review_number = '0'
record.direct_review = '0'
record.free_review_number = '0'
record.user = request.user
record.save()
messages.add_message(request,
messages.SUCCESS,
"文件上传成功",
extra_tags='success')
return redirect(next_url)
else:
messages.add_message(request,
messages.ERROR,
"表单验证错误",
extra_tags='danger')
return redirect(next_url)
