function initPorTabla($tabla) { $res = array(); $xTa = new cSAFETabla($tabla); if ($xTa->obj() != null) { $this->mValorEtiqueta = $xTa->getCampoDescripcion(); $this->mClavePrimaria = $xTa->getClaveUnica(); $this->mTabla = $tabla; if ($this->mValorEtiqueta != "") { $res = $this->get($this->mClavePrimaria, $this->mValorEtiqueta, $this->mTabla); } } return $res; }
if ($tabla != false) { $xObj = new cSAFETabla($tabla); if ($xObj->obj() == null) { $rs[MSG_NO_PARAM_VALID] = "ERROR\t para la Tabla {$tabla} y clave {$clave}\r\n"; } else { $obj = $xObj->obj(); if ($action == SYS_NINGUNO) { if ($clave != false) { $obj->setData($obj->query()->initByID($clave)); } $rs = $obj->query()->getCampos(); $cadena = json_encode($rs); } else { //$obj = new cSocios_aeconomica(); $indice = $obj->getKey(); $etiq = $xObj->getCampoDescripcion(); if ($etiq == "") { $campos = $obj->query()->getCampos(); $cnt = 0; foreach ($campos as $props) { $etiq = $cnt == 1 ? $props["N"] : $etiq; $cnt++; } } $sql = "SELECT `{$tabla}`.`{$indice}` AS `indice`, `{$tabla}`.`{$etiq}` AS `etiqueta` FROM {$tabla} WHERE (`{$tabla}`.`{$indice}` LIKE '%{$clave}%' OR `{$tabla}`.`{$etiq}` LIKE '%{$clave}%' ) LIMIT 0,100"; //setLog($sql); $xSVC = new MQLService($action, $sql); $cadena = $xSVC->getJSON($out); } } }