Detalle: ffactura.asp

ffactura.asp

Ir a la Página Volver a la Lista

Archivo ASP

ffactura.asp

Página Razor

Facturas/Ffactura.cshtml

Módulo

General

Líneas de Código

137

Características

En Menú:	No
Formularios:	1 formulario(s)
Consultas SQL:	Ninguna
Complejidad:	low
Bases de Datos:	Session DB

Tablas Utilizadas (0)

No se detectaron tablas

Comentarios y Notas (0)

No hay comentarios aún

Enlaces Salientes (6) Páginas a las que esta página enlaza

Archivo ASP	Tipo	Módulo	Estado	Página Razor
`barra.asp`	include	General	Pendiente	-
`empresa.asp`	include	General	Pendiente	-
`ffaclist.asp`	include	General	Pendiente	ffaclist
`general.asp`	include	General	Pendiente	-
`mpro.asp`	include	General	Pendiente	-
`user.asp`	include	General	Pendiente	-

Enlaces Entrantes (0) Páginas que enlazan a esta página

No hay enlaces entrantes

<%  
Option Explicit
%>
<%
Session.LCID = 2058
%> 
<!--#include file="User.asp"-->
<!--#include file="general.asp"-->
<html>
<head>
<title>Grupo MIM</title>
<link href="css/Modulo5.css" rel="stylesheet" />
<link rel=stylesheet href="vista.css">
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function NewWindow(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',resizable'
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
}
//  End -->
</script>	

</head>
<BODY>
<!--#INCLUDE FILE="BARRA.asp"-->

<div class="normalw" style="position:absolute; top:1px">
<center>
<!--#include file="empresa.asp"--><br>
<hr>
</center>
</div>

<div class="normalw" style="position:absolute; top:1px;">
Bienvenido: <%= nombre %>. <br>
Hora Actual: <%= time %>
</div>
<div class="normalw" style="position:absolute; top:34px; left:1">
<!--#include file="mpro.asp"-->
</div>

<div class="normal" style="position:absolute; top:60px; left:10">
<%
dim rs5, sql5
set rs5 = server.CreateObject("ADODB.Recordset")
sql5 = "select * from Ffacm where (usuario  like'" & nombre & "') order by ffacs asc"
rs5.open sql5,cn1,1,2
%>

<%
do while not rs5.EOF
%>
<a href="<%=rs5.fields("Ffacm")%>.asp"><img src="image/<%=rs5.fields("ffacn")%>.gif" border=0 Title="<%=rs5.fields("ffacn")%>"></a>
<%
rs5.MoveNext
loop
%>
<%
Response.Flush   
%>
</div>

<div  align="center" style="position:absolute; top:100px; left:50%; transform: translateX(-50%);">
<br>

<br>
<Center>
	<BR>
		<B>***** BUSQUEDA DE FACTURAS *****</B>
		<BR><BR>
			<Form action="ffactura.asp" method="post" >

			<Table Id="TablaOpc">
				<Tr>	
					<Td>Numero Factura:</Td>
					<Td>Nombre Cliente:</Td>
					<Td>Fecha Inical:</Td>
					<Td>Fecha Final:</Td>
				</Tr>
				<Tr>
					<Td>
					<input tabindex="1" type="text" placeholder="Numero Factura" Title="Número Factura" name="NumFac" Id="TablaOpc" id="NumFac" Size="15" value="<%= NumFac %>">
					</td>
					<Td>
					<input tabindex="2" type="text" placeholder="Nombre Cliente" Title="Nombre Cliente" Id="TablaOpc" name="Nomcli" id="Nomcli" Size="15" value="<%= Nomcli %>">				
					</Td>
					<td><input type=text class=normalb name="FechaInicio"Size="10" Id="TablaOpc" Value="<%= date()-365 %>" size=7 onChange="javascript:this.value=this.value.toUpperCase();"></td>
					<td><input type=text class=normalb name="FechaFinal"Size="10" Id="TablaOpc" Value="<%= date()+1 %>" size=7 onChange="javascript:this.value=this.value.toUpperCase();"></td>
					<Td>
					<button  tabindex="4" type="submit" name="Buscar" id="BuscarCli"/>Buscar</button>
					</td>
				</Tr>
			</table>
			</form>

<br>

<%
Response.Flush   
%>

<%
Dim Numfac
Dim Nomcli
Dim FechaInicio, FechaFinal

Nomcli = Cstr(request("Nomcli"))
Numfac = request("Numfac")
FechaInicio = request("FechaInicio")
FechaFinal = request("FechaFinal")

	If Numfac ="" and Nomcli ="" Then
	
	Else
