Detalle: compras.asp

compras.asp

Ir a la Página Volver a la Lista

Archivo ASP

compras.asp

Página Razor

Compras/Compras.cshtml

Módulo

Compras

Líneas de Código

105

Características

En Menú:	Sí
Formularios:	Ninguno
Consultas SQL:	1 consulta(s)
Complejidad:	low
Bases de Datos:	Session DB

Tablas Utilizadas (1)

Empresa

Consultas SQL (1)

SQL Original (ASP)

Select * from Empresa;

Tablas: Empresa

Comentarios y Notas (0)

No hay comentarios aún

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

Archivo ASP	Tipo	Módulo	Estado	Página Razor
`menucat.asp`	include	General	Pendiente	-
`menuh.asp`	include	General	Pendiente	-
`default.asp`	redirect	General	Pendiente	-

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

No hay enlaces entrantes

<%  
	Option Explicit
	Session.LCID = 2058
'*****  SI NO HA INICIADO SESION ***
If 	Session("Mybussiness") = "" then
	Response.redirect("default.asp")
Else

Session.Timeout = 1200

'******* EN CASO DE ERROR ****
		Err.Clear
		On Error Resume Next	
'*** REMPLAZA
Function Sanea(Texto)
Sanea = Replace(Texto, "'", "''")
End Function
		
%> 
<!DOCTYPE html>
<HTML>
<HEAD>
    <meta charset="ISO-8859-1" />
	<TITLE>SISTEMA MIM <%= Session("Mybussiness")  %> USUARIO: <%= Session("MyName")  %></TITLE>
		<link href="css/Modulo5.css" rel="stylesheet" />
		<link href="css/Buscador.css" rel="stylesheet" />
		
		<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>
<%
'***** Variables a la base de datos ****
Dim Cn1
Dim Rs11, Rs12, Rs13, Rs14
Dim Sql11, Sql12, Sql13, Sql14

'***** Conexion a la Base de Datos
Set Cn1 = Server.CreateObject( "ADODB.Connection" )
Cn1.Open "DRIVER={SQL Server};SERVER=172.17.0.5;UID="& Session("MyName") &";PWD="& Session("MyPass") &";Database="& Session("Mybussiness") &""

'***** Conexion A la Tabla Empresa ****
Set Rs11 = Server.CreateObject("ADODB.Recordset")
Sql11="Select * from Empresa;"
Rs11.Open Sql11,Cn1,1,2

%>

	<Header>

			<%= Rs11("Nombre") %><br>
			<%= Rs11("Direccion") %>, <%= Rs11("colonia") %><br>
			<%= Rs11("Poblacion") %>

	</header>

	<nav>
		<!--#INCLUDE FILE="menuh.asp"-->
		<br>
		<!--#INCLUDE FILE="MenuCat.asp"-->

	</nav>
	<SECTION>
	<CENTER>
	<b>*** MODULO DE COMPRAS ***</B>
	<br>
	<br>
	
	</SECTION>
	
<%
		If Err.Number <> 0 Then
%>


<br><br>
NÃºmero de Error: <%= Err.Number %><BR>
DescripciÃ³n:  <%= Err.Description %><BR>		
Origen: <%= Err.Source %><BR>
Linea: <%= Err.Line %><BR>
<br>

<%
		Else
'****** FIN DE LOS ERRORES ***
	End If
