control_oplog.py 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. # -*-coding:utf-8-*-
  2. import datetime
  3. import common.error_info as ce
  4. import common.models as cm
  5. import common.common_functions as ccf
  6. import common.common_control as ccc
  7. def get_oplog_list(request):
  8. filter_info = request.json
  9. qset = cm.OperationLog.objects.all()
  10. if filter_info.get("op_user_name"):
  11. qset = qset.filter(op_user_name__icontains=filter_info.get("op_user_name"))
  12. if filter_info.get("op_user_ip"):
  13. qset = qset.filter(op_user_ip=filter_info.get("op_user_ip"))
  14. if filter_info.get("op_content"):
  15. qset = qset.filter(op_content=filter_info.get("op_content"))
  16. # if filter_info.get("stime"):
  17. # qset = qset.filter(ctime__gte=filter_info.get("stime"))
  18. # if filter_info.get("etime"):
  19. # qset = qset.filter(ctime__lte=filter_info.get("etime"))
  20. if filter_info.get("ctime", ""):
  21. import web_site.tools as wst
  22. query = wst.datetime_filter("ctime", {}, filter_info["ctime"])
  23. qset = qset.filter(**query)
  24. count = qset.count()
  25. page = filter_info.get("page")
  26. page_size = filter_info.get("page_size")
  27. if page and page_size:
  28. count,qset = ccc.get_page_qset(qset,page,page_size)
  29. qdata = list(qset.values("op_user_name","op_user_realname","op_user_ip","ctime","is_suc"))
  30. for qd in qdata:
  31. qd["op_module"] = "系统管理"
  32. qd["op_content"] = "删除root用户成功"
  33. return count,qdata
  34. def get_warning_notice(*ids):
  35. """
  36. """
  37. qset = cm.WarningNotice.objects.filter(id__in=ids)
  38. qdata = qset.values()
  39. return qdata