function add_document($tbl, $link, $name_db_new, $name_db_old, $meta_data_tbl)
{
//para normalizar la la columna categoria
$data = search_all($tbl, $link, $name_db_old);
$meta_data_tbl = array_filter($meta_data_tbl);
unset($meta_data_tbl['is_document']);
unset($meta_data_tbl['num_consultas']);
//obtiene columnas
$columnas_new = NULL;
$columnas_old = NULL;
foreach ($meta_data_tbl as $key => $value) {
$columnas_old .= $key . ",";
$columnas_new .= $value . ",";
$fields_for_insert[] = $key;
}
$columnas_old = rtrim($columnas_old, ",");
$columnas_new = rtrim($columnas_new, ",");
$rows = "";
foreach ($data as $keys => $fila) {
$row = null;
foreach ($fila as $cols => $va) {
$isset = in_array($cols, $fields_for_insert);
if ($isset) {
//normaliza datos para tabla
if ($cols == "Producto") {
$tbl = 'producto';
$where = "codigo___prd='Aaro10b'";
$ids = 'id_______prd';
$new_value = search($tbl, $link, $name_db_new, $where, $ids);
//busca categorias
if (isset($new_value[0][$ids])) {
$va = $new_value[0][$ids];
} else {
$va = 0;
//si no lo encuentra, cambia el valor por cero
}
}
$row .= "'" . trim($va) . "',";
}
}
$row = rtrim($row, ',');
$rows .= "(" . $row . "),";
}
$rows = rtrim($rows, ',');
$tbl = 'documento';
print_r(insert($link, $name_db_new, $tbl, $columnas_new, $rows));
}
function add_document($tbl, $link, $name_db_new, $name_db_old, $meta_data_tbl)
{
$data = search_all($tbl, $link, $name_db_old);
$meta_data_tbl = array_filter($meta_data_tbl);
$fields_documento = $meta_data_tbl['is_document'];
$cantidad = ceil(row_count($tbl, $link, $name_db_old) / $fields_documento['num_consultas']);
unset($meta_data_tbl['is_document']);
unset($meta_data_tbl['num_consultas']);
$offsets = 0;
for ($i = 0; $i < $fields_documento['num_consultas']; $i++) {
$datos = search_limit($tbl, $link, $name_db_old, $where, $offsets, $cantidad);
//foreach sobre datos
$rows = "";
foreach ($data as $keys => $fila) {
$row = null;
//foreach sobre columnas
$columnas_new = null;
foreach ($fila as $cols => $va) {
$isset = in_array($cols, array_keys($fields_documento));
//obtiene campos que se deben ingresar en documentos
if ($isset) {
$columnas_new .= $fields_documento[$cols] . ",";
//normaliza datos para tabla
if ($cols == "Producto") {
//si la columna es Producto cambia los id (relaciones)
$tbl = 'producto';
$where = "codigo___prd='{$va}'";
$ids = 'id_______prd';
$new_value = search($tbl, $link, $name_db_new, $where, $ids);
//busca categorias
if (isset($new_value[0][$ids])) {
$va = $new_value[0][$ids];
} else {
$va = 0;
//si no lo encuentra, cambia el valor por cero
}
}
$row .= "'" . trim($va) . "',";
}
}
$row = rtrim($row, ',');
$rows .= "(" . $row . "),";
}
$rows = rtrim($rows, ',');
$columnas_new = rtrim($columnas_new, ',');
print_r($rows);
$tbl = 'documento';
//cambia la tabla para realizar la inserción
print_r(insert($link, $name_db_new, $tbl, $columnas_new, $rows));
$offsets = $offsets + $cantidad;
//paginador de registros
}
//obtiene columnas
$columnas_new = NULL;
$columnas_old = NULL;
foreach ($meta_data_tbl as $key => $value) {
$columnas_old .= $key . ",";
$columnas_new .= $value . ",";
$fields_for_insert[] = $key;
}
$columnas_old = rtrim($columnas_old, ",");
$columnas_new = rtrim($columnas_new, ",");
}
$size = floor($aval_width / $colombs);
$cfg['menu'] = 'Library';
$action = get('action');
$search_string = get('search_string');
$group_found = 'none';
$match_found = false;
if (strlen($search_string) == 0) {
message(__FILE__, __LINE__, 'warning', '[b]Empty search string[/b][br]Enter valid string.');
exit;
}
if (strlen($search_string) < 2) {
message(__FILE__, __LINE__, 'warning', '[b]Search string too short - min. 2 characters[/b][br][url=index.php][img]small_back.png[/img]Back to previous page[/url]');
exit;
}
if ($action == 'search_all') {
search_all();
} else {
message(__FILE__, __LINE__, 'error', '[b]Unsupported input value for[/b][br]action');
}
exit;
// +------------------------------------------------------------------------+
// | Search all |
// +------------------------------------------------------------------------+
function search_all()
{
global $cfg, $db, $size, $search_string, $group_found, $match_found;
authenticate('access_media');
// formattedNavigator
$nav = array();
$nav['name'][] = 'Library';
$nav['url'][] = 'index.php';