%>			
</BODY>
</HTML>
<%
'FIN DE SESION
End If
%>

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

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

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

        [BindProperty(SupportsGet = true)] public string? Buscar { 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<OrdenListViewModel> Ordenes { 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 o in _context.CORDENC
                        where o.Sucursal == sucursal
                        join p in _context.PROVEEDORES on o.PROORE equals p.CVEPRV into provJoin
                        from p in provJoin.DefaultIfEmpty()
                        select new OrdenListViewModel
                        {
                            Id = o.Id,
                            NUMORE = o.NUMORE,
                            FECORE = o.FECORE,
                            PROORE = o.PROORE,
                            NombreProveedor = p != null ? p.NOMPRV : o.PROORE,
                            TOTORE = o.TOTORE,
                            IVAORE = o.IVAORE,
                            MONORE = o.MONORE,
                            STAORE = o.STAORE
                        };

            // Unified search by order number or supplier name
            if (!string.IsNullOrEmpty(Buscar))
            {
                var buscarUpper = Buscar.ToUpper();
                query = query.Where(o => 
                    (o.NUMORE.HasValue && o.NUMORE.ToString()!.Contains(Buscar)) ||
                    (o.PROORE != null && o.PROORE.Contains(buscarUpper)) ||
                    (o.NombreProveedor != null && o.NombreProveedor.Contains(buscarUpper)));
            }

            if (FechaDesde.HasValue)
            {
                query = query.Where(o => o.FECORE >= FechaDesde);
            }

            if (FechaHasta.HasValue)
            {
                query = query.Where(o => o.FECORE <= FechaHasta);
            }

            TotalRecords = await query.CountAsync();
            TotalPages = (int)Math.Ceiling(TotalRecords / (double)PageSize);
            Ordenes = await query.OrderByDescending(o => o.FECORE).Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToListAsync();

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

            // Store HX-Target in ViewData so the view can decide what to render
            ViewData["HX-Target"] = Request.Headers["HX-Target"].ToString();
            
            return Page();
        }

        // Handler for autocomplete suggestions dropdown
        public async Task<IActionResult> OnGetSuggestionsAsync(string? Buscar)
        {
            var sucursal = HttpContext.Session.GetString("Sucursal") ?? "MERIDA";
            if (string.IsNullOrEmpty(Buscar) || Buscar.Length < 2)
            {
                return Content(""); // Return empty if query too short
            }

            var buscarUpper = Buscar.ToUpper();
            
            var suggestions = await (from o in _context.CORDENC
                        where o.Sucursal == sucursal
                        join p in _context.PROVEEDORES on o.PROORE equals p.CVEPRV into provJoin
                        from p in provJoin.DefaultIfEmpty()
                        where (o.NUMORE != null && o.NUMORE.ToString()!.Contains(Buscar)) ||
                              (o.PROORE != null && o.PROORE.Contains(buscarUpper)) ||
                              (p != null && p.NOMPRV != null && p.NOMPRV.Contains(buscarUpper))
                        orderby o.FECORE descending
                        select new { o.Id, o.NUMORE, o.FECORE, o.PROORE, NombreProveedor = p != null ? p.NOMPRV : o.PROORE, o.TOTORE, o.STAORE })
                .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='/Compras/Ordendet?id={s.Id}' class='dropdown-item suggestion-item'>
                    <div class='d-flex justify-content-between align-items-center'>
                        <div>
                            <span class='badge bg-dark me-2'>#{s.NUMORE}</span>
                            <strong>{s.NombreProveedor}</strong>
                        </div>
                        <span class='badge {(s.STAORE == "A" ? "bg-success" : s.STAORE == "T" ? "bg-info" : "bg-secondary")}'>{(s.STAORE == "A" ? "Activa" : s.STAORE == "T" ? "Terminada" : s.STAORE)}</span>
                    </div>
                    <small class='text-muted'><i class='bi bi-calendar me-1'></i>{s.FECORE.ToString("dd/MM/yyyy")} - <i class='bi bi-currency-dollar me-1'></i>{s.TOTORE?.ToString("N2")}</small>
                </a>
            "));

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

    public class OrdenListViewModel
    {
        public Guid Id { get; set; }
        public int? NUMORE { get; set; }
        public DateTime? FECORE { get; set; }
        public string? PROORE { get; set; }
        public string? NombreProveedor { get; set; }
        public decimal? TOTORE { get; set; }
        public decimal? IVAORE { get; set; }
        public int? MONORE { get; set; }
        public string? STAORE { get; set; }
    }
}

@page
@model MimPortal.Pages.Compras.ComprasModel
@{
    ViewData["Title"] = "Órdenes de Compra";
    var hxTarget = ViewData["HX-Target"]?.ToString() ?? "";
    var isSearchRequest = hxTarget == "results-container";
}

@* If this is a search/pagination request, return only the cards partial *@
@if (isSearchRequest)
{
    <partial name="_ComprasCards" model="Model" />
}
else
{
    @* Full page content for direct access or menu navigation *@
    <style>
        .compra-card {
            transition: transform 0.2s ease, box-shadow 0.2s ease;
            border: 1px solid #dee2e6;
        }
        .compra-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;
        }
        .search-container .htmx-indicator {
            position: absolute;
            right: 1rem;
            top: 50%;
            transform: translateY(-50%);
            z-index: 10;
        }
        .htmx-request .htmx-indicator {
            display: inline-block !important;
        }
        
        /* Autocomplete dropdown styles */
        .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:last-child {
            border-bottom: none;
            border-radius: 0 0 15px 15px;
        }
        .autocomplete-dropdown .dropdown-item:hover,
        .autocomplete-dropdown .dropdown-item:focus {
            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-cart"></i> Órdenes de Compra</h5>
                <a href="/Compras/Ordenadd" class="btn btn-success btn-sm">
                    <i class="bi bi-plus-circle"></i> Nueva Orden
                </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 orden o proveedor..."
                           hx-get="/Compras/Compras"
                           hx-trigger="keyup changed delay:300ms, search"
                           hx-target="#results-container"
                           hx-swap="innerHTML"
                           hx-include="[name='FechaDesde'],[name='FechaHasta']"
                           hx-indicator="#search-spinner"
                           autocomplete="off" />
                    <div id="search-spinner" class="htmx-indicator">
                        <div class="spinner-border spinner-border-sm text-primary" role="status">
                            <span class="visually-hidden">Buscando...</span>
                        </div>
                    </div>
                    
                    <!-- Autocomplete dropdown -->
                    <div id="suggestions-dropdown" class="autocomplete-dropdown"></div>
                </div>
                
                <!-- Date filters -->
                <div class="row g-2 mb-4">
                    <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="/Compras/Compras"
                                   hx-trigger="change"
                                   hx-target="#results-container"
                                   hx-include="[name='Buscar'],[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="/Compras/Compras"
                                   hx-trigger="change"
                                   hx-target="#results-container"
                                   hx-include="[name='Buscar'],[name='FechaDesde']" />
                        </div>
                    </div>
                </div>

                <!-- Results container - HTMX will update this -->
                <div id="results-container">
                    <partial name="_ComprasCards" model="Model" />
                </div>
            </div>
        </div>
        
        <!-- Script inside page-content so it runs on HTMX navigation -->
        <script>
            (function() {
                // Initialize autocomplete if MimAutocomplete is available
                if (typeof MimAutocomplete !== 'undefined') {
                    MimAutocomplete.init({
                        inputId: 'search-input',
                        dropdownId: 'suggestions-dropdown',
                        suggestionsUrl: '/Compras/Compras?handler=Suggestions',
                        paramName: 'Buscar',
                        minChars: 2,
                        debounceMs: 150
                    });
                }
                // Process any HTMX elements that were just loaded
                if (typeof htmx !== 'undefined') {
                    htmx.process(document.getElementById('page-content'));
                }
            })();
        </script>
    </div>
}