EVOLUTION-MANAGER
Edit File: catalogo.equivalencias.grid.php
<?php /** * @author Balam Gonzalez Luis Humberto * @version 1.0 * @package */ //===================================================================================================== include_once("../core/go.login.inc.php"); include_once("../core/core.error.inc.php"); include_once("../core/core.html.inc.php"); include_once("../core/core.init.inc.php"); include_once("../core/core.db.inc.php"); $theFile = __FILE__; $permiso = getSIPAKALPermissions($theFile); if($permiso === false){ header ("location:../404.php?i=999"); } $_SESSION["current_file"] = addslashes( $theFile ); //===================================================================================================== $xHP = new cHPage("TR.Catalogo de Denominaciones en Moneda", HP_GRID); $xF = new cFecha(); $xTabla = new cTesoreria_tipos_de_denominaciones(); $filtro1 = ""; $filtro2 = ""; $xHP->setNoDefaultCSS(); echo $xHP->getHeader(true); //HTML Object END echo '<body onmouseup="SetMouseDown(false);" ><div id="onGrid">'; //Define your grid $_SESSION["grid"]->SetDatabaseConnection(MY_DB_IN, USR_DB, PWD_DB); //Propiedades del GRID $mGridTitulo = $xHP->getTitle(); $mGridKeyField = $xTabla->getKey(); //Nombre del Campo Unico $mGridKeyEdit = true; //Es editable el Campo $mGridTable = $xTabla->get(); //Nombre de la tabla $mGridSQL = $xTabla->query()->getListaDeCampos();// "*"; //$xTabla->query()->getCampos(); $mGridWhere = ""; $mGridProp = array( "denominacion" => "Denominacion,true,80", "nombre" => "Nombre,true,300", "valor_contra_uno" => "Valor contra uno,true,120", "tipo_de_valor" => "Tipo de valor,true,120" ); //=========================================================================================================== $_SESSION["grid"]->SetSqlSelect($mGridSQL, $mGridTable, $mGridWhere); $_SESSION["grid"]->SetUniqueDatabaseColumn($mGridKeyField, $mGridKeyEdit); $_SESSION["grid"]->SetTitleName($mGridTitulo); $_SESSION["grid"]->SetEditModeAdd(true); //$_SESSION["grid"]->SetEditModeDelete(false); //=========================================================================================================== foreach ($mGridProp as $key => $value) { $mVals = explode(",", $value, 10); if ( isset($mVals[0]) ) { $_SESSION["grid"]->SetDatabaseColumnName($key, $mVals[0]); } if ( isset($mVals[1]) ) { $_SESSION["grid"]->SetDatabaseColumnEditable($key, $mVals[1]); } if ( isset($mVals[2]) ) { $_SESSION["grid"]->SetDatabaseColumnWidth($key, $mVals[2]); } } //=========================================================================================================== $_SESSION["grid"]->SetMaxRowsEachPage(25); $_SESSION["grid"]->PrintGrid(MODE_EDIT); echo $xHP->end(); ?>