Detalle: crequi.asp - MIM Portal

crequi.asp

Ir a la Página Volver a la Lista

Archivo ASP

crequi.asp

Página Razor

Compras/Crequi.cshtml

Módulo

General

Líneas de Código

106

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	-
`creqlist.asp`	include	General	Pendiente	-
`empresa.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 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 CRequiM where (CReqU  like'" & nombre & "') order By CReqO"
rs5.open sql5,cn1,1,2
%>

<%
do while not rs5.EOF
%>
<a href="<%=rs5.fields("CreqM")%>.asp"><img src="image/<%=rs5.fields("CReqN")%>.gif" border=0 Alt="<%= Rs5("CreqN") %>"></a>
<%
rs5.MoveNext
loop
%>

</div>

<div class="normal" style="position:absolute; top:100px; left:1">

<center>
<hr>
<br><br>
<Form action="CRequi.asp" name="Proveedores" method='post'>
<TABLE border=0 cellspacing=0 cellpadding=0 class="normal">
<tr>
<td Class="Normalb">Numero de Requisicion: </td>
<td><input type=text class=normalb name="NumReq" id="NumOrd" size=14 onChange="javascript:this.value=this.value.toUpperCase();"></td>
</tr>

<tr>
<td Class="Normalb">Numero de Pedido: </td>
<td><input type=text class=normalb name="NumPed" id="NumOrd" size=14 onChange="javascript:this.value=this.value.toUpperCase();"></td>
</tr>

<tr>
<td Class="Normalb">Cliente:</td>
<td><input type=text class=normalb name="Nomcli" id="Nomprv" size=40 onChange="javascript:this.value=this.value.toUpperCase();"></td>
<td>&nbsp<input type="submit" value="Buscar" class=normalb></td>
</tr>
</table>
</form>
<br>
<!--#include file="CreqList.asp"--><br>


</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.Compras
{
    public class CrequiModel : PageModel
    {
        private readonly MimDbContext _context;
        private const int PageSize = 25;

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

        [BindProperty(SupportsGet = true)]
        public int? NumReq { get; set; }

        [BindProperty(SupportsGet = true)]
        public int? NumPed { get; set; }

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

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

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

        public List<RequisicionViewModel> Requisiciones { 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 OnGetAsync()
        {
            var sucursal = HttpContext.Session.GetString("Sucursal") ?? "MERIDA";
            var sw = Stopwatch.StartNew();

            var query = from r in _context.CREQENC
                        where r.Sucursal == sucursal
                        join c in _context.CLIENTES on r.CliReqE equals c.CLACLI into cliJoin
                        from cli in cliJoin.DefaultIfEmpty()
                        select new RequisicionViewModel
                        {
                            NumReqE = r.NumReqE,
                            PedReqE = r.PedReqE,
                            FecReqE = r.FecReqE,
                            CliReqE = r.CliReqE,
                            ClienteNombre = cli.NOMCLI ?? r.CliReqE,
                            StaReqE = r.StaReqE,
                            MonReqE = r.MonReqE,
                            TcaReqE = r.TcaReqE,
                            ObsReqE = r.ObsReqE,
                            USRREQE = r.USRREQE
                        };

            // Apply filters
            if (NumReq.HasValue)
            {
                query = query.Where(r => r.NumReqE == NumReq.Value);
            }

            if (NumPed.HasValue)
            {
                query = query.Where(r => r.PedReqE == NumPed.Value);
            }

            if (!string.IsNullOrEmpty(NomCli))
            {
                query = query.Where(r => r.ClienteNombre != null && r.ClienteNombre.Contains(NomCli));
            }

            if (!string.IsNullOrEmpty(Status) && int.TryParse(Status, out int statusInt))
            {
                query = query.Where(r => r.StaReqE == statusInt);
            }

            // Order by requisition number descending
            query = query.OrderByDescending(r => r.NumReqE);

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

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

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

    public class RequisicionViewModel
    {
        public int NumReqE { get; set; }
        public int? PedReqE { get; set; }
        public DateTime? FecReqE { get; set; }
        public string? CliReqE { get; set; }
        public string? ClienteNombre { get; set; }
        public int? StaReqE { get; set; }
        public int? MonReqE { get; set; }
        public decimal? TcaReqE { get; set; }
        public string? ObsReqE { get; set; }
        public string? USRREQE { get; set; }
    }
}

@page
@model MimPortal.Pages.Compras.CrequiModel
@{
    ViewData["Title"] = "Requisiciones de Compra";
}
<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-clipboard-check"></i> Requisiciones de Compra</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="/Compras">Compras</a></li>
                        <li class="breadcrumb-item active">Requisiciones</li>
                    </ol>
                </nav>
            </div>
            <a href="/Compras/Crequiadd" class="btn btn-success">
                <i class="bi bi-plus-circle"></i> Nueva Requisición
            </a>
        </div>

        <div class="card mb-4">
            <div class="card-header">
                <h5 class="card-title mb-0"><i class="bi bi-funnel"></i> Filtros de Búsqueda</h5>
            </div>
            <div class="card-body">
                <form method="get" class="row g-3">
                    <div class="col-md-2">
                        <label class="form-label">No. Requisición</label>
                        <input type="number" class="form-control" name="NumReq" value="@Model.NumReq" placeholder="Número" />
                    </div>
                    <div class="col-md-2">
                        <label class="form-label">No. Pedido</label>
                        <input type="number" class="form-control" name="NumPed" value="@Model.NumPed" placeholder="Pedido" />
                    </div>
                    <div class="col-md-4">
                        <label class="form-label">Cliente</label>
                        <input type="text" class="form-control" name="NomCli" value="@Model.NomCli" placeholder="Nombre del cliente" />
                    </div>
                    <div class="col-md-2">
                        <label class="form-label">Status</label>
                        <select class="form-select" name="Status">
                            <option value="">Todos</option>
                            <option value="0" selected="@(Model.Status == "0")">Pendiente</option>
                            <option value="1" selected="@(Model.Status == "1")">Comprada</option>
                            <option value="2" selected="@(Model.Status == "2")">Cerrada</option>
                        </select>
                    </div>
                    <div class="col-md-2 d-flex align-items-end">
                        <button type="submit" class="btn btn-primary w-100">
                            <i class="bi bi-search"></i> Buscar
                        </button>
                    </div>
                </form>
            </div>
        </div>

        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h5 class="card-title mb-0">Listado de Requisiciones</h5>
                <div>
                    <span class="badge bg-primary">@Model.TotalCount registros</span>
                    <span class="badge bg-info">@Model.ElapsedMs ms</span>
                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-hover">
                        <thead class="table-light">
                            <tr>
                                <th>Requisición</th>
                                <th>Pedido</th>
                                <th>Cliente</th>
                                <th>Fecha</th>
                                <th>Moneda</th>
                                <th>Status</th>
                                <th>Usuario</th>
                                <th>Acciones</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if (Model.Requisiciones != null && Model.Requisiciones.Any())
                            {
                                @foreach (var req in Model.Requisiciones)
                                {
                                    <tr>
                                        <td><strong>@req.NumReqE</strong></td>
                                        <td>@req.PedReqE</td>
                                        <td>@req.ClienteNombre</td>
                                        <td>@req.FecReqE?.ToString("dd/MM/yyyy")</td>
                                        <td>@(req.MonReqE == 1 ? "MXN" : "USD")</td>
                                        <td>
                                            @switch (req.StaReqE)
                                            {
                                                case 0:
                                                    <span class="badge bg-warning">Pendiente</span>
                                                    break;
                                                case 1:
                                                    <span class="badge bg-success">Comprada</span>
                                                    break;
                                                case 2:
                                                    <span class="badge bg-secondary">Cerrada</span>
                                                    break;
                                                default:
                                                    <span class="badge bg-info">@req.StaReqE</span>
                                                    break;
                                            }
                                        </td>
                                        <td>@req.USRREQE</td>
                                        <td>
                                            <a href="/Compras/Crequidet/@req.NumReqE" class="btn btn-sm btn-outline-primary" title="Ver Detalle">
                                                <i class="bi bi-eye"></i>
                                            </a>
                                            @if (req.StaReqE == 0)
                                            {
                                                <a href="/Compras/Crequimod/@req.NumReqE" class="btn btn-sm btn-outline-warning" title="Editar">
                                                    <i class="bi bi-pencil"></i>
                                                </a>
                                            }
                                            <a href="/Compras/Crequiimp/@req.NumReqE" class="btn btn-sm btn-outline-secondary" title="Imprimir">
                                                <i class="bi bi-printer"></i>
                                            </a>
                                        </td>
                                    </tr>
                                }
                            }
                            else
                            {
                                <tr>
                                    <td colspan="8" class="text-center text-muted py-4">
                                        <i class="bi bi-inbox fs-1"></i>
                                        <p class="mt-2">No se encontraron requisiciones con los criterios especificados</p>
                                    </td>
                                </tr>
                            }
                        </tbody>
                    </table>
                </div>

@{
                    var paginationModel = new MimPortal.Pages.Shared.PaginationModel 
                    { 
                        CurrentPage = Model.CurrentPage, 
                        TotalPages = Model.TotalPages, 
                        BaseUrl = "/Compras/Crequi", 
                        QueryParams = new Dictionary<string, string> 
                        { 
                            { "NumReq", Model.NumReq?.ToString() ?? "" }, 
                            { "NumPed", Model.NumPed?.ToString() ?? "" }, 
                            { "NomCli", Model.NomCli ?? "" }, 
                            { "Status", Model.Status?.ToString() ?? "" } 
                        } 
                    };
                }
                <partial name="_Pagination" model="paginationModel" />
            </div>
        </div>
    </div>
</div>
<!-- Migrado desde: crequi.asp -->

MATERIALES INDUSTRIALES DE MEXICO

crequi.asp

Archivo ASP

Página Razor

Módulo

Líneas de Código