def delete_product_gl_packetqty_rules(request):
'删除配货规则'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=4)
rs2, rs1 = verifyData(rs1, length=4, required=[0, 2, 3], psrules=1)
html = u"<table width='800'><tr><th>代码</th><th>名称</th><th>代码说明</th><th>配货单位</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td style='background-color:yellow;'>" + rs[
4] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(html)
else:
t = get_template('mana1/delete_product_gl_packetqty_rules.html')
html = t.render(Context())
return HttpResponse(html)
def delete_product_gl_packetqty_rules(request):
'删除配货规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=4)
rs2,rs1=verifyData(rs1,length=4,required=[0,2,3],psrules=1)
html=u"<table width='800'><tr><th>代码</th><th>名称</th><th>代码说明</th><th>配货单位</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td style='background-color:yellow;'>" + rs[4] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
else:
t=get_template('mana1/delete_product_gl_packetqty_rules.html')
html=t.render(Context())
return HttpResponse(html)
def delete_quantou(request):
'删除订货规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=2)
rs2,rs1=verifyData(rs1,length=2,required=[0])
html=u"<table width='400'><tr><th>商品代码</th><th>商品名称</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td style='background-color:yellow'>" + rs[2] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/delete_quantou.html')
html=t.render(Context())
return HttpResponse(html)
def delete_tianshu(request):
'删除订货规则'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=4)
rs2, rs1 = verifyData(rs1, length=4, required=[0, 2, 3])
html = u"<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>安全库存天数</th><th>配送周期天数</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td style='background-color:yellow'>" + rs[4] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/delete_tianshu.html')
html = t.render(Context())
return HttpResponse(html)
def delete_delivery(request):
'删除配送规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=3)
rs2,rs1=verifyData(rs1,length=3,required=[0,2],delivery=1)
html=u"<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>配送日</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td style='background-color:yellow;'>" + rs[3] + "</td>"
html+="</tr>"
#log(rs1)
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
else:
t=get_template('mana1/delete_delivery.html')
html=t.render(Context())
return HttpResponse(html)
def import_product_gl_packetqty_rules(request):
'商品配送规则导入'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=4)
rs2, rs1 = verifyData(rs1, length=4, required=[0, 2, 3], psrules=1)
temp = []
for rs in rs1:
excode = rs[2]
if rs[2] == u'商品代码':
excode = 'sp'
if rs[2] == u'小类代码':
excode = 'xl'
if rs[2] == u'中类代码':
excode = 'zl'
if rs[2] == u'大类代码':
excode = 'dl'
'重复项覆盖'
sqlstr = "select * from product_gl_packetqty_rules where xcode='" + rs[
0] + "' and excode='" + excode + "'"
if confsql.checkExist(
sqlstr) == 1: #检查xcode,excode,packetqty 数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='800'><tr><th>代码</th><th>名称</th><th>代码说明</th><th>配货单位</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td style='background-color:yellow;'>" + rs[
4] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(html)
else:
t = get_template('mana1/import_product_gl_packetqty_rules.html')
html = t.render(Context())
return HttpResponse(html)
def import_product_gl_packetqty_rules(request):
'商品配送规则导入'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=4)
rs2,rs1=verifyData(rs1,length=4,required=[0,2,3],psrules=1)
temp=[]
for rs in rs1:
excode=rs[2]
if rs[2]==u'商品代码':
excode='sp'
if rs[2]==u'小类代码':
excode='xl'
if rs[2]==u'中类代码':
excode='zl'
if rs[2]==u'大类代码':
excode='dl'
'重复项覆盖'
sqlstr="select * from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'"
if confsql.checkExist(sqlstr)==1: #检查xcode,excode,packetqty 数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='800'><tr><th>代码</th><th>名称</th><th>代码说明</th><th>配货单位</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td style='background-color:yellow;'>" + rs[4] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
else:
t=get_template('mana1/import_product_gl_packetqty_rules.html')
html=t.render(Context())
return HttpResponse(html)
def import_basedisplay(request):
'订货量修改规则导入'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=5)
rs2, rs1 = verifyData(rs1, length=5, required=[0, 2, 4])
'重复项覆盖'
temp = []
for rs in rs1:
sqlstr = u"select * from basedisplay where braid='" + rs[
0] + "' and proid='" + rs[2] + "'"
if confsql.checkExist(sqlstr) == 1: #检查braid,proid数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>商品代码</th><th>商品名称</th><th>基本陈列量</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td style='background-color:yellow'>" + rs[5] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/import_basedisplay.html')
html = t.render(Context())
return HttpResponse(html)
def import_basedisplay(request):
'订货量修改规则导入'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=5)
rs2,rs1=verifyData(rs1,length=5,required=[0,2,4])
'重复项覆盖'
temp=[]
for rs in rs1:
sqlstr=u"select * from basedisplay where braid='"+rs[0]+"' and proid='"+rs[2]+"'"
if confsql.checkExist(sqlstr)==1: #检查braid,proid数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>商品代码</th><th>商品名称</th><th>基本陈列量</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td style='background-color:yellow'>" + rs[5] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/import_basedisplay.html')
html=t.render(Context())
return HttpResponse(html)
def import_tianshu(request):
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=4)
rs2, rs1 = verifyData(rs1, length=4, required=[0, 2, 3])
'重复项覆盖'
temp = []
if len(rs1) > 0:
for rs in rs1:
if confsql.checkExist("select * from tianshu where braid='" +
rs[0] + "'") == 1: #检查数据库是否已存在
temp.append(rs)
rs.append(u'数据库已存在!')
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>安全库存天数</th><th>送货周期天数</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td style='background-color:yellow'>" + rs[4] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/import_tianshu.html')
html = t.render(Context())
return HttpResponse(html)
def import_tianshu(request):
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=4)
rs2,rs1=verifyData(rs1,length=4,required=[0,2,3])
'重复项覆盖'
temp=[]
if len(rs1)>0:
for rs in rs1:
if confsql.checkExist("select * from tianshu where braid='"+rs[0]+"'")==1: #检查数据库是否已存在
temp.append(rs)
rs.append(u'数据库已存在!')
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>安全库存天数</th><th>送货周期天数</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td style='background-color:yellow'>" + rs[4] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/import_tianshu.html')
html=t.render(Context())
return HttpResponse(html)
def import_delivery(request):
''' 配送日期导入 '''
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value, itemlenth=3) #去除行尾多余换行符 rs1存放初始值
rs2,rs1=verifyData(rs1,length=3,required=[0,2],delivery=1)
#数据库已存在给予提示
temp=[]
for rs in rs1:
if confsql.checkExist("select * from delivery where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'")==1:
temp.append(rs)
rs.append(u'数据库已存在!')
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='800'><tr><th>门店代码</th><th>门店名称</th><th>配送日</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td style='background-color:yellow;'>" + rs[3] + "</td>"
html+="</tr>"
#log(rs1)
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
else:
t=get_template('mana1/import_delivery.html')
html=t.render(Context())
return HttpResponse(html)
def import_maxmin(request):
''' 上下限导入界面 '''
if request.method == 'POST':
'''暂存数据 初步检查'''
try:
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=6) #去除行尾多余换行符 rs1存放初始值
rs2, rs1 = verifyData(rs1, length=6, required=[4], maxmin=1)
html = u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>商品代码</th><th>商品名称</th><th>上限</th><th>下限</th><th></th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td style='background-color:yellow'>" + rs[
6] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(html)
except:
return HttpResponse(0)
else:
t = get_template('mana1/import_maxmin.html')
html = t.render(Context())
return HttpResponse(html)
def delete_dhrules(request):
'删除订货规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=8)
rs2,rs1=verifyData(rs1,length=8,required=[5,6,7],dhrules=1)
html=u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td style='background-color:yellow'>" + rs[8] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/delete_dhrules.html')
html=t.render(Context())
return HttpResponse(html)
def delete_dhrules(request):
'删除订货规则'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=8)
rs2, rs1 = verifyData(rs1, length=8, required=[5, 6, 7], dhrules=1)
html = u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td style='background-color:yellow'>" + rs[8] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/delete_dhrules.html')
html = t.render(Context())
return HttpResponse(html)
def import_maxmin(request):
''' 上下限导入界面 '''
if request.method=='POST':
'''暂存数据 初步检查'''
try:
value=request.POST['value']
rs1=trim_csv(value,itemlenth=6) #去除行尾多余换行符 rs1存放初始值
rs2,rs1=verifyData(rs1,length=6,required=[4],maxmin=1)
html=u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>商品代码</th><th>商品名称</th><th>上限</th><th>下限</th><th></th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td style='background-color:yellow'>" + rs[6] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(html)
except:
return HttpResponse(0)
else:
t=get_template('mana1/import_maxmin.html')
html=t.render(Context())
return HttpResponse(html)
def import_dhrules(request):
'订货量修改规则导入'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=8)
rs2,rs1=verifyData(rs1,length=8,required=[5,6,7],dhrules=1)
'重复项覆盖'
temp=[]
for rs in rs1:
excode=rs[4]
if rs[4]==u'商品代码':
excode='sp'
if rs[4]==u'小类代码':
excode='xl'
if rs[4]==u'中类代码':
excode='zl'
if rs[4]==u'大类代码':
excode='dl'
yqkey = rs[5]
if rs[5]==u'上阈值':
yqkey='maxlimit'
if rs[5]==u'下阈值':
yqkey='minlimit'
sqlstr=u"select * from dhrules where mdcode='"+rs[0]+"' and xcode = '"+ rs[2] +"' and excode='"+excode+"' and yqkey='"+yqkey+"'"
if confsql.checkExist(sqlstr)==1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td style='background-color:yellow'>" + rs[8] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/import_dhrules.html')
html=t.render(Context())
return HttpResponse(html)
def delete_maxminCuxiaori(request):
'删除促销日上下限规则'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=10)
rs2, rs1 = verifyData(rs1, length=10, required=[0, 2, 4, 5, 6, 7, 8])
'重复项覆盖'
temp = []
for rs in rs1:
excode = rs[4]
if rs[4] == u'商品代码':
excode = 'sp'
if rs[4] == u'品牌小类代码':
excode = 'braxl'
if rs[4] == u'大类代码':
excode = 'prodl'
if rs[4] == u'中类代码':
excode = 'prozl'
if rs[4] == u'小类代码':
excode = 'proxl'
sqlstr = u"select * from maxminCuxiaori where mdcode='" + rs[
0] + "' and xcode = '" + rs[
2] + "' and excode='" + excode + "' and startdate='" + rs[
7] + "' and enddate = '" + rs[8] + "'"
if confsql.checkExist(sqlstr) <> 1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库中不存在!')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'门店代码商品代码 长度检查'
temp = []
for rs in rs1:
if len(rs[0]) <> 5: #门店代码 5位
rs.append(u'门店代码长度必须为5位')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'代码说明 检查'
temp = []
for rs in rs1:
if rs[4] <> u"商品代码" and rs[4] <> u"品牌小类代码" and rs[
4] <> u"大类代码" and rs[4] <> u"中类代码" and rs[4] <> u"小类代码":
rs.append(u'代码说明不符要求')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'代码 检查 未考虑大,中类,小类'
"""temp=[]
for rs in rs1:
if len(rs[2])<>8: #商品代码或品牌小类代码 8位
rs.append(u'商品代码或品牌小类代码长度必须为8位')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)"""
'上下限倍数必须是数值'
temp = []
for rs in rs1:
if type(eval(rs[5])) <> type(1.00) and type(eval(
rs[5])) <> type(1):
rs.append(u'上限倍数必须是数值')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
temp = []
for rs in rs1:
if type(eval(rs[6])) <> type(1.00) and type(eval(
rs[6])) <> type(1):
rs.append(u'下限倍数必须是数值')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'开始日期格式检查'
temp = []
for rs in rs1:
m = re.match(r'^\w\w\w\w-\w\w-\w\w$', rs[7])
if m == None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'结束日期格式检查'
temp = []
for rs in rs1:
m = re.match(r'^\w\w\w\w-\w\w-\w\w$', rs[8])
if m == None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='1200'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>代码名称</th><th>代码说明</th><th>上限倍数</th><th>下限倍数</th><th>规则开始时间</th><th>规则结束时间</th><th>备注</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td>" + rs[8] + "</td>"
html += "<td>" + rs[9] + "</td>"
html += "<td style='background-color:yellow'>" + rs[
10] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td>" + rs[8] + "</td>"
html += "<td>" + rs[9] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/delete_maxminCuxiaori.html')
html = t.render(Context())
return HttpResponse(html)
def import_dhrules(request):
'订货量修改规则导入'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=8)
rs2, rs1 = verifyData(rs1, length=8, required=[5, 6, 7], dhrules=1)
'重复项覆盖'
temp = []
for rs in rs1:
excode = rs[4]
if rs[4] == u'商品代码':
excode = 'sp'
if rs[4] == u'小类代码':
excode = 'xl'
if rs[4] == u'中类代码':
excode = 'zl'
if rs[4] == u'大类代码':
excode = 'dl'
yqkey = rs[5]
if rs[5] == u'上阈值':
yqkey = 'maxlimit'
if rs[5] == u'下阈值':
yqkey = 'minlimit'
sqlstr = u"select * from dhrules where mdcode='" + rs[
0] + "' and xcode = '" + rs[
2] + "' and excode='" + excode + "' and yqkey='" + yqkey + "'"
if confsql.checkExist(sqlstr) == 1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库已存在!')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='1000'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th></tr>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td style='background-color:yellow'>" + rs[8] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/import_dhrules.html')
html = t.render(Context())
return HttpResponse(html)
def delete_dhrulesYuzhi(request):
'删除暂停订货范围规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=12)
rs2,rs1=verifyData(rs1,length=12,required=[5,6,7,8,9])
'是否重复'
temp=[]
for rs in rs1:
excode=rs[4]
if rs[4]==u'商品代码':
excode='sp'
if rs[4]==u'品牌小类代码':
excode='braxl'
if rs[4]==u'大类代码':
excode='prodl'
if rs[4]==u'中类代码':
excode='prozl'
if rs[4]==u'小类代码':
excode='proxl'
sqlstr=u"select * from dhrulesYuzhi where mdcode='"+rs[0]+"' and xcode = '"+ rs[2] +"' and excode='"+excode+"' and startdate='"+rs[8]+"' and enddate = '" + rs[9] + "'"
if confsql.checkExist(sqlstr)<>1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库不存在!')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'门店代码商品代码 长度检查'
temp=[]
for rs in rs1:
if len(rs[0])<>5: #门店代码 5位
rs.append(u'门店代码长度必须为5位！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'代码说明 检查'
temp=[]
for rs in rs1:
if rs[4] <>u"商品代码" and rs[4]<>u"品牌小类代码" and rs[4]<>u"大类代码" and rs[4]<>u"中类代码" and rs[4]<>u"小类代码":
rs.append(u'代码说明不符要求！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'代码 检查'
temp=[]
for rs in rs1:
if rs[4]==u"商品代码" or rs[4]==u"品牌小类代码" or rs[4]==u"小类代码":
if len(rs[2])<>8: #商品代码或品牌小类代码 8位
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if rs[4]==u"中类代码":
if len(rs[2])<>5:
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if rs[4]==u"大类代码":
if len(rs[2])<>2:
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'规则说明只能填相对值'
temp=[]
for rs in rs1:
if rs[6]<>u'相对值':
rs.append(u'规则说明只能填“相对值”！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'规则值为百分比格式且大于0'
temp=[]
for rs in rs1:
if type(eval(rs[7]))<>type(1.00) or eval(rs[7])<0:
rs.append(u'规则值必须为正百分比格式！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'开始日期格式检查'
temp=[]
for rs in rs1:
m=re.match(r'^\w\w\w\w-\w\w-\w\w$',rs[8])
if m==None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'结束日期格式检查'
temp=[]
for rs in rs1:
m=re.match(r'^\w\w\w\w-\w\w-\w\w$',rs[9])
if m==None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd！')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='1200'><thead><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>代码名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th><th>开始日期</th><th>结束日期</th><th>备注</th><th>添加日期</th></tr></thead><tbody>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td>" + rs[8] + "</td>"
html+="<td>" + rs[9] + "</td>"
html+="<td>" + rs[10] + "</td>"
html+="<td>" + rs[11] + "</td>"
html+="<td style='background-color:yellow'>" + rs[12] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td>" + rs[8] + "</td>"
html+="<td>" + rs[9] + "</td>"
html+="<td>" + rs[10] + "</td>"
html+="<td>" + rs[11] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</tbody></table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/delete_dhrulesYuzhi.html')
html=t.render(Context())
return HttpResponse(html)
def delete_dhrulesYuzhi(request):
'删除暂停订货范围规则'
if request.method == 'POST':
value = request.POST['value']
rs1 = trim_csv(value, itemlenth=12)
rs2, rs1 = verifyData(rs1, length=12, required=[5, 6, 7, 8, 9])
'是否重复'
temp = []
for rs in rs1:
excode = rs[4]
if rs[4] == u'商品代码':
excode = 'sp'
if rs[4] == u'品牌小类代码':
excode = 'braxl'
if rs[4] == u'大类代码':
excode = 'prodl'
if rs[4] == u'中类代码':
excode = 'prozl'
if rs[4] == u'小类代码':
excode = 'proxl'
sqlstr = u"select * from dhrulesYuzhi where mdcode='" + rs[
0] + "' and xcode = '" + rs[
2] + "' and excode='" + excode + "' and startdate='" + rs[
8] + "' and enddate = '" + rs[9] + "'"
if confsql.checkExist(sqlstr) <> 1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库不存在!')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'门店代码商品代码 长度检查'
temp = []
for rs in rs1:
if len(rs[0]) <> 5: #门店代码 5位
rs.append(u'门店代码长度必须为5位！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'代码说明 检查'
temp = []
for rs in rs1:
if rs[4] <> u"商品代码" and rs[4] <> u"品牌小类代码" and rs[
4] <> u"大类代码" and rs[4] <> u"中类代码" and rs[4] <> u"小类代码":
rs.append(u'代码说明不符要求！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'代码 检查'
temp = []
for rs in rs1:
if rs[4] == u"商品代码" or rs[4] == u"品牌小类代码" or rs[4] == u"小类代码":
if len(rs[2]) <> 8: #商品代码或品牌小类代码 8位
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if rs[4] == u"中类代码":
if len(rs[2]) <> 5:
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if rs[4] == u"大类代码":
if len(rs[2]) <> 2:
rs.append(u'代码长度不符！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'规则说明只能填相对值'
temp = []
for rs in rs1:
if rs[6] <> u'相对值':
rs.append(u'规则说明只能填“相对值”！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'规则值为百分比格式且大于0'
temp = []
for rs in rs1:
if type(eval(rs[7])) <> type(1.00) or eval(rs[7]) < 0:
rs.append(u'规则值必须为正百分比格式！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'开始日期格式检查'
temp = []
for rs in rs1:
m = re.match(r'^\w\w\w\w-\w\w-\w\w$', rs[8])
if m == None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
'结束日期格式检查'
temp = []
for rs in rs1:
m = re.match(r'^\w\w\w\w-\w\w-\w\w$', rs[9])
if m == None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd！')
temp.append(rs)
rs2.append(rs)
if len(temp) > 0:
for rs in temp:
rs1.remove(rs)
html = u"<table width='1200'><thead><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>代码名称</th><th>代码说明</th><th>规则对象</th><th>规则说明</th><th>规则值</th><th>开始日期</th><th>结束日期</th><th>备注</th><th>添加日期</th></tr></thead><tbody>"
if len(rs2) > 0:
for rs in rs2:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td>" + rs[8] + "</td>"
html += "<td>" + rs[9] + "</td>"
html += "<td>" + rs[10] + "</td>"
html += "<td>" + rs[11] + "</td>"
html += "<td style='background-color:yellow'>" + rs[
12] + "</td>"
html += "</tr>"
if len(rs1) > 0:
for rs in rs1:
html += "<tr>"
html += "<td>" + rs[0] + "</td>"
html += "<td>" + rs[1] + "</td>"
html += "<td>" + rs[2] + "</td>"
html += "<td>" + rs[3] + "</td>"
html += "<td>" + rs[4] + "</td>"
html += "<td>" + rs[5] + "</td>"
html += "<td>" + rs[6] + "</td>"
html += "<td>" + rs[7] + "</td>"
html += "<td>" + rs[8] + "</td>"
html += "<td>" + rs[9] + "</td>"
html += "<td>" + rs[10] + "</td>"
html += "<td>" + rs[11] + "</td>"
html += "<td></td>"
html += "</tr>"
html += "</tbody></table>"
return HttpResponse(Context(html))
else:
t = get_template('mana1/delete_dhrulesYuzhi.html')
html = t.render(Context())
return HttpResponse(html)
def delete_maxminCuxiaori(request):
'删除促销日上下限规则'
if request.method=='POST':
value=request.POST['value']
rs1=trim_csv(value,itemlenth=10)
rs2,rs1=verifyData(rs1,length=10,required=[0,2,4,5,6,7,8])
'重复项覆盖'
temp=[]
for rs in rs1:
excode=rs[4]
if rs[4]==u'商品代码':
excode='sp'
if rs[4]==u'品牌小类代码':
excode='braxl'
if rs[4]==u'大类代码':
excode='prodl'
if rs[4]==u'中类代码':
excode='prozl'
if rs[4]==u'小类代码':
excode='proxl'
sqlstr=u"select * from maxminCuxiaori where mdcode='"+rs[0]+"' and xcode = '"+ rs[2] +"' and excode='"+excode+"' and startdate='"+rs[7]+"' and enddate = '" + rs[8] + "'"
if confsql.checkExist(sqlstr)<>1: #检查mdcode,excode,yqkey数据库是否已存在
rs.append(u'数据库中不存在!')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'门店代码商品代码 长度检查'
temp=[]
for rs in rs1:
if len(rs[0])<>5: #门店代码 5位
rs.append(u'门店代码长度必须为5位')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'代码说明 检查'
temp=[]
for rs in rs1:
if rs[4] <>u"商品代码" and rs[4]<>u"品牌小类代码" and rs[4]<>u"大类代码" and rs[4]<>u"中类代码" and rs[4]<>u"小类代码":
rs.append(u'代码说明不符要求')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'代码 检查 未考虑大,中类,小类'
"""temp=[]
for rs in rs1:
if len(rs[2])<>8: #商品代码或品牌小类代码 8位
rs.append(u'商品代码或品牌小类代码长度必须为8位')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)"""
'上下限倍数必须是数值'
temp=[]
for rs in rs1:
if type(eval(rs[5]))<>type(1.00) and type(eval(rs[5]))<>type(1):
rs.append(u'上限倍数必须是数值')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
temp=[]
for rs in rs1:
if type(eval(rs[6]))<>type(1.00) and type(eval(rs[6]))<>type(1):
rs.append(u'下限倍数必须是数值')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'开始日期格式检查'
temp=[]
for rs in rs1:
m=re.match(r'^\w\w\w\w-\w\w-\w\w$',rs[7])
if m==None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
'结束日期格式检查'
temp=[]
for rs in rs1:
m=re.match(r'^\w\w\w\w-\w\w-\w\w$',rs[8])
if m==None: #日期格式 yyyy-mm-dd
rs.append(u'日期格式必须为yyyy-mm-dd')
temp.append(rs)
rs2.append(rs)
if len(temp)>0:
for rs in temp:
rs1.remove(rs)
html=u"<table width='1200'><tr><th>门店代码</th><th>门店名称</th><th>代码</th><th>代码名称</th><th>代码说明</th><th>上限倍数</th><th>下限倍数</th><th>规则开始时间</th><th>规则结束时间</th><th>备注</th></tr>"
if len(rs2)>0:
for rs in rs2:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td>" + rs[8] + "</td>"
html+="<td>" + rs[9] + "</td>"
html+="<td style='background-color:yellow'>" + rs[10] + "</td>"
html+="</tr>"
if len(rs1)>0:
for rs in rs1:
html+="<tr>"
html+="<td>" + rs[0] + "</td>"
html+="<td>" + rs[1] + "</td>"
html+="<td>" + rs[2] + "</td>"
html+="<td>" + rs[3] + "</td>"
html+="<td>" + rs[4] + "</td>"
html+="<td>" + rs[5] + "</td>"
html+="<td>" + rs[6] + "</td>"
html+="<td>" + rs[7] + "</td>"
html+="<td>" + rs[8] + "</td>"
html+="<td>" + rs[9] + "</td>"
html+="<td></td>"
html+="</tr>"
html+="</table>"
return HttpResponse(Context(html))
else:
t=get_template('mana1/delete_maxminCuxiaori.html')
html=t.render(Context())
return HttpResponse(html)