nuBuilder Forum

Code: Select all

  const inputTypes = [
    ["-1", "(Blanks)"],
    ["nuDate", "nuDate"],
    ["nuNumber", "nuNumber"],
    ["nuScroll", "nuScroll"],
    ["nuAutoNumber", "nuAutoNumber"];

Code: Select all

WHERE sob_input_type = '#nu5bad6cb377a01b0_filter#'
      OR left('#nu5bad6cb377a01b0_filter#', 1) IN ('#', '')
      OR (sob_input_type = '' AND '#nu5bad6cb377a01b0_filter#' = '-1')

Code: Select all

WHERE sob_input_type = '#nu5bad6cb377a01b0_filter#'
   OR LEFT('#nu5bad6cb377a01b0_filter#', 1) IN ('#', '')
   OR (sob_input_type = '' AND '#nu5bad6cb377a01b0_filter#' = '-1')

Code: Select all

sob_input_type = '#nu5bad6cb377a01b0_filter#'

Code: Select all

LEFT('#nu5bad6cb377a01b0_filter#', 1) IN ('#', '')

Code: Select all

sob_input_type = '' 
AND '#nu5bad6cb377a01b0_filter#' = '-1'

Code: Select all

WHERE
(
        (rend_ertekesitokod = '#66192bd91eefa91_filter#' OR LEFT('#66192bd91eefa91_filter#',1) IN ('#','') OR LOCATE(rend_ertekesitokod, '#66192bd91eefa91_filter#') > 0 )
        AND
        (rend_options = '#66192bd91f60507_filter#' OR LEFT('#66192bd91f60507_filter#',1) IN ('#','') OR LOCATE(rend_options, '#66192bd91f60507_filter#') > 0 )
        AND
        (rend_stat = '#66192bd91fc3266_filter#' OR LEFT('#66192bd91fc3266_filter#',1) IN ('#','') OR LOCATE(rend_stat, '#66192bd91fc3266_filter#') > 0 )
)

Code: Select all

nuAddBrowseFilter('66192bd91eefa91').nuSearchableMultiPopup({ items: getKER() });
nuAddBrowseFilter('66192bd91f60507').nuSearchableMultiPopup({ items: getOPTIONS() });
nuAddBrowseFilter('66192bd91fc3266').nuSearchableMultiPopup({ items: getSTATUSZ() }); 

Code: Select all

$sqlKER = function() use ($getDistinctrendelesekColumnQuery) {
  return $getDistinctrendelesekColumnQuery('rend_ertekesitokod');
};
$sqlOPTIONS = function() use ($getDistinctrendelesekColumnQuery) {
  return $getDistinctrendelesekColumnQuery('rend_options');
};
$sqlSTATUSZ = function() use ($getDistinctrendelesekColumnQuery) {
  return $getDistinctrendelesekColumnQuery('rend_stat');
};

$KER = nuEncodeQueryRowResults($sqlKER(), [], ['']);
$OPTIONS = nuEncodeQueryRowResults($sqlOPTIONS(), [], ['']);
$STATUSZ = nuEncodeQueryRowResults($sqlSTATUSZ(), [], ['']);

$filterJS = "
  function getData(data) {
    return JSON.parse(atob(data));
  }
  function getKER() {
    return getData('$KER');
  }
  function getOPTIONS() {
    return getData('$OPTIONS');
  }
  function getSTATUSZ() {
    return getData('$STATUSZ');
  }

Code: Select all

$getDistinctrendelesekColumnQuery = function($column) {
  return "SELECT DISTINCT `$column` FROM `rendelesek` WHERE IFNULL(`$column`,'') <> '' ORDER BY `$column`";
};

Code: Select all

    ((sus_language = '#nu5bad6cb3746cc1b_filter#' OR LEFT('#nu5bad6cb3746cc1b_filter#',1) IN ('#','')) OR (IFNULL(sus_language,'') = ''  AND '#nu5bad6cb3746cc1b_filter#' = '-1'))

Code: Select all

$getDistinctrendelesekColumnQuery = function($column) {
  return "
    SELECT DISTINCT
      CASE
        WHEN `$column` = '-1' OR IFNULL(TRIM(`$column`),'') = '' THEN '[Üres]'
        ELSE `$column`
      END AS `$column`
    FROM `rendelesek`
    ORDER BY (`$column` = '[Üres]') ASC, `$column`
  ";
};

Code: Select all

((rend_rendelesi = '#66192bd91f0b02f_filter#' OR LEFT('#66192bd91f0b02f_filter#',1) IN ('#','')) OR ((IFNULL(rend_rendelesi,'') = '' OR rend_rendelesi = '-1') AND '#66192bd91f0b02f_filter#' = '-1') OR LOCATE(rend_rendelesi, '#66192bd91f0b02f_filter#') > 0 )