def order_list(request,page):
if request.method == "GET":
if request.user.is_superuser:
orderList = Order_System.objects.all().order_by("-id")[0:1000]
else:
orderList = Order_System.objects.filter(Q(order_user=request.user.id) | Q(order_executor=request.user.id)).order_by("-id")[0:1000]
for ds in orderList:
try:
if ds.order_executor == request.user.id:ds.perm = 1
ds.order_user = User.objects.get(id=ds.order_user).username
ds.order_executor = User.objects.get(id=ds.order_executor).username
if ds.order_type == 1:
ds.order_url = '/deploy_order/status/{id}/'.format(id=ds.id)
ds.order_content = ds.project_order.order_content
elif ds.order_type == 0:
ds.order_url = '/db/sql/order/run/{id}/'.format(id=ds.id)
if ds.sql_audit_order.order_type == 'file' and ds.sql_audit_order.order_file:
filePath = os.getcwd() + '/upload/' + str(ds.sql_audit_order.order_file)
with open(filePath, 'r') as f:
ds.order_content = f.read(1000)
else:ds.order_content = ds.sql_audit_order.order_sql
elif ds.order_type == 2:
ds.order_url = '/file/upload/run/{id}/'.format(id=ds.id)
ds.order_content = ds.fileupload_audit_order.order_content
elif ds.order_type == 3:
ds.order_url = '/file/download/run/{id}/'.format(id=ds.id)
ds.order_content = ds.filedownload_audit_order.order_content
else:ds.order_content = '未知'
except Exception, ex:
logger.warn(msg="获取审核SQL[{id}]错误: {ex}".format(id=ds.id,ex=str(ex)))
orderRbt = Order()
#工单类型总计
orderType = orderRbt.countOrderType()
#用户列表
usernameList = orderRbt.getUserNameList()
#分页信息
paginator = Paginator(orderList, 25)
try:
orderList = paginator.page(page)
except PageNotAnInteger:
orderList = paginator.page(1)
except EmptyPage:
orderList = paginator.page(paginator.num_pages)
return render(request,'orders/order_list.html',{"user":request.user,"orderList":orderList,
"orderType":orderType,"monthDataList":orderRbt.getMonthOrderCount(),
"codeDataList":orderRbt.getOrderCount(type=1, day=7),"usernameList":usernameList,
"sqlDataList":orderRbt.getOrderCount(type=0, day=7),
"statusList":Order().getOrderStatusCount()},
)
def get(self):
username = self.get_secure_cookie("user")
if username:
books = Order.get(username)
self.render("order.html", books=books, page_title="My Order")
else:
self.redirect("/login")
def order_list(request, page):
if request.method == "GET":
if request.user.is_superuser:
orderList = Order_System.objects.all().order_by("-id")[0:1000]
else:
orderList = Order_System.objects.filter(
Q(order_user=request.user.id)
| Q(order_executor=request.user.id)).order_by("-id")[0:1000]
for ds in orderList:
try:
if ds.order_executor == request.user.id: ds.perm = 1
ds.order_user = User.objects.get(id=ds.order_user).username
ds.order_executor = User.objects.get(
id=ds.order_executor).username
if ds.order_type == 1:
ds.order_url = '/deploy_order/status/{id}/'.format(
id=ds.id)
ds.order_content = ds.project_order.order_content
else:
ds.order_url = '/db/sql/order/run/{id}/'.format(id=ds.id)
if ds.sql_audit_order.order_type == 'file' and ds.sql_audit_order.order_file:
filePath = os.getcwd() + '/upload/' + str(
ds.sql_audit_order.order_file)
with open(filePath, 'r') as f:
ds.order_content = f.read(1000)
else:
ds.order_content = ds.sql_audit_order.order_sql
except Exception, ex:
logger.warn(
msg="获取审核SQL[{id}]错误: {ex}".format(id=ds.id, ex=str(ex)))
orderRbt = Order()
#工单类型总计
orderType = orderRbt.countOrderType()
#用户列表
usernameList = orderRbt.getUserNameList()
#分页信息
paginator = Paginator(orderList, 25)
try:
orderList = paginator.page(page)
except PageNotAnInteger:
orderList = paginator.page(1)
except EmptyPage:
orderList = paginator.page(paginator.num_pages)
return render(
request,
'orders/order_list.html',
{
"user": request.user,
"orderList": orderList,
"orderType": orderType,
"monthDataList": orderRbt.getMonthOrderCount(),
"codeDataList": orderRbt.getOrderCount(type=1, day=7),
"usernameList": usernameList,
"sqlDataList": orderRbt.getOrderCount(type=0, day=7),
"statusList": Order().getOrderStatusCount()
},
)
def post(self):
username = self.get_secure_cookie("user")
if username:
res = Order.create(username)
if res:
self.redirect("/order")
else:
self.render("error.html", message="Some books are out of stock!")
else:
self.redirect("/login")
