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)