%>
<!--#include file="FFACList.asp"--><br>
<%
End If
rs5.close
%>
<%
Response.Flush   
%>
</div>
</body>
</html>
<%  
End Sub 
'Add the chosen course to the cart
 Call AddUsuario() 
'Display contents of electronic shopping cart
 Call DisplayUsuario()
%>

using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using MimPortal.Data;
using System.Diagnostics;

namespace MimPortal.Pages.Facturas
{
    public class FfacturaModel : PageModel
    {
        private readonly MimDbContext _context;
        private const int PageSize = 20;

        public FfacturaModel(MimDbContext context)
        {
            _context = context;
        }

        [BindProperty(SupportsGet = true)]
        public string? Search { get; set; }

        [BindProperty(SupportsGet = true)]
        public string? Status { get; set; }

        [BindProperty(SupportsGet = true)]
        public DateTime? FechaDesde { get; set; }

        [BindProperty(SupportsGet = true)]
        public DateTime? FechaHasta { get; set; }

        [BindProperty(SupportsGet = true)]
        public int Page { get; set; } = 1;

        public List<FacturaViewModel> Facturas { get; set; } = new();
        public int TotalCount { get; set; }
        public int TotalPages { get; set; }
        public int CurrentPage => Page;
        public long ElapsedMs { get; set; }

        public async Task<IActionResult> OnGetAsync()
        {
            var sucursal = HttpContext.Session.GetString("Sucursal") ?? "MERIDA";
            var sw = Stopwatch.StartNew();

            // Group by NUMFFACE to avoid duplicates - take the first record for each invoice number
            var query = _context.FFACENC
                .GroupBy(f => f.NUMFFACE)
                .Select(g => g.OrderByDescending(f => f.Id).First())
                .Select(f => new FacturaViewModel
                {
                    Id = f.Id,
                    NUMFFACE = f.NUMFFACE,
                    FECFFACE = f.FECFFACE,
                    CLIFFACE = f.CLIFFACE,
                    ClienteNombre = _context.CLIENTES
                        .Where(c => c.CLACLI == f.CLIFFACE)
                        .Select(c => c.NOMCLI)
                        .FirstOrDefault() ?? f.CLIFFACE,
                    MONFFACE = f.MONFFACE,
                    TCAFFACE = f.TCAFFACE,
                    SUBFFACE = f.SUBFFACE,
                    IVTFFACE = f.IVTFFACE,
                    TOTFFACE = f.TOTFFACE,
                    STAFFACE = f.STAFFACE,
                    TIMBRADA = !string.IsNullOrEmpty(f.UUIDF),
                    USUFFACE = f.USUFFACE,
                    UUID = f.UUIDF
                });

            // Apply filters
            if (!string.IsNullOrEmpty(Search))
            {
                if (int.TryParse(Search, out var numFac))
                {
                    query = query.Where(f => f.NUMFFACE == numFac);
                }
                else
                {
                    query = query.Where(f => f.ClienteNombre != null && f.ClienteNombre.Contains(Search));
                }
            }

            if (!string.IsNullOrEmpty(Status))
            {
                query = query.Where(f => f.STAFFACE == Status);
            }

            if (FechaDesde.HasValue)
            {
                query = query.Where(f => f.FECFFACE >= FechaDesde.Value);
            }

            if (FechaHasta.HasValue)
            {
                query = query.Where(f => f.FECFFACE <= FechaHasta.Value);
            }

            // Order by factura number descending
            query = query.OrderByDescending(f => f.NUMFFACE);

            // Get total count
            TotalCount = await query.CountAsync();
            TotalPages = (int)Math.Ceiling(TotalCount / (double)PageSize);

            // Paginate
            Facturas = await query
                .Skip((Page - 1) * PageSize)
                .Take(PageSize)
                .ToListAsync();

            sw.Stop();
            ElapsedMs = sw.ElapsedMilliseconds;

            // Return partial view for HTMX requests
            if (Request.Headers.ContainsKey("HX-Request"))
            {
                return Partial("_FfacturaCards", this);
            }

            return Page();
        }
    }

    public class FacturaViewModel
    {
        public Guid Id { get; set; }
        public int? NUMFFACE { get; set; }
        public DateTime? FECFFACE { get; set; }
        public string? CLIFFACE { get; set; }
        public string? ClienteNombre { get; set; }
        public int? MONFFACE { get; set; }
        public decimal? TCAFFACE { get; set; }
        public decimal? SUBFFACE { get; set; }
        public decimal? IVTFFACE { get; set; }
        public decimal? TOTFFACE { get; set; }
        public string? STAFFACE { get; set; }
        public bool? TIMBRADA { get; set; }
        public string? USUFFACE { get; set; }
        public string? UUID { get; set; }
    }
}

