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';