def check_delivery(request):
'''配送规则导入检查并插入数据库'''
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"], itemlenth=3)
#每做一次检查，从rs1中去除检查项
#判断字段数是否符合
rs2=[] #存放最终结果
rs3=[] #存放临时数据
for rs in rs1:
if len(rs)<3:
rs3.append(rs)
rs.append(u'格式不对')
rs2.append(rs)
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
#必填项检查
rs3=[]
flag=True
for rs in rs1:
for res in rs:
if res=='':
flag=False
if flag==False:
rs3.append(rs)
rs.append(u'必填字段不能为空')
rs2.append(rs)
flag=True
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
#配送周格式不对
myweek=[u'星期一',u'星期二',u'星期三',u'星期四',u'星期五',u'星期六',u'星期日']
rs3=[]
for rs in rs1:
if rs[2] in myweek:
pass
else:
rs3.append(rs)
rs.append(u'日期格式应为：星期X')
rs2.append(rs)
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
rs3=[]
for rs in rs1:
if confsql.verify("select * from delivery where braid='"+rs[0]+"'"): #数据库已存在则覆盖
confsql.delivery_del(braid=rs[0])
for rs in rs1:
rs.append(datetime.datetime.now().strftime('%Y-%m-%d')) #最后追加插入日期
confsql.delivery_insert(braid=rs[0],weekdelivery=rs[2],adddate=rs[3])
rs3=[rs[0],rs[1],rs[2]]
rs3.append('保存成功！')
rs2.append(rs3)
for rs in rs2:
res={}
res['braid']=rs[0]
res['braname'] = rs[1]
res['weekdelivery']=rs[2]
res['info']=rs[3] #导入情况
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def check_delivery(request):
'''配送规则导入检查并插入数据库'''
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"], itemlenth=3)
#每做一次检查，从rs1中去除检查项
#判断字段数是否符合
rs2 = [] #存放最终结果
rs3 = [] #存放临时数据
for rs in rs1:
if len(rs) < 3:
rs3.append(rs)
rs.append(u'格式不对')
rs2.append(rs)
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
#必填项检查
rs3 = []
flag = True
for rs in rs1:
for res in rs:
if res == '':
flag = False
if flag == False:
rs3.append(rs)
rs.append(u'必填字段不能为空')
rs2.append(rs)
flag = True
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
#配送周格式不对
myweek = [u'星期一', u'星期二', u'星期三', u'星期四', u'星期五', u'星期六', u'星期日']
rs3 = []
for rs in rs1:
if rs[2] in myweek:
pass
else:
rs3.append(rs)
rs.append(u'日期格式应为：星期X')
rs2.append(rs)
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
rs3 = []
for rs in rs1:
if confsql.verify("select * from delivery where braid='" + rs[0] +
"'"): #数据库已存在则覆盖
confsql.delivery_del(braid=rs[0])
for rs in rs1:
rs.append(datetime.datetime.now().strftime('%Y-%m-%d')) #最后追加插入日期
confsql.delivery_insert(braid=rs[0], weekdelivery=rs[2], adddate=rs[3])
rs3 = [rs[0], rs[1], rs[2]]
rs3.append('保存成功！')
rs2.append(rs3)
for rs in rs2:
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['weekdelivery'] = rs[2]
res['info'] = rs[3] #导入情况
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_delivery(request):
value=request.POST['value'].encode("utf-8")
rs1=[]
result=[]
rs1=trim_csv(value, itemlenth=3) #去除行尾多余换行符 rs1存放初始值
#每做一次检查，从rs1中去除检查项
#判断字段数是否符合
rs2=[] #存放最终结果
rs3=[] #存放临时数据
for rs in rs1:
if len(rs)<3:
rs3.append(rs)
rs.append('格式不对')
rs2.append(rs)
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
#必填项检查
rs3=[]
flag=True
for rs in rs1:
for res in rs:
if res=='':
flag=False
if flag==False:
rs3.append(rs)
rs.append('必填字段不能为空')
rs2.append(rs)
flag=True
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
#配送周格式不对
myweek=['星期一','星期二','星期三','星期四','星期五','星期六','星期日']
rs3=[]
for rs in rs1:
if rs[2] in myweek:
pass
else:
rs3.append(rs)
rs.append('日期格式应为：星期X')
rs2.append(rs)
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
#数据库已存在给予提示
rs3=[]
for rs in rs1:
if confsql.verify("select * from delivery where braid='"+rs[0]+"'"):
rs3.append(rs)
rs.append('')
rs2.append(rs)
if len(rs3)>0:
for rs in rs3:
rs1.remove(rs)
for rs in rs1:
rs.append('')
rs2.append(rs)
html="<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>配送周</th></tr>"
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
if rs[3]=="":
html+="<td>" + rs[3] + "</td>"
else:
html+="<td style='background-color:yellow;'>" + rs[3] + "</td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
def save_delivery(request):
value = request.POST['value'].encode("utf-8")
rs1 = []
result = []
rs1 = trim_csv(value, itemlenth=3) #去除行尾多余换行符 rs1存放初始值
#每做一次检查，从rs1中去除检查项
#判断字段数是否符合
rs2 = [] #存放最终结果
rs3 = [] #存放临时数据
for rs in rs1:
if len(rs) < 3:
rs3.append(rs)
rs.append('格式不对')
rs2.append(rs)
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
#必填项检查
rs3 = []
flag = True
for rs in rs1:
for res in rs:
if res == '':
flag = False
if flag == False:
rs3.append(rs)
rs.append('必填字段不能为空')
rs2.append(rs)
flag = True
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
#配送周格式不对
myweek = ['星期一', '星期二', '星期三', '星期四', '星期五', '星期六', '星期日']
rs3 = []
for rs in rs1:
if rs[2] in myweek:
pass
else:
rs3.append(rs)
rs.append('日期格式应为：星期X')
rs2.append(rs)
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
#数据库已存在给予提示
rs3 = []
for rs in rs1:
if confsql.verify("select * from delivery where braid='" + rs[0] +
"'"):
rs3.append(rs)
rs.append('')
rs2.append(rs)
if len(rs3) > 0:
for rs in rs3:
rs1.remove(rs)
for rs in rs1:
rs.append('')
rs2.append(rs)
html = "<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>配送周</th></tr>"
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
if rs[3] == "":
html += "<td>" + rs[3] + "</td>"
else:
html += "<td style='background-color:yellow;'>" + rs[3] + "</td>"
html += "</tr>"
html += "</table>"
return HttpResponse(html)
