}
$tpl->HIDDENS['key'] = $key;
if ($index == 'new') {
foreach ($columns as $k => $v) {
if ($columns[strtoupper($k)]['inputType'] != 'hidden') {
$tpl->columns[strtoupper($k)]['value'] = getInputWidget($k, "", $columns[strtoupper($k)]['inputType']);
}
}
} else {
$sql->readDB($table, "{$key}='{$index}'");
while ($row = $sql->fetchAssoc()) {
$data = $row;
}
foreach ($data as $k => $v) {
if (array_key_exists(strtoupper($k), $tpl->columns)) {
$tpl->columns[strtoupper($k)]['value'] = getInputWidget($k, $v, $columns[strtoupper($k)]['inputType']);
} else {
$tpl->HIDDENS[$k] = $v;
}
}
}
}
if (isset($_REQUEST['grabar'])) {
if (isset($_FILES)) {
foreach ($_FILES as $field => $data) {
$field = str_replace("_file", "", $field);
unset($_REQUEST[$field]);
if (is_array($data['tmp_name'])) {
for ($i = 0; $i < count($data['tmp_name']); $i++) {
$final = $install . "/html/archivos/" . $data['name'][$i];
if ($data['error'][$i] == 0 && move_uploaded_file($data['tmp_name'][$i], $final)) {
}
$tpl->HIDDENS['key'] = $key;
if ($index == 'new') {
foreach ($columns as $k => $v) {
if ($columns[strtoupper($k)]['inputType'] != 'hidden') {
$tpl->columns[strtoupper($k)]['value'] = getInputWidget($k, "", $columns[strtoupper($k)]['inputType'], isset($columns[strtoupper($k)]['required']) ? true : false);
}
}
} else {
$sql->readDB($table, "{$key}='{$index}'");
while ($row = $sql->fetchAssoc()) {
$data = $row;
}
foreach ($data as $k => $v) {
if (array_key_exists(strtoupper($k), $tpl->columns)) {
$tpl->columns[strtoupper($k)]['value'] = getInputWidget($k, $v, $columns[strtoupper($k)]['inputType'], isset($columns[strtoupper($k)]['required']) ? true : false);
} else {
$tpl->HIDDENS[$k] = $v;
}
}
}
}
if (isset($_REQUEST['grabar'])) {
if (isset($_FILES)) {
foreach ($_FILES as $field => $data) {
$field = str_replace("_file", "", $field);
unset($_REQUEST[$field]);
if (is_array($data['tmp_name'])) {
for ($i = 0; $i < count($data['tmp_name']); $i++) {
$final = $install . "/html/archivos/" . $data['name'][$i];
if ($data['error'][$i] == 0 && move_uploaded_file($data['tmp_name'][$i], $final)) {
}
$tpl->HIDDENS['key'] = $key;
if ($index == 'new') {
foreach ($columns as $k => $v) {
if ($columns[$k]['inputType'] != 'hidden') {
$tpl->columns[$k]['value'] = getInputWidget($k, "", $columns[$k]['inputType']);
}
}
} else {
$sql->readDB($table, "{$key}='{$index}'");
while ($row = $sql->fetchAssoc()) {
$data = $row;
}
foreach ($data as $k => $v) {
if (array_key_exists($k, $tpl->columns)) {
$tpl->columns[$k]['value'] = getInputWidget($k, $v, $columns[$k]['inputType']);
} else {
$tpl->HIDDENS[$k] = $v;
}
}
}
}
if (isset($_REQUEST['grabar'])) {
if (isset($_FILES)) {
foreach ($_FILES as $field => $data) {
$field = str_replace("_file", "", $field);
unset($_REQUEST[$field]);
if (is_array($data['tmp_name'])) {
for ($i = 0; $i < count($data['tmp_name']); $i++) {
$final = $install . "/html/archivos/" . $data['name'][$i];
if ($data['error'][$i] == 0 && move_uploaded_file($data['tmp_name'][$i], $final)) {
<?php
$tpl->columns['LOCAL___USU'] = array('desc' => 'Local');
$cursor = $sql->readDB("USUARIO_LOCAL", "USUARIO_ULC='{$index}'");
if ($cursor && $cursor->num_rows > 0) {
if ($row = $cursor->fetch_assoc()) {
$tpl->columns['LOCAL___USU']['value'] = getInputWidget('LOCAL___USU', $row['LOCAL___ULC'], 'dbcombobox[TABLE=LOCAL|LABEL=NOMBRE__LOC|INDEX=CODIGO__LOC]', '', true);
}
} else {
$tpl->columns['LOCAL___USU']['value'] = getInputWidget('LOCAL___USU', '', 'dbcombobox[TABLE=LOCAL|LABEL=NOMBRE__LOC|INDEX=CODIGO__LOC]', '', true);
}
if (isset($_REQUEST['grabar'])) {
$user = $_REQUEST['usernameusu'];
$local = $_REQUEST['local___usu'];
$data = array('LOCAL___ULC' => $local, 'USUARIO_ULC' => $user);
$cursor = $sql->readDB("USUARIO_LOCAL", "USUARIO_ULC='{$user}' AND LOCAL___ULC='{$local}'");
if ($cursor && $cursor->num_rows > 0) {
$sql->updateDB("USUARIO_LOCAL", $data, "USUARIO_ULC='{$user}' AND LOCAL___ULC='{$local}'");
} else {
$sql->addDB("USUARIO_LOCAL", $data);
}
}
