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")