def ls_log(request): sys_id = request.GET.get('sys_id','') mod_id = request.GET.get('mod_id','') func_id = request.GET.get('func_id','') start = request.GET.get('start','') if start != '': start = datetime.strptime(start+':00','%Y-%m-%d %X') end = request.GET.get('end','') if end != '': end = datetime.strptime(end+':00','%Y-%m-%d %X') if sys_id !='' and mod_id == '': mods = ModuleModel.objects(sys_id = sys_id) if start == '' and end == '': log = LogModel.objects(mod_id__in = [mod.id for mod in mods]).order_by('-time') if start != '' and end == '': log = LogModel.objects(mod_id__in = [mod.id for mod in mods],time__gte=start).order_by('-time') if start == '' and end != '': log = LogModel.objects(mod_id__in = [mod.id for mod in mods],time__lte=end).order_by('-time') if start != '' and end != '': log = LogModel.objects(mod_id__in = [mod.id for mod in mods],time__gte=start,time__lte=end).order_by('-time') if mod_id != '' and func_id == '': if start == '' and end == '': log = LogModel.objects(mod_id = mod_id).order_by('-time') if start != '' and end == '': log = LogModel.objects(mod_id = mod_id,time__gte=start).order_by('-time') if start == '' and end != '': log = LogModel.objects(mod_id = mod_id,time__lte=end).order_by('-time') if start != '' and end != '': log = LogModel.objects(mod_id = mod_id,time__gte=start,time__lte=end).order_by('-time') #log = LogModel.objects(__raw__={'mod_id':mod_id}) if func_id != '': #log = LogModel.objects(mod_id = mod_id,time__gte=start+':00',time__lte=end+':00') if start == '' and end == '': log = LogModel.objects(func_id = func_id).order_by('-time') if start != '' and end == '': log = LogModel.objects(func_id = func_id ,time__gte=start).order_by('-time') if start == '' and end != '': log = LogModel.objects(func_id = func_id ,time__lte=end).order_by('-time') if start != '' and end != '': log = LogModel.objects(func_id = func_id ,time__gte=start,time__lte=end).order_by('-time') if log: mod = ModuleModel.objects(id = log[0].mod_id) sys_id = mod[0].sys_id kn = KeynameModel.objects(sys_id = sys_id) keyname = {} for k in kn: keyname[k.key] = k.name t = get_template('log/index.html') html = t.render(Context({'logs':log,'detail':'detail','sys_id':sys_id,'mod_id':mod_id,'start':start,'end':end,'keyname':keyname})) return HttpResponse(html)