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);
    }
}
Beispiel #3
0
$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);
 }