$clave = parametro("id", null, MQL_INT); $xSel = new cHSelect(); if ($clave == null) { $step = MQL_ADD; $clave = $xTabla->query()->getLastID() + 1; } else { $step = MQL_MOD; if ($clave != null) { $xTabla->setData($xTabla->query()->initByID($clave)); } } $xFRM = new cHForm("frmaml_risk_catalog", "catalogo.riesgos.editar.frm.php?action={$step}"); $xFRM->addSubmit(); if ($action == MQL_ADD) { //Agregar $clave = parametro($xTabla->getKey(), null, MQL_INT); if ($clave != null) { $xTabla->setData($xTabla->query()->initByID($clave)); $xTabla->setData($_REQUEST); $xTabla->query()->insert()->save(); $xFRM->addAvisoRegistroOK(); } } else { if ($action == MQL_MOD) { //Modificar //iniciar $clave = parametro($xTabla->getKey(), null, MQL_INT); if ($clave != null) { $xTabla->setData($xTabla->query()->initByID($clave)); $xTabla->setData($_REQUEST); $xTabla->query()->update()->save($clave);
$_SESSION["current_file"] = addslashes($theFile); //===================================================================================================== $xHP = new cHPage("TR.Catalogo de Riesgos", HP_GRID); $xF = new cFecha(); $xTabla = new cAml_risk_catalog(); $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("clave_de_control" => "Clave,true,11", "descripcion" => "descripcion,true,150", "tipo_de_riesgo" => "tipo,true,11", "valor_ponderado" => "valor,true,37", "unidades_ponderadas" => "unidades,true,37", "unidad_de_medida" => "medida,true,10", "forma_de_reportar" => "Reporte,false,4", "frecuencia_de_chequeo" => "chequeo,false,4"); $mGridSQL = "clave_de_control,descripcion,tipo_de_riesgo,valor_ponderado,unidades_ponderadas,unidad_de_medida,forma_de_reportar,frecuencia_de_chequeo"; //=========================================================================================================== $_SESSION["grid"]->SetSqlSelect($mGridSQL, $mGridTable, $mGridWhere); $_SESSION["grid"]->SetUniqueDatabaseColumn($mGridKeyField, $mGridKeyEdit); $_SESSION["grid"]->SetTitleName($mGridTitulo); $_SESSION["grid"]->SetEditModeAdd(false);