def show(request, page):
if request.user.is_superuser:
guestbooks = Guestbook.objects.filter().order_by('-date','-id')
guestbooks, pageList, paginator, page = djangoPage(guestbooks,page,PAGE_NUM) #调用分页函数
replys = Reply.objects.filter(guestbookname=request.user.username).order_by('-date', '-id')
offset = PAGE_NUM * (page - 1)
return render(request, 'guestbook/showall.html', context=locals())
guestbooks = Guestbook.objects.filter(username=request.user.username).order_by('-date', '-id')
guestbooks, pageList, paginator, page = djangoPage(guestbooks,page,PAGE_NUM) #调用分页函数
replys = Reply.objects.filter(guestbookname=request.user.username).order_by('-date', '-id')
offset = PAGE_NUM * (page - 1)
return render(request, 'guestbook/show.html', context=locals())
def salesreport_makexlsx_page(request, page):
datas, tempFilePath, fileName = get_post_data(request, Salesreport.objects)
datas, pageList, num_pages, page = djangoPage(datas, page, PAGE_NUM) #调用分页函数
ids = [i+PAGE_NUM * (page - 1) for i in range(1,PAGE_NUM+1) ] #序号
if convertxlsx(datas, tempFilePath, ids):
return down_file(tempFilePath, fileName)
return HttpResponseRedirect(r'/web/materialreport/list/%s' % (page))
def copewith_list(request, page):
"""应付账款列表"""
cleanData = request.GET.dict()
model = Copewith.objects
if request.method == 'POST':
page = 1
cleanData = request.POST.dict()
dict.pop(cleanData, 'csrfmiddlewaretoken')
name, name_list, queryString, datas = get_model_data(model, cleanData)
payments = round(sum(datas.filter().values_list('payment', flat=True)),
2) #付款 求和
moneys = round(sum(datas.filter().values_list('money', flat=True)),
2) #金额 求和
money1s = round(sum(datas.filter().values_list('money1', flat=True)),
2) #金额1 求和
owe_tickets = round(
sum(datas.filter().values_list('owe_ticket', flat=True)), 2) #欠票 求和
if get_model_first_id(datas):
balances = datas.get(id=get_model_first_id(datas)).balance # 倒数最后一条记录
data_list, pageList, num_pages, page = djangoPage(datas, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'web/copewith/copewith_list.html', context=locals())
def vipplay(request, page):
if request.method == 'POST':
Browse.objects.filter().update(mobilephone=str(int(Browse.objects.get().mobilephone)+1))
cleanData = request.POST.dict()
url = cleanData.get('url','').strip()
name = cleanData.get('name','').strip()
tvname = cleanData.get('tvname','').strip()
if '央视网' in tvname:
lineroad = video_url_list[4] #线路5
elif '土豆' in tvname or '56我乐' in tvname or 'KU6.com' in tvname\
or '网易视频' in tvname or '新浪视频' in tvname or '6.CN' in tvname\
or '酷狗音乐' in tvname or '爆米花网' in tvname or '凤凰视频' in tvname\
or '看看新闻' in tvname or '时光网' in tvname:
return HttpResponseRedirect(url)
elif '华数TV' in tvname or '1905' in tvname:
lineroad = video_url_list[1] #线路2
elif '音悦Tai' in tvname or '糖豆' in tvname:
lineroad = video_url_list[7] #线路8
else:
lineroad = video_url_list[0] #线路1
line_list = video_url_list
videos = Video.objects.values().order_by('-date', '-id')
cleanData = request.GET.dict()
queryString = '?'+'&'.join(['%s=%s' % (k,v) for k,v in cleanData.items()])
videos, pageList, num_pages, page = djangoPage(videos,page,PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'blog/vipplay.html', context=locals())
def blogpage(request, page):
page = toInt(page)
if request.method == 'POST':
cleanData = request.POST.dict()
author = request.user
id = cleanData.get('id', -1)
subject = cleanData.get('subject', '')
summary = cleanData.get('summary', '')
content = cleanData.get('content', '')
blog = Blogs.objects.filter(id=id)
if blog:
blog.update(author=author,
subject=subject,
summary=summary,
content=content)
else:
blogs = Blogs(author=author,
subject=subject,
summary=summary,
content=content)
blogs.save()
mylist = list(Blogs.objects.values().order_by(
'-id')) #[(page-1)*PAGE_NUM:page*PAGE_NUM]
kvs = [{'author': User}] #外键字典
mylist = list(get_model_values(mylist, kvs))
blogs_list, pageList, paginator, page = djangoPage(mylist, page, PAGE_NUM)
offset = PAGE_NUM * (page - 1)
data = dict(blogs=list(blogs_list),
pageList=pageList,
page=page,
offset=offset)
return JsonResponse(data, safe=True)
def schedule_list(request, page):
operators = _getOperators()
cleanData = request.GET.dict()
queryString = '?' + '&'.join(
['%s=%s' % (k, v) for k, v in cleanData.items()])
datas = Schedule.objects.filter()
data_list, pageList, num_pages, page = djangoPage(datas, page, PAGE_NUM)
offset = PAGE_NUM * (page - 1)
return render(request, 'account/schedule_list.html', context=locals())
def showreply(request, page):
title = request.GET.get('title','')
if title != '':
replys = Reply.objects.filter(title=title)
else:
replys = Reply.objects.filter(username=request.user).order_by('-date', '-id')
replys, pageList, paginator, page = djangoPage(replys,page,PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'guestbook/showreply.html', context=locals())
def customer(request, page):
operators = _getOperators()
if request.user not in operators:
return HttpResponseRedirect('/')
cleanData = request.GET.dict()
companys = SearchNameContact(Company, cleanData.get('name', ''),
cleanData.get('contact', ''))
companys = companys.order_by('-id')
company_list, pageList, num_pages, page = djangoPage(
companys, page, PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'account/customer.html', context=locals())
def classname_list(request, page):
operators = _getOperators()
cleanData = request.GET.dict()
models = Schedule.objects.filter()
if request.method == 'POST':
cleanData = request.POST.dict()
dict.pop(cleanData, 'csrfmiddlewaretoken')
if cleanData.get('kcmc', ''):
models = models.filter(KCMC__icontains=cleanData['kcmc'])
queryString = '?' + '&'.join(
['%s=%s' % (k, v) for k, v in cleanData.items()])
data_list, pageList, num_pages, page = djangoPage(models, page, PAGE_NUM)
offset = PAGE_NUM * (page - 1)
return render(request, 'account/classname_list.html', context=locals())
def billing(request, page):
operators = _getOperators()
cleanData = request.GET.dict()
queryString = '?' + '&'.join(
['%s=%s' % (k, v) for k, v in cleanData.items()])
orders, monthNum = _filterOrder(request, cleanData)
TotalTax = sum(orders.values_list('priceIncludeTax', flat=True))
orders = orders.order_by('-date', '-id')
if request.user in operators: #如果登录用户在Operator组
company_name_list = Company.objects.values_list('name', flat=True)
type_list = [i[0] for i in Order.ORDER_TYPE]
material_name_list = Material.objects.values_list('name', flat=True)
taxPercent_list = [i[0] for i in Order.ORDER_TAX]
order_list, pageList, num_pages, page = djangoPage(orders, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'account/billing.html', context=locals())
def picking_list(request, page):
"""材料报表列表"""
cleanData = request.GET.dict()
model = Picking.objects
if request.method == 'POST':
cleanData = request.POST.dict()
dict.pop(cleanData, 'csrfmiddlewaretoken')
page = int(cleanData.get('page', 1))
name, name_list, queryString, datas = get_model_data(model, cleanData)
moneys = round(sum(datas.filter().values_list('money', flat=True)),
2) #金额 求和
data_list, pageList, num_pages, page = djangoPage(datas, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
name_list = pinyin(list(set(model.values_list('name', flat=True))))
name_list.insert(0, '')
return render(request, 'web/picking/picking_list.html', context=locals())
def delivery_list(request, page):
"""送货列表"""
cleanData = request.GET.dict()
model = Delivery.objects
if request.method == 'POST':
page = 1
cleanData = request.POST.dict()
dict.pop(cleanData, 'csrfmiddlewaretoken')
name, name_list, queryString, datas = get_model_name_customer(
model, cleanData)
customer_list = list(
set(Deliverycustomer.objects.values_list('name', flat=True))) # 客户名称
customer_list = pinyin(customer_list)
customer = get_dict_customer(cleanData)
moneys = round(sum(datas.filter().values_list('money', flat=True)),
2) #金额总和
data_list, pageList, num_pages, page = djangoPage(datas, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'web/delivery/delivery_list.html', context=locals())
def materialreport_list(request, page):
"""材料报表列表"""
cleanData = request.GET.dict()
model = Materialreport.objects
if request.method == 'POST':
page = 1
cleanData = request.POST.dict()
dict.pop(cleanData, 'csrfmiddlewaretoken')
name, name_list, queryString, datas = get_model_data(model, cleanData)
lastmonth_money = round(
sum(datas.filter().values_list('lastmonth_money', flat=True)),
2) #上月结存金额 求和
income_money = round(
sum(datas.filter().values_list('income_money', flat=True)),
2) #收入金额 求和
weighting_money = round(
sum(datas.filter().values_list('weighting_money', flat=True)),
2) #加权金额 求和
production_expenditure_money = round(
sum(datas.filter().values_list('production_expenditure_money',
flat=True)), 2) #生产支出金额 求和
material_expenditure_money = round(
sum(datas.filter().values_list('material_expenditure_money',
flat=True)), 2) #材料支出金额 求和
sale_money = round(sum(datas.filter().values_list('sale_money',
flat=True)), 2) #销售金额 求和
thismonth_money = round(
sum(datas.filter().values_list('thismonth_money', flat=True)),
2) #本月结存金额 求和
data_list, pageList, num_pages, page = djangoPage(datas, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
name_list = pinyin(
list(set(Materialreport.objects.values_list('name', flat=True))))
name_list.insert(0, '')
return render(request,
'web/materialreport/materialreport_list.html',
context=locals())
def customer(request, page):
operators = _getOperators()
if request.user not in operators:
return HttpResponseRedirect('/')
cleanData = request.GET.dict()
queryString = '?' + '&'.join(
['%s=%s' % (k, v) for k, v in cleanData.items()])
companys = SearchNameContact(Company, cleanData.get('name', ''),
cleanData.get('contact', ''))
companys = companys.order_by('-id')
companys = list(companys.values())
company_list, pageList, num_pages, page = djangoPage(
companys, page, PAGE_NUM) #调用分页函数
company_list = list(get_model_values(company_list,
[dict(username=User)])) #获得外键字段值
offset = PAGE_NUM * (page - 1)
operators = [str(o) for o in operators] #数据库记录
mydict = {'company_list':company_list,'pageList':pageList,\
'num_pages': num_pages,'page': page,'offset':offset,\
'operators':operators,'cleanData':cleanData,'queryString':queryString}
return JsonResponse(mydict, safe=False)
def billingFun(request, page):
operators = _getOperators()
cleanData = request.GET.dict()
queryString = '?' + '&'.join(
['%s=%s' % (k, v) for k, v in cleanData.items()])
orders, monthNum = _filterOrder(request, cleanData)
TotalTax = sum(orders.values_list('priceIncludeTax', flat=True))
orders = orders.order_by('-date', '-id')
order_list = list(orders.values())
order_list, pageList, num_pages, page = djangoPage(order_list, page,
PAGE_NUM) #调用分页函数
order_list = list(
get_model_values(order_list, [
dict(author=User),
dict(company=Company),
dict(material=Material)
])) #获得外键字段值
offset = PAGE_NUM * (page - 1)
operators = [str(o) for o in operators] #数据库记录
username = request.user.username
mdict = {}
if username in operators: #如果登录用户在Operator组
company_name_list = Company.objects.values_list('name', flat=True)
company_name_list = list(company_name_list)
type_list = [i[0] for i in Order.ORDER_TYPE]
material_name_list = list(
Material.objects.values_list('name', flat=True))
taxPercent_list = [i[0] for i in Order.ORDER_TAX]
mdict = {'company_name_list':company_name_list,'type_list':type_list,\
'material_name_list':material_name_list,\
'taxPercent_list':taxPercent_list}
mydict = {'order_list':order_list,'pageList':pageList,\
'num_pages': num_pages,'page': page,'offset':offset,\
'operators':operators,'monthNum':monthNum,'cleanData':cleanData,\
'queryString':queryString,'username':username}
mydict.update(mdict)
return mydict
def purchase_list(request, page):
"""采购列表"""
cleanData = request.GET.dict()
model = models.Purchase.objects
if request.method == 'POST':
page = 1
cleanData = request.POST.dict()
dict.pop(cleanData,
'csrfmiddlewaretoken') #删除字典中的键'csrfmiddlewaretoken'和值
name, name_list, queryString, datas = get_model_data(model, cleanData)
moneys = round(sum(datas.filter().values_list('money', flat=True)),
2) #金额总和
payments = round(sum(datas.filter().values_list('payment', flat=True)),
2) #支付款总和
if datas:
balance = datas.filter().get(
id=get_model_first_id(datas)).balance #结余款 最后一条记录(-id第一条记录)
data_list, pageList, num_pages, page = djangoPage(datas, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'web/purchase/purchase_list.html', context=locals())
def upload_pic(request, page):
pic_list = Image.objects.all()
pic_list, pageList, num_pages, page = djangoPage(pic_list, page, PAGE_NUM)
offset = PAGE_NUM * (page - 1)
return render(request, 'account/image.html', context=locals())
def users(request, page):
page = toInt(page)
Users = User.objects.all() #获得数据库记录 形式
users_list, pageList, paginator, page = djangoPage(Users, page, PAGE_NUM)
offset = PAGE_NUM * (page - 1)
return render(request, "blog_vue/user_list.html", context=locals())
def contact_list(request, page):
contacts = Contacts.objects.all()
contacts_list, pageList, num_pages, page = djangoPage(
contacts, page, PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'blog/contact_list.html', context=locals())
def data_show(request, queryString, modes, page, PAGE_NUM):
data_list, pageList, num_pages, page = djangoPage(modes, page,
PAGE_NUM) #调用分页函数
offset = PAGE_NUM * (page - 1)
return render(request, 'account/data_list.html', context=locals())
