Detalle: fremision.asp

fremision.asp

Ir a la Página Volver a la Lista

Archivo ASP

fremision.asp

Página Razor

Facturas/Fremision.cshtml

Módulo

General

Líneas de Código

141

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	-
`fremlist.asp`	include	General	Pendiente	-
`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>
<center>
<!--#INCLUDE FILE="BARRA.asp"-->
<!--#include file="empresa.asp"--><br>
<br>
<div class="normalw" style="position:absolute; top:1px">
<center>

<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:40px; left:1">
<!--#include file="mpro.asp"-->
<br><br>
</div>
<br>
<div class="normal" style="position:absolute; top:60px; left:10">
<%
dim rs5, sql5
set rs5 = server.CreateObject("ADODB.Recordset")
sql5 = "select * from Fremm where (usuario  like'" & nombre & "') ORDER BY NREMM ASC"
rs5.open sql5,cn1,1,2
%>

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

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


<Center>
	<BR>
		<B>***** BUSQUEDA DE REMISIONES *****</B>
		<BR><BR>
			<Form action="fremision.asp" method="post" >

			<Table Id="TablaOpc">
				<Tr>	
					<Td>Numero Remision:</Td>
					<Td>Nombre Cliente:</Td>
					<Td>Fecha Inical:</Td>
					<Td>Fecha Final:</Td>
				</Tr>
				<Tr>
					<Td>
					<input tabindex="1" type="text" placeholder="Numero Remision" Title="Número Remision" name="Numrem" Id="TablaOpc" id="Numrem" Size="15" value="<%= Numrem %>">
					</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 Numrem
Dim Nomcli
Dim FechaInicio, FechaFinal

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

If Numrem = "" and Nomcli = "" Then

Else

%>

<!--#include file="FremList.asp"--><br>

<%
Rs5.close
End If
%>
</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 FremisionModel : PageModel
    {
        private readonly MimDbContext _context;
        private const int PageSize = 20;

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

        [BindProperty(SupportsGet = true)]
        public string? Buscar { 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 CurrentPage { get; set; } = 1;

        public List<RemisionViewModel> Remisiones { get; set; } = new();
        public int TotalRecords { get; set; }
        public int TotalPages { get; set; }
        public long ElapsedMs { get; set; }

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

            var query = from r in _context.FREMENC
                        where r.Sucursal == sucursal
                        join c in _context.CLIENTES on r.CLIFREME equals c.CLACLI into cliJoin
                        from cli in cliJoin.DefaultIfEmpty()
                        select new RemisionViewModel
                        {
                            Id = r.Id,
                            NUMFREME = r.NUMFREME,
                            FECFREME = r.FECFREME,
                            CLIFREME = r.CLIFREME,
                            ClienteNombre = cli.NOMCLI ?? r.CLIFREME,
                            MONFREME = r.MONFREME,
                            TCAFREME = r.TCAFREME,
                            SUBFREME = r.SUBFREME,
                            IVTFREME = r.IVTFREME,
                            TOTFREME = r.TOTFREME,
                            STAFREME = r.STAFREME,
                            USUFREME = r.USUFREME
                        };

            // Unified search by number or client name
            if (!string.IsNullOrEmpty(Buscar))
            {
                if (int.TryParse(Buscar, out int numRem))
                {
                    query = query.Where(r => r.NUMFREME == numRem);
                }
                else
                {
                    query = query.Where(r => r.ClienteNombre != null && r.ClienteNombre.Contains(Buscar));
                }
            }

            if (!string.IsNullOrEmpty(Status))
            {
                query = query.Where(r => r.STAFREME == Status);
            }

            if (FechaDesde.HasValue)
            {
                query = query.Where(r => r.FECFREME >= FechaDesde.Value);
            }

            if (FechaHasta.HasValue)
            {
                query = query.Where(r => r.FECFREME <= FechaHasta.Value);
            }

            query = query.OrderByDescending(r => r.NUMFREME);

            TotalRecords = await query.CountAsync();
            TotalPages = (int)Math.Ceiling(TotalRecords / (double)PageSize);

            Remisiones = await query
                .Skip((CurrentPage - 1) * PageSize)
                .Take(PageSize)
                .ToListAsync();

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

            ViewData["HX-Target"] = Request.Headers["HX-Target"].ToString();
            
            return Page();
        }

        public async Task<IActionResult> OnGetSuggestionsAsync(string? Buscar)
        {
            var sucursal = HttpContext.Session.GetString("Sucursal") ?? "MERIDA";
            if (string.IsNullOrEmpty(Buscar) || Buscar.Length < 2)
            {
                return Content("");
            }

            var query = from r in _context.FREMENC
                        where r.Sucursal == sucursal
                        join c in _context.CLIENTES on r.CLIFREME equals c.CLACLI into cliJoin
                        from cli in cliJoin.DefaultIfEmpty()
                        select new { r.NUMFREME, r.FECFREME, r.CLIFREME, ClienteNombre = cli.NOMCLI ?? r.CLIFREME, r.TOTFREME, r.STAFREME };

            if (int.TryParse(Buscar, out int numRem))
            {
                query = query.Where(r => r.NUMFREME == numRem);
            }
            else
            {
                query = query.Where(r => r.ClienteNombre != null && r.ClienteNombre.Contains(Buscar));
            }

            var suggestions = await query
                .OrderByDescending(r => r.NUMFREME)
                .Take(8)
                .ToListAsync();

            if (!suggestions.Any())
            {
                return Content("<div class='dropdown-item text-muted'><i class='bi bi-info-circle me-2'></i>No se encontraron resultados</div>");
            }

            var html = string.Join("", suggestions.Select(s => $@"
                <a href='/Facturas/Fremdet/{s.NUMFREME}' class='dropdown-item suggestion-item'>
                    <div class='d-flex justify-content-between align-items-center'>
                        <div>
                            <span class='badge bg-dark me-2'>#{s.NUMFREME}</span>
                            <strong>{s.ClienteNombre}</strong>
                        </div>
                        <span class='badge {(s.STAFREME == "P" ? "bg-warning" : s.STAFREME == "F" ? "bg-success" : "bg-secondary")}'>{(s.STAFREME == "P" ? "Pendiente" : s.STAFREME == "F" ? "Facturada" : s.STAFREME)}</span>
                    </div>
                    <small class='text-muted'><i class='bi bi-calendar me-1'></i>{s.FECFREME?.ToString("dd/MM/yyyy")} - <i class='bi bi-currency-dollar me-1'></i>{s.TOTFREME?.ToString("N2")}</small>
                </a>
            "));

            return Content(html, "text/html");
        }
    }

    public class RemisionViewModel
    {
        public Guid Id { get; set; }
        public int NUMFREME { get; set; }
        public DateTime? FECFREME { get; set; }
        public string? CLIFREME { get; set; }
        public string? ClienteNombre { get; set; }
        public int? MONFREME { get; set; }
        public decimal? TCAFREME { get; set; }
        public decimal? SUBFREME { get; set; }
        public decimal? IVTFREME { get; set; }
        public decimal? TOTFREME { get; set; }
        public string? STAFREME { get; set; }
        public string? USUFREME { get; set; }
    }
}

@page
@model MimPortal.Pages.Facturas.FremisionModel
@{
    ViewData["Title"] = "Remisiones";
    var hxTarget = ViewData["HX-Target"]?.ToString() ?? "";
    var isSearchRequest = hxTarget == "results-container";
}

@if (isSearchRequest)
{
    <partial name="_RemisionesCards" model="Model" />
}
else
{
    <style>
        .remision-card {
            transition: transform 0.2s ease, box-shadow 0.2s ease;
            border: 1px solid #dee2e6;
        }
        .remision-card:hover {
            transform: translateY(-4px);
            box-shadow: 0 8px 25px rgba(0,0,0,0.15);
            border-color: #0d6efd;
        }
        .search-container {
            position: relative;
        }
        .search-container .form-control {
            padding-left: 2.5rem;
            font-size: 1.1rem;
            height: 50px;
            border-radius: 25px;
        }
        .search-container .search-icon {
            position: absolute;
            left: 1rem;
            top: 50%;
            transform: translateY(-50%);
            color: #6c757d;
            font-size: 1.2rem;
            z-index: 10;
        }
        .autocomplete-dropdown {
            position: absolute;
            top: 100%;
            left: 0;
            right: 0;
            background: white;
            border: 1px solid #dee2e6;
            border-top: none;
            border-radius: 0 0 15px 15px;
            box-shadow: 0 8px 25px rgba(0,0,0,0.15);
            z-index: 1000;
            max-height: 400px;
            overflow-y: auto;
            display: none;
        }
        .autocomplete-dropdown .dropdown-item {
            padding: 12px 20px;
            border-bottom: 1px solid #f0f0f0;
            text-decoration: none;
            color: inherit;
            display: block;
        }
        .autocomplete-dropdown .dropdown-item:hover {
            background-color: #e7f1ff;
        }
        .suggestion-item small {
            display: block;
            margin-top: 4px;
        }
    </style>

    <div id="page-content">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h5 class="mb-0"><i class="bi bi-file-earmark-arrow-up"></i> Remisiones</h5>
                <a href="/Facturas/Fremadd" class="btn btn-success btn-sm">
                    <i class="bi bi-plus-circle"></i> Nueva Remisión
                </a>
            </div>
            <div class="card-body">
                <!-- Search wrapper -->
                <div class="search-container mb-3">
                    <i class="bi bi-search search-icon"></i>
                    <input type="text" 
                           id="search-input"
                           class="form-control" 
                           name="Buscar" 
                           value="@Model.Buscar" 
                           placeholder="Buscar por número de remisión o cliente..."
                           hx-get="/Facturas/Fremision"
                           hx-trigger="keyup changed delay:300ms, search"
                           hx-target="#results-container"
                           hx-swap="innerHTML"
                           hx-include="[name='Status'],[name='FechaDesde'],[name='FechaHasta']"
                           autocomplete="off" />
                    <div id="suggestions-dropdown" class="autocomplete-dropdown"></div>
                </div>
                
                <!-- Filters -->
                <div class="row g-2 mb-4">
                    <div class="col-auto">
                        <select class="form-select form-select-sm" name="Status"
                                hx-get="/Facturas/Fremision"
                                hx-trigger="change"
                                hx-target="#results-container"
                                hx-include="[name='Buscar'],[name='FechaDesde'],[name='FechaHasta']">
                            <option value="">Todos los Status</option>
                            <option value="P" selected="@(Model.Status == "P")">Pendiente</option>
                            <option value="F" selected="@(Model.Status == "F")">Facturada</option>
                            <option value="C" selected="@(Model.Status == "C")">Cancelada</option>
                        </select>
                    </div>
                    <div class="col-auto">
                        <div class="input-group input-group-sm">
                            <span class="input-group-text"><i class="bi bi-calendar"></i>Desde</span>
                            <input type="date" class="form-control" name="FechaDesde" 
                                   value="@Model.FechaDesde?.ToString("yyyy-MM-dd")"
                                   hx-get="/Facturas/Fremision"
                                   hx-trigger="change"
                                   hx-target="#results-container"
                                   hx-include="[name='Buscar'],[name='Status'],[name='FechaHasta']" />
                        </div>
                    </div>
                    <div class="col-auto">
                        <div class="input-group input-group-sm">
                            <span class="input-group-text"><i class="bi bi-calendar"></i>Hasta</span>
                            <input type="date" class="form-control" name="FechaHasta" 
                                   value="@Model.FechaHasta?.ToString("yyyy-MM-dd")"
                                   hx-get="/Facturas/Fremision"
                                   hx-trigger="change"
                                   hx-target="#results-container"
                                   hx-include="[name='Buscar'],[name='Status'],[name='FechaDesde']" />
                        </div>
                    </div>
                </div>

                <!-- Results container -->
                <div id="results-container">
                    <partial name="_RemisionesCards" model="Model" />
                </div>
            </div>
        </div>
        
        <script>
            (function() {
                if (typeof MimAutocomplete !== 'undefined') {
                    MimAutocomplete.init({
                        inputId: 'search-input',
                        dropdownId: 'suggestions-dropdown',
                        suggestionsUrl: '/Facturas/Fremision?handler=Suggestions',
                        paramName: 'Buscar',
                        minChars: 2,
                        debounceMs: 150
                    });
                }
                if (typeof htmx !== 'undefined') {
                    htmx.process(document.getElementById('page-content'));
                }
            })();
        </script>
    </div>
}

MATERIALES INDUSTRIALES DE MEXICO

fremision.asp

Archivo ASP

Página Razor

Módulo

Líneas de Código