def deleteData_quantou(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"],itemlenth=0)
if len(rs1)>0:
for rs in rs1:
if rs[2]<>'': #出错信息的保留
res={}
res['proid']=rs[0]
res['proname']=rs[1]
res['info']=rs[2]
result.append(res)
else:
try:
res={}
sqlstr=u"delete from quantou where proid='"+rs[0]+"'"
confsql.runSql(sqlstr)
res={}
res['proid']=rs[0]
res['proname']=rs[1]
res['info']=u'删除成功!'
result.append(res)
except:
res={}
res['proid']=rs[0]
res['proname']=rs[1]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_quantou(request):
'保存拳头产品'
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
for rs in rs1:
if rs[2]==u'数据库已存在!':
try:
confsql.runSql("delete from quantou where proid='"+rs[0]+"'")
except:
rs[2]=u'删除失败!'
try:
confsql.runSql("insert into quantou values('"+rs[0]+"','"+datetime.date.today().strftime("%Y-%m-%d")+"')")
rs[2]=u'插入成功!'
except:
rs[2]=u'插入失败!'
res={}
res['proid']=rs[0]
res['proname']=rs[1]
res['info']=rs[2]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_tianshu(request):
'保存拳头产品'
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
for rs in rs1:
if rs[4] == u'数据库已存在!':
try:
confsql.runSql("delete from tianshu where braid='" + rs[0] +
"'")
except:
rs[4] = u'删除失败!'
try:
confsql.runSql("insert into tianshu values('" + rs[0] + "','" +
rs[2] + "','" + rs[3] + "','" +
datetime.date.today().strftime("%Y-%m-%d") + "')")
rs[4] = u'插入成功!'
except:
rs[4] = u'插入失败!'
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['anquankucun'] = rs[2]
res['peisongzhouqi'] = rs[3]
res['info'] = rs[4]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_maxmin(request):
' 上下限导入检查 写入数据库 '
try:
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
banben = myjson["banben"]
startdate = myjson["startdate"]
enddate = myjson["enddate"]
#插入数据库
sqlstr = ""
for rs in rs1:
if rs[6] == '':
sqlstr += "delete from maxmin where braid ='" + rs[
0] + "' and proid='" + rs[
2] + "' and banben='" + banben + "';"
if sqlstr <> "":
confsql.runSql(sqlstr) #数据库
sqlstr = ""
for rs in rs1:
if rs[6] == '':
adddate = datetime.datetime.now().strftime(
'%Y-%m-%d') #最后追加插入日期
sqlstr += "insert into maxmin(braid,proid,maxval,minval,banben,startdate,enddate,adddate) values('" + rs[
0] + "','" + rs[2] + "','" + rs[4] + "','" + rs[
5] + "','" + banben + "','" + startdate + "','" + enddate + "','" + adddate + "');"
rs[6] = '插入成功!'
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['maxval'] = rs[4]
res['minval'] = rs[5]
res['info'] = rs[6]
result.append(res)
else:
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['maxval'] = rs[4]
res['minval'] = rs[5]
res['info'] = rs[6]
result.append(res)
if sqlstr <> "":
confsql.runSql(sqlstr) #数据库
jsonres = simplejson.dumps(result)
log(jsonres)
return HttpResponse(jsonres)
except:
return HttpResponse(0)
def save_basedisplay(request):
'保存订货量修改规则'
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
for rs in rs1:
if rs[5] <> '':
if rs[5] == u'数据库已存在!':
try:
confsql.runSql("update basedisplay set basedisplay='" +
rs[4] + "' where braid='" + rs[0] +
"' and proid='" + rs[2] + "'")
rs[5] = '插入成功!'
except:
rs[5] = '插入失败!'
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = rs[5]
result.append(res)
else:
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = rs[5]
result.append(res)
else: #无误的
try:
confsql.runSql(
"insert into basedisplay(braid,proid,basedisplay) values('"
+ rs[0] + "','" + rs[2] + "','" + rs[4] + "')")
rs[5] = '插入成功!'
except:
rs[5] = '插入失败!'
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = rs[5]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_product_gl_packetqty_rules(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
#log(rs1)
if len(rs1) > 0:
for rs in rs1:
if rs[4] <> '': #出错信息的保留
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = rs[4]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
excode = rs[2]
if rs[2] == u'商品代码':
excode = 'sp'
if rs[2] == u'小类代码':
excode = 'xl'
if rs[2] == u'中类代码':
excode = u'zl'
if rs[2] == '大类代码':
excode = u'dl'
#log("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'")
confsql.runSql(
"delete from product_gl_packetqty_rules where xcode='"
+ rs[0] + "' and excode='" + excode + "'")
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = u'删除成功!'
result.append(res)
except:
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_basedisplay(request):
'保存订货量修改规则'
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
for rs in rs1:
if rs[5]<>'':
if rs[5]==u'数据库已存在!':
try:
confsql.runSql("update basedisplay set basedisplay='"+rs[4]+"' where braid='"+rs[0]+"' and proid='"+rs[2]+"'")
rs[5]='插入成功!'
except:
rs[5]='插入失败!'
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['proid']=rs[2]
res['proname']=rs[3]
res['basedisplay']=rs[4]
res['info']=rs[5]
result.append(res)
else:
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['proid']=rs[2]
res['proname']=rs[3]
res['basedisplay']=rs[4]
res['info']=rs[5]
result.append(res)
else: #无误的
try:
confsql.runSql("insert into basedisplay(braid,proid,basedisplay) values('"+rs[0]+"','"+rs[2]+"','"+rs[4]+"')")
rs[5]='插入成功!'
except:
rs[5]='插入失败!'
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['proid']=rs[2]
res['proname']=rs[3]
res['basedisplay']=rs[4]
res['info']=rs[5]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_maxmin(request):
' 上下限导入检查 写入数据库 '
try:
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
banben=myjson["banben"]
startdate=myjson["startdate"]
enddate=myjson["enddate"]
#插入数据库
sqlstr=""
for rs in rs1:
if rs[6]=='':
sqlstr+="delete from maxmin where braid ='" + rs[0] + "' and proid='" + rs[2] + "' and banben='" + banben + "';"
if sqlstr<>"":
confsql.runSql(sqlstr) #数据库
sqlstr=""
for rs in rs1:
if rs[6]=='':
adddate=datetime.datetime.now().strftime('%Y-%m-%d') #最后追加插入日期
sqlstr+="insert into maxmin(braid,proid,maxval,minval,banben,startdate,enddate,adddate) values('"+rs[0]+"','"+rs[2]+"','"+rs[4]+"','"+rs[5]+"','"+banben+"','"+startdate+"','"+enddate+"','"+adddate+"');"
rs[6]='插入成功!'
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['proid']=rs[2]
res['proname']=rs[3]
res['maxval']=rs[4]
res['minval']=rs[5]
res['info']=rs[6]
result.append(res)
else:
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['proid']=rs[2]
res['proname']=rs[3]
res['maxval']=rs[4]
res['minval']=rs[5]
res['info']=rs[6]
result.append(res)
if sqlstr<>"":
confsql.runSql(sqlstr) #数据库
jsonres=simplejson.dumps(result)
log(jsonres)
return HttpResponse(jsonres)
except:
return HttpResponse(0)
def deleteData_product_gl_packetqty_rules(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
#log(rs1)
if len(rs1)>0:
for rs in rs1:
if rs[4]<>'': #出错信息的保留
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=rs[4]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
excode=rs[2]
if rs[2]==u'商品代码':
excode='sp'
if rs[2]==u'小类代码':
excode='xl'
if rs[2]==u'中类代码':
excode=u'zl'
if rs[2]=='大类代码':
excode=u'dl'
#log("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'")
confsql.runSql("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'")
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=u'删除成功!'
result.append(res)
except:
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_delivery(request):
'''配送规则导入检查并插入数据库'''
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
adddate=datetime.datetime.now().strftime('%Y-%m-%d')
for rs in rs1:
#log(rs)
if rs[3]<>'':
if rs[3]==u'数据库已存在':
try:
#confsql.runSql("update delivery set adddate='"+adddate+"' where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'")
sqlstr ="delete from delivery where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'; "
sqlstr +=" insert into delivery(braid,weekdelivery,adddate) values('"+rs[0]+"','"+rs[2]+"','"+adddate+"') "
confsql.runSql(sqlstr)
rs[3]=u'插入成功!'
except:
rs[3]=u'插入失败!'
else:
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['weekdelivery']=rs[2]
res['adddate']=adddate
res['info']=rs[3]
result.append(res)
else:
try:
sqlstr="insert into delivery(braid,weekdelivery,adddate) values('"+rs[0]+"','"+rs[2]+"','"+adddate+"')"
confsql.runSql(sqlstr)
rs[3]=u'插入成功!'
except:
rs[3]=u'插入失败!'
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['weekdelivery']=rs[2]
res['adddate']=adddate
res['info']=rs[3]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_basedisplay(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"], itemlenth=0)
if len(rs1) > 0:
for rs in rs1:
if rs[5] <> '': #出错信息的保留
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = rs[5]
result.append(res)
else:
try:
sqlstr = u"delete from basedisplay where braid='" + rs[
0] + "' and proid='" + rs[2] + "'"
confsql.runSql(sqlstr)
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = u'删除成功!'
result.append(res)
except:
res = {}
res['braid'] = rs[0]
res['braname'] = rs[1]
res['proid'] = rs[2]
res['proname'] = rs[3]
res['basedisplay'] = rs[4]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_delivery(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"],itemlenth=0)
adddate=datetime.datetime.now().strftime('%Y-%m-%d')
if len(rs1)>0:
for rs in rs1:
if rs[3]<>'': #出错信息的保留
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['weekdelivery']=rs[2]
res['adddate']=adddate
res['info']=rs[3]
result.append(res)
else:
try:
sqlstr="delete from delivery where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'"
confsql.runSql(sqlstr)
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['weekdelivery']=rs[2]
res['adddate']=adddate
res['info']=u'删除成功!'
result.append(res)
except:
res={}
res['braid']=rs[0]
res['braname']=rs[1]
res['weekdelivery']=rs[2]
res['adddate']=adddate
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_dhrules(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"], itemlenth=0)
if len(rs1) > 0:
for rs in rs1:
if rs[8] <> '': #出错信息的保留
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = rs[8]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
res = {}
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"delete from dhrules where mdcode='" + rs[
0] + "' and xcode ='" + rs[
2] + "' and excode='" + excode + "' and yqkey='" + yqkey + "'"
#log(sqlstr)
confsql.runSql(sqlstr)
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = u'删除成功!'
result.append(res)
except:
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_dhrulesYuzhi(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
if len(rs1)>0:
for rs in rs1:
if rs[12]<>'': #出错信息的保留
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['startdate']=rs[8]
res['enddate']=rs[9]
res['remark']=rs[10]
res['adddate']=rs[11]
res['info']=rs[12]
result.append(res)
else: #无出错信息的执行删除
try:
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'
confsql.runSql("delete from dhrulesYuzhi where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[8]+"' and enddate = '" + rs[9] + "'")
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['startdate']=rs[8]
res['enddate']=rs[9]
res['remark']=rs[10]
res['adddate']=rs[11]
res['info']=u'删除成功!'
result.append(res)
except:
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['startdate']=rs[8]
res['enddate']=rs[9]
res['remark']=rs[10]
res['adddate']=rs[11]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_dhrulesYuzhi(request):
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
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'
adddate = time.strftime("%Y-%m-%d", time.localtime())
if rs[10]<>'':
if rs[10]==u'数据库已存在!':
try:
confsql.runSql(u"delete from dhrulesYuzhi where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[7]+"' and enddate = '" + rs[8] + "'")
confsql.runSql(u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','相对值','"+rs[6]+"','"+rs[7]+"','"+rs[8]+"','"+adddate+"')")
rs[10]=u'插入成功!'
except:
rs[10]=u'插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=u"相对值"
res['yqvalue']=rs[6]
res['startdate']=rs[7]
res['enddate']=rs[8]
res['remark']=rs[9]
res['info']=rs[10]
result.append(res)
else: #无误的
try:
sqlstr=u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+u"相对值"+"','"+rs[6]+"','"+rs[7]+"','"+rs[8]+"','"+rs[9]+"','"+adddate+"')"
confsql.runSql(sqlstr)
rs[10]=u'插入成功!'
except:
rs[10]=u'插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=u"相对值"
res['yqvalue']=rs[6]
res['startdate']=rs[7]
res['enddate']=rs[8]
res['remark']=rs[9]
res['info']=rs[10]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_dhPauserules(request):
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"].encode('utf8'))
rs1=trim_csv(myjson["table"])
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'
adddate = time.strftime("%Y-%m-%d", time.localtime())
if rs[7]<>'':
if rs[7]==u'数据库已存在!':
try:
#confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'")
#log("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'")
confsql.runSql("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'")
confsql.runSql("insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+rs[6]+"','"+adddate+"')")
rs[7]='插入成功!'
except:
rs[7]='插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=rs[7]
result.append(res)
else:
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=rs[7]
result.append(res)
else: #无误的
try:
confsql.runSql("insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+rs[6]+"','"+adddate+"')")
rs[7]='插入成功!'
except:
rs[7]='插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=rs[7]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_maxminCuxiaori(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
if len(rs1) > 0:
for rs in rs1:
if rs[10] <> '': #出错信息的保留
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['max_multiple'] = rs[5]
res['min_multiple'] = rs[6]
res['startdate'] = rs[7]
res['enddate'] = rs[8]
res['remark'] = rs[9]
res['info'] = rs[10]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
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'
confsql.runSql(
"delete from maxminCuxiaori where mdcode='" + rs[0] +
"' and xcode='" + rs[2] + "' and excode='" + excode +
"' and startdate='" + rs[7] + "' and enddate = '" +
rs[8] + "'")
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['max_multiple'] = rs[5]
res['min_multiple'] = rs[6]
res['startdate'] = rs[7]
res['enddate'] = rs[8]
res['remark'] = rs[9]
res['info'] = u'删除成功!'
result.append(res)
except:
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['max_multiple'] = rs[5]
res['min_multiple'] = rs[6]
res['startdate'] = rs[7]
res['enddate'] = rs[8]
res['remark'] = rs[9]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def backup_maxmin(request):
'备份上下限'
if request.method=='POST':
try:
jlist=simplejson.loads(request.POST["jsonlist"])
if jlist['proid']<>'' or jlist['proname']<>'' or jlist['braid']<>'' or jlist['braname']<>'' or jlist['prodl']<>'' or jlist['prozl']<>'' or jlist['proxl']<>'': #不全为空
sqlstr="""
insert into maxmin_bak
select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today().strftime('%Y-%m-%d') + """' from(
select * from (
select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate
from maxmin t1,branch t2,product_all t3
where t1.braid=t2.braid and t1.proid=t3.proid
) t1 where
"""
for j in jlist:
if jlist[j]<>'':
li=jlist[j].split(",")
if len(li)==1: #一个条件
sqlstr+=j+" like '%%"+jlist[j].strip()+"%%' and "
else: #逗号分隔的多条件
sqlstr+="("
for l in li:
sqlstr+=j+" like '%%"+l.strip() +"%%' or "
sqlstr=sqlstr[0:-4]+") and "
sqlstr=sqlstr[0:-4]
sqlstr+=") tt1"
confsql.runSql(sqlstr)
sqlstr="""
select count(*) from (
select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate
from maxmin t1,branch t2,product_all t3
where t1.braid=t2.braid and t1.proid=t3.proid
) t1 where
"""
for j in jlist:
if jlist[j]<>'':
li=jlist[j].split(",")
if len(li)==1: #一个条件
sqlstr+=j+" like '%%"+jlist[j].strip()+"%%' and "
else: #逗号分隔的多条件
sqlstr+="("
for l in li:
sqlstr+=j+" like '%%"+l.strip() +"%%' or "
sqlstr=sqlstr[0:-4]+") and "
sqlstr=sqlstr[0:-4]
result=confsql.runquery(sqlstr)
for rs in result:
num=rs[0]
return HttpResponse(num)
else: #全为空，查询所有
sqlstr="""
insert into maxmin_bak
select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today().strftime('%Y-%m-%d') + """'
from maxmin
"""
confsql.runSql(sqlstr)
sqlstr="select count(*) from maxmin"
result=confsql.runquery(sqlstr)
for rs in result:
num=rs[0]
return HttpResponse(num)
except:
return HttpResponse(0)
else:
t=get_template('mana1/backup_maxmin.html')
html=t.render(Context())
return HttpResponse(html)
def deleteData_dhrules(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"],itemlenth=0)
if len(rs1)>0:
for rs in rs1:
if rs[8]<>'': #出错信息的保留
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=rs[8]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
res={}
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"delete from dhrules where mdcode='"+rs[0]+"' and xcode ='"+rs[2] +"' and excode='"+excode+"' and yqkey='"+yqkey+"'"
#log(sqlstr)
confsql.runSql(sqlstr)
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=u'删除成功!'
result.append(res)
except:
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_dhrulesYuzhi(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
if len(rs1) > 0:
for rs in rs1:
if rs[12] <> '': #出错信息的保留
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['startdate'] = rs[8]
res['enddate'] = rs[9]
res['remark'] = rs[10]
res['adddate'] = rs[11]
res['info'] = rs[12]
result.append(res)
else: #无出错信息的执行删除
try:
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'
confsql.runSql("delete from dhrulesYuzhi where mdcode='" +
rs[0] + "' and xcode='" + rs[2] +
"' and excode='" + excode +
"' and startdate='" + rs[8] +
"' and enddate = '" + rs[9] + "'")
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['startdate'] = rs[8]
res['enddate'] = rs[9]
res['remark'] = rs[10]
res['adddate'] = rs[11]
res['info'] = u'删除成功!'
result.append(res)
except:
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['startdate'] = rs[8]
res['enddate'] = rs[9]
res['remark'] = rs[10]
res['adddate'] = rs[11]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_dhrulesYuzhi(request):
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
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'
adddate = time.strftime("%Y-%m-%d", time.localtime())
if rs[10] <> '':
if rs[10] == u'数据库已存在!':
try:
confsql.runSql(u"delete from dhrulesYuzhi where mdcode='" +
rs[0] + "' and xcode='" + rs[2] +
"' and excode='" + excode +
"' and startdate='" + rs[7] +
"' and enddate = '" + rs[8] + "'")
confsql.runSql(
u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('"
+ rs[0] + "','" + rs[2] + "','" + excode + "','" +
rs[5] + "','相对值','" + rs[6] + "','" + rs[7] + "','" +
rs[8] + "','" + adddate + "')")
rs[10] = u'插入成功!'
except:
rs[10] = u'插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = u"相对值"
res['yqvalue'] = rs[6]
res['startdate'] = rs[7]
res['enddate'] = rs[8]
res['remark'] = rs[9]
res['info'] = rs[10]
result.append(res)
else: #无误的
try:
sqlstr = u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('" + rs[
0] + "','" + rs[2] + "','" + excode + "','" + rs[
5] + "','" + u"相对值" + "','" + rs[6] + "','" + rs[
7] + "','" + rs[8] + "','" + rs[
9] + "','" + adddate + "')"
confsql.runSql(sqlstr)
rs[10] = u'插入成功!'
except:
rs[10] = u'插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = u"相对值"
res['yqvalue'] = rs[6]
res['startdate'] = rs[7]
res['enddate'] = rs[8]
res['remark'] = rs[9]
res['info'] = rs[10]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_product_gl_packetqty_rules(request):
'保存商品配货单位规则'
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
#sp, xl, zl, dl, null
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'
if rs[4]<>'':
if rs[4]==u'数据库已存在!':
try:
sqlstr="delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='" + excode + "'"
confsql.runSql(sqlstr)
sqlstr="insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('"+rs[0]+"','"+excode+"','"+rs[3]+"')"
confsql.runSql(sqlstr)
rs[4]='插入成功!'
except:
rs[4]='插入失败!'
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=rs[4]
result.append(res)
else:
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=rs[4]
result.append(res)
else:
try:
sqlstr="insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('"+rs[0]+"','"+excode+"','"+rs[3]+"')"
confsql.runSql(sqlstr)
rs[4]='插入成功!'
except:
rs[4]='插入失败!'
res={}
res['xcode']=rs[0]
res['name']=rs[1]
res['excode']=rs[2]
res['packetqty1']=rs[3]
res['info']=rs[4]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def save_product_gl_packetqty_rules(request):
'保存商品配货单位规则'
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
#sp, xl, zl, dl, null
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'
if rs[4] <> '':
if rs[4] == u'数据库已存在!':
try:
sqlstr = "delete from product_gl_packetqty_rules where xcode='" + rs[
0] + "' and excode='" + excode + "'"
confsql.runSql(sqlstr)
sqlstr = "insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('" + rs[
0] + "','" + excode + "','" + rs[3] + "')"
confsql.runSql(sqlstr)
rs[4] = '插入成功!'
except:
rs[4] = '插入失败!'
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = rs[4]
result.append(res)
else:
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = rs[4]
result.append(res)
else:
try:
sqlstr = "insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('" + rs[
0] + "','" + excode + "','" + rs[3] + "')"
confsql.runSql(sqlstr)
rs[4] = '插入成功!'
except:
rs[4] = '插入失败!'
res = {}
res['xcode'] = rs[0]
res['name'] = rs[1]
res['excode'] = rs[2]
res['packetqty1'] = rs[3]
res['info'] = rs[4]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_dhPauserules(request):
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"].encode('utf8'))
rs1 = trim_csv(myjson["table"])
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'
adddate = time.strftime("%Y-%m-%d", time.localtime())
if rs[7] <> '':
if rs[7] == u'数据库已存在!':
try:
#confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'")
#log("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'")
confsql.runSql("delete from dhpauserules where mdcode='" +
rs[0] + "' and xcode='" + rs[2] +
"' and excode='" + excode +
"' and startdate='" + rs[5] +
"' and enddate = '" + rs[6] + "'")
confsql.runSql(
"insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"
+ rs[0] + "','" + rs[2] + "','" + excode + "','" +
rs[5] + "','" + rs[6] + "','" + adddate + "')")
rs[7] = '插入成功!'
except:
rs[7] = '插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = rs[7]
result.append(res)
else:
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = rs[7]
result.append(res)
else: #无误的
try:
confsql.runSql(
"insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"
+ rs[0] + "','" + rs[2] + "','" + excode + "','" + rs[5] +
"','" + rs[6] + "','" + adddate + "')")
rs[7] = '插入成功!'
except:
rs[7] = '插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = rs[7]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def save_dhrules(request):
'保存订货量修改规则'
rs1 = []
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"])
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'
yqrule = rs[6]
if rs[6] == u'绝对值':
yqrule = 'jd'
if rs[6] == u'相对值':
yqrule = 'xd'
if rs[8] <> '':
if rs[8] == u'数据库已存在!':
try:
#confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'")
confsql.runSql("delete from dhrules where mdcode='" +
rs[0] + "' and xcode='" + rs[2] +
"' and excode='" + excode +
"' and yqkey='" + yqkey + "'")
confsql.runSql(
"insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"
+ rs[0] + "','" + rs[2] + "','" + excode + "','" +
yqkey + "','" + yqrule + "','" + rs[7] + "')")
rs[8] = '插入成功!'
except:
rs[8] = '插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = rs[8]
result.append(res)
else:
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = rs[8]
result.append(res)
else: #无误的
try:
confsql.runSql(
"insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"
+ rs[0] + "','" + rs[2] + "','" + excode + "','" + yqkey +
"','" + yqrule + "','" + rs[7] + "')")
rs[8] = '插入成功!'
except:
rs[8] = '插入失败!'
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['yqkey'] = rs[5]
res['yqrule'] = rs[6]
res['yqvalue'] = rs[7]
res['info'] = rs[8]
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_dhPauserules(request):
'删除数据'
result = []
myjson = simplejson.loads(request.POST["myjson"])
rs1 = trim_csv(myjson["table"], itemlenth=0)
if len(rs1) > 0:
for rs in rs1:
if rs[7] <> '': #出错信息的保留
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = rs[7]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
res = {}
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'
confsql.runSql("delete from dhpauserules where mdcode='" +
rs[0] + "' and xcode='" + rs[2] +
"' and excode='" + excode +
"' and startdate='" + rs[5] +
"' and enddate = '" + rs[6] + "'")
res = {}
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = u'删除成功!'
result.append(res)
except:
res['mdcode'] = rs[0]
res['mdname'] = rs[1]
res['xcode'] = rs[2]
res['name'] = rs[3]
res['excode'] = rs[4]
res['startdate'] = rs[5]
res['enddate'] = rs[6]
res['info'] = u'删除失败!'
result.append(res)
jsonres = simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_dhPauserules(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"],itemlenth=0)
if len(rs1)>0:
for rs in rs1:
if rs[7]<>'': #出错信息的保留
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=rs[7]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
res={}
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'
confsql.runSql("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'")
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=u'删除成功!'
result.append(res)
except:
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['startdate']=rs[5]
res['enddate']=rs[6]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def backup_maxmin(request):
'备份上下限'
if request.method == 'POST':
try:
jlist = simplejson.loads(request.POST["jsonlist"])
if jlist['proid'] <> '' or jlist['proname'] <> '' or jlist[
'braid'] <> '' or jlist['braname'] <> '' or jlist[
'prodl'] <> '' or jlist['prozl'] <> '' or jlist[
'proxl'] <> '': #不全为空
sqlstr = """
insert into maxmin_bak
select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today(
).strftime('%Y-%m-%d') + """' from(
select * from (
select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate
from maxmin t1,branch t2,product_all t3
where t1.braid=t2.braid and t1.proid=t3.proid
) t1 where
"""
for j in jlist:
if jlist[j] <> '':
li = jlist[j].split(",")
if len(li) == 1: #一个条件
sqlstr += j + " like '%%" + jlist[j].strip(
) + "%%' and "
else: #逗号分隔的多条件
sqlstr += "("
for l in li:
sqlstr += j + " like '%%" + l.strip(
) + "%%' or "
sqlstr = sqlstr[0:-4] + ") and "
sqlstr = sqlstr[0:-4]
sqlstr += ") tt1"
confsql.runSql(sqlstr)
sqlstr = """
select count(*) from (
select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate
from maxmin t1,branch t2,product_all t3
where t1.braid=t2.braid and t1.proid=t3.proid
) t1 where
"""
for j in jlist:
if jlist[j] <> '':
li = jlist[j].split(",")
if len(li) == 1: #一个条件
sqlstr += j + " like '%%" + jlist[j].strip(
) + "%%' and "
else: #逗号分隔的多条件
sqlstr += "("
for l in li:
sqlstr += j + " like '%%" + l.strip(
) + "%%' or "
sqlstr = sqlstr[0:-4] + ") and "
sqlstr = sqlstr[0:-4]
result = confsql.runquery(sqlstr)
for rs in result:
num = rs[0]
return HttpResponse(num)
else: #全为空，查询所有
sqlstr = """
insert into maxmin_bak
select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today(
).strftime('%Y-%m-%d') + """'
from maxmin
"""
confsql.runSql(sqlstr)
sqlstr = "select count(*) from maxmin"
result = confsql.runquery(sqlstr)
for rs in result:
num = rs[0]
return HttpResponse(num)
except:
return HttpResponse(0)
else:
t = get_template('mana1/backup_maxmin.html')
html = t.render(Context())
return HttpResponse(html)
def save_dhrules(request):
'保存订货量修改规则'
rs1=[]
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
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'
yqrule = rs[6]
if rs[6]==u'绝对值':
yqrule='jd'
if rs[6]==u'相对值':
yqrule='xd'
if rs[8]<>'':
if rs[8]==u'数据库已存在!':
try:
#confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'")
confsql.runSql("delete from dhrules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'")
confsql.runSql("insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+yqkey+"','"+yqrule+"','"+rs[7]+"')")
rs[8]='插入成功!'
except:
rs[8]='插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=rs[8]
result.append(res)
else:
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=rs[8]
result.append(res)
else: #无误的
try:
confsql.runSql("insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+yqkey+"','"+yqrule+"','"+rs[7]+"')")
rs[8]='插入成功!'
except:
rs[8]='插入失败!'
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['yqkey']=rs[5]
res['yqrule']=rs[6]
res['yqvalue']=rs[7]
res['info']=rs[8]
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
def deleteData_maxminCuxiaori(request):
'删除数据'
result=[]
myjson=simplejson.loads(request.POST["myjson"])
rs1=trim_csv(myjson["table"])
if len(rs1)>0:
for rs in rs1:
if rs[10]<>'': #出错信息的保留
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['max_multiple']=rs[5]
res['min_multiple']=rs[6]
res['startdate']=rs[7]
res['enddate']=rs[8]
res['remark']=rs[9]
res['info']=rs[10]
result.append(res)
else:
try:
#sp, xl, zl, dl, null
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'
confsql.runSql("delete from maxminCuxiaori where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[7]+"' and enddate = '" + rs[8] + "'")
res={}
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['max_multiple']=rs[5]
res['min_multiple']=rs[6]
res['startdate']=rs[7]
res['enddate']=rs[8]
res['remark']=rs[9]
res['info']=u'删除成功!'
result.append(res)
except:
res['mdcode']=rs[0]
res['mdname']=rs[1]
res['xcode']=rs[2]
res['name']=rs[3]
res['excode']=rs[4]
res['max_multiple']=rs[5]
res['min_multiple']=rs[6]
res['startdate']=rs[7]
res['enddate']=rs[8]
res['remark']=rs[9]
res['info']=u'删除失败!'
result.append(res)
jsonres=simplejson.dumps(result)
return HttpResponse(jsonres)
