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);
}
