$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