def consulta_depositos(request: HttpRequest) -> HttpResponse:
menu = menu_consultas(request)
data_inicial = request.GET.get("data_inicial", "")
data_final = request.GET.get("data_final", "")
form = FormDataInicialFinal(initial={
"data_inicial": data_inicial,
"data_final": data_final
}, )
query = Q()
if data_inicial:
data_inicial = datetime.strptime(data_inicial, "%Y-%m-%d").date()
query = query & Q(data_referencia__gte=data_inicial)
if data_final:
data_final = datetime.strptime(data_final, "%Y-%m-%d").date()
query = query & Q(data_referencia__lte=data_final)
itens = services.get_uploads(query)
paginator = Paginator(itens, 50)
page_number = request.GET.get("page")
page_obj = paginator.get_page(page_number)
context = {
"page_obj": page_obj,
"form": form,
"form_submit_text": 'Filtrar'
}
context.update(menu)
return render(request, "cartao/consultar_uploads.html", context)
def consultas_ordem_saida(request: HttpRequest) -> HttpResponse:
menu = menu_consultas(request)
data_inicial = request.GET.get('data_inicial', '')
data_final = request.GET.get('data_final', '')
form = FormDataInicialFinal(
initial={
'data_inicial': data_inicial,
'data_final': data_final,
}
)
query = Q(Q(tipo=1) & Q(Q(saida_ordem_ferramenta__id__gte=0) | Q(saida_ordem_patrimonio__id__gte=0)))
if data_inicial != '':
data_inicial = datetime.datetime.strptime(data_inicial, "%Y-%m-%d").date()
query = query & Q(data__gte=data_inicial)
if data_final != '':
data_final = datetime.datetime.strptime(data_final, "%Y-%m-%d").date()
query = query & Q(data__lte=data_final)
itens = Ordem.objects.filter(query).order_by(
'-data'
).annotate(
user_to_first_name1=Min('saida_ordem_ferramenta__user_to__first_name'),
user_to_last_name1=Min('saida_ordem_ferramenta__user_to__last_name'),
user_to_first_name2=Min('saida_ordem_patrimonio__user_to__first_name'),
user_to_last_name2=Min('saida_ordem_patrimonio__user_to__last_name'),
).values(
'id',
'data',
'user__first_name',
'user__last_name',
'user_to_first_name1',
'user_to_last_name1',
'user_to_first_name2',
'user_to_last_name2',
)
paginator = Paginator(itens, 50)
page_number = request.GET.get('page')
page_obj = paginator.get_page(page_number)
context = {
'page_obj': page_obj,
'tipo': 1,
'form': form,
'form_submit_text': 'filtar',
}
context.update(menu)
return render(request, 'patrimonio/v2/consulta_ordem.html', context)
def consulta_material_saida_detalhe(request, codigo):
menu = menu_consultas(request)
data_inicial = request.GET.get('data_inicial', '')
data_final = request.GET.get('data_final', '')
form = FormDataInicialFinal(initial={
'data_inicial': data_inicial,
'data_final': data_final,
})
query = Q(material__codigo=codigo)
if data_inicial != '':
data_inicial = datetime.datetime.strptime(data_inicial,
"%Y-%m-%d").date()
query = query & Q(data__gte=data_inicial)
if data_final != '':
data_final = datetime.datetime.strptime(data_final, "%Y-%m-%d").date()
query = query & Q(data__lte=data_final)
itens = MaterialSaida.objects.filter(query).values(
'user_to__first_name',
'user_to__last_name',
).annotate(
total=Sum(F('quantidade')),
qtde=Count(F('id')),
).order_by('-total', ).exclude(total__lte=0, )
material = Material.objects.get(codigo=codigo)
paginator = Paginator(itens, 50)
page_number = request.GET.get('page')
page_obj = paginator.get_page(page_number)
context = {
'page_obj': page_obj,
'form': form,
'form_submit_text': 'filtrar',
'material_codigo': material.codigo,
'material_material': material.material,
}
context.update(menu)
return render(request,
'almoxarifado/v2/consulta_material_saida_detalhe.html',
context)
def consulta_funcionario_detalhe(request, funcionario):
menu = menu_consultas(request)
data_inicial = request.GET.get('data_inicial', '')
data_final = request.GET.get('data_final', '')
form = FormDataInicialFinal(initial={
'data_inicial': data_inicial,
'data_final': data_final,
})
query = Q(almoxarifado_ordem_saida__user_to__username=funcionario)
if data_inicial != '':
data_inicial = datetime.datetime.strptime(data_inicial,
"%Y-%m-%d").date()
query = query & Q(data__gte=data_inicial)
if data_final != '':
data_final = datetime.datetime.strptime(data_final, "%Y-%m-%d").date()
query = query & Q(data__lte=data_final)
entregas = Ordem.objects.filter(query).order_by('-id')
entregas = entregas.values(
'id',
'data',
'user__first_name',
'user__last_name',
).annotate(
observacao=Min('almoxarifado_ordem_saida__observacao'),
n_materiais=Count('almoxarifado_ordem_saida__id', distinct=True),
)
paginator = Paginator(entregas, 50)
page_number = request.GET.get('page')
page_obj = paginator.get_page(page_number)
context = {
'page_obj': page_obj,
'form': form,
'form_submit_text': 'filtrar',
'funcionario': funcionario,
}
context.update(menu)
return render(request, 'almoxarifado/v2/consulta_funcionario_detalhe.html',
context)
def consulta_ordem_entrada(request):
menu = menu_consultas(request)
data_inicial = request.GET.get('data_inicial', '')
data_final = request.GET.get('data_final', '')
form = FormDataInicialFinal(initial={
'data_inicial': data_inicial,
'data_final': data_final,
})
query = Q(tipo=0)
if data_inicial != '':
data_inicial = datetime.datetime.strptime(data_inicial,
"%Y-%m-%d").date()
query = query & Q(data__gte=data_inicial)
if data_final != '':
data_final = datetime.datetime.strptime(data_final, "%Y-%m-%d").date()
query = query & Q(data__lte=data_final)
itens = Ordem.objects.filter(query).order_by('-data').annotate(
user_to_first_name=Min(
'almoxarifado_ordem_saida__user_to__first_name'),
user_to_last_name=Min('almoxarifado_ordem_saida__user_to__last_name'),
)
itens = itens.values(
'id',
'data',
'user__first_name',
'user__last_name',
'user_to_first_name',
'user_to_last_name',
)
paginator = Paginator(itens, 50)
page_number = request.GET.get('page')
page_obj = paginator.get_page(page_number)
context = {
'page_obj': page_obj,
'tipo': 0,
'form': form,
'form_submit_text': 'filtrar'
}
context.update(menu)
return render(request, 'almoxarifado/v2/consulta_ordem.html', context)
def painel_diario(request: HttpRequest) -> HttpResponse:
menu = menu_principal(request)
data_inicial = request.GET.get("data_inicial", datetime.date.today().isoformat())
data_final = request.GET.get("data_final", datetime.date.today().isoformat())
form = FormDataInicialFinal(initial={
"data_inicial": data_inicial,
"data_final": data_final,
})
context = {
"form": form,
"form_submit_text": "Filtrar"
}
context.update(menu)
return render(request, "gerencia/painel_diario.html", context)