public static function actualizarRegistros($tabla) { $estructura = ExtraParamsEstructuraDAO::search(new ExtraParamsEstructura(array("tabla" => $tabla))); $usuarios = UsuarioDAO::getAll(); for ($i = 0; $i < sizeof($usuarios); $i++) { $valores = self::getVals($tabla, $usuarios[$i]->getIdUsuario()); for ($e = 0; $e < sizeof($estructura); $e++) { $found = false; for ($v = 0; $v < sizeof($valores); $v++) { if ($valores[$v]["campo"] == $estructura[$e]->getCampo()) { $found = true; } } if (!$found) { $toInsert = new ExtraParamsValores(); $toInsert->setIdExtraParamsEstructura($estructura[$e]->getIdExtraParamsEstructura()); $toInsert->setIdPkTabla($usuarios[$i]->getIdUsuario()); $toInsert->setVal(null); ExtraParamsValoresDAO::save($toInsert); } } } }
require_once "../../../server/bootstrap.php"; $page = new GerenciaComponentPage(); // Validar parametro de base $DocumentoBase = DocumentoBaseDAO::getByPK($_GET["base"]); if (is_null($DocumentoBase)) { $page->render(); exit; } else { if ($DocumentoBase->GetActivo() == false) { $page->render(); exit; } } $page->addComponent(new TitleComponent("Nuevo " . $DocumentoBase->getNombre(), 1)); //Buscar sus parametros extra $ExtraParamsStructs = ExtraParamsEstructuraDAO::search(new ExtraParamsEstructura(array("tabla" => "documento_base-" . $DocumentoBase->getIdDocumentoBase()))); $f = new FormComponent(); $f->addApiCall("api/documento/nuevo"); for ($i = 0; $i < sizeof($ExtraParamsStructs); $i++) { // function addField($id, $caption, $type, $value = "", $name = null) { if ($ExtraParamsStructs[$i]->tipo == "enum") { $enum_string = explode(",", $ExtraParamsStructs[$i]->enum); $enum_array = array(); for ($k = 0; $k < count($enum_string); $k++) { array_push($enum_array, array("caption" => $enum_string[$k], "id" => $enum_string[$k], "selected" => 0)); } $f->addField($ExtraParamsStructs[$i]->campo, $ExtraParamsStructs[$i]->caption, $ExtraParamsStructs[$i]->tipo, $enum_array); } else { $f->addField($ExtraParamsStructs[$i]->campo, $ExtraParamsStructs[$i]->caption, $ExtraParamsStructs[$i]->tipo); } }
$tabla->addColRender("id_extra_params_estructura", "smenu"); $page->addComponent($tabla); $page->addComponent(new TitleComponent("Nueva columna", 3)); $nceObj = new ExtraParamsEstructura(); $nceObj->setTabla("\"clientes\""); $nuevaColumnaForm = new DAOFormComponent($nceObj); $nuevaColumnaForm->addApiCall("api/pos/bd/columna/nueva", "POST"); $nuevaColumnaForm->makeObligatory(array("campo", "tipo", "longitud", "olbigatorio", "obligatorio", "caption")); $nuevaColumnaForm->hideField(array("id_extra_params_estructura", "tabla")); $nuevaColumnaForm->sendHidden("tabla"); $nuevaColumnaForm->setType("descripcion", "textarea"); $nuevaColumnaForm->createComboBoxJoin("tipo", null, array("string", "int", "float", "date", "bool")); $nuevaColumnaForm->createComboBoxJoin("obligatorio", null, array("Si", "No")); $page->addComponent($nuevaColumnaForm); $q = new ExtraParamsEstructura(array("tabla" => "clientes")); $qr = ExtraParamsEstructuraDAO::search($q); for ($i = 0; $i < sizeof($qr); $i++) { unset($qr[$i]->id_extra_params_estructura); } $export_json = json_encode($qr); $page->addComponent(' <script> function exportar(){ var form = Ext.widget(\'form\', { layout: { type: \'vbox\', align: \'stretch\' }, border: false, bodyPadding: 10,
public function testCredenciales_Sapuraiya() { $res = ExtraParamsEstructuraDAO::search(new ExtraParamsEstructura(array("tabla" => "usuarios", "campo" => "Agenda"))); if (count($res) <= 0) { return; } $u = UsuarioDAO::getAll(); $o = "Empresa | Credenciales restantes | Numero de credenciales\n"; foreach ($u as $user) { $out = ExtraParamsValoresDAO::getVals("usuarios", $user->getIdUsuario()); $cr = $out[4]["val"]; $nc = $out[8]["val"]; if (strlen($nc > 1)) { $tipo_creden = substr($nc, 1, 1); switch ($tipo_creden) { case 'a': $nc = str_replace('a', " Proveedor", $nc); break; case 'b': $nc = str_replace('b', " Expositor", $nc); break; case 'c': $nc = str_replace('c', " Expositor/Proveedor", $nc); break; case 'd': $nc = str_replace('d', " Empresa Tractora", $nc); break; } } Logger::log("Credenciales restantes: " . $cr); Logger::log("Num credenciales: " . $nc); $o .= $user->getNombre() . " | " . $cr . " | " . $nc . "\n"; } $fp = fopen('credenciales.txt', 'w'); fwrite($fp, $o); fclose($fp); }