jpegueroandClaude Sonnet 5.5
539af7f912
- ccprrp018: agrega MAIN, GROUP BY por nombre, y reemplaza la salida Excel/DDE (G:\ESTADO.XLS, DEL G:\ESTADOS) por un reporte Genero (ccprrp018.4rp); carga con un solo INSERT...SELECT en tabla temporal. - ccprrp003: reemplaza el REPORT de texto con codigos de impresora por ccprrp003.4rp; agrega por cliente en una consulta (DATEDIFF, mismas reglas). - ccprrp001: agrega MAIN, GROUP BY por nombre, reporte Genero (ccprrp001.4rp) y registra el formulario ccfmrp001 en FORMULARIOS_CC (faltaba, -1110). - ccprrp052: la validacion del campo Orden estaba al reves. - ccprmt002: cctb00002.fecha es datetime en SQL Server; el formulario, la variable global relacion (ccprgb000) y el CONSTRUCT la manejan como DATE; corrige que eLiminar mostrara exito sin actualizar filas. - mbsERP.4pw: registra los .4rp, libgre y ccfmrp001 (sin credenciales). Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
85 lines
8.9 KiB
XML
85 lines
8.9 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<report:Report xmlns:rtl="http://www.4js.com/2004/RTL" xmlns:report="http://www.4js.com/2007/REPORT" xmlns="http://www.4js.com/2004/PXML" gstVersion="60003" version="7.00">
|
|
<report:Settings RWPageWidth="a4width" RWPageLength="a4length" RWLeftMargin="1.3cm" RWTopMargin="1.3cm" RWRightMargin="1.3cm" RWBottomMargin="1.3cm">
|
|
<report:FormatList>
|
|
<report:Format-SVG/>
|
|
<report:Format-PDF/>
|
|
<report:Format-image/>
|
|
</report:FormatList>
|
|
</report:Settings>
|
|
<report:Data RWFglReportName="estado18"/>
|
|
<report:Conflicts/>
|
|
<rtl:stylesheet>
|
|
<PXML>
|
|
<rtl:match name="Report" nameConstraint="Report" minOccurs="1" maxOccurs="1">
|
|
<MINIPAGE name="page root" width="max" length="max" alignment="near" fontName="Arial" fontSize="8">
|
|
<LAYOUTNODE name="header" width="min" length="min" alignment="center" port="firstPageHeader">
|
|
<WORDBOX name="Title" width="500" length="24" alignment="near" fontSize="15" fontBold="true" textAlignment="center" text="Estado de Cuentas Pendientes de Cobro"/>
|
|
<LAYOUTNODE name="espacio titulo" width="500" length="8"/>
|
|
</LAYOUTNODE>
|
|
<rtl:match name="Group codigo" nameConstraint="Group" minOccurs="0" maxOccurs="unbounded">
|
|
<MINIPAGE name="cliente header" width="min" length="max" layoutDirection="leftToRight" bgColor="#cccccc" fontBold="true">
|
|
<rtl:input-variable name="x.cliente" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="cliente Value" width="290" length="12" alignment="baseline" floatingBehavior="enclosed" text="{{x.cliente}}"/>
|
|
<rtl:input-variable name="x.limite" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="limite Value" width="210" length="12" alignment="baseline" floatingBehavior="enclosed" textAlignment="right" text="{{x.limite}}"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="direccion header" width="min" length="max" layoutDirection="leftToRight" bgColor="#eeeeee">
|
|
<rtl:input-variable name="x.direccion" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="direccion Value" width="230" length="12" alignment="baseline" floatingBehavior="enclosed" text="{{x.direccion}}"/>
|
|
<rtl:input-variable name="x.zona" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="zona Value" width="190" length="12" alignment="baseline" floatingBehavior="enclosed" text="{{x.zona}}"/>
|
|
<rtl:input-variable name="x.corte" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="corte Value" width="80" length="12" alignment="baseline" floatingBehavior="enclosed" textAlignment="right" text="{{x.corte}}"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="encabezado" width="min" length="max" bgColor="#eeeeee" fontBold="true" layoutDirection="leftToRight">
|
|
<WORDBOX name="h1" width="130" length="12" alignment="baseline" text="Documento"/>
|
|
<WORDBOX name="h2" width="80" length="12" alignment="baseline" text="Fecha"/>
|
|
<WORDBOX name="h3" width="100" length="12" alignment="baseline" textAlignment="right" text="Valor"/>
|
|
<WORDBOX name="h4" width="100" length="12" alignment="baseline" textAlignment="right" text="Balance"/>
|
|
<WORDBOX name="h5" width="60" length="12" alignment="baseline" textAlignment="right" text="Dias"/>
|
|
</MINIPAGE>
|
|
<rtl:match name="OnEveryRow" nameConstraint="OnEveryRow" minOccurs="0" maxOccurs="unbounded">
|
|
<MINIPAGE name="fila" width="min" length="max" layoutDirection="leftToRight">
|
|
<rtl:input-variable name="x.documento" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="documento Value" width="130" length="12" alignment="baseline" floatingBehavior="enclosed" text="{{x.documento}}"/>
|
|
<rtl:input-variable name="x.fecha" type="FGLString" expectedLocation="expectedHere"/>
|
|
<WORDWRAPBOX name="fecha Value" width="80" length="12" alignment="baseline" floatingBehavior="enclosed" text="{{x.fecha}}"/>
|
|
<rtl:input-variable name="x.valor" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="valor Value" width="100" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,---,--&.&&" value="{{x.valor}}"/>
|
|
<rtl:input-variable name="x.balance" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="balance Value" width="100" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,---,--&.&&" value="{{x.balance}}"/>
|
|
<rtl:input-variable name="x.dias" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="dias Value" width="60" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="----&" value="{{x.dias}}"/>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
<MINIPAGE name="antiguedad header" width="min" length="max" layoutDirection="leftToRight" bgColor="#eeeeee" fontBold="true">
|
|
<WORDBOX name="a1" width="80" length="12" alignment="baseline" textAlignment="right" text="No vencido"/>
|
|
<WORDBOX name="a2" width="80" length="12" alignment="baseline" textAlignment="right" text="1 a 30"/>
|
|
<WORDBOX name="a3" width="80" length="12" alignment="baseline" textAlignment="right" text="31 a 45"/>
|
|
<WORDBOX name="a4" width="80" length="12" alignment="baseline" textAlignment="right" text="46 a 60"/>
|
|
<WORDBOX name="a5" width="80" length="12" alignment="baseline" textAlignment="right" text="Mas de 60"/>
|
|
<WORDBOX name="a6" width="90" length="12" alignment="baseline" textAlignment="right" text="Total"/>
|
|
</MINIPAGE>
|
|
<MINIPAGE name="antiguedad valores" width="min" length="max" layoutDirection="leftToRight" fontBold="true">
|
|
<rtl:input-variable name="nov" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="nov Value" width="80" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,--&.&&" value="{{nov}}"/>
|
|
<rtl:input-variable name="d1" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="d1 Value" width="80" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,--&.&&" value="{{d1}}"/>
|
|
<rtl:input-variable name="d2" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="d2 Value" width="80" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,--&.&&" value="{{d2}}"/>
|
|
<rtl:input-variable name="d3" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="d3 Value" width="80" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,--&.&&" value="{{d3}}"/>
|
|
<rtl:input-variable name="d4" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="d4 Value" width="80" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,--&.&&" value="{{d4}}"/>
|
|
<rtl:input-variable name="total" type="FGLNumeric" expectedLocation="expectedHere"/>
|
|
<DECIMALFORMATBOX name="total Value" width="90" length="12" alignment="baseline" textAlignment="right" floatingBehavior="enclosed" format="--,---,---,--&.&&" value="{{total}}"/>
|
|
</MINIPAGE>
|
|
<LAYOUTNODE name="espacio cliente" width="500" length="14"/>
|
|
</rtl:match>
|
|
</MINIPAGE>
|
|
</rtl:match>
|
|
</PXML>
|
|
</rtl:stylesheet>
|
|
</report:Report>
|