Detalle: fcotizacion.asp

fcotizacion.asp

Ir a la Página Volver a la Lista

Archivo ASP

fcotizacion.asp

Página Razor

Facturas/Fcotizacion.cshtml

Módulo

General

Líneas de Código

140

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 (3) Páginas a las que esta página enlaza

Archivo ASP	Tipo	Módulo	Estado	Página Razor
`fcotlist.asp`	include	General	Pendiente	-
`fcotm.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/Modulos.css" rel="stylesheet" />
		<link href="css/Buscador.css" rel="stylesheet" />

		<!--- PARA ABRIR LAS VENTANAS EMERGENTES --->
		<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
Dim ClaveCli 
		
ClaveCli = Ucase(Request("ClaveCli"))

'***** 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
		
%>

	<SECTION Class="HeaderGes">
			<div Id="DivHeadGes">
			<%= Rs11("Nombre") %><br>
			<%= Rs11("Direccion") %>, <%= Rs11("colonia") %><br>
			<%= Rs11("Poblacion") %>
			</div>
	</SECTION>

	<SECTION>
	<!--#include file="Fcotm.asp"-->
	</SECTION>	
	
	<SECTION>
	
<%
Dim NumeroCot, NombreCot

NumeroCot = Request("NumeroCot")
NombreCot = Request("NombreCot")

%>	
	<Center>
		<B>***** BUSQUEDA DE COTIZACIONES *****</B>
		<BR><BR>
			<Form action="Fcotizacion.asp" method="post" name="Cotizaciones" id="PedidnoNuevo">

			<Table Class="Pedido">
				<Tr>	
					<Td>Cotizacion:</Td>
					<Td>Nombre Cliente:</Td>
				</Tr>
				<Tr>
					<Td>
					<input tabindex="1" type="text" placeholder="Cotizacion" Title="NÃºmero Cotizacion" name="NumeroCot" id="NumeroCot" Size="7" value="<%= NumeroCot %>">
					</td>
					<Td>
					<input tabindex="2" type="text" placeholder="Nombre Cliente" Title="Nombre Cliente" name="NombreCot" id="NombreCot" Size="15" value="<%= NombreCot %>">				
					</Td>
					<Td>
					<button  tabindex="3" type="submit" name="Buscar" id="BuscarCli"/>Buscar</button>
					</td>
				</Tr>
			</table>
	</SECTION>	


	<SECTION Id="Inventarios">
	<br>
	<center>
	<!--#include file="Fcotlist.asp"-->
	</SECTION>		
<%
Rs11.close
		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 System.Diagnostics;

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

        public FcotizacionModel(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<CotizacionViewModel> Cotizaciones { 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 c in _context.FCOTENC
                        where c.Sucursal == sucursal
                        join cli in _context.CLIENTES on c.CLIFCOTE equals cli.CLACLI into cliJoin
                        from cliente in cliJoin.DefaultIfEmpty()
                        select new CotizacionViewModel
                        {
                            Id = c.Id,
                            NUMFCOTE = c.NUMFCOTE,
                            FECFCOTE = c.FECFCOTE,
                            FVAFCOTE = c.FVAFCOTE,
                            CLIFCOTE = c.CLIFCOTE,
                            ClienteNombre = cliente.NOMCLI ?? c.CLIFCOTE,
                            MONFCOTE = c.MONFCOTE,
                            TCAFCOTE = c.TCAFCOTE,
                            SUBFCOTE = c.SUBFCOTE,
                            IVTFCOTE = c.IVTFCOTE,
                            TOTFCOTE = c.TOTFCOTE,
                            STAFCOTE = c.STAFCOTE,
                            USUFCOTE = c.USUFCOTE,
                            COTIZADOR = c.COTIZADOR
                        };

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

            if (!string.IsNullOrEmpty(Status))
            {
                query = query.Where(c => c.STAFCOTE == Status);
            }

            if (FechaDesde.HasValue)
            {
                query = query.Where(c => c.FECFCOTE >= FechaDesde.Value);
            }

            if (FechaHasta.HasValue)
            {
                query = query.Where(c => c.FECFCOTE <= FechaHasta.Value);
            }

            // Order by cotizacion number descending
            query = query.OrderByDescending(c => c.NUMFCOTE);

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

            // Paginate
            Cotizaciones = await query
                .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 query = from c in _context.FCOTENC
                        where c.Sucursal == sucursal
                        join cli in _context.CLIENTES on c.CLIFCOTE equals cli.CLACLI into cliJoin
                        from cliente in cliJoin.DefaultIfEmpty()
                        select new { c.NUMFCOTE, c.FECFCOTE, c.CLIFCOTE, ClienteNombre = cliente.NOMCLI ?? c.CLIFCOTE, c.TOTFCOTE, c.STAFCOTE };

            // Search by number or client name
            if (int.TryParse(Buscar, out int numCot))
            {
                query = query.Where(c => c.NUMFCOTE == numCot);
            }
            else
            {
                query = query.Where(c => c.ClienteNombre != null && c.ClienteNombre.Contains(Buscar));
            }

            var suggestions = await query
                .OrderByDescending(c => c.NUMFCOTE)
                .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/Fcotdet/{s.NUMFCOTE}' class='dropdown-item suggestion-item'>
                    <div class='d-flex justify-content-between align-items-center'>
                        <div>
                            <span class='badge bg-dark me-2'>#{s.NUMFCOTE}</span>
                            <strong>{s.ClienteNombre}</strong>
                        </div>
                        <span class='badge {(s.STAFCOTE == "A" ? "bg-success" : s.STAFCOTE == "P" ? "bg-warning" : s.STAFCOTE == "F" ? "bg-info" : "bg-secondary")}'>{(s.STAFCOTE == "A" ? "Autorizada" : s.STAFCOTE == "P" ? "Pendiente" : s.STAFCOTE == "F" ? "Facturada" : s.STAFCOTE)}</span>
                    </div>
                    <small class='text-muted'><i class='bi bi-calendar me-1'></i>{s.FECFCOTE:dd/MM/yyyy} - <i class='bi bi-currency-dollar me-1'></i>{s.TOTFCOTE?.ToString("N2")}</small>
                </a>
            "));

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

    public class CotizacionViewModel
    {
        public Guid Id { get; set; }
        public int NUMFCOTE { get; set; }
        public DateTime FECFCOTE { get; set; }
        public DateTime? FVAFCOTE { get; set; }
        public string? CLIFCOTE { get; set; }
        public string? ClienteNombre { get; set; }
        public int MONFCOTE { get; set; }
        public decimal? TCAFCOTE { get; set; }
        public decimal? SUBFCOTE { get; set; }
        public decimal? IVTFCOTE { get; set; }
        public decimal? TOTFCOTE { get; set; }
        public string? STAFCOTE { get; set; }
        public string? USUFCOTE { get; set; }
        public string? COTIZADOR { get; set; }
    }
}

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

@if (isSearchRequest)
{
    <partial name="_CotizacionesCards" model="Model" />
}
else
{
    <style>
        .cotizacion-card {
            transition: transform 0.2s ease, box-shadow 0.2s ease;
            border: 1px solid #dee2e6;
        }
        .cotizacion-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-text"></i> Cotizaciones</h5>
                <a href="/Facturas/Fcotadd" class="btn btn-success btn-sm">
                    <i class="bi bi-plus-circle"></i> Nueva Cotizació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 cotización o cliente..."
                           hx-get="/Facturas/Fcotizacion"
                           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/Fcotizacion"
                                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="A" selected="@(Model.Status == "A")">Autorizada</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/Fcotizacion"
                                   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/Fcotizacion"
                                   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="_CotizacionesCards" model="Model" />
                </div>
            </div>
        </div>
        
        <script>
            (function() {
                if (typeof MimAutocomplete !== 'undefined') {
                    MimAutocomplete.init({
                        inputId: 'search-input',
                        dropdownId: 'suggestions-dropdown',
                        suggestionsUrl: '/Facturas/Fcotizacion?handler=Suggestions',
                        paramName: 'Buscar',
                        minChars: 2,
                        debounceMs: 150
                    });
                }
                if (typeof htmx !== 'undefined') {
                    htmx.process(document.getElementById('page-content'));
                }
            })();
        </script>
    </div>
}

MATERIALES INDUSTRIALES DE MEXICO

fcotizacion.asp

Archivo ASP

Página Razor

Módulo

Líneas de Código