$mGridKeyField = "idcreditos_tipoconvenio";
//Nombre del Campo Unico
$mGridKeyEdit = false;
//Es editable el Campo
$mGridTable = "creditos_tipoconvenio";
//Nombre de la tabla
$mGridSQL = "idcreditos_tipoconvenio, descripcion_tipoconvenio, capital_vencido_renovado, capital_vencido_reestructurado, capital_vencido_normal, capital_vigente_renovado, capital_vigente_reestructurado, capital_vigente_normal, interes_vencido_renovado, interes_vencido_reestructurado, interes_vencido_normal, interes_vigente_renovado, interes_vigente_reestructurado, interes_vigente_normal, interes_cobrado, moratorio_cobrado";
$mGridWhere = "";
//layout: [Campo] => Titulo, Editable, Tamaño
$mGridProp = array();
//Obtiene el Grid de la Tabla de general_description
if ($mGridTable != "") {
$xTs = new cTableStructure($mGridTable);
$xAF = explode(",", $mGridSQL);
foreach ($xAF as $key => $value) {
$DField = $xTs->getInfoField(trim($value));
$mGridProp[$DField["campo"]] = $DField["titulo"] . ",true," . $DField["longitud"];
}
unset($xAF, $key, $value);
}
//===========================================================================================================
$_SESSION["grid"]->SetSqlSelect($mGridSQL, $mGridTable, $mGridWhere);
$_SESSION["grid"]->SetUniqueDatabaseColumn($mGridKeyField, $mGridKeyEdit);
$_SESSION["grid"]->SetTitleName($mGridTitulo);
$_SESSION["grid"]->SetEditModeAdd(false);
$_SESSION["grid"]->SetDatabaseColumnEditable("descripcion_tipoconvenio", false);
$_SESSION["grid"]->SetDatabaseColumnName("descripcion_tipoconvenio", "Tipo de Convenio");
//interes_vencido_renovado, interes_vencido_reestructurado, interes_vencido_normal, interes_vigente_renovado, interes_vigente_reestructurado, interes_vigente_normal
$_SESSION["grid"]->SetDatabaseColumnName("interes_cobrado", "Interes Cobrado");
$_SESSION["grid"]->SetDatabaseColumnName("moratorio_cobrado", "Moratorios Cobrados");
$_SESSION["grid"]->SetDatabaseColumnName("capital_vencido_normal", "Capital Vigente");
function compileFromSQL($sql)
{
$arrWithTilde = array("varchar" => "varchar", "date" => "date", "text" => "text", "tinytext" => "tinytext", "enum" => "enum", "blob" => "blob", "string" => "string", "longtext" => "longtext", "datetime" => "datetime", "time" => "time");
$arrTypesPHP = array("enum" => "string", "varchar" => "string", "tinytext" => "string", "float" => "float", "decimal" => "float", "int" => "integer", "integer" => "integer", "text" => "string", "longtext" => "string", "blob" => "string", "tinyint" => "integer", "datetime" => "string", "date" => "string", "time" => "string");
$arrTypesNum = array("float" => "float", "decimal" => "float", "int" => "integer", "integer" => "integer", "tinyint" => "integer");
//$IniMvtos = strpos($texto_contrato, "---");
$this->addCSS("../css/xml.css", "print");
$this->addCSS("../css/xml.css", "screen");
$this->getCampos($sql);
//obtener info del field
foreach ($this->mAFieldN as $clave => $valor) {
//propiedades extras
$mNumFormat = "";
$mAlin = "ALIGN='CENTER'";
$xTInfo = new cTableStructure($this->mAFieldD[$clave]);
$IField = $xTInfo->getInfoField($valor);
$FTipo = strtolower(trim($IField["tipo"]));
$FNombre = $IField["campo"];
if ($arrTypesPHP[$FTipo] == "float") {
$mNumFormat = "NUMBERFORMATEX='2'";
}
if (isset($arrTypesNum[$FTipo])) {
$mAlin = "ALIGN='LEFT'";
}
/**/
$this->mAGrpField[] = "<COL TYPE='FIELD' {$mAlin} CELLCLASS='FIELDS' {$mNumFormat} >" . $this->mAFieldT[$clave] . "</COL>\r\n";
$this->mAGrpTit[] = "<COL ALIGN='CENTER' CELLCLASS='GROUP_HEADER' >" . strtoupper($this->mAFieldT[$clave]) . "</COL>\r\n";
}
}