@page
@model MimPortal.Pages.Facturas.FfacturaModel
@{
    ViewData["Title"] = "Facturas";
}

<form id="antiforgery-form" method="post">
    @Html.AntiForgeryToken()
</form>

<div id="page-content">
    <div class="container-fluid">
        <div class="d-flex justify-content-between align-items-center mb-4">
            <div>
                <h1 class="h3 mb-0"><i class="bi bi-receipt"></i> Facturas</h1>
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb mb-0">
                        <li class="breadcrumb-item"><a href="/">Inicio</a></li>
                        <li class="breadcrumb-item"><a href="/Facturas">Facturas</a></li>
                        <li class="breadcrumb-item active">Listado</li>
                    </ol>
                </nav>
            </div>
            <a href="/Facturas/Ffacadd" class="btn btn-success">
                <i class="bi bi-plus-circle"></i> Nueva Factura
            </a>
        </div>

        <!-- Search and Filters -->
        <div class="card mb-4 border-0 shadow-sm">
            <div class="card-body bg-gradient" style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);">
                <div class="row g-3 align-items-end">
                    <div class="col-md-4">
                        <div class="input-group input-group-lg">
                            <span class="input-group-text bg-white border-0"><i class="bi bi-search text-muted"></i></span>
                            <input type="text" 
                                   id="searchInput"
                                   class="form-control border-0" 
                                   placeholder="Buscar por número o cliente..."
                                   value="@Model.Search"
                                   hx-get="/Facturas/Ffactura"
                                   hx-trigger="keyup changed delay:300ms"
                                   hx-target="#facturas-container"
                                   hx-include="#statusFilter, #fechaDesde, #fechaHasta"
                                   name="Search" />
                            <button class="btn btn-light border-0" type="button" onclick="document.getElementById('searchInput').value=''; htmx.trigger('#searchInput', 'keyup');">
                                <i class="bi bi-x-lg"></i>
                            </button>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <select id="statusFilter" 
                                name="Status" 
                                class="form-select"
                                hx-get="/Facturas/Ffactura"
                                hx-trigger="change"
                                hx-target="#facturas-container"
                                hx-include="#searchInput, #fechaDesde, #fechaHasta">
                            <option value="">Todos los Status</option>
                            @if (Model.Status == "A") { <option value="A" selected>Activa</option> } else { <option value="A">Activa</option> }
                            @if (Model.Status == "P") { <option value="P" selected>Pagada</option> } else { <option value="P">Pagada</option> }
                            @if (Model.Status == "C") { <option value="C" selected>Cancelada</option> } else { <option value="C">Cancelada</option> }
                            @if (Model.Status == "T") { <option value="T" selected>Timbrada</option> } else { <option value="T">Timbrada</option> }
                        </select>
                    </div>
                    <div class="col-md-2">
                        <input type="date" 
                               id="fechaDesde"
                               name="FechaDesde"
                               class="form-control"
                               value="@Model.FechaDesde?.ToString("yyyy-MM-dd")"
                               placeholder="Desde"
                               hx-get="/Facturas/Ffactura"
                               hx-trigger="change"
                               hx-target="#facturas-container"
                               hx-include="#searchInput, #statusFilter, #fechaHasta" />
                    </div>
                    <div class="col-md-2">
                        <input type="date" 
                               id="fechaHasta"
                               name="FechaHasta"
                               class="form-control"
                               value="@Model.FechaHasta?.ToString("yyyy-MM-dd")"
                               placeholder="Hasta"
                               hx-get="/Facturas/Ffactura"
                               hx-trigger="change"
                               hx-target="#facturas-container"
                               hx-include="#searchInput, #statusFilter, #fechaDesde" />
                    </div>
                    <div class="col-md-2 text-end">
                        <span class="badge bg-white text-dark fs-6">
                            <i class="bi bi-database"></i> @Model.TotalCount.ToString("N0") registros
                        </span>
                        <span class="badge bg-white text-success fs-6 ms-1">
                            <i class="bi bi-lightning"></i> @Model.ElapsedMs ms
                        </span>
                    </div>
                </div>
            </div>
        </div>

        <!-- Facturas Cards Container -->
        <div id="facturas-container">
            <partial name="_FfacturaCards" model="Model" />
        </div>
    </div>
</div>
<!-- Migrado desde: ffactura.asp -->

MATERIALES INDUSTRIALES DE MEXICO

ffactura.asp

Archivo ASP

Página Razor

Módulo

Líneas de Código