function jsaGetDatos($solicitud)
{
if ($solicitud != 0 and $solicitud != '') {
$xCred = new cCreditos_solicitud();
$xCred->setData($xCred->query()->getRow("numero_solicitud={$solicitud}"));
$pagos = $xCred->numero_pagos()->v();
$monto = $xCred->monto_solicitado()->v();
$periocidad = $xCred->periocidad_de_pago()->v();
$tasa = $xCred->tasa_interes()->v();
$xF = new cFecha();
$xT = new cTipos();
$tab = new TinyAjaxBehavior();
$tab->add(TabSetvalue::getBehavior('idpagos', $pagos));
$tab->add(TabSetvalue::getBehavior('idmonto', $monto));
$tab->add(TabSetvalue::getBehavior('idtasa', $tasa * 100));
$tab->add(TabSetvalue::getBehavior('idperiocidad', $periocidad));
$tab->add(TabSetvalue::getBehavior('idtipodepago', $xCred->tipo_de_pago()->v()));
//Fechas de ministracion
$tab->add(TabSetvalue::getBehavior('idfecha1', $xF->getFechaMX($xCred->fecha_autorizacion()->v(), "-")));
$tab->add(TabSetvalue::getBehavior('idfecha2', $xF->getFechaMX($xCred->fecha_ministracion()->v(), "-")));
$tab->add(TabSetvalue::getBehavior('idautorizacion', $xCred->docto_autorizacion()->v()));
$tab->add(TabSetvalue::getBehavior('idtipodeautorizacion', $xCred->tipo_autorizacion()->v()));
return $tab->getString();
}
}
function jsaGetDatosEmpresa($idEmpresa)
{
$xEmp = new cEmpresas($idEmpresa);
$xF = new cFecha();
$ql = new MQL();
$xl = new cSQLListas();
$observaciones = "";
$xEmp->init();
$persona = $xEmp->getClaveDePersona();
$xF = new cFecha(0);
$opts = "";
$exT = "";
$periocidad = $xEmp->getPeriocidadPref();
$periodo = $periocidad == CREDITO_TIPO_PERIOCIDAD_SEMANAL ? $xF->semana() : $xF->quincena();
$periodo = intval($xEmp->getPeriodo()) < 1 ? $periodo : intval($xEmp->getPeriodo());
$data = $ql->getDataRecord($xl->getListadoDePeriodoPorEmpresa($idEmpresa));
$variacion = "0";
$fecha_inicial = $xF->getFechaMX();
$fecha_final = $xF->getFechaMX();
$control = 0;
$ctrl = "<label for=\"idperiodo\">Periodo {$periodo}</label><input type=\"number\" id=\"idperiodo\" onchange=\"jsGetCobranza()\" onblur=\"jsGetCobranza()\" />";
$contar = 1;
$max = 5;
foreach ($data as $rw) {
$idsel = "";
$idclave = $rw["codigo"];
$xPer = $xEmp->getOPeriodo(false, false, $idclave);
if ($periodo == $xPer->periodo_marcado()->v() and $periocidad == $xPer->periocidad()->v()) {
$control = $idclave;
$periodo = $xPer->periodo_marcado()->v();
$periocidad = $xPer->periocidad()->v();
$fecha_final = $xPer->fecha_final()->v();
$fecha_inicial = $xPer->fecha_inicial()->v();
$idsel = " selected=\"true\" ";
}
if ($contar <= $max) {
$opts .= "<option value=\"" . $idclave . " \"{$idsel}>" . $rw["nombre_periocidad"] . "[" . $xPer->periodo_marcado()->v() . "]";
$opts .= " - DEL: " . $xF->getFechaDDMM($rw["fecha_inicial"]) . " - " . $xF->getFechaDDMM($rw["fecha_final"]) . " SALDO " . getFMoney($rw["saldo"]) . "</option>";
}
$contar++;
}
if ($opts != "") {
$ctrl = "<label for='idperiodo'>Periodo</label><select id=\"idperiodo\" name=\"idperiodo\" onblur=\"jsGetCobranza()\" onchange=\"jsGetCobranza()\">{$opts}</select>";
}
$ctrl .= "<input type=\"hidden\" id=\"idvariacion\" value=\"{$variacion}\" />";
$ctrl .= "<input type=\"hidden\" id=\"idperiodo\" value=\"{$periodo}\" />";
$ctrl .= "<input type=\"hidden\" id=\"idperiocidad\" value=\"{$periocidad}\" />";
$ctrl .= "<input type=\"hidden\" id=\"idclavedepersona\" value=\"{$periocidad}\" />";
return $ctrl;
}
function jsaInitPeriodo($empresa, $periocidad, $periodo)
{
$xF = new cFecha();
$xEmp = new cEmpresas($empresa);
$xEmp->init();
$tab = new TinyAjaxBehavior();
$DPer = $xEmp->getOPeriodo($periocidad);
$empPeriodo = $xEmp->getPeriodo();
if ($periodo > $empPeriodo) {
$fechaInicial = $xEmp->getFechaDeAviso($periocidad, false, $periodo, $periodo + 1);
} else {
$dias_dif = setNoMenorQueCero($periodo - $empPeriodo);
$starD = $periocidad * $dias_dif + 1;
$fechaInicial = $xF->setSumarDias($starD, $DPer->fecha_final()->v());
}
$fechaFinal = $xF->setSumarDias($xEmp->getPeriocidadPref(), $fechaInicial);
$tab->add(TabSetvalue::getBehavior("idfecha-10", $xF->getFechaMX($fechaInicial, "-")));
$tab->add(TabSetvalue::getBehavior("idfecha-11", $xF->getFechaMX($fechaFinal, "-")));
return $tab->getString();
}
$xTa->addTH("Numero Maximo de Operaciones");
$xTa->addTH("Monto Maximo de Operaciones");
$xTa->endRow();
$xT = new cFileImporter();
foreach ($rs as $rows) {
$xDSoc->setData($rows);
$codigo_de_socio = $xDSoc->codigo()->v();
$xSoc = new cSocio($codigo_de_socio);
$xSoc->init($rows);
$xSoc->getOEstats()->initDatosDeCredito();
$saldoCred = setNoMenorQueCero($xSoc->getCreditosComprometidos());
if ($saldoCred > 0) {
$xTa->initRow();
$xTa->addTD($xSoc->getSucursal());
$xTa->addTD(htmlentities($xSoc->getNombreCompleto()));
$xTa->addTD($xF->getFechaMX($xSoc->getFechaDeNacimiento()));
$xTa->addTD("MEXICANA");
$xTa->addTD($xSoc->getRFC());
$xOAE = $xSoc->getOActividadEconomica();
if ($xOAE == null) {
$xTa->addTD(" ");
$xTa->addTD(" ");
} else {
$idclave = $xOAE->getClaveDeActividad();
$actividad = isset($DActividades[$idclave]) ? htmlentities($DActividades[$idclave]) : "";
$actividad = strtoupper($xT->cleanString($actividad));
$actividad = $actividad == "DESCONOCIDO_MIGRADO" ? "" : $actividad;
$xTa->addTD($actividad);
//$xTa->addTD( $xOAE->getPuesto(true) );
}
$xViv = $xSoc->getODomicilio();
// mysql_num_rows($rs);
$counter = 0;
//while($rw = mysql_fetch_array($rs)){
foreach ($rs as $rw) {
//$TR_head = "";
if ($credito_anterior == false) {
$credito_anterior = $rw["solicitud"];
}
$credito = $rw["solicitud"];
if ($credito != $credito_anterior) {
//resetear TR_child
$TR_parent .= "\n\n \t\t\t\t{$TR_head}\n\n \t\t\t\t<tr>\n \t\t\t\t\t<td colspan='4'>\n \t\t\t\t\t\t<table>\n \t\t\t\t\t\t\t<thead>\n \t\t\t\t\t\t\t\t<th width='10%'>Recibo</th>\n \t\t\t\t\t\t\t\t<th width='15%'>Fecha</th>\n \t\t\t\t\t\t\t\t<th width='25%'>Operacion</th>\n \t\t\t\t\t\t\t\t<th width='20%'>Monto</th>\n \t\t\t\t\t\t\t\t<th width='30%'>Detalles</th>\n \t\t\t\t\t\t\t<thead>\n \t\t\t\t\t\t\t<tbody>\n \t\t\t\t\t\t\t{$TR_child}\n \t\t\t\t\t\t\t</tbody>\n \t\t\t\t\t\t</table>\n \t\t\t\t\t</td>\n \t\t\t\t\t<tr>\n \t\t\t\t\t\t<td colspan='4'></td>\n \t\t\t\t\t\t<td colspan='4'></td>\n \t\t\t\t\t</tr>\n \t\t\t\t</tr>\n \t\t\t\t";
$TR_child = "";
$TR_head = "";
}
$TR_child .= "\n\t\t\t<tr>\n\t\t\t\t<td>" . $rw["recibo"] . "</td>\n\t\t\t\t<td>" . $xF->getFechaMX($rw["fecha"]) . "</td>\n\t\t\t\t<td>" . $rw["tipo_de_operacion"] . "</td>\n\t\t\t\t<td class='mny'>" . getFMoney($rw["monto"]) . "</td>\n\t\t\t\t<td>" . $rw["detalles"] . "</td>\n\t\t\t</tr>";
$sumCAP += $rw["monto_original"];
$sumSDO += $rw["saldo_insoluto"];
$TR_head = "\n\t\t\t\t<tr>\n\t\t\t\t\t<th class='izq'>Socio</th>\n\t\t\t\t\t<td>" . $rw["socio"] . "</td>\n\t \t\t\t\t<th class='izq'>Nombre\n\t \t\t\t\t</th><td>" . $rw["nombre"] . "</td>\n\t \t\t\t</tr>\n\t \t\t\t<tr>\n \t\t\t\t\t<th class='izq'>Numero de Solicitud</th>\n \t\t\t\t\t<td>" . $rw["solicitud"] . "</td>\n \t\t\t\t\t<th class='izq'>Fecha de Ministracion</th>\n \t\t\t\t\t<td>" . $rw["fecha_de_otorgamiento"] . "</td>\n \t\t\t\t</tr>\n \t\t\t\t<tr>\n\t \t\t\t\t<th class='izq'>Tipo de Convenio</th>\n\t \t\t\t\t<td>" . $rw["modalidad"] . "</td>\n\t \t\t\t\t<th class='izq'>Fecha de Vencimiento</th>\n\t \t\t\t\t<td>" . $rw["fecha_de_vencimiento"] . "</td>\n\t \t\t\t</tr>\n\t \t\t\t<tr>\n \t\t\t\t\t<th class='izq'>Periocidad</th>\n \t\t\t\t\t<td>" . $rw["condiciones_de_pago"] . "</td>\n \t\t\t\t\t<th class='izq'>Estatus</th>\n \t\t\t\t\t<td>" . $rw["estatus"] . "</td>\n\t \t\t\t</tr>\n\t \t\t\t<tr>\n\t \t\t\t\t<th class='izq'>Monto Ministrado</th>\n\t \t\t\t\t<td class='mny'>" . getFMoney($rw["monto_original"]) . "</td>\n\t \t\t\t\t<th class='izq'>Saldo Actual</th>\n\t \t\t\t\t<td class='mny'>" . getFMoney($rw["saldo_insoluto"]) . "</td>\n \t\t\t\t</tr>";
$credito_anterior = $credito;
$counter++;
}
//Corregir el último
//resetear TR_child
$TR_parent .= "\n{$TR_head}\n<tr>\n\t<td colspan='4'>\n\t\t<table>\n\t\t\t<thead>\n\t\t\t\t<th width='10%'>Recibo</th>\n\t\t\t\t<th width='15%'>Fecha</th>\n\t\t\t\t<th width='25%'>Operacion</th>\n\t\t\t\t<th width='20%'>Monto</th>\n\t\t\t\t<th width='30%'>Detalles</th>\n\t\t\t<thead>\n\t\t<tbody> {$TR_child} </tbody>\n\t\t</table>\n\t</td>\n</tr>";
/* <!-- <tr>
<td colspan='4'>
<hr />
</td>
<tr>
<th class='izq'>[$counter]Monto Ministrado</th>
/**
* Genera la Tabla
* @param string $vCaption Titulo de la Tabla
* @param boolean $retorna Retornar la Tabla como Valor? true/false
*/
function Show($vCaption = "", $retorna = true, $TableID = "")
{
$xHComm = new cHObject();
$xD = new cFecha();
$xLng = new cLang();
$xT = new cTipos();
$xQL = new MQL();
$xBtn = new cHButton();
$xIcs = $this->ODicIcons();
$this->mID = $TableID == "" ? $this->mID : $TableID;
if (MODO_DEBUG == true and isset($_SERVER["REQUEST_URI"])) {
//setLog($_SERVER["REQUEST_URI"]);
if (strpos($_SERVER["REQUEST_URI"], "rpt") === false) {
$this->addTool(3);
}
}
$xD->setSeparador("/");
if ($this->mSql != "") {
//Miembros de las Tablas
$tds = "";
$ths = "";
//Inicio de Tabla
$pushInit = "";
$pushEnd = "";
$vClassT = "";
$vWidth = "";
$tdt = "";
$tht = "";
$tab = "";
$tfoot = "";
$trick = 1;
$capTable = "";
$oldTags = false;
if ($this->mTipoSalida == OUT_EXCEL) {
$oldTags = true;
}
//si hay Caption formar el caption
if ($vCaption != "" and $this->mPrepareChart == false) {
$vCaption = $xLng->getT($vCaption);
$vCaption = "<legend>[ {$vCaption} ]</legend>";
$pushInit = "<fieldset>{$vCaption}";
$pushEnd = "</fieldset>";
}
if ($vCaption != "" and $this->mPrepareChart == true) {
$capTable = "<caption>{$vCaption}</caption>";
}
if ($vCaption != "" and $this->mTipoSalida == OUT_EXCEL) {
$capTable = "<caption>{$vCaption}</caption>";
}
//Clase de la Tabla
if ($this->mClassT != "") {
$this->mClassT = " " . $this->mClassT;
}
$vClassT = "class=\"listado" . $this->mClassT . "\" ";
//Contar Tools
$il = count($this->mTool);
$itmCmd = count($this->mEspCMD);
$itmEspTool = count($this->mEspTool);
$itmTot = $il + $itmCmd + $itmEspTool;
if ($itmTot > 0) {
$wd = setNoMenorQueCero($this->mWidthTool) <= 0 ? $itmTot * 26 . "px" : $this->mWidthTool;
$tht = "<th style='min-width:" . $wd . ";width:" . $wd . ";'>Acciones</th>";
}
// --------------------------------------------------------------
$rs = getRecordset($this->mSql);
if ($this->mKeyField == "") {
$this->mKeyField = mysql_field_name($rs, $this->mKey);
}
if ($this->mTbl == "") {
$this->mTbl = mysql_field_table($rs, $this->mKey);
}
//Arrays de Nombres y tipo
$arrFieldNames = array();
$arrFieldTypes = array();
$preCols = count($this->Fields) <= 1 ? false : true;
//
$ifl = mysql_num_fields($rs) - 1;
//Limite de Fields
//------------------------------------------------------------- //Cabeceras de Columnas
for ($iCols = 0; $iCols <= $ifl; $iCols++) {
$fname = mysql_field_name($rs, $iCols);
$ftypes = mysql_field_type($rs, $iCols);
$this->Fields[] = $fname;
if ($this->mKey == 0 and $this->mKeyField != "") {
if (strtolower($fname) == strtolower($this->mKeyField)) {
$this->mKey = $iCols;
}
}
$tths = "";
if (isset($this->mColTitles[$fname])) {
$tths = $this->mColTitles[$fname];
} else {
$tths = strtoupper(str_replace("_", " ", $fname));
}
$tths = $xLng->getT("TR.{$tths}");
$cssTh = $iCols == $this->mKey ? " class='key' " : "";
$scope = $this->mPrepareChart == true ? " scope='col' " : "";
//Mejorar codigo
if ($this->mTipoSalida == OUT_EXCEL) {
$ths .= "<th class=\"xl25\">{$tths}</th>";
} else {
if ($this->mTipoSalida == OUT_TXT or $this->mTipoSalida == OUT_CSV) {
$ths .= $iCols == 0 ? $tths : $this->mDelimiter . $tths;
$ths .= $iCols == $ifl ? "\r\n" : "";
} else {
$ths .= ($this->mPrepareChart == true and $iCols == $this->mKey) ? "<td></td>" : "<th {$scope} {$cssTh}>{$tths}</th>";
}
}
/**
* Construye el Array de Tipos y Nombres
*/
$arrFieldNames[$iCols] = $fname;
$arrFieldTypes[$iCols] = $ftypes;
}
//$ths . "\n $tht";
// --------------------------------------------------------------
while ($rw = mysql_fetch_array($rs)) {
$this->mRowCount++;
$tdt = "";
$pKey = $this->mKey;
$idKey = is_string($rw[$pKey]) == true ? "'" . $rw[$pKey] . "'" : $rw[$pKey];
$dataCustom = "";
$trick = $trick >= 2 ? 1 : $trick + 1;
//switch oddr
$lis = "";
$liCss = $trick == 2 ? "tags green" : "tags blue";
/*$t = array(
0 => $xBtn->getBasic("TR.Ejecutar", $this->mActionExec . "($idKey)", ) "<img src='../images/common/execute.png' onclick=\"" . $this->mActionExec . "($idKey);\" title='Ejecutar Una acción' />",
1 => "<img src='../images/common/edit.png' onclick=\"if(typeof actualizame" . $this->mRndK . " != 'undefined'){actualizame" . $this->mRndK . "($idKey);} else {jsUp('" . $this->mTbl . "','" . $this->mKeyField . "', $idKey); } \" title='Editar Registro' />",
SYS_DOS => "<img src='../images/common/trash.png' onclick=\"var xG = new Gen(); xG.rmRecord({tabla:'" . $this->mTbl . "',id:" . $idKey . "});\" title='Eliminar Registro' />"
);*/
$t = array(0 => $xBtn->getBasic("TR.Ejecutar", $this->mActionExec . "({$idKey})", $xIcs->EJECUTAR, "exec{$idKey}", false, true), 1 => $xBtn->getBasic("TR.Editar", "if(typeof actualizame" . $this->mRndK . " != 'undefined'){actualizame" . $this->mRndK . "({$idKey});} else {jsUp('" . $this->mTbl . "','" . $this->mKeyField . "', {$idKey}); }", $xIcs->EDITAR, "redit{$idKey}", false, true), 2 => $xBtn->getBasic("TR.Eliminar", "var xG = new Gen(); xG.rmRecord({tabla:'" . $this->mTbl . "',id:" . $idKey . "});", $xIcs->ELIMINAR, "rdel{$idKey}", false, true), 3 => $xBtn->getBasic("TR.Ver", "var xDev=new SafeDev(); xDev.recordRAW({tabla:'" . $this->mTbl . "',id:" . $idKey . "});", $xIcs->EXPORTAR, "idcmdview{$idKey}", false, true));
foreach ($this->mTool as $idx => $clave) {
$lis .= isset($t[$clave]) ? "<li>" . $t[$clave] . "</li>" : "";
}
foreach ($this->mEspCMD as $idx => $cnt) {
$lis .= "<li>" . str_replace(HP_REPLACE_ID, $rw[$pKey], $cnt) . "</li>";
}
$tdt = $lis == "" ? "" : "<ul class='{$liCss}'>{$lis}</ul>";
/**
* Herramientas especiales
*/
foreach ($this->mEspTool as $key => $value) {
$DefValue = str_replace(HP_REPLACE_ID, $rw[$pKey], $value);
//validar si no es PHP
if (strpos($DefValue, "PHP::") !== false) {
$cod = str_replace("PHP::", "\$DefValue=", $DefValue);
eval($cod);
}
$tdt .= "\n " . $DefValue;
}
$tdt = trim($tdt) != "" ? "<td id=\"options-" . $rw[$pKey] . "\" class=\"toolbar-24\">{$tdt}</td>" : "";
if ($this->mTipoSalida == OUT_EXCEL) {
$tdt = "";
}
//-------------------------------------------------------
$ttds = "";
for ($i = 0; $i <= $ifl; $i++) {
$event = "";
$css = "";
$oprp = "";
$currVal = $rw[$i];
$sanID = str_replace(" ", "_", $currVal);
$type = isset($arrFieldTypes[$i]) ? $arrFieldTypes[$i] : "text";
$name = $arrFieldNames[$i];
$scope = "";
$delims = "td";
$mkEnd = "";
$extraCNT = "";
if ($i == $this->mKey) {
$event = $this->EventKey;
if ($event != "") {
$event = "<a class='button' onclick=\"{$event}('{$rw[$i]}');\" >";
$mkEnd = "</a>";
}
$css .= "key";
$oprp = " id=\"pk-" . $sanID . "\" ";
$scope = $this->mPrepareChart == true ? "scope=\"row\"" : "";
$delims = $this->mPrepareChart == true ? "th" : "td";
}
/**
*Agrega el data Custom
*/
if ($this->mDataCustom == true) {
$dataCustom .= $dataCustom == "" ? "{$name}={$currVal}" : "|{$name}={$currVal}";
}
/**
* Agrega una suma si el tipo aplica
*/
if (isset($this->arrTypesPHP[$type]) and $this->arrTypesPHP[$type] == "numeric") {
if (!isset($this->mFieldSum[$name])) {
$this->mFieldSum[$name] = 0;
}
$this->mFieldSum[$name] += $currVal;
}
//Agregar sub consulta
/*if($this->mSubsEnable == true){
$sqlSub = "";
//si no encuentra
if(isset($this->mSubSQLs[$i])){
$sqlSub = $this->mSubSQLs[$i];
} elseif(isset($this->mSubSQLs[$name])){
$sqlSub = $this->mSubSQLs[$name];
} else {
if ($i == $this->mKey OR $name == $this->mKeyField){
$sqlSub = (isset($this->mSubSQLs[0])) ? $this->mSubSQLs[0] : "";
}
}
if($sqlSub == ""){
} else {
$sqlSub = str_replace(HP_REPLACE_ID,$currVal, $sqlSub);
//if($currVal == 200039104){setLog($sqlSub);}
$mql = new MQL();
$data = $mql->getDataRecord($sqlSub);
$cnt = "";
$outc = new cHObject();
foreach($data as $info){
foreach($info as $pfield => $pvalue){
$cnt .= $pvalue . "\r\n";
}
}
$extraCNT .= $outc->Out($cnt, OUT_HTML);
}
}*/
//Tipo de Dato
/**
* Si la Opcion de Class por tipo es verdadero
* formatea cada Td como su tipo
*/
$oStr = array("string" => "string", "varchar" => "varchar", "text" => "text", "tinytext" => "tinytext");
if (!isset($oStr[$type])) {
$css = $css == "" ? $type : "{$css} {$type}";
}
if (isset($this->arrRowCSS[$name])) {
$css = $css == "" ? $type : "{$css} " . $this->arrRowCSS[$name];
}
$css = $css == "" ? "" : " class=\"{$css}\" ";
//Formatea a Moneda el valor si es tpo real
if ($type == "real") {
$currVal = ($this->mPrepareChart == true or $this->mTipoSalida == OUT_EXCEL) ? round($currVal, 2) : getFMoney($currVal);
}
if ($type == "date") {
$currVal = $xD->getFechaMX($currVal);
}
if (isset($oStr[$type])) {
$currVal = $xHComm->Out($currVal, OUT_HTML);
}
if ($this->mTipoSalida == OUT_EXCEL) {
//class=xl2216681 nowrap
$ttds .= "<{$delims} class=\"xl25\" >" . $currVal . "</{$delims}>";
} else {
if ($this->mTipoSalida == OUT_TXT or $this->mTipoSalida == OUT_CSV) {
$ttds .= $i == 0 ? $currVal : $this->mDelimiter . $currVal;
} else {
$css = $this->mPrepareChart == true ? "" : $css;
$ttds .= "<{$delims} {$scope} {$css} {$oprp}>{$event}" . $currVal . "{$mkEnd}{$extraCNT}</{$delims}>";
}
}
}
//
$trcss = $trick >= 2 ? " class='trOdd' " : "";
if ($this->mTipoSalida == OUT_EXCEL) {
$tds .= "<tr>{$ttds}{$tdt}</tr>\r\n";
} else {
if ($this->mTipoSalida == OUT_TXT or $this->mTipoSalida == OUT_CSV) {
$tds .= $ttds . "\r\n";
} else {
$dataCustom = $dataCustom != "" ? " data-info=\"{$dataCustom}\" " : "";
$tds .= "<tr id=\"tr-" . $this->mTbl . "-" . str_replace(" ", "_", $rw[$this->mKey]) . "\"{$dataCustom} {$trcss}>{$ttds} {$tdt} </tr>";
}
}
if ($this->mSubsEnable == true) {
foreach ($this->mSubSQLs as $idx => $sqls) {
if ($sqls != "") {
$sqlSub = str_replace(HP_REPLACE_ID, $rw[$this->mKey], $sqls);
$mql = new MQL();
$data = $mql->getDataRecord($sqlSub);
$outc = new cHObject();
foreach ($data as $info) {
foreach ($info as $pfield => $pvalue) {
$cnt .= $pvalue . "\r\n";
}
}
$extraCNT .= $outc->Out($cnt, OUT_HTML);
$icx22 = $ifl + 2;
$tds .= "<tr id=\"tr-subs-" . $this->mTbl . "-" . str_replace(" ", "_", $rw[$this->mKey]) . "\"><td colspan='{$icx22}'>{$extraCNT}</td></tr>";
}
}
}
}
$this->vFields = $rw;
// --------------------------------------------------------------
@mysql_free_result($rs);
$ism = $this->mFootSums;
//sumas
$tfoot = "";
for ($i = 0; $i <= $ifl; $i++) {
if (isset($ism[$i])) {
if ($this->mTipoSalida == OUT_EXCEL) {
$tfoot .= isset($this->mFieldSum[$ism[$i]]) ? "<th>" . getFMoney($this->mFieldSum[$ism[$i]]) . "</th>" : "<td></td>";
} else {
$tfoot .= isset($this->mFieldSum[$ism[$i]]) ? "<th><input type='hidden' id='idsum-" . $ism[$i] . "' value='" . $this->mFieldSum[$ism[$i]] . "' /><mark id='sum-" . $ism[$i] . "'>" . getFMoney($this->mFieldSum[$ism[$i]]) . "</mark></th>" : "<td></td>";
}
} else {
$tfoot .= $i == 0 ? "<th>Filas: " . $this->mRowCount . "</th>" : "<td></td>";
}
}
$tfoot = $oldTags == true ? "<tr>{$tfoot}</tr>" : "<tfoot><tr>{$tfoot}</tr></tfoot>";
$tfoot = ($this->mSumFoot == false or $this->mPrepareChart == true) ? "" : $tfoot;
//Da Salida a la Tbla
$mID = $this->mID;
$aProps = $this->mTipoSalida == OUT_EXCEL ? " x:str border=0 style='border-collapse: collapse' " : " {$vClassT} id=\"{$mID}\"";
$aProps = $this->mPrepareChart == true ? " style=\"display: none; text-align: center \" > " : $aProps;
$tBody = $oldTags == true ? "{$tds}" : "<tbody>{$tds}</tbody>";
$tHead = $oldTags == true ? "<tr>{$ths}{$tht}</tr>" : "<thead><tr>{$ths}{$tht}</tr></thead>";
$tHead = trim($ths) == "" ? "" : $tHead;
if ($this->mTipoSalida == OUT_TXT or $this->mTipoSalida == OUT_CSV) {
$tab = "{$ths} {$tds}";
} else {
$tab = "{$pushInit}<table{$aProps}>{$capTable}{$tHead}{$tBody}{$tfoot}</table>{$pushEnd}";
}
if ($retorna == true) {
return $tab;
} else {
echo $tab;
}
}
}
