def update_pwd(request):
rs = {}
ucode = request.POST.get('ucode')
passwd = request.POST.get('passwd')
try:
user = BasUser.objects.get(ucode=ucode)
user.password = mtu.md5(passwd)
user.save()
rs["status"] = "0"
except Exception as e:
rs["status"] = "1"
print(e)
return HttpResponse(json.dumps(rs))
def update_pwd(request):
rs = {}
ucode = request.POST.get('ucode')
passwd = request.POST.get('passwd')
try:
user = BasUser.objects.get(ucode=ucode)
user.password = mtu.md5(passwd)
user.save()
rs["status"] = "0"
except Exception as e:
rs["status"] = "1"
print(e)
return HttpResponse(json.dumps(rs))
def uppwd(request):
data = {}
flag = mtu.getReqVal(request, "flag")
#修改
if flag == "1":
user = request.session.get("s_user", None)
ucode = user["ucode"]
elif flag == "2":
ucode = mtu.getReqVal(request, "ucode")
data["result"] = "1"
try:
newPwd = mtu.getReqVal(request, "newPwd", "")
pwd = mtu.md5(newPwd)
BasUser.objects.filter(ucode=ucode).update(password=pwd)
data["result"] = "0"
except Exception as e:
print(e)
return HttpResponse(json.dumps(data))
def uppwd(request):
data = {}
flag = mtu.getReqVal(request,"flag")
#修改
if flag=="1":
user = request.session.get("s_user",None)
ucode = user["ucode"]
elif flag=="2":
ucode = mtu.getReqVal(request,"ucode")
data["result"] = "1"
try:
newPwd = mtu.getReqVal(request,"newPwd","")
pwd = mtu.md5(newPwd)
BasUser.objects.filter(ucode=ucode).update(password=pwd)
data["result"] = "0"
except Exception as e:
print(e)
return HttpResponse(json.dumps(data))
def login(request):
ucode = mtu.getReqVal(request, "ucode", "")
password = mtu.getReqVal(request, "password", "")
vcode = mtu.getReqVal(request, "vcode", "")
try:
olduser = request.session.get("s_user", default=None)
vcode2 = request.session["s_vcode"]
except:
olduser = []
vcode2 = ""
response_data = {}
try:
#判断是否过期：过期后不显示业务菜单，只显示首页、退出，提醒已经过期。
if not olduser:
if vcode == vcode2:
#查询用户信息
user = BasUser.objects.get(ucode=ucode)
if user:
upwd = user.password
password = mtu.md5(password)
if upwd == password:
request.session["s_user"] = user.toDict()
request.session["s_ucode"] = user.ucode
request.session["s_uname"] = user.nm
request.session["s_utype"] = user.utype
request.session["menu_type"] = user.utype
#根据grpcode查询grpname：
# 如果utype==3，登录用户为报表系统用户
# 如果utype==2，登录用户为供应商则grpname为供应商名称
# 如果utype==1，登录用户为零售商则grpname为零售商名称
if user.utype == "3":
getRbacRole(request, ucode)
response_data[
'homeurl'] = Constants.URL_REPORT_HOME
else:
if user.utype == "2": #供应商
grpcode = findGrpCodeBySuppCode(user.grpcode)
request.session["s_grpcode"] = grpcode
try:
fee = BasFee.objects.get(
suppcode=user.grpcode,
grpcode=grpcode,
ucode=ucode)
request.session["s_fee"] = fee.toDict()
except Exception as e:
print(e)
request.session["s_fee"] = {"status": "N"}
request.session["s_suppcode"] = user.grpcode
supp = findGrpNameByCode(
user.grpcode, user.utype)
request.session["s_suppname"] = supp.chnm
request.session[
"s_contracttype"] = supp.contracttype
request.session["s_paytypeid"] = supp.paytypeid
request.session["s_bank"] = supp.bank
request.session["s_accountno"] = supp.accountno
grp = findGrpNameByCode(grpcode, "1")
request.session["s_grpname"] = grp.grpnm
response_data[
'homeurl'] = Constants.URL_SUPPLIER_HOME
if user.utype == "1": #零售商
request.session["s_grpcode"] = user.grpcode
grp = findGrpNameByCode(
user.grpcode, user.utype)
request.session["s_grpname"] = grp.grpnm
request.session["s_fee"] = {}
response_data[
'homeurl'] = Constants.URL_RETAILER_HOME
request.session["homeurl"] = response_data[
'homeurl']
#查询角色，多个角色用“，”分割
urs = findRoleByUcode(user.ucode)
if urs:
urole = urs[0]
#查询菜单权限
purlist = findPurByRcode(urs[2])
request.session["s_rcodes"] = urs[1]
request.session["isadmin"] = urs[3]
request.session["s_urole"] = urole
request.session["s_umenu"] = getMenu(purlist)
response_data['status'] = "0"
#添加登录日志
if user.utype == "2":
lastlandtime = datetime.date.today(
).strftime("%Y-%m-%d")
slist = BasSuppLand.objects.filter(
suppcode=user.grpcode,
lastlandtime__gte=
"{lastlandtime} 00:00:00".format(
lastlandtime=lastlandtime)).values(
"landcs")
if slist and slist[0]:
sland = slist[0]
landcs = sland["landcs"] + 1
BasSuppLand.objects.filter(
suppcode=user.grpcode,
lastlandtime__gte=
"{lastlandtime} 00:00:00".format(
lastlandtime=lastlandtime
)).update(landcs=landcs,
lastlandtime=datetime.
datetime.today())
else:
fee = request.session.get("s_fee")
if fee:
status = fee["status"]
else:
status = "N"
suppname = request.session.get(
"s_suppname")
lastLand = BasSuppLand.objects.values(
"allcs").latest("allcs")
if lastLand:
allcs = lastLand["allcs"] + 1
else:
allcs = 1
bs = BasSuppLand()
bs.grpcode = "00069"
bs.utype = "2"
bs.suppcode = user.grpcode
bs.landcs = 1
bs.lastlandtime = datetime.date.today()
bs.status = status
bs.supname = suppname
bs.remark = ""
bs.ylzd1 = ""
bs.ylzd2 = ""
bs.allcs = allcs
bs.save()
else:
response_data['status'] = "4"
else:
response_data['status'] = "2"
else:
response_data['status'] = "1"
else:
response_data['status'] = "3"
else:
response_data['status'] = "0"
if olduser["utype"] == "1":
response_data['homeurl'] = Constants.URL_RETAILER_HOME
elif olduser["utype"] == "3":
response_data['homeurl'] = Constants.URL_REPORT_HOME
else:
response_data['homeurl'] = Constants.URL_SUPPLIER_HOME
except Exception as e:
print(e)
return HttpResponse(json.dumps(response_data),
content_type="application/json")
def index(request):
user = request.session.get("s_user", None)
suppcode = request.session.get("s_suppcode")
s_grpcode = request.session.get("s_grpcode")
paytypeid = request.session.get("s_paytypeid")
contracttype = request.session.get("s_contracttype")
if user:
pubList = findPubInfoAllByCon(user)
else:
pubList = []
pageNum = int(request.GET.get("pageNum", 1))
page = Paginator(pubList,
__EACH_PAGE_SHOW_NUMBER,
allow_empty_first_page=True).page(pageNum)
upwd = user["password"]
pwd = mtu.md5(suppcode)
pwdInit = False
if upwd == pwd:
pwdInit = True
#查询对账日期
ritemList = ReconcilItem.objects.filter(pid=paytypeid).values("rid")
rdays = []
tdays = []
rlist = []
if ritemList:
for ritem in ritemList:
rid = ritem["rid"]
reconcil = Reconcil.objects.filter(id=rid, status=1).values(
"rname", "beginday", "endday")
if reconcil:
row = reconcil[0]
rlist.append(dict(row))
rlist = sorted(rlist, key=lambda row: row["beginday"])
rds = ""
tds = ""
if rlist:
for rw in rlist:
begin = rw["beginday"]
end = rw["endday"]
rdays.append("{begin}-{end}".format(begin=begin, end=end))
if "随时" in rw["rname"]:
tdays.append("{begin}-{end}".format(begin=begin, end=end))
else:
if begin <= 15:
tdays.append("1-{begin}".format(begin=begin - 1))
else:
tdays.append("16-{begin}".format(begin=begin - 1))
rds = ",".join(rdays)
tds = ",".join(tdays)
endDate = ""
try:
fee = BasFee.objects.get(suppcode=suppcode,
grpcode=s_grpcode,
ucode=user["ucode"])
if fee:
endDate = fee.enddate
conn = mtu.get_MssqlConn()
#供应商结算方式
pdict = findPayType(2)
if pdict and paytypeid:
payTypeName = pdict[str(int(paytypeid))]
else:
payTypeName = ""
#g-购销 l-联营 d-代销 z-租赁
pstart, pend, cstart, cend = getStartAndEndDate(
contracttype, payTypeName)
#查询单据信息（动态查询）
rdict = findBillItem(conn, suppcode, pstart, pend, cstart, cend, None,
contracttype)
if rdict and rdict["blist"]:
blist = rdict["blist"]
blen = len(blist)
request.session["s_rdict"] = blen
else:
request.session["s_rdict"] = 0
conn.close()
except Exception as e:
print(e)
return render(
request, "index.html", {
"page": page,
"pageNum": pageNum,
"pwdInit": pwdInit,
"rdays": rds,
"tdays": tds,
"endDate": endDate,
"payTypeName": payTypeName
})
def index(request):
grpcode = request.session.get('s_grpcode', '')
utype = request.session.get("s_utype")
page = mtu.getReqVal(request, "page", "1")
action = mtu.getReqVal(request, "action")
nm = mtu.getReqVal(request, "nm")
ucode = mtu.getReqVal(request, "ucode")
pwd = mtu.getReqVal(request, "pwd")
dept = mtu.getReqVal(request, "dept")
status = mtu.getReqVal(request, "status")
remark = mtu.getReqVal(request, "remark")
user = BasUser()
if action != "new":
try:
user = BasUser.objects.get(ucode=ucode)
except:
user = None
if action == "save":
if not user:
user = BasUser()
user.ucode = ucode
user.budate = datetime.date.today()
user.password = mtu.md5(pwd)
user.nm = nm
user.dept = dept
user.utype = utype
user.status = status
user.remark = remark
user.grpcode = grpcode
user.save()
ke = BasKe()
ke.kbcode = user.ucode
ke.kbname = user.nm
ke.save()
elif action == "del":
try:
ke = BasKe.objects.get(kbcode=ucode)
if ke:
ke.delete()
except Exception as e:
print(e)
if user:
user.delete()
user = BasUser()
retUserList = BasUser.objects.values('ucode', 'nm', 'password', 'dept',
'depttype', 'utype', 'status',
'grpcode').filter(grpcode=grpcode)
paginator = Paginator(retUserList, LIMIT)
try:
retUserList = paginator.page(int(page))
except Exception as e:
print(e)
retUserList = []
pageCount = paginator.num_pages
pageList = []
for index in range(1, pageCount + 1):
pageList.append(index)
usertype = (str(utype), Constants.USER_TYPE.get(utype))
rs = {}
rs["page"] = page
rs["usertype"] = usertype
rs["retUserList"] = retUserList
rs["pageList"] = pageList
rs["grpcode"] = grpcode
rs["user"] = user
return render(request, 'admin/sysConf_retail_admin.html', rs)
def index(request):
grpcode = request.session.get('s_grpcode','')
utype = request.session.get("s_utype")
page = mtu.getReqVal(request,"page","1")
action = mtu.getReqVal(request,"action")
nm = mtu.getReqVal(request,"nm")
ucode = mtu.getReqVal(request,"ucode")
pwd = mtu.getReqVal(request,"pwd")
dept = mtu.getReqVal(request,"dept")
status = mtu.getReqVal(request,"status")
remark = mtu.getReqVal(request,"remark")
user = BasUser()
if action!="new":
try:
user = BasUser.objects.get(ucode=ucode)
except:
user = None
if action == "save":
if not user:
user = BasUser()
user.ucode = ucode
user.budate = datetime.date.today()
user.password = mtu.md5(pwd)
user.nm = nm
user.dept = dept
user.utype = utype
user.status = status
user.remark = remark
user.grpcode = grpcode
user.save()
ke = BasKe()
ke.kbcode = user.ucode
ke.kbname = user.nm
ke.save()
elif action == "del":
try:
ke = BasKe.objects.get(kbcode=ucode)
if ke:
ke.delete()
except Exception as e:
print(e)
if user:
user.delete()
user = BasUser()
retUserList = BasUser.objects.values('ucode','nm','password','dept','depttype','utype','status','grpcode').filter(grpcode=grpcode)
paginator = Paginator(retUserList,LIMIT)
try:
retUserList = paginator.page(int(page))
except Exception as e:
print(e)
retUserList = []
pageCount = paginator.num_pages
pageList = []
for index in range(1,pageCount+1):
pageList.append(index)
usertype = (str(utype),Constants.USER_TYPE.get(utype))
rs = {}
rs["page"] = page
rs["usertype"] = usertype
rs["retUserList"] = retUserList
rs["pageList"] = pageList
rs["grpcode"] = grpcode
rs["user"] = user
return render(request,'admin/sysConf_retail_admin.html',rs)
def login(request):
ucode = mtu.getReqVal(request,"ucode","")
password = mtu.getReqVal(request,"password","")
vcode = mtu.getReqVal(request,"vcode","")
try:
olduser = request.session.get("s_user",default=None)
vcode2 = request.session["s_vcode"]
except:
olduser = []
vcode2 = ""
response_data = {}
try:
#判断是否过期：过期后不显示业务菜单，只显示首页、退出，提醒已经过期。
if not olduser:
if vcode==vcode2:
#查询用户信息
user = BasUser.objects.get(ucode=ucode)
if user:
upwd = user.password
password = mtu.md5(password)
if upwd==password:
request.session["s_user"] = user.toDict()
request.session["s_ucode"] = user.ucode
request.session["s_uname"] = user.nm
request.session["s_utype"] = user.utype
request.session["menu_type"] = user.utype
#根据grpcode查询grpname：
# 如果utype==2，登录用户为供应商则grpname为供应商名称
# 如果utype==1，登录用户为零售商则grpname为零售商名称
if user.utype == "2": #供应商
grpcode = findGrpCodeBySuppCode(user.grpcode)
request.session["s_grpcode"] = grpcode
try:
fee = BasFee.objects.get(suppcode=user.grpcode,grpcode=grpcode,ucode=ucode)
request.session["s_fee"] = fee.toDict()
except Exception as e:
print(e)
request.session["s_fee"] = {"status":"N"}
request.session["s_suppcode"] = user.grpcode
supp = findGrpNameByCode(user.grpcode,user.utype)
request.session["s_suppname"] = supp.chnm
request.session["s_contracttype"] = supp.contracttype
request.session["s_paytypeid"] = supp.paytypeid
request.session["s_bank"] = supp.bank
request.session["s_accountno"] = supp.accountno
grp = findGrpNameByCode(grpcode,"1")
request.session["s_grpname"] = grp.grpnm
response_data['homeurl'] = Constants.URL_SUPPLIER_HOME
else: #零售商
request.session["s_grpcode"] = user.grpcode
grp = findGrpNameByCode(user.grpcode,user.utype)
request.session["s_grpname"] = grp.grpnm
request.session["s_fee"] = {}
response_data['homeurl'] = Constants.URL_RETAILER_HOME
request.session["homeurl"] = response_data['homeurl']
#查询角色，多个角色用“，”分割
urs = findRoleByUcode(user.ucode)
if urs:
urole = urs[0]
#查询菜单权限
purlist = findPurByRcode(urs[2])
request.session["s_rcodes"] = urs[1]
request.session["isadmin"] = urs[3]
request.session["s_urole"] = urole
request.session["s_umenu"] = getMenu(purlist)
response_data['status'] = "0"
#添加登录日志
if user.utype=="2":
lastlandtime = datetime.date.today().strftime("%Y-%m-%d")
slist = BasSuppLand.objects.filter(suppcode=user.grpcode,lastlandtime__gte="{lastlandtime} 00:00:00".format(lastlandtime=lastlandtime)).values("landcs")
if slist and slist[0]:
sland = slist[0]
landcs=sland["landcs"]+1
BasSuppLand.objects.filter(suppcode=user.grpcode,lastlandtime__gte="{lastlandtime} 00:00:00".format(lastlandtime=lastlandtime)).update(landcs=landcs,lastlandtime=datetime.datetime.today())
else:
fee = request.session.get("s_fee")
if fee:
status = fee["status"]
else:
status = "N"
suppname = request.session.get("s_suppname")
lastLand = BasSuppLand.objects.values("allcs").latest("allcs")
if lastLand:
allcs = lastLand["allcs"]+1
else:
allcs = 1
bs = BasSuppLand()
bs.grpcode = "00069"
bs.utype = "2"
bs.suppcode = user.grpcode
bs.landcs = 1
bs.lastlandtime = datetime.date.today()
bs.status = status
bs.supname = suppname
bs.remark=""
bs.ylzd1=""
bs.ylzd2=""
bs.allcs= allcs
bs.save()
else:
response_data['status'] = "4"
else:
response_data['status'] = "2"
else:
response_data['status'] = "1"
else:
response_data['status'] = "3"
else:
response_data['status'] = "0"
if olduser["utype"] == "1":
response_data['homeurl'] = Constants.URL_RETAILER_HOME
else:
response_data['homeurl'] = Constants.URL_SUPPLIER_HOME
except Exception as e:
print(e)
return HttpResponse(json.dumps(response_data), content_type="application/json")
