$value) { if (!empty($value)) { if (preg_match("/_ID$/", $key)) { if (preg_match("/NOT_/", $key)) { $key = explode("NOT_", $key); $key = $key[0].$key[1]; $sql.= "AND ".$key." != '".addslashes($value)."' "; } else { $sql.= "AND ".$key." = '".addslashes($value)."' "; } } else { if (preg_match("/EXACT_/", $key)) { $key = explode("EXACT_", $key); $key = $key[0].$key[1]; $sql.= "AND ".$key." = '".addslashes($value)."' "; } else { $sql.= "AND ".$key." LIKE '%".addslashes($value)."%' "; } } } } } $sql.= "GROUP BY t_categories.CATEGORY_ID "; if ($order_element) { $sql.= "ORDER BY ".$order_element." ".$order_order." "; } else { $sql.= "ORDER BY t_categories.CATEGORY_name ASC "; } $sql.= "LIMIT ".$index_element.", ".$show_elements." "; // echo "
".$sql."
"; $datos_results = LIB_db_generic_query($sql, $connection); //print_r($datos_results); // generamos los datos validos $results = MOD_CATEGORIES_get_categories_results($datos_results, $destiny); return $results; } // contabiliza el total de resultados de una busqueda function MOD_CATEGORIES_search_total_categories ($search_criteria=false, $destiny=false, $forceDB=false) { global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config; $connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"]; $sql = "SELECT COUNT(DISTINCT(t_categories.CATEGORY_ID)) ". "FROM t_categories ". "WHERE t_categories.CATEGORY_options_erased=0 "; if (is_array($search_criteria)) { foreach ($search_criteria as $key=>$value) { if (!empty($value)) { if (preg_match("/_ID$/", $key)) { if (preg_match("/NOT_/", $key)) { $key = explode("NOT_", $key); $key = $key[0].$key[1]; $sql.= "AND ".$key." != '".addslashes($value)."' "; } else { $sql.= "AND ".$key." = '".addslashes($value)."' "; } } else { if (preg_match("/EXACT_/", $key)) { $key = explode("EXACT_", $key); $key = $key[0].$key[1]; $sql.= "AND ".$key." = '".addslashes($value)."' "; } else { $sql.= "AND ".$key." LIKE '%".addslashes($value)."%' "; } } } } } // echo $sql; $datos_results = LIB_db_generic_query($sql, $connection); return $datos_results[0][0]; } // muestrea los resultados de una busqueda function MOD_CATEGORIES_get_categories_results ($complete_results, $destino='') { global $GLOBAL_config, $MOD_CATEGORIES_config, $search_criteria; if (is_array($complete_results)) { foreach($complete_results as $key=>$result) { switch ($destino) { case "load": default: $final_results[$key]["CATEGORY_ID"] = $result["CATEGORY_ID"]; $final_results[$key]["CATEGORY_name"] = htmlentities($result["CATEGORY_name"]); $final_results[$key]["CATEGORY_tag_search"] = htmlentities($result["CATEGORY_tag_search"]); break; } } } else { $final_results[0]["CATEGORY_ID"] = ""; $final_results[0]["CATEGORY_name"] = ""; $final_results[$key]["CATEGORY_tag_search"] = ""; } return $final_results; } // Función para generar un SELECT con las categorieas function MOD_CATEGORIES_generate_categories_select ($selected=false, $selected_action="add_selecteds") { global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config; $connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"]; $elements = LIB_db_select_query("CATEGORY_ID, CATEGORY_name", "t_categories", $connection, "CATEGORY_options_erased=0 ORDER BY CATEGORY_name "); $html = ""; if (!is_array($selected)) { $selected = explode(";", $selected); } if (is_array($elements)) { foreach ($elements as $value) { // Si ESTE elemento NO ESTÁ en los elementos pasados como parámetro, lo incluimos en el listado switch ($selected_action) { case "add_selecteds": $html.= ""; } return $html; } ?>
Fatal error: Call to undefined function MOD_CATEGORIES_search_total_categories() in /var/www/vhosts/vintagewatchparts.com/httpdocs/index.php on line 11